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

Line 4: c_ENTITY_TYPE_DISTRIBUTION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_DISTRIBUTION;

1: PACKAGE BODY PO_VAL_DISTRIBUTIONS AS
2: -- $Header: PO_VAL_DISTRIBUTIONS.plb 120.23.12020000.10 2013/05/30 17:36:44 vpeddi ship $
3:
4: c_ENTITY_TYPE_DISTRIBUTION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_DISTRIBUTION;
5: c_NEW CONSTANT VARCHAR2(3) := 'NEW';
6: c_RATE CONSTANT VARCHAR2(30) := 'RATE';
7: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
8: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

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

248: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
249: END IF;
250:
251: IF (x_result_set_id IS NULL) THEN
252: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
253: END IF;
254:
255: FORALL i IN 1 .. p_dist_id_tbl.COUNT
256: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 309: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

305: NVL(POD.quantity_financed, 0))
306: ;
307:
308: IF (SQL%ROWCOUNT > 0) THEN
309: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
310: ELSE
311: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
312: END IF;
313:

Line 311: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

307:
308: IF (SQL%ROWCOUNT > 0) THEN
309: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
310: ELSE
311: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
312: END IF;
313:
314: IF PO_LOG.d_proc THEN
315: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

311: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
312: END IF;
313:
314: IF PO_LOG.d_proc THEN
315: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
316: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
317: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
318: END IF;
319:

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

400: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
401: END IF;
402:
403: IF (x_result_set_id IS NULL) THEN
404: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
405: END IF;
406:
407: FORALL i IN 1 .. p_dist_id_tbl.COUNT
408: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 459: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

455: NVL(POD.amount_financed, 0),
456: NVL(POD.amount_billed, 0));
457:
458: IF (SQL%ROWCOUNT > 0) THEN
459: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
460: ELSE
461: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
462: END IF;
463:

Line 461: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

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

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

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

Line 557: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

553:
554: END LOOP;
555:
556: IF (l_results_count < x_results.result_type.COUNT) THEN
557: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
558: ELSE
559: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
560: END IF;
561:

Line 559: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

555:
556: IF (l_results_count < x_results.result_type.COUNT) THEN
557: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
558: ELSE
559: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
560: END IF;
561:
562: IF PO_LOG.d_proc THEN
563: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 675: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

671:
672: END LOOP;
673:
674: IF (l_results_count < x_results.result_type.COUNT) THEN
675: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
676: ELSE
677: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
678: END IF;
679:

Line 677: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

673:
674: IF (l_results_count < x_results.result_type.COUNT) THEN
675: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
676: ELSE
677: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
678: END IF;
679:
680: IF PO_LOG.d_proc THEN
681: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 886: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

882: END LOOP;
883:
884:
885: IF (l_results_count < x_results.result_type.COUNT) THEN
886: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
887: ELSE
888: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
889: END IF;
890:

Line 888: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

884:
885: IF (l_results_count < x_results.result_type.COUNT) THEN
886: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
887: ELSE
888: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
889: END IF;
890:
891: END gl_enc_date_not_null_open;
892:

Line 952: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

948:
949: END IF; -- if is_gms_enabled
950:
951: IF (l_results_count < x_results.result_type.COUNT) THEN
952: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
953: ELSE
954: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
955: END IF;
956:

Line 954: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

950:
951: IF (l_results_count < x_results.result_type.COUNT) THEN
952: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
953: ELSE
954: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
955: END IF;
956:
957: END gms_data_valid;
958:

Line 1044: l_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1040:
1041:
1042: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1043: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1044: l_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1045: ELSE
1046: l_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1047: END IF;
1048:

Line 1046: l_result_type := PO_VALIDATIONS.c_result_type_WARNING;

1042: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1043: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1044: l_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1045: ELSE
1046: l_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1047: END IF;
1048:
1049: x_results.add_result(
1050: p_entity_type => c_entity_type_DISTRIBUTION

Line 1064: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;

1060: END LOOP;
1061:
1062: IF (l_results_count < x_results.result_type.COUNT) THEN
1063:
1064: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1065:
1066: FOR j IN 1..x_results.result_type.COUNT LOOP
1067: IF (x_results.result_type(j) = PO_VALIDATIONS.c_result_type_FAILURE)
1068: THEN

Line 1067: IF (x_results.result_type(j) = PO_VALIDATIONS.c_result_type_FAILURE)

1063:
1064: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1065:
1066: FOR j IN 1..x_results.result_type.COUNT LOOP
1067: IF (x_results.result_type(j) = PO_VALIDATIONS.c_result_type_FAILURE)
1068: THEN
1069: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1070: END IF;
1071: exit;

Line 1069: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1065:
1066: FOR j IN 1..x_results.result_type.COUNT LOOP
1067: IF (x_results.result_type(j) = PO_VALIDATIONS.c_result_type_FAILURE)
1068: THEN
1069: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1070: END IF;
1071: exit;
1072: END LOOP;
1073:

Line 1075: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1071: exit;
1072: END LOOP;
1073:
1074: ELSE
1075: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1076: END IF;
1077:
1078: IF PO_LOG.d_proc THEN
1079: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 1151: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1147:
1148: END LOOP;
1149:
1150: IF (l_results_count < x_results.result_type.COUNT) THEN
1151: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1152: ELSE
1153: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1154: END IF;
1155:

Line 1153: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1149:
1150: IF (l_results_count < x_results.result_type.COUNT) THEN
1151: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1152: ELSE
1153: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1154: END IF;
1155:
1156: IF PO_LOG.d_proc THEN
1157: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 1289: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1285: END IF;
1286: END LOOP;
1287:
1288: IF (l_results_count < x_results.result_type.COUNT) THEN
1289: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1290: ELSE
1291: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1292: END IF;
1293:

Line 1291: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1287:
1288: IF (l_results_count < x_results.result_type.COUNT) THEN
1289: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1290: ELSE
1291: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1292: END IF;
1293:
1294: IF PO_LOG.d_proc THEN
1295: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 1383: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1379:
1380: END LOOP;
1381:
1382: IF (l_results_count < x_results.result_type.COUNT) THEN
1383: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1384: ELSE
1385: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1386: END IF;
1387:

Line 1385: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1381:
1382: IF (l_results_count < x_results.result_type.COUNT) THEN
1383: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1384: ELSE
1385: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1386: END IF;
1387:
1388: IF PO_LOG.d_proc THEN
1389: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 1480: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1476:
1477: END LOOP;
1478:
1479: IF (l_results_count < x_results.result_type.COUNT) THEN
1480: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
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 (l_results_count < x_results.result_type.COUNT) THEN
1480: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
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_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 1569: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;

1565:
1566: END LOOP;
1567:
1568: IF (l_results_count < x_results.result_type.COUNT) THEN
1569: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1570: ELSE
1571: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1572: END IF;
1573:

Line 1571: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1567:
1568: IF (l_results_count < x_results.result_type.COUNT) THEN
1569: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1570: ELSE
1571: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1572: END IF;
1573:
1574: IF PO_LOG.d_proc THEN
1575: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 1729: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

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

Line 1731: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1727:
1728: IF (l_results_count < x_results.result_type.COUNT) THEN
1729: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1730: ELSE
1731: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1732: END IF;
1733:
1734: IF po_log.d_proc THEN
1735: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

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

1773: PO_LOG.proc_begin(d_mod);
1774: END IF;
1775:
1776: IF (x_result_set_id IS NULL) THEN
1777: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1778: END IF;
1779:
1780: ----------------------------------------------------------------------
1781: -- In order to check that the total funded value of Distributions

Line 1874: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1870: PRD.funds_remaining
1871: HAVING PRD.funds_remaining + Sum(Nvl(GT2.num2,0)) < Sum(Nvl(GT2.num1,0)));
1872:
1873: IF (SQL%ROWCOUNT > 0) THEN
1874: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1875: ELSE
1876: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1877: END IF;
1878:

Line 1876: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1872:
1873: IF (SQL%ROWCOUNT > 0) THEN
1874: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1875: ELSE
1876: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1877: END IF;
1878:
1879: IF PO_LOG.d_proc THEN
1880: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

1876: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1877: END IF;
1878:
1879: IF PO_LOG.d_proc THEN
1880: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1881: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1882: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1883: END IF;
1884:

Line 1959: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1955:
1956: --Validation has to skipped for new lines in PAR
1957: IF ((p_draft_type_tbl(i) = 'PAR' AND p_change_status_tbl(i)='NEW') OR
1958: p_draft_type_tbl(i) <>'PAR' OR p_draft_type_tbl(i) IS NULL ) THEN
1959: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1960: RETURN;
1961: END IF;
1962:
1963:

Line 1987: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1983: END IF;
1984: END LOOP;
1985:
1986: IF (l_results_count < x_results.result_type.COUNT) THEN
1987: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1988: ELSE
1989: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1990: END IF;
1991:

Line 1989: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1985:
1986: IF (l_results_count < x_results.result_type.COUNT) THEN
1987: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1988: ELSE
1989: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1990: END IF;
1991:
1992: END check_dist_values_inc_for_par;
1993:

Line 2019: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2015: BEGIN
2016:
2017: -- skip the validation for non-CLM documents
2018: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
2019: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2020: RETURN;
2021: END IF;
2022:
2023: IF PO_LOG.d_proc THEN

Line 2055: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2051:
2052: END LOOP;
2053:
2054: IF l_results_count > 0 THEN
2055: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2056: ELSE
2057: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2058: END IF;
2059:

Line 2057: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2053:
2054: IF l_results_count > 0 THEN
2055: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2056: ELSE
2057: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2058: END IF;
2059:
2060: IF PO_LOG.d_proc THEN
2061: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2090: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2086: BEGIN
2087:
2088: -- skip the validation for non-CLM documents
2089: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
2090: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2091: RETURN;
2092: END IF;
2093:
2094: IF PO_LOG.d_proc THEN

Line 2134: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2130: END;
2131: END IF;
2132: END LOOP;
2133: IF l_results_count > 0 THEN
2134: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2135: ELSE
2136: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2137: END IF;
2138: IF PO_LOG.d_proc THEN

Line 2136: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2132: END LOOP;
2133: IF l_results_count > 0 THEN
2134: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2135: ELSE
2136: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2137: END IF;
2138: IF PO_LOG.d_proc THEN
2139: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2140: END IF;

Line 2166: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2162: BEGIN
2163:
2164: -- skip the validation for non-CLM documents
2165: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
2166: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2167: RETURN;
2168: END IF;
2169:
2170: IF PO_LOG.d_proc THEN

Line 2210: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2206: );
2207: END LOOP;
2208:
2209: IF l_intf_dist_id_tbl.count > 0 THEN
2210: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2211: ELSE
2212: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2213: END IF;
2214: IF PO_LOG.d_proc THEN

Line 2212: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2208:
2209: IF l_intf_dist_id_tbl.count > 0 THEN
2210: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2211: ELSE
2212: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2213: END IF;
2214: IF PO_LOG.d_proc THEN
2215: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2216: END IF;