DBA Data[Home] [Help]

APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_ACTION_INFORMATION_API

Line 312: pay_action_information_api.create_action_information

308:
309: l_ovnum number;
310: l_action_infor_id number;
311: BEGIN
312: pay_action_information_api.create_action_information
313: (p_action_information_id => l_action_infor_id
314: , p_action_context_id => p_action_context_id
315: , p_action_context_type => 'PA'
316: , p_object_version_number => l_ovnum

Line 3490: pay_action_information_api.create_action_information

3486: l_kop_report := 'N';
3487: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');
3488: fnd_message.set_token('VALUE','WNE');
3489: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));
3490: pay_action_information_api.create_action_information
3491: (
3492: p_action_information_id => l_action_info_id
3493: , p_action_context_id => l_child_aa_id
3494: , p_action_context_type => 'AAP'

Line 3512: pay_action_information_api.create_action_information

3508: l_kop_invalid := 'N';
3509: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');
3510: fnd_message.set_token('VALUE',l_part_details.kop);
3511: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));
3512: pay_action_information_api.create_action_information
3513: (
3514: p_action_information_id => l_action_info_id
3515: , p_action_context_id => l_child_aa_id
3516: , p_action_context_type => 'AAP'

Line 3570: pay_action_information_api.create_action_information

3566: END IF;
3567:
3568: IF l_wne_start_date IS NOT NULL AND l_wne_end_date IS NOT NULL AND l_wne_start_date < l_end_date THEN
3569: hr_utility.trace('1.Archiving Pay Period Details-WNE');
3570: pay_action_information_api.create_action_information
3571: (
3572: p_action_information_id => l_action_info_id
3573: , p_action_context_id => l_child_aa_id
3574: , p_action_context_type => 'AAP'

Line 3594: pay_action_information_api.create_action_information

3590: l_kop_report := 'N';
3591: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');
3592: fnd_message.set_token('VALUE','WNE');
3593: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));
3594: pay_action_information_api.create_action_information
3595: (
3596: p_action_information_id => l_action_info_id
3597: , p_action_context_id => l_child_aa_id
3598: , p_action_context_type => 'AAP'

Line 3629: pay_action_information_api.create_action_information

3625: END IF;
3626: END IF;
3627:
3628: hr_utility.trace('1.Archiving Pay Period Details-!WNE');
3629: pay_action_information_api.create_action_information
3630: (
3631: p_action_information_id => l_action_info_id
3632: , p_action_context_id => l_child_aa_id
3633: , p_action_context_type => 'AAP'

Line 3658: pay_action_information_api.create_action_information

3654: l_kop_report := 'N';
3655: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');
3656: fnd_message.set_token('VALUE','WNE');
3657: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));
3658: pay_action_information_api.create_action_information
3659: (
3660: p_action_information_id => l_action_info_id
3661: , p_action_context_id => l_child_aa_id
3662: , p_action_context_type => 'AAP'

Line 3688: pay_action_information_api.create_action_information

3684: ELSE
3685: l_wne_end_date := NULL;
3686: END IF;
3687: hr_utility.trace('2.Archiving Pay Period Details- WNE');
3688: pay_action_information_api.create_action_information
3689: (
3690: p_action_information_id => l_action_info_id
3691: , p_action_context_id => l_child_aa_id
3692: , p_action_context_type => 'AAP'

Line 3736: pay_action_information_api.create_action_information

3732: ELSE
3733: l_pension_st_date := l_all_contr_amt_values(i).date_earned;
3734: END IF;
3735:
3736: pay_action_information_api.create_action_information
3737: (
3738: p_action_information_id => l_action_info_id
3739: , p_action_context_id => l_child_aa_id
3740: , p_action_context_type => 'AAP'

Line 3769: pay_action_information_api.create_action_information

3765: ,c_start_date => p_start_date
3766: ,c_end_date => p_end_date) LOOP
3767: hr_utility.trace('X====NL_ABP_WITHDRAWAL_INFO=======================X: '||p_person_id);
3768: hr_utility.trace('lv_wth_old_start: '||rec_wth_old_start.date_earned);
3769: pay_action_information_api.create_action_information
3770: (
3771: p_action_information_id => l_action_info_id
3772: , p_action_context_id => l_child_aa_id
3773: , p_action_context_type => 'AAP'

Line 3921: pay_action_information_api.create_action_information

3917: --
3918: IF l_person_info.init = '' OR l_person_info.init IS NULL THEN
3919: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
3920: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','INITIALS'));
3921: pay_action_information_api.create_action_information
3922: (
3923: p_action_information_id => l_action_info_id
3924: , p_action_context_id => l_child_aa_id
3925: , p_action_context_type => 'AAP'

Line 3943: pay_action_information_api.create_action_information

3939: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');
3940: fnd_message.set_token('VALUE',l_person_info.init);
3941: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','INITIALS'));
3942: l_person_info.init := substr(l_person_info.init, 1, 6);
3943: pay_action_information_api.create_action_information
3944: (
3945: p_action_information_id => l_action_info_id
3946: , p_action_context_id => l_child_aa_id
3947: , p_action_context_type => 'AAP'

Line 3965: pay_action_information_api.create_action_information

3961: --
3962: IF l_person_info.employee_number IS NULL THEN
3963: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
3964: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','EMPLOYEE_NUMBER'));
3965: pay_action_information_api.create_action_information
3966: (
3967: p_action_information_id => l_action_info_id
3968: , p_action_context_id => l_child_aa_id
3969: , p_action_context_type => 'AAP'

Line 3987: pay_action_information_api.create_action_information

3983: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');
3984: fnd_message.set_token('VALUE',l_person_info.employee_number);
3985: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','EMPLOYEE_NUMBER'));
3986: l_person_info.employee_number := substr(l_person_info.employee_number,-15); --fetch last fifteen digits
3987: pay_action_information_api.create_action_information
3988: (
3989: p_action_information_id => l_action_info_id
3990: , p_action_context_id => l_child_aa_id
3991: , p_action_context_type => 'AAP'

Line 4013: pay_action_information_api.create_action_information

4009: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');
4010: fnd_message.set_token('VALUE','000000000');
4011: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','BSN'));
4012: l_person_info.sofi_number := '000000000';
4013: pay_action_information_api.create_action_information
4014: (
4015: p_action_information_id => l_action_info_id
4016: , p_action_context_id => l_child_aa_id
4017: , p_action_context_type => 'AAP'

Line 4035: pay_action_information_api.create_action_information

4031: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');
4032: fnd_message.set_token('VALUE',l_person_info.sofi_number);
4033: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','BSN'));
4034: l_person_info.sofi_number := substr(l_person_info.sofi_number, 1, 9);
4035: pay_action_information_api.create_action_information
4036: (
4037: p_action_information_id => l_action_info_id
4038: , p_action_context_id => l_child_aa_id
4039: , p_action_context_type => 'AAP'

Line 4084: pay_action_information_api.create_action_information

4080: hr_utility.trace('Prev Period Start Date ' ||l_prev_asg_info.start_date);
4081: hr_utility.trace('Prev Termination Date ' ||l_prev_asg_info.term_date);
4082: hr_utility.trace('End Date ' ||l_asg_end_date);
4083:
4084: pay_action_information_api.create_action_information
4085: (
4086: p_action_information_id => l_action_info_id
4087: , p_action_context_id => l_child_aa_id
4088: , p_action_context_type => 'AAP'

Line 4157: pay_action_information_api.create_action_information

4153: ||l_kind_emp);*/
4154:
4155: hr_utility.trace('Archiving Assignment Info : ');
4156:
4157: pay_action_information_api.create_action_information
4158: (
4159: p_action_information_id => l_action_info_id
4160: , p_action_context_id => l_child_aa_id
4161: , p_action_context_type => 'AAP'

Line 4238: pay_action_information_api.create_action_information

4234: l_iso := l_person_addr.iso;
4235: END IF;
4236:
4237: IF l_street IS NULL THEN
4238: pay_action_information_api.create_action_information
4239: (
4240: p_action_information_id => l_action_info_id
4241: , p_action_context_id => l_child_aa_id
4242: , p_action_context_type => 'AAP'

Line 4261: pay_action_information_api.create_action_information

4257: /* --15859347
4258: IF l_house_number IS NULL THEN
4259: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4260: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','HOUSE_NUMBER'));
4261: pay_action_information_api.create_action_information
4262: (
4263: p_action_information_id => l_action_info_id
4264: , p_action_context_id => l_child_aa_id
4265: , p_action_context_type => 'AAP'

Line 4282: pay_action_information_api.create_action_information

4278: END IF;
4279: */ --15859347
4280: --
4281: IF l_city IS NULL THEN
4282: pay_action_information_api.create_action_information
4283: (
4284: p_action_information_id => l_action_info_id
4285: , p_action_context_id => l_child_aa_id
4286: , p_action_context_type => 'AAP'

Line 4306: pay_action_information_api.create_action_information

4302: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');
4303: fnd_message.set_token('VALUE','0000AA');
4304: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','POSTAL_CODE'));
4305: l_postal_code := '0000AA';
4306: pay_action_information_api.create_action_information
4307: (
4308: p_action_information_id => l_action_info_id
4309: , p_action_context_id => l_child_aa_id
4310: , p_action_context_type => 'AAP'

Line 4328: pay_action_information_api.create_action_information

4324: --
4325: IF l_person_addr.style = 'NL_GLB' AND l_iso IS NULL THEN
4326: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4327: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','ISO_CODE'));
4328: pay_action_information_api.create_action_information
4329: (
4330: p_action_information_id => l_action_info_id
4331: , p_action_context_id => l_child_aa_id
4332: , p_action_context_type => 'AAP'

Line 4353: pay_action_information_api.create_action_information

4349:
4350: IF l_nationality IS NULL THEN
4351: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4352: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','NATIONALITY'));
4353: pay_action_information_api.create_action_information
4354: (
4355: p_action_information_id => l_action_info_id
4356: , p_action_context_id => l_child_aa_id
4357: , p_action_context_type => 'AAP'

Line 4379: pay_action_information_api.create_action_information

4375: CLOSE csr_prin_obj;
4376:
4377: hr_utility.trace('Archiving Person Data : ');
4378:
4379: pay_action_information_api.create_action_information
4380: (
4381: p_action_information_id => l_action_info_id
4382: , p_action_context_id => l_child_aa_id
4383: , p_action_context_type => 'AAP'

Line 4496: pay_action_information_api.create_action_information

4492: hr_utility.trace('months_between(l_wth_prd_start_date,l_asg_start_date) : '||months_between(l_wth_prd_start_date,l_asg_start_date));
4493: IF l_pay_period_det_cnt = months_between(trunc(l_wth_prd_start_date,'MM'),trunc(l_asg_start_date,'MM')) THEN
4494: l_code_withdrawal := 'ja';
4495: END IF;
4496: pay_action_information_api.create_action_information
4497: (
4498: p_action_information_id => l_action_info_id
4499: , p_action_context_id => l_child_aa_id
4500: , p_action_context_type => 'AAP'

Line 4681: pay_action_information_api.create_action_information

4677: IF csr_get_sender_details%FOUND THEN
4678: IF l_sender_details.reg_num_sender IS NULL THEN
4679: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4680: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','ABP_SENDER'));
4681: pay_action_information_api.create_action_information
4682: (
4683: p_action_information_id => l_action_info_id
4684: , p_action_context_id => p_payroll_action_id
4685: , p_action_context_type => 'PA'

Line 4701: pay_action_information_api.create_action_information

4697: END IF;
4698: IF l_sender_details.prod_test IS NULL THEN
4699: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4700: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','TEST_FLAG'));
4701: pay_action_information_api.create_action_information
4702: (
4703: p_action_information_id => l_action_info_id
4704: , p_action_context_id => p_payroll_action_id
4705: , p_action_context_type => 'PA'

Line 4721: pay_action_information_api.create_action_information

4717: END IF;
4718: ELSE
4719: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4720: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','ABP_SENDER'));
4721: pay_action_information_api.create_action_information
4722: (
4723: p_action_information_id => l_action_info_id
4724: , p_action_context_id => p_payroll_action_id
4725: , p_action_context_type => 'PA'

Line 4740: pay_action_information_api.create_action_information

4736: , p_action_information7 => substr(l_er_name,1,200));
4737:
4738: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4739: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','TEST_FLAG'));
4740: pay_action_information_api.create_action_information
4741: (
4742: p_action_information_id => l_action_info_id
4743: , p_action_context_id => p_payroll_action_id
4744: , p_action_context_type => 'PA'

Line 4763: pay_action_information_api.create_action_information

4759: OPEN csr_app_version;
4760: FETCH csr_app_version into l_get_app_ver;
4761: CLOSE csr_app_version;
4762:
4763: pay_action_information_api.create_action_information
4764: (
4765: p_action_information_id => l_action_info_id
4766: , p_action_context_id => p_payroll_action_id
4767: , p_action_context_type => 'PA'

Line 4833: pay_action_information_api.create_action_information

4829: END LOOP;
4830: END IF;
4831:
4832: IF l_er_num IS NULL THEN
4833: pay_action_information_api.create_action_information
4834: (
4835: p_action_information_id => l_action_info_id
4836: , p_action_context_id => p_payroll_action_id
4837: , p_action_context_type => 'PA'

Line 4855: pay_action_information_api.create_action_information

4851:
4852: IF l_freq IS NULL THEN
4853: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4854: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','FREQUENCY'));
4855: pay_action_information_api.create_action_information
4856: (
4857: p_action_information_id => l_action_info_id
4858: , p_action_context_id => p_payroll_action_id
4859: , p_action_context_type => 'PA'

Line 4874: pay_action_information_api.create_action_information

4870: , p_action_information7 => substr(l_er_name,1,200)
4871: , p_action_information8 => substr(l_er_num,1,12));
4872: END IF;
4873:
4874: pay_action_information_api.create_action_information
4875: (
4876: p_action_information_id => l_action_info_id
4877: , p_action_context_id => p_payroll_action_id
4878: , p_action_context_type => 'PA'