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.PQH_RSS_BUS dependencies on HR_UTILITY

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

43: l_proc varchar2(72) := g_package||'set_security_group_id';
44: --
45: begin
46: --
47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --
51: hr_api.mandatory_arg_error

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

78: (p_security_group_id => l_security_group_id
79: );
80: end if;
81: --
82: hr_utility.set_location(' Leaving:'|| l_proc, 20);
83: --
84: end set_security_group_id;
85: --
86: -- ---------------------------------------------------------------------------

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

113: l_proc varchar2(72) := g_package||'return_legislation_code';
114: --
115: Begin
116: --
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: -- Ensure that all the mandatory parameter are not null
120: --
121: hr_api.mandatory_arg_error

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

131: -- call to this function. Just return the value in the global
132: -- variable.
133: --
134: l_legislation_code := pqh_rss_bus.g_legislation_code;
135: hr_utility.set_location(l_proc, 20);
136: else
137: --
138: -- The ID is different to the last call to this function
139: -- or this is the first call to this function.

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

148: close csr_leg_code;
149: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
150: fnd_message.raise_error;
151: end if;
152: hr_utility.set_location(l_proc,30);
153: --
154: -- Set the global variables so the values are
155: -- available for the next call to this function.
156: --

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

157: close csr_leg_code;
158: pqh_rss_bus.g_result_set_id := p_result_set_id;
159: pqh_rss_bus.g_legislation_code := l_legislation_code;
160: end if;
161: hr_utility.set_location(' Leaving:'|| l_proc, 40);
162: return l_legislation_code;
163: end return_legislation_code;
164: --
165: -- ----------------------------------------------------------------------------

Line 220: hr_utility.set_message(8302, 'PQH_DE_NONUPD_GRADE_ID');

216: -- not been updated.
217: --
218: IF nvl(p_rec.Grade_id, hr_api.g_number) <>
219: nvl(pqh_RSS_shd.g_old_rec.Grade_id, hr_api.g_number) THEN
220: hr_utility.set_message(8302, 'PQH_DE_NONUPD_GRADE_ID');
221: fnd_message.raise_error;
222:
223: END IF;
224:

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

237: l_Grade_id PQH_DE_RESULT_SETS.Grade_id%TYPE;
238:
239: l_proc varchar2(72) := g_package || 'Check_Grade_id';
240: Begin
241: hr_utility.set_location(l_proc, 10);
242: Open c_Grade_id;
243: Fetch c_Grade_id into l_Grade_id;
244: If c_Grade_id%notfound Then
245: hr_utility.set_message(8302, 'PQH_DE_Check_Grade_id');

Line 245: hr_utility.set_message(8302, 'PQH_DE_Check_Grade_id');

241: hr_utility.set_location(l_proc, 10);
242: Open c_Grade_id;
243: Fetch c_Grade_id into l_Grade_id;
244: If c_Grade_id%notfound Then
245: hr_utility.set_message(8302, 'PQH_DE_Check_Grade_id');
246: Close c_Grade_id;
247: fnd_message.raise_error;
248: End If;
249: Close c_Grade_id;

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

251: when app_exception.application_exception then
252: if hr_multi_message.exception_add
253: (p_associated_column1 => 'PQH_DE_RESULT_SETS.Grade_id'
254: ) then
255: hr_utility.set_location(' Leaving:'||l_proc,60);
256: raise;
257: end if;
258: hr_utility.set_location(' Leaving:'||l_proc,70);
259: End Chk_Grade_id;

Line 258: hr_utility.set_location(' Leaving:'||l_proc,70);

254: ) then
255: hr_utility.set_location(' Leaving:'||l_proc,60);
256: raise;
257: end if;
258: hr_utility.set_location(' Leaving:'||l_proc,70);
259: End Chk_Grade_id;
260: -- ----------------------------------------------------------------------------
261: -- |----------------------< Chk_CIVIL_SERVANTS_Grade_id >---------------------|
262: -- ----------------------------------------------------------------------------

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

325: l_CIVIL_SERVANTS_Grade_id per_grades.name%TYPE;
326: l_proc varchar2(72) := g_package || 'Check_CIVIL_Grade_id';
327:
328: Begin
329: hr_utility.set_location(l_proc, 10);
330: Open c_CIVIL_SERVANTS_Grade_id;
331: Fetch c_CIVIL_SERVANTS_Grade_id into l_CIVIL_SERVANTS_Grade_id;
332: If c_CIVIL_SERVANTS_Grade_id%notfound Then
333: hr_utility.set_message(8302, 'PQH_DE_CIVIL_SERVANTS_Grade_id');

Line 333: hr_utility.set_message(8302, 'PQH_DE_CIVIL_SERVANTS_Grade_id');

329: hr_utility.set_location(l_proc, 10);
330: Open c_CIVIL_SERVANTS_Grade_id;
331: Fetch c_CIVIL_SERVANTS_Grade_id into l_CIVIL_SERVANTS_Grade_id;
332: If c_CIVIL_SERVANTS_Grade_id%notfound Then
333: hr_utility.set_message(8302, 'PQH_DE_CIVIL_SERVANTS_Grade_id');
334: Close c_CIVIL_SERVANTS_Grade_id;
335: fnd_message.raise_error;
336: End If;
337: Close c_CIVIL_SERVANTS_Grade_id;

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

339: when app_exception.application_exception then
340: if hr_multi_message.exception_add
341: (p_associated_column1 => 'PQH_DE_RESULT_SETS.Grade_id'
342: ) then
343: hr_utility.set_location(' Leaving:'||l_proc,60);
344: raise;
345: end if;
346: hr_utility.set_location(' Leaving:'||l_proc,70);
347: End Chk_CIVIL_SERVANTS_Grade_id;

Line 346: hr_utility.set_location(' Leaving:'||l_proc,70);

342: ) then
343: hr_utility.set_location(' Leaving:'||l_proc,60);
344: raise;
345: end if;
346: hr_utility.set_location(' Leaving:'||l_proc,70);
347: End Chk_CIVIL_SERVANTS_Grade_id;
348:
349: -- ----------------------------------------------------------------------------
350: -- |---------------------------< Chk_gradual_value_numbers >------------------|

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

367:
368: l_proc varchar2(72) := g_package || 'Chk_gradual_value_numbers';
369:
370: Begin
371: hr_utility.set_location(l_proc, 10);
372:
373: if to_number(p_rec.GRADUAL_VALUE_NUMBER_FROM) < 0 or to_number(p_rec.GRADUAL_VALUE_NUMBER_TO) < 0 then
374: hr_utility.set_message(8302, 'PQH_DE_GRADUAL_NUM_NEG');
375: fnd_message.raise_error;

Line 374: hr_utility.set_message(8302, 'PQH_DE_GRADUAL_NUM_NEG');

370: Begin
371: hr_utility.set_location(l_proc, 10);
372:
373: if to_number(p_rec.GRADUAL_VALUE_NUMBER_FROM) < 0 or to_number(p_rec.GRADUAL_VALUE_NUMBER_TO) < 0 then
374: hr_utility.set_message(8302, 'PQH_DE_GRADUAL_NUM_NEG');
375: fnd_message.raise_error;
376: End If;
377:
378: if to_number(p_rec.GRADUAL_VALUE_NUMBER_FROM) > to_number(p_rec.GRADUAL_VALUE_NUMBER_TO) then

Line 379: hr_utility.set_message(8302, 'PQH_DE_Gradual_value');

375: fnd_message.raise_error;
376: End If;
377:
378: if to_number(p_rec.GRADUAL_VALUE_NUMBER_FROM) > to_number(p_rec.GRADUAL_VALUE_NUMBER_TO) then
379: hr_utility.set_message(8302, 'PQH_DE_Gradual_value');
380: fnd_message.raise_error;
381: End If;
382:
383:

Line 388: hr_utility.set_message(8302, 'PQH_DE_GRADUAL_EXIST');

384:
385: Open c_gradual_value_numbers;
386: Fetch c_gradual_value_numbers into l_gradual_value_numbers;
387: If c_gradual_value_numbers%found Then
388: hr_utility.set_message(8302, 'PQH_DE_GRADUAL_EXIST');
389: Close c_gradual_value_numbers;
390: fnd_message.raise_error;
391: End If;
392: Close c_gradual_value_numbers;

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

395: when app_exception.application_exception then
396: if hr_multi_message.exception_add
397: (p_associated_column1 => 'PQH_DE_RESULT_SETS.GRADUAL_VALUE_NUMBER_FROM'
398: ) then
399: hr_utility.set_location(' Leaving:'||l_proc,60);
400: raise;
401: end if;
402: hr_utility.set_location(' Leaving:'||l_proc,70);
403: End Chk_gradual_value_numbers;

Line 402: hr_utility.set_location(' Leaving:'||l_proc,70);

398: ) then
399: hr_utility.set_location(' Leaving:'||l_proc,60);
400: raise;
401: end if;
402: hr_utility.set_location(' Leaving:'||l_proc,70);
403: End Chk_gradual_value_numbers;
404: --
405: -- ----------------------------------------------------------------------------
406: -- |---------------------------< insert_validate >----------------------------|

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

412: --
413: l_proc varchar2(72) := g_package||'insert_validate';
414: --
415: Begin
416: hr_utility.set_location('Entering:'||l_proc, 5);
417: --
418: -- Call all supporting business operations
419: --
420: --

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

431: -- Chk_Grade_id(P_Rec);
432: --
433: -- Chk_CIVIL_SERVANTS_Grade_id(p_effective_date,P_Rec);
434: --
435: hr_utility.set_location(' Leaving:'||l_proc, 10);
436:
437: End insert_validate;
438: --
439: -- ----------------------------------------------------------------------------

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

446: --
447: l_proc varchar2(72) := g_package||'update_validate';
448: --
449: Begin
450: hr_utility.set_location('Entering:'||l_proc, 5);
451: --
452: -- Call all supporting business operations
453: --
454: --

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

468: ,p_rec => p_rec
469: );
470: --
471: --
472: hr_utility.set_location(' Leaving:'||l_proc, 10);
473: End update_validate;
474: --
475: -- ----------------------------------------------------------------------------
476: -- |---------------------------< delete_validate >----------------------------|

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

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

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

485: hr_utility.set_location('Entering:'||l_proc, 5);
486: --
487: -- Call all supporting business operations
488: --
489: hr_utility.set_location(' Leaving:'||l_proc, 10);
490: End delete_validate;
491: --
492: end pqh_rss_bus;