APPS.EDW_BOM_RES_M_C dependencies on EDW_COLLECTION_UTIL

Line 22: IF (Not EDW_COLLECTION_UTIL.setup('EDW_BOM_RES_M')) THEN

18: Begin
19: Errbuf :=NULL;
20: Retcode:=NULL;
21:
22: IF (Not EDW_COLLECTION_UTIL.setup('EDW_BOM_RES_M')) THEN
23: errbuf := fnd_message.get;
24: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
25: END IF;
26:

Line 32: l_push_date_range1:= nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

28:
29: l_from_date := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
30: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
31:
32: l_push_date_range1:= nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
33: l_push_date_range2:= nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: edw_log.put_line( 'The collection range is from '||
35: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
36: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

Line 33: l_push_date_range2:= nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

29: l_from_date := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
30: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
31:
32: l_push_date_range1:= nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
33: l_push_date_range2:= nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: edw_log.put_line( 'The collection range is from '||
35: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
36: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
37: edw_log.put_line(' ');

Line 50: EDW_COLLECTION_UTIL.wrapup(TRUE, EDW_BOM_RES_M_C.g_row_count, null, l_push_date_range1, l_push_date_range2);

46: Push_EDW_BRES_PARENT_DEPT(l_push_date_range1, l_push_date_range2);
47: Push_EDW_BRES_DEPT(l_push_date_range1, l_push_date_range2);
48: Push_EDW_BRES_DEPT_CLASS(l_push_date_range1, l_push_date_range2);
49:
50: EDW_COLLECTION_UTIL.wrapup(TRUE, EDW_BOM_RES_M_C.g_row_count, null, l_push_date_range1, l_push_date_range2);
51: commit;
52:
53: Exception When others then
54: Errbuf := sqlerrm;

Line 58: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_BOM_RES_M_C.g_exception_message,l_push_date_range1, l_push_date_range2);

54: Errbuf := sqlerrm;
55: Retcode := sqlcode;
56: EDW_BOM_RES_M_C.g_exception_message := EDW_BOM_RES_M_C.g_exception_message||' <> '||Retcode||' : '||Errbuf;
57: Rollback;
58: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_BOM_RES_M_C.g_exception_message,l_push_date_range1, l_push_date_range2);
59: commit;
60:
61: End Push;
62: