30: --
31: Begin
32: --
33: If (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK1') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK2') Then
31: Begin
32: --
33: If (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK1') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK2') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
32: --
33: If (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK1') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK2') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
33: If (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK1') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK2') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK2') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK3') Then
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK2') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK3') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK2') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK3') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
38: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK2') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK3') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK3') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_ID') Then
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK3') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_ID') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK3') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_ID') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
43: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_FK3') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_ID') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_ID') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: Else
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_ID') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: Else
54: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_ID') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: Else
54: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
55: fnd_message.set_token('PROCEDURE', l_proc);
48: ElsIf (p_constraint_name = 'HXC_DATA_APP_RULE_USAGES_ID') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: Else
54: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: Else
54: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
57: fnd_message.raise_error;
58: End If;
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: Else
54: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
57: fnd_message.raise_error;
58: End If;
59: --
52: fnd_message.raise_error;
53: Else
54: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
57: fnd_message.raise_error;
58: End If;
59: --
60: End constraint_error;
53: Else
54: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
57: fnd_message.raise_error;
58: End If;
59: --
60: End constraint_error;
61: --
114: Close C_Sel1;
115: --
116: -- The primary key is invalid therefore we must error
117: --
118: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
119: fnd_message.raise_error;
120: End If;
121: Close C_Sel1;
122: If (p_object_version_number
115: --
116: -- The primary key is invalid therefore we must error
117: --
118: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
119: fnd_message.raise_error;
120: End If;
121: Close C_Sel1;
122: If (p_object_version_number
123: <> hxc_dru_shd.g_old_rec.object_version_number) Then
120: End If;
121: Close C_Sel1;
122: If (p_object_version_number
123: <> hxc_dru_shd.g_old_rec.object_version_number) Then
124: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
125: fnd_message.raise_error;
126: End If;
127: l_fct_ret := true;
128: End If;
121: Close C_Sel1;
122: If (p_object_version_number
123: <> hxc_dru_shd.g_old_rec.object_version_number) Then
124: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
125: fnd_message.raise_error;
126: End If;
127: l_fct_ret := true;
128: End If;
129: End If;
173: Close C_Sel1;
174: --
175: -- The primary key is invalid therefore we must error
176: --
177: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
178: fnd_message.raise_error;
179: End If;
180: Close C_Sel1;
181: If (p_object_version_number
174: --
175: -- The primary key is invalid therefore we must error
176: --
177: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
178: fnd_message.raise_error;
179: End If;
180: Close C_Sel1;
181: If (p_object_version_number
182: <> hxc_dru_shd.g_old_rec.object_version_number) Then
179: End If;
180: Close C_Sel1;
181: If (p_object_version_number
182: <> hxc_dru_shd.g_old_rec.object_version_number) Then
183: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
184: fnd_message.raise_error;
185: End If;
186: --
187: if g_debug then
180: Close C_Sel1;
181: If (p_object_version_number
182: <> hxc_dru_shd.g_old_rec.object_version_number) Then
183: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
184: fnd_message.raise_error;
185: End If;
186: --
187: if g_debug then
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
195: --
196: -- The object is locked therefore we need to supply a meaningful
197: -- error message.
198: --
199: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
200: fnd_message.set_token('TABLE_NAME', 'hxc_data_app_rule_usages');
201: fnd_message.raise_error;
202: End lck;
203: --
196: -- The object is locked therefore we need to supply a meaningful
197: -- error message.
198: --
199: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
200: fnd_message.set_token('TABLE_NAME', 'hxc_data_app_rule_usages');
201: fnd_message.raise_error;
202: End lck;
203: --
204: -- ----------------------------------------------------------------------------
197: -- error message.
198: --
199: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
200: fnd_message.set_token('TABLE_NAME', 'hxc_data_app_rule_usages');
201: fnd_message.raise_error;
202: End lck;
203: --
204: -- ----------------------------------------------------------------------------
205: -- |-----------------------------< convert_args >-----------------------------|