APPS.PO_LINES_SV7 dependencies on PO_INTERFACE_ERRORS_SV1

Line 52: po_interface_errors_sv1.handle_interface_errors(

48:
49: -- Bug 3362369 : ATO models are not purchasable
50: IF X_type_lookup_code = 'STANDARD' and
51: l_bom_item_type in (1,2) THEN
52: po_interface_errors_sv1.handle_interface_errors(
53: 'PO_DOCS_OPEN_INTERFACE',
54: 'FATAL',
55: null,
56: X_interface_header_id,

Line 69: po_interface_errors_sv1.handle_interface_errors(

65: X_header_processable_flag);
66: END IF;
67:
68: IF X_global_agreement_flag = 'Y' and X_outside_operation_flag = 'Y' THEN
69: po_interface_errors_sv1.handle_interface_errors(
70: 'PO_DOCS_OPEN_INTERFACE',
71: 'FATAL',
72: null,
73: X_interface_header_id,

Line 92: po_interface_errors_sv1.handle_interface_errors(

88:
89: IF (x_valid = FALSE) THEN
90: IF (X_outside_operation_flag = 'N') THEN
91: X_progress := '030';
92: po_interface_errors_sv1.handle_interface_errors(
93: 'PO_DOCS_OPEN_INTERFACE',
94: 'FATAL',
95: null,
96: X_interface_header_id,

Line 109: po_interface_errors_sv1.handle_interface_errors(

105: X_header_processable_flag);
106:
107: ELSIF (X_outside_operation_flag = 'Y') THEN
108: X_progress := '040';
109: po_interface_errors_sv1.handle_interface_errors(
110: 'PO_DOCS_OPEN_INTERFACE',
111: 'FATAL',
112: null,
113: X_interface_header_id,

Line 162: po_interface_errors_sv1.handle_interface_errors(

158: parameter is not set.
159: ***/
160:
161: X_progress := '110';
162: po_interface_errors_sv1.handle_interface_errors(
163: 'PO_DOCS_OPEN_INTERFACE',
164: 'FATAL',
165: null,
166: X_interface_header_id,

Line 186: po_interface_errors_sv1.handle_interface_errors(

182: X_unit_of_measure,
183: X_item_id,
184: X_def_inv_org_id);
185: IF (x_valid = FALSE) THEN
186: po_interface_errors_sv1.handle_interface_errors(
187: 'PO_DOCS_OPEN_INTERFACE',
188: 'FATAL',
189: null,
190: X_interface_header_id,

Line 214: po_interface_errors_sv1.handle_interface_errors(

210: X_item_revision,
211: X_item_id,
212: X_def_inv_org_id);
213: IF (x_valid = FALSE) THEN
214: po_interface_errors_sv1.handle_interface_errors(
215: 'PO_DOCS_OPEN_INTERFACE',
216: 'FATAL',
217: null,
218: X_interface_header_id,

Line 242: po_interface_errors_sv1.handle_interface_errors(

238: X_category_id,
239: X_item_id,
240: X_def_inv_org_id);
241: IF (x_valid = FALSE) THEN
242: po_interface_errors_sv1.handle_interface_errors(
243: 'PO_DOCS_OPEN_INTERFACE',
244: 'FATAL',
245: null,
246: X_interface_header_id,

Line 270: po_interface_errors_sv1.handle_interface_errors(

266: x_valid := po_unit_of_measures_sv1.val_unit_of_measure(
267: X_unit_of_measure,
268: NULL);
269: IF (x_valid = FALSE) THEN
270: po_interface_errors_sv1.handle_interface_errors(
271: 'PO_DOCS_OPEN_INTERFACE',
272: 'FATAL',
273: null,
274: X_interface_header_id,

Line 289: po_interface_errors_sv1.handle_interface_errors(

285: END IF;
286:
287: X_progress := '110';
288: IF (X_item_revision is not null) THEN
289: po_interface_errors_sv1.handle_interface_errors(
290: 'PO_DOCS_OPEN_INTERFACE',
291: 'FATAL',
292: null,
293: X_interface_header_id,

Line 312: po_interface_errors_sv1.handle_interface_errors(

308: IF (X_category_id is not null) THEN
309: x_valid := po_categories_sv1.val_category_id(X_category_id);
310:
311: IF (x_valid = FALSE) THEN
312: po_interface_errors_sv1.handle_interface_errors(
313: 'PO_DOCS_OPEN_INTERFACE',
314: 'FATAL',
315: null,
316: X_interface_header_id,

Line 384: po_interface_errors_sv1.handle_interface_errors(

380:
381: X_progress := '023';
382: IF (X_item_id IS NOT NULL) THEN
383: /** cannot specify item for amount based line type ***/
384: po_interface_errors_sv1.handle_interface_errors(
385: 'PO_DOCS_OPEN_INTERFACE',
386: 'FATAL',
387: null,
388: X_interface_header_id,

Line 405: po_interface_errors_sv1.handle_interface_errors(

401: END IF;
402:
403: X_progress := '025';
404: IF (X_unit_of_measure <> X_vs_unit_meas_lookup_code) THEN
405: po_interface_errors_sv1.handle_interface_errors(
406: 'PO_DOCS_OPEN_INTERFACE',
407: 'FATAL',
408: null,
409: X_interface_header_id,

Line 427: po_interface_errors_sv1.handle_interface_errors(

423: END IF;
424:
425: X_progress := '030';
426: IF (X_unit_price <> X_vs_unit_price) THEN
427: po_interface_errors_sv1.handle_interface_errors(
428: 'PO_DOCS_OPEN_INTERFACE',
429: 'FATAL',
430: null,
431: X_interface_header_id,

Line 457: po_interface_errors_sv1.handle_interface_errors(

453: */
454:
455: X_progress := '040';
456: IF (X_item_id is NULL) THEN
457: po_interface_errors_sv1.handle_interface_errors(
458: 'PO_DOCS_OPEN_INTERFACE',
459: 'FATAL',
460: null,
461: x_interface_header_id,

Line 477: po_interface_errors_sv1.handle_interface_errors(

473: /* For a global agreement OSP lines are not allowed */
474:
475: IF nvl(X_vs_outside_operation_flag,'N') = 'Y' AND
476: nvl(X_global_agreement_flag,'N') = 'Y' THEN
477: po_interface_errors_sv1.handle_interface_errors(
478: 'PO_DOCS_OPEN_INTERFACE',
479: 'FATAL',
480: null,
481: x_interface_header_id,

Line 688: po_interface_errors_sv1.handle_interface_errors(

684: /* since the relationship between po_header and po_line
685: is mater-detail relationship, so we need to make sure
686: that they have the same po_header_id */
687:
688: po_interface_errors_sv1.handle_interface_errors(
689: 'PO_DOCS_OPEN_INTERFACE',
690: 'FATAL',
691: null,
692: X_interface_header_id,

Line 716: po_interface_errors_sv1.handle_interface_errors(

712: x_valid :=po_headers_sv6.val_lookup_code(
713: x_over_tolerance_error_flag,
714: 'RECEIVING CONTROL LEVEL');
715: IF (x_valid = FALSE) THEN
716: po_interface_errors_sv1.handle_interface_errors(
717: 'PO_DOCS_OPEN_INTERFACE',
718: 'FATAL',
719: null,
720: x_interface_header_id,

Line 744: po_interface_errors_sv1.handle_interface_errors(

740: make a error mark in interface_errors_handle */
741:
742: x_progress := '017';
743: IF (x_closed_code is not null) THEN
744: po_interface_errors_sv1.handle_interface_errors(
745: 'PO_DOCS_OPEN_INTERFACE',
746: 'FATAL',
747: null,
748: x_interface_header_id,

Line 764: po_interface_errors_sv1.handle_interface_errors(

760: END IF;
761:
762:
763: IF (x_committed_amount is not null) THEN
764: po_interface_errors_sv1.handle_interface_errors(
765: 'PO_DOCS_OPEN_INTERFACE',
766: 'FATAL',
767: null,
768: x_interface_header_id,

Line 788: po_interface_errors_sv1.handle_interface_errors(

784: (x_create_or_update_item_flag <> 'Y')
785: /*** allow market price to have NOT NULL values because
786: Item Open Interface is to be called ***/
787: THEN
788: po_interface_errors_sv1.handle_interface_errors(
789: 'PO_DOCS_OPEN_INTERFACE',
790: 'FATAL',
791: null,
792: x_interface_header_id,

Line 808: po_interface_errors_sv1.handle_interface_errors(

804: END IF;
805:
806: x_progress := '030';
807: IF (x_allow_price_override_flag is not null) THEN
808: po_interface_errors_sv1.handle_interface_errors(
809: 'PO_DOCS_OPEN_INTERFACE',
810: 'FATAL',
811: null,
812: x_interface_header_id,

Line 828: po_interface_errors_sv1.handle_interface_errors(

824: END IF;
825:
826: x_progress := '040';
827: IF (x_not_to_exceed_price is not null) THEN
828: po_interface_errors_sv1.handle_interface_errors(
829: 'PO_DOCS_OPEN_INTERFACE',
830: 'FATAL',
831: null,
832: x_interface_header_id,

Line 848: po_interface_errors_sv1.handle_interface_errors(

844: END IF;
845:
846: x_progress := '050';
847: IF (x_negotiated_by_preparer_flag is not null) THEN
848: po_interface_errors_sv1.handle_interface_errors(
849: 'PO_DOCS_OPEN_INTERFACE',
850: 'FATAL',
851: null,
852: x_interface_header_id,

Line 868: po_interface_errors_sv1.handle_interface_errors(

864: END IF;
865:
866: x_progress := '060';
867: IF (x_capital_expense_flag is not null) THEN
868: po_interface_errors_sv1.handle_interface_errors(
869: 'PO_DOCS_OPEN_INTERFACE',
870: 'FATAL',
871: null,
872: x_interface_header_id,

Line 888: po_interface_errors_sv1.handle_interface_errors(

884: END IF;
885:
886: x_progress := '070';
887: IF (x_min_release_amount is not null) THEN
888: po_interface_errors_sv1.handle_interface_errors(
889: 'PO_DOCS_OPEN_INTERFACE',
890: 'FATAL',
891: null,
892: x_interface_header_id,

Line 909: po_interface_errors_sv1.handle_interface_errors(

905:
906: x_progress := '500';
907: IF (x_min_order_quantity < 0) AND (x_min_order_quantity is not null)
908: THEN
909: po_interface_errors_sv1.handle_interface_errors(
910: 'PO_DOCS_OPEN_INTERFACE',
911: 'FATAL',
912: null,
913: x_interface_header_id,

Line 930: po_interface_errors_sv1.handle_interface_errors(

926:
927: x_progress := '510';
928: IF (x_max_order_quantity < 0) AND (x_max_order_quantity is not null)
929: THEN
930: po_interface_errors_sv1.handle_interface_errors(
931: 'PO_DOCS_OPEN_INTERFACE',
932: 'FATAL',
933: null,
934: x_interface_header_id,

Line 954: po_interface_errors_sv1.handle_interface_errors(

950: (x_max_order_quantity is not null) THEN
951: x_valid := po_core_sv1.val_max_and_min_qty(x_min_order_quantity,
952: x_max_order_quantity);
953: IF (x_valid = FALSE) THEN
954: po_interface_errors_sv1.handle_interface_errors(
955: 'PO_DOCS_OPEN_INTERFACE',
956: 'FATAL',
957: null,
958: x_interface_header_id,

Line 981: po_interface_errors_sv1.handle_interface_errors(

977: x_over_tolerance_error_flag,
978: 'RECEIVING CONTROL LEVEL');
979: IF (x_valid = FALSE) THEN
980:
981: po_interface_errors_sv1.handle_interface_errors(
982: 'PO_DOCS_OPEN_INTERFACE',
983: 'FATAL',
984: null,
985: x_interface_header_id,

Line 1009: po_interface_errors_sv1.handle_interface_errors(

1005:
1006: IF (x_qty_rcv_tolerance is not null) AND
1007: (x_create_or_update_item_flag <> 'Y')
1008: THEN
1009: po_interface_errors_sv1.handle_interface_errors(
1010: 'PO_DOCS_OPEN_INTERFACE',
1011: 'FATAL',
1012: null,
1013: x_interface_header_id,

Line 1029: po_interface_errors_sv1.handle_interface_errors(

1025: END IF;
1026:
1027: x_progress := '090';
1028: IF (x_over_tolerance_error_flag is not null) THEN
1029: po_interface_errors_sv1.handle_interface_errors(
1030: 'PO_DOCS_OPEN_INTERFACE',
1031: 'FATAL',
1032: null,
1033: x_interface_header_id,

Line 1051: po_interface_errors_sv1.handle_interface_errors(

1047: x_progress := '100';
1048: IF (x_qty_rcv_exception_code is not null) AND
1049: (X_create_or_update_item_flag <> 'Y')
1050: THEN
1051: po_interface_errors_sv1.handle_interface_errors(
1052: 'PO_DOCS_OPEN_INTERFACE',
1053: 'FATAL',
1054: null,
1055: x_interface_header_id,

Line 1073: po_interface_errors_sv1.handle_interface_errors(

1069: -- Remove the check to see if lead time unit is NULL
1070: /*
1071: x_progress := '110';
1072: IF (x_lead_time_unit is not null) THEN
1073: po_interface_errors_sv1.handle_interface_errors(
1074: 'PO_DOCS_OPEN_INTERFACE',
1075: 'FATAL',
1076: null,
1077: x_interface_header_id,

Line 1093: po_interface_errors_sv1.handle_interface_errors(

1089: END IF;
1090: */
1091: x_progress := '120';
1092: IF (x_freight_carrier is not null) THEN
1093: po_interface_errors_sv1.handle_interface_errors(
1094: 'PO_DOCS_OPEN_INTERFACE',
1095: 'FATAL',
1096: null,
1097: x_interface_header_id,

Line 1113: po_interface_errors_sv1.handle_interface_errors(

1109: END IF;
1110:
1111: x_progress := '130';
1112: IF (x_fob is not null) THEN
1113: po_interface_errors_sv1.handle_interface_errors(
1114: 'PO_DOCS_OPEN_INTERFACE',
1115: 'FATAL',
1116: null,
1117: x_interface_header_id,

Line 1133: po_interface_errors_sv1.handle_interface_errors(

1129: END IF;
1130:
1131: x_progress := '140';
1132: IF (x_freight_terms is not null) THEN
1133: po_interface_errors_sv1.handle_interface_errors(
1134: 'PO_DOCS_OPEN_INTERFACE',
1135: 'FATAL',
1136: null,
1137: x_interface_header_id,

Line 1155: po_interface_errors_sv1.handle_interface_errors(

1151: X_progress := '150';
1152: IF (x_receipt_required_flag is not null) AND
1153: (x_create_or_update_item_flag <> 'Y' )
1154: THEN
1155: po_interface_errors_sv1.handle_interface_errors(
1156: 'PO_DOCS_OPEN_INTERFACE',
1157: 'FATAL',
1158: null,
1159: x_interface_header_id,

Line 1177: po_interface_errors_sv1.handle_interface_errors(

1173: X_progress := '155';
1174: IF (x_inspection_required_flag is not null) AND
1175: (x_create_or_update_item_flag <> 'Y')
1176: THEN
1177: po_interface_errors_sv1.handle_interface_errors(
1178: 'PO_DOCS_OPEN_INTERFACE',
1179: 'FATAL',
1180: null,
1181: x_interface_header_id,

Line 1197: po_interface_errors_sv1.handle_interface_errors(

1193: END IF;
1194:
1195: IF (x_min_release_amount < 0) AND (x_min_release_amount is not null)
1196: THEN
1197: po_interface_errors_sv1.handle_interface_errors(
1198: 'PO_DOCS_OPEN_INTERFACE',
1199: 'FATAL',
1200: null,
1201: x_interface_header_id,

Line 1218: po_interface_errors_sv1.handle_interface_errors(

1214:
1215: /* */
1216: X_progress := '156';
1217: if (p_shipment_num is not null) then
1218: po_interface_errors_sv1.handle_interface_errors(
1219: 'PO_DOCS_OPEN_INTERFACE',
1220: 'FATAL',
1221: null,
1222: x_interface_header_id,

Line 1266: po_interface_errors_sv1.handle_interface_errors(

1262:
1263: PO_DEBUG.put_line ('After calling validate_effective_dates()');
1264:
1265: if (l_errormsg is not null) then
1266: po_interface_errors_sv1.handle_interface_errors(
1267: 'PO_DOCS_OPEN_INTERFACE',
1268: 'FATAL',
1269: null,
1270: x_interface_header_id,

Line 1295: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1291: IF (p_order_type_lookup_code IN ('FIXED PRICE', 'RATE')) THEN
1292:
1293: IF (PO_SETUP_S1.get_services_enabled_flag = 'N') THEN
1294:
1295: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1296: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1297: X_Error_type => 'FATAL',
1298: X_Batch_id => NULL,
1299: X_Interface_Header_Id => x_interface_header_id,

Line 1326: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1322:
1323: IF (x_hd_type_lookup_code = 'BLANKET'
1324: AND NVL(x_global_agreement_flag, 'N') = 'N') THEN
1325: --New error: line type not supported for blanket
1326: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1327: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1328: X_Error_type => 'FATAL',
1329: X_Batch_id => NULL,
1330: X_Interface_Header_Id => x_interface_header_id,

Line 1380: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1376: END IF;
1377:
1378: l_valid_business_group_id := 'N';
1379:
1380: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1381: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1382: X_Error_type => 'FATAL',
1383: X_Batch_id => NULL,
1384: X_Interface_Header_Id => X_interface_header_id,

Line 1426: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1422: END IF;
1423:
1424: l_valid_business_group_id := 'N';
1425:
1426: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1427: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1428: X_Error_type => 'FATAL',
1429: X_Batch_id => NULL,
1430: X_Interface_Header_Id => X_interface_header_id,

Line 1462: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1458:
1459: --Job is mandatory for Temp Labor Lines.
1460: IF (p_job_id IS NULL) THEN
1461:
1462: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1463: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1464: X_Error_type => 'FATAL',
1465: X_Batch_id => NULL,
1466: X_Interface_Header_Id => x_interface_header_id,

Line 1544: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1540: PO_DEBUG.put_line('ERROR: job_id/business_group_id combination '||
1541: 'is invalid');
1542: END IF;
1543:
1544: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1545: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1546: X_Error_type => 'FATAL',
1547: X_Batch_id => NULL,
1548: X_Interface_Header_Id => X_interface_header_id,

Line 1590: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1586: AND NVL(TRUNC(PJ.date_from), TRUNC(sysdate)) <= TRUNC(sysdate)
1587: AND NVL(TRUNC(PJ.date_to), TRUNC(sysdate)) >= TRUNC(sysdate);
1588:
1589: IF (x_count < 1) THEN
1590: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1591: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1592: X_Error_type => 'FATAL',
1593: X_Batch_id => NULL,
1594: X_Interface_Header_Id => X_interface_header_id,

Line 1620: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1616:
1617: -- Bug 3308164 : capital expense flag is not applicable to
1618: -- temp labor lines
1619: IF (x_capital_expense_flag = 'Y') THEN
1620: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1621: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1622: X_Error_type => 'FATAL',
1623: X_Batch_id => NULL,
1624: X_Interface_Header_Id => x_interface_header_id,

Line 1648: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1644: /* Bug 3323281 Start */
1645: -- UN NUmber and Hazard Class not applicable for TEMP LABOR lines
1646:
1647: If (x_un_number_id is not NULL) then
1648: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1649: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1650: X_Error_type => 'FATAL',
1651: X_Batch_id => NULL,
1652: X_Interface_Header_Id => x_interface_header_id,

Line 1673: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1669: X_header_processable_flag => x_header_processable_flag);
1670: End if;
1671:
1672: If (x_hazard_class_id is not NULL) then
1673: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1674: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1675: X_Error_type => 'FATAL',
1676: X_Batch_id => NULL,
1677: X_Interface_Header_Id => x_interface_header_id,

Line 1704: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1700: --------------------------------------------------------------------
1701: -- Check: Do not allow Need-By Date if purchase basis is Temp Labor.
1702: --------------------------------------------------------------------
1703: IF (x_need_by_date IS NOT NULL) THEN
1704: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1705: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1706: X_Error_type => 'FATAL',
1707: X_Batch_id => NULL,
1708: X_Interface_Header_Id => x_interface_header_id,

Line 1732: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1728: --------------------------------------------------------------------
1729: -- Check: Do not allow Promised Date if purchase basis is Temp Labor.
1730: --------------------------------------------------------------------
1731: IF (x_promised_date IS NOT NULL) THEN
1732: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1733: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1734: X_Error_type => 'FATAL',
1735: X_Batch_id => NULL,
1736: X_Interface_Header_Id => x_interface_header_id,

Line 1763: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1759: --Effective date is required for Standard PO with purchase basis
1760: --'TEMP LABOR'
1761:
1762: IF (p_effective_date IS NULL) THEN
1763: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1764: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1765: X_Error_type => 'FATAL',
1766: X_Batch_id => NULL,
1767: X_Interface_Header_Id => X_interface_header_id,

Line 1790: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1786:
1787: -- Expiration date if provided should be later than the effective date
1788: IF ((p_expiration_date IS NOT NULL)
1789: AND (p_expiration_date < p_effective_date)) THEN
1790: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1791: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1792: X_Error_type => 'FATAL',
1793: X_Batch_id => NULL,
1794: X_Interface_Header_Id => X_interface_header_id,

Line 1820: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1816: ELSE --p_purchase_basis is not 'TEMP LABOR'
1817:
1818: -- For non TEMP LABOR Purchase basis, job should not be provided.
1819: IF (p_job_id IS NOT NULL) THEN
1820: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1821: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1822: X_Error_type => 'FATAL',
1823: X_Batch_id => NULL,
1824: X_Interface_Header_Id => X_interface_header_id,

Line 1847: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1843:
1844: IF (x_hd_type_lookup_code = 'STANDARD') THEN
1845: IF (p_effective_date IS NOT NULL
1846: OR p_expiration_date IS NOT NULL) THEN
1847: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1848: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1849: X_Error_type => 'FATAL',
1850: X_Batch_id => NULL,
1851: X_Interface_Header_Id => X_interface_header_id,

Line 1877: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1873: -- For non TEMP LABOR Purchase basis, contractor first name or
1874: -- contractor last name should not be provided.
1875: IF (p_contractor_first_name IS NOT NULL) OR
1876: (p_contractor_last_name IS NOT NULL) THEN
1877: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1878: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1879: X_Error_type => 'FATAL',
1880: X_Batch_id => NULL,
1881: X_Interface_Header_Id => X_interface_header_id,

Line 1908: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1904:
1905: IF (p_order_type_lookup_code IN ('FIXED PRICE', 'RATE')) THEN
1906:
1907: IF (x_item_id IS NOT NULL) THEN
1908: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1909: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1910: X_Error_type => 'FATAL',
1911: X_Batch_id => NULL,
1912: X_Interface_Header_Id => X_interface_header_id,

Line 1934: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1930:
1931: END IF;
1932:
1933: IF (X_item_revision is not null) THEN
1934: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1935: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1936: X_Error_type => 'FATAL',
1937: X_Batch_id => NULL,
1938: X_Interface_Header_Id => X_interface_header_id,

Line 1959: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1955: X_header_processable_flag => x_header_processable_flag);
1956: END IF;
1957:
1958: IF (x_quantity IS NOT NULL) THEN
1959: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1960: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1961: X_Error_type => 'FATAL',
1962: X_Batch_id => NULL,
1963: X_Interface_Header_Id => X_interface_header_id,

Line 1985: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

1981: END IF;
1982:
1983: IF ((p_amount IS NULL)
1984: AND (x_hd_type_lookup_code = 'STANDARD')) THEN
1985: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1986: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1987: X_Error_type => 'FATAL',
1988: X_Batch_id => NULL,
1989: X_Interface_Header_Id => X_interface_header_id,

Line 2019: PO_INTERFACE_ERRORS_SV1.handle_interface_errors

2015: IF ( p_purchase_basis = 'SERVICES' ) THEN -- Fixed Price/Services
2016:
2017: IF ( PO_SERVICES_PVT.get_ap_compatibility_flag = 'N' ) THEN
2018:
2019: PO_INTERFACE_ERRORS_SV1.handle_interface_errors
2020: ( X_interface_type => 'PO_DOCS_OPEN_INTERFACE'
2021: , X_Error_type => 'FATAL'
2022: , X_Batch_id => NULL
2023: , X_Interface_Header_Id => X_interface_header_id

Line 2049: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

2045: --
2046: --
2047:
2048: IF (x_unit_price IS NOT NULL) THEN
2049: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
2050: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
2051: X_Error_type => 'FATAL',
2052: X_Batch_id => NULL,
2053: X_Interface_Header_Id => X_interface_header_id,

Line 2075: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

2071: END IF;
2072:
2073: IF (x_unit_meas_lookup_code IS NOT NULL) THEN
2074:
2075: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
2076: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
2077: X_Error_type => 'FATAL',
2078: X_Batch_id => NULL,
2079: X_Interface_Header_Id => X_interface_header_id,

Line 2117: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

2113: l_rate_type := Null;
2114: End;
2115:
2116: if (l_rate_type = 'User') then
2117: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
2118: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
2119: X_Error_type => 'FATAL',
2120: X_Batch_id => NULL,
2121: X_Interface_Header_Id => X_interface_header_id,

Line 2145: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

2141: /* Bug 3307438 End */
2142:
2143: IF (x_hd_type_lookup_code = 'BLANKET') THEN
2144: IF (p_amount IS NOT NULL) THEN
2145: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
2146: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
2147: X_Error_type => 'FATAL',
2148: X_Batch_id => NULL,
2149: X_Interface_Header_Id => X_interface_header_id,

Line 2180: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

2176: AND unit_of_measure = x_unit_meas_lookup_code
2177: AND sysdate < NVL(disable_date, sysdate + 1);
2178:
2179: IF x_count < 1 THEN
2180: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
2181: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
2182: X_Error_type => 'FATAL',
2183: X_Batch_id => NULL,
2184: X_Interface_Header_Id => X_interface_header_id,

Line 2210: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

2206:
2207: ELSE --p_order_type_lookup_code NOT IN ('FIXED PRICE', 'RATE')
2208:
2209: IF (p_amount IS NOT NULL) THEN
2210: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
2211: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
2212: X_Error_type => 'FATAL',
2213: X_Batch_id => NULL,
2214: X_Interface_Header_Id => X_interface_header_id,

Line 2243: po_interface_errors_sv1.handle_interface_errors(

2239: --for all lookup types
2240: x_progress := '160';
2241: /* make sure that these fields are being populated */
2242: IF (x_line_num is null) THEN
2243: po_interface_errors_sv1.handle_interface_errors(
2244: 'PO_DOCS_OPEN_INTERFACE',
2245: 'FATAL',
2246: null,
2247: x_interface_header_id,

Line 2261: po_interface_errors_sv1.handle_interface_errors(

2257: END IF;
2258:
2259: X_progress := '163';
2260: IF (X_po_header_id IS NULL) THEN
2261: po_interface_errors_sv1.handle_interface_errors(
2262: 'PO_DOCS_OPEN_INTERFACE',
2263: 'FATAL',
2264: null,
2265: x_interface_header_id,

Line 2280: po_interface_errors_sv1.handle_interface_errors(

2276:
2277:
2278: X_progress := '165';
2279: IF (X_po_line_id IS NULL) THEN
2280: po_interface_errors_sv1.handle_interface_errors(
2281: 'PO_DOCS_OPEN_INTERFACE',
2282: 'FATAL',
2283: null,
2284: x_interface_header_id,

Line 2298: po_interface_errors_sv1.handle_interface_errors(

2294: END IF;
2295:
2296: x_progress := '170';
2297: IF (x_line_type_id is null) THEN
2298: po_interface_errors_sv1.handle_interface_errors(
2299: 'PO_DOCS_OPEN_INTERFACE',
2300: 'FATAL',
2301: null,
2302: x_interface_header_id,

Line 2316: po_interface_errors_sv1.handle_interface_errors(

2312: END IF;
2313:
2314: x_progress := '180';
2315: IF (x_category_id is null) THEN
2316: po_interface_errors_sv1.handle_interface_errors(
2317: 'PO_DOCS_OPEN_INTERFACE',
2318: 'FATAL',
2319: null,
2320: x_interface_header_id,

Line 2334: po_interface_errors_sv1.handle_interface_errors(

2330: END IF;
2331:
2332: x_progress := '190';
2333: IF (x_item_description is null) THEN
2334: po_interface_errors_sv1.handle_interface_errors(
2335: 'PO_DOCS_OPEN_INTERFACE',
2336: 'FATAL',
2337: null,
2338: x_interface_header_id,

Line 2353: po_interface_errors_sv1.handle_interface_errors(

2349:
2350: x_progress := '195';
2351: IF ((x_unit_meas_lookup_code IS NULL)
2352: AND (p_order_type_lookup_code <> 'FIXED PRICE')) THEN --
2353: po_interface_errors_sv1.handle_interface_errors(
2354: 'PO_DOCS_OPEN_INTERFACE',
2355: 'FATAL',
2356: null,
2357: x_interface_header_id,

Line 2372: po_interface_errors_sv1.handle_interface_errors(

2368:
2369: x_progress := '200';
2370: IF ((x_unit_price IS NULL)
2371: AND (p_order_type_lookup_code <> 'FIXED PRICE')) THEN --
2372: po_interface_errors_sv1.handle_interface_errors(
2373: 'PO_DOCS_OPEN_INTERFACE',
2374: 'FATAL',
2375: null,
2376: x_interface_header_id,

Line 2391: po_interface_errors_sv1.handle_interface_errors(

2387: --bug 1341322
2388: x_progress := '205';
2389: IF ((x_unit_price < 0)
2390: AND (p_order_type_lookup_code <> 'FIXED PRICE')) THEN --
2391: po_interface_errors_sv1.handle_interface_errors(
2392: 'PO_DOCS_OPEN_INTERFACE',
2393: 'FATAL',
2394: null,
2395: x_interface_header_id,

Line 2408: po_interface_errors_sv1.handle_interface_errors(

2404: x_header_processable_flag);
2405: END IF;
2406: x_progress := '210';
2407: IF (x_release_num is not null) THEN
2408: po_interface_errors_sv1.handle_interface_errors(
2409: 'PO_DOCS_OPEN_INTERFACE',
2410: 'FATAL',
2411: null,
2412: x_interface_header_id,

Line 2428: po_interface_errors_sv1.handle_interface_errors(

2424: END IF;
2425:
2426: x_progress := '220';
2427: IF (x_po_release_id is not null) THEN
2428: po_interface_errors_sv1.handle_interface_errors(
2429: 'PO_DOCS_OPEN_INTERFACE',
2430: 'FATAL',
2431: null,
2432: x_interface_header_id,

Line 2448: po_interface_errors_sv1.handle_interface_errors(

2444: END IF;
2445:
2446: x_progress := '230';
2447: IF (x_source_shipment_id is not null) THEN
2448: po_interface_errors_sv1.handle_interface_errors(
2449: 'PO_DOCS_OPEN_INTERFACE',
2450: 'FATAL',
2451: null,
2452: x_interface_header_id,

Line 2468: po_interface_errors_sv1.handle_interface_errors(

2464: END IF;
2465:
2466: x_progress := '240';
2467: IF (x_contract_num is not null) THEN
2468: po_interface_errors_sv1.handle_interface_errors(
2469: 'PO_DOCS_OPEN_INTERFACE',
2470: 'FATAL',
2471: null,
2472: x_interface_header_id,

Line 2491: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

2487: -- PDOI does not support importing contract reference info
2488:
2489: x_progress := '245';
2490: IF (p_contract_id IS NOT NULL) THEN
2491: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
2492: 'PO_DOCS_OPEN_INTERFACE',
2493: 'FATAL',
2494: null,
2495: x_interface_header_id,

Line 2513: po_interface_errors_sv1.handle_interface_errors(

2509: --
2510:
2511: x_progress := '250';
2512: IF (x_type_1099 is not null) THEN
2513: po_interface_errors_sv1.handle_interface_errors(
2514: 'PO_DOCS_OPEN_INTERFACE',
2515: 'FATAL',
2516: null,
2517: x_interface_header_id,

Line 2538: po_interface_errors_sv1.handle_interface_errors(

2534:
2535: IF (x_receipt_days_exception_code is not null) AND
2536: (x_create_or_update_item_flag <> 'Y')
2537: THEN
2538: po_interface_errors_sv1.handle_interface_errors(
2539: 'PO_DOCS_OPEN_INTERFACE',
2540: 'FATAL',
2541: null,
2542: x_interface_header_id,

Line 2559: po_interface_errors_sv1.handle_interface_errors(

2555:
2556: x_progress := '280';
2557: IF (x_need_by_date is not null) THEN -- Bug 3320741
2558:
2559: po_interface_errors_sv1.handle_interface_errors(
2560: 'PO_DOCS_OPEN_INTERFACE',
2561: 'FATAL',
2562: null,
2563: x_interface_header_id,

Line 2580: po_interface_errors_sv1.handle_interface_errors(

2576:
2577: x_progress := '290';
2578: IF (x_promised_date is not null) THEN -- Bug 3320741
2579:
2580: po_interface_errors_sv1.handle_interface_errors(
2581: 'PO_DOCS_OPEN_INTERFACE',
2582: 'FATAL',
2583: null,
2584: x_interface_header_id,

Line 2602: po_interface_errors_sv1.handle_interface_errors(

2598: x_progress := '360';
2599: IF (x_invoice_close_tolerance is not null) AND
2600: (x_create_or_update_item_flag <> 'Y')
2601: THEN
2602: po_interface_errors_sv1.handle_interface_errors(
2603: 'PO_DOCS_OPEN_INTERFACE',
2604: 'FATAL',
2605: null,
2606: x_interface_header_id,

Line 2624: po_interface_errors_sv1.handle_interface_errors(

2620: x_progress := '370';
2621: IF (x_receive_close_tolerance is not null) AND
2622: (x_create_or_update_item_flag <> 'Y')
2623: THEN
2624: po_interface_errors_sv1.handle_interface_errors(
2625: 'PO_DOCS_OPEN_INTERFACE',
2626: 'FATAL',
2627: null,
2628: x_interface_header_id,

Line 2646: po_interface_errors_sv1.handle_interface_errors(

2642: x_progress := '390';
2643: IF (x_days_early_receipt_allowed is not null) AND
2644: (x_create_or_update_item_flag <> 'Y')
2645: THEN
2646: po_interface_errors_sv1.handle_interface_errors(
2647: 'PO_DOCS_OPEN_INTERFACE',
2648: 'FATAL',
2649: null,
2650: x_interface_header_id,

Line 2668: po_interface_errors_sv1.handle_interface_errors(

2664: x_progress := '400';
2665: IF (x_days_late_receipt_allowed is not null) AND
2666: (x_create_or_update_item_flag <> 'Y')
2667: THEN
2668: po_interface_errors_sv1.handle_interface_errors(
2669: 'PO_DOCS_OPEN_INTERFACE',
2670: 'FATAL',
2671: null,
2672: x_interface_header_id,

Line 2690: po_interface_errors_sv1.handle_interface_errors(

2686: x_progress := '410';
2687: IF (x_enforce_ship_to_loc_code is not null) AND
2688: (x_create_or_update_item_flag <> 'Y')
2689: THEN
2690: po_interface_errors_sv1.handle_interface_errors(
2691: 'PO_DOCS_OPEN_INTERFACE',
2692: 'FATAL',
2693: null,
2694: x_interface_header_id,

Line 2712: po_interface_errors_sv1.handle_interface_errors(

2708: x_progress := '420';
2709: IF (x_allow_sub_receipts_flag is not null) AND
2710: (x_create_or_update_item_flag <> 'Y')
2711: THEN
2712: po_interface_errors_sv1.handle_interface_errors(
2713: 'PO_DOCS_OPEN_INTERFACE',
2714: 'FATAL',
2715: null,
2716: x_interface_header_id,

Line 2734: po_interface_errors_sv1.handle_interface_errors(

2730: x_progress := '430';
2731: IF (x_receiving_routing is not null) AND
2732: (x_create_or_update_item_flag <> 'Y')
2733: THEN
2734: po_interface_errors_sv1.handle_interface_errors(
2735: 'PO_DOCS_OPEN_INTERFACE',
2736: 'FATAL',
2737: null,
2738: x_interface_header_id,

Line 2758: po_interface_errors_sv1.handle_interface_errors(

2754: -- Remove the check to see if lead time is NULL
2755: /*
2756: x_progress := '300';
2757: IF (x_lead_time is not null) THEN
2758: po_interface_errors_sv1.handle_interface_errors(
2759: 'PO_DOCS_OPEN_INTERFACE',
2760: 'FATAL',
2761: null,
2762: x_interface_header_id,

Line 2780: po_interface_errors_sv1.handle_interface_errors(

2776: x_progress := '310';
2777:
2778: x_progress := '330';
2779: IF (x_closed_reason is not null) THEN
2780: po_interface_errors_sv1.handle_interface_errors(
2781: 'PO_DOCS_OPEN_INTERFACE',
2782: 'FATAL',
2783: null,
2784: x_interface_header_id,

Line 2800: po_interface_errors_sv1.handle_interface_errors(

2796: END IF;
2797:
2798: x_progress := '340';
2799: IF (x_closed_date is not null) THEN
2800: po_interface_errors_sv1.handle_interface_errors(
2801: 'PO_DOCS_OPEN_INTERFACE',
2802: 'FATAL',
2803: null,
2804: x_interface_header_id,

Line 2820: po_interface_errors_sv1.handle_interface_errors(

2816: END IF;
2817:
2818: x_progress := '350';
2819: IF (x_closed_by is not null) THEN
2820: po_interface_errors_sv1.handle_interface_errors(
2821: 'PO_DOCS_OPEN_INTERFACE',
2822: 'FATAL',
2823: null,
2824: x_interface_header_id,

Line 2841: po_interface_errors_sv1.handle_interface_errors(

2837:
2838:
2839: x_progress := '380';
2840: IF (x_firm_flag is not null) THEN
2841: po_interface_errors_sv1.handle_interface_errors(
2842: 'PO_DOCS_OPEN_INTERFACE',
2843: 'FATAL',
2844: null,
2845: x_interface_header_id,

Line 2883: po_interface_errors_sv1.handle_interface_errors(

2879:
2880: x_progress := '450';
2881: IF ((x_quantity < 0) AND (x_quantity is not null)
2882: AND (p_order_type_lookup_code NOT IN ('RATE', 'FIXED PRICE'))) THEN --
2883: po_interface_errors_sv1.handle_interface_errors(
2884: 'PO_DOCS_OPEN_INTERFACE',
2885: 'FATAL',
2886: null,
2887: x_interface_header_id,

Line 2908: po_interface_errors_sv1.handle_interface_errors(

2904: x_valid := po_lines_sv1.val_line_num_uniqueness(x_line_num,
2905: null,
2906: x_po_header_id);
2907: IF (x_valid = FALSE) THEN
2908: po_interface_errors_sv1.handle_interface_errors(
2909: 'PO_DOCS_OPEN_INTERFACE',
2910: 'FATAL',
2911: null,
2912: x_interface_header_id,

Line 2926: po_interface_errors_sv1.handle_interface_errors(

2922: END IF;
2923:
2924: x_progress := '470';
2925: IF (x_line_num <= 0) THEN
2926: po_interface_errors_sv1.handle_interface_errors(
2927: 'PO_DOCS_OPEN_INTERFACE',
2928: 'FATAL',
2929: null,
2930: x_interface_header_id,

Line 2951: po_interface_errors_sv1.handle_interface_errors(

2947: x_valid := po_lines_sv1.val_line_id_uniqueness(x_po_line_id,
2948: null,
2949: x_po_header_id);
2950: IF (x_valid = FALSE) THEN
2951: po_interface_errors_sv1.handle_interface_errors(
2952: 'PO_DOCS_OPEN_INTERFACE',
2953: 'FATAL',
2954: null,
2955: x_interface_header_id,

Line 2972: po_interface_errors_sv1.handle_interface_errors(

2968: x_progress := '490';
2969: IF (x_line_type_id is not null) THEN
2970: x_valid := po_line_types_sv1.val_line_type_id(x_line_type_id);
2971: IF (x_valid = FALSE) THEN
2972: po_interface_errors_sv1.handle_interface_errors(
2973: 'PO_DOCS_OPEN_INTERFACE',
2974: 'FATAL',
2975: null,
2976: x_interface_header_id,

Line 2993: po_interface_errors_sv1.handle_interface_errors(

2989: --frkhan add standard
2990: IF (x_hd_type_lookup_code in ('BLANKET','STANDARD')) THEN
2991: x_progress := '550';
2992: IF (x_committed_amount < 0) AND (x_committed_amount is not null) THEN
2993: po_interface_errors_sv1.handle_interface_errors(
2994: 'PO_DOCS_OPEN_INTERFACE',
2995: 'FATAL',
2996: null,
2997: x_interface_header_id,

Line 3013: po_interface_errors_sv1.handle_interface_errors(

3009: END IF;
3010:
3011: x_progress := '560';
3012: IF (x_market_price < 0) AND (x_market_price is not null) THEN
3013: po_interface_errors_sv1.handle_interface_errors(
3014: 'PO_DOCS_OPEN_INTERFACE',
3015: 'FATAL',
3016: null,
3017: x_interface_header_id,

Line 3036: po_interface_errors_sv1.handle_interface_errors(

3032: IF (x_negotiated_by_preparer_flag is not null) THEN
3033: x_valid := po_core_sv1.val_flag_value(
3034: x_negotiated_by_preparer_flag);
3035: IF (x_valid = FALSE) THEN
3036: po_interface_errors_sv1.handle_interface_errors(
3037: 'PO_DOCS_OPEN_INTERFACE',
3038: 'FATAL',
3039: null,
3040: x_interface_header_id,

Line 3059: po_interface_errors_sv1.handle_interface_errors(

3055: x_progress := '580';
3056: IF (x_capital_expense_flag is not null) THEN
3057: x_valid := po_core_sv1.val_flag_value(x_capital_expense_flag);
3058: IF (x_valid = FALSE) THEN
3059: po_interface_errors_sv1.handle_interface_errors(
3060: 'PO_DOCS_OPEN_INTERFACE',
3061: 'FATAL',
3062: null,
3063: x_interface_header_id,

Line 3081: po_interface_errors_sv1.handle_interface_errors(

3077:
3078: X_progress := '600';
3079: IF (x_allow_price_override_flag = 'N') THEN
3080: IF (x_not_to_exceed_price IS NOT NULL) THEN
3081: po_interface_errors_sv1.handle_interface_errors(
3082: 'PO_DOCS_OPEN_INTERFACE',
3083: 'FATAL',
3084: null,
3085: x_interface_header_id,

Line 3101: po_interface_errors_sv1.handle_interface_errors(

3097:
3098: X_progress := '610';
3099: IF (x_not_to_exceed_price IS NOT NULL) THEN
3100: IF (x_not_to_exceed_price < x_unit_price) THEN
3101: po_interface_errors_sv1.handle_interface_errors(
3102: 'PO_DOCS_OPEN_INTERFACE',
3103: 'FATAL',
3104: null,
3105: x_interface_header_id,

Line 3124: po_interface_errors_sv1.handle_interface_errors(

3120: --FRKHAN
3121: IF (x_hd_type_lookup_code = 'STANDARD') THEN
3122: x_progress := '620';
3123: IF (x_quantity = 0) AND (x_quantity is not null) THEN
3124: po_interface_errors_sv1.handle_interface_errors(
3125: 'PO_DOCS_OPEN_INTERFACE',
3126: 'FATAL',
3127: null,
3128: x_interface_header_id,

Line 3145: po_interface_errors_sv1.handle_interface_errors(

3141:
3142: /*
3143: x_progress := '630';
3144: IF (x_need_by_date < trunc(sysdate)) AND (x_need_by_date is not null) THEN
3145: po_interface_errors_sv1.handle_interface_errors(
3146: 'PO_DOCS_OPEN_INTERFACE',
3147: 'FATAL',
3148: null,
3149: x_interface_header_id,

Line 3163: po_interface_errors_sv1.handle_interface_errors(

3159: END IF;
3160:
3161: x_progress := '630';
3162: IF (x_promised_date < trunc(sysdate)) AND (x_promised_date is not null) THEN
3163: po_interface_errors_sv1.handle_interface_errors(
3164: 'PO_DOCS_OPEN_INTERFACE',
3165: 'FATAL',
3166: null,
3167: x_interface_header_id,

Line 3190: po_interface_errors_sv1.handle_interface_errors(

3186:
3187: if (NVL(x_taxable_flag, 'NULL') = 'N' and x_tax_name is not null and
3188: x_tax_code_id is not null) then
3189:
3190: po_interface_errors_sv1.handle_interface_errors(
3191: 'PO_DOCS_OPEN_INTERFACE',
3192: 'FATAL',
3193: null,
3194: x_interface_header_id,

Line 3213: po_interface_errors_sv1.handle_interface_errors(

3209:
3210: if (x_tax_name is not null and x_tax_code_id is null) then
3211:
3212: -- something went wrong
3213: po_interface_errors_sv1.handle_interface_errors(
3214: 'PO_DOCS_OPEN_INTERFACE',
3215: 'FATAL',
3216: null,
3217: x_interface_header_id,

Line 3231: po_interface_errors_sv1.handle_interface_errors(

3227:
3228: elsif (x_tax_name is null and x_tax_code_id is not null) then
3229:
3230: -- something went wrong
3231: po_interface_errors_sv1.handle_interface_errors(
3232: 'PO_DOCS_OPEN_INTERFACE',
3233: 'FATAL',
3234: null,
3235: x_interface_header_id,

Line 3259: po_interface_errors_sv1.handle_interface_errors(

3255: if x_count = 0 then
3256:
3257: -- invalid tax id
3258:
3259: po_interface_errors_sv1.handle_interface_errors(
3260: 'PO_DOCS_OPEN_INTERFACE',
3261: 'FATAL',
3262: null,
3263: x_interface_header_id,

Line 3282: po_interface_errors_sv1.handle_interface_errors(

3278: X_progress := '620';
3279: IF (x_terms_id is not null) THEN
3280: po_terms_sv.val_ap_terms(x_terms_id, x_res_terms_id);
3281: IF (x_res_terms_id is null) THEN
3282: po_interface_errors_sv1.handle_interface_errors(
3283: 'PO_DOCS_OPEN_INTERFACE',
3284: 'FATAL',
3285: null,
3286: x_interface_header_id,

Line 3303: po_interface_errors_sv1.handle_interface_errors(

3299: x_progress := '630';
3300: IF (x_un_number_id is not null) THEN
3301: x_valid := po_un_numbers_sv1.val_un_number_id(x_un_number_id);
3302: IF (x_valid = FALSE) THEN
3303: po_interface_errors_sv1.handle_interface_errors(
3304: 'PO_DOCS_OPEN_INTERFACE',
3305: 'FATAL',
3306: null,
3307: x_interface_header_id,

Line 3325: po_interface_errors_sv1.handle_interface_errors(

3321: IF (x_hazard_class_id is not null) THEN
3322: x_valid := po_hazard_classes_sv1.val_hazard_class_id(
3323: x_hazard_class_id);
3324: IF (x_valid = FALSE) THEN
3325: po_interface_errors_sv1.handle_interface_errors(
3326: 'PO_DOCS_OPEN_INTERFACE',
3327: 'FATAL',
3328: null,
3329: x_interface_header_id,

Line 3348: po_interface_errors_sv1.handle_interface_errors(

3344: /*
3345: IF (x_taxable_flag is not null) THEN
3346: x_valid := po_core_sv1.val_flag_value(x_taxable_flag);
3347: IF (x_valid = FALSE) THEN
3348: po_interface_errors_sv1.handle_interface_errors(
3349: 'PO_DOCS_OPEN_INTERFACE',
3350: 'FATAL',
3351: null,
3352: x_interface_header_id,

Line 3372: po_interface_errors_sv1.handle_interface_errors(

3368: IF (x_price_type_lookup_code is not null) THEN
3369: x_valid :=po_headers_sv6.val_lookup_code(x_price_type_lookup_code,
3370: 'PRICE TYPE');
3371: IF (x_valid = FALSE) THEN
3372: po_interface_errors_sv1.handle_interface_errors(
3373: 'PO_DOCS_OPEN_INTERFACE',
3374: 'FATAL',
3375: null,
3376: x_interface_header_id,

Line 3394: po_interface_errors_sv1.handle_interface_errors(

3390: IF (x_price_break_lookup_code is not null) THEN
3391: x_valid :=po_headers_sv6.val_lookup_code(x_price_break_lookup_code,
3392: 'PRICE BREAK TYPE');
3393: IF (x_valid = FALSE) THEN
3394: po_interface_errors_sv1.handle_interface_errors(
3395: 'PO_DOCS_OPEN_INTERFACE',
3396: 'FATAL',
3397: null,
3398: x_interface_header_id,

Line 3414: po_interface_errors_sv1.handle_interface_errors(

3410: /* FPI GA start*/
3411: /* For a global agreement cumulative price break lines are not allowed */
3412: IF x_price_break_lookup_code = 'CUMULATIVE' THEN
3413: IF nvl(X_global_agreement_flag,'N') = 'Y' THEN
3414: po_interface_errors_sv1.handle_interface_errors(
3415: 'PO_DOCS_OPEN_INTERFACE',
3416: 'FATAL',
3417: null,
3418: x_interface_header_id,

Line 3434: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

3430: AND p_purchase_basis = 'SERVICES') THEN
3431:
3432: --You cannot have cumulative price breaks on
3433: --FIXED PRICE/SERVICES line types.
3434: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
3435: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
3436: X_Error_type => 'FATAL',
3437: X_Batch_id => NULL,
3438: X_Interface_Header_Id => x_interface_header_id,