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_AM_TERMNT_QUOTE_PUB dependencies on FND_API

Line 131: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

127: IF (is_debug_statement_on) THEN
128: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.terminate_quote , return status: ' || l_return_status);
129: END IF;
130:
131: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
132: RAISE FND_API.G_EXC_ERROR;
133: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;

Line 132: RAISE FND_API.G_EXC_ERROR;

128: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.terminate_quote , return status: ' || l_return_status);
129: END IF;
130:
131: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
132: RAISE FND_API.G_EXC_ERROR;
133: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:

Line 133: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

129: END IF;
130:
131: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
132: RAISE FND_API.G_EXC_ERROR;
133: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:
137: --Copy value of OUT record type variable in the IN record type

Line 134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

130:
131: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
132: RAISE FND_API.G_EXC_ERROR;
133: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:
137: --Copy value of OUT record type variable in the IN record type
138: lp_term_rec := lx_term_rec;

Line 154: WHEN FND_API.G_EXC_ERROR THEN

150: END IF;
151:
152: EXCEPTION
153:
154: WHEN FND_API.G_EXC_ERROR THEN
155: ROLLBACK TO trx_terminate_quote;
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: x_msg_count := l_msg_count ;
158: x_msg_data := l_msg_data ;

Line 156: x_return_status := FND_API.G_RET_STS_ERROR;

152: EXCEPTION
153:
154: WHEN FND_API.G_EXC_ERROR THEN
155: ROLLBACK TO trx_terminate_quote;
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: x_msg_count := l_msg_count ;
158: x_msg_data := l_msg_data ;
159: FND_MSG_PUB.count_and_get(
160: p_count => x_msg_count

Line 165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

161: ,p_data => x_msg_data);
162: IF (is_debug_exception_on) THEN
163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
164: END IF;
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: ROLLBACK TO trx_terminate_quote;
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: x_msg_count := l_msg_count ;
169: x_msg_data := l_msg_data ;

Line 167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
164: END IF;
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: ROLLBACK TO trx_terminate_quote;
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: x_msg_count := l_msg_count ;
169: x_msg_data := l_msg_data ;
170: FND_MSG_PUB.count_and_get(
171: p_count => x_msg_count

Line 178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

174: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');
175: END IF;
176: WHEN OTHERS THEN
177: ROLLBACK TO trx_terminate_quote;
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179: x_msg_count := l_msg_count ;
180: x_msg_data := l_msg_data ;
181: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB','terminate_quote');
182: FND_MSG_PUB.count_and_get(

Line 319: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

315: IF (is_debug_statement_on) THEN
316: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.terminate_quote , return status: ' || l_return_status);
317: END IF;
318:
319: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
320: RAISE FND_API.G_EXC_ERROR;
321: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;

Line 320: RAISE FND_API.G_EXC_ERROR;

316: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.terminate_quote , return status: ' || l_return_status);
317: END IF;
318:
319: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
320: RAISE FND_API.G_EXC_ERROR;
321: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:

Line 321: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

317: END IF;
318:
319: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
320: RAISE FND_API.G_EXC_ERROR;
321: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325: --Copy value of OUT record type variable in the IN record type

Line 322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

318:
319: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
320: RAISE FND_API.G_EXC_ERROR;
321: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325: --Copy value of OUT record type variable in the IN record type
326: lp_term_tbl := lx_term_tbl;

Line 342: WHEN FND_API.G_EXC_ERROR THEN

338: END IF;
339:
340: EXCEPTION
341:
342: WHEN FND_API.G_EXC_ERROR THEN
343: ROLLBACK TO trx_terminate_quote;
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: x_msg_count := l_msg_count ;
346: x_msg_data := l_msg_data ;

Line 344: x_return_status := FND_API.G_RET_STS_ERROR;

340: EXCEPTION
341:
342: WHEN FND_API.G_EXC_ERROR THEN
343: ROLLBACK TO trx_terminate_quote;
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: x_msg_count := l_msg_count ;
346: x_msg_data := l_msg_data ;
347: FND_MSG_PUB.count_and_get(
348: p_count => x_msg_count

Line 353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

349: ,p_data => x_msg_data);
350: IF (is_debug_exception_on) THEN
351: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
352: END IF;
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK TO trx_terminate_quote;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: x_msg_count := l_msg_count ;
357: x_msg_data := l_msg_data ;

Line 355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

351: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
352: END IF;
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK TO trx_terminate_quote;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: x_msg_count := l_msg_count ;
357: x_msg_data := l_msg_data ;
358: FND_MSG_PUB.count_and_get(
359: p_count => x_msg_count

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

362: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');
363: END IF;
364: WHEN OTHERS THEN
365: ROLLBACK TO trx_terminate_quote;
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: x_msg_count := l_msg_count ;
368: x_msg_data := l_msg_data ;
369: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB','terminate_quote');
370: FND_MSG_PUB.count_and_get(

Line 487: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

483: IF (is_debug_statement_on) THEN
484: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.submit_for_approval , return status: ' || l_return_status);
485: END IF;
486:
487: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;

Line 488: RAISE FND_API.G_EXC_ERROR;

484: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.submit_for_approval , return status: ' || l_return_status);
485: END IF;
486:
487: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;
492:

Line 489: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

485: END IF;
486:
487: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;
492:
493: --Copy value of OUT record type variable in the IN record type

Line 490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

486:
487: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;
492:
493: --Copy value of OUT record type variable in the IN record type
494: lp_term_rec := lx_term_rec;

Line 507: WHEN FND_API.G_EXC_ERROR THEN

503: END IF;
504:
505: EXCEPTION
506:
507: WHEN FND_API.G_EXC_ERROR THEN
508: ROLLBACK TO submit_for_approval;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: x_msg_count := l_msg_count ;
511: x_msg_data := l_msg_data ;

Line 509: x_return_status := FND_API.G_RET_STS_ERROR;

505: EXCEPTION
506:
507: WHEN FND_API.G_EXC_ERROR THEN
508: ROLLBACK TO submit_for_approval;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: x_msg_count := l_msg_count ;
511: x_msg_data := l_msg_data ;
512: FND_MSG_PUB.count_and_get(
513: p_count => x_msg_count

Line 518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

514: ,p_data => x_msg_data);
515: IF (is_debug_exception_on) THEN
516: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
517: END IF;
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: ROLLBACK TO submit_for_approval;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: x_msg_count := l_msg_count ;
522: x_msg_data := l_msg_data ;

Line 520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

516: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
517: END IF;
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: ROLLBACK TO submit_for_approval;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: x_msg_count := l_msg_count ;
522: x_msg_data := l_msg_data ;
523: FND_MSG_PUB.count_and_get(
524: p_count => x_msg_count

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

527: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');
528: END IF;
529: WHEN OTHERS THEN
530: ROLLBACK TO submit_for_approval;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: x_msg_count := l_msg_count ;
533: x_msg_data := l_msg_data ;
534: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB','submit_for_approval');
535: FND_MSG_PUB.count_and_get(

Line 551: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;

547: x_clev_tbl OUT NOCOPY clev_tbl_type) RETURN VARCHAR2 IS
548: l_clev_tbl clev_tbl_type;
549: l_asset_line OKL_K_LINES.ID%TYPE;
550: l_sno_yn VARCHAR(3);
551: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;
552: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_asset_sno';
553: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
554: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
555: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

Line 579: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

575: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.check_asset_sno , return status: ' || l_return_status);
576: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_sno_yn: ' || l_sno_yn);
577: END IF;
578:
579: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
580: RAISE FND_API.G_EXC_ERROR;
581: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: END IF;

Line 580: RAISE FND_API.G_EXC_ERROR;

576: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_sno_yn: ' || l_sno_yn);
577: END IF;
578:
579: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
580: RAISE FND_API.G_EXC_ERROR;
581: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: END IF;
584: --Assign value to OUT variables

Line 581: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

577: END IF;
578:
579: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
580: RAISE FND_API.G_EXC_ERROR;
581: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: END IF;
584: --Assign value to OUT variables
585: x_sno_yn := l_sno_yn;

Line 582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

578:
579: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
580: RAISE FND_API.G_EXC_ERROR;
581: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: END IF;
584: --Assign value to OUT variables
585: x_sno_yn := l_sno_yn;
586: x_clev_tbl := l_clev_tbl;

Line 593: WHEN FND_API.G_EXC_ERROR THEN

589: END IF;
590:
591: RETURN l_return_status;
592: EXCEPTION
593: WHEN FND_API.G_EXC_ERROR THEN
594: ROLLBACK TO check_assset_sno_sav;
595: l_return_status := FND_API.G_RET_STS_ERROR;
596: IF (is_debug_exception_on) THEN
597: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');

Line 595: l_return_status := FND_API.G_RET_STS_ERROR;

591: RETURN l_return_status;
592: EXCEPTION
593: WHEN FND_API.G_EXC_ERROR THEN
594: ROLLBACK TO check_assset_sno_sav;
595: l_return_status := FND_API.G_RET_STS_ERROR;
596: IF (is_debug_exception_on) THEN
597: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
598: END IF;
599: RETURN l_return_status;

Line 600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

596: IF (is_debug_exception_on) THEN
597: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
598: END IF;
599: RETURN l_return_status;
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: ROLLBACK TO check_assset_sno_sav;
602: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: IF (is_debug_exception_on) THEN
604: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');

Line 602: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

598: END IF;
599: RETURN l_return_status;
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: ROLLBACK TO check_assset_sno_sav;
602: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: IF (is_debug_exception_on) THEN
604: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');
605: END IF;
606: RETURN l_return_status;

Line 609: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

605: END IF;
606: RETURN l_return_status;
607: WHEN OTHERS THEN
608: ROLLBACK TO check_assset_sno_sav;
609: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB','check_assset_sno_sav');
611: IF (is_debug_exception_on) THEN
612: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
613: || sqlcode || ' , SQLERRM : ' || sqlerrm);

Line 629: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;

625: l_init_msg_list VARCHAR2(3) ;
626: l_msg_count NUMBER ;
627: l_msg_data VARCHAR2(2000);
628: l_qld_tbl qte_ln_dtl_tbl;
629: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;
630: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'quote_line_dtls';
631: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
632: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
633: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

Line 671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

667: IF (is_debug_statement_on) THEN
668: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.quote_line_dtls , return status: ' || l_return_status);
669: END IF;
670:
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;

Line 672: RAISE FND_API.G_EXC_ERROR;

668: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.quote_line_dtls , return status: ' || l_return_status);
669: END IF;
670:
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: --Assign value to OUT variables

Line 673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

669: END IF;
670:
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: --Assign value to OUT variables
677: p_qld_tbl := l_qld_tbl;

Line 674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

670:
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: --Assign value to OUT variables
677: p_qld_tbl := l_qld_tbl;
678: x_return_status := l_return_status ;

Line 686: WHEN FND_API.G_EXC_ERROR THEN

682: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
683: END IF;
684:
685: EXCEPTION
686: WHEN FND_API.G_EXC_ERROR THEN
687: ROLLBACK TO quote_line_dtls;
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: x_msg_count := l_msg_count ;
690: x_msg_data := l_msg_data ;

Line 688: x_return_status := FND_API.G_RET_STS_ERROR;

684:
685: EXCEPTION
686: WHEN FND_API.G_EXC_ERROR THEN
687: ROLLBACK TO quote_line_dtls;
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: x_msg_count := l_msg_count ;
690: x_msg_data := l_msg_data ;
691: FND_MSG_PUB.count_and_get(
692: p_count => x_msg_count

Line 697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

693: ,p_data => x_msg_data);
694: IF (is_debug_exception_on) THEN
695: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
696: END IF;
697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: ROLLBACK TO quote_line_dtls;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: x_msg_count := l_msg_count ;
701: x_msg_data := l_msg_data ;

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
696: END IF;
697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: ROLLBACK TO quote_line_dtls;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: x_msg_count := l_msg_count ;
701: x_msg_data := l_msg_data ;
702: FND_MSG_PUB.count_and_get(
703: p_count => x_msg_count

Line 710: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');
707: END IF;
708: WHEN OTHERS THEN
709: ROLLBACK TO quote_line_dtls;
710: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: x_msg_count := l_msg_count ;
713: x_msg_data := l_msg_data ;
714: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB','quote_line_dtls');

Line 711: x_return_status := FND_API.G_RET_STS_ERROR;

707: END IF;
708: WHEN OTHERS THEN
709: ROLLBACK TO quote_line_dtls;
710: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: x_msg_count := l_msg_count ;
713: x_msg_data := l_msg_data ;
714: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB','quote_line_dtls');
715: FND_MSG_PUB.count_and_get(

Line 824: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

820: END IF;
821:
822:
823: -- raise exception if error
824: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
826: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;

Line 825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

821:
822:
823: -- raise exception if error
824: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
826: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829:

Line 826: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

822:
823: -- raise exception if error
824: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
826: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829:
830:

Line 827: RAISE FND_API.G_EXC_ERROR;

823: -- raise exception if error
824: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
826: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829:
830:
831: -- Assign value to OUT variables

Line 842: WHEN FND_API.G_EXC_ERROR THEN

838: END IF;
839:
840: EXCEPTION
841:
842: WHEN FND_API.G_EXC_ERROR THEN
843:
844: ROLLBACK TO trx_create_quote_line;
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: x_msg_count := l_msg_count ;

Line 845: x_return_status := FND_API.G_RET_STS_ERROR;

841:
842: WHEN FND_API.G_EXC_ERROR THEN
843:
844: ROLLBACK TO trx_create_quote_line;
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: x_msg_count := l_msg_count ;
847: x_msg_data := l_msg_data ;
848: FND_MSG_PUB.count_and_get(
849: p_count => x_msg_count,

Line 855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

851: IF (is_debug_exception_on) THEN
852: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
853: END IF;
854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
856:
857: ROLLBACK TO trx_create_quote_line;
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: x_msg_count := l_msg_count ;

Line 858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
856:
857: ROLLBACK TO trx_create_quote_line;
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: x_msg_count := l_msg_count ;
860: x_msg_data := l_msg_data ;
861: FND_MSG_PUB.count_and_get(
862: p_count => x_msg_count,

Line 871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

867:
868: WHEN OTHERS THEN
869:
870: ROLLBACK TO trx_create_quote_line;
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
872: x_msg_count := l_msg_count ;
873: x_msg_data := l_msg_data ;
874: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);
875: FND_MSG_PUB.count_and_get(

Line 988: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

984: END IF;
985:
986:
987: -- raise exception if error
988: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;

Line 989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

985:
986:
987: -- raise exception if error
988: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;
993:

Line 990: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

986:
987: -- raise exception if error
988: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;
993:
994:

Line 991: RAISE FND_API.G_EXC_ERROR;

987: -- raise exception if error
988: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;
993:
994:
995: -- Assign value to OUT variables

Line 1006: WHEN FND_API.G_EXC_ERROR THEN

1002: END IF;
1003:
1004: EXCEPTION
1005:
1006: WHEN FND_API.G_EXC_ERROR THEN
1007:
1008: ROLLBACK TO trx_create_quote_line;
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: x_msg_count := l_msg_count ;

Line 1009: x_return_status := FND_API.G_RET_STS_ERROR;

1005:
1006: WHEN FND_API.G_EXC_ERROR THEN
1007:
1008: ROLLBACK TO trx_create_quote_line;
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: x_msg_count := l_msg_count ;
1011: x_msg_data := l_msg_data ;
1012: FND_MSG_PUB.count_and_get(
1013: p_count => x_msg_count,

Line 1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1015: IF (is_debug_exception_on) THEN
1016: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
1017: END IF;
1018:
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020:
1021: ROLLBACK TO trx_create_quote_line;
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023: x_msg_count := l_msg_count ;

Line 1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1018:
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020:
1021: ROLLBACK TO trx_create_quote_line;
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023: x_msg_count := l_msg_count ;
1024: x_msg_data := l_msg_data ;
1025: FND_MSG_PUB.count_and_get(
1026: p_count => x_msg_count,

Line 1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1031:
1032: WHEN OTHERS THEN
1033:
1034: ROLLBACK TO trx_create_quote_line;
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: x_msg_count := l_msg_count ;
1037: x_msg_data := l_msg_data ;
1038: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);
1039: FND_MSG_PUB.count_and_get(

Line 1147: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1143: END IF;
1144:
1145:
1146: -- raise exception if error
1147: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;

Line 1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1144:
1145:
1146: -- raise exception if error
1147: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152:

Line 1149: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1145:
1146: -- raise exception if error
1147: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152:
1153:

Line 1150: RAISE FND_API.G_EXC_ERROR;

1146: -- raise exception if error
1147: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152:
1153:
1154: -- Assign value to OUT variables

Line 1165: WHEN FND_API.G_EXC_ERROR THEN

1161: END IF;
1162:
1163: EXCEPTION
1164:
1165: WHEN FND_API.G_EXC_ERROR THEN
1166:
1167: ROLLBACK TO trx_update_quote_line;
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169: x_msg_count := l_msg_count ;

Line 1168: x_return_status := FND_API.G_RET_STS_ERROR;

1164:
1165: WHEN FND_API.G_EXC_ERROR THEN
1166:
1167: ROLLBACK TO trx_update_quote_line;
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169: x_msg_count := l_msg_count ;
1170: x_msg_data := l_msg_data ;
1171: FND_MSG_PUB.count_and_get(
1172: p_count => x_msg_count,

Line 1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1174: IF (is_debug_exception_on) THEN
1175: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
1176: END IF;
1177:
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179:
1180: ROLLBACK TO trx_update_quote_line;
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182: x_msg_count := l_msg_count ;

Line 1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1177:
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179:
1180: ROLLBACK TO trx_update_quote_line;
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182: x_msg_count := l_msg_count ;
1183: x_msg_data := l_msg_data ;
1184: FND_MSG_PUB.count_and_get(
1185: p_count => x_msg_count,

Line 1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1190:
1191: WHEN OTHERS THEN
1192:
1193: ROLLBACK TO trx_update_quote_line;
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1195: x_msg_count := l_msg_count ;
1196: x_msg_data := l_msg_data ;
1197: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);
1198: FND_MSG_PUB.count_and_get(

Line 1311: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1307: END IF;
1308:
1309:
1310: -- raise exception if error
1311: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1313: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: END IF;

Line 1312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1308:
1309:
1310: -- raise exception if error
1311: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1313: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: END IF;
1316:

Line 1313: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1309:
1310: -- raise exception if error
1311: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1313: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: END IF;
1316:
1317:

Line 1314: RAISE FND_API.G_EXC_ERROR;

1310: -- raise exception if error
1311: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1313: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: END IF;
1316:
1317:
1318: -- Assign value to OUT variables

Line 1329: WHEN FND_API.G_EXC_ERROR THEN

1325: END IF;
1326:
1327: EXCEPTION
1328:
1329: WHEN FND_API.G_EXC_ERROR THEN
1330:
1331: ROLLBACK TO trx_update_quote_line;
1332: x_return_status := FND_API.G_RET_STS_ERROR;
1333: x_msg_count := l_msg_count ;

Line 1332: x_return_status := FND_API.G_RET_STS_ERROR;

1328:
1329: WHEN FND_API.G_EXC_ERROR THEN
1330:
1331: ROLLBACK TO trx_update_quote_line;
1332: x_return_status := FND_API.G_RET_STS_ERROR;
1333: x_msg_count := l_msg_count ;
1334: x_msg_data := l_msg_data ;
1335: FND_MSG_PUB.count_and_get(
1336: p_count => x_msg_count,

Line 1342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1338: IF (is_debug_exception_on) THEN
1339: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
1340: END IF;
1341:
1342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1343:
1344: ROLLBACK TO trx_update_quote_line;
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: x_msg_count := l_msg_count ;

Line 1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1341:
1342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1343:
1344: ROLLBACK TO trx_update_quote_line;
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: x_msg_count := l_msg_count ;
1347: x_msg_data := l_msg_data ;
1348: FND_MSG_PUB.count_and_get(
1349: p_count => x_msg_count,

Line 1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1354:
1355: WHEN OTHERS THEN
1356:
1357: ROLLBACK TO trx_update_quote_line;
1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1359: x_msg_count := l_msg_count ;
1360: x_msg_data := l_msg_data ;
1361: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);
1362: FND_MSG_PUB.count_and_get(

Line 1440: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1436: END IF;
1437:
1438:
1439: -- raise exception if error
1440: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1443: RAISE FND_API.G_EXC_ERROR;
1444: END IF;

Line 1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1437:
1438:
1439: -- raise exception if error
1440: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1443: RAISE FND_API.G_EXC_ERROR;
1444: END IF;
1445:

Line 1442: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1438:
1439: -- raise exception if error
1440: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1443: RAISE FND_API.G_EXC_ERROR;
1444: END IF;
1445:
1446:

Line 1443: RAISE FND_API.G_EXC_ERROR;

1439: -- raise exception if error
1440: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1443: RAISE FND_API.G_EXC_ERROR;
1444: END IF;
1445:
1446:
1447: -- Assign value to OUT variables

Line 1457: WHEN FND_API.G_EXC_ERROR THEN

1453: END IF;
1454:
1455: EXCEPTION
1456:
1457: WHEN FND_API.G_EXC_ERROR THEN
1458:
1459: ROLLBACK TO trx_delete_quote_line;
1460: x_return_status := FND_API.G_RET_STS_ERROR;
1461: x_msg_count := l_msg_count ;

Line 1460: x_return_status := FND_API.G_RET_STS_ERROR;

1456:
1457: WHEN FND_API.G_EXC_ERROR THEN
1458:
1459: ROLLBACK TO trx_delete_quote_line;
1460: x_return_status := FND_API.G_RET_STS_ERROR;
1461: x_msg_count := l_msg_count ;
1462: x_msg_data := l_msg_data ;
1463: FND_MSG_PUB.count_and_get(
1464: p_count => x_msg_count,

Line 1470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1466: IF (is_debug_exception_on) THEN
1467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
1468: END IF;
1469:
1470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1471:
1472: ROLLBACK TO trx_delete_quote_line;
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: x_msg_count := l_msg_count ;

Line 1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1469:
1470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1471:
1472: ROLLBACK TO trx_delete_quote_line;
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: x_msg_count := l_msg_count ;
1475: x_msg_data := l_msg_data ;
1476: FND_MSG_PUB.count_and_get(
1477: p_count => x_msg_count,

Line 1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1482:
1483: WHEN OTHERS THEN
1484:
1485: ROLLBACK TO trx_delete_quote_line;
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1487: x_msg_count := l_msg_count ;
1488: x_msg_data := l_msg_data ;
1489: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);
1490: FND_MSG_PUB.count_and_get(

Line 1573: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1569: END IF;
1570:
1571:
1572: -- raise exception if error
1573: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1575: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;

Line 1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1570:
1571:
1572: -- raise exception if error
1573: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1575: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;
1578:

Line 1575: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1571:
1572: -- raise exception if error
1573: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1575: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;
1578:
1579:

Line 1576: RAISE FND_API.G_EXC_ERROR;

1572: -- raise exception if error
1573: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1575: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;
1578:
1579:
1580: -- Assign value to OUT variables

Line 1589: WHEN FND_API.G_EXC_ERROR THEN

1585: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1586: END IF;
1587: EXCEPTION
1588:
1589: WHEN FND_API.G_EXC_ERROR THEN
1590:
1591: ROLLBACK TO trx_delete_quote_line;
1592: x_return_status := FND_API.G_RET_STS_ERROR;
1593: x_msg_count := l_msg_count ;

Line 1592: x_return_status := FND_API.G_RET_STS_ERROR;

1588:
1589: WHEN FND_API.G_EXC_ERROR THEN
1590:
1591: ROLLBACK TO trx_delete_quote_line;
1592: x_return_status := FND_API.G_RET_STS_ERROR;
1593: x_msg_count := l_msg_count ;
1594: x_msg_data := l_msg_data ;
1595: FND_MSG_PUB.count_and_get(
1596: p_count => x_msg_count,

Line 1602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1598: IF (is_debug_exception_on) THEN
1599: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
1600: END IF;
1601:
1602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1603:
1604: ROLLBACK TO trx_delete_quote_line;
1605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1606: x_msg_count := l_msg_count ;

Line 1605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1601:
1602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1603:
1604: ROLLBACK TO trx_delete_quote_line;
1605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1606: x_msg_count := l_msg_count ;
1607: x_msg_data := l_msg_data ;
1608: FND_MSG_PUB.count_and_get(
1609: p_count => x_msg_count,

Line 1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1614:
1615: WHEN OTHERS THEN
1616:
1617: ROLLBACK TO trx_delete_quote_line;
1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1619: x_msg_count := l_msg_count ;
1620: x_msg_data := l_msg_data ;
1621: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);
1622: FND_MSG_PUB.count_and_get(