3:
4: -- -------------------------
5: -- Private Package Variables
6: -- -------------------------
7: pc_log_level_statement CONSTANT NUMBER := FND_LOG.level_statement;
8: pc_log_level_procedure CONSTANT NUMBER := FND_LOG.level_procedure;
9: pc_log_level_event CONSTANT NUMBER := FND_LOG.level_event;
10: pc_log_level_exception CONSTANT NUMBER := FND_LOG.level_exception;
11: pc_log_level_error CONSTANT NUMBER := FND_LOG.level_error;
4: -- -------------------------
5: -- Private Package Variables
6: -- -------------------------
7: pc_log_level_statement CONSTANT NUMBER := FND_LOG.level_statement;
8: pc_log_level_procedure CONSTANT NUMBER := FND_LOG.level_procedure;
9: pc_log_level_event CONSTANT NUMBER := FND_LOG.level_event;
10: pc_log_level_exception CONSTANT NUMBER := FND_LOG.level_exception;
11: pc_log_level_error CONSTANT NUMBER := FND_LOG.level_error;
12: pc_log_level_unexpected CONSTANT NUMBER := FND_LOG.level_unexpected;
5: -- Private Package Variables
6: -- -------------------------
7: pc_log_level_statement CONSTANT NUMBER := FND_LOG.level_statement;
8: pc_log_level_procedure CONSTANT NUMBER := FND_LOG.level_procedure;
9: pc_log_level_event CONSTANT NUMBER := FND_LOG.level_event;
10: pc_log_level_exception CONSTANT NUMBER := FND_LOG.level_exception;
11: pc_log_level_error CONSTANT NUMBER := FND_LOG.level_error;
12: pc_log_level_unexpected CONSTANT NUMBER := FND_LOG.level_unexpected;
13:
6: -- -------------------------
7: pc_log_level_statement CONSTANT NUMBER := FND_LOG.level_statement;
8: pc_log_level_procedure CONSTANT NUMBER := FND_LOG.level_procedure;
9: pc_log_level_event CONSTANT NUMBER := FND_LOG.level_event;
10: pc_log_level_exception CONSTANT NUMBER := FND_LOG.level_exception;
11: pc_log_level_error CONSTANT NUMBER := FND_LOG.level_error;
12: pc_log_level_unexpected CONSTANT NUMBER := FND_LOG.level_unexpected;
13:
14: pv_nl VARCHAR2(1);
7: pc_log_level_statement CONSTANT NUMBER := FND_LOG.level_statement;
8: pc_log_level_procedure CONSTANT NUMBER := FND_LOG.level_procedure;
9: pc_log_level_event CONSTANT NUMBER := FND_LOG.level_event;
10: pc_log_level_exception CONSTANT NUMBER := FND_LOG.level_exception;
11: pc_log_level_error CONSTANT NUMBER := FND_LOG.level_error;
12: pc_log_level_unexpected CONSTANT NUMBER := FND_LOG.level_unexpected;
13:
14: pv_nl VARCHAR2(1);
15:
8: pc_log_level_procedure CONSTANT NUMBER := FND_LOG.level_procedure;
9: pc_log_level_event CONSTANT NUMBER := FND_LOG.level_event;
10: pc_log_level_exception CONSTANT NUMBER := FND_LOG.level_exception;
11: pc_log_level_error CONSTANT NUMBER := FND_LOG.level_error;
12: pc_log_level_unexpected CONSTANT NUMBER := FND_LOG.level_unexpected;
13:
14: pv_nl VARCHAR2(1);
15:
16: PRINT_ERROR EXCEPTION;
931: x_retcode := SQLCODE;
932:
933: -- Print the error message to program log file
934: FND_FILE.put_line(FND_FILE.log, x_errbuf);
935: -- Print the error message to FND Log
936: GL_MESSAGE.Write_Fndlog_String(log_level => pc_log_leveL_unexpected,
937: module => v_module,
938: message => x_errbuf);
939:
1008: -- <<< Unexpected database exceptions >>>
1009:
1010: -- Print the error message to program log file
1011: FND_FILE.put_line(FND_FILE.log, SQLERRM);
1012: -- Print the error message to FND Log
1013: GL_MESSAGE.Write_Fndlog_String(log_level => pc_log_leveL_unexpected,
1014: module => v_module,
1015: message => SQLERRM);
1016: -- Log the error exit