APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_NEW_DEL_INTERFACE

Line 931: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';

927: END IF;
928:
929: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
930:
931: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
932: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
933:
934: IF l_debug_on THEN
935: wsh_debug_sv.log (l_module_name, 'Delivery Interface Id', p_delivery_interface_id);

Line 1902: FROM WSH_NEW_DEL_INTERFACE

1898: WV_FROZEN_FLAG,
1899: --Bug 3458160
1900: SHIPMENT_DIRECTION,
1901: DELIVERED_DATE
1902: FROM WSH_NEW_DEL_INTERFACE
1903: WHERE delivery_interface_id = p_delivery_interface_id
1904: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1905:
1906: cursor get_carrier ( p_carrier_name in varchar2 ) is

Line 2092: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';

2088: --}
2089: END IF;
2090: IF ( l_log_error_flag = 'Y') THEN
2091: --{
2092: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
2093: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
2094: Log_Errors(
2095: p_loc_interface_errors_rec => l_loc_interface_error_rec,
2096: p_api_name =>'Process_Interfaced_Deliveries, Action=UPDATE' ,

Line 2355: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';

2351:
2352: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2353: THEN
2354: -- {
2355: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
2356: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
2357: --
2358: Log_Errors(
2359: p_loc_interface_errors_rec => l_loc_interface_error_rec,

Line 2493: FROM wsh_new_del_interface

2489: gross_weight,
2490: net_weight,
2491: volume,
2492: wv_frozen_flag
2493: FROM wsh_new_del_interface
2494: WHERE delivery_interface_id = p_delivery_interface_id
2495: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2496:
2497: cursor org_del_id(c_del_id IN NUMBER) IS

Line 2577: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';

2573: wsh_debug_sv.log (l_module_name,'Return status from lock delivery and details', l_return_status);
2574: END IF;
2575:
2576: IF(l_return_status <> wsh_util_core.g_ret_sts_success) THEN
2577: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
2578: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
2579: l_loc_interface_error_rec.p_message_name := 'WSH_NO_LOCK';
2580:
2581: Log_Errors(

Line 2671: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';

2667: END IF;
2668:
2669: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2670:
2671: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
2672: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
2673:
2674: IF l_debug_on THEN
2675: wsh_debug_sv.log (l_module_name, 'Delivery Interface Id', p_delivery_interface_id);

Line 2926: FROM wsh_new_del_interface

2922: END IF;
2923: ELSIF(p_delivery_interface_id IS NOT NULL) THEN
2924: l_entity_interface_id := p_delivery_interface_id;
2925: SELECT delivery_id INTO l_delivery_id
2926: FROM wsh_new_del_interface
2927: WHERE delivery_interface_id = p_delivery_interface_id
2928: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2929:
2930: IF l_debug_on THEN

Line 3195: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';

3191: -- For 940 inbound - cancel case, there may not be any
3192: -- data in interface tables.
3193:
3194: IF(p_delivery_interface_id IS NOT NULL) THEN
3195: l_loc_interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
3196: l_loc_interface_error_rec.p_interface_id := p_delivery_interface_id;
3197:
3198: Log_Errors(
3199: p_loc_interface_errors_rec => l_loc_interface_error_rec,