92: And application_id = (Select application_id
93: From fnd_application
94: Where application_short_name = 'SQLGL');
95:
96: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
97: l_state_level number := FND_LOG.LEVEL_STATEMENT;
98: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
99: l_event_level number := FND_LOG.LEVEL_EVENT;
100: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
93: From fnd_application
94: Where application_short_name = 'SQLGL');
95:
96: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
97: l_state_level number := FND_LOG.LEVEL_STATEMENT;
98: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
99: l_event_level number := FND_LOG.LEVEL_EVENT;
100: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
101: l_error_level number := FND_LOG.LEVEL_ERROR;
94: Where application_short_name = 'SQLGL');
95:
96: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
97: l_state_level number := FND_LOG.LEVEL_STATEMENT;
98: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
99: l_event_level number := FND_LOG.LEVEL_EVENT;
100: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
101: l_error_level number := FND_LOG.LEVEL_ERROR;
102: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
95:
96: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
97: l_state_level number := FND_LOG.LEVEL_STATEMENT;
98: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
99: l_event_level number := FND_LOG.LEVEL_EVENT;
100: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
101: l_error_level number := FND_LOG.LEVEL_ERROR;
102: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
103:
96: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
97: l_state_level number := FND_LOG.LEVEL_STATEMENT;
98: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
99: l_event_level number := FND_LOG.LEVEL_EVENT;
100: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
101: l_error_level number := FND_LOG.LEVEL_ERROR;
102: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
103:
104: Procedure Writelog(
97: l_state_level number := FND_LOG.LEVEL_STATEMENT;
98: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
99: l_event_level number := FND_LOG.LEVEL_EVENT;
100: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
101: l_error_level number := FND_LOG.LEVEL_ERROR;
102: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
103:
104: Procedure Writelog(
105: p_mesg IN varchar2,
98: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
99: l_event_level number := FND_LOG.LEVEL_EVENT;
100: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
101: l_error_level number := FND_LOG.LEVEL_ERROR;
102: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
103:
104: Procedure Writelog(
105: p_mesg IN varchar2,
106: p_debug_mode IN boolean ) IS
619: IF ( l_unexp_level >= l_debug_level) THEN
620: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
621: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
622: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
623: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Create_Actuals.msg1',TRUE);
624: END IF;
625: End If;
626: APP_EXCEPTION.RAISE_EXCEPTION;
627: End Create_Actuals ;
667: IF ( l_unexp_level >= l_debug_level) THEN
668: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
669: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
670: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
671: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Init_Gl_Interface.msg2',TRUE);
672: END IF;
673: End If;
674: APP_EXCEPTION.RAISE_EXCEPTION;
675: End Init_Gl_Interface;
706: IF ( l_unexp_level >= l_debug_level) THEN
707: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
708: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
709: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
710: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Insert_Control_Rec.msg3',TRUE);
711: END IF;
712: EnD If;
713: APP_EXCEPTION.RAISE_EXCEPTION;
714: End Insert_Control_Rec;
834: IF ( l_unexp_level >= l_debug_level) THEN
835: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
836: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
837: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
838: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Gl_Interface_Insert.msg4',TRUE);
839: END IF;
840: End If;
841: APP_EXCEPTION.RAISE_EXCEPTION;
842: End Gl_Interface_Insert;