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 PAY_FR_GENERAL

Line 168: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

164:
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;

Line 173: l_value := pay_fr_general.get_payroll_message

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
174: ('PAY_75181_SS_TEMP','VALUE1:'||l_emp_rec.full_name, 'VALUE2:'|| l_emp_rec.person_id
175: , null);
176: /* This has to be finalised by Heather */
177: ELSIF instr (upper(l_emp_rec.ss_number), 'X') > 0 THEN

Line 180: l_value := pay_fr_general.get_payroll_message('PAY_75189_SS_INCMP',

176: /* This has to be finalised by Heather */
177: ELSIF instr (upper(l_emp_rec.ss_number), 'X') > 0 THEN
178: l_ss_number := replace(l_emp_rec.ss_number, 'X', '9');
179: l_error_type := l_warning;
180: l_value := pay_fr_general.get_payroll_message('PAY_75189_SS_INCMP',
181: 'VALUE1:'||l_emp_rec.full_name, 'VALUE2:'|| l_emp_rec.ss_number, null);
182: ELSE
183: l_error_type := null;
184: l_value := null;

Line 204: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

200:
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;

Line 227: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA','VALUE1:'

223: -- Given Christian names
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;

Line 333: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

329: End if;
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

Line 358: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

354:
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;

Line 386: l_value := pay_fr_general.get_payroll_message('PAY_75179_TWN_CITY',

382:
383: -- Town
384: IF upper(l_emp_rec.small_town ) = upper(l_emp_rec.town) THEN
385: l_error_type := l_error;
386: l_value := pay_fr_general.get_payroll_message('PAY_75179_TWN_CITY',
387: null, null, null);
388: ELSE
389: l_error_type := Null;
390: l_value := Null;

Line 406: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

402:
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;

Line 425: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

421:
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;

Line 430: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',

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',
431: null, null, null);
432: ELSE
433: l_error_type := Null;
434: l_value := Null;

Line 450: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',

446: -- Country Code
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;

Line 470: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',

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

Line 476: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

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;
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;

Line 507: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

503:
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;

Line 528: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

524: -- Town of birth
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

Line 550: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

546: If (l_emp_rec.country_of_birth <> 'FR' And l_emp_rec.country_of_birth Is not Null) Then
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;

Line 573: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

569: Elsif (l_emp_rec.country_of_birth = 'FR') Then
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;

Line 594: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

590: Elsif (l_emp_rec.country_of_birth is null) Then
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;

Line 613: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

609: End If;
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;

Line 632: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

628:
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;

Line 657: FND_FILE.PUT_LINE(FND_FILE.LOG, pay_fr_general.get_payroll_message('PAY_75195_DADS',null));

653:
654: End loop;
655:
656: If (l_emp_found = FALSE) Then
657: FND_FILE.PUT_LINE(FND_FILE.LOG, pay_fr_general.get_payroll_message('PAY_75195_DADS',null));
658: End If;
659:
660: Exception
661: When others then

Line 2076: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

2072: End If;
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;

Line 2096: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

2092:
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;

Line 2116: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

2112:
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;

Line 2135: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

2131:
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;

Line 2233: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

2229: -- NIC of the Assignment Establishment
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;

Line 2256: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

2252:
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;

Line 2261: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_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',
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

Line 2282: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

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

Line 2288: l_value := pay_fr_general.get_payroll_message('PAY_75095_DADS_WORK_ACC_CODE1',

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;
2288: l_value := pay_fr_general.get_payroll_message('PAY_75095_DADS_WORK_ACC_CODE1',
2289: 'VALUE1:'|| l_work_risk_code, null, null);
2290: l_work_risk_code := substr(l_work_risk_code, 1, 5);
2291: ELSIF length(l_work_risk_code) < 5 then
2292: l_error_type := l_warning;

Line 2293: l_value := pay_fr_general.get_payroll_message('PAY_75096_DADS_WORK_ACC_CODE2',

2289: 'VALUE1:'|| l_work_risk_code, null, null);
2290: l_work_risk_code := substr(l_work_risk_code, 1, 5);
2291: ELSIF length(l_work_risk_code) < 5 then
2292: l_error_type := l_warning;
2293: l_value := pay_fr_general.get_payroll_message('PAY_75096_DADS_WORK_ACC_CODE2',
2294: 'VALUE1:'|| l_work_risk_code, null, null);
2295: -- Bug #3756137
2296: ELSIF l_work_risk_code = '98888' THEN
2297: l_error_type := l_error;

Line 2298: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',

2294: 'VALUE1:'|| l_work_risk_code, null, null);
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

Line 2336: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',

2332:
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;

Line 2362: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

2358:
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;

Line 2396: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

2392: --Need to be edited for exceptions report validation
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;

Line 2424: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

2420: --Item: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;

Line 2505: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

2501: --Need to be edited for exceptions report validation
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;

Line 2525: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

2521: hr_utility.set_location('S41 l_job_name:'||l_job_name,113);
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

Line 2550: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

2546: hr_utility.set_location('S41 l_pcs_code:'||l_pcs_code,113);
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;

Line 2570: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

2566: hr_utility.set_location('S41 l_contract_type:'||l_contract_type,113);
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;

Line 2637: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

2633: -- #3553847 previously the validation was there within the above if statement. Now, it has been taken down.
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;

Line 2666: l_emp_month_hours := PAY_FR_GENERAL.convert_hours(p_effective_date => l_effective_date

2662: --Item:S41.G01.00.020
2663: If (l_act_typ_val Is not Null And substr(l_act_typ_val,1,1) = 'P') Then
2664:
2665: If l_frequency <> 'M' Then
2666: l_emp_month_hours := PAY_FR_GENERAL.convert_hours(p_effective_date => l_effective_date
2667: ,p_business_group_id => g_param_business_group_id
2668: ,p_assignment_id => l_assignment_id
2669: ,p_hours => l_norm_hours
2670: ,p_from_freq_code => l_frequency

Line 2683: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

2679: -- #3553872 previously the validation was there within the above if statement. Now, it has been taken down.
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;

Line 2741: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

2737:
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;

Line 2831: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

2827: -- Basic Pension Organisation Code
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;

Line 2859: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',

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

Line 3233: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

3229: hr_utility.set_location('S41 l_gross_sbase_sec:'||l_gross_sbase_sec,116);
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';

Line 3239: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',

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;
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;

Line 3260: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',

3256: -- Item ID : S41.G01.00.029.002
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;

Line 3285: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

3281:
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';

Line 3291: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',

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;
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;

Line 3311: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',

3307: -- Item ID : S41.G01.00.030.002
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;

Line 3332: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

3328: -- CSG Base
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';

Line 3338: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',

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;
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;

Line 3361: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',

3357:
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;

Line 3383: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

3379:
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';

Line 3389: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',

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;
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;

Line 3410: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',

3406: -- Item ID : S41.G01.00.033.002
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;

Line 3430: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

3426: -- Fiscal Base
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';

Line 3436: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',

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;
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;

Line 3457: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',

3453: -- Item ID : S41.G01.00.035.002
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;

Line 3645: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

3641: -- Item ID : S41.G01.00.063.001
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;

Line 3650: l_value := pay_fr_general.get_payroll_message('PAY_75188_VAL_NEG',

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',
3651: 'VALUE1:'||hr_general.decode_lookup
3652: ('FR_DADS_RUBRICS','S41.G01.00.063.001'), null, null);
3653: ELSE
3654: l_error_type := null;

Line 3670: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

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

Line 3703: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

3699:
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;

Line 3708: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',

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',
3709: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
3710: 'S41.G01.00.060.006'), null, null);
3711: ELSE
3712: l_error_type := null;

Line 3738: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',

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

Line 3744: l_value := pay_fr_general.get_payroll_message('PAY_75179_TWN_CITY',

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;
3744: l_value := pay_fr_general.get_payroll_message('PAY_75179_TWN_CITY',
3745: null, null, null);
3746: ELSE
3747: l_error_type := null;
3748: l_value := null;

Line 3762: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

3758:
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;

Line 3767: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',

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',
3768: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
3769: 'S41.G01.00.060.010'), null, null);
3770: ELSE
3771: l_error_type := null;

Line 3786: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

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

Line 3792: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',

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;
3792: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',
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',

Line 3796: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',

3792: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',
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;

Line 3816: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',

3812: --Country Code
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;

Line 3821: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',

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',
3822: 'VALUE1: '||hr_general.decode_lookup
3823: ('FR_DADS_RUBRICS','S41.G01.00.060.013'), null, null);
3824: ELSE
3825: l_error_type := null;

Line 3840: l_value := pay_fr_general.get_payroll_message('PAY_75180_OMIT_VAL',

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

Line 3846: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',

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;
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

Line 3852: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

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;
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;