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

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY HXT_TIME_PAY AS
2: /* $Header: hxttpay.pkb 120.8 2007/01/12 13:48:48 nissharm ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: -- begin SIR020
5: PROCEDURE get_retro_fields( p_tim_id IN NUMBER
6: ,p_batch_name IN VARCHAR2
7: ,p_batch_ref IN VARCHAR2

Line 79: g_debug :=hr_utility.debug_enabled;

75: AND NVL(det.hours,0) > 0);
76:
77:
78: BEGIN
79: g_debug :=hr_utility.debug_enabled;
80: if g_debug then
81: hr_utility.set_location('hxt_time_pay.get_retro_fields',10);
82: end if;
83:

Line 81: hr_utility.set_location('hxt_time_pay.get_retro_fields',10);

77:
78: BEGIN
79: g_debug :=hr_utility.debug_enabled;
80: if g_debug then
81: hr_utility.set_location('hxt_time_pay.get_retro_fields',10);
82: end if;
83:
84: OPEN retro_pay_trans;
85: FETCH retro_pay_trans INTO p_pay_status, p_retro_batch_id;

Line 87: hr_utility.trace('p_pay_status :'||p_pay_status);

83:
84: OPEN retro_pay_trans;
85: FETCH retro_pay_trans INTO p_pay_status, p_retro_batch_id;
86: if g_debug then
87: hr_utility.trace('p_pay_status :'||p_pay_status);
88: hr_utility.trace('p_retro_batch_id :'||p_retro_batch_id);
89: end if;
90:
91: IF retro_pay_trans%NOTFOUND THEN

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

84: OPEN retro_pay_trans;
85: FETCH retro_pay_trans INTO p_pay_status, p_retro_batch_id;
86: if g_debug then
87: hr_utility.trace('p_pay_status :'||p_pay_status);
88: hr_utility.trace('p_retro_batch_id :'||p_retro_batch_id);
89: end if;
90:
91: IF retro_pay_trans%NOTFOUND THEN
92: if g_debug then

Line 93: hr_utility.set_location('hxt_time_pay.get_retro_fields',20);

89: end if;
90:
91: IF retro_pay_trans%NOTFOUND THEN
92: if g_debug then
93: hr_utility.set_location('hxt_time_pay.get_retro_fields',20);
94: end if;
95: OPEN complete_pay_trans;
96: FETCH complete_pay_trans INTO p_pay_status;
97: if g_debug then

Line 98: hr_utility.trace('p_pay_status :'||p_pay_status);

94: end if;
95: OPEN complete_pay_trans;
96: FETCH complete_pay_trans INTO p_pay_status;
97: if g_debug then
98: hr_utility.trace('p_pay_status :'||p_pay_status);
99: end if;
100:
101: IF complete_pay_trans%NOTFOUND THEN
102: if g_debug then

Line 103: hr_utility.set_location('hxt_time_pay.get_retro_fields',30);

99: end if;
100:
101: IF complete_pay_trans%NOTFOUND THEN
102: if g_debug then
103: hr_utility.set_location('hxt_time_pay.get_retro_fields',30);
104: end if;
105: p_pay_status := 'P';
106: p_retro_batch_id := NULL;
107: ELSE

Line 109: hr_utility.set_location('hxt_time_pay.get_retro_fields',40);

105: p_pay_status := 'P';
106: p_retro_batch_id := NULL;
107: ELSE
108: if g_debug then
109: hr_utility.set_location('hxt_time_pay.get_retro_fields',40);
110: end if;
111: p_retro_batch_id := hxt_UTIL.Get_Retro_Batch_Id(p_tim_id
112: ,p_batch_name
113: ,p_batch_ref);

Line 115: hr_utility.trace('p_retro_batch_id :'||p_retro_batch_id);

111: p_retro_batch_id := hxt_UTIL.Get_Retro_Batch_Id(p_tim_id
112: ,p_batch_name
113: ,p_batch_ref);
114: if g_debug then
115: hr_utility.trace('p_retro_batch_id :'||p_retro_batch_id);
116: end if;
117: END IF;
118: if g_debug then
119: hr_utility.set_location('hxt_time_pay.get_retro_fields',50);

Line 119: hr_utility.set_location('hxt_time_pay.get_retro_fields',50);

115: hr_utility.trace('p_retro_batch_id :'||p_retro_batch_id);
116: end if;
117: END IF;
118: if g_debug then
119: hr_utility.set_location('hxt_time_pay.get_retro_fields',50);
120: end if;
121: CLOSE complete_pay_trans;
122: END IF;
123: if g_debug then

Line 124: hr_utility.set_location('hxt_time_pay.get_retro_fields',60);

120: end if;
121: CLOSE complete_pay_trans;
122: END IF;
123: if g_debug then
124: hr_utility.set_location('hxt_time_pay.get_retro_fields',60);
125: end if;
126: CLOSE retro_pay_trans;
127:
128: OPEN retro_pa_trans;

Line 131: hr_utility.trace('p_pa_status :'||p_pa_status);

127:
128: OPEN retro_pa_trans;
129: FETCH retro_pa_trans INTO p_pa_status;
130: if g_debug then
131: hr_utility.trace('p_pa_status :'||p_pa_status);
132: end if;
133:
134: IF retro_pa_trans%NOTFOUND THEN
135: if g_debug then

Line 136: hr_utility.set_location('hxt_time_pay.get_retro_fields',70);

132: end if;
133:
134: IF retro_pa_trans%NOTFOUND THEN
135: if g_debug then
136: hr_utility.set_location('hxt_time_pay.get_retro_fields',70);
137: end if;
138: OPEN complete_pa_trans;
139: FETCH complete_pa_trans INTO p_pa_status;
140: if g_debug then

Line 141: hr_utility.trace('p_pa_status :'||p_pa_status);

137: end if;
138: OPEN complete_pa_trans;
139: FETCH complete_pa_trans INTO p_pa_status;
140: if g_debug then
141: hr_utility.trace('p_pa_status :'||p_pa_status);
142: end if;
143:
144: IF complete_pa_trans%NOTFOUND THEN
145: if g_debug then

Line 146: hr_utility.set_location('hxt_time_pay.get_retro_fields',80);

142: end if;
143:
144: IF complete_pa_trans%NOTFOUND THEN
145: if g_debug then
146: hr_utility.set_location('hxt_time_pay.get_retro_fields',80);
147: end if;
148: p_pa_status := 'P';
149: END IF;
150: if g_debug then

Line 151: hr_utility.set_location('hxt_time_pay.get_retro_fields',90);

147: end if;
148: p_pa_status := 'P';
149: END IF;
150: if g_debug then
151: hr_utility.set_location('hxt_time_pay.get_retro_fields',90);
152: end if;
153: CLOSE complete_pa_trans;
154: END IF;
155: if g_debug then

Line 156: hr_utility.set_location('hxt_time_pay.get_retro_fields',100);

152: end if;
153: CLOSE complete_pa_trans;
154: END IF;
155: if g_debug then
156: hr_utility.set_location('hxt_time_pay.get_retro_fields',100);
157: end if;
158: CLOSE retro_pa_trans;
159:
160: OPEN check_for_details ;

Line 163: hr_utility.trace('p_pay_status :'||p_pay_status);

159:
160: OPEN check_for_details ;
161: FETCH check_for_details INTO p_pay_status ;
162: if g_debug then
163: hr_utility.trace('p_pay_status :'||p_pay_status);
164: end if;
165:
166: IF check_for_details%FOUND THEN
167: if g_debug then

Line 168: hr_utility.set_location('hxt_time_pay.get_retro_fields',110);

164: end if;
165:
166: IF check_for_details%FOUND THEN
167: if g_debug then
168: hr_utility.set_location('hxt_time_pay.get_retro_fields',110);
169: end if;
170: p_retro_batch_id := HXT_UTIL.Get_Retro_Batch_Id(p_tim_id
171: ,p_batch_name
172: ,p_batch_ref);

Line 174: hr_utility.trace('p_retro_batch_id :'||p_retro_batch_id);

170: p_retro_batch_id := HXT_UTIL.Get_Retro_Batch_Id(p_tim_id
171: ,p_batch_name
172: ,p_batch_ref);
173: if g_debug then
174: hr_utility.trace('p_retro_batch_id :'||p_retro_batch_id);
175: end if;
176: END IF ;
177: if g_debug then
178: hr_utility.set_location('hxt_time_pay.get_retro_fields',120);

Line 178: hr_utility.set_location('hxt_time_pay.get_retro_fields',120);

174: hr_utility.trace('p_retro_batch_id :'||p_retro_batch_id);
175: end if;
176: END IF ;
177: if g_debug then
178: hr_utility.set_location('hxt_time_pay.get_retro_fields',120);
179: end if;
180: close check_for_details ;
181:
182: p_error_status := 0;

Line 188: hr_utility.set_location('hxt_time_pay.get_retro_fields',130);

184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: if g_debug then
188: hr_utility.set_location('hxt_time_pay.get_retro_fields',130);
189: end if;
190: p_error_status := 2;
191: p_sqlerrm := sqlerrm;
192:

Line 263: hr_utility.set_location('hxt_time_pay.call_gen_error',10);

259:
260: BEGIN
261:
262: if g_debug then
263: hr_utility.set_location('hxt_time_pay.call_gen_error',10);
264: end if;
265: hxt_util.gen_error(g_tim_id,
266: g_id,
267: NULL,

Line 275: hr_utility.set_location('hxt_time_pay.call_gen_error',20);

271: g_EFFECTIVE_START_DATE,
272: g_EFFECTIVE_END_DATE,
273: 'ERR');
274: if g_debug then
275: hr_utility.set_location('hxt_time_pay.call_gen_error',20);
276: end if;
277: RETURN 2;
278: END;
279:

Line 292: hr_utility.set_location('hxt_time_pay.call_gen_error',10);

288: -- calls error processing procedure --
289: BEGIN
290:
291: if g_debug then
292: hr_utility.set_location('hxt_time_pay.call_gen_error',10);
293: end if;
294: hxt_util.gen_error(g_tim_id,
295: g_id,
296: NULL,

Line 317: hr_utility.trace('Adding to g_otm_messages'||p_msg_name);

313: p_timecard_bb_ovn=> NULL,
314: p_time_attribute_ovn=> NULL
315: );
316: if g_debug then
317: hr_utility.trace('Adding to g_otm_messages'||p_msg_name);
318: hr_utility.set_location('hxt_time_pay.call_gen_error',20);
319: end if;
320: RETURN 2;
321: END;

Line 318: hr_utility.set_location('hxt_time_pay.call_gen_error',20);

314: p_time_attribute_ovn=> NULL
315: );
316: if g_debug then
317: hr_utility.trace('Adding to g_otm_messages'||p_msg_name);
318: hr_utility.set_location('hxt_time_pay.call_gen_error',20);
319: end if;
320: RETURN 2;
321: END;
322:

Line 401: hr_utility.set_location('hxt_time_pay.INSERT_HRS',10);

397: BEGIN
398:
399: if g_debug then
400:
401: hr_utility.set_location('hxt_time_pay.INSERT_HRS',10);
402: end if;
403:
404: --Set return code and get ID.
405: p_return_code := 0;

Line 411: hr_utility.trace('l_id :'||l_id);

407: OPEN next_id_cur;
408: FETCH next_id_cur INTO l_id;
409: if g_debug then
410:
411: hr_utility.trace('l_id :'||l_id);
412: end if;
413: CLOSE next_id_cur;
414:
415: p_id := l_id;

Line 428: hr_utility.set_location('hxt_time_pay.INSERT_HRS',20);

424: ,l_sqlerrm);
425:
426: IF l_error_status = 0 THEN
427: if g_debug then
428: hr_utility.set_location('hxt_time_pay.INSERT_HRS',20);
429: end if;
430:
431: BEGIN
432: -- ***********************************

Line 437: hr_utility.set_location('hxt_time_pay.INSERT_HRS',30);

433: -- ORACLE START Bugs #465434 & #464850
434: -- ***********************************
435:
436: if g_debug then
437: hr_utility.set_location('hxt_time_pay.INSERT_HRS',30);
438: end if;
439:
440: OPEN get_ovt_rates_cur ;
441: FETCH get_ovt_rates_cur

Line 444: hr_utility.trace('premium_type :'||premium_type);

440: OPEN get_ovt_rates_cur ;
441: FETCH get_ovt_rates_cur
442: INTO premium_type, premium_amount, processing_order ;
443: if g_debug then
444: hr_utility.trace('premium_type :'||premium_type);
445: hr_utility.trace('premium_amount :'||premium_amount);
446: hr_utility.trace('processing_order :'||processing_order);
447: end if;
448:

Line 445: hr_utility.trace('premium_amount :'||premium_amount);

441: FETCH get_ovt_rates_cur
442: INTO premium_type, premium_amount, processing_order ;
443: if g_debug then
444: hr_utility.trace('premium_type :'||premium_type);
445: hr_utility.trace('premium_amount :'||premium_amount);
446: hr_utility.trace('processing_order :'||processing_order);
447: end if;
448:
449: CLOSE get_ovt_rates_cur ;

Line 446: hr_utility.trace('processing_order :'||processing_order);

442: INTO premium_type, premium_amount, processing_order ;
443: if g_debug then
444: hr_utility.trace('premium_type :'||premium_type);
445: hr_utility.trace('premium_amount :'||premium_amount);
446: hr_utility.trace('processing_order :'||processing_order);
447: end if;
448:
449: CLOSE get_ovt_rates_cur ;
450: --

Line 455: hr_utility.trace('l_hours :'||l_hours);

451: -- Default the hours worked to those passed in
452: --
453: l_hours := p_hours ; -- SIR092
454: if g_debug then
455: hr_utility.trace('l_hours :'||l_hours);
456: end if;
457: --
458: -- Determine if a premium amount should apply.
459: --

Line 462: hr_utility.set_location('hxt_time_pay.INSERT_HRS',40);

458: -- Determine if a premium amount should apply.
459: --
460: IF premium_type = 'FACTOR' THEN
461: if g_debug then
462: hr_utility.set_location('hxt_time_pay.INSERT_HRS',40);
463: end if;
464: l_rate_multiple := premium_amount ;
465: ELSIF premium_type = 'RATE' THEN
466: if g_debug then

Line 467: hr_utility.set_location('hxt_time_pay.INSERT_HRS',50);

463: end if;
464: l_rate_multiple := premium_amount ;
465: ELSIF premium_type = 'RATE' THEN
466: if g_debug then
467: hr_utility.set_location('hxt_time_pay.INSERT_HRS',50);
468: end if;
469: l_hourly_rate := premium_amount ;
470: ELSIF premium_type = 'FIXED' THEN
471: if g_debug then

Line 472: hr_utility.set_location('hxt_time_pay.INSERT_HRS',60);

468: end if;
469: l_hourly_rate := premium_amount ;
470: ELSIF premium_type = 'FIXED' THEN
471: if g_debug then
472: hr_utility.set_location('hxt_time_pay.INSERT_HRS',60);
473: end if;
474: l_amount := premium_amount ;
475: l_hours := 0 ; -- SIR092 Hours have no meaning with
476: -- flat amount premiums

Line 479: hr_utility.set_location('hxt_time_pay.INSERT_HRS',70);

475: l_hours := 0 ; -- SIR092 Hours have no meaning with
476: -- flat amount premiums
477: ELSE
478: if g_debug then
479: hr_utility.set_location('hxt_time_pay.INSERT_HRS',70);
480: end if;
481: NULL ;
482: END IF ;
483: --

Line 488: hr_utility.set_location('hxt_time_pay.INSERT_HRS',80);

484: -- Any values passed in from globals will override retrieved values.
485: --
486: IF g_rate_multiple IS NOT NULL THEN
487: if g_debug then
488: hr_utility.set_location('hxt_time_pay.INSERT_HRS',80);
489: end if;
490: l_rate_multiple := g_rate_multiple ;
491: if g_debug then
492: hr_utility.trace('l_rate_multiple :'||l_rate_multiple);

Line 492: hr_utility.trace('l_rate_multiple :'||l_rate_multiple);

488: hr_utility.set_location('hxt_time_pay.INSERT_HRS',80);
489: end if;
490: l_rate_multiple := g_rate_multiple ;
491: if g_debug then
492: hr_utility.trace('l_rate_multiple :'||l_rate_multiple);
493: end if;
494: END IF ;
495: --
496: IF g_hourly_rate IS NOT NULL THEN

Line 498: hr_utility.set_location('hxt_time_pay.INSERT_HRS',90);

494: END IF ;
495: --
496: IF g_hourly_rate IS NOT NULL THEN
497: if g_debug then
498: hr_utility.set_location('hxt_time_pay.INSERT_HRS',90);
499: end if;
500: l_hourly_rate := g_hourly_rate ;
501: END IF ;
502: --

Line 505: hr_utility.set_location('hxt_time_pay.INSERT_HRS',100);

501: END IF ;
502: --
503: IF g_amount IS NOT NULL THEN
504: if g_debug then
505: hr_utility.set_location('hxt_time_pay.INSERT_HRS',100);
506: end if;
507: l_amount := g_amount ;
508: if g_debug then
509: hr_utility.trace('l_amount :'||l_amount);

Line 509: hr_utility.trace('l_amount :'||l_amount);

505: hr_utility.set_location('hxt_time_pay.INSERT_HRS',100);
506: end if;
507: l_amount := g_amount ;
508: if g_debug then
509: hr_utility.trace('l_amount :'||l_amount);
510: end if;
511: END IF ;
512:
513: -- *********************************

Line 518: hr_utility.set_location('hxt_time_pay.INSERT_HRS',110);

514: -- ORACLE END Bugs #465434 & #464850
515: -- *********************************
516: --
517: if g_debug then
518: hr_utility.set_location('hxt_time_pay.INSERT_HRS',110);
519: end if;
520: l_costable_type := HXT_UTIL.get_costable_type(p_element_type_id,
521: g_date_worked,
522: g_assignment_id);

Line 524: hr_utility.trace('l_costable_type :'||l_costable_type);

520: l_costable_type := HXT_UTIL.get_costable_type(p_element_type_id,
521: g_date_worked,
522: g_assignment_id);
523: if g_debug then
524: hr_utility.trace('l_costable_type :'||l_costable_type);
525: end if;
526:
527: IF l_costable_type in ('C','F') THEN
528: if g_debug then

Line 529: hr_utility.set_location('hxt_time_pay.INSERT_HRS',120);

525: end if;
526:
527: IF l_costable_type in ('C','F') THEN
528: if g_debug then
529: hr_utility.set_location('hxt_time_pay.INSERT_HRS',120);
530: end if;
531: l_ffv_cost_center_id := g_FFV_COST_CENTER_ID;
532: if g_debug then
533: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);

Line 533: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);

529: hr_utility.set_location('hxt_time_pay.INSERT_HRS',120);
530: end if;
531: l_ffv_cost_center_id := g_FFV_COST_CENTER_ID;
532: if g_debug then
533: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);
534: end if;
535: ELSE
536: if g_debug then
537: hr_utility.set_location('hxt_time_pay.INSERT_HRS',130);

Line 537: hr_utility.set_location('hxt_time_pay.INSERT_HRS',130);

533: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);
534: end if;
535: ELSE
536: if g_debug then
537: hr_utility.set_location('hxt_time_pay.INSERT_HRS',130);
538: end if;
539: l_ffv_cost_center_id := NULL;
540: if g_debug then
541: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);

Line 541: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);

537: hr_utility.set_location('hxt_time_pay.INSERT_HRS',130);
538: end if;
539: l_ffv_cost_center_id := NULL;
540: if g_debug then
541: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);
542: end if;
543: END IF;
544:
545: /* INSERT INTO hxt_det_hours_worked_f(id,

Line 619: hr_utility.set_location('hxt_time_pay.INSERT_HRS',140);

615:
616:
617: /* Call dml to insert hours into hxt_det_hours_worked_f */
618: if g_debug then
619: hr_utility.set_location('hxt_time_pay.INSERT_HRS',140);
620: end if;
621:
622: hxt_dml.insert_HXT_DET_HOURS_WORKED(
623: p_rowid => l_rowid,

Line 670: hr_utility.set_location('hxt_time_pay.INSERT_HRS',150);

666: p_CITY_NAME => g_CITY_NAME,
667: p_ZIP_CODE => g_ZIP_CODE);
668:
669: if g_debug then
670: hr_utility.set_location('hxt_time_pay.INSERT_HRS',150);
671: end if;
672:
673: EXCEPTION
674:

Line 677: hr_utility.set_location('hxt_time_pay.INSERT_HRS',160);

673: EXCEPTION
674:
675: WHEN OTHERS THEN
676: if g_debug then
677: hr_utility.set_location('hxt_time_pay.INSERT_HRS',160);
678: end if;
679: -- Insert record in error table.
680: FND_MESSAGE.SET_NAME('HXT','HXT_39313_OR_ERR_INS_REC');
681: p_return_code := call_hxthxc_gen_error('HXT','HXT_39313_OR_ERR_INS_REC',NULL,p_location||':INS', '',sqlerrm);

Line 684: hr_utility.trace('p_return_code :'||p_return_code);

680: FND_MESSAGE.SET_NAME('HXT','HXT_39313_OR_ERR_INS_REC');
681: p_return_code := call_hxthxc_gen_error('HXT','HXT_39313_OR_ERR_INS_REC',NULL,p_location||':INS', '',sqlerrm);
682: --2278400 p_return_code := call_gen_error(p_location||':INS', '',sqlerrm);
683: if g_debug then
684: hr_utility.trace('p_return_code :'||p_return_code);
685: end if;
686: END;
687:
688: ELSE

Line 690: hr_utility.set_location('hxt_time_pay.INSERT_HRS',170);

686: END;
687:
688: ELSE
689: if g_debug then
690: hr_utility.set_location('hxt_time_pay.INSERT_HRS',170);
691: end if;
692: FND_MESSAGE.SET_NAME('HXT','HXT_39421_GET_RETRO_ERR');
693: p_return_code := call_hxthxc_gen_error('HXT','HXT_39421_GET_RETRO_ERR',NULL,p_location||':INS', '',sqlerrm);
694: --2278400 p_return_code := call_gen_error(p_location||':INS', '',sqlerrm);

Line 696: hr_utility.trace('p_return_code :'||p_return_code);

692: FND_MESSAGE.SET_NAME('HXT','HXT_39421_GET_RETRO_ERR');
693: p_return_code := call_hxthxc_gen_error('HXT','HXT_39421_GET_RETRO_ERR',NULL,p_location||':INS', '',sqlerrm);
694: --2278400 p_return_code := call_gen_error(p_location||':INS', '',sqlerrm);
695: if g_debug then
696: hr_utility.trace('p_return_code :'||p_return_code);
697: end if;
698: END IF;
699:
700: END INSERT_HRS;

Line 1012: hr_utility.set_location('hxt_time_pay.Gen_Premiums',10);

1008:
1009: BEGIN
1010:
1011: if g_debug then
1012: hr_utility.set_location('hxt_time_pay.Gen_Premiums',10);
1013: end if;
1014:
1015: --Update location path with GEN_PREMIUMS function.
1016: l_location := p_location||':PREM';

Line 1020: hr_utility.trace('l_seqno :'||l_seqno);

1016: l_location := p_location||':PREM';
1017: --Increment line seqno
1018: l_seqno := p_seqno + 10;
1019: if g_debug then
1020: hr_utility.trace('l_seqno :'||l_seqno);
1021: hr_utility.set_location('hxt_time_pay.Gen_Premiums',20);
1022: end if;
1023:
1024: open get_min_detail_seqno;

Line 1021: hr_utility.set_location('hxt_time_pay.Gen_Premiums',20);

1017: --Increment line seqno
1018: l_seqno := p_seqno + 10;
1019: if g_debug then
1020: hr_utility.trace('l_seqno :'||l_seqno);
1021: hr_utility.set_location('hxt_time_pay.Gen_Premiums',20);
1022: end if;
1023:
1024: open get_min_detail_seqno;
1025: fetch get_min_detail_seqno into l_min_detail_seqno;

Line 1027: hr_utility.trace('l_min_detail_seqno:'||l_min_detail_seqno);

1023:
1024: open get_min_detail_seqno;
1025: fetch get_min_detail_seqno into l_min_detail_seqno;
1026: if g_debug then
1027: hr_utility.trace('l_min_detail_seqno:'||l_min_detail_seqno);
1028: end if;
1029: close get_min_detail_seqno;
1030:
1031: if g_debug then

Line 1032: hr_utility.set_location('hxt_time_pay.Gen_Premiums',30);

1028: end if;
1029: close get_min_detail_seqno;
1030:
1031: if g_debug then
1032: hr_utility.set_location('hxt_time_pay.Gen_Premiums',30);
1033: end if;
1034:
1035: open get_max_detail_seqno;
1036: fetch get_max_detail_seqno into l_max_detail_seqno;

Line 1038: hr_utility.trace('l_max_detail_seqno:'||l_max_detail_seqno);

1034:
1035: open get_max_detail_seqno;
1036: fetch get_max_detail_seqno into l_max_detail_seqno;
1037: if g_debug then
1038: hr_utility.trace('l_max_detail_seqno:'||l_max_detail_seqno);
1039: end if;
1040: close get_max_detail_seqno;
1041:
1042: --Loop through premiums person is eligible for

Line 1046: hr_utility.set_location('hxt_time_pay.Gen_Premiums',40);

1042: --Loop through premiums person is eligible for
1043: --in order of priority
1044:
1045: if g_debug then
1046: hr_utility.set_location('hxt_time_pay.Gen_Premiums',40);
1047: end if;
1048:
1049: <>
1050:

Line 1052: hr_utility.set_location('hxt_time_pay.Gen_Premiums',50);

1048:
1049: <>
1050:
1051: if g_debug then
1052: hr_utility.set_location('hxt_time_pay.Gen_Premiums',50);
1053: hr_utility.trace('g_ASSIGNMENT_ID :'||g_ASSIGNMENT_ID);
1054: hr_utility.trace('g_DATE_WORKED :'||g_DATE_WORKED);
1055: hr_utility.trace('g_PEP_ID :'||g_PEP_ID);
1056: hr_utility.trace('p_element_type_id:'||p_element_type_id);

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

1049: <>
1050:
1051: if g_debug then
1052: hr_utility.set_location('hxt_time_pay.Gen_Premiums',50);
1053: hr_utility.trace('g_ASSIGNMENT_ID :'||g_ASSIGNMENT_ID);
1054: hr_utility.trace('g_DATE_WORKED :'||g_DATE_WORKED);
1055: hr_utility.trace('g_PEP_ID :'||g_PEP_ID);
1056: hr_utility.trace('p_element_type_id:'||p_element_type_id);
1057: hr_utility.trace('g_HOL_YN :'||g_HOL_YN);

Line 1054: hr_utility.trace('g_DATE_WORKED :'||g_DATE_WORKED);

1050:
1051: if g_debug then
1052: hr_utility.set_location('hxt_time_pay.Gen_Premiums',50);
1053: hr_utility.trace('g_ASSIGNMENT_ID :'||g_ASSIGNMENT_ID);
1054: hr_utility.trace('g_DATE_WORKED :'||g_DATE_WORKED);
1055: hr_utility.trace('g_PEP_ID :'||g_PEP_ID);
1056: hr_utility.trace('p_element_type_id:'||p_element_type_id);
1057: hr_utility.trace('g_HOL_YN :'||g_HOL_YN);
1058: hr_utility.trace('p_sdf_id :'||p_sdf_id);

Line 1055: hr_utility.trace('g_PEP_ID :'||g_PEP_ID);

1051: if g_debug then
1052: hr_utility.set_location('hxt_time_pay.Gen_Premiums',50);
1053: hr_utility.trace('g_ASSIGNMENT_ID :'||g_ASSIGNMENT_ID);
1054: hr_utility.trace('g_DATE_WORKED :'||g_DATE_WORKED);
1055: hr_utility.trace('g_PEP_ID :'||g_PEP_ID);
1056: hr_utility.trace('p_element_type_id:'||p_element_type_id);
1057: hr_utility.trace('g_HOL_YN :'||g_HOL_YN);
1058: hr_utility.trace('p_sdf_id :'||p_sdf_id);
1059: hr_utility.trace('g_OSP_ID :'||g_OSP_ID);

Line 1056: hr_utility.trace('p_element_type_id:'||p_element_type_id);

1052: hr_utility.set_location('hxt_time_pay.Gen_Premiums',50);
1053: hr_utility.trace('g_ASSIGNMENT_ID :'||g_ASSIGNMENT_ID);
1054: hr_utility.trace('g_DATE_WORKED :'||g_DATE_WORKED);
1055: hr_utility.trace('g_PEP_ID :'||g_PEP_ID);
1056: hr_utility.trace('p_element_type_id:'||p_element_type_id);
1057: hr_utility.trace('g_HOL_YN :'||g_HOL_YN);
1058: hr_utility.trace('p_sdf_id :'||p_sdf_id);
1059: hr_utility.trace('g_OSP_ID :'||g_OSP_ID);
1060: hr_utility.trace('p_sdovr_id :'||p_sdovr_id);

Line 1057: hr_utility.trace('g_HOL_YN :'||g_HOL_YN);

1053: hr_utility.trace('g_ASSIGNMENT_ID :'||g_ASSIGNMENT_ID);
1054: hr_utility.trace('g_DATE_WORKED :'||g_DATE_WORKED);
1055: hr_utility.trace('g_PEP_ID :'||g_PEP_ID);
1056: hr_utility.trace('p_element_type_id:'||p_element_type_id);
1057: hr_utility.trace('g_HOL_YN :'||g_HOL_YN);
1058: hr_utility.trace('p_sdf_id :'||p_sdf_id);
1059: hr_utility.trace('g_OSP_ID :'||g_OSP_ID);
1060: hr_utility.trace('p_sdovr_id :'||p_sdovr_id);
1061: hr_utility.trace('p_time_in :'||to_char(p_time_in,'DD-MON-YYYY HH24:MI:SS'));

Line 1058: hr_utility.trace('p_sdf_id :'||p_sdf_id);

1054: hr_utility.trace('g_DATE_WORKED :'||g_DATE_WORKED);
1055: hr_utility.trace('g_PEP_ID :'||g_PEP_ID);
1056: hr_utility.trace('p_element_type_id:'||p_element_type_id);
1057: hr_utility.trace('g_HOL_YN :'||g_HOL_YN);
1058: hr_utility.trace('p_sdf_id :'||p_sdf_id);
1059: hr_utility.trace('g_OSP_ID :'||g_OSP_ID);
1060: hr_utility.trace('p_sdovr_id :'||p_sdovr_id);
1061: hr_utility.trace('p_time_in :'||to_char(p_time_in,'DD-MON-YYYY HH24:MI:SS'));
1062: hr_utility.trace('p_time_out :'||to_char(p_time_out,'DD-MON-YYYY HH24:MI:SS'));

Line 1059: hr_utility.trace('g_OSP_ID :'||g_OSP_ID);

1055: hr_utility.trace('g_PEP_ID :'||g_PEP_ID);
1056: hr_utility.trace('p_element_type_id:'||p_element_type_id);
1057: hr_utility.trace('g_HOL_YN :'||g_HOL_YN);
1058: hr_utility.trace('p_sdf_id :'||p_sdf_id);
1059: hr_utility.trace('g_OSP_ID :'||g_OSP_ID);
1060: hr_utility.trace('p_sdovr_id :'||p_sdovr_id);
1061: hr_utility.trace('p_time_in :'||to_char(p_time_in,'DD-MON-YYYY HH24:MI:SS'));
1062: hr_utility.trace('p_time_out :'||to_char(p_time_out,'DD-MON-YYYY HH24:MI:SS'));
1063: end if;

Line 1060: hr_utility.trace('p_sdovr_id :'||p_sdovr_id);

1056: hr_utility.trace('p_element_type_id:'||p_element_type_id);
1057: hr_utility.trace('g_HOL_YN :'||g_HOL_YN);
1058: hr_utility.trace('p_sdf_id :'||p_sdf_id);
1059: hr_utility.trace('g_OSP_ID :'||g_OSP_ID);
1060: hr_utility.trace('p_sdovr_id :'||p_sdovr_id);
1061: hr_utility.trace('p_time_in :'||to_char(p_time_in,'DD-MON-YYYY HH24:MI:SS'));
1062: hr_utility.trace('p_time_out :'||to_char(p_time_out,'DD-MON-YYYY HH24:MI:SS'));
1063: end if;
1064: FOR elig_prem_rec IN cur_elig_prem

Line 1061: hr_utility.trace('p_time_in :'||to_char(p_time_in,'DD-MON-YYYY HH24:MI:SS'));

1057: hr_utility.trace('g_HOL_YN :'||g_HOL_YN);
1058: hr_utility.trace('p_sdf_id :'||p_sdf_id);
1059: hr_utility.trace('g_OSP_ID :'||g_OSP_ID);
1060: hr_utility.trace('p_sdovr_id :'||p_sdovr_id);
1061: hr_utility.trace('p_time_in :'||to_char(p_time_in,'DD-MON-YYYY HH24:MI:SS'));
1062: hr_utility.trace('p_time_out :'||to_char(p_time_out,'DD-MON-YYYY HH24:MI:SS'));
1063: end if;
1064: FOR elig_prem_rec IN cur_elig_prem
1065: LOOP

Line 1062: hr_utility.trace('p_time_out :'||to_char(p_time_out,'DD-MON-YYYY HH24:MI:SS'));

1058: hr_utility.trace('p_sdf_id :'||p_sdf_id);
1059: hr_utility.trace('g_OSP_ID :'||g_OSP_ID);
1060: hr_utility.trace('p_sdovr_id :'||p_sdovr_id);
1061: hr_utility.trace('p_time_in :'||to_char(p_time_in,'DD-MON-YYYY HH24:MI:SS'));
1062: hr_utility.trace('p_time_out :'||to_char(p_time_out,'DD-MON-YYYY HH24:MI:SS'));
1063: end if;
1064: FOR elig_prem_rec IN cur_elig_prem
1065: LOOP
1066:

Line 1068: hr_utility.set_location('hxt_time_pay.Gen_Premiums',60);

1064: FOR elig_prem_rec IN cur_elig_prem
1065: LOOP
1066:
1067: if g_debug then
1068: hr_utility.set_location('hxt_time_pay.Gen_Premiums',60);
1069: end if;
1070: /*
1071: -- Check if the hxt_earning_category is Shift Differential Override.
1072: -- If yes,then check whether the employee has worked other than their

Line 1078: hr_utility.set_location('hxt_time_pay.Gen_Premiums',61);

1074: -- worked other than their regular shifts.
1075:
1076: IF elig_prem_rec.hxt_earning_category <> 'SDF' THEN
1077: if g_debug then
1078: hr_utility.set_location('hxt_time_pay.Gen_Premiums',61);
1079: end if;
1080: lv_elig_for_prem := TRUE;
1081: END IF;
1082:

Line 1085: hr_utility.set_location('hxt_time_pay.Gen_Premiums',62);

1081: END IF;
1082:
1083: IF elig_prem_rec.hxt_earning_category = 'SDF' THEN
1084: if g_debug then
1085: hr_utility.set_location('hxt_time_pay.Gen_Premiums',62);
1086: end if;
1087:
1088: open Get_Shift_Info( g_ASSIGNMENT_ID,g_DATE_WORKED );
1089: fetch Get_Shift_Info into lv_rotation_plan ,lv_tws_id ,lv_week_day

Line 1093: hr_utility.set_location('hxt_time_pay.Gen_Premiums',63);

1089: fetch Get_Shift_Info into lv_rotation_plan ,lv_tws_id ,lv_week_day
1090: ,lv_standard_start ,lv_standard_stop;
1091:
1092: if g_debug then
1093: hr_utility.set_location('hxt_time_pay.Gen_Premiums',63);
1094: end if;
1095: close Get_Shift_Info;
1096:
1097: if g_debug then

Line 1098: hr_utility.trace('lv_rotation_plan :'||lv_rotation_plan);

1094: end if;
1095: close Get_Shift_Info;
1096:
1097: if g_debug then
1098: hr_utility.trace('lv_rotation_plan :'||lv_rotation_plan);
1099: hr_utility.trace('lv_tws_id :'||lv_tws_id);
1100: hr_utility.trace('lv_week_day :'||lv_week_day);
1101: hr_utility.trace('lv_standard_start:'||lv_standard_start);
1102: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);

Line 1099: hr_utility.trace('lv_tws_id :'||lv_tws_id);

1095: close Get_Shift_Info;
1096:
1097: if g_debug then
1098: hr_utility.trace('lv_rotation_plan :'||lv_rotation_plan);
1099: hr_utility.trace('lv_tws_id :'||lv_tws_id);
1100: hr_utility.trace('lv_week_day :'||lv_week_day);
1101: hr_utility.trace('lv_standard_start:'||lv_standard_start);
1102: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
1103: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);

Line 1100: hr_utility.trace('lv_week_day :'||lv_week_day);

1096:
1097: if g_debug then
1098: hr_utility.trace('lv_rotation_plan :'||lv_rotation_plan);
1099: hr_utility.trace('lv_tws_id :'||lv_tws_id);
1100: hr_utility.trace('lv_week_day :'||lv_week_day);
1101: hr_utility.trace('lv_standard_start:'||lv_standard_start);
1102: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
1103: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);
1104:

Line 1101: hr_utility.trace('lv_standard_start:'||lv_standard_start);

1097: if g_debug then
1098: hr_utility.trace('lv_rotation_plan :'||lv_rotation_plan);
1099: hr_utility.trace('lv_tws_id :'||lv_tws_id);
1100: hr_utility.trace('lv_week_day :'||lv_week_day);
1101: hr_utility.trace('lv_standard_start:'||lv_standard_start);
1102: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
1103: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);
1104:
1105: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));

Line 1102: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);

1098: hr_utility.trace('lv_rotation_plan :'||lv_rotation_plan);
1099: hr_utility.trace('lv_tws_id :'||lv_tws_id);
1100: hr_utility.trace('lv_week_day :'||lv_week_day);
1101: hr_utility.trace('lv_standard_start:'||lv_standard_start);
1102: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
1103: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);
1104:
1105: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));
1106: hr_utility.trace('p_time_out :'||to_char(p_time_out,'HH24MI'));

Line 1103: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);

1099: hr_utility.trace('lv_tws_id :'||lv_tws_id);
1100: hr_utility.trace('lv_week_day :'||lv_week_day);
1101: hr_utility.trace('lv_standard_start:'||lv_standard_start);
1102: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
1103: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);
1104:
1105: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));
1106: hr_utility.trace('p_time_out :'||to_char(p_time_out,'HH24MI'));
1107:

Line 1105: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));

1101: hr_utility.trace('lv_standard_start:'||lv_standard_start);
1102: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
1103: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);
1104:
1105: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));
1106: hr_utility.trace('p_time_out :'||to_char(p_time_out,'HH24MI'));
1107:
1108: hr_utility.trace('p_time_in :'||to_number(to_char(p_time_in,'HH24MI')));
1109: hr_utility.trace('p_time_out:'||to_number(to_char(p_time_out,'HH24MI')));

Line 1106: hr_utility.trace('p_time_out :'||to_char(p_time_out,'HH24MI'));

1102: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
1103: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);
1104:
1105: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));
1106: hr_utility.trace('p_time_out :'||to_char(p_time_out,'HH24MI'));
1107:
1108: hr_utility.trace('p_time_in :'||to_number(to_char(p_time_in,'HH24MI')));
1109: hr_utility.trace('p_time_out:'||to_number(to_char(p_time_out,'HH24MI')));
1110: end if;

Line 1108: hr_utility.trace('p_time_in :'||to_number(to_char(p_time_in,'HH24MI')));

1104:
1105: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));
1106: hr_utility.trace('p_time_out :'||to_char(p_time_out,'HH24MI'));
1107:
1108: hr_utility.trace('p_time_in :'||to_number(to_char(p_time_in,'HH24MI')));
1109: hr_utility.trace('p_time_out:'||to_number(to_char(p_time_out,'HH24MI')));
1110: end if;
1111: IF lv_standard_start = 0 AND lv_standard_stop = 0
1112: AND g_osp_id is NOT NULL THEN -- for off shift days

Line 1109: hr_utility.trace('p_time_out:'||to_number(to_char(p_time_out,'HH24MI')));

1105: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));
1106: hr_utility.trace('p_time_out :'||to_char(p_time_out,'HH24MI'));
1107:
1108: hr_utility.trace('p_time_in :'||to_number(to_char(p_time_in,'HH24MI')));
1109: hr_utility.trace('p_time_out:'||to_number(to_char(p_time_out,'HH24MI')));
1110: end if;
1111: IF lv_standard_start = 0 AND lv_standard_stop = 0
1112: AND g_osp_id is NOT NULL THEN -- for off shift days
1113:

Line 1115: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64.1);

1111: IF lv_standard_start = 0 AND lv_standard_stop = 0
1112: AND g_osp_id is NOT NULL THEN -- for off shift days
1113:
1114: if g_debug then
1115: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64.1);
1116: end if;
1117: lv_elig_for_prem := TRUE; -- Thus for an off day shift the
1118: -- shift prem gets paid too
1119: -- along with the off shift premium

Line 1137: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64.2);

1133:
1134: -- i.e., If shift differential policy is applicable to time_in and
1135: -- time_outs
1136: if g_debug then
1137: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64.2);
1138: end if;
1139: lv_elig_for_prem := TRUE;
1140:
1141: ELSIF p_sdf_id = g_sdovr_id THEN

Line 1149: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64.3);

1145: -- gen_details ,so that the cursor cur_elig_prem returns a row and the
1146: -- logic gets called to insert the data into hxt_det_hours_worked
1147:
1148: if g_debug then
1149: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64.3);
1150: end if;
1151: lv_elig_for_prem := TRUE;
1152: END IF;
1153:

Line 1155: hr_utility.set_location('hxt_time_pay.Gen_Premiums',67);

1151: lv_elig_for_prem := TRUE;
1152: END IF;
1153:
1154: if g_debug then
1155: hr_utility.set_location('hxt_time_pay.Gen_Premiums',67);
1156: end if;
1157: END IF;
1158:
1159: IF lv_elig_for_prem = TRUE THEN

Line 1162: hr_utility.set_location('hxt_time_pay.Gen_Premiums',68);

1158:
1159: IF lv_elig_for_prem = TRUE THEN
1160:
1161: if g_debug then
1162: hr_utility.set_location('hxt_time_pay.Gen_Premiums',68);
1163: end if;
1164: */
1165: -- Default override multiple to override multiple in summary hour
1166: -- record (usually null)

Line 1170: hr_utility.trace('l_mult :'||l_mult);

1166: -- record (usually null)
1167: l_mult := g_RATE_MULTIPLE;
1168: l_rate := g_HOURLY_RATE; -- ORA131
1169: if g_debug then
1170: hr_utility.trace('l_mult :'||l_mult);
1171: hr_utility.trace('l_rate :'||l_rate);
1172: end if;
1173: --
1174: -- Default the hours worked zero if prem type is fixed -- SIR092

Line 1171: hr_utility.trace('l_rate :'||l_rate);

1167: l_mult := g_RATE_MULTIPLE;
1168: l_rate := g_HOURLY_RATE; -- ORA131
1169: if g_debug then
1170: hr_utility.trace('l_mult :'||l_mult);
1171: hr_utility.trace('l_rate :'||l_rate);
1172: end if;
1173: --
1174: -- Default the hours worked zero if prem type is fixed -- SIR092
1175: --

Line 1180: hr_utility.set_location ('hxt_time_pay.Gen_Premiums', 70);

1176: IF elig_prem_rec.hxt_premium_type = 'FIXED' and p_hours <> 0
1177: THEN
1178: IF g_debug
1179: THEN
1180: hr_utility.set_location ('hxt_time_pay.Gen_Premiums', 70);
1181: END IF;
1182:
1183: l_hours := 0;
1184: l_time_in := NULL;

Line 1189: hr_utility.TRACE ('l_hours :' || l_hours);

1185: l_time_out := NULL;
1186:
1187: IF g_debug
1188: THEN
1189: hr_utility.TRACE ('l_hours :' || l_hours);
1190: hr_utility.TRACE ('l_time_in:' || l_time_in);
1191: hr_utility.TRACE ('l_time_out:' || l_time_out);
1192: END IF;
1193: ELSIF elig_prem_rec.hxt_premium_type = 'FIXED' and p_hours = 0

Line 1190: hr_utility.TRACE ('l_time_in:' || l_time_in);

1186:
1187: IF g_debug
1188: THEN
1189: hr_utility.TRACE ('l_hours :' || l_hours);
1190: hr_utility.TRACE ('l_time_in:' || l_time_in);
1191: hr_utility.TRACE ('l_time_out:' || l_time_out);
1192: END IF;
1193: ELSIF elig_prem_rec.hxt_premium_type = 'FIXED' and p_hours = 0
1194: THEN

Line 1191: hr_utility.TRACE ('l_time_out:' || l_time_out);

1187: IF g_debug
1188: THEN
1189: hr_utility.TRACE ('l_hours :' || l_hours);
1190: hr_utility.TRACE ('l_time_in:' || l_time_in);
1191: hr_utility.TRACE ('l_time_out:' || l_time_out);
1192: END IF;
1193: ELSIF elig_prem_rec.hxt_premium_type = 'FIXED' and p_hours = 0
1194: THEN
1195: return 0;

Line 1199: hr_utility.set_location ('hxt_time_pay.Gen_Premiums', 80);

1195: return 0;
1196: ELSE
1197: IF g_debug
1198: THEN
1199: hr_utility.set_location ('hxt_time_pay.Gen_Premiums', 80);
1200: END IF;
1201:
1202: l_hours := p_hours;
1203: l_time_in := p_time_in;

Line 1208: hr_utility.TRACE ('l_hours :' || l_hours);

1204: l_time_out := p_time_out;
1205:
1206: IF g_debug
1207: THEN
1208: hr_utility.TRACE ('l_hours :' || l_hours);
1209: hr_utility.TRACE ( 'l_time_in:'
1210: || TO_CHAR (l_time_in,
1211: 'dd-mon-yyyy hh24:mi:ss'
1212: )

Line 1209: hr_utility.TRACE ( 'l_time_in:'

1205:
1206: IF g_debug
1207: THEN
1208: hr_utility.TRACE ('l_hours :' || l_hours);
1209: hr_utility.TRACE ( 'l_time_in:'
1210: || TO_CHAR (l_time_in,
1211: 'dd-mon-yyyy hh24:mi:ss'
1212: )
1213: );

Line 1214: hr_utility.TRACE ( 'l_time_out:'

1210: || TO_CHAR (l_time_in,
1211: 'dd-mon-yyyy hh24:mi:ss'
1212: )
1213: );
1214: hr_utility.TRACE ( 'l_time_out:'
1215: || TO_CHAR (l_time_out,
1216: 'dd-mon-yyyy hh24:mi:ss'
1217: )
1218: );

Line 1225: hr_utility.set_location('hxt_time_pay.Gen_Premiums',90);

1221:
1222: -- Check if override multiple is applicable
1223: IF elig_prem_rec.hxt_premium_type = 'FACTOR' THEN
1224: if g_debug then
1225: hr_utility.set_location('hxt_time_pay.Gen_Premiums',90);
1226: end if;
1227:
1228: -- Step through the premium detail records of type factor that
1229: -- were already inserted into the hours worked table - all are

Line 1238: hr_utility.set_location('hxt_time_pay.Gen_Premiums',100);

1234:
1235: <>
1236:
1237: if g_debug then
1238: hr_utility.set_location('hxt_time_pay.Gen_Premiums',100);
1239: end if;
1240:
1241: FOR prem_intr_rec IN cur_prem_intr(elig_prem_rec.elt_premium_id
1242: ,elig_prem_rec.hxt_processing_order)

Line 1245: hr_utility.set_location('hxt_time_pay.Gen_Premiums',110);

1241: FOR prem_intr_rec IN cur_prem_intr(elig_prem_rec.elt_premium_id
1242: ,elig_prem_rec.hxt_processing_order)
1243: LOOP
1244: if g_debug then
1245: hr_utility.set_location('hxt_time_pay.Gen_Premiums',110);
1246: end if;
1247:
1248: IF prem_intr_rec.hxt_premium_type = 'FACTOR' THEN --SIR190
1249: if g_debug then

Line 1250: hr_utility.set_location('hxt_time_pay.Gen_Premiums',120);

1246: end if;
1247:
1248: IF prem_intr_rec.hxt_premium_type = 'FACTOR' THEN --SIR190
1249: if g_debug then
1250: hr_utility.set_location('hxt_time_pay.Gen_Premiums',120);
1251: end if;
1252:
1253: -- SIR103 We must strip off the 1 from overtime premium
1254: -- so that it will be treated like any other premium in the

Line 1259: hr_utility.set_location('hxt_time_pay.Gen_Premiums',130);

1255: -- interaction calculations. PWM
1256:
1257: IF elig_prem_rec.hxt_earning_category = 'OVT' THEN --SIR103 ORA131
1258: if g_debug then
1259: hr_utility.set_location('hxt_time_pay.Gen_Premiums',130);
1260: end if;
1261: l_mult := nvl(g_RATE_MULTIPLE
1262: ,elig_prem_rec.hxt_premium_amount) -1 ; --SIR103
1263: if g_debug then

Line 1264: hr_utility.trace('l_mult :'||l_mult);

1260: end if;
1261: l_mult := nvl(g_RATE_MULTIPLE
1262: ,elig_prem_rec.hxt_premium_amount) -1 ; --SIR103
1263: if g_debug then
1264: hr_utility.trace('l_mult :'||l_mult);
1265: end if;
1266: ELSE --SIR103
1267: if g_debug then
1268: hr_utility.set_location('hxt_time_pay.Gen_Premiums',140);

Line 1268: hr_utility.set_location('hxt_time_pay.Gen_Premiums',140);

1264: hr_utility.trace('l_mult :'||l_mult);
1265: end if;
1266: ELSE --SIR103
1267: if g_debug then
1268: hr_utility.set_location('hxt_time_pay.Gen_Premiums',140);
1269: end if;
1270: l_mult := nvl(g_RATE_MULTIPLE
1271: ,elig_prem_rec.hxt_premium_amount) ; --SIR103
1272: if g_debug then

Line 1273: hr_utility.trace('l_mult :'||l_mult);

1269: end if;
1270: l_mult := nvl(g_RATE_MULTIPLE
1271: ,elig_prem_rec.hxt_premium_amount) ; --SIR103
1272: if g_debug then
1273: hr_utility.trace('l_mult :'||l_mult);
1274: end if;
1275: END IF; --SIR103
1276:
1277: -- SIR103 We must strip off the 1 from overtime premium

Line 1283: hr_utility.set_location('hxt_time_pay.Gen_Premiums',150);

1279: -- the interaction calculations. PWM
1280:
1281: IF prem_intr_rec.hxt_earning_category = 'OVT' THEN --SIR103
1282: if g_debug then
1283: hr_utility.set_location('hxt_time_pay.Gen_Premiums',150);
1284: end if;
1285: prem_intr_rec.multiple := prem_intr_rec.multiple -1 ;--SIR103
1286: END IF; --SIR103
1287: --

Line 1297: hr_utility.set_location('hxt_time_pay.Gen_Premiums',160);

1293: -- the multiple by applying the factors of the premium earned
1294: -- previously.
1295:
1296: if g_debug then
1297: hr_utility.set_location('hxt_time_pay.Gen_Premiums',160);
1298: end if;
1299: l_mult := nvl(prem_intr_rec.multiple,0) + l_mult * nvl(prem_intr_rec.multiple,1); --SIR103
1300: if g_debug then
1301: hr_utility.trace('l_mult :'||l_mult);

Line 1301: hr_utility.trace('l_mult :'||l_mult);

1297: hr_utility.set_location('hxt_time_pay.Gen_Premiums',160);
1298: end if;
1299: l_mult := nvl(prem_intr_rec.multiple,0) + l_mult * nvl(prem_intr_rec.multiple,1); --SIR103
1300: if g_debug then
1301: hr_utility.trace('l_mult :'||l_mult);
1302: end if;
1303:
1304: -- SIR103 We must add back the 1 that was stripped off before
1305: -- the calculation. PWM

Line 1309: hr_utility.set_location('hxt_time_pay.Gen_Premiums',170);

1305: -- the calculation. PWM
1306:
1307: IF prem_intr_rec.hxt_earning_category = 'OVT' THEN
1308: if g_debug then
1309: hr_utility.set_location('hxt_time_pay.Gen_Premiums',170);
1310: end if;
1311: l_mult := l_mult + 1 ;
1312: if g_debug then
1313: hr_utility.trace('l_mult :'||l_mult);

Line 1313: hr_utility.trace('l_mult :'||l_mult);

1309: hr_utility.set_location('hxt_time_pay.Gen_Premiums',170);
1310: end if;
1311: l_mult := l_mult + 1 ;
1312: if g_debug then
1313: hr_utility.trace('l_mult :'||l_mult);
1314: end if;
1315: END IF;
1316:
1317: ELSE

Line 1319: hr_utility.set_location('hxt_time_pay.Gen_Premiums',180);

1315: END IF;
1316:
1317: ELSE
1318: if g_debug then
1319: hr_utility.set_location('hxt_time_pay.Gen_Premiums',180);
1320: end if;
1321: -- Premium was RATE or FIXED, but not FACTOR so don't
1322: -- change the multiple
1323:

Line 1326: hr_utility.set_location('hxt_time_pay.Gen_Premiums',190);

1322: -- change the multiple
1323:
1324: IF elig_prem_rec.hxt_earning_category = 'OVT' THEN
1325: if g_debug then
1326: hr_utility.set_location('hxt_time_pay.Gen_Premiums',190);
1327: end if;
1328: l_mult := nvl(g_RATE_MULTIPLE
1329: ,elig_prem_rec.hxt_premium_amount) -1 ;
1330: if g_debug then

Line 1331: hr_utility.trace('l_mult :'||l_mult);

1327: end if;
1328: l_mult := nvl(g_RATE_MULTIPLE
1329: ,elig_prem_rec.hxt_premium_amount) -1 ;
1330: if g_debug then
1331: hr_utility.trace('l_mult :'||l_mult);
1332: end if;
1333: ELSE
1334: if g_debug then
1335: hr_utility.set_location('hxt_time_pay.Gen_Premiums',200);

Line 1335: hr_utility.set_location('hxt_time_pay.Gen_Premiums',200);

1331: hr_utility.trace('l_mult :'||l_mult);
1332: end if;
1333: ELSE
1334: if g_debug then
1335: hr_utility.set_location('hxt_time_pay.Gen_Premiums',200);
1336: end if;
1337: l_mult := nvl(g_RATE_MULTIPLE
1338: ,elig_prem_rec.hxt_premium_amount);
1339: if g_debug then

Line 1340: hr_utility.trace('l_mult :'||l_mult);

1336: end if;
1337: l_mult := nvl(g_RATE_MULTIPLE
1338: ,elig_prem_rec.hxt_premium_amount);
1339: if g_debug then
1340: hr_utility.trace('l_mult :'||l_mult);
1341: end if;
1342: END IF;
1343:
1344: if g_debug then

Line 1345: hr_utility.set_location('hxt_time_pay.Gen_Premiums',210);

1341: end if;
1342: END IF;
1343:
1344: if g_debug then
1345: hr_utility.set_location('hxt_time_pay.Gen_Premiums',210);
1346: end if;
1347: l_rate := prem_intr_rec.multiple + (l_mult * prem_intr_rec.multiple);
1348: l_mult := NULL;
1349: if g_debug then

Line 1350: hr_utility.trace('l_rate :'||l_rate);

1346: end if;
1347: l_rate := prem_intr_rec.multiple + (l_mult * prem_intr_rec.multiple);
1348: l_mult := NULL;
1349: if g_debug then
1350: hr_utility.trace('l_rate :'||l_rate);
1351: hr_utility.trace('l_mult :'||l_mult);
1352: end if;
1353: END IF;
1354:

Line 1351: hr_utility.trace('l_mult :'||l_mult);

1347: l_rate := prem_intr_rec.multiple + (l_mult * prem_intr_rec.multiple);
1348: l_mult := NULL;
1349: if g_debug then
1350: hr_utility.trace('l_rate :'||l_rate);
1351: hr_utility.trace('l_mult :'||l_mult);
1352: end if;
1353: END IF;
1354:
1355: if g_debug then

Line 1356: hr_utility.set_location('hxt_time_pay.Gen_Premiums',220);

1352: end if;
1353: END IF;
1354:
1355: if g_debug then
1356: hr_utility.set_location('hxt_time_pay.Gen_Premiums',220);
1357: end if;
1358: hrw_rowid := prem_intr_rec.hrwrowid;
1359: if g_debug then
1360: hr_utility.trace('hrw_rowid :'||hrw_rowid);

Line 1360: hr_utility.trace('hrw_rowid :'||hrw_rowid);

1356: hr_utility.set_location('hxt_time_pay.Gen_Premiums',220);
1357: end if;
1358: hrw_rowid := prem_intr_rec.hrwrowid;
1359: if g_debug then
1360: hr_utility.trace('hrw_rowid :'||hrw_rowid);
1361: end if;
1362: END LOOP prem_intr;
1363:
1364: if g_debug then

Line 1365: hr_utility.set_location('hxt_time_pay.Gen_Premiums',240);

1361: end if;
1362: END LOOP prem_intr;
1363:
1364: if g_debug then
1365: hr_utility.set_location('hxt_time_pay.Gen_Premiums',240);
1366: end if;
1367: END IF; -- Factor premium
1368:
1369: --

Line 1373: hr_utility.set_location('hxt_time_pay.Gen_Premiums',250);

1369: --
1370: -- ORA131 MOD START(all code between start and end mark was added forORA131)
1371: --
1372: if g_debug then
1373: hr_utility.set_location('hxt_time_pay.Gen_Premiums',250);
1374: end if;
1375: --
1376: -- Check if override rate is applicable
1377: --

Line 1380: hr_utility.set_location('hxt_time_pay.Gen_Premiums',260);

1376: -- Check if override rate is applicable
1377: --
1378: IF elig_prem_rec.hxt_premium_type = 'RATE' THEN
1379: if g_debug then
1380: hr_utility.set_location('hxt_time_pay.Gen_Premiums',260);
1381: end if;
1382: -- Step through the premium detail records of type rate that
1383: -- were already inserted into the hours worked table - all are
1384: -- lower priority than the current premium. By matching up against

Line 1392: hr_utility.set_location('hxt_time_pay.Gen_Premiums',270);

1388:
1389: <>
1390:
1391: if g_debug then
1392: hr_utility.set_location('hxt_time_pay.Gen_Premiums',270);
1393: end if;
1394:
1395: FOR prem_intr_rec IN cur_prem_intr(elig_prem_rec.elt_premium_id
1396: ,elig_prem_rec.hxt_processing_order)

Line 1399: hr_utility.set_location('hxt_time_pay.Gen_Premiums',280);

1395: FOR prem_intr_rec IN cur_prem_intr(elig_prem_rec.elt_premium_id
1396: ,elig_prem_rec.hxt_processing_order)
1397: LOOP
1398: if g_debug then
1399: hr_utility.set_location('hxt_time_pay.Gen_Premiums',280);
1400: end if;
1401:
1402: -- SIR190 No calculations are needed for Rate premiums
1403: -- since these cannot interact with another premium,

Line 1411: hr_utility.trace('l_rate :'||l_rate);

1407:
1408: l_rate := nvl(g_HOURLY_RATE
1409: ,elig_prem_rec.hxt_premium_amount); --SIR190
1410: if g_debug then
1411: hr_utility.trace('l_rate :'||l_rate);
1412: hr_utility.set_location('hxt_time_pay.Gen_Premiums',290);
1413: end if;
1414: -- The new rate is derived by multiplying the premium amount
1415: -- by the multiple of the interactive premium (which is most

Line 1412: hr_utility.set_location('hxt_time_pay.Gen_Premiums',290);

1408: l_rate := nvl(g_HOURLY_RATE
1409: ,elig_prem_rec.hxt_premium_amount); --SIR190
1410: if g_debug then
1411: hr_utility.trace('l_rate :'||l_rate);
1412: hr_utility.set_location('hxt_time_pay.Gen_Premiums',290);
1413: end if;
1414: -- The new rate is derived by multiplying the premium amount
1415: -- by the multiple of the interactive premium (which is most
1416: -- likely overtime)

Line 1427: hr_utility.trace('hrw_rowid :'||hrw_rowid);

1423: -- calculation. PWM
1424:
1425: hrw_rowid := prem_intr_rec.hrwrowid;
1426: if g_debug then
1427: hr_utility.trace('hrw_rowid :'||hrw_rowid);
1428: hr_utility.set_location('hxt_time_pay.Gen_Premiums',300);
1429: end if;
1430: END LOOP prem_intr;
1431:

Line 1428: hr_utility.set_location('hxt_time_pay.Gen_Premiums',300);

1424:
1425: hrw_rowid := prem_intr_rec.hrwrowid;
1426: if g_debug then
1427: hr_utility.trace('hrw_rowid :'||hrw_rowid);
1428: hr_utility.set_location('hxt_time_pay.Gen_Premiums',300);
1429: end if;
1430: END LOOP prem_intr;
1431:
1432: if g_debug then

Line 1433: hr_utility.set_location('hxt_time_pay.Gen_Premiums',320);

1429: end if;
1430: END LOOP prem_intr;
1431:
1432: if g_debug then
1433: hr_utility.set_location('hxt_time_pay.Gen_Premiums',320);
1434: end if;
1435: END IF; -- Rate premium
1436:
1437: -- Check if OVT premium and override multiple was derived

Line 1440: hr_utility.set_location('hxt_time_pay.Gen_Premiums',330);

1436:
1437: -- Check if OVT premium and override multiple was derived
1438: IF (l_mult is not null) THEN
1439: if g_debug then
1440: hr_utility.set_location('hxt_time_pay.Gen_Premiums',330);
1441: end if;
1442: -- Update existing base-hour detail record
1443:
1444: BEGIN

Line 1447: hr_utility.set_location('hxt_time_pay.Gen_Premiums',340);

1443:
1444: BEGIN
1445:
1446: if g_debug then
1447: hr_utility.set_location('hxt_time_pay.Gen_Premiums',340);
1448: end if;
1449: UPDATE hxt_det_hours_worked_f hrw
1450: SET rate_multiple = l_mult
1451: WHERE hrw.rowid = hrw_rowid;

Line 1455: hr_utility.set_location('hxt_time_pay.Gen_Premiums',350);

1451: WHERE hrw.rowid = hrw_rowid;
1452: EXCEPTION
1453: WHEN OTHERS THEN
1454: if g_debug then
1455: hr_utility.set_location('hxt_time_pay.Gen_Premiums',350);
1456: end if;
1457: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR');
1458: l_error_code := call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,l_location,'', sqlerrm);
1459: --2278400 l_error_code := call_gen_error(l_location,'', sqlerrm);

Line 1461: hr_utility.trace('l_error_code :'||l_error_code);

1457: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR');
1458: l_error_code := call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,l_location,'', sqlerrm);
1459: --2278400 l_error_code := call_gen_error(l_location,'', sqlerrm);
1460: if g_debug then
1461: hr_utility.trace('l_error_code :'||l_error_code);
1462: end if;
1463: END;
1464: if g_debug then
1465: hr_utility.set_location('hxt_time_pay.Gen_Premiums',360);

Line 1465: hr_utility.set_location('hxt_time_pay.Gen_Premiums',360);

1461: hr_utility.trace('l_error_code :'||l_error_code);
1462: end if;
1463: END;
1464: if g_debug then
1465: hr_utility.set_location('hxt_time_pay.Gen_Premiums',360);
1466: end if;
1467: END IF ;
1468: --
1469: -- ORA131 MOD START (all code between start and end mark was added for ORA131)

Line 1473: hr_utility.set_location('hxt_time_pay.Gen_Premiums',370);

1469: -- ORA131 MOD START (all code between start and end mark was added for ORA131)
1470: --
1471: IF (l_rate is not null) THEN
1472: if g_debug then
1473: hr_utility.set_location('hxt_time_pay.Gen_Premiums',370);
1474: end if;
1475:
1476: -- Update existing base-hour detail record
1477: BEGIN

Line 1480: hr_utility.set_location('hxt_time_pay.Gen_Premiums',380);

1476: -- Update existing base-hour detail record
1477: BEGIN
1478:
1479: if g_debug then
1480: hr_utility.set_location('hxt_time_pay.Gen_Premiums',380);
1481: end if;
1482: UPDATE hxt_det_hours_worked_f hrw
1483: SET hourly_rate = l_rate
1484: WHERE hrw.rowid = hrw_rowid;

Line 1488: hr_utility.set_location('hxt_time_pay.Gen_Premiums',390);

1484: WHERE hrw.rowid = hrw_rowid;
1485: EXCEPTION
1486: WHEN OTHERS THEN
1487: if g_debug then
1488: hr_utility.set_location('hxt_time_pay.Gen_Premiums',390);
1489: end if;
1490: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR');
1491: l_error_code := call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,l_location,'', sqlerrm);
1492: --2278400 l_error_code := call_gen_error(l_location,'', sqlerrm);

Line 1494: hr_utility.trace('l_error_code :'||l_error_code);

1490: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR');
1491: l_error_code := call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,l_location,'', sqlerrm);
1492: --2278400 l_error_code := call_gen_error(l_location,'', sqlerrm);
1493: if g_debug then
1494: hr_utility.trace('l_error_code :'||l_error_code);
1495: end if;
1496: END;
1497:
1498: if g_debug then

Line 1499: hr_utility.set_location('hxt_time_pay.Gen_Premiums',400);

1495: end if;
1496: END;
1497:
1498: if g_debug then
1499: hr_utility.set_location('hxt_time_pay.Gen_Premiums',400);
1500: end if;
1501: END IF ;
1502:
1503: IF elig_prem_rec.hxt_earning_category <> 'OVT' THEN

Line 1506: hr_utility.set_location('hxt_time_pay.Gen_Premiums',410);

1502:
1503: IF elig_prem_rec.hxt_earning_category <> 'OVT' THEN
1504:
1505: if g_debug then
1506: hr_utility.set_location('hxt_time_pay.Gen_Premiums',410);
1507: end if;
1508: get_retro_fields( g_tim_id
1509: ,HXT_TIME_COLLECTION.g_batch_name
1510: ,HXT_TIME_COLLECTION.g_batch_ref

Line 1520: hr_utility.set_location('hxt_time_pay.Gen_Premiums',420);

1516:
1517: IF l_error_status = 0 THEN
1518:
1519: if g_debug then
1520: hr_utility.set_location('hxt_time_pay.Gen_Premiums',420);
1521: end if;
1522: l_costable_type := HXT_UTIL.get_costable_type(
1523: elig_prem_rec.elt_premium_id
1524: ,g_DATE_WORKED

Line 1527: hr_utility.trace('l_costable_type :'||l_costable_type);

1523: elig_prem_rec.elt_premium_id
1524: ,g_DATE_WORKED
1525: ,g_ASSIGNMENT_ID);
1526: if g_debug then
1527: hr_utility.trace('l_costable_type :'||l_costable_type);
1528: end if;
1529:
1530: IF l_costable_type in ('C','F') THEN
1531: if g_debug then

Line 1532: hr_utility.set_location('hxt_time_pay.Gen_Premiums',430);

1528: end if;
1529:
1530: IF l_costable_type in ('C','F') THEN
1531: if g_debug then
1532: hr_utility.set_location('hxt_time_pay.Gen_Premiums',430);
1533: end if;
1534: l_ffv_cost_center_id := g_FFV_COST_CENTER_ID;
1535: if g_debug then
1536: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);

Line 1536: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);

1532: hr_utility.set_location('hxt_time_pay.Gen_Premiums',430);
1533: end if;
1534: l_ffv_cost_center_id := g_FFV_COST_CENTER_ID;
1535: if g_debug then
1536: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);
1537: end if;
1538: ELSE
1539: if g_debug then
1540: hr_utility.set_location('hxt_time_pay.Gen_Premiums',440);

Line 1540: hr_utility.set_location('hxt_time_pay.Gen_Premiums',440);

1536: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);
1537: end if;
1538: ELSE
1539: if g_debug then
1540: hr_utility.set_location('hxt_time_pay.Gen_Premiums',440);
1541: end if;
1542: l_ffv_cost_center_id := NULL;
1543: if g_debug then
1544: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);

Line 1544: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);

1540: hr_utility.set_location('hxt_time_pay.Gen_Premiums',440);
1541: end if;
1542: l_ffv_cost_center_id := NULL;
1543: if g_debug then
1544: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);
1545: end if;
1546: END IF;
1547: --
1548: -- ORACLE Bug #464850 & #465434 Be sure the detail for time records

Line 1554: hr_utility.set_location('hxt_time_pay.Gen_Premiums',450);

1550: --
1551: BEGIN
1552:
1553: if g_debug then
1554: hr_utility.set_location('hxt_time_pay.Gen_Premiums',450);
1555: end if;
1556:
1557:
1558: /* INSERT into hxt_det_hours_worked_f

Line 1629: hr_utility.trace('l_id :'||l_id);

1625: l_amount
1626: FROM dual;
1627:
1628: if g_debug then
1629: hr_utility.trace('l_id :'||l_id);
1630: hr_utility.trace('l_rate_multiple :'||l_rate_multiple);
1631: hr_utility.trace('l_hourly_rate :'||l_hourly_rate);
1632: hr_utility.trace('l_amount :'||l_amount);
1633: hr_utility.set_location('hxt_time_pay.Gen_Premiums',460);

Line 1630: hr_utility.trace('l_rate_multiple :'||l_rate_multiple);

1626: FROM dual;
1627:
1628: if g_debug then
1629: hr_utility.trace('l_id :'||l_id);
1630: hr_utility.trace('l_rate_multiple :'||l_rate_multiple);
1631: hr_utility.trace('l_hourly_rate :'||l_hourly_rate);
1632: hr_utility.trace('l_amount :'||l_amount);
1633: hr_utility.set_location('hxt_time_pay.Gen_Premiums',460);
1634: end if;

Line 1631: hr_utility.trace('l_hourly_rate :'||l_hourly_rate);

1627:
1628: if g_debug then
1629: hr_utility.trace('l_id :'||l_id);
1630: hr_utility.trace('l_rate_multiple :'||l_rate_multiple);
1631: hr_utility.trace('l_hourly_rate :'||l_hourly_rate);
1632: hr_utility.trace('l_amount :'||l_amount);
1633: hr_utility.set_location('hxt_time_pay.Gen_Premiums',460);
1634: end if;
1635: hxt_dml.insert_HXT_DET_HOURS_WORKED(

Line 1632: hr_utility.trace('l_amount :'||l_amount);

1628: if g_debug then
1629: hr_utility.trace('l_id :'||l_id);
1630: hr_utility.trace('l_rate_multiple :'||l_rate_multiple);
1631: hr_utility.trace('l_hourly_rate :'||l_hourly_rate);
1632: hr_utility.trace('l_amount :'||l_amount);
1633: hr_utility.set_location('hxt_time_pay.Gen_Premiums',460);
1634: end if;
1635: hxt_dml.insert_HXT_DET_HOURS_WORKED(
1636: p_rowid => l_rowid,

Line 1633: hr_utility.set_location('hxt_time_pay.Gen_Premiums',460);

1629: hr_utility.trace('l_id :'||l_id);
1630: hr_utility.trace('l_rate_multiple :'||l_rate_multiple);
1631: hr_utility.trace('l_hourly_rate :'||l_hourly_rate);
1632: hr_utility.trace('l_amount :'||l_amount);
1633: hr_utility.set_location('hxt_time_pay.Gen_Premiums',460);
1634: end if;
1635: hxt_dml.insert_HXT_DET_HOURS_WORKED(
1636: p_rowid => l_rowid,
1637: p_id => l_id,

Line 1683: hr_utility.set_location('hxt_time_pay.Gen_Premiums',470);

1679: p_CITY_NAME => g_CITY_NAME,
1680: p_ZIP_CODE => g_ZIP_CODE);
1681:
1682: if g_debug then
1683: hr_utility.set_location('hxt_time_pay.Gen_Premiums',470);
1684: end if;
1685:
1686:
1687: EXCEPTION

Line 1690: hr_utility.set_location('hxt_time_pay.Gen_Premiums',480);

1686:
1687: EXCEPTION
1688: WHEN OTHERS THEN
1689: if g_debug then
1690: hr_utility.set_location('hxt_time_pay.Gen_Premiums',480);
1691: end if;
1692: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR');
1693: l_error_code := call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,l_location,'', sqlerrm);
1694: --2278400 l_error_code := call_gen_error(l_location,'', sqlerrm);

Line 1696: hr_utility.trace('l_error_code :'||l_error_code);

1692: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR');
1693: l_error_code := call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,l_location,'', sqlerrm);
1694: --2278400 l_error_code := call_gen_error(l_location,'', sqlerrm);
1695: if g_debug then
1696: hr_utility.trace('l_error_code :'||l_error_code);
1697: end if;
1698: END;
1699: ELSE
1700: if g_debug then

Line 1701: hr_utility.set_location('hxt_time_pay.Gen_Premiums',490);

1697: end if;
1698: END;
1699: ELSE
1700: if g_debug then
1701: hr_utility.set_location('hxt_time_pay.Gen_Premiums',490);
1702: end if;
1703: FND_MESSAGE.SET_NAME('HXT','HXT_39421_GET_RETRO_ERR');
1704: l_error_code := call_hxthxc_gen_error('HXT','HXT_39421_GET_RETRO_ERR',NULL,p_location||':INS', '',sqlerrm);
1705: --2278400 l_error_code := call_gen_error(p_location||':INS', '',sqlerrm);

Line 1707: hr_utility.trace('l_error_code :'||l_error_code);

1703: FND_MESSAGE.SET_NAME('HXT','HXT_39421_GET_RETRO_ERR');
1704: l_error_code := call_hxthxc_gen_error('HXT','HXT_39421_GET_RETRO_ERR',NULL,p_location||':INS', '',sqlerrm);
1705: --2278400 l_error_code := call_gen_error(p_location||':INS', '',sqlerrm);
1706: if g_debug then
1707: hr_utility.trace('l_error_code :'||l_error_code);
1708: end if;
1709: END IF;
1710:
1711: if g_debug then

Line 1712: hr_utility.set_location('hxt_time_pay.Gen_Premiums',500);

1708: end if;
1709: END IF;
1710:
1711: if g_debug then
1712: hr_utility.set_location('hxt_time_pay.Gen_Premiums',500);
1713: end if;
1714: -- Increment line sequence number
1715: l_seqno := l_seqno + 10;
1716: if g_debug then

Line 1717: hr_utility.trace('l_seqno :'||l_seqno);

1713: end if;
1714: -- Increment line sequence number
1715: l_seqno := l_seqno + 10;
1716: if g_debug then
1717: hr_utility.trace('l_seqno :'||l_seqno);
1718: end if;
1719: END IF;
1720:
1721: if g_debug then

Line 1722: hr_utility.set_location('hxt_time_pay.Gen_Premiums',505);

1718: end if;
1719: END IF;
1720:
1721: if g_debug then
1722: hr_utility.set_location('hxt_time_pay.Gen_Premiums',505);
1723: end if;
1724: -- END IF; -- END IF lv_elig_for_prem := TRUE
1725: if g_debug then
1726: hr_utility.set_location('hxt_time_pay.Gen_Premiums',510);

Line 1726: hr_utility.set_location('hxt_time_pay.Gen_Premiums',510);

1722: hr_utility.set_location('hxt_time_pay.Gen_Premiums',505);
1723: end if;
1724: -- END IF; -- END IF lv_elig_for_prem := TRUE
1725: if g_debug then
1726: hr_utility.set_location('hxt_time_pay.Gen_Premiums',510);
1727: end if;
1728: END LOOP elig_prem;
1729:
1730: if g_debug then

Line 1731: hr_utility.set_location('hxt_time_pay.Gen_Premiums',520);

1727: end if;
1728: END LOOP elig_prem;
1729:
1730: if g_debug then
1731: hr_utility.set_location('hxt_time_pay.Gen_Premiums',520);
1732: end if;
1733: RETURN l_error_code;
1734:
1735: EXCEPTION

Line 1738: hr_utility.set_location('hxt_time_pay.Gen_Premiums',530);

1734:
1735: EXCEPTION
1736: WHEN OTHERS THEN
1737: if g_debug then
1738: hr_utility.set_location('hxt_time_pay.Gen_Premiums',530);
1739: end if;
1740: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR');
1741: RETURN call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,l_location,'', sqlerrm);
1742: --2278400 RETURN call_gen_error(l_location,'', sqlerrm);

Line 1770: hr_utility.set_location('hxt_time_pay.local_pay',10);

1766:
1767: BEGIN
1768:
1769: if g_debug then
1770: hr_utility.set_location('hxt_time_pay.local_pay',10);
1771: end if;
1772:
1773: -- Get next sequence number for SEQNO.
1774: OPEN next_seq_cur;

Line 1777: hr_utility.trace('next_seq :'||next_seq);

1773: -- Get next sequence number for SEQNO.
1774: OPEN next_seq_cur;
1775: FETCH next_seq_cur INTO next_seq;
1776: if g_debug then
1777: hr_utility.trace('next_seq :'||next_seq);
1778: hr_utility.set_location('hxt_time_pay.local_pay',20);
1779: end if;
1780: IF next_seq_cur%NOTFOUND THEN
1781: if g_debug then

Line 1778: hr_utility.set_location('hxt_time_pay.local_pay',20);

1774: OPEN next_seq_cur;
1775: FETCH next_seq_cur INTO next_seq;
1776: if g_debug then
1777: hr_utility.trace('next_seq :'||next_seq);
1778: hr_utility.set_location('hxt_time_pay.local_pay',20);
1779: end if;
1780: IF next_seq_cur%NOTFOUND THEN
1781: if g_debug then
1782: hr_utility.set_location('hxt_time_pay.local_pay',30);

Line 1782: hr_utility.set_location('hxt_time_pay.local_pay',30);

1778: hr_utility.set_location('hxt_time_pay.local_pay',20);
1779: end if;
1780: IF next_seq_cur%NOTFOUND THEN
1781: if g_debug then
1782: hr_utility.set_location('hxt_time_pay.local_pay',30);
1783: end if;
1784: FND_MESSAGE.SET_NAME('HXT','HXT_39290_NO_SEQ_NO_F_HRS_WKED');
1785: RETURN call_hxthxc_gen_error('HXT','HXT_39290_NO_SEQ_NO_F_HRS_WKED',NULL,location, '');
1786: --RETURN call_gen_error(location, '');

Line 1790: hr_utility.set_location('hxt_time_pay.local_pay',40);

1786: --RETURN call_gen_error(location, '');
1787: END IF;
1788:
1789: if g_debug then
1790: hr_utility.set_location('hxt_time_pay.local_pay',40);
1791: end if;
1792: next_seq := next_seq + 10;
1793: if g_debug then
1794: hr_utility.trace('next_seq :'||next_seq);

Line 1794: hr_utility.trace('next_seq :'||next_seq);

1790: hr_utility.set_location('hxt_time_pay.local_pay',40);
1791: end if;
1792: next_seq := next_seq + 10;
1793: if g_debug then
1794: hr_utility.trace('next_seq :'||next_seq);
1795: end if;
1796:
1797: CLOSE next_seq_cur;
1798:

Line 1800: hr_utility.trace('p_hours_to_pay :'||p_hours_to_pay);

1796:
1797: CLOSE next_seq_cur;
1798:
1799: if g_debug then
1800: hr_utility.trace('p_hours_to_pay :'||p_hours_to_pay);
1801: hr_utility.trace('p_time_in :'||p_time_in);
1802: hr_utility.trace('p_time_out :'||p_time_out);
1803: hr_utility.trace('p_pay_element_type_id :'||p_pay_element_type_id);
1804: hr_utility.trace('next_seq :'||next_seq);

Line 1801: hr_utility.trace('p_time_in :'||p_time_in);

1797: CLOSE next_seq_cur;
1798:
1799: if g_debug then
1800: hr_utility.trace('p_hours_to_pay :'||p_hours_to_pay);
1801: hr_utility.trace('p_time_in :'||p_time_in);
1802: hr_utility.trace('p_time_out :'||p_time_out);
1803: hr_utility.trace('p_pay_element_type_id :'||p_pay_element_type_id);
1804: hr_utility.trace('next_seq :'||next_seq);
1805: hr_utility.trace('location :'||location);

Line 1802: hr_utility.trace('p_time_out :'||p_time_out);

1798:
1799: if g_debug then
1800: hr_utility.trace('p_hours_to_pay :'||p_hours_to_pay);
1801: hr_utility.trace('p_time_in :'||p_time_in);
1802: hr_utility.trace('p_time_out :'||p_time_out);
1803: hr_utility.trace('p_pay_element_type_id :'||p_pay_element_type_id);
1804: hr_utility.trace('next_seq :'||next_seq);
1805: hr_utility.trace('location :'||location);
1806: end if;

Line 1803: hr_utility.trace('p_pay_element_type_id :'||p_pay_element_type_id);

1799: if g_debug then
1800: hr_utility.trace('p_hours_to_pay :'||p_hours_to_pay);
1801: hr_utility.trace('p_time_in :'||p_time_in);
1802: hr_utility.trace('p_time_out :'||p_time_out);
1803: hr_utility.trace('p_pay_element_type_id :'||p_pay_element_type_id);
1804: hr_utility.trace('next_seq :'||next_seq);
1805: hr_utility.trace('location :'||location);
1806: end if;
1807: -- Call function to insert record in to hours worked table.

Line 1804: hr_utility.trace('next_seq :'||next_seq);

1800: hr_utility.trace('p_hours_to_pay :'||p_hours_to_pay);
1801: hr_utility.trace('p_time_in :'||p_time_in);
1802: hr_utility.trace('p_time_out :'||p_time_out);
1803: hr_utility.trace('p_pay_element_type_id :'||p_pay_element_type_id);
1804: hr_utility.trace('next_seq :'||next_seq);
1805: hr_utility.trace('location :'||location);
1806: end if;
1807: -- Call function to insert record in to hours worked table.
1808: if g_debug then

Line 1805: hr_utility.trace('location :'||location);

1801: hr_utility.trace('p_time_in :'||p_time_in);
1802: hr_utility.trace('p_time_out :'||p_time_out);
1803: hr_utility.trace('p_pay_element_type_id :'||p_pay_element_type_id);
1804: hr_utility.trace('next_seq :'||next_seq);
1805: hr_utility.trace('location :'||location);
1806: end if;
1807: -- Call function to insert record in to hours worked table.
1808: if g_debug then
1809: hr_utility.set_location('hxt_time_pay.local_pay',50);

Line 1809: hr_utility.set_location('hxt_time_pay.local_pay',50);

1805: hr_utility.trace('location :'||location);
1806: end if;
1807: -- Call function to insert record in to hours worked table.
1808: if g_debug then
1809: hr_utility.set_location('hxt_time_pay.local_pay',50);
1810: end if;
1811: insert_hrs(pay_return_code,
1812: new_record_id,
1813: p_hours_to_pay,

Line 1821: hr_utility.trace('pay_return_code :'||pay_return_code);

1817: next_seq,
1818: location);
1819:
1820: if g_debug then
1821: hr_utility.trace('pay_return_code :'||pay_return_code);
1822: hr_utility.trace('new_record_id :'||new_record_id);
1823: hr_utility.set_location('hxt_time_pay.local_pay',60);
1824: end if;
1825: -- Now generate all premiums for the record just inserted if

Line 1822: hr_utility.trace('new_record_id :'||new_record_id);

1818: location);
1819:
1820: if g_debug then
1821: hr_utility.trace('pay_return_code :'||pay_return_code);
1822: hr_utility.trace('new_record_id :'||new_record_id);
1823: hr_utility.set_location('hxt_time_pay.local_pay',60);
1824: end if;
1825: -- Now generate all premiums for the record just inserted if
1826: -- premiums are to be paid.

Line 1823: hr_utility.set_location('hxt_time_pay.local_pay',60);

1819:
1820: if g_debug then
1821: hr_utility.trace('pay_return_code :'||pay_return_code);
1822: hr_utility.trace('new_record_id :'||new_record_id);
1823: hr_utility.set_location('hxt_time_pay.local_pay',60);
1824: end if;
1825: -- Now generate all premiums for the record just inserted if
1826: -- premiums are to be paid.
1827: if g_debug then

Line 1828: hr_utility.trace('g_pep_id :'||g_pep_id);

1824: end if;
1825: -- Now generate all premiums for the record just inserted if
1826: -- premiums are to be paid.
1827: if g_debug then
1828: hr_utility.trace('g_pep_id :'||g_pep_id);
1829: hr_utility.trace('pay_return_code :'||pay_return_code);
1830: hr_utility.trace('g_sdovr_id :'||g_sdovr_id);
1831: hr_utility.trace('g_sdf_id :'||g_sdf_id);
1832: end if;

Line 1829: hr_utility.trace('pay_return_code :'||pay_return_code);

1825: -- Now generate all premiums for the record just inserted if
1826: -- premiums are to be paid.
1827: if g_debug then
1828: hr_utility.trace('g_pep_id :'||g_pep_id);
1829: hr_utility.trace('pay_return_code :'||pay_return_code);
1830: hr_utility.trace('g_sdovr_id :'||g_sdovr_id);
1831: hr_utility.trace('g_sdf_id :'||g_sdf_id);
1832: end if;
1833: IF g_pep_id IS NOT NULL AND pay_return_code = 0 THEN

Line 1830: hr_utility.trace('g_sdovr_id :'||g_sdovr_id);

1826: -- premiums are to be paid.
1827: if g_debug then
1828: hr_utility.trace('g_pep_id :'||g_pep_id);
1829: hr_utility.trace('pay_return_code :'||pay_return_code);
1830: hr_utility.trace('g_sdovr_id :'||g_sdovr_id);
1831: hr_utility.trace('g_sdf_id :'||g_sdf_id);
1832: end if;
1833: IF g_pep_id IS NOT NULL AND pay_return_code = 0 THEN
1834: if g_debug then

Line 1831: hr_utility.trace('g_sdf_id :'||g_sdf_id);

1827: if g_debug then
1828: hr_utility.trace('g_pep_id :'||g_pep_id);
1829: hr_utility.trace('pay_return_code :'||pay_return_code);
1830: hr_utility.trace('g_sdovr_id :'||g_sdovr_id);
1831: hr_utility.trace('g_sdf_id :'||g_sdf_id);
1832: end if;
1833: IF g_pep_id IS NOT NULL AND pay_return_code = 0 THEN
1834: if g_debug then
1835: hr_utility.set_location('hxt_time_pay.local_pay',70);

Line 1835: hr_utility.set_location('hxt_time_pay.local_pay',70);

1831: hr_utility.trace('g_sdf_id :'||g_sdf_id);
1832: end if;
1833: IF g_pep_id IS NOT NULL AND pay_return_code = 0 THEN
1834: if g_debug then
1835: hr_utility.set_location('hxt_time_pay.local_pay',70);
1836: end if;
1837: -- Commented out this and passing both sdf_id and sdovr_id to GEN_PREMIUMS
1838: -- because we need both the values to determine which gets applied to the
1839: -- incoming time_in and time_outs

Line 1842: hr_utility.trace('override_sd_id :'||override_sd_id);

1838: -- because we need both the values to determine which gets applied to the
1839: -- incoming time_in and time_outs
1840: -- override_sd_id := NVL(g_sdovr_id, g_sdf_id);
1841: if g_debug then
1842: hr_utility.trace('override_sd_id :'||override_sd_id);
1843:
1844: hr_utility.trace('g_sdf_id :'||g_sdf_id);
1845: hr_utility.trace('g_sdovr_id:'||g_sdovr_id);
1846: end if;

Line 1844: hr_utility.trace('g_sdf_id :'||g_sdf_id);

1840: -- override_sd_id := NVL(g_sdovr_id, g_sdf_id);
1841: if g_debug then
1842: hr_utility.trace('override_sd_id :'||override_sd_id);
1843:
1844: hr_utility.trace('g_sdf_id :'||g_sdf_id);
1845: hr_utility.trace('g_sdovr_id:'||g_sdovr_id);
1846: end if;
1847: pay_return_code := gen_premiums(g_sdf_id,
1848: g_sdovr_id,

Line 1845: hr_utility.trace('g_sdovr_id:'||g_sdovr_id);

1841: if g_debug then
1842: hr_utility.trace('override_sd_id :'||override_sd_id);
1843:
1844: hr_utility.trace('g_sdf_id :'||g_sdf_id);
1845: hr_utility.trace('g_sdovr_id:'||g_sdovr_id);
1846: end if;
1847: pay_return_code := gen_premiums(g_sdf_id,
1848: g_sdovr_id,
1849: location,

Line 1857: hr_utility.set_location('hxt_time_pay.local_pay',80);

1853: p_time_out,
1854: p_pay_element_type_id,
1855: next_seq);
1856: if g_debug then
1857: hr_utility.set_location('hxt_time_pay.local_pay',80);
1858: end if;
1859: END IF;
1860: if g_debug then
1861: hr_utility.set_location('hxt_time_pay.local_pay',90);

Line 1861: hr_utility.set_location('hxt_time_pay.local_pay',90);

1857: hr_utility.set_location('hxt_time_pay.local_pay',80);
1858: end if;
1859: END IF;
1860: if g_debug then
1861: hr_utility.set_location('hxt_time_pay.local_pay',90);
1862: end if;
1863: RETURN pay_return_code;
1864: EXCEPTION
1865: WHEN OTHERS THEN

Line 1867: hr_utility.set_location('hxt_time_pay.local_pay',100);

1863: RETURN pay_return_code;
1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: if g_debug then
1867: hr_utility.set_location('hxt_time_pay.local_pay',100);
1868: end if;
1869: FND_MESSAGE.SET_NAME('HXT','HXT_39273_OR_ERR_IN_PAY_MDLE');
1870: RETURN call_hxthxc_gen_error('HXT','HXT_39273_OR_ERR_IN_PAY_MDLE',NULL,location, '', sqlerrm);
1871: -- RETURN call_gen_error(location, '', sqlerrm);

Line 1875: g_debug :=hr_utility.debug_enabled;

1871: -- RETURN call_gen_error(location, '', sqlerrm);
1872: END; --local_pay
1873:
1874: BEGIN
1875: g_debug :=hr_utility.debug_enabled;
1876: if g_debug then
1877: hr_utility.set_location('hxt_time_pay.pay',10);
1878: end if;
1879: RETURN local_pay(g_hours,

Line 1877: hr_utility.set_location('hxt_time_pay.pay',10);

1873:
1874: BEGIN
1875: g_debug :=hr_utility.debug_enabled;
1876: if g_debug then
1877: hr_utility.set_location('hxt_time_pay.pay',10);
1878: end if;
1879: RETURN local_pay(g_hours,
1880: g_element_type_id,
1881: g_time_in,

Line 1884: hr_utility.set_location('hxt_time_pay.pay',20);

1880: g_element_type_id,
1881: g_time_in,
1882: g_time_out);
1883: if g_debug then
1884: hr_utility.set_location('hxt_time_pay.pay',20);
1885: end if;
1886:
1887: EXCEPTION
1888: WHEN OTHERS THEN

Line 1890: hr_utility.set_location('hxt_time_pay.pay',30);

1886:
1887: EXCEPTION
1888: WHEN OTHERS THEN
1889: if g_debug then
1890: hr_utility.set_location('hxt_time_pay.pay',30);
1891: end if;
1892: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR');
1893: RETURN call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,location, '', sqlerrm);
1894: --2278400 RETURN call_gen_error(location, '', sqlerrm);