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_UTIL dependencies on MSD_DEM_COMMON_UTILITIES

Line 357: msd_dem_common_utilities.log_debug ('Entering: MSC_E1APS_UTIL.DEM_WORKFLOW - '

353: -- Bug#7199587 syenamar
354: l_schema_name VARCHAR2(255);
355: l_schema_id NUMBER;
356: BEGIN
357: msd_dem_common_utilities.log_debug ('Entering: MSC_E1APS_UTIL.DEM_WORKFLOW - '
358: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
359: DEM_SCHEMA := fnd_profile.value('MSD_DEM_SCHEMA');
360: IF fnd_profile.value('MSD_DEM_SCHEMA') IS NOT NULL THEN
361: l_user_id := p_user_id;

Line 370: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_SOP', 1, 'user_id'));

366: ||l_user_id;
367: EXECUTE immediate l_sql INTO l_user_name, l_password;
368: ELSE
369: /* Bug#8224935 - APP ID */
370: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_SOP', 1, 'user_id'));
371: IF l_user_id IS NOT NULL THEN
372: l_sql := 'select user_name, password from '
373: ||dem_schema
374: ||'.user_id where user_id = '

Line 378: msd_dem_common_utilities.log_message('Component is not found.');

374: ||'.user_id where user_id = '
375: ||l_user_id;
376: EXECUTE immediate l_sql INTO l_user_name, l_password;
377: ELSE
378: msd_dem_common_utilities.log_message('Component is not found.');
379: END IF;
380: END IF;
381: IF l_user_name IS NOT NULL THEN
382: l_url := fnd_profile.value('MSD_DEM_HOST_URL');

Line 387: l_schema_name := msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', l_wf_lookup_code, 1, 'schema_name');

383: -- Bug#7199587 syenamar
384: -- Do not hard-code 'EBS Full Download' workflow name here. Get its ID from lookup, get its name from demantra schema using the ID.
385: /* Bug#8224935 - APP ID */
386: -- l_wf_lookup_code is a schema_id in the database and meaning column in common lookup
387: l_schema_name := msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', l_wf_lookup_code, 1, 'schema_name');
388: l_schema_name := trim(l_schema_name);
389: l_sql := NULL;
390: l_sql := 'SELECT
391: utl_http.request('''

Line 400: msd_dem_common_utilities.log_debug (l_sql);

396: ||l_password
397: ||'&schema='
398: || REPLACE(l_schema_name, ' ', '%20')
399: ||'&sync=no'') FROM dual';
400: msd_dem_common_utilities.log_debug (l_sql);
401: EXECUTE immediate l_sql INTO process_id;
402: -- msd_dem_common_utilities.log_message('Process Id:'||l_dummy);
403: -- syenamar
404: ELSE

Line 402: -- msd_dem_common_utilities.log_message('Process Id:'||l_dummy);

398: || REPLACE(l_schema_name, ' ', '%20')
399: ||'&sync=no'') FROM dual';
400: msd_dem_common_utilities.log_debug (l_sql);
401: EXECUTE immediate l_sql INTO process_id;
402: -- msd_dem_common_utilities.log_message('Process Id:'||l_dummy);
403: -- syenamar
404: ELSE
405: msd_dem_common_utilities.log_message('Error in launching the download workflow.');
406: retcode := -1;

Line 405: msd_dem_common_utilities.log_message('Error in launching the download workflow.');

401: EXECUTE immediate l_sql INTO process_id;
402: -- msd_dem_common_utilities.log_message('Process Id:'||l_dummy);
403: -- syenamar
404: ELSE
405: msd_dem_common_utilities.log_message('Error in launching the download workflow.');
406: retcode := -1;
407: RETURN;
408: END IF;
409: ELSE

Line 410: msd_dem_common_utilities.log_message('Demantra Schema not set');

406: retcode := -1;
407: RETURN;
408: END IF;
409: ELSE
410: msd_dem_common_utilities.log_message('Demantra Schema not set');
411: END IF;
412: /* ELSE
413: msd_dem_common_utilities.log_message ('Auto Run Download - No ');
414: msd_dem_common_utilities.log_message ('Exiting without launching the download workflow.');

Line 413: msd_dem_common_utilities.log_message ('Auto Run Download - No ');

409: ELSE
410: msd_dem_common_utilities.log_message('Demantra Schema not set');
411: END IF;
412: /* ELSE
413: msd_dem_common_utilities.log_message ('Auto Run Download - No ');
414: msd_dem_common_utilities.log_message ('Exiting without launching the download workflow.');
415: END IF; */
416: msd_dem_common_utilities.log_debug ('Exiting: MSC_E1APS_UTIL.DEM_WORKFLOW - '
417: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 414: msd_dem_common_utilities.log_message ('Exiting without launching the download workflow.');

410: msd_dem_common_utilities.log_message('Demantra Schema not set');
411: END IF;
412: /* ELSE
413: msd_dem_common_utilities.log_message ('Auto Run Download - No ');
414: msd_dem_common_utilities.log_message ('Exiting without launching the download workflow.');
415: END IF; */
416: msd_dem_common_utilities.log_debug ('Exiting: MSC_E1APS_UTIL.DEM_WORKFLOW - '
417: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
418: EXCEPTION

Line 416: msd_dem_common_utilities.log_debug ('Exiting: MSC_E1APS_UTIL.DEM_WORKFLOW - '

412: /* ELSE
413: msd_dem_common_utilities.log_message ('Auto Run Download - No ');
414: msd_dem_common_utilities.log_message ('Exiting without launching the download workflow.');
415: END IF; */
416: msd_dem_common_utilities.log_debug ('Exiting: MSC_E1APS_UTIL.DEM_WORKFLOW - '
417: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
418: EXCEPTION
419: WHEN OTHERS THEN
420: errbuf := SUBSTR(SQLERRM,1,150);

Line 426: msd_dem_common_utilities.log_message ('Exception: MSC_E1APS_UTIL.DEM_WORKFLOW - '

422: -- l_stmt := 'begin ' || DEM_SCHEMA || '.DATA_LOAD.LOG_EP_LOAD_FAILURE; end;';
423: -- execute immediate l_stmt;
424: -- l_stmt := 'alter session set current_schema=APPS';
425: -- execute immediate l_stmt;
426: msd_dem_common_utilities.log_message ('Exception: MSC_E1APS_UTIL.DEM_WORKFLOW - '
427: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
428: msd_dem_common_utilities.log_message (errbuf);
429: RETURN;
430: END DEM_WORKFLOW;

Line 428: msd_dem_common_utilities.log_message (errbuf);

424: -- l_stmt := 'alter session set current_schema=APPS';
425: -- execute immediate l_stmt;
426: msd_dem_common_utilities.log_message ('Exception: MSC_E1APS_UTIL.DEM_WORKFLOW - '
427: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
428: msd_dem_common_utilities.log_message (errbuf);
429: RETURN;
430: END DEM_WORKFLOW;
431: /*Function To Launch Demantra Workflow and Executes ODI*/
432: FUNCTION PUBLISH_DEM_WORKFLOW(ERRBUF OUT NOCOPY VARCHAR2 ,

Line 470: msd_dem_common_utilities.log_message('DEM WORKFLOW NOT LAUNCHED');

466: /* Profile for Demantra WorkFlow TimeOut */
467: demTimeOut := fnd_profile.value('MSC_E1APS_DEM_WF_TIME_OUT');
468:
469: IF retcode= -1 OR ret_process_id = -1 THEN
470: msd_dem_common_utilities.log_message('DEM WORKFLOW NOT LAUNCHED');
471: RETURN 2;
472: ELSE
473: msd_dem_common_utilities.log_message('DEM WORKFLOW LAUNCHED.Process Id:'
474: ||ret_process_id );

Line 473: msd_dem_common_utilities.log_message('DEM WORKFLOW LAUNCHED.Process Id:'

469: IF retcode= -1 OR ret_process_id = -1 THEN
470: msd_dem_common_utilities.log_message('DEM WORKFLOW NOT LAUNCHED');
471: RETURN 2;
472: ELSE
473: msd_dem_common_utilities.log_message('DEM WORKFLOW LAUNCHED.Process Id:'
474: ||ret_process_id );
475: g_demantra_schema := msd_dem_demantra_utilities.get_demantra_schema;
476: LOOP
477: dem_cnt:=dem_cnt+ 1; -- +1 indicates 60 seconds

Line 488: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW COMPLETED SUCCESSFULLY');

484: || ret_process_id;
485: EXECUTE immediate v_sql INTO dem_status;
486: DBMS_LOCK.sleep(sleepTime);
487: IF dem_status = 0 THEN
488: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW COMPLETED SUCCESSFULLY');
489: EXIT;
490: elsif dem_cnt = demTimeOut THEN
491: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW TIMEOUT');
492: msd_dem_common_utilities.log_message('PLEASE CHECK THE DEMANTRA WORKFLOW STATUS.');

Line 491: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW TIMEOUT');

487: IF dem_status = 0 THEN
488: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW COMPLETED SUCCESSFULLY');
489: EXIT;
490: elsif dem_cnt = demTimeOut THEN
491: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW TIMEOUT');
492: msd_dem_common_utilities.log_message('PLEASE CHECK THE DEMANTRA WORKFLOW STATUS.');
493: dem_flag:= DEM_WARNING;
494: EXIT;
495: elsif dem_status = -1 THEN

Line 492: msd_dem_common_utilities.log_message('PLEASE CHECK THE DEMANTRA WORKFLOW STATUS.');

488: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW COMPLETED SUCCESSFULLY');
489: EXIT;
490: elsif dem_cnt = demTimeOut THEN
491: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW TIMEOUT');
492: msd_dem_common_utilities.log_message('PLEASE CHECK THE DEMANTRA WORKFLOW STATUS.');
493: dem_flag:= DEM_WARNING;
494: EXIT;
495: elsif dem_status = -1 THEN
496: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW FAILED.');

Line 496: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW FAILED.');

492: msd_dem_common_utilities.log_message('PLEASE CHECK THE DEMANTRA WORKFLOW STATUS.');
493: dem_flag:= DEM_WARNING;
494: EXIT;
495: elsif dem_status = -1 THEN
496: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW FAILED.');
497: dem_flag:= DEM_FAILURE;
498: EXIT;
499: END IF;
500: END LOOP;