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_ESTAB_COMP dependencies on PAY_FR_GENERAL

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

254: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');
255: -- SIREN Number
256: IF l_siren is null THEN
257: l_error_type := l_error;
258: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
259: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup
260: ('FR_DADS_RUBRICS','S10.G01.00.001.001'), null);
261: ELSE
262: l_error_type := null;

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

275: --
276: --NIC Origin Establishment
277: IF l_nic is null THEN
278: l_error_type := l_error;
279: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
280: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup
281: ('FR_DADS_RUBRICS','S10.G01.00.001.002'), null);
282: ELSE
283: l_error_type := null;

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

296: --
297: -- Name of the Establishment
298: IF l_name is null THEN
299: l_error_type := l_error;
300: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
301: 'VALUE1: '||hr_general.decode_lookup
302: ('FR_DADS_RUBRICS','S10.G01.00.002'), null, null);
303: ELSE
304: l_error_type := null;

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

316: ,p_usage => 'M');
317: -- First check the location
318: IF l_location is null THEN
319: l_error_type := l_error;
320: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
321: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup
322: ('FR_DADS_RUBRICS','S10.G01.00.003.006.M'), null);
323: -- Archive Nature and Name of the Street
324: archive_data(

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

368: ,p_usage => 'O');
369: -- Nature and Name of the Street
370: IF l_street_and_number is null THEN
371: l_error_type := l_error;
372: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
373: 'VALUE1:'||l_location_name, 'VALUE2: '||hr_general.decode_lookup
374: ('FR_DADS_RUBRICS','S10.G01.00.003.006'), null);
375: ELSE
376: l_error_type := null;

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

402: --
403: -- Name of the Town
404: IF upper(l_small_town) = upper(l_town) THEN
405: l_error_type := l_error;
406: l_value := pay_fr_general.get_payroll_message('PAY_75179_TWN_CITY',
407: null, null, null);
408: -- making the value of 'TOWN' as null
409: -- for bug 3550604
410: l_small_town := null;

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

425: --
426: -- Zip Code
427: IF l_postal_code is null THEN
428: l_error_type := l_error;
429: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
430: 'VALUE1:'||l_location_name, 'VALUE2: '||hr_general.decode_lookup
431: ('FR_DADS_RUBRICS','S10.G01.00.003.010'), null);
432: ELSE
433: l_error_type := null;

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

446: --
447: -- City
448: IF l_town <> upper(l_town) THEN
449: l_error_type := l_error;
450: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',
451: null, null, null);
452: ELSIF l_town is null THEN
453: l_error_type := l_error;
454: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

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

450: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',
451: null, null, null);
452: ELSIF l_town is null THEN
453: l_error_type := l_error;
454: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
455: 'VALUE1:'||l_location_name, 'VALUE2: '||hr_general.decode_lookup
456: ('FR_DADS_RUBRICS','S10.G01.00.003.012'), null);
457: ELSE
458: l_error_type := null;

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

472: /* Afnor Codes
473: -- Country Code
474: IF l_country_code = 'FR' THEN
475: l_error_type := l_error;
476: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
477: 'VALUE1: '||hr_general.decode_lookup
478: ('FR_DADS_RUBRICS','S10.G01.00.003.013'), null, null);
479: ELSE
480: l_error_type := null;

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

494: */
495: -- Country Name
496: IF l_country_name is not null and l_country_code = 'FR' THEN
497: l_error_type := l_error;
498: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
499: 'VALUE1: '||hr_general.decode_lookup
500: ('FR_DADS_RUBRICS','S10.G01.00.003.014'), null, null);
501: ELSIF l_country_name is null AND l_country_code is not null AND l_country_code <> 'FR' THEN
502: l_error_type := l_error;

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

499: 'VALUE1: '||hr_general.decode_lookup
500: ('FR_DADS_RUBRICS','S10.G01.00.003.014'), null, null);
501: ELSIF l_country_name is null AND l_country_code is not null AND l_country_code <> 'FR' THEN
502: l_error_type := l_error;
503: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
504: 'VALUE1: '||hr_general.decode_lookup
505: ('FR_DADS_RUBRICS','S10.G01.00.003.014'), null, null);
506: ELSE
507: l_error_type := null;

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

521: END IF; -- Check for location
522: -- Internal Reference
523: IF p_param_reference is null THEN
524: l_error_type := l_error;
525: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
526: 'VALUE1: '||hr_general.decode_lookup
527: ('FR_DADS_RUBRICS','S10.G01.00.004'), null, null);
528: ELSE
529: l_error_type := null;

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

581: --
582: -- Service Code
583: IF l_service_code is null THEN
584: l_error_type := l_error;
585: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
586: 'VALUE1: '||hr_general.decode_lookup
587: ('FR_DADS_RUBRICS','S10.G01.00.009'), null, null);
588: ELSE
589: l_error_type := null;

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

602: --
603: -- Norm
604: IF l_norm is null THEN
605: l_error_type := l_error;
606: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
607: 'VALUE1: '||hr_general.decode_lookup
608: ('FR_DADS_RUBRICS','S10.G01.00.011'), null, null);
609: ELSE
610: l_error_type := null;

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

623: --
624: -- Character Table Code
625: IF l_table_code is null THEN
626: l_error_type := l_error;
627: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
628: 'VALUE1: '||hr_general.decode_lookup
629: ('FR_DADS_RUBRICS','S10.G01.00.012'), null, null);
630: ELSE
631: l_error_type := null;

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

644: --
645: -- Live Send Code
646: IF l_live_send_code is null THEN
647: l_error_type := l_error;
648: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
649: 'VALUE1: '||hr_general.decode_lookup
650: ('FR_DADS_RUBRICS','S10.G01.00.010'), null, null);
651: ELSE
652: l_error_type := null;

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

665: --
666: -- Test Send Code
667: IF l_test_send_code is null THEN
668: l_error_type := l_error;
669: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
670: 'VALUE1: '||hr_general.decode_lookup
671: ('FR_DADS_RUBRICS','S10.G01.00.010'), null, null);
672: ELSE
673: l_error_type := null;

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

687: -- SIREN, NIC, Type of Media, Address for CRE
688: IF l_cre_estab_name is not null THEN
689: IF l_cre_siren is null THEN
690: l_error_type := l_error;
691: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
692: 'VALUE1: '||l_name_comp, 'VALUE2: '||hr_general.decode_lookup
693: ('FR_DADS_RUBRICS','S10.G01.00.013.001'), null);
694: ELSE
695: l_error_type:= null;

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

706: ,p_message_text => l_value
707: ,p_usage => 'C');
708: IF l_cre_nic is null THEN
709: l_error_type := l_error;
710: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
711: 'VALUE1: '||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup
712: ('FR_DADS_RUBRICS','S10.G01.00.013.002'), null);
713: ELSE
714: l_error_type:= null;

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

725: ,p_message_text => l_value
726: ,p_usage => 'C');
727: IF l_cre_media is null THEN
728: l_error_type := l_error;
729: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
730: 'VALUE1: '||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup
731: ('FR_DADS_RUBRICS','S10.G01.00.014'), null);
732: ELSE
733: l_error_type:= null;

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

744: ,p_message_text => l_value
745: ,p_usage => 'C');
746: IF l_address_to_use is null AND l_cre_media = '03' THEN
747: l_error_type := l_error;
748: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
749: 'VALUE1: '||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup
750: ('FR_DADS_RUBRICS','S10.G01.00.015'), null);
751: ELSIF l_cre_media = '05' AND l_address_to_use is not null THEN
752: l_error_type := l_error;

Line 753: l_value := pay_fr_general.get_payroll_message('PAY_75184_CRE_DATA',

749: 'VALUE1: '||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup
750: ('FR_DADS_RUBRICS','S10.G01.00.015'), null);
751: ELSIF l_cre_media = '05' AND l_address_to_use is not null THEN
752: l_error_type := l_error;
753: l_value := pay_fr_general.get_payroll_message('PAY_75184_CRE_DATA',
754: null, null, null);
755: ELSE
756: l_error_type:= null;
757: l_value :=null;

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

826: l_address_to_use := issue_person_rec.address_g01;
827: -- Name of person answering queries
828: IF l_person is null THEN
829: l_error_type := l_error;
830: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
831: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup
832: ('FR_DADS_RUBRICS','S10.G01.01.001.M'), null);
833: ELSIF (substr(l_person, 1,2) = 'M.' OR substr(l_person, 1,2) = 'M '
834: OR substr(l_person, 1,2) = 'MR' OR substr(l_person, 1,2) = 'Mr'

Line 838: l_value := pay_fr_general.get_payroll_message('PAY_75176_NO_TITLE',

834: OR substr(l_person, 1,2) = 'MR' OR substr(l_person, 1,2) = 'Mr'
835: OR substr(l_person, 1,3) = 'MME' OR substr(l_person, 1,3) = 'Mme'
836: OR substr(l_person, 1,3) = 'MLE' OR substr(l_person, 1,3) = 'Mle') THEN
837: l_error_type := l_warning;
838: l_value := pay_fr_general.get_payroll_message('PAY_75176_NO_TITLE',
839: null, null, null);
840: ELSE
841: l_error_type := null;
842: l_value := null;

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

854: --
855: -- Domain Code
856: IF l_domain_code is null THEN
857: l_error_type := l_error;
858: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
859: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup
860: ('FR_DADS_RUBRICS','S10.G01.01.002.M'), null);
861: ELSE
862: l_error_type := null;

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

875: --
876: -- Type of Media to use for Enquiries
877: IF l_media_type is null THEN
878: l_error_type := l_error;
879: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
880: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup
881: ('FR_DADS_RUBRICS','S10.G01.01.003.M'), null);
882: ELSE
883: l_error_type := null;

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

896: --
897: -- Address to use
898: IF l_address_to_use is null THEN
899: l_error_type := l_error;
900: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
901: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup
902: ('FR_DADS_RUBRICS','S10.G01.01.004.M'), null);
903: ELSE
904: l_error_type := null;

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

1173: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');
1174: -- SIREN Number
1175: IF l_siren_comp is null THEN
1176: l_error_type := l_error;
1177: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1178: 'VALUE1:'||l_name_comp, 'VALUE2: '||hr_general.decode_lookup
1179: ('FR_DADS_RUBRICS','S20.G01.00.001'), null);
1180: ELSE
1181: l_error_type := null;

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

1192: ,p_usage => 'M');
1193: -- Name of Company
1194: IF l_name_comp is null THEN
1195: l_error_type := l_error;
1196: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
1197: 'VALUE1:'||hr_general.decode_lookup
1198: ('FR_DADS_RUBRICS','S20.G01.00.002'), null, null);
1199: ELSE
1200: l_error_type := null;

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

1211: ,p_usage => 'M');
1212: -- Calendar Year
1213: IF l_cal_year is null THEN
1214: l_error_type := l_error;
1215: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
1216: 'VALUE1:'||hr_general.decode_lookup
1217: ('FR_DADS_RUBRICS','S20.G01.00.003'), null, null);
1218: ELSE
1219: l_error_type := null;

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

1234: -- removing the exception validation
1235: -- Declaration Nature Code
1236: /*IF l_decl_nature_code is null THEN
1237: l_error_type := l_error;
1238: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
1239: 'VALUE1:'||hr_general.decode_lookup
1240: ('FR_DADS_RUBRICS','S20.G01.00.004.001'), null, null);
1241: ELSE
1242: l_error_type := null;

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

1254:
1255: -- Declaration Type Code
1256: /*IF l_decl_type_code is null THEN
1257: l_error_type := l_error;
1258: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
1259: 'VALUE1:'||hr_general.decode_lookup
1260: ('FR_DADS_RUBRICS','S20.G01.00.004.002'), null, null);
1261: ELSIF (l_decl_nature_code = '02' OR l_decl_nature_code = '01') AND
1262: l_decl_type_code = '55' THEN

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

1260: ('FR_DADS_RUBRICS','S20.G01.00.004.002'), null, null);
1261: ELSIF (l_decl_nature_code = '02' OR l_decl_nature_code = '01') AND
1262: l_decl_type_code = '55' THEN
1263: l_error_type := l_error;
1264: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',
1265: 'VALUE1:'||hr_general.decode_lookup
1266: ('FR_DADS_RUBRICS','S20.G01.00.004.001'),
1267: 'VALUE2:'||hr_general.decode_lookup
1268: ('FR_DADS_RUBRICS','S20.G01.00.004.002'), null);

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

1267: 'VALUE2:'||hr_general.decode_lookup
1268: ('FR_DADS_RUBRICS','S20.G01.00.004.002'), null);
1269: ELSIF l_decl_nature_code = '05' AND l_decl_type_code <> '55' THEN
1270: l_error_type := l_error;
1271: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',
1272: 'VALUE1:'||hr_general.decode_lookup
1273: ('FR_DADS_RUBRICS','S20.G01.00.004.001'),
1274: 'VALUE2:'||hr_general.decode_lookup
1275: ('FR_DADS_RUBRICS','S20.G01.00.004.002'), null);

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

1293:
1294: -- Partition Number
1295: IF l_partition_number is null THEN
1296: l_error_type := l_error;
1297: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
1298: 'VALUE1:'||hr_general.decode_lookup
1299: ('FR_DADS_RUBRICS','S20.G01.00.005'), null, null);
1300: ELSE
1301: l_error_type := null;

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

1315: -- Calendar Year to which salaries are attached
1316: IF (l_cal_year_sal is null AND
1317: (l_decl_type_code = 52 OR l_decl_type_code = 53)) THEN
1318: l_error_type := l_error;
1319: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
1320: 'VALUE1:'||hr_general.decode_lookup
1321: ('FR_DADS_RUBRICS','S20.G01.00.003'), null, null);
1322: ELSIF ((l_decl_type_code <> 52 AND l_decl_type_code <> 53) AND
1323: l_cal_year_sal is not null) THEN

Line 1325: l_value := pay_fr_general.get_payroll_message('PAY_75183_RBR_SUPP',

1321: ('FR_DADS_RUBRICS','S20.G01.00.003'), null, null);
1322: ELSIF ((l_decl_type_code <> 52 AND l_decl_type_code <> 53) AND
1323: l_cal_year_sal is not null) THEN
1324: l_error_type := l_error;
1325: l_value := pay_fr_general.get_payroll_message('PAY_75183_RBR_SUPP',
1326: null, null, null);
1327: ELSE
1328: l_error_type := null;
1329: l_value := null;

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

1343:
1344: -- Currency Type
1345: IF l_currency_type is null THEN
1346: l_error_type := l_error;
1347: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
1348: 'VALUE1:'||hr_general.decode_lookup
1349: ('FR_DADS_RUBRICS','S20.G01.00.007'), null, null);
1350: ELSE
1351: l_error_type := null;

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

1362: ,p_usage => 'M');
1363: -- NIC of Headquarters Establishment
1364: IF l_hq_estab_id is null THEN
1365: l_error_type := l_error;
1366: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1367: 'VALUE1:'||l_name_comp, 'VALUE2: '||hr_general.decode_lookup
1368: ('FR_DADS_RUBRICS','S20.G01.00.008.M'), null);
1369: ELSIF l_NIC_HQ_estab is null THEN
1370: l_error_type := l_error;

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

1367: 'VALUE1:'||l_name_comp, 'VALUE2: '||hr_general.decode_lookup
1368: ('FR_DADS_RUBRICS','S20.G01.00.008.M'), null);
1369: ELSIF l_NIC_HQ_estab is null THEN
1370: l_error_type := l_error;
1371: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1372: 'VALUE1:'||l_name_estab, 'VALUE2: '||hr_general.decode_lookup
1373: ('FR_DADS_RUBRICS','S20.G01.00.008'), null);
1374: ELSE
1375: l_error_type:=NULL;

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

1386: ,p_extra_information => l_name_estab -- to store name of hq estab
1387: ,p_usage => 'M');
1388: IF l_location is null THEN
1389: l_error_type := l_error;
1390: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1391: 'VALUE1:'||l_name_estab, 'VALUE2: '||hr_general.decode_lookup
1392: ('FR_DADS_RUBRICS','S20.G01.00.009.006.M'), null);
1393: archive_data(
1394: p_payroll_action_id => p_payroll_action_id

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

1436: ,p_usage => 'O');
1437: -- Nature and Name of the Street
1438: IF l_hq_addr_nn_street is null THEN
1439: l_error_type := l_error;
1440: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1441: 'VALUE1:'||l_location_name, 'VALUE2: '||hr_general.decode_lookup
1442: ('FR_DADS_RUBRICS','S20.G01.00.009.006'), null);
1443: ELSE
1444: l_error_type := null;

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

1467: ,p_usage => 'O');
1468: -- Name of the Town
1469: IF upper(l_hq_addr_town) = upper(l_hq_addr_town_city) THEN
1470: l_error_type := l_error;
1471: l_value := pay_fr_general.get_payroll_message('PAY_75179_TWN_CITY',
1472: null, null, null);
1473: ELSE
1474: l_error_type := null;
1475: l_value := null;

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

1485: ,p_usage => 'C');
1486: -- Zip Code
1487: IF l_hq_addr_zip_code is null THEN
1488: l_error_type := l_error;
1489: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1490: 'VALUE1:'||l_location_name, 'VALUE2: '||hr_general.decode_lookup
1491: ('FR_DADS_RUBRICS','S20.G01.00.009.010'), null);
1492: ELSE
1493: l_error_type := null;

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

1504: ,p_usage => 'M');
1505: -- City
1506: IF l_hq_addr_town_city <> upper(l_hq_addr_town_city) THEN
1507: l_error_type := l_error;
1508: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',
1509: null, null, null);
1510: ELSIF l_hq_addr_town_city is null THEN
1511: l_error_type := l_error;
1512: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

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

1508: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',
1509: null, null, null);
1510: ELSIF l_hq_addr_town_city is null THEN
1511: l_error_type := l_error;
1512: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1513: 'VALUE1:'||l_location_name, 'VALUE2: '||hr_general.decode_lookup
1514: ('FR_DADS_RUBRICS','S20.G01.00.009.012'), null);
1515: ELSE
1516: l_error_type := null;

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

1529: /* Afnor Codes
1530: -- Country Code
1531: IF l_hq_addr_country_code = 'FR' THEN
1532: l_error_type := l_error;
1533: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
1534: 'VALUE1: '||hr_general.decode_lookup
1535: ('FR_DADS_RUBRICS','S20.G01.00.009.013'), null, null);
1536: ELSE
1537: l_error_type := null;

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

1549:
1550: -- Country Name
1551: IF l_hq_addr_country_name is not null and l_hq_addr_country_name = 'FR' THEN
1552: l_error_type := l_error;
1553: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
1554: 'VALUE1: '||hr_general.decode_lookup
1555: ('FR_DADS_RUBRICS','S20.G01.00.009.014'), null, null);
1556: ELSIF l_hq_addr_country_name is null AND
1557: (l_hq_addr_country_code is not null AND l_hq_addr_country_code

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

1556: ELSIF l_hq_addr_country_name is null AND
1557: (l_hq_addr_country_code is not null AND l_hq_addr_country_code
1558: <> 'FR') THEN
1559: l_error_type := l_error;
1560: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
1561: 'VALUE1: '||hr_general.decode_lookup
1562: ('FR_DADS_RUBRICS','S20.G01.00.009.014'), null, null);
1563: ELSE
1564: l_error_type := null;

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

1576: end if;-- check for location
1577: -- SIRET of Fiscal Establishment
1578: IF l_name_fisc_estab is null THEN
1579: l_error_type := l_error;
1580: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1581: 'VALUE1:'||l_name_comp, 'VALUE2: '||hr_general.decode_lookup
1582: ('FR_DADS_RUBRICS','S20.G01.00.010.M'), null);
1583: archive_data(
1584: p_payroll_action_id => p_payroll_action_id

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

1593: ELSE
1594: -- NIC of the Fiscal Establishment
1595: IF l_fisc_estab_id <> l_hq_estab_id and l_NIC_fisc_estab is null THEN
1596: l_error_type := l_error;
1597: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1598: 'VALUE1:'||l_name_fisc_estab, 'VALUE2: '||hr_general.decode_lookup
1599: ('FR_DADS_RUBRICS','S20.G01.00.010'), null);
1600: elsif l_fisc_estab_id = l_hq_estab_id and l_NIC_fisc_estab is not null THEN
1601: l_error_type := l_error;

Line 1602: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',

1598: 'VALUE1:'||l_name_fisc_estab, 'VALUE2: '||hr_general.decode_lookup
1599: ('FR_DADS_RUBRICS','S20.G01.00.010'), null);
1600: elsif l_fisc_estab_id = l_hq_estab_id and l_NIC_fisc_estab is not null THEN
1601: l_error_type := l_error;
1602: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',
1603: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
1604: 'S20.G01.00.010'), null, null);
1605: ELSE
1606: l_error_type := null;

Line 1622: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',

1618:
1619: --Fiscal Establishment Name
1620: IF l_fisc_estab_id = l_hq_estab_id AND l_name_fisc_estab is not null THEN
1621: l_error_type := l_error;
1622: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',
1623: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
1624: 'S20.G01.00.011'), null, null);
1625: ELSE
1626: l_error_type := null;

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

1638:
1639: -- Location
1640: IF l_fisc_location is null THEN
1641: l_error_type := l_error;
1642: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1643: 'VALUE1:'||l_name_fisc_estab, 'VALUE2: '||hr_general.decode_lookup
1644: ('FR_DADS_RUBRICS','S20.G01.00.012.006.M'), null);
1645: archive_data(
1646: p_payroll_action_id => p_payroll_action_id

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

1690:
1691: -- Nature and name of the street
1692: IF l_fisc_estab_id <> l_hq_estab_id AND l_fisc_addr_nn_street is null THEN
1693: l_error_type := l_error;
1694: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1695: 'VALUE1:'||l_fisc_location_name, 'VALUE2: '||hr_general.decode_lookup
1696: ('FR_DADS_RUBRICS','S20.G01.00.012.006'), null);
1697: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_nn_street is not null THEN
1698: l_error_type := l_error;

Line 1699: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',

1695: 'VALUE1:'||l_fisc_location_name, 'VALUE2: '||hr_general.decode_lookup
1696: ('FR_DADS_RUBRICS','S20.G01.00.012.006'), null);
1697: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_nn_street is not null THEN
1698: l_error_type := l_error;
1699: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',
1700: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
1701: 'S20.G01.00.012.006'), null, null);
1702: ELSE
1703: l_error_type := null;

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

1728:
1729: -- Name of the Town
1730: IF l_fisc_estab_id <> l_hq_estab_id AND upper(l_fisc_addr_town) = upper(l_fisc_addr_town_city) THEN
1731: l_error_type := l_error;
1732: l_value := pay_fr_general.get_payroll_message('PAY_75179_TWN_CITY',
1733: null, null, null);
1734: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_town is not null THEN
1735: l_error_type := l_error;
1736: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',

Line 1736: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',

1732: l_value := pay_fr_general.get_payroll_message('PAY_75179_TWN_CITY',
1733: null, null, null);
1734: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_town is not null THEN
1735: l_error_type := l_error;
1736: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',
1737: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
1738: 'S20.G01.00.012.009'), null, null);
1739: ELSE
1740: l_error_type := null;

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

1752:
1753: --Zip Code
1754: IF l_fisc_estab_id <> l_hq_estab_id AND l_fisc_addr_zip_code is null THEN
1755: l_error_type := l_error;
1756: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1757: 'VALUE1:'||l_fisc_location_name, 'VALUE2: '||hr_general.decode_lookup
1758: ('FR_DADS_RUBRICS','S20.G01.00.012.010'), null);
1759: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_zip_code is not null THEN
1760: l_error_type := l_error;

Line 1761: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',

1757: 'VALUE1:'||l_fisc_location_name, 'VALUE2: '||hr_general.decode_lookup
1758: ('FR_DADS_RUBRICS','S20.G01.00.012.010'), null);
1759: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_zip_code is not null THEN
1760: l_error_type := l_error;
1761: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',
1762: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
1763: 'S20.G01.00.012.010'), null, null);
1764: ELSE
1765: l_error_type := null;

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

1777:
1778: --City
1779: IF l_fisc_estab_id <> l_hq_estab_id AND l_fisc_addr_town is null THEN
1780: l_error_type := l_error;
1781: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1782: 'VALUE1:'||l_fisc_location_name, 'VALUE2: '||hr_general.decode_lookup
1783: ('FR_DADS_RUBRICS','S20.G01.00.012.012'), null);
1784: ELSIF l_fisc_estab_id <> l_hq_estab_id AND l_fisc_addr_town_city <> upper(l_fisc_addr_town_city) THEN
1785: l_error_type := l_error;

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

1782: 'VALUE1:'||l_fisc_location_name, 'VALUE2: '||hr_general.decode_lookup
1783: ('FR_DADS_RUBRICS','S20.G01.00.012.012'), null);
1784: ELSIF l_fisc_estab_id <> l_hq_estab_id AND l_fisc_addr_town_city <> upper(l_fisc_addr_town_city) THEN
1785: l_error_type := l_error;
1786: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',
1787: null, null, null);
1788: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_town_city is not null THEN
1789: l_error_type := l_error;
1790: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',

Line 1790: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',

1786: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',
1787: null, null, null);
1788: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_town_city is not null THEN
1789: l_error_type := l_error;
1790: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',
1791: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
1792: 'S20.G01.00.012.012'), null, null);
1793: ELSE
1794: l_error_type := null;

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

1807: -- Country Code
1808:
1809: IF l_fisc_estab_id <> l_hq_estab_id AND l_fisc_addr_country_code = 'FR' THEN
1810: l_error_type := l_error;
1811: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
1812: 'VALUE1: '||hr_general.decode_lookup
1813: ('FR_DADS_RUBRICS','S20.G01.00.012.013'), null, null);
1814: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_country_code is not null THEN
1815: l_error_type := l_error;

Line 1816: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',

1812: 'VALUE1: '||hr_general.decode_lookup
1813: ('FR_DADS_RUBRICS','S20.G01.00.012.013'), null, null);
1814: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_country_code is not null THEN
1815: l_error_type := l_error;
1816: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',
1817: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
1818: 'S20.G01.00.012.013'), null, null);
1819: ELSE
1820: l_error_type := null;

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

1833: -- Country Name
1834: IF l_fisc_estab_id <> l_hq_estab_id AND l_fisc_addr_country_name is not null
1835: AND l_fisc_addr_country_code = 'FR' THEN
1836: l_error_type := l_error;
1837: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
1838: 'VALUE1: '||hr_general.decode_lookup
1839: ('FR_DADS_RUBRICS','S20.G01.00.012.014'), null, null);
1840: ELSIF l_fisc_estab_id <> l_hq_estab_id AND l_fisc_addr_country_name is null AND
1841: (l_fisc_addr_country_code is not null AND l_fisc_addr_country_code

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

1840: ELSIF l_fisc_estab_id <> l_hq_estab_id AND l_fisc_addr_country_name is null AND
1841: (l_fisc_addr_country_code is not null AND l_fisc_addr_country_code
1842: <> 'FR') THEN
1843: l_error_type := l_error;
1844: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
1845: 'VALUE1: '||hr_general.decode_lookup
1846: ('FR_DADS_RUBRICS','S20.G01.00.012.014'), null, null);
1847: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_country_name is not null THEN
1848: l_error_type := l_error;

Line 1849: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',

1845: 'VALUE1: '||hr_general.decode_lookup
1846: ('FR_DADS_RUBRICS','S20.G01.00.012.014'), null, null);
1847: ELSIF l_fisc_estab_id = l_hq_estab_id AND l_fisc_addr_country_name is not null THEN
1848: l_error_type := l_error;
1849: l_value := pay_fr_general.get_payroll_message('PAY_75185_COUN_EST',
1850: 'VALUE1: '||hr_general.decode_lookup
1851: ('FR_DADS_RUBRICS','S20.G01.00.012.014'), null, null);
1852: ELSE
1853: l_error_type := null;

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

1868: -- SIREN, NIC, Type of Media, Address for CRE
1869: IF l_cre_estab_id is not null and l_cre_estab_id <> g_cre_info_issue.cre_estab_id THEN
1870: IF l_cre_siren is NULL then
1871: l_error_type:= l_error;
1872: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1873: 'VALUE1:'||l_name_comp, 'VALUE2: '||hr_general.decode_lookup
1874: ('FR_DADS_RUBRICS','S20.G01.00.014.001'), null);
1875: else
1876: l_error_type:=NULL;

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

1887: ,p_usage => 'C');
1888:
1889: IF l_cre_nic is null THEN
1890: l_error_type := l_error;
1891: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1892: 'VALUE1:'||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup
1893: ('FR_DADS_RUBRICS','S20.G01.00.014.002'), null);
1894: else
1895: l_error_type:=NULL;

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

1906: ,p_usage => 'C');
1907:
1908: IF l_cre_media is null THEN
1909: l_error_type := l_error;
1910: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1911: 'VALUE1:'||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup
1912: ('FR_DADS_RUBRICS','S20.G01.00.015'), null);
1913: else
1914: l_error_type := NULL;

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

1924: ,p_message_text => l_value
1925: ,p_usage => 'C');
1926: IF l_addr_to_use is null and l_cre_media='03' THEN
1927: l_error_type:= l_error;
1928: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
1929: 'VALUE1:'||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup
1930: ('FR_DADS_RUBRICS','S20.G01.00.016'), null);
1931: elsif l_cre_media ='05' and l_addr_to_use is NOT NULL then
1932: l_error_type := l_error;

Line 1933: l_value := pay_fr_general.get_payroll_message('PAY_75184_CRE_DATA',

1929: 'VALUE1:'||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup
1930: ('FR_DADS_RUBRICS','S20.G01.00.016'), null);
1931: elsif l_cre_media ='05' and l_addr_to_use is NOT NULL then
1932: l_error_type := l_error;
1933: l_value := pay_fr_general.get_payroll_message('PAY_75184_CRE_DATA',
1934: null, null, null);
1935: ELSE
1936: l_error_type := null;
1937: l_value := null;

Line 1953: l_value := pay_fr_general.get_payroll_message('PAY_75186_CRE_DET',

1949: AND l_addr_to_use is null THEN
1950: IF g_cre_info_issue.cre_siren is null AND g_cre_info_issue.cre_nic is null
1951: AND g_cre_info_issue.cre_media is null AND g_cre_info_issue.address_to_use is null THEN
1952: l_error_type := l_error;
1953: l_value := pay_fr_general.get_payroll_message('PAY_75186_CRE_DET',
1954: null, null, null);
1955: archive_data(
1956: p_payroll_action_id => p_payroll_action_id
1957: ,p_rubric_name => 'S20.G01.00.014.001'

Line 1969: l_value := pay_fr_general.get_payroll_message('PAY_75182_CRE_S10',

1965: ELSIF l_cre_siren is not null AND l_cre_nic is not null AND l_cre_media is not null
1966: AND l_addr_to_use is not null then
1967: IF l_cre_estab_id = g_cre_info_issue.cre_estab_id THEN
1968: l_error_type := l_error;
1969: l_value := pay_fr_general.get_payroll_message('PAY_75182_CRE_S10',
1970: null, null, null);
1971: archive_data(
1972: p_payroll_action_id => p_payroll_action_id
1973: ,p_rubric_name => 'S20.G01.00.014.001'

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

2010: ,p_usage => 'C');
2011: -- Test Periodicity Code
2012: IF l_periodicity_code_test is null THEN
2013: l_error_type := l_error;
2014: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2015: 'VALUE1:'||hr_general.decode_lookup
2016: ('FR_DADS_RUBRICS','S20.G01.00.018'), null, null);
2017: ELSE
2018: l_error_type := null;

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

2030: ,p_usage => 'M');
2031: -- Live Periodicity Code
2032: IF l_periodicity_code_live is null THEN
2033: l_error_type := l_error;
2034: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2035: 'VALUE1:'||hr_general.decode_lookup
2036: ('FR_DADS_RUBRICS','S20.G01.00.018'), null, null);
2037: ELSE
2038: l_error_type := null;

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

2206: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');
2207: -- SIREN Number
2208: IF l_estab_siren is null THEN
2209: l_error_type := l_error;
2210: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2211: 'VALUE1:'||l_name_comp, 'VALUE2:'||hr_general.decode_lookup
2212: ('FR_DADS_RUBRICS','S80.G01.00.001.001'), null);
2213: ELSE
2214: l_error_type := null;

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

2225: ,p_usage => 'M');
2226: --NIC of the Establishment
2227: IF l_estab_nic is null THEN
2228: l_error_type := l_error;
2229: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2230: 'VALUE1:'||l_estab_name, 'VALUE2:'||hr_general.decode_lookup
2231: ('FR_DADS_RUBRICS','S80.G01.00.001.002'), null);
2232: ELSE
2233: l_error_type := null;

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

2256: ,p_usage => 'C');
2257: --First Check Location
2258: IF l_estab_location is null THEN
2259: l_error_type := l_error;
2260: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2261: 'VALUE1:'||l_estab_name, 'VALUE2: '||hr_general.decode_lookup
2262: ('FR_DADS_RUBRICS','S80.G01.00.003.006.M'), null);
2263: archive_data(
2264: p_payroll_action_id => p_payroll_action_id

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

2306: ,p_usage => 'O');
2307: -- Nature and Name of the Street
2308: IF l_estab_addr_nn_street is null THEN
2309: l_error_type := l_error;
2310: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2311: 'VALUE1:'||l_location_name, 'VALUE2: '||hr_general.decode_lookup
2312: ('FR_DADS_RUBRICS','S80.G01.00.003.006'), null);
2313: ELSE
2314: l_error_type := null;

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

2337: ,p_usage => 'O');
2338: -- Name of the Town
2339: IF upper(l_estab_addr_town) = upper(l_estab_addr_town_city) THEN
2340: l_error_type := l_error;
2341: l_value := pay_fr_general.get_payroll_message('PAY_75179_TWN_CITY',
2342: null, null, null);
2343: ELSE
2344: l_error_type := null;
2345: l_value := null;

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

2355: ,p_usage => 'C');
2356: -- Zip Code
2357: IF l_estab_addr_zip_code is null THEN
2358: l_error_type := l_error;
2359: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2360: 'VALUE1:'||l_location_name, 'VALUE2: '||hr_general.decode_lookup
2361: ('FR_DADS_RUBRICS','S80.G01.00.003.010'), null);
2362: ELSE
2363: l_error_type := null;

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

2374: ,p_usage => 'M');
2375: -- City
2376: IF l_estab_addr_town_city <> upper(l_estab_addr_town_city) THEN
2377: l_error_type := l_error;
2378: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',
2379: null, null, null);
2380: ELSIF l_estab_addr_town_city is null THEN
2381: l_error_type := l_error;
2382: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

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

2378: l_value := pay_fr_general.get_payroll_message('PAY_75177_CITY_UPR',
2379: null, null, null);
2380: ELSIF l_estab_addr_town_city is null THEN
2381: l_error_type := l_error;
2382: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2383: 'VALUE1:'||l_location_name, 'VALUE2: '||hr_general.decode_lookup
2384: ('FR_DADS_RUBRICS','S80.G01.00.003.012'), null);
2385: ELSE
2386: l_error_type := null;

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

2398: /* Afnor Codes
2399: -- Country Code
2400: IF l_estab_addr_country_name = 'FR' THEN
2401: l_error_type := l_error;
2402: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
2403: 'VALUE1: '||hr_general.decode_lookup
2404: ('FR_DADS_RUBRICS','S80.G01.00.003.013'), null, null);
2405: ELSE
2406: l_error_type := null;

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

2417: ,p_usage =>); */
2418: -- Country Name
2419: IF l_estab_addr_country_name is not null and l_estab_addr_country_code = 'FR' THEN
2420: l_error_type := l_error;
2421: l_value := pay_fr_general.get_payroll_message('PAY_75175_COUN_FRN',
2422: 'VALUE1: '||hr_general.decode_lookup
2423: ('FR_DADS_RUBRICS','S80.G01.00.003.014'), null, null);
2424: ELSIF l_estab_addr_country_name is null AND l_estab_addr_country_code is not null
2425: AND l_estab_addr_country_code <> 'FR' THEN

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

2423: ('FR_DADS_RUBRICS','S80.G01.00.003.014'), null, null);
2424: ELSIF l_estab_addr_country_name is null AND l_estab_addr_country_code is not null
2425: AND l_estab_addr_country_code <> 'FR' THEN
2426: l_error_type := l_error;
2427: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2428: 'VALUE1:'||hr_general.decode_lookup
2429: ('FR_DADS_RUBRICS','S80.G01.00.003.014'), null, null);
2430: ELSE
2431: l_error_type := null;

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

2443: END IF; -- Checking Location
2444: -- Head Count
2445: IF l_estab_headcount_3112 is null then
2446: l_error_type := l_error;
2447: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2448: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
2449: 'S80.G01.00.004'), null, null);
2450: ELSE
2451: l_error_type := null;

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

2462: ,p_usage => 'M');
2463: -- Code Salary Tax
2464: IF l_estab_salary_tax_code is null then
2465: l_error_type := l_error;
2466: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',
2467: 'VALUE1: '||hr_general.decode_lookup ('FR_DADS_RUBRICS',
2468: 'S80.G01.00.005'), null, null);
2469: ELSIF l_estab_salary_tax_code <> '01' AND l_estab_salary_tax_code <> '02'
2470: AND l_estab_salary_tax_code is not null THEN

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

2468: 'S80.G01.00.005'), null, null);
2469: ELSIF l_estab_salary_tax_code <> '01' AND l_estab_salary_tax_code <> '02'
2470: AND l_estab_salary_tax_code is not null THEN
2471: l_error_type := l_error;
2472: l_value := pay_fr_general.get_payroll_message('PAY_75192_VALID_VAL',
2473: 'VALUE1: '||l_estab_name, 'VALUE2:'||hr_general.decode_lookup ('FR_DADS_RUBRICS',
2474: 'S80.G01.00.005.M'), null);
2475: ELSE
2476: l_error_type := null;