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_DU_DP_PC_CONVERSION dependencies on HR_DU_DP_PC_CONVERSION

Line 1: PACKAGE BODY hr_du_dp_pc_conversion AS

1: PACKAGE BODY hr_du_dp_pc_conversion AS
2: /* $Header: perdupc.pkb 115.21 2002/11/28 16:53:55 apholt noship $ */
3:
4:
5: /*--------------------------- GLOBAL VARIABLES ----------------------------*/

Line 36: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.

32: WHERE api_module_id = p_api_module_id;
33:
34: BEGIN
35: --
36: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.
37: store_column_mappings', 5);
38: hr_du_utility.message('PARA', '(p_api_module_id - ' || p_api_module_id ||
39: ')' , 10);
40:

Line 61: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion. ' ||

57: --
58: CLOSE csr_mapped_to_name;
59:
60: --
61: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion. ' ||
62: 'store_column_mappings', 15);
63: --
64: EXCEPTION
65: WHEN OTHERS THEN

Line 66: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.

62: 'store_column_mappings', 15);
63: --
64: EXCEPTION
65: WHEN OTHERS THEN
66: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.
67: store_column_mappings', '(none)', 'R');
68: RAISE;
69: --
70: END STORE_COLUMN_MAPPINGS;

Line 86: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.

82: IS
83:
84: BEGIN
85: --
86: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.
87: store_column_headings', 5);
88: hr_du_utility.message('PARA', '(p_line_id - ' || p_line_id || ')'
89: , 10);
90:

Line 217: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion.' ||

213:
214: hr_du_utility.message('INFO','Select Statement Ends ' , 20);
215:
216: --
217: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion.' ||
218: ' store_column_headings', 25);
219: --
220: EXCEPTION
221: WHEN OTHERS THEN

Line 222: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.

218: ' store_column_headings', 25);
219: --
220: EXCEPTION
221: WHEN OTHERS THEN
222: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.
223: store_column_headings',
224: '(none)', 'R');
225: RAISE;
226: --

Line 273: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.

269:
270:
271: BEGIN
272: --
273: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.
274: verify_api_attached', 5);
275: hr_du_utility.message('PARA', '(p_mapped_name - ' || p_mapped_name ||
276: ')(p_api_module_id - ' || p_api_module_id ||
277: ')(p_upload_header_id - ' || p_upload_header_id ||')'

Line 304: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion.' ||

300: --
301: CLOSE csr_api_file;
302:
303: --
304: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion.' ||
305: ' verify_api_attached', 15);
306: --
307: EXCEPTION
308: WHEN e_fatal_error THEN

Line 309: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.verify_api_attached'

305: ' verify_api_attached', 15);
306: --
307: EXCEPTION
308: WHEN e_fatal_error THEN
309: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.verify_api_attached'
310: ,l_fatal_error_message, 'R');
311: RAISE;
312: WHEN OTHERS THEN
313: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.verify_api_attached',

Line 313: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.verify_api_attached',

309: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.verify_api_attached'
310: ,l_fatal_error_message, 'R');
311: RAISE;
312: WHEN OTHERS THEN
313: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.verify_api_attached',
314: '(none)', 'R');
315: RAISE;
316: --
317: END VERIFY_API_ATTACHED;

Line 344: -- 'entry:hr_du_dp_pc_conversion.remove_spaces', 5);

340:
341: BEGIN
342:
343: --hr_du_utility.message('ROUT',
344: -- 'entry:hr_du_dp_pc_conversion.remove_spaces', 5);
345: --hr_du_utility.message('PARA',
346: -- '(p_word - ' || p_word || ')' , 10);
347:
348: p_spaces := FALSE;

Line 399: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.remove_spaces',

395:
396: --
397: EXCEPTION
398: WHEN OTHERS THEN
399: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.remove_spaces',
400: '(none)', 'R');
401: RAISE;
402: --
403: END REMOVE_SPACES;

Line 457: 'entry:hr_du_dp_pc_conversion.cp_referencing_columns',

453:
454: BEGIN
455: --
456: hr_du_utility.message('ROUT',
457: 'entry:hr_du_dp_pc_conversion.cp_referencing_columns',
458: 5);
459: hr_du_utility.message('PARA', '(p_array_pos - ' || p_array_pos || ')'
460: , 10);
461: --

Line 537: 'exit:hr_du_dp_pc_conversion.cp_referencing_columns', 45);

533: hr_du_utility.message('INFO', 'l_generic_pval : ' || l_generic_pval , 40);
534:
535: --
536: hr_du_utility.message('ROUT',
537: 'exit:hr_du_dp_pc_conversion.cp_referencing_columns', 45);
538: --
539: EXCEPTION
540: WHEN OTHERS THEN
541: hr_du_utility.error(SQLCODE,

Line 542: 'hr_du_dp_pc_conversion.cp_referencing_columns', '(none)', 'R');

538: --
539: EXCEPTION
540: WHEN OTHERS THEN
541: hr_du_utility.error(SQLCODE,
542: 'hr_du_dp_pc_conversion.cp_referencing_columns', '(none)', 'R');
543: RAISE;
544: --
545: END CP_REFERENCING_COLUMNS;
546:

Line 567: 'entry:hr_du_dp_pc_conversion.API_MODULE_id_to_table_id', 5);

563:
564: BEGIN
565: --
566: hr_du_utility.message('ROUT',
567: 'entry:hr_du_dp_pc_conversion.API_MODULE_id_to_table_id', 5);
568: --
569:
570:
571: --find out the size of the PL/SQL table

Line 622: 'exit:hr_du_dp_pc_conversion.

618: END LOOP;
619:
620: --
621: hr_du_utility.message('ROUT',
622: 'exit:hr_du_dp_pc_conversion.
623: API_MODULE_id_to_table_id', 25);
624: --
625: EXCEPTION
626: WHEN OTHERS THEN

Line 628: 'hr_du_dp_pc_conversion.API_MODULE_id_to_table_id', '(none)', 'R');

624: --
625: EXCEPTION
626: WHEN OTHERS THEN
627: hr_du_utility.error(SQLCODE,
628: 'hr_du_dp_pc_conversion.API_MODULE_id_to_table_id', '(none)', 'R');
629: RAISE;
630: --
631: END API_MODULE_ID_TO_TABLE_ID;
632:

Line 670: 'entry:hr_du_dp_pc_conversion.return_parent_api_module_id', 5);

666:
667: BEGIN
668: --
669: hr_du_utility.message('ROUT',
670: 'entry:hr_du_dp_pc_conversion.return_parent_api_module_id', 5);
671: hr_du_utility.message('PARA', '(p_api_module_id - ' || p_api_module_id ||
672: ')(p_reference_string - ' || p_reference_string || ')' , 10);
673: --
674: OPEN csr_parent_id;

Line 689: 'exit:hr_du_dp_pc_conversion.return_parent_api_module_id', 15);

685: CLOSE csr_parent_id;
686:
687: --
688: hr_du_utility.message('ROUT',
689: 'exit:hr_du_dp_pc_conversion.return_parent_api_module_id', 15);
690: hr_du_utility.message('PARA', '(l_parent_api_module_id - ' ||
691: l_parent_api_module_id || ')' , 20);
692: --
693: RETURN l_parent_api_module_id;

Line 698: 'hr_du_dp_pc_conversion.return_parent_api_module_id',

694:
695: EXCEPTION
696: WHEN e_fatal_error THEN
697: hr_du_utility.error(SQLCODE,
698: 'hr_du_dp_pc_conversion.return_parent_api_module_id',
699: l_fatal_error_message, 'R');
700: RAISE;
701: WHEN OTHERS THEN
702: hr_du_utility.error(SQLCODE,

Line 703: 'hr_du_dp_pc_conversion.return_parent_api_module_id', '(none)', 'R');

699: l_fatal_error_message, 'R');
700: RAISE;
701: WHEN OTHERS THEN
702: hr_du_utility.error(SQLCODE,
703: 'hr_du_dp_pc_conversion.return_parent_api_module_id', '(none)', 'R');
704: RAISE;
705: --
706: END RETURN_PARENT_API_MODULE_ID;
707:

Line 743: 'entry:hr_du_dp_pc_conversion.return_field_value', 5);

739:
740: BEGIN
741: --
742: hr_du_utility.message('ROUT',
743: 'entry:hr_du_dp_pc_conversion.return_field_value', 5);
744: hr_du_utility.message('PARA', '(p_table - ' || p_table ||
745: ')(p_record_id - ' || p_record_id ||
746: ')(p_field_pk - ' || p_field_pk ||
747: ')(p_field_name - ' || p_field_name || ')'

Line 760: 'exit:hr_du_dp_pc_conversion.return_field_value', 20);

756: hr_du_utility.dynamic_sql_str(l_dyn_sql, l_field_value, 2000);
757:
758: --
759: hr_du_utility.message('ROUT',
760: 'exit:hr_du_dp_pc_conversion.return_field_value', 20);
761: hr_du_utility.message('PARA', '(l_field_value - ' || l_field_value || ')',
762: 25);
763: --
764:

Line 769: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.return_field_value',

765: RETURN l_field_value;
766:
767: EXCEPTION
768: WHEN OTHERS THEN
769: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.return_field_value',
770: '(none)', 'R');
771: RAISE;
772: --
773: END RETURN_FIELD_VALUE;

Line 810: 'entry:hr_du_dp_pc_conversion.max_id_value', 5);

806:
807: BEGIN
808: --
809: hr_du_utility.message('ROUT',
810: 'entry:hr_du_dp_pc_conversion.max_id_value', 5);
811: hr_du_utility.message('PARA', '(p_upload_line_id - ' || p_upload_line_id ||
812: ')' ,10);
813: --
814:

Line 828: 'exit:hr_du_dp_pc_conversion.max_id_value', 20);

824: CLOSE csr_max_id;
825:
826: --
827: hr_du_utility.message('ROUT',
828: 'exit:hr_du_dp_pc_conversion.max_id_value', 20);
829: hr_du_utility.message('PARA', '(l_max_number - ' || l_max_number || ')'
830: , 25);
831: --
832:

Line 838: 'hr_du_dp_pc_conversion.max_id_value',

834:
835: EXCEPTION
836: WHEN e_fatal_error THEN
837: hr_du_utility.error(SQLCODE,
838: 'hr_du_dp_pc_conversion.max_id_value',
839: l_fatal_error_message, 'R');
840: RAISE;
841: WHEN OTHERS THEN
842: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.max_id_value',

Line 842: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.max_id_value',

838: 'hr_du_dp_pc_conversion.max_id_value',
839: l_fatal_error_message, 'R');
840: RAISE;
841: WHEN OTHERS THEN
842: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.max_id_value',
843: '(none)', 'R');
844: RAISE;
845: --
846: END MAX_ID_VALUE;

Line 886: 'entry:hr_du_dp_pc_conversion.general_referencing_column', 5);

882:
883: BEGIN
884: --
885: hr_du_utility.message('ROUT',
886: 'entry:hr_du_dp_pc_conversion.general_referencing_column', 5);
887: hr_du_utility.message('PARA', '(p_pval_field- ' || p_pval_field ||
888: ')(p_api_module_id - ' || p_api_module_id ||
889: ')(p_mapping_type - ' || p_mapping_type || ')'
890: , 10);

Line 902: 'exit:hr_du_dp_pc_conversion.general_referencing_column', 15);

898: --
899: CLOSE csr_ref_col;
900: --
901: hr_du_utility.message('ROUT',
902: 'exit:hr_du_dp_pc_conversion.general_referencing_column', 15);
903: hr_du_utility.message('PARA', '(l_mapped_name - ' || l_mapped_name || ')'
904: , 20);
905: --
906:

Line 912: 'hr_du_dp_pc_conversion.general_referencing_column','(none)', 'R');

908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: hr_du_utility.error(SQLCODE,
912: 'hr_du_dp_pc_conversion.general_referencing_column','(none)', 'R');
913: RAISE;
914: --
915: END GENERAL_REFERENCING_COLUMN;
916:

Line 957: 'hr_du_dp_pc_conversion.general_referencing_column_2','(none)', 'R');

953:
954: EXCEPTION
955: WHEN OTHERS THEN
956: hr_du_utility.error(SQLCODE,
957: 'hr_du_dp_pc_conversion.general_referencing_column_2','(none)', 'R');
958: RAISE;
959: --
960: END GENERAL_REFERENCING_COLUMN_2;
961:

Line 1018: 'entry:hr_du_dp_pc_conversion.insert_api_module_ids', 5);

1014:
1015: BEGIN
1016: --
1017: hr_du_utility.message('ROUT',
1018: 'entry:hr_du_dp_pc_conversion.insert_api_module_ids', 5);
1019: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1020: --
1021:
1022: --sets the delimiter through out the whole package to be a comma

Line 1052: 'exit:hr_du_dp_pc_conversion.insert_api_module_ids', 15);

1048: END IF;
1049:
1050: --
1051: hr_du_utility.message('ROUT',
1052: 'exit:hr_du_dp_pc_conversion.insert_api_module_ids', 15);
1053: --
1054:
1055: EXCEPTION
1056: WHEN e_fatal_error THEN

Line 1057: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.insert_api_module_ids'

1053: --
1054:
1055: EXCEPTION
1056: WHEN e_fatal_error THEN
1057: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.insert_api_module_ids'
1058: ,l_fatal_error_message, 'R');
1059: RAISE;
1060: WHEN OTHERS THEN
1061: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.insert_api_module_ids'

Line 1061: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.insert_api_module_ids'

1057: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.insert_api_module_ids'
1058: ,l_fatal_error_message, 'R');
1059: RAISE;
1060: WHEN OTHERS THEN
1061: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.insert_api_module_ids'
1062: ,'(none)', 'R');
1063: RAISE;
1064: --
1065: END INSERT_API_MODULE_IDS;

Line 1135: 'entry:hr_du_dp_pc_conversion.create_insert_string', 5);

1131:
1132: BEGIN
1133: --
1134: hr_du_utility.message('ROUT',
1135: 'entry:hr_du_dp_pc_conversion.create_insert_string', 5);
1136: hr_du_utility.message('PARA', '(p_api_module_id - ' || p_api_module_id ||
1137: ')(p_upload_header_id - ' || p_upload_header_id ||
1138: ')(p_array_pos - ' || p_array_pos || ')' ,
1139: 10);

Line 1281: 'exit:hr_du_dp_pc_conversion.create_insert_string', 50);

1277: WHERE upload_line_id = l_line_id;
1278:
1279: --
1280: hr_du_utility.message('ROUT',
1281: 'exit:hr_du_dp_pc_conversion.create_insert_string', 50);
1282: --
1283:
1284: EXCEPTION
1285: WHEN e_fatal_error THEN

Line 1286: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.create_insert_string'

1282: --
1283:
1284: EXCEPTION
1285: WHEN e_fatal_error THEN
1286: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.create_insert_string'
1287: ,l_fatal_error_message, 'R');
1288: RAISE;
1289: WHEN OTHERS THEN
1290: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.create_insert_string'

Line 1290: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.create_insert_string'

1286: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.create_insert_string'
1287: ,l_fatal_error_message, 'R');
1288: RAISE;
1289: WHEN OTHERS THEN
1290: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.create_insert_string'
1291: ,'(none)', 'R');
1292: RAISE;
1293: --
1294: END CREATE_INSERT_STRING;

Line 1353: 'entry:hr_du_dp_pc_conversion.switch_referencing_initial', 5);

1349:
1350: BEGIN
1351: --
1352: hr_du_utility.message('ROUT',
1353: 'entry:hr_du_dp_pc_conversion.switch_referencing_initial', 5);
1354: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1355: --
1356:
1357: --call the procedure to convert all api_module id's held within

Line 1503: 'exit:hr_du_dp_pc_conversion.switch_referencing_initial', 15);

1499: END LOOP;
1500:
1501: --
1502: hr_du_utility.message('ROUT',
1503: 'exit:hr_du_dp_pc_conversion.switch_referencing_initial', 15);
1504: --
1505:
1506: EXCEPTION
1507: WHEN e_fatal_error THEN

Line 1509: 'hr_du_dp_pc_conversion.switch_referencing_initial'

1505:
1506: EXCEPTION
1507: WHEN e_fatal_error THEN
1508: hr_du_utility.error(SQLCODE,
1509: 'hr_du_dp_pc_conversion.switch_referencing_initial'
1510: ,l_fatal_error_message, 'R');
1511: RAISE;
1512: WHEN OTHERS THEN
1513: hr_du_utility.error(SQLCODE,

Line 1514: 'hr_du_dp_pc_conversion.switch_referencing_initial','(none)', 'R');

1510: ,l_fatal_error_message, 'R');
1511: RAISE;
1512: WHEN OTHERS THEN
1513: hr_du_utility.error(SQLCODE,
1514: 'hr_du_dp_pc_conversion.switch_referencing_initial','(none)', 'R');
1515: RAISE;
1516: --
1517: END SWITCH_REFERENCING_INITIAL;
1518:

Line 1584: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.process_line',

1580:
1581:
1582: BEGIN
1583: --
1584: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.process_line',
1585: 5);
1586: hr_du_utility.message('PARA', '(p_prev_upload_line_id - ' ||
1587: p_prev_upload_line_id ||
1588: ')(p_prev_table_number - ' || p_prev_table_number ||

Line 1883: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion.process_line', 60);

1879:
1880: COMMIT;
1881:
1882: --
1883: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion.process_line', 60);
1884: --
1885:
1886: --
1887: EXCEPTION

Line 1889: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.process_line'

1885:
1886: --
1887: EXCEPTION
1888: WHEN e_fatal_error THEN
1889: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.process_line'
1890: ,l_fatal_error_message, 'R');
1891: RAISE;
1892: WHEN OTHERS THEN
1893: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.process_line',

Line 1893: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.process_line',

1889: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.process_line'
1890: ,l_fatal_error_message, 'R');
1891: RAISE;
1892: WHEN OTHERS THEN
1893: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.process_line',
1894: '(none)', 'R');
1895: RAISE;
1896: --
1897: END PROCESS_LINE;

Line 1918: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.validate', 5);

1914: l_source_reference_type VARCHAR2(30);
1915:
1916: BEGIN
1917: --
1918: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.validate', 5);
1919: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1920: --
1921:
1922: l_source_reference_type := NULL;

Line 1925: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion.validate', 15);

1921:
1922: l_source_reference_type := NULL;
1923:
1924: --
1925: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion.validate', 15);
1926: --
1927:
1928: --
1929: EXCEPTION

Line 1931: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.validate'

1927:
1928: --
1929: EXCEPTION
1930: WHEN e_fatal_error THEN
1931: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.validate'
1932: ,l_fatal_error_message, 'R');
1933: RAISE;
1934: WHEN OTHERS THEN
1935: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.validate',

Line 1935: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.validate',

1931: hr_du_utility.error(SQLCODE,'hr_du_dp_pc_conversion.validate'
1932: ,l_fatal_error_message, 'R');
1933: RAISE;
1934: WHEN OTHERS THEN
1935: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.validate',
1936: '(none)', 'R');
1937: RAISE;
1938: --
1939: END VALIDATE;

Line 1957: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.rollback', 5);

1953:
1954:
1955: BEGIN
1956: --
1957: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.rollback', 5);
1958: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1959: --
1960:
1961:

Line 1982: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion.rollback', 15);

1978: AND status <> 'NS';
1979: COMMIT;
1980:
1981: --
1982: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion.rollback', 15);
1983: --
1984:
1985: --
1986: EXCEPTION

Line 1988: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.rollback',

1984:
1985: --
1986: EXCEPTION
1987: WHEN OTHERS THEN
1988: hr_du_utility.error(SQLCODE, 'hr_du_dp_pc_conversion.rollback',
1989: '(none)', 'R');
1990: RAISE;
1991: --
1992: END ROLLBACK;

Line 1994: END HR_DU_DP_PC_CONVERSION;

1990: RAISE;
1991: --
1992: END ROLLBACK;
1993:
1994: END HR_DU_DP_PC_CONVERSION;