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_VALIDATION_HELPER dependencies on PO_VALIDATIONS

Line 18: c_entity_type_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_LINE;

14: c_SHIPMENT_NUM CONSTANT VARCHAR2(30) := 'SHIPMENT_NUM';
15: c_LINE_NUM CONSTANT VARCHAR2(30) := 'LINE_NUM';
16: c_PRICE_TYPE CONSTANT VARCHAR2(30) := 'PRICE_TYPE';
17:
18: c_entity_type_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_LINE;
19: --
20: c_entity_type_LINE_LOCATION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_LINE_LOCATION;
21: c_entity_type_DISTRIBUTION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_DISTRIBUTION;
22:

Line 20: c_entity_type_LINE_LOCATION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_LINE_LOCATION;

16: c_PRICE_TYPE CONSTANT VARCHAR2(30) := 'PRICE_TYPE';
17:
18: c_entity_type_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_LINE;
19: --
20: c_entity_type_LINE_LOCATION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_LINE_LOCATION;
21: c_entity_type_DISTRIBUTION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_DISTRIBUTION;
22:
23: ---------------------------------------------------------------------------
24: -- Modules for debugging.

Line 21: c_entity_type_DISTRIBUTION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_DISTRIBUTION;

17:
18: c_entity_type_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_LINE;
19: --
20: c_entity_type_LINE_LOCATION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_LINE_LOCATION;
21: c_entity_type_DISTRIBUTION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_DISTRIBUTION;
22:
23: ---------------------------------------------------------------------------
24: -- Modules for debugging.
25: ---------------------------------------------------------------------------

Line 163: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

159: -- A new object will be created if NULL is passed in.
160: --OUT:
161: --x_result_type
162: -- Indicates if any validations have failed.
163: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
164: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
165: --End of Comments
166: -------------------------------------------------------------------------------
167: PROCEDURE greater_than_zero(

Line 164: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

160: --OUT:
161: --x_result_type
162: -- Indicates if any validations have failed.
163: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
164: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
165: --End of Comments
166: -------------------------------------------------------------------------------
167: PROCEDURE greater_than_zero(
168: p_calling_module IN VARCHAR2

Line 229: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

225: END IF;
226: END LOOP;
227:
228: IF (l_results_count < x_results.result_type.COUNT) THEN
229: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
230: ELSE
231: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
232: END IF;
233:

Line 231: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

227:
228: IF (l_results_count < x_results.result_type.COUNT) THEN
229: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
230: ELSE
231: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
232: END IF;
233:
234: IF PO_LOG.d_proc THEN
235: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 282: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

278: -- A new object will be created if NULL is passed in.
279: --OUT:
280: --x_result_type
281: -- Indicates if any validations have failed.
282: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
283: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
284: --End of Comments
285: -------------------------------------------------------------------------------
286: PROCEDURE greater_or_equal_zero(

Line 283: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

279: --OUT:
280: --x_result_type
281: -- Indicates if any validations have failed.
282: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
283: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
284: --End of Comments
285: -------------------------------------------------------------------------------
286: PROCEDURE greater_or_equal_zero(
287: p_calling_module IN VARCHAR2,

Line 370: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

366: END IF;
367: END LOOP;
368:
369: IF (l_results_count < x_results.result_type.COUNT) THEN
370: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
371: ELSE
372: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
373: END IF;
374:

Line 372: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

368:
369: IF (l_results_count < x_results.result_type.COUNT) THEN
370: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
371: ELSE
372: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
373: END IF;
374:
375: IF PO_LOG.d_proc THEN
376: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 427: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

423: -- A new object will be created if NULL is passed in.
424: --OUT:
425: --x_result_type
426: -- Indicates if any validations have failed.
427: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
428: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
429: --End of Comments
430: -------------------------------------------------------------------------------
431: PROCEDURE within_percentage_range(

Line 428: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

424: --OUT:
425: --x_result_type
426: -- Indicates if any validations have failed.
427: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
428: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
429: --End of Comments
430: -------------------------------------------------------------------------------
431: PROCEDURE within_percentage_range(
432: p_calling_module IN VARCHAR2

Line 510: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

506: END IF;
507: END LOOP;
508:
509: IF (l_results_count < x_results.result_type.COUNT) THEN
510: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
511: ELSE
512: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
513: END IF;
514:

Line 512: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

508:
509: IF (l_results_count < x_results.result_type.COUNT) THEN
510: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
511: ELSE
512: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
513: END IF;
514:
515: IF PO_LOG.d_proc THEN
516: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 564: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

560: -- this identifier.
561: --OUT:
562: --x_result_type
563: -- Indicates if any validations have failed.
564: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
565: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
566: --End of Comments
567: -------------------------------------------------------------------------------
568: PROCEDURE open_period(

Line 565: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

561: --OUT:
562: --x_result_type
563: -- Indicates if any validations have failed.
564: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
565: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
566: --End of Comments
567: -------------------------------------------------------------------------------
568: PROCEDURE open_period(
569: p_calling_module IN VARCHAR2

Line 599: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

595: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
596: END IF;
597:
598: IF (x_result_set_id IS NULL) THEN
599: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
600: END IF;
601:
602: FND_PROFILE.get(PO_PROFILES.PO_CHECK_OPEN_PERIODS,l_profile_value);
603:

Line 604: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

600: END IF;
601:
602: FND_PROFILE.get(PO_PROFILES.PO_CHECK_OPEN_PERIODS,l_profile_value);
603:
604: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
605:
606: IF PO_LOG.d_stmt THEN
607: PO_LOG.stmt(d_mod,0,'l_profile_value',l_profile_value);
608: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);

Line 616: * Also, moved the call to "PO_VALIDATIONS.log_validation_results_gt" inside

612: IF (l_profile_value = 'Y') THEN
613:
614: /* Bug# 6671185: Added the condition "p_date_tbl(i) IS NOT NULL".
615: * This is to ensure that validation do not fail if p_date_tbl(i) is NULL.
616: * Also, moved the call to "PO_VALIDATIONS.log_validation_results_gt" inside
617: * the for loop, so that all the validation errors are captured.
618: */
619: FOR i IN 1 .. p_date_tbl.COUNT LOOP
620: IF p_date_tbl(i) IS NOT NULL THEN

Line 661: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

657: )
658: ;
659:
660: IF(SQL%ROWCOUNT > 0) THEN
661: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
662: END IF;
663:
664: IF PO_LOG.d_proc THEN
665: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

Line 665: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

661: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
662: END IF;
663:
664: IF PO_LOG.d_proc THEN
665: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
666: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
667: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
668: PO_LOG.proc_end(p_calling_module);
669: END IF;

Line 714: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

710: -- A new object will be created if NULL is passed in.
711: --OUT:
712: --x_result_type
713: -- Indicates if any validations have failed.
714: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
715: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
716: --End of Comments
717: -------------------------------------------------------------------------------
718: PROCEDURE not_null(

Line 715: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

711: --OUT:
712: --x_result_type
713: -- Indicates if any validations have failed.
714: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
715: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
716: --End of Comments
717: -------------------------------------------------------------------------------
718: PROCEDURE not_null(
719: p_calling_module IN VARCHAR2,

Line 789: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

785: END IF;
786: END LOOP;
787:
788: IF (l_results_count < x_results.result_type.COUNT) THEN
789: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
790: ELSE
791: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
792: END IF;
793:

Line 791: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

787:
788: IF (l_results_count < x_results.result_type.COUNT) THEN
789: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
790: ELSE
791: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
792: END IF;
793:
794: IF PO_LOG.d_proc THEN
795: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 838: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

834: -- A new object will be created if NULL is passed in.
835: --OUT:
836: --x_result_type
837: -- Indicates if any validations have failed.
838: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
839: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
840: --End of Comments
841: -------------------------------------------------------------------------------
842: PROCEDURE ensure_null(p_calling_module IN VARCHAR2,

Line 839: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

835: --OUT:
836: --x_result_type
837: -- Indicates if any validations have failed.
838: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
839: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
840: --End of Comments
841: -------------------------------------------------------------------------------
842: PROCEDURE ensure_null(p_calling_module IN VARCHAR2,
843: p_value_tbl IN PO_TBL_VARCHAR4000,

Line 908: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

904: END IF;
905: END LOOP;
906:
907: IF (l_results_count < x_results.result_type.COUNT) THEN
908: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
909: ELSE
910: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
911: END IF;
912:

Line 910: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

906:
907: IF (l_results_count < x_results.result_type.COUNT) THEN
908: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
909: ELSE
910: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
911: END IF;
912:
913: IF PO_LOG.d_proc THEN
914: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);

Line 957: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

953: -- A new object will be created if NULL is passed in.
954: --OUT:
955: --x_result_type
956: -- Indicates if any validations have failed.
957: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
958: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
959: --End of Comments
960: -------------------------------------------------------------------------------
961: PROCEDURE flag_value_Y_N(p_calling_module IN VARCHAR2,

Line 958: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

954: --OUT:
955: --x_result_type
956: -- Indicates if any validations have failed.
957: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
958: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
959: --End of Comments
960: -------------------------------------------------------------------------------
961: PROCEDURE flag_value_Y_N(p_calling_module IN VARCHAR2,
962: p_flag_value_tbl IN PO_TBL_VARCHAR1,

Line 1027: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1023: END IF;
1024: END LOOP;
1025:
1026: IF (l_results_count < x_results.result_type.COUNT) THEN
1027: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1028: ELSE
1029: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1030: END IF;
1031:

Line 1029: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1025:
1026: IF (l_results_count < x_results.result_type.COUNT) THEN
1027: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1028: ELSE
1029: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1030: END IF;
1031:
1032: IF PO_LOG.d_proc THEN
1033: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);

Line 1083: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

1079: -- A new object will be created if NULL is passed in.
1080: --OUT:
1081: --x_result_type
1082: -- Indicates if any validations have failed.
1083: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1084: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1085: --End of Comments
1086: -------------------------------------------------------------------------------
1087: PROCEDURE gt_zero_order_type_filter(

Line 1084: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

1080: --OUT:
1081: --x_result_type
1082: -- Indicates if any validations have failed.
1083: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1084: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1085: --End of Comments
1086: -------------------------------------------------------------------------------
1087: PROCEDURE gt_zero_order_type_filter(
1088: p_calling_module IN VARCHAR2

Line 1355: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

1351: -- A new object will be created if NULL is passed in.
1352: --OUT:
1353: --x_result_type
1354: -- Indicates if any validations have failed.
1355: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1356: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1357: --End of Comments
1358: -------------------------------------------------------------------------------
1359: PROCEDURE no_timecards_exist(

Line 1356: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

1352: --OUT:
1353: --x_result_type
1354: -- Indicates if any validations have failed.
1355: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1356: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1357: --End of Comments
1358: -------------------------------------------------------------------------------
1359: PROCEDURE no_timecards_exist(
1360: p_calling_module IN VARCHAR2

Line 1504: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1500:
1501: END LOOP;
1502:
1503: IF (l_results_count < x_results.result_type.COUNT) THEN
1504: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1505: ELSE
1506: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1507: END IF;
1508:

Line 1506: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1502:
1503: IF (l_results_count < x_results.result_type.COUNT) THEN
1504: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1505: ELSE
1506: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1507: END IF;
1508:
1509: IF PO_LOG.d_proc THEN
1510: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 1554: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

1550: -- this identifier.
1551: --OUT:
1552: --x_result_type
1553: -- Indicates if any validations have failed.
1554: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1555: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1556: --End of Comments
1557: -------------------------------------------------------------------------------
1558: PROCEDURE amount_notif_ctrl_warning(

Line 1555: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

1551: --OUT:
1552: --x_result_type
1553: -- Indicates if any validations have failed.
1554: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1555: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1556: --End of Comments
1557: -------------------------------------------------------------------------------
1558: PROCEDURE amount_notif_ctrl_warning(
1559: p_calling_module IN VARCHAR2

Line 1584: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

1580: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1581: END IF;
1582:
1583: IF (x_result_set_id IS NULL) THEN
1584: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1585: END IF;
1586:
1587: IF (p_quantity_tbl IS NULL) THEN
1588: l_quantity_flag := 'N';

Line 1607: , PO_VALIDATIONS.c_result_type_WARNING

1603: , message_name
1604: )
1605: SELECT
1606: x_result_set_id
1607: , PO_VALIDATIONS.c_result_type_WARNING
1608: , c_ENTITY_TYPE_LINE
1609: , p_line_id_tbl(i)
1610: , p_column_name
1611: , p_message_name

Line 1634: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;

1630: )
1631: ;
1632:
1633: IF (SQL%ROWCOUNT > 0) THEN
1634: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1635: ELSE
1636: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1637: END IF;
1638:

Line 1636: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1632:
1633: IF (SQL%ROWCOUNT > 0) THEN
1634: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1635: ELSE
1636: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1637: END IF;
1638:
1639: IF PO_LOG.d_proc THEN
1640: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

Line 1640: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

1636: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1637: END IF;
1638:
1639: IF PO_LOG.d_proc THEN
1640: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1641: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1642: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1643: PO_LOG.proc_end(p_calling_module);
1644: END IF;

Line 1711: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

1707: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1708: END IF;
1709:
1710: IF (x_result_set_id IS NULL) THEN
1711: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1712: END IF;
1713:
1714: ----------------------------------------------------------------------
1715: -- In order to check that the child number is unique

Line 1752: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_DISTRIBUTION) THEN

1748: -- Put the stored data for these ids into the temp table.
1749:
1750: l_data_key := PO_CORE_S.get_session_gt_nextval();
1751:
1752: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_DISTRIBUTION) THEN
1753:
1754: l_column_name := c_DISTRIBUTION_NUM;
1755: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_DIST_NUM;
1756:

Line 1788: ELSIF (p_entity_type = PO_VALIDATIONS.c_entity_type_LINE_LOCATION) THEN

1784: AND draft_id = p_draft_id_tbl(i)),-999);
1785: --
1786: END LOOP;
1787:
1788: ELSIF (p_entity_type = PO_VALIDATIONS.c_entity_type_LINE_LOCATION) THEN
1789:
1790: l_column_name := c_SHIPMENT_NUM;
1791: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_SHIP_NUM;
1792:

Line 1827: ELSE -- p_entity_type = PO_VALIDATIONS.c_entity_type_LINE

1823: -- do not consider the corresponding shipment on PAR
1824: AND Nvl(LINE.mod_line_id,-999 )<> l_parent_id_tbl(i);
1825: END LOOP;
1826:
1827: ELSE -- p_entity_type = PO_VALIDATIONS.c_entity_type_LINE
1828:
1829: l_column_name := c_LINE_NUM;
1830: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_LINE_NUM;
1831:

Line 1945: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1941: )
1942: ;
1943:
1944: IF (SQL%ROWCOUNT > 0) THEN
1945: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1946: ELSE
1947: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1948: END IF;
1949:

Line 1947: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1943:
1944: IF (SQL%ROWCOUNT > 0) THEN
1945: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1946: ELSE
1947: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1948: END IF;
1949:
1950: IF PO_LOG.d_proc THEN
1951: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);

Line 1952: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

1948: END IF;
1949:
1950: IF PO_LOG.d_proc THEN
1951: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1952: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1953: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1954: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1955: PO_LOG.proc_end(p_calling_module);
1956: END IF;

Line 2008: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

2004: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2005: END IF;
2006:
2007: IF (x_result_set_id IS NULL) THEN
2008: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2009: END IF;
2010:
2011: ----------------------------------------------------------------------
2012: -- See the discussion in child_num_unique for the

Line 2101: , PO_VALIDATIONS.c_entity_type_PRICE_DIFF

2097: , token1_value --bug #4956116
2098: )
2099: SELECT
2100: x_result_set_id
2101: , PO_VALIDATIONS.c_entity_type_PRICE_DIFF
2102: , CHILD.index_num2
2103: , p_column_name
2104: , CHILD.char1
2105: , p_message_name

Line 2126: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2122: )
2123: ;
2124:
2125: IF (SQL%ROWCOUNT > 0) THEN
2126: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2127: ELSE
2128: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2129: END IF;
2130:

Line 2128: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2124:
2125: IF (SQL%ROWCOUNT > 0) THEN
2126: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2127: ELSE
2128: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2129: END IF;
2130:
2131: IF PO_LOG.d_proc THEN
2132: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);

Line 2133: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

2129: END IF;
2130:
2131: IF PO_LOG.d_proc THEN
2132: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
2133: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2134: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2135: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2136: PO_LOG.proc_end(p_calling_module);
2137: END IF;

Line 2222: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2218: END IF;
2219: END LOOP;
2220:
2221: IF (l_results_count < x_results.result_type.COUNT) THEN
2222: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2223: ELSE
2224: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2225: END IF;
2226:

Line 2224: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2220:
2221: IF (l_results_count < x_results.result_type.COUNT) THEN
2222: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2223: ELSE
2224: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2225: END IF;
2226:
2227: IF PO_LOG.d_proc THEN
2228: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2292: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2288: END IF;
2289: END LOOP;
2290:
2291: IF (l_results_count < x_results.result_type.COUNT) THEN
2292: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2293: ELSE
2294: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2295: END IF;
2296:

Line 2294: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2290:
2291: IF (l_results_count < x_results.result_type.COUNT) THEN
2292: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2293: ELSE
2294: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2295: END IF;
2296:
2297: IF PO_LOG.d_proc THEN
2298: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2341: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

2337: -- A new object will be created if NULL is passed in.
2338: --OUT:
2339: --x_result_type
2340: -- Indicates if any validations have failed.
2341: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2342: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2343: --End of Comments
2344: -------------------------------------------------------------------------------
2345: PROCEDURE zero(p_calling_module IN VARCHAR2,

Line 2342: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

2338: --OUT:
2339: --x_result_type
2340: -- Indicates if any validations have failed.
2341: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2342: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2343: --End of Comments
2344: -------------------------------------------------------------------------------
2345: PROCEDURE zero(p_calling_module IN VARCHAR2,
2346: p_value_tbl IN PO_TBL_NUMBER,

Line 2412: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2408: END IF;
2409: END LOOP;
2410:
2411: IF (l_results_count < x_results.result_type.COUNT) THEN
2412: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2413: ELSE
2414: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2415: END IF;
2416:

Line 2414: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2410:
2411: IF (l_results_count < x_results.result_type.COUNT) THEN
2412: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2413: ELSE
2414: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2415: END IF;
2416:
2417: IF PO_LOG.d_proc THEN
2418: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);

Line 2457: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

2453: -- this identifier.
2454: --OUT:
2455: --x_result_type
2456: -- Indicates if any validations have failed.
2457: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2458: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2459: --End of Comments
2460: -------------------------------------------------------------------------------
2461: PROCEDURE terms_id(p_calling_module IN VARCHAR2,

Line 2458: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

2454: --OUT:
2455: --x_result_type
2456: -- Indicates if any validations have failed.
2457: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2458: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2459: --End of Comments
2460: -------------------------------------------------------------------------------
2461: PROCEDURE terms_id(p_calling_module IN VARCHAR2,
2462: p_terms_id_tbl IN PO_TBL_NUMBER,

Line 2473: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

2469: d_mod CONSTANT VARCHAR2(100) := D_terms_id;
2470:
2471: BEGIN
2472: IF x_result_set_id IS NULL THEN
2473: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2474: END IF;
2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_LOG.proc_begin(p_calling_module);

Line 2497: PO_VALIDATIONS.c_result_type_FAILURE,

2493: token1_name,
2494: token1_value,
2495: validation_id)
2496: SELECT x_result_set_id,
2497: PO_VALIDATIONS.c_result_type_FAILURE,
2498: p_entity_type,
2499: p_entity_id_tbl(i),
2500: 'PO_PDOI_INVALID_PAY_TERMS',
2501: 'TERMS_ID',

Line 2517: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2513: nvl(APT.start_date_active, sysdate - 1) AND
2514: nvl(APT.end_date_active, sysdate + 1)); -- END WHERE, FORALL
2515:
2516: IF (SQL%ROWCOUNT > 0) THEN
2517: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2518: ELSE
2519: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2520: END IF;
2521:

Line 2519: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2515:
2516: IF (SQL%ROWCOUNT > 0) THEN
2517: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2518: ELSE
2519: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2520: END IF;
2521:
2522: IF PO_LOG.d_proc THEN
2523: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 2523: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

2519: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2520: END IF;
2521:
2522: IF PO_LOG.d_proc THEN
2523: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
2524: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2525: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2526: PO_LOG.proc_end(p_calling_module);
2527: END IF;

Line 2569: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

2565: -- A new object will be created if NULL is passed in.
2566: --OUT:
2567: --x_result_type
2568: -- Indicates if any validations have failed.
2569: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2570: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2571: --End of Comments
2572: -------------------------------------------------------------------------------
2573: PROCEDURE gt_zero_opm_filter(

Line 2570: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

2566: --OUT:
2567: --x_result_type
2568: -- Indicates if any validations have failed.
2569: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2570: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2571: --End of Comments
2572: -------------------------------------------------------------------------------
2573: PROCEDURE gt_zero_opm_filter(
2574: p_calling_module IN VARCHAR2

Line 2619: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2615:
2616: IF p_item_id_tbl is null OR
2617: p_inv_org_id_tbl is null
2618: THEN
2619: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2620: RETURN;
2621: END IF;
2622:
2623: FOR i IN 1 .. l_input_size LOOP

Line 2712: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.

2708: -- A new object will be created if NULL is passed in.
2709: --OUT:
2710: --x_result_type
2711: -- Indicates if any validations have failed.
2712: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2713: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2714: --End of Comments
2715: -------------------------------------------------------------------------------
2716: PROCEDURE qtys_within_deviation(

Line 2713: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

2709: --OUT:
2710: --x_result_type
2711: -- Indicates if any validations have failed.
2712: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2713: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2714: --End of Comments
2715: -------------------------------------------------------------------------------
2716: PROCEDURE qtys_within_deviation(
2717: p_calling_module IN VARCHAR2

Line 2762: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2758:
2759: IF p_item_id_tbl is null OR
2760: p_inv_org_id_tbl is null
2761: THEN
2762: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2763: RETURN;
2764: END IF;
2765:
2766: FOR i IN 1 .. l_input_count LOOP

Line 2816: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2812:
2813: END LOOP;
2814:
2815: IF (l_results_count < x_results.result_type.COUNT) THEN
2816: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2817: ELSE
2818: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2819: END IF;
2820:

Line 2818: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2814:
2815: IF (l_results_count < x_results.result_type.COUNT) THEN
2816: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2817: ELSE
2818: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2819: END IF;
2820:
2821: IF PO_LOG.d_proc THEN
2822: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2877: x_result_type := po_validations.c_result_type_success;

2873: IF (x_results IS NULL) THEN
2874: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2875: END IF;
2876:
2877: x_result_type := po_validations.c_result_type_success;
2878:
2879: l_secondary_unit_of_meas_tbl.extend(p_item_id_tbl.COUNT);
2880:
2881: l_secondary_unit_of_meas_tbl := get_item_secondary_uom(p_item_id_tbl,

Line 2890: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN

2886: -- x_item is not derived for existing items..
2887: IF ((p_create_or_update_item_flag = 'Y' AND p_item_id_tbl(i) IS NULL AND p_item_tbl(i) IS NULL) OR
2888: (p_create_or_update_item_flag = 'N' and p_item_id_tbl(i) IS NULL)) AND
2889: p_secondary_unit_of_meas_tbl(i) IS NOT NULL THEN
2890: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2891: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2892: ELSE
2893: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2894: END IF;

Line 2901: x_result_type := po_validations.c_result_type_failure;

2897: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',
2898: p_column_val => p_secondary_unit_of_meas_tbl(i),
2899: p_message_name => 'PO_SECONDARY_UOM_NOT_REQUIRED',
2900: p_validation_id => l_validation_id);
2901: x_result_type := po_validations.c_result_type_failure;
2902: END IF;
2903:
2904: IF l_secondary_unit_of_meas_tbl(i) IS NULL THEN
2905: IF (p_secondary_unit_of_meas_tbl(i) IS NOT NULL) THEN

Line 2907: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN

2903:
2904: IF l_secondary_unit_of_meas_tbl(i) IS NULL THEN
2905: IF (p_secondary_unit_of_meas_tbl(i) IS NOT NULL) THEN
2906: -- Item is not dual control
2907: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2908: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2909: ELSE
2910: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2911: END IF;

Line 2918: x_result_type := po_validations.c_result_type_failure;

2914: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',
2915: p_column_val => p_secondary_unit_of_meas_tbl(i),
2916: p_message_name => 'PO_SECONDARY_UOM_NOT_REQUIRED',
2917: p_validation_id => l_validation_id);
2918: x_result_type := po_validations.c_result_type_failure;
2919: END IF;
2920: ELSE -- l_secondary_unit_of_measure is not null
2921: IF p_secondary_unit_of_meas_tbl(i) IS NULL THEN
2922: -- Secondary UOM missing for dual control item

Line 2923: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN

2919: END IF;
2920: ELSE -- l_secondary_unit_of_measure is not null
2921: IF p_secondary_unit_of_meas_tbl(i) IS NULL THEN
2922: -- Secondary UOM missing for dual control item
2923: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2924: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_not_null;
2925: ELSE
2926: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_not_null;
2927: END IF;

Line 2934: x_result_type := po_validations.c_result_type_failure;

2930: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',
2931: p_column_val => p_secondary_unit_of_meas_tbl(i),
2932: p_message_name => 'PO_SECONDARY_UOM_REQUIRED',
2933: p_validation_id => l_validation_id);
2934: x_result_type := po_validations.c_result_type_failure;
2935: END IF;
2936:
2937: IF l_secondary_unit_of_meas_tbl(i) <> p_secondary_unit_of_meas_tbl(i) THEN
2938: -- Secondary UOM specified is incorrect.

Line 2939: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN

2935: END IF;
2936:
2937: IF l_secondary_unit_of_meas_tbl(i) <> p_secondary_unit_of_meas_tbl(i) THEN
2938: -- Secondary UOM specified is incorrect.
2939: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2940: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_correct;
2941: ELSE
2942: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_correct;
2943: END IF;

Line 2950: x_result_type := po_validations.c_result_type_failure;

2946: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',
2947: p_column_val => p_secondary_unit_of_meas_tbl(i),
2948: p_message_name => 'PO_INCORRECT_SECONDARY_UOM',
2949: p_validation_id => l_validation_id);
2950: x_result_type := po_validations.c_result_type_failure;
2951: END IF;
2952: END IF;
2953: END LOOP;
2954:

Line 2956: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2952: END IF;
2953: END LOOP;
2954:
2955: IF (SQL%ROWCOUNT > 0) THEN
2956: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2957: END IF;
2958:
2959: IF PO_LOG.d_proc THEN
2960: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 3015: x_result_type := po_validations.c_result_type_success;

3011: IF (x_results IS NULL) THEN
3012: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3013: END IF;
3014:
3015: x_result_type := po_validations.c_result_type_success;
3016:
3017: l_secondary_unit_of_meas_tbl.extend(p_item_id_tbl.COUNT);
3018:
3019: l_secondary_unit_of_meas_tbl := get_item_secondary_uom(p_item_id_tbl,

Line 3026: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN

3022:
3023: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3024: IF p_order_type_lookup_code_tbl(i) IN ('FIXED PRICE', 'RATE') AND
3025: p_secondary_quantity_tbl(i) IS NOT NULL THEN
3026: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3027: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_null;
3028: ELSE
3029: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_null;
3030: END IF;

Line 3037: x_result_type := po_validations.c_result_type_failure;

3033: p_column_name => 'SECONDARY_QUANTITY',
3034: p_column_val => p_secondary_quantity_tbl(i),
3035: p_message_name => 'PO_SVC_NO_QTY',
3036: p_validation_id => l_validation_id);
3037: x_result_type := po_validations.c_result_type_failure;
3038: END IF;
3039:
3040: d_position := 20;
3041:

Line 3046: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN

3042: IF p_order_type_lookup_code_tbl(i) NOT IN ('FIXED PRICE', 'RATE') AND
3043: p_secondary_quantity_tbl(i) IS NOT NULL AND
3044: p_secondary_quantity_tbl(i) < 0
3045: THEN
3046: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3047: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_ge_zero;
3048: ELSE
3049: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_ge_zero;
3050: END IF;

Line 3057: x_result_type := po_validations.c_result_type_failure;

3053: p_column_name => 'SECONDARY_QUANTITY',
3054: p_column_val => p_secondary_quantity_tbl(i),
3055: p_message_name => 'PO_PDOI_LT_ZERO',
3056: p_validation_id => l_validation_id);
3057: x_result_type := po_validations.c_result_type_failure;
3058: END IF;
3059:
3060: d_position := 30;
3061:

Line 3066: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN

3062: IF p_doc_type = 'STANDARD' AND
3063: p_secondary_quantity_tbl(i) IS NOT NULL AND
3064: p_secondary_quantity_tbl(i) = 0
3065: THEN
3066: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3067: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_zero;
3068: ELSE
3069: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_zero;
3070: END IF;

Line 3077: x_result_type := po_validations.c_result_type_failure;

3073: p_column_name => 'SECONDARY_QUANTITY',
3074: p_column_val => p_secondary_quantity_tbl(i),
3075: p_message_name => 'PO_PDOI_QTY_ZERO',
3076: p_validation_id => l_validation_id);
3077: x_result_type := po_validations.c_result_type_failure;
3078: END IF;
3079:
3080: d_position := 40;
3081:

Line 3088: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN

3084: IF ((p_create_or_update_item_flag = 'Y' AND p_item_id_tbl(i) IS NULL AND p_item_tbl(i) IS NULL) OR
3085: (p_create_or_update_item_flag = 'N' AND p_item_id_tbl(i) IS NULL )) AND
3086: p_secondary_quantity_tbl(i) IS NOT NULL AND
3087: p_doc_type IN ('STANDARD', 'BLANKET') THEN
3088: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3089: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_reqd;
3090: ELSE
3091: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_reqd;
3092: END IF;

Line 3099: x_result_type := po_validations.c_result_type_failure;

3095: p_column_name => 'SECONDARY_QUANTITY',
3096: p_column_val => p_secondary_quantity_tbl(i),
3097: p_message_name => 'PO_SECONDARY_QTY_NOT_REQUIRED',
3098: p_validation_id => l_validation_id);
3099: x_result_type := po_validations.c_result_type_failure;
3100: END IF;
3101:
3102: d_position := 50;
3103:

Line 3110: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN

3106: d_position := 60;
3107:
3108: IF p_secondary_quantity_tbl(i) IS NOT NULL AND p_doc_type IN ('STANDARD', 'BLANKET') THEN
3109: -- Item is not dual control
3110: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3111: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_no_req_uom;
3112: ELSE
3113: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_req_uom;
3114: END IF;

Line 3121: x_result_type := po_validations.c_result_type_failure;

3117: p_column_name => 'SECONDARY_QUANTITY',
3118: p_column_val => p_secondary_quantity_tbl(i),
3119: p_message_name => 'PO_SECONDARY_QTY_NOT_REQUIRED',
3120: p_validation_id => l_validation_id);
3121: x_result_type := po_validations.c_result_type_failure;
3122: END IF;
3123: ELSE -- l_secondary_unit_of_measure is not null
3124:
3125: d_position := 70;

Line 3129: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN

3125: d_position := 70;
3126:
3127: IF p_secondary_quantity_tbl(i) IS NULL AND p_doc_type='STANDARD' THEN
3128: -- Secondary Quantity missing for dual control item
3129: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3130: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_req_uom;
3131: ELSE
3132: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_req_uom;
3133: END IF;

Line 3140: x_result_type := po_validations.c_result_type_failure;

3136: p_column_name => 'SECONDARY_QUANTITY',
3137: p_column_val => p_secondary_quantity_tbl(i),
3138: p_message_name => 'PO_SECONDARY_QTY_REQUIRED',
3139: p_validation_id => l_validation_id);
3140: x_result_type := po_validations.c_result_type_failure;
3141: END IF;
3142: END IF;
3143: END LOOP;
3144:

Line 3148: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3144:
3145: d_position := 80;
3146:
3147: IF (SQL%ROWCOUNT > 0) THEN
3148: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3149: END IF;
3150:
3151: IF PO_LOG.d_proc THEN
3152: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

3189: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3190: END IF;
3191:
3192: IF x_result_set_id IS NULL THEN
3193: x_result_set_id := po_validations.next_result_set_id();
3194: END IF;
3195:
3196: x_result_type := po_validations.c_result_type_success;
3197:

Line 3196: x_result_type := po_validations.c_result_type_success;

3192: IF x_result_set_id IS NULL THEN
3193: x_result_set_id := po_validations.next_result_set_id();
3194: END IF;
3195:
3196: x_result_type := po_validations.c_result_type_success;
3197:
3198: FORALL i IN 1 .. p_id_tbl.COUNT
3199: INSERT INTO po_validation_results_gt
3200: (result_set_id,

Line 3213: po_validations.c_result_type_failure,

3209: token1_value,
3210: token2_value,
3211: token3_value)
3212: SELECT x_result_set_id,
3213: po_validations.c_result_type_failure,
3214: p_entity_type,
3215: p_id_tbl(i),
3216: 'PO_PDOI_ITEM_RELATED_INFO',
3217: 'SECONDARY_UNIT_OF_MEASURE',

Line 3236: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3232: AND msi.organization_id = p_organization_id_tbl(i)
3233: AND p_secondary_unit_of_meas_tbl(i) <> msi.secondary_uom_code);
3234:
3235: IF (SQL%ROWCOUNT > 0) THEN
3236: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3237: END IF;
3238:
3239: IF PO_LOG.d_proc THEN
3240: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 3240: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

3236: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3237: END IF;
3238:
3239: IF PO_LOG.d_proc THEN
3240: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3241: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3242: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3243: END IF;
3244:

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

3287: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3288: END IF;
3289:
3290: IF x_result_set_id IS NULL THEN
3291: x_result_set_id := po_validations.next_result_set_id();
3292: END IF;
3293:
3294: IF (x_results IS NULL) THEN
3295: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 3298: x_result_type := po_validations.c_result_type_success;

3294: IF (x_results IS NULL) THEN
3295: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3296: END IF;
3297:
3298: x_result_type := po_validations.c_result_type_success;
3299: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3300: -- for one time item , error out..
3301: -- x_item is not derived for existing items..
3302: IF ((p_create_or_update_item_flag = 'Y' AND p_item_id_tbl(i) IS NULL AND p_item_tbl(i) IS NULL) OR

Line 3316: x_result_type := po_validations.c_result_type_failure;

3312: p_column_name => 'PREFERRED_GRADE',
3313: p_column_val => p_preferred_grade_tbl(i),
3314: p_message_name => 'PO_ITEM_NOT_GRADE_CTRL',
3315: p_validation_id => l_validation_id);
3316: x_result_type := po_validations.c_result_type_failure;
3317: END IF;
3318: END LOOP;
3319:
3320: FORALL i IN 1 .. p_id_tbl.COUNT

Line 3331: po_validations.c_result_type_failure,

3327: column_name,
3328: column_val,
3329: validation_id)
3330: SELECT x_result_set_id,
3331: po_validations.c_result_type_failure,
3332: p_entity_type,
3333: p_id_tbl(i),
3334: 'PO_ITEM_NOT_GRADE_CTRL',
3335: 'PREFERRED_GRADE',

Line 3351: x_result_type := po_validations.c_result_type_failure;

3347: AND msi.organization_id = p_organization_id_tbl(i)
3348: AND nvl(msi.grade_control_flag,'N') = 'N');
3349:
3350: IF (SQL%ROWCOUNT > 0) THEN
3351: x_result_type := po_validations.c_result_type_failure;
3352: END IF;
3353:
3354: FORALL i IN 1 .. p_id_tbl.COUNT
3355: INSERT INTO po_validation_results_gt

Line 3365: po_validations.c_result_type_failure,

3361: column_name,
3362: column_val,
3363: validation_id)
3364: SELECT x_result_set_id,
3365: po_validations.c_result_type_failure,
3366: p_entity_type,
3367: p_id_tbl(i),
3368: 'PO_INVALID_GRADE_CODE',
3369: 'PREFERRED_GRADE',

Line 3383: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3379: WHERE mgb.grade_code = p_preferred_grade_tbl(i) AND
3380: mgb.disable_flag = 'N');
3381:
3382: IF (SQL%ROWCOUNT > 0) THEN
3383: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3384: END IF;
3385:
3386: IF PO_LOG.d_proc THEN
3387: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 3387: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

3383: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3384: END IF;
3385:
3386: IF PO_LOG.d_proc THEN
3387: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3388: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3389: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3390: END IF;
3391:

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

3418: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3419: END IF;
3420:
3421: IF x_result_set_id IS NULL THEN
3422: x_result_set_id := po_validations.next_result_set_id();
3423: END IF;
3424:
3425: x_result_type := po_validations.c_result_type_success;
3426:

Line 3425: x_result_type := po_validations.c_result_type_success;

3421: IF x_result_set_id IS NULL THEN
3422: x_result_set_id := po_validations.next_result_set_id();
3423: END IF;
3424:
3425: x_result_type := po_validations.c_result_type_success;
3426:
3427: -- check if ship to org is process. Currently we don't support OSP items for process orgs.
3428: FORALL i IN 1 .. p_id_tbl.COUNT
3429: INSERT INTO po_validation_results_gt

Line 3438: po_validations.c_result_type_failure,

3434: message_name,
3435: column_name,
3436: column_val)
3437: SELECT x_result_set_id,
3438: po_validations.c_result_type_failure,
3439: p_entity_type,
3440: p_id_tbl(i),
3441: 'PO_OPS_ITEM_PROCESS_ORG',
3442: 'SHIP_TO_ORGANIZATION_ID',

Line 3458: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3454: AND msi.outside_operation_flag = 'Y'
3455: AND mp.process_enabled_flag = 'Y');
3456:
3457: IF (SQL%ROWCOUNT > 0) THEN
3458: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3459: END IF;
3460:
3461: IF PO_LOG.d_proc THEN
3462: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 3462: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

3458: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3459: END IF;
3460:
3461: IF PO_LOG.d_proc THEN
3462: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3463: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3464: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3465: END IF;
3466:

Line 3620: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3616: END IF;
3617: END LOOP;
3618:
3619: IF (l_results_count < x_results.result_type.COUNT) THEN
3620: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3621: ELSE
3622: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3623: END IF;
3624:

Line 3622: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3618:
3619: IF (l_results_count < x_results.result_type.COUNT) THEN
3620: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3621: ELSE
3622: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3623: END IF;
3624:
3625: IF PO_LOG.d_proc THEN
3626: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);