APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_INTERFACE_VALIDATIONS_PKG

Line 218: p_loc_interface_errors_rec IN WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type,

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

Line 574: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;

570: add_to_update_failed exception;
571: new_assignment_failed exception;
572: freight_cost_processing_error exception;
573: l_msg_details varchar2(2000);
574: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
575:
576: -- K LPN CONV. rv
577: l_cont_tab wsh_util_core.id_tab_type;
578: l_lpn_unit_weight NUMBER;

Line 1752: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;

1748: x_delivery_name VARCHAR2(150);
1749:
1750: l_curr_ship_method VARCHAR2(30);
1751:
1752: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
1753:
1754: CURSOR del_int_cur IS
1755: SELECT
1756: POOLED_SHIP_TO_LOCATION_CODE,

Line 2484: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;

2480: l_created_delivery_id NUMBER;
2481: l_new_del_detail_id NUMBER;
2482: l_action_code VARCHAR2(30);
2483:
2484: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
2485: -- cursors
2486: CURSOR del_id IS
2487: SELECT delivery_id ,
2488: -- J: W/V Changes

Line 2812: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;

2808: l_init_msg_list VARCHAR2(30) := NULL;
2809: l_commit VARCHAR2(1);
2810: l_return_status VARCHAR2(30);
2811:
2812: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
2813: l_entity_interface_id NUMBER;
2814: l_delivery_id NUMBER;
2815: l_del_detail_id NUMBER;
2816: -- cursors

Line 3131: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;

3127: l_init_msg_list VARCHAR2(30) := NULL;
3128: l_commit VARCHAR2(1) ;
3129: l_return_status VARCHAR2(30);
3130:
3131: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
3132: l_DETAIL_INFO_TAB WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
3133: l_IN_REC WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
3134: l_OUT_REC WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
3135: --exceptions

Line 4177: p_loc_interface_errors_rec IN WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type,

4173: END IF;
4174: END Lock_Delivery_And_Details;
4175:
4176: PROCEDURE log_errors(
4177: p_loc_interface_errors_rec IN WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type,
4178: p_msg_data IN VARCHAR2 DEFAULT NULL,
4179: p_api_name IN VARCHAR2,
4180: x_return_status OUT NOCOPY VARCHAR2
4181: ) IS

Line 4203: WSH_INTERFACE_VALIDATIONS_PKG.Log_Interface_Errors(

4199: wsh_debug_sv.log (l_module_name, 'Interface Id', p_loc_interface_errors_rec.p_interface_id);
4200: wsh_debug_sv.log (l_module_name, 'Message Name', p_loc_interface_errors_rec.p_message_name);
4201: END IF;
4202:
4203: WSH_INTERFACE_VALIDATIONS_PKG.Log_Interface_Errors(
4204: p_interface_errors_rec => p_loc_interface_errors_rec,
4205: p_msg_data => p_msg_data,
4206: p_api_name => p_api_name,
4207: x_return_status => x_return_status);