APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_INTERFACE_VALIDATIONS_PKG

Line 221: p_loc_interface_errors_rec IN WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type,

217: x_return_status OUT NOCOPY VARCHAR2);
218:
219:
220: PROCEDURE log_errors(
221: p_loc_interface_errors_rec IN WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type,
222: p_msg_data IN VARCHAR2 DEFAULT NULL,
223: p_api_name IN VARCHAR2,
224: x_return_status OUT NOCOPY VARCHAR2);
225:

Line 685: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;

681: add_to_update_failed exception;
682: new_assignment_failed exception;
683: freight_cost_processing_error exception;
684: l_msg_details varchar2(2000);
685: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
686:
687: -- K LPN CONV. rv
688: l_cont_tab wsh_util_core.id_tab_type;
689: l_lpn_unit_weight NUMBER;

Line 2705: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;

2701: x_delivery_name VARCHAR2(150);
2702:
2703: l_curr_ship_method VARCHAR2(30);
2704:
2705: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
2706:
2707: CURSOR del_int_cur IS
2708: SELECT
2709: POOLED_SHIP_TO_LOCATION_CODE,

Line 3453: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;

3449: l_created_delivery_id NUMBER;
3450: l_new_del_detail_id NUMBER;
3451: l_action_code VARCHAR2(30);
3452:
3453: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
3454: -- cursors
3455: CURSOR del_id IS
3456: SELECT delivery_id ,
3457: -- J: W/V Changes

Line 3822: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;

3818: l_init_msg_list VARCHAR2(30) := NULL;
3819: l_commit VARCHAR2(1);
3820: l_return_status VARCHAR2(30);
3821:
3822: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
3823: l_entity_interface_id NUMBER;
3824: l_delivery_id NUMBER;
3825: l_del_detail_id NUMBER;
3826: -- cursors

Line 4134: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;

4130: l_init_msg_list VARCHAR2(30) := NULL;
4131: l_commit VARCHAR2(1) ;
4132: l_return_status VARCHAR2(30);
4133:
4134: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
4135: l_DETAIL_INFO_TAB WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
4136: l_IN_REC WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
4137: l_OUT_REC WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
4138: -- TPW - Distribution Organization Changes - Inv. Rsv API Integration Changes - Starts

Line 5444: p_loc_interface_errors_rec IN WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type,

5440: END IF;
5441: END Lock_Delivery_Details;
5442:
5443: PROCEDURE log_errors(
5444: p_loc_interface_errors_rec IN WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type,
5445: p_msg_data IN VARCHAR2 DEFAULT NULL,
5446: p_api_name IN VARCHAR2,
5447: x_return_status OUT NOCOPY VARCHAR2
5448: ) IS

Line 5470: WSH_INTERFACE_VALIDATIONS_PKG.Log_Interface_Errors(

5466: wsh_debug_sv.log (l_module_name, 'Interface Id', p_loc_interface_errors_rec.p_interface_id);
5467: wsh_debug_sv.log (l_module_name, 'Message Name', p_loc_interface_errors_rec.p_message_name);
5468: END IF;
5469:
5470: WSH_INTERFACE_VALIDATIONS_PKG.Log_Interface_Errors(
5471: p_interface_errors_rec => p_loc_interface_errors_rec,
5472: p_msg_data => p_msg_data,
5473: p_api_name => p_api_name,
5474: x_return_status => x_return_status);