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.OKC_AAV_PVT dependencies on OKC_API

Line 148: IF (l_aavv_rec.aae_id = OKC_API.G_MISS_NUM) THEN

144: p_aavv_rec IN aavv_rec_type
145: ) RETURN aavv_rec_type IS
146: l_aavv_rec aavv_rec_type := p_aavv_rec;
147: BEGIN
148: IF (l_aavv_rec.aae_id = OKC_API.G_MISS_NUM) THEN
149: l_aavv_rec.aae_id := NULL;
150: END IF;
151: IF (l_aavv_rec.coe_id = OKC_API.G_MISS_NUM) THEN
152: l_aavv_rec.coe_id := NULL;

Line 151: IF (l_aavv_rec.coe_id = OKC_API.G_MISS_NUM) THEN

147: BEGIN
148: IF (l_aavv_rec.aae_id = OKC_API.G_MISS_NUM) THEN
149: l_aavv_rec.aae_id := NULL;
150: END IF;
151: IF (l_aavv_rec.coe_id = OKC_API.G_MISS_NUM) THEN
152: l_aavv_rec.coe_id := NULL;
153: END IF;
154: IF (l_aavv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
155: l_aavv_rec.object_version_number := NULL;

Line 154: IF (l_aavv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

150: END IF;
151: IF (l_aavv_rec.coe_id = OKC_API.G_MISS_NUM) THEN
152: l_aavv_rec.coe_id := NULL;
153: END IF;
154: IF (l_aavv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
155: l_aavv_rec.object_version_number := NULL;
156: END IF;
157: IF (l_aavv_rec.value = OKC_API.G_MISS_CHAR) THEN
158: l_aavv_rec.value := NULL;

Line 157: IF (l_aavv_rec.value = OKC_API.G_MISS_CHAR) THEN

153: END IF;
154: IF (l_aavv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
155: l_aavv_rec.object_version_number := NULL;
156: END IF;
157: IF (l_aavv_rec.value = OKC_API.G_MISS_CHAR) THEN
158: l_aavv_rec.value := NULL;
159: END IF;
160: IF (l_aavv_rec.created_by = OKC_API.G_MISS_NUM) THEN
161: l_aavv_rec.created_by := NULL;

Line 160: IF (l_aavv_rec.created_by = OKC_API.G_MISS_NUM) THEN

156: END IF;
157: IF (l_aavv_rec.value = OKC_API.G_MISS_CHAR) THEN
158: l_aavv_rec.value := NULL;
159: END IF;
160: IF (l_aavv_rec.created_by = OKC_API.G_MISS_NUM) THEN
161: l_aavv_rec.created_by := NULL;
162: END IF;
163: IF (l_aavv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
164: l_aavv_rec.creation_date := NULL;

Line 163: IF (l_aavv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

159: END IF;
160: IF (l_aavv_rec.created_by = OKC_API.G_MISS_NUM) THEN
161: l_aavv_rec.created_by := NULL;
162: END IF;
163: IF (l_aavv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
164: l_aavv_rec.creation_date := NULL;
165: END IF;
166: IF (l_aavv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
167: l_aavv_rec.last_updated_by := NULL;

Line 166: IF (l_aavv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

162: END IF;
163: IF (l_aavv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
164: l_aavv_rec.creation_date := NULL;
165: END IF;
166: IF (l_aavv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
167: l_aavv_rec.last_updated_by := NULL;
168: END IF;
169: IF (l_aavv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
170: l_aavv_rec.last_update_date := NULL;

Line 169: IF (l_aavv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

165: END IF;
166: IF (l_aavv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
167: l_aavv_rec.last_updated_by := NULL;
168: END IF;
169: IF (l_aavv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
170: l_aavv_rec.last_update_date := NULL;
171: END IF;
172: IF (l_aavv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
173: l_aavv_rec.last_update_login := NULL;

Line 172: IF (l_aavv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

168: END IF;
169: IF (l_aavv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
170: l_aavv_rec.last_update_date := NULL;
171: END IF;
172: IF (l_aavv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
173: l_aavv_rec.last_update_login := NULL;
174: END IF;
175: RETURN(l_aavv_rec);
176: END null_out_defaults;

Line 187: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

183: /* commenting out nocopy generated code in favor of hand written code
184: FUNCTION Validate_Attributes (
185: p_aavv_rec IN aavv_rec_type
186: ) RETURN VARCHAR2 IS
187: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
188: BEGIN
189: IF p_aavv_rec.aae_id = OKC_API.G_MISS_NUM OR
190: p_aavv_rec.aae_id IS NULL
191: THEN

Line 189: IF p_aavv_rec.aae_id = OKC_API.G_MISS_NUM OR

185: p_aavv_rec IN aavv_rec_type
186: ) RETURN VARCHAR2 IS
187: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
188: BEGIN
189: IF p_aavv_rec.aae_id = OKC_API.G_MISS_NUM OR
190: p_aavv_rec.aae_id IS NULL
191: THEN
192: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'aae_id');
193: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 192: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'aae_id');

188: BEGIN
189: IF p_aavv_rec.aae_id = OKC_API.G_MISS_NUM OR
190: p_aavv_rec.aae_id IS NULL
191: THEN
192: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'aae_id');
193: l_return_status := OKC_API.G_RET_STS_ERROR;
194: ELSIF p_aavv_rec.coe_id = OKC_API.G_MISS_NUM OR
195: p_aavv_rec.coe_id IS NULL
196: THEN

Line 193: l_return_status := OKC_API.G_RET_STS_ERROR;

189: IF p_aavv_rec.aae_id = OKC_API.G_MISS_NUM OR
190: p_aavv_rec.aae_id IS NULL
191: THEN
192: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'aae_id');
193: l_return_status := OKC_API.G_RET_STS_ERROR;
194: ELSIF p_aavv_rec.coe_id = OKC_API.G_MISS_NUM OR
195: p_aavv_rec.coe_id IS NULL
196: THEN
197: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coe_id');

Line 194: ELSIF p_aavv_rec.coe_id = OKC_API.G_MISS_NUM OR

190: p_aavv_rec.aae_id IS NULL
191: THEN
192: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'aae_id');
193: l_return_status := OKC_API.G_RET_STS_ERROR;
194: ELSIF p_aavv_rec.coe_id = OKC_API.G_MISS_NUM OR
195: p_aavv_rec.coe_id IS NULL
196: THEN
197: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coe_id');
198: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 197: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coe_id');

193: l_return_status := OKC_API.G_RET_STS_ERROR;
194: ELSIF p_aavv_rec.coe_id = OKC_API.G_MISS_NUM OR
195: p_aavv_rec.coe_id IS NULL
196: THEN
197: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coe_id');
198: l_return_status := OKC_API.G_RET_STS_ERROR;
199: ELSIF p_aavv_rec.object_version_number = OKC_API.G_MISS_NUM OR
200: p_aavv_rec.object_version_number IS NULL
201: THEN

Line 198: l_return_status := OKC_API.G_RET_STS_ERROR;

194: ELSIF p_aavv_rec.coe_id = OKC_API.G_MISS_NUM OR
195: p_aavv_rec.coe_id IS NULL
196: THEN
197: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coe_id');
198: l_return_status := OKC_API.G_RET_STS_ERROR;
199: ELSIF p_aavv_rec.object_version_number = OKC_API.G_MISS_NUM OR
200: p_aavv_rec.object_version_number IS NULL
201: THEN
202: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 199: ELSIF p_aavv_rec.object_version_number = OKC_API.G_MISS_NUM OR

195: p_aavv_rec.coe_id IS NULL
196: THEN
197: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coe_id');
198: l_return_status := OKC_API.G_RET_STS_ERROR;
199: ELSIF p_aavv_rec.object_version_number = OKC_API.G_MISS_NUM OR
200: p_aavv_rec.object_version_number IS NULL
201: THEN
202: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
203: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 202: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

198: l_return_status := OKC_API.G_RET_STS_ERROR;
199: ELSIF p_aavv_rec.object_version_number = OKC_API.G_MISS_NUM OR
200: p_aavv_rec.object_version_number IS NULL
201: THEN
202: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
203: l_return_status := OKC_API.G_RET_STS_ERROR;
204: ELSIF p_aavv_rec.value = OKC_API.G_MISS_CHAR OR
205: p_aavv_rec.value IS NULL
206: THEN

Line 203: l_return_status := OKC_API.G_RET_STS_ERROR;

199: ELSIF p_aavv_rec.object_version_number = OKC_API.G_MISS_NUM OR
200: p_aavv_rec.object_version_number IS NULL
201: THEN
202: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
203: l_return_status := OKC_API.G_RET_STS_ERROR;
204: ELSIF p_aavv_rec.value = OKC_API.G_MISS_CHAR OR
205: p_aavv_rec.value IS NULL
206: THEN
207: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'value');

Line 204: ELSIF p_aavv_rec.value = OKC_API.G_MISS_CHAR OR

200: p_aavv_rec.object_version_number IS NULL
201: THEN
202: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
203: l_return_status := OKC_API.G_RET_STS_ERROR;
204: ELSIF p_aavv_rec.value = OKC_API.G_MISS_CHAR OR
205: p_aavv_rec.value IS NULL
206: THEN
207: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'value');
208: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 207: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'value');

203: l_return_status := OKC_API.G_RET_STS_ERROR;
204: ELSIF p_aavv_rec.value = OKC_API.G_MISS_CHAR OR
205: p_aavv_rec.value IS NULL
206: THEN
207: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'value');
208: l_return_status := OKC_API.G_RET_STS_ERROR;
209: END IF;
210: RETURN(l_return_status);
211: END Validate_Attributes;

Line 208: l_return_status := OKC_API.G_RET_STS_ERROR;

204: ELSIF p_aavv_rec.value = OKC_API.G_MISS_CHAR OR
205: p_aavv_rec.value IS NULL
206: THEN
207: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'value');
208: l_return_status := OKC_API.G_RET_STS_ERROR;
209: END IF;
210: RETURN(l_return_status);
211: END Validate_Attributes;
212: */

Line 232: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

228: PROCEDURE Validate_Object_Version_Number(x_return_status OUT NOCOPY VARCHAR2
229: ,p_aavv_rec IN aavv_rec_type)
230: IS
231:
232: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
233:
234: BEGIN
235: -- initialize return status
236: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 236: x_return_status := OKC_API.G_RET_STS_SUCCESS;

232: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
233:
234: BEGIN
235: -- initialize return status
236: x_return_status := OKC_API.G_RET_STS_SUCCESS;
237: -- check for data before processing
238: IF (p_aavv_rec.object_version_number IS NULL) OR
239: (p_aavv_rec.object_version_Number = OKC_API.G_MISS_NUM) THEN
240: OKC_API.SET_MESSAGE(p_app_name => g_app_name

Line 239: (p_aavv_rec.object_version_Number = OKC_API.G_MISS_NUM) THEN

235: -- initialize return status
236: x_return_status := OKC_API.G_RET_STS_SUCCESS;
237: -- check for data before processing
238: IF (p_aavv_rec.object_version_number IS NULL) OR
239: (p_aavv_rec.object_version_Number = OKC_API.G_MISS_NUM) THEN
240: OKC_API.SET_MESSAGE(p_app_name => g_app_name
241: ,p_msg_name => g_required_value
242: ,p_token1 => g_col_name_token
243: ,p_token1_value => 'object_version_number');

Line 240: OKC_API.SET_MESSAGE(p_app_name => g_app_name

236: x_return_status := OKC_API.G_RET_STS_SUCCESS;
237: -- check for data before processing
238: IF (p_aavv_rec.object_version_number IS NULL) OR
239: (p_aavv_rec.object_version_Number = OKC_API.G_MISS_NUM) THEN
240: OKC_API.SET_MESSAGE(p_app_name => g_app_name
241: ,p_msg_name => g_required_value
242: ,p_token1 => g_col_name_token
243: ,p_token1_value => 'object_version_number');
244: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 244: x_return_status := OKC_API.G_RET_STS_ERROR;

240: OKC_API.SET_MESSAGE(p_app_name => g_app_name
241: ,p_msg_name => g_required_value
242: ,p_token1 => g_col_name_token
243: ,p_token1_value => 'object_version_number');
244: x_return_status := OKC_API.G_RET_STS_ERROR;
245: RAISE G_EXCEPTION_HALT_VALIDATION;
246: END IF;
247:
248: EXCEPTION

Line 256: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

252: NULL;
253:
254: WHEN OTHERS THEN
255: -- store SQL error message on message stack for caller
256: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
257: p_msg_name => g_unexpected_error,
258: p_token1 => g_sqlcode_token,
259: p_token1_value => sqlcode,
260: p_token2 => g_sqlerrm_token,

Line 264: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

260: p_token2 => g_sqlerrm_token,
261: p_token2_value => sqlerrm);
262:
263: -- notify caller of an UNEXPECTED error
264: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
265:
266: END Validate_Object_Version_Number;
267:
268: ---------------------------------------------------------------------------

Line 284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

280: PROCEDURE Validate_Aae_Id(x_return_status OUT NOCOPY VARCHAR2
281: ,p_aavv_rec IN aavv_rec_type)
282: IS
283:
284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
285:
286: BEGIN
287: -- initialize return status
288: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 288: x_return_status := OKC_API.G_RET_STS_SUCCESS;

284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
285:
286: BEGIN
287: -- initialize return status
288: x_return_status := OKC_API.G_RET_STS_SUCCESS;
289: -- check for data before processing
290: IF (p_aavv_rec.aae_id IS NULL) OR
291: (p_aavv_rec.aae_id = OKC_API.G_MISS_NUM) THEN
292: OKC_API.SET_MESSAGE(p_app_name => g_app_name

Line 291: (p_aavv_rec.aae_id = OKC_API.G_MISS_NUM) THEN

287: -- initialize return status
288: x_return_status := OKC_API.G_RET_STS_SUCCESS;
289: -- check for data before processing
290: IF (p_aavv_rec.aae_id IS NULL) OR
291: (p_aavv_rec.aae_id = OKC_API.G_MISS_NUM) THEN
292: OKC_API.SET_MESSAGE(p_app_name => g_app_name
293: ,p_msg_name => g_required_value
294: ,p_token1 => g_col_name_token
295: ,p_token1_value => 'aae_id');

Line 292: OKC_API.SET_MESSAGE(p_app_name => g_app_name

288: x_return_status := OKC_API.G_RET_STS_SUCCESS;
289: -- check for data before processing
290: IF (p_aavv_rec.aae_id IS NULL) OR
291: (p_aavv_rec.aae_id = OKC_API.G_MISS_NUM) THEN
292: OKC_API.SET_MESSAGE(p_app_name => g_app_name
293: ,p_msg_name => g_required_value
294: ,p_token1 => g_col_name_token
295: ,p_token1_value => 'aae_id');
296: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 296: x_return_status := OKC_API.G_RET_STS_ERROR;

292: OKC_API.SET_MESSAGE(p_app_name => g_app_name
293: ,p_msg_name => g_required_value
294: ,p_token1 => g_col_name_token
295: ,p_token1_value => 'aae_id');
296: x_return_status := OKC_API.G_RET_STS_ERROR;
297: RAISE G_EXCEPTION_HALT_VALIDATION;
298: END IF;
299:
300: EXCEPTION

Line 308: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

304: NULL;
305:
306: WHEN OTHERS THEN
307: -- store SQL error message on message stack for caller
308: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
309: p_msg_name => g_unexpected_error,
310: p_token1 => g_sqlcode_token,
311: p_token1_value => sqlcode,
312: p_token2 => g_sqlerrm_token,

Line 316: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

312: p_token2 => g_sqlerrm_token,
313: p_token2_value => sqlerrm);
314:
315: -- notify caller of an UNEXPECTED error
316: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
317:
318: END Validate_Aae_Id;
319:
320: ---------------------------------------------------------------------------

Line 336: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

332: PROCEDURE Validate_Coe_Id(x_return_status OUT NOCOPY VARCHAR2
333: ,p_aavv_rec IN aavv_rec_type)
334: IS
335:
336: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
337:
338: BEGIN
339: -- initialize return status
340: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 340: x_return_status := OKC_API.G_RET_STS_SUCCESS;

336: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
337:
338: BEGIN
339: -- initialize return status
340: x_return_status := OKC_API.G_RET_STS_SUCCESS;
341: -- check for data before processing
342: IF (p_aavv_rec.coe_id IS NULL) OR
343: (p_aavv_rec.coe_id = OKC_API.G_MISS_NUM) THEN
344: OKC_API.SET_MESSAGE(p_app_name => g_app_name

Line 343: (p_aavv_rec.coe_id = OKC_API.G_MISS_NUM) THEN

339: -- initialize return status
340: x_return_status := OKC_API.G_RET_STS_SUCCESS;
341: -- check for data before processing
342: IF (p_aavv_rec.coe_id IS NULL) OR
343: (p_aavv_rec.coe_id = OKC_API.G_MISS_NUM) THEN
344: OKC_API.SET_MESSAGE(p_app_name => g_app_name
345: ,p_msg_name => g_required_value
346: ,p_token1 => g_col_name_token
347: ,p_token1_value => 'coe_id');

Line 344: OKC_API.SET_MESSAGE(p_app_name => g_app_name

340: x_return_status := OKC_API.G_RET_STS_SUCCESS;
341: -- check for data before processing
342: IF (p_aavv_rec.coe_id IS NULL) OR
343: (p_aavv_rec.coe_id = OKC_API.G_MISS_NUM) THEN
344: OKC_API.SET_MESSAGE(p_app_name => g_app_name
345: ,p_msg_name => g_required_value
346: ,p_token1 => g_col_name_token
347: ,p_token1_value => 'coe_id');
348: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 348: x_return_status := OKC_API.G_RET_STS_ERROR;

344: OKC_API.SET_MESSAGE(p_app_name => g_app_name
345: ,p_msg_name => g_required_value
346: ,p_token1 => g_col_name_token
347: ,p_token1_value => 'coe_id');
348: x_return_status := OKC_API.G_RET_STS_ERROR;
349: RAISE G_EXCEPTION_HALT_VALIDATION;
350: END IF;
351:
352: EXCEPTION

Line 360: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

356: NULL;
357:
358: WHEN OTHERS THEN
359: -- store SQL error message on message stack for caller
360: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
361: p_msg_name => g_unexpected_error,
362: p_token1 => g_sqlcode_token,
363: p_token1_value => sqlcode,
364: p_token2 => g_sqlerrm_token,

Line 368: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

364: p_token2 => g_sqlerrm_token,
365: p_token2_value => sqlerrm);
366:
367: -- notify caller of an UNEXPECTED error
368: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
369:
370: END Validate_Coe_Id;
371:
372: ---------------------------------------------------------------------------

Line 377: --l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

373: PROCEDURE Validate_Unique_Aav_Record(x_return_status OUT NOCOPY VARCHAR2
374: ,p_aavv_rec IN aavv_rec_type)
375: IS
376:
377: --l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
378: --l_unq_tbl OKC_UTIL.unq_tbl_type;
379: l_dummy VARCHAR2(1);
380: l_row_found Boolean := False;
381: CURSOR c1(p_aae_id okc_action_att_vals_v.aae_id%TYPE,

Line 392: x_return_status := OKC_API.G_RET_STS_SUCCESS;

388:
389: BEGIN
390:
391: -- initialize return status
392: x_return_status := OKC_API.G_RET_STS_SUCCESS;
393:
394: /*Bug 1636056:The following code commented out nocopy since it was not using bind
395: variables and parsing was taking place.Replaced with explicit cursor
396: as above

Line 404: x_return_status := OKC_API.G_RET_STS_SUCCESS;

400: l_unq_tbl(1).p_col_val := p_aavv_rec.aae_id;
401: l_unq_tbl(2).p_col_name := 'coe_id';
402: l_unq_tbl(2).p_col_val := p_aavv_rec.coe_id;
403: -- initialize return status
404: x_return_status := OKC_API.G_RET_STS_SUCCESS;
405:
406: -- call check_comp_unique utility
407: OKC_UTIL.check_comp_unique('OKC_ACTION_ATT_VALS_V'
408: ,l_unq_tbl

Line 410: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

406: -- call check_comp_unique utility
407: OKC_UTIL.check_comp_unique('OKC_ACTION_ATT_VALS_V'
408: ,l_unq_tbl
409: ,l_return_status);
410: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
411: x_return_status := OKC_API.G_RET_STS_ERROR;
412: END IF;
413: */
414: OPEN c1(p_aavv_rec.aae_id,

Line 411: x_return_status := OKC_API.G_RET_STS_ERROR;

407: OKC_UTIL.check_comp_unique('OKC_ACTION_ATT_VALS_V'
408: ,l_unq_tbl
409: ,l_return_status);
410: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
411: x_return_status := OKC_API.G_RET_STS_ERROR;
412: END IF;
413: */
414: OPEN c1(p_aavv_rec.aae_id,
415: p_aavv_rec.coe_id);

Line 420: --OKC_API.set_message(G_APP_NAME,G_UNQS,G_COL_NAME_TOKEN1,'aae_id',G_COL_NAME_TOKEN2,'coe_id');

416: FETCH c1 into l_dummy;
417: l_row_found := c1%FOUND;
418: CLOSE c1;
419: IF l_row_found then
420: --OKC_API.set_message(G_APP_NAME,G_UNQS,G_COL_NAME_TOKEN1,'aae_id',G_COL_NAME_TOKEN2,'coe_id');
421: OKC_API.set_message(G_APP_NAME,G_UNQS);
422: x_return_status := OKC_API.G_RET_STS_ERROR;
423: END IF;
424:

Line 421: OKC_API.set_message(G_APP_NAME,G_UNQS);

417: l_row_found := c1%FOUND;
418: CLOSE c1;
419: IF l_row_found then
420: --OKC_API.set_message(G_APP_NAME,G_UNQS,G_COL_NAME_TOKEN1,'aae_id',G_COL_NAME_TOKEN2,'coe_id');
421: OKC_API.set_message(G_APP_NAME,G_UNQS);
422: x_return_status := OKC_API.G_RET_STS_ERROR;
423: END IF;
424:
425: EXCEPTION

Line 422: x_return_status := OKC_API.G_RET_STS_ERROR;

418: CLOSE c1;
419: IF l_row_found then
420: --OKC_API.set_message(G_APP_NAME,G_UNQS,G_COL_NAME_TOKEN1,'aae_id',G_COL_NAME_TOKEN2,'coe_id');
421: OKC_API.set_message(G_APP_NAME,G_UNQS);
422: x_return_status := OKC_API.G_RET_STS_ERROR;
423: END IF;
424:
425: EXCEPTION
426: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 433: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

429: NULL;
430:
431: WHEN OTHERS THEN
432: -- store SQL error message on message stack for caller
433: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
434: p_msg_name => g_unexpected_error,
435: p_token1 => g_sqlcode_token,
436: p_token1_value => sqlcode,
437: p_token2 => g_sqlerrm_token,

Line 441: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

437: p_token2 => g_sqlerrm_token,
438: p_token2_value => sqlerrm);
439:
440: -- notify caller of an UNEXPECTED error
441: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
442:
443: END Validate_Unique_Aav_Record;
444:
445: ---------------------------------------------------------------------------

Line 475: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

471: WHERE okc_condition_occurs_v.id = p_id;
472:
473: l_dummy VARCHAR2(1);
474:
475: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
476: l_row_notfound BOOLEAN := TRUE;
477: BEGIN
478: IF (p_aavv_rec.AAE_ID IS NOT NULL)
479: THEN

Line 485: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'AAE_ID');

481: FETCH okc_aaev_pk_csr INTO l_dummy_var;
482: l_row_notfound := okc_aaev_pk_csr%NOTFOUND;
483: CLOSE okc_aaev_pk_csr;
484: IF (l_row_notfound) THEN
485: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'AAE_ID');
486: RAISE item_not_found_error;
487: END IF;
488: END IF;
489: IF (p_aavv_rec.COE_ID IS NOT NULL)

Line 496: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COE_ID');

492: FETCH okc_coev_pk_csr INTO l_dummy;
493: l_row_notfound := okc_coev_pk_csr%NOTFOUND;
494: CLOSE okc_coev_pk_csr;
495: IF (l_row_notfound) THEN
496: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COE_ID');
497: RAISE item_not_found_error;
498: END IF;
499: END IF;
500: RETURN (l_return_status);

Line 503: l_return_status := OKC_API.G_RET_STS_ERROR;

499: END IF;
500: RETURN (l_return_status);
501: EXCEPTION
502: WHEN item_not_found_error THEN
503: l_return_status := OKC_API.G_RET_STS_ERROR;
504: RETURN (l_return_status);
505: END validate_foreign_keys;
506:
507: ---------------------------------------------------------------------------

Line 523: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

519:
520: FUNCTION Validate_Attributes (
521: p_aavv_rec IN aavv_rec_type
522: ) RETURN VARCHAR2 IS
523: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
524: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
525:
526: BEGIN
527:

Line 524: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

520: FUNCTION Validate_Attributes (
521: p_aavv_rec IN aavv_rec_type
522: ) RETURN VARCHAR2 IS
523: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
524: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
525:
526: BEGIN
527:
528: -- call each column-level validation

Line 533: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

529:
530: -- Validate Object_Version_Number
531: Validate_Object_Version_Number(x_return_status,p_aavv_rec);
532: -- store the highest degree of error
533: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
534: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
535: -- need to leave
536: l_return_status := x_return_status;
537: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 534: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

530: -- Validate Object_Version_Number
531: Validate_Object_Version_Number(x_return_status,p_aavv_rec);
532: -- store the highest degree of error
533: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
534: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
535: -- need to leave
536: l_return_status := x_return_status;
537: RAISE G_EXCEPTION_HALT_VALIDATION;
538: ELSE

Line 547: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

543:
544: -- Validate Aae_Id
545: Validate_Aae_Id(x_return_status,p_aavv_rec);
546: -- store the highest degree of error
547: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
548: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
549: -- need to leave
550: l_return_status := x_return_status;
551: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 548: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

544: -- Validate Aae_Id
545: Validate_Aae_Id(x_return_status,p_aavv_rec);
546: -- store the highest degree of error
547: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
548: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
549: -- need to leave
550: l_return_status := x_return_status;
551: RAISE G_EXCEPTION_HALT_VALIDATION;
552: ELSE

Line 561: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

557:
558: -- Validate Coe_Id
559: Validate_Coe_Id(x_return_status,p_aavv_rec);
560: -- store the highest degree of error
561: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
563: -- need to leave
564: l_return_status := x_return_status;
565: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

558: -- Validate Coe_Id
559: Validate_Coe_Id(x_return_status,p_aavv_rec);
560: -- store the highest degree of error
561: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
563: -- need to leave
564: l_return_status := x_return_status;
565: RAISE G_EXCEPTION_HALT_VALIDATION;
566: ELSE

Line 573: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

569: END IF;
570: END IF;
571:
572: l_return_status := Validate_Foreign_Keys(p_aavv_rec);
573: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
574: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
575: -- need to leave
576: x_return_status := l_return_status;
577: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 574: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

570: END IF;
571:
572: l_return_status := Validate_Foreign_Keys(p_aavv_rec);
573: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
574: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
575: -- need to leave
576: x_return_status := l_return_status;
577: RAISE G_EXCEPTION_HALT_VALIDATION;
578: ELSE

Line 591: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

587: NULL;
588: RETURN (l_return_status);
589: WHEN OTHERS THEN
590: -- store SQL error message on message stack for caller
591: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
592: p_msg_name => g_unexpected_error,
593: p_token1 => g_sqlcode_token,
594: p_token1_value => sqlcode,
595: p_token2 => g_sqlerrm_token,

Line 598: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

594: p_token1_value => sqlcode,
595: p_token2 => g_sqlerrm_token,
596: p_token2_value => sqlerrm);
597: -- notify caller of an UNEXPECTED error
598: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
599: RETURN(l_return_status);
600:
601: END Validate_Attributes;
602:

Line 613: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

609: /* commenting out nocopy generated code in favor of hand written code
610: FUNCTION Validate_Record (
611: p_aavv_rec IN aavv_rec_type
612: ) RETURN VARCHAR2 IS
613: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
614: ------------------------------------
615: -- FUNCTION validate_foreign_keys --
616: ------------------------------------
617: FUNCTION validate_foreign_keys (

Line 676: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

672: LAST_UPDATE_LOGIN
673: FROM Okc_Condition_Occurs_V
674: WHERE okc_condition_occurs_v.id = p_id;
675: l_okc_coev_pk okc_coev_pk_csr%ROWTYPE;
676: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
677: l_row_notfound BOOLEAN := TRUE;
678: BEGIN
679: IF (p_aavv_rec.AAE_ID IS NOT NULL)
680: THEN

Line 686: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'AAE_ID');

682: FETCH okc_aaev_pk_csr INTO l_okc_aaev_pk;
683: l_row_notfound := okc_aaev_pk_csr%NOTFOUND;
684: CLOSE okc_aaev_pk_csr;
685: IF (l_row_notfound) THEN
686: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'AAE_ID');
687: RAISE item_not_found_error;
688: END IF;
689: END IF;
690: IF (p_aavv_rec.COE_ID IS NOT NULL)

Line 697: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COE_ID');

693: FETCH okc_coev_pk_csr INTO l_okc_coev_pk;
694: l_row_notfound := okc_coev_pk_csr%NOTFOUND;
695: CLOSE okc_coev_pk_csr;
696: IF (l_row_notfound) THEN
697: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COE_ID');
698: RAISE item_not_found_error;
699: END IF;
700: END IF;
701: RETURN (l_return_status);

Line 704: l_return_status := OKC_API.G_RET_STS_ERROR;

700: END IF;
701: RETURN (l_return_status);
702: EXCEPTION
703: WHEN item_not_found_error THEN
704: l_return_status := OKC_API.G_RET_STS_ERROR;
705: RETURN (l_return_status);
706: END validate_foreign_keys;
707: BEGIN
708: l_return_status := validate_foreign_keys (p_aavv_rec);

Line 716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

712:
713: FUNCTION Validate_Record (
714: p_aavv_rec IN aavv_rec_type
715: ) RETURN VARCHAR2 IS
716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
717: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
718: BEGIN
719: /******** Commented out nocopy , called in Insert Row ***********
720: -- Validate_Unique_Aav_Record;

Line 717: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

713: FUNCTION Validate_Record (
714: p_aavv_rec IN aavv_rec_type
715: ) RETURN VARCHAR2 IS
716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
717: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
718: BEGIN
719: /******** Commented out nocopy , called in Insert Row ***********
720: -- Validate_Unique_Aav_Record;
721: Validate_Unique_Aav_Record(x_return_status,p_aavv_rec);

Line 723: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

719: /******** Commented out nocopy , called in Insert Row ***********
720: -- Validate_Unique_Aav_Record;
721: Validate_Unique_Aav_Record(x_return_status,p_aavv_rec);
722: -- store the highest degree of error
723: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
725: -- need to leave
726: l_return_status := x_return_status;
727: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

720: -- Validate_Unique_Aav_Record;
721: Validate_Unique_Aav_Record(x_return_status,p_aavv_rec);
722: -- store the highest degree of error
723: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
725: -- need to leave
726: l_return_status := x_return_status;
727: RAISE G_EXCEPTION_HALT_VALIDATION;
728: ELSE

Line 789: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

785: p_aavv_rec IN aavv_rec_type) IS
786:
787: l_api_version CONSTANT NUMBER := 1;
788: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
789: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
790: l_aavv_rec aavv_rec_type := p_aavv_rec;
791: l_aav_rec aav_rec_type;
792: BEGIN
793: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 793: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

789: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
790: l_aavv_rec aavv_rec_type := p_aavv_rec;
791: l_aav_rec aav_rec_type;
792: BEGIN
793: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
794: G_PKG_NAME,
795: p_init_msg_list,
796: l_api_version,
797: p_api_version,

Line 800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

796: l_api_version,
797: p_api_version,
798: '_PVT',
799: x_return_status);
800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_ERROR;
804: END IF;

Line 801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

797: p_api_version,
798: '_PVT',
799: x_return_status);
800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_ERROR;
804: END IF;
805: --- Validate all non-missing attributes (Item Level Validation)

Line 802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

798: '_PVT',
799: x_return_status);
800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_ERROR;
804: END IF;
805: --- Validate all non-missing attributes (Item Level Validation)
806: l_return_status := Validate_Attributes(l_aavv_rec);

Line 803: RAISE OKC_API.G_EXCEPTION_ERROR;

799: x_return_status);
800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_ERROR;
804: END IF;
805: --- Validate all non-missing attributes (Item Level Validation)
806: l_return_status := Validate_Attributes(l_aavv_rec);
807: --- If any errors happen abort API

Line 808: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

804: END IF;
805: --- Validate all non-missing attributes (Item Level Validation)
806: l_return_status := Validate_Attributes(l_aavv_rec);
807: --- If any errors happen abort API
808: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
810: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_ERROR;
812: END IF;

Line 809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

805: --- Validate all non-missing attributes (Item Level Validation)
806: l_return_status := Validate_Attributes(l_aavv_rec);
807: --- If any errors happen abort API
808: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
810: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_ERROR;
812: END IF;
813: l_return_status := Validate_Record(l_aavv_rec);

Line 810: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

806: l_return_status := Validate_Attributes(l_aavv_rec);
807: --- If any errors happen abort API
808: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
810: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_ERROR;
812: END IF;
813: l_return_status := Validate_Record(l_aavv_rec);
814: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 811: RAISE OKC_API.G_EXCEPTION_ERROR;

807: --- If any errors happen abort API
808: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
810: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_ERROR;
812: END IF;
813: l_return_status := Validate_Record(l_aavv_rec);
814: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 814: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

810: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_ERROR;
812: END IF;
813: l_return_status := Validate_Record(l_aavv_rec);
814: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_ERROR;
818: END IF;

Line 815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

811: RAISE OKC_API.G_EXCEPTION_ERROR;
812: END IF;
813: l_return_status := Validate_Record(l_aavv_rec);
814: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_ERROR;
818: END IF;
819: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 816: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

812: END IF;
813: l_return_status := Validate_Record(l_aavv_rec);
814: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_ERROR;
818: END IF;
819: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
820: EXCEPTION

Line 817: RAISE OKC_API.G_EXCEPTION_ERROR;

813: l_return_status := Validate_Record(l_aavv_rec);
814: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_ERROR;
818: END IF;
819: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
820: EXCEPTION
821: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 819: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_ERROR;
818: END IF;
819: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
820: EXCEPTION
821: WHEN OKC_API.G_EXCEPTION_ERROR THEN
822: x_return_status := OKC_API.HANDLE_EXCEPTIONS
823: (

Line 821: WHEN OKC_API.G_EXCEPTION_ERROR THEN

817: RAISE OKC_API.G_EXCEPTION_ERROR;
818: END IF;
819: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
820: EXCEPTION
821: WHEN OKC_API.G_EXCEPTION_ERROR THEN
822: x_return_status := OKC_API.HANDLE_EXCEPTIONS
823: (
824: l_api_name,
825: G_PKG_NAME,

Line 822: x_return_status := OKC_API.HANDLE_EXCEPTIONS

818: END IF;
819: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
820: EXCEPTION
821: WHEN OKC_API.G_EXCEPTION_ERROR THEN
822: x_return_status := OKC_API.HANDLE_EXCEPTIONS
823: (
824: l_api_name,
825: G_PKG_NAME,
826: 'OKC_API.G_RET_STS_ERROR',

Line 826: 'OKC_API.G_RET_STS_ERROR',

822: x_return_status := OKC_API.HANDLE_EXCEPTIONS
823: (
824: l_api_name,
825: G_PKG_NAME,
826: 'OKC_API.G_RET_STS_ERROR',
827: x_msg_count,
828: x_msg_data,
829: '_PVT'
830: );

Line 831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

827: x_msg_count,
828: x_msg_data,
829: '_PVT'
830: );
831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
832: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
833: (
834: l_api_name,
835: G_PKG_NAME,

Line 832: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

828: x_msg_data,
829: '_PVT'
830: );
831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
832: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
833: (
834: l_api_name,
835: G_PKG_NAME,
836: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 836: 'OKC_API.G_RET_STS_UNEXP_ERROR',

832: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
833: (
834: l_api_name,
835: G_PKG_NAME,
836: 'OKC_API.G_RET_STS_UNEXP_ERROR',
837: x_msg_count,
838: x_msg_data,
839: '_PVT'
840: );

Line 842: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

838: x_msg_data,
839: '_PVT'
840: );
841: WHEN OTHERS THEN
842: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
843: (
844: l_api_name,
845: G_PKG_NAME,
846: 'OTHERS',

Line 865: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

861: p_aavv_tbl IN aavv_tbl_type) IS
862:
863: l_api_version CONSTANT NUMBER := 1;
864: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
865: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
866: i NUMBER := 0;
867: BEGIN
868: OKC_API.init_msg_list(p_init_msg_list);
869: -- Make sure PL/SQL table has records in it before passing

Line 868: OKC_API.init_msg_list(p_init_msg_list);

864: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
865: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
866: i NUMBER := 0;
867: BEGIN
868: OKC_API.init_msg_list(p_init_msg_list);
869: -- Make sure PL/SQL table has records in it before passing
870: IF (p_aavv_tbl.COUNT > 0) THEN
871: i := p_aavv_tbl.FIRST;
872: LOOP

Line 875: p_init_msg_list => OKC_API.G_FALSE,

871: i := p_aavv_tbl.FIRST;
872: LOOP
873: validate_row (
874: p_api_version => p_api_version,
875: p_init_msg_list => OKC_API.G_FALSE,
876: x_return_status => x_return_status,
877: x_msg_count => x_msg_count,
878: x_msg_data => x_msg_data,
879: p_aavv_rec => p_aavv_tbl(i));

Line 885: WHEN OKC_API.G_EXCEPTION_ERROR THEN

881: i := p_aavv_tbl.NEXT(i);
882: END LOOP;
883: END IF;
884: EXCEPTION
885: WHEN OKC_API.G_EXCEPTION_ERROR THEN
886: x_return_status := OKC_API.HANDLE_EXCEPTIONS
887: (
888: l_api_name,
889: G_PKG_NAME,

Line 886: x_return_status := OKC_API.HANDLE_EXCEPTIONS

882: END LOOP;
883: END IF;
884: EXCEPTION
885: WHEN OKC_API.G_EXCEPTION_ERROR THEN
886: x_return_status := OKC_API.HANDLE_EXCEPTIONS
887: (
888: l_api_name,
889: G_PKG_NAME,
890: 'OKC_API.G_RET_STS_ERROR',

Line 890: 'OKC_API.G_RET_STS_ERROR',

886: x_return_status := OKC_API.HANDLE_EXCEPTIONS
887: (
888: l_api_name,
889: G_PKG_NAME,
890: 'OKC_API.G_RET_STS_ERROR',
891: x_msg_count,
892: x_msg_data,
893: '_PVT'
894: );

Line 895: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

891: x_msg_count,
892: x_msg_data,
893: '_PVT'
894: );
895: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
896: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
897: (
898: l_api_name,
899: G_PKG_NAME,

Line 896: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

892: x_msg_data,
893: '_PVT'
894: );
895: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
896: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
897: (
898: l_api_name,
899: G_PKG_NAME,
900: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 900: 'OKC_API.G_RET_STS_UNEXP_ERROR',

896: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
897: (
898: l_api_name,
899: G_PKG_NAME,
900: 'OKC_API.G_RET_STS_UNEXP_ERROR',
901: x_msg_count,
902: x_msg_data,
903: '_PVT'
904: );

Line 906: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

902: x_msg_data,
903: '_PVT'
904: );
905: WHEN OTHERS THEN
906: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
907: (
908: l_api_name,
909: G_PKG_NAME,
910: 'OTHERS',

Line 933: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

929: x_aav_rec OUT NOCOPY aav_rec_type) IS
930:
931: l_api_version CONSTANT NUMBER := 1;
932: l_api_name CONSTANT VARCHAR2(30) := 'VALS_insert_row';
933: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
934: l_aav_rec aav_rec_type := p_aav_rec;
935: l_def_aav_rec aav_rec_type;
936: --------------------------------------------
937: -- Set_Attributes for:OKC_ACTION_ATT_VALS --

Line 943: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

939: FUNCTION Set_Attributes (
940: p_aav_rec IN aav_rec_type,
941: x_aav_rec OUT NOCOPY aav_rec_type
942: ) RETURN VARCHAR2 IS
943: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
944: BEGIN
945: x_aav_rec := p_aav_rec;
946: RETURN(l_return_status);
947: END Set_Attributes;

Line 949: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

945: x_aav_rec := p_aav_rec;
946: RETURN(l_return_status);
947: END Set_Attributes;
948: BEGIN
949: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
950: p_init_msg_list,
951: '_PVT',
952: x_return_status);
953: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 953: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

949: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
950: p_init_msg_list,
951: '_PVT',
952: x_return_status);
953: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
955: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
956: RAISE OKC_API.G_EXCEPTION_ERROR;
957: END IF;

Line 954: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

950: p_init_msg_list,
951: '_PVT',
952: x_return_status);
953: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
955: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
956: RAISE OKC_API.G_EXCEPTION_ERROR;
957: END IF;
958: --- Setting item attributes

Line 955: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

951: '_PVT',
952: x_return_status);
953: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
955: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
956: RAISE OKC_API.G_EXCEPTION_ERROR;
957: END IF;
958: --- Setting item attributes
959: l_return_status := Set_Attributes(

Line 956: RAISE OKC_API.G_EXCEPTION_ERROR;

952: x_return_status);
953: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
955: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
956: RAISE OKC_API.G_EXCEPTION_ERROR;
957: END IF;
958: --- Setting item attributes
959: l_return_status := Set_Attributes(
960: p_aav_rec, -- IN

Line 963: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

959: l_return_status := Set_Attributes(
960: p_aav_rec, -- IN
961: l_aav_rec); -- OUT
962: --- If any errors happen abort API
963: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
964: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
966: RAISE OKC_API.G_EXCEPTION_ERROR;
967: END IF;

Line 964: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

960: p_aav_rec, -- IN
961: l_aav_rec); -- OUT
962: --- If any errors happen abort API
963: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
964: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
966: RAISE OKC_API.G_EXCEPTION_ERROR;
967: END IF;
968: INSERT INTO OKC_ACTION_ATT_VALS(

Line 965: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

961: l_aav_rec); -- OUT
962: --- If any errors happen abort API
963: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
964: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
966: RAISE OKC_API.G_EXCEPTION_ERROR;
967: END IF;
968: INSERT INTO OKC_ACTION_ATT_VALS(
969: aae_id,

Line 966: RAISE OKC_API.G_EXCEPTION_ERROR;

962: --- If any errors happen abort API
963: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
964: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
966: RAISE OKC_API.G_EXCEPTION_ERROR;
967: END IF;
968: INSERT INTO OKC_ACTION_ATT_VALS(
969: aae_id,
970: coe_id,

Line 990: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

986: l_aav_rec.last_update_date,
987: l_aav_rec.last_update_login);
988: -- Set OUT values
989: x_aav_rec := l_aav_rec;
990: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
991: EXCEPTION
992: WHEN OKC_API.G_EXCEPTION_ERROR THEN
993: x_return_status := OKC_API.HANDLE_EXCEPTIONS
994: (

Line 992: WHEN OKC_API.G_EXCEPTION_ERROR THEN

988: -- Set OUT values
989: x_aav_rec := l_aav_rec;
990: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
991: EXCEPTION
992: WHEN OKC_API.G_EXCEPTION_ERROR THEN
993: x_return_status := OKC_API.HANDLE_EXCEPTIONS
994: (
995: l_api_name,
996: G_PKG_NAME,

Line 993: x_return_status := OKC_API.HANDLE_EXCEPTIONS

989: x_aav_rec := l_aav_rec;
990: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
991: EXCEPTION
992: WHEN OKC_API.G_EXCEPTION_ERROR THEN
993: x_return_status := OKC_API.HANDLE_EXCEPTIONS
994: (
995: l_api_name,
996: G_PKG_NAME,
997: 'OKC_API.G_RET_STS_ERROR',

Line 997: 'OKC_API.G_RET_STS_ERROR',

993: x_return_status := OKC_API.HANDLE_EXCEPTIONS
994: (
995: l_api_name,
996: G_PKG_NAME,
997: 'OKC_API.G_RET_STS_ERROR',
998: x_msg_count,
999: x_msg_data,
1000: '_PVT'
1001: );

Line 1002: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

998: x_msg_count,
999: x_msg_data,
1000: '_PVT'
1001: );
1002: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1003: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1004: (
1005: l_api_name,
1006: G_PKG_NAME,

Line 1003: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

999: x_msg_data,
1000: '_PVT'
1001: );
1002: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1003: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1004: (
1005: l_api_name,
1006: G_PKG_NAME,
1007: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1007: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1003: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1004: (
1005: l_api_name,
1006: G_PKG_NAME,
1007: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1008: x_msg_count,
1009: x_msg_data,
1010: '_PVT'
1011: );

Line 1013: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1009: x_msg_data,
1010: '_PVT'
1011: );
1012: WHEN OTHERS THEN
1013: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1014: (
1015: l_api_name,
1016: G_PKG_NAME,
1017: 'OTHERS',

Line 1037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1033: x_aavv_rec OUT NOCOPY aavv_rec_type) IS
1034:
1035: l_api_version CONSTANT NUMBER := 1;
1036: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1038: l_aavv_rec aavv_rec_type;
1039: l_def_aavv_rec aavv_rec_type;
1040: l_aav_rec aav_rec_type;
1041: lx_aav_rec aav_rec_type;

Line 1064: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1060: FUNCTION Set_Attributes (
1061: p_aavv_rec IN aavv_rec_type,
1062: x_aavv_rec OUT NOCOPY aavv_rec_type
1063: ) RETURN VARCHAR2 IS
1064: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1065: BEGIN
1066: x_aavv_rec := p_aavv_rec;
1067: x_aavv_rec.OBJECT_VERSION_NUMBER := 1;
1068: RETURN(l_return_status);

Line 1071: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1067: x_aavv_rec.OBJECT_VERSION_NUMBER := 1;
1068: RETURN(l_return_status);
1069: END Set_Attributes;
1070: BEGIN
1071: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1072: G_PKG_NAME,
1073: p_init_msg_list,
1074: l_api_version,
1075: p_api_version,

Line 1078: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1074: l_api_version,
1075: p_api_version,
1076: '_PVT',
1077: x_return_status);
1078: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1081: RAISE OKC_API.G_EXCEPTION_ERROR;
1082: END IF;

Line 1079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1075: p_api_version,
1076: '_PVT',
1077: x_return_status);
1078: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1081: RAISE OKC_API.G_EXCEPTION_ERROR;
1082: END IF;
1083: l_aavv_rec := null_out_defaults(p_aavv_rec);

Line 1080: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1076: '_PVT',
1077: x_return_status);
1078: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1081: RAISE OKC_API.G_EXCEPTION_ERROR;
1082: END IF;
1083: l_aavv_rec := null_out_defaults(p_aavv_rec);
1084: --- Setting item attributes

Line 1081: RAISE OKC_API.G_EXCEPTION_ERROR;

1077: x_return_status);
1078: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1081: RAISE OKC_API.G_EXCEPTION_ERROR;
1082: END IF;
1083: l_aavv_rec := null_out_defaults(p_aavv_rec);
1084: --- Setting item attributes
1085: l_return_status := Set_Attributes(

Line 1089: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1085: l_return_status := Set_Attributes(
1086: l_aavv_rec, -- IN
1087: l_def_aavv_rec); -- OUT
1088: --- If any errors happen abort API
1089: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;

Line 1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1086: l_aavv_rec, -- IN
1087: l_def_aavv_rec); -- OUT
1088: --- If any errors happen abort API
1089: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094: l_def_aavv_rec := fill_who_columns(l_def_aavv_rec);

Line 1091: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1087: l_def_aavv_rec); -- OUT
1088: --- If any errors happen abort API
1089: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094: l_def_aavv_rec := fill_who_columns(l_def_aavv_rec);
1095: --- Validate all non-missing attributes (Item Level Validation)

Line 1092: RAISE OKC_API.G_EXCEPTION_ERROR;

1088: --- If any errors happen abort API
1089: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094: l_def_aavv_rec := fill_who_columns(l_def_aavv_rec);
1095: --- Validate all non-missing attributes (Item Level Validation)
1096: l_return_status := Validate_Attributes(l_def_aavv_rec);

Line 1098: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1094: l_def_aavv_rec := fill_who_columns(l_def_aavv_rec);
1095: --- Validate all non-missing attributes (Item Level Validation)
1096: l_return_status := Validate_Attributes(l_def_aavv_rec);
1097: --- If any errors happen abort API
1098: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;

Line 1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1095: --- Validate all non-missing attributes (Item Level Validation)
1096: l_return_status := Validate_Attributes(l_def_aavv_rec);
1097: --- If any errors happen abort API
1098: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;
1103: l_return_status := Validate_Record(l_def_aavv_rec);

Line 1100: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1096: l_return_status := Validate_Attributes(l_def_aavv_rec);
1097: --- If any errors happen abort API
1098: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;
1103: l_return_status := Validate_Record(l_def_aavv_rec);
1104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1101: RAISE OKC_API.G_EXCEPTION_ERROR;

1097: --- If any errors happen abort API
1098: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;
1103: l_return_status := Validate_Record(l_def_aavv_rec);
1104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1100: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;
1103: l_return_status := Validate_Record(l_def_aavv_rec);
1104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1106: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1107: RAISE OKC_API.G_EXCEPTION_ERROR;
1108: END IF;

Line 1105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;
1103: l_return_status := Validate_Record(l_def_aavv_rec);
1104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1106: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1107: RAISE OKC_API.G_EXCEPTION_ERROR;
1108: END IF;
1109:

Line 1106: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1102: END IF;
1103: l_return_status := Validate_Record(l_def_aavv_rec);
1104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1106: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1107: RAISE OKC_API.G_EXCEPTION_ERROR;
1108: END IF;
1109:
1110: /************ ADDED TO CHECK THE UNIQUENESS ****************/

Line 1107: RAISE OKC_API.G_EXCEPTION_ERROR;

1103: l_return_status := Validate_Record(l_def_aavv_rec);
1104: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1106: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1107: RAISE OKC_API.G_EXCEPTION_ERROR;
1108: END IF;
1109:
1110: /************ ADDED TO CHECK THE UNIQUENESS ****************/
1111:

Line 1115: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1111:
1112: -- Validate_Unique_Aav_Record;
1113: Validate_Unique_Aav_Record(x_return_status,p_aavv_rec);
1114: -- store the highest degree of error
1115: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1116: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1117: -- need to leave
1118: l_return_status := x_return_status;
1119: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1116: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1112: -- Validate_Unique_Aav_Record;
1113: Validate_Unique_Aav_Record(x_return_status,p_aavv_rec);
1114: -- store the highest degree of error
1115: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1116: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1117: -- need to leave
1118: l_return_status := x_return_status;
1119: RAISE G_EXCEPTION_HALT_VALIDATION;
1120: ELSE

Line 1144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1140: x_msg_data,
1141: l_aav_rec,
1142: lx_aav_rec
1143: );
1144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1147: RAISE OKC_API.G_EXCEPTION_ERROR;
1148: END IF;

Line 1145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1141: l_aav_rec,
1142: lx_aav_rec
1143: );
1144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1147: RAISE OKC_API.G_EXCEPTION_ERROR;
1148: END IF;
1149: migrate(lx_aav_rec, l_def_aavv_rec);

Line 1146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1142: lx_aav_rec
1143: );
1144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1147: RAISE OKC_API.G_EXCEPTION_ERROR;
1148: END IF;
1149: migrate(lx_aav_rec, l_def_aavv_rec);
1150: -- Set OUT values

Line 1147: RAISE OKC_API.G_EXCEPTION_ERROR;

1143: );
1144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1147: RAISE OKC_API.G_EXCEPTION_ERROR;
1148: END IF;
1149: migrate(lx_aav_rec, l_def_aavv_rec);
1150: -- Set OUT values
1151: x_aavv_rec := l_def_aavv_rec;

Line 1152: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1148: END IF;
1149: migrate(lx_aav_rec, l_def_aavv_rec);
1150: -- Set OUT values
1151: x_aavv_rec := l_def_aavv_rec;
1152: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1153: EXCEPTION
1154: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1155: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1156: (

Line 1154: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1150: -- Set OUT values
1151: x_aavv_rec := l_def_aavv_rec;
1152: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1153: EXCEPTION
1154: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1155: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1156: (
1157: l_api_name,
1158: G_PKG_NAME,

Line 1155: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1151: x_aavv_rec := l_def_aavv_rec;
1152: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1153: EXCEPTION
1154: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1155: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1156: (
1157: l_api_name,
1158: G_PKG_NAME,
1159: 'OKC_API.G_RET_STS_ERROR',

Line 1159: 'OKC_API.G_RET_STS_ERROR',

1155: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1156: (
1157: l_api_name,
1158: G_PKG_NAME,
1159: 'OKC_API.G_RET_STS_ERROR',
1160: x_msg_count,
1161: x_msg_data,
1162: '_PVT'
1163: );

Line 1164: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1160: x_msg_count,
1161: x_msg_data,
1162: '_PVT'
1163: );
1164: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1165: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1166: (
1167: l_api_name,
1168: G_PKG_NAME,

Line 1165: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1161: x_msg_data,
1162: '_PVT'
1163: );
1164: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1165: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1166: (
1167: l_api_name,
1168: G_PKG_NAME,
1169: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1169: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1165: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1166: (
1167: l_api_name,
1168: G_PKG_NAME,
1169: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1170: x_msg_count,
1171: x_msg_data,
1172: '_PVT'
1173: );

Line 1175: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1171: x_msg_data,
1172: '_PVT'
1173: );
1174: WHEN OTHERS THEN
1175: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1176: (
1177: l_api_name,
1178: G_PKG_NAME,
1179: 'OTHERS',

Line 1199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1195: x_aavv_tbl OUT NOCOPY aavv_tbl_type) IS
1196:
1197: l_api_version CONSTANT NUMBER := 1;
1198: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1200: i NUMBER := 0;
1201: BEGIN
1202: OKC_API.init_msg_list(p_init_msg_list);
1203: -- Make sure PL/SQL table has records in it before passing

Line 1202: OKC_API.init_msg_list(p_init_msg_list);

1198: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1200: i NUMBER := 0;
1201: BEGIN
1202: OKC_API.init_msg_list(p_init_msg_list);
1203: -- Make sure PL/SQL table has records in it before passing
1204: IF (p_aavv_tbl.COUNT > 0) THEN
1205: i := p_aavv_tbl.FIRST;
1206: LOOP

Line 1209: p_init_msg_list => OKC_API.G_FALSE,

1205: i := p_aavv_tbl.FIRST;
1206: LOOP
1207: insert_row (
1208: p_api_version => p_api_version,
1209: p_init_msg_list => OKC_API.G_FALSE,
1210: x_return_status => x_return_status,
1211: x_msg_count => x_msg_count,
1212: x_msg_data => x_msg_data,
1213: p_aavv_rec => p_aavv_tbl(i),

Line 1220: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1216: i := p_aavv_tbl.NEXT(i);
1217: END LOOP;
1218: END IF;
1219: EXCEPTION
1220: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1221: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1222: (
1223: l_api_name,
1224: G_PKG_NAME,

Line 1221: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1217: END LOOP;
1218: END IF;
1219: EXCEPTION
1220: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1221: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1222: (
1223: l_api_name,
1224: G_PKG_NAME,
1225: 'OKC_API.G_RET_STS_ERROR',

Line 1225: 'OKC_API.G_RET_STS_ERROR',

1221: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1222: (
1223: l_api_name,
1224: G_PKG_NAME,
1225: 'OKC_API.G_RET_STS_ERROR',
1226: x_msg_count,
1227: x_msg_data,
1228: '_PVT'
1229: );

Line 1230: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1226: x_msg_count,
1227: x_msg_data,
1228: '_PVT'
1229: );
1230: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1231: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1232: (
1233: l_api_name,
1234: G_PKG_NAME,

Line 1231: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1227: x_msg_data,
1228: '_PVT'
1229: );
1230: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1231: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1232: (
1233: l_api_name,
1234: G_PKG_NAME,
1235: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1235: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1231: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1232: (
1233: l_api_name,
1234: G_PKG_NAME,
1235: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1236: x_msg_count,
1237: x_msg_data,
1238: '_PVT'
1239: );

Line 1241: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1237: x_msg_data,
1238: '_PVT'
1239: );
1240: WHEN OTHERS THEN
1241: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1242: (
1243: l_api_name,
1244: G_PKG_NAME,
1245: 'OTHERS',

Line 1282: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1278: WHERE AAE_ID = p_aav_rec.aae_id
1279: AND COE_ID = p_aav_rec.coe_id;
1280: l_api_version CONSTANT NUMBER := 1;
1281: l_api_name CONSTANT VARCHAR2(30) := 'VALS_lock_row';
1282: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1283: l_object_version_number OKC_ACTION_ATT_VALS.OBJECT_VERSION_NUMBER%TYPE;
1284: lc_object_version_number OKC_ACTION_ATT_VALS.OBJECT_VERSION_NUMBER%TYPE;
1285: l_row_notfound BOOLEAN := FALSE;
1286: lc_row_notfound BOOLEAN := FALSE;

Line 1288: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1284: lc_object_version_number OKC_ACTION_ATT_VALS.OBJECT_VERSION_NUMBER%TYPE;
1285: l_row_notfound BOOLEAN := FALSE;
1286: lc_row_notfound BOOLEAN := FALSE;
1287: BEGIN
1288: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1289: p_init_msg_list,
1290: '_PVT',
1291: x_return_status);
1292: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1292: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1288: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1289: p_init_msg_list,
1290: '_PVT',
1291: x_return_status);
1292: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_ERROR;
1296: END IF;

Line 1293: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1289: p_init_msg_list,
1290: '_PVT',
1291: x_return_status);
1292: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_ERROR;
1296: END IF;
1297: BEGIN

Line 1294: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1290: '_PVT',
1291: x_return_status);
1292: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_ERROR;
1296: END IF;
1297: BEGIN
1298: OPEN lock_csr(p_aav_rec);

Line 1295: RAISE OKC_API.G_EXCEPTION_ERROR;

1291: x_return_status);
1292: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_ERROR;
1296: END IF;
1297: BEGIN
1298: OPEN lock_csr(p_aav_rec);
1299: FETCH lock_csr INTO l_object_version_number;

Line 1307: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1303: WHEN E_Resource_Busy THEN
1304: IF (lock_csr%ISOPEN) THEN
1305: CLOSE lock_csr;
1306: END IF;
1307: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1308: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1309: END;
1310:
1311: IF ( l_row_notfound ) THEN

Line 1318: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1314: lc_row_notfound := lchk_csr%NOTFOUND;
1315: CLOSE lchk_csr;
1316: END IF;
1317: IF (lc_row_notfound) THEN
1318: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1319: RAISE OKC_API.G_EXCEPTION_ERROR;
1320: ELSIF lc_object_version_number > p_aav_rec.object_version_number THEN
1321: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1322: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1319: RAISE OKC_API.G_EXCEPTION_ERROR;

1315: CLOSE lchk_csr;
1316: END IF;
1317: IF (lc_row_notfound) THEN
1318: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1319: RAISE OKC_API.G_EXCEPTION_ERROR;
1320: ELSIF lc_object_version_number > p_aav_rec.object_version_number THEN
1321: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1322: RAISE OKC_API.G_EXCEPTION_ERROR;
1323: ELSIF lc_object_version_number <> p_aav_rec.object_version_number THEN

Line 1321: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1317: IF (lc_row_notfound) THEN
1318: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1319: RAISE OKC_API.G_EXCEPTION_ERROR;
1320: ELSIF lc_object_version_number > p_aav_rec.object_version_number THEN
1321: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1322: RAISE OKC_API.G_EXCEPTION_ERROR;
1323: ELSIF lc_object_version_number <> p_aav_rec.object_version_number THEN
1324: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1325: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1322: RAISE OKC_API.G_EXCEPTION_ERROR;

1318: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1319: RAISE OKC_API.G_EXCEPTION_ERROR;
1320: ELSIF lc_object_version_number > p_aav_rec.object_version_number THEN
1321: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1322: RAISE OKC_API.G_EXCEPTION_ERROR;
1323: ELSIF lc_object_version_number <> p_aav_rec.object_version_number THEN
1324: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1325: RAISE OKC_API.G_EXCEPTION_ERROR;
1326: ELSIF lc_object_version_number = -1 THEN

Line 1324: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1320: ELSIF lc_object_version_number > p_aav_rec.object_version_number THEN
1321: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1322: RAISE OKC_API.G_EXCEPTION_ERROR;
1323: ELSIF lc_object_version_number <> p_aav_rec.object_version_number THEN
1324: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1325: RAISE OKC_API.G_EXCEPTION_ERROR;
1326: ELSIF lc_object_version_number = -1 THEN
1327: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1328: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1325: RAISE OKC_API.G_EXCEPTION_ERROR;

1321: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1322: RAISE OKC_API.G_EXCEPTION_ERROR;
1323: ELSIF lc_object_version_number <> p_aav_rec.object_version_number THEN
1324: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1325: RAISE OKC_API.G_EXCEPTION_ERROR;
1326: ELSIF lc_object_version_number = -1 THEN
1327: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1328: RAISE OKC_API.G_EXCEPTION_ERROR;
1329: END IF;

Line 1327: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1323: ELSIF lc_object_version_number <> p_aav_rec.object_version_number THEN
1324: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1325: RAISE OKC_API.G_EXCEPTION_ERROR;
1326: ELSIF lc_object_version_number = -1 THEN
1327: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1328: RAISE OKC_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1331: EXCEPTION

Line 1328: RAISE OKC_API.G_EXCEPTION_ERROR;

1324: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1325: RAISE OKC_API.G_EXCEPTION_ERROR;
1326: ELSIF lc_object_version_number = -1 THEN
1327: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1328: RAISE OKC_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1331: EXCEPTION
1332: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1330: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1326: ELSIF lc_object_version_number = -1 THEN
1327: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1328: RAISE OKC_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1331: EXCEPTION
1332: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1333: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1334: (

Line 1332: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1328: RAISE OKC_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1331: EXCEPTION
1332: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1333: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1334: (
1335: l_api_name,
1336: G_PKG_NAME,

Line 1333: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1329: END IF;
1330: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1331: EXCEPTION
1332: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1333: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1334: (
1335: l_api_name,
1336: G_PKG_NAME,
1337: 'OKC_API.G_RET_STS_ERROR',

Line 1337: 'OKC_API.G_RET_STS_ERROR',

1333: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1334: (
1335: l_api_name,
1336: G_PKG_NAME,
1337: 'OKC_API.G_RET_STS_ERROR',
1338: x_msg_count,
1339: x_msg_data,
1340: '_PVT'
1341: );

Line 1342: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1338: x_msg_count,
1339: x_msg_data,
1340: '_PVT'
1341: );
1342: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1343: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1344: (
1345: l_api_name,
1346: G_PKG_NAME,

Line 1343: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1339: x_msg_data,
1340: '_PVT'
1341: );
1342: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1343: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1344: (
1345: l_api_name,
1346: G_PKG_NAME,
1347: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1347: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1343: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1344: (
1345: l_api_name,
1346: G_PKG_NAME,
1347: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1348: x_msg_count,
1349: x_msg_data,
1350: '_PVT'
1351: );

Line 1353: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1349: x_msg_data,
1350: '_PVT'
1351: );
1352: WHEN OTHERS THEN
1353: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1354: (
1355: l_api_name,
1356: G_PKG_NAME,
1357: 'OTHERS',

Line 1376: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1372: p_aavv_rec IN aavv_rec_type) IS
1373:
1374: l_api_version CONSTANT NUMBER := 1;
1375: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1376: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1377: l_aav_rec aav_rec_type;
1378: BEGIN
1379: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1380: G_PKG_NAME,

Line 1379: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1375: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1376: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1377: l_aav_rec aav_rec_type;
1378: BEGIN
1379: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1380: G_PKG_NAME,
1381: p_init_msg_list,
1382: l_api_version,
1383: p_api_version,

Line 1386: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1382: l_api_version,
1383: p_api_version,
1384: '_PVT',
1385: x_return_status);
1386: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1388: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1389: RAISE OKC_API.G_EXCEPTION_ERROR;
1390: END IF;

Line 1387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1383: p_api_version,
1384: '_PVT',
1385: x_return_status);
1386: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1388: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1389: RAISE OKC_API.G_EXCEPTION_ERROR;
1390: END IF;
1391: --------------------------------------

Line 1388: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1384: '_PVT',
1385: x_return_status);
1386: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1388: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1389: RAISE OKC_API.G_EXCEPTION_ERROR;
1390: END IF;
1391: --------------------------------------
1392: -- Move VIEW record to "Child" records

Line 1389: RAISE OKC_API.G_EXCEPTION_ERROR;

1385: x_return_status);
1386: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1388: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1389: RAISE OKC_API.G_EXCEPTION_ERROR;
1390: END IF;
1391: --------------------------------------
1392: -- Move VIEW record to "Child" records
1393: --------------------------------------

Line 1405: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1401: x_msg_count,
1402: x_msg_data,
1403: l_aav_rec
1404: );
1405: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1406: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1407: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1408: RAISE OKC_API.G_EXCEPTION_ERROR;
1409: END IF;

Line 1406: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1402: x_msg_data,
1403: l_aav_rec
1404: );
1405: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1406: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1407: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1408: RAISE OKC_API.G_EXCEPTION_ERROR;
1409: END IF;
1410: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1407: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1403: l_aav_rec
1404: );
1405: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1406: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1407: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1408: RAISE OKC_API.G_EXCEPTION_ERROR;
1409: END IF;
1410: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1411: EXCEPTION

Line 1408: RAISE OKC_API.G_EXCEPTION_ERROR;

1404: );
1405: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1406: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1407: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1408: RAISE OKC_API.G_EXCEPTION_ERROR;
1409: END IF;
1410: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1411: EXCEPTION
1412: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1410: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1406: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1407: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1408: RAISE OKC_API.G_EXCEPTION_ERROR;
1409: END IF;
1410: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1411: EXCEPTION
1412: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1413: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1414: (

Line 1412: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1408: RAISE OKC_API.G_EXCEPTION_ERROR;
1409: END IF;
1410: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1411: EXCEPTION
1412: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1413: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1414: (
1415: l_api_name,
1416: G_PKG_NAME,

Line 1413: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1409: END IF;
1410: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1411: EXCEPTION
1412: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1413: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1414: (
1415: l_api_name,
1416: G_PKG_NAME,
1417: 'OKC_API.G_RET_STS_ERROR',

Line 1417: 'OKC_API.G_RET_STS_ERROR',

1413: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1414: (
1415: l_api_name,
1416: G_PKG_NAME,
1417: 'OKC_API.G_RET_STS_ERROR',
1418: x_msg_count,
1419: x_msg_data,
1420: '_PVT'
1421: );

Line 1422: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1418: x_msg_count,
1419: x_msg_data,
1420: '_PVT'
1421: );
1422: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1423: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1424: (
1425: l_api_name,
1426: G_PKG_NAME,

Line 1423: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1419: x_msg_data,
1420: '_PVT'
1421: );
1422: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1423: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1424: (
1425: l_api_name,
1426: G_PKG_NAME,
1427: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1427: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1423: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1424: (
1425: l_api_name,
1426: G_PKG_NAME,
1427: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1428: x_msg_count,
1429: x_msg_data,
1430: '_PVT'
1431: );

Line 1433: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1429: x_msg_data,
1430: '_PVT'
1431: );
1432: WHEN OTHERS THEN
1433: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1434: (
1435: l_api_name,
1436: G_PKG_NAME,
1437: 'OTHERS',

Line 1456: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1452: p_aavv_tbl IN aavv_tbl_type) IS
1453:
1454: l_api_version CONSTANT NUMBER := 1;
1455: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1456: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1457: i NUMBER := 0;
1458: BEGIN
1459: OKC_API.init_msg_list(p_init_msg_list);
1460: -- Make sure PL/SQL table has records in it before passing

Line 1459: OKC_API.init_msg_list(p_init_msg_list);

1455: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1456: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1457: i NUMBER := 0;
1458: BEGIN
1459: OKC_API.init_msg_list(p_init_msg_list);
1460: -- Make sure PL/SQL table has records in it before passing
1461: IF (p_aavv_tbl.COUNT > 0) THEN
1462: i := p_aavv_tbl.FIRST;
1463: LOOP

Line 1466: p_init_msg_list => OKC_API.G_FALSE,

1462: i := p_aavv_tbl.FIRST;
1463: LOOP
1464: lock_row (
1465: p_api_version => p_api_version,
1466: p_init_msg_list => OKC_API.G_FALSE,
1467: x_return_status => x_return_status,
1468: x_msg_count => x_msg_count,
1469: x_msg_data => x_msg_data,
1470: p_aavv_rec => p_aavv_tbl(i));

Line 1476: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1472: i := p_aavv_tbl.NEXT(i);
1473: END LOOP;
1474: END IF;
1475: EXCEPTION
1476: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1477: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1478: (
1479: l_api_name,
1480: G_PKG_NAME,

Line 1477: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1473: END LOOP;
1474: END IF;
1475: EXCEPTION
1476: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1477: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1478: (
1479: l_api_name,
1480: G_PKG_NAME,
1481: 'OKC_API.G_RET_STS_ERROR',

Line 1481: 'OKC_API.G_RET_STS_ERROR',

1477: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1478: (
1479: l_api_name,
1480: G_PKG_NAME,
1481: 'OKC_API.G_RET_STS_ERROR',
1482: x_msg_count,
1483: x_msg_data,
1484: '_PVT'
1485: );

Line 1486: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1482: x_msg_count,
1483: x_msg_data,
1484: '_PVT'
1485: );
1486: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1487: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1488: (
1489: l_api_name,
1490: G_PKG_NAME,

Line 1487: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1483: x_msg_data,
1484: '_PVT'
1485: );
1486: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1487: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1488: (
1489: l_api_name,
1490: G_PKG_NAME,
1491: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1491: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1487: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1488: (
1489: l_api_name,
1490: G_PKG_NAME,
1491: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1492: x_msg_count,
1493: x_msg_data,
1494: '_PVT'
1495: );

Line 1497: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1493: x_msg_data,
1494: '_PVT'
1495: );
1496: WHEN OTHERS THEN
1497: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1498: (
1499: l_api_name,
1500: G_PKG_NAME,
1501: 'OTHERS',

Line 1524: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1520: x_aav_rec OUT NOCOPY aav_rec_type) IS
1521:
1522: l_api_version CONSTANT NUMBER := 1;
1523: l_api_name CONSTANT VARCHAR2(30) := 'VALS_update_row';
1524: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1525: l_aav_rec aav_rec_type := p_aav_rec;
1526: l_def_aav_rec aav_rec_type;
1527: l_row_notfound BOOLEAN := TRUE;
1528: ----------------------------------

Line 1537: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1533: x_aav_rec OUT NOCOPY aav_rec_type
1534: ) RETURN VARCHAR2 IS
1535: l_aav_rec aav_rec_type;
1536: l_row_notfound BOOLEAN := TRUE;
1537: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1538: BEGIN
1539: x_aav_rec := p_aav_rec;
1540: -- Get current database values
1541: l_aav_rec := get_rec(p_aav_rec, l_row_notfound);

Line 1543: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1539: x_aav_rec := p_aav_rec;
1540: -- Get current database values
1541: l_aav_rec := get_rec(p_aav_rec, l_row_notfound);
1542: IF (l_row_notfound) THEN
1543: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1544: END IF;
1545: IF (x_aav_rec.aae_id = OKC_API.G_MISS_NUM)
1546: THEN
1547: x_aav_rec.aae_id := l_aav_rec.aae_id;

Line 1545: IF (x_aav_rec.aae_id = OKC_API.G_MISS_NUM)

1541: l_aav_rec := get_rec(p_aav_rec, l_row_notfound);
1542: IF (l_row_notfound) THEN
1543: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1544: END IF;
1545: IF (x_aav_rec.aae_id = OKC_API.G_MISS_NUM)
1546: THEN
1547: x_aav_rec.aae_id := l_aav_rec.aae_id;
1548: END IF;
1549: IF (x_aav_rec.coe_id = OKC_API.G_MISS_NUM)

Line 1549: IF (x_aav_rec.coe_id = OKC_API.G_MISS_NUM)

1545: IF (x_aav_rec.aae_id = OKC_API.G_MISS_NUM)
1546: THEN
1547: x_aav_rec.aae_id := l_aav_rec.aae_id;
1548: END IF;
1549: IF (x_aav_rec.coe_id = OKC_API.G_MISS_NUM)
1550: THEN
1551: x_aav_rec.coe_id := l_aav_rec.coe_id;
1552: END IF;
1553: IF (x_aav_rec.value = OKC_API.G_MISS_CHAR)

Line 1553: IF (x_aav_rec.value = OKC_API.G_MISS_CHAR)

1549: IF (x_aav_rec.coe_id = OKC_API.G_MISS_NUM)
1550: THEN
1551: x_aav_rec.coe_id := l_aav_rec.coe_id;
1552: END IF;
1553: IF (x_aav_rec.value = OKC_API.G_MISS_CHAR)
1554: THEN
1555: x_aav_rec.value := l_aav_rec.value;
1556: END IF;
1557: IF (x_aav_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1557: IF (x_aav_rec.object_version_number = OKC_API.G_MISS_NUM)

1553: IF (x_aav_rec.value = OKC_API.G_MISS_CHAR)
1554: THEN
1555: x_aav_rec.value := l_aav_rec.value;
1556: END IF;
1557: IF (x_aav_rec.object_version_number = OKC_API.G_MISS_NUM)
1558: THEN
1559: x_aav_rec.object_version_number := l_aav_rec.object_version_number;
1560: END IF;
1561: IF (x_aav_rec.created_by = OKC_API.G_MISS_NUM)

Line 1561: IF (x_aav_rec.created_by = OKC_API.G_MISS_NUM)

1557: IF (x_aav_rec.object_version_number = OKC_API.G_MISS_NUM)
1558: THEN
1559: x_aav_rec.object_version_number := l_aav_rec.object_version_number;
1560: END IF;
1561: IF (x_aav_rec.created_by = OKC_API.G_MISS_NUM)
1562: THEN
1563: x_aav_rec.created_by := l_aav_rec.created_by;
1564: END IF;
1565: IF (x_aav_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1565: IF (x_aav_rec.creation_date = OKC_API.G_MISS_DATE)

1561: IF (x_aav_rec.created_by = OKC_API.G_MISS_NUM)
1562: THEN
1563: x_aav_rec.created_by := l_aav_rec.created_by;
1564: END IF;
1565: IF (x_aav_rec.creation_date = OKC_API.G_MISS_DATE)
1566: THEN
1567: x_aav_rec.creation_date := l_aav_rec.creation_date;
1568: END IF;
1569: IF (x_aav_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1569: IF (x_aav_rec.last_updated_by = OKC_API.G_MISS_NUM)

1565: IF (x_aav_rec.creation_date = OKC_API.G_MISS_DATE)
1566: THEN
1567: x_aav_rec.creation_date := l_aav_rec.creation_date;
1568: END IF;
1569: IF (x_aav_rec.last_updated_by = OKC_API.G_MISS_NUM)
1570: THEN
1571: x_aav_rec.last_updated_by := l_aav_rec.last_updated_by;
1572: END IF;
1573: IF (x_aav_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1573: IF (x_aav_rec.last_update_date = OKC_API.G_MISS_DATE)

1569: IF (x_aav_rec.last_updated_by = OKC_API.G_MISS_NUM)
1570: THEN
1571: x_aav_rec.last_updated_by := l_aav_rec.last_updated_by;
1572: END IF;
1573: IF (x_aav_rec.last_update_date = OKC_API.G_MISS_DATE)
1574: THEN
1575: x_aav_rec.last_update_date := l_aav_rec.last_update_date;
1576: END IF;
1577: IF (x_aav_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1577: IF (x_aav_rec.last_update_login = OKC_API.G_MISS_NUM)

1573: IF (x_aav_rec.last_update_date = OKC_API.G_MISS_DATE)
1574: THEN
1575: x_aav_rec.last_update_date := l_aav_rec.last_update_date;
1576: END IF;
1577: IF (x_aav_rec.last_update_login = OKC_API.G_MISS_NUM)
1578: THEN
1579: x_aav_rec.last_update_login := l_aav_rec.last_update_login;
1580: END IF;
1581: RETURN(l_return_status);

Line 1590: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1586: FUNCTION Set_Attributes (
1587: p_aav_rec IN aav_rec_type,
1588: x_aav_rec OUT NOCOPY aav_rec_type
1589: ) RETURN VARCHAR2 IS
1590: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1591: BEGIN
1592: x_aav_rec := p_aav_rec;
1593: RETURN(l_return_status);
1594: END Set_Attributes;

Line 1596: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1592: x_aav_rec := p_aav_rec;
1593: RETURN(l_return_status);
1594: END Set_Attributes;
1595: BEGIN
1596: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1597: p_init_msg_list,
1598: '_PVT',
1599: x_return_status);
1600: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1600: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1596: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1597: p_init_msg_list,
1598: '_PVT',
1599: x_return_status);
1600: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1603: RAISE OKC_API.G_EXCEPTION_ERROR;
1604: END IF;

Line 1601: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1597: p_init_msg_list,
1598: '_PVT',
1599: x_return_status);
1600: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1603: RAISE OKC_API.G_EXCEPTION_ERROR;
1604: END IF;
1605: --- Setting item attributes

Line 1602: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1598: '_PVT',
1599: x_return_status);
1600: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1603: RAISE OKC_API.G_EXCEPTION_ERROR;
1604: END IF;
1605: --- Setting item attributes
1606: l_return_status := Set_Attributes(

Line 1603: RAISE OKC_API.G_EXCEPTION_ERROR;

1599: x_return_status);
1600: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1603: RAISE OKC_API.G_EXCEPTION_ERROR;
1604: END IF;
1605: --- Setting item attributes
1606: l_return_status := Set_Attributes(
1607: p_aav_rec, -- IN

Line 1610: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1606: l_return_status := Set_Attributes(
1607: p_aav_rec, -- IN
1608: l_aav_rec); -- OUT
1609: --- If any errors happen abort API
1610: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1613: RAISE OKC_API.G_EXCEPTION_ERROR;
1614: END IF;

Line 1611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1607: p_aav_rec, -- IN
1608: l_aav_rec); -- OUT
1609: --- If any errors happen abort API
1610: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1613: RAISE OKC_API.G_EXCEPTION_ERROR;
1614: END IF;
1615: l_return_status := populate_new_record(l_aav_rec, l_def_aav_rec);

Line 1612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1608: l_aav_rec); -- OUT
1609: --- If any errors happen abort API
1610: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1613: RAISE OKC_API.G_EXCEPTION_ERROR;
1614: END IF;
1615: l_return_status := populate_new_record(l_aav_rec, l_def_aav_rec);
1616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1613: RAISE OKC_API.G_EXCEPTION_ERROR;

1609: --- If any errors happen abort API
1610: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1613: RAISE OKC_API.G_EXCEPTION_ERROR;
1614: END IF;
1615: l_return_status := populate_new_record(l_aav_rec, l_def_aav_rec);
1616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1613: RAISE OKC_API.G_EXCEPTION_ERROR;
1614: END IF;
1615: l_return_status := populate_new_record(l_aav_rec, l_def_aav_rec);
1616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1618: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1619: RAISE OKC_API.G_EXCEPTION_ERROR;
1620: END IF;

Line 1617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1613: RAISE OKC_API.G_EXCEPTION_ERROR;
1614: END IF;
1615: l_return_status := populate_new_record(l_aav_rec, l_def_aav_rec);
1616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1618: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1619: RAISE OKC_API.G_EXCEPTION_ERROR;
1620: END IF;
1621: UPDATE OKC_ACTION_ATT_VALS

Line 1618: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1614: END IF;
1615: l_return_status := populate_new_record(l_aav_rec, l_def_aav_rec);
1616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1618: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1619: RAISE OKC_API.G_EXCEPTION_ERROR;
1620: END IF;
1621: UPDATE OKC_ACTION_ATT_VALS
1622: SET VALUE = l_def_aav_rec.value,

Line 1619: RAISE OKC_API.G_EXCEPTION_ERROR;

1615: l_return_status := populate_new_record(l_aav_rec, l_def_aav_rec);
1616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1618: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1619: RAISE OKC_API.G_EXCEPTION_ERROR;
1620: END IF;
1621: UPDATE OKC_ACTION_ATT_VALS
1622: SET VALUE = l_def_aav_rec.value,
1623: OBJECT_VERSION_NUMBER = l_def_aav_rec.object_version_number,

Line 1633: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1629: WHERE AAE_ID = l_def_aav_rec.aae_id
1630: AND COE_ID = l_def_aav_rec.coe_id;
1631:
1632: x_aav_rec := l_def_aav_rec;
1633: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1634: EXCEPTION
1635: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1636: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1637: (

Line 1635: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1631:
1632: x_aav_rec := l_def_aav_rec;
1633: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1634: EXCEPTION
1635: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1636: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1637: (
1638: l_api_name,
1639: G_PKG_NAME,

Line 1636: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1632: x_aav_rec := l_def_aav_rec;
1633: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1634: EXCEPTION
1635: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1636: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1637: (
1638: l_api_name,
1639: G_PKG_NAME,
1640: 'OKC_API.G_RET_STS_ERROR',

Line 1640: 'OKC_API.G_RET_STS_ERROR',

1636: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1637: (
1638: l_api_name,
1639: G_PKG_NAME,
1640: 'OKC_API.G_RET_STS_ERROR',
1641: x_msg_count,
1642: x_msg_data,
1643: '_PVT'
1644: );

Line 1645: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1641: x_msg_count,
1642: x_msg_data,
1643: '_PVT'
1644: );
1645: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1646: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1647: (
1648: l_api_name,
1649: G_PKG_NAME,

Line 1646: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1642: x_msg_data,
1643: '_PVT'
1644: );
1645: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1646: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1647: (
1648: l_api_name,
1649: G_PKG_NAME,
1650: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1650: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1646: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1647: (
1648: l_api_name,
1649: G_PKG_NAME,
1650: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1651: x_msg_count,
1652: x_msg_data,
1653: '_PVT'
1654: );

Line 1656: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1652: x_msg_data,
1653: '_PVT'
1654: );
1655: WHEN OTHERS THEN
1656: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1657: (
1658: l_api_name,
1659: G_PKG_NAME,
1660: 'OTHERS',

Line 1680: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1676: x_aavv_rec OUT NOCOPY aavv_rec_type) IS
1677:
1678: l_api_version CONSTANT NUMBER := 1;
1679: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1680: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1681: l_aavv_rec aavv_rec_type := p_aavv_rec;
1682: l_def_aavv_rec aavv_rec_type;
1683: l_aav_rec aav_rec_type;
1684: lx_aav_rec aav_rec_type;

Line 1707: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1703: x_aavv_rec OUT NOCOPY aavv_rec_type
1704: ) RETURN VARCHAR2 IS
1705: l_aavv_rec aavv_rec_type;
1706: l_row_notfound BOOLEAN := TRUE;
1707: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1708: BEGIN
1709: x_aavv_rec := p_aavv_rec;
1710: -- Get current database values
1711: l_aavv_rec := get_rec(p_aavv_rec, l_row_notfound);

Line 1713: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1709: x_aavv_rec := p_aavv_rec;
1710: -- Get current database values
1711: l_aavv_rec := get_rec(p_aavv_rec, l_row_notfound);
1712: IF (l_row_notfound) THEN
1713: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1714: END IF;
1715: IF (x_aavv_rec.aae_id = OKC_API.G_MISS_NUM)
1716: THEN
1717: x_aavv_rec.aae_id := l_aavv_rec.aae_id;

Line 1715: IF (x_aavv_rec.aae_id = OKC_API.G_MISS_NUM)

1711: l_aavv_rec := get_rec(p_aavv_rec, l_row_notfound);
1712: IF (l_row_notfound) THEN
1713: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1714: END IF;
1715: IF (x_aavv_rec.aae_id = OKC_API.G_MISS_NUM)
1716: THEN
1717: x_aavv_rec.aae_id := l_aavv_rec.aae_id;
1718: END IF;
1719: IF (x_aavv_rec.coe_id = OKC_API.G_MISS_NUM)

Line 1719: IF (x_aavv_rec.coe_id = OKC_API.G_MISS_NUM)

1715: IF (x_aavv_rec.aae_id = OKC_API.G_MISS_NUM)
1716: THEN
1717: x_aavv_rec.aae_id := l_aavv_rec.aae_id;
1718: END IF;
1719: IF (x_aavv_rec.coe_id = OKC_API.G_MISS_NUM)
1720: THEN
1721: x_aavv_rec.coe_id := l_aavv_rec.coe_id;
1722: END IF;
1723: IF (x_aavv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1723: IF (x_aavv_rec.object_version_number = OKC_API.G_MISS_NUM)

1719: IF (x_aavv_rec.coe_id = OKC_API.G_MISS_NUM)
1720: THEN
1721: x_aavv_rec.coe_id := l_aavv_rec.coe_id;
1722: END IF;
1723: IF (x_aavv_rec.object_version_number = OKC_API.G_MISS_NUM)
1724: THEN
1725: x_aavv_rec.object_version_number := l_aavv_rec.object_version_number;
1726: END IF;
1727: IF (x_aavv_rec.value = OKC_API.G_MISS_CHAR)

Line 1727: IF (x_aavv_rec.value = OKC_API.G_MISS_CHAR)

1723: IF (x_aavv_rec.object_version_number = OKC_API.G_MISS_NUM)
1724: THEN
1725: x_aavv_rec.object_version_number := l_aavv_rec.object_version_number;
1726: END IF;
1727: IF (x_aavv_rec.value = OKC_API.G_MISS_CHAR)
1728: THEN
1729: x_aavv_rec.value := l_aavv_rec.value;
1730: END IF;
1731: IF (x_aavv_rec.created_by = OKC_API.G_MISS_NUM)

Line 1731: IF (x_aavv_rec.created_by = OKC_API.G_MISS_NUM)

1727: IF (x_aavv_rec.value = OKC_API.G_MISS_CHAR)
1728: THEN
1729: x_aavv_rec.value := l_aavv_rec.value;
1730: END IF;
1731: IF (x_aavv_rec.created_by = OKC_API.G_MISS_NUM)
1732: THEN
1733: x_aavv_rec.created_by := l_aavv_rec.created_by;
1734: END IF;
1735: IF (x_aavv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1735: IF (x_aavv_rec.creation_date = OKC_API.G_MISS_DATE)

1731: IF (x_aavv_rec.created_by = OKC_API.G_MISS_NUM)
1732: THEN
1733: x_aavv_rec.created_by := l_aavv_rec.created_by;
1734: END IF;
1735: IF (x_aavv_rec.creation_date = OKC_API.G_MISS_DATE)
1736: THEN
1737: x_aavv_rec.creation_date := l_aavv_rec.creation_date;
1738: END IF;
1739: IF (x_aavv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1739: IF (x_aavv_rec.last_updated_by = OKC_API.G_MISS_NUM)

1735: IF (x_aavv_rec.creation_date = OKC_API.G_MISS_DATE)
1736: THEN
1737: x_aavv_rec.creation_date := l_aavv_rec.creation_date;
1738: END IF;
1739: IF (x_aavv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1740: THEN
1741: x_aavv_rec.last_updated_by := l_aavv_rec.last_updated_by;
1742: END IF;
1743: IF (x_aavv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1743: IF (x_aavv_rec.last_update_date = OKC_API.G_MISS_DATE)

1739: IF (x_aavv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1740: THEN
1741: x_aavv_rec.last_updated_by := l_aavv_rec.last_updated_by;
1742: END IF;
1743: IF (x_aavv_rec.last_update_date = OKC_API.G_MISS_DATE)
1744: THEN
1745: x_aavv_rec.last_update_date := l_aavv_rec.last_update_date;
1746: END IF;
1747: IF (x_aavv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1747: IF (x_aavv_rec.last_update_login = OKC_API.G_MISS_NUM)

1743: IF (x_aavv_rec.last_update_date = OKC_API.G_MISS_DATE)
1744: THEN
1745: x_aavv_rec.last_update_date := l_aavv_rec.last_update_date;
1746: END IF;
1747: IF (x_aavv_rec.last_update_login = OKC_API.G_MISS_NUM)
1748: THEN
1749: x_aavv_rec.last_update_login := l_aavv_rec.last_update_login;
1750: END IF;
1751: RETURN(l_return_status);

Line 1760: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1756: FUNCTION Set_Attributes (
1757: p_aavv_rec IN aavv_rec_type,
1758: x_aavv_rec OUT NOCOPY aavv_rec_type
1759: ) RETURN VARCHAR2 IS
1760: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1761: BEGIN
1762: x_aavv_rec := p_aavv_rec;
1763: x_aavv_rec.OBJECT_VERSION_NUMBER := NVL(x_aavv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1764: RETURN(l_return_status);

Line 1767: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1763: x_aavv_rec.OBJECT_VERSION_NUMBER := NVL(x_aavv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1764: RETURN(l_return_status);
1765: END Set_Attributes;
1766: BEGIN
1767: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1768: G_PKG_NAME,
1769: p_init_msg_list,
1770: l_api_version,
1771: p_api_version,

Line 1774: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1770: l_api_version,
1771: p_api_version,
1772: '_PVT',
1773: x_return_status);
1774: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1776: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1777: RAISE OKC_API.G_EXCEPTION_ERROR;
1778: END IF;

Line 1775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1771: p_api_version,
1772: '_PVT',
1773: x_return_status);
1774: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1776: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1777: RAISE OKC_API.G_EXCEPTION_ERROR;
1778: END IF;
1779: --- Setting item attributes

Line 1776: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1772: '_PVT',
1773: x_return_status);
1774: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1776: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1777: RAISE OKC_API.G_EXCEPTION_ERROR;
1778: END IF;
1779: --- Setting item attributes
1780: l_return_status := Set_Attributes(

Line 1777: RAISE OKC_API.G_EXCEPTION_ERROR;

1773: x_return_status);
1774: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1776: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1777: RAISE OKC_API.G_EXCEPTION_ERROR;
1778: END IF;
1779: --- Setting item attributes
1780: l_return_status := Set_Attributes(
1781: p_aavv_rec, -- IN

Line 1784: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1780: l_return_status := Set_Attributes(
1781: p_aavv_rec, -- IN
1782: l_aavv_rec); -- OUT
1783: --- If any errors happen abort API
1784: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1785: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1786: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1787: RAISE OKC_API.G_EXCEPTION_ERROR;
1788: END IF;

Line 1785: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1781: p_aavv_rec, -- IN
1782: l_aavv_rec); -- OUT
1783: --- If any errors happen abort API
1784: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1785: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1786: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1787: RAISE OKC_API.G_EXCEPTION_ERROR;
1788: END IF;
1789: l_return_status := populate_new_record(l_aavv_rec, l_def_aavv_rec);

Line 1786: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1782: l_aavv_rec); -- OUT
1783: --- If any errors happen abort API
1784: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1785: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1786: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1787: RAISE OKC_API.G_EXCEPTION_ERROR;
1788: END IF;
1789: l_return_status := populate_new_record(l_aavv_rec, l_def_aavv_rec);
1790: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1787: RAISE OKC_API.G_EXCEPTION_ERROR;

1783: --- If any errors happen abort API
1784: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1785: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1786: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1787: RAISE OKC_API.G_EXCEPTION_ERROR;
1788: END IF;
1789: l_return_status := populate_new_record(l_aavv_rec, l_def_aavv_rec);
1790: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1790: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1786: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1787: RAISE OKC_API.G_EXCEPTION_ERROR;
1788: END IF;
1789: l_return_status := populate_new_record(l_aavv_rec, l_def_aavv_rec);
1790: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_ERROR;
1794: END IF;

Line 1791: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1787: RAISE OKC_API.G_EXCEPTION_ERROR;
1788: END IF;
1789: l_return_status := populate_new_record(l_aavv_rec, l_def_aavv_rec);
1790: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_ERROR;
1794: END IF;
1795: l_def_aavv_rec := fill_who_columns(l_def_aavv_rec);

Line 1792: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1788: END IF;
1789: l_return_status := populate_new_record(l_aavv_rec, l_def_aavv_rec);
1790: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_ERROR;
1794: END IF;
1795: l_def_aavv_rec := fill_who_columns(l_def_aavv_rec);
1796: --- Validate all non-missing attributes (Item Level Validation)

Line 1793: RAISE OKC_API.G_EXCEPTION_ERROR;

1789: l_return_status := populate_new_record(l_aavv_rec, l_def_aavv_rec);
1790: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_ERROR;
1794: END IF;
1795: l_def_aavv_rec := fill_who_columns(l_def_aavv_rec);
1796: --- Validate all non-missing attributes (Item Level Validation)
1797: l_return_status := Validate_Attributes(l_def_aavv_rec);

Line 1799: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1795: l_def_aavv_rec := fill_who_columns(l_def_aavv_rec);
1796: --- Validate all non-missing attributes (Item Level Validation)
1797: l_return_status := Validate_Attributes(l_def_aavv_rec);
1798: --- If any errors happen abort API
1799: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1801: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1802: RAISE OKC_API.G_EXCEPTION_ERROR;
1803: END IF;

Line 1800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1796: --- Validate all non-missing attributes (Item Level Validation)
1797: l_return_status := Validate_Attributes(l_def_aavv_rec);
1798: --- If any errors happen abort API
1799: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1801: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1802: RAISE OKC_API.G_EXCEPTION_ERROR;
1803: END IF;
1804: l_return_status := Validate_Record(l_def_aavv_rec);

Line 1801: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1797: l_return_status := Validate_Attributes(l_def_aavv_rec);
1798: --- If any errors happen abort API
1799: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1801: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1802: RAISE OKC_API.G_EXCEPTION_ERROR;
1803: END IF;
1804: l_return_status := Validate_Record(l_def_aavv_rec);
1805: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1802: RAISE OKC_API.G_EXCEPTION_ERROR;

1798: --- If any errors happen abort API
1799: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1801: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1802: RAISE OKC_API.G_EXCEPTION_ERROR;
1803: END IF;
1804: l_return_status := Validate_Record(l_def_aavv_rec);
1805: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1806: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1805: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1801: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1802: RAISE OKC_API.G_EXCEPTION_ERROR;
1803: END IF;
1804: l_return_status := Validate_Record(l_def_aavv_rec);
1805: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1806: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1807: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1808: RAISE OKC_API.G_EXCEPTION_ERROR;
1809: END IF;

Line 1806: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1802: RAISE OKC_API.G_EXCEPTION_ERROR;
1803: END IF;
1804: l_return_status := Validate_Record(l_def_aavv_rec);
1805: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1806: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1807: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1808: RAISE OKC_API.G_EXCEPTION_ERROR;
1809: END IF;
1810:

Line 1807: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1803: END IF;
1804: l_return_status := Validate_Record(l_def_aavv_rec);
1805: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1806: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1807: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1808: RAISE OKC_API.G_EXCEPTION_ERROR;
1809: END IF;
1810:
1811: --------------------------------------

Line 1808: RAISE OKC_API.G_EXCEPTION_ERROR;

1804: l_return_status := Validate_Record(l_def_aavv_rec);
1805: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1806: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1807: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1808: RAISE OKC_API.G_EXCEPTION_ERROR;
1809: END IF;
1810:
1811: --------------------------------------
1812: -- Move VIEW record to "Child" records

Line 1826: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1822: x_msg_data,
1823: l_aav_rec,
1824: lx_aav_rec
1825: );
1826: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1827: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1828: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1829: RAISE OKC_API.G_EXCEPTION_ERROR;
1830: END IF;

Line 1827: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1823: l_aav_rec,
1824: lx_aav_rec
1825: );
1826: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1827: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1828: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1829: RAISE OKC_API.G_EXCEPTION_ERROR;
1830: END IF;
1831: migrate(lx_aav_rec, l_def_aavv_rec);

Line 1828: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1824: lx_aav_rec
1825: );
1826: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1827: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1828: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1829: RAISE OKC_API.G_EXCEPTION_ERROR;
1830: END IF;
1831: migrate(lx_aav_rec, l_def_aavv_rec);
1832: x_aavv_rec := l_def_aavv_rec;

Line 1829: RAISE OKC_API.G_EXCEPTION_ERROR;

1825: );
1826: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1827: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1828: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1829: RAISE OKC_API.G_EXCEPTION_ERROR;
1830: END IF;
1831: migrate(lx_aav_rec, l_def_aavv_rec);
1832: x_aavv_rec := l_def_aavv_rec;
1833: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1833: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1829: RAISE OKC_API.G_EXCEPTION_ERROR;
1830: END IF;
1831: migrate(lx_aav_rec, l_def_aavv_rec);
1832: x_aavv_rec := l_def_aavv_rec;
1833: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1834: EXCEPTION
1835: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1836: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1837: (

Line 1835: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1831: migrate(lx_aav_rec, l_def_aavv_rec);
1832: x_aavv_rec := l_def_aavv_rec;
1833: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1834: EXCEPTION
1835: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1836: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1837: (
1838: l_api_name,
1839: G_PKG_NAME,

Line 1836: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1832: x_aavv_rec := l_def_aavv_rec;
1833: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1834: EXCEPTION
1835: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1836: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1837: (
1838: l_api_name,
1839: G_PKG_NAME,
1840: 'OKC_API.G_RET_STS_ERROR',

Line 1840: 'OKC_API.G_RET_STS_ERROR',

1836: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1837: (
1838: l_api_name,
1839: G_PKG_NAME,
1840: 'OKC_API.G_RET_STS_ERROR',
1841: x_msg_count,
1842: x_msg_data,
1843: '_PVT'
1844: );

Line 1845: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1841: x_msg_count,
1842: x_msg_data,
1843: '_PVT'
1844: );
1845: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1846: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1847: (
1848: l_api_name,
1849: G_PKG_NAME,

Line 1846: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1842: x_msg_data,
1843: '_PVT'
1844: );
1845: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1846: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1847: (
1848: l_api_name,
1849: G_PKG_NAME,
1850: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1850: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1846: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1847: (
1848: l_api_name,
1849: G_PKG_NAME,
1850: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1851: x_msg_count,
1852: x_msg_data,
1853: '_PVT'
1854: );

Line 1856: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1852: x_msg_data,
1853: '_PVT'
1854: );
1855: WHEN OTHERS THEN
1856: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1857: (
1858: l_api_name,
1859: G_PKG_NAME,
1860: 'OTHERS',

Line 1880: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1876: x_aavv_tbl OUT NOCOPY aavv_tbl_type) IS
1877:
1878: l_api_version CONSTANT NUMBER := 1;
1879: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1880: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1881: i NUMBER := 0;
1882: BEGIN
1883: OKC_API.init_msg_list(p_init_msg_list);
1884: -- Make sure PL/SQL table has records in it before passing

Line 1883: OKC_API.init_msg_list(p_init_msg_list);

1879: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1880: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1881: i NUMBER := 0;
1882: BEGIN
1883: OKC_API.init_msg_list(p_init_msg_list);
1884: -- Make sure PL/SQL table has records in it before passing
1885: IF (p_aavv_tbl.COUNT > 0) THEN
1886: i := p_aavv_tbl.FIRST;
1887: LOOP

Line 1890: p_init_msg_list => OKC_API.G_FALSE,

1886: i := p_aavv_tbl.FIRST;
1887: LOOP
1888: update_row (
1889: p_api_version => p_api_version,
1890: p_init_msg_list => OKC_API.G_FALSE,
1891: x_return_status => x_return_status,
1892: x_msg_count => x_msg_count,
1893: x_msg_data => x_msg_data,
1894: p_aavv_rec => p_aavv_tbl(i),

Line 1901: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1897: i := p_aavv_tbl.NEXT(i);
1898: END LOOP;
1899: END IF;
1900: EXCEPTION
1901: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1902: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1903: (
1904: l_api_name,
1905: G_PKG_NAME,

Line 1902: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1898: END LOOP;
1899: END IF;
1900: EXCEPTION
1901: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1902: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1903: (
1904: l_api_name,
1905: G_PKG_NAME,
1906: 'OKC_API.G_RET_STS_ERROR',

Line 1906: 'OKC_API.G_RET_STS_ERROR',

1902: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1903: (
1904: l_api_name,
1905: G_PKG_NAME,
1906: 'OKC_API.G_RET_STS_ERROR',
1907: x_msg_count,
1908: x_msg_data,
1909: '_PVT'
1910: );

Line 1911: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1907: x_msg_count,
1908: x_msg_data,
1909: '_PVT'
1910: );
1911: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1912: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1913: (
1914: l_api_name,
1915: G_PKG_NAME,

Line 1912: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1908: x_msg_data,
1909: '_PVT'
1910: );
1911: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1912: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1913: (
1914: l_api_name,
1915: G_PKG_NAME,
1916: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1916: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1912: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1913: (
1914: l_api_name,
1915: G_PKG_NAME,
1916: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1917: x_msg_count,
1918: x_msg_data,
1919: '_PVT'
1920: );

Line 1922: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1918: x_msg_data,
1919: '_PVT'
1920: );
1921: WHEN OTHERS THEN
1922: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1923: (
1924: l_api_name,
1925: G_PKG_NAME,
1926: 'OTHERS',

Line 1948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1944: p_aav_rec IN aav_rec_type) IS
1945:
1946: l_api_version CONSTANT NUMBER := 1;
1947: l_api_name CONSTANT VARCHAR2(30) := 'VALS_delete_row';
1948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1949: l_aav_rec aav_rec_type:= p_aav_rec;
1950: l_row_notfound BOOLEAN := TRUE;
1951: BEGIN
1952: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1952: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1949: l_aav_rec aav_rec_type:= p_aav_rec;
1950: l_row_notfound BOOLEAN := TRUE;
1951: BEGIN
1952: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1953: p_init_msg_list,
1954: '_PVT',
1955: x_return_status);
1956: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1956: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1952: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1953: p_init_msg_list,
1954: '_PVT',
1955: x_return_status);
1956: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1957: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1958: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1959: RAISE OKC_API.G_EXCEPTION_ERROR;
1960: END IF;

Line 1957: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1953: p_init_msg_list,
1954: '_PVT',
1955: x_return_status);
1956: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1957: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1958: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1959: RAISE OKC_API.G_EXCEPTION_ERROR;
1960: END IF;
1961: DELETE FROM OKC_ACTION_ATT_VALS

Line 1958: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1954: '_PVT',
1955: x_return_status);
1956: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1957: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1958: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1959: RAISE OKC_API.G_EXCEPTION_ERROR;
1960: END IF;
1961: DELETE FROM OKC_ACTION_ATT_VALS
1962: WHERE AAE_ID = l_aav_rec.aae_id AND

Line 1959: RAISE OKC_API.G_EXCEPTION_ERROR;

1955: x_return_status);
1956: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1957: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1958: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1959: RAISE OKC_API.G_EXCEPTION_ERROR;
1960: END IF;
1961: DELETE FROM OKC_ACTION_ATT_VALS
1962: WHERE AAE_ID = l_aav_rec.aae_id AND
1963: COE_ID = l_aav_rec.coe_id;

Line 1965: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1961: DELETE FROM OKC_ACTION_ATT_VALS
1962: WHERE AAE_ID = l_aav_rec.aae_id AND
1963: COE_ID = l_aav_rec.coe_id;
1964:
1965: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1966: EXCEPTION
1967: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1968: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1969: (

Line 1967: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1963: COE_ID = l_aav_rec.coe_id;
1964:
1965: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1966: EXCEPTION
1967: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1968: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1969: (
1970: l_api_name,
1971: G_PKG_NAME,

Line 1968: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1964:
1965: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1966: EXCEPTION
1967: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1968: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1969: (
1970: l_api_name,
1971: G_PKG_NAME,
1972: 'OKC_API.G_RET_STS_ERROR',

Line 1972: 'OKC_API.G_RET_STS_ERROR',

1968: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1969: (
1970: l_api_name,
1971: G_PKG_NAME,
1972: 'OKC_API.G_RET_STS_ERROR',
1973: x_msg_count,
1974: x_msg_data,
1975: '_PVT'
1976: );

Line 1977: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1973: x_msg_count,
1974: x_msg_data,
1975: '_PVT'
1976: );
1977: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1978: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1979: (
1980: l_api_name,
1981: G_PKG_NAME,

Line 1978: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1974: x_msg_data,
1975: '_PVT'
1976: );
1977: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1978: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1979: (
1980: l_api_name,
1981: G_PKG_NAME,
1982: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1982: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1978: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1979: (
1980: l_api_name,
1981: G_PKG_NAME,
1982: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1983: x_msg_count,
1984: x_msg_data,
1985: '_PVT'
1986: );

Line 1988: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1984: x_msg_data,
1985: '_PVT'
1986: );
1987: WHEN OTHERS THEN
1988: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1989: (
1990: l_api_name,
1991: G_PKG_NAME,
1992: 'OTHERS',

Line 2011: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2007: p_aavv_rec IN aavv_rec_type) IS
2008:
2009: l_api_version CONSTANT NUMBER := 1;
2010: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2011: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2012: l_aavv_rec aavv_rec_type := p_aavv_rec;
2013: l_aav_rec aav_rec_type;
2014: BEGIN
2015: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2015: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2011: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2012: l_aavv_rec aavv_rec_type := p_aavv_rec;
2013: l_aav_rec aav_rec_type;
2014: BEGIN
2015: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2016: G_PKG_NAME,
2017: p_init_msg_list,
2018: l_api_version,
2019: p_api_version,

Line 2022: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2018: l_api_version,
2019: p_api_version,
2020: '_PVT',
2021: x_return_status);
2022: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2024: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2025: RAISE OKC_API.G_EXCEPTION_ERROR;
2026: END IF;

Line 2023: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2019: p_api_version,
2020: '_PVT',
2021: x_return_status);
2022: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2024: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2025: RAISE OKC_API.G_EXCEPTION_ERROR;
2026: END IF;
2027: --------------------------------------

Line 2024: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2020: '_PVT',
2021: x_return_status);
2022: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2024: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2025: RAISE OKC_API.G_EXCEPTION_ERROR;
2026: END IF;
2027: --------------------------------------
2028: -- Move VIEW record to "Child" records

Line 2025: RAISE OKC_API.G_EXCEPTION_ERROR;

2021: x_return_status);
2022: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2024: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2025: RAISE OKC_API.G_EXCEPTION_ERROR;
2026: END IF;
2027: --------------------------------------
2028: -- Move VIEW record to "Child" records
2029: --------------------------------------

Line 2041: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2037: x_msg_count,
2038: x_msg_data,
2039: l_aav_rec
2040: );
2041: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2043: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;

Line 2042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2038: x_msg_data,
2039: l_aav_rec
2040: );
2041: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2043: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;
2046: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2043: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2039: l_aav_rec
2040: );
2041: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2043: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;
2046: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2047: EXCEPTION

Line 2044: RAISE OKC_API.G_EXCEPTION_ERROR;

2040: );
2041: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2043: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;
2046: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2047: EXCEPTION
2048: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2046: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2043: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;
2046: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2047: EXCEPTION
2048: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2049: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2050: (

Line 2048: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;
2046: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2047: EXCEPTION
2048: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2049: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2050: (
2051: l_api_name,
2052: G_PKG_NAME,

Line 2049: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2045: END IF;
2046: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2047: EXCEPTION
2048: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2049: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2050: (
2051: l_api_name,
2052: G_PKG_NAME,
2053: 'OKC_API.G_RET_STS_ERROR',

Line 2053: 'OKC_API.G_RET_STS_ERROR',

2049: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2050: (
2051: l_api_name,
2052: G_PKG_NAME,
2053: 'OKC_API.G_RET_STS_ERROR',
2054: x_msg_count,
2055: x_msg_data,
2056: '_PVT'
2057: );

Line 2058: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2054: x_msg_count,
2055: x_msg_data,
2056: '_PVT'
2057: );
2058: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2059: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2060: (
2061: l_api_name,
2062: G_PKG_NAME,

Line 2059: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2055: x_msg_data,
2056: '_PVT'
2057: );
2058: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2059: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2060: (
2061: l_api_name,
2062: G_PKG_NAME,
2063: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2063: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2059: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2060: (
2061: l_api_name,
2062: G_PKG_NAME,
2063: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2064: x_msg_count,
2065: x_msg_data,
2066: '_PVT'
2067: );

Line 2069: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2065: x_msg_data,
2066: '_PVT'
2067: );
2068: WHEN OTHERS THEN
2069: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2070: (
2071: l_api_name,
2072: G_PKG_NAME,
2073: 'OTHERS',

Line 2092: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2088: p_aavv_tbl IN aavv_tbl_type) IS
2089:
2090: l_api_version CONSTANT NUMBER := 1;
2091: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2092: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2093: i NUMBER := 0;
2094: BEGIN
2095: OKC_API.init_msg_list(p_init_msg_list);
2096: -- Make sure PL/SQL table has records in it before passing

Line 2095: OKC_API.init_msg_list(p_init_msg_list);

2091: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2092: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2093: i NUMBER := 0;
2094: BEGIN
2095: OKC_API.init_msg_list(p_init_msg_list);
2096: -- Make sure PL/SQL table has records in it before passing
2097: IF (p_aavv_tbl.COUNT > 0) THEN
2098: i := p_aavv_tbl.FIRST;
2099: LOOP

Line 2102: p_init_msg_list => OKC_API.G_FALSE,

2098: i := p_aavv_tbl.FIRST;
2099: LOOP
2100: delete_row (
2101: p_api_version => p_api_version,
2102: p_init_msg_list => OKC_API.G_FALSE,
2103: x_return_status => x_return_status,
2104: x_msg_count => x_msg_count,
2105: x_msg_data => x_msg_data,
2106: p_aavv_rec => p_aavv_tbl(i));

Line 2112: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2108: i := p_aavv_tbl.NEXT(i);
2109: END LOOP;
2110: END IF;
2111: EXCEPTION
2112: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2113: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2114: (
2115: l_api_name,
2116: G_PKG_NAME,

Line 2113: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2109: END LOOP;
2110: END IF;
2111: EXCEPTION
2112: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2113: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2114: (
2115: l_api_name,
2116: G_PKG_NAME,
2117: 'OKC_API.G_RET_STS_ERROR',

Line 2117: 'OKC_API.G_RET_STS_ERROR',

2113: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2114: (
2115: l_api_name,
2116: G_PKG_NAME,
2117: 'OKC_API.G_RET_STS_ERROR',
2118: x_msg_count,
2119: x_msg_data,
2120: '_PVT'
2121: );

Line 2122: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2118: x_msg_count,
2119: x_msg_data,
2120: '_PVT'
2121: );
2122: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2123: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2124: (
2125: l_api_name,
2126: G_PKG_NAME,

Line 2123: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2119: x_msg_data,
2120: '_PVT'
2121: );
2122: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2123: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2124: (
2125: l_api_name,
2126: G_PKG_NAME,
2127: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2127: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2123: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2124: (
2125: l_api_name,
2126: G_PKG_NAME,
2127: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2128: x_msg_count,
2129: x_msg_data,
2130: '_PVT'
2131: );

Line 2133: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2129: x_msg_data,
2130: '_PVT'
2131: );
2132: WHEN OTHERS THEN
2133: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2134: (
2135: l_api_name,
2136: G_PKG_NAME,
2137: 'OTHERS',

Line 2162: x_return_status := OKC_API.G_RET_STS_ERROR;

2158: in_last_update_login OKC_DATATYPES.NumberTabTyp;
2159: j NUMBER := 0;
2160: i NUMBER := p_aavv_tbl.FIRST;
2161: BEGIN
2162: x_return_status := OKC_API.G_RET_STS_ERROR;
2163: -- Initializing the Return Status
2164:
2165: while i is not null
2166: LOOP

Line 2209: OKC_API.SET_MESSAGE(

2205:
2206: EXCEPTION
2207: WHEN OTHERS THEN
2208: -- store SQL error message on message stack
2209: OKC_API.SET_MESSAGE(
2210: p_app_name => G_APP_NAME,
2211: p_msg_name => G_UNEXPECTED_ERROR,
2212: p_token1 => G_SQLCODE_TOKEN,
2213: p_token1_value => SQLCODE,

Line 2217: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2213: p_token1_value => SQLCODE,
2214: p_token2 => G_SQLERRM_TOKEN,
2215: p_token2_value => SQLERRM);
2216: -- notify caller of an error as UNEXPETED error
2217: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2218: -- RAISE;
2219: END INSERT_ROW_UPG;
2220: END OKC_AAV_PVT;