36: Begin
37: hr_utility.set_location('Entering:'||l_proc, 5);
38: --
39: If (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_DT6') Then
40: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('STEP','5');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK1') Then
37: hr_utility.set_location('Entering:'||l_proc, 5);
38: --
39: If (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_DT6') Then
40: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('STEP','5');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK1') Then
45: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: --
39: If (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_DT6') Then
40: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('STEP','5');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK1') Then
45: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
46: fnd_message.set_token('PROCEDURE', l_proc);
39: If (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_DT6') Then
40: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('STEP','5');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK1') Then
45: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
46: fnd_message.set_token('PROCEDURE', l_proc);
47: fnd_message.set_token('STEP','10');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('STEP','5');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK1') Then
45: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
46: fnd_message.set_token('PROCEDURE', l_proc);
47: fnd_message.set_token('STEP','10');
48: fnd_message.raise_error;
49: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK3') Then
42: fnd_message.set_token('STEP','5');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK1') Then
45: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
46: fnd_message.set_token('PROCEDURE', l_proc);
47: fnd_message.set_token('STEP','10');
48: fnd_message.raise_error;
49: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK3') Then
50: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK1') Then
45: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
46: fnd_message.set_token('PROCEDURE', l_proc);
47: fnd_message.set_token('STEP','10');
48: fnd_message.raise_error;
49: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK3') Then
50: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
51: fnd_message.set_token('PROCEDURE', l_proc);
44: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK1') Then
45: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
46: fnd_message.set_token('PROCEDURE', l_proc);
47: fnd_message.set_token('STEP','10');
48: fnd_message.raise_error;
49: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK3') Then
50: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
51: fnd_message.set_token('PROCEDURE', l_proc);
52: fnd_message.set_token('STEP','15');
46: fnd_message.set_token('PROCEDURE', l_proc);
47: fnd_message.set_token('STEP','10');
48: fnd_message.raise_error;
49: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK3') Then
50: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
51: fnd_message.set_token('PROCEDURE', l_proc);
52: fnd_message.set_token('STEP','15');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_PK') Then
47: fnd_message.set_token('STEP','10');
48: fnd_message.raise_error;
49: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK3') Then
50: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
51: fnd_message.set_token('PROCEDURE', l_proc);
52: fnd_message.set_token('STEP','15');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_PK') Then
55: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.raise_error;
49: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK3') Then
50: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
51: fnd_message.set_token('PROCEDURE', l_proc);
52: fnd_message.set_token('STEP','15');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_PK') Then
55: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.set_token('PROCEDURE', l_proc);
49: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK3') Then
50: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
51: fnd_message.set_token('PROCEDURE', l_proc);
52: fnd_message.set_token('STEP','15');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_PK') Then
55: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('STEP','20');
51: fnd_message.set_token('PROCEDURE', l_proc);
52: fnd_message.set_token('STEP','15');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_PK') Then
55: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('STEP','20');
58: fnd_message.raise_error;
59: Else
52: fnd_message.set_token('STEP','15');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_PK') Then
55: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('STEP','20');
58: fnd_message.raise_error;
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_PK') Then
55: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('STEP','20');
58: fnd_message.raise_error;
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
61: fnd_message.set_token('PROCEDURE', l_proc);
54: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_PK') Then
55: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('STEP','20');
58: fnd_message.raise_error;
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('STEP','20');
58: fnd_message.raise_error;
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
63: fnd_message.raise_error;
64: End If;
57: fnd_message.set_token('STEP','20');
58: fnd_message.raise_error;
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
63: fnd_message.raise_error;
64: End If;
65: --
58: fnd_message.raise_error;
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
63: fnd_message.raise_error;
64: End If;
65: --
66: hr_utility.set_location(' Leaving:'||l_proc, 10);
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
63: fnd_message.raise_error;
64: End If;
65: --
66: hr_utility.set_location(' Leaving:'||l_proc, 10);
67: End constraint_error;
192: Close C_Sel1;
193: --
194: -- The primary key is invalid therefore we must error
195: --
196: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
197: fnd_message.raise_error;
198: End If;
199: Close C_Sel1;
200: If (p_object_version_number <> g_old_rec.object_version_number) Then
193: --
194: -- The primary key is invalid therefore we must error
195: --
196: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
197: fnd_message.raise_error;
198: End If;
199: Close C_Sel1;
200: If (p_object_version_number <> g_old_rec.object_version_number) Then
201: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
197: fnd_message.raise_error;
198: End If;
199: Close C_Sel1;
200: If (p_object_version_number <> g_old_rec.object_version_number) Then
201: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
202: fnd_message.raise_error;
203: End If;
204: hr_utility.set_location(l_proc, 15);
205: l_fct_ret := true;
198: End If;
199: Close C_Sel1;
200: If (p_object_version_number <> g_old_rec.object_version_number) Then
201: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
202: fnd_message.raise_error;
203: End If;
204: hr_utility.set_location(l_proc, 15);
205: l_fct_ret := true;
206: End If;
237: Open C_Sel1;
238: Fetch C_Sel1 Into l_parent_key_value1;
239: If C_Sel1%notfound then
240: Close C_Sel1;
241: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
242: fnd_message.set_token('PROCEDURE', l_proc);
243: fnd_message.set_token('STEP','10');
244: fnd_message.raise_error;
245: End If;
238: Fetch C_Sel1 Into l_parent_key_value1;
239: If C_Sel1%notfound then
240: Close C_Sel1;
241: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
242: fnd_message.set_token('PROCEDURE', l_proc);
243: fnd_message.set_token('STEP','10');
244: fnd_message.raise_error;
245: End If;
246: Close C_Sel1;
239: If C_Sel1%notfound then
240: Close C_Sel1;
241: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
242: fnd_message.set_token('PROCEDURE', l_proc);
243: fnd_message.set_token('STEP','10');
244: fnd_message.raise_error;
245: End If;
246: Close C_Sel1;
247: --
240: Close C_Sel1;
241: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
242: fnd_message.set_token('PROCEDURE', l_proc);
243: fnd_message.set_token('STEP','10');
244: fnd_message.raise_error;
245: End If;
246: Close C_Sel1;
247: --
248: -- Call the corresponding datetrack api
482: Close C_Sel1;
483: --
484: -- The primary key is invalid therefore we must error
485: --
486: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
487: fnd_message.raise_error;
488: End If;
489: Close C_Sel1;
490: If (p_object_version_number <> g_old_rec.object_version_number) Then
483: --
484: -- The primary key is invalid therefore we must error
485: --
486: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
487: fnd_message.raise_error;
488: End If;
489: Close C_Sel1;
490: If (p_object_version_number <> g_old_rec.object_version_number) Then
491: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
487: fnd_message.raise_error;
488: End If;
489: Close C_Sel1;
490: If (p_object_version_number <> g_old_rec.object_version_number) Then
491: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
492: fnd_message.raise_error;
493: End If;
494: hr_utility.set_location(l_proc, 15);
495: --
488: End If;
489: Close C_Sel1;
490: If (p_object_version_number <> g_old_rec.object_version_number) Then
491: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
492: fnd_message.raise_error;
493: End If;
494: hr_utility.set_location(l_proc, 15);
495: --
496: --
514: -- We are doing a datetrack 'INSERT' which is illegal within this
515: -- procedure therefore we must error (note: to lck on insert the
516: -- private procedure ins_lck should be called).
517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','20');
521: fnd_message.raise_error;
522: End If;
515: -- procedure therefore we must error (note: to lck on insert the
516: -- private procedure ins_lck should be called).
517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','20');
521: fnd_message.raise_error;
522: End If;
523: --
516: -- private procedure ins_lck should be called).
517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','20');
521: fnd_message.raise_error;
522: End If;
523: --
524: -- Set the validation start and end date OUT arguments
517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','20');
521: fnd_message.raise_error;
522: End If;
523: --
524: -- Set the validation start and end date OUT arguments
525: --
535: --
536: -- The object is locked therefore we need to supply a meaningful
537: -- error message.
538: --
539: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
540: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');
541: fnd_message.raise_error;
542: When l_object_invalid then
543: --
536: -- The object is locked therefore we need to supply a meaningful
537: -- error message.
538: --
539: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
540: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');
541: fnd_message.raise_error;
542: When l_object_invalid then
543: --
544: -- The object doesn't exist or is invalid
537: -- error message.
538: --
539: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
540: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');
541: fnd_message.raise_error;
542: When l_object_invalid then
543: --
544: -- The object doesn't exist or is invalid
545: --
542: When l_object_invalid then
543: --
544: -- The object doesn't exist or is invalid
545: --
546: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
547: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');
548: fnd_message.raise_error;
549: End lck;
550: --
543: --
544: -- The object doesn't exist or is invalid
545: --
546: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
547: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');
548: fnd_message.raise_error;
549: End lck;
550: --
551: -- ----------------------------------------------------------------------------
544: -- The object doesn't exist or is invalid
545: --
546: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
547: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');
548: fnd_message.raise_error;
549: End lck;
550: --
551: -- ----------------------------------------------------------------------------
552: -- |-----------------------------< convert_args >-----------------------------|