349: --l_debug_prefix VARCHAR2(30) := '';
350: BEGIN
351:
352: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
353: hz_utility_v2pub.debug(p_message=>'WRP:CLEANUP_STAGING()+',
354: p_prefix=>'',
355: p_msg_level=>fnd_log.level_procedure);
356: END IF;
357:
414: --DELETE HZ_IMP_INT_DEDUP_RESULTS WHERE batch_id = P_BATCH_ID;
415: DELETE HZ_IMP_TMP_REL_END_DATE WHERE batch_id = P_BATCH_ID;
416:
417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug(p_message=>'WRP:CLEANUP_STAGING()-',
419: p_prefix=>'',
420: p_msg_level=>fnd_log.level_procedure);
421: END IF;
422: COMMIT;
860: -- the lookup.
861:
862: -- validate original_system against lookup ORIG_SYSTEM
863: /*
864: hz_utility_v2pub.validate_lookup (
865: p_column => 'original_system',
866: p_lookup_type => 'ORIG_SYSTEM',
867: p_column_value => r_batch_info.original_system,
868: x_return_status => l_return_status);
981: (p_batch_id,
982: l_current_run,
983: 'PENDING',
984: null,
985: HZ_UTILITY_V2PUB.created_by,
986: HZ_UTILITY_V2PUB.creation_date,
987: HZ_UTILITY_V2PUB.last_updated_by,
988: HZ_UTILITY_V2PUB.last_update_date,
989: HZ_UTILITY_V2PUB.last_update_login,
982: l_current_run,
983: 'PENDING',
984: null,
985: HZ_UTILITY_V2PUB.created_by,
986: HZ_UTILITY_V2PUB.creation_date,
987: HZ_UTILITY_V2PUB.last_updated_by,
988: HZ_UTILITY_V2PUB.last_update_date,
989: HZ_UTILITY_V2PUB.last_update_login,
990: fnd_global.conc_request_id);
983: 'PENDING',
984: null,
985: HZ_UTILITY_V2PUB.created_by,
986: HZ_UTILITY_V2PUB.creation_date,
987: HZ_UTILITY_V2PUB.last_updated_by,
988: HZ_UTILITY_V2PUB.last_update_date,
989: HZ_UTILITY_V2PUB.last_update_login,
990: fnd_global.conc_request_id);
991:
984: null,
985: HZ_UTILITY_V2PUB.created_by,
986: HZ_UTILITY_V2PUB.creation_date,
987: HZ_UTILITY_V2PUB.last_updated_by,
988: HZ_UTILITY_V2PUB.last_update_date,
989: HZ_UTILITY_V2PUB.last_update_login,
990: fnd_global.conc_request_id);
991:
992: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
985: HZ_UTILITY_V2PUB.created_by,
986: HZ_UTILITY_V2PUB.creation_date,
987: HZ_UTILITY_V2PUB.last_updated_by,
988: HZ_UTILITY_V2PUB.last_update_date,
989: HZ_UTILITY_V2PUB.last_update_login,
990: fnd_global.conc_request_id);
991:
992: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
993:
1011: (p_batch_id,
1012: l_current_run,
1013: 'PENDING',
1014: null,
1015: HZ_UTILITY_V2PUB.created_by,
1016: HZ_UTILITY_V2PUB.creation_date,
1017: HZ_UTILITY_V2PUB.last_updated_by,
1018: HZ_UTILITY_V2PUB.last_update_date,
1019: HZ_UTILITY_V2PUB.last_update_login,
1012: l_current_run,
1013: 'PENDING',
1014: null,
1015: HZ_UTILITY_V2PUB.created_by,
1016: HZ_UTILITY_V2PUB.creation_date,
1017: HZ_UTILITY_V2PUB.last_updated_by,
1018: HZ_UTILITY_V2PUB.last_update_date,
1019: HZ_UTILITY_V2PUB.last_update_login,
1020: fnd_global.conc_request_id);
1013: 'PENDING',
1014: null,
1015: HZ_UTILITY_V2PUB.created_by,
1016: HZ_UTILITY_V2PUB.creation_date,
1017: HZ_UTILITY_V2PUB.last_updated_by,
1018: HZ_UTILITY_V2PUB.last_update_date,
1019: HZ_UTILITY_V2PUB.last_update_login,
1020: fnd_global.conc_request_id);
1021:
1014: null,
1015: HZ_UTILITY_V2PUB.created_by,
1016: HZ_UTILITY_V2PUB.creation_date,
1017: HZ_UTILITY_V2PUB.last_updated_by,
1018: HZ_UTILITY_V2PUB.last_update_date,
1019: HZ_UTILITY_V2PUB.last_update_login,
1020: fnd_global.conc_request_id);
1021:
1022: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
1015: HZ_UTILITY_V2PUB.created_by,
1016: HZ_UTILITY_V2PUB.creation_date,
1017: HZ_UTILITY_V2PUB.last_updated_by,
1018: HZ_UTILITY_V2PUB.last_update_date,
1019: HZ_UTILITY_V2PUB.last_update_login,
1020: fnd_global.conc_request_id);
1021:
1022: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
1023: