DBA Data[Home] [Help]

APPS.JA_CN_GSSM_EXP_PKG dependencies on FND_LOG

Line 47: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

43: PROCEDURE GSSM_Export( errbuf OUT NOCOPY VARCHAR2
44: ,retcode OUT NOCOPY VARCHAR2
45: ,P_GSSM_TYPE IN VARCHAR2
46: ) IS
47: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
48: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
49: l_proc_name VARCHAR2(100) :='GSSM_Export';
50:
51: JA_CN_NO_DATA_FOUND exception;

Line 48: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

44: ,retcode OUT NOCOPY VARCHAR2
45: ,P_GSSM_TYPE IN VARCHAR2
46: ) IS
47: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
48: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
49: l_proc_name VARCHAR2(100) :='GSSM_Export';
50:
51: JA_CN_NO_DATA_FOUND exception;
52: l_msg_no_data_found varchar2(2000); --'*****No data found*****';

Line 86: FND_LOG.String( l_proc_level

82: BEGIN
83: --log for debug
84: IF (l_proc_level >= l_dbg_level)
85: THEN
86: FND_LOG.String( l_proc_level
87: ,l_module_prefix||'.'||l_proc_name||'.begin'
88: ,'Enter procedure'
89: );
90: FND_LOG.String( l_proc_level

Line 90: FND_LOG.String( l_proc_level

86: FND_LOG.String( l_proc_level
87: ,l_module_prefix||'.'||l_proc_name||'.begin'
88: ,'Enter procedure'
89: );
90: FND_LOG.String( l_proc_level
91: ,l_module_prefix||'.'||l_proc_name||'.parameters'
92: ,'P_GSSM_TYPE '||P_GSSM_TYPE
93: );
94: END IF; --(l_proc_level >= l_dbg_level)

Line 143: FND_LOG.String( l_proc_level

139:
140: --FND_FILE.put_line(FND_FILE.output, l_msg_no_data_found);
141: IF (l_proc_level >= l_dbg_level)
142: THEN
143: FND_LOG.String( l_proc_level
144: ,l_module_prefix||'.'||l_proc_name||'.JA_CN_NO_DATA_FOUND '
145: ,l_msg_no_data_found);
146: END IF;
147: retcode := 1;

Line 152: FND_LOG.String( l_proc_level

148: errbuf := l_msg_no_data_found;
149: WHEN OTHERS THEN
150: IF (l_proc_level >= l_dbg_level)
151: THEN
152: FND_LOG.String( l_proc_level
153: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
154: ,SQLCODE||':'||SQLERRM
155: );
156: END IF; --(l_proc_level >= l_dbg_level)