APPS.MSC_E1_APS_PDP dependencies on MSC_APPS_INSTANCES

Line 308: select instance_code into l_instance_code from msc_apps_instances

304: WSURL := fnd_profile.value('MSC_E1APS_ODIURL');
305:
306: IF WSURL IS NOT NULL THEN
307: /* Launching Pre-Process Custom Hook ODI Scenario */
308: select instance_code into l_instance_code from msc_apps_instances
309: where instance_id = parInstanceID;
310:
311: scenario_name := 'PREPROCESSHOOKPKG';
312: scenario_version := '001';

Line 635: SELECT INSTANCE_CODE into parInstanceCode FROM MSC_APPS_INSTANCES

631:
632: IF parTradingPtnrs = MSC_UTIL.SYS_YES AND locParCalendars = MSC_UTIL.SYS_NO THEN
633: BEGIN
634:
635: SELECT INSTANCE_CODE into parInstanceCode FROM MSC_APPS_INSTANCES
636: WHERE INSTANCE_ID = parInstanceId;
637:
638: EXCEPTION
639: WHEN OTHERS THEN

Line 640: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows fetched from MSC_APPS_INSTANCES');

636: WHERE INSTANCE_ID = parInstanceId;
637:
638: EXCEPTION
639: WHEN OTHERS THEN
640: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows fetched from MSC_APPS_INSTANCES');
641: RETCODE := MSC_UTIL.G_ERROR;
642: RETURN;
643: END;
644: