DBA Data[Home] [Help]

APPS.OTA_FNS_SHD dependencies on FND_MESSAGE

Line 33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

29: --
30: Begin
31: --
32: If (p_constraint_name = 'OTA_FRM_NOTIF_SUBSCRIBERS_PK1') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else

Line 34: fnd_message.set_token('PROCEDURE', l_proc);

30: Begin
31: --
32: If (p_constraint_name = 'OTA_FRM_NOTIF_SUBSCRIBERS_PK1') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 35: fnd_message.set_token('STEP','5');

31: --
32: If (p_constraint_name = 'OTA_FRM_NOTIF_SUBSCRIBERS_PK1') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);

Line 36: fnd_message.raise_error;

32: If (p_constraint_name = 'OTA_FRM_NOTIF_SUBSCRIBERS_PK1') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

Line 38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;

Line 39: fnd_message.set_token('PROCEDURE', l_proc);

35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --

Line 40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --
44: End constraint_error;

Line 41: fnd_message.raise_error;

37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --
44: End constraint_error;
45: --

Line 112: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

108: Close C_Sel1;
109: --
110: -- The primary key is invalid therefore we must error
111: --
112: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
113: fnd_message.raise_error;
114: End If;
115: Close C_Sel1;
116: If (p_object_version_number

Line 113: fnd_message.raise_error;

109: --
110: -- The primary key is invalid therefore we must error
111: --
112: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
113: fnd_message.raise_error;
114: End If;
115: Close C_Sel1;
116: If (p_object_version_number
117: <> ota_fns_shd.g_old_rec.object_version_number) Then

Line 118: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

114: End If;
115: Close C_Sel1;
116: If (p_object_version_number
117: <> ota_fns_shd.g_old_rec.object_version_number) Then
118: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
119: fnd_message.raise_error;
120: End If;
121: l_fct_ret := true;
122: End If;

Line 119: fnd_message.raise_error;

115: Close C_Sel1;
116: If (p_object_version_number
117: <> ota_fns_shd.g_old_rec.object_version_number) Then
118: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
119: fnd_message.raise_error;
120: End If;
121: l_fct_ret := true;
122: End If;
123: End If;

Line 189: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

185: Close C_Sel1;
186: --
187: -- The primary key is invalid therefore we must error
188: --
189: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
190: fnd_message.raise_error;
191: End If;
192: Close C_Sel1;
193: If (p_object_version_number

Line 190: fnd_message.raise_error;

186: --
187: -- The primary key is invalid therefore we must error
188: --
189: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
190: fnd_message.raise_error;
191: End If;
192: Close C_Sel1;
193: If (p_object_version_number
194: <> ota_fns_shd.g_old_rec.object_version_number) Then

Line 195: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

191: End If;
192: Close C_Sel1;
193: If (p_object_version_number
194: <> ota_fns_shd.g_old_rec.object_version_number) Then
195: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
196: fnd_message.raise_error;
197: End If;
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 196: fnd_message.raise_error;

192: Close C_Sel1;
193: If (p_object_version_number
194: <> ota_fns_shd.g_old_rec.object_version_number) Then
195: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
196: fnd_message.raise_error;
197: End If;
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: --

Line 209: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');

205: --
206: -- The object is locked therefore we need to supply a meaningful
207: -- error message.
208: --
209: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
210: fnd_message.set_token('TABLE_NAME', 'ota_frm_notif_subscribers');
211: fnd_message.raise_error;
212: End lck;
213: --

Line 210: fnd_message.set_token('TABLE_NAME', 'ota_frm_notif_subscribers');

206: -- The object is locked therefore we need to supply a meaningful
207: -- error message.
208: --
209: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
210: fnd_message.set_token('TABLE_NAME', 'ota_frm_notif_subscribers');
211: fnd_message.raise_error;
212: End lck;
213: --
214: -- ----------------------------------------------------------------------------

Line 211: fnd_message.raise_error;

207: -- error message.
208: --
209: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
210: fnd_message.set_token('TABLE_NAME', 'ota_frm_notif_subscribers');
211: fnd_message.raise_error;
212: End lck;
213: --
214: -- ----------------------------------------------------------------------------
215: -- |-----------------------------< convert_args >-----------------------------|