DBA Data[Home] [Help]

APPS.PAY_AMP_SHD dependencies on PAY_AU_MODULE_PARAMETERS

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

29: --
30: Begin
31: l_proc := g_package||'constraint_error';
32: --
33: If (p_constraint_name = 'PAY_AU_MODULE_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_MODULE_PARAMETERS_CHK2') Then
37: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');

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

32: --
33: If (p_constraint_name = 'PAY_AU_MODULE_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_MODULE_PARAMETERS_CHK2') Then
37: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK3') Then
40: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');

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

35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK2') Then
37: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK3') Then
40: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK4') Then
43: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');

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

38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK3') Then
40: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK4') Then
43: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK5') Then
46: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');

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

41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK4') Then
43: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK5') Then
46: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK6') Then
49: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');

Line 48: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK6') Then

44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK5') Then
46: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK6') Then
49: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK7') Then
52: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');

Line 51: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK7') Then

47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK6') Then
49: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK7') Then
52: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK8') Then
55: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');

Line 54: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK8') Then

50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK7') Then
52: fnd_message.set_name('PAY', 'HR_AU_DATA_TYPE_MISMATCH');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK8') Then
55: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_FK1') Then
58: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');

Line 57: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_FK1') Then

53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_CHK8') Then
55: fnd_message.set_name('PER', 'PER_52500_INV_YES_NO_FLAG');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_FK1') Then
58: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_PK') Then
61: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 60: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_PK') Then

56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_FK1') Then
58: fnd_message.set_name('PAY','HR_NZ_INVALID_MODULE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_PK') Then
61: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
62: fnd_message.set_token('PROCEDURE', l_proc);
63: fnd_message.set_token('STEP','50');
64: fnd_message.raise_error;

Line 65: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_UK1') Then

61: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
62: fnd_message.set_token('PROCEDURE', l_proc);
63: fnd_message.set_token('STEP','50');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'PAY_AU_MODULE_PARAMETERS_UK1') Then
66: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 106: from pay_au_module_parameters

102: ,external_name
103: ,database_item_name
104: ,constant_value
105: ,object_version_number
106: from pay_au_module_parameters
107: where module_parameter_id = p_module_parameter_id;
108: --
109: l_fct_ret boolean;
110: --

Line 186: from pay_au_module_parameters

182: ,external_name
183: ,database_item_name
184: ,constant_value
185: ,object_version_number
186: from pay_au_module_parameters
187: where module_parameter_id = p_module_parameter_id
188: for update nowait;
189: --
190: l_proc varchar2(72);

Line 237: fnd_message.set_token('TABLE_NAME', 'pay_au_module_parameters');

233: -- The object is locked therefore we need to supply a meaningful
234: -- error message.
235: --
236: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
237: fnd_message.set_token('TABLE_NAME', 'pay_au_module_parameters');
238: fnd_message.raise_error;
239: End lck;
240: --
241: -- ----------------------------------------------------------------------------