APPS.EDW_LOOKUP_M_C dependencies on EDW_LOOKUP_M_C

Line 1: Package Body EDW_LOOKUP_M_C AS

1: Package Body EDW_LOOKUP_M_C AS
2: /* $Header: poapplkb.pls 120.1 2005/06/13 13:14:05 sriswami noship $ */
3:
4: g_row_count Number :=0;
5: g_exception_message varchar2(2000) :=NULL;

Line 41: Edw_Lookup_M_C.Push_Edw_Lookups(Errbuf, Retcode, L_push_date_range1,l_push_date_range2);

37: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
38: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
39: edw_log.put_line(' ');
40:
41: Edw_Lookup_M_C.Push_Edw_Lookups(Errbuf, Retcode, L_push_date_range1,l_push_date_range2);
42:
43: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,
44: P_PERIOD_START => l_push_date_range1,
45: P_PERIOD_END => l_push_date_range2);

Line 51: EDW_LOOKUP_M_C.g_exception_message := EDW_LOOKUP_M_C.g_exception_message||'<>'||Retcode || ':' || Errbuf;

47:
48: Exception When others then
49: Errbuf := sqlerrm;
50: Retcode := sqlcode;
51: EDW_LOOKUP_M_C.g_exception_message := EDW_LOOKUP_M_C.g_exception_message||'<>'||Retcode || ':' || Errbuf;
52: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_LOOKUP_M_C.g_exception_message,
53: l_push_date_range1, l_push_date_range2);
54: rollback;
55: raise;

Line 52: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_LOOKUP_M_C.g_exception_message,

48: Exception When others then
49: Errbuf := sqlerrm;
50: Retcode := sqlcode;
51: EDW_LOOKUP_M_C.g_exception_message := EDW_LOOKUP_M_C.g_exception_message||'<>'||Retcode || ':' || Errbuf;
52: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_LOOKUP_M_C.g_exception_message,
53: l_push_date_range1, l_push_date_range2);
54: rollback;
55: raise;
56:

Line 159: EDW_LOOKUP_M_C.g_row_count := EDW_LOOKUP_M_C.g_row_count + l_rows_inserted;

155:
156: -- ---------------------------------------------------------------------------
157: -- END OF Collection , Developer Customizable Section
158: -- ---------------------------------------------------------------------------
159: EDW_LOOKUP_M_C.g_row_count := EDW_LOOKUP_M_C.g_row_count + l_rows_inserted;
160:
161: Exception When others then
162: Errbuf := sqlerrm;
163: Retcode := sqlcode;

Line 165: EDW_LOOKUP_M_C.g_exception_message := Retcode || ':' || Errbuf;

161: Exception When others then
162: Errbuf := sqlerrm;
163: Retcode := sqlcode;
164:
165: EDW_LOOKUP_M_C.g_exception_message := Retcode || ':' || Errbuf;
166: rollback;
167:
168: raise;
169:

Line 174: End EDW_LOOKUP_M_C;

170:
171: End Push_Edw_Lookups;
172:
173:
174: End EDW_LOOKUP_M_C;