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_RESPONSE_IMPORT_PKG dependencies on PON_INTERFACE_ERRORS

Line 50: p_user_id IN pon_interface_errors.created_by%TYPE,

46: PROCEDURE validate_xml_req_values
47: (
48: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
49: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
50: p_user_id IN pon_interface_errors.created_by%TYPE,
51: p_suffix IN VARCHAR2,
52: p_batch_id IN pon_interface_errors.batch_id%TYPE,
53: p_request_id IN pon_interface_errors.request_id%TYPE);
54:

Line 52: p_batch_id IN pon_interface_errors.batch_id%TYPE,

48: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
49: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
50: p_user_id IN pon_interface_errors.created_by%TYPE,
51: p_suffix IN VARCHAR2,
52: p_batch_id IN pon_interface_errors.batch_id%TYPE,
53: p_request_id IN pon_interface_errors.request_id%TYPE);
54:
55:
56: PROCEDURE validate_xml_attr_values

Line 53: p_request_id IN pon_interface_errors.request_id%TYPE);

49: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
50: p_user_id IN pon_interface_errors.created_by%TYPE,
51: p_suffix IN VARCHAR2,
52: p_batch_id IN pon_interface_errors.batch_id%TYPE,
53: p_request_id IN pon_interface_errors.request_id%TYPE);
54:
55:
56: PROCEDURE validate_xml_attr_values
57: (

Line 60: p_user_id IN pon_interface_errors.created_by%TYPE,

56: PROCEDURE validate_xml_attr_values
57: (
58: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
59: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
60: p_user_id IN pon_interface_errors.created_by%TYPE,
61: p_suffix IN VARCHAR2,
62: p_batch_id IN pon_interface_errors.batch_id%TYPE,
63: p_request_id IN pon_interface_errors.request_id%TYPE);
64:

Line 62: p_batch_id IN pon_interface_errors.batch_id%TYPE,

58: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
59: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
60: p_user_id IN pon_interface_errors.created_by%TYPE,
61: p_suffix IN VARCHAR2,
62: p_batch_id IN pon_interface_errors.batch_id%TYPE,
63: p_request_id IN pon_interface_errors.request_id%TYPE);
64:
65:
66:

Line 63: p_request_id IN pon_interface_errors.request_id%TYPE);

59: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
60: p_user_id IN pon_interface_errors.created_by%TYPE,
61: p_suffix IN VARCHAR2,
62: p_batch_id IN pon_interface_errors.batch_id%TYPE,
63: p_request_id IN pon_interface_errors.request_id%TYPE);
64:
65:
66:
67: FUNCTION get_message_1_token

Line 88: p_userid IN pon_interface_errors.created_by%TYPE,

84: (
85: p_auc_header_id IN pon_bid_item_prices_interface.auction_header_id%TYPE,
86: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
87: p_request_id IN pon_bid_headers.request_id%TYPE,
88: p_userid IN pon_interface_errors.created_by%TYPE,
89: p_suffix IN VARCHAR2
90: ) IS
91: l_is_paused VARCHAR2(1);
92: l_paused_date TIMESTAMP;

Line 117: INSERT INTO pon_interface_errors

113: WHERE al.auction_header_id = bli.auction_header_id
114: AND al.line_number = bli.line_number);
115:
116: -- Report errors for all closed lines
117: INSERT INTO pon_interface_errors
118: (INTERFACE_TYPE,
119: COLUMN_NAME,
120: BATCH_ID,
121: INTERFACE_LINE_ID,

Line 233: p_userid IN pon_interface_errors.created_by%TYPE,

229: (
230: p_auc_header_id IN pon_bid_item_prices_interface.auction_header_id%TYPE,
231: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
232: p_request_id IN pon_bid_headers.request_id%TYPE,
233: p_userid IN pon_interface_errors.created_by%TYPE,
234: p_full_qty IN VARCHAR2,
235: p_buyer_user IN VARCHAR2,
236: p_suffix IN VARCHAR2
237: ) IS

Line 258: INSERT INTO pon_interface_errors

254: g_error_int)
255: WHERE bli.batch_id = p_batch_id;
256:
257: -- Report errors for invalid lines (invalid document_disp_line_number's)
258: INSERT INTO pon_interface_errors
259: (INTERFACE_TYPE,
260: COLUMN_NAME,
261: BATCH_ID,
262: INTERFACE_LINE_ID,

Line 395: p_userid IN pon_interface_errors.created_by%TYPE,

391: PROCEDURE validate_attribute_datatypes
392: (
393: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
394: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
395: p_userid IN pon_interface_errors.created_by%TYPE,
396: p_suffix IN VARCHAR2,
397: p_batch_id IN pon_interface_errors.batch_id%TYPE,
398: p_request_id IN pon_interface_errors.request_id%TYPE
399: ) IS

Line 397: p_batch_id IN pon_interface_errors.batch_id%TYPE,

393: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
394: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
395: p_userid IN pon_interface_errors.created_by%TYPE,
396: p_suffix IN VARCHAR2,
397: p_batch_id IN pon_interface_errors.batch_id%TYPE,
398: p_request_id IN pon_interface_errors.request_id%TYPE
399: ) IS
400: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
401: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;

Line 398: p_request_id IN pon_interface_errors.request_id%TYPE

394: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
395: p_userid IN pon_interface_errors.created_by%TYPE,
396: p_suffix IN VARCHAR2,
397: p_batch_id IN pon_interface_errors.batch_id%TYPE,
398: p_request_id IN pon_interface_errors.request_id%TYPE
399: ) IS
400: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
401: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
402: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;

Line 486: INSERT INTO pon_interface_errors

482: FOR i IN 1..l_num_errors LOOP
483:
484: l_index := SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
485:
486: INSERT INTO pon_interface_errors
487: (INTERFACE_TYPE,
488: COLUMN_NAME,
489: TABLE_NAME,
490: BATCH_ID,

Line 541: p_userid IN pon_interface_errors.created_by%TYPE,

537: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
538: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
539: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
540: p_request_id IN pon_bid_headers.request_id%TYPE,
541: p_userid IN pon_interface_errors.created_by%TYPE,
542: p_has_pe IN VARCHAR2,
543: p_suffix IN VARCHAR2
544: ) IS
545: --added by Allen Yang for Surrogate Bid 2008/10/27

Line 616: INSERT INTO pon_interface_errors

612: and aa.display_only_flag = 'Y'
613: );
614:
615: -- Report errors for invalid attributes (invalid attr_name)
616: INSERT INTO pon_interface_errors
617: (INTERFACE_TYPE,
618: COLUMN_NAME,
619: BATCH_ID,
620: INTERFACE_LINE_ID,

Line 697: INSERT INTO pon_interface_errors

693: ------------------------------------------------------
694: --IF (p_has_pe = 'Y') THEN
695: IF (p_has_pe = 'Y' AND NOT (l_two_part_flag = 'Y' AND l_tech_evaluation_status = 'NOT_COMPLETED' AND l_surrogate_bid_flag = 'Y')) THEN
696: ------------------------------------------------------
697: INSERT INTO pon_interface_errors
698: (INTERFACE_TYPE,
699: COLUMN_NAME,
700: BATCH_ID,
701: INTERFACE_LINE_ID,

Line 763: INSERT INTO pon_interface_errors

759: AND apf.price_element_type_id = bpfi.price_element_type_id);
760:
761: -- Report errors for invalid price elements
762: -- (invalid price_element_name or BUYER price factor)
763: INSERT INTO pon_interface_errors
764: (INTERFACE_TYPE,
765: COLUMN_NAME,
766: BATCH_ID,
767: INTERFACE_LINE_ID,

Line 830: INSERT INTO pon_interface_errors

826: AND al.price_diff_shipment_number = bpd.shipment_number), g_error_int)
827: WHERE bpdi.batch_id = p_batch_id;
828:
829: -- Report errors for invalid price differentials (invalid price_type)
830: INSERT INTO pon_interface_errors
831: (INTERFACE_TYPE,
832: COLUMN_NAME,
833: BATCH_ID,
834: INTERFACE_LINE_ID,

Line 1387: p_userid IN pon_interface_errors.created_by%TYPE,

1383: (
1384: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1385: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1386: p_request_id IN pon_bid_headers.request_id%TYPE,
1387: p_userid IN pon_interface_errors.created_by%TYPE,
1388: x_return_status OUT NOCOPY VARCHAR2,
1389: x_return_code OUT NOCOPY VARCHAR2
1390: ) IS
1391: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;

Line 1522: p_user_id IN pon_interface_errors.created_by%TYPE

1518: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1519: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1520: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1521: p_request_id IN pon_bid_item_prices.request_id%TYPE,
1522: p_user_id IN pon_interface_errors.created_by%TYPE
1523: ) IS
1524:
1525: l_loginid NUMBER;
1526: l_interface_type pon_interface_errors.interface_type%TYPE;

Line 1526: l_interface_type pon_interface_errors.interface_type%TYPE;

1522: p_user_id IN pon_interface_errors.created_by%TYPE
1523: ) IS
1524:
1525: l_loginid NUMBER;
1526: l_interface_type pon_interface_errors.interface_type%TYPE;
1527: l_lines_worksheet_sequence NUMBER;
1528: l_header_worksheet_sequence NUMBER;
1529: l_suffix VARCHAR2(2);
1530: BEGIN

Line 1545: INTO pon_interface_errors

1541: WHEN s_min_bid_change IS NOT NULL
1542: AND s_min_bid_change_type <> 'PERCENTAGE'
1543: AND PON_BID_VALIDATIONS_PKG.validate_price_precision(
1544: s_min_bid_change, s_bid_price_precision) = 'F' THEN
1545: INTO pon_interface_errors
1546: (INTERFACE_TYPE,
1547: COLUMN_NAME,
1548: BATCH_ID,
1549: INTERFACE_LINE_ID,

Line 1589: INTO pon_interface_errors

1585: )
1586: --2
1587: WHEN s_min_bid_change IS NOT NULL
1588: AND s_min_bid_change <= 0 THEN
1589: INTO pon_interface_errors
1590: (INTERFACE_TYPE,
1591: COLUMN_NAME,
1592: BATCH_ID,
1593: INTERFACE_LINE_ID,

Line 1633: INTO pon_interface_errors

1629: )
1630: --3
1631: WHEN s_min_bid_change IS NOT NULL
1632: AND s_min_bid_change < s_auc_min_bid_decrement THEN
1633: INTO pon_interface_errors
1634: (INTERFACE_TYPE,
1635: COLUMN_NAME,
1636: BATCH_ID,
1637: INTERFACE_LINE_ID,

Line 1677: INTO pon_interface_errors

1673: )
1674: --4
1675: WHEN s_surrogate_bid_flag = 'Y'
1676: AND s_response_recvd_time IS NULL THEN
1677: INTO pon_interface_errors
1678: (INTERFACE_TYPE,
1679: COLUMN_NAME,
1680: BATCH_ID,
1681: INTERFACE_LINE_ID,

Line 1724: INTO pon_interface_errors

1720: AND s_response_recvd_time IS NOT NULL
1721: AND ((s_response_recvd_time > sysdate)
1722: OR (s_open_bidding_date IS NOT NULL AND s_response_recvd_time < s_open_bidding_date)
1723: OR (s_response_recvd_time > s_close_bidding_date)) THEN
1724: INTO pon_interface_errors
1725: (INTERFACE_TYPE,
1726: COLUMN_NAME,
1727: BATCH_ID,
1728: INTERFACE_LINE_ID,

Line 1770: INTO pon_interface_errors

1766: WHEN s_surrogate_bid_flag = 'Y'
1767: AND s_old_response_recvd_time IS NOT NULL
1768: AND s_response_recvd_time IS NOT NULL
1769: AND s_response_recvd_time < s_old_response_recvd_time THEN
1770: INTO pon_interface_errors
1771: (INTERFACE_TYPE,
1772: COLUMN_NAME,
1773: BATCH_ID,
1774: INTERFACE_LINE_ID,

Line 1814: INTO pon_interface_errors

1810: )
1811: --7
1812: WHEN s_bid_valid_until IS NOT NULL
1813: AND s_bid_valid_until < s_close_bidding_date THEN
1814: INTO pon_interface_errors
1815: (INTERFACE_TYPE,
1816: COLUMN_NAME,
1817: BATCH_ID,
1818: INTERFACE_LINE_ID,

Line 1889: p_user_id IN pon_interface_errors.created_by%TYPE

1885: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1886: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1887: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1888: p_request_id IN pon_bid_item_prices.request_id%TYPE,
1889: p_user_id IN pon_interface_errors.created_by%TYPE
1890: )
1891: IS
1892: l_interface_type pon_interface_errors.interface_type%TYPE;
1893:

Line 1892: l_interface_type pon_interface_errors.interface_type%TYPE;

1888: p_request_id IN pon_bid_item_prices.request_id%TYPE,
1889: p_user_id IN pon_interface_errors.created_by%TYPE
1890: )
1891: IS
1892: l_interface_type pon_interface_errors.interface_type%TYPE;
1893:
1894: BEGIN
1895: l_interface_type := 'BIDBYSPREADSHEET';
1896: INSERT ALL

Line 1901: INTO pon_interface_errors

1897:
1898: -- Price Type can not be null. This secnario only possible for Xml Spreadsheet, which is not exist
1899: -- for online case.
1900: WHEN s_price_type is null THEN
1901: INTO pon_interface_errors
1902: (INTERFACE_TYPE,
1903: TABLE_NAME,
1904: COLUMN_NAME,
1905: BATCH_ID,

Line 2031: INSERT INTO pon_interface_errors

2027: -- Error is reported per line. Price factor errors reported below.
2028: -- NOTE: this error check is performed before that for BUYER pf's
2029: IF (p_has_pe = 'Y') THEN
2030:
2031: INSERT INTO pon_interface_errors
2032: (INTERFACE_TYPE,
2033: COLUMN_NAME,
2034: BATCH_ID,
2035: INTERFACE_LINE_ID,

Line 2206: p_userid IN pon_interface_errors.created_by%TYPE,

2202: (
2203: p_auc_header_id IN pon_bid_item_prices_interface.auction_header_id%TYPE,
2204: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2205: p_request_id IN pon_bid_headers.request_id%TYPE,
2206: p_userid IN pon_interface_errors.created_by%TYPE,
2207: p_full_qty IN VARCHAR2,
2208: p_buyer_user IN VARCHAR2,
2209: p_suffix IN VARCHAR2
2210: ) IS

Line 2283: p_user_id IN pon_interface_errors.created_by%TYPE,

2279: PROCEDURE validate_xml_req_values
2280: (
2281: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
2282: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2283: p_user_id IN pon_interface_errors.created_by%TYPE,
2284: p_suffix IN VARCHAR2,
2285: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2286: p_request_id IN pon_interface_errors.request_id%TYPE
2287: ) IS

Line 2285: p_batch_id IN pon_interface_errors.batch_id%TYPE,

2281: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
2282: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2283: p_user_id IN pon_interface_errors.created_by%TYPE,
2284: p_suffix IN VARCHAR2,
2285: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2286: p_request_id IN pon_interface_errors.request_id%TYPE
2287: ) IS
2288: -- Define table definitions
2289: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;

Line 2286: p_request_id IN pon_interface_errors.request_id%TYPE

2282: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2283: p_user_id IN pon_interface_errors.created_by%TYPE,
2284: p_suffix IN VARCHAR2,
2285: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2286: p_request_id IN pon_interface_errors.request_id%TYPE
2287: ) IS
2288: -- Define table definitions
2289: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2290: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;

Line 2410: INSERT INTO pon_interface_errors

2406: FOR i IN 1..l_num_errors LOOP
2407:
2408: l_index := SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
2409:
2410: INSERT INTO pon_interface_errors
2411: (INTERFACE_TYPE,
2412: COLUMN_NAME,
2413: TABLE_NAME,
2414: BATCH_ID,

Line 2474: p_user_id IN pon_interface_errors.created_by%TYPE,

2470: PROCEDURE validate_xml_attr_values
2471: (
2472: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
2473: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2474: p_user_id IN pon_interface_errors.created_by%TYPE,
2475: p_suffix IN VARCHAR2,
2476: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2477: p_request_id IN pon_interface_errors.request_id%TYPE
2478: ) IS

Line 2476: p_batch_id IN pon_interface_errors.batch_id%TYPE,

2472: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
2473: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2474: p_user_id IN pon_interface_errors.created_by%TYPE,
2475: p_suffix IN VARCHAR2,
2476: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2477: p_request_id IN pon_interface_errors.request_id%TYPE
2478: ) IS
2479: -- Define table definitions
2480: TYPE docDispLineNumTable IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;

Line 2477: p_request_id IN pon_interface_errors.request_id%TYPE

2473: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2474: p_user_id IN pon_interface_errors.created_by%TYPE,
2475: p_suffix IN VARCHAR2,
2476: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2477: p_request_id IN pon_interface_errors.request_id%TYPE
2478: ) IS
2479: -- Define table definitions
2480: TYPE docDispLineNumTable IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
2481: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;

Line 2609: INSERT INTO pon_interface_errors

2605: FOR i IN 1..l_num_errors LOOP
2606:
2607: l_index := SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
2608:
2609: INSERT INTO pon_interface_errors
2610: (INTERFACE_TYPE,
2611: COLUMN_NAME,
2612: TABLE_NAME,
2613: BATCH_ID,

Line 3045: p_user_id IN pon_interface_errors.created_by%TYPE,

3041: (
3042: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
3043: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3044: p_request_id IN pon_bid_headers.request_id%TYPE,
3045: p_user_id IN pon_interface_errors.created_by%TYPE,
3046: x_return_status OUT NOCOPY NUMBER,
3047: x_return_code OUT NOCOPY VARCHAR2
3048: ) IS
3049: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;