33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ELIGY_PRFL_FK1') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_PK') Then
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ELIGY_PRFL_FK1') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: --
36: If (p_constraint_name = 'BEN_ELIGY_PRFL_FK1') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
36: If (p_constraint_name = 'BEN_ELIGY_PRFL_FK1') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_UK1') Then
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_UK1') Then
47: /*
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_UK1') Then
47: /*
48: fnd_message.set_name('BEN', 'BEN_52347_NAME_NOT_UNIQUE');
41: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_UK1') Then
47: /*
48: fnd_message.set_name('BEN', 'BEN_52347_NAME_NOT_UNIQUE');
49: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_UK1') Then
47: /*
48: fnd_message.set_name('BEN', 'BEN_52347_NAME_NOT_UNIQUE');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','10');
51: */ -- Commented as part of bug 3134750
52: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_UK1') Then
47: /*
48: fnd_message.set_name('BEN', 'BEN_52347_NAME_NOT_UNIQUE');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','10');
51: */ -- Commented as part of bug 3134750
52: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
53: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ELIGY_PRFL_UK1') Then
47: /*
48: fnd_message.set_name('BEN', 'BEN_52347_NAME_NOT_UNIQUE');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','10');
51: */ -- Commented as part of bug 3134750
52: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
53: fnd_message.raise_error;
54: Else
48: fnd_message.set_name('BEN', 'BEN_52347_NAME_NOT_UNIQUE');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','10');
51: */ -- Commented as part of bug 3134750
52: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
53: fnd_message.raise_error;
54: Else
55: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
56: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','10');
51: */ -- Commented as part of bug 3134750
52: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
53: fnd_message.raise_error;
54: Else
55: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
51: */ -- Commented as part of bug 3134750
52: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
53: fnd_message.raise_error;
54: Else
55: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
58: fnd_message.raise_error;
59: End If;
52: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
53: fnd_message.raise_error;
54: Else
55: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
58: fnd_message.raise_error;
59: End If;
60: --
53: fnd_message.raise_error;
54: Else
55: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
58: fnd_message.raise_error;
59: End If;
60: --
61: hr_utility.set_location(' Leaving:'||l_proc, 10);
54: Else
55: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
58: fnd_message.raise_error;
59: End If;
60: --
61: hr_utility.set_location(' Leaving:'||l_proc, 10);
62: End constraint_error;
218: Close C_Sel1;
219: --
220: -- The primary key is invalid therefore we must error
221: --
222: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
223: fnd_message.raise_error;
224: End If;
225: Close C_Sel1;
226: If (p_object_version_number <> g_old_rec.object_version_number) Then
219: --
220: -- The primary key is invalid therefore we must error
221: --
222: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
223: fnd_message.raise_error;
224: End If;
225: Close C_Sel1;
226: If (p_object_version_number <> g_old_rec.object_version_number) Then
227: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
223: fnd_message.raise_error;
224: End If;
225: Close C_Sel1;
226: If (p_object_version_number <> g_old_rec.object_version_number) Then
227: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
228: fnd_message.raise_error;
229: End If;
230: hr_utility.set_location(l_proc, 15);
231: l_fct_ret := true;
224: End If;
225: Close C_Sel1;
226: If (p_object_version_number <> g_old_rec.object_version_number) Then
227: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
228: fnd_message.raise_error;
229: End If;
230: hr_utility.set_location(l_proc, 15);
231: l_fct_ret := true;
232: End If;
519: Close C_Sel1;
520: --
521: -- The primary key is invalid therefore we must error
522: --
523: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
524: fnd_message.raise_error;
525: End If;
526: Close C_Sel1;
527: If (p_object_version_number <> g_old_rec.object_version_number) Then
520: --
521: -- The primary key is invalid therefore we must error
522: --
523: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
524: fnd_message.raise_error;
525: End If;
526: Close C_Sel1;
527: If (p_object_version_number <> g_old_rec.object_version_number) Then
528: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
524: fnd_message.raise_error;
525: End If;
526: Close C_Sel1;
527: If (p_object_version_number <> g_old_rec.object_version_number) Then
528: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
529: fnd_message.raise_error;
530: End If;
531: hr_utility.set_location(l_proc, 15);
532: --
525: End If;
526: Close C_Sel1;
527: If (p_object_version_number <> g_old_rec.object_version_number) Then
528: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
529: fnd_message.raise_error;
530: End If;
531: hr_utility.set_location(l_proc, 15);
532: --
533: --
550: -- We are doing a datetrack 'INSERT' which is illegal within this
551: -- procedure therefore we must error (note: to lck on insert the
552: -- private procedure ins_lck should be called).
553: --
554: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE', l_proc);
556: fnd_message.set_token('STEP','20');
557: fnd_message.raise_error;
558: End If;
551: -- procedure therefore we must error (note: to lck on insert the
552: -- private procedure ins_lck should be called).
553: --
554: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE', l_proc);
556: fnd_message.set_token('STEP','20');
557: fnd_message.raise_error;
558: End If;
559: --
552: -- private procedure ins_lck should be called).
553: --
554: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE', l_proc);
556: fnd_message.set_token('STEP','20');
557: fnd_message.raise_error;
558: End If;
559: --
560: -- Set the validation start and end date OUT arguments
553: --
554: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE', l_proc);
556: fnd_message.set_token('STEP','20');
557: fnd_message.raise_error;
558: End If;
559: --
560: -- Set the validation start and end date OUT arguments
561: --
571: --
572: -- The object is locked therefore we need to supply a meaningful
573: -- error message.
574: --
575: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
576: fnd_message.set_token('TABLE_NAME', 'ben_eligy_prfl_f');
577: fnd_message.raise_error;
578: When l_object_invalid then
579: --
572: -- The object is locked therefore we need to supply a meaningful
573: -- error message.
574: --
575: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
576: fnd_message.set_token('TABLE_NAME', 'ben_eligy_prfl_f');
577: fnd_message.raise_error;
578: When l_object_invalid then
579: --
580: -- The object doesn't exist or is invalid
573: -- error message.
574: --
575: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
576: fnd_message.set_token('TABLE_NAME', 'ben_eligy_prfl_f');
577: fnd_message.raise_error;
578: When l_object_invalid then
579: --
580: -- The object doesn't exist or is invalid
581: --
578: When l_object_invalid then
579: --
580: -- The object doesn't exist or is invalid
581: --
582: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
583: fnd_message.set_token('TABLE_NAME', 'ben_eligy_prfl_f');
584: fnd_message.raise_error;
585: End lck;
586: --
579: --
580: -- The object doesn't exist or is invalid
581: --
582: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
583: fnd_message.set_token('TABLE_NAME', 'ben_eligy_prfl_f');
584: fnd_message.raise_error;
585: End lck;
586: --
587: -- ----------------------------------------------------------------------------
580: -- The object doesn't exist or is invalid
581: --
582: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
583: fnd_message.set_token('TABLE_NAME', 'ben_eligy_prfl_f');
584: fnd_message.raise_error;
585: End lck;
586: --
587: -- ----------------------------------------------------------------------------
588: -- |-----------------------------< convert_args >-----------------------------|