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

Line 102: gb_debug := hr_utility.debug_enabled;

98: IS
99: lc_text VARCHAR2(4000);
100: BEGIN
101: --
102: gb_debug := hr_utility.debug_enabled;
103: IF gb_debug THEN
104: hr_utility.set_location ('Entering CNV_STR',10);
105: END IF;
106: --

Line 104: hr_utility.set_location ('Entering CNV_STR',10);

100: BEGIN
101: --
102: gb_debug := hr_utility.debug_enabled;
103: IF gb_debug THEN
104: hr_utility.set_location ('Entering CNV_STR',10);
105: END IF;
106: --
107: lc_text := LTRIM(RTRIM(REPLACE(p_text,TO_MULTI_BYTE(' '),' ')));
108: --

Line 115: hr_utility.set_location ('Leaving CNV_STR',10);

111: lc_text := SUBSTR(lc_text,p_start,p_end);
112: END IF;
113: --
114: IF gb_debug THEN
115: hr_utility.set_location ('Leaving CNV_STR',10);
116: END IF;
117: --
118: RETURN lc_text;
119: --

Line 151: gb_debug := hr_utility.debug_enabled;

147: IS
148: lc_htmlspchar VARCHAR2(1) := 'N';
149: BEGIN
150: --
151: gb_debug := hr_utility.debug_enabled;
152: IF gb_debug THEN
153: hr_utility.set_location ('Entering htmlspchar',20);
154: END IF;
155: --

Line 153: hr_utility.set_location ('Entering htmlspchar',20);

149: BEGIN
150: --
151: gb_debug := hr_utility.debug_enabled;
152: IF gb_debug THEN
153: hr_utility.set_location ('Entering htmlspchar',20);
154: END IF;
155: --
156: IF NVL(INSTR(p_text,'<'),0) > 0 THEN
157: lc_htmlspchar := 'Y';

Line 187: hr_utility.set_location ('Leaving htmlspchar',20);

183: RETURN p_text;
184: END IF;
185: --
186: IF gb_debug THEN
187: hr_utility.set_location ('Leaving htmlspchar',20);
188: END IF;
189: --
190: END htmlspchar;
191: --

Line 222: gb_debug := hr_utility.debug_enabled;

218: lc_buf VARCHAR2(255);
219: --
220: BEGIN
221: --
222: gb_debug := hr_utility.debug_enabled;
223: IF gb_debug THEN
224: hr_utility.set_location ('Entering print_clob',30);
225: END IF;
226: --

Line 224: hr_utility.set_location ('Entering print_clob',30);

220: BEGIN
221: --
222: gb_debug := hr_utility.debug_enabled;
223: IF gb_debug THEN
224: hr_utility.set_location ('Entering print_clob',30);
225: END IF;
226: --
227: ln_chars := 240;
228: ln_offset := 1;

Line 237: hr_utility.set_location(lc_buf,20);

233: , ln_offset
234: , lc_buf
235: );
236: IF gb_debug THEN
237: hr_utility.set_location(lc_buf,20);
238: END IF;
239: ln_offset := ln_offset + ln_chars;
240: END LOOP;
241: --

Line 243: hr_utility.set_location ('Leaving print_clob',30);

239: ln_offset := ln_offset + ln_chars;
240: END LOOP;
241: --
242: IF gb_debug THEN
243: hr_utility.set_location ('Leaving print_clob',30);
244: END IF;
245: --
246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN

Line 249: hr_utility.set_location ('No Data Found in Print Clob',999999);

245: --
246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN
248: IF gb_debug THEN
249: hr_utility.set_location ('No Data Found in Print Clob',999999);
250: END IF;
251: END print_clob;
252: --
253: FUNCTION get_previous_job_history( p_mag_asg_action_id IN NUMBER)

Line 300: hr_utility.set_location('step1.... ',20);

296: lt_job_id(ln_index).assignment_id := lr_job_history.assignment_id;
297: lt_job_id(ln_index).start_date := lr_job_history.start_date;
298: lt_job_id(ln_index).end_date := lr_job_history.end_date;
299: lt_job_id(ln_index).company_name := lr_job_history.company_name;
300: hr_utility.set_location('step1.... ',20);
301: --
302: IF gb_debug THEN
303: hr_utility.set_location('p_mag_asg_action_id '||p_mag_asg_action_id,40);
304: hr_utility.set_location('p_prev_assignment_id '||lr_job_history.assignment_id,40);

Line 303: hr_utility.set_location('p_mag_asg_action_id '||p_mag_asg_action_id,40);

299: lt_job_id(ln_index).company_name := lr_job_history.company_name;
300: hr_utility.set_location('step1.... ',20);
301: --
302: IF gb_debug THEN
303: hr_utility.set_location('p_mag_asg_action_id '||p_mag_asg_action_id,40);
304: hr_utility.set_location('p_prev_assignment_id '||lr_job_history.assignment_id,40);
305: END IF;
306:
307: END LOOP;

Line 304: hr_utility.set_location('p_prev_assignment_id '||lr_job_history.assignment_id,40);

300: hr_utility.set_location('step1.... ',20);
301: --
302: IF gb_debug THEN
303: hr_utility.set_location('p_mag_asg_action_id '||p_mag_asg_action_id,40);
304: hr_utility.set_location('p_prev_assignment_id '||lr_job_history.assignment_id,40);
305: END IF;
306:
307: END LOOP;
308: --

Line 309: hr_utility.set_location(ln_index,20);

305: END IF;
306:
307: END LOOP;
308: --
309: hr_utility.set_location(ln_index,20);
310: IF ln_index=1 THEN
311: lt_res_tb(1).assignment_id :=lt_job_id(1).assignment_id;
312: lt_res_tb(1).start_date :=lt_job_id(1).start_date;
313: lt_res_tb(1).end_date :=lt_job_id(1).end_date;

Line 315: hr_utility.set_location('step2.... ',20);

311: lt_res_tb(1).assignment_id :=lt_job_id(1).assignment_id;
312: lt_res_tb(1).start_date :=lt_job_id(1).start_date;
313: lt_res_tb(1).end_date :=lt_job_id(1).end_date;
314: lt_res_tb(1).company_name :=lt_job_id(1).company_name;
315: hr_utility.set_location('step2.... ',20);
316: ELSE
317: FOR i in 1..ln_index
318: LOOP
319: IF i

Line 330: hr_utility.set_location('step3.... ',20);

326: lt_res_tb(i).start_date :=ld_start_date;
327: lt_res_tb(i).end_date :=lt_job_id(i).end_date;
328: lt_res_tb(i).company_name :=lt_job_id(i).company_name;
329: ln_count:=0;
330: hr_utility.set_location('step3.... ',20);
331: ELSE
332: lt_res_tb(i).assignment_id :=lt_job_id(i).assignment_id;
333: lt_res_tb(i).start_date :=lt_job_id(i).start_date;
334: lt_res_tb(i).end_date :=lt_job_id(i).end_date;

Line 336: hr_utility.set_location('step4.... ',20);

332: lt_res_tb(i).assignment_id :=lt_job_id(i).assignment_id;
333: lt_res_tb(i).start_date :=lt_job_id(i).start_date;
334: lt_res_tb(i).end_date :=lt_job_id(i).end_date;
335: lt_res_tb(i).company_name :=lt_job_id(i).company_name;
336: hr_utility.set_location('step4.... ',20);
337: END IF;
338: ELSE
339: IF ln_count=0 THEN
340: ld_start_date:=lt_job_id(i).start_date;

Line 341: hr_utility.set_location(' ld_start_date'||ld_start_date,20);

337: END IF;
338: ELSE
339: IF ln_count=0 THEN
340: ld_start_date:=lt_job_id(i).start_date;
341: hr_utility.set_location(' ld_start_date'||ld_start_date,20);
342: ln_count:=1;
343: END IF;
344: END IF;
345: ELSE

Line 355: hr_utility.set_location('step5.... ',20);

351: lt_res_tb(i).assignment_id :=lt_job_id(i).assignment_id;
352: lt_res_tb(i).start_date :=ld_start_date;
353: lt_res_tb(i).end_date :=lt_job_id(i).end_date;
354: lt_res_tb(i).company_name :=lt_job_id(i).company_name;
355: hr_utility.set_location('step5.... ',20);
356: ELSE
357: lt_res_tb(i).assignment_id:=lt_job_id(i).assignment_id;
358: lt_res_tb(i).start_date:=lt_job_id(i).start_date;
359: lt_res_tb(i).end_date:=lt_job_id(i).end_date;

Line 361: hr_utility.set_location('step6.... ',20);

357: lt_res_tb(i).assignment_id:=lt_job_id(i).assignment_id;
358: lt_res_tb(i).start_date:=lt_job_id(i).start_date;
359: lt_res_tb(i).end_date:=lt_job_id(i).end_date;
360: lt_res_tb(i).company_name:=lt_job_id(i).company_name;
361: hr_utility.set_location('step6.... ',20);
362: END IF;
363: END IF;
364: ELSE
365: IF (lt_job_id(i).assignment_id = lt_job_id(i-1).assignment_id)

Line 372: hr_utility.set_location('step7.... ',20);

368: lt_res_tb(i).assignment_id:=lt_job_id(i).assignment_id;
369: lt_res_tb(i).start_date:=ld_start_date;
370: lt_res_tb(i).end_date:=lt_job_id(i).end_date;
371: lt_res_tb(i).company_name:=lt_job_id(i).company_name;
372: hr_utility.set_location('step7.... ',20);
373: ELSE
374: lt_res_tb(i).assignment_id:=lt_job_id(i).assignment_id;
375: lt_res_tb(i).start_date:=lt_job_id(i).start_date;
376: lt_res_tb(i).end_date:=lt_job_id(i).end_date;

Line 378: hr_utility.set_location('step8.... ',20);

374: lt_res_tb(i).assignment_id:=lt_job_id(i).assignment_id;
375: lt_res_tb(i).start_date:=lt_job_id(i).start_date;
376: lt_res_tb(i).end_date:=lt_job_id(i).end_date;
377: lt_res_tb(i).company_name:=lt_job_id(i).company_name;
378: hr_utility.set_location('step8.... ',20);
379: END IF;
380: END IF;
381: END IF;
382: END LOOP;

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

384: RETURN lt_res_tb;
385: EXCEPTION
386: WHEN NO_DATA_FOUND THEN
387: IF gb_debug THEN
388: hr_utility.set_location('No Data Found Exception in get_job_history',10);
389: END IF;
390: RETURN lt_res_tb;
391: END get_previous_job_history;
392: --

Line 442: gb_debug := hr_utility.debug_enabled;

438: lc_procedure VARCHAR2(200);
439: --
440: BEGIN
441: --
442: gb_debug := hr_utility.debug_enabled;
443: IF gb_debug THEN
444: lc_procedure := gc_pkg_name||'initialize';
445: hr_utility.set_location('Entering '||lc_procedure,40);
446: END IF;

Line 445: hr_utility.set_location('Entering '||lc_procedure,40);

441: --
442: gb_debug := hr_utility.debug_enabled;
443: IF gb_debug THEN
444: lc_procedure := gc_pkg_name||'initialize';
445: hr_utility.set_location('Entering '||lc_procedure,40);
446: END IF;
447: --
448: -- Fetch the parameters passed by user into global variable.
449: OPEN lcr_params(p_payroll_action_id);

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

456: WHERE PPA.payroll_action_id = gr_parameters.payroll_action_id;
457:
458: --
459: IF gb_debug THEN
460: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
461: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
462: hr_utility.set_location('gr_parameters.assignment_set_id = ' || gr_parameters.assignment_set_id,30);
463: hr_utility.set_location('gr_parameters.organization_id...... = ' || gr_parameters.organization_id,30);
464: hr_utility.set_location('gr_parameters.business_group_id.... = ' || gr_parameters.business_group_id,30);

Line 461: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);

457:
458: --
459: IF gb_debug THEN
460: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
461: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
462: hr_utility.set_location('gr_parameters.assignment_set_id = ' || gr_parameters.assignment_set_id,30);
463: hr_utility.set_location('gr_parameters.organization_id...... = ' || gr_parameters.organization_id,30);
464: hr_utility.set_location('gr_parameters.business_group_id.... = ' || gr_parameters.business_group_id,30);
465: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);

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

458: --
459: IF gb_debug THEN
460: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
461: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
462: hr_utility.set_location('gr_parameters.assignment_set_id = ' || gr_parameters.assignment_set_id,30);
463: hr_utility.set_location('gr_parameters.organization_id...... = ' || gr_parameters.organization_id,30);
464: hr_utility.set_location('gr_parameters.business_group_id.... = ' || gr_parameters.business_group_id,30);
465: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
466: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);

Line 463: hr_utility.set_location('gr_parameters.organization_id...... = ' || gr_parameters.organization_id,30);

459: IF gb_debug THEN
460: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
461: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
462: hr_utility.set_location('gr_parameters.assignment_set_id = ' || gr_parameters.assignment_set_id,30);
463: hr_utility.set_location('gr_parameters.organization_id...... = ' || gr_parameters.organization_id,30);
464: hr_utility.set_location('gr_parameters.business_group_id.... = ' || gr_parameters.business_group_id,30);
465: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
466: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
467: hr_utility.set_location('gr_parameters.include_org_hierarchy = ' || gr_parameters.include_org_hierarchy,30);

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

460: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
461: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
462: hr_utility.set_location('gr_parameters.assignment_set_id = ' || gr_parameters.assignment_set_id,30);
463: hr_utility.set_location('gr_parameters.organization_id...... = ' || gr_parameters.organization_id,30);
464: hr_utility.set_location('gr_parameters.business_group_id.... = ' || gr_parameters.business_group_id,30);
465: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
466: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
467: hr_utility.set_location('gr_parameters.include_org_hierarchy = ' || gr_parameters.include_org_hierarchy,30);
468: hr_utility.set_location('gr_parameters.incl_term_emp... ... = ' || gr_parameters.incl_term_emp,30);

Line 465: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);

461: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
462: hr_utility.set_location('gr_parameters.assignment_set_id = ' || gr_parameters.assignment_set_id,30);
463: hr_utility.set_location('gr_parameters.organization_id...... = ' || gr_parameters.organization_id,30);
464: hr_utility.set_location('gr_parameters.business_group_id.... = ' || gr_parameters.business_group_id,30);
465: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
466: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
467: hr_utility.set_location('gr_parameters.include_org_hierarchy = ' || gr_parameters.include_org_hierarchy,30);
468: hr_utility.set_location('gr_parameters.incl_term_emp... ... = ' || gr_parameters.incl_term_emp,30);
469: hr_utility.set_location('gr_parameters.term_eff_date_from... = ' || gr_parameters.term_date_from,30);

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

462: hr_utility.set_location('gr_parameters.assignment_set_id = ' || gr_parameters.assignment_set_id,30);
463: hr_utility.set_location('gr_parameters.organization_id...... = ' || gr_parameters.organization_id,30);
464: hr_utility.set_location('gr_parameters.business_group_id.... = ' || gr_parameters.business_group_id,30);
465: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
466: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
467: hr_utility.set_location('gr_parameters.include_org_hierarchy = ' || gr_parameters.include_org_hierarchy,30);
468: hr_utility.set_location('gr_parameters.incl_term_emp... ... = ' || gr_parameters.incl_term_emp,30);
469: hr_utility.set_location('gr_parameters.term_eff_date_from... = ' || gr_parameters.term_date_from,30);
470: hr_utility.set_location('gr_parameters.term_eff_date_to..... = ' || gr_parameters.term_date_to,30);

Line 467: hr_utility.set_location('gr_parameters.include_org_hierarchy = ' || gr_parameters.include_org_hierarchy,30);

463: hr_utility.set_location('gr_parameters.organization_id...... = ' || gr_parameters.organization_id,30);
464: hr_utility.set_location('gr_parameters.business_group_id.... = ' || gr_parameters.business_group_id,30);
465: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
466: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
467: hr_utility.set_location('gr_parameters.include_org_hierarchy = ' || gr_parameters.include_org_hierarchy,30);
468: hr_utility.set_location('gr_parameters.incl_term_emp... ... = ' || gr_parameters.incl_term_emp,30);
469: hr_utility.set_location('gr_parameters.term_eff_date_from... = ' || gr_parameters.term_date_from,30);
470: hr_utility.set_location('gr_parameters.term_eff_date_to..... = ' || gr_parameters.term_date_to,30);
471: hr_utility.set_location('gr_parameters.img_display = ' || gr_parameters.img_display,30);

Line 468: hr_utility.set_location('gr_parameters.incl_term_emp... ... = ' || gr_parameters.incl_term_emp,30);

464: hr_utility.set_location('gr_parameters.business_group_id.... = ' || gr_parameters.business_group_id,30);
465: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
466: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
467: hr_utility.set_location('gr_parameters.include_org_hierarchy = ' || gr_parameters.include_org_hierarchy,30);
468: hr_utility.set_location('gr_parameters.incl_term_emp... ... = ' || gr_parameters.incl_term_emp,30);
469: hr_utility.set_location('gr_parameters.term_eff_date_from... = ' || gr_parameters.term_date_from,30);
470: hr_utility.set_location('gr_parameters.term_eff_date_to..... = ' || gr_parameters.term_date_to,30);
471: hr_utility.set_location('gr_parameters.img_display = ' || gr_parameters.img_display,30);
472: hr_utility.set_location('gr_parameters.sort_order_1 = ' || gr_parameters.sort_order_1,30);

Line 469: hr_utility.set_location('gr_parameters.term_eff_date_from... = ' || gr_parameters.term_date_from,30);

465: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
466: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
467: hr_utility.set_location('gr_parameters.include_org_hierarchy = ' || gr_parameters.include_org_hierarchy,30);
468: hr_utility.set_location('gr_parameters.incl_term_emp... ... = ' || gr_parameters.incl_term_emp,30);
469: hr_utility.set_location('gr_parameters.term_eff_date_from... = ' || gr_parameters.term_date_from,30);
470: hr_utility.set_location('gr_parameters.term_eff_date_to..... = ' || gr_parameters.term_date_to,30);
471: hr_utility.set_location('gr_parameters.img_display = ' || gr_parameters.img_display,30);
472: hr_utility.set_location('gr_parameters.sort_order_1 = ' || gr_parameters.sort_order_1,30);
473: hr_utility.set_location('gr_parameters.sort_order_2 = ' || gr_parameters.sort_order_2,30);

Line 470: hr_utility.set_location('gr_parameters.term_eff_date_to..... = ' || gr_parameters.term_date_to,30);

466: hr_utility.set_location('gr_parameters.effective_date....... = ' || gr_parameters.effective_date,30);
467: hr_utility.set_location('gr_parameters.include_org_hierarchy = ' || gr_parameters.include_org_hierarchy,30);
468: hr_utility.set_location('gr_parameters.incl_term_emp... ... = ' || gr_parameters.incl_term_emp,30);
469: hr_utility.set_location('gr_parameters.term_eff_date_from... = ' || gr_parameters.term_date_from,30);
470: hr_utility.set_location('gr_parameters.term_eff_date_to..... = ' || gr_parameters.term_date_to,30);
471: hr_utility.set_location('gr_parameters.img_display = ' || gr_parameters.img_display,30);
472: hr_utility.set_location('gr_parameters.sort_order_1 = ' || gr_parameters.sort_order_1,30);
473: hr_utility.set_location('gr_parameters.sort_order_2 = ' || gr_parameters.sort_order_2,30);
474: hr_utility.set_location('gr_parameters.sort_order_3 = ' || gr_parameters.sort_order_3,30);

Line 471: hr_utility.set_location('gr_parameters.img_display = ' || gr_parameters.img_display,30);

467: hr_utility.set_location('gr_parameters.include_org_hierarchy = ' || gr_parameters.include_org_hierarchy,30);
468: hr_utility.set_location('gr_parameters.incl_term_emp... ... = ' || gr_parameters.incl_term_emp,30);
469: hr_utility.set_location('gr_parameters.term_eff_date_from... = ' || gr_parameters.term_date_from,30);
470: hr_utility.set_location('gr_parameters.term_eff_date_to..... = ' || gr_parameters.term_date_to,30);
471: hr_utility.set_location('gr_parameters.img_display = ' || gr_parameters.img_display,30);
472: hr_utility.set_location('gr_parameters.sort_order_1 = ' || gr_parameters.sort_order_1,30);
473: hr_utility.set_location('gr_parameters.sort_order_2 = ' || gr_parameters.sort_order_2,30);
474: hr_utility.set_location('gr_parameters.sort_order_3 = ' || gr_parameters.sort_order_3,30);
475: END IF;

Line 472: hr_utility.set_location('gr_parameters.sort_order_1 = ' || gr_parameters.sort_order_1,30);

468: hr_utility.set_location('gr_parameters.incl_term_emp... ... = ' || gr_parameters.incl_term_emp,30);
469: hr_utility.set_location('gr_parameters.term_eff_date_from... = ' || gr_parameters.term_date_from,30);
470: hr_utility.set_location('gr_parameters.term_eff_date_to..... = ' || gr_parameters.term_date_to,30);
471: hr_utility.set_location('gr_parameters.img_display = ' || gr_parameters.img_display,30);
472: hr_utility.set_location('gr_parameters.sort_order_1 = ' || gr_parameters.sort_order_1,30);
473: hr_utility.set_location('gr_parameters.sort_order_2 = ' || gr_parameters.sort_order_2,30);
474: hr_utility.set_location('gr_parameters.sort_order_3 = ' || gr_parameters.sort_order_3,30);
475: END IF;
476: --

Line 473: hr_utility.set_location('gr_parameters.sort_order_2 = ' || gr_parameters.sort_order_2,30);

469: hr_utility.set_location('gr_parameters.term_eff_date_from... = ' || gr_parameters.term_date_from,30);
470: hr_utility.set_location('gr_parameters.term_eff_date_to..... = ' || gr_parameters.term_date_to,30);
471: hr_utility.set_location('gr_parameters.img_display = ' || gr_parameters.img_display,30);
472: hr_utility.set_location('gr_parameters.sort_order_1 = ' || gr_parameters.sort_order_1,30);
473: hr_utility.set_location('gr_parameters.sort_order_2 = ' || gr_parameters.sort_order_2,30);
474: hr_utility.set_location('gr_parameters.sort_order_3 = ' || gr_parameters.sort_order_3,30);
475: END IF;
476: --
477: IF gb_debug THEN

Line 474: hr_utility.set_location('gr_parameters.sort_order_3 = ' || gr_parameters.sort_order_3,30);

470: hr_utility.set_location('gr_parameters.term_eff_date_to..... = ' || gr_parameters.term_date_to,30);
471: hr_utility.set_location('gr_parameters.img_display = ' || gr_parameters.img_display,30);
472: hr_utility.set_location('gr_parameters.sort_order_1 = ' || gr_parameters.sort_order_1,30);
473: hr_utility.set_location('gr_parameters.sort_order_2 = ' || gr_parameters.sort_order_2,30);
474: hr_utility.set_location('gr_parameters.sort_order_3 = ' || gr_parameters.sort_order_3,30);
475: END IF;
476: --
477: IF gb_debug THEN
478: hr_utility.set_location('Leaving '||lc_procedure,40);

Line 478: hr_utility.set_location('Leaving '||lc_procedure,40);

474: hr_utility.set_location('gr_parameters.sort_order_3 = ' || gr_parameters.sort_order_3,30);
475: END IF;
476: --
477: IF gb_debug THEN
478: hr_utility.set_location('Leaving '||lc_procedure,40);
479: END IF;
480: --
481: EXCEPTION
482: WHEN gc_exception THEN

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

480: --
481: EXCEPTION
482: WHEN gc_exception THEN
483: IF gb_debug THEN
484: hr_utility.set_location('Error in '||lc_procedure,999999);
485: END IF;
486: RAISE;
487: WHEN OTHERS THEN
488: RAISE gc_exception;

Line 522: gb_debug := hr_utility.debug_enabled;

518: --************************************************************************
519: AS
520: lc_proc_name VARCHAR2(100);
521: BEGIN
522: gb_debug := hr_utility.debug_enabled;
523: --
524: IF gb_debug THEN
525: lc_proc_name := gc_pkg_name ||'range_cursor';
526: hr_utility.set_location ('Entering '||lc_proc_name,50);

Line 526: hr_utility.set_location ('Entering '||lc_proc_name,50);

522: gb_debug := hr_utility.debug_enabled;
523: --
524: IF gb_debug THEN
525: lc_proc_name := gc_pkg_name ||'range_cursor';
526: hr_utility.set_location ('Entering '||lc_proc_name,50);
527: hr_utility.set_location ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id,50);
528: END IF;
529: --
530: p_sqlstr := ' select distinct p.person_id'||

Line 527: hr_utility.set_location ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id,50);

523: --
524: IF gb_debug THEN
525: lc_proc_name := gc_pkg_name ||'range_cursor';
526: hr_utility.set_location ('Entering '||lc_proc_name,50);
527: hr_utility.set_location ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id,50);
528: END IF;
529: --
530: p_sqlstr := ' select distinct p.person_id'||
531: ' from per_people_f p,'||

Line 540: hr_utility.set_location ('Range cursor query : ' || p_sqlstr,50);

536: --
537: g_mag_payroll_action_id := p_payroll_action_id;
538: --
539: IF gb_debug THEN
540: hr_utility.set_location ('Range cursor query : ' || p_sqlstr,50);
541: hr_utility.set_location ('Leaving '||lc_proc_name,50);
542: END IF;
543: END range_cursor;
544: --

Line 541: hr_utility.set_location ('Leaving '||lc_proc_name,50);

537: g_mag_payroll_action_id := p_payroll_action_id;
538: --
539: IF gb_debug THEN
540: hr_utility.set_location ('Range cursor query : ' || p_sqlstr,50);
541: hr_utility.set_location ('Leaving '||lc_proc_name,50);
542: END IF;
543: END range_cursor;
544: --
545: --Commented below as per the bug #8766043

Line 588: gb_debug := hr_utility.debug_enabled;

584: ld_effective_date DATE;
585: --
586: BEGIN
587: --
588: gb_debug := hr_utility.debug_enabled;
589: IF gb_debug THEN
590: hr_utility.set_location('Entering sort_action procedure',20);
591: END IF;
592: --

Line 590: hr_utility.set_location('Entering sort_action procedure',20);

586: BEGIN
587: --
588: gb_debug := hr_utility.debug_enabled;
589: IF gb_debug THEN
590: hr_utility.set_location('Entering sort_action procedure',20);
591: END IF;
592: --
593: initialize(p_payroll_action_id);
594:

Line 637: hr_utility.set_location('End of the sort_Action cursor',20);

633:
634: len := length(sqlstr); -- return the length of the string
635: --
636: IF gb_debug THEN
637: hr_utility.set_location('End of the sort_Action cursor',20);
638: hr_utility.set_location('Leaving sort_action procedure',20);
639: END IF;
640: --
641: END sort_action;

Line 638: hr_utility.set_location('Leaving sort_action procedure',20);

634: len := length(sqlstr); -- return the length of the string
635: --
636: IF gb_debug THEN
637: hr_utility.set_location('End of the sort_Action cursor',20);
638: hr_utility.set_location('Leaving sort_action procedure',20);
639: END IF;
640: --
641: END sort_action;
642: */

Line 679: gb_debug := hr_utility.debug_enabled;

675: AS
676:
677: BEGIN
678: --
679: gb_debug := hr_utility.debug_enabled;
680: --
681: IF gb_debug THEN
682: hr_utility.set_location('Entering sort_action procedure',20);
683: END IF;

Line 682: hr_utility.set_location('Entering sort_action procedure',20);

678: --
679: gb_debug := hr_utility.debug_enabled;
680: --
681: IF gb_debug THEN
682: hr_utility.set_location('Entering sort_action procedure',20);
683: END IF;
684: --
685: hr_utility.trace('Beginning of the sort_action cursor');
686: --

Line 685: hr_utility.trace('Beginning of the sort_action cursor');

681: IF gb_debug THEN
682: hr_utility.set_location('Entering sort_action procedure',20);
683: END IF;
684: --
685: hr_utility.trace('Beginning of the sort_action cursor');
686: --
687: initialize(p_payroll_action_id);
688:
689: sqlstr := ' SELECT PAA.rowid

Line 723: hr_utility.trace('End of the sort_Action cursor');

719:
720: len := length(sqlstr);
721: IF gb_debug
722: THEN
723: hr_utility.trace('End of the sort_Action cursor');
724: END IF;
725: --
726: EXCEPTION WHEN NO_DATA_FOUND THEN
727: IF gb_debug THEN

Line 728: hr_utility.trace('Error in Sort Procedure - getting legislative param');

724: END IF;
725: --
726: EXCEPTION WHEN NO_DATA_FOUND THEN
727: IF gb_debug THEN
728: hr_utility.trace('Error in Sort Procedure - getting legislative param');
729: END IF;
730: RAISE;
731: --
732: END sort_action;

Line 768: gb_debug := hr_utility.debug_enabled;

764: lc_action_param_val VARCHAR2(30);
765: --
766: BEGIN
767: --
768: gb_debug := hr_utility.debug_enabled;
769: --
770: IF gb_debug THEN
771: hr_utility.set_location('Entering range_person_on',10);
772: END IF;

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

767: --
768: gb_debug := hr_utility.debug_enabled;
769: --
770: IF gb_debug THEN
771: hr_utility.set_location('Entering range_person_on',10);
772: END IF;
773: --
774: OPEN lcu_action_parameter;
775: FETCH lcu_action_parameter INTO lc_action_param_val;

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

777: --
778: IF lc_action_param_val = 'Y' THEN
779: lb_return := TRUE;
780: IF gb_debug THEN
781: hr_utility.set_location('Range Person = True',10);
782: END IF;
783: ELSE
784: lb_return := FALSE;
785: END IF;

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

784: lb_return := FALSE;
785: END IF;
786: --
787: IF gb_debug THEN
788: hr_utility.set_location('Leaving range_person_on',10);
789: END IF;
790: RETURN lb_return;
791: --
792: EXCEPTION WHEN NO_DATA_FOUND THEN

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

790: RETURN lb_return;
791: --
792: EXCEPTION WHEN NO_DATA_FOUND THEN
793: IF gb_debug THEN
794: hr_utility.set_location('No Data Found Exception in range_person_on',10);
795: END IF;
796: lb_return := FALSE;
797: RETURN lb_return;
798: END range_person_on;

Line 954: gb_debug := hr_utility.debug_enabled;

950: ln_ass_set_id NUMBER;
951: lb_result2 BOOLEAN;
952: --
953: BEGIN
954: gb_debug := hr_utility.debug_enabled;
955: --
956: IF gb_debug THEN
957: lc_proc_name := gc_pkg_name ||'action_creation';
958: hr_utility.set_location ('Entering '||lc_proc_name,50);

Line 958: hr_utility.set_location ('Entering '||lc_proc_name,50);

954: gb_debug := hr_utility.debug_enabled;
955: --
956: IF gb_debug THEN
957: lc_proc_name := gc_pkg_name ||'action_creation';
958: hr_utility.set_location ('Entering '||lc_proc_name,50);
959: END IF;
960: --
961: SELECT legislative_parameters
962: INTO lc_legislative_parameters

Line 972: hr_utility.set_location ('Parameters ....',20);

968: --
969: g_mag_payroll_action_id := p_payroll_action_id;
970: --
971: IF gb_debug THEN
972: hr_utility.set_location ('Parameters ....',20);
973: hr_utility.set_location ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id,20);
974: hr_utility.set_location ('P_START_PERSON_ID = '|| p_start_person_id,20);
975: hr_utility.set_location ('P_END_PERSON_ID = '|| p_end_person_id,20);
976: hr_utility.set_location ('P_CHUNK = '|| p_chunk,20);

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

969: g_mag_payroll_action_id := p_payroll_action_id;
970: --
971: IF gb_debug THEN
972: hr_utility.set_location ('Parameters ....',20);
973: hr_utility.set_location ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id,20);
974: hr_utility.set_location ('P_START_PERSON_ID = '|| p_start_person_id,20);
975: hr_utility.set_location ('P_END_PERSON_ID = '|| p_end_person_id,20);
976: hr_utility.set_location ('P_CHUNK = '|| p_chunk,20);
977: hr_utility.set_location ('P_OLD_PAYROLL_ACTION-ID = '|| ln_old_pact_id,20);

Line 974: hr_utility.set_location ('P_START_PERSON_ID = '|| p_start_person_id,20);

970: --
971: IF gb_debug THEN
972: hr_utility.set_location ('Parameters ....',20);
973: hr_utility.set_location ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id,20);
974: hr_utility.set_location ('P_START_PERSON_ID = '|| p_start_person_id,20);
975: hr_utility.set_location ('P_END_PERSON_ID = '|| p_end_person_id,20);
976: hr_utility.set_location ('P_CHUNK = '|| p_chunk,20);
977: hr_utility.set_location ('P_OLD_PAYROLL_ACTION-ID = '|| ln_old_pact_id,20);
978: hr_utility.set_location ('P_ASS_SET_ID = '|| ln_ass_set_id,20);

Line 975: hr_utility.set_location ('P_END_PERSON_ID = '|| p_end_person_id,20);

971: IF gb_debug THEN
972: hr_utility.set_location ('Parameters ....',20);
973: hr_utility.set_location ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id,20);
974: hr_utility.set_location ('P_START_PERSON_ID = '|| p_start_person_id,20);
975: hr_utility.set_location ('P_END_PERSON_ID = '|| p_end_person_id,20);
976: hr_utility.set_location ('P_CHUNK = '|| p_chunk,20);
977: hr_utility.set_location ('P_OLD_PAYROLL_ACTION-ID = '|| ln_old_pact_id,20);
978: hr_utility.set_location ('P_ASS_SET_ID = '|| ln_ass_set_id,20);
979: END IF;

Line 976: hr_utility.set_location ('P_CHUNK = '|| p_chunk,20);

972: hr_utility.set_location ('Parameters ....',20);
973: hr_utility.set_location ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id,20);
974: hr_utility.set_location ('P_START_PERSON_ID = '|| p_start_person_id,20);
975: hr_utility.set_location ('P_END_PERSON_ID = '|| p_end_person_id,20);
976: hr_utility.set_location ('P_CHUNK = '|| p_chunk,20);
977: hr_utility.set_location ('P_OLD_PAYROLL_ACTION-ID = '|| ln_old_pact_id,20);
978: hr_utility.set_location ('P_ASS_SET_ID = '|| ln_ass_set_id,20);
979: END IF;
980: --

Line 977: hr_utility.set_location ('P_OLD_PAYROLL_ACTION-ID = '|| ln_old_pact_id,20);

973: hr_utility.set_location ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id,20);
974: hr_utility.set_location ('P_START_PERSON_ID = '|| p_start_person_id,20);
975: hr_utility.set_location ('P_END_PERSON_ID = '|| p_end_person_id,20);
976: hr_utility.set_location ('P_CHUNK = '|| p_chunk,20);
977: hr_utility.set_location ('P_OLD_PAYROLL_ACTION-ID = '|| ln_old_pact_id,20);
978: hr_utility.set_location ('P_ASS_SET_ID = '|| ln_ass_set_id,20);
979: END IF;
980: --
981: initialize(g_mag_payroll_action_id);

Line 978: hr_utility.set_location ('P_ASS_SET_ID = '|| ln_ass_set_id,20);

974: hr_utility.set_location ('P_START_PERSON_ID = '|| p_start_person_id,20);
975: hr_utility.set_location ('P_END_PERSON_ID = '|| p_end_person_id,20);
976: hr_utility.set_location ('P_CHUNK = '|| p_chunk,20);
977: hr_utility.set_location ('P_OLD_PAYROLL_ACTION-ID = '|| ln_old_pact_id,20);
978: hr_utility.set_location ('P_ASS_SET_ID = '|| ln_ass_set_id,20);
979: END IF;
980: --
981: initialize(g_mag_payroll_action_id);
982: --

Line 1001: hr_utility.set_location ('In org hierarchy loop',20);

997: FOR i in 1..lt_org_id.COUNT
998: LOOP
999: --
1000: IF gb_debug THEN
1001: hr_utility.set_location ('In org hierarchy loop',20);
1002: END IF;
1003: --
1004: IF range_person_on THEN
1005: --

Line 1007: hr_utility.set_location('Inside Range person if condition, with org id',20);

1003: --
1004: IF range_person_on THEN
1005: --
1006: IF gb_debug THEN
1007: hr_utility.set_location('Inside Range person if condition, with org id',20);
1008: END IF;
1009: --
1010: FOR lr_assact IN lcu_assact_r(ln_old_pact_id
1011: ,gr_parameters.business_group_id

Line 1022: hr_utility.set_location ('In org - assact loop',20);

1018: )
1019: LOOP
1020: --
1021: IF gb_debug THEN
1022: hr_utility.set_location ('In org - assact loop',20);
1023: END IF;
1024: --
1025: -- Added NVL to overcome NULL issue.
1026: IF (NVL(ln_ass_set_id,0) = 0) THEN

Line 1069: hr_utility.set_location ('In org - assact loop',20);

1065: )
1066: LOOP
1067: --
1068: IF gb_debug THEN
1069: hr_utility.set_location ('In org - assact loop',20);
1070: END IF;
1071: --
1072: -- Added NVL to overcome NULL issue.
1073: IF (NVL(ln_ass_set_id,0) = 0) THEN

Line 1109: hr_utility.set_location('Inside Range person if condition, with org id as null',20);

1105: --
1106: ELSE -- If org id is null
1107: IF range_person_on THEN
1108: IF gb_debug THEN
1109: hr_utility.set_location('Inside Range person if condition, with org id as null',20);
1110: END IF;
1111: FOR lr_assact IN lcu_assact_r(ln_old_pact_id
1112: ,gr_parameters.business_group_id
1113: ,NULL

Line 1122: hr_utility.set_location ('In org assact loop',20);

1118: ,gr_parameters.effective_date
1119: )
1120: LOOP
1121: IF gb_debug THEN
1122: hr_utility.set_location ('In org assact loop',20);
1123: END IF;
1124: --
1125: -- Added NVL to overcome NULL issue.
1126: IF (NVL(ln_ass_set_id,0) = 0) THEN

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

1155: END IF;
1156: END LOOP; -- for lcu_assact_r
1157: ELSE
1158: IF gb_debug THEN
1159: hr_utility.set_location('Range person returns false',20);
1160: END IF;
1161: -- Assignment Action for Current and Terminated Employe
1162: FOR lr_assact IN lcu_assact(ln_old_pact_id
1163: ,gr_parameters.business_group_id

Line 1173: hr_utility.set_location ('In org assact loop',20);

1169: ,gr_parameters.effective_date
1170: )
1171: LOOP
1172: IF gb_debug THEN
1173: hr_utility.set_location ('In org assact loop',20);
1174: END IF;
1175: --
1176: -- Added NVL to overcome NULL issue.
1177: IF (NVL(ln_ass_set_id,0) = 0) THEN

Line 1212: hr_utility.set_location ('Leaving '||lc_proc_name,50);

1208: END IF; -- for range person
1209: END IF; -- for org id is null
1210: --
1211: IF gb_debug THEN
1212: hr_utility.set_location ('Leaving '||lc_proc_name,50);
1213: END IF;
1214: --
1215: END action_creation;
1216: --

Line 1242: gb_debug := hr_utility.debug_enabled;

1238: -- None
1239: --************************************************************************
1240: IS
1241: BEGIN
1242: gb_debug := hr_utility.debug_enabled;
1243: IF gb_debug THEN
1244: hr_utility.set_location ('inside init_code ',20);
1245: END IF;
1246: g_mag_payroll_action_id := p_payroll_action_id;

Line 1244: hr_utility.set_location ('inside init_code ',20);

1240: IS
1241: BEGIN
1242: gb_debug := hr_utility.debug_enabled;
1243: IF gb_debug THEN
1244: hr_utility.set_location ('inside init_code ',20);
1245: END IF;
1246: g_mag_payroll_action_id := p_payroll_action_id;
1247: NULL;
1248: END init_code;

Line 1278: gb_debug := hr_utility.debug_enabled;

1274: -- None
1275: --************************************************************************
1276: IS
1277: BEGIN
1278: gb_debug := hr_utility.debug_enabled;
1279: IF gb_debug THEN
1280: hr_utility.set_location ('inside archive_code ',20);
1281: END IF;
1282: END archive_code;

Line 1280: hr_utility.set_location ('inside archive_code ',20);

1276: IS
1277: BEGIN
1278: gb_debug := hr_utility.debug_enabled;
1279: IF gb_debug THEN
1280: hr_utility.set_location ('inside archive_code ',20);
1281: END IF;
1282: END archive_code;
1283: --
1284:

Line 1518: gb_debug := hr_utility.debug_enabled;

1514: vXMLTable.DELETE;
1515: gn_vctr := 0;
1516: lc_job_hist_xml := null;
1517: --
1518: gb_debug := hr_utility.debug_enabled;
1519: IF gb_debug THEN
1520: hr_utility.set_location ('Entering assact_xml',20);
1521: hr_utility.set_location('empdet_xml',20);
1522: END IF;

Line 1520: hr_utility.set_location ('Entering assact_xml',20);

1516: lc_job_hist_xml := null;
1517: --
1518: gb_debug := hr_utility.debug_enabled;
1519: IF gb_debug THEN
1520: hr_utility.set_location ('Entering assact_xml',20);
1521: hr_utility.set_location('empdet_xml',20);
1522: END IF;
1523: --
1524: ln_mag_asg_action_id := p_assignment_action_id;

Line 1521: hr_utility.set_location('empdet_xml',20);

1517: --
1518: gb_debug := hr_utility.debug_enabled;
1519: IF gb_debug THEN
1520: hr_utility.set_location ('Entering assact_xml',20);
1521: hr_utility.set_location('empdet_xml',20);
1522: END IF;
1523: --
1524: ln_mag_asg_action_id := p_assignment_action_id;
1525: --

Line 1790: hr_utility.set_location ('Leaving assact_xml',20);

1786: END IF;
1787: CLOSE lcu_emp_det;
1788: --
1789: IF gb_debug THEN
1790: hr_utility.set_location ('Leaving assact_xml',20);
1791: END IF;
1792: --
1793: EXCEPTION
1794: WHEN gc_exception THEN

Line 1796: hr_utility.set_location('Error in assact_xml ',999999);

1792: --
1793: EXCEPTION
1794: WHEN gc_exception THEN
1795: IF gb_debug THEN
1796: hr_utility.set_location('Error in assact_xml ',999999);
1797: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1798: END IF;
1799: hr_utility.raise_error;
1800: RAISE;

Line 1797: hr_utility.set_location('sqleerm ' || SQLERRM,20);

1793: EXCEPTION
1794: WHEN gc_exception THEN
1795: IF gb_debug THEN
1796: hr_utility.set_location('Error in assact_xml ',999999);
1797: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1798: END IF;
1799: hr_utility.raise_error;
1800: RAISE;
1801: WHEN OTHERS THEN

Line 1799: hr_utility.raise_error;

1795: IF gb_debug THEN
1796: hr_utility.set_location('Error in assact_xml ',999999);
1797: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1798: END IF;
1799: hr_utility.raise_error;
1800: RAISE;
1801: WHEN OTHERS THEN
1802: RAISE gc_exception;
1803: END assact_xml;

Line 1835: gb_debug := hr_utility.debug_enabled;

1831: l_tempclob CLOB;
1832: ln_ctr_table NUMBER;
1833: lc_xml2 CLOB;
1834: BEGIN
1835: gb_debug := hr_utility.debug_enabled;
1836: IF gb_debug THEN
1837: hr_utility.set_location('Entering writetoclob',20);
1838: END IF;
1839: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);

Line 1837: hr_utility.set_location('Entering writetoclob',20);

1833: lc_xml2 CLOB;
1834: BEGIN
1835: gb_debug := hr_utility.debug_enabled;
1836: IF gb_debug THEN
1837: hr_utility.set_location('Entering writetoclob',20);
1838: END IF;
1839: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1840: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1841: --

Line 1852: hr_utility.set_location('Out of loop ',99);

1848: --
1849: p_write_xml := g_xfdf_string;
1850: dbms_lob.close(g_xfdf_string);
1851: IF gb_debug THEN
1852: hr_utility.set_location('Out of loop ',99);
1853: hr_utility.set_location('Leaving writetoclob',20);
1854: END IF;
1855: --
1856: EXCEPTION

Line 1853: hr_utility.set_location('Leaving writetoclob',20);

1849: p_write_xml := g_xfdf_string;
1850: dbms_lob.close(g_xfdf_string);
1851: IF gb_debug THEN
1852: hr_utility.set_location('Out of loop ',99);
1853: hr_utility.set_location('Leaving writetoclob',20);
1854: END IF;
1855: --
1856: EXCEPTION
1857: WHEN gc_exception THEN

Line 1859: hr_utility.set_location('Error in writetoclob ',999999);

1855: --
1856: EXCEPTION
1857: WHEN gc_exception THEN
1858: IF gb_debug THEN
1859: hr_utility.set_location('Error in writetoclob ',999999);
1860: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1861: END IF;
1862: hr_utility.raise_error;
1863: RAISE;

Line 1860: hr_utility.set_location('sqleerm ' || SQLERRM,20);

1856: EXCEPTION
1857: WHEN gc_exception THEN
1858: IF gb_debug THEN
1859: hr_utility.set_location('Error in writetoclob ',999999);
1860: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1861: END IF;
1862: hr_utility.raise_error;
1863: RAISE;
1864: WHEN OTHERS THEN

Line 1862: hr_utility.raise_error;

1858: IF gb_debug THEN
1859: hr_utility.set_location('Error in writetoclob ',999999);
1860: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1861: END IF;
1862: hr_utility.raise_error;
1863: RAISE;
1864: WHEN OTHERS THEN
1865: RAISE gc_exception;
1866: END writetoclob;

Line 1898: gb_debug := hr_utility.debug_enabled;

1894: --************************************************************************
1895: IS
1896: --
1897: BEGIN
1898: gb_debug := hr_utility.debug_enabled;
1899: IF gb_debug THEN
1900: hr_utility.set_location('Entering get_cp_xml',20);
1901: hr_utility.set_location('Leaving get_cp_xml',20);
1902: END IF;

Line 1900: hr_utility.set_location('Entering get_cp_xml',20);

1896: --
1897: BEGIN
1898: gb_debug := hr_utility.debug_enabled;
1899: IF gb_debug THEN
1900: hr_utility.set_location('Entering get_cp_xml',20);
1901: hr_utility.set_location('Leaving get_cp_xml',20);
1902: END IF;
1903: assact_xml(p_assignment_action_id);
1904: writetoclob (p_xml);

Line 1901: hr_utility.set_location('Leaving get_cp_xml',20);

1897: BEGIN
1898: gb_debug := hr_utility.debug_enabled;
1899: IF gb_debug THEN
1900: hr_utility.set_location('Entering get_cp_xml',20);
1901: hr_utility.set_location('Leaving get_cp_xml',20);
1902: END IF;
1903: assact_xml(p_assignment_action_id);
1904: writetoclob (p_xml);
1905: END get_cp_xml;

Line 1968: gb_debug := hr_utility.debug_enabled;

1964:
1965: --
1966: BEGIN
1967: --
1968: gb_debug := hr_utility.debug_enabled;
1969: IF gb_debug THEN
1970: lc_proc_name := gc_pkg_name || 'generate_xml';
1971: hr_utility.set_location ('Entering '||lc_proc_name,20);
1972: END IF;

Line 1971: hr_utility.set_location ('Entering '||lc_proc_name,20);

1967: --
1968: gb_debug := hr_utility.debug_enabled;
1969: IF gb_debug THEN
1970: lc_proc_name := gc_pkg_name || 'generate_xml';
1971: hr_utility.set_location ('Entering '||lc_proc_name,20);
1972: END IF;
1973: --
1974: ln_cur_assact := pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID' );
1975: ln_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );

Line 2007: hr_utility.set_location ('exiting from loop',20);

2003: END LOOP;
2004: EXCEPTION
2005: WHEN no_data_found THEN
2006: IF gb_debug THEN
2007: hr_utility.set_location ('exiting from loop',20);
2008: END IF;
2009: END;
2010: --
2011: IF gr_parameters.img_display = 'Y' THEN

Line 2045: hr_utility.set_location ('exiting from loop',20);

2041: END LOOP;
2042: EXCEPTION
2043: WHEN no_data_found THEN
2044: IF gb_debug THEN
2045: hr_utility.set_location ('exiting from loop',20);
2046: END IF;
2047: END;
2048: END IF;
2049:

Line 2060: hr_utility.set_location ('Leaving '||lc_proc_name,20);

2056:
2057: EXCEPTION
2058: WHEN NO_DATA_FOUND THEN
2059: IF gb_debug THEN
2060: hr_utility.set_location ('Leaving '||lc_proc_name,20);
2061: END IF;
2062: WHEN gc_exception THEN
2063: IF gb_debug THEN
2064: hr_utility.set_location('Error in '||lc_proc_name,999999);

Line 2064: hr_utility.set_location('Error in '||lc_proc_name,999999);

2060: hr_utility.set_location ('Leaving '||lc_proc_name,20);
2061: END IF;
2062: WHEN gc_exception THEN
2063: IF gb_debug THEN
2064: hr_utility.set_location('Error in '||lc_proc_name,999999);
2065: hr_utility.set_location('sqleerm ' || SQLERRM,20);
2066: END IF;
2067: hr_utility.raise_error;
2068: RAISE;

Line 2065: hr_utility.set_location('sqleerm ' || SQLERRM,20);

2061: END IF;
2062: WHEN gc_exception THEN
2063: IF gb_debug THEN
2064: hr_utility.set_location('Error in '||lc_proc_name,999999);
2065: hr_utility.set_location('sqleerm ' || SQLERRM,20);
2066: END IF;
2067: hr_utility.raise_error;
2068: RAISE;
2069: WHEN OTHERS THEN

Line 2067: hr_utility.raise_error;

2063: IF gb_debug THEN
2064: hr_utility.set_location('Error in '||lc_proc_name,999999);
2065: hr_utility.set_location('sqleerm ' || SQLERRM,20);
2066: END IF;
2067: hr_utility.raise_error;
2068: RAISE;
2069: WHEN OTHERS THEN
2070: RAISE gc_exception;
2071: END generate_xml;

Line 2100: gb_debug := hr_utility.debug_enabled;

2096: lc_proc_name VARCHAR2(100);
2097: lc_buf VARCHAR2(2000);
2098: --
2099: BEGIN
2100: gb_debug := hr_utility.debug_enabled;
2101: IF gb_debug THEN
2102: lc_proc_name := gc_pkg_name || 'gen_xml_header';
2103: hr_utility.set_location ('Entering '||lc_proc_name,20);
2104: END IF ;

Line 2103: hr_utility.set_location ('Entering '||lc_proc_name,20);

2099: BEGIN
2100: gb_debug := hr_utility.debug_enabled;
2101: IF gb_debug THEN
2102: lc_proc_name := gc_pkg_name || 'gen_xml_header';
2103: hr_utility.set_location ('Entering '||lc_proc_name,20);
2104: END IF ;
2105: --
2106: vxmltable.DELETE; -- delete the pl/sql table
2107: --

Line 2113: hr_utility.set_location ('CLOB contents after appending header information',20);

2109: --
2110: pay_core_files.write_to_magtape_lob(lc_buf);
2111: --
2112: IF gb_debug THEN
2113: hr_utility.set_location ('CLOB contents after appending header information',20);
2114: hr_utility.set_location ('Leaving '||lc_proc_name,20);
2115: END IF ;
2116: --
2117: END gen_xml_header;

Line 2114: hr_utility.set_location ('Leaving '||lc_proc_name,20);

2110: pay_core_files.write_to_magtape_lob(lc_buf);
2111: --
2112: IF gb_debug THEN
2113: hr_utility.set_location ('CLOB contents after appending header information',20);
2114: hr_utility.set_location ('Leaving '||lc_proc_name,20);
2115: END IF ;
2116: --
2117: END gen_xml_header;
2118: --

Line 2147: gb_debug := hr_utility.debug_enabled;

2143: lc_proc_name VARCHAR2(100);
2144: --
2145: BEGIN
2146: --
2147: gb_debug := hr_utility.debug_enabled;
2148: IF gb_debug THEN
2149: lc_proc_name := gc_pkg_name || 'gen_xml_footer';
2150: hr_utility.set_location ('Entering '||lc_proc_name,20);
2151: END IF ;

Line 2150: hr_utility.set_location ('Entering '||lc_proc_name,20);

2146: --
2147: gb_debug := hr_utility.debug_enabled;
2148: IF gb_debug THEN
2149: lc_proc_name := gc_pkg_name || 'gen_xml_footer';
2150: hr_utility.set_location ('Entering '||lc_proc_name,20);
2151: END IF ;
2152: lc_buf := '' ;
2153: --
2154: pay_core_files.write_to_magtape_lob(lc_buf);

Line 2157: hr_utility.set_location ('CLOB contents after appending footer information',20);

2153: --
2154: pay_core_files.write_to_magtape_lob(lc_buf);
2155: --
2156: IF gb_debug THEN
2157: hr_utility.set_location ('CLOB contents after appending footer information',20);
2158: hr_utility.set_location ('Leaving '||lc_proc_name,20);
2159: END IF ;
2160: --
2161: END gen_xml_footer;

Line 2158: hr_utility.set_location ('Leaving '||lc_proc_name,20);

2154: pay_core_files.write_to_magtape_lob(lc_buf);
2155: --
2156: IF gb_debug THEN
2157: hr_utility.set_location ('CLOB contents after appending footer information',20);
2158: hr_utility.set_location ('Leaving '||lc_proc_name,20);
2159: END IF ;
2160: --
2161: END gen_xml_footer;
2162: --