DBA Data[Home] [Help]

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