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_SAI_PVT dependencies on OKC_API

Line 144: IF (l_saiv_rec.sae_id = OKC_API.G_MISS_NUM) THEN

140: p_saiv_rec IN saiv_rec_type
141: ) RETURN saiv_rec_type IS
142: l_saiv_rec saiv_rec_type := p_saiv_rec;
143: BEGIN
144: IF (l_saiv_rec.sae_id = OKC_API.G_MISS_NUM) THEN
145: l_saiv_rec.sae_id := NULL;
146: END IF;
147: IF (l_saiv_rec.sae_id_for = OKC_API.G_MISS_NUM) THEN
148: l_saiv_rec.sae_id_for := NULL;

Line 147: IF (l_saiv_rec.sae_id_for = OKC_API.G_MISS_NUM) THEN

143: BEGIN
144: IF (l_saiv_rec.sae_id = OKC_API.G_MISS_NUM) THEN
145: l_saiv_rec.sae_id := NULL;
146: END IF;
147: IF (l_saiv_rec.sae_id_for = OKC_API.G_MISS_NUM) THEN
148: l_saiv_rec.sae_id_for := NULL;
149: END IF;
150: IF (l_saiv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
151: l_saiv_rec.object_version_number := NULL;

Line 150: IF (l_saiv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

146: END IF;
147: IF (l_saiv_rec.sae_id_for = OKC_API.G_MISS_NUM) THEN
148: l_saiv_rec.sae_id_for := NULL;
149: END IF;
150: IF (l_saiv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
151: l_saiv_rec.object_version_number := NULL;
152: END IF;
153: IF (l_saiv_rec.created_by = OKC_API.G_MISS_NUM) THEN
154: l_saiv_rec.created_by := NULL;

Line 153: IF (l_saiv_rec.created_by = OKC_API.G_MISS_NUM) THEN

149: END IF;
150: IF (l_saiv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
151: l_saiv_rec.object_version_number := NULL;
152: END IF;
153: IF (l_saiv_rec.created_by = OKC_API.G_MISS_NUM) THEN
154: l_saiv_rec.created_by := NULL;
155: END IF;
156: IF (l_saiv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
157: l_saiv_rec.creation_date := NULL;

Line 156: IF (l_saiv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

152: END IF;
153: IF (l_saiv_rec.created_by = OKC_API.G_MISS_NUM) THEN
154: l_saiv_rec.created_by := NULL;
155: END IF;
156: IF (l_saiv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
157: l_saiv_rec.creation_date := NULL;
158: END IF;
159: IF (l_saiv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
160: l_saiv_rec.last_updated_by := NULL;

Line 159: IF (l_saiv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

155: END IF;
156: IF (l_saiv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
157: l_saiv_rec.creation_date := NULL;
158: END IF;
159: IF (l_saiv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
160: l_saiv_rec.last_updated_by := NULL;
161: END IF;
162: IF (l_saiv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
163: l_saiv_rec.last_update_date := NULL;

Line 162: IF (l_saiv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

158: END IF;
159: IF (l_saiv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
160: l_saiv_rec.last_updated_by := NULL;
161: END IF;
162: IF (l_saiv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
163: l_saiv_rec.last_update_date := NULL;
164: END IF;
165: IF (l_saiv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
166: l_saiv_rec.last_update_login := NULL;

Line 165: IF (l_saiv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

161: END IF;
162: IF (l_saiv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
163: l_saiv_rec.last_update_date := NULL;
164: END IF;
165: IF (l_saiv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
166: l_saiv_rec.last_update_login := NULL;
167: END IF;
168: RETURN(l_saiv_rec);
169: END null_out_defaults;

Line 199: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

195: l_row_found BOOLEAN := FALSE;
196: l_dummy VARCHAR2(1);
197:
198: BEGIN
199: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
200:
201: -- ---------------------------------------------------------------------
202: -- Bug 1636056 related changes - Shyam
203: -- OKC_UTIL.check_comp_unique call is replaced with

Line 208: AND (p_saiv_rec.sae_id <> OKC_API.G_MISS_NUM) )

204: -- the explicit cursors above, for identical function to
205: -- check uniqueness for SAE_ID + SAE_ID_FOR in OKC_STD_ART_INCMPTS_V
206: -- ---------------------------------------------------------------------
207: IF ( (p_saiv_rec.sae_id IS NOT NULL)
208: AND (p_saiv_rec.sae_id <> OKC_API.G_MISS_NUM) )
209: AND
210: ( (p_saiv_rec.sae_id_for IS NOT NULL)
211: AND (p_saiv_rec.sae_id_for <> OKC_API.G_MISS_NUM) )
212: THEN

Line 211: AND (p_saiv_rec.sae_id_for <> OKC_API.G_MISS_NUM) )

207: IF ( (p_saiv_rec.sae_id IS NOT NULL)
208: AND (p_saiv_rec.sae_id <> OKC_API.G_MISS_NUM) )
209: AND
210: ( (p_saiv_rec.sae_id_for IS NOT NULL)
211: AND (p_saiv_rec.sae_id_for <> OKC_API.G_MISS_NUM) )
212: THEN
213: OPEN cur_sae;
214: FETCH cur_sae INTO l_dummy;
215: l_row_found := cur_sae%FOUND;

Line 221: OKC_API.set_message(G_APP_NAME,

217:
218: IF (l_row_found)
219: THEN
220: -- Display the newly defined error message
221: OKC_API.set_message(G_APP_NAME,
222: 'OKC_DUP_SAE_ID');
223: x_return_status := OKC_API.G_RET_STS_ERROR;
224: END IF;
225: END IF;

Line 223: x_return_status := OKC_API.G_RET_STS_ERROR;

219: THEN
220: -- Display the newly defined error message
221: OKC_API.set_message(G_APP_NAME,
222: 'OKC_DUP_SAE_ID');
223: x_return_status := OKC_API.G_RET_STS_ERROR;
224: END IF;
225: END IF;
226:
227: EXCEPTION

Line 231: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

227: EXCEPTION
228: WHEN OTHERS THEN
229: -- other appropriate handlers
230: -- store SQL error message on message stack
231: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
232: p_msg_name => G_UNEXPECTED_ERROR,
233: p_token1 => G_SQLCODE_TOKEN,
234: p_token1_value => sqlcode,
235: p_token2 => G_SQLERRM_TOKEN,

Line 239: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

235: p_token2 => G_SQLERRM_TOKEN,
236: p_token2_value => sqlerrm);
237:
238: -- notify UNEXPECTED error
239: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
240: END validate_unique;
241:
242: -- Start of comments
243: -- Procedure Name : validate_Object_Version_number

Line 253: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

249: procedure validate_Object_Version_Number(p_saiv_rec IN saiv_rec_type,
250: x_return_status OUT NOCOPY VARCHAR2) is
251:
252: BEGIN
253: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
254: --check not null
255: If (p_saiv_rec.object_version_number is null) OR (p_saiv_rec.object_version_number=OKC_API.G_MISS_NUM) then
256: x_return_status:=OKC_API.G_RET_STS_ERROR;
257: --set error message in message stack

Line 255: If (p_saiv_rec.object_version_number is null) OR (p_saiv_rec.object_version_number=OKC_API.G_MISS_NUM) then

251:
252: BEGIN
253: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
254: --check not null
255: If (p_saiv_rec.object_version_number is null) OR (p_saiv_rec.object_version_number=OKC_API.G_MISS_NUM) then
256: x_return_status:=OKC_API.G_RET_STS_ERROR;
257: --set error message in message stack
258: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
259: p_msg_name => G_REQUIRED_VALUE,

Line 256: x_return_status:=OKC_API.G_RET_STS_ERROR;

252: BEGIN
253: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
254: --check not null
255: If (p_saiv_rec.object_version_number is null) OR (p_saiv_rec.object_version_number=OKC_API.G_MISS_NUM) then
256: x_return_status:=OKC_API.G_RET_STS_ERROR;
257: --set error message in message stack
258: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
259: p_msg_name => G_REQUIRED_VALUE,
260: p_token1 => G_COL_NAME_TOKEN,

Line 258: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

254: --check not null
255: If (p_saiv_rec.object_version_number is null) OR (p_saiv_rec.object_version_number=OKC_API.G_MISS_NUM) then
256: x_return_status:=OKC_API.G_RET_STS_ERROR;
257: --set error message in message stack
258: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
259: p_msg_name => G_REQUIRED_VALUE,
260: p_token1 => G_COL_NAME_TOKEN,
261: p_token1_value => 'OBJECT_VERSION_NUMBER');
262: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 273: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

269: null;
270: -- other appropriate handlers
271: When others then
272: -- store SQL error message on message stack
273: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
274: p_msg_name => G_UNEXPECTED_ERROR,
275: p_token1 => G_SQLCODE_TOKEN,
276: p_token1_value => sqlcode,
277: p_token2 => G_SQLERRM_TOKEN,

Line 281: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

277: p_token2 => G_SQLERRM_TOKEN,
278: p_token2_value => sqlerrm);
279:
280: -- notify UNEXPECTED error
281: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
282:
283: END validate_object_version_number;
284:
285:

Line 302: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

298: WHERE sae.id = p_saiv_rec.sae_id;
299: l_dummy_var VARCHAR2(1):='0';
300:
301: BEGIN
302: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
303: --check not null
304: If (p_saiv_rec.sae_id is null) OR (p_saiv_rec.sae_id=OKC_API.G_MISS_NUM) then
305: x_return_status:=OKC_API.G_RET_STS_ERROR;
306: --set error message in message stack

Line 304: If (p_saiv_rec.sae_id is null) OR (p_saiv_rec.sae_id=OKC_API.G_MISS_NUM) then

300:
301: BEGIN
302: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
303: --check not null
304: If (p_saiv_rec.sae_id is null) OR (p_saiv_rec.sae_id=OKC_API.G_MISS_NUM) then
305: x_return_status:=OKC_API.G_RET_STS_ERROR;
306: --set error message in message stack
307: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
308: p_msg_name => G_REQUIRED_VALUE,

Line 305: x_return_status:=OKC_API.G_RET_STS_ERROR;

301: BEGIN
302: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
303: --check not null
304: If (p_saiv_rec.sae_id is null) OR (p_saiv_rec.sae_id=OKC_API.G_MISS_NUM) then
305: x_return_status:=OKC_API.G_RET_STS_ERROR;
306: --set error message in message stack
307: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
308: p_msg_name => G_REQUIRED_VALUE,
309: p_token1 => G_COL_NAME_TOKEN,

Line 307: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

303: --check not null
304: If (p_saiv_rec.sae_id is null) OR (p_saiv_rec.sae_id=OKC_API.G_MISS_NUM) then
305: x_return_status:=OKC_API.G_RET_STS_ERROR;
306: --set error message in message stack
307: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
308: p_msg_name => G_REQUIRED_VALUE,
309: p_token1 => G_COL_NAME_TOKEN,
310: p_token1_value => 'SAE_ID');
311: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 321: x_return_status:= OKC_API.G_RET_STS_ERROR;

317: CLOSE l_sae_id_csr;
318: IF (l_dummy_var<>'1') Then
319:
320: --Corresponding Column value not found
321: x_return_status:= OKC_API.G_RET_STS_ERROR;
322: --set error message in message stack
323: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
324: p_msg_name => G_NO_PARENT_RECORD,
325: p_token1 => G_COL_NAME_TOKEN,

Line 323: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

319:
320: --Corresponding Column value not found
321: x_return_status:= OKC_API.G_RET_STS_ERROR;
322: --set error message in message stack
323: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
324: p_msg_name => G_NO_PARENT_RECORD,
325: p_token1 => G_COL_NAME_TOKEN,
326: p_token1_value => 'SAE_ID',
327: p_token2 => G_CHILD_TABLE_TOKEN,

Line 343: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

339: null;
340: -- other appropriate handlers
341: When others then
342: -- store SQL error message on message stack
343: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
344: p_msg_name => G_UNEXPECTED_ERROR,
345: p_token1 => G_SQLCODE_TOKEN,
346: p_token1_value => sqlcode,
347: p_token2 => G_SQLERRM_TOKEN,

Line 351: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

347: p_token2 => G_SQLERRM_TOKEN,
348: p_token2_value => sqlerrm);
349:
350: -- notify UNEXPECTED error
351: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
352:
353: END validate_sae_id;
354:
355: -- Start of comments

Line 371: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

367: WHERE sae.id = p_saiv_rec.sae_id_for;
368: l_dummy_var VARCHAR2(1):='0';
369:
370: BEGIN
371: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
372: --check not null
373: If (p_saiv_rec.sae_id_for is null) OR (p_saiv_rec.sae_id_for=OKC_API.G_MISS_NUM) then
374: x_return_status:=OKC_API.G_RET_STS_ERROR;
375: --set error message in message stack

Line 373: If (p_saiv_rec.sae_id_for is null) OR (p_saiv_rec.sae_id_for=OKC_API.G_MISS_NUM) then

369:
370: BEGIN
371: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
372: --check not null
373: If (p_saiv_rec.sae_id_for is null) OR (p_saiv_rec.sae_id_for=OKC_API.G_MISS_NUM) then
374: x_return_status:=OKC_API.G_RET_STS_ERROR;
375: --set error message in message stack
376: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
377: p_msg_name => G_REQUIRED_VALUE,

Line 374: x_return_status:=OKC_API.G_RET_STS_ERROR;

370: BEGIN
371: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
372: --check not null
373: If (p_saiv_rec.sae_id_for is null) OR (p_saiv_rec.sae_id_for=OKC_API.G_MISS_NUM) then
374: x_return_status:=OKC_API.G_RET_STS_ERROR;
375: --set error message in message stack
376: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
377: p_msg_name => G_REQUIRED_VALUE,
378: p_token1 => G_COL_NAME_TOKEN,

Line 376: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

372: --check not null
373: If (p_saiv_rec.sae_id_for is null) OR (p_saiv_rec.sae_id_for=OKC_API.G_MISS_NUM) then
374: x_return_status:=OKC_API.G_RET_STS_ERROR;
375: --set error message in message stack
376: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
377: p_msg_name => G_REQUIRED_VALUE,
378: p_token1 => G_COL_NAME_TOKEN,
379: p_token1_value => 'SAE_ID_FOR');
380: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 390: x_return_status:= OKC_API.G_RET_STS_ERROR;

386: CLOSE l_sae_id_csr;
387: IF (l_dummy_var<>'1') Then
388:
389: --Corresponding Column value not found
390: x_return_status:= OKC_API.G_RET_STS_ERROR;
391: --set error message in message stack
392: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
393: p_msg_name => G_NO_PARENT_RECORD,
394: p_token1 => G_COL_NAME_TOKEN,

Line 392: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

388:
389: --Corresponding Column value not found
390: x_return_status:= OKC_API.G_RET_STS_ERROR;
391: --set error message in message stack
392: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
393: p_msg_name => G_NO_PARENT_RECORD,
394: p_token1 => G_COL_NAME_TOKEN,
395: p_token1_value => 'SAE_ID_FOR',
396: p_token2 => G_CHILD_TABLE_TOKEN,

Line 410: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

406: null;
407: -- other appropriate handlers
408: When others then
409: -- store SQL error message on message stack
410: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
411: p_msg_name => G_UNEXPECTED_ERROR,
412: p_token1 => G_SQLCODE_TOKEN,
413: p_token1_value => sqlcode,
414: p_token2 => G_SQLERRM_TOKEN,

Line 418: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

414: p_token2 => G_SQLERRM_TOKEN,
415: p_token2_value => sqlerrm);
416:
417: -- notify UNEXPECTED error
418: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
419:
420: END validate_sae_id_for;
421:
422: ---------------------------------------------------------------------------

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

427: ------------------------------------------------
428: FUNCTION Validate_Attributes (
429: p_saiv_rec IN saiv_rec_type
430: ) RETURN VARCHAR2 IS
431: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
432: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
433: BEGIN
434:
435:

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

428: FUNCTION Validate_Attributes (
429: p_saiv_rec IN saiv_rec_type
430: ) RETURN VARCHAR2 IS
431: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
432: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
433: BEGIN
434:
435:
436: validate_object_version_number(p_saiv_rec,x_return_status);

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

433: BEGIN
434:
435:
436: validate_object_version_number(p_saiv_rec,x_return_status);
437: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
439: l_return_status := x_return_status;
440: RAISE G_EXCEPTION_HALT_VALIDATION;
441: ELSE

Line 438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

434:
435:
436: validate_object_version_number(p_saiv_rec,x_return_status);
437: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
439: l_return_status := x_return_status;
440: RAISE G_EXCEPTION_HALT_VALIDATION;
441: ELSE
442: l_return_status := x_return_status; -- record that there was an error

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

444: END IF;
445:
446:
447: validate_sae_id(p_saiv_rec,x_return_status);
448: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
449: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
450: l_return_status := x_return_status;
451: RAISE G_EXCEPTION_HALT_VALIDATION;
452: ELSE

Line 449: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

445:
446:
447: validate_sae_id(p_saiv_rec,x_return_status);
448: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
449: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
450: l_return_status := x_return_status;
451: RAISE G_EXCEPTION_HALT_VALIDATION;
452: ELSE
453: l_return_status := x_return_status; -- record that there was an error

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

454: END IF;
455: END IF;
456:
457: validate_sae_id_for(p_saiv_rec,x_return_status);
458: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
459: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
460: l_return_status := x_return_status;
461: RAISE G_EXCEPTION_HALT_VALIDATION;
462: ELSE

Line 459: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

455: END IF;
456:
457: validate_sae_id_for(p_saiv_rec,x_return_status);
458: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
459: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
460: l_return_status := x_return_status;
461: RAISE G_EXCEPTION_HALT_VALIDATION;
462: ELSE
463: l_return_status := x_return_status; -- record that there was an error

Line 475: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

471: RETURN(l_return_status);
472: -- other appropriate handlers
473: When others then
474: -- store SQL error message on message stack
475: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
476: p_msg_name => G_UNEXPECTED_ERROR,
477: p_token1 => G_SQLCODE_TOKEN,
478: p_token1_value => sqlcode,
479: p_token2 => G_SQLERRM_TOKEN,

Line 483: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

479: p_token2 => G_SQLERRM_TOKEN,
480: p_token2_value => sqlerrm);
481:
482: -- notify UNEXPECTED error
483: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
484: RETURN(l_return_status);
485: END Validate_Attributes;
486:
487:

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

494: -------------------------------------------------
495: FUNCTION Validate_Record (
496: p_saiv_rec IN saiv_rec_type
497: ) RETURN VARCHAR2 IS
498: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
499: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
500: l_unq OKC_UTIL.unq_tbl_type;
501: BEGIN
502: l_return_status:=OKC_API.G_RET_STS_SUCCESS;

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

495: FUNCTION Validate_Record (
496: p_saiv_rec IN saiv_rec_type
497: ) RETURN VARCHAR2 IS
498: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
499: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
500: l_unq OKC_UTIL.unq_tbl_type;
501: BEGIN
502: l_return_status:=OKC_API.G_RET_STS_SUCCESS;
503: --check that sae_id and sae_id_for are not same

Line 502: l_return_status:=OKC_API.G_RET_STS_SUCCESS;

498: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
499: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
500: l_unq OKC_UTIL.unq_tbl_type;
501: BEGIN
502: l_return_status:=OKC_API.G_RET_STS_SUCCESS;
503: --check that sae_id and sae_id_for are not same
504: IF (p_saiv_rec.sae_id=p_saiv_rec.sae_id_for)
505: THEN
506: l_return_status:=OKC_API.G_RET_STS_ERROR;

Line 506: l_return_status:=OKC_API.G_RET_STS_ERROR;

502: l_return_status:=OKC_API.G_RET_STS_SUCCESS;
503: --check that sae_id and sae_id_for are not same
504: IF (p_saiv_rec.sae_id=p_saiv_rec.sae_id_for)
505: THEN
506: l_return_status:=OKC_API.G_RET_STS_ERROR;
507: --set error message in message stack
508: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
509: p_msg_name => G_NOT_SAME);
510:

Line 508: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

504: IF (p_saiv_rec.sae_id=p_saiv_rec.sae_id_for)
505: THEN
506: l_return_status:=OKC_API.G_RET_STS_ERROR;
507: --set error message in message stack
508: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
509: p_msg_name => G_NOT_SAME);
510:
511: END IF;
512:

Line 522: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

518: RETURN (l_return_status);
519: -- other appropriate handlers
520: When others then
521: -- store SQL error message on message stack
522: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
523: p_msg_name => G_UNEXPECTED_ERROR,
524: p_token1 => G_SQLCODE_TOKEN,
525: p_token1_value => sqlcode,
526: p_token2 => G_SQLERRM_TOKEN,

Line 530: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

526: p_token2 => G_SQLERRM_TOKEN,
527: p_token2_value => sqlerrm);
528:
529: -- notify UNEXPECTED error
530: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
531: RETURN (l_return_status);
532: END Validate_Record;
533: /****************END ADDED AFTER TAPI**************/
534:

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

581: p_saiv_rec IN saiv_rec_type) IS
582:
583: l_api_version CONSTANT NUMBER := 1;
584: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
585: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
586: l_saiv_rec saiv_rec_type := p_saiv_rec;
587: l_sai_rec sai_rec_type;
588: BEGIN
589: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

585: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
586: l_saiv_rec saiv_rec_type := p_saiv_rec;
587: l_sai_rec sai_rec_type;
588: BEGIN
589: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
590: G_PKG_NAME,
591: p_init_msg_list,
592: l_api_version,
593: p_api_version,

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

592: l_api_version,
593: p_api_version,
594: '_PVT',
595: x_return_status);
596: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
597: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
598: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
599: RAISE OKC_API.G_EXCEPTION_ERROR;
600: END IF;

Line 597: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

593: p_api_version,
594: '_PVT',
595: x_return_status);
596: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
597: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
598: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
599: RAISE OKC_API.G_EXCEPTION_ERROR;
600: END IF;
601: --- Validate all non-missing attributes (Item Level Validation)

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

594: '_PVT',
595: x_return_status);
596: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
597: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
598: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
599: RAISE OKC_API.G_EXCEPTION_ERROR;
600: END IF;
601: --- Validate all non-missing attributes (Item Level Validation)
602: l_return_status := Validate_Attributes(l_saiv_rec);

Line 599: RAISE OKC_API.G_EXCEPTION_ERROR;

595: x_return_status);
596: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
597: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
598: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
599: RAISE OKC_API.G_EXCEPTION_ERROR;
600: END IF;
601: --- Validate all non-missing attributes (Item Level Validation)
602: l_return_status := Validate_Attributes(l_saiv_rec);
603: --- If any errors happen abort API

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

600: END IF;
601: --- Validate all non-missing attributes (Item Level Validation)
602: l_return_status := Validate_Attributes(l_saiv_rec);
603: --- If any errors happen abort API
604: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
607: RAISE OKC_API.G_EXCEPTION_ERROR;
608: END IF;

Line 605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

601: --- Validate all non-missing attributes (Item Level Validation)
602: l_return_status := Validate_Attributes(l_saiv_rec);
603: --- If any errors happen abort API
604: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
607: RAISE OKC_API.G_EXCEPTION_ERROR;
608: END IF;
609: l_return_status := Validate_Record(l_saiv_rec);

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

602: l_return_status := Validate_Attributes(l_saiv_rec);
603: --- If any errors happen abort API
604: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
607: RAISE OKC_API.G_EXCEPTION_ERROR;
608: END IF;
609: l_return_status := Validate_Record(l_saiv_rec);
610: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 607: RAISE OKC_API.G_EXCEPTION_ERROR;

603: --- If any errors happen abort API
604: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
607: RAISE OKC_API.G_EXCEPTION_ERROR;
608: END IF;
609: l_return_status := Validate_Record(l_saiv_rec);
610: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

606: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
607: RAISE OKC_API.G_EXCEPTION_ERROR;
608: END IF;
609: l_return_status := Validate_Record(l_saiv_rec);
610: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
613: RAISE OKC_API.G_EXCEPTION_ERROR;
614: END IF;

Line 611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

607: RAISE OKC_API.G_EXCEPTION_ERROR;
608: END IF;
609: l_return_status := Validate_Record(l_saiv_rec);
610: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
613: RAISE OKC_API.G_EXCEPTION_ERROR;
614: END IF;
615: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

608: END IF;
609: l_return_status := Validate_Record(l_saiv_rec);
610: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
613: RAISE OKC_API.G_EXCEPTION_ERROR;
614: END IF;
615: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
616: EXCEPTION

Line 613: RAISE OKC_API.G_EXCEPTION_ERROR;

609: l_return_status := Validate_Record(l_saiv_rec);
610: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
613: RAISE OKC_API.G_EXCEPTION_ERROR;
614: END IF;
615: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
616: EXCEPTION
617: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

611: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
613: RAISE OKC_API.G_EXCEPTION_ERROR;
614: END IF;
615: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
616: EXCEPTION
617: WHEN OKC_API.G_EXCEPTION_ERROR THEN
618: x_return_status := OKC_API.HANDLE_EXCEPTIONS
619: (

Line 617: WHEN OKC_API.G_EXCEPTION_ERROR THEN

613: RAISE OKC_API.G_EXCEPTION_ERROR;
614: END IF;
615: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
616: EXCEPTION
617: WHEN OKC_API.G_EXCEPTION_ERROR THEN
618: x_return_status := OKC_API.HANDLE_EXCEPTIONS
619: (
620: l_api_name,
621: G_PKG_NAME,

Line 618: x_return_status := OKC_API.HANDLE_EXCEPTIONS

614: END IF;
615: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
616: EXCEPTION
617: WHEN OKC_API.G_EXCEPTION_ERROR THEN
618: x_return_status := OKC_API.HANDLE_EXCEPTIONS
619: (
620: l_api_name,
621: G_PKG_NAME,
622: 'OKC_API.G_RET_STS_ERROR',

Line 622: 'OKC_API.G_RET_STS_ERROR',

618: x_return_status := OKC_API.HANDLE_EXCEPTIONS
619: (
620: l_api_name,
621: G_PKG_NAME,
622: 'OKC_API.G_RET_STS_ERROR',
623: x_msg_count,
624: x_msg_data,
625: '_PVT'
626: );

Line 627: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

623: x_msg_count,
624: x_msg_data,
625: '_PVT'
626: );
627: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
628: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
629: (
630: l_api_name,
631: G_PKG_NAME,

Line 628: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

624: x_msg_data,
625: '_PVT'
626: );
627: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
628: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
629: (
630: l_api_name,
631: G_PKG_NAME,
632: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 632: 'OKC_API.G_RET_STS_UNEXP_ERROR',

628: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
629: (
630: l_api_name,
631: G_PKG_NAME,
632: 'OKC_API.G_RET_STS_UNEXP_ERROR',
633: x_msg_count,
634: x_msg_data,
635: '_PVT'
636: );

Line 638: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

634: x_msg_data,
635: '_PVT'
636: );
637: WHEN OTHERS THEN
638: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
639: (
640: l_api_name,
641: G_PKG_NAME,
642: 'OTHERS',

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

657: p_saiv_tbl IN saiv_tbl_type) IS
658:
659: l_api_version CONSTANT NUMBER := 1;
660: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
661: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
662: i NUMBER := 0;
663: BEGIN
664: -- Make sure PL/SQL table has records in it before passing
665: IF (p_saiv_tbl.COUNT > 0) THEN

Line 680: WHEN OKC_API.G_EXCEPTION_ERROR THEN

676: i := p_saiv_tbl.NEXT(i);
677: END LOOP;
678: END IF;
679: EXCEPTION
680: WHEN OKC_API.G_EXCEPTION_ERROR THEN
681: x_return_status := OKC_API.HANDLE_EXCEPTIONS
682: (
683: l_api_name,
684: G_PKG_NAME,

Line 681: x_return_status := OKC_API.HANDLE_EXCEPTIONS

677: END LOOP;
678: END IF;
679: EXCEPTION
680: WHEN OKC_API.G_EXCEPTION_ERROR THEN
681: x_return_status := OKC_API.HANDLE_EXCEPTIONS
682: (
683: l_api_name,
684: G_PKG_NAME,
685: 'OKC_API.G_RET_STS_ERROR',

Line 685: 'OKC_API.G_RET_STS_ERROR',

681: x_return_status := OKC_API.HANDLE_EXCEPTIONS
682: (
683: l_api_name,
684: G_PKG_NAME,
685: 'OKC_API.G_RET_STS_ERROR',
686: x_msg_count,
687: x_msg_data,
688: '_PVT'
689: );

Line 690: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

686: x_msg_count,
687: x_msg_data,
688: '_PVT'
689: );
690: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
691: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
692: (
693: l_api_name,
694: G_PKG_NAME,

Line 691: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

687: x_msg_data,
688: '_PVT'
689: );
690: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
691: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
692: (
693: l_api_name,
694: G_PKG_NAME,
695: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 695: 'OKC_API.G_RET_STS_UNEXP_ERROR',

691: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
692: (
693: l_api_name,
694: G_PKG_NAME,
695: 'OKC_API.G_RET_STS_UNEXP_ERROR',
696: x_msg_count,
697: x_msg_data,
698: '_PVT'
699: );

Line 701: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

697: x_msg_data,
698: '_PVT'
699: );
700: WHEN OTHERS THEN
701: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
702: (
703: l_api_name,
704: G_PKG_NAME,
705: 'OTHERS',

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

724: x_sai_rec OUT NOCOPY sai_rec_type) IS
725:
726: l_api_version CONSTANT NUMBER := 1;
727: l_api_name CONSTANT VARCHAR2(30) := 'INCMPTS_insert_row';
728: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
729: l_sai_rec sai_rec_type := p_sai_rec;
730: l_def_sai_rec sai_rec_type;
731: --------------------------------------------
732: -- Set_Attributes for:OKC_STD_ART_INCMPTS --

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

734: FUNCTION Set_Attributes (
735: p_sai_rec IN sai_rec_type,
736: x_sai_rec OUT NOCOPY sai_rec_type
737: ) RETURN VARCHAR2 IS
738: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
739: BEGIN
740: x_sai_rec := p_sai_rec;
741: RETURN(l_return_status);
742: END Set_Attributes;

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

740: x_sai_rec := p_sai_rec;
741: RETURN(l_return_status);
742: END Set_Attributes;
743: BEGIN
744: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
745: p_init_msg_list,
746: '_PVT',
747: x_return_status);
748: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

744: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
745: p_init_msg_list,
746: '_PVT',
747: x_return_status);
748: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
749: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
750: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
751: RAISE OKC_API.G_EXCEPTION_ERROR;
752: END IF;

Line 749: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

745: p_init_msg_list,
746: '_PVT',
747: x_return_status);
748: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
749: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
750: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
751: RAISE OKC_API.G_EXCEPTION_ERROR;
752: END IF;
753: --- Setting item attributes

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

746: '_PVT',
747: x_return_status);
748: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
749: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
750: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
751: RAISE OKC_API.G_EXCEPTION_ERROR;
752: END IF;
753: --- Setting item attributes
754: l_return_status := Set_Attributes(

Line 751: RAISE OKC_API.G_EXCEPTION_ERROR;

747: x_return_status);
748: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
749: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
750: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
751: RAISE OKC_API.G_EXCEPTION_ERROR;
752: END IF;
753: --- Setting item attributes
754: l_return_status := Set_Attributes(
755: p_sai_rec, -- IN

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

754: l_return_status := Set_Attributes(
755: p_sai_rec, -- IN
756: l_sai_rec); -- OUT
757: --- If any errors happen abort API
758: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
760: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
761: RAISE OKC_API.G_EXCEPTION_ERROR;
762: END IF;

Line 759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

755: p_sai_rec, -- IN
756: l_sai_rec); -- OUT
757: --- If any errors happen abort API
758: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
760: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
761: RAISE OKC_API.G_EXCEPTION_ERROR;
762: END IF;
763: INSERT INTO OKC_STD_ART_INCMPTS(

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

756: l_sai_rec); -- OUT
757: --- If any errors happen abort API
758: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
760: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
761: RAISE OKC_API.G_EXCEPTION_ERROR;
762: END IF;
763: INSERT INTO OKC_STD_ART_INCMPTS(
764: sae_id,

Line 761: RAISE OKC_API.G_EXCEPTION_ERROR;

757: --- If any errors happen abort API
758: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
760: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
761: RAISE OKC_API.G_EXCEPTION_ERROR;
762: END IF;
763: INSERT INTO OKC_STD_ART_INCMPTS(
764: sae_id,
765: sae_id_for,

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

779: l_sai_rec.last_update_date,
780: l_sai_rec.last_update_login);
781: -- Set OUT values
782: x_sai_rec := l_sai_rec;
783: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
784: EXCEPTION
785: WHEN OKC_API.G_EXCEPTION_ERROR THEN
786: x_return_status := OKC_API.HANDLE_EXCEPTIONS
787: (

Line 785: WHEN OKC_API.G_EXCEPTION_ERROR THEN

781: -- Set OUT values
782: x_sai_rec := l_sai_rec;
783: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
784: EXCEPTION
785: WHEN OKC_API.G_EXCEPTION_ERROR THEN
786: x_return_status := OKC_API.HANDLE_EXCEPTIONS
787: (
788: l_api_name,
789: G_PKG_NAME,

Line 786: x_return_status := OKC_API.HANDLE_EXCEPTIONS

782: x_sai_rec := l_sai_rec;
783: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
784: EXCEPTION
785: WHEN OKC_API.G_EXCEPTION_ERROR THEN
786: x_return_status := OKC_API.HANDLE_EXCEPTIONS
787: (
788: l_api_name,
789: G_PKG_NAME,
790: 'OKC_API.G_RET_STS_ERROR',

Line 790: 'OKC_API.G_RET_STS_ERROR',

786: x_return_status := OKC_API.HANDLE_EXCEPTIONS
787: (
788: l_api_name,
789: G_PKG_NAME,
790: 'OKC_API.G_RET_STS_ERROR',
791: x_msg_count,
792: x_msg_data,
793: '_PVT'
794: );

Line 795: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

791: x_msg_count,
792: x_msg_data,
793: '_PVT'
794: );
795: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
796: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
797: (
798: l_api_name,
799: G_PKG_NAME,

Line 796: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

792: x_msg_data,
793: '_PVT'
794: );
795: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
796: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
797: (
798: l_api_name,
799: G_PKG_NAME,
800: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 800: 'OKC_API.G_RET_STS_UNEXP_ERROR',

796: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
797: (
798: l_api_name,
799: G_PKG_NAME,
800: 'OKC_API.G_RET_STS_UNEXP_ERROR',
801: x_msg_count,
802: x_msg_data,
803: '_PVT'
804: );

Line 806: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

802: x_msg_data,
803: '_PVT'
804: );
805: WHEN OTHERS THEN
806: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
807: (
808: l_api_name,
809: G_PKG_NAME,
810: 'OTHERS',

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

826: x_saiv_rec OUT NOCOPY saiv_rec_type) IS
827:
828: l_api_version CONSTANT NUMBER := 1;
829: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
830: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
831: l_saiv_rec saiv_rec_type;
832: l_def_saiv_rec saiv_rec_type;
833: l_sai_rec sai_rec_type;
834: lx_sai_rec sai_rec_type;

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

854: FUNCTION Set_Attributes (
855: p_saiv_rec IN saiv_rec_type,
856: x_saiv_rec OUT NOCOPY saiv_rec_type
857: ) RETURN VARCHAR2 IS
858: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
859: BEGIN
860: x_saiv_rec := p_saiv_rec;
861: x_saiv_rec.OBJECT_VERSION_NUMBER := 1;
862: RETURN(l_return_status);

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

861: x_saiv_rec.OBJECT_VERSION_NUMBER := 1;
862: RETURN(l_return_status);
863: END Set_Attributes;
864: BEGIN
865: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
866: G_PKG_NAME,
867: p_init_msg_list,
868: l_api_version,
869: p_api_version,

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

868: l_api_version,
869: p_api_version,
870: '_PVT',
871: x_return_status);
872: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
873: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
874: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
875: RAISE OKC_API.G_EXCEPTION_ERROR;
876: END IF;

Line 873: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

869: p_api_version,
870: '_PVT',
871: x_return_status);
872: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
873: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
874: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
875: RAISE OKC_API.G_EXCEPTION_ERROR;
876: END IF;
877: l_saiv_rec := null_out_defaults(p_saiv_rec);

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

870: '_PVT',
871: x_return_status);
872: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
873: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
874: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
875: RAISE OKC_API.G_EXCEPTION_ERROR;
876: END IF;
877: l_saiv_rec := null_out_defaults(p_saiv_rec);
878: --- Setting item attributes

Line 875: RAISE OKC_API.G_EXCEPTION_ERROR;

871: x_return_status);
872: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
873: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
874: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
875: RAISE OKC_API.G_EXCEPTION_ERROR;
876: END IF;
877: l_saiv_rec := null_out_defaults(p_saiv_rec);
878: --- Setting item attributes
879: l_return_status := Set_Attributes(

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

879: l_return_status := Set_Attributes(
880: l_saiv_rec, -- IN
881: l_def_saiv_rec); -- OUT
882: --- If any errors happen abort API
883: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
884: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
885: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
886: RAISE OKC_API.G_EXCEPTION_ERROR;
887: END IF;

Line 884: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

880: l_saiv_rec, -- IN
881: l_def_saiv_rec); -- OUT
882: --- If any errors happen abort API
883: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
884: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
885: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
886: RAISE OKC_API.G_EXCEPTION_ERROR;
887: END IF;
888: l_def_saiv_rec := fill_who_columns(l_def_saiv_rec);

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

881: l_def_saiv_rec); -- OUT
882: --- If any errors happen abort API
883: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
884: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
885: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
886: RAISE OKC_API.G_EXCEPTION_ERROR;
887: END IF;
888: l_def_saiv_rec := fill_who_columns(l_def_saiv_rec);
889: --- Validate all non-missing attributes (Item Level Validation)

Line 886: RAISE OKC_API.G_EXCEPTION_ERROR;

882: --- If any errors happen abort API
883: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
884: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
885: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
886: RAISE OKC_API.G_EXCEPTION_ERROR;
887: END IF;
888: l_def_saiv_rec := fill_who_columns(l_def_saiv_rec);
889: --- Validate all non-missing attributes (Item Level Validation)
890: l_return_status := Validate_Attributes(l_def_saiv_rec);

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

888: l_def_saiv_rec := fill_who_columns(l_def_saiv_rec);
889: --- Validate all non-missing attributes (Item Level Validation)
890: l_return_status := Validate_Attributes(l_def_saiv_rec);
891: --- If any errors happen abort API
892: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
893: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
894: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
895: RAISE OKC_API.G_EXCEPTION_ERROR;
896: END IF;

Line 893: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

889: --- Validate all non-missing attributes (Item Level Validation)
890: l_return_status := Validate_Attributes(l_def_saiv_rec);
891: --- If any errors happen abort API
892: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
893: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
894: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
895: RAISE OKC_API.G_EXCEPTION_ERROR;
896: END IF;
897: l_return_status := Validate_Record(l_def_saiv_rec);

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

890: l_return_status := Validate_Attributes(l_def_saiv_rec);
891: --- If any errors happen abort API
892: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
893: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
894: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
895: RAISE OKC_API.G_EXCEPTION_ERROR;
896: END IF;
897: l_return_status := Validate_Record(l_def_saiv_rec);
898: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 895: RAISE OKC_API.G_EXCEPTION_ERROR;

891: --- If any errors happen abort API
892: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
893: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
894: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
895: RAISE OKC_API.G_EXCEPTION_ERROR;
896: END IF;
897: l_return_status := Validate_Record(l_def_saiv_rec);
898: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

894: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
895: RAISE OKC_API.G_EXCEPTION_ERROR;
896: END IF;
897: l_return_status := Validate_Record(l_def_saiv_rec);
898: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
900: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
901: RAISE OKC_API.G_EXCEPTION_ERROR;
902: END IF;

Line 899: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

895: RAISE OKC_API.G_EXCEPTION_ERROR;
896: END IF;
897: l_return_status := Validate_Record(l_def_saiv_rec);
898: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
900: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
901: RAISE OKC_API.G_EXCEPTION_ERROR;
902: END IF;
903: /****************ADDED AFTER TAPI**************/

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

896: END IF;
897: l_return_status := Validate_Record(l_def_saiv_rec);
898: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
900: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
901: RAISE OKC_API.G_EXCEPTION_ERROR;
902: END IF;
903: /****************ADDED AFTER TAPI**************/
904: validate_unique(l_def_saiv_rec,l_return_status);

Line 901: RAISE OKC_API.G_EXCEPTION_ERROR;

897: l_return_status := Validate_Record(l_def_saiv_rec);
898: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
900: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
901: RAISE OKC_API.G_EXCEPTION_ERROR;
902: END IF;
903: /****************ADDED AFTER TAPI**************/
904: validate_unique(l_def_saiv_rec,l_return_status);
905: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

901: RAISE OKC_API.G_EXCEPTION_ERROR;
902: END IF;
903: /****************ADDED AFTER TAPI**************/
904: validate_unique(l_def_saiv_rec,l_return_status);
905: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
908: RAISE OKC_API.G_EXCEPTION_ERROR;
909: END IF;

Line 906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

902: END IF;
903: /****************ADDED AFTER TAPI**************/
904: validate_unique(l_def_saiv_rec,l_return_status);
905: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
908: RAISE OKC_API.G_EXCEPTION_ERROR;
909: END IF;
910: /****************END ADDED AFTER TAPI**************/

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

903: /****************ADDED AFTER TAPI**************/
904: validate_unique(l_def_saiv_rec,l_return_status);
905: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
908: RAISE OKC_API.G_EXCEPTION_ERROR;
909: END IF;
910: /****************END ADDED AFTER TAPI**************/
911: --------------------------------------

Line 908: RAISE OKC_API.G_EXCEPTION_ERROR;

904: validate_unique(l_def_saiv_rec,l_return_status);
905: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
908: RAISE OKC_API.G_EXCEPTION_ERROR;
909: END IF;
910: /****************END ADDED AFTER TAPI**************/
911: --------------------------------------
912: -- Move VIEW record to "Child" records

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

922: x_msg_data,
923: l_sai_rec,
924: lx_sai_rec
925: );
926: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
928: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
929: RAISE OKC_API.G_EXCEPTION_ERROR;
930: END IF;

Line 927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

923: l_sai_rec,
924: lx_sai_rec
925: );
926: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
928: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
929: RAISE OKC_API.G_EXCEPTION_ERROR;
930: END IF;
931: migrate(lx_sai_rec, l_def_saiv_rec);

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

924: lx_sai_rec
925: );
926: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
928: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
929: RAISE OKC_API.G_EXCEPTION_ERROR;
930: END IF;
931: migrate(lx_sai_rec, l_def_saiv_rec);
932: -- Set OUT values

Line 929: RAISE OKC_API.G_EXCEPTION_ERROR;

925: );
926: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
928: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
929: RAISE OKC_API.G_EXCEPTION_ERROR;
930: END IF;
931: migrate(lx_sai_rec, l_def_saiv_rec);
932: -- Set OUT values
933: x_saiv_rec := l_def_saiv_rec;

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

930: END IF;
931: migrate(lx_sai_rec, l_def_saiv_rec);
932: -- Set OUT values
933: x_saiv_rec := l_def_saiv_rec;
934: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
935: EXCEPTION
936: WHEN OKC_API.G_EXCEPTION_ERROR THEN
937: x_return_status := OKC_API.HANDLE_EXCEPTIONS
938: (

Line 936: WHEN OKC_API.G_EXCEPTION_ERROR THEN

932: -- Set OUT values
933: x_saiv_rec := l_def_saiv_rec;
934: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
935: EXCEPTION
936: WHEN OKC_API.G_EXCEPTION_ERROR THEN
937: x_return_status := OKC_API.HANDLE_EXCEPTIONS
938: (
939: l_api_name,
940: G_PKG_NAME,

Line 937: x_return_status := OKC_API.HANDLE_EXCEPTIONS

933: x_saiv_rec := l_def_saiv_rec;
934: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
935: EXCEPTION
936: WHEN OKC_API.G_EXCEPTION_ERROR THEN
937: x_return_status := OKC_API.HANDLE_EXCEPTIONS
938: (
939: l_api_name,
940: G_PKG_NAME,
941: 'OKC_API.G_RET_STS_ERROR',

Line 941: 'OKC_API.G_RET_STS_ERROR',

937: x_return_status := OKC_API.HANDLE_EXCEPTIONS
938: (
939: l_api_name,
940: G_PKG_NAME,
941: 'OKC_API.G_RET_STS_ERROR',
942: x_msg_count,
943: x_msg_data,
944: '_PVT'
945: );

Line 946: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

942: x_msg_count,
943: x_msg_data,
944: '_PVT'
945: );
946: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
947: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
948: (
949: l_api_name,
950: G_PKG_NAME,

Line 947: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

943: x_msg_data,
944: '_PVT'
945: );
946: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
947: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
948: (
949: l_api_name,
950: G_PKG_NAME,
951: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 951: 'OKC_API.G_RET_STS_UNEXP_ERROR',

947: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
948: (
949: l_api_name,
950: G_PKG_NAME,
951: 'OKC_API.G_RET_STS_UNEXP_ERROR',
952: x_msg_count,
953: x_msg_data,
954: '_PVT'
955: );

Line 957: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

953: x_msg_data,
954: '_PVT'
955: );
956: WHEN OTHERS THEN
957: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
958: (
959: l_api_name,
960: G_PKG_NAME,
961: 'OTHERS',

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

977: x_saiv_tbl OUT NOCOPY saiv_tbl_type) IS
978:
979: l_api_version CONSTANT NUMBER := 1;
980: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
981: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
982: i NUMBER := 0;
983: BEGIN
984: -- Make sure PL/SQL table has records in it before passing
985: IF (p_saiv_tbl.COUNT > 0) THEN

Line 1001: WHEN OKC_API.G_EXCEPTION_ERROR THEN

997: i := p_saiv_tbl.NEXT(i);
998: END LOOP;
999: END IF;
1000: EXCEPTION
1001: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1002: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1003: (
1004: l_api_name,
1005: G_PKG_NAME,

Line 1002: x_return_status := OKC_API.HANDLE_EXCEPTIONS

998: END LOOP;
999: END IF;
1000: EXCEPTION
1001: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1002: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1003: (
1004: l_api_name,
1005: G_PKG_NAME,
1006: 'OKC_API.G_RET_STS_ERROR',

Line 1006: 'OKC_API.G_RET_STS_ERROR',

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

Line 1011: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1007: x_msg_count,
1008: x_msg_data,
1009: '_PVT'
1010: );
1011: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1012: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1013: (
1014: l_api_name,
1015: G_PKG_NAME,

Line 1012: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1016: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1012: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1013: (
1014: l_api_name,
1015: G_PKG_NAME,
1016: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1017: x_msg_count,
1018: x_msg_data,
1019: '_PVT'
1020: );

Line 1022: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1018: x_msg_data,
1019: '_PVT'
1020: );
1021: WHEN OTHERS THEN
1022: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1023: (
1024: l_api_name,
1025: G_PKG_NAME,
1026: 'OTHERS',

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

1059: WHERE SAE_ID = p_sai_rec.sae_id
1060: AND SAE_ID_FOR = p_sai_rec.sae_id_for;
1061: l_api_version CONSTANT NUMBER := 1;
1062: l_api_name CONSTANT VARCHAR2(30) := 'INCMPTS_lock_row';
1063: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1064: l_object_version_number OKC_STD_ART_INCMPTS.OBJECT_VERSION_NUMBER%TYPE;
1065: lc_object_version_number OKC_STD_ART_INCMPTS.OBJECT_VERSION_NUMBER%TYPE;
1066: l_row_notfound BOOLEAN := FALSE;
1067: lc_row_notfound BOOLEAN := FALSE;

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

1065: lc_object_version_number OKC_STD_ART_INCMPTS.OBJECT_VERSION_NUMBER%TYPE;
1066: l_row_notfound BOOLEAN := FALSE;
1067: lc_row_notfound BOOLEAN := FALSE;
1068: BEGIN
1069: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1070: p_init_msg_list,
1071: '_PVT',
1072: x_return_status);
1073: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1069: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1070: p_init_msg_list,
1071: '_PVT',
1072: x_return_status);
1073: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1074: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1076: RAISE OKC_API.G_EXCEPTION_ERROR;
1077: END IF;

Line 1074: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1070: p_init_msg_list,
1071: '_PVT',
1072: x_return_status);
1073: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1074: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1076: RAISE OKC_API.G_EXCEPTION_ERROR;
1077: END IF;
1078: BEGIN

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

1071: '_PVT',
1072: x_return_status);
1073: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1074: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1076: RAISE OKC_API.G_EXCEPTION_ERROR;
1077: END IF;
1078: BEGIN
1079: OPEN lock_csr(p_sai_rec);

Line 1076: RAISE OKC_API.G_EXCEPTION_ERROR;

1072: x_return_status);
1073: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1074: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1076: RAISE OKC_API.G_EXCEPTION_ERROR;
1077: END IF;
1078: BEGIN
1079: OPEN lock_csr(p_sai_rec);
1080: FETCH lock_csr INTO l_object_version_number;

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

1084: WHEN E_Resource_Busy THEN
1085: IF (lock_csr%ISOPEN) THEN
1086: CLOSE lock_csr;
1087: END IF;
1088: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1089: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1090: END;
1091:
1092: IF ( l_row_notfound ) THEN

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

1095: lc_row_notfound := lchk_csr%NOTFOUND;
1096: CLOSE lchk_csr;
1097: END IF;
1098: IF (lc_row_notfound) THEN
1099: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1100: RAISE OKC_API.G_EXCEPTION_ERROR;
1101: ELSIF lc_object_version_number > p_sai_rec.object_version_number THEN
1102: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1103: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1100: RAISE OKC_API.G_EXCEPTION_ERROR;

1096: CLOSE lchk_csr;
1097: END IF;
1098: IF (lc_row_notfound) THEN
1099: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1100: RAISE OKC_API.G_EXCEPTION_ERROR;
1101: ELSIF lc_object_version_number > p_sai_rec.object_version_number THEN
1102: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1103: RAISE OKC_API.G_EXCEPTION_ERROR;
1104: ELSIF lc_object_version_number <> p_sai_rec.object_version_number THEN

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

1098: IF (lc_row_notfound) THEN
1099: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1100: RAISE OKC_API.G_EXCEPTION_ERROR;
1101: ELSIF lc_object_version_number > p_sai_rec.object_version_number THEN
1102: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1103: RAISE OKC_API.G_EXCEPTION_ERROR;
1104: ELSIF lc_object_version_number <> p_sai_rec.object_version_number THEN
1105: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1106: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1103: RAISE OKC_API.G_EXCEPTION_ERROR;

1099: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1100: RAISE OKC_API.G_EXCEPTION_ERROR;
1101: ELSIF lc_object_version_number > p_sai_rec.object_version_number THEN
1102: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1103: RAISE OKC_API.G_EXCEPTION_ERROR;
1104: ELSIF lc_object_version_number <> p_sai_rec.object_version_number THEN
1105: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1106: RAISE OKC_API.G_EXCEPTION_ERROR;
1107: ELSIF lc_object_version_number = -1 THEN

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

1101: ELSIF lc_object_version_number > p_sai_rec.object_version_number THEN
1102: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1103: RAISE OKC_API.G_EXCEPTION_ERROR;
1104: ELSIF lc_object_version_number <> p_sai_rec.object_version_number THEN
1105: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1106: RAISE OKC_API.G_EXCEPTION_ERROR;
1107: ELSIF lc_object_version_number = -1 THEN
1108: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1109: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1106: RAISE OKC_API.G_EXCEPTION_ERROR;

1102: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1103: RAISE OKC_API.G_EXCEPTION_ERROR;
1104: ELSIF lc_object_version_number <> p_sai_rec.object_version_number THEN
1105: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1106: RAISE OKC_API.G_EXCEPTION_ERROR;
1107: ELSIF lc_object_version_number = -1 THEN
1108: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;

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

1104: ELSIF lc_object_version_number <> p_sai_rec.object_version_number THEN
1105: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1106: RAISE OKC_API.G_EXCEPTION_ERROR;
1107: ELSIF lc_object_version_number = -1 THEN
1108: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;
1111: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1112: EXCEPTION

Line 1109: RAISE OKC_API.G_EXCEPTION_ERROR;

1105: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1106: RAISE OKC_API.G_EXCEPTION_ERROR;
1107: ELSIF lc_object_version_number = -1 THEN
1108: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;
1111: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1112: EXCEPTION
1113: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1107: ELSIF lc_object_version_number = -1 THEN
1108: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;
1111: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1112: EXCEPTION
1113: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1114: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1115: (

Line 1113: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;
1111: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1112: EXCEPTION
1113: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1114: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1115: (
1116: l_api_name,
1117: G_PKG_NAME,

Line 1114: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1110: END IF;
1111: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1112: EXCEPTION
1113: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1114: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1115: (
1116: l_api_name,
1117: G_PKG_NAME,
1118: 'OKC_API.G_RET_STS_ERROR',

Line 1118: 'OKC_API.G_RET_STS_ERROR',

1114: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1115: (
1116: l_api_name,
1117: G_PKG_NAME,
1118: 'OKC_API.G_RET_STS_ERROR',
1119: x_msg_count,
1120: x_msg_data,
1121: '_PVT'
1122: );

Line 1123: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1119: x_msg_count,
1120: x_msg_data,
1121: '_PVT'
1122: );
1123: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1124: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1125: (
1126: l_api_name,
1127: G_PKG_NAME,

Line 1124: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1120: x_msg_data,
1121: '_PVT'
1122: );
1123: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1124: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1125: (
1126: l_api_name,
1127: G_PKG_NAME,
1128: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1128: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1124: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1125: (
1126: l_api_name,
1127: G_PKG_NAME,
1128: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1129: x_msg_count,
1130: x_msg_data,
1131: '_PVT'
1132: );

Line 1134: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1130: x_msg_data,
1131: '_PVT'
1132: );
1133: WHEN OTHERS THEN
1134: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1135: (
1136: l_api_name,
1137: G_PKG_NAME,
1138: 'OTHERS',

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

1153: p_saiv_rec IN saiv_rec_type) IS
1154:
1155: l_api_version CONSTANT NUMBER := 1;
1156: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1157: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1158: l_sai_rec sai_rec_type;
1159: BEGIN
1160: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1161: G_PKG_NAME,

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

1156: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1157: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1158: l_sai_rec sai_rec_type;
1159: BEGIN
1160: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1161: G_PKG_NAME,
1162: p_init_msg_list,
1163: l_api_version,
1164: p_api_version,

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

1163: l_api_version,
1164: p_api_version,
1165: '_PVT',
1166: x_return_status);
1167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1170: RAISE OKC_API.G_EXCEPTION_ERROR;
1171: END IF;

Line 1168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1164: p_api_version,
1165: '_PVT',
1166: x_return_status);
1167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1170: RAISE OKC_API.G_EXCEPTION_ERROR;
1171: END IF;
1172: --------------------------------------

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

1165: '_PVT',
1166: x_return_status);
1167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1170: RAISE OKC_API.G_EXCEPTION_ERROR;
1171: END IF;
1172: --------------------------------------
1173: -- Move VIEW record to "Child" records

Line 1170: RAISE OKC_API.G_EXCEPTION_ERROR;

1166: x_return_status);
1167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1170: RAISE OKC_API.G_EXCEPTION_ERROR;
1171: END IF;
1172: --------------------------------------
1173: -- Move VIEW record to "Child" records
1174: --------------------------------------

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

1182: x_msg_count,
1183: x_msg_data,
1184: l_sai_rec
1185: );
1186: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1188: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1189: RAISE OKC_API.G_EXCEPTION_ERROR;
1190: END IF;

Line 1187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1183: x_msg_data,
1184: l_sai_rec
1185: );
1186: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1188: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1189: RAISE OKC_API.G_EXCEPTION_ERROR;
1190: END IF;
1191: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1184: l_sai_rec
1185: );
1186: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1188: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1189: RAISE OKC_API.G_EXCEPTION_ERROR;
1190: END IF;
1191: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1192: EXCEPTION

Line 1189: RAISE OKC_API.G_EXCEPTION_ERROR;

1185: );
1186: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1188: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1189: RAISE OKC_API.G_EXCEPTION_ERROR;
1190: END IF;
1191: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1192: EXCEPTION
1193: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1188: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1189: RAISE OKC_API.G_EXCEPTION_ERROR;
1190: END IF;
1191: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1192: EXCEPTION
1193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1194: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1195: (

Line 1193: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1189: RAISE OKC_API.G_EXCEPTION_ERROR;
1190: END IF;
1191: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1192: EXCEPTION
1193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1194: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1195: (
1196: l_api_name,
1197: G_PKG_NAME,

Line 1194: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1190: END IF;
1191: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1192: EXCEPTION
1193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1194: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1195: (
1196: l_api_name,
1197: G_PKG_NAME,
1198: 'OKC_API.G_RET_STS_ERROR',

Line 1198: 'OKC_API.G_RET_STS_ERROR',

1194: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1195: (
1196: l_api_name,
1197: G_PKG_NAME,
1198: 'OKC_API.G_RET_STS_ERROR',
1199: x_msg_count,
1200: x_msg_data,
1201: '_PVT'
1202: );

Line 1203: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1199: x_msg_count,
1200: x_msg_data,
1201: '_PVT'
1202: );
1203: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1204: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1205: (
1206: l_api_name,
1207: G_PKG_NAME,

Line 1204: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1200: x_msg_data,
1201: '_PVT'
1202: );
1203: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1204: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1205: (
1206: l_api_name,
1207: G_PKG_NAME,
1208: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1208: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1204: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1205: (
1206: l_api_name,
1207: G_PKG_NAME,
1208: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1209: x_msg_count,
1210: x_msg_data,
1211: '_PVT'
1212: );

Line 1214: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1210: x_msg_data,
1211: '_PVT'
1212: );
1213: WHEN OTHERS THEN
1214: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1215: (
1216: l_api_name,
1217: G_PKG_NAME,
1218: 'OTHERS',

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

1233: p_saiv_tbl IN saiv_tbl_type) IS
1234:
1235: l_api_version CONSTANT NUMBER := 1;
1236: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1237: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1238: i NUMBER := 0;
1239: BEGIN
1240: -- Make sure PL/SQL table has records in it before passing
1241: IF (p_saiv_tbl.COUNT > 0) THEN

Line 1256: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1252: i := p_saiv_tbl.NEXT(i);
1253: END LOOP;
1254: END IF;
1255: EXCEPTION
1256: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1257: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1258: (
1259: l_api_name,
1260: G_PKG_NAME,

Line 1257: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1253: END LOOP;
1254: END IF;
1255: EXCEPTION
1256: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1257: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1258: (
1259: l_api_name,
1260: G_PKG_NAME,
1261: 'OKC_API.G_RET_STS_ERROR',

Line 1261: 'OKC_API.G_RET_STS_ERROR',

1257: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1258: (
1259: l_api_name,
1260: G_PKG_NAME,
1261: 'OKC_API.G_RET_STS_ERROR',
1262: x_msg_count,
1263: x_msg_data,
1264: '_PVT'
1265: );

Line 1266: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1262: x_msg_count,
1263: x_msg_data,
1264: '_PVT'
1265: );
1266: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1267: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1268: (
1269: l_api_name,
1270: G_PKG_NAME,

Line 1267: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1263: x_msg_data,
1264: '_PVT'
1265: );
1266: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1267: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1268: (
1269: l_api_name,
1270: G_PKG_NAME,
1271: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1271: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1267: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1268: (
1269: l_api_name,
1270: G_PKG_NAME,
1271: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1272: x_msg_count,
1273: x_msg_data,
1274: '_PVT'
1275: );

Line 1277: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1273: x_msg_data,
1274: '_PVT'
1275: );
1276: WHEN OTHERS THEN
1277: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1278: (
1279: l_api_name,
1280: G_PKG_NAME,
1281: 'OTHERS',

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

1300: x_sai_rec OUT NOCOPY sai_rec_type) IS
1301:
1302: l_api_version CONSTANT NUMBER := 1;
1303: l_api_name CONSTANT VARCHAR2(30) := 'INCMPTS_update_row';
1304: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1305: l_sai_rec sai_rec_type := p_sai_rec;
1306: l_def_sai_rec sai_rec_type;
1307: l_row_notfound BOOLEAN := TRUE;
1308: ----------------------------------

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

1313: x_sai_rec OUT NOCOPY sai_rec_type
1314: ) RETURN VARCHAR2 IS
1315: l_sai_rec sai_rec_type;
1316: l_row_notfound BOOLEAN := TRUE;
1317: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1318: BEGIN
1319: x_sai_rec := p_sai_rec;
1320: -- Get current database values
1321: l_sai_rec := get_rec(p_sai_rec, l_row_notfound);

Line 1323: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1319: x_sai_rec := p_sai_rec;
1320: -- Get current database values
1321: l_sai_rec := get_rec(p_sai_rec, l_row_notfound);
1322: IF (l_row_notfound) THEN
1323: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1324: END IF;
1325: IF (x_sai_rec.sae_id = OKC_API.G_MISS_NUM)
1326: THEN
1327: x_sai_rec.sae_id := l_sai_rec.sae_id;

Line 1325: IF (x_sai_rec.sae_id = OKC_API.G_MISS_NUM)

1321: l_sai_rec := get_rec(p_sai_rec, l_row_notfound);
1322: IF (l_row_notfound) THEN
1323: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1324: END IF;
1325: IF (x_sai_rec.sae_id = OKC_API.G_MISS_NUM)
1326: THEN
1327: x_sai_rec.sae_id := l_sai_rec.sae_id;
1328: END IF;
1329: IF (x_sai_rec.sae_id_for = OKC_API.G_MISS_NUM)

Line 1329: IF (x_sai_rec.sae_id_for = OKC_API.G_MISS_NUM)

1325: IF (x_sai_rec.sae_id = OKC_API.G_MISS_NUM)
1326: THEN
1327: x_sai_rec.sae_id := l_sai_rec.sae_id;
1328: END IF;
1329: IF (x_sai_rec.sae_id_for = OKC_API.G_MISS_NUM)
1330: THEN
1331: x_sai_rec.sae_id_for := l_sai_rec.sae_id_for;
1332: END IF;
1333: IF (x_sai_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1333: IF (x_sai_rec.object_version_number = OKC_API.G_MISS_NUM)

1329: IF (x_sai_rec.sae_id_for = OKC_API.G_MISS_NUM)
1330: THEN
1331: x_sai_rec.sae_id_for := l_sai_rec.sae_id_for;
1332: END IF;
1333: IF (x_sai_rec.object_version_number = OKC_API.G_MISS_NUM)
1334: THEN
1335: x_sai_rec.object_version_number := l_sai_rec.object_version_number;
1336: END IF;
1337: IF (x_sai_rec.created_by = OKC_API.G_MISS_NUM)

Line 1337: IF (x_sai_rec.created_by = OKC_API.G_MISS_NUM)

1333: IF (x_sai_rec.object_version_number = OKC_API.G_MISS_NUM)
1334: THEN
1335: x_sai_rec.object_version_number := l_sai_rec.object_version_number;
1336: END IF;
1337: IF (x_sai_rec.created_by = OKC_API.G_MISS_NUM)
1338: THEN
1339: x_sai_rec.created_by := l_sai_rec.created_by;
1340: END IF;
1341: IF (x_sai_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1341: IF (x_sai_rec.creation_date = OKC_API.G_MISS_DATE)

1337: IF (x_sai_rec.created_by = OKC_API.G_MISS_NUM)
1338: THEN
1339: x_sai_rec.created_by := l_sai_rec.created_by;
1340: END IF;
1341: IF (x_sai_rec.creation_date = OKC_API.G_MISS_DATE)
1342: THEN
1343: x_sai_rec.creation_date := l_sai_rec.creation_date;
1344: END IF;
1345: IF (x_sai_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1345: IF (x_sai_rec.last_updated_by = OKC_API.G_MISS_NUM)

1341: IF (x_sai_rec.creation_date = OKC_API.G_MISS_DATE)
1342: THEN
1343: x_sai_rec.creation_date := l_sai_rec.creation_date;
1344: END IF;
1345: IF (x_sai_rec.last_updated_by = OKC_API.G_MISS_NUM)
1346: THEN
1347: x_sai_rec.last_updated_by := l_sai_rec.last_updated_by;
1348: END IF;
1349: IF (x_sai_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1349: IF (x_sai_rec.last_update_date = OKC_API.G_MISS_DATE)

1345: IF (x_sai_rec.last_updated_by = OKC_API.G_MISS_NUM)
1346: THEN
1347: x_sai_rec.last_updated_by := l_sai_rec.last_updated_by;
1348: END IF;
1349: IF (x_sai_rec.last_update_date = OKC_API.G_MISS_DATE)
1350: THEN
1351: x_sai_rec.last_update_date := l_sai_rec.last_update_date;
1352: END IF;
1353: IF (x_sai_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1353: IF (x_sai_rec.last_update_login = OKC_API.G_MISS_NUM)

1349: IF (x_sai_rec.last_update_date = OKC_API.G_MISS_DATE)
1350: THEN
1351: x_sai_rec.last_update_date := l_sai_rec.last_update_date;
1352: END IF;
1353: IF (x_sai_rec.last_update_login = OKC_API.G_MISS_NUM)
1354: THEN
1355: x_sai_rec.last_update_login := l_sai_rec.last_update_login;
1356: END IF;
1357: RETURN(l_return_status);

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

1362: FUNCTION Set_Attributes (
1363: p_sai_rec IN sai_rec_type,
1364: x_sai_rec OUT NOCOPY sai_rec_type
1365: ) RETURN VARCHAR2 IS
1366: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1367: BEGIN
1368: x_sai_rec := p_sai_rec;
1369: RETURN(l_return_status);
1370: END Set_Attributes;

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

1368: x_sai_rec := p_sai_rec;
1369: RETURN(l_return_status);
1370: END Set_Attributes;
1371: BEGIN
1372: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1373: p_init_msg_list,
1374: '_PVT',
1375: x_return_status);
1376: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1372: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1373: p_init_msg_list,
1374: '_PVT',
1375: x_return_status);
1376: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1379: RAISE OKC_API.G_EXCEPTION_ERROR;
1380: END IF;

Line 1377: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1373: p_init_msg_list,
1374: '_PVT',
1375: x_return_status);
1376: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1379: RAISE OKC_API.G_EXCEPTION_ERROR;
1380: END IF;
1381: --- Setting item attributes

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

1374: '_PVT',
1375: x_return_status);
1376: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1379: RAISE OKC_API.G_EXCEPTION_ERROR;
1380: END IF;
1381: --- Setting item attributes
1382: l_return_status := Set_Attributes(

Line 1379: RAISE OKC_API.G_EXCEPTION_ERROR;

1375: x_return_status);
1376: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1379: RAISE OKC_API.G_EXCEPTION_ERROR;
1380: END IF;
1381: --- Setting item attributes
1382: l_return_status := Set_Attributes(
1383: p_sai_rec, -- IN

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

1382: l_return_status := Set_Attributes(
1383: p_sai_rec, -- IN
1384: l_sai_rec); -- OUT
1385: --- If any errors happen abort API
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_sai_rec, -- IN
1384: l_sai_rec); -- OUT
1385: --- If any errors happen abort API
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: l_return_status := populate_new_record(l_sai_rec, l_def_sai_rec);

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

1384: l_sai_rec); -- OUT
1385: --- If any errors happen abort API
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: l_return_status := populate_new_record(l_sai_rec, l_def_sai_rec);
1392: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1389: RAISE OKC_API.G_EXCEPTION_ERROR;

1385: --- If any errors happen abort API
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: l_return_status := populate_new_record(l_sai_rec, l_def_sai_rec);
1392: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1393: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1388: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1389: RAISE OKC_API.G_EXCEPTION_ERROR;
1390: END IF;
1391: l_return_status := populate_new_record(l_sai_rec, l_def_sai_rec);
1392: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1393: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1394: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1395: RAISE OKC_API.G_EXCEPTION_ERROR;
1396: END IF;

Line 1393: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1389: RAISE OKC_API.G_EXCEPTION_ERROR;
1390: END IF;
1391: l_return_status := populate_new_record(l_sai_rec, l_def_sai_rec);
1392: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1393: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1394: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1395: RAISE OKC_API.G_EXCEPTION_ERROR;
1396: END IF;
1397: UPDATE OKC_STD_ART_INCMPTS

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

1390: END IF;
1391: l_return_status := populate_new_record(l_sai_rec, l_def_sai_rec);
1392: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1393: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1394: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1395: RAISE OKC_API.G_EXCEPTION_ERROR;
1396: END IF;
1397: UPDATE OKC_STD_ART_INCMPTS
1398: SET OBJECT_VERSION_NUMBER = l_def_sai_rec.object_version_number,

Line 1395: RAISE OKC_API.G_EXCEPTION_ERROR;

1391: l_return_status := populate_new_record(l_sai_rec, l_def_sai_rec);
1392: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1393: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1394: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1395: RAISE OKC_API.G_EXCEPTION_ERROR;
1396: END IF;
1397: UPDATE OKC_STD_ART_INCMPTS
1398: SET OBJECT_VERSION_NUMBER = l_def_sai_rec.object_version_number,
1399: CREATED_BY = l_def_sai_rec.created_by,

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

1404: WHERE SAE_ID = l_def_sai_rec.sae_id
1405: AND SAE_ID_FOR = l_def_sai_rec.sae_id_for;
1406:
1407: x_sai_rec := l_def_sai_rec;
1408: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1409: EXCEPTION
1410: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1411: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1412: (

Line 1410: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1406:
1407: x_sai_rec := l_def_sai_rec;
1408: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1409: EXCEPTION
1410: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1411: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1412: (
1413: l_api_name,
1414: G_PKG_NAME,

Line 1411: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1407: x_sai_rec := l_def_sai_rec;
1408: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1409: EXCEPTION
1410: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1411: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1412: (
1413: l_api_name,
1414: G_PKG_NAME,
1415: 'OKC_API.G_RET_STS_ERROR',

Line 1415: 'OKC_API.G_RET_STS_ERROR',

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

Line 1420: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1421: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1425: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1431: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

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

1451: x_saiv_rec OUT NOCOPY saiv_rec_type) IS
1452:
1453: l_api_version CONSTANT NUMBER := 1;
1454: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1455: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1456: l_saiv_rec saiv_rec_type := p_saiv_rec;
1457: l_def_saiv_rec saiv_rec_type;
1458: l_sai_rec sai_rec_type;
1459: lx_sai_rec sai_rec_type;

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

1478: x_saiv_rec OUT NOCOPY saiv_rec_type
1479: ) RETURN VARCHAR2 IS
1480: l_saiv_rec saiv_rec_type;
1481: l_row_notfound BOOLEAN := TRUE;
1482: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1483: BEGIN
1484: x_saiv_rec := p_saiv_rec;
1485: -- Get current database values
1486: l_saiv_rec := get_rec(p_saiv_rec, l_row_notfound);

Line 1488: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1484: x_saiv_rec := p_saiv_rec;
1485: -- Get current database values
1486: l_saiv_rec := get_rec(p_saiv_rec, l_row_notfound);
1487: IF (l_row_notfound) THEN
1488: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1489: END IF;
1490: IF (x_saiv_rec.sae_id = OKC_API.G_MISS_NUM)
1491: THEN
1492: x_saiv_rec.sae_id := l_saiv_rec.sae_id;

Line 1490: IF (x_saiv_rec.sae_id = OKC_API.G_MISS_NUM)

1486: l_saiv_rec := get_rec(p_saiv_rec, l_row_notfound);
1487: IF (l_row_notfound) THEN
1488: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1489: END IF;
1490: IF (x_saiv_rec.sae_id = OKC_API.G_MISS_NUM)
1491: THEN
1492: x_saiv_rec.sae_id := l_saiv_rec.sae_id;
1493: END IF;
1494: IF (x_saiv_rec.sae_id_for = OKC_API.G_MISS_NUM)

Line 1494: IF (x_saiv_rec.sae_id_for = OKC_API.G_MISS_NUM)

1490: IF (x_saiv_rec.sae_id = OKC_API.G_MISS_NUM)
1491: THEN
1492: x_saiv_rec.sae_id := l_saiv_rec.sae_id;
1493: END IF;
1494: IF (x_saiv_rec.sae_id_for = OKC_API.G_MISS_NUM)
1495: THEN
1496: x_saiv_rec.sae_id_for := l_saiv_rec.sae_id_for;
1497: END IF;
1498: IF (x_saiv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1498: IF (x_saiv_rec.object_version_number = OKC_API.G_MISS_NUM)

1494: IF (x_saiv_rec.sae_id_for = OKC_API.G_MISS_NUM)
1495: THEN
1496: x_saiv_rec.sae_id_for := l_saiv_rec.sae_id_for;
1497: END IF;
1498: IF (x_saiv_rec.object_version_number = OKC_API.G_MISS_NUM)
1499: THEN
1500: x_saiv_rec.object_version_number := l_saiv_rec.object_version_number;
1501: END IF;
1502: IF (x_saiv_rec.created_by = OKC_API.G_MISS_NUM)

Line 1502: IF (x_saiv_rec.created_by = OKC_API.G_MISS_NUM)

1498: IF (x_saiv_rec.object_version_number = OKC_API.G_MISS_NUM)
1499: THEN
1500: x_saiv_rec.object_version_number := l_saiv_rec.object_version_number;
1501: END IF;
1502: IF (x_saiv_rec.created_by = OKC_API.G_MISS_NUM)
1503: THEN
1504: x_saiv_rec.created_by := l_saiv_rec.created_by;
1505: END IF;
1506: IF (x_saiv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1506: IF (x_saiv_rec.creation_date = OKC_API.G_MISS_DATE)

1502: IF (x_saiv_rec.created_by = OKC_API.G_MISS_NUM)
1503: THEN
1504: x_saiv_rec.created_by := l_saiv_rec.created_by;
1505: END IF;
1506: IF (x_saiv_rec.creation_date = OKC_API.G_MISS_DATE)
1507: THEN
1508: x_saiv_rec.creation_date := l_saiv_rec.creation_date;
1509: END IF;
1510: IF (x_saiv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1510: IF (x_saiv_rec.last_updated_by = OKC_API.G_MISS_NUM)

1506: IF (x_saiv_rec.creation_date = OKC_API.G_MISS_DATE)
1507: THEN
1508: x_saiv_rec.creation_date := l_saiv_rec.creation_date;
1509: END IF;
1510: IF (x_saiv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1511: THEN
1512: x_saiv_rec.last_updated_by := l_saiv_rec.last_updated_by;
1513: END IF;
1514: IF (x_saiv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1514: IF (x_saiv_rec.last_update_date = OKC_API.G_MISS_DATE)

1510: IF (x_saiv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1511: THEN
1512: x_saiv_rec.last_updated_by := l_saiv_rec.last_updated_by;
1513: END IF;
1514: IF (x_saiv_rec.last_update_date = OKC_API.G_MISS_DATE)
1515: THEN
1516: x_saiv_rec.last_update_date := l_saiv_rec.last_update_date;
1517: END IF;
1518: IF (x_saiv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1518: IF (x_saiv_rec.last_update_login = OKC_API.G_MISS_NUM)

1514: IF (x_saiv_rec.last_update_date = OKC_API.G_MISS_DATE)
1515: THEN
1516: x_saiv_rec.last_update_date := l_saiv_rec.last_update_date;
1517: END IF;
1518: IF (x_saiv_rec.last_update_login = OKC_API.G_MISS_NUM)
1519: THEN
1520: x_saiv_rec.last_update_login := l_saiv_rec.last_update_login;
1521: END IF;
1522: RETURN(l_return_status);

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

1527: FUNCTION Set_Attributes (
1528: p_saiv_rec IN saiv_rec_type,
1529: x_saiv_rec OUT NOCOPY saiv_rec_type
1530: ) RETURN VARCHAR2 IS
1531: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1532: BEGIN
1533: x_saiv_rec := p_saiv_rec;
1534: x_saiv_rec.OBJECT_VERSION_NUMBER := NVL(x_saiv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1535: RETURN(l_return_status);

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

1534: x_saiv_rec.OBJECT_VERSION_NUMBER := NVL(x_saiv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1535: RETURN(l_return_status);
1536: END Set_Attributes;
1537: BEGIN
1538: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1539: G_PKG_NAME,
1540: p_init_msg_list,
1541: l_api_version,
1542: p_api_version,

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

1541: l_api_version,
1542: p_api_version,
1543: '_PVT',
1544: x_return_status);
1545: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1547: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1548: RAISE OKC_API.G_EXCEPTION_ERROR;
1549: END IF;

Line 1546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1542: p_api_version,
1543: '_PVT',
1544: x_return_status);
1545: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1547: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1548: RAISE OKC_API.G_EXCEPTION_ERROR;
1549: END IF;
1550: --- Setting item attributes

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

1543: '_PVT',
1544: x_return_status);
1545: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1547: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1548: RAISE OKC_API.G_EXCEPTION_ERROR;
1549: END IF;
1550: --- Setting item attributes
1551: l_return_status := Set_Attributes(

Line 1548: RAISE OKC_API.G_EXCEPTION_ERROR;

1544: x_return_status);
1545: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1547: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1548: RAISE OKC_API.G_EXCEPTION_ERROR;
1549: END IF;
1550: --- Setting item attributes
1551: l_return_status := Set_Attributes(
1552: p_saiv_rec, -- IN

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

1551: l_return_status := Set_Attributes(
1552: p_saiv_rec, -- IN
1553: l_saiv_rec); -- OUT
1554: --- If any errors happen abort API
1555: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1558: RAISE OKC_API.G_EXCEPTION_ERROR;
1559: END IF;

Line 1556: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1552: p_saiv_rec, -- IN
1553: l_saiv_rec); -- OUT
1554: --- If any errors happen abort API
1555: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1558: RAISE OKC_API.G_EXCEPTION_ERROR;
1559: END IF;
1560: l_return_status := populate_new_record(l_saiv_rec, l_def_saiv_rec);

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

1553: l_saiv_rec); -- OUT
1554: --- If any errors happen abort API
1555: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1558: RAISE OKC_API.G_EXCEPTION_ERROR;
1559: END IF;
1560: l_return_status := populate_new_record(l_saiv_rec, l_def_saiv_rec);
1561: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1558: RAISE OKC_API.G_EXCEPTION_ERROR;

1554: --- If any errors happen abort API
1555: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1558: RAISE OKC_API.G_EXCEPTION_ERROR;
1559: END IF;
1560: l_return_status := populate_new_record(l_saiv_rec, l_def_saiv_rec);
1561: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1562: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1557: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1558: RAISE OKC_API.G_EXCEPTION_ERROR;
1559: END IF;
1560: l_return_status := populate_new_record(l_saiv_rec, l_def_saiv_rec);
1561: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1562: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1563: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1564: RAISE OKC_API.G_EXCEPTION_ERROR;
1565: END IF;

Line 1562: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1558: RAISE OKC_API.G_EXCEPTION_ERROR;
1559: END IF;
1560: l_return_status := populate_new_record(l_saiv_rec, l_def_saiv_rec);
1561: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1562: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1563: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1564: RAISE OKC_API.G_EXCEPTION_ERROR;
1565: END IF;
1566: l_def_saiv_rec := fill_who_columns(l_def_saiv_rec);

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

1559: END IF;
1560: l_return_status := populate_new_record(l_saiv_rec, l_def_saiv_rec);
1561: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1562: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1563: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1564: RAISE OKC_API.G_EXCEPTION_ERROR;
1565: END IF;
1566: l_def_saiv_rec := fill_who_columns(l_def_saiv_rec);
1567: --- Validate all non-missing attributes (Item Level Validation)

Line 1564: RAISE OKC_API.G_EXCEPTION_ERROR;

1560: l_return_status := populate_new_record(l_saiv_rec, l_def_saiv_rec);
1561: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1562: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1563: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1564: RAISE OKC_API.G_EXCEPTION_ERROR;
1565: END IF;
1566: l_def_saiv_rec := fill_who_columns(l_def_saiv_rec);
1567: --- Validate all non-missing attributes (Item Level Validation)
1568: l_return_status := Validate_Attributes(l_def_saiv_rec);

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

1566: l_def_saiv_rec := fill_who_columns(l_def_saiv_rec);
1567: --- Validate all non-missing attributes (Item Level Validation)
1568: l_return_status := Validate_Attributes(l_def_saiv_rec);
1569: --- If any errors happen abort API
1570: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1571: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1572: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_ERROR;
1574: END IF;

Line 1571: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1567: --- Validate all non-missing attributes (Item Level Validation)
1568: l_return_status := Validate_Attributes(l_def_saiv_rec);
1569: --- If any errors happen abort API
1570: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1571: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1572: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_ERROR;
1574: END IF;
1575: l_return_status := Validate_Record(l_def_saiv_rec);

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

1568: l_return_status := Validate_Attributes(l_def_saiv_rec);
1569: --- If any errors happen abort API
1570: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1571: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1572: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_ERROR;
1574: END IF;
1575: l_return_status := Validate_Record(l_def_saiv_rec);
1576: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1573: RAISE OKC_API.G_EXCEPTION_ERROR;

1569: --- If any errors happen abort API
1570: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1571: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1572: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_ERROR;
1574: END IF;
1575: l_return_status := Validate_Record(l_def_saiv_rec);
1576: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1577: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1572: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_ERROR;
1574: END IF;
1575: l_return_status := Validate_Record(l_def_saiv_rec);
1576: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1577: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1578: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1579: RAISE OKC_API.G_EXCEPTION_ERROR;
1580: END IF;

Line 1577: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1573: RAISE OKC_API.G_EXCEPTION_ERROR;
1574: END IF;
1575: l_return_status := Validate_Record(l_def_saiv_rec);
1576: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1577: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1578: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1579: RAISE OKC_API.G_EXCEPTION_ERROR;
1580: END IF;
1581:

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

1574: END IF;
1575: l_return_status := Validate_Record(l_def_saiv_rec);
1576: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1577: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1578: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1579: RAISE OKC_API.G_EXCEPTION_ERROR;
1580: END IF;
1581:
1582: --------------------------------------

Line 1579: RAISE OKC_API.G_EXCEPTION_ERROR;

1575: l_return_status := Validate_Record(l_def_saiv_rec);
1576: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1577: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1578: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1579: RAISE OKC_API.G_EXCEPTION_ERROR;
1580: END IF;
1581:
1582: --------------------------------------
1583: -- Move VIEW record to "Child" records

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

1593: x_msg_data,
1594: l_sai_rec,
1595: lx_sai_rec
1596: );
1597: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1600: RAISE OKC_API.G_EXCEPTION_ERROR;
1601: END IF;

Line 1598: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1594: l_sai_rec,
1595: lx_sai_rec
1596: );
1597: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1600: RAISE OKC_API.G_EXCEPTION_ERROR;
1601: END IF;
1602: migrate(lx_sai_rec, l_def_saiv_rec);

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

1595: lx_sai_rec
1596: );
1597: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1600: RAISE OKC_API.G_EXCEPTION_ERROR;
1601: END IF;
1602: migrate(lx_sai_rec, l_def_saiv_rec);
1603: x_saiv_rec := l_def_saiv_rec;

Line 1600: RAISE OKC_API.G_EXCEPTION_ERROR;

1596: );
1597: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1600: RAISE OKC_API.G_EXCEPTION_ERROR;
1601: END IF;
1602: migrate(lx_sai_rec, l_def_saiv_rec);
1603: x_saiv_rec := l_def_saiv_rec;
1604: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1600: RAISE OKC_API.G_EXCEPTION_ERROR;
1601: END IF;
1602: migrate(lx_sai_rec, l_def_saiv_rec);
1603: x_saiv_rec := l_def_saiv_rec;
1604: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1605: EXCEPTION
1606: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1607: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1608: (

Line 1606: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1602: migrate(lx_sai_rec, l_def_saiv_rec);
1603: x_saiv_rec := l_def_saiv_rec;
1604: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1605: EXCEPTION
1606: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1607: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1608: (
1609: l_api_name,
1610: G_PKG_NAME,

Line 1607: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1603: x_saiv_rec := l_def_saiv_rec;
1604: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1605: EXCEPTION
1606: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1607: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1608: (
1609: l_api_name,
1610: G_PKG_NAME,
1611: 'OKC_API.G_RET_STS_ERROR',

Line 1611: 'OKC_API.G_RET_STS_ERROR',

1607: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1608: (
1609: l_api_name,
1610: G_PKG_NAME,
1611: 'OKC_API.G_RET_STS_ERROR',
1612: x_msg_count,
1613: x_msg_data,
1614: '_PVT'
1615: );

Line 1616: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1612: x_msg_count,
1613: x_msg_data,
1614: '_PVT'
1615: );
1616: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1617: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1618: (
1619: l_api_name,
1620: G_PKG_NAME,

Line 1617: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1613: x_msg_data,
1614: '_PVT'
1615: );
1616: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1617: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1618: (
1619: l_api_name,
1620: G_PKG_NAME,
1621: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1621: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1617: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1618: (
1619: l_api_name,
1620: G_PKG_NAME,
1621: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1622: x_msg_count,
1623: x_msg_data,
1624: '_PVT'
1625: );

Line 1627: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1623: x_msg_data,
1624: '_PVT'
1625: );
1626: WHEN OTHERS THEN
1627: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1628: (
1629: l_api_name,
1630: G_PKG_NAME,
1631: 'OTHERS',

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

1647: x_saiv_tbl OUT NOCOPY saiv_tbl_type) IS
1648:
1649: l_api_version CONSTANT NUMBER := 1;
1650: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1651: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1652: i NUMBER := 0;
1653: BEGIN
1654: -- Make sure PL/SQL table has records in it before passing
1655: IF (p_saiv_tbl.COUNT > 0) THEN

Line 1671: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1667: i := p_saiv_tbl.NEXT(i);
1668: END LOOP;
1669: END IF;
1670: EXCEPTION
1671: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1672: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1673: (
1674: l_api_name,
1675: G_PKG_NAME,

Line 1672: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1668: END LOOP;
1669: END IF;
1670: EXCEPTION
1671: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1672: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1673: (
1674: l_api_name,
1675: G_PKG_NAME,
1676: 'OKC_API.G_RET_STS_ERROR',

Line 1676: 'OKC_API.G_RET_STS_ERROR',

1672: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1673: (
1674: l_api_name,
1675: G_PKG_NAME,
1676: 'OKC_API.G_RET_STS_ERROR',
1677: x_msg_count,
1678: x_msg_data,
1679: '_PVT'
1680: );

Line 1681: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1677: x_msg_count,
1678: x_msg_data,
1679: '_PVT'
1680: );
1681: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1682: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1683: (
1684: l_api_name,
1685: G_PKG_NAME,

Line 1682: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1678: x_msg_data,
1679: '_PVT'
1680: );
1681: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1682: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1683: (
1684: l_api_name,
1685: G_PKG_NAME,
1686: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1686: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1682: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1683: (
1684: l_api_name,
1685: G_PKG_NAME,
1686: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1687: x_msg_count,
1688: x_msg_data,
1689: '_PVT'
1690: );

Line 1692: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1688: x_msg_data,
1689: '_PVT'
1690: );
1691: WHEN OTHERS THEN
1692: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1693: (
1694: l_api_name,
1695: G_PKG_NAME,
1696: 'OTHERS',

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

1714: p_sai_rec IN sai_rec_type) IS
1715:
1716: l_api_version CONSTANT NUMBER := 1;
1717: l_api_name CONSTANT VARCHAR2(30) := 'INCMPTS_delete_row';
1718: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1719: l_sai_rec sai_rec_type:= p_sai_rec;
1720: l_row_notfound BOOLEAN := TRUE;
1721: BEGIN
1722: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

1718: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1719: l_sai_rec sai_rec_type:= p_sai_rec;
1720: l_row_notfound BOOLEAN := TRUE;
1721: BEGIN
1722: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1723: p_init_msg_list,
1724: '_PVT',
1725: x_return_status);
1726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1722: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1723: p_init_msg_list,
1724: '_PVT',
1725: x_return_status);
1726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;

Line 1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1723: p_init_msg_list,
1724: '_PVT',
1725: x_return_status);
1726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: DELETE FROM OKC_STD_ART_INCMPTS

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

1724: '_PVT',
1725: x_return_status);
1726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: DELETE FROM OKC_STD_ART_INCMPTS
1732: WHERE SAE_ID = l_sai_rec.sae_id AND

Line 1729: RAISE OKC_API.G_EXCEPTION_ERROR;

1725: x_return_status);
1726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: DELETE FROM OKC_STD_ART_INCMPTS
1732: WHERE SAE_ID = l_sai_rec.sae_id AND
1733: SAE_ID_FOR = l_sai_rec.sae_id_for;

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

1731: DELETE FROM OKC_STD_ART_INCMPTS
1732: WHERE SAE_ID = l_sai_rec.sae_id AND
1733: SAE_ID_FOR = l_sai_rec.sae_id_for;
1734:
1735: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1736: EXCEPTION
1737: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1738: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1739: (

Line 1737: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1733: SAE_ID_FOR = l_sai_rec.sae_id_for;
1734:
1735: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1736: EXCEPTION
1737: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1738: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1739: (
1740: l_api_name,
1741: G_PKG_NAME,

Line 1738: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1734:
1735: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1736: EXCEPTION
1737: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1738: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1739: (
1740: l_api_name,
1741: G_PKG_NAME,
1742: 'OKC_API.G_RET_STS_ERROR',

Line 1742: 'OKC_API.G_RET_STS_ERROR',

1738: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1739: (
1740: l_api_name,
1741: G_PKG_NAME,
1742: 'OKC_API.G_RET_STS_ERROR',
1743: x_msg_count,
1744: x_msg_data,
1745: '_PVT'
1746: );

Line 1747: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1743: x_msg_count,
1744: x_msg_data,
1745: '_PVT'
1746: );
1747: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1748: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1749: (
1750: l_api_name,
1751: G_PKG_NAME,

Line 1748: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1744: x_msg_data,
1745: '_PVT'
1746: );
1747: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1748: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1749: (
1750: l_api_name,
1751: G_PKG_NAME,
1752: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1752: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1748: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1749: (
1750: l_api_name,
1751: G_PKG_NAME,
1752: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1753: x_msg_count,
1754: x_msg_data,
1755: '_PVT'
1756: );

Line 1758: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1754: x_msg_data,
1755: '_PVT'
1756: );
1757: WHEN OTHERS THEN
1758: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1759: (
1760: l_api_name,
1761: G_PKG_NAME,
1762: 'OTHERS',

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

1777: p_saiv_rec IN saiv_rec_type) IS
1778:
1779: l_api_version CONSTANT NUMBER := 1;
1780: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
1781: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1782: l_saiv_rec saiv_rec_type := p_saiv_rec;
1783: l_sai_rec sai_rec_type;
1784: BEGIN
1785: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

1781: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1782: l_saiv_rec saiv_rec_type := p_saiv_rec;
1783: l_sai_rec sai_rec_type;
1784: BEGIN
1785: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1786: G_PKG_NAME,
1787: p_init_msg_list,
1788: l_api_version,
1789: p_api_version,

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

1788: l_api_version,
1789: p_api_version,
1790: '_PVT',
1791: x_return_status);
1792: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1794: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1795: RAISE OKC_API.G_EXCEPTION_ERROR;
1796: END IF;

Line 1793: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1789: p_api_version,
1790: '_PVT',
1791: x_return_status);
1792: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1794: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1795: RAISE OKC_API.G_EXCEPTION_ERROR;
1796: END IF;
1797: --------------------------------------

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

1790: '_PVT',
1791: x_return_status);
1792: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1794: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1795: RAISE OKC_API.G_EXCEPTION_ERROR;
1796: END IF;
1797: --------------------------------------
1798: -- Move VIEW record to "Child" records

Line 1795: RAISE OKC_API.G_EXCEPTION_ERROR;

1791: x_return_status);
1792: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1794: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1795: RAISE OKC_API.G_EXCEPTION_ERROR;
1796: END IF;
1797: --------------------------------------
1798: -- Move VIEW record to "Child" records
1799: --------------------------------------

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

1807: x_msg_count,
1808: x_msg_data,
1809: l_sai_rec
1810: );
1811: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1812: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1813: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1814: RAISE OKC_API.G_EXCEPTION_ERROR;
1815: END IF;

Line 1812: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1808: x_msg_data,
1809: l_sai_rec
1810: );
1811: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1812: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1813: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1814: RAISE OKC_API.G_EXCEPTION_ERROR;
1815: END IF;
1816: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1809: l_sai_rec
1810: );
1811: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1812: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1813: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1814: RAISE OKC_API.G_EXCEPTION_ERROR;
1815: END IF;
1816: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1817: EXCEPTION

Line 1814: RAISE OKC_API.G_EXCEPTION_ERROR;

1810: );
1811: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1812: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1813: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1814: RAISE OKC_API.G_EXCEPTION_ERROR;
1815: END IF;
1816: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1817: EXCEPTION
1818: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1812: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1813: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1814: RAISE OKC_API.G_EXCEPTION_ERROR;
1815: END IF;
1816: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1817: EXCEPTION
1818: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1819: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1820: (

Line 1818: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1814: RAISE OKC_API.G_EXCEPTION_ERROR;
1815: END IF;
1816: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1817: EXCEPTION
1818: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1819: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1820: (
1821: l_api_name,
1822: G_PKG_NAME,

Line 1819: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1815: END IF;
1816: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1817: EXCEPTION
1818: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1819: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1820: (
1821: l_api_name,
1822: G_PKG_NAME,
1823: 'OKC_API.G_RET_STS_ERROR',

Line 1823: 'OKC_API.G_RET_STS_ERROR',

1819: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1820: (
1821: l_api_name,
1822: G_PKG_NAME,
1823: 'OKC_API.G_RET_STS_ERROR',
1824: x_msg_count,
1825: x_msg_data,
1826: '_PVT'
1827: );

Line 1828: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1824: x_msg_count,
1825: x_msg_data,
1826: '_PVT'
1827: );
1828: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1829: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1830: (
1831: l_api_name,
1832: G_PKG_NAME,

Line 1829: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1825: x_msg_data,
1826: '_PVT'
1827: );
1828: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1829: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1830: (
1831: l_api_name,
1832: G_PKG_NAME,
1833: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1833: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1829: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1830: (
1831: l_api_name,
1832: G_PKG_NAME,
1833: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1834: x_msg_count,
1835: x_msg_data,
1836: '_PVT'
1837: );

Line 1839: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1835: x_msg_data,
1836: '_PVT'
1837: );
1838: WHEN OTHERS THEN
1839: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1840: (
1841: l_api_name,
1842: G_PKG_NAME,
1843: 'OTHERS',

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

1858: p_saiv_tbl IN saiv_tbl_type) IS
1859:
1860: l_api_version CONSTANT NUMBER := 1;
1861: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
1862: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1863: i NUMBER := 0;
1864: BEGIN
1865: -- Make sure PL/SQL table has records in it before passing
1866: IF (p_saiv_tbl.COUNT > 0) THEN

Line 1881: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1877: i := p_saiv_tbl.NEXT(i);
1878: END LOOP;
1879: END IF;
1880: EXCEPTION
1881: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1882: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1883: (
1884: l_api_name,
1885: G_PKG_NAME,

Line 1882: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1878: END LOOP;
1879: END IF;
1880: EXCEPTION
1881: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1882: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1883: (
1884: l_api_name,
1885: G_PKG_NAME,
1886: 'OKC_API.G_RET_STS_ERROR',

Line 1886: 'OKC_API.G_RET_STS_ERROR',

1882: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1883: (
1884: l_api_name,
1885: G_PKG_NAME,
1886: 'OKC_API.G_RET_STS_ERROR',
1887: x_msg_count,
1888: x_msg_data,
1889: '_PVT'
1890: );

Line 1891: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1887: x_msg_count,
1888: x_msg_data,
1889: '_PVT'
1890: );
1891: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1892: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1893: (
1894: l_api_name,
1895: G_PKG_NAME,

Line 1892: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1888: x_msg_data,
1889: '_PVT'
1890: );
1891: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1892: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1893: (
1894: l_api_name,
1895: G_PKG_NAME,
1896: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1896: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1892: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1893: (
1894: l_api_name,
1895: G_PKG_NAME,
1896: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1897: x_msg_count,
1898: x_msg_data,
1899: '_PVT'
1900: );

Line 1902: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1898: x_msg_data,
1899: '_PVT'
1900: );
1901: WHEN OTHERS THEN
1902: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1903: (
1904: l_api_name,
1905: G_PKG_NAME,
1906: 'OTHERS',