DBA Data[Home] [Help]

APPS.OKL_CS_CREATE_QUOTE_PVT dependencies on OKL_AM_CREATE_QUOTE_PUB

Line 22: p_assn_tbl IN OKL_AM_CREATE_QUOTE_PUB.assn_tbl_type,

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,
22: p_assn_tbl IN OKL_AM_CREATE_QUOTE_PUB.assn_tbl_type,
23: p_qpyv_tbl IN qpyv_tbl_type DEFAULT G_EMPTY_QPYV_TBL,
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

Line 25: x_tqlv_tbl OUT NOCOPY OKL_AM_CREATE_QUOTE_PUB.tqlv_tbl_type,

21: p_quot_tbl IN quot_tbl_type,
22: p_assn_tbl IN OKL_AM_CREATE_QUOTE_PUB.assn_tbl_type,
23: p_qpyv_tbl IN qpyv_tbl_type DEFAULT G_EMPTY_QPYV_TBL,
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;

Line 26: x_assn_tbl OUT NOCOPY OKL_AM_CREATE_QUOTE_PUB.assn_tbl_type)AS

22: p_assn_tbl IN OKL_AM_CREATE_QUOTE_PUB.assn_tbl_type,
23: p_qpyv_tbl IN qpyv_tbl_type DEFAULT G_EMPTY_QPYV_TBL,
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;

Line 48: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.create_terminate_quote with parameters: ');

44: IF (p_quot_tbl.COUNT > 0) THEN
45: i := p_quot_tbl.FIRST;
46: LOOP
47: IF (is_debug_statement_on) THEN
48: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.create_terminate_quote with parameters: ');
49: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).id : '||p_quot_tbl(i).id );
50: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).qrs_code : '||p_quot_tbl(i).qrs_code );
51: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).qst_code : '||p_quot_tbl(i).qst_code );
52: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).consolidated_qte_id : '||p_quot_tbl(i).consolidated_qte_id );

Line 126: okl_am_create_quote_pub.create_terminate_quote(

122: End loop;
123:
124: END IF;
125: END IF;
126: okl_am_create_quote_pub.create_terminate_quote(
127: p_api_version => p_api_version,
128: p_init_msg_list => FND_API.G_FALSE,
129: x_return_status => x_return_status,
130: x_msg_count => x_msg_count,

Line 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);

135: x_quot_rec => x_quot_tbl(i),
136: x_tqlv_tbl => x_tqlv_tbl,
137: x_assn_tbl => x_assn_tbl);
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

Line 189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.fetch_rule_quote_parties with parameters: ');

185: IF (p_qtev_tbl.COUNT > 0) THEN
186: i := p_qtev_tbl.FIRST;
187: LOOP
188: IF (is_debug_statement_on) THEN
189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.fetch_rule_quote_parties with parameters: ');
190: IF p_qtev_tbl.count > 0 THEN
191: FOR k IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
192: IF p_qtev_tbl.exists(k) THEN
193: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).id = ' || p_qtev_tbl(k).id );

Line 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);

333: x_qpyv_tbl => x_qpyv_tbl,
334: x_q_party_uv_tbl => x_q_party_uv_tbl,
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');

Line 385: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.submit_for_approval with parameters: ');

381: IF (p_term_tbl.COUNT > 0) THEN
382: i := p_term_tbl.FIRST;
383: LOOP
384: IF (is_debug_statement_on) THEN
385: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.submit_for_approval with parameters: ');
386: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).id : '||p_term_tbl(i).id );
387: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).qrs_code : '||p_term_tbl(i).qrs_code );
388: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).qst_code : '||p_term_tbl(i).qst_code );
389: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).consolidated_qte_id : '||p_term_tbl(i).consolidated_qte_id );

Line 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);

429: x_msg_data => x_msg_data,
430: p_term_rec => p_term_tbl(i),
431: x_term_rec => x_term_tbl(i));
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

Line 483: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.send_terminate_quote with parameters: ');

479: IF (p_qtev_tbl.COUNT > 0) THEN
480: i := p_qtev_tbl.FIRST;
481: LOOP
482: IF (is_debug_statement_on) THEN
483: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.send_terminate_quote with parameters: ');
484: IF p_qtev_tbl.COUNT > 0 THEN
485: FOR k IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
486: IF p_qtev_tbl.exists(k) THEN
487: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).id = ' || p_qtev_tbl(k).id );

Line 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);

670: p_qtev_rec => p_qtev_tbl(i),
671: x_qtev_rec => x_qtev_tbl(i));
672:
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