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

Line 100: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

96: l_rep_agreement_yn VARCHAR2(1) := 'N';
97: l_program_khr_id NUMBER := NULL;
98: l_rulv_rec rulv_rec_type;
99: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_repurchase_agreement';
100: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
101: G_LEVEL_EXCEPTION);
102: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
103: G_LEVEL_PROCEDURE);
104: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

Line 102: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

98: l_rulv_rec rulv_rec_type;
99: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_repurchase_agreement';
100: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
101: G_LEVEL_EXCEPTION);
102: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
103: G_LEVEL_PROCEDURE);
104: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
105: G_LEVEL_STATEMENT);
106:

Line 104: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

100: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
101: G_LEVEL_EXCEPTION);
102: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
103: G_LEVEL_PROCEDURE);
104: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
105: G_LEVEL_STATEMENT);
106:
107: BEGIN
108: IF (is_debug_procedure_on) THEN

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

105: G_LEVEL_STATEMENT);
106:
107: BEGIN
108: IF (is_debug_procedure_on) THEN
109: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
110: END IF;
111: IF (is_debug_statement_on) THEN
112: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
113: END IF;

Line 112: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

108: IF (is_debug_procedure_on) THEN
109: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
110: END IF;
111: IF (is_debug_statement_on) THEN
112: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
113: END IF;
114:
115: OPEN l_khr_csr (p_chr_id);
116: FETCH l_khr_csr INTO l_program_khr_id;

Line 122: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

118:
119: IF l_program_khr_id IS NOT NULL THEN
120:
121: IF (is_debug_statement_on) THEN
122: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
123: END IF;
124: okl_am_util_pvt.get_rule_record(
125: p_rgd_code => 'AMREPQ',
126: p_rdf_code => 'AMARQC',

Line 133: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

129: p_message_yn => FALSE,
130: x_rulv_rec => l_rulv_rec,
131: x_return_status => l_return_status);
132: IF (is_debug_statement_on) THEN
133: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
134: END IF;
135:
136: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
137: IF l_rulv_rec.rule_information1 IS NOT NULL

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

142: END IF;
143: END IF;
144: END IF;
145: IF (is_debug_procedure_on) THEN
146: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
147: END IF;
148: IF (is_debug_statement_on) THEN
149: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Returning l_rep_agreement_yn : ' || l_rep_agreement_yn);
150: END IF;

Line 149: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Returning l_rep_agreement_yn : ' || l_rep_agreement_yn);

145: IF (is_debug_procedure_on) THEN
146: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
147: END IF;
148: IF (is_debug_statement_on) THEN
149: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Returning l_rep_agreement_yn : ' || l_rep_agreement_yn);
150: END IF;
151:
152: RETURN l_rep_agreement_yn;
153:

Line 158: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

154: EXCEPTION
155:
156: WHEN OTHERS THEN
157: IF (is_debug_exception_on) THEN
158: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
159: END IF;
160:
161: -- close open cursors
162: IF l_khr_csr%ISOPEN THEN

Line 198: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

194: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
195: l_quote_eff_days NUMBER := NULL;
196: l_quote_eff_max_days NUMBER := NULL;
197: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_quote_effectivity';
198: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
199: G_LEVEL_EXCEPTION);
200: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
201: G_LEVEL_PROCEDURE);
202: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

Line 200: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

196: l_quote_eff_max_days NUMBER := NULL;
197: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_quote_effectivity';
198: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
199: G_LEVEL_EXCEPTION);
200: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
201: G_LEVEL_PROCEDURE);
202: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
203: G_LEVEL_STATEMENT);
204:

Line 202: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

198: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
199: G_LEVEL_EXCEPTION);
200: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
201: G_LEVEL_PROCEDURE);
202: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
203: G_LEVEL_STATEMENT);
204:
205: BEGIN
206: IF (is_debug_procedure_on) THEN

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

203: G_LEVEL_STATEMENT);
204:
205: BEGIN
206: IF (is_debug_procedure_on) THEN
207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
208: END IF;
209: IF (is_debug_statement_on) THEN
210: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rule_info1: '||p_rule_info1);
211: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rule_info2: '||p_rule_info2);

Line 210: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rule_info1: '||p_rule_info1);

206: IF (is_debug_procedure_on) THEN
207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
208: END IF;
209: IF (is_debug_statement_on) THEN
210: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rule_info1: '||p_rule_info1);
211: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rule_info2: '||p_rule_info2);
212: END IF;
213:
214: IF p_rule_info1 IS NOT NULL

Line 211: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rule_info2: '||p_rule_info2);

207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
208: END IF;
209: IF (is_debug_statement_on) THEN
210: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rule_info1: '||p_rule_info1);
211: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rule_info2: '||p_rule_info2);
212: END IF;
213:
214: IF p_rule_info1 IS NOT NULL
215: AND p_rule_info1 <> G_MISS_CHAR THEN

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

269: END IF;
270:
271: x_return_status := l_return_status;
272: IF (is_debug_procedure_on) THEN
273: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
274: END IF;
275:
276: EXCEPTION
277:

Line 280: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

276: EXCEPTION
277:
278: WHEN OTHERS THEN
279: IF (is_debug_exception_on) THEN
280: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
281: END IF;
282:
283: -- store SQL error message on message stack for caller
284: OKL_API.SET_MESSAGE (

Line 323: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

319: x_return_status OUT NOCOPY VARCHAR2) IS
320:
321: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
322: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_value';
323: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
324: G_LEVEL_EXCEPTION);
325: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
326: G_LEVEL_PROCEDURE);
327: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

Line 325: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

321: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
322: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_value';
323: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
324: G_LEVEL_EXCEPTION);
325: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
326: G_LEVEL_PROCEDURE);
327: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
328: G_LEVEL_STATEMENT);
329:

Line 327: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

323: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
324: G_LEVEL_EXCEPTION);
325: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
326: G_LEVEL_PROCEDURE);
327: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
328: G_LEVEL_STATEMENT);
329:
330: BEGIN
331: IF (is_debug_procedure_on) THEN

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

328: G_LEVEL_STATEMENT);
329:
330: BEGIN
331: IF (is_debug_procedure_on) THEN
332: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
333: END IF;
334: IF (is_debug_statement_on) THEN
335: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_calc_option: '||p_calc_option);
336: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_fixed_value: '||p_fixed_value);

Line 335: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_calc_option: '||p_calc_option);

331: IF (is_debug_procedure_on) THEN
332: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
333: END IF;
334: IF (is_debug_statement_on) THEN
335: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_calc_option: '||p_calc_option);
336: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_fixed_value: '||p_fixed_value);
337: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_formula_name: '||p_formula_name);
338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
339: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);

Line 336: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_fixed_value: '||p_fixed_value);

332: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
333: END IF;
334: IF (is_debug_statement_on) THEN
335: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_calc_option: '||p_calc_option);
336: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_fixed_value: '||p_fixed_value);
337: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_formula_name: '||p_formula_name);
338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
339: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);
340: END IF;

Line 337: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_formula_name: '||p_formula_name);

333: END IF;
334: IF (is_debug_statement_on) THEN
335: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_calc_option: '||p_calc_option);
336: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_fixed_value: '||p_fixed_value);
337: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_formula_name: '||p_formula_name);
338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
339: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);
340: END IF;
341:

Line 338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);

334: IF (is_debug_statement_on) THEN
335: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_calc_option: '||p_calc_option);
336: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_fixed_value: '||p_fixed_value);
337: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_formula_name: '||p_formula_name);
338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
339: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);
340: END IF;
341:
342:

Line 339: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);

335: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_calc_option: '||p_calc_option);
336: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_fixed_value: '||p_fixed_value);
337: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_formula_name: '||p_formula_name);
338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
339: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);
340: END IF;
341:
342:
343:

Line 423: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.set_invalid_rule_message');

419:
420: ELSE -- Invalid combination of values
421:
422: IF (is_debug_statement_on) THEN
423: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.set_invalid_rule_message');
424: END IF;
425: okl_am_util_pvt.set_invalid_rule_message (
426: p_rgd_code => p_rgd_code,
427: p_rdf_code => p_rdf_code);

Line 429: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.set_invalid_rule_message');

425: okl_am_util_pvt.set_invalid_rule_message (
426: p_rgd_code => p_rgd_code,
427: p_rdf_code => p_rdf_code);
428: IF (is_debug_statement_on) THEN
429: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.set_invalid_rule_message');
430: END IF;
431:
432: l_return_status := OKL_API.G_RET_STS_ERROR;
433:

Line 463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.set_invalid_rule_message');

459: ELSE
460:
461: -- Invalid combination of values
462: IF (is_debug_statement_on) THEN
463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.set_invalid_rule_message');
464: END IF;
465: okl_am_util_pvt.set_invalid_rule_message (
466: p_rgd_code => p_rgd_code,
467: p_rdf_code => p_rdf_code);

Line 469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.set_invalid_rule_message');

465: okl_am_util_pvt.set_invalid_rule_message (
466: p_rgd_code => p_rgd_code,
467: p_rdf_code => p_rdf_code);
468: IF (is_debug_statement_on) THEN
469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.set_invalid_rule_message');
470: END IF;
471:
472: l_return_status := OKL_API.G_RET_STS_ERROR;
473:

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

475: END IF;
476:
477: x_return_status := l_return_status;
478: IF (is_debug_procedure_on) THEN
479: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
480: END IF;
481:
482: EXCEPTION
483:

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

482: EXCEPTION
483:
484: WHEN OTHERS THEN
485: IF (is_debug_exception_on) THEN
486: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
487: || sqlcode || ' , SQLERRM : ' || sqlerrm);
488: END IF;
489:
490: -- store SQL error message on message stack for caller

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

520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
521: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
522: l_rulv_rec rulv_rec_type;
523: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_setup';
524: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
525: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
526: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
527:
528: BEGIN

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

521: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
522: l_rulv_rec rulv_rec_type;
523: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_setup';
524: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
525: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
526: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
527:
528: BEGIN
529: IF (is_debug_procedure_on) THEN

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

522: l_rulv_rec rulv_rec_type;
523: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_setup';
524: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
525: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
526: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
527:
528: BEGIN
529: IF (is_debug_procedure_on) THEN
530: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

526: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
527:
528: BEGIN
529: IF (is_debug_procedure_on) THEN
530: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
531: END IF;
532: IF (is_debug_statement_on) THEN
533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
534: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);

Line 533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);

529: IF (is_debug_procedure_on) THEN
530: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
531: END IF;
532: IF (is_debug_statement_on) THEN
533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
534: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);
535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
536: END IF;
537:

Line 534: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);

530: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
531: END IF;
532: IF (is_debug_statement_on) THEN
533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
534: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);
535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
536: END IF;
537:
538: IF (is_debug_statement_on) THEN

Line 535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

531: END IF;
532: IF (is_debug_statement_on) THEN
533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
534: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);
535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
536: END IF;
537:
538: IF (is_debug_statement_on) THEN
539: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

Line 539: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
536: END IF;
537:
538: IF (is_debug_statement_on) THEN
539: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
540: END IF;
541: okl_am_util_pvt.get_rule_record (
542: p_rgd_code => p_rgd_code,
543: p_rdf_code => p_rdf_code,

Line 550: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

546: p_message_yn => FALSE,
547: x_rulv_rec => l_rulv_rec,
548: x_return_status => l_return_status);
549: IF (is_debug_statement_on) THEN
550: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
551: END IF;
552:
553: -- If rule is not found, return Success
554: -- If rule is found, check its setup

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

623: END IF;
624:
625: x_return_status := l_overall_status;
626: IF (is_debug_procedure_on) THEN
627: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
628: END IF;
629:
630: EXCEPTION
631:

Line 634: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

630: EXCEPTION
631:
632: WHEN OTHERS THEN
633: IF (is_debug_exception_on) THEN
634: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
635: END IF;
636:
637: -- store SQL error message on message stack for caller
638: OKL_API.SET_MESSAGE (

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

666: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
667: l_rulv_rec rulv_rec_type;
668: l_rgd_code VARCHAR2(30) := 'AMCOPO'; -- Contract Portfolio RG
669: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_contract_portfolio';
670: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
671: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
672: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
673:
674: BEGIN

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

667: l_rulv_rec rulv_rec_type;
668: l_rgd_code VARCHAR2(30) := 'AMCOPO'; -- Contract Portfolio RG
669: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_contract_portfolio';
670: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
671: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
672: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
673:
674: BEGIN
675: IF (is_debug_procedure_on) THEN

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

668: l_rgd_code VARCHAR2(30) := 'AMCOPO'; -- Contract Portfolio RG
669: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_contract_portfolio';
670: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
671: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
672: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
673:
674: BEGIN
675: IF (is_debug_procedure_on) THEN
676: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

672: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
673:
674: BEGIN
675: IF (is_debug_procedure_on) THEN
676: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
677: END IF;
678: IF (is_debug_statement_on) THEN
679: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
680: END IF;

Line 679: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

675: IF (is_debug_procedure_on) THEN
676: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
677: END IF;
678: IF (is_debug_statement_on) THEN
679: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
680: END IF;
681:
682: -- *************
683: -- Budget Amount

Line 687: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

683: -- Budget Amount
684: -- *************
685:
686: IF (is_debug_statement_on) THEN
687: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
688: END IF;
689: okl_am_util_pvt.get_rule_record (
690: p_rgd_code => l_rgd_code,
691: p_rdf_code => 'AMPRBA',

Line 698: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

694: p_message_yn => TRUE,
695: x_rulv_rec => l_rulv_rec,
696: x_return_status => l_return_status);
697: IF (is_debug_statement_on) THEN
698: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
699: END IF;
700:
701: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
702: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

720: -- Strategy
721: -- ********
722:
723: IF (is_debug_statement_on) THEN
724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
725: END IF;
726: okl_am_util_pvt.get_rule_record(
727: p_rgd_code => l_rgd_code,
728: p_rdf_code => 'AMPRST',

Line 735: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

731: p_message_yn => TRUE,
732: x_rulv_rec => l_rulv_rec,
733: x_return_status => l_return_status);
734: IF (is_debug_statement_on) THEN
735: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
736: END IF;
737:
738: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
739: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 749: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

745: -- Assignment Group
746: -- ****************
747:
748: IF (is_debug_statement_on) THEN
749: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
750: END IF;
751: okl_am_util_pvt.get_rule_record(
752: p_rgd_code => l_rgd_code,
753: p_rdf_code => 'AMPRAG',

Line 760: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

756: p_message_yn => TRUE,
757: x_rulv_rec => l_rulv_rec,
758: x_return_status => l_return_status);
759: IF (is_debug_statement_on) THEN
760: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
761: END IF;
762:
763: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
764: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 774: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

770: -- Execution Due Date
771: -- ******************
772:
773: IF (is_debug_statement_on) THEN
774: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
775: END IF;
776: okl_am_util_pvt.get_rule_record(
777: p_rgd_code => l_rgd_code,
778: p_rdf_code => 'AMPRED',

Line 785: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

781: p_message_yn => TRUE,
782: x_rulv_rec => l_rulv_rec,
783: x_return_status => l_return_status);
784: IF (is_debug_statement_on) THEN
785: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
786: END IF;
787:
788: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
789: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

792: END IF;
793:
794: x_return_status := l_overall_status;
795: IF (is_debug_procedure_on) THEN
796: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
797: END IF;
798:
799: EXCEPTION
800:

Line 803: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' ||

799: EXCEPTION
800:
801: WHEN OTHERS THEN
802: IF (is_debug_exception_on) THEN
803: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' ||
804: sqlerrm);
805: END IF;
806:
807: -- store SQL error message on message stack for caller

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

835: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
836: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
837: l_rulv_rec rulv_rec_type;
838: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_calculate_quote';
839: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
840: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
841: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
842:
843: BEGIN

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

836: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
837: l_rulv_rec rulv_rec_type;
838: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_calculate_quote';
839: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
840: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
841: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
842:
843: BEGIN
844: IF (is_debug_procedure_on) THEN

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

837: l_rulv_rec rulv_rec_type;
838: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_calculate_quote';
839: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
840: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
841: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
842:
843: BEGIN
844: IF (is_debug_procedure_on) THEN
845: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

841: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
842:
843: BEGIN
844: IF (is_debug_procedure_on) THEN
845: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
846: END IF;
847: IF (is_debug_statement_on) THEN
848: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
849: END IF;

Line 848: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

844: IF (is_debug_procedure_on) THEN
845: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
846: END IF;
847: IF (is_debug_statement_on) THEN
848: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
849: END IF;
850:
851: -- ***************************************
852: -- Top End of Term Purchase Option Formula

Line 856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

852: -- Top End of Term Purchase Option Formula
853: -- ***************************************
854:
855: IF (is_debug_statement_on) THEN
856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
857: END IF;
858: okl_am_util_pvt.get_rule_record(
859: p_rgd_code => 'AMTFOC',
860: p_rdf_code => 'AMBPOC',

Line 867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

863: p_message_yn => TRUE,
864: x_rulv_rec => l_rulv_rec,
865: x_return_status => l_return_status);
866: IF (is_debug_statement_on) THEN
867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
868: END IF;
869:
870: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
871: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

1167: END IF;
1168:
1169: x_return_status := l_overall_status;
1170: IF (is_debug_procedure_on) THEN
1171: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1172: END IF;
1173:
1174: EXCEPTION
1175:

Line 1178: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

1174: EXCEPTION
1175:
1176: WHEN OTHERS THEN
1177: IF (is_debug_exception_on) THEN
1178: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1179: END IF;
1180:
1181: -- store SQL error message on message stack for caller
1182: OKL_API.SET_MESSAGE (

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

1209: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1210: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1211: l_rulv_rec rulv_rec_type;
1212: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_create_quote';
1213: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1214: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1215: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1216:
1217: BEGIN

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

1210: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1211: l_rulv_rec rulv_rec_type;
1212: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_create_quote';
1213: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1214: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1215: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1216:
1217: BEGIN
1218: IF (is_debug_procedure_on) THEN

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

1211: l_rulv_rec rulv_rec_type;
1212: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_create_quote';
1213: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1214: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1215: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1216:
1217: BEGIN
1218: IF (is_debug_procedure_on) THEN
1219: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1215: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1216:
1217: BEGIN
1218: IF (is_debug_procedure_on) THEN
1219: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1220: END IF;
1221: IF (is_debug_statement_on) THEN
1222: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1223: END IF;

Line 1222: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

1218: IF (is_debug_procedure_on) THEN
1219: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1220: END IF;
1221: IF (is_debug_statement_on) THEN
1222: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1223: END IF;
1224:
1225: -- *******************************************************
1226: -- Quote Effectivity for Termination and Repurchase Quotes

Line 1230: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

1226: -- Quote Effectivity for Termination and Repurchase Quotes
1227: -- *******************************************************
1228:
1229: IF (is_debug_statement_on) THEN
1230: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
1231: END IF;
1232: okl_am_util_pvt.get_rule_record(
1233: p_rgd_code => 'AMTQPR',
1234: p_rdf_code => 'AMQTEF',

Line 1241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

1237: p_message_yn => TRUE,
1238: x_rulv_rec => l_rulv_rec,
1239: x_return_status => l_return_status);
1240: IF (is_debug_statement_on) THEN
1241: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
1242: END IF;
1243:
1244: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1245: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 1270: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

1266: -- Term Status for Termination Quote
1267: -- *********************************
1268:
1269: IF (is_debug_statement_on) THEN
1270: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
1271: END IF;
1272: okl_am_util_pvt.get_rule_record(
1273: p_rgd_code => 'AMTQPR',
1274: p_rdf_code => 'AMTSET',

Line 1281: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

1277: p_message_yn => TRUE,
1278: x_rulv_rec => l_rulv_rec,
1279: x_return_status => l_return_status);
1280: IF (is_debug_statement_on) THEN
1281: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
1282: END IF;
1283:
1284: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1285: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

1288: END IF;
1289:
1290: x_return_status := l_overall_status;
1291: IF (is_debug_procedure_on) THEN
1292: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1293: END IF;
1294:
1295: EXCEPTION
1296:

Line 1299: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

1295: EXCEPTION
1296:
1297: WHEN OTHERS THEN
1298: IF (is_debug_exception_on) THEN
1299: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1300: END IF;
1301:
1302: -- store SQL error message on message stack for caller
1303: OKL_API.SET_MESSAGE (

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

1329:
1330: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1331: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1332: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_quote_wf';
1333: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1334: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1335: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1336:
1337: BEGIN

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

1330: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1331: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1332: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_quote_wf';
1333: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1334: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1335: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1336:
1337: BEGIN
1338: IF (is_debug_procedure_on) THEN

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

1331: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1332: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_quote_wf';
1333: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1334: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1335: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1336:
1337: BEGIN
1338: IF (is_debug_procedure_on) THEN
1339: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1335: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1336:
1337: BEGIN
1338: IF (is_debug_procedure_on) THEN
1339: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1340: END IF;
1341: IF (is_debug_statement_on) THEN
1342: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1343: END IF;

Line 1342: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

1338: IF (is_debug_procedure_on) THEN
1339: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1340: END IF;
1341: IF (is_debug_statement_on) THEN
1342: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1343: END IF;
1344:
1345: -- *************
1346: -- Gain and Loss

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

1359: END IF;
1360:
1361: x_return_status := l_overall_status;
1362: IF (is_debug_procedure_on) THEN
1363: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1364: END IF;
1365:
1366: EXCEPTION
1367:

Line 1370: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

1366: EXCEPTION
1367:
1368: WHEN OTHERS THEN
1369: IF (is_debug_exception_on) THEN
1370: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1371: END IF;
1372:
1373: -- store SQL error message on message stack for caller
1374: OKL_API.SET_MESSAGE (

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

1414: l_qpyv_tbl qpyv_tbl_type; -- Quote Parties
1415: l_taiv_rec taiv_rec_type; -- Billing Header
1416: e_taiv_rec taiv_rec_type; -- Empty Billing Header
1417: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_termin_quote_parties';
1418: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1419: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1420: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1421:
1422: BEGIN

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

1415: l_taiv_rec taiv_rec_type; -- Billing Header
1416: e_taiv_rec taiv_rec_type; -- Empty Billing Header
1417: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_termin_quote_parties';
1418: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1419: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1420: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1421:
1422: BEGIN
1423: IF (is_debug_procedure_on) THEN

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

1416: e_taiv_rec taiv_rec_type; -- Empty Billing Header
1417: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_termin_quote_parties';
1418: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1419: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1420: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1421:
1422: BEGIN
1423: IF (is_debug_procedure_on) THEN
1424: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1420: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1421:
1422: BEGIN
1423: IF (is_debug_procedure_on) THEN
1424: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1425: END IF;
1426: IF (is_debug_statement_on) THEN
1427: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1428: END IF;

Line 1427: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

1423: IF (is_debug_procedure_on) THEN
1424: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1425: END IF;
1426: IF (is_debug_statement_on) THEN
1427: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1428: END IF;
1429:
1430: -- ********************************************
1431: -- Validate all quote parties using setup rules

Line 1437: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_parties_pvt.create_quote_parties');

1433:
1434: l_qtev_rec.khr_id := p_chr_id;
1435:
1436: IF (is_debug_statement_on) THEN
1437: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_parties_pvt.create_quote_parties');
1438: END IF;
1439: -- The procedure will issue warning messages
1440: okl_am_parties_pvt.create_quote_parties (
1441: p_qtev_rec => l_qtev_rec,

Line 1446: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_parties_pvt.create_quote_parties , return status: ' || l_return_status);

1442: p_validate_only => TRUE,
1443: x_qpyv_tbl => l_qpyv_tbl,
1444: x_return_status => l_return_status);
1445: IF (is_debug_statement_on) THEN
1446: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_parties_pvt.create_quote_parties , return status: ' || l_return_status);
1447: END IF;
1448:
1449: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1450: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_invoices_pvt.get_vendor_billing_info');

1461: l_taiv_rec := e_taiv_rec;
1462: l_taiv_rec.khr_id := p_chr_id;
1463:
1464: IF (is_debug_statement_on) THEN
1465: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_invoices_pvt.get_vendor_billing_info');
1466: END IF;
1467: -- The procedure will issue warning messages
1468: okl_am_invoices_pvt.get_vendor_billing_info (
1469: p_cpl_id => l_vendor_rec.cpl_id,

Line 1473: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_invoices_pvt.get_vendor_billing_info , return status: ' || l_return_status);

1469: p_cpl_id => l_vendor_rec.cpl_id,
1470: px_taiv_rec => l_taiv_rec,
1471: x_return_status => l_return_status);
1472: IF (is_debug_statement_on) THEN
1473: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_invoices_pvt.get_vendor_billing_info , return status: ' || l_return_status);
1474: END IF;
1475:
1476: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1477: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR

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

1483: END LOOP;
1484:
1485: x_return_status := l_overall_status;
1486: IF (is_debug_procedure_on) THEN
1487: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1488: END IF;
1489:
1490: EXCEPTION
1491:

Line 1494: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

1490: EXCEPTION
1491:
1492: WHEN OTHERS THEN
1493: IF (is_debug_exception_on) THEN
1494: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1495: END IF;
1496:
1497: -- close open cursors
1498: IF l_vendor_csr%ISOPEN THEN

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

1533: l_qtev_rec qtev_rec_type; -- Quote Header
1534: l_qpyv_tbl qpyv_tbl_type; -- Quote Parties
1535: l_taiv_rec taiv_rec_type; -- Billing Header
1536: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_repurch_quote_parties';
1537: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1538: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1539: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1540:
1541: BEGIN

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

1534: l_qpyv_tbl qpyv_tbl_type; -- Quote Parties
1535: l_taiv_rec taiv_rec_type; -- Billing Header
1536: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_repurch_quote_parties';
1537: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1538: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1539: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1540:
1541: BEGIN
1542: IF (is_debug_procedure_on) THEN

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

1535: l_taiv_rec taiv_rec_type; -- Billing Header
1536: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_repurch_quote_parties';
1537: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1538: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1539: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1540:
1541: BEGIN
1542: IF (is_debug_procedure_on) THEN
1543: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1539: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1540:
1541: BEGIN
1542: IF (is_debug_procedure_on) THEN
1543: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1544: END IF;
1545: IF (is_debug_statement_on) THEN
1546: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1547: END IF;

Line 1546: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

1542: IF (is_debug_procedure_on) THEN
1543: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1544: END IF;
1545: IF (is_debug_statement_on) THEN
1546: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1547: END IF;
1548:
1549: IF get_repurchase_agreement (p_chr_id) = 'Y' THEN
1550:

Line 1558: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_parties_pvt.create_partner_as_recipient');

1554:
1555: l_qtev_rec.khr_id := p_chr_id;
1556:
1557: IF (is_debug_statement_on) THEN
1558: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_parties_pvt.create_partner_as_recipient');
1559: END IF;
1560: -- The procedure will issue error messages if needed
1561: okl_am_parties_pvt.create_partner_as_recipient (
1562: p_qtev_rec => l_qtev_rec,

Line 1567: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_parties_pvt.create_partner_as_recipient , return status: ' || l_return_status);

1563: p_validate_only => TRUE,
1564: x_qpyv_tbl => l_qpyv_tbl,
1565: x_return_status => l_return_status);
1566: IF (is_debug_statement_on) THEN
1567: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_parties_pvt.create_partner_as_recipient , return status: ' || l_return_status);
1568: END IF;
1569:
1570: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1571: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 1583: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_invoices_pvt.get_vendor_billing_info');

1579:
1580: l_taiv_rec.khr_id := p_chr_id;
1581:
1582: IF (is_debug_statement_on) THEN
1583: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_invoices_pvt.get_vendor_billing_info');
1584: END IF;
1585: -- The procedure will issue error messages if needed
1586: okl_am_invoices_pvt.get_vendor_billing_info (
1587: px_taiv_rec => l_taiv_rec,

Line 1590: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_invoices_pvt.get_vendor_billing_info , return status: ' || l_return_status);

1586: okl_am_invoices_pvt.get_vendor_billing_info (
1587: px_taiv_rec => l_taiv_rec,
1588: x_return_status => l_return_status);
1589: IF (is_debug_statement_on) THEN
1590: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_invoices_pvt.get_vendor_billing_info , return status: ' || l_return_status);
1591: END IF;
1592:
1593: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1594: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR

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

1600: END IF;
1601:
1602: x_return_status := l_overall_status;
1603: IF (is_debug_procedure_on) THEN
1604: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1605: END IF;
1606:
1607: EXCEPTION
1608:

Line 1611: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

1607: EXCEPTION
1608:
1609: WHEN OTHERS THEN
1610: IF (is_debug_exception_on) THEN
1611: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1612: END IF;
1613:
1614: -- store SQL error message on message stack for caller
1615: OKL_API.SET_MESSAGE (

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

1641:
1642: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1643: l_bill_to_address_rec okx_cust_site_uses_v%ROWTYPE;
1644: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_bill_to_address';
1645: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1646: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1647: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1648:
1649: BEGIN

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

1642: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1643: l_bill_to_address_rec okx_cust_site_uses_v%ROWTYPE;
1644: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_bill_to_address';
1645: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1646: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1647: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1648:
1649: BEGIN
1650: IF (is_debug_procedure_on) THEN

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

1643: l_bill_to_address_rec okx_cust_site_uses_v%ROWTYPE;
1644: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_bill_to_address';
1645: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1646: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1647: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1648:
1649: BEGIN
1650: IF (is_debug_procedure_on) THEN
1651: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1647: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1648:
1649: BEGIN
1650: IF (is_debug_procedure_on) THEN
1651: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1652: END IF;
1653: IF (is_debug_statement_on) THEN
1654: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1655: END IF;

Line 1654: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

1650: IF (is_debug_procedure_on) THEN
1651: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1652: END IF;
1653: IF (is_debug_statement_on) THEN
1654: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1655: END IF;
1656:
1657: IF (is_debug_statement_on) THEN
1658: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_bill_to_address');

Line 1658: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_bill_to_address');

1654: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1655: END IF;
1656:
1657: IF (is_debug_statement_on) THEN
1658: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_bill_to_address');
1659: END IF;
1660: okl_am_util_pvt.get_bill_to_address (
1661: p_contract_id => p_chr_id,
1662: x_bill_to_address_rec => l_bill_to_address_rec,

Line 1665: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_bill_to_address , return status: ' || l_return_status);

1661: p_contract_id => p_chr_id,
1662: x_bill_to_address_rec => l_bill_to_address_rec,
1663: x_return_status => l_return_status);
1664: IF (is_debug_statement_on) THEN
1665: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_bill_to_address , return status: ' || l_return_status);
1666: END IF;
1667:
1668: x_return_status := l_return_status;
1669: IF (is_debug_procedure_on) THEN

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

1666: END IF;
1667:
1668: x_return_status := l_return_status;
1669: IF (is_debug_procedure_on) THEN
1670: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1671: END IF;
1672:
1673: EXCEPTION
1674:

Line 1677: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

1673: EXCEPTION
1674:
1675: WHEN OTHERS THEN
1676: IF (is_debug_exception_on) THEN
1677: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1678: END IF;
1679:
1680: -- store SQL error message on message stack for caller
1681: OKL_API.SET_MESSAGE (

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

1727: l_contract_end_date DATE;
1728: l_sysdate DATE := SYSDATE;
1729: l_calculate_sdd BOOLEAN;
1730: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_sec_dep_disp';
1731: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1732: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1733: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1734:
1735: BEGIN

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

1728: l_sysdate DATE := SYSDATE;
1729: l_calculate_sdd BOOLEAN;
1730: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_sec_dep_disp';
1731: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1732: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1733: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1734:
1735: BEGIN
1736: IF (is_debug_procedure_on) THEN

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

1729: l_calculate_sdd BOOLEAN;
1730: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_sec_dep_disp';
1731: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1732: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1733: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1734:
1735: BEGIN
1736: IF (is_debug_procedure_on) THEN
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1733: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1734:
1735: BEGIN
1736: IF (is_debug_procedure_on) THEN
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1738: END IF;
1739: IF (is_debug_statement_on) THEN
1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1741: END IF;

Line 1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

1736: IF (is_debug_procedure_on) THEN
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1738: END IF;
1739: IF (is_debug_statement_on) THEN
1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1741: END IF;
1742:
1743: -- *************************
1744: -- Get Security Deposit Rule

Line 1748: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

1744: -- Get Security Deposit Rule
1745: -- *************************
1746:
1747: IF (is_debug_statement_on) THEN
1748: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
1749: END IF;
1750: okl_am_util_pvt.get_rule_record (
1751: p_rgd_code => 'LASDEP',
1752: p_rdf_code => 'LASDEP',

Line 1759: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

1755: x_rulv_rec => l_rulv_rec,
1756: x_return_status => l_return_status,
1757: p_message_yn => FALSE);
1758: IF (is_debug_statement_on) THEN
1759: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
1760: END IF;
1761:
1762: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1763:

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

1797: END IF;
1798:
1799: x_return_status := l_return_status;
1800: IF (is_debug_procedure_on) THEN
1801: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1802: END IF;
1803:
1804: EXCEPTION
1805:

Line 1808: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

1804: EXCEPTION
1805:
1806: WHEN OTHERS THEN
1807: IF (is_debug_exception_on) THEN
1808: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1809: END IF;
1810:
1811: -- Close open cursors
1812:

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

1846:
1847: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1848: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1849: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_am_rule_format';
1850: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1851: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1852: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1853:
1854: BEGIN

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

1847: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1848: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1849: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_am_rule_format';
1850: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1851: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1852: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1853:
1854: BEGIN
1855: IF (is_debug_procedure_on) THEN

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

1848: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1849: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_am_rule_format';
1850: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1851: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1852: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1853:
1854: BEGIN
1855: IF (is_debug_procedure_on) THEN
1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1852: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1853:
1854: BEGIN
1855: IF (is_debug_procedure_on) THEN
1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1857: END IF;
1858: IF (is_debug_statement_on) THEN
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information_category: ' || p_rgr_rec.rule_information_category);

Line 1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

1855: IF (is_debug_procedure_on) THEN
1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1857: END IF;
1858: IF (is_debug_statement_on) THEN
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information_category: ' || p_rgr_rec.rule_information_category);
1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1862: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);

Line 1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information_category: ' || p_rgr_rec.rule_information_category);

1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1857: END IF;
1858: IF (is_debug_statement_on) THEN
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information_category: ' || p_rgr_rec.rule_information_category);
1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1862: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1864: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);

Line 1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);

1857: END IF;
1858: IF (is_debug_statement_on) THEN
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information_category: ' || p_rgr_rec.rule_information_category);
1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1862: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1864: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1865: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);

Line 1862: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);

1858: IF (is_debug_statement_on) THEN
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information_category: ' || p_rgr_rec.rule_information_category);
1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1862: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1864: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1865: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);

Line 1863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);

1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information_category: ' || p_rgr_rec.rule_information_category);
1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1862: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1864: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1865: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);

Line 1864: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);

1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information_category: ' || p_rgr_rec.rule_information_category);
1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1862: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1864: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1865: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1868: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);

Line 1865: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);

1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1862: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1864: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1865: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1868: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1869: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);

Line 1866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);

1862: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1864: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1865: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1868: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1869: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1870: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);

Line 1867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);

1863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1864: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1865: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1868: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1869: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1870: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);
1871: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information10: ' || p_rgr_rec.rule_information10);

Line 1868: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);

1864: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1865: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1868: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1869: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1870: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);
1871: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information10: ' || p_rgr_rec.rule_information10);
1872: END IF;

Line 1869: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);

1865: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1868: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1869: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1870: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);
1871: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information10: ' || p_rgr_rec.rule_information10);
1872: END IF;
1873:

Line 1870: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);

1866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1868: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1869: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1870: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);
1871: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information10: ' || p_rgr_rec.rule_information10);
1872: END IF;
1873:
1874:

Line 1871: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information10: ' || p_rgr_rec.rule_information10);

1867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1868: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1869: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1870: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);
1871: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information10: ' || p_rgr_rec.rule_information10);
1872: END IF;
1873:
1874:
1875: -- **************************************************

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

1989: END IF;
1990:
1991: x_return_status := l_overall_status;
1992: IF (is_debug_procedure_on) THEN
1993: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1994: END IF;
1995:
1996: EXCEPTION
1997:

Line 2000: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

1996: EXCEPTION
1997:
1998: WHEN OTHERS THEN
1999: IF (is_debug_exception_on) THEN
2000: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2001: END IF;
2002:
2003: -- store SQL error message on message stack for caller
2004: OKL_API.SET_MESSAGE (

Line 2034: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

2030:
2031: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2032: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2033: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_constraints';
2034: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2035: G_LEVEL_EXCEPTION);
2036: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2037: G_LEVEL_PROCEDURE);
2038: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

Line 2036: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

2032: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2033: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_constraints';
2034: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2035: G_LEVEL_EXCEPTION);
2036: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2037: G_LEVEL_PROCEDURE);
2038: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2039: G_LEVEL_STATEMENT);
2040:

Line 2038: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

2034: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2035: G_LEVEL_EXCEPTION);
2036: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2037: G_LEVEL_PROCEDURE);
2038: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2039: G_LEVEL_STATEMENT);
2040:
2041: BEGIN
2042: IF (is_debug_procedure_on) THEN

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

2039: G_LEVEL_STATEMENT);
2040:
2041: BEGIN
2042: IF (is_debug_procedure_on) THEN
2043: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
2044: END IF;
2045: IF (is_debug_statement_on) THEN
2046: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
2047: END IF;

Line 2046: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

2042: IF (is_debug_procedure_on) THEN
2043: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
2044: END IF;
2045: IF (is_debug_statement_on) THEN
2046: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
2047: END IF;
2048:
2049: check_bill_to_address (
2050: x_return_status => l_return_status,

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

2117: END IF;
2118:
2119: x_return_status := l_overall_status;
2120: IF (is_debug_procedure_on) THEN
2121: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
2122: END IF;
2123:
2124: EXCEPTION
2125:

Line 2128: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

2124: EXCEPTION
2125:
2126: WHEN OTHERS THEN
2127: IF (is_debug_exception_on) THEN
2128: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2129: END IF;
2130:
2131: -- store SQL error message on message stack for caller
2132: OKL_API.SET_MESSAGE (

Line 2162: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

2158:
2159: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2160: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2161: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_warning_constraints';
2162: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2163: G_LEVEL_EXCEPTION);
2164: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2165: G_LEVEL_PROCEDURE);
2166: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

Line 2164: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

2160: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2161: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_warning_constraints';
2162: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2163: G_LEVEL_EXCEPTION);
2164: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2165: G_LEVEL_PROCEDURE);
2166: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2167: G_LEVEL_STATEMENT);
2168:

Line 2166: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

2162: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2163: G_LEVEL_EXCEPTION);
2164: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2165: G_LEVEL_PROCEDURE);
2166: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2167: G_LEVEL_STATEMENT);
2168:
2169: BEGIN
2170: IF (is_debug_procedure_on) THEN

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

2167: G_LEVEL_STATEMENT);
2168:
2169: BEGIN
2170: IF (is_debug_procedure_on) THEN
2171: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
2172: END IF;
2173: IF (is_debug_statement_on) THEN
2174: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
2175: END IF;

Line 2174: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

2170: IF (is_debug_procedure_on) THEN
2171: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
2172: END IF;
2173: IF (is_debug_statement_on) THEN
2174: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
2175: END IF;
2176:
2177: check_termin_quote_parties (
2178: x_return_status => l_return_status,

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

2185: END IF;
2186:
2187: x_return_status := l_overall_status;
2188: IF (is_debug_procedure_on) THEN
2189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
2190: END IF;
2191:
2192: EXCEPTION
2193:

Line 2196: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);

2192: EXCEPTION
2193:
2194: WHEN OTHERS THEN
2195: IF (is_debug_exception_on) THEN
2196: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2197: END IF;
2198:
2199: -- store SQL error message on message stack for caller
2200: OKL_API.SET_MESSAGE (