33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_DSGNTR_ENRLD_CVG_PK') 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: Else
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_DSGNTR_ENRLD_CVG_PK') 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: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
35: --
36: If (p_constraint_name = 'BEN_DSGNTR_ENRLD_CVG_PK') 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: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
36: If (p_constraint_name = 'BEN_DSGNTR_ENRLD_CVG_PK') 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: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
47: --
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
47: --
48: hr_utility.set_location(' Leaving:'||l_proc, 10);
41: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
47: --
48: hr_utility.set_location(' Leaving:'||l_proc, 10);
49: End constraint_error;
138: Close C_Sel1;
139: --
140: -- The primary key is invalid therefore we must error
141: --
142: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: End If;
145: Close C_Sel1;
146: If (p_object_version_number <> g_old_rec.object_version_number) Then
139: --
140: -- The primary key is invalid therefore we must error
141: --
142: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: End If;
145: Close C_Sel1;
146: If (p_object_version_number <> g_old_rec.object_version_number) Then
147: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
143: fnd_message.raise_error;
144: End If;
145: Close C_Sel1;
146: If (p_object_version_number <> g_old_rec.object_version_number) Then
147: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
148: fnd_message.raise_error;
149: End If;
150: hr_utility.set_location(l_proc, 15);
151: l_fct_ret := true;
144: End If;
145: Close C_Sel1;
146: If (p_object_version_number <> g_old_rec.object_version_number) Then
147: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
148: fnd_message.raise_error;
149: End If;
150: hr_utility.set_location(l_proc, 15);
151: l_fct_ret := true;
152: End If;
372: Close C_Sel1;
373: --
374: -- The primary key is invalid therefore we must error
375: --
376: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
377: fnd_message.raise_error;
378: End If;
379: Close C_Sel1;
380: If (p_object_version_number <> g_old_rec.object_version_number) Then
373: --
374: -- The primary key is invalid therefore we must error
375: --
376: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
377: fnd_message.raise_error;
378: End If;
379: Close C_Sel1;
380: If (p_object_version_number <> g_old_rec.object_version_number) Then
381: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
377: fnd_message.raise_error;
378: End If;
379: Close C_Sel1;
380: If (p_object_version_number <> g_old_rec.object_version_number) Then
381: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
382: fnd_message.raise_error;
383: End If;
384: hr_utility.set_location(l_proc, 15);
385: --
378: End If;
379: Close C_Sel1;
380: If (p_object_version_number <> g_old_rec.object_version_number) Then
381: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
382: fnd_message.raise_error;
383: End If;
384: hr_utility.set_location(l_proc, 15);
385: --
386: --
402: -- We are doing a datetrack 'INSERT' which is illegal within this
403: -- procedure therefore we must error (note: to lck on insert the
404: -- private procedure ins_lck should be called).
405: --
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc);
408: fnd_message.set_token('STEP','20');
409: fnd_message.raise_error;
410: End If;
403: -- procedure therefore we must error (note: to lck on insert the
404: -- private procedure ins_lck should be called).
405: --
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc);
408: fnd_message.set_token('STEP','20');
409: fnd_message.raise_error;
410: End If;
411: --
404: -- private procedure ins_lck should be called).
405: --
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc);
408: fnd_message.set_token('STEP','20');
409: fnd_message.raise_error;
410: End If;
411: --
412: -- Set the validation start and end date OUT arguments
405: --
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc);
408: fnd_message.set_token('STEP','20');
409: fnd_message.raise_error;
410: End If;
411: --
412: -- Set the validation start and end date OUT arguments
413: --
423: --
424: -- The object is locked therefore we need to supply a meaningful
425: -- error message.
426: --
427: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
428: fnd_message.set_token('TABLE_NAME', 'ben_dsgntr_enrld_cvg_f');
429: fnd_message.raise_error;
430: When l_object_invalid then
431: --
424: -- The object is locked therefore we need to supply a meaningful
425: -- error message.
426: --
427: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
428: fnd_message.set_token('TABLE_NAME', 'ben_dsgntr_enrld_cvg_f');
429: fnd_message.raise_error;
430: When l_object_invalid then
431: --
432: -- The object doesn't exist or is invalid
425: -- error message.
426: --
427: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
428: fnd_message.set_token('TABLE_NAME', 'ben_dsgntr_enrld_cvg_f');
429: fnd_message.raise_error;
430: When l_object_invalid then
431: --
432: -- The object doesn't exist or is invalid
433: --
430: When l_object_invalid then
431: --
432: -- The object doesn't exist or is invalid
433: --
434: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
435: fnd_message.set_token('TABLE_NAME', 'ben_dsgntr_enrld_cvg_f');
436: fnd_message.raise_error;
437: End lck;
438: --
431: --
432: -- The object doesn't exist or is invalid
433: --
434: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
435: fnd_message.set_token('TABLE_NAME', 'ben_dsgntr_enrld_cvg_f');
436: fnd_message.raise_error;
437: End lck;
438: --
439: -- ----------------------------------------------------------------------------
432: -- The object doesn't exist or is invalid
433: --
434: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
435: fnd_message.set_token('TABLE_NAME', 'ben_dsgntr_enrld_cvg_f');
436: fnd_message.raise_error;
437: End lck;
438: --
439: -- ----------------------------------------------------------------------------
440: -- |-----------------------------< convert_args >-----------------------------|