APPS.RCV_ROI_TRANSACTION dependencies on RCV_SETUP_S

Line 7915: AND NVL(rcv_setup_s.get_override_routing, 'N') = 'N') THEN

7911: IF ( x_cascaded_table(n).transaction_type = 'RECEIVE'
7912: AND NVL(x_cascaded_table(n).auto_transact_code, 'RECEIVE') = 'DELIVER') THEN
7913: /* 1 is Standard Receipt, 2 is Inspection Required */
7914: IF ( (x_cascaded_table(n).routing_header_id) IN(1, 2)
7915: AND NVL(rcv_setup_s.get_override_routing, 'N') = 'N') THEN
7916: rcv_error_pkg.set_error_message('RCV_ASN_DELIVER_ROUTING_FAILED');
7917: RAISE e_validation_error;
7918: END IF;
7919: END IF;

Line 7923: AND NVL(rcv_setup_s.get_override_routing, 'N') = 'N') THEN --{

7919: END IF;
7920:
7921: IF (x_cascaded_table(n).transaction_type IN('ACCEPT', 'REJECT')) THEN --{
7922: IF ( (x_cascaded_table(n).routing_header_id) IN(3)
7923: AND NVL(rcv_setup_s.get_override_routing, 'N') = 'N') THEN --{
7924: asn_debug.put_line('We cannot do inspection on this record .');
7925: rcv_error_pkg.set_error_message('RCV_INSPECT_ROUTING_FAILED');
7926: RAISE e_validation_error;
7927: END IF; --}

Line 7935: AND NVL(rcv_setup_s.get_override_routing, 'N') = 'N') THEN

7931: * If profile RCV override routing is No, Deliver txn should not be allowed for Inspection Required routing
7932: * until Inspect txn is created. */
7933: IF ( x_cascaded_table(n).transaction_type = 'DELIVER'
7934: AND (x_cascaded_table(n).routing_header_id) = 2
7935: AND NVL(rcv_setup_s.get_override_routing, 'N') = 'N') THEN
7936:
7937: BEGIN
7938:
7939: IF x_cascaded_table(n).parent_transaction_id IS NOT NULL THEN