18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_PAYMENT_GL_ACCOUNTS_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_PAYMENT_GL_ACCOUNTS_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_PAYMENT_GL_ACCOUNTS_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_PAYMENT_GL_ACCOUNTS_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: --
94: Close C_Sel1;
95: --
96: -- The primary key is invalid therefore we must error
97: --
98: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
99: fnd_message.raise_error;
100: End If;
101: Close C_Sel1;
102: If (p_object_version_number
95: --
96: -- The primary key is invalid therefore we must error
97: --
98: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
99: fnd_message.raise_error;
100: End If;
101: Close C_Sel1;
102: If (p_object_version_number
103: <> pay_pga_shd.g_old_rec.object_version_number) Then
100: End If;
101: Close C_Sel1;
102: If (p_object_version_number
103: <> pay_pga_shd.g_old_rec.object_version_number) Then
104: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
105: fnd_message.raise_error;
106: End If;
107: l_fct_ret := true;
108: End If;
101: Close C_Sel1;
102: If (p_object_version_number
103: <> pay_pga_shd.g_old_rec.object_version_number) Then
104: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
105: fnd_message.raise_error;
106: End If;
107: l_fct_ret := true;
108: End If;
109: End If;
303: Close C_Sel1;
304: --
305: -- The primary key is invalid therefore we must error
306: --
307: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
308: fnd_message.raise_error;
309: End If;
310: Close C_Sel1;
311: If (p_object_version_number
304: --
305: -- The primary key is invalid therefore we must error
306: --
307: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
308: fnd_message.raise_error;
309: End If;
310: Close C_Sel1;
311: If (p_object_version_number
312: <> pay_pga_shd.g_old_rec.object_version_number) Then
309: End If;
310: Close C_Sel1;
311: If (p_object_version_number
312: <> pay_pga_shd.g_old_rec.object_version_number) Then
313: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
314: fnd_message.raise_error;
315: End If;
316: --
317: --
310: Close C_Sel1;
311: If (p_object_version_number
312: <> pay_pga_shd.g_old_rec.object_version_number) Then
313: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
314: fnd_message.raise_error;
315: End If;
316: --
317: --
318: -- Validate the datetrack mode mode getting the validation start
353: -- We are doing a datetrack 'INSERT' which is illegal within this
354: -- procedure therefore we must error (note: to lck on insert the
355: -- private procedure ins_lck should be called).
356: --
357: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
358: fnd_message.set_token('PROCEDURE', l_proc);
359: fnd_message.set_token('STEP','20');
360: fnd_message.raise_error;
361: End If;
354: -- procedure therefore we must error (note: to lck on insert the
355: -- private procedure ins_lck should be called).
356: --
357: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
358: fnd_message.set_token('PROCEDURE', l_proc);
359: fnd_message.set_token('STEP','20');
360: fnd_message.raise_error;
361: End If;
362: --
355: -- private procedure ins_lck should be called).
356: --
357: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
358: fnd_message.set_token('PROCEDURE', l_proc);
359: fnd_message.set_token('STEP','20');
360: fnd_message.raise_error;
361: End If;
362: --
363: -- Set the validation start and end date OUT arguments
356: --
357: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
358: fnd_message.set_token('PROCEDURE', l_proc);
359: fnd_message.set_token('STEP','20');
360: fnd_message.raise_error;
361: End If;
362: --
363: -- Set the validation start and end date OUT arguments
364: --
374: --
375: -- The object is locked therefore we need to supply a meaningful
376: -- error message.
377: --
378: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
379: fnd_message.set_token('TABLE_NAME', 'pay_payment_gl_accounts_f');
380: fnd_message.raise_error;
381: End lck;
382: --
375: -- The object is locked therefore we need to supply a meaningful
376: -- error message.
377: --
378: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
379: fnd_message.set_token('TABLE_NAME', 'pay_payment_gl_accounts_f');
380: fnd_message.raise_error;
381: End lck;
382: --
383: -- ----------------------------------------------------------------------------
376: -- error message.
377: --
378: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
379: fnd_message.set_token('TABLE_NAME', 'pay_payment_gl_accounts_f');
380: fnd_message.raise_error;
381: End lck;
382: --
383: -- ----------------------------------------------------------------------------
384: -- |-----------------------------< convert_args >-----------------------------|