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 PON_INTERFACE_ERRORS

Line 490: p_interface_type IN pon_interface_errors.interface_type%TYPE,

486: PROCEDURE validate_bids_placed
487: (
488: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
489: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
490: p_interface_type IN pon_interface_errors.interface_type%TYPE,
491: p_userid IN pon_interface_errors.created_by%TYPE,
492: p_rebid IN VARCHAR2,
493: p_bid_all_lines IN VARCHAR2,
494: p_auc_has_items IN VARCHAR2,

Line 491: p_userid IN pon_interface_errors.created_by%TYPE,

487: (
488: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
489: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
490: p_interface_type IN pon_interface_errors.interface_type%TYPE,
491: p_userid IN pon_interface_errors.created_by%TYPE,
492: p_rebid IN VARCHAR2,
493: p_bid_all_lines IN VARCHAR2,
494: p_auc_has_items IN VARCHAR2,
495: p_suffix IN VARCHAR2,

Line 496: p_batch_id IN pon_interface_errors.batch_id%TYPE,

492: p_rebid IN VARCHAR2,
493: p_bid_all_lines IN VARCHAR2,
494: p_auc_has_items IN VARCHAR2,
495: p_suffix IN VARCHAR2,
496: p_batch_id IN pon_interface_errors.batch_id%TYPE,
497: p_request_id IN pon_interface_errors.request_id%TYPE
498: ) IS
499: l_header_modified VARCHAR2(1);
500: BEGIN

Line 497: p_request_id IN pon_interface_errors.request_id%TYPE

493: p_bid_all_lines IN VARCHAR2,
494: p_auc_has_items IN VARCHAR2,
495: p_suffix IN VARCHAR2,
496: p_batch_id IN pon_interface_errors.batch_id%TYPE,
497: p_request_id IN pon_interface_errors.request_id%TYPE
498: ) IS
499: l_header_modified VARCHAR2(1);
500: BEGIN
501:

Line 536: INTO pon_interface_errors

532: INSERT FIRST
533:
534: -- When rebidding, the header or one line must be changed
535: WHEN p_rebid = 'Y' AND l_header_modified = 'N' AND s_changed_line_count = 0 THEN
536: INTO pon_interface_errors
537: (INTERFACE_TYPE,
538: TABLE_NAME,
539: BATCH_ID,
540: ERROR_MESSAGE_NAME,

Line 565: INTO pon_interface_errors

561: g_exp_date)
562:
563: -- All lines must have recieved a bid if that is a requirement
564: WHEN p_bid_all_lines = 'Y' AND s_avail_bidded_lines <> s_bidded_lines THEN
565: INTO pon_interface_errors
566: (INTERFACE_TYPE,
567: TABLE_NAME,
568: BATCH_ID,
569: ERROR_MESSAGE_NAME,

Line 594: INTO pon_interface_errors

590: g_exp_date)
591:
592: -- At least one line must have recieved a bid if the auction has lines
593: WHEN p_rebid = 'N' AND p_auc_has_items = 'Y' AND s_has_bid_count = 0 THEN
594: INTO pon_interface_errors
595: (INTERFACE_TYPE,
596: TABLE_NAME,
597: BATCH_ID,
598: ERROR_MESSAGE_NAME,

Line 664: p_interface_type IN pon_interface_errors.interface_type%TYPE,

660: PROCEDURE validate_lots_and_groups
661: (
662: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
663: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
664: p_interface_type IN pon_interface_errors.interface_type%TYPE,
665: p_userid IN pon_interface_errors.created_by%TYPE,
666: p_spreadsheet IN VARCHAR2,
667: p_batch_id IN pon_interface_errors.batch_id%TYPE,
668: p_request_id IN pon_interface_errors.request_id%TYPE

Line 665: p_userid IN pon_interface_errors.created_by%TYPE,

661: (
662: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
663: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
664: p_interface_type IN pon_interface_errors.interface_type%TYPE,
665: p_userid IN pon_interface_errors.created_by%TYPE,
666: p_spreadsheet IN VARCHAR2,
667: p_batch_id IN pon_interface_errors.batch_id%TYPE,
668: p_request_id IN pon_interface_errors.request_id%TYPE
669: ) IS

Line 667: p_batch_id IN pon_interface_errors.batch_id%TYPE,

663: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
664: p_interface_type IN pon_interface_errors.interface_type%TYPE,
665: p_userid IN pon_interface_errors.created_by%TYPE,
666: p_spreadsheet IN VARCHAR2,
667: p_batch_id IN pon_interface_errors.batch_id%TYPE,
668: p_request_id IN pon_interface_errors.request_id%TYPE
669: ) IS
670: BEGIN
671:

Line 668: p_request_id IN pon_interface_errors.request_id%TYPE

664: p_interface_type IN pon_interface_errors.interface_type%TYPE,
665: p_userid IN pon_interface_errors.created_by%TYPE,
666: p_spreadsheet IN VARCHAR2,
667: p_batch_id IN pon_interface_errors.batch_id%TYPE,
668: p_request_id IN pon_interface_errors.request_id%TYPE
669: ) IS
670: BEGIN
671:
672: INSERT ALL

Line 684: INTO pon_interface_errors

680: AND al.auction_header_id = bl.auction_header_id
681: AND al.line_number = bl.line_number
682: AND al.auction_header_id = p_auc_header_id
683: AND al.parent_line_number = s_line_number) = 'N' THEN
684: INTO pon_interface_errors
685: (INTERFACE_TYPE,
686: TABLE_NAME,
687: BATCH_ID,
688: INTERFACE_LINE_ID,

Line 736: INTO pon_interface_errors

732: AND al.auction_header_id = p_auc_header_id
733: AND al.parent_line_number = s_line_number
734: AND bl.has_bid_flag = 'Y'
735: AND rownum = 1) THEN
736: INTO pon_interface_errors
737: (INTERFACE_TYPE,
738: TABLE_NAME,
739: BATCH_ID,
740: INTERFACE_LINE_ID,

Line 807: p_interface_type IN pon_interface_errors.interface_type%TYPE,

803: PROCEDURE validate_lines
804: (
805: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
806: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
807: p_interface_type IN pon_interface_errors.interface_type%TYPE,
808: p_userid IN pon_interface_errors.created_by%TYPE,
809: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
810: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
811: p_spreadsheet IN VARCHAR2,

Line 808: p_userid IN pon_interface_errors.created_by%TYPE,

804: (
805: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
806: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
807: p_interface_type IN pon_interface_errors.interface_type%TYPE,
808: p_userid IN pon_interface_errors.created_by%TYPE,
809: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
810: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
811: p_spreadsheet IN VARCHAR2,
812: p_blanket IN VARCHAR2,

Line 828: p_batch_id IN pon_interface_errors.batch_id%TYPE,

824: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
825: p_amt_precision IN fnd_currencies.precision%TYPE,
826: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
827: p_suffix IN VARCHAR2,
828: p_batch_id IN pon_interface_errors.batch_id%TYPE,
829: p_request_id IN pon_interface_errors.request_id%TYPE
830: --added by Allen Yang for Surrogate Bid 2008/09/03
831: --------------------------------------------------
832: , p_two_part_tech_surrogate_flag IN VARCHAR2

Line 829: p_request_id IN pon_interface_errors.request_id%TYPE

825: p_amt_precision IN fnd_currencies.precision%TYPE,
826: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
827: p_suffix IN VARCHAR2,
828: p_batch_id IN pon_interface_errors.batch_id%TYPE,
829: p_request_id IN pon_interface_errors.request_id%TYPE
830: --added by Allen Yang for Surrogate Bid 2008/09/03
831: --------------------------------------------------
832: , p_two_part_tech_surrogate_flag IN VARCHAR2
833: --------------------------------------------------

Line 848: INTO pon_interface_errors

844: INSERT ALL
845:
846: -- Header level field min_bid_change is required if there is a proxy line
847: WHEN p_min_bid_change IS null AND s_proxy_bid_limit_price IS NOT null THEN
848: INTO pon_interface_errors
849: (INTERFACE_TYPE,
850: COLUMN_NAME,
851: TABLE_NAME,
852: BATCH_ID,

Line 908: INTO pon_interface_errors

904: ---------------------------------------------------
905: AND p_two_part_tech_surrogate_flag = 'N'
906: ---------------------------------------------------
907: THEN
908: INTO pon_interface_errors
909: (INTERFACE_TYPE,
910: TABLE_NAME,
911: BATCH_ID,
912: INTERFACE_LINE_ID,

Line 962: INTO pon_interface_errors

958: ---------------------------------------------------
959: AND p_two_part_tech_surrogate_flag = 'N'
960: ---------------------------------------------------
961: THEN
962: INTO pon_interface_errors
963: (INTERFACE_TYPE,
964: TABLE_NAME,
965: COLUMN_NAME,
966: BATCH_ID,

Line 1013: INTO pon_interface_errors

1009: s_entity_message_code)
1010:
1011: -- Quantity is a required field if it is editable
1012: WHEN p_blanket = 'N' AND s_qty_editable = 'Y' AND s_bid_quantity IS null THEN
1013: INTO pon_interface_errors
1014: (INTERFACE_TYPE,
1015: TABLE_NAME,
1016: COLUMN_NAME,
1017: BATCH_ID,

Line 1065: INTO pon_interface_errors

1061:
1062: -- Bug 7460446 Bid cannot be zero or negative
1063: -- Doesn't apply for blanket agreements
1064: WHEN p_blanket = 'N' AND s_bid_quantity <= 0 THEN
1065: INTO pon_interface_errors
1066: (INTERFACE_TYPE,
1067: COLUMN_NAME,
1068: TABLE_NAME,
1069: BATCH_ID,

Line 1119: INTO pon_interface_errors

1115:
1116: -- Bid quantity should not exceed auction quantity
1117: -- Does not apply for blanket agreements
1118: WHEN p_blanket = 'N' AND s_bid_quantity > s_auc_quantity THEN
1119: INTO pon_interface_errors
1120: (INTERFACE_TYPE,
1121: COLUMN_NAME,
1122: TABLE_NAME,
1123: BATCH_ID,

Line 1179: INTO pon_interface_errors

1175: ---------------------------------------------------
1176: AND p_two_part_tech_surrogate_flag = 'N'
1177: ---------------------------------------------------
1178: THEN
1179: INTO pon_interface_errors
1180: (INTERFACE_TYPE,
1181: COLUMN_NAME,
1182: TABLE_NAME,
1183: BATCH_ID,

Line 1236: INTO pon_interface_errors

1232: ---------------------------------------------------
1233: AND p_two_part_tech_surrogate_flag = 'N'
1234: ---------------------------------------------------
1235: THEN
1236: INTO pon_interface_errors
1237: (INTERFACE_TYPE,
1238: COLUMN_NAME,
1239: TABLE_NAME,
1240: BATCH_ID,

Line 1289: INTO pon_interface_errors

1285: s_entity_message_code)
1286:
1287: -- po_bid_min_rel_amount should not be negative
1288: WHEN p_blanket = 'Y' AND s_po_bid_min_rel_amount < 0 THEN
1289: INTO pon_interface_errors
1290: (INTERFACE_TYPE,
1291: COLUMN_NAME,
1292: TABLE_NAME,
1293: BATCH_ID,

Line 1343: INTO pon_interface_errors

1339:
1340: -- po_bid_min_rel_amount should not exceed currency precision
1341: WHEN p_blanket = 'Y' AND validate_currency_precision(
1342: s_po_bid_min_rel_amount, p_amt_precision) = 'F' THEN
1343: INTO pon_interface_errors
1344: (INTERFACE_TYPE,
1345: COLUMN_NAME,
1346: TABLE_NAME,
1347: BATCH_ID,

Line 1404: INTO pon_interface_errors

1400: ---------------------------------------------------
1401: AND p_two_part_tech_surrogate_flag = 'N'
1402: ---------------------------------------------------
1403: THEN
1404: INTO pon_interface_errors
1405: (INTERFACE_TYPE,
1406: COLUMN_NAME,
1407: TABLE_NAME,
1408: BATCH_ID,

Line 1466: INTO pon_interface_errors

1462: ---------------------------------------------------
1463: AND p_two_part_tech_surrogate_flag = 'N'
1464: ---------------------------------------------------
1465: THEN
1466: INTO pon_interface_errors
1467: (INTERFACE_TYPE,
1468: COLUMN_NAME,
1469: TABLE_NAME,
1470: BATCH_ID,

Line 1525: INTO pon_interface_errors

1521: ---------------------------------------------------
1522: AND p_two_part_tech_surrogate_flag = 'N'
1523: ---------------------------------------------------
1524: THEN
1525: INTO pon_interface_errors
1526: (INTERFACE_TYPE,
1527: COLUMN_NAME,
1528: TABLE_NAME,
1529: BATCH_ID,

Line 1622: INTO pon_interface_errors

1618: ---------------------------------------------------
1619: AND p_two_part_tech_surrogate_flag = 'N'
1620: ---------------------------------------------------
1621: THEN
1622: INTO pon_interface_errors
1623: (INTERFACE_TYPE,
1624: COLUMN_NAME,
1625: TABLE_NAME,
1626: BATCH_ID,

Line 1685: INTO pon_interface_errors

1681: p_two_part_tech_surrogate_flag = 'N' AND
1682: ---------------------------------------------------
1683: validate_price_precision(s_bid_currency_price, p_price_precision) = 'F'
1684: THEN
1685: INTO pon_interface_errors
1686: (INTERFACE_TYPE,
1687: COLUMN_NAME,
1688: TABLE_NAME,
1689: BATCH_ID,

Line 1746: INTO pon_interface_errors

1742: ---------------------------------------------------
1743: AND p_two_part_tech_surrogate_flag = 'N'
1744: ---------------------------------------------------
1745: THEN
1746: INTO pon_interface_errors
1747: (INTERFACE_TYPE,
1748: COLUMN_NAME,
1749: TABLE_NAME,
1750: BATCH_ID,

Line 1804: INTO pon_interface_errors

1800: ---------------------------------------------------
1801: AND p_two_part_tech_surrogate_flag = 'N'
1802: ---------------------------------------------------
1803: THEN
1804: INTO pon_interface_errors
1805: (INTERFACE_TYPE,
1806: COLUMN_NAME,
1807: TABLE_NAME,
1808: BATCH_ID,

Line 1865: INTO pon_interface_errors

1861: ---------------------------------------------------
1862: p_two_part_tech_surrogate_flag = 'N' AND
1863: ---------------------------------------------------
1864: validate_price_precision(s_bid_currency_limit_price, p_price_precision) = 'F' THEN
1865: INTO pon_interface_errors
1866: (INTERFACE_TYPE,
1867: COLUMN_NAME,
1868: TABLE_NAME,
1869: BATCH_ID,

Line 1933: INTO pon_interface_errors

1929: ---------------------------------------------------
1930: AND p_two_part_tech_surrogate_flag = 'N'
1931: ---------------------------------------------------
1932: THEN
1933: INTO pon_interface_errors
1934: (INTERFACE_TYPE,
1935: COLUMN_NAME,
1936: TABLE_NAME,
1937: BATCH_ID,

Line 2014: INTO pon_interface_errors

2010: ---------------------------------------------------
2011: AND p_two_part_tech_surrogate_flag = 'N'
2012: ---------------------------------------------------
2013: THEN
2014: INTO pon_interface_errors
2015: (INTERFACE_TYPE,
2016: COLUMN_NAME,
2017: TABLE_NAME,
2018: BATCH_ID,

Line 2089: INTO pon_interface_errors

2085: ---------------------------------------------------
2086: AND p_two_part_tech_surrogate_flag = 'N'
2087: ---------------------------------------------------
2088: THEN
2089: INTO pon_interface_errors
2090: (INTERFACE_TYPE,
2091: COLUMN_NAME,
2092: TABLE_NAME,
2093: BATCH_ID,

Line 2159: INTO pon_interface_errors

2155: ---------------------------------------------------
2156: AND p_two_part_tech_surrogate_flag = 'N'
2157: ---------------------------------------------------
2158: THEN
2159: INTO pon_interface_errors
2160: (INTERFACE_TYPE,
2161: COLUMN_NAME,
2162: TABLE_NAME,
2163: BATCH_ID,

Line 2222: INTO pon_interface_errors

2218: ---------------------------------------------------
2219: AND p_two_part_tech_surrogate_flag = 'N'
2220: ---------------------------------------------------
2221: THEN
2222: INTO pon_interface_errors
2223: (INTERFACE_TYPE,
2224: COLUMN_NAME,
2225: TABLE_NAME,
2226: BATCH_ID,

Line 2280: INTO pon_interface_errors

2276: -- There was a previous bid on this line which was deleted
2277: -- Not allowed to unbid when rebidding.
2278: WHEN p_rebid = 'Y' AND s_is_changed_line_flag = 'Y'
2279: AND s_has_bid_flag = 'N' THEN
2280: INTO pon_interface_errors
2281: (INTERFACE_TYPE,
2282: TABLE_NAME,
2283: BATCH_ID,
2284: INTERFACE_LINE_ID,

Line 2329: INTO pon_interface_errors

2325: ---------------------------------------------------
2326: AND p_two_part_tech_surrogate_flag = 'N'
2327: ---------------------------------------------------
2328: THEN
2329: INTO pon_interface_errors
2330: (INTERFACE_TYPE,
2331: TABLE_NAME,
2332: BATCH_ID,
2333: INTERFACE_LINE_ID,

Line 2391: INTO pon_interface_errors

2387: WHERE bpb.bid_number = p_bid_number
2388: AND bpb.line_number = s_line_number
2389: AND bpb.shipment_type = 'PRICE BREAK')
2390: THEN
2391: INTO pon_interface_errors
2392: (INTERFACE_TYPE,
2393: TABLE_NAME,
2394: BATCH_ID,
2395: INTERFACE_LINE_ID,

Line 2498: INTO pon_interface_errors

2494: ---------------------------------------------------
2495: p_two_part_tech_surrogate_flag = 'N' AND
2496: ---------------------------------------------------
2497: retainage_rate_percent IS NOT NULL AND (retainage_rate_percent < 0 OR retainage_rate_percent > 100) THEN
2498: INTO pon_interface_errors
2499: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2500: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2501: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2502: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2523: INTO pon_interface_errors

2519: ---------------------------------------------------
2520: p_two_part_tech_surrogate_flag = 'N' AND
2521: ---------------------------------------------------
2522: bid_curr_max_retainage_amt IS NOT NULL AND bid_curr_max_retainage_amt < 0 THEN
2523: INTO pon_interface_errors
2524: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2525: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2526: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2527: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2548: INTO pon_interface_errors

2544: ---------------------------------------------------
2545: p_two_part_tech_surrogate_flag = 'N' AND
2546: ---------------------------------------------------
2547: bid_curr_advance_amount IS NOT NULL AND bid_curr_advance_amount < 0 THEN
2548: INTO pon_interface_errors
2549: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2550: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2551: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2552: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2574: INTO pon_interface_errors

2570: p_two_part_tech_surrogate_flag = 'N' AND
2571: ---------------------------------------------------
2572: progress_pymt_rate_percent IS NOT NULL AND
2573: (progress_pymt_rate_percent < 0 OR progress_pymt_rate_percent > 100) THEN
2574: INTO pon_interface_errors
2575: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2576: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2577: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2578: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2600: INTO pon_interface_errors

2596: p_two_part_tech_surrogate_flag = 'N' AND
2597: ---------------------------------------------------
2598: recoupment_rate_percent IS NOT NULL AND
2599: (recoupment_rate_percent < 0 OR recoupment_rate_percent > 100) THEN
2600: INTO pon_interface_errors
2601: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2602: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2603: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2604: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2626: INTO pon_interface_errors

2622: p_two_part_tech_surrogate_flag = 'N' AND
2623: ---------------------------------------------------
2624: progress_payment_type = 'FINANCE' AND contract_type='STANDARD'
2625: AND s_group_type NOT IN ('GROUP','LOT_LINE') AND progress_pymt_rate_percent IS NULL THEN
2626: INTO pon_interface_errors
2627: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2628: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2629: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2630: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2655: INTO pon_interface_errors

2651: p_two_part_tech_surrogate_flag = 'N' AND
2652: ---------------------------------------------------
2653: retainage_negotiable_flag = 'Y'
2654: AND s_group_type NOT IN ('GROUP','LOT_LINE') AND retainage_rate_percent IS NULL THEN
2655: INTO pon_interface_errors
2656: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2657: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2658: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2659: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2682: INTO pon_interface_errors

2678: p_two_part_tech_surrogate_flag = 'N' AND
2679: ---------------------------------------------------
2680: max_retainage_negotiable_flag = 'Y'
2681: AND s_group_type NOT IN ('GROUP','LOT_LINE') AND bid_curr_max_retainage_amt IS NULL THEN
2682: INTO pon_interface_errors
2683: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2684: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2685: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2686: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2714: INTO pon_interface_errors

2710: ((recoupment_negotiable_flag = 'Y' AND recoupment_rate_percent IS NULL) OR
2711: ((progress_pymt_rate_percent IS NOT NULL OR bid_curr_advance_amount IS NOT NULL) AND
2712: recoupment_rate_percent IS NULL)))
2713: THEN
2714: INTO pon_interface_errors
2715: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2716: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2717: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2718: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2742: INTO pon_interface_errors

2738: ---------------------------------------------------
2739: advance_negotiable_flag = 'Y'
2740: AND s_group_type NOT IN ('GROUP','LOT_LINE')
2741: AND bid_curr_advance_amount IS NULL THEN
2742: INTO pon_interface_errors
2743: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2744: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2745: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2746: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2807: INTO pon_interface_errors

2803: p_two_part_tech_surrogate_flag = 'N' AND
2804: ---------------------------------------------------
2805: bid_curr_advance_amount IS NOT NULL AND s_bid_currency_unit_price IS NOT NULL AND
2806: (bid_curr_advance_amount > (NVL(s_bid_quantity,1) * s_bid_currency_unit_price)) THEN
2807: INTO pon_interface_errors
2808: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2809: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2810: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2811: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2839: INTO pon_interface_errors

2835: WHERE p_bps.auction_header_id=p_auc_header_id
2836: AND p_bps.bid_line_number=s_line_number
2837: AND p_bps.bid_number=p_bid_number))
2838: + nvl(bid_curr_advance_amount,0)) * 100)/((nvl(s_bid_quantity, 1) * s_bid_currency_unit_price))) THEN
2839: INTO pon_interface_errors
2840: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2841: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2842: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2843: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2866: INTO pon_interface_errors

2862: (p_spreadsheet = g_online_mode OR p_spreadsheet = g_xml_upload_mode) AND progress_payment_type = 'ACTUAL' AND
2863: recoupment_rate_percent IS NOT NULL AND bid_curr_advance_amount IS NOT NULL AND
2864: s_bid_currency_unit_price IS NOT NULL AND
2865: recoupment_rate_percent <((bid_curr_advance_amount * 100)/(nvl(s_bid_quantity,1) * s_bid_currency_unit_price)) THEN
2866: INTO pon_interface_errors
2867: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2868: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2869: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2870: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2898: INTO pon_interface_errors

2894: FROM pon_bid_payments_shipments pbps
2895: WHERE pbps.auction_header_id = p_auc_header_id
2896: AND pbps.bid_number = p_bid_number
2897: AND pbps.bid_line_number = s_line_number) THEN
2898: INTO pon_interface_errors
2899: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2900: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2901: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2902: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2930: INTO pon_interface_errors

2926: FROM pon_bid_payments_shipments
2927: WHERE auction_header_id = p_auc_header_id
2928: AND bid_number = p_bid_number
2929: AND bid_line_number = s_line_number) THEN
2930: INTO pon_interface_errors
2931: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2932: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2933: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2934: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2956: INTO pon_interface_errors

2952: p_two_part_tech_surrogate_flag = 'N' AND
2953: ---------------------------------------------------
2954: bid_curr_advance_amount IS NOT NULL AND
2955: validate_currency_precision(bid_curr_advance_amount, p_amt_precision) = 'F' THEN
2956: INTO pon_interface_errors
2957: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2958: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2959: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2960: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 2984: INTO pon_interface_errors

2980: p_two_part_tech_surrogate_flag = 'N' AND
2981: ---------------------------------------------------
2982: bid_curr_max_retainage_amt IS NOT NULL AND
2983: validate_currency_precision(bid_curr_max_retainage_amt, p_amt_precision) = 'F' THEN
2984: INTO pon_interface_errors
2985: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2986: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
2987: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
2988: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 3011: INTO pon_interface_errors

3007: p_two_part_tech_surrogate_flag = 'N' AND
3008: ---------------------------------------------------
3009: progress_pymt_rate_percent IS NOT NULL AND
3010: validate_currency_precision(progress_pymt_rate_percent, 2) = 'F' THEN
3011: INTO pon_interface_errors
3012: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
3013: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
3014: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
3015: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 3038: INTO pon_interface_errors

3034: p_two_part_tech_surrogate_flag = 'N' AND
3035: ---------------------------------------------------
3036: retainage_rate_percent IS NOT NULL AND
3037: validate_currency_precision(retainage_rate_percent, 2) = 'F' THEN
3038: INTO pon_interface_errors
3039: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
3040: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
3041: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
3042: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 3065: INTO pon_interface_errors

3061: p_two_part_tech_surrogate_flag = 'N' AND
3062: ---------------------------------------------------
3063: recoupment_rate_percent IS NOT NULL AND
3064: validate_currency_precision(recoupment_rate_percent, 2) = 'F' THEN
3065: INTO pon_interface_errors
3066: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
3067: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
3068: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, --3
3069: LAST_UPDATE_DATE, REQUEST_ID, ENTITY_TYPE, --4

Line 3125: p_interface_type IN pon_interface_errors.interface_type%TYPE,

3121: PROCEDURE validate_requirements
3122: (
3123: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3124: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3125: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3126: p_userid IN pon_interface_errors.created_by%TYPE,
3127: p_spreadsheet IN VARCHAR2,
3128: p_suffix IN VARCHAR2,
3129: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 3126: p_userid IN pon_interface_errors.created_by%TYPE,

3122: (
3123: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3124: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3125: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3126: p_userid IN pon_interface_errors.created_by%TYPE,
3127: p_spreadsheet IN VARCHAR2,
3128: p_suffix IN VARCHAR2,
3129: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3130: p_request_id IN pon_interface_errors.request_id%TYPE

Line 3129: p_batch_id IN pon_interface_errors.batch_id%TYPE,

3125: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3126: p_userid IN pon_interface_errors.created_by%TYPE,
3127: p_spreadsheet IN VARCHAR2,
3128: p_suffix IN VARCHAR2,
3129: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3130: p_request_id IN pon_interface_errors.request_id%TYPE
3131: -- added by Allen Yang for Surrogate Bid 2008/09/03
3132: ---------------------------------------------------
3133: , p_two_part_tech_surrogate_flag IN VARCHAR2

Line 3130: p_request_id IN pon_interface_errors.request_id%TYPE

3126: p_userid IN pon_interface_errors.created_by%TYPE,
3127: p_spreadsheet IN VARCHAR2,
3128: p_suffix IN VARCHAR2,
3129: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3130: p_request_id IN pon_interface_errors.request_id%TYPE
3131: -- added by Allen Yang for Surrogate Bid 2008/09/03
3132: ---------------------------------------------------
3133: , p_two_part_tech_surrogate_flag IN VARCHAR2
3134: ---------------------------------------------------

Line 3149: INTO pon_interface_errors

3145: AND s_value IS null AND p_two_part_tech_surrogate_flag = 'Y'
3146: AND s_two_part_section_type = 'TECHNICAL')
3147: -------------------------------------------------------------------
3148: THEN
3149: INTO pon_interface_errors
3150: (INTERFACE_TYPE,
3151: COLUMN_NAME,
3152: TABLE_NAME,
3153: BATCH_ID,

Line 3206: INTO pon_interface_errors

3202: WHERE bs.auction_header_id = p_auc_header_id
3203: AND bs.line_number = s_line_number
3204: AND bs.attribute_sequence_number = s_sequence_number
3205: AND bs.value = s_value) THEN
3206: INTO pon_interface_errors
3207: (INTERFACE_TYPE,
3208: COLUMN_NAME,
3209: TABLE_NAME,
3210: BATCH_ID,

Line 3296: p_interface_type IN pon_interface_errors.interface_type%TYPE,

3292: PROCEDURE validate_attributes
3293: (
3294: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3295: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3296: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3297: p_userid IN pon_interface_errors.created_by%TYPE,
3298: p_spreadsheet IN VARCHAR2,
3299: p_suffix IN VARCHAR2,
3300: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 3297: p_userid IN pon_interface_errors.created_by%TYPE,

3293: (
3294: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3295: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3296: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3297: p_userid IN pon_interface_errors.created_by%TYPE,
3298: p_spreadsheet IN VARCHAR2,
3299: p_suffix IN VARCHAR2,
3300: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3301: p_request_id IN pon_interface_errors.request_id%TYPE

Line 3300: p_batch_id IN pon_interface_errors.batch_id%TYPE,

3296: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3297: p_userid IN pon_interface_errors.created_by%TYPE,
3298: p_spreadsheet IN VARCHAR2,
3299: p_suffix IN VARCHAR2,
3300: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3301: p_request_id IN pon_interface_errors.request_id%TYPE
3302: ) IS
3303: BEGIN
3304:

Line 3301: p_request_id IN pon_interface_errors.request_id%TYPE

3297: p_userid IN pon_interface_errors.created_by%TYPE,
3298: p_spreadsheet IN VARCHAR2,
3299: p_suffix IN VARCHAR2,
3300: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3301: p_request_id IN pon_interface_errors.request_id%TYPE
3302: ) IS
3303: BEGIN
3304:
3305: INSERT FIRST

Line 3309: INTO pon_interface_errors

3305: INSERT FIRST
3306:
3307: -- value must be entered if it is a required attribute
3308: WHEN s_mandatory_flag = 'Y' AND s_value IS null THEN
3309: INTO pon_interface_errors
3310: (INTERFACE_TYPE,
3311: COLUMN_NAME,
3312: TABLE_NAME,
3313: BATCH_ID,

Line 3372: INTO pon_interface_errors

3368: WHERE bs.auction_header_id = p_auc_header_id
3369: AND bs.line_number = s_line_number
3370: AND bs.attribute_sequence_number = s_sequence_number
3371: AND bs.value = s_value) THEN
3372: INTO pon_interface_errors
3373: (INTERFACE_TYPE,
3374: COLUMN_NAME,
3375: TABLE_NAME,
3376: BATCH_ID,

Line 3459: p_interface_type IN pon_interface_errors.interface_type%TYPE,

3455: PROCEDURE validate_cost_factors
3456: (
3457: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3458: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3459: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3460: p_userid IN pon_interface_errors.created_by%TYPE,
3461: p_spreadsheet IN VARCHAR2,
3462: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
3463: p_amt_precision IN fnd_currencies.precision%TYPE,

Line 3460: p_userid IN pon_interface_errors.created_by%TYPE,

3456: (
3457: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3458: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3459: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3460: p_userid IN pon_interface_errors.created_by%TYPE,
3461: p_spreadsheet IN VARCHAR2,
3462: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
3463: p_amt_precision IN fnd_currencies.precision%TYPE,
3464: p_suffix IN VARCHAR2,

Line 3465: p_batch_id IN pon_interface_errors.batch_id%TYPE,

3461: p_spreadsheet IN VARCHAR2,
3462: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
3463: p_amt_precision IN fnd_currencies.precision%TYPE,
3464: p_suffix IN VARCHAR2,
3465: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3466: p_request_id IN pon_interface_errors.request_id%TYPE
3467: ) IS
3468: BEGIN
3469:

Line 3466: p_request_id IN pon_interface_errors.request_id%TYPE

3462: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
3463: p_amt_precision IN fnd_currencies.precision%TYPE,
3464: p_suffix IN VARCHAR2,
3465: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3466: p_request_id IN pon_interface_errors.request_id%TYPE
3467: ) IS
3468: BEGIN
3469:
3470: -- The following validations are performed only for SUPPLIER cost factors

Line 3475: INTO pon_interface_errors

3471: INSERT FIRST
3472:
3473: -- bid_currency_value must recieve a bid
3474: WHEN s_bid_currency_value IS null THEN
3475: INTO pon_interface_errors
3476: (INTERFACE_TYPE,
3477: COLUMN_NAME,
3478: TABLE_NAME,
3479: BATCH_ID,

Line 3532: INTO pon_interface_errors

3528: s_entity_message_code)
3529:
3530: -- Line price cost factor must be positive
3531: WHEN s_sequence_number = -10 AND s_bid_currency_value <= 0 THEN
3532: INTO pon_interface_errors
3533: (INTERFACE_TYPE,
3534: COLUMN_NAME,
3535: TABLE_NAME,
3536: BATCH_ID,

Line 3591: INTO pon_interface_errors

3587: s_entity_message_code)
3588:
3589: -- Cost factor value must be postive or zero if not line price
3590: WHEN s_sequence_number <> -10 AND s_bid_currency_value < 0 THEN
3591: INTO pon_interface_errors
3592: (INTERFACE_TYPE,
3593: COLUMN_NAME,
3594: TABLE_NAME,
3595: BATCH_ID,

Line 3652: INTO pon_interface_errors

3648: -- bid_currency_precision must not exceed price precision for PER_UNIT cf
3649: WHEN s_pricing_basis = 'PER_UNIT'
3650: AND validate_price_precision(s_bid_currency_value,
3651: p_price_precision) = 'F' THEN
3652: INTO pon_interface_errors
3653: (INTERFACE_TYPE,
3654: COLUMN_NAME,
3655: TABLE_NAME,
3656: BATCH_ID,

Line 3713: INTO pon_interface_errors

3709: -- bid_currency_precision must not exceed currency precision for FIXED_AMOUNT cf
3710: WHEN s_pricing_basis = 'FIXED_AMOUNT'
3711: AND validate_currency_precision(s_bid_currency_value,
3712: p_amt_precision) = 'F' THEN
3713: INTO pon_interface_errors
3714: (INTERFACE_TYPE,
3715: COLUMN_NAME,
3716: TABLE_NAME,
3717: BATCH_ID,

Line 3810: p_interface_type IN pon_interface_errors.interface_type%TYPE,

3806: PROCEDURE validate_price_breaks
3807: (
3808: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3809: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3810: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3811: p_userid IN pon_interface_errors.created_by%TYPE,
3812: p_spreadsheet IN VARCHAR2,
3813: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
3814: p_trans_view IN VARCHAR2,

Line 3811: p_userid IN pon_interface_errors.created_by%TYPE,

3807: (
3808: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3809: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3810: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3811: p_userid IN pon_interface_errors.created_by%TYPE,
3812: p_spreadsheet IN VARCHAR2,
3813: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
3814: p_trans_view IN VARCHAR2,
3815: p_blanket IN VARCHAR2,

Line 3821: p_batch_id IN pon_interface_errors.batch_id%TYPE,

3817: p_po_start_date IN pon_auction_headers_all.po_start_date%TYPE,
3818: p_po_end_date IN pon_auction_headers_all.po_end_date%TYPE,
3819: p_auc_close_date IN pon_auction_headers_all.close_bidding_date%TYPE,
3820: p_suffix IN VARCHAR2,
3821: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3822: p_request_id IN pon_interface_errors.request_id%TYPE
3823: ) IS
3824: BEGIN
3825:

Line 3822: p_request_id IN pon_interface_errors.request_id%TYPE

3818: p_po_end_date IN pon_auction_headers_all.po_end_date%TYPE,
3819: p_auc_close_date IN pon_auction_headers_all.close_bidding_date%TYPE,
3820: p_suffix IN VARCHAR2,
3821: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3822: p_request_id IN pon_interface_errors.request_id%TYPE
3823: ) IS
3824: BEGIN
3825:
3826: INSERT ALL

Line 3830: INTO pon_interface_errors

3826: INSERT ALL
3827:
3828: -- quantity must be positive or zero
3829: WHEN s_quantity < 0 THEN
3830: INTO pon_interface_errors
3831: (INTERFACE_TYPE,
3832: TABLE_NAME,
3833: COLUMN_NAME,
3834: BATCH_ID,

Line 3886: INTO pon_interface_errors

3882:
3883: -- bid_currency_unit_price must be positive
3884: -- Only applier if price_type is PRICE
3885: WHEN s_price_type = 'PRICE' AND s_bid_currency_unit_price < 0 THEN
3886: INTO pon_interface_errors
3887: (INTERFACE_TYPE,
3888: TABLE_NAME,
3889: COLUMN_NAME,
3890: BATCH_ID,

Line 3943: INTO pon_interface_errors

3939: -- bid_currency_unit_price precision must not exceed price precision
3940: -- Only applier if price_type is PRICE
3941: WHEN s_price_type = 'PRICE' AND validate_price_precision(
3942: s_bid_currency_unit_price, p_price_precision) = 'F' THEN
3943: INTO pon_interface_errors
3944: (INTERFACE_TYPE,
3945: TABLE_NAME,
3946: COLUMN_NAME,
3947: BATCH_ID,

Line 4002: INTO pon_interface_errors

3998: -- in untransformed view, we can use s_price (which is the
3999: -- transformed price in auction currency)
4000: -- NOTE: rate conversion is unneccessary since we only check sign
4001: WHEN p_trans_view = 'N' AND s_price < 0 THEN
4002: INTO pon_interface_errors
4003: (INTERFACE_TYPE,
4004: TABLE_NAME,
4005: BATCH_ID,
4006: INTERFACE_LINE_ID,

Line 4055: INTO pon_interface_errors

4051: s_entity_name)
4052:
4053: -- bid_currency_price must be positive
4054: WHEN p_trans_view = 'Y' AND s_bid_currency_price < 0 THEN
4055: INTO pon_interface_errors
4056: (INTERFACE_TYPE,
4057: TABLE_NAME,
4058: BATCH_ID,
4059: INTERFACE_LINE_ID,

Line 4111: INTO pon_interface_errors

4107:
4108: -- bid_currency_price precision must not exceed price precision
4109: WHEN validate_price_precision(
4110: s_bid_currency_price, p_price_precision) = 'F' THEN
4111: INTO pon_interface_errors
4112: (INTERFACE_TYPE,
4113: TABLE_NAME,
4114: BATCH_ID,
4115: INTERFACE_LINE_ID,

Line 4166: INTO pon_interface_errors

4162: -- price_discount must be 0 to 100
4163: -- Only applies if price_type is PRICE DISCOUNT
4164: WHEN s_price_type = 'PRICE DISCOUNT'
4165: AND (s_price_discount < 0 OR s_price_discount > 100) THEN
4166: INTO pon_interface_errors
4167: (INTERFACE_TYPE,
4168: TABLE_NAME,
4169: COLUMN_NAME,
4170: BATCH_ID,

Line 4221: INTO pon_interface_errors

4217: s_entity_name)
4218:
4219: -- effective_start_date must be past the current date
4220: WHEN s_effective_start_date < s_current_date THEN
4221: INTO pon_interface_errors
4222: (INTERFACE_TYPE,
4223: TABLE_NAME,
4224: COLUMN_NAME,
4225: BATCH_ID,

Line 4275: INTO pon_interface_errors

4271: s_worksheet_seq_num,
4272: s_entity_name)
4273: -- effective_start_date must be after po start date
4274: WHEN s_effective_start_date < p_po_start_date THEN
4275: INTO pon_interface_errors
4276: (INTERFACE_TYPE,
4277: TABLE_NAME,
4278: COLUMN_NAME,
4279: BATCH_ID,

Line 4330: INTO pon_interface_errors

4326: s_entity_name)
4327:
4328: -- effective_start_date must be before po end date
4329: WHEN s_effective_start_date > p_po_end_date THEN
4330: INTO pon_interface_errors
4331: (INTERFACE_TYPE,
4332: TABLE_NAME,
4333: COLUMN_NAME,
4334: BATCH_ID,

Line 4385: INTO pon_interface_errors

4381: s_entity_name)
4382:
4383: -- effective start date must be after auction close date
4384: WHEN s_effective_start_date < p_auc_close_date THEN
4385: INTO pon_interface_errors
4386: (INTERFACE_TYPE,
4387: TABLE_NAME,
4388: COLUMN_NAME,
4389: BATCH_ID,

Line 4439: INTO pon_interface_errors

4435: s_worksheet_seq_num,
4436: s_entity_name)
4437: -- effective_end_date must be after current date
4438: WHEN s_effective_end_date < s_current_date THEN
4439: INTO pon_interface_errors
4440: (INTERFACE_TYPE,
4441: TABLE_NAME,
4442: COLUMN_NAME,
4443: BATCH_ID,

Line 4494: INTO pon_interface_errors

4490: s_entity_name)
4491:
4492: -- effective_end_date must be after po start date
4493: WHEN s_effective_end_date < p_po_start_date THEN
4494: INTO pon_interface_errors
4495: (INTERFACE_TYPE,
4496: TABLE_NAME,
4497: COLUMN_NAME,
4498: BATCH_ID,

Line 4549: INTO pon_interface_errors

4545: s_entity_name)
4546:
4547: -- effective_end_date must be before po end date
4548: WHEN s_effective_end_date > p_po_end_date THEN
4549: INTO pon_interface_errors
4550: (INTERFACE_TYPE,
4551: TABLE_NAME,
4552: COLUMN_NAME,
4553: BATCH_ID,

Line 4604: INTO pon_interface_errors

4600: s_entity_name)
4601:
4602: -- effective_end_date must be after auction close date
4603: WHEN s_effective_end_date < p_auc_close_date THEN
4604: INTO pon_interface_errors
4605: (INTERFACE_TYPE,
4606: TABLE_NAME,
4607: COLUMN_NAME,
4608: BATCH_ID,

Line 4664: INTO pon_interface_errors

4660: AND s_ship_to_location_id IS null
4661: AND s_quantity IS null
4662: AND s_effective_start_date IS null
4663: AND s_effective_end_date IS null THEN
4664: INTO pon_interface_errors
4665: (INTERFACE_TYPE,
4666: TABLE_NAME,
4667: BATCH_ID,
4668: INTERFACE_LINE_ID,

Line 4712: INTO pon_interface_errors

4708: s_worksheet_seq_num,
4709: s_entity_name)
4710: -- effective_start_date must be before effective_end_date
4711: WHEN s_effective_start_date > s_effective_end_date THEN
4712: INTO pon_interface_errors
4713: (INTERFACE_TYPE,
4714: TABLE_NAME,
4715: COLUMN_NAME,
4716: BATCH_ID,

Line 4767: INTO pon_interface_errors

4763: s_entity_name)
4764:
4765: -- Either bid_currency_unit_price or price_discount must have a value
4766: WHEN s_bid_currency_unit_price IS null AND s_price_discount IS null THEN
4767: INTO pon_interface_errors
4768: (INTERFACE_TYPE,
4769: TABLE_NAME,
4770: COLUMN_NAME,
4771: BATCH_ID,

Line 4820: INTO pon_interface_errors

4816: -- CUMULATIVE price breaks cannot have start and end dates
4817: WHEN s_price_break_type = 'CUMULATIVE'
4818: AND (s_effective_start_date IS NOT null
4819: OR s_effective_end_date IS NOT null) THEN
4820: INTO pon_interface_errors
4821: (INTERFACE_TYPE,
4822: TABLE_NAME,
4823: BATCH_ID,
4824: INTERFACE_LINE_ID,

Line 4934: p_interface_type IN pon_interface_errors.interface_type%TYPE,

4930: PROCEDURE VALIDATE_QTY_BASED_PRICE_TIERS
4931: (
4932: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
4933: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
4934: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4935: p_userid IN pon_interface_errors.created_by%TYPE,
4936: p_spreadsheet IN VARCHAR2,
4937: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
4938: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 4935: p_userid IN pon_interface_errors.created_by%TYPE,

4931: (
4932: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
4933: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
4934: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4935: p_userid IN pon_interface_errors.created_by%TYPE,
4936: p_spreadsheet IN VARCHAR2,
4937: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
4938: p_batch_id IN pon_interface_errors.batch_id%TYPE,
4939: p_request_id IN pon_interface_errors.request_id%TYPE,

Line 4938: p_batch_id IN pon_interface_errors.batch_id%TYPE,

4934: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4935: p_userid IN pon_interface_errors.created_by%TYPE,
4936: p_spreadsheet IN VARCHAR2,
4937: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
4938: p_batch_id IN pon_interface_errors.batch_id%TYPE,
4939: p_request_id IN pon_interface_errors.request_id%TYPE,
4940: p_contract_type IN pon_bid_headers.contract_type%TYPE
4941: ) IS
4942:

Line 4939: p_request_id IN pon_interface_errors.request_id%TYPE,

4935: p_userid IN pon_interface_errors.created_by%TYPE,
4936: p_spreadsheet IN VARCHAR2,
4937: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
4938: p_batch_id IN pon_interface_errors.batch_id%TYPE,
4939: p_request_id IN pon_interface_errors.request_id%TYPE,
4940: p_contract_type IN pon_bid_headers.contract_type%TYPE
4941: ) IS
4942:
4943: BEGIN

Line 4966: INTO pon_interface_errors

4962: OR
4963: s_min_quantity = g_null_int
4964: )
4965: THEN
4966: INTO pon_interface_errors
4967: (INTERFACE_TYPE,
4968: TABLE_NAME,
4969: COLUMN_NAME,
4970: BATCH_ID,

Line 5030: INTO pon_interface_errors

5026: OR
5027: s_max_quantity = g_null_int
5028: )
5029: THEN
5030: INTO pon_interface_errors
5031: (INTERFACE_TYPE,
5032: TABLE_NAME,
5033: COLUMN_NAME,
5034: BATCH_ID,

Line 5094: INTO pon_interface_errors

5090: s_min_quantity <= 0 AND
5091: s_min_quantity <> g_null_int)
5092: )
5093: THEN
5094: INTO pon_interface_errors
5095: (INTERFACE_TYPE,
5096: TABLE_NAME,
5097: COLUMN_NAME,
5098: BATCH_ID,

Line 5158: INTO pon_interface_errors

5154: s_max_quantity <= 0 AND
5155: s_max_quantity <> g_null_int)
5156: )
5157: THEN
5158: INTO pon_interface_errors
5159: (INTERFACE_TYPE,
5160: TABLE_NAME,
5161: COLUMN_NAME,
5162: BATCH_ID,

Line 5221: INTO pon_interface_errors

5217: (
5218: s_min_quantity > s_max_quantity
5219: )
5220: THEN
5221: INTO pon_interface_errors
5222: (INTERFACE_TYPE,
5223: TABLE_NAME,
5224: COLUMN_NAME,
5225: BATCH_ID,

Line 5290: INTO pon_interface_errors

5286: )
5287: )
5288:
5289: THEN
5290: INTO pon_interface_errors
5291: (INTERFACE_TYPE,
5292: TABLE_NAME,
5293: COLUMN_NAME,
5294: BATCH_ID,

Line 5364: INTO pon_interface_errors

5360: )
5361: )
5362:
5363: THEN
5364: INTO pon_interface_errors
5365: (INTERFACE_TYPE,
5366: TABLE_NAME,
5367: COLUMN_NAME,
5368: BATCH_ID,

Line 5422: INTO pon_interface_errors

5418: WHEN (s_bid_currency_unit_price IS NULL
5419: OR
5420: s_bid_currency_unit_price = g_null_int) THEN
5421:
5422: INTO pon_interface_errors
5423: (INTERFACE_TYPE,
5424: TABLE_NAME,
5425: COLUMN_NAME,
5426: BATCH_ID,

Line 5484: INTO pon_interface_errors

5480: (s_bid_currency_unit_price IS NOT NULL AND
5481: s_bid_currency_unit_price <> g_null_int AND
5482: s_bid_currency_unit_price <= 0)
5483: THEN
5484: INTO pon_interface_errors
5485: (INTERFACE_TYPE,
5486: TABLE_NAME,
5487: COLUMN_NAME,
5488: BATCH_ID,

Line 5542: INTO pon_interface_errors

5538:
5539: -- bid_currency_unit_price precision must not exceed price precision
5540:
5541: WHEN validate_price_precision(s_bid_currency_unit_price, p_price_precision) = 'F' THEN
5542: INTO pon_interface_errors
5543: (INTERFACE_TYPE,
5544: TABLE_NAME,
5545: COLUMN_NAME,
5546: BATCH_ID,

Line 5607: INTO pon_interface_errors

5603: and s_max_ship_qty = s_max_quantity
5604: and s_max_ship_qty <> s_bid_quantity
5605: )
5606: THEN
5607: INTO pon_interface_errors
5608: (INTERFACE_TYPE,
5609: TABLE_NAME,
5610: COLUMN_NAME,
5611: BATCH_ID,

Line 5669: INTO pon_interface_errors

5665: WHEN (p_contract_type = 'STANDARD'
5666: and s_max_ship_qty = s_bid_quantity
5667: and s_max_ship_qty = s_max_quantity
5668: and s_bid_price <> s_shipments_price) THEN
5669: INTO pon_interface_errors
5670: (INTERFACE_TYPE,
5671: TABLE_NAME,
5672: COLUMN_NAME,
5673: BATCH_ID,

Line 5772: Insert INTO pon_interface_errors

5768: message => 'Performing overlapping tiers validation for online bidding flow.');
5769: END IF; --}
5770:
5771:
5772: Insert INTO pon_interface_errors
5773: (INTERFACE_TYPE,
5774: TABLE_NAME,
5775: BATCH_ID,
5776: INTERFACE_LINE_ID,

Line 5845: p_interface_type IN pon_interface_errors.interface_type%TYPE,

5841: PROCEDURE validate_price_differentials
5842: (
5843: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
5844: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
5845: p_interface_type IN pon_interface_errors.interface_type%TYPE,
5846: p_userid IN pon_interface_errors.created_by%TYPE,
5847: p_spreadsheet IN VARCHAR2,
5848: p_suffix IN VARCHAR2,
5849: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 5846: p_userid IN pon_interface_errors.created_by%TYPE,

5842: (
5843: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
5844: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
5845: p_interface_type IN pon_interface_errors.interface_type%TYPE,
5846: p_userid IN pon_interface_errors.created_by%TYPE,
5847: p_spreadsheet IN VARCHAR2,
5848: p_suffix IN VARCHAR2,
5849: p_batch_id IN pon_interface_errors.batch_id%TYPE,
5850: p_request_id IN pon_interface_errors.request_id%TYPE

Line 5849: p_batch_id IN pon_interface_errors.batch_id%TYPE,

5845: p_interface_type IN pon_interface_errors.interface_type%TYPE,
5846: p_userid IN pon_interface_errors.created_by%TYPE,
5847: p_spreadsheet IN VARCHAR2,
5848: p_suffix IN VARCHAR2,
5849: p_batch_id IN pon_interface_errors.batch_id%TYPE,
5850: p_request_id IN pon_interface_errors.request_id%TYPE
5851: ) IS
5852: BEGIN
5853:

Line 5850: p_request_id IN pon_interface_errors.request_id%TYPE

5846: p_userid IN pon_interface_errors.created_by%TYPE,
5847: p_spreadsheet IN VARCHAR2,
5848: p_suffix IN VARCHAR2,
5849: p_batch_id IN pon_interface_errors.batch_id%TYPE,
5850: p_request_id IN pon_interface_errors.request_id%TYPE
5851: ) IS
5852: BEGIN
5853:
5854: INSERT FIRST

Line 5860: INTO pon_interface_errors

5856: -- Line price differential validation:
5857: -- multiplier should be entered for REQUIRED price differentials
5858: WHEN s_shipment_number = -1 AND s_multiplier IS null
5859: AND s_differential_response_type = 'REQUIRED' THEN
5860: INTO pon_interface_errors
5861: (INTERFACE_TYPE,
5862: COLUMN_NAME,
5863: TABLE_NAME,
5864: BATCH_ID,

Line 5921: INTO pon_interface_errors

5917: -- Line price differential validation:
5918: -- multiplier should not be entered for DISPLAY_ONLY price differentials
5919: WHEN s_shipment_number = -1 AND s_multiplier IS NOT null
5920: AND s_differential_response_type = 'DISPLAY_ONLY' THEN
5921: INTO pon_interface_errors
5922: (INTERFACE_TYPE,
5923: COLUMN_NAME,
5924: TABLE_NAME,
5925: BATCH_ID,

Line 5983: INTO pon_interface_errors

5979:
5980: -- Line price differential validation:
5981: -- multiplier should be greater than the target multiplier
5982: WHEN s_shipment_number = -1 AND s_multiplier < s_target_multiplier THEN
5983: INTO pon_interface_errors
5984: (INTERFACE_TYPE,
5985: COLUMN_NAME,
5986: TABLE_NAME,
5987: BATCH_ID,

Line 6048: INTO pon_interface_errors

6044: -- multiplier should be entered for REQUIRED price differentials
6045: WHEN ( p_spreadsheet = g_online_mode or p_spreadsheet = g_xml_upload_mode )
6046: and s_shipment_number <> -1 AND s_multiplier IS null
6047: AND s_differential_response_type = 'REQUIRED' THEN
6048: INTO pon_interface_errors
6049: (INTERFACE_TYPE,
6050: COLUMN_NAME,
6051: TABLE_NAME,
6052: BATCH_ID,

Line 6112: INTO pon_interface_errors

6108: -- multiplier should not be entered for DISPLAY_ONLY price differentials
6109: WHEN ( p_spreadsheet = g_online_mode or p_spreadsheet = g_xml_upload_mode )
6110: and s_shipment_number <> -1 AND s_multiplier IS NOT null
6111: AND s_differential_response_type = 'DISPLAY_ONLY' THEN
6112: INTO pon_interface_errors
6113: (INTERFACE_TYPE,
6114: COLUMN_NAME,
6115: TABLE_NAME,
6116: BATCH_ID,

Line 6177: INTO pon_interface_errors

6173: -- multiplier should be greater than target multiplier
6174: WHEN ( p_spreadsheet = g_online_mode or p_spreadsheet = g_xml_upload_mode )
6175: and s_shipment_number <> -1
6176: AND s_multiplier < s_target_multiplier THEN
6177: INTO pon_interface_errors
6178: (INTERFACE_TYPE,
6179: COLUMN_NAME,
6180: TABLE_NAME,
6181: BATCH_ID,

Line 6290: p_interface_type IN pon_interface_errors.interface_type%TYPE,

6286: PROCEDURE validate_payments
6287: (
6288: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6289: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6290: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6291: p_userid IN pon_interface_errors.created_by%TYPE,
6292: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
6293: p_batch_id IN pon_interface_errors.batch_id%TYPE,
6294: p_request_id IN pon_interface_errors.request_id%TYPE

Line 6291: p_userid IN pon_interface_errors.created_by%TYPE,

6287: (
6288: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6289: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6290: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6291: p_userid IN pon_interface_errors.created_by%TYPE,
6292: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
6293: p_batch_id IN pon_interface_errors.batch_id%TYPE,
6294: p_request_id IN pon_interface_errors.request_id%TYPE
6295: ) IS

Line 6293: p_batch_id IN pon_interface_errors.batch_id%TYPE,

6289: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6290: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6291: p_userid IN pon_interface_errors.created_by%TYPE,
6292: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
6293: p_batch_id IN pon_interface_errors.batch_id%TYPE,
6294: p_request_id IN pon_interface_errors.request_id%TYPE
6295: ) IS
6296: l_loginid NUMBER;
6297: l_exp_date DATE;

Line 6294: p_request_id IN pon_interface_errors.request_id%TYPE

6290: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6291: p_userid IN pon_interface_errors.created_by%TYPE,
6292: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
6293: p_batch_id IN pon_interface_errors.batch_id%TYPE,
6294: p_request_id IN pon_interface_errors.request_id%TYPE
6295: ) IS
6296: l_loginid NUMBER;
6297: l_exp_date DATE;
6298: l_module CONSTANT VARCHAR2(32) := 'VALIDATE_PAYMENTS';

Line 6312: INSERT INTO pon_interface_errors

6308: */
6309:
6310: BEGIN
6311: --To check for duplicate pay item number
6312: INSERT INTO pon_interface_errors
6313: (INTERFACE_TYPE,
6314: COLUMN_NAME,
6315: TABLE_NAME,
6316: BATCH_ID,

Line 6374: INTO pon_interface_errors

6370:
6371:
6372: INSERT ALL
6373: WHEN payment_display_number < 1 OR payment_display_number<> ROUND(payment_display_number) THEN
6374: INTO pon_interface_errors
6375: (
6376: request_id, entity_attr_name, error_message_name, -- 1
6377: error_value_datatype, error_value_number, error_value_date, -- 2
6378: token1_name, token1_value, token2_name, -- 3

Line 6397: INTO pon_interface_errors

6393: l_exp_date, p_userid, SYSDATE, -- 7
6394: p_userid, SYSDATE, l_loginid -- 8
6395: )
6396: WHEN payment_type_code = 'RATE' AND quantity < 0 THEN
6397: INTO pon_interface_errors
6398: (
6399: request_id, entity_attr_name, error_message_name, -- 1
6400: error_value_datatype, error_value_number, error_value_date, -- 2
6401: token1_name, token1_value, token2_name, -- 3

Line 6420: INTO pon_interface_errors

6416: l_exp_date, p_userid, SYSDATE, -- 7
6417: p_userid, SYSDATE, l_loginid -- 8
6418: )
6419: WHEN bid_currency_price IS NOT NULL AND bid_currency_price < 0 THEN
6420: INTO pon_interface_errors
6421: (
6422: request_id, entity_attr_name, error_message_name, -- 1
6423: error_value_datatype, error_value_number, error_value_date, -- 2
6424: token1_name, token1_value, token2_name, -- 3

Line 6443: INTO pon_interface_errors

6439: l_exp_date, p_userid, SYSDATE, -- 7
6440: p_userid, SYSDATE, l_loginid -- 8
6441: )
6442: WHEN payment_display_number IS NULL THEN
6443: INTO pon_interface_errors
6444: (
6445: request_id, entity_attr_name, error_message_name, -- 1
6446: error_value_datatype, error_value, error_value_date, -- 2
6447: token1_name, token1_value, token2_name, -- 3

Line 6466: INTO pon_interface_errors

6462: l_exp_date, p_userid, SYSDATE, -- 7
6463: p_userid, SYSDATE, l_loginid -- 8
6464: )
6465: WHEN payment_type_code IS NULL THEN
6466: INTO pon_interface_errors
6467: (
6468: request_id, entity_attr_name, error_message_name, -- 1
6469: error_value_datatype, error_value_number, error_value, -- 2
6470: token1_name, token1_value, token2_name, -- 3

Line 6489: INTO pon_interface_errors

6485: l_exp_date, p_userid, SYSDATE, -- 7
6486: p_userid, SYSDATE, l_loginid -- 8
6487: )
6488: WHEN payment_description IS NULL THEN
6489: INTO pon_interface_errors
6490: (
6491: request_id, entity_attr_name, error_message_name, -- 1
6492: error_value_datatype, error_value_number, error_value, -- 2
6493: token1_name, token1_value, token2_name, -- 3

Line 6512: INTO pon_interface_errors

6508: l_exp_date, p_userid, SYSDATE, -- 7
6509: p_userid, SYSDATE, l_loginid -- 8
6510: )
6511: WHEN payment_type_code = 'RATE' AND quantity IS NULL THEN
6512: INTO pon_interface_errors
6513: (
6514: request_id, entity_attr_name, error_message_name, -- 1
6515: error_value_datatype, error_value, error_value_date, -- 2
6516: token1_name, token1_value, token2_name, -- 3

Line 6535: INTO pon_interface_errors

6531: l_exp_date, p_userid, SYSDATE, -- 7
6532: p_userid, SYSDATE, l_loginid -- 8
6533: )
6534: WHEN payment_type_code = 'RATE' AND uom_code IS NULL THEN
6535: INTO pon_interface_errors
6536: (
6537: request_id, entity_attr_name, error_message_name, -- 1
6538: error_value_datatype, error_value, error_value_date, -- 2
6539: token1_name, token1_value, token2_name, -- 3

Line 6558: INTO pon_interface_errors

6554: l_exp_date, p_userid, SYSDATE, -- 7
6555: p_userid, SYSDATE, l_loginid -- 8
6556: )
6557: WHEN bid_currency_price IS NULL THEN
6558: INTO pon_interface_errors
6559: (
6560: request_id, entity_attr_name, error_message_name, -- 1
6561: error_value_datatype, error_value, error_value_date, -- 2
6562: token1_name, token1_value, token2_name, -- 3

Line 6581: INTO pon_interface_errors

6577: l_exp_date, p_userid, SYSDATE, -- 7
6578: p_userid, SYSDATE, l_loginid -- 8
6579: )
6580: WHEN promised_date IS NOT NULL AND promised_date <= close_bidding_date THEN
6581: INTO pon_interface_errors
6582: (
6583: request_id, entity_attr_name, error_message_name, -- 1
6584: error_value_datatype, error_value_number, error_value_date, -- 2
6585: token1_name, token1_value, token2_name, -- 3

Line 6605: INTO pon_interface_errors

6601: p_userid, SYSDATE, l_loginid -- 8
6602: )
6603: WHEN bid_currency_price IS NOT NULL
6604: AND validate_price_precision(bid_currency_price, p_price_precision) = 'F' THEN
6605: INTO pon_interface_errors
6606: (
6607: request_id, entity_attr_name, error_message_name, -- 1
6608: error_value_datatype, error_value_number, error_value_date, -- 2
6609: token1_name, token1_value, token2_name, -- 3

Line 6671: p_interface_type IN pon_interface_errors.interface_type%TYPE,

6667: PROCEDURE perform_all_validations
6668: (
6669: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6670: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6671: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6672: p_userid IN pon_interface_errors.created_by%TYPE,
6673: p_batch_id IN pon_interface_errors.batch_id%TYPE,
6674: p_request_id IN pon_interface_errors.request_id%TYPE,
6675: p_spreadsheet IN VARCHAR2,

Line 6672: p_userid IN pon_interface_errors.created_by%TYPE,

6668: (
6669: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6670: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6671: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6672: p_userid IN pon_interface_errors.created_by%TYPE,
6673: p_batch_id IN pon_interface_errors.batch_id%TYPE,
6674: p_request_id IN pon_interface_errors.request_id%TYPE,
6675: p_spreadsheet IN VARCHAR2,
6676: x_return_status OUT NOCOPY NUMBER,

Line 6673: p_batch_id IN pon_interface_errors.batch_id%TYPE,

6669: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6670: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6671: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6672: p_userid IN pon_interface_errors.created_by%TYPE,
6673: p_batch_id IN pon_interface_errors.batch_id%TYPE,
6674: p_request_id IN pon_interface_errors.request_id%TYPE,
6675: p_spreadsheet IN VARCHAR2,
6676: x_return_status OUT NOCOPY NUMBER,
6677: x_return_code OUT NOCOPY VARCHAR2

Line 6674: p_request_id IN pon_interface_errors.request_id%TYPE,

6670: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6671: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6672: p_userid IN pon_interface_errors.created_by%TYPE,
6673: p_batch_id IN pon_interface_errors.batch_id%TYPE,
6674: p_request_id IN pon_interface_errors.request_id%TYPE,
6675: p_spreadsheet IN VARCHAR2,
6676: x_return_status OUT NOCOPY NUMBER,
6677: x_return_code OUT NOCOPY VARCHAR2
6678: ) IS

Line 6830: FROM pon_interface_errors

6826:
6827: -- Check if there were any errors
6828: SELECT decode(count(auction_header_id), 0, 'N', 'Y')
6829: INTO l_has_errors
6830: FROM pon_interface_errors
6831: WHERE (batch_id = p_batch_id OR request_id = p_request_id)
6832: AND rownum = 1;
6833:
6834: IF (l_has_errors = 'Y') THEN

Line 7036: FROM pon_interface_errors

7032:
7033: -- Check if any errors were present
7034: SELECT decode(count(auction_header_id), 0, 'N', 'Y')
7035: INTO l_has_errors
7036: FROM pon_interface_errors
7037: WHERE (batch_id = p_batch_id OR request_id = p_request_id)
7038: AND rownum = 1;
7039:
7040: IF (l_has_errors = 'Y') THEN

Line 7054: p_interface_type IN pon_interface_errors.interface_type%TYPE,

7050: PROCEDURE validate_bid
7051: (
7052: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7053: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7054: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7055: p_userid IN pon_interface_errors.created_by%TYPE,
7056: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7057: p_request_id IN pon_interface_errors.request_id%TYPE,
7058: x_return_status OUT NOCOPY NUMBER,

Line 7055: p_userid IN pon_interface_errors.created_by%TYPE,

7051: (
7052: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7053: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7054: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7055: p_userid IN pon_interface_errors.created_by%TYPE,
7056: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7057: p_request_id IN pon_interface_errors.request_id%TYPE,
7058: x_return_status OUT NOCOPY NUMBER,
7059: x_return_code OUT NOCOPY VARCHAR2

Line 7056: p_batch_id IN pon_interface_errors.batch_id%TYPE,

7052: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7053: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7054: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7055: p_userid IN pon_interface_errors.created_by%TYPE,
7056: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7057: p_request_id IN pon_interface_errors.request_id%TYPE,
7058: x_return_status OUT NOCOPY NUMBER,
7059: x_return_code OUT NOCOPY VARCHAR2
7060: ) IS

Line 7057: p_request_id IN pon_interface_errors.request_id%TYPE,

7053: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7054: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7055: p_userid IN pon_interface_errors.created_by%TYPE,
7056: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7057: p_request_id IN pon_interface_errors.request_id%TYPE,
7058: x_return_status OUT NOCOPY NUMBER,
7059: x_return_code OUT NOCOPY VARCHAR2
7060: ) IS
7061: BEGIN

Line 7072: p_interface_type IN pon_interface_errors.interface_type%TYPE,

7068: PROCEDURE validate_spreadsheet_upload
7069: (
7070: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7071: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7072: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7073: p_spreadsheet_type IN VARCHAR2,
7074: p_userid IN pon_interface_errors.created_by%TYPE,
7075: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7076: p_request_id IN pon_interface_errors.request_id%TYPE,

Line 7074: p_userid IN pon_interface_errors.created_by%TYPE,

7070: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7071: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7072: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7073: p_spreadsheet_type IN VARCHAR2,
7074: p_userid IN pon_interface_errors.created_by%TYPE,
7075: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7076: p_request_id IN pon_interface_errors.request_id%TYPE,
7077: x_return_status OUT NOCOPY NUMBER,
7078: x_return_code OUT NOCOPY VARCHAR2

Line 7075: p_batch_id IN pon_interface_errors.batch_id%TYPE,

7071: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7072: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7073: p_spreadsheet_type IN VARCHAR2,
7074: p_userid IN pon_interface_errors.created_by%TYPE,
7075: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7076: p_request_id IN pon_interface_errors.request_id%TYPE,
7077: x_return_status OUT NOCOPY NUMBER,
7078: x_return_code OUT NOCOPY VARCHAR2
7079: ) IS

Line 7076: p_request_id IN pon_interface_errors.request_id%TYPE,

7072: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7073: p_spreadsheet_type IN VARCHAR2,
7074: p_userid IN pon_interface_errors.created_by%TYPE,
7075: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7076: p_request_id IN pon_interface_errors.request_id%TYPE,
7077: x_return_status OUT NOCOPY NUMBER,
7078: x_return_code OUT NOCOPY VARCHAR2
7079: ) IS
7080: BEGIN