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 4542: PO_VAL_SHIPMENTS2.need_by_date(p_id_tbl => p_line_locations.interface_id,

4538: -- PDOI Shipment Validation Subroutines
4539: --------------------------------------------------------------------------
4540: WHEN c_shipment_need_by_date THEN
4541: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
4542: PO_VAL_SHIPMENTS2.need_by_date(p_id_tbl => p_line_locations.interface_id,
4543: p_purchase_basis_tbl => p_line_locations.purchase_basis,
4544: p_need_by_date_tbl => p_line_locations.need_by_date,
4545: x_results => x_results,
4546: x_result_type => l_result_type);

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

4545: x_results => x_results,
4546: x_result_type => l_result_type);
4547: WHEN c_shipment_promised_date THEN
4548: -- if purchase_basis is 'TEMP LABOR', the promised_date must be null
4549: PO_VAL_SHIPMENTS2.promised_date(p_id_tbl => p_line_locations.interface_id,
4550: p_purchase_basis_tbl => p_line_locations.purchase_basis,
4551: p_promised_date_tbl => p_line_locations.promised_date,
4552: x_results => x_results,
4553: x_result_type => l_result_type);

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

4552: x_results => x_results,
4553: x_result_type => l_result_type);
4554: WHEN c_shipment_type_blanket THEN
4555: -- validate shipment type
4556: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
4557: p_shipment_type_tbl => p_line_locations.shipment_type,
4558: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project
4559: p_doc_type => c_doc_type_blanket,
4560: x_results => x_results,

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

4560: x_results => x_results,
4561: x_result_type => l_result_type);
4562: WHEN c_shipment_type_standard THEN
4563: -- validate shipment type
4564: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
4565: p_shipment_type_tbl => p_line_locations.shipment_type,
4566: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project
4567: p_doc_type => c_doc_type_standard,
4568: x_results => x_results,

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

4568: x_results => x_results,
4569: x_result_type => l_result_type);
4570: WHEN c_shipment_type_quotation THEN
4571: -- validate shipment type
4572: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
4573: p_shipment_type_tbl => p_line_locations.shipment_type,
4574: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project
4575: p_doc_type => c_doc_type_quotation,
4576: x_results => x_results,

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

4577: x_result_type => l_result_type);
4578: WHEN c_shipment_num THEN
4579: -- validate shipment num is not null, greater than zero and unique
4580: -- bug 4642348: add two parameters - p_draft_id_tbl, p_doc_type
4581: PO_VAL_SHIPMENTS2.shipment_num(p_id_tbl => p_line_locations.interface_id,
4582: p_shipment_num_tbl => p_line_locations.shipment_num,
4583: p_shipment_type_tbl => p_line_locations.shipment_type,
4584: p_po_header_id_tbl => p_line_locations.po_header_id,
4585: p_po_line_id_tbl => p_line_locations.po_line_id,

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

4598: x_result_set_id => l_result_set_id,
4599: x_result_type => l_result_type);
4600: WHEN c_shipment_quantity THEN
4601: -- If order_type_lookup_code is RATE or FIXED PRICE, validate quantity is not null
4602: PO_VAL_SHIPMENTS2.quantity(p_id_tbl => p_line_locations.interface_id,
4603: p_quantity_tbl => p_line_locations.quantity,
4604: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
4605: p_shipment_type_tbl => p_line_locations.shipment_type, -- PDOI for Complex PO Project
4606: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project

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

4609: x_results => x_results,
4610: x_result_type => l_result_type);
4611: WHEN c_shipment_price_override THEN
4612: -- If order_type_lookup_code is not FIXED PRICE, price_override cannot be null
4613: PO_VAL_SHIPMENTS2.price_override(p_id_tbl => p_line_locations.interface_id,
4614: p_price_override_tbl => p_line_locations.price_override,
4615: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
4616: p_shipment_type_tbl => p_line_locations.shipment_type, -- PDOI for Complex PO Project
4617: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project

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

4621: x_result_type => l_result_type);
4622: WHEN c_shipment_price_discount THEN
4623: -- If order_type_lookup_code is not FIXED PRICE, price_discount/price_override cannot both be null
4624: -- and price discount cannot be less than zero or greater than 100
4625: PO_VAL_SHIPMENTS2.price_discount(p_id_tbl => p_line_locations.interface_id,
4626: p_price_discount_tbl => p_line_locations.price_discount,
4627: p_price_override_tbl => p_line_locations.price_override,
4628: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
4629: x_results => x_results,

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

4629: x_results => x_results,
4630: x_result_type => l_result_type);
4631: WHEN c_ship_to_organization_id THEN
4632: -- validate ship_to_organization_id
4633: PO_VAL_SHIPMENTS2.ship_to_organization_id(p_id_tbl => p_line_locations.interface_id,
4634: p_ship_to_organization_id_tbl => p_line_locations.ship_to_organization_id,
4635: p_item_id_tbl => p_line_locations.item_id,
4636: p_item_revision_tbl => p_line_locations.item_revision,
4637: p_ship_to_location_id_tbl => p_line_locations.ship_to_location_id,

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

4640: WHEN c_shipment_effective_dates THEN
4641: -- validate_effective_dates
4642: -- bug5016163
4643: -- Added price break look up code as parameter
4644: PO_VAL_SHIPMENTS2.effective_dates(p_id_tbl => p_line_locations.interface_id,
4645: p_line_expiration_date_tbl => p_line_locations.line_expiration_date,
4646: p_to_date_tbl => p_line_locations.to_date,
4647: p_from_date_tbl => p_line_locations.from_date,
4648: p_header_start_date_tbl => p_line_locations.hdr_start_date,

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

4651: x_results => x_results,
4652: x_result_type => l_result_type);
4653: WHEN c_qty_rcv_exception_code THEN
4654: -- validate qty_rcv_exception_code against PO_LOOKUP_CODES
4655: PO_VAL_SHIPMENTS2.qty_rcv_exception_code(p_id_tbl => p_line_locations.interface_id,
4656: p_qty_rcv_exception_code_tbl => p_line_locations.qty_rcv_exception_code,
4657: x_result_set_id => l_result_set_id,
4658: x_result_type => l_result_type);
4659: WHEN c_enforce_ship_to_loc_code THEN

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

4658: x_result_type => l_result_type);
4659: WHEN c_enforce_ship_to_loc_code THEN
4660: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
4661: -- to NONE, REJECT or WARNING
4662: PO_VAL_SHIPMENTS2.enforce_ship_to_loc_code(p_id_tbl => p_line_locations.interface_id,
4663: p_enforce_ship_to_loc_code_tbl => p_line_locations.enforce_ship_to_location_code,
4664: p_shipment_type_tbl => p_line_locations.shipment_type,
4665: x_results => x_results,
4666: x_result_type => l_result_type);

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

4666: x_result_type => l_result_type);
4667: WHEN c_allow_sub_receipts_flag THEN
4668: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal
4669: -- to NONE, REJECT or WARNING
4670: PO_VAL_SHIPMENTS2.allow_sub_receipts_flag(p_id_tbl => p_line_locations.interface_id,
4671: p_shipment_type_tbl => p_line_locations.shipment_type,
4672: p_allow_sub_receipts_flag_tbl => p_line_locations.allow_substitute_receipts_flag,
4673: x_results => x_results,
4674: x_result_type => l_result_type);

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

4674: x_result_type => l_result_type);
4675: WHEN c_days_early_receipt_allowed THEN
4676: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
4677: -- and less than zero.
4678: PO_VAL_SHIPMENTS2.days_early_receipt_allowed(p_id_tbl => p_line_locations.interface_id,
4679: p_shipment_type_tbl => p_line_locations.shipment_type,
4680: p_days_early_rcpt_allowed_tbl => p_line_locations.days_early_receipt_allowed,
4681: x_results => x_results,
4682: x_result_type => l_result_type);

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

4682: x_result_type => l_result_type);
4683: WHEN c_receipt_days_exception_code THEN
4684: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
4685: -- and not 'NONE', 'REJECT' not 'WARNING'
4686: PO_VAL_SHIPMENTS2.receipt_days_exception_code(p_id_tbl => p_line_locations.interface_id,
4687: p_shipment_type_tbl => p_line_locations.shipment_type,
4688: p_rcpt_days_exception_code_tbl => p_line_locations.receipt_days_exception_code,
4689: x_results => x_results,
4690: x_result_type => l_result_type);

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

4690: x_result_type => l_result_type);
4691: WHEN c_invoice_close_tolerance THEN
4692: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
4693: -- and less than or equal to zero or greater than or equal to 100.
4694: PO_VAL_SHIPMENTS2.invoice_close_tolerance(p_id_tbl => p_line_locations.interface_id,
4695: p_shipment_type_tbl => p_line_locations.shipment_type,
4696: p_invoice_close_tolerance_tbl => p_line_locations.invoice_close_tolerance,
4697: x_results => x_results,
4698: x_result_type => l_result_type);

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

4698: x_result_type => l_result_type);
4699: WHEN c_receive_close_tolerance THEN
4700: -- If shipment_type is STANDARD and receive_close_tolerance is not null
4701: -- and less than or equal to zero or greater than or equal to 100.
4702: PO_VAL_SHIPMENTS2.receive_close_tolerance(p_id_tbl => p_line_locations.interface_id,
4703: p_shipment_type_tbl => p_line_locations.shipment_type,
4704: p_receive_close_tolerance_tbl => p_line_locations.receive_close_tolerance,
4705: x_results => x_results,
4706: x_result_type => l_result_type);

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

4705: x_results => x_results,
4706: x_result_type => l_result_type);
4707: WHEN c_receiving_routing_id THEN
4708: -- Validate that receiving routing id exists in rcv_routing_headers
4709: PO_VAL_SHIPMENTS2.receiving_routing_id(p_id_tbl => p_line_locations.interface_id,
4710: p_shipment_type_tbl => p_line_locations.shipment_type,
4711: p_receiving_routing_id_tbl => p_line_locations.receiving_routing_id,
4712: x_result_set_id => l_result_set_id,
4713: x_result_type => l_result_type);

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

4712: x_result_set_id => l_result_set_id,
4713: x_result_type => l_result_type);
4714: WHEN c_accrue_on_receipt_flag THEN
4715: -- Validate accrue_on_receipt_flag is Y or N, if not null.
4716: PO_VAL_SHIPMENTS2.accrue_on_receipt_flag(p_id_tbl => p_line_locations.interface_id,
4717: p_accrue_on_receipt_flag_tbl => p_line_locations.accrue_on_receipt_flag,
4718: x_results => x_results,
4719: x_result_type => l_result_type);
4720: --

Line 4723: PO_VAL_SHIPMENTS2.advance_amt_le_amt(p_id_tbl => p_line_locations.interface_id,

4719: x_result_type => l_result_type);
4720: --
4721: WHEN c_pdoi_amt_ge_ship_advance_amt THEN
4722: -- Validate advance amount at shipment.
4723: PO_VAL_SHIPMENTS2.advance_amt_le_amt(p_id_tbl => p_line_locations.interface_id,
4724: p_payment_type_tbl => p_line_locations.payment_type,
4725: p_advance_tbl => p_line_locations.amount,
4726: p_amount_tbl => p_line_locations.line_amount,
4727: p_quantity_tbl => p_line_locations.line_quantity,

Line 4733: PO_VAL_SHIPMENTS2.amount(p_id_tbl => p_line_locations.interface_id,

4729: x_results => x_results,
4730: x_result_type => l_result_type);
4731: WHEN c_pdoi_shipment_amount THEN
4732: -- Validate amount at shipment.
4733: PO_VAL_SHIPMENTS2.amount(p_id_tbl => p_line_locations.interface_id,
4734: p_amount_tbl => p_line_locations.amount,
4735: p_shipment_type_tbl => p_line_locations.shipment_type,
4736: p_style_id_tbl => p_line_locations.hdr_style_id,
4737: p_payment_type_tbl => p_line_locations.payment_type,

Line 4743: PO_VAL_SHIPMENTS2.payment_type(p_id_tbl => p_line_locations.interface_id,

4739: x_results => x_results,
4740: x_result_type => l_result_type);
4741: WHEN c_pdoi_payment_type THEN
4742: -- Validate payment type.
4743: PO_VAL_SHIPMENTS2.payment_type(p_id_tbl => p_line_locations.interface_id,
4744: po_line_id_tbl => p_line_locations.po_line_id,
4745: p_style_id_tbl => p_line_locations.hdr_style_id,
4746: p_payment_type_tbl => p_line_locations.payment_type,
4747: p_shipment_type_tbl => p_line_locations.shipment_type,

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

4748: x_results => x_results,
4749: x_result_type => l_result_type);
4750: --
4751: WHEN c_fob_lookup_code_line_loc THEN
4752: PO_VAL_SHIPMENTS2.fob_lookup_code(p_id_tbl => p_line_locations.interface_id,
4753: p_fob_lookup_code_tbl => p_line_locations.fob_lookup_code,
4754: x_result_set_id => l_result_set_id,
4755: x_result_type => l_result_type);
4756: WHEN c_freight_terms_line_loc THEN

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

4753: p_fob_lookup_code_tbl => p_line_locations.fob_lookup_code,
4754: x_result_set_id => l_result_set_id,
4755: x_result_type => l_result_type);
4756: WHEN c_freight_terms_line_loc THEN
4757: PO_VAL_SHIPMENTS2.freight_terms(p_id_tbl => p_line_locations.interface_id,
4758: p_freight_terms_tbl => p_line_locations.freight_terms_lookup_code,
4759: x_result_set_id => l_result_set_id,
4760: x_result_type => l_result_type);
4761: WHEN c_freight_carrier_line_loc THEN

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

4758: p_freight_terms_tbl => p_line_locations.freight_terms_lookup_code,
4759: x_result_set_id => l_result_set_id,
4760: x_result_type => l_result_type);
4761: WHEN c_freight_carrier_line_loc THEN
4762: PO_VAL_SHIPMENTS2.freight_carrier(p_id_tbl => p_line_locations.interface_id,
4763: p_freight_carrier_tbl => p_line_locations.freight_carrier,
4764: p_inventory_org_id => l_inventory_org_id,
4765: x_result_set_id => l_result_set_id,
4766: x_result_type => l_result_type);

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

4764: p_inventory_org_id => l_inventory_org_id,
4765: x_result_set_id => l_result_set_id,
4766: x_result_type => l_result_type);
4767: WHEN c_line_loc_style_related_info THEN
4768: PO_VAL_SHIPMENTS2.style_related_info(p_id_tbl => p_line_locations.interface_id,
4769: p_style_id_tbl => p_line_locations.hdr_style_id,
4770: x_result_set_id => l_result_set_id,
4771: x_result_type => l_result_type);
4772: WHEN c_price_break THEN

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

4771: x_result_type => l_result_type);
4772: WHEN c_price_break THEN
4773: -- Cannot create price breaks for Amount-Based or Fixed Price lines in a Blanket
4774: -- Purchase Agreement.
4775: PO_VAL_SHIPMENTS2.price_break(p_id_tbl => p_line_locations.interface_id,
4776: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
4777: x_results => x_results,
4778: x_result_type => l_result_type);
4779: WHEN c_tax_name THEN

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

4776: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
4777: x_results => x_results,
4778: x_result_type => l_result_type);
4779: WHEN c_tax_name THEN
4780: PO_VAL_SHIPMENTS2.tax_name(p_id_tbl => p_line_locations.interface_id,
4781: p_tax_name_tbl => p_line_locations.tax_name,
4782: p_tax_code_id_tbl => p_line_locations.tax_code_id,
4783: p_need_by_date_tbl => p_line_locations.need_by_date,
4784: p_allow_tax_code_override => l_allow_tax_code_override,