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.OKL_SETUPDQUALITYS_PVT dependencies on OKL_API

Line 41: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

37: WHERE okl_pdt_pqys_v.id = p_id;
38: l_okl_pdqv_pk okl_pdqv_pk_csr%ROWTYPE;
39: l_pdqv_rec pdqv_rec_type;
40: BEGIN
41: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
42: x_no_data_found := TRUE;
43: -- Get current database values
44: OPEN okl_pdqv_pk_csr (p_pdqv_rec.id);
45: FETCH okl_pdqv_pk_csr INTO

Line 64: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

60: x_pdqv_rec := l_pdqv_rec;
61: EXCEPTION
62: WHEN OTHERS THEN
63: -- store SQL error message on message stack
64: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
65: p_msg_name => G_UNEXPECTED_ERROR,
66: p_token1 => G_SQLCODE_TOKEN,
67:
68: p_token1_value => SQLCODE,

Line 73: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

69:
70: p_token2 => G_SQLERRM_TOKEN,
71: p_token2_value => SQLERRM);
72: -- notify UNEXPECTED error for calling API.
73: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
74:
75: IF (okl_pdqv_pk_csr%ISOPEN) THEN
76: CLOSE okl_pdqv_pk_csr;
77: END IF;

Line 99: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

95: WHERE ptlv.id = p_ptl_id;
96: l_okl_ptlv_pk okl_ptl_pk_csr%ROWTYPE;
97: l_ptlv_rec ptlv_rec_type;
98: BEGIN
99: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
100: x_no_data_found := TRUE;
101: -- Get current database values
102: OPEN okl_ptl_pk_csr (p_pdqv_rec.ptl_id);
103: FETCH okl_ptl_pk_csr INTO

Line 112: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

108: x_ptlv_rec := l_ptlv_rec;
109: EXCEPTION
110: WHEN OTHERS THEN
111: -- store SQL error message on message stack
112: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
113: p_msg_name => G_UNEXPECTED_ERROR,
114: p_token1 => G_SQLCODE_TOKEN,
115: p_token1_value => SQLCODE,
116: p_token2 => G_SQLERRM_TOKEN,

Line 119: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

115: p_token1_value => SQLCODE,
116: p_token2 => G_SQLERRM_TOKEN,
117: p_token2_value => SQLERRM);
118: -- notify UNEXPECTED error for calling API.
119: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
120:
121:
122: IF (okl_ptl_pk_csr%ISOPEN) THEN
123: CLOSE okl_ptl_pk_csr;

Line 134: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

130: -----------------------------------------------------------------------------
131:
132: PROCEDURE Check_Constraints (
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
135: p_pdqv_rec IN pdqv_rec_type,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,

Line 203: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

199: l_token_6 VARCHAR2(1999);
200:
201: BEGIN
202: x_valid := TRUE;
203: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
204:
205:
206: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PDT_TMPL_PDT_QLTY_SUMRY',
207: p_attribute_code => 'OKL_PDT_TMPL_PDT_Q_SUMRY_TITLE');

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

227: l_row_not_found := okl_pdqv_chk%NOTFOUND;
228: CLOSE okl_pdqv_chk;
229:
230: IF l_row_not_found = FALSE THEN
231: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
232: p_msg_name => G_IN_USE,
233: p_token1 => G_PARENT_TABLE_TOKEN,
234: p_token1_value => l_token_1,
235: p_token2 => G_CHILD_TABLE_TOKEN,

Line 238: x_return_status := Okl_Api.G_RET_STS_ERROR;

234: p_token1_value => l_token_1,
235: p_token2 => G_CHILD_TABLE_TOKEN,
236: p_token2_value => l_token_2);
237: x_valid := FALSE;
238: x_return_status := Okl_Api.G_RET_STS_ERROR;
239: RAISE G_EXCEPTION_HALT_PROCESSING;
240: END IF;
241:
242:

Line 250: ---Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME,Okl_Pdq_Pvt.G_UNQS,Okl_Pdq_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001

246: l_row_found := c1%FOUND;
247:
248: CLOSE c1;
249: IF l_row_found THEN
250: ---Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME,Okl_Pdq_Pvt.G_UNQS,Okl_Pdq_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001
251: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
252: p_msg_name => 'OKL_COLUMN_NOT_UNIQUE',
253: p_token1 => G_TABLE_TOKEN,
254: p_token1_value => l_token_1,

Line 251: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

247:
248: CLOSE c1;
249: IF l_row_found THEN
250: ---Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME,Okl_Pdq_Pvt.G_UNQS,Okl_Pdq_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001
251: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
252: p_msg_name => 'OKL_COLUMN_NOT_UNIQUE',
253: p_token1 => G_TABLE_TOKEN,
254: p_token1_value => l_token_1,
255: p_token2 => G_COLUMN_TOKEN,

Line 258: x_return_status := Okl_Api.G_RET_STS_ERROR;

254: p_token1_value => l_token_1,
255: p_token2 => G_COLUMN_TOKEN,
256: p_token2_value => l_token_6);
257: x_valid := FALSE;
258: x_return_status := Okl_Api.G_RET_STS_ERROR;
259: RAISE G_EXCEPTION_HALT_PROCESSING;
260: END IF;
261:
262:

Line 337: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

333:
334: */
335:
336: IF l_invalid_selection_1 > 0 THEN
337: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
338: p_msg_name => G_LEASE_SEC_MISMATCH);
339:
340: x_valid := FALSE;
341: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 341: x_return_status := Okl_Api.G_RET_STS_ERROR;

337: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
338: p_msg_name => G_LEASE_SEC_MISMATCH);
339:
340: x_valid := FALSE;
341: x_return_status := Okl_Api.G_RET_STS_ERROR;
342: RAISE G_EXCEPTION_HALT_PROCESSING;
343: END IF;
344:
345: /*

Line 347: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

343: END IF;
344:
345: /*
346: IF l_invalid_selection_2 > 0 THEN
347: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
348: p_msg_name => G_TAXOWN_SEC_MISMATCH);
349: x_valid := FALSE;
350: x_return_status := Okl_Api.G_RET_STS_ERROR;
351: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 350: x_return_status := Okl_Api.G_RET_STS_ERROR;

346: IF l_invalid_selection_2 > 0 THEN
347: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
348: p_msg_name => G_TAXOWN_SEC_MISMATCH);
349: x_valid := FALSE;
350: x_return_status := Okl_Api.G_RET_STS_ERROR;
351: RAISE G_EXCEPTION_HALT_PROCESSING;
352: END IF;
353: */
354: END;

Line 358: IF p_pdqv_rec.id = Okl_Api.G_MISS_NUM THEN

354: END;
355:
356:
357: -- Check for constraints dates
358: IF p_pdqv_rec.id = Okl_Api.G_MISS_NUM THEN
359: OPEN okl_pdq_constraints_csr (p_pdqv_rec.pqy_id,
360: p_pdqv_rec.from_date,
361: p_pdqv_rec.TO_DATE);
362: FETCH okl_pdq_constraints_csr INTO l_check;

Line 367: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

363: l_row_not_found := okl_pdq_constraints_csr%NOTFOUND;
364: CLOSE okl_pdq_constraints_csr;
365:
366: IF l_row_not_found = FALSE THEN
367: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
368: p_msg_name => G_DATES_MISMATCH,
369: p_token1 => G_PARENT_TABLE_TOKEN,
370: p_token1_value => l_token_5,
371: p_token2 => G_CHILD_TABLE_TOKEN,

Line 374: x_return_status := Okl_Api.G_RET_STS_ERROR;

370: p_token1_value => l_token_5,
371: p_token2 => G_CHILD_TABLE_TOKEN,
372: p_token2_value => l_token_4);
373: x_valid := FALSE;
374: x_return_status := Okl_Api.G_RET_STS_ERROR;
375: RAISE G_EXCEPTION_HALT_PROCESSING;
376: END IF;
377: END IF;
378:

Line 387: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

383: -- with the next column
384: NULL;
385: WHEN OTHERS THEN
386: -- store SQL error message on message stack
387: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
388: p_msg_name => G_UNEXPECTED_ERROR,
389: p_token1 => G_SQLCODE_TOKEN,
390: p_token1_value => SQLCODE,
391: p_token2 => G_SQLERRM_TOKEN,

Line 395: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

391: p_token2 => G_SQLERRM_TOKEN,
392:
393: p_token2_value => SQLERRM);
394: x_valid := FALSE;
395: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
396:
397:
398: IF (okl_pdqv_chk%ISOPEN) THEN
399: CLOSE okl_pdqv_chk;

Line 439: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

435: FROM okl_pdt_qualitys_v
436: WHERE okl_pdt_qualitys_v.id = p_id;
437:
438: l_pqy_status VARCHAR2(1);
439: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
440: l_row_notfound BOOLEAN := TRUE;
441: l_token_1 VARCHAR2(1999);
442:
443: BEGIN

Line 445: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

441: l_token_1 VARCHAR2(1999);
442:
443: BEGIN
444: -- initialize return status
445: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
446:
447: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PDT_TMPL_PDT_QLTY_CREAT',
448: p_attribute_code => 'OKL_PRODUCT_QUALITY');
449:

Line 452: (p_pdqv_rec.pqy_id = Okl_Api.G_MISS_NUM) THEN

448: p_attribute_code => 'OKL_PRODUCT_QUALITY');
449:
450: -- check for data before processing
451: IF (p_pdqv_rec.pqy_id IS NULL) OR
452: (p_pdqv_rec.pqy_id = Okl_Api.G_MISS_NUM) THEN
453: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
454: IF(L_DEBUG_ENABLED='Y') THEN
455: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
456: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

Line 453: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE

449:
450: -- check for data before processing
451: IF (p_pdqv_rec.pqy_id IS NULL) OR
452: (p_pdqv_rec.pqy_id = Okl_Api.G_MISS_NUM) THEN
453: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
454: IF(L_DEBUG_ENABLED='Y') THEN
455: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
456: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
457: END IF;

Line 460: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');

456: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
457: END IF;
458: IF(IS_DEBUG_PROCEDURE_ON) THEN
459: BEGIN
460: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');
461: END;
462: END IF;
463: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name
464: ,p_msg_name => Okl_Pdq_Pvt.g_required_value

Line 463: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name

459: BEGIN
460: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');
461: END;
462: END IF;
463: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name
464: ,p_msg_name => Okl_Pdq_Pvt.g_required_value
465: ,p_token1 => Okl_Pdq_Pvt.g_col_name_token
466: ,p_token1_value => l_token_1);
467: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 469: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');

465: ,p_token1 => Okl_Pdq_Pvt.g_col_name_token
466: ,p_token1_value => l_token_1);
467: IF(IS_DEBUG_PROCEDURE_ON) THEN
468: BEGIN
469: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');
470: END;
471: END IF;
472: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
473: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 472: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE

468: BEGIN
469: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');
470: END;
471: END IF;
472: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
473: x_return_status := Okl_Api.G_RET_STS_ERROR;
474: RAISE G_EXCEPTION_HALT_PROCESSING;
475: END IF;
476:

Line 473: x_return_status := Okl_Api.G_RET_STS_ERROR;

469: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');
470: END;
471: END IF;
472: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
473: x_return_status := Okl_Api.G_RET_STS_ERROR;
474: RAISE G_EXCEPTION_HALT_PROCESSING;
475: END IF;
476:
477: IF (p_pdqv_rec.pqy_ID IS NOT NULL)

Line 485: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.set_message

481: FETCH okl_pqyv_pk_csr INTO l_pqy_status;
482: l_row_notfound := okl_pqyv_pk_csr%NOTFOUND;
483: CLOSE okl_pqyv_pk_csr;
484: IF (l_row_notfound) THEN
485: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.set_message
486: IF(IS_DEBUG_PROCEDURE_ON) THEN
487: BEGIN
488: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.set_message ');
489: END;

Line 488: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.set_message ');

484: IF (l_row_notfound) THEN
485: -- Start of wraper code generated automatically by Debug code generator for Okl_Api.set_message
486: IF(IS_DEBUG_PROCEDURE_ON) THEN
487: BEGIN
488: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.set_message ');
489: END;
490: END IF;
491: Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME, Okl_Pdq_Pvt.G_INVALID_VALUE,Okl_Pdq_Pvt.G_COL_NAME_TOKEN,l_token_1);
492: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 491: Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME, Okl_Pdq_Pvt.G_INVALID_VALUE,Okl_Pdq_Pvt.G_COL_NAME_TOKEN,l_token_1);

487: BEGIN
488: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.set_message ');
489: END;
490: END IF;
491: Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME, Okl_Pdq_Pvt.G_INVALID_VALUE,Okl_Pdq_Pvt.G_COL_NAME_TOKEN,l_token_1);
492: IF(IS_DEBUG_PROCEDURE_ON) THEN
493: BEGIN
494: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.set_message ');
495: END;

Line 494: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.set_message ');

490: END IF;
491: Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME, Okl_Pdq_Pvt.G_INVALID_VALUE,Okl_Pdq_Pvt.G_COL_NAME_TOKEN,l_token_1);
492: IF(IS_DEBUG_PROCEDURE_ON) THEN
493: BEGIN
494: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.set_message ');
495: END;
496: END IF;
497: -- End of wraper code generated automatically by Debug code generator for Okl_Api.set_message
498: RAISE G_ITEM_NOT_FOUND_ERROR;

Line 497: -- End of wraper code generated automatically by Debug code generator for Okl_Api.set_message

493: BEGIN
494: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.set_message ');
495: END;
496: END IF;
497: -- End of wraper code generated automatically by Debug code generator for Okl_Api.set_message
498: RAISE G_ITEM_NOT_FOUND_ERROR;
499: END IF;
500: END IF;
501:

Line 512: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,

508: x_return_status := Okc_Api.G_RET_STS_ERROR;
509:
510: WHEN OTHERS THEN
511: -- store SQL error message on message stack for caller
512: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,
513: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,
514: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,
515: p_token1_value => SQLCODE,
516: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,

Line 520: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

516: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,
517: p_token2_value => SQLERRM);
518:
519: -- notify caller of an UNEXPECTED error
520: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
521:
522: END Validate_Pqy_Id;
523:
524: ---------------------------------------------------------------------------

Line 540: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

536:
537: FUNCTION Validate_Attributes (
538: p_pdqv_rec IN pdqv_rec_type
539: ) RETURN VARCHAR2 IS
540: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
541: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
542: BEGIN
543: -- Validate_Pqy_Id
544: Validate_Pqy_Id(p_pdqv_rec,x_return_status);

Line 541: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

537: FUNCTION Validate_Attributes (
538: p_pdqv_rec IN pdqv_rec_type
539: ) RETURN VARCHAR2 IS
540: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
541: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
542: BEGIN
543: -- Validate_Pqy_Id
544: Validate_Pqy_Id(p_pdqv_rec,x_return_status);
545: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 545: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

541: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
542: BEGIN
543: -- Validate_Pqy_Id
544: Validate_Pqy_Id(p_pdqv_rec,x_return_status);
545: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
546: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
547: -- need to leave
548: l_return_status := x_return_status;
549: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 546: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

542: BEGIN
543: -- Validate_Pqy_Id
544: Validate_Pqy_Id(p_pdqv_rec,x_return_status);
545: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
546: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
547: -- need to leave
548: l_return_status := x_return_status;
549: RAISE G_EXCEPTION_HALT_PROCESSING;
550: ELSE

Line 565: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,

561: RETURN (l_return_status);
562:
563: WHEN OTHERS THEN
564: -- store SQL error message on message stack for caller
565: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,
566: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,
567: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,
568: p_token1_value => SQLCODE,
569: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,

Line 572: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

568: p_token1_value => SQLCODE,
569: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,
570: p_token2_value => SQLERRM);
571: -- notify caller of an UNEXPECTED error
572: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
573: RETURN(l_return_status);
574:
575: END Validate_Attributes;
576:

Line 582: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

578: -- PROCEDURE copy_dependent_qualitys for: OKL_PDT_PQYS_V
579: ---------------------------------------------------------------------------
580:
581: PROCEDURE copy_dependent_qualitys (p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
583: p_pdqv_rec IN pdqv_rec_type,
584: p_name IN okl_pdt_qualitys_v.name%TYPE,
585: x_return_status OUT NOCOPY VARCHAR2,
586: x_msg_count OUT NOCOPY NUMBER,

Line 597: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

593: WHERE pqy.name = cp_name;
594:
595: l_pdqv_rec pdqv_rec_type;
596: l_out_pdqv_rec pdqv_rec_type;
597: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
598: l_psy_count NUMBER := 0;
599: l_name okl_pdt_qualitys_v.name%TYPE;
600: l_pqy_id okl_pdt_qualitys_v.id%TYPE;
601:

Line 603: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

599: l_name okl_pdt_qualitys_v.name%TYPE;
600: l_pqy_id okl_pdt_qualitys_v.id%TYPE;
601:
602: BEGIN
603: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
604: l_pdqv_rec := p_pdqv_rec;
605: l_pdqv_rec := p_pdqv_rec;
606: l_name := p_name;
607:

Line 615: IF l_pqy_id <> Okl_Api.G_MISS_NUM AND l_pqy_id IS NOT NULL THEN

611: NULL;
612: END IF;
613: CLOSE get_pqy_csr;
614:
615: IF l_pqy_id <> Okl_Api.G_MISS_NUM AND l_pqy_id IS NOT NULL THEN
616:
617: --Default the dependent quality
618: l_pdqv_rec.pqy_id := l_pqy_id;
619:

Line 645: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

641: END IF;
642: -- End of wraper code generated automatically by Debug code generator for okl_pdt_pqys_pub.insert_pdt_pqys
643: END IF;
644:
645: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
646: x_return_status := Okl_Api.G_RET_STS_ERROR;
647: RAISE G_EXCEPTION_HALT_PROCESSING;
648: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
649: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 646: x_return_status := Okl_Api.G_RET_STS_ERROR;

642: -- End of wraper code generated automatically by Debug code generator for okl_pdt_pqys_pub.insert_pdt_pqys
643: END IF;
644:
645: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
646: x_return_status := Okl_Api.G_RET_STS_ERROR;
647: RAISE G_EXCEPTION_HALT_PROCESSING;
648: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
649: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
650: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 648: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

644:
645: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
646: x_return_status := Okl_Api.G_RET_STS_ERROR;
647: RAISE G_EXCEPTION_HALT_PROCESSING;
648: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
649: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
650: RAISE G_EXCEPTION_HALT_PROCESSING;
651: END IF;
652:

Line 649: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

645: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
646: x_return_status := Okl_Api.G_RET_STS_ERROR;
647: RAISE G_EXCEPTION_HALT_PROCESSING;
648: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
649: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
650: RAISE G_EXCEPTION_HALT_PROCESSING;
651: END IF;
652:
653: EXCEPTION

Line 661: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

657: NULL;
658:
659: WHEN OTHERS THEN
660: -- store SQL error message on message stack
661: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
662: p_msg_name => G_UNEXPECTED_ERROR,
663: p_token1 => G_SQLCODE_TOKEN,
664: p_token1_value => SQLCODE,
665: p_token2 => G_SQLERRM_TOKEN,

Line 668: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

664: p_token1_value => SQLCODE,
665: p_token2 => G_SQLERRM_TOKEN,
666: p_token2_value => SQLERRM );
667: -- notify UNEXPECTED error for calling API.
668: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
669:
670: END copy_dependent_qualitys;
671:
672: ---------------------------------------------------------------------------

Line 677: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

673: -- PROCEDURE insert_dqualitys for: Okl_Pdt_pqys_V
674: ---------------------------------------------------------------------------
675:
676: PROCEDURE insert_dqualitys(p_api_version IN NUMBER,
677: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
678: x_return_status OUT NOCOPY VARCHAR2,
679: x_msg_count OUT NOCOPY NUMBER,
680:
681: x_msg_data OUT NOCOPY VARCHAR2,

Line 704: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

700:
701:
702: l_api_version CONSTANT NUMBER := 1;
703: l_api_name CONSTANT VARCHAR2(30) := 'insert_dqualitys';
704: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
705: l_choosen_quality okl_pdt_qualitys_v.name%TYPE;
706: l_dependent_quality okl_pdt_qualitys_v.name%TYPE;
707: l_dependent_quality_cnt NUMBER(4):= 0;
708: l_valid BOOLEAN;

Line 714: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

710: l_ptlv_rec ptlv_rec_type;
711: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
712: l_row_notfound BOOLEAN := TRUE;
713: BEGIN
714: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
715: l_pdqv_rec := p_pdqv_rec;
716:
717: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
718: p_pkg_name => G_PKG_NAME,

Line 717: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

713: BEGIN
714: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
715: l_pdqv_rec := p_pdqv_rec;
716:
717: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
718: p_pkg_name => G_PKG_NAME,
719: p_init_msg_list => p_init_msg_list,
720: l_api_version => l_api_version,
721: p_api_version => p_api_version,

Line 725: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

721: p_api_version => p_api_version,
722: p_api_type => '_PVT',
723: x_return_status => l_return_status);
724:
725: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
726: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
727: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
728: RAISE Okl_Api.G_EXCEPTION_ERROR;
729: END IF;

Line 726: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

722: p_api_type => '_PVT',
723: x_return_status => l_return_status);
724:
725: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
726: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
727: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
728: RAISE Okl_Api.G_EXCEPTION_ERROR;
729: END IF;
730:

Line 727: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

723: x_return_status => l_return_status);
724:
725: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
726: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
727: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
728: RAISE Okl_Api.G_EXCEPTION_ERROR;
729: END IF;
730:
731: l_return_status := Validate_Attributes(l_pdqv_rec);

Line 728: RAISE Okl_Api.G_EXCEPTION_ERROR;

724:
725: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
726: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
727: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
728: RAISE Okl_Api.G_EXCEPTION_ERROR;
729: END IF;
730:
731: l_return_status := Validate_Attributes(l_pdqv_rec);
732: --- If any errors happen abort API

Line 733: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

729: END IF;
730:
731: l_return_status := Validate_Attributes(l_pdqv_rec);
732: --- If any errors happen abort API
733: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
734: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
736: RAISE Okl_Api.G_EXCEPTION_ERROR;
737: END IF;

Line 734: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

730:
731: l_return_status := Validate_Attributes(l_pdqv_rec);
732: --- If any errors happen abort API
733: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
734: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
736: RAISE Okl_Api.G_EXCEPTION_ERROR;
737: END IF;
738:

Line 735: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

731: l_return_status := Validate_Attributes(l_pdqv_rec);
732: --- If any errors happen abort API
733: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
734: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
736: RAISE Okl_Api.G_EXCEPTION_ERROR;
737: END IF;
738:
739: get_parent_dates(p_pdqv_rec => l_pdqv_rec,

Line 736: RAISE Okl_Api.G_EXCEPTION_ERROR;

732: --- If any errors happen abort API
733: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
734: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
736: RAISE Okl_Api.G_EXCEPTION_ERROR;
737: END IF;
738:
739: get_parent_dates(p_pdqv_rec => l_pdqv_rec,
740: x_no_data_found => l_row_notfound,

Line 745: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

741: x_return_status => l_return_status,
742: x_ptlv_rec => l_ptlv_rec);
743:
744: IF (l_row_notfound) THEN
745: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
746: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
747: RAISE Okl_Api.G_EXCEPTION_ERROR;
748: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
749: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 746: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

742: x_ptlv_rec => l_ptlv_rec);
743:
744: IF (l_row_notfound) THEN
745: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
746: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
747: RAISE Okl_Api.G_EXCEPTION_ERROR;
748: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
749: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
750: END IF;

Line 747: RAISE Okl_Api.G_EXCEPTION_ERROR;

743:
744: IF (l_row_notfound) THEN
745: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
746: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
747: RAISE Okl_Api.G_EXCEPTION_ERROR;
748: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
749: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
750: END IF;
751:

Line 748: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

744: IF (l_row_notfound) THEN
745: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
746: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
747: RAISE Okl_Api.G_EXCEPTION_ERROR;
748: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
749: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
750: END IF;
751:
752: --l_ptlv_rec := x_ptlv_rec;

Line 749: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

745: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
746: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
747: RAISE Okl_Api.G_EXCEPTION_ERROR;
748: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
749: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
750: END IF;
751:
752: --l_ptlv_rec := x_ptlv_rec;
753: --assign parent dates.

Line 768: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

764: x_msg_count => x_msg_count,
765: x_msg_data => x_msg_data,
766: x_valid => l_valid);
767:
768: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
770: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
771: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
772: l_valid <> TRUE) THEN

Line 769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

765: x_msg_data => x_msg_data,
766: x_valid => l_valid);
767:
768: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
770: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
771: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
772: l_valid <> TRUE) THEN
773:

Line 770: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR

766: x_valid => l_valid);
767:
768: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
770: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
771: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
772: l_valid <> TRUE) THEN
773:
774: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 771: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

767:
768: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
770: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
771: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
772: l_valid <> TRUE) THEN
773:
774: x_return_status := Okl_Api.G_RET_STS_ERROR;
775: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 774: x_return_status := Okl_Api.G_RET_STS_ERROR;

770: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
771: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
772: l_valid <> TRUE) THEN
773:
774: x_return_status := Okl_Api.G_RET_STS_ERROR;
775: RAISE Okl_Api.G_EXCEPTION_ERROR;
776: END IF;
777:
778: /* public api to insert dqualitys */

Line 775: RAISE Okl_Api.G_EXCEPTION_ERROR;

771: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
772: l_valid <> TRUE) THEN
773:
774: x_return_status := Okl_Api.G_RET_STS_ERROR;
775: RAISE Okl_Api.G_EXCEPTION_ERROR;
776: END IF;
777:
778: /* public api to insert dqualitys */
779: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys

Line 804: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

800: END;
801: END IF;
802: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys
803:
804: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
805: RAISE Okl_Api.G_EXCEPTION_ERROR;
806: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
807: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
808: END IF;

Line 805: RAISE Okl_Api.G_EXCEPTION_ERROR;

801: END IF;
802: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys
803:
804: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
805: RAISE Okl_Api.G_EXCEPTION_ERROR;
806: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
807: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
808: END IF;
809:

Line 806: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

802: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.insert_pdt_pqys
803:
804: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
805: RAISE Okl_Api.G_EXCEPTION_ERROR;
806: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
807: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
808: END IF;
809:
810: /* BEGIN --- commented by rajnisku bug 6398092

Line 807: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

803:
804: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
805: RAISE Okl_Api.G_EXCEPTION_ERROR;
806: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
807: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
808: END IF;
809:
810: /* BEGIN --- commented by rajnisku bug 6398092
811: OPEN choose_qualitys_csr(l_pdqv_rec.pqy_id);

Line 833: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

829: x_msg_count => x_msg_count,
830: x_msg_data => x_msg_data);
831: END LOOP;
832:
833: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
834: RAISE OKL_API.G_EXCEPTION_ERROR;
835: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
837: END IF;

Line 834: RAISE OKL_API.G_EXCEPTION_ERROR;

830: x_msg_data => x_msg_data);
831: END LOOP;
832:
833: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
834: RAISE OKL_API.G_EXCEPTION_ERROR;
835: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
837: END IF;
838: END IF;

Line 835: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

831: END LOOP;
832:
833: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
834: RAISE OKL_API.G_EXCEPTION_ERROR;
835: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
837: END IF;
838: END IF;
839: END;

Line 836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

832:
833: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
834: RAISE OKL_API.G_EXCEPTION_ERROR;
835: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
837: END IF;
838: END IF;
839: END;
840: */

Line 886: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

882: p_name => 'TAXOWNER',
883: x_return_status => l_return_status,
884: x_msg_count => x_msg_count,
885: x_msg_data => x_msg_data);
886: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
887: RAISE OKL_API.G_EXCEPTION_ERROR;
888: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
890: END IF;

Line 887: RAISE OKL_API.G_EXCEPTION_ERROR;

883: x_return_status => l_return_status,
884: x_msg_count => x_msg_count,
885: x_msg_data => x_msg_data);
886: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
887: RAISE OKL_API.G_EXCEPTION_ERROR;
888: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
890: END IF;
891: ELSIF l_choosen_quality = 'TAXOWNER' and l_dependent_quality_cnt = 0 THEN

Line 888: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

884: x_msg_count => x_msg_count,
885: x_msg_data => x_msg_data);
886: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
887: RAISE OKL_API.G_EXCEPTION_ERROR;
888: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
890: END IF;
891: ELSIF l_choosen_quality = 'TAXOWNER' and l_dependent_quality_cnt = 0 THEN
892: copy_dependent_qualitys(p_api_version => p_api_version,

Line 889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

885: x_msg_data => x_msg_data);
886: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
887: RAISE OKL_API.G_EXCEPTION_ERROR;
888: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
890: END IF;
891: ELSIF l_choosen_quality = 'TAXOWNER' and l_dependent_quality_cnt = 0 THEN
892: copy_dependent_qualitys(p_api_version => p_api_version,
893: p_init_msg_list => p_init_msg_list,

Line 899: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

895: p_name => 'LEASE',
896: x_return_status => l_return_status,
897: x_msg_count => x_msg_count,
898: x_msg_data => x_msg_data);
899: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
900: RAISE OKL_API.G_EXCEPTION_ERROR;
901: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
902: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
903: END IF;

Line 900: RAISE OKL_API.G_EXCEPTION_ERROR;

896: x_return_status => l_return_status,
897: x_msg_count => x_msg_count,
898: x_msg_data => x_msg_data);
899: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
900: RAISE OKL_API.G_EXCEPTION_ERROR;
901: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
902: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
903: END IF;
904: END IF;

Line 901: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

897: x_msg_count => x_msg_count,
898: x_msg_data => x_msg_data);
899: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
900: RAISE OKL_API.G_EXCEPTION_ERROR;
901: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
902: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
903: END IF;
904: END IF;
905: */

Line 902: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

898: x_msg_data => x_msg_data);
899: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
900: RAISE OKL_API.G_EXCEPTION_ERROR;
901: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
902: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
903: END IF;
904: END IF;
905: */
906: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

Line 906: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

902: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
903: END IF;
904: END IF;
905: */
906: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
907: x_msg_data => x_msg_data);
908: EXCEPTION
909: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
910: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 909: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

905: */
906: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
907: x_msg_data => x_msg_data);
908: EXCEPTION
909: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
910: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
911: p_pkg_name => G_PKG_NAME,
912: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
913: x_msg_count => x_msg_count,

Line 910: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

906: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
907: x_msg_data => x_msg_data);
908: EXCEPTION
909: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
910: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
911: p_pkg_name => G_PKG_NAME,
912: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
913: x_msg_count => x_msg_count,
914: x_msg_data => x_msg_data,

Line 912: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

908: EXCEPTION
909: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
910: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
911: p_pkg_name => G_PKG_NAME,
912: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
913: x_msg_count => x_msg_count,
914: x_msg_data => x_msg_data,
915: p_api_type => '_PVT');
916: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 916: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

912: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
913: x_msg_count => x_msg_count,
914: x_msg_data => x_msg_data,
915: p_api_type => '_PVT');
916: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
917:
918: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
919: p_pkg_name => G_PKG_NAME,
920: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 918: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

914: x_msg_data => x_msg_data,
915: p_api_type => '_PVT');
916: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
917:
918: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
919: p_pkg_name => G_PKG_NAME,
920: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
921: x_msg_count => x_msg_count,
922: x_msg_data => x_msg_data,

Line 920: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

916: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
917:
918: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
919: p_pkg_name => G_PKG_NAME,
920: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
921: x_msg_count => x_msg_count,
922: x_msg_data => x_msg_data,
923:
924: p_api_type => '_PVT');

Line 926: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

922: x_msg_data => x_msg_data,
923:
924: p_api_type => '_PVT');
925: WHEN OTHERS THEN
926: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
927: p_pkg_name => G_PKG_NAME,
928: p_exc_name => 'OTHERS',
929: x_msg_count => x_msg_count,
930: x_msg_data => x_msg_data,

Line 941: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

937: END insert_dqualitys;
938:
939:
940: PROCEDURE insert_dqualitys(p_api_version IN NUMBER,
941: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
942: x_return_status OUT NOCOPY VARCHAR2,
943: x_msg_count OUT NOCOPY NUMBER,
944:
945: x_msg_data OUT NOCOPY VARCHAR2,

Line 951: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

947: p_pdqv_tbl IN pdqv_tbl_type,
948: x_pdqv_tbl OUT NOCOPY pdqv_tbl_type
949: ) IS
950: l_api_name CONSTANT VARCHAR2(30) := 'insert_dqualitys';
951: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
952: i NUMBER := 0;
953: do_copy NUMBER := 0;
954: CURSOR copy_allowed_csr IS
955: select 1 from okl_pdt_qualitys pdtq ,okl_pdt_pqys pdt

Line 975: p_init_msg_list => OKL_API.G_FALSE,

971: i := p_pdqv_tbl.FIRST;
972: LOOP
973: insert_dqualitys(
974: p_api_version => p_api_version,
975: p_init_msg_list => OKL_API.G_FALSE,
976: x_return_status => x_return_status,
977: x_msg_count => x_msg_count,
978: x_msg_data => x_msg_data,
979: p_ptlv_rec => p_ptlv_rec,

Line 982: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN

978: x_msg_data => x_msg_data,
979: p_ptlv_rec => p_ptlv_rec,
980: p_pdqv_rec => p_pdqv_tbl(i),
981: x_pdqv_rec => x_pdqv_tbl(i));
982: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: ELSIF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
985: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
986: END IF;

Line 983: RAISE OKL_API.G_EXCEPTION_ERROR;

979: p_ptlv_rec => p_ptlv_rec,
980: p_pdqv_rec => p_pdqv_tbl(i),
981: x_pdqv_rec => x_pdqv_tbl(i));
982: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: ELSIF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
985: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
986: END IF;
987:

Line 984: ELSIF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

980: p_pdqv_rec => p_pdqv_tbl(i),
981: x_pdqv_rec => x_pdqv_tbl(i));
982: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: ELSIF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
985: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
986: END IF;
987:
988: EXIT WHEN (i = p_pdqv_tbl.LAST);

Line 985: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

981: x_pdqv_rec => x_pdqv_tbl(i));
982: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: ELSIF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
985: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
986: END IF;
987:
988: EXIT WHEN (i = p_pdqv_tbl.LAST);
989: i := p_pdqv_tbl.NEXT(i);

Line 1017: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1013: END ;
1014:
1015: END IF;
1016: EXCEPTION
1017: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1018: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1019: p_pkg_name => G_PKG_NAME,
1020: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1021: x_msg_count => x_msg_count,

Line 1018: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1014:
1015: END IF;
1016: EXCEPTION
1017: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1018: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1019: p_pkg_name => G_PKG_NAME,
1020: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1021: x_msg_count => x_msg_count,
1022: x_msg_data => x_msg_data,

Line 1020: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1016: EXCEPTION
1017: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1018: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1019: p_pkg_name => G_PKG_NAME,
1020: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1021: x_msg_count => x_msg_count,
1022: x_msg_data => x_msg_data,
1023: p_api_type => '_PVT');
1024: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1024: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1020: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1021: x_msg_count => x_msg_count,
1022: x_msg_data => x_msg_data,
1023: p_api_type => '_PVT');
1024: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1025:
1026: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1027: p_pkg_name => G_PKG_NAME,
1028: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1026: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1022: x_msg_data => x_msg_data,
1023: p_api_type => '_PVT');
1024: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1025:
1026: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1027: p_pkg_name => G_PKG_NAME,
1028: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1029: x_msg_count => x_msg_count,
1030: x_msg_data => x_msg_data,

Line 1028: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1024: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1025:
1026: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1027: p_pkg_name => G_PKG_NAME,
1028: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1029: x_msg_count => x_msg_count,
1030: x_msg_data => x_msg_data,
1031:
1032: p_api_type => '_PVT');

Line 1034: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1030: x_msg_data => x_msg_data,
1031:
1032: p_api_type => '_PVT');
1033: WHEN OTHERS THEN
1034: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1035: p_pkg_name => G_PKG_NAME,
1036: p_exc_name => 'OTHERS',
1037: x_msg_count => x_msg_count,
1038: x_msg_data => x_msg_data,

Line 1062: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1058: ,p_ptlv_rec IN ptlv_rec_type
1059: ,p_pdqv_rec IN pdqv_rec_type) IS
1060:
1061: i PLS_INTEGER :=0;
1062: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1063: l_del_pqvv_tbl Okl_Pqy_Values_Pub.pqvv_tbl_type;
1064:
1065: CURSOR pqv_csr IS
1066: SELECT pqvv.id

Line 1101: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1097: END;
1098: END IF;
1099: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.delete_pqy_values
1100:
1101: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1102: RAISE G_EXCEPTION_HALT_PROCESSING;
1103: ELSE
1104: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1105:

Line 1104: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1100:
1101: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1102: RAISE G_EXCEPTION_HALT_PROCESSING;
1103: ELSE
1104: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1105:
1106: l_return_status := x_return_status;
1107: END IF;
1108: END IF;

Line 1130: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1126: END;
1127: END IF;
1128: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Pqys_Pub.delete_pdt_pqys
1129:
1130: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1131: RAISE G_EXCEPTION_HALT_PROCESSING;
1132: ELSE
1133: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1134: l_return_status := x_return_status;

Line 1133: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1129:
1130: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1131: RAISE G_EXCEPTION_HALT_PROCESSING;
1132: ELSE
1133: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1134: l_return_status := x_return_status;
1135: END IF;
1136: END IF;
1137: EXCEPTION

Line 1142: Okl_Api.SET_MESSAGE(p_app_name => g_app_name

1138: WHEN G_EXCEPTION_HALT_PROCESSING THEN
1139:
1140: NULL;
1141: WHEN OTHERS THEN
1142: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
1143: ,p_msg_name => g_unexpected_error
1144: ,p_token1 => g_sqlcode_token
1145: ,p_token1_value => SQLCODE
1146: ,p_token2 => g_sqlerrm_token

Line 1149: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1145: ,p_token1_value => SQLCODE
1146: ,p_token2 => g_sqlerrm_token
1147: ,p_token2_value => SQLERRM);
1148:
1149: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1150: END delete_pdt_pqys;
1151:
1152: ---------------------------------------------------------------------------
1153: -- PROCEDURE delete_dqualitys for: Okl_Pdt_pqys_V

Line 1173: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1169:
1170: l_api_name CONSTANT VARCHAR2(30) := 'delete_dqualitys';
1171: l_pdqv_rec pdqv_rec_type;
1172: l_valid BOOLEAN;
1173: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1174: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS; --TCHGS
1175:
1176: j PLS_INTEGER :=0;
1177: id_count number(10):=0;

Line 1174: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS; --TCHGS

1170: l_api_name CONSTANT VARCHAR2(30) := 'delete_dqualitys';
1171: l_pdqv_rec pdqv_rec_type;
1172: l_valid BOOLEAN;
1173: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1174: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS; --TCHGS
1175:
1176: j PLS_INTEGER :=0;
1177: id_count number(10):=0;
1178: other_id number;

Line 1219: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1215: l_pdqv_tbl(x).Id := id;
1216: End;
1217:
1218: BEGIN
1219: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1220: l_pdqv_tbl := p_pdqv_tbl;
1221: l_ptlv_rec := p_ptlv_rec;
1222:
1223: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

Line 1223: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

1219: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1220: l_pdqv_tbl := p_pdqv_tbl;
1221: l_ptlv_rec := p_ptlv_rec;
1222:
1223: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
1224: p_pkg_name => G_PKG_NAME,
1225: p_init_msg_list => p_init_msg_list,
1226: l_api_version => l_api_version,
1227: p_api_version => p_api_version,

Line 1231: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1227: p_api_version => p_api_version,
1228: p_api_type => '_PVT',
1229: x_return_status => l_return_status);
1230:
1231: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1233: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1234: RAISE Okl_Api.G_EXCEPTION_ERROR;
1235: END IF;

Line 1232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1228: p_api_type => '_PVT',
1229: x_return_status => l_return_status);
1230:
1231: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1233: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1234: RAISE Okl_Api.G_EXCEPTION_ERROR;
1235: END IF;
1236:

Line 1233: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1229: x_return_status => l_return_status);
1230:
1231: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1233: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1234: RAISE Okl_Api.G_EXCEPTION_ERROR;
1235: END IF;
1236:
1237:

Line 1234: RAISE Okl_Api.G_EXCEPTION_ERROR;

1230:
1231: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1233: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1234: RAISE Okl_Api.G_EXCEPTION_ERROR;
1235: END IF;
1236:
1237:
1238: IF (l_pdqv_tbl.COUNT > 0) THEN

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

1288: x_msg_count => x_msg_count,
1289: x_msg_data => x_msg_data,
1290: x_valid => l_valid);
1291:
1292: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1293:
1294: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1295: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
1296: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

Line 1294: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1290: x_valid => l_valid);
1291:
1292: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1293:
1294: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1295: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
1296: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
1297: l_valid <> TRUE) THEN
1298:

Line 1295: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR

1291:
1292: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1293:
1294: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1295: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
1296: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
1297: l_valid <> TRUE) THEN
1298:
1299: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 1296: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

1292: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1293:
1294: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1295: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
1296: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
1297: l_valid <> TRUE) THEN
1298:
1299: x_return_status := Okl_Api.G_RET_STS_ERROR;
1300: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1299: x_return_status := Okl_Api.G_RET_STS_ERROR;

1295: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
1296: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
1297: l_valid <> TRUE) THEN
1298:
1299: x_return_status := Okl_Api.G_RET_STS_ERROR;
1300: RAISE Okl_Api.G_EXCEPTION_ERROR;
1301: END IF;
1302:
1303:

Line 1300: RAISE Okl_Api.G_EXCEPTION_ERROR;

1296: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
1297: l_valid <> TRUE) THEN
1298:
1299: x_return_status := Okl_Api.G_RET_STS_ERROR;
1300: RAISE Okl_Api.G_EXCEPTION_ERROR;
1301: END IF;
1302:
1303:
1304: delete_pdt_pqys(

Line 1314: IF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR

1310: ,p_ptlv_rec => l_ptlv_rec
1311: ,p_pdqv_rec => l_pdqv_tbl(i)
1312: );
1313: -- store the highest degree of error
1314: IF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
1315: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
1316: l_valid <> TRUE) THEN
1317: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1318: l_overall_status := l_return_status;

Line 1315: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

1311: ,p_pdqv_rec => l_pdqv_tbl(i)
1312: );
1313: -- store the highest degree of error
1314: IF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
1315: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
1316: l_valid <> TRUE) THEN
1317: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1318: l_overall_status := l_return_status;
1319: END IF;

Line 1317: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1313: -- store the highest degree of error
1314: IF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
1315: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
1316: l_valid <> TRUE) THEN
1317: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1318: l_overall_status := l_return_status;
1319: END IF;
1320: END IF;
1321:

Line 1330: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

1326: --TCHGS: return overall status
1327: x_return_status := l_overall_status;
1328: END IF;
1329:
1330: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
1331: x_msg_data => x_msg_data);
1332:
1333: EXCEPTION
1334: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 1334: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1330: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
1331: x_msg_data => x_msg_data);
1332:
1333: EXCEPTION
1334: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1335: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1336: p_pkg_name => G_PKG_NAME,
1337: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1338: x_msg_count => x_msg_count,

Line 1335: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1331: x_msg_data => x_msg_data);
1332:
1333: EXCEPTION
1334: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1335: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1336: p_pkg_name => G_PKG_NAME,
1337: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1338: x_msg_count => x_msg_count,
1339: x_msg_data => x_msg_data,

Line 1337: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1333: EXCEPTION
1334: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1335: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1336: p_pkg_name => G_PKG_NAME,
1337: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1338: x_msg_count => x_msg_count,
1339: x_msg_data => x_msg_data,
1340: p_api_type => '_PVT');
1341: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1341: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1337: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1338: x_msg_count => x_msg_count,
1339: x_msg_data => x_msg_data,
1340: p_api_type => '_PVT');
1341: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1342: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1343: p_pkg_name => G_PKG_NAME,
1344: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1345: x_msg_count => x_msg_count,

Line 1342: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1338: x_msg_count => x_msg_count,
1339: x_msg_data => x_msg_data,
1340: p_api_type => '_PVT');
1341: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1342: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1343: p_pkg_name => G_PKG_NAME,
1344: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1345: x_msg_count => x_msg_count,
1346: x_msg_data => x_msg_data,

Line 1344: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1340: p_api_type => '_PVT');
1341: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1342: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1343: p_pkg_name => G_PKG_NAME,
1344: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1345: x_msg_count => x_msg_count,
1346: x_msg_data => x_msg_data,
1347: p_api_type => '_PVT');
1348: WHEN OTHERS THEN

Line 1349: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1345: x_msg_count => x_msg_count,
1346: x_msg_data => x_msg_data,
1347: p_api_type => '_PVT');
1348: WHEN OTHERS THEN
1349: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1350: p_pkg_name => G_PKG_NAME,
1351: p_exc_name => 'OTHERS',
1352: x_msg_count => x_msg_count,
1353: x_msg_data => x_msg_data,