APPS.PAY_AMT_SHD dependencies on PAY_AU_MODULE_TYPES

Line 33: If (p_constraint_name = 'PAY_AU_MODULE_TYPES_CHK1') Then

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

Line 36: ElsIf (p_constraint_name = 'PAY_AU_MODULE_TYPES_PK') Then

32: --
33: If (p_constraint_name = 'PAY_AU_MODULE_TYPES_CHK1') Then
34: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_AU_MODULE_TYPES_PK') 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','10');
40: fnd_message.raise_error;

Line 41: ElsIf (p_constraint_name = 'PAY_AU_MODULE_TYPES_UK1') 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','10');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_AU_MODULE_TYPES_UK1') Then
42: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
43: fnd_message.raise_error;
44: Else
45: fnd_message.set_name('PAY', 'PAY_52681_BHT_CHILD_EXISTS');

Line 70: from pay_au_module_types

66: ,name
67: ,enabled_flag
68: ,description
69: ,object_version_number
70: from pay_au_module_types
71: where module_type_id = p_module_type_id;
72: --
73: l_fct_ret boolean;
74: --

Line 140: from pay_au_module_types

136: ,name
137: ,enabled_flag
138: ,description
139: ,object_version_number
140: from pay_au_module_types
141: where module_type_id = p_module_type_id
142: for update nowait;
143: --
144: l_proc varchar2(72);

Line 191: fnd_message.set_token('TABLE_NAME', 'pay_au_module_types');

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