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_DI_INSERT dependencies on HR_DU_UTILITY

Line 38: hr_du_utility.message('ROUT',

34: AND upload_header_id = p_upload_header_id;
35:
36: BEGIN
37: --
38: hr_du_utility.message('ROUT',
39: 'entry:hr_du_di_insert.validate_sheet_descriptors', 5);
40: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id ||
41: ')(p_upload_header_id - ' || p_upload_header_id || ')' , 10);
42: --

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

36: BEGIN
37: --
38: hr_du_utility.message('ROUT',
39: 'entry:hr_du_di_insert.validate_sheet_descriptors', 5);
40: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id ||
41: ')(p_upload_header_id - ' || p_upload_header_id || ')' , 10);
42: --
43: OPEN csr_total_desc;
44: FETCH csr_total_desc INTO l_counter_1;

Line 73: hr_du_utility.message('ROUT',

69: RAISE e_fatal_error;
70: END IF;
71:
72: --
73: hr_du_utility.message('ROUT',
74: 'exit:hr_du_di_insert.validate_sheet_descriptors', 15);
75: --
76: EXCEPTION
77: WHEN e_fatal_error THEN

Line 78: hr_du_utility.error(SQLCODE,

74: 'exit:hr_du_di_insert.validate_sheet_descriptors', 15);
75: --
76: EXCEPTION
77: WHEN e_fatal_error THEN
78: hr_du_utility.error(SQLCODE,
79: 'hr_du_di_insert.validate_sheet_descriptors',
80: l_fatal_error_message, 'R');
81: RAISE;
82: WHEN OTHERS THEN

Line 83: hr_du_utility.error(SQLCODE,'hr_du_di_insert.validate_sheet_descriptors'

79: 'hr_du_di_insert.validate_sheet_descriptors',
80: l_fatal_error_message, 'R');
81: RAISE;
82: WHEN OTHERS THEN
83: hr_du_utility.error(SQLCODE,'hr_du_di_insert.validate_sheet_descriptors'
84: ,'(none)', 'R');
85: RAISE;
86: --
87: END VALIDATE_SHEET_DESCRIPTORS;

Line 122: hr_du_utility.message('ROUT',

118: AND upload_header_id IS NULL;
119:
120: BEGIN
121: --
122: hr_du_utility.message('ROUT',
123: 'entry:hr_du_di_insert.validate_header_descriptors', 5);
124: hr_du_utility.message('PARA',
125: '(p_upload_id - ' || p_upload_id || ')' , 10);
126:

Line 124: hr_du_utility.message('PARA',

120: BEGIN
121: --
122: hr_du_utility.message('ROUT',
123: 'entry:hr_du_di_insert.validate_header_descriptors', 5);
124: hr_du_utility.message('PARA',
125: '(p_upload_id - ' || p_upload_id || ')' , 10);
126:
127: --
128: OPEN csr_total_desc;

Line 153: hr_du_utility.message('ROUT',

149: RAISE e_fatal_error;
150: END IF;
151:
152: --
153: hr_du_utility.message('ROUT',
154: 'exit:hr_du_di_insert.validate_header_descriptors', 15);
155: --
156: EXCEPTION
157: WHEN e_fatal_error THEN

Line 158: hr_du_utility.error(SQLCODE,

154: 'exit:hr_du_di_insert.validate_header_descriptors', 15);
155: --
156: EXCEPTION
157: WHEN e_fatal_error THEN
158: hr_du_utility.error(SQLCODE,
159: 'hr_du_di_insert.validate_header_descriptors',
160: l_fatal_error_message, 'R');
161: RAISE;
162: WHEN OTHERS THEN

Line 163: hr_du_utility.error(SQLCODE,

159: 'hr_du_di_insert.validate_header_descriptors',
160: l_fatal_error_message, 'R');
161: RAISE;
162: WHEN OTHERS THEN
163: hr_du_utility.error(SQLCODE,
164: 'hr_du_di_insert.validate_header_descriptors',
165: '(none)', 'R');
166: RAISE;
167: --

Line 200: hr_du_utility.message('ROUT',

196: l_file_name VARCHAR2(200);
197:
198: BEGIN
199: --
200: hr_du_utility.message('ROUT',
201: 'entry:hr_du_di_insert.parse_line_to_table', 5);
202: hr_du_utility.message('PARA', '(p_data_line - ' || p_data_line ||
203: ')(p_upload_header_id - ' || p_upload_header_id ||
204: ')(p_line_type - ' || p_line_type || ')' , 10);

Line 202: hr_du_utility.message('PARA', '(p_data_line - ' || p_data_line ||

198: BEGIN
199: --
200: hr_du_utility.message('ROUT',
201: 'entry:hr_du_di_insert.parse_line_to_table', 5);
202: hr_du_utility.message('PARA', '(p_data_line - ' || p_data_line ||
203: ')(p_upload_header_id - ' || p_upload_header_id ||
204: ')(p_line_type - ' || p_line_type || ')' , 10);
205: --
206:

Line 271: hr_du_utility.message('ROUT',

267: g_line_table(j) := NULL;
268: END LOOP;
269:
270: --
271: hr_du_utility.message('ROUT',
272: 'exit:hr_du_di_insert.parse_line_to_table', 15);
273: --
274: EXCEPTION
275: WHEN e_fatal_error THEN

Line 276: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.parse_line_to_table',

272: 'exit:hr_du_di_insert.parse_line_to_table', 15);
273: --
274: EXCEPTION
275: WHEN e_fatal_error THEN
276: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.parse_line_to_table',
277: l_fatal_error_message, 'R');
278: RAISE;
279: WHEN OTHERS THEN
280: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.parse_line_to_table',

Line 280: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.parse_line_to_table',

276: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.parse_line_to_table',
277: l_fatal_error_message, 'R');
278: RAISE;
279: WHEN OTHERS THEN
280: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.parse_line_to_table',
281: '(none)', 'R');
282: RAISE;
283: --
284: END PARSE_LINE_TO_TABLE;

Line 318: hr_du_utility.message('ROUT',

314: AND DESCRIPTOR_TYPE = 'F';
315:
316: BEGIN
317: --
318: hr_du_utility.message('ROUT',
319: 'entry:hr_du_di_insert.check_unique_files', 5);
320: --
321:
322: OPEN csr_total_count;

Line 347: hr_du_utility.message('ROUT',

343: RAISE e_fatal_error;
344: END IF;
345:
346: --
347: hr_du_utility.message('ROUT',
348: 'exit:hr_du_di_insert.check_unique_files', 15);
349: --
350: EXCEPTION
351: WHEN e_fatal_error THEN

Line 352: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',

348: 'exit:hr_du_di_insert.check_unique_files', 15);
349: --
350: EXCEPTION
351: WHEN e_fatal_error THEN
352: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',
353: l_fatal_error_message, 'R');
354: RAISE;
355: WHEN OTHERS THEN
356: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.check_unique_files',

Line 356: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.check_unique_files',

352: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',
353: l_fatal_error_message, 'R');
354: RAISE;
355: WHEN OTHERS THEN
356: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.check_unique_files',
357: '(none)', 'R');
358: RAISE;
359: --
360: END CHECK_UNIQUE_FILES;

Line 365: -- dynamic SQL table with the appropriate hr_du_utility.local_CHR(i) values.

361:
362:
363: -- ------------------------- POPULATE_DYNAMIC_TABLE ------------------------
364: -- Description: This procedure is called once and simply populates the
365: -- dynamic SQL table with the appropriate hr_du_utility.local_CHR(i) values.
366: -- The Upper case are in positions 1..26 and Lower case in 27..52
367: -- -------------------------------------------------------------------------
368: PROCEDURE POPULATE_DYNAMIC_TABLE
369: IS

Line 375: hr_du_utility.message('ROUT',

371: l_counter NUMBER := 1;
372:
373: BEGIN
374: --
375: hr_du_utility.message('ROUT',
376: 'entry:hr_du_di_insert.populate_dynamic_table', 5);
377: --
378:
379: --Loop around the upper case letters

Line 381: Char_table(l_counter) := hr_du_utility.local_CHR(i);

377: --
378:
379: --Loop around the upper case letters
380: FOR i IN 65..90 LOOP
381: Char_table(l_counter) := hr_du_utility.local_CHR(i);
382: l_counter := l_counter + 1;
383: END LOOP;
384:
385: --Loop around the lower case letters

Line 387: Char_table(l_counter) := hr_du_utility.local_CHR(i);

383: END LOOP;
384:
385: --Loop around the lower case letters
386: FOR i IN 97..122 LOOP
387: Char_table(l_counter) := hr_du_utility.local_CHR(i);
388: l_counter := l_counter + 1;
389: END LOOP;
390:
391: --

Line 392: hr_du_utility.message('ROUT',

388: l_counter := l_counter + 1;
389: END LOOP;
390:
391: --
392: hr_du_utility.message('ROUT',
393: 'exit:hr_du_di_insert.populate_dynamic_table', 15);
394: --
395: EXCEPTION
396: WHEN OTHERS THEN

Line 397: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.populate_dynamic_table',

393: 'exit:hr_du_di_insert.populate_dynamic_table', 15);
394: --
395: EXCEPTION
396: WHEN OTHERS THEN
397: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.populate_dynamic_table',
398: '(none)', 'R');
399: RAISE;
400: --
401: END POPULATE_DYNAMIC_TABLE;

Line 457: hr_du_utility.message('ROUT',

453: l_cursor_handle INT;
454:
455: BEGIN
456: --
457: hr_du_utility.message('ROUT',
458: 'entry:hr_du_di_insert.validate_api_ids', 5);
459: hr_du_utility.message('PARA',
460: '(p_upload_header_id - ' || p_upload_header_id || ')' , 10);
461: --

Line 459: hr_du_utility.message('PARA',

455: BEGIN
456: --
457: hr_du_utility.message('ROUT',
458: 'entry:hr_du_di_insert.validate_api_ids', 5);
459: hr_du_utility.message('PARA',
460: '(p_upload_header_id - ' || p_upload_header_id || ')' , 10);
461: --
462:
463: OPEN csr_line_id;

Line 485: hr_du_utility.message('INFO', 'Warning : l_pval_field (with ' ||

481:
482: hr_du_dp_pc_conversion.REMOVE_SPACES (l_pval_field, l_spaces);
483:
484: IF l_spaces = TRUE THEN
485: hr_du_utility.message('INFO', 'Warning : l_pval_field (with ' ||
486: 'spaces removed) : ' || l_pval_field , 20);
487: END IF;
488: --
489: END LOOP;

Line 524: hr_du_utility.message('ROUT','exit:hr_du_di_insert.validate_api_ids', 15);

520: RAISE e_fatal_error;
521: END IF;
522:
523: --
524: hr_du_utility.message('ROUT','exit:hr_du_di_insert.validate_api_ids', 15);
525: --
526: EXCEPTION
527: WHEN e_fatal_error THEN
528: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',

Line 528: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',

524: hr_du_utility.message('ROUT','exit:hr_du_di_insert.validate_api_ids', 15);
525: --
526: EXCEPTION
527: WHEN e_fatal_error THEN
528: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',
529: l_fatal_error_message, 'R');
530: RAISE;
531: WHEN OTHERS THEN
532: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',

Line 532: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',

528: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',
529: l_fatal_error_message, 'R');
530: RAISE;
531: WHEN OTHERS THEN
532: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',
533: '(none)', 'R');
534: RAISE;
535: --
536: END VALIDATE_API_IDS;

Line 561: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.set_delimiter_string',

557: END IF;
558:
559: EXCEPTION
560: WHEN OTHERS THEN
561: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.set_delimiter_string',
562: '(none)', 'R');
563: RAISE;
564: --
565: END SET_DElIMITER_STRING;

Line 609: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.num_delimiters',

605:
606: --error handling
607: EXCEPTION
608: WHEN OTHERS THEN
609: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.num_delimiters',
610: '(none)', 'R');
611: RAISE;
612: --
613: END NUM_DELIMITERS;

Line 647: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.words_on_line','(none)',

643:
644: --error handling
645: EXCEPTION
646: WHEN OTHERS THEN
647: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.words_on_line','(none)',
648: 'R');
649: RAISE;
650: END WORDS_ON_LINE;
651:

Line 673: hr_du_utility.message('ROUT','entry:hr_du_di_insert.remove_garbage', 5);

669: l_new_data_line VARCHAR2(32767);
670:
671: BEGIN
672: --
673: hr_du_utility.message('ROUT','entry:hr_du_di_insert.remove_garbage', 5);
674: hr_du_utility.message('PARA', '(p_line - ' || p_line || ')' , 10);
675: --
676:
677: --this loop handles removing i.e carrage returns from the line

Line 674: hr_du_utility.message('PARA', '(p_line - ' || p_line || ')' , 10);

670:
671: BEGIN
672: --
673: hr_du_utility.message('ROUT','entry:hr_du_di_insert.remove_garbage', 5);
674: hr_du_utility.message('PARA', '(p_line - ' || p_line || ')' , 10);
675: --
676:
677: --this loop handles removing i.e carrage returns from the line
678: IF g_delimiter_count = 0 THEN

Line 687: hr_du_utility.message('ROUT','exit:hr_du_di_insert.remove_garbage', 15);

683: l_new_data_line := l_new_data_line || l_temp_line;
684: END LOOP;
685: END IF;
686: --
687: hr_du_utility.message('ROUT','exit:hr_du_di_insert.remove_garbage', 15);
688: hr_du_utility.message('PARA', '(l_new_data_line - ' || l_new_data_line
689: || ')' , 20);
690: --
691: RETURN l_new_data_line;

Line 688: hr_du_utility.message('PARA', '(l_new_data_line - ' || l_new_data_line

684: END LOOP;
685: END IF;
686: --
687: hr_du_utility.message('ROUT','exit:hr_du_di_insert.remove_garbage', 15);
688: hr_du_utility.message('PARA', '(l_new_data_line - ' || l_new_data_line
689: || ')' , 20);
690: --
691: RETURN l_new_data_line;
692:

Line 696: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.remove_garbage','(none)',

692:
693: --error handling
694: EXCEPTION
695: WHEN OTHERS THEN
696: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.remove_garbage','(none)',
697: 'R');
698: RAISE;
699:
700: END REMOVE_GARBAGE;

Line 734: hr_du_utility.message('ROUT','entry:hr_du_di_insert.next_line', 5);

730: AND head.api_module_id = api.api_module_id;
731:
732: BEGIN
733: --
734: hr_du_utility.message('ROUT','entry:hr_du_di_insert.next_line', 5);
735: hr_du_utility.message('PARA', '(p_filehandle - Record type )' , 10);
736: --
737: g_counter := g_counter + 1;
738: utl_file.get_line(p_filehandle,l_data_line);

Line 735: hr_du_utility.message('PARA', '(p_filehandle - Record type )' , 10);

731:
732: BEGIN
733: --
734: hr_du_utility.message('ROUT','entry:hr_du_di_insert.next_line', 5);
735: hr_du_utility.message('PARA', '(p_filehandle - Record type )' , 10);
736: --
737: g_counter := g_counter + 1;
738: utl_file.get_line(p_filehandle,l_data_line);
739: l_string_length := LENGTH(l_data_line);

Line 741: hr_du_utility.message('INFO','Value of the line ' || l_data_line, 15);

737: g_counter := g_counter + 1;
738: utl_file.get_line(p_filehandle,l_data_line);
739: l_string_length := LENGTH(l_data_line);
740: --
741: hr_du_utility.message('INFO','Value of the line ' || l_data_line, 15);
742: --
743:
744: g_current_delimiter := g_linef_delimiter;
745: g_delimiter_count := Num_Delimiters(l_data_line);

Line 770: hr_du_utility.message('ROUT','exit:hr_du_di_insert.next_line', 20);

766: SET_DElIMITER_STRING;
767: g_delimiter_count := Num_Delimiters(l_data_line);
768:
769: --
770: hr_du_utility.message('ROUT','exit:hr_du_di_insert.next_line', 20);
771: hr_du_utility.message('PARA', '(l_data_line - ' || l_data_line || ')' ,
772: 25);
773: --
774:

Line 771: hr_du_utility.message('PARA', '(l_data_line - ' || l_data_line || ')' ,

767: g_delimiter_count := Num_Delimiters(l_data_line);
768:
769: --
770: hr_du_utility.message('ROUT','exit:hr_du_di_insert.next_line', 20);
771: hr_du_utility.message('PARA', '(l_data_line - ' || l_data_line || ')' ,
772: 25);
773: --
774:
775: RETURN l_data_line;

Line 783: hr_du_utility.error(SQLCODE, 'Problem at line ' || g_counter ||

779: WHEN NO_DATA_FOUND THEN
780: OPEN csr_api_name;
781: FETCH csr_api_name INTO l_api_name;
782: CLOSE csr_api_name;
783: hr_du_utility.error(SQLCODE, 'Problem at line ' || g_counter ||
784: ' within the file relating to the API : '||
785: l_api_name,'(none)', 'R');
786: RAISE;
787: WHEN OTHERS THEN

Line 788: hr_du_utility.error(SQLCODE,

784: ' within the file relating to the API : '||
785: l_api_name,'(none)', 'R');
786: RAISE;
787: WHEN OTHERS THEN
788: hr_du_utility.error(SQLCODE,
789: 'hr_du_di_insert.next_line','(none)', 'R');
790: RAISE;
791: END NEXT_LINE;
792:

Line 874: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_word',

870:
871: --error handling
872: EXCEPTION
873: WHEN e_fatal_error THEN
874: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_word',
875: l_fatal_error_message, 'R');
876: RAISE;
877: WHEN OTHERS THEN
878: hr_du_utility.error(SQLCODE,

Line 878: hr_du_utility.error(SQLCODE,

874: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_word',
875: l_fatal_error_message, 'R');
876: RAISE;
877: WHEN OTHERS THEN
878: hr_du_utility.error(SQLCODE,
879: 'hr_du_di_insert.return_word','(none)', 'R');
880: RAISE;
881: END RETURN_WORD;
882:

Line 916: hr_du_utility.message('ROUT','entry:hr_du_di_insert.general_extract', 5);

912: l_file_name VARCHAR2(2000);
913:
914: BEGIN
915: --
916: hr_du_utility.message('ROUT','entry:hr_du_di_insert.general_extract', 5);
917: hr_du_utility.message('PARA', '(p_filehandle - Record Type)' ||
918: '(p_upload_id - ' || p_upload_id ||
919: ')(p_upload_header_id - ' || p_upload_header_id ||
920: ')(p_string - ' || p_string ||

Line 917: hr_du_utility.message('PARA', '(p_filehandle - Record Type)' ||

913:
914: BEGIN
915: --
916: hr_du_utility.message('ROUT','entry:hr_du_di_insert.general_extract', 5);
917: hr_du_utility.message('PARA', '(p_filehandle - Record Type)' ||
918: '(p_upload_id - ' || p_upload_id ||
919: ')(p_upload_header_id - ' || p_upload_header_id ||
920: ')(p_string - ' || p_string ||
921: ')(p_descriptor_type - ' || p_descriptor_type || ')' , 10);

Line 926: hr_du_utility.message('INFO','Processing Line - ' || l_data_line, 15);

922: --
923: LOOP
924: BEGIN
925: l_data_line := next_line(p_filehandle, p_upload_header_id);
926: hr_du_utility.message('INFO','Processing Line - ' || l_data_line, 15);
927: --call return_word to get the first word which is the descriptor
928: l_Col_one := upper(Return_Word (l_data_line, 1));
929: l_Col_two := upper(Return_Word (l_data_line, 2));
930: EXIT WHEN (l_Col_one = p_string)

Line 953: hr_du_utility.message('INFO','Processing Line - ' || l_data_line, 20);

949: --
950: LOOP
951: BEGIN
952: l_data_line := next_line(p_filehandle, p_upload_header_id);
953: hr_du_utility.message('INFO','Processing Line - ' || l_data_line, 20);
954: IF l_data_line IS NULL THEN
955: null;
956: ELSE
957: l_Col_one := Return_Word (l_data_line, 1);

Line 980: hr_du_utility.message('INFO','Insert statement', 25);

976: EXIT WHEN (UPPER(l_Col_one) = p_string)
977: AND (UPPER(l_Col_two) = 'END');
978:
979: --insert into the descriptors table the values
980: hr_du_utility.message('INFO','Insert statement', 25);
981: INSERT INTO HR_DU_DESCRIPTORS(
982: DESCRIPTOR_ID, UPLOAD_ID, UPLOAD_HEADER_ID,
983: DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
984: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,

Line 1017: hr_du_utility.message('ROUT','exit:hr_du_di_insert.general_extract', 30);

1013: RAISE e_fatal_error;
1014: END;
1015: END LOOP;
1016: --
1017: hr_du_utility.message('ROUT','exit:hr_du_di_insert.general_extract', 30);
1018: --
1019:
1020: --error handling
1021: EXCEPTION

Line 1023: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.general_extract',

1019:
1020: --error handling
1021: EXCEPTION
1022: WHEN e_fatal_error THEN
1023: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.general_extract',
1024: l_fatal_error_message, 'R');
1025: RAISE;
1026: WHEN OTHERS THEN
1027: hr_du_utility.error(SQLCODE,

Line 1027: hr_du_utility.error(SQLCODE,

1023: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.general_extract',
1024: l_fatal_error_message, 'R');
1025: RAISE;
1026: WHEN OTHERS THEN
1027: hr_du_utility.error(SQLCODE,
1028: 'hr_du_di_insert.general_extract','(none)', 'R');
1029: RAISE;
1030:
1031: END GENERAL_EXTRACT;

Line 1054: hr_du_utility.message('ROUT','entry:hr_du_di_insert.extract_api_locations'

1050: l_upload_header_id NUMBER := null;
1051:
1052: BEGIN
1053: --
1054: hr_du_utility.message('ROUT','entry:hr_du_di_insert.extract_api_locations'
1055: , 5);
1056: --
1057: GENERAL_Extract (p_filehandle, p_upload_id, l_upload_header_id,
1058: l_Column_one_header, l_file_descriptor);

Line 1060: hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_api_locations'

1056: --
1057: GENERAL_Extract (p_filehandle, p_upload_id, l_upload_header_id,
1058: l_Column_one_header, l_file_descriptor);
1059: --
1060: hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_api_locations'
1061: , 10);
1062: --
1063:
1064: --error handling

Line 1067: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.extract_api_locations'

1063:
1064: --error handling
1065: EXCEPTION
1066: WHEN OTHERS THEN
1067: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.extract_api_locations'
1068: ,'(none)', 'R');
1069: RAISE;
1070:
1071: END EXTRACT_API_LOCATIONS;

Line 1093: hr_du_utility.message('ROUT','entry:hr_du_di_insert.extract_headers', 5);

1089: l_upload_header_id NUMBER := null;
1090:
1091: BEGIN
1092: --
1093: hr_du_utility.message('ROUT','entry:hr_du_di_insert.extract_headers', 5);
1094: --
1095: GENERAL_Extract(p_filehandle, p_upload_id, l_upload_header_id,
1096: l_Column_one_header, l_file_descriptor);
1097: VALIDATE_HEADER_DESCRIPTORS(p_upload_id);

Line 1099: hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_headers', 10);

1095: GENERAL_Extract(p_filehandle, p_upload_id, l_upload_header_id,
1096: l_Column_one_header, l_file_descriptor);
1097: VALIDATE_HEADER_DESCRIPTORS(p_upload_id);
1098: --
1099: hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_headers', 10);
1100: --
1101:
1102: --error handling
1103: EXCEPTION

Line 1105: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.extract_headers',

1101:
1102: --error handling
1103: EXCEPTION
1104: WHEN OTHERS THEN
1105: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.extract_headers',
1106: '(none)', 'R');
1107: RAISE;
1108:
1109: END EXTRACT_HEADERS;

Line 1136: hr_du_utility.message('ROUT','entry:hr_du_di_insert.extract_descriptors',

1132: l_reference_type VARCHAR2(100);
1133:
1134: BEGIN
1135: --
1136: hr_du_utility.message('ROUT','entry:hr_du_di_insert.extract_descriptors',
1137: 5);
1138: --
1139: GENERAL_Extract(p_filehandle, p_upload_id, p_upload_header_id,
1140: l_Column_one_header, l_file_descriptor);

Line 1154: hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_descriptors',

1150: (p_upload_header_id);
1151: HR_DU_RULES.API_PRESENT_AND_CORRECT
1152: (p_upload_header_id, p_upload_id);
1153: --
1154: hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_descriptors',
1155: 10);
1156: hr_du_utility.message('PARA', '(l_reference_type - ' || l_reference_type
1157: || ')' , 15);
1158: --

Line 1156: hr_du_utility.message('PARA', '(l_reference_type - ' || l_reference_type

1152: (p_upload_header_id, p_upload_id);
1153: --
1154: hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_descriptors',
1155: 10);
1156: hr_du_utility.message('PARA', '(l_reference_type - ' || l_reference_type
1157: || ')' , 15);
1158: --
1159:
1160: RETURN l_reference_type;

Line 1165: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.extract_descriptors',

1161:
1162: --error handling
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.extract_descriptors',
1166: '(none)', 'R');
1167: RAISE;
1168:
1169: END EXTRACT_DESCRIPTORS;

Line 1231: hr_du_utility.message('ROUT','entry:hr_du_di_insert.handle_api_files', 5);

1227:
1228:
1229: BEGIN
1230: --
1231: hr_du_utility.message('ROUT','entry:hr_du_di_insert.handle_api_files', 5);
1232: hr_du_utility.message('PARA', '(p_Location - ' || p_Location ||
1233: ')(p_upload_id - ' || p_upload_id || ')' , 10);
1234: --
1235: g_header_table.delete;

Line 1232: hr_du_utility.message('PARA', '(p_Location - ' || p_Location ||

1228:
1229: BEGIN
1230: --
1231: hr_du_utility.message('ROUT','entry:hr_du_di_insert.handle_api_files', 5);
1232: hr_du_utility.message('PARA', '(p_Location - ' || p_Location ||
1233: ')(p_upload_id - ' || p_upload_id || ')' , 10);
1234: --
1235: g_header_table.delete;
1236: OPEN csr_incorrect;

Line 1256: hr_du_utility.message('INFO','Insert statement', 15);

1252: INTO l_upload_header_id
1253: FROM dual;
1254:
1255:
1256: hr_du_utility.message('INFO','Insert statement', 15);
1257: --Creating upload_header
1258: INSERT INTO HR_DU_UPLOAD_HEADERS(
1259: UPLOAD_HEADER_ID, UPLOAD_ID, API_MODULE_ID, STATUS,
1260: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 1278: hr_du_utility.message('INFO','File Opened', 20);

1274:
1275: l_original_upload_header_id := l_upload_header_id;
1276: -- open the new file relating to the current API
1277: l_filehandle := Open_file (p_Location, l_file_record.VALUE);
1278: hr_du_utility.message('INFO','File Opened', 20);
1279:
1280: l_reference_type := Extract_descriptors(l_filehandle, p_upload_id,
1281: l_upload_header_id);
1282: hr_du_utility.message('INFO','Extracted Descriptors;', 25);

Line 1282: hr_du_utility.message('INFO','Extracted Descriptors;', 25);

1278: hr_du_utility.message('INFO','File Opened', 20);
1279:
1280: l_reference_type := Extract_descriptors(l_filehandle, p_upload_id,
1281: l_upload_header_id);
1282: hr_du_utility.message('INFO','Extracted Descriptors;', 25);
1283:
1284:
1285: l_found_value := FALSE;
1286: l_table_size := g_header_table.count;

Line 1287: hr_du_utility.message('INFO','l_table_size : ' || l_table_size , 30);

1283:
1284:
1285: l_found_value := FALSE;
1286: l_table_size := g_header_table.count;
1287: hr_du_utility.message('INFO','l_table_size : ' || l_table_size , 30);
1288:
1289:
1290: --This statement loops around the table checking to see whether
1291: --the API_module_id has already been assigned to an upload_header

Line 1332: hr_du_utility.message('ROUT','exit:hr_du_di_insert.handle_api_files', 30);

1328: END LOOP;
1329: CLOSE csr_files;
1330:
1331: --
1332: hr_du_utility.message('ROUT','exit:hr_du_di_insert.handle_api_files', 30);
1333: --
1334:
1335: --error handling
1336: EXCEPTION

Line 1338: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.handle_api_files',

1334:
1335: --error handling
1336: EXCEPTION
1337: WHEN e_fatal_error THEN
1338: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.handle_api_files',
1339: l_fatal_error_message, 'R');
1340: RAISE;
1341: WHEN OTHERS THEN
1342: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.handle_api_files',

Line 1342: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.handle_api_files',

1338: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.handle_api_files',
1339: l_fatal_error_message, 'R');
1340: RAISE;
1341: WHEN OTHERS THEN
1342: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.handle_api_files',
1343: '(none)', 'R');
1344: RAISE;
1345:
1346: END HANDLE_API_FILES;

Line 1398: hr_du_utility.message('ROUT',

1394: WHERE BUSINESS_GROUP_ID = l_business_group_id;
1395:
1396: BEGIN
1397: --
1398: hr_du_utility.message('ROUT',
1399: 'entry:hr_du_di_insert.update_upload_table', 5);
1400: hr_du_utility.message('PARA',
1401: '(p_upload_id - ' || p_upload_id || ')' , 10);
1402: --

Line 1400: hr_du_utility.message('PARA',

1396: BEGIN
1397: --
1398: hr_du_utility.message('ROUT',
1399: 'entry:hr_du_di_insert.update_upload_table', 5);
1400: hr_du_utility.message('PARA',
1401: '(p_upload_id - ' || p_upload_id || ')' , 10);
1402: --
1403:
1404: OPEN csr_batch_name;

Line 1427: hr_du_utility.message('INFO','l_business_group_profile - ' ||

1423: FETCH csr_business_group_lookup INTO l_business_group_profile;
1424: CLOSE csr_business_group_lookup;
1425:
1426: -- validate business groups
1427: hr_du_utility.message('INFO','l_business_group_profile - ' ||
1428: l_business_group_profile, 15);
1429: hr_du_utility.message('INFO','l_business_group_file - ' ||
1430: l_business_group_file, 15);
1431: hr_du_rules.validate_business_group(l_business_group_profile,

Line 1429: hr_du_utility.message('INFO','l_business_group_file - ' ||

1425:
1426: -- validate business groups
1427: hr_du_utility.message('INFO','l_business_group_profile - ' ||
1428: l_business_group_profile, 15);
1429: hr_du_utility.message('INFO','l_business_group_file - ' ||
1430: l_business_group_file, 15);
1431: hr_du_rules.validate_business_group(l_business_group_profile,
1432: l_business_group_file);
1433:

Line 1448: hr_du_utility.message('INFO','Using business group name - ' ||

1444: ELSE
1445: l_business_group_name := l_business_group_profile;
1446: END IF;
1447:
1448: hr_du_utility.message('INFO','Using business group name - ' ||
1449: NVL(l_business_group_name,'NULL'), 15);
1450:
1451:
1452: UPDATE hr_du_uploads

Line 1481: hr_du_utility.message('INFO','Row inserted into descriptors table', 15);

1477: 1,
1478: 1,
1479: 1,
1480: sysdate);
1481: hr_du_utility.message('INFO','Row inserted into descriptors table', 15);
1482: COMMIT;
1483: ELSE
1484: hr_du_utility.message('INFO','Row updated in descriptors table', 20);
1485: END IF;

Line 1484: hr_du_utility.message('INFO','Row updated in descriptors table', 20);

1480: sysdate);
1481: hr_du_utility.message('INFO','Row inserted into descriptors table', 15);
1482: COMMIT;
1483: ELSE
1484: hr_du_utility.message('INFO','Row updated in descriptors table', 20);
1485: END IF;
1486:
1487: --
1488: hr_du_utility.message('ROUT',

Line 1488: hr_du_utility.message('ROUT',

1484: hr_du_utility.message('INFO','Row updated in descriptors table', 20);
1485: END IF;
1486:
1487: --
1488: hr_du_utility.message('ROUT',
1489: 'exit:hr_du_di_insert.update_upload_table', 25);
1490: --
1491:
1492: --error handling

Line 1495: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.update_upload_table',

1491:
1492: --error handling
1493: EXCEPTION
1494: WHEN e_fatal_error THEN
1495: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.update_upload_table',
1496: l_fatal_error_message, 'R');
1497: RAISE;
1498: WHEN OTHERS THEN
1499: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.update_upload_table',

Line 1499: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.update_upload_table',

1495: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.update_upload_table',
1496: l_fatal_error_message, 'R');
1497: RAISE;
1498: WHEN OTHERS THEN
1499: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.update_upload_table',
1500: '(none)', 'R');
1501: RAISE;
1502:
1503: END UPDATE_UPLOAD_TABLE;

Line 1529: hr_du_utility.message('ROUT','entry:hr_du_di_insert.return_file_name', 5);

1525: l_source_name VARCHAR2(50);
1526:
1527: BEGIN
1528: --
1529: hr_du_utility.message('ROUT','entry:hr_du_di_insert.return_file_name', 5);
1530: hr_du_utility.message('PARA',
1531: '(p_upload_id - ' || p_upload_id || ')' , 10);
1532: --
1533: OPEN csr_source;

Line 1530: hr_du_utility.message('PARA',

1526:
1527: BEGIN
1528: --
1529: hr_du_utility.message('ROUT','entry:hr_du_di_insert.return_file_name', 5);
1530: hr_du_utility.message('PARA',
1531: '(p_upload_id - ' || p_upload_id || ')' , 10);
1532: --
1533: OPEN csr_source;
1534: FETCH csr_source INTO l_source_name;

Line 1542: hr_du_utility.message('ROUT','exit:hr_du_di_insert.return_file_name', 15);

1538: RAISE e_fatal_error;
1539: END IF;
1540: CLOSE csr_source;
1541: --
1542: hr_du_utility.message('ROUT','exit:hr_du_di_insert.return_file_name', 15);
1543: hr_du_utility.message('PARA', '(l_source_name - ' || l_source_name ||
1544: ')' , 20);
1545: --
1546: RETURN l_source_name;

Line 1543: hr_du_utility.message('PARA', '(l_source_name - ' || l_source_name ||

1539: END IF;
1540: CLOSE csr_source;
1541: --
1542: hr_du_utility.message('ROUT','exit:hr_du_di_insert.return_file_name', 15);
1543: hr_du_utility.message('PARA', '(l_source_name - ' || l_source_name ||
1544: ')' , 20);
1545: --
1546: RETURN l_source_name;
1547:

Line 1551: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_file_name',

1547:
1548: --error handling
1549: EXCEPTION
1550: WHEN e_fatal_error THEN
1551: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_file_name',
1552: l_fatal_error_message, 'R');
1553: RAISE;
1554: WHEN OTHERS THEN
1555: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_file_name',

Line 1555: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_file_name',

1551: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_file_name',
1552: l_fatal_error_message, 'R');
1553: RAISE;
1554: WHEN OTHERS THEN
1555: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_file_name',
1556: '(none)', 'R');
1557: RAISE;
1558:
1559: END RETURN_FILE_NAME;

Line 1589: hr_du_utility.message('ROUT','entry:hr_du_di_insert.open_file', 5);

1585: l_valid_profile VARCHAR2(2000);
1586: --
1587: BEGIN
1588: --
1589: hr_du_utility.message('ROUT','entry:hr_du_di_insert.open_file', 5);
1590: hr_du_utility.message('PARA', '(p_file_location - ' || p_file_location ||
1591: ')(p_file_name - ' || p_file_name || ')' , 10);
1592: --
1593: OPEN csr_valid_profile;

Line 1590: hr_du_utility.message('PARA', '(p_file_location - ' || p_file_location ||

1586: --
1587: BEGIN
1588: --
1589: hr_du_utility.message('ROUT','entry:hr_du_di_insert.open_file', 5);
1590: hr_du_utility.message('PARA', '(p_file_location - ' || p_file_location ||
1591: ')(p_file_name - ' || p_file_name || ')' , 10);
1592: --
1593: OPEN csr_valid_profile;
1594: FETCH csr_valid_profile INTO l_valid_profile;

Line 1601: hr_du_utility.message('SUMM', 'File name ->' || p_file_name , 25);

1597: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
1598: --
1599: -- Output additional information to the log file concerning header file
1600: --
1601: hr_du_utility.message('SUMM', 'File name ->' || p_file_name , 25);
1602: hr_du_utility.message('SUMM', 'File location/HR: Data Exchange Directory profile option->' || l_location , 30);
1603: hr_du_utility.message('SUMM', 'Valid options for HR: Data Exchange Directory profile ->' || l_valid_profile , 35);
1604: --
1605: l_filehandle := utl_file.fopen(p_file_location, p_file_name, 'r', 32767);

Line 1602: hr_du_utility.message('SUMM', 'File location/HR: Data Exchange Directory profile option->' || l_location , 30);

1598: --
1599: -- Output additional information to the log file concerning header file
1600: --
1601: hr_du_utility.message('SUMM', 'File name ->' || p_file_name , 25);
1602: hr_du_utility.message('SUMM', 'File location/HR: Data Exchange Directory profile option->' || l_location , 30);
1603: hr_du_utility.message('SUMM', 'Valid options for HR: Data Exchange Directory profile ->' || l_valid_profile , 35);
1604: --
1605: l_filehandle := utl_file.fopen(p_file_location, p_file_name, 'r', 32767);
1606: g_counter := 0;

Line 1603: hr_du_utility.message('SUMM', 'Valid options for HR: Data Exchange Directory profile ->' || l_valid_profile , 35);

1599: -- Output additional information to the log file concerning header file
1600: --
1601: hr_du_utility.message('SUMM', 'File name ->' || p_file_name , 25);
1602: hr_du_utility.message('SUMM', 'File location/HR: Data Exchange Directory profile option->' || l_location , 30);
1603: hr_du_utility.message('SUMM', 'Valid options for HR: Data Exchange Directory profile ->' || l_valid_profile , 35);
1604: --
1605: l_filehandle := utl_file.fopen(p_file_location, p_file_name, 'r', 32767);
1606: g_counter := 0;
1607: --

Line 1608: hr_du_utility.message('ROUT','exit:hr_du_di_insert.open_file', 15);

1604: --
1605: l_filehandle := utl_file.fopen(p_file_location, p_file_name, 'r', 32767);
1606: g_counter := 0;
1607: --
1608: hr_du_utility.message('ROUT','exit:hr_du_di_insert.open_file', 15);
1609: hr_du_utility.message('PARA', '(l_filehandle - File Type )' , 20);
1610: --
1611: RETURN l_filehandle;
1612: --error handling

Line 1609: hr_du_utility.message('PARA', '(l_filehandle - File Type )' , 20);

1605: l_filehandle := utl_file.fopen(p_file_location, p_file_name, 'r', 32767);
1606: g_counter := 0;
1607: --
1608: hr_du_utility.message('ROUT','exit:hr_du_di_insert.open_file', 15);
1609: hr_du_utility.message('PARA', '(l_filehandle - File Type )' , 20);
1610: --
1611: RETURN l_filehandle;
1612: --error handling
1613: EXCEPTION

Line 1615: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.Open_file',

1611: RETURN l_filehandle;
1612: --error handling
1613: EXCEPTION
1614: WHEN OTHERS THEN
1615: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.Open_file',
1616: ' ERROR Opening - ' || p_file_name ||
1617: '. File may not exist or spelt incorrectly', 'R');
1618: RAISE;
1619:

Line 1669: hr_du_utility.message('ROUT','entry:hr_du_di_insert.extract_lines', 5);

1665: l_header_file VARCHAR2(200);
1666:
1667: BEGIN
1668: --
1669: hr_du_utility.message('ROUT','entry:hr_du_di_insert.extract_lines', 5);
1670: hr_du_utility.message('ROUT', '(p_filehandle - File Type )' ||
1671: '(p_upload_id - ' || p_upload_id ||
1672: ')(p_original_upload_header_id - ' || p_original_upload_header_id ||
1673: ')(p_reference_type - ' || p_reference_type ||

Line 1670: hr_du_utility.message('ROUT', '(p_filehandle - File Type )' ||

1666:
1667: BEGIN
1668: --
1669: hr_du_utility.message('ROUT','entry:hr_du_di_insert.extract_lines', 5);
1670: hr_du_utility.message('ROUT', '(p_filehandle - File Type )' ||
1671: '(p_upload_id - ' || p_upload_id ||
1672: ')(p_original_upload_header_id - ' || p_original_upload_header_id ||
1673: ')(p_reference_type - ' || p_reference_type ||
1674: ')(p_api_module_id - ' || p_api_module_id ||

Line 1678: l_chunk_size_master := hr_du_utility.chunk_size;

1674: ')(p_api_module_id - ' || p_api_module_id ||
1675: ')(p_upload_header_id - ' || p_upload_header_id ||
1676: ')' , 10);
1677: --
1678: l_chunk_size_master := hr_du_utility.chunk_size;
1679:
1680: LOOP
1681: BEGIN
1682: l_data_line := next_line(p_filehandle, p_original_upload_header_id);

Line 1683: hr_du_utility.message('INFO',

1679:
1680: LOOP
1681: BEGIN
1682: l_data_line := next_line(p_filehandle, p_original_upload_header_id);
1683: hr_du_utility.message('INFO',
1684: 'Data Line Header - ' || l_data_line , 15);
1685: --call return_word to get the first word which is the descriptor
1686: l_Col_one := Return_Word (l_data_line, 1);
1687: l_Col_two := Return_Word (l_data_line, 2);

Line 1713: hr_du_utility.message('INFO','Data Line Data - ' || l_data_line , 20);

1709: LOOP
1710: BEGIN
1711:
1712: l_data_line := next_line(p_filehandle, p_original_upload_header_id);
1713: hr_du_utility.message('INFO','Data Line Data - ' || l_data_line , 20);
1714:
1715: --Add loop to check that there is valid data on the line and it
1716: --isn't just tabs and spaces.
1717:

Line 1799: hr_du_utility.message('INFO','Insert Statement Start ' , 25);

1795: IF (p_original_upload_header_id <> p_upload_header_id) AND
1796: (l_line_type = 'C') THEN
1797: null;
1798: ELSE
1799: hr_du_utility.message('INFO','Insert Statement Start ' , 25);
1800:
1801: INSERT INTO hr_du_upload_lines(
1802: UPLOAD_LINE_ID, UPLOAD_HEADER_ID, BATCH_LINE_ID,
1803: STATUS, REFERENCE_TYPE, LINE_TYPE, LAST_UPDATE_DATE,

Line 1936: hr_du_utility.message('INFO','Insert Statement End ' , 30);

1932: ELSE
1933: l_chunk_size_slave := l_chunk_size_slave - 1;
1934: END IF;
1935: END IF;
1936: hr_du_utility.message('INFO','Insert Statement End ' , 30);
1937: END IF;
1938: l_line_type := 'D';
1939:
1940: EXCEPTION

Line 1949: hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_lines', 35);

1945: END LOOP;
1946: --commit to make sure everything has been committed
1947: COMMIT;
1948: --
1949: hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_lines', 35);
1950: --
1951:
1952: --error handling
1953: EXCEPTION

Line 1955: hr_du_utility.error(SQLCODE,

1951:
1952: --error handling
1953: EXCEPTION
1954: WHEN e_fatal_error THEN
1955: hr_du_utility.error(SQLCODE,
1956: 'hr_du_di_insert.extract_lines',l_fatal_error_message, 'R');
1957: RAISE;
1958: WHEN OTHERS THEN
1959: hr_du_utility.error(SQLCODE,

Line 1959: hr_du_utility.error(SQLCODE,

1955: hr_du_utility.error(SQLCODE,
1956: 'hr_du_di_insert.extract_lines',l_fatal_error_message, 'R');
1957: RAISE;
1958: WHEN OTHERS THEN
1959: hr_du_utility.error(SQLCODE,
1960: 'hr_du_di_insert.extract_lines','(none)', 'R');
1961: RAISE;
1962:
1963: END Extract_lines;

Line 1987: hr_du_utility.message('ROUT','entry:hr_du_di_insert.ordered_sequence', 5);

1983: l_file_name VARCHAR2(2000);
1984:
1985: BEGIN
1986: --
1987: hr_du_utility.message('ROUT','entry:hr_du_di_insert.ordered_sequence', 5);
1988: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')',10);
1989: --
1990:
1991: g_flat_file_delimiter := g_tab_delimiter;

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

1984:
1985: BEGIN
1986: --
1987: hr_du_utility.message('ROUT','entry:hr_du_di_insert.ordered_sequence', 5);
1988: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')',10);
1989: --
1990:
1991: g_flat_file_delimiter := g_tab_delimiter;
1992: g_current_delimiter := g_flat_file_delimiter;

Line 2009: hr_du_utility.message('ROUT','exit:hr_du_di_insert.ordered_sequence', 15);

2005:
2006: Handle_API_Files (l_location, p_upload_id);
2007:
2008: --
2009: hr_du_utility.message('ROUT','exit:hr_du_di_insert.ordered_sequence', 15);
2010: --
2011:
2012: --error handling
2013: EXCEPTION

Line 2015: hr_du_utility.error(SQLCODE,

2011:
2012: --error handling
2013: EXCEPTION
2014: WHEN OTHERS THEN
2015: hr_du_utility.error(SQLCODE,
2016: 'hr_du_di_insert.ordered_sequence','(none)', 'R');
2017: RAISE;
2018:
2019: END ORDERED_SEQUENCE;

Line 2035: hr_du_utility.message('ROUT','entry:hr_du_di_insert.validate', 5);

2031: l_temp VARCHAR2(20);
2032:
2033: BEGIN
2034: --
2035: hr_du_utility.message('ROUT','entry:hr_du_di_insert.validate', 5);
2036: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')',
2037: 10);
2038: --
2039: l_temp := null;

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

2032:
2033: BEGIN
2034: --
2035: hr_du_utility.message('ROUT','entry:hr_du_di_insert.validate', 5);
2036: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')',
2037: 10);
2038: --
2039: l_temp := null;
2040: --

Line 2041: hr_du_utility.message('ROUT','exit:hr_du_di_insert.validate', 15);

2037: 10);
2038: --
2039: l_temp := null;
2040: --
2041: hr_du_utility.message('ROUT','exit:hr_du_di_insert.validate', 15);
2042: --
2043:
2044: --
2045: EXCEPTION

Line 2047: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate',

2043:
2044: --
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate',
2048: '(none)', 'R');
2049: RAISE;
2050: --
2051: END VALIDATE;

Line 2067: hr_du_utility.message('ROUT','entry:hr_du_di_insert.rollback', 5);

2063: PROCEDURE ROLLBACK(p_upload_id IN NUMBER) IS
2064:
2065: BEGIN
2066: --
2067: hr_du_utility.message('ROUT','entry:hr_du_di_insert.rollback', 5);
2068: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')',
2069: 10);
2070: --
2071:

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

2064:
2065: BEGIN
2066: --
2067: hr_du_utility.message('ROUT','entry:hr_du_di_insert.rollback', 5);
2068: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')',
2069: 10);
2070: --
2071:
2072: DELETE FROM HR_DU_DESCRIPTORS

Line 2087: hr_du_utility.message('ROUT','exit:hr_du_di_insert.rollback', 15);

2083: WHERE UPLOAD_ID = p_upload_id;
2084: COMMIT;
2085:
2086: --
2087: hr_du_utility.message('ROUT','exit:hr_du_di_insert.rollback', 15);
2088: --
2089:
2090: --
2091: EXCEPTION

Line 2093: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.rollback',

2089:
2090: --
2091: EXCEPTION
2092: WHEN OTHERS THEN
2093: hr_du_utility.error(SQLCODE, 'hr_du_di_insert.rollback',
2094: '(none)', 'R');
2095: RAISE;
2096: --
2097: END ROLLBACK;