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_CONSOLIDATED_QTE_PVT dependencies on OKL_DEBUG_PUB

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

45: i NUMBER;
46: lp_qtev_tbl qtev_tbl_type := p_qtev_tbl;
47: lx_qtev_tbl qtev_tbl_type := p_qtev_tbl;
48: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_and_set_database_values';
49: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
50: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
51: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
52:
53:

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

46: lp_qtev_tbl qtev_tbl_type := p_qtev_tbl;
47: lx_qtev_tbl qtev_tbl_type := p_qtev_tbl;
48: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_and_set_database_values';
49: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
50: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
51: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
52:
53:
54: BEGIN

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

47: lx_qtev_tbl qtev_tbl_type := p_qtev_tbl;
48: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_and_set_database_values';
49: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
50: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
51: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
52:
53:
54: BEGIN
55: IF (is_debug_procedure_on) THEN

Line 56: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

52:
53:
54: BEGIN
55: IF (is_debug_procedure_on) THEN
56: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
57: END IF;
58: IF (is_debug_statement_on) THEN
59: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
60: IF (p_qtev_tbl.exists(i)) THEN

Line 61: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);

57: END IF;
58: IF (is_debug_statement_on) THEN
59: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
60: IF (p_qtev_tbl.exists(i)) THEN
61: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
62: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
63: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
64: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
65: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);

Line 62: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);

58: IF (is_debug_statement_on) THEN
59: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
60: IF (p_qtev_tbl.exists(i)) THEN
61: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
62: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
63: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
64: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
65: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
66: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);

Line 63: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);

59: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
60: IF (p_qtev_tbl.exists(i)) THEN
61: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
62: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
63: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
64: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
65: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
66: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
67: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);

Line 64: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);

60: IF (p_qtev_tbl.exists(i)) THEN
61: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
62: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
63: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
64: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
65: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
66: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
67: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
68: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);

Line 65: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);

61: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
62: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
63: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
64: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
65: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
66: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
67: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
68: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);

Line 66: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);

62: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
63: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
64: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
65: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
66: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
67: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
68: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);

Line 67: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);

63: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
64: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
65: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
66: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
67: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
68: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
71: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);

Line 68: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);

64: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
65: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
66: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
67: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
68: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
71: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
72: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);

Line 69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);

65: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
66: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
67: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
68: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
71: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
72: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
73: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);

Line 70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);

66: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
67: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
68: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
71: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
72: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
73: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
74: END IF;

Line 71: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);

67: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
68: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
71: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
72: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
73: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
74: END IF;
75: END LOOP;

Line 72: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);

68: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
71: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
72: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
73: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
74: END IF;
75: END LOOP;
76: END IF;

Line 73: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);

69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
71: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
72: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
73: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
74: END IF;
75: END LOOP;
76: END IF;
77:

Line 163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');

159: -- Set the return status
160: x_return_status := l_return_status;
161: x_qtev_tbl := lx_qtev_tbl;
162: IF (is_debug_procedure_on) THEN
163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
164: END IF;
165:
166: EXCEPTION
167: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 169: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_HALT_VALIDATION');

165:
166: EXCEPTION
167: WHEN G_EXCEPTION_HALT_VALIDATION THEN
168: IF (is_debug_exception_on) THEN
169: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_HALT_VALIDATION');
170: END IF;
171:
172: IF get_quote_values_csr%ISOPEN THEN
173: CLOSE get_quote_values_csr;

Line 180: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

176: x_return_status := OKL_API.G_RET_STS_ERROR;
177:
178: WHEN OTHERS THEN
179: IF (is_debug_exception_on) THEN
180: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
181: || sqlcode || ' , SQLERRM : ' || sqlerrm);
182: END IF;
183:
184: IF get_quote_values_csr%ISOPEN THEN

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

214: l_quote_reason VARCHAR2(200) := 'EOT';
215: l_sys_date DATE;
216: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
217: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_consolidated_quote_rec';
218: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
219: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
220: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
221:
222: BEGIN

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

215: l_sys_date DATE;
216: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
217: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_consolidated_quote_rec';
218: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
219: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
220: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
221:
222: BEGIN
223: IF (is_debug_procedure_on) THEN

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

216: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
217: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_consolidated_quote_rec';
218: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
219: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
220: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
221:
222: BEGIN
223: IF (is_debug_procedure_on) THEN
224: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

Line 224: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

220: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
221:
222: BEGIN
223: IF (is_debug_procedure_on) THEN
224: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
225: END IF;
226: IF (is_debug_statement_on) THEN
227: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_from: ' || p_qtev_rec.date_effective_from);
228: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_to: ' || p_qtev_rec.date_effective_to);

Line 227: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_from: ' || p_qtev_rec.date_effective_from);

223: IF (is_debug_procedure_on) THEN
224: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
225: END IF;
226: IF (is_debug_statement_on) THEN
227: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_from: ' || p_qtev_rec.date_effective_from);
228: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_to: ' || p_qtev_rec.date_effective_to);
229: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_requested: ' || p_qtev_rec.date_requested);
230: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_proposal: ' || p_qtev_rec.date_proposal);
231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qtp_code: ' || p_qtev_rec.qtp_code);

Line 228: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_to: ' || p_qtev_rec.date_effective_to);

224: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
225: END IF;
226: IF (is_debug_statement_on) THEN
227: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_from: ' || p_qtev_rec.date_effective_from);
228: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_to: ' || p_qtev_rec.date_effective_to);
229: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_requested: ' || p_qtev_rec.date_requested);
230: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_proposal: ' || p_qtev_rec.date_proposal);
231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qtp_code: ' || p_qtev_rec.qtp_code);
232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qst_code: ' || p_qtev_rec.qst_code);

Line 229: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_requested: ' || p_qtev_rec.date_requested);

225: END IF;
226: IF (is_debug_statement_on) THEN
227: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_from: ' || p_qtev_rec.date_effective_from);
228: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_to: ' || p_qtev_rec.date_effective_to);
229: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_requested: ' || p_qtev_rec.date_requested);
230: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_proposal: ' || p_qtev_rec.date_proposal);
231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qtp_code: ' || p_qtev_rec.qtp_code);
232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qst_code: ' || p_qtev_rec.qst_code);
233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qrs_code: ' || p_qtev_rec.qrs_code);

Line 230: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_proposal: ' || p_qtev_rec.date_proposal);

226: IF (is_debug_statement_on) THEN
227: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_from: ' || p_qtev_rec.date_effective_from);
228: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_to: ' || p_qtev_rec.date_effective_to);
229: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_requested: ' || p_qtev_rec.date_requested);
230: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_proposal: ' || p_qtev_rec.date_proposal);
231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qtp_code: ' || p_qtev_rec.qtp_code);
232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qst_code: ' || p_qtev_rec.qst_code);
233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qrs_code: ' || p_qtev_rec.qrs_code);
234: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.early_termination_yn: ' || p_qtev_rec.early_termination_yn);

Line 231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qtp_code: ' || p_qtev_rec.qtp_code);

227: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_from: ' || p_qtev_rec.date_effective_from);
228: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_to: ' || p_qtev_rec.date_effective_to);
229: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_requested: ' || p_qtev_rec.date_requested);
230: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_proposal: ' || p_qtev_rec.date_proposal);
231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qtp_code: ' || p_qtev_rec.qtp_code);
232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qst_code: ' || p_qtev_rec.qst_code);
233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qrs_code: ' || p_qtev_rec.qrs_code);
234: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.early_termination_yn: ' || p_qtev_rec.early_termination_yn);
235: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.partial_yn: ' || p_qtev_rec.partial_yn);

Line 232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qst_code: ' || p_qtev_rec.qst_code);

228: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_effective_to: ' || p_qtev_rec.date_effective_to);
229: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_requested: ' || p_qtev_rec.date_requested);
230: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_proposal: ' || p_qtev_rec.date_proposal);
231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qtp_code: ' || p_qtev_rec.qtp_code);
232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qst_code: ' || p_qtev_rec.qst_code);
233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qrs_code: ' || p_qtev_rec.qrs_code);
234: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.early_termination_yn: ' || p_qtev_rec.early_termination_yn);
235: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.partial_yn: ' || p_qtev_rec.partial_yn);
236: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.consolidated_yn: ' || p_qtev_rec.consolidated_yn);

Line 233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qrs_code: ' || p_qtev_rec.qrs_code);

229: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_requested: ' || p_qtev_rec.date_requested);
230: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_proposal: ' || p_qtev_rec.date_proposal);
231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qtp_code: ' || p_qtev_rec.qtp_code);
232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qst_code: ' || p_qtev_rec.qst_code);
233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qrs_code: ' || p_qtev_rec.qrs_code);
234: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.early_termination_yn: ' || p_qtev_rec.early_termination_yn);
235: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.partial_yn: ' || p_qtev_rec.partial_yn);
236: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.consolidated_yn: ' || p_qtev_rec.consolidated_yn);
237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.accepted_yn: ' || p_qtev_rec.accepted_yn);

Line 234: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.early_termination_yn: ' || p_qtev_rec.early_termination_yn);

230: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.date_proposal: ' || p_qtev_rec.date_proposal);
231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qtp_code: ' || p_qtev_rec.qtp_code);
232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qst_code: ' || p_qtev_rec.qst_code);
233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qrs_code: ' || p_qtev_rec.qrs_code);
234: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.early_termination_yn: ' || p_qtev_rec.early_termination_yn);
235: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.partial_yn: ' || p_qtev_rec.partial_yn);
236: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.consolidated_yn: ' || p_qtev_rec.consolidated_yn);
237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.accepted_yn: ' || p_qtev_rec.accepted_yn);
238: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.approved_yn: ' || p_qtev_rec.approved_yn);

Line 235: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.partial_yn: ' || p_qtev_rec.partial_yn);

231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qtp_code: ' || p_qtev_rec.qtp_code);
232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qst_code: ' || p_qtev_rec.qst_code);
233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qrs_code: ' || p_qtev_rec.qrs_code);
234: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.early_termination_yn: ' || p_qtev_rec.early_termination_yn);
235: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.partial_yn: ' || p_qtev_rec.partial_yn);
236: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.consolidated_yn: ' || p_qtev_rec.consolidated_yn);
237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.accepted_yn: ' || p_qtev_rec.accepted_yn);
238: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.approved_yn: ' || p_qtev_rec.approved_yn);
239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.preproceeds_yn: ' || p_qtev_rec.preproceeds_yn);

Line 236: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.consolidated_yn: ' || p_qtev_rec.consolidated_yn);

232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qst_code: ' || p_qtev_rec.qst_code);
233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qrs_code: ' || p_qtev_rec.qrs_code);
234: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.early_termination_yn: ' || p_qtev_rec.early_termination_yn);
235: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.partial_yn: ' || p_qtev_rec.partial_yn);
236: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.consolidated_yn: ' || p_qtev_rec.consolidated_yn);
237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.accepted_yn: ' || p_qtev_rec.accepted_yn);
238: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.approved_yn: ' || p_qtev_rec.approved_yn);
239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.preproceeds_yn: ' || p_qtev_rec.preproceeds_yn);
240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.summary_format_yn: ' || p_qtev_rec.summary_format_yn);

Line 237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.accepted_yn: ' || p_qtev_rec.accepted_yn);

233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.qrs_code: ' || p_qtev_rec.qrs_code);
234: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.early_termination_yn: ' || p_qtev_rec.early_termination_yn);
235: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.partial_yn: ' || p_qtev_rec.partial_yn);
236: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.consolidated_yn: ' || p_qtev_rec.consolidated_yn);
237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.accepted_yn: ' || p_qtev_rec.accepted_yn);
238: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.approved_yn: ' || p_qtev_rec.approved_yn);
239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.preproceeds_yn: ' || p_qtev_rec.preproceeds_yn);
240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.summary_format_yn: ' || p_qtev_rec.summary_format_yn);
241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.payment_received_yn: ' || p_qtev_rec.payment_received_yn);

Line 238: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.approved_yn: ' || p_qtev_rec.approved_yn);

234: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.early_termination_yn: ' || p_qtev_rec.early_termination_yn);
235: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.partial_yn: ' || p_qtev_rec.partial_yn);
236: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.consolidated_yn: ' || p_qtev_rec.consolidated_yn);
237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.accepted_yn: ' || p_qtev_rec.accepted_yn);
238: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.approved_yn: ' || p_qtev_rec.approved_yn);
239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.preproceeds_yn: ' || p_qtev_rec.preproceeds_yn);
240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.summary_format_yn: ' || p_qtev_rec.summary_format_yn);
241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.payment_received_yn: ' || p_qtev_rec.payment_received_yn);
242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.khr_id: ' || p_qtev_rec.khr_id);

Line 239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.preproceeds_yn: ' || p_qtev_rec.preproceeds_yn);

235: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.partial_yn: ' || p_qtev_rec.partial_yn);
236: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.consolidated_yn: ' || p_qtev_rec.consolidated_yn);
237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.accepted_yn: ' || p_qtev_rec.accepted_yn);
238: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.approved_yn: ' || p_qtev_rec.approved_yn);
239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.preproceeds_yn: ' || p_qtev_rec.preproceeds_yn);
240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.summary_format_yn: ' || p_qtev_rec.summary_format_yn);
241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.payment_received_yn: ' || p_qtev_rec.payment_received_yn);
242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.khr_id: ' || p_qtev_rec.khr_id);
243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_code: ' || p_qtev_rec.currency_code);

Line 240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.summary_format_yn: ' || p_qtev_rec.summary_format_yn);

236: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.consolidated_yn: ' || p_qtev_rec.consolidated_yn);
237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.accepted_yn: ' || p_qtev_rec.accepted_yn);
238: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.approved_yn: ' || p_qtev_rec.approved_yn);
239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.preproceeds_yn: ' || p_qtev_rec.preproceeds_yn);
240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.summary_format_yn: ' || p_qtev_rec.summary_format_yn);
241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.payment_received_yn: ' || p_qtev_rec.payment_received_yn);
242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.khr_id: ' || p_qtev_rec.khr_id);
243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_code: ' || p_qtev_rec.currency_code);
244: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_code: ' || p_qtev_rec.currency_conversion_code);

Line 241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.payment_received_yn: ' || p_qtev_rec.payment_received_yn);

237: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.accepted_yn: ' || p_qtev_rec.accepted_yn);
238: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.approved_yn: ' || p_qtev_rec.approved_yn);
239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.preproceeds_yn: ' || p_qtev_rec.preproceeds_yn);
240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.summary_format_yn: ' || p_qtev_rec.summary_format_yn);
241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.payment_received_yn: ' || p_qtev_rec.payment_received_yn);
242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.khr_id: ' || p_qtev_rec.khr_id);
243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_code: ' || p_qtev_rec.currency_code);
244: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_code: ' || p_qtev_rec.currency_conversion_code);
245: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_type: ' || p_qtev_rec.currency_conversion_type);

Line 242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.khr_id: ' || p_qtev_rec.khr_id);

238: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.approved_yn: ' || p_qtev_rec.approved_yn);
239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.preproceeds_yn: ' || p_qtev_rec.preproceeds_yn);
240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.summary_format_yn: ' || p_qtev_rec.summary_format_yn);
241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.payment_received_yn: ' || p_qtev_rec.payment_received_yn);
242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.khr_id: ' || p_qtev_rec.khr_id);
243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_code: ' || p_qtev_rec.currency_code);
244: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_code: ' || p_qtev_rec.currency_conversion_code);
245: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_type: ' || p_qtev_rec.currency_conversion_type);
246: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_rate: ' || p_qtev_rec.currency_conversion_rate);

Line 243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_code: ' || p_qtev_rec.currency_code);

239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.preproceeds_yn: ' || p_qtev_rec.preproceeds_yn);
240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.summary_format_yn: ' || p_qtev_rec.summary_format_yn);
241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.payment_received_yn: ' || p_qtev_rec.payment_received_yn);
242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.khr_id: ' || p_qtev_rec.khr_id);
243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_code: ' || p_qtev_rec.currency_code);
244: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_code: ' || p_qtev_rec.currency_conversion_code);
245: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_type: ' || p_qtev_rec.currency_conversion_type);
246: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_rate: ' || p_qtev_rec.currency_conversion_rate);
247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_date: ' || p_qtev_rec.currency_conversion_date);

Line 244: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_code: ' || p_qtev_rec.currency_conversion_code);

240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.summary_format_yn: ' || p_qtev_rec.summary_format_yn);
241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.payment_received_yn: ' || p_qtev_rec.payment_received_yn);
242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.khr_id: ' || p_qtev_rec.khr_id);
243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_code: ' || p_qtev_rec.currency_code);
244: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_code: ' || p_qtev_rec.currency_conversion_code);
245: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_type: ' || p_qtev_rec.currency_conversion_type);
246: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_rate: ' || p_qtev_rec.currency_conversion_rate);
247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_date: ' || p_qtev_rec.currency_conversion_date);
248: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.id: ' || p_qtev_rec.id);

Line 245: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_type: ' || p_qtev_rec.currency_conversion_type);

241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.payment_received_yn: ' || p_qtev_rec.payment_received_yn);
242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.khr_id: ' || p_qtev_rec.khr_id);
243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_code: ' || p_qtev_rec.currency_code);
244: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_code: ' || p_qtev_rec.currency_conversion_code);
245: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_type: ' || p_qtev_rec.currency_conversion_type);
246: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_rate: ' || p_qtev_rec.currency_conversion_rate);
247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_date: ' || p_qtev_rec.currency_conversion_date);
248: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.id: ' || p_qtev_rec.id);
249: END IF;

Line 246: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_rate: ' || p_qtev_rec.currency_conversion_rate);

242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.khr_id: ' || p_qtev_rec.khr_id);
243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_code: ' || p_qtev_rec.currency_code);
244: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_code: ' || p_qtev_rec.currency_conversion_code);
245: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_type: ' || p_qtev_rec.currency_conversion_type);
246: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_rate: ' || p_qtev_rec.currency_conversion_rate);
247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_date: ' || p_qtev_rec.currency_conversion_date);
248: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.id: ' || p_qtev_rec.id);
249: END IF;
250: -- Get the sysdate

Line 247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_date: ' || p_qtev_rec.currency_conversion_date);

243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_code: ' || p_qtev_rec.currency_code);
244: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_code: ' || p_qtev_rec.currency_conversion_code);
245: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_type: ' || p_qtev_rec.currency_conversion_type);
246: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_rate: ' || p_qtev_rec.currency_conversion_rate);
247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_date: ' || p_qtev_rec.currency_conversion_date);
248: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.id: ' || p_qtev_rec.id);
249: END IF;
250: -- Get the sysdate
251: SELECT sysdate INTO l_sys_date FROM DUAL;

Line 248: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.id: ' || p_qtev_rec.id);

244: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_code: ' || p_qtev_rec.currency_conversion_code);
245: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_type: ' || p_qtev_rec.currency_conversion_type);
246: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_rate: ' || p_qtev_rec.currency_conversion_rate);
247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_date: ' || p_qtev_rec.currency_conversion_date);
248: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.id: ' || p_qtev_rec.id);
249: END IF;
250: -- Get the sysdate
251: SELECT sysdate INTO l_sys_date FROM DUAL;
252:

Line 297: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');

293:
294: -- Set the return status
295: x_return_status := l_return_status;
296: IF (is_debug_procedure_on) THEN
297: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
298: END IF;
299:
300: EXCEPTION
301: WHEN OTHERS THEN

Line 303: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

299:
300: EXCEPTION
301: WHEN OTHERS THEN
302: IF (is_debug_exception_on) THEN
303: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
304: || sqlcode || ' , SQLERRM : ' || sqlerrm);
305: END IF;
306: OKL_API.set_message(p_app_name => g_app_name,
307: p_msg_name => g_unexpected_error,

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

380: -- RMUNJULU 23-DEC-02 2726739 Added variables
381: l_chr_currency_code VARCHAR2(15);
382: l_contract_currency_code VARCHAR2(15);
383: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'validate_quotes';
384: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
385: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
386: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
387:
388: BEGIN

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

381: l_chr_currency_code VARCHAR2(15);
382: l_contract_currency_code VARCHAR2(15);
383: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'validate_quotes';
384: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
385: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
386: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
387:
388: BEGIN
389: IF (is_debug_procedure_on) THEN

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

382: l_contract_currency_code VARCHAR2(15);
383: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'validate_quotes';
384: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
385: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
386: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
387:
388: BEGIN
389: IF (is_debug_procedure_on) THEN
390: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

Line 390: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

386: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
387:
388: BEGIN
389: IF (is_debug_procedure_on) THEN
390: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
391: END IF;
392: IF (is_debug_statement_on) THEN
393: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_control_flag: '||p_control_flag);
394: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP

Line 393: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_control_flag: '||p_control_flag);

389: IF (is_debug_procedure_on) THEN
390: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
391: END IF;
392: IF (is_debug_statement_on) THEN
393: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_control_flag: '||p_control_flag);
394: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
395: IF (p_qtev_tbl.exists(i)) THEN
396: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);

Line 396: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);

392: IF (is_debug_statement_on) THEN
393: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_control_flag: '||p_control_flag);
394: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
395: IF (p_qtev_tbl.exists(i)) THEN
396: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
400: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);

Line 397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);

393: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_control_flag: '||p_control_flag);
394: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
395: IF (p_qtev_tbl.exists(i)) THEN
396: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
400: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
401: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);

Line 398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);

394: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
395: IF (p_qtev_tbl.exists(i)) THEN
396: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
400: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
401: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
402: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);

Line 399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);

395: IF (p_qtev_tbl.exists(i)) THEN
396: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
400: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
401: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
402: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
403: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);

Line 400: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);

396: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
400: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
401: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
402: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
403: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);

Line 401: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);

397: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
400: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
401: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
402: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
403: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
405: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);

Line 402: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);

398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
400: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
401: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
402: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
403: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
405: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
406: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);

Line 403: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);

399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
400: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
401: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
402: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
403: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
405: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
406: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
407: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);

Line 404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);

400: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
401: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
402: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
403: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
405: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
406: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
407: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);

Line 405: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);

401: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
402: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
403: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
405: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
406: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
407: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
409: END IF;

Line 406: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);

402: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
403: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
405: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
406: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
407: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
409: END IF;
410: END LOOP;

Line 407: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);

403: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
405: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
406: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
407: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
409: END IF;
410: END LOOP;
411: END IF;

Line 408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);

404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
405: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
406: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
407: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
409: END IF;
410: END LOOP;
411: END IF;
412:

Line 443: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called get_and_set_database_values , return status: ' || l_return_status);

439: p_qtev_tbl => lp_qtev_tbl,
440: x_return_status => l_return_status,
441: x_qtev_tbl => l_qtev_tbl);
442: IF (is_debug_statement_on) THEN
443: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called get_and_set_database_values , return status: ' || l_return_status);
444: END IF;
445:
446: -- Raise error if this fails
447: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');

728:
729: x_return_status := l_return_status;
730: x_qtev_tbl := l_qtev_tbl;
731: IF (is_debug_procedure_on) THEN
732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
733: END IF;
734:
735: EXCEPTION
736: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_HALT_VALIDATION');

734:
735: EXCEPTION
736: WHEN G_EXCEPTION_HALT_VALIDATION THEN
737: IF (is_debug_exception_on) THEN
738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_HALT_VALIDATION');
739: END IF;
740:
741: IF prod_id_csr%ISOPEN THEN
742: CLOSE prod_id_csr;

Line 753: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

749: x_return_status := OKL_API.G_RET_STS_ERROR;
750:
751: WHEN OTHERS THEN
752: IF (is_debug_exception_on) THEN
753: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
754: || sqlcode || ' , SQLERRM : ' || sqlerrm);
755: END IF;
756:
757: IF prod_id_csr%ISOPEN THEN

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

800: l_currency_conversion_type VARCHAR2(30) := 'User';
801: l_currency_conversion_rate NUMBER := 1;
802: l_currency_conversion_date DATE := p_sys_date;
803: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_currency_defaults';
804: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
805: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
806: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
807:
808:

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

801: l_currency_conversion_rate NUMBER := 1;
802: l_currency_conversion_date DATE := p_sys_date;
803: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_currency_defaults';
804: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
805: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
806: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
807:
808:
809: BEGIN

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

802: l_currency_conversion_date DATE := p_sys_date;
803: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_currency_defaults';
804: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
805: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
806: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
807:
808:
809: BEGIN
810: IF (is_debug_procedure_on) THEN

Line 811: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

807:
808:
809: BEGIN
810: IF (is_debug_procedure_on) THEN
811: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
812: END IF;
813: IF (is_debug_statement_on) THEN
814: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_sys_date: '||p_sys_date);
815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.khr_id: ' || p_first_qtev_rec.khr_id);

Line 814: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_sys_date: '||p_sys_date);

810: IF (is_debug_procedure_on) THEN
811: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
812: END IF;
813: IF (is_debug_statement_on) THEN
814: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_sys_date: '||p_sys_date);
815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.khr_id: ' || p_first_qtev_rec.khr_id);
816: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_code: ' || p_first_qtev_rec.currency_code);
817: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_code: ' || p_first_qtev_rec.currency_conversion_code);
818: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_type: ' || p_first_qtev_rec.currency_conversion_type);

Line 815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.khr_id: ' || p_first_qtev_rec.khr_id);

811: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
812: END IF;
813: IF (is_debug_statement_on) THEN
814: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_sys_date: '||p_sys_date);
815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.khr_id: ' || p_first_qtev_rec.khr_id);
816: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_code: ' || p_first_qtev_rec.currency_code);
817: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_code: ' || p_first_qtev_rec.currency_conversion_code);
818: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_type: ' || p_first_qtev_rec.currency_conversion_type);
819: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_rate: ' || p_first_qtev_rec.currency_conversion_rate);

Line 816: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_code: ' || p_first_qtev_rec.currency_code);

812: END IF;
813: IF (is_debug_statement_on) THEN
814: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_sys_date: '||p_sys_date);
815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.khr_id: ' || p_first_qtev_rec.khr_id);
816: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_code: ' || p_first_qtev_rec.currency_code);
817: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_code: ' || p_first_qtev_rec.currency_conversion_code);
818: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_type: ' || p_first_qtev_rec.currency_conversion_type);
819: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_rate: ' || p_first_qtev_rec.currency_conversion_rate);
820: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_date: ' || p_first_qtev_rec.currency_conversion_date);

Line 817: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_code: ' || p_first_qtev_rec.currency_conversion_code);

813: IF (is_debug_statement_on) THEN
814: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_sys_date: '||p_sys_date);
815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.khr_id: ' || p_first_qtev_rec.khr_id);
816: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_code: ' || p_first_qtev_rec.currency_code);
817: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_code: ' || p_first_qtev_rec.currency_conversion_code);
818: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_type: ' || p_first_qtev_rec.currency_conversion_type);
819: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_rate: ' || p_first_qtev_rec.currency_conversion_rate);
820: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_date: ' || p_first_qtev_rec.currency_conversion_date);
821: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.id: ' || p_first_qtev_rec.id);

Line 818: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_type: ' || p_first_qtev_rec.currency_conversion_type);

814: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_sys_date: '||p_sys_date);
815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.khr_id: ' || p_first_qtev_rec.khr_id);
816: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_code: ' || p_first_qtev_rec.currency_code);
817: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_code: ' || p_first_qtev_rec.currency_conversion_code);
818: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_type: ' || p_first_qtev_rec.currency_conversion_type);
819: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_rate: ' || p_first_qtev_rec.currency_conversion_rate);
820: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_date: ' || p_first_qtev_rec.currency_conversion_date);
821: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.id: ' || p_first_qtev_rec.id);
822: END IF;

Line 819: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_rate: ' || p_first_qtev_rec.currency_conversion_rate);

815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.khr_id: ' || p_first_qtev_rec.khr_id);
816: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_code: ' || p_first_qtev_rec.currency_code);
817: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_code: ' || p_first_qtev_rec.currency_conversion_code);
818: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_type: ' || p_first_qtev_rec.currency_conversion_type);
819: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_rate: ' || p_first_qtev_rec.currency_conversion_rate);
820: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_date: ' || p_first_qtev_rec.currency_conversion_date);
821: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.id: ' || p_first_qtev_rec.id);
822: END IF;
823:

Line 820: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_date: ' || p_first_qtev_rec.currency_conversion_date);

816: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_code: ' || p_first_qtev_rec.currency_code);
817: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_code: ' || p_first_qtev_rec.currency_conversion_code);
818: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_type: ' || p_first_qtev_rec.currency_conversion_type);
819: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_rate: ' || p_first_qtev_rec.currency_conversion_rate);
820: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_date: ' || p_first_qtev_rec.currency_conversion_date);
821: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.id: ' || p_first_qtev_rec.id);
822: END IF;
823:
824: -- Get the functional currency from AM_Util

Line 821: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.id: ' || p_first_qtev_rec.id);

817: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_code: ' || p_first_qtev_rec.currency_conversion_code);
818: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_type: ' || p_first_qtev_rec.currency_conversion_type);
819: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_rate: ' || p_first_qtev_rec.currency_conversion_rate);
820: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.currency_conversion_date: ' || p_first_qtev_rec.currency_conversion_date);
821: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_first_qtev_rec.id: ' || p_first_qtev_rec.id);
822: END IF;
823:
824: -- Get the functional currency from AM_Util
825: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency();

Line 847: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');

843:
844: -- Set the return status
845: x_return_status := l_return_status;
846: IF (is_debug_procedure_on) THEN
847: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
848: END IF;
849:
850: EXCEPTION
851:

Line 855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

851:
852:
853: WHEN OTHERS THEN
854: IF (is_debug_exception_on) THEN
855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
856: || sqlcode || ' , SQLERRM : ' || sqlerrm);
857: END IF;
858:
859: -- unexpected error

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

906:
907: -- RMUNJULU 23-DEC-02 2726739 Added variable
908: l_sys_date DATE;
909: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_consolidate_quote';
910: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
911: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
912: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
913:
914: BEGIN

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

907: -- RMUNJULU 23-DEC-02 2726739 Added variable
908: l_sys_date DATE;
909: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_consolidate_quote';
910: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
911: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
912: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
913:
914: BEGIN
915: IF (is_debug_procedure_on) THEN

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

908: l_sys_date DATE;
909: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_consolidate_quote';
910: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
911: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
912: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
913:
914: BEGIN
915: IF (is_debug_procedure_on) THEN
916: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

Line 916: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

912: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
913:
914: BEGIN
915: IF (is_debug_procedure_on) THEN
916: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
917: END IF;
918: IF (is_debug_statement_on) THEN
919: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
920: IF (p_qtev_tbl.exists(i)) THEN

Line 921: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);

917: END IF;
918: IF (is_debug_statement_on) THEN
919: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
920: IF (p_qtev_tbl.exists(i)) THEN
921: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
922: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
923: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
924: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);

Line 922: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);

918: IF (is_debug_statement_on) THEN
919: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
920: IF (p_qtev_tbl.exists(i)) THEN
921: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
922: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
923: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
924: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
926: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);

Line 923: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);

919: FOR i IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
920: IF (p_qtev_tbl.exists(i)) THEN
921: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
922: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
923: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
924: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
926: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);

Line 924: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);

920: IF (p_qtev_tbl.exists(i)) THEN
921: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
922: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
923: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
924: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
926: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
928: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);

Line 925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);

921: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').id : ' || p_qtev_tbl(i).id);
922: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
923: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
924: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
926: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
928: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
929: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);

Line 926: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);

922: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qst_code : ' || p_qtev_tbl(i).qst_code);
923: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
924: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
926: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
928: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
929: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
930: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);

Line 927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);

923: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qtp_code : ' || p_qtev_tbl(i).qtp_code);
924: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
926: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
928: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
929: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
930: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
931: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);

Line 928: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);

924: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').qrs_code : ' || p_qtev_tbl(i).qrs_code);
925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
926: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
928: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
929: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
930: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
931: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
932: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);

Line 929: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);

925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').khr_id : ' || p_qtev_tbl(i).khr_id);
926: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
928: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
929: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
930: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
931: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
932: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
933: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);

Line 930: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);

926: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').accepted_yn : ' || p_qtev_tbl(i).accepted_yn);
927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
928: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
929: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
930: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
931: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
932: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
933: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
934: END IF;

Line 931: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);

927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_yn : ' || p_qtev_tbl(i).consolidated_yn);
928: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
929: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
930: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
931: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
932: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
933: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
934: END IF;
935: END LOOP;

Line 932: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);

928: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').early_termination_yn : ' || p_qtev_tbl(i).early_termination_yn);
929: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
930: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
931: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
932: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
933: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
934: END IF;
935: END LOOP;
936: END IF;

Line 933: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);

929: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').partial_yn : ' || p_qtev_tbl(i).partial_yn);
930: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').consolidated_qte_id : ' || p_qtev_tbl(i).consolidated_qte_id);
931: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_from : ' || p_qtev_tbl(i).date_effective_from);
932: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').date_effective_to : ' || p_qtev_tbl(i).date_effective_to);
933: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_tbl(' || i || ').quote_number : ' || p_qtev_tbl(i).quote_number);
934: END IF;
935: END LOOP;
936: END IF;
937:

Line 971: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called validate_quotes , return status: ' || l_return_status);

967: p_control_flag => 'CREATE',
968: p_qtev_tbl => lp_qtev_tbl,
969: x_qtev_tbl => lx_qtev_tbl);
970: IF (is_debug_statement_on) THEN
971: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called validate_quotes , return status: ' || l_return_status);
972: END IF;
973:
974: -- Throw exception if validation of one or more of selected quotes fails
975: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 987: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called set_consolidated_quote_rec , return status: ' || l_return_status);

983: p_qtev_rec => lx_qtev_tbl(p_qtev_tbl.FIRST),
984: x_return_status => l_return_status,
985: x_qtev_rec => lp_consolidate_quote_rec);
986: IF (is_debug_statement_on) THEN
987: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called set_consolidated_quote_rec , return status: ' || l_return_status);
988: END IF;
989:
990: -- Throw exception if setting the consolidated quote record fails
991: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1006: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called set_currency_defaults , return status: ' || l_return_status);

1002: px_qtev_rec => lp_consolidate_quote_rec,
1003: p_sys_date => l_sys_date,
1004: x_return_status => l_return_status);
1005: IF (is_debug_statement_on) THEN
1006: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called set_currency_defaults , return status: ' || l_return_status);
1007: END IF;
1008:
1009:
1010: -- Throw exception if setting the consolidated quote record fails

Line 1020: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_QUOTES_PUB.insert_trx_quotes');

1016:
1017:
1018: -- Call the insert_row of tapi to insert the consolidated quote
1019: IF (is_debug_statement_on) THEN
1020: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_QUOTES_PUB.insert_trx_quotes');
1021: END IF;
1022: OKL_TRX_QUOTES_PUB.insert_trx_quotes (
1023: p_api_version => p_api_version,
1024: p_init_msg_list => OKL_API.G_FALSE,

Line 1031: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_QUOTES_PUB.insert_trx_quotes , return status: ' || l_return_status);

1027: x_return_status => l_return_status,
1028: p_qtev_rec => lp_consolidate_quote_rec,
1029: x_qtev_rec => lx_consolidate_quote_rec);
1030: IF (is_debug_statement_on) THEN
1031: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_QUOTES_PUB.insert_trx_quotes , return status: ' || l_return_status);
1032: END IF;
1033:
1034: -- Throw exception if inserting the consolidated quote record fails
1035: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1054: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_QUOTES_PUB.update_trx_quotes');

1050: i := lx_qtev_tbl.NEXT(i);
1051: END LOOP;
1052:
1053: IF (is_debug_statement_on) THEN
1054: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_QUOTES_PUB.update_trx_quotes');
1055: END IF;
1056: -- For all quotes passed call update_row of tapi
1057: OKL_TRX_QUOTES_PUB.update_trx_quotes (
1058: p_api_version => p_api_version,

Line 1066: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_QUOTES_PUB.update_trx_quotes , return status: ' || l_return_status);

1062: x_msg_data => x_msg_data,
1063: p_qtev_tbl => lp_quot_tbl,
1064: x_qtev_tbl => lx_quot_tbl);
1065: IF (is_debug_statement_on) THEN
1066: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_QUOTES_PUB.update_trx_quotes , return status: ' || l_return_status);
1067: END IF;
1068:
1069: -- Throw exception if updating the selected quotes to set the consolidated
1070: -- quote for anyone of them fails

Line 1086: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');

1082:
1083: -- end the transaction
1084: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1085: IF (is_debug_procedure_on) THEN
1086: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1087: END IF;
1088:
1089: EXCEPTION
1090: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1092: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');

1088:
1089: EXCEPTION
1090: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1091: IF (is_debug_exception_on) THEN
1092: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
1093: END IF;
1094: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1095: (
1096: l_api_name,

Line 1105: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');

1101: '_PVT'
1102: );
1103: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1104: IF (is_debug_exception_on) THEN
1105: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
1106: END IF;
1107: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1108: (
1109: l_api_name,

Line 1118: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

1114: '_PVT'
1115: );
1116: WHEN OTHERS THEN
1117: IF (is_debug_exception_on) THEN
1118: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1119: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1120: END IF;
1121: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1122: (

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

1158: lp_cons_rec qtev_rec_type := p_cons_rec;
1159: get_cons_db_vals_rec get_cons_db_vals_csr%ROWTYPE;
1160: l_date_eff_from DATE;
1161: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'validate_consolidated_quote';
1162: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1163: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1164: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1165:
1166: BEGIN

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

1159: get_cons_db_vals_rec get_cons_db_vals_csr%ROWTYPE;
1160: l_date_eff_from DATE;
1161: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'validate_consolidated_quote';
1162: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1163: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1164: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1165:
1166: BEGIN
1167: IF (is_debug_procedure_on) THEN

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

1160: l_date_eff_from DATE;
1161: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'validate_consolidated_quote';
1162: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1163: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1164: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1165:
1166: BEGIN
1167: IF (is_debug_procedure_on) THEN
1168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

Line 1168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

1164: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1165:
1166: BEGIN
1167: IF (is_debug_procedure_on) THEN
1168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1169: END IF;
1170: IF (is_debug_statement_on) THEN
1171: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);
1172: END IF;

Line 1171: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);

1167: IF (is_debug_procedure_on) THEN
1168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1169: END IF;
1170: IF (is_debug_statement_on) THEN
1171: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);
1172: END IF;
1173:
1174: OPEN get_cons_db_vals_csr(lp_cons_rec.id);
1175: FETCH get_cons_db_vals_csr INTO get_cons_db_vals_rec;

Line 1233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');

1229: END IF;
1230:
1231: x_return_status := l_return_status;
1232: IF (is_debug_procedure_on) THEN
1233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1234: END IF;
1235:
1236: EXCEPTION
1237: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_HALT_VALIDATION');

1235:
1236: EXCEPTION
1237: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1238: IF (is_debug_exception_on) THEN
1239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_HALT_VALIDATION');
1240: END IF;
1241:
1242: IF get_cons_db_vals_csr%ISOPEN THEN
1243: CLOSE get_cons_db_vals_csr;

Line 1250: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

1246: x_return_status := OKL_API.G_RET_STS_ERROR;
1247:
1248: WHEN OTHERS THEN
1249: IF (is_debug_exception_on) THEN
1250: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1251: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1252: END IF;
1253:
1254: IF get_cons_db_vals_csr%ISOPEN THEN

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

1286:
1287: lp_qtev_tbl qtev_tbl_type;
1288: i NUMBER;
1289: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_quotes_of_consolidated_qte';
1290: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1291: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1292: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1293:
1294: BEGIN

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

1287: lp_qtev_tbl qtev_tbl_type;
1288: i NUMBER;
1289: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_quotes_of_consolidated_qte';
1290: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1291: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1292: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1293:
1294: BEGIN
1295: IF (is_debug_procedure_on) THEN

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

1288: i NUMBER;
1289: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_quotes_of_consolidated_qte';
1290: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1291: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1292: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1293:
1294: BEGIN
1295: IF (is_debug_procedure_on) THEN
1296: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

Line 1296: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

1292: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1293:
1294: BEGIN
1295: IF (is_debug_procedure_on) THEN
1296: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1297: END IF;
1298: IF (is_debug_statement_on) THEN
1299: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);
1300: END IF;

Line 1299: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);

1295: IF (is_debug_procedure_on) THEN
1296: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1297: END IF;
1298: IF (is_debug_statement_on) THEN
1299: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);
1300: END IF;
1301:
1302: i := 1;
1303: FOR get_qtes_of_cons_qte_rec IN get_qtes_of_cons_qte_csr(p_cons_rec.id) LOOP

Line 1310: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');

1306: i := i + 1;
1307:
1308: END LOOP;
1309: IF (is_debug_procedure_on) THEN
1310: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1311: END IF;
1312:
1313: RETURN lp_qtev_tbl;
1314:

Line 1318: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

1314:
1315: EXCEPTION
1316: WHEN OTHERS THEN
1317: IF (is_debug_exception_on) THEN
1318: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1319: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1320: END IF;
1321: OKL_API.set_message(p_app_name => g_app_name,
1322: p_msg_name => g_unexpected_error,

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

1348:
1349: lp_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;
1350: i NUMBER;
1351: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_quotes_lines';
1352: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1353: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1354: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1355:
1356: BEGIN

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

1349: lp_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;
1350: i NUMBER;
1351: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_quotes_lines';
1352: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1353: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1354: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1355:
1356: BEGIN
1357: IF (is_debug_procedure_on) THEN

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

1350: i NUMBER;
1351: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_quotes_lines';
1352: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1353: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1354: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1355:
1356: BEGIN
1357: IF (is_debug_procedure_on) THEN
1358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

Line 1358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

1354: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1355:
1356: BEGIN
1357: IF (is_debug_procedure_on) THEN
1358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1359: END IF;
1360: IF (is_debug_statement_on) THEN
1361: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.id: ' || p_qtev_rec.id);
1362: END IF;

Line 1361: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.id: ' || p_qtev_rec.id);

1357: IF (is_debug_procedure_on) THEN
1358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1359: END IF;
1360: IF (is_debug_statement_on) THEN
1361: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.id: ' || p_qtev_rec.id);
1362: END IF;
1363:
1364: i := 1;
1365: FOR get_qtes_lines_of_qte_rec IN get_qtes_lines_of_qte_csr(p_qtev_rec.id) LOOP

Line 1372: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');

1368: i := i + 1;
1369:
1370: END LOOP;
1371: IF (is_debug_procedure_on) THEN
1372: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1373: END IF;
1374:
1375: RETURN lp_tqlv_tbl;
1376:

Line 1380: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

1376:
1377: EXCEPTION
1378: WHEN OTHERS THEN
1379: IF (is_debug_exception_on) THEN
1380: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1381: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1382: END IF;
1383: OKL_API.set_message(p_app_name => g_app_name,
1384: p_msg_name => g_unexpected_error,

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

1435: lp_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;
1436: lx_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;
1437:
1438: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_consolidate_quote';
1439: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1440: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1441: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1442:
1443: BEGIN

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

1436: lx_tqlv_tbl OKL_AM_REPURCHASE_ASSET_PUB.tqlv_tbl_type;
1437:
1438: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_consolidate_quote';
1439: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1440: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1441: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1442:
1443: BEGIN
1444: IF (is_debug_procedure_on) THEN

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

1437:
1438: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_consolidate_quote';
1439: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1440: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1441: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1442:
1443: BEGIN
1444: IF (is_debug_procedure_on) THEN
1445: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

Line 1445: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

1441: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1442:
1443: BEGIN
1444: IF (is_debug_procedure_on) THEN
1445: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1446: END IF;
1447: IF (is_debug_statement_on) THEN
1448: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_from: ' || p_cons_rec.date_effective_from);
1449: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_to: ' || p_cons_rec.date_effective_to);

Line 1448: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_from: ' || p_cons_rec.date_effective_from);

1444: IF (is_debug_procedure_on) THEN
1445: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1446: END IF;
1447: IF (is_debug_statement_on) THEN
1448: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_from: ' || p_cons_rec.date_effective_from);
1449: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_to: ' || p_cons_rec.date_effective_to);
1450: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_requested: ' || p_cons_rec.date_requested);
1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_proposal: ' || p_cons_rec.date_proposal);
1452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qtp_code: ' || p_cons_rec.qtp_code);

Line 1449: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_to: ' || p_cons_rec.date_effective_to);

1445: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1446: END IF;
1447: IF (is_debug_statement_on) THEN
1448: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_from: ' || p_cons_rec.date_effective_from);
1449: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_to: ' || p_cons_rec.date_effective_to);
1450: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_requested: ' || p_cons_rec.date_requested);
1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_proposal: ' || p_cons_rec.date_proposal);
1452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qtp_code: ' || p_cons_rec.qtp_code);
1453: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qst_code: ' || p_cons_rec.qst_code);

Line 1450: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_requested: ' || p_cons_rec.date_requested);

1446: END IF;
1447: IF (is_debug_statement_on) THEN
1448: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_from: ' || p_cons_rec.date_effective_from);
1449: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_to: ' || p_cons_rec.date_effective_to);
1450: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_requested: ' || p_cons_rec.date_requested);
1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_proposal: ' || p_cons_rec.date_proposal);
1452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qtp_code: ' || p_cons_rec.qtp_code);
1453: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qst_code: ' || p_cons_rec.qst_code);
1454: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qrs_code: ' || p_cons_rec.qrs_code);

Line 1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_proposal: ' || p_cons_rec.date_proposal);

1447: IF (is_debug_statement_on) THEN
1448: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_from: ' || p_cons_rec.date_effective_from);
1449: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_to: ' || p_cons_rec.date_effective_to);
1450: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_requested: ' || p_cons_rec.date_requested);
1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_proposal: ' || p_cons_rec.date_proposal);
1452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qtp_code: ' || p_cons_rec.qtp_code);
1453: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qst_code: ' || p_cons_rec.qst_code);
1454: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qrs_code: ' || p_cons_rec.qrs_code);
1455: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.early_termination_yn: ' || p_cons_rec.early_termination_yn);

Line 1452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qtp_code: ' || p_cons_rec.qtp_code);

1448: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_from: ' || p_cons_rec.date_effective_from);
1449: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_to: ' || p_cons_rec.date_effective_to);
1450: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_requested: ' || p_cons_rec.date_requested);
1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_proposal: ' || p_cons_rec.date_proposal);
1452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qtp_code: ' || p_cons_rec.qtp_code);
1453: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qst_code: ' || p_cons_rec.qst_code);
1454: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qrs_code: ' || p_cons_rec.qrs_code);
1455: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.early_termination_yn: ' || p_cons_rec.early_termination_yn);
1456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.partial_yn: ' || p_cons_rec.partial_yn);

Line 1453: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qst_code: ' || p_cons_rec.qst_code);

1449: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_effective_to: ' || p_cons_rec.date_effective_to);
1450: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_requested: ' || p_cons_rec.date_requested);
1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_proposal: ' || p_cons_rec.date_proposal);
1452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qtp_code: ' || p_cons_rec.qtp_code);
1453: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qst_code: ' || p_cons_rec.qst_code);
1454: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qrs_code: ' || p_cons_rec.qrs_code);
1455: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.early_termination_yn: ' || p_cons_rec.early_termination_yn);
1456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.partial_yn: ' || p_cons_rec.partial_yn);
1457: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.consolidated_yn: ' || p_cons_rec.consolidated_yn);

Line 1454: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qrs_code: ' || p_cons_rec.qrs_code);

1450: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_requested: ' || p_cons_rec.date_requested);
1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_proposal: ' || p_cons_rec.date_proposal);
1452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qtp_code: ' || p_cons_rec.qtp_code);
1453: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qst_code: ' || p_cons_rec.qst_code);
1454: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qrs_code: ' || p_cons_rec.qrs_code);
1455: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.early_termination_yn: ' || p_cons_rec.early_termination_yn);
1456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.partial_yn: ' || p_cons_rec.partial_yn);
1457: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.consolidated_yn: ' || p_cons_rec.consolidated_yn);
1458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.accepted_yn: ' || p_cons_rec.accepted_yn);

Line 1455: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.early_termination_yn: ' || p_cons_rec.early_termination_yn);

1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.date_proposal: ' || p_cons_rec.date_proposal);
1452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qtp_code: ' || p_cons_rec.qtp_code);
1453: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qst_code: ' || p_cons_rec.qst_code);
1454: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qrs_code: ' || p_cons_rec.qrs_code);
1455: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.early_termination_yn: ' || p_cons_rec.early_termination_yn);
1456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.partial_yn: ' || p_cons_rec.partial_yn);
1457: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.consolidated_yn: ' || p_cons_rec.consolidated_yn);
1458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.accepted_yn: ' || p_cons_rec.accepted_yn);
1459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.approved_yn: ' || p_cons_rec.approved_yn);

Line 1456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.partial_yn: ' || p_cons_rec.partial_yn);

1452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qtp_code: ' || p_cons_rec.qtp_code);
1453: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qst_code: ' || p_cons_rec.qst_code);
1454: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qrs_code: ' || p_cons_rec.qrs_code);
1455: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.early_termination_yn: ' || p_cons_rec.early_termination_yn);
1456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.partial_yn: ' || p_cons_rec.partial_yn);
1457: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.consolidated_yn: ' || p_cons_rec.consolidated_yn);
1458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.accepted_yn: ' || p_cons_rec.accepted_yn);
1459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.approved_yn: ' || p_cons_rec.approved_yn);
1460: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.preproceeds_yn: ' || p_cons_rec.preproceeds_yn);

Line 1457: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.consolidated_yn: ' || p_cons_rec.consolidated_yn);

1453: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qst_code: ' || p_cons_rec.qst_code);
1454: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qrs_code: ' || p_cons_rec.qrs_code);
1455: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.early_termination_yn: ' || p_cons_rec.early_termination_yn);
1456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.partial_yn: ' || p_cons_rec.partial_yn);
1457: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.consolidated_yn: ' || p_cons_rec.consolidated_yn);
1458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.accepted_yn: ' || p_cons_rec.accepted_yn);
1459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.approved_yn: ' || p_cons_rec.approved_yn);
1460: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.preproceeds_yn: ' || p_cons_rec.preproceeds_yn);
1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.summary_format_yn: ' || p_cons_rec.summary_format_yn);

Line 1458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.accepted_yn: ' || p_cons_rec.accepted_yn);

1454: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.qrs_code: ' || p_cons_rec.qrs_code);
1455: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.early_termination_yn: ' || p_cons_rec.early_termination_yn);
1456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.partial_yn: ' || p_cons_rec.partial_yn);
1457: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.consolidated_yn: ' || p_cons_rec.consolidated_yn);
1458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.accepted_yn: ' || p_cons_rec.accepted_yn);
1459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.approved_yn: ' || p_cons_rec.approved_yn);
1460: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.preproceeds_yn: ' || p_cons_rec.preproceeds_yn);
1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.summary_format_yn: ' || p_cons_rec.summary_format_yn);
1462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.payment_received_yn: ' || p_cons_rec.payment_received_yn);

Line 1459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.approved_yn: ' || p_cons_rec.approved_yn);

1455: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.early_termination_yn: ' || p_cons_rec.early_termination_yn);
1456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.partial_yn: ' || p_cons_rec.partial_yn);
1457: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.consolidated_yn: ' || p_cons_rec.consolidated_yn);
1458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.accepted_yn: ' || p_cons_rec.accepted_yn);
1459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.approved_yn: ' || p_cons_rec.approved_yn);
1460: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.preproceeds_yn: ' || p_cons_rec.preproceeds_yn);
1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.summary_format_yn: ' || p_cons_rec.summary_format_yn);
1462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.payment_received_yn: ' || p_cons_rec.payment_received_yn);
1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.khr_id: ' || p_cons_rec.khr_id);

Line 1460: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.preproceeds_yn: ' || p_cons_rec.preproceeds_yn);

1456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.partial_yn: ' || p_cons_rec.partial_yn);
1457: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.consolidated_yn: ' || p_cons_rec.consolidated_yn);
1458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.accepted_yn: ' || p_cons_rec.accepted_yn);
1459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.approved_yn: ' || p_cons_rec.approved_yn);
1460: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.preproceeds_yn: ' || p_cons_rec.preproceeds_yn);
1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.summary_format_yn: ' || p_cons_rec.summary_format_yn);
1462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.payment_received_yn: ' || p_cons_rec.payment_received_yn);
1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.khr_id: ' || p_cons_rec.khr_id);
1464: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_code: ' || p_cons_rec.currency_code);

Line 1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.summary_format_yn: ' || p_cons_rec.summary_format_yn);

1457: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.consolidated_yn: ' || p_cons_rec.consolidated_yn);
1458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.accepted_yn: ' || p_cons_rec.accepted_yn);
1459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.approved_yn: ' || p_cons_rec.approved_yn);
1460: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.preproceeds_yn: ' || p_cons_rec.preproceeds_yn);
1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.summary_format_yn: ' || p_cons_rec.summary_format_yn);
1462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.payment_received_yn: ' || p_cons_rec.payment_received_yn);
1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.khr_id: ' || p_cons_rec.khr_id);
1464: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_code: ' || p_cons_rec.currency_code);
1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_code: ' || p_cons_rec.currency_conversion_code);

Line 1462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.payment_received_yn: ' || p_cons_rec.payment_received_yn);

1458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.accepted_yn: ' || p_cons_rec.accepted_yn);
1459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.approved_yn: ' || p_cons_rec.approved_yn);
1460: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.preproceeds_yn: ' || p_cons_rec.preproceeds_yn);
1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.summary_format_yn: ' || p_cons_rec.summary_format_yn);
1462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.payment_received_yn: ' || p_cons_rec.payment_received_yn);
1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.khr_id: ' || p_cons_rec.khr_id);
1464: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_code: ' || p_cons_rec.currency_code);
1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_code: ' || p_cons_rec.currency_conversion_code);
1466: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_type: ' || p_cons_rec.currency_conversion_type);

Line 1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.khr_id: ' || p_cons_rec.khr_id);

1459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.approved_yn: ' || p_cons_rec.approved_yn);
1460: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.preproceeds_yn: ' || p_cons_rec.preproceeds_yn);
1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.summary_format_yn: ' || p_cons_rec.summary_format_yn);
1462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.payment_received_yn: ' || p_cons_rec.payment_received_yn);
1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.khr_id: ' || p_cons_rec.khr_id);
1464: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_code: ' || p_cons_rec.currency_code);
1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_code: ' || p_cons_rec.currency_conversion_code);
1466: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_type: ' || p_cons_rec.currency_conversion_type);
1467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_rate: ' || p_cons_rec.currency_conversion_rate);

Line 1464: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_code: ' || p_cons_rec.currency_code);

1460: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.preproceeds_yn: ' || p_cons_rec.preproceeds_yn);
1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.summary_format_yn: ' || p_cons_rec.summary_format_yn);
1462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.payment_received_yn: ' || p_cons_rec.payment_received_yn);
1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.khr_id: ' || p_cons_rec.khr_id);
1464: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_code: ' || p_cons_rec.currency_code);
1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_code: ' || p_cons_rec.currency_conversion_code);
1466: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_type: ' || p_cons_rec.currency_conversion_type);
1467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_rate: ' || p_cons_rec.currency_conversion_rate);
1468: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_date: ' || p_cons_rec.currency_conversion_date);

Line 1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_code: ' || p_cons_rec.currency_conversion_code);

1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.summary_format_yn: ' || p_cons_rec.summary_format_yn);
1462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.payment_received_yn: ' || p_cons_rec.payment_received_yn);
1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.khr_id: ' || p_cons_rec.khr_id);
1464: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_code: ' || p_cons_rec.currency_code);
1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_code: ' || p_cons_rec.currency_conversion_code);
1466: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_type: ' || p_cons_rec.currency_conversion_type);
1467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_rate: ' || p_cons_rec.currency_conversion_rate);
1468: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_date: ' || p_cons_rec.currency_conversion_date);
1469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);

Line 1466: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_type: ' || p_cons_rec.currency_conversion_type);

1462: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.payment_received_yn: ' || p_cons_rec.payment_received_yn);
1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.khr_id: ' || p_cons_rec.khr_id);
1464: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_code: ' || p_cons_rec.currency_code);
1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_code: ' || p_cons_rec.currency_conversion_code);
1466: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_type: ' || p_cons_rec.currency_conversion_type);
1467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_rate: ' || p_cons_rec.currency_conversion_rate);
1468: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_date: ' || p_cons_rec.currency_conversion_date);
1469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);
1470: END IF;

Line 1467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_rate: ' || p_cons_rec.currency_conversion_rate);

1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.khr_id: ' || p_cons_rec.khr_id);
1464: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_code: ' || p_cons_rec.currency_code);
1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_code: ' || p_cons_rec.currency_conversion_code);
1466: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_type: ' || p_cons_rec.currency_conversion_type);
1467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_rate: ' || p_cons_rec.currency_conversion_rate);
1468: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_date: ' || p_cons_rec.currency_conversion_date);
1469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);
1470: END IF;
1471:

Line 1468: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_date: ' || p_cons_rec.currency_conversion_date);

1464: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_code: ' || p_cons_rec.currency_code);
1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_code: ' || p_cons_rec.currency_conversion_code);
1466: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_type: ' || p_cons_rec.currency_conversion_type);
1467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_rate: ' || p_cons_rec.currency_conversion_rate);
1468: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_date: ' || p_cons_rec.currency_conversion_date);
1469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);
1470: END IF;
1471:
1472: --Check API version, initialize message list and create savepoint.

Line 1469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);

1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_code: ' || p_cons_rec.currency_conversion_code);
1466: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_type: ' || p_cons_rec.currency_conversion_type);
1467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_rate: ' || p_cons_rec.currency_conversion_rate);
1468: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.currency_conversion_date: ' || p_cons_rec.currency_conversion_date);
1469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);
1470: END IF;
1471:
1472: --Check API version, initialize message list and create savepoint.
1473: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1497: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called validate_consolidated_quote , return status: ' || l_return_status);

1493: x_msg_count => x_msg_count,
1494: x_msg_data => x_msg_data,
1495: p_cons_rec => lp_cons_rec);
1496: IF (is_debug_statement_on) THEN
1497: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called validate_consolidated_quote , return status: ' || l_return_status);
1498: END IF;
1499:
1500: -- Throw exception if validation of consolidated quote fails
1501: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1521: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called validate_quotes , return status: ' || l_return_status);

1517: p_control_flag => 'UPDATE',
1518: p_qtev_tbl => lp_qtev_tbl,
1519: x_qtev_tbl => li_qtev_tbl);
1520: IF (is_debug_statement_on) THEN
1521: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called validate_quotes , return status: ' || l_return_status);
1522: END IF;
1523:
1524: -- Throw exception if validation of one or more of selected quotes fails
1525: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1563: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_TERMNT_QUOTE_PUB.terminate_quote');

1559:
1560: IF li_qtev_tbl(i).qtp_code LIKE 'TER%' THEN
1561:
1562: IF (is_debug_statement_on) THEN
1563: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_TERMNT_QUOTE_PUB.terminate_quote');
1564: END IF;
1565: -- Call terminate quote update api
1566: OKL_AM_TERMNT_QUOTE_PUB.terminate_quote(
1567: p_api_version => p_api_version,

Line 1576: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PUB.terminate_quote , return status: ' || l_return_status);

1572: p_term_rec => li_qtev_tbl(i),
1573: x_term_rec => lx_qtev_tbl(i),
1574: x_err_msg => l_err_msg);
1575: IF (is_debug_statement_on) THEN
1576: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PUB.terminate_quote , return status: ' || l_return_status);
1577: END IF;
1578:
1579: -- Throw exception if terminate quote update failed
1580: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1593: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote');

1589: lp_tqlv_tbl := get_quotes_lines (
1590: p_qtev_rec => li_qtev_tbl(i));
1591:
1592: IF (is_debug_statement_on) THEN
1593: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote');
1594: END IF;
1595: -- Call terminate quote update api
1596: OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote(
1597: p_api_version => p_api_version,

Line 1607: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote , return status: ' || l_return_status);

1603: p_tqlv_tbl => lp_tqlv_tbl,
1604: x_qtev_rec => lx_qtev_tbl(i),
1605: x_tqlv_tbl => lx_tqlv_tbl);
1606: IF (is_debug_statement_on) THEN
1607: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote , return status: ' || l_return_status);
1608: END IF;
1609:
1610: -- Throw exception if repurchase quote update failed
1611: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1621: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_RESTRUCTURE_QUOTE_PUB.update_restructure_quote');

1617:
1618: ELSIF li_qtev_tbl(i).qtp_code LIKE 'RES%' THEN
1619:
1620: IF (is_debug_statement_on) THEN
1621: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_RESTRUCTURE_QUOTE_PUB.update_restructure_quote');
1622: END IF;
1623: -- Call terminate quote update api
1624: OKL_AM_RESTRUCTURE_QUOTE_PUB.update_restructure_quote(
1625: p_api_version => p_api_version,

Line 1633: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RESTRUCTURE_QUOTE_PUB.update_restructure_quote , return status: ' || l_return_status);

1629: x_msg_data => x_msg_data,
1630: p_quot_rec => li_qtev_tbl(i),
1631: x_quot_rec => lx_qtev_tbl(i));
1632: IF (is_debug_statement_on) THEN
1633: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RESTRUCTURE_QUOTE_PUB.update_restructure_quote , return status: ' || l_return_status);
1634: END IF;
1635:
1636: -- Throw exception if restructure quote update failed
1637: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1662: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_QUOTES_PUB.update_trx_quotes');

1658: lp_cons_rec.date_accepted := l_sys_date;
1659: END IF;
1660:
1661: IF (is_debug_statement_on) THEN
1662: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_QUOTES_PUB.update_trx_quotes');
1663: END IF;
1664: -- update consolidate quote
1665: OKL_TRX_QUOTES_PUB.update_trx_quotes (
1666: p_api_version => p_api_version,

Line 1674: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_QUOTES_PUB.update_trx_quotes , return status: ' || l_return_status);

1670: x_msg_data => x_msg_data,
1671: p_qtev_rec => lp_cons_rec,
1672: x_qtev_rec => lx_cons_rec);
1673: IF (is_debug_statement_on) THEN
1674: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_QUOTES_PUB.update_trx_quotes , return status: ' || l_return_status);
1675: END IF;
1676:
1677: -- Throw exception if updating the consolidated quote fails
1678: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1692: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');

1688:
1689: -- end the transaction
1690: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1691: IF (is_debug_procedure_on) THEN
1692: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1693: END IF;
1694:
1695: EXCEPTION
1696: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1698: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');

1694:
1695: EXCEPTION
1696: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1697: IF (is_debug_exception_on) THEN
1698: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
1699: END IF;
1700: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1701: (
1702: l_api_name,

Line 1711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');

1707: '_PVT'
1708: );
1709: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1710: IF (is_debug_exception_on) THEN
1711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
1712: END IF;
1713: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1714: (
1715: l_api_name,

Line 1724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

1720: '_PVT'
1721: );
1722: WHEN OTHERS THEN
1723: IF (is_debug_exception_on) THEN
1724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1725: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1726: END IF;
1727: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1728: (