APPS.PO_VAL_SHIPMENTS2 dependencies on PO_VALIDATIONS

Line 3: c_entity_type_line_location CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_LINE_LOCATION;

1: PACKAGE BODY PO_VAL_SHIPMENTS2 AS
2: -- $Header: PO_VAL_SHIPMENTS2.plb 120.17.12010000.2 2008/10/29 11:47:48 lswamina ship $
3: c_entity_type_line_location CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_LINE_LOCATION;
4: -- The module base for this package.
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_SHIPMENTS2');
6:
7: -- The module base for the subprogram.

Line 55: x_result_type := po_validations.c_result_type_success;

51: IF (x_results IS NULL) THEN
52: x_results := po_validation_results_type.new_instance();
53: END IF;
54:
55: x_result_type := po_validations.c_result_type_success;
56:
57: IF po_log.d_proc THEN
58: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
59: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);

Line 73: x_result_type := po_validations.c_result_type_failure;

69: p_column_name => 'NEED_BY_DATE',
70: p_column_val => p_need_by_date_tbl(i),
71: p_message_name => 'PO_SVC_NO_NEED_PROMISE_DATE',
72: p_validation_id => PO_VAL_CONSTANTS.c_loc_need_by_date);
73: x_result_type := po_validations.c_result_type_failure;
74: END IF;
75: END LOOP;
76:
77: IF po_log.d_proc THEN

Line 106: x_result_type := po_validations.c_result_type_success;

102: IF (x_results IS NULL) THEN
103: x_results := po_validation_results_type.new_instance();
104: END IF;
105:
106: x_result_type := po_validations.c_result_type_success;
107:
108: IF po_log.d_proc THEN
109: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
110: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);

Line 124: x_result_type := po_validations.c_result_type_failure;

120: p_column_name => 'PROMISE_DATE',
121: p_column_val => p_promised_date_tbl(i),
122: p_message_name => 'PO_SVC_NO_NEED_PROMISE_DATE',
123: p_validation_id => PO_VAL_CONSTANTS.c_loc_promised_date);
124: x_result_type := po_validations.c_result_type_failure;
125: END IF;
126: END LOOP;
127:
128: IF po_log.d_proc THEN

Line 157: x_result_type := po_validations.c_result_type_success;

153: IF (x_results IS NULL) THEN
154: x_results := po_validation_results_type.new_instance();
155: END IF;
156:
157: x_result_type := po_validations.c_result_type_success;
158:
159: IF po_log.d_proc THEN
160: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
161: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

Line 175: x_result_type := po_validations.c_result_type_failure;

171: p_column_name => 'SHIPMENT_TYPE',
172: p_column_val => p_shipment_type_tbl(i),
173: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
174: p_validation_id => PO_VAL_CONSTANTS.c_shipment_type_not_null);
175: x_result_type := po_validations.c_result_type_failure;
176: ELSIF (p_doc_type = 'QUOTATION' AND p_shipment_type_tbl(i) <> 'QUOTATION')
177: OR (p_doc_type = 'BLANKET' AND p_shipment_type_tbl(i) <> 'PRICE BREAK')
178: OR (p_doc_type = 'STANDARD' AND p_shipment_type_tbl(i) <> 'STANDARD') THEN
179: x_results.add_result(p_entity_type => c_entity_type_line_location,

Line 185: x_result_type := po_validations.c_result_type_failure;

181: p_column_name => 'SHIPMENT_TYPE',
182: p_column_val => p_shipment_type_tbl(i),
183: p_message_name => 'PO_PDOI_INVALID_SHIPMENT_TYPE',
184: p_validation_id => PO_VAL_CONSTANTS.c_shipment_type_valid);
185: x_result_type := po_validations.c_result_type_failure;
186: END IF;
187: END LOOP;
188:
189: IF po_log.d_proc THEN

Line 220: x_result_set_id := po_validations.next_result_set_id();

216: IS
217: d_mod CONSTANT VARCHAR2(100) := d_shipment_num;
218: BEGIN
219: IF x_result_set_id IS NULL THEN
220: x_result_set_id := po_validations.next_result_set_id();
221: END IF;
222:
223: IF (x_results IS NULL) THEN
224: x_results := po_validation_results_type.new_instance();

Line 238: x_result_type := po_validations.c_result_type_success;

234: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
235: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
236: END IF;
237:
238: x_result_type := po_validations.c_result_type_success;
239:
240: -- if shipment_type is Null
241: FOR i IN 1 .. p_id_tbl.COUNT LOOP
242: IF p_shipment_num_tbl(i) IS NULL THEN

Line 251: x_result_type := po_validations.c_result_type_failure;

247: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
248: p_token1_name => 'COLUMN_NAME',
249: p_token1_value => 'SHIPMENT_NUM',
250: p_validation_id => PO_VAL_CONSTANTS.c_shipment_num_not_null);
251: x_result_type := po_validations.c_result_type_failure;
252: ELSIF p_shipment_num_tbl(i) <= 0 THEN
253: x_results.add_result(p_entity_type => c_entity_type_line_location,
254: p_entity_id => p_id_tbl(i),
255: p_column_name => 'SHIPMENT_NUM',

Line 263: x_result_type := po_validations.c_result_type_failure;

259: p_token1_value => 'SHIPMENT_NUM',
260: p_token2_name => 'VALUE',
261: p_token2_value => p_shipment_num_tbl(i),
262: p_validation_id => PO_VAL_CONSTANTS.c_shipment_num_gt_zero);
263: x_result_type := po_validations.c_result_type_failure;
264: END IF;
265: END LOOP;
266:
267: -- Validate shipment number is unique

Line 281: po_validations.c_result_type_failure,

277: token1_name,
278: token1_value,
279: validation_id)
280: SELECT x_result_set_id,
281: po_validations.c_result_type_failure,
282: 'PO_LINE_LOCATIONS_DRAFT_ALL',
283: p_id_tbl(i),
284: 'PO_PDOI_SHIPMENT_NUM_UNIQUE',
285: 'SHIPMENT_NUM',

Line 311: x_result_type := po_validations.c_result_type_failure;

307: AND NVL(delete_flag, 'N') = 'N')); -- bug 4642348
308:
309:
310: IF (SQL%ROWCOUNT > 0) THEN
311: x_result_type := po_validations.c_result_type_failure;
312: END IF;
313:
314: IF po_log.d_proc THEN
315: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 315: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

311: x_result_type := po_validations.c_result_type_failure;
312: END IF;
313:
314: IF po_log.d_proc THEN
315: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
316: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
317: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
318: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
319: END IF;

Line 347: x_result_type := po_validations.c_result_type_success;

343: IF (x_results IS NULL) THEN
344: x_results := po_validation_results_type.new_instance();
345: END IF;
346:
347: x_result_type := po_validations.c_result_type_success;
348:
349: IF po_log.d_proc THEN
350: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
351: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);

Line 367: x_result_type := po_validations.c_result_type_failure;

363: p_column_name => 'QUANTITY',
364: p_column_val => p_quantity_tbl(i),
365: p_message_name => 'PO_PDOI_SVC_PB_NO_QTY',
366: p_validation_id => PO_VAL_CONSTANTS.c_loc_quantity);
367: x_result_type := po_validations.c_result_type_failure;
368: ELSIF (p_order_type_lookup_code_tbl(i) NOT IN ('FIXED PRICE', 'RATE')
369: AND p_quantity_tbl(i) IS NOT NULL
370: AND p_quantity_tbl(i) < 0) THEN
371: x_results.add_result(p_entity_type => c_entity_type_line_location,

Line 381: x_result_type := po_validations.c_result_type_failure;

377: p_token1_value => 'QUANTITY',
378: p_token2_name => 'VALUE',
379: p_token2_value => p_quantity_tbl(i),
380: p_validation_id => PO_VAL_CONSTANTS.c_loc_quantity_ge_zero);
381: x_result_type := po_validations.c_result_type_failure;
382:
383: END IF;
384: END LOOP;
385:

Line 415: x_result_type := po_validations.c_result_type_success;

411: IF (x_results IS NULL) THEN
412: x_results := po_validation_results_type.new_instance();
413: END IF;
414:
415: x_result_type := po_validations.c_result_type_success;
416:
417: IF po_log.d_proc THEN
418: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
419: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);

Line 435: x_result_type := po_validations.c_result_type_failure;

431: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
432: p_token1_name => 'COLUMN_NAME',
433: p_token1_value => 'PRICE_OVERRIDE',
434: p_validation_id => PO_VAL_CONSTANTS.c_loc_price_override_not_null);
435: x_result_type := po_validations.c_result_type_failure;
436: ELSIF p_price_override_tbl(i) < 0 THEN
437: x_results.add_result(p_entity_type => c_entity_type_line_location,
438: p_entity_id => p_id_tbl(i),
439: p_column_name => 'PRICE_OVERRIDE',

Line 447: x_result_type := po_validations.c_result_type_failure;

443: p_token1_value => 'PRICE_OVERRIDE',
444: p_token2_name => 'VALUE',
445: p_token2_value => p_price_override_tbl(i),
446: p_validation_id => PO_VAL_CONSTANTS.c_loc_price_override_ge_zero);
447: x_result_type := po_validations.c_result_type_failure;
448: END IF;
449: END LOOP;
450:
451: IF po_log.d_proc THEN

Line 482: x_result_type := po_validations.c_result_type_success;

478: IF (x_results IS NULL) THEN
479: x_results := po_validation_results_type.new_instance();
480: END IF;
481:
482: x_result_type := po_validations.c_result_type_success;
483:
484: IF po_log.d_proc THEN
485: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
486: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);

Line 505: x_result_type := po_validations.c_result_type_failure;

501: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
502: p_token1_name => 'COLUMN_NAME',
503: p_token1_value => 'PRICE_DISCOUNT',
504: p_validation_id => PO_VAL_CONSTANTS.c_loc_price_discount_not_null);
505: x_result_type := po_validations.c_result_type_failure;
506:
507: -- Bug 6614819 -- Commented the code below --
508: -- Since negative price break discount is allowed from the form,
509: -- now it is allowed from PDOI also.

Line 521: x_result_type := po_validations.c_result_type_failure;

517: p_message_name => 'PO_PDOI_INVALID_DISCOUNT',
518: p_token1_name => 'VALUE',
519: p_token1_value => p_price_discount_tbl(i),
520: p_validation_id => PO_VAL_CONSTANTS.c_loc_price_discount_valid);
521: x_result_type := po_validations.c_result_type_failure;
522: END IF;
523: END LOOP;
524:
525: IF po_log.d_proc THEN

Line 553: x_result_set_id := po_validations.next_result_set_id();

549: IS
550: d_mod CONSTANT VARCHAR2(100) := d_ship_to_organization_id;
551: BEGIN
552: IF x_result_set_id IS NULL THEN
553: x_result_set_id := po_validations.next_result_set_id();
554: END IF;
555:
556: x_result_type := po_validations.c_result_type_success;
557:

Line 556: x_result_type := po_validations.c_result_type_success;

552: IF x_result_set_id IS NULL THEN
553: x_result_set_id := po_validations.next_result_set_id();
554: END IF;
555:
556: x_result_type := po_validations.c_result_type_success;
557:
558: IF po_log.d_proc THEN
559: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
560: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);

Line 582: po_validations.c_result_type_failure,

578: token1_name,
579: token1_value,
580: validation_id)
581: SELECT x_result_set_id,
582: po_validations.c_result_type_failure,
583: c_entity_type_line_location,
584: p_id_tbl(i),
585: 'PO_PDOI_INVALID_SHIP_TO_ORG_ID',
586: 'SHIP_TO_ORGANIZATION_ID',

Line 603: x_result_type := po_validations.c_result_type_failure;

599: AND mir.revision = p_item_revision_tbl(i)
600: AND mir.organization_id = p_ship_to_organization_id_tbl(i));
601:
602: IF (SQL%ROWCOUNT > 0) THEN
603: x_result_type := po_validations.c_result_type_failure;
604: END IF;
605:
606: -- If item_id is not null and ship_to_organization_id is not null, and
607: -- item_revision is null, and no record exists in mtl_system_items.

Line 623: po_validations.c_result_type_failure,

619: token1_name,
620: token1_value,
621: validation_id)
622: SELECT x_result_set_id,
623: po_validations.c_result_type_failure,
624: c_entity_type_line_location,
625: p_id_tbl(i),
626: 'PO_PDOI_INVALID_SHIP_TO_ORG_ID',
627: 'SHIP_TO_ORGANIZATION_ID',

Line 643: x_result_type := po_validations.c_result_type_failure;

639: AND msi.organization_id = p_ship_to_organization_id_tbl(i));
640:
641:
642: IF (SQL%ROWCOUNT > 0) THEN
643: x_result_type := po_validations.c_result_type_failure;
644: END IF;
645:
646: -- If item_id is null, and ship_to_organization_id is not null,
647: -- validate ship_to_organization_id against org_organization_definitions

Line 661: po_validations.c_result_type_failure,

657: token1_name,
658: token1_value,
659: validation_id)
660: SELECT x_result_set_id,
661: po_validations.c_result_type_failure,
662: c_entity_type_line_location,
663: p_id_tbl(i),
664: 'PO_PDOI_INVALID_SHIP_TO_ORG_ID',
665: 'SHIP_TO_ORGANIZATION_ID',

Line 681: x_result_type := po_validations.c_result_type_failure;

677: AND SYSDATE < NVL(ood.disable_date, SYSDATE + 1)
678: AND ood.inventory_enabled_flag = 'Y');
679:
680: IF (SQL%ROWCOUNT > 0) THEN
681: x_result_type := po_validations.c_result_type_failure;
682: END IF;
683:
684: -- If ship_to_location_id is not null, check if record exists in
685: -- po_locations_val_v by ship_to_location_id and ship_to_organization_id.

Line 700: po_validations.c_result_type_failure,

696: token1_name,
697: token1_value,
698: validation_id)
699: SELECT x_result_set_id,
700: po_validations.c_result_type_failure,
701: c_entity_type_line_location,
702: p_id_tbl(i),
703: 'PO_PDOI_INVALID_SHIP_TO_LOC_ID',
704: 'SHIP_TO_LOCATION_ID',

Line 721: x_result_type := po_validations.c_result_type_failure;

717: OR PLV.inventory_organization_id = p_ship_to_organization_id_tbl(i)
718: OR p_ship_to_organization_id_tbl(i) IS NULL));
719:
720: IF (SQL%ROWCOUNT > 0) THEN
721: x_result_type := po_validations.c_result_type_failure;
722: END IF;
723:
724: IF po_log.d_proc THEN
725: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 725: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

721: x_result_type := po_validations.c_result_type_failure;
722: END IF;
723:
724: IF po_log.d_proc THEN
725: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
726: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
727: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
728: END IF;
729: EXCEPTION

Line 757: x_result_type := po_validations.c_result_type_success;

753: IF (x_results IS NULL) THEN
754: x_results := po_validation_results_type.new_instance();
755: END IF;
756:
757: x_result_type := po_validations.c_result_type_success;
758:
759: IF po_log.d_proc THEN
760: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
761: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);

Line 780: x_result_type := po_validations.c_result_type_failure;

776: x_results.add_result(p_entity_type => c_entity_type_line_location,
777: p_entity_id => p_id_tbl(i),
778: p_column_name => 'PRICE_BREAK_ATTRIBUTES',
779: p_message_name => 'POX_PRICEBREAK_ITEM_FAILED');
780: x_result_type := po_validations.c_result_type_failure;
781: END IF;
782: END LOOP;
783:
784: IF po_log.d_proc THEN

Line 817: x_result_type := po_validations.c_result_type_success;

813: IF (x_results IS NULL) THEN
814: x_results := po_validation_results_type.new_instance();
815: END IF;
816:
817: x_result_type := po_validations.c_result_type_success;
818:
819: IF po_log.d_proc THEN
820: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
821: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);

Line 839: x_result_type := po_validations.c_result_type_failure;

835: p_column_name => 'EFFECTIVE_DATE',
836: p_column_val => p_from_date_tbl(i),
837: p_message_name => 'POX_EFFECTIVE_DATES1',
838: p_validation_id => PO_VAL_CONSTANTS.c_loc_from_date_ge_hdr_start);
839: x_result_type := po_validations.c_result_type_failure;
840: END IF;
841:
842: -- Pricebreak effective from date cannot be later than blanket
843: -- agreement header end date

Line 851: x_result_type := po_validations.c_result_type_failure;

847: p_column_name => 'EFFECTIVE_DATE',
848: p_column_val => p_from_date_tbl(i),
849: p_message_name => 'POX_EFFECTIVE_DATES4',
850: p_validation_id => PO_VAL_CONSTANTS.c_loc_from_date_le_hdr_end);
851: x_result_type := po_validations.c_result_type_failure;
852: END IF;
853:
854: -- Pricebreak effective From Date cannot be later than pricebreak
855: -- effective To Date

Line 864: x_result_type := po_validations.c_result_type_failure;

860: p_column_name => 'EFFECTIVE_DATE',
861: p_column_val => p_from_date_tbl(i),
862: p_message_name => 'POX_EFFECTIVE_DATES3',
863: p_validation_id => PO_VAL_CONSTANTS.c_loc_from_date_le_loc_end);
864: x_result_type := po_validations.c_result_type_failure;
865: END IF;
866:
867: -- Pricebreak From Date cannot be greater than the pricebreak line
868: -- expiration Date

Line 876: x_result_type := po_validations.c_result_type_failure;

872: p_column_name => 'EFFECTIVE_DATE',
873: p_column_val => p_from_date_tbl(i),
874: p_message_name => 'POX_EFFECTIVE_DATES6',
875: p_validation_id => PO_VAL_CONSTANTS.c_loc_from_date_le_line_end);
876: x_result_type := po_validations.c_result_type_failure;
877: END IF;
878:
879: -- Pricebreak effective To Date cannot be later than
880: -- expiration Date, if expiration date exists

Line 888: x_result_type := po_validations.c_result_type_failure;

884: p_column_name => 'EXPIRATION_DATE',
885: p_column_val => p_line_expiration_date_tbl(i),
886: p_message_name => 'POX_EFFECTIVE_DATES2',
887: p_validation_id => PO_VAL_CONSTANTS.c_loc_end_date_le_line_end);
888: x_result_type := po_validations.c_result_type_failure;
889: END IF;
890:
891: -- Pricebreak To Date is greater than Header End date
892: IF (p_header_end_date_tbl(i) IS NOT NULL AND p_to_date_tbl(i) > p_header_end_date_tbl(i)) THEN

Line 899: x_result_type := po_validations.c_result_type_failure;

895: p_column_name => 'EXPIRATION_DATE',
896: p_column_val => p_line_expiration_date_tbl(i),
897: p_message_name => 'POX_EFFECTIVE_DATES',
898: p_validation_id => PO_VAL_CONSTANTS.c_loc_end_date_le_hdr_end);
899: x_result_type := po_validations.c_result_type_failure;
900: END IF;
901:
902: -- Pricebreak To Date cannot be earlier than Header Start date
903: IF (p_header_start_date_tbl(i) IS NOT NULL AND p_to_date_tbl(i) < p_header_start_date_tbl(i)) THEN

Line 910: x_result_type := po_validations.c_result_type_failure;

906: p_column_name => 'START_DATE',
907: p_column_val => p_header_start_date_tbl(i),
908: p_message_name => 'POX_EFFECTIVE_DATES5',
909: p_validation_id => PO_VAL_CONSTANTS.c_loc_end_date_ge_hdr_start);
910: x_result_type := po_validations.c_result_type_failure;
911: END IF;
912:
913: -- Pricebreak effective To Date cannot be earlier than Pricebreak
914: -- effective From Date

Line 923: x_result_type := po_validations.c_result_type_failure;

919: p_column_name => 'EFFECTIVE_DATE',
920: p_column_val => p_to_date_tbl(i),
921: p_message_name => 'POX_EFFECTIVE_DATES3',
922: p_validation_id => PO_VAL_CONSTANTS.c_loc_from_date_le_loc_end);
923: x_result_type := po_validations.c_result_type_failure;
924: END IF;
925:
926: -- bug5016163
927: -- Time phased pricing cannot go with cumulative pricing

Line 942: x_result_type := po_validations.c_result_type_failure;

938: p_column_val => p_from_date_tbl(i),
939: p_message_name => 'PO_PDOI_CUMULATIVE_FAILED',
940: p_validation_id => PO_VAL_CONSTANTS.c_dates_cumulative_failed);
941:
942: x_result_type := po_validations.c_result_type_failure;
943:
944: ELSIF (p_to_date_tbl(i) IS NOT NULL) THEN
945:
946: -- bug5262146

Line 957: x_result_type := po_validations.c_result_type_failure;

953: p_column_val => p_to_date_tbl(i),
954: p_message_name => 'PO_PDOI_CUMULATIVE_FAILED',
955: p_validation_id => PO_VAL_CONSTANTS.c_dates_cumulative_failed);
956:
957: x_result_type := po_validations.c_result_type_failure;
958: END IF;
959: END IF;
960:
961: END LOOP;

Line 988: x_result_set_id := po_validations.next_result_set_id();

984: IS
985: d_mod CONSTANT VARCHAR2(100) := d_qty_rcv_exception_code;
986: BEGIN
987: IF x_result_set_id IS NULL THEN
988: x_result_set_id := po_validations.next_result_set_id();
989: END IF;
990:
991: x_result_type := po_validations.c_result_type_success;
992:

Line 991: x_result_type := po_validations.c_result_type_success;

987: IF x_result_set_id IS NULL THEN
988: x_result_set_id := po_validations.next_result_set_id();
989: END IF;
990:
991: x_result_type := po_validations.c_result_type_success;
992:
993: IF po_log.d_proc THEN
994: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
995: po_log.proc_begin(d_mod, 'p_qty_rcv_exception_code_tbl', p_qty_rcv_exception_code_tbl);

Line 1012: po_validations.c_result_type_failure,

1008: token1_name,
1009: token1_value,
1010: validation_id)
1011: SELECT x_result_set_id,
1012: po_validations.c_result_type_failure,
1013: c_entity_type_line_location,
1014: p_id_tbl(i),
1015: 'PO_PDOI_INVALID_RCV_EXCEP_CD',
1016: 'QTY_RCV_EXCEPTION_CODE',

Line 1031: x_result_type := po_validations.c_result_type_failure;

1027: AND plc.lookup_type = 'RECEIVING CONTROL LEVEL'
1028: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1029:
1030: IF (SQL%ROWCOUNT > 0) THEN
1031: x_result_type := po_validations.c_result_type_failure;
1032: ELSE
1033: x_result_type := po_validations.c_result_type_success;
1034: END IF;
1035:

Line 1033: x_result_type := po_validations.c_result_type_success;

1029:
1030: IF (SQL%ROWCOUNT > 0) THEN
1031: x_result_type := po_validations.c_result_type_failure;
1032: ELSE
1033: x_result_type := po_validations.c_result_type_success;
1034: END IF;
1035:
1036: IF po_log.d_proc THEN
1037: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 1037: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

1033: x_result_type := po_validations.c_result_type_success;
1034: END IF;
1035:
1036: IF po_log.d_proc THEN
1037: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1038: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1039: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1040: END IF;
1041: EXCEPTION

Line 1067: x_result_type := po_validations.c_result_type_success;

1063: IF (x_results IS NULL) THEN
1064: x_results := po_validation_results_type.new_instance();
1065: END IF;
1066:
1067: x_result_type := po_validations.c_result_type_success;
1068:
1069: IF po_log.d_proc THEN
1070: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1071: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);

Line 1088: x_result_type := po_validations.c_result_type_failure;

1084: p_column_name => 'ENFORCE_SHIP_TO_LOC_CODE',
1085: p_column_val => p_enforce_ship_to_loc_code_tbl(i),
1086: p_message_name => 'PO_PDOI_INVALID_EN_SH_LOC_CODE'
1087: );
1088: x_result_type := po_validations.c_result_type_failure;
1089: END IF;
1090: END LOOP;
1091:
1092: IF po_log.d_proc THEN

Line 1122: x_result_type := po_validations.c_result_type_success;

1118: IF (x_results IS NULL) THEN
1119: x_results := po_validation_results_type.new_instance();
1120: END IF;
1121:
1122: x_result_type := po_validations.c_result_type_success;
1123:
1124: IF po_log.d_proc THEN
1125: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1126: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

Line 1141: x_result_type := po_validations.c_result_type_failure;

1137: p_entity_id => p_id_tbl(i),
1138: p_column_name => 'ALLOW_SUB_RECEIPTS_FLAG',
1139: p_column_val => p_allow_sub_receipts_flag_tbl(i),
1140: p_message_name => 'PO_PDOI_ALLOW_SUB_REC_FLAG');
1141: x_result_type := po_validations.c_result_type_failure;
1142: END IF;
1143: END LOOP;
1144:
1145: IF po_log.d_proc THEN

Line 1175: x_result_type := po_validations.c_result_type_success;

1171: IF (x_results IS NULL) THEN
1172: x_results := po_validation_results_type.new_instance();
1173: END IF;
1174:
1175: x_result_type := po_validations.c_result_type_success;
1176:
1177: IF po_log.d_proc THEN
1178: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1179: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

Line 1195: x_result_type := po_validations.c_result_type_failure;

1191: p_entity_id => p_id_tbl(i),
1192: p_column_name => 'DAYS_EARLY_RECEIPT_ALLOWED',
1193: p_column_val => p_days_early_rcpt_allowed_tbl(i),
1194: p_message_name => 'PO_PDOI_DAYS_EARLY_REC_ALLOWED');
1195: x_result_type := po_validations.c_result_type_failure;
1196: END IF;
1197: END LOOP;
1198:
1199: IF po_log.d_proc THEN

Line 1229: x_result_type := po_validations.c_result_type_success;

1225: IF (x_results IS NULL) THEN
1226: x_results := po_validation_results_type.new_instance();
1227: END IF;
1228:
1229: x_result_type := po_validations.c_result_type_success;
1230:
1231: IF po_log.d_proc THEN
1232: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1233: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

Line 1249: x_result_type := po_validations.c_result_type_failure;

1245: p_entity_id => p_id_tbl(i),
1246: p_column_name => 'RECEIPT_DAYS_EXPECTION_CODE',
1247: p_column_val => p_rcpt_days_exception_code_tbl(i),
1248: p_message_name => 'PO_PDOI_INV_REC_DAYS_EX_CODE');
1249: x_result_type := po_validations.c_result_type_failure;
1250: END IF;
1251: END LOOP;
1252:
1253: IF po_log.d_proc THEN

Line 1283: x_result_type := po_validations.c_result_type_success;

1279: IF (x_results IS NULL) THEN
1280: x_results := po_validation_results_type.new_instance();
1281: END IF;
1282:
1283: x_result_type := po_validations.c_result_type_success;
1284:
1285: IF po_log.d_proc THEN
1286: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1287: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

Line 1303: x_result_type := po_validations.c_result_type_failure;

1299: p_entity_id => p_invoice_close_tolerance_tbl(i),
1300: p_column_name => 'INVOICE_CLOSE_TOLERANCE',
1301: p_column_val => p_invoice_close_tolerance_tbl(i),
1302: p_message_name => 'PO_PDOI_INV_CLOSE_TOLERANCE');
1303: x_result_type := po_validations.c_result_type_failure;
1304: END IF;
1305: END LOOP;
1306:
1307: IF po_log.d_proc THEN

Line 1337: x_result_type := po_validations.c_result_type_success;

1333: IF (x_results IS NULL) THEN
1334: x_results := po_validation_results_type.new_instance();
1335: END IF;
1336:
1337: x_result_type := po_validations.c_result_type_success;
1338:
1339: IF po_log.d_proc THEN
1340: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1341: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

Line 1357: x_result_type := po_validations.c_result_type_failure;

1353: p_entity_id => p_id_tbl(i),
1354: p_column_name => 'RECEIVE_CLOSE_TOLERANCE',
1355: p_column_val => p_receive_close_tolerance_tbl(i),
1356: p_message_name => 'PO_PDOI_RCT_CLOSE_TOLERANCE');
1357: x_result_type := po_validations.c_result_type_failure;
1358: END IF;
1359: END LOOP;
1360:
1361: IF po_log.d_proc THEN

Line 1387: x_result_set_id := po_validations.next_result_set_id();

1383: IS
1384: d_mod CONSTANT VARCHAR2(100) := d_receiving_routing_id;
1385: BEGIN
1386: IF x_result_set_id IS NULL THEN
1387: x_result_set_id := po_validations.next_result_set_id();
1388: END IF;
1389:
1390: x_result_type := po_validations.c_result_type_success;
1391:

Line 1390: x_result_type := po_validations.c_result_type_success;

1386: IF x_result_set_id IS NULL THEN
1387: x_result_set_id := po_validations.next_result_set_id();
1388: END IF;
1389:
1390: x_result_type := po_validations.c_result_type_success;
1391:
1392: IF po_log.d_proc THEN
1393: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1394: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

Line 1412: po_validations.c_result_type_failure,

1408: column_val,
1409: token1_name,
1410: token1_value)
1411: SELECT x_result_set_id,
1412: po_validations.c_result_type_failure,
1413: 'PO_LINE_LOCATIONS_DRAFT_ALL',
1414: p_id_tbl(i),
1415: 'PO_PDOI_INVALID_ROUTING_ID',
1416: 'RECEIVING_ROUTING_ID',

Line 1428: x_result_type := po_validations.c_result_type_failure;

1424: FROM rcv_routing_headers rrh
1425: WHERE rrh.routing_header_id = p_receiving_routing_id_tbl(i));
1426:
1427: IF (SQL%ROWCOUNT > 0) THEN
1428: x_result_type := po_validations.c_result_type_failure;
1429: END IF;
1430:
1431: IF po_log.d_proc THEN
1432: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 1432: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

1428: x_result_type := po_validations.c_result_type_failure;
1429: END IF;
1430:
1431: IF po_log.d_proc THEN
1432: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1433: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1434: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1435: END IF;
1436: EXCEPTION

Line 1460: x_result_type := po_validations.c_result_type_success;

1456: IF (x_results IS NULL) THEN
1457: x_results := po_validation_results_type.new_instance();
1458: END IF;
1459:
1460: x_result_type := po_validations.c_result_type_success;
1461:
1462: IF po_log.d_proc THEN
1463: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1464: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);

Line 1475: x_result_type := po_validations.c_result_type_failure;

1471: p_entity_id => p_id_tbl(i),
1472: p_column_name => 'ACCRUE_ON_RECEIPT_FLAG',
1473: p_column_val => p_accrue_on_receipt_flag_tbl(i),
1474: p_message_name => 'PO_PDOI_INVALID_VALUE');
1475: x_result_type := po_validations.c_result_type_failure;
1476: END IF;
1477: END LOOP;
1478:
1479: IF po_log.d_proc THEN

Line 1504: x_result_set_id := po_validations.next_result_set_id();

1500: IS
1501: d_mod CONSTANT VARCHAR2(100) := d_style_related_info;
1502: BEGIN
1503: IF x_result_set_id IS NULL THEN
1504: x_result_set_id := po_validations.next_result_set_id();
1505: END IF;
1506:
1507: IF po_log.d_proc THEN
1508: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1513: x_result_type := po_validations.c_result_type_success;

1509: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1510: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1511: END IF;
1512:
1513: x_result_type := po_validations.c_result_type_success;
1514:
1515: -- bug5262146
1516: -- Added NVL() around pdsh.price_breaks_flag
1517:

Line 1531: po_validations.c_result_type_failure,

1527: token1_name,
1528: token1_value,
1529: validation_id)
1530: SELECT x_result_set_id,
1531: po_validations.c_result_type_failure,
1532: c_entity_type_line_location,
1533: p_id_tbl(i),
1534: 'PO_PDOI_PRICE_BREAK_STYLE',
1535: 'STYLE_ID',

Line 1547: x_result_type := po_validations.c_result_type_failure;

1543: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1544: NVL(pdsh.price_breaks_flag, 'N') = 'N');
1545:
1546: IF (SQL%ROWCOUNT > 0) THEN
1547: x_result_type := po_validations.c_result_type_failure;
1548: END IF;
1549:
1550: IF po_log.d_proc THEN
1551: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 1551: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

1547: x_result_type := po_validations.c_result_type_failure;
1548: END IF;
1549:
1550: IF po_log.d_proc THEN
1551: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1552: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1553: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1554: END IF;
1555: EXCEPTION

Line 1582: x_result_set_id := po_validations.next_result_set_id();

1578: IS
1579: d_mod CONSTANT VARCHAR2(100) := d_tax_name;
1580: BEGIN
1581: IF x_result_set_id IS NULL THEN
1582: x_result_set_id := po_validations.next_result_set_id();
1583: END IF;
1584:
1585: IF po_log.d_proc THEN
1586: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1592: x_result_type := po_validations.c_result_type_success;

1588: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);
1589: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1590: END IF;
1591:
1592: x_result_type := po_validations.c_result_type_success;
1593:
1594: -- Bug 4965755. Modified both queries to include -99 as valid orgs in zx
1595: -- tax_name must be valid if not null
1596: FORALL i IN 1 .. p_id_tbl.COUNT

Line 1609: po_validations.c_result_type_failure,

1605: token1_name,
1606: token1_value,
1607: validation_id)
1608: SELECT x_result_set_id,
1609: po_validations.c_result_type_failure,
1610: c_entity_type_line_location,
1611: p_id_tbl(i),
1612: 'PO_PDOI_INVALID_TAX_NAME',
1613: 'TAX_NAME',

Line 1634: x_result_type := po_validations.c_result_type_failure;

1630: SYSDATE)
1631: AND p_allow_tax_code_override = 'Y');
1632:
1633: IF (SQL%ROWCOUNT > 0) THEN
1634: x_result_type := po_validations.c_result_type_failure;
1635: END IF;
1636:
1637: -- tax_code_id and tax_name must be a valid combination in zx_id_tcc_mapping
1638: -- if both are not null

Line 1652: po_validations.c_result_type_failure,

1648: token1_name,
1649: token1_value,
1650: validation_id)
1651: SELECT x_result_set_id,
1652: po_validations.c_result_type_failure,
1653: c_entity_type_line_location,
1654: p_id_tbl(i),
1655: 'PO_PDOI_INVALID_TAX_NAME',
1656: 'TAX_NAME',

Line 1680: x_result_type := po_validations.c_result_type_failure;

1676: AND active_flag = 'Y'
1677: AND p_allow_tax_code_override = 'Y');
1678:
1679: IF (SQL%ROWCOUNT > 0) THEN
1680: x_result_type := po_validations.c_result_type_failure;
1681: END IF;
1682:
1683: IF po_log.d_proc THEN
1684: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 1684: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

1680: x_result_type := po_validations.c_result_type_failure;
1681: END IF;
1682:
1683: IF po_log.d_proc THEN
1684: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1685: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1686: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1687: END IF;
1688: EXCEPTION

Line 1708: x_result_set_id := po_validations.next_result_set_id();

1704: IS
1705: d_mod CONSTANT VARCHAR2(100) := d_fob_lookup_code;
1706: BEGIN
1707: IF x_result_set_id IS NULL THEN
1708: x_result_set_id := po_validations.next_result_set_id();
1709: END IF;
1710:
1711: IF po_log.d_proc THEN
1712: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1717: x_result_type := po_validations.c_result_type_success;

1713: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1714: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1715: END IF;
1716:
1717: x_result_type := po_validations.c_result_type_success;
1718:
1719: -- fob_lookup_code must be valid if not null
1720: FORALL i IN 1 .. p_id_tbl.COUNT
1721: INSERT INTO po_validation_results_gt

Line 1733: po_validations.c_result_type_failure,

1729: token1_name,
1730: token1_value,
1731: validation_id)
1732: SELECT x_result_set_id,
1733: po_validations.c_result_type_failure,
1734: c_entity_type_line_location,
1735: p_id_tbl(i),
1736: 'PO_PDOI_INVALID_FOB',
1737: 'FOB_LOOKUP_CODE',

Line 1751: x_result_type := po_validations.c_result_type_failure;

1747: sysdate < nvl(inactive_date, sysdate + 1) AND
1748: lookup_code = p_fob_lookup_code_tbl(i));
1749:
1750: IF (SQL%ROWCOUNT > 0) THEN
1751: x_result_type := po_validations.c_result_type_failure;
1752: END IF;
1753:
1754: IF po_log.d_proc THEN
1755: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 1755: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

1751: x_result_type := po_validations.c_result_type_failure;
1752: END IF;
1753:
1754: IF po_log.d_proc THEN
1755: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1756: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1757: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1758: END IF;
1759: EXCEPTION

Line 1779: x_result_set_id := po_validations.next_result_set_id();

1775: IS
1776: d_mod CONSTANT VARCHAR2(100) := d_freight_terms;
1777: BEGIN
1778: IF x_result_set_id IS NULL THEN
1779: x_result_set_id := po_validations.next_result_set_id();
1780: END IF;
1781:
1782: IF po_log.d_proc THEN
1783: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1788: x_result_type := po_validations.c_result_type_success;

1784: po_log.proc_begin(d_mod, 'p_freight_terms_tbl', p_freight_terms_tbl);
1785: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1786: END IF;
1787:
1788: x_result_type := po_validations.c_result_type_success;
1789:
1790: -- freight_terms must be valid if not null
1791: FORALL i IN 1 .. p_id_tbl.COUNT
1792: INSERT INTO po_validation_results_gt

Line 1804: po_validations.c_result_type_failure,

1800: token1_name,
1801: token1_value,
1802: validation_id)
1803: SELECT x_result_set_id,
1804: po_validations.c_result_type_failure,
1805: c_entity_type_line_location,
1806: p_id_tbl(i),
1807: 'PO_PDOI_INVALID_FREIGHT_TERMS',
1808: 'FREIGHT_TERMS',

Line 1822: x_result_type := po_validations.c_result_type_failure;

1818: sysdate < nvl(inactive_date, sysdate + 1) AND
1819: lookup_code = p_freight_terms_tbl(i));
1820:
1821: IF (SQL%ROWCOUNT > 0) THEN
1822: x_result_type := po_validations.c_result_type_failure;
1823: END IF;
1824:
1825: IF po_log.d_proc THEN
1826: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 1826: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

1822: x_result_type := po_validations.c_result_type_failure;
1823: END IF;
1824:
1825: IF po_log.d_proc THEN
1826: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1827: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1828: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1829: END IF;
1830: EXCEPTION

Line 1851: x_result_set_id := po_validations.next_result_set_id();

1847: IS
1848: d_mod CONSTANT VARCHAR2(100) := d_freight_carrier;
1849: BEGIN
1850: IF x_result_set_id IS NULL THEN
1851: x_result_set_id := po_validations.next_result_set_id();
1852: END IF;
1853:
1854: IF po_log.d_proc THEN
1855: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1861: x_result_type := po_validations.c_result_type_success;

1857: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1858: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1859: END IF;
1860:
1861: x_result_type := po_validations.c_result_type_success;
1862:
1863: -- freight_carrier must be valid if not null
1864: FORALL i IN 1 .. p_id_tbl.COUNT
1865: INSERT INTO po_validation_results_gt

Line 1877: po_validations.c_result_type_failure,

1873: token1_name,
1874: token1_value,
1875: validation_id)
1876: SELECT x_result_set_id,
1877: po_validations.c_result_type_failure,
1878: c_entity_type_line_location,
1879: p_id_tbl(i),
1880: 'PO_PDOI_INVALID_FREIGHT_CARR',
1881: 'FREIGHT_CARRIER',

Line 1895: x_result_type := po_validations.c_result_type_failure;

1891: organization_id = p_inventory_org_id AND
1892: nvl(disable_date, sysdate + 1) > sysdate);
1893:
1894: IF (SQL%ROWCOUNT > 0) THEN
1895: x_result_type := po_validations.c_result_type_failure;
1896: END IF;
1897:
1898: IF po_log.d_proc THEN
1899: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 1899: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

1895: x_result_type := po_validations.c_result_type_failure;
1896: END IF;
1897:
1898: IF po_log.d_proc THEN
1899: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1901: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1902: END IF;
1903: EXCEPTION

Line 1928: x_result_type := po_validations.c_result_type_success;

1924: IF (x_results IS NULL) THEN
1925: x_results := po_validation_results_type.new_instance();
1926: END IF;
1927:
1928: x_result_type := po_validations.c_result_type_success;
1929:
1930: IF po_log.d_proc THEN
1931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1932: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);

Line 1944: x_result_type := po_validations.c_result_type_failure;

1940: p_column_name => NULL,
1941: p_column_val => NULL,
1942: p_message_name => 'PO_PDOI_PRICE_BRK_AMT_BASED_LN',
1943: p_validation_id => PO_VAL_CONSTANTS.c_price_break_not_allowed);
1944: x_result_type := po_validations.c_result_type_failure;
1945: END IF;
1946: END LOOP;
1947:
1948: IF po_log.d_proc THEN