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

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: package body per_jp_empdet_archive_pkg as
2: /* $Header: pejpearc.pkb 120.34 2011/06/23 04:00:31 keyazawa noship $ */
3: --
4: c_package constant varchar2(30) := 'per_jp_empdet_archive_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;
6: --
7: g_range_person varchar2(80);
8: g_ext_proc_name varchar2(150);
9: --

Line 178: hr_utility.trace('l_hidden_debug : '||l_hidden_debug);

174: end if;
175: --
176: if g_debug then
177: --
178: hr_utility.trace('l_hidden_debug : '||l_hidden_debug);
179: hr_utility.trace('g_detail_debug : '||g_detail_debug);
180: --
181: end if;
182: --

Line 179: hr_utility.trace('g_detail_debug : '||g_detail_debug);

175: --
176: if g_debug then
177: --
178: hr_utility.trace('l_hidden_debug : '||l_hidden_debug);
179: hr_utility.trace('g_detail_debug : '||g_detail_debug);
180: --
181: end if;
182: --
183: end set_detail_debug;

Line 252: hr_utility.set_location(l_proc,0);

248: set_detail_debug(l_detail_debug);
249: --
250: if g_debug
251: and g_detail_debug = 'Y' then
252: hr_utility.set_location(l_proc,0);
253: end if;
254: --
255: if g_payroll_action_id is null
256: or g_payroll_action_id <> p_payroll_action_id then

Line 260: hr_utility.set_location(l_proc,10);

256: or g_payroll_action_id <> p_payroll_action_id then
257: --
258: if g_debug
259: and g_detail_debug = 'Y' then
260: hr_utility.set_location(l_proc,10);
261: hr_utility.trace('no cache : g_pact_id('||g_payroll_action_id||'),p_pact_id('||p_payroll_action_id||')');
262: end if;
263: --
264: open csr_action;

Line 261: hr_utility.trace('no cache : g_pact_id('||g_payroll_action_id||'),p_pact_id('||p_payroll_action_id||')');

257: --
258: if g_debug
259: and g_detail_debug = 'Y' then
260: hr_utility.set_location(l_proc,10);
261: hr_utility.trace('no cache : g_pact_id('||g_payroll_action_id||'),p_pact_id('||p_payroll_action_id||')');
262: end if;
263: --
264: open csr_action;
265: fetch csr_action into l_csr_action;

Line 346: hr_utility.trace('g_payroll_action_id : '||to_char(g_payroll_action_id));

342: --
343: end if;
344: --
345: if g_debug then
346: hr_utility.trace('g_payroll_action_id : '||to_char(g_payroll_action_id));
347: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));
348: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
349: hr_utility.trace('g_legislation_code : '||g_legislation_code);
350: hr_utility.trace('g_inc_org_hier_flag : '||g_inc_org_hier_flag);

Line 347: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));

343: end if;
344: --
345: if g_debug then
346: hr_utility.trace('g_payroll_action_id : '||to_char(g_payroll_action_id));
347: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));
348: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
349: hr_utility.trace('g_legislation_code : '||g_legislation_code);
350: hr_utility.trace('g_inc_org_hier_flag : '||g_inc_org_hier_flag);
351: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));

Line 348: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));

344: --
345: if g_debug then
346: hr_utility.trace('g_payroll_action_id : '||to_char(g_payroll_action_id));
347: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));
348: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
349: hr_utility.trace('g_legislation_code : '||g_legislation_code);
350: hr_utility.trace('g_inc_org_hier_flag : '||g_inc_org_hier_flag);
351: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
352: hr_utility.trace('g_location_id : '||to_char(g_location_id));

Line 349: hr_utility.trace('g_legislation_code : '||g_legislation_code);

345: if g_debug then
346: hr_utility.trace('g_payroll_action_id : '||to_char(g_payroll_action_id));
347: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));
348: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
349: hr_utility.trace('g_legislation_code : '||g_legislation_code);
350: hr_utility.trace('g_inc_org_hier_flag : '||g_inc_org_hier_flag);
351: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
352: hr_utility.trace('g_location_id : '||to_char(g_location_id));
353: hr_utility.trace('g_inc_term_flag : '||g_inc_term_flag);

Line 350: hr_utility.trace('g_inc_org_hier_flag : '||g_inc_org_hier_flag);

346: hr_utility.trace('g_payroll_action_id : '||to_char(g_payroll_action_id));
347: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));
348: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
349: hr_utility.trace('g_legislation_code : '||g_legislation_code);
350: hr_utility.trace('g_inc_org_hier_flag : '||g_inc_org_hier_flag);
351: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
352: hr_utility.trace('g_location_id : '||to_char(g_location_id));
353: hr_utility.trace('g_inc_term_flag : '||g_inc_term_flag);
354: hr_utility.trace('g_term_date_from : '||to_char(g_term_date_from,'YYYY/MM/DD'));

Line 351: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));

347: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));
348: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
349: hr_utility.trace('g_legislation_code : '||g_legislation_code);
350: hr_utility.trace('g_inc_org_hier_flag : '||g_inc_org_hier_flag);
351: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
352: hr_utility.trace('g_location_id : '||to_char(g_location_id));
353: hr_utility.trace('g_inc_term_flag : '||g_inc_term_flag);
354: hr_utility.trace('g_term_date_from : '||to_char(g_term_date_from,'YYYY/MM/DD'));
355: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));

Line 352: hr_utility.trace('g_location_id : '||to_char(g_location_id));

348: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
349: hr_utility.trace('g_legislation_code : '||g_legislation_code);
350: hr_utility.trace('g_inc_org_hier_flag : '||g_inc_org_hier_flag);
351: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
352: hr_utility.trace('g_location_id : '||to_char(g_location_id));
353: hr_utility.trace('g_inc_term_flag : '||g_inc_term_flag);
354: hr_utility.trace('g_term_date_from : '||to_char(g_term_date_from,'YYYY/MM/DD'));
355: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
356: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));

Line 353: hr_utility.trace('g_inc_term_flag : '||g_inc_term_flag);

349: hr_utility.trace('g_legislation_code : '||g_legislation_code);
350: hr_utility.trace('g_inc_org_hier_flag : '||g_inc_org_hier_flag);
351: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
352: hr_utility.trace('g_location_id : '||to_char(g_location_id));
353: hr_utility.trace('g_inc_term_flag : '||g_inc_term_flag);
354: hr_utility.trace('g_term_date_from : '||to_char(g_term_date_from,'YYYY/MM/DD'));
355: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
356: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
357: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));

Line 354: hr_utility.trace('g_term_date_from : '||to_char(g_term_date_from,'YYYY/MM/DD'));

350: hr_utility.trace('g_inc_org_hier_flag : '||g_inc_org_hier_flag);
351: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
352: hr_utility.trace('g_location_id : '||to_char(g_location_id));
353: hr_utility.trace('g_inc_term_flag : '||g_inc_term_flag);
354: hr_utility.trace('g_term_date_from : '||to_char(g_term_date_from,'YYYY/MM/DD'));
355: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
356: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
357: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
358: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);

Line 355: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));

351: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
352: hr_utility.trace('g_location_id : '||to_char(g_location_id));
353: hr_utility.trace('g_inc_term_flag : '||g_inc_term_flag);
354: hr_utility.trace('g_term_date_from : '||to_char(g_term_date_from,'YYYY/MM/DD'));
355: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
356: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
357: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
358: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
359: hr_utility.trace('g_range_person : '||g_range_person);

Line 356: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));

352: hr_utility.trace('g_location_id : '||to_char(g_location_id));
353: hr_utility.trace('g_inc_term_flag : '||g_inc_term_flag);
354: hr_utility.trace('g_term_date_from : '||to_char(g_term_date_from,'YYYY/MM/DD'));
355: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
356: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
357: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
358: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
359: hr_utility.trace('g_range_person : '||g_range_person);
360: hr_utility.trace('c_jp_pea_flex_num : '||to_char(c_jp_pea_flex_num));

Line 357: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));

353: hr_utility.trace('g_inc_term_flag : '||g_inc_term_flag);
354: hr_utility.trace('g_term_date_from : '||to_char(g_term_date_from,'YYYY/MM/DD'));
355: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
356: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
357: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
358: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
359: hr_utility.trace('g_range_person : '||g_range_person);
360: hr_utility.trace('c_jp_pea_flex_num : '||to_char(c_jp_pea_flex_num));
361: hr_utility.trace('g_ext_proc_name : '||g_ext_proc_name);

Line 358: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);

354: hr_utility.trace('g_term_date_from : '||to_char(g_term_date_from,'YYYY/MM/DD'));
355: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
356: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
357: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
358: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
359: hr_utility.trace('g_range_person : '||g_range_person);
360: hr_utility.trace('c_jp_pea_flex_num : '||to_char(c_jp_pea_flex_num));
361: hr_utility.trace('g_ext_proc_name : '||g_ext_proc_name);
362: end if;

Line 359: hr_utility.trace('g_range_person : '||g_range_person);

355: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
356: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
357: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
358: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
359: hr_utility.trace('g_range_person : '||g_range_person);
360: hr_utility.trace('c_jp_pea_flex_num : '||to_char(c_jp_pea_flex_num));
361: hr_utility.trace('g_ext_proc_name : '||g_ext_proc_name);
362: end if;
363: --

Line 360: hr_utility.trace('c_jp_pea_flex_num : '||to_char(c_jp_pea_flex_num));

356: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
357: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
358: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
359: hr_utility.trace('g_range_person : '||g_range_person);
360: hr_utility.trace('c_jp_pea_flex_num : '||to_char(c_jp_pea_flex_num));
361: hr_utility.trace('g_ext_proc_name : '||g_ext_proc_name);
362: end if;
363: --
364: if g_debug

Line 361: hr_utility.trace('g_ext_proc_name : '||g_ext_proc_name);

357: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
358: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
359: hr_utility.trace('g_range_person : '||g_range_person);
360: hr_utility.trace('c_jp_pea_flex_num : '||to_char(c_jp_pea_flex_num));
361: hr_utility.trace('g_ext_proc_name : '||g_ext_proc_name);
362: end if;
363: --
364: if g_debug
365: and g_detail_debug = 'Y' then

Line 366: hr_utility.set_location(l_proc,1000);

362: end if;
363: --
364: if g_debug
365: and g_detail_debug = 'Y' then
366: hr_utility.set_location(l_proc,1000);
367: end if;
368: --
369: end init_pact;
370: --

Line 384: -- hr_utility.set_location(l_proc,0);

380: --begin
381: ----
382: -- if g_debug
383: -- and g_detail_debug = 'Y' then
384: -- hr_utility.set_location(l_proc,0);
385: -- end if;
386: ----
387: -- -- no create, update pact in mark for retry.
388: ----

Line 391: -- hr_utility.set_location(l_proc,1000);

387: -- -- no create, update pact in mark for retry.
388: ----
389: -- if g_debug
390: -- and g_detail_debug = 'Y' then
391: -- hr_utility.set_location(l_proc,1000);
392: -- end if;
393: ----
394: --end archive_pact;
395: --

Line 411: hr_utility.set_location(l_proc,0);

407: --
408: begin
409: --
410: if g_debug then
411: hr_utility.set_location(l_proc,0);
412: end if;
413: --
414: init_pact(p_payroll_action_id);
415: set_detail_debug(l_detail_debug);

Line 419: hr_utility.set_location(l_proc,10);

415: set_detail_debug(l_detail_debug);
416: --
417: if g_debug
418: and g_detail_debug = 'Y' then
419: hr_utility.set_location(l_proc,10);
420: end if;
421: --
422: --archive_pact(p_payroll_action_id);
423: --

Line 426: -- hr_utility.set_location(l_proc,20);

422: --archive_pact(p_payroll_action_id);
423: --
424: --if g_debug
425: --and g_detail_debug = 'Y' then
426: -- hr_utility.set_location(l_proc,20);
427: --end if;
428: --
429: -- consider security view, only employee target (ref ppos)
430: -- include any term emp whose final proc date is before effective date

Line 447: hr_utility.set_location(l_proc,1000);

443: --
444: p_sqlstr := replace(p_sqlstr,'i_effective_date',fnd_date.date_to_canonical(g_effective_date));
445: --
446: if g_debug then
447: hr_utility.set_location(l_proc,1000);
448: end if;
449: --
450: end range_code;
451: --

Line 793: hr_utility.set_location(l_proc,0);

789: --
790: if g_debug
791: and g_detail_debug = 'Y' then
792: l_assact_step := 0;
793: hr_utility.set_location(l_proc,0);
794: end if;
795: --
796: -- need set for multiple ranges.
797: init_pact(p_payroll_action_id);

Line 807: hr_utility.set_location(l_proc,10);

803: --
804: if g_debug
805: and g_detail_debug = 'Y' then
806: l_assact_step := 1;
807: hr_utility.set_location(l_proc,10);
808: end if;
809: --
810: if nvl(g_range_person,'N') = 'Y' then
811: --

Line 863: -- hr_utility.set_location(l_proc,20);

859: --
860: --if g_debug
861: --and g_detail_debug = 'Y' then
862: -- l_assact_step := 4;
863: -- hr_utility.set_location(l_proc,20);
864: -- hr_utility.trace('l_csr_proc_hasa_ppr_tbl.count : '||to_char(l_csr_proc_hasa_ppr_tbl.count));
865: --end if;
866: --
867: else

Line 864: -- hr_utility.trace('l_csr_proc_hasa_ppr_tbl.count : '||to_char(l_csr_proc_hasa_ppr_tbl.count));

860: --if g_debug
861: --and g_detail_debug = 'Y' then
862: -- l_assact_step := 4;
863: -- hr_utility.set_location(l_proc,20);
864: -- hr_utility.trace('l_csr_proc_hasa_ppr_tbl.count : '||to_char(l_csr_proc_hasa_ppr_tbl.count));
865: --end if;
866: --
867: else
868: --

Line 916: -- hr_utility.set_location(l_proc,30);

912: --
913: --if g_debug
914: --and g_detail_debug = 'Y' then
915: -- l_assact_step := 7;
916: -- hr_utility.set_location(l_proc,30);
917: -- hr_utility.trace('l_csr_proc_ass_ppr_tbl.count : '||to_char(l_csr_proc_ass_ppr_tbl.count));
918: --end if;
919: --
920: end if;

Line 917: -- hr_utility.trace('l_csr_proc_ass_ppr_tbl.count : '||to_char(l_csr_proc_ass_ppr_tbl.count));

913: --if g_debug
914: --and g_detail_debug = 'Y' then
915: -- l_assact_step := 7;
916: -- hr_utility.set_location(l_proc,30);
917: -- hr_utility.trace('l_csr_proc_ass_ppr_tbl.count : '||to_char(l_csr_proc_ass_ppr_tbl.count));
918: --end if;
919: --
920: end if;
921: --

Line 975: -- hr_utility.set_location(l_proc,40);

971: --
972: --if g_debug
973: --and g_detail_debug = 'Y' then
974: -- l_assact_step := 10;
975: -- hr_utility.set_location(l_proc,40);
976: -- hr_utility.trace('l_csr_proc_hasa_tbl.count : '||to_char(l_csr_proc_hasa_tbl.count));
977: --end if;
978: --
979: else

Line 976: -- hr_utility.trace('l_csr_proc_hasa_tbl.count : '||to_char(l_csr_proc_hasa_tbl.count));

972: --if g_debug
973: --and g_detail_debug = 'Y' then
974: -- l_assact_step := 10;
975: -- hr_utility.set_location(l_proc,40);
976: -- hr_utility.trace('l_csr_proc_hasa_tbl.count : '||to_char(l_csr_proc_hasa_tbl.count));
977: --end if;
978: --
979: else
980: --

Line 1028: -- hr_utility.set_location(l_proc,50);

1024: --
1025: --if g_debug
1026: --and g_detail_debug = 'Y' then
1027: -- l_assact_step := 13;
1028: -- hr_utility.set_location(l_proc,50);
1029: -- hr_utility.trace('l_csr_proc_ass_tbl.count : '||to_char(l_csr_proc_ass_tbl.count));
1030: --end if;
1031: --
1032: end if;

Line 1029: -- hr_utility.trace('l_csr_proc_ass_tbl.count : '||to_char(l_csr_proc_ass_tbl.count));

1025: --if g_debug
1026: --and g_detail_debug = 'Y' then
1027: -- l_assact_step := 13;
1028: -- hr_utility.set_location(l_proc,50);
1029: -- hr_utility.trace('l_csr_proc_ass_tbl.count : '||to_char(l_csr_proc_ass_tbl.count));
1030: --end if;
1031: --
1032: end if;
1033: --

Line 1039: hr_utility.set_location(l_proc,60);

1035: --
1036: if g_debug
1037: and g_detail_debug = 'Y' then
1038: l_assact_step := 14;
1039: hr_utility.set_location(l_proc,60);
1040: hr_utility.trace('g_ass_tbl.count : '||to_char(g_ass_tbl.count));
1041: hr_utility.trace('l_ass_tbl_cnt : '||to_char(l_ass_tbl_cnt));
1042: end if;
1043: --

Line 1040: hr_utility.trace('g_ass_tbl.count : '||to_char(g_ass_tbl.count));

1036: if g_debug
1037: and g_detail_debug = 'Y' then
1038: l_assact_step := 14;
1039: hr_utility.set_location(l_proc,60);
1040: hr_utility.trace('g_ass_tbl.count : '||to_char(g_ass_tbl.count));
1041: hr_utility.trace('l_ass_tbl_cnt : '||to_char(l_ass_tbl_cnt));
1042: end if;
1043: --
1044: if g_ass_tbl.count > 0 then

Line 1041: hr_utility.trace('l_ass_tbl_cnt : '||to_char(l_ass_tbl_cnt));

1037: and g_detail_debug = 'Y' then
1038: l_assact_step := 14;
1039: hr_utility.set_location(l_proc,60);
1040: hr_utility.trace('g_ass_tbl.count : '||to_char(g_ass_tbl.count));
1041: hr_utility.trace('l_ass_tbl_cnt : '||to_char(l_ass_tbl_cnt));
1042: end if;
1043: --
1044: if g_ass_tbl.count > 0 then
1045: --

Line 1088: hr_utility.trace('g_ass_tbl.count is 0 : '||to_char(g_ass_tbl.count));

1084: end if;
1085: --
1086: else
1087: --
1088: hr_utility.trace('g_ass_tbl.count is 0 : '||to_char(g_ass_tbl.count));
1089: --
1090: if g_debug
1091: and g_detail_debug = 'Y' then
1092: l_assact_step := 17;

Line 1101: hr_utility.set_location(l_proc,70);

1097: if g_debug
1098: and g_detail_debug = 'Y' then
1099: --
1100: l_assact_step := 18;
1101: hr_utility.set_location(l_proc,70);
1102: hr_utility.trace('p_start_person_id : '||to_char(p_start_person_id));
1103: hr_utility.trace('p_end_person_id : '||to_char(p_end_person_id));
1104: hr_utility.trace('p_chunk_number : '||to_char(p_chunk_number));
1105: --

Line 1102: hr_utility.trace('p_start_person_id : '||to_char(p_start_person_id));

1098: and g_detail_debug = 'Y' then
1099: --
1100: l_assact_step := 18;
1101: hr_utility.set_location(l_proc,70);
1102: hr_utility.trace('p_start_person_id : '||to_char(p_start_person_id));
1103: hr_utility.trace('p_end_person_id : '||to_char(p_end_person_id));
1104: hr_utility.trace('p_chunk_number : '||to_char(p_chunk_number));
1105: --
1106: hr_utility.trace('g_ass_tbl.count : '||to_char(g_ass_tbl.count));

Line 1103: hr_utility.trace('p_end_person_id : '||to_char(p_end_person_id));

1099: --
1100: l_assact_step := 18;
1101: hr_utility.set_location(l_proc,70);
1102: hr_utility.trace('p_start_person_id : '||to_char(p_start_person_id));
1103: hr_utility.trace('p_end_person_id : '||to_char(p_end_person_id));
1104: hr_utility.trace('p_chunk_number : '||to_char(p_chunk_number));
1105: --
1106: hr_utility.trace('g_ass_tbl.count : '||to_char(g_ass_tbl.count));
1107: hr_utility.trace('g_per_ind_tbl.count : '||to_char(g_per_ind_tbl.count));

Line 1104: hr_utility.trace('p_chunk_number : '||to_char(p_chunk_number));

1100: l_assact_step := 18;
1101: hr_utility.set_location(l_proc,70);
1102: hr_utility.trace('p_start_person_id : '||to_char(p_start_person_id));
1103: hr_utility.trace('p_end_person_id : '||to_char(p_end_person_id));
1104: hr_utility.trace('p_chunk_number : '||to_char(p_chunk_number));
1105: --
1106: hr_utility.trace('g_ass_tbl.count : '||to_char(g_ass_tbl.count));
1107: hr_utility.trace('g_per_ind_tbl.count : '||to_char(g_per_ind_tbl.count));
1108: --

Line 1106: hr_utility.trace('g_ass_tbl.count : '||to_char(g_ass_tbl.count));

1102: hr_utility.trace('p_start_person_id : '||to_char(p_start_person_id));
1103: hr_utility.trace('p_end_person_id : '||to_char(p_end_person_id));
1104: hr_utility.trace('p_chunk_number : '||to_char(p_chunk_number));
1105: --
1106: hr_utility.trace('g_ass_tbl.count : '||to_char(g_ass_tbl.count));
1107: hr_utility.trace('g_per_ind_tbl.count : '||to_char(g_per_ind_tbl.count));
1108: --
1109: if g_ass_tbl.count > 0 then
1110: hr_utility.trace('g_ass_tbl.first : '||to_char(g_ass_tbl.first));

Line 1107: hr_utility.trace('g_per_ind_tbl.count : '||to_char(g_per_ind_tbl.count));

1103: hr_utility.trace('p_end_person_id : '||to_char(p_end_person_id));
1104: hr_utility.trace('p_chunk_number : '||to_char(p_chunk_number));
1105: --
1106: hr_utility.trace('g_ass_tbl.count : '||to_char(g_ass_tbl.count));
1107: hr_utility.trace('g_per_ind_tbl.count : '||to_char(g_per_ind_tbl.count));
1108: --
1109: if g_ass_tbl.count > 0 then
1110: hr_utility.trace('g_ass_tbl.first : '||to_char(g_ass_tbl.first));
1111: hr_utility.trace('g_ass_tbl.last : '||to_char(g_ass_tbl.last));

Line 1110: hr_utility.trace('g_ass_tbl.first : '||to_char(g_ass_tbl.first));

1106: hr_utility.trace('g_ass_tbl.count : '||to_char(g_ass_tbl.count));
1107: hr_utility.trace('g_per_ind_tbl.count : '||to_char(g_per_ind_tbl.count));
1108: --
1109: if g_ass_tbl.count > 0 then
1110: hr_utility.trace('g_ass_tbl.first : '||to_char(g_ass_tbl.first));
1111: hr_utility.trace('g_ass_tbl.last : '||to_char(g_ass_tbl.last));
1112: hr_utility.trace('g_ass_tbl(g_ass_tbl.first).person_id : '||to_char(g_ass_tbl(g_ass_tbl.first).person_id));
1113: hr_utility.trace('g_ass_tbl(g_ass_tbl.last).person_id : '||to_char(g_ass_tbl(g_ass_tbl.last).person_id));
1114: end if;

Line 1111: hr_utility.trace('g_ass_tbl.last : '||to_char(g_ass_tbl.last));

1107: hr_utility.trace('g_per_ind_tbl.count : '||to_char(g_per_ind_tbl.count));
1108: --
1109: if g_ass_tbl.count > 0 then
1110: hr_utility.trace('g_ass_tbl.first : '||to_char(g_ass_tbl.first));
1111: hr_utility.trace('g_ass_tbl.last : '||to_char(g_ass_tbl.last));
1112: hr_utility.trace('g_ass_tbl(g_ass_tbl.first).person_id : '||to_char(g_ass_tbl(g_ass_tbl.first).person_id));
1113: hr_utility.trace('g_ass_tbl(g_ass_tbl.last).person_id : '||to_char(g_ass_tbl(g_ass_tbl.last).person_id));
1114: end if;
1115: --

Line 1112: hr_utility.trace('g_ass_tbl(g_ass_tbl.first).person_id : '||to_char(g_ass_tbl(g_ass_tbl.first).person_id));

1108: --
1109: if g_ass_tbl.count > 0 then
1110: hr_utility.trace('g_ass_tbl.first : '||to_char(g_ass_tbl.first));
1111: hr_utility.trace('g_ass_tbl.last : '||to_char(g_ass_tbl.last));
1112: hr_utility.trace('g_ass_tbl(g_ass_tbl.first).person_id : '||to_char(g_ass_tbl(g_ass_tbl.first).person_id));
1113: hr_utility.trace('g_ass_tbl(g_ass_tbl.last).person_id : '||to_char(g_ass_tbl(g_ass_tbl.last).person_id));
1114: end if;
1115: --
1116: if g_per_ind_tbl.count > 0 then

Line 1113: hr_utility.trace('g_ass_tbl(g_ass_tbl.last).person_id : '||to_char(g_ass_tbl(g_ass_tbl.last).person_id));

1109: if g_ass_tbl.count > 0 then
1110: hr_utility.trace('g_ass_tbl.first : '||to_char(g_ass_tbl.first));
1111: hr_utility.trace('g_ass_tbl.last : '||to_char(g_ass_tbl.last));
1112: hr_utility.trace('g_ass_tbl(g_ass_tbl.first).person_id : '||to_char(g_ass_tbl(g_ass_tbl.first).person_id));
1113: hr_utility.trace('g_ass_tbl(g_ass_tbl.last).person_id : '||to_char(g_ass_tbl(g_ass_tbl.last).person_id));
1114: end if;
1115: --
1116: if g_per_ind_tbl.count > 0 then
1117: hr_utility.trace('g_per_ind_tbl.first : '||to_char(g_per_ind_tbl.first));

Line 1117: hr_utility.trace('g_per_ind_tbl.first : '||to_char(g_per_ind_tbl.first));

1113: hr_utility.trace('g_ass_tbl(g_ass_tbl.last).person_id : '||to_char(g_ass_tbl(g_ass_tbl.last).person_id));
1114: end if;
1115: --
1116: if g_per_ind_tbl.count > 0 then
1117: hr_utility.trace('g_per_ind_tbl.first : '||to_char(g_per_ind_tbl.first));
1118: hr_utility.trace('g_per_ind_tbl.last : '||to_char(g_per_ind_tbl.last));
1119: hr_utility.trace('g_per_ind_tbl(g_per_ind_tbl.first).person_id : '||to_char(g_per_ind_tbl(g_per_ind_tbl.first).person_id));
1120: hr_utility.trace('g_per_ind_tbl(g_per_ind_tbl.last).person_id : '||to_char(g_per_ind_tbl(g_per_ind_tbl.last).person_id));
1121: end if;

Line 1118: hr_utility.trace('g_per_ind_tbl.last : '||to_char(g_per_ind_tbl.last));

1114: end if;
1115: --
1116: if g_per_ind_tbl.count > 0 then
1117: hr_utility.trace('g_per_ind_tbl.first : '||to_char(g_per_ind_tbl.first));
1118: hr_utility.trace('g_per_ind_tbl.last : '||to_char(g_per_ind_tbl.last));
1119: hr_utility.trace('g_per_ind_tbl(g_per_ind_tbl.first).person_id : '||to_char(g_per_ind_tbl(g_per_ind_tbl.first).person_id));
1120: hr_utility.trace('g_per_ind_tbl(g_per_ind_tbl.last).person_id : '||to_char(g_per_ind_tbl(g_per_ind_tbl.last).person_id));
1121: end if;
1122: --

Line 1119: hr_utility.trace('g_per_ind_tbl(g_per_ind_tbl.first).person_id : '||to_char(g_per_ind_tbl(g_per_ind_tbl.first).person_id));

1115: --
1116: if g_per_ind_tbl.count > 0 then
1117: hr_utility.trace('g_per_ind_tbl.first : '||to_char(g_per_ind_tbl.first));
1118: hr_utility.trace('g_per_ind_tbl.last : '||to_char(g_per_ind_tbl.last));
1119: hr_utility.trace('g_per_ind_tbl(g_per_ind_tbl.first).person_id : '||to_char(g_per_ind_tbl(g_per_ind_tbl.first).person_id));
1120: hr_utility.trace('g_per_ind_tbl(g_per_ind_tbl.last).person_id : '||to_char(g_per_ind_tbl(g_per_ind_tbl.last).person_id));
1121: end if;
1122: --
1123: end if;

Line 1120: hr_utility.trace('g_per_ind_tbl(g_per_ind_tbl.last).person_id : '||to_char(g_per_ind_tbl(g_per_ind_tbl.last).person_id));

1116: if g_per_ind_tbl.count > 0 then
1117: hr_utility.trace('g_per_ind_tbl.first : '||to_char(g_per_ind_tbl.first));
1118: hr_utility.trace('g_per_ind_tbl.last : '||to_char(g_per_ind_tbl.last));
1119: hr_utility.trace('g_per_ind_tbl(g_per_ind_tbl.first).person_id : '||to_char(g_per_ind_tbl(g_per_ind_tbl.first).person_id));
1120: hr_utility.trace('g_per_ind_tbl(g_per_ind_tbl.last).person_id : '||to_char(g_per_ind_tbl(g_per_ind_tbl.last).person_id));
1121: end if;
1122: --
1123: end if;
1124: --

Line 1131: hr_utility.set_location(l_proc,80);

1127: --
1128: if g_debug
1129: and g_detail_debug = 'Y' then
1130: l_assact_step := 19;
1131: hr_utility.set_location(l_proc,80);
1132: end if;
1133: --
1134: <>
1135: for j in p_start_person_id..p_end_person_id loop

Line 1205: hr_utility.trace('j person_id : '||to_char(j));

1201: --
1202: if g_debug
1203: and g_detail_debug = 'Y' then
1204: l_assact_step := 24;
1205: hr_utility.trace('j person_id : '||to_char(j));
1206: hr_utility.trace('l_ass_id_tbl_cnt : '||to_char(l_ass_id_tbl_cnt));
1207: hr_utility.trace('l_ass_id_tbl.count : '||to_char(l_ass_id_tbl.count));
1208: end if;
1209: --

Line 1206: hr_utility.trace('l_ass_id_tbl_cnt : '||to_char(l_ass_id_tbl_cnt));

1202: if g_debug
1203: and g_detail_debug = 'Y' then
1204: l_assact_step := 24;
1205: hr_utility.trace('j person_id : '||to_char(j));
1206: hr_utility.trace('l_ass_id_tbl_cnt : '||to_char(l_ass_id_tbl_cnt));
1207: hr_utility.trace('l_ass_id_tbl.count : '||to_char(l_ass_id_tbl.count));
1208: end if;
1209: --
1210: if l_ass_id_tbl.count > 0 then

Line 1207: hr_utility.trace('l_ass_id_tbl.count : '||to_char(l_ass_id_tbl.count));

1203: and g_detail_debug = 'Y' then
1204: l_assact_step := 24;
1205: hr_utility.trace('j person_id : '||to_char(j));
1206: hr_utility.trace('l_ass_id_tbl_cnt : '||to_char(l_ass_id_tbl_cnt));
1207: hr_utility.trace('l_ass_id_tbl.count : '||to_char(l_ass_id_tbl.count));
1208: end if;
1209: --
1210: if l_ass_id_tbl.count > 0 then
1211: --

Line 1269: hr_utility.set_location(l_proc,90);

1265: --
1266: if g_debug
1267: and g_detail_debug = 'Y' then
1268: l_assact_step := 30;
1269: hr_utility.set_location(l_proc,90);
1270: hr_utility.trace('person_id : '||to_char(g_ass_ind_tbl(l_ass_id_tbl(t)).person_id));
1271: hr_utility.trace('assignment_id : '||to_char(g_ass_ind_tbl(l_ass_id_tbl(t)).assignment_id));
1272: end if;
1273: --

Line 1270: hr_utility.trace('person_id : '||to_char(g_ass_ind_tbl(l_ass_id_tbl(t)).person_id));

1266: if g_debug
1267: and g_detail_debug = 'Y' then
1268: l_assact_step := 30;
1269: hr_utility.set_location(l_proc,90);
1270: hr_utility.trace('person_id : '||to_char(g_ass_ind_tbl(l_ass_id_tbl(t)).person_id));
1271: hr_utility.trace('assignment_id : '||to_char(g_ass_ind_tbl(l_ass_id_tbl(t)).assignment_id));
1272: end if;
1273: --
1274: end if;

Line 1271: hr_utility.trace('assignment_id : '||to_char(g_ass_ind_tbl(l_ass_id_tbl(t)).assignment_id));

1267: and g_detail_debug = 'Y' then
1268: l_assact_step := 30;
1269: hr_utility.set_location(l_proc,90);
1270: hr_utility.trace('person_id : '||to_char(g_ass_ind_tbl(l_ass_id_tbl(t)).person_id));
1271: hr_utility.trace('assignment_id : '||to_char(g_ass_ind_tbl(l_ass_id_tbl(t)).assignment_id));
1272: end if;
1273: --
1274: end if;
1275: --

Line 1285: hr_utility.trace('l_ass_id_tbl.count is 0 : '||to_char(l_ass_id_tbl.count));

1281: and g_detail_debug = 'Y' then
1282: l_assact_step := 31;
1283: end if;
1284: --
1285: hr_utility.trace('l_ass_id_tbl.count is 0 : '||to_char(l_ass_id_tbl.count));
1286: --
1287: end if;
1288: --
1289: if g_debug

Line 1313: hr_utility.set_location(l_proc,100);

1309: --
1310: if g_debug
1311: and g_detail_debug = 'Y' then
1312: l_assact_step := 35;
1313: hr_utility.set_location(l_proc,100);
1314: end if;
1315: --
1316: hr_utility.trace('g_per_ind_tbl.count is 0 : '||to_char(g_per_ind_tbl.count));
1317: hr_utility.trace('g_ass_tbl.count is 0 : '||to_char(g_ass_tbl.count));

Line 1316: hr_utility.trace('g_per_ind_tbl.count is 0 : '||to_char(g_per_ind_tbl.count));

1312: l_assact_step := 35;
1313: hr_utility.set_location(l_proc,100);
1314: end if;
1315: --
1316: hr_utility.trace('g_per_ind_tbl.count is 0 : '||to_char(g_per_ind_tbl.count));
1317: hr_utility.trace('g_ass_tbl.count is 0 : '||to_char(g_ass_tbl.count));
1318: --
1319: end if;
1320: --

Line 1317: hr_utility.trace('g_ass_tbl.count is 0 : '||to_char(g_ass_tbl.count));

1313: hr_utility.set_location(l_proc,100);
1314: end if;
1315: --
1316: hr_utility.trace('g_per_ind_tbl.count is 0 : '||to_char(g_per_ind_tbl.count));
1317: hr_utility.trace('g_ass_tbl.count is 0 : '||to_char(g_ass_tbl.count));
1318: --
1319: end if;
1320: --
1321: if g_debug

Line 1324: hr_utility.trace('assact_step : '||to_char(l_assact_step));

1320: --
1321: if g_debug
1322: and g_detail_debug = 'Y' then
1323: l_assact_step := 1000;
1324: hr_utility.trace('assact_step : '||to_char(l_assact_step));
1325: hr_utility.set_location(l_proc,1000);
1326: end if;
1327: --
1328: exception

Line 1325: hr_utility.set_location(l_proc,1000);

1321: if g_debug
1322: and g_detail_debug = 'Y' then
1323: l_assact_step := 1000;
1324: hr_utility.trace('assact_step : '||to_char(l_assact_step));
1325: hr_utility.set_location(l_proc,1000);
1326: end if;
1327: --
1328: exception
1329: when others then

Line 1334: hr_utility.trace('assignment_action_creation error : '||l_error_code||' : '||l_error_mesg);

1330: --
1331: l_error_code := sqlcode;
1332: l_error_mesg := substrb(sqlerrm,1,100);
1333: --
1334: hr_utility.trace('assignment_action_creation error : '||l_error_code||' : '||l_error_mesg);
1335: --
1336: if g_debug
1337: and g_detail_debug = 'Y' then
1338: hr_utility.trace('assact_step : '||to_char(l_assact_step));

Line 1338: hr_utility.trace('assact_step : '||to_char(l_assact_step));

1334: hr_utility.trace('assignment_action_creation error : '||l_error_code||' : '||l_error_mesg);
1335: --
1336: if g_debug
1337: and g_detail_debug = 'Y' then
1338: hr_utility.trace('assact_step : '||to_char(l_assact_step));
1339: end if;
1340: --
1341: raise;
1342: --

Line 1357: hr_utility.set_location(l_proc,0);

1353: --
1354: begin
1355: --
1356: if g_debug then
1357: hr_utility.set_location(l_proc,0);
1358: end if;
1359: --
1360: -- invoke for mark for retry.
1361: init_pact(p_payroll_action_id);

Line 1365: hr_utility.set_location(l_proc,1000);

1361: init_pact(p_payroll_action_id);
1362: --
1363: if g_debug then
1364: --
1365: hr_utility.set_location(l_proc,1000);
1366: --
1367: end if;
1368: --
1369: end initialization_code;

Line 1384: -- hr_utility.set_location(l_proc,0);

1380: ----
1381: --begin
1382: ----
1383: -- if g_debug then
1384: -- hr_utility.set_location(l_proc,0);
1385: -- end if;
1386: -- --
1387: -- if g_debug then
1388: -- hr_utility.set_location(l_proc,1000);

Line 1388: -- hr_utility.set_location(l_proc,1000);

1384: -- hr_utility.set_location(l_proc,0);
1385: -- end if;
1386: -- --
1387: -- if g_debug then
1388: -- hr_utility.set_location(l_proc,1000);
1389: -- end if;
1390: ----
1391: --end init_assact;
1392: --

Line 1927: hr_utility.set_location(l_proc,0);

1923: --
1924: begin
1925: --
1926: if g_debug then
1927: hr_utility.set_location(l_proc,0);
1928: hr_utility.trace('p_assignment_action_id : '||to_char(p_assignment_action_id));
1929: l_archive_step := 0;
1930: end if;
1931: --

Line 1928: hr_utility.trace('p_assignment_action_id : '||to_char(p_assignment_action_id));

1924: begin
1925: --
1926: if g_debug then
1927: hr_utility.set_location(l_proc,0);
1928: hr_utility.trace('p_assignment_action_id : '||to_char(p_assignment_action_id));
1929: l_archive_step := 0;
1930: end if;
1931: --
1932: -- ---------------------------------------------

Line 1948: hr_utility.set_location(l_proc,10);

1944: --
1945: if g_debug
1946: and g_detail_debug = 'Y' then
1947: l_archive_step := 1;
1948: hr_utility.set_location(l_proc,10);
1949: hr_utility.trace('l_person_id : '||to_char(l_person_id));
1950: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1951: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1952: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);

Line 1949: hr_utility.trace('l_person_id : '||to_char(l_person_id));

1945: if g_debug
1946: and g_detail_debug = 'Y' then
1947: l_archive_step := 1;
1948: hr_utility.set_location(l_proc,10);
1949: hr_utility.trace('l_person_id : '||to_char(l_person_id));
1950: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1951: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1952: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1953: hr_utility.trace('l_effective_date_ass : '||to_char(l_effective_date_ass,'YYYY/MM/DD'));

Line 1950: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);

1946: and g_detail_debug = 'Y' then
1947: l_archive_step := 1;
1948: hr_utility.set_location(l_proc,10);
1949: hr_utility.trace('l_person_id : '||to_char(l_person_id));
1950: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1951: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1952: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1953: hr_utility.trace('l_effective_date_ass : '||to_char(l_effective_date_ass,'YYYY/MM/DD'));
1954: hr_utility.trace('l_effective_date_proc : '||to_char(l_effective_date_proc,'YYYY/MM/DD'));

Line 1951: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);

1947: l_archive_step := 1;
1948: hr_utility.set_location(l_proc,10);
1949: hr_utility.trace('l_person_id : '||to_char(l_person_id));
1950: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1951: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1952: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1953: hr_utility.trace('l_effective_date_ass : '||to_char(l_effective_date_ass,'YYYY/MM/DD'));
1954: hr_utility.trace('l_effective_date_proc : '||to_char(l_effective_date_proc,'YYYY/MM/DD'));
1955: hr_utility.trace('l_hire_date : '||to_char(l_hire_date,'YYYY/MM/DD'));

Line 1952: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);

1948: hr_utility.set_location(l_proc,10);
1949: hr_utility.trace('l_person_id : '||to_char(l_person_id));
1950: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1951: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1952: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1953: hr_utility.trace('l_effective_date_ass : '||to_char(l_effective_date_ass,'YYYY/MM/DD'));
1954: hr_utility.trace('l_effective_date_proc : '||to_char(l_effective_date_proc,'YYYY/MM/DD'));
1955: hr_utility.trace('l_hire_date : '||to_char(l_hire_date,'YYYY/MM/DD'));
1956: end if;

Line 1953: hr_utility.trace('l_effective_date_ass : '||to_char(l_effective_date_ass,'YYYY/MM/DD'));

1949: hr_utility.trace('l_person_id : '||to_char(l_person_id));
1950: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1951: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1952: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1953: hr_utility.trace('l_effective_date_ass : '||to_char(l_effective_date_ass,'YYYY/MM/DD'));
1954: hr_utility.trace('l_effective_date_proc : '||to_char(l_effective_date_proc,'YYYY/MM/DD'));
1955: hr_utility.trace('l_hire_date : '||to_char(l_hire_date,'YYYY/MM/DD'));
1956: end if;
1957: --

Line 1954: hr_utility.trace('l_effective_date_proc : '||to_char(l_effective_date_proc,'YYYY/MM/DD'));

1950: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1951: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1952: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1953: hr_utility.trace('l_effective_date_ass : '||to_char(l_effective_date_ass,'YYYY/MM/DD'));
1954: hr_utility.trace('l_effective_date_proc : '||to_char(l_effective_date_proc,'YYYY/MM/DD'));
1955: hr_utility.trace('l_hire_date : '||to_char(l_hire_date,'YYYY/MM/DD'));
1956: end if;
1957: --
1958: l_emp_hi_num := pay_jp_balance_pkg.get_entry_value_char(c_hi_card_num_iv_id,p_assignment_id,l_effective_date_ass);

Line 1955: hr_utility.trace('l_hire_date : '||to_char(l_hire_date,'YYYY/MM/DD'));

1951: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1952: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1953: hr_utility.trace('l_effective_date_ass : '||to_char(l_effective_date_ass,'YYYY/MM/DD'));
1954: hr_utility.trace('l_effective_date_proc : '||to_char(l_effective_date_proc,'YYYY/MM/DD'));
1955: hr_utility.trace('l_hire_date : '||to_char(l_hire_date,'YYYY/MM/DD'));
1956: end if;
1957: --
1958: l_emp_hi_num := pay_jp_balance_pkg.get_entry_value_char(c_hi_card_num_iv_id,p_assignment_id,l_effective_date_ass);
1959: l_emp_wp_num := pay_jp_balance_pkg.get_entry_value_char(c_basic_pension_num_iv_id,p_assignment_id,l_effective_date_ass);

Line 1970: hr_utility.set_location(l_proc,20);

1966: --
1967: if g_debug
1968: and g_detail_debug = 'Y' then
1969: l_archive_step := 2;
1970: hr_utility.set_location(l_proc,20);
1971: hr_utility.trace('l_emp_hi_num : '||l_emp_hi_num);
1972: hr_utility.trace('l_emp_wp_num : '||l_emp_wp_num);
1973: hr_utility.trace('l_emp_wpf_num : '||l_emp_wpf_num);
1974: hr_utility.trace('l_emp_ei_num : '||l_emp_ei_num);

Line 1971: hr_utility.trace('l_emp_hi_num : '||l_emp_hi_num);

1967: if g_debug
1968: and g_detail_debug = 'Y' then
1969: l_archive_step := 2;
1970: hr_utility.set_location(l_proc,20);
1971: hr_utility.trace('l_emp_hi_num : '||l_emp_hi_num);
1972: hr_utility.trace('l_emp_wp_num : '||l_emp_wp_num);
1973: hr_utility.trace('l_emp_wpf_num : '||l_emp_wpf_num);
1974: hr_utility.trace('l_emp_ei_num : '||l_emp_ei_num);
1975: hr_utility.trace('l_emp_hi_qd : '||to_char(l_emp_hi_qd,'YYYY/MM/DD'));

Line 1972: hr_utility.trace('l_emp_wp_num : '||l_emp_wp_num);

1968: and g_detail_debug = 'Y' then
1969: l_archive_step := 2;
1970: hr_utility.set_location(l_proc,20);
1971: hr_utility.trace('l_emp_hi_num : '||l_emp_hi_num);
1972: hr_utility.trace('l_emp_wp_num : '||l_emp_wp_num);
1973: hr_utility.trace('l_emp_wpf_num : '||l_emp_wpf_num);
1974: hr_utility.trace('l_emp_ei_num : '||l_emp_ei_num);
1975: hr_utility.trace('l_emp_hi_qd : '||to_char(l_emp_hi_qd,'YYYY/MM/DD'));
1976: hr_utility.trace('l_emp_wp_qd : '||to_char(l_emp_wp_qd,'YYYY/MM/DD'));

Line 1973: hr_utility.trace('l_emp_wpf_num : '||l_emp_wpf_num);

1969: l_archive_step := 2;
1970: hr_utility.set_location(l_proc,20);
1971: hr_utility.trace('l_emp_hi_num : '||l_emp_hi_num);
1972: hr_utility.trace('l_emp_wp_num : '||l_emp_wp_num);
1973: hr_utility.trace('l_emp_wpf_num : '||l_emp_wpf_num);
1974: hr_utility.trace('l_emp_ei_num : '||l_emp_ei_num);
1975: hr_utility.trace('l_emp_hi_qd : '||to_char(l_emp_hi_qd,'YYYY/MM/DD'));
1976: hr_utility.trace('l_emp_wp_qd : '||to_char(l_emp_wp_qd,'YYYY/MM/DD'));
1977: hr_utility.trace('l_emp_wpf_qd : '||to_char(l_emp_wpf_qd,'YYYY/MM/DD'));

Line 1974: hr_utility.trace('l_emp_ei_num : '||l_emp_ei_num);

1970: hr_utility.set_location(l_proc,20);
1971: hr_utility.trace('l_emp_hi_num : '||l_emp_hi_num);
1972: hr_utility.trace('l_emp_wp_num : '||l_emp_wp_num);
1973: hr_utility.trace('l_emp_wpf_num : '||l_emp_wpf_num);
1974: hr_utility.trace('l_emp_ei_num : '||l_emp_ei_num);
1975: hr_utility.trace('l_emp_hi_qd : '||to_char(l_emp_hi_qd,'YYYY/MM/DD'));
1976: hr_utility.trace('l_emp_wp_qd : '||to_char(l_emp_wp_qd,'YYYY/MM/DD'));
1977: hr_utility.trace('l_emp_wpf_qd : '||to_char(l_emp_wpf_qd,'YYYY/MM/DD'));
1978: hr_utility.trace('l_emp_ei_qd : '||to_char(l_emp_ei_qd,'YYYY/MM/DD'));

Line 1975: hr_utility.trace('l_emp_hi_qd : '||to_char(l_emp_hi_qd,'YYYY/MM/DD'));

1971: hr_utility.trace('l_emp_hi_num : '||l_emp_hi_num);
1972: hr_utility.trace('l_emp_wp_num : '||l_emp_wp_num);
1973: hr_utility.trace('l_emp_wpf_num : '||l_emp_wpf_num);
1974: hr_utility.trace('l_emp_ei_num : '||l_emp_ei_num);
1975: hr_utility.trace('l_emp_hi_qd : '||to_char(l_emp_hi_qd,'YYYY/MM/DD'));
1976: hr_utility.trace('l_emp_wp_qd : '||to_char(l_emp_wp_qd,'YYYY/MM/DD'));
1977: hr_utility.trace('l_emp_wpf_qd : '||to_char(l_emp_wpf_qd,'YYYY/MM/DD'));
1978: hr_utility.trace('l_emp_ei_qd : '||to_char(l_emp_ei_qd,'YYYY/MM/DD'));
1979: hr_utility.trace('l_csr_emp.term_date : '||to_char(l_csr_emp.term_date,'YYYY/MM/DD'));

Line 1976: hr_utility.trace('l_emp_wp_qd : '||to_char(l_emp_wp_qd,'YYYY/MM/DD'));

1972: hr_utility.trace('l_emp_wp_num : '||l_emp_wp_num);
1973: hr_utility.trace('l_emp_wpf_num : '||l_emp_wpf_num);
1974: hr_utility.trace('l_emp_ei_num : '||l_emp_ei_num);
1975: hr_utility.trace('l_emp_hi_qd : '||to_char(l_emp_hi_qd,'YYYY/MM/DD'));
1976: hr_utility.trace('l_emp_wp_qd : '||to_char(l_emp_wp_qd,'YYYY/MM/DD'));
1977: hr_utility.trace('l_emp_wpf_qd : '||to_char(l_emp_wpf_qd,'YYYY/MM/DD'));
1978: hr_utility.trace('l_emp_ei_qd : '||to_char(l_emp_ei_qd,'YYYY/MM/DD'));
1979: hr_utility.trace('l_csr_emp.term_date : '||to_char(l_csr_emp.term_date,'YYYY/MM/DD'));
1980: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));

Line 1977: hr_utility.trace('l_emp_wpf_qd : '||to_char(l_emp_wpf_qd,'YYYY/MM/DD'));

1973: hr_utility.trace('l_emp_wpf_num : '||l_emp_wpf_num);
1974: hr_utility.trace('l_emp_ei_num : '||l_emp_ei_num);
1975: hr_utility.trace('l_emp_hi_qd : '||to_char(l_emp_hi_qd,'YYYY/MM/DD'));
1976: hr_utility.trace('l_emp_wp_qd : '||to_char(l_emp_wp_qd,'YYYY/MM/DD'));
1977: hr_utility.trace('l_emp_wpf_qd : '||to_char(l_emp_wpf_qd,'YYYY/MM/DD'));
1978: hr_utility.trace('l_emp_ei_qd : '||to_char(l_emp_ei_qd,'YYYY/MM/DD'));
1979: hr_utility.trace('l_csr_emp.term_date : '||to_char(l_csr_emp.term_date,'YYYY/MM/DD'));
1980: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
1981: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));

Line 1978: hr_utility.trace('l_emp_ei_qd : '||to_char(l_emp_ei_qd,'YYYY/MM/DD'));

1974: hr_utility.trace('l_emp_ei_num : '||l_emp_ei_num);
1975: hr_utility.trace('l_emp_hi_qd : '||to_char(l_emp_hi_qd,'YYYY/MM/DD'));
1976: hr_utility.trace('l_emp_wp_qd : '||to_char(l_emp_wp_qd,'YYYY/MM/DD'));
1977: hr_utility.trace('l_emp_wpf_qd : '||to_char(l_emp_wpf_qd,'YYYY/MM/DD'));
1978: hr_utility.trace('l_emp_ei_qd : '||to_char(l_emp_ei_qd,'YYYY/MM/DD'));
1979: hr_utility.trace('l_csr_emp.term_date : '||to_char(l_csr_emp.term_date,'YYYY/MM/DD'));
1980: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
1981: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));
1982: end if;

Line 1979: hr_utility.trace('l_csr_emp.term_date : '||to_char(l_csr_emp.term_date,'YYYY/MM/DD'));

1975: hr_utility.trace('l_emp_hi_qd : '||to_char(l_emp_hi_qd,'YYYY/MM/DD'));
1976: hr_utility.trace('l_emp_wp_qd : '||to_char(l_emp_wp_qd,'YYYY/MM/DD'));
1977: hr_utility.trace('l_emp_wpf_qd : '||to_char(l_emp_wpf_qd,'YYYY/MM/DD'));
1978: hr_utility.trace('l_emp_ei_qd : '||to_char(l_emp_ei_qd,'YYYY/MM/DD'));
1979: hr_utility.trace('l_csr_emp.term_date : '||to_char(l_csr_emp.term_date,'YYYY/MM/DD'));
1980: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
1981: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));
1982: end if;
1983: --

Line 1980: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));

1976: hr_utility.trace('l_emp_wp_qd : '||to_char(l_emp_wp_qd,'YYYY/MM/DD'));
1977: hr_utility.trace('l_emp_wpf_qd : '||to_char(l_emp_wpf_qd,'YYYY/MM/DD'));
1978: hr_utility.trace('l_emp_ei_qd : '||to_char(l_emp_ei_qd,'YYYY/MM/DD'));
1979: hr_utility.trace('l_csr_emp.term_date : '||to_char(l_csr_emp.term_date,'YYYY/MM/DD'));
1980: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
1981: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));
1982: end if;
1983: --
1984: -- exclude future term data

Line 1981: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));

1977: hr_utility.trace('l_emp_wpf_qd : '||to_char(l_emp_wpf_qd,'YYYY/MM/DD'));
1978: hr_utility.trace('l_emp_ei_qd : '||to_char(l_emp_ei_qd,'YYYY/MM/DD'));
1979: hr_utility.trace('l_csr_emp.term_date : '||to_char(l_csr_emp.term_date,'YYYY/MM/DD'));
1980: hr_utility.trace('g_term_date_to : '||to_char(g_term_date_to,'YYYY/MM/DD'));
1981: hr_utility.trace('g_effective_date : '||to_char(g_effective_date,'YYYY/MM/DD'));
1982: end if;
1983: --
1984: -- exclude future term data
1985: if l_csr_emp.term_date is not null

Line 2006: hr_utility.trace('l_trm_assact_id : '||to_char(l_trm_assact_id));

2002: --
2003: if g_debug
2004: and g_detail_debug = 'Y' then
2005: l_archive_step := 4;
2006: hr_utility.trace('l_trm_assact_id : '||to_char(l_trm_assact_id));
2007: end if;
2008: --
2009: if l_trm_assact_id is not null then
2010: --

Line 2018: hr_utility.trace('l_trm_amt : '||to_char(l_trm_amt));

2014: --
2015: if g_debug
2016: and g_detail_debug = 'Y' then
2017: l_archive_step := 5;
2018: hr_utility.trace('l_trm_amt : '||to_char(l_trm_amt));
2019: end if;
2020: --
2021: end if;
2022: --

Line 2422: hr_utility.trace('archive_step : '||to_char(l_archive_step));

2418: --
2419: if g_debug
2420: and g_detail_debug = 'Y' then
2421: l_archive_step := 1000;
2422: hr_utility.trace('archive_step : '||to_char(l_archive_step));
2423: hr_utility.set_location(l_proc,1000);
2424: end if;
2425: --
2426: exception

Line 2423: hr_utility.set_location(l_proc,1000);

2419: if g_debug
2420: and g_detail_debug = 'Y' then
2421: l_archive_step := 1000;
2422: hr_utility.trace('archive_step : '||to_char(l_archive_step));
2423: hr_utility.set_location(l_proc,1000);
2424: end if;
2425: --
2426: exception
2427: when others then

Line 2432: hr_utility.trace('archive_assact error : '||l_error_code||' : '||l_error_mesg);

2428: --
2429: l_error_code := sqlcode;
2430: l_error_mesg := substrb(sqlerrm,1,100);
2431: --
2432: hr_utility.trace('archive_assact error : '||l_error_code||' : '||l_error_mesg);
2433: --
2434: if g_debug
2435: and g_detail_debug = 'Y' then
2436: hr_utility.trace('archive_step : '||to_char(l_archive_step));

Line 2436: hr_utility.trace('archive_step : '||to_char(l_archive_step));

2432: hr_utility.trace('archive_assact error : '||l_error_code||' : '||l_error_mesg);
2433: --
2434: if g_debug
2435: and g_detail_debug = 'Y' then
2436: hr_utility.trace('archive_step : '||to_char(l_archive_step));
2437: end if;
2438: --
2439: raise;
2440: --

Line 2456: -- hr_utility.set_location(l_proc,0);

2452: ----
2453: --begin
2454: ----
2455: -- if g_debug then
2456: -- hr_utility.set_location(l_proc,0);
2457: -- end if;
2458: ----
2459: ----
2460: -- if g_debug then

Line 2461: -- hr_utility.set_location(l_proc,1000);

2457: -- end if;
2458: ----
2459: ----
2460: -- if g_debug then
2461: -- hr_utility.set_location(l_proc,1000);
2462: -- end if;
2463: ----
2464: --end post_assact;
2465: --

Line 2481: hr_utility.set_location(l_proc,0);

2477: --
2478: begin
2479: --
2480: if g_debug then
2481: hr_utility.set_location(l_proc,0);
2482: end if;
2483: --
2484: select assignment_id
2485: into l_assignment_id

Line 2490: hr_utility.set_location(l_proc,10);

2486: from pay_assignment_actions
2487: where assignment_action_id = p_assignment_action_id;
2488: --
2489: if g_debug then
2490: hr_utility.set_location(l_proc,10);
2491: hr_utility.trace('archive_data p_assignment_action_id : '||to_char(p_assignment_action_id));
2492: hr_utility.trace('archive_data l_assignment_id : '||to_char(l_assignment_id));
2493: end if;
2494: --

Line 2491: hr_utility.trace('archive_data p_assignment_action_id : '||to_char(p_assignment_action_id));

2487: where assignment_action_id = p_assignment_action_id;
2488: --
2489: if g_debug then
2490: hr_utility.set_location(l_proc,10);
2491: hr_utility.trace('archive_data p_assignment_action_id : '||to_char(p_assignment_action_id));
2492: hr_utility.trace('archive_data l_assignment_id : '||to_char(l_assignment_id));
2493: end if;
2494: --
2495: --init_assact(

Line 2492: hr_utility.trace('archive_data l_assignment_id : '||to_char(l_assignment_id));

2488: --
2489: if g_debug then
2490: hr_utility.set_location(l_proc,10);
2491: hr_utility.trace('archive_data p_assignment_action_id : '||to_char(p_assignment_action_id));
2492: hr_utility.trace('archive_data l_assignment_id : '||to_char(l_assignment_id));
2493: end if;
2494: --
2495: --init_assact(
2496: -- p_assignment_action_id => p_assignment_action_id,

Line 2500: -- hr_utility.set_location(l_proc,20);

2496: -- p_assignment_action_id => p_assignment_action_id,
2497: -- p_assignment_id => l_assignment_id);
2498: --
2499: --if g_debug then
2500: -- hr_utility.set_location(l_proc,20);
2501: --end if;
2502: --
2503: archive_assact(
2504: p_assignment_action_id => p_assignment_action_id,

Line 2508: hr_utility.set_location(l_proc,20);

2504: p_assignment_action_id => p_assignment_action_id,
2505: p_assignment_id => l_assignment_id);
2506: --
2507: if g_debug then
2508: hr_utility.set_location(l_proc,20);
2509: end if;
2510: --
2511: --post_assact(
2512: -- p_assignment_action_id => p_assignment_action_id,

Line 2516: hr_utility.set_location(l_proc,1000);

2512: -- p_assignment_action_id => p_assignment_action_id,
2513: -- p_assignment_id => l_assignment_id);
2514: --
2515: if g_debug then
2516: hr_utility.set_location(l_proc,1000);
2517: end if;
2518: --
2519: end archive_code;
2520: --

Line 2533: -- hr_utility.set_location(l_proc,0);

2529: ----
2530: --begin
2531: ----
2532: -- if g_debug then
2533: -- hr_utility.set_location(l_proc,0);
2534: -- end if;
2535: ----
2536: ---- archive_pact(p_payroll_action_id);
2537: ----

Line 2543: -- hr_utility.set_location(l_proc,1000);

2539: -- g_ass_ind_tbl.delete;
2540: -- g_per_ind_tbl.delete;
2541: ----
2542: -- if g_debug then
2543: -- hr_utility.set_location(l_proc,1000);
2544: -- end if;
2545: ----
2546: --end deinitialize_code;
2547: --