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

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_rlt_shd.api_updating
47: (p_routing_list_id => p_routing_list_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_routing_list_id;
75: --
76: -- ----------------------------------------------------------------------------

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

113: from pqh_routing_lists
114: where nvl(routing_list_name,hr_api.g_varchar2) = nvl(p_routing_list_name,hr_api.g_varchar2);
115: Begin
116: --
117: hr_utility.set_location('Entering:'||l_proc, 5);
118: --
119: l_api_updating := pqh_rlt_shd.api_updating
120: (p_routing_list_id => p_routing_list_id,
121: p_object_version_number => p_object_version_number);

Line 133: hr_utility.set_message(8302,'PQH_ROUTING_LIST_NAME_EXISTS');

129: open c1;
130: fetch c1 into l_dummy;
131: if c1%found then
132: close c1;
133: hr_utility.set_message(8302,'PQH_ROUTING_LIST_NAME_EXISTS');
134: hr_utility.raise_error;
135: -- pqh_rlt_shd.constraint_error('PQH_ROUTING_LISTS_PK');
136: end if;
137: close c1;

Line 134: hr_utility.raise_error;

130: fetch c1 into l_dummy;
131: if c1%found then
132: close c1;
133: hr_utility.set_message(8302,'PQH_ROUTING_LIST_NAME_EXISTS');
134: hr_utility.raise_error;
135: -- pqh_rlt_shd.constraint_error('PQH_ROUTING_LISTS_PK');
136: end if;
137: close c1;
138: --

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

139: end if;
140: --
141: end if;
142: --
143: hr_utility.set_location('Leaving:'||l_proc, 10);
144: --
145: End chk_routing_list_name;
146: --
147: -- ----------------------------------------------------------------------------

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

186: Where transaction_category_id = p_transaction_category_id;
187: --
188: Begin
189: --
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: --
192: for r_txn_cat in c_txn_cats(p_routing_list_id)
193: loop
194: --

Line 202: hr_utility.set_message(8302,'PQH_CANT_DEL_RL_PENDING_TXNS');

198: Open csr_txn_cat_name(p_transaction_category_id => r_txn_cat.transaction_category_id);
199: Fetch csr_txn_cat_name into l_name,l_bus_grp_id;
200: Close csr_txn_cat_name;
201: --
202: hr_utility.set_message(8302,'PQH_CANT_DEL_RL_PENDING_TXNS');
203: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_name);
204: if (l_bus_grp_id is not null) then
205: l_bus_grp_name := hr_general.DECODE_ORGANIZATION(l_bus_grp_id);
206: else

Line 203: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_name);

199: Fetch csr_txn_cat_name into l_name,l_bus_grp_id;
200: Close csr_txn_cat_name;
201: --
202: hr_utility.set_message(8302,'PQH_CANT_DEL_RL_PENDING_TXNS');
203: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_name);
204: if (l_bus_grp_id is not null) then
205: l_bus_grp_name := hr_general.DECODE_ORGANIZATION(l_bus_grp_id);
206: else
207: l_bus_grp_name := hr_general.decode_lookup('PQH_TCT_SCOPE', 'GLOBAL');

Line 210: hr_utility.set_message_token('BUSINESS_GROUP', l_bus_grp_name);

206: else
207: l_bus_grp_name := hr_general.decode_lookup('PQH_TCT_SCOPE', 'GLOBAL');
208: end if;
209: --
210: hr_utility.set_message_token('BUSINESS_GROUP', l_bus_grp_name);
211: --
212: hr_utility.raise_error;
213: --
214: end if;

Line 212: hr_utility.raise_error;

208: end if;
209: --
210: hr_utility.set_message_token('BUSINESS_GROUP', l_bus_grp_name);
211: --
212: hr_utility.raise_error;
213: --
214: end if;
215: --
216: end loop;

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

214: end if;
215: --
216: end loop;
217: --
218: hr_utility.set_location('Leaving:'||l_proc,10);
219: --
220: end chk_for_pending_txns;
221: --
222: --

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

228: --
229: l_proc varchar2(72) := g_package||'insert_validate';
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: -- Call all supporting business operations
235: --
236: chk_routing_list_id

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

243: p_object_version_number => p_rec.object_version_number);
244: --
245: --
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 10);
248: End insert_validate;
249: --
250: -- ----------------------------------------------------------------------------
251: -- |---------------------------< update_validate >----------------------------|

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

254: --
255: l_proc varchar2(72) := g_package||'update_validate';
256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: -- Call all supporting business operations
261: --
262: chk_routing_list_id

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

269: p_routing_list_name => p_rec.routing_list_name,
270: p_object_version_number => p_rec.object_version_number);
271: --
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 10);
274: End update_validate;
275: --
276: -- ----------------------------------------------------------------------------
277: -- |---------------------------< delete_validate >----------------------------|

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

280: --
281: l_proc varchar2(72) := g_package||'delete_validate';
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: -- Call all supporting business operations
287: --
288: chk_for_pending_txns(p_rec.routing_list_id);

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

286: -- Call all supporting business operations
287: --
288: chk_for_pending_txns(p_rec.routing_list_id);
289: --
290: hr_utility.set_location(' Leaving:'||l_proc, 10);
291: End delete_validate;
292: --
293: end pqh_rlt_bus;