DBA Data[Home] [Help]

APPS.BEN_BPR_BUS dependencies on FND_MESSAGE

Line 131: fnd_message.set_name('BEN','BEN_91714_MUT_EXLSV_MN_VAL_FLG');

127: p_mn_rlovr_val is not null) then
128: --
129: -- OK fields are not mutaully exclusive so raise an error
130: --
131: fnd_message.set_name('BEN','BEN_91714_MUT_EXLSV_MN_VAL_FLG');
132: fnd_message.raise_error;
133: --
134: end if;
135: --

Line 132: fnd_message.raise_error;

128: --
129: -- OK fields are not mutaully exclusive so raise an error
130: --
131: fnd_message.set_name('BEN','BEN_91714_MUT_EXLSV_MN_VAL_FLG');
132: fnd_message.raise_error;
133: --
134: end if;
135: --
136: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 192: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');

188: p_mx_rlovr_val is not null) then
189: --
190: -- OK fields are not mutaully exclusive so raise an error
191: --
192: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
193: fnd_message.raise_error;
194: --
195: end if;
196: --

Line 193: fnd_message.raise_error;

189: --
190: -- OK fields are not mutaully exclusive so raise an error
191: --
192: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
193: fnd_message.raise_error;
194: --
195: end if;
196: --
197: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 253: fnd_message.set_name('BEN','BEN_91716_MUT_EXLSV_MN_PCT_FLG');

249: p_mn_rlovr_pct_num is not null) then
250: --
251: -- OK fields are not mutaully exclusive so raise an error
252: --
253: fnd_message.set_name('BEN','BEN_91716_MUT_EXLSV_MN_PCT_FLG');
254: fnd_message.raise_error;
255: --
256: end if;
257: --

Line 254: fnd_message.raise_error;

250: --
251: -- OK fields are not mutaully exclusive so raise an error
252: --
253: fnd_message.set_name('BEN','BEN_91716_MUT_EXLSV_MN_PCT_FLG');
254: fnd_message.raise_error;
255: --
256: end if;
257: --
258: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 314: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSV_MX_PCT_FLG');

310: p_mx_rlovr_pct_num is not null) then
311: --
312: -- OK fields are not mutaully exclusive so raise an error
313: --
314: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSV_MX_PCT_FLG');
315: fnd_message.raise_error;
316: --
317: end if;
318: --

Line 315: fnd_message.raise_error;

311: --
312: -- OK fields are not mutaully exclusive so raise an error
313: --
314: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSV_MX_PCT_FLG');
315: fnd_message.raise_error;
316: --
317: end if;
318: --
319: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 381: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');

377: or not l_api_updating) then
378: --
379: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
380: --
381: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
382: fnd_message.raise_error;
383: --
384: end if;
385: --

Line 382: fnd_message.raise_error;

378: --
379: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
380: --
381: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
382: fnd_message.raise_error;
383: --
384: end if;
385: --
386: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then

Line 388: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');

384: end if;
385: --
386: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
387: --
388: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
389: fnd_message.raise_error;
390: --
391: end if;
392: --

Line 389: fnd_message.raise_error;

385: --
386: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
387: --
388: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
389: fnd_message.raise_error;
390: --
391: end if;
392: --
393: end if;

Line 457: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');

453: or not l_api_updating) then
454: --
455: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
456: --
457: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
458: fnd_message.raise_error;
459: --
460: end if;
461: --

Line 458: fnd_message.raise_error;

454: --
455: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
456: --
457: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
458: fnd_message.raise_error;
459: --
460: end if;
461: --
462: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then

Line 464: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');

460: end if;
461: --
462: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
463: --
464: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
465: fnd_message.raise_error;
466: --
467: end if;
468: --

Line 465: fnd_message.raise_error;

461: --
462: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
463: --
464: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
465: fnd_message.raise_error;
466: --
467: end if;
468: --
469: end if;

Line 533: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

529: p_effective_date => p_effective_date) then
530: --
531: -- raise error as does not exist as lookup
532: --
533: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
534: fnd_message.set_token('FIELD','p_pct_rndg_cd');
535: fnd_message.set_token('TYPE','BEN_RNDG');
536: fnd_message.raise_error;
537: --

Line 534: fnd_message.set_token('FIELD','p_pct_rndg_cd');

530: --
531: -- raise error as does not exist as lookup
532: --
533: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
534: fnd_message.set_token('FIELD','p_pct_rndg_cd');
535: fnd_message.set_token('TYPE','BEN_RNDG');
536: fnd_message.raise_error;
537: --
538: end if;

Line 535: fnd_message.set_token('TYPE','BEN_RNDG');

531: -- raise error as does not exist as lookup
532: --
533: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
534: fnd_message.set_token('FIELD','p_pct_rndg_cd');
535: fnd_message.set_token('TYPE','BEN_RNDG');
536: fnd_message.raise_error;
537: --
538: end if;
539: --

Line 536: fnd_message.raise_error;

532: --
533: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
534: fnd_message.set_token('FIELD','p_pct_rndg_cd');
535: fnd_message.set_token('TYPE','BEN_RNDG');
536: fnd_message.raise_error;
537: --
538: end if;
539: --
540: end if;

Line 626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

622: close c1;
623: --
624: -- raise error
625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --

Line 627: fnd_message.set_token('ID',p_val_rndg_rl);

623: --
624: -- raise error
625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --
631: end if;

Line 628: fnd_message.set_token('TYPE_ID',-169);

624: -- raise error
625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --
631: end if;
632: --

Line 629: fnd_message.raise_error;

625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --
631: end if;
632: --
633: close c1;

Line 699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

695: p_effective_date => p_effective_date) then
696: --
697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --

Line 700: fnd_message.set_token('FIELD','p_val_rndg_cd');

696: --
697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --
704: end if;

Line 701: fnd_message.set_token('TYPE','BEN_RNDG');

697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --
704: end if;
705: --

Line 702: fnd_message.raise_error;

698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --
704: end if;
705: --
706: end if;

Line 770: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

766: p_effective_date => p_effective_date) then
767: --
768: -- raise error as does not exist as lookup
769: --
770: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
771: fnd_message.raise_error;
772: --
773: end if;
774: --

Line 771: fnd_message.raise_error;

767: --
768: -- raise error as does not exist as lookup
769: --
770: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
771: fnd_message.raise_error;
772: --
773: end if;
774: --
775: end if;

Line 861: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

857: close c1;
858: --
859: -- raise error
860: --
861: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
862: fnd_message.set_token('ID',p_rlovr_val_rl);
863: fnd_message.set_token('TYPE_ID',-532);
864: fnd_message.raise_error;
865: --

Line 862: fnd_message.set_token('ID',p_rlovr_val_rl);

858: --
859: -- raise error
860: --
861: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
862: fnd_message.set_token('ID',p_rlovr_val_rl);
863: fnd_message.set_token('TYPE_ID',-532);
864: fnd_message.raise_error;
865: --
866: end if;

Line 863: fnd_message.set_token('TYPE_ID',-532);

859: -- raise error
860: --
861: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
862: fnd_message.set_token('ID',p_rlovr_val_rl);
863: fnd_message.set_token('TYPE_ID',-532);
864: fnd_message.raise_error;
865: --
866: end if;
867: --

Line 864: fnd_message.raise_error;

860: --
861: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
862: fnd_message.set_token('ID',p_rlovr_val_rl);
863: fnd_message.set_token('TYPE_ID',-532);
864: fnd_message.raise_error;
865: --
866: end if;
867: --
868: close c1;

Line 935: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

931: p_effective_date => p_effective_date) then
932: --
933: -- raise error as does not exist as lookup
934: --
935: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
936: fnd_message.raise_error;
937: --
938: end if;
939: --

Line 936: fnd_message.raise_error;

932: --
933: -- raise error as does not exist as lookup
934: --
935: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
936: fnd_message.raise_error;
937: --
938: end if;
939: --
940: end if;

Line 1004: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

1000: p_effective_date => p_effective_date) then
1001: --
1002: -- raise error as does not exist as lookup
1003: --
1004: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1005: fnd_message.raise_error;
1006: --
1007: end if;
1008: --

Line 1005: fnd_message.raise_error;

1001: --
1002: -- raise error as does not exist as lookup
1003: --
1004: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1005: fnd_message.raise_error;
1006: --
1007: end if;
1008: --
1009: end if;

Line 1073: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

1069: p_effective_date => p_effective_date) then
1070: --
1071: -- raise error as does not exist as lookup
1072: --
1073: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1074: fnd_message.raise_error;
1075: --
1076: end if;
1077: --

Line 1074: fnd_message.raise_error;

1070: --
1071: -- raise error as does not exist as lookup
1072: --
1073: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1074: fnd_message.raise_error;
1075: --
1076: end if;
1077: --
1078: end if;

Line 1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

1141: p_effective_date => p_effective_date) then
1142: --
1143: -- raise error as does not exist as lookup
1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_crs_rlovr_procg_cd');
1147: fnd_message.set_token('TYPE','BEN_CRS_RLOVR_PROCG');
1148: fnd_message.raise_error;
1149: --

Line 1146: fnd_message.set_token('FIELD', 'p_crs_rlovr_procg_cd');

1142: --
1143: -- raise error as does not exist as lookup
1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_crs_rlovr_procg_cd');
1147: fnd_message.set_token('TYPE','BEN_CRS_RLOVR_PROCG');
1148: fnd_message.raise_error;
1149: --
1150: end if;

Line 1147: fnd_message.set_token('TYPE','BEN_CRS_RLOVR_PROCG');

1143: -- raise error as does not exist as lookup
1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_crs_rlovr_procg_cd');
1147: fnd_message.set_token('TYPE','BEN_CRS_RLOVR_PROCG');
1148: fnd_message.raise_error;
1149: --
1150: end if;
1151: --

Line 1148: fnd_message.raise_error;

1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_crs_rlovr_procg_cd');
1147: fnd_message.set_token('TYPE','BEN_CRS_RLOVR_PROCG');
1148: fnd_message.raise_error;
1149: --
1150: end if;
1151: --
1152: end if;

Line 1238: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

1234: close c1;
1235: --
1236: -- raise error
1237: --
1238: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1239: fnd_message.set_token('ID',p_pct_rndg_rl);
1240: fnd_message.set_token('TYPE_ID',-169);
1241: fnd_message.raise_error;
1242: --

Line 1239: fnd_message.set_token('ID',p_pct_rndg_rl);

1235: --
1236: -- raise error
1237: --
1238: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1239: fnd_message.set_token('ID',p_pct_rndg_rl);
1240: fnd_message.set_token('TYPE_ID',-169);
1241: fnd_message.raise_error;
1242: --
1243: end if;

Line 1240: fnd_message.set_token('TYPE_ID',-169);

1236: -- raise error
1237: --
1238: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1239: fnd_message.set_token('ID',p_pct_rndg_rl);
1240: fnd_message.set_token('TYPE_ID',-169);
1241: fnd_message.raise_error;
1242: --
1243: end if;
1244: --

Line 1241: fnd_message.raise_error;

1237: --
1238: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1239: fnd_message.set_token('ID',p_pct_rndg_rl);
1240: fnd_message.set_token('TYPE_ID',-169);
1241: fnd_message.raise_error;
1242: --
1243: end if;
1244: --
1245: close c1;

Line 1333: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

1329: close c1;
1330: --
1331: -- raise error
1332: --
1333: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1334: fnd_message.set_token('ID',p_prtt_elig_rlovr_rl);
1335: fnd_message.set_token('TYPE_ID',-294);
1336: fnd_message.raise_error;
1337: --

Line 1334: fnd_message.set_token('ID',p_prtt_elig_rlovr_rl);

1330: --
1331: -- raise error
1332: --
1333: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1334: fnd_message.set_token('ID',p_prtt_elig_rlovr_rl);
1335: fnd_message.set_token('TYPE_ID',-294);
1336: fnd_message.raise_error;
1337: --
1338: end if;

Line 1335: fnd_message.set_token('TYPE_ID',-294);

1331: -- raise error
1332: --
1333: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1334: fnd_message.set_token('ID',p_prtt_elig_rlovr_rl);
1335: fnd_message.set_token('TYPE_ID',-294);
1336: fnd_message.raise_error;
1337: --
1338: end if;
1339: --

Line 1336: fnd_message.raise_error;

1332: --
1333: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1334: fnd_message.set_token('ID',p_prtt_elig_rlovr_rl);
1335: fnd_message.set_token('TYPE_ID',-294);
1336: fnd_message.raise_error;
1337: --
1338: end if;
1339: --
1340: close c1;

Line 1383: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');

1379: fetch c_abp into l_dummy_var ;
1380: if c_abp%found then
1381: hr_utility.set_location('dupes:'||l_proc, 5);
1382: close c_abp ;
1383: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
1384: fnd_message.set_token('VAR1', 'Rollover Requirements');
1385: fnd_message.set_token('VAR2','Benefit Pool');
1386: fnd_message.raise_error;
1387: end if ;

Line 1384: fnd_message.set_token('VAR1', 'Rollover Requirements');

1380: if c_abp%found then
1381: hr_utility.set_location('dupes:'||l_proc, 5);
1382: close c_abp ;
1383: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
1384: fnd_message.set_token('VAR1', 'Rollover Requirements');
1385: fnd_message.set_token('VAR2','Benefit Pool');
1386: fnd_message.raise_error;
1387: end if ;
1388: close c_abp ;

Line 1385: fnd_message.set_token('VAR2','Benefit Pool');

1381: hr_utility.set_location('dupes:'||l_proc, 5);
1382: close c_abp ;
1383: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
1384: fnd_message.set_token('VAR1', 'Rollover Requirements');
1385: fnd_message.set_token('VAR2','Benefit Pool');
1386: fnd_message.raise_error;
1387: end if ;
1388: close c_abp ;
1389:

Line 1386: fnd_message.raise_error;

1382: close c_abp ;
1383: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
1384: fnd_message.set_token('VAR1', 'Rollover Requirements');
1385: fnd_message.set_token('VAR2','Benefit Pool');
1386: fnd_message.raise_error;
1387: end if ;
1388: close c_abp ;
1389:
1390: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1494: --
1495: -- An unhandled or unexpected error has occurred which
1496: -- we must report
1497: --
1498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1499: fnd_message.set_token('PROCEDURE', l_proc);
1500: fnd_message.set_token('STEP','15');
1501: fnd_message.raise_error;
1502: End dt_update_validate;

Line 1499: fnd_message.set_token('PROCEDURE', l_proc);

1495: -- An unhandled or unexpected error has occurred which
1496: -- we must report
1497: --
1498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1499: fnd_message.set_token('PROCEDURE', l_proc);
1500: fnd_message.set_token('STEP','15');
1501: fnd_message.raise_error;
1502: End dt_update_validate;
1503: --

Line 1500: fnd_message.set_token('STEP','15');

1496: -- we must report
1497: --
1498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1499: fnd_message.set_token('PROCEDURE', l_proc);
1500: fnd_message.set_token('STEP','15');
1501: fnd_message.raise_error;
1502: End dt_update_validate;
1503: --
1504: -- ----------------------------------------------------------------------------

Line 1501: fnd_message.raise_error;

1497: --
1498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1499: fnd_message.set_token('PROCEDURE', l_proc);
1500: fnd_message.set_token('STEP','15');
1501: fnd_message.raise_error;
1502: End dt_update_validate;
1503: --
1504: -- ----------------------------------------------------------------------------
1505: -- |--------------------------< dt_delete_validate >--------------------------|

Line 1601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1597: --
1598: -- An unhandled or unexpected error has occurred which
1599: -- we must report
1600: --
1601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1602: fnd_message.set_token('PROCEDURE', l_proc);
1603: fnd_message.set_token('STEP','15');
1604: fnd_message.raise_error;
1605: End dt_delete_validate;

Line 1602: fnd_message.set_token('PROCEDURE', l_proc);

1598: -- An unhandled or unexpected error has occurred which
1599: -- we must report
1600: --
1601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1602: fnd_message.set_token('PROCEDURE', l_proc);
1603: fnd_message.set_token('STEP','15');
1604: fnd_message.raise_error;
1605: End dt_delete_validate;
1606: --

Line 1603: fnd_message.set_token('STEP','15');

1599: -- we must report
1600: --
1601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1602: fnd_message.set_token('PROCEDURE', l_proc);
1603: fnd_message.set_token('STEP','15');
1604: fnd_message.raise_error;
1605: End dt_delete_validate;
1606: --
1607: -- ----------------------------------------------------------------------------

Line 1604: fnd_message.raise_error;

1600: --
1601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1602: fnd_message.set_token('PROCEDURE', l_proc);
1603: fnd_message.set_token('STEP','15');
1604: fnd_message.raise_error;
1605: End dt_delete_validate;
1606: --
1607: -- ----------------------------------------------------------------------------
1608: -- |---------------------------< insert_validate >----------------------------|

Line 1965: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

1961: close csr_leg_code;
1962: --
1963: -- The primary key is invalid therefore we must error
1964: --
1965: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1966: fnd_message.raise_error;
1967: --
1968: end if;
1969: --

Line 1966: fnd_message.raise_error;

1962: --
1963: -- The primary key is invalid therefore we must error
1964: --
1965: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1966: fnd_message.raise_error;
1967: --
1968: end if;
1969: --
1970: close csr_leg_code;