APPS.PAY_AMO_SHD dependencies on PAY_AU_MODULES

Line 34: If (p_constraint_name = 'PAY_AU_MODULES_CHK1') Then

30: Begin
31: --
32: l_proc := g_package||'constraint_error';
33: --
34: If (p_constraint_name = 'PAY_AU_MODULES_CHK1') Then
35: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_AU_MODULES_FK1') Then
38: fnd_message.set_name('PAY','HR_AU_INVALID_MODULE_TYPE');

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

33: --
34: If (p_constraint_name = 'PAY_AU_MODULES_CHK1') Then
35: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_AU_MODULES_FK1') Then
38: fnd_message.set_name('PAY','HR_AU_INVALID_MODULE_TYPE');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PAY_AU_MODULES_PK') Then
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_AU_MODULES_FK1') Then
38: fnd_message.set_name('PAY','HR_AU_INVALID_MODULE_TYPE');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PAY_AU_MODULES_PK') Then
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','15');
44: fnd_message.raise_error;

Line 45: ElsIf (p_constraint_name = 'PAY_AU_MODULES_UK1') Then

41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','15');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'PAY_AU_MODULES_UK1') Then
46: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
47: fnd_message.raise_error;
48: Else
49: fnd_message.set_name('PAY', 'PAY_52681_BHT_CHILD_EXISTS');

Line 80: from pay_au_modules

76: ,package_name
77: ,procedure_function_name
78: ,formula_name
79: ,object_version_number
80: from pay_au_modules
81: where module_id = p_module_id;
82: --
83: l_fct_ret boolean;
84: --

Line 156: from pay_au_modules

152: ,package_name
153: ,procedure_function_name
154: ,formula_name
155: ,object_version_number
156: from pay_au_modules
157: where module_id = p_module_id
158: for update nowait;
159: --
160: l_proc varchar2(72);

Line 207: fnd_message.set_token('TABLE_NAME', 'pay_au_modules');

203: -- The object is locked therefore we need to supply a meaningful
204: -- error message.
205: --
206: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
207: fnd_message.set_token('TABLE_NAME', 'pay_au_modules');
208: fnd_message.raise_error;
209: End lck;
210: --
211: -- ----------------------------------------------------------------------------