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.MSD_DEM_PUSH_SETUP_PARAMETERS dependencies on MSD_DEM_COMMON_UTILITIES

Line 59: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.get_profile_value - ' || sysdate);

55: RETURN x_return_value;
56:
57: EXCEPTION
58: WHEN OTHERS THEN
59: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.get_profile_value - ' || sysdate);
60: RETURN NULL;
61:
62: END GET_PROFILE_VALUE;
63:

Line 87: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.get_function_value - ' || sysdate);

83: RETURN x_return_value;
84:
85: EXCEPTION
86: WHEN OTHERS THEN
87: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.get_function_value - ' || sysdate);
88: RETURN NULL;
89:
90: END GET_FUNCTION_VALUE;
91:

Line 107: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.get_multi_org_flag - ' || sysdate);

103: RETURN x_return_value;
104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.get_multi_org_flag - ' || sysdate);
108: RETURN NULL;
109:
110: END GET_MULTI_ORG_FLAG;
111:

Line 130: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.decode_profile_function - ' || sysdate);

126: RETURN x_return_value;
127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.decode_profile_function - ' || sysdate);
131: RETURN NULL;
132:
133: END DECODE_PROFILE_FUNCTION;
134:

Line 176: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.check_customer_attribute - ' || sysdate);

172: x_sql VARCHAR2(1000) := NULL;
173:
174: BEGIN
175:
176: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.check_customer_attribute - ' || sysdate);
177:
178: /*
179: * If collecting for the first time, then the table msd_dem_setup_parameters
180: * will be empty in the source instance

Line 191: msd_dem_common_utilities.log_message (x_check_customer_attr_log_msg);

187:
188: x_sql := 'BEGIN :x_out1 := msd_dem_sr_util.set_customer_attribute' || g_dblink ||
189: ' (''MSD_DEM_CUSTOMER_ATTRIBUTE'', ''NONE'', ''SITE''); END;';
190: EXECUTE IMMEDIATE x_sql USING OUT x_set_profile;
191: msd_dem_common_utilities.log_message (x_check_customer_attr_log_msg);
192:
193: IF (x_set_profile = 2)
194: THEN
195: retcode := -1;

Line 197: msd_dem_common_utilities.log_message ('Error: msd_dem_push_setup_parameters.check_customer_attribute - ' || sysdate);

193: IF (x_set_profile = 2)
194: THEN
195: retcode := -1;
196: errbuf := 'Error while Setting Value for Profile MSD_CUSTOMER_ATTRIBUTE';
197: msd_dem_common_utilities.log_message ('Error: msd_dem_push_setup_parameters.check_customer_attribute - ' || sysdate);
198: msd_dem_common_utilities.log_message ('Error while Setting Value for Profile MSD_CUSTOMER_ATTRIBUTE');
199: RETURN;
200: END IF;
201:

Line 198: msd_dem_common_utilities.log_message ('Error while Setting Value for Profile MSD_CUSTOMER_ATTRIBUTE');

194: THEN
195: retcode := -1;
196: errbuf := 'Error while Setting Value for Profile MSD_CUSTOMER_ATTRIBUTE';
197: msd_dem_common_utilities.log_message ('Error: msd_dem_push_setup_parameters.check_customer_attribute - ' || sysdate);
198: msd_dem_common_utilities.log_message ('Error while Setting Value for Profile MSD_CUSTOMER_ATTRIBUTE');
199: RETURN;
200: END IF;
201:
202: COMMIT;

Line 205: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.check_customer_attribute - ' || sysdate);

201:
202: COMMIT;
203: retcode := 1;
204: END IF;
205: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.check_customer_attribute - ' || sysdate);
206:
207: EXCEPTION
208: WHEN OTHERS THEN
209: retcode := -1 ;

Line 211: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.check_customer_attribute - ' || sysdate);

207: EXCEPTION
208: WHEN OTHERS THEN
209: retcode := -1 ;
210: errbuf := substr(SQLERRM,1,150);
211: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.check_customer_attribute - ' || sysdate);
212: msd_dem_common_utilities.log_message (errbuf);
213: RETURN;
214:
215: END CHECK_CUSTOMER_ATTRIBUTE;

Line 212: msd_dem_common_utilities.log_message (errbuf);

208: WHEN OTHERS THEN
209: retcode := -1 ;
210: errbuf := substr(SQLERRM,1,150);
211: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.check_customer_attribute - ' || sysdate);
212: msd_dem_common_utilities.log_message (errbuf);
213: RETURN;
214:
215: END CHECK_CUSTOMER_ATTRIBUTE;
216:

Line 234: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.init - ' || sysdate);

230: x_retcode VARCHAR2(100) := NULL;
231:
232: BEGIN
233:
234: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.init - ' || sysdate);
235:
236: g_profile_list(1).profile_code := 'MSD_DEM_CATEGORY_SET_NAME';
237: g_profile_list(1).function_name := 'MSD_DEM_SR_UTIL.GET_CATEGORY_SET_ID';
238: g_profile_list(1).destination_flag := 'N';

Line 281: g_profile_list(11).function_name := 'MSD_DEM_COMMON_UTILITIES.GET_SPF_SR_CAT_SET_ID(' || to_char(p_sr_instance_id) || ')';

277: g_profile_list(10).destination_flag := 'Y';
278: g_profile_list(10).function_profile_code := 'P';
279:
280: g_profile_list(11).profile_code := 'MSC_SERVICE_LEVEL_CATEGORY_SET';
281: g_profile_list(11).function_name := 'MSD_DEM_COMMON_UTILITIES.GET_SPF_SR_CAT_SET_ID(' || to_char(p_sr_instance_id) || ')';
282: g_profile_list(11).destination_flag := 'Y';
283: g_profile_list(11).function_profile_code := 'F';
284:
285: g_profile_list(12).profile_code := 'MSD_SPF_FAILURE_RATE_HIST_BASIS';

Line 290: g_profile_list(13).function_name := 'MSD_DEM_COMMON_UTILITIES.DM_TIME_LEVEL';

286: g_profile_list(12).destination_flag := 'Y';
287: g_profile_list(12).function_profile_code := 'P';
288:
289: g_profile_list(13).profile_code := 'MSD_DEM_DAY_LEVEL';
290: g_profile_list(13).function_name := 'MSD_DEM_COMMON_UTILITIES.DM_TIME_LEVEL';
291: g_profile_list(13).destination_flag := 'Y';
292: g_profile_list(13).function_profile_code := 'F';
293:
294: g_profile_list(14).profile_code := 'MSD_SPF_MASTER_ORG';

Line 313: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.init - ' || sysdate);

309: g_profile_list(17).function_profile_code := 'P';
310:
311: g_num_profiles := g_profile_list.LAST;
312:
313: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.init - ' || sysdate);
314:
315: EXCEPTION
316: WHEN OTHERS THEN
317: retcode := -1 ;

Line 319: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.init - ' || sysdate);

315: EXCEPTION
316: WHEN OTHERS THEN
317: retcode := -1 ;
318: errbuf := substr(SQLERRM,1,150);
319: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.init - ' || sysdate);
320: msd_dem_common_utilities.log_message (errbuf);
321: RETURN;
322:
323: END INIT;

Line 320: msd_dem_common_utilities.log_message (errbuf);

316: WHEN OTHERS THEN
317: retcode := -1 ;
318: errbuf := substr(SQLERRM,1,150);
319: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.init - ' || sysdate);
320: msd_dem_common_utilities.log_message (errbuf);
321: RETURN;
322:
323: END INIT;
324:

Line 352: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_profiles - ' || sysdate);

348: x_sql VARCHAR2(1000) := NULL;
349:
350: BEGIN
351:
352: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_profiles - ' || sysdate);
353:
354: x_sql := 'alter session set session_cached_cursors = 0';
355: execute immediate x_sql;
356:

Line 358: msd_dem_common_utilities.log_message (' Push Profiles ');

354: x_sql := 'alter session set session_cached_cursors = 0';
355: execute immediate x_sql;
356:
357:
358: msd_dem_common_utilities.log_message (' Push Profiles ');
359: msd_dem_common_utilities.log_message ('---------------');
360: msd_dem_common_utilities.log_message (' ');
361: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
362: msd_dem_common_utilities.log_message (' Profile Name - Value');

Line 359: msd_dem_common_utilities.log_message ('---------------');

355: execute immediate x_sql;
356:
357:
358: msd_dem_common_utilities.log_message (' Push Profiles ');
359: msd_dem_common_utilities.log_message ('---------------');
360: msd_dem_common_utilities.log_message (' ');
361: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
362: msd_dem_common_utilities.log_message (' Profile Name - Value');
363: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');

Line 360: msd_dem_common_utilities.log_message (' ');

356:
357:
358: msd_dem_common_utilities.log_message (' Push Profiles ');
359: msd_dem_common_utilities.log_message ('---------------');
360: msd_dem_common_utilities.log_message (' ');
361: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
362: msd_dem_common_utilities.log_message (' Profile Name - Value');
363: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
364:

Line 361: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');

357:
358: msd_dem_common_utilities.log_message (' Push Profiles ');
359: msd_dem_common_utilities.log_message ('---------------');
360: msd_dem_common_utilities.log_message (' ');
361: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
362: msd_dem_common_utilities.log_message (' Profile Name - Value');
363: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
364:
365: /* Initializing profiles */

Line 362: msd_dem_common_utilities.log_message (' Profile Name - Value');

358: msd_dem_common_utilities.log_message (' Push Profiles ');
359: msd_dem_common_utilities.log_message ('---------------');
360: msd_dem_common_utilities.log_message (' ');
361: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
362: msd_dem_common_utilities.log_message (' Profile Name - Value');
363: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
364:
365: /* Initializing profiles */
366: init (x_errbuf,

Line 363: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');

359: msd_dem_common_utilities.log_message ('---------------');
360: msd_dem_common_utilities.log_message (' ');
361: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
362: msd_dem_common_utilities.log_message (' Profile Name - Value');
363: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
364:
365: /* Initializing profiles */
366: init (x_errbuf,
367: x_retcode,

Line 374: msd_dem_common_utilities.log_message (rpad('Profile ' || g_profile_list(i).profile_code,40)

370: /* Get the Profile values */
371: FOR i IN g_profile_list.FIRST..g_profile_list.LAST
372: LOOP
373: g_profile_list(i).profile_value := decode_profile_function (g_profile_list(i));
374: msd_dem_common_utilities.log_message (rpad('Profile ' || g_profile_list(i).profile_code,40)
375: || '- ' || g_profile_list(i).profile_value);
376: END LOOP;
377:
378: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');

Line 378: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');

374: msd_dem_common_utilities.log_message (rpad('Profile ' || g_profile_list(i).profile_code,40)
375: || '- ' || g_profile_list(i).profile_value);
376: END LOOP;
377:
378: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
379: msd_dem_common_utilities.log_message (' ');
380:
381: /* Check if all the mandatory profiles are defined */
382: IF ( (g_profile_list(2).profile_value IS NULL)

Line 379: msd_dem_common_utilities.log_message (' ');

375: || '- ' || g_profile_list(i).profile_value);
376: END LOOP;
377:
378: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
379: msd_dem_common_utilities.log_message (' ');
380:
381: /* Check if all the mandatory profiles are defined */
382: IF ( (g_profile_list(2).profile_value IS NULL)
383: OR (g_profile_list(3).profile_value IS NULL)

Line 423: msd_dem_common_utilities.log_message ('Profile ' ||

419: /* If Two-Level Planning has not been set, then default it to NO
420: */
421: IF (g_profile_list(6).profile_value IS NULL)
422: THEN
423: msd_dem_common_utilities.log_message ('Profile ' ||
424: g_profile_list(6).profile_code ||
425: ' is not defined. Defaulting this profile to - ');
426: msd_dem_common_utilities.log_message ('''Exclude family members with forecast control NONE''');
427: g_profile_list(6).profile_value := 2;

Line 426: msd_dem_common_utilities.log_message ('''Exclude family members with forecast control NONE''');

422: THEN
423: msd_dem_common_utilities.log_message ('Profile ' ||
424: g_profile_list(6).profile_code ||
425: ' is not defined. Defaulting this profile to - ');
426: msd_dem_common_utilities.log_message ('''Exclude family members with forecast control NONE''');
427: g_profile_list(6).profile_value := 2;
428:
429: END IF;
430:

Line 433: msd_dem_common_utilities.log_message ('Profile ' || g_profile_list(4).profile_code ||

429: END IF;
430:
431: IF ( (x_error <> 1) AND (x_warning = 1) )
432: THEN
433: msd_dem_common_utilities.log_message ('Profile ' || g_profile_list(4).profile_code ||
434: ' in the Source instance NOT SET !!!');
435: msd_dem_common_utilities.log_message ('The system has determined to use Organization Id = ' ||
436: g_profile_list(4).profile_value ||
437: ' as the master org.');

Line 435: msd_dem_common_utilities.log_message ('The system has determined to use Organization Id = ' ||

431: IF ( (x_error <> 1) AND (x_warning = 1) )
432: THEN
433: msd_dem_common_utilities.log_message ('Profile ' || g_profile_list(4).profile_code ||
434: ' in the Source instance NOT SET !!!');
435: msd_dem_common_utilities.log_message ('The system has determined to use Organization Id = ' ||
436: g_profile_list(4).profile_value ||
437: ' as the master org.');
438: msd_dem_common_utilities.log_message ('If this is not the master org, please update the MSD_DEM_MASTER_ORG profile on the Source');
439: msd_dem_common_utilities.log_message ('and rerun collections.');

Line 438: msd_dem_common_utilities.log_message ('If this is not the master org, please update the MSD_DEM_MASTER_ORG profile on the Source');

434: ' in the Source instance NOT SET !!!');
435: msd_dem_common_utilities.log_message ('The system has determined to use Organization Id = ' ||
436: g_profile_list(4).profile_value ||
437: ' as the master org.');
438: msd_dem_common_utilities.log_message ('If this is not the master org, please update the MSD_DEM_MASTER_ORG profile on the Source');
439: msd_dem_common_utilities.log_message ('and rerun collections.');
440: END IF;
441:
442: IF (x_error = 1 AND p_for_spf = 2)

Line 439: msd_dem_common_utilities.log_message ('and rerun collections.');

435: msd_dem_common_utilities.log_message ('The system has determined to use Organization Id = ' ||
436: g_profile_list(4).profile_value ||
437: ' as the master org.');
438: msd_dem_common_utilities.log_message ('If this is not the master org, please update the MSD_DEM_MASTER_ORG profile on the Source');
439: msd_dem_common_utilities.log_message ('and rerun collections.');
440: END IF;
441:
442: IF (x_error = 1 AND p_for_spf = 2)
443: THEN

Line 444: msd_dem_common_utilities.log_message ('Please make sure that profiles ' ||

440: END IF;
441:
442: IF (x_error = 1 AND p_for_spf = 2)
443: THEN
444: msd_dem_common_utilities.log_message ('Please make sure that profiles ' ||
445: 'MSD_DEM_CONVERSION_TYPE and MSD_DEM_MASTER_ORG are set in Source instance');
446: msd_dem_common_utilities.log_message (' and MSD_DEM_PLANNING_PERCENTAGE and MSD_DEM_INCLUDE_DEPENDENT_DEMAND and MSD_DEM_EXPLODE_DEMAND_METHOD');
447: msd_dem_common_utilities.log_message (' and MSD_DEM_CURRENCY_CODE and MSD_DEM_SCHEMA profiles in the Planning Server are set.');
448:

Line 446: msd_dem_common_utilities.log_message (' and MSD_DEM_PLANNING_PERCENTAGE and MSD_DEM_INCLUDE_DEPENDENT_DEMAND and MSD_DEM_EXPLODE_DEMAND_METHOD');

442: IF (x_error = 1 AND p_for_spf = 2)
443: THEN
444: msd_dem_common_utilities.log_message ('Please make sure that profiles ' ||
445: 'MSD_DEM_CONVERSION_TYPE and MSD_DEM_MASTER_ORG are set in Source instance');
446: msd_dem_common_utilities.log_message (' and MSD_DEM_PLANNING_PERCENTAGE and MSD_DEM_INCLUDE_DEPENDENT_DEMAND and MSD_DEM_EXPLODE_DEMAND_METHOD');
447: msd_dem_common_utilities.log_message (' and MSD_DEM_CURRENCY_CODE and MSD_DEM_SCHEMA profiles in the Planning Server are set.');
448:
449: retcode := -1;
450: errbuf := 'Profiles not set';

Line 447: msd_dem_common_utilities.log_message (' and MSD_DEM_CURRENCY_CODE and MSD_DEM_SCHEMA profiles in the Planning Server are set.');

443: THEN
444: msd_dem_common_utilities.log_message ('Please make sure that profiles ' ||
445: 'MSD_DEM_CONVERSION_TYPE and MSD_DEM_MASTER_ORG are set in Source instance');
446: msd_dem_common_utilities.log_message (' and MSD_DEM_PLANNING_PERCENTAGE and MSD_DEM_INCLUDE_DEPENDENT_DEMAND and MSD_DEM_EXPLODE_DEMAND_METHOD');
447: msd_dem_common_utilities.log_message (' and MSD_DEM_CURRENCY_CODE and MSD_DEM_SCHEMA profiles in the Planning Server are set.');
448:
449: retcode := -1;
450: errbuf := 'Profiles not set';
451: RETURN;

Line 454: msd_dem_common_utilities.log_message ('Please make sure that profiles ' ||

450: errbuf := 'Profiles not set';
451: RETURN;
452: ELSIF (x_error = 1 AND p_for_spf = 1)
453: THEN
454: msd_dem_common_utilities.log_message ('Please make sure that profiles ' ||
455: 'MSD_DEM_CONVERSION_TYPE and MSD_DEM_MASTER_ORG and MSD_SPF_MASTER_ORG are set in Source instance');
456: msd_dem_common_utilities.log_message (' and MSD_DEM_PLANNING_PERCENTAGE and MSD_DEM_INCLUDE_DEPENDENT_DEMAND and MSD_DEM_EXPLODE_DEMAND_METHOD');
457: msd_dem_common_utilities.log_message (' and MSD_DEM_CURRENCY_CODE and MSD_DEM_SCHEMA and MSC_SERVICE_ITEMS_CATSET and MSD_SPF_FAILURE_RATE_HIST_BASIS profiles in the Planning Server are set.');
458:

Line 456: msd_dem_common_utilities.log_message (' and MSD_DEM_PLANNING_PERCENTAGE and MSD_DEM_INCLUDE_DEPENDENT_DEMAND and MSD_DEM_EXPLODE_DEMAND_METHOD');

452: ELSIF (x_error = 1 AND p_for_spf = 1)
453: THEN
454: msd_dem_common_utilities.log_message ('Please make sure that profiles ' ||
455: 'MSD_DEM_CONVERSION_TYPE and MSD_DEM_MASTER_ORG and MSD_SPF_MASTER_ORG are set in Source instance');
456: msd_dem_common_utilities.log_message (' and MSD_DEM_PLANNING_PERCENTAGE and MSD_DEM_INCLUDE_DEPENDENT_DEMAND and MSD_DEM_EXPLODE_DEMAND_METHOD');
457: msd_dem_common_utilities.log_message (' and MSD_DEM_CURRENCY_CODE and MSD_DEM_SCHEMA and MSC_SERVICE_ITEMS_CATSET and MSD_SPF_FAILURE_RATE_HIST_BASIS profiles in the Planning Server are set.');
458:
459: retcode := -1;
460: errbuf := 'Profiles not set';

Line 457: msd_dem_common_utilities.log_message (' and MSD_DEM_CURRENCY_CODE and MSD_DEM_SCHEMA and MSC_SERVICE_ITEMS_CATSET and MSD_SPF_FAILURE_RATE_HIST_BASIS profiles in the Planning Server are set.');

453: THEN
454: msd_dem_common_utilities.log_message ('Please make sure that profiles ' ||
455: 'MSD_DEM_CONVERSION_TYPE and MSD_DEM_MASTER_ORG and MSD_SPF_MASTER_ORG are set in Source instance');
456: msd_dem_common_utilities.log_message (' and MSD_DEM_PLANNING_PERCENTAGE and MSD_DEM_INCLUDE_DEPENDENT_DEMAND and MSD_DEM_EXPLODE_DEMAND_METHOD');
457: msd_dem_common_utilities.log_message (' and MSD_DEM_CURRENCY_CODE and MSD_DEM_SCHEMA and MSC_SERVICE_ITEMS_CATSET and MSD_SPF_FAILURE_RATE_HIST_BASIS profiles in the Planning Server are set.');
458:
459: retcode := -1;
460: errbuf := 'Profiles not set';
461: RETURN;

Line 464: msd_dem_common_utilities.log_message (' Actions');

460: errbuf := 'Profiles not set';
461: RETURN;
462: ELSE
463:
464: msd_dem_common_utilities.log_message (' Actions');
465: msd_dem_common_utilities.log_message ('---------');
466:
467: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_setup_parameters in the Source instance');
468: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_setup_parameters' || g_dblink;

Line 465: msd_dem_common_utilities.log_message ('---------');

461: RETURN;
462: ELSE
463:
464: msd_dem_common_utilities.log_message (' Actions');
465: msd_dem_common_utilities.log_message ('---------');
466:
467: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_setup_parameters in the Source instance');
468: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_setup_parameters' || g_dblink;
469: */

Line 467: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_setup_parameters in the Source instance');

463:
464: msd_dem_common_utilities.log_message (' Actions');
465: msd_dem_common_utilities.log_message ('---------');
466:
467: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_setup_parameters in the Source instance');
468: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_setup_parameters' || g_dblink;
469: */
470: x_sql := 'DELETE FROM msd_dem_setup_parameters' || g_dblink;
471:

Line 474: msd_dem_common_utilities.log_message ('Inserting profiles into source msd_dem_setup_parameters');

470: x_sql := 'DELETE FROM msd_dem_setup_parameters' || g_dblink;
471:
472: EXECUTE IMMEDIATE x_sql;
473:
474: msd_dem_common_utilities.log_message ('Inserting profiles into source msd_dem_setup_parameters');
475: x_sql := 'INSERT INTO msd_dem_setup_parameters' || g_dblink ||
476: ' (parameter_name, parameter_value, last_update_date, last_updated_by, creation_date, ' ||
477: ' created_by, last_update_login) values (:1, :2, sysdate, :3, sysdate, ' ||
478: ' :4, :5)';

Line 490: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_setup_parameters in the Destination instance');

486:
487: IF (g_dblink IS NOT NULL)
488: THEN
489:
490: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_setup_parameters in the Destination instance');
491: x_sql := 'DELETE FROM msd_dem_setup_parameters';
492: EXECUTE IMMEDIATE x_sql;
493:
494: msd_dem_common_utilities.log_message ('Inserting profiles into destination msd_dem_setup_parameters');

Line 494: msd_dem_common_utilities.log_message ('Inserting profiles into destination msd_dem_setup_parameters');

490: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_setup_parameters in the Destination instance');
491: x_sql := 'DELETE FROM msd_dem_setup_parameters';
492: EXECUTE IMMEDIATE x_sql;
493:
494: msd_dem_common_utilities.log_message ('Inserting profiles into destination msd_dem_setup_parameters');
495: x_sql := 'INSERT INTO msd_dem_setup_parameters' ||
496: ' (parameter_name, parameter_value, last_update_date, last_updated_by, creation_date, ' ||
497: ' created_by, last_update_login) values (:1, :2, sysdate, :3, sysdate, ' ||
498: ' :4, :5)';

Line 505: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_setup_parameters');

501: LOOP
502: EXECUTE IMMEDIATE x_sql USING g_profile_list(j).profile_code, g_profile_list(j).profile_value, g_user_id, g_user_id, g_login_id;
503: END LOOP;
504:
505: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_setup_parameters');
506: msd_dem_collect_history_data.analyze_table (x_errbuf, x_retcode, 'MSD_DEM_SETUP_PARAMETERS');
507:
508: COMMIT;
509:

Line 512: msd_dem_common_utilities.log_message (' ');

508: COMMIT;
509:
510: END IF;
511:
512: msd_dem_common_utilities.log_message (' ');
513:
514: END IF;
515:
516:

Line 517: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_profiles - ' || sysdate);

513:
514: END IF;
515:
516:
517: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_profiles - ' || sysdate);
518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: retcode := -1 ;

Line 523: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_profiles - ' || sysdate);

519: EXCEPTION
520: WHEN OTHERS THEN
521: retcode := -1 ;
522: errbuf := substr(SQLERRM,1,150);
523: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_profiles - ' || sysdate);
524: msd_dem_common_utilities.log_message (errbuf);
525: RETURN;
526:
527: END PUSH_PROFILES;

Line 524: msd_dem_common_utilities.log_message (errbuf);

520: WHEN OTHERS THEN
521: retcode := -1 ;
522: errbuf := substr(SQLERRM,1,150);
523: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_profiles - ' || sysdate);
524: msd_dem_common_utilities.log_message (errbuf);
525: RETURN;
526:
527: END PUSH_PROFILES;
528:

Line 552: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);

548: x_sql VARCHAR2(1000) := NULL;
549:
550: BEGIN
551:
552: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
553:
554: msd_dem_common_utilities.log_message (' Push Organizations - Actions');
555: msd_dem_common_utilities.log_message ('------------------------------');
556: msd_dem_common_utilities.log_message (' ');

Line 554: msd_dem_common_utilities.log_message (' Push Organizations - Actions');

550: BEGIN
551:
552: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
553:
554: msd_dem_common_utilities.log_message (' Push Organizations - Actions');
555: msd_dem_common_utilities.log_message ('------------------------------');
556: msd_dem_common_utilities.log_message (' ');
557:
558: msd_dem_common_utilities.log_message ('Deleting Organizations from source msd_dem_app_instance_orgs');

Line 555: msd_dem_common_utilities.log_message ('------------------------------');

551:
552: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
553:
554: msd_dem_common_utilities.log_message (' Push Organizations - Actions');
555: msd_dem_common_utilities.log_message ('------------------------------');
556: msd_dem_common_utilities.log_message (' ');
557:
558: msd_dem_common_utilities.log_message ('Deleting Organizations from source msd_dem_app_instance_orgs');
559: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_app_instance_orgs' || g_dblink;

Line 556: msd_dem_common_utilities.log_message (' ');

552: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
553:
554: msd_dem_common_utilities.log_message (' Push Organizations - Actions');
555: msd_dem_common_utilities.log_message ('------------------------------');
556: msd_dem_common_utilities.log_message (' ');
557:
558: msd_dem_common_utilities.log_message ('Deleting Organizations from source msd_dem_app_instance_orgs');
559: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_app_instance_orgs' || g_dblink;
560: */

Line 558: msd_dem_common_utilities.log_message ('Deleting Organizations from source msd_dem_app_instance_orgs');

554: msd_dem_common_utilities.log_message (' Push Organizations - Actions');
555: msd_dem_common_utilities.log_message ('------------------------------');
556: msd_dem_common_utilities.log_message (' ');
557:
558: msd_dem_common_utilities.log_message ('Deleting Organizations from source msd_dem_app_instance_orgs');
559: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_app_instance_orgs' || g_dblink;
560: */
561: x_sql := 'DELETE FROM msd_dem_app_instance_orgs' || g_dblink;
562:

Line 565: msd_dem_common_utilities.log_message ('Inserting Organizations into source msd_dem_app_instance_orgs');

561: x_sql := 'DELETE FROM msd_dem_app_instance_orgs' || g_dblink;
562:
563: EXECUTE IMMEDIATE x_sql;
564:
565: msd_dem_common_utilities.log_message ('Inserting Organizations into source msd_dem_app_instance_orgs');
566: x_sql := 'INSERT INTO msd_dem_app_instance_orgs' || g_dblink ||
567: ' ( organization_id, organization_code, last_update_date, last_updated_by, creation_date, ' ||
568: ' created_by, last_update_login) ' ||
569: ' SELECT mtp.sr_tp_id, mtp.organization_code, sysdate, :a1, sysdate, ' ||

Line 591: msd_dem_common_utilities.log_message ('Removing Organizations not enabled for spares forecasting from source msd_dem_app_instance_orgs');

587: ' WHERE hoi.organization_id = mdaio.organization_id ' ||
588: ' AND hoi.org_information_context = ''CLASS'' ' ||
589: ' AND hoi.org_information1 = ''SPF'' ' ||
590: ' AND hoi.org_information2 = ''Y'') ';
591: msd_dem_common_utilities.log_message ('Removing Organizations not enabled for spares forecasting from source msd_dem_app_instance_orgs');
592: EXECUTE IMMEDIATE x_sql;
593:
594: END IF;
595:

Line 606: msd_dem_common_utilities.log_message ('Removing Organizations that are enabled for spares forecasting from source msd_dem_app_instance_orgs');

602: ' WHERE hoi.organization_id = mdaio.organization_id ' ||
603: ' AND hoi.org_information_context = ''CLASS'' ' ||
604: ' AND hoi.org_information1 = ''SPF'' ' ||
605: ' AND hoi.org_information2 = ''Y'') ';
606: msd_dem_common_utilities.log_message ('Removing Organizations that are enabled for spares forecasting from source msd_dem_app_instance_orgs');
607: EXECUTE IMMEDIATE x_sql;
608:
609: END IF;
610:

Line 616: msd_dem_common_utilities.log_message ('Deleting Organizations from destination msd_dem_app_instance_orgs');

612:
613: IF (g_dblink IS NOT NULL)
614: THEN
615:
616: msd_dem_common_utilities.log_message ('Deleting Organizations from destination msd_dem_app_instance_orgs');
617: x_sql := 'DELETE FROM msd_dem_app_instance_orgs';
618: EXECUTE IMMEDIATE x_sql;
619:
620: msd_dem_common_utilities.log_message ('Inserting Organizations into destination msd_dem_app_instance_orgs');

Line 620: msd_dem_common_utilities.log_message ('Inserting Organizations into destination msd_dem_app_instance_orgs');

616: msd_dem_common_utilities.log_message ('Deleting Organizations from destination msd_dem_app_instance_orgs');
617: x_sql := 'DELETE FROM msd_dem_app_instance_orgs';
618: EXECUTE IMMEDIATE x_sql;
619:
620: msd_dem_common_utilities.log_message ('Inserting Organizations into destination msd_dem_app_instance_orgs');
621: x_sql := 'INSERT INTO msd_dem_app_instance_orgs' ||
622: ' ( organization_id, organization_code, last_update_date, last_updated_by, creation_date, ' ||
623: ' created_by, last_update_login) ' ||
624: ' SELECT organization_id, organization_code, sysdate, :1, sysdate, :2, :3 ' ||

Line 628: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_app_instance_orgs');

624: ' SELECT organization_id, organization_code, sysdate, :1, sysdate, :2, :3 ' ||
625: ' FROM msd_dem_app_instance_orgs' || g_dblink;
626: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
627:
628: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_app_instance_orgs');
629: msd_dem_collect_history_data.analyze_table (x_errbuf, x_retcode, 'MSD_DEM_APP_INSTANCE_ORGS');
630:
631: COMMIT;
632:

Line 635: msd_dem_common_utilities.log_message (' ');

631: COMMIT;
632:
633: END IF;
634:
635: msd_dem_common_utilities.log_message (' ');
636: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
637:
638: EXCEPTION
639: WHEN OTHERS THEN

Line 636: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);

632:
633: END IF;
634:
635: msd_dem_common_utilities.log_message (' ');
636: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
637:
638: EXCEPTION
639: WHEN OTHERS THEN
640: retcode := -1 ;

Line 642: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);

638: EXCEPTION
639: WHEN OTHERS THEN
640: retcode := -1 ;
641: errbuf := substr(SQLERRM,1,150);
642: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
643: msd_dem_common_utilities.log_message (errbuf);
644: RETURN;
645:
646: END PUSH_ORGANIZATIONS;

Line 643: msd_dem_common_utilities.log_message (errbuf);

639: WHEN OTHERS THEN
640: retcode := -1 ;
641: errbuf := substr(SQLERRM,1,150);
642: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
643: msd_dem_common_utilities.log_message (errbuf);
644: RETURN;
645:
646: END PUSH_ORGANIZATIONS;
647:

Line 686: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);

682: x_actual_agg_method NUMBER(1) := NULL;
683:
684: BEGIN
685:
686: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
687:
688:
689: msd_dem_common_utilities.log_message (' Push Time Data - Actions');
690: msd_dem_common_utilities.log_message ('------------------------------');

Line 689: msd_dem_common_utilities.log_message (' Push Time Data - Actions');

685:
686: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
687:
688:
689: msd_dem_common_utilities.log_message (' Push Time Data - Actions');
690: msd_dem_common_utilities.log_message ('------------------------------');
691: msd_dem_common_utilities.log_message (' ');
692:
693: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_dates');

Line 690: msd_dem_common_utilities.log_message ('------------------------------');

686: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
687:
688:
689: msd_dem_common_utilities.log_message (' Push Time Data - Actions');
690: msd_dem_common_utilities.log_message ('------------------------------');
691: msd_dem_common_utilities.log_message (' ');
692:
693: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_dates');
694: x_sql := 'DELETE FROM msd_dem_dates' || g_dblink;

Line 691: msd_dem_common_utilities.log_message (' ');

687:
688:
689: msd_dem_common_utilities.log_message (' Push Time Data - Actions');
690: msd_dem_common_utilities.log_message ('------------------------------');
691: msd_dem_common_utilities.log_message (' ');
692:
693: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_dates');
694: x_sql := 'DELETE FROM msd_dem_dates' || g_dblink;
695: EXECUTE IMMEDIATE x_sql;

Line 693: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_dates');

689: msd_dem_common_utilities.log_message (' Push Time Data - Actions');
690: msd_dem_common_utilities.log_message ('------------------------------');
691: msd_dem_common_utilities.log_message (' ');
692:
693: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_dates');
694: x_sql := 'DELETE FROM msd_dem_dates' || g_dblink;
695: EXECUTE IMMEDIATE x_sql;
696:
697: x_dm_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');

Line 697: x_dm_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');

693: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_dates');
694: x_sql := 'DELETE FROM msd_dem_dates' || g_dblink;
695: EXECUTE IMMEDIATE x_sql;
696:
697: x_dm_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');
698:
699: /* Get the time level info for the active data model */
700: x_sql := 'SELECT time_bucket, first_day_of_week, aggregation_method ' ||
701: ' FROM ' || x_dm_table ||

Line 709: msd_dem_common_utilities.log_message ('Lowest Time Bucket - Day : Time data not inserted into source msd_dem_dates');

705: EXECUTE IMMEDIATE x_sql INTO x_time_bucket, x_first_day_of_week, x_aggregation_method;
706:
707: IF (upper(x_time_bucket) = 'DAY')
708: THEN
709: msd_dem_common_utilities.log_message ('Lowest Time Bucket - Day : Time data not inserted into source msd_dem_dates');
710: --populate msd_dem_day_dates before returning
711: --RETURN;
712: ELSIF (upper(x_time_bucket) = 'WEEK')
713: THEN

Line 722: msd_dem_common_utilities.log_message ('Error(1): msd_dem_push_setup_parameters.push_time_data - ' || sysdate);

718: x_actual_agg_method := 2;
719: ELSE
720: retcode := -1;
721: errbuf := 'Invalid time bucket';
722: msd_dem_common_utilities.log_message ('Error(1): msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
723: msd_dem_common_utilities.log_message ('Invalid time bucket');
724: RETURN;
725: END IF;
726:

Line 723: msd_dem_common_utilities.log_message ('Invalid time bucket');

719: ELSE
720: retcode := -1;
721: errbuf := 'Invalid time bucket';
722: msd_dem_common_utilities.log_message ('Error(1): msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
723: msd_dem_common_utilities.log_message ('Invalid time bucket');
724: RETURN;
725: END IF;
726:
727: IF (x_actual_agg_method = 1) /* Forward */

Line 738: x_source_time_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS');

734: END IF;
735:
736: x_end_date := 'trunc(' || x_end_date || ') + 86399/86400 end_date';
737:
738: x_source_time_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS');
739:
740: IF (UPPER(X_TIME_BUCKET) <> 'DAY') THEN
741: msd_dem_common_utilities.log_message ('Inserting time data into source msd_dem_dates');
742: x_sql := 'INSERT INTO msd_dem_dates' || g_dblink ||

Line 741: msd_dem_common_utilities.log_message ('Inserting time data into source msd_dem_dates');

737:
738: x_source_time_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS');
739:
740: IF (UPPER(X_TIME_BUCKET) <> 'DAY') THEN
741: msd_dem_common_utilities.log_message ('Inserting time data into source msd_dem_dates');
742: x_sql := 'INSERT INTO msd_dem_dates' || g_dblink ||
743: ' (datet, num_of_days, start_date, end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||
744: ' SELECT datet, num_of_days, ' || x_start_date || x_end_date || ',' ||
745: ' sysdate, :1, sysdate, :2, :3 ' ||

Line 747: msd_dem_common_utilities.log_debug('SQL for inserting data into source msd_dem_dates : ');

743: ' (datet, num_of_days, start_date, end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||
744: ' SELECT datet, num_of_days, ' || x_start_date || x_end_date || ',' ||
745: ' sysdate, :1, sysdate, :2, :3 ' ||
746: ' FROM ' || x_source_time_table;
747: msd_dem_common_utilities.log_debug('SQL for inserting data into source msd_dem_dates : ');
748: msd_dem_common_utilities.log_debug(x_sql);
749: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
750: END IF;
751:

Line 748: msd_dem_common_utilities.log_debug(x_sql);

744: ' SELECT datet, num_of_days, ' || x_start_date || x_end_date || ',' ||
745: ' sysdate, :1, sysdate, :2, :3 ' ||
746: ' FROM ' || x_source_time_table;
747: msd_dem_common_utilities.log_debug('SQL for inserting data into source msd_dem_dates : ');
748: msd_dem_common_utilities.log_debug(x_sql);
749: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
750: END IF;
751:
752: IF (g_dblink IS NOT NULL)

Line 755: msd_dem_common_utilities.log_message ('Deleting time data from destination msd_dem_dates');

751:
752: IF (g_dblink IS NOT NULL)
753: THEN
754:
755: msd_dem_common_utilities.log_message ('Deleting time data from destination msd_dem_dates');
756: x_sql := 'DELETE FROM msd_dem_dates';
757: EXECUTE IMMEDIATE x_sql;
758:
759: IF (UPPER(X_TIME_BUCKET) <> 'DAY') THEN

Line 760: msd_dem_common_utilities.log_message ('Inserting time data into destination msd_dem_dates');

756: x_sql := 'DELETE FROM msd_dem_dates';
757: EXECUTE IMMEDIATE x_sql;
758:
759: IF (UPPER(X_TIME_BUCKET) <> 'DAY') THEN
760: msd_dem_common_utilities.log_message ('Inserting time data into destination msd_dem_dates');
761: x_sql := 'INSERT INTO msd_dem_dates' ||
762: ' (datet, num_of_days, start_date, end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||
763: ' SELECT datet, num_of_days, ' || x_start_date || x_end_date || ',' ||
764: ' sysdate, :1, sysdate, :2, :3 ' ||

Line 766: msd_dem_common_utilities.log_debug('SQL for inserting data into destination msd_dem_dates : ');

762: ' (datet, num_of_days, start_date, end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||
763: ' SELECT datet, num_of_days, ' || x_start_date || x_end_date || ',' ||
764: ' sysdate, :1, sysdate, :2, :3 ' ||
765: ' FROM ' || x_source_time_table;
766: msd_dem_common_utilities.log_debug('SQL for inserting data into destination msd_dem_dates : ');
767: msd_dem_common_utilities.log_debug(x_sql);
768: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
769:
770: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_dates');

Line 767: msd_dem_common_utilities.log_debug(x_sql);

763: ' SELECT datet, num_of_days, ' || x_start_date || x_end_date || ',' ||
764: ' sysdate, :1, sysdate, :2, :3 ' ||
765: ' FROM ' || x_source_time_table;
766: msd_dem_common_utilities.log_debug('SQL for inserting data into destination msd_dem_dates : ');
767: msd_dem_common_utilities.log_debug(x_sql);
768: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
769:
770: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_dates');
771: msd_dem_collect_history_data.analyze_table (x_errbuf, x_retcode, 'MSD_DEM_DATES');

Line 770: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_dates');

766: msd_dem_common_utilities.log_debug('SQL for inserting data into destination msd_dem_dates : ');
767: msd_dem_common_utilities.log_debug(x_sql);
768: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
769:
770: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_dates');
771: msd_dem_collect_history_data.analyze_table (x_errbuf, x_retcode, 'MSD_DEM_DATES');
772: END IF;
773:
774: COMMIT;

Line 778: msd_dem_common_utilities.log_message ('Deleting time data from destination msd_dem_day_dates');

774: COMMIT;
775:
776: END IF;
777:
778: msd_dem_common_utilities.log_message ('Deleting time data from destination msd_dem_day_dates');
779: x_sql := 'DELETE FROM msd_dem_day_dates';
780: EXECUTE IMMEDIATE x_sql;
781:
782: msd_dem_common_utilities.log_message ('Inserting time data into destination msd_dem_day_dates');

Line 782: msd_dem_common_utilities.log_message ('Inserting time data into destination msd_dem_day_dates');

778: msd_dem_common_utilities.log_message ('Deleting time data from destination msd_dem_day_dates');
779: x_sql := 'DELETE FROM msd_dem_day_dates';
780: EXECUTE IMMEDIATE x_sql;
781:
782: msd_dem_common_utilities.log_message ('Inserting time data into destination msd_dem_day_dates');
783: x_sql := 'INSERT INTO msd_dem_day_dates' ||
784: ' (day_date, bucket_date, bucket_start_date, bucket_end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||
785: ' with dem_dates as '||
786: ' (SELECT datet, num_of_days, ' || x_start_date || x_end_date ||

Line 791: msd_dem_common_utilities.log_debug('SQL for inserting data into destination msd_dem_day_dates : ');

787: ' FROM ' || x_source_time_table || ') ' ||
788: ' select start_date + i day_date, datet, start_date, end_date, sysdate, :1, sysdate, :2, :3 ' ||
789: ' from dem_dates, xmltable(''for $i in 0 to xs:int(D)-1 return $i'' passing xmlelement(d, num_of_days)
790: columns i integer path ''.'')' ;
791: msd_dem_common_utilities.log_debug('SQL for inserting data into destination msd_dem_day_dates : ');
792: msd_dem_common_utilities.log_debug(x_sql);
793: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
794:
795: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_day_dates');

Line 792: msd_dem_common_utilities.log_debug(x_sql);

788: ' select start_date + i day_date, datet, start_date, end_date, sysdate, :1, sysdate, :2, :3 ' ||
789: ' from dem_dates, xmltable(''for $i in 0 to xs:int(D)-1 return $i'' passing xmlelement(d, num_of_days)
790: columns i integer path ''.'')' ;
791: msd_dem_common_utilities.log_debug('SQL for inserting data into destination msd_dem_day_dates : ');
792: msd_dem_common_utilities.log_debug(x_sql);
793: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
794:
795: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_day_dates');
796: msd_dem_collect_history_data.analyze_table (x_errbuf, x_retcode, 'MSD_DEM_DAY_DATES');

Line 795: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_day_dates');

791: msd_dem_common_utilities.log_debug('SQL for inserting data into destination msd_dem_day_dates : ');
792: msd_dem_common_utilities.log_debug(x_sql);
793: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
794:
795: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_day_dates');
796: msd_dem_collect_history_data.analyze_table (x_errbuf, x_retcode, 'MSD_DEM_DAY_DATES');
797:
798: commit;
799:

Line 801: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_day_dates');

797:
798: commit;
799:
800: IF (g_dblink IS NOT NULL) THEN
801: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_day_dates');
802: x_sql := 'DELETE FROM msd_dem_day_dates' || g_dblink;
803: EXECUTE IMMEDIATE x_sql;
804:
805: msd_dem_common_utilities.log_message('Inserting data into source msd_dem_day_dates');

Line 805: msd_dem_common_utilities.log_message('Inserting data into source msd_dem_day_dates');

801: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_day_dates');
802: x_sql := 'DELETE FROM msd_dem_day_dates' || g_dblink;
803: EXECUTE IMMEDIATE x_sql;
804:
805: msd_dem_common_utilities.log_message('Inserting data into source msd_dem_day_dates');
806: x_sql := 'INSERT INTO msd_dem_day_dates' || g_dblink ||
807: ' (day_date, bucket_date, bucket_start_date, bucket_end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||
808: ' SELECT day_date, bucket_date, bucket_start_date, bucket_end_date, ' ||
809: ' sysdate, :1, sysdate, :2, :3 ' ||

Line 811: msd_dem_common_utilities.log_debug('SQL for inserting data into source msd_dem_day_dates : ');

807: ' (day_date, bucket_date, bucket_start_date, bucket_end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||
808: ' SELECT day_date, bucket_date, bucket_start_date, bucket_end_date, ' ||
809: ' sysdate, :1, sysdate, :2, :3 ' ||
810: ' FROM msd_dem_day_dates' ;
811: msd_dem_common_utilities.log_debug('SQL for inserting data into source msd_dem_day_dates : ');
812: msd_dem_common_utilities.log_debug(x_sql);
813: execute immediate x_sql using g_user_id, g_user_id, g_login_id;
814: COMMIT;
815: END IF;

Line 812: msd_dem_common_utilities.log_debug(x_sql);

808: ' SELECT day_date, bucket_date, bucket_start_date, bucket_end_date, ' ||
809: ' sysdate, :1, sysdate, :2, :3 ' ||
810: ' FROM msd_dem_day_dates' ;
811: msd_dem_common_utilities.log_debug('SQL for inserting data into source msd_dem_day_dates : ');
812: msd_dem_common_utilities.log_debug(x_sql);
813: execute immediate x_sql using g_user_id, g_user_id, g_login_id;
814: COMMIT;
815: END IF;
816:

Line 817: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);

813: execute immediate x_sql using g_user_id, g_user_id, g_login_id;
814: COMMIT;
815: END IF;
816:
817: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
818:
819: EXCEPTION
820: WHEN OTHERS THEN
821: retcode := -1 ;

Line 823: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);

819: EXCEPTION
820: WHEN OTHERS THEN
821: retcode := -1 ;
822: errbuf := substr(SQLERRM,1,150);
823: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
824: msd_dem_common_utilities.log_message (errbuf);
825: RETURN;
826:
827: END PUSH_TIME_DATA;

Line 824: msd_dem_common_utilities.log_message (errbuf);

820: WHEN OTHERS THEN
821: retcode := -1 ;
822: errbuf := substr(SQLERRM,1,150);
823: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
824: msd_dem_common_utilities.log_message (errbuf);
825: RETURN;
826:
827: END PUSH_TIME_DATA;
828:

Line 867: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);

863: ORDER BY created desc;
864:
865: BEGIN
866:
867: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
868:
869: /* Get the db link to the source instance */
870: msd_dem_common_utilities.get_dblink (
871: x_errbuf,

Line 870: msd_dem_common_utilities.get_dblink (

866:
867: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
868:
869: /* Get the db link to the source instance */
870: msd_dem_common_utilities.get_dblink (
871: x_errbuf,
872: x_retcode,
873: p_sr_instance_id,
874: g_dblink);

Line 880: msd_dem_common_utilities.log_message ('Error(1): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);

876: IF (x_retcode = '-1')
877: THEN
878: retcode := -1;
879: errbuf := x_errbuf;
880: msd_dem_common_utilities.log_message ('Error(1): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
881: RETURN;
882: END IF;
883:
884: /* Get the msd schema name */

Line 888: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);

884: /* Get the msd schema name */
885: /* x_sql := 'DECLARE x_retval BOOLEAN; x_dummy1 VARCHAR2(50); x_dummy2 VARCHAR2(50); BEGIN x_retval := fnd_installation.get_app_info' || g_dblink || ' ( ''MSD'', x_dummy1, x_dummy2, :x_out1); END;';
886: EXECUTE IMMEDIATE x_sql USING OUT g_msd_schema_name;
887:
888: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);
889: */
890: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
891: msd_dem_common_utilities.log_message (' -----------------------------');
892: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);

Line 890: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');

886: EXECUTE IMMEDIATE x_sql USING OUT g_msd_schema_name;
887:
888: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);
889: */
890: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
891: msd_dem_common_utilities.log_message (' -----------------------------');
892: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);
893: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
894: msd_dem_common_utilities.log_message (' ');

Line 891: msd_dem_common_utilities.log_message (' -----------------------------');

887:
888: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);
889: */
890: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
891: msd_dem_common_utilities.log_message (' -----------------------------');
892: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);
893: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
894: msd_dem_common_utilities.log_message (' ');
895:

Line 892: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);

888: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);
889: */
890: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
891: msd_dem_common_utilities.log_message (' -----------------------------');
892: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);
893: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
894: msd_dem_common_utilities.log_message (' ');
895:
896: g_user_id := fnd_global.user_id;

Line 893: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);

889: */
890: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
891: msd_dem_common_utilities.log_message (' -----------------------------');
892: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);
893: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
894: msd_dem_common_utilities.log_message (' ');
895:
896: g_user_id := fnd_global.user_id;
897: g_login_id := fnd_global.login_id;

Line 894: msd_dem_common_utilities.log_message (' ');

890: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
891: msd_dem_common_utilities.log_message (' -----------------------------');
892: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);
893: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
894: msd_dem_common_utilities.log_message (' ');
895:
896: g_user_id := fnd_global.user_id;
897: g_login_id := fnd_global.login_id;
898:

Line 908: msd_dem_common_utilities.log_message ('Error(2): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);

904: IF (x_retcode = '-1')
905: THEN
906: retcode := -1;
907: errbuf := x_errbuf;
908: msd_dem_common_utilities.log_message ('Error(2): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
909: RETURN;
910: ELSE
911: retcode := x_retcode;
912: END IF;

Line 926: msd_dem_common_utilities.log_message ('Error(3): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);

922: IF (x_retcode = '-1')
923: THEN
924: retcode := -1;
925: errbuf := x_errbuf;
926: msd_dem_common_utilities.log_message ('Error(3): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
927: RETURN;
928: END IF;
929:
930: /* Push the profile values to the source instance */

Line 943: msd_dem_common_utilities.log_message ('Error(4): msd_dem_push_setup_parameters.push_organizations - ' || sysdate);

939: IF (x_retcode = '-1')
940: THEN
941: retcode := -1;
942: errbuf := x_errbuf;
943: msd_dem_common_utilities.log_message ('Error(4): msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
944: RETURN;
945: END IF;
946:
947: OPEN c_get_dm_schema; --jarora

Line 966: msd_dem_common_utilities.log_message ('Error(5): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);

962: IF (x_retcode = '-1')
963: THEN
964: retcode := -1;
965: errbuf := x_errbuf;
966: msd_dem_common_utilities.log_message ('Error(5): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
967: RETURN;
968: END IF;
969:
970: ELSE

Line 976: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);

972: END IF; --jarora
973:
974: COMMIT;
975:
976: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
977:
978: EXCEPTION
979: WHEN OTHERS THEN
980: retcode := -1 ;

Line 982: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);

978: EXCEPTION
979: WHEN OTHERS THEN
980: retcode := -1 ;
981: errbuf := substr(SQLERRM,1,150);
982: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
983: msd_dem_common_utilities.log_message (errbuf);
984: RETURN;
985:
986: END PUSH_SETUP_PARAMETERS;

Line 983: msd_dem_common_utilities.log_message (errbuf);

979: WHEN OTHERS THEN
980: retcode := -1 ;
981: errbuf := substr(SQLERRM,1,150);
982: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
983: msd_dem_common_utilities.log_message (errbuf);
984: RETURN;
985:
986: END PUSH_SETUP_PARAMETERS;
987:

Line 1003: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.configure_legacy_profiles - ' || sysdate);

999: /*** LOCAL VARIABLES ***/
1000: x_sql VARCHAR2(500) := NULL;
1001:
1002: BEGIN
1003: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.configure_legacy_profiles - ' || sysdate);
1004:
1005: /* check if instance_id or master_org or category_set is null */
1006: IF ( (p_legacy_instance_id IS NULL)
1007: OR (p_master_org IS NULL))

Line 1011: msd_dem_common_utilities.log_message ('Error: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);

1007: OR (p_master_org IS NULL))
1008: THEN
1009: retcode := -1;
1010: errbuf := 'Legacy Instance ID or Master Organization or Category set ID cannot be null.';
1011: msd_dem_common_utilities.log_message ('Error: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
1012: RETURN;
1013: END IF;
1014:
1015: /* Before inserting parameter values for a legacy instance to the MSD_DEM_LEGACY_SETUP_PARAMS table

Line 1018: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_legacy_setup_params, for instance_id : ' || p_legacy_instance_id );

1014:
1015: /* Before inserting parameter values for a legacy instance to the MSD_DEM_LEGACY_SETUP_PARAMS table
1016: * delete any rows which already exist for this instance.
1017: */
1018: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_legacy_setup_params, for instance_id : ' || p_legacy_instance_id );
1019: x_sql := 'DELETE FROM msd_dem_legacy_setup_params where instance_id = ' || p_legacy_instance_id;
1020: EXECUTE IMMEDIATE x_sql;
1021:
1022: g_user_id := fnd_global.user_id;

Line 1034: msd_dem_common_utilities.log_message ('Inserting profile ' || g_master_org || ' for legacy instance ' || p_legacy_instance_id || ' into msd_dem_legacy_setup_params');

1030: ' (instance_id, parameter_name, parameter_value, last_update_date, last_updated_by, creation_date, ' ||
1031: ' created_by, last_update_login) values (:1, :2, :3, sysdate, :4, sysdate, ' ||
1032: ' :5, :6)';
1033:
1034: msd_dem_common_utilities.log_message ('Inserting profile ' || g_master_org || ' for legacy instance ' || p_legacy_instance_id || ' into msd_dem_legacy_setup_params');
1035: EXECUTE IMMEDIATE x_sql USING p_legacy_instance_id, g_master_org, p_master_org, g_user_id, g_user_id, g_login_id;
1036:
1037: msd_dem_common_utilities.log_message ('Inserting profile ' || g_sr_category_set || ' for legacy instance ' || p_legacy_instance_id || ' into msd_dem_legacy_setup_params');
1038: EXECUTE IMMEDIATE x_sql USING p_legacy_instance_id, g_sr_category_set, p_sr_category_set_id, g_user_id, g_user_id, g_login_id;

Line 1037: msd_dem_common_utilities.log_message ('Inserting profile ' || g_sr_category_set || ' for legacy instance ' || p_legacy_instance_id || ' into msd_dem_legacy_setup_params');

1033:
1034: msd_dem_common_utilities.log_message ('Inserting profile ' || g_master_org || ' for legacy instance ' || p_legacy_instance_id || ' into msd_dem_legacy_setup_params');
1035: EXECUTE IMMEDIATE x_sql USING p_legacy_instance_id, g_master_org, p_master_org, g_user_id, g_user_id, g_login_id;
1036:
1037: msd_dem_common_utilities.log_message ('Inserting profile ' || g_sr_category_set || ' for legacy instance ' || p_legacy_instance_id || ' into msd_dem_legacy_setup_params');
1038: EXECUTE IMMEDIATE x_sql USING p_legacy_instance_id, g_sr_category_set, p_sr_category_set_id, g_user_id, g_user_id, g_login_id;
1039:
1040: COMMIT;
1041:

Line 1042: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.configure_legacy_profiles - ' || sysdate);

1038: EXECUTE IMMEDIATE x_sql USING p_legacy_instance_id, g_sr_category_set, p_sr_category_set_id, g_user_id, g_user_id, g_login_id;
1039:
1040: COMMIT;
1041:
1042: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.configure_legacy_profiles - ' || sysdate);
1043:
1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: retcode := -1 ;

Line 1048: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.configure_legacy_profiles - ' || sysdate);

1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: retcode := -1 ;
1047: errbuf := substr(SQLERRM,1,150);
1048: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.configure_legacy_profiles - ' || sysdate);
1049: msd_dem_common_utilities.log_message (errbuf);
1050: RETURN;
1051:
1052: END CONFIGURE_LEGACY_PROFILES;

Line 1049: msd_dem_common_utilities.log_message (errbuf);

1045: WHEN OTHERS THEN
1046: retcode := -1 ;
1047: errbuf := substr(SQLERRM,1,150);
1048: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.configure_legacy_profiles - ' || sysdate);
1049: msd_dem_common_utilities.log_message (errbuf);
1050: RETURN;
1051:
1052: END CONFIGURE_LEGACY_PROFILES;
1053:

Line 1072: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);

1068:
1069: BEGIN
1070:
1071:
1072: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);
1073:
1074: msd_dem_common_utilities.log_message (' Push Legacy Setup Parameters Program');
1075: msd_dem_common_utilities.log_message (' ------------------------------------');
1076: msd_dem_common_utilities.log_message (' Legacy Instance ID : ' || p_legacy_instance_id);

Line 1074: msd_dem_common_utilities.log_message (' Push Legacy Setup Parameters Program');

1070:
1071:
1072: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);
1073:
1074: msd_dem_common_utilities.log_message (' Push Legacy Setup Parameters Program');
1075: msd_dem_common_utilities.log_message (' ------------------------------------');
1076: msd_dem_common_utilities.log_message (' Legacy Instance ID : ' || p_legacy_instance_id);
1077: msd_dem_common_utilities.log_message (' ');
1078:

Line 1075: msd_dem_common_utilities.log_message (' ------------------------------------');

1071:
1072: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);
1073:
1074: msd_dem_common_utilities.log_message (' Push Legacy Setup Parameters Program');
1075: msd_dem_common_utilities.log_message (' ------------------------------------');
1076: msd_dem_common_utilities.log_message (' Legacy Instance ID : ' || p_legacy_instance_id);
1077: msd_dem_common_utilities.log_message (' ');
1078:
1079: g_user_id := fnd_global.user_id;

Line 1076: msd_dem_common_utilities.log_message (' Legacy Instance ID : ' || p_legacy_instance_id);

1072: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);
1073:
1074: msd_dem_common_utilities.log_message (' Push Legacy Setup Parameters Program');
1075: msd_dem_common_utilities.log_message (' ------------------------------------');
1076: msd_dem_common_utilities.log_message (' Legacy Instance ID : ' || p_legacy_instance_id);
1077: msd_dem_common_utilities.log_message (' ');
1078:
1079: g_user_id := fnd_global.user_id;
1080: g_login_id := fnd_global.login_id;

Line 1077: msd_dem_common_utilities.log_message (' ');

1073:
1074: msd_dem_common_utilities.log_message (' Push Legacy Setup Parameters Program');
1075: msd_dem_common_utilities.log_message (' ------------------------------------');
1076: msd_dem_common_utilities.log_message (' Legacy Instance ID : ' || p_legacy_instance_id);
1077: msd_dem_common_utilities.log_message (' ');
1078:
1079: g_user_id := fnd_global.user_id;
1080: g_login_id := fnd_global.login_id;
1081:

Line 1084: msd_dem_common_utilities.log_message ('Pushing time data for Legacy Instance');

1080: g_login_id := fnd_global.login_id;
1081:
1082: -- Bug#12931039 mpmurali
1083: /* Push the time data to the source instance */
1084: msd_dem_common_utilities.log_message ('Pushing time data for Legacy Instance');
1085: push_time_data (
1086: errbuf,
1087: retcode,
1088: p_legacy_instance_id,

Line 1098: msd_dem_common_utilities.log_message ('Fetching value for parameter - ' || g_master_org || ' from msd_dem_legacy_setup_params');

1094: */
1095: x_sql := 'SELECT parameter_value FROM msd_dem_legacy_setup_params where instance_id = :1 and parameter_name = :2';
1096:
1097: BEGIN
1098: msd_dem_common_utilities.log_message ('Fetching value for parameter - ' || g_master_org || ' from msd_dem_legacy_setup_params');
1099: EXECUTE IMMEDIATE x_sql INTO x_master_org_value USING p_legacy_instance_id, g_master_org;
1100:
1101: /* Master Organization should be set*/
1102: IF (x_master_org_value IS NULL)

Line 1106: msd_dem_common_utilities.log_message (errbuf);

1102: IF (x_master_org_value IS NULL)
1103: THEN
1104: retcode := -1;
1105: errbuf := 'Master Organization not set for legacy instance : ' || p_legacy_instance_id;
1106: msd_dem_common_utilities.log_message (errbuf);
1107: RETURN;
1108: END IF;
1109:
1110: msd_dem_common_utilities.log_message ('Fetching value for parameter - ' || g_sr_category_set || ' from msd_dem_legacy_setup_params');

Line 1110: msd_dem_common_utilities.log_message ('Fetching value for parameter - ' || g_sr_category_set || ' from msd_dem_legacy_setup_params');

1106: msd_dem_common_utilities.log_message (errbuf);
1107: RETURN;
1108: END IF;
1109:
1110: msd_dem_common_utilities.log_message ('Fetching value for parameter - ' || g_sr_category_set || ' from msd_dem_legacy_setup_params');
1111: EXECUTE IMMEDIATE x_sql INTO x_category_set_value USING p_legacy_instance_id, g_sr_category_set;
1112: -- not checking for value of Category Set as it can be null
1113: EXCEPTION
1114: WHEN NO_DATA_FOUND THEN

Line 1117: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);

1113: EXCEPTION
1114: WHEN NO_DATA_FOUND THEN
1115: retcode := -1;
1116: errbuf := 'No records found for one or more parameters for legacy instance : ' || p_legacy_instance_id;
1117: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);
1118: msd_dem_common_utilities.log_message (errbuf);
1119: RETURN;
1120: END;
1121:

Line 1118: msd_dem_common_utilities.log_message (errbuf);

1114: WHEN NO_DATA_FOUND THEN
1115: retcode := -1;
1116: errbuf := 'No records found for one or more parameters for legacy instance : ' || p_legacy_instance_id;
1117: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);
1118: msd_dem_common_utilities.log_message (errbuf);
1119: RETURN;
1120: END;
1121:
1122: msd_dem_common_utilities.log_message ('Deleting records for profiles ' || g_master_org || ' and ' || g_sr_category_set || ' from msd_dem_setup_parameters in the destination instance');

Line 1122: msd_dem_common_utilities.log_message ('Deleting records for profiles ' || g_master_org || ' and ' || g_sr_category_set || ' from msd_dem_setup_parameters in the destination instance');

1118: msd_dem_common_utilities.log_message (errbuf);
1119: RETURN;
1120: END;
1121:
1122: msd_dem_common_utilities.log_message ('Deleting records for profiles ' || g_master_org || ' and ' || g_sr_category_set || ' from msd_dem_setup_parameters in the destination instance');
1123: x_sql := 'DELETE FROM msd_dem_setup_parameters where parameter_name in (''' || g_master_org || ''', ''' || g_sr_category_set || ''')';
1124: EXECUTE IMMEDIATE x_sql;
1125:
1126: g_user_id := fnd_global.user_id;

Line 1138: msd_dem_common_utilities.log_message ('Inserting profile ' || g_master_org || ' into msd_dem_setup_parameters');

1134: ' (parameter_name, parameter_value, last_update_date, last_updated_by, creation_date, ' ||
1135: ' created_by, last_update_login) values (:1, :2, sysdate, :3, sysdate, ' ||
1136: ' :4, :5)';
1137:
1138: msd_dem_common_utilities.log_message ('Inserting profile ' || g_master_org || ' into msd_dem_setup_parameters');
1139: EXECUTE IMMEDIATE x_sql USING g_master_org, x_master_org_value, g_user_id, g_user_id, g_login_id;
1140:
1141: msd_dem_common_utilities.log_message ('Inserting profile ' || g_sr_category_set || ' into msd_dem_setup_parameters');
1142: EXECUTE IMMEDIATE x_sql USING g_sr_category_set, x_category_set_value, g_user_id, g_user_id, g_login_id;

Line 1141: msd_dem_common_utilities.log_message ('Inserting profile ' || g_sr_category_set || ' into msd_dem_setup_parameters');

1137:
1138: msd_dem_common_utilities.log_message ('Inserting profile ' || g_master_org || ' into msd_dem_setup_parameters');
1139: EXECUTE IMMEDIATE x_sql USING g_master_org, x_master_org_value, g_user_id, g_user_id, g_login_id;
1140:
1141: msd_dem_common_utilities.log_message ('Inserting profile ' || g_sr_category_set || ' into msd_dem_setup_parameters');
1142: EXECUTE IMMEDIATE x_sql USING g_sr_category_set, x_category_set_value, g_user_id, g_user_id, g_login_id;
1143:
1144: COMMIT;
1145:

Line 1146: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);

1142: EXECUTE IMMEDIATE x_sql USING g_sr_category_set, x_category_set_value, g_user_id, g_user_id, g_login_id;
1143:
1144: COMMIT;
1145:
1146: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);
1147:
1148: EXCEPTION
1149: WHEN OTHERS THEN
1150: retcode := -1 ;

Line 1152: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);

1148: EXCEPTION
1149: WHEN OTHERS THEN
1150: retcode := -1 ;
1151: errbuf := substr(SQLERRM,1,150);
1152: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);
1153: msd_dem_common_utilities.log_message (errbuf);
1154: RETURN;
1155:
1156: END PUSH_LEGACY_SETUP_PARAMETERS;

Line 1153: msd_dem_common_utilities.log_message (errbuf);

1149: WHEN OTHERS THEN
1150: retcode := -1 ;
1151: errbuf := substr(SQLERRM,1,150);
1152: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_legacy_setup_parameters - ' || sysdate);
1153: msd_dem_common_utilities.log_message (errbuf);
1154: RETURN;
1155:
1156: END PUSH_LEGACY_SETUP_PARAMETERS;
1157: