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

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: package body hxc_time_category_hook as
2: /* $Header: hxchtchk.pkb 120.5 2006/03/24 16:27:16 jdupont noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: procedure maintain_pto_time_category (
7: p_accrual_plan_id NUMBER default null
8: , p_net_calculation_rule_id NUMBER default null

Line 122: hr_utility.trace(' Params *');

118: hr_general2.init_fndload (p_resp_appl_id => 809 );
119:
120: if g_debug then
121: l_proc := g_package||'maintain_pto_time_category';
122: hr_utility.trace('********** Params ***********');
123: hr_utility.trace('p_accrual_plan_id is :'||to_char(p_accrual_plan_id));
124: hr_utility.trace('p_net_calc_rule_id is :'||to_char(p_net_calculation_rule_id));
125: end if;
126:

Line 123: hr_utility.trace('p_accrual_plan_id is :'||to_char(p_accrual_plan_id));

119:
120: if g_debug then
121: l_proc := g_package||'maintain_pto_time_category';
122: hr_utility.trace('********** Params ***********');
123: hr_utility.trace('p_accrual_plan_id is :'||to_char(p_accrual_plan_id));
124: hr_utility.trace('p_net_calc_rule_id is :'||to_char(p_net_calculation_rule_id));
125: end if;
126:
127: IF ( p_delete )

Line 124: hr_utility.trace('p_net_calc_rule_id is :'||to_char(p_net_calculation_rule_id));

120: if g_debug then
121: l_proc := g_package||'maintain_pto_time_category';
122: hr_utility.trace('********** Params ***********');
123: hr_utility.trace('p_accrual_plan_id is :'||to_char(p_accrual_plan_id));
124: hr_utility.trace('p_net_calc_rule_id is :'||to_char(p_net_calculation_rule_id));
125: end if;
126:
127: IF ( p_delete )
128: THEN

Line 130: hr_utility.trace('Delete is TRUE');

126:
127: IF ( p_delete )
128: THEN
129: if g_debug then
130: hr_utility.trace('Delete is TRUE');
131: end if;
132: ELSE
133: if g_debug then
134: hr_utility.trace('Delete is FALSE');

Line 134: hr_utility.trace('Delete is FALSE');

130: hr_utility.trace('Delete is TRUE');
131: end if;
132: ELSE
133: if g_debug then
134: hr_utility.trace('Delete is FALSE');
135: end if;
136: END IF;
137:
138: if g_debug then

Line 139: hr_utility.trace(' ENd Params ');

135: end if;
136: END IF;
137:
138: if g_debug then
139: hr_utility.trace('******** ENd Params ********');
140: end if;
141:
142: if g_debug then
143: hr_utility.set_location('Entering '||l_proc, 10);

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

139: hr_utility.trace('******** ENd Params ********');
140: end if;
141:
142: if g_debug then
143: hr_utility.set_location('Entering '||l_proc, 10);
144: end if;
145:
146: IF ( p_accrual_plan_id IS NULL )
147: THEN

Line 164: hr_utility.trace('l pap id is '||to_char(l_pap_id));

160: FETCH csr_get_accrual_plan_name INTO l_accrual_plan_name;
161: CLOSE csr_get_accrual_plan_name;
162:
163: if g_debug then
164: hr_utility.trace('l pap id is '||to_char(l_pap_id));
165: end if;
166:
167:
168: -- get the Dummy Element Context mapping component id

Line 175: hr_utility.set_location('Processing '||l_proc, 10);

171: FETCH csr_get_mpc_id INTO l_mpc_id;
172: CLOSE csr_get_mpc_id;
173:
174: if g_debug then
175: hr_utility.set_location('Processing '||l_proc, 10);
176: end if;
177:
178: -- set the Time Category name
179:

Line 192: hr_utility.trace('DEC TC NAME is '||l_dec_tc_name);

188: l_dec_tc_id := l_tc_info.time_category_id;
189: l_dec_tc_ovn := l_tc_info.object_version_number;
190:
191: if g_debug then
192: hr_utility.trace('DEC TC NAME is '||l_dec_tc_name);
193: hr_utility.trace('DEC TC ID is '||to_char(l_dec_tc_id));
194: hr_utility.trace('DEC TC OVN is '||to_char(l_dec_tc_ovn));
195: end if;
196:

Line 193: hr_utility.trace('DEC TC ID is '||to_char(l_dec_tc_id));

189: l_dec_tc_ovn := l_tc_info.object_version_number;
190:
191: if g_debug then
192: hr_utility.trace('DEC TC NAME is '||l_dec_tc_name);
193: hr_utility.trace('DEC TC ID is '||to_char(l_dec_tc_id));
194: hr_utility.trace('DEC TC OVN is '||to_char(l_dec_tc_ovn));
195: end if;
196:
197: END IF;

Line 194: hr_utility.trace('DEC TC OVN is '||to_char(l_dec_tc_ovn));

190:
191: if g_debug then
192: hr_utility.trace('DEC TC NAME is '||l_dec_tc_name);
193: hr_utility.trace('DEC TC ID is '||to_char(l_dec_tc_id));
194: hr_utility.trace('DEC TC OVN is '||to_char(l_dec_tc_ovn));
195: end if;
196:
197: END IF;
198:

Line 216: hr_utility.trace('INC TC NAME is '||l_inc_tc_name);

212: l_inc_tc_id := l_tc_info.time_category_id;
213: l_inc_tc_ovn := l_tc_info.object_version_number;
214:
215: if g_debug then
216: hr_utility.trace('INC TC NAME is '||l_inc_tc_name);
217: hr_utility.trace('INC TC ID is '||to_char(l_inc_tc_id));
218: hr_utility.trace('INC TC OVN is '||to_char(l_inc_tc_ovn));
219: end if;
220:

Line 217: hr_utility.trace('INC TC ID is '||to_char(l_inc_tc_id));

213: l_inc_tc_ovn := l_tc_info.object_version_number;
214:
215: if g_debug then
216: hr_utility.trace('INC TC NAME is '||l_inc_tc_name);
217: hr_utility.trace('INC TC ID is '||to_char(l_inc_tc_id));
218: hr_utility.trace('INC TC OVN is '||to_char(l_inc_tc_ovn));
219: end if;
220:
221: END IF;

Line 218: hr_utility.trace('INC TC OVN is '||to_char(l_inc_tc_ovn));

214:
215: if g_debug then
216: hr_utility.trace('INC TC NAME is '||l_inc_tc_name);
217: hr_utility.trace('INC TC ID is '||to_char(l_inc_tc_id));
218: hr_utility.trace('INC TC OVN is '||to_char(l_inc_tc_ovn));
219: end if;
220:
221: END IF;
222:

Line 226: hr_utility.set_location('Processing '||l_proc, 20);

222:
223: CLOSE csr_get_time_category_info;
224:
225: if g_debug then
226: hr_utility.set_location('Processing '||l_proc, 20);
227: end if;
228:
229:
230: OPEN csr_get_elements ( l_pap_id, p_net_calculation_rule_id );

Line 234: hr_utility.set_location('Processing '||l_proc, 30);

230: OPEN csr_get_elements ( l_pap_id, p_net_calculation_rule_id );
231: FETCH csr_get_elements INTO l_accrual_info;
232:
233: if g_debug then
234: hr_utility.set_location('Processing '||l_proc, 30);
235: end if;
236:
237: -- create the new time category name
238:

Line 248: hr_utility.set_location('Processing '||l_proc, 40);

244:
245: -- create time categories
246:
247: if g_debug then
248: hr_utility.set_location('Processing '||l_proc, 40);
249: end if;
250:
251: -- we always create the DEC since there is always one DEC NCR
252: -- which can never be deleted

Line 257: hr_utility.trace('creating DEC TC');

253:
254: l_dec_tc_name := SUBSTR('OTL_DEC_'||l_accrual_info.accrual_plan_name,1,90);
255:
256: if g_debug then
257: hr_utility.trace('creating DEC TC');
258: hr_utility.trace('DEC TC NAME is '||l_dec_tc_name);
259: end if;
260:
261: hxc_time_category_api.create_time_category (

Line 258: hr_utility.trace('DEC TC NAME is '||l_dec_tc_name);

254: l_dec_tc_name := SUBSTR('OTL_DEC_'||l_accrual_info.accrual_plan_name,1,90);
255:
256: if g_debug then
257: hr_utility.trace('creating DEC TC');
258: hr_utility.trace('DEC TC NAME is '||l_dec_tc_name);
259: end if;
260:
261: hxc_time_category_api.create_time_category (
262: p_time_category_id => l_dec_tc_id

Line 270: hr_utility.trace('DEC TC ID is '||to_char(l_dec_tc_id));

266: ,p_display => 'Y'
267: ,p_description => 'System Generated Decrementing PTO Time Category' );
268:
269: if g_debug then
270: hr_utility.trace('DEC TC ID is '||to_char(l_dec_tc_id));
271: hr_utility.trace('DEC TC OVN is '||to_char(l_dec_tc_ovn));
272: end if;
273:
274: -- CREATE time category comp

Line 271: hr_utility.trace('DEC TC OVN is '||to_char(l_dec_tc_ovn));

267: ,p_description => 'System Generated Decrementing PTO Time Category' );
268:
269: if g_debug then
270: hr_utility.trace('DEC TC ID is '||to_char(l_dec_tc_id));
271: hr_utility.trace('DEC TC OVN is '||to_char(l_dec_tc_ovn));
272: end if;
273:
274: -- CREATE time category comp
275:

Line 277: hr_utility.set_location('Processing '||l_proc, 50);

273:
274: -- CREATE time category comp
275:
276: if g_debug then
277: hr_utility.set_location('Processing '||l_proc, 50);
278:
279: hr_utility.trace('Creating DEC time component');
280: end if;
281:

Line 279: hr_utility.trace('Creating DEC time component');

275:
276: if g_debug then
277: hr_utility.set_location('Processing '||l_proc, 50);
278:
279: hr_utility.trace('Creating DEC time component');
280: end if;
281:
282: hxc_time_category_comp_api.create_time_category_comp (
283: p_time_category_comp_id => l_tcc_id

Line 298: hr_utility.trace('Creating INC time component');

294: ELSIF ( ( l_inc_tc_name IS NULL ) AND ( NOT p_delete ) AND ( l_accrual_info.add_or_subtract = 1 ) )
295: THEN
296:
297: if g_debug then
298: hr_utility.trace('Creating INC time component');
299:
300: hr_utility.trace('INC TC ID is null');
301: end if;
302:

Line 300: hr_utility.trace('INC TC ID is null');

296:
297: if g_debug then
298: hr_utility.trace('Creating INC time component');
299:
300: hr_utility.trace('INC TC ID is null');
301: end if;
302:
303: -- check to see this isn't the first INC NCR
304:

Line 310: hr_utility.trace('MIN inc ncr is '||to_char(l_min_inc_ncr_id));

306: FETCH csr_get_min_inc_ncr INTO l_min_inc_ncr_id;
307: CLOSE csr_get_min_inc_ncr;
308:
309: if g_debug then
310: hr_utility.trace('MIN inc ncr is '||to_char(l_min_inc_ncr_id));
311: end if;
312:
313: IF ( p_net_calculation_rule_id > l_min_inc_ncr_id )
314: THEN

Line 319: hr_utility.trace('Creating INC TC');

315:
316: l_inc_tc_name := SUBSTR('OTL_INC_'||l_accrual_info.accrual_plan_name,1,90);
317:
318: if g_debug then
319: hr_utility.trace('Creating INC TC');
320: hr_utility.trace('INC TC NAME is '||l_inc_tc_name);
321: end if;
322:
323: hxc_time_category_api.create_time_category (

Line 320: hr_utility.trace('INC TC NAME is '||l_inc_tc_name);

316: l_inc_tc_name := SUBSTR('OTL_INC_'||l_accrual_info.accrual_plan_name,1,90);
317:
318: if g_debug then
319: hr_utility.trace('Creating INC TC');
320: hr_utility.trace('INC TC NAME is '||l_inc_tc_name);
321: end if;
322:
323: hxc_time_category_api.create_time_category (
324: p_time_category_id => l_inc_tc_id

Line 332: hr_utility.trace('INC TC ID is '||to_char(l_inc_tc_id));

328: ,p_display => 'Y'
329: ,p_description => 'System Generated Inccrementing PTO Time Category' );
330:
331: if g_debug then
332: hr_utility.trace('INC TC ID is '||to_char(l_inc_tc_id));
333: hr_utility.trace('INC TC OVN is '||to_char(l_inc_tc_ovn));
334:
335: hr_utility.trace('Creating INC time component');
336: end if;

Line 333: hr_utility.trace('INC TC OVN is '||to_char(l_inc_tc_ovn));

329: ,p_description => 'System Generated Inccrementing PTO Time Category' );
330:
331: if g_debug then
332: hr_utility.trace('INC TC ID is '||to_char(l_inc_tc_id));
333: hr_utility.trace('INC TC OVN is '||to_char(l_inc_tc_ovn));
334:
335: hr_utility.trace('Creating INC time component');
336: end if;
337:

Line 335: hr_utility.trace('Creating INC time component');

331: if g_debug then
332: hr_utility.trace('INC TC ID is '||to_char(l_inc_tc_id));
333: hr_utility.trace('INC TC OVN is '||to_char(l_inc_tc_ovn));
334:
335: hr_utility.trace('Creating INC time component');
336: end if;
337:
338: hxc_time_category_comp_api.create_time_category_comp (
339: p_time_category_comp_id => l_tcc_id

Line 353: hr_utility.set_location('Processing '||l_proc, 60);

349:
350: END IF; -- ( p_net_calculation_rule_id > l_min_inc_ncr_id )
351:
352: if g_debug then
353: hr_utility.set_location('Processing '||l_proc, 60);
354: end if;
355:
356: ELSIF ( ( l_dec_tc_name IS NOT NULL ) AND ( NOT p_delete ) AND ( l_accrual_info.add_or_subtract = -1 ) )
357: THEN

Line 361: hr_utility.set_location('Processing '||l_proc, 70);

357: THEN
358: -- updating existing time category
359:
360: if g_debug then
361: hr_utility.set_location('Processing '||l_proc, 70);
362: end if;
363:
364: -- check to see if this time category comp exists
365:

Line 370: hr_utility.set_location('Processing '||l_proc, 90);

366: OPEN csr_get_tc_comp ( l_dec_tc_id, l_mpc_id, l_accrual_info.element_type_id );
367: FETCH csr_get_tc_comp INTO l_tcc_id, l_tcc_ovn;
368:
369: if g_debug then
370: hr_utility.set_location('Processing '||l_proc, 90);
371: end if;
372:
373: IF ( csr_get_tc_comp%NOTFOUND )
374: THEN

Line 377: hr_utility.set_location('Processing '||l_proc, 130);

373: IF ( csr_get_tc_comp%NOTFOUND )
374: THEN
375:
376: if g_debug then
377: hr_utility.set_location('Processing '||l_proc, 130);
378: end if;
379:
380: hxc_time_category_comp_api.create_time_category_comp (
381: p_time_category_comp_id => l_tcc_id

Line 395: hr_utility.set_location('Processing '||l_proc, 140);

391:
392: ELSE
393:
394: if g_debug then
395: hr_utility.set_location('Processing '||l_proc, 140);
396: end if;
397:
398: hxc_time_category_comp_api.update_time_category_comp (
399: p_time_category_comp_id => l_tcc_id

Line 415: hr_utility.set_location('Processing '||l_proc, 150);

411:
412: CLOSE csr_get_tc_comp;
413:
414: if g_debug then
415: hr_utility.set_location('Processing '||l_proc, 150);
416: end if;
417:
418:
419: ELSIF ( ( l_inc_tc_name IS NOT NULL ) AND ( NOT p_delete ) AND ( l_accrual_info.add_or_subtract = 1 ) )

Line 423: hr_utility.trace('INC TC ID is '||to_char(l_inc_tc_id));

419: ELSIF ( ( l_inc_tc_name IS NOT NULL ) AND ( NOT p_delete ) AND ( l_accrual_info.add_or_subtract = 1 ) )
420: THEN
421:
422: if g_debug then
423: hr_utility.trace('INC TC ID is '||to_char(l_inc_tc_id));
424: hr_utility.trace('INC TC OVN is '||to_char(l_inc_tc_ovn));
425: end if;
426:
427: OPEN csr_get_tc_comp ( l_inc_tc_id, l_mpc_id, l_accrual_info.element_type_id );

Line 424: hr_utility.trace('INC TC OVN is '||to_char(l_inc_tc_ovn));

420: THEN
421:
422: if g_debug then
423: hr_utility.trace('INC TC ID is '||to_char(l_inc_tc_id));
424: hr_utility.trace('INC TC OVN is '||to_char(l_inc_tc_ovn));
425: end if;
426:
427: OPEN csr_get_tc_comp ( l_inc_tc_id, l_mpc_id, l_accrual_info.element_type_id );
428: FETCH csr_get_tc_comp INTO l_tcc_id, l_tcc_ovn;

Line 431: hr_utility.set_location('Processing '||l_proc, 160);

427: OPEN csr_get_tc_comp ( l_inc_tc_id, l_mpc_id, l_accrual_info.element_type_id );
428: FETCH csr_get_tc_comp INTO l_tcc_id, l_tcc_ovn;
429:
430: if g_debug then
431: hr_utility.set_location('Processing '||l_proc, 160);
432: end if;
433:
434: IF ( csr_get_tc_comp%NOTFOUND )
435: THEN

Line 438: hr_utility.set_location('Processing '||l_proc, 170);

434: IF ( csr_get_tc_comp%NOTFOUND )
435: THEN
436:
437: if g_debug then
438: hr_utility.set_location('Processing '||l_proc, 170);
439: end if;
440:
441: hxc_time_category_comp_api.create_time_category_comp (
442: p_time_category_comp_id => l_tcc_id

Line 456: hr_utility.set_location('Processing '||l_proc, 180);

452:
453: ELSE
454:
455: if g_debug then
456: hr_utility.set_location('Processing '||l_proc, 180);
457: end if;
458:
459: hxc_time_category_comp_api.update_time_category_comp (
460: p_time_category_comp_id => l_tcc_id

Line 476: hr_utility.set_location('Processing '||l_proc, 190);

472:
473: CLOSE csr_get_tc_comp;
474:
475: if g_debug then
476: hr_utility.set_location('Processing '||l_proc, 190);
477: end if;
478:
479: ELSE
480:

Line 482: hr_utility.trace('Deleting');

478:
479: ELSE
480:
481: if g_debug then
482: hr_utility.trace('Deleting');
483:
484: hr_utility.set_location('Processing '||l_proc, 210);
485: end if;
486:

Line 484: hr_utility.set_location('Processing '||l_proc, 210);

480:
481: if g_debug then
482: hr_utility.trace('Deleting');
483:
484: hr_utility.set_location('Processing '||l_proc, 210);
485: end if;
486:
487: -- delete an individual time category comp
488:

Line 495: hr_utility.trace('delete dec tcc');

491: IF ( l_accrual_info.add_or_subtract = -1 )
492: THEN
493:
494: if g_debug then
495: hr_utility.trace('delete dec tcc');
496: end if;
497:
498: OPEN csr_get_tc_comp ( l_dec_tc_id, l_mpc_id, l_accrual_info.element_type_id );
499: FETCH csr_get_tc_comp INTO l_tcc_id, l_tcc_ovn;

Line 502: hr_utility.trace('tc id is '||to_char(l_dec_tc_id));

498: OPEN csr_get_tc_comp ( l_dec_tc_id, l_mpc_id, l_accrual_info.element_type_id );
499: FETCH csr_get_tc_comp INTO l_tcc_id, l_tcc_ovn;
500:
501: if g_debug then
502: hr_utility.trace('tc id is '||to_char(l_dec_tc_id));
503: hr_utility.trace('tc name is '||l_dec_tc_name);
504: hr_utility.trace('tc ovn is '||to_char(l_dec_tc_ovn));
505: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
506: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));

Line 503: hr_utility.trace('tc name is '||l_dec_tc_name);

499: FETCH csr_get_tc_comp INTO l_tcc_id, l_tcc_ovn;
500:
501: if g_debug then
502: hr_utility.trace('tc id is '||to_char(l_dec_tc_id));
503: hr_utility.trace('tc name is '||l_dec_tc_name);
504: hr_utility.trace('tc ovn is '||to_char(l_dec_tc_ovn));
505: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
506: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));
507: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));

Line 504: hr_utility.trace('tc ovn is '||to_char(l_dec_tc_ovn));

500:
501: if g_debug then
502: hr_utility.trace('tc id is '||to_char(l_dec_tc_id));
503: hr_utility.trace('tc name is '||l_dec_tc_name);
504: hr_utility.trace('tc ovn is '||to_char(l_dec_tc_ovn));
505: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
506: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));
507: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));
508: end if;

Line 505: hr_utility.trace('tcc id is '||to_char(l_tcc_id));

501: if g_debug then
502: hr_utility.trace('tc id is '||to_char(l_dec_tc_id));
503: hr_utility.trace('tc name is '||l_dec_tc_name);
504: hr_utility.trace('tc ovn is '||to_char(l_dec_tc_ovn));
505: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
506: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));
507: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));
508: end if;
509: IF csr_get_tc_comp%FOUND THEN

Line 506: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));

502: hr_utility.trace('tc id is '||to_char(l_dec_tc_id));
503: hr_utility.trace('tc name is '||l_dec_tc_name);
504: hr_utility.trace('tc ovn is '||to_char(l_dec_tc_ovn));
505: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
506: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));
507: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));
508: end if;
509: IF csr_get_tc_comp%FOUND THEN
510: hxc_time_category_comp_api.delete_time_category_comp(

Line 507: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));

503: hr_utility.trace('tc name is '||l_dec_tc_name);
504: hr_utility.trace('tc ovn is '||to_char(l_dec_tc_ovn));
505: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
506: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));
507: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));
508: end if;
509: IF csr_get_tc_comp%FOUND THEN
510: hxc_time_category_comp_api.delete_time_category_comp(
511: p_time_category_comp_id => l_tcc_id

Line 515: hr_utility.set_location('Processing '||l_proc, 220);

511: p_time_category_comp_id => l_tcc_id
512: ,p_object_version_number => l_tcc_ovn );
513: END IF;
514: if g_debug then
515: hr_utility.set_location('Processing '||l_proc, 220);
516: end if;
517:
518: CLOSE csr_get_tc_comp;
519:

Line 529: hr_utility.set_location('Processing '||l_proc, 230);

525:
526: IF ( csr_chk_tc_comps%NOTFOUND )
527: THEN
528: if g_debug then
529: hr_utility.set_location('Processing '||l_proc, 230);
530: end if;
531:
532: -- delete the whole time category
533: IF l_dec_tc_id is not null THEN

Line 554: hr_utility.trace('MIN inc ncr is '||to_char(l_min_inc_ncr_id));

550: FETCH csr_get_min_inc_ncr INTO l_min_inc_ncr_id;
551: CLOSE csr_get_min_inc_ncr;
552:
553: if g_debug then
554: hr_utility.trace('MIN inc ncr is '||to_char(l_min_inc_ncr_id));
555: end if;
556:
557: IF ( p_net_calculation_rule_id > l_min_inc_ncr_id )
558: THEN

Line 561: hr_utility.trace('deleting inc tcc');

557: IF ( p_net_calculation_rule_id > l_min_inc_ncr_id )
558: THEN
559:
560: if g_debug then
561: hr_utility.trace('deleting inc tcc');
562: end if;
563:
564: OPEN csr_get_tc_comp ( l_inc_tc_id, l_mpc_id, l_accrual_info.element_type_id );
565: FETCH csr_get_tc_comp INTO l_tcc_id, l_tcc_ovn;

Line 568: hr_utility.trace('tc id is '||to_char(l_inc_tc_id));

564: OPEN csr_get_tc_comp ( l_inc_tc_id, l_mpc_id, l_accrual_info.element_type_id );
565: FETCH csr_get_tc_comp INTO l_tcc_id, l_tcc_ovn;
566:
567: if g_debug then
568: hr_utility.trace('tc id is '||to_char(l_inc_tc_id));
569: hr_utility.trace('tc name is '||l_inc_tc_name);
570: hr_utility.trace('tc ovn is '||to_char(l_inc_tc_ovn));
571: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
572: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));

Line 569: hr_utility.trace('tc name is '||l_inc_tc_name);

565: FETCH csr_get_tc_comp INTO l_tcc_id, l_tcc_ovn;
566:
567: if g_debug then
568: hr_utility.trace('tc id is '||to_char(l_inc_tc_id));
569: hr_utility.trace('tc name is '||l_inc_tc_name);
570: hr_utility.trace('tc ovn is '||to_char(l_inc_tc_ovn));
571: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
572: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));
573: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));

Line 570: hr_utility.trace('tc ovn is '||to_char(l_inc_tc_ovn));

566:
567: if g_debug then
568: hr_utility.trace('tc id is '||to_char(l_inc_tc_id));
569: hr_utility.trace('tc name is '||l_inc_tc_name);
570: hr_utility.trace('tc ovn is '||to_char(l_inc_tc_ovn));
571: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
572: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));
573: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));
574: end if;

Line 571: hr_utility.trace('tcc id is '||to_char(l_tcc_id));

567: if g_debug then
568: hr_utility.trace('tc id is '||to_char(l_inc_tc_id));
569: hr_utility.trace('tc name is '||l_inc_tc_name);
570: hr_utility.trace('tc ovn is '||to_char(l_inc_tc_ovn));
571: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
572: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));
573: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));
574: end if;
575:

Line 572: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));

568: hr_utility.trace('tc id is '||to_char(l_inc_tc_id));
569: hr_utility.trace('tc name is '||l_inc_tc_name);
570: hr_utility.trace('tc ovn is '||to_char(l_inc_tc_ovn));
571: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
572: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));
573: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));
574: end if;
575:
576: IF csr_get_tc_comp%FOUND THEN

Line 573: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));

569: hr_utility.trace('tc name is '||l_inc_tc_name);
570: hr_utility.trace('tc ovn is '||to_char(l_inc_tc_ovn));
571: hr_utility.trace('tcc id is '||to_char(l_tcc_id));
572: hr_utility.trace('tcc ovn is '||to_char(l_tcc_ovn));
573: hr_utility.trace('element type id is '||to_char(l_accrual_info.element_type_id));
574: end if;
575:
576: IF csr_get_tc_comp%FOUND THEN
577: hxc_time_category_comp_api.delete_time_category_comp(

Line 582: hr_utility.set_location('Processing '||l_proc, 240);

578: p_time_category_comp_id => l_tcc_id
579: ,p_object_version_number => l_tcc_ovn );
580: END IF;
581: if g_debug then
582: hr_utility.set_location('Processing '||l_proc, 240);
583: end if;
584:
585: CLOSE csr_get_tc_comp;
586:

Line 612: hr_utility.set_location('Leaving '||l_proc, 290);

608: CLOSE csr_get_elements;
609:
610:
611: if g_debug then
612: hr_utility.set_location('Leaving '||l_proc, 290);
613: end if;
614:
615: fnd_global.INITIALIZE(
616: session_id => l_session_id,

Line 632: hr_utility.trace('exception');

628:
629: EXCEPTION WHEN OTHERS THEN
630:
631: if g_debug then
632: hr_utility.trace('exception');
633: end if;
634:
635: fnd_global.INITIALIZE(
636: session_id => l_session_id,