[Home] [Help]
71: p_entity_id => p_id_tbl(i),
72: p_column_name => 'NEED_BY_DATE',
73: p_column_val => p_need_by_date_tbl(i),
74: p_message_name => 'PO_SVC_NO_NEED_PROMISE_DATE',
75: p_validation_id => PO_VAL_CONSTANTS.c_loc_need_by_date);
76: x_result_type := po_validations.c_result_type_failure;
77: END IF;
78: END LOOP;
79:
122: p_entity_id => p_id_tbl(i),
123: p_column_name => 'PROMISE_DATE',
124: p_column_val => p_promised_date_tbl(i),
125: p_message_name => 'PO_SVC_NO_NEED_PROMISE_DATE',
126: p_validation_id => PO_VAL_CONSTANTS.c_loc_promised_date);
127: x_result_type := po_validations.c_result_type_failure;
128: END IF;
129: END LOOP;
130:
181: p_entity_id => p_id_tbl(i),
182: p_column_name => 'SHIPMENT_TYPE',
183: p_column_val => p_shipment_type_tbl(i),
184: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
185: p_validation_id => PO_VAL_CONSTANTS.c_shipment_type_not_null);
186: x_result_type := po_validations.c_result_type_failure;
187: ELSIF (p_doc_type = 'QUOTATION' AND p_shipment_type_tbl(i) <> 'QUOTATION')
188: OR (p_doc_type = 'BLANKET' AND p_shipment_type_tbl(i) <> 'PRICE BREAK')
189: OR (p_doc_type = 'STANDARD' AND l_is_complex_work_style = FALSE AND p_shipment_type_tbl(i) <> 'STANDARD') THEN
192: p_entity_id => p_id_tbl(i),
193: p_column_name => 'SHIPMENT_TYPE',
194: p_column_val => p_shipment_type_tbl(i),
195: p_message_name => 'PO_PDOI_INVALID_SHIPMENT_TYPE',
196: p_validation_id => PO_VAL_CONSTANTS.c_shipment_type_valid);
197: x_result_type := po_validations.c_result_type_failure;
198: END IF;
199: END LOOP;
200:
276: p_column_val => p_payment_type_tbl(i),
277: p_message_name => 'PO_PDOI_ADVANCE_NOT_ALLOWED',
278: p_token1_name => 'STYLE_ID',
279: p_token1_value => p_style_id_tbl(i),
280: p_validation_id => PO_VAL_CONSTANTS.c_loc_payment_type);
281: x_result_type := po_validations.c_result_type_failure;
282: ELSIF (l_financing_payments_flag = 'N' AND Nvl(p_payment_type_tbl(i),'MILESTONE') = 'DELIVERY') THEN
283: -- If Financing is not allowed for the style, DELIVERY shipment is not allowed.
284: x_results.add_result(p_entity_type => c_entity_type_line_location,
287: p_column_val => p_payment_type_tbl(i),
288: p_message_name => 'PO_PDOI_DELIVERY_NOT_ALLOWED',
289: p_token1_name => 'STYLE_ID',
290: p_token1_value => p_style_id_tbl(i),
291: p_validation_id => PO_VAL_CONSTANTS.c_loc_payment_type);
292: x_result_type := po_validations.c_result_type_failure;
293: ELSIF (l_complex_work_flag = 'Y' AND
294: ((Nvl(p_payment_type_tbl(i),'MILESTONE') = 'ADVANCE' AND Nvl(p_shipment_type_tbl(i),'STANDARD') <> 'PREPAYMENT') OR
295: (Nvl(p_payment_type_tbl(i),'MILESTONE') = 'DELIVERY' AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') <> 'STANDARD'))) THEN
303: p_token1_name => 'TYPE',
304: p_token1_value => p_shipment_type_tbl(i),
305: p_token2_name => 'VALUE',
306: p_token2_value => p_payment_type_tbl(i),
307: p_validation_id => PO_VAL_CONSTANTS.c_shipment_type_valid);
308: x_result_type := po_validations.c_result_type_failure;
309: ELSIF (l_complex_work_flag = 'Y' AND (p_payment_type_tbl(i) IS NULL OR
310: p_payment_type_tbl(i) NOT IN ('ADVANCE','DELIVERY','MILESTONE','LUMPSUM','RATE'))) THEN
311: -- For a Complex PO shipment, Payment type should not be NULL.
316: p_column_val => p_payment_type_tbl(i),
317: p_message_name => 'PO_PDOI_INVALID_PAYMENT_TYPE',
318: p_token1_name => 'STYLE_ID',
319: p_token1_value => p_style_id_tbl(i),
320: p_validation_id => PO_VAL_CONSTANTS.c_loc_payment_type);
321: x_result_type := po_validations.c_result_type_failure;
322: END IF;
323:
324: IF l_complex_work_flag = 'Y' THEN
340: p_column_val => p_payment_type_tbl(i),
341: p_message_name => 'PO_PDOI_PAY_ITEM_NOT_PRESENT',
342: p_token1_name => 'STYLE_ID',
343: p_token1_value => p_style_id_tbl(i),
344: p_validation_id => PO_VAL_CONSTANTS.c_loc_payment_type);
345: x_result_type := po_validations.c_result_type_failure;
346: END IF;
347: END IF;
348:
363: p_column_val => p_payment_type_tbl(i),
364: p_message_name => 'PO_PDOI_DELIVERY_NOT_PRESENT',
365: p_token1_name => 'STYLE_ID',
366: p_token1_value => p_style_id_tbl(i),
367: p_validation_id => PO_VAL_CONSTANTS.c_loc_payment_type);
368: x_result_type := po_validations.c_result_type_failure;
369: END IF;
370: END IF;
371:
382: p_column_val => p_payment_type_tbl(i),
383: p_message_name => 'PO_PDOI_DUP_DELIVERY_DISALLOW',
384: p_token1_name => 'STYLE_ID',
385: p_token1_value => p_style_id_tbl(i),
386: p_validation_id => PO_VAL_CONSTANTS.c_loc_payment_type);
387: x_result_type := po_validations.c_result_type_failure;
388: END IF;
389: END LOOP;
390: ELSIF Nvl(p_payment_type_tbl(i),'MILESTONE') = 'ADVANCE' THEN
400: p_column_val => p_payment_type_tbl(i),
401: p_message_name => 'PO_PDOI_DUP_ADVANCE_DISALLOW',
402: p_token1_name => 'STYLE_ID',
403: p_token1_value => p_style_id_tbl(i),
404: p_validation_id => PO_VAL_CONSTANTS.c_loc_payment_type);
405: x_result_type := po_validations.c_result_type_failure;
406: END IF;
407: END LOOP;
408: END IF;
477: p_column_val => p_shipment_num_tbl(i),
478: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
479: p_token1_name => 'COLUMN_NAME',
480: p_token1_value => 'SHIPMENT_NUM',
481: p_validation_id => PO_VAL_CONSTANTS.c_shipment_num_not_null);
482: x_result_type := po_validations.c_result_type_failure;
483: /* PDOI for Complex PO Project: Allow Shipment Num zero for Complex PO */
484: ELSIF ((l_is_complex_work_style = FALSE AND p_shipment_num_tbl(i) <= 0)
485: OR (l_is_complex_work_style = TRUE AND p_shipment_num_tbl(i) < 0))THEN
491: p_token1_name => 'COLUMN_NAME',
492: p_token1_value => 'SHIPMENT_NUM',
493: p_token2_name => 'VALUE',
494: p_token2_value => p_shipment_num_tbl(i),
495: p_validation_id => PO_VAL_CONSTANTS.c_shipment_num_gt_zero);
496: x_result_type := po_validations.c_result_type_failure;
497: END IF;
498: END LOOP;
499:
518: 'SHIPMENT_NUM',
519: p_shipment_num_tbl(i),
520: 'VALUE',
521: p_shipment_num_tbl(i),
522: PO_VAL_CONSTANTS.c_shipment_num_unique
523: FROM DUAL
524: WHERE p_shipment_num_tbl(i) IS NOT NULL AND
525: p_po_header_id_tbl(i) IS NOT NULL AND
526: p_po_line_id_tbl(i) IS NOT NULL AND
612: p_entity_id => p_id_tbl(i),
613: p_column_name => 'QUANTITY',
614: p_column_val => p_quantity_tbl(i),
615: p_message_name => 'PO_PDOI_SVC_PB_NO_QTY',
616: p_validation_id => PO_VAL_CONSTANTS.c_loc_quantity);
617: x_result_type := po_validations.c_result_type_failure;
618: ELSIF (p_order_type_lookup_code_tbl(i) NOT IN ('FIXED PRICE', 'RATE')
619: AND p_quantity_tbl(i) IS NOT NULL
620: AND p_quantity_tbl(i) < 0) THEN
626: p_token1_name => 'COLUMN_NAME',
627: p_token1_value => 'QUANTITY',
628: p_token2_name => 'VALUE',
629: p_token2_value => p_quantity_tbl(i),
630: p_validation_id => PO_VAL_CONSTANTS.c_loc_quantity_ge_zero);
631: x_result_type := po_validations.c_result_type_failure;
632: --
633: ELSIF (l_is_financing_style AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') = 'STANDARD'
634: AND Nvl(p_payment_type_tbl(i),'MILESTONE') = 'DELIVERY'
641: p_token1_name => 'COLUMN',
642: p_token1_value => 'QUANTITY',
643: p_token2_name => 'VALUE',
644: p_token2_value => p_quantity_tbl(i),
645: p_validation_id => PO_VAL_CONSTANTS.c_loc_quantity);
646: x_result_type := po_validations.c_result_type_failure;
647: --
648: END IF;
649: END LOOP;
710: p_token1_name => 'COLUMN',
711: p_token1_value => 'AMOUNT',
712: p_token2_name => 'VALUE',
713: p_token2_value => p_amount_tbl(i),
714: p_validation_id => PO_VAL_CONSTANTS.c_loc_amount);
715: x_result_type := po_validations.c_result_type_failure;
716: END IF;
717: END LOOP;
718:
778: p_column_val => p_price_override_tbl(i),
779: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
780: p_token1_name => 'COLUMN_NAME',
781: p_token1_value => 'PRICE_OVERRIDE',
782: p_validation_id => PO_VAL_CONSTANTS.c_loc_price_override_not_null);
783: x_result_type := po_validations.c_result_type_failure;
784: ELSIF p_price_override_tbl(i) < 0 THEN
785: x_results.add_result(p_entity_type => c_entity_type_line_location,
786: p_entity_id => p_id_tbl(i),
790: p_token1_name => 'COLUMN_NAME',
791: p_token1_value => 'PRICE_OVERRIDE',
792: p_token2_name => 'VALUE',
793: p_token2_value => p_price_override_tbl(i),
794: p_validation_id => PO_VAL_CONSTANTS.c_loc_price_override_ge_zero);
795: x_result_type := po_validations.c_result_type_failure;
796: --
797: ELSIF (l_is_financing_style AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') = 'STANDARD'
798: AND Nvl(p_payment_type_tbl(i),'MILESTONE') = 'DELIVERY'
805: p_token1_name => 'COLUMN',
806: p_token1_value => 'PRICE_OVERRIDE',
807: p_token2_name => 'VALUE',
808: p_token2_value => p_price_override_tbl(i),
809: p_validation_id => PO_VAL_CONSTANTS.c_loc_price_override_not_null);
810: x_result_type := po_validations.c_result_type_failure;
811: --
812: END IF;
813: END LOOP;
864: p_column_val => p_price_discount_tbl(i),
865: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
866: p_token1_name => 'COLUMN_NAME',
867: p_token1_value => 'PRICE_DISCOUNT',
868: p_validation_id => PO_VAL_CONSTANTS.c_loc_price_discount_not_null);
869: x_result_type := po_validations.c_result_type_failure;
870:
871: -- Bug 6614819 -- Commented the code below --
872: -- Since negative price break discount is allowed from the form,
880: p_column_val => p_price_discount_tbl(i),
881: p_message_name => 'PO_PDOI_INVALID_DISCOUNT',
882: p_token1_name => 'VALUE',
883: p_token1_value => p_price_discount_tbl(i),
884: p_validation_id => PO_VAL_CONSTANTS.c_loc_price_discount_valid);
885: x_result_type := po_validations.c_result_type_failure;
886: END IF;
887: END LOOP;
888:
950: 'SHIP_TO_ORGANIZATION_ID',
951: p_ship_to_organization_id_tbl(i),
952: 'SHIP_TO_ORGANIZATION_ID',
953: p_ship_to_organization_id_tbl(i),
954: PO_VAL_CONSTANTS.c_ship_to_organization_id
955: FROM DUAL
956: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
957: AND p_item_revision_tbl(i) IS NOT NULL
958: AND p_item_id_tbl(i) IS NOT NULL
991: 'SHIP_TO_ORGANIZATION_ID',
992: p_ship_to_organization_id_tbl(i),
993: 'SHIP_TO_ORGANIZATION_ID',
994: p_ship_to_organization_id_tbl(i),
995: PO_VAL_CONSTANTS.c_ship_to_organization_id
996: FROM DUAL
997: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
998: AND p_item_revision_tbl(i) IS NULL
999: AND p_item_id_tbl(i) IS NOT NULL
1029: 'SHIP_TO_ORGANIZATION_ID',
1030: p_ship_to_organization_id_tbl(i),
1031: 'SHIP_TO_ORGANIZATION_ID',
1032: p_ship_to_organization_id_tbl(i),
1033: PO_VAL_CONSTANTS.c_ship_to_organization_id
1034: FROM DUAL
1035: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
1036: AND p_item_id_tbl(i) IS NULL
1037: AND NOT EXISTS(
1068: 'SHIP_TO_LOCATION_ID',
1069: p_ship_to_location_id_tbl(i),
1070: 'SHIP_TO_LOCATION_ID',
1071: p_ship_to_location_id_tbl(i),
1072: PO_VAL_CONSTANTS.c_loc_ship_to_loc_id_valid
1073: FROM DUAL
1074: WHERE p_ship_to_location_id_tbl(i) IS NOT NULL
1075: AND NOT EXISTS(
1076: SELECT 1
1198: p_entity_id => p_id_tbl(i),
1199: p_column_name => 'EFFECTIVE_DATE',
1200: p_column_val => p_from_date_tbl(i),
1201: p_message_name => 'POX_EFFECTIVE_DATES1',
1202: p_validation_id => PO_VAL_CONSTANTS.c_loc_from_date_ge_hdr_start);
1203: x_result_type := po_validations.c_result_type_failure;
1204: END IF;
1205:
1206: -- Pricebreak effective from date cannot be later than blanket
1210: p_entity_id => p_id_tbl(i),
1211: p_column_name => 'EFFECTIVE_DATE',
1212: p_column_val => p_from_date_tbl(i),
1213: p_message_name => 'POX_EFFECTIVE_DATES4',
1214: p_validation_id => PO_VAL_CONSTANTS.c_loc_from_date_le_hdr_end);
1215: x_result_type := po_validations.c_result_type_failure;
1216: END IF;
1217:
1218: -- Pricebreak effective From Date cannot be later than pricebreak
1223: p_entity_id => p_id_tbl(i),
1224: p_column_name => 'EFFECTIVE_DATE',
1225: p_column_val => p_from_date_tbl(i),
1226: p_message_name => 'POX_EFFECTIVE_DATES3',
1227: p_validation_id => PO_VAL_CONSTANTS.c_loc_from_date_le_loc_end);
1228: x_result_type := po_validations.c_result_type_failure;
1229: END IF;
1230:
1231: -- Pricebreak From Date cannot be greater than the pricebreak line
1235: p_entity_id => p_id_tbl(i),
1236: p_column_name => 'EFFECTIVE_DATE',
1237: p_column_val => p_from_date_tbl(i),
1238: p_message_name => 'POX_EFFECTIVE_DATES6',
1239: p_validation_id => PO_VAL_CONSTANTS.c_loc_from_date_le_line_end);
1240: x_result_type := po_validations.c_result_type_failure;
1241: END IF;
1242:
1243: -- Pricebreak effective To Date cannot be later than
1247: p_entity_id => p_id_tbl(i),
1248: p_column_name => 'EXPIRATION_DATE',
1249: p_column_val => p_line_expiration_date_tbl(i),
1250: p_message_name => 'POX_EFFECTIVE_DATES2',
1251: p_validation_id => PO_VAL_CONSTANTS.c_loc_end_date_le_line_end);
1252: x_result_type := po_validations.c_result_type_failure;
1253: END IF;
1254:
1255: -- Pricebreak To Date is greater than Header End date
1258: p_entity_id => p_id_tbl(i),
1259: p_column_name => 'EXPIRATION_DATE',
1260: p_column_val => p_line_expiration_date_tbl(i),
1261: p_message_name => 'POX_EFFECTIVE_DATES',
1262: p_validation_id => PO_VAL_CONSTANTS.c_loc_end_date_le_hdr_end);
1263: x_result_type := po_validations.c_result_type_failure;
1264: END IF;
1265:
1266: -- Pricebreak To Date cannot be earlier than Header Start date
1269: p_entity_id => p_id_tbl(i),
1270: p_column_name => 'START_DATE',
1271: p_column_val => p_header_start_date_tbl(i),
1272: p_message_name => 'POX_EFFECTIVE_DATES5',
1273: p_validation_id => PO_VAL_CONSTANTS.c_loc_end_date_ge_hdr_start);
1274: x_result_type := po_validations.c_result_type_failure;
1275: END IF;
1276:
1277: -- Pricebreak effective To Date cannot be earlier than Pricebreak
1282: p_entity_id => p_id_tbl(i),
1283: p_column_name => 'EFFECTIVE_DATE',
1284: p_column_val => p_to_date_tbl(i),
1285: p_message_name => 'POX_EFFECTIVE_DATES3',
1286: p_validation_id => PO_VAL_CONSTANTS.c_loc_from_date_le_loc_end);
1287: x_result_type := po_validations.c_result_type_failure;
1288: END IF;
1289:
1290: -- bug5016163
1300: p_entity_id => p_id_tbl(i),
1301: p_column_name => 'EFFECTIVE_DATE',
1302: p_column_val => p_from_date_tbl(i),
1303: p_message_name => 'PO_PDOI_CUMULATIVE_FAILED',
1304: p_validation_id => PO_VAL_CONSTANTS.c_dates_cumulative_failed);
1305:
1306: x_result_type := po_validations.c_result_type_failure;
1307:
1308: ELSIF (p_to_date_tbl(i) IS NOT NULL) THEN
1315: p_entity_id => p_id_tbl(i),
1316: p_column_name => 'EFFECTIVE_DATE',
1317: p_column_val => p_to_date_tbl(i),
1318: p_message_name => 'PO_PDOI_CUMULATIVE_FAILED',
1319: p_validation_id => PO_VAL_CONSTANTS.c_dates_cumulative_failed);
1320:
1321: x_result_type := po_validations.c_result_type_failure;
1322: END IF;
1323: END IF;
1380: 'QTY_RCV_EXCEPTION_CODE',
1381: p_qty_rcv_exception_code_tbl(i),
1382: 'QTY_RCV_EXCEPTION_CODE',
1383: p_qty_rcv_exception_code_tbl(i),
1384: PO_VAL_CONSTANTS.c_qty_ecv_exception_code
1385: FROM DUAL
1386: WHERE p_qty_rcv_exception_code_tbl(i) IS NOT NULL
1387: AND NOT EXISTS(
1388: SELECT 1
1958: 'STYLE_ID',
1959: p_style_id_tbl(i),
1960: 'STYLE_ID',
1961: p_style_id_tbl(i),
1962: PO_VAL_CONSTANTS.c_loc_style_related_info
1963: FROM DUAL
1964: WHERE EXISTS(SELECT 1
1965: FROM po_doc_style_headers pdsh
1966: WHERE pdsh.style_id = p_style_id_tbl(i) AND
2036: 'TAX_NAME',
2037: p_tax_name_tbl(i),
2038: 'VALUE',
2039: p_tax_name_tbl(i),
2040: PO_VAL_CONSTANTS.c_tax_name
2041: FROM DUAL
2042: WHERE p_tax_name_tbl(i) IS NOT NULL
2043: AND p_tax_code_id_tbl(i) IS NULL
2044: AND NOT EXISTS(SELECT 'Y'
2079: 'TAX_NAME',
2080: p_tax_name_tbl(i),
2081: 'VALUE',
2082: p_tax_name_tbl(i),
2083: PO_VAL_CONSTANTS.c_tax_name
2084: FROM DUAL
2085: WHERE p_tax_code_id_tbl(i) IS NOT NULL
2086: AND p_tax_name_tbl(i) IS NOT NULL
2087: AND NOT EXISTS(SELECT 'Y'
2160: 'FOB_LOOKUP_CODE',
2161: p_fob_lookup_code_tbl(i),
2162: 'VALUE',
2163: p_fob_lookup_code_tbl(i),
2164: PO_VAL_CONSTANTS.c_loc_fob_lookup_code
2165: FROM DUAL
2166: WHERE p_fob_lookup_code_tbl(i) IS NOT NULL
2167: AND NOT EXISTS(SELECT 1
2168: FROM PO_LOOKUP_CODES
2231: 'FREIGHT_TERMS',
2232: p_freight_terms_tbl(i),
2233: 'VALUE',
2234: p_freight_terms_tbl(i),
2235: PO_VAL_CONSTANTS.c_loc_freight_terms
2236: FROM DUAL
2237: WHERE p_freight_terms_tbl(i) IS NOT NULL
2238: AND NOT EXISTS(SELECT 1
2239: FROM PO_LOOKUP_CODES
2304: 'FREIGHT_CARRIER',
2305: p_freight_carrier_tbl(i),
2306: 'VALUE',
2307: p_freight_carrier_tbl(i),
2308: PO_VAL_CONSTANTS.c_loc_freight_carrier
2309: FROM DUAL
2310: WHERE p_freight_carrier_tbl(i) IS NOT NULL
2311: AND NOT EXISTS(SELECT 1
2312: FROM ORG_FREIGHT
2362: p_entity_id => p_id_tbl(i),
2363: p_column_name => NULL,
2364: p_column_val => NULL,
2365: p_message_name => 'PO_PDOI_PRICE_BRK_AMT_BASED_LN',
2366: p_validation_id => PO_VAL_CONSTANTS.c_price_break_not_allowed);
2367: x_result_type := po_validations.c_result_type_failure;
2368: END IF;
2369: END LOOP;
2370: