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 OKL_DEBUG_PUB

Line 29: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

25: lx_achr_tbl achr_tbl_type;
26:
27: -- for debug logging
28: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'advance_contract_search';
29: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
30: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
31: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
32:
33: BEGIN

Line 30: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

26:
27: -- for debug logging
28: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'advance_contract_search';
29: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
30: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
31: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
32:
33: BEGIN
34:

Line 31: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

27: -- for debug logging
28: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'advance_contract_search';
29: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
30: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
31: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
32:
33: BEGIN
34:
35: SAVEPOINT trx_adv_contract_search;

Line 38: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

34:
35: SAVEPOINT trx_adv_contract_search;
36:
37: IF (is_debug_procedure_on) THEN
38: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
39: END IF;
40:
41: l_api_version := p_api_version ;
42: l_init_msg_list := p_init_msg_list ;

Line 61: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

57: x_achr_tbl => lx_achr_tbl);
58:
59:
60: IF (is_debug_statement_on) 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

Line 78: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

74: x_msg_data := l_msg_data ;
75: x_achr_tbl := lx_achr_tbl;
76:
77: IF (is_debug_procedure_on) THEN
78: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
79: END IF;
80:
81: EXCEPTION
82:

Line 85: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');

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:
88: ROLLBACK TO trx_adv_contract_search;
89: x_return_status := FND_API.G_RET_STS_ERROR;

Line 98: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'UNEXPECTED');

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;
100:
101: ROLLBACK TO trx_adv_contract_search;
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 110: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '

106: p_count => x_msg_count
107: ,p_data => x_msg_data);
108: WHEN OTHERS THEN
109: IF (is_debug_exception_on) THEN
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;

Line 151: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

147: lx_assn_tbl assn_tbl_type;
148: lx_tqlv_tbl tqlv_tbl_type;
149: -- for debug logging
150: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'create_terminate_quote';
151: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
152: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
153: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
154:
155: BEGIN

Line 152: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

148: lx_tqlv_tbl tqlv_tbl_type;
149: -- for debug logging
150: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'create_terminate_quote';
151: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
152: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
153: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
154:
155: BEGIN
156: SAVEPOINT trx_create_terminate_quote;

Line 153: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

149: -- for debug logging
150: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'create_terminate_quote';
151: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
152: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
153: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
154:
155: BEGIN
156: SAVEPOINT trx_create_terminate_quote;
157:

Line 159: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

155: BEGIN
156: SAVEPOINT trx_create_terminate_quote;
157:
158: IF (is_debug_procedure_on) THEN
159: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
160: END IF;
161:
162: l_api_version := p_api_version ;
163: l_init_msg_list := p_init_msg_list ;

Line 192: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

188: ,x_assn_tbl => lx_assn_tbl
189: ,x_tqlv_tbl => lx_tqlv_tbl);
190:
191: IF (is_debug_statement_on) 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

Line 219: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

215: x_assn_tbl := lx_assn_tbl;
216: x_tqlv_tbl := lx_tqlv_tbl;
217:
218: IF (is_debug_procedure_on) THEN
219: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
220: END IF;
221:
222: EXCEPTION
223:

Line 226: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');

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;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: x_msg_count := l_msg_count ;

Line 237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'UNEXPECTED');

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;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: x_msg_count := l_msg_count ;

Line 248: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '

244: p_count => x_msg_count
245: ,p_data => x_msg_data);
246: WHEN OTHERS THEN
247: IF (is_debug_exception_on) THEN
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;