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

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

56: l_api_updating boolean;
57: l_disallow varchar2(1);
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: l_api_updating := pay_sba_shd.api_updating
62: (p_balance_attribute_id => p_rec.balance_attribute_id
63: ,p_object_version_number => p_rec.object_version_number
64: );

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

62: (p_balance_attribute_id => p_rec.balance_attribute_id
63: ,p_object_version_number => p_rec.object_version_number
64: );
65: if not l_api_updating then
66: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP', '10');
69: hr_utility.raise_error;
70: end if;

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

63: ,p_object_version_number => p_rec.object_version_number
64: );
65: if not l_api_updating then
66: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP', '10');
69: hr_utility.raise_error;
70: end if;
71: --

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

64: );
65: if not l_api_updating then
66: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP', '10');
69: hr_utility.raise_error;
70: end if;
71: --
72: hr_utility.set_location(l_proc, 15);

Line 69: hr_utility.raise_error;

65: if not l_api_updating then
66: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP', '10');
69: hr_utility.raise_error;
70: end if;
71: --
72: hr_utility.set_location(l_proc, 15);
73: --

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

68: hr_utility.set_message_token('STEP', '10');
69: hr_utility.raise_error;
70: end if;
71: --
72: hr_utility.set_location(l_proc, 15);
73: --
74: -- Check that the update is actually allowed.
75: --
76: open csr_disallow_update;

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

75: --
76: open csr_disallow_update;
77: fetch csr_disallow_update into l_disallow;
78: if csr_disallow_update%found then
79: hr_utility.set_location(l_proc, 20);
80: close csr_disallow_update;
81: fnd_message.set_name('PAY', 'PAY_50202_SBA_CORE_ROW_EXISTS');
82: fnd_message.raise_error;
83: end if;

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

81: fnd_message.set_name('PAY', 'PAY_50202_SBA_CORE_ROW_EXISTS');
82: fnd_message.raise_error;
83: end if;
84: close csr_disallow_update;
85: hr_utility.set_location(' Leaving:'||l_proc, 25);
86: exception
87: when others then
88: hr_utility.set_location('Leaving:'||l_proc, 35);
89: raise;

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

84: close csr_disallow_update;
85: hr_utility.set_location(' Leaving:'||l_proc, 25);
86: exception
87: when others then
88: hr_utility.set_location('Leaving:'||l_proc, 35);
89: raise;
90: End chk_non_updateable_args;
91: -- ----------------------------------------------------------------------------
92: -- |-------------------------< chk_exclusion_rule_id >------------------------|

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

115: l_api_updating boolean;
116: l_valid varchar2(1);
117: --
118: Begin
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: l_api_updating := pay_sba_shd.api_updating
121: (p_balance_attribute_id => p_balance_attribute_id
122: ,p_object_version_number => p_object_version_number
123: );

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

128: if p_exclusion_rule_id is not null then
129: open csr_exclusion_rule_id_valid;
130: fetch csr_exclusion_rule_id_valid into l_valid;
131: if csr_exclusion_rule_id_valid%notfound then
132: hr_utility.set_location('Leaving:'||l_proc, 10);
133: close csr_exclusion_rule_id_valid;
134: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
135: fnd_message.raise_error;
136: end if;

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

136: end if;
137: close csr_exclusion_rule_id_valid;
138: end if;
139: end if;
140: hr_utility.set_location('Leaving:'||l_proc, 5);
141: end chk_exclusion_rule_id;
142: -- ----------------------------------------------------------------------------
143: -- |------------------------< chk_defined_balance_id >-------------------------|
144: -- ----------------------------------------------------------------------------

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

156: l_proc varchar2(72) := g_package||'chk_defined_balance_id';
157: l_exists varchar2(1);
158: --
159: Begin
160: hr_utility.set_location('Entering:'||l_proc, 5);
161: --
162: -- Check that the balance type is not null.
163: --
164: hr_api.mandatory_arg_error

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

171: --
172: open csr_defined_balance_exists;
173: fetch csr_defined_balance_exists into l_exists;
174: if csr_defined_balance_exists%notfound then
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: close csr_defined_balance_exists;
177: fnd_message.set_name('PAY', 'PAY_50203_ETM_INVALID_DEF_BAL');
178: fnd_message.raise_error;
179: end if;

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

177: fnd_message.set_name('PAY', 'PAY_50203_ETM_INVALID_DEF_BAL');
178: fnd_message.raise_error;
179: end if;
180: close csr_defined_balance_exists;
181: hr_utility.set_location(' Leaving:'||l_proc, 15);
182: End chk_defined_balance_id;
183: -- ----------------------------------------------------------------------------
184: -- |--------------------------< chk_attribute_name >--------------------------|
185: -- ----------------------------------------------------------------------------

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

203: l_api_updating boolean;
204: l_exists varchar2(1);
205: --
206: Begin
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: l_api_updating := pay_sba_shd.api_updating
209: (p_balance_attribute_id => p_balance_attribute_id
210: ,p_object_version_number => p_object_version_number
211: );

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

226: --
227: open csr_balance_attribute_exists;
228: fetch csr_balance_attribute_exists into l_exists;
229: if csr_balance_attribute_exists%found then
230: hr_utility.set_location(' Leaving:'||l_proc, 10);
231: close csr_balance_attribute_exists;
232: fnd_message.set_name('PAY', 'PAY_50205_SBA_BAL_ATTR_EXISTS');
233: fnd_message.raise_error;
234: end if;

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

233: fnd_message.raise_error;
234: end if;
235: close csr_balance_attribute_exists;
236: end if;
237: hr_utility.set_location(' Leaving:'||l_proc, 25);
238: End chk_attribute_name;
239: -- ----------------------------------------------------------------------------
240: -- |------------------------------< chk_delete >------------------------------|
241: -- ----------------------------------------------------------------------------

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

255: l_error exception;
256: l_exists varchar2(1);
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: open csr_core_objects;
262: fetch csr_core_objects into l_exists;
263: if csr_core_objects%found then

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

260: --
261: open csr_core_objects;
262: fetch csr_core_objects into l_exists;
263: if csr_core_objects%found then
264: hr_utility.set_location(' Leaving:'||l_proc, 10);
265: close csr_core_objects;
266: raise l_error;
267: end if;
268: close csr_core_objects;

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

265: close csr_core_objects;
266: raise l_error;
267: end if;
268: close csr_core_objects;
269: hr_utility.set_location(' Leaving:'||l_proc, 15);
270: exception
271: when l_error then
272: fnd_message.set_name('PAY', 'PAY_50204_SBA_INVALID_DELETE');
273: fnd_message.raise_error;

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

271: when l_error then
272: fnd_message.set_name('PAY', 'PAY_50204_SBA_INVALID_DELETE');
273: fnd_message.raise_error;
274: when others then
275: hr_utility.set_location(' Leaving:'||l_proc, 20);
276: raise;
277: End chk_delete;
278: --
279: -- ----------------------------------------------------------------------------

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

285: --
286: l_proc varchar2(72) := g_package||'insert_validate';
287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: -- Call all supporting business operations
292: --
293: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS.

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

309: ,p_defined_balance_id => p_rec.defined_balance_id
310: ,p_balance_attribute_id => p_rec.balance_attribute_id
311: ,p_object_version_number => p_rec.object_version_number
312: );
313: hr_utility.set_location(' Leaving:'||l_proc, 10);
314: End insert_validate;
315: --
316: -- ----------------------------------------------------------------------------
317: -- |---------------------------< update_validate >----------------------------|

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

322: --
323: l_proc varchar2(72) := g_package||'update_validate';
324: --
325: Begin
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: -- Call all supporting business operations
329: --
330: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS.

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

348: ,p_defined_balance_id => p_rec.defined_balance_id
349: ,p_balance_attribute_id => p_rec.balance_attribute_id
350: ,p_object_version_number => p_rec.object_version_number
351: );
352: hr_utility.set_location(' Leaving:'||l_proc, 10);
353: End update_validate;
354: --
355: -- ----------------------------------------------------------------------------
356: -- |---------------------------< delete_validate >----------------------------|

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

361: --
362: l_proc varchar2(72) := g_package||'delete_validate';
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: -- Call all supporting business operations
368: --
369: chk_delete

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

368: --
369: chk_delete
370: (p_balance_attribute_id => p_rec.balance_attribute_id
371: );
372: hr_utility.set_location(' Leaving:'||l_proc, 10);
373: End delete_validate;
374: --
375: end pay_sba_bus;