DBA Data[Home] [Help]

APPS.EDW_GL_ACCT_M_C dependencies on EDW_GL_ACCT_M_C

Line 1: Package Body EDW_GL_ACCT_M_C AS

1: Package Body EDW_GL_ACCT_M_C AS
2: /* $Header: EDWVBHPB.pls 120.4 2006/03/10 03:34:08 rkumar noship $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: G_DEBUG Boolean:=false;

Line 1276: EDW_GL_ACCT_M_C.g_push_date_range1 := nvl(l_from_date,

1272: edw_log.put_line('Collect program for '|| p_dimension_name ||' dimension');
1273: edw_log.put_line('Dimension number '|| p_dimension_no);
1274: edw_log.put_line('Dimension physical name : '||g_dimension_name);
1275:
1276: EDW_GL_ACCT_M_C.g_push_date_range1 := nvl(l_from_date,
1277: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1278: EDW_GL_ACCT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1279: EDW_LOG.PUT_LINE( 'The collection range is from '||to_char(EDW_GL_ACCT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||to_char(EDW_GL_ACCT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
1280: EDW_LOG.PUT_LINE(' ');

Line 1278: EDW_GL_ACCT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

1274: edw_log.put_line('Dimension physical name : '||g_dimension_name);
1275:
1276: EDW_GL_ACCT_M_C.g_push_date_range1 := nvl(l_from_date,
1277: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1278: EDW_GL_ACCT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1279: EDW_LOG.PUT_LINE( 'The collection range is from '||to_char(EDW_GL_ACCT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||to_char(EDW_GL_ACCT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
1280: EDW_LOG.PUT_LINE(' ');
1281:
1282: select FND_PROFILE.VALUE('EDW_PARALLEL_SRC') into g_parallel_level from dual;

Line 1279: EDW_LOG.PUT_LINE( 'The collection range is from '||to_char(EDW_GL_ACCT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||to_char(EDW_GL_ACCT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

1275:
1276: EDW_GL_ACCT_M_C.g_push_date_range1 := nvl(l_from_date,
1277: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1278: EDW_GL_ACCT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1279: EDW_LOG.PUT_LINE( 'The collection range is from '||to_char(EDW_GL_ACCT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||to_char(EDW_GL_ACCT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
1280: EDW_LOG.PUT_LINE(' ');
1281:
1282: select FND_PROFILE.VALUE('EDW_PARALLEL_SRC') into g_parallel_level from dual;
1283: if ( g_parallel_level is not null ) then

Line 1491: EDW_GL_ACCT_M_C.g_exception_msg := l_exception_msg;

1487: When others then
1488: Errbuf:=sqlerrm;
1489: Retcode:=sqlcode;
1490: l_exception_msg := Retcode || ':' || Errbuf;
1491: EDW_GL_ACCT_M_C.g_exception_msg := l_exception_msg;
1492: rollback;
1493: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_GL_ACCT_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);
1494:
1495: End push;

Line 1493: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_GL_ACCT_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);

1489: Retcode:=sqlcode;
1490: l_exception_msg := Retcode || ':' || Errbuf;
1491: EDW_GL_ACCT_M_C.g_exception_msg := l_exception_msg;
1492: rollback;
1493: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_GL_ACCT_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);
1494:
1495: End push;
1496:
1497: END EDW_GL_ACCT_M_C ;

Line 1497: END EDW_GL_ACCT_M_C ;

1493: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_GL_ACCT_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);
1494:
1495: End push;
1496:
1497: END EDW_GL_ACCT_M_C ;