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.HR_DM_COPY dependencies on HR_DM_UTILITY

Line 66: hr_dm_utility.message('ROUT','entry:hr_dm_copy.delete_datapump_tables', 5);

62: l_schema varchar2(30);
63:
64: begin
65:
66: hr_dm_utility.message('ROUT','entry:hr_dm_copy.delete_datapump_tables', 5);
67:
68: -- get schema for PER
69: l_schema := get_schema('PER');
70:

Line 80: hr_dm_utility.message('INFO',

76: '.HR_PUMP_BATCH_LINE_USER_KEYS ' ||
77: ' disable constraint HR_PUMP_BATCH_LINE_USER_KE_FK1';
78: exception
79: when others then
80: hr_dm_utility.message('INFO',
81: 'Problem with constraint HR_PUMP_BATCH_LINE_USER_KE_FK1 - disable', 5);
82: end;
83: -- hr_pump_batch_headers
84: begin

Line 90: hr_dm_utility.message('INFO',

86: '.HR_PUMP_BATCH_LINES ' ||
87: ' disable constraint HR_PUMP_BATCH_LINES_FK1';
88: exception
89: when others then
90: hr_dm_utility.message('INFO',
91: 'Problem with constraint HR_PUMP_BATCH_LINES_FK1 - disable', 5);
92: end;
93: begin
94: execute immediate 'alter table ' || l_schema ||

Line 99: hr_dm_utility.message('INFO',

95: '.HR_PUMP_RANGES ' ||
96: ' disable constraint HR_PUMP_RANGES_FK1';
97: exception
98: when others then
99: hr_dm_utility.message('INFO',
100: 'Problem with constraint HR_PUMP_RANGES_FK1 - disable', 5);
101: end;
102: begin
103: execute immediate 'alter table ' || l_schema ||

Line 108: hr_dm_utility.message('INFO',

104: '.HR_PUMP_REQUESTS ' ||
105: ' disable constraint HR_PUMP_REQUESTS_FK1';
106: exception
107: when others then
108: hr_dm_utility.message('INFO',
109: 'Problem with constraint HR_PUMP_REQUESTS_FK1 - disable', 5);
110: end;
111:
112:

Line 116: hr_dm_utility.message('INFO','Truncating table hr_pump_requests',10);

112:
113:
114: -- truncate datapump tables. call run_sql procedure to run
115: -- 'truncate ddl' command.
116: hr_dm_utility.message('INFO','Truncating table hr_pump_requests',10);
117: hr_dm_library.run_sql('truncate table ' || l_schema ||
118: '.hr_pump_requests');
119:
120: hr_dm_utility.message('INFO','Truncating table hr_pump_ranges',15);

Line 120: hr_dm_utility.message('INFO','Truncating table hr_pump_ranges',15);

116: hr_dm_utility.message('INFO','Truncating table hr_pump_requests',10);
117: hr_dm_library.run_sql('truncate table ' || l_schema ||
118: '.hr_pump_requests');
119:
120: hr_dm_utility.message('INFO','Truncating table hr_pump_ranges',15);
121: hr_dm_library.run_sql('truncate table ' || l_schema ||
122: '.hr_pump_ranges');
123:
124: hr_dm_utility.message('INFO',

Line 124: hr_dm_utility.message('INFO',

120: hr_dm_utility.message('INFO','Truncating table hr_pump_ranges',15);
121: hr_dm_library.run_sql('truncate table ' || l_schema ||
122: '.hr_pump_ranges');
123:
124: hr_dm_utility.message('INFO',
125: 'Truncating table hr_pump_batch_exceptions',20);
126: hr_dm_library.run_sql('truncate table ' || l_schema ||
127: '.hr_pump_batch_exceptions');
128:

Line 129: hr_dm_utility.message('INFO',

125: 'Truncating table hr_pump_batch_exceptions',20);
126: hr_dm_library.run_sql('truncate table ' || l_schema ||
127: '.hr_pump_batch_exceptions');
128:
129: hr_dm_utility.message('INFO',
130: 'Truncating table hr_pump_batch_line_user_keys',25);
131: hr_dm_library.run_sql('truncate table ' || l_schema ||
132: '.hr_pump_batch_line_user_keys');
133:

Line 134: hr_dm_utility.message('INFO','Truncating table hr_pump_batch_lines',26);

130: 'Truncating table hr_pump_batch_line_user_keys',25);
131: hr_dm_library.run_sql('truncate table ' || l_schema ||
132: '.hr_pump_batch_line_user_keys');
133:
134: hr_dm_utility.message('INFO','Truncating table hr_pump_batch_lines',26);
135: hr_dm_library.run_sql('truncate table ' || l_schema ||
136: '.hr_pump_batch_lines');
137:
138: hr_dm_utility.message('INFO',

Line 138: hr_dm_utility.message('INFO',

134: hr_dm_utility.message('INFO','Truncating table hr_pump_batch_lines',26);
135: hr_dm_library.run_sql('truncate table ' || l_schema ||
136: '.hr_pump_batch_lines');
137:
138: hr_dm_utility.message('INFO',
139: 'Truncating table hr_pump_batch_headers',30);
140: hr_dm_library.run_sql('truncate table ' || l_schema ||
141: '.hr_pump_batch_headers');
142:

Line 154: hr_dm_utility.message('INFO',

150: '.HR_PUMP_BATCH_LINE_USER_KEYS ' ||
151: ' enable constraint HR_PUMP_BATCH_LINE_USER_KE_FK1';
152: exception
153: when others then
154: hr_dm_utility.message('INFO',
155: 'Problem with constraint HR_PUMP_BATCH_LINE_USER_KE_FK1 - enable', 5);
156: end;
157: -- hr_pump_batch_headers
158: begin

Line 164: hr_dm_utility.message('INFO',

160: '.HR_PUMP_BATCH_LINES ' ||
161: ' enable constraint HR_PUMP_BATCH_LINES_FK1';
162: exception
163: when others then
164: hr_dm_utility.message('INFO',
165: 'Problem with constraint HR_PUMP_BATCH_LINES_FK1 - enable', 5);
166: end;
167: begin
168: execute immediate 'alter table ' || l_schema ||

Line 173: hr_dm_utility.message('INFO',

169: '.HR_PUMP_RANGES ' ||
170: ' enable constraint HR_PUMP_RANGES_FK1';
171: exception
172: when others then
173: hr_dm_utility.message('INFO',
174: 'Problem with constraint HR_PUMP_RANGES_FK1 - enable', 5);
175: end;
176: begin
177: execute immediate 'alter table ' || l_schema ||

Line 182: hr_dm_utility.message('INFO',

178: '.HR_PUMP_REQUESTS ' ||
179: ' enable constraint HR_PUMP_REQUESTS_FK1';
180: exception
181: when others then
182: hr_dm_utility.message('INFO',
183: 'Problem with constraint HR_PUMP_REQUESTS_FK1 - enable', 5);
184: end;
185:
186:

Line 187: hr_dm_utility.message('ROUT','exit:hr_dm_copy.delete_datapump_tables', 35);

183: 'Problem with constraint HR_PUMP_REQUESTS_FK1 - enable', 5);
184: end;
185:
186:
187: hr_dm_utility.message('ROUT','exit:hr_dm_copy.delete_datapump_tables', 35);
188:
189:
190:
191: exception

Line 193: hr_dm_utility.error(SQLCODE,'hr_dm_copy.delete_datapump_tables',

189:
190:
191: exception
192: when others then
193: hr_dm_utility.error(SQLCODE,'hr_dm_copy.delete_datapump_tables',
194: '(none)','R');
195: raise;
196: end delete_datapump_tables;
197:

Line 250: hr_dm_utility.message('ROUT','entry:hr_dm_copy.source_copy', 5);

246:
247:
248:
249: begin
250: hr_dm_utility.message('ROUT','entry:hr_dm_copy.source_copy', 5);
251: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
252: ')', 10);
253:
254:

Line 251: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||

247:
248:
249: begin
250: hr_dm_utility.message('ROUT','entry:hr_dm_copy.source_copy', 5);
251: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
252: ')', 10);
253:
254:
255: -- insert data migrator packages rows from HR_API_MODULES i.e

Line 264: hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_api_modules_v',15);

260: fetch csr_phase_rule into l_up_phase_used;
261: close csr_phase_rule;
262:
263: if (l_up_phase_used = 'UP') then
264: hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_api_modules_v',15);
265: insert into hr_dm_exp_api_modules_v (exp_imp_id
266: ,table_name
267: ,api_module_id
268: ,api_module_type

Line 302: hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_migrations_v',20);

298:
299: -- Insert the current migration row from HR_DM_MIGRATIONS tables
300: -- into HR_DM_EXP_MIGRATIONS_V view based on HR_DM_EXP_IMPS table
301:
302: hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_migrations_v',20);
303: insert into hr_dm_exp_migrations_v ( exp_imp_id
304: ,table_name
305: ,migration_id
306: ,source_database_instance

Line 361: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_V',15);

357: -- only perform for an FW migration
358:
359: if (l_migration_type = 'FW') then
360:
361: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_V',15);
362: insert into HR_DM_EXP_HR_LOC_ALL_V (
363: EXP_IMP_ID,
364: TABLE_NAME,
365: LOCATION_ID,

Line 541: hr_dm_utility.message('INFO','Removing HR_LOCATIONS_ALL rows from hr_pump_batch_lines',15);

537:
538: -- remove entries for HR_LOCATIONS_ALL in the table hr_pump_batch lines
539: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
540: -- Note that the view already matches the where clause
541: hr_dm_utility.message('INFO','Removing HR_LOCATIONS_ALL rows from hr_pump_batch_lines',15);
542: -- use dynamic sql to avoid compiliation errors where the data pump views
543: -- have not yet been created
544: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL';
545:

Line 546: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_TL_V',15);

542: -- use dynamic sql to avoid compiliation errors where the data pump views
543: -- have not yet been created
544: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL';
545:
546: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_TL_V',15);
547: insert into HR_DM_EXP_HR_LOC_ALL_TL_V (
548: EXP_IMP_ID,
549: TABLE_NAME,
550: LOCATION_ID,

Line 585: hr_dm_utility.message('INFO','Removing HR_LOCATIONS_ALL_TL rows from hr_pump_batch_lines',15);

581: where BUSINESS_GROUP_ID is null);
582:
583: -- remove entries for HR_LOCATIONS_ALL_TL in the table hr_pump_batch lines
584: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
585: hr_dm_utility.message('INFO','Removing HR_LOCATIONS_ALL_TL rows from hr_pump_batch_lines',15);
586: -- use dynamic sql to avoid compiliation errors where the data pump views
587: -- have not yet been created
588: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL_TL ' ||
589: 'where p_LOCATION_ID in ( ' ||

Line 601: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_ALL_ORG_UNITS_V',15);

597: ' from HR_LOCATIONS_ALL ' ||
598: ' where BUSINESS_GROUP_ID is null' || ')';
599:
600:
601: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_ALL_ORG_UNITS_V',15);
602: -- the comments column has been removed as it is a long data type
603: insert into HR_DM_EXP_ALL_ORG_UNITS_V (
604: EXP_IMP_ID,
605: TABLE_NAME,

Line 697: hr_dm_utility.message('INFO','Removing HR_ALL_ORGANIZATION_UNITS rows from hr_pump_batch_lines',15);

693:
694: -- remove entries for HR_ALL_ORGANIZATION_UNITS in the table hr_pump_batch lines
695: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
696: -- Note that the view already matches the where clause
697: hr_dm_utility.message('INFO','Removing HR_ALL_ORGANIZATION_UNITS rows from hr_pump_batch_lines',15);
698: -- use dynamic sql to avoid compiliation errors where the data pump views
699: -- have not yet been created
700: execute immediate 'delete HRDPV_UHR_ALL_ORGANIZATONUNITS';
701:

Line 702: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_ORG_INFO_V',15);

698: -- use dynamic sql to avoid compiliation errors where the data pump views
699: -- have not yet been created
700: execute immediate 'delete HRDPV_UHR_ALL_ORGANIZATONUNITS';
701:
702: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_ORG_INFO_V',15);
703: insert into HR_DM_EXP_ORG_INFO_V (
704: EXP_IMP_ID,
705: TABLE_NAME,
706: ORG_INFORMATION_ID,

Line 823: hr_dm_utility.message('INFO','Removing HR_ALL_ORGANIZATION_UNITS rows from hr_pump_batch_lines',15);

819: where BUSINESS_GROUP_ID = l_business_group_id);
820:
821: -- remove entries for HR_ORGANIZATION_INFORMATION in the table hr_pump_batch lines
822: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
823: hr_dm_utility.message('INFO','Removing HR_ALL_ORGANIZATION_UNITS rows from hr_pump_batch_lines',15);
824: -- use dynamic sql to avoid compiliation errors where the data pump views
825: -- have not yet been created
826: execute immediate 'delete HRDPV_UHR_ORGANIZATNINFORMATON ' ||
827: ' where p_ORGANIZATION_ID in ( ' ||

Line 833: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_ALL_ORG_UNITS_TL_V',15);

829: ' from HR_ALL_ORGANIZATION_UNITS ' ||
830: ' where BUSINESS_GROUP_ID = ' ||
831: l_business_group_id || ')';
832:
833: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_ALL_ORG_UNITS_TL_V',15);
834: insert into HR_DM_EXP_ALL_ORG_UNITS_TL_V (
835: EXP_IMP_ID,
836: TABLE_NAME,
837: ORGANIZATION_ID,

Line 866: hr_dm_utility.message('INFO','Removing HR_ALL_ORGANIZATION_UNITS_TL rows from hr_pump_batch_lines',15);

862: where BUSINESS_GROUP_ID = l_business_group_id);
863:
864: -- remove entries for HR_ALL_ORGANIZATION_UNITS_TL in the table hr_pump_batch lines
865: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
866: hr_dm_utility.message('INFO','Removing HR_ALL_ORGANIZATION_UNITS_TL rows from hr_pump_batch_lines',15);
867: -- use dynamic sql to avoid compiliation errors where the data pump views
868: -- have not yet been created
869: execute immediate 'delete HRDPV_UHR_ALL_ORGANZTNUNITS_TL ' ||
870: ' where p_ORGANIZATION_ID in ( ' ||

Line 884: hr_dm_utility.message('INFO','copy across the ID_FLEX_STRUCTURE_NAMEs',15);

880: -- only perform for an FW or A migration
881: if (l_migration_type in ('FW', 'A')) then
882:
883: -- copy across the ID_FLEX_STRUCTURE_NAMEs for the current business group
884: hr_dm_utility.message('INFO','copy across the ID_FLEX_STRUCTURE_NAMEs',15);
885:
886: select ID_FLEX_STRUCTURE_NAME
887: into l_org_information4
888: from fnd_id_flex_structures_vl

Line 968: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_BEN_BATCH_PARAS_V',15);

964: -- only perform for an FW or A migration
965:
966: if (l_migration_type in ('FW', 'A')) then
967:
968: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_BEN_BATCH_PARAS_V',15);
969: insert into HR_DM_EXP_BEN_BATCH_PARAS_V (
970: EXP_IMP_ID,
971: TABLE_NAME,
972: BATCH_PARAMETER_ID,

Line 1012: hr_dm_utility.message('ROUT','exit:hr_dm_copy.source_copy', 25);

1008:
1009: end if;
1010:
1011: commit;
1012: hr_dm_utility.message('ROUT','exit:hr_dm_copy.source_copy', 25);
1013: exception
1014: when others then
1015: hr_dm_utility.error(SQLCODE,'hr_dm_copy.source_copy',
1016: '(none)','R');

Line 1015: hr_dm_utility.error(SQLCODE,'hr_dm_copy.source_copy',

1011: commit;
1012: hr_dm_utility.message('ROUT','exit:hr_dm_copy.source_copy', 25);
1013: exception
1014: when others then
1015: hr_dm_utility.error(SQLCODE,'hr_dm_copy.source_copy',
1016: '(none)','R');
1017: raise;
1018: end source_copy;
1019: