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 297: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)

293: , last_update_date
294: , last_update_login
295: )
296: VALUES ( 'AWARDBID'
297: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
298: , 'PON_AUC_BID_NUMBER_INVALID' || l_suffix
299: , s_bid_number
300: , 'PON_AWARD_ITEMS_INTERFACE'
301: , s_batch_id

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

336: , last_update_date
337: , last_update_login
338: )
339: VALUES ( 'AWARDBID'
340: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
341: , 'PON_AUC_ITEM_AWARDED'
342: , 'PON_AWARD_ITEMS_INTERFACE'
343: , s_batch_id
344: , s_worksheet_name

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

379: , last_update_date
380: , last_update_login
381: )
382: VALUES ( 'AWARDBID'
383: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
384: , 'PON_AWARD_EXCLUDE_SHLIST_ERR' || l_suffix
385: , s_bid_number
386: , 'PON_AWARD_ITEMS_INTERFACE'
387: , s_batch_id

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

423: , last_update_date
424: , last_update_login
425: )
426: VALUES ( 'AWARDBID'
427: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
428: , 'PON_AWARD_BID_NOT_ACTIVE' || l_suffix
429: , s_bid_number
430: , 'PON_AWARD_ITEMS_INTERFACE'
431: , s_batch_id

Line 471: , 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))

467: , last_update_date
468: , last_update_login
469: )
470: VALUES ( 'AWARDBID'
471: , 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))
472: , 'PON_AWARD_INACTIVE_SUPPLIER'
473: , s_trading_partner_name
474: , 'PON_AWARD_ITEMS_INTERFACE'
475: , s_batch_id

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

510: , last_update_date
511: , last_update_login
512: )
513: VALUES ( 'AWARDBID'
514: , decode(l_contract_type, 'STANDARD', fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY'), fnd_message.get_string('PON','PON_AUCTS_AGREED_QUANTITY'))
515: , decode(l_contract_type, 'STANDARD', 'PON_AUC_AWARD_QTY_COL_NEG', 'PON_AUC_QTY_AGREED_COL_NEG')
516: , s_award_quantity
517: , 'NUM'
518: , 'PON_AWARD_ITEMS_INTERFACE'

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

556: , last_update_date
557: , last_update_login
558: )
559: VALUES ( 'AWARDBID'
560: , fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY')
561: , 'PON_AUCTS_MUST_AWARD'
562: , 'PON_AWARD_ITEMS_INTERFACE'
563: , s_batch_id
564: , s_worksheet_name

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

605: , TOKEN1_NAME
606: , TOKEN1_VALUE
607: )
608: VALUES ( 'AWARDBID'
609: , fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY')
610: , 'PON_QUANTITY_TIER_VIOLATION' || l_suffix
611: , 'PON_AWARD_ITEMS_INTERFACE'
612: , s_award_quantity
613: , s_batch_id

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

679: , TOKEN1_VALUE
680: )
681: SELECT
682: 'AWARDBID'
683: , fnd_message.get_string('PON','PON_AUC_LINE_TYPE')
684: , 'PON_AWARD_FIXED_PRICE'|| l_suffix
685: , pltt.line_type
686: , 'PON_AWARD_ITEMS_INTERFACE'
687: , paii.BATCH_ID

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

768: last_update_date, last_update_login -- 6
769: )
770: VALUES
771: (
772: interface_type, fnd_message.get_string('PON','PON_AUC_LINE_TYPE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
773: line_type, 'PON_INVALID_STYLE_LINETYPE', batch_id, -- 2
774: interface_line_id, auction_header_id, s_line_number, -- 3
775: NULL, NULL, l_exp_date, -- 4
776: l_userid, SYSDATE, l_userid, -- 5

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

808: last_update_date, last_update_login -- 6
809: )
810: VALUES
811: (
812: interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
813: retainage_rate_percent, 'PON_RTNG_RATE_WRONG', batch_id, -- 2
814: interface_line_id, auction_header_id, s_line_number, -- 3
815: NULL, NULL, l_exp_date, -- 4
816: l_userid, SYSDATE, l_userid, -- 5

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

828: last_update_date, last_update_login -- 6
829: )
830: VALUES
831: (
832: interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_ITEM_PRICES_INTERFACE', -- 1
833: max_retainage_amount , 'PON_MAX_RTNG_WRONG', batch_id, -- 2
834: interface_line_id, auction_header_id, s_line_number, -- 3
835: NULL, NULL, l_exp_date, -- 4
836: l_userid, SYSDATE, l_userid, -- 5

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

848: last_update_date, last_update_login -- 6
849: )
850: VALUES
851: (
852: interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_ITEM_PRICES_INTERFACE', -- 1
853: advance_amount, 'PON_ADV_AMT_WRONG', batch_id, -- 2
854: interface_line_id, auction_header_id, s_line_number, -- 3
855: NULL, NULL, l_exp_date, -- 4
856: l_userid, SYSDATE, l_userid, -- 5

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

868: last_update_date, last_update_login -- 6
869: )
870: VALUES
871: (
872: interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
873: progress_pymt_rate_percent, 'PON_PROG_PYMT_RATE_WRONG', batch_id, -- 2
874: interface_line_id, auction_header_id, s_line_number, -- 3
875: NULL, NULL, l_exp_date, -- 4
876: l_userid, SYSDATE, l_userid, -- 5

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

887: last_update_date, last_update_login -- 6
888: )
889: VALUES
890: (
891: interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
892: recoupment_rate_percent, 'PON_RECOUP_RATE_WRONG', batch_id, -- 2
893: interface_line_id, auction_header_id, s_line_number, -- 3
894: NULL, NULL, l_exp_date, -- 4
895: l_userid, SYSDATE, l_userid, -- 5

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

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

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

930: last_update_date, last_update_login -- 6
931: )
932: VALUES
933: (
934: interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
935: recoupment_rate_percent, 'PON_RECUP_NEEDED_WITH_PPRATE', batch_id, -- 2
936: interface_line_id, auction_header_id, s_line_number, -- 3
937: NULL, NULL, l_exp_date, -- 4
938: l_userid, SYSDATE, l_userid, -- 5

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

951: last_update_date, last_update_login -- 6
952: )
953: VALUES
954: (
955: interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
956: recoupment_rate_percent, 'PON_RECUP_NEEDED_WITH_ADVAMT', batch_id, -- 2
957: interface_line_id, auction_header_id, s_line_number, -- 3
958: NULL, NULL, l_exp_date, -- 4
959: l_userid, SYSDATE, l_userid, -- 5

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

972: last_update_date, last_update_login -- 6
973: )
974: VALUES
975: (
976: interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_ITEM_PRICES_INTERFACE', -- 1
977: advance_amount, 'PON_ADV_AMT_MORE', batch_id, -- 2
978: interface_line_id, auction_header_id, s_line_number, -- 3
979: NULL, NULL, l_exp_date, -- 4
980: l_userid, SYSDATE, l_userid, -- 5

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

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

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

1018: last_update_date, last_update_login -- 6
1019: )
1020: VALUES
1021: (
1022: interface_type, fnd_message.get_string('PON','PON_AUC_LINE_TYPE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1023: line_type, 'PON_INVALID_STYLE_LINETYPE', batch_id, -- 2
1024: interface_line_id, auction_header_id, s_line_number, -- 3
1025: NULL, NULL, l_exp_date, -- 4
1026: l_userid, SYSDATE, l_userid, -- 5

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

1038: last_update_date, last_update_login -- 6
1039: )
1040: VALUES
1041: (
1042: interface_type, fnd_message.get_string('PON','PON_AUCTS_PROJECT'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1043: project_number, 'PON_PROJ_NUM_INVALID', batch_id, -- 2
1044: interface_line_id, auction_header_id, s_line_number, -- 3
1045: NULL, NULL, l_exp_date, -- 4
1046: l_userid, SYSDATE, l_userid, -- 5

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

1063: last_update_date, last_update_login -- 6
1064: )
1065: VALUES
1066: (
1067: interface_type, fnd_message.get_string('PON','PON_AUCTS_TASK'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1068: project_task_number, 'PON_PROJ_TASK_INVALID', batch_id, -- 2
1069: interface_line_id, auction_header_id, s_line_number, -- 3
1070: NULL, NULL, l_exp_date, -- 4
1071: l_userid, SYSDATE, l_userid, -- 5

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

1093: last_update_date, last_update_login -- 6
1094: )
1095: VALUES
1096: (
1097: interface_type, fnd_message.get_string('PON','PON_AUCTS_PROJECT_AWARD'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1098: project_award_number, 'PON_PROJ_AWARD_INVALID', batch_id, -- 2
1099: interface_line_id, auction_header_id, s_line_number, -- 3
1100: NULL, NULL, l_exp_date, -- 4
1101: l_userid, SYSDATE, l_userid, -- 5

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

1114: last_update_date, last_update_login -- 6
1115: )
1116: VALUES
1117: (
1118: interface_type, fnd_message.get_string('PON','PON_AUCTS_EXPENDITUE_ORG'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1119: project_exp_organization_name,'PON_PROJ_EXPORG_INVALID', batch_id, -- 2
1120: interface_line_id, auction_header_id, s_line_number, -- 3
1121: NULL, NULL, l_exp_date, -- 4
1122: l_userid, SYSDATE, l_userid, -- 5

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

1142: last_update_date, last_update_login -- 6
1143: )
1144: VALUES
1145: (
1146: interface_type, fnd_message.get_string('PON','PON_AUCTS_EXPENDITUE_TYPE'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1147: s_project_exp_type, 'PON_PROJ_EXPTYPE_INVALID', batch_id, -- 2
1148: interface_line_id, auction_header_id, s_line_number, -- 3
1149: NULL, NULL, l_exp_date, -- 4
1150: l_userid, SYSDATE, l_userid, -- 5

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

1164: last_update_date, last_update_login -- 6
1165: )
1166: VALUES
1167: (
1168: interface_type, fnd_message.get_string('PON','PON_AUCTS_PROJECT_AWARD'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1169: project_award_number, 'PON_PROJ_AWARD_NULL', batch_id, -- 2
1170: interface_line_id, auction_header_id, s_line_number, -- 3
1171: NULL, NULL, l_exp_date, -- 4
1172: l_userid, SYSDATE, l_userid, -- 5

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

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

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

1215: last_update_date, last_update_login -- 6
1216: )
1217: VALUES
1218: (
1219: interface_type, fnd_message.get_string('PON','PON_DEFAULT_OWNER'), 'PON_ITEM_PRICES_INTERFACE', -- 1
1220: NULL, 'PON_LIN_OWNER_INVALID', batch_id, -- 2
1221: interface_line_id, auction_header_id, s_line_number, -- 3
1222: NULL, NULL, l_exp_date, -- 4
1223: l_userid, SYSDATE, l_userid, -- 5

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

1511: table_name,
1512: batch_id,
1513: interface_line_id)
1514: select interface_type,
1515: fnd_message.get_string('PON','PON_AUCTS_QUANTITY'),
1516: quantity,
1517: 'PON_AUCTS_PR_QT_NOT_APPLY',
1518: 'PON_ITEM_PRICES_INTERFACE',
1519: batch_id,

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

1534: table_name,
1535: batch_id,
1536: interface_line_id)
1537: select interface_type,
1538: fnd_message.get_string('PON','PON_AUCTION_UOM'),
1539: unit_of_measure,
1540: 'PON_AUCTS_PR_QT_NOT_APPLY',
1541: 'PON_ITEM_PRICES_INTERFACE',
1542: batch_id,

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

1557: table_name,
1558: batch_id,
1559: interface_line_id)
1560: select interface_type,
1561: fnd_message.get_string('PON','PON_AUCTS_TARGET_PRICE'),
1562: target_price,
1563: 'PON_AUCTS_PR_QT_NOT_APPLY',
1564: 'PON_ITEM_PRICES_INTERFACE',
1565: batch_id,

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

1580: table_name,
1581: batch_id,
1582: interface_line_id)
1583: select interface_type,
1584: fnd_message.get_string('PON','PON_AUCTS_CURRENT_PRICE'),
1585: current_price,
1586: 'PON_AUCTS_PR_QT_NOT_APPLY',
1587: 'PON_ITEM_PRICES_INTERFACE',
1588: batch_id,

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

1603: table_name,
1604: batch_id,
1605: interface_line_id)
1606: select interface_type,
1607: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1608: 'PON_FIELD_MUST_BE_ENTERED',
1609: 'PON_ITEM_PRICES_INTERFACE',
1610: batch_id,
1611: interface_line_id

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

1634: table_name,
1635: batch_id,
1636: interface_line_id)
1637: select interface_type,
1638: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1639: line_type,
1640: 'PON_AUC_LINE_TYPE_ERR',
1641: 'PON_ITEM_PRICES_INTERFACE',
1642: batch_id,

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

1657: table_name,
1658: batch_id,
1659: interface_line_id)
1660: select interface_type,
1661: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1662: line_type,
1663: 'PON_AUC_LINE_TYPE_ERR',
1664: 'PON_ITEM_PRICES_INTERFACE',
1665: batch_id,

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

1685: table_name,
1686: batch_id,
1687: interface_line_id)
1688: select interface_type,
1689: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1690: line_type,
1691: 'PON_AUC_LINE_TYPE_ERR',
1692: 'PON_ITEM_PRICES_INTERFACE',
1693: batch_id,

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

1717: table_name,
1718: batch_id,
1719: interface_line_id)
1720: SELECT interface_type,
1721: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1722: line_type,
1723: 'PON_STANDARD_LINE_TYPES',
1724: 'PON_ITEM_PRICES_INTERFACE',
1725: batch_id,

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

1740: table_name,
1741: batch_id,
1742: interface_line_id)
1743: SELECT interface_type,
1744: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1745: line_type,
1746: 'PON_GLOBAL_LINE_TYPES',
1747: 'PON_ITEM_PRICES_INTERFACE',
1748: batch_id,

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

1764: table_name,
1765: batch_id,
1766: interface_line_id)
1767: SELECT interface_type,
1768: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1769: line_type,
1770: 'PON_AUC_GLOBAL_OP_LINE',
1771: 'PON_ITEM_PRICES_INTERFACE',
1772: batch_id,

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

1787: table_name,
1788: batch_id,
1789: interface_line_id)
1790: SELECT interface_type,
1791: fnd_message.get_string('PON','PON_AUCTS_ITEM'),
1792: null,
1793: 'PON_AUC_OPL_ITEM_REQ',
1794: 'PON_ITEM_PRICES_INTERFACE',
1795: batch_id,

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

1810: table_name,
1811: batch_id,
1812: interface_line_id)
1813: SELECT interface_type,
1814: fnd_message.get_string('PON','PON_ITEM_JOB'),
1815: '',
1816: 'PON_LINE_TYPE_JOB_REQ',
1817: 'PON_ITEM_PRICES_INTERFACE',
1818: batch_id,

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

1868: table_name,
1869: batch_id,
1870: interface_line_id)
1871: SELECT interface_type,
1872: fnd_message.get_string('PON','PON_ITEM_JOB'),
1873: item_number,
1874: 'PON_JOB_INVALID',
1875: 'PON_ITEM_PRICES_INTERFACE',
1876: batch_id,

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

1925: table_name,
1926: batch_id,
1927: interface_line_id)
1928: select interface_type,
1929: fnd_message.get_string('PON','PON_PRICE_DIFF_RESPONSE'),
1930: differential_response_type,
1931: 'PON_INVALID_DIFF_RESPONSE',
1932: 'PON_ITEM_PRICES_INTERFACE',
1933: batch_id,

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

1935: from pon_item_prices_interface p1
1936: where batch_id = p_batch_id and
1937: purchase_basis = 'TEMP LABOR' and
1938: differential_response_type not in ('DIFF_NONE_ENTERED',
1939: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
1940: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
1941: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'));
1942: --
1943: -- clear out the differential response type

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

1936: where batch_id = p_batch_id and
1937: purchase_basis = 'TEMP LABOR' and
1938: differential_response_type not in ('DIFF_NONE_ENTERED',
1939: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
1940: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
1941: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'));
1942: --
1943: -- clear out the differential response type
1944: -- if it does not apply

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

1937: purchase_basis = 'TEMP LABOR' and
1938: differential_response_type not in ('DIFF_NONE_ENTERED',
1939: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
1940: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
1941: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'));
1942: --
1943: -- clear out the differential response type
1944: -- if it does not apply
1945: update pon_item_prices_interface

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

1945: update pon_item_prices_interface
1946: set differential_response_type = null
1947: where batch_id = p_batch_id and
1948: (purchase_basis = 'TEMP LABOR' and
1949: differential_response_type not in (fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
1950: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
1951: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'))) or
1952: (purchase_basis <> 'TEMP LABOR');
1953: --

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

1946: set differential_response_type = null
1947: where batch_id = p_batch_id and
1948: (purchase_basis = 'TEMP LABOR' and
1949: differential_response_type not in (fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
1950: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
1951: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'))) or
1952: (purchase_basis <> 'TEMP LABOR');
1953: --
1954: -- End major services validation

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

1947: where batch_id = p_batch_id and
1948: (purchase_basis = 'TEMP LABOR' and
1949: differential_response_type not in (fnd_message.get_string('PON','PON_AUCTS_REQUIRED'),
1950: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'),
1951: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'))) or
1952: (purchase_basis <> 'TEMP LABOR');
1953: --
1954: -- End major services validation
1955: --

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

1966: table_name,
1967: batch_id,
1968: interface_line_id)
1969: select interface_type,
1970: fnd_message.get_string('PON','PON_AUCTS_ITEM'),
1971: item_number,
1972: 'PON_AUCTS_SS_INVALID_INV_NUM',
1973: 'PON_ITEM_PRICES_INTERFACE',
1974: batch_id,

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

2092: table_name,
2093: batch_id,
2094: interface_line_id)
2095: select interface_type,
2096: fnd_message.get_string('PON','PON_AUCTS_ITEM_DESC'),
2097: item_description,
2098: 'PON_AUCTS_INVALID_INV_DESC',
2099: 'PON_ITEM_PRICES_INTERFACE',
2100: batch_id,

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

2123: table_name,
2124: batch_id,
2125: interface_line_id)
2126: select interface_type,
2127: fnd_message.get_string('PON','PON_AUCTS_REVISION'),
2128: item_revision,
2129: 'PON_AUCTS_INVALID_INV_REV',
2130: 'PON_ITEM_PRICES_INTERFACE',
2131: batch_id,

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

2176: , batch_id
2177: , interface_line_id
2178: )
2179: SELECT INTERFACE_TYPE
2180: , fnd_message.get_string('PON','PON_AUCTION_UOM')
2181: , unit_of_measure
2182: , 'PON_AUC_LINE_UOM_ERR'
2183: , 'PON_ITEM_PRICES_INTERFACE'
2184: , BATCH_ID

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

2200: , interface_line_id
2201: )
2202: SELECT
2203: INTERFACE_TYPE
2204: , fnd_message.get_string('PON',decode(p_contract_type,'STANDARD','PON_AUCTS_QUANTITY','PON_AUCTS_EST_QUANTITY'))
2205: , quantity
2206: , 'PON_AUC_LINE_QUAN_ERR'
2207: , 'PON_ITEM_PRICES_INTERFACE'
2208: , BATCH_ID

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

2223: table_name,
2224: batch_id,
2225: interface_line_id)
2226: select interface_type,
2227: fnd_message.get_string('PON','PON_AUCTS_CATEGORY'),
2228: 'PON_FIELD_MUST_BE_ENTERED',
2229: 'PON_ITEM_PRICES_INTERFACE',
2230: batch_id,
2231: interface_line_id

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

2320: table_name,
2321: batch_id,
2322: interface_line_id)
2323: select interface_type,
2324: fnd_message.get_string('PON','PON_AUCTS_CATEGORY'),
2325: category_name,
2326: decode(purchase_basis,'TEMP LABOR','PON_INVALID_TEMP_LABOR_CAT','PON_CATEGORY_ID_NOT_FOUND'),
2327: 'PON_ITEM_PRICES_INTERFACE',
2328: batch_id,

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

2342: table_name,
2343: batch_id,
2344: interface_line_id)
2345: select interface_type,
2346: fnd_message.get_string('PON','PON_AUCTS_CATEGORY'),
2347: category_name,
2348: 'PON_AUCTS_INVALID_INV_CAT',
2349: 'PON_ITEM_PRICES_INTERFACE',
2350: batch_id,

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

2395: table_name,
2396: batch_id,
2397: interface_line_id)
2398: select interface_type,
2399: fnd_message.get_string('PON','PON_SHOPPING_CAT'),
2400: 'PON_SHOP_CAT_NOT_VALID',
2401: 'PON_ITEM_PRICES_INTERFACE',
2402: batch_id,
2403: interface_line_id

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

2444: table_name,
2445: batch_id,
2446: interface_line_id)
2447: select interface_type,
2448: fnd_message.get_string('PON','PON_AUCTS_ITEM_DESC'),
2449: 'PON_FIELD_MUST_BE_ENTERED',
2450: 'PON_ITEM_PRICES_INTERFACE',
2451: batch_id,
2452: interface_line_id

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

2473: table_name,
2474: batch_id,
2475: interface_line_id)
2476: select interface_type,
2477: fnd_message.get_string('PON','PON_ORDER_UNIT_H'),
2478: 'PON_FIELD_MUST_BE_ENTERED',
2479: 'PON_ITEM_PRICES_INTERFACE',
2480: batch_id,
2481: interface_line_id

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

2567: table_name,
2568: batch_id,
2569: interface_line_id)
2570: select interface_type,
2571: fnd_message.get_string('PON','PON_AUCTION_UOM'),
2572: unit_of_measure,
2573: decode(purchase_basis,'TEMP LABOR','PON_INVALID_TEMP_LABOR_UOM','PON_INVALID_UOM'),
2574: 'PON_ITEM_PRICES_INTERFACE',
2575: batch_id,

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

2590: table_name,
2591: batch_id,
2592: interface_line_id)
2593: select interface_type,
2594: fnd_message.get_string('PON','PON_AUCTION_UOM'),
2595: unit_of_measure,
2596: 'PON_AUCTS_INVALID_INV_UOM',
2597: 'PON_ITEM_PRICES_INTERFACE',
2598: batch_id,

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

2632: table_name,
2633: batch_id,
2634: interface_line_id)
2635: select interface_type,
2636: fnd_message.get_string('PON','PON_AUCTS_QUANTITY'),
2637: 'PON_FIELD_MUST_BE_ENTERED',
2638: 'PON_ITEM_PRICES_INTERFACE',
2639: batch_id,
2640: interface_line_id

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

2661: batch_id,
2662: interface_line_id)
2663: SELECT
2664: interface_type,
2665: fnd_message.get_string('PON', 'PON_AUCTS_EST_QUANTITY'),
2666: quantity,
2667: 'PON_AUC_QUAN_FIXED_AMT',
2668: 'LINENUM',
2669: interface_line_id,

Line 2738: fnd_message.get_string('PON','PON_AUC_NEED_BY_FROM_DATE'),

2734: table_name,
2735: batch_id,
2736: interface_line_id)
2737: select interface_type,
2738: fnd_message.get_string('PON','PON_AUC_NEED_BY_FROM_DATE'),
2739: need_by_start_date,
2740: 'PON_DATE_MUST_BE_GT_TODAY',
2741: 'PON_ITEM_PRICES_INTERFACE',
2742: batch_id,

Line 2758: fnd_message.get_string('PON','PON_AUC_NEED_BY_TO_DATE'),

2754: table_name,
2755: batch_id,
2756: interface_line_id)
2757: select interface_type,
2758: fnd_message.get_string('PON','PON_AUC_NEED_BY_TO_DATE'),
2759: need_by_date,
2760: 'PON_DATE_MUST_BE_GT_TODAY',
2761: 'PON_ITEM_PRICES_INTERFACE',
2762: batch_id,

Line 2778: fnd_message.get_string('PON','PON_AUC_NEED_BY_TO_DATE'),

2774: table_name,
2775: batch_id,
2776: interface_line_id)
2777: select interface_type,
2778: fnd_message.get_string('PON','PON_AUC_NEED_BY_TO_DATE'),
2779: need_by_date,
2780: 'PON_AUC_NEEDBY_BEFORE_FROM_SS',
2781: 'PON_ITEM_PRICES_INTERFACE',
2782: batch_id,

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

2795: table_name,
2796: batch_id,
2797: interface_line_id)
2798: select ip.interface_type,
2799: fnd_message.get_string('PON','PON_AUCTS_NEEDBY'),
2800: null,
2801: 'PON_NEED_BY_DATE_REQ_SPD',
2802: 'PON_ITEM_PRICES_INTERFACE',
2803: ip.batch_id,

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

2834: , batch_id
2835: , interface_line_id
2836: )
2837: select interface_type
2838: , fnd_message.get_string('PON','PON_AUCTS_SHIP_TO_LOC')
2839: , 'PON_FIELD_MUST_BE_ENTERED'
2840: , 'PON_ITEM_PRICES_INTERFACE'
2841: , batch_id
2842: , interface_line_id

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

2883: table_name,
2884: batch_id,
2885: interface_line_id)
2886: select interface_type,
2887: fnd_message.get_string('PON','PON_AUCTS_SHIP_TO_LOC'),
2888: ship_to_location,
2889: 'PON_CAT_INVALID_VALUE',
2890: 'PON_ITEM_PRICES_INTERFACE',
2891: batch_id,

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

2909: table_name,
2910: batch_id,
2911: interface_line_id)
2912: select interface_type,
2913: fnd_message.get_string('PON','PON_AUCTS_TARGET_PRICE'),
2914: target_price,
2915: 'PON_MUST_BE_POSITIVE_NUMBER',
2916: 'PON_ITEM_PRICES_INTERFACE',
2917: batch_id,

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

2934: table_name,
2935: batch_id,
2936: interface_line_id)
2937: select interface_type,
2938: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),
2939: bid_start_price,
2940: 'PON_MUST_BE_POSITIVE_NUMBER',
2941: 'PON_ITEM_PRICES_INTERFACE',
2942: batch_id,

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

2958: table_name,
2959: batch_id,
2960: interface_line_id)
2961: select interface_type,
2962: fnd_message.get_string('PON','PON_AUCTS_CURRENT_PRICE'),
2963: current_price,
2964: 'PON_MUST_BE_POSITIVE_NUMBER',
2965: 'PON_ITEM_PRICES_INTERFACE',
2966: batch_id,

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

2983: table_name,
2984: batch_id,
2985: interface_line_id)
2986: select interface_type,
2987: fnd_message.get_string('PON','PON_AUCTS_RESERVE_PRICE'),
2988: reserve_price,
2989: 'PON_MUST_BE_POSITIVE_NUMBER',
2990: 'PON_ITEM_PRICES_INTERFACE',
2991: batch_id,

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

3018: table_name,
3019: batch_id,
3020: interface_line_id)
3021: select interface_type,
3022: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),
3023: bid_start_price,
3024: 'PON_TARGET_GTR_BID_START',
3025: 'PON_ITEM_PRICES_INTERFACE',
3026: batch_id,

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

3043: table_name,
3044: batch_id,
3045: interface_line_id)
3046: select interface_type,
3047: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),
3048: bid_start_price,
3049: 'PON_AUCTS_START_LT_TARGET',
3050: 'PON_ITEM_PRICES_INTERFACE',
3051: batch_id,

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

3065: table_name,
3066: batch_id,
3067: interface_line_id)
3068: select interface_type,
3069: fnd_message.get_string('PON','PON_AUCTION_BID_START_PRICE'),
3070: bid_start_price,
3071: 'PON_AUCTS_START_LT_RESERVE',
3072: 'PON_ITEM_PRICES_INTERFACE',
3073: batch_id,

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

3087: table_name,
3088: batch_id,
3089: interface_line_id)
3090: select interface_type,
3091: fnd_message.get_string('PON','PON_AUCTS_RESERVE_PRICE'),
3092: reserve_price,
3093: 'PON_AUCTS_RESERVE_LT_TARGET',
3094: 'PON_ITEM_PRICES_INTERFACE',
3095: batch_id,

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

3112: table_name,
3113: batch_id,
3114: interface_line_id)
3115: select interface_type,
3116: fnd_message.get_string('PON','PON_ITEM_PRICE_TARGET_VALUE'),
3117: unit_target_price,
3118: 'PON_AUC_POSITIVE_OR_ZERO',
3119: 'PON_ITEM_PRICES_INTERFACE',
3120: batch_id,