eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on FND_MESSAGE

Line 321: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)

317: , last_update_date
318: , last_update_login
319: )
320: VALUES ( 'AWARDBID'
321: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
322: , 'PON_AUC_BID_NUMBER_INVALID' || l_suffix
323: , s_bid_number
324: , 'PON_AWARD_ITEMS_INTERFACE'
325: , s_batch_id

Line 364: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)

360: , last_update_date
361: , last_update_login
362: )
363: VALUES ( 'AWARDBID'
364: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
365: , 'PON_AUC_ITEM_AWARDED'
366: , 'PON_AWARD_ITEMS_INTERFACE'
367: , s_batch_id
368: , s_worksheet_name

Line 407: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)

403: , last_update_date
404: , last_update_login
405: )
406: VALUES ( 'AWARDBID'
407: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
408: , 'PON_AWARD_EXCLUDE_SHLIST_ERR' || l_suffix
409: , s_bid_number
410: , 'PON_AWARD_ITEMS_INTERFACE'
411: , s_batch_id

Line 451: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)

447: , last_update_date
448: , last_update_login
449: )
450: VALUES ( 'AWARDBID'
451: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
452: , 'PON_AWARD_BID_NOT_ACTIVE' || l_suffix
453: , s_bid_number
454: , 'PON_AWARD_ITEMS_INTERFACE'
455: , s_batch_id

Line 495: , decode(p_spreadsheet_type, PON_AWARD_PKG.g_xml_upload_mode, fnd_message.get_string('PON','PON_ACCTS_SUPPLIER'), fnd_message.get_string('PON','PON_BIDS_BIDDER' || l_suffix))

491: , last_update_date
492: , last_update_login
493: )
494: VALUES ( 'AWARDBID'
495: , decode(p_spreadsheet_type, PON_AWARD_PKG.g_xml_upload_mode, fnd_message.get_string('PON','PON_ACCTS_SUPPLIER'), fnd_message.get_string('PON','PON_BIDS_BIDDER' || l_suffix))
496: , 'PON_AWARD_INACTIVE_SUPPLIER'
497: , s_trading_partner_name
498: , 'PON_AWARD_ITEMS_INTERFACE'
499: , s_batch_id

Line 538: , decode(l_contract_type, 'STANDARD', fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY'), fnd_message.get_string('PON','PON_AUCTS_AGREED_QUANTITY'))

534: , last_update_date
535: , last_update_login
536: )
537: VALUES ( 'AWARDBID'
538: , decode(l_contract_type, 'STANDARD', fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY'), fnd_message.get_string('PON','PON_AUCTS_AGREED_QUANTITY'))
539: , decode(l_contract_type, 'STANDARD', 'PON_AUC_AWARD_QTY_COL_NEG', 'PON_AUC_QTY_AGREED_COL_NEG')
540: , s_award_quantity
541: , 'NUM'
542: , 'PON_AWARD_ITEMS_INTERFACE'

Line 584: , fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY')

580: , last_update_date
581: , last_update_login
582: )
583: VALUES ( 'AWARDBID'
584: , fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY')
585: , 'PON_AUCTS_MUST_AWARD'
586: , 'PON_AWARD_ITEMS_INTERFACE'
587: , s_batch_id
588: , s_worksheet_name

Line 633: , fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY')

629: , TOKEN1_NAME
630: , TOKEN1_VALUE
631: )
632: VALUES ( 'AWARDBID'
633: , fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY')
634: , 'PON_QUANTITY_TIER_VIOLATION' || l_suffix
635: , 'PON_AWARD_ITEMS_INTERFACE'
636: , s_award_quantity
637: , s_batch_id

Line 707: , fnd_message.get_string('PON','PON_AUC_LINE_TYPE')

703: , TOKEN1_VALUE
704: )
705: SELECT
706: 'AWARDBID'
707: , fnd_message.get_string('PON','PON_AUC_LINE_TYPE')
708: , 'PON_AWARD_FIXED_PRICE'|| l_suffix
709: , pltt.line_type
710: , 'PON_AWARD_ITEMS_INTERFACE'
711: , paii.BATCH_ID

Line 804: interface_type, fnd_message.get_string('PON','PON_AUC_LINE_TYPE'), 'PON_ITEM_PRICES_INTERFACE', -- 1

800: last_update_date, last_update_login -- 6
801: )
802: VALUES
803: (
804: interface_type, fnd_message.get_string('PON','PON_AUC_LINE_TYPE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
805: line_type, 'PON_INVALID_STYLE_LINETYPE', batch_id, -- 2
806: interface_line_id, auction_header_id, s_line_number, -- 3
807: NULL, NULL, l_exp_date, -- 4
808: l_userid, SYSDATE, l_userid, -- 5

Line 845: interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1

841: last_update_date, last_update_login -- 6
842: )
843: VALUES
844: (
845: interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
846: retainage_rate_percent, 'PON_RTNG_RATE_WRONG', batch_id, -- 2
847: interface_line_id, auction_header_id, s_line_number, -- 3
848: NULL, NULL, l_exp_date, -- 4
849: l_userid, SYSDATE, l_userid, -- 5

Line 866: interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_ITEM_PRICES_INTERFACE', -- 1

862: last_update_date, last_update_login -- 6
863: )
864: VALUES
865: (
866: interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_ITEM_PRICES_INTERFACE', -- 1
867: max_retainage_amount , 'PON_MAX_RTNG_WRONG', batch_id, -- 2
868: interface_line_id, auction_header_id, s_line_number, -- 3
869: NULL, NULL, l_exp_date, -- 4
870: l_userid, SYSDATE, l_userid, -- 5

Line 887: interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_ITEM_PRICES_INTERFACE', -- 1

883: last_update_date, last_update_login -- 6
884: )
885: VALUES
886: (
887: interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_ITEM_PRICES_INTERFACE', -- 1
888: advance_amount, 'PON_ADV_AMT_WRONG', batch_id, -- 2
889: interface_line_id, auction_header_id, s_line_number, -- 3
890: NULL, NULL, l_exp_date, -- 4
891: l_userid, SYSDATE, l_userid, -- 5

Line 908: interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1

904: last_update_date, last_update_login -- 6
905: )
906: VALUES
907: (
908: interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
909: progress_pymt_rate_percent, 'PON_PROG_PYMT_RATE_WRONG', batch_id, -- 2
910: interface_line_id, auction_header_id, s_line_number, -- 3
911: NULL, NULL, l_exp_date, -- 4
912: l_userid, SYSDATE, l_userid, -- 5

Line 928: interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1

924: last_update_date, last_update_login -- 6
925: )
926: VALUES
927: (
928: interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
929: recoupment_rate_percent, 'PON_RECOUP_RATE_WRONG', batch_id, -- 2
930: interface_line_id, auction_header_id, s_line_number, -- 3
931: NULL, NULL, l_exp_date, -- 4
932: l_userid, SYSDATE, l_userid, -- 5

Line 949: interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1

945: last_update_date, last_update_login -- 6
946: )
947: VALUES
948: (
949: interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
950: progress_pymt_rate_percent, 'PON_FIELD_MUST_BE_ENTERED', batch_id, -- 2
951: interface_line_id, auction_header_id, s_line_number, -- 3
952: NULL, NULL, l_exp_date, -- 4
953: l_userid, SYSDATE, l_userid, -- 5

Line 973: interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1

969: last_update_date, last_update_login -- 6
970: )
971: VALUES
972: (
973: interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
974: recoupment_rate_percent, 'PON_RECUP_NEEDED_WITH_PPRATE', batch_id, -- 2
975: interface_line_id, auction_header_id, s_line_number, -- 3
976: NULL, NULL, l_exp_date, -- 4
977: l_userid, SYSDATE, l_userid, -- 5

Line 995: interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1

991: last_update_date, last_update_login -- 6
992: )
993: VALUES
994: (
995: interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
996: recoupment_rate_percent, 'PON_RECUP_NEEDED_WITH_ADVAMT', batch_id, -- 2
997: interface_line_id, auction_header_id, s_line_number, -- 3
998: NULL, NULL, l_exp_date, -- 4
999: l_userid, SYSDATE, l_userid, -- 5

Line 1017: interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_ITEM_PRICES_INTERFACE', -- 1

1013: last_update_date, last_update_login -- 6
1014: )
1015: VALUES
1016: (
1017: interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1018: advance_amount, 'PON_ADV_AMT_MORE', batch_id, -- 2
1019: interface_line_id, auction_header_id, s_line_number, -- 3
1020: NULL, NULL, l_exp_date, -- 4
1021: l_userid, SYSDATE, l_userid, -- 5

Line 1040: interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1

1036: last_update_date, last_update_login -- 6
1037: )
1038: VALUES
1039: (
1040: interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1041: recoupment_rate_percent, 'PON_RECOUP_LESS_THAN_ADV', batch_id, -- 2
1042: interface_line_id, auction_header_id, s_line_number, -- 3
1043: NULL, NULL, l_exp_date, -- 4
1044: l_userid, SYSDATE, l_userid, -- 5

Line 1065: interface_type, fnd_message.get_string('PON','PON_AUC_LINE_TYPE'), 'PON_ITEM_PRICES_INTERFACE', -- 1

1061: last_update_date, last_update_login -- 6
1062: )
1063: VALUES
1064: (
1065: interface_type, fnd_message.get_string('PON','PON_AUC_LINE_TYPE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1066: line_type, 'PON_INVALID_STYLE_LINETYPE', batch_id, -- 2
1067: interface_line_id, auction_header_id, s_line_number, -- 3
1068: NULL, NULL, l_exp_date, -- 4
1069: l_userid, SYSDATE, l_userid, -- 5

Line 1085: interface_type, fnd_message.get_string('PON','PON_AUCTS_PROJECT'), 'PON_ITEM_PRICES_INTERFACE', -- 1

1081: last_update_date, last_update_login -- 6
1082: )
1083: VALUES
1084: (
1085: interface_type, fnd_message.get_string('PON','PON_AUCTS_PROJECT'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1086: project_number, 'PON_PROJ_NUM_INVALID', batch_id, -- 2
1087: interface_line_id, auction_header_id, s_line_number, -- 3
1088: NULL, NULL, l_exp_date, -- 4
1089: l_userid, SYSDATE, l_userid, -- 5

Line 1111: interface_type, fnd_message.get_string('PON','PON_AUCTS_TASK'), 'PON_ITEM_PRICES_INTERFACE', -- 1

1107: last_update_date, last_update_login -- 6
1108: )
1109: VALUES
1110: (
1111: interface_type, fnd_message.get_string('PON','PON_AUCTS_TASK'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1112: project_task_number, 'PON_PROJ_TASK_INVALID', batch_id, -- 2
1113: interface_line_id, auction_header_id, s_line_number, -- 3
1114: NULL, NULL, l_exp_date, -- 4
1115: l_userid, SYSDATE, l_userid, -- 5

Line 1142: interface_type, fnd_message.get_string('PON','PON_AUCTS_PROJECT_AWARD'), 'PON_ITEM_PRICES_INTERFACE', -- 1

1138: last_update_date, last_update_login -- 6
1139: )
1140: VALUES
1141: (
1142: interface_type, fnd_message.get_string('PON','PON_AUCTS_PROJECT_AWARD'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1143: project_award_number, 'PON_PROJ_AWARD_INVALID', batch_id, -- 2
1144: interface_line_id, auction_header_id, s_line_number, -- 3
1145: NULL, NULL, l_exp_date, -- 4
1146: l_userid, SYSDATE, l_userid, -- 5

Line 1164: interface_type, fnd_message.get_string('PON','PON_AUCTS_EXPENDITUE_ORG'), 'PON_ITEM_PRICES_INTERFACE', -- 1

1160: last_update_date, last_update_login -- 6
1161: )
1162: VALUES
1163: (
1164: interface_type, fnd_message.get_string('PON','PON_AUCTS_EXPENDITUE_ORG'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1165: project_exp_organization_name,'PON_PROJ_EXPORG_INVALID', batch_id, -- 2
1166: interface_line_id, auction_header_id, s_line_number, -- 3
1167: NULL, NULL, l_exp_date, -- 4
1168: l_userid, SYSDATE, l_userid, -- 5

Line 1193: interface_type, fnd_message.get_string('PON','PON_AUCTS_EXPENDITUE_TYPE'), 'PON_ITEM_PRICES_INTERFACE', -- 1

1189: last_update_date, last_update_login -- 6
1190: )
1191: VALUES
1192: (
1193: interface_type, fnd_message.get_string('PON','PON_AUCTS_EXPENDITUE_TYPE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1194: s_project_exp_type, 'PON_PROJ_EXPTYPE_INVALID', batch_id, -- 2
1195: interface_line_id, auction_header_id, s_line_number, -- 3
1196: NULL, NULL, l_exp_date, -- 4
1197: l_userid, SYSDATE, l_userid, -- 5

Line 1216: interface_type, fnd_message.get_string('PON','PON_AUCTS_PROJECT_AWARD'), 'PON_ITEM_PRICES_INTERFACE', -- 1

1212: last_update_date, last_update_login -- 6
1213: )
1214: VALUES
1215: (
1216: interface_type, fnd_message.get_string('PON','PON_AUCTS_PROJECT_AWARD'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1217: project_award_number, 'PON_PROJ_AWARD_NULL', batch_id, -- 2
1218: interface_line_id, auction_header_id, s_line_number, -- 3
1219: NULL, NULL, l_exp_date, -- 4
1220: l_userid, SYSDATE, l_userid, -- 5

Line 1240: interface_type, fnd_message.get_string('PON','PON_AUCTS_PROJECT'), 'PON_ITEM_PRICES_INTERFACE', -- 1

1236: last_update_date, last_update_login -- 6
1237: )
1238: VALUES
1239: (
1240: interface_type, fnd_message.get_string('PON','PON_AUCTS_PROJECT'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1241: NULL, 'PON_PROJ_INFO_INCOMPLETE', batch_id, -- 2
1242: interface_line_id, auction_header_id, s_line_number, -- 3
1243: NULL, NULL, l_exp_date, -- 4
1244: l_userid, SYSDATE, l_userid, -- 5

Line 1269: interface_type, fnd_message.get_string('PON','PON_DEFAULT_OWNER'), 'PON_ITEM_PRICES_INTERFACE', -- 1

1265: last_update_date, last_update_login -- 6
1266: )
1267: VALUES
1268: (
1269: interface_type, fnd_message.get_string('PON','PON_DEFAULT_OWNER'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1270: NULL, 'PON_LIN_OWNER_INVALID', batch_id, -- 2
1271: interface_line_id, auction_header_id, s_line_number, -- 3
1272: NULL, NULL, l_exp_date, -- 4
1273: l_userid, SYSDATE, l_userid, -- 5

Line 1637: fnd_message.get_string('PON','PON_AUC_TYPE_REQ'),

1633: table_name,
1634: batch_id,
1635: interface_line_id)
1636: select interface_type,
1637: fnd_message.get_string('PON','PON_AUC_TYPE_REQ'),
1638: 'Number of clins can not exceed 9999',
1639: 'PON_TOO_MANY_CLINS',
1640: 'PON_ITEM_PRICES_INTERFACE',
1641: batch_id,

Line 1668: fnd_message.get_string('PON','PON_AUC_TYPE_REQ'),

1664: table_name,
1665: batch_id,
1666: interface_line_id)
1667: select interface_type,
1668: fnd_message.get_string('PON','PON_AUC_TYPE_REQ'),
1669: 'Slins',
1670: 'PON_TOO_MANY_SLINS',
1671: 'PON_ITEM_PRICES_INTERFACE',
1672: batch_id,

Line 1701: fnd_message.get_string('PON','PON_AUCTS_QUANTITY'),

1697: table_name,
1698: batch_id,
1699: interface_line_id)
1700: select interface_type,
1701: fnd_message.get_string('PON','PON_AUCTS_QUANTITY'),
1702: quantity,
1703: 'PON_AUCTS_PR_QT_NOT_APPLY',
1704: 'PON_ITEM_PRICES_INTERFACE',
1705: batch_id,

Line 1724: fnd_message.get_string('PON','PON_AUCTION_UOM'),

1720: table_name,
1721: batch_id,
1722: interface_line_id)
1723: select interface_type,
1724: fnd_message.get_string('PON','PON_AUCTION_UOM'),
1725: unit_of_measure,
1726: 'PON_AUCTS_PR_QT_NOT_APPLY',
1727: 'PON_ITEM_PRICES_INTERFACE',
1728: batch_id,

Line 1747: fnd_message.get_string('PON','PON_AUCTS_TARGET_PRICE'),

1743: table_name,
1744: batch_id,
1745: interface_line_id)
1746: select interface_type,
1747: fnd_message.get_string('PON','PON_AUCTS_TARGET_PRICE'),
1748: target_price,
1749: 'PON_AUCTS_PR_QT_NOT_APPLY',
1750: 'PON_ITEM_PRICES_INTERFACE',
1751: batch_id,

Line 1770: fnd_message.get_string('PON','PON_AUCTS_CURRENT_PRICE'),

1766: table_name,
1767: batch_id,
1768: interface_line_id)
1769: select interface_type,
1770: fnd_message.get_string('PON','PON_AUCTS_CURRENT_PRICE'),
1771: current_price,
1772: 'PON_AUCTS_PR_QT_NOT_APPLY',
1773: 'PON_ITEM_PRICES_INTERFACE',
1774: batch_id,

Line 1793: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),

1789: table_name,
1790: batch_id,
1791: interface_line_id)
1792: select interface_type,
1793: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1794: 'PON_FIELD_MUST_BE_ENTERED',
1795: 'PON_ITEM_PRICES_INTERFACE',
1796: batch_id,
1797: interface_line_id

Line 1826: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),

1822: table_name,
1823: batch_id,
1824: interface_line_id)
1825: select interface_type,
1826: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1827: line_type,
1828: 'PON_AUC_LINE_TYPE_ERR',
1829: 'PON_ITEM_PRICES_INTERFACE',
1830: batch_id,

Line 1850: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),

1846: table_name,
1847: batch_id,
1848: interface_line_id)
1849: select interface_type,
1850: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1851: line_type,
1852: 'PON_AUC_LINE_TYPE_ERR',
1853: 'PON_ITEM_PRICES_INTERFACE',
1854: batch_id,

Line 1878: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),

1874: table_name,
1875: batch_id,
1876: interface_line_id)
1877: select interface_type,
1878: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1879: line_type,
1880: 'PON_AUC_LINE_TYPE_ERR',
1881: 'PON_ITEM_PRICES_INTERFACE',
1882: batch_id,

Line 1911: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),

1907: table_name,
1908: batch_id,
1909: interface_line_id)
1910: SELECT interface_type,
1911: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1912: line_type,
1913: 'PON_STANDARD_LINE_TYPES',
1914: 'PON_ITEM_PRICES_INTERFACE',
1915: batch_id,

Line 1934: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),

1930: table_name,
1931: batch_id,
1932: interface_line_id)
1933: SELECT interface_type,
1934: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1935: line_type,
1936: 'PON_GLOBAL_LINE_TYPES',
1937: 'PON_ITEM_PRICES_INTERFACE',
1938: batch_id,

Line 1958: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),

1954: table_name,
1955: batch_id,
1956: interface_line_id)
1957: SELECT interface_type,
1958: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1959: line_type,
1960: 'PON_AUC_GLOBAL_OP_LINE',
1961: 'PON_ITEM_PRICES_INTERFACE',
1962: batch_id,

Line 1981: fnd_message.get_string('PON','PON_AUCTS_ITEM'),

1977: table_name,
1978: batch_id,
1979: interface_line_id)
1980: SELECT interface_type,
1981: fnd_message.get_string('PON','PON_AUCTS_ITEM'),
1982: null,
1983: 'PON_AUC_OPL_ITEM_REQ',
1984: 'PON_ITEM_PRICES_INTERFACE',
1985: batch_id,

Line 2004: fnd_message.get_string('PON','PON_ITEM_JOB'),

2000: table_name,
2001: batch_id,
2002: interface_line_id)
2003: SELECT interface_type,
2004: fnd_message.get_string('PON','PON_ITEM_JOB'),
2005: '',
2006: 'PON_LINE_TYPE_JOB_REQ',
2007: 'PON_ITEM_PRICES_INTERFACE',
2008: batch_id,

Line 2062: fnd_message.get_string('PON','PON_ITEM_JOB'),

2058: table_name,
2059: batch_id,
2060: interface_line_id)
2061: SELECT interface_type,
2062: fnd_message.get_string('PON','PON_ITEM_JOB'),
2063: item_number,
2064: 'PON_JOB_INVALID',
2065: 'PON_ITEM_PRICES_INTERFACE',
2066: batch_id,

Line 2119: fnd_message.get_string('PON','PON_PRICE_DIFF_RESPONSE'),

2115: table_name,
2116: batch_id,
2117: interface_line_id)
2118: select interface_type,
2119: fnd_message.get_string('PON','PON_PRICE_DIFF_RESPONSE'),
2120: differential_response_type,
2121: 'PON_INVALID_DIFF_RESPONSE',
2122: 'PON_ITEM_PRICES_INTERFACE',
2123: batch_id,

Line 2129: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),

2125: from pon_item_prices_interface p1
2126: where batch_id = p_batch_id and
2127: purchase_basis = 'TEMP LABOR' and
2128: differential_response_type not in ('DIFF_NONE_ENTERED',
2129: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
2130: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
2131: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'));
2132: --
2133: -- clear out the differential response type

Line 2130: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),

2126: where batch_id = p_batch_id and
2127: purchase_basis = 'TEMP LABOR' and
2128: differential_response_type not in ('DIFF_NONE_ENTERED',
2129: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
2130: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
2131: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'));
2132: --
2133: -- clear out the differential response type
2134: -- if it does not apply

Line 2131: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'));

2127: purchase_basis = 'TEMP LABOR' and
2128: differential_response_type not in ('DIFF_NONE_ENTERED',
2129: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
2130: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
2131: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'));
2132: --
2133: -- clear out the differential response type
2134: -- if it does not apply
2135: update pon_item_prices_interface

Line 2139: differential_response_type not in (fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),

2135: update pon_item_prices_interface
2136: set differential_response_type = null
2137: where batch_id = p_batch_id and
2138: (purchase_basis = 'TEMP LABOR' and
2139: differential_response_type not in (fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
2140: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
2141: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'))) or
2142: (purchase_basis <> 'TEMP LABOR');
2143: --

Line 2140: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),

2136: set differential_response_type = null
2137: where batch_id = p_batch_id and
2138: (purchase_basis = 'TEMP LABOR' and
2139: differential_response_type not in (fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
2140: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
2141: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'))) or
2142: (purchase_basis <> 'TEMP LABOR');
2143: --
2144: -- End major services validation

Line 2141: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'))) or

2137: where batch_id = p_batch_id and
2138: (purchase_basis = 'TEMP LABOR' and
2139: differential_response_type not in (fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
2140: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
2141: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'))) or
2142: (purchase_basis <> 'TEMP LABOR');
2143: --
2144: -- End major services validation
2145: --

Line 2160: fnd_message.get_string('PON','PON_AUCTS_ITEM'),

2156: table_name,
2157: batch_id,
2158: interface_line_id)
2159: select interface_type,
2160: fnd_message.get_string('PON','PON_AUCTS_ITEM'),
2161: item_number,
2162: 'PON_AUCTS_SS_INVALID_INV_NUM',
2163: 'PON_ITEM_PRICES_INTERFACE',
2164: batch_id,

Line 2292: fnd_message.get_string('PON','PON_AUCTS_ITEM_DESC'),

2288: table_name,
2289: batch_id,
2290: interface_line_id)
2291: select interface_type,
2292: fnd_message.get_string('PON','PON_AUCTS_ITEM_DESC'),
2293: item_description,
2294: 'PON_AUCTS_INVALID_INV_DESC',
2295: 'PON_ITEM_PRICES_INTERFACE',
2296: batch_id,

Line 2323: fnd_message.get_string('PON','PON_AUCTS_REVISION'),

2319: table_name,
2320: batch_id,
2321: interface_line_id)
2322: select interface_type,
2323: fnd_message.get_string('PON','PON_AUCTS_REVISION'),
2324: item_revision,
2325: 'PON_AUCTS_INVALID_INV_REV',
2326: 'PON_ITEM_PRICES_INTERFACE',
2327: batch_id,

Line 2378: , fnd_message.get_string('PON','PON_AUCTION_UOM')

2374: , batch_id
2375: , interface_line_id
2376: )
2377: SELECT INTERFACE_TYPE
2378: , fnd_message.get_string('PON','PON_AUCTION_UOM')
2379: , unit_of_measure
2380: , 'PON_AUC_LINE_UOM_ERR'
2381: , 'PON_ITEM_PRICES_INTERFACE'
2382: , BATCH_ID

Line 2403: , fnd_message.get_string('PON',decode(p_contract_type,'STANDARD','PON_AUCTS_QUANTITY','PON_AUCTS_EST_QUANTITY'))

2399: , interface_line_id
2400: )
2401: SELECT
2402: INTERFACE_TYPE
2403: , fnd_message.get_string('PON',decode(p_contract_type,'STANDARD','PON_AUCTS_QUANTITY','PON_AUCTS_EST_QUANTITY'))
2404: , quantity
2405: , 'PON_AUC_LINE_QUAN_ERR'
2406: , 'PON_ITEM_PRICES_INTERFACE'
2407: , BATCH_ID

Line 2429: fnd_message.get_string('PON','PON_AUCTS_CATEGORY'),

2425: table_name,
2426: batch_id,
2427: interface_line_id)
2428: select interface_type,
2429: fnd_message.get_string('PON','PON_AUCTS_CATEGORY'),
2430: 'PON_FIELD_MUST_BE_ENTERED',
2431: 'PON_ITEM_PRICES_INTERFACE',
2432: batch_id,
2433: interface_line_id

Line 2527: fnd_message.get_string('PON','PON_AUCTS_CATEGORY'),

2523: table_name,
2524: batch_id,
2525: interface_line_id)
2526: select interface_type,
2527: fnd_message.get_string('PON','PON_AUCTS_CATEGORY'),
2528: category_name,
2529: decode(purchase_basis,'TEMP LABOR','PON_INVALID_TEMP_LABOR_CAT','PON_CATEGORY_ID_NOT_FOUND'),
2530: 'PON_ITEM_PRICES_INTERFACE',
2531: batch_id,

Line 2549: fnd_message.get_string('PON','PON_AUCTS_CATEGORY'),

2545: table_name,
2546: batch_id,
2547: interface_line_id)
2548: select interface_type,
2549: fnd_message.get_string('PON','PON_AUCTS_CATEGORY'),
2550: category_name,
2551: 'PON_AUCTS_INVALID_INV_CAT',
2552: 'PON_ITEM_PRICES_INTERFACE',
2553: batch_id,

Line 2602: fnd_message.get_string('PON','PON_SHOPPING_CAT'),

2598: table_name,
2599: batch_id,
2600: interface_line_id)
2601: select interface_type,
2602: fnd_message.get_string('PON','PON_SHOPPING_CAT'),
2603: 'PON_SHOP_CAT_NOT_VALID',
2604: 'PON_ITEM_PRICES_INTERFACE',
2605: batch_id,
2606: interface_line_id

Line 2652: fnd_message.get_string('PON','PON_AUCTS_ITEM_DESC'),

2648: table_name,
2649: batch_id,
2650: interface_line_id)
2651: select interface_type,
2652: fnd_message.get_string('PON','PON_AUCTS_ITEM_DESC'),
2653: 'PON_FIELD_MUST_BE_ENTERED',
2654: 'PON_ITEM_PRICES_INTERFACE',
2655: batch_id,
2656: interface_line_id

Line 2681: fnd_message.get_string('PON','PON_ORDER_UNIT_H'),

2677: table_name,
2678: batch_id,
2679: interface_line_id)
2680: select interface_type,
2681: fnd_message.get_string('PON','PON_ORDER_UNIT_H'),
2682: 'PON_FIELD_MUST_BE_ENTERED',
2683: 'PON_ITEM_PRICES_INTERFACE',
2684: batch_id,
2685: interface_line_id

Line 2776: fnd_message.get_string('PON','PON_AUCTION_UOM'),

2772: table_name,
2773: batch_id,
2774: interface_line_id)
2775: select interface_type,
2776: fnd_message.get_string('PON','PON_AUCTION_UOM'),
2777: unit_of_measure,
2778: decode(purchase_basis,'TEMP LABOR','PON_INVALID_TEMP_LABOR_UOM','PON_INVALID_UOM'),
2779: 'PON_ITEM_PRICES_INTERFACE',
2780: batch_id,

Line 2799: fnd_message.get_string('PON','PON_AUCTION_UOM'),

2795: table_name,
2796: batch_id,
2797: interface_line_id)
2798: select interface_type,
2799: fnd_message.get_string('PON','PON_AUCTION_UOM'),
2800: unit_of_measure,
2801: 'PON_AUCTS_INVALID_INV_UOM',
2802: 'PON_ITEM_PRICES_INTERFACE',
2803: batch_id,

Line 2841: fnd_message.get_string('PON','PON_AUCTS_QUANTITY'),

2837: table_name,
2838: batch_id,
2839: interface_line_id)
2840: select interface_type,
2841: fnd_message.get_string('PON','PON_AUCTS_QUANTITY'),
2842: 'PON_FIELD_MUST_BE_ENTERED',
2843: 'PON_ITEM_PRICES_INTERFACE',
2844: batch_id,
2845: interface_line_id

Line 2871: fnd_message.get_string('PON', 'PON_AUCTS_EST_QUANTITY'),

2867: batch_id,
2868: interface_line_id)
2869: SELECT
2870: interface_type,
2871: fnd_message.get_string('PON', 'PON_AUCTS_EST_QUANTITY'),
2872: quantity,
2873: 'PON_AUC_QUAN_FIXED_AMT',
2874: 'LINENUM',
2875: interface_line_id,

Line 3029: decode(l_is_fed,'Y',fnd_message.get_string('PON','PON_CLM_PERIOD_PERF_START_DATE'),fnd_message.get_string('PON','PON_AUC_NEED_BY_FROM_DATE')),

3025: batch_id,
3026: interface_line_id)
3027: select interface_type,
3028: -- CLM : For federal documents, display Period Of Performance Start Date
3029: decode(l_is_fed,'Y',fnd_message.get_string('PON','PON_CLM_PERIOD_PERF_START_DATE'),fnd_message.get_string('PON','PON_AUC_NEED_BY_FROM_DATE')),
3030: need_by_start_date,
3031: 'PON_DATE_MUST_BE_GT_TODAY',
3032: 'PON_ITEM_PRICES_INTERFACE',
3033: batch_id,

Line 3050: decode(l_is_fed,'Y',fnd_message.get_string('PON','PON_CLM_PERIOD_PERF_END_DATE'),fnd_message.get_string('PON','PON_AUC_NEED_BY_TO_DATE')),

3046: batch_id,
3047: interface_line_id)
3048: select interface_type,
3049: -- CLM : For federal documents, display Period Of Performance End Date
3050: decode(l_is_fed,'Y',fnd_message.get_string('PON','PON_CLM_PERIOD_PERF_END_DATE'),fnd_message.get_string('PON','PON_AUC_NEED_BY_TO_DATE')),
3051: need_by_date,
3052: 'PON_DATE_MUST_BE_GT_TODAY',
3053: 'PON_ITEM_PRICES_INTERFACE',
3054: batch_id,

Line 3071: fnd_message.get_string('PON','PON_AUCTS_NEED_BY_DATE'),

3067: table_name,
3068: batch_id,
3069: interface_line_id)
3070: select interface_type,
3071: fnd_message.get_string('PON','PON_AUCTS_NEED_BY_DATE'),
3072: clm_need_by_date,
3073: 'PON_DATE_MUST_BE_GT_TODAY',
3074: 'PON_ITEM_PRICES_INTERFACE',
3075: batch_id,

Line 3092: decode(l_is_fed,'Y',fnd_message.get_string('PON','PON_CLM_PERIOD_PERF_END_DATE'),fnd_message.get_string('PON','PON_AUC_NEED_BY_TO_DATE')),

3088: batch_id,
3089: interface_line_id)
3090: select interface_type,
3091: --CLM : For Federal, show Period of Performance end date
3092: decode(l_is_fed,'Y',fnd_message.get_string('PON','PON_CLM_PERIOD_PERF_END_DATE'),fnd_message.get_string('PON','PON_AUC_NEED_BY_TO_DATE')),
3093: need_by_date,
3094: -- CLM : For federal display Period Of Perf dates message
3095: decode(l_is_fed,'Y','PON_AUC_IMPORT_POP_BEFORE_FROM','PON_AUC_NEEDBY_BEFORE_FROM_SS'),
3096: 'PON_ITEM_PRICES_INTERFACE',

Line 3118: fnd_message.get_string('PON','PON_AUCTS_NEEDBY'),

3114: table_name,
3115: batch_id,
3116: interface_line_id)
3117: select ip.interface_type,
3118: fnd_message.get_string('PON','PON_AUCTS_NEEDBY'),
3119: null,
3120: 'PON_NEED_BY_DATE_REQ_SPD',
3121: 'PON_ITEM_PRICES_INTERFACE',
3122: ip.batch_id,

Line 3158: fnd_message.get_string('PON','PON_CLM_DEL_EVENT_CODE'),

3154: table_name,
3155: batch_id,
3156: interface_line_id)
3157: select interface_type,
3158: fnd_message.get_string('PON','PON_CLM_DEL_EVENT_CODE'),
3159: CLM_DELIVERY_EVENT,
3160: 'PON_INV_DEL_EVENT_CODE',
3161: 'PON_ITEM_PRICES_INTERFACE',
3162: batch_id,

Line 3183: fnd_message.get_string('PON','PON_CLM_DEL_PERIOD_UOM'),

3179: table_name,
3180: batch_id,
3181: interface_line_id)
3182: select interface_type,
3183: fnd_message.get_string('PON','PON_CLM_DEL_PERIOD_UOM'),
3184: CLM_DELIVERY_PERIOD_UOM,
3185: 'PON_INV_PERIOD_UOM_CODE',
3186: 'PON_ITEM_PRICES_INTERFACE',
3187: batch_id,

Line 3208: fnd_message.get_string('PON','PON_CLM_POP_DUR_UOM'),

3204: table_name,
3205: batch_id,
3206: interface_line_id)
3207: select interface_type,
3208: fnd_message.get_string('PON','PON_CLM_POP_DUR_UOM'),
3209: CLM_POP_DURATION_UOM,
3210: 'PON_INV_POP_UOM_CODE',
3211: 'PON_ITEM_PRICES_INTERFACE',
3212: batch_id,

Line 3236: , fnd_message.get_string('PON','PON_AUCTS_SHIP_TO_LOC')

3232: , batch_id
3233: , interface_line_id
3234: )
3235: select interface_type
3236: , fnd_message.get_string('PON','PON_AUCTS_SHIP_TO_LOC')
3237: , 'PON_FIELD_MUST_BE_ENTERED'
3238: , 'PON_ITEM_PRICES_INTERFACE'
3239: , batch_id
3240: , interface_line_id

Line 3286: fnd_message.get_string('PON','PON_AUCTS_SHIP_TO_LOC'),

3282: table_name,
3283: batch_id,
3284: interface_line_id)
3285: select interface_type,
3286: fnd_message.get_string('PON','PON_AUCTS_SHIP_TO_LOC'),
3287: ship_to_location,
3288: 'PON_CAT_INVALID_VALUE',
3289: 'PON_ITEM_PRICES_INTERFACE',
3290: batch_id,

Line 3312: fnd_message.get_string('PON','PON_AUCTS_TARGET_PRICE'),

3308: table_name,
3309: batch_id,
3310: interface_line_id)
3311: select interface_type,
3312: fnd_message.get_string('PON','PON_AUCTS_TARGET_PRICE'),
3313: target_price,
3314: 'PON_MUST_BE_POSITIVE_NUMBER',
3315: 'PON_ITEM_PRICES_INTERFACE',
3316: batch_id,

Line 3337: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),

3333: table_name,
3334: batch_id,
3335: interface_line_id)
3336: select interface_type,
3337: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),
3338: bid_start_price,
3339: 'PON_MUST_BE_POSITIVE_NUMBER',
3340: 'PON_ITEM_PRICES_INTERFACE',
3341: batch_id,

Line 3361: fnd_message.get_string('PON','PON_AUCTS_CURRENT_PRICE'),

3357: table_name,
3358: batch_id,
3359: interface_line_id)
3360: select interface_type,
3361: fnd_message.get_string('PON','PON_AUCTS_CURRENT_PRICE'),
3362: current_price,
3363: 'PON_MUST_BE_POSITIVE_NUMBER',
3364: 'PON_ITEM_PRICES_INTERFACE',
3365: batch_id,

Line 3386: fnd_message.get_string('PON','PON_AUCTS_RESERVE_PRICE'),

3382: table_name,
3383: batch_id,
3384: interface_line_id)
3385: select interface_type,
3386: fnd_message.get_string('PON','PON_AUCTS_RESERVE_PRICE'),
3387: reserve_price,
3388: 'PON_MUST_BE_POSITIVE_NUMBER',
3389: 'PON_ITEM_PRICES_INTERFACE',
3390: batch_id,

Line 3421: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),

3417: table_name,
3418: batch_id,
3419: interface_line_id)
3420: select interface_type,
3421: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),
3422: bid_start_price,
3423: 'PON_TARGET_GTR_BID_START',
3424: 'PON_ITEM_PRICES_INTERFACE',
3425: batch_id,

Line 3446: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),

3442: table_name,
3443: batch_id,
3444: interface_line_id)
3445: select interface_type,
3446: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),
3447: bid_start_price,
3448: 'PON_AUCTS_START_LT_TARGET',
3449: 'PON_ITEM_PRICES_INTERFACE',
3450: batch_id,

Line 3468: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),

3464: table_name,
3465: batch_id,
3466: interface_line_id)
3467: select interface_type,
3468: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),
3469: bid_start_price,
3470: 'PON_AUCTS_START_LT_RESERVE',
3471: 'PON_ITEM_PRICES_INTERFACE',
3472: batch_id,

Line 3490: fnd_message.get_string('PON','PON_AUCTS_RESERVE_PRICE'),

3486: table_name,
3487: batch_id,
3488: interface_line_id)
3489: select interface_type,
3490: fnd_message.get_string('PON','PON_AUCTS_RESERVE_PRICE'),
3491: reserve_price,
3492: 'PON_AUCTS_RESERVE_LT_TARGET',
3493: 'PON_ITEM_PRICES_INTERFACE',
3494: batch_id,

Line 3515: fnd_message.get_string('PON','PON_ITEM_PRICE_TARGET_VALUE'),

3511: table_name,
3512: batch_id,
3513: interface_line_id)
3514: select interface_type,
3515: fnd_message.get_string('PON','PON_ITEM_PRICE_TARGET_VALUE'),
3516: unit_target_price,
3517: 'PON_AUC_POSITIVE_OR_ZERO',
3518: 'PON_ITEM_PRICES_INTERFACE',
3519: batch_id,

Line 3535: fnd_message.get_string('PON','PON_CLM_OPTION_FROM_DATE'),

3531: table_name,
3532: batch_id,
3533: interface_line_id)
3534: select interface_type,
3535: fnd_message.get_string('PON','PON_CLM_OPTION_FROM_DATE'),
3536: 'PON_FIELD_MUST_BE_ENTERED',
3537: 'PON_ITEM_PRICES_INTERFACE',
3538: batch_id,
3539: interface_line_id

Line 3553: fnd_message.get_string('PON','PON_CLM_OPTION_TO_DATE'),

3549: table_name,
3550: batch_id,
3551: interface_line_id)
3552: select interface_type,
3553: fnd_message.get_string('PON','PON_CLM_OPTION_TO_DATE'),
3554: 'PON_FIELD_MUST_BE_ENTERED',
3555: 'PON_ITEM_PRICES_INTERFACE',
3556: batch_id,
3557: interface_line_id

Line 3572: fnd_message.get_string('PON','PON_CLM_OPTION_FROM_DATE'),

3568: table_name,
3569: batch_id,
3570: interface_line_id)
3571: select interface_type,
3572: fnd_message.get_string('PON','PON_CLM_OPTION_FROM_DATE'),
3573: CLM_OPTION_FROM_DATE,
3574: 'PON_CLM_OPT_FROMDATE_ERR',
3575: 'PON_ITEM_PRICES_INTERFACE',
3576: batch_id,

Line 3592: fnd_message.get_string('PON','PON_CLM_OPTION_TO_DATE'),

3588: table_name,
3589: batch_id,
3590: interface_line_id)
3591: select interface_type,
3592: fnd_message.get_string('PON','PON_CLM_OPTION_TO_DATE'),
3593: CLM_OPTION_TO_DATE,
3594: 'PON_CLM_OPT_TODATE_ERR',
3595: 'PON_ITEM_PRICES_INTERFACE',
3596: batch_id,

Line 3622: fnd_message.get_string('PON', 'PON_CLM_AMOUNT'),

3618: table_name,
3619: batch_id,
3620: interface_line_id)
3621: (select interface_type,
3622: fnd_message.get_string('PON', 'PON_CLM_AMOUNT'),
3623: 'Slins',
3624: 'PON_CLM_AMOUNT_ERR',
3625: 'PON_ITEM_PRICES_INTERFACE',
3626: batch_id,

Line 3644: fnd_message.get_string('PON', 'PON_CLM_UNIT_PRICE'),

3640: table_name,
3641: batch_id,
3642: interface_line_id)
3643: (select interface_type,
3644: fnd_message.get_string('PON', 'PON_CLM_UNIT_PRICE'),
3645: 'Slins',
3646: 'PON_CLM_UNIT_PRICE_ERR',
3647: 'PON_ITEM_PRICES_INTERFACE',
3648: batch_id,

Line 3669: fnd_message.get_string('PON', 'PON_CLM_CONTRACT_TYPE'),

3665: interface_line_id)
3666: --Bug 16567154
3667: --Removing spaces in the error message
3668: (select interface_type,
3669: fnd_message.get_string('PON', 'PON_CLM_CONTRACT_TYPE'),
3670: 'Slins',
3671: 'PON_CLM_CONTRACT_TYPE_ERR',
3672: 'PON_ITEM_PRICES_INTERFACE',
3673: batch_id,

Line 3700: fnd_message.get_string('PON', 'PON_CLM_COST_CONSTRAINT'),

3696: interface_line_id)
3697: --Bug 16567154
3698: --Removing spaces in the error message
3699: (select interface_type,
3700: fnd_message.get_string('PON', 'PON_CLM_COST_CONSTRAINT'),
3701: 'Slins',
3702: 'PON_CLM_COST_CONSTRAINT_ERR',
3703: 'PON_ITEM_PRICES_INTERFACE',
3704: batch_id,

Line 3731: fnd_message.get_string('PON', 'PON_CLM_BASE_LINE_NUM'),

3727: interface_line_id)
3728: --Bug 16567154
3729: --Removing spaces in the error message
3730: (select interface_type,
3731: fnd_message.get_string('PON', 'PON_CLM_BASE_LINE_NUM'),
3732: 'Slins',
3733: 'PON_CLM_BASE_LINE_NUM_ERR',
3734: 'PON_ITEM_PRICES_INTERFACE',
3735: batch_id,

Line 3762: fnd_message.get_string('PON', 'PON_CLM_OPTION_INDICATOR'),

3758: interface_line_id)
3759: --Bug 16567154
3760: --Removing spaces in the error message
3761: (select interface_type,
3762: fnd_message.get_string('PON', 'PON_CLM_OPTION_INDICATOR'),
3763: 'Slins',
3764: 'PON_CLM_OPTION_INDICATOR_ERR',
3765: 'PON_ITEM_PRICES_INTERFACE',
3766: batch_id,

Line 3804: fnd_message.get_string('PON','PON_AGREEMENT_RELEASE_QUANTITY') || ',' || fnd_message.get_string('PON','PON_AUCTS_PB_RESPONSE'),

3800: table_name,
3801: batch_id,
3802: interface_line_id)
3803: select interface_type,
3804: fnd_message.get_string('PON','PON_AGREEMENT_RELEASE_QUANTITY') || ',' || fnd_message.get_string('PON','PON_AUCTS_PB_RESPONSE'),
3805: null,
3806: 'PON_AUCTS_PB_FP_LINE_ERR',
3807: 'PON_ITEM_PRICES_INTERFACE',
3808: batch_id,

Line 3866: fnd_message.get_string('PON','PON_AGREEMENT_RELEASE_QUANTITY') || ',' || fnd_message.get_string('PON','PON_AUCTS_PB_RESPONSE'),

3862: table_name,
3863: batch_id,
3864: interface_line_id)
3865: select interface_type,
3866: fnd_message.get_string('PON','PON_AGREEMENT_RELEASE_QUANTITY') || ',' || fnd_message.get_string('PON','PON_AUCTS_PB_RESPONSE'),
3867: null,
3868: 'PON_INVALID_PB_SETTING',
3869: 'PON_ITEM_PRICES_INTERFACE',
3870: batch_id,

Line 3889: fnd_message.get_string('PON','PON_AUCTS_PB_RESPONSE'),

3885: table_name,
3886: batch_id,
3887: interface_line_id)
3888: select interface_type,
3889: fnd_message.get_string('PON','PON_AUCTS_PB_RESPONSE'),
3890: null,
3891: 'PON_AUC_PB_NOT_EMPTY',
3892: 'PON_ITEM_PRICES_INTERFACE',
3893: batch_id,

Line 3946: fnd_message.get_string('PON','PON_AUCTS_LINENUMBER'),

3942: table_name,
3943: batch_id,
3944: interface_line_id)
3945: select interface_type,
3946: fnd_message.get_string('PON','PON_AUCTS_LINENUMBER'),
3947: null,
3948: 'PON_AUCTS_PB_TBL_LINE_ERR',
3949: 'PON_ITEM_PRICES_INTERFACE',
3950: batch_id,