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.

[Home] [Help]

APPS.PAY_SFR_BUS dependencies on HR_UTILITY

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

30: l_api_updating boolean;
31: l_disallow varchar2(1);
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: l_api_updating := pay_sfr_shd.api_updating
36: (p_formula_result_rule_id => p_rec.formula_result_rule_id
37: ,p_object_version_number => p_rec.object_version_number
38: );

Line 40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

36: (p_formula_result_rule_id => p_rec.formula_result_rule_id
37: ,p_object_version_number => p_rec.object_version_number
38: );
39: if not l_api_updating then
40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('STEP', '10');
43: hr_utility.raise_error;
44: end if;

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

37: ,p_object_version_number => p_rec.object_version_number
38: );
39: if not l_api_updating then
40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('STEP', '10');
43: hr_utility.raise_error;
44: end if;
45: --

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

38: );
39: if not l_api_updating then
40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('STEP', '10');
43: hr_utility.raise_error;
44: end if;
45: --
46: hr_utility.set_location(l_proc, 15);

Line 43: hr_utility.raise_error;

39: if not l_api_updating then
40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('STEP', '10');
43: hr_utility.raise_error;
44: end if;
45: --
46: hr_utility.set_location(l_proc, 15);
47: --

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

42: hr_utility.set_message_token('STEP', '10');
43: hr_utility.raise_error;
44: end if;
45: --
46: hr_utility.set_location(l_proc, 15);
47: --
48: -- Check that the update is actually allowed.
49: --
50: open csr_disallow_update;

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

49: --
50: open csr_disallow_update;
51: fetch csr_disallow_update into l_disallow;
52: if csr_disallow_update%found then
53: hr_utility.set_location(l_proc, 20);
54: close csr_disallow_update;
55: fnd_message.set_name('PAY', 'PAY_50094_SFR_CORE_ROW_EXISTS');
56: fnd_message.raise_error;
57: end if;

Line 65: hr_utility.set_location(l_proc, 25);

61: --
62: if nvl(p_rec.shadow_element_type_id, hr_api.g_number) <>
63: nvl(pay_sfr_shd.g_old_rec.shadow_element_type_id, hr_api.g_number)
64: then
65: hr_utility.set_location(l_proc, 25);
66: l_argument := 'p_shadow_element_type_id';
67: raise l_error;
68: end if;
69: hr_utility.set_location(' Leaving:'||l_proc, 25);

Line 69: hr_utility.set_location(' Leaving:'||l_proc, 25);

65: hr_utility.set_location(l_proc, 25);
66: l_argument := 'p_shadow_element_type_id';
67: raise l_error;
68: end if;
69: hr_utility.set_location(' Leaving:'||l_proc, 25);
70: exception
71: when l_error then
72: hr_utility.set_location('Leaving:'||l_proc, 30);
73: hr_api.argument_changed_error

Line 72: hr_utility.set_location('Leaving:'||l_proc, 30);

68: end if;
69: hr_utility.set_location(' Leaving:'||l_proc, 25);
70: exception
71: when l_error then
72: hr_utility.set_location('Leaving:'||l_proc, 30);
73: hr_api.argument_changed_error
74: (p_api_name => l_proc
75: ,p_argument => l_argument);
76: when others then

Line 77: hr_utility.set_location('Leaving:'||l_proc, 35);

73: hr_api.argument_changed_error
74: (p_api_name => l_proc
75: ,p_argument => l_argument);
76: when others then
77: hr_utility.set_location('Leaving:'||l_proc, 35);
78: raise;
79: End chk_non_updateable_args;
80: -- ----------------------------------------------------------------------------
81: -- |----------------------< chk_shadow_element_type_id >----------------------|

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

94: l_proc varchar2(72) := g_package||'chk_shadow_element_type_id';
95: l_exists varchar2(1);
96: --
97: Begin
98: hr_utility.set_location('Entering:'||l_proc, 5);
99: --
100: -- Check that the shadow element type is not null.
101: --
102: hr_api.mandatory_arg_error

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

109: --
110: open csr_shadow_element_type_exists;
111: fetch csr_shadow_element_type_exists into l_exists;
112: if csr_shadow_element_type_exists%notfound then
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: close csr_shadow_element_type_exists;
115: fnd_message.set_name('PAY', 'PAY_50095_ETM_INVALID_ELE_TYPE');
116: fnd_message.raise_error;
117: end if;

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

115: fnd_message.set_name('PAY', 'PAY_50095_ETM_INVALID_ELE_TYPE');
116: fnd_message.raise_error;
117: end if;
118: close csr_shadow_element_type_exists;
119: hr_utility.set_location(' Leaving:'||l_proc, 20);
120: End chk_shadow_element_type_id;
121: -- ----------------------------------------------------------------------------
122: -- |-----------------------< chk_result_rule_type >---------------------------|
123: -- ----------------------------------------------------------------------------

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

131: l_proc varchar2(72) := g_package||'chk_result_rule_type';
132: l_api_updating boolean;
133: --
134: Begin
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: l_api_updating := pay_sfr_shd.api_updating
137: (p_formula_result_rule_id => p_formula_result_rule_id
138: ,p_object_version_number => p_object_version_number
139: );

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

158: ,p_lookup_type => 'RESULT_RULE_TYPE'
159: ,p_lookup_code => p_result_rule_type
160: )
161: then
162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
164: fnd_message.set_token('LOOKUP_TYPE', 'RESULT_RULE_TYPE');
165: fnd_message.set_token('COLUMN', 'RESULT_RULE_TYPE');
166: fnd_message.raise_error;

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

165: fnd_message.set_token('COLUMN', 'RESULT_RULE_TYPE');
166: fnd_message.raise_error;
167: end if;
168: end if;
169: hr_utility.set_location(' Leaving:'||l_proc, 20);
170: End chk_result_rule_type;
171: -- ----------------------------------------------------------------------------
172: -- |--------------------------< chk_element_type_id >-------------------------|
173: -- ----------------------------------------------------------------------------

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

195: l_exists varchar2(1);
196: l_api_updating boolean;
197: --
198: Begin
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: l_api_updating := pay_sfr_shd.api_updating
201: (p_formula_result_rule_id => p_formula_result_rule_id
202: ,p_object_version_number => p_object_version_number
203: );

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

211: --
212: open csr_element_type_exists;
213: fetch csr_element_type_exists into l_exists;
214: if csr_element_type_exists%notfound then
215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: close csr_element_type_exists;
217: fnd_message.set_name('PAY', 'PAY_50096_SFR_ELE_ETM_MISMATCH');
218: fnd_message.raise_error;
219: end if;

Line 228: hr_utility.set_location(' Leaving:'||l_proc, 15);

224: -- Confirm that at least one of p_element_type_id and p_element_name is
225: -- null.
226: --
227: if p_element_type_id is not null and p_element_name is not null then
228: hr_utility.set_location(' Leaving:'||l_proc, 15);
229: fnd_message.set_name('PAY', 'PAY_50214_SFR_ELE_NOT_NULL');
230: fnd_message.raise_error;
231: end if;
232: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

228: hr_utility.set_location(' Leaving:'||l_proc, 15);
229: fnd_message.set_name('PAY', 'PAY_50214_SFR_ELE_NOT_NULL');
230: fnd_message.raise_error;
231: end if;
232: hr_utility.set_location(' Leaving:'||l_proc, 20);
233: End chk_element_type_id;
234: -- ----------------------------------------------------------------------------
235: -- |--------------------------< chk_input_value_id >--------------------------|
236: -- ----------------------------------------------------------------------------

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

259: l_exists varchar2(1);
260: l_api_updating boolean;
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: l_api_updating := pay_sfr_shd.api_updating
265: (p_formula_result_rule_id => p_formula_result_rule_id
266: ,p_object_version_number => p_object_version_number
267: );

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

275: --
276: open csr_input_value_exists;
277: fetch csr_input_value_exists into l_exists;
278: if csr_input_value_exists%notfound then
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: close csr_input_value_exists;
281: fnd_message.set_name('PAY', 'PAY_50098_ETM_INVALID_INP_VAL');
282: fnd_message.raise_error;
283: end if;

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

283: end if;
284: close csr_input_value_exists;
285: end if;
286: end if;
287: hr_utility.set_location(' Leaving:'||l_proc, 20);
288: End chk_input_value_id;
289: -- ----------------------------------------------------------------------------
290: -- |---------------------------< chk_result_name >---------------------------|
291: -- ----------------------------------------------------------------------------

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

303: l_rgeflg varchar2(2000);
304: l_api_updating boolean;
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: l_api_updating := pay_sfr_shd.api_updating
309: (p_formula_result_rule_id => p_formula_result_rule_id
310: ,p_object_version_number => p_object_version_number
311: );

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

327: ,rgeflg => l_rgeflg
328: ,curcode => null
329: );
330: end if;
331: hr_utility.set_location(' Leaving:'||l_proc, 20);
332: End chk_result_name;
333: -- ----------------------------------------------------------------------------
334: -- |-------------------------< chk_severity_level >---------------------------|
335: -- ----------------------------------------------------------------------------

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

345: l_api_updating boolean;
346: l_result_rule_changed boolean;
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: l_api_updating := pay_sfr_shd.api_updating
351: (p_formula_result_rule_id => p_formula_result_rule_id
352: ,p_object_version_number => p_object_version_number
353: );

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

377: ,p_lookup_type => 'MESSAGE_LEVEL'
378: ,p_lookup_code => p_severity_level
379: )
380: then
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
383: fnd_message.set_token('LOOKUP_TYPE', 'MESSAGE_LEVEL');
384: fnd_message.set_token('COLUMN', 'SEVERITY_LEVEL');
385: fnd_message.raise_error;

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

387: --
388: -- Severity level must be null otherwise.
389: --
390: elsif p_severity_level is not null then
391: hr_utility.set_location(' Leaving:'||l_proc, 10);
392: fnd_message.set_name('PAY', 'PAY_50097_SFR_SEV_LVL_NOT_NULL');
393: fnd_message.set_token('RESULT_RULE_TYPE', p_result_rule_type);
394: fnd_message.raise_error;
395: end if;

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

393: fnd_message.set_token('RESULT_RULE_TYPE', p_result_rule_type);
394: fnd_message.raise_error;
395: end if;
396: end if;
397: hr_utility.set_location(' Leaving:'||l_proc, 20);
398: End chk_severity_level;
399: -- ----------------------------------------------------------------------------
400: -- |-------------------------< chk_exclusion_rule_id >------------------------|
401: -- ----------------------------------------------------------------------------

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

420: l_api_updating boolean;
421: l_valid varchar2(1);
422: --
423: Begin
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: l_api_updating := pay_sfr_shd.api_updating
426: (p_formula_result_rule_id => p_formula_result_rule_id
427: ,p_object_version_number => p_object_version_number
428: );

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

433: if p_exclusion_rule_id is not null then
434: open csr_exclusion_rule_id_valid;
435: fetch csr_exclusion_rule_id_valid into l_valid;
436: if csr_exclusion_rule_id_valid%notfound then
437: hr_utility.set_location('Leaving:'||l_proc, 10);
438: close csr_exclusion_rule_id_valid;
439: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
440: fnd_message.raise_error;
441: end if;

Line 445: hr_utility.set_location(' Leaving:'||l_proc, 15);

441: end if;
442: close csr_exclusion_rule_id_valid;
443: end if;
444: end if;
445: hr_utility.set_location(' Leaving:'||l_proc, 15);
446: End chk_exclusion_rule_id;
447: -- ----------------------------------------------------------------------------
448: -- |------------------------------< chk_delete >------------------------------|
449: -- ----------------------------------------------------------------------------

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

463: l_error exception;
464: l_exists varchar2(1);
465: --
466: Begin
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: open csr_core_objects;
470: fetch csr_core_objects into l_exists;
471: if csr_core_objects%found then

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

468: --
469: open csr_core_objects;
470: fetch csr_core_objects into l_exists;
471: if csr_core_objects%found then
472: hr_utility.set_location(' Leaving:'||l_proc, 10);
473: close csr_core_objects;
474: raise l_error;
475: end if;
476: close csr_core_objects;

Line 477: hr_utility.set_location(' Leaving:'||l_proc, 25);

473: close csr_core_objects;
474: raise l_error;
475: end if;
476: close csr_core_objects;
477: hr_utility.set_location(' Leaving:'||l_proc, 25);
478: exception
479: when l_error then
480: fnd_message.set_name('PAY', 'PAY_50099_SFR_INVALID_DELETE');
481: fnd_message.raise_error;

Line 483: hr_utility.set_location(' Leaving:'||l_proc, 30);

479: when l_error then
480: fnd_message.set_name('PAY', 'PAY_50099_SFR_INVALID_DELETE');
481: fnd_message.raise_error;
482: when others then
483: hr_utility.set_location(' Leaving:'||l_proc, 30);
484: raise;
485: End chk_delete;
486: -- ----------------------------------------------------------------------------
487: -- |---------------------------< insert_validate >----------------------------|

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

493: --
494: l_proc varchar2(72) := g_package||'insert_validate';
495: --
496: Begin
497: hr_utility.set_location('Entering:'||l_proc, 5);
498: --
499: -- Call all supporting business operations
500: --
501: chk_shadow_element_type_id(p_rec.shadow_element_type_id);

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

543: ,p_shadow_element_type_id => p_rec.shadow_element_type_id
544: ,p_formula_result_rule_id => p_rec.formula_result_rule_id
545: ,p_object_version_number => p_rec.object_version_number
546: );
547: hr_utility.set_location(' Leaving:'||l_proc, 10);
548: End insert_validate;
549: --
550: -- ----------------------------------------------------------------------------
551: -- |---------------------------< update_validate >----------------------------|

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

557: --
558: l_proc varchar2(72) := g_package||'update_validate';
559: --
560: Begin
561: hr_utility.set_location('Entering:'||l_proc, 5);
562: --
563: -- Call all supporting business operations
564: --
565: chk_non_updateable_args(p_rec);

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

608: ,p_formula_result_rule_id => p_rec.formula_result_rule_id
609: ,p_object_version_number => p_rec.object_version_number
610: );
611: --
612: hr_utility.set_location(' Leaving:'||l_proc, 10);
613: End update_validate;
614: --
615: -- ----------------------------------------------------------------------------
616: -- |---------------------------< delete_validate >----------------------------|

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

619: --
620: l_proc varchar2(72) := g_package||'delete_validate';
621: --
622: Begin
623: hr_utility.set_location('Entering:'||l_proc, 5);
624: --
625: -- Call all supporting business operations
626: --
627: chk_delete(p_rec.formula_result_rule_id);

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

625: -- Call all supporting business operations
626: --
627: chk_delete(p_rec.formula_result_rule_id);
628: --
629: hr_utility.set_location(' Leaving:'||l_proc, 10);
630: End delete_validate;
631: --
632: end pay_sfr_bus;