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

Line 5: c_ENTITY_TYPE_LINE_LOCATION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE_LOCATION;

1: PACKAGE BODY PO_VAL_SHIPMENTS AS
2: -- $Header: PO_VAL_SHIPMENTS.plb 120.24.12020000.4 2013/04/03 22:32:45 rarajar ship $
3:
4:
5: c_ENTITY_TYPE_LINE_LOCATION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE_LOCATION;
6: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE;
7:
8: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
9: c_RATE CONSTANT VARCHAR2(30) := 'RATE';

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

2: -- $Header: PO_VAL_SHIPMENTS.plb 120.24.12020000.4 2013/04/03 22:32:45 rarajar ship $
3:
4:
5: c_ENTITY_TYPE_LINE_LOCATION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE_LOCATION;
6: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE;
7:
8: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
9: c_RATE CONSTANT VARCHAR2(30) := 'RATE';
10: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

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

278: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
279: END IF;
280:
281: IF (x_result_set_id IS NULL) THEN
282: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
283: END IF;
284:
285: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
286:

Line 285: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

281: IF (x_result_set_id IS NULL) THEN
282: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
283: END IF;
284:
285: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
286:
287: l_input_size := p_line_loc_id_tbl.COUNT;
288:
289: l_line_loc_id_tbl := PO_TBL_NUMBER();

Line 334: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

330: )
331: ;
332:
333: IF (SQL%ROWCOUNT > 0) THEN
334: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
335: END IF;
336:
337: END IF;
338:

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

336:
337: END IF;
338:
339: IF PO_LOG.d_proc THEN
340: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
341: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
342: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
343: END IF;
344:

Line 406: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

402: END IF;
403: END LOOP;
404:
405: IF (l_results_count < x_results.result_type.COUNT) THEN
406: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
407: ELSE
408: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
409: END IF;
410:

Line 408: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

404:
405: IF (l_results_count < x_results.result_type.COUNT) THEN
406: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
407: ELSE
408: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
409: END IF;
410:
411: IF PO_LOG.d_proc THEN
412: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 861: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

857:
858: END LOOP;
859:
860: IF (l_results_count < x_results.result_type.COUNT) THEN
861: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
862: ELSE
863: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
864: END IF;
865:

Line 863: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

859:
860: IF (l_results_count < x_results.result_type.COUNT) THEN
861: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
862: ELSE
863: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
864: END IF;
865:
866: IF PO_LOG.d_proc THEN
867: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

1021: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1022: END IF;
1023:
1024: IF (x_result_set_id IS NULL) THEN
1025: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1026: END IF;
1027:
1028:
1029: FORALL i IN 1 .. p_line_loc_id_tbl.COUNT

Line 1085: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1081: NVL(PLL.quantity_financed, 0))
1082: ;
1083:
1084: IF (SQL%ROWCOUNT > 0) THEN
1085: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1086: ELSE
1087: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1088: END IF;
1089:

Line 1087: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1083:
1084: IF (SQL%ROWCOUNT > 0) THEN
1085: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1086: ELSE
1087: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1088: END IF;
1089:
1090: IF PO_LOG.d_proc THEN
1091: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

1087: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1088: END IF;
1089:
1090: IF PO_LOG.d_proc THEN
1091: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1092: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1093: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1094: END IF;
1095:

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

1249: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1250: END IF;
1251:
1252: IF (x_result_set_id IS NULL) THEN
1253: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1254: END IF;
1255:
1256: FORALL i IN 1 .. p_line_loc_id_tbl.COUNT
1257: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 1310: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1306: NVL(PLL.amount_financed, 0))
1307: ;
1308:
1309: IF (SQL%ROWCOUNT > 0) THEN
1310: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1311: ELSE
1312: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1313: END IF;
1314:

Line 1312: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1308:
1309: IF (SQL%ROWCOUNT > 0) THEN
1310: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1311: ELSE
1312: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1313: END IF;
1314:
1315: IF PO_LOG.d_proc THEN
1316: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

1312: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1313: END IF;
1314:
1315: IF PO_LOG.d_proc THEN
1316: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1317: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1318: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1319: END IF;
1320:

Line 1477: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1473: END LOOP;
1474:
1475: -- Bug 5532560 START
1476: IF (l_results_count < x_results.result_type.COUNT) THEN
1477: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1478: ELSE
1479: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1480: END IF;
1481:

Line 1479: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1475: -- Bug 5532560 START
1476: IF (l_results_count < x_results.result_type.COUNT) THEN
1477: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1478: ELSE
1479: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1480: END IF;
1481:
1482: IF PO_LOG.d_proc THEN
1483: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

1509: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
1510: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1511: END IF;
1512: IF (x_result_set_id IS NULL) THEN
1513: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1514: END IF;
1515:
1516: FORALL i IN 1..p_line_loc_id_tbl.COUNT
1517: INSERT INTO po_validation_results_gt

Line 1539: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1535: WHERE line_location_id = p_line_loc_id_tbl(i)
1536: AND quantity > quantity_received);
1537:
1538: IF (SQL%ROWCOUNT > 0) THEN
1539: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1540: ELSE
1541: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1542: END IF;
1543:

Line 1541: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1537:
1538: IF (SQL%ROWCOUNT > 0) THEN
1539: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1540: ELSE
1541: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1542: END IF;
1543:
1544:
1545: IF PO_LOG.d_proc THEN

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

1542: END IF;
1543:
1544:
1545: IF PO_LOG.d_proc THEN
1546: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1547: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1548: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1549: END IF;
1550:

Line 1573: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1569: l_results_count NUMBER;
1570: BEGIN
1571:
1572: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1573: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1574: RETURN;
1575: END IF;
1576:
1577: IF (x_results IS NULL) THEN

Line 1599: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1595: END IF;
1596: END LOOP;
1597:
1598: IF (l_results_count < x_results.result_type.COUNT) THEN
1599: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1600: ELSE
1601: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1602: PO_VALIDATION_HELPER.start_date_le_end_date
1603: (

Line 1601: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1597:
1598: IF (l_results_count < x_results.result_type.COUNT) THEN
1599: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1600: ELSE
1601: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1602: PO_VALIDATION_HELPER.start_date_le_end_date
1603: (
1604: p_calling_module => D_start_date_le_end_date
1605: , p_start_date_tbl => p_start_date_tbl

Line 1635: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1631: l_results_count NUMBER;
1632: BEGIN
1633:
1634: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1635: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1636: RETURN;
1637: END IF;
1638:
1639: IF (x_results IS NULL) THEN

Line 1661: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1657: END IF;
1658: END LOOP;
1659:
1660: IF (l_results_count < x_results.result_type.COUNT) THEN
1661: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1662: ELSE
1663: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1664: END IF;
1665:

Line 1663: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1659:
1660: IF (l_results_count < x_results.result_type.COUNT) THEN
1661: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1662: ELSE
1663: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1664: END IF;
1665:
1666: EXCEPTION WHEN OTHERS THEN
1667: RAISE;