3274: RAISE;
3275: END;
3276:
3277: IF (g_fnd_debug = 'Y') THEN
3278: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3279: FND_LOG.string( log_level => FND_LOG.LEVEL_STATEMENT,
3280: module => g_module_prefix || l_proc_name,
3281: message => 'Amount threshold: ' || l_amount_threshold
3282: || '; Completion threshold: '
3275: END;
3276:
3277: IF (g_fnd_debug = 'Y') THEN
3278: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3279: FND_LOG.string( log_level => FND_LOG.LEVEL_STATEMENT,
3280: module => g_module_prefix || l_proc_name,
3281: message => 'Amount threshold: ' || l_amount_threshold
3282: || '; Completion threshold: '
3283: || l_completion_threshold );
3368: WHEN OTHERS THEN
3369: IF (g_fnd_debug = 'Y') THEN
3370: FND_MSG_PUB.Build_Exc_Msg ( p_pkg_name => g_pkg_name,
3371: p_procedure_name => l_proc_name );
3372: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3373: FND_LOG.string( log_level => FND_LOG.LEVEL_UNEXPECTED,
3374: module => g_module_prefix || l_proc_name,
3375: message => FND_MESSAGE.get );
3376: END IF;
3369: IF (g_fnd_debug = 'Y') THEN
3370: FND_MSG_PUB.Build_Exc_Msg ( p_pkg_name => g_pkg_name,
3371: p_procedure_name => l_proc_name );
3372: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3373: FND_LOG.string( log_level => FND_LOG.LEVEL_UNEXPECTED,
3374: module => g_module_prefix || l_proc_name,
3375: message => FND_MESSAGE.get );
3376: END IF;
3377: END IF;
3424: x_username => l_requester_user_name,
3425: x_user_display_name => l_requester_disp_name );
3426:
3427: IF (g_fnd_debug = 'Y') THEN
3428: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT) THEN
3429: FND_LOG.string( log_level => FND_LOG.LEVEL_EVENT,
3430: module => g_module_prefix || l_proc_name,
3431: message => 'Launching the reminder workflow:'
3432: || ' item key: ' || l_item_key
3425: x_user_display_name => l_requester_disp_name );
3426:
3427: IF (g_fnd_debug = 'Y') THEN
3428: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT) THEN
3429: FND_LOG.string( log_level => FND_LOG.LEVEL_EVENT,
3430: module => g_module_prefix || l_proc_name,
3431: message => 'Launching the reminder workflow:'
3432: || ' item key: ' || l_item_key
3433: || ', requester ID: ' || p_requester_id
3575: WHEN OTHERS THEN
3576: IF (g_fnd_debug = 'Y') THEN
3577: FND_MSG_PUB.Build_Exc_Msg ( p_pkg_name => g_pkg_name,
3578: p_procedure_name => l_proc_name );
3579: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3580: FND_LOG.string( log_level => FND_LOG.LEVEL_UNEXPECTED,
3581: module => g_module_prefix || l_proc_name,
3582: message => FND_MESSAGE.get );
3583: END IF;
3576: IF (g_fnd_debug = 'Y') THEN
3577: FND_MSG_PUB.Build_Exc_Msg ( p_pkg_name => g_pkg_name,
3578: p_procedure_name => l_proc_name );
3579: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3580: FND_LOG.string( log_level => FND_LOG.LEVEL_UNEXPECTED,
3581: module => g_module_prefix || l_proc_name,
3582: message => FND_MESSAGE.get );
3583: END IF;
3584: END IF;