53: BEGIN
54:
55: WSH_UTIL_CORE.println(' Inside procedure CALL_CUSTOM_API');
56:
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: ----------------------------------------------------------
60: -- Select the application short name which will be later
61: -- used to call the Application Specific custom procedure.
149:
150: EXCEPTION
151:
152: WHEN OTHERS THEN
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: l_error_code := SQLCODE;
155: l_error_text := SQLERRM;
156:
157: WSH_UTIL_CORE.PrintMsg('Failed in Procedure Call_Custom_API');
187: x_exception_id NUMBER;
188: l_old_status VARCHAR2(30);
189: l_new_status VARCHAR2(30);
190: l_default_status VARCHAR2(100);
191: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
192: l_varchar_status_tab WSH_UTIL_CORE.Column_Tab_Type;
193: l_num_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
194:
195: l_logged_at_location_id number ;
242: l_default_status := 'F';
243:
244:
245: WSH_XC_UTIL.change_status ( p_api_version => l_api_version,
246: p_init_msg_list => FND_API.g_false,
247: p_commit => FND_API.g_false,
248: p_validation_level => l_validation_level,
249: x_return_status => l_return_status,
250: x_msg_count => l_msg_count,
243:
244:
245: WSH_XC_UTIL.change_status ( p_api_version => l_api_version,
246: p_init_msg_list => FND_API.g_false,
247: p_commit => FND_API.g_false,
248: p_validation_level => l_validation_level,
249: x_return_status => l_return_status,
250: x_msg_count => l_msg_count,
251: x_msg_data => l_msg_data,
267:
268:
269: WSH_XC_UTIL.log_exception(
270: p_api_version => l_api_version,
271: p_init_msg_list => FND_API.g_false,
272: p_commit => FND_API.g_false,
273: p_validation_level => l_validation_level,
274: x_return_status => l_return_status,
275: x_msg_count => l_msg_count,
268:
269: WSH_XC_UTIL.log_exception(
270: p_api_version => l_api_version,
271: p_init_msg_list => FND_API.g_false,
272: p_commit => FND_API.g_false,
273: p_validation_level => l_validation_level,
274: x_return_status => l_return_status,
275: x_msg_count => l_msg_count,
276: x_msg_data => l_msg_data,
679:
680: WSH_UTIL_CORE.println('After Call to Call_Custom_API');
681: WSH_UTIL_CORE.println('Return Status from Call_Custom_API:' || l_return_status);
682:
683: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
684: RAISE Call_Custom_API_Failed;
685: END IF;
686: commit;
687:
904: WSH_UTIL_CORE.println('Response from Response analyser is different from the override parameter entered by user.. ignoring this and processing next record');
905: ELSE
906: WSH_UTIL_CORE.println('Cannot process data errors');
907: END IF;
908: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
909: RAISE Response_Analyser_Failed;
910: END IF;
911:
912: ELSE
920: WSH_UTIL_CORE.println(' ');
921:
922: BEGIN
923:
924: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
925: RAISE Response_Analyser_Failed;
926: END IF;
927:
928: IF l_interpreted_value = p_override_type OR
947: );
948:
949: WSH_UTIL_CORE.println('AFter Call_Custom_API');
950:
951: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
952: RAISE Call_Custom_API_Failed;
953: END IF;
954:
955: END IF;