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_UTILITY

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 19: hr_du_utility.message('PARA', '(p_line_id - ' || p_line_id || ')'

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:
22: hr_du_utility.message('INFO','Select Statement Start ' , 15);
23:

Line 22: hr_du_utility.message('INFO','Select Statement Start ' , 15);

18: store_column_headings', 5);
19: hr_du_utility.message('PARA', '(p_line_id - ' || p_line_id || ')'
20: , 10);
21:
22: hr_du_utility.message('INFO','Select Statement Start ' , 15);
23:
24: SELECT
25: PVAL001, PVAL002, PVAL003, PVAL004 , PVAL005 , PVAL006,
26: PVAL007, PVAL008, PVAL009, PVAL010 , PVAL011, PVAL012,

Line 145: hr_du_utility.message('INFO','Select Statement Ends ' , 20);

141: g_column_headings(229),g_column_headings(230)
142: FROM HR_DU_UPLOAD_LINES
143: WHERE UPLOAD_LINE_ID = p_line_id;
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);

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 185: hr_du_utility.message('ROUT',

181: AND MAPPING_TYPE = 'U';
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: --

Line 187: hr_du_utility.message('PARA', '(p_api_module_id - ' ||

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:
191: OPEN csr_user_key;

Line 202: hr_du_utility.message('ROUT',

198: --
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:

Line 204: hr_du_utility.message('PARA', '(l_user_key - ' || l_user_key || ')' , 20);

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;
208:

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 215: hr_du_utility.error(SQLCODE,

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,
216: 'hr_du_do_datapump.find_user_key_from_mappings','(none)', 'R');
217: RAISE;
218: --
219: END FIND_USER_KEY_FROM_MAPPINGS;

Line 253: hr_du_utility.message('ROUT',

249: and upper(des1.value) = api.module_name;
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);

Line 255: hr_du_utility.message('PARA', '(p_api_module_id - ' || p_api_module_id ||

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: --
259:

Line 271: hr_du_utility.message('ROUT',

267: --
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: --

Line 273: hr_du_utility.message('PARA', '(l_process_order - ' || l_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:
277: RETURN l_process_order;

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 285: hr_du_utility.error(SQLCODE,

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,
286: 'hr_du_do_datapump.api_id_to_process_order','(none)', 'R');
287: RAISE;
288: --
289: END API_ID_TO_PROCESS_ORDER;

Line 333: hr_du_utility.message('ROUT',

329: l_string_length NUMBER;
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 || ')'

Line 335: hr_du_utility.message('PARA', '(p_user_key - ' || p_user_key ||

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);
339: --

Line 361: hr_du_utility.message('ROUT',

357: (l_string_length - l_length));
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: --

Line 363: hr_du_utility.message('PARA', '(l_extra_user_keys - ' || l_extra_user_keys

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:
367: RETURN l_extra_user_keys;

Line 371: hr_du_utility.error(SQLCODE,

367: RETURN l_extra_user_keys;
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;

Line 416: hr_du_utility.message('PARA', '(p_pval_field- ' || p_pval_field ||

412: AND PARENT_TABLE IS NULL;
413:
414: BEGIN
415: --
416: hr_du_utility.message('PARA', '(p_pval_field- ' || p_pval_field ||
417: ')(p_api_module_id - ' || p_api_module_id ||
418: ')(p_mapping_type - ' || p_mapping_type || ')'
419: , 5);
420: --

Line 430: hr_du_utility.message('PARA', '(l_mapped_name - ' || l_mapped_name || ')'

426: END IF;
427: --
428: CLOSE csr_ref_col;
429: --
430: hr_du_utility.message('PARA', '(l_mapped_name - ' || l_mapped_name || ')'
431: , 10);
432: --
433:
434: RETURN l_mapped_name;

Line 438: hr_du_utility.error(SQLCODE,

434: RETURN l_mapped_name;
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;

Line 458: hr_du_utility.message('ROUT',

454:
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:

Line 460: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')', 10);

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
464: SET status = 'NS'

Line 472: hr_du_utility.message('ROUT',

468: AND (REFERENCE_TYPE = 'CP' OR LINE_TYPE = 'C');
469: COMMIT;
470:
471: --
472: hr_du_utility.message('ROUT',
473: 'exit:hr_du_do_datapump.set_status', 15);
474: --
475:
476: EXCEPTION

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 540: hr_du_utility.message('ROUT',

536: AND line.PVAL001 = to_char(p_column_id);
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 || ')' ,

Line 542: hr_du_utility.message('PARA', '(p_api_module_id - ' || p_api_module_id ||

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);
546: --

Line 594: hr_du_utility.message('INFO', 'l_upload_line_id : ' ||

590: END IF;
591: --
592: CLOSE csr_upload_line_id;
593:
594: hr_du_utility.message('INFO', 'l_upload_line_id : ' ||
595: l_upload_line_id , 20);
596:
597: -- now work out the size of the user key separated by : loop around
598: -- getting it and then glue them on to a string

Line 669: hr_du_utility.message('ROUT',

665: --
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: --

Line 671: hr_du_utility.message('PARA', '(l_actual_user_key - ' || l_actual_user_key

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:
675: RETURN l_actual_user_key;

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 730: hr_du_utility.message('ROUT',

726:
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

Line 732: hr_du_utility.message('PARA', '(p_column_id - ' || p_column_id ||

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);
736: --

Line 820: hr_du_utility.message('ROUT',

816: g_user_key_table(l_user_key_table_size + 1).r_user_key := p_user_key;
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: --

Line 822: hr_du_utility.message('PARA', '(l_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:
826: RETURN l_actual_user_key;

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 865: hr_du_utility.message('ROUT',

861: l_single_name VARCHAR2(50);
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);

Line 867: hr_du_utility.message('PARA', '(p_mapped_name - ' || p_mapped_name ||

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: --
871:

Line 902: hr_du_utility.message('ROUT',

898: END IF;
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;

Line 904: hr_du_utility.message('PARA', '(l_pval - ' || l_pval || ')' , 20);

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:
908: EXCEPTION

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 938: hr_du_utility.message('ROUT',

934:
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:

Line 940: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')', 10);

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
944: BEGIN

Line 959: hr_du_utility.message('ROUT',

955: RAISE e_fatal_error;
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;

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 1008: hr_du_utility.message('ROUT',

1004:
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);

Line 1010: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id ||

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: --
1014: OPEN csr_user_key;

Line 1024: hr_du_utility.message('ROUT',

1020: --
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:

Line 1026: hr_du_utility.message('PARA', '(l_user_key - ' || l_user_key|| ')' , 20);

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;
1030:

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 1115: hr_du_utility.message('ROUT',

1111:
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:

Line 1117: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id ||

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: --
1121: FOR l_counter IN 1..p_table_size LOOP

Line 1127: hr_du_utility.message('INFO', 'API Module id : ' ||

1123: l_key_pval_string := null;
1124:
1125: --Extracts the user key defined by the user within the flat file
1126: l_user_key := EXTRACT_USER_KEY(p_upload_id, l_counter);
1127: hr_du_utility.message('INFO', 'API Module id : ' ||
1128: g_values_table(l_counter).r_api_id, 25);
1129:
1130: hr_du_di_insert.g_current_delimiter := ':';
1131:

Line 1268: hr_du_utility.message('INFO', 'l_key_pval_string : ' ||

1264: END IF;
1265: CLOSE csr_referencing;
1266:
1267: --insert the string in to R_USER_KEY_PVAL
1268: hr_du_utility.message('INFO', 'l_key_pval_string : ' ||
1269: l_key_pval_string, 25);
1270:
1271: g_values_table(l_counter).r_user_key_pval := l_key_pval_string;
1272: --

Line 1276: hr_du_utility.message('ROUT',

1272: --
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

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 1335: hr_du_utility.message('ROUT',

1331: l_string_length NUMBER;
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 || ')' ,

Line 1337: hr_du_utility.message('PARA', '(p_api_module_id - ' || p_api_module_id ||

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);
1341: --

Line 1385: hr_du_utility.message('ROUT',

1381: g_values_table(p_array_pos).r_insert_string := l_pvalues_string;
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

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 1439: hr_du_utility.message('ROUT',

1435: l_upload_header_id NUMBER;
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;

Line 1441: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);

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
1445: --

Line 1463: hr_du_utility.message('ROUT',

1459: END IF;
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

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 1542: hr_du_utility.message('ROUT',

1538: AND column_name = l_pval_field;
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 ||

Line 1545: hr_du_utility.message('PARA', '(p_line_id - ' || p_line_id ||

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 ||
1548: ')(p_array_pos - ' || p_array_pos || ')'
1549: , 10);

Line 1577: hr_du_utility.message('INFO', l_parent_table, 15);

1573: FETCH csr_parent_table_column INTO l_parent_table;
1574: IF csr_parent_table_column%FOUND THEN
1575: --loop through the column headings again to search for the
1576: --position in the line of where the api_module id will be stored
1577: hr_du_utility.message('INFO', l_parent_table, 15);
1578: FOR j IN 1..230 LOOP
1579: --
1580: l_inner_pval := LPAD(j,3,'0');
1581: l_inner_pval := 'PVAL' || l_inner_pval;

Line 1585: hr_du_utility.message('INFO', l_inner_field, 20);

1581: l_inner_pval := 'PVAL' || l_inner_pval;
1582:
1583: l_inner_field := g_column_headings(j);
1584:
1585: hr_du_utility.message('INFO', l_inner_field, 20);
1586:
1587: IF l_parent_table = l_inner_field THEN
1588: --found the exact position in the line where the api_module id
1589: --from the calling table will be stored (l_inner_pval).

Line 1607: hr_du_utility.message('INFO', l_parent_api_module_id , 25);

1603: CLOSE csr_parent_table_column;
1604: --
1605: ELSE
1606: --
1607: hr_du_utility.message('INFO', l_parent_api_module_id , 25);
1608: l_string_apis := l_string_apis || l_parent_api_module_id || ',';
1609: l_api_PVALS := l_api_PVALS || l_current_pval || ',';
1610: l_generic_pval := l_generic_pval || null || ',';
1611: --

Line 1636: hr_du_utility.message('INFO', l_api_PVALS , 35);

1632: g_values_table(p_array_pos).r_parent_api_module_number := l_string_apis;
1633: g_values_table(p_array_pos).r_pval_parent_line_id := l_api_PVALS;
1634: g_values_table(p_array_pos).r_pval_api_module_number := l_generic_pval;
1635:
1636: hr_du_utility.message('INFO', l_api_PVALS , 35);
1637: hr_du_utility.message('INFO', l_string_apis , 30);
1638: hr_du_utility.message('INFO', l_generic_pval , 40);
1639:
1640: --

Line 1637: hr_du_utility.message('INFO', l_string_apis , 30);

1633: g_values_table(p_array_pos).r_pval_parent_line_id := l_api_PVALS;
1634: g_values_table(p_array_pos).r_pval_api_module_number := l_generic_pval;
1635:
1636: hr_du_utility.message('INFO', l_api_PVALS , 35);
1637: hr_du_utility.message('INFO', l_string_apis , 30);
1638: hr_du_utility.message('INFO', l_generic_pval , 40);
1639:
1640: --
1641: hr_du_utility.message('ROUT',

Line 1638: hr_du_utility.message('INFO', l_generic_pval , 40);

1634: g_values_table(p_array_pos).r_pval_api_module_number := l_generic_pval;
1635:
1636: hr_du_utility.message('INFO', l_api_PVALS , 35);
1637: hr_du_utility.message('INFO', l_string_apis , 30);
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',

Line 1641: hr_du_utility.message('ROUT',

1637: hr_du_utility.message('INFO', l_string_apis , 30);
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

Line 1647: hr_du_utility.error(SQLCODE,

1643: 45);
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: --

Line 1689: hr_du_utility.message('ROUT',

1685:
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 || ')'

Line 1691: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id ||

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);
1695: --

Line 1706: hr_du_utility.message('INFO', 'l_line_id : ' || l_line_id, 15);

1702: RAISE e_fatal_error;
1703: END IF;
1704: CLOSE csr_line_id;
1705:
1706: hr_du_utility.message('INFO', 'l_line_id : ' || l_line_id, 15);
1707:
1708: REFERENCING_COLUMNS(l_line_id, p_api_module_id, p_upload_id,
1709: p_table_position);
1710:

Line 1713: hr_du_utility.message('ROUT',

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

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 1755: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);

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;
1759: FETCH csr_validate_data INTO l_upload_line_id;

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 1812: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);

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:
1816: UPDATE hr_du_upload_lines

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 1944: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);

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);
1948:

Line 1960: hr_du_utility.message('INFO','l_business_group : ' || l_business_group, 15);

1956: PRODUCE_TABLE(p_upload_id);
1957:
1958: --Returns the overall business group related to the HR_DU_UPLOAD.ID
1959: l_business_group := EXTRACT_BUSINESS_GROUP(p_upload_id);
1960: hr_du_utility.message('INFO','l_business_group : ' || l_business_group, 15);
1961:
1962:
1963: OPEN csr_batch_name;
1964: FETCH csr_batch_name INTO l_upload_id;

Line 2002: hr_du_utility.message('INFO','l_batch_id : ' || l_batch_id, 20);

1998:
1999: fnd_conc_global.set_req_globals(request_data => to_char(l_batch_id));
2000:
2001:
2002: hr_du_utility.message('INFO','l_batch_id : ' || l_batch_id, 20);
2003:
2004:
2005: UPDATE hr_du_uploads
2006: SET batch_id = l_batch_id

Line 2012: hr_du_utility.message('INFO','api_module id : ' ||

2008: COMMIT;
2009:
2010: FOR i IN 1..l_table_size LOOP
2011: --
2012: hr_du_utility.message('INFO','api_module id : ' ||
2013: g_values_table(i).r_api_id, 25);
2014:
2015: --Procedure call to fill in R_PVAL_PARENT_LINE_ID,
2016: --R_PARENT_api_module_NUMBER, R_PVAL_api_module_NUMBER

Line 2019: hr_du_utility.message('INFO','r_parent_api_module_number : ' ||

2015: --Procedure call to fill in R_PVAL_PARENT_LINE_ID,
2016: --R_PARENT_api_module_NUMBER, R_PVAL_api_module_NUMBER
2017: CREATE_REFERENCING_STRINGS(p_upload_id, i, g_values_table(i).r_api_id);
2018:
2019: hr_du_utility.message('INFO','r_parent_api_module_number : ' ||
2020: g_values_table(i).r_parent_api_module_number , 15);
2021: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||
2022: g_values_table(i).r_pval_parent_line_id , 15);
2023: hr_du_utility.message('INFO','r_pval_api_module_number : ' ||

Line 2021: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||

2017: CREATE_REFERENCING_STRINGS(p_upload_id, i, g_values_table(i).r_api_id);
2018:
2019: hr_du_utility.message('INFO','r_parent_api_module_number : ' ||
2020: g_values_table(i).r_parent_api_module_number , 15);
2021: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||
2022: g_values_table(i).r_pval_parent_line_id , 15);
2023: hr_du_utility.message('INFO','r_pval_api_module_number : ' ||
2024: g_values_table(i).r_pval_api_module_number , 15);
2025:

Line 2023: hr_du_utility.message('INFO','r_pval_api_module_number : ' ||

2019: hr_du_utility.message('INFO','r_parent_api_module_number : ' ||
2020: g_values_table(i).r_parent_api_module_number , 15);
2021: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||
2022: g_values_table(i).r_pval_parent_line_id , 15);
2023: hr_du_utility.message('INFO','r_pval_api_module_number : ' ||
2024: g_values_table(i).r_pval_api_module_number , 15);
2025:
2026: --
2027: END LOOP;

Line 2044: hr_du_utility.message('INFO','l_api_name : ' || l_api_name , 20);

2040: --this is here for the user_sequence value
2041: l_process_order := API_id_to_process_order(l_api_module_id,
2042: p_upload_id);
2043:
2044: hr_du_utility.message('INFO','l_api_name : ' || l_api_name , 20);
2045: hr_du_utility.message('INFO','l_process_order : ' || l_process_order, 20);
2046:
2047:
2048: --Making sure that the api name is the correct length for when the Meta

Line 2045: hr_du_utility.message('INFO','l_process_order : ' || l_process_order, 20);

2041: l_process_order := API_id_to_process_order(l_api_module_id,
2042: p_upload_id);
2043:
2044: hr_du_utility.message('INFO','l_api_name : ' || l_api_name , 20);
2045: hr_du_utility.message('INFO','l_process_order : ' || l_process_order, 20);
2046:
2047:
2048: --Making sure that the api name is the correct length for when the Meta
2049: --Mapper has been run it's rounded to 30 characters including HRDPV_

Line 2058: l_chunk_size_master := hr_du_utility.chunk_size;

2054: ELSE
2055: l_api_name_thirty := l_api_name;
2056: END IF;
2057:
2058: l_chunk_size_master := hr_du_utility.chunk_size;
2059: l_chunk_size_slave := l_chunk_size_master;
2060:
2061:
2062: OPEN csr_upload_line_id;

Line 2084: hr_du_utility.message('INFO',upper(l_api_name), 20);

2080:
2081: --If statements inserted here to call the appropriate procedure within
2082: --HR_DU_DO_ENTITIES so that the insert statements are build up correctly
2083:
2084: hr_du_utility.message('INFO',upper(l_api_name), 20);
2085:
2086: IF upper(l_api_name) = 'CREATE_US_EMPLOYEE' OR
2087: upper(l_api_name) = 'CREATE_GB_EMPLOYEE' THEN
2088: hr_du_do_entities.CREATE_DEFAULT_EMPLOYEE(g_values_table(i), 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: