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 MSD_DEM_COMMON_UTILITIES

Line 531: msd_dem_common_utilities.log_message('Error Loading msd_dem_ssl_rs.run_rs Concurrent Request'

527: p_file_name := 'DemHistory.dat';
528: /* Step 3: Launching Demantra Collections */
529: msd_dem_ssl_rs.run_rs(errbuf, retcode, p_instance_id, p_auto_run, p_file_seperator, p_control_path, p_data_path, p_file_name );
530: IF NVL(to_number(retcode),0) <>0 THEN
531: msd_dem_common_utilities.log_message('Error Loading msd_dem_ssl_rs.run_rs Concurrent Request'
532: || errbuf
533: || retcode);
534: RETCODE := MSC_UTIL.G_ERROR;
535: RETURN;

Line 537: msd_dem_common_utilities.log_message('Demantra Collections Launched successfully');

533: || retcode);
534: RETCODE := MSC_UTIL.G_ERROR;
535: RETURN;
536: ELSE
537: msd_dem_common_utilities.log_message('Demantra Collections Launched successfully');
538: END IF;
539: /*Launching CP for Calender */
540: v_request_id := fnd_request.submit_request('MSD', -- appln short name
541: 'MSDDEMDC', -- short name of conc pgm

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

705: FROM MSC_APPS_INSTANCES
706: WHERE INSTANCE_ID = p_instance_id;
707:
708: /* Bug#8224935 - APP ID */
709: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_PTP', 1, 'user_id'));
710: /*Launching LIST PRICE ODI Senario*/
711: IF p_list_price = 1 THEN
712: /*Calling 'MSC_E1APS_ODIScenarioExecute' Function by using the 'CALL_ODIEXE' function
713: by passing the Senario name, version,parameter,odiurl */

Line 759: msd_dem_common_utilities.log_message('LIST PRICE DEM WORKFLOW NOT LAUNCHED. Process ID: ' || process_id);

755: /* Calling LIST PRICE DEM WorkFlow*/
756: l_wf_lookup_code := 'WF_AIA_E1_PTP_PROMOPRICE_DWNLD';
757: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, RETCODE,l_wf_lookup_code , process_id, l_user_id);
758: IF retcode= -1 OR process_id= -1 THEN
759: msd_dem_common_utilities.log_message('LIST PRICE DEM WORKFLOW NOT LAUNCHED. Process ID: ' || process_id);
760: RETCODE := MSC_UTIL.G_ERROR;
761: RETURN;
762: ELSE
763: msd_dem_common_utilities.log_message('LIST PRICE DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);

Line 763: msd_dem_common_utilities.log_message('LIST PRICE DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);

759: msd_dem_common_utilities.log_message('LIST PRICE DEM WORKFLOW NOT LAUNCHED. Process ID: ' || process_id);
760: RETCODE := MSC_UTIL.G_ERROR;
761: RETURN;
762: ELSE
763: msd_dem_common_utilities.log_message('LIST PRICE DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);
764: END IF;
765: END IF;
766: END IF;
767: /*Launching ITEM COST ODI Senario*/

Line 816: msd_dem_common_utilities.log_message('ITEM COST DEM WORKFLOW NOT LAUNCHED.' || process_id);

812: /* Calling DEM WorkFlow*/
813: l_wf_lookup_code := 'WF_AIA_E1_PTP_PROMOCOST_DWNLD';
814: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, RETCODE,l_wf_lookup_code , process_id, l_user_id);
815: IF retcode= -1 OR process_id= -1 THEN
816: msd_dem_common_utilities.log_message('ITEM COST DEM WORKFLOW NOT LAUNCHED.' || process_id);
817: RETCODE := MSC_UTIL.G_ERROR;
818: RETURN;
819: ELSE
820: msd_dem_common_utilities.log_message('ITEM COST DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);

Line 820: msd_dem_common_utilities.log_message('ITEM COST DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);

816: msd_dem_common_utilities.log_message('ITEM COST DEM WORKFLOW NOT LAUNCHED.' || process_id);
817: RETCODE := MSC_UTIL.G_ERROR;
818: RETURN;
819: ELSE
820: msd_dem_common_utilities.log_message('ITEM COST DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);
821: END IF;
822: END IF;
823: END IF;
824: /*Launching PRICE HISTORY ODI Senario*/

Line 870: msd_dem_common_utilities.log_message('PRICE HISTORY DEM WORKFLOW NOT LAUNCHED.Process ID: ' || process_id);

866: /* Calling DEM WorkFlow*/
867: l_wf_lookup_code := 'WF_AIA_E1_PTP_PRICEHIST_DWNLD';
868: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, RETCODE,l_wf_lookup_code , process_id, l_user_id);
869: IF retcode= -1 OR process_id= -1 THEN
870: msd_dem_common_utilities.log_message('PRICE HISTORY DEM WORKFLOW NOT LAUNCHED.Process ID: ' || process_id);
871: RETCODE := MSC_UTIL.G_ERROR;
872: RETURN;
873: ELSE
874: msd_dem_common_utilities.log_message('PRICE HISTORY DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);

Line 874: msd_dem_common_utilities.log_message('PRICE HISTORY DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);

870: msd_dem_common_utilities.log_message('PRICE HISTORY DEM WORKFLOW NOT LAUNCHED.Process ID: ' || process_id);
871: RETCODE := MSC_UTIL.G_ERROR;
872: RETURN;
873: ELSE
874: msd_dem_common_utilities.log_message('PRICE HISTORY DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);
875: END IF;
876: END IF;
877: END IF;
878:

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

1175: execute immediate x_sql ;
1176: commit;
1177:
1178: /* Bug#8224935 - APP ID */
1179: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_DM', 1, 'user_id'));
1180: l_wf_lookup_code := 'WF_AIA_FORECAST_EXPORT';
1181: scenario_name := 'LOADDMFORECASTDATATOE1PKG';
1182:
1183: --Bug8740081

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

1326: END IF;
1327: END IF;
1328:
1329: /* Bug#8224935 - APP ID */
1330: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_PTP', 1, 'user_id'));
1331: l_wf_lookup_code := 'WF_AIA_PTP_E1_UPLD_PROM_PRIC';
1332: scenario_name := 'LOADDMPROMOTIONPRICINGDATATOE1PKG';
1333:
1334: --Bug8740081

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

1545:
1546: END IF;
1547:
1548: /* Bug#8224935 - APP ID */
1549: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_PTP', 1, 'user_id'));
1550: IF p_pb_claims = MSC_UTIL.SYS_YES THEN
1551: l_wf_lookup_code := 'WF_AIA_DSM_E1_CLAIM_EXP';
1552: scenario_name := 'LOADDMCLAIMDATATOE1PKG';
1553: ret_value:=MSC_E1APS_UTIL.PUBLISH_DEM_WORKFLOW(ERRBUF ,RETCODE ,p_instance_id ,l_wf_lookup_code ,scenario_name,l_user_id);