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: ---------------------------------------------------------------------------
21: -- Modules for debugging.
22: ---------------------------------------------------------------------------

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

149: -- A new object will be created if NULL is passed in.
150: --OUT:
151: --x_result_type
152: -- Indicates if any validations have failed.
153: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
154: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
155: --End of Comments
156: -------------------------------------------------------------------------------
157: PROCEDURE greater_than_zero(

Line 154: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

150: --OUT:
151: --x_result_type
152: -- Indicates if any validations have failed.
153: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
154: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
155: --End of Comments
156: -------------------------------------------------------------------------------
157: PROCEDURE greater_than_zero(
158: p_calling_module IN VARCHAR2

Line 219: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

215: END IF;
216: END LOOP;
217:
218: IF (l_results_count < x_results.result_type.COUNT) THEN
219: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
220: ELSE
221: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
222: END IF;
223:

Line 221: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

217:
218: IF (l_results_count < x_results.result_type.COUNT) THEN
219: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
220: ELSE
221: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
222: END IF;
223:
224: IF PO_LOG.d_proc THEN
225: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

268: -- A new object will be created if NULL is passed in.
269: --OUT:
270: --x_result_type
271: -- Indicates if any validations have failed.
272: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
273: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
274: --End of Comments
275: -------------------------------------------------------------------------------
276: PROCEDURE greater_or_equal_zero(

Line 273: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

269: --OUT:
270: --x_result_type
271: -- Indicates if any validations have failed.
272: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
273: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
274: --End of Comments
275: -------------------------------------------------------------------------------
276: PROCEDURE greater_or_equal_zero(
277: p_calling_module IN VARCHAR2,

Line 360: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

356: END IF;
357: END LOOP;
358:
359: IF (l_results_count < x_results.result_type.COUNT) THEN
360: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
361: ELSE
362: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
363: END IF;
364:

Line 362: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

358:
359: IF (l_results_count < x_results.result_type.COUNT) THEN
360: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
361: ELSE
362: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
363: END IF;
364:
365: IF PO_LOG.d_proc THEN
366: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

413: -- A new object will be created if NULL is passed in.
414: --OUT:
415: --x_result_type
416: -- Indicates if any validations have failed.
417: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
418: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
419: --End of Comments
420: -------------------------------------------------------------------------------
421: PROCEDURE within_percentage_range(

Line 418: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

414: --OUT:
415: --x_result_type
416: -- Indicates if any validations have failed.
417: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
418: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
419: --End of Comments
420: -------------------------------------------------------------------------------
421: PROCEDURE within_percentage_range(
422: p_calling_module IN VARCHAR2

Line 500: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

496: END IF;
497: END LOOP;
498:
499: IF (l_results_count < x_results.result_type.COUNT) THEN
500: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
501: ELSE
502: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
503: END IF;
504:

Line 502: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

498:
499: IF (l_results_count < x_results.result_type.COUNT) THEN
500: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
501: ELSE
502: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
503: END IF;
504:
505: IF PO_LOG.d_proc THEN
506: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

550: -- this identifier.
551: --OUT:
552: --x_result_type
553: -- Indicates if any validations have failed.
554: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
555: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
556: --End of Comments
557: -------------------------------------------------------------------------------
558: PROCEDURE open_period(

Line 555: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

551: --OUT:
552: --x_result_type
553: -- Indicates if any validations have failed.
554: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
555: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
556: --End of Comments
557: -------------------------------------------------------------------------------
558: PROCEDURE open_period(
559: p_calling_module IN VARCHAR2

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

585: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
586: END IF;
587:
588: IF (x_result_set_id IS NULL) THEN
589: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
590: END IF;
591:
592: FND_PROFILE.get(PO_PROFILES.PO_CHECK_OPEN_PERIODS,l_profile_value);
593:

Line 594: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

590: END IF;
591:
592: FND_PROFILE.get(PO_PROFILES.PO_CHECK_OPEN_PERIODS,l_profile_value);
593:
594: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
595:
596: IF PO_LOG.d_stmt THEN
597: PO_LOG.stmt(d_mod,0,'l_profile_value',l_profile_value);
598: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);

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

602: IF (l_profile_value = 'Y') THEN
603:
604: /* Bug# 6671185: Added the condition "p_date_tbl(i) IS NOT NULL".
605: * This is to ensure that validation do not fail if p_date_tbl(i) is NULL.
606: * Also, moved the call to "PO_VALIDATIONS.log_validation_results_gt" inside
607: * the for loop, so that all the validation errors are captured.
608: */
609: FOR i IN 1 .. p_date_tbl.COUNT LOOP
610: IF p_date_tbl(i) IS NOT NULL THEN

Line 651: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

647: )
648: ;
649:
650: IF(SQL%ROWCOUNT > 0) THEN
651: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
652: END IF;
653:
654: IF PO_LOG.d_proc THEN
655: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

651: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
652: END IF;
653:
654: IF PO_LOG.d_proc THEN
655: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
656: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
657: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
658: PO_LOG.proc_end(p_calling_module);
659: END IF;

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

700: -- A new object will be created if NULL is passed in.
701: --OUT:
702: --x_result_type
703: -- Indicates if any validations have failed.
704: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
705: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
706: --End of Comments
707: -------------------------------------------------------------------------------
708: PROCEDURE not_null(

Line 705: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

701: --OUT:
702: --x_result_type
703: -- Indicates if any validations have failed.
704: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
705: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
706: --End of Comments
707: -------------------------------------------------------------------------------
708: PROCEDURE not_null(
709: p_calling_module IN VARCHAR2,

Line 779: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

775: END IF;
776: END LOOP;
777:
778: IF (l_results_count < x_results.result_type.COUNT) THEN
779: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
780: ELSE
781: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
782: END IF;
783:

Line 781: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

777:
778: IF (l_results_count < x_results.result_type.COUNT) THEN
779: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
780: ELSE
781: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
782: END IF;
783:
784: IF PO_LOG.d_proc THEN
785: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

824: -- A new object will be created if NULL is passed in.
825: --OUT:
826: --x_result_type
827: -- Indicates if any validations have failed.
828: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
829: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
830: --End of Comments
831: -------------------------------------------------------------------------------
832: PROCEDURE ensure_null(p_calling_module IN VARCHAR2,

Line 829: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

825: --OUT:
826: --x_result_type
827: -- Indicates if any validations have failed.
828: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
829: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
830: --End of Comments
831: -------------------------------------------------------------------------------
832: PROCEDURE ensure_null(p_calling_module IN VARCHAR2,
833: p_value_tbl IN PO_TBL_VARCHAR4000,

Line 898: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

894: END IF;
895: END LOOP;
896:
897: IF (l_results_count < x_results.result_type.COUNT) THEN
898: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
899: ELSE
900: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
901: END IF;
902:

Line 900: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

896:
897: IF (l_results_count < x_results.result_type.COUNT) THEN
898: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
899: ELSE
900: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
901: END IF;
902:
903: IF PO_LOG.d_proc THEN
904: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);

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

943: -- A new object will be created if NULL is passed in.
944: --OUT:
945: --x_result_type
946: -- Indicates if any validations have failed.
947: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
948: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
949: --End of Comments
950: -------------------------------------------------------------------------------
951: PROCEDURE flag_value_Y_N(p_calling_module IN VARCHAR2,

Line 948: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

944: --OUT:
945: --x_result_type
946: -- Indicates if any validations have failed.
947: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
948: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
949: --End of Comments
950: -------------------------------------------------------------------------------
951: PROCEDURE flag_value_Y_N(p_calling_module IN VARCHAR2,
952: p_flag_value_tbl IN PO_TBL_VARCHAR1,

Line 1017: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1013: END IF;
1014: END LOOP;
1015:
1016: IF (l_results_count < x_results.result_type.COUNT) THEN
1017: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1018: ELSE
1019: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1020: END IF;
1021:

Line 1019: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1015:
1016: IF (l_results_count < x_results.result_type.COUNT) THEN
1017: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1018: ELSE
1019: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1020: END IF;
1021:
1022: IF PO_LOG.d_proc THEN
1023: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);

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

1069: -- A new object will be created if NULL is passed in.
1070: --OUT:
1071: --x_result_type
1072: -- Indicates if any validations have failed.
1073: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1074: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1075: --End of Comments
1076: -------------------------------------------------------------------------------
1077: PROCEDURE gt_zero_order_type_filter(

Line 1074: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

1070: --OUT:
1071: --x_result_type
1072: -- Indicates if any validations have failed.
1073: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1074: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1075: --End of Comments
1076: -------------------------------------------------------------------------------
1077: PROCEDURE gt_zero_order_type_filter(
1078: p_calling_module IN VARCHAR2

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

1197: -- A new object will be created if NULL is passed in.
1198: --OUT:
1199: --x_result_type
1200: -- Indicates if any validations have failed.
1201: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1202: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1203: --End of Comments
1204: -------------------------------------------------------------------------------
1205: PROCEDURE no_timecards_exist(

Line 1202: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

1198: --OUT:
1199: --x_result_type
1200: -- Indicates if any validations have failed.
1201: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1202: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1203: --End of Comments
1204: -------------------------------------------------------------------------------
1205: PROCEDURE no_timecards_exist(
1206: p_calling_module IN VARCHAR2

Line 1350: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1346:
1347: END LOOP;
1348:
1349: IF (l_results_count < x_results.result_type.COUNT) THEN
1350: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1351: ELSE
1352: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1353: END IF;
1354:

Line 1352: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1348:
1349: IF (l_results_count < x_results.result_type.COUNT) THEN
1350: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1351: ELSE
1352: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1353: END IF;
1354:
1355: IF PO_LOG.d_proc THEN
1356: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

1396: -- this identifier.
1397: --OUT:
1398: --x_result_type
1399: -- Indicates if any validations have failed.
1400: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1401: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1402: --End of Comments
1403: -------------------------------------------------------------------------------
1404: PROCEDURE amount_notif_ctrl_warning(

Line 1401: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

1397: --OUT:
1398: --x_result_type
1399: -- Indicates if any validations have failed.
1400: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
1401: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
1402: --End of Comments
1403: -------------------------------------------------------------------------------
1404: PROCEDURE amount_notif_ctrl_warning(
1405: p_calling_module IN VARCHAR2

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

1426: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1427: END IF;
1428:
1429: IF (x_result_set_id IS NULL) THEN
1430: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1431: END IF;
1432:
1433: IF (p_quantity_tbl IS NULL) THEN
1434: l_quantity_flag := 'N';

Line 1453: , PO_VALIDATIONS.c_result_type_WARNING

1449: , message_name
1450: )
1451: SELECT
1452: x_result_set_id
1453: , PO_VALIDATIONS.c_result_type_WARNING
1454: , c_ENTITY_TYPE_LINE
1455: , p_line_id_tbl(i)
1456: , p_column_name
1457: , p_message_name

Line 1480: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;

1476: )
1477: ;
1478:
1479: IF (SQL%ROWCOUNT > 0) THEN
1480: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1481: ELSE
1482: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1483: END IF;
1484:

Line 1482: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1478:
1479: IF (SQL%ROWCOUNT > 0) THEN
1480: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1481: ELSE
1482: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1483: END IF;
1484:
1485: IF PO_LOG.d_proc THEN
1486: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

1482: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1483: END IF;
1484:
1485: IF PO_LOG.d_proc THEN
1486: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1487: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1488: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1489: PO_LOG.proc_end(p_calling_module);
1490: END IF;

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

1550: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1551: END IF;
1552:
1553: IF (x_result_set_id IS NULL) THEN
1554: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1555: END IF;
1556:
1557: ----------------------------------------------------------------------
1558: -- In order to check that the child number is unique

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

1591: -- Put the stored data for these ids into the temp table.
1592:
1593: l_data_key := PO_CORE_S.get_session_gt_nextval();
1594:
1595: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_DISTRIBUTION) THEN
1596:
1597: l_column_name := c_DISTRIBUTION_NUM;
1598: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_DIST_NUM;
1599:

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

1616: WHERE
1617: DIST.line_location_id = l_parent_id_tbl(i)
1618: ;
1619:
1620: ELSIF (p_entity_type = PO_VALIDATIONS.c_entity_type_LINE_LOCATION) THEN
1621:
1622: l_column_name := c_SHIPMENT_NUM;
1623: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_SHIP_NUM;
1624:

Line 1651: ELSE -- p_entity_type = PO_VALIDATIONS.c_entity_type_LINE

1647: AND ( LINE_LOC.payment_type IS NULL
1648: OR LINE_LOC.payment_type <> 'ADVANCE' )
1649: ;
1650:
1651: ELSE -- p_entity_type = PO_VALIDATIONS.c_entity_type_LINE
1652:
1653: l_column_name := c_LINE_NUM;
1654: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_LINE_NUM;
1655:

Line 1760: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1756: )
1757: ;
1758:
1759: IF (SQL%ROWCOUNT > 0) THEN
1760: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1761: ELSE
1762: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1763: END IF;
1764:

Line 1762: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1758:
1759: IF (SQL%ROWCOUNT > 0) THEN
1760: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1761: ELSE
1762: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1763: END IF;
1764:
1765: IF PO_LOG.d_proc THEN
1766: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);

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

1763: END IF;
1764:
1765: IF PO_LOG.d_proc THEN
1766: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1767: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1768: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1769: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1770: PO_LOG.proc_end(p_calling_module);
1771: END IF;

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

1819: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1820: END IF;
1821:
1822: IF (x_result_set_id IS NULL) THEN
1823: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1824: END IF;
1825:
1826: ----------------------------------------------------------------------
1827: -- See the discussion in child_num_unique for the

Line 1916: , PO_VALIDATIONS.c_entity_type_PRICE_DIFF

1912: , token1_value --bug #4956116
1913: )
1914: SELECT
1915: x_result_set_id
1916: , PO_VALIDATIONS.c_entity_type_PRICE_DIFF
1917: , CHILD.index_num2
1918: , p_column_name
1919: , CHILD.char1
1920: , p_message_name

Line 1941: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1937: )
1938: ;
1939:
1940: IF (SQL%ROWCOUNT > 0) THEN
1941: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1942: ELSE
1943: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1944: END IF;
1945:

Line 1943: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1939:
1940: IF (SQL%ROWCOUNT > 0) THEN
1941: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1942: ELSE
1943: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1944: END IF;
1945:
1946: IF PO_LOG.d_proc THEN
1947: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);

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

1944: END IF;
1945:
1946: IF PO_LOG.d_proc THEN
1947: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1948: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1949: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1950: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1951: PO_LOG.proc_end(p_calling_module);
1952: END IF;

Line 2037: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2033: END IF;
2034: END LOOP;
2035:
2036: IF (l_results_count < x_results.result_type.COUNT) THEN
2037: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2038: ELSE
2039: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2040: END IF;
2041:

Line 2039: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2035:
2036: IF (l_results_count < x_results.result_type.COUNT) THEN
2037: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2038: ELSE
2039: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2040: END IF;
2041:
2042: IF PO_LOG.d_proc THEN
2043: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2107: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2103: END IF;
2104: END LOOP;
2105:
2106: IF (l_results_count < x_results.result_type.COUNT) THEN
2107: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2108: ELSE
2109: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2110: END IF;
2111:

Line 2109: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2105:
2106: IF (l_results_count < x_results.result_type.COUNT) THEN
2107: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2108: ELSE
2109: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2110: END IF;
2111:
2112: IF PO_LOG.d_proc THEN
2113: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

2152: -- A new object will be created if NULL is passed in.
2153: --OUT:
2154: --x_result_type
2155: -- Indicates if any validations have failed.
2156: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2157: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2158: --End of Comments
2159: -------------------------------------------------------------------------------
2160: PROCEDURE zero(p_calling_module IN VARCHAR2,

Line 2157: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

2153: --OUT:
2154: --x_result_type
2155: -- Indicates if any validations have failed.
2156: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2157: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2158: --End of Comments
2159: -------------------------------------------------------------------------------
2160: PROCEDURE zero(p_calling_module IN VARCHAR2,
2161: p_value_tbl IN PO_TBL_NUMBER,

Line 2227: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2223: END IF;
2224: END LOOP;
2225:
2226: IF (l_results_count < x_results.result_type.COUNT) THEN
2227: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2228: ELSE
2229: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2230: END IF;
2231:

Line 2229: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2225:
2226: IF (l_results_count < x_results.result_type.COUNT) THEN
2227: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2228: ELSE
2229: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2230: END IF;
2231:
2232: IF PO_LOG.d_proc THEN
2233: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);

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

2268: -- this identifier.
2269: --OUT:
2270: --x_result_type
2271: -- Indicates if any validations have failed.
2272: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2273: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2274: --End of Comments
2275: -------------------------------------------------------------------------------
2276: PROCEDURE terms_id(p_calling_module IN VARCHAR2,

Line 2273: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

2269: --OUT:
2270: --x_result_type
2271: -- Indicates if any validations have failed.
2272: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2273: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2274: --End of Comments
2275: -------------------------------------------------------------------------------
2276: PROCEDURE terms_id(p_calling_module IN VARCHAR2,
2277: p_terms_id_tbl IN PO_TBL_NUMBER,

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

2284: d_mod CONSTANT VARCHAR2(100) := D_terms_id;
2285:
2286: BEGIN
2287: IF x_result_set_id IS NULL THEN
2288: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2289: END IF;
2290:
2291: IF PO_LOG.d_proc THEN
2292: PO_LOG.proc_begin(p_calling_module);

Line 2312: PO_VALIDATIONS.c_result_type_FAILURE,

2308: token1_name,
2309: token1_value,
2310: validation_id)
2311: SELECT x_result_set_id,
2312: PO_VALIDATIONS.c_result_type_FAILURE,
2313: p_entity_type,
2314: p_entity_id_tbl(i),
2315: 'PO_PDOI_INVALID_PAY_TERMS',
2316: 'TERMS_ID',

Line 2332: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2328: nvl(APT.start_date_active, sysdate - 1) AND
2329: nvl(APT.end_date_active, sysdate + 1)); -- END WHERE, FORALL
2330:
2331: IF (SQL%ROWCOUNT > 0) THEN
2332: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2333: ELSE
2334: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2335: END IF;
2336:

Line 2334: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2330:
2331: IF (SQL%ROWCOUNT > 0) THEN
2332: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2333: ELSE
2334: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2335: END IF;
2336:
2337: IF PO_LOG.d_proc THEN
2338: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

2334: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2335: END IF;
2336:
2337: IF PO_LOG.d_proc THEN
2338: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
2339: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2340: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2341: PO_LOG.proc_end(p_calling_module);
2342: END IF;

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

2380: -- A new object will be created if NULL is passed in.
2381: --OUT:
2382: --x_result_type
2383: -- Indicates if any validations have failed.
2384: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2385: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2386: --End of Comments
2387: -------------------------------------------------------------------------------
2388: PROCEDURE gt_zero_opm_filter(

Line 2385: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

2381: --OUT:
2382: --x_result_type
2383: -- Indicates if any validations have failed.
2384: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2385: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2386: --End of Comments
2387: -------------------------------------------------------------------------------
2388: PROCEDURE gt_zero_opm_filter(
2389: p_calling_module IN VARCHAR2

Line 2434: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2430:
2431: IF p_item_id_tbl is null OR
2432: p_inv_org_id_tbl is null
2433: THEN
2434: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2435: RETURN;
2436: END IF;
2437:
2438: FOR i IN 1 .. l_input_size LOOP

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

2523: -- A new object will be created if NULL is passed in.
2524: --OUT:
2525: --x_result_type
2526: -- Indicates if any validations have failed.
2527: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2528: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2529: --End of Comments
2530: -------------------------------------------------------------------------------
2531: PROCEDURE qtys_within_deviation(

Line 2528: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

2524: --OUT:
2525: --x_result_type
2526: -- Indicates if any validations have failed.
2527: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
2528: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2529: --End of Comments
2530: -------------------------------------------------------------------------------
2531: PROCEDURE qtys_within_deviation(
2532: p_calling_module IN VARCHAR2

Line 2577: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2573:
2574: IF p_item_id_tbl is null OR
2575: p_inv_org_id_tbl is null
2576: THEN
2577: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2578: RETURN;
2579: END IF;
2580:
2581: FOR i IN 1 .. l_input_count LOOP

Line 2629: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2625:
2626: END LOOP;
2627:
2628: IF (l_results_count < x_results.result_type.COUNT) THEN
2629: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2630: ELSE
2631: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2632: END IF;
2633:

Line 2631: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2627:
2628: IF (l_results_count < x_results.result_type.COUNT) THEN
2629: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2630: ELSE
2631: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2632: END IF;
2633:
2634: IF PO_LOG.d_proc THEN
2635: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2690: x_result_type := po_validations.c_result_type_success;

2686: IF (x_results IS NULL) THEN
2687: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2688: END IF;
2689:
2690: x_result_type := po_validations.c_result_type_success;
2691:
2692: l_secondary_unit_of_meas_tbl.extend(p_item_id_tbl.COUNT);
2693:
2694: l_secondary_unit_of_meas_tbl := get_item_secondary_uom(p_item_id_tbl,

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

2699: -- x_item is not derived for existing items..
2700: IF ((p_create_or_update_item_flag = 'Y' AND p_item_id_tbl(i) IS NULL AND p_item_tbl(i) IS NULL) OR
2701: (p_create_or_update_item_flag = 'N' and p_item_id_tbl(i) IS NULL)) AND
2702: p_secondary_unit_of_meas_tbl(i) IS NOT NULL THEN
2703: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2704: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2705: ELSE
2706: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2707: END IF;

Line 2714: x_result_type := po_validations.c_result_type_failure;

2710: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',
2711: p_column_val => p_secondary_unit_of_meas_tbl(i),
2712: p_message_name => 'PO_SECONDARY_UOM_NOT_REQUIRED',
2713: p_validation_id => l_validation_id);
2714: x_result_type := po_validations.c_result_type_failure;
2715: END IF;
2716:
2717: IF l_secondary_unit_of_meas_tbl(i) IS NULL THEN
2718: IF (p_secondary_unit_of_meas_tbl(i) IS NOT NULL) THEN

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

2716:
2717: IF l_secondary_unit_of_meas_tbl(i) IS NULL THEN
2718: IF (p_secondary_unit_of_meas_tbl(i) IS NOT NULL) THEN
2719: -- Item is not dual control
2720: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2721: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2722: ELSE
2723: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2724: END IF;

Line 2731: x_result_type := po_validations.c_result_type_failure;

2727: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',
2728: p_column_val => p_secondary_unit_of_meas_tbl(i),
2729: p_message_name => 'PO_SECONDARY_UOM_NOT_REQUIRED',
2730: p_validation_id => l_validation_id);
2731: x_result_type := po_validations.c_result_type_failure;
2732: END IF;
2733: ELSE -- l_secondary_unit_of_measure is not null
2734: IF p_secondary_unit_of_meas_tbl(i) IS NULL THEN
2735: -- Secondary UOM missing for dual control item

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

2732: END IF;
2733: ELSE -- l_secondary_unit_of_measure is not null
2734: IF p_secondary_unit_of_meas_tbl(i) IS NULL THEN
2735: -- Secondary UOM missing for dual control item
2736: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2737: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_not_null;
2738: ELSE
2739: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_not_null;
2740: END IF;

Line 2747: x_result_type := po_validations.c_result_type_failure;

2743: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',
2744: p_column_val => p_secondary_unit_of_meas_tbl(i),
2745: p_message_name => 'PO_SECONDARY_UOM_REQUIRED',
2746: p_validation_id => l_validation_id);
2747: x_result_type := po_validations.c_result_type_failure;
2748: END IF;
2749:
2750: IF l_secondary_unit_of_meas_tbl(i) <> p_secondary_unit_of_meas_tbl(i) THEN
2751: -- Secondary UOM specified is incorrect.

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

2748: END IF;
2749:
2750: IF l_secondary_unit_of_meas_tbl(i) <> p_secondary_unit_of_meas_tbl(i) THEN
2751: -- Secondary UOM specified is incorrect.
2752: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2753: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_correct;
2754: ELSE
2755: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_correct;
2756: END IF;

Line 2763: x_result_type := po_validations.c_result_type_failure;

2759: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',
2760: p_column_val => p_secondary_unit_of_meas_tbl(i),
2761: p_message_name => 'PO_INCORRECT_SECONDARY_UOM',
2762: p_validation_id => l_validation_id);
2763: x_result_type := po_validations.c_result_type_failure;
2764: END IF;
2765: END IF;
2766: END LOOP;
2767:

Line 2769: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2765: END IF;
2766: END LOOP;
2767:
2768: IF (SQL%ROWCOUNT > 0) THEN
2769: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2770: END IF;
2771:
2772: IF PO_LOG.d_proc THEN
2773: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2828: x_result_type := po_validations.c_result_type_success;

2824: IF (x_results IS NULL) THEN
2825: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2826: END IF;
2827:
2828: x_result_type := po_validations.c_result_type_success;
2829:
2830: l_secondary_unit_of_meas_tbl.extend(p_item_id_tbl.COUNT);
2831:
2832: l_secondary_unit_of_meas_tbl := get_item_secondary_uom(p_item_id_tbl,

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

2835:
2836: FOR i IN 1 .. p_id_tbl.COUNT LOOP
2837: IF p_order_type_lookup_code_tbl(i) IN ('FIXED PRICE', 'RATE') AND
2838: p_secondary_quantity_tbl(i) IS NOT NULL THEN
2839: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2840: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_null;
2841: ELSE
2842: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_null;
2843: END IF;

Line 2850: x_result_type := po_validations.c_result_type_failure;

2846: p_column_name => 'SECONDARY_QUANTITY',
2847: p_column_val => p_secondary_quantity_tbl(i),
2848: p_message_name => 'PO_SVC_NO_QTY',
2849: p_validation_id => l_validation_id);
2850: x_result_type := po_validations.c_result_type_failure;
2851: END IF;
2852:
2853: d_position := 20;
2854:

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

2855: IF p_order_type_lookup_code_tbl(i) NOT IN ('FIXED PRICE', 'RATE') AND
2856: p_secondary_quantity_tbl(i) IS NOT NULL AND
2857: p_secondary_quantity_tbl(i) < 0
2858: THEN
2859: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2860: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_ge_zero;
2861: ELSE
2862: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_ge_zero;
2863: END IF;

Line 2870: x_result_type := po_validations.c_result_type_failure;

2866: p_column_name => 'SECONDARY_QUANTITY',
2867: p_column_val => p_secondary_quantity_tbl(i),
2868: p_message_name => 'PO_PDOI_LT_ZERO',
2869: p_validation_id => l_validation_id);
2870: x_result_type := po_validations.c_result_type_failure;
2871: END IF;
2872:
2873: d_position := 30;
2874:

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

2875: IF p_doc_type = 'STANDARD' AND
2876: p_secondary_quantity_tbl(i) IS NOT NULL AND
2877: p_secondary_quantity_tbl(i) = 0
2878: THEN
2879: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2880: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_zero;
2881: ELSE
2882: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_zero;
2883: END IF;

Line 2890: x_result_type := po_validations.c_result_type_failure;

2886: p_column_name => 'SECONDARY_QUANTITY',
2887: p_column_val => p_secondary_quantity_tbl(i),
2888: p_message_name => 'PO_PDOI_QTY_ZERO',
2889: p_validation_id => l_validation_id);
2890: x_result_type := po_validations.c_result_type_failure;
2891: END IF;
2892:
2893: d_position := 40;
2894:

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

2897: IF ((p_create_or_update_item_flag = 'Y' AND p_item_id_tbl(i) IS NULL AND p_item_tbl(i) IS NULL) OR
2898: (p_create_or_update_item_flag = 'N' AND p_item_id_tbl(i) IS NULL )) AND
2899: p_secondary_quantity_tbl(i) IS NOT NULL AND
2900: p_doc_type IN ('STANDARD', 'BLANKET') THEN
2901: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2902: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_reqd;
2903: ELSE
2904: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_reqd;
2905: END IF;

Line 2912: x_result_type := po_validations.c_result_type_failure;

2908: p_column_name => 'SECONDARY_QUANTITY',
2909: p_column_val => p_secondary_quantity_tbl(i),
2910: p_message_name => 'PO_SECONDARY_QTY_NOT_REQUIRED',
2911: p_validation_id => l_validation_id);
2912: x_result_type := po_validations.c_result_type_failure;
2913: END IF;
2914:
2915: d_position := 50;
2916:

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

2919: d_position := 60;
2920:
2921: IF p_secondary_quantity_tbl(i) IS NOT NULL AND p_doc_type IN ('STANDARD', 'BLANKET') THEN
2922: -- Item is not dual control
2923: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2924: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_no_req_uom;
2925: ELSE
2926: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_req_uom;
2927: END IF;

Line 2934: x_result_type := po_validations.c_result_type_failure;

2930: p_column_name => 'SECONDARY_QUANTITY',
2931: p_column_val => p_secondary_quantity_tbl(i),
2932: p_message_name => 'PO_SECONDARY_QTY_NOT_REQUIRED',
2933: p_validation_id => l_validation_id);
2934: x_result_type := po_validations.c_result_type_failure;
2935: END IF;
2936: ELSE -- l_secondary_unit_of_measure is not null
2937:
2938: d_position := 70;

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

2938: d_position := 70;
2939:
2940: IF p_secondary_quantity_tbl(i) IS NULL AND p_doc_type='STANDARD' THEN
2941: -- Secondary Quantity missing for dual control item
2942: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2943: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_req_uom;
2944: ELSE
2945: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_req_uom;
2946: END IF;

Line 2953: x_result_type := po_validations.c_result_type_failure;

2949: p_column_name => 'SECONDARY_QUANTITY',
2950: p_column_val => p_secondary_quantity_tbl(i),
2951: p_message_name => 'PO_SECONDARY_QTY_REQUIRED',
2952: p_validation_id => l_validation_id);
2953: x_result_type := po_validations.c_result_type_failure;
2954: END IF;
2955: END IF;
2956: END LOOP;
2957:

Line 2961: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2957:
2958: d_position := 80;
2959:
2960: IF (SQL%ROWCOUNT > 0) THEN
2961: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2962: END IF;
2963:
2964: IF PO_LOG.d_proc THEN
2965: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

3002: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3003: END IF;
3004:
3005: IF x_result_set_id IS NULL THEN
3006: x_result_set_id := po_validations.next_result_set_id();
3007: END IF;
3008:
3009: x_result_type := po_validations.c_result_type_success;
3010:

Line 3009: x_result_type := po_validations.c_result_type_success;

3005: IF x_result_set_id IS NULL THEN
3006: x_result_set_id := po_validations.next_result_set_id();
3007: END IF;
3008:
3009: x_result_type := po_validations.c_result_type_success;
3010:
3011: FORALL i IN 1 .. p_id_tbl.COUNT
3012: INSERT INTO po_validation_results_gt
3013: (result_set_id,

Line 3026: po_validations.c_result_type_failure,

3022: token1_value,
3023: token2_value,
3024: token3_value)
3025: SELECT x_result_set_id,
3026: po_validations.c_result_type_failure,
3027: p_entity_type,
3028: p_id_tbl(i),
3029: 'PO_PDOI_ITEM_RELATED_INFO',
3030: 'SECONDARY_UNIT_OF_MEASURE',

Line 3049: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3045: AND msi.organization_id = p_organization_id_tbl(i)
3046: AND p_secondary_unit_of_meas_tbl(i) <> msi.secondary_uom_code);
3047:
3048: IF (SQL%ROWCOUNT > 0) THEN
3049: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3050: END IF;
3051:
3052: IF PO_LOG.d_proc THEN
3053: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

3049: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3050: END IF;
3051:
3052: IF PO_LOG.d_proc THEN
3053: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3054: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3055: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3056: END IF;
3057:

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

3100: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3101: END IF;
3102:
3103: IF x_result_set_id IS NULL THEN
3104: x_result_set_id := po_validations.next_result_set_id();
3105: END IF;
3106:
3107: IF (x_results IS NULL) THEN
3108: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 3111: x_result_type := po_validations.c_result_type_success;

3107: IF (x_results IS NULL) THEN
3108: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3109: END IF;
3110:
3111: x_result_type := po_validations.c_result_type_success;
3112: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3113: -- for one time item , error out..
3114: -- x_item is not derived for existing items..
3115: 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 3129: x_result_type := po_validations.c_result_type_failure;

3125: p_column_name => 'PREFERRED_GRADE',
3126: p_column_val => p_preferred_grade_tbl(i),
3127: p_message_name => 'PO_ITEM_NOT_GRADE_CTRL',
3128: p_validation_id => l_validation_id);
3129: x_result_type := po_validations.c_result_type_failure;
3130: END IF;
3131: END LOOP;
3132:
3133: FORALL i IN 1 .. p_id_tbl.COUNT

Line 3144: po_validations.c_result_type_failure,

3140: column_name,
3141: column_val,
3142: validation_id)
3143: SELECT x_result_set_id,
3144: po_validations.c_result_type_failure,
3145: p_entity_type,
3146: p_id_tbl(i),
3147: 'PO_ITEM_NOT_GRADE_CTRL',
3148: 'PREFERRED_GRADE',

Line 3164: x_result_type := po_validations.c_result_type_failure;

3160: AND msi.organization_id = p_organization_id_tbl(i)
3161: AND nvl(msi.grade_control_flag,'N') = 'N');
3162:
3163: IF (SQL%ROWCOUNT > 0) THEN
3164: x_result_type := po_validations.c_result_type_failure;
3165: END IF;
3166:
3167: FORALL i IN 1 .. p_id_tbl.COUNT
3168: INSERT INTO po_validation_results_gt

Line 3178: po_validations.c_result_type_failure,

3174: column_name,
3175: column_val,
3176: validation_id)
3177: SELECT x_result_set_id,
3178: po_validations.c_result_type_failure,
3179: p_entity_type,
3180: p_id_tbl(i),
3181: 'PO_INVALID_GRADE_CODE',
3182: 'PREFERRED_GRADE',

Line 3196: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3192: WHERE mgb.grade_code = p_preferred_grade_tbl(i) AND
3193: mgb.disable_flag = 'N');
3194:
3195: IF (SQL%ROWCOUNT > 0) THEN
3196: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3197: END IF;
3198:
3199: IF PO_LOG.d_proc THEN
3200: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

3196: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3197: END IF;
3198:
3199: IF PO_LOG.d_proc THEN
3200: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3201: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3202: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3203: END IF;
3204:

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

3231: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3232: END IF;
3233:
3234: IF x_result_set_id IS NULL THEN
3235: x_result_set_id := po_validations.next_result_set_id();
3236: END IF;
3237:
3238: x_result_type := po_validations.c_result_type_success;
3239:

Line 3238: x_result_type := po_validations.c_result_type_success;

3234: IF x_result_set_id IS NULL THEN
3235: x_result_set_id := po_validations.next_result_set_id();
3236: END IF;
3237:
3238: x_result_type := po_validations.c_result_type_success;
3239:
3240: -- check if ship to org is process. Currently we don't support OSP items for process orgs.
3241: FORALL i IN 1 .. p_id_tbl.COUNT
3242: INSERT INTO po_validation_results_gt

Line 3251: po_validations.c_result_type_failure,

3247: message_name,
3248: column_name,
3249: column_val)
3250: SELECT x_result_set_id,
3251: po_validations.c_result_type_failure,
3252: p_entity_type,
3253: p_id_tbl(i),
3254: 'PO_OPS_ITEM_PROCESS_ORG',
3255: 'SHIP_TO_ORGANIZATION_ID',

Line 3271: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3267: AND msi.outside_operation_flag = 'Y'
3268: AND mp.process_enabled_flag = 'Y');
3269:
3270: IF (SQL%ROWCOUNT > 0) THEN
3271: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3272: END IF;
3273:
3274: IF PO_LOG.d_proc THEN
3275: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);

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

3271: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3272: END IF;
3273:
3274: IF PO_LOG.d_proc THEN
3275: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3276: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3277: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3278: END IF;
3279:

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

3381: -- A new object will be created if NULL is passed in.
3382: --OUT:
3383: --x_result_type
3384: -- Indicates if any validations have failed.
3385: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
3386: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
3387: --End of Comments
3388: -------------------------------------------------------------------------------
3389: PROCEDURE validate_desc_flex (

Line 3386: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.

3382: --OUT:
3383: --x_result_type
3384: -- Indicates if any validations have failed.
3385: -- PO_VALIDATIONS.c_result_type_SUCCESS - no failures.
3386: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
3387: --End of Comments
3388: -------------------------------------------------------------------------------
3389: PROCEDURE validate_desc_flex (
3390: p_calling_module IN VARCHAR2,

Line 3447: x_result_type := po_validations.c_result_type_success;

3443: IF (x_results IS NULL) THEN
3444: x_results := po_validation_results_type.new_instance();
3445: END IF;
3446:
3447: x_result_type := po_validations.c_result_type_success;
3448:
3449: -- Loop through all the ids
3450: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3451: -- Set attribute category (context) and all attribute values

Line 3481: x_result_type := po_validations.c_result_type_failure;

3477: p_token1_name => c_dff_name,
3478: p_token1_value => p_desc_flex_name,
3479: p_token2_name => c_segment_num,
3480: p_token2_value => FND_FLEX_DESCVAL.error_segment);
3481: x_result_type := po_validations.c_result_type_failure;
3482: END IF;
3483:
3484: END LOOP;
3485: