APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on HR_UTILITY

Line 34: g_debug boolean := hr_utility.debug_enabled;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

329: --
330: end if;
331: --
332: if g_debug then
333: hr_utility.set_location(l_proc,1000);
334: end if;
335: --
336: end range_cursor;
337: --

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

374: --
375: begin
376: --
377: if g_debug then
378: hr_utility.set_location(l_proc,0);
379: end if;
380: --
381: -- Reset global variable in case of multiple threads.
382: init_pact(p_payroll_action_id);

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

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

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

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

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

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

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

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

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

410: end loop ass_exist;
411: --
412: if g_debug then
413: hr_utility.set_location(l_proc,30);
414: hr_utility.trace('assignment id : '||l_assignment_id);
415: end if;
416: --
417: else
418: --

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

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

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

419: l_assignment_id := l_csr_proc_ass.assignment_id;
420: --
421: if g_debug then
422: hr_utility.set_location(l_proc,40);
423: hr_utility.trace('assignment id : '||l_assignment_id);
424: end if;
425: --
426: end if;
427: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

469: chunk => p_chunk_number,
470: greid => null);
471: --
472: if g_debug then
473: hr_utility.set_location(l_proc,90);
474: hr_utility.trace('assignment_action_id : '||l_assignment_action_id);
475: end if;
476: --
477: end if;

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

470: greid => null);
471: --
472: if g_debug then
473: hr_utility.set_location(l_proc,90);
474: hr_utility.trace('assignment_action_id : '||l_assignment_action_id);
475: end if;
476: --
477: end if;
478: --

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

483: end loop;
484: close csr_proc_ass;
485: --
486: if g_debug then
487: hr_utility.set_location(l_proc,1000);
488: end if;
489: --
490: end assignment_action_creation;
491: --

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

498: l_proc varchar2(80) := c_package||'archinit';
499: begin
500: --
501: if g_debug then
502: hr_utility.set_location(l_proc,0);
503: end if;
504: --
505: init_pact(p_payroll_action_id);
506: ff_exec.reset_caches;

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

505: init_pact(p_payroll_action_id);
506: ff_exec.reset_caches;
507: --
508: if g_debug then
509: hr_utility.set_location(l_proc,1000);
510: end if;
511: --
512: end archinit;
513: --

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

523: --
524: begin
525: --
526: if g_debug then
527: hr_utility.set_location(l_proc,0);
528: end if;
529: --
530: if g_assignment_action_id is null
531: or g_assignment_action_id <> p_assignment_action_id then

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

530: if g_assignment_action_id is null
531: or g_assignment_action_id <> p_assignment_action_id then
532: --
533: if g_debug then
534: hr_utility.set_location(l_proc,10);
535: hr_utility.trace('no cache : g_assact_id('||g_assignment_action_id||'),p_assact_id('||p_assignment_action_id||')');
536: end if;
537: --
538: g_assignment_action_id := p_assignment_action_id;

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

531: or g_assignment_action_id <> p_assignment_action_id then
532: --
533: if g_debug then
534: hr_utility.set_location(l_proc,10);
535: hr_utility.trace('no cache : g_assact_id('||g_assignment_action_id||'),p_assact_id('||p_assignment_action_id||')');
536: end if;
537: --
538: g_assignment_action_id := p_assignment_action_id;
539: g_assignment_id := p_assignment_id;

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

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

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

541: end if;
542: --
543: if g_debug then
544: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
545: hr_utility.trace('assignment_id : '||g_assignment_id);
546: hr_utility.set_location(l_proc,1000);
547: end if;
548: --
549: end init_assact;

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

542: --
543: if g_debug then
544: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
545: hr_utility.trace('assignment_id : '||g_assignment_id);
546: hr_utility.set_location(l_proc,1000);
547: end if;
548: --
549: end init_assact;
550: --

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

577: --
578: begin
579: --
580: if g_debug then
581: hr_utility.set_location(l_proc,0);
582: end if;
583: --
584: open csr_ff;
585: fetch csr_ff into l_formula_id;

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

585: fetch csr_ff into l_formula_id;
586: close csr_ff;
587: --
588: if g_debug then
589: hr_utility.set_location(l_proc,10);
590: hr_utility.trace('formula_id : '||l_formula_id);
591: end if;
592: --
593: if l_formula_id is not null then

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

586: close csr_ff;
587: --
588: if g_debug then
589: hr_utility.set_location(l_proc,10);
590: hr_utility.trace('formula_id : '||l_formula_id);
591: end if;
592: --
593: if l_formula_id is not null then
594: --

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

598: p_inputs => l_inputs,
599: p_outputs => l_outputs);
600: --
601: if g_debug then
602: hr_utility.set_location(l_proc,20);
603: end if;
604: --
605: if l_inputs.count > 1 then
606: --

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

653: --
654: end loop;
655: --
656: if g_debug then
657: hr_utility.set_location(l_proc,30);
658: hr_utility.trace('business_group_id : '||g_business_group_id);
659: hr_utility.trace('payroll_id : '||g_payroll_id);
660: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
661: hr_utility.trace('assignment_id : '||g_assignment_id);

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

654: end loop;
655: --
656: if g_debug then
657: hr_utility.set_location(l_proc,30);
658: hr_utility.trace('business_group_id : '||g_business_group_id);
659: hr_utility.trace('payroll_id : '||g_payroll_id);
660: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
661: hr_utility.trace('assignment_id : '||g_assignment_id);
662: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);

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

655: --
656: if g_debug then
657: hr_utility.set_location(l_proc,30);
658: hr_utility.trace('business_group_id : '||g_business_group_id);
659: hr_utility.trace('payroll_id : '||g_payroll_id);
660: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
661: hr_utility.trace('assignment_id : '||g_assignment_id);
662: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
663: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));

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

656: if g_debug then
657: hr_utility.set_location(l_proc,30);
658: hr_utility.trace('business_group_id : '||g_business_group_id);
659: hr_utility.trace('payroll_id : '||g_payroll_id);
660: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
661: hr_utility.trace('assignment_id : '||g_assignment_id);
662: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
663: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
664: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);

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

657: hr_utility.set_location(l_proc,30);
658: hr_utility.trace('business_group_id : '||g_business_group_id);
659: hr_utility.trace('payroll_id : '||g_payroll_id);
660: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
661: hr_utility.trace('assignment_id : '||g_assignment_id);
662: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
663: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
664: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
665: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);

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

658: hr_utility.trace('business_group_id : '||g_business_group_id);
659: hr_utility.trace('payroll_id : '||g_payroll_id);
660: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
661: hr_utility.trace('assignment_id : '||g_assignment_id);
662: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
663: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
664: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
665: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
666: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);

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

659: hr_utility.trace('payroll_id : '||g_payroll_id);
660: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
661: hr_utility.trace('assignment_id : '||g_assignment_id);
662: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
663: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
664: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
665: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
666: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
667: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);

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

660: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
661: hr_utility.trace('assignment_id : '||g_assignment_id);
662: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
663: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
664: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
665: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
666: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
667: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
668: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);

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

661: hr_utility.trace('assignment_id : '||g_assignment_id);
662: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
663: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
664: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
665: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
666: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
667: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
668: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
669: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);

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

662: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
663: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
664: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
665: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
666: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
667: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
668: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
669: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
670: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);

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

663: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
664: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
665: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
666: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
667: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
668: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
669: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
670: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
671: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);

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

664: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
665: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
666: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
667: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
668: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
669: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
670: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
671: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
672: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);

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

665: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
666: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
667: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
668: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
669: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
670: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
671: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
672: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
673: hr_utility.trace('i_cmi_prem_bal : '||p_ins_info_rec.cmi_prem_bal);

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

666: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
667: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
668: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
669: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
670: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
671: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
672: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
673: hr_utility.trace('i_cmi_prem_bal : '||p_ins_info_rec.cmi_prem_bal);
674: hr_utility.trace('i_cmi_prem_mth_ele : '||p_ins_info_rec.cmi_prem_mth_ele);

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

667: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);
668: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
669: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
670: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
671: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
672: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
673: hr_utility.trace('i_cmi_prem_bal : '||p_ins_info_rec.cmi_prem_bal);
674: hr_utility.trace('i_cmi_prem_mth_ele : '||p_ins_info_rec.cmi_prem_mth_ele);
675: hr_utility.trace('i_cmi_prem_bon_ele : '||p_ins_info_rec.cmi_prem_bon_ele);

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

668: hr_utility.trace('i_lig_prem_mth_ele : '||p_ins_info_rec.lig_prem_mth_ele);
669: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
670: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
671: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
672: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
673: hr_utility.trace('i_cmi_prem_bal : '||p_ins_info_rec.cmi_prem_bal);
674: hr_utility.trace('i_cmi_prem_mth_ele : '||p_ins_info_rec.cmi_prem_mth_ele);
675: hr_utility.trace('i_cmi_prem_bon_ele : '||p_ins_info_rec.cmi_prem_bon_ele);
676: hr_utility.trace('i_linc_prem : '||p_ins_info_rec.linc_prem);

Line 673: hr_utility.trace('i_cmi_prem_bal : '||p_ins_info_rec.cmi_prem_bal);

669: hr_utility.trace('i_lig_prem_bon_ele : '||p_ins_info_rec.lig_prem_bon_ele);
670: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
671: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
672: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
673: hr_utility.trace('i_cmi_prem_bal : '||p_ins_info_rec.cmi_prem_bal);
674: hr_utility.trace('i_cmi_prem_mth_ele : '||p_ins_info_rec.cmi_prem_mth_ele);
675: hr_utility.trace('i_cmi_prem_bon_ele : '||p_ins_info_rec.cmi_prem_bon_ele);
676: hr_utility.trace('i_linc_prem : '||p_ins_info_rec.linc_prem);
677: end if;

Line 674: hr_utility.trace('i_cmi_prem_mth_ele : '||p_ins_info_rec.cmi_prem_mth_ele);

670: hr_utility.trace('i_lip_prem_bal : '||p_ins_info_rec.lip_prem_bal);
671: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
672: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
673: hr_utility.trace('i_cmi_prem_bal : '||p_ins_info_rec.cmi_prem_bal);
674: hr_utility.trace('i_cmi_prem_mth_ele : '||p_ins_info_rec.cmi_prem_mth_ele);
675: hr_utility.trace('i_cmi_prem_bon_ele : '||p_ins_info_rec.cmi_prem_bon_ele);
676: hr_utility.trace('i_linc_prem : '||p_ins_info_rec.linc_prem);
677: end if;
678: --

Line 675: hr_utility.trace('i_cmi_prem_bon_ele : '||p_ins_info_rec.cmi_prem_bon_ele);

671: hr_utility.trace('i_lip_prem_mth_ele : '||p_ins_info_rec.lip_prem_mth_ele);
672: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
673: hr_utility.trace('i_cmi_prem_bal : '||p_ins_info_rec.cmi_prem_bal);
674: hr_utility.trace('i_cmi_prem_mth_ele : '||p_ins_info_rec.cmi_prem_mth_ele);
675: hr_utility.trace('i_cmi_prem_bon_ele : '||p_ins_info_rec.cmi_prem_bon_ele);
676: hr_utility.trace('i_linc_prem : '||p_ins_info_rec.linc_prem);
677: end if;
678: --
679: end if;

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

672: hr_utility.trace('i_lip_prem_bon_ele : '||p_ins_info_rec.lip_prem_bon_ele);
673: hr_utility.trace('i_cmi_prem_bal : '||p_ins_info_rec.cmi_prem_bal);
674: hr_utility.trace('i_cmi_prem_mth_ele : '||p_ins_info_rec.cmi_prem_mth_ele);
675: hr_utility.trace('i_cmi_prem_bon_ele : '||p_ins_info_rec.cmi_prem_bon_ele);
676: hr_utility.trace('i_linc_prem : '||p_ins_info_rec.linc_prem);
677: end if;
678: --
679: end if;
680: --

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

682: p_inputs => l_inputs,
683: p_outputs => l_outputs);
684: --
685: if g_debug then
686: hr_utility.set_location(l_proc,40);
687: end if;
688: --
689: if l_outputs.count > 1 then
690: --

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

702: --
703: end loop;
704: --
705: if g_debug then
706: hr_utility.set_location(l_proc,50);
707: hr_utility.trace('lig_prem : '||p_lig_prem);
708: hr_utility.trace('lip_prem : '||p_lip_prem);
709: hr_utility.trace('cmi_prem : '||p_cmi_prem);
710: hr_utility.trace('message : '||substrb(p_message,1,300));

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

703: end loop;
704: --
705: if g_debug then
706: hr_utility.set_location(l_proc,50);
707: hr_utility.trace('lig_prem : '||p_lig_prem);
708: hr_utility.trace('lip_prem : '||p_lip_prem);
709: hr_utility.trace('cmi_prem : '||p_cmi_prem);
710: hr_utility.trace('message : '||substrb(p_message,1,300));
711: end if;

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

704: --
705: if g_debug then
706: hr_utility.set_location(l_proc,50);
707: hr_utility.trace('lig_prem : '||p_lig_prem);
708: hr_utility.trace('lip_prem : '||p_lip_prem);
709: hr_utility.trace('cmi_prem : '||p_cmi_prem);
710: hr_utility.trace('message : '||substrb(p_message,1,300));
711: end if;
712: --

Line 709: hr_utility.trace('cmi_prem : '||p_cmi_prem);

705: if g_debug then
706: hr_utility.set_location(l_proc,50);
707: hr_utility.trace('lig_prem : '||p_lig_prem);
708: hr_utility.trace('lip_prem : '||p_lip_prem);
709: hr_utility.trace('cmi_prem : '||p_cmi_prem);
710: hr_utility.trace('message : '||substrb(p_message,1,300));
711: end if;
712: --
713: if p_message is not null then

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

706: hr_utility.set_location(l_proc,50);
707: hr_utility.trace('lig_prem : '||p_lig_prem);
708: hr_utility.trace('lip_prem : '||p_lip_prem);
709: hr_utility.trace('cmi_prem : '||p_cmi_prem);
710: hr_utility.trace('message : '||substrb(p_message,1,300));
711: end if;
712: --
713: if p_message is not null then
714: --

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

712: --
713: if p_message is not null then
714: --
715: if g_debug then
716: hr_utility.set_location(l_proc,60);
717: end if;
718: --
719: fnd_file.put_line(fnd_file.output,'Assignment Id : '||fnd_number.number_to_canonical(g_assignment_id));
720: fnd_file.put_line(fnd_file.output,'----------------------------------------------------------------------------------------------------');

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

721: fnd_file.put_line(fnd_file.output,p_message);
722: fnd_file.put_line(fnd_file.output,' ');
723: --
724: if g_debug then
725: hr_utility.set_location(l_proc,70);
726: end if;
727: --
728: end if;
729: --

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

731: --
732: end if;
733: --
734: if g_debug then
735: hr_utility.set_location(l_proc,1000);
736: end if;
737: --
738: end calc_li_annual_prem;
739: --

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

765: --
766: begin
767: --
768: if g_debug then
769: hr_utility.set_location(l_proc,0);
770: end if;
771: --
772: open csr_ff;
773: fetch csr_ff into l_formula_id;

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

773: fetch csr_ff into l_formula_id;
774: close csr_ff;
775: --
776: if g_debug then
777: hr_utility.set_location(l_proc,10);
778: hr_utility.trace('formula_id : '||l_formula_id);
779: end if;
780: --
781: if l_formula_id is not null then

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

774: close csr_ff;
775: --
776: if g_debug then
777: hr_utility.set_location(l_proc,10);
778: hr_utility.trace('formula_id : '||l_formula_id);
779: end if;
780: --
781: if l_formula_id is not null then
782: --

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

786: p_inputs => l_inputs,
787: p_outputs => l_outputs);
788: --
789: if g_debug then
790: hr_utility.set_location(l_proc,20);
791: end if;
792: --
793: if l_inputs.count > 1 then
794: --

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

837: --
838: end loop;
839: --
840: if g_debug then
841: hr_utility.set_location(l_proc,30);
842: hr_utility.trace('business_group_id : '||g_business_group_id);
843: hr_utility.trace('payroll_id : '||g_payroll_id);
844: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
845: hr_utility.trace('assignment_id : '||g_assignment_id);

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

838: end loop;
839: --
840: if g_debug then
841: hr_utility.set_location(l_proc,30);
842: hr_utility.trace('business_group_id : '||g_business_group_id);
843: hr_utility.trace('payroll_id : '||g_payroll_id);
844: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
845: hr_utility.trace('assignment_id : '||g_assignment_id);
846: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);

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

839: --
840: if g_debug then
841: hr_utility.set_location(l_proc,30);
842: hr_utility.trace('business_group_id : '||g_business_group_id);
843: hr_utility.trace('payroll_id : '||g_payroll_id);
844: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
845: hr_utility.trace('assignment_id : '||g_assignment_id);
846: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
847: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));

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

840: if g_debug then
841: hr_utility.set_location(l_proc,30);
842: hr_utility.trace('business_group_id : '||g_business_group_id);
843: hr_utility.trace('payroll_id : '||g_payroll_id);
844: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
845: hr_utility.trace('assignment_id : '||g_assignment_id);
846: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
847: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
848: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);

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

841: hr_utility.set_location(l_proc,30);
842: hr_utility.trace('business_group_id : '||g_business_group_id);
843: hr_utility.trace('payroll_id : '||g_payroll_id);
844: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
845: hr_utility.trace('assignment_id : '||g_assignment_id);
846: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
847: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
848: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
849: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);

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

842: hr_utility.trace('business_group_id : '||g_business_group_id);
843: hr_utility.trace('payroll_id : '||g_payroll_id);
844: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
845: hr_utility.trace('assignment_id : '||g_assignment_id);
846: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
847: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
848: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
849: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
850: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);

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

843: hr_utility.trace('payroll_id : '||g_payroll_id);
844: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
845: hr_utility.trace('assignment_id : '||g_assignment_id);
846: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
847: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
848: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
849: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
850: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
851: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);

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

844: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
845: hr_utility.trace('assignment_id : '||g_assignment_id);
846: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
847: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
848: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
849: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
850: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
851: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
852: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);

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

845: hr_utility.trace('assignment_id : '||g_assignment_id);
846: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
847: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
848: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
849: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
850: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
851: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
852: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
853: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);

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

846: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
847: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
848: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
849: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
850: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
851: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
852: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
853: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
854: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);

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

847: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
848: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
849: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
850: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
851: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
852: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
853: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
854: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
855: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);

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

848: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
849: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
850: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
851: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
852: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
853: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
854: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
855: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
856: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);

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

849: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
850: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
851: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
852: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
853: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
854: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
855: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
856: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);
857: hr_utility.trace('i_ai_prem : '||p_ins_info_rec.annual_prem);

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

850: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
851: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
852: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
853: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
854: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
855: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
856: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);
857: hr_utility.trace('i_ai_prem : '||p_ins_info_rec.annual_prem);
858: end if;

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

851: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);
852: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
853: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
854: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
855: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
856: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);
857: hr_utility.trace('i_ai_prem : '||p_ins_info_rec.annual_prem);
858: end if;
859: --

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

852: hr_utility.trace('i_eqi_prem_mth_ele : '||p_ins_info_rec.eqi_prem_mth_ele);
853: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
854: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
855: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
856: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);
857: hr_utility.trace('i_ai_prem : '||p_ins_info_rec.annual_prem);
858: end if;
859: --
860: end if;

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

853: hr_utility.trace('i_eqi_prem_bon_ele : '||p_ins_info_rec.eqi_prem_bon_ele);
854: hr_utility.trace('i_ai_prem_bal : '||p_ins_info_rec.ai_prem_bal);
855: hr_utility.trace('i_ai_prem_mth_ele : '||p_ins_info_rec.ai_prem_mth_ele);
856: hr_utility.trace('i_ai_prem_bon_ele : '||p_ins_info_rec.ai_prem_bon_ele);
857: hr_utility.trace('i_ai_prem : '||p_ins_info_rec.annual_prem);
858: end if;
859: --
860: end if;
861: --

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

863: p_inputs => l_inputs,
864: p_outputs => l_outputs);
865: --
866: if g_debug then
867: hr_utility.set_location(l_proc,40);
868: end if;
869: --
870: if l_outputs.count >= 1 then
871: --

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

881: --
882: end loop;
883: --
884: if g_debug then
885: hr_utility.set_location(l_proc,50);
886: hr_utility.trace('eqi_prem : '||p_eqi_prem);
887: hr_utility.trace('ai_prem : '||p_ai_prem);
888: hr_utility.trace('message : '||substrb(p_message,1,300));
889: end if;

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

882: end loop;
883: --
884: if g_debug then
885: hr_utility.set_location(l_proc,50);
886: hr_utility.trace('eqi_prem : '||p_eqi_prem);
887: hr_utility.trace('ai_prem : '||p_ai_prem);
888: hr_utility.trace('message : '||substrb(p_message,1,300));
889: end if;
890: --

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

883: --
884: if g_debug then
885: hr_utility.set_location(l_proc,50);
886: hr_utility.trace('eqi_prem : '||p_eqi_prem);
887: hr_utility.trace('ai_prem : '||p_ai_prem);
888: hr_utility.trace('message : '||substrb(p_message,1,300));
889: end if;
890: --
891: if p_message is not null then

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

884: if g_debug then
885: hr_utility.set_location(l_proc,50);
886: hr_utility.trace('eqi_prem : '||p_eqi_prem);
887: hr_utility.trace('ai_prem : '||p_ai_prem);
888: hr_utility.trace('message : '||substrb(p_message,1,300));
889: end if;
890: --
891: if p_message is not null then
892: --

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

890: --
891: if p_message is not null then
892: --
893: if g_debug then
894: hr_utility.set_location(l_proc,60);
895: end if;
896: --
897: fnd_file.put_line(fnd_file.output,'Assignment Id : '||fnd_number.number_to_canonical(g_assignment_id));
898: fnd_file.put_line(fnd_file.output,'----------------------------------------------------------------------------------------------------');

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

899: fnd_file.put_line(fnd_file.output,p_message);
900: fnd_file.put_line(fnd_file.output,' ');
901: --
902: if g_debug then
903: hr_utility.set_location(l_proc,70);
904: end if;
905: --
906: end if;
907: --

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

909: --
910: end if;
911: --
912: if g_debug then
913: hr_utility.set_location(l_proc,1000);
914: end if;
915: --
916: end calc_ai_annual_prem;
917: --

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

1007: --
1008: begin
1009: --
1010: if g_debug then
1011: hr_utility.set_location(l_proc,0);
1012: end if;
1013: --
1014: p_entry_rec.ins_entry_cnt := 0;
1015: p_entry_rec.ins_datetrack_update_mode := null;

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

1122: end loop;
1123: close csr_entry;
1124: --
1125: if g_debug then
1126: hr_utility.set_location(l_proc,1000);
1127: end if;
1128: --
1129: end fetch_entry;
1130: --

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

1493: --
1494: begin
1495: --
1496: if g_debug then
1497: hr_utility.set_location(l_proc,0);
1498: end if;
1499: --
1500: if g_archive_default_flag = 'Y' then
1501: --

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

1499: --
1500: if g_archive_default_flag = 'Y' then
1501: --
1502: if g_debug then
1503: hr_utility.set_location(l_proc,10);
1504: end if;
1505: --
1506: open csr_emp;
1507: fetch csr_emp into l_csr_emp;

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

1507: fetch csr_emp into l_csr_emp;
1508: close csr_emp;
1509: --
1510: if g_debug then
1511: hr_utility.set_location(l_proc,20);
1512: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1513: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1514: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1515: hr_utility.trace('last_name : '||l_csr_emp.last_name);

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

1508: close csr_emp;
1509: --
1510: if g_debug then
1511: hr_utility.set_location(l_proc,20);
1512: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1513: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1514: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1515: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1516: hr_utility.trace('first_name : '||l_csr_emp.first_name);

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

1509: --
1510: if g_debug then
1511: hr_utility.set_location(l_proc,20);
1512: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1513: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1514: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1515: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1516: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1517: hr_utility.trace('full_name : '||l_csr_emp.full_name);

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

1510: if g_debug then
1511: hr_utility.set_location(l_proc,20);
1512: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1513: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1514: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1515: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1516: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1517: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1518: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);

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

1511: hr_utility.set_location(l_proc,20);
1512: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1513: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1514: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1515: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1516: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1517: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1518: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);
1519: hr_utility.trace('address : '||l_csr_emp.address);

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

1512: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1513: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1514: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1515: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1516: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1517: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1518: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);
1519: hr_utility.trace('address : '||l_csr_emp.address);
1520: end if;

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

1513: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1514: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1515: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1516: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1517: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1518: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);
1519: hr_utility.trace('address : '||l_csr_emp.address);
1520: end if;
1521: --

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

1514: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1515: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1516: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1517: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1518: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);
1519: hr_utility.trace('address : '||l_csr_emp.address);
1520: end if;
1521: --
1522: if g_debug then

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

1515: hr_utility.trace('last_name : '||l_csr_emp.last_name);
1516: hr_utility.trace('first_name : '||l_csr_emp.first_name);
1517: hr_utility.trace('full_name : '||l_csr_emp.full_name);
1518: hr_utility.trace('postal_code : '||l_csr_emp.postal_code);
1519: hr_utility.trace('address : '||l_csr_emp.address);
1520: end if;
1521: --
1522: if g_debug then
1523: hr_utility.trace('start create_emp');

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

1519: hr_utility.trace('address : '||l_csr_emp.address);
1520: end if;
1521: --
1522: if g_debug then
1523: hr_utility.trace('start create_emp');
1524: end if;
1525: --
1526: pay_jp_isdf_dml_pkg.create_emp(
1527: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

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

1539: p_address => l_csr_emp.address,
1540: p_object_version_number => l_object_version_number);
1541: --
1542: if g_debug then
1543: hr_utility.trace('end create_emp');
1544: hr_utility.set_location(l_proc,30);
1545: hr_utility.trace('start create_entry');
1546: end if;
1547: --

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

1540: p_object_version_number => l_object_version_number);
1541: --
1542: if g_debug then
1543: hr_utility.trace('end create_emp');
1544: hr_utility.set_location(l_proc,30);
1545: hr_utility.trace('start create_entry');
1546: end if;
1547: --
1548: -- jp_isdf_entry is fetched in the transfer process since transfer date can be specified as different from archive date,

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

1541: --
1542: if g_debug then
1543: hr_utility.trace('end create_emp');
1544: hr_utility.set_location(l_proc,30);
1545: hr_utility.trace('start create_entry');
1546: end if;
1547: --
1548: -- jp_isdf_entry is fetched in the transfer process since transfer date can be specified as different from archive date,
1549: -- archive data in this archive time will be meaningless in the transfer time.

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

1597: --
1598: end if;
1599: --
1600: if g_debug then
1601: hr_utility.trace('end create_entry');
1602: hr_utility.set_location(l_proc,40);
1603: end if;
1604: --
1605: if g_copy_archive_pact_id is null then

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

1598: end if;
1599: --
1600: if g_debug then
1601: hr_utility.trace('end create_entry');
1602: hr_utility.set_location(l_proc,40);
1603: end if;
1604: --
1605: if g_copy_archive_pact_id is null then
1606: --

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

1604: --
1605: if g_copy_archive_pact_id is null then
1606: --
1607: if g_debug then
1608: hr_utility.trace('start create_life_gen');
1609: hr_utility.set_location(l_proc,50);
1610: end if;
1611: --
1612: open csr_gen;

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

1605: if g_copy_archive_pact_id is null then
1606: --
1607: if g_debug then
1608: hr_utility.trace('start create_life_gen');
1609: hr_utility.set_location(l_proc,50);
1610: end if;
1611: --
1612: open csr_gen;
1613: loop

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

1615: fetch csr_gen into l_li_info_rec;
1616: exit when csr_gen%notfound;
1617: --
1618: if g_debug then
1619: hr_utility.set_location(l_proc,60);
1620: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1621: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1622: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1623: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);

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

1616: exit when csr_gen%notfound;
1617: --
1618: if g_debug then
1619: hr_utility.set_location(l_proc,60);
1620: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1621: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1622: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1623: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1624: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);

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

1617: --
1618: if g_debug then
1619: hr_utility.set_location(l_proc,60);
1620: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1621: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1622: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1623: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1624: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1625: hr_utility.trace('gen_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);

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

1618: if g_debug then
1619: hr_utility.set_location(l_proc,60);
1620: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1621: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1622: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1623: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1624: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1625: hr_utility.trace('gen_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1626: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);

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

1619: hr_utility.set_location(l_proc,60);
1620: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1621: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1622: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1623: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1624: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1625: hr_utility.trace('gen_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1626: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1627: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);

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

1620: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1621: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1622: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1623: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1624: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1625: hr_utility.trace('gen_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1626: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1627: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1628: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);

Line 1625: hr_utility.trace('gen_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);

1621: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1622: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1623: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1624: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1625: hr_utility.trace('gen_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1626: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1627: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1628: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1629: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);

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

1622: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1623: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1624: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1625: hr_utility.trace('gen_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1626: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1627: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1628: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1629: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);

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

1623: hr_utility.trace('gen_ins_class : '||l_li_info_rec.ins_class);
1624: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1625: hr_utility.trace('gen_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1626: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1627: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1628: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1629: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));

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

1624: hr_utility.trace('gen_ins_company_code : '||l_li_info_rec.ins_comp_code);
1625: hr_utility.trace('gen_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1626: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1627: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1628: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1629: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));

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

1625: hr_utility.trace('gen_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1626: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1627: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1628: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1629: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);

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

1626: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1627: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1628: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1629: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));

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

1627: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1628: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1629: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

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

1628: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1629: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1636: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

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

1629: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1636: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1637: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);

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

1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1636: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1637: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1638: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

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

1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1636: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1637: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1638: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1639: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));

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

1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1636: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1637: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1638: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1639: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1640: end if;

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

1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1636: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1637: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1638: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1639: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1640: end if;
1641: --

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

1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1636: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1637: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1638: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1639: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1640: end if;
1641: --
1642: l_lig_prem := null;

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

1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1636: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1637: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1638: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1639: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1640: end if;
1641: --
1642: l_lig_prem := null;
1643: --

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

1652: --
1653: end if;
1654: --
1655: if g_debug then
1656: hr_utility.set_location(l_proc,70);
1657: hr_utility.trace('annual_prem : '||l_lig_prem);
1658: end if;
1659: --
1660: pay_jp_isdf_dml_pkg.create_life_gen(

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

1653: end if;
1654: --
1655: if g_debug then
1656: hr_utility.set_location(l_proc,70);
1657: hr_utility.trace('annual_prem : '||l_lig_prem);
1658: end if;
1659: --
1660: pay_jp_isdf_dml_pkg.create_life_gen(
1661: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

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

1679: p_object_version_number => l_object_version_number,
1680: p_gen_ins_old_new => l_li_info_rec.ins_class_old_new);
1681: --
1682: if g_debug then
1683: hr_utility.set_location(l_proc,80);
1684: end if;
1685: --
1686: end loop;
1687: close csr_gen;

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

1687: close csr_gen;
1688: --
1689:
1690: if g_debug then
1691: hr_utility.trace('end create_life_gen');
1692: hr_utility.set_location(l_proc,85);
1693: hr_utility.trace('start create_care_med');
1694: end if;
1695:

Line 1692: hr_utility.set_location(l_proc,85);

1688: --
1689:
1690: if g_debug then
1691: hr_utility.trace('end create_life_gen');
1692: hr_utility.set_location(l_proc,85);
1693: hr_utility.trace('start create_care_med');
1694: end if;
1695:
1696: open csr_cmi;

Line 1693: hr_utility.trace('start create_care_med');

1689:
1690: if g_debug then
1691: hr_utility.trace('end create_life_gen');
1692: hr_utility.set_location(l_proc,85);
1693: hr_utility.trace('start create_care_med');
1694: end if;
1695:
1696: open csr_cmi;
1697: loop

Line 1703: hr_utility.set_location(l_proc,86);

1699: fetch csr_cmi into l_li_info_rec;
1700: exit when csr_cmi%notfound;
1701: --
1702: if g_debug then
1703: hr_utility.set_location(l_proc,86);
1704: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1705: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1706: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1707: hr_utility.trace('care_ins_class : '||l_li_info_rec.ins_class);

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

1700: exit when csr_cmi%notfound;
1701: --
1702: if g_debug then
1703: hr_utility.set_location(l_proc,86);
1704: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1705: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1706: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1707: hr_utility.trace('care_ins_class : '||l_li_info_rec.ins_class);
1708: hr_utility.trace('care_ins_company_code : '||l_li_info_rec.ins_comp_code);

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

1701: --
1702: if g_debug then
1703: hr_utility.set_location(l_proc,86);
1704: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1705: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1706: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1707: hr_utility.trace('care_ins_class : '||l_li_info_rec.ins_class);
1708: hr_utility.trace('care_ins_company_code : '||l_li_info_rec.ins_comp_code);
1709: hr_utility.trace('care_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);

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

1702: if g_debug then
1703: hr_utility.set_location(l_proc,86);
1704: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1705: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1706: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1707: hr_utility.trace('care_ins_class : '||l_li_info_rec.ins_class);
1708: hr_utility.trace('care_ins_company_code : '||l_li_info_rec.ins_comp_code);
1709: hr_utility.trace('care_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1710: hr_utility.trace('care_ins_company_name : '||l_li_info_rec.ins_comp_name);

Line 1707: hr_utility.trace('care_ins_class : '||l_li_info_rec.ins_class);

1703: hr_utility.set_location(l_proc,86);
1704: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1705: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1706: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1707: hr_utility.trace('care_ins_class : '||l_li_info_rec.ins_class);
1708: hr_utility.trace('care_ins_company_code : '||l_li_info_rec.ins_comp_code);
1709: hr_utility.trace('care_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1710: hr_utility.trace('care_ins_company_name : '||l_li_info_rec.ins_comp_name);
1711: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);

Line 1708: hr_utility.trace('care_ins_company_code : '||l_li_info_rec.ins_comp_code);

1704: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1705: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1706: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1707: hr_utility.trace('care_ins_class : '||l_li_info_rec.ins_class);
1708: hr_utility.trace('care_ins_company_code : '||l_li_info_rec.ins_comp_code);
1709: hr_utility.trace('care_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1710: hr_utility.trace('care_ins_company_name : '||l_li_info_rec.ins_comp_name);
1711: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);

Line 1709: hr_utility.trace('care_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);

1705: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1706: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1707: hr_utility.trace('care_ins_class : '||l_li_info_rec.ins_class);
1708: hr_utility.trace('care_ins_company_code : '||l_li_info_rec.ins_comp_code);
1709: hr_utility.trace('care_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1710: hr_utility.trace('care_ins_company_name : '||l_li_info_rec.ins_comp_name);
1711: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);
1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);

Line 1710: hr_utility.trace('care_ins_company_name : '||l_li_info_rec.ins_comp_name);

1706: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1707: hr_utility.trace('care_ins_class : '||l_li_info_rec.ins_class);
1708: hr_utility.trace('care_ins_company_code : '||l_li_info_rec.ins_comp_code);
1709: hr_utility.trace('care_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1710: hr_utility.trace('care_ins_company_name : '||l_li_info_rec.ins_comp_name);
1711: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);
1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);
1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);

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

1707: hr_utility.trace('care_ins_class : '||l_li_info_rec.ins_class);
1708: hr_utility.trace('care_ins_company_code : '||l_li_info_rec.ins_comp_code);
1709: hr_utility.trace('care_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1710: hr_utility.trace('care_ins_company_name : '||l_li_info_rec.ins_comp_name);
1711: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);
1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);
1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);
1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));

Line 1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);

1708: hr_utility.trace('care_ins_company_code : '||l_li_info_rec.ins_comp_code);
1709: hr_utility.trace('care_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1710: hr_utility.trace('care_ins_company_name : '||l_li_info_rec.ins_comp_name);
1711: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);
1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);
1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);
1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));

Line 1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);

1709: hr_utility.trace('care_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1710: hr_utility.trace('care_ins_company_name : '||l_li_info_rec.ins_comp_name);
1711: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);
1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);
1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);
1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);

Line 1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);

1710: hr_utility.trace('care_ins_company_name : '||l_li_info_rec.ins_comp_name);
1711: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);
1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);
1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);
1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));

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

1711: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);
1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);
1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);
1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

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

1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);
1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);
1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);
1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1720: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

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

1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);
1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);
1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1720: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1721: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);

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

1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);
1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1720: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1721: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1722: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

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

1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1720: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1721: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1722: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1723: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));

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

1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1720: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1721: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1722: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1723: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1724: end if;

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

1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1720: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1721: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1722: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1723: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1724: end if;
1725: --

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

1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1720: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1721: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1722: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1723: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1724: end if;
1725: --
1726: l_cmi_prem := null;

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

1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1720: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1721: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1722: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1723: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1724: end if;
1725: --
1726: l_cmi_prem := null;
1727: --

Line 1740: hr_utility.set_location(l_proc,87);

1736: --
1737: end if;
1738: --
1739: if g_debug then
1740: hr_utility.set_location(l_proc,87);
1741: hr_utility.trace('annual_prem : '||l_cmi_prem);
1742: end if;
1743: --
1744: pay_jp_isdf_dml_pkg.create_care_med(

Line 1741: hr_utility.trace('annual_prem : '||l_cmi_prem);

1737: end if;
1738: --
1739: if g_debug then
1740: hr_utility.set_location(l_proc,87);
1741: hr_utility.trace('annual_prem : '||l_cmi_prem);
1742: end if;
1743: --
1744: pay_jp_isdf_dml_pkg.create_care_med(
1745: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

Line 1767: hr_utility.set_location(l_proc,88);

1763: p_object_version_number => l_object_version_number,
1764: p_care_ins_old_new => l_li_info_rec.ins_class_old_new);
1765: --
1766: if g_debug then
1767: hr_utility.set_location(l_proc,88);
1768: end if;
1769: --
1770: end loop;
1771: close csr_cmi;

Line 1775: hr_utility.trace('end create_care_med');

1771: close csr_cmi;
1772: --
1773:
1774: if g_debug then
1775: hr_utility.trace('end create_care_med');
1776: hr_utility.set_location(l_proc,90);
1777: hr_utility.trace('start create_life_pens');
1778: end if;
1779: --

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

1772: --
1773:
1774: if g_debug then
1775: hr_utility.trace('end create_care_med');
1776: hr_utility.set_location(l_proc,90);
1777: hr_utility.trace('start create_life_pens');
1778: end if;
1779: --
1780: open csr_pens;

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

1773:
1774: if g_debug then
1775: hr_utility.trace('end create_care_med');
1776: hr_utility.set_location(l_proc,90);
1777: hr_utility.trace('start create_life_pens');
1778: end if;
1779: --
1780: open csr_pens;
1781: loop

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

1783: fetch csr_pens into l_li_info_rec;
1784: exit when csr_pens%notfound;
1785: --
1786: if g_debug then
1787: hr_utility.set_location(l_proc,100);
1788: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1789: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1790: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1791: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);

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

1784: exit when csr_pens%notfound;
1785: --
1786: if g_debug then
1787: hr_utility.set_location(l_proc,100);
1788: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1789: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1790: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1791: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1792: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);

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

1785: --
1786: if g_debug then
1787: hr_utility.set_location(l_proc,100);
1788: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1789: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1790: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1791: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1792: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1793: hr_utility.trace('pens_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);

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

1786: if g_debug then
1787: hr_utility.set_location(l_proc,100);
1788: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1789: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1790: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1791: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1792: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1793: hr_utility.trace('pens_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1794: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);

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

1787: hr_utility.set_location(l_proc,100);
1788: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1789: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1790: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1791: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1792: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1793: hr_utility.trace('pens_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1794: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1795: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);

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

1788: hr_utility.trace('assignment_extra_info_id : '||l_li_info_rec.assignment_extra_info_id);
1789: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1790: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1791: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1792: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1793: hr_utility.trace('pens_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1794: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1795: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1796: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);

Line 1793: hr_utility.trace('pens_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);

1789: hr_utility.trace('aei_object_version_number : '||l_li_info_rec.aei_object_version_number);
1790: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1791: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1792: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1793: hr_utility.trace('pens_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1794: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1795: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1796: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1797: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);

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

1790: hr_utility.trace('info_type : '||l_li_info_rec.info_type);
1791: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1792: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1793: hr_utility.trace('pens_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1794: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1795: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1796: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1797: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);

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

1791: hr_utility.trace('pens_ins_class : '||l_li_info_rec.ins_class);
1792: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1793: hr_utility.trace('pens_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1794: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1795: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1796: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1797: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));

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

1792: hr_utility.trace('pens_ins_company_code : '||l_li_info_rec.ins_comp_code);
1793: hr_utility.trace('pens_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1794: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1795: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1796: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1797: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));

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

1793: hr_utility.trace('pens_ins_class_old_or_new : '||l_li_info_rec.ins_class_old_new);
1794: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1795: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1796: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1797: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);

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

1794: hr_utility.trace('ins_company_name : '||l_li_info_rec.ins_comp_name);
1795: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1796: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1797: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));

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

1795: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1796: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1797: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

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

1796: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1797: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1804: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

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

1797: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1804: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1805: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);

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

1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1804: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1805: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1806: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

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

1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1804: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1805: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1806: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1807: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));

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

1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1804: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1805: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1806: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1807: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1808: end if;

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

1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1804: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1805: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1806: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1807: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1808: end if;
1809: --

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

1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1804: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1805: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1806: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1807: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1808: end if;
1809: --
1810: l_lip_prem := null;

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

1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1804: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1805: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1806: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1807: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1808: end if;
1809: --
1810: l_lip_prem := null;
1811: --

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

1820: --
1821: end if;
1822: --
1823: if g_debug then
1824: hr_utility.set_location(l_proc,110);
1825: hr_utility.trace('annual_prem : '||l_lip_prem);
1826: end if;
1827: --
1828: pay_jp_isdf_dml_pkg.create_life_pens(

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

1821: end if;
1822: --
1823: if g_debug then
1824: hr_utility.set_location(l_proc,110);
1825: hr_utility.trace('annual_prem : '||l_lip_prem);
1826: end if;
1827: --
1828: pay_jp_isdf_dml_pkg.create_life_pens(
1829: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

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

1848: p_object_version_number => l_object_version_number,
1849: p_pens_ins_old_new => l_li_info_rec.ins_class_old_new);
1850: --
1851: if g_debug then
1852: hr_utility.set_location(l_proc,120);
1853: end if;
1854: --
1855: end loop;
1856: close csr_pens;

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

1855: end loop;
1856: close csr_pens;
1857: --
1858: if g_debug then
1859: hr_utility.trace('end create_life_pens');
1860: hr_utility.set_location(l_proc,130);
1861: hr_utility.trace('start create_nonlife');
1862: end if;
1863: --

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

1856: close csr_pens;
1857: --
1858: if g_debug then
1859: hr_utility.trace('end create_life_pens');
1860: hr_utility.set_location(l_proc,130);
1861: hr_utility.trace('start create_nonlife');
1862: end if;
1863: --
1864: open csr_nonlife;

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

1857: --
1858: if g_debug then
1859: hr_utility.trace('end create_life_pens');
1860: hr_utility.set_location(l_proc,130);
1861: hr_utility.trace('start create_nonlife');
1862: end if;
1863: --
1864: open csr_nonlife;
1865: loop

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

1867: fetch csr_nonlife into l_ai_info_rec;
1868: exit when csr_nonlife%notfound;
1869: --
1870: if g_debug then
1871: hr_utility.set_location(l_proc,140);
1872: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1873: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1874: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1875: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);

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

1868: exit when csr_nonlife%notfound;
1869: --
1870: if g_debug then
1871: hr_utility.set_location(l_proc,140);
1872: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1873: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1874: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1875: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1876: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);

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

1869: --
1870: if g_debug then
1871: hr_utility.set_location(l_proc,140);
1872: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1873: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1874: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1875: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1876: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1877: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);

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

1870: if g_debug then
1871: hr_utility.set_location(l_proc,140);
1872: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1873: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1874: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1875: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1876: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1877: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1878: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);

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

1871: hr_utility.set_location(l_proc,140);
1872: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1873: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1874: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1875: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1876: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1877: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1878: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1879: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);

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

1872: hr_utility.trace('assignment_extra_info_id : '||l_ai_info_rec.assignment_extra_info_id);
1873: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1874: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1875: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1876: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1877: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1878: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1879: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1880: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);

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

1873: hr_utility.trace('aei_object_version_number : '||l_ai_info_rec.aei_object_version_number);
1874: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1875: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1876: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1877: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1878: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1879: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1880: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1881: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);

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

1874: hr_utility.trace('info_type : '||l_ai_info_rec.info_type);
1875: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1876: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1877: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1878: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1879: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1880: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1881: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1882: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);

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

1875: hr_utility.trace('nonlife_ins_class : '||l_ai_info_rec.ins_class);
1876: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1877: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1878: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1879: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1880: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1881: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1882: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1883: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);

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

1876: hr_utility.trace('nonlife_term_type : '||l_ai_info_rec.ins_term_type);
1877: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1878: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1879: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1880: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1881: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1882: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1883: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1884: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);

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

1877: hr_utility.trace('nonlife_ins_company_code : '||l_ai_info_rec.ins_comp_code);
1878: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1879: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1880: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1881: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1882: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1883: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1884: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1885: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);

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

1878: hr_utility.trace('ins_company_name : '||l_ai_info_rec.ins_comp_name);
1879: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1880: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1881: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1882: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1883: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1884: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1885: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));

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

1879: hr_utility.trace('calc_prem_ff : '||l_ai_info_rec.calc_prem_ff);
1880: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1881: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1882: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1883: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1884: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1885: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));

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

1880: hr_utility.trace('eqi_prem_bal : '||l_ai_info_rec.eqi_prem_bal);
1881: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1882: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1883: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1884: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1885: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1888: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);

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

1881: hr_utility.trace('eqi_prem_mth_ele : '||l_ai_info_rec.eqi_prem_mth_ele);
1882: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1883: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1884: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1885: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1888: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1889: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);

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

1882: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1883: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1884: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1885: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1888: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1889: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);

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

1883: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1884: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1885: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1888: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1889: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1891: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);

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

1884: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1885: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1888: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1889: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1891: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1892: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);

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

1885: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1888: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1889: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1891: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1892: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1893: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);

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

1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1888: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1889: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1891: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1892: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1893: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1894: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));

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

1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1888: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1889: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1891: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1892: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1893: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1894: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));
1895: end if;

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

1888: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1889: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1891: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1892: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1893: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1894: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));
1895: end if;
1896: --

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

1889: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1891: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1892: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1893: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1894: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));
1895: end if;
1896: --
1897: l_ai_prem := null;

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

1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1891: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1892: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1893: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1894: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));
1895: end if;
1896: --
1897: l_ai_prem := null;
1898: l_eqi_prem := null;

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

1914: --
1915: end if;
1916: --
1917: if g_debug then
1918: hr_utility.set_location(l_proc,150);
1919: hr_utility.trace('ai annual_prem : '||l_ai_prem);
1920: hr_utility.trace('eqi annual_prem : '||l_eqi_prem);
1921: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1922: end if;

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

1915: end if;
1916: --
1917: if g_debug then
1918: hr_utility.set_location(l_proc,150);
1919: hr_utility.trace('ai annual_prem : '||l_ai_prem);
1920: hr_utility.trace('eqi annual_prem : '||l_eqi_prem);
1921: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1922: end if;
1923: --

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

1916: --
1917: if g_debug then
1918: hr_utility.set_location(l_proc,150);
1919: hr_utility.trace('ai annual_prem : '||l_ai_prem);
1920: hr_utility.trace('eqi annual_prem : '||l_eqi_prem);
1921: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1922: end if;
1923: --
1924: pay_jp_isdf_dml_pkg.create_nonlife(

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

1917: if g_debug then
1918: hr_utility.set_location(l_proc,150);
1919: hr_utility.trace('ai annual_prem : '||l_ai_prem);
1920: hr_utility.trace('eqi annual_prem : '||l_eqi_prem);
1921: hr_utility.trace('nli annual_prem : '||l_nli_prem);
1922: end if;
1923: --
1924: pay_jp_isdf_dml_pkg.create_nonlife(
1925: p_action_information_id => pay_jp_isdf_dml_pkg.next_action_information_id,

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

1944: p_annual_prem => l_ai_prem,
1945: p_object_version_number => l_object_version_number);
1946: --
1947: if g_debug then
1948: hr_utility.set_location(l_proc,160);
1949: end if;
1950: --
1951: end loop;
1952: close csr_nonlife;

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

1951: end loop;
1952: close csr_nonlife;
1953: --
1954: if g_debug then
1955: hr_utility.trace('end create_nonlife');
1956: hr_utility.set_location(l_proc,170);
1957: hr_utility.trace('start create_spouse');
1958: end if;
1959: --

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

1952: close csr_nonlife;
1953: --
1954: if g_debug then
1955: hr_utility.trace('end create_nonlife');
1956: hr_utility.set_location(l_proc,170);
1957: hr_utility.trace('start create_spouse');
1958: end if;
1959: --
1960: l_spouse_rec.spouse_type := null;

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

1953: --
1954: if g_debug then
1955: hr_utility.trace('end create_nonlife');
1956: hr_utility.set_location(l_proc,170);
1957: hr_utility.trace('start create_spouse');
1958: end if;
1959: --
1960: l_spouse_rec.spouse_type := null;
1961: l_spouse_rec.widow_type := null;

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

2008: --
2009: end if;
2010: --
2011: if g_debug then
2012: hr_utility.trace('end create_spouse');
2013: hr_utility.set_location(l_proc,180);
2014: end if;
2015: --
2016: -- copy previous archive information to current archive

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

2009: end if;
2010: --
2011: if g_debug then
2012: hr_utility.trace('end create_spouse');
2013: hr_utility.set_location(l_proc,180);
2014: end if;
2015: --
2016: -- copy previous archive information to current archive
2017: -- this function will be useful in case of re-yea

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

2019: --
2020: else
2021: --
2022: if g_debug then
2023: hr_utility.set_location(l_proc,190);
2024: hr_utility.trace('copy pact id : '||g_copy_archive_pact_id);
2025: end if;
2026: --
2027: open csr_copy_assact;

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

2020: else
2021: --
2022: if g_debug then
2023: hr_utility.set_location(l_proc,190);
2024: hr_utility.trace('copy pact id : '||g_copy_archive_pact_id);
2025: end if;
2026: --
2027: open csr_copy_assact;
2028: fetch csr_copy_assact into l_copy_archive_assact_id;

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

2028: fetch csr_copy_assact into l_copy_archive_assact_id;
2029: close csr_copy_assact;
2030: --
2031: if g_debug then
2032: hr_utility.set_location(l_proc,200);
2033: hr_utility.trace('copy assact id : '||l_copy_archive_assact_id);
2034: end if;
2035: --
2036: if l_copy_archive_assact_id is not null then

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

2029: close csr_copy_assact;
2030: --
2031: if g_debug then
2032: hr_utility.set_location(l_proc,200);
2033: hr_utility.trace('copy assact id : '||l_copy_archive_assact_id);
2034: end if;
2035: --
2036: if l_copy_archive_assact_id is not null then
2037: --

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

2035: --
2036: if l_copy_archive_assact_id is not null then
2037: --
2038: if g_debug then
2039: hr_utility.set_location(l_proc,210);
2040: hr_utility.trace('start copy life_gen');
2041: end if;
2042: --
2043: open csr_copy_life_gen;

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

2036: if l_copy_archive_assact_id is not null then
2037: --
2038: if g_debug then
2039: hr_utility.set_location(l_proc,210);
2040: hr_utility.trace('start copy life_gen');
2041: end if;
2042: --
2043: open csr_copy_life_gen;
2044: loop

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

2071: end loop;
2072: close csr_copy_life_gen;
2073: --
2074: if g_debug then
2075: hr_utility.trace('end copy life_gen');
2076: hr_utility.set_location(l_proc,219);
2077: hr_utility.trace('start copy care_med');
2078: end if;
2079: --

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

2072: close csr_copy_life_gen;
2073: --
2074: if g_debug then
2075: hr_utility.trace('end copy life_gen');
2076: hr_utility.set_location(l_proc,219);
2077: hr_utility.trace('start copy care_med');
2078: end if;
2079: --
2080: open csr_copy_care_med;

Line 2077: hr_utility.trace('start copy care_med');

2073: --
2074: if g_debug then
2075: hr_utility.trace('end copy life_gen');
2076: hr_utility.set_location(l_proc,219);
2077: hr_utility.trace('start copy care_med');
2078: end if;
2079: --
2080: open csr_copy_care_med;
2081: loop

Line 2112: hr_utility.trace('end copy care_med');

2108: end loop;
2109: close csr_copy_care_med;
2110:
2111: if g_debug then
2112: hr_utility.trace('end copy care_med');
2113: hr_utility.set_location(l_proc,220);
2114: hr_utility.trace('start copy life_pens');
2115: end if;
2116: --

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

2109: close csr_copy_care_med;
2110:
2111: if g_debug then
2112: hr_utility.trace('end copy care_med');
2113: hr_utility.set_location(l_proc,220);
2114: hr_utility.trace('start copy life_pens');
2115: end if;
2116: --
2117:

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

2110:
2111: if g_debug then
2112: hr_utility.trace('end copy care_med');
2113: hr_utility.set_location(l_proc,220);
2114: hr_utility.trace('start copy life_pens');
2115: end if;
2116: --
2117:
2118: open csr_copy_life_pens;

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

2147: end loop;
2148: close csr_copy_life_pens;
2149: --
2150: if g_debug then
2151: hr_utility.trace('end copy life_pens');
2152: hr_utility.set_location(l_proc,230);
2153: hr_utility.trace('start copy nonlife');
2154: end if;
2155: --

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

2148: close csr_copy_life_pens;
2149: --
2150: if g_debug then
2151: hr_utility.trace('end copy life_pens');
2152: hr_utility.set_location(l_proc,230);
2153: hr_utility.trace('start copy nonlife');
2154: end if;
2155: --
2156: open csr_copy_nonlife;

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

2149: --
2150: if g_debug then
2151: hr_utility.trace('end copy life_pens');
2152: hr_utility.set_location(l_proc,230);
2153: hr_utility.trace('start copy nonlife');
2154: end if;
2155: --
2156: open csr_copy_nonlife;
2157: loop

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

2185: end loop;
2186: close csr_copy_nonlife;
2187: --
2188: if g_debug then
2189: hr_utility.trace('end copy nonlife');
2190: hr_utility.set_location(l_proc,240);
2191: hr_utility.trace('start copy social');
2192: end if;
2193: --

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

2186: close csr_copy_nonlife;
2187: --
2188: if g_debug then
2189: hr_utility.trace('end copy nonlife');
2190: hr_utility.set_location(l_proc,240);
2191: hr_utility.trace('start copy social');
2192: end if;
2193: --
2194: open csr_copy_social;

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

2187: --
2188: if g_debug then
2189: hr_utility.trace('end copy nonlife');
2190: hr_utility.set_location(l_proc,240);
2191: hr_utility.trace('start copy social');
2192: end if;
2193: --
2194: open csr_copy_social;
2195: loop

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

2216: end loop;
2217: close csr_copy_social;
2218: --
2219: if g_debug then
2220: hr_utility.trace('end copy social');
2221: hr_utility.set_location(l_proc,250);
2222: hr_utility.trace('start copy mutual_aid');
2223: end if;
2224: --

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

2217: close csr_copy_social;
2218: --
2219: if g_debug then
2220: hr_utility.trace('end copy social');
2221: hr_utility.set_location(l_proc,250);
2222: hr_utility.trace('start copy mutual_aid');
2223: end if;
2224: --
2225: open csr_copy_mutual_aid;

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

2218: --
2219: if g_debug then
2220: hr_utility.trace('end copy social');
2221: hr_utility.set_location(l_proc,250);
2222: hr_utility.trace('start copy mutual_aid');
2223: end if;
2224: --
2225: open csr_copy_mutual_aid;
2226: loop

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

2244: end loop;
2245: close csr_copy_mutual_aid;
2246: --
2247: if g_debug then
2248: hr_utility.trace('end copy mutual_aid');
2249: hr_utility.set_location(l_proc,260);
2250: hr_utility.trace('start copy spouse');
2251: end if;
2252: --

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

2245: close csr_copy_mutual_aid;
2246: --
2247: if g_debug then
2248: hr_utility.trace('end copy mutual_aid');
2249: hr_utility.set_location(l_proc,260);
2250: hr_utility.trace('start copy spouse');
2251: end if;
2252: --
2253: open csr_copy_spouse;

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

2246: --
2247: if g_debug then
2248: hr_utility.trace('end copy mutual_aid');
2249: hr_utility.set_location(l_proc,260);
2250: hr_utility.trace('start copy spouse');
2251: end if;
2252: --
2253: open csr_copy_spouse;
2254: loop

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

2278: end loop;
2279: close csr_copy_spouse;
2280: --
2281: if g_debug then
2282: hr_utility.trace('end copy spouse');
2283: hr_utility.set_location(l_proc,270);
2284: hr_utility.trace('start copy spouse_inc');
2285: end if;
2286: --

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

2279: close csr_copy_spouse;
2280: --
2281: if g_debug then
2282: hr_utility.trace('end copy spouse');
2283: hr_utility.set_location(l_proc,270);
2284: hr_utility.trace('start copy spouse_inc');
2285: end if;
2286: --
2287: open csr_copy_spouse_inc;

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

2280: --
2281: if g_debug then
2282: hr_utility.trace('end copy spouse');
2283: hr_utility.set_location(l_proc,270);
2284: hr_utility.trace('start copy spouse_inc');
2285: end if;
2286: --
2287: open csr_copy_spouse_inc;
2288: loop

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

2320: end loop;
2321: close csr_copy_spouse_inc;
2322: --
2323: if g_debug then
2324: hr_utility.trace('end copy spouse_inc');
2325: hr_utility.set_location(l_proc,280);
2326: end if;
2327: --
2328: end if;

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

2321: close csr_copy_spouse_inc;
2322: --
2323: if g_debug then
2324: hr_utility.trace('end copy spouse_inc');
2325: hr_utility.set_location(l_proc,280);
2326: end if;
2327: --
2328: end if;
2329: --

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

2327: --
2328: end if;
2329: --
2330: if g_debug then
2331: hr_utility.set_location(l_proc,290);
2332: end if;
2333: --
2334: end if;
2335: --

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

2333: --
2334: end if;
2335: --
2336: if g_debug then
2337: hr_utility.set_location(l_proc,300);
2338: end if;
2339: --
2340: end if;
2341: --

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

2339: --
2340: end if;
2341: --
2342: if g_debug then
2343: hr_utility.set_location(l_proc,1000);
2344: end if;
2345: --
2346: end archive_assact;
2347: --

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

2357: --
2358: begin
2359: --
2360: if g_debug then
2361: hr_utility.set_location(l_proc,0);
2362: end if;
2363: --
2364: if g_archive_default_flag = 'Y' then
2365: --

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

2363: --
2364: if g_archive_default_flag = 'Y' then
2365: --
2366: if g_debug then
2367: hr_utility.set_location(l_proc,10);
2368: hr_utility.trace('action_information_id : '||p_action_information_id);
2369: hr_utility.trace('object_version_number : '||p_object_version_number);
2370: end if;
2371: --

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

2364: if g_archive_default_flag = 'Y' then
2365: --
2366: if g_debug then
2367: hr_utility.set_location(l_proc,10);
2368: hr_utility.trace('action_information_id : '||p_action_information_id);
2369: hr_utility.trace('object_version_number : '||p_object_version_number);
2370: end if;
2371: --
2372: -- include lock assact (only transaction,ovn will be changed, others same as new condition)

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

2365: --
2366: if g_debug then
2367: hr_utility.set_location(l_proc,10);
2368: hr_utility.trace('action_information_id : '||p_action_information_id);
2369: hr_utility.trace('object_version_number : '||p_object_version_number);
2370: end if;
2371: --
2372: -- include lock assact (only transaction,ovn will be changed, others same as new condition)
2373: pay_jp_isdf_dml_pkg.update_assact(

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

2382: p_transfer_date => null,
2383: p_expiry_date => null);
2384: --
2385: if g_debug then
2386: hr_utility.set_location(l_proc,20);
2387: end if;
2388: --
2389: end if;
2390: --

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

2388: --
2389: end if;
2390: --
2391: if g_debug then
2392: hr_utility.set_location(l_proc,1000);
2393: end if;
2394: --
2395: end post_assact;
2396: --

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

2412: --
2413: begin
2414: --
2415: if g_debug then
2416: hr_utility.set_location(l_proc,0);
2417: end if;
2418: --
2419: select assignment_id
2420: into l_assignment_id

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

2421: from pay_assignment_actions
2422: where assignment_action_id = p_assignment_action_id;
2423: --
2424: if g_debug then
2425: hr_utility.set_location(l_proc,10);
2426: end if;
2427: --
2428: -- set context.
2429: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));

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

2430: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(l_assignment_id));
2431: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
2432: --
2433: if g_debug then
2434: hr_utility.set_location(l_proc,20);
2435: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));
2436: hr_utility.trace('assignment_id : '||l_assignment_id);
2437: hr_utility.trace('tax_type : '||l_tax_type);
2438: end if;

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

2431: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
2432: --
2433: if g_debug then
2434: hr_utility.set_location(l_proc,20);
2435: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));
2436: hr_utility.trace('assignment_id : '||l_assignment_id);
2437: hr_utility.trace('tax_type : '||l_tax_type);
2438: end if;
2439: --

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

2432: --
2433: if g_debug then
2434: hr_utility.set_location(l_proc,20);
2435: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));
2436: hr_utility.trace('assignment_id : '||l_assignment_id);
2437: hr_utility.trace('tax_type : '||l_tax_type);
2438: end if;
2439: --
2440: if l_tax_type not in ('M_KOU','D_KOU') then

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

2433: if g_debug then
2434: hr_utility.set_location(l_proc,20);
2435: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));
2436: hr_utility.trace('assignment_id : '||l_assignment_id);
2437: hr_utility.trace('tax_type : '||l_tax_type);
2438: end if;
2439: --
2440: if l_tax_type not in ('M_KOU','D_KOU') then
2441: --

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

2444: --
2445: else
2446: --
2447: if g_debug then
2448: hr_utility.set_location(l_proc,30);
2449: hr_utility.trace('start create_assact');
2450: end if;
2451: --
2452: l_action_information_id := pay_jp_isdf_dml_pkg.next_action_information_id;

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

2445: else
2446: --
2447: if g_debug then
2448: hr_utility.set_location(l_proc,30);
2449: hr_utility.trace('start create_assact');
2450: end if;
2451: --
2452: l_action_information_id := pay_jp_isdf_dml_pkg.next_action_information_id;
2453: --

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

2469: p_expiry_date => null,
2470: p_object_version_number => l_object_version_number);
2471: --
2472: if g_debug then
2473: hr_utility.trace('end create_assact');
2474: hr_utility.set_location(l_proc,40);
2475: end if;
2476: --
2477: init_assact(

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

2470: p_object_version_number => l_object_version_number);
2471: --
2472: if g_debug then
2473: hr_utility.trace('end create_assact');
2474: hr_utility.set_location(l_proc,40);
2475: end if;
2476: --
2477: init_assact(
2478: p_assignment_action_id => p_assignment_action_id,

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

2478: p_assignment_action_id => p_assignment_action_id,
2479: p_assignment_id => l_assignment_id);
2480: --
2481: if g_debug then
2482: hr_utility.set_location(l_proc,50);
2483: end if;
2484: --
2485: archive_assact(
2486: p_assignment_action_id => p_assignment_action_id,

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

2486: p_assignment_action_id => p_assignment_action_id,
2487: p_assignment_id => l_assignment_id);
2488: --
2489: if g_debug then
2490: hr_utility.set_location(l_proc,60);
2491: hr_utility.trace('assignment_action_id : '||p_assignment_action_id);
2492: hr_utility.trace('action_information_id : '||l_action_information_id);
2493: hr_utility.trace('object_version_number : '||l_object_version_number);
2494: end if;

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

2487: p_assignment_id => l_assignment_id);
2488: --
2489: if g_debug then
2490: hr_utility.set_location(l_proc,60);
2491: hr_utility.trace('assignment_action_id : '||p_assignment_action_id);
2492: hr_utility.trace('action_information_id : '||l_action_information_id);
2493: hr_utility.trace('object_version_number : '||l_object_version_number);
2494: end if;
2495: --

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

2488: --
2489: if g_debug then
2490: hr_utility.set_location(l_proc,60);
2491: hr_utility.trace('assignment_action_id : '||p_assignment_action_id);
2492: hr_utility.trace('action_information_id : '||l_action_information_id);
2493: hr_utility.trace('object_version_number : '||l_object_version_number);
2494: end if;
2495: --
2496: -- update transaction status from U to N because archive has been made.

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

2489: if g_debug then
2490: hr_utility.set_location(l_proc,60);
2491: hr_utility.trace('assignment_action_id : '||p_assignment_action_id);
2492: hr_utility.trace('action_information_id : '||l_action_information_id);
2493: hr_utility.trace('object_version_number : '||l_object_version_number);
2494: end if;
2495: --
2496: -- update transaction status from U to N because archive has been made.
2497: post_assact(

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

2498: p_action_information_id => l_action_information_id,
2499: p_object_version_number => l_object_version_number);
2500: --
2501: if g_debug then
2502: hr_utility.set_location(l_proc,70);
2503: end if;
2504: --
2505: end if;
2506: --

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

2504: --
2505: end if;
2506: --
2507: if g_debug then
2508: hr_utility.set_location(l_proc,1000);
2509: end if;
2510: --
2511: end archive_data;
2512: --

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

2521: --
2522: begin
2523: --
2524: if g_debug then
2525: hr_utility.set_location(l_proc,0);
2526: end if;
2527: --
2528: -- invoke in case of mark for retry.
2529: init_pact(p_payroll_action_id);

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

2528: -- invoke in case of mark for retry.
2529: init_pact(p_payroll_action_id);
2530: --
2531: if g_debug then
2532: hr_utility.set_location(l_proc,10);
2533: end if;
2534: --
2535: archive_pact(p_payroll_action_id);
2536: --

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

2534: --
2535: archive_pact(p_payroll_action_id);
2536: --
2537: if g_debug then
2538: hr_utility.set_location(l_proc,1000);
2539: end if;
2540: --
2541: end deinitialize_code;
2542: --