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_QSA_BUS dependencies on HR_UTILITY

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

36: --
37: l_security_group_id number;
38: l_proc varchar2(72) := g_package||'set_security_group_id';
39: begin
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

51: close csr_sec_grp;
52: --
53: -- The primary key is invalid therefore we must error
54: --
55: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');
56: hr_utility.raise_error;
57: end if;
58: close csr_sec_grp;
59: --

Line 56: hr_utility.raise_error;

52: --
53: -- The primary key is invalid therefore we must error
54: --
55: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');
56: hr_utility.raise_error;
57: end if;
58: close csr_sec_grp;
59: --
60: -- Set the security_group_id in CLIENT_INFO

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

62: hr_api.set_security_group_id
63: (p_security_group_id => l_security_group_id
64: );
65: --
66: hr_utility.set_location(' Leaving:'|| l_proc, 20);
67: end set_security_group_id;
68: -- ----------------------------------------------------------------------------
69: -- |-------------------< chk_questionnaire_template_id >----------------------|
70: -- ----------------------------------------------------------------------------

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

136:
137: --
138: begin
139: --
140: hr_utility.set_location('Entering: '||l_proc, 10);
141: --
142: if p_questionnaire_template_id is null then
143: -- Item is a mandatory parameter, thus error.
144: fnd_message.set_name('PER','PER_52430_QSA_MAND_TEMPLATE');

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

143: -- Item is a mandatory parameter, thus error.
144: fnd_message.set_name('PER','PER_52430_QSA_MAND_TEMPLATE');
145: fnd_message.raise_error;
146: else
147: hr_utility.set_location(l_proc,20);
148: --
149: -- Check item exists in hr_questionnaires.
150: open csr_id_exists;
151: fetch csr_id_exists into l_bus_grp_id;

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

155: hr_qsa_shd.constraint_error('HR_QUEST_ANSWERS_FK1');
156: end if;
157: close csr_id_exists;
158: --
159: hr_utility.set_location(l_proc,30);
160: --
161: if p_type = 'APPRAISAL' then
162: -- Check that questionnaire_template_id is valid against
163: -- PER_APPRAISAL_TEMPLATES

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

171: fnd_message.raise_error;
172: end if;
173: close csr_appraisal_valid;
174: --
175: hr_utility.set_location(l_proc,40);
176: --
177: elsif p_type = 'PARTICIPANT' then
178: --
179: hr_utility.set_location(l_proc,50);

Line 179: hr_utility.set_location(l_proc,50);

175: hr_utility.set_location(l_proc,40);
176: --
177: elsif p_type = 'PARTICIPANT' then
178: --
179: hr_utility.set_location(l_proc,50);
180: --
181: --
182: hr_utility.set_location(l_proc,60);
183: --

Line 182: hr_utility.set_location(l_proc,60);

178: --
179: hr_utility.set_location(l_proc,50);
180: --
181: --
182: hr_utility.set_location(l_proc,60);
183: --
184: else
185: -- currently no other types, so do nothing.
186: null;

Line 203: hr_utility.set_location(l_proc,70);

199: fnd_message.raise_error;
200: end if;
201: */
202: --
203: hr_utility.set_location(l_proc,70);
204: --
205: end if;
206: --
207: hr_utility.set_location('Leaving: '||l_proc,80);

Line 207: hr_utility.set_location('Leaving: '||l_proc,80);

203: hr_utility.set_location(l_proc,70);
204: --
205: end if;
206: --
207: hr_utility.set_location('Leaving: '||l_proc,80);
208: --
209: end chk_questionnaire_template_id;
210: --
211: -- ----------------------------------------------------------------------------

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

220: l_proc varchar2(72) := g_package || 'chk_type';
221: --
222: begin
223: --
224: hr_utility.set_location('Entering: '||l_proc,10);
225: --
226: if p_type is not null then
227: -- Check that p_type exists in lookup
228: if hr_api.not_exists_in_hr_lookups

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

238: fnd_message.set_name('PER','PER_52432_QSA_MAND_TYPE');
239: fnd_message.raise_error;
240: end if;
241: --
242: hr_utility.set_location('Leaving: '||l_proc,20);
243: --
244: end chk_type;
245: --
246: -- ----------------------------------------------------------------------------

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

285: where qsa.type_object_id = p_type_object_id
286: and qsa.type = p_type;
287: begin
288: --
289: hr_utility.set_location('Entering: '||l_proc, 10);
290: --
291: if p_type_object_id is null then
292: -- type_object_id is mandatory, thus raise error.
293: fnd_message.set_name('PER','PER_52433_QSA_MAND_OBJECT_ID');

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

301: hr_qsa_shd.constraint_error('HR_QUEST_ANSWERS_UK1');
302: end if;
303: close csr_unique_id;
304: --
305: hr_utility.set_location(l_proc,20);
306: --
307: if p_type = 'APPRAISAL' then
308: --
309: hr_utility.set_location(l_proc,30);

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

305: hr_utility.set_location(l_proc,20);
306: --
307: if p_type = 'APPRAISAL' then
308: --
309: hr_utility.set_location(l_proc,30);
310: --
311: -- Check type_object_id for APPRAISAL
312: open csr_type_appraisal;
313: fetch csr_type_appraisal into l_bus_grp_id;

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

317: fnd_message.set_name('PER','PER_52434_QSA_INVAL_TYPE_OBJ');
318: fnd_message.raise_error;
319: else
320: --
321: hr_utility.set_location(l_proc,40);
322: --
323: close csr_type_appraisal;
324: if l_bus_grp_id <> p_business_group_id then
325: -- Appraisal doesnt exist in the given business group

Line 332: hr_utility.set_location(l_proc,50);

328: end if;
329: end if;
330: elsif p_type = 'PARTICIPANT' then
331: --
332: hr_utility.set_location(l_proc,50);
333: --
334: lv_cross_business_group := fnd_profile.value('HR_CROSS_BUSINESS_GROUP'); -- bug 1980440 fix
335: -- Check type_object_id for PARTICIPANT
336: open csr_type_participant;

Line 347: hr_utility.set_location(l_proc,60);

343: fnd_message.raise_error;
344: else
345: close csr_type_participant;
346: --
347: hr_utility.set_location(l_proc,60);
348: -- bug 1980440 fix starts
349: if lv_cross_business_group <> 'Y' THEN
350: if l_bus_grp_id <> p_business_group_id then
351: -- Participant doesnt exist in the given business group

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

354: end if;
355: end if;
356: -- bug 1980440 fix ends
357: --
358: hr_utility.set_location(l_proc,70);
359: --
360: if (l_part_in_tab <> 'PER_APPRAISALS') and
361: (l_part_in_col <> 'APPRAISAL_ID') then
362: -- Invalid combination, raise error.

Line 369: hr_utility.set_location(l_proc,80);

365: end if;
366: end if;
367: else
368: --
369: hr_utility.set_location(l_proc,80);
370: --
371: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE',l_proc);
373: fnd_message.set_token('STEP','80');

Line 377: hr_utility.set_location('Leaving: '||l_proc,90);

373: fnd_message.set_token('STEP','80');
374: fnd_message.raise_error;
375: end if;
376: --
377: hr_utility.set_location('Leaving: '||l_proc,90);
378: end if;
379: --
380: end chk_type_object_id;
381: --

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

399: where qsv.questionnaire_answer_id = p_questionnaire_answer_id;
400: --
401: begin
402: --
403: hr_utility.set_location('Entering: '||l_proc,10);
404: --
405: hr_api.mandatory_arg_error
406: (p_api_name => l_proc
407: ,p_argument => 'questionnaire_answer_id'

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

418: fnd_message.raise_error;
419: end if;
420: close csr_chk_child_row;
421: --
422: hr_utility.set_location('Leaving: '||l_proc, 20);
423: --
424: end chk_row_delete;
425: --
426: -- ----------------------------------------------------------------------------

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

432: --
433: l_proc varchar2(72) := g_package||'insert_validate';
434: --
435: Begin
436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: -- Call all supporting business operations
439: --
440: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

454: ,p_type_object_id => p_rec.type_object_id
455: ,p_business_group_id => p_rec.business_group_id
456: );
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 10);
459: End insert_validate;
460: --
461: -- ----------------------------------------------------------------------------
462: -- |---------------------------< update_validate >----------------------------|

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

466: --
467: l_proc varchar2(72) := g_package||'update_validate';
468: --
469: Begin
470: hr_utility.set_location('Entering:'||l_proc, 5);
471: --
472: -- Call all supporting business operations
473: --
474: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

472: -- Call all supporting business operations
473: --
474: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 10);
477: End update_validate;
478: --
479: -- ----------------------------------------------------------------------------
480: -- |---------------------------< delete_validate >----------------------------|

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

483: --
484: l_proc varchar2(72) := g_package||'delete_validate';
485: --
486: Begin
487: hr_utility.set_location('Entering:'||l_proc, 5);
488: --
489: -- Call all supporting business operations
490: --
491: chk_row_delete(p_questionnaire_answer_id

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

490: --
491: chk_row_delete(p_questionnaire_answer_id
492: => p_rec.questionnaire_answer_id);
493: --
494: hr_utility.set_location(' Leaving:'||l_proc, 10);
495: End delete_validate;
496: --
497: -- ----------------------------------------------------------------------------
498: -- |--------------------< return_legislation_code >---------------------------|

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

515: --
516: l_legislation_code varchar2(150);
517: l_proc varchar2(72) := 'return_legislation_code';
518: begin
519: hr_utility.set_location('Entering: '|| l_proc, 10);
520: --
521: hr_api.mandatory_arg_error(p_api_name => l_proc
522: ,p_argument => 'questionnaire_answer_id'
523: ,p_argument_value => p_questionnaire_answer_id

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

529: -- The legislation code has already been found with a previous call
530: -- to this function Just return the value in the global variable.
531: --
532: l_legislation_code := g_legislation_code;
533: hr_utility.set_location(l_proc,20);
534: else
535: --
536: -- The ID is different to the last call to this function, or this
537: -- is the first call to this function.

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

545: close csr_leg_code;
546: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
547: fnd_message.raise_error;
548: end if;
549: hr_utility.set_location(l_proc,30);
550: --
551: -- Set the global variable so the values are available for the
552: -- next call to this function.
553: --

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

554: close csr_leg_code;
555: g_questionnaire_answer_id := p_questionnaire_answer_id;
556: g_legislation_code := l_legislation_code;
557: end if;
558: hr_utility.set_location('Leaving: '||l_proc, 40);
559: --
560: return l_legislation_code;
561: end return_legislation_code;
562: --