[Home] [Help]
34:
35: -- Check if any errors were present
36: SELECT decode(count(interface_type), 0, 'N', 'Y')
37: INTO l_has_errors
38: FROM pon_interface_errors
39: WHERE batch_id = p_batch_id
40: AND rownum = 1;
41:
42: IF (l_has_errors = 'Y') THEN
273: WHERE s_auction_header_id = bp.auction_header_id
274: AND s_auction_line_number = bp.line_number
275: AND s_bid_number = bp.bid_number)
276: THEN
277: INTO PON_INTERFACE_ERRORS
278: ( interface_type
279: , column_name
280: , error_message_name
281: , error_value
317: s_award_quantity > 0 OR
318: s_awardreject_reason is not null)
319: AND s_line_award_status = 'COMPLETED'
320: THEN
321: INTO PON_INTERFACE_ERRORS
322: ( interface_type
323: , column_name
324: , error_message_name
325: , table_name
359: s_award_quantity > 0 OR
360: s_awardreject_reason is not null)
361: AND s_shortlist_flag = 'N'
362: THEN
363: INTO PON_INTERFACE_ERRORS
364: ( interface_type
365: , column_name
366: , error_message_name
367: , error_value
403: s_award_quantity > 0 OR
404: s_awardreject_reason is not null)
405: AND s_bid_status <> 'ACTIVE'
406: THEN
407: INTO PON_INTERFACE_ERRORS
408: ( interface_type
409: , column_name
410: , error_message_name
411: , error_value
447: s_award_quantity > 0 OR
448: s_awardreject_reason is not null)
449: AND s_end_date_active is not null and s_end_date_active <= trunc(sysdate)
450: THEN
451: INTO PON_INTERFACE_ERRORS
452: ( interface_type
453: , column_name
454: , error_message_name
455: , error_value
489: -- Check if award quantity is > 0 when uploading an XML file
490: WHEN p_spreadsheet_type = PON_AWARD_PKG.g_xml_upload_mode
491: AND s_award_quantity < 0
492: THEN
493: INTO PON_INTERFACE_ERRORS
494: ( interface_type
495: , column_name
496: , error_message_name
497: , error_value_number
537: AND s_order_type_lookup_code = 'QUANTITY'
538: AND s_bid_line_award_status = 'Y'
539: AND s_award_quantity is null
540: THEN
541: INTO PON_INTERFACE_ERRORS
542: ( interface_type
543: , column_name
544: , error_message_name
545: , table_name
583: AND s_award_shipment_number = -1
584: AND p_spreadsheet_type = g_txt_upload_mode
585: AND nvl(s_award_quantity , 0) > 0
586: THEN
587: INTO PON_INTERFACE_ERRORS
588: ( interface_type
589: , column_name
590: , error_message_name
591: , table_name
656: AND bh.vendor_id = pv.vendor_id (+);
657:
658:
659: --
660: INSERT INTO PON_INTERFACE_ERRORS
661: ( interface_type
662: , column_name
663: , error_message_name
664: , error_value
757: line_type_id IS NOT NULL AND
758: NOT ((order_type_lookup_code = 'FIXED PRICE' AND purchase_basis = 'SERVICES') OR
759: (order_type_lookup_code = 'QUANTITY' AND purchase_basis = 'GOODS')))
760: OR po_outside_operation_flag = 'Y' THEN
761: INTO pon_interface_errors
762: (
763: interface_type, column_name, table_name, -- 1
764: error_value, error_message_name, batch_id, -- 2
765: interface_line_id, auction_header_id, line_number, -- 3
797: ELSIF p_contract_type = 'STANDARD' THEN
798:
799: INSERT ALL
800: WHEN retainage_rate_percent IS NOT NULL AND (retainage_rate_percent < 0 OR retainage_rate_percent > 100) THEN
801: INTO pon_interface_errors
802: (
803: interface_type, column_name, table_name, -- 1
804: error_value, error_message_name, batch_id, -- 2
805: interface_line_id, auction_header_id, line_number, -- 3
817: SYSDATE, l_loginid -- 6
818: )
819:
820: WHEN max_retainage_amount IS NOT NULL AND max_retainage_amount < 0 THEN
821: INTO pon_interface_errors
822: (
823: interface_type, column_name, table_name, -- 1
824: error_value, error_message_name, batch_id, -- 2
825: interface_line_id, auction_header_id, line_number, -- 3
837: SYSDATE, l_loginid -- 6
838: )
839:
840: WHEN advance_amount IS NOT NULL AND advance_amount < 0 THEN
841: INTO pon_interface_errors
842: (
843: interface_type, column_name, table_name, -- 1
844: error_value, error_message_name, batch_id, -- 2
845: interface_line_id, auction_header_id, line_number, -- 3
857: SYSDATE, l_loginid -- 6
858: )
859:
860: WHEN progress_pymt_rate_percent IS NOT NULL AND (progress_pymt_rate_percent < 0 OR progress_pymt_rate_percent > 100) then
861: INTO pon_interface_errors
862: (
863: interface_type, column_name, table_name, -- 1
864: error_value, error_message_name, batch_id, -- 2
865: interface_line_id, auction_header_id, line_number, -- 3
876: l_userid, SYSDATE, l_userid, -- 5
877: SYSDATE, l_loginid -- 6
878: )
879: WHEN recoupment_rate_percent IS NOT NULL AND (recoupment_rate_percent < 0 OR recoupment_rate_percent > 100) THEN
880: INTO pon_interface_errors
881: (
882: interface_type, column_name, table_name, -- 1
883: error_value, error_message_name, batch_id, -- 2
884: interface_line_id, auction_header_id, line_number, -- 3
896: SYSDATE, l_loginid -- 6
897: )
898:
899: WHEN p_progress_payment_type = 'FINANCE' AND progress_pymt_rate_percent IS NULL THEN
900: INTO pon_interface_errors
901: (
902: interface_type, column_name, table_name, -- 1
903: error_value, error_message_name, batch_id, -- 2
904: interface_line_id, auction_header_id, line_number, -- 3
919:
920: WHEN progress_pymt_rate_percent IS NOT NULL AND
921: recoupment_rate_percent IS NULL AND
922: p_recoupment_negotiable_flag = 'N' THEN
923: INTO pon_interface_errors
924: (
925: interface_type, column_name, table_name, -- 1
926: error_value, error_message_name, batch_id, -- 2
927: interface_line_id, auction_header_id, line_number, -- 3
940: )
941:
942: WHEN ((advance_amount IS NOT NULL OR p_advance_negotiable_flag = 'Y') AND
943: (recoupment_rate_percent IS NULL AND p_recoupment_negotiable_flag = 'N')) THEN
944: INTO pon_interface_errors
945: (
946: interface_type, column_name, table_name, -- 1
947: error_value, error_message_name, batch_id, -- 2
948: interface_line_id, auction_header_id, line_number, -- 3
961: )
962:
963: WHEN target_price IS NOT NULL AND advance_amount IS NOT NULL
964: AND (advance_amount > nvl(s_quantity,1) * target_price) THEN
965: INTO pon_interface_errors
966: (
967: interface_type, column_name, table_name, -- 1
968: error_value, error_message_name, batch_id, -- 2
969: interface_line_id, auction_header_id, line_number, -- 3
983:
984: WHEN p_progress_payment_type <> 'NONE' AND recoupment_rate_percent IS NOT NULL
985: AND advance_amount IS NOT NULL AND target_price IS NOT NULL
986: AND (recoupment_rate_percent < (advance_amount * 100)/(nvl(s_quantity,1) * target_price)) THEN
987: INTO pon_interface_errors
988: (
989: interface_type, column_name, table_name, -- 1
990: error_value, error_message_name, batch_id, -- 2
991: interface_line_id, auction_header_id, line_number, -- 3
1007: line_type_id IS NOT NULL AND
1008: NOT ((order_type_lookup_code = 'FIXED PRICE' AND purchase_basis = 'SERVICES') OR
1009: (order_type_lookup_code = 'QUANTITY' AND purchase_basis = 'GOODS')))
1010: OR po_outside_operation_flag = 'Y' THEN
1011: INTO pon_interface_errors
1012: (
1013: interface_type, column_name, table_name, -- 1
1014: error_value, error_message_name, batch_id, -- 2
1015: interface_line_id, auction_header_id, line_number, -- 3
1027: SYSDATE, l_loginid -- 6
1028: )
1029:
1030: WHEN line_origination_code <> 'REQUISITION' AND project_number IS NOT NULL AND pro_project_id IS NULL THEN
1031: INTO pon_interface_errors
1032: (
1033: interface_type, column_name, table_name, -- 1
1034: error_value, error_message_name, batch_id, -- 2
1035: interface_line_id, auction_header_id, line_number, -- 3
1052: AND project_task_number IS NOT NULL
1053: AND NOT EXISTS (SELECT 1
1054: FROM PA_TASKS_EXPEND_V task
1055: WHERE task.project_id = pro_project_id AND task.task_number = project_task_number) THEN
1056: INTO pon_interface_errors
1057: (
1058: interface_type, column_name, table_name, -- 1
1059: error_value, error_message_name, batch_id, -- 2
1060: interface_line_id, auction_header_id, line_number, -- 3
1082: WHERE award.project_id = pro_project_id
1083: AND task.task_number = project_task_number
1084: AND award.task_id = task.task_id
1085: AND task.project_id = pro_project_id) THEN
1086: INTO pon_interface_errors
1087: (
1088: interface_type, column_name, table_name, -- 1
1089: error_value, error_message_name, batch_id, -- 2
1090: interface_line_id, auction_header_id, line_number, -- 3
1103: )
1104:
1105: WHEN line_origination_code <> 'REQUISITION' AND project_exp_organization_name IS NOT NULL
1106: AND porg_proj_exp_organization_id IS NULL THEN
1107: INTO pon_interface_errors
1108: (
1109: interface_type, column_name, table_name, -- 1
1110: error_value, error_message_name, batch_id, -- 2
1111: interface_line_id, auction_header_id, line_number, -- 3
1131: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))
1132: AND trunc(sysdate) BETWEEN nvl(exptype.sys_link_start_date_active, trunc(sysdate))
1133: AND nvl(exptype.sys_link_end_date_Active, trunc(sysdate))) THEN
1134:
1135: INTO pon_interface_errors
1136: (
1137: interface_type, column_name, table_name, -- 1
1138: error_value, error_message_name, batch_id, -- 2
1139: interface_line_id, auction_header_id, line_number, -- 3
1153:
1154: WHEN pro_project_id IS NOT NULL
1155: AND project_award_number IS NULL
1156: AND PON_NEGOTIATION_PUBLISH_PVT.IS_PROJECT_SPONSORED(pro_project_id) = 'Y' THEN
1157: INTO pon_interface_errors
1158: (
1159: interface_type, column_name, table_name, -- 1
1160: error_value, error_message_name, batch_id, -- 2
1161: interface_line_id, auction_header_id, line_number, -- 3
1176: ((project_number IS NULL OR project_task_number IS NULL OR s_project_exp_type IS NULL
1177: OR project_exp_organization_name IS NULL OR project_expenditure_item_date IS NULL) AND
1178: (project_number IS NOT NULL OR project_task_number IS NOT NULL OR s_project_exp_type IS NOT NULL
1179: OR project_exp_organization_name IS NOT NULL OR project_expenditure_item_date IS NOT NULL)) THEN
1180: INTO pon_interface_errors
1181: (
1182: interface_type, column_name, table_name, -- 1
1183: error_value, error_message_name, batch_id, -- 2
1184: interface_line_id, auction_header_id, line_number, -- 3
1204: AND fu.employee_id = peo.person_id
1205: AND SYSDATE >= nvl(fu.start_date, SYSDATE)
1206: AND SYSDATE <= nvl(fu.end_date, SYSDATE) )
1207: THEN
1208: INTO pon_interface_errors
1209: (
1210: interface_type, column_name, table_name, -- 1
1211: error_value, error_message_name, batch_id, -- 2
1212: interface_line_id, auction_header_id, line_number, -- 3
1502: IF (is_valid_rule(p_doctype_Id, 'NO_PRICE_QUANTITY_ITEMS')) THEN
1503:
1504: IF (is_valid_rule(p_doctype_Id, 'QUANTITY')) THEN
1505: -- Quantity should be empty
1506: insert into PON_INTERFACE_ERRORS
1507: (interface_type,
1508: column_name,
1509: error_value,
1510: error_message_name,
1525: END IF;
1526:
1527: IF (is_valid_rule(p_doctype_Id, 'UNIT_OF_MEASURE')) THEN
1528: -- UOM should be empty
1529: insert into PON_INTERFACE_ERRORS
1530: (interface_type,
1531: column_name,
1532: error_value,
1533: error_message_name,
1548: END IF;
1549:
1550: IF (is_valid_rule(p_doctype_Id, 'TARGET_PRICE')) THEN
1551: -- Target Price should be empty
1552: insert into PON_INTERFACE_ERRORS
1553: (interface_type,
1554: column_name,
1555: error_value,
1556: error_message_name,
1571: END IF;
1572:
1573: IF (is_valid_rule(p_doctype_Id, 'CURRENT_PRICE')) THEN
1574: -- Current Price should be empty
1575: insert into PON_INTERFACE_ERRORS
1576: (interface_type,
1577: column_name,
1578: error_value,
1579: error_message_name,
1595:
1596: END IF;
1597:
1598: -- For Line Type Check.
1599: insert into PON_INTERFACE_ERRORS
1600: (interface_type,
1601: column_name,
1602: error_message_name,
1603: table_name,
1625: and line_type <> 'LINE_TYPE_NONE_ENTERED'
1626: and line_type is not null;
1627:
1628:
1629: insert into PON_INTERFACE_ERRORS
1630: (interface_type,
1631: column_name,
1632: error_value,
1633: error_message_name,
1648:
1649:
1650: -- perform the following check if po style has restricted line types
1651: if (l_line_type_restriction = 'SPECIFIED') then
1652: insert into PON_INTERFACE_ERRORS
1653: (interface_type,
1654: column_name,
1655: error_value,
1656: error_message_name,
1676: -- Bug 4722286.
1677: -- perform the following check if po style has restricted purchase basis
1678:
1679: if (l_line_type_restriction = 'ALL') then
1680: insert into PON_INTERFACE_ERRORS
1681: (interface_type,
1682: column_name,
1683: error_value,
1684: error_message_name,
1708: -- are on a standard outcome document
1709: --
1710: IF(p_contract_type = 'STANDARD') THEN
1711: --
1712: INSERT INTO pon_interface_errors
1713: (interface_type,
1714: column_name,
1715: error_value,
1716: error_message_name,
1731: END IF;
1732: --
1733: IF(p_contract_type = 'BLANKET' OR p_contract_type = 'CONTRACT') AND
1734: (p_global_flag = 'N') THEN
1735: INSERT INTO pon_interface_errors
1736: (interface_type,
1737: column_name,
1738: error_value,
1739: error_message_name,
1755: --
1756: -- Do not allow Outside Processing lines for Global Agreements
1757: --
1758: IF(p_contract_type = 'BLANKET' and p_global_flag = 'Y') THEN
1759: insert into pon_interface_errors
1760: (interface_type,
1761: column_name,
1762: error_value,
1763: error_message_name,
1778: END IF;
1779: --
1780: -- For Outside Processing lines, the Item is required
1781: --
1782: insert into pon_interface_errors
1783: (interface_type,
1784: column_name,
1785: error_value,
1786: error_message_name,
1801: AND outside_operation_flag = 'Y';
1802: --
1803: -- For temp labor lines, the job is required
1804: --
1805: INSERT INTO PON_INTERFACE_ERRORS
1806: (interface_type,
1807: column_name,
1808: error_value,
1809: error_message_name,
1859: job_id <> -1;
1860: --
1861: -- Validate the job
1862: --
1863: INSERT INTO PON_INTERFACE_ERRORS (
1864: interface_type,
1865: column_name,
1866: error_value,
1867: error_message_name,
1916: job_id <> -1;
1917: --
1918: -- Validate differential response type
1919: --
1920: insert into PON_INTERFACE_ERRORS
1921: (interface_type,
1922: column_name,
1923: error_value,
1924: error_message_name,
1957: -- ignore inventory item related fields for amount based lines
1958:
1959: l_item_number_delimiter := '.';
1960:
1961: insert into PON_INTERFACE_ERRORS
1962: (interface_type,
1963: column_name,
1964: error_value,
1965: error_message_name,
2083: (category_name = 'CAT_NONE_ENTERED' or category_name is null);
2084:
2085: -- validate description for inventory items where the modified flag is set to false
2086:
2087: insert into PON_INTERFACE_ERRORS
2088: (interface_type,
2089: column_name,
2090: error_value,
2091: error_message_name,
2114: msitl.language = p_language);
2115:
2116: -- validate revision for inventory items
2117:
2118: insert into PON_INTERFACE_ERRORS
2119: (interface_type,
2120: column_name,
2121: error_value,
2122: error_message_name,
2166: where batch_id = p_batch_id
2167: and ((UNIT_OF_MEASURE = 'UOM_NONE_ENTERED') or (UNIT_OF_MEASURE is null));
2168:
2169:
2170: INSERT INTO PON_INTERFACE_ERRORS
2171: ( interface_type
2172: , column_name
2173: , error_value
2174: , error_message_name
2189: and order_type_lookup_code = 'AMOUNT'
2190: and NOT((upper(UNIT_OF_MEASURE) = UPPER(l_amount_based_uom) ) or
2191: (upper(UNIT_OF_MEASURE) = UPPER(l_amount_based_unit_of_measure) )) ;
2192:
2193: INSERT INTO PON_INTERFACE_ERRORS
2194: ( interface_type
2195: , column_name
2196: , error_value
2197: , error_message_name
2215:
2216: -- END Line Type Check
2217:
2218: IF (is_valid_rule(p_doctype_Id, 'CATEGORY')) THEN
2219: insert into PON_INTERFACE_ERRORS
2220: (interface_type,
2221: column_name,
2222: error_message_name,
2223: table_name,
2311: where batch_id = p_batch_id
2312: and category_name <> 'CAT_NON_ENTERED'
2313: AND category_id <> -1;
2314:
2315: insert into PON_INTERFACE_ERRORS
2316: (interface_type,
2317: column_name,
2318: error_value,
2319: error_message_name,
2333: AND category_name <> 'CAT_NON_ENTERED';
2334:
2335: -- validate category name for inventory items
2336:
2337: insert into PON_INTERFACE_ERRORS
2338: (interface_type,
2339: column_name,
2340: error_value,
2341: error_message_name,
2387: (p1.ip_category_name is null or p1.ip_category_name = 'IP_CAT_NONE_ENTERED');
2388:
2389: -- iP category needs to be valid
2390:
2391: insert into PON_INTERFACE_ERRORS
2392: (interface_type,
2393: column_name,
2394: error_message_name,
2395: table_name,
2436:
2437: --
2438: -- Item description can't be null
2439: --
2440: insert into PON_INTERFACE_ERRORS
2441: (interface_type,
2442: column_name,
2443: error_message_name,
2444: table_name,
2465: -- Unit of Measure
2466: -- AUCTION and BID --
2467: --
2468: IF (is_valid_rule(p_doctype_Id, 'UNIT_OF_MEASURE')) THEN
2469: insert into PON_INTERFACE_ERRORS
2470: (interface_type,
2471: column_name,
2472: error_message_name,
2473: table_name,
2558: where batch_id = p_batch_id
2559: and unit_of_measure <> 'UOM_NONE_ENTERED'
2560: AND uom_code <> 'XXX';
2561:
2562: insert into PON_INTERFACE_ERRORS
2563: (interface_type,
2564: column_name,
2565: error_value,
2566: error_message_name,
2581: AND nvl(price_and_quantity_apply, 'Y') = 'Y';
2582:
2583: -- validate unit of measure for inventory items
2584:
2585: insert into PON_INTERFACE_ERRORS
2586: (interface_type,
2587: column_name,
2588: error_value,
2589: error_message_name,
2624: -- check quantity can't be null under certain conditions.
2625: --
2626: --
2627: if (p_contract_type = 'STANDARD' or p_contract_type is null) then
2628: insert into PON_INTERFACE_ERRORS
2629: (interface_type,
2630: column_name,
2631: error_message_name,
2632: table_name,
2649: end if;
2650:
2651: -- quantity cannot also be null if line is neither fixed-price based nor amount-based and it has a fixed amount price factor
2652: IF (p_contract_type IN ('BLANKET', 'CONTRACT')) THEN
2653: INSERT INTO pon_interface_errors
2654: (interface_type,
2655: column_name,
2656: error_value,
2657: error_message_name,
2696: -- Quantity > 0 --
2697: -- AUCTION and BID --
2698: --
2699: IF (is_valid_rule(p_doctype_Id, 'QUANTITY')) THEN
2700: insert into PON_INTERFACE_ERRORS
2701: (interface_type,
2702: column_name,
2703: error_value,
2704: error_message_name,
2725: -- AUCTION only --
2726: --
2727: IF (is_valid_rule(p_doctype_Id, 'NEED_BY_DATE')) THEN
2728: -- NEED_BY_FROM_DATE
2729: insert into PON_INTERFACE_ERRORS
2730: (interface_type,
2731: column_name,
2732: error_value,
2733: error_message_name,
2745: where need_by_start_date < sysdate
2746: and batch_id = p_batch_id;
2747: --
2748: -- NEED_BY_TO_DATE
2749: insert into PON_INTERFACE_ERRORS
2750: (interface_type,
2751: column_name,
2752: error_value,
2753: error_message_name,
2765: where need_by_date < sysdate
2766: and batch_id = p_batch_id;
2767: --
2768: -- NEED_BY_TO_DATE vs NEED_BY_FROM_DATE
2769: insert into PON_INTERFACE_ERRORS
2770: (interface_type,
2771: column_name,
2772: error_value,
2773: error_message_name,
2786: and batch_id = p_batch_id;
2787: --
2788: -- need by required for planned inventory items for SPO
2789: IF(p_contract_type = 'STANDARD') THEN
2790: insert into PON_INTERFACE_ERRORS
2791: (interface_type,
2792: column_name,
2793: error_value,
2794: error_message_name,
2825: --
2826: IF (is_valid_rule(p_doctype_Id, 'SHIP_TO_LOCATION') and (p_contract_type is null or p_contract_type = 'STANDARD')) THEN
2827:
2828: IF (is_required_rule(p_doctype_Id, 'SHIP_TO_LOCATION')) THEN
2829: insert into PON_INTERFACE_ERRORS
2830: ( interface_type
2831: , column_name
2832: , error_message_name
2833: , table_name
2874: AND ship_to_location_id <> -1;
2875: --
2876: --
2877:
2878: insert into PON_INTERFACE_ERRORS
2879: (interface_type,
2880: column_name,
2881: error_value,
2882: error_message_name,
2900: -- Target price NOT <=0 --
2901: -- AUCTION only --
2902: --
2903: IF (is_valid_rule(p_doctype_Id, 'TARGET_PRICE')) THEN
2904: insert into PON_INTERFACE_ERRORS
2905: (interface_type,
2906: column_name,
2907: error_value,
2908: error_message_name,
2925: -- Bid start price NOT <=0 --
2926: -- AUCTION only --
2927: --
2928: IF (is_valid_rule(p_doctype_Id, 'START_PRICE')) THEN
2929: insert into PON_INTERFACE_ERRORS
2930: (interface_type,
2931: column_name,
2932: error_value,
2933: error_message_name,
2949: -- Current price NOT <=0 --
2950: -- AUCTION/RFQs/Offers --
2951: --
2952: IF (is_valid_rule(p_doctype_Id, 'CURRENT_PRICE')) THEN
2953: insert into PON_INTERFACE_ERRORS
2954: (interface_type,
2955: column_name,
2956: error_value,
2957: error_message_name,
2974: -- reserve price NOT <=0 --
2975: -- AUCTION only --
2976: --
2977: IF (is_valid_rule(p_doctype_Id, 'RESERVE_PRICE')) THEN
2978: insert into PON_INTERFACE_ERRORS
2979: (interface_type,
2980: column_name,
2981: error_value,
2982: error_message_name,
3009: -- Buyer AUCTION only --
3010: --
3011:
3012: IF (is_valid_rule(p_doctype_Id, 'TARGET_PRICE') AND is_valid_rule(p_doctype_Id, 'START_PRICE')) THEN
3013: insert into PON_INTERFACE_ERRORS
3014: (interface_type,
3015: column_name,
3016: error_value,
3017: error_message_name,
3034: --
3035: -- Bid start price < TARGET PRICE --
3036: -- Seller AUCTION only --
3037: --
3038: insert into PON_INTERFACE_ERRORS
3039: (interface_type,
3040: column_name,
3041: error_value,
3042: error_message_name,
3056: --
3057: -- bid start price < reserve price
3058: -- Seller AUCTION only --
3059: --
3060: insert into PON_INTERFACE_ERRORS
3061: (interface_type,
3062: column_name,
3063: error_value,
3064: error_message_name,
3078: --
3079: -- reserve price < target price
3080: -- Seller AUCTION only --
3081: --
3082: insert into PON_INTERFACE_ERRORS
3083: (interface_type,
3084: column_name,
3085: error_value,
3086: error_message_name,
3103:
3104: -- unit target price NOT < 0
3105: -- AUCTION only
3106:
3107: insert into PON_INTERFACE_ERRORS
3108: (interface_type,
3109: column_name,
3110: error_value,
3111: error_message_name,