APPS.MSC_E1APS_DSMCOLL dependencies on MSD_DEM_COMMON_UTILITIES

Line 122: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID',

118:
119: select ATTRIBUTE14,ATTRIBUTE13 into source_file,destination_file from MSC_APPS_INSTANCES where INSTANCE_ID = parInstanceID;
120:
121: /* Bug#8224935 - APP ID */
122: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID',
123: 'COMP_PTP',
124: 1,
125: 'user_id'));
126: /*Initialize ODI*/

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

188: /* Lauch Demantra Work Flow */
189: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, retcode, l_wf_lookup_code,process_id,l_user_id);
190:
191: if retcode = -1 or process_id= -1 then
192: msd_dem_common_utilities.log_message('DEM WORKFLOW NOT LAUNCHED');
193: RETCODE := MSC_UTIL.G_ERROR;
194: RETURN;
195: else
196: msd_dem_common_utilities.log_message('DEM WORKFLOW LAUNCHED. Process ID: ' || process_id );

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

192: msd_dem_common_utilities.log_message('DEM WORKFLOW NOT LAUNCHED');
193: RETCODE := MSC_UTIL.G_ERROR;
194: RETURN;
195: else
196: msd_dem_common_utilities.log_message('DEM WORKFLOW LAUNCHED. Process ID: ' || process_id );
197: end if;
198: END IF;
199:
200: END IF;

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

237: /* Lauch Demantra Work Flow */
238: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, retcode, l_wf_lookup_code,process_id,l_user_id);
239:
240: if retcode= -1 then
241: msd_dem_common_utilities.log_message('DEM WORKFLOW NOT LAUNCHED');
242: RETCODE := MSC_UTIL.G_ERROR;
243: RETURN;
244: else
245: msd_dem_common_utilities.log_message('DEM WORKFLOW LAUNCHED. Process ID: ' || process_id );

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

241: msd_dem_common_utilities.log_message('DEM WORKFLOW NOT LAUNCHED');
242: RETCODE := MSC_UTIL.G_ERROR;
243: RETURN;
244: else
245: msd_dem_common_utilities.log_message('DEM WORKFLOW LAUNCHED. Process ID: ' || process_id );
246: end if;
247:
248: END IF;
249: END IF;