APPS.SSP_MAT_BUS dependencies on FND_MESSAGE

Line 58: fnd_message.set_name ('SSP' , 'SSP_35057_BAD_PERSON_ID' ) ;

54: --
55: -- The person id is not valid
56: --
57: close csr_person;
58: fnd_message.set_name ('SSP' , 'SSP_35057_BAD_PERSON_ID' ) ;
59: fnd_message.raise_error;
60: --
61: elsif p_sex <> 'F' then
62: --

Line 59: fnd_message.raise_error;

55: -- The person id is not valid
56: --
57: close csr_person;
58: fnd_message.set_name ('SSP' , 'SSP_35057_BAD_PERSON_ID' ) ;
59: fnd_message.raise_error;
60: --
61: elsif p_sex <> 'F' then
62: --
63: -- The person is not female (and therefore may not have maternity)

Line 66: fnd_message.set_name ('SSP', 'SSP_35002_PER_NOT_FEMALE');

62: --
63: -- The person is not female (and therefore may not have maternity)
64: --
65: close csr_person;
66: fnd_message.set_name ('SSP', 'SSP_35002_PER_NOT_FEMALE');
67: fnd_message.raise_error;
68: --
69: else
70: close csr_person;

Line 67: fnd_message.raise_error;

63: -- The person is not female (and therefore may not have maternity)
64: --
65: close csr_person;
66: fnd_message.set_name ('SSP', 'SSP_35002_PER_NOT_FEMALE');
67: fnd_message.raise_error;
68: --
69: else
70: close csr_person;
71: end if;

Line 119: fnd_message.set_name ('SSP', 'SSP_35009_DUP_DUE_DATE');

115: --
116: if csr_duplicate_due_date%FOUND then
117: --
118: close csr_duplicate_due_date;
119: fnd_message.set_name ('SSP', 'SSP_35009_DUP_DUE_DATE');
120: fnd_message.raise_error;
121: --
122: end if;
123: --

Line 120: fnd_message.raise_error;

116: if csr_duplicate_due_date%FOUND then
117: --
118: close csr_duplicate_due_date;
119: fnd_message.set_name ('SSP', 'SSP_35009_DUP_DUE_DATE');
120: fnd_message.raise_error;
121: --
122: end if;
123: --
124: close csr_duplicate_due_date;

Line 142: fnd_message.set_name('SSP','SSP_35003_INV_FUTURE_DATE');

138:
139: Procedure check_actual_birth (p_actual_birth_date in date) is
140: BEGIN
141: if p_actual_birth_date > SYSDATE then
142: fnd_message.set_name('SSP','SSP_35003_INV_FUTURE_DATE');
143: fnd_message.raise_error;
144: end if;
145: END check_actual_birth;
146: --

Line 143: fnd_message.raise_error;

139: Procedure check_actual_birth (p_actual_birth_date in date) is
140: BEGIN
141: if p_actual_birth_date > SYSDATE then
142: fnd_message.set_name('SSP','SSP_35003_INV_FUTURE_DATE');
143: fnd_message.raise_error;
144: end if;
145: END check_actual_birth;
146: --
147: -- ----------------------------------------------------------------------------

Line 159: fnd_message.set_name ('SSP', 'SSP_35004_LIVE_BIRTH_FLAG');

155:
156: Procedure check_live_birth (p_live_birth_flag in out nocopy varchar2, p_actual_birth_date in date) is
157: BEGIN
158: if p_live_birth_flag = 'N' and p_actual_birth_date is null then
159: fnd_message.set_name ('SSP', 'SSP_35004_LIVE_BIRTH_FLAG');
160: fnd_message.raise_error;
161: p_live_birth_flag := 'Y';
162: end if;
163: END check_live_birth;

Line 160: fnd_message.raise_error;

156: Procedure check_live_birth (p_live_birth_flag in out nocopy varchar2, p_actual_birth_date in date) is
157: BEGIN
158: if p_live_birth_flag = 'N' and p_actual_birth_date is null then
159: fnd_message.set_name ('SSP', 'SSP_35004_LIVE_BIRTH_FLAG');
160: fnd_message.raise_error;
161: p_live_birth_flag := 'Y';
162: end if;
163: END check_live_birth;
164: --

Line 178: fnd_message.set_name ('SSP', 'SSP_35012_EARLY_BIRTH_NOTIFIC');

174: Procedure check_date_notified (p_notification_of_birth_date in date,
175: p_actual_birth_date in date) is
176: BEGIN
177: if p_notification_of_birth_date < p_actual_birth_date then
178: fnd_message.set_name ('SSP', 'SSP_35012_EARLY_BIRTH_NOTIFIC');
179: fnd_message.raise_error;
180: elsif p_notification_of_birth_date > SYSDATE then
181: fnd_message.set_name ('SSP', 'SSP_35019_INV_NOTIF_DATE');
182: fnd_message.raise_error;

Line 179: fnd_message.raise_error;

175: p_actual_birth_date in date) is
176: BEGIN
177: if p_notification_of_birth_date < p_actual_birth_date then
178: fnd_message.set_name ('SSP', 'SSP_35012_EARLY_BIRTH_NOTIFIC');
179: fnd_message.raise_error;
180: elsif p_notification_of_birth_date > SYSDATE then
181: fnd_message.set_name ('SSP', 'SSP_35019_INV_NOTIF_DATE');
182: fnd_message.raise_error;
183: end if;

Line 181: fnd_message.set_name ('SSP', 'SSP_35019_INV_NOTIF_DATE');

177: if p_notification_of_birth_date < p_actual_birth_date then
178: fnd_message.set_name ('SSP', 'SSP_35012_EARLY_BIRTH_NOTIFIC');
179: fnd_message.raise_error;
180: elsif p_notification_of_birth_date > SYSDATE then
181: fnd_message.set_name ('SSP', 'SSP_35019_INV_NOTIF_DATE');
182: fnd_message.raise_error;
183: end if;
184: END check_date_notified;
185: --

Line 182: fnd_message.raise_error;

178: fnd_message.set_name ('SSP', 'SSP_35012_EARLY_BIRTH_NOTIFIC');
179: fnd_message.raise_error;
180: elsif p_notification_of_birth_date > SYSDATE then
181: fnd_message.set_name ('SSP', 'SSP_35019_INV_NOTIF_DATE');
182: fnd_message.raise_error;
183: end if;
184: END check_date_notified;
185: --
186: -- -----------------------------------------------------------------------------

Line 204: fnd_message.set_name('SSP', 'SSP_35013_INV_EVNT_RET_DATE');

200: p_mpp_start_date in date,
201: p_earliest_mpp_start in date) is
202: BEGIN
203: if p_intend_to_return = 'N' and p_stated_return_date is not null then
204: fnd_message.set_name('SSP', 'SSP_35013_INV_EVNT_RET_DATE');
205: fnd_message.raise_error;
206: elsif p_stated_return_date < nvl(p_mpp_start_date, p_stated_return_date) then
207: fnd_message.set_name ('SSP', 'SSP_35006_RET_DATE_LT_MPP');
208: fnd_message.raise_error;

Line 205: fnd_message.raise_error;

201: p_earliest_mpp_start in date) is
202: BEGIN
203: if p_intend_to_return = 'N' and p_stated_return_date is not null then
204: fnd_message.set_name('SSP', 'SSP_35013_INV_EVNT_RET_DATE');
205: fnd_message.raise_error;
206: elsif p_stated_return_date < nvl(p_mpp_start_date, p_stated_return_date) then
207: fnd_message.set_name ('SSP', 'SSP_35006_RET_DATE_LT_MPP');
208: fnd_message.raise_error;
209: elsif p_stated_return_date < nvl(p_earliest_mpp_start, p_stated_return_date) then

Line 207: fnd_message.set_name ('SSP', 'SSP_35006_RET_DATE_LT_MPP');

203: if p_intend_to_return = 'N' and p_stated_return_date is not null then
204: fnd_message.set_name('SSP', 'SSP_35013_INV_EVNT_RET_DATE');
205: fnd_message.raise_error;
206: elsif p_stated_return_date < nvl(p_mpp_start_date, p_stated_return_date) then
207: fnd_message.set_name ('SSP', 'SSP_35006_RET_DATE_LT_MPP');
208: fnd_message.raise_error;
209: elsif p_stated_return_date < nvl(p_earliest_mpp_start, p_stated_return_date) then
210: fnd_message.set_name ('SSP','SSP_35007_RET_DTE_LT_EMPSD');
211: fnd_message.raise_error;

Line 208: fnd_message.raise_error;

204: fnd_message.set_name('SSP', 'SSP_35013_INV_EVNT_RET_DATE');
205: fnd_message.raise_error;
206: elsif p_stated_return_date < nvl(p_mpp_start_date, p_stated_return_date) then
207: fnd_message.set_name ('SSP', 'SSP_35006_RET_DATE_LT_MPP');
208: fnd_message.raise_error;
209: elsif p_stated_return_date < nvl(p_earliest_mpp_start, p_stated_return_date) then
210: fnd_message.set_name ('SSP','SSP_35007_RET_DTE_LT_EMPSD');
211: fnd_message.raise_error;
212: end if;

Line 210: fnd_message.set_name ('SSP','SSP_35007_RET_DTE_LT_EMPSD');

206: elsif p_stated_return_date < nvl(p_mpp_start_date, p_stated_return_date) then
207: fnd_message.set_name ('SSP', 'SSP_35006_RET_DATE_LT_MPP');
208: fnd_message.raise_error;
209: elsif p_stated_return_date < nvl(p_earliest_mpp_start, p_stated_return_date) then
210: fnd_message.set_name ('SSP','SSP_35007_RET_DTE_LT_EMPSD');
211: fnd_message.raise_error;
212: end if;
213: END check_stated_ret_date;
214: --

Line 211: fnd_message.raise_error;

207: fnd_message.set_name ('SSP', 'SSP_35006_RET_DATE_LT_MPP');
208: fnd_message.raise_error;
209: elsif p_stated_return_date < nvl(p_earliest_mpp_start, p_stated_return_date) then
210: fnd_message.set_name ('SSP','SSP_35007_RET_DTE_LT_EMPSD');
211: fnd_message.raise_error;
212: end if;
213: END check_stated_ret_date;
214: --
215: --------------------------------------------------------------------------------

Line 231: fnd_message.set_name ('PER', 'SSP_35114_SMCAL_EMPP_TOO_EARLY');

227: p_earliest_mpp_start_date in date,
228: p_actual_birth_date in date) is
229: BEGIN
230: if p_mpp_start_date < p_earliest_mpp_start_date and p_actual_birth_date IS NULL then
231: fnd_message.set_name ('PER', 'SSP_35114_SMCAL_EMPP_TOO_EARLY');
232: fnd_message.raise_error;
233: end if;
234:
235: if NOT(p_actual_birth_date IS NULL) then

Line 232: fnd_message.raise_error;

228: p_actual_birth_date in date) is
229: BEGIN
230: if p_mpp_start_date < p_earliest_mpp_start_date and p_actual_birth_date IS NULL then
231: fnd_message.set_name ('PER', 'SSP_35114_SMCAL_EMPP_TOO_EARLY');
232: fnd_message.raise_error;
233: end if;
234:
235: if NOT(p_actual_birth_date IS NULL) then
236: if (p_mpp_start_date IS NULL) OR (p_mpp_start_date < p_earliest_mpp_start_date) THEN

Line 288: fnd_message.set_name('SSP','SSP_36078_MPP_RESET_MPP');

284: p_actual_birth_date > p_prev_mpp_start_date and
285: p_actual_birth_date is not null then
286: -- user cannot reset the value of MPP
287: if p_prev_mpp_start_date <> p_mpp_start_date then
288: fnd_message.set_name('SSP','SSP_36078_MPP_RESET_MPP');
289: fnd_message.raise_error;
290: end if;
291: elsif ( p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00')
292: and p_mpp_start_date = p_actual_birth_date + 1 ) or

Line 289: fnd_message.raise_error;

285: p_actual_birth_date is not null then
286: -- user cannot reset the value of MPP
287: if p_prev_mpp_start_date <> p_mpp_start_date then
288: fnd_message.set_name('SSP','SSP_36078_MPP_RESET_MPP');
289: fnd_message.raise_error;
290: end if;
291: elsif ( p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00')
292: and p_mpp_start_date = p_actual_birth_date + 1 ) or
293: ( pregnancy_related_absences%FOUND and

Line 305: fnd_message.set_name('SSP','SSP_36077_MPP_PREMATURE_DAY');

301: CLOSE pregnancy_related_absences;
302: null;
303: else
304: CLOSE pregnancy_related_absences;
305: fnd_message.set_name('SSP','SSP_36077_MPP_PREMATURE_DAY');
306: fnd_message.raise_error;
307: end if;
308: -- This condition checks if the baby was born during the MPP, if yes then
309: -- the user cannot set the MPP start date here

Line 306: fnd_message.raise_error;

302: null;
303: else
304: CLOSE pregnancy_related_absences;
305: fnd_message.set_name('SSP','SSP_36077_MPP_PREMATURE_DAY');
306: fnd_message.raise_error;
307: end if;
308: -- This condition checks if the baby was born during the MPP, if yes then
309: -- the user cannot set the MPP start date here
310: /*

Line 314: fnd_message.set_name('SSP','SSP_36079_MPP_SICKNESS_DAY');

310: /*
311: elsif pregnancy_related_absences%FOUND and
312: p_mpp_start_date <> l_pregnancy_related_illness.sickness_start_date then
313: CLOSE pregnancy_related_absences;
314: fnd_message.set_name('SSP','SSP_36079_MPP_SICKNESS_DAY');
315: fnd_message.raise_error;
316: */
317: -- begin bug fix 5331152
318: elsif pregnancy_related_absences%FOUND and

Line 315: fnd_message.raise_error;

311: elsif pregnancy_related_absences%FOUND and
312: p_mpp_start_date <> l_pregnancy_related_illness.sickness_start_date then
313: CLOSE pregnancy_related_absences;
314: fnd_message.set_name('SSP','SSP_36079_MPP_SICKNESS_DAY');
315: fnd_message.raise_error;
316: */
317: -- begin bug fix 5331152
318: elsif pregnancy_related_absences%FOUND and
319: p_mpp_start_date = l_pregnancy_related_illness.sickness_start_date then

Line 321: fnd_message.set_name('SSP','SSP_35051_MPP_ILLNESS_DATE');

317: -- begin bug fix 5331152
318: elsif pregnancy_related_absences%FOUND and
319: p_mpp_start_date = l_pregnancy_related_illness.sickness_start_date then
320: CLOSE pregnancy_related_absences;
321: fnd_message.set_name('SSP','SSP_35051_MPP_ILLNESS_DATE');
322: fnd_message.raise_error;
323: elsif pregnancy_related_absences%FOUND and
324: p_mpp_start_date = l_pregnancy_related_illness.sickness_start_date + 1 then
325: CLOSE pregnancy_related_absences;

Line 322: fnd_message.raise_error;

318: elsif pregnancy_related_absences%FOUND and
319: p_mpp_start_date = l_pregnancy_related_illness.sickness_start_date then
320: CLOSE pregnancy_related_absences;
321: fnd_message.set_name('SSP','SSP_35051_MPP_ILLNESS_DATE');
322: fnd_message.raise_error;
323: elsif pregnancy_related_absences%FOUND and
324: p_mpp_start_date = l_pregnancy_related_illness.sickness_start_date + 1 then
325: CLOSE pregnancy_related_absences;
326: null;

Line 332: fnd_message.set_name('SSP','SSP_36077_MPP_PREMATURE_DAY');

328: elsif p_due_date >= fnd_date.canonical_to_date('2003/04/06 00:00:00') and
329: p_actual_birth_date is not null and
330: p_mpp_start_date <> p_actual_birth_date + 1 then
331: CLOSE pregnancy_related_absences;
332: fnd_message.set_name('SSP','SSP_36077_MPP_PREMATURE_DAY');
333: fnd_message.raise_error;
334: elsif to_char(to_date(to_char(p_mpp_start_date,'DD/MM/YYYY'),'DD/MM/YYYY'),'fmDAY') <> l_sunday
335: and
336: p_due_date < fnd_date.canonical_to_date('2007/04/01 00:00:00') then

Line 333: fnd_message.raise_error;

329: p_actual_birth_date is not null and
330: p_mpp_start_date <> p_actual_birth_date + 1 then
331: CLOSE pregnancy_related_absences;
332: fnd_message.set_name('SSP','SSP_36077_MPP_PREMATURE_DAY');
333: fnd_message.raise_error;
334: elsif to_char(to_date(to_char(p_mpp_start_date,'DD/MM/YYYY'),'DD/MM/YYYY'),'fmDAY') <> l_sunday
335: and
336: p_due_date < fnd_date.canonical_to_date('2007/04/01 00:00:00') then
337: CLOSE pregnancy_related_absences;

Line 338: fnd_message.set_name('SSP','SSP_35054_MPP_NOT_SUNDAY');

334: elsif to_char(to_date(to_char(p_mpp_start_date,'DD/MM/YYYY'),'DD/MM/YYYY'),'fmDAY') <> l_sunday
335: and
336: p_due_date < fnd_date.canonical_to_date('2007/04/01 00:00:00') then
337: CLOSE pregnancy_related_absences;
338: fnd_message.set_name('SSP','SSP_35054_MPP_NOT_SUNDAY');
339: fnd_message.raise_error;
340: end if;
341:
342: END check_MPP_start_date_2;

Line 339: fnd_message.raise_error;

335: and
336: p_due_date < fnd_date.canonical_to_date('2007/04/01 00:00:00') then
337: CLOSE pregnancy_related_absences;
338: fnd_message.set_name('SSP','SSP_35054_MPP_NOT_SUNDAY');
339: fnd_message.raise_error;
340: end if;
341:
342: END check_MPP_start_date_2;
343:

Line 361: fnd_message.set_name ('SSP', 'SSP_35014_FWD_MPP_START');

357: then
358: p_mpp_start_date := p_start_date_mat_allow;
359: elsif p_mpp_start_date > nvl(p_start_date_mat_allow, p_mpp_start_date)
360: then
361: fnd_message.set_name ('SSP', 'SSP_35014_FWD_MPP_START');
362: fnd_message.raise_error;
363: end if;
364: END check_forward_MPP_date;
365: --

Line 362: fnd_message.raise_error;

358: p_mpp_start_date := p_start_date_mat_allow;
359: elsif p_mpp_start_date > nvl(p_start_date_mat_allow, p_mpp_start_date)
360: then
361: fnd_message.set_name ('SSP', 'SSP_35014_FWD_MPP_START');
362: fnd_message.raise_error;
363: end if;
364: END check_forward_MPP_date;
365: --
366: -- -----------------------------------------------------------------------------

Line 462: fnd_message.set_name ('SSP', 'SSP_36075_EVIDENCE_NOW_INVALID');

458: l_chk_date := p_ewc - l_element_details.earliest_SMP_evidence;
459:
460: for csr_ev in csr_evidence loop
461: if csr_ev.evidence_date < l_chk_date then
462: fnd_message.set_name ('SSP', 'SSP_36075_EVIDENCE_NOW_INVALID');
463: fnd_message.raise_error;
464: end if;
465: end loop;
466: --

Line 463: fnd_message.raise_error;

459:
460: for csr_ev in csr_evidence loop
461: if csr_ev.evidence_date < l_chk_date then
462: fnd_message.set_name ('SSP', 'SSP_36075_EVIDENCE_NOW_INVALID');
463: fnd_message.raise_error;
464: end if;
465: end loop;
466: --
467: END evd_before_ewc_due_date_change;

Line 489: fnd_message.set_name ('SSP', 'SSP_35028_LATE_EVID_DATE');

485: get_SMP_element_details(p_effective_date, p_element_name, l_element_details);
486: --
487: l_chk_date := p_ewc - l_element_details.earliest_SMP_evidence;
488: if p_evidence_date < l_chk_date then
489: fnd_message.set_name ('SSP', 'SSP_35028_LATE_EVID_DATE');
490: fnd_message.raise_error;
491: end if;
492: END evd_before_ewc;
493:

Line 490: fnd_message.raise_error;

486: --
487: l_chk_date := p_ewc - l_element_details.earliest_SMP_evidence;
488: if p_evidence_date < l_chk_date then
489: fnd_message.set_name ('SSP', 'SSP_35028_LATE_EVID_DATE');
490: fnd_message.raise_error;
491: end if;
492: END evd_before_ewc;
493:
494: -- -----------------------------------------------------------------------------

Line 560: fnd_message.set_name('SSP','SSP_36094_CHILD_EXPECTED_DATE');

556: PROCEDURE CHECK_CHILD_EXPECTED_DATE(p_due_date in date,
557: p_matching_date in date) is
558: Begin
559: If p_due_date < p_matching_date then
560: fnd_message.set_name('SSP','SSP_36094_CHILD_EXPECTED_DATE');
561: fnd_message.raise_error;
562: End if;
563: End;
564:

Line 561: fnd_message.raise_error;

557: p_matching_date in date) is
558: Begin
559: If p_due_date < p_matching_date then
560: fnd_message.set_name('SSP','SSP_36094_CHILD_EXPECTED_DATE');
561: fnd_message.raise_error;
562: End if;
563: End;
564:
565: PROCEDURE CHECK_APP_START_DATE(p_mpp_start_date in date,

Line 571: fnd_message.set_name('SSP','SSP_36085_APP_DATE_PLACEMENT');

567: p_due_date in date) is
568: Begin
569:
570: If p_placement_date is not null and p_mpp_start_date > p_placement_date then
571: fnd_message.set_name('SSP','SSP_36085_APP_DATE_PLACEMENT');
572: fnd_message.raise_error;
573: end if;
574:
575: If p_mpp_start_date < ssp_sap_pkg.EARLIEST_APP_START_DATE(p_due_date) then

Line 572: fnd_message.raise_error;

568: Begin
569:
570: If p_placement_date is not null and p_mpp_start_date > p_placement_date then
571: fnd_message.set_name('SSP','SSP_36085_APP_DATE_PLACEMENT');
572: fnd_message.raise_error;
573: end if;
574:
575: If p_mpp_start_date < ssp_sap_pkg.EARLIEST_APP_START_DATE(p_due_date) then
576: fnd_message.set_name('SSP','SSP_36083_APP_DATE_EARLY');

Line 576: fnd_message.set_name('SSP','SSP_36083_APP_DATE_EARLY');

572: fnd_message.raise_error;
573: end if;
574:
575: If p_mpp_start_date < ssp_sap_pkg.EARLIEST_APP_START_DATE(p_due_date) then
576: fnd_message.set_name('SSP','SSP_36083_APP_DATE_EARLY');
577: fnd_message.raise_error;
578: End if;
579:
580: If p_placement_date is null and p_mpp_start_date > p_due_date then

Line 577: fnd_message.raise_error;

573: end if;
574:
575: If p_mpp_start_date < ssp_sap_pkg.EARLIEST_APP_START_DATE(p_due_date) then
576: fnd_message.set_name('SSP','SSP_36083_APP_DATE_EARLY');
577: fnd_message.raise_error;
578: End if;
579:
580: If p_placement_date is null and p_mpp_start_date > p_due_date then
581: fnd_message.set_name('SSP','SSP_36098_APP_DATE_LATE');

Line 581: fnd_message.set_name('SSP','SSP_36098_APP_DATE_LATE');

577: fnd_message.raise_error;
578: End if;
579:
580: If p_placement_date is null and p_mpp_start_date > p_due_date then
581: fnd_message.set_name('SSP','SSP_36098_APP_DATE_LATE');
582: fnd_message.raise_error;
583: End if;
584:
585: End ;

Line 582: fnd_message.raise_error;

578: End if;
579:
580: If p_placement_date is null and p_mpp_start_date > p_due_date then
581: fnd_message.set_name('SSP','SSP_36098_APP_DATE_LATE');
582: fnd_message.raise_error;
583: End if;
584:
585: End ;
586:

Line 592: fnd_message.set_name('SSP','SSP_36090_PPP_DATE_PLACE_NULL');

588: p_placement_date in date,
589: p_due_date in date) is
590: begin
591: if p_placement_date is null and p_ppp_start_date is not null then
592: fnd_message.set_name('SSP','SSP_36090_PPP_DATE_PLACE_NULL');
593: fnd_message.raise_error;
594: end if;
595:
596: if p_ppp_start_date < ssp_pad_pkg.EARLIEST_PPP_START_DATE(p_placement_date)

Line 593: fnd_message.raise_error;

589: p_due_date in date) is
590: begin
591: if p_placement_date is null and p_ppp_start_date is not null then
592: fnd_message.set_name('SSP','SSP_36090_PPP_DATE_PLACE_NULL');
593: fnd_message.raise_error;
594: end if;
595:
596: if p_ppp_start_date < ssp_pad_pkg.EARLIEST_PPP_START_DATE(p_placement_date)
597: then

Line 598: fnd_message.set_name('SSP','SSP_36088_PPP_DATE_PLACE_EARLY');

594: end if;
595:
596: if p_ppp_start_date < ssp_pad_pkg.EARLIEST_PPP_START_DATE(p_placement_date)
597: then
598: fnd_message.set_name('SSP','SSP_36088_PPP_DATE_PLACE_EARLY');
599: fnd_message.raise_error;
600: end if;
601:
602: if p_ppp_start_date > ssp_pad_pkg.LATEST_PPP_START_DATE(p_placement_date)

Line 599: fnd_message.raise_error;

595:
596: if p_ppp_start_date < ssp_pad_pkg.EARLIEST_PPP_START_DATE(p_placement_date)
597: then
598: fnd_message.set_name('SSP','SSP_36088_PPP_DATE_PLACE_EARLY');
599: fnd_message.raise_error;
600: end if;
601:
602: if p_ppp_start_date > ssp_pad_pkg.LATEST_PPP_START_DATE(p_placement_date)
603: then

Line 604: fnd_message.set_name('SSP','SSP_36087_PPP_DATE_PLACE_LATE');

600: end if;
601:
602: if p_ppp_start_date > ssp_pad_pkg.LATEST_PPP_START_DATE(p_placement_date)
603: then
604: fnd_message.set_name('SSP','SSP_36087_PPP_DATE_PLACE_LATE');
605: fnd_message.raise_error;
606: end if;
607: end;
608:

Line 605: fnd_message.raise_error;

601:
602: if p_ppp_start_date > ssp_pad_pkg.LATEST_PPP_START_DATE(p_placement_date)
603: then
604: fnd_message.set_name('SSP','SSP_36087_PPP_DATE_PLACE_LATE');
605: fnd_message.raise_error;
606: end if;
607: end;
608:
609: PROCEDURE CHECK_PPP_START_DATE(p_ppp_start_date in date,

Line 615: fnd_message.set_name('SSP','SSP_36092_PPP_DATE_BIRTH_NULL');

611: p_ewc in date,
612: p_due_date in date) is
613: begin
614: if p_birth_date is null and p_ppp_start_date is not null then
615: fnd_message.set_name('SSP','SSP_36092_PPP_DATE_BIRTH_NULL');
616: fnd_message.raise_error;
617: end if;
618:
619: if p_ppp_start_date > ssp_pab_pkg.LATEST_PPP_START_DATE(p_birth_date,

Line 616: fnd_message.raise_error;

612: p_due_date in date) is
613: begin
614: if p_birth_date is null and p_ppp_start_date is not null then
615: fnd_message.set_name('SSP','SSP_36092_PPP_DATE_BIRTH_NULL');
616: fnd_message.raise_error;
617: end if;
618:
619: if p_ppp_start_date > ssp_pab_pkg.LATEST_PPP_START_DATE(p_birth_date,
620: p_ewc,

Line 623: fnd_message.set_name('SSP','SSP_36097_PPP_DATE_BIRTH_LATE');

619: if p_ppp_start_date > ssp_pab_pkg.LATEST_PPP_START_DATE(p_birth_date,
620: p_ewc,
621: p_due_date)
622: then
623: fnd_message.set_name('SSP','SSP_36097_PPP_DATE_BIRTH_LATE');
624: fnd_message.raise_error;
625: end if;
626:
627: if p_ppp_start_date < ssp_pab_pkg.EARLIEST_PPP_START_DATE(p_birth_date)

Line 624: fnd_message.raise_error;

620: p_ewc,
621: p_due_date)
622: then
623: fnd_message.set_name('SSP','SSP_36097_PPP_DATE_BIRTH_LATE');
624: fnd_message.raise_error;
625: end if;
626:
627: if p_ppp_start_date < ssp_pab_pkg.EARLIEST_PPP_START_DATE(p_birth_date)
628: then

Line 629: fnd_message.set_name('SSP','SSP_36096_PPP_DATE_BIRTH');

625: end if;
626:
627: if p_ppp_start_date < ssp_pab_pkg.EARLIEST_PPP_START_DATE(p_birth_date)
628: then
629: fnd_message.set_name('SSP','SSP_36096_PPP_DATE_BIRTH');
630: fnd_message.raise_error;
631: end if;
632:
633: end;

Line 630: fnd_message.raise_error;

626:
627: if p_ppp_start_date < ssp_pab_pkg.EARLIEST_PPP_START_DATE(p_birth_date)
628: then
629: fnd_message.set_name('SSP','SSP_36096_PPP_DATE_BIRTH');
630: fnd_message.raise_error;
631: end if;
632:
633: end;
634:

Line 642: fnd_message.set_name('SSP','SSP_36092_PPP_DATE_BIRTH_NULL');

638: p_partner_return_date in date,
639: p_mother_death_date in date) is
640: begin
641: /* if p_birth_date is null then
642: fnd_message.set_name('SSP','SSP_36092_PPP_DATE_BIRTH_NULL');
643: fnd_message.raise_error;
644: end if; */
645:
646: if p_aspp_start_date > ssp_apab_pkg.LATEST_ASPPP_START_DATE(p_birth_date,

Line 643: fnd_message.raise_error;

639: p_mother_death_date in date) is
640: begin
641: /* if p_birth_date is null then
642: fnd_message.set_name('SSP','SSP_36092_PPP_DATE_BIRTH_NULL');
643: fnd_message.raise_error;
644: end if; */
645:
646: if p_aspp_start_date > ssp_apab_pkg.LATEST_ASPPP_START_DATE(p_birth_date,
647: p_aspp_start_date,

Line 650: fnd_message.set_name('SSP','SSP_36797_APL_BIR_START_LATE');

646: if p_aspp_start_date > ssp_apab_pkg.LATEST_ASPPP_START_DATE(p_birth_date,
647: p_aspp_start_date,
648: p_partner_mpp_start)
649: then
650: fnd_message.set_name('SSP','SSP_36797_APL_BIR_START_LATE');
651: fnd_message.raise_error;
652: end if;
653:
654: if p_aspp_start_date < nvl(p_partner_return_date, p_aspp_start_date)

Line 651: fnd_message.raise_error;

647: p_aspp_start_date,
648: p_partner_mpp_start)
649: then
650: fnd_message.set_name('SSP','SSP_36797_APL_BIR_START_LATE');
651: fnd_message.raise_error;
652: end if;
653:
654: if p_aspp_start_date < nvl(p_partner_return_date, p_aspp_start_date)
655: then

Line 656: fnd_message.set_name('SSP','SSP_36800_APL_BEF_PARTNER');

652: end if;
653:
654: if p_aspp_start_date < nvl(p_partner_return_date, p_aspp_start_date)
655: then
656: fnd_message.set_name('SSP','SSP_36800_APL_BEF_PARTNER');
657: fnd_message.raise_error;
658: end if;
659:
660: if p_aspp_start_date < least(ssp_apab_pkg.EARLIEST_ASPPP_START_DATE(p_birth_date),

Line 657: fnd_message.raise_error;

653:
654: if p_aspp_start_date < nvl(p_partner_return_date, p_aspp_start_date)
655: then
656: fnd_message.set_name('SSP','SSP_36800_APL_BEF_PARTNER');
657: fnd_message.raise_error;
658: end if;
659:
660: if p_aspp_start_date < least(ssp_apab_pkg.EARLIEST_ASPPP_START_DATE(p_birth_date),
661: nvl(p_mother_death_date,hr_general.end_of_time))

Line 663: fnd_message.set_name('SSP','SSP_36796_APL_BIR_START_EARLY');

659:
660: if p_aspp_start_date < least(ssp_apab_pkg.EARLIEST_ASPPP_START_DATE(p_birth_date),
661: nvl(p_mother_death_date,hr_general.end_of_time))
662: then
663: fnd_message.set_name('SSP','SSP_36796_APL_BIR_START_EARLY');
664: fnd_message.raise_error;
665: end if;
666:
667: end;

Line 664: fnd_message.raise_error;

660: if p_aspp_start_date < least(ssp_apab_pkg.EARLIEST_ASPPP_START_DATE(p_birth_date),
661: nvl(p_mother_death_date,hr_general.end_of_time))
662: then
663: fnd_message.set_name('SSP','SSP_36796_APL_BIR_START_EARLY');
664: fnd_message.raise_error;
665: end if;
666:
667: end;
668:

Line 678: fnd_message.set_name('SSP','SSP_36090_PPP_DATE_PLACE_NULL');

674: begin
675:
676: /*
677: if p_placement_date is null and p_aspp_start_date is not null then
678: fnd_message.set_name('SSP','SSP_36090_PPP_DATE_PLACE_NULL');
679: fnd_message.raise_error;
680: end if;
681: */
682:

Line 679: fnd_message.raise_error;

675:
676: /*
677: if p_placement_date is null and p_aspp_start_date is not null then
678: fnd_message.set_name('SSP','SSP_36090_PPP_DATE_PLACE_NULL');
679: fnd_message.raise_error;
680: end if;
681: */
682:
683: if p_aspp_start_date > ssp_apad_pkg.LATEST_ASPPP_START_DATE(p_placement_date,

Line 686: fnd_message.set_name('SSP','SSP_36799_APL_ADO_START_LATE');

682:
683: if p_aspp_start_date > ssp_apad_pkg.LATEST_ASPPP_START_DATE(p_placement_date,
684: p_aspp_start_date)
685: then
686: fnd_message.set_name('SSP','SSP_36799_APL_ADO_START_LATE');
687: fnd_message.raise_error;
688: end if;
689:
690: if p_aspp_start_date < nvl(p_partner_return_date, p_aspp_start_date)

Line 687: fnd_message.raise_error;

683: if p_aspp_start_date > ssp_apad_pkg.LATEST_ASPPP_START_DATE(p_placement_date,
684: p_aspp_start_date)
685: then
686: fnd_message.set_name('SSP','SSP_36799_APL_ADO_START_LATE');
687: fnd_message.raise_error;
688: end if;
689:
690: if p_aspp_start_date < nvl(p_partner_return_date, p_aspp_start_date)
691: then

Line 692: fnd_message.set_name('SSP','SSP_36800_APL_BEF_PARTNER');

688: end if;
689:
690: if p_aspp_start_date < nvl(p_partner_return_date, p_aspp_start_date)
691: then
692: fnd_message.set_name('SSP','SSP_36800_APL_BEF_PARTNER');
693: fnd_message.raise_error;
694: end if;
695:
696: if p_aspp_start_date < least(ssp_apad_pkg.EARLIEST_ASPPP_START_DATE(p_placement_date),

Line 693: fnd_message.raise_error;

689:
690: if p_aspp_start_date < nvl(p_partner_return_date, p_aspp_start_date)
691: then
692: fnd_message.set_name('SSP','SSP_36800_APL_BEF_PARTNER');
693: fnd_message.raise_error;
694: end if;
695:
696: if p_aspp_start_date < least(ssp_apad_pkg.EARLIEST_ASPPP_START_DATE(p_placement_date),
697: nvl(p_mother_death_date,hr_general.end_of_time))

Line 699: fnd_message.set_name('SSP','SSP_36798_APL_ADO_START_EARLY');

695:
696: if p_aspp_start_date < least(ssp_apad_pkg.EARLIEST_ASPPP_START_DATE(p_placement_date),
697: nvl(p_mother_death_date,hr_general.end_of_time))
698: then
699: fnd_message.set_name('SSP','SSP_36798_APL_ADO_START_EARLY');
700: fnd_message.raise_error;
701: end if;
702:
703: end;

Line 700: fnd_message.raise_error;

696: if p_aspp_start_date < least(ssp_apad_pkg.EARLIEST_ASPPP_START_DATE(p_placement_date),
697: nvl(p_mother_death_date,hr_general.end_of_time))
698: then
699: fnd_message.set_name('SSP','SSP_36798_APL_ADO_START_EARLY');
700: fnd_message.raise_error;
701: end if;
702:
703: end;
704:

Line 709: fnd_message.set_name('SSP','SSP_36091_PLACE_DATE_MATCHING');

705: PROCEDURE CHECK_PLACEMENT_DATE( p_placement_date in date,
706: P_MATCHING_DATE IN DATE) is
707: begin
708: If p_placement_date < P_MATCHING_DATE then
709: fnd_message.set_name('SSP','SSP_36091_PLACE_DATE_MATCHING');
710: fnd_message.raise_error;
711: End if;
712: End;
713:

Line 710: fnd_message.raise_error;

706: P_MATCHING_DATE IN DATE) is
707: begin
708: If p_placement_date < P_MATCHING_DATE then
709: fnd_message.set_name('SSP','SSP_36091_PLACE_DATE_MATCHING');
710: fnd_message.raise_error;
711: End if;
712: End;
713:
714: PROCEDURE CHECK_DISRUPTED_PLACEMENT_DATE (p_disrupted_placement_date in date,

Line 718: fnd_message.set_name('SSP','SSP_36095_APP_DATE_DISRUPTED');

714: PROCEDURE CHECK_DISRUPTED_PLACEMENT_DATE (p_disrupted_placement_date in date,
715: p_mpp_start_date in date) is
716: Begin
717: If p_disrupted_placement_date < p_mpp_start_date then
718: fnd_message.set_name('SSP','SSP_36095_APP_DATE_DISRUPTED');
719: fnd_message.raise_error;
720: End if;
721: End ;
722:

Line 719: fnd_message.raise_error;

715: p_mpp_start_date in date) is
716: Begin
717: If p_disrupted_placement_date < p_mpp_start_date then
718: fnd_message.set_name('SSP','SSP_36095_APP_DATE_DISRUPTED');
719: fnd_message.raise_error;
720: End if;
721: End ;
722:
723:

Line 730: fnd_message.set_name('SSP','SSP_36093_ACTUALBIRTH_DATE_18');

726: BEGIN
727: NULL;
728: /* Removed 18 year check due to legislation change
729: if months_between(p_due_date,p_actual_birth_date)/12 > 18 then
730: fnd_message.set_name('SSP','SSP_36093_ACTUALBIRTH_DATE_18');
731: fnd_message.raise_error;
732: end if;
733: */
734: END;

Line 731: fnd_message.raise_error;

727: NULL;
728: /* Removed 18 year check due to legislation change
729: if months_between(p_due_date,p_actual_birth_date)/12 > 18 then
730: fnd_message.set_name('SSP','SSP_36093_ACTUALBIRTH_DATE_18');
731: fnd_message.raise_error;
732: end if;
733: */
734: END;
735:

Line 741: fnd_message.set_name('SSP','SSP_36803_APL_RET_DEATH');

737: p_partner_death IN DATE,
738: p_partner_mpp_start in date) is
739: begin
740: if ((p_partner_return is null) and (p_partner_death is null)) then
741: fnd_message.set_name('SSP','SSP_36803_APL_RET_DEATH');
742: fnd_message.raise_error;
743: end if;
744:
745: if ((p_partner_return is not null) and (p_partner_death is not null)) then

Line 742: fnd_message.raise_error;

738: p_partner_mpp_start in date) is
739: begin
740: if ((p_partner_return is null) and (p_partner_death is null)) then
741: fnd_message.set_name('SSP','SSP_36803_APL_RET_DEATH');
742: fnd_message.raise_error;
743: end if;
744:
745: if ((p_partner_return is not null) and (p_partner_death is not null)) then
746: if p_partner_return > p_partner_death then

Line 747: fnd_message.set_name('SSP','SSP_36804_APL_PARTNER_RET');

743: end if;
744:
745: if ((p_partner_return is not null) and (p_partner_death is not null)) then
746: if p_partner_return > p_partner_death then
747: fnd_message.set_name('SSP','SSP_36804_APL_PARTNER_RET');
748: fnd_message.raise_error;
749: end if;
750: end if;
751:

Line 748: fnd_message.raise_error;

744:
745: if ((p_partner_return is not null) and (p_partner_death is not null)) then
746: if p_partner_return > p_partner_death then
747: fnd_message.set_name('SSP','SSP_36804_APL_PARTNER_RET');
748: fnd_message.raise_error;
749: end if;
750: end if;
751:
752: if p_partner_mpp_start is not null then

Line 754: fnd_message.set_name('SSP','SSP_36806_APL_INV_PAR_RET');

750: end if;
751:
752: if p_partner_mpp_start is not null then
753: if nvl(p_partner_return, hr_general.end_of_time) < p_partner_mpp_start then
754: fnd_message.set_name('SSP','SSP_36806_APL_INV_PAR_RET');
755: fnd_message.raise_error;
756: end if;
757: if nvl(p_partner_death, hr_general.end_of_time) < p_partner_mpp_start then
758: fnd_message.set_name('SSP','SSP_36807_APL_INV_DEATH');

Line 755: fnd_message.raise_error;

751:
752: if p_partner_mpp_start is not null then
753: if nvl(p_partner_return, hr_general.end_of_time) < p_partner_mpp_start then
754: fnd_message.set_name('SSP','SSP_36806_APL_INV_PAR_RET');
755: fnd_message.raise_error;
756: end if;
757: if nvl(p_partner_death, hr_general.end_of_time) < p_partner_mpp_start then
758: fnd_message.set_name('SSP','SSP_36807_APL_INV_DEATH');
759: fnd_message.raise_error;

Line 758: fnd_message.set_name('SSP','SSP_36807_APL_INV_DEATH');

754: fnd_message.set_name('SSP','SSP_36806_APL_INV_PAR_RET');
755: fnd_message.raise_error;
756: end if;
757: if nvl(p_partner_death, hr_general.end_of_time) < p_partner_mpp_start then
758: fnd_message.set_name('SSP','SSP_36807_APL_INV_DEATH');
759: fnd_message.raise_error;
760: end if;
761: end if;
762:

Line 759: fnd_message.raise_error;

755: fnd_message.raise_error;
756: end if;
757: if nvl(p_partner_death, hr_general.end_of_time) < p_partner_mpp_start then
758: fnd_message.set_name('SSP','SSP_36807_APL_INV_DEATH');
759: fnd_message.raise_error;
760: end if;
761: end if;
762:
763: end;

Line 794: fnd_message.set_name ('SSP', 'SSP_35083_KIT_DAY_NO_MPP_APP');

790: p_date in date) is
791: begin
792: if p_date is not null then
793: if p_start is null then
794: fnd_message.set_name ('SSP', 'SSP_35083_KIT_DAY_NO_MPP_APP');
795: fnd_message.raise_error;
796: end if;
797: if p_date < p_start or
798: p_date > p_end then

Line 795: fnd_message.raise_error;

791: begin
792: if p_date is not null then
793: if p_start is null then
794: fnd_message.set_name ('SSP', 'SSP_35083_KIT_DAY_NO_MPP_APP');
795: fnd_message.raise_error;
796: end if;
797: if p_date < p_start or
798: p_date > p_end then
799: fnd_message.set_name ('SSP', 'SSP_35081_KIT_DAY_PERIOD');

Line 799: fnd_message.set_name ('SSP', 'SSP_35081_KIT_DAY_PERIOD');

795: fnd_message.raise_error;
796: end if;
797: if p_date < p_start or
798: p_date > p_end then
799: fnd_message.set_name ('SSP', 'SSP_35081_KIT_DAY_PERIOD');
800: fnd_message.set_token('DATE1', p_start);
801: fnd_message.set_token('DATE2',p_end);
802: fnd_message.raise_error;
803: else

Line 800: fnd_message.set_token('DATE1', p_start);

796: end if;
797: if p_date < p_start or
798: p_date > p_end then
799: fnd_message.set_name ('SSP', 'SSP_35081_KIT_DAY_PERIOD');
800: fnd_message.set_token('DATE1', p_start);
801: fnd_message.set_token('DATE2',p_end);
802: fnd_message.raise_error;
803: else
804: /*Bug 7025371 if p_date <= l_2_weeks_after_birth then */

Line 801: fnd_message.set_token('DATE2',p_end);

797: if p_date < p_start or
798: p_date > p_end then
799: fnd_message.set_name ('SSP', 'SSP_35081_KIT_DAY_PERIOD');
800: fnd_message.set_token('DATE1', p_start);
801: fnd_message.set_token('DATE2',p_end);
802: fnd_message.raise_error;
803: else
804: /*Bug 7025371 if p_date <= l_2_weeks_after_birth then */
805: if p_date between p_rec.actual_birth_date+1 and p_rec.actual_birth_date + 15 then

Line 802: fnd_message.raise_error;

798: p_date > p_end then
799: fnd_message.set_name ('SSP', 'SSP_35081_KIT_DAY_PERIOD');
800: fnd_message.set_token('DATE1', p_start);
801: fnd_message.set_token('DATE2',p_end);
802: fnd_message.raise_error;
803: else
804: /*Bug 7025371 if p_date <= l_2_weeks_after_birth then */
805: if p_date between p_rec.actual_birth_date+1 and p_rec.actual_birth_date + 15 then
806: fnd_message.set_name ('SSP', 'SSP_35082_KIT_DAY_NOT_ALLOWS');

Line 806: fnd_message.set_name ('SSP', 'SSP_35082_KIT_DAY_NOT_ALLOWS');

802: fnd_message.raise_error;
803: else
804: /*Bug 7025371 if p_date <= l_2_weeks_after_birth then */
805: if p_date between p_rec.actual_birth_date+1 and p_rec.actual_birth_date + 15 then
806: fnd_message.set_name ('SSP', 'SSP_35082_KIT_DAY_NOT_ALLOWS');
807: fnd_message.raise_error;
808: end if;
809: end if;
810: end if;

Line 807: fnd_message.raise_error;

803: else
804: /*Bug 7025371 if p_date <= l_2_weeks_after_birth then */
805: if p_date between p_rec.actual_birth_date+1 and p_rec.actual_birth_date + 15 then
806: fnd_message.set_name ('SSP', 'SSP_35082_KIT_DAY_NOT_ALLOWS');
807: fnd_message.raise_error;
808: end if;
809: end if;
810: end if;
811: end;