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.26.12020000.2 2013/02/10 17:42:21 vegajula 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 185: x_result_type := po_validations.c_result_type_failure;

181: (p_type_lookup_code_tbl(i) = 'QUOTATION' AND
182: type_lookup_code = p_type_lookup_code_tbl(i)))));
183:
184: IF (SQL%ROWCOUNT > 0) THEN
185: x_result_type := po_validations.c_result_type_failure;
186: END IF;
187:
188: FOR i IN 1 .. p_id_tbl.COUNT LOOP
189: IF p_document_num_tbl(i) IS NULL THEN

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

197: p_token2_name => 'VALUE',
198: p_token2_value => p_document_num_tbl(i),
199: p_validation_id => PO_VAL_CONSTANTS.c_document_num_not_null);
200:
201: x_result_type := po_validations.c_result_type_failure; -- bug5101044
202: ELSIF ((p_type_lookup_code_tbl(i) IN ('BLANKET', 'STANDARD')
203: AND p_manual_po_num_type = 'NUMERIC')
204: OR
205: (p_type_lookup_code_tbl(i) = 'QUOTATION'

Line 226: x_result_type := po_validations.c_result_type_failure;

222: p_token1_value => 'DOCUMENT_NUM',
223: p_token2_name => 'VALUE',
224: p_token2_value => p_document_num_tbl(i),
225: p_validation_id => PO_VAL_CONSTANTS.c_document_num_ge_zero);
226: x_result_type := po_validations.c_result_type_failure;
227: END IF;
228:
229: EXCEPTION
230: WHEN VALUE_ERROR THEN

Line 242: x_result_type := po_validations.c_result_type_failure;

238: p_token1_value => 'DOCUMENT_NUM',
239: p_token2_name => 'VALUE',
240: p_token2_value => p_document_num_tbl(i),
241: p_validation_id => PO_VAL_CONSTANTS.c_document_num_valid);
242: x_result_type := po_validations.c_result_type_failure;
243: END;
244: END IF;
245: END LOOP;
246:

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

244: END IF;
245: END LOOP;
246:
247: IF po_log.d_proc THEN
248: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
249: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
250: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
251: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
252: END IF;

Line 285: x_result_type := po_validations.c_result_type_success;

281: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
282: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
283: END IF;
284:
285: x_result_type := po_validations.c_result_type_success;
286:
287: FOR i IN 1 .. p_id_tbl.COUNT LOOP
288: IF p_type_lookup_code_tbl(i) IS NULL THEN
289: x_results.add_result(p_entity_type => c_entity_type_header,

Line 299: x_result_type := po_validations.c_result_type_failure;

295: p_token1_value => 'TYPE_LOOKUP_CODE',
296: p_token2_name => 'VALUE',
297: p_token2_value => p_type_lookup_code_tbl(i),
298: p_validation_id => PO_VAL_CONSTANTS.c_type_lookup_code_not_null);
299: x_result_type := po_validations.c_result_type_failure;
300: ELSIF p_type_lookup_code_tbl(i) NOT IN('BLANKET', 'STANDARD', 'QUOTATION') THEN
301: x_results.add_result(p_entity_type => c_entity_type_header,
302: p_entity_id => p_id_tbl(i),
303: p_column_name => 'TYPE_LOOKUP_CODE',

Line 309: x_result_type := po_validations.c_result_type_failure;

305: p_message_name => 'PO_PDOI_INVALID_TYPE_LKUP_CD',
306: p_token1_name => 'VALUE',
307: p_token1_value => p_type_lookup_code_tbl(i),
308: p_validation_id => PO_VAL_CONSTANTS.c_type_lookup_code_valid);
309: x_result_type := po_validations.c_result_type_failure;
310: END IF;
311: END LOOP;
312:
313: IF po_log.d_proc THEN

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

334: IS
335: d_mod CONSTANT VARCHAR2(100) := d_currency_code;
336: BEGIN
337: IF x_result_set_id IS NULL THEN
338: x_result_set_id := po_validations.next_result_set_id();
339: END IF;
340:
341: IF po_log.d_proc THEN
342: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 347: x_result_type := po_validations.c_result_type_success;

343: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
344: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
345: END IF;
346:
347: x_result_type := po_validations.c_result_type_success;
348: -- Bulk validate currency_code not null and against FND_CURRENCIES
349: FORALL i IN 1 .. p_id_tbl.COUNT
350: INSERT INTO po_validation_results_gt
351: (result_set_id,

Line 364: po_validations.c_result_type_failure,

360: token2_name,
361: token2_value,
362: validation_id)
363: SELECT x_result_set_id,
364: po_validations.c_result_type_failure,
365: c_entity_type_header,
366: p_id_tbl(i),
367: DECODE(p_currency_code_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_CURRENCY'),
368: 'CURRENCY_CODE',

Line 387: x_result_type := po_validations.c_result_type_failure;

383: AND SYSDATE BETWEEN NVL(cur.start_date_active, SYSDATE - 1)
384: AND NVL(cur.end_date_active, SYSDATE + 1));
385:
386: IF (SQL%ROWCOUNT > 0) THEN
387: x_result_type := po_validations.c_result_type_failure;
388: END IF;
389:
390: IF po_log.d_proc THEN
391: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

387: x_result_type := po_validations.c_result_type_failure;
388: END IF;
389:
390: IF po_log.d_proc THEN
391: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
392: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
393: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
394: END IF;
395: EXCEPTION

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

422: d_mod CONSTANT VARCHAR2(100) := d_rate_info;
423: x_rate NUMBER;
424: BEGIN
425: IF x_result_set_id IS NULL THEN
426: x_result_set_id := po_validations.next_result_set_id();
427: END IF;
428:
429: IF (x_results IS NULL) THEN
430: x_results := po_validation_results_type.new_instance();

Line 445: x_result_type := po_validations.c_result_type_success;

441: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
442: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
443: END IF;
444:
445: x_result_type := po_validations.c_result_type_success;
446:
447: FOR i IN 1 .. p_id_tbl.COUNT LOOP
448:
449: -- check if currency is equal to functional currency

Line 463: x_result_type := po_validations.c_result_type_failure;

459: p_token1_value => 'RATE',
460: p_token2_name => 'VALUE',
461: p_token2_value => p_rate_tbl(i),
462: p_validation_id => PO_VAL_CONSTANTS.c_rate_null);
463: x_result_type := po_validations.c_result_type_failure;
464: END IF;
465:
466: -- validate rate_type is null if currency is functional
467: IF p_rate_type_tbl(i) IS NOT NULL THEN

Line 478: x_result_type := po_validations.c_result_type_failure;

474: p_token1_value => 'RATE_TYPE',
475: p_token2_name => 'VALUE',
476: p_token2_value => p_rate_type_tbl(i),
477: p_validation_id => PO_VAL_CONSTANTS.c_rate_type_null);
478: x_result_type := po_validations.c_result_type_failure;
479: END IF;
480:
481: -- validate rate_date is null if currency is functional
482: IF p_rate_date_tbl(i) IS NOT NULL THEN

Line 493: x_result_type := po_validations.c_result_type_failure;

489: p_token1_value => 'RATE_DATE',
490: p_token2_name => 'VALUE',
491: p_token2_value => p_rate_date_tbl(i),
492: p_validation_id => PO_VAL_CONSTANTS.c_rate_date_null);
493: x_result_type := po_validations.c_result_type_failure;
494: END IF;
495: ELSE
496: -- currency is not functional
497:

Line 510: x_result_type := po_validations.c_result_type_failure;

506: p_token1_value => 'RATE',
507: p_token2_name => 'VALUE',
508: p_token2_value => p_rate_tbl(i),
509: p_validation_id => PO_VAL_CONSTANTS.c_rate_not_null);
510: x_result_type := po_validations.c_result_type_failure;
511: END IF;
512:
513: -- validate rate is positive
514: IF NVL(p_rate_tbl(i), 1) < 0 THEN

Line 525: x_result_type := po_validations.c_result_type_failure;

521: p_token1_value => 'RATE',
522: p_token2_name => 'VALUE',
523: p_token2_value => p_rate_tbl(i),
524: p_validation_id => PO_VAL_CONSTANTS.c_rate_ge_zero);
525: x_result_type := po_validations.c_result_type_failure;
526: END IF;
527:
528: -- validate rate_type is not null if currency is functional
529: IF p_rate_type_tbl(i) IS NULL THEN

Line 540: x_result_type := po_validations.c_result_type_failure;

536: p_token1_value => 'RATE_TYPE',
537: p_token2_name => 'VALUE',
538: p_token2_value => p_rate_type_tbl(i),
539: p_validation_id => PO_VAL_CONSTANTS.c_rate_type_not_null);
540: x_result_type := po_validations.c_result_type_failure;
541: END IF;
542:
543: -- validate rate against g1_currency_api.get_rate()
544: IF p_rate_type_tbl(i) IS NOT NULL AND

Line 565: x_result_type := po_validations.c_result_type_failure;

561: p_message_name => 'PO_PDOI_INVALID_RATE',
562: p_token1_name => 'VALUE',
563: p_token1_value => p_rate_tbl(i),
564: p_validation_id => PO_VAL_CONSTANTS.c_rate_valid);
565: x_result_type := po_validations.c_result_type_failure;
566: END IF;
567: END IF;
568: END IF;
569: END LOOP;

Line 585: po_validations.c_result_type_failure,

581: token1_name,
582: token1_value,
583: validation_id)
584: SELECT x_result_set_id,
585: po_validations.c_result_type_failure,
586: c_entity_type_header,
587: p_id_tbl(i),
588: 'PO_PDOI_INVALID_RATE_TYPE',
589: 'RATE_TYPE',

Line 602: x_result_type := po_validations.c_result_type_failure;

598: FROM gl_daily_conversion_types_v dct
599: WHERE p_rate_type_tbl(i) = dct.conversion_type);
600:
601: IF (SQL%ROWCOUNT > 0) THEN
602: x_result_type := po_validations.c_result_type_failure;
603: END IF;
604:
605: IF po_log.d_proc THEN
606: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

602: x_result_type := po_validations.c_result_type_failure;
603: END IF;
604:
605: IF po_log.d_proc THEN
606: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
607: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
608: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
609: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
610: END IF;

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

628: IS
629: d_mod CONSTANT VARCHAR2(100) := d_agent_id;
630: BEGIN
631: IF x_result_set_id IS NULL THEN
632: x_result_set_id := po_validations.next_result_set_id();
633: END IF;
634:
635: IF po_log.d_proc THEN
636: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 641: x_result_type := po_validations.c_result_type_success;

637: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
638: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
639: END IF;
640:
641: x_result_type := po_validations.c_result_type_success;
642: -- validate agent_id against PO_AGENTS
643: FORALL i IN 1 .. p_id_tbl.COUNT
644: INSERT INTO po_validation_results_gt
645: (result_set_id,

Line 658: po_validations.c_result_type_failure,

654: token2_name,
655: token2_value,
656: validation_id)
657: SELECT x_result_set_id,
658: po_validations.c_result_type_failure,
659: c_entity_type_header,
660: p_id_tbl(i),
661: DECODE(p_agent_id_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_BUYER'),
662: 'AGENT_ID',

Line 680: x_result_type := po_validations.c_result_type_failure;

676: AND SYSDATE BETWEEN NVL(poa.start_date_active, SYSDATE - 1)
677: AND NVL(poa.end_date_active, SYSDATE + 1));
678:
679: IF (SQL%ROWCOUNT > 0) THEN
680: x_result_type := po_validations.c_result_type_failure;
681: END IF;
682:
683: IF po_log.d_proc THEN
684: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

680: x_result_type := po_validations.c_result_type_failure;
681: END IF;
682:
683: IF po_log.d_proc THEN
684: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
685: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
686: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
687: END IF;
688: EXCEPTION

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

728: -- is exempt from CCR
729: g_site_not_ccr_site CONSTANT NUMBER := 2;
730: BEGIN
731: IF x_result_set_id IS NULL THEN
732: x_result_set_id := po_validations.next_result_set_id();
733: END IF;
734:
735: IF (x_results IS NULL) THEN
736: x_results := po_validation_results_type.new_instance();

Line 749: x_result_type := po_validations.c_result_type_success;

745: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
746: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
747: END IF;
748:
749: x_result_type := po_validations.c_result_type_success;
750: FORALL i IN 1 .. p_id_tbl.COUNT
751: INSERT INTO po_validation_results_gt
752: (result_set_id,
753: result_type,

Line 765: po_validations.c_result_type_failure,

761: token2_name,
762: token2_value,
763: validation_id)
764: SELECT x_result_set_id,
765: po_validations.c_result_type_failure,
766: c_entity_type_header,
767: p_id_tbl(i),
768: DECODE(p_vendor_id_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_VENDOR'),
769: 'VENDOR_ID',

Line 784: x_result_type := po_validations.c_result_type_failure;

780: FROM po_suppliers_val_v psv
781: WHERE p_vendor_id_tbl(i) = psv.vendor_id);
782:
783: IF (SQL%ROWCOUNT > 0) THEN
784: x_result_type := po_validations.c_result_type_failure;
785: END IF;
786:
787: FORALL i IN 1 .. p_id_tbl.COUNT
788: INSERT INTO po_validation_results_gt

Line 802: po_validations.c_result_type_failure,

798: token2_name,
799: token2_value,
800: validation_id)
801: SELECT x_result_set_id,
802: po_validations.c_result_type_failure,
803: c_entity_type_header,
804: p_id_tbl(i),
805: DECODE(p_vendor_site_id_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_VENDOR_SITE'),
806: 'VENDOR_SITE_ID',

Line 824: x_result_type := po_validations.c_result_type_failure;

820: WHERE p_vendor_id_tbl(i) = pssv.vendor_id
821: AND p_vendor_site_id_tbl(i) = pssv.vendor_site_id));
822:
823: IF (SQL%ROWCOUNT > 0) THEN
824: x_result_type := po_validations.c_result_type_failure;
825: END IF;
826:
827: FORALL i IN 1 .. p_id_tbl.COUNT
828: INSERT INTO po_validation_results_gt

Line 840: po_validations.c_result_type_failure,

836: token1_name,
837: token1_value,
838: validation_id)
839: SELECT x_result_set_id,
840: po_validations.c_result_type_failure,
841: c_entity_type_header,
842: p_id_tbl(i),
843: 'PO_PDOI_INVALID_VDR_CNTCT',
844: 'VENDOR_CONTACT_ID',

Line 859: x_result_type := po_validations.c_result_type_failure;

855: WHERE p_vendor_site_id_tbl(i) = pvc.vendor_site_id
856: AND p_vendor_contact_id_tbl(i) = pvc.vendor_contact_id);
857:
858: IF (SQL%ROWCOUNT > 0) THEN
859: x_result_type := po_validations.c_result_type_failure;
860: END IF;
861:
862: IF (p_federal_instance = 'Y') THEN
863: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 892: x_result_type := po_validations.c_result_type_failure;

888: p_token1_value => p_vendor_site_id_tbl(i),
889: p_token2_name => 'VENDOR_ID',
890: p_token2_value => p_vendor_id_tbl(i),
891: p_validation_id => PO_VAL_CONSTANTS.c_vendor_site_ccr_valid);
892: x_result_type := po_validations.c_result_type_failure;
893: END IF;
894: END;
895: END LOOP;
896: END IF;

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

895: END LOOP;
896: END IF;
897:
898: IF po_log.d_proc THEN
899: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
901: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
902: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
903: END IF;

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

923: IS
924: d_mod CONSTANT VARCHAR2(100) := d_ship_to_location_id;
925: BEGIN
926: IF x_result_set_id IS NULL THEN
927: x_result_set_id := po_validations.next_result_set_id();
928: END IF;
929:
930: IF po_log.d_proc THEN
931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 937: x_result_type := po_validations.c_result_type_success;

933: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
934: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
935: END IF;
936:
937: x_result_type := po_validations.c_result_type_success;
938: -- validate ship_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
939: FORALL i IN 1 .. p_id_tbl.COUNT
940: INSERT INTO po_validation_results_gt
941: (result_set_id,

Line 954: po_validations.c_result_type_failure,

950: token2_name,
951: token2_value,
952: validation_id)
953: SELECT x_result_set_id,
954: po_validations.c_result_type_failure,
955: c_entity_type_header,
956: p_id_tbl(i),
957: DECODE(p_ship_to_location_id_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_SHIP_LOC_ID'),
958: 'SHIP_TO_LOCATION_ID',

Line 979: x_result_type := po_validations.c_result_type_failure;

975: AND p_ship_to_location_id_tbl(i) = hrl.location_id
976: AND SYSDATE < NVL(hrl.inactive_date, SYSDATE + 1)));
977:
978: IF (SQL%ROWCOUNT > 0) THEN
979: x_result_type := po_validations.c_result_type_failure;
980: END IF;
981:
982: IF po_log.d_proc THEN
983: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

979: x_result_type := po_validations.c_result_type_failure;
980: END IF;
981:
982: IF po_log.d_proc THEN
983: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
984: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
985: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
986: END IF;
987: EXCEPTION

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

1006: IS
1007: d_mod CONSTANT VARCHAR2(100) := d_bill_to_location_id;
1008: BEGIN
1009: IF x_result_set_id IS NULL THEN
1010: x_result_set_id := po_validations.next_result_set_id();
1011: END IF;
1012:
1013: IF po_log.d_proc THEN
1014: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1020: x_result_type := po_validations.c_result_type_success;

1016: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1017: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1018: END IF;
1019:
1020: x_result_type := po_validations.c_result_type_success;
1021: -- validate bill_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
1022: FORALL i IN 1 .. p_id_tbl.COUNT
1023: INSERT INTO po_validation_results_gt
1024: (result_set_id,

Line 1037: po_validations.c_result_type_failure,

1033: token2_name,
1034: token2_value,
1035: validation_id)
1036: SELECT x_result_set_id,
1037: po_validations.c_result_type_failure,
1038: c_entity_type_header,
1039: p_id_tbl(i),
1040: DECODE(p_bill_to_location_id_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_INVALID_BILL_LOC_ID'),
1041: 'BILL_TO_LOCATION_ID',

Line 1062: x_result_type := po_validations.c_result_type_failure;

1058: AND p_bill_to_location_id_tbl(i) = hrl.location_id
1059: AND SYSDATE < NVL(hrl.inactive_date, SYSDATE + 1)));
1060:
1061: IF (SQL%ROWCOUNT > 0) THEN
1062: x_result_type := po_validations.c_result_type_failure;
1063: END IF;
1064:
1065: IF po_log.d_proc THEN
1066: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1062: x_result_type := po_validations.c_result_type_failure;
1063: END IF;
1064:
1065: IF po_log.d_proc THEN
1066: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1067: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1068: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1069: END IF;
1070: EXCEPTION

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

1088: IS
1089: d_mod CONSTANT VARCHAR2(100) := d_ship_via_lookup_code;
1090: BEGIN
1091: IF x_result_set_id IS NULL THEN
1092: x_result_set_id := po_validations.next_result_set_id();
1093: END IF;
1094:
1095: IF po_log.d_proc THEN
1096: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1102: x_result_type := po_validations.c_result_type_success;

1098: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1099: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1100: END IF;
1101:
1102: x_result_type := po_validations.c_result_type_success;
1103: FORALL i IN 1 .. p_id_tbl.COUNT
1104: INSERT INTO po_validation_results_gt
1105: (result_set_id,
1106: result_type,

Line 1116: po_validations.c_result_type_failure,

1112: token1_name,
1113: token1_value,
1114: validation_id)
1115: SELECT x_result_set_id,
1116: po_validations.c_result_type_failure,
1117: c_entity_type_header,
1118: p_id_tbl(i),
1119: 'PO_PDOI_INVALID_FREIGHT_CARR',
1120: 'SHIP_VIA_LOOKUP_CODE',

Line 1135: x_result_type := po_validations.c_result_type_failure;

1131: AND NVL(ofr.disable_date, SYSDATE + 1) > SYSDATE
1132: AND ofr.organization_id = p_inventory_org_id);
1133:
1134: IF (SQL%ROWCOUNT > 0) THEN
1135: x_result_type := po_validations.c_result_type_failure;
1136: END IF;
1137:
1138: IF po_log.d_proc THEN
1139: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1135: x_result_type := po_validations.c_result_type_failure;
1136: END IF;
1137:
1138: IF po_log.d_proc THEN
1139: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1140: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1141: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1142: END IF;
1143: EXCEPTION

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

1160: IS
1161: d_mod CONSTANT VARCHAR2(100) := d_fob_lookup_code;
1162: BEGIN
1163: IF (x_result_set_id IS NULL) THEN
1164: x_result_set_id := po_validations.next_result_set_id();
1165: END IF;
1166:
1167: IF po_log.d_proc THEN
1168: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1173: x_result_type := po_validations.c_result_type_success;

1169: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1170: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1171: END IF;
1172:
1173: x_result_type := po_validations.c_result_type_success;
1174: FORALL i IN 1 .. p_id_tbl.COUNT
1175: INSERT INTO po_validation_results_gt
1176: (result_set_id,
1177: result_type,

Line 1187: po_validations.c_result_type_failure,

1183: token1_name,
1184: token1_value,
1185: validation_id)
1186: SELECT x_result_set_id,
1187: po_validations.c_result_type_failure,
1188: c_entity_type_header,
1189: p_id_tbl(i),
1190: 'PO_PDOI_INVALID_FOB',
1191: 'FOB_LOOKUP_CODE',

Line 1206: x_result_type := po_validations.c_result_type_failure;

1202: AND plc.lookup_type = 'FOB'
1203: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1204:
1205: IF (SQL%ROWCOUNT > 0) THEN
1206: x_result_type := po_validations.c_result_type_failure;
1207: END IF;
1208:
1209: IF po_log.d_proc THEN
1210: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1206: x_result_type := po_validations.c_result_type_failure;
1207: END IF;
1208:
1209: IF po_log.d_proc THEN
1210: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1211: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1212: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1213: END IF;
1214: EXCEPTION

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

1231: IS
1232: d_mod CONSTANT VARCHAR2(100) := d_freight_terms_lookup_code;
1233: BEGIN
1234: IF (x_result_set_id IS NULL) THEN
1235: x_result_set_id := po_validations.next_result_set_id();
1236: END IF;
1237:
1238: IF po_log.d_proc THEN
1239: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1244: x_result_type := po_validations.c_result_type_success;

1240: po_log.proc_begin(d_mod, 'p_freight_terms_lookup_tbl', p_freight_terms_lookup_tbl);
1241: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1242: END IF;
1243:
1244: x_result_type := po_validations.c_result_type_success;
1245: FORALL i IN 1 .. p_id_tbl.COUNT
1246: INSERT INTO po_validation_results_gt
1247: (result_set_id,
1248: result_type,

Line 1258: po_validations.c_result_type_failure,

1254: token1_name,
1255: token1_value,
1256: validation_id)
1257: SELECT x_result_set_id,
1258: po_validations.c_result_type_failure,
1259: c_entity_type_header,
1260: p_id_tbl(i),
1261: 'PO_PDOI_INVALID_FREIGHT_TERMS',
1262: 'FREIGHT_TERMS_LOOKUP_CODE',

Line 1277: x_result_type := po_validations.c_result_type_failure;

1273: AND plc.lookup_type = 'FREIGHT TERMS'
1274: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1275:
1276: IF (SQL%ROWCOUNT > 0) THEN
1277: x_result_type := po_validations.c_result_type_failure;
1278: END IF;
1279:
1280: IF po_log.d_proc THEN
1281: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1277: x_result_type := po_validations.c_result_type_failure;
1278: END IF;
1279:
1280: IF po_log.d_proc THEN
1281: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1282: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1283: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1284: END IF;
1285: EXCEPTION

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

1302: IS
1303: d_mod CONSTANT VARCHAR2(100) := d_shipping_control;
1304: BEGIN
1305: IF (x_result_set_id IS NULL) THEN
1306: x_result_set_id := po_validations.next_result_set_id();
1307: END IF;
1308:
1309: IF po_log.d_proc THEN
1310: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1315: x_result_type := po_validations.c_result_type_success;

1311: po_log.proc_begin(d_mod, 'p_shipping_control_tbl', p_shipping_control_tbl);
1312: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1313: END IF;
1314:
1315: x_result_type := po_validations.c_result_type_success;
1316: FORALL i IN 1 .. p_id_tbl.COUNT
1317: INSERT INTO po_validation_results_gt
1318: (result_set_id,
1319: result_type,

Line 1329: po_validations.c_result_type_failure,

1325: token1_name,
1326: token1_value,
1327: validation_id)
1328: SELECT x_result_set_id,
1329: po_validations.c_result_type_failure,
1330: c_entity_type_header,
1331: p_id_tbl(i),
1332: 'PO_PDOI_INVALID_SHIPPING_CTRL',
1333: 'SHIPPING_CONTROL',

Line 1348: x_result_type := po_validations.c_result_type_failure;

1344: AND plc.lookup_type = 'SHIPPING CONTROL'
1345: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1346:
1347: IF (SQL%ROWCOUNT > 0) THEN
1348: x_result_type := po_validations.c_result_type_failure;
1349: END IF;
1350:
1351: IF po_log.d_proc THEN
1352: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1348: x_result_type := po_validations.c_result_type_failure;
1349: END IF;
1350:
1351: IF po_log.d_proc THEN
1352: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1353: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1354: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1355: END IF;
1356: EXCEPTION

Line 1389: x_result_type := po_validations.c_result_type_success;

1385: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1386: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1387: END IF;
1388:
1389: x_result_type := po_validations.c_result_type_success;
1390:
1391: -- Bug6601134(obsoleted 4467491)
1392: /*FOR i IN 1 .. p_id_tbl.COUNT LOOP
1393: IF p_acceptance_reqd_flag_tbl(i) = 'Y' AND p_acceptance_due_date_tbl(i) IS NULL THEN

Line 1404: x_result_type := po_validations.c_result_type_failure;

1400: p_token1_value => 'ACCEPTANCE_DUE_DATE',
1401: p_token2_name => 'VALUE',
1402: p_token2_value => p_acceptance_due_date_tbl(i),
1403: p_validation_id => PO_VAL_CONSTANTS.c_acceptance_due_date);
1404: x_result_type := po_validations.c_result_type_failure;
1405: END IF;
1406: END LOOP;*/
1407:
1408: IF po_log.d_proc THEN

Line 1442: x_result_type := po_validations.c_result_type_success;

1438: po_log.proc_begin(d_mod, 'p_cancel_flag_tbl', p_cancel_flag_tbl);
1439: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1440: END IF;
1441:
1442: x_result_type := po_validations.c_result_type_success;
1443:
1444: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1445: IF p_cancel_flag_tbl(i) <> 'N' THEN
1446: x_results.add_result(p_entity_type => c_entity_type_header,

Line 1457: x_result_type := po_validations.c_result_type_failure;

1453: p_token2_name => 'VALUE',
1454: p_token2_value => p_cancel_flag_tbl(i),
1455: p_validation_id => PO_VAL_CONSTANTS.c_cancel_flag);
1456:
1457: x_result_type := po_validations.c_result_type_failure;
1458: END IF;
1459: END LOOP;
1460:
1461: IF po_log.d_proc THEN

Line 1497: x_result_type := po_validations.c_result_type_success;

1493: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1494: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1495: END IF;
1496:
1497: x_result_type := po_validations.c_result_type_success;
1498:
1499: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1500: IF p_acceptance_reqd_flag_tbl(i) ='Y' AND p_closed_code_tbl(i) <> 'OPEN' THEN
1501: x_results.add_result(p_entity_type => c_entity_type_header,

Line 1512: x_result_type := po_validations.c_result_type_failure;

1508: p_token2_name => 'VALUE',
1509: p_token2_value => p_closed_code_tbl(i),
1510: p_validation_id => PO_VAL_CONSTANTS.c_closed_code);
1511:
1512: x_result_type := po_validations.c_result_type_failure;
1513: END IF;
1514: END LOOP;
1515:
1516: IF po_log.d_proc THEN

Line 1552: x_result_type := po_validations.c_result_type_success;

1548: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1549: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1550: END IF;
1551:
1552: x_result_type := po_validations.c_result_type_success;
1553:
1554: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1555: IF p_approval_status_tbl(i) <> 'APPROVED' AND p_print_count_tbl(i) <> 0 THEN
1556: x_results.add_result(p_entity_type => c_entity_type_header,

Line 1566: x_result_type := po_validations.c_result_type_failure;

1562: p_token1_value => 'PRINT COUNT',
1563: p_token2_name => 'VALUE',
1564: p_token2_value => 0,
1565: p_validation_id => PO_VAL_CONSTANTS.c_print_count);
1566: x_result_type := po_validations.c_result_type_failure;
1567: END IF;
1568: END LOOP;
1569:
1570: IF po_log.d_proc THEN

Line 1605: x_result_type := po_validations.c_result_type_success;

1601: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1602: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1603: END IF;
1604:
1605: x_result_type := po_validations.c_result_type_success;
1606:
1607: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1608: IF p_approval_status_tbl(i) NOT IN('APPROVED', 'INCOMPLETE', 'INITIATE APPROVAL') THEN
1609: x_results.add_result(p_entity_type => c_entity_type_header,

Line 1615: x_result_type := po_validations.c_result_type_failure;

1611: p_column_name => 'APPROVAL_STATUS',
1612: p_column_val => p_approval_status_tbl(i),
1613: p_message_name => 'PO_PDOI_INVALID_STATUS',
1614: p_validation_id => PO_VAL_CONSTANTS.c_approval_status);
1615: x_result_type := po_validations.c_result_type_failure;
1616: END IF;
1617: END LOOP;
1618:
1619: IF po_log.d_proc THEN

Line 1653: x_result_type := po_validations.c_result_type_success;

1649: po_log.proc_begin(d_mod, 'p_amount_to_encumber_tbl', p_amount_to_encumber_tbl);
1650: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1651: END IF;
1652:
1653: x_result_type := po_validations.c_result_type_success;
1654:
1655: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1656: IF p_amount_to_encumber_tbl(i) <= 0 THEN
1657: x_results.add_result(p_entity_type => c_entity_type_header,

Line 1667: x_result_type := po_validations.c_result_type_failure;

1663: p_token1_value => 'AMOUNT_TO_ENCUMBER',
1664: p_token2_name => 'VALUE',
1665: p_token2_value => p_amount_to_encumber_tbl(i),
1666: p_validation_id => PO_VAL_CONSTANTS.c_amount_to_encumber);
1667: x_result_type := po_validations.c_result_type_failure;
1668: END IF;
1669: END LOOP;
1670:
1671: IF po_log.d_proc THEN

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

1692: IS
1693: d_mod CONSTANT VARCHAR2(100) := d_style_id;
1694: BEGIN
1695: IF x_result_set_id IS NULL THEN
1696: x_result_set_id := po_validations.next_result_set_id();
1697: END IF;
1698:
1699: IF po_log.d_proc THEN
1700: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1705: x_result_type := po_validations.c_result_type_success;

1701: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1702: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1703: END IF;
1704:
1705: x_result_type := po_validations.c_result_type_success;
1706:
1707: -- validate that the style_id exists in the system and the status is ACTIVE.
1708: FORALL i IN 1 .. p_id_tbl.COUNT
1709: INSERT INTO po_validation_results_gt

Line 1721: po_validations.c_result_type_failure,

1717: token1_name,
1718: token1_value,
1719: validation_id)
1720: SELECT x_result_set_id,
1721: po_validations.c_result_type_failure,
1722: c_entity_type_header,
1723: p_id_tbl(i),
1724: 'PO_PDOI_INVALID_STYLE_ID',
1725: 'STYLE_ID',

Line 1737: x_result_type := po_validations.c_result_type_failure;

1733: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1734: pdsh.status = 'ACTIVE');
1735:
1736: IF (SQL%ROWCOUNT > 0) THEN
1737: x_result_type := po_validations.c_result_type_failure;
1738: END IF;
1739:
1740: /* PDOI for Complex PO Project: Allow Complex PO styles: Reverting the changes
1741: -- Bug 13018193 Disabling the validation of complex work PO

Line 1756: po_validations.c_result_type_failure,

1752: token1_name,
1753: token1_value,
1754: validation_id)
1755: SELECT x_result_set_id,
1756: po_validations.c_result_type_failure,
1757: c_entity_type_header,
1758: p_id_tbl(i),
1759: 'PO_PDOI_COMPLEX_WORK_STYLE',
1760: 'STYLE_ID',

Line 1772: x_result_type := po_validations.c_result_type_failure;

1768: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1769: pdsh.progress_payment_flag = 'Y');
1770:
1771: IF (SQL%ROWCOUNT > 0) THEN
1772: x_result_type := po_validations.c_result_type_failure;
1773: END IF; */
1774:
1775: IF po_log.d_proc THEN
1776: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

1772: x_result_type := po_validations.c_result_type_failure;
1773: END IF; */
1774:
1775: IF po_log.d_proc THEN
1776: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1777: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1778: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1779: END IF;
1780:

Line 1810: x_result_type := po_validations.c_result_type_success;

1806: IF (x_results IS NULL) THEN
1807: x_results := po_validation_results_type.new_instance();
1808: END IF;
1809:
1810: x_result_type := po_validations.c_result_type_success;
1811:
1812: FOR i IN 1..p_id_tbl.COUNT LOOP
1813:
1814: IF (p_type_lookup_code_tbl(i) = 'QUOTATION') THEN

Line 1831: x_result_type := po_validations.c_result_type_failure;

1827: p_token2_value => p_acceptance_required_flag_tbl(i),
1828: p_validation_id => PO_VAL_CONSTANTS.c_acceptance_required_flag
1829: );
1830:
1831: x_result_type := po_validations.c_result_type_failure;
1832: END IF;
1833:
1834: ELSE
1835:

Line 1847: x_result_type := po_validations.c_result_type_failure;

1843: p_message_name => 'PO_PDOI_INVALID_ACC_REQD_FLAG',
1844: p_validation_id => PO_VAL_CONSTANTS.c_acceptance_required_flag
1845: );
1846:
1847: x_result_type := po_validations.c_result_type_failure;
1848: END IF;
1849: END IF;
1850:
1851: END LOOP;

Line 1890: x_result_type := po_validations.c_result_type_success;

1886: IF (x_results IS NULL) THEN
1887: x_results := po_validation_results_type.new_instance();
1888: END IF;
1889:
1890: x_result_type := po_validations.c_result_type_success;
1891:
1892:
1893:
1894: PO_VALIDATION_HELPER.greater_or_equal_zero

Line 1928: x_result_type := po_validations.c_result_type_failure;

1924: p_validation_id => PO_VAL_CONSTANTS.c_amount_agreed_not_null
1925: );
1926:
1927:
1928: x_result_type := po_validations.c_result_type_failure;
1929: END IF;
1930:
1931: IF ( p_amount_limit_tbl(i) < p_amount_agreed_tbl(i) ) THEN
1932:

Line 1942: x_result_type := po_validations.c_result_type_failure;

1938: p_message_name => PO_MESSAGE_S.PO_PO_AMT_LIMIT_CK_FAILED,
1939: p_validation_id => PO_VAL_CONSTANTS.c_amount_limit_gt_amt_agreed
1940: );
1941:
1942: x_result_type := po_validations.c_result_type_failure;
1943: END IF;
1944:
1945: END LOOP;
1946: