DBA Data[Home] [Help]

APPS.PAY_CNU_BUS1 dependencies on FND_MESSAGE

Line 61: fnd_message.set_name('PAY', 'PAY_74897_CNU_BAD_USAGE_TYPE');

57: p_effective_date => p_effective_date
58: ,p_lookup_type => 'FR_CONTRIBUTION_USAGE_TYPE'
59: ,p_lookup_code => p_contribution_usage_type)
60: then
61: fnd_message.set_name('PAY', 'PAY_74897_CNU_BAD_USAGE_TYPE');
62: fnd_message.raise_error;
63: end if;
64: --
65: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 62: fnd_message.raise_error;

58: ,p_lookup_type => 'FR_CONTRIBUTION_USAGE_TYPE'
59: ,p_lookup_code => p_contribution_usage_type)
60: then
61: fnd_message.set_name('PAY', 'PAY_74897_CNU_BAD_USAGE_TYPE');
62: fnd_message.raise_error;
63: end if;
64: --
65: hr_utility.set_location(' Leaving:'||l_proc, 20);
66: end chk_contribution_usage_type;

Line 94: fnd_message.set_name('PAY', 'PAY_74898_CNU_BAD_RATE_TYPE');

90: p_effective_date => p_effective_date
91: ,p_lookup_type => 'FR_CONTRIBUTION_RATE_TYPE'
92: ,p_lookup_code => p_rate_type)
93: then
94: fnd_message.set_name('PAY', 'PAY_74898_CNU_BAD_RATE_TYPE');
95: fnd_message.raise_error;
96: end if;
97: end if;
98: --

Line 95: fnd_message.raise_error;

91: ,p_lookup_type => 'FR_CONTRIBUTION_RATE_TYPE'
92: ,p_lookup_code => p_rate_type)
93: then
94: fnd_message.set_name('PAY', 'PAY_74898_CNU_BAD_RATE_TYPE');
95: fnd_message.raise_error;
96: end if;
97: end if;
98: --
99: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 132: fnd_message.set_name('PAY', 'PAY_74899_CNU_BAD_PROCESS');

128: p_effective_date => p_effective_date
129: ,p_lookup_type => 'FR_PROCESS_TYPE'
130: ,p_lookup_code => p_process_type)
131: then
132: fnd_message.set_name('PAY', 'PAY_74899_CNU_BAD_PROCESS');
133: fnd_message.raise_error;
134: end if;
135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 133: fnd_message.raise_error;

129: ,p_lookup_type => 'FR_PROCESS_TYPE'
130: ,p_lookup_code => p_process_type)
131: then
132: fnd_message.set_name('PAY', 'PAY_74899_CNU_BAD_PROCESS');
133: fnd_message.raise_error;
134: end if;
135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 20);
137: end chk_process_type;

Line 176: fnd_message.set_name('PAY', 'PAY_74900_CNU_BAD_GROUP_CODE');

172: p_effective_date => p_effective_date
173: ,p_lookup_type => 'FR_USER_ELEMENT_GROUP'
174: ,p_lookup_code => p_group_code )
175: then
176: fnd_message.set_name('PAY', 'PAY_74900_CNU_BAD_GROUP_CODE');
177: fnd_message.raise_error;
178: end if;
179: end if;
180: --

Line 177: fnd_message.raise_error;

173: ,p_lookup_type => 'FR_USER_ELEMENT_GROUP'
174: ,p_lookup_code => p_group_code )
175: then
176: fnd_message.set_name('PAY', 'PAY_74900_CNU_BAD_GROUP_CODE');
177: fnd_message.raise_error;
178: end if;
179: end if;
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 215: fnd_message.set_name('PAY', 'PAY_74901_CNU_BAD_LEGISLATION');

211: fetch csr_leg_code into l_leg_code;
212: close csr_leg_code;
213: If l_leg_code <> 'FR'
214: then
215: fnd_message.set_name('PAY', 'PAY_74901_CNU_BAD_LEGISLATION');
216: fnd_message.raise_error;
217: end if;
218: hr_utility.set_location(' Step:'|| l_proc, 20);
219: end if;

Line 216: fnd_message.raise_error;

212: close csr_leg_code;
213: If l_leg_code <> 'FR'
214: then
215: fnd_message.set_name('PAY', 'PAY_74901_CNU_BAD_LEGISLATION');
216: fnd_message.raise_error;
217: end if;
218: hr_utility.set_location(' Step:'|| l_proc, 20);
219: end if;
220: --

Line 252: fnd_message.set_name('PAY', 'PAY_74902_CNU_BAD_RATE_CAT');

248: and(p_rate_category <> 'C')
249:
250: )
251: then
252: fnd_message.set_name('PAY', 'PAY_74902_CNU_BAD_RATE_CAT');
253: fnd_message.raise_error;
254: end if;
255: --
256: hr_utility.set_location(' Step:'|| l_proc, 30);

Line 253: fnd_message.raise_error;

249:
250: )
251: then
252: fnd_message.set_name('PAY', 'PAY_74902_CNU_BAD_RATE_CAT');
253: fnd_message.raise_error;
254: end if;
255: --
256: hr_utility.set_location(' Step:'|| l_proc, 30);
257: if( ( ( p_rate_category = 'W'

Line 266: fnd_message.set_name('PAY', 'PAY_74903_CNU_BAD_RATE_STD');

262: OR p_rate_category = 'D'
263: OR p_rate_category = 'C') and p_rate_type is null)
264: )
265: then
266: fnd_message.set_name('PAY', 'PAY_74903_CNU_BAD_RATE_STD');
267: fnd_message.raise_error;
268: end if;
269: hr_utility.set_location(' Leaving:'||l_proc, 40);
270: end chk_rate_category_type;

Line 267: fnd_message.raise_error;

263: OR p_rate_category = 'C') and p_rate_type is null)
264: )
265: then
266: fnd_message.set_name('PAY', 'PAY_74903_CNU_BAD_RATE_STD');
267: fnd_message.raise_error;
268: end if;
269: hr_utility.set_location(' Leaving:'||l_proc, 40);
270: end chk_rate_category_type;
271: --

Line 332: fnd_message.set_name('PAY', 'PAY_74904_CNU_BAD_URSSAF');

328: OR(length(p_code) <> 7 and length(p_code) <> 8)
329: )
330: then
331: hr_utility.set_location(' Step:'|| l_proc, 20);
332: fnd_message.set_name('PAY', 'PAY_74904_CNU_BAD_URSSAF');
333: fnd_message.raise_error;
334: end if;
335: hr_utility.set_location(' Step:'|| l_proc, 30);
336: --

Line 333: fnd_message.raise_error;

329: )
330: then
331: hr_utility.set_location(' Step:'|| l_proc, 20);
332: fnd_message.set_name('PAY', 'PAY_74904_CNU_BAD_URSSAF');
333: fnd_message.raise_error;
334: end if;
335: hr_utility.set_location(' Step:'|| l_proc, 30);
336: --
337: -- ASSEDIC

Line 353: fnd_message.set_name('PAY', 'PAY_74905_CNU_BAD_ASSEDIC');

349: OR(is_numeric(substr(p_code, 7, 1)) <> '1')
350: OR(length(p_code) <> 7)
351: )
352: then
353: fnd_message.set_name('PAY', 'PAY_74905_CNU_BAD_ASSEDIC');
354: fnd_message.raise_error;
355: end if;
356: hr_utility.set_location(' Step:'|| l_proc, 50);
357: --

Line 354: fnd_message.raise_error;

350: OR(length(p_code) <> 7)
351: )
352: then
353: fnd_message.set_name('PAY', 'PAY_74905_CNU_BAD_ASSEDIC');
354: fnd_message.raise_error;
355: end if;
356: hr_utility.set_location(' Step:'|| l_proc, 50);
357: --
358: -- AGIRC

Line 368: fnd_message.set_name('PAY', 'PAY_74906_CNU_BAD_AGIRC');

364: OR(is_numeric(substr(p_code, 7, 1)) <> '1')
365: OR(length(p_code) <> 7)
366: )
367: then
368: fnd_message.set_name('PAY', 'PAY_74906_CNU_BAD_AGIRC');
369: fnd_message.raise_error;
370: end if;
371: hr_utility.set_location(' Step:'|| l_proc, 60);
372: --

Line 369: fnd_message.raise_error;

365: OR(length(p_code) <> 7)
366: )
367: then
368: fnd_message.set_name('PAY', 'PAY_74906_CNU_BAD_AGIRC');
369: fnd_message.raise_error;
370: end if;
371: hr_utility.set_location(' Step:'|| l_proc, 60);
372: --
373: --

Line 384: fnd_message.set_name('PAY', 'PAY_74907_CNU_BAD_ARRCO');

380: OR(is_numeric(substr(p_code, 7, 1)) <> '1' and is_numeric(substr(p_code, 7, 1)) <> '2')
381: OR(length(p_code) <> 7)
382: )
383: then
384: fnd_message.set_name('PAY', 'PAY_74907_CNU_BAD_ARRCO');
385: fnd_message.raise_error;
386: end if;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 385: fnd_message.raise_error;

381: OR(length(p_code) <> 7)
382: )
383: then
384: fnd_message.set_name('PAY', 'PAY_74907_CNU_BAD_ARRCO');
385: fnd_message.raise_error;
386: end if;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 80);
389: end chk_validate_code;

Line 424: fnd_message.set_name('PAY', 'PAY_74908_CNU_MISSING_CODE');

420: --
421: if p_contribution_type <> 'URSSAF' and p_contribution_code is null and p_rate_category <> 'C'
422: then
423: hr_utility.set_location(' Step:'|| l_proc, 20);
424: fnd_message.set_name('PAY', 'PAY_74908_CNU_MISSING_CODE');
425: fnd_message.raise_error;
426: end if;
427: --
428: l_api_updating := pay_cnu_shd.api_updating

Line 425: fnd_message.raise_error;

421: if p_contribution_type <> 'URSSAF' and p_contribution_code is null and p_rate_category <> 'C'
422: then
423: hr_utility.set_location(' Step:'|| l_proc, 20);
424: fnd_message.set_name('PAY', 'PAY_74908_CNU_MISSING_CODE');
425: fnd_message.raise_error;
426: end if;
427: --
428: l_api_updating := pay_cnu_shd.api_updating
429: (p_contribution_usage_id => p_contribution_usage_id

Line 493: fnd_message.set_name('PAY', 'PAY_74909_CNU_BAD_CONT_TYPE');

489: and p_contribution_type <> 'AGIRC'
490: and p_contribution_type <> 'ARRCO'
491: then
492: hr_utility.set_location(' Step:'|| l_proc, 20);
493: fnd_message.set_name('PAY', 'PAY_74909_CNU_BAD_CONT_TYPE');
494: fnd_message.raise_error;
495: end if;
496: hr_utility.set_location(' Leaving:'||l_proc, 90);
497: end chk_contribution_type;

Line 494: fnd_message.raise_error;

490: and p_contribution_type <> 'ARRCO'
491: then
492: hr_utility.set_location(' Step:'|| l_proc, 20);
493: fnd_message.set_name('PAY', 'PAY_74909_CNU_BAD_CONT_TYPE');
494: fnd_message.raise_error;
495: end if;
496: hr_utility.set_location(' Leaving:'||l_proc, 90);
497: end chk_contribution_type;
498:

Line 578: fnd_message.set_name('PAY', 'PAY_74910_CNU_CHANGING_GROUP');

574: open csr_unique;
575: fetch csr_unique into l_cu_id;
576: if csr_unique%FOUND then
577: close csr_unique;
578: fnd_message.set_name('PAY', 'PAY_74910_CNU_CHANGING_GROUP');
579: fnd_message.raise_error;
580: else
581: close csr_unique;
582: hr_utility.set_location(' Step:'|| l_proc, 80);

Line 579: fnd_message.raise_error;

575: fetch csr_unique into l_cu_id;
576: if csr_unique%FOUND then
577: close csr_unique;
578: fnd_message.set_name('PAY', 'PAY_74910_CNU_CHANGING_GROUP');
579: fnd_message.raise_error;
580: else
581: close csr_unique;
582: hr_utility.set_location(' Step:'|| l_proc, 80);
583: end if;

Line 696: fnd_message.set_name('PAY', 'PAY_74911_CNU_DATE_FROM');

692: -- Check that the date_from is before or on the date_to
693: --
694: if p_date_from > nvl(p_date_to, hr_api.g_eot) THEN
695: hr_utility.set_location(' Step:'|| l_proc, 55);
696: fnd_message.set_name('PAY', 'PAY_74911_CNU_DATE_FROM');
697: fnd_message.raise_error;
698: end if;
699: --
700: -- If the date_to is changing or if this is an insert

Line 697: fnd_message.raise_error;

693: --
694: if p_date_from > nvl(p_date_to, hr_api.g_eot) THEN
695: hr_utility.set_location(' Step:'|| l_proc, 55);
696: fnd_message.set_name('PAY', 'PAY_74911_CNU_DATE_FROM');
697: fnd_message.raise_error;
698: end if;
699: --
700: -- If the date_to is changing or if this is an insert
701: --

Line 713: fnd_message.set_name('PAY', 'PAY_74912_CNU_DUPLICATE_USAGE');

709: fetch csr_unique into l_cu_id;
710: if csr_unique%FOUND then
711: close csr_unique;
712: hr_utility.set_location(' Step:'|| l_proc, 70);
713: fnd_message.set_name('PAY', 'PAY_74912_CNU_DUPLICATE_USAGE');
714: fnd_message.raise_error;
715: else
716: close csr_unique;
717: hr_utility.set_location(' Step:'|| l_proc, 80);

Line 714: fnd_message.raise_error;

710: if csr_unique%FOUND then
711: close csr_unique;
712: hr_utility.set_location(' Step:'|| l_proc, 70);
713: fnd_message.set_name('PAY', 'PAY_74912_CNU_DUPLICATE_USAGE');
714: fnd_message.raise_error;
715: else
716: close csr_unique;
717: hr_utility.set_location(' Step:'|| l_proc, 80);
718: end if;

Line 876: fnd_message.set_name('PAY', 'PAY_75061_CNU_NOT_REQ_CODE_R');

872: -- check if code_rate_id is required
873: --
874: if p_rate_category in ('W', 'T') or p_contribution_code is null or p_rate_type is null then
875: if p_code_rate_id is not null then
876: fnd_message.set_name('PAY', 'PAY_75061_CNU_NOT_REQ_CODE_R');
877: fnd_message.raise_error;
878: end if;
879: else
880: if (p_business_group_id is null and p_code_rate_id is null)

Line 877: fnd_message.raise_error;

873: --
874: if p_rate_category in ('W', 'T') or p_contribution_code is null or p_rate_type is null then
875: if p_code_rate_id is not null then
876: fnd_message.set_name('PAY', 'PAY_75061_CNU_NOT_REQ_CODE_R');
877: fnd_message.raise_error;
878: end if;
879: else
880: if (p_business_group_id is null and p_code_rate_id is null)
881: or

Line 884: fnd_message.set_name('PAY', 'PAY_75062_CNU_BG_CODE_R');

880: if (p_business_group_id is null and p_code_rate_id is null)
881: or
882: (p_business_group_id is not null and p_code_rate_id is not null)
883: then
884: fnd_message.set_name('PAY', 'PAY_75062_CNU_BG_CODE_R');
885: fnd_message.raise_error;
886: end if;
887: --
888: -- seeded code rate ids must be >=0, <30

Line 885: fnd_message.raise_error;

881: or
882: (p_business_group_id is not null and p_code_rate_id is not null)
883: then
884: fnd_message.set_name('PAY', 'PAY_75062_CNU_BG_CODE_R');
885: fnd_message.raise_error;
886: end if;
887: --
888: -- seeded code rate ids must be >=0, <30
889: --

Line 893: fnd_message.set_name('PAY', 'PAY_75063_CNU_RGE_CODE_R');

889: --
890: if p_business_group_id is null
891: and (p_code_rate_id < 0 OR p_code_rate_id >29)
892: then
893: fnd_message.set_name('PAY', 'PAY_75063_CNU_RGE_CODE_R');
894: fnd_message.raise_error;
895: end if;
896: --
897: -- get a code rate id for the business group id

Line 894: fnd_message.raise_error;

890: if p_business_group_id is null
891: and (p_code_rate_id < 0 OR p_code_rate_id >29)
892: then
893: fnd_message.set_name('PAY', 'PAY_75063_CNU_RGE_CODE_R');
894: fnd_message.raise_error;
895: end if;
896: --
897: -- get a code rate id for the business group id
898: --

Line 918: fnd_message.set_name('PAY', 'PAY_75064_CNU_UNQ_CODE_R');

914: open csr_chk_unique;
915: fetch csr_chk_unique into l_exists;
916: if csr_chk_unique%FOUND then
917: close csr_chk_unique;
918: fnd_message.set_name('PAY', 'PAY_75064_CNU_UNQ_CODE_R');
919: fnd_message.raise_error;
920: else
921: close csr_chk_unique;
922: end if;

Line 919: fnd_message.raise_error;

915: fetch csr_chk_unique into l_exists;
916: if csr_chk_unique%FOUND then
917: close csr_chk_unique;
918: fnd_message.set_name('PAY', 'PAY_75064_CNU_UNQ_CODE_R');
919: fnd_message.raise_error;
920: else
921: close csr_chk_unique;
922: end if;
923: End if;