DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PUB dependencies on OKL_AM_TERMNT_QUOTE_PUB

Line 1: PACKAGE BODY OKL_AM_TERMNT_QUOTE_PUB AS

1: PACKAGE BODY OKL_AM_TERMNT_QUOTE_PUB AS
2: /* $Header: OKLPTNQB.pls 120.4 2007/12/14 14:03:02 nikshah ship $ */
3:
4: -- GLOBAL VARIABLES
5: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_am_termnt_quote_pub.';

4: -- GLOBAL VARIABLES
5: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_am_termnt_quote_pub.';
9:
10: --Bug #3921591: pagarg +++ Rollover +++
11: -- additional parameter has been added to the call, to identify the acceptance source
12: PROCEDURE terminate_quote(

Line 181: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB','terminate_quote');

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(
183: p_count => x_msg_count
184: ,p_data => x_msg_data);
185: IF (is_debug_exception_on) THEN

Line 369: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB','terminate_quote');

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(
371: p_count => x_msg_count
372: ,p_data => x_msg_data);
373: IF (is_debug_exception_on) THEN

Line 534: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB','submit_for_approval');

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(
536: p_count => x_msg_count
537: ,p_data => x_msg_data);
538: IF (is_debug_exception_on) THEN

Line 610: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB','check_assset_sno_sav');

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);
614: END IF;

Line 714: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB','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(
716: p_count => x_msg_count
717: ,p_data => x_msg_data);
718: IF (is_debug_exception_on) THEN

Line 874: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);

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(
876: p_count => x_msg_count,
877: p_data => x_msg_data);
878: IF (is_debug_exception_on) THEN

Line 1038: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);

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(
1040: p_count => x_msg_count,
1041: p_data => x_msg_data);
1042: IF (is_debug_exception_on) THEN

Line 1197: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);

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(
1199: p_count => x_msg_count,
1200: p_data => x_msg_data);
1201: IF (is_debug_exception_on) THEN

Line 1361: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);

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(
1363: p_count => x_msg_count,
1364: p_data => x_msg_data);
1365: IF (is_debug_exception_on) THEN

Line 1489: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);

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(
1491: p_count => x_msg_count,
1492: p_data => x_msg_data);
1493: IF (is_debug_exception_on) THEN

Line 1621: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_TERMNT_QUOTE_PUB',l_api_name);

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(
1623: p_count => x_msg_count,
1624: p_data => x_msg_data);
1625: IF (is_debug_exception_on) THEN

Line 1632: END OKL_AM_TERMNT_QUOTE_PUB;

1628: END IF;
1629:
1630: END delete_quote_line;
1631:
1632: END OKL_AM_TERMNT_QUOTE_PUB;