[Home] [Help]
485: -- e. Currency is not an EMU currency
486: -- o Range of dates specified does not exceeds 366 days
487: --
488: -- If there is any error, an appropriate error_code will be set.
489: gl_message.func_ent('Daily Rates Import');
490:
491: -- GL_CRM_UTILITIES_PKG.DEBUG_MODE := TRUE;
492: /*If the Batch Number is NULL, it'll process only the records with Batch Number NULL records in the GL_DAILY_RATES_INTERFACE Table.*/
493: /* Updating BATCH_NUMNER '-99999' in the Interface table if Batch Number Parameter is NULL*/
932: --- will run the gl_rate_rates here, which will remove all the gl_daily_rates lines.
933: fnd_profile.get('GL_CRM_CR_OVERRIDE', golden_rule_flag);
934:
935: IF DEBUG_MODE THEN
936: gl_message.write_log('CRM0004', 1, 'VALUE', golden_rule_flag);
937: END IF;
938:
939: IF (golden_rule_flag = 'SYSTEM') OR(golden_rule_flag = 'BOTH') THEN
940: IF DEBUG_MODE THEN
1428: FROM gl_daily_conversion_types gct,
1429: gl_cross_rate_rules gcrs
1430: WHERE gct.conversion_type = gcrs.conversion_type);
1431:
1432: gl_message.func_ent('Cross Rates Calculation');
1433:
1434: -- select all the lines who can be calculate cross rate from the gl_daily_rates table
1435: IF DEBUG_MODE THEN
1436: fnd_file.put_line(fnd_file.LOG, 'Clean gl_cross_rate_temp.');
1983: p_parameter_name3 => 'ERROR_MESSAGE',
1984: p_parameter_value3 => l_error_message
1985: );
1986:
1987: gl_message.write_log('CRM0002', 0);
1988: fnd_file.put_line
1989: (fnd_file.LOG,
1990: 'Error: Duplicate Row or Overlapping Date Range found.');
1991: fnd_file.put_line
1996: ('ERROR',
1997: 'Error: Duplicate Row or Overlapping Date Range found.');
1998: END;
1999:
2000: gl_message.func_succ('Cross Rates Calculation');
2001: END IF;
2002:
2003: ---- End Calculation
2004: