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 947: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_DEC' || p_suffix),

943: ENTITY_MESSAGE_CODE)
944: VALUES
945: (p_interface_type,
946: decode(p_spreadsheet, g_xml_upload_mode,
947: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_DEC' || p_suffix),
948: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
949: 'PON_BID_ITEM_PRICES',
950: p_batch_id,
951: s_interface_line_id,

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

944: VALUES
945: (p_interface_type,
946: decode(p_spreadsheet, g_xml_upload_mode,
947: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_DEC' || p_suffix),
948: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
949: 'PON_BID_ITEM_PRICES',
950: p_batch_id,
951: s_interface_line_id,
952: 'PON_AUCTS_MIN_DEC_NULL' || p_suffix,

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

1058: ENTITY_MESSAGE_CODE)
1059: VALUES
1060: (p_interface_type,
1061: 'PON_BID_ITEM_PRICES',
1062: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1063: p_batch_id,
1064: s_interface_line_id,
1065: 'PON_BID_PRICE_REQUIRED' || p_suffix,
1066: p_userid,

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

1110: ENTITY_MESSAGE_CODE)
1111: VALUES
1112: (p_interface_type,
1113: 'PON_BID_ITEM_PRICES',
1114: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1115: p_batch_id,
1116: s_interface_line_id,
1117: 'PON_BID_QUANTITY_REQUIRED' || p_suffix,
1118: p_userid,

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

1163: WORKSHEET_SEQUENCE_NUMBER,
1164: ENTITY_MESSAGE_CODE)
1165: VALUES
1166: (p_interface_type,
1167: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1168: 'PON_BID_ITEM_PRICES',
1169: p_batch_id,
1170: s_interface_line_id,
1171: 'PON_AUC_BIDQTY_NEG' || p_suffix,

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

1218: WORKSHEET_SEQUENCE_NUMBER,
1219: ENTITY_MESSAGE_CODE)
1220: VALUES
1221: (p_interface_type,
1222: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1223: 'PON_BID_ITEM_PRICES',
1224: p_batch_id,
1225: s_interface_line_id,
1226: 'PON_INVALID_BID_QTY' || p_suffix,

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

1278: WORKSHEET_SEQUENCE_NUMBER,
1279: ENTITY_MESSAGE_CODE)
1280: VALUES
1281: (p_interface_type,
1282: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
1283: 'PON_BID_ITEM_PRICES',
1284: p_batch_id,
1285: s_interface_line_id,
1286: 'PON_AUC_PROMISED_DATE_REQ',

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

1337: WORKSHEET_SEQUENCE_NUMBER,
1338: ENTITY_MESSAGE_CODE)
1339: VALUES
1340: (p_interface_type,
1341: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
1342: 'PON_BID_ITEM_PRICES',
1343: p_batch_id,
1344: s_interface_line_id,
1345: 'PON_AUC_PDATE_TOO_EARLY',

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

1394: WORKSHEET_SEQUENCE_NUMBER,
1395: ENTITY_MESSAGE_CODE)
1396: VALUES
1397: (p_interface_type,
1398: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
1399: 'PON_BID_ITEM_PRICES',
1400: p_batch_id,
1401: s_interface_line_id,
1402: 'PON_CLM_PROMISE_POPDT_LINE_VAL',

Line 1455: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_END_DATE'),

1451: WORKSHEET_SEQUENCE_NUMBER,
1452: ENTITY_MESSAGE_CODE)
1453: VALUES
1454: (p_interface_type,
1455: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_END_DATE'),
1456: 'PON_BID_ITEM_PRICES',
1457: p_batch_id,
1458: s_interface_line_id,
1459: 'PON_CLM_PROMISE_POP_ENDDT_REQ',

Line 1511: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),

1507: WORKSHEET_SEQUENCE_NUMBER,
1508: ENTITY_MESSAGE_CODE)
1509: VALUES
1510: (p_interface_type,
1511: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),
1512: 'PON_BID_ITEM_PRICES',
1513: p_batch_id,
1514: s_interface_line_id,
1515: 'PON_CLM_PROMISE_POP_STDT_REQ',

Line 1569: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),

1565: WORKSHEET_SEQUENCE_NUMBER,
1566: ENTITY_MESSAGE_CODE)
1567: VALUES
1568: (p_interface_type,
1569: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),
1570: 'PON_BID_ITEM_PRICES',
1571: p_batch_id,
1572: s_interface_line_id,
1573: 'PON_CLM_PROMISE_POP_DATE_VALX',

Line 1627: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),

1623: WORKSHEET_SEQUENCE_NUMBER,
1624: ENTITY_MESSAGE_CODE)
1625: VALUES
1626: (p_interface_type,
1627: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),
1628: 'PON_BID_ITEM_PRICES',
1629: p_batch_id,
1630: s_interface_line_id,
1631: 'PON_BID_POP_START_BEF_TODAY',

Line 1685: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_END_DATE'),

1681: WORKSHEET_SEQUENCE_NUMBER,
1682: ENTITY_MESSAGE_CODE)
1683: VALUES
1684: (p_interface_type,
1685: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_END_DATE'),
1686: 'PON_BID_ITEM_PRICES',
1687: p_batch_id,
1688: s_interface_line_id,
1689: 'PON_BID_POP_END_BEF_TODAY',

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

1740: WORKSHEET_SEQUENCE_NUMBER,
1741: ENTITY_MESSAGE_CODE)
1742: VALUES
1743: (p_interface_type,
1744: fnd_message.get_string('PON', 'PON_CLM_PROMISE_PERIOD'),
1745: 'PON_BID_ITEM_PRICES',
1746: p_batch_id,
1747: s_interface_line_id,
1748: 'PON_BID_INV_PERIOD',

Line 1802: fnd_message.get_string('PON', 'PON_CLM_PROMISE_PERIOD'),

1798: WORKSHEET_SEQUENCE_NUMBER,
1799: ENTITY_MESSAGE_CODE)
1800: VALUES
1801: (p_interface_type,
1802: fnd_message.get_string('PON', 'PON_CLM_PROMISE_PERIOD'),
1803: 'PON_BID_ITEM_PRICES',
1804: p_batch_id,
1805: s_interface_line_id,
1806: 'PON_BID_INV_POP_DUR',

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

1852: WORKSHEET_SEQUENCE_NUMBER,
1853: ENTITY_MESSAGE_CODE)
1854: VALUES
1855: (p_interface_type,
1856: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),
1857: 'PON_BID_ITEM_PRICES',
1858: p_batch_id,
1859: s_interface_line_id,
1860: 'PON_AUC_MINREL_POS_ZERO' || p_suffix,

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

1907: WORKSHEET_SEQUENCE_NUMBER,
1908: ENTITY_MESSAGE_CODE)
1909: VALUES
1910: (p_interface_type,
1911: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),
1912: 'PON_BID_ITEM_PRICES',
1913: p_batch_id,
1914: s_interface_line_id,
1915: 'PON_AUC_MINREL_MIN_PREC' || p_suffix,

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

1969: WORKSHEET_SEQUENCE_NUMBER,
1970: ENTITY_MESSAGE_CODE)
1971: VALUES
1972: (p_interface_type,
1973: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),
1974: 'PON_BID_ITEM_PRICES',
1975: p_batch_id,
1976: s_interface_line_id,
1977: 'PON_LINEPRICE_MUST_BE_POS',

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

2032: WORKSHEET_SEQUENCE_NUMBER,
2033: ENTITY_MESSAGE_CODE)
2034: VALUES
2035: (p_interface_type,
2036: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),
2037: 'PON_BID_ITEM_PRICES',
2038: p_batch_id,
2039: s_interface_line_id,
2040: 'PON_LINEPRICE_MIN_PREC' || p_suffix,

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

2091: WORKSHEET_SEQUENCE_NUMBER,
2092: ENTITY_MESSAGE_CODE)
2093: VALUES
2094: (p_interface_type,
2095: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2096: 'PON_BID_ITEM_PRICES',
2097: p_batch_id,
2098: s_interface_line_id,
2099: 'PON_BID_PRICE_REQUIRED' || p_suffix,

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

2200: WORKSHEET_SEQUENCE_NUMBER,
2201: ENTITY_MESSAGE_CODE)
2202: VALUES
2203: (p_interface_type,
2204: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2205: 'PON_BID_ITEM_PRICES',
2206: p_batch_id,
2207: s_interface_line_id,
2208: decode(p_trans_view, 'N',

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

2265: WORKSHEET_SEQUENCE_NUMBER,
2266: ENTITY_MESSAGE_CODE)
2267: VALUES
2268: (p_interface_type,
2269: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2270: 'PON_BID_ITEM_PRICES',
2271: p_batch_id,
2272: s_interface_line_id,
2273: 'PON_AUCTS_BIDPRICE_MIN_PREC' || p_suffix,

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

2329: WORKSHEET_SEQUENCE_NUMBER,
2330: ENTITY_MESSAGE_CODE)
2331: VALUES
2332: (p_interface_type,
2333: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2334: 'PON_BID_ITEM_PRICES',
2335: p_batch_id,
2336: s_interface_line_id,
2337: 'PON_AUCTS_BIDPRICE_MIN_PREC' || p_suffix,

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

2391: WORKSHEET_SEQUENCE_NUMBER,
2392: ENTITY_MESSAGE_CODE)
2393: VALUES
2394: (p_interface_type,
2395: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2396: 'PON_BID_ITEM_PRICES',
2397: p_batch_id,
2398: s_interface_line_id,
2399: 'PON_LINE_BIDPRICE_INVALID_1' || p_suffix,

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

2452: VALUES
2453: (p_interface_type,
2454: decode(p_spreadsheet,
2455: g_xml_upload_mode,
2456: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2457: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2458: 'PON_BID_ITEM_PRICES',
2459: p_batch_id,
2460: s_interface_line_id,

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

2453: (p_interface_type,
2454: decode(p_spreadsheet,
2455: g_xml_upload_mode,
2456: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2457: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2458: 'PON_BID_ITEM_PRICES',
2459: p_batch_id,
2460: s_interface_line_id,
2461: 'PON_AUC_LIMPRICE_MUST_BE_POS',

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

2514: VALUES
2515: (p_interface_type,
2516: decode(p_spreadsheet,
2517: g_xml_upload_mode,
2518: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2519: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2520: 'PON_BID_ITEM_PRICES',
2521: p_batch_id,
2522: s_interface_line_id,

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

2515: (p_interface_type,
2516: decode(p_spreadsheet,
2517: g_xml_upload_mode,
2518: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2519: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2520: 'PON_BID_ITEM_PRICES',
2521: p_batch_id,
2522: s_interface_line_id,
2523: 'PON_AUCTS_LIMIT_MIN_PREC' || p_suffix,

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

2597: WORKSHEET_SEQUENCE_NUMBER,
2598: ENTITY_MESSAGE_CODE)
2599: VALUES
2600: (p_interface_type,
2601: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2602: 'PON_BID_ITEM_PRICES',
2603: p_batch_id,
2604: s_interface_line_id,
2605: 'PON_BP_LTE_BIDSTARTPRICE' || p_suffix,

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

2678: ENTITY_MESSAGE_CODE
2679: )
2680: VALUES
2681: (p_interface_type,
2682: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2683: 'PON_BID_ITEM_PRICES',
2684: p_batch_id,
2685: s_interface_line_id,
2686: 'PON_MIN_BID_DECREMENT' || p_suffix,

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

2754: ENTITY_MESSAGE_CODE
2755: )
2756: VALUES
2757: (p_interface_type,
2758: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2759: 'PON_BID_ITEM_PRICES',
2760: p_batch_id,
2761: s_interface_line_id,
2762: 'PON_MIN_BESTBID_DECREMENT' || p_suffix,

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

2822: WORKSHEET_SEQUENCE_NUMBER,
2823: ENTITY_MESSAGE_CODE)
2824: VALUES
2825: (p_interface_type,
2826: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2827: 'PON_BID_ITEM_PRICES',
2828: p_batch_id,
2829: s_interface_line_id,
2830: decode(p_bid_decr_method,'BEST_PRICE','PON_BESTBID_PRICE_LOWER','PON_BID_PRICE_LOWER') || p_suffix,

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

2888: VALUES
2889: (p_interface_type,
2890: decode(p_spreadsheet,
2891: g_xml_upload_mode,
2892: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2893: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2894: 'PON_BID_ITEM_PRICES',
2895: p_batch_id,
2896: s_interface_line_id,

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

2889: (p_interface_type,
2890: decode(p_spreadsheet,
2891: g_xml_upload_mode,
2892: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2893: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2894: 'PON_BID_ITEM_PRICES',
2895: p_batch_id,
2896: s_interface_line_id,
2897: 'PON_AUCTS_LIMIT_MIN_LESS_PRI' || p_suffix,

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

3156: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3157: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3158: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3159: VALUES
3160: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
3161: p_batch_id, s_interface_line_id, 'PON_RTNG_RATE_WRONG_L', --2
3162: p_userid, sysdate, p_userid, --3
3163: sysdate, p_request_id, 'BID_ITEMS', --4
3164: 'RetainageRatePercent', retainage_rate_percent, 'NUM', --5

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

3182: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3183: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3184: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3185: VALUES
3186: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
3187: p_batch_id, s_interface_line_id, 'PON_MAX_RTNG_WRONG_L', --2
3188: p_userid, sysdate, p_userid, --3
3189: sysdate, p_request_id, 'BID_ITEMS', --4
3190: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'NUM', --5

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

3208: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3209: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3210: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3211: VALUES
3212: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
3213: p_batch_id, s_interface_line_id, 'PON_ADV_AMT_WRONG_L', --2
3214: p_userid, sysdate, p_userid, --3
3215: sysdate, p_request_id, 'BID_ITEMS', --4
3216: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'NUM', --5

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

3235: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3236: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3237: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3238: VALUES
3239: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
3240: p_batch_id, s_interface_line_id, 'PON_PROG_PYMT_RATE_WRONG_L', --2
3241: p_userid, sysdate, p_userid, --3
3242: sysdate, p_request_id, 'BID_ITEMS', --4
3243: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'NUM', --5

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

3262: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3263: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3264: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3265: VALUES
3266: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3267: p_batch_id, s_interface_line_id, 'PON_RECOUP_RATE_WRONG', --2
3268: p_userid, sysdate, p_userid, --3
3269: sysdate, p_request_id, 'BID_ITEMS', --4
3270: 'RecoupmentRatePercent', recoupment_rate_percent, 'NUM', --5

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

3290: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3291: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
3292: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3293: VALUES
3294: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
3295: p_batch_id, s_interface_line_id, 'PON_PROG_PYMT_NEEDED_L', --2
3296: p_userid, sysdate, p_userid, --3
3297: sysdate, p_request_id, 'BID_ITEMS', --4
3298: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'TXT', --5

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

3320: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3321: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3322: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3323: VALUES
3324: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
3325: p_batch_id, s_interface_line_id, 'PON_RETAINAGE_NEEDED_L', --2
3326: p_userid, sysdate, p_userid, --3
3327: sysdate, p_request_id, 'BID_ITEMS', --4
3328: 'RetainageRatePercent', retainage_rate_percent, 'TXT', --5

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

3350: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3351: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
3352: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3353: VALUES
3354: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
3355: p_batch_id, s_interface_line_id, 'PON_MAX_RETAINAGE_NEEDED_L', --2
3356: p_userid, sysdate, p_userid, --3
3357: sysdate, p_request_id, 'BID_ITEMS', --4
3358: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'TXT', --5

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

3383: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3384: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3385: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3386: VALUES
3387: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3388: p_batch_id, s_interface_line_id, 'PON_RECUP_RATE_NEEDED_L', --2
3389: p_userid, sysdate, p_userid, --3
3390: sysdate, p_request_id, 'BID_ITEMS', --4
3391: 'RecoupmentRatePercent', recoupment_rate_percent, 'TXT', --5

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

3414: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3415: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3416: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3417: VALUES
3418: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
3419: p_batch_id, s_interface_line_id, 'PON_ADVANCE_AMT_NEEDED_L', --2
3420: p_userid, sysdate, p_userid, --3
3421: sysdate, p_request_id, 'BID_ITEMS', --4
3422: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'TXT', --5

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

3483: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3484: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, --7
3485: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3486: VALUES
3487: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
3488: p_batch_id, s_interface_line_id, 'PON_ADV_AMT_MORE_L', --2
3489: p_userid, sysdate, p_userid, --3
3490: sysdate, p_request_id, 'BID_ITEMS', --4
3491: NULL, bid_curr_advance_amount, 'NUM', --5

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

3516: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3517: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,--7
3518: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3519: VALUES
3520: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3521: p_batch_id, s_interface_line_id, 'PON_RECOUP_LESS_THAN_PYMT_L', --2
3522: p_userid, sysdate, p_userid, --3
3523: sysdate, p_request_id, 'BID_ITEMS', --4
3524: NULL, recoupment_rate_percent, 'NUM', --5

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

3545: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3546: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,--7
3547: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3548: VALUES
3549: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3550: p_batch_id, s_interface_line_id, 'PON_RECOUP_LESS_THAN_ADV_L', --2
3551: p_userid, sysdate, p_userid, --3
3552: sysdate, p_request_id, 'BID_ITEMS', --4
3553: NULL, recoupment_rate_percent, 'NUM', --5

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

3639: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3640: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
3641: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3642: VALUES
3643: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
3644: p_batch_id, s_interface_line_id, 'PON_LINEAMT_INVALID_PRECISION', --2
3645: p_userid, sysdate, p_userid, --3
3646: sysdate, p_request_id, 'BID_ITEMS', --4
3647: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'NUM', --5

Line 3651: Decode(g_is_fed,'Y',s_clm_line_num_display,s_document_disp_line_number), 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'),

3647: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'NUM', --5
3648: p_auc_header_id, p_bid_number, s_line_number, --6
3649: NULL, g_exp_date, 'LINENUM', --7
3650: --s_document_disp_line_number,
3651: Decode(g_is_fed,'Y',s_clm_line_num_display,s_document_disp_line_number), 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'),
3652: s_worksheet_name, s_worksheet_sequence_number, s_entity_message_code) --8
3653: -- bid_curr_max_retainage_amt should not exceed currency precision
3654: WHEN
3655: -- added by Allen Yang for Surrogate Bid 2008/09/03

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

3667: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3668: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3669: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3670: VALUES
3671: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
3672: p_batch_id, s_interface_line_id, 'PON_LINEAMT_INVALID_PRECISION', --2
3673: p_userid, sysdate, p_userid, --3
3674: sysdate, p_request_id, 'BID_ITEMS', --4
3675: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'NUM', --5

Line 3679: Decode(g_is_fed,'Y',s_clm_line_num_display,s_document_disp_line_number), 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'),

3675: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'NUM', --5
3676: p_auc_header_id, p_bid_number, s_line_number, --6
3677: NULL, g_exp_date, 'LINENUM', --7
3678: --s_document_disp_line_number,
3679: Decode(g_is_fed,'Y',s_clm_line_num_display,s_document_disp_line_number), 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'),
3680: s_worksheet_name, s_worksheet_sequence_number, s_entity_message_code) --8
3681: -- progress_pymt_rate_percent should not exceed currency precision
3682: WHEN
3683: -- added by Allen Yang for Surrogate Bid 2008/09/03

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

3695: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3696: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3697: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3698: VALUES
3699: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
3700: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3701: p_userid, sysdate, p_userid, --3
3702: sysdate, p_request_id, 'BID_ITEMS', --4
3703: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'NUM', --5

Line 3707: Decode(g_is_fed,'Y',s_clm_line_num_display,s_document_disp_line_number), 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'),

3703: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'NUM', --5
3704: p_auc_header_id, p_bid_number, s_line_number, --6
3705: NULL, g_exp_date, 'LINENUM', --7
3706: --s_document_disp_line_number,
3707: Decode(g_is_fed,'Y',s_clm_line_num_display,s_document_disp_line_number), 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'),
3708: s_worksheet_name, s_worksheet_sequence_number, s_entity_message_code) --8
3709: -- retainage_rate_percent should not exceed currency precision
3710: WHEN
3711: -- added by Allen Yang for Surrogate Bid 2008/09/03

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

3723: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3724: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3725: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3726: VALUES
3727: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
3728: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3729: p_userid, sysdate, p_userid, --3
3730: sysdate, p_request_id, 'BID_ITEMS', --4
3731: 'RetainageRatePercent', retainage_rate_percent, 'NUM', --5

Line 3735: Decode(g_is_fed,'Y',s_clm_line_num_display,s_document_disp_line_number), 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_RETAINAGE_RATE'),

3731: 'RetainageRatePercent', retainage_rate_percent, 'NUM', --5
3732: p_auc_header_id, p_bid_number, s_line_number, --6
3733: NULL, g_exp_date, 'LINENUM', --7
3734: --s_document_disp_line_number,
3735: Decode(g_is_fed,'Y',s_clm_line_num_display,s_document_disp_line_number), 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_RETAINAGE_RATE'),
3736: s_worksheet_name, s_worksheet_sequence_number, s_entity_message_code) --8
3737: -- recoupment_rate_percent should not exceed currency precision
3738: WHEN
3739: -- added by Allen Yang for Surrogate Bid 2008/09/03

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

3751: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3752: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3753: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME,WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3754: VALUES
3755: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3756: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3757: p_userid, sysdate, p_userid, --3
3758: sysdate, p_request_id, 'BID_ITEMS', --4
3759: 'RecoupmentRatePercent', recoupment_rate_percent, 'NUM', --5

Line 3763: Decode(g_is_fed,'Y',s_clm_line_num_display,s_document_disp_line_number), 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_RECOUPMENT_RATE'),

3759: 'RecoupmentRatePercent', recoupment_rate_percent, 'NUM', --5
3760: p_auc_header_id, p_bid_number, s_line_number, --6
3761: NULL, g_exp_date, 'LINENUM', --7
3762: --s_document_disp_line_number,
3763: Decode(g_is_fed,'Y',s_clm_line_num_display,s_document_disp_line_number), 'ATTRIBUTENAME', fnd_message.get_string('PON','PON_RECOUPMENT_RATE'),
3764: s_worksheet_name, s_worksheet_sequence_number, s_entity_message_code) --8
3765: SELECT
3766: al.group_type s_group_type,
3767: bl.quantity s_bid_quantity,

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

3859: WORKSHEET_SEQUENCE_NUMBER,
3860: ENTITY_MESSAGE_CODE)
3861: VALUES
3862: (p_interface_type,
3863: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3864: 'PON_BID_ATTRIBUTE_VALUES',
3865: p_batch_id,
3866: s_interface_line_id,
3867: 'PON_AUC_HDR_ATTR_REQ' || p_suffix,

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

3916: WORKSHEET_SEQUENCE_NUMBER,
3917: ENTITY_MESSAGE_CODE)
3918: VALUES
3919: (p_interface_type,
3920: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3921: 'PON_BID_ATTRIBUTE_VALUES',
3922: p_batch_id,
3923: s_interface_line_id,
3924: 'PON_AUC_INVALID_ATTR_VALUE' || p_suffix,

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

4034: WORKSHEET_SEQUENCE_NUMBER,
4035: ENTITY_MESSAGE_CODE)
4036: VALUES
4037: (p_interface_type,
4038: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
4039: 'PON_BID_ATTRIBUTE_VALUES',
4040: p_batch_id,
4041: s_interface_line_id,
4042: 'PON_AUC_ATTR_VALUE_REQ' || p_suffix,

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

4095: WORKSHEET_SEQUENCE_NUMBER,
4096: ENTITY_MESSAGE_CODE)
4097: VALUES
4098: (p_interface_type,
4099: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
4100: 'PON_BID_ATTRIBUTE_VALUES',
4101: p_batch_id,
4102: s_interface_line_id,
4103: 'PON_AUC_INVALID_ATTR_VALUE' || p_suffix,

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

4487: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, to_char(null)) s_worksheet_name,
4488: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_PRICE_ELEMENTS', to_char(null)) s_entity_message_code,
4489: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
4490: decode(p_spreadsheet, g_xml_upload_mode,
4491: fnd_message.get_string('PON', 'PON_AUCTS_ATTR_BID_VALUE' || p_suffix),
4492: fnd_message.get_string('PON', 'PON_AUC_PE_BID_VALUE_REQ' || p_suffix)) s_column_name,
4493: al.line_num_display s_clm_line_num_display
4494: FROM pon_bid_price_elements bpf
4495: , pon_auction_item_prices_all al

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

4488: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_PRICE_ELEMENTS', to_char(null)) s_entity_message_code,
4489: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
4490: decode(p_spreadsheet, g_xml_upload_mode,
4491: fnd_message.get_string('PON', 'PON_AUCTS_ATTR_BID_VALUE' || p_suffix),
4492: fnd_message.get_string('PON', 'PON_AUC_PE_BID_VALUE_REQ' || p_suffix)) s_column_name,
4493: al.line_num_display s_clm_line_num_display
4494: FROM pon_bid_price_elements bpf
4495: , pon_auction_item_prices_all al
4496: , pon_bid_item_prices bl

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

4563: ENTITY_MESSAGE_CODE)
4564: VALUES
4565: (p_interface_type,
4566: 'PON_BID_SHIPMENTS',
4567: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_QUANTITY'), null ),
4568: p_batch_id,
4569: s_interface_line_id,
4570: 'PON_AUCTS_PB_QUANTITY_POSITIVE',
4571: p_userid,

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

4620: ENTITY_MESSAGE_CODE)
4621: VALUES
4622: (p_interface_type,
4623: 'PON_BID_SHIPMENTS',
4624: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
4625: p_batch_id,
4626: s_interface_line_id,
4627: 'PON_AUC_PB_POS_OR_ZERO',
4628: p_userid,

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

4678: ENTITY_MESSAGE_CODE)
4679: VALUES
4680: (p_interface_type,
4681: 'PON_BID_SHIPMENTS',
4682: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
4683: p_batch_id,
4684: s_interface_line_id,
4685: 'PON_AUC_PB_INVALID_BID_PREC' || p_suffix,
4686: p_userid,

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

4905: ENTITY_MESSAGE_CODE)
4906: VALUES
4907: (p_interface_type,
4908: 'PON_BID_SHIPMENTS',
4909: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
4910: p_batch_id,
4911: s_interface_line_id,
4912: 'PON_INVALID_PRICE_DISCOUNT',
4913: p_userid,

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

4961: ENTITY_MESSAGE_CODE)
4962: VALUES
4963: (p_interface_type,
4964: 'PON_BID_SHIPMENTS',
4965: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
4966: p_batch_id,
4967: s_interface_line_id,
4968: 'PON_AUC_FROMDATE_AFTER_CURDATE',
4969: p_userid,

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

5016: ENTITY_MESSAGE_CODE)
5017: VALUES
5018: (p_interface_type,
5019: 'PON_BID_SHIPMENTS',
5020: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
5021: p_batch_id,
5022: s_interface_line_id,
5023: 'PON_AUC_BAD_PB_EFF_FDATE_2',
5024: p_userid,

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

5072: ENTITY_MESSAGE_CODE)
5073: VALUES
5074: (p_interface_type,
5075: 'PON_BID_SHIPMENTS',
5076: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
5077: p_batch_id,
5078: s_interface_line_id,
5079: 'PON_AUC_BAD_PB_EFF_FDATE_3',
5080: p_userid,

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

5128: ENTITY_MESSAGE_CODE)
5129: VALUES
5130: (p_interface_type,
5131: 'PON_BID_SHIPMENTS',
5132: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
5133: p_batch_id,
5134: s_interface_line_id,
5135: 'PON_AUC_BAD_PB_EFF_FDATE_1',
5136: p_userid,

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

5183: ENTITY_MESSAGE_CODE)
5184: VALUES
5185: (p_interface_type,
5186: 'PON_BID_SHIPMENTS',
5187: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
5188: p_batch_id,
5189: s_interface_line_id,
5190: 'PON_AUC_TODATE_AFTER_CURDATE',
5191: p_userid,

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

5239: ENTITY_MESSAGE_CODE)
5240: VALUES
5241: (p_interface_type,
5242: 'PON_BID_SHIPMENTS',
5243: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
5244: p_batch_id,
5245: s_interface_line_id,
5246: 'PON_AUC_BAD_PB_EFF_TDATE_2',
5247: p_userid,

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

5295: ENTITY_MESSAGE_CODE)
5296: VALUES
5297: (p_interface_type,
5298: 'PON_BID_SHIPMENTS',
5299: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
5300: p_batch_id,
5301: s_interface_line_id,
5302: 'PON_AUC_BAD_PB_EFF_TDATE_3',
5303: p_userid,

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

5351: ENTITY_MESSAGE_CODE)
5352: VALUES
5353: (p_interface_type,
5354: 'PON_BID_SHIPMENTS',
5355: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
5356: p_batch_id,
5357: s_interface_line_id ,
5358: 'PON_AUC_BAD_PB_EFF_TDATE_1',
5359: p_userid,

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

5461: ENTITY_MESSAGE_CODE)
5462: VALUES
5463: (p_interface_type,
5464: 'PON_BID_SHIPMENTS',
5465: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
5466: p_batch_id,
5467: s_interface_line_id,
5468: 'PON_AUC_INVALID_EFF_DATES',
5469: p_userid,

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

5515: ENTITY_MESSAGE_CODE)
5516: VALUES
5517: (p_interface_type,
5518: 'PON_BID_SHIPMENTS',
5519: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
5520: p_batch_id,
5521: s_interface_line_id,
5522: 'PON_AUC_PB_PRICE_REQ',
5523: p_userid,

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

5719: ENTITY_MESSAGE_CODE)
5720: VALUES
5721: (p_interface_type,
5722: 'PON_BID_SHIPMENTS',
5723: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
5724: p_batch_id,
5725: s_interface_line_id,
5726: 'PON_AUCTS_PT_MIN_QUANTITY_REQ',
5727: p_userid,

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

5785: )
5786: VALUES
5787: (p_interface_type,
5788: 'PON_BID_SHIPMENTS',
5789: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5790: p_batch_id,
5791: s_interface_line_id,
5792: 'PON_AUCTS_PT_MAX_QUANTITY_REQ',
5793: p_userid,

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

5850: )
5851: VALUES
5852: (p_interface_type,
5853: 'PON_BID_SHIPMENTS',
5854: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
5855: p_batch_id,
5856: s_interface_line_id,
5857: 'PON_AUCTS_PT_QUANTITY_POSITIVE',
5858: p_userid,

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

5915: )
5916: VALUES
5917: (p_interface_type,
5918: 'PON_BID_SHIPMENTS',
5919: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5920: p_batch_id,
5921: s_interface_line_id,
5922: 'PON_AUCTS_PT_QUANTITY_POSITIVE',
5923: p_userid,

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

5979: )
5980: VALUES
5981: (p_interface_type,
5982: 'PON_BID_SHIPMENTS',
5983: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5984: p_batch_id,
5985: s_interface_line_id,
5986: 'PON_QT_MAX_MIN_QTY_ERR',
5987: p_userid,

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

6048: ENTITY_MESSAGE_CODE)
6049: VALUES
6050: (p_interface_type,
6051: 'PON_BID_SHIPMENTS',
6052: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
6053: p_batch_id,
6054: s_interface_line_id,
6055: 'PON_AUC_OVERLAP_RANGES_QT',
6056: p_userid,

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

6123: ENTITY_MESSAGE_CODE)
6124: VALUES
6125: (p_interface_type,
6126: 'PON_BID_SHIPMENTS',
6127: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
6128: p_batch_id,
6129: s_interface_line_id,
6130: 'PON_AUC_OVERLAP_RANGES_QT',
6131: p_userid,

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

6183: )
6184: VALUES
6185: (p_interface_type,
6186: 'PON_BID_SHIPMENTS',
6187: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
6188: p_batch_id,
6189: s_interface_line_id,
6190: 'PON_AUC_PT_PRICE_REQ',
6191: p_userid,

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

6246: )
6247: VALUES
6248: (p_interface_type,
6249: 'PON_BID_SHIPMENTS',
6250: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
6251: p_batch_id,
6252: s_interface_line_id,
6253: 'PON_AUCTS_QT_PRICE_POSITIVE',
6254: p_userid,

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

6305: )
6306: VALUES
6307: (p_interface_type,
6308: 'PON_BID_SHIPMENTS',
6309: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
6310: p_batch_id,
6311: s_interface_line_id,
6312: 'PON_AUC_QT_INVALID_BID_PREC',
6313: p_userid,

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

6371: )
6372: VALUES
6373: (p_interface_type,
6374: 'PON_BID_ITEM_PRICES',
6375: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
6376: p_batch_id,
6377: s_interface_line_id,
6378: 'PON_BID_QTY_NOT_WITHIN_TIERS',
6379: p_userid,

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

6434: )
6435: VALUES
6436: (p_interface_type,
6437: 'PON_BID_ITEM_PRICES',
6438: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
6439: p_batch_id,
6440: s_interface_line_id,
6441: 'PON_BID_PRICE_NOT_WITHIN_TIERS',
6442: p_userid,

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

6627: WORKSHEET_SEQUENCE_NUMBER,
6628: ENTITY_MESSAGE_CODE)
6629: VALUES
6630: (p_interface_type,
6631: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
6632: 'PON_BID_PRICE_DIFFERENTIALS',
6633: p_batch_id,
6634: s_interface_line_id,
6635: 'PON_AUC_PD_VALUE_REQ' || p_suffix,

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

6690: WORKSHEET_SEQUENCE_NUMBER,
6691: ENTITY_MESSAGE_CODE)
6692: VALUES
6693: (p_interface_type,
6694: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
6695: 'PON_BID_PRICE_DIFFERENTIALS',
6696: p_batch_id,
6697: s_interface_line_id ,
6698: 'PON_AUC_PD_VAL_NONENTERABLE',

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

6753: WORKSHEET_SEQUENCE_NUMBER,
6754: ENTITY_MESSAGE_CODE)
6755: VALUES
6756: (p_interface_type,
6757: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
6758: 'PON_BID_PRICE_DIFFERENTIALS',
6759: p_batch_id,
6760: s_interface_line_id,
6761: 'PON_AUC_PD_INVALID_MULT' || p_suffix,

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

6819: WORKSHEET_SEQUENCE_NUMBER,
6820: ENTITY_MESSAGE_CODE)
6821: VALUES
6822: (p_interface_type,
6823: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6824: 'PON_BID_PRICE_DIFFERENTIALS',
6825: p_batch_id,
6826: s_interface_line_id,
6827: 'PON_AUC_PB_PD_VALUE_REQ' || p_suffix,

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

6884: WORKSHEET_SEQUENCE_NUMBER,
6885: ENTITY_MESSAGE_CODE)
6886: VALUES
6887: (p_interface_type,
6888: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6889: 'PON_BID_PRICE_DIFFERENTIALS',
6890: p_batch_id,
6891: s_interface_line_id,
6892: 'PON_AUC_PB_PD_VAL_NONENTERABLE',

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

6951: ENTITY_MESSAGE_CODE
6952: )
6953: VALUES
6954: (p_interface_type,
6955: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6956: 'PON_BID_PRICE_DIFFERENTIALS',
6957: p_batch_id,
6958: s_interface_line_id,
6959: 'PON_AUC_PB_PD_INVALID_MULT' || p_suffix,

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

7080: TOKEN2_NAME,
7081: TOKEN2_VALUE)
7082: SELECT
7083: p_interface_type,
7084: fnd_message.get_string('PON','PON_AUCTS_PAYITEM_NUMBER'),
7085: 'PON_BID_ITEM_PRICES',
7086: p_batch_id,
7087: 'PON_PYMT_NUM_NOT_UNQ',
7088: p_userid,

Line 7491: fnd_message.get_string('PON', 'PON_EMD_STATUS_VALUE'),

7487: LINE_NUMBER,
7488: EXPIRATION_DATE)
7489: values(
7490: p_interface_type,
7491: fnd_message.get_string('PON', 'PON_EMD_STATUS_VALUE'),
7492: 'PON_EMD_TRANSACTIONS',
7493: p_batch_id,
7494: 'PON_EMD_STATUS_VALUE',
7495: p_userid,