[Home] [Help]
68: p_entity_id => p_id_tbl(i),
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:
119: p_entity_id => p_id_tbl(i),
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:
170: p_entity_id => p_id_tbl(i),
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
180: p_entity_id => p_id_tbl(i),
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:
246: p_column_val => p_shipment_num_tbl(i),
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),
258: p_token1_name => 'COLUMN_NAME',
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:
285: 'SHIPMENT_NUM',
286: p_shipment_num_tbl(i),
287: 'VALUE',
288: p_shipment_num_tbl(i),
289: PO_VAL_CONSTANTS.c_shipment_num_unique
290: FROM DUAL
291: WHERE p_shipment_num_tbl(i) IS NOT NULL AND
292: p_po_header_id_tbl(i) IS NOT NULL AND
293: p_po_line_id_tbl(i) IS NOT NULL AND
362: p_entity_id => p_id_tbl(i),
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
376: p_token1_name => 'COLUMN_NAME',
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;
430: p_column_val => p_price_override_tbl(i),
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),
442: p_token1_name => 'COLUMN_NAME',
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:
500: p_column_val => p_price_discount_tbl(i),
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,
516: p_column_val => p_price_discount_tbl(i),
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:
586: 'SHIP_TO_ORGANIZATION_ID',
587: p_ship_to_organization_id_tbl(i),
588: 'SHIP_TO_ORGANIZATION_ID',
589: p_ship_to_organization_id_tbl(i),
590: PO_VAL_CONSTANTS.c_ship_to_organization_id
591: FROM DUAL
592: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
593: AND p_item_revision_tbl(i) IS NOT NULL
594: AND p_item_id_tbl(i) IS NOT NULL
627: 'SHIP_TO_ORGANIZATION_ID',
628: p_ship_to_organization_id_tbl(i),
629: 'SHIP_TO_ORGANIZATION_ID',
630: p_ship_to_organization_id_tbl(i),
631: PO_VAL_CONSTANTS.c_ship_to_organization_id
632: FROM DUAL
633: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
634: AND p_item_revision_tbl(i) IS NULL
635: AND p_item_id_tbl(i) IS NOT NULL
665: 'SHIP_TO_ORGANIZATION_ID',
666: p_ship_to_organization_id_tbl(i),
667: 'SHIP_TO_ORGANIZATION_ID',
668: p_ship_to_organization_id_tbl(i),
669: PO_VAL_CONSTANTS.c_ship_to_organization_id
670: FROM DUAL
671: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
672: AND p_item_id_tbl(i) IS NULL
673: AND NOT EXISTS(
704: 'SHIP_TO_LOCATION_ID',
705: p_ship_to_location_id_tbl(i),
706: 'SHIP_TO_LOCATION_ID',
707: p_ship_to_location_id_tbl(i),
708: PO_VAL_CONSTANTS.c_loc_ship_to_loc_id_valid
709: FROM DUAL
710: WHERE p_ship_to_location_id_tbl(i) IS NOT NULL
711: AND NOT EXISTS(
712: SELECT 1
834: p_entity_id => p_id_tbl(i),
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
846: p_entity_id => p_id_tbl(i),
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
859: p_entity_id => p_id_tbl(i),
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
871: p_entity_id => p_id_tbl(i),
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
883: p_entity_id => p_id_tbl(i),
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
894: p_entity_id => p_id_tbl(i),
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
905: p_entity_id => p_id_tbl(i),
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
918: p_entity_id => p_id_tbl(i),
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
936: p_entity_id => p_id_tbl(i),
937: p_column_name => 'EFFECTIVE_DATE',
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
951: p_entity_id => p_id_tbl(i),
952: p_column_name => 'EFFECTIVE_DATE',
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;
1016: 'QTY_RCV_EXCEPTION_CODE',
1017: p_qty_rcv_exception_code_tbl(i),
1018: 'QTY_RCV_EXCEPTION_CODE',
1019: p_qty_rcv_exception_code_tbl(i),
1020: PO_VAL_CONSTANTS.c_qty_ecv_exception_code
1021: FROM DUAL
1022: WHERE p_qty_rcv_exception_code_tbl(i) IS NOT NULL
1023: AND NOT EXISTS(
1024: SELECT 1
1535: 'STYLE_ID',
1536: p_style_id_tbl(i),
1537: 'STYLE_ID',
1538: p_style_id_tbl(i),
1539: PO_VAL_CONSTANTS.c_loc_style_related_info
1540: FROM DUAL
1541: WHERE EXISTS(SELECT 1
1542: FROM po_doc_style_headers pdsh
1543: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1613: 'TAX_NAME',
1614: p_tax_name_tbl(i),
1615: 'VALUE',
1616: p_tax_name_tbl(i),
1617: PO_VAL_CONSTANTS.c_tax_name
1618: FROM DUAL
1619: WHERE p_tax_name_tbl(i) IS NOT NULL
1620: AND p_tax_code_id_tbl(i) IS NULL
1621: AND NOT EXISTS(SELECT 'Y'
1656: 'TAX_NAME',
1657: p_tax_name_tbl(i),
1658: 'VALUE',
1659: p_tax_name_tbl(i),
1660: PO_VAL_CONSTANTS.c_tax_name
1661: FROM DUAL
1662: WHERE p_tax_code_id_tbl(i) IS NOT NULL
1663: AND p_tax_name_tbl(i) IS NOT NULL
1664: AND NOT EXISTS(SELECT 'Y'
1737: 'FOB_LOOKUP_CODE',
1738: p_fob_lookup_code_tbl(i),
1739: 'VALUE',
1740: p_fob_lookup_code_tbl(i),
1741: PO_VAL_CONSTANTS.c_loc_fob_lookup_code
1742: FROM DUAL
1743: WHERE p_fob_lookup_code_tbl(i) IS NOT NULL
1744: AND NOT EXISTS(SELECT 1
1745: FROM PO_LOOKUP_CODES
1808: 'FREIGHT_TERMS',
1809: p_freight_terms_tbl(i),
1810: 'VALUE',
1811: p_freight_terms_tbl(i),
1812: PO_VAL_CONSTANTS.c_loc_freight_terms
1813: FROM DUAL
1814: WHERE p_freight_terms_tbl(i) IS NOT NULL
1815: AND NOT EXISTS(SELECT 1
1816: FROM PO_LOOKUP_CODES
1881: 'FREIGHT_CARRIER',
1882: p_freight_carrier_tbl(i),
1883: 'VALUE',
1884: p_freight_carrier_tbl(i),
1885: PO_VAL_CONSTANTS.c_loc_freight_carrier
1886: FROM DUAL
1887: WHERE p_freight_carrier_tbl(i) IS NOT NULL
1888: AND NOT EXISTS(SELECT 1
1889: FROM ORG_FREIGHT
1939: p_entity_id => p_id_tbl(i),
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: