17: /* ====================== DEBUG_UNEXPECTED_MSG ===================== */
18:
19: PROCEDURE debug_unexpected_msg(p_full_path IN VARCHAR2) IS
20: BEGIN
21: FND_MESSAGE.SET_NAME('PSA','PSA_LOGGING_USER_ERROR');
22: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
23: IF (g_unexp_level >= g_debug_level) THEN
24: FND_MESSAGE.SET_NAME('PSA','PSA_LOGGING_UNEXP_ERROR');
25: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
18:
19: PROCEDURE debug_unexpected_msg(p_full_path IN VARCHAR2) IS
20: BEGIN
21: FND_MESSAGE.SET_NAME('PSA','PSA_LOGGING_USER_ERROR');
22: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
23: IF (g_unexp_level >= g_debug_level) THEN
24: FND_MESSAGE.SET_NAME('PSA','PSA_LOGGING_UNEXP_ERROR');
25: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
26: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
20: BEGIN
21: FND_MESSAGE.SET_NAME('PSA','PSA_LOGGING_USER_ERROR');
22: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
23: IF (g_unexp_level >= g_debug_level) THEN
24: FND_MESSAGE.SET_NAME('PSA','PSA_LOGGING_UNEXP_ERROR');
25: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
26: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
27: FND_LOG.MESSAGE (g_unexp_level,p_full_path, TRUE);
28: END IF;
21: FND_MESSAGE.SET_NAME('PSA','PSA_LOGGING_USER_ERROR');
22: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
23: IF (g_unexp_level >= g_debug_level) THEN
24: FND_MESSAGE.SET_NAME('PSA','PSA_LOGGING_UNEXP_ERROR');
25: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
26: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
27: FND_LOG.MESSAGE (g_unexp_level,p_full_path, TRUE);
28: END IF;
29:
22: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
23: IF (g_unexp_level >= g_debug_level) THEN
24: FND_MESSAGE.SET_NAME('PSA','PSA_LOGGING_UNEXP_ERROR');
25: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
26: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
27: FND_LOG.MESSAGE (g_unexp_level,p_full_path, TRUE);
28: END IF;
29:
30: END debug_unexpected_msg;