524: l_status VARCHAR2(1);
525: l_debug_prefix VARCHAR2(30) := '';
526: begin
527:
528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
529: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_orig_sys_reference (+)',
530: p_msg_level=>fnd_log.level_procedure);
531: END IF;
532: --Initialize API return status to success.
526: begin
527:
528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
529: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_orig_sys_reference (+)',
530: p_msg_level=>fnd_log.level_procedure);
531: END IF;
532: --Initialize API return status to success.
533: x_return_status := FND_API.G_RET_STS_SUCCESS;
534:
616: THEN*/
617: select party_type into l_dummy
618: from hz_parties
619: where party_id = p_orig_sys_reference_rec.owner_table_id ;
620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'DQM Sync Mode '||p_orig_sys_reference_rec.dqm_sync_mode,
622: p_msg_level=>fnd_log.level_statement);
623: END IF;
624: --Bug13117445
618: from hz_parties
619: where party_id = p_orig_sys_reference_rec.owner_table_id ;
620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'DQM Sync Mode '||p_orig_sys_reference_rec.dqm_sync_mode,
622: p_msg_level=>fnd_log.level_statement);
623: END IF;
624: --Bug13117445
625: IF l_dummy = 'ORGANIZATION'
626: THEN
692: END;
693:
694: END IF;
695:
696: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
697: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_orig_sys_reference (-)',
698: p_msg_level=>fnd_log.level_procedure);
699: END IF;
700:
694: END IF;
695:
696: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
697: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_orig_sys_reference (-)',
698: p_msg_level=>fnd_log.level_procedure);
699: END IF;
700:
701:
702: end do_create_orig_sys_reference;