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_HEADERS2 dependencies on PO_VAL_CONSTANTS

Line 80: DECODE(p_po_header_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_po_header_id_not_null,

76: 'COLUMN_NAME',
77: 'PO_HEADER_ID',
78: 'VALUE',
79: p_po_header_id_tbl(i),
80: DECODE(p_po_header_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_po_header_id_not_null,
81: PO_VAL_CONSTANTS.c_po_header_id_unique)
82: FROM DUAL
83: WHERE p_id_tbl(i) IS NULL OR EXISTS(SELECT 1
84: FROM po_headers_all poh

Line 81: PO_VAL_CONSTANTS.c_po_header_id_unique)

77: 'PO_HEADER_ID',
78: 'VALUE',
79: p_po_header_id_tbl(i),
80: DECODE(p_po_header_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_po_header_id_not_null,
81: PO_VAL_CONSTANTS.c_po_header_id_unique)
82: FROM DUAL
83: WHERE p_id_tbl(i) IS NULL OR EXISTS(SELECT 1
84: FROM po_headers_all poh
85: WHERE p_po_header_id_tbl(i) = poh.po_header_id);

Line 163: PO_VAL_CONSTANTS.c_document_num_unique

159: 'DOCUMENT_NUM',
160: p_document_num_tbl(i),
161: 'VALUE',
162: p_document_num_tbl(i),
163: PO_VAL_CONSTANTS.c_document_num_unique
164: FROM DUAL
165: WHERE p_document_num_tbl(i) IS NOT NULL AND
166: EXISTS(SELECT 1
167: FROM po_headers

Line 192: p_validation_id => PO_VAL_CONSTANTS.c_document_num_not_null);

188: p_token1_name => 'COLUMN_NAME',
189: p_token1_value => 'DOCUMENT_NUM',
190: p_token2_name => 'VALUE',
191: p_token2_value => p_document_num_tbl(i),
192: p_validation_id => PO_VAL_CONSTANTS.c_document_num_not_null);
193:
194: x_result_type := po_validations.c_result_type_failure; -- bug5101044
195: ELSIF ((p_type_lookup_code_tbl(i) IN ('BLANKET', 'STANDARD')
196: AND p_manual_po_num_type = 'NUMERIC')

Line 218: p_validation_id => PO_VAL_CONSTANTS.c_document_num_ge_zero);

214: p_token1_name => 'COLUMN_NAME',
215: p_token1_value => 'DOCUMENT_NUM',
216: p_token2_name => 'VALUE',
217: p_token2_value => p_document_num_tbl(i),
218: p_validation_id => PO_VAL_CONSTANTS.c_document_num_ge_zero);
219: x_result_type := po_validations.c_result_type_failure;
220: END IF;
221:
222: EXCEPTION

Line 234: p_validation_id => PO_VAL_CONSTANTS.c_document_num_valid);

230: p_token1_name => 'COLUMN_NAME',
231: p_token1_value => 'DOCUMENT_NUM',
232: p_token2_name => 'VALUE',
233: p_token2_value => p_document_num_tbl(i),
234: p_validation_id => PO_VAL_CONSTANTS.c_document_num_valid);
235: x_result_type := po_validations.c_result_type_failure;
236: END;
237: END IF;
238: END LOOP;

Line 291: p_validation_id => PO_VAL_CONSTANTS.c_type_lookup_code_not_null);

287: p_token1_name => 'COLUMN_NAME',
288: p_token1_value => 'TYPE_LOOKUP_CODE',
289: p_token2_name => 'VALUE',
290: p_token2_value => p_type_lookup_code_tbl(i),
291: p_validation_id => PO_VAL_CONSTANTS.c_type_lookup_code_not_null);
292: x_result_type := po_validations.c_result_type_failure;
293: ELSIF p_type_lookup_code_tbl(i) NOT IN('BLANKET', 'STANDARD', 'QUOTATION') THEN
294: x_results.add_result(p_entity_type => c_entity_type_header,
295: p_entity_id => p_id_tbl(i),

Line 301: p_validation_id => PO_VAL_CONSTANTS.c_type_lookup_code_valid);

297: p_column_val => p_type_lookup_code_tbl(i),
298: p_message_name => 'PO_PDOI_INVALID_TYPE_LKUP_CD',
299: p_token1_name => 'VALUE',
300: p_token1_value => p_type_lookup_code_tbl(i),
301: p_validation_id => PO_VAL_CONSTANTS.c_type_lookup_code_valid);
302: x_result_type := po_validations.c_result_type_failure;
303: END IF;
304: END LOOP;
305:

Line 367: DECODE(p_currency_code_tbl(i), NULL, PO_VAL_CONSTANTS.c_currency_code_not_null,

363: 'COLUMN_NAME',
364: 'CURRENCY_CODE',
365: 'VALUE',
366: p_currency_code_tbl(i),
367: DECODE(p_currency_code_tbl(i), NULL, PO_VAL_CONSTANTS.c_currency_code_not_null,
368: PO_VAL_CONSTANTS.c_currency_code_valid)
369: FROM DUAL
370: WHERE p_currency_code_tbl(i) IS NULL
371: OR NOT EXISTS(

Line 368: PO_VAL_CONSTANTS.c_currency_code_valid)

364: 'CURRENCY_CODE',
365: 'VALUE',
366: p_currency_code_tbl(i),
367: DECODE(p_currency_code_tbl(i), NULL, PO_VAL_CONSTANTS.c_currency_code_not_null,
368: PO_VAL_CONSTANTS.c_currency_code_valid)
369: FROM DUAL
370: WHERE p_currency_code_tbl(i) IS NULL
371: OR NOT EXISTS(
372: SELECT 1

Line 455: p_validation_id => PO_VAL_CONSTANTS.c_rate_null);

451: p_token1_name => 'COLUMN_NAME',
452: p_token1_value => 'RATE',
453: p_token2_name => 'VALUE',
454: p_token2_value => p_rate_tbl(i),
455: p_validation_id => PO_VAL_CONSTANTS.c_rate_null);
456: x_result_type := po_validations.c_result_type_failure;
457: END IF;
458:
459: -- validate rate_type is null if currency is functional

Line 470: p_validation_id => PO_VAL_CONSTANTS.c_rate_type_null);

466: p_token1_name => 'COLUMN_NAME',
467: p_token1_value => 'RATE_TYPE',
468: p_token2_name => 'VALUE',
469: p_token2_value => p_rate_type_tbl(i),
470: p_validation_id => PO_VAL_CONSTANTS.c_rate_type_null);
471: x_result_type := po_validations.c_result_type_failure;
472: END IF;
473:
474: -- validate rate_date is null if currency is functional

Line 485: p_validation_id => PO_VAL_CONSTANTS.c_rate_date_null);

481: p_token1_name => 'COLUMN_NAME',
482: p_token1_value => 'RATE_DATE',
483: p_token2_name => 'VALUE',
484: p_token2_value => p_rate_date_tbl(i),
485: p_validation_id => PO_VAL_CONSTANTS.c_rate_date_null);
486: x_result_type := po_validations.c_result_type_failure;
487: END IF;
488: ELSE
489: -- currency is not functional

Line 502: p_validation_id => PO_VAL_CONSTANTS.c_rate_not_null);

498: p_token1_name => 'COLUMN_NAME',
499: p_token1_value => 'RATE',
500: p_token2_name => 'VALUE',
501: p_token2_value => p_rate_tbl(i),
502: p_validation_id => PO_VAL_CONSTANTS.c_rate_not_null);
503: x_result_type := po_validations.c_result_type_failure;
504: END IF;
505:
506: -- validate rate is positive

Line 517: p_validation_id => PO_VAL_CONSTANTS.c_rate_ge_zero);

513: p_token1_name => 'COLUMN_NAME',
514: p_token1_value => 'RATE',
515: p_token2_name => 'VALUE',
516: p_token2_value => p_rate_tbl(i),
517: p_validation_id => PO_VAL_CONSTANTS.c_rate_ge_zero);
518: x_result_type := po_validations.c_result_type_failure;
519: END IF;
520:
521: -- validate rate_type is not null if currency is functional

Line 532: p_validation_id => PO_VAL_CONSTANTS.c_rate_type_not_null);

528: p_token1_name => 'COLUMN_NAME',
529: p_token1_value => 'RATE_TYPE',
530: p_token2_name => 'VALUE',
531: p_token2_value => p_rate_type_tbl(i),
532: p_validation_id => PO_VAL_CONSTANTS.c_rate_type_not_null);
533: x_result_type := po_validations.c_result_type_failure;
534: END IF;
535:
536: -- validate rate against g1_currency_api.get_rate()

Line 557: p_validation_id => PO_VAL_CONSTANTS.c_rate_valid);

553: p_column_val => p_rate_tbl(i),
554: p_message_name => 'PO_PDOI_INVALID_RATE',
555: p_token1_name => 'VALUE',
556: p_token1_value => p_rate_tbl(i),
557: p_validation_id => PO_VAL_CONSTANTS.c_rate_valid);
558: x_result_type := po_validations.c_result_type_failure;
559: END IF;
560: END IF;
561: END IF;

Line 586: PO_VAL_CONSTANTS.c_rate_type_valid

582: 'RATE_TYPE',
583: p_rate_type_tbl(i),
584: 'VALUE',
585: p_rate_type_tbl(i),
586: PO_VAL_CONSTANTS.c_rate_type_valid
587: FROM DUAL
588: WHERE p_func_currency_code <> NVL(p_currency_code_tbl(i), ' ')
589: AND p_rate_type_tbl(i) IS NOT NULL
590: AND NOT EXISTS(SELECT 1

Line 661: DECODE(p_agent_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_agent_id_not_null,

657: 'COLUMN_NAME',
658: 'AGENT_ID',
659: 'VALUE',
660: p_agent_id_tbl(i),
661: DECODE(p_agent_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_agent_id_not_null,
662: PO_VAL_CONSTANTS.c_agent_id_valid)
663: FROM DUAL
664: WHERE p_agent_id_tbl(i) IS NULL
665: OR NOT EXISTS(

Line 662: PO_VAL_CONSTANTS.c_agent_id_valid)

658: 'AGENT_ID',
659: 'VALUE',
660: p_agent_id_tbl(i),
661: DECODE(p_agent_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_agent_id_not_null,
662: PO_VAL_CONSTANTS.c_agent_id_valid)
663: FROM DUAL
664: WHERE p_agent_id_tbl(i) IS NULL
665: OR NOT EXISTS(
666: SELECT 1

Line 766: DECODE(p_vendor_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_vendor_not_null,

762: 'COLUMN_NAME',
763: 'VENDOR_ID',
764: 'VALUE',
765: p_vendor_id_tbl(i),
766: DECODE(p_vendor_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_vendor_not_null,
767: PO_VAL_CONSTANTS.c_vendor_valid)
768: FROM DUAL
769: WHERE p_vendor_id_tbl(i) IS NULL
770: OR NOT EXISTS(SELECT 1

Line 767: PO_VAL_CONSTANTS.c_vendor_valid)

763: 'VENDOR_ID',
764: 'VALUE',
765: p_vendor_id_tbl(i),
766: DECODE(p_vendor_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_vendor_not_null,
767: PO_VAL_CONSTANTS.c_vendor_valid)
768: FROM DUAL
769: WHERE p_vendor_id_tbl(i) IS NULL
770: OR NOT EXISTS(SELECT 1
771: FROM po_suppliers_val_v psv

Line 803: DECODE(p_vendor_site_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_vendor_site_not_null,

799: 'COLUMN_NAME',
800: 'VENDOR_SITE_ID',
801: 'VALUE',
802: p_vendor_site_id_tbl(i),
803: DECODE(p_vendor_site_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_vendor_site_not_null,
804: PO_VAL_CONSTANTS.c_vendor_site_valid)
805: FROM DUAL
806: WHERE p_vendor_id_tbl(i) IS NOT NULL
807: AND ( p_vendor_site_id_tbl(i) IS NULL

Line 804: PO_VAL_CONSTANTS.c_vendor_site_valid)

800: 'VENDOR_SITE_ID',
801: 'VALUE',
802: p_vendor_site_id_tbl(i),
803: DECODE(p_vendor_site_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_vendor_site_not_null,
804: PO_VAL_CONSTANTS.c_vendor_site_valid)
805: FROM DUAL
806: WHERE p_vendor_id_tbl(i) IS NOT NULL
807: AND ( p_vendor_site_id_tbl(i) IS NULL
808: OR NOT EXISTS(SELECT 1

Line 838: PO_VAL_CONSTANTS.c_vendor_contact_valid

834: 'VENDOR_CONTACT_ID',
835: p_vendor_contact_id_tbl(i),
836: 'VALUE',
837: p_vendor_contact_id_tbl(i),
838: PO_VAL_CONSTANTS.c_vendor_contact_valid
839: FROM DUAL
840: WHERE p_vendor_id_tbl(i) IS NOT NULL
841: AND p_vendor_site_id_tbl(i) IS NOT NULL
842: AND p_vendor_contact_id_tbl(i) IS NOT NULL

Line 881: p_validation_id => PO_VAL_CONSTANTS.c_vendor_site_ccr_valid);

877: p_token1_name => 'VENDOR_SITE_ID',
878: p_token1_value => p_vendor_site_id_tbl(i),
879: p_token2_name => 'VENDOR_ID',
880: p_token2_value => p_vendor_id_tbl(i),
881: p_validation_id => PO_VAL_CONSTANTS.c_vendor_site_ccr_valid);
882: x_result_type := po_validations.c_result_type_failure;
883: END IF;
884: END;
885: END LOOP;

Line 954: DECODE(p_ship_to_location_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_ship_to_location_id_not_null,

950: 'COLUMN_NAME',
951: 'SHIP_TO_LOCATION_ID',
952: 'VALUE',
953: p_ship_to_location_id_tbl(i),
954: DECODE(p_ship_to_location_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_ship_to_location_id_not_null,
955: PO_VAL_CONSTANTS.c_ship_to_location_id_valid)
956: FROM DUAL
957: WHERE (p_ship_to_location_id_tbl(i) IS NULL
958: -- Bug 7007502: Allow bill_to_loc to be NULL for Quotations.

Line 955: PO_VAL_CONSTANTS.c_ship_to_location_id_valid)

951: 'SHIP_TO_LOCATION_ID',
952: 'VALUE',
953: p_ship_to_location_id_tbl(i),
954: DECODE(p_ship_to_location_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_ship_to_location_id_not_null,
955: PO_VAL_CONSTANTS.c_ship_to_location_id_valid)
956: FROM DUAL
957: WHERE (p_ship_to_location_id_tbl(i) IS NULL
958: -- Bug 7007502: Allow bill_to_loc to be NULL for Quotations.
959: AND p_type_lookup_code_tbl(i) <> 'QUOTATION')

Line 1037: DECODE(p_bill_to_location_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_bill_to_location_id_not_null,

1033: 'COLUMN_NAME',
1034: 'BILL_TO_LOCATION_ID',
1035: 'VALUE',
1036: p_bill_to_location_id_tbl(i),
1037: DECODE(p_bill_to_location_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_bill_to_location_id_not_null,
1038: PO_VAL_CONSTANTS.c_bill_to_location_id_valid)
1039: FROM DUAL
1040: WHERE (p_bill_to_location_id_tbl(i) IS NULL
1041: -- Bug 7007502: Allow bill_to_loc to be NULL for Quotations.

Line 1038: PO_VAL_CONSTANTS.c_bill_to_location_id_valid)

1034: 'BILL_TO_LOCATION_ID',
1035: 'VALUE',
1036: p_bill_to_location_id_tbl(i),
1037: DECODE(p_bill_to_location_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_bill_to_location_id_not_null,
1038: PO_VAL_CONSTANTS.c_bill_to_location_id_valid)
1039: FROM DUAL
1040: WHERE (p_bill_to_location_id_tbl(i) IS NULL
1041: -- Bug 7007502: Allow bill_to_loc to be NULL for Quotations.
1042: AND p_type_lookup_code_tbl(i) <> 'QUOTATION')

Line 1114: PO_VAL_CONSTANTS.c_ship_via_lookup_code

1110: 'SHIP_VIA_LOOKUP_CODE',
1111: p_ship_via_lookup_code_tbl(i),
1112: 'VALUE',
1113: p_ship_via_lookup_code_tbl(i),
1114: PO_VAL_CONSTANTS.c_ship_via_lookup_code
1115: FROM DUAL
1116: WHERE p_ship_via_lookup_code_tbl(i) IS NOT NULL
1117: AND NOT EXISTS(
1118: SELECT 1

Line 1185: PO_VAL_CONSTANTS.c_fob_lookup_code

1181: 'FOB_LOOKUP_CODE',
1182: p_fob_lookup_code_tbl(i),
1183: 'VALUE',
1184: p_fob_lookup_code_tbl(i),
1185: PO_VAL_CONSTANTS.c_fob_lookup_code
1186: FROM DUAL
1187: WHERE p_fob_lookup_code_tbl(i) IS NOT NULL
1188: AND NOT EXISTS(
1189: SELECT 1

Line 1256: PO_VAL_CONSTANTS.c_freight_terms_lookup_code

1252: 'FREIGHT_TERMS_LOOKUP_CODE',
1253: p_freight_terms_lookup_tbl(i),
1254: 'VALUE',
1255: p_freight_terms_lookup_tbl(i),
1256: PO_VAL_CONSTANTS.c_freight_terms_lookup_code
1257: FROM DUAL
1258: WHERE p_freight_terms_lookup_tbl(i) IS NOT NULL
1259: AND NOT EXISTS(
1260: SELECT 1

Line 1327: PO_VAL_CONSTANTS.c_shipping_control

1323: 'SHIPPING_CONTROL',
1324: p_shipping_control_tbl(i),
1325: 'VALUE',
1326: p_shipping_control_tbl(i),
1327: PO_VAL_CONSTANTS.c_shipping_control
1328: FROM DUAL
1329: WHERE p_shipping_control_tbl(i) IS NOT NULL
1330: AND NOT EXISTS(
1331: SELECT 1

Line 1393: p_validation_id => PO_VAL_CONSTANTS.c_acceptance_due_date);

1389: p_token1_name => 'COLUMN_NAME',
1390: p_token1_value => 'ACCEPTANCE_DUE_DATE',
1391: p_token2_name => 'VALUE',
1392: p_token2_value => p_acceptance_due_date_tbl(i),
1393: p_validation_id => PO_VAL_CONSTANTS.c_acceptance_due_date);
1394: x_result_type := po_validations.c_result_type_failure;
1395: END IF;
1396: END LOOP;*/
1397:

Line 1445: p_validation_id => PO_VAL_CONSTANTS.c_cancel_flag);

1441: p_token1_name => 'COLUMN_NAME',
1442: p_token1_value => 'CANCEL_FLAG',
1443: p_token2_name => 'VALUE',
1444: p_token2_value => p_cancel_flag_tbl(i),
1445: p_validation_id => PO_VAL_CONSTANTS.c_cancel_flag);
1446:
1447: x_result_type := po_validations.c_result_type_failure;
1448: END IF;
1449: END LOOP;

Line 1500: p_validation_id => PO_VAL_CONSTANTS.c_closed_code);

1496: p_token1_name => 'COLUMN_NAME',
1497: p_token1_value => 'CLOSED_CODE',
1498: p_token2_name => 'VALUE',
1499: p_token2_value => p_closed_code_tbl(i),
1500: p_validation_id => PO_VAL_CONSTANTS.c_closed_code);
1501:
1502: x_result_type := po_validations.c_result_type_failure;
1503: END IF;
1504: END LOOP;

Line 1555: p_validation_id => PO_VAL_CONSTANTS.c_print_count);

1551: p_token1_name => 'COLUMN_NAME',
1552: p_token1_value => 'PRINT COUNT',
1553: p_token2_name => 'VALUE',
1554: p_token2_value => 0,
1555: p_validation_id => PO_VAL_CONSTANTS.c_print_count);
1556: x_result_type := po_validations.c_result_type_failure;
1557: END IF;
1558: END LOOP;
1559:

Line 1604: p_validation_id => PO_VAL_CONSTANTS.c_approval_status);

1600: p_entity_id => p_id_tbl(i),
1601: p_column_name => 'APPROVAL_STATUS',
1602: p_column_val => p_approval_status_tbl(i),
1603: p_message_name => 'PO_PDOI_INVALID_STATUS',
1604: p_validation_id => PO_VAL_CONSTANTS.c_approval_status);
1605: x_result_type := po_validations.c_result_type_failure;
1606: END IF;
1607: END LOOP;
1608:

Line 1656: p_validation_id => PO_VAL_CONSTANTS.c_amount_to_encumber);

1652: p_token1_name => 'COLUMN_NAME',
1653: p_token1_value => 'AMOUNT_TO_ENCUMBER',
1654: p_token2_name => 'VALUE',
1655: p_token2_value => p_amount_to_encumber_tbl(i),
1656: p_validation_id => PO_VAL_CONSTANTS.c_amount_to_encumber);
1657: x_result_type := po_validations.c_result_type_failure;
1658: END IF;
1659: END LOOP;
1660:

Line 1719: PO_VAL_CONSTANTS.c_style_id_valid

1715: 'STYLE_ID',
1716: p_style_id_tbl(i),
1717: 'STYLE_ID',
1718: p_style_id_tbl(i),
1719: PO_VAL_CONSTANTS.c_style_id_valid
1720: FROM DUAL
1721: WHERE NOT EXISTS(SELECT 1
1722: FROM po_doc_style_headers pdsh
1723: WHERE pdsh.style_id = p_style_id_tbl(i) AND

Line 1752: PO_VAL_CONSTANTS.c_style_id_complex_work

1748: 'STYLE_ID',
1749: p_style_id_tbl(i),
1750: 'STYLE_ID',
1751: p_style_id_tbl(i),
1752: PO_VAL_CONSTANTS.c_style_id_complex_work
1753: FROM DUAL
1754: WHERE EXISTS(SELECT 1
1755: FROM po_doc_style_headers pdsh
1756: WHERE pdsh.style_id = p_style_id_tbl(i) AND

Line 1816: p_validation_id => PO_VAL_CONSTANTS.c_acceptance_required_flag

1812: p_token1_name => 'COLUMN_NAME',
1813: p_token1_value => 'ACCEPTANCE_REQUIRED_FLAG',
1814: p_token2_name => 'VALUE',
1815: p_token2_value => p_acceptance_required_flag_tbl(i),
1816: p_validation_id => PO_VAL_CONSTANTS.c_acceptance_required_flag
1817: );
1818:
1819: x_result_type := po_validations.c_result_type_failure;
1820: END IF;

Line 1832: p_validation_id => PO_VAL_CONSTANTS.c_acceptance_required_flag

1828: p_entity_id => p_id_tbl(i),
1829: p_column_name => 'ACCEPTANCE_REQUIRED_FLAG',
1830: p_column_val => p_acceptance_required_flag_tbl(i),
1831: p_message_name => 'PO_PDOI_INVALID_ACC_REQD_FLAG',
1832: p_validation_id => PO_VAL_CONSTANTS.c_acceptance_required_flag
1833: );
1834:
1835: x_result_type := po_validations.c_result_type_failure;
1836: END IF;

Line 1894: p_validation_id => PO_VAL_CONSTANTS.c_amount_limit_gt_zero,

1890: p_token1_name => 'COLUMN_NAME',
1891: p_token1_value => 'AMOUNT_LIMIT',
1892: p_token2_name => 'VALUE',
1893: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_amount_limit_tbl),
1894: p_validation_id => PO_VAL_CONSTANTS.c_amount_limit_gt_zero,
1895: x_results => x_results,
1896: x_result_type => x_result_type
1897: );
1898:

Line 1912: p_validation_id => PO_VAL_CONSTANTS.c_amount_agreed_not_null

1908: p_entity_id => p_id_tbl(i),
1909: p_column_name => 'AMOUNT_AGREED',
1910: p_column_val => p_amount_agreed_tbl(i),
1911: p_message_name => PO_MESSAGE_S.PO_AMT_LMT_NOT_NULL,
1912: p_validation_id => PO_VAL_CONSTANTS.c_amount_agreed_not_null
1913: );
1914:
1915:
1916: x_result_type := po_validations.c_result_type_failure;

Line 1927: p_validation_id => PO_VAL_CONSTANTS.c_amount_limit_gt_amt_agreed

1923: p_entity_id => p_id_tbl(i),
1924: p_column_name => 'AMOUNT_LIMIT',
1925: p_column_val => p_amount_limit_tbl(i),
1926: p_message_name => PO_MESSAGE_S.PO_PO_AMT_LIMIT_CK_FAILED,
1927: p_validation_id => PO_VAL_CONSTANTS.c_amount_limit_gt_amt_agreed
1928: );
1929:
1930: x_result_type := po_validations.c_result_type_failure;
1931: END IF;