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 235: p_userid IN pon_interface_errors.created_by%TYPE,

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

Line 285: INSERT INTO pon_interface_errors

281: g_error_int)
282: WHERE bli.batch_id = p_batch_id;
283:
284: -- Report errors for invalid lines (invalid document_disp_line_number's)
285: INSERT INTO pon_interface_errors
286: (INTERFACE_TYPE,
287: COLUMN_NAME,
288: BATCH_ID,
289: INTERFACE_LINE_ID,

Line 422: p_userid IN pon_interface_errors.created_by%TYPE,

418: PROCEDURE validate_attribute_datatypes
419: (
420: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
421: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
422: p_userid IN pon_interface_errors.created_by%TYPE,
423: p_suffix IN VARCHAR2,
424: p_batch_id IN pon_interface_errors.batch_id%TYPE,
425: p_request_id IN pon_interface_errors.request_id%TYPE
426: ) IS

Line 424: p_batch_id IN pon_interface_errors.batch_id%TYPE,

420: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
421: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
422: p_userid IN pon_interface_errors.created_by%TYPE,
423: p_suffix IN VARCHAR2,
424: p_batch_id IN pon_interface_errors.batch_id%TYPE,
425: p_request_id IN pon_interface_errors.request_id%TYPE
426: ) IS
427: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
428: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;

Line 425: p_request_id IN pon_interface_errors.request_id%TYPE

421: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
422: p_userid IN pon_interface_errors.created_by%TYPE,
423: p_suffix IN VARCHAR2,
424: p_batch_id IN pon_interface_errors.batch_id%TYPE,
425: p_request_id IN pon_interface_errors.request_id%TYPE
426: ) IS
427: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
428: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
429: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;

Line 556: INSERT INTO pon_interface_errors

552: ' Array Index: ' || SQL%BULK_EXCEPTIONS(i).error_index ||
553: ' Message: ' || SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
554: END if;
555:
556: INSERT INTO pon_interface_errors
557: (INTERFACE_TYPE,
558: COLUMN_NAME,
559: TABLE_NAME,
560: BATCH_ID,

Line 618: p_userid IN pon_interface_errors.created_by%TYPE,

614: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
615: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
616: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
617: p_request_id IN pon_bid_headers.request_id%TYPE,
618: p_userid IN pon_interface_errors.created_by%TYPE,
619: p_has_pe IN VARCHAR2,
620: p_suffix IN VARCHAR2
621: ) IS
622: --added by Allen Yang for Surrogate Bid 2008/10/27

Line 693: INSERT INTO pon_interface_errors

689: and aa.display_only_flag = 'Y'
690: );
691:
692: -- Report errors for invalid attributes (invalid attr_name)
693: INSERT INTO pon_interface_errors
694: (INTERFACE_TYPE,
695: COLUMN_NAME,
696: BATCH_ID,
697: INTERFACE_LINE_ID,

Line 774: INSERT INTO pon_interface_errors

770: ------------------------------------------------------
771: --IF (p_has_pe = 'Y') THEN
772: 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
773: ------------------------------------------------------
774: INSERT INTO pon_interface_errors
775: (INTERFACE_TYPE,
776: COLUMN_NAME,
777: BATCH_ID,
778: INTERFACE_LINE_ID,

Line 840: INSERT INTO pon_interface_errors

836: AND apf.price_element_type_id = bpfi.price_element_type_id);
837:
838: -- Report errors for invalid price elements
839: -- (invalid price_element_name or BUYER price factor)
840: INSERT INTO pon_interface_errors
841: (INTERFACE_TYPE,
842: COLUMN_NAME,
843: BATCH_ID,
844: INTERFACE_LINE_ID,

Line 907: INSERT INTO pon_interface_errors

903: AND al.price_diff_shipment_number = bpd.shipment_number), g_error_int)
904: WHERE bpdi.batch_id = p_batch_id;
905:
906: -- Report errors for invalid price differentials (invalid price_type)
907: INSERT INTO pon_interface_errors
908: (INTERFACE_TYPE,
909: COLUMN_NAME,
910: BATCH_ID,
911: INTERFACE_LINE_ID,

Line 960: p_userid IN pon_interface_errors.created_by%TYPE,

956: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
957: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
958: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
959: p_request_id IN pon_bid_headers.request_id%TYPE,
960: p_userid IN pon_interface_errors.created_by%TYPE,
961: p_has_pe IN VARCHAR2,
962: p_suffix IN VARCHAR2
963: ) IS
964:

Line 973: INSERT INTO pon_interface_errors

969: FROM fnd_lookup_values_vl
970: WHERE lookup_type = 'CLM_PERIOD'
971: AND meaning = p.CLM_PROMISE_PERIOD_UOM);
972:
973: INSERT INTO pon_interface_errors
974: (INTERFACE_TYPE,
975: COLUMN_NAME,
976: TABLE_NAME,
977: BATCH_ID,

Line 1018: INSERT INTO pon_interface_errors

1014: FROM fnd_lookup_values_vl
1015: WHERE lookup_type = 'CLM_PERIOD'
1016: AND meaning = p.CLM_PROMISE_POP_DURATION_UOM);
1017:
1018: INSERT INTO pon_interface_errors
1019: (INTERFACE_TYPE,
1020: COLUMN_NAME,
1021: TABLE_NAME,
1022: BATCH_ID,

Line 1590: p_userid IN pon_interface_errors.created_by%TYPE,

1586: (
1587: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1588: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1589: p_request_id IN pon_bid_headers.request_id%TYPE,
1590: p_userid IN pon_interface_errors.created_by%TYPE,
1591: x_return_status OUT NOCOPY VARCHAR2,
1592: x_return_code OUT NOCOPY VARCHAR2
1593: ) IS
1594: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;

Line 1735: p_user_id IN pon_interface_errors.created_by%TYPE

1731: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1732: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1733: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1734: p_request_id IN pon_bid_item_prices.request_id%TYPE,
1735: p_user_id IN pon_interface_errors.created_by%TYPE
1736: ) IS
1737:
1738: l_loginid NUMBER;
1739: l_interface_type pon_interface_errors.interface_type%TYPE;

Line 1739: l_interface_type pon_interface_errors.interface_type%TYPE;

1735: p_user_id IN pon_interface_errors.created_by%TYPE
1736: ) IS
1737:
1738: l_loginid NUMBER;
1739: l_interface_type pon_interface_errors.interface_type%TYPE;
1740: l_lines_worksheet_sequence NUMBER;
1741: l_header_worksheet_sequence NUMBER;
1742: l_suffix VARCHAR2(2);
1743: BEGIN

Line 1758: INTO pon_interface_errors

1754: WHEN s_min_bid_change IS NOT NULL
1755: AND s_min_bid_change_type <> 'PERCENTAGE'
1756: AND PON_BID_VALIDATIONS_PKG.validate_price_precision(
1757: s_min_bid_change, s_bid_price_precision) = 'F' THEN
1758: INTO pon_interface_errors
1759: (INTERFACE_TYPE,
1760: COLUMN_NAME,
1761: BATCH_ID,
1762: INTERFACE_LINE_ID,

Line 1802: INTO pon_interface_errors

1798: )
1799: --2
1800: WHEN s_min_bid_change IS NOT NULL
1801: AND s_min_bid_change <= 0 THEN
1802: INTO pon_interface_errors
1803: (INTERFACE_TYPE,
1804: COLUMN_NAME,
1805: BATCH_ID,
1806: INTERFACE_LINE_ID,

Line 1846: INTO pon_interface_errors

1842: )
1843: --3
1844: WHEN s_min_bid_change IS NOT NULL
1845: AND s_min_bid_change < s_auc_min_bid_decrement THEN
1846: INTO pon_interface_errors
1847: (INTERFACE_TYPE,
1848: COLUMN_NAME,
1849: BATCH_ID,
1850: INTERFACE_LINE_ID,

Line 1890: INTO pon_interface_errors

1886: )
1887: --4
1888: WHEN s_surrogate_bid_flag = 'Y'
1889: AND s_response_recvd_time IS NULL THEN
1890: INTO pon_interface_errors
1891: (INTERFACE_TYPE,
1892: COLUMN_NAME,
1893: BATCH_ID,
1894: INTERFACE_LINE_ID,

Line 1937: INTO pon_interface_errors

1933: AND s_response_recvd_time IS NOT NULL
1934: AND ((s_response_recvd_time > sysdate)
1935: OR (s_open_bidding_date IS NOT NULL AND s_response_recvd_time < s_open_bidding_date)
1936: OR (s_response_recvd_time > s_close_bidding_date)) THEN
1937: INTO pon_interface_errors
1938: (INTERFACE_TYPE,
1939: COLUMN_NAME,
1940: BATCH_ID,
1941: INTERFACE_LINE_ID,

Line 1983: INTO pon_interface_errors

1979: WHEN s_surrogate_bid_flag = 'Y'
1980: AND s_old_response_recvd_time IS NOT NULL
1981: AND s_response_recvd_time IS NOT NULL
1982: AND s_response_recvd_time < s_old_response_recvd_time THEN
1983: INTO pon_interface_errors
1984: (INTERFACE_TYPE,
1985: COLUMN_NAME,
1986: BATCH_ID,
1987: INTERFACE_LINE_ID,

Line 2027: INTO pon_interface_errors

2023: )
2024: --7
2025: WHEN s_bid_valid_until IS NOT NULL
2026: AND s_bid_valid_until < s_close_bidding_date THEN
2027: INTO pon_interface_errors
2028: (INTERFACE_TYPE,
2029: COLUMN_NAME,
2030: BATCH_ID,
2031: INTERFACE_LINE_ID,

Line 2102: p_user_id IN pon_interface_errors.created_by%TYPE

2098: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2099: p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2100: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2101: p_request_id IN pon_bid_item_prices.request_id%TYPE,
2102: p_user_id IN pon_interface_errors.created_by%TYPE
2103: )
2104: IS
2105: l_interface_type pon_interface_errors.interface_type%TYPE;
2106:

Line 2105: l_interface_type pon_interface_errors.interface_type%TYPE;

2101: p_request_id IN pon_bid_item_prices.request_id%TYPE,
2102: p_user_id IN pon_interface_errors.created_by%TYPE
2103: )
2104: IS
2105: l_interface_type pon_interface_errors.interface_type%TYPE;
2106:
2107: BEGIN
2108: l_interface_type := 'BIDBYSPREADSHEET';
2109: INSERT ALL

Line 2114: INTO pon_interface_errors

2110:
2111: -- Price Type can not be null. This secnario only possible for Xml Spreadsheet, which is not exist
2112: -- for online case.
2113: WHEN s_price_type is null THEN
2114: INTO pon_interface_errors
2115: (INTERFACE_TYPE,
2116: TABLE_NAME,
2117: COLUMN_NAME,
2118: BATCH_ID,

Line 2244: INSERT INTO pon_interface_errors

2240: -- Error is reported per line. Price factor errors reported below.
2241: -- NOTE: this error check is performed before that for BUYER pf's
2242: IF (p_has_pe = 'Y') THEN
2243:
2244: INSERT INTO pon_interface_errors
2245: (INTERFACE_TYPE,
2246: COLUMN_NAME,
2247: BATCH_ID,
2248: INTERFACE_LINE_ID,

Line 2419: p_userid IN pon_interface_errors.created_by%TYPE,

2415: (
2416: p_auc_header_id IN pon_bid_item_prices_interface.auction_header_id%TYPE,
2417: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2418: p_request_id IN pon_bid_headers.request_id%TYPE,
2419: p_userid IN pon_interface_errors.created_by%TYPE,
2420: p_full_qty IN VARCHAR2,
2421: p_buyer_user IN VARCHAR2,
2422: p_suffix IN VARCHAR2
2423: ) IS

Line 2496: p_user_id IN pon_interface_errors.created_by%TYPE,

2492: PROCEDURE validate_xml_req_values
2493: (
2494: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
2495: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2496: p_user_id IN pon_interface_errors.created_by%TYPE,
2497: p_suffix IN VARCHAR2,
2498: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2499: p_request_id IN pon_interface_errors.request_id%TYPE
2500: ) IS

Line 2498: p_batch_id IN pon_interface_errors.batch_id%TYPE,

2494: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
2495: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2496: p_user_id IN pon_interface_errors.created_by%TYPE,
2497: p_suffix IN VARCHAR2,
2498: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2499: p_request_id IN pon_interface_errors.request_id%TYPE
2500: ) IS
2501: -- Define table definitions
2502: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;

Line 2499: p_request_id IN pon_interface_errors.request_id%TYPE

2495: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2496: p_user_id IN pon_interface_errors.created_by%TYPE,
2497: p_suffix IN VARCHAR2,
2498: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2499: p_request_id IN pon_interface_errors.request_id%TYPE
2500: ) IS
2501: -- Define table definitions
2502: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2503: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;

Line 2623: INSERT INTO pon_interface_errors

2619: FOR i IN 1..l_num_errors LOOP
2620:
2621: l_index := SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
2622:
2623: INSERT INTO pon_interface_errors
2624: (INTERFACE_TYPE,
2625: COLUMN_NAME,
2626: TABLE_NAME,
2627: BATCH_ID,

Line 2687: p_user_id IN pon_interface_errors.created_by%TYPE,

2683: PROCEDURE validate_xml_attr_values
2684: (
2685: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
2686: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2687: p_user_id IN pon_interface_errors.created_by%TYPE,
2688: p_suffix IN VARCHAR2,
2689: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2690: p_request_id IN pon_interface_errors.request_id%TYPE
2691: ) IS

Line 2689: p_batch_id IN pon_interface_errors.batch_id%TYPE,

2685: p_auction_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
2686: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2687: p_user_id IN pon_interface_errors.created_by%TYPE,
2688: p_suffix IN VARCHAR2,
2689: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2690: p_request_id IN pon_interface_errors.request_id%TYPE
2691: ) IS
2692: -- Define table definitions
2693: TYPE docDispLineNumTable IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;

Line 2690: p_request_id IN pon_interface_errors.request_id%TYPE

2686: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
2687: p_user_id IN pon_interface_errors.created_by%TYPE,
2688: p_suffix IN VARCHAR2,
2689: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2690: p_request_id IN pon_interface_errors.request_id%TYPE
2691: ) IS
2692: -- Define table definitions
2693: TYPE docDispLineNumTable IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
2694: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;

Line 2822: INSERT INTO pon_interface_errors

2818: FOR i IN 1..l_num_errors LOOP
2819:
2820: l_index := SQL%BULK_EXCEPTIONS(i).ERROR_INDEX;
2821:
2822: INSERT INTO pon_interface_errors
2823: (INTERFACE_TYPE,
2824: COLUMN_NAME,
2825: TABLE_NAME,
2826: BATCH_ID,

Line 3258: p_user_id IN pon_interface_errors.created_by%TYPE,

3254: (
3255: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
3256: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3257: p_request_id IN pon_bid_headers.request_id%TYPE,
3258: p_user_id IN pon_interface_errors.created_by%TYPE,
3259: x_return_status OUT NOCOPY NUMBER,
3260: x_return_code OUT NOCOPY VARCHAR2
3261: ) IS
3262: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;

Line 3416: p_userid IN pon_interface_errors.created_by%TYPE,

3412: --bug 16654950
3413: p_transaction_id IN po_uda_interface.transaction_id%TYPE,
3414: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3415: p_request_id IN pon_bid_headers.request_id%TYPE,
3416: p_userid IN pon_interface_errors.created_by%TYPE,
3417: x_return_status OUT NOCOPY VARCHAR2
3418: )
3419: Is
3420: po_uda_array PO_UDA_USAGE_OBJECT_ARRAY := PO_UDA_USAGE_OBJECT_ARRAY();