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.PAY_SE_TAX_TABLE_UPLOAD dependencies on HR_UTILITY

Line 52: hr_utility.set_location ('Entering:' || l_proc, 10);

48:
49: CLOSE csr_legislation_code;
50:
51: legislation_code := lr_legislation_code.legislation_code;
52: hr_utility.set_location ('Entering:' || l_proc, 10);
53: hr_utility.set_location ('p_business_group' || p_business_group, 15);
54: hr_utility.set_location ('Legislation = ' || legislation_code, 20);
55: hr_utility.set_location ( 'Effective Start Date = '
56: || p_effective_start_date

Line 53: hr_utility.set_location ('p_business_group' || p_business_group, 15);

49: CLOSE csr_legislation_code;
50:
51: legislation_code := lr_legislation_code.legislation_code;
52: hr_utility.set_location ('Entering:' || l_proc, 10);
53: hr_utility.set_location ('p_business_group' || p_business_group, 15);
54: hr_utility.set_location ('Legislation = ' || legislation_code, 20);
55: hr_utility.set_location ( 'Effective Start Date = '
56: || p_effective_start_date
57: ,21

Line 54: hr_utility.set_location ('Legislation = ' || legislation_code, 20);

50:
51: legislation_code := lr_legislation_code.legislation_code;
52: hr_utility.set_location ('Entering:' || l_proc, 10);
53: hr_utility.set_location ('p_business_group' || p_business_group, 15);
54: hr_utility.set_location ('Legislation = ' || legislation_code, 20);
55: hr_utility.set_location ( 'Effective Start Date = '
56: || p_effective_start_date
57: ,21
58: );

Line 55: hr_utility.set_location ( 'Effective Start Date = '

51: legislation_code := lr_legislation_code.legislation_code;
52: hr_utility.set_location ('Entering:' || l_proc, 10);
53: hr_utility.set_location ('p_business_group' || p_business_group, 15);
54: hr_utility.set_location ('Legislation = ' || legislation_code, 20);
55: hr_utility.set_location ( 'Effective Start Date = '
56: || p_effective_start_date
57: ,21
58: );
59: hr_utility.set_location ('c_end_of_time = ' || c_end_of_time, 22);

Line 59: hr_utility.set_location ('c_end_of_time = ' || c_end_of_time, 22);

55: hr_utility.set_location ( 'Effective Start Date = '
56: || p_effective_start_date
57: ,21
58: );
59: hr_utility.set_location ('c_end_of_time = ' || c_end_of_time, 22);
60:
61: -- Check for Sweden Localization.
62: IF legislation_code = 'SE'
63: THEN

Line 72: hr_utility.set_location ('l_retcode:' || l_retcode, 40);

68: errbuf := l_errbuf;
69: retcode := l_retcode;
70: --If anything happens inside the previous call,,
71: -- dont proceed further
72: hr_utility.set_location ('l_retcode:' || l_retcode, 40);
73:
74: IF l_retcode IS NULL OR l_retcode = 1
75: THEN
76: -- Call to Load data procedure

Line 103: hr_utility.set_location ('Leaving:' || l_proc, 40);

99:
100: COMMIT;
101: END IF;
102:
103: hr_utility.set_location ('Leaving:' || l_proc, 40);
104: END main;
105:
106: /* */
107:

Line 151: --hr_utility.trace_on(null,'tax');

147:
148: lr_legislation_code csr_legislation_code%ROWTYPE;
149: legislation_code per_business_groups.legislation_code%TYPE;
150: BEGIN
151: --hr_utility.trace_on(null,'tax');
152: hr_utility.set_location ('Entering: Purge ', 10);
153: hr_utility.set_location ('p_business_group ' || p_business_group, 10);
154: hr_utility.set_location ( 'p_effective_start_date'
155: || p_effective_start_date

Line 152: hr_utility.set_location ('Entering: Purge ', 10);

148: lr_legislation_code csr_legislation_code%ROWTYPE;
149: legislation_code per_business_groups.legislation_code%TYPE;
150: BEGIN
151: --hr_utility.trace_on(null,'tax');
152: hr_utility.set_location ('Entering: Purge ', 10);
153: hr_utility.set_location ('p_business_group ' || p_business_group, 10);
154: hr_utility.set_location ( 'p_effective_start_date'
155: || p_effective_start_date
156: ,10

Line 153: hr_utility.set_location ('p_business_group ' || p_business_group, 10);

149: legislation_code per_business_groups.legislation_code%TYPE;
150: BEGIN
151: --hr_utility.trace_on(null,'tax');
152: hr_utility.set_location ('Entering: Purge ', 10);
153: hr_utility.set_location ('p_business_group ' || p_business_group, 10);
154: hr_utility.set_location ( 'p_effective_start_date'
155: || p_effective_start_date
156: ,10
157: );

Line 154: hr_utility.set_location ( 'p_effective_start_date'

150: BEGIN
151: --hr_utility.trace_on(null,'tax');
152: hr_utility.set_location ('Entering: Purge ', 10);
153: hr_utility.set_location ('p_business_group ' || p_business_group, 10);
154: hr_utility.set_location ( 'p_effective_start_date'
155: || p_effective_start_date
156: ,10
157: );
158: hr_utility.set_location ('p_effective_end_date' || p_effective_end_date

Line 158: hr_utility.set_location ('p_effective_end_date' || p_effective_end_date

154: hr_utility.set_location ( 'p_effective_start_date'
155: || p_effective_start_date
156: ,10
157: );
158: hr_utility.set_location ('p_effective_end_date' || p_effective_end_date
159: ,10
160: );
161:
162: IF p_effective_start_date IS NULL AND p_effective_end_date IS NULL

Line 174: hr_utility.set_location ('Legislation_Code' || legislation_code, 10);

170:
171: CLOSE csr_legislation_code;
172:
173: legislation_code := lr_legislation_code.legislation_code;
174: hr_utility.set_location ('Legislation_Code' || legislation_code, 10);
175:
176: FOR MASTER IN csr_range_table_id (legislation_code)
177: LOOP
178: FOR CHILD IN csr_range_id (MASTER.range_table_id)

Line 335: hr_utility.set_location ('UPLOAD PROCESS', 10);

331: l_check VARCHAR2 (20);
332: lr_csr_master_end_date csr_master_end_date%ROWTYPE;
333: BEGIN
334: l_check := ' ';
335: hr_utility.set_location ('UPLOAD PROCESS', 10);
336: l_object_version_number := 1;
337:
338: -- Check for the Data if the effective date is same as available in db ,,
339: -- Plz say no and clear temp table and error out

Line 391: hr_utility.set_location ('PROCESS', 10);

387:
388: IF l_csr_range_table_id <> -99
389: THEN
390: -- It found the master id is already present which has to be end-dated.
391: hr_utility.set_location ('PROCESS', 10);
392: pay_range_table_api.update_range_table
393: (p_range_table_id => l_csr_range_table_id
394: ,p_effective_end_date => p_effective_start_date
395: - 1

Line 456: hr_utility.set_location (l_proc, 270);

452: -- *************************************
453: WHEN e_same_date
454: -- Data already availabe on same date
455: THEN
456: hr_utility.set_location (l_proc, 270);
457: -- Set retcode to 2, indicating an ERROR to the ConcMgr
458: retcode := g_error;
459: -- Set the application error
460: hr_utility.set_message (801, 'HR_377224_SE_DATE_INVALID');

Line 460: hr_utility.set_message (801, 'HR_377224_SE_DATE_INVALID');

456: hr_utility.set_location (l_proc, 270);
457: -- Set retcode to 2, indicating an ERROR to the ConcMgr
458: retcode := g_error;
459: -- Set the application error
460: hr_utility.set_message (801, 'HR_377224_SE_DATE_INVALID');
461: -- Return the message to the ConcMgr (This msg will appear in the log file)
462: errbuf := hr_utility.GET_MESSAGE;
463: -- *************************************
464:

Line 462: errbuf := hr_utility.GET_MESSAGE;

458: retcode := g_error;
459: -- Set the application error
460: hr_utility.set_message (801, 'HR_377224_SE_DATE_INVALID');
461: -- Return the message to the ConcMgr (This msg will appear in the log file)
462: errbuf := hr_utility.GET_MESSAGE;
463: -- *************************************
464:
465: -- *************************************
466: WHEN e_future_rec_exists

Line 469: hr_utility.set_location (l_proc, 270);

465: -- *************************************
466: WHEN e_future_rec_exists
467: -- Data already availabe on same date
468: THEN
469: hr_utility.set_location (l_proc, 270);
470: -- Set retcode to 2, indicating an ERROR to the ConcMgr
471: retcode := g_error;
472: -- Set the application error
473: hr_utility.set_message (801, 'HR_377226_SE_FUTURE_DATA_EXIST');

Line 473: hr_utility.set_message (801, 'HR_377226_SE_FUTURE_DATA_EXIST');

469: hr_utility.set_location (l_proc, 270);
470: -- Set retcode to 2, indicating an ERROR to the ConcMgr
471: retcode := g_error;
472: -- Set the application error
473: hr_utility.set_message (801, 'HR_377226_SE_FUTURE_DATA_EXIST');
474: hr_utility.set_message_token (801
475: ,'START_DATE'
476: ,TO_DATE (start_date, 'DD/MM/YYYY')
477: );

Line 474: hr_utility.set_message_token (801

470: -- Set retcode to 2, indicating an ERROR to the ConcMgr
471: retcode := g_error;
472: -- Set the application error
473: hr_utility.set_message (801, 'HR_377226_SE_FUTURE_DATA_EXIST');
474: hr_utility.set_message_token (801
475: ,'START_DATE'
476: ,TO_DATE (start_date, 'DD/MM/YYYY')
477: );
478: hr_utility.set_message_token (801

Line 478: hr_utility.set_message_token (801

474: hr_utility.set_message_token (801
475: ,'START_DATE'
476: ,TO_DATE (start_date, 'DD/MM/YYYY')
477: );
478: hr_utility.set_message_token (801
479: ,'END_DATE'
480: ,TO_DATE (end_date, 'DD/MM/YYYY')
481: );
482: -- Return the message to the ConcMgr (This msg will appear in the log file)

Line 483: errbuf := hr_utility.GET_MESSAGE;

479: ,'END_DATE'
480: ,TO_DATE (end_date, 'DD/MM/YYYY')
481: );
482: -- Return the message to the ConcMgr (This msg will appear in the log file)
483: errbuf := hr_utility.GET_MESSAGE;
484: -- *************************************
485: END upload_tax_to_main_table;
486:
487: PROCEDURE end_date_child (

Line 584: hr_utility.set_location ('Entering:' || l_proc, 10);

580: -- Local Variables
581: l_diff_record_type NUMBER := 0;
582:
583: BEGIN
584: hr_utility.set_location ('Entering:' || l_proc, 10);
585: hr_utility.set_location ('p_data_file_name ' || p_data_file_name, 1);
586: l_filename := p_data_file_name;
587: fnd_profile.get (c_data_exchange_dir, l_location);
588: hr_utility.set_location ('Directory = ' || l_location, 30);

Line 585: hr_utility.set_location ('p_data_file_name ' || p_data_file_name, 1);

581: l_diff_record_type NUMBER := 0;
582:
583: BEGIN
584: hr_utility.set_location ('Entering:' || l_proc, 10);
585: hr_utility.set_location ('p_data_file_name ' || p_data_file_name, 1);
586: l_filename := p_data_file_name;
587: fnd_profile.get (c_data_exchange_dir, l_location);
588: hr_utility.set_location ('Directory = ' || l_location, 30);
589:

Line 588: hr_utility.set_location ('Directory = ' || l_location, 30);

584: hr_utility.set_location ('Entering:' || l_proc, 10);
585: hr_utility.set_location ('p_data_file_name ' || p_data_file_name, 1);
586: l_filename := p_data_file_name;
587: fnd_profile.get (c_data_exchange_dir, l_location);
588: hr_utility.set_location ('Directory = ' || l_location, 30);
589:
590: IF l_location IS NULL
591: THEN
592: hr_utility.set_location ('Raising I/O error = ' || l_location, 35);

Line 592: hr_utility.set_location ('Raising I/O error = ' || l_location, 35);

588: hr_utility.set_location ('Directory = ' || l_location, 30);
589:
590: IF l_location IS NULL
591: THEN
592: hr_utility.set_location ('Raising I/O error = ' || l_location, 35);
593: -- error : I/O directory not defined
594: RAISE e_fatal_error;
595: END IF;
596:

Line 609: hr_utility.set_location (' line read: ' || l_line_read, 60);

605: LOOP
606: BEGIN
607: UTL_FILE.get_line (l_file_type, l_line_read);
608: l_batch_seq := l_batch_seq + 1;
609: hr_utility.set_location (' line read: ' || l_line_read, 60);
610: -- Calling the procedure tyo split the line into variables
611: split_line (p_line => l_line_read
612: ,p_range_table_number => l_range_table_number
613: ,p_row_value_uom => l_row_value_uom

Line 663: hr_utility.set_location (' Record is of different type', 110);

659: ,l_amount7
660: ,l_amount8
661: );
662: else
663: hr_utility.set_location (' Record is of different type', 110);
664: l_diff_record_type := l_diff_record_type +1;
665: IF l_diff_record_type < 100
666: THEN
667: RAISE e_diff_record_frequency;

Line 691: hr_utility.set_message (801, 'HR_377252_SE_REC_DIFF_FREQ');

687: THEN
688: -- Set retcode to 1, indicating a WARNING to the ConcMgr
689: retcode := g_warning;
690: -- Set the application error
691: hr_utility.set_message (801, 'HR_377252_SE_REC_DIFF_FREQ');
692: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
693: hr_utility.set_message_token (801, 'LINE', l_line_read);
694: hr_utility.set_location (l_proc, 260);
695: -- Write the message to log file, do not raise an application error but continue

Line 692: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);

688: -- Set retcode to 1, indicating a WARNING to the ConcMgr
689: retcode := g_warning;
690: -- Set the application error
691: hr_utility.set_message (801, 'HR_377252_SE_REC_DIFF_FREQ');
692: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
693: hr_utility.set_message_token (801, 'LINE', l_line_read);
694: hr_utility.set_location (l_proc, 260);
695: -- Write the message to log file, do not raise an application error but continue
696: -- (with next line)

Line 693: hr_utility.set_message_token (801, 'LINE', l_line_read);

689: retcode := g_warning;
690: -- Set the application error
691: hr_utility.set_message (801, 'HR_377252_SE_REC_DIFF_FREQ');
692: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
693: hr_utility.set_message_token (801, 'LINE', l_line_read);
694: hr_utility.set_location (l_proc, 260);
695: -- Write the message to log file, do not raise an application error but continue
696: -- (with next line)
697: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);

Line 694: hr_utility.set_location (l_proc, 260);

690: -- Set the application error
691: hr_utility.set_message (801, 'HR_377252_SE_REC_DIFF_FREQ');
692: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
693: hr_utility.set_message_token (801, 'LINE', l_line_read);
694: hr_utility.set_location (l_proc, 260);
695: -- Write the message to log file, do not raise an application error but continue
696: -- (with next line)
697: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);
698:

Line 697: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);

693: hr_utility.set_message_token (801, 'LINE', l_line_read);
694: hr_utility.set_location (l_proc, 260);
695: -- Write the message to log file, do not raise an application error but continue
696: -- (with next line)
697: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);
698:
699: -- *************************************
700: -- When 100 Records of different frequency type has been found.
701: WHEN e_diff_record_freq_limit

Line 704: hr_utility.set_location (l_proc, 270);

700: -- When 100 Records of different frequency type has been found.
701: WHEN e_diff_record_freq_limit
702: --Record is of different frequency
703: THEN
704: hr_utility.set_location (l_proc, 270);
705: -- Set retcode to 2, indicating an ERROR to the ConcMgr
706: retcode := g_error;
707: -- Set the application error
708: hr_utility.set_message (801, 'HR_377253_SE_REC_FREQ_LIMIT');

Line 708: hr_utility.set_message (801, 'HR_377253_SE_REC_FREQ_LIMIT');

704: hr_utility.set_location (l_proc, 270);
705: -- Set retcode to 2, indicating an ERROR to the ConcMgr
706: retcode := g_error;
707: -- Set the application error
708: hr_utility.set_message (801, 'HR_377253_SE_REC_FREQ_LIMIT');
709: -- Return the message to the ConcMgr (This msg will appear in the log file)
710: errbuf := hr_utility.GET_MESSAGE;
711:
712: -- *************************************

Line 710: errbuf := hr_utility.GET_MESSAGE;

706: retcode := g_error;
707: -- Set the application error
708: hr_utility.set_message (801, 'HR_377253_SE_REC_FREQ_LIMIT');
709: -- Return the message to the ConcMgr (This msg will appear in the log file)
710: errbuf := hr_utility.GET_MESSAGE;
711:
712: -- *************************************
713: -- When the Record in the file is larger than specified size.
714: WHEN e_record_too_long

Line 720: hr_utility.set_message (801, 'HR_377215_SE_RECORD_TOO_LONG');

716: THEN
717: -- Set retcode to 1, indicating a WARNING to the ConcMgr
718: retcode := g_warning;
719: -- Set the application error
720: hr_utility.set_message (801, 'HR_377215_SE_RECORD_TOO_LONG');
721: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
722: hr_utility.set_message_token (801, 'LINE', l_line_read);
723: hr_utility.set_location (l_proc, 260);
724: -- Write the message to log file, do not raise an application error but continue

Line 721: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);

717: -- Set retcode to 1, indicating a WARNING to the ConcMgr
718: retcode := g_warning;
719: -- Set the application error
720: hr_utility.set_message (801, 'HR_377215_SE_RECORD_TOO_LONG');
721: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
722: hr_utility.set_message_token (801, 'LINE', l_line_read);
723: hr_utility.set_location (l_proc, 260);
724: -- Write the message to log file, do not raise an application error but continue
725: -- (with next line)

Line 722: hr_utility.set_message_token (801, 'LINE', l_line_read);

718: retcode := g_warning;
719: -- Set the application error
720: hr_utility.set_message (801, 'HR_377215_SE_RECORD_TOO_LONG');
721: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
722: hr_utility.set_message_token (801, 'LINE', l_line_read);
723: hr_utility.set_location (l_proc, 260);
724: -- Write the message to log file, do not raise an application error but continue
725: -- (with next line)
726: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);

Line 723: hr_utility.set_location (l_proc, 260);

719: -- Set the application error
720: hr_utility.set_message (801, 'HR_377215_SE_RECORD_TOO_LONG');
721: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
722: hr_utility.set_message_token (801, 'LINE', l_line_read);
723: hr_utility.set_location (l_proc, 260);
724: -- Write the message to log file, do not raise an application error but continue
725: -- (with next line)
726: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);
727: -- *************************************

Line 726: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);

722: hr_utility.set_message_token (801, 'LINE', l_line_read);
723: hr_utility.set_location (l_proc, 260);
724: -- Write the message to log file, do not raise an application error but continue
725: -- (with next line)
726: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);
727: -- *************************************
728: WHEN e_empty_line
729: THEN
730: -- Set retcode to 1, indicating a WARNING to the ConcMgr

Line 733: hr_utility.set_message (800, 'HR_377222_SE_EMPTY_LINE');

729: THEN
730: -- Set retcode to 1, indicating a WARNING to the ConcMgr
731: retcode := g_warning;
732: -- Set the application error
733: hr_utility.set_message (800, 'HR_377222_SE_EMPTY_LINE');
734: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);
735: -- Write the message to log file, do not raise an application error but continue
736: -- (with next line)
737: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);

Line 734: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);

730: -- Set retcode to 1, indicating a WARNING to the ConcMgr
731: retcode := g_warning;
732: -- Set the application error
733: hr_utility.set_message (800, 'HR_377222_SE_EMPTY_LINE');
734: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);
735: -- Write the message to log file, do not raise an application error but continue
736: -- (with next line)
737: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);
738: END; -- file reading Begin

Line 737: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);

733: hr_utility.set_message (800, 'HR_377222_SE_EMPTY_LINE');
734: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);
735: -- Write the message to log file, do not raise an application error but continue
736: -- (with next line)
737: fnd_file.put_line (fnd_file.LOG, hr_utility.GET_MESSAGE);
738: END; -- file reading Begin
739: END LOOP read_lines_in_file;
740:
741: -- Commit the outstanding records

Line 744: hr_utility.set_location ('Leaving:' || l_proc, 260);

740:
741: -- Commit the outstanding records
742: COMMIT;
743: UTL_FILE.fclose (l_file_type);
744: hr_utility.set_location ('Leaving:' || l_proc, 260);
745: EXCEPTION
746: -- When file location is not proper
747: -- ***********************************************
748: WHEN e_fatal_error

Line 757: hr_utility.set_location (l_proc, 270);

753: THEN
754: UTL_FILE.fclose (l_file_type);
755: END IF;
756:
757: hr_utility.set_location (l_proc, 270);
758: -- Set retcode to 2, indicating an ERROR to the ConcMgr
759: retcode := g_error;
760: -- Set the application error
761: hr_utility.set_message (801, 'HR_SE_DATA_EXCHANGE_DIR_MIS');

Line 761: hr_utility.set_message (801, 'HR_SE_DATA_EXCHANGE_DIR_MIS');

757: hr_utility.set_location (l_proc, 270);
758: -- Set retcode to 2, indicating an ERROR to the ConcMgr
759: retcode := g_error;
760: -- Set the application error
761: hr_utility.set_message (801, 'HR_SE_DATA_EXCHANGE_DIR_MIS');
762: -- Return the message to the ConcMgr (This msg will appear in the log file)
763: errbuf := hr_utility.GET_MESSAGE;
764: -- ***********************************************
765: WHEN UTL_FILE.invalid_operation

Line 763: errbuf := hr_utility.GET_MESSAGE;

759: retcode := g_error;
760: -- Set the application error
761: hr_utility.set_message (801, 'HR_SE_DATA_EXCHANGE_DIR_MIS');
762: -- Return the message to the ConcMgr (This msg will appear in the log file)
763: errbuf := hr_utility.GET_MESSAGE;
764: -- ***********************************************
765: WHEN UTL_FILE.invalid_operation
766: -- File could not be opened as requested, perhaps because of operating system permissions
767: -- Also raised when attempting a write operation on a file opened for read, or a read operation

Line 775: hr_utility.set_location (l_proc, 280);

771: THEN
772: UTL_FILE.fclose (l_file_type);
773: END IF;
774:
775: hr_utility.set_location (l_proc, 280);
776: retcode := g_error;
777: errbuf :=
778: 'Reading File ('
779: || l_location

Line 792: hr_utility.set_location (l_proc, 290);

788: THEN
789: UTL_FILE.fclose (l_file_type);
790: END IF;
791:
792: hr_utility.set_location (l_proc, 290);
793: retcode := g_error;
794: errbuf :=
795: 'Reading File ('
796: || l_location

Line 809: hr_utility.set_location (l_proc, 300);

805: THEN
806: UTL_FILE.fclose (l_file_type);
807: END IF;
808:
809: hr_utility.set_location (l_proc, 300);
810: retcode := g_error;
811: errbuf :=
812: 'Reading File ('
813: || l_location

Line 833: hr_utility.set_location (l_proc, 310);

829: || l_location
830: || ' -> '
831: || l_filename
832: || ') - Invalid Path or Filename.';
833: hr_utility.set_location (l_proc, 310);
834: -- ***********************************************
835: WHEN UTL_FILE.invalid_filehandle
836: -- File type does not specify an open file
837: THEN

Line 843: hr_utility.set_location (l_proc, 320);

839: THEN
840: UTL_FILE.fclose (l_file_type);
841: END IF;
842:
843: hr_utility.set_location (l_proc, 320);
844: retcode := g_error;
845: errbuf :=
846: 'Reading File ('
847: || l_location

Line 861: hr_utility.set_location (l_proc, 330);

857: THEN
858: UTL_FILE.fclose (l_file_type);
859: END IF;
860:
861: hr_utility.set_location (l_proc, 330);
862: retcode := g_error;
863: errbuf :=
864: 'Reading File ('
865: || l_location

Line 906: hr_utility.set_location ('Entering:' || l_proc, 70);

902: -- Procedure name
903: l_proc CONSTANT VARCHAR2 (72) := g_package || '.split_line';
904: l_record_length NUMBER := 45; --33;
905: BEGIN
906: hr_utility.set_location ('Entering:' || l_proc, 70);
907: --Set record length
908: l_record_length := 45; --33;
909:
910: IF p_line IS NULL

Line 918: hr_utility.set_location (' Record too long', 110);

914: ELSE
915: -- Error in record if it is too long according to given format
916: IF (LENGTH (p_line) > l_record_length)
917: THEN
918: hr_utility.set_location (' Record too long', 110);
919: RAISE e_record_too_long;
920: END IF;
921:
922: p_period_frequency := SUBSTR (p_line, 1, 2);

Line 938: hr_utility.set_location ( ' p_RANGE_TABLE_NUMBER'

934: p_amount6 := NULL;
935: p_amount7 := NULL;
936: p_amount8 := NULL;
937: -- ************************* NOT REQUIRED FOR NOW *********************
938: hr_utility.set_location ( ' p_RANGE_TABLE_NUMBER'
939: || p_range_table_number
940: ,110
941: );
942: hr_utility.set_location (' p_ROW_VALUE_UOM ' || p_row_value_uom, 110);

Line 942: hr_utility.set_location (' p_ROW_VALUE_UOM ' || p_row_value_uom, 110);

938: hr_utility.set_location ( ' p_RANGE_TABLE_NUMBER'
939: || p_range_table_number
940: ,110
941: );
942: hr_utility.set_location (' p_ROW_VALUE_UOM ' || p_row_value_uom, 110);
943: hr_utility.set_location (' p_PERIOD_FREQUENCY ' || p_period_frequency
944: ,110
945: );
946: hr_utility.set_location (' p_LOW_BAND ' || p_low_band, 110);

Line 943: hr_utility.set_location (' p_PERIOD_FREQUENCY ' || p_period_frequency

939: || p_range_table_number
940: ,110
941: );
942: hr_utility.set_location (' p_ROW_VALUE_UOM ' || p_row_value_uom, 110);
943: hr_utility.set_location (' p_PERIOD_FREQUENCY ' || p_period_frequency
944: ,110
945: );
946: hr_utility.set_location (' p_LOW_BAND ' || p_low_band, 110);
947: hr_utility.set_location (' p_HIGH_BAND ' || p_high_band, 110);

Line 946: hr_utility.set_location (' p_LOW_BAND ' || p_low_band, 110);

942: hr_utility.set_location (' p_ROW_VALUE_UOM ' || p_row_value_uom, 110);
943: hr_utility.set_location (' p_PERIOD_FREQUENCY ' || p_period_frequency
944: ,110
945: );
946: hr_utility.set_location (' p_LOW_BAND ' || p_low_band, 110);
947: hr_utility.set_location (' p_HIGH_BAND ' || p_high_band, 110);
948: hr_utility.set_location (' p_AMOUNT1 ' || p_amount1, 110);
949: hr_utility.set_location (' p_AMOUNT2 ' || p_amount2, 110);
950: hr_utility.set_location (' p_AMOUNT3 ' || p_amount3, 110);

Line 947: hr_utility.set_location (' p_HIGH_BAND ' || p_high_band, 110);

943: hr_utility.set_location (' p_PERIOD_FREQUENCY ' || p_period_frequency
944: ,110
945: );
946: hr_utility.set_location (' p_LOW_BAND ' || p_low_band, 110);
947: hr_utility.set_location (' p_HIGH_BAND ' || p_high_band, 110);
948: hr_utility.set_location (' p_AMOUNT1 ' || p_amount1, 110);
949: hr_utility.set_location (' p_AMOUNT2 ' || p_amount2, 110);
950: hr_utility.set_location (' p_AMOUNT3 ' || p_amount3, 110);
951: hr_utility.set_location (' p_AMOUNT4 ' || p_amount4, 110);

Line 948: hr_utility.set_location (' p_AMOUNT1 ' || p_amount1, 110);

944: ,110
945: );
946: hr_utility.set_location (' p_LOW_BAND ' || p_low_band, 110);
947: hr_utility.set_location (' p_HIGH_BAND ' || p_high_band, 110);
948: hr_utility.set_location (' p_AMOUNT1 ' || p_amount1, 110);
949: hr_utility.set_location (' p_AMOUNT2 ' || p_amount2, 110);
950: hr_utility.set_location (' p_AMOUNT3 ' || p_amount3, 110);
951: hr_utility.set_location (' p_AMOUNT4 ' || p_amount4, 110);
952: hr_utility.set_location (' p_AMOUNT5 ' || p_amount5, 110);

Line 949: hr_utility.set_location (' p_AMOUNT2 ' || p_amount2, 110);

945: );
946: hr_utility.set_location (' p_LOW_BAND ' || p_low_band, 110);
947: hr_utility.set_location (' p_HIGH_BAND ' || p_high_band, 110);
948: hr_utility.set_location (' p_AMOUNT1 ' || p_amount1, 110);
949: hr_utility.set_location (' p_AMOUNT2 ' || p_amount2, 110);
950: hr_utility.set_location (' p_AMOUNT3 ' || p_amount3, 110);
951: hr_utility.set_location (' p_AMOUNT4 ' || p_amount4, 110);
952: hr_utility.set_location (' p_AMOUNT5 ' || p_amount5, 110);
953: hr_utility.set_location (' p_AMOUNT6 ' || p_amount6, 110);

Line 950: hr_utility.set_location (' p_AMOUNT3 ' || p_amount3, 110);

946: hr_utility.set_location (' p_LOW_BAND ' || p_low_band, 110);
947: hr_utility.set_location (' p_HIGH_BAND ' || p_high_band, 110);
948: hr_utility.set_location (' p_AMOUNT1 ' || p_amount1, 110);
949: hr_utility.set_location (' p_AMOUNT2 ' || p_amount2, 110);
950: hr_utility.set_location (' p_AMOUNT3 ' || p_amount3, 110);
951: hr_utility.set_location (' p_AMOUNT4 ' || p_amount4, 110);
952: hr_utility.set_location (' p_AMOUNT5 ' || p_amount5, 110);
953: hr_utility.set_location (' p_AMOUNT6 ' || p_amount6, 110);
954: hr_utility.set_location (' p_AMOUNT7 ' || p_amount7, 110);

Line 951: hr_utility.set_location (' p_AMOUNT4 ' || p_amount4, 110);

947: hr_utility.set_location (' p_HIGH_BAND ' || p_high_band, 110);
948: hr_utility.set_location (' p_AMOUNT1 ' || p_amount1, 110);
949: hr_utility.set_location (' p_AMOUNT2 ' || p_amount2, 110);
950: hr_utility.set_location (' p_AMOUNT3 ' || p_amount3, 110);
951: hr_utility.set_location (' p_AMOUNT4 ' || p_amount4, 110);
952: hr_utility.set_location (' p_AMOUNT5 ' || p_amount5, 110);
953: hr_utility.set_location (' p_AMOUNT6 ' || p_amount6, 110);
954: hr_utility.set_location (' p_AMOUNT7 ' || p_amount7, 110);
955: hr_utility.set_location (' p_AMOUNT8 ' || p_amount8, 110);

Line 952: hr_utility.set_location (' p_AMOUNT5 ' || p_amount5, 110);

948: hr_utility.set_location (' p_AMOUNT1 ' || p_amount1, 110);
949: hr_utility.set_location (' p_AMOUNT2 ' || p_amount2, 110);
950: hr_utility.set_location (' p_AMOUNT3 ' || p_amount3, 110);
951: hr_utility.set_location (' p_AMOUNT4 ' || p_amount4, 110);
952: hr_utility.set_location (' p_AMOUNT5 ' || p_amount5, 110);
953: hr_utility.set_location (' p_AMOUNT6 ' || p_amount6, 110);
954: hr_utility.set_location (' p_AMOUNT7 ' || p_amount7, 110);
955: hr_utility.set_location (' p_AMOUNT8 ' || p_amount8, 110);
956: END IF;

Line 953: hr_utility.set_location (' p_AMOUNT6 ' || p_amount6, 110);

949: hr_utility.set_location (' p_AMOUNT2 ' || p_amount2, 110);
950: hr_utility.set_location (' p_AMOUNT3 ' || p_amount3, 110);
951: hr_utility.set_location (' p_AMOUNT4 ' || p_amount4, 110);
952: hr_utility.set_location (' p_AMOUNT5 ' || p_amount5, 110);
953: hr_utility.set_location (' p_AMOUNT6 ' || p_amount6, 110);
954: hr_utility.set_location (' p_AMOUNT7 ' || p_amount7, 110);
955: hr_utility.set_location (' p_AMOUNT8 ' || p_amount8, 110);
956: END IF;
957:

Line 954: hr_utility.set_location (' p_AMOUNT7 ' || p_amount7, 110);

950: hr_utility.set_location (' p_AMOUNT3 ' || p_amount3, 110);
951: hr_utility.set_location (' p_AMOUNT4 ' || p_amount4, 110);
952: hr_utility.set_location (' p_AMOUNT5 ' || p_amount5, 110);
953: hr_utility.set_location (' p_AMOUNT6 ' || p_amount6, 110);
954: hr_utility.set_location (' p_AMOUNT7 ' || p_amount7, 110);
955: hr_utility.set_location (' p_AMOUNT8 ' || p_amount8, 110);
956: END IF;
957:
958: hr_utility.set_location ('Leaving:' || l_proc, 120);

Line 955: hr_utility.set_location (' p_AMOUNT8 ' || p_amount8, 110);

951: hr_utility.set_location (' p_AMOUNT4 ' || p_amount4, 110);
952: hr_utility.set_location (' p_AMOUNT5 ' || p_amount5, 110);
953: hr_utility.set_location (' p_AMOUNT6 ' || p_amount6, 110);
954: hr_utility.set_location (' p_AMOUNT7 ' || p_amount7, 110);
955: hr_utility.set_location (' p_AMOUNT8 ' || p_amount8, 110);
956: END IF;
957:
958: hr_utility.set_location ('Leaving:' || l_proc, 120);
959: END;

Line 958: hr_utility.set_location ('Leaving:' || l_proc, 120);

954: hr_utility.set_location (' p_AMOUNT7 ' || p_amount7, 110);
955: hr_utility.set_location (' p_AMOUNT8 ' || p_amount8, 110);
956: END IF;
957:
958: hr_utility.set_location ('Leaving:' || l_proc, 120);
959: END;
960: END pay_se_tax_table_upload;