APPS.MSC_E1_APS_PDP dependencies on FND_PROFILE

Line 104: ws_prf := fnd_profile.value('MSC_E1APS_ODIURL');

100: RETURN FALSE;
101: end if;
102:
103: -- Changes for bug # 12897298
104: ws_prf := fnd_profile.value('MSC_E1APS_ODIURL');
105: sql_cnd := 'select INSTR('''||ws_prf||''','''||srch_str||''') from dual';
106: EXECUTE immediate sql_cnd into chk_cnd;
107: IF (chk_cnd > 0) THEN -- Execute only if its 11G
108: if (SessionNum <> '-1' and length(ErrMessage) IS NULL) then

Line 304: WSURL := fnd_profile.value('MSC_E1APS_ODIURL');

300: RETCODE := MSC_UTIL.G_ERROR;
301: RETURN;
302: END IF;
303:
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

Line 584: WSURL := fnd_profile.value('MSC_E1APS_ODIURL');

580: /*Initialize ODI */
581:
582: MSC_UTIL.MSC_DEBUG('INITIALIZING ODI ....');
583:
584: WSURL := fnd_profile.value('MSC_E1APS_ODIURL');
585:
586: IF WSURL IS NOT NULL THEN
587: BEGIN
588: select MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(WSURL,parBaseDate) into ReturnStr from dual;

Line 778: varTimeOut := fnd_profile.value('MSC_E1APS_TIME_OUT');

774:
775: MSC_UTIL.MSC_DEBUG('Before Lauching Pre-processor');
776:
777: -- Getting profile values set -- for bug # 11769639
778: varTimeOut := fnd_profile.value('MSC_E1APS_TIME_OUT');
779: varBatchSize := fnd_profile.value('MSC_E1APS_BATCH_SIZE');
780: varNumWorkers := fnd_profile.value('MSC_E1APS_NO_OF_WORKERS');
781:
782: -- checking if the profile values are set

Line 779: varBatchSize := fnd_profile.value('MSC_E1APS_BATCH_SIZE');

775: MSC_UTIL.MSC_DEBUG('Before Lauching Pre-processor');
776:
777: -- Getting profile values set -- for bug # 11769639
778: varTimeOut := fnd_profile.value('MSC_E1APS_TIME_OUT');
779: varBatchSize := fnd_profile.value('MSC_E1APS_BATCH_SIZE');
780: varNumWorkers := fnd_profile.value('MSC_E1APS_NO_OF_WORKERS');
781:
782: -- checking if the profile values are set
783: IF varTimeOut IS NULL THEN

Line 780: varNumWorkers := fnd_profile.value('MSC_E1APS_NO_OF_WORKERS');

776:
777: -- Getting profile values set -- for bug # 11769639
778: varTimeOut := fnd_profile.value('MSC_E1APS_TIME_OUT');
779: varBatchSize := fnd_profile.value('MSC_E1APS_BATCH_SIZE');
780: varNumWorkers := fnd_profile.value('MSC_E1APS_NO_OF_WORKERS');
781:
782: -- checking if the profile values are set
783: IF varTimeOut IS NULL THEN
784: varTimeOut := 180;

Line 866: WSURL := fnd_profile.value('MSC_E1APS_ODIURL');

862: RETURN;
863: END IF;
864:
865:
866: WSURL := fnd_profile.value('MSC_E1APS_ODIURL');
867: IF WSURL IS NOT NULL THEN
868: /* Launching Post-Process Custom Hook ODI Scenario */
869: scenario_name := 'POSTPROCESSHOOKPKG';
870: scenario_version := '001';