147: -- based on the conversion set rules defined
148: BEGIN
149: SELECT include_flag
150: INTO l_conversion_flag
151: FROM gl_je_inclusion_rules
152: WHERE je_rule_set_id = l_je_conv_set_id
153: AND je_source_name = p_je_source_name
154: AND je_category_name = p_je_category_name;
155: EXCEPTION
156: WHEN OTHERS THEN
157: BEGIN
158: SELECT include_flag
159: INTO l_conversion_flag
160: FROM gl_je_inclusion_rules
161: WHERE je_rule_set_id = l_je_conv_set_id
162: AND je_source_name = p_je_source_name
163: AND je_category_name = 'Other';
164: EXCEPTION
165: WHEN OTHERS THEN
166: BEGIN
167: SELECT include_flag
168: INTO l_conversion_flag
169: FROM gl_je_inclusion_rules
170: WHERE je_rule_set_id = l_je_conv_set_id
171: AND je_source_name = 'Other'
172: AND je_category_name = p_je_category_name;
173: EXCEPTION
174: WHEN OTHERS THEN
175: BEGIN
176: SELECT include_flag
177: INTO l_conversion_flag
178: FROM gl_je_inclusion_rules
179: WHERE je_rule_set_id = l_je_conv_set_id
180: AND je_source_name = 'Other'
181: AND je_category_name = 'Other';
182: EXCEPTION