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.9.12020000.2 2013/01/08 06:34:42 kkhatri ship $ */
3:
4: /*** CUSTOM DATA TYPES ***/
5:

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

1157:
1158:
1159:
1160:
1161: END MSD_DEM_PUSH_SETUP_PARAMETERS;