APPS.PQH_GSP_PROCESS_LOG dependencies on BEN_BATCH_UTILS

Line 75: Select Decode(Assgt.Grade_ladder_Pgm_id, NULL, NULL, Ben_Batch_Utils.GET_PGM_NAME(Assgt.Grade_ladder_Pgm_id,

71: From PQH_GSP_ELECTABLE_CHOICE_V
72: Where Elig_Per_Elctbl_Chc_id = P_Txn_Id;
73:
74: Cursor Person_Dtls is
75: Select Decode(Assgt.Grade_ladder_Pgm_id, NULL, NULL, Ben_Batch_Utils.GET_PGM_NAME(Assgt.Grade_ladder_Pgm_id,
76: Assgt.BUSINESS_GROUP_ID,
77: P_Effective_Date)),
78: Hr_general.Decode_Grade(Grade_Id),
79: pqh_gsp_utility.Get_Step_Dtls(Assgt.Assignment_id,

Line 141: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','EMPDTLS'));

137: End If;
138:
139: If P_Module_Cd = 'PQH_GSP_DFLT_ENRL' Then
140: Fnd_File.New_Line(WHICH => fnd_file.log);
141: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','EMPDTLS'));
142: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','NAME') || l_Log_Context);
143: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRDLDR') || L_Grade_Ladder_Name);
144:
145: If l_Grade_name is NOT NULL Then

Line 142: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','NAME') || l_Log_Context);

138:
139: If P_Module_Cd = 'PQH_GSP_DFLT_ENRL' Then
140: Fnd_File.New_Line(WHICH => fnd_file.log);
141: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','EMPDTLS'));
142: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','NAME') || l_Log_Context);
143: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRDLDR') || L_Grade_Ladder_Name);
144:
145: If l_Grade_name is NOT NULL Then
146: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRADE') || l_Grade_name);

Line 143: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRDLDR') || L_Grade_Ladder_Name);

139: If P_Module_Cd = 'PQH_GSP_DFLT_ENRL' Then
140: Fnd_File.New_Line(WHICH => fnd_file.log);
141: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','EMPDTLS'));
142: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','NAME') || l_Log_Context);
143: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRDLDR') || L_Grade_Ladder_Name);
144:
145: If l_Grade_name is NOT NULL Then
146: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRADE') || l_Grade_name);
147: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','STEP') || l_Step_name);

Line 146: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRADE') || l_Grade_name);

142: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','NAME') || l_Log_Context);
143: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRDLDR') || L_Grade_Ladder_Name);
144:
145: If l_Grade_name is NOT NULL Then
146: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRADE') || l_Grade_name);
147: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','STEP') || l_Step_name);
148: End If;
149: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','ERRMSG') || p_message_text);
150: Return;

Line 147: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','STEP') || l_Step_name);

143: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRDLDR') || L_Grade_Ladder_Name);
144:
145: If l_Grade_name is NOT NULL Then
146: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRADE') || l_Grade_name);
147: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','STEP') || l_Step_name);
148: End If;
149: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','ERRMSG') || p_message_text);
150: Return;
151: End If;

Line 149: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','ERRMSG') || p_message_text);

145: If l_Grade_name is NOT NULL Then
146: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','GRADE') || l_Grade_name);
147: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','STEP') || l_Step_name);
148: End If;
149: Ben_batch_utils.write(Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','ERRMSG') || p_message_text);
150: Return;
151: End If;
152:
153: Open Master_Log;