APPS.PAY_APP_SHD dependencies on PAY_AU_PROCESS_PARAMETERS

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

29: --
30: Begin
31: l_proc := g_package||'constraint_error';
32: --
33: If (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_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_PROCESS_PARAMETERS_CHK2') Then
37: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');

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

32: --
33: If (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_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_PROCESS_PARAMETERS_CHK2') Then
37: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_FK1') Then
40: fnd_message.set_name('PAY', 'HR_AU_INVALID_PROCESS');

Line 39: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_FK1') Then

35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_CHK2') Then
37: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_FK1') Then
40: fnd_message.set_name('PAY', 'HR_AU_INVALID_PROCESS');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_PK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 42: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_PK') Then

38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_FK1') Then
40: fnd_message.set_name('PAY', 'HR_AU_INVALID_PROCESS');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_PK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','20');
46: fnd_message.raise_error;

Line 47: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_UK1') Then

43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','20');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_AU_PROCESS_PARAMETERS_UK1') Then
48: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 79: from pay_au_process_parameters

75: ,internal_name
76: ,data_type
77: ,enabled_flag
78: ,object_version_number
79: from pay_au_process_parameters
80: where process_parameter_id = p_process_parameter_id;
81: --
82: l_fct_ret boolean;
83: --

Line 150: from pay_au_process_parameters

146: ,internal_name
147: ,data_type
148: ,enabled_flag
149: ,object_version_number
150: from pay_au_process_parameters
151: where process_parameter_id = p_process_parameter_id
152: for update nowait;
153: --
154: l_proc varchar2(72);

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

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_process_parameters');
202: fnd_message.raise_error;
203: End lck;
204: --
205: -- ----------------------------------------------------------------------------