321: l_msg_count_after := NVL(fnd_msg_pub.Count_Msg,0);
322: x_msg_count := l_msg_count_after;
323: x_return_status := l_status;
324:
325: -- FND Logging for debug purpose
326: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
327: hz_utility_v2pub.debug
328: (p_message => 'After HZ_GNR_PKG.validateLoc. l_msg_count_before:'||
329: l_msg_count_before||':l_msg_count_after:'||l_msg_count_after||
322: x_msg_count := l_msg_count_after;
323: x_return_status := l_status;
324:
325: -- FND Logging for debug purpose
326: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
327: hz_utility_v2pub.debug
328: (p_message => 'After HZ_GNR_PKG.validateLoc. l_msg_count_before:'||
329: l_msg_count_before||':l_msg_count_after:'||l_msg_count_after||
330: ':x_return_status:'||x_return_status||':x_addr_val_status:'||
329: l_msg_count_before||':l_msg_count_after:'||l_msg_count_after||
330: ':x_return_status:'||x_return_status||':x_addr_val_status:'||
331: x_addr_val_status,
332: p_prefix => l_debug_prefix,
333: p_msg_level => fnd_log.level_statement,
334: p_module_prefix => l_module_prefix,
335: p_module => l_module
336: );
337: END IF;
361: IF (x_addr_val_status IS NULL) THEN
362: x_addr_val_status := l_status;
363: END IF;
364:
365: -- FND Logging for debug purpose
366: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
367: hz_utility_v2pub.debug
368: (p_message => 'l_status:'||l_status||':x_msg_data:'||x_msg_data,
369: p_prefix => l_debug_prefix,
362: x_addr_val_status := l_status;
363: END IF;
364:
365: -- FND Logging for debug purpose
366: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
367: hz_utility_v2pub.debug
368: (p_message => 'l_status:'||l_status||':x_msg_data:'||x_msg_data,
369: p_prefix => l_debug_prefix,
370: p_msg_level => fnd_log.level_statement,
366: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
367: hz_utility_v2pub.debug
368: (p_message => 'l_status:'||l_status||':x_msg_data:'||x_msg_data,
369: p_prefix => l_debug_prefix,
370: p_msg_level => fnd_log.level_statement,
371: p_module_prefix => l_module_prefix,
372: p_module => l_module
373: );
374: END IF;
401: p_data => x_msg_data );
402:
403: END IF;
404:
405: -- FND Logging for debug purpose
406: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
407: hz_utility_v2pub.debug
408: (p_message => 'EXCEPTION :'||SQLERRM,
409: p_prefix => l_debug_prefix,
402:
403: END IF;
404:
405: -- FND Logging for debug purpose
406: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
407: hz_utility_v2pub.debug
408: (p_message => 'EXCEPTION :'||SQLERRM,
409: p_prefix => l_debug_prefix,
410: p_msg_level => fnd_log.level_exception,
406: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
407: hz_utility_v2pub.debug
408: (p_message => 'EXCEPTION :'||SQLERRM,
409: p_prefix => l_debug_prefix,
410: p_msg_level => fnd_log.level_exception,
411: p_module_prefix => l_module_prefix,
412: p_module => l_module
413: );
414: END IF;