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_EC_EVALUATE_PVT dependencies on FND_LOG

Line 16: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_lookup_meaning';

12: FROM fnd_lookups fnd
13: WHERE fnd.lookup_type = p_lookup_type
14: AND fnd.lookup_code = p_lookup_code;
15: l_return_value varchar2(200) := okl_api.g_miss_char;
16: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_lookup_meaning';
17: l_debug_enabled varchar2(10);
18: is_debug_procedure_on boolean;
19: is_debug_statement_on boolean;
20:

Line 24: ,fnd_log.level_procedure);

20:
21: BEGIN
22: l_debug_enabled := okl_debug_pub.check_log_enabled;
23: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
24: ,fnd_log.level_procedure);
25:
26: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
27: okl_debug_pub.log_debug(fnd_log.level_procedure
28: ,l_module

Line 27: okl_debug_pub.log_debug(fnd_log.level_procedure

23: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
24: ,fnd_log.level_procedure);
25:
26: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
27: okl_debug_pub.log_debug(fnd_log.level_procedure
28: ,l_module
29: ,'begin debug OKLRECUB.pls.pls call get_lookup_meaning');
30: END IF;
31:

Line 39: okl_debug_pub.log_debug(fnd_log.level_procedure

35: CLOSE fnd_lookup_csr;
36: END IF;
37:
38: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
39: okl_debug_pub.log_debug(fnd_log.level_procedure
40: ,l_module
41: ,'end debug OKLRECUB.pls.pls call evaluate_territory');
42: END IF;
43: RETURN l_return_value;

Line 59: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.set_fnd_message';

55: ,p_value3 IN varchar2 DEFAULT NULL
56: ,p_token4 IN varchar2 DEFAULT NULL
57: ,p_value4 IN varchar2 DEFAULT NULL) IS
58: l_msg varchar2(2700);
59: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.set_fnd_message';
60: l_debug_enabled varchar2(10);
61: is_debug_procedure_on boolean;
62: is_debug_statement_on boolean;
63:

Line 67: ,fnd_log.level_procedure);

63:
64: BEGIN
65: l_debug_enabled := okl_debug_pub.check_log_enabled;
66: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
67: ,fnd_log.level_procedure);
68:
69: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
70: okl_debug_pub.log_debug(fnd_log.level_procedure
71: ,l_module

Line 70: okl_debug_pub.log_debug(fnd_log.level_procedure

66: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
67: ,fnd_log.level_procedure);
68:
69: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
70: okl_debug_pub.log_debug(fnd_log.level_procedure
71: ,l_module
72: ,'begin debug OKLRECUB.pls.pls call set_fnd_message');
73: END IF;
74: fnd_message.set_name(g_app_name, p_msg_name);

Line 93: okl_debug_pub.log_debug(fnd_log.level_procedure

89: fnd_message.set_token(token => p_token4, value => p_value4);
90: END IF;
91:
92: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
93: okl_debug_pub.log_debug(fnd_log.level_procedure
94: ,l_module
95: ,'end debug OKLRECUB.pls.pls call set_fnd_message');
96: END IF;
97:

Line 114: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_msg_single';

110: FROM fnd_lookups
111: WHERE lookup_type = 'OKL_FE_OPERATORS' AND lookup_code = p_operator;
112: l_operator varchar2(30);
113: l_msg varchar2(240);
114: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_msg_single';
115: l_debug_enabled varchar2(10);
116: is_debug_procedure_on boolean;
117: is_debug_statement_on boolean;
118:

Line 122: ,fnd_log.level_procedure);

118:
119: BEGIN
120: l_debug_enabled := okl_debug_pub.check_log_enabled;
121: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
122: ,fnd_log.level_procedure);
123:
124: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
125: okl_debug_pub.log_debug(fnd_log.level_procedure
126: ,l_module

Line 125: okl_debug_pub.log_debug(fnd_log.level_procedure

121: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
122: ,fnd_log.level_procedure);
123:
124: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
125: okl_debug_pub.log_debug(fnd_log.level_procedure
126: ,l_module
127: ,'begin debug OKLRECUB.pls.pls call get_msg_single');
128: END IF;
129: OPEN get_op;

Line 143: okl_debug_pub.log_debug(fnd_log.level_procedure

139: ,p_token4 => 'SOURCE'
140: ,p_value4 => p_src_name);
141:
142: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
143: okl_debug_pub.log_debug(fnd_log.level_procedure
144: ,l_module
145: ,'end debug OKLRECUB.pls.pls call get_msg_single');
146: END IF;
147: RETURN fnd_message.get;

Line 158: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_msg_range';

154: ,p_val1 IN varchar2
155: ,p_val2 IN varchar2
156: ,p_src_name IN varchar2) RETURN varchar2 IS
157: l_msg varchar2(240);
158: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_msg_range';
159: l_debug_enabled varchar2(10);
160: is_debug_procedure_on boolean;
161: is_debug_statement_on boolean;
162:

Line 166: ,fnd_log.level_procedure);

162:
163: BEGIN
164: l_debug_enabled := okl_debug_pub.check_log_enabled;
165: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
166: ,fnd_log.level_procedure);
167:
168: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
169: okl_debug_pub.log_debug(fnd_log.level_procedure
170: ,l_module

Line 169: okl_debug_pub.log_debug(fnd_log.level_procedure

165: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
166: ,fnd_log.level_procedure);
167:
168: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
169: okl_debug_pub.log_debug(fnd_log.level_procedure
170: ,l_module
171: ,'begin debug OKLRECUB.pls.pls call get_msg_range');
172: END IF;
173: set_fnd_message(p_msg_name => 'OKL_EC_QA_RANGE'

Line 184: okl_debug_pub.log_debug(fnd_log.level_procedure

180: ,p_token4 => 'SOURCE'
181: ,p_value4 => p_src_name);
182:
183: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
184: okl_debug_pub.log_debug(fnd_log.level_procedure
185: ,l_module
186: ,'end debug OKLRECUB.pls.pls call get_msg_range');
187: END IF;
188: RETURN fnd_message.get;

Line 197: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_msg_multiple';

193: **/
194: FUNCTION get_msg_multiple(p_ec_name IN varchar2
195: ,p_src_name IN varchar2) RETURN varchar2 IS
196: l_msg varchar2(240);
197: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_msg_multiple';
198: l_debug_enabled varchar2(10);
199: is_debug_procedure_on boolean;
200: is_debug_statement_on boolean;
201:

Line 205: ,fnd_log.level_procedure);

201:
202: BEGIN
203: l_debug_enabled := okl_debug_pub.check_log_enabled;
204: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
205: ,fnd_log.level_procedure);
206:
207: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
208: okl_debug_pub.log_debug(fnd_log.level_procedure
209: ,l_module

Line 208: okl_debug_pub.log_debug(fnd_log.level_procedure

204: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
205: ,fnd_log.level_procedure);
206:
207: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
208: okl_debug_pub.log_debug(fnd_log.level_procedure
209: ,l_module
210: ,'begin debug OKLRECUB.pls.pls call get_msg_multiple');
211: END IF;
212: set_fnd_message(p_msg_name => 'OKL_EC_QA_MULTIPLE'

Line 219: okl_debug_pub.log_debug(fnd_log.level_procedure

215: ,p_token2 => 'SOURCE'
216: ,p_value2 => p_src_name);
217:
218: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
219: okl_debug_pub.log_debug(fnd_log.level_procedure
220: ,l_module
221: ,'end debug OKLRECUB.pls.pls call get_msg_multiple');
222: END IF;
223: RETURN fnd_message.get;

Line 232: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_msg_user';

228: **/
229: FUNCTION get_msg_user(p_ec_name IN varchar2
230: ,p_src_name IN varchar2) RETURN varchar2 IS
231: l_msg varchar2(240);
232: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_msg_user';
233: l_debug_enabled varchar2(10);
234: is_debug_procedure_on boolean;
235: is_debug_statement_on boolean;
236:

Line 240: ,fnd_log.level_procedure);

236:
237: BEGIN
238: l_debug_enabled := okl_debug_pub.check_log_enabled;
239: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
240: ,fnd_log.level_procedure);
241:
242: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
243: okl_debug_pub.log_debug(fnd_log.level_procedure
244: ,l_module

Line 243: okl_debug_pub.log_debug(fnd_log.level_procedure

239: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
240: ,fnd_log.level_procedure);
241:
242: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
243: okl_debug_pub.log_debug(fnd_log.level_procedure
244: ,l_module
245: ,'begin debug OKLRECUB.pls.pls call get_msg_user');
246: END IF;
247: set_fnd_message(p_msg_name => 'OKL_EC_QA_USER'

Line 254: okl_debug_pub.log_debug(fnd_log.level_procedure

250: ,p_token2 => 'SOURCE'
251: ,p_value2 => p_src_name);
252:
253: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
254: okl_debug_pub.log_debug(fnd_log.level_procedure
255: ,l_module
256: ,'end debug OKLRECUB.pls.pls call get_msg_user');
257: END IF;
258: RETURN fnd_message.get;

Line 266: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_msg_success';

262: **/
263: FUNCTION get_msg_success(p_ec_name IN varchar2
264: ,p_src_name IN varchar2) RETURN varchar2 IS
265: l_msg varchar2(240);
266: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_msg_success';
267: l_debug_enabled varchar2(10);
268: is_debug_procedure_on boolean;
269: is_debug_statement_on boolean;
270:

Line 274: ,fnd_log.level_procedure);

270:
271: BEGIN
272: l_debug_enabled := okl_debug_pub.check_log_enabled;
273: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
274: ,fnd_log.level_procedure);
275:
276: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
277: okl_debug_pub.log_debug(fnd_log.level_procedure
278: ,l_module

Line 277: okl_debug_pub.log_debug(fnd_log.level_procedure

273: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
274: ,fnd_log.level_procedure);
275:
276: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
277: okl_debug_pub.log_debug(fnd_log.level_procedure
278: ,l_module
279: ,'begin debug OKLRECUB.pls.pls call get_msg_success');
280: END IF;
281: set_fnd_message(p_msg_name => 'OKL_EC_QA_SUCCESS'

Line 288: okl_debug_pub.log_debug(fnd_log.level_procedure

284: ,p_token2 => 'SOURCE'
285: ,p_value2 => p_src_name);
286:
287: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
288: okl_debug_pub.log_debug(fnd_log.level_procedure
289: ,l_module
290: ,'end debug OKLRECUB.pls.pls call get_msg_success');
291: END IF;
292: RETURN fnd_message.get;

Line 302: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_advance_rent';

298: FUNCTION validate_advance_rent(p_operator_code IN varchar2
299: ,p_value1 IN varchar2
300: ,p_advance_rent IN number) RETURN number IS
301: l_numval1 number;
302: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_advance_rent';
303: l_debug_enabled varchar2(10);
304: is_debug_procedure_on boolean;
305: is_debug_statement_on boolean;
306:

Line 310: ,fnd_log.level_procedure);

306:
307: BEGIN
308: l_debug_enabled := okl_debug_pub.check_log_enabled;
309: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
310: ,fnd_log.level_procedure);
311:
312: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
313: okl_debug_pub.log_debug(fnd_log.level_procedure
314: ,l_module

Line 313: okl_debug_pub.log_debug(fnd_log.level_procedure

309: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
310: ,fnd_log.level_procedure);
311:
312: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
313: okl_debug_pub.log_debug(fnd_log.level_procedure
314: ,l_module
315: ,'begin debug OKLRECUB.pls.pls call validate_advance_rent');
316: END IF;
317: l_numval1 := to_number(p_value1);

Line 322: okl_debug_pub.log_debug(fnd_log.level_procedure

318:
319: IF p_operator_code = 'EQ' THEN
320: IF p_advance_rent = l_numval1 THEN
321: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
322: okl_debug_pub.log_debug(fnd_log.level_procedure
323: ,l_module
324: ,'end debug OKLRECUB.pls.pls call validate_advance_rent');
325: END IF;
326: RETURN 1;

Line 329: okl_debug_pub.log_debug(fnd_log.level_procedure

325: END IF;
326: RETURN 1;
327: ELSE
328: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
329: okl_debug_pub.log_debug(fnd_log.level_procedure
330: ,l_module
331: ,'end debug OKLRECUB.pls.pls call validate_advance_rent');
332: END IF;
333: RETURN 0;

Line 338: okl_debug_pub.log_debug(fnd_log.level_procedure

334: END IF;
335: ELSIF p_operator_code = 'NE' THEN
336: IF p_advance_rent <> l_numval1 THEN
337: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
338: okl_debug_pub.log_debug(fnd_log.level_procedure
339: ,l_module
340: ,'end debug OKLRECUB.pls.pls call validate_advance_rent');
341: END IF;
342: RETURN 1;

Line 345: okl_debug_pub.log_debug(fnd_log.level_procedure

341: END IF;
342: RETURN 1;
343: ELSE
344: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
345: okl_debug_pub.log_debug(fnd_log.level_procedure
346: ,l_module
347: ,'end debug OKLRECUB.pls.pls call validate_advance_rent');
348: END IF;
349: RETURN 0;

Line 354: okl_debug_pub.log_debug(fnd_log.level_procedure

350: END IF;
351: ELSIF p_operator_code = 'LT' THEN
352: IF p_advance_rent < l_numval1 THEN
353: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
354: okl_debug_pub.log_debug(fnd_log.level_procedure
355: ,l_module
356: ,'end debug OKLRECUB.pls.pls call validate_advance_rent');
357: END IF;
358: RETURN 1;

Line 361: okl_debug_pub.log_debug(fnd_log.level_procedure

357: END IF;
358: RETURN 1;
359: ELSE
360: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
361: okl_debug_pub.log_debug(fnd_log.level_procedure
362: ,l_module
363: ,'end debug OKLRECUB.pls.pls call validate_advance_rent');
364: END IF;
365: RETURN 0;

Line 370: okl_debug_pub.log_debug(fnd_log.level_procedure

366: END IF;
367: ELSIF p_operator_code = 'GT' THEN
368: IF p_advance_rent > l_numval1 THEN
369: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
370: okl_debug_pub.log_debug(fnd_log.level_procedure
371: ,l_module
372: ,'end debug OKLRECUB.pls.pls call validate_advance_rent');
373: END IF;
374: RETURN 1;

Line 377: okl_debug_pub.log_debug(fnd_log.level_procedure

373: END IF;
374: RETURN 1;
375: ELSE
376: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
377: okl_debug_pub.log_debug(fnd_log.level_procedure
378: ,l_module
379: ,'end debug OKLRECUB.pls.pls call validate_advance_rent');
380: END IF;
381: RETURN 0;

Line 394: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_down_payment';

390: FUNCTION validate_down_payment(p_operator_code IN varchar2
391: ,p_value1 IN varchar2
392: ,p_down_payment IN number) RETURN number IS
393: l_numval1 number;
394: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_down_payment';
395: l_debug_enabled varchar2(10);
396: is_debug_procedure_on boolean;
397: is_debug_statement_on boolean;
398:

Line 402: ,fnd_log.level_procedure);

398:
399: BEGIN
400: l_debug_enabled := okl_debug_pub.check_log_enabled;
401: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
402: ,fnd_log.level_procedure);
403:
404: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
405: okl_debug_pub.log_debug(fnd_log.level_procedure
406: ,l_module

Line 405: okl_debug_pub.log_debug(fnd_log.level_procedure

401: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
402: ,fnd_log.level_procedure);
403:
404: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
405: okl_debug_pub.log_debug(fnd_log.level_procedure
406: ,l_module
407: ,'begin debug OKLRECUB.pls.pls call validate_down_payment');
408: END IF;
409: l_numval1 := to_number(p_value1);

Line 414: okl_debug_pub.log_debug(fnd_log.level_procedure

410:
411: IF p_operator_code = 'EQ' THEN
412: IF p_down_payment = l_numval1 THEN
413: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
414: okl_debug_pub.log_debug(fnd_log.level_procedure
415: ,l_module
416: ,'end debug OKLRECUB.pls.pls call validate_down_payment');
417: END IF;
418: RETURN 1;

Line 421: okl_debug_pub.log_debug(fnd_log.level_procedure

417: END IF;
418: RETURN 1;
419: ELSE
420: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
421: okl_debug_pub.log_debug(fnd_log.level_procedure
422: ,l_module
423: ,'end debug OKLRECUB.pls.pls call validate_down_payment');
424: END IF;
425: RETURN 0;

Line 430: okl_debug_pub.log_debug(fnd_log.level_procedure

426: END IF;
427: ELSIF p_operator_code = 'NE' THEN
428: IF p_down_payment <> l_numval1 THEN
429: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
430: okl_debug_pub.log_debug(fnd_log.level_procedure
431: ,l_module
432: ,'end debug OKLRECUB.pls.pls call validate_down_payment');
433: END IF;
434: RETURN 1;

Line 437: okl_debug_pub.log_debug(fnd_log.level_procedure

433: END IF;
434: RETURN 1;
435: ELSE
436: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
437: okl_debug_pub.log_debug(fnd_log.level_procedure
438: ,l_module
439: ,'end debug OKLRECUB.pls.pls call validate_down_payment');
440: END IF;
441: RETURN 0;

Line 446: okl_debug_pub.log_debug(fnd_log.level_procedure

442: END IF;
443: ELSIF p_operator_code = 'LT' THEN
444: IF p_down_payment < l_numval1 THEN
445: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
446: okl_debug_pub.log_debug(fnd_log.level_procedure
447: ,l_module
448: ,'end debug OKLRECUB.pls.pls call validate_down_payment');
449: END IF;
450: RETURN 1;

Line 453: okl_debug_pub.log_debug(fnd_log.level_procedure

449: END IF;
450: RETURN 1;
451: ELSE
452: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
453: okl_debug_pub.log_debug(fnd_log.level_procedure
454: ,l_module
455: ,'end debug OKLRECUB.pls.pls call validate_down_payment');
456: END IF;
457: RETURN 0;

Line 462: okl_debug_pub.log_debug(fnd_log.level_procedure

458: END IF;
459: ELSIF p_operator_code = 'GT' THEN
460: IF p_down_payment > l_numval1 THEN
461: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
462: okl_debug_pub.log_debug(fnd_log.level_procedure
463: ,l_module
464: ,'end debug OKLRECUB.pls.pls call validate_down_payment');
465: END IF;
466: RETURN 1;

Line 469: okl_debug_pub.log_debug(fnd_log.level_procedure

465: END IF;
466: RETURN 1;
467: ELSE
468: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
469: okl_debug_pub.log_debug(fnd_log.level_procedure
470: ,l_module
471: ,'end debug OKLRECUB.pls.pls call validate_down_payment');
472: END IF;
473: RETURN 0;

Line 488: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_trade_in_value';

484: ,p_value2 IN varchar2
485: ,p_trade_in_value IN number) RETURN number IS
486: l_numval1 number;
487: l_numval2 number;
488: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_trade_in_value';
489: l_debug_enabled varchar2(10);
490: is_debug_procedure_on boolean;
491: is_debug_statement_on boolean;
492:

Line 496: ,fnd_log.level_procedure);

492:
493: BEGIN
494: l_debug_enabled := okl_debug_pub.check_log_enabled;
495: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
496: ,fnd_log.level_procedure);
497:
498: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
499: okl_debug_pub.log_debug(fnd_log.level_procedure
500: ,l_module

Line 499: okl_debug_pub.log_debug(fnd_log.level_procedure

495: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
496: ,fnd_log.level_procedure);
497:
498: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
499: okl_debug_pub.log_debug(fnd_log.level_procedure
500: ,l_module
501: ,'begin debug OKLRECUB.pls.pls call validate_trade_in_value');
502: END IF;
503: l_numval1 := fnd_number.canonical_to_number(p_value1);

Line 508: okl_debug_pub.log_debug(fnd_log.level_procedure

504: l_numval2 := fnd_number.canonical_to_number(p_value2);
505:
506: IF (p_trade_in_value >= l_numval1 AND p_trade_in_value <= l_numval2) THEN
507: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
508: okl_debug_pub.log_debug(fnd_log.level_procedure
509: ,l_module
510: ,'end debug OKLRECUB.pls.pls call validate_trade_in_value');
511: END IF;
512: RETURN 1;

Line 515: okl_debug_pub.log_debug(fnd_log.level_procedure

511: END IF;
512: RETURN 1;
513: ELSE
514: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
515: okl_debug_pub.log_debug(fnd_log.level_procedure
516: ,l_module
517: ,'end debug OKLRECUB.pls.pls call validate_trade_in_value');
518: END IF;
519: RETURN 0;

Line 528: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_term';

524: FUNCTION validate_term(p_value_tbl IN okl_number_table_type
525: ,p_match_criteria IN varchar2
526: ,p_term IN number) RETURN number IS
527: l_result varchar2(1);
528: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_term';
529: l_debug_enabled varchar2(10);
530: is_debug_procedure_on boolean;
531: is_debug_statement_on boolean;
532:

Line 536: ,fnd_log.level_procedure);

532:
533: BEGIN
534: l_debug_enabled := okl_debug_pub.check_log_enabled;
535: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
536: ,fnd_log.level_procedure);
537:
538: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
539: okl_debug_pub.log_debug(fnd_log.level_procedure
540: ,l_module

Line 539: okl_debug_pub.log_debug(fnd_log.level_procedure

535: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
536: ,fnd_log.level_procedure);
537:
538: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
539: okl_debug_pub.log_debug(fnd_log.level_procedure
540: ,l_module
541: ,'begin debug OKLRECUB.pls.pls call validate_term');
542: END IF;
543: l_result := 'S';

Line 579: okl_debug_pub.log_debug(fnd_log.level_procedure

575: END IF;
576:
577: IF l_result = 'S' THEN
578: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
579: okl_debug_pub.log_debug(fnd_log.level_procedure
580: ,l_module
581: ,'end debug OKLRECUB.pls.pls call validate_term');
582: END IF;
583: RETURN 1;

Line 586: okl_debug_pub.log_debug(fnd_log.level_procedure

582: END IF;
583: RETURN 1;
584: ELSE
585: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
586: okl_debug_pub.log_debug(fnd_log.level_procedure
587: ,l_module
588: ,'end debug OKLRECUB.pls.pls call validate_term');
589: END IF;
590: RETURN 0;

Line 602: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_territory';

598: FUNCTION validate_territory(p_value_tbl IN okl_varchar2_table_type
599: ,p_match_criteria IN varchar2
600: ,p_territory IN varchar2) RETURN number IS
601: l_result varchar2(1);
602: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_territory';
603: l_debug_enabled varchar2(10);
604: is_debug_procedure_on boolean;
605: is_debug_statement_on boolean;
606:

Line 610: ,fnd_log.level_procedure);

606:
607: BEGIN
608: l_debug_enabled := okl_debug_pub.check_log_enabled;
609: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
610: ,fnd_log.level_procedure);
611:
612: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
613: okl_debug_pub.log_debug(fnd_log.level_procedure
614: ,l_module

Line 613: okl_debug_pub.log_debug(fnd_log.level_procedure

609: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
610: ,fnd_log.level_procedure);
611:
612: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
613: okl_debug_pub.log_debug(fnd_log.level_procedure
614: ,l_module
615: ,'begin debug OKLRECUB.pls.pls call validate_territory');
616: END IF;
617: l_result := 'S';

Line 649: okl_debug_pub.log_debug(fnd_log.level_procedure

645: END IF;
646:
647: IF l_result = 'S' THEN
648: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
649: okl_debug_pub.log_debug(fnd_log.level_procedure
650: ,l_module
651: ,'end debug OKLRECUB.pls.pls call validate_territory');
652: END IF;
653: RETURN 1;

Line 656: okl_debug_pub.log_debug(fnd_log.level_procedure

652: END IF;
653: RETURN 1;
654: ELSE
655: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
656: okl_debug_pub.log_debug(fnd_log.level_procedure
657: ,l_module
658: ,'end debug OKLRECUB.pls.pls call validate_territory');
659: END IF;
660: RETURN 0;

Line 672: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_customer_credit_class';

668: FUNCTION validate_customer_credit_class(p_value_tbl IN okl_varchar2_table_type
669: ,p_match_criteria IN varchar2
670: ,p_cust_credit_class IN varchar2) RETURN number IS
671: l_result varchar2(1);
672: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_customer_credit_class';
673: l_debug_enabled varchar2(10);
674: is_debug_procedure_on boolean;
675: is_debug_statement_on boolean;
676:

Line 680: ,fnd_log.level_procedure);

676:
677: BEGIN
678: l_debug_enabled := okl_debug_pub.check_log_enabled;
679: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
680: ,fnd_log.level_procedure);
681:
682: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
683: okl_debug_pub.log_debug(fnd_log.level_procedure
684: ,l_module

Line 683: okl_debug_pub.log_debug(fnd_log.level_procedure

679: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
680: ,fnd_log.level_procedure);
681:
682: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
683: okl_debug_pub.log_debug(fnd_log.level_procedure
684: ,l_module
685: ,'begin debug OKLRECUB.pls.pls call validate_customer_credit_class');
686: END IF;
687: l_result := 'S';

Line 719: okl_debug_pub.log_debug(fnd_log.level_procedure

715: END IF;
716:
717: IF l_result = 'S' THEN
718: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
719: okl_debug_pub.log_debug(fnd_log.level_procedure
720: ,l_module
721: ,'end debug OKLRECUB.pls.pls call validate_customer_credit_class');
722: END IF;
723: RETURN 1;

Line 726: okl_debug_pub.log_debug(fnd_log.level_procedure

722: END IF;
723: RETURN 1;
724: ELSE
725: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
726: okl_debug_pub.log_debug(fnd_log.level_procedure
727: ,l_module
728: ,'end debug OKLRECUB.pls.pls call validate_customer_credit_class');
729: END IF;
730: RETURN 0;

Line 742: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_item';

738: FUNCTION validate_item(p_value_tbl okl_number_table_type
739: ,p_match_criteria IN varchar2
740: ,p_item_tbl okl_number_table_type) RETURN number IS
741: l_result varchar2(1);
742: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_item';
743: l_debug_enabled varchar2(10);
744: is_debug_procedure_on boolean;
745: is_debug_statement_on boolean;
746:

Line 750: ,fnd_log.level_procedure);

746:
747: BEGIN
748: l_debug_enabled := okl_debug_pub.check_log_enabled;
749: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
750: ,fnd_log.level_procedure);
751:
752: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
753: okl_debug_pub.log_debug(fnd_log.level_procedure
754: ,l_module

Line 753: okl_debug_pub.log_debug(fnd_log.level_procedure

749: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
750: ,fnd_log.level_procedure);
751:
752: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
753: okl_debug_pub.log_debug(fnd_log.level_procedure
754: ,l_module
755: ,'begin debug OKLRECUB.pls.pls call validate_item');
756: END IF;
757: l_result := 'S';

Line 793: okl_debug_pub.log_debug(fnd_log.level_procedure

789: END IF;
790:
791: IF l_result = 'S' THEN
792: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
793: okl_debug_pub.log_debug(fnd_log.level_procedure
794: ,l_module
795: ,'end debug OKLRECUB.pls.pls call validate_item');
796: END IF;
797: RETURN 1;

Line 800: okl_debug_pub.log_debug(fnd_log.level_procedure

796: END IF;
797: RETURN 1;
798: ELSE
799: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
800: okl_debug_pub.log_debug(fnd_log.level_procedure
801: ,l_module
802: ,'end debug OKLRECUB.pls.pls call validate_item');
803: END IF;
804: RETURN 0;

Line 816: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_item_categories';

812: FUNCTION validate_item_categories(p_value_tbl okl_number_table_type
813: ,p_match_criteria IN varchar2
814: ,p_item_categories_tbl okl_number_table_type) RETURN number IS
815: l_result varchar2(1);
816: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_item_categories';
817: l_debug_enabled varchar2(10);
818: is_debug_procedure_on boolean;
819: is_debug_statement_on boolean;
820:

Line 824: ,fnd_log.level_procedure);

820:
821: BEGIN
822: l_debug_enabled := okl_debug_pub.check_log_enabled;
823: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
824: ,fnd_log.level_procedure);
825:
826: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
827: okl_debug_pub.log_debug(fnd_log.level_procedure
828: ,l_module

Line 827: okl_debug_pub.log_debug(fnd_log.level_procedure

823: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
824: ,fnd_log.level_procedure);
825:
826: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
827: okl_debug_pub.log_debug(fnd_log.level_procedure
828: ,l_module
829: ,'begin debug OKLRECUB.pls.pls call validate_item_categories');
830: END IF;
831: l_result := 'S';

Line 867: okl_debug_pub.log_debug(fnd_log.level_procedure

863: END IF;
864:
865: IF l_result = 'S' THEN
866: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
867: okl_debug_pub.log_debug(fnd_log.level_procedure
868: ,l_module
869: ,'end debug OKLRECUB.pls.pls call validate_item_categories');
870: END IF;
871: RETURN 1;

Line 874: okl_debug_pub.log_debug(fnd_log.level_procedure

870: END IF;
871: RETURN 1;
872: ELSE
873: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
874: okl_debug_pub.log_debug(fnd_log.level_procedure
875: ,l_module
876: ,'end debug OKLRECUB.pls.pls call validate_item_categories');
877: END IF;
878: RETURN 0;

Line 891: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_deal_size';

887: ,p_value2 IN varchar2
888: ,p_deal_size IN number) RETURN number IS
889: l_numval1 number;
890: l_numval2 number;
891: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate_deal_size';
892: l_debug_enabled varchar2(10);
893: is_debug_procedure_on boolean;
894: is_debug_statement_on boolean;
895:

Line 899: ,fnd_log.level_procedure);

895:
896: BEGIN
897: l_debug_enabled := okl_debug_pub.check_log_enabled;
898: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
899: ,fnd_log.level_procedure);
900:
901: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
902: okl_debug_pub.log_debug(fnd_log.level_procedure
903: ,l_module

Line 902: okl_debug_pub.log_debug(fnd_log.level_procedure

898: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
899: ,fnd_log.level_procedure);
900:
901: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
902: okl_debug_pub.log_debug(fnd_log.level_procedure
903: ,l_module
904: ,'begin debug OKLRECUB.pls.pls call validate_deal_size');
905: END IF;
906: l_numval1 := fnd_number.canonical_to_number(p_value1);

Line 911: okl_debug_pub.log_debug(fnd_log.level_procedure

907: l_numval2 := fnd_number.canonical_to_number(p_value2);
908:
909: IF (p_deal_size >= l_numval1 AND p_deal_size <= l_numval2) THEN
910: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
911: okl_debug_pub.log_debug(fnd_log.level_procedure
912: ,l_module
913: ,'end debug OKLRECUB.pls.pls call validate_deal_size');
914: END IF;
915: RETURN 1;

Line 918: okl_debug_pub.log_debug(fnd_log.level_procedure

914: END IF;
915: RETURN 1;
916: ELSE
917: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
918: okl_debug_pub.log_debug(fnd_log.level_procedure
919: ,l_module
920: ,'end debug OKLRECUB.pls.pls call validate_deal_size');
921: END IF;
922: RETURN 0;

Line 937: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.evaluate_term';

933: **/
934:
935: FUNCTION evaluate_term(p_value_tbl IN okl_number_table_type
936: ,p_term IN number) RETURN number IS
937: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.evaluate_term';
938: l_debug_enabled varchar2(10);
939: is_debug_procedure_on boolean;
940: is_debug_statement_on boolean;
941:

Line 945: ,fnd_log.level_procedure);

941:
942: BEGIN
943: l_debug_enabled := okl_debug_pub.check_log_enabled;
944: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
945: ,fnd_log.level_procedure);
946:
947: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
948: okl_debug_pub.log_debug(fnd_log.level_procedure
949: ,l_module

Line 948: okl_debug_pub.log_debug(fnd_log.level_procedure

944: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
945: ,fnd_log.level_procedure);
946:
947: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
948: okl_debug_pub.log_debug(fnd_log.level_procedure
949: ,l_module
950: ,'begin debug OKLRECUB.pls.pls call evaluate_term');
951: END IF;
952:

Line 959: okl_debug_pub.log_debug(fnd_log.level_procedure

955: -- dbms_output.put_line('p_term_tbl(i)= '||p_term_tbl(i)|| 'p_value_tbl(j) = '||p_value_tbl(j));
956:
957: IF p_term = p_value_tbl(j) THEN
958: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
959: okl_debug_pub.log_debug(fnd_log.level_procedure
960: ,l_module
961: ,'end debug OKLRECUB.pls.pls call evaluate_term');
962: END IF;
963: RETURN j;

Line 969: okl_debug_pub.log_debug(fnd_log.level_procedure

965:
966: END LOOP;
967:
968: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
969: okl_debug_pub.log_debug(fnd_log.level_procedure
970: ,l_module
971: ,'end debug OKLRECUB.pls.pls call evaluate_term');
972: END IF;
973: RETURN 0;

Line 986: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.evaluate_territory';

982: **/
983:
984: FUNCTION evaluate_territory(p_value_tbl IN okl_varchar2_table_type
985: ,p_territory IN varchar2) RETURN number IS
986: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.evaluate_territory';
987: l_debug_enabled varchar2(10);
988: is_debug_procedure_on boolean;
989: is_debug_statement_on boolean;
990:

Line 994: ,fnd_log.level_procedure);

990:
991: BEGIN
992: l_debug_enabled := okl_debug_pub.check_log_enabled;
993: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
994: ,fnd_log.level_procedure);
995:
996: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
997: okl_debug_pub.log_debug(fnd_log.level_procedure
998: ,l_module

Line 997: okl_debug_pub.log_debug(fnd_log.level_procedure

993: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
994: ,fnd_log.level_procedure);
995:
996: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
997: okl_debug_pub.log_debug(fnd_log.level_procedure
998: ,l_module
999: ,'begin debug OKLRECUB.pls.pls call evaluate_territory');
1000: END IF;
1001:

Line 1008: okl_debug_pub.log_debug(fnd_log.level_procedure

1004: -- dbms_output.put_line('p_term_tbl(i)= '||p_term_tbl(i)|| 'p_value_tbl(j) = '||p_value_tbl(j));
1005:
1006: IF p_territory = p_value_tbl(j) THEN
1007: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1008: okl_debug_pub.log_debug(fnd_log.level_procedure
1009: ,l_module
1010: ,'end debug OKLRECUB.pls.pls call evaluate_territory');
1011: END IF;
1012: RETURN j;

Line 1018: okl_debug_pub.log_debug(fnd_log.level_procedure

1014:
1015: END LOOP;
1016:
1017: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1018: okl_debug_pub.log_debug(fnd_log.level_procedure
1019: ,l_module
1020: ,'end debug OKLRECUB.pls.pls call evaluate_territory');
1021: END IF;
1022: RETURN 0;

Line 1035: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.evaluate_customer_credit_class';

1031: **/
1032:
1033: FUNCTION evaluate_customer_credit_class(p_value_tbl IN okl_varchar2_table_type
1034: ,p_customer_credit_class IN varchar2) RETURN number IS
1035: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.evaluate_customer_credit_class';
1036: l_debug_enabled varchar2(10);
1037: is_debug_procedure_on boolean;
1038: is_debug_statement_on boolean;
1039:

Line 1043: ,fnd_log.level_procedure);

1039:
1040: BEGIN
1041: l_debug_enabled := okl_debug_pub.check_log_enabled;
1042: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1043: ,fnd_log.level_procedure);
1044:
1045: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1046: okl_debug_pub.log_debug(fnd_log.level_procedure
1047: ,l_module

Line 1046: okl_debug_pub.log_debug(fnd_log.level_procedure

1042: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1043: ,fnd_log.level_procedure);
1044:
1045: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1046: okl_debug_pub.log_debug(fnd_log.level_procedure
1047: ,l_module
1048: ,'begin debug OKLRECUB.pls.pls call evaluate_customer_credit_class');
1049: END IF;
1050:

Line 1054: ,fnd_log.level_statement);

1050:
1051: -- check for logging on STATEMENT level
1052:
1053: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1054: ,fnd_log.level_statement);
1055:
1056: FOR j IN p_value_tbl.FIRST..p_value_tbl.LAST LOOP
1057:
1058: -- dbms_output.put_line('p_term_tbl(i)= '||p_term_tbl(i)|| 'p_value_tbl(j) = '||p_value_tbl(j));

Line 1062: okl_debug_pub.log_debug(fnd_log.level_procedure

1058: -- dbms_output.put_line('p_term_tbl(i)= '||p_term_tbl(i)|| 'p_value_tbl(j) = '||p_value_tbl(j));
1059:
1060: IF p_customer_credit_class = p_value_tbl(j) THEN
1061: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1062: okl_debug_pub.log_debug(fnd_log.level_procedure
1063: ,l_module
1064: ,'end debug OKLRECUB.pls.pls call evaluate_customer_credit_class');
1065: END IF;
1066: RETURN j;

Line 1072: okl_debug_pub.log_debug(fnd_log.level_procedure

1068:
1069: END LOOP;
1070:
1071: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1072: okl_debug_pub.log_debug(fnd_log.level_procedure
1073: ,l_module
1074: ,'end debug OKLRECUB.pls.pls call evaluate_customer_credit_class');
1075: END IF;
1076: RETURN 0;

Line 1090: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.evaluate_deal_size';

1086: ,p_value2 IN varchar2
1087: ,p_deal_size IN number) RETURN number IS
1088: l_numval1 number;
1089: l_numval2 number;
1090: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.evaluate_deal_size';
1091: l_debug_enabled varchar2(10);
1092: is_debug_procedure_on boolean;
1093: is_debug_statement_on boolean;
1094:

Line 1098: ,fnd_log.level_procedure);

1094:
1095: BEGIN
1096: l_debug_enabled := okl_debug_pub.check_log_enabled;
1097: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1098: ,fnd_log.level_procedure);
1099:
1100: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1101: okl_debug_pub.log_debug(fnd_log.level_procedure
1102: ,l_module

Line 1101: okl_debug_pub.log_debug(fnd_log.level_procedure

1097: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1098: ,fnd_log.level_procedure);
1099:
1100: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1101: okl_debug_pub.log_debug(fnd_log.level_procedure
1102: ,l_module
1103: ,'begin debug OKLRECUB.pls.pls call evaluate_deal_size');
1104: END IF;
1105:

Line 1109: ,fnd_log.level_statement);

1105:
1106: -- check for logging on STATEMENT level
1107:
1108: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1109: ,fnd_log.level_statement);
1110: l_numval1 := fnd_number.canonical_to_number(p_value1);
1111: l_numval2 := fnd_number.canonical_to_number(p_value2);
1112:
1113: IF (p_deal_size >= l_numval1 AND p_deal_size <= l_numval2) THEN

Line 1115: okl_debug_pub.log_debug(fnd_log.level_procedure

1111: l_numval2 := fnd_number.canonical_to_number(p_value2);
1112:
1113: IF (p_deal_size >= l_numval1 AND p_deal_size <= l_numval2) THEN
1114: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1115: okl_debug_pub.log_debug(fnd_log.level_procedure
1116: ,l_module
1117: ,'end debug OKLRECUB.pls.pls call evaluate_deal_size');
1118: END IF;
1119: RETURN 1;

Line 1122: okl_debug_pub.log_debug(fnd_log.level_procedure

1118: END IF;
1119: RETURN 1;
1120: ELSE
1121: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1122: okl_debug_pub.log_debug(fnd_log.level_procedure
1123: ,l_module
1124: ,'end debug OKLRECUB.pls.pls call evaluate_deal_size');
1125: END IF;
1126: RETURN 0;

Line 1199: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate';

1195: l_msg_count number;
1196: l_msg_data varchar2(2000);
1197: l_init_msg_list varchar2(1) DEFAULT OKL_API.G_FALSE;
1198: l_function_name okl_data_src_fnctns_v.name%TYPE;
1199: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate';
1200: l_debug_enabled varchar2(10);
1201: is_debug_procedure_on boolean;
1202: is_debug_statement_on boolean;
1203:

Line 1207: ,fnd_log.level_procedure);

1203:
1204: BEGIN
1205: l_debug_enabled := okl_debug_pub.check_log_enabled;
1206: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1207: ,fnd_log.level_procedure);
1208:
1209: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1210: okl_debug_pub.log_debug(fnd_log.level_procedure
1211: ,l_module

Line 1210: okl_debug_pub.log_debug(fnd_log.level_procedure

1206: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1207: ,fnd_log.level_procedure);
1208:
1209: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1210: okl_debug_pub.log_debug(fnd_log.level_procedure
1211: ,l_module
1212: ,'begin debug OKLRECUB.pls.pls call validate');
1213: END IF;
1214: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 1215: ,fnd_log.level_statement);

1211: ,l_module
1212: ,'begin debug OKLRECUB.pls.pls call validate');
1213: END IF;
1214: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1215: ,fnd_log.level_statement);
1216: --dbms_output.put_line('start of new ');
1217:
1218: --log the incoming values
1219: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN

Line 1220: okl_debug_pub.log_debug(fnd_log.level_statement

1216: --dbms_output.put_line('start of new ');
1217:
1218: --log the incoming values
1219: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1220: okl_debug_pub.log_debug(fnd_log.level_statement
1221: ,l_module
1222: ,' p_okl_ec_rec.SRC_ID = ' || p_okl_ec_rec.SRC_ID ||
1223: ' p_okl_ec_rec.SOURCE_NAME = ' || p_okl_ec_rec.SOURCE_NAME ||
1224: ' p_okl_ec_rec.TARGET_ID = ' || p_okl_ec_rec.TARGET_ID ||

Line 1298: okl_debug_pub.log_debug(fnd_log.level_procedure

1294: ,p_okl_ec_rec.advance_rent);
1295: IF p_okl_ec_rec.validation_mode = 'LOV' THEN
1296: IF (ec_tbl(i).mc_hdr = 'ONE' AND fun_ret = 1) THEN
1297: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1298: okl_debug_pub.log_debug(fnd_log.level_procedure
1299: ,l_module
1300: ,'end debug OKLRECUB.pls.pls call validate');
1301: END IF;
1302: x_eligible := true;

Line 1308: okl_debug_pub.log_debug(fnd_log.level_procedure

1304: RETURN;
1305: END IF;
1306: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1307: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1308: okl_debug_pub.log_debug(fnd_log.level_procedure
1309: ,l_module
1310: ,'end debug OKLRECUB.pls.pls call validate');
1311: END IF;
1312: x_eligible := false;

Line 1366: okl_debug_pub.log_debug(fnd_log.level_procedure

1362: ,p_okl_ec_rec.customer_credit_class);
1363: IF p_okl_ec_rec.validation_mode = 'LOV' THEN
1364: IF (ec_tbl(i).mc_hdr = 'ONE' AND fun_ret = 1) THEN
1365: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1366: okl_debug_pub.log_debug(fnd_log.level_procedure
1367: ,l_module
1368: ,'end debug OKLRECUB.pls.pls call validate');
1369: END IF;
1370: x_eligible := true;

Line 1376: okl_debug_pub.log_debug(fnd_log.level_procedure

1372: RETURN;
1373: END IF;
1374: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1375: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1376: okl_debug_pub.log_debug(fnd_log.level_procedure
1377: ,l_module
1378: ,'end debug OKLRECUB.pls.pls call validate');
1379: END IF;
1380: x_eligible := false;

Line 1430: okl_debug_pub.log_debug(fnd_log.level_procedure

1426: ,p_okl_ec_rec.deal_size); --dbms_output.put_line('fun_ret deal size = '||fun_ret);
1427: IF p_okl_ec_rec.validation_mode = 'LOV' THEN
1428: IF (ec_tbl(i).mc_hdr = 'ONE' AND fun_ret = 1) THEN
1429: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1430: okl_debug_pub.log_debug(fnd_log.level_procedure
1431: ,l_module
1432: ,'end debug OKLRECUB.pls.pls call validate');
1433: END IF;
1434: x_eligible := true;

Line 1440: okl_debug_pub.log_debug(fnd_log.level_procedure

1436: RETURN;
1437: END IF;
1438: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1439: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1440: okl_debug_pub.log_debug(fnd_log.level_procedure
1441: ,l_module
1442: ,'end debug OKLRECUB.pls.pls call validate');
1443: END IF;
1444: x_eligible := false;

Line 1504: okl_debug_pub.log_debug(fnd_log.level_procedure

1500:
1501: IF p_okl_ec_rec.validation_mode = 'LOV' THEN
1502: IF (ec_tbl(i).mc_hdr = 'ONE' AND fun_ret = 1) THEN
1503: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1504: okl_debug_pub.log_debug(fnd_log.level_procedure
1505: ,l_module
1506: ,'end debug OKLRECUB.pls.pls call validate');
1507: END IF;
1508: x_eligible := true;

Line 1514: okl_debug_pub.log_debug(fnd_log.level_procedure

1510: RETURN;
1511: END IF;
1512: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1513: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1514: okl_debug_pub.log_debug(fnd_log.level_procedure
1515: ,l_module
1516: ,'end debug OKLRECUB.pls.pls call validate');
1517: END IF;
1518: x_eligible := false;

Line 1572: okl_debug_pub.log_debug(fnd_log.level_procedure

1568: ,p_okl_ec_rec.item_table);
1569: IF p_okl_ec_rec.validation_mode = 'LOV' THEN
1570: IF (ec_tbl(i).mc_hdr = 'ONE' AND fun_ret = 1) THEN
1571: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1572: okl_debug_pub.log_debug(fnd_log.level_procedure
1573: ,l_module
1574: ,'end debug OKLRECUB.pls.pls call validate');
1575: END IF;
1576: x_eligible := true;

Line 1582: okl_debug_pub.log_debug(fnd_log.level_procedure

1578: RETURN;
1579: END IF;
1580: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1581: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1582: okl_debug_pub.log_debug(fnd_log.level_procedure
1583: ,l_module
1584: ,'end debug OKLRECUB.pls.pls call validate');
1585: END IF;
1586: x_eligible := false;

Line 1636: okl_debug_pub.log_debug(fnd_log.level_procedure

1632: ,p_okl_ec_rec.item_categories_table);
1633: IF p_okl_ec_rec.validation_mode = 'LOV' THEN
1634: IF (ec_tbl(i).mc_hdr = 'ONE' AND fun_ret = 1) THEN
1635: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1636: okl_debug_pub.log_debug(fnd_log.level_procedure
1637: ,l_module
1638: ,'end debug OKLRECUB.pls.pls call validate');
1639: END IF;
1640: x_eligible := true;

Line 1646: okl_debug_pub.log_debug(fnd_log.level_procedure

1642: RETURN;
1643: END IF;
1644: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1645: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1646: okl_debug_pub.log_debug(fnd_log.level_procedure
1647: ,l_module
1648: ,'end debug OKLRECUB.pls.pls call validate');
1649: END IF;
1650: x_eligible := false;

Line 1707: okl_debug_pub.log_debug(fnd_log.level_procedure

1703: --dbms_output.put_line('ec_tbl(i).mc_hdr = '||ec_tbl(i).mc_hdr || 'fun_ret = '|| fun_ret);
1704:
1705: IF (ec_tbl(i).mc_hdr = 'ONE' AND fun_ret = 1) THEN
1706: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1707: okl_debug_pub.log_debug(fnd_log.level_procedure
1708: ,l_module
1709: ,'end debug OKLRECUB.pls.pls call validate');
1710: END IF;
1711: x_eligible := true;

Line 1717: okl_debug_pub.log_debug(fnd_log.level_procedure

1713: RETURN;
1714: END IF;
1715: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1716: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1717: okl_debug_pub.log_debug(fnd_log.level_procedure
1718: ,l_module
1719: ,'end debug OKLRECUB.pls.pls call validate');
1720: END IF;
1721: x_eligible := false;

Line 1771: okl_debug_pub.log_debug(fnd_log.level_procedure

1767: ,p_okl_ec_rec.territory);
1768: IF p_okl_ec_rec.validation_mode = 'LOV' THEN
1769: IF (ec_tbl(i).mc_hdr = 'ONE' AND fun_ret = 1) THEN
1770: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1771: okl_debug_pub.log_debug(fnd_log.level_procedure
1772: ,l_module
1773: ,'end debug OKLRECUB.pls.pls call validate');
1774: END IF;
1775: x_eligible := true;

Line 1781: okl_debug_pub.log_debug(fnd_log.level_procedure

1777: RETURN;
1778: END IF;
1779: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1780: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1781: okl_debug_pub.log_debug(fnd_log.level_procedure
1782: ,l_module
1783: ,'end debug OKLRECUB.pls.pls call validate');
1784: END IF;
1785: x_eligible := false;

Line 1836: okl_debug_pub.log_debug(fnd_log.level_procedure

1832: ,p_okl_ec_rec.trade_in_value);
1833: IF p_okl_ec_rec.validation_mode = 'LOV' THEN
1834: IF (ec_tbl(i).mc_hdr = 'ONE' AND fun_ret = 1) THEN
1835: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1836: okl_debug_pub.log_debug(fnd_log.level_procedure
1837: ,l_module
1838: ,'end debug OKLRECUB.pls.pls call validate');
1839: END IF;
1840: x_eligible := true;

Line 1846: okl_debug_pub.log_debug(fnd_log.level_procedure

1842: RETURN;
1843: END IF;
1844: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1845: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1846: okl_debug_pub.log_debug(fnd_log.level_procedure
1847: ,l_module
1848: ,'end debug OKLRECUB.pls.pls call validate');
1849: END IF;
1850: x_eligible := false;

Line 1922: okl_debug_pub.log_debug(fnd_log.level_statement

1918: p_function_name => l_function_name,
1919: x_value => fun_ret
1920: );
1921: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1922: okl_debug_pub.log_debug(fnd_log.level_statement
1923: ,l_module
1924: ,'okl_execute_formula_pvt.execute_eligibility_criteria returned with status ' ||
1925: x_return_status ||
1926: ' x_msg_data ' ||

Line 1939: okl_debug_pub.log_debug(fnd_log.level_procedure

1935:
1936: IF p_okl_ec_rec.validation_mode = 'LOV' THEN
1937: IF (ec_tbl(i).mc_hdr = 'ONE' AND fun_ret = 1) THEN
1938: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1939: okl_debug_pub.log_debug(fnd_log.level_procedure
1940: ,l_module
1941: ,'end debug OKLRECUB.pls.pls call validate');
1942: END IF;
1943: x_eligible := true;

Line 1949: okl_debug_pub.log_debug(fnd_log.level_procedure

1945: RETURN;
1946: END IF;
1947: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1948: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1949: okl_debug_pub.log_debug(fnd_log.level_procedure
1950: ,l_module
1951: ,'end debug OKLRECUB.pls.pls call validate');
1952: END IF;
1953: x_eligible := false;

Line 1990: okl_debug_pub.log_debug(fnd_log.level_procedure

1986: END IF; -- of If ec_tbl.count > 0
1987:
1988: IF fun_ret = 1 THEN
1989: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1990: okl_debug_pub.log_debug(fnd_log.level_procedure
1991: ,l_module
1992: ,'end debug OKLRECUB.pls.pls call validate');
1993: END IF;
1994: x_return_status := okl_api.g_ret_sts_success;

Line 1998: okl_debug_pub.log_debug(fnd_log.level_procedure

1994: x_return_status := okl_api.g_ret_sts_success;
1995: x_eligible := true;
1996: ELSE
1997: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1998: okl_debug_pub.log_debug(fnd_log.level_procedure
1999: ,l_module
2000: ,'end debug OKLRECUB.pls.pls call validate');
2001: END IF;
2002: x_return_status := okl_api.g_ret_sts_success;

Line 2116: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_adjustment_factor';

2112: l_msg_count number;
2113: l_msg_data varchar2(2000);
2114: l_init_msg_list varchar2(1) DEFAULT OKL_API.G_FALSE;
2115: l_function_name okl_data_src_fnctns_v.name%TYPE;
2116: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_adjustment_factor';
2117: l_debug_enabled varchar2(10);
2118: is_debug_procedure_on boolean;
2119: is_debug_statement_on boolean;
2120:

Line 2124: ,fnd_log.level_procedure);

2120:
2121: BEGIN
2122: l_debug_enabled := okl_debug_pub.check_log_enabled;
2123: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2124: ,fnd_log.level_procedure);
2125:
2126: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2127: okl_debug_pub.log_debug(fnd_log.level_procedure
2128: ,l_module

Line 2127: okl_debug_pub.log_debug(fnd_log.level_procedure

2123: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2124: ,fnd_log.level_procedure);
2125:
2126: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2127: okl_debug_pub.log_debug(fnd_log.level_procedure
2128: ,l_module
2129: ,'begin debug OKLRECUB.pls.pls call get_adjustment_factor');
2130: END IF;
2131:

Line 2135: okl_debug_pub.log_debug(fnd_log.level_statement

2131:
2132: --dbms_output.put_line('start of new ');
2133: --log the incoming values
2134: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
2135: okl_debug_pub.log_debug(fnd_log.level_statement
2136: ,l_module
2137: ,' p_okl_ac_rec.SRC_ID = ' || p_okl_ac_rec.SRC_ID ||
2138: ' p_okl_ac_rec.SOURCE_NAME = ' || p_okl_ac_rec.SOURCE_NAME ||
2139: ' p_okl_ac_rec.TARGET_ID = ' || p_okl_ac_rec.TARGET_ID ||

Line 2306: okl_debug_pub.log_debug(fnd_log.level_statement

2302: p_function_name => l_function_name,
2303: x_value => fun_ret
2304: );
2305: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
2306: okl_debug_pub.log_debug(fnd_log.level_statement
2307: ,l_module
2308: ,'okl_execute_formula_pvt.execute_eligibility_criteria returned with status ' ||
2309: l_return_status ||
2310: ' x_msg_data ' ||

Line 2330: okl_debug_pub.log_debug(fnd_log.level_procedure

2326:
2327: END IF; -- of If ac_tbl.count > 0
2328:
2329: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2330: okl_debug_pub.log_debug(fnd_log.level_procedure
2331: ,l_module
2332: ,'end debug OKLRECUB.pls.pls call get_adjustment_factor');
2333: END IF;
2334: x_adjustment_factor := l_adjustment_factor;

Line 2439: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.compare_eligibility_criteria';

2435: j number;
2436: k number;
2437: l number;
2438: m number;
2439: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.compare_eligibility_criteria';
2440: l_debug_enabled varchar2(10);
2441: is_debug_procedure_on boolean;
2442: is_debug_statement_on boolean;
2443:

Line 2447: ,fnd_log.level_procedure);

2443:
2444: BEGIN
2445: l_debug_enabled := okl_debug_pub.check_log_enabled;
2446: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2447: ,fnd_log.level_procedure);
2448:
2449: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2450: okl_debug_pub.log_debug(fnd_log.level_procedure
2451: ,l_module

Line 2450: okl_debug_pub.log_debug(fnd_log.level_procedure

2446: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2447: ,fnd_log.level_procedure);
2448:
2449: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2450: okl_debug_pub.log_debug(fnd_log.level_procedure
2451: ,l_module
2452: ,'begin debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2453: END IF;
2454:

Line 2458: ,fnd_log.level_statement);

2454:
2455: -- check for logging on STATEMENT level
2456:
2457: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2458: ,fnd_log.level_statement);
2459: i := 1;
2460:
2461: FOR ec_rec IN get_ec(p_source_id1, p_source_type1) LOOP
2462: ec1_tbl(i).match_criteria_code := ec_rec.match_criteria_code;

Line 2541: okl_debug_pub.log_debug(fnd_log.level_procedure

2537:
2538: IF NOT (l_ec1_numval1 BETWEEN l_ec2_numval1 AND l_ec2_numval2
2539: OR l_ec2_numval1 BETWEEN l_ec1_numval1 AND l_ec1_numval2) THEN
2540: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2541: okl_debug_pub.log_debug(fnd_log.level_procedure
2542: ,l_module
2543: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2544: END IF;
2545: RETURN false;

Line 2555: okl_debug_pub.log_debug(fnd_log.level_procedure

2551: l_ec2_dateval2 := fnd_date.canonical_to_date(l_ec2_value2);
2552: IF NOT (l_ec1_dateval1 BETWEEN l_ec2_dateval1 AND l_ec2_dateval2
2553: OR l_ec2_dateval1 BETWEEN l_ec1_dateval1 AND l_ec1_dateval2) THEN
2554: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2555: okl_debug_pub.log_debug(fnd_log.level_procedure
2556: ,l_module
2557: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2558: END IF;
2559: RETURN false;

Line 2587: okl_debug_pub.log_debug(fnd_log.level_procedure

2583: END LOOP;
2584: END LOOP;
2585: IF NOT l_match_found THEN
2586: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2587: okl_debug_pub.log_debug(fnd_log.level_procedure
2588: ,l_module
2589: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2590: END IF;
2591: RETURN false;

Line 2610: okl_debug_pub.log_debug(fnd_log.level_procedure

2606: END IF;
2607: END LOOP;
2608: IF l_match_found THEN
2609: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2610: okl_debug_pub.log_debug(fnd_log.level_procedure
2611: ,l_module
2612: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2613: END IF;
2614: RETURN false;

Line 2633: okl_debug_pub.log_debug(fnd_log.level_procedure

2629: END IF;
2630: END LOOP;
2631: IF l_match_found THEN
2632: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2633: okl_debug_pub.log_debug(fnd_log.level_procedure
2634: ,l_module
2635: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2636: END IF;
2637: RETURN false;

Line 2657: okl_debug_pub.log_debug(fnd_log.level_procedure

2653: l_ec2_numval1 := fnd_number.canonical_to_number(l_ec2_value1);
2654: IF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'EQ' THEN
2655: IF l_ec1_numval1 <> l_ec2_numval1 THEN
2656: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2657: okl_debug_pub.log_debug(fnd_log.level_procedure
2658: ,l_module
2659: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2660: END IF;
2661: RETURN false;

Line 2666: okl_debug_pub.log_debug(fnd_log.level_procedure

2662: END IF;
2663: ELSIF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'NE' THEN
2664: IF l_ec1_numval1 >= l_ec2_numval1 THEN
2665: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2666: okl_debug_pub.log_debug(fnd_log.level_procedure
2667: ,l_module
2668: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2669: END IF;
2670: RETURN false;

Line 2675: okl_debug_pub.log_debug(fnd_log.level_procedure

2671: END IF;
2672: ELSIF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'LT' THEN
2673: IF l_ec1_numval1 >= l_ec2_numval1 THEN
2674: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2675: okl_debug_pub.log_debug(fnd_log.level_procedure
2676: ,l_module
2677: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2678: END IF;
2679: RETURN false;

Line 2684: okl_debug_pub.log_debug(fnd_log.level_procedure

2680: END IF;
2681: ELSIF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'GT' THEN
2682: IF l_ec1_numval1 <= l_ec2_numval1 THEN
2683: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2684: okl_debug_pub.log_debug(fnd_log.level_procedure
2685: ,l_module
2686: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2687: END IF;
2688: RETURN false;

Line 2693: okl_debug_pub.log_debug(fnd_log.level_procedure

2689: END IF;
2690: ELSIF l_ec1_operator_code = 'NE' AND l_ec2_operator_code = 'EQ' THEN
2691: IF l_ec1_numval1 = l_ec2_numval1 THEN
2692: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2693: okl_debug_pub.log_debug(fnd_log.level_procedure
2694: ,l_module
2695: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2696: END IF;
2697: RETURN false;

Line 2702: okl_debug_pub.log_debug(fnd_log.level_procedure

2698: END IF;
2699: ELSIF l_ec1_operator_code = 'LT' AND l_ec2_operator_code = 'EQ' THEN
2700: IF l_ec1_numval1 <= l_ec2_numval1 THEN
2701: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2702: okl_debug_pub.log_debug(fnd_log.level_procedure
2703: ,l_module
2704: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2705: END IF;
2706: RETURN false;

Line 2711: okl_debug_pub.log_debug(fnd_log.level_procedure

2707: END IF;
2708: ELSIF l_ec1_operator_code = 'LT' AND l_ec2_operator_code = 'GT' THEN
2709: IF l_ec1_numval1 - l_ec2_numval1 <= 1 THEN
2710: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2711: okl_debug_pub.log_debug(fnd_log.level_procedure
2712: ,l_module
2713: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2714: END IF;
2715: RETURN false;

Line 2720: okl_debug_pub.log_debug(fnd_log.level_procedure

2716: END IF;
2717: ELSIF l_ec1_operator_code = 'GT' AND l_ec2_operator_code = 'EQ' THEN
2718: IF l_ec1_numval1 >= l_ec2_numval1 THEN
2719: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2720: okl_debug_pub.log_debug(fnd_log.level_procedure
2721: ,l_module
2722: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2723: END IF;
2724: RETURN false;

Line 2729: okl_debug_pub.log_debug(fnd_log.level_procedure

2725: END IF;
2726: ELSIF l_ec1_operator_code = 'GT' AND l_ec2_operator_code = 'LT' THEN
2727: IF l_ec2_numval1 - l_ec1_numval1 <= 1 THEN
2728: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2729: okl_debug_pub.log_debug(fnd_log.level_procedure
2730: ,l_module
2731: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2732: END IF;
2733: RETURN false;

Line 2742: okl_debug_pub.log_debug(fnd_log.level_procedure

2738: l_ec2_dateval1 := fnd_date.canonical_to_date(l_ec2_value1);
2739: IF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'EQ' THEN
2740: IF l_ec1_dateval1 <> l_ec2_dateval1 THEN
2741: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2742: okl_debug_pub.log_debug(fnd_log.level_procedure
2743: ,l_module
2744: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2745: END IF;
2746: RETURN false;

Line 2751: okl_debug_pub.log_debug(fnd_log.level_procedure

2747: END IF;
2748: ELSIF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'NE' THEN
2749: IF l_ec1_dateval1 >= l_ec2_dateval1 THEN
2750: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2751: okl_debug_pub.log_debug(fnd_log.level_procedure
2752: ,l_module
2753: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2754: END IF;
2755: RETURN false;

Line 2760: okl_debug_pub.log_debug(fnd_log.level_procedure

2756: END IF;
2757: ELSIF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'LT' THEN
2758: IF l_ec1_dateval1 >= l_ec2_dateval1 THEN
2759: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2760: okl_debug_pub.log_debug(fnd_log.level_procedure
2761: ,l_module
2762: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2763: END IF;
2764: RETURN false;

Line 2769: okl_debug_pub.log_debug(fnd_log.level_procedure

2765: END IF;
2766: ELSIF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'GT' THEN
2767: IF l_ec1_dateval1 <= l_ec2_dateval1 THEN
2768: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2769: okl_debug_pub.log_debug(fnd_log.level_procedure
2770: ,l_module
2771: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2772: END IF;
2773: RETURN false;

Line 2778: okl_debug_pub.log_debug(fnd_log.level_procedure

2774: END IF;
2775: ELSIF l_ec1_operator_code = 'NE' AND l_ec2_operator_code = 'EQ' THEN
2776: IF l_ec1_dateval1 = l_ec2_dateval1 THEN
2777: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2778: okl_debug_pub.log_debug(fnd_log.level_procedure
2779: ,l_module
2780: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2781: END IF;
2782: RETURN false;

Line 2787: okl_debug_pub.log_debug(fnd_log.level_procedure

2783: END IF;
2784: ELSIF l_ec1_operator_code = 'LT' AND l_ec2_operator_code = 'EQ' THEN
2785: IF l_ec1_dateval1 <= l_ec2_dateval1 THEN
2786: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2787: okl_debug_pub.log_debug(fnd_log.level_procedure
2788: ,l_module
2789: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2790: END IF;
2791: RETURN false;

Line 2796: okl_debug_pub.log_debug(fnd_log.level_procedure

2792: END IF;
2793: ELSIF l_ec1_operator_code = 'LT' AND l_ec2_operator_code = 'GT' THEN
2794: IF l_ec1_dateval1 - l_ec2_dateval1 <= 1 THEN
2795: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2796: okl_debug_pub.log_debug(fnd_log.level_procedure
2797: ,l_module
2798: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2799: END IF;
2800: RETURN false;

Line 2805: okl_debug_pub.log_debug(fnd_log.level_procedure

2801: END IF;
2802: ELSIF l_ec1_operator_code = 'GT' AND l_ec2_operator_code = 'EQ' THEN
2803: IF l_ec1_dateval1 >= l_ec2_dateval1 THEN
2804: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2805: okl_debug_pub.log_debug(fnd_log.level_procedure
2806: ,l_module
2807: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2808: END IF;
2809: RETURN false;

Line 2814: okl_debug_pub.log_debug(fnd_log.level_procedure

2810: END IF;
2811: ELSIF l_ec1_operator_code = 'GT' AND l_ec2_operator_code = 'LT' THEN
2812: IF l_ec2_dateval1 - l_ec1_dateval1 <= 1 THEN
2813: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2814: okl_debug_pub.log_debug(fnd_log.level_procedure
2815: ,l_module
2816: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2817: END IF;
2818: RETURN false;

Line 2825: okl_debug_pub.log_debug(fnd_log.level_procedure

2821: ELSIF ec1_tbl(i).data_type_code = 'VARCHAR2' THEN
2822: IF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'EQ' THEN
2823: IF l_ec1_value1 <> l_ec2_value1 THEN
2824: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2825: okl_debug_pub.log_debug(fnd_log.level_procedure
2826: ,l_module
2827: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2828: END IF;
2829: RETURN false;

Line 2834: okl_debug_pub.log_debug(fnd_log.level_procedure

2830: END IF;
2831: ELSIF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'NE' THEN
2832: IF l_ec1_value1 >= l_ec2_value1 THEN
2833: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2834: okl_debug_pub.log_debug(fnd_log.level_procedure
2835: ,l_module
2836: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2837: END IF;
2838: RETURN false;

Line 2843: okl_debug_pub.log_debug(fnd_log.level_procedure

2839: END IF;
2840: ELSIF l_ec1_operator_code = 'NE' AND l_ec2_operator_code = 'EQ' THEN
2841: IF l_ec1_value1 = l_ec2_value1 THEN
2842: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2843: okl_debug_pub.log_debug(fnd_log.level_procedure
2844: ,l_module
2845: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2846: END IF;
2847: RETURN false;

Line 2861: okl_debug_pub.log_debug(fnd_log.level_procedure

2857: END IF;
2858: END IF;
2859:
2860: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2861: okl_debug_pub.log_debug(fnd_log.level_procedure
2862: ,l_module
2863: ,'end debug OKLRECUB.pls.pls call compare_eligibility_criteria');
2864: END IF;
2865: RETURN true;