19: Begin
20: --
21: /*
22: If (p_constraint_name = 'OTA_LEARNING_PATHS_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;
27: Else
20: --
21: /*
22: If (p_constraint_name = 'OTA_LEARNING_PATHS_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;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
21: /*
22: If (p_constraint_name = 'OTA_LEARNING_PATHS_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;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
22: If (p_constraint_name = 'OTA_LEARNING_PATHS_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;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
33: */
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
33: */
34: If (p_constraint_name = 'OTA_LEARNING_PATHS_UK1') Then
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
33: */
34: If (p_constraint_name = 'OTA_LEARNING_PATHS_UK1') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
31: fnd_message.raise_error;
32: End If;
33: */
34: If (p_constraint_name = 'OTA_LEARNING_PATHS_UK1') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
32: End If;
33: */
34: If (p_constraint_name = 'OTA_LEARNING_PATHS_UK1') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: */
34: If (p_constraint_name = 'OTA_LEARNING_PATHS_UK1') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
34: If (p_constraint_name = 'OTA_LEARNING_PATHS_UK1') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: --
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: --
46: End constraint_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: --
46: End constraint_error;
47: --
133: Close C_Sel1;
134: --
135: -- The primary key is invalid therefore we must error
136: --
137: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: End If;
140: Close C_Sel1;
141: If (p_object_version_number
134: --
135: -- The primary key is invalid therefore we must error
136: --
137: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: End If;
140: Close C_Sel1;
141: If (p_object_version_number
142: <> ota_lps_shd.g_old_rec.object_version_number) Then
139: End If;
140: Close C_Sel1;
141: If (p_object_version_number
142: <> ota_lps_shd.g_old_rec.object_version_number) Then
143: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
144: fnd_message.raise_error;
145: End If;
146: l_fct_ret := true;
147: End If;
140: Close C_Sel1;
141: If (p_object_version_number
142: <> ota_lps_shd.g_old_rec.object_version_number) Then
143: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
144: fnd_message.raise_error;
145: End If;
146: l_fct_ret := true;
147: End If;
148: End If;
227: Close C_Sel1;
228: --
229: -- The primary key is invalid therefore we must error
230: --
231: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
232: fnd_message.raise_error;
233: End If;
234: Close C_Sel1;
235: If (p_object_version_number
228: --
229: -- The primary key is invalid therefore we must error
230: --
231: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
232: fnd_message.raise_error;
233: End If;
234: Close C_Sel1;
235: If (p_object_version_number
236: <> ota_lps_shd.g_old_rec.object_version_number) Then
233: End If;
234: Close C_Sel1;
235: If (p_object_version_number
236: <> ota_lps_shd.g_old_rec.object_version_number) Then
237: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
238: fnd_message.raise_error;
239: End If;
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 10);
234: Close C_Sel1;
235: If (p_object_version_number
236: <> ota_lps_shd.g_old_rec.object_version_number) Then
237: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
238: fnd_message.raise_error;
239: End If;
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 10);
242: --
247: --
248: -- The object is locked therefore we need to supply a meaningful
249: -- error message.
250: --
251: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
252: fnd_message.set_token('TABLE_NAME', 'ota_learning_paths');
253: fnd_message.raise_error;
254: End lck;
255: --
248: -- The object is locked therefore we need to supply a meaningful
249: -- error message.
250: --
251: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
252: fnd_message.set_token('TABLE_NAME', 'ota_learning_paths');
253: fnd_message.raise_error;
254: End lck;
255: --
256: -- ----------------------------------------------------------------------------
249: -- error message.
250: --
251: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
252: fnd_message.set_token('TABLE_NAME', 'ota_learning_paths');
253: fnd_message.raise_error;
254: End lck;
255: --
256: -- ----------------------------------------------------------------------------
257: -- |-----------------------------< convert_args >-----------------------------|