DBA Data[Home] [Help]

APPS.BEN_XWC_SHD dependencies on FND_MESSAGE

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

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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_EXT_WHERE_CLAUSE_FK2') Then

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

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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_EXT_WHERE_CLAUSE_FK2') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 39: fnd_message.set_token('STEP','5');

35: --
36: If (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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_EXT_WHERE_CLAUSE_FK2') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);

Line 40: fnd_message.raise_error;

36: If (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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_EXT_WHERE_CLAUSE_FK2') 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');

Line 42: 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_EXT_WHERE_CLAUSE_FK2') 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_EXT_WHERE_CLAUSE_FK3') Then

Line 43: 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_EXT_WHERE_CLAUSE_FK2') 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_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') 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_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);

Line 45: fnd_message.raise_error;

41: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') 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_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');

Line 47: 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_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then

Line 48: 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_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);

Line 50: fnd_message.raise_error;

46: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');

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

48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then

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

49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);

Line 55: fnd_message.raise_error;

51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','25');

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

53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_PK') Then

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

54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 59: fnd_message.set_token('STEP','25');

55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);

Line 60: fnd_message.raise_error;

56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','30');

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

58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','30');
65: fnd_message.raise_error;
66: Else

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

59: fnd_message.set_token('STEP','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','30');
65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 64: fnd_message.set_token('STEP','30');

60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','30');
65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);

Line 65: fnd_message.raise_error;

61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','30');
65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

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

63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','30');
65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
70: fnd_message.raise_error;
71: End If;

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

64: fnd_message.set_token('STEP','30');
65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
70: fnd_message.raise_error;
71: End If;
72: --

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

65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
70: fnd_message.raise_error;
71: End If;
72: --
73: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 70: fnd_message.raise_error;

66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
70: fnd_message.raise_error;
71: End If;
72: --
73: hr_utility.set_location(' Leaving:'||l_proc, 10);
74: End constraint_error;

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

144: Close C_Sel1;
145: --
146: -- The primary key is invalid therefore we must error
147: --
148: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 149: fnd_message.raise_error;

145: --
146: -- The primary key is invalid therefore we must error
147: --
148: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
153: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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

149: fnd_message.raise_error;
150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
153: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
154: fnd_message.raise_error;
155: End If;
156: hr_utility.set_location(l_proc, 15);
157: l_fct_ret := true;

Line 154: fnd_message.raise_error;

150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
153: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
154: fnd_message.raise_error;
155: End If;
156: hr_utility.set_location(l_proc, 15);
157: l_fct_ret := true;
158: End If;

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

214: Close C_Sel1;
215: --
216: -- The primary key is invalid therefore we must error
217: --
218: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
219: fnd_message.raise_error;
220: End If;
221: Close C_Sel1;
222: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 219: fnd_message.raise_error;

215: --
216: -- The primary key is invalid therefore we must error
217: --
218: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
219: fnd_message.raise_error;
220: End If;
221: Close C_Sel1;
222: If (p_object_version_number <> g_old_rec.object_version_number) Then
223: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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

219: fnd_message.raise_error;
220: End If;
221: Close C_Sel1;
222: If (p_object_version_number <> g_old_rec.object_version_number) Then
223: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
224: fnd_message.raise_error;
225: End If;
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 224: fnd_message.raise_error;

220: End If;
221: Close C_Sel1;
222: If (p_object_version_number <> g_old_rec.object_version_number) Then
223: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
224: fnd_message.raise_error;
225: End If;
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: --

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

233: --
234: -- The object is locked therefore we need to supply a meaningful
235: -- error message.
236: --
237: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
238: fnd_message.set_token('TABLE_NAME', 'ben_ext_where_clause');
239: fnd_message.raise_error;
240: End lck;
241: --

Line 238: fnd_message.set_token('TABLE_NAME', 'ben_ext_where_clause');

234: -- The object is locked therefore we need to supply a meaningful
235: -- error message.
236: --
237: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
238: fnd_message.set_token('TABLE_NAME', 'ben_ext_where_clause');
239: fnd_message.raise_error;
240: End lck;
241: --
242: -- ----------------------------------------------------------------------------

Line 239: fnd_message.raise_error;

235: -- error message.
236: --
237: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
238: fnd_message.set_token('TABLE_NAME', 'ben_ext_where_clause');
239: fnd_message.raise_error;
240: End lck;
241: --
242: -- ----------------------------------------------------------------------------
243: -- |-----------------------------< convert_args >-----------------------------|