18: --
19: Begin
20: --
21: If (p_constraint_name = 'IRC_INTERVIEW_DETAILS_FK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'IRC_INTERVIEW_DETAILS_PK') Then
19: Begin
20: --
21: If (p_constraint_name = 'IRC_INTERVIEW_DETAILS_FK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'IRC_INTERVIEW_DETAILS_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
20: --
21: If (p_constraint_name = 'IRC_INTERVIEW_DETAILS_FK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'IRC_INTERVIEW_DETAILS_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
21: If (p_constraint_name = 'IRC_INTERVIEW_DETAILS_FK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'IRC_INTERVIEW_DETAILS_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'IRC_INTERVIEW_DETAILS_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'IRC_INTERVIEW_DETAILS_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'IRC_INTERVIEW_DETAILS_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
26: ElsIf (p_constraint_name = 'IRC_INTERVIEW_DETAILS_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
35: fnd_message.raise_error;
36: End If;
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
35: fnd_message.raise_error;
36: End If;
37: --
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
35: fnd_message.raise_error;
36: End If;
37: --
38: End constraint_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
35: fnd_message.raise_error;
36: End If;
37: --
38: End constraint_error;
39: --
121: Close C_Sel1;
122: --
123: -- The primary key is invalid therefore we must error
124: --
125: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
126: fnd_message.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number
122: --
123: -- The primary key is invalid therefore we must error
124: --
125: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
126: fnd_message.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number
130: <> irc_iid_shd.g_old_rec.object_version_number) Then
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number
130: <> irc_iid_shd.g_old_rec.object_version_number) Then
131: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
132: fnd_message.raise_error;
133: End If;
134: l_fct_ret := true;
135: End If;
128: Close C_Sel1;
129: If (p_object_version_number
130: <> irc_iid_shd.g_old_rec.object_version_number) Then
131: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
132: fnd_message.raise_error;
133: End If;
134: l_fct_ret := true;
135: End If;
136: End If;
280: Close C_Sel1;
281: --
282: -- The primary key is invalid therefore we must error
283: --
284: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
285: fnd_message.raise_error;
286: End If;
287: Close C_Sel1;
288: If (p_object_version_number
281: --
282: -- The primary key is invalid therefore we must error
283: --
284: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
285: fnd_message.raise_error;
286: End If;
287: Close C_Sel1;
288: If (p_object_version_number
289: <> irc_iid_shd.g_old_rec.object_version_number) Then
286: End If;
287: Close C_Sel1;
288: If (p_object_version_number
289: <> irc_iid_shd.g_old_rec.object_version_number) Then
290: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
291: fnd_message.raise_error;
292: End If;
293: --
294: --
287: Close C_Sel1;
288: If (p_object_version_number
289: <> irc_iid_shd.g_old_rec.object_version_number) Then
290: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
291: fnd_message.raise_error;
292: End If;
293: --
294: --
295: --
298: -- We are doing a datetrack 'INSERT' which is illegal within this
299: -- procedure therefore we must error (note: to lck on insert the
300: -- private procedure ins_lck should be called).
301: --
302: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
303: fnd_message.set_token('PROCEDURE', l_proc);
304: fnd_message.set_token('STEP','20');
305: fnd_message.raise_error;
306: End If;
299: -- procedure therefore we must error (note: to lck on insert the
300: -- private procedure ins_lck should be called).
301: --
302: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
303: fnd_message.set_token('PROCEDURE', l_proc);
304: fnd_message.set_token('STEP','20');
305: fnd_message.raise_error;
306: End If;
307: --
300: -- private procedure ins_lck should be called).
301: --
302: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
303: fnd_message.set_token('PROCEDURE', l_proc);
304: fnd_message.set_token('STEP','20');
305: fnd_message.raise_error;
306: End If;
307: --
308: -- Set the validation start and end date OUT arguments
301: --
302: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
303: fnd_message.set_token('PROCEDURE', l_proc);
304: fnd_message.set_token('STEP','20');
305: fnd_message.raise_error;
306: End If;
307: --
308: -- Set the validation start and end date OUT arguments
309: --
324: --
325: -- The object is locked therefore we need to supply a meaningful
326: -- error message.
327: --
328: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
329: fnd_message.set_token('TABLE_NAME', 'irc_interview_details');
330: fnd_message.raise_error;
331: End lck;
332: --
325: -- The object is locked therefore we need to supply a meaningful
326: -- error message.
327: --
328: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
329: fnd_message.set_token('TABLE_NAME', 'irc_interview_details');
330: fnd_message.raise_error;
331: End lck;
332: --
333: -- ----------------------------------------------------------------------------
326: -- error message.
327: --
328: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
329: fnd_message.set_token('TABLE_NAME', 'irc_interview_details');
330: fnd_message.raise_error;
331: End lck;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |-----------------------------< convert_args >-----------------------------|