eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_UITE_ARCH_PKG dependencies on HR_UTILITY

Line 120: gb_debug := hr_utility.debug_enabled;

116: ln_life_ins_org_id NUMBER;
117: --
118: BEGIN
119: --
120: gb_debug := hr_utility.debug_enabled;
121: --
122: IF gb_debug THEN
123: lc_procedure := gc_package||'get_life_ins_org';
124: hr_utility.set_location('Entering '||lc_procedure,1);

Line 124: hr_utility.set_location('Entering '||lc_procedure,1);

120: gb_debug := hr_utility.debug_enabled;
121: --
122: IF gb_debug THEN
123: lc_procedure := gc_package||'get_life_ins_org';
124: hr_utility.set_location('Entering '||lc_procedure,1);
125: END IF;
126: --
127: ln_life_ins_org_id := pay_jp_balance_pkg.get_entry_value_number(p_element_name => 'COM_LI_INFO'
128: ,p_input_value_name => 'EI_LOCATION'

Line 135: hr_utility.set_location('Leaving '||lc_procedure,1000);

131: );
132:
133: --
134: IF gb_debug THEN
135: hr_utility.set_location('Leaving '||lc_procedure,1000);
136: END IF;
137: --
138: RETURN ln_life_ins_org_id;
139: --

Line 143: hr_utility.set_location('No Data Found Exception in get_life_ins_org_id',10);

139: --
140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN
142: IF gb_debug THEN
143: hr_utility.set_location('No Data Found Exception in get_life_ins_org_id',10);
144: END IF;
145: RETURN NULL;
146: --
147: WHEN OTHERS THEN

Line 148: hr_utility.set_location('Error in '||lc_procedure,999999);

144: END IF;
145: RETURN NULL;
146: --
147: WHEN OTHERS THEN
148: hr_utility.set_location('Error in '||lc_procedure,999999);
149: RAISE;
150: RETURN NULL;
151: END get_life_ins_org_id;
152: --

Line 179: gb_debug := hr_utility.debug_enabled;

175: lc_ei_type VARCHAR2(60);
176: --
177: BEGIN
178: --
179: gb_debug := hr_utility.debug_enabled;
180: --
181: IF gb_debug THEN
182: lc_procedure := gc_package||'get_ei_type';
183: hr_utility.set_location('Entering '||lc_procedure,1);

Line 183: hr_utility.set_location('Entering '||lc_procedure,1);

179: gb_debug := hr_utility.debug_enabled;
180: --
181: IF gb_debug THEN
182: lc_procedure := gc_package||'get_ei_type';
183: hr_utility.set_location('Entering '||lc_procedure,1);
184: END IF;
185: --
186: lc_ei_type := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_LI_INFO'
187: ,p_input_value_name => 'EI_TYPE'

Line 194: hr_utility.set_location('Leaving '||lc_procedure,1000);

190: );
191:
192: --
193: IF gb_debug THEN
194: hr_utility.set_location('Leaving '||lc_procedure,1000);
195: END IF;
196: --
197: RETURN lc_ei_type;
198: --

Line 202: hr_utility.set_location('No Data Found Exception in get_ei_type',10);

198: --
199: EXCEPTION
200: WHEN NO_DATA_FOUND THEN
201: IF gb_debug THEN
202: hr_utility.set_location('No Data Found Exception in get_ei_type',10);
203: END IF;
204: RETURN NULL;
205: --
206: WHEN OTHERS THEN

Line 207: hr_utility.set_location('Error in '||lc_procedure,999999);

203: END IF;
204: RETURN NULL;
205: --
206: WHEN OTHERS THEN
207: hr_utility.set_location('Error in '||lc_procedure,999999);
208: RAISE;
209: RETURN NULL;
210: END get_ei_type;
211: --

Line 238: gb_debug := hr_utility.debug_enabled;

234: lc_term_rpt_flag VARCHAR2(60);
235: --
236: BEGIN
237: --
238: gb_debug := hr_utility.debug_enabled;
239: --
240: IF gb_debug THEN
241: lc_procedure := gc_package||'get_term_rpt_flag';
242: hr_utility.set_location('Entering '||lc_procedure,1);

Line 242: hr_utility.set_location('Entering '||lc_procedure,1);

238: gb_debug := hr_utility.debug_enabled;
239: --
240: IF gb_debug THEN
241: lc_procedure := gc_package||'get_term_rpt_flag';
242: hr_utility.set_location('Entering '||lc_procedure,1);
243: END IF;
244: --
245: lc_term_rpt_flag := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_EI_QUALIFY_INFO'
246: ,p_input_value_name => 'TRM_REPORT_OUTPUT_FLAG'

Line 253: hr_utility.set_location('Leaving '||lc_procedure,1000);

249: );
250:
251: --
252: IF gb_debug THEN
253: hr_utility.set_location('Leaving '||lc_procedure,1000);
254: END IF;
255: --
256: RETURN lc_term_rpt_flag;
257: --

Line 261: hr_utility.set_location('No Data Found Exception in get_term_rpt_flag',10);

257: --
258: EXCEPTION
259: WHEN NO_DATA_FOUND THEN
260: IF gb_debug THEN
261: hr_utility.set_location('No Data Found Exception in get_term_rpt_flag',10);
262: END IF;
263: RETURN NULL;
264: --
265: WHEN OTHERS THEN

Line 266: hr_utility.set_location('Error in '||lc_procedure,999999);

262: END IF;
263: RETURN NULL;
264: --
265: WHEN OTHERS THEN
266: hr_utility.set_location('Error in '||lc_procedure,999999);
267: RAISE;
268: RETURN NULL;
269: END get_term_rpt_flag;
270: --

Line 297: gb_debug := hr_utility.debug_enabled;

293: ld_qualify_date DATE;
294: --
295: BEGIN
296: --
297: gb_debug := hr_utility.debug_enabled;
298: --
299: IF gb_debug THEN
300: lc_procedure := gc_package||'get_ei_quality_date';
301: hr_utility.set_location('Entering '||lc_procedure,1);

Line 301: hr_utility.set_location('Entering '||lc_procedure,1);

297: gb_debug := hr_utility.debug_enabled;
298: --
299: IF gb_debug THEN
300: lc_procedure := gc_package||'get_ei_quality_date';
301: hr_utility.set_location('Entering '||lc_procedure,1);
302: END IF;
303: --
304: ld_qualify_date := pay_jp_balance_pkg.get_entry_value_date(p_element_name => 'COM_EI_QUALIFY_INFO'
305: ,p_input_value_name => 'QUALIFY_DATE'

Line 312: hr_utility.set_location('Leaving '||lc_procedure,1000);

308: );
309:
310: --
311: IF gb_debug THEN
312: hr_utility.set_location('Leaving '||lc_procedure,1000);
313: END IF;
314: --
315: RETURN ld_qualify_date;
316: --

Line 320: hr_utility.set_location('No Data Found Exception in get_ei_quality_date',10);

316: --
317: EXCEPTION
318: WHEN NO_DATA_FOUND THEN
319: IF gb_debug THEN
320: hr_utility.set_location('No Data Found Exception in get_ei_quality_date',10);
321: END IF;
322: RETURN NULL;
323: --
324: WHEN OTHERS THEN

Line 325: hr_utility.set_location('Error in '||lc_procedure,999999);

321: END IF;
322: RETURN NULL;
323: --
324: WHEN OTHERS THEN
325: hr_utility.set_location('Error in '||lc_procedure,999999);
326: RAISE;
327: RETURN NULL;
328: END get_ei_qualify_date;
329: --

Line 356: gb_debug := hr_utility.debug_enabled;

352: ld_qualify_date DATE;
353: --
354: BEGIN
355: --
356: gb_debug := hr_utility.debug_enabled;
357: --
358: IF gb_debug THEN
359: lc_procedure := gc_package||'get_ei_dis_qual_date';
360: hr_utility.set_location('Entering '||lc_procedure,1);

Line 360: hr_utility.set_location('Entering '||lc_procedure,1);

356: gb_debug := hr_utility.debug_enabled;
357: --
358: IF gb_debug THEN
359: lc_procedure := gc_package||'get_ei_dis_qual_date';
360: hr_utility.set_location('Entering '||lc_procedure,1);
361: END IF;
362: --
363: ld_qualify_date := pay_jp_balance_pkg.get_entry_value_date(p_element_name => 'COM_EI_QUALIFY_INFO'
364: ,p_input_value_name => 'DISQUALIFY_DATE'

Line 371: hr_utility.set_location('Leaving '||lc_procedure,1000);

367: );
368:
369: --
370: IF gb_debug THEN
371: hr_utility.set_location('Leaving '||lc_procedure,1000);
372: END IF;
373: --
374: RETURN ld_qualify_date;
375: --

Line 380: hr_utility.set_location('No Data Found Exception in get_ei_dis_qual_date',10);

376: EXCEPTION
377:
378: WHEN NO_DATA_FOUND THEN
379: IF gb_debug THEN
380: hr_utility.set_location('No Data Found Exception in get_ei_dis_qual_date',10);
381: END IF;
382: RETURN NULL;
383: --
384: WHEN OTHERS THEN

Line 385: hr_utility.set_location('Error in '||lc_procedure,999999);

381: END IF;
382: RETURN NULL;
383: --
384: WHEN OTHERS THEN
385: hr_utility.set_location('Error in '||lc_procedure,999999);
386: RAISE;
387: RETURN NULL;
388: END get_ei_dis_qual_date;
389: --

Line 416: gb_debug := hr_utility.debug_enabled;

412: lc_ui_num VARCHAR2(20);
413: --
414: BEGIN
415: --
416: gb_debug := hr_utility.debug_enabled;
417: --
418: IF gb_debug THEN
419: lc_procedure := gc_package||'get_ui_num';
420: hr_utility.set_location('Entering '||lc_procedure,1);

Line 420: hr_utility.set_location('Entering '||lc_procedure,1);

416: gb_debug := hr_utility.debug_enabled;
417: --
418: IF gb_debug THEN
419: lc_procedure := gc_package||'get_ui_num';
420: hr_utility.set_location('Entering '||lc_procedure,1);
421: END IF;
422: --
423: lc_ui_num := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_LI_INFO'
424: ,p_input_value_name => 'EI_NUM'

Line 431: hr_utility.set_location('Leaving '||lc_procedure,1000);

427: );
428:
429: --
430: IF gb_debug THEN
431: hr_utility.set_location('Leaving '||lc_procedure,1000);
432: END IF;
433: --
434: RETURN lc_ui_num;
435: --

Line 439: hr_utility.set_location('No Data Found Exception in get_ui_num',10);

435: --
436: EXCEPTION
437: WHEN NO_DATA_FOUND THEN
438: IF gb_debug THEN
439: hr_utility.set_location('No Data Found Exception in get_ui_num',10);
440: END IF;
441: RETURN NULL;
442: --
443: WHEN OTHERS THEN

Line 444: hr_utility.set_location('Error in '||lc_procedure,999999);

440: END IF;
441: RETURN NULL;
442: --
443: WHEN OTHERS THEN
444: hr_utility.set_location('Error in '||lc_procedure,999999);
445: RAISE;
446: RETURN NULL;
447: END get_ui_num;
448: --

Line 485: gb_debug := hr_utility.debug_enabled;

481: --
482: BEGIN
483: --
484: --
485: gb_debug := hr_utility.debug_enabled;
486: --
487: IF gb_debug THEN
488: lc_procedure := gc_package||'RANGE_CODE';
489: hr_utility.set_location('Entering '||lc_procedure,1);

Line 489: hr_utility.set_location('Entering '||lc_procedure,1);

485: gb_debug := hr_utility.debug_enabled;
486: --
487: IF gb_debug THEN
488: lc_procedure := gc_package||'RANGE_CODE';
489: hr_utility.set_location('Entering '||lc_procedure,1);
490: END IF;
491: --
492: OPEN csr_ele_set;
493: FETCH csr_ele_set into ln_element_set_id;

Line 534: gb_debug := hr_utility.debug_enabled;

530: ld_final_insured_date DATE;
531: --
532: BEGIN
533: --
534: gb_debug := hr_utility.debug_enabled;
535: --
536: IF gb_debug THEN
537: lc_procedure := gc_package||'get_insert_action_info';
538: hr_utility.set_location('Entering '||lc_procedure,1);

Line 538: hr_utility.set_location('Entering '||lc_procedure,1);

534: gb_debug := hr_utility.debug_enabled;
535: --
536: IF gb_debug THEN
537: lc_procedure := gc_package||'get_insert_action_info';
538: hr_utility.set_location('Entering '||lc_procedure,1);
539: END IF;
540: --
541: ln_count := p_insert_wage_info.count;
542: --

Line 544: hr_utility.set_location('p_insert_wage_info count = '||ln_count,1);

540: --
541: ln_count := p_insert_wage_info.count;
542: --
543: IF gb_debug THEN
544: hr_utility.set_location('p_insert_wage_info count = '||ln_count,1);
545: END IF;
546: --
547: IF ln_count=1 THEN
548: --

Line 673: hr_utility.set_location('Leaving '||lc_procedure,1);

669: --
670: RETURN lt_res_tb;
671: --
672: IF gb_debug THEN
673: hr_utility.set_location('Leaving '||lc_procedure,1);
674: END IF;
675: --
676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN

Line 679: hr_utility.set_location('No Data Found Exception in ' ||lc_procedure,10);

675: --
676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN
678: IF gb_debug THEN
679: hr_utility.set_location('No Data Found Exception in ' ||lc_procedure,10);
680: END IF;
681: RETURN lt_res_tb;
682: END get_insert_action_info;
683: --

Line 749: gb_debug := hr_utility.debug_enabled;

745: lr_lcu_period_for_no_assact lcu_period_for_no_assact%rowtype;
746: --
747: BEGIN
748: --
749: gb_debug := hr_utility.debug_enabled;
750: --
751: IF gb_debug THEN
752: lc_procedure := gc_package||'proc_insert_row';
753: hr_utility.set_location('Entering '||lc_procedure,1);

Line 753: hr_utility.set_location('Entering '||lc_procedure,1);

749: gb_debug := hr_utility.debug_enabled;
750: --
751: IF gb_debug THEN
752: lc_procedure := gc_package||'proc_insert_row';
753: hr_utility.set_location('Entering '||lc_procedure,1);
754: END IF;
755: --
756: OPEN lcu_period_for_no_assact;
757: --

Line 765: hr_utility.set_location('ln_diff_mth '||lc_procedure,20);

761: - TO_NUMBER(TO_CHAR(p_termination_date,'YYYY'))) * 12
762: + (TO_NUMBER(TO_CHAR(lr_lcu_period_for_no_assact.start_date,'MM'))
763: - TO_NUMBER(TO_CHAR(p_termination_date,'MM'))); --#Bug 9653516
764: --
765: hr_utility.set_location('ln_diff_mth '||lc_procedure,20);
766: --
767: -- Wage Payment Days --
768: --
769: IF TO_CHAR(lr_lcu_period_for_no_assact.start_date,'MM') = TO_CHAR(lr_lcu_period_for_no_assact.end_date,'MM') THEN

Line 825: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);

821: --
822: END IF;
823: --
824: IF gb_debug THEN
825: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
826: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
827: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
828: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
829: END IF;

Line 826: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);

822: END IF;
823: --
824: IF gb_debug THEN
825: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
826: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
827: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
828: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
829: END IF;
830: --

Line 827: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);

823: --
824: IF gb_debug THEN
825: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
826: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
827: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
828: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
829: END IF;
830: --
831: pay_action_information_api.create_action_information

Line 828: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);

824: IF gb_debug THEN
825: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
826: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
827: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
828: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
829: END IF;
830: --
831: pay_action_information_api.create_action_information
832: (p_action_information_id => ln_action_info_id

Line 861: hr_utility.set_location('Leaving '||lc_procedure,1);

857: --
858: p_line_number := ln_line_number;
859: --
860: IF gb_debug THEN
861: hr_utility.set_location('Leaving '||lc_procedure,1);
862: END IF;
863: --
864: EXCEPTION
865: --

Line 868: hr_utility.set_location('Error in '||lc_procedure,999999);

864: EXCEPTION
865: --
866: WHEN gc_exception THEN
867: IF gb_debug THEN
868: hr_utility.set_location('Error in '||lc_procedure,999999);
869: END IF;
870: RAISE;
871: --
872: WHEN OTHERS THEN

Line 1120: gb_debug := hr_utility.debug_enabled;

1116: lr_lcu_period_for_no_assact lcu_period_for_no_assact%rowtype;
1117: --
1118: BEGIN
1119: --
1120: gb_debug := hr_utility.debug_enabled;
1121: --
1122: IF gb_debug THEN
1123: lc_procedure := gc_package||'proc_sal_arch';
1124: hr_utility.set_location('Entering '||lc_procedure,1);

Line 1124: hr_utility.set_location('Entering '||lc_procedure,1);

1120: gb_debug := hr_utility.debug_enabled;
1121: --
1122: IF gb_debug THEN
1123: lc_procedure := gc_package||'proc_sal_arch';
1124: hr_utility.set_location('Entering '||lc_procedure,1);
1125: END IF;
1126: --
1127: -- Fetching balnce id for Wage Payment days
1128: --

Line 1325: hr_utility.set_location('ln_diff_mth = '||ln_diff_mth,20);

1321: - TO_NUMBER(TO_CHAR(p_termination_date,'YYYY'))) * 12
1322: + (TO_NUMBER(TO_CHAR(ld_period_start_date,'MM'))
1323: - TO_NUMBER(TO_CHAR(p_termination_date,'MM'))); --#Bug 9653516
1324: --
1325: hr_utility.set_location('ln_diff_mth = '||ln_diff_mth,20);
1326: --
1327: -- Wage Payment Days --
1328: --
1329: IF TO_CHAR(ld_period_start_date,'MM') = TO_CHAR(ld_period_end_date,'MM') THEN

Line 1477: hr_utility.set_location('ln_wage_amount_a = '||ln_wage_amount_a,11);

1473: --
1474: END IF; --Bug 9693280
1475: --
1476: IF gb_debug THEN
1477: hr_utility.set_location('ln_wage_amount_a = '||ln_wage_amount_a,11);
1478: hr_utility.set_location('ln_wage_amount_b = '||ln_wage_amount_b,12);
1479: hr_utility.set_location('ln_assignment_action_id = '||ln_assignment_action_id,13);
1480: END IF;
1481: --

Line 1478: hr_utility.set_location('ln_wage_amount_b = '||ln_wage_amount_b,12);

1474: END IF; --Bug 9693280
1475: --
1476: IF gb_debug THEN
1477: hr_utility.set_location('ln_wage_amount_a = '||ln_wage_amount_a,11);
1478: hr_utility.set_location('ln_wage_amount_b = '||ln_wage_amount_b,12);
1479: hr_utility.set_location('ln_assignment_action_id = '||ln_assignment_action_id,13);
1480: END IF;
1481: --
1482: IF (ln_wage_amount_a IS NOT NULL) THEN -- #Bug9692693

Line 1479: hr_utility.set_location('ln_assignment_action_id = '||ln_assignment_action_id,13);

1475: --
1476: IF gb_debug THEN
1477: hr_utility.set_location('ln_wage_amount_a = '||ln_wage_amount_a,11);
1478: hr_utility.set_location('ln_wage_amount_b = '||ln_wage_amount_b,12);
1479: hr_utility.set_location('ln_assignment_action_id = '||ln_assignment_action_id,13);
1480: END IF;
1481: --
1482: IF (ln_wage_amount_a IS NOT NULL) THEN -- #Bug9692693
1483: --

Line 1498: hr_utility.set_location('Payment Date '||lt_assact_tbl(assact_cnt).effective_date,11);

1494: lc_exclude_period := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','EXCLUDE_PERIOD',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);
1495: lc_remarks := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','RMKS',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);
1496: --
1497: IF gb_debug THEN
1498: hr_utility.set_location('Payment Date '||lt_assact_tbl(assact_cnt).effective_date,11);
1499: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1500: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1501: hr_utility.set_location('Insured Period Base Days '||ln_wage_pay_days,14);
1502: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);

Line 1499: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);

1495: lc_remarks := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','RMKS',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);
1496: --
1497: IF gb_debug THEN
1498: hr_utility.set_location('Payment Date '||lt_assact_tbl(assact_cnt).effective_date,11);
1499: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1500: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1501: hr_utility.set_location('Insured Period Base Days '||ln_wage_pay_days,14);
1502: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1503: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);

Line 1500: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);

1496: --
1497: IF gb_debug THEN
1498: hr_utility.set_location('Payment Date '||lt_assact_tbl(assact_cnt).effective_date,11);
1499: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1500: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1501: hr_utility.set_location('Insured Period Base Days '||ln_wage_pay_days,14);
1502: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1503: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1504: hr_utility.set_location('Pay Period Base Days '||ln_base_days,17);

Line 1501: hr_utility.set_location('Insured Period Base Days '||ln_wage_pay_days,14);

1497: IF gb_debug THEN
1498: hr_utility.set_location('Payment Date '||lt_assact_tbl(assact_cnt).effective_date,11);
1499: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1500: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1501: hr_utility.set_location('Insured Period Base Days '||ln_wage_pay_days,14);
1502: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1503: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1504: hr_utility.set_location('Pay Period Base Days '||ln_base_days,17);
1505: hr_utility.set_location('Wage Amount A '||ln_wage_amount_a,18);

Line 1502: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);

1498: hr_utility.set_location('Payment Date '||lt_assact_tbl(assact_cnt).effective_date,11);
1499: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1500: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1501: hr_utility.set_location('Insured Period Base Days '||ln_wage_pay_days,14);
1502: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1503: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1504: hr_utility.set_location('Pay Period Base Days '||ln_base_days,17);
1505: hr_utility.set_location('Wage Amount A '||ln_wage_amount_a,18);
1506: hr_utility.set_location('Wage Amount B '||ln_wage_amount_b,19);

Line 1503: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);

1499: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1500: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1501: hr_utility.set_location('Insured Period Base Days '||ln_wage_pay_days,14);
1502: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1503: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1504: hr_utility.set_location('Pay Period Base Days '||ln_base_days,17);
1505: hr_utility.set_location('Wage Amount A '||ln_wage_amount_a,18);
1506: hr_utility.set_location('Wage Amount B '||ln_wage_amount_b,19);
1507: hr_utility.set_location('Wage Amount Total '||ln_total_wage,20);

Line 1504: hr_utility.set_location('Pay Period Base Days '||ln_base_days,17);

1500: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1501: hr_utility.set_location('Insured Period Base Days '||ln_wage_pay_days,14);
1502: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1503: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1504: hr_utility.set_location('Pay Period Base Days '||ln_base_days,17);
1505: hr_utility.set_location('Wage Amount A '||ln_wage_amount_a,18);
1506: hr_utility.set_location('Wage Amount B '||ln_wage_amount_b,19);
1507: hr_utility.set_location('Wage Amount Total '||ln_total_wage,20);
1508: hr_utility.set_location('Remarks '||lc_remarks,21);

Line 1505: hr_utility.set_location('Wage Amount A '||ln_wage_amount_a,18);

1501: hr_utility.set_location('Insured Period Base Days '||ln_wage_pay_days,14);
1502: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1503: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1504: hr_utility.set_location('Pay Period Base Days '||ln_base_days,17);
1505: hr_utility.set_location('Wage Amount A '||ln_wage_amount_a,18);
1506: hr_utility.set_location('Wage Amount B '||ln_wage_amount_b,19);
1507: hr_utility.set_location('Wage Amount Total '||ln_total_wage,20);
1508: hr_utility.set_location('Remarks '||lc_remarks,21);
1509: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);

Line 1506: hr_utility.set_location('Wage Amount B '||ln_wage_amount_b,19);

1502: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1503: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1504: hr_utility.set_location('Pay Period Base Days '||ln_base_days,17);
1505: hr_utility.set_location('Wage Amount A '||ln_wage_amount_a,18);
1506: hr_utility.set_location('Wage Amount B '||ln_wage_amount_b,19);
1507: hr_utility.set_location('Wage Amount Total '||ln_total_wage,20);
1508: hr_utility.set_location('Remarks '||lc_remarks,21);
1509: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);
1510: hr_utility.set_location('ln_line_number '||ln_line_number ,23);

Line 1507: hr_utility.set_location('Wage Amount Total '||ln_total_wage,20);

1503: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1504: hr_utility.set_location('Pay Period Base Days '||ln_base_days,17);
1505: hr_utility.set_location('Wage Amount A '||ln_wage_amount_a,18);
1506: hr_utility.set_location('Wage Amount B '||ln_wage_amount_b,19);
1507: hr_utility.set_location('Wage Amount Total '||ln_total_wage,20);
1508: hr_utility.set_location('Remarks '||lc_remarks,21);
1509: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);
1510: hr_utility.set_location('ln_line_number '||ln_line_number ,23);
1511: END IF;

Line 1508: hr_utility.set_location('Remarks '||lc_remarks,21);

1504: hr_utility.set_location('Pay Period Base Days '||ln_base_days,17);
1505: hr_utility.set_location('Wage Amount A '||ln_wage_amount_a,18);
1506: hr_utility.set_location('Wage Amount B '||ln_wage_amount_b,19);
1507: hr_utility.set_location('Wage Amount Total '||ln_total_wage,20);
1508: hr_utility.set_location('Remarks '||lc_remarks,21);
1509: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);
1510: hr_utility.set_location('ln_line_number '||ln_line_number ,23);
1511: END IF;
1512: --

Line 1509: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);

1505: hr_utility.set_location('Wage Amount A '||ln_wage_amount_a,18);
1506: hr_utility.set_location('Wage Amount B '||ln_wage_amount_b,19);
1507: hr_utility.set_location('Wage Amount Total '||ln_total_wage,20);
1508: hr_utility.set_location('Remarks '||lc_remarks,21);
1509: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);
1510: hr_utility.set_location('ln_line_number '||ln_line_number ,23);
1511: END IF;
1512: --
1513:

Line 1510: hr_utility.set_location('ln_line_number '||ln_line_number ,23);

1506: hr_utility.set_location('Wage Amount B '||ln_wage_amount_b,19);
1507: hr_utility.set_location('Wage Amount Total '||ln_total_wage,20);
1508: hr_utility.set_location('Remarks '||lc_remarks,21);
1509: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);
1510: hr_utility.set_location('ln_line_number '||ln_line_number ,23);
1511: END IF;
1512: --
1513:
1514: lt_insert_wage_info(i).payment_date := lt_assact_tbl(assact_cnt).effective_date; -- Payment Date

Line 1548: hr_utility.set_location('Inserting Data into Pay action Information ',30);

1544: --
1545: WHILE j IS NOT NULL LOOP
1546: IF gb_debug THEN
1547: --
1548: hr_utility.set_location('Inserting Data into Pay action Information ',30);
1549: --
1550: END IF;
1551: --
1552: -- Summing total if wage_amount_a and wage_amount_b not null during any month

Line 1675: hr_utility.set_location('ln_diff_mth '||lc_procedure,20);

1671: END IF;
1672: --
1673: IF gb_debug THEN
1674: --
1675: hr_utility.set_location('ln_diff_mth '||lc_procedure,20);
1676: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1677: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1678: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1679: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);

Line 1676: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);

1672: --
1673: IF gb_debug THEN
1674: --
1675: hr_utility.set_location('ln_diff_mth '||lc_procedure,20);
1676: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1677: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1678: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1679: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1680: hr_utility.set_location('Remarks '||lc_remarks,21);

Line 1677: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);

1673: IF gb_debug THEN
1674: --
1675: hr_utility.set_location('ln_diff_mth '||lc_procedure,20);
1676: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1677: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1678: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1679: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1680: hr_utility.set_location('Remarks '||lc_remarks,21);
1681: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);

Line 1678: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);

1674: --
1675: hr_utility.set_location('ln_diff_mth '||lc_procedure,20);
1676: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1677: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1678: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1679: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1680: hr_utility.set_location('Remarks '||lc_remarks,21);
1681: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);
1682: hr_utility.set_location('ln_line_number '||ln_line_number ,23);

Line 1679: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);

1675: hr_utility.set_location('ln_diff_mth '||lc_procedure,20);
1676: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1677: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1678: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1679: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1680: hr_utility.set_location('Remarks '||lc_remarks,21);
1681: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);
1682: hr_utility.set_location('ln_line_number '||ln_line_number ,23);
1683: END IF;

Line 1680: hr_utility.set_location('Remarks '||lc_remarks,21);

1676: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);
1677: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1678: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1679: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1680: hr_utility.set_location('Remarks '||lc_remarks,21);
1681: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);
1682: hr_utility.set_location('ln_line_number '||ln_line_number ,23);
1683: END IF;
1684: --

Line 1681: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);

1677: hr_utility.set_location('Insured Period End Date '||ld_insured_end_date,13);
1678: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1679: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1680: hr_utility.set_location('Remarks '||lc_remarks,21);
1681: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);
1682: hr_utility.set_location('ln_line_number '||ln_line_number ,23);
1683: END IF;
1684: --
1685: pay_action_information_api.create_action_information

Line 1682: hr_utility.set_location('ln_line_number '||ln_line_number ,23);

1678: hr_utility.set_location('Pay Period Start Date '||ld_period_start_date,15);
1679: hr_utility.set_location('Pay Period End Date '||ld_period_end_date,16);
1680: hr_utility.set_location('Remarks '||lc_remarks,21);
1681: hr_utility.set_location('Exclude Period '||lc_exclude_period,22);
1682: hr_utility.set_location('ln_line_number '||ln_line_number ,23);
1683: END IF;
1684: --
1685: pay_action_information_api.create_action_information
1686: (p_action_information_id => ln_action_info_id

Line 1718: hr_utility.set_location('Leaving '||lc_procedure,1);

1714: --
1715: END IF;
1716: --
1717: IF gb_debug THEN
1718: hr_utility.set_location('Leaving '||lc_procedure,1);
1719: END IF;
1720: --
1721: EXCEPTION
1722: --

Line 1725: hr_utility.set_location('Error in '||lc_procedure,999999);

1721: EXCEPTION
1722: --
1723: WHEN gc_exception THEN
1724: IF gb_debug THEN
1725: hr_utility.set_location('Error in '||lc_procedure,999999);
1726: END IF;
1727: RAISE;
1728: WHEN OTHERS THEN
1729: RAISE gc_exception;

Line 1823: gb_debug := hr_utility.debug_enabled;

1819: lt_spb_assact_tbl t_spb_assact_tbl;
1820: --
1821: BEGIN
1822: --
1823: gb_debug := hr_utility.debug_enabled;
1824: --
1825: IF gb_debug THEN
1826: lc_procedure := gc_package||'proc_spb_arch';
1827: hr_utility.set_location('Entering '||lc_procedure,1);

Line 1827: hr_utility.set_location('Entering '||lc_procedure,1);

1823: gb_debug := hr_utility.debug_enabled;
1824: --
1825: IF gb_debug THEN
1826: lc_procedure := gc_package||'proc_spb_arch';
1827: hr_utility.set_location('Entering '||lc_procedure,1);
1828: END IF;
1829: --
1830: lt_spb_assact_tbl.delete;
1831: --

Line 1881: hr_utility.set_location('leaving '||lc_procedure,1);

1877: --
1878: END IF;
1879: --
1880: IF gb_debug THEN
1881: hr_utility.set_location('leaving '||lc_procedure,1);
1882: END IF;
1883:
1884: --
1885: END proc_spb_arch;

Line 1944: gb_debug := hr_utility.debug_enabled;

1940: lc_procedure VARCHAR2(200);
1941: --
1942: BEGIN
1943: --
1944: gb_debug := hr_utility.debug_enabled;
1945: --
1946: IF gb_debug THEN
1947: lc_procedure := gc_package||'proc_term_arch';
1948: hr_utility.set_location('Entering '||lc_procedure,1);

Line 1948: hr_utility.set_location('Entering '||lc_procedure,1);

1944: gb_debug := hr_utility.debug_enabled;
1945: --
1946: IF gb_debug THEN
1947: lc_procedure := gc_package||'proc_term_arch';
1948: hr_utility.set_location('Entering '||lc_procedure,1);
1949: END IF;
1950: --
1951: --Wage Instructions
1952: --

Line 2011: hr_utility.set_location('Leaving '||lc_procedure,1);

2007: );
2008: --
2009: IF gb_debug THEN
2010: --
2011: hr_utility.set_location('Leaving '||lc_procedure,1);
2012: --
2013: END IF;
2014: --
2015: EXCEPTION

Line 2018: hr_utility.set_location('Error in '||lc_procedure,999999);

2014: --
2015: EXCEPTION
2016: WHEN gc_exception THEN
2017: IF gb_debug THEN
2018: hr_utility.set_location('Error in '||lc_procedure,999999);
2019: END IF;
2020: RAISE;
2021: WHEN OTHERS THEN
2022: RAISE gc_exception;

Line 2059: gb_debug := hr_utility.debug_enabled;

2055: lc_procedure VARCHAR2(200);
2056:
2057: BEGIN
2058: --
2059: gb_debug := hr_utility.debug_enabled;
2060: --
2061: IF gb_debug THEN
2062: lc_procedure := gc_package||'RANGE_CODE';
2063: hr_utility.set_location('Entering '||lc_procedure,1);

Line 2063: hr_utility.set_location('Entering '||lc_procedure,1);

2059: gb_debug := hr_utility.debug_enabled;
2060: --
2061: IF gb_debug THEN
2062: lc_procedure := gc_package||'RANGE_CODE';
2063: hr_utility.set_location('Entering '||lc_procedure,1);
2064: END IF ;
2065: -------------------------------------------------------------------------
2066: -- sql string to SELECT a range of assignments eligible for archival.
2067: -------------------------------------------------------------------------

Line 2076: hr_utility.set_location('Leaving '||lc_procedure,1000);

2072: ' AND p.business_group_id = pa.business_group_id' ||
2073: ' ORDER BY p.person_id';
2074: --
2075: IF gb_debug THEN
2076: hr_utility.set_location('Leaving '||lc_procedure,1000);
2077: END IF;
2078: --
2079: IF gb_debug THEN
2080: hr_utility.set_location(lc_procedure,10);

Line 2080: hr_utility.set_location(lc_procedure,10);

2076: hr_utility.set_location('Leaving '||lc_procedure,1000);
2077: END IF;
2078: --
2079: IF gb_debug THEN
2080: hr_utility.set_location(lc_procedure,10);
2081: END IF;
2082: --
2083: END RANGE_CODE;
2084: --

Line 2173: gb_debug :=hr_utility.debug_enabled ;

2169: lc_procedure VARCHAR2(200);
2170: --
2171: BEGIN
2172: --
2173: gb_debug :=hr_utility.debug_enabled ;
2174: lc_procedure := gc_package||'initialize';
2175: --
2176: IF gb_debug THEN
2177: hr_utility.set_location('Entering '||lc_procedure,1);

Line 2177: hr_utility.set_location('Entering '||lc_procedure,1);

2173: gb_debug :=hr_utility.debug_enabled ;
2174: lc_procedure := gc_package||'initialize';
2175: --
2176: IF gb_debug THEN
2177: hr_utility.set_location('Entering '||lc_procedure,1);
2178: END IF;
2179: -------------------------------------------------------------------------
2180: -- initialization_code to set the global tables for EIT
2181: -- that will be used by each thread in multi-threading.

Line 2198: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);

2194: ,gr_parameters.effective_date;
2195: CLOSE lcr_params;
2196: --
2197: IF gb_debug THEN
2198: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
2199: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
2200: hr_utility.set_location('gr_parameters.assignment_set_id.......= ' || gr_parameters.assignment_set_id,30);
2201: hr_utility.set_location('gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from,30);
2202: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);

Line 2199: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);

2195: CLOSE lcr_params;
2196: --
2197: IF gb_debug THEN
2198: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
2199: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
2200: hr_utility.set_location('gr_parameters.assignment_set_id.......= ' || gr_parameters.assignment_set_id,30);
2201: hr_utility.set_location('gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from,30);
2202: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
2203: hr_utility.set_location('gr_parameters.labor_insorg_id..= ' || gr_parameters.labor_insorg_id,30);

Line 2200: hr_utility.set_location('gr_parameters.assignment_set_id.......= ' || gr_parameters.assignment_set_id,30);

2196: --
2197: IF gb_debug THEN
2198: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
2199: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
2200: hr_utility.set_location('gr_parameters.assignment_set_id.......= ' || gr_parameters.assignment_set_id,30);
2201: hr_utility.set_location('gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from,30);
2202: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
2203: hr_utility.set_location('gr_parameters.labor_insorg_id..= ' || gr_parameters.labor_insorg_id,30);
2204: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);

Line 2201: hr_utility.set_location('gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from,30);

2197: IF gb_debug THEN
2198: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
2199: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
2200: hr_utility.set_location('gr_parameters.assignment_set_id.......= ' || gr_parameters.assignment_set_id,30);
2201: hr_utility.set_location('gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from,30);
2202: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
2203: hr_utility.set_location('gr_parameters.labor_insorg_id..= ' || gr_parameters.labor_insorg_id,30);
2204: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
2205: END IF;

Line 2202: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);

2198: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
2199: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
2200: hr_utility.set_location('gr_parameters.assignment_set_id.......= ' || gr_parameters.assignment_set_id,30);
2201: hr_utility.set_location('gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from,30);
2202: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
2203: hr_utility.set_location('gr_parameters.labor_insorg_id..= ' || gr_parameters.labor_insorg_id,30);
2204: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
2205: END IF;
2206: --

Line 2203: hr_utility.set_location('gr_parameters.labor_insorg_id..= ' || gr_parameters.labor_insorg_id,30);

2199: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
2200: hr_utility.set_location('gr_parameters.assignment_set_id.......= ' || gr_parameters.assignment_set_id,30);
2201: hr_utility.set_location('gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from,30);
2202: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
2203: hr_utility.set_location('gr_parameters.labor_insorg_id..= ' || gr_parameters.labor_insorg_id,30);
2204: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
2205: END IF;
2206: --
2207: gn_business_group_id := gr_parameters.business_group_id ;

Line 2204: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);

2200: hr_utility.set_location('gr_parameters.assignment_set_id.......= ' || gr_parameters.assignment_set_id,30);
2201: hr_utility.set_location('gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from,30);
2202: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
2203: hr_utility.set_location('gr_parameters.labor_insorg_id..= ' || gr_parameters.labor_insorg_id,30);
2204: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
2205: END IF;
2206: --
2207: gn_business_group_id := gr_parameters.business_group_id ;
2208: gn_payroll_action_id := p_payroll_action_id;

Line 2223: hr_utility.set_location('Separation Certificate Santei Base.......= ' || gc_santei_base,30);

2219: ,gn_output_period;
2220: CLOSE lcu_ei_org_info;
2221: --
2222: IF gb_debug THEN
2223: hr_utility.set_location('Separation Certificate Santei Base.......= ' || gc_santei_base,30);
2224: hr_utility.set_location('Separation Certificate Output Period.......= ' ||gn_output_period,30);
2225: hr_utility.set_location('gn_sal_ele_set_id .........= ' ||gn_sal_ele_set_id,30);
2226: hr_utility.set_location('gn_spb_ele_set_id .........= ' ||gn_spb_ele_set_id,30);
2227: hr_utility.set_location('Leaving '||lc_procedure,1000);

Line 2224: hr_utility.set_location('Separation Certificate Output Period.......= ' ||gn_output_period,30);

2220: CLOSE lcu_ei_org_info;
2221: --
2222: IF gb_debug THEN
2223: hr_utility.set_location('Separation Certificate Santei Base.......= ' || gc_santei_base,30);
2224: hr_utility.set_location('Separation Certificate Output Period.......= ' ||gn_output_period,30);
2225: hr_utility.set_location('gn_sal_ele_set_id .........= ' ||gn_sal_ele_set_id,30);
2226: hr_utility.set_location('gn_spb_ele_set_id .........= ' ||gn_spb_ele_set_id,30);
2227: hr_utility.set_location('Leaving '||lc_procedure,1000);
2228: END IF;

Line 2225: hr_utility.set_location('gn_sal_ele_set_id .........= ' ||gn_sal_ele_set_id,30);

2221: --
2222: IF gb_debug THEN
2223: hr_utility.set_location('Separation Certificate Santei Base.......= ' || gc_santei_base,30);
2224: hr_utility.set_location('Separation Certificate Output Period.......= ' ||gn_output_period,30);
2225: hr_utility.set_location('gn_sal_ele_set_id .........= ' ||gn_sal_ele_set_id,30);
2226: hr_utility.set_location('gn_spb_ele_set_id .........= ' ||gn_spb_ele_set_id,30);
2227: hr_utility.set_location('Leaving '||lc_procedure,1000);
2228: END IF;
2229: --

Line 2226: hr_utility.set_location('gn_spb_ele_set_id .........= ' ||gn_spb_ele_set_id,30);

2222: IF gb_debug THEN
2223: hr_utility.set_location('Separation Certificate Santei Base.......= ' || gc_santei_base,30);
2224: hr_utility.set_location('Separation Certificate Output Period.......= ' ||gn_output_period,30);
2225: hr_utility.set_location('gn_sal_ele_set_id .........= ' ||gn_sal_ele_set_id,30);
2226: hr_utility.set_location('gn_spb_ele_set_id .........= ' ||gn_spb_ele_set_id,30);
2227: hr_utility.set_location('Leaving '||lc_procedure,1000);
2228: END IF;
2229: --
2230: EXCEPTION

Line 2227: hr_utility.set_location('Leaving '||lc_procedure,1000);

2223: hr_utility.set_location('Separation Certificate Santei Base.......= ' || gc_santei_base,30);
2224: hr_utility.set_location('Separation Certificate Output Period.......= ' ||gn_output_period,30);
2225: hr_utility.set_location('gn_sal_ele_set_id .........= ' ||gn_sal_ele_set_id,30);
2226: hr_utility.set_location('gn_spb_ele_set_id .........= ' ||gn_spb_ele_set_id,30);
2227: hr_utility.set_location('Leaving '||lc_procedure,1000);
2228: END IF;
2229: --
2230: EXCEPTION
2231: WHEN OTHERS THEN

Line 2232: hr_utility.set_location('Error in '||lc_procedure,999999);

2228: END IF;
2229: --
2230: EXCEPTION
2231: WHEN OTHERS THEN
2232: hr_utility.set_location('Error in '||lc_procedure,999999);
2233: RAISE;
2234: END initialize;
2235: --
2236: PROCEDURE INITIALIZATION_CODE ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE )

Line 2265: gb_debug :=hr_utility.debug_enabled ;

2261: lc_procedure VARCHAR2(200);
2262: --
2263: BEGIN
2264: --
2265: gb_debug :=hr_utility.debug_enabled ;
2266: --
2267: IF gb_debug THEN
2268: lc_procedure := gc_package||'INITIALIZATION_CODE';
2269: hr_utility.set_location('Entering '||lc_procedure,1);

Line 2269: hr_utility.set_location('Entering '||lc_procedure,1);

2265: gb_debug :=hr_utility.debug_enabled ;
2266: --
2267: IF gb_debug THEN
2268: lc_procedure := gc_package||'INITIALIZATION_CODE';
2269: hr_utility.set_location('Entering '||lc_procedure,1);
2270: END IF;
2271: -----------------------------------------------------------
2272: -- initialization_code to set the global tables for EIT
2273: -- that will be used by each thread in multi-threading.

Line 2283: hr_utility.set_location('Leaving '||lc_procedure,1000);

2279: -----------------------------------------------------------
2280: initialize(p_payroll_action_id);
2281: --
2282: IF gb_debug THEN
2283: hr_utility.set_location('Leaving '||lc_procedure,1000);
2284: END IF;
2285: --
2286: EXCEPTION
2287: WHEN OTHERS THEN

Line 2288: hr_utility.set_location('Error in '||lc_procedure,999999);

2284: END IF;
2285: --
2286: EXCEPTION
2287: WHEN OTHERS THEN
2288: hr_utility.set_location('Error in '||lc_procedure,999999);
2289: RAISE;
2290: END INITIALIZATION_CODE;
2291: --Function pay_yea_balance_result_value
2292: --

Line 2325: gb_debug := hr_utility.debug_enabled;

2321: lc_action_param_val VARCHAR2(30);
2322: --
2323: BEGIN
2324: --
2325: gb_debug := hr_utility.debug_enabled;
2326: --
2327: IF gb_debug THEN
2328: hr_utility.set_location('Entering range_person_on',10);
2329: END IF;

Line 2328: hr_utility.set_location('Entering range_person_on',10);

2324: --
2325: gb_debug := hr_utility.debug_enabled;
2326: --
2327: IF gb_debug THEN
2328: hr_utility.set_location('Entering range_person_on',10);
2329: END IF;
2330: --
2331: OPEN lcu_action_parameter;
2332: FETCH lcu_action_parameter INTO lc_action_param_val;

Line 2338: hr_utility.set_location('Range Person = True',10);

2334: --
2335: IF lc_action_param_val = 'Y' THEN
2336: lb_return := TRUE;
2337: IF gb_debug THEN
2338: hr_utility.set_location('Range Person = True',10);
2339: END IF;
2340: ELSE
2341: lb_return := FALSE;
2342: END IF;

Line 2345: hr_utility.set_location('Leaving range_person_on',10);

2341: lb_return := FALSE;
2342: END IF;
2343: --
2344: IF gb_debug THEN
2345: hr_utility.set_location('Leaving range_person_on',10);
2346: END IF;
2347: RETURN lb_return;
2348: --
2349: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2351: hr_utility.set_location('No Data Found Exception in range_person_on',10);

2347: RETURN lb_return;
2348: --
2349: EXCEPTION WHEN NO_DATA_FOUND THEN
2350: IF gb_debug THEN
2351: hr_utility.set_location('No Data Found Exception in range_person_on',10);
2352: END IF;
2353: lb_return := FALSE;
2354: RETURN lb_return;
2355: END range_person_on;

Line 2475: gb_debug := hr_utility.debug_enabled ;

2471: ln_next_assignment_action_id NUMBER;
2472: --
2473: BEGIN
2474: --
2475: gb_debug := hr_utility.debug_enabled ;
2476: --
2477: IF gb_debug THEN
2478: lc_procedure := gc_package||'assignment_action_code';
2479: hr_utility.set_location('Entering ' || lc_procedure,20);

Line 2479: hr_utility.set_location('Entering ' || lc_procedure,20);

2475: gb_debug := hr_utility.debug_enabled ;
2476: --
2477: IF gb_debug THEN
2478: lc_procedure := gc_package||'assignment_action_code';
2479: hr_utility.set_location('Entering ' || lc_procedure,20);
2480: hr_utility.set_location('Entering assignment_action_code',20);
2481: hr_utility.set_location('Person Range '||p_start_person||' - '||p_end_person,20);
2482: hr_utility.set_location('p_payroll_action_id - '||p_payroll_action_id,20);
2483: hr_utility.set_location('p_chunk - '||p_chunk,20);

Line 2480: hr_utility.set_location('Entering assignment_action_code',20);

2476: --
2477: IF gb_debug THEN
2478: lc_procedure := gc_package||'assignment_action_code';
2479: hr_utility.set_location('Entering ' || lc_procedure,20);
2480: hr_utility.set_location('Entering assignment_action_code',20);
2481: hr_utility.set_location('Person Range '||p_start_person||' - '||p_end_person,20);
2482: hr_utility.set_location('p_payroll_action_id - '||p_payroll_action_id,20);
2483: hr_utility.set_location('p_chunk - '||p_chunk,20);
2484: END IF;

Line 2481: hr_utility.set_location('Person Range '||p_start_person||' - '||p_end_person,20);

2477: IF gb_debug THEN
2478: lc_procedure := gc_package||'assignment_action_code';
2479: hr_utility.set_location('Entering ' || lc_procedure,20);
2480: hr_utility.set_location('Entering assignment_action_code',20);
2481: hr_utility.set_location('Person Range '||p_start_person||' - '||p_end_person,20);
2482: hr_utility.set_location('p_payroll_action_id - '||p_payroll_action_id,20);
2483: hr_utility.set_location('p_chunk - '||p_chunk,20);
2484: END IF;
2485: --

Line 2482: hr_utility.set_location('p_payroll_action_id - '||p_payroll_action_id,20);

2478: lc_procedure := gc_package||'assignment_action_code';
2479: hr_utility.set_location('Entering ' || lc_procedure,20);
2480: hr_utility.set_location('Entering assignment_action_code',20);
2481: hr_utility.set_location('Person Range '||p_start_person||' - '||p_end_person,20);
2482: hr_utility.set_location('p_payroll_action_id - '||p_payroll_action_id,20);
2483: hr_utility.set_location('p_chunk - '||p_chunk,20);
2484: END IF;
2485: --
2486: -- initialization_code to to set the global tables for EIT

Line 2483: hr_utility.set_location('p_chunk - '||p_chunk,20);

2479: hr_utility.set_location('Entering ' || lc_procedure,20);
2480: hr_utility.set_location('Entering assignment_action_code',20);
2481: hr_utility.set_location('Person Range '||p_start_person||' - '||p_end_person,20);
2482: hr_utility.set_location('p_payroll_action_id - '||p_payroll_action_id,20);
2483: hr_utility.set_location('p_chunk - '||p_chunk,20);
2484: END IF;
2485: --
2486: -- initialization_code to to set the global tables for EIT
2487: -- that will be used by each thread in multi-threading.

Line 2496: hr_utility.set_location('Inside Range person if condition',20);

2492:
2493: IF range_person_on THEN
2494: --
2495: IF gb_debug THEN
2496: hr_utility.set_location('Inside Range person if condition',20);
2497: END IF;
2498: -- -- Assignment Action for Current and Terminated Employees
2499: FOR lr_emp_assignment_det IN lcu_emp_assignment_det_r(gr_parameters.business_group_id
2500: ,gr_parameters.labor_insorg_id

Line 2512: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);

2508: FETCH lcu_next_action_id INTO ln_next_assignment_action_id;
2509: CLOSE lcu_next_action_id;
2510: --
2511: IF gb_debug THEN
2512: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2513: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2514: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2515: END IF;
2516: --

Line 2513: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);

2509: CLOSE lcu_next_action_id;
2510: --
2511: IF gb_debug THEN
2512: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2513: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2514: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2515: END IF;
2516: --
2517: -- Create the archive assignment actions

Line 2514: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);

2510: --
2511: IF gb_debug THEN
2512: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2513: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2514: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2515: END IF;
2516: --
2517: -- Create the archive assignment actions
2518: hr_nonrun_asact.insact(ln_next_assignment_action_id

Line 2535: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);

2531: FETCH lcu_next_action_id INTO ln_next_assignment_action_id;
2532: CLOSE lcu_next_action_id;
2533: --
2534: IF gb_debug THEN
2535: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2536: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2537: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2538: END IF;
2539: --

Line 2536: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);

2532: CLOSE lcu_next_action_id;
2533: --
2534: IF gb_debug THEN
2535: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2536: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2537: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2538: END IF;
2539: --
2540: -- Create the archive assignment actions

Line 2537: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);

2533: --
2534: IF gb_debug THEN
2535: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2536: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2537: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2538: END IF;
2539: --
2540: -- Create the archive assignment actions
2541: hr_nonrun_asact.insact(ln_next_assignment_action_id

Line 2551: hr_utility.set_location('Range person returns false',20);

2547: END IF;
2548: END LOOP; -- End loop for assignment details cursor
2549: ELSE -- Range person is not on
2550: IF gb_debug THEN
2551: hr_utility.set_location('Range person returns false',20);
2552: END IF;
2553: -- -- Assignment Action for Current and Terminated Employees
2554: FOR lr_emp_assignment_det IN lcu_emp_assignment_det(p_start_person
2555: ,p_end_person

Line 2569: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);

2565: FETCH lcu_next_action_id INTO ln_next_assignment_action_id;
2566: CLOSE lcu_next_action_id;
2567: --
2568: IF gb_debug THEN
2569: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2570: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2571: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2572: END IF;
2573: --

Line 2570: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);

2566: CLOSE lcu_next_action_id;
2567: --
2568: IF gb_debug THEN
2569: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2570: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2571: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2572: END IF;
2573: --
2574: -- Create the archive assignment actions

Line 2571: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);

2567: --
2568: IF gb_debug THEN
2569: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2570: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2571: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2572: END IF;
2573: --
2574: -- Create the archive assignment actions
2575: hr_nonrun_asact.insact(ln_next_assignment_action_id

Line 2592: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);

2588: FETCH lcu_next_action_id INTO ln_next_assignment_action_id;
2589: CLOSE lcu_next_action_id;
2590: --
2591: IF gb_debug THEN
2592: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2593: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2594: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2595: END IF;
2596: --

Line 2593: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);

2589: CLOSE lcu_next_action_id;
2590: --
2591: IF gb_debug THEN
2592: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2593: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2594: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2595: END IF;
2596: --
2597: -- Create the archive assignment actions

Line 2594: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);

2590: --
2591: IF gb_debug THEN
2592: hr_utility.set_location('p_payroll_action_id......... = '||p_payroll_action_id,20);
2593: hr_utility.set_location('l_next_assignment_action_id. = '||ln_next_assignment_action_id,20);
2594: hr_utility.set_location('lr_emp_assignment_det.assignment_id.= '||lr_emp_assignment_det.assignment_id,20);
2595: END IF;
2596: --
2597: -- Create the archive assignment actions
2598: hr_nonrun_asact.insact(ln_next_assignment_action_id

Line 2609: hr_utility.set_location('Leaving '||lc_procedure,1);

2605: END LOOP; -- End loop for assignment details cursor
2606: END IF; -- End If for range_person_on
2607: --
2608: IF gb_debug THEN
2609: hr_utility.set_location('Leaving '||lc_procedure,1);
2610: END IF;
2611: --
2612: EXCEPTION
2613: WHEN gc_exception THEN

Line 2615: hr_utility.set_location('Error in '||lc_procedure,999999);

2611: --
2612: EXCEPTION
2613: WHEN gc_exception THEN
2614: IF gb_debug THEN
2615: hr_utility.set_location('Error in '||lc_procedure,999999);
2616: END IF;
2617: RAISE;
2618: WHEN OTHERS THEN
2619: RAISE gc_exception;

Line 2705: gb_debug := hr_utility.debug_enabled ;

2701: ld_ins_start_date per_time_periods.start_date%TYPE;
2702: --
2703: BEGIN
2704: --
2705: gb_debug := hr_utility.debug_enabled ;
2706: -- initialization_code to set the global tables for EIT
2707: -- that will be used by each thread in multi-threading.
2708: --
2709: initialize(gn_payroll_action_id);

Line 2713: hr_utility.set_location('Entering '||lc_procedure,1);

2709: initialize(gn_payroll_action_id);
2710: --
2711: IF gb_debug THEN
2712: lc_procedure := gc_package||'archive_code';
2713: hr_utility.set_location('Entering '||lc_procedure,1);
2714: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
2715: hr_utility.set_location('p_effective_date............= '|| TO_CHAR(p_effective_date,'DD-MON-YYYY'),10);
2716: END IF;
2717: --

Line 2714: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);

2710: --
2711: IF gb_debug THEN
2712: lc_procedure := gc_package||'archive_code';
2713: hr_utility.set_location('Entering '||lc_procedure,1);
2714: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
2715: hr_utility.set_location('p_effective_date............= '|| TO_CHAR(p_effective_date,'DD-MON-YYYY'),10);
2716: END IF;
2717: --
2718: -- Fetch the assignment id

Line 2715: hr_utility.set_location('p_effective_date............= '|| TO_CHAR(p_effective_date,'DD-MON-YYYY'),10);

2711: IF gb_debug THEN
2712: lc_procedure := gc_package||'archive_code';
2713: hr_utility.set_location('Entering '||lc_procedure,1);
2714: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
2715: hr_utility.set_location('p_effective_date............= '|| TO_CHAR(p_effective_date,'DD-MON-YYYY'),10);
2716: END IF;
2717: --
2718: -- Fetch the assignment id
2719: OPEN lcu_get_assignment_id(p_assignment_action_id);

Line 2724: hr_utility.set_location('Opening Employee Details cursor for ARCHIVE',30);

2720: FETCH lcu_get_assignment_id INTO ln_assignment_id;
2721: CLOSE lcu_get_assignment_id;
2722: --
2723: IF gb_debug THEN
2724: hr_utility.set_location('Opening Employee Details cursor for ARCHIVE',30);
2725: hr_utility.set_location('Archiving EMPLOYEE DETAILS',30);
2726: END IF;
2727: --
2728: FOR lr_employee_details IN lcu_employee_details(p_assignment_id => ln_assignment_id

Line 2725: hr_utility.set_location('Archiving EMPLOYEE DETAILS',30);

2721: CLOSE lcu_get_assignment_id;
2722: --
2723: IF gb_debug THEN
2724: hr_utility.set_location('Opening Employee Details cursor for ARCHIVE',30);
2725: hr_utility.set_location('Archiving EMPLOYEE DETAILS',30);
2726: END IF;
2727: --
2728: FOR lr_employee_details IN lcu_employee_details(p_assignment_id => ln_assignment_id
2729: ,p_effective_date => gr_parameters.effective_date)

Line 2790: hr_utility.set_location('Leaving '||lc_procedure,1);

2786: --
2787: END LOOP; -- End LOOP for Employee Details
2788: --
2789: IF gb_debug THEN
2790: hr_utility.set_location('Leaving '||lc_procedure,1);
2791: END IF;
2792: --
2793: EXCEPTION
2794: WHEN gc_exception THEN

Line 2796: hr_utility.set_location('Error in '||lc_procedure,999999);

2792: --
2793: EXCEPTION
2794: WHEN gc_exception THEN
2795: IF gb_debug THEN
2796: hr_utility.set_location('Error in '||lc_procedure,999999);
2797: END IF;
2798: RAISE;
2799: WHEN OTHERS THEN
2800: RAISE gc_exception;

Line 2852: gb_debug := hr_utility.debug_enabled ;

2848: ln_obj_version_num pay_action_information.object_version_number%TYPE;
2849:
2850: --
2851: BEGIN
2852: gb_debug := hr_utility.debug_enabled ;
2853: --
2854: IF gb_debug THEN
2855: hr_utility.set_location('Entering: ' || lc_proc, 10);
2856: END IF;

Line 2855: hr_utility.set_location('Entering: ' || lc_proc, 10);

2851: BEGIN
2852: gb_debug := hr_utility.debug_enabled ;
2853: --
2854: IF gb_debug THEN
2855: hr_utility.set_location('Entering: ' || lc_proc, 10);
2856: END IF;
2857: --
2858: -- Office Details
2859: --

Line 2889: hr_utility.set_location('Leaving: ' || lc_proc, 10);

2885: --
2886: END LOOP;
2887: --
2888: IF gb_debug THEN
2889: hr_utility.set_location('Leaving: ' || lc_proc, 10);
2890: END IF;
2891: --
2892: END deinitialize_code;
2893: --