DBA Data[Home] [Help]

APPS.PO_LINE_LOCATIONS_SV7 dependencies on PO_INTERFACE_ERRORS_SV1

Line 56: po_interface_errors_sv1.handle_interface_errors(

52: --Price breaks not allowed for FIXED PRICE line types as well
53: IF (X_type_lookup_code = 'BLANKET') AND
54: (X_order_type IN ('AMOUNT', 'FIXED PRICE')) --
55: THEN
56: po_interface_errors_sv1.handle_interface_errors(
57: 'PO_DOCS_OPEN_INTERFACE',
58: 'FATAL',
59: null,
60: x_interface_header_id,

Line 94: po_interface_errors_sv1.handle_interface_errors(

90: AND line_type_id = X_line_type_id
91: AND category_id = X_category_id;
92:
93: IF X_count = 0 THEN
94: po_interface_errors_sv1.handle_interface_errors(
95: 'PO_DOCS_OPEN_INTERFACE',
96: 'FATAL',
97: null,
98: x_interface_header_id,

Line 125: po_interface_errors_sv1.handle_interface_errors(

121: AND line_type_id = X_line_type_id
122: AND category_id = X_category_id;
123:
124: IF (X_count = 0) THEN
125: po_interface_errors_sv1.handle_interface_errors(
126: 'PO_DOCS_OPEN_INTERFACE',
127: 'FATAL',
128: null,
129: x_interface_header_id,

Line 152: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

148: AND line_type_id = X_line_type_id
149: AND category_id = X_category_id;
150:
151: IF X_count = 0 THEN
152: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
153: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
154: X_Error_type => 'FATAL',
155: X_Batch_id => NULL,
156: X_Interface_Header_Id => x_interface_header_id,

Line 194: po_interface_errors_sv1.handle_interface_errors(

190: AND po_line_id = X_po_line_id
191: AND line_num = p_line_num;
192:
193: IF (X_count = 0) THEN
194: po_interface_errors_sv1.handle_interface_errors(
195: 'PO_DOCS_OPEN_INTERFACE',
196: 'FATAL',
197: null,
198: x_interface_header_id,

Line 354: po_interface_errors_sv1.handle_interface_errors(

350:
351: /*** first need to make sure all the required columns are populated ***/
352: X_progress := '010';
353: IF (x_shipment_type IS NULL) THEN
354: po_interface_errors_sv1.handle_interface_errors(
355: 'PO_DOCS_OPEN_INTERFACE',
356: 'FATAL',
357: null,
358: x_interface_header_id,

Line 372: po_interface_errors_sv1.handle_interface_errors(

368: END IF;
369:
370: X_progress := '020';
371: IF (X_shipment_num IS NULL) THEN
372: po_interface_errors_sv1.handle_interface_errors(
373: 'PO_DOCS_OPEN_INTERFACE',
374: 'FATAL',
375: null,
376: x_interface_header_id,

Line 392: po_interface_errors_sv1.handle_interface_errors(

388: END IF;
389:
390: X_progress := '030';
391: IF (X_line_location_id IS NULL) THEN
392: po_interface_errors_sv1.handle_interface_errors(
393: 'PO_DOCS_OPEN_INTERFACE',
394: 'FATAL',
395: null,
396: x_interface_header_id,

Line 412: po_interface_errors_sv1.handle_interface_errors(

408:
409:
410: X_progress := '040';
411: IF (X_po_line_id IS NULL) THEN
412: po_interface_errors_sv1.handle_interface_errors(
413: 'PO_DOCS_OPEN_INTERFACE',
414: 'FATAL',
415: null,
416: x_interface_header_id,

Line 432: po_interface_errors_sv1.handle_interface_errors(

428:
429:
430: X_progress := '050';
431: IF (X_po_header_id IS NULL) THEN
432: po_interface_errors_sv1.handle_interface_errors(
433: 'PO_DOCS_OPEN_INTERFACE',
434: 'FATAL',
435: null,
436: x_interface_header_id,

Line 464: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

460: FROM PO_LINE_LOCATIONS
461: WHERE po_line_id = x_po_line_id;
462:
463: IF x_temp_count >= 1 THEN
464: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
465: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
466: X_Error_type => 'FATAL',
467: X_Batch_id => NULL,
468: X_Interface_Header_Id => x_interface_header_id,

Line 494: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

490:
491: IF (p_order_type_lookup_code in ('RATE', 'FIXED PRICE')) THEN
492:
493: IF (x_quantity IS NOT NULL) THEN
494: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
495: X_interface_type => 'PO_DOCS_OPEN_INTERFACE',
496: X_Error_type => 'FATAL',
497: X_Batch_id => NULL,
498: X_Interface_Header_Id => x_interface_header_id,

Line 523: po_interface_errors_sv1.handle_interface_errors(

519: --
520:
521: if (x_hd_type_lookup_code <> 'BLANKET') then /* */
522: IF (X_quantity IS NULL) THEN
523: po_interface_errors_sv1.handle_interface_errors(
524: 'PO_DOCS_OPEN_INTERFACE',
525: 'FATAL',
526: null,
527: x_interface_header_id,

Line 548: po_interface_errors_sv1.handle_interface_errors(

544: /* Added x_price_discount as part of the condition */
545:
546: IF (p_order_type_lookup_code <> 'FIXED PRICE') THEN --
547: IF (X_price_override IS NULL AND x_price_discount IS NULL) THEN /* */
548: po_interface_errors_sv1.handle_interface_errors(
549: 'PO_DOCS_OPEN_INTERFACE',
550: 'FATAL',
551: null,
552: x_interface_header_id,

Line 591: po_interface_errors_sv1.handle_interface_errors(

587: x_end_date,
588: l_exp_date,
589: l_errormsg);
590: if (l_errormsg is not null) then
591: po_interface_errors_sv1.handle_interface_errors(
592: 'PO_DOCS_OPEN_INTERFACE',
593: 'FATAL',
594: null,
595: x_interface_header_id,

Line 616: po_interface_errors_sv1.handle_interface_errors(

612: x_ship_to_organization_id,
613: x_ship_to_location_id,
614: l_errormsg);
615: if (l_errormsg is not null) then
616: po_interface_errors_sv1.handle_interface_errors(
617: 'PO_DOCS_OPEN_INTERFACE',
618: 'FATAL',
619: null,
620: x_interface_header_id,

Line 646: po_interface_errors_sv1.handle_interface_errors(

642: when others then
643: null;
644: END;
645: if (l_pb_lookup_code = 'CUMULATIVE') then
646: po_interface_errors_sv1.handle_interface_errors(
647: 'PO_DOCS_OPEN_INTERFACE',
648: 'FATAL',
649: null,
650: x_interface_header_id,

Line 685: po_interface_errors_sv1.handle_interface_errors(

681: AND revision = X_item_revision;
682:
683: IF (X_temp_count = 0) THEN
684: X_progress := '100';
685: po_interface_errors_sv1.handle_interface_errors(
686: 'PO_DOCS_OPEN_INTERFACE',
687: 'FATAL',
688: null,
689: x_interface_header_id,

Line 713: po_interface_errors_sv1.handle_interface_errors(

709: AND organization_id = x_ship_to_organization_id;
710:
711: IF (X_temp_count = 0) THEN
712: X_progress := '120';
713: po_interface_errors_sv1.handle_interface_errors(
714: 'PO_DOCS_OPEN_INTERFACE',
715: 'FATAL',
716: null,
717: x_interface_header_id,

Line 737: po_interface_errors_sv1.handle_interface_errors(

733: X_valid := hr_organizations_sv1.val_inv_organization_id(
734: x_ship_to_organization_id);
735: IF (x_valid = FALSE) THEN
736: X_progress := '140';
737: po_interface_errors_sv1.handle_interface_errors(
738: 'PO_DOCS_OPEN_INTERFACE',
739: 'FATAL',
740: null,
741: x_interface_header_id,

Line 781: PO_INTERFACE_ERRORS_SV1.handle_interface_errors

777: IF (l_return_status <> FND_API.g_ret_sts_success) OR
778: (NOT l_is_ship_to_org_valid)
779: THEN
780: -- The ship-to org is not valid
781: PO_INTERFACE_ERRORS_SV1.handle_interface_errors
782: (x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
783: x_error_type => 'FATAL',
784: x_batch_id => NULL,
785: x_interface_header_id => x_interface_header_id,

Line 830: PO_INTERFACE_ERRORS_SV1.handle_interface_errors

826: IF (l_return_status <> FND_API.g_ret_sts_success) OR
827: (NOT l_is_ship_to_org_valid)
828: THEN
829: -- The ship-to org is not valid
830: PO_INTERFACE_ERRORS_SV1.handle_interface_errors
831: (x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
832: x_error_type => 'FATAL',
833: x_batch_id => NULL,
834: x_interface_header_id => x_interface_header_id,

Line 880: po_interface_errors_sv1.handle_interface_errors(

876: );
877:
878: IF (X_temp_count <> 1 ) THEN
879: X_progress := '170';
880: po_interface_errors_sv1.handle_interface_errors(
881: 'PO_DOCS_OPEN_INTERFACE',
882: 'FATAL',
883: null,
884: x_interface_header_id,

Line 902: po_interface_errors_sv1.handle_interface_errors(

898: x_progress := '180';
899: po_terms_sv.val_ap_terms(x_terms_id, x_res_terms_id);
900: IF (x_res_terms_id is null) THEN
901: x_progress := '190';
902: po_interface_errors_sv1.handle_interface_errors(
903: 'PO_DOCS_OPEN_INTERFACE',
904: 'FATAL',
905: null,
906: x_interface_header_id,

Line 924: po_interface_errors_sv1.handle_interface_errors(

920: IF (x_hd_type_lookup_code = 'QUOTATION') THEN
921: x_progress := '210';
922: IF (x_qty_rcv_tolerance < 0)
923: THEN
924: po_interface_errors_sv1.handle_interface_errors(
925: 'PO_DOCS_OPEN_INTERFACE',
926: 'FATAL',
927: null,
928: x_interface_header_id,

Line 948: po_interface_errors_sv1.handle_interface_errors(

944: x_valid :=po_headers_sv6.val_lookup_code(
945: x_qty_rcv_exception_code,
946: 'RECEIVING CONTROL LEVEL');
947: IF (x_valid = FALSE) THEN
948: po_interface_errors_sv1.handle_interface_errors(
949: 'PO_DOCS_OPEN_INTERFACE',
950: 'FATAL',
951: null,
952: x_interface_header_id,

Line 973: po_interface_errors_sv1.handle_interface_errors(

969: po_vendors_sv.val_freight_carrier(x_ship_via_lookup_code,
970: x_def_inv_org_id, x_res_carrier);
971: IF (x_res_carrier is null) THEN
972: x_progress := '240';
973: po_interface_errors_sv1.handle_interface_errors(
974: 'PO_DOCS_OPEN_INTERFACE',
975: 'FATAL',
976: null,
977: x_interface_header_id,

Line 994: po_interface_errors_sv1.handle_interface_errors(

990: IF (x_fob_lookup_code is not null) THEN
991: x_progress := '240';
992: po_vendors_sv.val_fob(x_fob_lookup_code, x_res_fob);
993: IF (x_res_fob is null) THEN
994: po_interface_errors_sv1.handle_interface_errors(
995: 'PO_DOCS_OPEN_INTERFACE',
996: 'FATAL',
997: null,
998: x_interface_header_id,

Line 1017: po_interface_errors_sv1.handle_interface_errors(

1013: x_progress := '260';
1014: po_vendors_sv.val_freight_terms(x_freight_terms_lookup_code,
1015: x_res_freight);
1016: IF (x_res_freight is null) THEN
1017: po_interface_errors_sv1.handle_interface_errors(
1018: 'PO_DOCS_OPEN_INTERFACE',
1019: 'FATAL',
1020: null,
1021: x_interface_header_id,

Line 1037: po_interface_errors_sv1.handle_interface_errors(

1033: END IF; /* document_type = 'QUOTATION' */
1034:
1035: x_progress := '270';
1036: IF (x_price_override < 0) THEN
1037: po_interface_errors_sv1.handle_interface_errors(
1038: 'PO_DOCS_OPEN_INTERFACE',
1039: 'FATAL',
1040: null,
1041: x_interface_header_id,

Line 1061: po_interface_errors_sv1.handle_interface_errors(

1057: x_progress := '290';
1058: x_valid := po_unit_of_measures_sv1.val_unit_of_measure(x_lead_time_unit,
1059: NULL);
1060: IF (x_valid = FALSE) THEN
1061: po_interface_errors_sv1.handle_interface_errors(
1062: 'PO_DOCS_OPEN_INTERFACE',
1063: 'FATAL',
1064: null,
1065: x_interface_header_id,

Line 1083: po_interface_errors_sv1.handle_interface_errors(

1079: IF (x_price_discount is not null) THEN
1080: x_progress := '310';
1081: x_valid := po_core_sv1.val_discount(x_price_discount);
1082: IF (x_valid = FALSE) THEN
1083: po_interface_errors_sv1.handle_interface_errors(
1084: 'PO_DOCS_OPEN_INTERFACE',
1085: 'FATAL',
1086: null,
1087: x_interface_header_id,

Line 1105: po_interface_errors_sv1.handle_interface_errors(

1101: IF (x_start_date is not null) AND (x_end_date is not null) THEN
1102: x_progress := '330';
1103: x_valid := po_core_sv1.val_start_and_end_date(x_start_date, x_end_date);
1104: IF (x_valid = FALSE) THEN
1105: po_interface_errors_sv1.handle_interface_errors(
1106: 'PO_DOCS_OPEN_INTERFACE',
1107: 'FATAL',
1108: null,
1109: x_interface_header_id,

Line 1132: po_interface_errors_sv1.handle_interface_errors(

1128: of the header ***/
1129: x_valid := po_core_sv1.val_effective_date(x_start_date,
1130: x_po_header_id);
1131: IF (x_valid = FALSE) THEN
1132: po_interface_errors_sv1.handle_interface_errors(
1133: 'PO_DOCS_OPEN_INTERFACE',
1134: 'FATAL',
1135: null,
1136: x_interface_header_id,

Line 1154: po_interface_errors_sv1.handle_interface_errors(

1150: x_progress := '360';
1151: x_valid := po_core_sv1.val_effective_date(x_end_date,
1152: x_po_header_id);
1153: IF (x_valid = FALSE) THEN
1154: po_interface_errors_sv1.handle_interface_errors(
1155: 'PO_DOCS_OPEN_INTERFACE',
1156: 'FATAL',
1157: null,
1158: x_interface_header_id,

Line 1180: po_interface_errors_sv1.handle_interface_errors(

1176: X_valid := po_line_locations_sv1.val_shipment_type(X_shipment_type,
1177: X_hd_type_lookup_code);
1178: IF (X_valid = FALSE) THEN
1179: X_progress := '390';
1180: po_interface_errors_sv1.handle_interface_errors(
1181: 'PO_DOCS_OPEN_INTERFACE',
1182: 'FATAL',
1183: null,
1184: x_interface_header_id,

Line 1210: po_interface_errors_sv1.handle_interface_errors(

1206: x_po_header_id,
1207: x_po_line_id,
1208: null);
1209: IF (x_valid = FALSE) THEN
1210: po_interface_errors_sv1.handle_interface_errors(
1211: 'PO_DOCS_OPEN_INTERFACE',
1212: 'FATAL',
1213: null,
1214: x_interface_header_id,

Line 1229: po_interface_errors_sv1.handle_interface_errors(

1225:
1226: X_progress := '420';
1227: IF (x_shipment_num <= 0) THEN
1228: X_progress := '430';
1229: po_interface_errors_sv1.handle_interface_errors(
1230: 'PO_DOCS_OPEN_INTERFACE',
1231: 'FATAL',
1232: null,
1233: x_interface_header_id,

Line 1254: po_interface_errors_sv1.handle_interface_errors(

1250: X_valid := po_line_locations_sv7.val_line_location_id_unique(
1251: X_line_location_id);
1252:
1253: IF (X_valid = FALSE) THEN
1254: po_interface_errors_sv1.handle_interface_errors(
1255: 'PO_DOCS_OPEN_INTERFACE',
1256: 'FATAL',
1257: null,
1258: x_interface_header_id,

Line 1280: po_interface_errors_sv1.handle_interface_errors(

1276:
1277: IF (x_enforce_ship_to_loc_code <> 'NONE' AND
1278: x_enforce_ship_to_loc_code <> 'REJECT' AND
1279: x_enforce_ship_to_loc_code <> 'WARNING' ) THEN
1280: po_interface_errors_sv1.handle_interface_errors(
1281: 'PO_DOCS_OPEN_INTERFACE',
1282: 'FATAL',
1283: null,
1284: x_interface_header_id,

Line 1302: po_interface_errors_sv1.handle_interface_errors(

1298: IF (x_allow_sub_receipts_flag is not null) THEN
1299: x_progress := '460';
1300: IF (x_allow_sub_receipts_flag <> 'Y' AND
1301: x_allow_sub_receipts_flag <> 'N' ) THEN
1302: po_interface_errors_sv1.handle_interface_errors(
1303: 'PO_DOCS_OPEN_INTERFACE',
1304: 'FATAL',
1305: null,
1306: x_interface_header_id,

Line 1323: po_interface_errors_sv1.handle_interface_errors(

1319: x_progress := '470';
1320: IF (x_days_early_receipt_allowed is not null) THEN
1321: x_progress := '480';
1322: IF (x_days_early_receipt_allowed < 0 ) THEN
1323: po_interface_errors_sv1.handle_interface_errors(
1324: 'PO_DOCS_OPEN_INTERFACE',
1325: 'FATAL',
1326: null,
1327: x_interface_header_id,

Line 1347: po_interface_errors_sv1.handle_interface_errors(

1343:
1344: IF (x_receipt_days_exception_code <> 'NONE' AND
1345: x_receipt_days_exception_code <> 'REJECT' AND
1346: x_receipt_days_exception_code <> 'WARNING' ) THEN
1347: po_interface_errors_sv1.handle_interface_errors(
1348: 'PO_DOCS_OPEN_INTERFACE',
1349: 'FATAL',
1350: null,
1351: x_interface_header_id,

Line 1375: po_interface_errors_sv1.handle_interface_errors(

1371: x_valid := FALSE;
1372: END IF;
1373:
1374: IF (x_valid = FALSE) THEN
1375: po_interface_errors_sv1.handle_interface_errors(
1376: 'PO_DOCS_OPEN_INTERFACE',
1377: 'FATAL',
1378: null,
1379: x_interface_header_id,

Line 1403: po_interface_errors_sv1.handle_interface_errors(

1399: x_valid := FALSE;
1400: END IF;
1401:
1402: IF (x_valid = FALSE) THEN
1403: po_interface_errors_sv1.handle_interface_errors(
1404: 'PO_DOCS_OPEN_INTERFACE',
1405: 'FATAL',
1406: null,
1407: x_interface_header_id,

Line 1428: po_interface_errors_sv1.handle_interface_errors(

1424: from rcv_routing_headers
1425: where routing_header_id = x_receiving_routing_id;
1426:
1427: IF (X_temp_count = 0) THEN
1428: po_interface_errors_sv1.handle_interface_errors(
1429: 'PO_DOCS_OPEN_INTERFACE',
1430: 'FATAL',
1431: null,
1432: x_interface_header_id,

Line 1450: po_interface_errors_sv1.handle_interface_errors(

1446: IF (x_accrue_on_receipt_flag is not null) THEN
1447: x_progress := '580';
1448: IF (x_accrue_on_receipt_flag <> 'Y' AND
1449: x_accrue_on_receipt_flag <> 'N' ) THEN
1450: po_interface_errors_sv1.handle_interface_errors(
1451: 'PO_DOCS_OPEN_INTERFACE',
1452: 'FATAL',
1453: null,
1454: x_interface_header_id,

Line 1472: po_interface_errors_sv1.handle_interface_errors(

1468: IF (x_firm_status_lookup_code is not null) THEN
1469: x_progress := '600';
1470: IF (x_firm_status_lookup_code <> 'Y' AND
1471: x_firm_status_lookup_code <> 'N' ) THEN
1472: po_interface_errors_sv1.handle_interface_errors(
1473: 'PO_DOCS_OPEN_INTERFACE',
1474: 'FATAL',
1475: null,
1476: x_interface_header_id,

Line 1504: PO_INTERFACE_ERRORS_SV1.handle_interface_errors

1500: WHERE po_header_id = x_po_header_id
1501: AND po_line_id = x_po_line_id;
1502:
1503: IF (x_price_override <> NVL(l_line_price,-1)) THEN
1504: PO_INTERFACE_ERRORS_SV1.handle_interface_errors
1505: (x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
1506: x_error_type => 'FATAL',
1507: x_batch_id => NULL,
1508: x_interface_header_id => x_interface_header_id,