eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DU_DP_PC_CONVERSION dependencies on HR_DU_UTILITY

Line 10: g_space VARCHAR2(100) := hr_du_utility.local_CHR(32);

6:
7: g_insert_table INSERT_TABLE_TYPE;
8: g_column_headings COLUMN_HEADINGS_TABLE;
9: g_column_mapped_to COLUMN_MAPPED_TO_TABLE;
10: g_space VARCHAR2(100) := hr_du_utility.local_CHR(32);
11: g_start_table STARTING_POINT_TABLE;
12:
13: /*-------------------------------------------------------------------------*/
14:

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

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

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

34: BEGIN
35: --
36: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.
37: store_column_mappings', 5);
38: hr_du_utility.message('PARA', '(p_api_module_id - ' || p_api_module_id ||
39: ')' , 10);
40:
41: OPEN csr_mapped_to_name;
42: --

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

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

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

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

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

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

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

84: BEGIN
85: --
86: hr_du_utility.message('ROUT','entry:hr_du_dp_pc_conversion.
87: store_column_headings', 5);
88: hr_du_utility.message('PARA', '(p_line_id - ' || p_line_id || ')'
89: , 10);
90:
91: hr_du_utility.message('INFO','Select Statement Start ' , 15);
92:

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

87: store_column_headings', 5);
88: hr_du_utility.message('PARA', '(p_line_id - ' || p_line_id || ')'
89: , 10);
90:
91: hr_du_utility.message('INFO','Select Statement Start ' , 15);
92:
93: SELECT
94: PVAL001, PVAL002, PVAL003, PVAL004 , PVAL005 , PVAL006,
95: PVAL007, PVAL008, PVAL009, PVAL010 , PVAL011, PVAL012,

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

210: g_column_headings(229),g_column_headings(230)
211: FROM HR_DU_UPLOAD_LINES
212: WHERE UPLOAD_LINE_ID = p_line_id;
213:
214: hr_du_utility.message('INFO','Select Statement Ends ' , 20);
215:
216: --
217: hr_du_utility.message('ROUT','exit:hr_du_dp_pc_conversion.' ||
218: ' store_column_headings', 25);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 343: --hr_du_utility.message('ROUT',

339: l_new_word VARCHAR2(2000);
340:
341: BEGIN
342:
343: --hr_du_utility.message('ROUT',
344: -- 'entry:hr_du_dp_pc_conversion.remove_spaces', 5);
345: --hr_du_utility.message('PARA',
346: -- '(p_word - ' || p_word || ')' , 10);
347:

Line 345: --hr_du_utility.message('PARA',

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

Line 355: --hr_du_utility.message('INFO', 'l_word_length - ' || l_word_length, 99);

351: IF l_word_length IS NULL THEN
352: l_word_length := 0;
353: END IF;
354:
355: --hr_du_utility.message('INFO', 'l_word_length - ' || l_word_length, 99);
356:
357: IF l_word_length = 1 AND p_word = g_space THEN
358: p_word := NULL;
359: l_exit_1 := TRUE;

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

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

Line 456: hr_du_utility.message('ROUT',

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

Line 459: hr_du_utility.message('PARA', '(p_array_pos - ' || p_array_pos || ')'

455: --
456: hr_du_utility.message('ROUT',
457: 'entry:hr_du_dp_pc_conversion.cp_referencing_columns',
458: 5);
459: hr_du_utility.message('PARA', '(p_array_pos - ' || p_array_pos || ')'
460: , 10);
461: --
462: l_string_apis := null;
463: l_api_PVALS := null;

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

481: FETCH csr_parent_table_column INTO l_parent_table;
482: IF csr_parent_table_column%FOUND THEN
483: --loop through the column headings again to search for the
484: --position in the line of where the api module id will be stored
485: hr_du_utility.message('INFO', l_parent_table, 15);
486: FOR j IN 1..230 LOOP
487: --
488: l_inner_pval := LPAD(j,3,'0');
489: l_inner_pval := 'PVAL' || l_inner_pval;

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

489: l_inner_pval := 'PVAL' || l_inner_pval;
490:
491: l_inner_field := g_column_headings(j);
492:
493: hr_du_utility.message('INFO', l_inner_field, 20);
494:
495: IF l_parent_table = l_inner_field THEN
496: --found the exact position in the line where the api id
497: --from the calling table will be stored (l_inner_pval).

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

511: CLOSE csr_parent_table_column;
512: --
513: ELSE
514: --
515: hr_du_utility.message('INFO', l_parent_api_module_id , 25);
516: l_string_apis := l_string_apis || l_parent_api_module_id || ',';
517: l_api_PVALS := l_api_PVALS || l_current_pval || ',';
518: --
519: END IF;

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

527: g_insert_table(p_array_pos).r_string_apis := l_string_apis;
528: g_insert_table(p_array_pos).r_api_PVALS := l_api_PVALS;
529: g_insert_table(p_array_pos).r_generic_pval := l_generic_pval;
530:
531: hr_du_utility.message('INFO', 'l_string_apis : ' || l_string_apis , 30);
532: hr_du_utility.message('INFO', 'l_api_PVALS : ' || l_api_PVALS , 35);
533: hr_du_utility.message('INFO', 'l_generic_pval : ' || l_generic_pval , 40);
534:
535: --

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

528: g_insert_table(p_array_pos).r_api_PVALS := l_api_PVALS;
529: g_insert_table(p_array_pos).r_generic_pval := l_generic_pval;
530:
531: hr_du_utility.message('INFO', 'l_string_apis : ' || l_string_apis , 30);
532: hr_du_utility.message('INFO', 'l_api_PVALS : ' || l_api_PVALS , 35);
533: hr_du_utility.message('INFO', 'l_generic_pval : ' || l_generic_pval , 40);
534:
535: --
536: hr_du_utility.message('ROUT',

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

529: g_insert_table(p_array_pos).r_generic_pval := l_generic_pval;
530:
531: hr_du_utility.message('INFO', 'l_string_apis : ' || l_string_apis , 30);
532: hr_du_utility.message('INFO', 'l_api_PVALS : ' || l_api_PVALS , 35);
533: hr_du_utility.message('INFO', 'l_generic_pval : ' || l_generic_pval , 40);
534:
535: --
536: hr_du_utility.message('ROUT',
537: 'exit:hr_du_dp_pc_conversion.cp_referencing_columns', 45);

Line 536: hr_du_utility.message('ROUT',

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

Line 541: hr_du_utility.error(SQLCODE,

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

Line 566: hr_du_utility.message('ROUT',

562: l_string_length NUMBER;
563:
564: BEGIN
565: --
566: hr_du_utility.message('ROUT',
567: 'entry:hr_du_dp_pc_conversion.API_MODULE_id_to_table_id', 5);
568: --
569:
570:

Line 587: hr_du_utility.message('INFO', g_insert_table(i).r_ref_Col_apis , 10);

583:
584: l_number_references :=
585: hr_du_di_insert.WORDS_ON_LINE(g_insert_table(i).r_ref_Col_apis);
586:
587: hr_du_utility.message('INFO', g_insert_table(i).r_ref_Col_apis , 10);
588:
589: --loop around for each reference trying to match its api id with the
590: --table id
591: FOR j IN 1..l_number_references LOOP

Line 600: hr_du_utility.message('INFO', l_reference_pval , 15);

596:
597: l_reference_pval := hr_du_di_insert.Return_Word(
598: g_insert_table(i).r_ref_Col_apis, j);
599:
600: hr_du_utility.message('INFO', l_reference_pval , 15);
601:
602: --create a string with the corresponding PL/SQL table id's
603: FOR k IN 1..l_size LOOP
604: IF l_reference_pval = g_insert_table(k).r_api_id THEN

Line 613: hr_du_utility.message('INFO', 'l_new_string : ' || l_new_string , 20);

609: END LOOP;
610: l_length := LENGTHB(',');
611: l_string_length := LENGTHB(l_new_string);
612: l_new_string := SUBSTRB(l_new_string,1, (l_string_length - l_length ));
613: hr_du_utility.message('INFO', 'l_new_string : ' || l_new_string , 20);
614:
615: --replace the old R_REF_COL_APIS with the new_string
616: g_insert_table(i).r_ref_Col_apis := l_new_string;
617: END IF;

Line 621: hr_du_utility.message('ROUT',

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

Line 627: hr_du_utility.error(SQLCODE,

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

Line 669: hr_du_utility.message('ROUT',

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

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

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

Line 688: hr_du_utility.message('ROUT',

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

Line 690: hr_du_utility.message('PARA', '(l_parent_api_module_id - ' ||

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

Line 697: hr_du_utility.error(SQLCODE,

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

Line 702: hr_du_utility.error(SQLCODE,

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

Line 742: hr_du_utility.message('ROUT',

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

Line 744: hr_du_utility.message('PARA', '(p_table - ' || p_table ||

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

Line 754: hr_du_utility.message('INFO', l_dyn_sql , 15);

750:
751: l_dyn_sql := 'SELECT ' || p_field_name ||' FROM ' || p_table ||
752: ' WHERE ' || p_field_pk || ' = ' || p_record_id;
753:
754: hr_du_utility.message('INFO', l_dyn_sql , 15);
755:
756: hr_du_utility.dynamic_sql_str(l_dyn_sql, l_field_value, 2000);
757:
758: --

Line 756: hr_du_utility.dynamic_sql_str(l_dyn_sql, l_field_value, 2000);

752: ' WHERE ' || p_field_pk || ' = ' || p_record_id;
753:
754: hr_du_utility.message('INFO', l_dyn_sql , 15);
755:
756: hr_du_utility.dynamic_sql_str(l_dyn_sql, l_field_value, 2000);
757:
758: --
759: hr_du_utility.message('ROUT',
760: 'exit:hr_du_dp_pc_conversion.return_field_value', 20);

Line 759: hr_du_utility.message('ROUT',

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

Line 761: hr_du_utility.message('PARA', '(l_field_value - ' || l_field_value || ')',

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

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

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

Line 809: hr_du_utility.message('ROUT',

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

Line 811: hr_du_utility.message('PARA', '(p_upload_line_id - ' || p_upload_line_id ||

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

Line 827: hr_du_utility.message('ROUT',

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

Line 829: hr_du_utility.message('PARA', '(l_max_number - ' || l_max_number || ')'

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

Line 837: hr_du_utility.error(SQLCODE,

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

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

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

Line 885: hr_du_utility.message('ROUT',

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

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

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

Line 901: hr_du_utility.message('ROUT',

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

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

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

Line 911: hr_du_utility.error(SQLCODE,

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

Line 956: hr_du_utility.error(SQLCODE,

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

Line 1017: hr_du_utility.message('ROUT',

1013: l_temp_varchar VARCHAR2(2000);
1014:
1015: BEGIN
1016: --
1017: hr_du_utility.message('ROUT',
1018: 'entry:hr_du_dp_pc_conversion.insert_api_module_ids', 5);
1019: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1020: --
1021:

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

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

Line 1051: hr_du_utility.message('ROUT',

1047: SWITCH_REFERENCING_INITIAL(p_upload_id);
1048: END IF;
1049:
1050: --
1051: hr_du_utility.message('ROUT',
1052: 'exit:hr_du_dp_pc_conversion.insert_api_module_ids', 15);
1053: --
1054:
1055: EXCEPTION

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

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

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

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

Line 1134: hr_du_utility.message('ROUT',

1130: AND upper(api.module_name) = upper(des.descriptor);
1131:
1132: BEGIN
1133: --
1134: hr_du_utility.message('ROUT',
1135: 'entry:hr_du_dp_pc_conversion.create_insert_string', 5);
1136: hr_du_utility.message('PARA', '(p_api_module_id - ' || p_api_module_id ||
1137: ')(p_upload_header_id - ' || p_upload_header_id ||
1138: ')(p_array_pos - ' || p_array_pos || ')' ,

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

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

Line 1181: hr_du_utility.message('INFO', 'l_pval_field (with spaces removed) : '

1177: l_pval_field := g_column_headings(i);
1178: --
1179: REMOVE_SPACES (l_pval_field, l_spaces);
1180: IF l_spaces = TRUE THEN
1181: hr_du_utility.message('INFO', 'l_pval_field (with spaces removed) : '
1182: || l_pval_field , 20);
1183: END IF;
1184:
1185: --checks to see if the l_pval_field is a ('D') datapump column, if it

Line 1228: l_spreadsheet_cell := hr_du_utility.Return_Spreadsheet_row(i);

1224: OPEN csr_api_file;
1225: FETCH csr_api_file INTO l_api_name;
1226: CLOSE csr_api_file;
1227:
1228: l_spreadsheet_cell := hr_du_utility.Return_Spreadsheet_row(i);
1229: l_fatal_error_message := 'In ' || l_api_name ||
1230: ' there is an invalid column name within cell ' ||
1231: l_spreadsheet_cell || l_di_line_number;
1232: RAISE e_fatal_error;

Line 1266: hr_du_utility.message('INFO', l_pval_string, 15);

1262: g_insert_table(p_array_pos).r_id_curval := l_id_currval;
1263: g_insert_table(p_array_pos).r_ref_Col_Names := l_reference_string;
1264: g_insert_table(p_array_pos).r_ref_Col_apis := l_api_module_id_string;
1265:
1266: hr_du_utility.message('INFO', l_pval_string, 15);
1267: hr_du_utility.message('INFO', l_pval_reference, 20);
1268: hr_du_utility.message('INFO', l_id_currval, 30);
1269: hr_du_utility.message('INFO', l_reference_string, 35);
1270: hr_du_utility.message('INFO', l_api_module_id_string, 45);

Line 1267: hr_du_utility.message('INFO', l_pval_reference, 20);

1263: g_insert_table(p_array_pos).r_ref_Col_Names := l_reference_string;
1264: g_insert_table(p_array_pos).r_ref_Col_apis := l_api_module_id_string;
1265:
1266: hr_du_utility.message('INFO', l_pval_string, 15);
1267: hr_du_utility.message('INFO', l_pval_reference, 20);
1268: hr_du_utility.message('INFO', l_id_currval, 30);
1269: hr_du_utility.message('INFO', l_reference_string, 35);
1270: hr_du_utility.message('INFO', l_api_module_id_string, 45);
1271:

Line 1268: hr_du_utility.message('INFO', l_id_currval, 30);

1264: g_insert_table(p_array_pos).r_ref_Col_apis := l_api_module_id_string;
1265:
1266: hr_du_utility.message('INFO', l_pval_string, 15);
1267: hr_du_utility.message('INFO', l_pval_reference, 20);
1268: hr_du_utility.message('INFO', l_id_currval, 30);
1269: hr_du_utility.message('INFO', l_reference_string, 35);
1270: hr_du_utility.message('INFO', l_api_module_id_string, 45);
1271:
1272:

Line 1269: hr_du_utility.message('INFO', l_reference_string, 35);

1265:
1266: hr_du_utility.message('INFO', l_pval_string, 15);
1267: hr_du_utility.message('INFO', l_pval_reference, 20);
1268: hr_du_utility.message('INFO', l_id_currval, 30);
1269: hr_du_utility.message('INFO', l_reference_string, 35);
1270: hr_du_utility.message('INFO', l_api_module_id_string, 45);
1271:
1272:
1273: --change the status of the PC row column heading to show that

Line 1270: hr_du_utility.message('INFO', l_api_module_id_string, 45);

1266: hr_du_utility.message('INFO', l_pval_string, 15);
1267: hr_du_utility.message('INFO', l_pval_reference, 20);
1268: hr_du_utility.message('INFO', l_id_currval, 30);
1269: hr_du_utility.message('INFO', l_reference_string, 35);
1270: hr_du_utility.message('INFO', l_api_module_id_string, 45);
1271:
1272:
1273: --change the status of the PC row column heading to show that
1274: --I've completed

Line 1280: hr_du_utility.message('ROUT',

1276: SET status = 'C'
1277: WHERE upload_line_id = l_line_id;
1278:
1279: --
1280: hr_du_utility.message('ROUT',
1281: 'exit:hr_du_dp_pc_conversion.create_insert_string', 50);
1282: --
1283:
1284: EXCEPTION

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

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

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

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

Line 1352: hr_du_utility.message('ROUT',

1348: WHERE upload_line_id = l_upload_line_id;
1349:
1350: BEGIN
1351: --
1352: hr_du_utility.message('ROUT',
1353: 'entry:hr_du_dp_pc_conversion.switch_referencing_initial', 5);
1354: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1355: --
1356:

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

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

Line 1442: hr_du_utility.message('INFO','ID value of the upload_line ' ||

1438: END IF;
1439: --
1440: CLOSE csr_field_value;
1441:
1442: hr_du_utility.message('INFO','ID value of the upload_line ' ||
1443: l_row_id, 15);
1444: hr_du_utility.message('INFO','api_module ID associated with ' ||
1445: 'the ID value ' || 1, 20);
1446:

Line 1444: hr_du_utility.message('INFO','api_module ID associated with ' ||

1440: CLOSE csr_field_value;
1441:
1442: hr_du_utility.message('INFO','ID value of the upload_line ' ||
1443: l_row_id, 15);
1444: hr_du_utility.message('INFO','api_module ID associated with ' ||
1445: 'the ID value ' || 1, 20);
1446:
1447: --recursive function PROCESS_LINE is initiated on the chosen
1448: --row_id

Line 1502: hr_du_utility.message('ROUT',

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

Line 1508: hr_du_utility.error(SQLCODE,

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

Line 1513: hr_du_utility.error(SQLCODE,

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

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

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

Line 1586: hr_du_utility.message('PARA', '(p_prev_upload_line_id - ' ||

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

Line 1635: hr_du_utility.message('INFO', 'l_upload_line_id : ' || l_upload_line_id, 15);

1631: p_target_ID;
1632: RAISE e_fatal_error;
1633: END;
1634:
1635: hr_du_utility.message('INFO', 'l_upload_line_id : ' || l_upload_line_id, 15);
1636:
1637: --change the status of the PC row to show we're processing this
1638: UPDATE hr_du_upload_lines
1639: SET status = 'S'

Line 1683: hr_du_utility.message('INFO', l_built_up_string1 || l_date_string ||

1679: --in the PL/SQL table
1680: g_insert_table(p_target_api_module).r_id_curval :=
1681: g_insert_table(p_target_api_module).r_id_curval + 1;
1682:
1683: hr_du_utility.message('INFO', l_built_up_string1 || l_date_string ||
1684: l_built_up_string2 || l_date_string || l_built_up_string3, 20);
1685:
1686: hr_du_utility.dynamic_sql(l_built_up_string1 || l_date_string ||
1687: l_built_up_string2 || l_date_string || l_built_up_string3);

Line 1686: hr_du_utility.dynamic_sql(l_built_up_string1 || l_date_string ||

1682:
1683: hr_du_utility.message('INFO', l_built_up_string1 || l_date_string ||
1684: l_built_up_string2 || l_date_string || l_built_up_string3, 20);
1685:
1686: hr_du_utility.dynamic_sql(l_built_up_string1 || l_date_string ||
1687: l_built_up_string2 || l_date_string || l_built_up_string3);
1688:
1689: --Next step is to see if there are any referencing columns
1690: --associated with the api_module

Line 1710: hr_du_utility.message('INFO', 'l_reference_pval : '

1706:
1707: l_reference_pval := hr_du_di_insert.Return_Word(
1708: g_insert_table(p_target_api_module).r_ref_PVAL, i);
1709:
1710: hr_du_utility.message('INFO', 'l_reference_pval : '
1711: || l_reference_pval, 25);
1712:
1713: --identify the target row in the PL/SQL table that holds all of the
1714: --information on that particular api_module

Line 1721: hr_du_utility.message('INFO', 'l_target_api_module : '

1717:
1718: l_target_api_module := hr_du_di_insert.Return_Word(
1719: g_insert_table(p_target_api_module).r_ref_Col_apis, i);
1720:
1721: hr_du_utility.message('INFO', 'l_target_api_module : '
1722: || l_target_api_module, 30);
1723:
1724: --Target the value of the cell with the appropriate PVAL*** supplied
1725: --by l_reference_pval

Line 1732: hr_du_utility.message('INFO', 'l_cell_value (with spaces removed) : '

1728:
1729: --removes leading and trailing spaces from the reference number
1730: REMOVE_SPACES (l_cell_value, l_spaces);
1731: IF l_spaces = TRUE THEN
1732: hr_du_utility.message('INFO', 'l_cell_value (with spaces removed) : '
1733: || l_cell_value , 20);
1734: END IF;
1735: --
1736:

Line 1737: hr_du_utility.message('INFO', 'l_cell_value : ' || l_cell_value, 35);

1733: || l_cell_value , 20);
1734: END IF;
1735: --
1736:
1737: hr_du_utility.message('INFO', 'l_cell_value : ' || l_cell_value, 35);
1738:
1739: IF l_cell_value IS NOT NULL THEN
1740: --
1741: --To find out the upload_header_id I extract the upload_id and then

Line 1759: hr_du_utility.message('INFO', l_built_up_string1, 35);

1755: 'AND des.upload_header_id = head.upload_header_id ' ||
1756: 'AND des.descriptor = ''API'' ' ||
1757: 'AND des.value IS NOT NULL';
1758:
1759: hr_du_utility.message('INFO', l_built_up_string1, 35);
1760:
1761: hr_du_utility.dynamic_sql_num(l_built_up_string1, l_upload_header_id);
1762:
1763: hr_du_utility.message('INFO',

Line 1761: hr_du_utility.dynamic_sql_num(l_built_up_string1, l_upload_header_id);

1757: 'AND des.value IS NOT NULL';
1758:
1759: hr_du_utility.message('INFO', l_built_up_string1, 35);
1760:
1761: hr_du_utility.dynamic_sql_num(l_built_up_string1, l_upload_header_id);
1762:
1763: hr_du_utility.message('INFO',
1764: 'Entering call to Process Line.' , 40);
1765:

Line 1763: hr_du_utility.message('INFO',

1759: hr_du_utility.message('INFO', l_built_up_string1, 35);
1760:
1761: hr_du_utility.dynamic_sql_num(l_built_up_string1, l_upload_header_id);
1762:
1763: hr_du_utility.message('INFO',
1764: 'Entering call to Process Line.' , 40);
1765:
1766: PROCESS_LINE(g_insert_table(p_target_api_module).r_id_curval,
1767: p_target_api_module, l_cell_value, l_target_api_module,

Line 1770: hr_du_utility.message('INFO',

1766: PROCESS_LINE(g_insert_table(p_target_api_module).r_id_curval,
1767: p_target_api_module, l_cell_value, l_target_api_module,
1768: l_upload_header_id, p_upload_id);
1769:
1770: hr_du_utility.message('INFO',
1771: 'Returned from call to Process Line.' || l_cell_value, 45);
1772: --
1773: END IF;
1774: --

Line 1786: hr_du_utility.message('INFO', 'r_string_apis : ' ||

1782: g_insert_table(p_target_api_module).r_string_apis);
1783: l_number_references := hr_du_di_insert.WORDS_ON_LINE(
1784: g_insert_table(p_target_api_module).r_string_apis);
1785:
1786: hr_du_utility.message('INFO', 'r_string_apis : ' ||
1787: g_insert_table(p_target_api_module).r_string_apis ,50);
1788: hr_du_utility.message('INFO', l_number_references ,55);
1789:
1790: --this loop catches all occurrences

Line 1788: hr_du_utility.message('INFO', l_number_references ,55);

1784: g_insert_table(p_target_api_module).r_string_apis);
1785:
1786: hr_du_utility.message('INFO', 'r_string_apis : ' ||
1787: g_insert_table(p_target_api_module).r_string_apis ,50);
1788: hr_du_utility.message('INFO', l_number_references ,55);
1789:
1790: --this loop catches all occurrences
1791: FOR j IN 1..l_number_references LOOP
1792: --

Line 1816: hr_du_utility.message('INFO', l_built_up_string1 ,50);

1812: l_built_up_string1 := 'update HR_DU_UPLOAD_LINES SET ' ||
1813: l_single_pval || ' = ''' || p_prev_upload_line_id ||
1814: ''' WHERE upload_line_id = ' || l_line_id;
1815:
1816: hr_du_utility.message('INFO', l_built_up_string1 ,50);
1817:
1818: hr_du_utility.dynamic_sql(l_built_up_string1);
1819:
1820: --Set to true for api_module id matches has precedence over generic

Line 1818: hr_du_utility.dynamic_sql(l_built_up_string1);

1814: ''' WHERE upload_line_id = ' || l_line_id;
1815:
1816: hr_du_utility.message('INFO', l_built_up_string1 ,50);
1817:
1818: hr_du_utility.dynamic_sql(l_built_up_string1);
1819:
1820: --Set to true for api_module id matches has precedence over generic
1821: --matches. (this is handled in the next loop)
1822: l_found_flag := TRUE;

Line 1856: hr_du_utility.message('INFO', l_built_up_string3 ,55);

1852: || ''',' || l_generic_pval || ' = ''' ||
1853: g_insert_table(p_prev_table_number).r_api_id ||
1854: ''' WHERE upload_line_id = ' || l_line_id;
1855:
1856: hr_du_utility.message('INFO', l_built_up_string3 ,55);
1857:
1858: hr_du_utility.dynamic_sql(l_built_up_string3);
1859:
1860: EXIT;

Line 1858: hr_du_utility.dynamic_sql(l_built_up_string3);

1854: ''' WHERE upload_line_id = ' || l_line_id;
1855:
1856: hr_du_utility.message('INFO', l_built_up_string3 ,55);
1857:
1858: hr_du_utility.dynamic_sql(l_built_up_string3);
1859:
1860: EXIT;
1861: --
1862: ELSE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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