APPS.PAY_APR_SHD dependencies on PAY_AU_PROCESSES

Line 35: If (p_constraint_name = 'PAY_AU_PROCESSES_PK') Then

31: Begin
32: --
33: l_proc := g_package||'constraint_error';
34:
35: If (p_constraint_name = 'PAY_AU_PROCESSES_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','5');
39: fnd_message.raise_error;

Line 40: ElsIf (p_constraint_name = 'PAY_AU_PROCESSES_UK1') 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','5');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PAY_AU_PROCESSES_UK1') Then
41: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_AU_PROCESSES_UK2') Then
44: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');

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

39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PAY_AU_PROCESSES_UK1') Then
41: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_AU_PROCESSES_UK2') Then
44: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
45: fnd_message.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'PAY_52681_BHT_CHILD_EXISTS');

Line 76: from pay_au_processes

72: ,legislation_code
73: ,description
74: ,accrual_category
75: ,object_version_number
76: from pay_au_processes
77: where process_id = p_process_id;
78: --
79: l_fct_ret boolean;
80: --

Line 150: from pay_au_processes

146: ,legislation_code
147: ,description
148: ,accrual_category
149: ,object_version_number
150: from pay_au_processes
151: where process_id = p_process_id
152: for update nowait;
153: --
154: l_proc varchar2(72);

Line 201: fnd_message.set_token('TABLE_NAME', 'pay_au_processes');

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