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_PAYMENTS_INT dependencies on PON_BID_PAYMENTS_INTERFACE

Line 94: FROM PON_BID_PAYMENTS_INTERFACE pbp

90: l_loginid,
91: pbp.worksheet_name,
92: pbp.worksheet_sequence_number,
93: l_entity_name
94: FROM PON_BID_PAYMENTS_INTERFACE pbp
95: WHERE pbp.batch_id = p_batch_id
96: AND pbp.interface_line_id >
97: ( SELECT min(interface_line_id)
98: FROM PON_BID_PAYMENTS_INTERFACE pbpi2

Line 98: FROM PON_BID_PAYMENTS_INTERFACE pbpi2

94: FROM PON_BID_PAYMENTS_INTERFACE pbp
95: WHERE pbp.batch_id = p_batch_id
96: AND pbp.interface_line_id >
97: ( SELECT min(interface_line_id)
98: FROM PON_BID_PAYMENTS_INTERFACE pbpi2
99: WHERE pbp.document_disp_line_number = pbpi2.document_disp_line_number
100: AND pbp.payment_display_number = pbpi2.payment_display_number
101: AND pbp.batch_id = pbpi2.batch_id
102: AND pbp.interface_line_id <> pbpi2.interface_line_id);

Line 112: DELETE FROM PON_BID_PAYMENTS_INTERFACE pbpi

108: -- If we don't delete duplicate records Merge statement won't work
109: -- We could have validated the rest of the records and delete them before merge
110: -- but as discussed with PM Alan Ng, we will retain the behaviour of R12 for now
111:
112: DELETE FROM PON_BID_PAYMENTS_INTERFACE pbpi
113: WHERE pbpi.batch_id = p_batch_id
114: AND pbpi.interface_line_id >
115: ( SELECT min(interface_line_id)
116: FROM PON_BID_PAYMENTS_INTERFACE pbpi2

Line 116: FROM PON_BID_PAYMENTS_INTERFACE pbpi2

112: DELETE FROM PON_BID_PAYMENTS_INTERFACE pbpi
113: WHERE pbpi.batch_id = p_batch_id
114: AND pbpi.interface_line_id >
115: ( SELECT min(interface_line_id)
116: FROM PON_BID_PAYMENTS_INTERFACE pbpi2
117: WHERE pbpi.document_disp_line_number = pbpi2.document_disp_line_number
118: AND pbpi.payment_display_number = pbpi2.payment_display_number
119: AND pbpi.batch_id = pbpi2.batch_id
120: AND pbpi.interface_line_id <> pbpi2.interface_line_id);

Line 154: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

150: (
151: fnd_message.get_string('PON','PON_AUCTS_UOM'), NULL, 'PON_UOM_INVALID', -- 1
152: 'TXT', unit_of_measure, NULL, -- 2
153: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
154: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
155: p_batch_id, interface_line_id, NULL, -- 5
156: auction_header_id, auction_line_number, bid_payment_id, -- 6
157: l_exp_date, l_userid, SYSDATE, -- 7
158: l_userid, SYSDATE, l_loginid, -- 8

Line 183: NULL, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

179: (
180: fnd_message.get_string('PON','PON_AUCTS_LINENUMBER'), NULL, 'PON_PYMT_NOTALLOWED', -- 1
181: 'TXT', document_disp_line_number, NULL, -- 2
182: 'LINENUM', document_disp_line_number, NULL, -- 3
183: NULL, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
184: p_batch_id, interface_line_id, NULL, -- 5
185: auction_header_id, auction_line_number, bid_payment_id, -- 6
186: l_exp_date, l_userid, SYSDATE, -- 7
187: l_userid, SYSDATE, l_loginid,

Line 208: NULL, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

204: (
205: fnd_message.get_string('PON','PON_AUCTS_LINENUMBER'), NULL, 'PON_INVALID_LINE_NUM', -- 1
206: 'TXT', document_disp_line_number, NULL, -- 2
207: NULL, NULL, NULL, -- 3
208: NULL, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
209: p_batch_id, interface_line_id, NULL, -- 5
210: auction_header_id, auction_line_number, bid_payment_id, -- 6
211: l_exp_date, l_userid, SYSDATE, -- 7
212: l_userid, SYSDATE, l_loginid,

Line 246: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

242: decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_txt_upload_mode, fnd_message.get_string('PON','PON_AUCTS_PAYITEM_TYPE'), fnd_message.get_string('PON','PON_AUCTS_TYPE')),
243: NULL, 'PON_PYMT_TYPE_INVALID', -- 1
244: 'TXT', payment_type, NULL, -- 2
245: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
246: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
247: p_batch_id, interface_line_id, NULL, -- 5
248: auction_header_id, auction_line_number, bid_payment_id, -- 6
249: l_exp_date, l_userid, SYSDATE, -- 7
250: l_userid, SYSDATE, l_loginid, -- 8

Line 279: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

275: decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_txt_upload_mode, fnd_message.get_string('PON','PON_AUCTS_PAYITEM_NUMBER'), fnd_message.get_string('PON','PON_PAY_ITEM')),
276: NULL, 'PON_PYMT_NUM_WRONG', -- 1
277: 'TXT', payment_display_number, NULL, -- 2
278: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
279: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
280: p_batch_id, interface_line_id, NULL, -- 5
281: auction_header_id, auction_line_number, bid_payment_id, -- 6
282: l_exp_date, l_userid, SYSDATE, -- 7
283: l_userid, SYSDATE, l_loginid, -- 8

Line 311: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

307: (
308: fnd_message.get_string('PON','PON_AUCTS_BID_QTY_R'), NULL, 'PON_PYMT_QTY_WRONG', -- 1
309: 'NUM', quantity, NULL, -- 2
310: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
311: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
312: p_batch_id, interface_line_id, NULL, -- 5
313: auction_header_id, auction_line_number, bid_payment_id, -- 6
314: l_exp_date, l_userid, SYSDATE, -- 7
315: l_userid, SYSDATE, l_loginid, -- 8

Line 343: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

339: (
340: fnd_message.get_string('PON','PON_AUCTS_UOM'), NULL, 'PON_PYMT_UOM_NULL', -- 1
341: 'TXT', NULL, NULL, -- 2
342: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
343: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
344: p_batch_id, interface_line_id, NULL, -- 5
345: auction_header_id, auction_line_number, bid_payment_id, -- 6
346: l_exp_date, l_userid, SYSDATE, -- 7
347: l_userid, SYSDATE, l_loginid, -- 8

Line 374: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

370: (
371: fnd_message.get_string('PON','PON_AUCTS_BID_PRICE_R'), NULL, 'PON_PYMT_PRICE_WRONG', -- 1
372: 'NUM', bid_currency_price, NULL, -- 2
373: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
374: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
375: p_batch_id, interface_line_id, NULL, -- 5
376: auction_header_id, auction_line_number, bid_payment_id, -- 6
377: l_exp_date, l_userid, SYSDATE, -- 7
378: l_userid, SYSDATE, l_loginid, -- 8

Line 406: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

402: (
403: fnd_message.get_string('PON','PON_AUCTS_BID_QTY_R'), NULL, 'PON_PYMT_QTY_NULL', -- 1
404: 'TXT', NULL, NULL, -- 2
405: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
406: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
407: p_batch_id, interface_line_id, NULL, -- 5
408: auction_header_id, auction_line_number, bid_payment_id, -- 6
409: l_exp_date, l_userid, SYSDATE, -- 7
410: l_userid, SYSDATE, l_loginid, -- 8

Line 437: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

433: (
434: fnd_message.get_string('PON','PON_AUCTS_BID_PRICE_R'), NULL, 'PON_PYMT_BID_PRICE_NULL', -- 1
435: 'TXT', NULL, NULL, -- 2
436: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
437: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
438: p_batch_id, interface_line_id, NULL, -- 5
439: auction_header_id, auction_line_number, bid_payment_id, -- 6
440: l_exp_date, l_userid, SYSDATE, -- 7
441: l_userid, SYSDATE, l_loginid, -- 8

Line 470: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

466: (
467: fnd_message.get_string('PON','PON_AUCTS_BID_PRICE_R'), NULL, 'PON_QUOTEPRICE_INVALID_PREC_L', -- 1
468: 'NUM', bid_currency_price, NULL, -- 2
469: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
470: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
471: p_batch_id, interface_line_id, NULL, -- 5
472: auction_header_id, auction_line_number, bid_payment_id, -- 6
473: l_exp_date, l_userid, SYSDATE, -- 7
474: l_userid, SYSDATE, l_loginid, -- 8

Line 501: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4

497: (
498: fnd_message.get_string('PON','PON_AUCTS_PROMISED_DATE'), NULL, 'PON_PYMT_PDATE_LESS_CDATE', -- 1
499: 'TIM', NULL, promised_date, -- 2
500: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
501: payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_INTERFACE', -- 4
502: p_batch_id, interface_line_id, NULL, -- 5
503: auction_header_id, auction_line_number, bid_payment_id, -- 6
504: l_exp_date, l_userid, SYSDATE, -- 7
505: l_userid, SYSDATE, l_loginid, -- 8

Line 536: FROM PON_BID_PAYMENTS_INTERFACE pbp,

532: null bid_payment_id,
533: pbi.line_number bid_line_number,
534: fc.precision fc_precision,
535: pbh.number_price_decimals pbh_price_precision
536: FROM PON_BID_PAYMENTS_INTERFACE pbp,
537: PON_AUCTION_ITEM_PRICES_ALL pai,
538: PON_BID_ITEM_PRICES pbi,
539: PON_AUCTION_HEADERS_ALL pah,
540: MTL_UNITS_OF_MEASURE uom,

Line 597: FROM PON_BID_PAYMENTS_INTERFACE pbp,

593: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_name, NULL),
594: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_sequence_number, NULL),
595: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, l_entity_name, NULL) ,
596: p_request_id
597: FROM PON_BID_PAYMENTS_INTERFACE pbp,
598: PON_AUCTION_ITEM_PRICES_ALL pai,
599: PON_AUCTION_HEADERS_ALL pah
600: WHERE pbp.document_disp_line_number = pai.document_disp_line_number
601: AND pbp.auction_header_id = pai.auction_header_id

Line 1353: FROM pon_bid_payments_interface pbpi,

1349: pbps.bid_payment_id,
1350: pbps.bid_number,
1351: pbps.bid_line_number,
1352: pbpi.document_disp_line_number
1353: FROM pon_bid_payments_interface pbpi,
1354: pon_auction_item_prices_all pai,
1355: pon_bid_payments_shipments pbps
1356: WHERE pbpi.auction_header_id = pai.auction_header_id
1357: AND pbpi.document_disp_line_number = pai.document_disp_line_number

Line 1375: pon_bid_payments_interface pbpi

1371: -- select some variables that we need for currency conversion
1372: SELECT distinct pbh.rate
1373: INTO l_rate
1374: FROM pon_bid_headers pbh,
1375: pon_bid_payments_interface pbpi
1376: WHERE pbpi.bid_number = pbh.bid_number
1377: AND pbpi.batch_id = p_batch_id;
1378:
1379: -- Update lines table with values in the interface table

Line 1397: FROM pon_bid_payments_interface pbpi,

1393: fl.lookup_code payment_type_code,
1394: pbpi.promised_date,
1395: pbip.line_number line_number,
1396: nvl(pah.supplier_enterable_pymt_flag,'N') supplier_can_modify_pymts
1397: FROM pon_bid_payments_interface pbpi,
1398: pon_auction_item_prices_all paip,
1399: pon_auction_headers_all pah,
1400: pon_bid_item_prices pbip,
1401: MTL_UNITS_OF_MEASURE uom,

Line 1514: FROM PON_BID_PAYMENTS_INTERFACE pbpi,

1510:
1511: IF l_supplier_enterable_pymt_flag = 'Y' THEN
1512: DELETE FROM PON_BID_PAYMENTS_SHIPMENTS pbp
1513: WHERE pbp.payment_display_number NOT IN (SELECT pbpi.payment_display_number
1514: FROM PON_BID_PAYMENTS_INTERFACE pbpi,
1515: PON_AUCTION_ITEM_PRICES_ALL pai
1516: WHERE pbpi.batch_id = p_batch_id
1517: AND pbpi.bid_number = p_bid_number
1518: AND pai.auction_header_id = pbpi.auction_header_id

Line 1549: SELECT paip.line_number FROM pon_auction_item_prices_all paip, pon_bid_payments_interface pbpi, pon_bid_payments_shipments pbps WHERE

1545: UPDATE pon_bid_item_prices pbip SET pbip.IS_CHANGED_LINE_FLAG = 'Y',
1546: LAST_UPDATE_DATE = sysdate,
1547: LAST_UPDATED_BY = FND_GLOBAL.user_id
1548: WHERE pbip.line_number IN (
1549: SELECT paip.line_number FROM pon_auction_item_prices_all paip, pon_bid_payments_interface pbpi, pon_bid_payments_shipments pbps WHERE
1550: pbpi.batch_id = p_batch_id AND
1551: paip.auction_header_id = pbpi.auction_header_id AND
1552: pbpi.document_disp_line_number = paip.document_disp_line_number AND
1553: pbps.AUCTION_LINE_NUMBER = paip.line_number AND

Line 1569: delete from pon_bid_payments_interface where batch_id = p_batch_id;

1565: );
1566:
1567:
1568: -- Clear the interface tables
1569: delete from pon_bid_payments_interface where batch_id = p_batch_id;
1570:
1571: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1572: l_progress := 'delete from pon_bid_payments_interface completed for p_batch_id = '||p_batch_id;
1573: END if;

Line 1572: l_progress := 'delete from pon_bid_payments_interface completed for p_batch_id = '||p_batch_id;

1568: -- Clear the interface tables
1569: delete from pon_bid_payments_interface where batch_id = p_batch_id;
1570:
1571: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1572: l_progress := 'delete from pon_bid_payments_interface completed for p_batch_id = '||p_batch_id;
1573: END if;
1574:
1575: EXCEPTION
1576: WHEN OTHERS THEN