APPS.FII_PA_BUDGET_M_C dependencies on FII_PA_BUDGET_M_C

Line 1: Package Body FII_PA_BUDGET_M_C AS

1: Package Body FII_PA_BUDGET_M_C AS
2: /* $Header: FIIPA09B.pls 120.1 2002/11/22 20:21:33 svermett ship $ */
3:
4: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
5:

Line 39: FII_PA_BUDGET_M_C.g_push_date_range1 :=

35: errbuf := fnd_message.get;
36: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
37: END IF;
38:
39: FII_PA_BUDGET_M_C.g_push_date_range1 :=
40: nvl(l_from_date, EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
41:
42: FII_PA_BUDGET_M_C.g_push_date_range2 :=
43: nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

Line 42: FII_PA_BUDGET_M_C.g_push_date_range2 :=

38:
39: FII_PA_BUDGET_M_C.g_push_date_range1 :=
40: nvl(l_from_date, EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
41:
42: FII_PA_BUDGET_M_C.g_push_date_range2 :=
43: nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
44:
45: if g_debug_flag = 'Y' then
46: edw_log.put_line( 'The collection range is from '||

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

43: nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
44:
45: if g_debug_flag = 'Y' then
46: edw_log.put_line( 'The collection range is from '||
47: to_char(FII_PA_BUDGET_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
48: to_char(FII_PA_BUDGET_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
49: edw_log.put_line(' ');
50: end if;
51:

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

44:
45: if g_debug_flag = 'Y' then
46: edw_log.put_line( 'The collection range is from '||
47: to_char(FII_PA_BUDGET_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
48: to_char(FII_PA_BUDGET_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
49: edw_log.put_line(' ');
50: end if;
51:
52: -- -----------------------------------------------------------------------------

Line 64: Push_FII_PA_PABU_BUDGET_LSTG(FII_PA_BUDGET_M_C.g_push_date_range1, FII_PA_BUDGET_M_C.g_push_date_range2);

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

Line 84: FII_PA_BUDGET_M_C.g_exception_msg := l_exception_msg;

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

Line 86: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_PA_BUDGET_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);

82: Retcode:=sqlcode;
83: l_exception_msg := Retcode || ':' || Errbuf;
84: FII_PA_BUDGET_M_C.g_exception_msg := l_exception_msg;
85: rollback;
86: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_PA_BUDGET_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);
87:
88: commit;
89: End;
90:

Line 166: End FII_PA_BUDGET_M_C;

162: Exception When others then
163: raise;
164: commit;
165: END;
166: End FII_PA_BUDGET_M_C;