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_PUSH_SETUP_PARAMETERS

Line 1: PACKAGE BODY MSD_DEM_PUSH_SETUP_PARAMETERS AS

1: PACKAGE BODY MSD_DEM_PUSH_SETUP_PARAMETERS AS
2: /* $Header: msddempspb.pls 120.1.12010000.2 2008/09/05 09:50:38 nallkuma ship $ */
3:
4: /*** CUSTOM DATA TYPES ***/
5:

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 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 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 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 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 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 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 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 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 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 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 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 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 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 779: END MSD_DEM_PUSH_SETUP_PARAMETERS;

775:
776: END PUSH_SETUP_PARAMETERS;
777:
778:
779: END MSD_DEM_PUSH_SETUP_PARAMETERS;