18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_IE_SOCIAL_BENEFITS_F_PK') 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: Else
19: Begin
20: --
21: If (p_constraint_name = 'PAY_IE_SOCIAL_BENEFITS_F_PK') 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: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
20: --
21: If (p_constraint_name = 'PAY_IE_SOCIAL_BENEFITS_F_PK') 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: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
21: If (p_constraint_name = 'PAY_IE_SOCIAL_BENEFITS_F_PK') 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: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
33: End constraint_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
33: End constraint_error;
34: --
100: Close C_Sel1;
101: --
102: -- The primary key is invalid therefore we must error
103: --
104: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
105: fnd_message.raise_error;
106: End If;
107: Close C_Sel1;
108: If (p_object_version_number
101: --
102: -- The primary key is invalid therefore we must error
103: --
104: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
105: fnd_message.raise_error;
106: End If;
107: Close C_Sel1;
108: If (p_object_version_number
109: <> pay_isb_shd.g_old_rec.object_version_number) Then
106: End If;
107: Close C_Sel1;
108: If (p_object_version_number
109: <> pay_isb_shd.g_old_rec.object_version_number) Then
110: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
111: fnd_message.raise_error;
112: End If;
113: l_fct_ret := true;
114: End If;
107: Close C_Sel1;
108: If (p_object_version_number
109: <> pay_isb_shd.g_old_rec.object_version_number) Then
110: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
111: fnd_message.raise_error;
112: End If;
113: l_fct_ret := true;
114: End If;
115: End If;
180: Fetch C_Sel1 Into
181: l_parent_key_value1;
182: If C_Sel1%NOTFOUND then
183: Close C_Sel1;
184: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
185: fnd_message.set_token('PROCEDURE',l_proc);
186: fnd_message.set_token('STEP','10');
187: fnd_message.raise_error;
188: End If;
181: l_parent_key_value1;
182: If C_Sel1%NOTFOUND then
183: Close C_Sel1;
184: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
185: fnd_message.set_token('PROCEDURE',l_proc);
186: fnd_message.set_token('STEP','10');
187: fnd_message.raise_error;
188: End If;
189: Close C_Sel1;
182: If C_Sel1%NOTFOUND then
183: Close C_Sel1;
184: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
185: fnd_message.set_token('PROCEDURE',l_proc);
186: fnd_message.set_token('STEP','10');
187: fnd_message.raise_error;
188: End If;
189: Close C_Sel1;
190: --
183: Close C_Sel1;
184: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
185: fnd_message.set_token('PROCEDURE',l_proc);
186: fnd_message.set_token('STEP','10');
187: fnd_message.raise_error;
188: End If;
189: Close C_Sel1;
190: --
191: -- Call the corresponding datetrack api
338: Close C_Sel1;
339: --
340: -- The primary key is invalid therefore we must error
341: --
342: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
343: fnd_message.raise_error;
344: End If;
345: Close C_Sel1;
346: If (p_object_version_number
339: --
340: -- The primary key is invalid therefore we must error
341: --
342: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
343: fnd_message.raise_error;
344: End If;
345: Close C_Sel1;
346: If (p_object_version_number
347: <> pay_isb_shd.g_old_rec.object_version_number) Then
344: End If;
345: Close C_Sel1;
346: If (p_object_version_number
347: <> pay_isb_shd.g_old_rec.object_version_number) Then
348: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
349: fnd_message.raise_error;
350: End If;
351: --
352: --
345: Close C_Sel1;
346: If (p_object_version_number
347: <> pay_isb_shd.g_old_rec.object_version_number) Then
348: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
349: fnd_message.raise_error;
350: End If;
351: --
352: --
353: -- Validate the datetrack mode mode getting the validation start
371: -- We are doing a datetrack 'INSERT' which is illegal within this
372: -- procedure therefore we must error (note: to lck on insert the
373: -- private procedure ins_lck should be called).
374: --
375: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
376: fnd_message.set_token('PROCEDURE', l_proc);
377: fnd_message.set_token('STEP','20');
378: fnd_message.raise_error;
379: End If;
372: -- procedure therefore we must error (note: to lck on insert the
373: -- private procedure ins_lck should be called).
374: --
375: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
376: fnd_message.set_token('PROCEDURE', l_proc);
377: fnd_message.set_token('STEP','20');
378: fnd_message.raise_error;
379: End If;
380: --
373: -- private procedure ins_lck should be called).
374: --
375: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
376: fnd_message.set_token('PROCEDURE', l_proc);
377: fnd_message.set_token('STEP','20');
378: fnd_message.raise_error;
379: End If;
380: --
381: -- Set the validation start and end date OUT arguments
374: --
375: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
376: fnd_message.set_token('PROCEDURE', l_proc);
377: fnd_message.set_token('STEP','20');
378: fnd_message.raise_error;
379: End If;
380: --
381: -- Set the validation start and end date OUT arguments
382: --
392: --
393: -- The object is locked therefore we need to supply a meaningful
394: -- error message.
395: --
396: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
397: fnd_message.set_token('TABLE_NAME', 'pay_ie_social_benefits_f');
398: fnd_message.raise_error;
399: End lck;
400: --
393: -- The object is locked therefore we need to supply a meaningful
394: -- error message.
395: --
396: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
397: fnd_message.set_token('TABLE_NAME', 'pay_ie_social_benefits_f');
398: fnd_message.raise_error;
399: End lck;
400: --
401: -- ----------------------------------------------------------------------------
394: -- error message.
395: --
396: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
397: fnd_message.set_token('TABLE_NAME', 'pay_ie_social_benefits_f');
398: fnd_message.raise_error;
399: End lck;
400: --
401: -- ----------------------------------------------------------------------------
402: -- |-----------------------------< convert_args >-----------------------------|