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.

[Home] [Help]

APPS.PAY_NL_ABP_ARCHIVE dependencies on HR_GENERAL

Line 739: ,hr_general.end_of_time

735: ,c_effective_date IN DATE
736: ,c_period_end_date IN DATE) IS
737: SELECT asg.effective_start_date start_date
738: ,decode (asg.effective_end_date
739: ,hr_general.end_of_time
740: ,trunc (c_period_end_date)
741: ,asg.effective_end_date) end_date
742: ,fnd_number.canonical_to_number (nvl (target.segment29
743: ,'100')) ptp

Line 929: ,hr_general.end_of_time))

925: AND information_type = 'NL_ABP_PAR_INFO'
926: AND aei_information_category = 'NL_ABP_PAR_INFO'
927: AND c_effective_date BETWEEN trunc (fnd_date.canonical_to_date (aei_information1))
928: AND trunc (nvl (fnd_date.canonical_to_date (aei_information2)
929: ,hr_general.end_of_time))
930: AND aei_information6 IS NOT NULL;
931:
932: l_override_value NUMBER := 0;
933: l_dim_name VARCHAR2(100);

Line 1205: ,hr_general.end_of_time)

1201: ,hr_soft_coding_keyflex target
1202: WHERE asg.assignment_id = c_asg_id
1203: AND asg.effective_start_date BETWEEN c_start_date
1204: AND nvl (c_end_date
1205: ,hr_general.end_of_time)
1206: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1207: AND target.enabled_flag = 'Y'
1208: ORDER BY start_date;
1209: --=========================================================================

Line 2381: ,hr_general.end_of_time) >= c_start_date

2377: ,per_all_people_f pap
2378: WHERE posv.organization_structure_id = c_org_struct_id
2379: AND posv.date_from <= c_end_date
2380: AND nvl (posv.date_to
2381: ,hr_general.end_of_time) >= c_start_date
2382: AND (
2383: paa.organization_id IN
2384: (
2385: (

Line 2753: ,hr_general.end_of_time

2749: -- Assignment Period
2750: CURSOR csr_get_asg_period(c_assignment_id IN NUMBER) IS
2751: SELECT min (pas.effective_start_date) asg_start_date
2752: ,decode (max (pas.effective_end_date)
2753: ,hr_general.end_of_time
2754: ,to_date (NULL)
2755: ,max (pas.effective_end_date)) asg_end_date
2756: FROM per_all_assignments_f pas
2757: WHERE pas.assignment_id = c_assignment_id;

Line 2803: ,hr_general.end_of_time);*/

2799: AND aei_information_category = 'NL_ABP_PAR_INFO'
2800: AND assignment_id = c_assignment_id
2801: AND c_effective_date BETWEEN fnd_date.canonical_to_date (aei_information1)
2802: AND nvl (fnd_date.canonical_to_date(aei_information2)
2803: ,hr_general.end_of_time);*/
2804:
2805: CURSOR csr_part_details(c_assignment_id IN NUMBER
2806: ,c_eff_start_date IN DATE
2807: ,c_eff_end_date IN DATE) IS

Line 2817: AND nvl (fnd_date.canonical_to_date (aei_information2), hr_general.end_of_time) >= c_eff_start_date

2813: WHERE information_type = 'NL_ABP_PAR_INFO'
2814: AND aei_information_category = 'NL_ABP_PAR_INFO'
2815: AND assignment_id = c_assignment_id
2816: AND fnd_date.canonical_to_date (aei_information1) <= c_eff_end_date
2817: AND nvl (fnd_date.canonical_to_date (aei_information2), hr_general.end_of_time) >= c_eff_start_date
2818: ORDER BY fnd_date.canonical_to_date (kop_start_date);
2819: --=========================================================================
2820: --All Participation Details
2821: CURSOR csr_all_part_details(c_ass_act_id IN NUMBER

Line 2992: ,hr_general.end_of_time)

2988: WHERE pad.person_id = c_person_id
2989: AND pad.primary_flag = 'Y'
2990: AND c_effective_date BETWEEN pad.date_from
2991: AND nvl (pad.date_to
2992: ,hr_general.end_of_time)
2993: ORDER BY 1 DESC;
2994: --=========================================================================
2995: -- Individual Exemption
2996: CURSOR csr_prin_obj(c_assignment_id IN NUMBER

Line 3007: ,hr_general.end_of_time)

3003: WHERE assignment_id = c_assignment_id
3004: AND information_type = 'NL_USZO_INFO'
3005: AND trunc (c_effective_date) BETWEEN fnd_date.canonical_to_date (aei_information1)
3006: AND nvl (fnd_date.canonical_to_date (aei_information2)
3007: ,hr_general.end_of_time)
3008: AND rownum = 1; -- Added in case of multiple valid rows
3009: --=========================================================================
3010: -- Income Code
3011: CURSOR csr_income_code(c_assignment_id IN NUMBER

Line 3332: l_prev_start_date DATE := hr_general.end_of_time;

3328: l_person_data VARCHAR2(1) := 'Y';
3329: l_person_count NUMBER := 1;
3330: l_prev_asg_info csr_get_prev_asg_info%ROWTYPE;
3331: l_pay_period_count NUMBER:=1;
3332: l_prev_start_date DATE := hr_general.end_of_time;
3333: l_fetch VARCHAR2(1):='Y';
3334: l_temp NUMBER := 0;
3335: l_asg_num per_all_assignments_f.assignment_number%TYPE;
3336: l_kop_report VARCHAR2(1) := 'Y';

Line 3481: OPEN csr_part_details(l_assignment_id,greatest(lv_start_date,l_asg_start_date),least(lv_end_date,nvl(l_asg_end_date,hr_general.end_of_time)));

3477: CLOSE csr_income_code;
3478:
3479: l_temp_date := greatest(lv_start_date,l_asg_start_date);
3480:
3481: OPEN csr_part_details(l_assignment_id,greatest(lv_start_date,l_asg_start_date),least(lv_end_date,nvl(l_asg_end_date,hr_general.end_of_time)));
3482: LOOP
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

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 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 3538: l_kop_end_date := NVL(l_part_details.kop_end_date,least(l_end_date,nvl(l_asg_end_date,hr_general.end_of_time)));

3534: l_kop_start_date := l_part_details.kop_start_date;
3535: IF l_part_details.kop_end_date > last_day(l_part_details.kop_start_date) THEN
3536: l_kop_end_date := last_day(l_part_details.kop_start_date);
3537: ELSE
3538: l_kop_end_date := NVL(l_part_details.kop_end_date,least(l_end_date,nvl(l_asg_end_date,hr_general.end_of_time)));
3539: END IF;
3540:
3541: IF l_temp_date > l_kop_start_date THEN
3542: l_kop_start_date := l_temp_date;

Line 3546: l_kop_end_date := least(l_end_date,nvl(l_asg_end_date,hr_general.end_of_time),l_part_details.kop_end_date);

3542: l_kop_start_date := l_temp_date;
3543: END IF;
3544:
3545: IF l_kop_end_date < l_kop_start_date THEN
3546: l_kop_end_date := least(l_end_date,nvl(l_asg_end_date,hr_general.end_of_time),l_part_details.kop_end_date);
3547: END IF;
3548:
3549: IF l_kop_start_date <> l_start_date AND l_kop_start_date <> l_temp_date THEN
3550: l_wne_start_date:= l_temp_date;

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 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 3885: IF NVL(l_asg_term_date,hr_general.end_of_time) <> hr_general.end_of_time

3881: OPEN c_term_date(l_assignment_id, l_person_id, l_bg_id);
3882: FETCH c_term_date INTO l_asg_term_date;
3883: CLOSE c_term_date;
3884:
3885: IF NVL(l_asg_term_date,hr_general.end_of_time) <> hr_general.end_of_time
3886: THEN
3887: l_asg_end_date := l_asg_term_date;
3888: END IF;
3889: --15859347

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 4903: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',80,'-') || rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION_REPORT'),20,' ') || rpad('-',80,'-'));

4899:
4900: END LOOP;
4901: -- 14793405
4902:
4903: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',80,'-') || rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION_REPORT'),20,' ') || rpad('-',80,'-'));
4904: FND_FILE.PUT_LINE(fnd_file.output,rpad(' ',180,' '));
4905: --
4906: FOR csr_exception_rec IN csr_get_PA_exception_info(p_payroll_action_id) LOOP
4907: --

Line 4912: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||

4908: l_exception_flag := 'Y' ;
4909: IF empr_flag = 'N' THEN
4910: --
4911: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4912: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||
4913: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));
4914: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4915: empr_flag :='Y';
4916: --

Line 4913: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));

4909: IF empr_flag = 'N' THEN
4910: --
4911: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4912: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||
4913: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));
4914: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4915: empr_flag :='Y';
4916: --
4917: END IF;

Line 4931: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||

4927: --
4928: IF empe_flag = 'N' THEN
4929: --
4930: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4931: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
4932: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),45,' ') ||
4933: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
4934: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4935: empe_flag := 'Y';

Line 4932: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),45,' ') ||

4928: IF empe_flag = 'N' THEN
4929: --
4930: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4931: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
4932: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),45,' ') ||
4933: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
4934: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4935: empe_flag := 'Y';
4936: END IF;

Line 4933: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));

4929: --
4930: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4931: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
4932: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),45,' ') ||
4933: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
4934: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4935: empe_flag := 'Y';
4936: END IF;
4937: --

Line 4943: FND_FILE.PUT_LINE(fnd_file.output , hr_general.decode_lookup('NL_FORM_LABELS','WR_NO_VALIDATION_ERRORS'));

4939: --
4940: END LOOP;
4941: --
4942: IF l_exception_flag = 'N' THEN
4943: FND_FILE.PUT_LINE(fnd_file.output , hr_general.decode_lookup('NL_FORM_LABELS','WR_NO_VALIDATION_ERRORS'));
4944: END IF;
4945:
4946: fnd_file.put_line(fnd_file.log,'X====deinitialization_code============X '||p_payroll_action_id);
4947: