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_VALIDATIONS

Line 3: c_entity_type_header CONSTANT VARCHAR2(30) := po_validations.c_entity_type_header;

1: PACKAGE BODY PO_VAL_HEADERS2 AS
2: -- $Header: PO_VAL_HEADERS2.plb 120.19.12010000.2 2008/08/04 08:41:02 rramasam ship $
3: c_entity_type_header CONSTANT VARCHAR2(30) := po_validations.c_entity_type_header;
4: -- The module base for this package.
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_HEADERS2');
6:
7: -- The module base for the subprogram.

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

41: IS
42: d_mod CONSTANT VARCHAR2(100) := d_po_header_id;
43: BEGIN
44: IF x_result_set_id IS NULL THEN
45: x_result_set_id := po_validations.next_result_set_id();
46: END IF;
47:
48: IF po_log.d_proc THEN
49: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 54: x_result_type := po_validations.c_result_type_success;

50: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
51: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
52: END IF;
53:
54: x_result_type := po_validations.c_result_type_success;
55: FORALL i IN 1 .. p_id_tbl.COUNT
56: INSERT INTO po_validation_results_gt
57: (result_set_id,
58: result_type,

Line 70: po_validations.c_result_type_failure,

66: token2_name,
67: token2_value,
68: validation_id)
69: SELECT x_result_set_id,
70: po_validations.c_result_type_failure,
71: c_entity_type_header,
72: p_id_tbl(i),
73: DECODE(p_po_header_id_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_PO_HDR_ID_UNIQUE'),
74: 'PO_HEADER_ID',

Line 88: x_result_type := po_validations.c_result_type_failure;

84: FROM po_headers_all poh
85: WHERE p_po_header_id_tbl(i) = poh.po_header_id);
86:
87: IF (SQL%ROWCOUNT > 0) THEN
88: x_result_type := po_validations.c_result_type_failure;
89: END IF;
90:
91: IF po_log.d_proc THEN
92: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

88: x_result_type := po_validations.c_result_type_failure;
89: END IF;
90:
91: IF po_log.d_proc THEN
92: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
93: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
94: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
95: END IF;
96: EXCEPTION

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

119: d_mod CONSTANT VARCHAR2(100) := d_document_num;
120: l_num_test NUMBER;
121: BEGIN
122: IF x_result_set_id IS NULL THEN
123: x_result_set_id := po_validations.next_result_set_id();
124: END IF;
125:
126: IF (x_results IS NULL) THEN
127: x_results := po_validation_results_type.new_instance();

Line 140: x_result_type := po_validations.c_result_type_success;

136: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
137: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
138: END IF;
139:
140: x_result_type := po_validations.c_result_type_success;
141: -- Bulk validate document_num uniqueness
142: FORALL i IN 1 .. p_id_tbl.COUNT
143: INSERT INTO po_validation_results_gt
144: (result_set_id,

Line 155: po_validations.c_result_type_failure,

151: token1_name,
152: token1_value,
153: validation_id)
154: SELECT x_result_set_id,
155: po_validations.c_result_type_failure,
156: c_entity_type_header,
157: p_id_tbl(i),
158: 'PO_PDOI_DOC_NUM_UNIQUE',
159: 'DOCUMENT_NUM',

Line 178: x_result_type := po_validations.c_result_type_failure;

174: (p_type_lookup_code_tbl(i) = 'QUOTATION' AND
175: type_lookup_code = p_type_lookup_code_tbl(i))));
176:
177: IF (SQL%ROWCOUNT > 0) THEN
178: x_result_type := po_validations.c_result_type_failure;
179: END IF;
180:
181: FOR i IN 1 .. p_id_tbl.COUNT LOOP
182: IF p_document_num_tbl(i) IS NULL THEN

Line 194: x_result_type := po_validations.c_result_type_failure; -- bug5101044

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')
197: OR
198: (p_type_lookup_code_tbl(i) = 'QUOTATION'

Line 219: x_result_type := po_validations.c_result_type_failure;

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
223: WHEN VALUE_ERROR THEN

Line 235: x_result_type := po_validations.c_result_type_failure;

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;
239:

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

237: END IF;
238: END LOOP;
239:
240: IF po_log.d_proc THEN
241: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
242: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
243: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
244: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
245: END IF;

Line 278: x_result_type := po_validations.c_result_type_success;

274: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
275: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
276: END IF;
277:
278: x_result_type := po_validations.c_result_type_success;
279:
280: FOR i IN 1 .. p_id_tbl.COUNT LOOP
281: IF p_type_lookup_code_tbl(i) IS NULL THEN
282: x_results.add_result(p_entity_type => c_entity_type_header,

Line 292: x_result_type := po_validations.c_result_type_failure;

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),
296: p_column_name => 'TYPE_LOOKUP_CODE',

Line 302: x_result_type := po_validations.c_result_type_failure;

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:
306: IF po_log.d_proc THEN

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

327: IS
328: d_mod CONSTANT VARCHAR2(100) := d_currency_code;
329: BEGIN
330: IF x_result_set_id IS NULL THEN
331: x_result_set_id := po_validations.next_result_set_id();
332: END IF;
333:
334: IF po_log.d_proc THEN
335: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 340: x_result_type := po_validations.c_result_type_success;

336: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
337: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
338: END IF;
339:
340: x_result_type := po_validations.c_result_type_success;
341: -- Bulk validate currency_code not null and against FND_CURRENCIES
342: FORALL i IN 1 .. p_id_tbl.COUNT
343: INSERT INTO po_validation_results_gt
344: (result_set_id,

Line 357: po_validations.c_result_type_failure,

353: token2_name,
354: token2_value,
355: validation_id)
356: SELECT x_result_set_id,
357: po_validations.c_result_type_failure,
358: c_entity_type_header,
359: p_id_tbl(i),
360: DECODE(p_currency_code_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_CURRENCY'),
361: 'CURRENCY_CODE',

Line 380: x_result_type := po_validations.c_result_type_failure;

376: AND SYSDATE BETWEEN NVL(cur.start_date_active, SYSDATE - 1)
377: AND NVL(cur.end_date_active, SYSDATE + 1));
378:
379: IF (SQL%ROWCOUNT > 0) THEN
380: x_result_type := po_validations.c_result_type_failure;
381: END IF;
382:
383: IF po_log.d_proc THEN
384: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

380: x_result_type := po_validations.c_result_type_failure;
381: END IF;
382:
383: IF po_log.d_proc THEN
384: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
385: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
386: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
387: END IF;
388: EXCEPTION

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

415: d_mod CONSTANT VARCHAR2(100) := d_rate_info;
416: x_rate NUMBER;
417: BEGIN
418: IF x_result_set_id IS NULL THEN
419: x_result_set_id := po_validations.next_result_set_id();
420: END IF;
421:
422: IF (x_results IS NULL) THEN
423: x_results := po_validation_results_type.new_instance();

Line 438: x_result_type := po_validations.c_result_type_success;

434: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
435: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
436: END IF;
437:
438: x_result_type := po_validations.c_result_type_success;
439:
440: FOR i IN 1 .. p_id_tbl.COUNT LOOP
441:
442: -- check if currency is equal to functional currency

Line 456: x_result_type := po_validations.c_result_type_failure;

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
460: IF p_rate_type_tbl(i) IS NOT NULL THEN

Line 471: x_result_type := po_validations.c_result_type_failure;

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
475: IF p_rate_date_tbl(i) IS NOT NULL THEN

Line 486: x_result_type := po_validations.c_result_type_failure;

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
490:

Line 503: x_result_type := po_validations.c_result_type_failure;

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
507: IF NVL(p_rate_tbl(i), 1) < 0 THEN

Line 518: x_result_type := po_validations.c_result_type_failure;

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
522: IF p_rate_type_tbl(i) IS NULL THEN

Line 533: x_result_type := po_validations.c_result_type_failure;

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()
537: IF p_rate_type_tbl(i) IS NOT NULL AND

Line 558: x_result_type := po_validations.c_result_type_failure;

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;
562: END LOOP;

Line 578: po_validations.c_result_type_failure,

574: token1_name,
575: token1_value,
576: validation_id)
577: SELECT x_result_set_id,
578: po_validations.c_result_type_failure,
579: c_entity_type_header,
580: p_id_tbl(i),
581: 'PO_PDOI_INVALID_RATE_TYPE',
582: 'RATE_TYPE',

Line 595: x_result_type := po_validations.c_result_type_failure;

591: FROM gl_daily_conversion_types_v dct
592: WHERE p_rate_type_tbl(i) = dct.conversion_type);
593:
594: IF (SQL%ROWCOUNT > 0) THEN
595: x_result_type := po_validations.c_result_type_failure;
596: END IF;
597:
598: IF po_log.d_proc THEN
599: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

595: x_result_type := po_validations.c_result_type_failure;
596: END IF;
597:
598: IF po_log.d_proc THEN
599: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
600: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
601: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
602: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
603: END IF;

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

621: IS
622: d_mod CONSTANT VARCHAR2(100) := d_agent_id;
623: BEGIN
624: IF x_result_set_id IS NULL THEN
625: x_result_set_id := po_validations.next_result_set_id();
626: END IF;
627:
628: IF po_log.d_proc THEN
629: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 634: x_result_type := po_validations.c_result_type_success;

630: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
631: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
632: END IF;
633:
634: x_result_type := po_validations.c_result_type_success;
635: -- validate agent_id against PO_AGENTS
636: FORALL i IN 1 .. p_id_tbl.COUNT
637: INSERT INTO po_validation_results_gt
638: (result_set_id,

Line 651: po_validations.c_result_type_failure,

647: token2_name,
648: token2_value,
649: validation_id)
650: SELECT x_result_set_id,
651: po_validations.c_result_type_failure,
652: c_entity_type_header,
653: p_id_tbl(i),
654: DECODE(p_agent_id_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_BUYER'),
655: 'AGENT_ID',

Line 673: x_result_type := po_validations.c_result_type_failure;

669: AND SYSDATE BETWEEN NVL(poa.start_date_active, SYSDATE - 1)
670: AND NVL(poa.end_date_active, SYSDATE + 1));
671:
672: IF (SQL%ROWCOUNT > 0) THEN
673: x_result_type := po_validations.c_result_type_failure;
674: END IF;
675:
676: IF po_log.d_proc THEN
677: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

673: x_result_type := po_validations.c_result_type_failure;
674: END IF;
675:
676: IF po_log.d_proc THEN
677: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
678: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
679: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
680: END IF;
681: EXCEPTION

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

720: -- is exempt from CCR
721: g_site_not_ccr_site CONSTANT NUMBER := 2;
722: BEGIN
723: IF x_result_set_id IS NULL THEN
724: x_result_set_id := po_validations.next_result_set_id();
725: END IF;
726:
727: IF (x_results IS NULL) THEN
728: x_results := po_validation_results_type.new_instance();

Line 740: x_result_type := po_validations.c_result_type_success;

736: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
737: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
738: END IF;
739:
740: x_result_type := po_validations.c_result_type_success;
741: FORALL i IN 1 .. p_id_tbl.COUNT
742: INSERT INTO po_validation_results_gt
743: (result_set_id,
744: result_type,

Line 756: po_validations.c_result_type_failure,

752: token2_name,
753: token2_value,
754: validation_id)
755: SELECT x_result_set_id,
756: po_validations.c_result_type_failure,
757: c_entity_type_header,
758: p_id_tbl(i),
759: DECODE(p_vendor_id_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_VENDOR'),
760: 'VENDOR_ID',

Line 775: x_result_type := po_validations.c_result_type_failure;

771: FROM po_suppliers_val_v psv
772: WHERE p_vendor_id_tbl(i) = psv.vendor_id);
773:
774: IF (SQL%ROWCOUNT > 0) THEN
775: x_result_type := po_validations.c_result_type_failure;
776: END IF;
777:
778: FORALL i IN 1 .. p_id_tbl.COUNT
779: INSERT INTO po_validation_results_gt

Line 793: po_validations.c_result_type_failure,

789: token2_name,
790: token2_value,
791: validation_id)
792: SELECT x_result_set_id,
793: po_validations.c_result_type_failure,
794: c_entity_type_header,
795: p_id_tbl(i),
796: DECODE(p_vendor_site_id_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_VENDOR_SITE'),
797: 'VENDOR_SITE_ID',

Line 814: x_result_type := po_validations.c_result_type_failure;

810: WHERE p_vendor_id_tbl(i) = pssv.vendor_id
811: AND p_vendor_site_id_tbl(i) = pssv.vendor_site_id));
812:
813: IF (SQL%ROWCOUNT > 0) THEN
814: x_result_type := po_validations.c_result_type_failure;
815: END IF;
816:
817: FORALL i IN 1 .. p_id_tbl.COUNT
818: INSERT INTO po_validation_results_gt

Line 830: po_validations.c_result_type_failure,

826: token1_name,
827: token1_value,
828: validation_id)
829: SELECT x_result_set_id,
830: po_validations.c_result_type_failure,
831: c_entity_type_header,
832: p_id_tbl(i),
833: 'PO_PDOI_INVALID_VDR_CNTCT',
834: 'VENDOR_CONTACT_ID',

Line 849: x_result_type := po_validations.c_result_type_failure;

845: WHERE p_vendor_site_id_tbl(i) = pvc.vendor_site_id
846: AND p_vendor_contact_id_tbl(i) = pvc.vendor_contact_id);
847:
848: IF (SQL%ROWCOUNT > 0) THEN
849: x_result_type := po_validations.c_result_type_failure;
850: END IF;
851:
852: IF (p_federal_instance = 'Y') THEN
853: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 882: x_result_type := po_validations.c_result_type_failure;

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;
886: END IF;

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

885: END LOOP;
886: END IF;
887:
888: IF po_log.d_proc THEN
889: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
890: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
891: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
892: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
893: END IF;

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

913: IS
914: d_mod CONSTANT VARCHAR2(100) := d_ship_to_location_id;
915: BEGIN
916: IF x_result_set_id IS NULL THEN
917: x_result_set_id := po_validations.next_result_set_id();
918: END IF;
919:
920: IF po_log.d_proc THEN
921: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 927: x_result_type := po_validations.c_result_type_success;

923: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
924: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
925: END IF;
926:
927: x_result_type := po_validations.c_result_type_success;
928: -- validate ship_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
929: FORALL i IN 1 .. p_id_tbl.COUNT
930: INSERT INTO po_validation_results_gt
931: (result_set_id,

Line 944: po_validations.c_result_type_failure,

940: token2_name,
941: token2_value,
942: validation_id)
943: SELECT x_result_set_id,
944: po_validations.c_result_type_failure,
945: c_entity_type_header,
946: p_id_tbl(i),
947: DECODE(p_ship_to_location_id_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_SHIP_LOC_ID'),
948: 'SHIP_TO_LOCATION_ID',

Line 969: x_result_type := po_validations.c_result_type_failure;

965: AND p_ship_to_location_id_tbl(i) = hrl.location_id
966: AND SYSDATE < NVL(hrl.inactive_date, SYSDATE + 1)));
967:
968: IF (SQL%ROWCOUNT > 0) THEN
969: x_result_type := po_validations.c_result_type_failure;
970: END IF;
971:
972: IF po_log.d_proc THEN
973: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

969: x_result_type := po_validations.c_result_type_failure;
970: END IF;
971:
972: IF po_log.d_proc THEN
973: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
974: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
975: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
976: END IF;
977: EXCEPTION

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

996: IS
997: d_mod CONSTANT VARCHAR2(100) := d_bill_to_location_id;
998: BEGIN
999: IF x_result_set_id IS NULL THEN
1000: x_result_set_id := po_validations.next_result_set_id();
1001: END IF;
1002:
1003: IF po_log.d_proc THEN
1004: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1010: x_result_type := po_validations.c_result_type_success;

1006: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1007: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1008: END IF;
1009:
1010: x_result_type := po_validations.c_result_type_success;
1011: -- validate bill_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
1012: FORALL i IN 1 .. p_id_tbl.COUNT
1013: INSERT INTO po_validation_results_gt
1014: (result_set_id,

Line 1027: po_validations.c_result_type_failure,

1023: token2_name,
1024: token2_value,
1025: validation_id)
1026: SELECT x_result_set_id,
1027: po_validations.c_result_type_failure,
1028: c_entity_type_header,
1029: p_id_tbl(i),
1030: DECODE(p_bill_to_location_id_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_BILL_LOC_ID'),
1031: 'BILL_TO_LOCATION_ID',

Line 1052: x_result_type := po_validations.c_result_type_failure;

1048: AND p_bill_to_location_id_tbl(i) = hrl.location_id
1049: AND SYSDATE < NVL(hrl.inactive_date, SYSDATE + 1)));
1050:
1051: IF (SQL%ROWCOUNT > 0) THEN
1052: x_result_type := po_validations.c_result_type_failure;
1053: END IF;
1054:
1055: IF po_log.d_proc THEN
1056: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1052: x_result_type := po_validations.c_result_type_failure;
1053: END IF;
1054:
1055: IF po_log.d_proc THEN
1056: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1057: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1058: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1059: END IF;
1060: EXCEPTION

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

1078: IS
1079: d_mod CONSTANT VARCHAR2(100) := d_ship_via_lookup_code;
1080: BEGIN
1081: IF x_result_set_id IS NULL THEN
1082: x_result_set_id := po_validations.next_result_set_id();
1083: END IF;
1084:
1085: IF po_log.d_proc THEN
1086: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1092: x_result_type := po_validations.c_result_type_success;

1088: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1089: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1090: END IF;
1091:
1092: x_result_type := po_validations.c_result_type_success;
1093: FORALL i IN 1 .. p_id_tbl.COUNT
1094: INSERT INTO po_validation_results_gt
1095: (result_set_id,
1096: result_type,

Line 1106: po_validations.c_result_type_failure,

1102: token1_name,
1103: token1_value,
1104: validation_id)
1105: SELECT x_result_set_id,
1106: po_validations.c_result_type_failure,
1107: c_entity_type_header,
1108: p_id_tbl(i),
1109: 'PO_PDOI_INVALID_FREIGHT_CARR',
1110: 'SHIP_VIA_LOOKUP_CODE',

Line 1125: x_result_type := po_validations.c_result_type_failure;

1121: AND NVL(ofr.disable_date, SYSDATE + 1) > SYSDATE
1122: AND ofr.organization_id = p_inventory_org_id);
1123:
1124: IF (SQL%ROWCOUNT > 0) THEN
1125: x_result_type := po_validations.c_result_type_failure;
1126: END IF;
1127:
1128: IF po_log.d_proc THEN
1129: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1125: x_result_type := po_validations.c_result_type_failure;
1126: END IF;
1127:
1128: IF po_log.d_proc THEN
1129: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1130: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1131: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1132: END IF;
1133: EXCEPTION

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

1150: IS
1151: d_mod CONSTANT VARCHAR2(100) := d_fob_lookup_code;
1152: BEGIN
1153: IF (x_result_set_id IS NULL) THEN
1154: x_result_set_id := po_validations.next_result_set_id();
1155: END IF;
1156:
1157: IF po_log.d_proc THEN
1158: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1163: x_result_type := po_validations.c_result_type_success;

1159: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1160: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1161: END IF;
1162:
1163: x_result_type := po_validations.c_result_type_success;
1164: FORALL i IN 1 .. p_id_tbl.COUNT
1165: INSERT INTO po_validation_results_gt
1166: (result_set_id,
1167: result_type,

Line 1177: po_validations.c_result_type_failure,

1173: token1_name,
1174: token1_value,
1175: validation_id)
1176: SELECT x_result_set_id,
1177: po_validations.c_result_type_failure,
1178: c_entity_type_header,
1179: p_id_tbl(i),
1180: 'PO_PDOI_INVALID_FOB',
1181: 'FOB_LOOKUP_CODE',

Line 1196: x_result_type := po_validations.c_result_type_failure;

1192: AND plc.lookup_type = 'FOB'
1193: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1194:
1195: IF (SQL%ROWCOUNT > 0) THEN
1196: x_result_type := po_validations.c_result_type_failure;
1197: END IF;
1198:
1199: IF po_log.d_proc THEN
1200: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1196: x_result_type := po_validations.c_result_type_failure;
1197: END IF;
1198:
1199: IF po_log.d_proc THEN
1200: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1201: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1202: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1203: END IF;
1204: EXCEPTION

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

1221: IS
1222: d_mod CONSTANT VARCHAR2(100) := d_freight_terms_lookup_code;
1223: BEGIN
1224: IF (x_result_set_id IS NULL) THEN
1225: x_result_set_id := po_validations.next_result_set_id();
1226: END IF;
1227:
1228: IF po_log.d_proc THEN
1229: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1234: x_result_type := po_validations.c_result_type_success;

1230: po_log.proc_begin(d_mod, 'p_freight_terms_lookup_tbl', p_freight_terms_lookup_tbl);
1231: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1232: END IF;
1233:
1234: x_result_type := po_validations.c_result_type_success;
1235: FORALL i IN 1 .. p_id_tbl.COUNT
1236: INSERT INTO po_validation_results_gt
1237: (result_set_id,
1238: result_type,

Line 1248: po_validations.c_result_type_failure,

1244: token1_name,
1245: token1_value,
1246: validation_id)
1247: SELECT x_result_set_id,
1248: po_validations.c_result_type_failure,
1249: c_entity_type_header,
1250: p_id_tbl(i),
1251: 'PO_PDOI_INVALID_FREIGHT_TERMS',
1252: 'FREIGHT_TERMS_LOOKUP_CODE',

Line 1267: x_result_type := po_validations.c_result_type_failure;

1263: AND plc.lookup_type = 'FREIGHT TERMS'
1264: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1265:
1266: IF (SQL%ROWCOUNT > 0) THEN
1267: x_result_type := po_validations.c_result_type_failure;
1268: END IF;
1269:
1270: IF po_log.d_proc THEN
1271: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1267: x_result_type := po_validations.c_result_type_failure;
1268: END IF;
1269:
1270: IF po_log.d_proc THEN
1271: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1272: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1273: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1274: END IF;
1275: EXCEPTION

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

1292: IS
1293: d_mod CONSTANT VARCHAR2(100) := d_shipping_control;
1294: BEGIN
1295: IF (x_result_set_id IS NULL) THEN
1296: x_result_set_id := po_validations.next_result_set_id();
1297: END IF;
1298:
1299: IF po_log.d_proc THEN
1300: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1305: x_result_type := po_validations.c_result_type_success;

1301: po_log.proc_begin(d_mod, 'p_shipping_control_tbl', p_shipping_control_tbl);
1302: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1303: END IF;
1304:
1305: x_result_type := po_validations.c_result_type_success;
1306: FORALL i IN 1 .. p_id_tbl.COUNT
1307: INSERT INTO po_validation_results_gt
1308: (result_set_id,
1309: result_type,

Line 1319: po_validations.c_result_type_failure,

1315: token1_name,
1316: token1_value,
1317: validation_id)
1318: SELECT x_result_set_id,
1319: po_validations.c_result_type_failure,
1320: c_entity_type_header,
1321: p_id_tbl(i),
1322: 'PO_PDOI_INVALID_SHIPPING_CTRL',
1323: 'SHIPPING_CONTROL',

Line 1338: x_result_type := po_validations.c_result_type_failure;

1334: AND plc.lookup_type = 'SHIPPING CONTROL'
1335: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1336:
1337: IF (SQL%ROWCOUNT > 0) THEN
1338: x_result_type := po_validations.c_result_type_failure;
1339: END IF;
1340:
1341: IF po_log.d_proc THEN
1342: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1338: x_result_type := po_validations.c_result_type_failure;
1339: END IF;
1340:
1341: IF po_log.d_proc THEN
1342: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1343: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1344: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1345: END IF;
1346: EXCEPTION

Line 1379: x_result_type := po_validations.c_result_type_success;

1375: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1376: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1377: END IF;
1378:
1379: x_result_type := po_validations.c_result_type_success;
1380:
1381: -- Bug6601134(obsoleted 4467491)
1382: /*FOR i IN 1 .. p_id_tbl.COUNT LOOP
1383: IF p_acceptance_reqd_flag_tbl(i) = 'Y' AND p_acceptance_due_date_tbl(i) IS NULL THEN

Line 1394: x_result_type := po_validations.c_result_type_failure;

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:
1398: IF po_log.d_proc THEN

Line 1432: x_result_type := po_validations.c_result_type_success;

1428: po_log.proc_begin(d_mod, 'p_cancel_flag_tbl', p_cancel_flag_tbl);
1429: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1430: END IF;
1431:
1432: x_result_type := po_validations.c_result_type_success;
1433:
1434: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1435: IF p_cancel_flag_tbl(i) <> 'N' THEN
1436: x_results.add_result(p_entity_type => c_entity_type_header,

Line 1447: x_result_type := po_validations.c_result_type_failure;

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;
1450:
1451: IF po_log.d_proc THEN

Line 1487: x_result_type := po_validations.c_result_type_success;

1483: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1484: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1485: END IF;
1486:
1487: x_result_type := po_validations.c_result_type_success;
1488:
1489: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1490: IF p_acceptance_reqd_flag_tbl(i) ='Y' AND p_closed_code_tbl(i) <> 'OPEN' THEN
1491: x_results.add_result(p_entity_type => c_entity_type_header,

Line 1502: x_result_type := po_validations.c_result_type_failure;

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;
1505:
1506: IF po_log.d_proc THEN

Line 1542: x_result_type := po_validations.c_result_type_success;

1538: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1539: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1540: END IF;
1541:
1542: x_result_type := po_validations.c_result_type_success;
1543:
1544: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1545: IF p_approval_status_tbl(i) <> 'APPROVED' AND p_print_count_tbl(i) <> 0 THEN
1546: x_results.add_result(p_entity_type => c_entity_type_header,

Line 1556: x_result_type := po_validations.c_result_type_failure;

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:
1560: IF po_log.d_proc THEN

Line 1595: x_result_type := po_validations.c_result_type_success;

1591: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1592: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1593: END IF;
1594:
1595: x_result_type := po_validations.c_result_type_success;
1596:
1597: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1598: IF p_approval_status_tbl(i) NOT IN('APPROVED', 'INCOMPLETE', 'INITIATE APPROVAL') THEN
1599: x_results.add_result(p_entity_type => c_entity_type_header,

Line 1605: x_result_type := po_validations.c_result_type_failure;

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:
1609: IF po_log.d_proc THEN

Line 1643: x_result_type := po_validations.c_result_type_success;

1639: po_log.proc_begin(d_mod, 'p_amount_to_encumber_tbl', p_amount_to_encumber_tbl);
1640: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1641: END IF;
1642:
1643: x_result_type := po_validations.c_result_type_success;
1644:
1645: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1646: IF p_amount_to_encumber_tbl(i) <= 0 THEN
1647: x_results.add_result(p_entity_type => c_entity_type_header,

Line 1657: x_result_type := po_validations.c_result_type_failure;

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:
1661: IF po_log.d_proc THEN

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

1682: IS
1683: d_mod CONSTANT VARCHAR2(100) := d_style_id;
1684: BEGIN
1685: IF x_result_set_id IS NULL THEN
1686: x_result_set_id := po_validations.next_result_set_id();
1687: END IF;
1688:
1689: IF po_log.d_proc THEN
1690: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1695: x_result_type := po_validations.c_result_type_success;

1691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1692: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1693: END IF;
1694:
1695: x_result_type := po_validations.c_result_type_success;
1696:
1697: -- validate that the style_id exists in the system and the status is ACTIVE.
1698: FORALL i IN 1 .. p_id_tbl.COUNT
1699: INSERT INTO po_validation_results_gt

Line 1711: po_validations.c_result_type_failure,

1707: token1_name,
1708: token1_value,
1709: validation_id)
1710: SELECT x_result_set_id,
1711: po_validations.c_result_type_failure,
1712: c_entity_type_header,
1713: p_id_tbl(i),
1714: 'PO_PDOI_INVALID_STYLE_ID',
1715: 'STYLE_ID',

Line 1727: x_result_type := po_validations.c_result_type_failure;

1723: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1724: pdsh.status = 'ACTIVE');
1725:
1726: IF (SQL%ROWCOUNT > 0) THEN
1727: x_result_type := po_validations.c_result_type_failure;
1728: END IF;
1729:
1730: -- validate that complex work is not enabled
1731: FORALL i IN 1 .. p_id_tbl.COUNT

Line 1744: po_validations.c_result_type_failure,

1740: token1_name,
1741: token1_value,
1742: validation_id)
1743: SELECT x_result_set_id,
1744: po_validations.c_result_type_failure,
1745: c_entity_type_header,
1746: p_id_tbl(i),
1747: 'PO_PDOI_COMPLEX_WORK_STYLE',
1748: 'STYLE_ID',

Line 1760: x_result_type := po_validations.c_result_type_failure;

1756: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1757: pdsh.progress_payment_flag = 'Y');
1758:
1759: IF (SQL%ROWCOUNT > 0) THEN
1760: x_result_type := po_validations.c_result_type_failure;
1761: END IF;
1762:
1763: IF po_log.d_proc THEN
1764: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1760: x_result_type := po_validations.c_result_type_failure;
1761: END IF;
1762:
1763: IF po_log.d_proc THEN
1764: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1765: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1766: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1767: END IF;
1768:

Line 1798: x_result_type := po_validations.c_result_type_success;

1794: IF (x_results IS NULL) THEN
1795: x_results := po_validation_results_type.new_instance();
1796: END IF;
1797:
1798: x_result_type := po_validations.c_result_type_success;
1799:
1800: FOR i IN 1..p_id_tbl.COUNT LOOP
1801:
1802: IF (p_type_lookup_code_tbl(i) = 'QUOTATION') THEN

Line 1819: x_result_type := po_validations.c_result_type_failure;

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;
1821:
1822: ELSE
1823:

Line 1835: x_result_type := po_validations.c_result_type_failure;

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;
1837: END IF;
1838:
1839: END LOOP;

Line 1878: x_result_type := po_validations.c_result_type_success;

1874: IF (x_results IS NULL) THEN
1875: x_results := po_validation_results_type.new_instance();
1876: END IF;
1877:
1878: x_result_type := po_validations.c_result_type_success;
1879:
1880:
1881:
1882: PO_VALIDATION_HELPER.greater_or_equal_zero

Line 1916: x_result_type := po_validations.c_result_type_failure;

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;
1917: END IF;
1918:
1919: IF ( p_amount_limit_tbl(i) < p_amount_agreed_tbl(i) ) THEN
1920:

Line 1930: x_result_type := po_validations.c_result_type_failure;

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;
1932:
1933: END LOOP;
1934: