238: IF v_map_projects_flag = 'Y' THEN
239: IF dist_rec.project IS NOT NULL THEN
240: -- Note that the package being called will issue an error message if it can't find a mapping, so there's no need
241: -- for this trigger to handle this exception.
242: v_facility_id := GHG_ORGANIZATION_MAPPINGS_PKG.find_project_mapping(dist_rec.distribution_line_number, dist_rec.project, dist_rec.task, dist_rec.gl_date);
243: ELSE
244: v_facility_id := GHG_ORGANIZATION_MAPPINGS_PKG.find_flexfield_mapping(dist_rec.distribution_line_number, dist_rec.code_combination_id, v_chart_of_accounts_id, dist_rec.gl_date);
245: END IF;
246: ELSE
240: -- Note that the package being called will issue an error message if it can't find a mapping, so there's no need
241: -- for this trigger to handle this exception.
242: v_facility_id := GHG_ORGANIZATION_MAPPINGS_PKG.find_project_mapping(dist_rec.distribution_line_number, dist_rec.project, dist_rec.task, dist_rec.gl_date);
243: ELSE
244: v_facility_id := GHG_ORGANIZATION_MAPPINGS_PKG.find_flexfield_mapping(dist_rec.distribution_line_number, dist_rec.code_combination_id, v_chart_of_accounts_id, dist_rec.gl_date);
245: END IF;
246: ELSE
247: v_facility_id := GHG_ORGANIZATION_MAPPINGS_PKG.find_flexfield_mapping(dist_rec.distribution_line_number, dist_rec.code_combination_id, v_chart_of_accounts_id, dist_rec.gl_date);
248: END IF;
243: ELSE
244: v_facility_id := GHG_ORGANIZATION_MAPPINGS_PKG.find_flexfield_mapping(dist_rec.distribution_line_number, dist_rec.code_combination_id, v_chart_of_accounts_id, dist_rec.gl_date);
245: END IF;
246: ELSE
247: v_facility_id := GHG_ORGANIZATION_MAPPINGS_PKG.find_flexfield_mapping(dist_rec.distribution_line_number, dist_rec.code_combination_id, v_chart_of_accounts_id, dist_rec.gl_date);
248: END IF;
249: ELSIF v_map_projects_flag = 'Y' THEN
250: IF dist_rec.project IS NOT NULL THEN
251: v_facility_id := GHG_ORGANIZATION_MAPPINGS_PKG.find_project_mapping(dist_rec.distribution_line_number, dist_rec.project, dist_rec.task, dist_rec.gl_date);
247: v_facility_id := GHG_ORGANIZATION_MAPPINGS_PKG.find_flexfield_mapping(dist_rec.distribution_line_number, dist_rec.code_combination_id, v_chart_of_accounts_id, dist_rec.gl_date);
248: END IF;
249: ELSIF v_map_projects_flag = 'Y' THEN
250: IF dist_rec.project IS NOT NULL THEN
251: v_facility_id := GHG_ORGANIZATION_MAPPINGS_PKG.find_project_mapping(dist_rec.distribution_line_number, dist_rec.project, dist_rec.task, dist_rec.gl_date);
252: ELSIF v_map_operating_unit_flag = 'Y' THEN
253: v_facility_id := v_facility_id_for_op_unit;
254: ELSE
255: FND_MESSAGE.SET_NAME('GHG', 'GHG_PROJECT_NOT_SPECIFIED');