APPS.HR_NMF_SHD dependencies on HR_NAME_FORMATS

Line 22: If (p_constraint_name = 'HR_NAME_FORMATS_PK') Then

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'HR_NAME_FORMATS_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;

Line 27: ElsIf (p_constraint_name = 'HR_NAME_FORMATS_U1') Then

23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_NAME_FORMATS_U1') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;

Line 61: from hr_name_formats

57: ,legislation_code
58: ,user_format_choice
59: ,format_mask
60: ,object_version_number
61: from hr_name_formats
62: where name_format_id = p_name_format_id;
63: --
64: l_fct_ret boolean;
65: --

Line 132: from hr_name_formats

128: ,legislation_code
129: ,user_format_choice
130: ,format_mask
131: ,object_version_number
132: from hr_name_formats
133: where name_format_id = p_name_format_id
134: for update nowait;
135: --
136: l_proc varchar2(72) := g_package||'lck';

Line 187: fnd_message.set_token('TABLE_NAME', 'hr_name_formats');

183: -- The object is locked therefore we need to supply a meaningful
184: -- error message.
185: --
186: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
187: fnd_message.set_token('TABLE_NAME', 'hr_name_formats');
188: fnd_message.raise_error;
189: End lck;
190: --
191: -- ----------------------------------------------------------------------------