APPS.EDW_ALL_COLLECT dependencies on EDW_ALL_COLLECT

Line 1: package body EDW_ALL_COLLECT AS

1: package body EDW_ALL_COLLECT AS
2: /*$Header: EDWACOLB.pls 120.0 2005/06/01 16:43:59 appldev noship $*/
3: l_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
4: l_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
5: l_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 646: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('ERROR In EDW_ALL_COLLECT.Collect_Dimension,

642: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n(g_status_message,FND_LOG.LEVEL_ERROR);
643: retcode:='2';
644: return_with_error(g_load_pk,'LOG');
645: when others then
646: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('ERROR In EDW_ALL_COLLECT.Collect_Dimension,
647: Error mesg:'||sqlerrm||' Time '||get_time,FND_LOG.LEVEL_ERROR);
648: g_status_message:=sqlerrm;
649: errbuf:=g_status_message;
650: retcode:='2';

Line 1006: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('ERROR:EDW_ALL_COLLECT.Collect_Each_Level, finish '||

1002: if g_debug then
1003: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Finished Collect_Each_Level'||get_time,FND_LOG.LEVEL_PROCEDURE);
1004: end if;
1005: Exception when others then
1006: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('ERROR:EDW_ALL_COLLECT.Collect_Each_Level, finish '||
1007: ' collect level '||g_primary_target(l_latest)||' WITH ERROR::'||sqlerrm||' Time '||get_time,FND_LOG.LEVEL_ERROR);
1008: g_status:=false;
1009: g_status_message:=sqlerrm;
1010: return;

Line 1384: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('FINISH : EDW_ALL_COLLECT.Collect_Fact, Time '||

1380: null
1381: );
1382: insert_into_load_progress_nd(g_load_pk,null,null,null,null,sysdate,null,null,'LF','U');
1383: if l_status=true then
1384: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('FINISH : EDW_ALL_COLLECT.Collect_Fact, Time '||
1385: get_time,FND_LOG.LEVEL_PROCEDURE);
1386: else
1387: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('FINISH with ERROR: EDW_ALL_COLLECT.Collect_Fact '||
1388: EDW_MAPPING_COLLECT.get_status_message||' Time '||get_time,FND_LOG.LEVEL_PROCEDURE);

Line 1387: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('FINISH with ERROR: EDW_ALL_COLLECT.Collect_Fact '||

1383: if l_status=true then
1384: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('FINISH : EDW_ALL_COLLECT.Collect_Fact, Time '||
1385: get_time,FND_LOG.LEVEL_PROCEDURE);
1386: else
1387: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('FINISH with ERROR: EDW_ALL_COLLECT.Collect_Fact '||
1388: EDW_MAPPING_COLLECT.get_status_message||' Time '||get_time,FND_LOG.LEVEL_PROCEDURE);
1389: g_status:=false;
1390: g_status_message:=EDW_MAPPING_COLLECT.get_status_message;
1391: errbuf:=g_status_message;

Line 1450: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('ERROR:EDW_ALL_COLLECT.Collect_Fact,

1446: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Finished post_coll with error'||get_time,FND_LOG.LEVEL_ERROR);
1447: end if;
1448: /*******************END WORKFLOW API*****************************************/
1449: Exception when others then
1450: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('ERROR:EDW_ALL_COLLECT.Collect_Fact,
1451: ERROR '||sqlerrm||' Time '||get_time,FND_LOG.LEVEL_ERROR);
1452: g_status:=false;
1453: g_status_message:=sqlerrm;
1454: errbuf:=g_status_message;

Line 3332: END EDW_ALL_COLLECT;

3328: raise;
3329: End;
3330:
3331:
3332: END EDW_ALL_COLLECT;