DBA Data[Home] [Help]

APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on FND_MESSAGE

Line 166: fnd_message.set_name('SSP', 'SSP_35060_SSP_ABS_FK2');

162: If (p_constraint_name = 'PER_ABSENCE_ATTENDANCES_FK4') Then
163: --
164: -- The linked_absence_id does not refer to a valid absence_attendance_id.
165: --
166: fnd_message.set_name('SSP', 'SSP_35060_SSP_ABS_FK2');
167: --
168: ElsIf (p_constraint_name = 'PER_ABSENCE_ATTENDANCES_FK5') Then
169: --
170: -- The maternity_id is not valid.

Line 172: fnd_message.set_name('SSP', 'SSP_35061_SSP_ABS_FK1');

168: ElsIf (p_constraint_name = 'PER_ABSENCE_ATTENDANCES_FK5') Then
169: --
170: -- The maternity_id is not valid.
171: --
172: fnd_message.set_name('SSP', 'SSP_35061_SSP_ABS_FK1');
173: --
174: ElsIf (p_constraint_name = 'SSP_ABA_SICKNESS_END_DATE') Then
175: --
176: -- date_end must be specified if sickness_end_date is specified, and

Line 179: fnd_message.set_name('SSP', 'SSP_35062_ABS_SICK_END_DATE');

175: --
176: -- date_end must be specified if sickness_end_date is specified, and
177: -- date_end cannot be after sickness_end_date
178: --
179: fnd_message.set_name('SSP', 'SSP_35062_ABS_SICK_END_DATE');
180: --
181: ElsIf (p_constraint_name = 'SSP_ABA_MATERNITY_NOT_SICKNESS') Then
182: --
183: -- Cannot mix maternity and sickness attributes for an absence.

Line 185: fnd_message.set_name('SSP', 'SSP_35063_MAT_NOT_SICKNESS');

181: ElsIf (p_constraint_name = 'SSP_ABA_MATERNITY_NOT_SICKNESS') Then
182: --
183: -- Cannot mix maternity and sickness attributes for an absence.
184: --
185: fnd_message.set_name('SSP', 'SSP_35063_MAT_NOT_SICKNESS');
186: --
187: ElsIf (p_constraint_name = 'SSP_ABA_START_AND_END_DATES') Then
188: --
189: -- Date_start must be before date_end

Line 191: fnd_message.set_name('SSP', 'SSP_35064_ABS_START_AND_END');

187: ElsIf (p_constraint_name = 'SSP_ABA_START_AND_END_DATES') Then
188: --
189: -- Date_start must be before date_end
190: --
191: fnd_message.set_name('SSP', 'SSP_35064_ABS_START_AND_END');
192: --
193: ElsIf (p_constraint_name = 'SSP_ABA_SICKNESS_START_DATE') Then
194: --
195: -- The sickness start date must not be after the absence date start

Line 197: fnd_message.set_name('SSP', 'SSP_36066_ABS_SICK_START_DATE');

193: ElsIf (p_constraint_name = 'SSP_ABA_SICKNESS_START_DATE') Then
194: --
195: -- The sickness start date must not be after the absence date start
196: --
197: fnd_message.set_name('SSP', 'SSP_36066_ABS_SICK_START_DATE');
198: --
199: ElsIf (p_constraint_name = 'SSP_ABA_SICK_NOTIFICATION_DATE') Then
200: --
201: -- The notification date must be on or after the sickness start date.

Line 203: fnd_message.set_name('SSP', 'SSP_35067_ABS_SICK_NOTIF_DATE');

199: ElsIf (p_constraint_name = 'SSP_ABA_SICK_NOTIFICATION_DATE') Then
200: --
201: -- The notification date must be on or after the sickness start date.
202: --
203: fnd_message.set_name('SSP', 'SSP_35067_ABS_SICK_NOTIF_DATE');
204: --
205: ElsIf (p_constraint_name = 'SSP_ABA_TIME_START_FORMAT') Then
206: --
207: -- The time format is incorrect.

Line 209: fnd_message.set_name('SSP', 'SSP_36069_TIME_FORMAT');

205: ElsIf (p_constraint_name = 'SSP_ABA_TIME_START_FORMAT') Then
206: --
207: -- The time format is incorrect.
208: --
209: fnd_message.set_name('SSP', 'SSP_36069_TIME_FORMAT');
210: --
211: ElsIf (p_constraint_name = 'SSP_ABA_TIME_END_FORMAT') Then
212: --
213: -- The time format is incorrect.

Line 215: fnd_message.set_name('SSP', 'SSP_36069_TIME_FORMAT');

211: ElsIf (p_constraint_name = 'SSP_ABA_TIME_END_FORMAT') Then
212: --
213: -- The time format is incorrect.
214: --
215: fnd_message.set_name('SSP', 'SSP_36069_TIME_FORMAT');
216: --
217: ElsIf (p_constraint_name = 'SSP_ABA_SICKNESS_ATTRIBUTES') Then
218: --
219: -- An invalid combination of attributes have been entered.

Line 221: fnd_message.set_name('SSP', 'SSP_36072_ABS_SICK_ATTRIBUTES');

217: ElsIf (p_constraint_name = 'SSP_ABA_SICKNESS_ATTRIBUTES') Then
218: --
219: -- An invalid combination of attributes have been entered.
220: --
221: fnd_message.set_name('SSP', 'SSP_36072_ABS_SICK_ATTRIBUTES');
222: --
223: ElsIf (p_constraint_name = 'SSP_35037_PIW_BROKEN') Then
224: --
225: -- The linked series of sickness absences has been disrupted.

Line 227: fnd_message.set_name('SSP', 'SSP_35037_PIW_BROKEN');

223: ElsIf (p_constraint_name = 'SSP_35037_PIW_BROKEN') Then
224: --
225: -- The linked series of sickness absences has been disrupted.
226: --
227: fnd_message.set_name('SSP', 'SSP_35037_PIW_BROKEN');
228: --
229: Else
230: --
231: -- A constraint has been violated which is not explicitly handled by this

Line 234: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

230: --
231: -- A constraint has been violated which is not explicitly handled by this
232: -- code.
233: --
234: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
235: fnd_message.set_token('PROCEDURE',l_proc);
236: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
237: --
238: End If;

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

231: -- A constraint has been violated which is not explicitly handled by this
232: -- code.
233: --
234: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
235: fnd_message.set_token('PROCEDURE',l_proc);
236: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
237: --
238: End If;
239: --

Line 236: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);

232: -- code.
233: --
234: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
235: fnd_message.set_token('PROCEDURE',l_proc);
236: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
237: --
238: End If;
239: --
240: fnd_message.raise_error;

Line 240: fnd_message.raise_error;

236: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
237: --
238: End If;
239: --
240: fnd_message.raise_error;
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: --
244: End constraint_error;

Line 442: fnd_message.set_name ('SSP', 'SSP_36812_APL_ABS_END');

438: if l_maternity.leave_type = 'AB' then
439:
440: if (nvl(p_end_date, hr_api.g_sot) >= add_months(l_maternity.actual_birth_date, 12)) then
441: hr_utility.set_location ('End date beyond 12 months of birth date:'||l_maternity.actual_birth_date,2);
442: fnd_message.set_name ('SSP', 'SSP_36812_APL_ABS_END');
443: fnd_message.raise_error;
444: end if;
445:
446: select decode(l_maternity.partner_death_date,null,to_number (ele1.element_information12),to_number (ele1.element_information13))

Line 443: fnd_message.raise_error;

439:
440: if (nvl(p_end_date, hr_api.g_sot) >= add_months(l_maternity.actual_birth_date, 12)) then
441: hr_utility.set_location ('End date beyond 12 months of birth date:'||l_maternity.actual_birth_date,2);
442: fnd_message.set_name ('SSP', 'SSP_36812_APL_ABS_END');
443: fnd_message.raise_error;
444: end if;
445:
446: select decode(l_maternity.partner_death_date,null,to_number (ele1.element_information12),to_number (ele1.element_information13))
447: into l_apl_max_weeks

Line 456: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');

452:
453: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);
454: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then
455: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);
456: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');
457: fnd_message.raise_error;
458: end if;
459:
460: end if; -- End of leave type AB validations

Line 457: fnd_message.raise_error;

453: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);
454: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then
455: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);
456: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');
457: fnd_message.raise_error;
458: end if;
459:
460: end if; -- End of leave type AB validations
461:

Line 465: fnd_message.set_name ('SSP', 'SSP_36812_APL_ABS_END');

461:
462: if l_maternity.leave_type = 'AA' then
463: if (nvl(p_end_date, hr_api.g_sot) >= add_months(l_maternity.placement_date, 12)) then
464: hr_utility.set_location ('End date beyond 12 months of placement date:'||l_maternity.placement_date,2);
465: fnd_message.set_name ('SSP', 'SSP_36812_APL_ABS_END');
466: fnd_message.raise_error;
467: end if;
468:
469: select decode(l_maternity.partner_death_date,null,to_number (ele1.element_information11),to_number (ele1.element_information12))

Line 466: fnd_message.raise_error;

462: if l_maternity.leave_type = 'AA' then
463: if (nvl(p_end_date, hr_api.g_sot) >= add_months(l_maternity.placement_date, 12)) then
464: hr_utility.set_location ('End date beyond 12 months of placement date:'||l_maternity.placement_date,2);
465: fnd_message.set_name ('SSP', 'SSP_36812_APL_ABS_END');
466: fnd_message.raise_error;
467: end if;
468:
469: select decode(l_maternity.partner_death_date,null,to_number (ele1.element_information11),to_number (ele1.element_information12))
470: into l_apl_max_weeks

Line 479: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');

475:
476: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);
477: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then
478: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);
479: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');
480: fnd_message.raise_error;
481: end if;
482:
483: end if; -- End of leave type AA validations

Line 480: fnd_message.raise_error;

476: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);
477: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then
478: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);
479: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');
480: fnd_message.raise_error;
481: end if;
482:
483: end if; -- End of leave type AA validations
484: /* Bug fix 12850183 End */

Line 1509: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

1505: )
1506: then
1507: return;
1508: else
1509: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1510: fnd_message.raise_error;
1511: end if;
1512: END Lock_Row;
1513:

Line 1510: fnd_message.raise_error;

1506: then
1507: return;
1508: else
1509: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1510: fnd_message.raise_error;
1511: end if;
1512: END Lock_Row;
1513:
1514:

Line 2917: fnd_message.set_name('SSP','SSP_35032_NO_RELATED_MATERNITY');

2913: end LOOP;
2914:
2915: if counter = 0 then
2916: -- there was no maternity record
2917: fnd_message.set_name('SSP','SSP_35032_NO_RELATED_MATERNITY');
2918: fnd_message.raise_error;
2919: return(FALSE);
2920: elsif counter > 1 then
2921: -- There are multiple maternity records

Line 2918: fnd_message.raise_error;

2914:
2915: if counter = 0 then
2916: -- there was no maternity record
2917: fnd_message.set_name('SSP','SSP_35032_NO_RELATED_MATERNITY');
2918: fnd_message.raise_error;
2919: return(FALSE);
2920: elsif counter > 1 then
2921: -- There are multiple maternity records
2922: p_smp_due_date := null;

Line 2965: fnd_message.set_name('SSP', 'SSP_35031_MAT_ABS_DATE');

2961: --
2962: if p_date_start < least(maternity.QW, maternity.MPP)
2963: and maternity.leave_type = 'MA'
2964: then
2965: fnd_message.set_name('SSP', 'SSP_35031_MAT_ABS_DATE');
2966: fnd_message.raise_error;
2967: end if;
2968:
2969: end if;

Line 2966: fnd_message.raise_error;

2962: if p_date_start < least(maternity.QW, maternity.MPP)
2963: and maternity.leave_type = 'MA'
2964: then
2965: fnd_message.set_name('SSP', 'SSP_35031_MAT_ABS_DATE');
2966: fnd_message.raise_error;
2967: end if;
2968:
2969: end if;
2970: --

Line 3029: fnd_message.set_name('SSP', 'SSP_36810_APL_CONTINOUS_EMPL');

3025:
3026: if period_of_service%notfound then
3027: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',4);
3028: close period_of_service;
3029: fnd_message.set_name('SSP', 'SSP_36810_APL_CONTINOUS_EMPL');
3030: fnd_message.raise_error;
3031: end if;
3032: close period_of_service;
3033: end if;

Line 3030: fnd_message.raise_error;

3026: if period_of_service%notfound then
3027: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',4);
3028: close period_of_service;
3029: fnd_message.set_name('SSP', 'SSP_36810_APL_CONTINOUS_EMPL');
3030: fnd_message.raise_error;
3031: end if;
3032: close period_of_service;
3033: end if;
3034: close csr_maternity;

Line 3061: fnd_message.set_name('SSP','SSP_36073_PREG_RELATED_ILLNESS');

3057: hr_utility.set_location('per_absence_attendances_pkg.chk_related_maernity',1);
3058: open c1;
3059: fetch c1 into c1_rec;
3060: if c1%NOTFOUND then
3061: fnd_message.set_name('SSP','SSP_36073_PREG_RELATED_ILLNESS');
3062: fnd_message.raise_error;
3063: end if;
3064: close c1;
3065: END check_related_maternity;

Line 3062: fnd_message.raise_error;

3058: open c1;
3059: fetch c1 into c1_rec;
3060: if c1%NOTFOUND then
3061: fnd_message.set_name('SSP','SSP_36073_PREG_RELATED_ILLNESS');
3062: fnd_message.raise_error;
3063: end if;
3064: close c1;
3065: END check_related_maternity;
3066:

Line 3092: fnd_message.set_name('SSP','SSP_35033_ATTACHED_SICK_NOTE');

3088: hr_utility.set_location('per_absence_attendances_pkg.chk_evd_before_del',1);
3089: open c1;
3090: fetch c1 into c1_rec;
3091: if c1%FOUND then
3092: fnd_message.set_name('SSP','SSP_35033_ATTACHED_SICK_NOTE');
3093: fnd_message.raise_error;
3094: end if;
3095: close c1;
3096: END check_evd_before_del;

Line 3093: fnd_message.raise_error;

3089: open c1;
3090: fetch c1 into c1_rec;
3091: if c1%FOUND then
3092: fnd_message.set_name('SSP','SSP_35033_ATTACHED_SICK_NOTE');
3093: fnd_message.raise_error;
3094: end if;
3095: close c1;
3096: END check_evd_before_del;
3097: