APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_FTE_COMP_CONSTRAINT_GRP

Line 45: l_entity_table WSH_FTE_COMP_CONSTRAINT_GRP.wshfte_ccin_tab_type;

41: x_msg_data OUT nocopy varchar2) IS
42:
43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
44:
45: l_entity_table WSH_FTE_COMP_CONSTRAINT_GRP.wshfte_ccin_tab_type;
46: l_return_status VARCHAR2(1);
47: l_msg_count NUMBER;
48: l_msg_data VARCHAR2(2000);
49: l_fte_install_status VARCHAR2(30);

Line 76: --wsh_fte_comp_constraint_grp.validate_constraint

72: debug('shipMethod code: ' || p_shipmethod_code, 'VALIDATE_SHIP_METHOD');
73: END IF;
74:
75: --query the fields needed to pass into
76: --wsh_fte_comp_constraint_grp.validate_constraint
77: SELECT organization_id,
78: customer_id,
79: initial_pickup_location_id,
80: ultimate_dropoff_location_id,

Line 96: l_entity_table(1).p_action_code := wsh_fte_comp_constraint_grp.g_action_update;

92: FROM wsh_new_deliveries_ob_grp_v wnd
93: WHERE wnd.delivery_id = p_delivery_id;
94:
95: --for validation, 'UPDATE' is the action code
96: l_entity_table(1).p_action_code := wsh_fte_comp_constraint_grp.g_action_update;
97: l_entity_table(1).p_entity_type := wsh_fte_comp_constraint_grp.g_delivery;
98: l_entity_table(1).p_entity_id := p_delivery_id;
99: l_entity_table(1).p_shipmethod_code := p_shipmethod_code;
100:

Line 97: l_entity_table(1).p_entity_type := wsh_fte_comp_constraint_grp.g_delivery;

93: WHERE wnd.delivery_id = p_delivery_id;
94:
95: --for validation, 'UPDATE' is the action code
96: l_entity_table(1).p_action_code := wsh_fte_comp_constraint_grp.g_action_update;
97: l_entity_table(1).p_entity_type := wsh_fte_comp_constraint_grp.g_delivery;
98: l_entity_table(1).p_entity_id := p_delivery_id;
99: l_entity_table(1).p_shipmethod_code := p_shipmethod_code;
100:
101: wsh_fte_comp_constraint_grp.validate_constraint(p_api_version_number => 1.0,

Line 101: wsh_fte_comp_constraint_grp.validate_constraint(p_api_version_number => 1.0,

97: l_entity_table(1).p_entity_type := wsh_fte_comp_constraint_grp.g_delivery;
98: l_entity_table(1).p_entity_id := p_delivery_id;
99: l_entity_table(1).p_shipmethod_code := p_shipmethod_code;
100:
101: wsh_fte_comp_constraint_grp.validate_constraint(p_api_version_number => 1.0,
102: p_init_msg_list => FND_API.G_TRUE,
103: p_entity_tab => l_entity_table,
104: x_msg_count => l_msg_count,
105: x_msg_data => l_msg_data,