DBA Data[Home] [Help]

APPS.PER_ABB_BUS dependencies on FND_MESSAGE

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

70: --
71: -- The primary key is invalid therefore we must error
72: --
73: close csr_leg_code;
74: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
75: fnd_message.raise_error;
76: end if;
77: hr_utility.set_location(l_proc,30);
78: --

Line 75: fnd_message.raise_error;

71: -- The primary key is invalid therefore we must error
72: --
73: close csr_leg_code;
74: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
75: fnd_message.raise_error;
76: end if;
77: hr_utility.set_location(l_proc,30);
78: --
79: -- Set the global variables so the values are

Line 164: fnd_message.set_name('PER','PER_7003_ALL_DATE_FROM_TO');

160: or p_date_end <> per_abb_shd.g_old_rec.date_end))
161: or not l_api_updating) then
162: --
163: if p_date_effective > nvl (p_date_end,hr_api.g_eot) then
164: fnd_message.set_name('PER','PER_7003_ALL_DATE_FROM_TO');
165: fnd_message.raise_error;
166: end if;
167: --
168: if l_api_updating then

Line 165: fnd_message.raise_error;

161: or not l_api_updating) then
162: --
163: if p_date_effective > nvl (p_date_end,hr_api.g_eot) then
164: fnd_message.set_name('PER','PER_7003_ALL_DATE_FROM_TO');
165: fnd_message.raise_error;
166: end if;
167: --
168: if l_api_updating then
169: open csr_chk_attendance_date;

Line 173: fnd_message.set_name('PER','HR_6790_ABS_NO_CHANGE_2');

169: open csr_chk_attendance_date;
170: fetch csr_chk_attendance_date into l_dummy;
171: if csr_chk_attendance_date%found then
172: close csr_chk_attendance_date;
173: fnd_message.set_name('PER','HR_6790_ABS_NO_CHANGE_2');
174: fnd_message.raise_error;
175: else
176: close csr_chk_attendance_date;
177: end if;

Line 174: fnd_message.raise_error;

170: fetch csr_chk_attendance_date into l_dummy;
171: if csr_chk_attendance_date%found then
172: close csr_chk_attendance_date;
173: fnd_message.set_name('PER','HR_6790_ABS_NO_CHANGE_2');
174: fnd_message.raise_error;
175: else
176: close csr_chk_attendance_date;
177: end if;
178: end if;

Line 317: fnd_message.set_name('PER','PER_449173_ABB_NO_BG_NO_INPUT');

313: -- input value cannot be specified unless BG is specified
314: --
315: if p_business_group_id is null
316: and p_input_value_id is not null then
317: fnd_message.set_name('PER','PER_449173_ABB_NO_BG_NO_INPUT');
318: fnd_message.raise_error;
319: end if;
320: --
321: hr_utility.set_location(l_proc,30);

Line 318: fnd_message.raise_error;

314: --
315: if p_business_group_id is null
316: and p_input_value_id is not null then
317: fnd_message.set_name('PER','PER_449173_ABB_NO_BG_NO_INPUT');
318: fnd_message.raise_error;
319: end if;
320: --
321: hr_utility.set_location(l_proc,30);
322: --

Line 329: fnd_message.set_name('PER','PER_449174_ABB_NO_CHANGE_INPUT');

325: if (p_input_value_id is not null
326: and p_input_value_id <> nvl(per_abb_shd.g_old_rec.input_value_id,p_input_value_id))
327: or (p_input_value_id is null and per_abb_shd.g_old_rec.input_value_id is not null)
328: then
329: fnd_message.set_name('PER','PER_449174_ABB_NO_CHANGE_INPUT');
330: fnd_message.raise_error;
331: end if;
332: --
333: if p_input_value_id is not null then

Line 330: fnd_message.raise_error;

326: and p_input_value_id <> nvl(per_abb_shd.g_old_rec.input_value_id,p_input_value_id))
327: or (p_input_value_id is null and per_abb_shd.g_old_rec.input_value_id is not null)
328: then
329: fnd_message.set_name('PER','PER_449174_ABB_NO_CHANGE_INPUT');
330: fnd_message.raise_error;
331: end if;
332: --
333: if p_input_value_id is not null then
334: --

Line 339: fnd_message.set_name('PER','PER_449182_ABB_INPUT_WRONG_BG');

335: open csr_valid_input_value_bg;
336: fetch csr_valid_input_value_bg into l_dummy;
337: if csr_valid_input_value_bg%notfound then
338: close csr_valid_input_value_bg;
339: fnd_message.set_name('PER','PER_449182_ABB_INPUT_WRONG_BG');
340: fnd_message.raise_error;
341: else
342: close csr_valid_input_value_bg;
343: end if;

Line 340: fnd_message.raise_error;

336: fetch csr_valid_input_value_bg into l_dummy;
337: if csr_valid_input_value_bg%notfound then
338: close csr_valid_input_value_bg;
339: fnd_message.set_name('PER','PER_449182_ABB_INPUT_WRONG_BG');
340: fnd_message.raise_error;
341: else
342: close csr_valid_input_value_bg;
343: end if;
344: --

Line 356: fnd_message.set_name('PER','PER_7800_DEF_ABS_ELEMENT_ENDS');

352: and l_input_end < hr_api.g_eot then
353: l_date_end := l_input_end; --auto-populate date_end if input has end date
354: elsif p_date_end is not null
355: and p_date_end > l_input_end then
356: fnd_message.set_name('PER','PER_7800_DEF_ABS_ELEMENT_ENDS');
357: fnd_message.raise_error;
358: end if;
359: --
360: open csr_valid_input_value_dates;

Line 357: fnd_message.raise_error;

353: l_date_end := l_input_end; --auto-populate date_end if input has end date
354: elsif p_date_end is not null
355: and p_date_end > l_input_end then
356: fnd_message.set_name('PER','PER_7800_DEF_ABS_ELEMENT_ENDS');
357: fnd_message.raise_error;
358: end if;
359: --
360: open csr_valid_input_value_dates;
361: fetch csr_valid_input_value_dates into l_dummy;

Line 364: fnd_message.set_name('PER','PER_449176_ABB_INPUT_NOT_EXIST');

360: open csr_valid_input_value_dates;
361: fetch csr_valid_input_value_dates into l_dummy;
362: if csr_valid_input_value_dates%notfound then
363: close csr_valid_input_value_dates;
364: fnd_message.set_name('PER','PER_449176_ABB_INPUT_NOT_EXIST');
365: fnd_message.raise_error;
366: else
367: close csr_valid_input_value_dates;
368: end if;

Line 365: fnd_message.raise_error;

361: fetch csr_valid_input_value_dates into l_dummy;
362: if csr_valid_input_value_dates%notfound then
363: close csr_valid_input_value_dates;
364: fnd_message.set_name('PER','PER_449176_ABB_INPUT_NOT_EXIST');
365: fnd_message.raise_error;
366: else
367: close csr_valid_input_value_dates;
368: end if;
369: --

Line 376: fnd_message.set_name('PER','PER_449175_ABB_INPUT_WRONG_UOM');

372: open csr_valid_input_value_uom;
373: fetch csr_valid_input_value_uom into l_dummy;
374: if csr_valid_input_value_uom%notfound then
375: close csr_valid_input_value_uom;
376: fnd_message.set_name('PER','PER_449175_ABB_INPUT_WRONG_UOM');
377: fnd_message.raise_error;
378: else
379: close csr_valid_input_value_uom;
380: end if;

Line 377: fnd_message.raise_error;

373: fetch csr_valid_input_value_uom into l_dummy;
374: if csr_valid_input_value_uom%notfound then
375: close csr_valid_input_value_uom;
376: fnd_message.set_name('PER','PER_449175_ABB_INPUT_WRONG_UOM');
377: fnd_message.raise_error;
378: else
379: close csr_valid_input_value_uom;
380: end if;
381: --

Line 388: fnd_message.set_name('PER','PER_449177_ABB_INPUT_ELE_TYPE');

384: open csr_valid_element_type;
385: fetch csr_valid_element_type into l_dummy;
386: if csr_valid_element_type%notfound then
387: close csr_valid_element_type;
388: fnd_message.set_name('PER','PER_449177_ABB_INPUT_ELE_TYPE');
389: fnd_message.raise_error;
390: else
391: close csr_valid_element_type;
392: end if;

Line 389: fnd_message.raise_error;

385: fetch csr_valid_element_type into l_dummy;
386: if csr_valid_element_type%notfound then
387: close csr_valid_element_type;
388: fnd_message.set_name('PER','PER_449177_ABB_INPUT_ELE_TYPE');
389: fnd_message.raise_error;
390: else
391: close csr_valid_element_type;
392: end if;
393: --

Line 558: fnd_message.set_name('PER','PER_449183_ABB_NO_INPUT_NO_INC');

554: then
555: --
556: if p_input_value_id is null then
557: if p_inc_or_dec_flag is not null then
558: fnd_message.set_name('PER','PER_449183_ABB_NO_INPUT_NO_INC');
559: fnd_message.raise_error;
560: end if;
561: --
562: hr_utility.set_location(l_proc,20);

Line 559: fnd_message.raise_error;

555: --
556: if p_input_value_id is null then
557: if p_inc_or_dec_flag is not null then
558: fnd_message.set_name('PER','PER_449183_ABB_NO_INPUT_NO_INC');
559: fnd_message.raise_error;
560: end if;
561: --
562: hr_utility.set_location(l_proc,20);
563: --

Line 568: fnd_message.set_name('PER','HR_7583_ALL_MAN_INC_FIELD');

564: else
565: -- input_value_id is not null so inc_or_dec_flag must be specified
566: --
567: if nvl(p_inc_or_dec_flag,hr_api.g_varchar2) not in ('I','D') then
568: fnd_message.set_name('PER','HR_7583_ALL_MAN_INC_FIELD');
569: fnd_message.raise_error;
570: end if;
571: --
572: hr_utility.set_location(l_proc,30);

Line 569: fnd_message.raise_error;

565: -- input_value_id is not null so inc_or_dec_flag must be specified
566: --
567: if nvl(p_inc_or_dec_flag,hr_api.g_varchar2) not in ('I','D') then
568: fnd_message.set_name('PER','HR_7583_ALL_MAN_INC_FIELD');
569: fnd_message.raise_error;
570: end if;
571: --
572: hr_utility.set_location(l_proc,30);
573: --

Line 581: fnd_message.set_name('PER','PER_449178_ABB_NO_CHANGE_INC');

577: per_abb_shd.g_old_rec.increasing_or_decreasing_flag then
578: --
579: --flag must not be changed once it is not null
580: --
581: fnd_message.set_name('PER','PER_449178_ABB_NO_CHANGE_INC');
582: fnd_message.raise_error;
583: end if;
584: end if;
585: end if;

Line 582: fnd_message.raise_error;

578: --
579: --flag must not be changed once it is not null
580: --
581: fnd_message.set_name('PER','PER_449178_ABB_NO_CHANGE_INC');
582: fnd_message.raise_error;
583: end if;
584: end if;
585: end if;
586: hr_utility.set_location('Leaving:'||l_proc,70);

Line 667: fnd_message.set_name('PER','PER_449184_ABB_NO_INPUT_NO_HOU');

663: then
664: --
665: if p_input_value_id is null then
666: if p_hours_or_days is not null then
667: fnd_message.set_name('PER','PER_449184_ABB_NO_INPUT_NO_HOU');
668: fnd_message.raise_error;
669: end if;
670: --
671: else -- input_value_id is not null

Line 668: fnd_message.raise_error;

664: --
665: if p_input_value_id is null then
666: if p_hours_or_days is not null then
667: fnd_message.set_name('PER','PER_449184_ABB_NO_INPUT_NO_HOU');
668: fnd_message.raise_error;
669: end if;
670: --
671: else -- input_value_id is not null
672: hr_utility.set_location(l_proc,20);

Line 681: fnd_message.set_name('PER','PER_449179_ABB_NO_CHANGE_HOURS');

677: per_abb_shd.g_old_rec.hours_or_days then
678: --
679: --flag must not be changed once it is not null
680: --
681: fnd_message.set_name('PER','PER_449179_ABB_NO_CHANGE_HOURS');
682: fnd_message.raise_error;
683: end if;
684: --
685: hr_utility.set_location(l_proc,30);

Line 682: fnd_message.raise_error;

678: --
679: --flag must not be changed once it is not null
680: --
681: fnd_message.set_name('PER','PER_449179_ABB_NO_CHANGE_HOURS');
682: fnd_message.raise_error;
683: end if;
684: --
685: hr_utility.set_location(l_proc,30);
686: --

Line 691: fnd_message.set_name('PER','PER_449180_ABB_HOURS_WRONG_UOM');

687: -- flag must have the correct value (uom of input value is already validated)
688: --
689: if p_hours_or_days is null
690: or p_hours_or_days not in ('D','H') then
691: fnd_message.set_name('PER','PER_449180_ABB_HOURS_WRONG_UOM');
692: fnd_message.raise_error;
693: end if;
694: end if; --input_value_id is null check
695: --

Line 692: fnd_message.raise_error;

688: --
689: if p_hours_or_days is null
690: or p_hours_or_days not in ('D','H') then
691: fnd_message.set_name('PER','PER_449180_ABB_HOURS_WRONG_UOM');
692: fnd_message.raise_error;
693: end if;
694: end if; --input_value_id is null check
695: --
696: end if; --api updating check

Line 786: fnd_message.set_name('PER','PER_449185_ABB_CAT_NOT_EXIST');

782: ,p_lookup_code => p_absence_category
783: )
784: then
785: --
786: fnd_message.set_name('PER','PER_449185_ABB_CAT_NOT_EXIST');
787: fnd_message.raise_error;
788: end if;
789: --
790: hr_utility.set_location(l_proc,30);

Line 787: fnd_message.raise_error;

783: )
784: then
785: --
786: fnd_message.set_name('PER','PER_449185_ABB_CAT_NOT_EXIST');
787: fnd_message.raise_error;
788: end if;
789: --
790: hr_utility.set_location(l_proc,30);
791: --

Line 802: fnd_message.set_name('PER','HR_6383_ABS_DET_NO_CHANGE');

798: and per_abb_shd.g_old_rec.absence_category <>
799: nvl(p_absence_category,hr_api.g_varchar2)
800: then
801: close csr_absence_attendance;
802: fnd_message.set_name('PER','HR_6383_ABS_DET_NO_CHANGE');
803: fnd_message.raise_error;
804: else
805: hr_utility.set_location(l_proc,40);
806: --

Line 803: fnd_message.raise_error;

799: nvl(p_absence_category,hr_api.g_varchar2)
800: then
801: close csr_absence_attendance;
802: fnd_message.set_name('PER','HR_6383_ABS_DET_NO_CHANGE');
803: fnd_message.raise_error;
804: else
805: hr_utility.set_location(l_proc,40);
806: --
807: close csr_absence_attendance;

Line 905: fnd_message.set_name('PER','PER_449181_ABB_INFO_CAT_BG');

901: hr_utility.set_location(l_proc,10);
902: --
903: if p_information_category is not null then
904: if p_business_group_id is null then
905: fnd_message.set_name('PER','PER_449181_ABB_INFO_CAT_BG');
906: fnd_message.raise_error;
907: else
908: --
909: hr_utility.set_location(l_proc,20);

Line 906: fnd_message.raise_error;

902: --
903: if p_information_category is not null then
904: if p_business_group_id is null then
905: fnd_message.set_name('PER','PER_449181_ABB_INFO_CAT_BG');
906: fnd_message.raise_error;
907: else
908: --
909: hr_utility.set_location(l_proc,20);
910: --

Line 916: fnd_message.set_name('PER','PER_449186_ABB_INF_CAT_LEG');

912: fetch csr_bg_legislation into l_leg;
913: close csr_bg_legislation;
914: --
915: if p_information_category <> l_leg then
916: fnd_message.set_name('PER','PER_449186_ABB_INF_CAT_LEG');
917: fnd_message.raise_error;
918: end if;
919: --
920: end if;

Line 917: fnd_message.raise_error;

913: close csr_bg_legislation;
914: --
915: if p_information_category <> l_leg then
916: fnd_message.set_name('PER','PER_449186_ABB_INF_CAT_LEG');
917: fnd_message.raise_error;
918: end if;
919: --
920: end if;
921: else

Line 1009: fnd_message.set_name('PER','PER_7059_EMP_ABS_DEL_TYPE');

1005: open csr_attendance;
1006: fetch csr_attendance into l_dummy;
1007: if csr_attendance%found then
1008: close csr_attendance;
1009: fnd_message.set_name('PER','PER_7059_EMP_ABS_DEL_TYPE');
1010: fnd_message.raise_error;
1011: else
1012: close csr_attendance;
1013: end if;

Line 1010: fnd_message.raise_error;

1006: fetch csr_attendance into l_dummy;
1007: if csr_attendance%found then
1008: close csr_attendance;
1009: fnd_message.set_name('PER','PER_7059_EMP_ABS_DEL_TYPE');
1010: fnd_message.raise_error;
1011: else
1012: close csr_attendance;
1013: end if;
1014: --

Line 1021: fnd_message.set_name('PER','PER_7805_DEF_ABS_DEL_REASON');

1017: open csr_reason;
1018: fetch csr_reason into l_dummy;
1019: if csr_reason%found then
1020: close csr_reason;
1021: fnd_message.set_name('PER','PER_7805_DEF_ABS_DEL_REASON');
1022: fnd_message.raise_error;
1023: else
1024: close csr_reason;
1025: end if;

Line 1022: fnd_message.raise_error;

1018: fetch csr_reason into l_dummy;
1019: if csr_reason%found then
1020: close csr_reason;
1021: fnd_message.set_name('PER','PER_7805_DEF_ABS_DEL_REASON');
1022: fnd_message.raise_error;
1023: else
1024: close csr_reason;
1025: end if;
1026: --

Line 1350: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

1346: IF NOT per_abb_shd.api_updating
1347: (p_absence_attendance_type_id => p_rec.absence_attendance_type_id
1348: ,p_object_version_number => p_rec.object_version_number
1349: ) THEN
1350: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1351: fnd_message.set_token('PROCEDURE ', l_proc);
1352: fnd_message.set_token('STEP ', '5');
1353: fnd_message.raise_error;
1354: END IF;

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

1347: (p_absence_attendance_type_id => p_rec.absence_attendance_type_id
1348: ,p_object_version_number => p_rec.object_version_number
1349: ) THEN
1350: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1351: fnd_message.set_token('PROCEDURE ', l_proc);
1352: fnd_message.set_token('STEP ', '5');
1353: fnd_message.raise_error;
1354: END IF;
1355: --

Line 1352: fnd_message.set_token('STEP ', '5');

1348: ,p_object_version_number => p_rec.object_version_number
1349: ) THEN
1350: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1351: fnd_message.set_token('PROCEDURE ', l_proc);
1352: fnd_message.set_token('STEP ', '5');
1353: fnd_message.raise_error;
1354: END IF;
1355: --
1356: hr_utility.set_location(l_proc, 10);

Line 1353: fnd_message.raise_error;

1349: ) THEN
1350: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1351: fnd_message.set_token('PROCEDURE ', l_proc);
1352: fnd_message.set_token('STEP ', '5');
1353: fnd_message.raise_error;
1354: END IF;
1355: --
1356: hr_utility.set_location(l_proc, 10);
1357: --