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;
858: -- the lookup.
859:
860: -- validate original_system against lookup ORIG_SYSTEM
861: /*
862: hz_utility_v2pub.validate_lookup (
863: p_column => 'original_system',
864: p_lookup_type => 'ORIG_SYSTEM',
865: p_column_value => r_batch_info.original_system,
866: x_return_status => l_return_status);
979: (p_batch_id,
980: l_current_run,
981: 'PENDING',
982: null,
983: HZ_UTILITY_V2PUB.created_by,
984: HZ_UTILITY_V2PUB.creation_date,
985: HZ_UTILITY_V2PUB.last_updated_by,
986: HZ_UTILITY_V2PUB.last_update_date,
987: HZ_UTILITY_V2PUB.last_update_login,
980: l_current_run,
981: 'PENDING',
982: null,
983: HZ_UTILITY_V2PUB.created_by,
984: HZ_UTILITY_V2PUB.creation_date,
985: HZ_UTILITY_V2PUB.last_updated_by,
986: HZ_UTILITY_V2PUB.last_update_date,
987: HZ_UTILITY_V2PUB.last_update_login,
988: fnd_global.conc_request_id);
981: 'PENDING',
982: null,
983: HZ_UTILITY_V2PUB.created_by,
984: HZ_UTILITY_V2PUB.creation_date,
985: HZ_UTILITY_V2PUB.last_updated_by,
986: HZ_UTILITY_V2PUB.last_update_date,
987: HZ_UTILITY_V2PUB.last_update_login,
988: fnd_global.conc_request_id);
989:
982: null,
983: HZ_UTILITY_V2PUB.created_by,
984: HZ_UTILITY_V2PUB.creation_date,
985: HZ_UTILITY_V2PUB.last_updated_by,
986: HZ_UTILITY_V2PUB.last_update_date,
987: HZ_UTILITY_V2PUB.last_update_login,
988: fnd_global.conc_request_id);
989:
990: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
983: HZ_UTILITY_V2PUB.created_by,
984: HZ_UTILITY_V2PUB.creation_date,
985: HZ_UTILITY_V2PUB.last_updated_by,
986: HZ_UTILITY_V2PUB.last_update_date,
987: HZ_UTILITY_V2PUB.last_update_login,
988: fnd_global.conc_request_id);
989:
990: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
991:
1009: (p_batch_id,
1010: l_current_run,
1011: 'PENDING',
1012: null,
1013: HZ_UTILITY_V2PUB.created_by,
1014: HZ_UTILITY_V2PUB.creation_date,
1015: HZ_UTILITY_V2PUB.last_updated_by,
1016: HZ_UTILITY_V2PUB.last_update_date,
1017: HZ_UTILITY_V2PUB.last_update_login,
1010: l_current_run,
1011: 'PENDING',
1012: null,
1013: HZ_UTILITY_V2PUB.created_by,
1014: HZ_UTILITY_V2PUB.creation_date,
1015: HZ_UTILITY_V2PUB.last_updated_by,
1016: HZ_UTILITY_V2PUB.last_update_date,
1017: HZ_UTILITY_V2PUB.last_update_login,
1018: fnd_global.conc_request_id);
1011: 'PENDING',
1012: null,
1013: HZ_UTILITY_V2PUB.created_by,
1014: HZ_UTILITY_V2PUB.creation_date,
1015: HZ_UTILITY_V2PUB.last_updated_by,
1016: HZ_UTILITY_V2PUB.last_update_date,
1017: HZ_UTILITY_V2PUB.last_update_login,
1018: fnd_global.conc_request_id);
1019:
1012: null,
1013: HZ_UTILITY_V2PUB.created_by,
1014: HZ_UTILITY_V2PUB.creation_date,
1015: HZ_UTILITY_V2PUB.last_updated_by,
1016: HZ_UTILITY_V2PUB.last_update_date,
1017: HZ_UTILITY_V2PUB.last_update_login,
1018: fnd_global.conc_request_id);
1019:
1020: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
1013: HZ_UTILITY_V2PUB.created_by,
1014: HZ_UTILITY_V2PUB.creation_date,
1015: HZ_UTILITY_V2PUB.last_updated_by,
1016: HZ_UTILITY_V2PUB.last_update_date,
1017: HZ_UTILITY_V2PUB.last_update_login,
1018: fnd_global.conc_request_id);
1019:
1020: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
1021: