APPS.PER_ECO_SHD dependencies on PER_ELECTION_CONSTITUENCYS

Line 36: If (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK2') Then

32: l_proc varchar2(72) := g_package||'constraint_error';
33: --
34: Begin
35: --
36: If (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK2') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;

Line 41: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK3') Then

37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK3') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;

Line 46: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_PK') Then

42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_PK') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;

Line 110: from per_election_constituencys

106: ,attribute28
107: ,attribute29
108: ,attribute30
109: ,object_version_number
110: from per_election_constituencys
111: where election_constituency_id = p_election_constituency_id;
112: --
113: l_fct_ret boolean;
114: --

Line 211: from per_election_constituencys

207: ,attribute28
208: ,attribute29
209: ,attribute30
210: ,object_version_number
211: from per_election_constituencys
212: where election_constituency_id = p_election_constituency_id
213: for update nowait;
214: --
215: l_proc varchar2(72) := g_package||'lck';

Line 254: fnd_message.set_token('TABLE_NAME', 'per_election_constituencys');

250: -- The object is locked therefore we need to supply a meaningful
251: -- error message.
252: --
253: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
254: fnd_message.set_token('TABLE_NAME', 'per_election_constituencys');
255: fnd_message.raise_error;
256: End lck;
257: --
258: -- ----------------------------------------------------------------------------