DBA Data[Home] [Help]

APPS.PON_SGD_PKG dependencies on FND_MESSAGE

Line 501: SELECT nvl(fnd_message.get_string('PON', c.label_message_code),d.column_name) label_message_code,

497: XMLElement("mod_value", diff.mod_value_desc) ))) finalXML
498: INTO l_finalXML
499: FROM
500: (
501: SELECT nvl(fnd_message.get_string('PON', c.label_message_code),d.column_name) label_message_code,
502: c.disp_data_type,
503: c.sub_entity_name,
504: d.orig_value,
505: d.mod_value,

Line 572: nvl(fnd_message.get_string('PON', min(c.label_message_code)),d.column_name) label_message_code,

568: --cursor which gets the rollup change by grouping rows in po_entity_rollup_gt table
569: CURSOR c_rollup_changes IS
570: SELECT d.mod_doc_source_name,
571: d.column_name,
572: nvl(fnd_message.get_string('PON', min(c.label_message_code)),d.column_name) label_message_code,
573: d.orig_value,
574: d.mod_value,
575: decode(min(c.disp_data_type), 'N', nvl2(d.orig_value, d.orig_value, 0),
576: 'M', nvl2(d.orig_value, d.orig_value, 0),

Line 683: XMLElement("printable_pks", fnd_message.get_string('PON', 'PON_FED_AMEND_LINE_TITLE_MSG') || ' ' || rollup_pk )))

679: XMLElement("orig_id", r_change.orig_value),
680: XMLElement("mod_id", r_change.mod_value),
681: XMLElement("orig_value", r_change.orig_value_desc),
682: XMLElement("mod_value", r_change.mod_value_desc),
683: XMLElement("printable_pks", fnd_message.get_string('PON', 'PON_FED_AMEND_LINE_TITLE_MSG') || ' ' || rollup_pk )))
684: INTO l_finalXML from dual;
685: END LOOP;
686: ELSE
687: --if document_type or entity_name is not passed, then we have to pass empty xml instead of null