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

Line 20: hr_utility.set_location('Entering: '||l_proc,10);

16: l_dynamic varchar2(2000):= null;
17: l_proc varchar2(72) := g_package||'get_query';
18: begin
19:
20: hr_utility.set_location('Entering: '||l_proc,10);
21:
22: l_query :=null;
23:
24:

Line 159: hr_utility.set_location('Query is: '||l_query,20);

155:
156: if l_dynamic is not null then
157: l_query := l_static || l_dynamic || ' = ' ||p_pk_id || p_delete_clause ;
158: end if;
159: hr_utility.set_location('Query is: '||l_query,20);
160: hr_utility.set_location('Leaving: '||l_proc,30);
161: end get_query;
162:
163: procedure delete_dpnts(p_table_alias in varchar2

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

156: if l_dynamic is not null then
157: l_query := l_static || l_dynamic || ' = ' ||p_pk_id || p_delete_clause ;
158: end if;
159: hr_utility.set_location('Query is: '||l_query,20);
160: hr_utility.set_location('Leaving: '||l_proc,30);
161: end get_query;
162:
163: procedure delete_dpnts(p_table_alias in varchar2
164: , p_copy_entity_txn_id in Number

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

171: l_dpnt_rows l_template%rowtype;
172: l_proc varchar2(72) := g_package||'delete_dpnts';
173: l_delete_clause varchar2(100) := ' AND( DML_OPERATION <> ''DELETE'' OR pd_parent_entity_result_id IS NULL )';
174: begin
175: hr_utility.set_location('Entering: '||l_proc,10);
176:
177: get_query(p_table_alias,p_copy_entity_txn_id,p_pk_id,l_delete_clause,l_query);
178: if(l_query is not null) then
179: open l_dpnts for l_query;

Line 186: hr_utility.set_location('Deleting Entity :'|| l_dpnt_rows.table_alias ||' copy_entity_result_id :'||to_char(l_dpnt_rows.copy_entity_result_id) ,30);

182: exit when l_dpnts%notfound;
183: -- here is a recursive call to the same procedure
184: delete_dpnts(l_dpnt_rows.table_alias,p_copy_entity_txn_id,l_dpnt_rows.pk_id,p_top_level_result_id);
185: -- delete the parent row after deleting the child
186: hr_utility.set_location('Deleting Entity :'|| l_dpnt_rows.table_alias ||' copy_entity_result_id :'||to_char(l_dpnt_rows.copy_entity_result_id) ,30);
187: IF(g_top_level_entity = g_EXISTING) THEN
188: IF(l_dpnt_rows.dml_operation = 'INSERT') THEN
189: delete from ben_copy_entity_results where copy_entity_result_id = l_dpnt_rows.copy_entity_result_id ;
190: ELSE

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

200: END IF;
201: end loop;
202: close l_dpnts ;
203: end if;
204: hr_utility.set_location('Leaving: '||l_proc,30);
205: end delete_dpnts;
206:
207: procedure write_route_and_hierarchy(p_copy_entity_txn_id in number)
208: is

Line 212: hr_utility.set_location('Entering: '||l_proc,10);

208: is
209: --pragma AUTONOMOUS_TRANSACTION;
210: l_proc varchar2(72) := g_package||'write_route_and_hierarchy';
211: begin
212: hr_utility.set_location('Entering: '||l_proc,10);
213: UPDATE ben_copy_entity_results cer
214: set (table_route_id, order_in_hierarchy) =
215: (select table_route_id,display_order
216: from pqh_table_route

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

221: or order_in_hierarchy is null);
222:
223: -- commit the autonomous transaction
224: --commit;
225: hr_utility.set_location('Leaving: '||l_proc,20);
226: exception
227: when others then
228: rollback;
229: raise;

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

236: is
237: --pragma AUTONOMOUS_TRANSACTION;
238: l_proc varchar2(72) := g_package||'write_route_and_hierarchy';
239: begin
240: hr_utility.set_location('Entering: '||l_proc,10);
241: UPDATE ben_copy_entity_results cer
242: set (table_route_id, order_in_hierarchy) =
243: (select table_route_id,display_order
244: from pqh_table_route

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

251: or order_in_hierarchy is null);
252:
253: -- commit the autonomous transaction
254: --commit;
255: hr_utility.set_location('Leaving: '||l_proc,20);
256: exception
257: when others then
258: rollback;
259: raise;

Line 272: hr_utility.set_location('Entering: '||l_proc,10);

268: is
269: l_proc varchar2(72) := g_package||'update_result_rows';
270: l_effectve_date date;
271: begin
272: hr_utility.set_location('Entering: '||l_proc,10);
273:
274: select src_effective_date into l_effectve_date
275: from pqh_copy_entity_txns
276: where copy_entity_txn_id = p_copy_entity_txn_id;

Line 278: hr_utility.set_location('l_effectve_date: '||l_effectve_date,10);

274: select src_effective_date into l_effectve_date
275: from pqh_copy_entity_txns
276: where copy_entity_txn_id = p_copy_entity_txn_id;
277:
278: hr_utility.set_location('l_effectve_date: '||l_effectve_date,10);
279:
280: UPDATE ben_copy_entity_results cer
281: set number_of_copies = 0
282: where cer.copy_entity_txn_id = p_copy_entity_txn_id

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

281: set number_of_copies = 0
282: where cer.copy_entity_txn_id = p_copy_entity_txn_id
283: and l_effectve_date not between information2 and information3;
284:
285: hr_utility.set_location('Leaving: '||l_proc,20);
286: exception
287: when others then
288: rollback;
289: raise;

Line 339: hr_utility.set_location('Entering: '||l_proc,10);

335: select information1 from ben_copy_entity_results where
336: copy_entity_result_id = p_copy_entity_result_id;
337: begin
338:
339: hr_utility.set_location('Entering: '||l_proc,10);
340: fnd_msg_pub.initialize;
341: g_top_level_entity := g_NEW;
342: open getId;
343: fetch getId into l_pk_id;

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

348: -- delete from ben_copy_entity_results where copy_entity_result_id = p_copy_entity_result_id ;
349: end if;
350: close getId;
351:
352: hr_utility.set_location('Leaving: '||l_proc,20);
353:
354: end delete_Entity ;
355: -- This procedure does not delete the passed entity and only deletes the dpnts
356: procedure delete_entity

Line 371: hr_utility.set_location('Entering: '||l_proc,10);

367: select information1 from ben_copy_entity_results where
368: copy_entity_result_id = p_copy_entity_result_id;
369: begin
370:
371: hr_utility.set_location('Entering: '||l_proc,10);
372: fnd_msg_pub.initialize;
373: g_top_level_entity := p_top_level_entity;
374: open getId;
375: fetch getId into l_pk_id;

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

389: ,p_parent_entity_result_id =>p_copy_entity_result_id
390: ,p_delete_failed => p_delete_failed
391: );
392: END IF;
393: hr_utility.set_location('Leaving: '||l_proc,20);
394: end delete_Entity ;
395:
396:
397: -- This is moved from plan copy files as we need to call delete also

Line 417: hr_utility.set_location('Entering: '||l_proc,10);

413: l_proc varchar2(72) := g_package||'pdw_submit_copy_request';
414: l_encoded_message varchar2(2000);
415: l_effective_date date;
416: begin
417: hr_utility.set_location('Entering: '||l_proc,10);
418: savepoint SUBMIT_RQST;
419:
420: /****** The commented portion is moved to bepdcprc.pkb within concurrent request *****/
421: /*-- write the table_route_id

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

475: -- p_validate is true
476: if p_process_validate = 1 then
477: raise hr_API.validate_enabled;
478: end if;
479: hr_utility.set_location('Leaving: '||l_proc,20);
480: exception
481: when hr_API.validate_enabled then
482: ROLLBACK TO SUBMIT_REQUEST;
483: when app_exception.application_exception then

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

490: if p_validate = 1 then -- p_validate is true
491: raise hr_API.validate_enabled;
492: end if;
493: --
494: hr_utility.set_location(' Leaving:'||l_proc, 70);
495: --
496: exception
497: --
498: when hr_API.validate_enabled then

Line 510: hr_utility.set_location(' Leaving:'||l_proc, 80);

506: -- (Any key or derived arguments must be set to null
507: -- when validation only mode is being used.)
508: --
509: p_request_id := null;
510: hr_utility.set_location(' Leaving:'||l_proc, 80);
511: --
512: when app_exception.application_exception then
513:
514: fnd_msg_pub.add;