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_FR_DADS_EMP_PKG dependencies on HR_GENERAL

Line 139: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');

135: -- Getting the error messages
136: -- hr_utility.trace_on(null, 'SA_DADS');
137: hr_utility.set_location('S30 Entering:'||p_org_id,1);
138:
139: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
140: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');
141:
142: p_id := p_org_id;
143: --Initialize the globals

Line 140: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');

136: -- hr_utility.trace_on(null, 'SA_DADS');
137: hr_utility.set_location('S30 Entering:'||p_org_id,1);
138:
139: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
140: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');
141:
142: p_id := p_org_id;
143: --Initialize the globals
144: --

Line 169: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup

165: l_ss_number := l_emp_rec.ss_number;
166: IF l_emp_rec.ss_number is null THEN
167: l_error_type := l_error;
168: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
169: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup
170: ('FR_DADS_RUBRICS','S30.G01.00.001'), null);
171: ELSIF ( substr(l_emp_rec.ss_number, 1, 1) = '7' or substr(l_emp_rec.ss_number, 1, 1) = '8') THEN
172: l_error_type := l_error;
173: l_value := pay_fr_general.get_payroll_message

Line 205: 'VALUE1:'||hr_general.decode_lookup

201: -- Birth name
202: IF l_emp_rec.birth_name is null THEN
203: l_error_type := l_error;
204: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
205: 'VALUE1:'||hr_general.decode_lookup
206: ('FR_DADS_RUBRICS','S30.G01.00.002'), null, null);
207: ELSE
208: l_error_type := null;
209: l_value := null;

Line 228: ||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup

224: IF ((l_emp_rec.first_name is null)
225: and (l_emp_rec.middle_names is null)) THEN
226: l_error_type := l_error;
227: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA','VALUE1:'
228: ||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup
229: ('FR_DADS_RUBRICS','S30.G01.00.003'), null);
230: ELSE
231: l_error_type := null;
232: l_value := null;

Line 334: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S30.G01.00.007'), null, null);

330: /* If title is null, then error message is archived */
331: ELSIF l_emp_rec.title is null THEN
332: l_error_type := l_error;
333: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
334: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S30.G01.00.007'), null, null);
335: archive_data( p_rubric_name => 'S30.G01.00.007'
336: ,p_message_type => l_error_type
337: ,p_id => p_id
338: ,p_lookup_type => null

Line 359: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup

355: -- Employee Address street
356: IF l_emp_rec.street is null THEN
357: l_error_type := l_error;
358: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
359: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup
360: ('FR_DADS_RUBRICS','S30.G01.00.008.006'), null);
361: ELSE
362: l_error_type := Null;
363: l_value := Null;

Line 407: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup

403: -- Postal Code
404: IF l_emp_rec.postal_code is null THEN
405: l_error_type := l_error;
406: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
407: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup
408: ('FR_DADS_RUBRICS','S30.G01.00.008.010'), null);
409: ELSE
410: l_error_type := Null;
411: l_value := Null;

Line 426: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup

422: -- City
423: IF l_emp_rec.town is null THEN
424: l_error_type := l_error;
425: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
426: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup
427: ('FR_DADS_RUBRICS','S30.G01.00.008.012'), null);
428: ELSIF l_emp_rec.town <> upper(l_emp_rec.town) THEN
429: l_error_type := l_error;
430: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',

Line 451: 'VALUE1: '||hr_general.decode_lookup

447: IF l_emp_rec.country_code = 'FR'
448: AND l_emp_rec.country_code is not null THEN
449: l_error_type := l_error;
450: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
451: 'VALUE1: '||hr_general.decode_lookup
452: ('FR_DADS_RUBRICS','S30.G01.00.008.013'), null, null);
453: ELSE
454: l_error_type := Null;
455: l_value := Null;

Line 471: 'VALUE1: '||hr_general.decode_lookup

467: -- Country Name
468: IF l_emp_rec.country_name is not null and l_emp_rec.country_code = 'FR' THEN
469: l_error_type := l_error;
470: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
471: 'VALUE1: '||hr_general.decode_lookup
472: ('FR_DADS_RUBRICS','S30.G01.00.008.014'), null, null);
473: ELSIF l_emp_rec.country_name is null AND l_emp_rec.country_code is not null
474: AND l_emp_rec.country_code <> 'FR' THEN
475: l_error_type := l_error;

Line 477: 'VALUE1:'||hr_general.decode_lookup

473: ELSIF l_emp_rec.country_name is null AND l_emp_rec.country_code is not null
474: AND l_emp_rec.country_code <> 'FR' THEN
475: l_error_type := l_error;
476: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
477: 'VALUE1:'||hr_general.decode_lookup
478: ('FR_DADS_RUBRICS','S30.G01.00.008.014'), null, null);
479: ELSE
480: l_error_type := Null;
481: l_value := Null;

Line 508: 'VALUE1:'||hr_general.decode_lookup

504: -- Date of birth
505: IF l_emp_rec.date_of_birth is null THEN
506: l_error_type := l_error;
507: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
508: 'VALUE1:'||hr_general.decode_lookup
509: ('FR_DADS_RUBRICS','S30.G01.00.009'), null);
510: ELSE
511: l_error_type := Null;
512: l_value := Null;

Line 529: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup

525: IF (l_emp_rec.town_of_birth is null
526: AND l_emp_rec.country_of_birth = 'FR') THEN
527: l_error_type := l_error;
528: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
529: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup
530: ('FR_DADS_RUBRICS','S30.G01.00.010'), null);
531: -- #3553740 Deleted the archiving procedure call. Since, it is archived again after this if loop.
532: ELSE
533: l_error_type := Null;

Line 551: 'VALUE1:'||hr_general.decode_lookup

547: -- Birth department code
548: /*IF l_emp_rec.region_of_birth is null THEN
549: l_error_type := l_error;
550: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
551: 'VALUE1:'||hr_general.decode_lookup
552: ('FR_DADS_RUBRICS','S30.G01.00.011'), null, null);
553: ELSE
554: l_error_type := Null;
555: l_value := Null;

Line 574: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup

570: -- Birth department code
571: IF (l_emp_rec.region_of_birth is null) THEN
572: l_error_type := l_error;
573: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
574: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup
575: ('FR_DADS_RUBRICS','S30.G01.00.011.M'), null);
576: ELSE
577: l_error_type := Null;
578: l_value := Null;

Line 595: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup

591: -- Birth department code
592: IF (l_emp_rec.region_of_birth is null) THEN
593: l_error_type := l_error;
594: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
595: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup
596: ('FR_DADS_RUBRICS','S30.G01.00.011.M'), null);
597: ELSE
598: l_error_type := Null;
599: l_value := Null;

Line 614: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup

610: -- Birth country
611: IF l_emp_rec.country_of_birth is null THEN
612: l_error_type := l_error;
613: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
614: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup
615: ('FR_DADS_RUBRICS','S30.G01.00.012'), null);
616: ELSE
617: l_error_type := Null;
618: l_value := Null;

Line 633: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup

629: -- Nationality
630: IF l_emp_rec.nationality is null THEN
631: l_error_type := l_error;
632: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
633: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'||hr_general.decode_lookup
634: ('FR_DADS_RUBRICS','S30.G01.00.013'), null);
635: ELSE
636: l_error_type := Null;
637: l_value := Null;

Line 639: l_nationality := hr_general.decode_lookup('NATIONALITY', l_emp_rec.nationality);

635: ELSE
636: l_error_type := Null;
637: l_value := Null;
638: END IF;
639: l_nationality := hr_general.decode_lookup('NATIONALITY', l_emp_rec.nationality);
640: archive_data(p_rubric_name => 'S30.G01.00.013'
641: ,p_message_type => l_error_type
642: ,p_id => p_id
643: ,p_lookup_type =>'NATIONALITY'

Line 1451: l_leav_reason := hr_general.decode_lookup('LEAV_REAS', get_person_rec.leav_reason);

1447: Loop
1448: l_date_start := get_person_rec.start_date;
1449: l_act_dt := get_person_rec.term_date;
1450: l_final_date := get_person_rec.final_date;
1451: l_leav_reason := hr_general.decode_lookup('LEAV_REAS', get_person_rec.leav_reason);
1452: End Loop;
1453:
1454: hr_utility.set_location('S41 g_param_start_date 97:'||g_param_start_date,10);
1455:

Line 2022: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');

2018:
2019: --
2020: --
2021: -- Getting the error messages
2022: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
2023: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');
2024:
2025: --
2026: hr_utility.set_location('L_HIST COUNT:'||l_hist.count, 117);

Line 2023: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');

2019: --
2020: --
2021: -- Getting the error messages
2022: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
2023: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');
2024:
2025: --
2026: hr_utility.set_location('L_HIST COUNT:'||l_hist.count, 117);
2027:

Line 2077: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.001'),

2073:
2074: IF l_hist(l_counter).start_date is null THEN
2075: l_error_type := l_error;
2076: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2077: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.001'),
2078: null, null);
2079: ELSE
2080: l_error_type := null;
2081: l_value := null;

Line 2097: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.002'),

2093: -- Reason Code for Start Period
2094: IF l_hist(l_counter).start_reason is null THEN
2095: l_error_type := l_error;
2096: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2097: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.002'),
2098: null, null);
2099: ELSE
2100: l_error_type := null;
2101: l_value := null;

Line 2117: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.003'),

2113: --End of the Period for the Situation
2114: IF l_hist(l_counter).start_date is null THEN
2115: l_error_type := l_error;
2116: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2117: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.003'),
2118: null, null);
2119: ELSE
2120: l_error_type := null;
2121: l_value := null;

Line 2136: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.004'),

2132: -- Reason Code for End Period
2133: IF l_hist(l_counter).end_reason is null THEN
2134: l_error_type := l_error;
2135: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2136: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.004'),
2137: null, null);
2138: ELSE
2139: l_error_type := null;
2140: l_value := null;

Line 2234: 'VALUE1:'||l_issue_estab_name, 'VALUE2:'||hr_general.decode_lookup

2230: hr_utility.set_location('S41 out of the fitst cursor',114);
2231: IF l_siret_number is null THEN
2232: l_error_type := l_error;
2233: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2234: 'VALUE1:'||l_issue_estab_name, 'VALUE2:'||hr_general.decode_lookup
2235: ('FR_DADS_RUBRICS','S41.G01.00.005'), null);
2236: ELSE
2237: l_error_type := null;
2238: l_value := null;

Line 2257: 'VALUE1:'||l_issue_estab_name, 'VALUE2:'||hr_general.decode_lookup

2253: -- Work Accident Section Code
2254: IF l_work_section_code is null THEN
2255: l_error_type := l_error;
2256: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2257: 'VALUE1:'||l_issue_estab_name, 'VALUE2:'||hr_general.decode_lookup
2258: ('FR_DADS_RUBRICS','S41.G01.00.025'), null);
2259: ELSIF l_work_section_code = '98' THEN
2260: l_error_type := l_error;
2261: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',

Line 2262: 'VALUE1:'|| hr_general.decode_lookup

2258: ('FR_DADS_RUBRICS','S41.G01.00.025'), null);
2259: ELSIF l_work_section_code = '98' THEN
2260: l_error_type := l_error;
2261: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',
2262: 'VALUE1:'|| hr_general.decode_lookup
2263: ('FR_DADS_RUBRICS','S41.G01.00.025'), 'VALUE2:'||hr_general.decode_lookup
2264: ('FR_DADS_RUBRICS','S41.G01.00.025.M'), null);
2265: ELSE
2266: l_error_type := null;

Line 2263: ('FR_DADS_RUBRICS','S41.G01.00.025'), 'VALUE2:'||hr_general.decode_lookup

2259: ELSIF l_work_section_code = '98' THEN
2260: l_error_type := l_error;
2261: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',
2262: 'VALUE1:'|| hr_general.decode_lookup
2263: ('FR_DADS_RUBRICS','S41.G01.00.025'), 'VALUE2:'||hr_general.decode_lookup
2264: ('FR_DADS_RUBRICS','S41.G01.00.025.M'), null);
2265: ELSE
2266: l_error_type := null;
2267: l_value := null;

Line 2283: 'VALUE1:'||l_issue_estab_name, 'VALUE2:'||hr_general.decode_lookup

2279: -- Work Accident Risk Code
2280: IF l_work_risk_code is null THEN
2281: l_error_type := l_error;
2282: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2283: 'VALUE1:'||l_issue_estab_name, 'VALUE2:'||hr_general.decode_lookup
2284: ('FR_DADS_RUBRICS','S41.G01.00.026'), null);
2285: -- Bug #3756137
2286: ELSIF length(l_work_risk_code) > 5 then
2287: l_error_type := l_warning;

Line 2299: 'VALUE1:'|| hr_general.decode_lookup

2295: -- Bug #3756137
2296: ELSIF l_work_risk_code = '98888' THEN
2297: l_error_type := l_error;
2298: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',
2299: 'VALUE1:'|| hr_general.decode_lookup
2300: ('FR_DADS_RUBRICS','S41.G01.00.026'), 'VALUE2:'||hr_general.decode_lookup
2301: ('FR_DADS_RUBRICS','S41.G01.00.025.M'), null);
2302: ELSE
2303: l_error_type := null;

Line 2300: ('FR_DADS_RUBRICS','S41.G01.00.026'), 'VALUE2:'||hr_general.decode_lookup

2296: ELSIF l_work_risk_code = '98888' THEN
2297: l_error_type := l_error;
2298: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',
2299: 'VALUE1:'|| hr_general.decode_lookup
2300: ('FR_DADS_RUBRICS','S41.G01.00.026'), 'VALUE2:'||hr_general.decode_lookup
2301: ('FR_DADS_RUBRICS','S41.G01.00.025.M'), null);
2302: ELSE
2303: l_error_type := null;
2304: l_value := null;

Line 2337: 'VALUE1:'||l_issue_estab_name, 'VALUE2:'||hr_general.decode_lookup

2333: -- Office Work Accident Code
2334: IF l_work_office_code is not null AND l_work_office_code <> 'B' THEN
2335: l_error_type := l_error;
2336: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',
2337: 'VALUE1:'||l_issue_estab_name, 'VALUE2:'||hr_general.decode_lookup
2338: ('FR_DADS_RUBRICS','S41.G01.00.027.M'), null);
2339: ELSE
2340: l_error_type := null;
2341: l_value := null;

Line 2363: 'VALUE1:'||l_issue_estab_name, 'VALUE2:'||hr_general.decode_lookup

2359: -- Work Accident Rate
2360: IF l_work_acc_rate is null THEN
2361: l_error_type := l_error;
2362: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2363: 'VALUE1:'||l_issue_estab_name, 'VALUE2:'||hr_general.decode_lookup
2364: ('FR_DADS_RUBRICS','S41.G01.00.028'), null);
2365: ELSE
2366: l_error_type := null;
2367: l_value := null;

Line 2397: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.008'),

2393: -- Multiple Employers Code
2394: IF l_multi_employr_code is null THEN
2395: l_error_type := l_error;
2396: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2397: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.008'),
2398: null, null);
2399: ELSE
2400: l_error_type := null;
2401: l_value := null;

Line 2425: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.009'),

2421: l_positive_offset := '01';
2422: IF l_positive_offset is null THEN
2423: l_error_type := l_error;
2424: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2425: 'VALUE1:'||hr_general.decode_lookup('FR_DADS_RUBRICS','S41.G01.00.009'),
2426: null, null);
2427: ELSE
2428: l_error_type := null;
2429: l_value := null;

Line 2506: 'VALUE1:'||l_emp_full_name, 'VALUE2:'||hr_general.decode_lookup

2502: -- Job Nature
2503: IF l_job_name is null THEN
2504: l_error_type := l_error;
2505: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2506: 'VALUE1:'||l_emp_full_name, 'VALUE2:'||hr_general.decode_lookup
2507: ('FR_DADS_RUBRICS','S41.G01.00.010'), null);
2508: ELSE
2509: l_error_type := null;
2510: l_value := null;

Line 2526: 'VALUE1:'||l_job_name, 'VALUE2:'||hr_general.decode_lookup

2522: -- Category Code
2523: IF l_job_name is not null AND l_pcs_code is null THEN
2524: l_error_type := l_error;
2525: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2526: 'VALUE1:'||l_job_name, 'VALUE2:'||hr_general.decode_lookup
2527: ('FR_DADS_RUBRICS','S41.G01.00.011.M'), null);
2528: ELSE
2529: --3311942 call the procedure to get the valid pcs code
2530: per_fr_d2_pkg. get_pcs_code (p_report_qualifier => 'DADS'

Line 2551: 'VALUE1:'||hr_general.decode_lookup

2547: -- Work Contract Code
2548: IF l_contract_type is null THEN
2549: l_error_type := l_error;
2550: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2551: 'VALUE1:'||hr_general.decode_lookup
2552: ('FR_DADS_RUBRICS','S41.G01.00.012'), null, null);
2553: ELSE
2554: l_error_type := null;
2555: l_value := null;

Line 2571: 'VALUE1:'||l_emp_full_name, 'VALUE2:'||hr_general.decode_lookup

2567: -- Professional Status Code
2568: IF l_prof_code is null THEN
2569: l_error_type := l_error;
2570: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2571: 'VALUE1:'||l_emp_full_name, 'VALUE2:'||hr_general.decode_lookup
2572: ('FR_DADS_RUBRICS','S41.G01.00.014'), null);
2573: ELSE
2574: l_error_type := null;
2575: l_value := null;

Line 2638: 'VALUE1:'||hr_general.decode_lookup

2634: -- Activity Type Code
2635: IF l_act_typ_code is null THEN
2636: l_error_type := l_error;
2637: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2638: 'VALUE1:'||hr_general.decode_lookup
2639: ('FR_DADS_RUBRICS','S41.G01.00.013'), null, null);
2640: ELSE
2641: l_error_type := null;
2642: l_value := null;

Line 2684: 'VALUE1:'||hr_general.decode_lookup

2680: -- Percentage of Part Time
2681: IF l_act_typ_code = '02' AND l_percentage_part_time is null THEN
2682: l_error_type := l_error;
2683: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2684: 'VALUE1:'||hr_general.decode_lookup
2685: ('FR_DADS_RUBRICS','S41.G01.00.020'), null, null);
2686: ELSE
2687: l_error_type := null;
2688: l_value := null;

Line 2742: 'VALUE1:'||hr_general.decode_lookup

2738: -- Employee Category Code
2739: IF l_emp_cat_code is null THEN
2740: l_error_type := l_error;
2741: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2742: 'VALUE1:'||hr_general.decode_lookup
2743: ('FR_DADS_RUBRICS','S41.G01.00.015'), null, null);
2744: ELSE
2745: l_error_type := null;
2746: l_value := null;

Line 2832: 'VALUE1:'||hr_general.decode_lookup

2828:
2829: IF l_pension_code is null THEN
2830: l_error_type := l_error;
2831: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2832: 'VALUE1:'||hr_general.decode_lookup
2833: ('FR_DADS_RUBRICS','S41.G01.00.018'), null, null);
2834: ELSE
2835: l_error_type := null;
2836: l_value := null;

Line 2860: 'VALUE1:'||l_issue_estab_name, 'VALUE2: '||hr_general.decode_lookup

2856: -- Code for Work Abroad
2857: IF l_border_worker <> '01' AND l_border_worker <> '02' AND l_border_worker is null THEN
2858: l_error_type := l_error;
2859: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',
2860: 'VALUE1:'||l_issue_estab_name, 'VALUE2: '||hr_general.decode_lookup
2861: ('FR_DADS_RUBRICS','S41.G01.00.034.M'), null);
2862: END IF;
2863:
2864: archive_data( p_rubric_name => 'S41.G01.00.034'

Line 3234: 'VALUE1:'||hr_general.decode_lookup

3230: -- Gross Social Security Base
3231: IF l_gross_sbase_sec Is Null THEN
3232: l_error_type := l_error;
3233: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
3234: 'VALUE1:'||hr_general.decode_lookup
3235: ('FR_DADS_RUBRICS','S41.G01.00.029.001'), null, null);
3236: ELSIF l_gross_sbase_sec < 0 THEN
3237: l_gross_sbase_sec_sign := 'N';
3238: l_error_type := l_warning;

Line 3240: 'VALUE1:'||hr_general.decode_lookup

3236: ELSIF l_gross_sbase_sec < 0 THEN
3237: l_gross_sbase_sec_sign := 'N';
3238: l_error_type := l_warning;
3239: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',
3240: 'VALUE1:'||hr_general.decode_lookup
3241: ('FR_DADS_RUBRICS','S41.G01.00.029.001'), null, null);
3242: ELSE
3243: l_error_type := null;
3244: l_value := null;

Line 3261: 'VALUE1:', 'VALUE2: '||hr_general.decode_lookup

3257: -- Sign
3258: IF l_gross_sbase_sec_sign <> 'N' AND l_gross_sbase_sec_sign is not null THEN
3259: l_error_type := l_error;
3260: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',
3261: 'VALUE1:', 'VALUE2: '||hr_general.decode_lookup
3262: ('FR_DADS_RUBRICS','S41.G01.00.029.002.M'), null);
3263: ELSE
3264: l_error_type := null;
3265: l_value := null;

Line 3286: 'VALUE1:'||hr_general.decode_lookup

3282: -- Capped Social Secuirty Base
3283: IF l_cap_ssec_base is null THEN
3284: l_error_type := l_error;
3285: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
3286: 'VALUE1:'||hr_general.decode_lookup
3287: ('FR_DADS_RUBRICS','S41.G01.00.030.001'), null, null);
3288: ELSIF l_cap_ssec_base < 0 THEN
3289: l_cap_ssec_base_sign := 'N';
3290: l_error_type := l_warning;

Line 3292: 'VALUE1:'||hr_general.decode_lookup

3288: ELSIF l_cap_ssec_base < 0 THEN
3289: l_cap_ssec_base_sign := 'N';
3290: l_error_type := l_warning;
3291: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',
3292: 'VALUE1:'||hr_general.decode_lookup
3293: ('FR_DADS_RUBRICS','S41.G01.00.030.001'), null, null);
3294: ELSE
3295: l_error_type := null;
3296: l_value := null;

Line 3312: 'VALUE1:', 'VALUE2: '||hr_general.decode_lookup

3308: -- Sign
3309: IF l_cap_ssec_base_sign <> 'N' AND l_cap_ssec_base_sign is not null THEN
3310: l_error_type := l_error;
3311: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',
3312: 'VALUE1:', 'VALUE2: '||hr_general.decode_lookup
3313: ('FR_DADS_RUBRICS','S41.G01.00.029.002.M'), null);
3314: ELSE
3315: l_error_type := null;
3316: l_value := null;

Line 3333: 'VALUE1:'||hr_general.decode_lookup

3329: l_csg_base := l_subject_to_csg + l_subject_to_csg_excess;
3330: IF l_csg_base is null THEN
3331: l_error_type := l_error;
3332: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
3333: 'VALUE1:'||hr_general.decode_lookup
3334: ('FR_DADS_RUBRICS','S41.G01.00.032.001'), null, null);
3335: ELSIF l_csg_base < 0 THEN
3336: l_csg_base_sign := 'N';
3337: l_error_type := l_warning;

Line 3339: 'VALUE1:'||hr_general.decode_lookup

3335: ELSIF l_csg_base < 0 THEN
3336: l_csg_base_sign := 'N';
3337: l_error_type := l_warning;
3338: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',
3339: 'VALUE1:'||hr_general.decode_lookup
3340: ('FR_DADS_RUBRICS','S41.G01.00.032.001'), null, null);
3341: ELSE
3342: l_error_type := null;
3343: l_value := null;

Line 3362: 'VALUE1:', 'VALUE2: '||hr_general.decode_lookup

3358: -- Sign
3359: IF l_csg_base_sign <> 'N' AND l_csg_base_sign is not null THEN
3360: l_error_type := l_error;
3361: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',
3362: 'VALUE1:', 'VALUE2: '||hr_general.decode_lookup
3363: ('FR_DADS_RUBRICS','S41.G01.00.029.002.M'), null);
3364: ELSE
3365: l_error_type := null;
3366: l_value := null;

Line 3384: 'VALUE1:'||hr_general.decode_lookup

3380: -- CRDS Base
3381: IF l_subject_to_crds is null THEN
3382: l_error_type := l_error;
3383: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
3384: 'VALUE1:'||hr_general.decode_lookup
3385: ('FR_DADS_RUBRICS','S41.G01.00.033.001'), null, null);
3386: ELSIF l_subject_to_crds < 0 THEN
3387: l_subject_to_crds_sign := 'N';
3388: l_error_type := l_warning;

Line 3390: 'VALUE1:'||hr_general.decode_lookup

3386: ELSIF l_subject_to_crds < 0 THEN
3387: l_subject_to_crds_sign := 'N';
3388: l_error_type := l_warning;
3389: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',
3390: 'VALUE1:'||hr_general.decode_lookup
3391: ('FR_DADS_RUBRICS','S41.G01.00.033.001'), null, null);
3392: ELSE
3393: l_error_type := null;
3394: l_value := null;

Line 3411: 'VALUE1:', 'VALUE2: '||hr_general.decode_lookup

3407: -- Sign
3408: IF l_subject_to_crds_sign <> 'N' AND l_subject_to_crds_sign is not null THEN
3409: l_error_type := l_error;
3410: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',
3411: 'VALUE1:', 'VALUE2: '||hr_general.decode_lookup
3412: ('FR_DADS_RUBRICS','S41.G01.00.029.002.M'), null);
3413: ELSE
3414: l_error_type := null;
3415: l_value := null;

Line 3431: 'VALUE1:'||hr_general.decode_lookup

3427: l_fiscal_base := l_subject_to_salary_tax +l_subject_to_salary_tax_excess;
3428: IF l_fiscal_base is null THEN
3429: l_error_type := l_error;
3430: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
3431: 'VALUE1:'||hr_general.decode_lookup
3432: ('FR_DADS_RUBRICS','S41.G01.00.035.001'), null, null);
3433: ELSIF l_fiscal_base < 0 THEN
3434: l_fiscal_base_sign := 'N';
3435: l_error_type := l_warning;

Line 3437: 'VALUE1:'||hr_general.decode_lookup

3433: ELSIF l_fiscal_base < 0 THEN
3434: l_fiscal_base_sign := 'N';
3435: l_error_type := l_warning;
3436: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',
3437: 'VALUE1:'||hr_general.decode_lookup
3438: ('FR_DADS_RUBRICS','S41.G01.00.035.001'), null, null);
3439: ELSE
3440: l_error_type := null;
3441: l_value := null;

Line 3458: 'VALUE1:', 'VALUE2: '||hr_general.decode_lookup

3454: -- Sign
3455: IF l_fiscal_base_sign <> 'N' AND l_fiscal_base_sign is not null THEN
3456: l_error_type := l_error;
3457: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',
3458: 'VALUE1:', 'VALUE2: '||hr_general.decode_lookup
3459: ('FR_DADS_RUBRICS','S41.G01.00.029.002.M'), null);
3460: ELSE
3461: l_error_type := null;
3462: l_value := null;

Line 3646: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',

3642: -- Activity Salary
3643: IF l_taxable_income is null THEN
3644: l_error_type := l_error;
3645: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
3646: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
3647: 'S41.G01.00.063.001'), null, null);
3648: ELSIF l_taxable_income_sign = 'N' THEN
3649: l_error_type := l_warning;
3650: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',

Line 3651: 'VALUE1:'||hr_general.decode_lookup

3647: 'S41.G01.00.063.001'), null, null);
3648: ELSIF l_taxable_income_sign = 'N' THEN
3649: l_error_type := l_warning;
3650: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',
3651: 'VALUE1:'||hr_general.decode_lookup
3652: ('FR_DADS_RUBRICS','S41.G01.00.063.001'), null, null);
3653: ELSE
3654: l_error_type := null;
3655: l_value := null;

Line 3671: 'VALUE1:'||l_emp_full_name, 'VALUE2: '||hr_general.decode_lookup

3667: IF l_asg_location is null THEN
3668: -- #3553797 Added employee full name in the token. Previously assignment establishment name was there in the token.
3669: l_error_type := l_error;
3670: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
3671: 'VALUE1:'||l_emp_full_name, 'VALUE2: '||hr_general.decode_lookup
3672: ('FR_DADS_RUBRICS','S41.G01.00.060.006.M'), null);
3673: archive_data( p_rubric_name => 'S41.G01.00.060.006'
3674: ,p_message_type => l_error_type
3675: ,p_id => p_org_id

Line 3704: 'VALUE1:'||l_location_name, 'VALUE2:'||hr_general.decode_lookup

3700: -- Nature and name of the street
3701: IF ((l_est_location <> l_asg_location) AND l_csr_asg_loc.street_name is null) THEN
3702: l_error_type := l_error;
3703: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
3704: 'VALUE1:'||l_location_name, 'VALUE2:'||hr_general.decode_lookup
3705: ('FR_DADS_RUBRICS','S41.G01.00.060.006'), null);
3706: ELSIF ((l_est_location = l_asg_location) AND l_csr_asg_loc.street_name is not null) THEN
3707: l_error_type := l_error;
3708: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',

Line 3709: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',

3705: ('FR_DADS_RUBRICS','S41.G01.00.060.006'), null);
3706: ELSIF ((l_est_location = l_asg_location) AND l_csr_asg_loc.street_name is not null) THEN
3707: l_error_type := l_error;
3708: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',
3709: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
3710: 'S41.G01.00.060.006'), null, null);
3711: ELSE
3712: l_error_type := null;
3713: l_value := null;

Line 3739: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',

3735: --Name of the town
3736: IF ((l_est_location = l_asg_location) AND l_csr_asg_loc.small_town is not null) THEN
3737: l_error_type := l_error;
3738: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',
3739: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
3740: 'S41.G01.00.060.009'), null, null);
3741: ELSIF ((l_est_location <> l_asg_location)
3742: AND upper(l_csr_asg_loc.small_town) = upper(l_csr_asg_loc.town)) THEN
3743: l_error_type := l_error;

Line 3763: 'VALUE1:'||l_location_name, 'VALUE2:'||hr_general.decode_lookup

3759: --Zip Code
3760: IF ((l_est_location <> l_asg_location) AND l_csr_asg_loc.zip_code is null) THEN
3761: l_error_type := l_error;
3762: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
3763: 'VALUE1:'||l_location_name, 'VALUE2:'||hr_general.decode_lookup
3764: ('FR_DADS_RUBRICS','S41.G01.00.060.010'), null);
3765: ELSIF ((l_est_location = l_asg_location) AND l_csr_asg_loc.zip_code is not null) THEN
3766: l_error_type := l_error;
3767: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',

Line 3768: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',

3764: ('FR_DADS_RUBRICS','S41.G01.00.060.010'), null);
3765: ELSIF ((l_est_location = l_asg_location) AND l_csr_asg_loc.zip_code is not null) THEN
3766: l_error_type := l_error;
3767: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',
3768: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
3769: 'S41.G01.00.060.010'), null, null);
3770: ELSE
3771: l_error_type := null;
3772: l_value := null;

Line 3787: 'VALUE1:'||l_location_name, 'VALUE2:'||hr_general.decode_lookup

3783: --Town
3784: IF ((l_est_location <> l_asg_location) AND l_csr_asg_loc.town is null) THEN
3785: l_error_type := l_error;
3786: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
3787: 'VALUE1:'||l_location_name, 'VALUE2:'||hr_general.decode_lookup
3788: ('FR_DADS_RUBRICS','S41.G01.00.060.012'), null);
3789: ELSIF ((l_est_location <> l_asg_location)
3790: AND l_csr_asg_loc.town <> upper(l_csr_asg_loc.town)) THEN
3791: l_error_type := l_error;

Line 3797: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',

3793: null, null, null);
3794: ELSIF ((l_est_location = l_asg_location) AND l_csr_asg_loc.town is not null) THEN
3795: l_error_type := l_error;
3796: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',
3797: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
3798: 'S41.G01.00.060.012'), null, null);
3799: ELSE
3800: l_error_type := null;
3801: l_value := null;

Line 3817: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',

3813: /* -- Country Code
3814: IF ((l_est_location = l_asg_location) AND l_country_code is not null) THEN
3815: l_error_type := l_error;
3816: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',
3817: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
3818: 'S41.G01.00.060.013'), null, null);
3819: ELSIF ((l_est_location <> l_asg_location) AND l_country_code = 'FR') THEN
3820: l_error_type := l_error;
3821: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',

Line 3822: 'VALUE1: '||hr_general.decode_lookup

3818: 'S41.G01.00.060.013'), null, null);
3819: ELSIF ((l_est_location <> l_asg_location) AND l_country_code = 'FR') THEN
3820: l_error_type := l_error;
3821: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
3822: 'VALUE1: '||hr_general.decode_lookup
3823: ('FR_DADS_RUBRICS','S41.G01.00.060.013'), null, null);
3824: ELSE
3825: l_error_type := null;
3826: l_value := null;

Line 3841: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',

3837: --Country Name
3838: IF ((l_est_location = l_asg_location) AND l_csr_asg_loc.country_name is not null) THEN
3839: l_error_type := l_error;
3840: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',
3841: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
3842: 'S41.G01.00.060.014'), null, null);
3843: ELSIF (l_est_location <> l_asg_location) THEN
3844: IF l_csr_asg_loc.country_name is not null and l_country_code = 'FR' THEN
3845: l_error_type := l_error;

Line 3847: 'VALUE1: '||hr_general.decode_lookup

3843: ELSIF (l_est_location <> l_asg_location) THEN
3844: IF l_csr_asg_loc.country_name is not null and l_country_code = 'FR' THEN
3845: l_error_type := l_error;
3846: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
3847: 'VALUE1: '||hr_general.decode_lookup
3848: ('FR_DADS_RUBRICS','S41.G01.00.060.014'), null, null);
3849: ELSIF l_csr_asg_loc.country_name is null AND l_country_code is not null
3850: AND l_csr_asg_loc.country_code <> 'FR' THEN
3851: l_error_type := l_error;

Line 3853: 'VALUE1:'||hr_general.decode_lookup

3849: ELSIF l_csr_asg_loc.country_name is null AND l_country_code is not null
3850: AND l_csr_asg_loc.country_code <> 'FR' THEN
3851: l_error_type := l_error;
3852: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
3853: 'VALUE1:'||hr_general.decode_lookup
3854: ('FR_DADS_RUBRICS','S41.G01.00.060.014'), null, null);
3855: ELSE
3856: l_error_type := null;
3857: l_value := null;

Line 4004: l_user_value := hr_general.decode_lookup(p_lookup_type, p_file_value);

4000: hr_utility.set_location('archive_data:'||p_rubric_name,555);
4001: l_file_value := p_file_value;
4002: hr_utility.set_location('l_file_value:'||l_file_value,555);
4003: If p_lookup_type Is Not Null Then
4004: l_user_value := hr_general.decode_lookup(p_lookup_type, p_file_value);
4005: If p_rubric_name = 'S30.G01.00.007' Then
4006: If l_file_value = 'MR.' Then
4007: l_file_Value := '01';
4008: Elsif l_file_value = 'MRS.' Then

Line 4049: Elsif (p_message_type = hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W')) Then

4045: ,p_action_information6 => Null
4046: ,p_action_information8 => p_id2
4047: ,p_action_information9 => p_rubric_type);
4048: End if;
4049: Elsif (p_message_type = hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W')) Then
4050: hr_utility.set_location('p_message_type2:'||p_message_type,1234);
4051: pay_action_information_api.create_action_information( p_action_information_id => l_action_info_id
4052: ,p_action_context_id => g_assign_action_id
4053: ,p_action_context_type => 'AAP'

Line 4065: Elsif (p_message_type = hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E')) Then

4061: ,p_action_information6 => p_message_text
4062: ,p_action_information8 => p_id2
4063: ,p_action_information9 => p_rubric_type);
4064:
4065: Elsif (p_message_type = hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E')) Then
4066: hr_utility.set_location('p_message_type3:'||p_message_type,1234);
4067: pay_action_information_api.create_action_information( p_action_information_id => l_action_info_id
4068: ,p_action_context_id => g_assign_action_id
4069: ,p_action_context_type => 'AAP'