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

Line 103: gb_debug := hr_utility.debug_enabled;

99: lc_procedure VARCHAR2(200);
100:
101: BEGIN
102: --
103: gb_debug := hr_utility.debug_enabled;
104: --
105: IF gb_debug THEN
106: lc_procedure := gc_package||'RANGE_CODE';
107: hr_utility.set_location('Entering '||lc_procedure,1);

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

103: gb_debug := hr_utility.debug_enabled;
104: --
105: IF gb_debug THEN
106: lc_procedure := gc_package||'RANGE_CODE';
107: hr_utility.set_location('Entering '||lc_procedure,1);
108: END IF ;
109: -------------------------------------------------------------------------
110: -- Archive the payroll action level data and EIT defintions.
111: -- sql string to SELECT a range of assignments eligible for archival.

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

117: ' AND p.business_group_id = pa.business_group_id' ||
118: ' ORDER BY p.person_id';
119: --
120: IF gb_debug THEN
121: hr_utility.set_location('Leaving '||lc_procedure,1000);
122: END IF;
123: --
124: IF gb_debug THEN
125: hr_utility.set_location(lc_procedure,10);

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

121: hr_utility.set_location('Leaving '||lc_procedure,1000);
122: END IF;
123: --
124: IF gb_debug THEN
125: hr_utility.set_location(lc_procedure,10);
126: END IF;
127: --
128: END range_code;
129: --

Line 194: gb_debug :=hr_utility.debug_enabled ;

190: lc_legislative_parameters pay_payroll_actions.legislative_parameters%type;
191: --
192: BEGIN
193: --
194: gb_debug :=hr_utility.debug_enabled ;
195: lc_procedure := gc_package||'initialize';
196: --
197: IF gb_debug THEN
198: hr_utility.set_location('Entering '||lc_procedure,1);

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

194: gb_debug :=hr_utility.debug_enabled ;
195: lc_procedure := gc_package||'initialize';
196: --
197: IF gb_debug THEN
198: hr_utility.set_location('Entering '||lc_procedure,1);
199: END IF;
200: -------------------------------------------------------------------------
201: -- initialization_code to set the global tables for EIT
202: -- that will be used by each thread in multi-threading.

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

217: ,gr_parameters.rearchive_flag;
218: CLOSE lcr_params;
219: --
220: IF gb_debug THEN
221: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
222: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
223: hr_utility.set_location('gr_parameters.effective_date.......= ' || gr_parameters.effective_date,30);
224: hr_utility.set_location('gr_parameters.withholding_agent_id..........= ' ||gr_parameters.withholding_agent_id,30);
225: hr_utility.set_location('gr_parameters.payroll_id......= ' || gr_parameters.payroll_id,30);

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

218: CLOSE lcr_params;
219: --
220: IF gb_debug THEN
221: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
222: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
223: hr_utility.set_location('gr_parameters.effective_date.......= ' || gr_parameters.effective_date,30);
224: hr_utility.set_location('gr_parameters.withholding_agent_id..........= ' ||gr_parameters.withholding_agent_id,30);
225: hr_utility.set_location('gr_parameters.payroll_id......= ' || gr_parameters.payroll_id,30);
226: hr_utility.set_location('gr_parameters.gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from ,30);

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

219: --
220: IF gb_debug THEN
221: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
222: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
223: hr_utility.set_location('gr_parameters.effective_date.......= ' || gr_parameters.effective_date,30);
224: hr_utility.set_location('gr_parameters.withholding_agent_id..........= ' ||gr_parameters.withholding_agent_id,30);
225: hr_utility.set_location('gr_parameters.payroll_id......= ' || gr_parameters.payroll_id,30);
226: hr_utility.set_location('gr_parameters.gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from ,30);
227: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);

Line 224: hr_utility.set_location('gr_parameters.withholding_agent_id..........= ' ||gr_parameters.withholding_agent_id,30);

220: IF gb_debug THEN
221: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
222: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
223: hr_utility.set_location('gr_parameters.effective_date.......= ' || gr_parameters.effective_date,30);
224: hr_utility.set_location('gr_parameters.withholding_agent_id..........= ' ||gr_parameters.withholding_agent_id,30);
225: hr_utility.set_location('gr_parameters.payroll_id......= ' || gr_parameters.payroll_id,30);
226: hr_utility.set_location('gr_parameters.gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from ,30);
227: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
228: hr_utility.set_location('gr_parameters.assignment_set_id .....= ' || gr_parameters.assignment_set_id ,30);

Line 225: hr_utility.set_location('gr_parameters.payroll_id......= ' || gr_parameters.payroll_id,30);

221: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
222: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
223: hr_utility.set_location('gr_parameters.effective_date.......= ' || gr_parameters.effective_date,30);
224: hr_utility.set_location('gr_parameters.withholding_agent_id..........= ' ||gr_parameters.withholding_agent_id,30);
225: hr_utility.set_location('gr_parameters.payroll_id......= ' || gr_parameters.payroll_id,30);
226: hr_utility.set_location('gr_parameters.gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from ,30);
227: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
228: hr_utility.set_location('gr_parameters.assignment_set_id .....= ' || gr_parameters.assignment_set_id ,30);
229: hr_utility.set_location('gr_parameters.rearchive_flag.......= ' || gr_parameters.rearchive_flag,30);

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

222: hr_utility.set_location('gr_parameters.business_group_id.......= ' || gr_parameters.business_group_id,30);
223: hr_utility.set_location('gr_parameters.effective_date.......= ' || gr_parameters.effective_date,30);
224: hr_utility.set_location('gr_parameters.withholding_agent_id..........= ' ||gr_parameters.withholding_agent_id,30);
225: hr_utility.set_location('gr_parameters.payroll_id......= ' || gr_parameters.payroll_id,30);
226: hr_utility.set_location('gr_parameters.gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from ,30);
227: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
228: hr_utility.set_location('gr_parameters.assignment_set_id .....= ' || gr_parameters.assignment_set_id ,30);
229: hr_utility.set_location('gr_parameters.rearchive_flag.......= ' || gr_parameters.rearchive_flag,30);
230: END IF;

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

223: hr_utility.set_location('gr_parameters.effective_date.......= ' || gr_parameters.effective_date,30);
224: hr_utility.set_location('gr_parameters.withholding_agent_id..........= ' ||gr_parameters.withholding_agent_id,30);
225: hr_utility.set_location('gr_parameters.payroll_id......= ' || gr_parameters.payroll_id,30);
226: hr_utility.set_location('gr_parameters.gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from ,30);
227: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
228: hr_utility.set_location('gr_parameters.assignment_set_id .....= ' || gr_parameters.assignment_set_id ,30);
229: hr_utility.set_location('gr_parameters.rearchive_flag.......= ' || gr_parameters.rearchive_flag,30);
230: END IF;
231: --

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

224: hr_utility.set_location('gr_parameters.withholding_agent_id..........= ' ||gr_parameters.withholding_agent_id,30);
225: hr_utility.set_location('gr_parameters.payroll_id......= ' || gr_parameters.payroll_id,30);
226: hr_utility.set_location('gr_parameters.gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from ,30);
227: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
228: hr_utility.set_location('gr_parameters.assignment_set_id .....= ' || gr_parameters.assignment_set_id ,30);
229: hr_utility.set_location('gr_parameters.rearchive_flag.......= ' || gr_parameters.rearchive_flag,30);
230: END IF;
231: --
232: gd_ystart_date := TRUNC(gr_parameters.effective_date, 'YYYY');

Line 229: hr_utility.set_location('gr_parameters.rearchive_flag.......= ' || gr_parameters.rearchive_flag,30);

225: hr_utility.set_location('gr_parameters.payroll_id......= ' || gr_parameters.payroll_id,30);
226: hr_utility.set_location('gr_parameters.gr_parameters.termination_date_from...= ' || gr_parameters.termination_date_from ,30);
227: hr_utility.set_location('gr_parameters.termination_date_to.....= ' || gr_parameters.termination_date_to,30);
228: hr_utility.set_location('gr_parameters.assignment_set_id .....= ' || gr_parameters.assignment_set_id ,30);
229: hr_utility.set_location('gr_parameters.rearchive_flag.......= ' || gr_parameters.rearchive_flag,30);
230: END IF;
231: --
232: gd_ystart_date := TRUNC(gr_parameters.effective_date, 'YYYY');
233: gd_yend_date := ADD_MONTHS(gd_ystart_date, 12) - 1;

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

237: -- Fetch the Organization information into global type
238: -------------------------------------------------------------------------
239: --
240: IF gb_debug THEN
241: hr_utility.set_location('Leaving '||lc_procedure,1000);
242: END IF;
243: --
244: EXCEPTION
245: WHEN OTHERS THEN

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

242: END IF;
243: --
244: EXCEPTION
245: WHEN OTHERS THEN
246: hr_utility.set_location('Error in '||lc_procedure,999999);
247: RAISE;
248: END initialize;
249: --
250: PROCEDURE initialization_code ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE )

Line 279: gb_debug :=hr_utility.debug_enabled ;

275: lc_procedure VARCHAR2(200);
276: --
277: BEGIN
278: --
279: gb_debug :=hr_utility.debug_enabled ;
280: --
281: IF gb_debug THEN
282: lc_procedure := gc_package||'INITIALIZATION_CODE';
283: hr_utility.set_location('Entering '||lc_procedure,1);

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

279: gb_debug :=hr_utility.debug_enabled ;
280: --
281: IF gb_debug THEN
282: lc_procedure := gc_package||'INITIALIZATION_CODE';
283: hr_utility.set_location('Entering '||lc_procedure,1);
284: END IF;
285: -----------------------------------------------------------
286: -- initialization_code to set the global tables for EIT
287: -- that will be used by each thread in multi-threading.

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

293: -----------------------------------------------------------
294: initialize(p_payroll_action_id);
295: --
296: IF gb_debug THEN
297: hr_utility.set_location('Leaving '||lc_procedure,1000);
298: END IF;
299: --
300: EXCEPTION
301: WHEN OTHERS THEN

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

298: END IF;
299: --
300: EXCEPTION
301: WHEN OTHERS THEN
302: hr_utility.set_location('Error in '||lc_procedure,999999);
303: RAISE;
304: END initialization_code;
305: --
306:

Line 347: gb_debug :=hr_utility.debug_enabled ;

343: lc_meaning hr_lookups.meaning%TYPE;
344: --
345: BEGIN
346: --
347: gb_debug :=hr_utility.debug_enabled ;
348: --
349: IF gb_debug THEN
350: lc_procedure := gc_package||'proc_lookup_meaning';
351: hr_utility.set_location('Entering '||lc_procedure,1);

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

347: gb_debug :=hr_utility.debug_enabled ;
348: --
349: IF gb_debug THEN
350: lc_procedure := gc_package||'proc_lookup_meaning';
351: hr_utility.set_location('Entering '||lc_procedure,1);
352: END IF;
353: -----------------------------------------------------------
354: -- Fetch the parameters passed by user into global variable
355: -- initialize procedure

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

363: --
364: RETURN lc_meaning;
365: --
366: IF gb_debug THEN
367: hr_utility.set_location('Leaving '||lc_procedure,1000);
368: END IF;
369: --
370: EXCEPTION
371: WHEN OTHERS THEN

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

368: END IF;
369: --
370: EXCEPTION
371: WHEN OTHERS THEN
372: hr_utility.set_location('Error in '||lc_procedure,999999);
373: RAISE;
374: RETURN NULL;
375: END proc_lookup_meaning;
376: --

Line 403: gb_debug := hr_utility.debug_enabled;

399: ln_with_hold_agent NUMBER;
400: --
401: BEGIN
402: --
403: gb_debug := hr_utility.debug_enabled;
404: --
405: IF gb_debug THEN
406: lc_procedure := gc_package||'get_with_holding_id';
407: hr_utility.set_location('Entering '||lc_procedure,1);

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

403: gb_debug := hr_utility.debug_enabled;
404: --
405: IF gb_debug THEN
406: lc_procedure := gc_package||'get_with_holding_id';
407: hr_utility.set_location('Entering '||lc_procedure,1);
408: END IF;
409: --
410: ln_with_hold_agent := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_ITX_INFO'
411: ,p_input_value_name => 'WITHHOLD_AGENT'

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

414: );
415:
416: --
417: IF gb_debug THEN
418: hr_utility.set_location('Leaving '||lc_procedure,1000);
419: END IF;
420: --
421: RETURN ln_with_hold_agent;
422: --

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

422: --
423: EXCEPTION
424: WHEN NO_DATA_FOUND THEN
425: IF gb_debug THEN
426: hr_utility.set_location('No Data Found Exception in ln_with_hold_agent',10);
427: END IF;
428: RETURN NULL;
429: --
430: WHEN OTHERS THEN

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

427: END IF;
428: RETURN NULL;
429: --
430: WHEN OTHERS THEN
431: hr_utility.set_location('Error in '||lc_procedure,999999);
432: RAISE;
433: RETURN NULL;
434: END get_with_hold_agent;
435: --

Line 480: gb_debug :=hr_utility.debug_enabled ;

476: lc_procedure VARCHAR2(200);
477: --
478: BEGIN
479: --
480: gb_debug :=hr_utility.debug_enabled ;
481: --
482: IF gb_debug THEN
483: lc_procedure := gc_package||'delete_assact';
484: hr_utility.set_location('Entering '||lc_procedure,1);

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

480: gb_debug :=hr_utility.debug_enabled ;
481: --
482: IF gb_debug THEN
483: lc_procedure := gc_package||'delete_assact';
484: hr_utility.set_location('Entering '||lc_procedure,1);
485: END IF;
486: -----------------------------------------------------------
487: -- Fetch the parameters passed by user into global variable
488: -- initialize procedure

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

496: ,p_object_version_number => lr_emp_assignment_det.object_version_number);
497: END LOOP;
498: --
499: IF gb_debug THEN
500: hr_utility.set_location('Leaving '||lc_procedure,1000);
501: END IF;
502: --
503: EXCEPTION
504: WHEN OTHERS THEN

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

501: END IF;
502: --
503: EXCEPTION
504: WHEN OTHERS THEN
505: hr_utility.set_location('Error in '||lc_procedure,999999);
506: RAISE;
507: END delete_assact;
508: --
509: FUNCTION range_person_on

Line 541: gb_debug := hr_utility.debug_enabled;

537: lc_action_param_val VARCHAR2(30);
538: --
539: BEGIN
540: --
541: gb_debug := hr_utility.debug_enabled;
542: --
543: IF gb_debug THEN
544: hr_utility.set_location('Entering range_person_on',10);
545: END IF;

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

540: --
541: gb_debug := hr_utility.debug_enabled;
542: --
543: IF gb_debug THEN
544: hr_utility.set_location('Entering range_person_on',10);
545: END IF;
546: --
547: OPEN lcu_action_parameter;
548: FETCH lcu_action_parameter INTO lc_action_param_val;

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

550: --
551: IF lc_action_param_val = 'Y' THEN
552: lb_return := TRUE;
553: IF gb_debug THEN
554: hr_utility.set_location('Range Person = True',10);
555: END IF;
556: ELSE
557: lb_return := FALSE;
558: END IF;

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

557: lb_return := FALSE;
558: END IF;
559: --
560: IF gb_debug THEN
561: hr_utility.set_location('Leaving range_person_on',10);
562: END IF;
563: RETURN lb_return;
564: --
565: EXCEPTION WHEN NO_DATA_FOUND THEN

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

563: RETURN lb_return;
564: --
565: EXCEPTION WHEN NO_DATA_FOUND THEN
566: IF gb_debug THEN
567: hr_utility.set_location('No Data Found Exception in range_person_on',10);
568: END IF;
569: lb_return := FALSE;
570: RETURN lb_return;
571: END range_person_on;

Line 746: gb_debug := hr_utility.debug_enabled ;

742: ld_termination_date_to DATE;
743: --
744: BEGIN
745: --
746: gb_debug := hr_utility.debug_enabled ;
747: --
748: IF gb_debug THEN
749: lc_procedure := gc_package||'assignment_action_code';
750: hr_utility.set_location('Entering ' || lc_procedure,1);

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

746: gb_debug := hr_utility.debug_enabled ;
747: --
748: IF gb_debug THEN
749: lc_procedure := gc_package||'assignment_action_code';
750: hr_utility.set_location('Entering ' || lc_procedure,1);
751: hr_utility.set_location('Person Range '||p_start_person||' - '||p_end_person,1);
752: END IF;
753: --
754: -- initialization_code to set the global tables for EIT

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

747: --
748: IF gb_debug THEN
749: lc_procedure := gc_package||'assignment_action_code';
750: hr_utility.set_location('Entering ' || lc_procedure,1);
751: hr_utility.set_location('Person Range '||p_start_person||' - '||p_end_person,1);
752: END IF;
753: --
754: -- initialization_code to set the global tables for EIT
755: -- that will be used by each thread in multi-threading.

Line 765: hr_utility.set_location('before range person1 on loop',20);

761: --
762: IF range_person_on THEN
763: --
764: IF gb_debug THEN
765: hr_utility.set_location('before range person1 on loop',20);
766: END IF;
767: --
768: FOR lr_emp_assignment_det_r in lcu_emp_assignment_det_r(p_payroll_action_id
769: ,gr_parameters.business_group_id

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

779: FETCH lcu_next_action_id INTO ln_next_assignment_action_id;
780: CLOSE lcu_next_action_id;
781: --
782: IF gb_debug THEN
783: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
784: hr_utility.set_location('l_next_assignment_action_id..= '||ln_next_assignment_action_id,20);
785: hr_utility.set_location('lr_emp_assignment_det_r.assignment_id...= '||lr_emp_assignment_det_r.assignment_id,20);
786: END IF;
787: --

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

780: CLOSE lcu_next_action_id;
781: --
782: IF gb_debug THEN
783: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
784: hr_utility.set_location('l_next_assignment_action_id..= '||ln_next_assignment_action_id,20);
785: hr_utility.set_location('lr_emp_assignment_det_r.assignment_id...= '||lr_emp_assignment_det_r.assignment_id,20);
786: END IF;
787: --
788: -- Create the archive assignment actions

Line 785: hr_utility.set_location('lr_emp_assignment_det_r.assignment_id...= '||lr_emp_assignment_det_r.assignment_id,20);

781: --
782: IF gb_debug THEN
783: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
784: hr_utility.set_location('l_next_assignment_action_id..= '||ln_next_assignment_action_id,20);
785: hr_utility.set_location('lr_emp_assignment_det_r.assignment_id...= '||lr_emp_assignment_det_r.assignment_id,20);
786: END IF;
787: --
788: -- Create the archive assignment actions
789: --

Line 807: hr_utility.set_location('lc_include_flag after check.= '||lc_include_flag ,20);

803: ,p_populate_fs_flag => 'Y' -- #Bug No 9508028
804: );
805:
806: IF gb_debug THEN
807: hr_utility.set_location('lc_include_flag after check.= '||lc_include_flag ,20);
808: END IF;
809: --
810: IF lc_include_flag = 'Y' THEN
811: --

Line 833: hr_utility.set_location('range_person_on_loop2',302);

829: --
830: ELSE
831: --
832: IF gb_debug THEN
833: hr_utility.set_location('range_person_on_loop2',302);
834: END IF;
835: --
836: FOR lr_emp_assignment_det in lcu_emp_assignment_det(p_payroll_action_id
837: ,p_start_person

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

849: FETCH lcu_next_action_id INTO ln_next_assignment_action_id;
850: CLOSE lcu_next_action_id;
851: --
852: IF gb_debug THEN
853: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
854: hr_utility.set_location('l_next_assignment_action_id.= '||ln_next_assignment_action_id,20);
855: hr_utility.set_location('lr_emp_assignment_det.assignment_id.......= '||lr_emp_assignment_det.assignment_id,20);
856: END IF;
857: --

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

850: CLOSE lcu_next_action_id;
851: --
852: IF gb_debug THEN
853: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
854: hr_utility.set_location('l_next_assignment_action_id.= '||ln_next_assignment_action_id,20);
855: hr_utility.set_location('lr_emp_assignment_det.assignment_id.......= '||lr_emp_assignment_det.assignment_id,20);
856: END IF;
857: --
858: -- Create the archive assignment actions

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

851: --
852: IF gb_debug THEN
853: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
854: hr_utility.set_location('l_next_assignment_action_id.= '||ln_next_assignment_action_id,20);
855: hr_utility.set_location('lr_emp_assignment_det.assignment_id.......= '||lr_emp_assignment_det.assignment_id,20);
856: END IF;
857: --
858: -- Create the archive assignment actions
859: --

Line 877: hr_utility.set_location('lc_include_flag after check.= '||lc_include_flag ,20);

873: ,p_effective_date => NVL(lr_emp_assignment_det.actual_termination_date,gr_parameters.effective_date) -- #Bug No 9508028
874: ,p_populate_fs_flag => 'Y' -- #Bug No 9508028
875: );
876: IF gb_debug THEN
877: hr_utility.set_location('lc_include_flag after check.= '||lc_include_flag ,20);
878: END IF;
879: --
880: IF lc_include_flag = 'Y' THEN
881:

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

902: END IF;
903: --
904: EXCEPTION
905: WHEN OTHERS THEN
906: hr_utility.set_location('Error in '||lc_procedure,999999);
907: RAISE;
908: END assignment_action_code;
909: --
910: PROCEDURE archive_code ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type

Line 1185: gb_debug := hr_utility.debug_enabled ;

1181:
1182: --
1183: BEGIN
1184: --
1185: gb_debug := hr_utility.debug_enabled ;
1186: --
1187: IF gb_debug THEN
1188: --
1189: lc_procedure := gc_package||'ARCHIVE_CODE';

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

1186: --
1187: IF gb_debug THEN
1188: --
1189: lc_procedure := gc_package||'ARCHIVE_CODE';
1190: hr_utility.set_location('Entering ' || lc_procedure,1);
1191: --
1192: END IF;
1193: --
1194: -- Fetch the Assignemnt Id

Line 1303: hr_utility.set_location('Date Earned = ' || ld_date_earned,10);

1299: -- Fetching Term_ Withholding Tax Report Infromation
1300: --
1301: IF gb_debug THEN
1302: --
1303: hr_utility.set_location('Date Earned = ' || ld_date_earned,10);
1304: --
1305: END IF;
1306: --
1307: lc_descfield := pay_jp_balance_pkg.get_entry_value_char('TRM_WITHHOLD_TAX_REPORT_INFO','DESC_FIELD',lr_emp_rec.assignment_id,ld_date_earned); --Bug 9509191

Line 1470: hr_utility.set_location('Leaving ' || lc_procedure,10);

1466: END IF;
1467: --
1468: IF gb_debug THEN
1469: --
1470: hr_utility.set_location('Leaving ' || lc_procedure,10);
1471: --
1472: END IF;
1473: --
1474: EXCEPTION

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

1473: --
1474: EXCEPTION
1475: WHEN OTHERS THEN
1476: --
1477: hr_utility.set_location('Error in '||lc_procedure,999999);
1478: RAISE;
1479: END archive_code;
1480: --
1481: PROCEDURE deinitialize_code(p_payroll_action_id IN NUMBER)

Line 1524: gb_debug := hr_utility.debug_enabled ;

1520: lc_proc CONSTANT VARCHAR2(61) := gc_package || 'deinitialise_code';
1521: --
1522: BEGIN
1523: --
1524: gb_debug := hr_utility.debug_enabled ;
1525: --
1526: IF gb_debug THEN
1527: hr_utility.set_location('Entering: ' || lc_proc, 10);
1528: END IF;

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

1523: --
1524: gb_debug := hr_utility.debug_enabled ;
1525: --
1526: IF gb_debug THEN
1527: hr_utility.set_location('Entering: ' || lc_proc, 10);
1528: END IF;
1529: --
1530: FOR l_rec IN lcu_assacts LOOP
1531: py_rollback_pkg.rollback_ass_action(l_rec.assignment_action_id);

Line 1536: hr_utility.set_location('Leaving ' || lc_proc,20);

1532: END LOOP;
1533: --
1534: IF gb_debug THEN
1535: --
1536: hr_utility.set_location('Leaving ' || lc_proc,20);
1537: --
1538: END IF;
1539: --
1540: END deinitialize_code;