[Home] [Help]
1: PACKAGE BODY WSH_INTERFACE_COMMON_ACTIONS as
2: /* $Header: WSHINCAB.pls 120.1 2006/10/18 18:45:52 bsadri noship $ */
3:
4: -- this cursor will be used by Process_Non_Splits and Process_Splits procedures
5:
204:
205:
206: -- forward declaration
207: --
208: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_INTERFACE_COMMON_ACTIONS';
209: --
210: PROCEDURE Add_To_Update_Table(
211: p_del_det_int_rec IN del_det_int_cur%ROWTYPE,
212: p_update_mode IN VARCHAR2 DEFAULT 'UPDATE',
2434: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:freight_cost_processing_error');
2435: END IF;
2436: WHEN OTHERS THEN
2437: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2438: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.PROCESS_INTERFACED_DELIVERIES');
2439:
2440: IF l_debug_on THEN
2441: wsh_debug_sv.logmsg(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM, wsh_debug_sv.c_unexpec_err_level);
2442: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
3758:
3759: -- variables
3760: --l_changed_attributes WSH_INTERFACE.ChangedAttributeRecType;
3761: l_changed_attributes WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
3762: l_packing_detail_rec WSH_INTERFACE_COMMON_ACTIONS.PackingDetailRecType;
3763: l_intf_parent_det_id NUMBER;
3764:
3765: -- cursors
3766: CURSOR base_detail_cur(l_cont_inst_id NUMBER) IS
4348: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4349: END IF;
4350: WHEN OTHERS THEN
4351: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4352: wsh_util_core.default_handler('WSH_INTERFACE_COMMON_ACTIONS.split_delivery_detail');
4353: --
4354: IF l_debug_on THEN
4355: wsh_debug_sv.logmsg(l_module_name,
4356: 'Unexpected error has occured. Oracle error message is '
4380: WHEN OTHERS THEN
4381: raise fnd_api.g_exc_error;
4382: END add_to_serial_table;
4383:
4384: END WSH_INTERFACE_COMMON_ACTIONS;