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

Line 165: hr_utility.set_location('Calling create_ler_per_info_cs:'|| l_proc, 10);

161: l_exists := TRUE;
162: exit;
163: end loop;
164: IF NOT l_exists THEN
165: hr_utility.set_location('Calling create_ler_per_info_cs:'|| l_proc, 10);
166:
167: -- To associate the Person Type Change with the LER
168: ben_Ler_Per_Info_Cs_Ler_api.create_Ler_Per_Info_Cs_Ler
169: (p_ler_per_info_cs_ler_id => l_per_info_cs_id

Line 232: hr_utility.set_location('Calling create_ler_per_info_cs:'|| l_proc, 10);

228: exit;
229: end loop;
230: IF NOT l_exists THEN
231:
232: hr_utility.set_location('Calling create_ler_per_info_cs:'|| l_proc, 10);
233:
234: -- To associate the Person Type Change with the LER
235: ben_Ler_Per_Info_Cs_Ler_api.create_Ler_Per_Info_Cs_Ler
236: (p_ler_per_info_cs_ler_id => l_per_info_cs_id

Line 298: hr_utility.set_location('Calling create_ler_per_info_cs:'|| l_proc, 10);

294: exit;
295: end loop;
296: IF NOT l_exists THEN
297:
298: hr_utility.set_location('Calling create_ler_per_info_cs:'|| l_proc, 10);
299:
300: -- To associate the Person Type Change with the LER
301: ben_Ler_Per_Info_Cs_Ler_api.create_Ler_Per_Info_Cs_Ler
302: (p_ler_per_info_cs_ler_id => l_per_info_cs_id

Line 365: hr_utility.set_location('Calling create_ler_per_info_cs:'|| l_proc, 10);

361: exit;
362: end loop;
363: IF NOT l_exists THEN
364:
365: hr_utility.set_location('Calling create_ler_per_info_cs:'|| l_proc, 10);
366:
367: -- To associate the Person Type Change with the LER
368: ben_Ler_Per_Info_Cs_Ler_api.create_Ler_Per_Info_Cs_Ler
369: (p_ler_per_info_cs_ler_id => l_per_info_cs_id

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

377: );
378: END IF;
379: END IF;
380:
381: hr_utility.set_location('Leaving: '|| g_package||l_proc, 50);
382: End create_person_type_usages;
383:
384: Procedure create_collapse_rule (p_target_business_group_id in Number) is
385: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%type;

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

415: select ler_id,effective_start_date from ben_ler_f
416: where name = l_le_name
417: and business_group_id = p_target_business_group_id;
418: begin
419: hr_utility.set_location('Entering: '|| g_package||l_proc, 5);
420: -- Create the Sub Life Events
421: create_sub_life_events(p_target_business_group_id);
422: -- Create person type changes and Attach person type changes
423: create_person_type_usages(p_target_business_group_id);

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

517: and business_group_id = p_target_business_group_id;
518: --
519: Begin
520:
521: hr_utility.set_location('Entering:'|| g_package||l_proc, 5);
522:
523: Open get_txn_category_id;
524: Fetch get_txn_category_id into p_transaction_category_id;
525: hr_utility.trace('Transaction Category Id :'|| p_transaction_category_id);

Line 525: hr_utility.trace('Transaction Category Id :'|| p_transaction_category_id);

521: hr_utility.set_location('Entering:'|| g_package||l_proc, 5);
522:
523: Open get_txn_category_id;
524: Fetch get_txn_category_id into p_transaction_category_id;
525: hr_utility.trace('Transaction Category Id :'|| p_transaction_category_id);
526: hr_utility.set_location('Opening cursor get_copy_txn_id '||l_proc, 10);
527: --dbms_output.put_line('txn category id '||p_transaction_category_id);
528:
529: Open get_copy_txn_id;

Line 526: hr_utility.set_location('Opening cursor get_copy_txn_id '||l_proc, 10);

522:
523: Open get_txn_category_id;
524: Fetch get_txn_category_id into p_transaction_category_id;
525: hr_utility.trace('Transaction Category Id :'|| p_transaction_category_id);
526: hr_utility.set_location('Opening cursor get_copy_txn_id '||l_proc, 10);
527: --dbms_output.put_line('txn category id '||p_transaction_category_id);
528:
529: Open get_copy_txn_id;
530: fetch get_copy_txn_id into p_copy_entity_txn_id;

Line 534: hr_utility.trace('Copy entity Txn. Id :'|| p_copy_entity_txn_id);

530: fetch get_copy_txn_id into p_copy_entity_txn_id;
531: If get_copy_txn_id%notfound then
532: Raise Nothing_to_do;
533: End If;
534: hr_utility.trace('Copy entity Txn. Id :'|| p_copy_entity_txn_id);
535: --dbms_output.put_line('copy_entity_txn_id :'||p_copy_entity_txn_id );
536:
537: ----------------------------
538: /* This update is introduced to open the lookup type delivererd by Benefits team */

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

582: End If;
583: If get_copy_txn_id%ISOPEN then
584: CLOSE get_copy_txn_id;
585: End If;
586: hr_utility.set_location('Leaving :'|| g_package||l_proc, 50);
587:
588: Exception
589: When Nothing_to_do Then
590: If get_txn_category_id%ISOPEN then

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

600: End If;
601: If get_copy_txn_id%ISOPEN then
602: CLOSE get_copy_txn_id;
603: End If;
604: hr_utility.set_location('Leaving :'|| g_package||l_proc, 70);
605: Raise;
606: End create_program_and_plans;
607:
608:

Line 626: hr_utility.set_location('entering :'|| g_package||l_proc, 10);

622: Nothing_To_Do Exception;
623:
624:
625: Begin
626: hr_utility.set_location('entering :'|| g_package||l_proc, 10);
627: hr_utility.trace('Business Group Id ' ||p_target_business_group_id);
628: Open check_pgm_exists;
629: Fetch check_pgm_exists into p_exists;
630: If check_pgm_exists%NOTFOUND Then

Line 627: hr_utility.trace('Business Group Id ' ||p_target_business_group_id);

623:
624:
625: Begin
626: hr_utility.set_location('entering :'|| g_package||l_proc, 10);
627: hr_utility.trace('Business Group Id ' ||p_target_business_group_id);
628: Open check_pgm_exists;
629: Fetch check_pgm_exists into p_exists;
630: If check_pgm_exists%NOTFOUND Then
631: p_exists := 'N';

Line 640: hr_utility.trace('After create_program_and_plans....');

636:
637: Savepoint create_plan_design;
638: --dbms_output.put_line('now starting plan design ' ||p_target_business_group_id);
639: create_program_and_plans(p_target_business_group_id);
640: hr_utility.trace('After create_program_and_plans....');
641: create_collapse_rule(p_target_business_group_id);
642: --commit;
643: If check_pgm_exists%ISOPEN then
644: CLOSE check_pgm_exists;

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

642: --commit;
643: If check_pgm_exists%ISOPEN then
644: CLOSE check_pgm_exists;
645: End If;
646: hr_utility.set_location('Leaving :'|| g_package||l_proc, 50);
647: Exception
648: When Nothing_to_do Then
649: If check_pgm_exists%ISOPEN then
650: CLOSE check_pgm_exists;

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

653: When others then
654: If check_pgm_exists%ISOPEN then
655: CLOSE check_pgm_exists;
656: End If;
657: hr_utility.set_location('Leaving :'|| g_package||l_proc, 60);
658: hr_utility.trace('Error ' ||sqlerrm(sqlcode));
659: l_err_msg := substr(p_target_business_group_id||':'||nvl(fnd_message.get,sqlerrm),1,1999) ;
660: rollback to create_plan_design;
661: ghr_wgi_pkg.create_ghr_errorlog

Line 658: hr_utility.trace('Error ' ||sqlerrm(sqlcode));

654: If check_pgm_exists%ISOPEN then
655: CLOSE check_pgm_exists;
656: End If;
657: hr_utility.set_location('Leaving :'|| g_package||l_proc, 60);
658: hr_utility.trace('Error ' ||sqlerrm(sqlcode));
659: l_err_msg := substr(p_target_business_group_id||':'||nvl(fnd_message.get,sqlerrm),1,1999) ;
660: rollback to create_plan_design;
661: ghr_wgi_pkg.create_ghr_errorlog
662: (p_program_name => l_proc,

Line 683: hr_utility.set_location('entering :'|| g_package||l_proc, 10);

679: p_errbuf varchar(2000);
680: p_retcode number;
681:
682: Begin
683: hr_utility.set_location('entering :'|| g_package||l_proc, 10);
684: For i in c_get_business_group_id Loop
685: Begin
686: hr_utility.trace('Business Group Id ' ||i.business_group_id);
687: ghr_fehb_plan_design.populate_fehb_plan_design(

Line 686: hr_utility.trace('Business Group Id ' ||i.business_group_id);

682: Begin
683: hr_utility.set_location('entering :'|| g_package||l_proc, 10);
684: For i in c_get_business_group_id Loop
685: Begin
686: hr_utility.trace('Business Group Id ' ||i.business_group_id);
687: ghr_fehb_plan_design.populate_fehb_plan_design(
688: p_errbuf , p_retcode ,
689: i.business_group_id);
690: End;

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

688: p_errbuf , p_retcode ,
689: i.business_group_id);
690: End;
691: End Loop;
692: hr_utility.set_location('Leaving :'|| l_proc, 50);
693: End populate_fehb_pd_all_bgs;
694: */
695:
696: