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_DO_DATAPUMP dependencies on HR_DU_DO_DATAPUMP

Line 1: PACKAGE BODY HR_DU_DO_DATAPUMP AS

1: PACKAGE BODY HR_DU_DO_DATAPUMP AS
2: /* $Header: perdudp.pkb 115.29 2002/11/28 15:25:47 apholt noship $ */
3:
4: -- ------------------------- STORE_COLUMN_HEADINGS ------------------------
5: -- Description: This procedure extracts the column headings for the given

Line 17: hr_du_utility.message('ROUT','entry:hr_du_do_datapump.

13: IS
14:
15: BEGIN
16: --
17: hr_du_utility.message('ROUT','entry:hr_du_do_datapump.
18: store_column_headings', 5);
19: hr_du_utility.message('PARA', '(p_line_id - ' || p_line_id || ')'
20: , 10);
21:

Line 148: hr_du_utility.message('ROUT','exit:hr_du_do_datapump.' ||

144:
145: hr_du_utility.message('INFO','Select Statement Ends ' , 20);
146:
147: --
148: hr_du_utility.message('ROUT','exit:hr_du_do_datapump.' ||
149: ' store_column_headings', 25);
150: --
151: EXCEPTION
152: WHEN OTHERS THEN

Line 153: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.

149: ' store_column_headings', 25);
150: --
151: EXCEPTION
152: WHEN OTHERS THEN
153: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.
154: store_column_headings',
155: '(none)', 'R');
156: RAISE;
157: --

Line 186: 'entry:hr_du_do_datapump.find_user_key_from_mappings', 5);

182:
183: BEGIN
184: --
185: hr_du_utility.message('ROUT',
186: 'entry:hr_du_do_datapump.find_user_key_from_mappings', 5);
187: hr_du_utility.message('PARA', '(p_api_module_id - ' ||
188: p_api_module_id || ')' , 10);
189: --
190:

Line 203: 'exit:hr_du_do_datapump.find_user_key_from_mappings', 15);

199: CLOSE csr_user_key;
200:
201: --
202: hr_du_utility.message('ROUT',
203: 'exit:hr_du_do_datapump.find_user_key_from_mappings', 15);
204: hr_du_utility.message('PARA', '(l_user_key - ' || l_user_key || ')' , 20);
205: --
206:
207: RETURN l_user_key;

Line 211: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.

207: RETURN l_user_key;
208:
209: EXCEPTION
210: WHEN e_fatal_error THEN
211: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.
212: find_user_key_from_mappings',l_fatal_error_message, 'R');
213: RAISE;
214: WHEN OTHERS THEN
215: hr_du_utility.error(SQLCODE,

Line 216: 'hr_du_do_datapump.find_user_key_from_mappings','(none)', 'R');

212: find_user_key_from_mappings',l_fatal_error_message, 'R');
213: RAISE;
214: WHEN OTHERS THEN
215: hr_du_utility.error(SQLCODE,
216: 'hr_du_do_datapump.find_user_key_from_mappings','(none)', 'R');
217: RAISE;
218: --
219: END FIND_USER_KEY_FROM_MAPPINGS;
220:

Line 254: 'entry:hr_du_do_datapump.api_id_to_process_order', 5);

250:
251: BEGIN
252: --
253: hr_du_utility.message('ROUT',
254: 'entry:hr_du_do_datapump.api_id_to_process_order', 5);
255: hr_du_utility.message('PARA', '(p_api_module_id - ' || p_api_module_id ||
256: ')(p_upload_id - ' || p_upload_id || ')'
257: , 10);
258: --

Line 272: 'exit:hr_du_do_datapump.api_id_to_process_order', 15);

268: CLOSE csr_process_order;
269:
270: --
271: hr_du_utility.message('ROUT',
272: 'exit:hr_du_do_datapump.api_id_to_process_order', 15);
273: hr_du_utility.message('PARA', '(l_process_order - ' || l_process_order
274: || ')' , 20);
275: --
276:

Line 281: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.api_id_to_process_order'

277: RETURN l_process_order;
278:
279: EXCEPTION
280: WHEN e_fatal_error THEN
281: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.api_id_to_process_order'
282: ,l_fatal_error_message, 'R');
283: RAISE;
284: WHEN OTHERS THEN
285: hr_du_utility.error(SQLCODE,

Line 286: 'hr_du_do_datapump.api_id_to_process_order','(none)', 'R');

282: ,l_fatal_error_message, 'R');
283: RAISE;
284: WHEN OTHERS THEN
285: hr_du_utility.error(SQLCODE,
286: 'hr_du_do_datapump.api_id_to_process_order','(none)', 'R');
287: RAISE;
288: --
289: END API_ID_TO_PROCESS_ORDER;
290:

Line 334: 'entry:hr_du_do_datapump.any_extra_references', 5);

330:
331: BEGIN
332: --
333: hr_du_utility.message('ROUT',
334: 'entry:hr_du_do_datapump.any_extra_references', 5);
335: hr_du_utility.message('PARA', '(p_user_key - ' || p_user_key ||
336: ')(p_api_module_id - ' || p_api_module_id ||
337: ')(p_number_of_keys - ' || p_number_of_keys || ')'
338: , 10);

Line 362: 'exit:hr_du_do_datapump.any_extra_references', 15);

358: END IF;
359:
360: --
361: hr_du_utility.message('ROUT',
362: 'exit:hr_du_do_datapump.any_extra_references', 15);
363: hr_du_utility.message('PARA', '(l_extra_user_keys - ' || l_extra_user_keys
364: || ')' , 20);
365: --
366:

Line 372: 'hr_du_do_datapump.any_extra_references','(none)', 'R');

368:
369: EXCEPTION
370: WHEN OTHERS THEN
371: hr_du_utility.error(SQLCODE,
372: 'hr_du_do_datapump.any_extra_references','(none)', 'R');
373: RAISE;
374: --
375: END ANY_EXTRA_REFERENCES;
376:

Line 439: 'hr_du_do_datapump.general_referencing_column','(none)', 'R');

435:
436: EXCEPTION
437: WHEN OTHERS THEN
438: hr_du_utility.error(SQLCODE,
439: 'hr_du_do_datapump.general_referencing_column','(none)', 'R');
440: RAISE;
441: --
442: END GENERAL_REFERENCING_COLUMN;
443:

Line 459: 'entry:hr_du_do_datapump.set_status', 5);

455: BEGIN
456:
457: --
458: hr_du_utility.message('ROUT',
459: 'entry:hr_du_do_datapump.set_status', 5);
460: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')', 10);
461: --
462:
463: UPDATE hr_du_upload_lines

Line 473: 'exit:hr_du_do_datapump.set_status', 15);

469: COMMIT;
470:
471: --
472: hr_du_utility.message('ROUT',
473: 'exit:hr_du_do_datapump.set_status', 15);
474: --
475:
476: EXCEPTION
477: WHEN OTHERS THEN

Line 478: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.set_status'

474: --
475:
476: EXCEPTION
477: WHEN OTHERS THEN
478: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.set_status'
479: ,'(none)', 'R');
480: RAISE;
481: --
482: END SET_STATUS;

Line 541: 'entry:hr_du_do_datapump.return_created_user_key', 5);

537:
538: BEGIN
539: --
540: hr_du_utility.message('ROUT',
541: 'entry:hr_du_do_datapump.return_created_user_key', 5);
542: hr_du_utility.message('PARA', '(p_api_module_id - ' || p_api_module_id ||
543: ')(p_column_id - ' || p_column_id ||
544: ')(p_upload_id - ' || p_upload_id || ')' ,
545: 10);

Line 670: 'exit:hr_du_do_datapump.return_created_user_key', 15);

666: END IF;
667:
668: --
669: hr_du_utility.message('ROUT',
670: 'exit:hr_du_do_datapump.return_created_user_key', 15);
671: hr_du_utility.message('PARA', '(l_actual_user_key - ' || l_actual_user_key
672: || ')' , 20);
673: --
674:

Line 679: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key'

675: RETURN l_actual_user_key;
676:
677: EXCEPTION
678: WHEN e_fatal_error THEN
679: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key'
680: ,l_fatal_error_message, 'R');
681: RAISE;
682: WHEN OTHERS THEN
683: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key'

Line 683: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key'

679: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key'
680: ,l_fatal_error_message, 'R');
681: RAISE;
682: WHEN OTHERS THEN
683: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key'
684: ,'(none)', 'R');
685: RAISE;
686: --
687: END RETURN_CREATED_USER_KEY;

Line 731: 'entry:hr_du_do_datapump.return_created_user_key_2', 5);

727: BEGIN
728:
729: --
730: hr_du_utility.message('ROUT',
731: 'entry:hr_du_do_datapump.return_created_user_key_2', 5);
732: hr_du_utility.message('PARA', '(p_column_id - ' || p_column_id ||
733: ')(p_api_module_id - ' || p_api_module_id ||
734: ')(p_upload_line_id - ' || p_upload_line_id
735: || ')' , 10);

Line 821: 'exit:hr_du_do_datapump.return_created_user_key_2', 15);

817: g_user_key_table(l_user_key_table_size + 1).r_actual_user_key := l_actual_user_key;
818:
819: --
820: hr_du_utility.message('ROUT',
821: 'exit:hr_du_do_datapump.return_created_user_key_2', 15);
822: hr_du_utility.message('PARA', '(l_actual_user_key - ' || l_actual_user_key
823: || ')' , 20);
824: --
825:

Line 830: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key_2'

826: RETURN l_actual_user_key;
827:
828: EXCEPTION
829: WHEN e_fatal_error THEN
830: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key_2'
831: ,l_fatal_error_message, 'R');
832: RAISE;
833: WHEN OTHERS THEN
834: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key_2'

Line 834: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key_2'

830: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key_2'
831: ,l_fatal_error_message, 'R');
832: RAISE;
833: WHEN OTHERS THEN
834: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_created_user_key_2'
835: ,'(none)', 'R');
836: RAISE;
837: --
838: END RETURN_CREATED_USER_KEY_2;

Line 866: 'entry:hr_du_do_datapump.return_pval', 5);

862:
863: BEGIN
864: --
865: hr_du_utility.message('ROUT',
866: 'entry:hr_du_do_datapump.return_pval', 5);
867: hr_du_utility.message('PARA', '(p_mapped_name - ' || p_mapped_name ||
868: ')(p_table_pos - ' || p_table_pos || ')' ,
869: 10);
870: --

Line 903: 'exit:hr_du_do_datapump.return_pval', 30);

899: --
900: END LOOP;
901: --
902: hr_du_utility.message('ROUT',
903: 'exit:hr_du_do_datapump.return_pval', 30);
904: hr_du_utility.message('PARA', '(l_pval - ' || l_pval || ')' , 20);
905: --
906: RETURN l_pval;
907:

Line 910: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_pval'

906: RETURN l_pval;
907:
908: EXCEPTION
909: WHEN OTHERS THEN
910: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.return_pval'
911: ,'(none)', 'R');
912: RAISE;
913: --
914: END RETURN_PVAL;

Line 939: 'entry:hr_du_do_datapump.extract_business_group', 5);

935: BEGIN
936:
937: --
938: hr_du_utility.message('ROUT',
939: 'entry:hr_du_do_datapump.extract_business_group', 5);
940: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')', 10);
941: --
942:
943: --Retrieve the business group for the appropriate HR_DU_UPLOADS

Line 960: 'exit:hr_du_do_datapump.extract_business_group', 15);

956: END;
957:
958: --
959: hr_du_utility.message('ROUT',
960: 'exit:hr_du_do_datapump.extract_business_group', 15);
961: --
962:
963: RETURN l_business_group;
964:

Line 967: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.extract_business_group'

963: RETURN l_business_group;
964:
965: EXCEPTION
966: WHEN e_fatal_error THEN
967: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.extract_business_group'
968: ,l_fatal_error_message, 'R');
969: RAISE;
970: WHEN OTHERS THEN
971: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.extract_business_group'

Line 971: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.extract_business_group'

967: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.extract_business_group'
968: ,l_fatal_error_message, 'R');
969: RAISE;
970: WHEN OTHERS THEN
971: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.extract_business_group'
972: ,'(none)', 'R');
973: RAISE;
974: --
975: END EXTRACT_BUSINESS_GROUP;

Line 1009: 'entry:hr_du_do_datapump.extract_user_key', 5);

1005: BEGIN
1006:
1007: --
1008: hr_du_utility.message('ROUT',
1009: 'entry:hr_du_do_datapump.extract_user_key', 5);
1010: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id ||
1011: ')(p_table_id - ' || p_table_id || ')' ,
1012: 10);
1013: --

Line 1025: 'exit:hr_du_do_datapump.extract_user_key', 15);

1021: CLOSE csr_user_key;
1022:
1023: --
1024: hr_du_utility.message('ROUT',
1025: 'exit:hr_du_do_datapump.extract_user_key', 15);
1026: hr_du_utility.message('PARA', '(l_user_key - ' || l_user_key|| ')' , 20);
1027: --
1028:
1029: RETURN l_user_key;

Line 1033: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.extract_user_key'

1029: RETURN l_user_key;
1030:
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.extract_user_key'
1034: ,'(none)', 'R');
1035: RAISE;
1036: --
1037: END EXTRACT_USER_KEY;

Line 1116: 'entry:hr_du_do_datapump.create_user_key_string', 5);

1112: BEGIN
1113:
1114: --
1115: hr_du_utility.message('ROUT',
1116: 'entry:hr_du_do_datapump.create_user_key_string', 5);
1117: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id ||
1118: ')(p_table_size - ' || p_table_size || ')', 10);
1119:
1120: --

Line 1277: 'exit:hr_du_do_datapump.create_user_key_string', 30);

1273: END LOOP;
1274:
1275: --
1276: hr_du_utility.message('ROUT',
1277: 'exit:hr_du_do_datapump.create_user_key_string', 30);
1278: --
1279:
1280: EXCEPTION
1281: WHEN e_fatal_error THEN

Line 1282: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_user_key_string'

1278: --
1279:
1280: EXCEPTION
1281: WHEN e_fatal_error THEN
1282: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_user_key_string'
1283: ,l_fatal_error_message, 'R');
1284: RAISE;
1285: WHEN OTHERS THEN
1286: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_user_key_string'

Line 1286: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_user_key_string'

1282: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_user_key_string'
1283: ,l_fatal_error_message, 'R');
1284: RAISE;
1285: WHEN OTHERS THEN
1286: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_user_key_string'
1287: ,'(none)', 'R');
1288: RAISE;
1289: --
1290: END CREATE_USER_KEY_STRING;

Line 1336: 'entry:hr_du_do_datapump.create_p_strings', 5);

1332:
1333: BEGIN
1334: --
1335: hr_du_utility.message('ROUT',
1336: 'entry:hr_du_do_datapump.create_p_strings', 5);
1337: hr_du_utility.message('PARA', '(p_api_module_id - ' || p_api_module_id ||
1338: ')(p_upload_id - ' || p_upload_id ||
1339: ')(p_array_pos - ' || p_array_pos || ')' ,
1340: 10);

Line 1386: 'exit:hr_du_do_datapump.create_p_strings', 15);

1382: g_values_table(p_array_pos).r_PVAL_string := l_pval_string;
1383:
1384: --
1385: hr_du_utility.message('ROUT',
1386: 'exit:hr_du_do_datapump.create_p_strings', 15);
1387: --
1388:
1389: EXCEPTION
1390: WHEN e_fatal_error THEN

Line 1391: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_p_strings'

1387: --
1388:
1389: EXCEPTION
1390: WHEN e_fatal_error THEN
1391: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_p_strings'
1392: ,l_fatal_error_message, 'R');
1393: RAISE;
1394: WHEN OTHERS THEN
1395: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_p_strings'

Line 1395: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_p_strings'

1391: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_p_strings'
1392: ,l_fatal_error_message, 'R');
1393: RAISE;
1394: WHEN OTHERS THEN
1395: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_p_strings'
1396: ,'(none)', 'R');
1397: RAISE;
1398: --
1399: END CREATE_P_STRINGS;

Line 1440: 'entry:hr_du_do_datapump.produce_table', 5);

1436:
1437: BEGIN
1438: --
1439: hr_du_utility.message('ROUT',
1440: 'entry:hr_du_do_datapump.produce_table', 5);
1441: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1442: --
1443: OPEN csr_apis;
1444: LOOP

Line 1464: 'exit:hr_du_do_datapump.produce_table', 15);

1460: CLOSE csr_apis;
1461:
1462: --
1463: hr_du_utility.message('ROUT',
1464: 'exit:hr_du_do_datapump.produce_table', 15);
1465: --
1466:
1467: EXCEPTION
1468: WHEN e_fatal_error THEN

Line 1469: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.produce_table'

1465: --
1466:
1467: EXCEPTION
1468: WHEN e_fatal_error THEN
1469: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.produce_table'
1470: ,l_fatal_error_message, 'R');
1471: RAISE;
1472: WHEN OTHERS THEN
1473: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.produce_table',

Line 1473: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.produce_table',

1469: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.produce_table'
1470: ,l_fatal_error_message, 'R');
1471: RAISE;
1472: WHEN OTHERS THEN
1473: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.produce_table',
1474: '(none)', 'R');
1475: RAISE;
1476: --
1477: END PRODUCE_TABLE;

Line 1543: 'entry:hr_du_do_datapump.referencing_columns',

1539:
1540: BEGIN
1541: --
1542: hr_du_utility.message('ROUT',
1543: 'entry:hr_du_do_datapump.referencing_columns',
1544: 5);
1545: hr_du_utility.message('PARA', '(p_line_id - ' || p_line_id ||
1546: ')(p_api_module_id - ' || p_api_module_id ||
1547: ')(p_upload_id - ' || p_upload_id ||

Line 1642: 'exit:hr_du_do_datapump.referencing_columns',

1638: hr_du_utility.message('INFO', l_generic_pval , 40);
1639:
1640: --
1641: hr_du_utility.message('ROUT',
1642: 'exit:hr_du_do_datapump.referencing_columns',
1643: 45);
1644: --
1645: EXCEPTION
1646: WHEN OTHERS THEN

Line 1648: 'hr_du_do_datapump.referencing_columns',

1644: --
1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: hr_du_utility.error(SQLCODE,
1648: 'hr_du_do_datapump.referencing_columns',
1649: '(none)', 'R');
1650: RAISE;
1651: --
1652: END REFERENCING_COLUMNS;

Line 1690: 'entry:hr_du_do_datapump.create_referencing_strings', 5);

1686: BEGIN
1687:
1688: --
1689: hr_du_utility.message('ROUT',
1690: 'entry:hr_du_do_datapump.create_referencing_strings', 5);
1691: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id ||
1692: ')(p_table_position - ' || p_table_position ||
1693: ')(p_api_module_id - ' || p_api_module_id || ')'
1694: , 10);

Line 1714: 'exit:hr_du_do_datapump.create_referencing_strings', 30);

1710:
1711:
1712: --
1713: hr_du_utility.message('ROUT',
1714: 'exit:hr_du_do_datapump.create_referencing_strings', 30);
1715: --
1716:
1717: EXCEPTION
1718: WHEN e_fatal_error THEN

Line 1719: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.main'

1715: --
1716:
1717: EXCEPTION
1718: WHEN e_fatal_error THEN
1719: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.main'
1720: ,l_fatal_error_message, 'R');
1721: RAISE;
1722: WHEN OTHERS THEN
1723: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_referencing_strings'

Line 1723: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_referencing_strings'

1719: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.main'
1720: ,l_fatal_error_message, 'R');
1721: RAISE;
1722: WHEN OTHERS THEN
1723: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.create_referencing_strings'
1724: ,'(none)', 'R');
1725: RAISE;
1726: --
1727: END CREATE_REFERENCING_STRINGS;

Line 1754: hr_du_utility.message('ROUT','entry:hr_du_do_datapump.validate', 5);

1750: l_upload_line_id NUMBER;
1751:
1752: BEGIN
1753: --
1754: hr_du_utility.message('ROUT','entry:hr_du_do_datapump.validate', 5);
1755: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1756: --
1757:
1758: OPEN csr_validate_data;

Line 1770: hr_du_utility.message('ROUT','exit:hr_du_do_datapump.validate', 15);

1766: CLOSE csr_validate_data;
1767:
1768:
1769: --
1770: hr_du_utility.message('ROUT','exit:hr_du_do_datapump.validate', 15);
1771: --
1772:
1773: --
1774: EXCEPTION

Line 1776: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.validate'

1772:
1773: --
1774: EXCEPTION
1775: WHEN e_fatal_error THEN
1776: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.validate'
1777: ,l_fatal_error_message, 'R');
1778: RAISE;
1779: WHEN OTHERS THEN
1780: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.validate',

Line 1780: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.validate',

1776: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.validate'
1777: ,l_fatal_error_message, 'R');
1778: RAISE;
1779: WHEN OTHERS THEN
1780: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.validate',
1781: '(none)', 'R');
1782: RAISE;
1783: --
1784: END VALIDATE;

Line 1811: hr_du_utility.message('ROUT','entry:hr_du_do_datapump.rollback', 5);

1807: WHERE batch_id = l_batch_id;
1808:
1809: BEGIN
1810: --
1811: hr_du_utility.message('ROUT','entry:hr_du_do_datapump.rollback', 5);
1812: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1813: --
1814:
1815:

Line 1874: hr_du_utility.message('ROUT','exit:hr_du_do_datapump.rollback', 15);

1870: WHERE BATCH_ID = l_batch_id;
1871: Commit;
1872:
1873: --
1874: hr_du_utility.message('ROUT','exit:hr_du_do_datapump.rollback', 15);
1875: --
1876:
1877: --
1878: EXCEPTION

Line 1880: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.rollback',

1876:
1877: --
1878: EXCEPTION
1879: WHEN OTHERS THEN
1880: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.rollback',
1881: '(none)', 'R');
1882: RAISE;
1883: --
1884: END ROLLBACK;

Line 1943: hr_du_utility.message('ROUT','entry:hr_du_do_datapump.main', 5);

1939:
1940: BEGIN
1941:
1942: --
1943: hr_du_utility.message('ROUT','entry:hr_du_do_datapump.main', 5);
1944: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1945: --
1946:
1947: SET_STATUS(p_upload_id);

Line 2128: hr_du_utility.message('ROUT','exit:hr_du_do_datapump.main', 20);

2124: --
2125: END LOOP;
2126:
2127: --
2128: hr_du_utility.message('ROUT','exit:hr_du_do_datapump.main', 20);
2129: --
2130:
2131: EXCEPTION
2132: WHEN e_fatal_error THEN

Line 2133: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.main'

2129: --
2130:
2131: EXCEPTION
2132: WHEN e_fatal_error THEN
2133: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.main'
2134: ,l_fatal_error_message, 'R');
2135: RAISE;
2136: WHEN OTHERS THEN
2137: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.main','(none)', 'R');

Line 2137: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.main','(none)', 'R');

2133: hr_du_utility.error(SQLCODE,'hr_du_do_datapump.main'
2134: ,l_fatal_error_message, 'R');
2135: RAISE;
2136: WHEN OTHERS THEN
2137: hr_du_utility.error(SQLCODE, 'hr_du_do_datapump.main','(none)', 'R');
2138: RAISE;
2139: --
2140: END MAIN;
2141:

Line 2143: END HR_DU_DO_DATAPUMP;

2139: --
2140: END MAIN;
2141:
2142:
2143: END HR_DU_DO_DATAPUMP;