345: return(is_rule_processed);
346:
347: exception
348: when others then
349: fnd_message.set_name ('FND', 'SQL-Generic error');
350: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
351: fnd_message.set_token ('REASON', sqlerrm, FALSE);
352: fnd_message.set_token ('ROUTINE', 'FND_DEBUG.ENABLE_DB_RULES', FALSE);
353: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
346:
347: exception
348: when others then
349: fnd_message.set_name ('FND', 'SQL-Generic error');
350: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
351: fnd_message.set_token ('REASON', sqlerrm, FALSE);
352: fnd_message.set_token ('ROUTINE', 'FND_DEBUG.ENABLE_DB_RULES', FALSE);
353: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
354: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
347: exception
348: when others then
349: fnd_message.set_name ('FND', 'SQL-Generic error');
350: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
351: fnd_message.set_token ('REASON', sqlerrm, FALSE);
352: fnd_message.set_token ('ROUTINE', 'FND_DEBUG.ENABLE_DB_RULES', FALSE);
353: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
354: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
355: 'fnd.plsql.FND_DEBUG.ENABLE_DB_RULES.others',
348: when others then
349: fnd_message.set_name ('FND', 'SQL-Generic error');
350: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
351: fnd_message.set_token ('REASON', sqlerrm, FALSE);
352: fnd_message.set_token ('ROUTINE', 'FND_DEBUG.ENABLE_DB_RULES', FALSE);
353: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
354: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
355: 'fnd.plsql.FND_DEBUG.ENABLE_DB_RULES.others',
356: FALSE);
395: return is_rule_processed;
396:
397: exception
398: when others then
399: fnd_message.set_name ('FND', 'SQL-Generic error');
400: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
401: fnd_message.set_token ('REASON', sqlerrm, FALSE);
402: fnd_message.set_token ('ROUTINE', 'FND_DEBUG.DISABLE_DB_RULES', FALSE);
403: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
396:
397: exception
398: when others then
399: fnd_message.set_name ('FND', 'SQL-Generic error');
400: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
401: fnd_message.set_token ('REASON', sqlerrm, FALSE);
402: fnd_message.set_token ('ROUTINE', 'FND_DEBUG.DISABLE_DB_RULES', FALSE);
403: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
404: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
397: exception
398: when others then
399: fnd_message.set_name ('FND', 'SQL-Generic error');
400: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
401: fnd_message.set_token ('REASON', sqlerrm, FALSE);
402: fnd_message.set_token ('ROUTINE', 'FND_DEBUG.DISABLE_DB_RULES', FALSE);
403: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
404: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
405: 'fnd.plsql.FND_DEBUG.DISABLE_DB_RULES.others',
398: when others then
399: fnd_message.set_name ('FND', 'SQL-Generic error');
400: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
401: fnd_message.set_token ('REASON', sqlerrm, FALSE);
402: fnd_message.set_token ('ROUTINE', 'FND_DEBUG.DISABLE_DB_RULES', FALSE);
403: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
404: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
405: 'fnd.plsql.FND_DEBUG.DISABLE_DB_RULES.others',
406: FALSE);
631: return ltrim(rtrim(debug_str));
632:
633: exception
634: when others then
635: fnd_message.set_name ('FND', 'SQL-Generic error');
636: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
637: fnd_message.set_token ('REASON', sqlerrm, FALSE);
638: fnd_message.set_token (
639: 'ROUTINE', 'FND_DEBUG.GET_OS_RULES', FALSE);
632:
633: exception
634: when others then
635: fnd_message.set_name ('FND', 'SQL-Generic error');
636: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
637: fnd_message.set_token ('REASON', sqlerrm, FALSE);
638: fnd_message.set_token (
639: 'ROUTINE', 'FND_DEBUG.GET_OS_RULES', FALSE);
640: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
633: exception
634: when others then
635: fnd_message.set_name ('FND', 'SQL-Generic error');
636: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
637: fnd_message.set_token ('REASON', sqlerrm, FALSE);
638: fnd_message.set_token (
639: 'ROUTINE', 'FND_DEBUG.GET_OS_RULES', FALSE);
640: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
641: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
634: when others then
635: fnd_message.set_name ('FND', 'SQL-Generic error');
636: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
637: fnd_message.set_token ('REASON', sqlerrm, FALSE);
638: fnd_message.set_token (
639: 'ROUTINE', 'FND_DEBUG.GET_OS_RULES', FALSE);
640: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
641: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
642: 'fnd.plsql.FND_DEBUG.GET_OS_RULES.others', FALSE);
763: commit;
764:
765: exception
766: when others then
767: fnd_message.set_name ('FND', 'SQL-Generic error');
768: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
769: fnd_message.set_token ('REASON', sqlerrm, FALSE);
770: fnd_message.set_token (
771: 'ROUTINE', 'FND_DEBUG.ASSIGN_REQUEST', FALSE);
764:
765: exception
766: when others then
767: fnd_message.set_name ('FND', 'SQL-Generic error');
768: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
769: fnd_message.set_token ('REASON', sqlerrm, FALSE);
770: fnd_message.set_token (
771: 'ROUTINE', 'FND_DEBUG.ASSIGN_REQUEST', FALSE);
772: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
765: exception
766: when others then
767: fnd_message.set_name ('FND', 'SQL-Generic error');
768: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
769: fnd_message.set_token ('REASON', sqlerrm, FALSE);
770: fnd_message.set_token (
771: 'ROUTINE', 'FND_DEBUG.ASSIGN_REQUEST', FALSE);
772: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
773: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
766: when others then
767: fnd_message.set_name ('FND', 'SQL-Generic error');
768: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
769: fnd_message.set_token ('REASON', sqlerrm, FALSE);
770: fnd_message.set_token (
771: 'ROUTINE', 'FND_DEBUG.ASSIGN_REQUEST', FALSE);
772: IF (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) THEN
773: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
774: 'fnd.plsql.FND_DEBUG.ASSIGN_REQUEST.others', FALSE);