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 120.0.12010000.3 2009/09/23 12:39:51 gbhargav 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 254: -- WSH_ITM_UTIL.Update_process_Flag to update the process_flag value to 4.

250: -- In case if multiple request lines are present this will only return the first record
251: -- found with the matching i/p criteria
252: -- Before OM inserts a record in Wsh_Itm_Request_Control table, if there exists a record
253: -- in WIRC table for same order line then OM (OEXVITMB.pls) calls API
254: -- WSH_ITM_UTIL.Update_process_Flag to update the process_flag value to 4.
255: -- So, while querying from WIRC table ignore record with process_flag value 4.
256: --
257: -- PARAMETERS : p_appliciation_id i/p Appliciation id
258: -- p_original_sys_reference i/p Original system reference

Line 300: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.GET_COMPLIANCE_STATUS');

296: BEGIN
297:
298: --
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.GET_COMPLIANCE_STATUS');
301: oe_debug_pub.add('p_appliciation_id :' || p_appliciation_id );
302: oe_debug_pub.add('p_original_sys_reference :' || p_original_sys_reference );
303: oe_debug_pub.add('p_original_sys_line_reference :' || p_original_sys_line_reference );
304:

Line 341: oe_debug_pub.add('End of the procedure WSH_ITM_UTIL.GET_COMPLIANCE_STATUS');

337: x_process_flag := l_process_flag;
338: x_request_control_id := l_request_control_id;
339: x_request_set_id := l_request_set_id;
340:
341: oe_debug_pub.add('End of the procedure WSH_ITM_UTIL.GET_COMPLIANCE_STATUS');
342: --
343: EXCEPTION
344:
345: WHEN INVALID_APPLICATION THEN

Line 365: END WSH_ITM_UTIL;

361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362:
363: END GET_COMPLIANCE_STATUS;
364:
365: END WSH_ITM_UTIL;