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_DK_ABSR_PKG dependencies on HR_UTILITY

Line 6: g_debug BOOLEAN := hr_utility.debug_enabled;

2: /* $Header: pydkabsr.pkb 120.1 2010/08/21 19:43:10 rsahai noship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_DK_ABSR_PKG.';
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7: g_err_num NUMBER;
8:
9:
10: -----------------------------------------------------------------------------

Line 47: hr_utility.set_location(' Entering Function GET_PARAMETER',10);

43: l_delimiter VARCHAR2(1):=' ';
44:
45: BEGIN
46: IF g_debug THEN
47: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
48: END IF;
49:
50: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
51:

Line 73: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);

69: END IF;
70:
71: RETURN l_parameter;
72: IF g_debug THEN
73: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
74: END IF;
75:
76: END GET_PARAMETER;
77:

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

105: --
106: BEGIN
107:
108: IF g_debug THEN
109: hr_utility.set_location(' Entering procedure '||l_proc,10);
110: END IF;
111:
112: OPEN csr_parameter_info (p_payroll_action_id);
113:

Line 125: hr_utility.set_location(' Leaving procedure '||l_proc,20);

121: ,p_business_group_id;
122: CLOSE csr_parameter_info;
123: --
124: IF g_debug THEN
125: hr_utility.set_location(' Leaving procedure '||l_proc,20);
126: END IF;
127: END GET_ALL_PARAMETERS;
128:
129: ----------------------------------------------------

Line 150: hr_utility.set_location('Entering:'|| l_proc, 1);

146: l_proc varchar2(72) := g_package||'get_global_value';
147:
148: BEGIN
149: IF g_debug THEN
150: hr_utility.set_location('Entering:'|| l_proc, 1);
151: END IF;
152:
153: OPEN csr_globals;
154: FETCH csr_globals INTO l_global_value;

Line 158: hr_utility.set_location('Entering:'|| l_proc, 2);

154: FETCH csr_globals INTO l_global_value;
155: CLOSE csr_globals;
156:
157: IF g_debug THEN
158: hr_utility.set_location('Entering:'|| l_proc, 2);
159: END IF;
160:
161: RETURN l_global_value;
162: END GET_GLOBAL_VALUE;

Line 318: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);

314:
315: BEGIN
316:
317: IF g_debug THEN
318: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
319: END IF;
320:
321:
322: -- The sql string to return

Line 428: hr_utility.set_location(' Leaving Procedure RANGE_CODE',20);

424:
425: END LOOP;
426:
427: IF g_debug THEN
428: hr_utility.set_location(' Leaving Procedure RANGE_CODE',20);
429: END IF;
430:
431: EXCEPTION WHEN e_no_da_sys_no THEN
432: fnd_message.set_name('PAY','PAY_377058_DK_NO_DA_CODE_ERR');

Line 784: hr_utility.trace('Inside the Statistics Report');

780: l_tab_per_abs_rec tab_per_abs_rec;
781:
782: --
783: BEGIN
784: hr_utility.trace('Inside the Statistics Report');
785:
786: IF g_debug THEN
787: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
788: END IF;

Line 787: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);

783: BEGIN
784: hr_utility.trace('Inside the Statistics Report');
785:
786: IF g_debug THEN
787: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
788: END IF;
789:
790: SELECT PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'YEAR')
791: INTO l_year

Line 796: hr_utility.trace(' Before for loop csr_get_hdr_info ');

792: FROM pay_payroll_actions
793: WHERE payroll_action_id = p_payroll_action_id;
794:
795:
796: hr_utility.trace(' Before for loop csr_get_hdr_info ');
797: -- Fetch Header and Sub-header details
798: l_assg_no := NULL;
799: l_cpr_no := NULL;
800: l_abs_code := NULL;

Line 817: hr_utility.trace(' Inside for loop csr_get_hdr_info :');

813:
814: FOR rec_hdr_info IN csr_get_hdr_info(p_payroll_action_id)
815: LOOP
816:
817: hr_utility.trace(' Inside for loop csr_get_hdr_info :');
818: l_le_id := rec_hdr_info.tax_unit_id;
819: hr_utility.trace(' l_le_id :'||l_le_id);
820: l_le_name := rec_hdr_info.le_name;
821: hr_utility.trace(' l_le_name :'||l_le_name);

Line 819: hr_utility.trace(' l_le_id :'||l_le_id);

815: LOOP
816:
817: hr_utility.trace(' Inside for loop csr_get_hdr_info :');
818: l_le_id := rec_hdr_info.tax_unit_id;
819: hr_utility.trace(' l_le_id :'||l_le_id);
820: l_le_name := rec_hdr_info.le_name;
821: hr_utility.trace(' l_le_name :'||l_le_name);
822: l_payroll_id := rec_hdr_info.payroll_id;
823: hr_utility.trace(' l_payroll_id :'||l_payroll_id);

Line 821: hr_utility.trace(' l_le_name :'||l_le_name);

817: hr_utility.trace(' Inside for loop csr_get_hdr_info :');
818: l_le_id := rec_hdr_info.tax_unit_id;
819: hr_utility.trace(' l_le_id :'||l_le_id);
820: l_le_name := rec_hdr_info.le_name;
821: hr_utility.trace(' l_le_name :'||l_le_name);
822: l_payroll_id := rec_hdr_info.payroll_id;
823: hr_utility.trace(' l_payroll_id :'||l_payroll_id);
824: l_punit := rec_hdr_info.le_punit;
825: hr_utility.trace(' l_punit :'||l_punit);

Line 823: hr_utility.trace(' l_payroll_id :'||l_payroll_id);

819: hr_utility.trace(' l_le_id :'||l_le_id);
820: l_le_name := rec_hdr_info.le_name;
821: hr_utility.trace(' l_le_name :'||l_le_name);
822: l_payroll_id := rec_hdr_info.payroll_id;
823: hr_utility.trace(' l_payroll_id :'||l_payroll_id);
824: l_punit := rec_hdr_info.le_punit;
825: hr_utility.trace(' l_punit :'||l_punit);
826:
827: hr_utility.trace('Variables Initialisations New ');

Line 825: hr_utility.trace(' l_punit :'||l_punit);

821: hr_utility.trace(' l_le_name :'||l_le_name);
822: l_payroll_id := rec_hdr_info.payroll_id;
823: hr_utility.trace(' l_payroll_id :'||l_payroll_id);
824: l_punit := rec_hdr_info.le_punit;
825: hr_utility.trace(' l_punit :'||l_punit);
826:
827: hr_utility.trace('Variables Initialisations New ');
828:
829: l_le_cvr_no := to_char(rec_hdr_info.LE_CVR_NUMBER);

Line 827: hr_utility.trace('Variables Initialisations New ');

823: hr_utility.trace(' l_payroll_id :'||l_payroll_id);
824: l_punit := rec_hdr_info.le_punit;
825: hr_utility.trace(' l_punit :'||l_punit);
826:
827: hr_utility.trace('Variables Initialisations New ');
828:
829: l_le_cvr_no := to_char(rec_hdr_info.LE_CVR_NUMBER);
830: l_le_da_scode := to_char(rec_hdr_info.LE_DA_OFFICE_CODE);
831:

Line 832: hr_utility.trace(' After Variables Initialisations. ');

828:
829: l_le_cvr_no := to_char(rec_hdr_info.LE_CVR_NUMBER);
830: l_le_da_scode := to_char(rec_hdr_info.LE_DA_OFFICE_CODE);
831:
832: hr_utility.trace(' After Variables Initialisations. ');
833: /*
834: OPEN csr_get_hdr_info(p_payroll_action_id);
835: FETCH csr_get_hdr_info INTO rec_hdr_info;
836: CLOSE csr_get_hdr_info;

Line 851: hr_utility.trace(' l_global_value :'||l_global_value);

847:
848: OPEN cur_global(l_effective_date);
849: FETCH cur_global INTO l_global_value;
850: CLOSE cur_global;
851: hr_utility.trace(' l_global_value :'||l_global_value);
852: -- Fetch Assignment's details
853:
854: FOR csr_rec IN csr_assignments( p_payroll_action_id
855: ,l_payroll_id

Line 864: hr_utility.trace(' Inside loop csr_assignments');

860: ,l_le_id
861: ,l_effective_date )
862: LOOP
863:
864: hr_utility.trace(' Inside loop csr_assignments');
865: l_loc_id := csr_rec.loc_id; --8820009
866: l_hr_org_id := csr_rec.hr_org_id;
867: /*
868: l_hourly_salaried := csr_rec.hourly_salaried_code;

Line 877: hr_utility.trace(' l_asgid :'||l_asgid);

873: l_hourly_salaried := 'H';
874: END IF ;
875: END IF ;
876: */
877: hr_utility.trace(' l_asgid :'||l_asgid);
878: hr_utility.trace(' csr_rec.asg_id :'||csr_rec.asg_id);
879:
880: IF (csr_rec.asg_id <> l_asgid) THEN
881:

Line 878: hr_utility.trace(' csr_rec.asg_id :'||csr_rec.asg_id);

874: END IF ;
875: END IF ;
876: */
877: hr_utility.trace(' l_asgid :'||l_asgid);
878: hr_utility.trace(' csr_rec.asg_id :'||csr_rec.asg_id);
879:
880: IF (csr_rec.asg_id <> l_asgid) THEN
881:
882: hr_utility.trace(' ***** Intializing the old variables **** ');

Line 882: hr_utility.trace(' * Intializing the old variables ');

878: hr_utility.trace(' csr_rec.asg_id :'||csr_rec.asg_id);
879:
880: IF (csr_rec.asg_id <> l_asgid) THEN
881:
882: hr_utility.trace(' ***** Intializing the old variables **** ');
883:
884: l_assg_no := NULL;
885: l_cpr_no := NULL;
886: l_abs_code := NULL;

Line 902: hr_utility.trace(' l_perid :'||l_perid);

898: --8840262
899:
900: End if;
901:
902: hr_utility.trace(' l_perid :'||l_perid);
903: hr_utility.trace(' csr_rec.person_id :'||csr_rec.person_id);
904: --8766712
905: IF l_perid <> csr_rec.person_id
906: THEN

Line 903: hr_utility.trace(' csr_rec.person_id :'||csr_rec.person_id);

899:
900: End if;
901:
902: hr_utility.trace(' l_perid :'||l_perid);
903: hr_utility.trace(' csr_rec.person_id :'||csr_rec.person_id);
904: --8766712
905: IF l_perid <> csr_rec.person_id
906: THEN
907: --clear the pl_sql_table;

Line 923: hr_utility.trace(' Inside if csr_rec.asg_id <> l_asgid');

919: or csr_rec.loc_id <> l_old_loc_id)
920: ) */
921: THEN
922:
923: hr_utility.trace(' Inside if csr_rec.asg_id <> l_asgid');
924: FOR rec_csr_abs IN csr_abs(csr_rec.person_id
925: ,l_bg_id
926: ,l_date_from
927: ,l_date_to

Line 935: hr_utility.trace(' Inside IF NOT l_tab_per_abs_rec.EXISTS');

931: --8766712
932: IF NOT l_tab_per_abs_rec.EXISTS(rec_csr_abs.absence_attendance_id) THEN
933: l_tab_per_abs_rec(rec_csr_abs.absence_attendance_id) := csr_rec.person_id;
934:
935: hr_utility.trace(' Inside IF NOT l_tab_per_abs_rec.EXISTS');
936:
937: l_assg_no := csr_rec.ASSIGNMENT_NUMBER;
938: l_cpr_no := csr_rec.CPR_NO;
939: l_abs_code := rec_csr_abs.ABS_CODE;

Line 948: hr_utility.trace(' Inside Hour hr_loc_work_schedule');

944: l_abs_end_time := rec_csr_abs.time_end;
945:
946: IF l_abs_start_time IS NOT NULL OR l_abs_end_time IS NOT NULL THEN
947:
948: hr_utility.trace(' Inside Hour hr_loc_work_schedule');
949:
950: l_return := hr_loc_work_schedule.calc_sch_based_dur ( csr_rec.asg_id ,
951: 'H' ,
952: 'Y' ,

Line 963: hr_utility.trace(' Inside Day hr_loc_work_schedule');

959: l_duration := l_duration * 100 ;
960:
961: ELSE
962:
963: hr_utility.trace(' Inside Day hr_loc_work_schedule');
964:
965: l_return := hr_loc_work_schedule.calc_sch_based_dur ( csr_rec.asg_id ,
966: 'D' ,
967: 'Y' ,

Line 980: hr_utility.trace(' l_time_units:'||l_time_units);

976: END IF;
977:
978: l_time_units := l_duration;
979:
980: hr_utility.trace(' l_time_units:'||l_time_units);
981:
982: IF l_time_units < 0
983: THEN
984: l_sign_units := '-';

Line 989: hr_utility.trace(' Inside if csr_rec.asg_id <> l_asgid after variable initialized');

985: ELSE
986: l_sign_units := '+';
987: END IF;
988:
989: hr_utility.trace(' Inside if csr_rec.asg_id <> l_asgid after variable initialized');
990:
991: BEGIN
992: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
993: EXCEPTION

Line 1000: hr_utility.trace('After hr_nonrun_asact.insact');

996: END ;
997: -- Create the archive assignment action
998: hr_nonrun_asact.insact(l_actid ,csr_rec.asg_id ,p_payroll_action_id ,p_chunk,null);
999:
1000: hr_utility.trace('After hr_nonrun_asact.insact');
1001:
1002: hr_utility.trace(' csr_rec.asg_id l_loc_punit:'||l_loc_punit||'-'||csr_rec.asg_id );
1003: hr_utility.trace(' csr_rec.asg_id l_org_punit:'||l_org_punit||'-'||csr_rec.asg_id );
1004: hr_utility.trace(' csr_rec.asg_id l_punit:'||l_punit||'-'||csr_rec.asg_id );

Line 1002: hr_utility.trace(' csr_rec.asg_id l_loc_punit:'||l_loc_punit||'-'||csr_rec.asg_id );

998: hr_nonrun_asact.insact(l_actid ,csr_rec.asg_id ,p_payroll_action_id ,p_chunk,null);
999:
1000: hr_utility.trace('After hr_nonrun_asact.insact');
1001:
1002: hr_utility.trace(' csr_rec.asg_id l_loc_punit:'||l_loc_punit||'-'||csr_rec.asg_id );
1003: hr_utility.trace(' csr_rec.asg_id l_org_punit:'||l_org_punit||'-'||csr_rec.asg_id );
1004: hr_utility.trace(' csr_rec.asg_id l_punit:'||l_punit||'-'||csr_rec.asg_id );
1005: hr_utility.trace(' csr_rec.asg_id l_punit_code:'||l_punit_code||'-'||csr_rec.asg_id );
1006: --8820009

Line 1003: hr_utility.trace(' csr_rec.asg_id l_org_punit:'||l_org_punit||'-'||csr_rec.asg_id );

999:
1000: hr_utility.trace('After hr_nonrun_asact.insact');
1001:
1002: hr_utility.trace(' csr_rec.asg_id l_loc_punit:'||l_loc_punit||'-'||csr_rec.asg_id );
1003: hr_utility.trace(' csr_rec.asg_id l_org_punit:'||l_org_punit||'-'||csr_rec.asg_id );
1004: hr_utility.trace(' csr_rec.asg_id l_punit:'||l_punit||'-'||csr_rec.asg_id );
1005: hr_utility.trace(' csr_rec.asg_id l_punit_code:'||l_punit_code||'-'||csr_rec.asg_id );
1006: --8820009
1007: IF l_loc_id IS NOT NULL THEN

Line 1004: hr_utility.trace(' csr_rec.asg_id l_punit:'||l_punit||'-'||csr_rec.asg_id );

1000: hr_utility.trace('After hr_nonrun_asact.insact');
1001:
1002: hr_utility.trace(' csr_rec.asg_id l_loc_punit:'||l_loc_punit||'-'||csr_rec.asg_id );
1003: hr_utility.trace(' csr_rec.asg_id l_org_punit:'||l_org_punit||'-'||csr_rec.asg_id );
1004: hr_utility.trace(' csr_rec.asg_id l_punit:'||l_punit||'-'||csr_rec.asg_id );
1005: hr_utility.trace(' csr_rec.asg_id l_punit_code:'||l_punit_code||'-'||csr_rec.asg_id );
1006: --8820009
1007: IF l_loc_id IS NOT NULL THEN
1008: OPEN csr_location_info (l_loc_id);

Line 1005: hr_utility.trace(' csr_rec.asg_id l_punit_code:'||l_punit_code||'-'||csr_rec.asg_id );

1001:
1002: hr_utility.trace(' csr_rec.asg_id l_loc_punit:'||l_loc_punit||'-'||csr_rec.asg_id );
1003: hr_utility.trace(' csr_rec.asg_id l_org_punit:'||l_org_punit||'-'||csr_rec.asg_id );
1004: hr_utility.trace(' csr_rec.asg_id l_punit:'||l_punit||'-'||csr_rec.asg_id );
1005: hr_utility.trace(' csr_rec.asg_id l_punit_code:'||l_punit_code||'-'||csr_rec.asg_id );
1006: --8820009
1007: IF l_loc_id IS NOT NULL THEN
1008: OPEN csr_location_info (l_loc_id);
1009: FETCH csr_location_info INTO rg_csr_location_info;

Line 1012: hr_utility.trace(' csr_rec.asg_id l_loc_punit:'||l_loc_punit||'-'||csr_rec.asg_id );

1008: OPEN csr_location_info (l_loc_id);
1009: FETCH csr_location_info INTO rg_csr_location_info;
1010: IF csr_location_info%FOUND THEN
1011: l_loc_punit := rg_csr_location_info.lei_information1;
1012: hr_utility.trace(' csr_rec.asg_id l_loc_punit:'||l_loc_punit||'-'||csr_rec.asg_id );
1013: END IF;
1014: CLOSE csr_location_info;
1015: END IF;
1016: --8840262

Line 1022: hr_utility.trace(' csr_rec.asg_id l_loc_punit:'||l_org_punit||'-'||csr_rec.asg_id );

1018: OPEN csr_get_hr_org_info (l_hr_org_id);
1019: FETCH csr_get_hr_org_info INTO rg_csr_get_hr_org_info;
1020: IF csr_get_hr_org_info%FOUND THEN
1021: l_org_punit := rg_csr_get_hr_org_info.org_information6;
1022: hr_utility.trace(' csr_rec.asg_id l_loc_punit:'||l_org_punit||'-'||csr_rec.asg_id );
1023: END IF;
1024: CLOSE csr_get_hr_org_info;
1025: END IF;
1026:

Line 1049: hr_utility.trace(' csr_rec.asg_id l_loc_punit2:'||l_loc_punit||'-'||csr_rec.asg_id );

1045: END IF;
1046: */
1047: --8840262
1048: --8820009
1049: hr_utility.trace(' csr_rec.asg_id l_loc_punit2:'||l_loc_punit||'-'||csr_rec.asg_id );
1050: hr_utility.trace(' csr_rec.asg_id l_punit2:'||l_punit||'-'||csr_rec.asg_id );
1051: hr_utility.trace(' csr_rec.asg_id l_loc_id2:'||l_loc_id||'-'||csr_rec.asg_id );
1052:
1053: hr_utility.trace('l_punit: '||l_punit );

Line 1050: hr_utility.trace(' csr_rec.asg_id l_punit2:'||l_punit||'-'||csr_rec.asg_id );

1046: */
1047: --8840262
1048: --8820009
1049: hr_utility.trace(' csr_rec.asg_id l_loc_punit2:'||l_loc_punit||'-'||csr_rec.asg_id );
1050: hr_utility.trace(' csr_rec.asg_id l_punit2:'||l_punit||'-'||csr_rec.asg_id );
1051: hr_utility.trace(' csr_rec.asg_id l_loc_id2:'||l_loc_id||'-'||csr_rec.asg_id );
1052:
1053: hr_utility.trace('l_punit: '||l_punit );
1054:

Line 1051: hr_utility.trace(' csr_rec.asg_id l_loc_id2:'||l_loc_id||'-'||csr_rec.asg_id );

1047: --8840262
1048: --8820009
1049: hr_utility.trace(' csr_rec.asg_id l_loc_punit2:'||l_loc_punit||'-'||csr_rec.asg_id );
1050: hr_utility.trace(' csr_rec.asg_id l_punit2:'||l_punit||'-'||csr_rec.asg_id );
1051: hr_utility.trace(' csr_rec.asg_id l_loc_id2:'||l_loc_id||'-'||csr_rec.asg_id );
1052:
1053: hr_utility.trace('l_punit: '||l_punit );
1054:
1055: IF l_time_units <> 0 AND l_abs_code IS NOT NULL THEN --8789760

Line 1053: hr_utility.trace('l_punit: '||l_punit );

1049: hr_utility.trace(' csr_rec.asg_id l_loc_punit2:'||l_loc_punit||'-'||csr_rec.asg_id );
1050: hr_utility.trace(' csr_rec.asg_id l_punit2:'||l_punit||'-'||csr_rec.asg_id );
1051: hr_utility.trace(' csr_rec.asg_id l_loc_id2:'||l_loc_id||'-'||csr_rec.asg_id );
1052:
1053: hr_utility.trace('l_punit: '||l_punit );
1054:
1055: IF l_time_units <> 0 AND l_abs_code IS NOT NULL THEN --8789760
1056:
1057: hr_utility.trace(' creating pay_action_information_api.create_action_information ');

Line 1057: hr_utility.trace(' creating pay_action_information_api.create_action_information ');

1053: hr_utility.trace('l_punit: '||l_punit );
1054:
1055: IF l_time_units <> 0 AND l_abs_code IS NOT NULL THEN --8789760
1056:
1057: hr_utility.trace(' creating pay_action_information_api.create_action_information ');
1058:
1059: pay_action_information_api.create_action_information
1060: ( p_action_information_id => l_action_info_id -- OUT parameter
1061: ,p_object_version_number => l_ovn -- OUT parameter

Line 1088: hr_utility.trace('After pay_action_information_api.create_action_information ' );

1084: ,p_action_information16 => nvl(l_punit_code,l_punit) --LE's P Unit Code --8840262
1085: ,p_action_information17 => l_abs_start_time --Start time of Absence
1086: ,p_action_information18 => l_abs_end_time --End time of Absence
1087: );
1088: hr_utility.trace('After pay_action_information_api.create_action_information ' );
1089:
1090: END IF;
1091:
1092: --8789760

Line 1139: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',20);

1135: END LOOP;
1136:
1137:
1138: IF g_debug THEN
1139: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',20);
1140: END IF;
1141:
1142: EXCEPTION
1143: WHEN e_too_many_hours THEN

Line 1166: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',10);

1162:
1163: NULL;
1164:
1165: IF g_debug THEN
1166: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',10);
1167: END IF;
1168:
1169:
1170: IF g_debug THEN

Line 1171: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',20);

1167: END IF;
1168:
1169:
1170: IF g_debug THEN
1171: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',20);
1172: END IF;
1173:
1174: EXCEPTION WHEN OTHERS THEN
1175: g_err_num := SQLCODE;

Line 1178: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',30);

1174: EXCEPTION WHEN OTHERS THEN
1175: g_err_num := SQLCODE;
1176:
1177: IF g_debug THEN
1178: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',30);
1179: END IF;
1180:
1181: END INITIALIZATION_CODE;
1182:

Line 1192: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',10);

1188: IS
1189:
1190: BEGIN
1191: IF g_debug THEN
1192: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',10);
1193: END IF;
1194:
1195: IF g_debug THEN
1196: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',20);

Line 1196: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',20);

1192: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',10);
1193: END IF;
1194:
1195: IF g_debug THEN
1196: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',20);
1197: END IF;
1198:
1199: END ARCHIVE_CODE;
1200:

Line 1272: hr_utility.set_location('Entered Procedure GETDATA',10);

1268:
1269: l_payroll_action_id :=p_payroll_action_id;
1270:
1271: END IF;
1272: hr_utility.set_location('Entered Procedure GETDATA',10);
1273:
1274: /* Get the File Start and End Record Information */
1275: OPEN csr_get_hdr_info(l_payroll_action_id);
1276: FETCH csr_get_hdr_info INTO rec_get_hdr_info;

Line 1279: hr_utility.set_location('Before populating pl/sql table',20);

1275: OPEN csr_get_hdr_info(l_payroll_action_id);
1276: FETCH csr_get_hdr_info INTO rec_get_hdr_info;
1277: CLOSE csr_get_hdr_info;
1278:
1279: hr_utility.set_location('Before populating pl/sql table',20);
1280:
1281: ----------------------------------HEADER
1282:
1283: xml_tab(l_counter).TagName :='FILE_HEADER_FOOTER_START';

Line 1384: hr_utility.set_location('After populating pl/sql table',30);

1380: xml_tab(l_counter).TagName :='FILE_HEADER_FOOTER_START';
1381: xml_tab(l_counter).TagValue :='FILE_HEADER_FOOTER_END';
1382: l_counter := l_counter + 1;
1383:
1384: hr_utility.set_location('After populating pl/sql table',30);
1385: hr_utility.set_location('Entered Procedure GETDATA',10);
1386:
1387: WritetoCLOB (p_xml );
1388:

Line 1385: hr_utility.set_location('Entered Procedure GETDATA',10);

1381: xml_tab(l_counter).TagValue :='FILE_HEADER_FOOTER_END';
1382: l_counter := l_counter + 1;
1383:
1384: hr_utility.set_location('After populating pl/sql table',30);
1385: hr_utility.set_location('Entered Procedure GETDATA',10);
1386:
1387: WritetoCLOB (p_xml );
1388:
1389: END POPULATE_DATA;

Line 1411: hr_utility.set_location('Entering WritetoCLOB ',10);

1407: current_index pls_integer;
1408:
1409: BEGIN
1410:
1411: hr_utility.set_location('Entering WritetoCLOB ',10);
1412: l_IANA_charset :=PAY_DK_GENERAL.get_IANA_charset ;
1413: --l_str1 := ' ' ;
1414: l_str1 := ' ';
1415: l_str2 := '<';

Line 1488: hr_utility.set_location('Leaving WritetoCLOB ',20);

1484: END IF;
1485:
1486: p_xfdf_clob := l_xfdf_string;
1487:
1488: hr_utility.set_location('Leaving WritetoCLOB ',20);
1489:
1490:
1491: EXCEPTION
1492: WHEN OTHERS then

Line 1493: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);

1489:
1490:
1491: EXCEPTION
1492: WHEN OTHERS then
1493: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
1494: HR_UTILITY.RAISE_ERROR;
1495: END WritetoCLOB;
1496:
1497: END PAY_DK_ABSR_PKG;

Line 1494: HR_UTILITY.RAISE_ERROR;

1490:
1491: EXCEPTION
1492: WHEN OTHERS then
1493: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
1494: HR_UTILITY.RAISE_ERROR;
1495: END WritetoCLOB;
1496:
1497: END PAY_DK_ABSR_PKG;