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 HR_GENERAL

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

22: --
23: BEGIN
24: --
25: IF p_lookup_type is not null THEN
26: l_user_value := hr_general.decode_lookup(p_lookup_type,p_file_value);
27: END IF;
28: --
29: pay_action_information_api.create_action_information (
30: p_action_information_id => l_action_info_id

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

249: p_cre_org_name => l_cre_estab_name,
250: p_report_code => 'S10_CRE_ESTAB_NAME');
251: END IF;
252: -- Getting the error messages
253: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
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;

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

250: p_report_code => 'S10_CRE_ESTAB_NAME');
251: END IF;
252: -- Getting the error messages
253: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
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',

Line 259: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup

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;
263: l_value := null;

Line 280: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup

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;
284: l_value := null;

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

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;
305: l_value := null;

Line 321: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup

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(
325: p_payroll_action_id => p_payroll_action_id

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

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;
377: l_value := null;

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

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;
434: l_value := null;

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

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;
459: l_value := null;

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

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;
481: l_value := null;

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

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

Line 504: '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;
508: l_value := null;

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

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;
530: l_value := null;

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

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;
590: l_value := null;

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

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;
611: l_value := null;

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

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;
632: l_value := null;

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

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;
653: l_value := null;

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

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;
674: l_value := null;

Line 692: 'VALUE1: '||l_name_comp, 'VALUE2: '||hr_general.decode_lookup

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;
696: l_value:=null;

Line 711: 'VALUE1: '||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup

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;
715: l_value:=null;

Line 730: 'VALUE1: '||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup

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;
734: l_value:=null;

Line 749: 'VALUE1: '||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup

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

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

812: /* End of Initialising the local variables */
813:
814: --
815: -- Getting the error messages
816: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
817: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');
818: --
819: -- Loop through 3 times as it is a multi-record EIT
820: FOR issue_person_rec in csr_get_S10_G01 LOOP

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

813:
814: --
815: -- Getting the error messages
816: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
817: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');
818: --
819: -- Loop through 3 times as it is a multi-record EIT
820: FOR issue_person_rec in csr_get_S10_G01 LOOP
821: l_count := l_count+1;

Line 831: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup

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'
835: OR substr(l_person, 1,3) = 'MME' OR substr(l_person, 1,3) = 'Mme'

Line 859: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup

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;
863: l_value := null;

Line 880: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup

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;
884: l_value := null;

Line 901: 'VALUE1:'||l_name, 'VALUE2: '||hr_general.decode_lookup

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;
905: l_value := null;

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

1168: ELSE
1169: l_periodicity_code_live :='EVE';
1170: END IF;
1171: -- Getting the error messages
1172: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
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;

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

1169: l_periodicity_code_live :='EVE';
1170: END IF;
1171: -- Getting the error messages
1172: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
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',

Line 1178: 'VALUE1:'||l_name_comp, 'VALUE2: '||hr_general.decode_lookup

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;
1182: l_value := null;

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

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;
1201: l_value := null;

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

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;
1220: l_value := null;

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

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;
1243: l_value := null;

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

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
1263: l_error_type := l_error;

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

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);
1269: ELSIF l_decl_nature_code = '05' AND l_decl_type_code <> '55' THEN

Line 1267: 'VALUE2:'||hr_general.decode_lookup

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);
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',

Line 1272: 'VALUE1:'||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);
1276: ELSE

Line 1274: 'VALUE2:'||hr_general.decode_lookup

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);
1276: ELSE
1277: l_error_type := null;
1278: l_value := null;

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

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;
1302: l_value := null;

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

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
1324: l_error_type := l_error;

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

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;
1352: l_value := null;

Line 1367: 'VALUE1:'||l_name_comp, 'VALUE2: '||hr_general.decode_lookup

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

Line 1372: 'VALUE1:'||l_name_estab, '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;
1376: l_value:=NULL;

Line 1391: 'VALUE1:'||l_name_estab, 'VALUE2: '||hr_general.decode_lookup

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
1395: ,p_rubric_name => 'S20.G01.00.009.006'

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

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;
1445: l_value := null;

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

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;
1494: l_value := null;

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

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;
1517: l_value := null;

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

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;
1538: l_value := null;

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

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
1558: <> 'FR') THEN

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

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;
1565: l_value := null;

Line 1581: 'VALUE1:'||l_name_comp, 'VALUE2: '||hr_general.decode_lookup

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
1585: ,p_rubric_name => 'S20.G01.00.010'

Line 1598: 'VALUE1:'||l_name_fisc_estab, 'VALUE2: '||hr_general.decode_lookup

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

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

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;
1607: l_value := null;

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

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;
1627: l_value := null;

Line 1643: 'VALUE1:'||l_name_fisc_estab, 'VALUE2: '||hr_general.decode_lookup

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
1647: ,p_rubric_name => 'S20.G01.00.012.006'

Line 1695: 'VALUE1:'||l_fisc_location_name, 'VALUE2: '||hr_general.decode_lookup

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

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

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;
1704: l_value := null;

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

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;
1741: l_value := null;

Line 1757: 'VALUE1:'||l_fisc_location_name, 'VALUE2: '||hr_general.decode_lookup

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

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

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;
1766: l_value := null;

Line 1782: 'VALUE1:'||l_fisc_location_name, 'VALUE2: '||hr_general.decode_lookup

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

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

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;
1795: l_value := null;

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

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

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

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;
1821: l_value := null;

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

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
1842: <> 'FR') THEN

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

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

Line 1850: '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;
1854: l_value := null;

Line 1873: 'VALUE1:'||l_name_comp, 'VALUE2: '||hr_general.decode_lookup

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;
1877: l_value :=NULL;

Line 1892: 'VALUE1:'||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup

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;
1896: l_value :=NULL;

Line 1911: 'VALUE1:'||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup

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;
1915: l_value :=NULL;

Line 1929: 'VALUE1:'||l_cre_estab_name, 'VALUE2: '||hr_general.decode_lookup

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

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

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;
2019: l_value := null;

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

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;
2039: l_value := null;

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

2201: END IF;
2202: END LOOP;
2203: -- Validation for S80
2204: -- Getting the error messages
2205: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
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;

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

2202: END LOOP;
2203: -- Validation for S80
2204: -- Getting the error messages
2205: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
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',

Line 2211: 'VALUE1:'||l_name_comp, 'VALUE2:'||hr_general.decode_lookup

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;
2215: l_value := null;

Line 2230: 'VALUE1:'||l_estab_name, 'VALUE2:'||hr_general.decode_lookup

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;
2234: l_value := null;

Line 2261: 'VALUE1:'||l_estab_name, 'VALUE2: '||hr_general.decode_lookup

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
2265: ,p_rubric_name => 'S80.G01.00.003.006'

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

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;
2315: l_value := null;

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

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;
2364: l_value := null;

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

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;
2387: l_value := null;

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

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;
2407: l_value := null;

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

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
2426: l_error_type := l_error;

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

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;
2432: l_value := null;

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

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;
2452: l_value := null;

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

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
2471: l_error_type := l_error;

Line 2473: 'VALUE1: '||l_estab_name, 'VALUE2:'||hr_general.decode_lookup ('FR_DADS_RUBRICS',

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;
2477: l_value := null;