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 55: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.get_profile_value - ' || sysdate);

51: RETURN x_return_value;
52:
53: EXCEPTION
54: WHEN OTHERS THEN
55: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.get_profile_value - ' || sysdate);
56: RETURN NULL;
57:
58: END GET_PROFILE_VALUE;
59:

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

79: RETURN x_return_value;
80:
81: EXCEPTION
82: WHEN OTHERS THEN
83: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.get_function_value - ' || sysdate);
84: RETURN NULL;
85:
86: END GET_FUNCTION_VALUE;
87:

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

99: RETURN x_return_value;
100:
101: EXCEPTION
102: WHEN OTHERS THEN
103: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.get_multi_org_flag - ' || sysdate);
104: RETURN NULL;
105:
106: END GET_MULTI_ORG_FLAG;
107:

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

122: RETURN x_return_value;
123:
124: EXCEPTION
125: WHEN OTHERS THEN
126: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.decode_profile_function - ' || sysdate);
127: RETURN NULL;
128:
129: END DECODE_PROFILE_FUNCTION;
130:

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

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

Line 187: msd_dem_common_utilities.log_message (x_check_customer_attr_log_msg);

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

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

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

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

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

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

197:
198: COMMIT;
199: retcode := 1;
200: END IF;
201: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.check_customer_attribute - ' || sysdate);
202:
203: EXCEPTION
204: WHEN OTHERS THEN
205: retcode := -1 ;

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

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

Line 208: msd_dem_common_utilities.log_message (errbuf);

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

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

225: x_retcode VARCHAR2(100) := NULL;
226:
227: BEGIN
228:
229: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.init - ' || sysdate);
230:
231: g_profile_list(1).profile_code := 'MSD_DEM_CATEGORY_SET_NAME';
232: g_profile_list(1).function_name := 'MSD_DEM_SR_UTIL.GET_CATEGORY_SET_ID';
233: g_profile_list(1).destination_flag := 'N';

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

261: g_profile_list(7).function_profile_code := 'P';
262:
263: g_num_profiles := g_profile_list.LAST;
264:
265: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.init - ' || sysdate);
266:
267: EXCEPTION
268: WHEN OTHERS THEN
269: retcode := -1 ;

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

267: EXCEPTION
268: WHEN OTHERS THEN
269: retcode := -1 ;
270: errbuf := substr(SQLERRM,1,150);
271: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.init - ' || sysdate);
272: msd_dem_common_utilities.log_message (errbuf);
273: RETURN;
274:
275: END INIT;

Line 272: msd_dem_common_utilities.log_message (errbuf);

268: WHEN OTHERS THEN
269: retcode := -1 ;
270: errbuf := substr(SQLERRM,1,150);
271: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.init - ' || sysdate);
272: msd_dem_common_utilities.log_message (errbuf);
273: RETURN;
274:
275: END INIT;
276:

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

299: x_sql VARCHAR2(1000) := NULL;
300:
301: BEGIN
302:
303: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_profiles - ' || sysdate);
304:
305: x_sql := 'alter session set session_cached_cursors = 0';
306: execute immediate x_sql;
307:

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

305: x_sql := 'alter session set session_cached_cursors = 0';
306: execute immediate x_sql;
307:
308:
309: msd_dem_common_utilities.log_message (' Push Profiles ');
310: msd_dem_common_utilities.log_message ('---------------');
311: msd_dem_common_utilities.log_message (' ');
312: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
313: msd_dem_common_utilities.log_message (' Profile Name - Value');

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

306: execute immediate x_sql;
307:
308:
309: msd_dem_common_utilities.log_message (' Push Profiles ');
310: msd_dem_common_utilities.log_message ('---------------');
311: msd_dem_common_utilities.log_message (' ');
312: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
313: msd_dem_common_utilities.log_message (' Profile Name - Value');
314: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');

Line 311: msd_dem_common_utilities.log_message (' ');

307:
308:
309: msd_dem_common_utilities.log_message (' Push Profiles ');
310: msd_dem_common_utilities.log_message ('---------------');
311: msd_dem_common_utilities.log_message (' ');
312: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
313: msd_dem_common_utilities.log_message (' Profile Name - Value');
314: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
315:

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

308:
309: msd_dem_common_utilities.log_message (' Push Profiles ');
310: msd_dem_common_utilities.log_message ('---------------');
311: msd_dem_common_utilities.log_message (' ');
312: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
313: msd_dem_common_utilities.log_message (' Profile Name - Value');
314: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
315:
316: /* Initializing profiles */

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

309: msd_dem_common_utilities.log_message (' Push Profiles ');
310: msd_dem_common_utilities.log_message ('---------------');
311: msd_dem_common_utilities.log_message (' ');
312: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
313: msd_dem_common_utilities.log_message (' Profile Name - Value');
314: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
315:
316: /* Initializing profiles */
317: init (x_errbuf,

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

310: msd_dem_common_utilities.log_message ('---------------');
311: msd_dem_common_utilities.log_message (' ');
312: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
313: msd_dem_common_utilities.log_message (' Profile Name - Value');
314: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
315:
316: /* Initializing profiles */
317: init (x_errbuf,
318: x_retcode);

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

320: /* Get the Profile values */
321: FOR i IN g_profile_list.FIRST..g_profile_list.LAST
322: LOOP
323: g_profile_list(i).profile_value := decode_profile_function (g_profile_list(i));
324: msd_dem_common_utilities.log_message (rpad('Profile ' || g_profile_list(i).profile_code,40)
325: || '- ' || g_profile_list(i).profile_value);
326: END LOOP;
327:
328: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');

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

324: msd_dem_common_utilities.log_message (rpad('Profile ' || g_profile_list(i).profile_code,40)
325: || '- ' || g_profile_list(i).profile_value);
326: END LOOP;
327:
328: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
329: msd_dem_common_utilities.log_message (' ');
330:
331: /* Check if all the mandatory profiles are defined */
332: IF ( (g_profile_list(2).profile_value IS NULL)

Line 329: msd_dem_common_utilities.log_message (' ');

325: || '- ' || g_profile_list(i).profile_value);
326: END LOOP;
327:
328: msd_dem_common_utilities.log_message ('-------------------------------------------------------------');
329: msd_dem_common_utilities.log_message (' ');
330:
331: /* Check if all the mandatory profiles are defined */
332: IF ( (g_profile_list(2).profile_value IS NULL)
333: OR (g_profile_list(3).profile_value IS NULL)

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

357: /* If Two-Level Planning has not been set, then default it to NO
358: */
359: IF (g_profile_list(6).profile_value IS NULL)
360: THEN
361: msd_dem_common_utilities.log_message ('Profile ' ||
362: g_profile_list(6).profile_code ||
363: ' is not defined. Defaulting this profile to - ');
364: msd_dem_common_utilities.log_message ('''Exclude family members with forecast control NONE''');
365: g_profile_list(6).profile_value := 2;

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

360: THEN
361: msd_dem_common_utilities.log_message ('Profile ' ||
362: g_profile_list(6).profile_code ||
363: ' is not defined. Defaulting this profile to - ');
364: msd_dem_common_utilities.log_message ('''Exclude family members with forecast control NONE''');
365: g_profile_list(6).profile_value := 2;
366:
367: END IF;
368:

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

367: END IF;
368:
369: IF ( (x_error <> 1) AND (x_warning = 1) )
370: THEN
371: msd_dem_common_utilities.log_message ('Profile ' || g_profile_list(4).profile_code ||
372: ' in the Source instance NOT SET !!!');
373: msd_dem_common_utilities.log_message ('The system has determined to use Organization Id = ' ||
374: g_profile_list(4).profile_value ||
375: ' as the master org.');

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

369: IF ( (x_error <> 1) AND (x_warning = 1) )
370: THEN
371: msd_dem_common_utilities.log_message ('Profile ' || g_profile_list(4).profile_code ||
372: ' in the Source instance NOT SET !!!');
373: msd_dem_common_utilities.log_message ('The system has determined to use Organization Id = ' ||
374: g_profile_list(4).profile_value ||
375: ' as the master org.');
376: msd_dem_common_utilities.log_message ('If this is not the master org, please update the MSD_DEM_MASTER_ORG profile on the Source');
377: msd_dem_common_utilities.log_message ('and rerun collections.');

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

372: ' in the Source instance NOT SET !!!');
373: msd_dem_common_utilities.log_message ('The system has determined to use Organization Id = ' ||
374: g_profile_list(4).profile_value ||
375: ' as the master org.');
376: msd_dem_common_utilities.log_message ('If this is not the master org, please update the MSD_DEM_MASTER_ORG profile on the Source');
377: msd_dem_common_utilities.log_message ('and rerun collections.');
378: END IF;
379:
380: IF (x_error = 1)

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

373: msd_dem_common_utilities.log_message ('The system has determined to use Organization Id = ' ||
374: g_profile_list(4).profile_value ||
375: ' as the master org.');
376: msd_dem_common_utilities.log_message ('If this is not the master org, please update the MSD_DEM_MASTER_ORG profile on the Source');
377: msd_dem_common_utilities.log_message ('and rerun collections.');
378: END IF;
379:
380: IF (x_error = 1)
381: THEN

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

378: END IF;
379:
380: IF (x_error = 1)
381: THEN
382: msd_dem_common_utilities.log_message ('Please make sure that profiles ' ||
383: 'MSD_DEM_CONVERSION_TYPE and MSD_DEM_MASTER_ORG are set in Source instance');
384: msd_dem_common_utilities.log_message (' and MSD_DEM_CURRENCY_CODE and MSD_DEM_SCHEMA profiles in the Planning Server are set.');
385:
386: retcode := -1;

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

380: IF (x_error = 1)
381: THEN
382: msd_dem_common_utilities.log_message ('Please make sure that profiles ' ||
383: 'MSD_DEM_CONVERSION_TYPE and MSD_DEM_MASTER_ORG are set in Source instance');
384: msd_dem_common_utilities.log_message (' and MSD_DEM_CURRENCY_CODE and MSD_DEM_SCHEMA profiles in the Planning Server are set.');
385:
386: retcode := -1;
387: errbuf := 'Profiles not set';
388: RETURN;

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

387: errbuf := 'Profiles not set';
388: RETURN;
389: ELSE
390:
391: msd_dem_common_utilities.log_message (' Actions');
392: msd_dem_common_utilities.log_message ('---------');
393:
394: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_setup_parameters in the Source instance');
395: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_setup_parameters' || g_dblink;

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

388: RETURN;
389: ELSE
390:
391: msd_dem_common_utilities.log_message (' Actions');
392: msd_dem_common_utilities.log_message ('---------');
393:
394: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_setup_parameters in the Source instance');
395: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_setup_parameters' || g_dblink;
396: */

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

390:
391: msd_dem_common_utilities.log_message (' Actions');
392: msd_dem_common_utilities.log_message ('---------');
393:
394: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_setup_parameters in the Source instance');
395: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_setup_parameters' || g_dblink;
396: */
397: x_sql := 'DELETE FROM msd_dem_setup_parameters' || g_dblink;
398:

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

397: x_sql := 'DELETE FROM msd_dem_setup_parameters' || g_dblink;
398:
399: EXECUTE IMMEDIATE x_sql;
400:
401: msd_dem_common_utilities.log_message ('Inserting profiles into source msd_dem_setup_parameters');
402: x_sql := 'INSERT INTO msd_dem_setup_parameters' || g_dblink ||
403: ' (parameter_name, parameter_value, last_update_date, last_updated_by, creation_date, ' ||
404: ' created_by, last_update_login) values (:1, :2, sysdate, :3, sysdate, ' ||
405: ' :4, :5)';

Line 414: msd_dem_common_utilities.log_message (' ');

410: END LOOP;
411:
412: COMMIT;
413:
414: msd_dem_common_utilities.log_message (' ');
415:
416: END IF;
417:
418:

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

415:
416: END IF;
417:
418:
419: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_profiles - ' || sysdate);
420:
421: EXCEPTION
422: WHEN OTHERS THEN
423: retcode := -1 ;

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

421: EXCEPTION
422: WHEN OTHERS THEN
423: retcode := -1 ;
424: errbuf := substr(SQLERRM,1,150);
425: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_profiles - ' || sysdate);
426: msd_dem_common_utilities.log_message (errbuf);
427: RETURN;
428:
429: END PUSH_PROFILES;

Line 426: msd_dem_common_utilities.log_message (errbuf);

422: WHEN OTHERS THEN
423: retcode := -1 ;
424: errbuf := substr(SQLERRM,1,150);
425: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_profiles - ' || sysdate);
426: msd_dem_common_utilities.log_message (errbuf);
427: RETURN;
428:
429: END PUSH_PROFILES;
430:

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

449: x_sql VARCHAR2(1000) := NULL;
450:
451: BEGIN
452:
453: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
454:
455: msd_dem_common_utilities.log_message (' Push Organizations - Actions');
456: msd_dem_common_utilities.log_message ('------------------------------');
457: msd_dem_common_utilities.log_message (' ');

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

451: BEGIN
452:
453: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
454:
455: msd_dem_common_utilities.log_message (' Push Organizations - Actions');
456: msd_dem_common_utilities.log_message ('------------------------------');
457: msd_dem_common_utilities.log_message (' ');
458:
459: msd_dem_common_utilities.log_message ('Deleting Organizations from source msd_dem_app_instance_orgs');

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

452:
453: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
454:
455: msd_dem_common_utilities.log_message (' Push Organizations - Actions');
456: msd_dem_common_utilities.log_message ('------------------------------');
457: msd_dem_common_utilities.log_message (' ');
458:
459: msd_dem_common_utilities.log_message ('Deleting Organizations from source msd_dem_app_instance_orgs');
460: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_app_instance_orgs' || g_dblink;

Line 457: msd_dem_common_utilities.log_message (' ');

453: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
454:
455: msd_dem_common_utilities.log_message (' Push Organizations - Actions');
456: msd_dem_common_utilities.log_message ('------------------------------');
457: msd_dem_common_utilities.log_message (' ');
458:
459: msd_dem_common_utilities.log_message ('Deleting Organizations from source msd_dem_app_instance_orgs');
460: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_app_instance_orgs' || g_dblink;
461: */

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

455: msd_dem_common_utilities.log_message (' Push Organizations - Actions');
456: msd_dem_common_utilities.log_message ('------------------------------');
457: msd_dem_common_utilities.log_message (' ');
458:
459: msd_dem_common_utilities.log_message ('Deleting Organizations from source msd_dem_app_instance_orgs');
460: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.msd_dem_app_instance_orgs' || g_dblink;
461: */
462: x_sql := 'DELETE FROM msd_dem_app_instance_orgs' || g_dblink;
463:

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

462: x_sql := 'DELETE FROM msd_dem_app_instance_orgs' || g_dblink;
463:
464: EXECUTE IMMEDIATE x_sql;
465:
466: msd_dem_common_utilities.log_message ('Inserting Organizations into source msd_dem_app_instance_orgs');
467: x_sql := 'INSERT INTO msd_dem_app_instance_orgs' || g_dblink ||
468: ' ( organization_id, organization_code, last_update_date, last_updated_by, creation_date, ' ||
469: ' created_by, last_update_login) ' ||
470: ' SELECT mtp.sr_tp_id, mtp.organization_code, sysdate, :a1, sysdate, ' ||

Line 484: msd_dem_common_utilities.log_message (' ');

480: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id, p_sr_instance_id, p_collection_group, p_collection_group;
481:
482: COMMIT;
483:
484: msd_dem_common_utilities.log_message (' ');
485: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
486:
487: EXCEPTION
488: WHEN OTHERS THEN

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

481:
482: COMMIT;
483:
484: msd_dem_common_utilities.log_message (' ');
485: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
486:
487: EXCEPTION
488: WHEN OTHERS THEN
489: retcode := -1 ;

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

487: EXCEPTION
488: WHEN OTHERS THEN
489: retcode := -1 ;
490: errbuf := substr(SQLERRM,1,150);
491: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
492: msd_dem_common_utilities.log_message (errbuf);
493: RETURN;
494:
495: END PUSH_ORGANIZATIONS;

Line 492: msd_dem_common_utilities.log_message (errbuf);

488: WHEN OTHERS THEN
489: retcode := -1 ;
490: errbuf := substr(SQLERRM,1,150);
491: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
492: msd_dem_common_utilities.log_message (errbuf);
493: RETURN;
494:
495: END PUSH_ORGANIZATIONS;
496:

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

531: x_actual_agg_method NUMBER(1) := NULL;
532:
533: BEGIN
534:
535: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
536:
537:
538: msd_dem_common_utilities.log_message (' Push Time Data - Actions');
539: msd_dem_common_utilities.log_message ('------------------------------');

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

534:
535: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
536:
537:
538: msd_dem_common_utilities.log_message (' Push Time Data - Actions');
539: msd_dem_common_utilities.log_message ('------------------------------');
540: msd_dem_common_utilities.log_message (' ');
541:
542: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_dates');

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

535: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
536:
537:
538: msd_dem_common_utilities.log_message (' Push Time Data - Actions');
539: msd_dem_common_utilities.log_message ('------------------------------');
540: msd_dem_common_utilities.log_message (' ');
541:
542: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_dates');
543: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.' || 'msd_dem_dates' || g_dblink;

Line 540: msd_dem_common_utilities.log_message (' ');

536:
537:
538: msd_dem_common_utilities.log_message (' Push Time Data - Actions');
539: msd_dem_common_utilities.log_message ('------------------------------');
540: msd_dem_common_utilities.log_message (' ');
541:
542: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_dates');
543: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.' || 'msd_dem_dates' || g_dblink;
544: */

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

538: msd_dem_common_utilities.log_message (' Push Time Data - Actions');
539: msd_dem_common_utilities.log_message ('------------------------------');
540: msd_dem_common_utilities.log_message (' ');
541:
542: msd_dem_common_utilities.log_message ('Deleting time data from source msd_dem_dates');
543: /* x_sql := 'TRUNCATE TABLE ' || g_msd_schema_name || '.' || 'msd_dem_dates' || g_dblink;
544: */
545: x_sql := 'DELETE FROM msd_dem_dates' || g_dblink;
546:

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

551: FETCH c_get_table INTO x_dm_table;
552: CLOSE c_get_table;
553: */
554:
555: x_dm_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');
556:
557: /* Get the time level info for the active data model */
558: x_sql := 'SELECT time_bucket, first_day_of_week, aggregation_method ' ||
559: ' FROM ' || x_dm_table ||

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

563: EXECUTE IMMEDIATE x_sql INTO x_time_bucket, x_first_day_of_week, x_aggregation_method;
564:
565: IF (upper(x_time_bucket) = 'DAY')
566: THEN
567: msd_dem_common_utilities.log_message ('Lowest Time Bucket - Day : Time data not inserted into source msd_dem_dates');
568: RETURN;
569: ELSIF (upper(x_time_bucket) = 'WEEK')
570: THEN
571: x_actual_agg_method := x_aggregation_method;

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

575: x_actual_agg_method := 2;
576: ELSE
577: retcode := -1;
578: errbuf := 'Invalid time bucket';
579: msd_dem_common_utilities.log_message ('Error(1): msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
580: msd_dem_common_utilities.log_message ('Invalid time bucket');
581: RETURN;
582: END IF;
583:

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

576: ELSE
577: retcode := -1;
578: errbuf := 'Invalid time bucket';
579: msd_dem_common_utilities.log_message ('Error(1): msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
580: msd_dem_common_utilities.log_message ('Invalid time bucket');
581: RETURN;
582: END IF;
583:
584: IF (x_actual_agg_method = 1) /* Forward */

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

595: FETCH c_get_table INTO x_source_time_table;
596: CLOSE c_get_table;
597: */
598:
599: x_source_time_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS');
600:
601: msd_dem_common_utilities.log_message ('Inserting time data into source msd_dem_dates');
602: x_sql := 'INSERT INTO msd_dem_dates' || g_dblink ||
603: ' (datet, num_of_days, start_date, end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||

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

597: */
598:
599: x_source_time_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS');
600:
601: msd_dem_common_utilities.log_message ('Inserting time data into source msd_dem_dates');
602: x_sql := 'INSERT INTO msd_dem_dates' || g_dblink ||
603: ' (datet, num_of_days, start_date, end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||
604: ' SELECT datet, num_of_days, ' || x_start_date || x_end_date ||
605: ' sysdate, :1, sysdate, :2, :3 ' ||

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

607: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
608:
609: COMMIT;
610:
611: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
612:
613: EXCEPTION
614: WHEN OTHERS THEN
615: retcode := -1 ;

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

613: EXCEPTION
614: WHEN OTHERS THEN
615: retcode := -1 ;
616: errbuf := substr(SQLERRM,1,150);
617: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
618: msd_dem_common_utilities.log_message (errbuf);
619: RETURN;
620:
621: END PUSH_TIME_DATA;

Line 618: msd_dem_common_utilities.log_message (errbuf);

614: WHEN OTHERS THEN
615: retcode := -1 ;
616: errbuf := substr(SQLERRM,1,150);
617: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_time_data - ' || sysdate);
618: msd_dem_common_utilities.log_message (errbuf);
619: RETURN;
620:
621: END PUSH_TIME_DATA;
622:

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

655: ORDER BY created desc;
656:
657: BEGIN
658:
659: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
660:
661: /* Get the db link to the source instance */
662: msd_dem_common_utilities.get_dblink (
663: x_errbuf,

Line 662: msd_dem_common_utilities.get_dblink (

658:
659: msd_dem_common_utilities.log_debug ('Entering: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
660:
661: /* Get the db link to the source instance */
662: msd_dem_common_utilities.get_dblink (
663: x_errbuf,
664: x_retcode,
665: p_sr_instance_id,
666: g_dblink);

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

668: IF (x_retcode = '-1')
669: THEN
670: retcode := -1;
671: errbuf := x_errbuf;
672: msd_dem_common_utilities.log_message ('Error(1): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
673: RETURN;
674: END IF;
675:
676: /* Get the msd schema name */

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

676: /* Get the msd schema name */
677: /* 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;';
678: EXECUTE IMMEDIATE x_sql USING OUT g_msd_schema_name;
679:
680: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);
681: */
682: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
683: msd_dem_common_utilities.log_message (' -----------------------------');
684: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);

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

678: EXECUTE IMMEDIATE x_sql USING OUT g_msd_schema_name;
679:
680: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);
681: */
682: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
683: msd_dem_common_utilities.log_message (' -----------------------------');
684: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);
685: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
686: msd_dem_common_utilities.log_message (' ');

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

679:
680: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);
681: */
682: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
683: msd_dem_common_utilities.log_message (' -----------------------------');
684: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);
685: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
686: msd_dem_common_utilities.log_message (' ');
687:

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

680: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);
681: */
682: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
683: msd_dem_common_utilities.log_message (' -----------------------------');
684: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);
685: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
686: msd_dem_common_utilities.log_message (' ');
687:
688: g_user_id := fnd_global.user_id;

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

681: */
682: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
683: msd_dem_common_utilities.log_message (' -----------------------------');
684: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);
685: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
686: msd_dem_common_utilities.log_message (' ');
687:
688: g_user_id := fnd_global.user_id;
689: g_login_id := fnd_global.login_id;

Line 686: msd_dem_common_utilities.log_message (' ');

682: msd_dem_common_utilities.log_message (' Push Setup Parameters Program');
683: msd_dem_common_utilities.log_message (' -----------------------------');
684: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);
685: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
686: msd_dem_common_utilities.log_message (' ');
687:
688: g_user_id := fnd_global.user_id;
689: g_login_id := fnd_global.login_id;
690:

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

696: IF (x_retcode = '-1')
697: THEN
698: retcode := -1;
699: errbuf := x_errbuf;
700: msd_dem_common_utilities.log_message ('Error(2): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
701: RETURN;
702: ELSE
703: retcode := x_retcode;
704: END IF;

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

713: IF (x_retcode = '-1')
714: THEN
715: retcode := -1;
716: errbuf := x_errbuf;
717: msd_dem_common_utilities.log_message ('Error(3): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
718: RETURN;
719: END IF;
720:
721: /* Push the profile values to the source instance */

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

729: IF (x_retcode = '-1')
730: THEN
731: retcode := -1;
732: errbuf := x_errbuf;
733: msd_dem_common_utilities.log_message ('Error(4): msd_dem_push_setup_parameters.push_organizations - ' || sysdate);
734: RETURN;
735: END IF;
736:
737: OPEN c_get_dm_schema; --jarora

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

752: IF (x_retcode = '-1')
753: THEN
754: retcode := -1;
755: errbuf := x_errbuf;
756: msd_dem_common_utilities.log_message ('Error(5): msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
757: RETURN;
758: END IF;
759:
760: ELSE

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

762: END IF; --jarora
763:
764: COMMIT;
765:
766: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
767:
768: EXCEPTION
769: WHEN OTHERS THEN
770: retcode := -1 ;

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

768: EXCEPTION
769: WHEN OTHERS THEN
770: retcode := -1 ;
771: errbuf := substr(SQLERRM,1,150);
772: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
773: msd_dem_common_utilities.log_message (errbuf);
774: RETURN;
775:
776: END PUSH_SETUP_PARAMETERS;

Line 773: msd_dem_common_utilities.log_message (errbuf);

769: WHEN OTHERS THEN
770: retcode := -1 ;
771: errbuf := substr(SQLERRM,1,150);
772: msd_dem_common_utilities.log_message ('Exception: msd_dem_push_setup_parameters.push_setup_parameters - ' || sysdate);
773: msd_dem_common_utilities.log_message (errbuf);
774: RETURN;
775:
776: END PUSH_SETUP_PARAMETERS;
777: