113: FND_MSG_PUB.initialize;
114: END IF;
115:
116: -- Debug info.
117: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
118: hz_utility_v2pub.debug(p_message=>'get_orig_sys_ref_objs(+)',
119: p_prefix=>l_debug_prefix,
120: p_msg_level=>fnd_log.level_procedure);
121: END IF;
116: -- Debug info.
117: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
118: hz_utility_v2pub.debug(p_message=>'get_orig_sys_ref_objs(+)',
119: p_prefix=>l_debug_prefix,
120: p_msg_level=>fnd_log.level_procedure);
121: END IF;
122:
123:
124: x_orig_sys_ref_objs := HZ_ORIG_SYS_REF_OBJ_TBL();
127: fetch c1 BULK COLLECT into x_orig_sys_ref_objs;
128: close c1;
129:
130: -- Debug info.
131: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
132: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
133: p_msg_data=>x_msg_data,
134: p_msg_type=>'WARNING',
135: p_msg_level=>fnd_log.level_exception);
131: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
132: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
133: p_msg_data=>x_msg_data,
134: p_msg_type=>'WARNING',
135: p_msg_level=>fnd_log.level_exception);
136: END IF;
137:
138: -- Debug info.
139: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
135: p_msg_level=>fnd_log.level_exception);
136: END IF;
137:
138: -- Debug info.
139: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
140: hz_utility_v2pub.debug(p_message=>'get_orig_sys_ref_objs(-)',
141: p_prefix=>l_debug_prefix,
142: p_msg_level=>fnd_log.level_procedure);
143: END IF;
138: -- Debug info.
139: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
140: hz_utility_v2pub.debug(p_message=>'get_orig_sys_ref_objs(-)',
141: p_prefix=>l_debug_prefix,
142: p_msg_level=>fnd_log.level_procedure);
143: END IF;
144:
145:
146: EXCEPTION
155: p_count => x_msg_count,
156: p_data => x_msg_data);
157:
158: -- Debug info.
159: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
160: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
161: p_msg_data=>x_msg_data,
162: p_msg_type=>'SQL ERROR',
163: p_msg_level=>fnd_log.level_error);
159: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
160: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
161: p_msg_data=>x_msg_data,
162: p_msg_type=>'SQL ERROR',
163: p_msg_level=>fnd_log.level_error);
164: END IF;
165: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
166: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
167: p_prefix=>l_debug_prefix,
161: p_msg_data=>x_msg_data,
162: p_msg_type=>'SQL ERROR',
163: p_msg_level=>fnd_log.level_error);
164: END IF;
165: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
166: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
167: p_prefix=>l_debug_prefix,
168: p_msg_level=>fnd_log.level_procedure);
169: END IF;
164: END IF;
165: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
166: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
167: p_prefix=>l_debug_prefix,
168: p_msg_level=>fnd_log.level_procedure);
169: END IF;
170:
171: end;
172: