DBA Data[Home] [Help]

APPS.PQH_DE_GRADE_COMPUTE dependencies on HR_UTILITY

Line 82: Hr_utility.Set_message(8302,sqlerrm);

78: End Loop;
79: End Loop;
80: Exception
81: When Others Then
82: Hr_utility.Set_message(8302,sqlerrm);
83: Hr_utility.raise_Error;
84: End;
85:
86: Procedure PQH_DE_CS_COMPUTE

Line 83: Hr_utility.raise_Error;

79: End Loop;
80: Exception
81: When Others Then
82: Hr_utility.Set_message(8302,sqlerrm);
83: Hr_utility.raise_Error;
84: End;
85:
86: Procedure PQH_DE_CS_COMPUTE
87: (P_GVNumber In Number,

Line 105: Hr_utility.Set_message(8302,'PQH_DE_GRADE');

101: Open Derive_Grad;
102: Fetch Derive_Grad into P_CS_Grade;
103: If Derive_Grad%NOTFOUND Then
104: Close Derive_Grad;
105: Hr_utility.Set_message(8302,'PQH_DE_GRADE');
106: Hr_utility.raise_Error;
107: End If;
108: If Derive_Grad%ROWCOUNT > 1 then
109: Close Derive_Grad;

Line 106: Hr_utility.raise_Error;

102: Fetch Derive_Grad into P_CS_Grade;
103: If Derive_Grad%NOTFOUND Then
104: Close Derive_Grad;
105: Hr_utility.Set_message(8302,'PQH_DE_GRADE');
106: Hr_utility.raise_Error;
107: End If;
108: If Derive_Grad%ROWCOUNT > 1 then
109: Close Derive_Grad;
110: Hr_utility.Set_message(8302,'PQH_DE_GRADE');

Line 110: Hr_utility.Set_message(8302,'PQH_DE_GRADE');

106: Hr_utility.raise_Error;
107: End If;
108: If Derive_Grad%ROWCOUNT > 1 then
109: Close Derive_Grad;
110: Hr_utility.Set_message(8302,'PQH_DE_GRADE');
111: Hr_utility.raise_Error;
112: End If;
113: p_cs_Grdnam := hr_general.Decode_grade(P_CS_Grade);
114: Close Derive_Grad;

Line 111: Hr_utility.raise_Error;

107: End If;
108: If Derive_Grad%ROWCOUNT > 1 then
109: Close Derive_Grad;
110: Hr_utility.Set_message(8302,'PQH_DE_GRADE');
111: Hr_utility.raise_Error;
112: End If;
113: p_cs_Grdnam := hr_general.Decode_grade(P_CS_Grade);
114: Close Derive_Grad;
115: Exception