142: p_full_path IN VARCHAR2
143: )
144: IS
145: BEGIN
146: fnd_message.set_name('PSA','PSA_LOGGING_USER_ERROR');
147: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
148: IF (g_unexp_level >= g_debug_level) THEN
149: fnd_message.set_name('PSA','PSA_LOGGING_UNEXP_ERROR');
150: fnd_message.set_token('CODE',SQLCODE);
143: )
144: IS
145: BEGIN
146: fnd_message.set_name('PSA','PSA_LOGGING_USER_ERROR');
147: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
148: IF (g_unexp_level >= g_debug_level) THEN
149: fnd_message.set_name('PSA','PSA_LOGGING_UNEXP_ERROR');
150: fnd_message.set_token('CODE',SQLCODE);
151: fnd_message.set_token('MSG', SQLERRM);
145: BEGIN
146: fnd_message.set_name('PSA','PSA_LOGGING_USER_ERROR');
147: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
148: IF (g_unexp_level >= g_debug_level) THEN
149: fnd_message.set_name('PSA','PSA_LOGGING_UNEXP_ERROR');
150: fnd_message.set_token('CODE',SQLCODE);
151: fnd_message.set_token('MSG', SQLERRM);
152: fnd_log.message (g_unexp_level,p_full_path, TRUE);
153: END IF;
146: fnd_message.set_name('PSA','PSA_LOGGING_USER_ERROR');
147: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
148: IF (g_unexp_level >= g_debug_level) THEN
149: fnd_message.set_name('PSA','PSA_LOGGING_UNEXP_ERROR');
150: fnd_message.set_token('CODE',SQLCODE);
151: fnd_message.set_token('MSG', SQLERRM);
152: fnd_log.message (g_unexp_level,p_full_path, TRUE);
153: END IF;
154: END debug_unexpected_msg;
147: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
148: IF (g_unexp_level >= g_debug_level) THEN
149: fnd_message.set_name('PSA','PSA_LOGGING_UNEXP_ERROR');
150: fnd_message.set_token('CODE',SQLCODE);
151: fnd_message.set_token('MSG', SQLERRM);
152: fnd_log.message (g_unexp_level,p_full_path, TRUE);
153: END IF;
154: END debug_unexpected_msg;
155: