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

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

29: l_argument varchar2(30);
30: l_disallow varchar2(1);
31: --
32: Begin
33: hr_utility.set_location('Entering:'||l_proc, 5);
34: l_api_updating := pay_sf_shd.api_updating
35: (p_formula_id => p_rec.formula_id
36: ,p_object_version_number => p_rec.object_version_number
37: );

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

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

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

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

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

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

Line 42: hr_utility.raise_error;

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

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

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

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

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

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

93: l_argument := 'p_formula_name';
94: raise l_error;
95: end if;
96:
97: hr_utility.set_location('Leaving:'||l_proc, 25);
98: exception
99: when l_error then
100: hr_utility.set_location('Leaving:'||l_proc, 30);
101: hr_api.argument_changed_error

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

96:
97: hr_utility.set_location('Leaving:'||l_proc, 25);
98: exception
99: when l_error then
100: hr_utility.set_location('Leaving:'||l_proc, 30);
101: hr_api.argument_changed_error
102: (p_api_name => l_proc
103: ,p_argument => l_argument);
104: when others then

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

101: hr_api.argument_changed_error
102: (p_api_name => l_proc
103: ,p_argument => l_argument);
104: when others then
105: hr_utility.set_location('Leaving:'||l_proc, 35);
106: raise;
107: End chk_non_updateable_args;
108: -- ----------------------------------------------------------------------------
109: -- |-------------------------< chk_busgrp_legcode >---------------------------|

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

123: l_proc varchar2(72) := g_package||'chk_busgrp_legcode';
124: l_valid varchar2(1);
125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: -- Check that at least one of legislation_code and business_group_id
130: -- is null.
131: --

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

130: -- is null.
131: --
132: if p_business_group_id is not null and p_legislation_code is not null
133: then
134: hr_utility.set_location(' Leaving:'||l_proc, 10);
135: fnd_message.set_name('PAY', 'PAY_50069_ETM_LEG_BUS_NOT_NULL');
136: fnd_message.raise_error;
137: end if;
138: --

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

148: p_legislation_code <> 'ZZ' then
149: open csr_valid_leg_code;
150: fetch csr_valid_leg_code into l_valid;
151: if csr_valid_leg_code%notfound then
152: hr_utility.set_location(' Leaving:'||l_proc, 15);
153: close csr_valid_leg_code;
154: fnd_message.set_name('PAY', 'PAY_50070_INVALID_LEG_CODE');
155: fnd_message.raise_error;
156: end if;

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

155: fnd_message.raise_error;
156: end if;
157: close csr_valid_leg_code;
158: end if;
159: hr_utility.set_location(' Leaving:'||l_proc, 20);
160: End chk_busgrp_legcode;
161: -- ----------------------------------------------------------------------------
162: -- |---------------------------< chk_formula_name >---------------------------|
163: -- ----------------------------------------------------------------------------

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

207: l_output varchar2(2000);
208: l_rgeflg varchar2(2000);
209: --
210: Begin
211: hr_utility.set_location('Entering:'||l_proc, 5);
212: --
213: -- Check that the name is not null.
214: --
215: hr_api.mandatory_arg_error

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

261: );
262: fetch csr_T_formula_name_exists into l_exists;
263: if csr_T_formula_name_exists%found then
264: close csr_T_formula_name_exists;
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: fnd_message.set_name('PAY', 'PAY_50102_SF_FORMULA_EXISTS');
267: fnd_message.set_token('FORMULA_NAME', p_formula_name);
268: fnd_message.raise_error;
269: end if;

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

271: elsif p_template_type = 'U' then
272: open csr_U_formula_name_exists;
273: fetch csr_U_formula_name_exists into l_exists;
274: if csr_U_formula_name_exists%found then
275: hr_utility.set_location(' Leaving:'||l_proc, 15);
276: close csr_U_formula_name_exists;
277: fnd_message.set_name('PAY', 'PAY_50102_SF_FORMULA_EXISTS');
278: fnd_message.set_token('FORMULA_NAME', p_formula_name);
279: fnd_message.raise_error;

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

279: fnd_message.raise_error;
280: end if;
281: close csr_U_formula_name_exists;
282: end if;
283: hr_utility.set_location(' Leaving:'||l_proc, 20);
284: End chk_formula_name;
285: --
286: -- ----------------------------------------------------------------------------
287: -- |--------------------------< chk_template_type >---------------------------|

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

295: --
296: l_proc varchar2(72) := g_package||'chk_template_type';
297: --
298: Begin
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: -- Check that the template type is not null.
302: --
303: hr_api.mandatory_arg_error

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

314: ,p_lookup_type => 'ELEMENT_TEMPLATE_TYPE'
315: ,p_lookup_code => p_template_type
316: )
317: then
318: hr_utility.set_location(' Leaving:'||l_proc, 10);
319: fnd_message.set_name('PAY', 'PAY_50082_ETM_BAD_TEMP_TYPE');
320: fnd_message.set_token('TEMPLATE_TYPE', p_template_type);
321: fnd_message.raise_error;
322: end if;

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

326: --
327: if p_template_type = 'U' and
328: (p_legislation_code is not null or p_business_group_id is null)
329: then
330: hr_utility.set_location(' Leaving:'||l_proc, 20);
331: fnd_message.set_name('PAY', 'PAY_50081_ETM_BAD_BUS_GROUP');
332: fnd_message.raise_error;
333: end if;
334: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

330: hr_utility.set_location(' Leaving:'||l_proc, 20);
331: fnd_message.set_name('PAY', 'PAY_50081_ETM_BAD_BUS_GROUP');
332: fnd_message.raise_error;
333: end if;
334: hr_utility.set_location(' Leaving:'||l_proc, 20);
335: End chk_template_type;
336: -- ----------------------------------------------------------------------------
337: -- |------------------------------< chk_delete >------------------------------|
338: -- ----------------------------------------------------------------------------

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

368: l_exists varchar2(1);
369: l_error exception;
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: open csr_element_types;
375: fetch csr_element_types into l_exists;
376: if csr_element_types%found then

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

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

Line 386: hr_utility.set_location(' Leaving:'||l_proc, 12);

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

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

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

Line 404: hr_utility.set_location(' Leaving:'||l_proc, 18);

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

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

406: raise l_error;
407: end if;
408: close csr_ff_usages;
409: --
410: hr_utility.set_location(' Leaving:'||l_proc, 50);
411: exception
412: when l_error then
413: fnd_message.set_name('PAY', 'PAY_50103_SF_INVALID_DELETE');
414: fnd_message.raise_error;

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

412: when l_error then
413: fnd_message.set_name('PAY', 'PAY_50103_SF_INVALID_DELETE');
414: fnd_message.raise_error;
415: when others then
416: hr_utility.set_location(' Leaving:'||l_proc, 60);
417: raise;
418: End chk_delete;
419: -- ----------------------------------------------------------------------------
420: -- |---------------------------< insert_validate >----------------------------|

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

426: --
427: l_proc varchar2(72) := g_package||'insert_validate';
428: --
429: Begin
430: hr_utility.set_location('Entering:'||l_proc, 5);
431: --
432: -- Call all supporting business operations
433: --
434: chk_busgrp_legcode

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

449: ,p_legislation_code => p_rec.legislation_code
450: ,p_business_group_id => p_rec.business_group_id
451: );
452: --
453: hr_utility.set_location(' Leaving:'||l_proc, 10);
454: End insert_validate;
455: --
456: -- ----------------------------------------------------------------------------
457: -- |---------------------------< 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 473: hr_utility.set_location(' Leaving:'||l_proc, 10);

469: -- Call all supporting business operations
470: --
471: chk_non_updateable_args(p_rec);
472: --
473: hr_utility.set_location(' Leaving:'||l_proc, 10);
474: End update_validate;
475: --
476: -- ----------------------------------------------------------------------------
477: -- |---------------------------< delete_validate >----------------------------|

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

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

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

486: -- Call all supporting business operations
487: --
488: chk_delete(p_rec.formula_id);
489: --
490: hr_utility.set_location(' Leaving:'||l_proc, 10);
491: End delete_validate;
492: --
493: end pay_sf_bus;