175: l_seg_condition_der_sources c_seg_condition_der_sources%rowtype;
176:
177: BEGIN
178:
179: xla_utility_pkg.trace('> xla_tab_acct_defs_pkg.invalid_seg_rule' , 10);
180:
181: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
182: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
183: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
177: BEGIN
178:
179: xla_utility_pkg.trace('> xla_tab_acct_defs_pkg.invalid_seg_rule' , 10);
180:
181: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
182: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
183: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
184:
185: --
178:
179: xla_utility_pkg.trace('> xla_tab_acct_defs_pkg.invalid_seg_rule' , 10);
180:
181: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
182: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
183: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
184:
185: --
186: -- check if segment rules has details existing
179: xla_utility_pkg.trace('> xla_tab_acct_defs_pkg.invalid_seg_rule' , 10);
180:
181: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
182: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
183: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
184:
185: --
186: -- check if segment rules has details existing
187: --
319: CLOSE c_seg_condition_der_sources;
320: END IF;
321: */
322:
323: xla_utility_pkg.trace('< xla_tab_acct_defs_pkg.invalid_seg_rule' , 10);
324:
325: return l_return;
326:
327: EXCEPTION
390: l_source_type varchar2(80) := null;
391:
392: BEGIN
393:
394: xla_utility_pkg.trace('> xla_tab_acct_defs_pkg.invalid_segment_rule' , 10);
395:
396: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
397: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
398: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
392: BEGIN
393:
394: xla_utility_pkg.trace('> xla_tab_acct_defs_pkg.invalid_segment_rule' , 10);
395:
396: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
397: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
398: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
399:
400: --
393:
394: xla_utility_pkg.trace('> xla_tab_acct_defs_pkg.invalid_segment_rule' , 10);
395:
396: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
397: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
398: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
399:
400: --
401: -- call invalid_seg_rule to see if segment rule is invalid
394: xla_utility_pkg.trace('> xla_tab_acct_defs_pkg.invalid_segment_rule' , 10);
395:
396: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
397: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
398: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
399:
400: --
401: -- call invalid_seg_rule to see if segment rule is invalid
402: --
414: ELSE
415: l_return := 'FALSE';
416: END IF;
417:
418: xla_utility_pkg.trace('< xla_tab_acct_defs_pkg.invalid_segment_rule' , 10);
419: return l_return;
420:
421: EXCEPTION
422: WHEN xla_exceptions_pkg.application_exception THEN
463:
464: BEGIN
465:
466:
467: xla_utility_pkg.trace('> xla_tab_acct_defs_pkg.uncompile_tran_acct_def' , 10);
468:
469: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
470:
471: OPEN c_prod_rules;
465:
466:
467: xla_utility_pkg.trace('> xla_tab_acct_defs_pkg.uncompile_tran_acct_def' , 10);
468:
469: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
470:
471: OPEN c_prod_rules;
472: FETCH c_prod_rules
473: INTO l_exist;
483: END IF;
484: CLOSE c_prod_rules;
485:
486:
487: xla_utility_pkg.trace('< xla_tab_acct_defs_pkg.uncompile_tran_acct_def' , 10);
488:
489: return l_return;
490:
491: EXCEPTION