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_SHIPMENTS2 dependencies on STANDARD

Line 189: OR (p_doc_type = 'STANDARD' AND l_is_complex_work_style = FALSE AND p_shipment_type_tbl(i) <> 'STANDARD') THEN

185: p_validation_id => PO_VAL_CONSTANTS.c_shipment_type_not_null);
186: x_result_type := po_validations.c_result_type_failure;
187: ELSIF (p_doc_type = 'QUOTATION' AND p_shipment_type_tbl(i) <> 'QUOTATION')
188: OR (p_doc_type = 'BLANKET' AND p_shipment_type_tbl(i) <> 'PRICE BREAK')
189: OR (p_doc_type = 'STANDARD' AND l_is_complex_work_style = FALSE AND p_shipment_type_tbl(i) <> 'STANDARD') THEN
190: /* PDOI for Complex PO Project: Allow Other Shipment Types for Complex PO */
191: x_results.add_result(p_entity_type => c_entity_type_line_location,
192: p_entity_id => p_id_tbl(i),
193: p_column_name => 'SHIPMENT_TYPE',

Line 294: ((Nvl(p_payment_type_tbl(i),'MILESTONE') = 'ADVANCE' AND Nvl(p_shipment_type_tbl(i),'STANDARD') <> 'PREPAYMENT') OR

290: p_token1_value => p_style_id_tbl(i),
291: p_validation_id => PO_VAL_CONSTANTS.c_loc_payment_type);
292: x_result_type := po_validations.c_result_type_failure;
293: ELSIF (l_complex_work_flag = 'Y' AND
294: ((Nvl(p_payment_type_tbl(i),'MILESTONE') = 'ADVANCE' AND Nvl(p_shipment_type_tbl(i),'STANDARD') <> 'PREPAYMENT') OR
295: (Nvl(p_payment_type_tbl(i),'MILESTONE') = 'DELIVERY' AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') <> 'STANDARD'))) THEN
296: -- For a Complex PO shipment, if Payment type is ADVANCE, then Shipment type should be PREPAYMENT.
297: -- For a Complex PO shipment, if Payment type is DELIVERY, then Shipment type should be STANDARD.
298: x_results.add_result(p_entity_type => c_entity_type_line_location,

Line 295: (Nvl(p_payment_type_tbl(i),'MILESTONE') = 'DELIVERY' AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') <> 'STANDARD'))) THEN

291: p_validation_id => PO_VAL_CONSTANTS.c_loc_payment_type);
292: x_result_type := po_validations.c_result_type_failure;
293: ELSIF (l_complex_work_flag = 'Y' AND
294: ((Nvl(p_payment_type_tbl(i),'MILESTONE') = 'ADVANCE' AND Nvl(p_shipment_type_tbl(i),'STANDARD') <> 'PREPAYMENT') OR
295: (Nvl(p_payment_type_tbl(i),'MILESTONE') = 'DELIVERY' AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') <> 'STANDARD'))) THEN
296: -- For a Complex PO shipment, if Payment type is ADVANCE, then Shipment type should be PREPAYMENT.
297: -- For a Complex PO shipment, if Payment type is DELIVERY, then Shipment type should be STANDARD.
298: x_results.add_result(p_entity_type => c_entity_type_line_location,
299: p_entity_id => p_id_tbl(i),

Line 297: -- For a Complex PO shipment, if Payment type is DELIVERY, then Shipment type should be STANDARD.

293: ELSIF (l_complex_work_flag = 'Y' AND
294: ((Nvl(p_payment_type_tbl(i),'MILESTONE') = 'ADVANCE' AND Nvl(p_shipment_type_tbl(i),'STANDARD') <> 'PREPAYMENT') OR
295: (Nvl(p_payment_type_tbl(i),'MILESTONE') = 'DELIVERY' AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') <> 'STANDARD'))) THEN
296: -- For a Complex PO shipment, if Payment type is ADVANCE, then Shipment type should be PREPAYMENT.
297: -- For a Complex PO shipment, if Payment type is DELIVERY, then Shipment type should be STANDARD.
298: x_results.add_result(p_entity_type => c_entity_type_line_location,
299: p_entity_id => p_id_tbl(i),
300: p_column_name => 'SHIPMENT_TYPE',
301: p_column_val => p_shipment_type_tbl(i),

Line 330: AND ((l_financing_payments_flag = 'Y' AND Nvl(p_shipment_type_tbl(i),'STANDARD') = 'PREPAYMENT')

326: l_line_id := po_line_id_tbl(i);
327: l_payitem_exists := FALSE;
328: FOR i IN 1 .. p_id_tbl.COUNT LOOP
329: IF (po_line_id_tbl(i) = l_line_id AND Nvl(p_payment_type_tbl(i),'MILESTONE') <> 'ADVANCE'
330: AND ((l_financing_payments_flag = 'Y' AND Nvl(p_shipment_type_tbl(i),'STANDARD') = 'PREPAYMENT')
331: OR (l_financing_payments_flag = 'N' AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') = 'STANDARD'))) THEN
332: l_payitem_exists := TRUE;
333: END IF;
334: END LOOP;

Line 331: OR (l_financing_payments_flag = 'N' AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') = 'STANDARD'))) THEN

327: l_payitem_exists := FALSE;
328: FOR i IN 1 .. p_id_tbl.COUNT LOOP
329: IF (po_line_id_tbl(i) = l_line_id AND Nvl(p_payment_type_tbl(i),'MILESTONE') <> 'ADVANCE'
330: AND ((l_financing_payments_flag = 'Y' AND Nvl(p_shipment_type_tbl(i),'STANDARD') = 'PREPAYMENT')
331: OR (l_financing_payments_flag = 'N' AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') = 'STANDARD'))) THEN
332: l_payitem_exists := TRUE;
333: END IF;
334: END LOOP;
335:

Line 609: AND Nvl(p_shipment_type_tbl(i),'STANDARD') <> 'PREPAYMENT' AND p_quantity_tbl(i) IS NOT NULL THEN

605: l_is_financing_style := PO_COMPLEX_WORK_PVT.is_financing_payment_style(p_style_id => p_style_id_tbl(i));
606: /* PDOI for Complex PO Project: END */
607:
608: IF (p_order_type_lookup_code_tbl(i) = 'RATE' OR p_order_type_lookup_code_tbl(i) = 'FIXED PRICE')
609: AND Nvl(p_shipment_type_tbl(i),'STANDARD') <> 'PREPAYMENT' AND p_quantity_tbl(i) IS NOT NULL THEN
610: -- PDOI for Complex PO Project
611: x_results.add_result(p_entity_type => c_entity_type_line_location,
612: p_entity_id => p_id_tbl(i),
613: p_column_name => 'QUANTITY',

Line 633: ELSIF (l_is_financing_style AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') = 'STANDARD'

629: p_token2_value => p_quantity_tbl(i),
630: p_validation_id => PO_VAL_CONSTANTS.c_loc_quantity_ge_zero);
631: x_result_type := po_validations.c_result_type_failure;
632: --
633: ELSIF (l_is_financing_style AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') = 'STANDARD'
634: AND Nvl(p_payment_type_tbl(i),'MILESTONE') = 'DELIVERY'
635: AND Nvl(p_quantity_tbl(i),0) <> Nvl(p_line_quantity_tbl(i),0)) THEN
636: x_results.add_result(p_entity_type => c_entity_type_line_location,
637: p_entity_id => p_id_tbl(i),

Line 702: IF (l_is_financing_style AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') = 'STANDARD'

698:
699: l_is_financing_style := FALSE;
700: l_is_financing_style := PO_COMPLEX_WORK_PVT.is_financing_payment_style(p_style_id => p_style_id_tbl(i));
701:
702: IF (l_is_financing_style AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') = 'STANDARD'
703: AND Nvl(p_payment_type_tbl(i),'MILESTONE') = 'DELIVERY'
704: AND Nvl(p_amount_tbl(i),0) <> Nvl(p_line_amount_tbl(i),0)) THEN
705: x_results.add_result(p_entity_type => c_entity_type_line_location,
706: p_entity_id => p_id_tbl(i),

Line 797: ELSIF (l_is_financing_style AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') = 'STANDARD'

793: p_token2_value => p_price_override_tbl(i),
794: p_validation_id => PO_VAL_CONSTANTS.c_loc_price_override_ge_zero);
795: x_result_type := po_validations.c_result_type_failure;
796: --
797: ELSIF (l_is_financing_style AND Nvl(p_shipment_type_tbl(i),'PREPAYMENT') = 'STANDARD'
798: AND Nvl(p_payment_type_tbl(i),'MILESTONE') = 'DELIVERY'
799: AND Nvl(p_price_override_tbl(i),0) <> Nvl(p_line_unit_price_tbl(i),0)) THEN
800: x_results.add_result(p_entity_type => c_entity_type_line_location,
801: p_entity_id => p_id_tbl(i),

Line 1415: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal

1411: RAISE;
1412: END qty_rcv_exception_code;
1413:
1414: -------------------------------------------------------------------------
1415: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
1416: -- to NONE, REJECT or WARNING
1417: -------------------------------------------------------------------------
1418: PROCEDURE enforce_ship_to_loc_code(
1419: p_id_tbl IN po_tbl_number,

Line 1440: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal

1436: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1437: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1438: END IF;
1439:
1440: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
1441: -- to NONE, REJECT or WARNING
1442: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1443: IF ( p_shipment_type_tbl(i) = 'STANDARD'
1444: AND p_enforce_ship_to_loc_code_tbl(i) IS NOT NULL

Line 1443: IF ( p_shipment_type_tbl(i) = 'STANDARD'

1439:
1440: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
1441: -- to NONE, REJECT or WARNING
1442: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1443: IF ( p_shipment_type_tbl(i) = 'STANDARD'
1444: AND p_enforce_ship_to_loc_code_tbl(i) IS NOT NULL
1445: AND (p_enforce_ship_to_loc_code_tbl(i) NOT IN('NONE', 'REJECT', 'WARNING'))) THEN
1446: x_results.add_result(p_entity_type => c_entity_type_line_location,
1447: p_entity_id => p_id_tbl(i),

Line 1470: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal

1466: RAISE;
1467: END enforce_ship_to_loc_code;
1468:
1469: -------------------------------------------------------------------------
1470: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal
1471: -- to NONE, REJECT or WARNING
1472: -------------------------------------------------------------------------
1473: PROCEDURE allow_sub_receipts_flag(
1474: p_id_tbl IN po_tbl_number,

Line 1495: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not null and

1491: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1492: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1493: END IF;
1494:
1495: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not null and
1496: -- not equal to NONE, REJECT or WARNING
1497: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1498: IF p_shipment_type_tbl(i) = 'STANDARD' AND p_allow_sub_receipts_flag_tbl(i) IS NOT NULL
1499: AND p_allow_sub_receipts_flag_tbl(i) NOT IN('Y', 'N') THEN

Line 1498: IF p_shipment_type_tbl(i) = 'STANDARD' AND p_allow_sub_receipts_flag_tbl(i) IS NOT NULL

1494:
1495: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not null and
1496: -- not equal to NONE, REJECT or WARNING
1497: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1498: IF p_shipment_type_tbl(i) = 'STANDARD' AND p_allow_sub_receipts_flag_tbl(i) IS NOT NULL
1499: AND p_allow_sub_receipts_flag_tbl(i) NOT IN('Y', 'N') THEN
1500: x_results.add_result(p_entity_type => c_entity_type_line_location,
1501: p_entity_id => p_id_tbl(i),
1502: p_column_name => 'ALLOW_SUB_RECEIPTS_FLAG',

Line 1523: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null

1519: RAISE;
1520: END allow_sub_receipts_flag;
1521:
1522: -------------------------------------------------------------------------
1523: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
1524: -- and less than zero.
1525: -------------------------------------------------------------------------
1526: PROCEDURE days_early_receipt_allowed(
1527: p_id_tbl IN po_tbl_number,

Line 1548: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null

1544: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1545: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1546: END IF;
1547:
1548: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
1549: -- and less than zero.
1550: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1551: IF (p_shipment_type_tbl(i) = 'STANDARD'
1552: AND p_days_early_rcpt_allowed_tbl(i) IS NOT NULL

Line 1551: IF (p_shipment_type_tbl(i) = 'STANDARD'

1547:
1548: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
1549: -- and less than zero.
1550: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1551: IF (p_shipment_type_tbl(i) = 'STANDARD'
1552: AND p_days_early_rcpt_allowed_tbl(i) IS NOT NULL
1553: AND p_days_early_rcpt_allowed_tbl(i) < 0) THEN
1554: x_results.add_result(p_entity_type => c_entity_type_line_location,
1555: p_entity_id => p_id_tbl(i),

Line 1577: -- If shipment_type is STANDARD and receipt_days_expection_code is not null

1573: RAISE;
1574: END days_early_receipt_allowed;
1575:
1576: -------------------------------------------------------------------------
1577: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
1578: -- and not 'NONE', 'REJECT' not 'WARNING'
1579: -------------------------------------------------------------------------
1580: PROCEDURE receipt_days_exception_code(
1581: p_id_tbl IN po_tbl_number,

Line 1602: -- If shipment_type is STANDARD and receipt_days_expection_code is not null

1598: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1599: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1600: END IF;
1601:
1602: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
1603: -- and not 'NONE', 'REJECT' not 'WARNING'
1604: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1605: IF p_shipment_type_tbl(i) = 'STANDARD'
1606: AND p_rcpt_days_exception_code_tbl(i) IS NOT NULL

Line 1605: IF p_shipment_type_tbl(i) = 'STANDARD'

1601:
1602: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
1603: -- and not 'NONE', 'REJECT' not 'WARNING'
1604: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1605: IF p_shipment_type_tbl(i) = 'STANDARD'
1606: AND p_rcpt_days_exception_code_tbl(i) IS NOT NULL
1607: AND p_rcpt_days_exception_code_tbl(i) NOT IN('NONE', 'REJECT', 'WARNING') THEN
1608: x_results.add_result(p_entity_type => c_entity_type_line_location,
1609: p_entity_id => p_id_tbl(i),

Line 1631: -- If shipment_type is STANDARD and invoice_close_tolerance is not null

1627: RAISE;
1628: END receipt_days_exception_code;
1629:
1630: -------------------------------------------------------------------------
1631: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
1632: -- and less than or equal to zero or greater than or equal to 100.
1633: -------------------------------------------------------------------------
1634: PROCEDURE invoice_close_tolerance(
1635: p_id_tbl IN po_tbl_number,

Line 1656: -- If shipment_type is STANDARD and invoice_close_tolerance is not null

1652: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1653: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1654: END IF;
1655:
1656: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
1657: -- and less than or equal to zero or greater than or equal to 100.
1658: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1659: IF p_shipment_type_tbl(i) = 'STANDARD' AND
1660: p_invoice_close_tolerance_tbl(i) IS NOT NULL AND

Line 1659: IF p_shipment_type_tbl(i) = 'STANDARD' AND

1655:
1656: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
1657: -- and less than or equal to zero or greater than or equal to 100.
1658: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1659: IF p_shipment_type_tbl(i) = 'STANDARD' AND
1660: p_invoice_close_tolerance_tbl(i) IS NOT NULL AND
1661: (p_invoice_close_tolerance_tbl(i) < 0 OR p_invoice_close_tolerance_tbl(i) > 100) THEN
1662: x_results.add_result(p_entity_type => c_entity_type_line_location,
1663: p_entity_id => p_invoice_close_tolerance_tbl(i),

Line 1685: -- If shipment_type is STANDARD and receive_close_tolerance is not null

1681: RAISE;
1682: END invoice_close_tolerance;
1683:
1684: -------------------------------------------------------------------------
1685: -- If shipment_type is STANDARD and receive_close_tolerance is not null
1686: -- and less than or equal to zero or greater than or equal to 100.
1687: -------------------------------------------------------------------------
1688: PROCEDURE receive_close_tolerance(
1689: p_id_tbl IN po_tbl_number,

Line 1710: -- If shipment_type is STANDARD and receive_close_tolerance is not null

1706: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1707: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1708: END IF;
1709:
1710: -- If shipment_type is STANDARD and receive_close_tolerance is not null
1711: -- and less than or equal to zero or greater than or equal to 100.
1712: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1713: IF p_shipment_type_tbl(i) = 'STANDARD' AND
1714: p_receive_close_tolerance_tbl(i) IS NOT NULL AND

Line 1713: IF p_shipment_type_tbl(i) = 'STANDARD' AND

1709:
1710: -- If shipment_type is STANDARD and receive_close_tolerance is not null
1711: -- and less than or equal to zero or greater than or equal to 100.
1712: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1713: IF p_shipment_type_tbl(i) = 'STANDARD' AND
1714: p_receive_close_tolerance_tbl(i) IS NOT NULL AND
1715: (p_receive_close_tolerance_tbl(i) < 0 OR p_receive_close_tolerance_tbl(i) > 100) THEN
1716: x_results.add_result(p_entity_type => c_entity_type_line_location,
1717: p_entity_id => p_id_tbl(i),

Line 1786: AND p_shipment_type_tbl(i) = 'STANDARD'

1782: 'RECEIVING_ROUTING_ID',
1783: p_receiving_routing_id_tbl(i)
1784: FROM DUAL
1785: WHERE p_receiving_routing_id_tbl(i) IS NOT NULL
1786: AND p_shipment_type_tbl(i) = 'STANDARD'
1787: AND NOT EXISTS(SELECT 1
1788: FROM rcv_routing_headers rrh
1789: WHERE rrh.routing_header_id = p_receiving_routing_id_tbl(i));
1790: