eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_LINES dependencies on PO_VALIDATIONS

Line 4: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE;

1: PACKAGE BODY po_val_lines AS
2: -- $Header: PO_VAL_LINES.plb 120.42.12020000.13 2013/05/08 14:43:06 akyanama ship $
3:
4: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE;
5:
6: c_RATE CONSTANT VARCHAR2(30) := 'RATE';
7: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
8: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

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

388: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
389: END IF;
390:
391: IF (x_result_set_id IS NULL) THEN
392: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
393: END IF;
394:
395: FORALL i IN 1 .. p_line_id_tbl.COUNT
396: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 462: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

458: AND p_quantity_tbl(i) < POLL_TOTAL.qty_executed
459: ;
460:
461: IF (SQL%ROWCOUNT > 0) THEN
462: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
463: ELSE
464: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
465: END IF;
466:

Line 464: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

460:
461: IF (SQL%ROWCOUNT > 0) THEN
462: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
463: ELSE
464: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
465: END IF;
466:
467: IF PO_LOG.d_proc THEN
468: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

464: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
465: END IF;
466:
467: IF PO_LOG.d_proc THEN
468: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
469: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
470: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
471: END IF;
472:

Line 530: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

526: END IF;
527: END LOOP;
528:
529: IF (l_results_count < x_results.result_type.COUNT) THEN
530: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
531: ELSE
532: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
533: END IF;
534: END IF;

Line 532: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

528:
529: IF (l_results_count < x_results.result_type.COUNT) THEN
530: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
531: ELSE
532: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
533: END IF;
534: END IF;
535:
536: END advance_amt_le_amt;

Line 661: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

657: END IF;
658: END LOOP;
659:
660: IF (l_results_count < x_results.result_type.COUNT) THEN
661: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
662: ELSE
663: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
664: END IF;
665: END IF;

Line 663: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

659:
660: IF (l_results_count < x_results.result_type.COUNT) THEN
661: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
662: ELSE
663: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
664: END IF;
665: END IF;
666:
667: END complex_po_attributes_check;

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

689: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
690: END IF;
691:
692: IF (x_result_set_id IS NULL) THEN
693: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
694: END IF;
695:
696: /* Bug#11782846 : Unable to change Price in Modification */
697: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

Line 697: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

693: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
694: END IF;
695:
696: /* Bug#11782846 : Unable to change Price in Modification */
697: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
698:
699: FOR i IN 1 .. p_line_id_tbl.Count LOOP
700: l_is_clm_po := PO_CLM_INTG_GRP.Is_clm_po(p_po_line_id => p_line_id_tbl(i));
701:

Line 743: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

739: AND p_quantity_tbl(i) < DIST_TOTAL.quantity_encumbered
740: ;
741:
742: IF (SQL%ROWCOUNT > 0) THEN
743: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
744: END IF;
745: END IF;
746: END LOOP;
747:

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

745: END IF;
746: END LOOP;
747:
748: IF PO_LOG.d_proc THEN
749: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
750: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
751: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
752: END IF;
753:

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

858:
859: d_progress := 10.0;
860:
861: IF (x_result_set_id IS NULL) THEN
862: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
863: END IF;
864:
865: d_progress := 20.0;
866:

Line 997: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

993:
994: d_progress := 50.0;
995:
996: IF (SQL%ROWCOUNT > 0) THEN
997: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
998: ELSE
999: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1000: END IF;
1001:

Line 999: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

995:
996: IF (SQL%ROWCOUNT > 0) THEN
997: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
998: ELSE
999: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1000: END IF;
1001:
1002: d_progress := 60.0;
1003:

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

1001:
1002: d_progress := 60.0;
1003:
1004: IF PO_LOG.d_proc THEN
1005: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1006: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1007: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1008: END IF;
1009:

Line 1129: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1125:
1126: END LOOP;
1127:
1128: IF (l_results_count < x_results.result_type.COUNT) THEN
1129: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1130: ELSE
1131: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1132: END IF;
1133:

Line 1131: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1127:
1128: IF (l_results_count < x_results.result_type.COUNT) THEN
1129: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1130: ELSE
1131: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1132: END IF;
1133:
1134: IF PO_LOG.d_proc THEN
1135: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

1245: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1246: END IF;
1247:
1248: IF (x_result_set_id IS NULL) THEN
1249: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1250: END IF;
1251:
1252: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1253:

Line 1252: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1248: IF (x_result_set_id IS NULL) THEN
1249: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1250: END IF;
1251:
1252: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1253:
1254: -- Get profile PO_VMI_DISPLAY_WARNING
1255: fnd_profile.get(PO_PROFILES.PO_VMI_DISPLAY_WARNING,l_po_vmi_display_warning);
1256:

Line 1271: , PO_VALIDATIONS.c_result_type_WARNING

1267: , message_name
1268: )
1269: SELECT
1270: x_result_set_id
1271: , PO_VALIDATIONS.c_result_type_WARNING
1272: , c_ENTITY_TYPE_LINE
1273: , p_line_id_tbl(i)
1274: , c_ITEM_ID
1275: , TO_CHAR(p_item_id_tbl(i))

Line 1304: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;

1300: WHERE paa2.asl_id = pasl.asl_id
1301: AND paa2.using_organization_id IN (-1, p_org_id_tbl(i)));
1302:
1303: IF (SQL%ROWCOUNT > 0) THEN
1304: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1305: END IF;
1306:
1307: END IF;
1308:

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

1306:
1307: END IF;
1308:
1309: IF PO_LOG.d_proc THEN
1310: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1311: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1312: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1313: END IF;
1314:

Line 1340: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1336: IS
1337: BEGIN
1338:
1339: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1340: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1341: RETURN;
1342: END IF;
1343:
1344: PO_VALIDATION_HELPER.start_date_le_end_date(

Line 1378: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1374: l_results_count NUMBER;
1375: BEGIN
1376:
1377: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1378: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1379: RETURN;
1380: END IF;
1381:
1382: IF (x_results IS NULL) THEN

Line 1420: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1416: , x_result_type => x_result_type
1417: );
1418:
1419: IF (l_results_count < x_results.result_type.COUNT) THEN
1420: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1421: ELSE
1422: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1423: END IF;
1424:

Line 1422: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1418:
1419: IF (l_results_count < x_results.result_type.COUNT) THEN
1420: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1421: ELSE
1422: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1423: END IF;
1424:
1425: EXCEPTION WHEN OTHERS THEN
1426: RAISE;

Line 1448: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1444: line_count NUMBER := 0;
1445: BEGIN
1446:
1447: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1448: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1449: RETURN;
1450: END IF;
1451:
1452: IF PO_LOG.d_proc THEN

Line 1499: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1495: END IF;
1496: END LOOP;
1497:
1498: IF (l_results_count < x_results.result_type.COUNT) THEN
1499: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1500: ELSE
1501: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1502: END IF;
1503:

Line 1501: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1497:
1498: IF (l_results_count < x_results.result_type.COUNT) THEN
1499: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1500: ELSE
1501: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1502: END IF;
1503:
1504: IF PO_LOG.d_proc THEN
1505: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 1530: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1526: l_results_count NUMBER;
1527: BEGIN
1528:
1529: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1530: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1531: RETURN;
1532: END IF;
1533:
1534: IF p_line_id_tbl IS not null

Line 1562: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1558: END IF;
1559: END LOOP;
1560:
1561: IF (l_results_count < x_results.result_type.COUNT) THEN
1562: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1563: ELSE
1564: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1565: END IF;
1566: END IF;

Line 1564: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1560:
1561: IF (l_results_count < x_results.result_type.COUNT) THEN
1562: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1563: ELSE
1564: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1565: END IF;
1566: END IF;
1567:
1568: END max_tot_amt_le_line_tot_amt;

Line 1585: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1581: l_results_count NUMBER;
1582: BEGIN
1583:
1584: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1585: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1586: RETURN;
1587: END IF;
1588:
1589: IF p_line_id_tbl IS not null

Line 1617: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1613: END IF;
1614: END LOOP;
1615:
1616: IF (l_results_count < x_results.result_type.COUNT) THEN
1617: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1618: ELSE
1619: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1620: END IF;
1621: END IF;

Line 1619: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1615:
1616: IF (l_results_count < x_results.result_type.COUNT) THEN
1617: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1618: ELSE
1619: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1620: END IF;
1621: END IF;
1622:
1623: END max_tot_amt_ge_min_tot_amt;

Line 1639: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1635: l_results_count NUMBER;
1636: BEGIN
1637:
1638: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1639: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1640: RETURN;
1641: END IF;
1642:
1643: IF p_line_id_tbl IS not null

Line 1671: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1667: END IF;
1668: END LOOP;
1669:
1670: IF (l_results_count < x_results.result_type.COUNT) THEN
1671: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1672: ELSE
1673: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1674: END IF;
1675: END IF;

Line 1673: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1669:
1670: IF (l_results_count < x_results.result_type.COUNT) THEN
1671: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1672: ELSE
1673: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1674: END IF;
1675: END IF;
1676:
1677: END max_tot_qty_le_line_tot_qty;

Line 1694: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1690: l_results_count NUMBER;
1691: BEGIN
1692:
1693: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1694: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1695: RETURN;
1696: END IF;
1697:
1698: IF p_line_id_tbl IS not null

Line 1726: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1722: END IF;
1723: END LOOP;
1724:
1725: IF (l_results_count < x_results.result_type.COUNT) THEN
1726: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1727: ELSE
1728: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1729: END IF;
1730: END IF;

Line 1728: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1724:
1725: IF (l_results_count < x_results.result_type.COUNT) THEN
1726: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1727: ELSE
1728: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1729: END IF;
1730: END IF;
1731:
1732: END max_tot_qty_ge_min_tot_qty;

Line 1749: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1745: l_results_count NUMBER;
1746: BEGIN
1747:
1748: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1749: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1750: RETURN;
1751: END IF;
1752:
1753: IF p_line_id_tbl IS not null

Line 1781: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1777: END IF;
1778: END LOOP;
1779:
1780: IF (l_results_count < x_results.result_type.COUNT) THEN
1781: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1782: ELSE
1783: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1784: END IF;
1785: END IF;

Line 1783: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1779:
1780: IF (l_results_count < x_results.result_type.COUNT) THEN
1781: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1782: ELSE
1783: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1784: END IF;
1785: END IF;
1786:
1787: END max_ord_amt_le_max_tot_amt;

Line 1804: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1800: l_results_count NUMBER;
1801: BEGIN
1802:
1803: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1804: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1805: RETURN;
1806: END IF;
1807:
1808: IF p_line_id_tbl IS not null

Line 1836: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1832: END IF;
1833: END LOOP;
1834:
1835: IF (l_results_count < x_results.result_type.COUNT) THEN
1836: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1837: ELSE
1838: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1839: END IF;
1840: END IF;

Line 1838: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1834:
1835: IF (l_results_count < x_results.result_type.COUNT) THEN
1836: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1837: ELSE
1838: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1839: END IF;
1840: END IF;
1841:
1842: END max_ord_amt_ge_min_ord_amt;

Line 1858: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1854: l_results_count NUMBER;
1855: BEGIN
1856:
1857: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1858: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1859: RETURN;
1860: END IF;
1861:
1862: IF p_line_id_tbl IS not null

Line 1890: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1886: END IF;
1887: END LOOP;
1888:
1889: IF (l_results_count < x_results.result_type.COUNT) THEN
1890: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1891: ELSE
1892: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1893: END IF;
1894: END IF;

Line 1892: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1888:
1889: IF (l_results_count < x_results.result_type.COUNT) THEN
1890: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1891: ELSE
1892: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1893: END IF;
1894: END IF;
1895:
1896: END max_ord_qty_le_max_tot_qty;

Line 1913: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1909: l_results_count NUMBER;
1910: BEGIN
1911:
1912: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1913: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1914: RETURN;
1915: END IF;
1916:
1917: IF p_line_id_tbl IS not null

Line 1945: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1941: END IF;
1942: END LOOP;
1943:
1944: IF (l_results_count < x_results.result_type.COUNT) 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: END IF;

Line 1947: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1943:
1944: IF (l_results_count < x_results.result_type.COUNT) 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: END IF;
1950:
1951: END max_ord_qty_ge_min_ord_qty;

Line 2222: PO_VALIDATIONS.validate_unit_price_change(

2218: ;
2219:
2220: IF (l_line_id_tbl.COUNT > 0) THEN
2221:
2222: PO_VALIDATIONS.validate_unit_price_change(
2223: p_line_id_tbl => l_line_id_tbl
2224: , p_price_break_lookup_code_tbl => l_price_break_lookup_code_tbl
2225: , p_amount_changed_flag_tbl => l_amount_changed_flag_tbl ----
2226: , x_result_type => x_result_type

Line 2233: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2229: );
2230:
2231: ELSE
2232:
2233: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2234:
2235: END IF;
2236:
2237:

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

2235: END IF;
2236:
2237:
2238: IF PO_LOG.d_proc THEN
2239: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2240: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2241: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2242: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2243: END IF;

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

2415: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2416: END IF;
2417:
2418: IF (x_result_set_id IS NULL) THEN
2419: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2420: END IF;
2421:
2422: -- : Fill in the following messages
2423: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL

Line 2471: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2467: AND p_quantity_tbl(i) < POLL_TOTAL.max_qty_executed
2468: ;
2469:
2470: IF (SQL%ROWCOUNT > 0) THEN
2471: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2472: ELSE
2473: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2474: END IF;
2475:

Line 2473: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2469:
2470: IF (SQL%ROWCOUNT > 0) THEN
2471: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2472: ELSE
2473: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2474: END IF;
2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

2473: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2474: END IF;
2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2478: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2479: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2480: END IF;
2481:

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

2510: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2511: END IF;
2512:
2513: IF (x_result_set_id IS NULL) THEN
2514: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2515: END IF;
2516:
2517: -- : Fill in the following messages
2518: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL

Line 2559: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2555: AND p_price_tbl(i) < POLL_TOTAL.sum_price_executed
2556: ;
2557:
2558: IF (SQL%ROWCOUNT > 0) THEN
2559: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2560: ELSE
2561: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2562: END IF;
2563:

Line 2561: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2557:
2558: IF (SQL%ROWCOUNT > 0) THEN
2559: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2560: ELSE
2561: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2562: END IF;
2563:
2564: IF PO_LOG.d_proc THEN
2565: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

2561: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2562: END IF;
2563:
2564: IF PO_LOG.d_proc THEN
2565: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2566: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2567: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2568: END IF;
2569:

Line 2629: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2625: END IF;
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 2763: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

2759: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2760: END IF;
2761:
2762: IF (x_result_set_id IS NULL) THEN
2763: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2764: END IF;
2765:
2766: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2767:

Line 2766: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2762: IF (x_result_set_id IS NULL) THEN
2763: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2764: END IF;
2765:
2766: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2767:
2768: l_input_size := p_id_tbl.COUNT;
2769:
2770: l_id_tbl := PO_TBL_NUMBER();

Line 2820: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2816: AND PLT.outside_operation_flag = 'Y'
2817: ;
2818:
2819: IF (SQL%ROWCOUNT > 0) THEN
2820: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2821: END IF;
2822:
2823: END IF;
2824:

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

2822:
2823: END IF;
2824:
2825: IF PO_LOG.d_proc THEN
2826: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2827: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2828: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2829: END IF;
2830:

Line 2884: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2880: END IF;
2881: END LOOP;
2882:
2883: IF (l_results_count < x_results.result_type.COUNT) THEN
2884: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2885: ELSE
2886: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2887: END IF;
2888:

Line 2886: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2882:
2883: IF (l_results_count < x_results.result_type.COUNT) THEN
2884: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2885: ELSE
2886: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2887: END IF;
2888:
2889: IF PO_LOG.d_proc THEN
2890: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2955: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2951:
2952: END LOOP;
2953:
2954: IF (l_results_count < x_results.result_type.COUNT) THEN
2955: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2956: ELSE
2957: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2958: END IF;
2959:

Line 2957: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2953:
2954: IF (l_results_count < x_results.result_type.COUNT) THEN
2955: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2956: ELSE
2957: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2958: END IF;
2959:
2960: IF PO_LOG.d_proc THEN
2961: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 3068: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3064: END IF;
3065: END LOOP;
3066:
3067: IF (l_results_count < x_results.result_type.COUNT) THEN
3068: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3069: ELSE
3070: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3071: END IF;
3072:

Line 3070: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3066:
3067: IF (l_results_count < x_results.result_type.COUNT) THEN
3068: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3069: ELSE
3070: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3071: END IF;
3072:
3073: IF PO_LOG.d_proc THEN
3074: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 3284: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3280:
3281: END LOOP;
3282:
3283: IF (l_results_count < x_results.result_type.COUNT) THEN
3284: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3285: ELSE
3286: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3287: END IF;
3288:

Line 3286: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3282:
3283: IF (l_results_count < x_results.result_type.COUNT) THEN
3284: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3285: ELSE
3286: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3287: END IF;
3288:
3289: IF PO_LOG.d_proc THEN
3290: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

3353: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
3354: END IF;
3355:
3356: IF (x_result_set_id IS NULL) THEN
3357: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
3358: END IF;
3359:
3360: FORALL i IN 1 .. p_line_id_tbl.COUNT
3361: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 3396: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3392: p_max_retain_amt_tbl(i) < LOCATIONS_TOTAL.amount_retained
3393: ;
3394:
3395: IF (SQL%ROWCOUNT > 0) THEN
3396: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3397: ELSE
3398: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3399: END IF;
3400:

Line 3398: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3394:
3395: IF (SQL%ROWCOUNT > 0) THEN
3396: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3397: ELSE
3398: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3399: END IF;
3400:
3401: IF PO_LOG.d_proc THEN
3402: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

3398: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3399: END IF;
3400:
3401: IF PO_LOG.d_proc THEN
3402: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
3403: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3404: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
3405: END IF;
3406:

Line 3456: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3452: );
3453: END IF;
3454: END LOOP;
3455: IF (l_results_count < x_results.result_type.COUNT) THEN
3456: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3457: ELSE
3458: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3459: END IF;
3460:

Line 3458: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3454: END LOOP;
3455: IF (l_results_count < x_results.result_type.COUNT) THEN
3456: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3457: ELSE
3458: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3459: END IF;
3460:
3461: IF PO_LOG.d_proc THEN
3462: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 3516: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3512: END IF;
3513:
3514: END LOOP;
3515: IF (l_results_count < x_results.result_type.COUNT) THEN
3516: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3517: ELSE
3518: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3519: END IF;
3520: EXCEPTION WHEN OTHERS THEN

Line 3518: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3514: END LOOP;
3515: IF (l_results_count < x_results.result_type.COUNT) THEN
3516: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3517: ELSE
3518: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3519: END IF;
3520: EXCEPTION WHEN OTHERS THEN
3521: IF PO_LOG.d_exc THEN
3522: PO_LOG.exc(d_mod,0,NULL);

Line 3572: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3568: END IF;
3569: END IF;
3570: END LOOP;
3571: IF (l_results_count < x_results.result_type.COUNT) THEN
3572: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3573: ELSE
3574: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3575: END IF;
3576:

Line 3574: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3570: END LOOP;
3571: IF (l_results_count < x_results.result_type.COUNT) THEN
3572: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3573: ELSE
3574: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3575: END IF;
3576:
3577: IF PO_LOG.d_proc THEN
3578: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 3655: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3651: END IF;
3652: END IF;
3653: END LOOP;
3654: IF (l_results_count < x_results.result_type.COUNT) THEN
3655: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3656: ELSE
3657: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3658: END IF;
3659:

Line 3657: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3653: END LOOP;
3654: IF (l_results_count < x_results.result_type.COUNT) THEN
3655: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3656: ELSE
3657: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3658: END IF;
3659:
3660: IF PO_LOG.d_proc THEN
3661: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 3717: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3713: END IF;
3714: END IF;
3715: END LOOP;
3716: IF (l_results_count < x_results.result_type.COUNT) THEN
3717: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3718: ELSE
3719: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3720: END IF;
3721:

Line 3719: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3715: END LOOP;
3716: IF (l_results_count < x_results.result_type.COUNT) THEN
3717: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3718: ELSE
3719: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3720: END IF;
3721:
3722: IF PO_LOG.d_proc THEN
3723: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 3847: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3843:
3844: END LOOP;
3845:
3846: IF (l_results_count < x_results.result_type.COUNT) THEN
3847: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3848: ELSE
3849: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3850: END IF;
3851:

Line 3849: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3845:
3846: IF (l_results_count < x_results.result_type.COUNT) THEN
3847: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3848: ELSE
3849: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3850: END IF;
3851:
3852: IF PO_LOG.d_proc THEN
3853: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

3876: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
3877: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
3878: END IF;
3879: IF (x_result_set_id IS NULL) THEN
3880: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
3881: END IF;
3882:
3883: FORALL i IN 1..p_line_id_tbl.COUNT
3884: INSERT INTO po_validation_results_gt

Line 3906: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

3902: WHERE po_line_id = p_line_id_tbl(i)
3903: AND quantity > quantity_received);
3904:
3905: IF (SQL%ROWCOUNT > 0) THEN
3906: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3907: ELSE
3908: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3909: END IF;
3910:

Line 3908: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3904:
3905: IF (SQL%ROWCOUNT > 0) THEN
3906: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3907: ELSE
3908: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3909: END IF;
3910:
3911:
3912: IF PO_LOG.d_proc THEN

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

3909: END IF;
3910:
3911:
3912: IF PO_LOG.d_proc THEN
3913: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
3914: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3915: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
3916: END IF;
3917:

Line 3953: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

3949: BEGIN
3950: --
3951: -- skip the validation for non-CLM documents
3952: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
3953: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3954: RETURN;
3955: END IF;
3956:
3957: IF PO_LOG.d_proc THEN

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

3959: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
3960: END IF;
3961:
3962: IF (x_result_set_id IS NULL) THEN
3963: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
3964: END IF;
3965:
3966: -- Get a distinct list of parent ids.
3967: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_header_id_tbl;

Line 4057: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4053: AND SIBLING.index_num2 <> CHILD.index_num2 -- line_id
4054: );
4055:
4056: IF (SQL%ROWCOUNT > 0) THEN
4057: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4058: ELSE
4059: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4060: END IF;
4061:

Line 4059: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4055:
4056: IF (SQL%ROWCOUNT > 0) THEN
4057: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4058: ELSE
4059: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4060: END IF;
4061:
4062:
4063: -- validate SLIN numbers are in sync with CLIN numbers

Line 4090: IF (SQL%ROWCOUNT > 0 OR x_result_type = PO_VALIDATIONS.c_result_type_FAILURE)

4086: AND CLIN.index_num2 = SLIN.num1 -- CLIN.po_line_id = SLIN.group_line_id
4087: AND CLIN.char1 <> SUBSTR(SLIN.char1,0,4) -- line_num_display
4088: AND CLIN.index_char2 = c_NEW; -- check only new and modified CLINs
4089:
4090: IF (SQL%ROWCOUNT > 0 OR x_result_type = PO_VALIDATIONS.c_result_type_FAILURE)
4091: THEN
4092: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4093: ELSE
4094: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

Line 4092: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4088: AND CLIN.index_char2 = c_NEW; -- check only new and modified CLINs
4089:
4090: IF (SQL%ROWCOUNT > 0 OR x_result_type = PO_VALIDATIONS.c_result_type_FAILURE)
4091: THEN
4092: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4093: ELSE
4094: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4095: END IF;
4096:

Line 4094: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4090: IF (SQL%ROWCOUNT > 0 OR x_result_type = PO_VALIDATIONS.c_result_type_FAILURE)
4091: THEN
4092: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4093: ELSE
4094: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4095: END IF;
4096:
4097: IF PO_LOG.d_proc THEN
4098: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 4127: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4123: BEGIN
4124:
4125: -- skip the validation for non-CLM documents
4126: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
4127: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4128: RETURN;
4129: END IF;
4130:
4131: IF PO_LOG.d_proc THEN

Line 4173: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4169: l_results_count := l_results_count + l_line_count;
4170: END LOOP;
4171:
4172: IF l_results_count > 0 THEN
4173: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4174: ELSE
4175: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4176: END IF;
4177:

Line 4175: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4171:
4172: IF l_results_count > 0 THEN
4173: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4174: ELSE
4175: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4176: END IF;
4177:
4178: IF PO_LOG.d_proc THEN
4179: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 4208: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4204: BEGIN
4205:
4206: -- skip the validation for non-CLM documents
4207: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
4208: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4209: RETURN;
4210: END IF;
4211:
4212: IF PO_LOG.d_proc THEN

Line 4260: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4256: END IF;
4257: END LOOP;
4258:
4259: IF l_results_count > 0 THEN
4260: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4261: ELSE
4262: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4263: END IF;
4264:

Line 4262: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4258:
4259: IF l_results_count > 0 THEN
4260: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4261: ELSE
4262: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4263: END IF;
4264:
4265: IF PO_LOG.d_proc THEN
4266: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 4296: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4292: BEGIN
4293:
4294: -- skip the validation for non-CLM documents
4295: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
4296: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4297: RETURN;
4298: END IF;
4299:
4300: IF PO_LOG.d_proc THEN

Line 4334: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4330: END IF;
4331: END LOOP;
4332:
4333: IF l_results_count > 0 THEN
4334: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4335: ELSE
4336: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4337: END IF;
4338:

Line 4336: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4332:
4333: IF l_results_count > 0 THEN
4334: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4335: ELSE
4336: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4337: END IF;
4338:
4339: IF PO_LOG.d_proc THEN
4340: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 4370: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4366: BEGIN
4367:
4368: -- skip the validation for non-CLM documents
4369: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
4370: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4371: RETURN;
4372: END IF;
4373:
4374: IF PO_LOG.d_proc THEN

Line 4439: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4435: END;
4436: END IF;
4437: END LOOP;
4438: IF l_results_count > 0 THEN
4439: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4440: ELSE
4441: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4442: END IF;
4443:

Line 4441: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4437: END LOOP;
4438: IF l_results_count > 0 THEN
4439: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4440: ELSE
4441: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4442: END IF;
4443:
4444: IF PO_LOG.d_proc THEN
4445: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 4474: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4470: BEGIN
4471:
4472: -- skip the validation for non-CLM documents
4473: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
4474: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4475: RETURN;
4476: END IF;
4477:
4478: IF PO_LOG.d_proc THEN

Line 4505: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4501: END IF;
4502: END LOOP;
4503:
4504: IF l_results_count > 0 THEN
4505: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4506: ELSE
4507: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4508: END IF;
4509:

Line 4507: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4503:
4504: IF l_results_count > 0 THEN
4505: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4506: ELSE
4507: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4508: END IF;
4509:
4510: IF PO_LOG.d_proc THEN
4511: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 4542: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4538: BEGIN
4539:
4540: -- skip the validation for non-CLM documents
4541: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
4542: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4543: RETURN;
4544: END IF;
4545:
4546: IF PO_LOG.d_proc THEN

Line 4607: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4603: END IF;
4604: END LOOP;
4605:
4606: IF l_results_count > 0 THEN
4607: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4608: ELSE
4609: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4610: END IF;
4611:

Line 4609: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4605:
4606: IF l_results_count > 0 THEN
4607: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4608: ELSE
4609: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4610: END IF;
4611:
4612: IF PO_LOG.d_proc THEN
4613: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 4645: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4641: BEGIN
4642:
4643: -- skip the validation for non-CLM documents
4644: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
4645: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4646: RETURN;
4647: END IF;
4648:
4649: IF PO_LOG.d_proc THEN

Line 4703: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4699: END IF;
4700: END LOOP;
4701:
4702: IF l_results_count > 0 THEN
4703: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4704: ELSE
4705: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4706: END IF;
4707:

Line 4705: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4701:
4702: IF l_results_count > 0 THEN
4703: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4704: ELSE
4705: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4706: END IF;
4707:
4708: IF PO_LOG.d_proc THEN
4709: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 4738: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4734: BEGIN
4735:
4736: -- skip the validation for non-CLM documents
4737: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
4738: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4739: RETURN;
4740: END IF;
4741:
4742: IF PO_LOG.d_proc THEN

Line 4777: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4773: END IF;
4774: END LOOP;
4775:
4776: IF l_results_count > 0 THEN
4777: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4778: ELSE
4779: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4780: END IF;
4781:

Line 4779: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4775:
4776: IF l_results_count > 0 THEN
4777: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4778: ELSE
4779: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4780: END IF;
4781:
4782: IF PO_LOG.d_proc THEN
4783: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 4814: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4810: BEGIN
4811:
4812: -- skip the validation for non-CLM documents
4813: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
4814: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4815: RETURN;
4816: END IF;
4817:
4818: IF PO_LOG.d_proc THEN

Line 4861: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4857:
4858: END LOOP;
4859:
4860: IF l_results_count > 0 THEN
4861: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4862: ELSE
4863: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4864: END IF;
4865:

Line 4863: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4859:
4860: IF l_results_count > 0 THEN
4861: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4862: ELSE
4863: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4864: END IF;
4865:
4866: IF PO_LOG.d_proc THEN
4867: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 4934: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

4930: );
4931: END LOOP;
4932:
4933: IF l_intf_line_id_tbl.count > 0 THEN
4934: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4935: ELSE
4936: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4937: END IF;
4938: IF PO_LOG.d_proc THEN

Line 4936: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

4932:
4933: IF l_intf_line_id_tbl.count > 0 THEN
4934: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4935: ELSE
4936: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4937: END IF;
4938: IF PO_LOG.d_proc THEN
4939: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4940: END IF;

Line 5006: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

5002: );
5003: END LOOP;
5004:
5005: IF l_intf_line_id_tbl.count > 0 THEN
5006: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
5007: ELSE
5008: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5009: END IF;
5010: IF PO_LOG.d_proc THEN

Line 5008: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

5004:
5005: IF l_intf_line_id_tbl.count > 0 THEN
5006: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
5007: ELSE
5008: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5009: END IF;
5010: IF PO_LOG.d_proc THEN
5011: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5012: END IF;

Line 5069: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

5065: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
5066: PO_LOG.proc_begin(d_mod,'p_comments_tbl',p_comments_tbl);
5067: END IF;
5068:
5069: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5070:
5071: -- Return if the document is base document
5072: FOR i IN 1..p_draft_id_tbl.Count() LOOP
5073: IF p_draft_id_tbl(i) = -1 THEN

Line 5126: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

5122: BEGIN
5123: --
5124: -- skip the validation for non-CLM documents
5125: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
5126: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5127: RETURN;
5128: END IF;
5129:
5130: IF PO_LOG.d_proc THEN

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

5133: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
5134: END IF;
5135:
5136: IF (x_result_set_id IS NULL) THEN
5137: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
5138: END IF;
5139:
5140: FORALL i IN 1 .. p_line_id_tbl.COUNT
5141: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 5176: IF (SQL%ROWCOUNT > 0 OR x_result_type = PO_VALIDATIONS.c_result_type_FAILURE)

5172: AND p_exhibit_name_tbl(i) IS NOT NULL
5173: AND POL.PO_LINE_ID =p_line_id_tbl(i)
5174: AND POL.DRAFT_ID =p_draft_id_tbl(i) ;
5175:
5176: IF (SQL%ROWCOUNT > 0 OR x_result_type = PO_VALIDATIONS.c_result_type_FAILURE)
5177: THEN
5178: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
5179: ELSE
5180: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

Line 5178: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

5174: AND POL.DRAFT_ID =p_draft_id_tbl(i) ;
5175:
5176: IF (SQL%ROWCOUNT > 0 OR x_result_type = PO_VALIDATIONS.c_result_type_FAILURE)
5177: THEN
5178: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
5179: ELSE
5180: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5181: END IF;
5182:

Line 5180: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

5176: IF (SQL%ROWCOUNT > 0 OR x_result_type = PO_VALIDATIONS.c_result_type_FAILURE)
5177: THEN
5178: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
5179: ELSE
5180: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5181: END IF;
5182:
5183: IF PO_LOG.d_proc THEN
5184: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 5295: , p_entity_type => PO_VALIDATIONS.c_entity_type_LINE_UCAS

5291: p_calling_module => D_mod_undef_amt_le_line_amt
5292: , p_num1_tbl => l_undef_amt_tbl
5293: , p_num2_tbl => l_extended_price_tbl
5294: , p_entity_id_tbl => l_po_line_uca_id_tbl
5295: , p_entity_type => PO_VALIDATIONS.c_entity_type_LINE_UCAS
5296: , p_column_name => 'UNDEF_AMOUNT'
5297: , p_message_name => PO_MESSAGE_S.PO_UCA_UNDEF_LE_LINE_AMT
5298: , x_results => x_results
5299: , x_result_type => x_result_type);

Line 5307: , p_entity_type => PO_VALIDATIONS.c_entity_type_LINE_UCAS

5303: p_calling_module => D_mod_undef_amt_le_line_amt
5304: , p_num1_tbl => l_undef_amt_tbl
5305: , p_num2_tbl => l_extended_price_tbl
5306: , p_entity_id_tbl => l_po_line_uca_id_tbl
5307: , p_entity_type => PO_VALIDATIONS.c_entity_type_LINE_UCAS
5308: , p_column_name => 'UNDEF_AMOUNT'
5309: , p_message_name => 'PO_UCA_UNDEF_MOD_LE_LINE_AMT'
5310: , x_results => x_results
5311: , x_result_type => x_result_type);

Line 5316: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

5312: END IF;
5313: END IF;
5314:
5315: IF (l_results_count < x_results.result_type.COUNT) THEN
5316: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
5317: ELSE
5318: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5319: END IF;
5320:

Line 5318: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

5314:
5315: IF (l_results_count < x_results.result_type.COUNT) THEN
5316: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
5317: ELSE
5318: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5319: END IF;
5320:
5321: IF PO_LOG.d_proc THEN
5322: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);