646: write_to_log_file_n('pre_mapping_coll'||get_time);
647: end if;
648: insert_into_load_progress_d(g_load_pk,g_primary_target_name,'Pre Mapping Collection Hook',sysdate,null,'MAPPING',
649: 'PRE-MAP',1010,'I');
650: if EDW_COLLECTION_HOOK.pre_mapping_coll(g_primary_target_name)=false then
651: write_to_log_file_n('EDW_COLLECTION_HOOK.pre_mapping_coll returned with error.'||get_time);
652: return false;
653: end if;
654: write_to_log_file_n('EDW_COLLECTION_HOOK.pre_mapping_coll returned with success.'||get_time);
647: end if;
648: insert_into_load_progress_d(g_load_pk,g_primary_target_name,'Pre Mapping Collection Hook',sysdate,null,'MAPPING',
649: 'PRE-MAP',1010,'I');
650: if EDW_COLLECTION_HOOK.pre_mapping_coll(g_primary_target_name)=false then
651: write_to_log_file_n('EDW_COLLECTION_HOOK.pre_mapping_coll returned with error.'||get_time);
652: return false;
653: end if;
654: write_to_log_file_n('EDW_COLLECTION_HOOK.pre_mapping_coll returned with success.'||get_time);
655: insert_into_load_progress_d(g_load_pk,null,null,null,sysdate,null,null,1010,'U');
650: if EDW_COLLECTION_HOOK.pre_mapping_coll(g_primary_target_name)=false then
651: write_to_log_file_n('EDW_COLLECTION_HOOK.pre_mapping_coll returned with error.'||get_time);
652: return false;
653: end if;
654: write_to_log_file_n('EDW_COLLECTION_HOOK.pre_mapping_coll returned with success.'||get_time);
655: insert_into_load_progress_d(g_load_pk,null,null,null,sysdate,null,null,1010,'U');
656: Init_all(null);
657: insert_into_load_progress_d(g_load_pk,g_primary_target_name,'Read Metadata',sysdate,null,'MAPPING',
658: 'METADATA-READ',1020,'I');
765: write_to_log_file_n('Calling post mapping collection hook '||get_time);
766: end if;
767: insert_into_load_progress_d(g_load_pk,g_primary_target_name,'Post Mapping Collection Hook',sysdate,null,'HOOK',
768: 'POST-MAP',1070,'I');
769: if EDW_COLLECTION_HOOK.post_mapping_coll(g_primary_target_name)= false then
770: write_to_log_file_n('EDW_COLLECTION_HOOK.post_mapping_coll returned with error.'||get_time);
771: g_status:=false;
772: return false;
773: end if;
766: end if;
767: insert_into_load_progress_d(g_load_pk,g_primary_target_name,'Post Mapping Collection Hook',sysdate,null,'HOOK',
768: 'POST-MAP',1070,'I');
769: if EDW_COLLECTION_HOOK.post_mapping_coll(g_primary_target_name)= false then
770: write_to_log_file_n('EDW_COLLECTION_HOOK.post_mapping_coll returned with error.'||get_time);
771: g_status:=false;
772: return false;
773: end if;
774: insert_into_load_progress_d(g_load_pk,null,null,null,sysdate,null,null,1070,'U');
772: return false;
773: end if;
774: insert_into_load_progress_d(g_load_pk,null,null,null,sysdate,null,null,1070,'U');
775: if g_debug then
776: write_to_log_file_n('EDW_COLLECTION_HOOK.post_mapping_coll returned with success.'||get_time);
777: end if;
778: return true;
779: Exception when others then
780: g_status_message:=sqlerrm;
1244: write_to_log_file_n('pre_mapping_coll'||get_time);
1245: end if;
1246: insert_into_load_progress_d(g_load_pk,g_primary_target_name,'Pre Mapping Collection Hook',sysdate,null,'MAPPING',
1247: 'PRE-MAP',1010,'I');
1248: if EDW_COLLECTION_HOOK.pre_mapping_coll(g_primary_target_name)= false then
1249: write_to_log_file_n('EDW_COLLECTION_HOOK.pre_mapping_coll returned with error.'||get_time);
1250: g_status:=false;
1251: p_status:=false;
1252: return;
1245: end if;
1246: insert_into_load_progress_d(g_load_pk,g_primary_target_name,'Pre Mapping Collection Hook',sysdate,null,'MAPPING',
1247: 'PRE-MAP',1010,'I');
1248: if EDW_COLLECTION_HOOK.pre_mapping_coll(g_primary_target_name)= false then
1249: write_to_log_file_n('EDW_COLLECTION_HOOK.pre_mapping_coll returned with error.'||get_time);
1250: g_status:=false;
1251: p_status:=false;
1252: return;
1253: end if;
1250: g_status:=false;
1251: p_status:=false;
1252: return;
1253: end if;
1254: write_to_log_file_n('EDW_COLLECTION_HOOK.pre_mapping_coll returned with success.'||get_time);
1255: insert_into_load_progress_d(g_load_pk,null,null,null,sysdate,null,null,1010,'U');
1256: Init_all(null);
1257: if g_status=false then
1258: p_status:=g_status;