DBA Data[Home] [Help]

APPS.HR_QSF_SHD dependencies on HR_UTILITY

Line 19: hr_utility.set_location('Entering:'||l_proc, 5);

15: --
16: l_proc varchar2(72) := g_package||'constraint_error';
17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_QUEST_FIELDS_FK') Then
22: fnd_message.set_name('PER', 'PER_52416_QSF_INVAL_TEMP_ID');
23: fnd_message.raise_error;

Line 26: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

22: fnd_message.set_name('PER', 'PER_52416_QSF_INVAL_TEMP_ID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_PK') Then
25: -- Unlikely to fail.
26: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_SQL_FLAG_CHK') Then

Line 27: hr_utility.set_message_token('PROCEDURE', l_proc);

23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_PK') Then
25: -- Unlikely to fail.
26: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_SQL_FLAG_CHK') Then
31: fnd_message.set_name('PER', 'PER_52417_QSF_REQD_FLAG_INVAL');

Line 28: hr_utility.set_message_token('STEP','10');

24: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_PK') Then
25: -- Unlikely to fail.
26: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_SQL_FLAG_CHK') Then
31: fnd_message.set_name('PER', 'PER_52417_QSF_REQD_FLAG_INVAL');
32: fnd_message.raise_error;

Line 29: hr_utility.raise_error;

25: -- Unlikely to fail.
26: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_SQL_FLAG_CHK') Then
31: fnd_message.set_name('PER', 'PER_52417_QSF_REQD_FLAG_INVAL');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_TYPE_CHK') Then

Line 37: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');

33: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_TYPE_CHK') Then
34: fnd_message.set_name('PER', 'PER_52418_QSF_TYPE_INVALID');
35: fnd_message.raise_error;
36: Else
37: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
40: hr_utility.raise_error;
41: End If;

Line 38: hr_utility.set_message_token('PROCEDURE', l_proc);

34: fnd_message.set_name('PER', 'PER_52418_QSF_TYPE_INVALID');
35: fnd_message.raise_error;
36: Else
37: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
40: hr_utility.raise_error;
41: End If;
42: --

Line 39: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

35: fnd_message.raise_error;
36: Else
37: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
40: hr_utility.raise_error;
41: End If;
42: --
43: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 40: hr_utility.raise_error;

36: Else
37: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
40: hr_utility.raise_error;
41: End If;
42: --
43: hr_utility.set_location(' Leaving:'||l_proc, 10);
44: End constraint_error;

Line 43: hr_utility.set_location(' Leaving:'||l_proc, 10);

39: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
40: hr_utility.raise_error;
41: End If;
42: --
43: hr_utility.set_location(' Leaving:'||l_proc, 10);
44: End constraint_error;
45: --
46: -- ----------------------------------------------------------------------------
47: -- |-----------------------------< api_updating >-----------------------------|

Line 78: hr_utility.set_location('Entering:'||l_proc, 5);

74: l_proc varchar2(72) := g_package||'api_updating';
75: l_fct_ret boolean;
76: --
77: Begin
78: hr_utility.set_location('Entering:'||l_proc, 5);
79: --
80: If (
81: p_field_id is null and
82: p_object_version_number is null

Line 94: hr_utility.set_location(l_proc, 10);

90: If (
91: p_field_id = g_old_rec.field_id and
92: p_object_version_number = g_old_rec.object_version_number
93: ) Then
94: hr_utility.set_location(l_proc, 10);
95: --
96: -- The g_old_rec is current therefore we must
97: -- set the returning function to true
98: --

Line 111: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');

107: Close C_Sel1;
108: --
109: -- The primary key is invalid therefore we must error
110: --
111: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');
112: hr_utility.raise_error;
113: End If;
114: Close C_Sel1;
115: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 112: hr_utility.raise_error;

108: --
109: -- The primary key is invalid therefore we must error
110: --
111: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');
112: hr_utility.raise_error;
113: End If;
114: Close C_Sel1;
115: If (p_object_version_number <> g_old_rec.object_version_number) Then
116: hr_utility.set_message('PER', 'HR_7155_OBJECT_INVALID');

Line 116: hr_utility.set_message('PER', 'HR_7155_OBJECT_INVALID');

112: hr_utility.raise_error;
113: End If;
114: Close C_Sel1;
115: If (p_object_version_number <> g_old_rec.object_version_number) Then
116: hr_utility.set_message('PER', 'HR_7155_OBJECT_INVALID');
117: hr_utility.raise_error;
118: End If;
119: hr_utility.set_location(l_proc, 15);
120: l_fct_ret := true;

Line 117: hr_utility.raise_error;

113: End If;
114: Close C_Sel1;
115: If (p_object_version_number <> g_old_rec.object_version_number) Then
116: hr_utility.set_message('PER', 'HR_7155_OBJECT_INVALID');
117: hr_utility.raise_error;
118: End If;
119: hr_utility.set_location(l_proc, 15);
120: l_fct_ret := true;
121: End If;

Line 119: hr_utility.set_location(l_proc, 15);

115: If (p_object_version_number <> g_old_rec.object_version_number) Then
116: hr_utility.set_message('PER', 'HR_7155_OBJECT_INVALID');
117: hr_utility.raise_error;
118: End If;
119: hr_utility.set_location(l_proc, 15);
120: l_fct_ret := true;
121: End If;
122: End If;
123: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 123: hr_utility.set_location(' Leaving:'||l_proc, 20);

119: hr_utility.set_location(l_proc, 15);
120: l_fct_ret := true;
121: End If;
122: End If;
123: hr_utility.set_location(' Leaving:'||l_proc, 20);
124: Return (l_fct_ret);
125: --
126: End api_updating;
127: --

Line 158: hr_utility.set_location('Entering:'||l_proc, 5);

154: --
155: l_proc varchar2(72) := g_package||'lck';
156: --
157: Begin
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: hr_api.mandatory_arg_error
161: (p_api_name => l_proc
162: ,p_argument => 'field_id'

Line 177: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');

173: Close C_Sel1;
174: --
175: -- The primary key is invalid therefore we must error
176: --
177: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');
178: hr_utility.raise_error;
179: End If;
180: Close C_Sel1;
181: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 178: hr_utility.raise_error;

174: --
175: -- The primary key is invalid therefore we must error
176: --
177: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');
178: hr_utility.raise_error;
179: End If;
180: Close C_Sel1;
181: If (p_object_version_number <> g_old_rec.object_version_number) Then
182: hr_utility.set_message('PER', 'HR_7155_OBJECT_INVALID');

Line 182: hr_utility.set_message('PER', 'HR_7155_OBJECT_INVALID');

178: hr_utility.raise_error;
179: End If;
180: Close C_Sel1;
181: If (p_object_version_number <> g_old_rec.object_version_number) Then
182: hr_utility.set_message('PER', 'HR_7155_OBJECT_INVALID');
183: hr_utility.raise_error;
184: End If;
185: --
186: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 183: hr_utility.raise_error;

179: End If;
180: Close C_Sel1;
181: If (p_object_version_number <> g_old_rec.object_version_number) Then
182: hr_utility.set_message('PER', 'HR_7155_OBJECT_INVALID');
183: hr_utility.raise_error;
184: End If;
185: --
186: hr_utility.set_location(' Leaving:'||l_proc, 10);
187: --

Line 186: hr_utility.set_location(' Leaving:'||l_proc, 10);

182: hr_utility.set_message('PER', 'HR_7155_OBJECT_INVALID');
183: hr_utility.raise_error;
184: End If;
185: --
186: hr_utility.set_location(' Leaving:'||l_proc, 10);
187: --
188: -- We need to trap the ORA LOCK exception
189: --
190: Exception

Line 196: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');

192: --
193: -- The object is locked therefore we need to supply a meaningful
194: -- error message.
195: --
196: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');
197: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_fields');
198: hr_utility.raise_error;
199: End lck;
200: --

Line 197: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_fields');

193: -- The object is locked therefore we need to supply a meaningful
194: -- error message.
195: --
196: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');
197: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_fields');
198: hr_utility.raise_error;
199: End lck;
200: --
201: -- ----------------------------------------------------------------------------

Line 198: hr_utility.raise_error;

194: -- error message.
195: --
196: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');
197: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_fields');
198: hr_utility.raise_error;
199: End lck;
200: --
201: -- ----------------------------------------------------------------------------
202: -- |-----------------------------< convert_args >-----------------------------|

Line 225: hr_utility.set_location('Entering:'||l_proc, 5);

221: l_proc varchar2(72) := g_package||'convert_args';
222: --
223: Begin
224: --
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: --
227: -- Convert arguments into local l_rec structure.
228: --
229: l_rec.field_id := p_field_id;

Line 243: hr_utility.set_location(' Leaving:'||l_proc, 10);

239: l_rec.display_sequence := p_display_sequence;
240: --
241: -- Return the plsql record structure.
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
244: Return(l_rec);
245: --
246: End convert_args;
247: --