APPS.OKC_TERMS_TMPL_APPROVAL_GRP dependencies on FND_LOG

Line 34: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

30: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
31: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
32: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;
33:
34: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
35: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
36: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
37:
38:

Line 35: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

31: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
32: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;
33:
34: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
35: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
36: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
37:
38:
39: ---------------------------------------------------------------------------

Line 36: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

32: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;
33:
34: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
35: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
36: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
37:
38:
39: ---------------------------------------------------------------------------
40: -- Procedure start_approval

Line 112: FND_LOG.STRING(G_PROC_LEVEL,

108: okc_debug.log('100: Entered OKC_TERMS_TMPL_APPROVAL_GRP.start_approval', 2);
109: END IF;*/
110:
111: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
112: FND_LOG.STRING(G_PROC_LEVEL,
113: G_PKG_NAME, '100: Entered OKC_TERMS_TMPL_APPROVAL_GRP.start_approval' );
114: END IF;
115:
116: -- Standard Start of API savepoint

Line 138: FND_LOG.STRING(G_PROC_LEVEL,

134: okc_debug.log('200: opening tmpl_csr', 2);
135: END IF;*/
136:
137: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
138: FND_LOG.STRING(G_PROC_LEVEL,
139: G_PKG_NAME, '200: opening tmpl_csr' );
140: END IF;
141:
142: -- Calling Template Apporval PVT API

Line 152: FND_LOG.STRING(G_PROC_LEVEL,

148: Okc_Debug.Log('300: - attribute TEMPLATE_ID is invalid', 2);
149: END IF;*/
150:
151: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
152: FND_LOG.STRING(G_PROC_LEVEL,
153: G_PKG_NAME, '300: - attribute TEMPLATE_ID is invalid' );
154: END IF;
155: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_ID');
156: x_return_status := G_RET_STS_ERROR;

Line 197: FND_LOG.STRING(G_PROC_LEVEL,

193: okc_debug.log('1000: Leaving start_approval', 2);
194: END IF;*/
195:
196: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
197: FND_LOG.STRING(G_PROC_LEVEL,
198: G_PKG_NAME, '1000: Leaving start_approval' );
199: END IF;
200:
201: EXCEPTION

Line 209: FND_LOG.STRING(G_EXCP_LEVEL,

205: okc_debug.log('800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception', 2);
206: END IF;*/
207:
208: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
209: FND_LOG.STRING(G_EXCP_LEVEL,
210: G_PKG_NAME, '800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception' );
211: END IF;
212:
213: ROLLBACK TO g_start_approval_grp;

Line 223: FND_LOG.STRING(G_EXCP_LEVEL,

219: okc_debug.log('900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
220: END IF;*/
221:
222: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
223: FND_LOG.STRING(G_EXCP_LEVEL,
224: G_PKG_NAME, '900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
225: END IF;
226:
227: ROLLBACK TO g_start_approval_grp;

Line 237: FND_LOG.STRING(G_EXCP_LEVEL,

233: okc_debug.log('1000: Leaving start_approval because of EXCEPTION: '||sqlerrm, 2);
234: END IF;*/
235:
236: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
237: FND_LOG.STRING(G_EXCP_LEVEL,
238: G_PKG_NAME, '1000: Leaving start_approval because of EXCEPTION: '||sqlerrm );
239: END IF;
240:
241: ROLLBACK TO g_start_approval_grp;