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

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

19: l_argument varchar2(30);
20: l_api_updating boolean;
21: --
22: Begin
23: hr_utility.set_location('Entering:'||l_proc, 5);
24: l_api_updating := pay_ter_shd.api_updating
25: (p_exclusion_rule_id => p_rec.exclusion_rule_id
26: ,p_object_version_number => p_rec.object_version_number
27: );

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

25: (p_exclusion_rule_id => p_rec.exclusion_rule_id
26: ,p_object_version_number => p_rec.object_version_number
27: );
28: if not l_api_updating then
29: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
30: hr_utility.set_message_token('PROCEDURE', l_proc);
31: hr_utility.set_message_token('STEP', '10');
32: hr_utility.raise_error;
33: end if;

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

26: ,p_object_version_number => p_rec.object_version_number
27: );
28: if not l_api_updating then
29: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
30: hr_utility.set_message_token('PROCEDURE', l_proc);
31: hr_utility.set_message_token('STEP', '10');
32: hr_utility.raise_error;
33: end if;
34: --

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

27: );
28: if not l_api_updating then
29: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
30: hr_utility.set_message_token('PROCEDURE', l_proc);
31: hr_utility.set_message_token('STEP', '10');
32: hr_utility.raise_error;
33: end if;
34: --
35: hr_utility.set_location(l_proc, 15);

Line 32: hr_utility.raise_error;

28: if not l_api_updating then
29: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
30: hr_utility.set_message_token('PROCEDURE', l_proc);
31: hr_utility.set_message_token('STEP', '10');
32: hr_utility.raise_error;
33: end if;
34: --
35: hr_utility.set_location(l_proc, 15);
36: --

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

31: hr_utility.set_message_token('STEP', '10');
32: hr_utility.raise_error;
33: end if;
34: --
35: hr_utility.set_location(l_proc, 15);
36: --
37: -- p_template_id
38: --
39: if nvl(p_rec.template_id, hr_api.g_number) <>

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

41: then
42: l_argument := 'p_template_id';
43: raise l_error;
44: end if;
45: hr_utility.set_location(' Leaving:'||l_proc, 20);
46: exception
47: when l_error then
48: hr_utility.set_location('Leaving:'||l_proc, 25);
49: hr_api.argument_changed_error

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

44: end if;
45: hr_utility.set_location(' Leaving:'||l_proc, 20);
46: exception
47: when l_error then
48: hr_utility.set_location('Leaving:'||l_proc, 25);
49: hr_api.argument_changed_error
50: (p_api_name => l_proc
51: ,p_argument => l_argument);
52: when others then

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

49: hr_api.argument_changed_error
50: (p_api_name => l_proc
51: ,p_argument => l_argument);
52: when others then
53: hr_utility.set_location('Leaving:'||l_proc, 30);
54: raise;
55: End chk_non_updateable_args;
56: -- ----------------------------------------------------------------------------
57: -- |---------------------------< chk_template_id >----------------------------|

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

72: l_proc varchar2(72) := g_package||'chk_template_id';
73: l_valid varchar2(1);
74: --
75: Begin
76: hr_utility.set_location('Entering:'||l_proc, 5);
77: --
78: -- Check that template_id is not null.
79: --
80: hr_api.mandatory_arg_error

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

87: --
88: open csr_template_id_valid;
89: fetch csr_template_id_valid into l_valid;
90: if csr_template_id_valid%notfound then
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: close csr_template_id_valid;
93: fnd_message.set_name('PAY', 'PAY_50057_BAD_SOURCE_TEMPLATE');
94: fnd_message.raise_error;
95: end if;

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

93: fnd_message.set_name('PAY', 'PAY_50057_BAD_SOURCE_TEMPLATE');
94: fnd_message.raise_error;
95: end if;
96: close csr_template_id_valid;
97: hr_utility.set_location(' Leaving:'||l_proc, 15);
98: End chk_template_id;
99: -- ----------------------------------------------------------------------------
100: -- |-------------------------< chk_flexfield_column >-------------------------|
101: -- ----------------------------------------------------------------------------

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

126: l_api_updating boolean;
127: l_clash varchar2(1);
128: --
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: l_api_updating := pay_ter_shd.api_updating
132: (p_exclusion_rule_id => p_exclusion_rule_id
133: ,p_object_version_number => p_object_version_number
134: );

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

165: -- All exceptions are due to the name being in the incorrect
166: -- format.
167: --
168: when others then
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: fnd_message.set_name('PAY', 'PAY_50130_ETM_BAD_FLEX_COLUMN');
171: fnd_message.set_token('FLEXFIELD_COLUMN', p_flexfield_column);
172: fnd_message.raise_error;
173: end;

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

177: --
178: open csr_default_value_clash;
179: fetch csr_default_value_clash into l_clash;
180: if csr_default_value_clash%found then
181: hr_utility.set_location(' Leaving:'||l_proc, 15);
182: close csr_default_value_clash;
183: fnd_message.set_name('PAY', 'PAY_50131_TER_SIV_CLASH');
184: fnd_message.raise_error;
185: end if;

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

184: fnd_message.raise_error;
185: end if;
186: close csr_default_value_clash;
187: end if;
188: hr_utility.set_location(' Leaving:'||l_proc, 20);
189: End chk_flexfield_column;
190: -- ----------------------------------------------------------------------------
191: -- |-------------------------< chk_exclusion_value >--------------------------|
192: -- ----------------------------------------------------------------------------

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

199: l_proc varchar2(72) := g_package||'chk_exclusion_value';
200: l_api_updating boolean;
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: l_api_updating := pay_ter_shd.api_updating
205: (p_exclusion_rule_id => p_exclusion_rule_id
206: ,p_object_version_number => p_object_version_number
207: );

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

217: ,p_argument => 'p_exclusion_value'
218: ,p_argument_value => p_exclusion_value
219: );
220: end if;
221: hr_utility.set_location(' Leaving:'||l_proc, 15);
222: End chk_exclusion_value;
223: -- ----------------------------------------------------------------------------
224: -- |------------------------------< chk_delete >------------------------------|
225: -- ----------------------------------------------------------------------------

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

298: l_exists varchar(1);
299: l_error exception;
300: --
301: Begin
302: hr_utility.set_location('Entering:'||l_proc, 5);
303: --
304: open csr_element_types;
305: fetch csr_element_types into l_exists;
306: if csr_element_types%found then

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

303: --
304: open csr_element_types;
305: fetch csr_element_types into l_exists;
306: if csr_element_types%found then
307: hr_utility.set_location(' Leaving:'||l_proc, 10);
308: close csr_element_types;
309: raise l_error;
310: end if;
311: close csr_element_types;

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

312: --
313: open csr_balance_types;
314: fetch csr_balance_types into l_exists;
315: if csr_balance_types%found then
316: hr_utility.set_location(' Leaving:'||l_proc, 15);
317: close csr_balance_types;
318: raise l_error;
319: end if;
320: close csr_balance_types;

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

321: --
322: open csr_input_values;
323: fetch csr_input_values into l_exists;
324: if csr_input_values%found then
325: hr_utility.set_location(' Leaving:'||l_proc, 20);
326: close csr_input_values;
327: raise l_error;
328: end if;
329: close csr_input_values;

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

330: --
331: open csr_balance_feeds;
332: fetch csr_balance_feeds into l_exists;
333: if csr_balance_feeds%found then
334: hr_utility.set_location(' Leaving:'||l_proc, 25);
335: close csr_balance_feeds;
336: raise l_error;
337: end if;
338: close csr_balance_feeds;

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

339: --
340: open csr_formula_rules;
341: fetch csr_formula_rules into l_exists;
342: if csr_formula_rules%found then
343: hr_utility.set_location(' Leaving:'||l_proc, 30);
344: close csr_formula_rules;
345: raise l_error;
346: end if;
347: close csr_formula_rules;

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

348: --
349: open csr_iterative_rules;
350: fetch csr_iterative_rules into l_exists;
351: if csr_iterative_rules%found then
352: hr_utility.set_location(' Leaving:'||l_proc, 35);
353: close csr_iterative_rules;
354: raise l_error;
355: end if;
356: close csr_iterative_rules;

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

357: --
358: open csr_ele_type_usages;
359: fetch csr_ele_type_usages into l_exists;
360: if csr_ele_type_usages%found then
361: hr_utility.set_location(' Leaving:'||l_proc, 40);
362: close csr_ele_type_usages;
363: raise l_error;
364: end if;
365: close csr_ele_type_usages;

Line 370: hr_utility.set_location(' Leaving:'||l_proc, 45);

366: --
367: open csr_gu_bal_exclusions;
368: fetch csr_gu_bal_exclusions into l_exists;
369: if csr_gu_bal_exclusions%found then
370: hr_utility.set_location(' Leaving:'||l_proc, 45);
371: close csr_gu_bal_exclusions;
372: raise l_error;
373: end if;
374: close csr_gu_bal_exclusions;

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

375: --
376: open csr_balance_classi;
377: fetch csr_balance_classi into l_exists;
378: if csr_balance_classi%found then
379: hr_utility.set_location(' Leaving:'||l_proc, 50);
380: close csr_balance_classi;
381: raise l_error;
382: end if;
383: close csr_balance_classi;

Line 388: hr_utility.set_location(' Leaving:'||l_proc, 55);

384: --
385: open csr_defined_balances;
386: fetch csr_defined_balances into l_exists;
387: if csr_defined_balances%found then
388: hr_utility.set_location(' Leaving:'||l_proc, 55);
389: close csr_defined_balances;
390: raise l_error;
391: end if;
392: close csr_defined_balances;

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

393: --
394: open csr_sub_classi_rules;
395: fetch csr_sub_classi_rules into l_exists;
396: if csr_sub_classi_rules%found then
397: hr_utility.set_location(' Leaving:'||l_proc, 60);
398: close csr_sub_classi_rules;
399: raise l_error;
400: end if;
401: close csr_sub_classi_rules;

Line 406: hr_utility.set_location(' Leaving:'||l_proc, 65);

402: --
403: open csr_template_ff_usages;
404: fetch csr_template_ff_usages into l_exists;
405: if csr_template_ff_usages%found then
406: hr_utility.set_location(' Leaving:'||l_proc, 65);
407: close csr_template_ff_usages;
408: raise l_error;
409: end if;
410: close csr_template_ff_usages;

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

411: --
412: open csr_bal_attributes;
413: fetch csr_bal_attributes into l_exists;
414: if csr_bal_attributes%found then
415: hr_utility.set_location(' Leaving:'||l_proc, 70);
416: close csr_bal_attributes;
417: raise l_error;
418: end if;
419: close csr_bal_attributes;

Line 420: hr_utility.set_location(' Leaving:'||l_proc, 75);

416: close csr_bal_attributes;
417: raise l_error;
418: end if;
419: close csr_bal_attributes;
420: hr_utility.set_location(' Leaving:'||l_proc, 75);
421: exception
422: when l_error then
423: fnd_message.set_name('PAY', 'PAY_50129_TER_INVALID_DELETE');
424: fnd_message.raise_error;

Line 426: hr_utility.set_location(' Leaving:'||l_proc, 200);

422: when l_error then
423: fnd_message.set_name('PAY', 'PAY_50129_TER_INVALID_DELETE');
424: fnd_message.raise_error;
425: when others then
426: hr_utility.set_location(' Leaving:'||l_proc, 200);
427: raise;
428: End chk_delete;
429: -- ----------------------------------------------------------------------------
430: -- |---------------------------< insert_validate >----------------------------|

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

433: --
434: l_proc varchar2(72) := g_package||'insert_validate';
435: --
436: Begin
437: hr_utility.set_location('Entering:'||l_proc, 5);
438: --
439: -- Call all supporting business operations
440: --
441: chk_template_id(p_rec.template_id);

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

452: ,p_exclusion_rule_id => p_rec.exclusion_rule_id
453: ,p_object_version_number => p_rec.object_version_number
454: );
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: End insert_validate;
458: --
459: -- ----------------------------------------------------------------------------
460: -- |---------------------------< update_validate >----------------------------|

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

463: --
464: l_proc varchar2(72) := g_package||'update_validate';
465: --
466: Begin
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: -- Call all supporting business operations
470: --
471: chk_non_updateable_args(p_rec);

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

482: ,p_exclusion_rule_id => p_rec.exclusion_rule_id
483: ,p_object_version_number => p_rec.object_version_number
484: );
485: --
486: hr_utility.set_location(' Leaving:'||l_proc, 10);
487: End update_validate;
488: --
489: -- ----------------------------------------------------------------------------
490: -- |---------------------------< delete_validate >----------------------------|

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

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

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

498: --
499: -- Call all supporting business operations
500: --
501: chk_delete(p_rec.exclusion_rule_id);
502: hr_utility.set_location(' Leaving:'||l_proc, 10);
503: End delete_validate;
504: --
505: end pay_ter_bus;