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_SDB_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_sdb_shd.api_updating
36: (p_defined_balance_id => p_rec.defined_balance_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_defined_balance_id => p_rec.defined_balance_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_50090_SDB_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.balance_type_id, hr_api.g_number) <>
63: nvl(pay_sdb_shd.g_old_rec.balance_type_id, hr_api.g_number)
64: then
65: hr_utility.set_location(l_proc, 25);
66: l_argument := 'p_balance_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_balance_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_exclusion_rule_id >------------------------|

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

102: l_api_updating boolean;
103: l_valid varchar2(1);
104: --
105: Begin
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: l_api_updating := pay_sdb_shd.api_updating
108: (p_defined_balance_id => p_defined_balance_id
109: ,p_object_version_number => p_object_version_number
110: );

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

115: if p_exclusion_rule_id is not null then
116: open csr_exclusion_rule_id_valid;
117: fetch csr_exclusion_rule_id_valid into l_valid;
118: if csr_exclusion_rule_id_valid%notfound then
119: hr_utility.set_location('Leaving:'||l_proc, 10);
120: close csr_exclusion_rule_id_valid;
121: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
122: fnd_message.raise_error;
123: end if;

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

123: end if;
124: close csr_exclusion_rule_id_valid;
125: end if;
126: end if;
127: hr_utility.set_location('Leaving:'||l_proc, 5);
128: end chk_exclusion_rule_id;
129: -- ----------------------------------------------------------------------------
130: -- |--------------------------< chk_balance_type_id >-------------------------|
131: -- ----------------------------------------------------------------------------

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

143: l_proc varchar2(72) := g_package||'chk_balance_type_id';
144: l_exists varchar2(1);
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: -- Check that the balance type is not null.
150: --
151: hr_api.mandatory_arg_error

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

158: --
159: open csr_balance_type_exists;
160: fetch csr_balance_type_exists into l_exists;
161: if csr_balance_type_exists%notfound then
162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: close csr_balance_type_exists;
164: fnd_message.set_name('PAY', 'PAY_50086_ETM_INVALID_BAL_TYPE');
165: fnd_message.raise_error;
166: end if;

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

164: fnd_message.set_name('PAY', 'PAY_50086_ETM_INVALID_BAL_TYPE');
165: fnd_message.raise_error;
166: end if;
167: close csr_balance_type_exists;
168: hr_utility.set_location(' Leaving:'||l_proc, 15);
169: End chk_balance_type_id;
170: -- ----------------------------------------------------------------------------
171: -- |--------------------------< chk_dimension_name >--------------------------|
172: -- ----------------------------------------------------------------------------

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

190: l_api_updating boolean;
191: l_exists varchar2(1);
192: --
193: Begin
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: l_api_updating := pay_sdb_shd.api_updating
196: (p_defined_balance_id => p_defined_balance_id
197: ,p_object_version_number => p_object_version_number
198: );

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

213: --
214: open csr_defined_balance_exists;
215: fetch csr_defined_balance_exists into l_exists;
216: if csr_defined_balance_exists%found then
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: close csr_defined_balance_exists;
219: fnd_message.set_name('PAY', 'PAY_50091_SDB_DEF_BAL_EXISTS');
220: fnd_message.raise_error;
221: end if;

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

220: fnd_message.raise_error;
221: end if;
222: close csr_defined_balance_exists;
223: end if;
224: hr_utility.set_location(' Leaving:'||l_proc, 25);
225: End chk_dimension_name;
226: -- ----------------------------------------------------------------------------
227: -- |---------------------< chk_force_latest_bal_flag >------------------------|
228: -- ----------------------------------------------------------------------------

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

236: l_proc varchar2(72) := g_package||'chk_force_latest_bal_flag';
237: l_api_updating boolean;
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: l_api_updating := pay_sdb_shd.api_updating
242: (p_defined_balance_id => p_defined_balance_id
243: ,p_object_version_number => p_object_version_number
244: );

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

256: ,p_lookup_type => 'YES_NO'
257: ,p_lookup_code => p_force_latest_balance_flag
258: )
259: then
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
262: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
263: fnd_message.set_token('COLUMN', 'FORCE_LATEST_BALANCE_FLAG');
264: fnd_message.raise_error;

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

264: fnd_message.raise_error;
265: end if;
266: end if;
267: end if;
268: hr_utility.set_location(' Leaving:'||l_proc, 20);
269: End chk_force_latest_bal_flag;
270: -- ----------------------------------------------------------------------------
271: -- |---------------------< chk_grossup_allowed_flag >-------------------------|
272: -- ----------------------------------------------------------------------------

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

280: l_proc varchar2(72) := g_package||'chk_grossup_allowed_flag';
281: l_api_updating boolean;
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: l_api_updating := pay_sdb_shd.api_updating
286: (p_defined_balance_id => p_defined_balance_id
287: ,p_object_version_number => p_object_version_number
288: );

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

300: ,p_lookup_type => 'YES_NO'
301: ,p_lookup_code => p_grossup_allowed_flag
302: )
303: then
304: hr_utility.set_location(' Leaving:'||l_proc, 10);
305: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
306: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
307: fnd_message.set_token('COLUMN', 'GROSSUP_ALLOWED_FLAG');
308: fnd_message.raise_error;

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

308: fnd_message.raise_error;
309: end if;
310: end if;
311: end if;
312: hr_utility.set_location(' Leaving:'||l_proc, 20);
313: End chk_grossup_allowed_flag;
314: -- ----------------------------------------------------------------------------
315: -- |------------------------------< chk_delete >------------------------------|
316: -- ----------------------------------------------------------------------------

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

336: l_error exception;
337: l_exists varchar2(1);
338: --
339: Begin
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: --
342: open csr_core_objects;
343: fetch csr_core_objects into l_exists;
344: if csr_core_objects%found then

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

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

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

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

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

355: close csr_bal_attributes;
356: raise l_error;
357: end if;
358: close csr_bal_attributes;
359: hr_utility.set_location(' Leaving:'||l_proc, 15);
360: exception
361: when l_error then
362: fnd_message.set_name('PAY', 'PAY_50092_SDB_INVALID_DELETE');
363: fnd_message.raise_error;

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

361: when l_error then
362: fnd_message.set_name('PAY', 'PAY_50092_SDB_INVALID_DELETE');
363: fnd_message.raise_error;
364: when others then
365: hr_utility.set_location(' Leaving:'||l_proc, 20);
366: raise;
367: End chk_delete;
368: -- ----------------------------------------------------------------------------
369: -- |---------------------------< insert_validate >----------------------------|

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

375: --
376: l_proc varchar2(72) := g_package||'insert_validate';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: --
381: -- Call all supporting business operations
382: --
383: chk_balance_type_id(p_rec.balance_type_id);

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

408: ,p_balance_type_id => p_rec.balance_type_id
409: ,p_defined_balance_id => p_rec.defined_balance_id
410: ,p_object_version_number => p_rec.object_version_number
411: );
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: End insert_validate;
414: --
415: -- ----------------------------------------------------------------------------
416: -- |---------------------------< update_validate >----------------------------|

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

422: --
423: l_proc varchar2(72) := g_package||'update_validate';
424: --
425: Begin
426: hr_utility.set_location('Entering:'||l_proc, 5);
427: --
428: -- Call all supporting business operations
429: --
430: chk_non_updateable_args(p_rec);

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

456: ,p_defined_balance_id => p_rec.defined_balance_id
457: ,p_object_version_number => p_rec.object_version_number
458: );
459: --
460: hr_utility.set_location(' Leaving:'||l_proc, 10);
461: End update_validate;
462: --
463: -- ----------------------------------------------------------------------------
464: -- |---------------------------< delete_validate >----------------------------|

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

467: --
468: l_proc varchar2(72) := g_package||'delete_validate';
469: --
470: Begin
471: hr_utility.set_location('Entering:'||l_proc, 5);
472: --
473: -- Call all supporting business operations
474: --
475: chk_delete(p_rec.defined_balance_id);

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

473: -- Call all supporting business operations
474: --
475: chk_delete(p_rec.defined_balance_id);
476: --
477: hr_utility.set_location(' Leaving:'||l_proc, 10);
478: End delete_validate;
479: --
480: end pay_sdb_bus;