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_CS_CREATE_QUOTE_PUB dependencies on OKL_API

Line 10: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

6: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_cs_create_quote_pub.';
7:
8: PROCEDURE create_terminate_quote(
9: p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_quot_tbl IN quot_tbl_type,

Line 21: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

17: x_quot_tbl OUT NOCOPY quot_tbl_type,
18: x_tqlv_tbl OUT NOCOPY OKL_AM_CREATE_QUOTE_PUB.tqlv_tbl_type,
19: x_assn_tbl OUT NOCOPY OKL_AM_CREATE_QUOTE_PUB.assn_tbl_type)AS
20:
21: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
22: l_msg_count NUMBER;
23: l_msg_data VARCHAR2(2000);
24:
25: l_request_id NUMBER;

Line 140: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

136:
137: IF (is_debug_statement_on) THEN
138: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_cs_create_quote_pvt.create_terminate_quote , return status: ' || l_return_status);
139: END IF;
140: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
141: IF (is_debug_exception_on) THEN
142: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
143: END IF;
144: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 144: RAISE OKL_API.G_EXCEPTION_ERROR;

140: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
141: IF (is_debug_exception_on) THEN
142: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
143: END IF;
144: RAISE OKL_API.G_EXCEPTION_ERROR;
145: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
146: IF (is_debug_exception_on) THEN
147: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
148: END IF;

Line 145: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

141: IF (is_debug_exception_on) THEN
142: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
143: END IF;
144: RAISE OKL_API.G_EXCEPTION_ERROR;
145: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
146: IF (is_debug_exception_on) THEN
147: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
148: END IF;
149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

145: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
146: IF (is_debug_exception_on) THEN
147: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
148: END IF;
149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
150: END IF;
151:
152: ------------ End Call to Private Process API--------------
153: x_return_status := l_return_status;

Line 159: WHEN OKL_API.G_EXCEPTION_ERROR THEN

155: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End (-)');
156: END IF;
157: EXCEPTION
158:
159: WHEN OKL_API.G_EXCEPTION_ERROR THEN
160: --ROLLBACK TO create_terminate_quote;
161: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
162: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
163: p_data => x_msg_data);

Line 161: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

157: EXCEPTION
158:
159: WHEN OKL_API.G_EXCEPTION_ERROR THEN
160: --ROLLBACK TO create_terminate_quote;
161: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
162: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
163: p_data => x_msg_data);
164:
165: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 165: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

161: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
162: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
163: p_data => x_msg_data);
164:
165: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
166: --ROLLBACK TO create_terminate_quote;
167: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
168: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
169: p_data => x_msg_data);

Line 167: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

163: p_data => x_msg_data);
164:
165: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
166: --ROLLBACK TO create_terminate_quote;
167: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
168: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
169: p_data => x_msg_data);
170:
171: WHEN OTHERS THEN

Line 173: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

169: p_data => x_msg_data);
170:
171: WHEN OTHERS THEN
172: --ROLLBACK TO create_terminate_quote;
173: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
174: FND_MSG_PUB.ADD_EXC_MSG('OKL_CS_CREATE_QUOTE_PUB','create_terminate_quote');
175: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
176: p_data => x_msg_data);
177: