APPS.FII_GL_BOOK_M_C dependencies on FII_GL_BOOK_M_C

Line 1: Package Body FII_GL_BOOK_M_C AS

1: Package Body FII_GL_BOOK_M_C AS
2: /* $Header: FIICMBKB.pls 120.2 2002/11/20 20:01:56 djanaswa ship $ */
3:
4: G_PUSH_DATE_RANGE1 Date :=Null;
5: G_PUSH_DATE_RANGE2 Date :=Null;

Line 45: FII_GL_BOOK_M_C.g_push_date_range1 := nvl(l_from_date,

41: errbuf := fnd_message.get;
42: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
43: END IF;
44:
45: FII_GL_BOOK_M_C.g_push_date_range1 := nvl(l_from_date,
46: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
47: FII_GL_BOOK_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
48: edw_log.put_line( 'The collection range is from '||
49: to_char(FII_GL_BOOK_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 47: FII_GL_BOOK_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

43: END IF;
44:
45: FII_GL_BOOK_M_C.g_push_date_range1 := nvl(l_from_date,
46: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
47: FII_GL_BOOK_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
48: edw_log.put_line( 'The collection range is from '||
49: to_char(FII_GL_BOOK_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
50: to_char(FII_GL_BOOK_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
51: edw_log.put_line(' ');

Line 49: to_char(FII_GL_BOOK_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||

45: FII_GL_BOOK_M_C.g_push_date_range1 := nvl(l_from_date,
46: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
47: FII_GL_BOOK_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
48: edw_log.put_line( 'The collection range is from '||
49: to_char(FII_GL_BOOK_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
50: to_char(FII_GL_BOOK_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
51: edw_log.put_line(' ');
52:
53: -- -----------------------------------------------------------------------------

Line 50: to_char(FII_GL_BOOK_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

46: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
47: FII_GL_BOOK_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
48: edw_log.put_line( 'The collection range is from '||
49: to_char(FII_GL_BOOK_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
50: to_char(FII_GL_BOOK_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
51: edw_log.put_line(' ');
52:
53: -- -----------------------------------------------------------------------------
54: -- Start of Collection , Developer Customizable Section

Line 63: Push_EDW_GL_BOOK_FA_BOOK_LSTG(FII_GL_BOOK_M_C.g_push_date_range1, FII_GL_BOOK_M_C.g_push_date_range2);

59:
60: l_temp_date := sysdate;
61:
62:
63: Push_EDW_GL_BOOK_FA_BOOK_LSTG(FII_GL_BOOK_M_C.g_push_date_range1, FII_GL_BOOK_M_C.g_push_date_range2);
64: Push_EDW_GL_BOOK_BOOK_LSTG(FII_GL_BOOK_M_C.g_push_date_range1, FII_GL_BOOK_M_C.g_push_date_range2);
65:
66:
67: l_duration := sysdate - l_temp_date;

Line 64: Push_EDW_GL_BOOK_BOOK_LSTG(FII_GL_BOOK_M_C.g_push_date_range1, FII_GL_BOOK_M_C.g_push_date_range2);

60: l_temp_date := sysdate;
61:
62:
63: Push_EDW_GL_BOOK_FA_BOOK_LSTG(FII_GL_BOOK_M_C.g_push_date_range1, FII_GL_BOOK_M_C.g_push_date_range2);
64: Push_EDW_GL_BOOK_BOOK_LSTG(FII_GL_BOOK_M_C.g_push_date_range1, FII_GL_BOOK_M_C.g_push_date_range2);
65:
66:
67: l_duration := sysdate - l_temp_date;
68:

Line 81: FII_GL_BOOK_M_C.g_exception_msg := l_exception_msg;

77: Exception When others then
78: Errbuf:=sqlerrm;
79: Retcode:=sqlcode;
80: l_exception_msg := Retcode || ':' || Errbuf;
81: FII_GL_BOOK_M_C.g_exception_msg := l_exception_msg;
82: rollback;
83: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_GL_BOOK_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);
84:
85: commit;

Line 83: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_GL_BOOK_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);

79: Retcode:=sqlcode;
80: l_exception_msg := Retcode || ':' || Errbuf;
81: FII_GL_BOOK_M_C.g_exception_msg := l_exception_msg;
82: rollback;
83: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_GL_BOOK_M_C.g_exception_msg,g_push_date_range1, g_push_date_range2);
84:
85: commit;
86: End;
87:

Line 223: End FII_GL_BOOK_M_C;

219: raise;
220: commit;
221: END;
222:
223: End FII_GL_BOOK_M_C;