DBA Data[Home] [Help]

APPS.MSD_DEM_COLLECT_CURRENCY dependencies on MSD_DEM_COLLECT_CURRENCY

Line 1: PACKAGE BODY msd_dem_collect_currency AS

1: PACKAGE BODY msd_dem_collect_currency AS
2: /* $Header: msddemccb.pls 120.5.12010000.5 2009/06/08 10:39:07 syenamar ship $ */
3:
4: PROCEDURE get_min_max_date(l_min_date OUT NOCOPY DATE,
5: l_max_date OUT NOCOPY DATE) AS

Line 324: msd_dem_common_utilities.log_debug('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

320: l_curr_code VARCHAR2(30);
321:
322: BEGIN
323:
324: msd_dem_common_utilities.log_debug('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
325: msd_dem_common_utilities.log_message('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
326:
327: /* Get the db link to the source instance */ msd_dem_common_utilities.get_dblink(x_errbuf, x_retcode, p_instance_id, g_dblink);
328:

Line 325: msd_dem_common_utilities.log_message('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

321:
322: BEGIN
323:
324: msd_dem_common_utilities.log_debug('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
325: msd_dem_common_utilities.log_message('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
326:
327: /* Get the db link to the source instance */ msd_dem_common_utilities.get_dblink(x_errbuf, x_retcode, p_instance_id, g_dblink);
328:
329: IF(x_retcode = '-1') THEN

Line 332: msd_dem_common_utilities.log_message('Error(1): msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

328:
329: IF(x_retcode = '-1') THEN
330: retcode := -1;
331: errbuf := x_errbuf;
332: msd_dem_common_utilities.log_message('Error(1): msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
333: RETURN;
334: END IF;
335:
336: /* Get the min and max date in demantra time */

Line 350: msd_dem_common_utilities.log_message('Error: msd_dem_collect_currency.collect_currency- ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

346:
347: IF(l_date_from > l_date_to) THEN
348: retcode := -1;
349: errbuf := 'From Date should not be greater than To Date.';
350: msd_dem_common_utilities.log_message('Error: msd_dem_collect_currency.collect_currency- ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
351: msd_dem_common_utilities.log_message(errbuf);
352: RETURN;
353: END IF;
354:

Line 473: END msd_dem_collect_currency;

469: retcode := -1;
470:
471: END;
472:
473: END msd_dem_collect_currency;
474: