APPS.PQH_RER_SHD dependencies on PQH_RATE_ELEMENT_RELATIONS

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK1') Then
22: hr_utility.set_message(8302, 'PQH_RBC_INVALID_CRT_RT_ELMNT');
23: hr_utility.raise_error;
24: /*fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);

Line 28: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK3') Then

24: /*fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;*/
28: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK3') Then
29: hr_utility.set_message(8302, 'PQH_RBC_INVALID_BUSINESS_GRP');
30: hr_utility.raise_error;
31: /* fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
32: fnd_message.set_token('PROCEDURE', l_proc);

Line 35: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_PK') Then

31: /* fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error; */
35: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_PK') Then
36: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;

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

36: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK4') Then
41: hr_utility.set_message(8302, 'PQH_RBC_INVALID_ELEMENT_TYPE');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK5') Then
44: hr_utility.set_message(8302, 'PQH_RBC_INVALID_INPUT_VALUE');

Line 43: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK5') Then

39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK4') Then
41: hr_utility.set_message(8302, 'PQH_RBC_INVALID_ELEMENT_TYPE');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK5') Then
44: hr_utility.set_message(8302, 'PQH_RBC_INVALID_INPUT_VALUE');
45: hr_utility.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 78: from pqh_rate_element_relations

74: ,rel_input_value_id
75: ,business_group_id
76: ,legislation_code
77: ,object_version_number
78: from pqh_rate_element_relations
79: where rate_element_relation_id = p_rate_element_relation_id;
80: --
81: l_fct_ret boolean;
82: --

Line 151: from pqh_rate_element_relations

147: ,rel_input_value_id
148: ,business_group_id
149: ,legislation_code
150: ,object_version_number
151: from pqh_rate_element_relations
152: where rate_element_relation_id = p_rate_element_relation_id
153: for update nowait;
154: --
155: l_proc varchar2(72) := g_package||'lck';

Line 200: fnd_message.set_token('TABLE_NAME', 'pqh_rate_element_relations');

196: -- The object is locked therefore we need to supply a meaningful
197: -- error message.
198: --
199: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
200: fnd_message.set_token('TABLE_NAME', 'pqh_rate_element_relations');
201: fnd_message.raise_error;
202: End lck;
203: --
204: -- ----------------------------------------------------------------------------