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 411: (P_Message_Type_Cd => Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','ERR')

407: ,P_Level => 2
408: ,P_Log_Context => l_person_Name);
409:
410: Pqh_Process_Batch_log.Insert_log
411: (P_Message_Type_Cd => Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','ERR')
412: ,P_Message_text => Nvl(fnd_message.get,Sqlerrm));
413:
414: End if;
415:

Line 551: and Paa.Business_group_id = hr_General.get_Business_group_id

547: Select Paa.Assignment_Id, Paa.Grade_ladder_Pgm_Id, Paa.Grade_Id, Paa.Person_Id,
548: paa.soft_coding_keyflex_id,paa.people_group_id,paa.special_ceiling_step_id,paa.object_version_number
549: from Per_All_Assignments_F Paa
550: Where L_Effective_Date Between paa.Effective_Start_Date and Paa.Effective_End_Date
551: and Paa.Business_group_id = hr_General.get_Business_group_id
552: and Paa.Person_id = Nvl(P_Person_Id, Paa.Person_Id)
553: and paa.assignment_type ='E'
554: and paa.primary_flag ='Y'
555: and Paa.Grade_ladder_Pgm_Id is null

Line 596: l_business_group_id := hr_General.get_Business_group_id;

592:
593: g_debug := hr_utility.debug_enabled;
594:
595: L_Effective_Date := Fnd_Date.CANONICAL_TO_DATE(P_Effective_Date);
596: l_business_group_id := hr_General.get_Business_group_id;
597:
598: hr_utility.set_location(' Entering ', 10);
599: hr_utility.set_location(' L_Effective_Date'||L_Effective_Date, 20);
600:

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

602: L_Concurrent_Req_Id := fnd_global.conc_request_id;
603:
604: Pqh_Gsp_process_Log.Start_log
605: (P_Txn_ID => l_Concurrent_Req_Id
606: ,P_Txn_Name => Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','BENRL') || l_Concurrent_Req_Id
607: ,P_Module_Cd => 'PQH_GSP_BATCH_ENRL');
608:
609: For Asgt_Rec in Asgt_Dtls
610: Loop

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

727: End Loop;
728:
729: If L_Error_Exists = 'N' Then
730: fnd_message.set_name('PQH','PQH_GSP_LOG_SUC');
731: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_BATCH_ENRL'));
732: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
733: Else
734: fnd_message.set_name('PQH','PQH_GSP_LOG_ERR');
735: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_BATCH_ENRL'));

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

731: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_BATCH_ENRL'));
732: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
733: Else
734: fnd_message.set_name('PQH','PQH_GSP_LOG_ERR');
735: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_BATCH_ENRL'));
736: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
737: l_conc_status := fnd_concurrent.set_completion_status(status => 'ERROR'
738: ,message=>SQLERRM);
739: hr_utility.set_location('Some Error:'|| SQLERRM,120);

Line 960: and Business_Group_id = Hr_general.get_business_group_id;

956: and Pgm_Typ_Cd = 'GSP'
957: and P_Effective_Date
958: Between Effective_Start_Date
959: and Effective_End_Date
960: and Business_Group_id = Hr_general.get_business_group_id;
961:
962: -- Bug 13532919
963: -- Bug 16285614
964: cursor csr_step_val

Line 2697: and Ler.Business_group_id = Hr_general.get_Business_Group_id

2693: where Ler.typ_Cd = 'GSP'
2694: and L_Effective_Date
2695: Between Ler.Effective_Start_Date
2696: and Ler.Effective_End_Date
2697: and Ler.Business_group_id = Hr_general.get_Business_Group_id
2698: and Pil.Ler_Id = Ler.Ler_id
2699: and Pil.PER_IN_LER_STAT_CD = 'STRTD'
2700: and Elct.Per_In_Ler_id = Pil.Per_in_Ler_id
2701: and Elct.DFLT_FLAG = 'Y'

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

2719: L_Concurrent_Req_Id := fnd_global.conc_request_id;
2720:
2721: Pqh_Gsp_process_Log.Start_log
2722: (P_Txn_ID => L_Concurrent_Req_Id
2723: ,P_Txn_Name => Hr_general.Decode_lookup('PQH_GSP_GEN_PROMPTS','AUI') || L_Concurrent_Req_Id
2724: ,P_Module_Cd => 'PQH_GSP_APPROVAL_UI');
2725:
2726: For Elctbl_Rec in Elctbl
2727: Loop

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

2826: End Loop;
2827:
2828: If l_Error_Exists = 'N' Then
2829: fnd_message.set_name('PQH','PQH_GSP_LOG_SUC');
2830: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_APPROVAL_UI'));
2831: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
2832: Else
2833: fnd_message.set_name('PQH','PQH_GSP_LOG_ERR');
2834: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_APPROVAL_UI'));

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

2830: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_APPROVAL_UI'));
2831: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
2832: Else
2833: fnd_message.set_name('PQH','PQH_GSP_LOG_ERR');
2834: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_APPROVAL_UI'));
2835: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
2836: l_conc_status := fnd_concurrent.set_completion_status(status => 'ERROR'
2837: ,message=>SQLERRM);
2838: End If;

Line 3213: and Business_Group_id = Hr_general.get_business_group_id;

3209: and Pgm_Typ_Cd = 'GSP'
3210: and P_Effective_Date
3211: Between Effective_Start_Date
3212: and Effective_End_Date
3213: and Business_Group_id = Hr_general.get_business_group_id;
3214:
3215: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
3216: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
3217: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;