APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on HR_UTILITY

Line 31: g_debug boolean := hr_utility.debug_enabled;

27: c_national_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_is_elm_id, 'NATIONAL_PENSION_PREM');
28: --
29: c_st_upd_date_2007 constant date := to_date('2007/01/01','YYYY/MM/DD');
30: --
31: g_debug boolean := hr_utility.debug_enabled;
32: g_business_group_id number;
33: g_legislation_code per_business_groups_perf.legislation_code%type;
34: g_payroll_action_id number;
35: g_assignment_action_id number;

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

87: --
88: begin
89: --
90: if g_debug then
91: hr_utility.set_location(l_proc,0);
92: end if;
93: --
94: if g_payroll_action_id is null
95: or g_payroll_action_id <> p_payroll_action_id then

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

94: if g_payroll_action_id is null
95: or g_payroll_action_id <> p_payroll_action_id then
96: --
97: if g_debug then
98: hr_utility.set_location(l_proc,10);
99: hr_utility.trace('no cache : g_pact_id('||g_payroll_action_id||'),p_pact_id('||p_payroll_action_id||')');
100: end if;
101: --
102: open csr_action;

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

95: or g_payroll_action_id <> p_payroll_action_id then
96: --
97: if g_debug then
98: hr_utility.set_location(l_proc,10);
99: hr_utility.trace('no cache : g_pact_id('||g_payroll_action_id||'),p_pact_id('||p_payroll_action_id||')');
100: end if;
101: --
102: open csr_action;
103: fetch csr_action into l_csr_action;

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

125: --
126: if g_assignment_set_id is not null then
127: --
128: if g_debug then
129: hr_utility.set_location(l_proc,20);
130: hr_utility.trace('assignment set : '||g_assignment_set_id);
131: end if;
132: --
133: hr_jp_ast_utility_pkg.pay_asgs(

Line 130: hr_utility.trace('assignment set : '||g_assignment_set_id);

126: if g_assignment_set_id is not null then
127: --
128: if g_debug then
129: hr_utility.set_location(l_proc,20);
130: hr_utility.trace('assignment set : '||g_assignment_set_id);
131: end if;
132: --
133: hr_jp_ast_utility_pkg.pay_asgs(
134: p_payroll_id => g_payroll_id,

Line 142: hr_utility.set_location(l_proc,30);

138: p_assignment_set_id => g_assignment_set_id,
139: p_asg_rec => g_asg_rec);
140: --
141: if g_debug then
142: hr_utility.set_location(l_proc,30);
143: hr_utility.trace('inclusive assignment count : '||g_asg_rec.assignment_id_tbl.count);
144: end if;
145: --
146: end if;

Line 143: hr_utility.trace('inclusive assignment count : '||g_asg_rec.assignment_id_tbl.count);

139: p_asg_rec => g_asg_rec);
140: --
141: if g_debug then
142: hr_utility.set_location(l_proc,30);
143: hr_utility.trace('inclusive assignment count : '||g_asg_rec.assignment_id_tbl.count);
144: end if;
145: --
146: end if;
147: --

Line 151: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);

147: --
148: end if;
149: --
150: if g_debug then
151: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
152: hr_utility.trace('business_group_id : '||g_business_group_id);
153: hr_utility.trace('effective_date : '||g_effective_date);
154: hr_utility.trace('legislation_code : '||g_legislation_code);
155: hr_utility.trace('payroll_id : '||g_payroll_id);

Line 152: hr_utility.trace('business_group_id : '||g_business_group_id);

148: end if;
149: --
150: if g_debug then
151: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
152: hr_utility.trace('business_group_id : '||g_business_group_id);
153: hr_utility.trace('effective_date : '||g_effective_date);
154: hr_utility.trace('legislation_code : '||g_legislation_code);
155: hr_utility.trace('payroll_id : '||g_payroll_id);
156: hr_utility.trace('organization_id : '||g_organization_id);

Line 153: hr_utility.trace('effective_date : '||g_effective_date);

149: --
150: if g_debug then
151: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
152: hr_utility.trace('business_group_id : '||g_business_group_id);
153: hr_utility.trace('effective_date : '||g_effective_date);
154: hr_utility.trace('legislation_code : '||g_legislation_code);
155: hr_utility.trace('payroll_id : '||g_payroll_id);
156: hr_utility.trace('organization_id : '||g_organization_id);
157: hr_utility.trace('assignment_set_id : '||g_assignment_set_id);

Line 154: hr_utility.trace('legislation_code : '||g_legislation_code);

150: if g_debug then
151: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
152: hr_utility.trace('business_group_id : '||g_business_group_id);
153: hr_utility.trace('effective_date : '||g_effective_date);
154: hr_utility.trace('legislation_code : '||g_legislation_code);
155: hr_utility.trace('payroll_id : '||g_payroll_id);
156: hr_utility.trace('organization_id : '||g_organization_id);
157: hr_utility.trace('assignment_set_id : '||g_assignment_set_id);
158: hr_utility.trace('process_assignments_flag : '||g_process_assignments_flag);

Line 155: hr_utility.trace('payroll_id : '||g_payroll_id);

151: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
152: hr_utility.trace('business_group_id : '||g_business_group_id);
153: hr_utility.trace('effective_date : '||g_effective_date);
154: hr_utility.trace('legislation_code : '||g_legislation_code);
155: hr_utility.trace('payroll_id : '||g_payroll_id);
156: hr_utility.trace('organization_id : '||g_organization_id);
157: hr_utility.trace('assignment_set_id : '||g_assignment_set_id);
158: hr_utility.trace('process_assignments_flag : '||g_process_assignments_flag);
159: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);

Line 156: hr_utility.trace('organization_id : '||g_organization_id);

152: hr_utility.trace('business_group_id : '||g_business_group_id);
153: hr_utility.trace('effective_date : '||g_effective_date);
154: hr_utility.trace('legislation_code : '||g_legislation_code);
155: hr_utility.trace('payroll_id : '||g_payroll_id);
156: hr_utility.trace('organization_id : '||g_organization_id);
157: hr_utility.trace('assignment_set_id : '||g_assignment_set_id);
158: hr_utility.trace('process_assignments_flag : '||g_process_assignments_flag);
159: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);
160: hr_utility.trace('copy_archive_pact_id : '||g_copy_archive_pact_id);

Line 157: hr_utility.trace('assignment_set_id : '||g_assignment_set_id);

153: hr_utility.trace('effective_date : '||g_effective_date);
154: hr_utility.trace('legislation_code : '||g_legislation_code);
155: hr_utility.trace('payroll_id : '||g_payroll_id);
156: hr_utility.trace('organization_id : '||g_organization_id);
157: hr_utility.trace('assignment_set_id : '||g_assignment_set_id);
158: hr_utility.trace('process_assignments_flag : '||g_process_assignments_flag);
159: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);
160: hr_utility.trace('copy_archive_pact_id : '||g_copy_archive_pact_id);
161: hr_utility.trace('bg_itax_dpnt_ref_type : '||g_bg_itax_dpnt_ref_type);

Line 158: hr_utility.trace('process_assignments_flag : '||g_process_assignments_flag);

154: hr_utility.trace('legislation_code : '||g_legislation_code);
155: hr_utility.trace('payroll_id : '||g_payroll_id);
156: hr_utility.trace('organization_id : '||g_organization_id);
157: hr_utility.trace('assignment_set_id : '||g_assignment_set_id);
158: hr_utility.trace('process_assignments_flag : '||g_process_assignments_flag);
159: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);
160: hr_utility.trace('copy_archive_pact_id : '||g_copy_archive_pact_id);
161: hr_utility.trace('bg_itax_dpnt_ref_type : '||g_bg_itax_dpnt_ref_type);
162: end if;

Line 159: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);

155: hr_utility.trace('payroll_id : '||g_payroll_id);
156: hr_utility.trace('organization_id : '||g_organization_id);
157: hr_utility.trace('assignment_set_id : '||g_assignment_set_id);
158: hr_utility.trace('process_assignments_flag : '||g_process_assignments_flag);
159: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);
160: hr_utility.trace('copy_archive_pact_id : '||g_copy_archive_pact_id);
161: hr_utility.trace('bg_itax_dpnt_ref_type : '||g_bg_itax_dpnt_ref_type);
162: end if;
163: --

Line 160: hr_utility.trace('copy_archive_pact_id : '||g_copy_archive_pact_id);

156: hr_utility.trace('organization_id : '||g_organization_id);
157: hr_utility.trace('assignment_set_id : '||g_assignment_set_id);
158: hr_utility.trace('process_assignments_flag : '||g_process_assignments_flag);
159: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);
160: hr_utility.trace('copy_archive_pact_id : '||g_copy_archive_pact_id);
161: hr_utility.trace('bg_itax_dpnt_ref_type : '||g_bg_itax_dpnt_ref_type);
162: end if;
163: --
164: if g_debug then

Line 161: hr_utility.trace('bg_itax_dpnt_ref_type : '||g_bg_itax_dpnt_ref_type);

157: hr_utility.trace('assignment_set_id : '||g_assignment_set_id);
158: hr_utility.trace('process_assignments_flag : '||g_process_assignments_flag);
159: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);
160: hr_utility.trace('copy_archive_pact_id : '||g_copy_archive_pact_id);
161: hr_utility.trace('bg_itax_dpnt_ref_type : '||g_bg_itax_dpnt_ref_type);
162: end if;
163: --
164: if g_debug then
165: hr_utility.set_location(l_proc,1000);

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

161: hr_utility.trace('bg_itax_dpnt_ref_type : '||g_bg_itax_dpnt_ref_type);
162: end if;
163: --
164: if g_debug then
165: hr_utility.set_location(l_proc,1000);
166: end if;
167: --
168: end init_pact;
169: --

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

204: --
205: begin
206: --
207: if g_debug then
208: hr_utility.set_location(l_proc,0);
209: end if;
210: --
211: -- no create pact in mark for retry.
212: --

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

215: --
216: if csr_validate_pact%notfound then
217: --
218: if g_debug then
219: hr_utility.set_location(l_proc,10);
220: end if;
221: --
222: open csr_org;
223: fetch csr_org into l_csr_org;

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

229: --
230: close csr_org;
231: --
232: if g_debug then
233: hr_utility.set_location(l_proc,20);
234: hr_utility.trace('tax_office_name : '||l_csr_org.tax_office_name);
235: hr_utility.trace('salary_payer_name : '||l_csr_org.salary_payer_name);
236: hr_utility.trace('salary_payer_address : '||l_csr_org.salary_payer_address);
237: hr_utility.trace('start create_pact');

Line 234: hr_utility.trace('tax_office_name : '||l_csr_org.tax_office_name);

230: close csr_org;
231: --
232: if g_debug then
233: hr_utility.set_location(l_proc,20);
234: hr_utility.trace('tax_office_name : '||l_csr_org.tax_office_name);
235: hr_utility.trace('salary_payer_name : '||l_csr_org.salary_payer_name);
236: hr_utility.trace('salary_payer_address : '||l_csr_org.salary_payer_address);
237: hr_utility.trace('start create_pact');
238: end if;

Line 235: hr_utility.trace('salary_payer_name : '||l_csr_org.salary_payer_name);

231: --
232: if g_debug then
233: hr_utility.set_location(l_proc,20);
234: hr_utility.trace('tax_office_name : '||l_csr_org.tax_office_name);
235: hr_utility.trace('salary_payer_name : '||l_csr_org.salary_payer_name);
236: hr_utility.trace('salary_payer_address : '||l_csr_org.salary_payer_address);
237: hr_utility.trace('start create_pact');
238: end if;
239: --

Line 236: hr_utility.trace('salary_payer_address : '||l_csr_org.salary_payer_address);

232: if g_debug then
233: hr_utility.set_location(l_proc,20);
234: hr_utility.trace('tax_office_name : '||l_csr_org.tax_office_name);
235: hr_utility.trace('salary_payer_name : '||l_csr_org.salary_payer_name);
236: hr_utility.trace('salary_payer_address : '||l_csr_org.salary_payer_address);
237: hr_utility.trace('start create_pact');
238: end if;
239: --
240: pay_jp_isdf_dml_pkg.create_pact(

Line 237: hr_utility.trace('start create_pact');

233: hr_utility.set_location(l_proc,20);
234: hr_utility.trace('tax_office_name : '||l_csr_org.tax_office_name);
235: hr_utility.trace('salary_payer_name : '||l_csr_org.salary_payer_name);
236: hr_utility.trace('salary_payer_address : '||l_csr_org.salary_payer_address);
237: hr_utility.trace('start create_pact');
238: end if;
239: --
240: pay_jp_isdf_dml_pkg.create_pact(
241: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

Line 258: hr_utility.trace('end create_pact');

254: p_salary_payer_address => l_csr_org.salary_payer_address,
255: p_object_version_number => l_object_version_number);
256: --
257: if g_debug then
258: hr_utility.trace('end create_pact');
259: hr_utility.set_location(l_proc,30);
260: end if;
261: --
262: end if;

Line 259: hr_utility.set_location(l_proc,30);

255: p_object_version_number => l_object_version_number);
256: --
257: if g_debug then
258: hr_utility.trace('end create_pact');
259: hr_utility.set_location(l_proc,30);
260: end if;
261: --
262: end if;
263: close csr_validate_pact;

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

262: end if;
263: close csr_validate_pact;
264: --
265: if g_debug then
266: hr_utility.set_location(l_proc,1000);
267: end if;
268: --
269: end archive_pact;
270: --

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

280: --
281: begin
282: --
283: if g_debug then
284: hr_utility.set_location(l_proc,0);
285: end if;
286: --
287: init_pact(p_payroll_action_id);
288: --

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

286: --
287: init_pact(p_payroll_action_id);
288: --
289: if g_debug then
290: hr_utility.set_location(l_proc,10);
291: end if;
292: --
293: archive_pact(p_payroll_action_id);
294: --

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

292: --
293: archive_pact(p_payroll_action_id);
294: --
295: if g_debug then
296: hr_utility.set_location(l_proc,20);
297: end if;
298: --
299: -- no create assact when process assignments flag is set.
300: --

Line 304: hr_utility.set_location(l_proc,30);

300: --
301: if g_process_assignments_flag = 'N' then
302: --
303: if g_debug then
304: hr_utility.set_location(l_proc,30);
305: end if;
306: --
307: p_sqlstr :=
308: 'select 1

Line 315: hr_utility.set_location(l_proc,40);

311: --
312: else
313: --
314: if g_debug then
315: hr_utility.set_location(l_proc,40);
316: end if;
317: --
318: p_sqlstr :=
319: 'select /*+ ORDERED */

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

326: --
327: end if;
328: --
329: if g_debug then
330: hr_utility.set_location(l_proc,1000);
331: end if;
332: --
333: end range_cursor;
334: --

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

370: --
371: begin
372: --
373: if g_debug then
374: hr_utility.set_location(l_proc,0);
375: end if;
376: --
377: -- Reset global variable in case of multiple threads.
378: init_pact(p_payroll_action_id);

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

377: -- Reset global variable in case of multiple threads.
378: init_pact(p_payroll_action_id);
379: --
380: if g_debug then
381: hr_utility.set_location(l_proc,10);
382: end if;
383: --
384: open csr_proc_ass;
385: loop

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

390: l_assignment_id := null;
391: if g_assignment_set_id is not null then
392: --
393: if g_debug then
394: hr_utility.set_location(l_proc,20);
395: hr_utility.trace('assignment set : '||g_assignment_set_id);
396: end if;
397: --
398: <>

Line 395: hr_utility.trace('assignment set : '||g_assignment_set_id);

391: if g_assignment_set_id is not null then
392: --
393: if g_debug then
394: hr_utility.set_location(l_proc,20);
395: hr_utility.trace('assignment set : '||g_assignment_set_id);
396: end if;
397: --
398: <>
399: for i in 1..g_asg_rec.assignment_id_tbl.count loop

Line 409: hr_utility.set_location(l_proc,30);

405: --
406: end loop ass_exist;
407: --
408: if g_debug then
409: hr_utility.set_location(l_proc,30);
410: hr_utility.trace('assignment id : '||l_assignment_id);
411: end if;
412: --
413: else

Line 410: hr_utility.trace('assignment id : '||l_assignment_id);

406: end loop ass_exist;
407: --
408: if g_debug then
409: hr_utility.set_location(l_proc,30);
410: hr_utility.trace('assignment id : '||l_assignment_id);
411: end if;
412: --
413: else
414: --

Line 418: hr_utility.set_location(l_proc,40);

414: --
415: l_assignment_id := l_csr_proc_ass.assignment_id;
416: --
417: if g_debug then
418: hr_utility.set_location(l_proc,40);
419: hr_utility.trace('assignment id : '||l_assignment_id);
420: end if;
421: --
422: end if;

Line 419: hr_utility.trace('assignment id : '||l_assignment_id);

415: l_assignment_id := l_csr_proc_ass.assignment_id;
416: --
417: if g_debug then
418: hr_utility.set_location(l_proc,40);
419: hr_utility.trace('assignment id : '||l_assignment_id);
420: end if;
421: --
422: end if;
423: --

Line 427: hr_utility.set_location(l_proc,50);

423: --
424: if l_assignment_id is not null then
425: --
426: if g_debug then
427: hr_utility.set_location(l_proc,50);
428: end if;
429: --
430: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
431: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(l_assignment_id));

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

432: l_organization_id := pay_balance_pkg.run_db_item(c_org_iv_name,g_business_group_id,g_legislation_code);
433: --
434: if g_debug and l_debug_cnt < 1 then
435: l_debug_cnt := l_debug_cnt + 1;
436: hr_utility.set_location(l_proc,60);
437: hr_utility.trace('diff org : g_org_id('||g_organization_id||'),l_org_id('||l_organization_id||')');
438: end if;
439: --
440: if l_organization_id = g_organization_id then

Line 437: hr_utility.trace('diff org : g_org_id('||g_organization_id||'),l_org_id('||l_organization_id||')');

433: --
434: if g_debug and l_debug_cnt < 1 then
435: l_debug_cnt := l_debug_cnt + 1;
436: hr_utility.set_location(l_proc,60);
437: hr_utility.trace('diff org : g_org_id('||g_organization_id||'),l_org_id('||l_organization_id||')');
438: end if;
439: --
440: if l_organization_id = g_organization_id then
441: --

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

441: --
442: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
443: --
444: if g_debug then
445: hr_utility.set_location(l_proc,70);
446: hr_utility.trace('tax type : '||l_tax_type);
447: end if;
448: --
449: -- target only kou by legislative rule.

Line 446: hr_utility.trace('tax type : '||l_tax_type);

442: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
443: --
444: if g_debug then
445: hr_utility.set_location(l_proc,70);
446: hr_utility.trace('tax type : '||l_tax_type);
447: end if;
448: --
449: -- target only kou by legislative rule.
450: if l_tax_type in ('M_KOU','D_KOU') then

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

449: -- target only kou by legislative rule.
450: if l_tax_type in ('M_KOU','D_KOU') then
451: --
452: if g_debug then
453: hr_utility.set_location(l_proc,80);
454: hr_utility.trace('assignment_id : '||l_assignment_id);
455: end if;
456: --
457: select pay_assignment_actions_s.nextval

Line 454: hr_utility.trace('assignment_id : '||l_assignment_id);

450: if l_tax_type in ('M_KOU','D_KOU') then
451: --
452: if g_debug then
453: hr_utility.set_location(l_proc,80);
454: hr_utility.trace('assignment_id : '||l_assignment_id);
455: end if;
456: --
457: select pay_assignment_actions_s.nextval
458: into l_assignment_action_id

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

465: chunk => p_chunk_number,
466: greid => null);
467: --
468: if g_debug then
469: hr_utility.set_location(l_proc,90);
470: hr_utility.trace('assignment_action_id : '||l_assignment_action_id);
471: end if;
472: --
473: end if;

Line 470: hr_utility.trace('assignment_action_id : '||l_assignment_action_id);

466: greid => null);
467: --
468: if g_debug then
469: hr_utility.set_location(l_proc,90);
470: hr_utility.trace('assignment_action_id : '||l_assignment_action_id);
471: end if;
472: --
473: end if;
474: --

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

479: end loop;
480: close csr_proc_ass;
481: --
482: if g_debug then
483: hr_utility.set_location(l_proc,1000);
484: end if;
485: --
486: end assignment_action_creation;
487: --

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

494: l_proc varchar2(80) := c_package||'archinit';
495: begin
496: --
497: if g_debug then
498: hr_utility.set_location(l_proc,0);
499: end if;
500: --
501: init_pact(p_payroll_action_id);
502: --

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

500: --
501: init_pact(p_payroll_action_id);
502: --
503: if g_debug then
504: hr_utility.set_location(l_proc,1000);
505: end if;
506: --
507: end archinit;
508: --

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

518: --
519: begin
520: --
521: if g_debug then
522: hr_utility.set_location(l_proc,0);
523: end if;
524: --
525: if g_assignment_action_id is null
526: or g_assignment_action_id <> p_assignment_action_id then

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

525: if g_assignment_action_id is null
526: or g_assignment_action_id <> p_assignment_action_id then
527: --
528: if g_debug then
529: hr_utility.set_location(l_proc,10);
530: hr_utility.trace('no cache : g_assact_id('||g_assignment_action_id||'),p_assact_id('||p_assignment_action_id||')');
531: end if;
532: --
533: g_assignment_action_id := p_assignment_action_id;

Line 530: hr_utility.trace('no cache : g_assact_id('||g_assignment_action_id||'),p_assact_id('||p_assignment_action_id||')');

526: or g_assignment_action_id <> p_assignment_action_id then
527: --
528: if g_debug then
529: hr_utility.set_location(l_proc,10);
530: hr_utility.trace('no cache : g_assact_id('||g_assignment_action_id||'),p_assact_id('||p_assignment_action_id||')');
531: end if;
532: --
533: g_assignment_action_id := p_assignment_action_id;
534: g_assignment_id := p_assignment_id;

Line 539: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);

535: --
536: end if;
537: --
538: if g_debug then
539: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
540: hr_utility.trace('assignment_id : '||g_assignment_id);
541: hr_utility.set_location(l_proc,1000);
542: end if;
543: --

Line 540: hr_utility.trace('assignment_id : '||g_assignment_id);

536: end if;
537: --
538: if g_debug then
539: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
540: hr_utility.trace('assignment_id : '||g_assignment_id);
541: hr_utility.set_location(l_proc,1000);
542: end if;
543: --
544: end init_assact;

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

537: --
538: if g_debug then
539: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
540: hr_utility.trace('assignment_id : '||g_assignment_id);
541: hr_utility.set_location(l_proc,1000);
542: end if;
543: --
544: end init_assact;
545: --

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

571: --
572: begin
573: --
574: if g_debug then
575: hr_utility.set_location(l_proc,0);
576: end if;
577: --
578: open csr_ff;
579: fetch csr_ff into l_formula_id;

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

579: fetch csr_ff into l_formula_id;
580: close csr_ff;
581: --
582: if g_debug then
583: hr_utility.set_location(l_proc,10);
584: hr_utility.trace('formula_id : '||l_formula_id);
585: end if;
586: --
587: if l_formula_id is not null then

Line 584: hr_utility.trace('formula_id : '||l_formula_id);

580: close csr_ff;
581: --
582: if g_debug then
583: hr_utility.set_location(l_proc,10);
584: hr_utility.trace('formula_id : '||l_formula_id);
585: end if;
586: --
587: if l_formula_id is not null then
588: --

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

592: p_inputs => l_inputs,
593: p_outputs => l_outputs);
594: --
595: if g_debug then
596: hr_utility.set_location(l_proc,20);
597: end if;
598: --
599: if l_inputs.count > 1 then
600: --

Line 645: hr_utility.set_location(l_proc,30);

641: --
642: end loop;
643: --
644: if g_debug then
645: hr_utility.set_location(l_proc,30);
646: hr_utility.trace('business_group_id : '||g_business_group_id);
647: hr_utility.trace('payroll_id : '||g_payroll_id);
648: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
649: hr_utility.trace('assignment_id : '||g_assignment_id);

Line 646: hr_utility.trace('business_group_id : '||g_business_group_id);

642: end loop;
643: --
644: if g_debug then
645: hr_utility.set_location(l_proc,30);
646: hr_utility.trace('business_group_id : '||g_business_group_id);
647: hr_utility.trace('payroll_id : '||g_payroll_id);
648: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
649: hr_utility.trace('assignment_id : '||g_assignment_id);
650: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);

Line 647: hr_utility.trace('payroll_id : '||g_payroll_id);

643: --
644: if g_debug then
645: hr_utility.set_location(l_proc,30);
646: hr_utility.trace('business_group_id : '||g_business_group_id);
647: hr_utility.trace('payroll_id : '||g_payroll_id);
648: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
649: hr_utility.trace('assignment_id : '||g_assignment_id);
650: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
651: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));

Line 648: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);

644: if g_debug then
645: hr_utility.set_location(l_proc,30);
646: hr_utility.trace('business_group_id : '||g_business_group_id);
647: hr_utility.trace('payroll_id : '||g_payroll_id);
648: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
649: hr_utility.trace('assignment_id : '||g_assignment_id);
650: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
651: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
652: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);

Line 649: hr_utility.trace('assignment_id : '||g_assignment_id);

645: hr_utility.set_location(l_proc,30);
646: hr_utility.trace('business_group_id : '||g_business_group_id);
647: hr_utility.trace('payroll_id : '||g_payroll_id);
648: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
649: hr_utility.trace('assignment_id : '||g_assignment_id);
650: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
651: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
652: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
653: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);

Line 650: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);

646: hr_utility.trace('business_group_id : '||g_business_group_id);
647: hr_utility.trace('payroll_id : '||g_payroll_id);
648: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
649: hr_utility.trace('assignment_id : '||g_assignment_id);
650: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
651: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
652: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
653: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
654: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);

Line 651: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));

647: hr_utility.trace('payroll_id : '||g_payroll_id);
648: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
649: hr_utility.trace('assignment_id : '||g_assignment_id);
650: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
651: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
652: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
653: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
654: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
655: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);

Line 652: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);

648: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
649: hr_utility.trace('assignment_id : '||g_assignment_id);
650: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
651: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
652: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
653: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
654: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
655: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
656: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);

Line 653: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);

649: hr_utility.trace('assignment_id : '||g_assignment_id);
650: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
651: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
652: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
653: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
654: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
655: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
656: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
657: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);

Line 654: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);

650: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
651: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
652: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
653: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
654: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
655: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
656: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
657: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
658: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);

Line 655: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);

651: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
652: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
653: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
654: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
655: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
656: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
657: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
658: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
659: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);

Line 656: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);

652: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
653: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
654: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
655: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
656: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
657: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
658: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
659: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
660: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);

Line 657: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);

653: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
654: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
655: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
656: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
657: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
658: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
659: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
660: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
661: hr_utility.trace('i_linc_prem : '||p_ins_info_rec.linc_prem);

Line 658: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);

654: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
655: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
656: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
657: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
658: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
659: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
660: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
661: hr_utility.trace('i_linc_prem : '||p_ins_info_rec.linc_prem);
662: end if;

Line 659: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);

655: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
656: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
657: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
658: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
659: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
660: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
661: hr_utility.trace('i_linc_prem : '||p_ins_info_rec.linc_prem);
662: end if;
663: --

Line 660: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);

656: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
657: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
658: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
659: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
660: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
661: hr_utility.trace('i_linc_prem : '||p_ins_info_rec.linc_prem);
662: end if;
663: --
664: end if;

Line 661: hr_utility.trace('i_linc_prem : '||p_ins_info_rec.linc_prem);

657: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
658: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
659: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
660: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
661: hr_utility.trace('i_linc_prem : '||p_ins_info_rec.linc_prem);
662: end if;
663: --
664: end if;
665: --

Line 671: hr_utility.set_location(l_proc,40);

667: p_inputs => l_inputs,
668: p_outputs => l_outputs);
669: --
670: if g_debug then
671: hr_utility.set_location(l_proc,40);
672: end if;
673: --
674: if l_outputs.count > 1 then
675: --

Line 689: hr_utility.set_location(l_proc,50);

685: --
686: end loop;
687: --
688: if g_debug then
689: hr_utility.set_location(l_proc,50);
690: hr_utility.trace('lig_prem : '||p_lig_prem);
691: hr_utility.trace('lip_prem : '||p_lip_prem);
692: hr_utility.trace('message : '||substrb(p_message,1,300));
693: end if;

Line 690: hr_utility.trace('lig_prem : '||p_lig_prem);

686: end loop;
687: --
688: if g_debug then
689: hr_utility.set_location(l_proc,50);
690: hr_utility.trace('lig_prem : '||p_lig_prem);
691: hr_utility.trace('lip_prem : '||p_lip_prem);
692: hr_utility.trace('message : '||substrb(p_message,1,300));
693: end if;
694: --

Line 691: hr_utility.trace('lip_prem : '||p_lip_prem);

687: --
688: if g_debug then
689: hr_utility.set_location(l_proc,50);
690: hr_utility.trace('lig_prem : '||p_lig_prem);
691: hr_utility.trace('lip_prem : '||p_lip_prem);
692: hr_utility.trace('message : '||substrb(p_message,1,300));
693: end if;
694: --
695: if p_message is not null then

Line 692: hr_utility.trace('message : '||substrb(p_message,1,300));

688: if g_debug then
689: hr_utility.set_location(l_proc,50);
690: hr_utility.trace('lig_prem : '||p_lig_prem);
691: hr_utility.trace('lip_prem : '||p_lip_prem);
692: hr_utility.trace('message : '||substrb(p_message,1,300));
693: end if;
694: --
695: if p_message is not null then
696: --

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

694: --
695: if p_message is not null then
696: --
697: if g_debug then
698: hr_utility.set_location(l_proc,60);
699: end if;
700: --
701: fnd_file.put_line(fnd_file.output,'Assignment Id : '||fnd_number.number_to_canonical(g_assignment_id));
702: fnd_file.put_line(fnd_file.output,'----------------------------------------------------------------------------------------------------');

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

703: fnd_file.put_line(fnd_file.output,p_message);
704: fnd_file.put_line(fnd_file.output,' ');
705: --
706: if g_debug then
707: hr_utility.set_location(l_proc,70);
708: end if;
709: --
710: end if;
711: --

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

713: --
714: end if;
715: --
716: if g_debug then
717: hr_utility.set_location(l_proc,1000);
718: end if;
719: --
720: end calc_li_annual_prem;
721: --

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

747: --
748: begin
749: --
750: if g_debug then
751: hr_utility.set_location(l_proc,0);
752: end if;
753: --
754: open csr_ff;
755: fetch csr_ff into l_formula_id;

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

755: fetch csr_ff into l_formula_id;
756: close csr_ff;
757: --
758: if g_debug then
759: hr_utility.set_location(l_proc,10);
760: hr_utility.trace('formula_id : '||l_formula_id);
761: end if;
762: --
763: if l_formula_id is not null then

Line 760: hr_utility.trace('formula_id : '||l_formula_id);

756: close csr_ff;
757: --
758: if g_debug then
759: hr_utility.set_location(l_proc,10);
760: hr_utility.trace('formula_id : '||l_formula_id);
761: end if;
762: --
763: if l_formula_id is not null then
764: --

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

768: p_inputs => l_inputs,
769: p_outputs => l_outputs);
770: --
771: if g_debug then
772: hr_utility.set_location(l_proc,20);
773: end if;
774: --
775: if l_inputs.count > 1 then
776: --

Line 823: hr_utility.set_location(l_proc,30);

819: --
820: end loop;
821: --
822: if g_debug then
823: hr_utility.set_location(l_proc,30);
824: hr_utility.trace('business_group_id : '||g_business_group_id);
825: hr_utility.trace('payroll_id : '||g_payroll_id);
826: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
827: hr_utility.trace('assignment_id : '||g_assignment_id);

Line 824: hr_utility.trace('business_group_id : '||g_business_group_id);

820: end loop;
821: --
822: if g_debug then
823: hr_utility.set_location(l_proc,30);
824: hr_utility.trace('business_group_id : '||g_business_group_id);
825: hr_utility.trace('payroll_id : '||g_payroll_id);
826: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
827: hr_utility.trace('assignment_id : '||g_assignment_id);
828: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);

Line 825: hr_utility.trace('payroll_id : '||g_payroll_id);

821: --
822: if g_debug then
823: hr_utility.set_location(l_proc,30);
824: hr_utility.trace('business_group_id : '||g_business_group_id);
825: hr_utility.trace('payroll_id : '||g_payroll_id);
826: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
827: hr_utility.trace('assignment_id : '||g_assignment_id);
828: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
829: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));

Line 826: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);

822: if g_debug then
823: hr_utility.set_location(l_proc,30);
824: hr_utility.trace('business_group_id : '||g_business_group_id);
825: hr_utility.trace('payroll_id : '||g_payroll_id);
826: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
827: hr_utility.trace('assignment_id : '||g_assignment_id);
828: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
829: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
830: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);

Line 827: hr_utility.trace('assignment_id : '||g_assignment_id);

823: hr_utility.set_location(l_proc,30);
824: hr_utility.trace('business_group_id : '||g_business_group_id);
825: hr_utility.trace('payroll_id : '||g_payroll_id);
826: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
827: hr_utility.trace('assignment_id : '||g_assignment_id);
828: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
829: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
830: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
831: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);

Line 828: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);

824: hr_utility.trace('business_group_id : '||g_business_group_id);
825: hr_utility.trace('payroll_id : '||g_payroll_id);
826: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
827: hr_utility.trace('assignment_id : '||g_assignment_id);
828: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
829: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
830: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
831: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
832: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);

Line 829: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));

825: hr_utility.trace('payroll_id : '||g_payroll_id);
826: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
827: hr_utility.trace('assignment_id : '||g_assignment_id);
828: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
829: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
830: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
831: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
832: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
833: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);

Line 830: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);

826: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
827: hr_utility.trace('assignment_id : '||g_assignment_id);
828: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
829: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
830: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
831: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
832: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
833: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
834: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);

Line 831: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);

827: hr_utility.trace('assignment_id : '||g_assignment_id);
828: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
829: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
830: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
831: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
832: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
833: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
834: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
835: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);

Line 832: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);

828: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
829: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
830: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
831: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
832: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
833: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
834: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
835: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
836: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);

Line 833: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);

829: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
830: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
831: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
832: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
833: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
834: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
835: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
836: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
837: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);

Line 834: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);

830: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
831: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
832: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
833: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
834: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
835: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
836: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
837: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
838: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);

Line 835: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);

831: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
832: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
833: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
834: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
835: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
836: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
837: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
838: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);
839: hr_utility.trace('i_ai_prem : '||p_ins_info_rec.annual_prem);

Line 836: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);

832: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
833: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
834: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
835: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
836: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
837: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
838: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);
839: hr_utility.trace('i_ai_prem : '||p_ins_info_rec.annual_prem);
840: end if;

Line 837: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);

833: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
834: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
835: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
836: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
837: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
838: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);
839: hr_utility.trace('i_ai_prem : '||p_ins_info_rec.annual_prem);
840: end if;
841: --

Line 838: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);

834: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
835: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
836: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
837: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
838: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);
839: hr_utility.trace('i_ai_prem : '||p_ins_info_rec.annual_prem);
840: end if;
841: --
842: end if;

Line 839: hr_utility.trace('i_ai_prem : '||p_ins_info_rec.annual_prem);

835: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
836: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
837: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
838: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);
839: hr_utility.trace('i_ai_prem : '||p_ins_info_rec.annual_prem);
840: end if;
841: --
842: end if;
843: --

Line 849: hr_utility.set_location(l_proc,40);

845: p_inputs => l_inputs,
846: p_outputs => l_outputs);
847: --
848: if g_debug then
849: hr_utility.set_location(l_proc,40);
850: end if;
851: --
852: if l_outputs.count >= 1 then
853: --

Line 867: hr_utility.set_location(l_proc,50);

863: --
864: end loop;
865: --
866: if g_debug then
867: hr_utility.set_location(l_proc,50);
868: hr_utility.trace('eqi_prem : '||p_eqi_prem);
869: hr_utility.trace('ai_prem : '||p_ai_prem);
870: hr_utility.trace('message : '||substrb(p_message,1,300));
871: end if;

Line 868: hr_utility.trace('eqi_prem : '||p_eqi_prem);

864: end loop;
865: --
866: if g_debug then
867: hr_utility.set_location(l_proc,50);
868: hr_utility.trace('eqi_prem : '||p_eqi_prem);
869: hr_utility.trace('ai_prem : '||p_ai_prem);
870: hr_utility.trace('message : '||substrb(p_message,1,300));
871: end if;
872: --

Line 869: hr_utility.trace('ai_prem : '||p_ai_prem);

865: --
866: if g_debug then
867: hr_utility.set_location(l_proc,50);
868: hr_utility.trace('eqi_prem : '||p_eqi_prem);
869: hr_utility.trace('ai_prem : '||p_ai_prem);
870: hr_utility.trace('message : '||substrb(p_message,1,300));
871: end if;
872: --
873: if p_message is not null then

Line 870: hr_utility.trace('message : '||substrb(p_message,1,300));

866: if g_debug then
867: hr_utility.set_location(l_proc,50);
868: hr_utility.trace('eqi_prem : '||p_eqi_prem);
869: hr_utility.trace('ai_prem : '||p_ai_prem);
870: hr_utility.trace('message : '||substrb(p_message,1,300));
871: end if;
872: --
873: if p_message is not null then
874: --

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

872: --
873: if p_message is not null then
874: --
875: if g_debug then
876: hr_utility.set_location(l_proc,60);
877: end if;
878: --
879: fnd_file.put_line(fnd_file.output,'Assignment Id : '||fnd_number.number_to_canonical(g_assignment_id));
880: fnd_file.put_line(fnd_file.output,'----------------------------------------------------------------------------------------------------');

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

881: fnd_file.put_line(fnd_file.output,p_message);
882: fnd_file.put_line(fnd_file.output,' ');
883: --
884: if g_debug then
885: hr_utility.set_location(l_proc,70);
886: end if;
887: --
888: end if;
889: --

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

891: --
892: end if;
893: --
894: if g_debug then
895: hr_utility.set_location(l_proc,1000);
896: end if;
897: --
898: end calc_ai_annual_prem;
899: --

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

989: --
990: begin
991: --
992: if g_debug then
993: hr_utility.set_location(l_proc,0);
994: end if;
995: --
996: p_entry_rec.ins_entry_cnt := 0;
997: p_entry_rec.ins_datetrack_update_mode := null;

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

1089: end loop;
1090: close csr_entry;
1091: --
1092: if g_debug then
1093: hr_utility.set_location(l_proc,1000);
1094: end if;
1095: --
1096: end fetch_entry;
1097: --

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

1383: --
1384: begin
1385: --
1386: if g_debug then
1387: hr_utility.set_location(l_proc,0);
1388: end if;
1389: --
1390: if g_archive_default_flag = 'Y' then
1391: --

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

1389: --
1390: if g_archive_default_flag = 'Y' then
1391: --
1392: if g_debug then
1393: hr_utility.set_location(l_proc,10);
1394: end if;
1395: --
1396: open csr_emp;
1397: fetch csr_emp into l_csr_emp;

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

1397: fetch csr_emp into l_csr_emp;
1398: close csr_emp;
1399: --
1400: if g_debug then
1401: hr_utility.set_location(l_proc,20);
1402: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1403: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1404: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1405: hr_utility.trace('last_name : '||l_csr_emp.last_name);

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

1398: close csr_emp;
1399: --
1400: if g_debug then
1401: hr_utility.set_location(l_proc,20);
1402: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1403: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1404: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1405: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1406: hr_utility.trace('first_name : '||l_csr_emp.first_name);

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

1399: --
1400: if g_debug then
1401: hr_utility.set_location(l_proc,20);
1402: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1403: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1404: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1405: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1406: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1407: hr_utility.trace('full_name : '||l_csr_emp.full_name);

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

1400: if g_debug then
1401: hr_utility.set_location(l_proc,20);
1402: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1403: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1404: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1405: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1406: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1407: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1408: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);

Line 1405: hr_utility.trace('last_name : '||l_csr_emp.last_name);

1401: hr_utility.set_location(l_proc,20);
1402: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1403: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1404: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1405: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1406: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1407: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1408: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);
1409: hr_utility.trace('address : '||l_csr_emp.address);

Line 1406: hr_utility.trace('first_name : '||l_csr_emp.first_name);

1402: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1403: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1404: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1405: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1406: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1407: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1408: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);
1409: hr_utility.trace('address : '||l_csr_emp.address);
1410: end if;

Line 1407: hr_utility.trace('full_name : '||l_csr_emp.full_name);

1403: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1404: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1405: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1406: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1407: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1408: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);
1409: hr_utility.trace('address : '||l_csr_emp.address);
1410: end if;
1411: --

Line 1408: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);

1404: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1405: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1406: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1407: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1408: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);
1409: hr_utility.trace('address : '||l_csr_emp.address);
1410: end if;
1411: --
1412: if g_debug then

Line 1409: hr_utility.trace('address : '||l_csr_emp.address);

1405: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1406: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1407: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1408: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);
1409: hr_utility.trace('address : '||l_csr_emp.address);
1410: end if;
1411: --
1412: if g_debug then
1413: hr_utility.trace('start create_emp');

Line 1413: hr_utility.trace('start create_emp');

1409: hr_utility.trace('address : '||l_csr_emp.address);
1410: end if;
1411: --
1412: if g_debug then
1413: hr_utility.trace('start create_emp');
1414: end if;
1415: --
1416: pay_jp_isdf_dml_pkg.create_emp(
1417: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

Line 1433: hr_utility.trace('end create_emp');

1429: p_address => l_csr_emp.address,
1430: p_object_version_number => l_object_version_number);
1431: --
1432: if g_debug then
1433: hr_utility.trace('end create_emp');
1434: hr_utility.set_location(l_proc,30);
1435: hr_utility.trace('start create_entry');
1436: end if;
1437: --

Line 1434: hr_utility.set_location(l_proc,30);

1430: p_object_version_number => l_object_version_number);
1431: --
1432: if g_debug then
1433: hr_utility.trace('end create_emp');
1434: hr_utility.set_location(l_proc,30);
1435: hr_utility.trace('start create_entry');
1436: end if;
1437: --
1438: -- jp_isdf_entry is fetched in the transfer process since transfer date can be specified as different from archive date,

Line 1435: hr_utility.trace('start create_entry');

1431: --
1432: if g_debug then
1433: hr_utility.trace('end create_emp');
1434: hr_utility.set_location(l_proc,30);
1435: hr_utility.trace('start create_entry');
1436: end if;
1437: --
1438: -- jp_isdf_entry is fetched in the transfer process since transfer date can be specified as different from archive date,
1439: -- archive data in this archive time will be meaningless in the transfer time.

Line 1488: hr_utility.trace('end create_entry');

1484: --
1485: end if;
1486: --
1487: if g_debug then
1488: hr_utility.trace('end create_entry');
1489: hr_utility.set_location(l_proc,40);
1490: end if;
1491: --
1492: if g_copy_archive_pact_id is null then

Line 1489: hr_utility.set_location(l_proc,40);

1485: end if;
1486: --
1487: if g_debug then
1488: hr_utility.trace('end create_entry');
1489: hr_utility.set_location(l_proc,40);
1490: end if;
1491: --
1492: if g_copy_archive_pact_id is null then
1493: --

Line 1495: hr_utility.trace('start create_life_gen');

1491: --
1492: if g_copy_archive_pact_id is null then
1493: --
1494: if g_debug then
1495: hr_utility.trace('start create_life_gen');
1496: hr_utility.set_location(l_proc,50);
1497: end if;
1498: --
1499: open csr_gen;

Line 1496: hr_utility.set_location(l_proc,50);

1492: if g_copy_archive_pact_id is null then
1493: --
1494: if g_debug then
1495: hr_utility.trace('start create_life_gen');
1496: hr_utility.set_location(l_proc,50);
1497: end if;
1498: --
1499: open csr_gen;
1500: loop

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

1502: fetch csr_gen into l_li_info_rec;
1503: exit when csr_gen%notfound;
1504: --
1505: if g_debug then
1506: hr_utility.set_location(l_proc,60);
1507: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1508: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1509: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1510: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);

Line 1507: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);

1503: exit when csr_gen%notfound;
1504: --
1505: if g_debug then
1506: hr_utility.set_location(l_proc,60);
1507: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1508: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1509: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1510: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1511: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);

Line 1508: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);

1504: --
1505: if g_debug then
1506: hr_utility.set_location(l_proc,60);
1507: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1508: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1509: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1510: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1511: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1512: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);

Line 1509: hr_utility.trace('info_type : '||l_li_info_rec.info_type);

1505: if g_debug then
1506: hr_utility.set_location(l_proc,60);
1507: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1508: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1509: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1510: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1511: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1512: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1513: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);

Line 1510: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);

1506: hr_utility.set_location(l_proc,60);
1507: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1508: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1509: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1510: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1511: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1512: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1513: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);

Line 1511: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);

1507: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1508: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1509: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1510: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1511: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1512: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1513: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);

Line 1512: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);

1508: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1509: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1510: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1511: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1512: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1513: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);

Line 1513: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);

1509: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1510: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1511: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1512: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1513: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));

Line 1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);

1510: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1511: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1512: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1513: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));

Line 1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);

1511: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1512: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1513: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);

Line 1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);

1512: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1513: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));

Line 1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));

1513: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

Line 1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));

1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

Line 1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);

1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1523: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);

Line 1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));

1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1523: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1524: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

Line 1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1523: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1524: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1525: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));

Line 1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1523: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1524: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1525: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1526: end if;

Line 1523: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);

1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1523: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1524: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1525: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1526: end if;
1527: --

Line 1524: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1523: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1524: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1525: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1526: end if;
1527: --
1528: l_lig_prem := null;

Line 1525: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));

1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1523: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1524: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1525: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1526: end if;
1527: --
1528: l_lig_prem := null;
1529: --

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

1537: --
1538: end if;
1539: --
1540: if g_debug then
1541: hr_utility.set_location(l_proc,70);
1542: hr_utility.trace('annual_prem : '||l_lig_prem);
1543: end if;
1544: --
1545: pay_jp_isdf_dml_pkg.create_life_gen(

Line 1542: hr_utility.trace('annual_prem : '||l_lig_prem);

1538: end if;
1539: --
1540: if g_debug then
1541: hr_utility.set_location(l_proc,70);
1542: hr_utility.trace('annual_prem : '||l_lig_prem);
1543: end if;
1544: --
1545: pay_jp_isdf_dml_pkg.create_life_gen(
1546: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

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

1563: p_annual_prem => l_lig_prem,
1564: p_object_version_number => l_object_version_number);
1565: --
1566: if g_debug then
1567: hr_utility.set_location(l_proc,80);
1568: end if;
1569: --
1570: end loop;
1571: close csr_gen;

Line 1574: hr_utility.trace('end create_life_gen');

1570: end loop;
1571: close csr_gen;
1572: --
1573: if g_debug then
1574: hr_utility.trace('end create_life_gen');
1575: hr_utility.set_location(l_proc,90);
1576: hr_utility.trace('start create_life_pens');
1577: end if;
1578: --

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

1571: close csr_gen;
1572: --
1573: if g_debug then
1574: hr_utility.trace('end create_life_gen');
1575: hr_utility.set_location(l_proc,90);
1576: hr_utility.trace('start create_life_pens');
1577: end if;
1578: --
1579: open csr_pens;

Line 1576: hr_utility.trace('start create_life_pens');

1572: --
1573: if g_debug then
1574: hr_utility.trace('end create_life_gen');
1575: hr_utility.set_location(l_proc,90);
1576: hr_utility.trace('start create_life_pens');
1577: end if;
1578: --
1579: open csr_pens;
1580: loop

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

1582: fetch csr_pens into l_li_info_rec;
1583: exit when csr_pens%notfound;
1584: --
1585: if g_debug then
1586: hr_utility.set_location(l_proc,100);
1587: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1588: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1589: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1590: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);

Line 1587: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);

1583: exit when csr_pens%notfound;
1584: --
1585: if g_debug then
1586: hr_utility.set_location(l_proc,100);
1587: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1588: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1589: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1590: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1591: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);

Line 1588: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);

1584: --
1585: if g_debug then
1586: hr_utility.set_location(l_proc,100);
1587: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1588: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1589: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1590: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1591: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1592: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);

Line 1589: hr_utility.trace('info_type : '||l_li_info_rec.info_type);

1585: if g_debug then
1586: hr_utility.set_location(l_proc,100);
1587: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1588: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1589: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1590: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1591: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1592: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1593: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);

Line 1590: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);

1586: hr_utility.set_location(l_proc,100);
1587: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1588: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1589: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1590: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1591: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1592: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1593: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);

Line 1591: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);

1587: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1588: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1589: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1590: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1591: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1592: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1593: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);

Line 1592: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);

1588: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1589: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1590: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1591: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1592: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1593: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);

Line 1593: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);

1589: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1590: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1591: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1592: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1593: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));

Line 1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);

1590: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1591: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1592: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1593: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));

Line 1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);

1591: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1592: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1593: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);

Line 1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);

1592: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1593: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));

Line 1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));

1593: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

Line 1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));

1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

Line 1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);

1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1603: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);

Line 1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));

1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1603: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1604: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

Line 1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1603: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1604: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1605: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));

Line 1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1603: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1604: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1605: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1606: end if;

Line 1603: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);

1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1603: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1604: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1605: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1606: end if;
1607: --

Line 1604: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1603: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1604: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1605: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1606: end if;
1607: --
1608: l_lip_prem := null;

Line 1605: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));

1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1603: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1604: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1605: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1606: end if;
1607: --
1608: l_lip_prem := null;
1609: --

Line 1621: hr_utility.set_location(l_proc,110);

1617: --
1618: end if;
1619: --
1620: if g_debug then
1621: hr_utility.set_location(l_proc,110);
1622: hr_utility.trace('annual_prem : '||l_lip_prem);
1623: end if;
1624: --
1625: pay_jp_isdf_dml_pkg.create_life_pens(

Line 1622: hr_utility.trace('annual_prem : '||l_lip_prem);

1618: end if;
1619: --
1620: if g_debug then
1621: hr_utility.set_location(l_proc,110);
1622: hr_utility.trace('annual_prem : '||l_lip_prem);
1623: end if;
1624: --
1625: pay_jp_isdf_dml_pkg.create_life_pens(
1626: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

Line 1648: hr_utility.set_location(l_proc,120);

1644: p_annual_prem => l_lip_prem,
1645: p_object_version_number => l_object_version_number);
1646: --
1647: if g_debug then
1648: hr_utility.set_location(l_proc,120);
1649: end if;
1650: --
1651: end loop;
1652: close csr_pens;

Line 1655: hr_utility.trace('end create_life_pens');

1651: end loop;
1652: close csr_pens;
1653: --
1654: if g_debug then
1655: hr_utility.trace('end create_life_pens');
1656: hr_utility.set_location(l_proc,130);
1657: hr_utility.trace('start create_nonlife');
1658: end if;
1659: --

Line 1656: hr_utility.set_location(l_proc,130);

1652: close csr_pens;
1653: --
1654: if g_debug then
1655: hr_utility.trace('end create_life_pens');
1656: hr_utility.set_location(l_proc,130);
1657: hr_utility.trace('start create_nonlife');
1658: end if;
1659: --
1660: open csr_nonlife;

Line 1657: hr_utility.trace('start create_nonlife');

1653: --
1654: if g_debug then
1655: hr_utility.trace('end create_life_pens');
1656: hr_utility.set_location(l_proc,130);
1657: hr_utility.trace('start create_nonlife');
1658: end if;
1659: --
1660: open csr_nonlife;
1661: loop

Line 1667: hr_utility.set_location(l_proc,140);

1663: fetch csr_nonlife into l_ai_info_rec;
1664: exit when csr_nonlife%notfound;
1665: --
1666: if g_debug then
1667: hr_utility.set_location(l_proc,140);
1668: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1669: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1670: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1671: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);

Line 1668: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);

1664: exit when csr_nonlife%notfound;
1665: --
1666: if g_debug then
1667: hr_utility.set_location(l_proc,140);
1668: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1669: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1670: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1671: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1672: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);

Line 1669: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);

1665: --
1666: if g_debug then
1667: hr_utility.set_location(l_proc,140);
1668: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1669: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1670: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1671: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1672: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1673: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);

Line 1670: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);

1666: if g_debug then
1667: hr_utility.set_location(l_proc,140);
1668: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1669: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1670: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1671: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1672: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1673: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1674: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);

Line 1671: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);

1667: hr_utility.set_location(l_proc,140);
1668: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1669: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1670: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1671: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1672: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1673: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1674: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1675: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);

Line 1672: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);

1668: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1669: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1670: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1671: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1672: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1673: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1674: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1675: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1676: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);

Line 1673: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);

1669: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1670: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1671: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1672: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1673: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1674: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1675: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1676: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1677: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);

Line 1674: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);

1670: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1671: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1672: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1673: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1674: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1675: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1676: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1677: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1678: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);

Line 1675: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);

1671: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1672: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1673: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1674: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1675: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1676: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1677: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1678: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);

Line 1676: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);

1672: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1673: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1674: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1675: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1676: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1677: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1678: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);

Line 1677: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);

1673: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1674: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1675: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1676: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1677: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1678: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);

Line 1678: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);

1674: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1675: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1676: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1677: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1678: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));

Line 1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);

1675: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1676: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1677: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1678: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));

Line 1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);

1676: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1677: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1678: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);

Line 1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);

1677: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1678: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);

Line 1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));

1678: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);

Line 1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));

1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1687: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);

Line 1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);

1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1687: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1688: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);

Line 1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);

1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1687: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1688: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1689: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);

Line 1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);

1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1687: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1688: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1689: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1690: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));

Line 1687: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);

1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1687: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1688: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1689: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1690: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));
1691: end if;

Line 1688: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);

1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1687: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1688: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1689: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1690: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));
1691: end if;
1692: --

Line 1689: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);

1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1687: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1688: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1689: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1690: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));
1691: end if;
1692: --
1693: l_ai_prem := null;

Line 1690: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));

1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1687: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1688: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1689: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1690: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));
1691: end if;
1692: --
1693: l_ai_prem := null;
1694: l_eqi_prem := null;

Line 1714: hr_utility.set_location(l_proc,150);

1710: --
1711: end if;
1712: --
1713: if g_debug then
1714: hr_utility.set_location(l_proc,150);
1715: hr_utility.trace('ai annual_prem : '||l_ai_prem);
1716: hr_utility.trace('eqi annual_prem : '||l_eqi_prem);
1717: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1718: end if;

Line 1715: hr_utility.trace('ai annual_prem : '||l_ai_prem);

1711: end if;
1712: --
1713: if g_debug then
1714: hr_utility.set_location(l_proc,150);
1715: hr_utility.trace('ai annual_prem : '||l_ai_prem);
1716: hr_utility.trace('eqi annual_prem : '||l_eqi_prem);
1717: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1718: end if;
1719: --

Line 1716: hr_utility.trace('eqi annual_prem : '||l_eqi_prem);

1712: --
1713: if g_debug then
1714: hr_utility.set_location(l_proc,150);
1715: hr_utility.trace('ai annual_prem : '||l_ai_prem);
1716: hr_utility.trace('eqi annual_prem : '||l_eqi_prem);
1717: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1718: end if;
1719: --
1720: pay_jp_isdf_dml_pkg.create_nonlife(

Line 1717: hr_utility.trace('nli annual_prem : '||l_nli_prem);

1713: if g_debug then
1714: hr_utility.set_location(l_proc,150);
1715: hr_utility.trace('ai annual_prem : '||l_ai_prem);
1716: hr_utility.trace('eqi annual_prem : '||l_eqi_prem);
1717: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1718: end if;
1719: --
1720: pay_jp_isdf_dml_pkg.create_nonlife(
1721: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

Line 1744: hr_utility.set_location(l_proc,160);

1740: p_annual_prem => l_ai_prem,
1741: p_object_version_number => l_object_version_number);
1742: --
1743: if g_debug then
1744: hr_utility.set_location(l_proc,160);
1745: end if;
1746: --
1747: end loop;
1748: close csr_nonlife;

Line 1751: hr_utility.trace('end create_nonlife');

1747: end loop;
1748: close csr_nonlife;
1749: --
1750: if g_debug then
1751: hr_utility.trace('end create_nonlife');
1752: hr_utility.set_location(l_proc,170);
1753: hr_utility.trace('start create_spouse');
1754: end if;
1755: --

Line 1752: hr_utility.set_location(l_proc,170);

1748: close csr_nonlife;
1749: --
1750: if g_debug then
1751: hr_utility.trace('end create_nonlife');
1752: hr_utility.set_location(l_proc,170);
1753: hr_utility.trace('start create_spouse');
1754: end if;
1755: --
1756: l_spouse_rec.spouse_type := null;

Line 1753: hr_utility.trace('start create_spouse');

1749: --
1750: if g_debug then
1751: hr_utility.trace('end create_nonlife');
1752: hr_utility.set_location(l_proc,170);
1753: hr_utility.trace('start create_spouse');
1754: end if;
1755: --
1756: l_spouse_rec.spouse_type := null;
1757: l_spouse_rec.widow_type := null;

Line 1808: hr_utility.trace('end create_spouse');

1804: --
1805: end if;
1806: --
1807: if g_debug then
1808: hr_utility.trace('end create_spouse');
1809: hr_utility.set_location(l_proc,180);
1810: end if;
1811: --
1812: -- copy previous archive information to current archive

Line 1809: hr_utility.set_location(l_proc,180);

1805: end if;
1806: --
1807: if g_debug then
1808: hr_utility.trace('end create_spouse');
1809: hr_utility.set_location(l_proc,180);
1810: end if;
1811: --
1812: -- copy previous archive information to current archive
1813: -- this function will be useful in case of re-yea

Line 1819: hr_utility.set_location(l_proc,190);

1815: --
1816: else
1817: --
1818: if g_debug then
1819: hr_utility.set_location(l_proc,190);
1820: hr_utility.trace('copy pact id : '||g_copy_archive_pact_id);
1821: end if;
1822: --
1823: open csr_copy_assact;

Line 1820: hr_utility.trace('copy pact id : '||g_copy_archive_pact_id);

1816: else
1817: --
1818: if g_debug then
1819: hr_utility.set_location(l_proc,190);
1820: hr_utility.trace('copy pact id : '||g_copy_archive_pact_id);
1821: end if;
1822: --
1823: open csr_copy_assact;
1824: fetch csr_copy_assact into l_copy_archive_assact_id;

Line 1828: hr_utility.set_location(l_proc,200);

1824: fetch csr_copy_assact into l_copy_archive_assact_id;
1825: close csr_copy_assact;
1826: --
1827: if g_debug then
1828: hr_utility.set_location(l_proc,200);
1829: hr_utility.trace('copy assact id : '||l_copy_archive_assact_id);
1830: end if;
1831: --
1832: if l_copy_archive_assact_id is not null then

Line 1829: hr_utility.trace('copy assact id : '||l_copy_archive_assact_id);

1825: close csr_copy_assact;
1826: --
1827: if g_debug then
1828: hr_utility.set_location(l_proc,200);
1829: hr_utility.trace('copy assact id : '||l_copy_archive_assact_id);
1830: end if;
1831: --
1832: if l_copy_archive_assact_id is not null then
1833: --

Line 1835: hr_utility.set_location(l_proc,210);

1831: --
1832: if l_copy_archive_assact_id is not null then
1833: --
1834: if g_debug then
1835: hr_utility.set_location(l_proc,210);
1836: hr_utility.trace('start copy life_gen');
1837: end if;
1838: --
1839: open csr_copy_life_gen;

Line 1836: hr_utility.trace('start copy life_gen');

1832: if l_copy_archive_assact_id is not null then
1833: --
1834: if g_debug then
1835: hr_utility.set_location(l_proc,210);
1836: hr_utility.trace('start copy life_gen');
1837: end if;
1838: --
1839: open csr_copy_life_gen;
1840: loop

Line 1870: hr_utility.trace('end copy life_gen');

1866: end loop;
1867: close csr_copy_life_gen;
1868: --
1869: if g_debug then
1870: hr_utility.trace('end copy life_gen');
1871: hr_utility.set_location(l_proc,220);
1872: hr_utility.trace('start copy life_pens');
1873: end if;
1874: --

Line 1871: hr_utility.set_location(l_proc,220);

1867: close csr_copy_life_gen;
1868: --
1869: if g_debug then
1870: hr_utility.trace('end copy life_gen');
1871: hr_utility.set_location(l_proc,220);
1872: hr_utility.trace('start copy life_pens');
1873: end if;
1874: --
1875: open csr_copy_life_pens;

Line 1872: hr_utility.trace('start copy life_pens');

1868: --
1869: if g_debug then
1870: hr_utility.trace('end copy life_gen');
1871: hr_utility.set_location(l_proc,220);
1872: hr_utility.trace('start copy life_pens');
1873: end if;
1874: --
1875: open csr_copy_life_pens;
1876: loop

Line 1907: hr_utility.trace('end copy life_pens');

1903: end loop;
1904: close csr_copy_life_pens;
1905: --
1906: if g_debug then
1907: hr_utility.trace('end copy life_pens');
1908: hr_utility.set_location(l_proc,230);
1909: hr_utility.trace('start copy nonlife');
1910: end if;
1911: --

Line 1908: hr_utility.set_location(l_proc,230);

1904: close csr_copy_life_pens;
1905: --
1906: if g_debug then
1907: hr_utility.trace('end copy life_pens');
1908: hr_utility.set_location(l_proc,230);
1909: hr_utility.trace('start copy nonlife');
1910: end if;
1911: --
1912: open csr_copy_nonlife;

Line 1909: hr_utility.trace('start copy nonlife');

1905: --
1906: if g_debug then
1907: hr_utility.trace('end copy life_pens');
1908: hr_utility.set_location(l_proc,230);
1909: hr_utility.trace('start copy nonlife');
1910: end if;
1911: --
1912: open csr_copy_nonlife;
1913: loop

Line 1945: hr_utility.trace('end copy nonlife');

1941: end loop;
1942: close csr_copy_nonlife;
1943: --
1944: if g_debug then
1945: hr_utility.trace('end copy nonlife');
1946: hr_utility.set_location(l_proc,240);
1947: hr_utility.trace('start copy social');
1948: end if;
1949: --

Line 1946: hr_utility.set_location(l_proc,240);

1942: close csr_copy_nonlife;
1943: --
1944: if g_debug then
1945: hr_utility.trace('end copy nonlife');
1946: hr_utility.set_location(l_proc,240);
1947: hr_utility.trace('start copy social');
1948: end if;
1949: --
1950: open csr_copy_social;

Line 1947: hr_utility.trace('start copy social');

1943: --
1944: if g_debug then
1945: hr_utility.trace('end copy nonlife');
1946: hr_utility.set_location(l_proc,240);
1947: hr_utility.trace('start copy social');
1948: end if;
1949: --
1950: open csr_copy_social;
1951: loop

Line 1976: hr_utility.trace('end copy social');

1972: end loop;
1973: close csr_copy_social;
1974: --
1975: if g_debug then
1976: hr_utility.trace('end copy social');
1977: hr_utility.set_location(l_proc,250);
1978: hr_utility.trace('start copy mutual_aid');
1979: end if;
1980: --

Line 1977: hr_utility.set_location(l_proc,250);

1973: close csr_copy_social;
1974: --
1975: if g_debug then
1976: hr_utility.trace('end copy social');
1977: hr_utility.set_location(l_proc,250);
1978: hr_utility.trace('start copy mutual_aid');
1979: end if;
1980: --
1981: open csr_copy_mutual_aid;

Line 1978: hr_utility.trace('start copy mutual_aid');

1974: --
1975: if g_debug then
1976: hr_utility.trace('end copy social');
1977: hr_utility.set_location(l_proc,250);
1978: hr_utility.trace('start copy mutual_aid');
1979: end if;
1980: --
1981: open csr_copy_mutual_aid;
1982: loop

Line 2004: hr_utility.trace('end copy mutual_aid');

2000: end loop;
2001: close csr_copy_mutual_aid;
2002: --
2003: if g_debug then
2004: hr_utility.trace('end copy mutual_aid');
2005: hr_utility.set_location(l_proc,260);
2006: hr_utility.trace('start copy spouse');
2007: end if;
2008: --

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

2001: close csr_copy_mutual_aid;
2002: --
2003: if g_debug then
2004: hr_utility.trace('end copy mutual_aid');
2005: hr_utility.set_location(l_proc,260);
2006: hr_utility.trace('start copy spouse');
2007: end if;
2008: --
2009: open csr_copy_spouse;

Line 2006: hr_utility.trace('start copy spouse');

2002: --
2003: if g_debug then
2004: hr_utility.trace('end copy mutual_aid');
2005: hr_utility.set_location(l_proc,260);
2006: hr_utility.trace('start copy spouse');
2007: end if;
2008: --
2009: open csr_copy_spouse;
2010: loop

Line 2038: hr_utility.trace('end copy spouse');

2034: end loop;
2035: close csr_copy_spouse;
2036: --
2037: if g_debug then
2038: hr_utility.trace('end copy spouse');
2039: hr_utility.set_location(l_proc,270);
2040: hr_utility.trace('start copy spouse_inc');
2041: end if;
2042: --

Line 2039: hr_utility.set_location(l_proc,270);

2035: close csr_copy_spouse;
2036: --
2037: if g_debug then
2038: hr_utility.trace('end copy spouse');
2039: hr_utility.set_location(l_proc,270);
2040: hr_utility.trace('start copy spouse_inc');
2041: end if;
2042: --
2043: open csr_copy_spouse_inc;

Line 2040: hr_utility.trace('start copy spouse_inc');

2036: --
2037: if g_debug then
2038: hr_utility.trace('end copy spouse');
2039: hr_utility.set_location(l_proc,270);
2040: hr_utility.trace('start copy spouse_inc');
2041: end if;
2042: --
2043: open csr_copy_spouse_inc;
2044: loop

Line 2080: hr_utility.trace('end copy spouse_inc');

2076: end loop;
2077: close csr_copy_spouse_inc;
2078: --
2079: if g_debug then
2080: hr_utility.trace('end copy spouse_inc');
2081: hr_utility.set_location(l_proc,280);
2082: end if;
2083: --
2084: end if;

Line 2081: hr_utility.set_location(l_proc,280);

2077: close csr_copy_spouse_inc;
2078: --
2079: if g_debug then
2080: hr_utility.trace('end copy spouse_inc');
2081: hr_utility.set_location(l_proc,280);
2082: end if;
2083: --
2084: end if;
2085: --

Line 2087: hr_utility.set_location(l_proc,290);

2083: --
2084: end if;
2085: --
2086: if g_debug then
2087: hr_utility.set_location(l_proc,290);
2088: end if;
2089: --
2090: end if;
2091: --

Line 2093: hr_utility.set_location(l_proc,300);

2089: --
2090: end if;
2091: --
2092: if g_debug then
2093: hr_utility.set_location(l_proc,300);
2094: end if;
2095: --
2096: end if;
2097: --

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

2095: --
2096: end if;
2097: --
2098: if g_debug then
2099: hr_utility.set_location(l_proc,1000);
2100: end if;
2101: --
2102: end archive_assact;
2103: --

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

2113: --
2114: begin
2115: --
2116: if g_debug then
2117: hr_utility.set_location(l_proc,0);
2118: end if;
2119: --
2120: if g_archive_default_flag = 'Y' then
2121: --

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

2119: --
2120: if g_archive_default_flag = 'Y' then
2121: --
2122: if g_debug then
2123: hr_utility.set_location(l_proc,10);
2124: hr_utility.trace('action_information_id : '||p_action_information_id);
2125: hr_utility.trace('object_version_number : '||p_object_version_number);
2126: end if;
2127: --

Line 2124: hr_utility.trace('action_information_id : '||p_action_information_id);

2120: if g_archive_default_flag = 'Y' then
2121: --
2122: if g_debug then
2123: hr_utility.set_location(l_proc,10);
2124: hr_utility.trace('action_information_id : '||p_action_information_id);
2125: hr_utility.trace('object_version_number : '||p_object_version_number);
2126: end if;
2127: --
2128: -- include lock assact (only transaction,ovn will be changed, others same as new condition)

Line 2125: hr_utility.trace('object_version_number : '||p_object_version_number);

2121: --
2122: if g_debug then
2123: hr_utility.set_location(l_proc,10);
2124: hr_utility.trace('action_information_id : '||p_action_information_id);
2125: hr_utility.trace('object_version_number : '||p_object_version_number);
2126: end if;
2127: --
2128: -- include lock assact (only transaction,ovn will be changed, others same as new condition)
2129: pay_jp_isdf_dml_pkg.update_assact(

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

2138: p_transfer_date => null,
2139: p_expiry_date => null);
2140: --
2141: if g_debug then
2142: hr_utility.set_location(l_proc,20);
2143: end if;
2144: --
2145: end if;
2146: --

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

2144: --
2145: end if;
2146: --
2147: if g_debug then
2148: hr_utility.set_location(l_proc,1000);
2149: end if;
2150: --
2151: end post_assact;
2152: --

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

2168: --
2169: begin
2170: --
2171: if g_debug then
2172: hr_utility.set_location(l_proc,0);
2173: end if;
2174: --
2175: select assignment_id
2176: into l_assignment_id

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

2177: from pay_assignment_actions
2178: where assignment_action_id = p_assignment_action_id;
2179: --
2180: if g_debug then
2181: hr_utility.set_location(l_proc,10);
2182: end if;
2183: --
2184: -- set context.
2185: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));

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

2186: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(l_assignment_id));
2187: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
2188: --
2189: if g_debug then
2190: hr_utility.set_location(l_proc,20);
2191: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));
2192: hr_utility.trace('assignment_id : '||l_assignment_id);
2193: hr_utility.trace('tax_type : '||l_tax_type);
2194: end if;

Line 2191: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));

2187: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
2188: --
2189: if g_debug then
2190: hr_utility.set_location(l_proc,20);
2191: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));
2192: hr_utility.trace('assignment_id : '||l_assignment_id);
2193: hr_utility.trace('tax_type : '||l_tax_type);
2194: end if;
2195: --

Line 2192: hr_utility.trace('assignment_id : '||l_assignment_id);

2188: --
2189: if g_debug then
2190: hr_utility.set_location(l_proc,20);
2191: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));
2192: hr_utility.trace('assignment_id : '||l_assignment_id);
2193: hr_utility.trace('tax_type : '||l_tax_type);
2194: end if;
2195: --
2196: if l_tax_type not in ('M_KOU','D_KOU') then

Line 2193: hr_utility.trace('tax_type : '||l_tax_type);

2189: if g_debug then
2190: hr_utility.set_location(l_proc,20);
2191: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));
2192: hr_utility.trace('assignment_id : '||l_assignment_id);
2193: hr_utility.trace('tax_type : '||l_tax_type);
2194: end if;
2195: --
2196: if l_tax_type not in ('M_KOU','D_KOU') then
2197: --

Line 2204: hr_utility.set_location(l_proc,30);

2200: --
2201: else
2202: --
2203: if g_debug then
2204: hr_utility.set_location(l_proc,30);
2205: hr_utility.trace('start create_assact');
2206: end if;
2207: --
2208: l_action_information_id := pay_jp_isdf_dml_pkg.next_action_information_id;

Line 2205: hr_utility.trace('start create_assact');

2201: else
2202: --
2203: if g_debug then
2204: hr_utility.set_location(l_proc,30);
2205: hr_utility.trace('start create_assact');
2206: end if;
2207: --
2208: l_action_information_id := pay_jp_isdf_dml_pkg.next_action_information_id;
2209: --

Line 2229: hr_utility.trace('end create_assact');

2225: p_expiry_date => null,
2226: p_object_version_number => l_object_version_number);
2227: --
2228: if g_debug then
2229: hr_utility.trace('end create_assact');
2230: hr_utility.set_location(l_proc,40);
2231: end if;
2232: --
2233: init_assact(

Line 2230: hr_utility.set_location(l_proc,40);

2226: p_object_version_number => l_object_version_number);
2227: --
2228: if g_debug then
2229: hr_utility.trace('end create_assact');
2230: hr_utility.set_location(l_proc,40);
2231: end if;
2232: --
2233: init_assact(
2234: p_assignment_action_id => p_assignment_action_id,

Line 2238: hr_utility.set_location(l_proc,50);

2234: p_assignment_action_id => p_assignment_action_id,
2235: p_assignment_id => l_assignment_id);
2236: --
2237: if g_debug then
2238: hr_utility.set_location(l_proc,50);
2239: end if;
2240: --
2241: archive_assact(
2242: p_assignment_action_id => p_assignment_action_id,

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

2242: p_assignment_action_id => p_assignment_action_id,
2243: p_assignment_id => l_assignment_id);
2244: --
2245: if g_debug then
2246: hr_utility.set_location(l_proc,60);
2247: hr_utility.trace('assignment_action_id : '||p_assignment_action_id);
2248: hr_utility.trace('action_information_id : '||l_action_information_id);
2249: hr_utility.trace('object_version_number : '||l_object_version_number);
2250: end if;

Line 2247: hr_utility.trace('assignment_action_id : '||p_assignment_action_id);

2243: p_assignment_id => l_assignment_id);
2244: --
2245: if g_debug then
2246: hr_utility.set_location(l_proc,60);
2247: hr_utility.trace('assignment_action_id : '||p_assignment_action_id);
2248: hr_utility.trace('action_information_id : '||l_action_information_id);
2249: hr_utility.trace('object_version_number : '||l_object_version_number);
2250: end if;
2251: --

Line 2248: hr_utility.trace('action_information_id : '||l_action_information_id);

2244: --
2245: if g_debug then
2246: hr_utility.set_location(l_proc,60);
2247: hr_utility.trace('assignment_action_id : '||p_assignment_action_id);
2248: hr_utility.trace('action_information_id : '||l_action_information_id);
2249: hr_utility.trace('object_version_number : '||l_object_version_number);
2250: end if;
2251: --
2252: -- update transaction status from U to N because archive has been made.

Line 2249: hr_utility.trace('object_version_number : '||l_object_version_number);

2245: if g_debug then
2246: hr_utility.set_location(l_proc,60);
2247: hr_utility.trace('assignment_action_id : '||p_assignment_action_id);
2248: hr_utility.trace('action_information_id : '||l_action_information_id);
2249: hr_utility.trace('object_version_number : '||l_object_version_number);
2250: end if;
2251: --
2252: -- update transaction status from U to N because archive has been made.
2253: post_assact(

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

2254: p_action_information_id => l_action_information_id,
2255: p_object_version_number => l_object_version_number);
2256: --
2257: if g_debug then
2258: hr_utility.set_location(l_proc,70);
2259: end if;
2260: --
2261: end if;
2262: --

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

2260: --
2261: end if;
2262: --
2263: if g_debug then
2264: hr_utility.set_location(l_proc,1000);
2265: end if;
2266: --
2267: end archive_data;
2268: --

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

2277: --
2278: begin
2279: --
2280: if g_debug then
2281: hr_utility.set_location(l_proc,0);
2282: end if;
2283: --
2284: -- invoke in case of mark for retry.
2285: init_pact(p_payroll_action_id);

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

2284: -- invoke in case of mark for retry.
2285: init_pact(p_payroll_action_id);
2286: --
2287: if g_debug then
2288: hr_utility.set_location(l_proc,10);
2289: end if;
2290: --
2291: archive_pact(p_payroll_action_id);
2292: --

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

2290: --
2291: archive_pact(p_payroll_action_id);
2292: --
2293: if g_debug then
2294: hr_utility.set_location(l_proc,1000);
2295: end if;
2296: --
2297: end deinitialize_code;
2298: --