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_VALIDATIONS dependencies on PO_VAL_SHIPMENTS2

Line 3669: PO_VAL_SHIPMENTS2.need_by_date(p_id_tbl => p_line_locations.interface_id,

3665: -- PDOI Shipment Validation Subroutines
3666: --------------------------------------------------------------------------
3667: WHEN c_shipment_need_by_date THEN
3668: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
3669: PO_VAL_SHIPMENTS2.need_by_date(p_id_tbl => p_line_locations.interface_id,
3670: p_purchase_basis_tbl => p_line_locations.purchase_basis,
3671: p_need_by_date_tbl => p_line_locations.need_by_date,
3672: x_results => x_results,
3673: x_result_type => l_result_type);

Line 3676: PO_VAL_SHIPMENTS2.promised_date(p_id_tbl => p_line_locations.interface_id,

3672: x_results => x_results,
3673: x_result_type => l_result_type);
3674: WHEN c_shipment_promised_date THEN
3675: -- if purchase_basis is 'TEMP LABOR', the promised_date must be null
3676: PO_VAL_SHIPMENTS2.promised_date(p_id_tbl => p_line_locations.interface_id,
3677: p_purchase_basis_tbl => p_line_locations.purchase_basis,
3678: p_promised_date_tbl => p_line_locations.promised_date,
3679: x_results => x_results,
3680: x_result_type => l_result_type);

Line 3683: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,

3679: x_results => x_results,
3680: x_result_type => l_result_type);
3681: WHEN c_shipment_type_blanket THEN
3682: -- validate shipment type
3683: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
3684: p_shipment_type_tbl => p_line_locations.shipment_type,
3685: p_doc_type => c_doc_type_blanket,
3686: x_results => x_results,
3687: x_result_type => l_result_type);

Line 3690: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,

3686: x_results => x_results,
3687: x_result_type => l_result_type);
3688: WHEN c_shipment_type_standard THEN
3689: -- validate shipment type
3690: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
3691: p_shipment_type_tbl => p_line_locations.shipment_type,
3692: p_doc_type => c_doc_type_standard,
3693: x_results => x_results,
3694: x_result_type => l_result_type);

Line 3697: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,

3693: x_results => x_results,
3694: x_result_type => l_result_type);
3695: WHEN c_shipment_type_quotation THEN
3696: -- validate shipment type
3697: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
3698: p_shipment_type_tbl => p_line_locations.shipment_type,
3699: p_doc_type => c_doc_type_quotation,
3700: x_results => x_results,
3701: x_result_type => l_result_type);

Line 3705: PO_VAL_SHIPMENTS2.shipment_num(p_id_tbl => p_line_locations.interface_id,

3701: x_result_type => l_result_type);
3702: WHEN c_shipment_num THEN
3703: -- validate shipment num is not null, greater than zero and unique
3704: -- bug 4642348: add two parameters - p_draft_id_tbl, p_doc_type
3705: PO_VAL_SHIPMENTS2.shipment_num(p_id_tbl => p_line_locations.interface_id,
3706: p_shipment_num_tbl => p_line_locations.shipment_num,
3707: p_shipment_type_tbl => p_line_locations.shipment_type,
3708: p_po_header_id_tbl => p_line_locations.po_header_id,
3709: p_po_line_id_tbl => p_line_locations.po_line_id,

Line 3725: PO_VAL_SHIPMENTS2.quantity(p_id_tbl => p_line_locations.interface_id,

3721: x_result_set_id => l_result_set_id,
3722: x_result_type => l_result_type);
3723: WHEN c_shipment_quantity THEN
3724: -- If order_type_lookup_code is RATE or FIXED PRICE, validate quantity is not null
3725: PO_VAL_SHIPMENTS2.quantity(p_id_tbl => p_line_locations.interface_id,
3726: p_quantity_tbl => p_line_locations.quantity,
3727: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
3728: x_results => x_results,
3729: x_result_type => l_result_type);

Line 3732: PO_VAL_SHIPMENTS2.price_override(p_id_tbl => p_line_locations.interface_id,

3728: x_results => x_results,
3729: x_result_type => l_result_type);
3730: WHEN c_shipment_price_override THEN
3731: -- If order_type_lookup_code is not FIXED PRICE, price_override cannot be null
3732: PO_VAL_SHIPMENTS2.price_override(p_id_tbl => p_line_locations.interface_id,
3733: p_price_override_tbl => p_line_locations.price_override,
3734: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
3735: x_results => x_results,
3736: x_result_type => l_result_type);

Line 3740: PO_VAL_SHIPMENTS2.price_discount(p_id_tbl => p_line_locations.interface_id,

3736: x_result_type => l_result_type);
3737: WHEN c_shipment_price_discount THEN
3738: -- If order_type_lookup_code is not FIXED PRICE, price_discount/price_override cannot both be null
3739: -- and price discount cannot be less than zero or greater than 100
3740: PO_VAL_SHIPMENTS2.price_discount(p_id_tbl => p_line_locations.interface_id,
3741: p_price_discount_tbl => p_line_locations.price_discount,
3742: p_price_override_tbl => p_line_locations.price_override,
3743: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
3744: x_results => x_results,

Line 3748: PO_VAL_SHIPMENTS2.ship_to_organization_id(p_id_tbl => p_line_locations.interface_id,

3744: x_results => x_results,
3745: x_result_type => l_result_type);
3746: WHEN c_ship_to_organization_id THEN
3747: -- validate ship_to_organization_id
3748: PO_VAL_SHIPMENTS2.ship_to_organization_id(p_id_tbl => p_line_locations.interface_id,
3749: p_ship_to_organization_id_tbl => p_line_locations.ship_to_organization_id,
3750: p_item_id_tbl => p_line_locations.item_id,
3751: p_item_revision_tbl => p_line_locations.item_revision,
3752: p_ship_to_location_id_tbl => p_line_locations.ship_to_location_id,

Line 3759: PO_VAL_SHIPMENTS2.effective_dates(p_id_tbl => p_line_locations.interface_id,

3755: WHEN c_shipment_effective_dates THEN
3756: -- validate_effective_dates
3757: -- bug5016163
3758: -- Added price break look up code as parameter
3759: PO_VAL_SHIPMENTS2.effective_dates(p_id_tbl => p_line_locations.interface_id,
3760: p_line_expiration_date_tbl => p_line_locations.line_expiration_date,
3761: p_to_date_tbl => p_line_locations.to_date,
3762: p_from_date_tbl => p_line_locations.from_date,
3763: p_header_start_date_tbl => p_line_locations.hdr_start_date,

Line 3770: PO_VAL_SHIPMENTS2.qty_rcv_exception_code(p_id_tbl => p_line_locations.interface_id,

3766: x_results => x_results,
3767: x_result_type => l_result_type);
3768: WHEN c_qty_rcv_exception_code THEN
3769: -- validate qty_rcv_exception_code against PO_LOOKUP_CODES
3770: PO_VAL_SHIPMENTS2.qty_rcv_exception_code(p_id_tbl => p_line_locations.interface_id,
3771: p_qty_rcv_exception_code_tbl => p_line_locations.qty_rcv_exception_code,
3772: x_result_set_id => l_result_set_id,
3773: x_result_type => l_result_type);
3774: WHEN c_enforce_ship_to_loc_code THEN

Line 3777: PO_VAL_SHIPMENTS2.enforce_ship_to_loc_code(p_id_tbl => p_line_locations.interface_id,

3773: x_result_type => l_result_type);
3774: WHEN c_enforce_ship_to_loc_code THEN
3775: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
3776: -- to NONE, REJECT or WARNING
3777: PO_VAL_SHIPMENTS2.enforce_ship_to_loc_code(p_id_tbl => p_line_locations.interface_id,
3778: p_enforce_ship_to_loc_code_tbl => p_line_locations.enforce_ship_to_location_code,
3779: p_shipment_type_tbl => p_line_locations.shipment_type,
3780: x_results => x_results,
3781: x_result_type => l_result_type);

Line 3785: PO_VAL_SHIPMENTS2.allow_sub_receipts_flag(p_id_tbl => p_line_locations.interface_id,

3781: x_result_type => l_result_type);
3782: WHEN c_allow_sub_receipts_flag THEN
3783: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal
3784: -- to NONE, REJECT or WARNING
3785: PO_VAL_SHIPMENTS2.allow_sub_receipts_flag(p_id_tbl => p_line_locations.interface_id,
3786: p_shipment_type_tbl => p_line_locations.shipment_type,
3787: p_allow_sub_receipts_flag_tbl => p_line_locations.allow_substitute_receipts_flag,
3788: x_results => x_results,
3789: x_result_type => l_result_type);

Line 3793: PO_VAL_SHIPMENTS2.days_early_receipt_allowed(p_id_tbl => p_line_locations.interface_id,

3789: x_result_type => l_result_type);
3790: WHEN c_days_early_receipt_allowed THEN
3791: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
3792: -- and less than zero.
3793: PO_VAL_SHIPMENTS2.days_early_receipt_allowed(p_id_tbl => p_line_locations.interface_id,
3794: p_shipment_type_tbl => p_line_locations.shipment_type,
3795: p_days_early_rcpt_allowed_tbl => p_line_locations.days_early_receipt_allowed,
3796: x_results => x_results,
3797: x_result_type => l_result_type);

Line 3801: PO_VAL_SHIPMENTS2.receipt_days_exception_code(p_id_tbl => p_line_locations.interface_id,

3797: x_result_type => l_result_type);
3798: WHEN c_receipt_days_exception_code THEN
3799: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
3800: -- and not 'NONE', 'REJECT' not 'WARNING'
3801: PO_VAL_SHIPMENTS2.receipt_days_exception_code(p_id_tbl => p_line_locations.interface_id,
3802: p_shipment_type_tbl => p_line_locations.shipment_type,
3803: p_rcpt_days_exception_code_tbl => p_line_locations.receipt_days_exception_code,
3804: x_results => x_results,
3805: x_result_type => l_result_type);

Line 3809: PO_VAL_SHIPMENTS2.invoice_close_tolerance(p_id_tbl => p_line_locations.interface_id,

3805: x_result_type => l_result_type);
3806: WHEN c_invoice_close_tolerance THEN
3807: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
3808: -- and less than or equal to zero or greater than or equal to 100.
3809: PO_VAL_SHIPMENTS2.invoice_close_tolerance(p_id_tbl => p_line_locations.interface_id,
3810: p_shipment_type_tbl => p_line_locations.shipment_type,
3811: p_invoice_close_tolerance_tbl => p_line_locations.invoice_close_tolerance,
3812: x_results => x_results,
3813: x_result_type => l_result_type);

Line 3817: PO_VAL_SHIPMENTS2.receive_close_tolerance(p_id_tbl => p_line_locations.interface_id,

3813: x_result_type => l_result_type);
3814: WHEN c_receive_close_tolerance THEN
3815: -- If shipment_type is STANDARD and receive_close_tolerance is not null
3816: -- and less than or equal to zero or greater than or equal to 100.
3817: PO_VAL_SHIPMENTS2.receive_close_tolerance(p_id_tbl => p_line_locations.interface_id,
3818: p_shipment_type_tbl => p_line_locations.shipment_type,
3819: p_receive_close_tolerance_tbl => p_line_locations.receive_close_tolerance,
3820: x_results => x_results,
3821: x_result_type => l_result_type);

Line 3824: PO_VAL_SHIPMENTS2.receiving_routing_id(p_id_tbl => p_line_locations.interface_id,

3820: x_results => x_results,
3821: x_result_type => l_result_type);
3822: WHEN c_receiving_routing_id THEN
3823: -- Validate that receiving routing id exists in rcv_routing_headers
3824: PO_VAL_SHIPMENTS2.receiving_routing_id(p_id_tbl => p_line_locations.interface_id,
3825: p_shipment_type_tbl => p_line_locations.shipment_type,
3826: p_receiving_routing_id_tbl => p_line_locations.receiving_routing_id,
3827: x_result_set_id => l_result_set_id,
3828: x_result_type => l_result_type);

Line 3831: PO_VAL_SHIPMENTS2.accrue_on_receipt_flag(p_id_tbl => p_line_locations.interface_id,

3827: x_result_set_id => l_result_set_id,
3828: x_result_type => l_result_type);
3829: WHEN c_accrue_on_receipt_flag THEN
3830: -- Validate accrue_on_receipt_flag is Y or N, if not null.
3831: PO_VAL_SHIPMENTS2.accrue_on_receipt_flag(p_id_tbl => p_line_locations.interface_id,
3832: p_accrue_on_receipt_flag_tbl => p_line_locations.accrue_on_receipt_flag,
3833: x_results => x_results,
3834: x_result_type => l_result_type);
3835: WHEN c_fob_lookup_code_line_loc THEN

Line 3836: PO_VAL_SHIPMENTS2.fob_lookup_code(p_id_tbl => p_line_locations.interface_id,

3832: p_accrue_on_receipt_flag_tbl => p_line_locations.accrue_on_receipt_flag,
3833: x_results => x_results,
3834: x_result_type => l_result_type);
3835: WHEN c_fob_lookup_code_line_loc THEN
3836: PO_VAL_SHIPMENTS2.fob_lookup_code(p_id_tbl => p_line_locations.interface_id,
3837: p_fob_lookup_code_tbl => p_line_locations.fob_lookup_code,
3838: x_result_set_id => l_result_set_id,
3839: x_result_type => l_result_type);
3840: WHEN c_freight_terms_line_loc THEN

Line 3841: PO_VAL_SHIPMENTS2.freight_terms(p_id_tbl => p_line_locations.interface_id,

3837: p_fob_lookup_code_tbl => p_line_locations.fob_lookup_code,
3838: x_result_set_id => l_result_set_id,
3839: x_result_type => l_result_type);
3840: WHEN c_freight_terms_line_loc THEN
3841: PO_VAL_SHIPMENTS2.freight_terms(p_id_tbl => p_line_locations.interface_id,
3842: p_freight_terms_tbl => p_line_locations.freight_terms_lookup_code,
3843: x_result_set_id => l_result_set_id,
3844: x_result_type => l_result_type);
3845: WHEN c_freight_carrier_line_loc THEN

Line 3846: PO_VAL_SHIPMENTS2.freight_carrier(p_id_tbl => p_line_locations.interface_id,

3842: p_freight_terms_tbl => p_line_locations.freight_terms_lookup_code,
3843: x_result_set_id => l_result_set_id,
3844: x_result_type => l_result_type);
3845: WHEN c_freight_carrier_line_loc THEN
3846: PO_VAL_SHIPMENTS2.freight_carrier(p_id_tbl => p_line_locations.interface_id,
3847: p_freight_carrier_tbl => p_line_locations.freight_carrier,
3848: p_inventory_org_id => l_inventory_org_id,
3849: x_result_set_id => l_result_set_id,
3850: x_result_type => l_result_type);

Line 3852: PO_VAL_SHIPMENTS2.style_related_info(p_id_tbl => p_line_locations.interface_id,

3848: p_inventory_org_id => l_inventory_org_id,
3849: x_result_set_id => l_result_set_id,
3850: x_result_type => l_result_type);
3851: WHEN c_line_loc_style_related_info THEN
3852: PO_VAL_SHIPMENTS2.style_related_info(p_id_tbl => p_line_locations.interface_id,
3853: p_style_id_tbl => p_line_locations.hdr_style_id,
3854: x_result_set_id => l_result_set_id,
3855: x_result_type => l_result_type);
3856: WHEN c_price_break THEN

Line 3859: PO_VAL_SHIPMENTS2.price_break(p_id_tbl => p_line_locations.interface_id,

3855: x_result_type => l_result_type);
3856: WHEN c_price_break THEN
3857: -- Cannot create price breaks for Amount-Based or Fixed Price lines in a Blanket
3858: -- Purchase Agreement.
3859: PO_VAL_SHIPMENTS2.price_break(p_id_tbl => p_line_locations.interface_id,
3860: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
3861: x_results => x_results,
3862: x_result_type => l_result_type);
3863: WHEN c_tax_name THEN

Line 3864: PO_VAL_SHIPMENTS2.tax_name(p_id_tbl => p_line_locations.interface_id,

3860: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
3861: x_results => x_results,
3862: x_result_type => l_result_type);
3863: WHEN c_tax_name THEN
3864: PO_VAL_SHIPMENTS2.tax_name(p_id_tbl => p_line_locations.interface_id,
3865: p_tax_name_tbl => p_line_locations.tax_name,
3866: p_tax_code_id_tbl => p_line_locations.tax_code_id,
3867: p_need_by_date_tbl => p_line_locations.need_by_date,
3868: p_allow_tax_code_override => l_allow_tax_code_override,