eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_E1APS_DEMCL dependencies on FND_PROFILE

Line 131: odi_url := fnd_profile.value('MSC_E1APS_ODIURL'); --Checking ODI Profile

127: RETURN;
128: END IF;
129:
130: /* Launching ODI Pre-Process Custom Hook Scenarios */
131: odi_url := fnd_profile.value('MSC_E1APS_ODIURL'); --Checking ODI Profile
132: IF odi_url IS NOT NULL THEN
133:
134: select instance_code into l_instance_code
135: from msc_apps_instances

Line 206: p_start_date := fnd_profile.value('MSC_E1APS_DEM_START_DATE_IN_MONTHS');

202: FROM MSD_DEM_PRICE_LISTS;
203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Inserted ' || total_rows || 'rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
204:
205:
206: p_start_date := fnd_profile.value('MSC_E1APS_DEM_START_DATE_IN_MONTHS');
207: p_end_date := fnd_profile.value('MSC_E1APS_DEM_END_DATE_IN_MONTHS');
208:
209: IF total_rows <>0 THEN
210: p_start_date := fnd_date.date_to_canonical(ADD_MONTHS(SYSDATE, - p_start_date));

Line 207: p_end_date := fnd_profile.value('MSC_E1APS_DEM_END_DATE_IN_MONTHS');

203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Inserted ' || total_rows || 'rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
204:
205:
206: p_start_date := fnd_profile.value('MSC_E1APS_DEM_START_DATE_IN_MONTHS');
207: p_end_date := fnd_profile.value('MSC_E1APS_DEM_END_DATE_IN_MONTHS');
208:
209: IF total_rows <>0 THEN
210: p_start_date := fnd_date.date_to_canonical(ADD_MONTHS(SYSDATE, - p_start_date));
211: p_end_date := fnd_date.date_to_canonical(ADD_MONTHS(SYSDATE, + p_end_date));

Line 266: odi_url := fnd_profile.value('MSC_E1APS_ODIURL'); --Checking ODI Profile

262: END IF;
263: END IF;
264:
265: /* Launching ODI Post-Process Custom Hook Scenarios */
266: odi_url := fnd_profile.value('MSC_E1APS_ODIURL'); --Checking ODI Profile
267: IF odi_url IS NOT NULL THEN
268:
269: select instance_code into l_instance_code
270: from msc_apps_instances

Line 353: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

349: RETURN;
350: END IF;
351:
352: /*Checking ODI Profile */
353: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
354: IF odi_url IS NOT NULL THEN
355: /* Launching Pre-Process Custom Hook ODI Scenario */
356: select instance_code into l_instance_code from msc_apps_instances
357: where instance_id = p_instance_id;

Line 450: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

446: RETURN;
447: END;
448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
449: /*ODI Initialize*/
450: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
451: IF odi_url IS NOT NULL THEN
452: BEGIN
453: SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
454: INTO ReturnStr

Line 482: fc_url := fnd_profile.value('MSC_E1APS_FCURL');

478: scenario_version := '001';
479: scenario_param := '';
480: ret_value :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
481: /* Copies the file from source path to destination Path */
482: fc_url := fnd_profile.value('MSC_E1APS_FCURL');
483:
484: IF fc_url IS NOT NULL AND ret_value THEN
485: scenario_name := 'IMPORTFILETOAPSSERVER';
486: scenario_version := '001';

Line 557: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

553: END IF;
554: END IF;
555:
556: /*Checking ODI Profile */
557: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
558: IF odi_url IS NOT NULL THEN
559:
560: /* Launching Post-Process Custom Hook ODI Scenario */
561: scenario_name := 'POSTPROCESSHOOKPKG';

Line 645: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

641: RETURN;
642: END IF;
643:
644: /* Checking ODI Profile*/
645: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
646: IF odi_url IS NOT NULL THEN
647: /* Launching Pre-Process Custom Hook ODI Scenario */
648: select instance_code into l_instance_code from msc_apps_instances
649: where instance_id = p_instance_id;

Line 673: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

669: END IF;
670:
671:
672: /* Checking ODI Profile*/
673: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
674: /* Invoke ODISenario*/
675: IF odi_url IS NOT NULL THEN
676: BEGIN
677: SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)

Line 720: fc_url := fnd_profile.value('MSC_E1APS_FCURL');

716: scenario_param := '';
717: ret_value :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
718:
719: /* Copies the file from source path to destination Path */
720: fc_url := fnd_profile.value('MSC_E1APS_FCURL');
721: fc_ret_value:=TRUE;
722: IF fc_url IS NOT NULL AND ret_value THEN
723: scenario_name := 'IMPORTFILESTODEMANTRASERVER';
724: scenario_version := '001';

Line 778: fc_url := fnd_profile.value('MSC_E1APS_FCURL');

774: ret_value :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
775:
776: /* Copies the file from source path to destination Path */
777:
778: fc_url := fnd_profile.value('MSC_E1APS_FCURL');
779: fc_ret_value:=TRUE;
780: IF fc_url IS NOT NULL AND ret_value THEN
781: scenario_name := 'IMPORTFILESTODEMANTRASERVER';
782: scenario_version := '001';

Line 833: fc_url := fnd_profile.value('MSC_E1APS_FCURL');

829: scenario_param := '';
830: ret_value :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
831:
832: /* Copies the file from source path to destination Path */
833: fc_url := fnd_profile.value('MSC_E1APS_FCURL');
834: fc_ret_value:=TRUE;
835: IF fc_url IS NOT NULL AND ret_value THEN
836: scenario_name := 'IMPORTFILESTODEMANTRASERVER';
837: scenario_version := '001';

Line 952: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

948: RETURN;
949: END IF;
950:
951: /* Checking ODI Profile*/
952: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
953:
954: IF odi_url IS NOT NULL THEN
955: /* Launching Pre-Process Custom Hook ODI Scenario */
956: select instance_code into l_instance_code from msc_apps_instances

Line 986: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

982: scenario_param := scenario_param
983: || p_plan_id;
984:
985: /* Checking ODI Profile*/
986: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
987: /* Invoke ODISenario*/
988: IF odi_url IS NOT NULL THEN
989: BEGIN
990: SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)

Line 1123: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

1119: RETURN;
1120: END IF;
1121:
1122: /* Checking ODI Profile*/
1123: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
1124:
1125: IF odi_url IS NOT NULL THEN
1126: /* Launching Pre-Process Custom Hook ODI Scenario */
1127: select instance_code into l_instance_code from msc_apps_instances

Line 1186: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

1182:
1183: --Bug8740081
1184: /*ODI Initializing */
1185: /* Checking ODI Profile*/
1186: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
1187:
1188: /* Invoke ODISenario */
1189: IF odi_url IS NOT NULL THEN
1190: BEGIN

Line 1302: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

1298: RETURN;
1299: END IF;
1300:
1301: /* Checking ODI Profile*/
1302: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
1303: IF odi_url IS NOT NULL THEN
1304: /* Launching Pre-Process Custom Hook ODI Scenario */
1305: select instance_code into l_instance_code
1306: from msc_apps_instances

Line 1338: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

1334: --Bug8740081
1335: /* ODI Initialization */
1336:
1337: /* Checking ODI Profile*/
1338: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
1339: /* Invoke ODISenario*/
1340: IF odi_url IS NOT NULL THEN
1341: BEGIN
1342: SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)

Line 1388: fc_url := fnd_profile.value('MSC_E1APS_FCURL');

1384: END IF;
1385:
1386:
1387: /* Copies the file from Demantra Server To E1_file_DS
1388: fc_url := fnd_profile.value('MSC_E1APS_FCURL');
1389: fc_ret_value:=FALSE;
1390: IF fc_url IS NOT NULL THEN
1391: scenario_version := '001';
1392: scenario_param := '';

Line 1492: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

1488: RETURN;
1489: END IF;
1490:
1491: /* Checking ODI Profile*/
1492: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
1493: IF odi_url IS NOT NULL THEN
1494: /* Updating ODI Pre-Process custom hook scenario_param */
1495: select instance_code into l_instance_code
1496: from msc_apps_instances

Line 1522: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');

1518: --Bug8740081
1519: --Bug8740081
1520: /*ODI Initialization*/
1521: /* Checking ODI Profile*/
1522: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
1523: /* Invoke ODISenario*/
1524: IF odi_url IS NOT NULL THEN
1525: BEGIN
1526: SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)