DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PUB dependencies on FND_API

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

61: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
62: 'after call to OKL_AM_CREATE_QUOTE_PVT.advance_contract_search :'||l_return_status);
63: END IF;
64:
65: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
66: RAISE FND_API.G_EXC_ERROR;
67: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;

Line 66: RAISE FND_API.G_EXC_ERROR;

62: 'after call to OKL_AM_CREATE_QUOTE_PVT.advance_contract_search :'||l_return_status);
63: END IF;
64:
65: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
66: RAISE FND_API.G_EXC_ERROR;
67: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70:

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

63: END IF;
64:
65: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
66: RAISE FND_API.G_EXC_ERROR;
67: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70:
71: --Assign value to OUT variables

Line 68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

64:
65: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
66: RAISE FND_API.G_EXC_ERROR;
67: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70:
71: --Assign value to OUT variables
72: x_return_status := l_return_status ;

Line 83: WHEN FND_API.G_EXC_ERROR THEN

79: END IF;
80:
81: EXCEPTION
82:
83: WHEN FND_API.G_EXC_ERROR THEN
84: IF (is_debug_exception_on) THEN
85: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
86: END IF;
87:

Line 89: x_return_status := FND_API.G_RET_STS_ERROR;

85: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
86: END IF;
87:
88: ROLLBACK TO trx_adv_contract_search;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: x_msg_count := l_msg_count ;
91: x_msg_data := l_msg_data ;
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count

Line 95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

91: x_msg_data := l_msg_data ;
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96:
97: IF (is_debug_exception_on) THEN
98: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'UNEXPECTED');
99: END IF;

Line 102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

98: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'UNEXPECTED');
99: END IF;
100:
101: ROLLBACK TO trx_adv_contract_search;
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
103: x_msg_count := l_msg_count ;
104: x_msg_data := l_msg_data ;
105: FND_MSG_PUB.count_and_get(
106: p_count => x_msg_count

Line 114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

110: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
111: || sqlcode || ' , SQLERRM : ' || sqlerrm);
112: END IF;
113: ROLLBACK TO trx_adv_contract_search;
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: x_msg_count := l_msg_count ;
116: x_msg_data := l_msg_data ;
117: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_CREATE_QUOTE_PUB','advance_contract_search');
118: FND_MSG_PUB.count_and_get(

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

192: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
193: 'after call to OKL_AM_CREATE_QUOTE_PVT.create_terminate_quote :'||l_return_status);
194: END IF;
195:
196: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
197: RAISE FND_API.G_EXC_ERROR;
198: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;

Line 197: RAISE FND_API.G_EXC_ERROR;

193: 'after call to OKL_AM_CREATE_QUOTE_PVT.create_terminate_quote :'||l_return_status);
194: END IF;
195:
196: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
197: RAISE FND_API.G_EXC_ERROR;
198: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:

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

194: END IF;
195:
196: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
197: RAISE FND_API.G_EXC_ERROR;
198: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202:

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195:
196: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
197: RAISE FND_API.G_EXC_ERROR;
198: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202:
203: --Copy value of OUT record type variable in the IN record type

Line 224: WHEN FND_API.G_EXC_ERROR THEN

220: END IF;
221:
222: EXCEPTION
223:
224: WHEN FND_API.G_EXC_ERROR THEN
225: IF (is_debug_exception_on) THEN
226: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
227: END IF;
228: ROLLBACK TO trx_create_terminate_quote;

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: IF (is_debug_exception_on) THEN
226: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
227: END IF;
228: ROLLBACK TO trx_create_terminate_quote;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: x_msg_count := l_msg_count ;
231: x_msg_data := l_msg_data ;
232: FND_MSG_PUB.count_and_get(
233: p_count => x_msg_count

Line 235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

231: x_msg_data := l_msg_data ;
232: FND_MSG_PUB.count_and_get(
233: p_count => x_msg_count
234: ,p_data => x_msg_data);
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: IF (is_debug_exception_on) THEN
237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'UNEXPECTED');
238: END IF;
239: ROLLBACK TO trx_create_terminate_quote;

Line 240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

236: IF (is_debug_exception_on) THEN
237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'UNEXPECTED');
238: END IF;
239: ROLLBACK TO trx_create_terminate_quote;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: x_msg_count := l_msg_count ;
242: x_msg_data := l_msg_data ;
243: FND_MSG_PUB.count_and_get(
244: p_count => x_msg_count

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

248: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
249: || sqlcode || ' , SQLERRM : ' || sqlerrm);
250: END IF;
251: ROLLBACK TO trx_create_terminate_quote;
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: x_msg_count := l_msg_count ;
254: x_msg_data := l_msg_data ;
255: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_CREATE_QUOTE_PUB','create_terminate_quote');
256: FND_MSG_PUB.count_and_get(