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

Line 63: hr_utility.set_location('Entering psp_general.calc_sch_based_dur',10);

59: --
60: e_bad_time_format EXCEPTION;
61: --
62: BEGIN
63: hr_utility.set_location('Entering psp_general.calc_sch_based_dur',10);
64: p_duration := 0;
65: l_time_start := p_time_start;
66: l_time_end := p_time_end;
67: --

Line 88: hr_utility.trace('p_assignment_id ' ||p_assignment_id);

84: END IF;
85: l_start_date := TO_DATE(TO_CHAR(p_date_start,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
86: l_end_date := TO_DATE(TO_CHAR(p_date_end,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
87:
88: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
89: hr_utility.trace('l_start_date ' ||l_start_date);
90: hr_utility.trace('l_end_date ' ||l_end_date);
91: hr_utility.trace('p_time_start ' ||p_time_start);
92: hr_utility.trace('p_time_end ' ||p_time_end);

Line 89: hr_utility.trace('l_start_date ' ||l_start_date);

85: l_start_date := TO_DATE(TO_CHAR(p_date_start,'DD-MM-YYYY')||' '||l_time_start,'DD-MM-YYYY HH24:MI');
86: l_end_date := TO_DATE(TO_CHAR(p_date_end,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
87:
88: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
89: hr_utility.trace('l_start_date ' ||l_start_date);
90: hr_utility.trace('l_end_date ' ||l_end_date);
91: hr_utility.trace('p_time_start ' ||p_time_start);
92: hr_utility.trace('p_time_end ' ||p_time_end);
93: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);

Line 90: hr_utility.trace('l_end_date ' ||l_end_date);

86: l_end_date := TO_DATE(TO_CHAR(p_date_end,'DD-MM-YYYY')||' '||l_time_end,'DD-MM-YYYY HH24:MI');
87:
88: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
89: hr_utility.trace('l_start_date ' ||l_start_date);
90: hr_utility.trace('l_end_date ' ||l_end_date);
91: hr_utility.trace('p_time_start ' ||p_time_start);
92: hr_utility.trace('p_time_end ' ||p_time_end);
93: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
94:

Line 91: hr_utility.trace('p_time_start ' ||p_time_start);

87:
88: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
89: hr_utility.trace('l_start_date ' ||l_start_date);
90: hr_utility.trace('l_end_date ' ||l_end_date);
91: hr_utility.trace('p_time_start ' ||p_time_start);
92: hr_utility.trace('p_time_end ' ||p_time_end);
93: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
94:
95: --

Line 92: hr_utility.trace('p_time_end ' ||p_time_end);

88: hr_utility.trace('p_assignment_id ' ||p_assignment_id);
89: hr_utility.trace('l_start_date ' ||l_start_date);
90: hr_utility.trace('l_end_date ' ||l_end_date);
91: hr_utility.trace('p_time_start ' ||p_time_start);
92: hr_utility.trace('p_time_end ' ||p_time_end);
93: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
94:
95: --
96: -- Fetch the work schedule

Line 93: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);

89: hr_utility.trace('l_start_date ' ||l_start_date);
90: hr_utility.trace('l_end_date ' ||l_end_date);
91: hr_utility.trace('p_time_start ' ||p_time_start);
92: hr_utility.trace('p_time_end ' ||p_time_end);
93: hr_utility.trace('p_days_or_hours ' ||p_days_or_hours);
94:
95: --
96: -- Fetch the work schedule
97: --

Line 112: hr_utility.trace('l_return_status ' ||l_return_status);

108: , x_return_message => l_return_message
109: );
110: --
111:
112: hr_utility.trace('l_return_status ' ||l_return_status);
113: IF l_return_status = '0' THEN
114: --
115: -- Calculate duration
116: --

Line 118: hr_utility.trace('l_idx ' || l_idx);

114: --
115: -- Calculate duration
116: --
117: l_idx := l_schedule.first;
118: hr_utility.trace('l_idx ' || l_idx);
119: hr_utility.trace('Schedule Counts ' ||l_schedule.count);
120: --
121: IF p_days_or_hours = 'D' THEN
122: --

Line 119: hr_utility.trace('Schedule Counts ' ||l_schedule.count);

115: -- Calculate duration
116: --
117: l_idx := l_schedule.first;
118: hr_utility.trace('l_idx ' || l_idx);
119: hr_utility.trace('Schedule Counts ' ||l_schedule.count);
120: --
121: IF p_days_or_hours = 'D' THEN
122: --
123: l_first_band := TRUE;

Line 152: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE ' || l_schedule(l_idx).FREE_BUSY_TYPE );

148: l_day_start_time := '00:00';
149: l_day_end_time := '23:59';
150: WHILE l_idx IS NOT NULL
151: LOOP
152: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
153: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
154: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
155:
156: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN

Line 153: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );

149: l_day_end_time := '23:59';
150: WHILE l_idx IS NOT NULL
151: LOOP
152: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
153: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
154: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
155:
156: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
157: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );

Line 154: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );

150: WHILE l_idx IS NOT NULL
151: LOOP
152: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
153: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
154: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
155:
156: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
157: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
158: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN

Line 157: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );

153: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
154: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
155:
156: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
157: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
158: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
159: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
160: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
161: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );

Line 159: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );

155:
156: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
157: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
158: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
159: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
160: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
161: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
162: IF l_schedule(l_idx).END_DATE_TIME < l_schedule(l_idx).START_DATE_TIME THEN
163: -- Skip this invalid slot which ends before it starts

Line 160: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );

156: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
157: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
158: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
159: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
160: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
161: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
162: IF l_schedule(l_idx).END_DATE_TIME < l_schedule(l_idx).START_DATE_TIME THEN
163: -- Skip this invalid slot which ends before it starts
164: NULL;

Line 161: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );

157: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is not null ' || l_schedule(l_idx).FREE_BUSY_TYPE );
158: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN
159: hr_utility.trace('l_schedule(l_idx).FREE_BUSY_TYPE is FREE ' || l_schedule(l_idx).FREE_BUSY_TYPE );
160: hr_utility.trace('l_schedule(l_idx).END_DATE_TIME ' || l_schedule(l_idx).END_DATE_TIME );
161: hr_utility.trace('l_schedule(l_idx).START_DATE_TIME ' || l_schedule(l_idx).START_DATE_TIME );
162: IF l_schedule(l_idx).END_DATE_TIME < l_schedule(l_idx).START_DATE_TIME THEN
163: -- Skip this invalid slot which ends before it starts
164: NULL;
165: ELSE

Line 171: hr_utility.trace('l_start_time ' || l_start_time);

167: -- Start and End on different days
168: --
169: -- Get first day hours
170: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
171: hr_utility.trace('l_start_time ' || l_start_time);
172:
173: SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
174: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
175: INTO p_duration

Line 177: -- hr_utility.trace('p_start_duration ' || p_start_duration);

173: SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
174: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
175: INTO p_duration
176: FROM DUAL;
177: -- hr_utility.trace('p_start_duration ' || p_start_duration);
178: hr_utility.trace('Start p_duration ' || p_duration);
179:
180: --
181: -- Get last day hours

Line 178: hr_utility.trace('Start p_duration ' || p_duration);

174: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
175: INTO p_duration
176: FROM DUAL;
177: -- hr_utility.trace('p_start_duration ' || p_start_duration);
178: hr_utility.trace('Start p_duration ' || p_duration);
179:
180: --
181: -- Get last day hours
182: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');

Line 183: hr_utility.trace('l_end_time ' || l_end_time);

179:
180: --
181: -- Get last day hours
182: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
183: hr_utility.trace('l_end_time ' || l_end_time);
184: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
185: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
186: INTO p_duration
187: FROM DUAL;

Line 188: --hr_utility.trace('p_end_duration ' || p_end_duration);

184: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
185: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
186: INTO p_duration
187: FROM DUAL;
188: --hr_utility.trace('p_end_duration ' || p_end_duration);
189: hr_utility.trace('End p_duration ' || p_duration);
190: --
191: -- Get between full day hours
192: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)

Line 189: hr_utility.trace('End p_duration ' || p_duration);

185: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
186: INTO p_duration
187: FROM DUAL;
188: --hr_utility.trace('p_end_duration ' || p_end_duration);
189: hr_utility.trace('End p_duration ' || p_duration);
190: --
191: -- Get between full day hours
192: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
193: INTO p_duration

Line 200: hr_utility.trace('l_start_time ' || l_start_time);

196: -- Start and End on same day
197: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
198: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
199:
200: hr_utility.trace('l_start_time ' || l_start_time);
201: hr_utility.trace('l_end_time ' || l_end_time);
202:
203: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
204: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)

Line 201: hr_utility.trace('l_end_time ' || l_end_time);

197: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
198: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
199:
200: hr_utility.trace('l_start_time ' || l_start_time);
201: hr_utility.trace('l_end_time ' || l_end_time);
202:
203: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
204: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
205: INTO p_duration

Line 207: hr_utility.trace('duration l_idx '||l_idx||' ' ||p_duration);

203: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
204: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
205: INTO p_duration
206: FROM DUAL;
207: hr_utility.trace('duration l_idx '||l_idx||' ' ||p_duration);
208:
209: END IF;
210: END IF;
211: END IF;

Line 215: hr_utility.trace('duration ' ||p_duration);

211: END IF;
212: END IF;
213: l_idx := l_schedule(l_idx).NEXT_OBJECT_INDEX;
214: END LOOP;
215: hr_utility.trace('duration ' ||p_duration);
216:
217: p_duration := ROUND(p_duration,2);
218: --
219: END IF;

Line 222: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',20);

218: --
219: END IF;
220: END IF;
221: --
222: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',20);
223: EXCEPTION
224: --
225: WHEN e_bad_time_format THEN
226: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',30);

Line 226: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',30);

222: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',20);
223: EXCEPTION
224: --
225: WHEN e_bad_time_format THEN
226: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',30);
227: hr_utility.set_location(SQLERRM,35);
228: RAISE;
229: WHEN OTHERS THEN
230: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',40);

Line 227: hr_utility.set_location(SQLERRM,35);

223: EXCEPTION
224: --
225: WHEN e_bad_time_format THEN
226: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',30);
227: hr_utility.set_location(SQLERRM,35);
228: RAISE;
229: WHEN OTHERS THEN
230: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',40);
231: hr_utility.set_location(SQLERRM,45);

Line 230: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',40);

226: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',30);
227: hr_utility.set_location(SQLERRM,35);
228: RAISE;
229: WHEN OTHERS THEN
230: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',40);
231: hr_utility.set_location(SQLERRM,45);
232: RAISE;
233: END calc_sch_based_dur;
234:

Line 231: hr_utility.set_location(SQLERRM,45);

227: hr_utility.set_location(SQLERRM,35);
228: RAISE;
229: WHEN OTHERS THEN
230: hr_utility.set_location('Leaving psp_general.calc_sch_based_dur',40);
231: hr_utility.set_location(SQLERRM,45);
232: RAISE;
233: END calc_sch_based_dur;
234:
235: FUNCTION p_org_exists(organization_id1 IN NUMBER)

Line 2961: l_debug_enabled BOOLEAN := hr_utility.Debug_enabled();

2957: p_task_id IN NUMBER DEFAULT NULL)
2958: RETURN NUMBER
2959: IS
2960: l_record_count NUMBER;
2961: l_debug_enabled BOOLEAN := hr_utility.Debug_enabled();
2962: l_package VARCHAR2(30) := ' psp_general.';
2963: l_proc VARCHAR2(100);
2964: l_return_code NUMBER;
2965: l_return_flag NUMBER;

Line 2989: hr_utility.trace('Entering:'|| l_proc);

2985: BEGIN
2986:
2987: IF l_debug_enabled THEN
2988: l_proc := l_package||'chk_param_valid';
2989: hr_utility.trace('Entering:'|| l_proc);
2990: END IF;
2991:
2992: IF p_project_id IS NULL AND p_task_id IS NULL
2993: THEN

Line 2996: hr_utility.trace(l_proc);

2992: IF p_project_id IS NULL AND p_task_id IS NULL
2993: THEN
2994: IF l_debug_enabled THEN
2995: l_proc := l_package||'chk_param_valid => p_project_id IS NULL AND p_task_id IS NULL';
2996: hr_utility.trace(l_proc);
2997: END IF;
2998:
2999: l_return_code := 1;
3000: RETURN l_return_code;

Line 3007: hr_utility.trace('Entering:'|| l_proc);

3003: IF p_project_id IS NOT NULL
3004: THEN
3005: IF l_debug_enabled THEN
3006: l_proc := l_package||'chk_param_valid => c_proj_exists';
3007: hr_utility.trace('Entering:'|| l_proc);
3008: END IF;
3009:
3010: OPEN c_proj_exists;
3011: FETCH c_proj_exists INTO l_proj_task_id;

Line 3022: hr_utility.trace('Leaving:'|| l_proc);

3018: END IF;
3019:
3020: IF l_debug_enabled THEN
3021: l_proc := l_package||'chk_param_valid => c_proj_exists';
3022: hr_utility.trace('Leaving:'|| l_proc);
3023: END IF;
3024: END IF;
3025:
3026: IF p_task_id IS NOT NULL

Line 3030: hr_utility.trace('Entering:'|| l_proc);

3026: IF p_task_id IS NOT NULL
3027: THEN
3028: IF l_debug_enabled THEN
3029: l_proc := l_package||'chk_param_valid => c_task_exists';
3030: hr_utility.trace('Entering:'|| l_proc);
3031: END IF;
3032:
3033:
3034: OPEN c_task_exists;

Line 3046: hr_utility.trace('Leaving:'|| l_proc);

3042: END IF;
3043:
3044: IF l_debug_enabled THEN
3045: l_proc := l_package||'chk_param_valid => c_task_exists';
3046: hr_utility.trace('Leaving:'|| l_proc);
3047: END IF;
3048: END IF;
3049: END IF;
3050:

Line 3053: hr_utility.trace('Leaving:'|| l_proc);

3049: END IF;
3050:
3051: IF l_debug_enabled THEN
3052: l_proc := l_package||'chk_param_valid';
3053: hr_utility.trace('Leaving:'|| l_proc);
3054: END IF;
3055: RETURN l_return_code;
3056: EXCEPTION
3057: WHEN OTHERS THEN

Line 3058: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3054: END IF;
3055: RETURN l_return_code;
3056: EXCEPTION
3057: WHEN OTHERS THEN
3058: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3059: hr_utility.TRACE ('chk_param_valid => sqlerrm is ' || SQLERRM);
3060: hr_utility.TRACE ('chk_param_valid => sqlcode is ' || SQLCODE);
3061: RAISE;
3062: END chk_param_valid;

Line 3059: hr_utility.TRACE ('chk_param_valid => sqlerrm is ' || SQLERRM);

3055: RETURN l_return_code;
3056: EXCEPTION
3057: WHEN OTHERS THEN
3058: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3059: hr_utility.TRACE ('chk_param_valid => sqlerrm is ' || SQLERRM);
3060: hr_utility.TRACE ('chk_param_valid => sqlcode is ' || SQLCODE);
3061: RAISE;
3062: END chk_param_valid;
3063:

Line 3060: hr_utility.TRACE ('chk_param_valid => sqlcode is ' || SQLCODE);

3056: EXCEPTION
3057: WHEN OTHERS THEN
3058: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3059: hr_utility.TRACE ('chk_param_valid => sqlerrm is ' || SQLERRM);
3060: hr_utility.TRACE ('chk_param_valid => sqlcode is ' || SQLCODE);
3061: RAISE;
3062: END chk_param_valid;
3063:
3064: FUNCTION chk_global_element_level

Line 3080: hr_utility.Trace('Entering:'|| l_proc);

3076: BEGIN
3077:
3078: IF l_debug_enabled THEN
3079: l_proc := l_package||'chk_global_element_level';
3080: hr_utility.Trace('Entering:'|| l_proc);
3081: END IF;
3082:
3083: OPEN c_glb_element_level;
3084: FETCH c_glb_element_level INTO l_record_count;

Line 3095: hr_utility.trace('Leaving:'|| l_proc);

3091: END IF;
3092:
3093: IF l_debug_enabled THEN
3094: l_proc := l_package||'chk_global_element_level';
3095: hr_utility.trace('Leaving:'|| l_proc);
3096: END IF;
3097: RETURN l_return_code;
3098: EXCEPTION
3099: WHEN OTHERS THEN

Line 3100: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3096: END IF;
3097: RETURN l_return_code;
3098: EXCEPTION
3099: WHEN OTHERS THEN
3100: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3101: hr_utility.TRACE ('chk_global_element_level => sqlerrm is ' || SQLERRM);
3102: hr_utility.TRACE ('chk_global_element_level => sqlcode is ' || SQLCODE);
3103: RAISE;
3104: END chk_global_element_level;

Line 3101: hr_utility.TRACE ('chk_global_element_level => sqlerrm is ' || SQLERRM);

3097: RETURN l_return_code;
3098: EXCEPTION
3099: WHEN OTHERS THEN
3100: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3101: hr_utility.TRACE ('chk_global_element_level => sqlerrm is ' || SQLERRM);
3102: hr_utility.TRACE ('chk_global_element_level => sqlcode is ' || SQLCODE);
3103: RAISE;
3104: END chk_global_element_level;
3105:

Line 3102: hr_utility.TRACE ('chk_global_element_level => sqlcode is ' || SQLCODE);

3098: EXCEPTION
3099: WHEN OTHERS THEN
3100: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3101: hr_utility.TRACE ('chk_global_element_level => sqlerrm is ' || SQLERRM);
3102: hr_utility.TRACE ('chk_global_element_level => sqlcode is ' || SQLCODE);
3103: RAISE;
3104: END chk_global_element_level;
3105:
3106: FUNCTION chk_element_level

Line 3124: hr_utility.trace('Entering:'|| l_proc);

3120: BEGIN
3121:
3122: IF l_debug_enabled THEN
3123: l_proc := l_package||'chk_element_level';
3124: hr_utility.trace('Entering:'|| l_proc);
3125: END IF;
3126:
3127: OPEN c_element_level;
3128: FETCH c_element_level INTO l_record_count;

Line 3139: hr_utility.trace('Leaving:'|| l_proc);

3135: END IF;
3136:
3137: IF l_debug_enabled THEN
3138: l_proc := l_package||'chk_element_level';
3139: hr_utility.trace('Leaving:'|| l_proc);
3140: END IF;
3141: RETURN l_return_code;
3142: EXCEPTION
3143: WHEN OTHERS THEN

Line 3144: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3140: END IF;
3141: RETURN l_return_code;
3142: EXCEPTION
3143: WHEN OTHERS THEN
3144: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3145: hr_utility.TRACE ('chk_element_level => sqlerrm is ' || SQLERRM);
3146: hr_utility.TRACE ('chk_element_level => sqlcode is ' || SQLCODE);
3147: RAISE;
3148: END chk_element_level;

Line 3145: hr_utility.TRACE ('chk_element_level => sqlerrm is ' || SQLERRM);

3141: RETURN l_return_code;
3142: EXCEPTION
3143: WHEN OTHERS THEN
3144: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3145: hr_utility.TRACE ('chk_element_level => sqlerrm is ' || SQLERRM);
3146: hr_utility.TRACE ('chk_element_level => sqlcode is ' || SQLCODE);
3147: RAISE;
3148: END chk_element_level;
3149:

Line 3146: hr_utility.TRACE ('chk_element_level => sqlcode is ' || SQLCODE);

3142: EXCEPTION
3143: WHEN OTHERS THEN
3144: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3145: hr_utility.TRACE ('chk_element_level => sqlerrm is ' || SQLERRM);
3146: hr_utility.TRACE ('chk_element_level => sqlcode is ' || SQLCODE);
3147: RAISE;
3148: END chk_element_level;
3149:
3150: FUNCTION chk_element_Group_level

Line 3167: hr_utility.trace('Entering:'|| l_proc);

3163: BEGIN
3164:
3165: IF l_debug_enabled THEN
3166: l_proc := l_package||'chk_element_Group_level';
3167: hr_utility.trace('Entering:'|| l_proc);
3168: END IF;
3169:
3170: OPEN c_element_Group_level;
3171: FETCH c_element_Group_level INTO l_record_count;

Line 3182: hr_utility.trace('Leaving:'|| l_proc);

3178: END IF;
3179:
3180: IF l_debug_enabled THEN
3181: l_proc := l_package||'chk_element_Group_level';
3182: hr_utility.trace('Leaving:'|| l_proc);
3183: END IF;
3184: RETURN l_return_code;
3185: EXCEPTION
3186: WHEN OTHERS THEN

Line 3187: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3183: END IF;
3184: RETURN l_return_code;
3185: EXCEPTION
3186: WHEN OTHERS THEN
3187: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3188: hr_utility.TRACE ('chk_element_Group_level => sqlerrm is ' || SQLERRM);
3189: hr_utility.TRACE ('chk_element_Group_level => sqlcode is ' || SQLCODE);
3190: RAISE;
3191: END chk_element_Group_level;

Line 3188: hr_utility.TRACE ('chk_element_Group_level => sqlerrm is ' || SQLERRM);

3184: RETURN l_return_code;
3185: EXCEPTION
3186: WHEN OTHERS THEN
3187: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3188: hr_utility.TRACE ('chk_element_Group_level => sqlerrm is ' || SQLERRM);
3189: hr_utility.TRACE ('chk_element_Group_level => sqlcode is ' || SQLCODE);
3190: RAISE;
3191: END chk_element_Group_level;
3192:

Line 3189: hr_utility.TRACE ('chk_element_Group_level => sqlcode is ' || SQLCODE);

3185: EXCEPTION
3186: WHEN OTHERS THEN
3187: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3188: hr_utility.TRACE ('chk_element_Group_level => sqlerrm is ' || SQLERRM);
3189: hr_utility.TRACE ('chk_element_Group_level => sqlcode is ' || SQLCODE);
3190: RAISE;
3191: END chk_element_Group_level;
3192:
3193: FUNCTION chk_assignment_level

Line 3211: hr_utility.trace('Entering:'|| l_proc);

3207: BEGIN
3208:
3209: IF l_debug_enabled THEN
3210: l_proc := l_package||'chk_assignment_level';
3211: hr_utility.trace('Entering:'|| l_proc);
3212: END IF;
3213:
3214: OPEN c_assignment_level;
3215: FETCH c_assignment_level INTO l_record_count;

Line 3226: hr_utility.trace('Leaving:'|| l_proc);

3222: END IF;
3223:
3224: IF l_debug_enabled THEN
3225: l_proc := l_package||'chk_assignment_level';
3226: hr_utility.trace('Leaving:'|| l_proc);
3227: END IF;
3228: RETURN l_return_code;
3229: EXCEPTION
3230: WHEN OTHERS THEN

Line 3231: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3227: END IF;
3228: RETURN l_return_code;
3229: EXCEPTION
3230: WHEN OTHERS THEN
3231: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3232: hr_utility.TRACE ('chk_assignment_level => sqlerrm is ' || SQLERRM);
3233: hr_utility.TRACE ('chk_assignment_level => sqlcode is ' || SQLCODE);
3234: RAISE;
3235: END chk_assignment_level;

Line 3232: hr_utility.TRACE ('chk_assignment_level => sqlerrm is ' || SQLERRM);

3228: RETURN l_return_code;
3229: EXCEPTION
3230: WHEN OTHERS THEN
3231: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3232: hr_utility.TRACE ('chk_assignment_level => sqlerrm is ' || SQLERRM);
3233: hr_utility.TRACE ('chk_assignment_level => sqlcode is ' || SQLCODE);
3234: RAISE;
3235: END chk_assignment_level;
3236:

Line 3233: hr_utility.TRACE ('chk_assignment_level => sqlcode is ' || SQLCODE);

3229: EXCEPTION
3230: WHEN OTHERS THEN
3231: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3232: hr_utility.TRACE ('chk_assignment_level => sqlerrm is ' || SQLERRM);
3233: hr_utility.TRACE ('chk_assignment_level => sqlcode is ' || SQLCODE);
3234: RAISE;
3235: END chk_assignment_level;
3236:
3237: FUNCTION chk_default_labor_schedule

Line 3252: hr_utility.trace('Entering:'|| l_proc);

3248: BEGIN
3249:
3250: IF l_debug_enabled THEN
3251: l_proc := l_package||'chk_default_labor_schedule';
3252: hr_utility.trace('Entering:'|| l_proc);
3253: END IF;
3254:
3255: OPEN c_default_labor_schedule;
3256: FETCH c_default_labor_schedule INTO l_record_count;

Line 3267: hr_utility.trace('Leaving:'|| l_proc);

3263: END IF;
3264:
3265: IF l_debug_enabled THEN
3266: l_proc := l_package||'chk_default_labor_schedule';
3267: hr_utility.trace('Leaving:'|| l_proc);
3268: END IF;
3269: RETURN l_return_code;
3270: EXCEPTION
3271: WHEN OTHERS THEN

Line 3272: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3268: END IF;
3269: RETURN l_return_code;
3270: EXCEPTION
3271: WHEN OTHERS THEN
3272: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3273: hr_utility.TRACE ('chk_default_labor_schedule => sqlerrm is ' || SQLERRM);
3274: hr_utility.TRACE ('chk_default_labor_schedule => sqlcode is ' || SQLCODE);
3275: RAISE;
3276: END chk_default_labor_schedule;

Line 3273: hr_utility.TRACE ('chk_default_labor_schedule => sqlerrm is ' || SQLERRM);

3269: RETURN l_return_code;
3270: EXCEPTION
3271: WHEN OTHERS THEN
3272: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3273: hr_utility.TRACE ('chk_default_labor_schedule => sqlerrm is ' || SQLERRM);
3274: hr_utility.TRACE ('chk_default_labor_schedule => sqlcode is ' || SQLCODE);
3275: RAISE;
3276: END chk_default_labor_schedule;
3277:

Line 3274: hr_utility.TRACE ('chk_default_labor_schedule => sqlcode is ' || SQLCODE);

3270: EXCEPTION
3271: WHEN OTHERS THEN
3272: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3273: hr_utility.TRACE ('chk_default_labor_schedule => sqlerrm is ' || SQLERRM);
3274: hr_utility.TRACE ('chk_default_labor_schedule => sqlcode is ' || SQLCODE);
3275: RAISE;
3276: END chk_default_labor_schedule;
3277:
3278: FUNCTION chk_Org_Default_Account

Line 3294: hr_utility.trace('Entering:'|| l_proc);

3290: BEGIN
3291:
3292: IF l_debug_enabled THEN
3293: l_proc := l_package||'chk_Org_Default_Account';
3294: hr_utility.trace('Entering:'|| l_proc);
3295: END IF;
3296:
3297: OPEN c_Organization_Default_Account;
3298: FETCH c_Organization_Default_Account INTO l_record_count;

Line 3309: hr_utility.trace('Leaving:'|| l_proc);

3305: END IF;
3306:
3307: IF l_debug_enabled THEN
3308: l_proc := l_package||'chk_Org_Default_Account';
3309: hr_utility.trace('Leaving:'|| l_proc);
3310: END IF;
3311: RETURN l_return_code;
3312: EXCEPTION
3313: WHEN OTHERS THEN

Line 3314: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3310: END IF;
3311: RETURN l_return_code;
3312: EXCEPTION
3313: WHEN OTHERS THEN
3314: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3315: hr_utility.TRACE ('chk_Org_Default_Account => sqlerrm is ' || SQLERRM);
3316: hr_utility.TRACE ('chk_Org_Default_Account => sqlcode is ' || SQLCODE);
3317: RAISE;
3318: END chk_Org_Default_Account;

Line 3315: hr_utility.TRACE ('chk_Org_Default_Account => sqlerrm is ' || SQLERRM);

3311: RETURN l_return_code;
3312: EXCEPTION
3313: WHEN OTHERS THEN
3314: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3315: hr_utility.TRACE ('chk_Org_Default_Account => sqlerrm is ' || SQLERRM);
3316: hr_utility.TRACE ('chk_Org_Default_Account => sqlcode is ' || SQLCODE);
3317: RAISE;
3318: END chk_Org_Default_Account;
3319:

Line 3316: hr_utility.TRACE ('chk_Org_Default_Account => sqlcode is ' || SQLCODE);

3312: EXCEPTION
3313: WHEN OTHERS THEN
3314: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3315: hr_utility.TRACE ('chk_Org_Default_Account => sqlerrm is ' || SQLERRM);
3316: hr_utility.TRACE ('chk_Org_Default_Account => sqlcode is ' || SQLCODE);
3317: RAISE;
3318: END chk_Org_Default_Account;
3319:
3320: FUNCTION chk_Suspense_Account_Level

Line 3336: hr_utility.trace('Entering:'|| l_proc);

3332: BEGIN
3333:
3334: IF l_debug_enabled THEN
3335: l_proc := l_package||'chk_Suspense_Account_Level';
3336: hr_utility.trace('Entering:'|| l_proc);
3337: END IF;
3338:
3339: OPEN c_Suspense_Account_Level;
3340: FETCH c_Suspense_Account_Level INTO l_record_count;

Line 3351: hr_utility.trace('Leaving:'|| l_proc);

3347: END IF;
3348:
3349: IF l_debug_enabled THEN
3350: l_proc := l_package||'chk_Suspense_Account_Level';
3351: hr_utility.trace('Leaving:'|| l_proc);
3352: END IF;
3353: RETURN l_return_code;
3354: EXCEPTION
3355: WHEN OTHERS THEN

Line 3356: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3352: END IF;
3353: RETURN l_return_code;
3354: EXCEPTION
3355: WHEN OTHERS THEN
3356: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3357: hr_utility.TRACE ('chk_Suspense_Account_Level => sqlerrm is ' || SQLERRM);
3358: hr_utility.TRACE ('chk_Suspense_Account_Level => sqlcode is ' || SQLCODE);
3359: RAISE;
3360: END chk_Suspense_Account_Level;

Line 3357: hr_utility.TRACE ('chk_Suspense_Account_Level => sqlerrm is ' || SQLERRM);

3353: RETURN l_return_code;
3354: EXCEPTION
3355: WHEN OTHERS THEN
3356: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3357: hr_utility.TRACE ('chk_Suspense_Account_Level => sqlerrm is ' || SQLERRM);
3358: hr_utility.TRACE ('chk_Suspense_Account_Level => sqlcode is ' || SQLCODE);
3359: RAISE;
3360: END chk_Suspense_Account_Level;
3361:

Line 3358: hr_utility.TRACE ('chk_Suspense_Account_Level => sqlcode is ' || SQLCODE);

3354: EXCEPTION
3355: WHEN OTHERS THEN
3356: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3357: hr_utility.TRACE ('chk_Suspense_Account_Level => sqlerrm is ' || SQLERRM);
3358: hr_utility.TRACE ('chk_Suspense_Account_Level => sqlcode is ' || SQLCODE);
3359: RAISE;
3360: END chk_Suspense_Account_Level;
3361:
3362:

Line 3379: hr_utility.trace('Entering:'|| l_proc);

3375: BEGIN
3376:
3377: IF l_debug_enabled THEN
3378: l_proc := l_package||'chk_Generic_Sus_Account_Level';
3379: hr_utility.trace('Entering:'|| l_proc);
3380: END IF;
3381:
3382: OPEN c_Generic_Susp_Account_Level;
3383: FETCH c_Generic_Susp_Account_Level INTO l_record_count;

Line 3394: hr_utility.trace('Leaving:'|| l_proc);

3390: END IF;
3391:
3392: IF l_debug_enabled THEN
3393: l_proc := l_package||'chk_Generic_Sus_Account_Level';
3394: hr_utility.trace('Leaving:'|| l_proc);
3395: END IF;
3396: RETURN l_return_code;
3397: EXCEPTION
3398: WHEN OTHERS THEN

Line 3399: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3395: END IF;
3396: RETURN l_return_code;
3397: EXCEPTION
3398: WHEN OTHERS THEN
3399: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3400: hr_utility.TRACE ('chk_Generic_Sus_Account_Level => sqlerrm is ' || SQLERRM);
3401: hr_utility.TRACE ('chk_Generic_Sus_Account_Level => sqlcode is ' || SQLCODE);
3402: RAISE;
3403: END chk_Generic_Sus_Account_Level;

Line 3400: hr_utility.TRACE ('chk_Generic_Sus_Account_Level => sqlerrm is ' || SQLERRM);

3396: RETURN l_return_code;
3397: EXCEPTION
3398: WHEN OTHERS THEN
3399: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3400: hr_utility.TRACE ('chk_Generic_Sus_Account_Level => sqlerrm is ' || SQLERRM);
3401: hr_utility.TRACE ('chk_Generic_Sus_Account_Level => sqlcode is ' || SQLCODE);
3402: RAISE;
3403: END chk_Generic_Sus_Account_Level;
3404:

Line 3401: hr_utility.TRACE ('chk_Generic_Sus_Account_Level => sqlcode is ' || SQLCODE);

3397: EXCEPTION
3398: WHEN OTHERS THEN
3399: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3400: hr_utility.TRACE ('chk_Generic_Sus_Account_Level => sqlerrm is ' || SQLERRM);
3401: hr_utility.TRACE ('chk_Generic_Sus_Account_Level => sqlcode is ' || SQLCODE);
3402: RAISE;
3403: END chk_Generic_Sus_Account_Level;
3404:
3405: FUNCTION chk_Org_Excess_Salary_Account

Line 3420: hr_utility.trace('Entering:'|| l_proc);

3416: BEGIN
3417:
3418: IF l_debug_enabled THEN
3419: l_proc := l_package||'chk_Org_Excess_Salary_Account';
3420: hr_utility.trace('Entering:'|| l_proc);
3421: END IF;
3422:
3423: OPEN c_Org_Excess_Salary_Account;
3424: FETCH c_Org_Excess_Salary_Account INTO l_record_count;

Line 3435: hr_utility.trace('Leaving:'|| l_proc);

3431: END IF;
3432:
3433: IF l_debug_enabled THEN
3434: l_proc := l_package||'chk_Org_Excess_Salary_Account';
3435: hr_utility.trace('Leaving:'|| l_proc);
3436: END IF;
3437: RETURN l_return_code;
3438: EXCEPTION
3439: WHEN OTHERS THEN

Line 3440: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3436: END IF;
3437: RETURN l_return_code;
3438: EXCEPTION
3439: WHEN OTHERS THEN
3440: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3441: hr_utility.TRACE ('chk_Org_Excess_Salary_Account => sqlerrm is ' || SQLERRM);
3442: hr_utility.TRACE ('chk_Org_Excess_Salary_Account => sqlcode is ' || SQLCODE);
3443: RAISE;
3444: END chk_Org_Excess_Salary_Account;

Line 3441: hr_utility.TRACE ('chk_Org_Excess_Salary_Account => sqlerrm is ' || SQLERRM);

3437: RETURN l_return_code;
3438: EXCEPTION
3439: WHEN OTHERS THEN
3440: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3441: hr_utility.TRACE ('chk_Org_Excess_Salary_Account => sqlerrm is ' || SQLERRM);
3442: hr_utility.TRACE ('chk_Org_Excess_Salary_Account => sqlcode is ' || SQLCODE);
3443: RAISE;
3444: END chk_Org_Excess_Salary_Account;
3445:

Line 3442: hr_utility.TRACE ('chk_Org_Excess_Salary_Account => sqlcode is ' || SQLCODE);

3438: EXCEPTION
3439: WHEN OTHERS THEN
3440: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3441: hr_utility.TRACE ('chk_Org_Excess_Salary_Account => sqlerrm is ' || SQLERRM);
3442: hr_utility.TRACE ('chk_Org_Excess_Salary_Account => sqlcode is ' || SQLCODE);
3443: RAISE;
3444: END chk_Org_Excess_Salary_Account;
3445:
3446: FUNCTION chk_for_enc_liq_summ_lines

Line 3468: hr_utility.trace('Entering:'|| l_proc);

3464: BEGIN
3465:
3466: IF l_debug_enabled THEN
3467: l_proc := l_package||'chk_for_enc_liq_summ_lines.c_enc_summary_lines';
3468: hr_utility.trace('Entering:'|| l_proc);
3469: END IF;
3470:
3471: OPEN c_enc_summary_lines;
3472: FETCH c_enc_summary_lines INTO l_record_count;

Line 3483: hr_utility.trace('Leaving:'|| l_proc);

3479: END IF;
3480:
3481: IF l_debug_enabled THEN
3482: l_proc := l_package||'chk_for_enc_liq_summ_lines.c_enc_summary_lines';
3483: hr_utility.trace('Leaving:'|| l_proc);
3484: END IF;
3485:
3486: IF l_debug_enabled THEN
3487: l_proc := l_package||'chk_for_enc_liq_summ_lines.c_enc_summary_lines_arch';

Line 3488: hr_utility.trace('Entering:'|| l_proc);

3484: END IF;
3485:
3486: IF l_debug_enabled THEN
3487: l_proc := l_package||'chk_for_enc_liq_summ_lines.c_enc_summary_lines_arch';
3488: hr_utility.trace('Entering:'|| l_proc);
3489: END IF;
3490:
3491: OPEN c_enc_summary_lines_arch;
3492: FETCH c_enc_summary_lines_arch INTO l_record_count;

Line 3503: hr_utility.trace('Leaving:'|| l_proc);

3499: END IF;
3500:
3501: IF l_debug_enabled THEN
3502: l_proc := l_package||'chk_for_enc_liq_summ_lines.c_enc_summary_lines_arch';
3503: hr_utility.trace('Leaving:'|| l_proc);
3504: END IF;
3505: RETURN l_return_code;
3506: EXCEPTION
3507: WHEN OTHERS THEN

Line 3508: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3504: END IF;
3505: RETURN l_return_code;
3506: EXCEPTION
3507: WHEN OTHERS THEN
3508: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3509: hr_utility.TRACE ('chk_for_enc_liq_summ_lines => sqlerrm is ' || SQLERRM);
3510: hr_utility.TRACE ('chk_for_enc_liq_summ_lines => sqlcode is ' || SQLCODE);
3511: RAISE;
3512: END chk_for_enc_liq_summ_lines;

Line 3509: hr_utility.TRACE ('chk_for_enc_liq_summ_lines => sqlerrm is ' || SQLERRM);

3505: RETURN l_return_code;
3506: EXCEPTION
3507: WHEN OTHERS THEN
3508: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3509: hr_utility.TRACE ('chk_for_enc_liq_summ_lines => sqlerrm is ' || SQLERRM);
3510: hr_utility.TRACE ('chk_for_enc_liq_summ_lines => sqlcode is ' || SQLCODE);
3511: RAISE;
3512: END chk_for_enc_liq_summ_lines;
3513:

Line 3510: hr_utility.TRACE ('chk_for_enc_liq_summ_lines => sqlcode is ' || SQLCODE);

3506: EXCEPTION
3507: WHEN OTHERS THEN
3508: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3509: hr_utility.TRACE ('chk_for_enc_liq_summ_lines => sqlerrm is ' || SQLERRM);
3510: hr_utility.TRACE ('chk_for_enc_liq_summ_lines => sqlcode is ' || SQLCODE);
3511: RAISE;
3512: END chk_for_enc_liq_summ_lines;
3513:
3514: FUNCTION chk_dist_adj_pregen_summ_lines

Line 3536: hr_utility.trace('Entering:'|| l_proc);

3532: BEGIN
3533:
3534: IF l_debug_enabled THEN
3535: l_proc := l_package||'chk_dist_adj_pregen_summ_lines.c_summary_lines';
3536: hr_utility.trace('Entering:'|| l_proc);
3537: END IF;
3538:
3539: OPEN c_summary_lines;
3540: FETCH c_summary_lines INTO l_record_count;

Line 3551: hr_utility.trace('Leaving:'|| l_proc);

3547: END IF;
3548:
3549: IF l_debug_enabled THEN
3550: l_proc := l_package||'chk_dist_adj_pregen_summ_lines.c_summary_lines';
3551: hr_utility.trace('Leaving:'|| l_proc);
3552: END IF;
3553:
3554: IF l_debug_enabled THEN
3555: l_proc := l_package||'chk_dist_adj_pregen_summ_lines.c_summary_lines_arch';

Line 3556: hr_utility.trace('Entering:'|| l_proc);

3552: END IF;
3553:
3554: IF l_debug_enabled THEN
3555: l_proc := l_package||'chk_dist_adj_pregen_summ_lines.c_summary_lines_arch';
3556: hr_utility.trace('Entering:'|| l_proc);
3557: END IF;
3558:
3559: OPEN c_summary_lines_arch;
3560: FETCH c_summary_lines_arch INTO l_record_count;

Line 3571: hr_utility.trace('Leaving:'|| l_proc);

3567: END IF;
3568:
3569: IF l_debug_enabled THEN
3570: l_proc := l_package||'chk_dist_adj_pregen_summ_lines.c_summary_lines_arch';
3571: hr_utility.trace('Leaving:'|| l_proc);
3572: END IF;
3573: RETURN l_return_code;
3574: EXCEPTION
3575: WHEN OTHERS THEN

Line 3576: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3572: END IF;
3573: RETURN l_return_code;
3574: EXCEPTION
3575: WHEN OTHERS THEN
3576: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3577: hr_utility.TRACE ('chk_dist_adj_pregen_summ_lines => sqlerrm is ' || SQLERRM);
3578: hr_utility.TRACE ('chk_dist_adj_pregen_summ_lines => sqlcode is ' || SQLCODE);
3579: RAISE;
3580: END chk_dist_adj_pregen_summ_lines;

Line 3577: hr_utility.TRACE ('chk_dist_adj_pregen_summ_lines => sqlerrm is ' || SQLERRM);

3573: RETURN l_return_code;
3574: EXCEPTION
3575: WHEN OTHERS THEN
3576: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3577: hr_utility.TRACE ('chk_dist_adj_pregen_summ_lines => sqlerrm is ' || SQLERRM);
3578: hr_utility.TRACE ('chk_dist_adj_pregen_summ_lines => sqlcode is ' || SQLCODE);
3579: RAISE;
3580: END chk_dist_adj_pregen_summ_lines;
3581:

Line 3578: hr_utility.TRACE ('chk_dist_adj_pregen_summ_lines => sqlcode is ' || SQLCODE);

3574: EXCEPTION
3575: WHEN OTHERS THEN
3576: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3577: hr_utility.TRACE ('chk_dist_adj_pregen_summ_lines => sqlerrm is ' || SQLERRM);
3578: hr_utility.TRACE ('chk_dist_adj_pregen_summ_lines => sqlcode is ' || SQLCODE);
3579: RAISE;
3580: END chk_dist_adj_pregen_summ_lines;
3581:
3582: FUNCTION chk_in_psp_pre_gen_dist_lines

Line 3622: hr_utility.trace('Entering:'|| l_proc);

3618: BEGIN
3619:
3620: IF l_debug_enabled THEN
3621: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines';
3622: hr_utility.trace('Entering:'|| l_proc);
3623: END IF;
3624:
3625: OPEN c_pre_gen_dist_lines;
3626: FETCH c_pre_gen_dist_lines INTO l_record_count;

Line 3637: hr_utility.trace('Leaving:'|| l_proc);

3633: END IF;
3634:
3635: IF l_debug_enabled THEN
3636: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines';
3637: hr_utility.trace('Leaving:'|| l_proc);
3638: END IF;
3639:
3640: IF l_debug_enabled THEN
3641: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines_hist';

Line 3642: hr_utility.trace('Entering:'|| l_proc);

3638: END IF;
3639:
3640: IF l_debug_enabled THEN
3641: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines_hist';
3642: hr_utility.trace('Entering:'|| l_proc);
3643: END IF;
3644:
3645: OPEN c_pre_gen_dist_lines_hist;
3646: FETCH c_pre_gen_dist_lines_hist INTO l_record_count;

Line 3657: hr_utility.trace('Leaving:'|| l_proc);

3653: END IF;
3654:
3655: IF l_debug_enabled THEN
3656: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_pre_gen_dist_lines_hist';
3657: hr_utility.trace('Leaving:'|| l_proc);
3658: END IF;
3659:
3660: IF l_debug_enabled THEN
3661: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_interface';

Line 3662: hr_utility.trace('Entering:'|| l_proc);

3658: END IF;
3659:
3660: IF l_debug_enabled THEN
3661: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_interface';
3662: hr_utility.trace('Entering:'|| l_proc);
3663: END IF;
3664:
3665: OPEN c_distribution_interface;
3666: FETCH c_distribution_interface INTO l_record_count;

Line 3677: hr_utility.trace('Leaving:'|| l_proc);

3673: END IF;
3674:
3675: IF l_debug_enabled THEN
3676: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_interface';
3677: hr_utility.trace('Leaving:'|| l_proc);
3678: END IF;
3679:
3680: IF l_debug_enabled THEN
3681: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_int_arch';

Line 3682: hr_utility.trace('Entering:'|| l_proc);

3678: END IF;
3679:
3680: IF l_debug_enabled THEN
3681: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_int_arch';
3682: hr_utility.trace('Entering:'|| l_proc);
3683: END IF;
3684:
3685: OPEN c_distribution_int_arch;
3686: FETCH c_distribution_int_arch INTO l_record_count;

Line 3697: hr_utility.trace('Leaving:'|| l_proc);

3693: END IF;
3694:
3695: IF l_debug_enabled THEN
3696: l_proc := l_package||'chk_in_psp_pre_gen_dist_lines.c_distribution_int_arch';
3697: hr_utility.trace('Leaving:'|| l_proc);
3698: END IF;
3699: RETURN l_return_code;
3700:
3701: EXCEPTION

Line 3703: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3699: RETURN l_return_code;
3700:
3701: EXCEPTION
3702: WHEN OTHERS THEN
3703: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3704: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlerrm is ' || SQLERRM);
3705: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlcode is ' || SQLCODE);
3706: RAISE;
3707: END chk_in_psp_pre_gen_dist_lines;

Line 3704: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlerrm is ' || SQLERRM);

3700:
3701: EXCEPTION
3702: WHEN OTHERS THEN
3703: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3704: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlerrm is ' || SQLERRM);
3705: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlcode is ' || SQLCODE);
3706: RAISE;
3707: END chk_in_psp_pre_gen_dist_lines;
3708:

Line 3705: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlcode is ' || SQLCODE);

3701: EXCEPTION
3702: WHEN OTHERS THEN
3703: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3704: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlerrm is ' || SQLERRM);
3705: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlcode is ' || SQLCODE);
3706: RAISE;
3707: END chk_in_psp_pre_gen_dist_lines;
3708:
3709: FUNCTION chk_in_psp_adjustment_lines

Line 3730: hr_utility.trace('Entering:'|| l_proc);

3726: BEGIN
3727:
3728: IF l_debug_enabled THEN
3729: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines';
3730: hr_utility.trace('Entering:'|| l_proc);
3731: END IF;
3732:
3733: OPEN c_psp_adjustment_lines;
3734: FETCH c_psp_adjustment_lines INTO l_record_count;

Line 3745: hr_utility.trace('Leaving:'|| l_proc);

3741: END IF;
3742:
3743: IF l_debug_enabled THEN
3744: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines';
3745: hr_utility.trace('Leaving:'|| l_proc);
3746: END IF;
3747:
3748: IF l_debug_enabled THEN
3749: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines_history';

Line 3750: hr_utility.trace('Entering:'|| l_proc);

3746: END IF;
3747:
3748: IF l_debug_enabled THEN
3749: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines_history';
3750: hr_utility.trace('Entering:'|| l_proc);
3751: END IF;
3752:
3753: OPEN c_psp_adjustment_lines_history;
3754: FETCH c_psp_adjustment_lines_history INTO l_record_count;

Line 3765: hr_utility.trace('Leaving:'|| l_proc);

3761: END IF;
3762:
3763: IF l_debug_enabled THEN
3764: l_proc := l_package||'chk_in_psp_adjustment_lines.c_psp_adjustment_lines_history';
3765: hr_utility.trace('Leaving:'|| l_proc);
3766: END IF;
3767: RETURN l_return_code;
3768: EXCEPTION
3769: WHEN OTHERS THEN

Line 3770: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3766: END IF;
3767: RETURN l_return_code;
3768: EXCEPTION
3769: WHEN OTHERS THEN
3770: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3771: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlerrm is ' || SQLERRM);
3772: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlcode is ' || SQLCODE);
3773: RAISE;
3774: END chk_in_psp_adjustment_lines;

Line 3771: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlerrm is ' || SQLERRM);

3767: RETURN l_return_code;
3768: EXCEPTION
3769: WHEN OTHERS THEN
3770: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3771: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlerrm is ' || SQLERRM);
3772: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlcode is ' || SQLCODE);
3773: RAISE;
3774: END chk_in_psp_adjustment_lines;
3775:

Line 3772: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlcode is ' || SQLCODE);

3768: EXCEPTION
3769: WHEN OTHERS THEN
3770: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3771: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlerrm is ' || SQLERRM);
3772: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlcode is ' || SQLCODE);
3773: RAISE;
3774: END chk_in_psp_adjustment_lines;
3775:
3776: FUNCTION chk_poeta_in_element_entries

Line 3793: hr_utility.trace('Entering:'|| l_proc);

3789: BEGIN
3790:
3791: IF l_debug_enabled THEN
3792: l_proc := l_package||'chk_poeta_in_element_entries';
3793: hr_utility.trace('Entering:'|| l_proc);
3794: END IF;
3795:
3796: OPEN c_poeta_setup_element_entries;
3797: FETCH c_poeta_setup_element_entries INTO l_record_count;

Line 3808: hr_utility.trace('Leaving:'|| l_proc);

3804: END IF;
3805:
3806: IF l_debug_enabled THEN
3807: l_proc := l_package||'chk_poeta_in_element_entries';
3808: hr_utility.trace('Leaving:'|| l_proc);
3809: END IF;
3810: RETURN l_return_code;
3811: EXCEPTION
3812: WHEN OTHERS THEN

Line 3813: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3809: END IF;
3810: RETURN l_return_code;
3811: EXCEPTION
3812: WHEN OTHERS THEN
3813: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3814: hr_utility.TRACE ('chk_poeta_in_element_entries => sqlerrm is ' || SQLERRM);
3815: hr_utility.TRACE ('chk_poeta_in_element_entries => sqlcode is ' || SQLCODE);
3816: RAISE;
3817: END chk_poeta_in_element_entries;

Line 3814: hr_utility.TRACE ('chk_poeta_in_element_entries => sqlerrm is ' || SQLERRM);

3810: RETURN l_return_code;
3811: EXCEPTION
3812: WHEN OTHERS THEN
3813: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3814: hr_utility.TRACE ('chk_poeta_in_element_entries => sqlerrm is ' || SQLERRM);
3815: hr_utility.TRACE ('chk_poeta_in_element_entries => sqlcode is ' || SQLCODE);
3816: RAISE;
3817: END chk_poeta_in_element_entries;
3818:

Line 3815: hr_utility.TRACE ('chk_poeta_in_element_entries => sqlcode is ' || SQLCODE);

3811: EXCEPTION
3812: WHEN OTHERS THEN
3813: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3814: hr_utility.TRACE ('chk_poeta_in_element_entries => sqlerrm is ' || SQLERRM);
3815: hr_utility.TRACE ('chk_poeta_in_element_entries => sqlcode is ' || SQLCODE);
3816: RAISE;
3817: END chk_poeta_in_element_entries;
3818:
3819: FUNCTION chk_imported_poeta_trans

Line 3833: hr_utility.trace('Entering:'|| l_proc);

3829: BEGIN
3830:
3831: IF l_debug_enabled THEN
3832: l_proc := l_package||'chk_imported_poeta_trans';
3833: hr_utility.trace('Entering:'|| l_proc);
3834: END IF;
3835:
3836: OPEN c_imported_poeta_trans;
3837: FETCH c_imported_poeta_trans INTO l_record_count;

Line 3848: hr_utility.trace('Leaving:'|| l_proc);

3844: END IF;
3845:
3846: IF l_debug_enabled THEN
3847: l_proc := l_package||'chk_imported_poeta_trans';
3848: hr_utility.trace('Leaving:'|| l_proc);
3849: END IF;
3850: RETURN l_return_code;
3851: EXCEPTION
3852: WHEN OTHERS THEN

Line 3853: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3849: END IF;
3850: RETURN l_return_code;
3851: EXCEPTION
3852: WHEN OTHERS THEN
3853: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3854: hr_utility.TRACE ('chk_imported_poeta_trans => sqlerrm is ' || SQLERRM);
3855: hr_utility.TRACE ('chk_imported_poeta_trans => sqlcode is ' || SQLCODE);
3856: RAISE;
3857: END chk_imported_poeta_trans;

Line 3854: hr_utility.TRACE ('chk_imported_poeta_trans => sqlerrm is ' || SQLERRM);

3850: RETURN l_return_code;
3851: EXCEPTION
3852: WHEN OTHERS THEN
3853: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3854: hr_utility.TRACE ('chk_imported_poeta_trans => sqlerrm is ' || SQLERRM);
3855: hr_utility.TRACE ('chk_imported_poeta_trans => sqlcode is ' || SQLCODE);
3856: RAISE;
3857: END chk_imported_poeta_trans;
3858:

Line 3855: hr_utility.TRACE ('chk_imported_poeta_trans => sqlcode is ' || SQLCODE);

3851: EXCEPTION
3852: WHEN OTHERS THEN
3853: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3854: hr_utility.TRACE ('chk_imported_poeta_trans => sqlerrm is ' || SQLERRM);
3855: hr_utility.TRACE ('chk_imported_poeta_trans => sqlcode is ' || SQLCODE);
3856: RAISE;
3857: END chk_imported_poeta_trans;
3858:
3859: BEGIN /*============ Main Procedure "chk_pa_trans_exists_in_ld" begins==================== */

Line 3861: l_debug_enabled := hr_utility.Debug_enabled();

3857: END chk_imported_poeta_trans;
3858:
3859: BEGIN /*============ Main Procedure "chk_pa_trans_exists_in_ld" begins==================== */
3860:
3861: l_debug_enabled := hr_utility.Debug_enabled();
3862:
3863: IF l_debug_enabled THEN
3864: l_proc := l_package||'chk_pa_trans_exists_in_ld';
3865: hr_utility.trace('Entering:'|| l_proc);

Line 3865: hr_utility.trace('Entering:'|| l_proc);

3861: l_debug_enabled := hr_utility.Debug_enabled();
3862:
3863: IF l_debug_enabled THEN
3864: l_proc := l_package||'chk_pa_trans_exists_in_ld';
3865: hr_utility.trace('Entering:'|| l_proc);
3866: END IF;
3867:
3868: l_return_flag := chk_param_valid; -- Validation of Input Parameters
3869: IF l_return_flag <> 0 THEN

Line 3955: hr_utility.trace('Leaving:'|| l_proc);

3951: END IF;
3952:
3953: IF l_debug_enabled THEN
3954: l_proc := l_package||'chk_pa_trans_exists_in_ld';
3955: hr_utility.trace('Leaving:'|| l_proc);
3956: END IF;
3957:
3958: l_return_flag := 0;
3959: RETURN l_return_flag;

Line 3963: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3959: RETURN l_return_flag;
3960:
3961: EXCEPTION
3962: WHEN OTHERS THEN
3963: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3964: hr_utility.TRACE ('chk_pa_trans_exists_in_ld => sqlerrm is ' || SQLERRM);
3965: hr_utility.TRACE ('chk_pa_trans_exists_in_ld => sqlcode is ' || SQLCODE);
3966: RAISE;
3967: END chk_pa_trans_exists_in_ld;

Line 3964: hr_utility.TRACE ('chk_pa_trans_exists_in_ld => sqlerrm is ' || SQLERRM);

3960:
3961: EXCEPTION
3962: WHEN OTHERS THEN
3963: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3964: hr_utility.TRACE ('chk_pa_trans_exists_in_ld => sqlerrm is ' || SQLERRM);
3965: hr_utility.TRACE ('chk_pa_trans_exists_in_ld => sqlcode is ' || SQLCODE);
3966: RAISE;
3967: END chk_pa_trans_exists_in_ld;
3968:

Line 3965: hr_utility.TRACE ('chk_pa_trans_exists_in_ld => sqlcode is ' || SQLCODE);

3961: EXCEPTION
3962: WHEN OTHERS THEN
3963: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3964: hr_utility.TRACE ('chk_pa_trans_exists_in_ld => sqlerrm is ' || SQLERRM);
3965: hr_utility.TRACE ('chk_pa_trans_exists_in_ld => sqlcode is ' || SQLCODE);
3966: RAISE;
3967: END chk_pa_trans_exists_in_ld;
3968:
3969: END psp_general;