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_LIBRARY dependencies on HR_DM_LIBRARY

Line 1: package body hr_dm_library as

1: package body hr_dm_library as
2: /* $Header: perdmlib.pkb 115.29 2004/03/24 08:28:56 mmudigon ship $ */
3: l_status varchar2(50);
4: l_industry varchar2(50);
5: l_per_owner varchar2(30);

Line 49: hr_dm_utility.error(SQLCODE,'hr_dm_library.indent',

45: end if;
46: return l_spaces;
47: exception
48: when others then
49: hr_dm_utility.error(SQLCODE,'hr_dm_library.indent',
50: '(p_indent_spaces - ' || p_indent_spaces ||
51: ')(p_newline - ' || p_newline || ')',
52: 'R');
53: end indent;

Line 103: hr_dm_utility.error(SQLCODE,'hr_dm_library.priv_indent',

99: l_spaces := c_newline || rpad(' ', p_indent_spaces) || '- ' ;
100: return l_spaces;
101: exception
102: when others then
103: hr_dm_utility.error(SQLCODE,'hr_dm_library.priv_indent',
104: '(none)',
105: 'R');
106: raise;
107: end priv_indent;

Line 111: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_generator_version'

107: end priv_indent;
108:
109: begin
110:
111: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_generator_version'
112: , 5);
113:
114: -- get the version of main generator
115: get_package_version ( p_package_name => 'HR_DM_GEN_MAIN',

Line 125: get_package_version ( p_package_name => 'HR_DM_LIBRARY',

121: l_generator_version := l_package_version;
122: end if;
123:
124: -- get the version of Library package
125: get_package_version ( p_package_name => 'HR_DM_LIBRARY',
126: p_package_version => l_package_version);
127:
128: if p_format_output = 'Y' then
129: l_generator_version := l_generator_version || priv_indent || l_package_version;

Line 176: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_generator_version'

172: p_generator_version := l_generator_version;
173:
174: hr_dm_utility.message('PARA','(p_generator_version - ' ||
175: p_generator_version || ')', 30);
176: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_generator_version'
177: , 25);
178:
179: exception
180: when others then

Line 181: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_generator_version',

177: , 25);
178:
179: exception
180: when others then
181: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_generator_version',
182: '(p_generator_version - ' || p_generator_version ||
183: ')','R');
184: raise;
185: end get_generator_version;

Line 257: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_package_version', 5);

253: end priv_get_version_from_string;
254:
255: begin
256:
257: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_package_version', 5);
258: hr_dm_utility.message('PARA','(p_package_name - ' || p_package_name ||
259: ')', 10);
260:
261: open csr_get_package_version;

Line 279: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_package_version', 25);

275: end if;
276:
277: hr_dm_utility.message('PARA','(p_package_version - ' ||
278: p_package_version || ')', 30);
279: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_package_version', 25);
280:
281: exception
282: when others then
283: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_package_version',

Line 283: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_package_version',

279: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_package_version', 25);
280:
281: exception
282: when others then
283: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_package_version',
284: '(p_package_name - ' || p_package_name ||
285: ')','R');
286: raise;
287: end get_package_version;

Line 332: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_data_type', 5);

328: l_per_owner);
329:
330: begin
331:
332: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_data_type', 5);
333: hr_dm_utility.message('PARA','(p_table_name - ' || p_table_name ||
334: ')(p_column_name - ' || p_column_name ||
335: ')', 10);
336:

Line 355: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_data_type', 25);

351: close csr_get_data_type;
352:
353: hr_dm_utility.message('PARA','(p_data_type - ' ||
354: p_data_type || ')', 30);
355: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_data_type', 25);
356:
357: exception
358: when e_fatal_error then
359: if csr_get_data_type%isopen then

Line 362: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_data_type',

358: when e_fatal_error then
359: if csr_get_data_type%isopen then
360: close csr_get_data_type;
361: end if;
362: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_data_type',
363: l_fatal_error_message,'R');
364:
365: raise;
366: when others then

Line 367: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_data_type',

363: l_fatal_error_message,'R');
364:
365: raise;
366: when others then
367: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_data_type',
368: '(p_table_name - ' || p_table_name ||
369: ')(p_column_name - ' || p_column_name ||
370: ')','R');
371: raise;

Line 420: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_table_info', 5);

416: where tbl.table_id = p_table_id;
417:
418: begin
419:
420: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_table_info', 5);
421: hr_dm_utility.message('PARA','(p_table_id - ' || p_table_id ||
422: ')', 10);
423: for csr_get_table_rec in csr_get_table loop
424: --

Line 457: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_table_info', 25);

453: 15);
454:
455: hr_dm_utility.message('PARA','(p_table_info.table_name - ' ||
456: p_table_info.table_name || ')', 30);
457: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_table_info', 25);
458:
459: exception
460: when others then
461: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_table_info','(none)'

Line 461: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_table_info','(none)'

457: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_table_info', 25);
458:
459: exception
460: when others then
461: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_table_info','(none)'
462: ,'R');
463: raise;
464: end get_table_info;
465: -- ------------------------- check_col_for_fk_on_aol ------------------------

Line 487: hr_dm_utility.message('ROUT','entry:hr_dm_library.check_col_for_fk_on_aol'

483: p_index out nocopy number
484: ) is
485: l_index number := p_fk_to_aol_columns_tbl.first;
486: begin
487: hr_dm_utility.message('ROUT','entry:hr_dm_library.check_col_for_fk_on_aol'
488: , 5);
489: hr_dm_utility.message('PARA','(p_column_name - ' || p_column_name || ')'
490: ,10);
491: p_index := null;

Line 510: hr_dm_utility.message('ROUT','exit:hr_dm_library.check_col_for_fk_on_aol',

506: 'column has FK on AOL table',15);
507: -- hr_dm_utility.message('SUMM','HR_DM_LIBARARY - checks whether ' ||
508: -- 'column has FK on AOL table',20);
509: hr_dm_utility.message('PARA','(p_index - ' || l_index || ')', 30);
510: hr_dm_utility.message('ROUT','exit:hr_dm_library.check_col_for_fk_on_aol',
511: 25);
512:
513: exception
514: when others then

Line 515: hr_dm_utility.error(SQLCODE,'hr_dm_library.check_col_for_fk_on_aol',

511: 25);
512:
513: exception
514: when others then
515: hr_dm_utility.error(SQLCODE,'hr_dm_library.check_col_for_fk_on_aol',
516: '(none)','R');
517: raise;
518: end check_col_for_fk_on_aol;
519: -- ------------------------- populate_fk_to_aol_cols -----------------------

Line 560: 'entry:hr_dm_library.populate_fk_to_aol_cols_info', 5);

556:
557: l_index number := 1;
558: begin
559: hr_dm_utility.message('ROUT',
560: 'entry:hr_dm_library.populate_fk_to_aol_cols_info', 5);
561: hr_dm_utility.message('PARA','(p_table_id - ' || p_table_info.table_id ||
562: ')(p_table_name - ' || p_table_info.table_name ||
563: ')', 10);
564: for csr_get_fk_to_aol_cols_rec in csr_get_fk_to_aol_cols loop

Line 585: 'exit:hr_dm_library.populate_fk_to_aol_cols_info',

581: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - populate list with ' ||
582: -- 'column who have FK on AOL table',20);
583: hr_dm_utility.message('PARA','(p_index - ' || l_index || ')', 30);
584: hr_dm_utility.message('ROUT',
585: 'exit:hr_dm_library.populate_fk_to_aol_cols_info',
586: 25);
587:
588: exception
589: when others then

Line 591: 'hr_dm_library.populate_fk_to_aol_cols_info',

587:
588: exception
589: when others then
590: hr_dm_utility.error(SQLCODE,
591: 'hr_dm_library.populate_fk_to_aol_cols_info',
592: '(none)','R');
593: raise;
594: end populate_fk_to_aol_cols_info;
595:

Line 665: hr_dm_utility.message('ROUT','entry:hr_dm_library.populate_columns_list'

661: l_per_owner);
662:
663: begin
664:
665: hr_dm_utility.message('ROUT','entry:hr_dm_library.populate_columns_list'
666: ,5);
667: hr_dm_utility.message('PARA','(p_table_id - ' || p_table_info.table_id ||
668: ')(p_table_name - ' || p_table_info.table_name ||
669: ')', 10);

Line 748: hr_dm_utility.message('ROUT','exit:hr_dm_library.populate_columns_list',

744: || ')( p_parameter_tbl - varchar2 record type )'
745: || ')( p_aol_columns_tbl - varchar2 record type )'
746: || ')( p_aol_parameter_tbl - varchar2 record type )'
747: ,30);
748: hr_dm_utility.message('ROUT','exit:hr_dm_library.populate_columns_list',
749: 25);
750: exception
751: when others then
752: hr_dm_utility.error(SQLCODE,'hr_dm_library.populate_columns_list',

Line 752: hr_dm_utility.error(SQLCODE,'hr_dm_library.populate_columns_list',

748: hr_dm_utility.message('ROUT','exit:hr_dm_library.populate_columns_list',
749: 25);
750: exception
751: when others then
752: hr_dm_utility.error(SQLCODE,'hr_dm_library.populate_columns_list',
753: '(none)','R');
754: raise;
755: end populate_columns_list;
756:

Line 830: 'entry:hr_dm_library.populate_pk_columns_list', 5);

826:
827:
828: begin
829: hr_dm_utility.message('ROUT',
830: 'entry:hr_dm_library.populate_pk_columns_list', 5);
831: hr_dm_utility.message('PARA','(p_table_id - ' || p_table_info.table_id ||
832: ')(p_table_name - ' || p_table_info.table_name ||
833: ')', 10);
834:

Line 899: hr_dm_utility.message('ROUT','exit:hr_dm_library.populate_pk_columns_list',

895: '(p_no_of_pk_columns - ' || p_no_of_pk_columns
896: || ')( p_pk_columns_tbl - varchar2 record type )'
897: || ')( p_pk_parameter_tbl - varchar2 record type )'
898: ,30);
899: hr_dm_utility.message('ROUT','exit:hr_dm_library.populate_pk_columns_list',
900: 25);
901:
902: exception
903: when e_fatal_error then

Line 904: hr_dm_utility.error(SQLCODE,'hr_dm_library.populate_pk_columns_list',

900: 25);
901:
902: exception
903: when e_fatal_error then
904: hr_dm_utility.error(SQLCODE,'hr_dm_library.populate_pk_columns_list',
905: l_fatal_error_message,'R');
906:
907: raise;
908: when others then

Line 909: hr_dm_utility.error(SQLCODE,'hr_dm_library.populate_pk_columns_list',

905: l_fatal_error_message,'R');
906:
907: raise;
908: when others then
909: hr_dm_utility.error(SQLCODE,'hr_dm_library.populate_pk_columns_list',
910: '(none)','R');
911: raise;
912: end populate_pk_columns_list;
913:

Line 994: 'entry:hr_dm_library.populate_hierarchy_cols_list', 5);

990:
991:
992: begin
993: hr_dm_utility.message('ROUT',
994: 'entry:hr_dm_library.populate_hierarchy_cols_list', 5);
995: hr_dm_utility.message('PARA','(p_table_id - ' || p_table_info.table_id ||
996: ')(p_table_name - ' || p_table_info.table_name ||
997: ')(p_called_from - ' || p_called_from ||
998: ')', 10);

Line 1048: 'exit:hr_dm_library.populate_hierarchy_cols_list',

1044: hr_dm_utility.message('PARA','( p_hier_columns_tbl - varchar2 record type )'
1045: || ')( p_hier_parameter_tbl - varchar2 record type )'
1046: ,30);
1047: hr_dm_utility.message('ROUT',
1048: 'exit:hr_dm_library.populate_hierarchy_cols_list',
1049: 25);
1050: exception
1051: when others then
1052: hr_dm_utility.error(SQLCODE,'hr_dm_library.populate_hierarchy_cols_list',

Line 1052: hr_dm_utility.error(SQLCODE,'hr_dm_library.populate_hierarchy_cols_list',

1048: 'exit:hr_dm_library.populate_hierarchy_cols_list',
1049: 25);
1050: exception
1051: when others then
1052: hr_dm_utility.error(SQLCODE,'hr_dm_library.populate_hierarchy_cols_list',
1053: '(none)','R');
1054: raise;
1055: end populate_hierarchy_cols_list;
1056:

Line 1075: p_columns_tbl in hr_dm_library.t_varchar2_tbl,

1071: -- contains the list of all the columns which have foreign key on AOL table.
1072: -----------------------------------------------------------------------------
1073: procedure get_cols_list_wo_pk_cols
1074: (
1075: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
1076: p_pk_columns_tbl in hr_dm_library.t_varchar2_tbl,
1077: p_cols_wo_pk_cols_tbl out nocopy hr_dm_library.t_varchar2_tbl
1078: ) is
1079:

Line 1076: p_pk_columns_tbl in hr_dm_library.t_varchar2_tbl,

1072: -----------------------------------------------------------------------------
1073: procedure get_cols_list_wo_pk_cols
1074: (
1075: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
1076: p_pk_columns_tbl in hr_dm_library.t_varchar2_tbl,
1077: p_cols_wo_pk_cols_tbl out nocopy hr_dm_library.t_varchar2_tbl
1078: ) is
1079:
1080: l_index number := p_columns_tbl.first;

Line 1077: p_cols_wo_pk_cols_tbl out nocopy hr_dm_library.t_varchar2_tbl

1073: procedure get_cols_list_wo_pk_cols
1074: (
1075: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
1076: p_pk_columns_tbl in hr_dm_library.t_varchar2_tbl,
1077: p_cols_wo_pk_cols_tbl out nocopy hr_dm_library.t_varchar2_tbl
1078: ) is
1079:
1080: l_index number := p_columns_tbl.first;
1081: l_count number := 1;

Line 1102: hr_dm_utility.error(SQLCODE,'hr_dm_library.private_is_pk_column',

1098: end loop;
1099: return l_return;
1100: exception
1101: when others then
1102: hr_dm_utility.error(SQLCODE,'hr_dm_library.private_is_pk_column',
1103: '( p_column_name = ' || p_column_name || ')','R');
1104: raise;
1105: end;
1106: begin

Line 1107: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_cols_list_wo_pk_cols'

1103: '( p_column_name = ' || p_column_name || ')','R');
1104: raise;
1105: end;
1106: begin
1107: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_cols_list_wo_pk_cols'
1108: , 5);
1109:
1110: while l_index is not null loop
1111:

Line 1122: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_cols_list_wo_pk_cols',

1118: end if;
1119: l_index := p_columns_tbl.next(l_index);
1120: end loop;
1121:
1122: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_cols_list_wo_pk_cols',
1123: 25);
1124: exception
1125: when others then
1126: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_cols_list_wo_pk_cols',

Line 1126: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_cols_list_wo_pk_cols',

1122: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_cols_list_wo_pk_cols',
1123: 25);
1124: exception
1125: when others then
1126: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_cols_list_wo_pk_cols',
1127: '(none)','R');
1128: raise;
1129: end get_cols_list_wo_pk_cols;
1130: -- ------------------------- conv_list_to_text ---------------------------

Line 1192: hr_dm_utility.message('ROUT','entry:hr_dm_library.conv_list_to_text', 5);

1188: l_list_index number;
1189: l_count number;
1190:
1191: begin
1192: hr_dm_utility.message('ROUT','entry:hr_dm_library.conv_list_to_text', 5);
1193: hr_dm_utility.message('PARA','(p_rpad_spaces - ' || p_rpad_spaces ||
1194: ')(p_pad_first_line - ' || p_pad_first_line ||
1195: ')(p_prefix_col - ' || p_prefix_col ||
1196: ')(p_col_length - ' || p_col_length ||

Line 1243: hr_dm_utility.message('ROUT','exit:hr_dm_library.conv_list_to_text',

1239: -- 'into formatted text',20);
1240:
1241: hr_dm_utility.message('PARA','(l_out_text - formatted text)' ,30);
1242:
1243: hr_dm_utility.message('ROUT','exit:hr_dm_library.conv_list_to_text',
1244: 25);
1245:
1246: return l_out_text;
1247: exception

Line 1249: hr_dm_utility.error(SQLCODE,'hr_dm_library.conv_list_to_text',

1245:
1246: return l_out_text;
1247: exception
1248: when others then
1249: hr_dm_utility.error(SQLCODE,'hr_dm_library.conv_list_to_text',
1250: '(none)','R');
1251: raise;
1252: end conv_list_to_text ;
1253:

Line 1323: hr_dm_utility.message('ROUT','entry:hr_dm_library.conv_list_to_text', 5);

1319: l_prefix varchar2(30);
1320: l_exc_index number;
1321:
1322: begin
1323: hr_dm_utility.message('ROUT','entry:hr_dm_library.conv_list_to_text', 5);
1324: hr_dm_utility.message('PARA','(p_rpad_spaces - ' || p_rpad_spaces ||
1325: ')(p_pad_first_line - ' || p_pad_first_line ||
1326: ')(p_prefix_col - ' || p_prefix_col ||
1327: ')(p_col_length - ' || p_col_length ||

Line 1405: hr_dm_utility.message('ROUT','exit:hr_dm_library.conv_list_to_text',

1401: -- 'into formatted text',20);
1402:
1403: hr_dm_utility.message('PARA','(l_out_text - formatted text)' ,30);
1404:
1405: hr_dm_utility.message('ROUT','exit:hr_dm_library.conv_list_to_text',
1406: 25);
1407:
1408: return l_out_text;
1409: exception

Line 1411: hr_dm_utility.error(SQLCODE,'hr_dm_library.conv_list_to_text',

1407:
1408: return l_out_text;
1409: exception
1410: when others then
1411: hr_dm_utility.error(SQLCODE,'hr_dm_library.conv_list_to_text',
1412: '(none)','R');
1413: raise;
1414: end conv_list_to_text ;
1415:

Line 1464: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_nvl_arguement', 5);

1460: l_per_owner);
1461:
1462: begin
1463:
1464: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_nvl_arguement', 5);
1465: hr_dm_utility.message('PARA','(p_test_with_nvl - ' || p_test_with_nvl ||
1466: ')(p_table_name - ' || p_table_name ||
1467: ')(p_column_name - ' || p_column_name ||
1468: ')', 10);

Line 1504: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_nvl_arguement', 25);

1500: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - found nvl arguement',20);
1501:
1502: hr_dm_utility.message('PARA','(p_nvl_prefix - ' || p_nvl_prefix || ')' ,30);
1503: hr_dm_utility.message('PARA','(p_nvl_suffix - ' || p_nvl_suffix || ')' ,30);
1504: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_nvl_arguement', 25);
1505:
1506:
1507: exception
1508: when others then

Line 1509: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_nvl_arguement',

1505:
1506:
1507: exception
1508: when others then
1509: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_nvl_arguement',
1510: 'Check seed data in Hierarchies / Tables','R');
1511: raise;
1512:
1513: end get_nvl_arguement;

Line 1612: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_func_asg', 5);

1608: l_nvl_right varchar2(100);
1609: l_nvl_indent varchar2(30);
1610:
1611: begin
1612: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_func_asg', 5);
1613: hr_dm_utility.message('PARA','( p_rpad_spaces - ' || p_rpad_spaces ||
1614: ')(p_prefix_left_asg - ' || p_prefix_left_asg ||
1615: ')( p_prefix_right_asg - ' || p_prefix_right_asg ||
1616: ')(p_omit_business_group_id - ' || p_omit_business_group_id ||

Line 1721: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_func_asg',

1717: -- ' named convention used for parameters ',20);
1718:
1719: hr_dm_utility.message('PARA','(l_out_text - formatted text for funtion ' ||
1720: 'assignment )' ,30);
1721: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_func_asg',
1722: 25);
1723: return l_out_text;
1724: exception
1725: when others then

Line 1726: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_func_asg',

1722: 25);
1723: return l_out_text;
1724: exception
1725: when others then
1726: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_func_asg',
1727: '( p_rpad_spaces - ' || p_rpad_spaces ||
1728: ')(p_prefix_left_asg - ' || p_prefix_left_asg ||
1729: ')( p_prefix_right_asg - ' || p_prefix_right_asg ||
1730: ')(p_omit_business_group_id - ' || p_omit_business_group_id ||

Line 1845: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_func_asg', 5);

1841: l_nvl_right varchar2(100);
1842: l_nvl_indent varchar2(30);
1843:
1844: begin
1845: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_func_asg', 5);
1846: hr_dm_utility.message('PARA','( p_rpad_spaces - ' || p_rpad_spaces ||
1847: ')(p_prefix_left_asg - ' || p_prefix_left_asg ||
1848: ')( p_prefix_right_asg - ' || p_prefix_right_asg ||
1849: ')(p_omit_business_group_id - ' || p_omit_business_group_id ||

Line 1986: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_func_asg',

1982: -- ' named convention used for parameters ',20);
1983:
1984: hr_dm_utility.message('PARA','(l_out_text - formatted text for funtion ' ||
1985: 'assignment )' ,30);
1986: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_func_asg',
1987: 25);
1988: return l_out_text;
1989: exception
1990: when others then

Line 1991: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_func_asg',

1987: 25);
1988: return l_out_text;
1989: exception
1990: when others then
1991: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_func_asg',
1992: '( p_rpad_spaces - ' || p_rpad_spaces ||
1993: ')(p_prefix_left_asg - ' || p_prefix_left_asg ||
1994: ')( p_prefix_right_asg - ' || p_prefix_right_asg ||
1995: ')(p_omit_business_group_id - ' || p_omit_business_group_id ||

Line 2110: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_func_asg_with_dev_key', 5);

2106: l_left_parameter varchar2(100);
2107: l_right_parameter varchar2(100);
2108: l_index number;
2109: begin
2110: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_func_asg_with_dev_key', 5);
2111: hr_dm_utility.message('PARA','( p_rpad_spaces - ' || p_rpad_spaces ||
2112: ')(p_prefix_left_asg - ' || p_prefix_left_asg ||
2113: ')( p_prefix_right_asg - ' || p_prefix_right_asg ||
2114: ')(p_prefix_left_asg_dev_key - ' || p_prefix_left_asg_dev_key ||

Line 2272: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_func_asg_with_dev_key',

2268: 'procedure and named convention used for parameters ',15);
2269:
2270: hr_dm_utility.message('PARA','(l_out_text - out nocopy formatted text for function' ||
2271: 'assignment )' ,30);
2272: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_func_asg_with_dev_key',
2273: 25);
2274: return l_out_text;
2275: exception
2276: when others then

Line 2277: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_func_asg_with_dev_key',

2273: 25);
2274: return l_out_text;
2275: exception
2276: when others then
2277: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_func_asg_with_dev_key',
2278: '( p_rpad_spaces - ' || p_rpad_spaces ||
2279: ')(p_prefix_left_asg - ' || p_prefix_left_asg ||
2280: ')( p_prefix_right_asg - ' || p_prefix_right_asg ||
2281: ')(p_prefix_left_asg_dev_key - ' || p_prefix_left_asg_dev_key ||

Line 2313: hr_dm_utility.message('ROUT','entry:hr_dm_library.ins_resolve_pks ', 5);

2309: ) is
2310: e_fatal_error EXCEPTION;
2311: l_fatal_error_message VARCHAR2(200);
2312: begin
2313: hr_dm_utility.message('ROUT','entry:hr_dm_library.ins_resolve_pks ', 5);
2314: hr_dm_utility.message('PARA','(p_table_name - ' || p_table_name ||
2315: ')(p_source_id - ' || p_source_id ||
2316: ')(p_destination_id - ' || p_destination_id ||
2317: ')', 10);

Line 2369: hr_dm_utility.message('ROUT','exit:hr_dm_library.ins_resolve_pks',

2365: end if;
2366:
2367: hr_dm_utility.message('INFO','HR_DM_LIBARARY - insert row into ' ||
2368: 'hr_dm_resolve_pks table ',15);
2369: hr_dm_utility.message('ROUT','exit:hr_dm_library.ins_resolve_pks',
2370: 25);
2371: exception
2372: when e_fatal_error then
2373: hr_dm_utility.error(SQLCODE,'hr_dm_library.ins_resolve_pks',

Line 2373: hr_dm_utility.error(SQLCODE,'hr_dm_library.ins_resolve_pks',

2369: hr_dm_utility.message('ROUT','exit:hr_dm_library.ins_resolve_pks',
2370: 25);
2371: exception
2372: when e_fatal_error then
2373: hr_dm_utility.error(SQLCODE,'hr_dm_library.ins_resolve_pks',
2374: l_fatal_error_message,'R');
2375: raise;
2376:
2377: when others then

Line 2378: hr_dm_utility.error(SQLCODE,'hr_dm_library.ins_resolve_pks',

2374: l_fatal_error_message,'R');
2375: raise;
2376:
2377: when others then
2378: hr_dm_utility.error(SQLCODE,'hr_dm_library.ins_resolve_pks',
2379: '(none)','R');
2380: raise;
2381: end ins_resolve_pks;
2382:

Line 2414: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_resolved_pk', 5);

2410: where table_name = upper(p_table_name)
2411: and source_id = p_source_id
2412: and source_database_instance = hr_dm_upload.g_data_migrator_source_db;
2413: begin
2414: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_resolved_pk', 5);
2415: hr_dm_utility.message('PARA','(p_source_id - ' || p_source_id ||
2416: ')(p_table_name - ' || p_table_name ||
2417: ')', 10);
2418:

Line 2430: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_resolved_pk',

2426: 'in get_resolved_pk for a given id of a table ',15);
2427:
2428: hr_dm_utility.message('PARA','(p_destination_id - ' || p_destination_id
2429: || ')' ,30);
2430: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_resolved_pk',
2431: 25);
2432: exception
2433: when others then
2434: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_resolved_pk',

Line 2434: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_resolved_pk',

2430: hr_dm_utility.message('ROUT','exit:hr_dm_library.get_resolved_pk',
2431: 25);
2432: exception
2433: when others then
2434: hr_dm_utility.error(SQLCODE,'hr_dm_library.get_resolved_pk',
2435: '(none)','R');
2436: raise;
2437: end get_resolved_pk;
2438: -- ------------------------ ins_dt_delete ---------------------------------

Line 2466: hr_dm_utility.message('ROUT','entry:hr_dm_library.ins_dt_delete ', 5);

2462: p_pk_column_3 in varchar2 default null,
2463: p_pk_column_4 in varchar2 default null
2464: ) is
2465: begin
2466: hr_dm_utility.message('ROUT','entry:hr_dm_library.ins_dt_delete ', 5);
2467: hr_dm_utility.message('PARA','(p_id - ' || p_id ||
2468: ')(p_table_name - ' || p_table_name ||
2469: ')(p_ins_type - ' || p_ins_type ||
2470: ')(p_pk_column_1 - ' || p_pk_column_1 ||

Line 2498: hr_dm_utility.message('ROUT','exit:hr_dm_library.ins_dt_delete',

2494: hr_dm_utility.message('INFO','HR_DM_LIBARARY - insert row into ' ||
2495: 'hr_dm_dt_deletes table ',15);
2496: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - - insert row into ' ||
2497: -- 'hr_dm_dt_deletes table ',20);
2498: hr_dm_utility.message('ROUT','exit:hr_dm_library.ins_dt_delete',
2499: 25);
2500: exception
2501: when others then
2502: hr_dm_utility.error(SQLCODE,'hr_dm_library.ins_dt_delete',

Line 2502: hr_dm_utility.error(SQLCODE,'hr_dm_library.ins_dt_delete',

2498: hr_dm_utility.message('ROUT','exit:hr_dm_library.ins_dt_delete',
2499: 25);
2500: exception
2501: when others then
2502: hr_dm_utility.error(SQLCODE,'hr_dm_library.ins_dt_delete',
2503: '(none)','R');
2504: raise;
2505: end ins_dt_delete;
2506:

Line 2541: hr_dm_utility.message('ROUT','entry:hr_dm_library.chk_row_in_dt_delete', 5);

2537: where id_value = p_id
2538: and table_name = p_table_name
2539: order by data_type;
2540: begin
2541: hr_dm_utility.message('ROUT','entry:hr_dm_library.chk_row_in_dt_delete', 5);
2542: hr_dm_utility.message('PARA','(p_id - ' || p_id ||
2543: ')(p_table_name - ' || p_table_name ||
2544: ')', 10);
2545:

Line 2564: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete',

2560: -- 'in hr_dm_dt_deletes table ',20);
2561:
2562: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type
2563: || ')( p_row_exists - ' ||p_row_exists ,30);
2564: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete',
2565: 25);
2566: exception
2567: when others then
2568: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete',

Line 2568: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete',

2564: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete',
2565: 25);
2566: exception
2567: when others then
2568: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete',
2569: '(none)','R');
2570: raise;
2571: end chk_row_in_dt_delete;
2572:

Line 2608: hr_dm_utility.message('ROUT','entry:hr_dm_library.chk_row_in_dt_delete_1_pkcol', 5);

2604: where pk_column_1 = p_pk_column_1
2605: and table_name = p_table_name
2606: order by data_type;
2607: begin
2608: hr_dm_utility.message('ROUT','entry:hr_dm_library.chk_row_in_dt_delete_1_pkcol', 5);
2609: hr_dm_utility.message('PARA','(p_table_name - ' || p_table_name ||
2610: ')(p_pk_column_1 - ' || p_pk_column_1 ||
2611: ')', 10);
2612:

Line 2631: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_1_pkcol',

2627: -- 'in hr_dm_dt_deletes table ',20);
2628:
2629: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type
2630: || ')( p_row_exists - ' ||p_row_exists ,30);
2631: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_1_pkcol',
2632: 25);
2633: exception
2634: when others then
2635: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_1_pkcol',

Line 2635: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_1_pkcol',

2631: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_1_pkcol',
2632: 25);
2633: exception
2634: when others then
2635: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_1_pkcol',
2636: '(none)','R');
2637: raise;
2638: end chk_row_in_dt_delete_1_pkcol;
2639: -- ------------------------ chk_row_in_dt_delete_2_pkcol ------------------------------

Line 2677: hr_dm_utility.message('ROUT','entry:hr_dm_library.chk_row_in_dt_delete_2_pkcol', 5);

2673: and pk_column_2 = p_pk_column_2
2674: and table_name = p_table_name
2675: order by data_type;
2676: begin
2677: hr_dm_utility.message('ROUT','entry:hr_dm_library.chk_row_in_dt_delete_2_pkcol', 5);
2678: hr_dm_utility.message('PARA','(p_table_name - ' || p_table_name ||
2679: ')(p_pk_column_1 - ' || p_pk_column_1 ||
2680: ')(p_pk_column_2 - ' || p_pk_column_2 ||
2681: ')', 10);

Line 2700: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_2_pkcol',

2696: -- 'in hr_dm_dt_deletes table ',20);
2697:
2698: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type
2699: || ')( p_row_exists - ' ||p_row_exists ,30);
2700: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_2_pkcol',
2701: 25);
2702: exception
2703: when others then
2704: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_2_pkcol',

Line 2704: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_2_pkcol',

2700: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_2_pkcol',
2701: 25);
2702: exception
2703: when others then
2704: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_2_pkcol',
2705: '(none)','R');
2706: raise;
2707: end chk_row_in_dt_delete_2_pkcol;
2708:

Line 2751: hr_dm_utility.message('ROUT','entry:hr_dm_library.chk_row_in_dt_delete_3_pkcol', 5);

2747: and pk_column_3 = p_pk_column_3
2748: and table_name = p_table_name
2749: order by data_type;
2750: begin
2751: hr_dm_utility.message('ROUT','entry:hr_dm_library.chk_row_in_dt_delete_3_pkcol', 5);
2752: hr_dm_utility.message('PARA','(p_table_name - ' || p_table_name ||
2753: ')(p_pk_column_1 - ' || p_pk_column_1 ||
2754: ')(p_pk_column_2 - ' || p_pk_column_2 ||
2755: ')(p_pk_column_3 - ' || p_pk_column_3 ||

Line 2775: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_3_pkcol',

2771: -- 'in hr_dm_dt_deletes table ',20);
2772:
2773: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type
2774: || ')( p_row_exists - ' ||p_row_exists ,30);
2775: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_3_pkcol',
2776: 25);
2777: exception
2778: when others then
2779: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_3_pkcol',

Line 2779: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_3_pkcol',

2775: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_3_pkcol',
2776: 25);
2777: exception
2778: when others then
2779: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_3_pkcol',
2780: '(none)','R');
2781: raise;
2782: end chk_row_in_dt_delete_3_pkcol;
2783:

Line 2828: hr_dm_utility.message('ROUT','entry:hr_dm_library.chk_row_in_dt_delete_4_pkcol', 5);

2824: and pk_column_4 = p_pk_column_4
2825: and table_name = p_table_name
2826: order by data_type;
2827: begin
2828: hr_dm_utility.message('ROUT','entry:hr_dm_library.chk_row_in_dt_delete_4_pkcol', 5);
2829: hr_dm_utility.message('PARA','(p_table_name - ' || p_table_name ||
2830: ')(p_pk_column_1 - ' || p_pk_column_1 ||
2831: ')(p_pk_column_2 - ' || p_pk_column_2 ||
2832: ')(p_pk_column_3 - ' || p_pk_column_3 ||

Line 2853: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_4_pkcol',

2849: -- 'in hr_dm_dt_deletes table ',20);
2850:
2851: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type
2852: || ')( p_row_exists - ' ||p_row_exists ,30);
2853: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_4_pkcol',
2854: 25);
2855: exception
2856: when others then
2857: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_4_pkcol',

Line 2857: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_4_pkcol',

2853: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_4_pkcol',
2854: 25);
2855: exception
2856: when others then
2857: hr_dm_utility.error(SQLCODE,'hr_dm_library.chk_row_in_dt_delete_4_pkcol',
2858: '(none)','R');
2859: raise;
2860: end chk_row_in_dt_delete_4_pkcol;
2861: -- ------------------------ run_sql ---------------------------------------

Line 2873: hr_dm_utility.message('ROUT','entry:hr_dm_library.run_sql', 5);

2869: is
2870: l_csr_sql integer;
2871: l_rows number;
2872: begin
2873: hr_dm_utility.message('ROUT','entry:hr_dm_library.run_sql', 5);
2874: hr_dm_utility.message('PARA','(p_sql - varchar2)', 10);
2875: l_csr_sql := dbms_sql.open_cursor;
2876: dbms_sql.parse( l_csr_sql, p_sql, dbms_sql.native );
2877: l_rows := dbms_sql.execute( l_csr_sql );

Line 2881: hr_dm_utility.message('ROUT','exit:hr_dm_library.run_sql',

2877: l_rows := dbms_sql.execute( l_csr_sql );
2878: dbms_sql.close_cursor( l_csr_sql );
2879: hr_dm_utility.message('INFO','HR_DM_LIBARARY - run SQL command - 1',15);
2880: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - run SQL command - 1',20);
2881: hr_dm_utility.message('ROUT','exit:hr_dm_library.run_sql',
2882: 25);
2883: exception
2884: when others then
2885: hr_dm_utility.error(SQLCODE,'hr_dm_library.run_sql',

Line 2885: hr_dm_utility.error(SQLCODE,'hr_dm_library.run_sql',

2881: hr_dm_utility.message('ROUT','exit:hr_dm_library.run_sql',
2882: 25);
2883: exception
2884: when others then
2885: hr_dm_utility.error(SQLCODE,'hr_dm_library.run_sql',
2886: '(none)','R');
2887: raise;
2888: end run_sql;
2889: -- ------------------------ run_sql ---------------------------------------

Line 2903: hr_dm_utility.message('ROUT','entry:hr_dm_library.run_sql', 5);

2899: l_csr_sql integer;
2900: l_rows number;
2901:
2902: begin
2903: hr_dm_utility.message('ROUT','entry:hr_dm_library.run_sql', 5);
2904: hr_dm_utility.message('PARA','(p_package_index - ' || p_package_index ||
2905: ')' || '(p_package_index - dbms_sql.varchar2s)'
2906: , 10);
2907: l_csr_sql := dbms_sql.open_cursor;

Line 2913: hr_dm_utility.message('ROUT','exit:hr_dm_library.run_sql',

2909: l_rows := dbms_sql.execute( l_csr_sql );
2910: dbms_sql.close_cursor( l_csr_sql );
2911: hr_dm_utility.message('INFO','HR_DM_LIBARARY - run SQL command - 2',15);
2912: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - run SQL command - 2',20);
2913: hr_dm_utility.message('ROUT','exit:hr_dm_library.run_sql',
2914: 25);
2915: exception
2916: when others then
2917: hr_dm_utility.error(SQLCODE,'hr_dm_library.run_sql - dbms_sql.varchar2s',

Line 2917: hr_dm_utility.error(SQLCODE,'hr_dm_library.run_sql - dbms_sql.varchar2s',

2913: hr_dm_utility.message('ROUT','exit:hr_dm_library.run_sql',
2914: 25);
2915: exception
2916: when others then
2917: hr_dm_utility.error(SQLCODE,'hr_dm_library.run_sql - dbms_sql.varchar2s',
2918: '(none)','R');
2919: raise;
2920: end run_sql;
2921:

Line 2944: hr_dm_utility.message('ROUT','entry:hr_dm_library.check_compile', 5);

2940: where upper(object_name) = upper(p_object_name)
2941: and upper(object_type) = upper(p_object_type);
2942: l_status varchar2(64);
2943: begin
2944: hr_dm_utility.message('ROUT','entry:hr_dm_library.check_compile', 5);
2945: hr_dm_utility.message('PARA','(p_object_name - ' || p_object_name ||
2946: ')(p_object_type - ' || p_object_type ||
2947: ')', 10);
2948:

Line 2959: hr_dm_utility.message('ROUT','exit:hr_dm_library.check_compile',

2955: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check status of the package ' ||
2956: 'in hr_dm_dt_deletes table ',15);
2957: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check status of the package ' ||
2958: -- 'in hr_dm_dt_deletes table ',20);
2959: hr_dm_utility.message('ROUT','exit:hr_dm_library.check_compile',
2960: 25);
2961:
2962: exception
2963: when e_invalid_package then

Line 2964: hr_dm_utility.error(SQLCODE,'hr_dm_library.check_compile',

2960: 25);
2961:
2962: exception
2963: when e_invalid_package then
2964: hr_dm_utility.error(SQLCODE,'hr_dm_library.check_compile',
2965: 'Invalid Status For Package ' || p_object_name ,'R');
2966: raise;
2967: when others then
2968: hr_dm_utility.error(SQLCODE,'hr_dm_library.check_compile',

Line 2968: hr_dm_utility.error(SQLCODE,'hr_dm_library.check_compile',

2964: hr_dm_utility.error(SQLCODE,'hr_dm_library.check_compile',
2965: 'Invalid Status For Package ' || p_object_name ,'R');
2966: raise;
2967: when others then
2968: hr_dm_utility.error(SQLCODE,'hr_dm_library.check_compile',
2969: '(none)','R');
2970: raise;
2971: end check_compile;
2972:

Line 3068: hr_dm_utility.message('ROUT','entry:hr_dm_library.create_view', 5);

3064: --
3065: begin
3066: --
3067:
3068: hr_dm_utility.message('ROUT','entry:hr_dm_library.create_view', 5);
3069: hr_dm_utility.message('PARA','(p_table_info - record)', 10);
3070:
3071: open csr_apps_name;
3072: fetch csr_apps_name into l_apps_name;

Line 3142: hr_dm_library.get_table_info (cst_get_table_rec.parent_table_id,

3138: if p_table_info.table_name <> 'hr_dmvs_hr_locations_all' then
3139: if p_table_info.table_hierarchy = 'Y' then
3140: for cst_get_table_rec in csr_get_table loop
3141: -- get the parent table name
3142: hr_dm_library.get_table_info (cst_get_table_rec.parent_table_id,
3143: l_parent_table_info);
3144: l_cursor_select_from := l_cursor_select_from || ' ' || ',' ||
3145: l_parent_table_info.table_name ||' ' || l_parent_table_info.alias || l_cr;
3146: end loop;

Line 3190: hr_dm_utility.message('ROUT','exit:hr_dm_library.create_view', 25);

3186: hr_dm_utility.message('INFO','View created - ' ||
3187: upper(p_table_info.table_name), 15);
3188: hr_dm_utility.message('SUMM','View created - ' ||
3189: upper(p_table_info.table_name), 20);
3190: hr_dm_utility.message('ROUT','exit:hr_dm_library.create_view', 25);
3191: hr_dm_utility.message('PARA','(none)', 30);
3192:
3193: -- error handling
3194: exception

Line 3196: hr_dm_utility.error(sqlcode,'hr_dm_library.create_view','(none)','R');

3192:
3193: -- error handling
3194: exception
3195: when others then
3196: hr_dm_utility.error(sqlcode,'hr_dm_library.create_view','(none)','R');
3197: raise;
3198:
3199: --
3200: end create_view;

Line 3250: hr_dm_utility.message('ROUT','entry:hr_dm_library.seed_view_who', 5);

3246: --
3247: begin
3248: --
3249:
3250: hr_dm_utility.message('ROUT','entry:hr_dm_library.seed_view_who', 5);
3251:
3252:
3253: open csr_table;
3254: loop

Line 3339: hr_dm_utility.message('ROUT','exit:hr_dm_library.seed_view_who', 25);

3335: commit;
3336:
3337: hr_dm_utility.message('INFO','Created seed AOL hierarchy info', 15);
3338: hr_dm_utility.message('SUMM','Created seed AOL hierarchy info', 20);
3339: hr_dm_utility.message('ROUT','exit:hr_dm_library.seed_view_who', 25);
3340: hr_dm_utility.message('PARA','(none)', 30);
3341:
3342: -- error handling
3343: exception

Line 3345: hr_dm_utility.error(sqlcode,'hr_dm_library.seed_view_who',

3341:
3342: -- error handling
3343: exception
3344: when others then
3345: hr_dm_utility.error(sqlcode,'hr_dm_library.seed_view_who',
3346: 'error seed AOL hierarchy info','r');
3347: raise;
3348:
3349: --

Line 3401: hr_dm_utility.message('ROUT','entry:hr_dm_library.seed_view_null', 5);

3397: --
3398: begin
3399: --
3400:
3401: hr_dm_utility.message('ROUT','entry:hr_dm_library.seed_view_null', 5);
3402:
3403:
3404: open csr_table;
3405: loop

Line 3471: hr_dm_utility.message('ROUT','exit:hr_dm_library.seed_view_null', 25);

3467: commit;
3468:
3469: hr_dm_utility.message('INFO','Created seed null hierarchy info', 15);
3470: hr_dm_utility.message('SUMM','Created seed null hierarchy info', 20);
3471: hr_dm_utility.message('ROUT','exit:hr_dm_library.seed_view_null', 25);
3472: hr_dm_utility.message('PARA','(none)', 30);
3473:
3474: -- error handling
3475: exception

Line 3477: hr_dm_utility.error(sqlcode,'hr_dm_library.seed_view_null',

3473:
3474: -- error handling
3475: exception
3476: when others then
3477: hr_dm_utility.error(sqlcode,'hr_dm_library.seed_view_null',
3478: 'error seed null hierarchy info','r');
3479: raise;
3480:
3481: --

Line 3588: hr_dm_utility.message('ROUT','entry:hr_dm_library.create_stub_views', 5);

3584: --
3585: begin
3586: --
3587:
3588: hr_dm_utility.message('ROUT','entry:hr_dm_library.create_stub_views', 5);
3589: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id || ')',
3590: 10);
3591:
3592: open csr_apps_name;

Line 3685: hr_dm_utility.message('ROUT','exit:hr_dm_library.create_stub_views', 25);

3681: seed_view_null;
3682:
3683: hr_dm_utility.message('INFO','Created stub views', 15);
3684: hr_dm_utility.message('SUMM','Created stub views', 20);
3685: hr_dm_utility.message('ROUT','exit:hr_dm_library.create_stub_views', 25);
3686: hr_dm_utility.message('PARA','(none)', 30);
3687:
3688: -- error handling
3689: exception

Line 3691: hr_dm_utility.error(sqlcode,'hr_dm_library.create_stub_views',

3687:
3688: -- error handling
3689: exception
3690: when others then
3691: hr_dm_utility.error(sqlcode,'hr_dm_library.create_stub_views',
3692: 'error creating stub views','r');
3693: raise;
3694:
3695: --

Line 3702: end hr_dm_library;

3698:
3699:
3700:
3701:
3702: end hr_dm_library;