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_VALIDATIONS_PKG

Line 42: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN

38:
39: --Validate and remove duplicate records for payments for Xml Upload case
40: --For text based spreadsheet duplicate records are not inserted in the interface table
41:
42: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN
43: BEGIN
44:
45: INSERT INTO PON_INTERFACE_ERRORS
46: (

Line 164: WHEN p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode AND bid_line_number IS NOT NULL and group_type IN ('GROUP','LOT_LINE') THEN

160: s_worksheet_sequence_number,
161: s_entity_name ,
162: p_request_id
163: )
164: WHEN p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode AND bid_line_number IS NOT NULL and group_type IN ('GROUP','LOT_LINE') THEN
165: INTO pon_interface_errors
166: (
167: column_name, entity_attr_name, error_message_name, -- 1
168: error_value_datatype, error_value, error_value_date, -- 2

Line 190: WHEN p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode AND bid_line_number IS NULL THEN

186: l_exp_date, l_userid, SYSDATE, -- 7
187: l_userid, SYSDATE, l_loginid,
188: p_request_id
189: )
190: WHEN p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode AND bid_line_number IS NULL THEN
191: INTO pon_interface_errors
192: (
193: column_name, entity_attr_name, error_message_name, -- 1
194: error_value_datatype, error_value, error_value_date, -- 2

Line 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')),

238: REQUEST_ID
239: )
240: VALUES
241: (
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

Line 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')),

271: REQUEST_ID
272: )
273: VALUES
274: (
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

Line 448: AND PON_BID_VALIDATIONS_PKG.validate_price_precision(

444: s_entity_name,
445: p_request_id
446: )
447: WHEN bid_currency_price IS NOT NULL
448: AND PON_BID_VALIDATIONS_PKG.validate_price_precision(
449: bid_currency_price, pbh_price_precision) = 'F' THEN
450: INTO pon_interface_errors
451: (
452: column_name, entity_attr_name, error_message_name, -- 1

Line 523: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_name, NULL) s_worksheet_name,

519: pbp.document_disp_line_number,
520: pbp.bid_currency_price,
521: pbp.quantity,
522: pbp.promised_date,
523: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_name, NULL) s_worksheet_name,
524: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_sequence_number, NULL) s_worksheet_sequence_number,
525: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, l_entity_name, NULL) s_entity_name,
526: pai.line_number auction_line_number,
527: pai.group_type,

Line 524: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_sequence_number, NULL) s_worksheet_sequence_number,

520: pbp.bid_currency_price,
521: pbp.quantity,
522: pbp.promised_date,
523: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_name, NULL) s_worksheet_name,
524: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_sequence_number, NULL) s_worksheet_sequence_number,
525: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, l_entity_name, NULL) s_entity_name,
526: pai.line_number auction_line_number,
527: pai.group_type,
528: pai.purchase_basis line_type,

Line 525: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, l_entity_name, NULL) s_entity_name,

521: pbp.quantity,
522: pbp.promised_date,
523: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_name, NULL) s_worksheet_name,
524: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_sequence_number, NULL) s_worksheet_sequence_number,
525: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, l_entity_name, NULL) s_entity_name,
526: pai.line_number auction_line_number,
527: pai.group_type,
528: pai.purchase_basis line_type,
529: pai.close_bidding_date,

Line 584: SELECT 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')),

580: entity_message_code,
581: REQUEST_ID
582:
583: )
584: SELECT 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')),
585: NULL, 'PON_LINE_PYMT_INVALID', -- 1
586: 'NUM', pbp.payment_display_number, NULL, -- 2
587: 'LINENUM', pbp.document_disp_line_number, 'PAYITEMNUM', -- 3
588: pbp.payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

Line 593: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_name, NULL),

589: p_batch_id, pbp.interface_line_id, NULL, -- 5
590: pbp.auction_header_id, pai.line_number, NULL, -- 6
591: l_exp_date, l_userid, SYSDATE, -- 7
592: l_userid, SYSDATE, l_loginid, -- 8
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,

Line 594: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_sequence_number, NULL),

590: pbp.auction_header_id, pai.line_number, NULL, -- 6
591: l_exp_date, l_userid, SYSDATE, -- 7
592: l_userid, SYSDATE, l_loginid, -- 8
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,

Line 595: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, l_entity_name, NULL) ,

591: l_exp_date, l_userid, SYSDATE, -- 7
592: l_userid, SYSDATE, l_loginid, -- 8
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

Line 1479: IF (p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode) THEN

1475: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1476: l_progress := 'Merge into pon_bid_payments_shipments is successful for batch_id = '||p_batch_id;
1477: END if;
1478:
1479: IF (p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode) THEN
1480: --create URL Attachments
1481: FOR l_attachment_record IN l_attachment_cursor LOOP
1482:
1483: IF l_attachment_record.document_disp_line_number <> l_previous_line_number THEN