eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_QSV_BUS dependencies on HR_UTILITY

Line 33: hr_utility.set_location('Entering: '||l_proc, 10);

29: l_argument varchar2(30);
30: --
31: begin
32: --
33: hr_utility.set_location('Entering: '||l_proc, 10);
34: --
35: -- Only proceed with validation if a row exists for the
36: -- current record in the HR Schema.
37: --

Line 47: hr_utility.set_location(l_proc, 30);

43: fnd_message.set_token('PROCEDURE',l_proc);
44: fnd_message.set_token('STEP',20);
45: fnd_message.raise_error;
46: end if;
47: hr_utility.set_location(l_proc, 30);
48: --
49: if nvl(p_rec.questionnaire_answer_id, hr_api.g_number)
50: <> hr_qsv_shd.g_old_rec.questionnaire_answer_id then
51: l_argument := 'questionnaire_answer_id';

Line 54: hr_utility.set_location(l_proc, 40);

50: <> hr_qsv_shd.g_old_rec.questionnaire_answer_id then
51: l_argument := 'questionnaire_answer_id';
52: raise l_error;
53: end if;
54: hr_utility.set_location(l_proc, 40);
55: --
56: if nvl(p_rec.field_id, hr_api.g_number) <> hr_qsv_shd.g_old_rec.field_id then
57: l_argument := 'field_id';
58: raise l_error;

Line 60: hr_utility.set_location('Leaving: '||l_proc,50);

56: if nvl(p_rec.field_id, hr_api.g_number) <> hr_qsv_shd.g_old_rec.field_id then
57: l_argument := 'field_id';
58: raise l_error;
59: end if;
60: hr_utility.set_location('Leaving: '||l_proc,50);
61: --
62: exception
63: when l_error then
64: hr_api.argument_changed_error

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

90: where qsa.questionnaire_answer_id = p_questionnaire_answer_id;
91: --
92: begin
93: --
94: hr_utility.set_location('Entering: '||l_proc,10);
95: --
96: if p_questionnaire_answer_id is null then
97: -- error, as this cannot be null
98: fnd_message.set_name('PER','PER_52446_QSV_MAND_ANS_ID');

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

109: end if;
110: close csr_id_exists;
111: end if;
112: --
113: hr_utility.set_location('Leaving: '||l_proc,20);
114: --
115: end chk_questionnaire_answer_id;
116: --
117: -- ----------------------------------------------------------------------------

Line 150: hr_utility.set_location('Entering: '||l_proc,10);

146: and qsv.field_id = p_field_id;
147: --
148: begin
149: --
150: hr_utility.set_location('Entering: '||l_proc,10);
151: --
152: if p_field_id is null then
153: -- Error, as this is mandatory
154: fnd_message.set_name('PER','PER_52447_QSV_MAND_FIELD_ID');

Line 167: hr_utility.set_location(l_proc,20);

163: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_FK2');
164: end if;
165: close csr_id_exists;
166: --
167: hr_utility.set_location(l_proc,20);
168: --
169: -- Check that field_id is unique for the given questionnaire_answer_id
170: --
171: open csr_chk_unique;

Line 180: hr_utility.set_location(l_proc,30);

176: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_UK1');
177: end if;
178: close csr_chk_unique;
179: --
180: hr_utility.set_location(l_proc,30);
181: --
182: -- Check that qsf.questionnaire_template_id is the same as
183: -- qsa.questionnaire_template_id.
184: --

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

189: end if;
190: --
191: end if;
192: --
193: hr_utility.set_location('Leaving: '||l_proc,20);
194: --
195: end chk_field_id;
196: --
197: -- ----------------------------------------------------------------------------

Line 210: hr_utility.set_location('Entering: '||l_proc,10);

206: l_proc varchar2(72) := g_package || 'chk_delete_allowed';
207: --
208: begin
209: --
210: hr_utility.set_location('Entering: '||l_proc,10);
211: --
212: -- Deleted check on p_value to see if it is not null and raise
213: -- error PER_52449_QSV_ANSWER_NOT_NULL, as this is required
214: -- for appraisal deletion using API, to clean up appraisals.

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

213: -- error PER_52449_QSV_ANSWER_NOT_NULL, as this is required
214: -- for appraisal deletion using API, to clean up appraisals.
215: -- Bug 3104804.
216: --
217: hr_utility.set_location('Leaving: '||l_proc,20);
218: --
219: end chk_delete_allowed;
220: --
221: -- ----------------------------------------------------------------------------

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

225: --
226: l_proc varchar2(72) := g_package||'insert_validate';
227: --
228: Begin
229: hr_utility.set_location('Entering:'||l_proc, 5);
230: --
231: -- Set the business group id
232: --
233: hr_qsa_bus.set_security_group_id

Line 236: hr_utility.set_location('Entering:'||l_proc, 7);

232: --
233: hr_qsa_bus.set_security_group_id
234: (p_questionnaire_answer_id=> p_rec.questionnaire_answer_id);
235: --
236: hr_utility.set_location('Entering:'||l_proc, 7);
237: --
238: -- Reset global g_questionnaire_template_id
239: --
240: g_questionnaire_template_id := null;

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

249: ,p_questionnaire_answer_id => p_rec.questionnaire_answer_id
250: );
251: --
252: --
253: hr_utility.set_location(' Leaving:'||l_proc, 10);
254: End insert_validate;
255: --
256: -- ----------------------------------------------------------------------------
257: -- |---------------------------< update_validate >----------------------------|

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

260: --
261: l_proc varchar2(72) := g_package||'update_validate';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: -- Set the business group id
267: --
268: hr_qsa_bus.set_security_group_id

Line 271: hr_utility.set_location('Entering:'||l_proc, 7);

267: --
268: hr_qsa_bus.set_security_group_id
269: (p_questionnaire_answer_id=> p_rec.questionnaire_answer_id);
270: --
271: hr_utility.set_location('Entering:'||l_proc, 7);
272: --
273: -- Reset global g_questionnaire_template_id to null
274: --
275: g_questionnaire_template_id := null;

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

278: --
279: hr_qsv_bus.chk_non_updateable_args(p_rec);
280: --
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 10);
283: End update_validate;
284: --
285: -- ----------------------------------------------------------------------------
286: -- |---------------------------< delete_validate >----------------------------|

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

289: --
290: l_proc varchar2(72) := g_package||'delete_validate';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- Call all supporting business operations
296: --
297: chk_delete_allowed

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

296: --
297: chk_delete_allowed
298: (p_value => hr_qsv_shd.g_old_rec.value);
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301: End delete_validate;
302: --
303: -- ----------------------------------------------------------------------------
304: -- |---------------------< return_legislation_code >--------------------------|

Line 329: hr_utility.set_location('Entering: '||l_proc, 10);

325: l_proc varchar2(72) := 'return_legislation_code';
326: --
327: begin
328: --
329: hr_utility.set_location('Entering: '||l_proc, 10);
330: --
331: hr_api.mandatory_arg_error(p_api_name => l_proc
332: ,p_argument => 'quest_answer_val_id'
333: ,p_argument_value => p_quest_answer_val_id

Line 342: hr_utility.set_location(l_proc,20);

338: -- The legislation code has already been found with a previous call
339: -- to this function. Just return the value in the global variable.
340: --
341: l_legislation_code := g_legislation_code;
342: hr_utility.set_location(l_proc,20);
343: else
344: --
345: -- The ID is different to the last call to this function, or this
346: -- is the first call to this function.

Line 358: hr_utility.set_location(l_proc,30);

354: close csr_leg_code;
355: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
356: fnd_message.raise_error;
357: end if;
358: hr_utility.set_location(l_proc,30);
359: --
360: -- Set the global variables so the values are available for the
361: -- next call to this function.
362: --

Line 368: hr_utility.set_location('Leaving: '||l_proc,40);

364: g_quest_answer_val_id := p_quest_answer_val_id;
365: g_legislation_code := l_legislation_code;
366: end if;
367: --
368: hr_utility.set_location('Leaving: '||l_proc,40);
369: --
370: return l_legislation_code;
371: end return_legislation_code;
372: --