APPS.PQH_CRE_SHD dependencies on PQH_CRITERIA_RATE_ELEMENTS

Line 21: If (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK3') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK3') Then
22: hr_utility.set_message(8302, 'PQH_RBC_INVALID_BUSINESS_GRP');
23: hr_utility.raise_error;
24: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_PK') Then
25: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 24: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_PK') Then

20: --
21: If (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK3') Then
22: hr_utility.set_message(8302, 'PQH_RBC_INVALID_BUSINESS_GRP');
23: hr_utility.raise_error;
24: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_PK') Then
25: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
26: fnd_message.set_token('PROCEDURE', l_proc);
27: fnd_message.set_token('STEP','10');
28: fnd_message.raise_error;

Line 29: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK1') Then

25: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
26: fnd_message.set_token('PROCEDURE', l_proc);
27: fnd_message.set_token('STEP','10');
28: fnd_message.raise_error;
29: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK1') Then
30: hr_utility.set_message(8302, 'PQH_RBC_CRT_RT_DF_ID_NOT_EXIST');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK3') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 32: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK3') Then

28: fnd_message.raise_error;
29: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK1') Then
30: hr_utility.set_message(8302, 'PQH_RBC_CRT_RT_DF_ID_NOT_EXIST');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK3') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 37: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK4') Then

33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK4') Then
38: hr_utility.set_message(8302, 'PQH_RBC_INVALID_ELEMENT_TYPE');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK5') Then
41: hr_utility.set_message(8302, 'PQH_RBC_INVALID_INPUT_VALUE');

Line 40: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK5') Then

36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK4') Then
38: hr_utility.set_message(8302, 'PQH_RBC_INVALID_ELEMENT_TYPE');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PQH_CRITERIA_RATE_ELEMENTS_FK5') Then
41: hr_utility.set_message(8302, 'PQH_RBC_INVALID_INPUT_VALUE');
42: hr_utility.raise_error;
43: Else
44: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 73: from pqh_criteria_rate_elements

69: ,input_value_id
70: ,business_group_id
71: ,legislation_code
72: ,object_version_number
73: from pqh_criteria_rate_elements
74: where criteria_rate_element_id = p_criteria_rate_element_id;
75: --
76: l_fct_ret boolean;
77: --

Line 145: from pqh_criteria_rate_elements

141: ,input_value_id
142: ,business_group_id
143: ,legislation_code
144: ,object_version_number
145: from pqh_criteria_rate_elements
146: where criteria_rate_element_id = p_criteria_rate_element_id
147: for update nowait;
148: --
149: l_proc varchar2(72) := g_package||'lck';

Line 194: fnd_message.set_token('TABLE_NAME', 'pqh_criteria_rate_elements');

190: -- The object is locked therefore we need to supply a meaningful
191: -- error message.
192: --
193: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
194: fnd_message.set_token('TABLE_NAME', 'pqh_criteria_rate_elements');
195: fnd_message.raise_error;
196: End lck;
197: --
198: -- ----------------------------------------------------------------------------