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;
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(' ');
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;
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
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;
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 ;
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 ;