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_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 198: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

Line 199: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 226: WHEN FND_API.G_EXC_ERROR THEN

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

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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