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_GSP_POST_PROCESS dependencies on HR_GENERAL

Line 157: and Pgm.Business_Group_id = hr_general.get_Business_group_Id

153: and Pgm.Pgm_Typ_Cd = 'GSP'
154: and P_effective_date
155: Between Pgm.Effective_Start_Date
156: and Pgm.Effective_End_Date
157: and Pgm.Business_Group_id = hr_general.get_Business_group_Id
158: and Plan.Mapping_Table_name = 'PER_GRADES'
159: and Plan.Mapping_Table_Pk_id = l_grade_Id
160: and P_Effective_Date
161: Between Plan.Effective_Start_Date

Line 370: (P_Message_Type_Cd => Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','ERR')

366: ,P_Level => 2
367: ,P_Log_Context => l_person_Name);
368:
369: Pqh_Process_Batch_log.Insert_log
370: (P_Message_Type_Cd => Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','ERR')
371: ,P_Message_text => Nvl(fnd_message.get,Sqlerrm));
372:
373: End if;
374:

Line 510: and Paa.Business_group_id = hr_General.get_Business_group_id

506: Select Paa.Assignment_Id, Paa.Grade_ladder_Pgm_Id, Paa.Grade_Id, Paa.Person_Id,
507: paa.soft_coding_keyflex_id,paa.people_group_id,paa.special_ceiling_step_id,paa.object_version_number
508: from Per_All_Assignments_F Paa
509: Where L_Effective_Date Between paa.Effective_Start_Date and Paa.Effective_End_Date
510: and Paa.Business_group_id = hr_General.get_Business_group_id
511: and Paa.Person_id = Nvl(P_Person_Id, Paa.Person_Id)
512: and paa.assignment_type ='E'
513: and paa.primary_flag ='Y'
514: and Paa.Grade_ladder_Pgm_Id is null

Line 555: l_business_group_id := hr_General.get_Business_group_id;

551:
552: g_debug := hr_utility.debug_enabled;
553:
554: L_Effective_Date := Fnd_Date.CANONICAL_TO_DATE(P_Effective_Date);
555: l_business_group_id := hr_General.get_Business_group_id;
556:
557: hr_utility.set_location(' Entering ', 10);
558: hr_utility.set_location(' L_Effective_Date'||L_Effective_Date, 20);
559:

Line 565: ,P_Txn_Name => Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','BENRL') || l_Concurrent_Req_Id

561: L_Concurrent_Req_Id := fnd_global.conc_request_id;
562:
563: Pqh_Gsp_process_Log.Start_log
564: (P_Txn_ID => l_Concurrent_Req_Id
565: ,P_Txn_Name => Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','BENRL') || l_Concurrent_Req_Id
566: ,P_Module_Cd => 'PQH_GSP_BATCH_ENRL');
567:
568: For Asgt_Rec in Asgt_Dtls
569: Loop

Line 690: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_BATCH_ENRL'));

686: End Loop;
687:
688: If L_Error_Exists = 'N' Then
689: fnd_message.set_name('PQH','PQH_GSP_LOG_SUC');
690: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_BATCH_ENRL'));
691: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
692: Else
693: fnd_message.set_name('PQH','PQH_GSP_LOG_ERR');
694: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_BATCH_ENRL'));

Line 694: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_BATCH_ENRL'));

690: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_BATCH_ENRL'));
691: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
692: Else
693: fnd_message.set_name('PQH','PQH_GSP_LOG_ERR');
694: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_BATCH_ENRL'));
695: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
696: l_conc_status := fnd_concurrent.set_completion_status(status => 'ERROR'
697: ,message=>SQLERRM);
698: hr_utility.set_location('Some Error:'|| SQLERRM,120);

Line 908: and Business_Group_id = Hr_general.get_business_group_id;

904: and Pgm_Typ_Cd = 'GSP'
905: and P_Effective_Date
906: Between Effective_Start_Date
907: and Effective_End_Date
908: and Business_Group_id = Hr_general.get_business_group_id;
909:
910: L_person_Id Per_All_People_F.Person_Id%TYPE;
911: l_Ler_id Ben_ler_F.Ler_Id%TYPE;
912: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;

Line 2537: and Ler.Business_group_id = Hr_general.get_Business_Group_id

2533: where Ler.typ_Cd = 'GSP'
2534: and L_Effective_Date
2535: Between Ler.Effective_Start_Date
2536: and Ler.Effective_End_Date
2537: and Ler.Business_group_id = Hr_general.get_Business_Group_id
2538: and Pil.Ler_Id = Ler.Ler_id
2539: and Pil.PER_IN_LER_STAT_CD = 'STRTD'
2540: and Elct.Per_In_Ler_id = Pil.Per_in_Ler_id
2541: and Elct.DFLT_FLAG = 'Y'

Line 2563: ,P_Txn_Name => Hr_general.Decode_lookup('PQH_GSP_GEN_PROMPTS','AUI') || L_Concurrent_Req_Id

2559: L_Concurrent_Req_Id := fnd_global.conc_request_id;
2560:
2561: Pqh_Gsp_process_Log.Start_log
2562: (P_Txn_ID => L_Concurrent_Req_Id
2563: ,P_Txn_Name => Hr_general.Decode_lookup('PQH_GSP_GEN_PROMPTS','AUI') || L_Concurrent_Req_Id
2564: ,P_Module_Cd => 'PQH_GSP_APPROVAL_UI');
2565:
2566: For Elctbl_Rec in Elctbl
2567: Loop

Line 2670: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_APPROVAL_UI'));

2666: End Loop;
2667:
2668: If l_Error_Exists = 'N' Then
2669: fnd_message.set_name('PQH','PQH_GSP_LOG_SUC');
2670: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_APPROVAL_UI'));
2671: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
2672: Else
2673: fnd_message.set_name('PQH','PQH_GSP_LOG_ERR');
2674: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_APPROVAL_UI'));

Line 2674: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_APPROVAL_UI'));

2670: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_APPROVAL_UI'));
2671: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
2672: Else
2673: fnd_message.set_name('PQH','PQH_GSP_LOG_ERR');
2674: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_APPROVAL_UI'));
2675: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
2676: l_conc_status := fnd_concurrent.set_completion_status(status => 'ERROR'
2677: ,message=>SQLERRM);
2678: End If;

Line 3053: and Business_Group_id = Hr_general.get_business_group_id;

3049: and Pgm_Typ_Cd = 'GSP'
3050: and P_Effective_Date
3051: Between Effective_Start_Date
3052: and Effective_End_Date
3053: and Business_Group_id = Hr_general.get_business_group_id;
3054:
3055: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
3056: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
3057: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;