eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_LINES2 dependencies on PO_VAL_CONSTANTS

Line 106: PO_VAL_CONSTANTS.c_over_tolerance_error_flag

102: 'OVER_TOLERANCE_ERROR_FLAG',
103: p_over_tolerance_err_flag_tbl(i),
104: 'OVER_TOLERANCE_ERROR_FLAG',
105: p_over_tolerance_err_flag_tbl(i),
106: PO_VAL_CONSTANTS.c_over_tolerance_error_flag
107: FROM DUAL
108: WHERE p_over_tolerance_err_flag_tbl(i) IS NOT NULL AND
109: NOT EXISTS(
110: SELECT 1

Line 173: p_validation_id => PO_VAL_CONSTANTS.c_expiration_date_blk_not_null);

169: p_column_val => p_expiration_date_tbl(i),
170: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
171: p_token1_name => 'COLUMN_NAME',
172: p_token1_value => 'EXPIRATION_DATE',
173: p_validation_id => PO_VAL_CONSTANTS.c_expiration_date_blk_not_null);
174: x_result_type := po_validations.c_result_type_failure;
175: ELSIF p_expiration_date_tbl(i) IS NOT NULL
176: AND (p_header_start_date_tbl(i) > p_expiration_date_tbl(i)
177: OR p_header_end_date_tbl(i) < p_expiration_date_tbl(i)) THEN

Line 183: p_validation_id => PO_VAL_CONSTANTS.c_expiration_date_blk_exc_hdr);

179: p_entity_id => p_id_tbl(i),
180: p_column_name => 'EXPIRATION_DATE',
181: p_column_val => p_expiration_date_tbl(i),
182: p_message_name => 'POX_EXPIRATION_DATES',
183: p_validation_id => PO_VAL_CONSTANTS.c_expiration_date_blk_exc_hdr);
184: x_result_type := po_validations.c_result_type_failure;
185: END IF;
186: END LOOP;
187:

Line 244: p_validation_id => PO_VAL_CONSTANTS.c_ga_flag_temp_labor);

240: p_entity_id => p_id_tbl(i),
241: p_column_name => 'GLOBAL_AGREEMENT_FLAG',
242: p_column_val => p_global_agreement_flag_tbl(i),
243: p_message_name => 'PO_PDOI_SVC_NO_LOCAL_BLANKET',
244: p_validation_id => PO_VAL_CONSTANTS.c_ga_flag_temp_labor);
245: x_result_type := po_validations.c_result_type_failure;
246: END IF;
247: END LOOP;
248:

Line 262: PO_VAL_CONSTANTS.c_ga_flag_op

258: po_validations.c_result_type_failure,
259: c_entity_type_line,
260: p_id_tbl(i),
261: 'PO_PDOI_GA_OSP_NA',
262: PO_VAL_CONSTANTS.c_ga_flag_op
263: FROM DUAL
264: WHERE p_line_type_id_tbl(i) IS NOT NULL
265: AND EXISTS(
266: SELECT 1

Line 326: p_validation_id => PO_VAL_CONSTANTS.c_amount_blanket);

322: p_entity_id => p_id_tbl(i),
323: p_column_name => 'AMOUNT',
324: p_column_val => p_amount_tbl(i),
325: p_message_name => 'PO_PDOI_SVC_BLKT_NO_AMT',
326: p_validation_id => PO_VAL_CONSTANTS.c_amount_blanket);
327: x_result_type := po_validations.c_result_type_failure;
328: ELSIF (p_order_type_lookup_code_tbl(i) = 'FIXED PRICE'
329: AND p_amount_tbl(i) IS NOT NULL
330: AND p_amount_tbl(i) < 0) THEN

Line 340: p_validation_id => PO_VAL_CONSTANTS.c_amount_ge_zero);

336: p_token1_name => 'COLUMN_NAME',
337: p_token1_value => 'AMOUNT',
338: p_token2_name => 'VALUE',
339: p_token2_value => p_amount_tbl(i),
340: p_validation_id => PO_VAL_CONSTANTS.c_amount_ge_zero);
341: x_result_type := po_validations.c_result_type_failure;
342: END IF;
343: END LOOP;
344:

Line 393: p_validation_id => PO_VAL_CONSTANTS.c_order_type_lookup_code);

389: p_entity_id => p_id_tbl(i),
390: p_column_name => 'ORDER_TYPE_LOOKUP_CODE',
391: p_column_val => p_order_type_lookup_code_tbl(i),
392: p_message_name => 'PO_SVC_NOT_ENABLED',
393: p_validation_id => PO_VAL_CONSTANTS.c_order_type_lookup_code);
394: x_result_type := po_validations.c_result_type_failure;
395: END IF;
396: END LOOP;
397: END IF;

Line 452: p_validation_id => PO_VAL_CONSTANTS.c_contractor_name);

448: p_entity_id => p_id_tbl(i),
449: p_column_name => 'CONTRACTOR FIRST/LAST NAME',
450: p_column_val => p_contractor_last_name_tbl(i),
451: p_message_name => 'PO_PDOI_SVC_NO_NAME',
452: p_validation_id => PO_VAL_CONSTANTS.c_contractor_name);
453: x_result_type := po_validations.c_result_type_failure;
454: END IF;
455: END LOOP;
456:

Line 511: p_validation_id => PO_VAL_CONSTANTS.c_job_id_null );

507: p_entity_id => p_id_tbl(i),
508: p_column_name => 'JOB_ID',
509: p_column_val => p_job_id_tbl(i),
510: p_message_name => 'PO_PDOI_SVC_NO_JOB',
511: p_validation_id => PO_VAL_CONSTANTS.c_job_id_null );
512: x_result_type := po_validations.c_result_type_failure;
513: ELSIF p_purchase_basis_tbl(i) = 'TEMP LABOR' AND p_job_id_tbl(i) IS NULL THEN
514: x_results.add_result(p_entity_type => c_entity_type_line,
515: p_entity_id => p_id_tbl(i),

Line 519: p_validation_id => PO_VAL_CONSTANTS.c_job_id_not_null );

515: p_entity_id => p_id_tbl(i),
516: p_column_name => 'JOB_ID',
517: p_column_val => p_job_id_tbl(i),
518: p_message_name => 'PO_PDOI_SVC_MUST_JOB',
519: p_validation_id => PO_VAL_CONSTANTS.c_job_id_not_null );
520: x_result_type := po_validations.c_result_type_failure;
521: END IF;
522: END LOOP;
523:

Line 552: PO_VAL_CONSTANTS.c_job_id_valid

548: 'JOB_ID',
549: p_job_id_tbl(i),
550: 'JOB_BG_ID',
551: p_job_business_group_id_tbl(i),
552: PO_VAL_CONSTANTS.c_job_id_valid
553: FROM DUAL
554: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
555: AND NOT EXISTS(
556: SELECT 1

Line 597: PO_VAL_CONSTANTS.c_job_id_valid

593: 'JOB_ID',
594: p_job_id_tbl(i),
595: 'JOB_BG_ID',
596: p_job_business_group_id_tbl(i),
597: PO_VAL_CONSTANTS.c_job_id_valid
598: FROM DUAL
599: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
600: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
601: AND NOT EXISTS(

Line 638: PO_VAL_CONSTANTS.c_job_id_valid_cat

634: p_id_tbl(i),
635: 'PO_PDOI_SVC_INVALID_JOB_CAT',
636: 'JOB_ID',
637: p_job_id_tbl(i),
638: PO_VAL_CONSTANTS.c_job_id_valid_cat
639: FROM DUAL
640: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
641: AND p_category_id_tbl(i) IS NOT NULL
642: AND NOT EXISTS(

Line 718: PO_VAL_CONSTANTS.c_job_bg_id_not_cross_bg

714: p_id_tbl(i),
715: 'PO_PDOI_SVC_CANNOT_CROSS_BG',
716: 'JOB_BUSINESS_GROUP_ID',
717: p_job_business_group_id_tbl(i),
718: PO_VAL_CONSTANTS.c_job_bg_id_not_cross_bg
719: FROM DUAL
720: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
721: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
722: AND NOT EXISTS(SELECT 1

Line 748: PO_VAL_CONSTANTS.c_job_business_group_id_valid

744: p_id_tbl(i),
745: 'PO_PDOI_SVC_INVALID_BG',
746: 'JOB_BUSINESS_GROUP_ID',
747: p_job_business_group_id_tbl(i),
748: PO_VAL_CONSTANTS.c_job_business_group_id_valid
749: FROM DUAL
750: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
751: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
752: AND NOT EXISTS(

Line 810: p_validation_id => PO_VAL_CONSTANTS.c_capital_expense_flag_null);

806: p_entity_id => p_id_tbl(i),
807: p_column_name => 'CAPITAL_EXPENSE_FLAG',
808: p_column_val => p_capital_expense_flag_tbl(i),
809: p_message_name => 'PO_SVC_NO_CAP_EXPENSE',
810: p_validation_id => PO_VAL_CONSTANTS.c_capital_expense_flag_null);
811: x_result_type := po_validations.c_result_type_failure;
812: END IF;
813: END LOOP;
814:

Line 866: p_validation_id => PO_VAL_CONSTANTS.c_un_number_id_null);

862: p_entity_id => p_id_tbl(i),
863: p_column_name => 'UN_NUMBER',
864: p_column_val => p_un_number_id_tbl(i),
865: p_message_name => 'PO_PDOI_SVC_NO_UNNUMBER',
866: p_validation_id => PO_VAL_CONSTANTS.c_un_number_id_null);
867: x_result_type := po_validations.c_result_type_failure;
868: END IF;
869: END LOOP;
870:

Line 892: PO_VAL_CONSTANTS.c_un_number_id_valid

888: 'UN_NUMBER_ID',
889: p_un_number_id_tbl(i),
890: 'VALUE',
891: p_un_number_id_tbl(i),
892: PO_VAL_CONSTANTS.c_un_number_id_valid
893: FROM DUAL
894: WHERE p_un_number_id_tbl(i) IS NOT NULL
895: AND p_purchase_basis_tbl(i) <> 'TEMP LABOR'
896: AND NOT EXISTS(SELECT 1

Line 957: p_validation_id => PO_VAL_CONSTANTS.c_hazard_class_id_null );

953: p_entity_id => p_id_tbl(i),
954: p_column_name => 'HAZARD_CLASS',
955: p_column_val => p_hazard_class_id_tbl(i),
956: p_message_name => 'PO_PDOI_SVC_NO_HAZARD_CLASS',
957: p_validation_id => PO_VAL_CONSTANTS.c_hazard_class_id_null );
958: x_result_type := po_validations.c_result_type_failure;
959: END IF;
960: END LOOP;
961:

Line 983: PO_VAL_CONSTANTS.c_hazard_class_id_valid

979: 'HAZARD_CLASS_ID',
980: p_hazard_class_id_tbl(i),
981: 'VALUE',
982: p_hazard_class_id_tbl(i),
983: PO_VAL_CONSTANTS.c_hazard_class_id_valid
984: FROM DUAL
985: WHERE p_hazard_class_id_tbl(i) IS NOT NULL
986: AND p_purchase_basis_tbl(i) <> 'TEMP LABOR'
987: AND NOT EXISTS(SELECT 'Y'

Line 1055: p_validation_id => PO_VAL_CONSTANTS.c_item_id_null);

1051: p_column_val => p_item_id_tbl(i),
1052: p_message_name => 'PO_PDOI_COLUMN_NULL',
1053: p_token1_name => 'COLUMN_NAME',
1054: p_token1_value => 'ITEM_ID',
1055: p_validation_id => PO_VAL_CONSTANTS.c_item_id_null);
1056: x_result_type := po_validations.c_result_type_failure;
1057: ELSIF p_order_type_lookup_code_tbl(i) = 'AMOUNT' AND p_item_id_tbl(i) IS NOT NULL THEN
1058: x_results.add_result(p_entity_type => c_entity_type_line,
1059: p_entity_id => p_id_tbl(i),

Line 1065: p_validation_id => PO_VAL_CONSTANTS.c_item_id_null);

1061: p_column_val => p_item_id_tbl(i),
1062: p_message_name => 'PO_PDOI_COLUMN_NULL',
1063: p_token1_name => 'COLUMN_NAME',
1064: p_token1_value => 'ITEM_ID',
1065: p_validation_id => PO_VAL_CONSTANTS.c_item_id_null);
1066: x_result_type := po_validations.c_result_type_failure;
1067: END IF;
1068: END LOOP;
1069:

Line 1089: PO_VAL_CONSTANTS.c_item_id_not_null

1085: p_id_tbl(i),
1086: 'PO_PDOI_ITEM_NOT_NULL',
1087: 'ITEM_ID',
1088: p_item_id_tbl(i),
1089: PO_VAL_CONSTANTS.c_item_id_not_null
1090: FROM DUAL
1091: WHERE p_order_type_lookup_code_tbl(i) = 'QUANTITY'
1092: AND p_item_id_tbl(i) IS NULL
1093: AND EXISTS(

Line 1126: DECODE(plt.outside_operation_flag, 'N', PO_VAL_CONSTANTS.c_item_id_valid,

1122: 'ITEM_ID',
1123: p_item_id_tbl(i),
1124: 'VALUE',
1125: p_item_id_tbl(i),
1126: DECODE(plt.outside_operation_flag, 'N', PO_VAL_CONSTANTS.c_item_id_valid,
1127: PO_VAL_CONSTANTS.c_item_id_op_valid)
1128: FROM po_line_types_b plt
1129: WHERE p_item_id_tbl(i) IS NOT NULL
1130: AND p_line_type_id_tbl(i) IS NOT NULL

Line 1127: PO_VAL_CONSTANTS.c_item_id_op_valid)

1123: p_item_id_tbl(i),
1124: 'VALUE',
1125: p_item_id_tbl(i),
1126: DECODE(plt.outside_operation_flag, 'N', PO_VAL_CONSTANTS.c_item_id_valid,
1127: PO_VAL_CONSTANTS.c_item_id_op_valid)
1128: FROM po_line_types_b plt
1129: WHERE p_item_id_tbl(i) IS NOT NULL
1130: AND p_line_type_id_tbl(i) IS NOT NULL
1131: AND p_line_type_id_tbl(i) = plt.line_type_id

Line 1218: DECODE(p_item_description_tbl(i), NULL, PO_VAL_CONSTANTS.c_item_desc_not_null,

1214: 'ITEM_DESCRIPTION',
1215: p_item_description_tbl(i),
1216: DECODE(p_item_description_tbl(i), NULL, 'COLUMN_NAME', NULL),
1217: DECODE(p_item_description_tbl(i), NULL, 'ITEM_DESCRIPTION', NULL),
1218: DECODE(p_item_description_tbl(i), NULL, PO_VAL_CONSTANTS.c_item_desc_not_null,
1219: PO_VAL_CONSTANTS.c_item_desc_not_updatable)
1220: FROM DUAL
1221: WHERE p_item_description_tbl(i) IS NULL
1222: OR ( p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')

Line 1219: PO_VAL_CONSTANTS.c_item_desc_not_updatable)

1215: p_item_description_tbl(i),
1216: DECODE(p_item_description_tbl(i), NULL, 'COLUMN_NAME', NULL),
1217: DECODE(p_item_description_tbl(i), NULL, 'ITEM_DESCRIPTION', NULL),
1218: DECODE(p_item_description_tbl(i), NULL, PO_VAL_CONSTANTS.c_item_desc_not_null,
1219: PO_VAL_CONSTANTS.c_item_desc_not_updatable)
1220: FROM DUAL
1221: WHERE p_item_description_tbl(i) IS NULL
1222: OR ( p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1223: AND p_item_id_tbl(i) IS NOT NULL

Line 1305: p_validation_id => PO_VAL_CONSTANTS.c_unit_meas_lookup_null);

1301: p_entity_id => p_id_tbl(i),
1302: p_column_name => 'UNIT_MEAS_LOOKUP_CODE',
1303: p_column_val => p_unit_meas_lookup_code_tbl(i),
1304: p_message_name => 'PO_PDOI_SVC_NO_UOM',
1305: p_validation_id => PO_VAL_CONSTANTS.c_unit_meas_lookup_null);
1306: x_result_type := po_validations.c_result_type_failure;
1307: ELSIF (p_order_type_lookup_code_tbl(i) <> 'FIXED PRICE' AND p_unit_meas_lookup_code_tbl(i) IS NULL) THEN
1308: x_results.add_result(p_entity_type => c_entity_type_line,
1309: p_entity_id => p_id_tbl(i),

Line 1315: p_validation_id => PO_VAL_CONSTANTS.c_unit_meas_lookup_not_null);

1311: p_column_val => p_unit_meas_lookup_code_tbl(i),
1312: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
1313: p_token1_name => 'COLUMN_NAME',
1314: p_token1_value => 'UNIT_MEAS_LOOKUP_CODE',
1315: p_validation_id => PO_VAL_CONSTANTS.c_unit_meas_lookup_not_null);
1316: x_result_type := po_validations.c_result_type_failure;
1317: END IF;
1318: END LOOP;
1319:

Line 1349: PO_VAL_CONSTANTS.c_unit_meas_lookup_item

1345: 'ITEM',
1346: 'UNIT_MEAS_LOOKUP_CODE',
1347: p_unit_meas_lookup_code_tbl(i),
1348: p_item_id_tbl(i),
1349: PO_VAL_CONSTANTS.c_unit_meas_lookup_item
1350: FROM DUAL
1351: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1352: AND p_item_id_tbl(i) IS NOT NULL
1353: AND p_unit_meas_lookup_code_tbl(i) IS NOT NULL

Line 1387: PO_VAL_CONSTANTS.c_unit_meas_lookup_valid

1383: 'UNIT_MEAS_LOOKUP_CODE',
1384: p_unit_meas_lookup_code_tbl(i),
1385: 'VALUE',
1386: p_unit_meas_lookup_code_tbl(i),
1387: PO_VAL_CONSTANTS.c_unit_meas_lookup_valid
1388: FROM DUAL
1389: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1390: AND p_item_id_tbl(i) IS NULL
1391: AND p_unit_meas_lookup_code_tbl(i) IS NOT NULL

Line 1430: PO_VAL_CONSTANTS.c_unit_meas_lookup_line_type

1426: 'LINE_TYPE',
1427: 'UNIT_MEAS_LOOKUP_CODE',
1428: p_unit_meas_lookup_code_tbl(i),
1429: pltb.unit_of_measure,
1430: PO_VAL_CONSTANTS.c_unit_meas_lookup_line_type
1431: FROM PO_LINE_TYPES_B pltb
1432: WHERE pltb.line_type_id = p_line_type_id_tbl(i)
1433: AND p_order_type_lookup_code_tbl(i) = 'AMOUNT'
1434: AND p_unit_meas_lookup_code_tbl(i) <> pltb.unit_of_measure;

Line 1467: PO_VAL_CONSTANTS.c_unit_meas_lookup_svc_valid

1463: 'COLUMN_NAME',
1464: 'VALUE',
1465: 'UNIT_MEAS_LOOKUP_CODE',
1466: p_unit_meas_lookup_code_tbl(i),
1467: PO_VAL_CONSTANTS.c_unit_meas_lookup_svc_valid
1468: FROM DUAL
1469: WHERE p_order_type_lookup_code_tbl(i) = 'RATE'
1470: AND NOT EXISTS(SELECT 1
1471: FROM mtl_units_of_measure_vl muomv

Line 1536: p_validation_id => PO_VAL_CONSTANTS.c_item_revision_null);

1532: p_entity_id => p_id_tbl(i),
1533: p_column_name => 'ITEM_REVISION',
1534: p_column_val => p_item_revision_tbl(i),
1535: p_message_name => 'PO_PDOI_COLUMN_NULL',
1536: p_validation_id => PO_VAL_CONSTANTS.c_item_revision_null);
1537: x_result_type := po_validations.c_result_type_failure;
1538: END IF;
1539: END LOOP;
1540:

Line 1572: PO_VAL_CONSTANTS.c_item_revision_item

1568: 'ITEM',
1569: 'item_revision',
1570: p_item_revision_tbl(i),
1571: p_item_id_tbl(i),
1572: PO_VAL_CONSTANTS.c_item_revision_item
1573: FROM DUAL
1574: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1575: AND p_item_revision_tbl(i) IS NOT NULL
1576: AND p_item_id_tbl(i) IS NOT NULL

Line 1684: PO_VAL_CONSTANTS.c_category_id_item

1680: 'VALUE',
1681: p_category_id_tbl(i),
1682: 'ITEM',
1683: p_item_id_tbl(i),
1684: PO_VAL_CONSTANTS.c_category_id_item
1685: FROM DUAL
1686: WHERE p_order_type_lookup_code_tbl(i) NOT IN('FIXED PRICE', 'RATE')
1687: AND p_item_id_tbl(i) IS NOT NULL
1688: AND p_category_id_tbl(i) IS NOT NULL

Line 1726: PO_VAL_CONSTANTS.c_category_id_valid

1722: 'CATEGORY_ID',
1723: p_category_id_tbl(i),
1724: 'VALUE',
1725: p_category_id_tbl(i),
1726: PO_VAL_CONSTANTS.c_category_id_valid
1727: FROM DUAL
1728: WHERE p_order_type_lookup_code_tbl(i) NOT IN('FIXED PRICE', 'RATE')
1729: AND p_item_id_tbl(i) IS NULL
1730: AND p_category_id_tbl(i) IS NOT NULL

Line 1767: PO_VAL_CONSTANTS.c_category_id_valid

1763: 'CATEGORY_ID',
1764: p_category_id_tbl(i),
1765: 'VALUE',
1766: p_category_id_tbl(i),
1767: PO_VAL_CONSTANTS.c_category_id_valid
1768: FROM DUAL
1769: WHERE p_order_type_lookup_code_tbl(i) NOT IN('FIXED PRICE', 'RATE')
1770: AND p_item_id_tbl(i) IS NULL
1771: AND p_category_id_tbl(i) IS NOT NULL

Line 1839: p_validation_id => PO_VAL_CONSTANTS.c_ip_category_id_not_null,

1835: p_token1_name => 'COLUMN_NAME',
1836: p_token1_value => 'IP_CATEGORY_ID',
1837: p_token2_name => 'VALUE',
1838: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_ip_category_id_tbl),
1839: p_validation_id => PO_VAL_CONSTANTS.c_ip_category_id_not_null,
1840: x_results => x_results,
1841: x_result_type => x_result_type);
1842:
1843: -- Validate if x_category_id is valid if not empty

Line 1865: PO_VAL_CONSTANTS.c_ip_category_id_valid

1861: 'IP_CATEGORY_ID',
1862: p_ip_category_id_tbl(i),
1863: 'VALUE',
1864: p_ip_category_id_tbl(i),
1865: PO_VAL_CONSTANTS.c_ip_category_id_valid
1866: FROM DUAL
1867: WHERE p_ip_category_id_tbl(i) IS NOT NULL
1868: AND p_ip_category_id_tbl(i) <> -2
1869: AND NOT EXISTS(

Line 1940: p_validation_id => PO_VAL_CONSTANTS.c_unit_price_not_null);

1936: p_column_val => p_unit_price_tbl(i),
1937: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
1938: p_token1_name => 'COLUMN_NAME',
1939: p_token1_value => 'UNIT_PRICE',
1940: p_validation_id => PO_VAL_CONSTANTS.c_unit_price_not_null);
1941: x_result_type := po_validations.c_result_type_failure;
1942: ELSIF p_order_type_lookup_code_tbl(i) <> 'FIXED PRICE' AND p_unit_price_tbl(i) < 0 THEN
1943: x_results.add_result(p_entity_type => c_entity_type_line,
1944: p_entity_id => p_id_tbl(i),

Line 1952: p_validation_id => PO_VAL_CONSTANTS.c_unit_price_ge_zero);

1948: p_token1_name => 'COLUMN_NAME',
1949: p_token1_value => 'UNIT_PRICE',
1950: p_token2_name => 'VALUE',
1951: p_token2_value => p_unit_price_tbl(i),
1952: p_validation_id => PO_VAL_CONSTANTS.c_unit_price_ge_zero);
1953: x_result_type := po_validations.c_result_type_failure;
1954: END IF;
1955: END LOOP;
1956:

Line 1988: PO_VAL_CONSTANTS.c_unit_price_line_type

1984: 'COLUMN_NAME',
1985: 'VALUE',
1986: 'UNIT_PRICE',
1987: p_unit_price_tbl(i),
1988: PO_VAL_CONSTANTS.c_unit_price_line_type
1989: FROM DUAL
1990: WHERE p_line_type_id_tbl(i) IS NOT NULL
1991: AND p_order_type_lookup_code_tbl(i) = 'AMOUNT'
1992: AND NOT EXISTS(SELECT 1

Line 2009: p_validation_id => PO_VAL_CONSTANTS.c_unit_price_null);

2005: p_entity_id => p_id_tbl(i),
2006: p_column_name => 'UNIT_PRICE',
2007: p_column_val => p_unit_price_tbl(i),
2008: p_message_name => 'PO_PDOI_SVC_NO_PRICE',
2009: p_validation_id => PO_VAL_CONSTANTS.c_unit_price_null);
2010: x_result_type := po_validations.c_result_type_failure;
2011: END IF;
2012: END LOOP;
2013:

Line 2070: p_validation_id => PO_VAL_CONSTANTS.c_quantity_ge_zero);

2066: p_token1_name => 'COLUMN_NAME',
2067: p_token1_value => 'QUANTITY',
2068: p_token2_name => 'VALUE',
2069: p_token2_value => p_quantity_tbl(i),
2070: p_validation_id => PO_VAL_CONSTANTS.c_quantity_ge_zero);
2071: x_result_type := po_validations.c_result_type_failure;
2072: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', quantity
2073: -- must be null
2074: ELSIF (p_order_type_lookup_code_tbl(i) = 'FIXED PRICE' OR p_order_type_lookup_code_tbl(i) = 'RATE') AND

Line 2081: p_validation_id => PO_VAL_CONSTANTS.c_quantity_null);

2077: p_entity_id => p_id_tbl(i),
2078: p_column_name => 'QUANTITY',
2079: p_column_val => p_quantity_tbl(i),
2080: p_message_name => 'PO_SVC_NO_QTY',
2081: p_validation_id => PO_VAL_CONSTANTS.c_quantity_null);
2082: x_result_type := po_validations.c_result_type_failure;
2083: END IF;
2084: END LOOP;
2085:

Line 2134: p_validation_id => PO_VAL_CONSTANTS.c_amount_null);

2130: p_entity_id => p_id_tbl(i),
2131: p_column_name => 'AMOUNT',
2132: p_column_val => p_amount_tbl(i),
2133: p_message_name => 'PO_SVC_NO_AMT',
2134: p_validation_id => PO_VAL_CONSTANTS.c_amount_null);
2135: x_result_type := po_validations.c_result_type_failure;
2136: END IF;
2137: END LOOP;
2138:

Line 2185: p_validation_id => PO_VAL_CONSTANTS.c_rate_type_no_usr);

2181: p_entity_id => p_id_tbl(i),
2182: p_column_name => 'RATE_TYPE',
2183: p_column_val => p_rate_type_tbl(i),
2184: p_message_name => 'PO_PDOI_SVC_RATE_TYPE_NO_USR',
2185: p_validation_id => PO_VAL_CONSTANTS.c_rate_type_no_usr);
2186: x_result_type := po_validations.c_result_type_failure;
2187: END IF;
2188: END LOOP;
2189:

Line 2248: p_validation_id => PO_VAL_CONSTANTS.c_line_num_not_null);

2244: p_column_val => p_line_num_tbl(i),
2245: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2246: p_token1_name => 'COLUMN_NAME',
2247: p_token1_value => 'LINE_NUM',
2248: p_validation_id => PO_VAL_CONSTANTS.c_line_num_not_null);
2249: x_result_type := po_validations.c_result_type_failure;
2250: ELSIF p_line_num_tbl(i) <= 0 THEN
2251: x_results.add_result(p_entity_type => c_entity_type_line,
2252: p_entity_id => p_id_tbl(i),

Line 2260: p_validation_id => PO_VAL_CONSTANTS.c_line_num_gt_zero);

2256: p_token1_name => 'COLUMN_NAME',
2257: p_token1_value => 'LINE_NUM',
2258: p_token2_name => 'VALUE',
2259: p_token2_value => p_line_num_tbl(i),
2260: p_validation_id => PO_VAL_CONSTANTS.c_line_num_gt_zero);
2261: x_result_type := po_validations.c_result_type_failure;
2262: END IF;
2263: END LOOP;
2264:

Line 2291: PO_VAL_CONSTANTS.c_line_num_unique

2287: 'LINE_NUM',
2288: p_line_num_tbl(i),
2289: 'VALUE',
2290: p_line_num_tbl(i),
2291: PO_VAL_CONSTANTS.c_line_num_unique
2292: FROM DUAL
2293: WHERE p_po_header_id_tbl(i) IS NOT NULL
2294: AND p_line_num_tbl(i) IS NOT NULL
2295: AND (EXISTS(SELECT 'Y'

Line 2378: DECODE(p_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_po_line_id_not_null,

2374: 'COLUMN',
2375: 'PO_LINE_ID',
2376: 'VALUE',
2377: p_po_line_id_tbl(i),
2378: DECODE(p_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_po_line_id_not_null,
2379: PO_VAL_CONSTANTS.c_po_line_id_unique)
2380: FROM DUAL
2381: WHERE p_po_line_id_tbl(i) IS NULL
2382: OR ( p_po_header_id_tbl(i) IS NOT NULL

Line 2379: PO_VAL_CONSTANTS.c_po_line_id_unique)

2375: 'PO_LINE_ID',
2376: 'VALUE',
2377: p_po_line_id_tbl(i),
2378: DECODE(p_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_po_line_id_not_null,
2379: PO_VAL_CONSTANTS.c_po_line_id_unique)
2380: FROM DUAL
2381: WHERE p_po_line_id_tbl(i) IS NULL
2382: OR ( p_po_header_id_tbl(i) IS NOT NULL
2383: AND EXISTS(SELECT 1

Line 2453: DECODE(p_line_type_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_line_type_id_not_null,

2449: 'COLUMN_NAME',
2450: 'LINE_TYPE_ID',
2451: 'VALUE',
2452: p_line_type_id_tbl(i),
2453: DECODE(p_line_type_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_line_type_id_not_null,
2454: PO_VAL_CONSTANTS.c_line_type_id_valid)
2455: FROM DUAL
2456: WHERE p_line_type_id_tbl(i) IS NULL OR
2457: NOT EXISTS(SELECT 1

Line 2454: PO_VAL_CONSTANTS.c_line_type_id_valid)

2450: 'LINE_TYPE_ID',
2451: 'VALUE',
2452: p_line_type_id_tbl(i),
2453: DECODE(p_line_type_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_line_type_id_not_null,
2454: PO_VAL_CONSTANTS.c_line_type_id_valid)
2455: FROM DUAL
2456: WHERE p_line_type_id_tbl(i) IS NULL OR
2457: NOT EXISTS(SELECT 1
2458: FROM po_line_types_val_v pltv

Line 2531: PO_VAL_CONSTANTS.c_line_style_on_line_type

2527: 'STYLE_ID',
2528: p_style_id_tbl(i),
2529: 'LINE_TYPE_ID',
2530: p_line_type_id_tbl(i),
2531: PO_VAL_CONSTANTS.c_line_style_on_line_type
2532: FROM po_doc_style_headers pdsh
2533: WHERE p_style_id_tbl(i) IS NOT NULL AND
2534: pdsh.style_id = p_style_id_tbl(i) AND
2535: pdsh.line_type_allowed = 'SPECIFIED' AND

Line 2573: PO_VAL_CONSTANTS.c_line_style_on_purchase_basis

2569: 'STYLE_ID',
2570: p_style_id_tbl(i),
2571: 'PURCHASE_BASIS',
2572: p_purchase_basis_tbl(i),
2573: PO_VAL_CONSTANTS.c_line_style_on_purchase_basis
2574: FROM DUAL
2575: WHERE NOT EXISTS(SELECT 1
2576: FROM po_doc_style_values pdsv
2577: WHERE pdsv.style_id = p_style_id_tbl(i)

Line 2644: PO_VAL_CONSTANTS.c_price_type_lookup_code

2640: 'PRICE_TYPE_LOOKUP_CODE',
2641: p_price_type_lookup_code_tbl(i),
2642: 'VALUE',
2643: p_price_type_lookup_code_tbl(i),
2644: PO_VAL_CONSTANTS.c_price_type_lookup_code
2645: FROM DUAL
2646: WHERE p_price_type_lookup_code_tbl(i) IS NOT NULL
2647: AND NOT EXISTS(
2648: SELECT 'Y'

Line 2935: p_validation_id => PO_VAL_CONSTANTS.c_amount_gt_zero);

2931: p_token1_name => 'COLUMN_NAME',
2932: p_token1_value => 'AMOUNT',
2933: p_token2_name => 'VALUE',
2934: p_token2_value => p_amount_tbl(i),
2935: p_validation_id => PO_VAL_CONSTANTS.c_amount_gt_zero);
2936: x_result_type := po_validations.c_result_type_failure;
2937:
2938: END IF;
2939: END LOOP;

Line 3098: p_validation_id => PO_VAL_CONSTANTS.c_not_to_exceed_price_null);

3094: p_entity_id => p_id_tbl(i),
3095: p_column_name => 'NOT_TO_EXCEED_PRICE',
3096: p_column_val => p_not_to_exceed_price_tbl(i),
3097: p_message_name => 'PO_PDOI_EXCEED_PRICE_NULL',
3098: p_validation_id => PO_VAL_CONSTANTS.c_not_to_exceed_price_null);
3099: x_result_type := po_validations.c_result_type_failure;
3100: ELSIF p_not_to_exceed_price_tbl(i) IS NOT NULL
3101: AND p_not_to_exceed_price_tbl(i) < p_unit_price_tbl(i) THEN
3102: -- If not_to_exceed_price is not null, then it cannot be less than

Line 3113: p_validation_id => PO_VAL_CONSTANTS.c_not_to_exceed_price_valid);

3109: p_token1_name => 'VALUE',
3110: p_token1_value => p_not_to_exceed_price_tbl(i),
3111: p_token2_name => 'UNIT_PRICE',
3112: p_token2_value => p_unit_price_tbl(i),
3113: p_validation_id => PO_VAL_CONSTANTS.c_not_to_exceed_price_valid);
3114: x_result_type := po_validations.c_result_type_failure;
3115: END IF;
3116: END LOOP;
3117:

Line 3169: p_validation_id => PO_VAL_CONSTANTS.c_ip_cat_id_update_not_null);

3165: p_column_val => p_ip_category_id_tbl(i),
3166: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
3167: p_token1_name => 'COLUMN_NAME',
3168: p_token1_value => 'IP_CATEGORY_ID',
3169: p_validation_id => PO_VAL_CONSTANTS.c_ip_cat_id_update_not_null);
3170: x_result_type := po_validations.c_result_type_failure;
3171: END IF;
3172: END LOOP;
3173:

Line 3196: PO_VAL_CONSTANTS.c_ip_cat_id_update_valid

3192: 'IP_CATEGORY_ID',
3193: p_ip_category_id_tbl(i),
3194: 'VALUE',
3195: p_ip_category_id_tbl(i),
3196: PO_VAL_CONSTANTS.c_ip_cat_id_update_valid
3197: FROM DUAL
3198: WHERE p_ip_category_id_tbl(i) IS NOT NULL
3199: AND p_ip_category_id_tbl(i) <> -2
3200: AND NOT EXISTS(

Line 3261: p_validation_id => PO_VAL_CONSTANTS.c_uom_update_not_null);

3257: p_column_val => p_unit_meas_lookup_code_tbl(i),
3258: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
3259: p_token1_name => 'COLUMN_NAME',
3260: p_token1_value => 'UNIT_MEAS_LOOKUP_CODE',
3261: p_validation_id => PO_VAL_CONSTANTS.c_uom_update_not_null);
3262: x_result_type := po_validations.c_result_type_failure;
3263: END IF;
3264: END LOOP;
3265:

Line 3287: PO_VAL_CONSTANTS.c_uom_update_valid

3283: 'UNIT_MEAS_LOOKUP_CODE',
3284: p_unit_meas_lookup_code_tbl(i),
3285: 'UNIT_MEAS_LOOKUP_CODE',
3286: p_unit_meas_lookup_code_tbl(i),
3287: PO_VAL_CONSTANTS.c_uom_update_valid
3288: FROM DUAL
3289: WHERE EXISTS(
3290: SELECT 1
3291: FROM po_lines_all pol,

Line 3368: p_validation_id => PO_VAL_CONSTANTS.c_item_desc_update_not_null);

3364: p_column_val => p_item_description_tbl(i),
3365: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
3366: p_token1_name => 'COLUMN_NAME',
3367: p_token1_value => 'ITEM_DESCRIPTION',
3368: p_validation_id => PO_VAL_CONSTANTS.c_item_desc_update_not_null);
3369: x_result_type := po_validations.c_result_type_failure;
3370: END IF;
3371: END LOOP;
3372:

Line 3397: PO_VAL_CONSTANTS.c_item_desc_update_unupdatable

3393: 'ITEM_DESCRIPTION',
3394: p_item_description_tbl(i),
3395: 'ITEM_DESCRIPTION',
3396: p_item_description_tbl(i),
3397: PO_VAL_CONSTANTS.c_item_desc_update_unupdatable
3398: FROM DUAL
3399: WHERE EXISTS(
3400: SELECT 1
3401: FROM mtl_system_items msi,

Line 3478: p_validation_id => PO_VAL_CONSTANTS.c_negotiated_by_preparer);

3474: p_token1_name => 'COLUMN_NAME',
3475: p_token1_value => 'NEGOTIATED_BY_PREPARER',
3476: p_token2_name => 'VALUE',
3477: p_token2_value => p_negotiated_by_preparer_tbl(i),
3478: p_validation_id => PO_VAL_CONSTANTS.c_negotiated_by_preparer);
3479: x_result_type := po_validations.c_result_type_failure;
3480: END IF;
3481: END LOOP;
3482:

Line 3525: p_validation_id => PO_VAL_CONSTANTS.c_nego_by_prep_update_not_null);

3521: p_column_val => p_negotiated_by_preparer_tbl(i),
3522: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
3523: p_token1_name => 'COLUMN_NAME',
3524: p_token1_value => 'NEGOTIATED_BY_PREPARER',
3525: p_validation_id => PO_VAL_CONSTANTS.c_nego_by_prep_update_not_null);
3526: x_result_type := po_validations.c_result_type_failure;
3527: ELSIF p_negotiated_by_preparer_tbl(i) NOT IN (NULL, 'Y', 'N') THEN
3528: x_results.add_result(p_entity_type => c_entity_type_line,
3529: p_entity_id => p_id_tbl(i),

Line 3537: p_validation_id => PO_VAL_CONSTANTS.c_nego_by_prep_update_valid);

3533: p_token1_name => 'COLUMN_NAME',
3534: p_token1_value => 'NEGOTIATED_BY_PREPARER',
3535: p_token2_name => 'VALUE',
3536: p_token2_value => p_negotiated_by_preparer_tbl(i),
3537: p_validation_id => PO_VAL_CONSTANTS.c_nego_by_prep_update_valid);
3538: x_result_type := po_validations.c_result_type_failure;
3539: END IF;
3540: END LOOP;
3541:

Line 3600: p_validation_id => PO_VAL_CONSTANTS.c_cat_id_update_not_null);

3596: p_column_val => p_category_id_tbl(i),
3597: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
3598: p_token1_name => 'COLUMN_NAME',
3599: p_token1_value => 'CATEGORY_ID',
3600: p_validation_id => PO_VAL_CONSTANTS.c_cat_id_update_not_null);
3601: x_result_type := po_validations.c_result_type_failure;
3602: END IF;
3603: END LOOP;
3604:

Line 3622: PO_VAL_CONSTANTS.c_cat_id_update_not_updatable

3618: p_id_tbl(i),
3619: 'PO_PDOI_NO_PO_CAT_UPDATE',
3620: 'CATEGORY_ID',
3621: p_category_id_tbl(i),
3622: PO_VAL_CONSTANTS.c_cat_id_update_not_updatable
3623: FROM DUAL
3624: WHERE p_category_id_tbl(i) IS NOT NULL
3625: AND (p_item_id_tbl(i) IS NOT NULL OR p_job_id_tbl(i) IS NOT NULL)
3626: AND (EXISTS(SELECT 1

Line 3705: p_validation_id => PO_VAL_CONSTANTS.c_unit_price_update_not_null);

3701: p_column_val => p_unit_price_tbl(i),
3702: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
3703: p_token1_name => 'COLUMN_NAME',
3704: p_token1_value => 'UNIT_PRICE',
3705: p_validation_id => PO_VAL_CONSTANTS.c_unit_price_update_not_null);
3706: x_result_type := po_validations.c_result_type_failure;
3707: ELSIF p_unit_price_tbl(i) IS NOT NULL AND p_unit_price_tbl(i) < 0 THEN
3708: x_results.add_result(p_entity_type => c_entity_type_line,
3709: p_entity_id => p_id_tbl(i),

Line 3717: p_validation_id => PO_VAL_CONSTANTS.c_unit_price_update_ge_zero);

3713: p_token1_name => 'COLUMN_NAME',
3714: p_token1_value => 'UNIT_PRICE',
3715: p_token2_name => 'VALUE',
3716: p_token2_value => p_unit_price_tbl(i),
3717: p_validation_id => PO_VAL_CONSTANTS.c_unit_price_update_ge_zero);
3718: x_result_type := po_validations.c_result_type_failure;
3719:
3720: END IF;
3721: END LOOP;

Line 3742: PO_VAL_CONSTANTS.c_unit_price_null

3738: p_id_tbl(i),
3739: 'PO_PDOI_SVC_NO_PRICE',
3740: 'UNIT_PRICE',
3741: p_unit_price_tbl(i),
3742: PO_VAL_CONSTANTS.c_unit_price_null
3743: FROM po_lines_all POL
3744: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3745: AND POL.order_type_lookup_code = 'FIXED PRICE'
3746: AND p_unit_price_tbl(i) IS NOT NULL

Line 3756: PO_VAL_CONSTANTS.c_unit_price_null

3752: p_id_tbl(i),
3753: 'PO_PDOI_SVC_NO_PRICE',
3754: 'UNIT_PRICE',
3755: p_unit_price_tbl(i),
3756: PO_VAL_CONSTANTS.c_unit_price_null
3757: FROM po_lines_draft_all POL
3758: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3759: AND POL.draft_id = p_draft_id_tbl(i)
3760: AND POL.order_type_lookup_code = 'FIXED PRICE'

Line 3794: PO_VAL_CONSTANTS.c_not_to_exceed_price_valid

3790: 'UNIT_PRICE',
3791: p_unit_price_tbl(i),
3792: 'UNIT_PRICE',
3793: p_unit_price_tbl(i),
3794: PO_VAL_CONSTANTS.c_not_to_exceed_price_valid
3795: FROM po_lines_all POL
3796: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3797: AND POL.not_to_exceed_price < p_unit_price_tbl(i);
3798:

Line 3867: PO_VAL_CONSTANTS.c_amount_blanket

3863: p_id_tbl(i),
3864: 'PO_PDOI_SVC_BLKT_NO_AMT',
3865: 'AMOUNT',
3866: p_amount_tbl(i),
3867: PO_VAL_CONSTANTS.c_amount_blanket
3868: FROM po_lines_all POL
3869: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3870: AND POL.order_type_lookup_code <> 'FIXED PRICE'
3871: AND p_amount_tbl(i) IS NOT NULL

Line 3881: PO_VAL_CONSTANTS.c_amount_blanket

3877: p_id_tbl(i),
3878: 'PO_PDOI_SVC_BLKT_NO_AMT',
3879: 'AMOUNT',
3880: p_amount_tbl(i),
3881: PO_VAL_CONSTANTS.c_amount_blanket
3882: FROM po_lines_draft_all POL
3883: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3884: AND POL.draft_id = p_draft_id_tbl(i)
3885: AND POL.order_type_lookup_code <> 'FIXED PRICE'