APPS.OPI_EDW_OPM_RES_UTIL_F_C dependencies on EDW_COLLECTION_UTIL

Line 157: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,l_staging_table,l_staging_table,l_exception_msg)) THEN

153: Errbuf :=NULL;
154: Retcode:=0;
155: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
156: l_to_date :=to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS');
157: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,l_staging_table,l_staging_table,l_exception_msg)) THEN
158: errbuf := fnd_message.get;
159: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
160: Return;
161: END IF;

Line 167: EDW_COLLECTION_UTIL.G_local_last_push_start_date -

163: -- Taking care of cases where the input from/to
164: -- date is NULL.
165: -- --------------------------------------------
166: g_push_from_date := nvl(l_from_date,
167: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
168: EDW_COLLECTION_UTIL.g_offset);
169: g_push_to_date := nvl(l_to_date,
170: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
171: edw_log.put_line( 'The collection range is from '||

Line 168: EDW_COLLECTION_UTIL.g_offset);

164: -- date is NULL.
165: -- --------------------------------------------
166: g_push_from_date := nvl(l_from_date,
167: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
168: EDW_COLLECTION_UTIL.g_offset);
169: g_push_to_date := nvl(l_to_date,
170: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
171: edw_log.put_line( 'The collection range is from '||
172: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 170: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

166: g_push_from_date := nvl(l_from_date,
167: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
168: EDW_COLLECTION_UTIL.g_offset);
169: g_push_to_date := nvl(l_to_date,
170: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
171: edw_log.put_line( 'The collection range is from '||
172: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
173: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
174: edw_log.put_line(' ');

Line 197: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,

193: edw_log.put_line(' ');
194: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
195: ' rows into the staging table');
196: edw_log.put_line(' ');
197: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
198: g_push_from_date, g_push_to_date);
199: -- ---------------------------------------------------------------------------
200: -- END OF Collection , Developer Customizable Section
201: -- ---------------------------------------------------------------------------

Line 209: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);

205: Retcode:=g_retcode;
206: l_exception_msg := Retcode || ':' || Errbuf;
207: rollback; -- Rollback insert into local staging
208: edw_log.put_line('Inserting into local staging have failed');
209: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
210: raise;
211: WHEN L_IDEN_CHANGE_FAILURE THEN
212: Errbuf:=g_errbuf;
213: Retcode:=g_retcode;

Line 216: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);

212: Errbuf:=g_errbuf;
213: Retcode:=g_retcode;
214: l_exception_msg := Retcode || ':' || Errbuf;
215: edw_log.put_line('Identifying changed records have Failed');
216: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
217: raise;
218: WHEN OTHERS THEN
219: Errbuf:=g_errbuf;
220: Retcode:=g_retcode;

Line 224: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,

220: Retcode:=g_retcode;
221: l_exception_msg := Retcode || ':' || Errbuf;
222: rollback;
223: edw_log.put_line('Other errors');
224: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
225: g_push_from_date, g_push_to_date);
226: raise;
227: END;
228: END OPI_EDW_OPM_RES_UTIL_F_C ;