33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'SSP_MAT_NOTE_OF_BIRTH_TOO_SOON') Then
37: fnd_message.set_name ('SSP', 'SSP_35012_EARLY_BIRTH_NOTIFIC');
38: --
39: ElsIf (p_constraint_name = 'SSP_MAT_MPP_MUST_START_SUNDAY') Then
40: fnd_message.set_name ('SSP', 'SSP_35054_MPP_NOT_SUNDAY');
41: --
36: If (p_constraint_name = 'SSP_MAT_NOTE_OF_BIRTH_TOO_SOON') Then
37: fnd_message.set_name ('SSP', 'SSP_35012_EARLY_BIRTH_NOTIFIC');
38: --
39: ElsIf (p_constraint_name = 'SSP_MAT_MPP_MUST_START_SUNDAY') Then
40: fnd_message.set_name ('SSP', 'SSP_35054_MPP_NOT_SUNDAY');
41: --
42: ElsIf (p_constraint_name = 'SSP_MAT_INTEND_TO_RETURN_DATE') Then
43: fnd_message.set_name ('SSP', 'SSP_35013_INV_EVNT_RET_DATE');
44: --
39: ElsIf (p_constraint_name = 'SSP_MAT_MPP_MUST_START_SUNDAY') Then
40: fnd_message.set_name ('SSP', 'SSP_35054_MPP_NOT_SUNDAY');
41: --
42: ElsIf (p_constraint_name = 'SSP_MAT_INTEND_TO_RETURN_DATE') Then
43: fnd_message.set_name ('SSP', 'SSP_35013_INV_EVNT_RET_DATE');
44: --
45: ElsIf (p_constraint_name = 'SSP_MAT_STILLBIRTH_NEEDS_DATE') Then
46: fnd_message.set_name ('SSP', 'SSP_35004_LIVE_BIRTH_FLAG');
47: --
42: ElsIf (p_constraint_name = 'SSP_MAT_INTEND_TO_RETURN_DATE') Then
43: fnd_message.set_name ('SSP', 'SSP_35013_INV_EVNT_RET_DATE');
44: --
45: ElsIf (p_constraint_name = 'SSP_MAT_STILLBIRTH_NEEDS_DATE') Then
46: fnd_message.set_name ('SSP', 'SSP_35004_LIVE_BIRTH_FLAG');
47: --
48: ElsIf (p_constraint_name = 'SSP_MAT_MPP_SMA_START_DATES') Then
49: fnd_message.set_name ('SSP', 'SSP_35014_FWD_MPP_START');
50: --
45: ElsIf (p_constraint_name = 'SSP_MAT_STILLBIRTH_NEEDS_DATE') Then
46: fnd_message.set_name ('SSP', 'SSP_35004_LIVE_BIRTH_FLAG');
47: --
48: ElsIf (p_constraint_name = 'SSP_MAT_MPP_SMA_START_DATES') Then
49: fnd_message.set_name ('SSP', 'SSP_35014_FWD_MPP_START');
50: --
51: ElsIf (p_constraint_name = 'SSP_MAT_UNFIT_TO_RETURN_DATE') Then
52: fnd_message.set_name ('SSP', 'SSP_35058_UNFIT_TO_RETURN');
53: --
48: ElsIf (p_constraint_name = 'SSP_MAT_MPP_SMA_START_DATES') Then
49: fnd_message.set_name ('SSP', 'SSP_35014_FWD_MPP_START');
50: --
51: ElsIf (p_constraint_name = 'SSP_MAT_UNFIT_TO_RETURN_DATE') Then
52: fnd_message.set_name ('SSP', 'SSP_35058_UNFIT_TO_RETURN');
53: --
54: ElsIf (p_constraint_name = 'SSP_MATERNITIES_PK') Then
55: fnd_message.set_name ('SSP', 'SSP_35041_DUP_MATERNITY_PK');
56: --
51: ElsIf (p_constraint_name = 'SSP_MAT_UNFIT_TO_RETURN_DATE') Then
52: fnd_message.set_name ('SSP', 'SSP_35058_UNFIT_TO_RETURN');
53: --
54: ElsIf (p_constraint_name = 'SSP_MATERNITIES_PK') Then
55: fnd_message.set_name ('SSP', 'SSP_35041_DUP_MATERNITY_PK');
56: --
57: ElsIf (p_constraint_name = 'SSP_MATERNITIES_UK1') Then
58: fnd_message.set_name ('SSP', 'SSP_35009_DUP_DUE_DATE');
59: --
54: ElsIf (p_constraint_name = 'SSP_MATERNITIES_PK') Then
55: fnd_message.set_name ('SSP', 'SSP_35041_DUP_MATERNITY_PK');
56: --
57: ElsIf (p_constraint_name = 'SSP_MATERNITIES_UK1') Then
58: fnd_message.set_name ('SSP', 'SSP_35009_DUP_DUE_DATE');
59: --
60: ElsIf (p_constraint_name = 'SSP_MAT_MPP_START_BIRTH_DATE') Then
61: fnd_message.set_name ('SSP', 'SSP_35055_MPP_SUN_FOLLW_BIRTH');
62: --
57: ElsIf (p_constraint_name = 'SSP_MATERNITIES_UK1') Then
58: fnd_message.set_name ('SSP', 'SSP_35009_DUP_DUE_DATE');
59: --
60: ElsIf (p_constraint_name = 'SSP_MAT_MPP_START_BIRTH_DATE') Then
61: fnd_message.set_name ('SSP', 'SSP_35055_MPP_SUN_FOLLW_BIRTH');
62: --
63: ElsIf (p_constraint_name = 'SSP_MAT_NOTIFICATION_OF_BIRTH') Then
64: fnd_message.set_name ('SSP', 'SSP_35059_NOTIF_OF_BIRTH');
65: --
60: ElsIf (p_constraint_name = 'SSP_MAT_MPP_START_BIRTH_DATE') Then
61: fnd_message.set_name ('SSP', 'SSP_35055_MPP_SUN_FOLLW_BIRTH');
62: --
63: ElsIf (p_constraint_name = 'SSP_MAT_NOTIFICATION_OF_BIRTH') Then
64: fnd_message.set_name ('SSP', 'SSP_35059_NOTIF_OF_BIRTH');
65: --
66: ElsIf (p_constraint_name = 'SSP_MATERNITIES_FK1') Then
67: fnd_message.set_name('SSP', 'SSP_35057_BAD_PERSON_ID');
68: --
63: ElsIf (p_constraint_name = 'SSP_MAT_NOTIFICATION_OF_BIRTH') Then
64: fnd_message.set_name ('SSP', 'SSP_35059_NOTIF_OF_BIRTH');
65: --
66: ElsIf (p_constraint_name = 'SSP_MATERNITIES_FK1') Then
67: fnd_message.set_name('SSP', 'SSP_35057_BAD_PERSON_ID');
68: --
69: Else
70: fnd_message.set_name ('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
71: fnd_message.set_token('PROCEDURE', l_proc);
66: ElsIf (p_constraint_name = 'SSP_MATERNITIES_FK1') Then
67: fnd_message.set_name('SSP', 'SSP_35057_BAD_PERSON_ID');
68: --
69: Else
70: fnd_message.set_name ('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
71: fnd_message.set_token('PROCEDURE', l_proc);
72: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
73: End If;
74: --
67: fnd_message.set_name('SSP', 'SSP_35057_BAD_PERSON_ID');
68: --
69: Else
70: fnd_message.set_name ('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
71: fnd_message.set_token('PROCEDURE', l_proc);
72: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
73: End If;
74: --
75: fnd_message.raise_error;
68: --
69: Else
70: fnd_message.set_name ('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
71: fnd_message.set_token('PROCEDURE', l_proc);
72: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
73: End If;
74: --
75: fnd_message.raise_error;
76: --
71: fnd_message.set_token('PROCEDURE', l_proc);
72: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
73: End If;
74: --
75: fnd_message.raise_error;
76: --
77: hr_utility.set_location(' Leaving:'||l_proc, 10);
78: End constraint_error;
79: --
204: Close C_Sel1;
205: --
206: -- The primary key is invalid therefore we must error
207: --
208: fnd_message.set_name ('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
209: fnd_message.raise_error;
210: End If;
211: Close C_Sel1;
212: If (p_object_version_number <> g_old_rec.object_version_number) Then
205: --
206: -- The primary key is invalid therefore we must error
207: --
208: fnd_message.set_name ('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
209: fnd_message.raise_error;
210: End If;
211: Close C_Sel1;
212: If (p_object_version_number <> g_old_rec.object_version_number) Then
213: fnd_message.set_name ('PAY', 'HR_7155_OBJECT_INVALID');
209: fnd_message.raise_error;
210: End If;
211: Close C_Sel1;
212: If (p_object_version_number <> g_old_rec.object_version_number) Then
213: fnd_message.set_name ('PAY', 'HR_7155_OBJECT_INVALID');
214: fnd_message.raise_error;
215: End If;
216: hr_utility.set_location(l_proc, 15);
217: l_fct_ret := true;
210: End If;
211: Close C_Sel1;
212: If (p_object_version_number <> g_old_rec.object_version_number) Then
213: fnd_message.set_name ('PAY', 'HR_7155_OBJECT_INVALID');
214: fnd_message.raise_error;
215: End If;
216: hr_utility.set_location(l_proc, 15);
217: l_fct_ret := true;
218: End If;
330: Close C_Sel1;
331: --
332: -- The primary key is invalid therefore we must error
333: --
334: fnd_message.set_name ('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
335: fnd_message.raise_error;
336: End If;
337: Close C_Sel1;
338: If (p_object_version_number <> g_old_rec.object_version_number) Then
331: --
332: -- The primary key is invalid therefore we must error
333: --
334: fnd_message.set_name ('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
335: fnd_message.raise_error;
336: End If;
337: Close C_Sel1;
338: If (p_object_version_number <> g_old_rec.object_version_number) Then
339: fnd_message.set_name ('PAY', 'HR_7155_OBJECT_INVALID');
335: fnd_message.raise_error;
336: End If;
337: Close C_Sel1;
338: If (p_object_version_number <> g_old_rec.object_version_number) Then
339: fnd_message.set_name ('PAY', 'HR_7155_OBJECT_INVALID');
340: fnd_message.raise_error;
341: End If;
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 10);
336: End If;
337: Close C_Sel1;
338: If (p_object_version_number <> g_old_rec.object_version_number) Then
339: fnd_message.set_name ('PAY', 'HR_7155_OBJECT_INVALID');
340: fnd_message.raise_error;
341: End If;
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 10);
344: --
349: --
350: -- The object is locked therefore we need to supply a meaningful
351: -- error message.
352: --
353: fnd_message.set_name ('PAY', 'HR_7165_OBJECT_LOCKED');
354: fnd_message.set_token('TABLE_NAME', 'ssp_maternities');
355: fnd_message.raise_error;
356: End lck;
357: --
350: -- The object is locked therefore we need to supply a meaningful
351: -- error message.
352: --
353: fnd_message.set_name ('PAY', 'HR_7165_OBJECT_LOCKED');
354: fnd_message.set_token('TABLE_NAME', 'ssp_maternities');
355: fnd_message.raise_error;
356: End lck;
357: --
358: -- ----------------------------------------------------------------------------
351: -- error message.
352: --
353: fnd_message.set_name ('PAY', 'HR_7165_OBJECT_LOCKED');
354: fnd_message.set_token('TABLE_NAME', 'ssp_maternities');
355: fnd_message.raise_error;
356: End lck;
357: --
358: -- ----------------------------------------------------------------------------
359: -- |-----------------------------< convert_args >-----------------------------|