APPS.FII_PA_EXP_TYPE_M_C dependencies on FII_PA_EXP_TYPE_M_C

Line 1: Package Body FII_PA_EXP_TYPE_M_C AS

1: Package Body FII_PA_EXP_TYPE_M_C AS
2: /* $Header: FIIPA08B.pls 120.2 2005/06/07 15:02:03 pschandr ship $ */
3:
4: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
5:

Line 40: FII_PA_EXP_TYPE_M_C.g_push_date_range1 := nvl(l_from_date, EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

36: errbuf := fnd_message.get;
37: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
38: END IF;
39:
40: FII_PA_EXP_TYPE_M_C.g_push_date_range1 := nvl(l_from_date, EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
41: FII_PA_EXP_TYPE_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
42:
43: if g_debug_flag = 'Y' then
44: edw_log.put_line( 'The collection range is from '||

Line 41: FII_PA_EXP_TYPE_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

37: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
38: END IF;
39:
40: FII_PA_EXP_TYPE_M_C.g_push_date_range1 := nvl(l_from_date, EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
41: FII_PA_EXP_TYPE_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
42:
43: if g_debug_flag = 'Y' then
44: edw_log.put_line( 'The collection range is from '||
45: to_char(FII_PA_EXP_TYPE_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||

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

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

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

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

Line 61: Push_EDW_PA_PAEX_EXP_TYPE_LSTG(FII_PA_EXP_TYPE_M_C.g_push_date_range1, FII_PA_EXP_TYPE_M_C.g_push_date_range2);

57: end if;
58:
59: l_temp_date := sysdate;
60:
61: Push_EDW_PA_PAEX_EXP_TYPE_LSTG(FII_PA_EXP_TYPE_M_C.g_push_date_range1, FII_PA_EXP_TYPE_M_C.g_push_date_range2);
62:
63: l_duration := sysdate - l_temp_date;
64:
65: if g_debug_flag = 'Y' then

Line 81: FII_PA_EXP_TYPE_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_PA_EXP_TYPE_M_C.g_exception_msg := l_exception_msg;
82: rollback;
83: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_PA_EXP_TYPE_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_PA_EXP_TYPE_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);

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

Line 152: End FII_PA_EXP_TYPE_M_C;

148: Exception When others then
149: raise;
150: commit;
151: END;
152: End FII_PA_EXP_TYPE_M_C;