eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_ABP_ARCHIVE dependencies on FND_MESSAGE

Line 3487: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');

3483: FETCH csr_part_details INTO l_part_details;
3484: IF csr_part_details%FOUND THEN
3485: IF l_kop_report = 'Y' AND l_part_details.kop IS NULL THEN
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: (

Line 3488: fnd_message.set_token('VALUE','WNE');

3484: IF csr_part_details%FOUND THEN
3485: IF l_kop_report = 'Y' AND l_part_details.kop IS NULL THEN
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

Line 3489: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));

3485: IF l_kop_report = 'Y' AND l_part_details.kop IS NULL THEN
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

Line 3502: , p_action_information4 => fnd_message.get

3498: , p_source_id => NULL
3499: , p_source_text => NULL
3500: , p_tax_unit_id => l_org_id
3501: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3502: , p_action_information4 => fnd_message.get
3503: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3504: , p_action_information6 => 'Kind of Participation is null'
3505: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3506: , p_action_information8 => to_char(l_asg_num));

Line 3509: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');

3505: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3506: , p_action_information8 => to_char(l_asg_num));
3507: ELSIF l_kop_invalid = 'Y' AND l_part_details.kop IN ('VLF','WVP') THEN
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: (

Line 3510: fnd_message.set_token('VALUE',l_part_details.kop);

3506: , p_action_information8 => to_char(l_asg_num));
3507: ELSIF l_kop_invalid = 'Y' AND l_part_details.kop IN ('VLF','WVP') THEN
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

Line 3511: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));

3507: ELSIF l_kop_invalid = 'Y' AND l_part_details.kop IN ('VLF','WVP') THEN
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

Line 3524: , p_action_information4 => fnd_message.get

3520: , p_source_id => NULL
3521: , p_source_text => NULL
3522: , p_tax_unit_id => l_org_id
3523: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3524: , p_action_information4 => fnd_message.get
3525: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3526: , p_action_information6 => 'Invalid Kind of Participation'
3527: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3528: , p_action_information8 => to_char(l_asg_num));

Line 3591: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');

3587: );
3588: hr_utility.trace('l_kop_report: '||l_kop_report);
3589: IF l_kop_report = 'Y' THEN
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: (

Line 3592: fnd_message.set_token('VALUE','WNE');

3588: hr_utility.trace('l_kop_report: '||l_kop_report);
3589: IF l_kop_report = 'Y' THEN
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

Line 3593: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));

3589: IF l_kop_report = 'Y' THEN
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

Line 3606: , p_action_information4 => fnd_message.get

3602: , p_source_id => NULL
3603: , p_source_text => NULL
3604: , p_tax_unit_id => l_org_id
3605: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3606: , p_action_information4 => fnd_message.get
3607: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3608: , p_action_information6 => 'Kind of Participation is null'
3609: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3610: , p_action_information8 => to_char(l_asg_num));

Line 3655: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');

3651: ELSE
3652: --
3653: IF l_kop_report = 'Y' THEN
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: (

Line 3656: fnd_message.set_token('VALUE','WNE');

3652: --
3653: IF l_kop_report = 'Y' THEN
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

Line 3657: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));

3653: IF l_kop_report = 'Y' THEN
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

Line 3670: , p_action_information4 => fnd_message.get

3666: , p_source_id => NULL
3667: , p_source_text => NULL
3668: , p_tax_unit_id => l_org_id
3669: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3670: , p_action_information4 => fnd_message.get
3671: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3672: , p_action_information6 => 'Kind of Participation is null'
3673: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3674: , p_action_information8 => to_char(l_asg_num));

Line 3919: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');

3915: CLOSE csr_get_withdrawal_flag;
3916:
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

Line 3920: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','INITIALS'));

3916:
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

Line 3933: , p_action_information4 => fnd_message.get

3929: , p_source_id => NULL
3930: , p_source_text => NULL
3931: , p_tax_unit_id => l_org_id
3932: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3933: , p_action_information4 => fnd_message.get
3934: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3935: , p_action_information6 => 'Invalid Initials for the employee'
3936: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3937: , p_action_information8 => to_char(l_asg_num));

Line 3939: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');

3935: , p_action_information6 => 'Invalid Initials for the employee'
3936: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3937: , p_action_information8 => to_char(l_asg_num));
3938: ELSIF length(l_person_info.init) > 6 THEN
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

Line 3940: fnd_message.set_token('VALUE',l_person_info.init);

3936: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3937: , p_action_information8 => to_char(l_asg_num));
3938: ELSIF length(l_person_info.init) > 6 THEN
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: (

Line 3941: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','INITIALS'));

3937: , p_action_information8 => to_char(l_asg_num));
3938: ELSIF length(l_person_info.init) > 6 THEN
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

Line 3955: , p_action_information4 => fnd_message.get

3951: , p_source_id => NULL
3952: , p_source_text => NULL
3953: , p_tax_unit_id => l_org_id
3954: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3955: , p_action_information4 => fnd_message.get
3956: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3957: , p_action_information6 => 'Invalid Employee Number'
3958: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3959: , p_action_information8 => to_char(l_asg_num));

Line 3963: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');

3959: , p_action_information8 => to_char(l_asg_num));
3960: END IF;
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

Line 3964: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','EMPLOYEE_NUMBER'));

3960: END IF;
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

Line 3977: , p_action_information4 => fnd_message.get

3973: , p_source_id => NULL
3974: , p_source_text => NULL
3975: , p_tax_unit_id => l_org_id
3976: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3977: , p_action_information4 => fnd_message.get
3978: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3979: , p_action_information6 => 'Employee Number missing'
3980: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3981: , p_action_information8 => to_char(l_asg_num));

Line 3983: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');

3979: , p_action_information6 => 'Employee Number missing'
3980: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3981: , p_action_information8 => to_char(l_asg_num));
3982: ELSIF length(l_person_info.employee_number) > 15 THEN
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

Line 3984: fnd_message.set_token('VALUE',l_person_info.employee_number);

3980: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3981: , p_action_information8 => to_char(l_asg_num));
3982: ELSIF length(l_person_info.employee_number) > 15 THEN
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: (

Line 3985: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','EMPLOYEE_NUMBER'));

3981: , p_action_information8 => to_char(l_asg_num));
3982: ELSIF length(l_person_info.employee_number) > 15 THEN
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

Line 3999: , p_action_information4 => fnd_message.get

3995: , p_source_id => NULL
3996: , p_source_text => NULL
3997: , p_tax_unit_id => l_org_id
3998: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3999: , p_action_information4 => fnd_message.get
4000: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4001: , p_action_information6 => 'Invalid Employee Number'
4002: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4003: , p_action_information8 => to_char(l_asg_num));

Line 4009: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');

4005: l_person_info.employee_number := lpad(l_person_info.employee_number, 15, 0);
4006: END IF;
4007: --
4008: IF l_person_info.sofi_number IS NULL THEN
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

Line 4010: fnd_message.set_token('VALUE','000000000');

4006: END IF;
4007: --
4008: IF l_person_info.sofi_number IS NULL THEN
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: (

Line 4011: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','BSN'));

4007: --
4008: IF l_person_info.sofi_number IS NULL THEN
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

Line 4025: , p_action_information4 => fnd_message.get

4021: , p_source_id => NULL
4022: , p_source_text => NULL
4023: , p_tax_unit_id => l_org_id
4024: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4025: , p_action_information4 => fnd_message.get
4026: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4027: , p_action_information6 => 'BSN/Sofi Number missing'
4028: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4029: , p_action_information8 => to_char(l_asg_num));

Line 4031: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');

4027: , p_action_information6 => 'BSN/Sofi Number missing'
4028: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4029: , p_action_information8 => to_char(l_asg_num));
4030: ELSIF length(l_person_info.sofi_number) > 9 THEN
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

Line 4032: fnd_message.set_token('VALUE',l_person_info.sofi_number);

4028: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4029: , p_action_information8 => to_char(l_asg_num));
4030: ELSIF length(l_person_info.sofi_number) > 9 THEN
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: (

Line 4033: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','BSN'));

4029: , p_action_information8 => to_char(l_asg_num));
4030: ELSIF length(l_person_info.sofi_number) > 9 THEN
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

Line 4047: , p_action_information4 => fnd_message.get

4043: , p_source_id => NULL
4044: , p_source_text => NULL
4045: , p_tax_unit_id => l_org_id
4046: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4047: , p_action_information4 => fnd_message.get
4048: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4049: , p_action_information6 => 'Invalid BSN/Sofi Number'
4050: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4051: , p_action_information8 => to_char(l_asg_num));

Line 4250: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_STREET')

4246: , p_source_id => NULL
4247: , p_source_text => NULL
4248: , p_tax_unit_id => l_org_id
4249: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4250: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_STREET')
4251: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4252: , p_action_information6 => 'Street name missing in the address'
4253: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4254: , p_action_information8 => to_char(l_asg_num));

Line 4259: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');

4255: END IF;
4256: --
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

Line 4260: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','HOUSE_NUMBER'));

4256: --
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

Line 4273: , p_action_information4 => fnd_message.get

4269: , p_source_id => NULL
4270: , p_source_text => NULL
4271: , p_tax_unit_id => l_org_id
4272: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4273: , p_action_information4 => fnd_message.get
4274: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4275: , p_action_information6 => 'House Number missing in address'
4276: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4277: , p_action_information8 => to_char(l_asg_num));

Line 4294: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_CITY')

4290: , p_source_id => NULL
4291: , p_source_text => NULL
4292: , p_tax_unit_id => l_org_id
4293: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4294: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_CITY')
4295: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4296: , p_action_information6 => 'City name missing in the address'
4297: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4298: , p_action_information8 => to_char(l_asg_num));

Line 4302: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');

4298: , p_action_information8 => to_char(l_asg_num));
4299: END IF;
4300: --
4301: IF l_person_addr.style = 'NL' AND l_postal_code IS NULL THEN
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

Line 4303: fnd_message.set_token('VALUE','0000AA');

4299: END IF;
4300: --
4301: IF l_person_addr.style = 'NL' AND l_postal_code IS NULL THEN
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: (

Line 4304: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','POSTAL_CODE'));

4300: --
4301: IF l_person_addr.style = 'NL' AND l_postal_code IS NULL THEN
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

Line 4318: , p_action_information4 => fnd_message.get

4314: , p_source_id => NULL
4315: , p_source_text => NULL
4316: , p_tax_unit_id => l_org_id
4317: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4318: , p_action_information4 => fnd_message.get
4319: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4320: , p_action_information6 => 'Postal Code missing in address'
4321: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4322: , p_action_information8 => to_char(l_asg_num));

Line 4326: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');

4322: , p_action_information8 => to_char(l_asg_num));
4323: END IF;
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

Line 4327: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','ISO_CODE'));

4323: END IF;
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

Line 4340: , p_action_information4 => fnd_message.get

4336: , p_source_id => NULL
4337: , p_source_text => NULL
4338: , p_tax_unit_id => l_org_id
4339: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4340: , p_action_information4 => fnd_message.get
4341: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4342: , p_action_information6 => 'ISO Country code missing in address'
4343: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4344: , p_action_information8 => to_char(l_asg_num));

Line 4351: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');

4347: END IF;--csr_get_person_addr%FOUND
4348: CLOSE csr_get_person_addr;
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

Line 4352: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','NATIONALITY'));

4348: CLOSE csr_get_person_addr;
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

Line 4365: , p_action_information4 => fnd_message.get

4361: , p_source_id => NULL
4362: , p_source_text => NULL
4363: , p_tax_unit_id => l_org_id
4364: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4365: , p_action_information4 => fnd_message.get
4366: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4367: , p_action_information6 => 'Invalid Nationality for the employee'
4368: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4369: , p_action_information8 => to_char(l_asg_num));

Line 4679: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');

4675: OPEN csr_get_sender_details(l_org_id,l_bg_id);
4676: FETCH csr_get_sender_details into l_sender_details;
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

Line 4680: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','ABP_SENDER'));

4676: FETCH csr_get_sender_details into l_sender_details;
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

Line 4693: , p_action_information4 => fnd_message.get

4689: , p_source_id => NULL
4690: , p_source_text => NULL
4691: , p_tax_unit_id => l_org_id
4692: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4693: , p_action_information4 => fnd_message.get
4694: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4695: , p_action_information6 => 'ABP Registration Number Sender is null'
4696: , p_action_information7 => substr(l_er_name,1,200));
4697: END IF;

Line 4699: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');

4695: , p_action_information6 => 'ABP Registration Number Sender is null'
4696: , p_action_information7 => substr(l_er_name,1,200));
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

Line 4700: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','TEST_FLAG'));

4696: , p_action_information7 => substr(l_er_name,1,200));
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

Line 4713: , p_action_information4 => fnd_message.get

4709: , p_source_id => NULL
4710: , p_source_text => NULL
4711: , p_tax_unit_id => l_org_id
4712: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4713: , p_action_information4 => fnd_message.get
4714: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4715: , p_action_information6 => 'Test Environment Flag is null'
4716: , p_action_information7 => substr(l_er_name,1,200));
4717: END IF;

Line 4719: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');

4715: , p_action_information6 => 'Test Environment Flag is null'
4716: , p_action_information7 => substr(l_er_name,1,200));
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

Line 4720: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','ABP_SENDER'));

4716: , p_action_information7 => substr(l_er_name,1,200));
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

Line 4733: , p_action_information4 => fnd_message.get

4729: , p_source_id => NULL
4730: , p_source_text => NULL
4731: , p_tax_unit_id => l_org_id
4732: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4733: , p_action_information4 => fnd_message.get
4734: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4735: , p_action_information6 => 'ABP Registration Number Sender is null'
4736: , p_action_information7 => substr(l_er_name,1,200));
4737:

Line 4738: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');

4734: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4735: , p_action_information6 => 'ABP Registration Number Sender is null'
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

Line 4739: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','TEST_FLAG'));

4735: , p_action_information6 => 'ABP Registration Number Sender is null'
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

Line 4752: , p_action_information4 => fnd_message.get

4748: , p_source_id => NULL
4749: , p_source_text => NULL
4750: , p_tax_unit_id => l_org_id
4751: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4752: , p_action_information4 => fnd_message.get
4753: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4754: , p_action_information6 => 'Test Environment Flag is null'
4755: , p_action_information7 => substr(l_er_name,1,200));
4756: END IF;

Line 4845: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TAX_NO')

4841: , p_source_id => NULL
4842: , p_source_text => NULL
4843: , p_tax_unit_id => l_org_id
4844: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4845: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TAX_NO')
4846: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4847: , p_action_information6 => 'Tax Registration Number is null'
4848: , p_action_information7 => substr(l_er_name,1,200)
4849: , p_action_information8 => substr(l_er_num,1,12));

Line 4853: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');

4849: , p_action_information8 => substr(l_er_num,1,12));
4850: END IF;
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

Line 4854: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','FREQUENCY'));

4850: END IF;
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

Line 4867: , p_action_information4 => fnd_message.get

4863: , p_source_id => NULL
4864: , p_source_text => NULL
4865: , p_tax_unit_id => l_org_id
4866: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4867: , p_action_information4 => fnd_message.get
4868: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4869: , p_action_information6 => 'Frequency is null'
4870: , p_action_information7 => substr(l_er_name,1,200)
4871: , p_action_information8 => substr(l_er_num,1,12));