Issue #24315:translatable error messages

diff --git a/foundation-database/public/functions/convertquote.sql b/foundation-database/public/functions/convertquote.sql
index 008d093..85b97d5 100644 (file)
--- a/foundation-database/public/functions/convertquote.sql
+++ b/foundation-database/public/functions/convertquote.sql
@@ -70,7 +70,8 @@ BEGIN
     WHERE (quhead_id=pQuheadid)
       AND (COALESCE(quhead_custponumber, '') = '');
     IF (FOUND) THEN
-      RAISE EXCEPTION 'Customer PO required for Quote %', _qunumber;
+      RAISE EXCEPTION 'Customer PO required for Quote % [xtuple: convertQuote, -7, %]',
+                      _qunumber, _qunumber;
     END IF;
   END IF;
   
@@ -80,7 +81,9 @@ BEGIN
                                  (UPPER(cohead_custponumber)=UPPER(quhead_custponumber)) )
     WHERE (quhead_id=pQuheadid);
     IF (FOUND) THEN
-      RAISE EXCEPTION 'Duplicate Customer PO % for Quote %', _ponumber, _qunumber;
+      RAISE EXCEPTION 'Duplicate Customer PO % for Quote % [xtuple: convertQuote, -8, %, %]',
+                      _ponumber, _qunumber,
+                      _ponumber, _qunumber;
     END IF;
   END IF;
   

diff --git a/foundation-database/public/functions/convertquotetoinvoice.sql b/foundation-database/public/functions/convertquotetoinvoice.sql
index 938ae18..b64426d 100644 (file)
--- a/foundation-database/public/functions/convertquotetoinvoice.sql
+++ b/foundation-database/public/functions/convertquotetoinvoice.sql
@@ -76,7 +76,8 @@ BEGIN
     WHERE (quhead_id=pQuheadid)
       AND (COALESCE(quhead_custponumber, '') = '');
     IF (FOUND) THEN
-      RAISE EXCEPTION 'Customer PO required for Quote %', _qunumber;
+      RAISE EXCEPTION 'Customer PO required for Quote % [xtuple: convertQuote, -7, %]',
+                      _qunumber, _qunumber;
     END IF;
   END IF;
   
@@ -86,7 +87,9 @@ BEGIN
                                    (UPPER(invchead_ponumber)=UPPER(quhead_custponumber)) )
     WHERE (quhead_id=pQuheadid);
     IF (FOUND) THEN
-      RAISE EXCEPTION 'Duplicate Customer PO % for Quote %', _ponumber, _qunumber;
+      RAISE EXCEPTION 'Duplicate Customer PO % for Quote % [xtuple: convertQuote, -8, %, %]',
+                      _ponumber, _qunumber,
+                      _ponumber, _qunumber;
     END IF;
   END IF;