149: BEGIN
150:
151: -- Debug info.
152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
153: hz_utility_v2pub.debug(p_message=>'validate_parent_id(+)',
154: p_prefix=>l_debug_prefix,
155: p_msg_level=>fnd_log.level_procedure);
156: END IF;
157:
258: p_data => x_msg_data);
259:
260: -- Debug info.
261: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
262: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
263: p_msg_data=>x_msg_data,
264: p_msg_type=>'ERROR',
265: p_msg_level=>fnd_log.level_error);
266: END IF;
264: p_msg_type=>'ERROR',
265: p_msg_level=>fnd_log.level_error);
266: END IF;
267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
268: hz_utility_v2pub.debug(p_message=>'validate_parent_id(-)',
269: p_prefix=>l_debug_prefix,
270: p_msg_level=>fnd_log.level_procedure);
271: END IF;
272: WHEN fnd_api.g_exc_unexpected_error THEN
277: p_data => x_msg_data);
278:
279: -- Debug info.
280: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
281: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
282: p_msg_data=>x_msg_data,
283: p_msg_type=>'UNEXPECTED ERROR',
284: p_msg_level=>fnd_log.level_error);
285: END IF;
283: p_msg_type=>'UNEXPECTED ERROR',
284: p_msg_level=>fnd_log.level_error);
285: END IF;
286: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
287: hz_utility_v2pub.debug(p_message=>'validate_parent_id(-)',
288: p_prefix=>l_debug_prefix,
289: p_msg_level=>fnd_log.level_procedure);
290: END IF;
291:
301: p_data => x_msg_data);
302:
303: -- Debug info.
304: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
305: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
306: p_msg_data=>x_msg_data,
307: p_msg_type=>'SQL ERROR',
308: p_msg_level=>fnd_log.level_error);
309: END IF;
307: p_msg_type=>'SQL ERROR',
308: p_msg_level=>fnd_log.level_error);
309: END IF;
310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
311: hz_utility_v2pub.debug(p_message=>'validate_parent_id(-)',
312: p_prefix=>l_debug_prefix,
313: p_msg_level=>fnd_log.level_procedure);
314: END IF;
315: END validate_parent_id;
414: l_obj_type VARCHAR2(30);
415: BEGIN
416: -- Debug info.
417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(+)',
419: p_prefix=>l_debug_prefix,
420: p_msg_level=>fnd_log.level_procedure);
421: END IF;
422:
577: p_data => x_msg_data);
578:
579: -- Debug info.
580: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
582: p_msg_data=>x_msg_data,
583: p_msg_type=>'ERROR',
584: p_msg_level=>fnd_log.level_error);
585: END IF;
583: p_msg_type=>'ERROR',
584: p_msg_level=>fnd_log.level_error);
585: END IF;
586: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
587: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
588: p_prefix=>l_debug_prefix,
589: p_msg_level=>fnd_log.level_procedure);
590: END IF;
591: WHEN fnd_api.g_exc_unexpected_error THEN
596: p_data => x_msg_data);
597:
598: -- Debug info.
599: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
601: p_msg_data=>x_msg_data,
602: p_msg_type=>'UNEXPECTED ERROR',
603: p_msg_level=>fnd_log.level_error);
604: END IF;
602: p_msg_type=>'UNEXPECTED ERROR',
603: p_msg_level=>fnd_log.level_error);
604: END IF;
605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
606: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
607: p_prefix=>l_debug_prefix,
608: p_msg_level=>fnd_log.level_procedure);
609: END IF;
610: WHEN OTHERS THEN
619: p_data => x_msg_data);
620:
621: -- Debug info.
622: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
623: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
624: p_msg_data=>x_msg_data,
625: p_msg_type=>'SQL ERROR',
626: p_msg_level=>fnd_log.level_error);
627: END IF;
625: p_msg_type=>'SQL ERROR',
626: p_msg_level=>fnd_log.level_error);
627: END IF;
628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
629: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
630: p_prefix=>l_debug_prefix,
631: p_msg_level=>fnd_log.level_procedure);
632: END IF;
633: END validate_ssm_id;