DBA Data[Home] [Help]

APPS.PQH_GSP_PROCESS_LOG dependencies on HR_GENERAL

Line 46: ,p_message_text => NVL(p_message_text,Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','CMPSUC'))

42: ,p_module_cd => P_Module_Cd
43: ,p_txn_id => P_Txn_id
44: ,p_log_context => P_Log_Context
45: ,p_master_process_log_id => P_Master_Process_log_id
46: ,p_message_text => NVL(p_message_text,Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','CMPSUC'))
47: ,p_message_type_cd => P_Message_Type_Cd
48: ,p_information_category => 'GSP'
49: ,p_object_version_number => l_ovn
50: ,P_Information1 => P_Information1

Line 78: Hr_general.Decode_Grade(Grade_Id),

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,
80: P_Effective_Date,
81: 'N',
82: 'CURR'),

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;

Line 167: ,p_message_text => NVL(p_message_text,Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','CMPSUC'))

163: Insert_log(p_module_cd => P_Module_Cd
164: ,p_txn_id => P_Txn_id
165: ,p_log_context => l_Log_Context
166: ,p_master_process_log_id => l_Master_log_id
167: ,p_message_text => NVL(p_message_text,Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','CMPSUC'))
168: ,p_message_type_cd => l_Message_Type
169: ,P_Information1 => L_Grade_Ladder_name
170: ,P_Information2 => L_Grade_name
171: ,P_Information3 => L_Step_Name);