APPS.WSH_ITM_UTIL dependencies on WSH_ITM_UTIL

Line 1: PACKAGE BODY WSH_ITM_UTIL AS

1: PACKAGE BODY WSH_ITM_UTIL AS
2: /* $Header: WSHUTITB.pls 115.5 2004/01/19 14:39:18 sgumaste ship $ */
3:
4:
5: -- Name

Line 86: oe_debug_pub.add('***Inside the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS***');

82:
83: BEGIN
84: --
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: oe_debug_pub.add('***Inside the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS***');
87: oe_debug_pub.add('Application Id ' || p_application_id);
88: oe_debug_pub.add('Master Organization Id ' || p_master_organization_id);
89: oe_debug_pub.add('Organization Id ' || p_organization_id);
90:

Line 141: oe_debug_pub.add('***End of the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS***');

137:
138: oe_debug_pub.add('Supports Combination Flag ' || comb_flag );
139: x_supports_combination_flag := comb_flag;
140: x_service_tbl := service_tbl;
141: oe_debug_pub.add('***End of the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS***');
142:
143:
144: EXCEPTION
145:

Line 177: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.UPDATE_PROCESS_FLAG');

173: BEGIN
174:
175: --
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.UPDATE_PROCESS_FLAG');
178:
179: FORALL i IN p_control_id_list.FIRST..p_control_id_list.LAST
180: UPDATE WSH_ITM_REQUEST_CONTROL
181: SET

Line 185: oe_debug_pub.add('End of the procedure WSH_ITM_UTIL.UPDATE_PROCESS_FLAG');

181: SET
182: PROCESS_FLAG = p_process_flag
183: WHERE REQUEST_CONTROL_ID = p_control_id_list(i);
184:
185: oe_debug_pub.add('End of the procedure WSH_ITM_UTIL.UPDATE_PROCESS_FLAG');
186:
187: EXCEPTION
188:
189: WHEN OTHERS THEN

Line 242: END WSH_ITM_UTIL;

238: x_service_provider := NULL;
239: END GET_SERVICE_PROVIDER;
240:
241:
242: END WSH_ITM_UTIL;