eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LPS_BUS dependencies on HR_API

Line 48: hr_api.mandatory_arg_error

44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error
49: (p_api_name => l_proc
50: ,p_argument => 'learning_path_id'
51: ,p_argument_value => p_learning_path_id
52: );

Line 75: hr_api.set_security_group_id

71: close csr_sec_grp;
72: --
73: -- Set the security_group_id in CLIENT_INFO
74: --
75: hr_api.set_security_group_id
76: (p_security_group_id => l_security_group_id
77: );
78: --
79: -- Set the sessions legislation context in HR_SESSION_DATA

Line 81: hr_api.set_legislation_context(l_legislation_code);

77: );
78: --
79: -- Set the sessions legislation context in HR_SESSION_DATA
80: --
81: hr_api.set_legislation_context(l_legislation_code);
82: end if;
83: --
84: hr_utility.set_location(' Leaving:'|| l_proc, 20);
85: --

Line 117: hr_api.mandatory_arg_error

113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error
118: (p_api_name => l_proc
119: ,p_argument => 'learning_path_id'
120: ,p_argument_value => p_learning_path_id
121: );

Line 123: if ( nvl(ota_lps_bus.g_learning_path_id, hr_api.g_number)

119: ,p_argument => 'learning_path_id'
120: ,p_argument_value => p_learning_path_id
121: );
122: --
123: if ( nvl(ota_lps_bus.g_learning_path_id, hr_api.g_number)
124: = p_learning_path_id) then
125: --
126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global

Line 199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

195: begin
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.learning_path_id is not null) and (
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.learning_path_id is not null) and (
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

197: --
198: if ((p_rec.learning_path_id is not null) and (
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 202: nvl(p_rec.attribute1, hr_api.g_varchar2) or

198: if ((p_rec.learning_path_id is not null) and (
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 204: nvl(p_rec.attribute2, hr_api.g_varchar2) or

200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 206: nvl(p_rec.attribute3, hr_api.g_varchar2) or

202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 208: nvl(p_rec.attribute4, hr_api.g_varchar2) or

204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 210: nvl(p_rec.attribute5, hr_api.g_varchar2) or

206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 212: nvl(p_rec.attribute6, hr_api.g_varchar2) or

208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 214: nvl(p_rec.attribute7, hr_api.g_varchar2) or

210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 216: nvl(p_rec.attribute8, hr_api.g_varchar2) or

212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 218: nvl(p_rec.attribute9, hr_api.g_varchar2) or

214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 220: nvl(p_rec.attribute10, hr_api.g_varchar2) or

216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 222: nvl(p_rec.attribute11, hr_api.g_varchar2) or

218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 224: nvl(p_rec.attribute12, hr_api.g_varchar2) or

220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 226: nvl(p_rec.attribute13, hr_api.g_varchar2) or

222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 228: nvl(p_rec.attribute14, hr_api.g_varchar2) or

224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 230: nvl(p_rec.attribute15, hr_api.g_varchar2) or

226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 232: nvl(p_rec.attribute16, hr_api.g_varchar2) or

228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 234: nvl(p_rec.attribute17, hr_api.g_varchar2) or

230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 236: nvl(p_rec.attribute18, hr_api.g_varchar2) or

232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_id is null) then

Line 238: nvl(p_rec.attribute19, hr_api.g_varchar2) or

234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_id is null) then
242: --

Line 239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_id is null) then
242: --
243: -- Only execute the validation if absolutely necessary:

Line 240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_id is null) then
242: --
243: -- Only execute the validation if absolutely necessary:
244: -- a) During update, the structure column value or any

Line 348: IF NVL(p_rec.business_group_id, hr_api.g_number) <>

344: fnd_message.raise_error;
345: END IF;
346: --
347: hr_utility.set_location(' Step:'|| l_proc, 10);
348: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
349: NVL(ota_lps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
350: hr_api.argument_changed_error
351: (p_api_name => l_proc
352: ,p_argument => 'BUSINESS_GROUP_ID'

Line 349: NVL(ota_lps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN

345: END IF;
346: --
347: hr_utility.set_location(' Step:'|| l_proc, 10);
348: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
349: NVL(ota_lps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
350: hr_api.argument_changed_error
351: (p_api_name => l_proc
352: ,p_argument => 'BUSINESS_GROUP_ID'
353: ,p_base_table => ota_lps_shd.g_tab_nam);

Line 350: hr_api.argument_changed_error

346: --
347: hr_utility.set_location(' Step:'|| l_proc, 10);
348: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
349: NVL(ota_lps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
350: hr_api.argument_changed_error
351: (p_api_name => l_proc
352: ,p_argument => 'BUSINESS_GROUP_ID'
353: ,p_base_table => ota_lps_shd.g_tab_nam);
354: END IF;

Line 357: IF NVL(p_rec.learning_path_id, hr_api.g_number) <>

353: ,p_base_table => ota_lps_shd.g_tab_nam);
354: END IF;
355: --
356: hr_utility.set_location(' Step:'|| l_proc, 20);
357: IF NVL(p_rec.learning_path_id, hr_api.g_number) <>
358: NVL(ota_lps_shd.g_old_rec.learning_path_id, hr_api.g_number) THEN
359: hr_api.argument_changed_error
360: (p_api_name => l_proc
361: ,p_argument => 'LEARNING_PATH_ID'

Line 358: NVL(ota_lps_shd.g_old_rec.learning_path_id, hr_api.g_number) THEN

354: END IF;
355: --
356: hr_utility.set_location(' Step:'|| l_proc, 20);
357: IF NVL(p_rec.learning_path_id, hr_api.g_number) <>
358: NVL(ota_lps_shd.g_old_rec.learning_path_id, hr_api.g_number) THEN
359: hr_api.argument_changed_error
360: (p_api_name => l_proc
361: ,p_argument => 'LEARNING_PATH_ID'
362: ,p_base_table => ota_lps_shd.g_tab_nam);

Line 359: hr_api.argument_changed_error

355: --
356: hr_utility.set_location(' Step:'|| l_proc, 20);
357: IF NVL(p_rec.learning_path_id, hr_api.g_number) <>
358: NVL(ota_lps_shd.g_old_rec.learning_path_id, hr_api.g_number) THEN
359: hr_api.argument_changed_error
360: (p_api_name => l_proc
361: ,p_argument => 'LEARNING_PATH_ID'
362: ,p_base_table => ota_lps_shd.g_tab_nam);
363: END IF;

Line 408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>

404: --
405: -- Check if anything is changing, or this is an insert
406: --
407: IF (l_api_updating AND
408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>
409: NVL(p_duration, hr_api.g_number)
410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
411: NVL(p_duration_units, hr_api.g_varchar2))
412: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN

Line 409: NVL(p_duration, hr_api.g_number)

405: -- Check if anything is changing, or this is an insert
406: --
407: IF (l_api_updating AND
408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>
409: NVL(p_duration, hr_api.g_number)
410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
411: NVL(p_duration_units, hr_api.g_varchar2))
412: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
413: --

Line 410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>

406: --
407: IF (l_api_updating AND
408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>
409: NVL(p_duration, hr_api.g_number)
410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
411: NVL(p_duration_units, hr_api.g_varchar2))
412: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
413: --
414: -- check the duration is positive

Line 411: NVL(p_duration_units, hr_api.g_varchar2))

407: IF (l_api_updating AND
408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>
409: NVL(p_duration, hr_api.g_number)
410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
411: NVL(p_duration_units, hr_api.g_varchar2))
412: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
413: --
414: -- check the duration is positive
415: --

Line 466: hr_api.mandatory_arg_error

462: hr_utility.set_location(' Leaving:'||l_proc, 10);
463: --
464: -- check mandatory parameters has been set
465: --
466: hr_api.mandatory_arg_error
467: (p_api_name => l_proc
468: ,p_argument => 'effective_date'
469: ,p_argument_value => p_effective_date);
470:

Line 477: NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>

473: ,p_object_version_number => p_object_version_number);
474:
475:
476: IF ((l_api_updating AND
477: NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
478: NVL(p_duration_units, hr_api.g_varchar2))
479: OR NOT l_api_updating AND p_duration_units IS NOT NULL) THEN
480:
481: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 478: NVL(p_duration_units, hr_api.g_varchar2))

474:
475:
476: IF ((l_api_updating AND
477: NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
478: NVL(p_duration_units, hr_api.g_varchar2))
479: OR NOT l_api_updating AND p_duration_units IS NOT NULL) THEN
480:
481: hr_utility.set_location(' Leaving:'||l_proc, 20);
482: --

Line 485: IF hr_api.not_exists_in_hr_lookups

481: hr_utility.set_location(' Leaving:'||l_proc, 20);
482: --
483:
484: IF p_duration_units IS NOT NULL THEN
485: IF hr_api.not_exists_in_hr_lookups
486: (p_effective_date => p_effective_date
487: ,p_lookup_type => 'OTA_DURATION_UNITS'
488: ,p_lookup_code => p_duration_units) THEN
489: fnd_message.set_name('OTA','OTA_13882_NHS_DURATION_INVALID');

Line 580: hr_api.mandatory_arg_error

576: hr_utility.set_location(' Leaving:'||l_proc, 10);
577: --
578: -- check mandatory parameters has been set
579: --
580: hr_api.mandatory_arg_error
581: (p_api_name => l_proc
582: ,p_argument => 'effective_date'
583: ,p_argument_value => p_effective_date);
584:

Line 590: NVL(ota_lps_shd.g_old_rec.path_source_code,hr_api.g_varchar2) <>

586: (p_learning_path_id => p_learning_path_id
587: ,p_object_version_number => p_object_version_number);
588:
589: IF ((l_api_updating AND
590: NVL(ota_lps_shd.g_old_rec.path_source_code,hr_api.g_varchar2) <>
591: NVL(p_path_source_code, hr_api.g_varchar2))
592: OR NOT l_api_updating AND p_path_source_code IS NOT NULL) THEN
593:
594: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 591: NVL(p_path_source_code, hr_api.g_varchar2))

587: ,p_object_version_number => p_object_version_number);
588:
589: IF ((l_api_updating AND
590: NVL(ota_lps_shd.g_old_rec.path_source_code,hr_api.g_varchar2) <>
591: NVL(p_path_source_code, hr_api.g_varchar2))
592: OR NOT l_api_updating AND p_path_source_code IS NOT NULL) THEN
593:
594: hr_utility.set_location(' Leaving:'||l_proc, 20);
595: --

Line 598: IF hr_api.not_exists_in_hr_lookups

594: hr_utility.set_location(' Leaving:'||l_proc, 20);
595: --
596:
597: IF p_path_source_code IS NOT NULL THEN
598: IF hr_api.not_exists_in_hr_lookups
599: (p_effective_date => p_effective_date
600: ,p_lookup_type => 'OTA_TRAINING_PLAN_SOURCE'
601: ,p_lookup_code => p_path_source_code) THEN
602: fnd_message.set_name('OTA','OTA_13176_TPS_PLN_SRC_INVLD');

Line 645: hr_api.mandatory_arg_error

641: hr_utility.set_location(' Leaving:'||l_proc, 10);
642: --
643: -- check mandatory parameters has been set
644: --
645: hr_api.mandatory_arg_error
646: (p_api_name => l_proc
647: ,p_argument => 'effective_date'
648: ,p_argument_value => p_effective_date);
649:

Line 656: NVL(ota_lps_shd.g_old_rec.source_function_code,hr_api.g_varchar2) <>

652: ,p_object_version_number => p_object_version_number);
653:
654:
655: IF ((l_api_updating AND
656: NVL(ota_lps_shd.g_old_rec.source_function_code,hr_api.g_varchar2) <>
657: NVL(p_source_function_code, hr_api.g_varchar2))
658: OR NOT l_api_updating AND p_source_function_code IS NOT NULL) THEN
659:
660: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 657: NVL(p_source_function_code, hr_api.g_varchar2))

653:
654:
655: IF ((l_api_updating AND
656: NVL(ota_lps_shd.g_old_rec.source_function_code,hr_api.g_varchar2) <>
657: NVL(p_source_function_code, hr_api.g_varchar2))
658: OR NOT l_api_updating AND p_source_function_code IS NOT NULL) THEN
659:
660: hr_utility.set_location(' Leaving:'||l_proc, 20);
661: --

Line 664: IF hr_api.not_exists_in_hr_lookups

660: hr_utility.set_location(' Leaving:'||l_proc, 20);
661: --
662:
663: IF p_source_function_code IS NOT NULL THEN
664: IF hr_api.not_exists_in_hr_lookups
665: (p_effective_date => p_effective_date
666: ,p_lookup_type => 'OTA_PLAN_COMPONENT_SOURCE'
667: ,p_lookup_code => p_source_function_code) THEN
668: fnd_message.set_name('OTA','OTA_13178_TPM_SRC_FUNC_INVLD');

Line 710: hr_api.mandatory_arg_error

706: hr_utility.set_location(' Leaving:'||l_proc, 10);
707: --
708: -- check mandatory parameters has been set
709: --
710: hr_api.mandatory_arg_error
711: (p_api_name => l_proc
712: ,p_argument => 'effective_date'
713: ,p_argument_value => p_effective_date);
714:

Line 721: NVL(ota_lps_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>

717: ,p_object_version_number => p_object_version_number);
718:
719:
720: IF ((l_api_updating AND
721: NVL(ota_lps_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
722: NVL(p_competency_update_level, hr_api.g_varchar2))
723: OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN
724:
725: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 722: NVL(p_competency_update_level, hr_api.g_varchar2))

718:
719:
720: IF ((l_api_updating AND
721: NVL(ota_lps_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
722: NVL(p_competency_update_level, hr_api.g_varchar2))
723: OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN
724:
725: hr_utility.set_location(' Leaving:'||l_proc, 20);
726: --

Line 729: IF hr_api.not_exists_in_hr_lookups

725: hr_utility.set_location(' Leaving:'||l_proc, 20);
726: --
727:
728: IF p_competency_update_level IS NOT NULL THEN
729: IF hr_api.not_exists_in_hr_lookups
730: (p_effective_date => p_effective_date
731: ,p_lookup_type => 'OTA_COMPETENCY_UPDATE_LEVEL'
732: ,p_lookup_code => p_competency_update_level) THEN
733: fnd_message.set_name('OTA','OTA_443411_COMP_UPD_LEV_INVLD');

Line 842: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>

838: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
839: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
840: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE' ) THEN
841:
842: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
843: NVL( p_start_date, hr_api.g_date )) THEN
844: l_upd_start_date := TRUE;
845: l_start_date_active := p_start_date;
846: ELSE

Line 843: NVL( p_start_date, hr_api.g_date )) THEN

839: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
840: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE' ) THEN
841:
842: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
843: NVL( p_start_date, hr_api.g_date )) THEN
844: l_upd_start_date := TRUE;
845: l_start_date_active := p_start_date;
846: ELSE
847: l_upd_start_date := FALSE;

Line 851: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>

847: l_upd_start_date := FALSE;
848: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
849: END IF;
850:
851: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
852: NVL( p_end_date, hr_api.g_date )) THEN
853: l_upd_end_date := TRUE;
854: l_end_date_active := p_end_date;
855: ELSE

Line 852: NVL( p_end_date, hr_api.g_date )) THEN

848: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
849: END IF;
850:
851: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
852: NVL( p_end_date, hr_api.g_date )) THEN
853: l_upd_end_date := TRUE;
854: l_end_date_active := p_end_date;
855: ELSE
856: l_upd_end_date := FALSE;

Line 954: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>

950: --
951: OPEN cur_cat_start_end_date;
952: FETCH cur_cat_start_end_date into l_cat_start_date, l_cat_end_date;
953:
954: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
955: NVL( p_start_date, hr_api.g_date )) THEN
956: l_start_date_active := p_start_date;
957: ELSE
958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;

Line 955: NVL( p_start_date, hr_api.g_date )) THEN

951: OPEN cur_cat_start_end_date;
952: FETCH cur_cat_start_end_date into l_cat_start_date, l_cat_end_date;
953:
954: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
955: NVL( p_start_date, hr_api.g_date )) THEN
956: l_start_date_active := p_start_date;
957: ELSE
958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
959: END IF;

Line 961: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>

957: ELSE
958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
959: END IF;
960:
961: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
962: NVL( p_end_date, hr_api.g_date )) THEN
963: l_end_date_active := p_end_date;
964: ELSE
965: l_end_date_active := ota_lps_shd.g_old_rec.end_date_active;

Line 962: NVL( p_end_date, hr_api.g_date )) THEN

958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
959: END IF;
960:
961: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
962: NVL( p_end_date, hr_api.g_date )) THEN
963: l_end_date_active := p_end_date;
964: ELSE
965: l_end_date_active := ota_lps_shd.g_old_rec.end_date_active;
966: END IF;

Line 1021: hr_api.mandatory_arg_error

1017: --
1018: -- check mandatory parameters have been set
1019: --
1020: hr_utility.set_location('Entering:'||l_proc, 5);
1021: hr_api.mandatory_arg_error
1022: (p_api_name => l_proc
1023: ,p_argument => 'p_learning_path_id'
1024: ,p_argument_value => p_learning_path_id
1025: );

Line 1056: hr_api.mandatory_arg_error

1052: --
1053: -- check mandatory parameters have been set
1054: --
1055: hr_utility.set_location('Entering:'||l_proc, 5);
1056: hr_api.mandatory_arg_error
1057: (p_api_name => l_proc
1058: ,p_argument => 'p_learning_path_id'
1059: ,p_argument_value => p_learning_path_id
1060: );

Line 1092: hr_api.validate_bus_grp_id

1088: hr_utility.set_location('Entering:'||l_proc, 5);
1089: --
1090: -- Call all supporting business operations
1091: --
1092: hr_api.validate_bus_grp_id
1093: (p_business_group_id => p_rec.business_group_id
1094: ,p_associated_column1 => ota_lps_shd.g_tab_nam
1095: || '.BUSINESS_GROUP_ID');
1096: --

Line 1188: hr_api.validate_bus_grp_id

1184: hr_utility.set_location('Entering:'||l_proc, 5);
1185: --
1186: -- Call all supporting business operations
1187: --
1188: hr_api.validate_bus_grp_id
1189: (p_business_group_id => p_rec.business_group_id
1190: ,p_associated_column1 => ota_lps_shd.g_tab_nam
1191: || '.BUSINESS_GROUP_ID');
1192: --