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_BID_VALIDATIONS_PKG dependencies on FND_MESSAGE

Line 876: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_DEC' || p_suffix),

872: ENTITY_MESSAGE_CODE)
873: VALUES
874: (p_interface_type,
875: decode(p_spreadsheet, g_xml_upload_mode,
876: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_DEC' || p_suffix),
877: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
878: 'PON_BID_ITEM_PRICES',
879: p_batch_id,
880: s_interface_line_id,

Line 877: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),

873: VALUES
874: (p_interface_type,
875: decode(p_spreadsheet, g_xml_upload_mode,
876: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_DEC' || p_suffix),
877: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
878: 'PON_BID_ITEM_PRICES',
879: p_batch_id,
880: s_interface_line_id,
881: 'PON_AUCTS_MIN_DEC_NULL' || p_suffix,

Line 989: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),

985: ENTITY_MESSAGE_CODE)
986: VALUES
987: (p_interface_type,
988: 'PON_BID_ITEM_PRICES',
989: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
990: p_batch_id,
991: s_interface_line_id,
992: 'PON_BID_PRICE_REQUIRED' || p_suffix,
993: p_userid,

Line 1040: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),

1036: ENTITY_MESSAGE_CODE)
1037: VALUES
1038: (p_interface_type,
1039: 'PON_BID_ITEM_PRICES',
1040: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1041: p_batch_id,
1042: s_interface_line_id,
1043: 'PON_BID_QUANTITY_REQUIRED' || p_suffix,
1044: p_userid,

Line 1092: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),

1088: WORKSHEET_SEQUENCE_NUMBER,
1089: ENTITY_MESSAGE_CODE)
1090: VALUES
1091: (p_interface_type,
1092: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1093: 'PON_BID_ITEM_PRICES',
1094: p_batch_id,
1095: s_interface_line_id,
1096: 'PON_AUC_BIDQTY_NEG' || p_suffix,

Line 1146: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),

1142: WORKSHEET_SEQUENCE_NUMBER,
1143: ENTITY_MESSAGE_CODE)
1144: VALUES
1145: (p_interface_type,
1146: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1147: 'PON_BID_ITEM_PRICES',
1148: p_batch_id,
1149: s_interface_line_id,
1150: 'PON_INVALID_BID_QTY' || p_suffix,

Line 1205: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),

1201: WORKSHEET_SEQUENCE_NUMBER,
1202: ENTITY_MESSAGE_CODE)
1203: VALUES
1204: (p_interface_type,
1205: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
1206: 'PON_BID_ITEM_PRICES',
1207: p_batch_id,
1208: s_interface_line_id,
1209: 'PON_AUC_PROMISED_DATE_REQ',

Line 1263: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),

1259: WORKSHEET_SEQUENCE_NUMBER,
1260: ENTITY_MESSAGE_CODE)
1261: VALUES
1262: (p_interface_type,
1263: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
1264: 'PON_BID_ITEM_PRICES',
1265: p_batch_id,
1266: s_interface_line_id,
1267: 'PON_AUC_PDATE_TOO_EARLY',

Line 1316: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),

1312: WORKSHEET_SEQUENCE_NUMBER,
1313: ENTITY_MESSAGE_CODE)
1314: VALUES
1315: (p_interface_type,
1316: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),
1317: 'PON_BID_ITEM_PRICES',
1318: p_batch_id,
1319: s_interface_line_id,
1320: 'PON_AUC_MINREL_POS_ZERO' || p_suffix,

Line 1370: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),

1366: WORKSHEET_SEQUENCE_NUMBER,
1367: ENTITY_MESSAGE_CODE)
1368: VALUES
1369: (p_interface_type,
1370: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),
1371: 'PON_BID_ITEM_PRICES',
1372: p_batch_id,
1373: s_interface_line_id,
1374: 'PON_AUC_MINREL_MIN_PREC' || p_suffix,

Line 1431: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),

1427: WORKSHEET_SEQUENCE_NUMBER,
1428: ENTITY_MESSAGE_CODE)
1429: VALUES
1430: (p_interface_type,
1431: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),
1432: 'PON_BID_ITEM_PRICES',
1433: p_batch_id,
1434: s_interface_line_id,
1435: 'PON_LINEPRICE_MUST_BE_POS',

Line 1493: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),

1489: WORKSHEET_SEQUENCE_NUMBER,
1490: ENTITY_MESSAGE_CODE)
1491: VALUES
1492: (p_interface_type,
1493: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),
1494: 'PON_BID_ITEM_PRICES',
1495: p_batch_id,
1496: s_interface_line_id,
1497: 'PON_LINEPRICE_MIN_PREC' || p_suffix,

Line 1551: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),

1547: WORKSHEET_SEQUENCE_NUMBER,
1548: ENTITY_MESSAGE_CODE)
1549: VALUES
1550: (p_interface_type,
1551: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1552: 'PON_BID_ITEM_PRICES',
1553: p_batch_id,
1554: s_interface_line_id,
1555: 'PON_BID_PRICE_REQUIRED' || p_suffix,

Line 1649: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),

1645: WORKSHEET_SEQUENCE_NUMBER,
1646: ENTITY_MESSAGE_CODE)
1647: VALUES
1648: (p_interface_type,
1649: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1650: 'PON_BID_ITEM_PRICES',
1651: p_batch_id,
1652: s_interface_line_id,
1653: decode(p_trans_view, 'N',

Line 1712: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),

1708: WORKSHEET_SEQUENCE_NUMBER,
1709: ENTITY_MESSAGE_CODE)
1710: VALUES
1711: (p_interface_type,
1712: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1713: 'PON_BID_ITEM_PRICES',
1714: p_batch_id,
1715: s_interface_line_id,
1716: 'PON_AUCTS_BIDPRICE_MIN_PREC' || p_suffix,

Line 1773: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),

1769: WORKSHEET_SEQUENCE_NUMBER,
1770: ENTITY_MESSAGE_CODE)
1771: VALUES
1772: (p_interface_type,
1773: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1774: 'PON_BID_ITEM_PRICES',
1775: p_batch_id,
1776: s_interface_line_id,
1777: 'PON_LINE_BIDPRICE_INVALID_1' || p_suffix,

Line 1833: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),

1829: VALUES
1830: (p_interface_type,
1831: decode(p_spreadsheet,
1832: g_xml_upload_mode,
1833: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
1834: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
1835: 'PON_BID_ITEM_PRICES',
1836: p_batch_id,
1837: s_interface_line_id,

Line 1834: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),

1830: (p_interface_type,
1831: decode(p_spreadsheet,
1832: g_xml_upload_mode,
1833: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
1834: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
1835: 'PON_BID_ITEM_PRICES',
1836: p_batch_id,
1837: s_interface_line_id,
1838: 'PON_AUC_LIMPRICE_MUST_BE_POS',

Line 1894: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),

1890: VALUES
1891: (p_interface_type,
1892: decode(p_spreadsheet,
1893: g_xml_upload_mode,
1894: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
1895: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
1896: 'PON_BID_ITEM_PRICES',
1897: p_batch_id,
1898: s_interface_line_id,

Line 1895: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),

1891: (p_interface_type,
1892: decode(p_spreadsheet,
1893: g_xml_upload_mode,
1894: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
1895: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
1896: 'PON_BID_ITEM_PRICES',
1897: p_batch_id,
1898: s_interface_line_id,
1899: 'PON_AUCTS_LIMIT_MIN_PREC' || p_suffix,

Line 1964: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),

1960: WORKSHEET_SEQUENCE_NUMBER,
1961: ENTITY_MESSAGE_CODE)
1962: VALUES
1963: (p_interface_type,
1964: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1965: 'PON_BID_ITEM_PRICES',
1966: p_batch_id,
1967: s_interface_line_id,
1968: 'PON_BP_LTE_BIDSTARTPRICE' || p_suffix,

Line 2044: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),

2040: ENTITY_MESSAGE_CODE
2041: )
2042: VALUES
2043: (p_interface_type,
2044: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2045: 'PON_BID_ITEM_PRICES',
2046: p_batch_id,
2047: s_interface_line_id,
2048: 'PON_MIN_BID_DECREMENT' || p_suffix,

Line 2119: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),

2115: ENTITY_MESSAGE_CODE
2116: )
2117: VALUES
2118: (p_interface_type,
2119: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2120: 'PON_BID_ITEM_PRICES',
2121: p_batch_id,
2122: s_interface_line_id,
2123: 'PON_MIN_BESTBID_DECREMENT' || p_suffix,

Line 2186: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),

2182: WORKSHEET_SEQUENCE_NUMBER,
2183: ENTITY_MESSAGE_CODE)
2184: VALUES
2185: (p_interface_type,
2186: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2187: 'PON_BID_ITEM_PRICES',
2188: p_batch_id,
2189: s_interface_line_id,
2190: decode(p_bid_decr_method,'BEST_PRICE','PON_BESTBID_PRICE_LOWER','PON_BID_PRICE_LOWER') || p_suffix,

Line 2251: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),

2247: VALUES
2248: (p_interface_type,
2249: decode(p_spreadsheet,
2250: g_xml_upload_mode,
2251: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2252: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2253: 'PON_BID_ITEM_PRICES',
2254: p_batch_id,
2255: s_interface_line_id,

Line 2252: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),

2248: (p_interface_type,
2249: decode(p_spreadsheet,
2250: g_xml_upload_mode,
2251: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2252: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2253: 'PON_BID_ITEM_PRICES',
2254: p_batch_id,
2255: s_interface_line_id,
2256: 'PON_AUCTS_LIMIT_MIN_LESS_PRI' || p_suffix,

Line 2508: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1

2504: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2505: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2506: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2507: VALUES
2508: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
2509: p_batch_id, s_interface_line_id, 'PON_RTNG_RATE_WRONG_L', --2
2510: p_userid, sysdate, p_userid, --3
2511: sysdate, p_request_id, 'BID_ITEMS', --4
2512: 'RetainageRatePercent', retainage_rate_percent, 'NUM', --5

Line 2533: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1

2529: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2530: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2531: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2532: VALUES
2533: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
2534: p_batch_id, s_interface_line_id, 'PON_MAX_RTNG_WRONG_L', --2
2535: p_userid, sysdate, p_userid, --3
2536: sysdate, p_request_id, 'BID_ITEMS', --4
2537: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'NUM', --5

Line 2558: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1

2554: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2555: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2556: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2557: VALUES
2558: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
2559: p_batch_id, s_interface_line_id, 'PON_ADV_AMT_WRONG_L', --2
2560: p_userid, sysdate, p_userid, --3
2561: sysdate, p_request_id, 'BID_ITEMS', --4
2562: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'NUM', --5

Line 2584: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1

2580: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2581: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2582: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2583: VALUES
2584: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
2585: p_batch_id, s_interface_line_id, 'PON_PROG_PYMT_RATE_WRONG_L', --2
2586: p_userid, sysdate, p_userid, --3
2587: sysdate, p_request_id, 'BID_ITEMS', --4
2588: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'NUM', --5

Line 2610: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1

2606: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2607: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2608: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2609: VALUES
2610: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
2611: p_batch_id, s_interface_line_id, 'PON_RECOUP_RATE_WRONG', --2
2612: p_userid, sysdate, p_userid, --3
2613: sysdate, p_request_id, 'BID_ITEMS', --4
2614: 'RecoupmentRatePercent', recoupment_rate_percent, 'NUM', --5

Line 2637: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1

2633: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2634: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
2635: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2636: VALUES
2637: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
2638: p_batch_id, s_interface_line_id, 'PON_PROG_PYMT_NEEDED_L', --2
2639: p_userid, sysdate, p_userid, --3
2640: sysdate, p_request_id, 'BID_ITEMS', --4
2641: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'TXT', --5

Line 2665: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1

2661: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2662: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2663: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2664: VALUES
2665: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
2666: p_batch_id, s_interface_line_id, 'PON_RETAINAGE_NEEDED_L', --2
2667: p_userid, sysdate, p_userid, --3
2668: sysdate, p_request_id, 'BID_ITEMS', --4
2669: 'RetainageRatePercent', retainage_rate_percent, 'TXT', --5

Line 2693: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1

2689: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2690: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
2691: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2692: VALUES
2693: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
2694: p_batch_id, s_interface_line_id, 'PON_MAX_RETAINAGE_NEEDED_L', --2
2695: p_userid, sysdate, p_userid, --3
2696: sysdate, p_request_id, 'BID_ITEMS', --4
2697: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'TXT', --5

Line 2724: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1

2720: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2721: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2722: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2723: VALUES
2724: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
2725: p_batch_id, s_interface_line_id, 'PON_RECUP_RATE_NEEDED_L', --2
2726: p_userid, sysdate, p_userid, --3
2727: sysdate, p_request_id, 'BID_ITEMS', --4
2728: 'RecoupmentRatePercent', recoupment_rate_percent, 'TXT', --5

Line 2752: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1

2748: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2749: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2750: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2751: VALUES
2752: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
2753: p_batch_id, s_interface_line_id, 'PON_ADVANCE_AMT_NEEDED_L', --2
2754: p_userid, sysdate, p_userid, --3
2755: sysdate, p_request_id, 'BID_ITEMS', --4
2756: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'TXT', --5

Line 2817: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1

2813: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2814: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, --7
2815: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2816: VALUES
2817: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
2818: p_batch_id, s_interface_line_id, 'PON_ADV_AMT_MORE_L', --2
2819: p_userid, sysdate, p_userid, --3
2820: sysdate, p_request_id, 'BID_ITEMS', --4
2821: NULL, bid_curr_advance_amount, 'NUM', --5

Line 2849: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1

2845: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2846: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,--7
2847: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2848: VALUES
2849: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
2850: p_batch_id, s_interface_line_id, 'PON_RECOUP_LESS_THAN_PYMT_L', --2
2851: p_userid, sysdate, p_userid, --3
2852: sysdate, p_request_id, 'BID_ITEMS', --4
2853: NULL, recoupment_rate_percent, 'NUM', --5

Line 2876: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1

2872: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2873: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,--7
2874: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2875: VALUES
2876: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
2877: p_batch_id, s_interface_line_id, 'PON_RECOUP_LESS_THAN_ADV_L', --2
2878: p_userid, sysdate, p_userid, --3
2879: sysdate, p_request_id, 'BID_ITEMS', --4
2880: NULL, recoupment_rate_percent, 'NUM', --5

Line 2967: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1

2963: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2964: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
2965: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2966: VALUES
2967: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
2968: p_batch_id, s_interface_line_id, 'PON_LINEAMT_INVALID_PRECISION', --2
2969: p_userid, sysdate, p_userid, --3
2970: sysdate, p_request_id, 'BID_ITEMS', --4
2971: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'NUM', --5

Line 2974: s_document_disp_line_number, 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'),

2970: sysdate, p_request_id, 'BID_ITEMS', --4
2971: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'NUM', --5
2972: p_auc_header_id, p_bid_number, s_line_number, --6
2973: NULL, g_exp_date, 'LINENUM', --7
2974: s_document_disp_line_number, 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'),
2975: s_worksheet_name, s_worksheet_sequence_number, s_entity_message_code) --8
2976: -- bid_curr_max_retainage_amt should not exceed currency precision
2977: WHEN
2978: -- added by Allen Yang for Surrogate Bid 2008/09/03

Line 2994: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1

2990: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2991: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2992: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2993: VALUES
2994: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
2995: p_batch_id, s_interface_line_id, 'PON_LINEAMT_INVALID_PRECISION', --2
2996: p_userid, sysdate, p_userid, --3
2997: sysdate, p_request_id, 'BID_ITEMS', --4
2998: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'NUM', --5

Line 3001: s_document_disp_line_number, 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'),

2997: sysdate, p_request_id, 'BID_ITEMS', --4
2998: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'NUM', --5
2999: p_auc_header_id, p_bid_number, s_line_number, --6
3000: NULL, g_exp_date, 'LINENUM', --7
3001: s_document_disp_line_number, 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'),
3002: s_worksheet_name, s_worksheet_sequence_number, s_entity_message_code) --8
3003: -- progress_pymt_rate_percent should not exceed currency precision
3004: WHEN
3005: -- added by Allen Yang for Surrogate Bid 2008/09/03

Line 3021: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1

3017: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3018: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3019: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3020: VALUES
3021: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
3022: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3023: p_userid, sysdate, p_userid, --3
3024: sysdate, p_request_id, 'BID_ITEMS', --4
3025: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'NUM', --5

Line 3028: s_document_disp_line_number, 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'),

3024: sysdate, p_request_id, 'BID_ITEMS', --4
3025: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'NUM', --5
3026: p_auc_header_id, p_bid_number, s_line_number, --6
3027: NULL, g_exp_date, 'LINENUM', --7
3028: s_document_disp_line_number, 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'),
3029: s_worksheet_name, s_worksheet_sequence_number, s_entity_message_code) --8
3030: -- retainage_rate_percent should not exceed currency precision
3031: WHEN
3032: -- added by Allen Yang for Surrogate Bid 2008/09/03

Line 3048: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1

3044: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3045: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3046: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3047: VALUES
3048: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
3049: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3050: p_userid, sysdate, p_userid, --3
3051: sysdate, p_request_id, 'BID_ITEMS', --4
3052: 'RetainageRatePercent', retainage_rate_percent, 'NUM', --5

Line 3055: s_document_disp_line_number, 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_RETAINAGE_RATE'),

3051: sysdate, p_request_id, 'BID_ITEMS', --4
3052: 'RetainageRatePercent', retainage_rate_percent, 'NUM', --5
3053: p_auc_header_id, p_bid_number, s_line_number, --6
3054: NULL, g_exp_date, 'LINENUM', --7
3055: s_document_disp_line_number, 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_RETAINAGE_RATE'),
3056: s_worksheet_name, s_worksheet_sequence_number, s_entity_message_code) --8
3057: -- recoupment_rate_percent should not exceed currency precision
3058: WHEN
3059: -- added by Allen Yang for Surrogate Bid 2008/09/03

Line 3075: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1

3071: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3072: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3073: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME,WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3074: VALUES
3075: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3076: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3077: p_userid, sysdate, p_userid, --3
3078: sysdate, p_request_id, 'BID_ITEMS', --4
3079: 'RecoupmentRatePercent', recoupment_rate_percent, 'NUM', --5

Line 3082: s_document_disp_line_number, 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_RECOUPMENT_RATE'),

3078: sysdate, p_request_id, 'BID_ITEMS', --4
3079: 'RecoupmentRatePercent', recoupment_rate_percent, 'NUM', --5
3080: p_auc_header_id, p_bid_number, s_line_number, --6
3081: NULL, g_exp_date, 'LINENUM', --7
3082: s_document_disp_line_number, 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_RECOUPMENT_RATE'),
3083: s_worksheet_name, s_worksheet_sequence_number, s_entity_message_code) --8
3084: SELECT
3085: al.group_type s_group_type,
3086: bl.quantity s_bid_quantity,

Line 3175: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),

3171: WORKSHEET_SEQUENCE_NUMBER,
3172: ENTITY_MESSAGE_CODE)
3173: VALUES
3174: (p_interface_type,
3175: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3176: 'PON_BID_ATTRIBUTE_VALUES',
3177: p_batch_id,
3178: s_interface_line_id,
3179: 'PON_AUC_HDR_ATTR_REQ' || p_suffix,

Line 3232: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),

3228: WORKSHEET_SEQUENCE_NUMBER,
3229: ENTITY_MESSAGE_CODE)
3230: VALUES
3231: (p_interface_type,
3232: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3233: 'PON_BID_ATTRIBUTE_VALUES',
3234: p_batch_id,
3235: s_interface_line_id,
3236: 'PON_AUC_INVALID_ATTR_VALUE' || p_suffix,

Line 3338: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),

3334: WORKSHEET_SEQUENCE_NUMBER,
3335: ENTITY_MESSAGE_CODE)
3336: VALUES
3337: (p_interface_type,
3338: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3339: 'PON_BID_ATTRIBUTE_VALUES',
3340: p_batch_id,
3341: s_interface_line_id,
3342: 'PON_AUC_ATTR_VALUE_REQ' || p_suffix,

Line 3398: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),

3394: WORKSHEET_SEQUENCE_NUMBER,
3395: ENTITY_MESSAGE_CODE)
3396: VALUES
3397: (p_interface_type,
3398: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3399: 'PON_BID_ATTRIBUTE_VALUES',
3400: p_batch_id,
3401: s_interface_line_id,
3402: 'PON_AUC_INVALID_ATTR_VALUE' || p_suffix,

Line 3784: fnd_message.get_string('PON', 'PON_AUCTS_ATTR_BID_VALUE' || p_suffix),

3780: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, to_char(null)) s_worksheet_name,
3781: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_PRICE_ELEMENTS', to_char(null)) s_entity_message_code,
3782: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
3783: decode(p_spreadsheet, g_xml_upload_mode,
3784: fnd_message.get_string('PON', 'PON_AUCTS_ATTR_BID_VALUE' || p_suffix),
3785: fnd_message.get_string('PON', 'PON_AUC_PE_BID_VALUE_REQ' || p_suffix)) s_column_name
3786: FROM pon_bid_price_elements bpf
3787: , pon_auction_item_prices_all al
3788: , pon_bid_item_prices bl

Line 3785: fnd_message.get_string('PON', 'PON_AUC_PE_BID_VALUE_REQ' || p_suffix)) s_column_name

3781: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_PRICE_ELEMENTS', to_char(null)) s_entity_message_code,
3782: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
3783: decode(p_spreadsheet, g_xml_upload_mode,
3784: fnd_message.get_string('PON', 'PON_AUCTS_ATTR_BID_VALUE' || p_suffix),
3785: fnd_message.get_string('PON', 'PON_AUC_PE_BID_VALUE_REQ' || p_suffix)) s_column_name
3786: FROM pon_bid_price_elements bpf
3787: , pon_auction_item_prices_all al
3788: , pon_bid_item_prices bl
3789: , pon_price_element_types_tl pft

Line 3859: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_QUANTITY'), null ),

3855: ENTITY_MESSAGE_CODE)
3856: VALUES
3857: (p_interface_type,
3858: 'PON_BID_SHIPMENTS',
3859: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_QUANTITY'), null ),
3860: p_batch_id,
3861: s_interface_line_id,
3862: 'PON_AUCTS_PB_QUANTITY_POSITIVE',
3863: p_userid,

Line 3915: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),

3911: ENTITY_MESSAGE_CODE)
3912: VALUES
3913: (p_interface_type,
3914: 'PON_BID_SHIPMENTS',
3915: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
3916: p_batch_id,
3917: s_interface_line_id,
3918: 'PON_AUC_PB_POS_OR_ZERO',
3919: p_userid,

Line 3972: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),

3968: ENTITY_MESSAGE_CODE)
3969: VALUES
3970: (p_interface_type,
3971: 'PON_BID_SHIPMENTS',
3972: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
3973: p_batch_id,
3974: s_interface_line_id,
3975: 'PON_AUC_PB_INVALID_BID_PREC' || p_suffix,
3976: p_userid,

Line 4195: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),

4191: ENTITY_MESSAGE_CODE)
4192: VALUES
4193: (p_interface_type,
4194: 'PON_BID_SHIPMENTS',
4195: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
4196: p_batch_id,
4197: s_interface_line_id,
4198: 'PON_INVALID_PRICE_DISCOUNT',
4199: p_userid,

Line 4250: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),

4246: ENTITY_MESSAGE_CODE)
4247: VALUES
4248: (p_interface_type,
4249: 'PON_BID_SHIPMENTS',
4250: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
4251: p_batch_id,
4252: s_interface_line_id,
4253: 'PON_AUC_FROMDATE_AFTER_CURDATE',
4254: p_userid,

Line 4304: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),

4300: ENTITY_MESSAGE_CODE)
4301: VALUES
4302: (p_interface_type,
4303: 'PON_BID_SHIPMENTS',
4304: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
4305: p_batch_id,
4306: s_interface_line_id,
4307: 'PON_AUC_BAD_PB_EFF_FDATE_2',
4308: p_userid,

Line 4359: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),

4355: ENTITY_MESSAGE_CODE)
4356: VALUES
4357: (p_interface_type,
4358: 'PON_BID_SHIPMENTS',
4359: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
4360: p_batch_id,
4361: s_interface_line_id,
4362: 'PON_AUC_BAD_PB_EFF_FDATE_3',
4363: p_userid,

Line 4414: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),

4410: ENTITY_MESSAGE_CODE)
4411: VALUES
4412: (p_interface_type,
4413: 'PON_BID_SHIPMENTS',
4414: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
4415: p_batch_id,
4416: s_interface_line_id,
4417: 'PON_AUC_BAD_PB_EFF_FDATE_1',
4418: p_userid,

Line 4468: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),

4464: ENTITY_MESSAGE_CODE)
4465: VALUES
4466: (p_interface_type,
4467: 'PON_BID_SHIPMENTS',
4468: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
4469: p_batch_id,
4470: s_interface_line_id,
4471: 'PON_AUC_TODATE_AFTER_CURDATE',
4472: p_userid,

Line 4523: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),

4519: ENTITY_MESSAGE_CODE)
4520: VALUES
4521: (p_interface_type,
4522: 'PON_BID_SHIPMENTS',
4523: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
4524: p_batch_id,
4525: s_interface_line_id,
4526: 'PON_AUC_BAD_PB_EFF_TDATE_2',
4527: p_userid,

Line 4578: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),

4574: ENTITY_MESSAGE_CODE)
4575: VALUES
4576: (p_interface_type,
4577: 'PON_BID_SHIPMENTS',
4578: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
4579: p_batch_id,
4580: s_interface_line_id,
4581: 'PON_AUC_BAD_PB_EFF_TDATE_3',
4582: p_userid,

Line 4633: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),

4629: ENTITY_MESSAGE_CODE)
4630: VALUES
4631: (p_interface_type,
4632: 'PON_BID_SHIPMENTS',
4633: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
4634: p_batch_id,
4635: s_interface_line_id ,
4636: 'PON_AUC_BAD_PB_EFF_TDATE_1',
4637: p_userid,

Line 4741: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),

4737: ENTITY_MESSAGE_CODE)
4738: VALUES
4739: (p_interface_type,
4740: 'PON_BID_SHIPMENTS',
4741: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
4742: p_batch_id,
4743: s_interface_line_id,
4744: 'PON_AUC_INVALID_EFF_DATES',
4745: p_userid,

Line 4794: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),

4790: ENTITY_MESSAGE_CODE)
4791: VALUES
4792: (p_interface_type,
4793: 'PON_BID_SHIPMENTS',
4794: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
4795: p_batch_id,
4796: s_interface_line_id,
4797: 'PON_AUC_PB_PRICE_REQ',
4798: p_userid,

Line 4995: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),

4991: ENTITY_MESSAGE_CODE)
4992: VALUES
4993: (p_interface_type,
4994: 'PON_BID_SHIPMENTS',
4995: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
4996: p_batch_id,
4997: s_interface_line_id,
4998: 'PON_AUCTS_PT_MIN_QUANTITY_REQ',
4999: p_userid,

Line 5060: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),

5056: )
5057: VALUES
5058: (p_interface_type,
5059: 'PON_BID_SHIPMENTS',
5060: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5061: p_batch_id,
5062: s_interface_line_id,
5063: 'PON_AUCTS_PT_MAX_QUANTITY_REQ',
5064: p_userid,

Line 5124: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),

5120: )
5121: VALUES
5122: (p_interface_type,
5123: 'PON_BID_SHIPMENTS',
5124: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
5125: p_batch_id,
5126: s_interface_line_id,
5127: 'PON_AUCTS_PT_QUANTITY_POSITIVE',
5128: p_userid,

Line 5188: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),

5184: )
5185: VALUES
5186: (p_interface_type,
5187: 'PON_BID_SHIPMENTS',
5188: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5189: p_batch_id,
5190: s_interface_line_id,
5191: 'PON_AUCTS_PT_QUANTITY_POSITIVE',
5192: p_userid,

Line 5251: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),

5247: )
5248: VALUES
5249: (p_interface_type,
5250: 'PON_BID_SHIPMENTS',
5251: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5252: p_batch_id,
5253: s_interface_line_id,
5254: 'PON_QT_MAX_MIN_QTY_ERR',
5255: p_userid,

Line 5319: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),

5315: ENTITY_MESSAGE_CODE)
5316: VALUES
5317: (p_interface_type,
5318: 'PON_BID_SHIPMENTS',
5319: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
5320: p_batch_id,
5321: s_interface_line_id,
5322: 'PON_AUC_OVERLAP_RANGES_QT',
5323: p_userid,

Line 5393: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),

5389: ENTITY_MESSAGE_CODE)
5390: VALUES
5391: (p_interface_type,
5392: 'PON_BID_SHIPMENTS',
5393: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5394: p_batch_id,
5395: s_interface_line_id,
5396: 'PON_AUC_OVERLAP_RANGES_QT',
5397: p_userid,

Line 5452: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),

5448: )
5449: VALUES
5450: (p_interface_type,
5451: 'PON_BID_SHIPMENTS',
5452: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
5453: p_batch_id,
5454: s_interface_line_id,
5455: 'PON_AUC_PT_PRICE_REQ',
5456: p_userid,

Line 5514: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),

5510: )
5511: VALUES
5512: (p_interface_type,
5513: 'PON_BID_SHIPMENTS',
5514: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
5515: p_batch_id,
5516: s_interface_line_id,
5517: 'PON_AUCTS_QT_PRICE_POSITIVE',
5518: p_userid,

Line 5572: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),

5568: )
5569: VALUES
5570: (p_interface_type,
5571: 'PON_BID_SHIPMENTS',
5572: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
5573: p_batch_id,
5574: s_interface_line_id,
5575: 'PON_AUC_QT_INVALID_BID_PREC',
5576: p_userid,

Line 5637: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),

5633: )
5634: VALUES
5635: (p_interface_type,
5636: 'PON_BID_ITEM_PRICES',
5637: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5638: p_batch_id,
5639: s_interface_line_id,
5640: 'PON_BID_QTY_NOT_WITHIN_TIERS',
5641: p_userid,

Line 5699: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),

5695: )
5696: VALUES
5697: (p_interface_type,
5698: 'PON_BID_ITEM_PRICES',
5699: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
5700: p_batch_id,
5701: s_interface_line_id,
5702: 'PON_BID_PRICE_NOT_WITHIN_TIERS',
5703: p_userid,

Line 5890: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),

5886: WORKSHEET_SEQUENCE_NUMBER,
5887: ENTITY_MESSAGE_CODE)
5888: VALUES
5889: (p_interface_type,
5890: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
5891: 'PON_BID_PRICE_DIFFERENTIALS',
5892: p_batch_id,
5893: s_interface_line_id,
5894: 'PON_AUC_PD_VALUE_REQ' || p_suffix,

Line 5952: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),

5948: WORKSHEET_SEQUENCE_NUMBER,
5949: ENTITY_MESSAGE_CODE)
5950: VALUES
5951: (p_interface_type,
5952: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
5953: 'PON_BID_PRICE_DIFFERENTIALS',
5954: p_batch_id,
5955: s_interface_line_id ,
5956: 'PON_AUC_PD_VAL_NONENTERABLE',

Line 6014: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),

6010: WORKSHEET_SEQUENCE_NUMBER,
6011: ENTITY_MESSAGE_CODE)
6012: VALUES
6013: (p_interface_type,
6014: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
6015: 'PON_BID_PRICE_DIFFERENTIALS',
6016: p_batch_id,
6017: s_interface_line_id,
6018: 'PON_AUC_PD_INVALID_MULT' || p_suffix,

Line 6079: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),

6075: WORKSHEET_SEQUENCE_NUMBER,
6076: ENTITY_MESSAGE_CODE)
6077: VALUES
6078: (p_interface_type,
6079: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6080: 'PON_BID_PRICE_DIFFERENTIALS',
6081: p_batch_id,
6082: s_interface_line_id,
6083: 'PON_AUC_PB_PD_VALUE_REQ' || p_suffix,

Line 6143: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),

6139: WORKSHEET_SEQUENCE_NUMBER,
6140: ENTITY_MESSAGE_CODE)
6141: VALUES
6142: (p_interface_type,
6143: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6144: 'PON_BID_PRICE_DIFFERENTIALS',
6145: p_batch_id,
6146: s_interface_line_id,
6147: 'PON_AUC_PB_PD_VAL_NONENTERABLE',

Line 6209: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),

6205: ENTITY_MESSAGE_CODE
6206: )
6207: VALUES
6208: (p_interface_type,
6209: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6210: 'PON_BID_PRICE_DIFFERENTIALS',
6211: p_batch_id,
6212: s_interface_line_id,
6213: 'PON_AUC_PB_PD_INVALID_MULT' || p_suffix,

Line 6336: fnd_message.get_string('PON','PON_AUCTS_PAYITEM_NUMBER'),

6332: TOKEN2_NAME,
6333: TOKEN2_VALUE)
6334: SELECT
6335: p_interface_type,
6336: fnd_message.get_string('PON','PON_AUCTS_PAYITEM_NUMBER'),
6337: 'PON_BID_ITEM_PRICES',
6338: p_batch_id,
6339: 'PON_PYMT_NUM_NOT_UNQ',
6340: p_userid,