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 413: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.set_invalid_rule_message');

409:
410: ELSE -- Invalid combination of values
411:
412: IF (is_debug_statement_on) THEN
413: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.set_invalid_rule_message');
414: END IF;
415: okl_am_util_pvt.set_invalid_rule_message (
416: p_rgd_code => p_rgd_code,
417: p_rdf_code => p_rdf_code);

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

415: okl_am_util_pvt.set_invalid_rule_message (
416: p_rgd_code => p_rgd_code,
417: p_rdf_code => p_rdf_code);
418: IF (is_debug_statement_on) THEN
419: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.set_invalid_rule_message');
420: END IF;
421:
422: l_return_status := OKL_API.G_RET_STS_ERROR;
423:

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

449: ELSE
450:
451: -- Invalid combination of values
452: IF (is_debug_statement_on) THEN
453: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.set_invalid_rule_message');
454: END IF;
455: okl_am_util_pvt.set_invalid_rule_message (
456: p_rgd_code => p_rgd_code,
457: p_rdf_code => p_rdf_code);

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

455: okl_am_util_pvt.set_invalid_rule_message (
456: p_rgd_code => p_rgd_code,
457: p_rdf_code => p_rdf_code);
458: IF (is_debug_statement_on) THEN
459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.set_invalid_rule_message');
460: END IF;
461:
462: l_return_status := OKL_API.G_RET_STS_ERROR;
463:

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

465: END IF;
466:
467: x_return_status := l_return_status;
468: IF (is_debug_procedure_on) THEN
469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
470: END IF;
471:
472: EXCEPTION
473:

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

472: EXCEPTION
473:
474: WHEN OTHERS THEN
475: IF (is_debug_exception_on) THEN
476: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
477: || sqlcode || ' , SQLERRM : ' || sqlerrm);
478: END IF;
479:
480: -- store SQL error message on message stack for caller

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

510: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
511: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
512: l_rulv_rec rulv_rec_type;
513: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_setup';
514: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
515: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
516: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
517:
518: BEGIN

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

511: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
512: l_rulv_rec rulv_rec_type;
513: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_setup';
514: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
515: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
516: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
517:
518: BEGIN
519: IF (is_debug_procedure_on) THEN

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

512: l_rulv_rec rulv_rec_type;
513: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_setup';
514: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
515: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
516: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
517:
518: BEGIN
519: IF (is_debug_procedure_on) THEN
520: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

516: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
517:
518: BEGIN
519: IF (is_debug_procedure_on) THEN
520: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
521: END IF;
522: IF (is_debug_statement_on) THEN
523: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
524: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);

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

519: IF (is_debug_procedure_on) THEN
520: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
521: END IF;
522: IF (is_debug_statement_on) THEN
523: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
524: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);
525: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
526: END IF;
527:

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

520: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
521: END IF;
522: IF (is_debug_statement_on) THEN
523: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
524: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);
525: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
526: END IF;
527:
528: IF (is_debug_statement_on) THEN

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

521: END IF;
522: IF (is_debug_statement_on) THEN
523: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgd_code: '||p_rgd_code);
524: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rdf_code: '||p_rdf_code);
525: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
526: END IF;
527:
528: IF (is_debug_statement_on) THEN
529: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

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

525: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
526: END IF;
527:
528: IF (is_debug_statement_on) THEN
529: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
530: END IF;
531: okl_am_util_pvt.get_rule_record (
532: p_rgd_code => p_rgd_code,
533: p_rdf_code => p_rdf_code,

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

536: p_message_yn => FALSE,
537: x_rulv_rec => l_rulv_rec,
538: x_return_status => l_return_status);
539: IF (is_debug_statement_on) THEN
540: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
541: END IF;
542:
543: -- If rule is not found, return Success
544: -- If rule is found, check its setup

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

613: END IF;
614:
615: x_return_status := l_overall_status;
616: IF (is_debug_procedure_on) THEN
617: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
618: END IF;
619:
620: EXCEPTION
621:

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

620: EXCEPTION
621:
622: WHEN OTHERS THEN
623: IF (is_debug_exception_on) THEN
624: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
625: END IF;
626:
627: -- store SQL error message on message stack for caller
628: OKL_API.SET_MESSAGE (

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

656: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
657: l_rulv_rec rulv_rec_type;
658: l_rgd_code VARCHAR2(30) := 'AMCOPO'; -- Contract Portfolio RG
659: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_contract_portfolio';
660: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
661: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
662: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
663:
664: BEGIN

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

657: l_rulv_rec rulv_rec_type;
658: l_rgd_code VARCHAR2(30) := 'AMCOPO'; -- Contract Portfolio RG
659: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_contract_portfolio';
660: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
661: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
662: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
663:
664: BEGIN
665: IF (is_debug_procedure_on) THEN

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

658: l_rgd_code VARCHAR2(30) := 'AMCOPO'; -- Contract Portfolio RG
659: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_contract_portfolio';
660: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
661: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
662: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
663:
664: BEGIN
665: IF (is_debug_procedure_on) THEN
666: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

662: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
663:
664: BEGIN
665: IF (is_debug_procedure_on) THEN
666: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
667: END IF;
668: IF (is_debug_statement_on) THEN
669: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
670: END IF;

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

665: IF (is_debug_procedure_on) THEN
666: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
667: END IF;
668: IF (is_debug_statement_on) THEN
669: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
670: END IF;
671:
672: -- *************
673: -- Budget Amount

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

673: -- Budget Amount
674: -- *************
675:
676: IF (is_debug_statement_on) THEN
677: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
678: END IF;
679: okl_am_util_pvt.get_rule_record (
680: p_rgd_code => l_rgd_code,
681: p_rdf_code => 'AMPRBA',

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

684: p_message_yn => TRUE,
685: x_rulv_rec => l_rulv_rec,
686: x_return_status => l_return_status);
687: IF (is_debug_statement_on) THEN
688: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
689: END IF;
690:
691: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
692: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

710: -- Strategy
711: -- ********
712:
713: IF (is_debug_statement_on) THEN
714: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
715: END IF;
716: okl_am_util_pvt.get_rule_record(
717: p_rgd_code => l_rgd_code,
718: p_rdf_code => 'AMPRST',

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

721: p_message_yn => TRUE,
722: x_rulv_rec => l_rulv_rec,
723: x_return_status => l_return_status);
724: IF (is_debug_statement_on) THEN
725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
726: END IF;
727:
728: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
729: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

735: -- Assignment Group
736: -- ****************
737:
738: IF (is_debug_statement_on) THEN
739: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
740: END IF;
741: okl_am_util_pvt.get_rule_record(
742: p_rgd_code => l_rgd_code,
743: p_rdf_code => 'AMPRAG',

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

746: p_message_yn => TRUE,
747: x_rulv_rec => l_rulv_rec,
748: x_return_status => l_return_status);
749: IF (is_debug_statement_on) THEN
750: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
751: END IF;
752:
753: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
754: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

760: -- Execution Due Date
761: -- ******************
762:
763: IF (is_debug_statement_on) THEN
764: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
765: END IF;
766: okl_am_util_pvt.get_rule_record(
767: p_rgd_code => l_rgd_code,
768: p_rdf_code => 'AMPRED',

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

771: p_message_yn => TRUE,
772: x_rulv_rec => l_rulv_rec,
773: x_return_status => l_return_status);
774: IF (is_debug_statement_on) THEN
775: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
776: END IF;
777:
778: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
779: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

782: END IF;
783:
784: x_return_status := l_overall_status;
785: IF (is_debug_procedure_on) THEN
786: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
787: END IF;
788:
789: EXCEPTION
790:

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

789: EXCEPTION
790:
791: WHEN OTHERS THEN
792: IF (is_debug_exception_on) THEN
793: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' ||
794: sqlerrm);
795: END IF;
796:
797: -- store SQL error message on message stack for caller

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

825: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
826: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
827: l_rulv_rec rulv_rec_type;
828: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_calculate_quote';
829: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
830: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
831: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
832:
833: BEGIN

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

826: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
827: l_rulv_rec rulv_rec_type;
828: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_calculate_quote';
829: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
830: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
831: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
832:
833: BEGIN
834: IF (is_debug_procedure_on) THEN

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

827: l_rulv_rec rulv_rec_type;
828: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_calculate_quote';
829: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
830: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
831: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
832:
833: BEGIN
834: IF (is_debug_procedure_on) THEN
835: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

831: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
832:
833: BEGIN
834: IF (is_debug_procedure_on) THEN
835: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
836: END IF;
837: IF (is_debug_statement_on) THEN
838: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
839: END IF;

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

834: IF (is_debug_procedure_on) THEN
835: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
836: END IF;
837: IF (is_debug_statement_on) THEN
838: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
839: END IF;
840:
841: -- ***************************************
842: -- Top End of Term Purchase Option Formula

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

842: -- Top End of Term Purchase Option Formula
843: -- ***************************************
844:
845: IF (is_debug_statement_on) THEN
846: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
847: END IF;
848: okl_am_util_pvt.get_rule_record(
849: p_rgd_code => 'AMTFOC',
850: p_rdf_code => 'AMBPOC',

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

853: p_message_yn => TRUE,
854: x_rulv_rec => l_rulv_rec,
855: x_return_status => l_return_status);
856: IF (is_debug_statement_on) THEN
857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
858: END IF;
859:
860: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
861: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

1157: END IF;
1158:
1159: x_return_status := l_overall_status;
1160: IF (is_debug_procedure_on) THEN
1161: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1162: END IF;
1163:
1164: EXCEPTION
1165:

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

1164: EXCEPTION
1165:
1166: WHEN OTHERS THEN
1167: IF (is_debug_exception_on) THEN
1168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1169: END IF;
1170:
1171: -- store SQL error message on message stack for caller
1172: OKL_API.SET_MESSAGE (

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

1199: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1200: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1201: l_rulv_rec rulv_rec_type;
1202: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_create_quote';
1203: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1204: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1205: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1206:
1207: BEGIN

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

1200: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1201: l_rulv_rec rulv_rec_type;
1202: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_create_quote';
1203: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1204: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1205: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1206:
1207: BEGIN
1208: IF (is_debug_procedure_on) THEN

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

1201: l_rulv_rec rulv_rec_type;
1202: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_create_quote';
1203: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1204: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1205: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1206:
1207: BEGIN
1208: IF (is_debug_procedure_on) THEN
1209: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1205: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1206:
1207: BEGIN
1208: IF (is_debug_procedure_on) THEN
1209: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1210: END IF;
1211: IF (is_debug_statement_on) THEN
1212: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1213: END IF;

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

1208: IF (is_debug_procedure_on) THEN
1209: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1210: END IF;
1211: IF (is_debug_statement_on) THEN
1212: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1213: END IF;
1214:
1215: -- *******************************************************
1216: -- Quote Effectivity for Termination and Repurchase Quotes

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

1216: -- Quote Effectivity for Termination and Repurchase Quotes
1217: -- *******************************************************
1218:
1219: IF (is_debug_statement_on) THEN
1220: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
1221: END IF;
1222: okl_am_util_pvt.get_rule_record(
1223: p_rgd_code => 'AMTQPR',
1224: p_rdf_code => 'AMQTEF',

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

1227: p_message_yn => TRUE,
1228: x_rulv_rec => l_rulv_rec,
1229: x_return_status => l_return_status);
1230: IF (is_debug_statement_on) THEN
1231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
1232: END IF;
1233:
1234: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1235: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

1256: -- Term Status for Termination Quote
1257: -- *********************************
1258:
1259: IF (is_debug_statement_on) THEN
1260: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
1261: END IF;
1262: okl_am_util_pvt.get_rule_record(
1263: p_rgd_code => 'AMTQPR',
1264: p_rdf_code => 'AMTSET',

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

1267: p_message_yn => TRUE,
1268: x_rulv_rec => l_rulv_rec,
1269: x_return_status => l_return_status);
1270: IF (is_debug_statement_on) THEN
1271: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
1272: END IF;
1273:
1274: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1275: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

1278: END IF;
1279:
1280: x_return_status := l_overall_status;
1281: IF (is_debug_procedure_on) THEN
1282: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1283: END IF;
1284:
1285: EXCEPTION
1286:

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

1285: EXCEPTION
1286:
1287: WHEN OTHERS THEN
1288: IF (is_debug_exception_on) THEN
1289: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1290: END IF;
1291:
1292: -- store SQL error message on message stack for caller
1293: OKL_API.SET_MESSAGE (

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

1319:
1320: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1321: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1322: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_quote_wf';
1323: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1324: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1325: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1326:
1327: BEGIN

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

1320: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1321: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1322: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_quote_wf';
1323: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1324: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1325: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1326:
1327: BEGIN
1328: IF (is_debug_procedure_on) THEN

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

1321: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1322: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_quote_wf';
1323: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1324: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1325: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1326:
1327: BEGIN
1328: IF (is_debug_procedure_on) THEN
1329: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1325: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1326:
1327: BEGIN
1328: IF (is_debug_procedure_on) THEN
1329: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1330: END IF;
1331: IF (is_debug_statement_on) THEN
1332: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1333: END IF;

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

1328: IF (is_debug_procedure_on) THEN
1329: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1330: END IF;
1331: IF (is_debug_statement_on) THEN
1332: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1333: END IF;
1334:
1335: -- *************
1336: -- Gain and Loss

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

1349: END IF;
1350:
1351: x_return_status := l_overall_status;
1352: IF (is_debug_procedure_on) THEN
1353: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1354: END IF;
1355:
1356: EXCEPTION
1357:

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

1356: EXCEPTION
1357:
1358: WHEN OTHERS THEN
1359: IF (is_debug_exception_on) THEN
1360: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1361: END IF;
1362:
1363: -- store SQL error message on message stack for caller
1364: OKL_API.SET_MESSAGE (

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

1404: l_qpyv_tbl qpyv_tbl_type; -- Quote Parties
1405: l_taiv_rec taiv_rec_type; -- Billing Header
1406: e_taiv_rec taiv_rec_type; -- Empty Billing Header
1407: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_termin_quote_parties';
1408: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1409: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1410: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1411:
1412: BEGIN

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

1405: l_taiv_rec taiv_rec_type; -- Billing Header
1406: e_taiv_rec taiv_rec_type; -- Empty Billing Header
1407: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_termin_quote_parties';
1408: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1409: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1410: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1411:
1412: BEGIN
1413: IF (is_debug_procedure_on) THEN

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

1406: e_taiv_rec taiv_rec_type; -- Empty Billing Header
1407: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_termin_quote_parties';
1408: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1409: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1410: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1411:
1412: BEGIN
1413: IF (is_debug_procedure_on) THEN
1414: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1410: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1411:
1412: BEGIN
1413: IF (is_debug_procedure_on) THEN
1414: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1415: END IF;
1416: IF (is_debug_statement_on) THEN
1417: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1418: END IF;

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

1413: IF (is_debug_procedure_on) THEN
1414: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1415: END IF;
1416: IF (is_debug_statement_on) THEN
1417: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1418: END IF;
1419:
1420: -- ********************************************
1421: -- Validate all quote parties using setup rules

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

1423:
1424: l_qtev_rec.khr_id := p_chr_id;
1425:
1426: IF (is_debug_statement_on) THEN
1427: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_parties_pvt.create_quote_parties');
1428: END IF;
1429: -- The procedure will issue warning messages
1430: okl_am_parties_pvt.create_quote_parties (
1431: p_qtev_rec => l_qtev_rec,

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

1432: p_validate_only => TRUE,
1433: x_qpyv_tbl => l_qpyv_tbl,
1434: x_return_status => l_return_status);
1435: IF (is_debug_statement_on) THEN
1436: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_parties_pvt.create_quote_parties , return status: ' || l_return_status);
1437: END IF;
1438:
1439: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1440: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

1451: l_taiv_rec := e_taiv_rec;
1452: l_taiv_rec.khr_id := p_chr_id;
1453:
1454: IF (is_debug_statement_on) THEN
1455: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_invoices_pvt.get_vendor_billing_info');
1456: END IF;
1457: -- The procedure will issue warning messages
1458: okl_am_invoices_pvt.get_vendor_billing_info (
1459: p_cpl_id => l_vendor_rec.cpl_id,

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

1459: p_cpl_id => l_vendor_rec.cpl_id,
1460: px_taiv_rec => l_taiv_rec,
1461: x_return_status => l_return_status);
1462: IF (is_debug_statement_on) THEN
1463: 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);
1464: END IF;
1465:
1466: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1467: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR

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

1473: END LOOP;
1474:
1475: x_return_status := l_overall_status;
1476: IF (is_debug_procedure_on) THEN
1477: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1478: END IF;
1479:
1480: EXCEPTION
1481:

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

1480: EXCEPTION
1481:
1482: WHEN OTHERS THEN
1483: IF (is_debug_exception_on) THEN
1484: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1485: END IF;
1486:
1487: -- close open cursors
1488: IF l_vendor_csr%ISOPEN THEN

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

1523: l_qtev_rec qtev_rec_type; -- Quote Header
1524: l_qpyv_tbl qpyv_tbl_type; -- Quote Parties
1525: l_taiv_rec taiv_rec_type; -- Billing Header
1526: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_repurch_quote_parties';
1527: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1528: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1529: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1530:
1531: BEGIN

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

1524: l_qpyv_tbl qpyv_tbl_type; -- Quote Parties
1525: l_taiv_rec taiv_rec_type; -- Billing Header
1526: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_repurch_quote_parties';
1527: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1528: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1529: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1530:
1531: BEGIN
1532: IF (is_debug_procedure_on) THEN

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

1525: l_taiv_rec taiv_rec_type; -- Billing Header
1526: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_repurch_quote_parties';
1527: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1528: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1529: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1530:
1531: BEGIN
1532: IF (is_debug_procedure_on) THEN
1533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1529: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1530:
1531: BEGIN
1532: IF (is_debug_procedure_on) THEN
1533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1534: END IF;
1535: IF (is_debug_statement_on) THEN
1536: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1537: END IF;

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

1532: IF (is_debug_procedure_on) THEN
1533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1534: END IF;
1535: IF (is_debug_statement_on) THEN
1536: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1537: END IF;
1538:
1539: IF get_repurchase_agreement (p_chr_id) = 'Y' THEN
1540:

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

1544:
1545: l_qtev_rec.khr_id := p_chr_id;
1546:
1547: IF (is_debug_statement_on) THEN
1548: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_parties_pvt.create_partner_as_recipient');
1549: END IF;
1550: -- The procedure will issue error messages if needed
1551: okl_am_parties_pvt.create_partner_as_recipient (
1552: p_qtev_rec => l_qtev_rec,

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

1553: p_validate_only => TRUE,
1554: x_qpyv_tbl => l_qpyv_tbl,
1555: x_return_status => l_return_status);
1556: IF (is_debug_statement_on) THEN
1557: 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);
1558: END IF;
1559:
1560: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1561: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

1569:
1570: l_taiv_rec.khr_id := p_chr_id;
1571:
1572: IF (is_debug_statement_on) THEN
1573: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_invoices_pvt.get_vendor_billing_info');
1574: END IF;
1575: -- The procedure will issue error messages if needed
1576: okl_am_invoices_pvt.get_vendor_billing_info (
1577: px_taiv_rec => l_taiv_rec,

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

1576: okl_am_invoices_pvt.get_vendor_billing_info (
1577: px_taiv_rec => l_taiv_rec,
1578: x_return_status => l_return_status);
1579: IF (is_debug_statement_on) THEN
1580: 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);
1581: END IF;
1582:
1583: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1584: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR

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

1590: END IF;
1591:
1592: x_return_status := l_overall_status;
1593: IF (is_debug_procedure_on) THEN
1594: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1595: END IF;
1596:
1597: EXCEPTION
1598:

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

1597: EXCEPTION
1598:
1599: WHEN OTHERS THEN
1600: IF (is_debug_exception_on) THEN
1601: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1602: END IF;
1603:
1604: -- store SQL error message on message stack for caller
1605: OKL_API.SET_MESSAGE (

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

1631:
1632: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1633: l_bill_to_address_rec okx_cust_site_uses_v%ROWTYPE;
1634: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_bill_to_address';
1635: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1636: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1637: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1638:
1639: BEGIN

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

1632: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1633: l_bill_to_address_rec okx_cust_site_uses_v%ROWTYPE;
1634: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_bill_to_address';
1635: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1636: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1637: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1638:
1639: BEGIN
1640: IF (is_debug_procedure_on) THEN

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

1633: l_bill_to_address_rec okx_cust_site_uses_v%ROWTYPE;
1634: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_bill_to_address';
1635: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1636: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1637: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1638:
1639: BEGIN
1640: IF (is_debug_procedure_on) THEN
1641: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1637: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1638:
1639: BEGIN
1640: IF (is_debug_procedure_on) THEN
1641: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1642: END IF;
1643: IF (is_debug_statement_on) THEN
1644: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1645: END IF;

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

1640: IF (is_debug_procedure_on) THEN
1641: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1642: END IF;
1643: IF (is_debug_statement_on) THEN
1644: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1645: END IF;
1646:
1647: IF (is_debug_statement_on) THEN
1648: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_bill_to_address');

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

1644: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1645: END IF;
1646:
1647: IF (is_debug_statement_on) THEN
1648: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_bill_to_address');
1649: END IF;
1650: okl_am_util_pvt.get_bill_to_address (
1651: p_contract_id => p_chr_id,
1652: x_bill_to_address_rec => l_bill_to_address_rec,

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

1651: p_contract_id => p_chr_id,
1652: x_bill_to_address_rec => l_bill_to_address_rec,
1653: x_return_status => l_return_status);
1654: IF (is_debug_statement_on) THEN
1655: 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);
1656: END IF;
1657:
1658: x_return_status := l_return_status;
1659: IF (is_debug_procedure_on) THEN

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

1656: END IF;
1657:
1658: x_return_status := l_return_status;
1659: IF (is_debug_procedure_on) THEN
1660: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1661: END IF;
1662:
1663: EXCEPTION
1664:

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

1663: EXCEPTION
1664:
1665: WHEN OTHERS THEN
1666: IF (is_debug_exception_on) THEN
1667: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1668: END IF;
1669:
1670: -- store SQL error message on message stack for caller
1671: OKL_API.SET_MESSAGE (

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

1717: l_contract_end_date DATE;
1718: l_sysdate DATE := SYSDATE;
1719: l_calculate_sdd BOOLEAN;
1720: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_sec_dep_disp';
1721: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1722: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1723: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1724:
1725: BEGIN

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

1718: l_sysdate DATE := SYSDATE;
1719: l_calculate_sdd BOOLEAN;
1720: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_sec_dep_disp';
1721: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1722: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1723: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1724:
1725: BEGIN
1726: IF (is_debug_procedure_on) THEN

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

1719: l_calculate_sdd BOOLEAN;
1720: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_sec_dep_disp';
1721: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1722: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1723: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1724:
1725: BEGIN
1726: IF (is_debug_procedure_on) THEN
1727: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1723: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1724:
1725: BEGIN
1726: IF (is_debug_procedure_on) THEN
1727: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1728: END IF;
1729: IF (is_debug_statement_on) THEN
1730: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1731: END IF;

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

1726: IF (is_debug_procedure_on) THEN
1727: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1728: END IF;
1729: IF (is_debug_statement_on) THEN
1730: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1731: END IF;
1732:
1733: -- *************************
1734: -- Get Security Deposit Rule

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

1734: -- Get Security Deposit Rule
1735: -- *************************
1736:
1737: IF (is_debug_statement_on) THEN
1738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
1739: END IF;
1740: okl_am_util_pvt.get_rule_record (
1741: p_rgd_code => 'LASDEP',
1742: p_rdf_code => 'LASDEP',

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

1745: x_rulv_rec => l_rulv_rec,
1746: x_return_status => l_return_status,
1747: p_message_yn => FALSE);
1748: IF (is_debug_statement_on) THEN
1749: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
1750: END IF;
1751:
1752: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1753:

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

1787: END IF;
1788:
1789: x_return_status := l_return_status;
1790: IF (is_debug_procedure_on) THEN
1791: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1792: END IF;
1793:
1794: EXCEPTION
1795:

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

1794: EXCEPTION
1795:
1796: WHEN OTHERS THEN
1797: IF (is_debug_exception_on) THEN
1798: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1799: END IF;
1800:
1801: -- Close open cursors
1802:

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

1836:
1837: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1838: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1839: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_am_rule_format';
1840: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1841: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1842: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1843:
1844: BEGIN

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

1837: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1838: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1839: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_am_rule_format';
1840: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1841: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1842: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1843:
1844: BEGIN
1845: IF (is_debug_procedure_on) THEN

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

1838: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1839: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_am_rule_format';
1840: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1841: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1842: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1843:
1844: BEGIN
1845: IF (is_debug_procedure_on) THEN
1846: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

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

1842: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1843:
1844: BEGIN
1845: IF (is_debug_procedure_on) THEN
1846: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1847: END IF;
1848: IF (is_debug_statement_on) THEN
1849: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1850: 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 1849: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);

1845: IF (is_debug_procedure_on) THEN
1846: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1847: END IF;
1848: IF (is_debug_statement_on) THEN
1849: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1850: 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);
1851: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1852: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1853: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);

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

1846: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1847: END IF;
1848: IF (is_debug_statement_on) THEN
1849: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1850: 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);
1851: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1852: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1853: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1854: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);

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

1847: END IF;
1848: IF (is_debug_statement_on) THEN
1849: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1850: 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);
1851: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1852: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1853: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1854: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);

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

1848: IF (is_debug_statement_on) THEN
1849: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1850: 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);
1851: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1852: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1853: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1854: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);

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

1849: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
1850: 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);
1851: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1852: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1853: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1854: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);

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

1850: 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);
1851: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1852: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1853: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1854: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1858: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);

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

1851: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rgd_code: ' || p_rgr_rec.rgd_code);
1852: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1853: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1854: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1858: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);

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

1852: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information1: ' || p_rgr_rec.rule_information1);
1853: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1854: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1858: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);

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

1853: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information2: ' || p_rgr_rec.rule_information2);
1854: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1858: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);
1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information10: ' || p_rgr_rec.rule_information10);

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

1854: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information3: ' || p_rgr_rec.rule_information3);
1855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1858: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);
1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information10: ' || p_rgr_rec.rule_information10);
1862: END IF;

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

1855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information4: ' || p_rgr_rec.rule_information4);
1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1858: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);
1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information10: ' || p_rgr_rec.rule_information10);
1862: END IF;
1863:

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

1856: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information5: ' || p_rgr_rec.rule_information5);
1857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1858: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);
1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information10: ' || p_rgr_rec.rule_information10);
1862: END IF;
1863:
1864:

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

1857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information6: ' || p_rgr_rec.rule_information6);
1858: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information7: ' || p_rgr_rec.rule_information7);
1859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information8: ' || p_rgr_rec.rule_information8);
1860: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information9: ' || p_rgr_rec.rule_information9);
1861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_rgr_rec.rule_information10: ' || p_rgr_rec.rule_information10);
1862: END IF;
1863:
1864:
1865: -- **************************************************

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

1979: END IF;
1980:
1981: x_return_status := l_overall_status;
1982: IF (is_debug_procedure_on) THEN
1983: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1984: END IF;
1985:
1986: EXCEPTION
1987:

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

1986: EXCEPTION
1987:
1988: WHEN OTHERS THEN
1989: IF (is_debug_exception_on) THEN
1990: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1991: END IF;
1992:
1993: -- store SQL error message on message stack for caller
1994: OKL_API.SET_MESSAGE (

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

2020:
2021: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2022: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2023: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_constraints';
2024: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2025: G_LEVEL_EXCEPTION);
2026: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2027: G_LEVEL_PROCEDURE);
2028: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

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

2022: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2023: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_constraints';
2024: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2025: G_LEVEL_EXCEPTION);
2026: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2027: G_LEVEL_PROCEDURE);
2028: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2029: G_LEVEL_STATEMENT);
2030:

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

2024: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2025: G_LEVEL_EXCEPTION);
2026: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2027: G_LEVEL_PROCEDURE);
2028: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2029: G_LEVEL_STATEMENT);
2030:
2031: BEGIN
2032: IF (is_debug_procedure_on) THEN

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

2029: G_LEVEL_STATEMENT);
2030:
2031: BEGIN
2032: IF (is_debug_procedure_on) THEN
2033: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
2034: END IF;
2035: IF (is_debug_statement_on) THEN
2036: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
2037: END IF;

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

2032: IF (is_debug_procedure_on) THEN
2033: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
2034: END IF;
2035: IF (is_debug_statement_on) THEN
2036: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
2037: END IF;
2038:
2039: check_bill_to_address (
2040: x_return_status => l_return_status,

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

2107: END IF;
2108:
2109: x_return_status := l_overall_status;
2110: IF (is_debug_procedure_on) THEN
2111: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
2112: END IF;
2113:
2114: EXCEPTION
2115:

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

2114: EXCEPTION
2115:
2116: WHEN OTHERS THEN
2117: IF (is_debug_exception_on) THEN
2118: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2119: END IF;
2120:
2121: -- store SQL error message on message stack for caller
2122: OKL_API.SET_MESSAGE (

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

2148:
2149: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2150: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2151: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_warning_constraints';
2152: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2153: G_LEVEL_EXCEPTION);
2154: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2155: G_LEVEL_PROCEDURE);
2156: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

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

2150: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2151: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_warning_constraints';
2152: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2153: G_LEVEL_EXCEPTION);
2154: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2155: G_LEVEL_PROCEDURE);
2156: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2157: G_LEVEL_STATEMENT);
2158:

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

2152: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2153: G_LEVEL_EXCEPTION);
2154: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2155: G_LEVEL_PROCEDURE);
2156: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2157: G_LEVEL_STATEMENT);
2158:
2159: BEGIN
2160: IF (is_debug_procedure_on) THEN

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

2157: G_LEVEL_STATEMENT);
2158:
2159: BEGIN
2160: IF (is_debug_procedure_on) THEN
2161: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
2162: END IF;
2163: IF (is_debug_statement_on) THEN
2164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
2165: END IF;

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

2160: IF (is_debug_procedure_on) THEN
2161: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
2162: END IF;
2163: IF (is_debug_statement_on) THEN
2164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
2165: END IF;
2166:
2167: check_termin_quote_parties (
2168: x_return_status => l_return_status,

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

2175: END IF;
2176:
2177: x_return_status := l_overall_status;
2178: IF (is_debug_procedure_on) THEN
2179: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
2180: END IF;
2181:
2182: EXCEPTION
2183:

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

2182: EXCEPTION
2183:
2184: WHEN OTHERS THEN
2185: IF (is_debug_exception_on) THEN
2186: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2187: END IF;
2188:
2189: -- store SQL error message on message stack for caller
2190: OKL_API.SET_MESSAGE (