DBA Data[Home] [Help]

APPS.BEN_PRC_SHD dependencies on FND_MESSAGE

Line 40: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

Line 41: fnd_message.set_token('PROCEDURE', l_proc);

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');

Line 42: fnd_message.set_token('STEP','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');
46: fnd_message.set_token('PROCEDURE', l_proc);

Line 43: fnd_message.raise_error;

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');

Line 45: 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');
48: fnd_message.raise_error;
49: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_FK3') Then

Line 46: 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
50: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 47: fnd_message.set_token('STEP','10');

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);

Line 48: 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);
52: fnd_message.set_token('STEP','15');

Line 50: 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');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'BEN_PRTT_REIMBMT_RQST_F_PK') Then

Line 51: 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
55: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 52: fnd_message.set_token('STEP','15');

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);

Line 53: 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);
57: fnd_message.set_token('STEP','20');

Line 55: 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');
58: fnd_message.raise_error;
59: Else

Line 56: 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
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 57: fnd_message.set_token('STEP','20');

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);

Line 58: 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);
62: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

Line 60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

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;

Line 61: 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;
65: --

Line 62: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

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);

Line 63: 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);
67: End constraint_error;

Line 196: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

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

Line 197: fnd_message.raise_error;

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');

Line 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;

Line 202: 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;
206: End If;

Line 241: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 242: fnd_message.set_token('PROCEDURE', l_proc);

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;

Line 243: fnd_message.set_token('STEP','10');

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: --

Line 244: fnd_message.raise_error;

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

Line 486: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

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

Line 487: fnd_message.raise_error;

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');

Line 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: --

Line 492: 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: --
496: --

Line 518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 519: fnd_message.set_token('PROCEDURE', l_proc);

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: --

Line 520: fnd_message.set_token('STEP','20');

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

Line 521: fnd_message.raise_error;

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: --

Line 539: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');

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: --

Line 540: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');

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

Line 541: fnd_message.raise_error;

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: --

Line 546: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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: --

Line 547: fnd_message.set_token('TABLE_NAME', 'ben_prtt_reimbmt_rqst_f');

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: -- ----------------------------------------------------------------------------

Line 548: fnd_message.raise_error;

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 >-----------------------------|