APPS.WSH_ITM_UTIL dependencies on FND_API

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81: ) order by priority;
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);

Line 150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

146: WHEN OTHERS THEN
147: l_sql_error := SQLERRM;
148: OE_DEBUG_PUB.Add('Processing Failed with an Error');
149: OE_DEBUG_PUB.Add('The unexpected error is :' || l_sql_error);
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151:
152: END GET_SERVICE_DETAILS;
153:
154:

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS;

172:
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

Line 193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

189: WHEN OTHERS THEN
190: l_sql_error := SQLERRM;
191: oe_debug_pub.add('Processing Failed with an Error');
192: oe_debug_pub.add('The unexpected error is :' || l_sql_error);
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194:
195: END UPDATE_PROCESS_FLAG;
196:
197: -- Name

Line 299: x_return_status := FND_API.G_RET_STS_SUCCESS;

295:
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 );

Line 347: x_return_status := FND_API.G_RET_STS_ERROR;

343: EXCEPTION
344:
345: WHEN INVALID_APPLICATION THEN
346: oe_debug_pub.add('Processing Failed as application_id provided is invalid ');
347: x_return_status := FND_API.G_RET_STS_ERROR;
348:
349: WHEN MISSING_INPUT THEN
350: oe_debug_pub.add('Processing Failed as some mandatory parameters are missing ');
351: x_return_status := FND_API.G_RET_STS_ERROR;

Line 351: x_return_status := FND_API.G_RET_STS_ERROR;

347: x_return_status := FND_API.G_RET_STS_ERROR;
348:
349: WHEN MISSING_INPUT THEN
350: oe_debug_pub.add('Processing Failed as some mandatory parameters are missing ');
351: x_return_status := FND_API.G_RET_STS_ERROR;
352:
353: WHEN OTHERS THEN
354:
355: IF c_get_compliance_details%ISOPEN THEN

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

357: END IF;
358: l_sql_error := SQLERRM;
359: oe_debug_pub.add('Processing Failed with an Error');
360: oe_debug_pub.add('The unexpected error is :' || l_sql_error);
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362:
363: END GET_COMPLIANCE_STATUS;
364:
365: END WSH_ITM_UTIL;