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_GEN_MAIN dependencies on HR_DM_GEN_MAIN

Line 1: package body hr_dm_gen_main as

1: package body hr_dm_gen_main as
2: /* $Header: perdmgn.pkb 115.21 2004/03/24 08:28:33 mmudigon ship $ */
3: -- ------------------------- chk_long_column ------------------------
4: -- Description:
5: -- It check whether a table has a long column or not. It reurns

Line 59: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.chk_long_column', 5);

55: l_pay_owner,
56: l_per_owner);
57:
58: begin
59: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.chk_long_column', 5);
60: hr_dm_utility.message('PARA','(p_table_name - ' || p_table_name ||
61: ')', 10);
62:
63: open csr_apps_name;

Line 77: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - check whether table has any long column',15);

73: l_return_flag := 'N';
74: end if;
75: close csr_chk_long_column;
76:
77: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - check whether table has any long column',15);
78:
79: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.chk_long_column', 25);
80: hr_dm_utility.message('PARA','(l_return_flag - ' || l_return_flag || ')' ,30);
81: return l_return_flag;

Line 79: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.chk_long_column', 25);

75: close csr_chk_long_column;
76:
77: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - check whether table has any long column',15);
78:
79: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.chk_long_column', 25);
80: hr_dm_utility.message('PARA','(l_return_flag - ' || l_return_flag || ')' ,30);
81: return l_return_flag;
82: exception
83: when others then

Line 84: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.chk_long_column',

80: hr_dm_utility.message('PARA','(l_return_flag - ' || l_return_flag || ')' ,30);
81: return l_return_flag;
82: exception
83: when others then
84: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.chk_long_column',
85: '(none)','R');
86: raise;
87: end chk_long_column;
88:

Line 129: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.get_hierarchy_info', 5);

125: and hir.hierarchy_type = p_hierarchy_type;
126:
127:
128: begin
129: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.get_hierarchy_info', 5);
130: hr_dm_utility.message('PARA','(p_table_id - ' || p_table_id ||
131: ')(p_hierarchy_type - ' || p_hierarchy_type ||
132: ')', 10);
133:

Line 161: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - get whether a given hierarchy type'||

157: close csr_get_hierarchy_info;
158:
159: end if;
160:
161: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - get whether a given hierarchy type'||
162: ' is valid for table ' ||
163: 'in hr_dm_dt_deletes table ',15);
164:
165: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.get_hierarchy_info',

Line 165: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.get_hierarchy_info',

161: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - get whether a given hierarchy type'||
162: ' is valid for table ' ||
163: 'in hr_dm_dt_deletes table ',15);
164:
165: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.get_hierarchy_info',
166: 25);
167: hr_dm_utility.message('PARA','(l_return_flag - ' || l_return_flag || ')' ,30);
168: return l_return_flag;
169: exception

Line 171: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.get_hierarchy_info',

167: hr_dm_utility.message('PARA','(l_return_flag - ' || l_return_flag || ')' ,30);
168: return l_return_flag;
169: exception
170: when others then
171: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.get_hierarchy_info',
172: '(none)','R');
173: raise;
174: end get_hierarchy_info;
175:

Line 202: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.chk_ins_resolve_pk', 5);

198: select nvl(upload_table_name, table_name)
199: from hr_dm_tables
200: where table_id = p_table_id));
201: begin
202: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.chk_ins_resolve_pk', 5);
203: hr_dm_utility.message('PARA','(p_table_id - ' || p_table_id ||
204: ')', 10);
205:
206: open csr_chk_ins_resolve_pk (p_table_id);

Line 215: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - get whether a table has child table'||

211: l_return_flag := 'N';
212: end if;
213: close csr_chk_ins_resolve_pk;
214:
215: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - get whether a table has child table'||
216: ' with hierarchy type L',15);
217:
218: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.chk_ins_resolve_pk',
219: 25);

Line 218: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.chk_ins_resolve_pk',

214:
215: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - get whether a table has child table'||
216: ' with hierarchy type L',15);
217:
218: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.chk_ins_resolve_pk',
219: 25);
220: hr_dm_utility.message('PARA','(l_return_flag - ' || l_return_flag || ')' ,30);
221: return l_return_flag;
222: exception

Line 224: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.chk_ins_resolve_pk',

220: hr_dm_utility.message('PARA','(l_return_flag - ' || l_return_flag || ')' ,30);
221: return l_return_flag;
222: exception
223: when others then
224: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.chk_ins_resolve_pk',
225: '(none)','R');
226: raise;
227: end chk_ins_resolve_pk;
228:

Line 321: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.post_generate_validate', 5);

317:
318:
319: begin
320: -- return;
321: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.post_generate_validate', 5);
322: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
323: ')', 10);
324:
325: for csr_get_table_rec in csr_get_table loop

Line 403: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - post generate validation ',15);

399: raise e_fatal_error;
400: end if;
401:
402:
403: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - post generate validation ',15);
404: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.post_generate_validate',
405: 25);
406:
407: -- error handling

Line 404: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.post_generate_validate',

400: end if;
401:
402:
403: hr_dm_utility.message('INFO','HR_DM_GEN_MAIN - post generate validation ',15);
404: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.post_generate_validate',
405: 25);
406:
407: -- error handling
408: exception

Line 410: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.post_generate_validate',

406:
407: -- error handling
408: exception
409: when e_fatal_error then
410: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.post_generate_validate',
411: l_fatal_error_message,'R');
412: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.post_generate_validate',
413: '(none)','R');
414: when others then

Line 412: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.post_generate_validate',

408: exception
409: when e_fatal_error then
410: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.post_generate_validate',
411: l_fatal_error_message,'R');
412: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.post_generate_validate',
413: '(none)','R');
414: when others then
415: -- update status to error
416: hr_dm_utility.update_phase_items(p_new_status => 'E',

Line 418: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.post_generate_validate','(none)','R');

414: when others then
415: -- update status to error
416: hr_dm_utility.update_phase_items(p_new_status => 'E',
417: p_id => l_phase_item_id);
418: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.post_generate_validate','(none)','R');
419: end post_generate_validate;
420:
421: -- ------------------------- slave_generator_for_tbl --------------------
422: -- Description:

Line 510: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.slave_generator_for_tbl ', 5);

506: l_parent_table_id number;
507:
508: begin
509:
510: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.slave_generator_for_tbl ', 5);
511: hr_dm_utility.message('PARA','(p_phase_item_id - ' || p_phase_item_id ||
512: ')', 10);
513: -- initialise the counter.
514: l_count := 1;

Line 821: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.slave_generator_for_tbl',

817: l_csr_get_table_rec.table_name || ', Table Id - ' ||
818: l_csr_get_table_rec.table_id,115);
819: close csr_get_table;
820:
821: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.slave_generator_for_tbl',
822: 120);
823:
824: -- error handling
825: exception

Line 830: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator_for_tbl',

826: when e_fatal_error then
827: if csr_get_table%isopen then
828: close csr_get_table;
829: end if;
830: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator_for_tbl',
831: l_fatal_error_message,'R');
832: hr_dm_utility.update_phase_items(p_new_status => 'E',
833: p_id => l_phase_item_id);
834:

Line 835: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator_for_tbl','(none)','R');

831: l_fatal_error_message,'R');
832: hr_dm_utility.update_phase_items(p_new_status => 'E',
833: p_id => l_phase_item_id);
834:
835: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator_for_tbl','(none)','R');
836: when others then
837: if csr_get_table%isopen then
838: close csr_get_table;
839: end if;

Line 843: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator_for_tbl','(none)','R');

839: end if;
840: -- update status to error
841: hr_dm_utility.update_phase_items(p_new_status => 'E',
842: p_id => l_phase_item_id);
843: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator_for_tbl','(none)','R');
844:
845: end slave_generator_for_tbl ;
846:
847: -- ------------------------- slave_generator --------------------------

Line 1002: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.slave_generator', 5);

998: if p_concurrent_process = 'Y' then
999: hr_dm_utility.message_init;
1000: end if;
1001:
1002: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.slave_generator', 5);
1003: hr_dm_utility.message('PARA','(errbuf - ' || errbuf ||
1004: ')(retcode - ' || retcode ||
1005: ')(p_migration_id - ' || p_migration_id ||
1006: ')(p_concurrent_process - ' || p_concurrent_process ||

Line 1412: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.slave_generator',

1408: -- set up return values to concurrent manager
1409: retcode := 0;
1410: errbuf := 'No errors - examine logfiles for detailed reports.';
1411:
1412: hr_dm_utility.message('ROUT','exit:hr_dm_gen_main.slave_generator',
1413: 125);
1414: -- error handling
1415: exception
1416: when e_fatal_error then

Line 1422: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator',

1418: close csr_get_table;
1419: end if;
1420: retcode := 2;
1421: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
1422: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator',
1423: l_fatal_error_message,'R');
1424:
1425: -- if the error is caused because the other process has set the generator phase to 'Error'
1426: -- then the phase_item_id is 'NULL' , otherwise, the error is caused within this process

Line 1437: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator','(none)','R');

1433: hr_dm_utility.update_phases(p_new_status => 'E',
1434: p_id => l_phase_id);
1435: end if;
1436:
1437: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator','(none)','R');
1438: when e_fatal_error2 then
1439: if csr_get_table%isopen then
1440: close csr_get_table;
1441: end if;

Line 1444: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator',

1440: close csr_get_table;
1441: end if;
1442: retcode := 0;
1443: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
1444: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator',
1445: l_fatal_error_message,'R');
1446:
1447: -- if the error is caused because the other process has set the generator phase to 'Error'
1448: -- then the phase_item_id is 'NULL' , otherwise, the error is caused within this process

Line 1459: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator','(none)','R');

1455: hr_dm_utility.update_phases(p_new_status => 'E',
1456: p_id => l_phase_id);
1457: end if;
1458:
1459: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator','(none)','R');
1460: when others then
1461: if csr_get_table%isopen then
1462: close csr_get_table;
1463: end if;

Line 1469: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator','(none)','R');

1465: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
1466: -- update status to error
1467: hr_dm_utility.update_phase_items(p_new_status => 'E',
1468: p_id => l_phase_item_id);
1469: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator','(none)','R');
1470:
1471:
1472: end slave_generator ;
1473: end hr_dm_gen_main;

Line 1473: end hr_dm_gen_main;

1469: hr_dm_utility.error(SQLCODE,'hr_dm_gen_main.slave_generator','(none)','R');
1470:
1471:
1472: end slave_generator ;
1473: end hr_dm_gen_main;