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_PVT dependencies on OKC_API

Line 17: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

13: -- the pl/sql table and so the record api is called only once.
14: --------------------------------------------------------
15: PROCEDURE create_terminate_quote(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2,
21: p_quot_tbl IN quot_tbl_type,

Line 28: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

24: x_quot_tbl OUT NOCOPY quot_tbl_type,
25: x_tqlv_tbl OUT NOCOPY OKL_AM_CREATE_QUOTE_PUB.tqlv_tbl_type,
26: x_assn_tbl OUT NOCOPY OKL_AM_CREATE_QUOTE_PUB.assn_tbl_type)AS
27:
28: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
29: i NUMBER := 0;
30: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
31:
32: -- asawanka added for debug feature start

Line 30: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

26: x_assn_tbl OUT NOCOPY OKL_AM_CREATE_QUOTE_PUB.assn_tbl_type)AS
27:
28: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
29: i NUMBER := 0;
30: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
31:
32: -- asawanka added for debug feature start
33: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_terminate_quote';
34: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 43: OKC_API.init_msg_list(p_init_msg_list);

39: IF (is_debug_procedure_on) THEN
40: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
41: END IF;
42:
43: OKC_API.init_msg_list(p_init_msg_list);
44: IF (p_quot_tbl.COUNT > 0) THEN
45: i := p_quot_tbl.FIRST;
46: LOOP
47: IF (is_debug_statement_on) THEN

Line 142: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

138: IF (is_debug_statement_on) THEN
139: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_create_quote_pub.create_terminate_quote , return status: ' || x_return_status);
140: END IF;
141:
142: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
143: IF (is_debug_exception_on) THEN
144: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
145: END IF;
146: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

Line 146: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

142: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
143: IF (is_debug_exception_on) THEN
144: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
145: END IF;
146: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
147: l_overall_status := x_return_status;
148: END IF;
149: END IF;
150: EXIT WHEN (i = p_quot_tbl.LAST);

Line 173: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

169: x_q_party_uv_tbl OUT NOCOPY okl_am_parties_pvt.q_party_uv_tbl_type,
170: x_record_count OUT NOCOPY NUMBER)
171: IS
172: i NUMBER := 0;
173: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
174: -- asawanka added for debug feature start
175: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'fetch_rule_quote_parties';
176: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
177: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 184: OKC_API.init_msg_list(p_init_msg_list);

180: BEGIN
181: IF (is_debug_procedure_on) THEN
182: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
183: END IF;
184: OKC_API.init_msg_list(p_init_msg_list);
185: IF (p_qtev_tbl.COUNT > 0) THEN
186: i := p_qtev_tbl.FIRST;
187: LOOP
188: IF (is_debug_statement_on) THEN

Line 339: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

335: x_record_count => x_record_count);
336: IF (is_debug_statement_on) THEN
337: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_create_quote_pub.fetch_rule_quote_parties , return status: ' || x_return_status);
338: END IF;
339: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
340: IF (is_debug_exception_on) THEN
341: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
342: END IF;
343: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

Line 343: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

339: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
340: IF (is_debug_exception_on) THEN
341: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
342: END IF;
343: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
344: l_overall_status := x_return_status;
345: END IF;
346: END IF;
347: EXIT WHEN (i = p_qtev_tbl.LAST);

Line 367: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

363: x_msg_data OUT NOCOPY VARCHAR2,
364: p_term_tbl IN quot_tbl_type,
365: x_term_tbl OUT NOCOPY quot_tbl_type) AS
366:
367: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
368: i NUMBER := 0;
369: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
370: -- asawanka added for debug feature start
371: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'submit_for_approval';

Line 369: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

365: x_term_tbl OUT NOCOPY quot_tbl_type) AS
366:
367: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
368: i NUMBER := 0;
369: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
370: -- asawanka added for debug feature start
371: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'submit_for_approval';
372: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
373: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 380: OKC_API.init_msg_list(p_init_msg_list);

376: BEGIN
377: IF (is_debug_procedure_on) THEN
378: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
379: END IF;
380: OKC_API.init_msg_list(p_init_msg_list);
381: IF (p_term_tbl.COUNT > 0) THEN
382: i := p_term_tbl.FIRST;
383: LOOP
384: IF (is_debug_statement_on) THEN

Line 436: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

432: IF (is_debug_statement_on) THEN
433: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_create_quote_pub.submit_for_approval , return status: ' || x_return_status);
434: END IF;
435:
436: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
437: IF (is_debug_exception_on) THEN
438: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
439: END IF;
440: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

Line 440: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

436: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
437: IF (is_debug_exception_on) THEN
438: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
439: END IF;
440: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
441: l_overall_status := x_return_status;
442: END IF;
443: END IF;
444: EXIT WHEN (i = p_term_tbl.LAST);

Line 465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

461: x_party_tbl OUT NOCOPY okl_am_parties_pvt.q_party_uv_tbl_type,
462: p_qtev_tbl IN quot_tbl_type,
463: x_qtev_tbl OUT NOCOPY quot_tbl_type) as
464:
465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
466: i NUMBER := 0;
467: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
468: -- asawanka added for debug feature start
469: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'send_terminate_quote';

Line 467: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

463: x_qtev_tbl OUT NOCOPY quot_tbl_type) as
464:
465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
466: i NUMBER := 0;
467: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
468: -- asawanka added for debug feature start
469: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'send_terminate_quote';
470: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
471: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 478: OKC_API.init_msg_list(p_init_msg_list);

474: BEGIN
475: IF (is_debug_procedure_on) THEN
476: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
477: END IF;
478: OKC_API.init_msg_list(p_init_msg_list);
479: IF (p_qtev_tbl.COUNT > 0) THEN
480: i := p_qtev_tbl.FIRST;
481: LOOP
482: IF (is_debug_statement_on) THEN

Line 677: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

673: IF (is_debug_statement_on) THEN
674: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_create_quote_pub.send_terminate_quote , return status: ' || x_return_status);
675: END IF;
676:
677: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
678: IF (is_debug_exception_on) THEN
679: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
680: END IF;
681: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

Line 681: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

677: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
678: IF (is_debug_exception_on) THEN
679: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
680: END IF;
681: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
682: l_overall_status := x_return_status;
683: END IF;
684: END IF;
685: EXIT WHEN (i = p_qtev_tbl.LAST);