APPS.OKC_CODE_HOOK dependencies on FND_LOG

Line 21: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

17: g_sqlerrm_token CONSTANT VARCHAR2 (200) := 'ERROR_MESSAGE';
18: g_sqlcode_token CONSTANT VARCHAR2 (200) := 'ERROR_CODE';
19:
20:
21: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
22: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
23: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
24:
25:

Line 22: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

18: g_sqlcode_token CONSTANT VARCHAR2 (200) := 'ERROR_CODE';
19:
20:
21: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
22: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
23: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
24:
25:
26: /* PROCEDURE

Line 23: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

19:
20:
21: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
22: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
23: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
24:
25:
26: /* PROCEDURE
27: GET_MULTIVAL_UDV_FOR_XPRT This routine is used to get the multiple values for variables in expert.

Line 213: FND_LOG.STRING(G_PROC_LEVEL,

209:
210: /* -- Comment Start -- Comment this line if you want sync RWA
211:
212: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
213: FND_LOG.STRING(G_PROC_LEVEL,
214: G_PKG_NAME, '100: sync_rwa_with_document Start');
215: END IF;
216:
217: -- Get the template id from document usages

Line 224: FND_LOG.STRING(G_PROC_LEVEL,

220: FROM okc_template_usages
221: WHERE document_type = p_doc_type AND document_id = p_doc_id;
222:
223: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
224: FND_LOG.STRING(G_PROC_LEVEL,
225: G_PKG_NAME, '110: sync_rwa_with_document : After getting Template_id '|| l_template_id);
226: END IF;
227:
228: -- Get the intent and org_id from the template

Line 237: FND_LOG.STRING(G_PROC_LEVEL,

233:
234: WHERE template_id = l_template_id;
235:
236: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
237: FND_LOG.STRING(G_PROC_LEVEL,
238: G_PKG_NAME, '120: sync_rwa_with_document : After getting Intent as '|| l_intent ||' and Org id as' ||l_org_id );
239: END IF;
240:
241:

Line 276: FND_LOG.STRING(G_PROC_LEVEL,

272: WHERE outcome.rule_id = rule.rule_id
273: AND outcome.object_type = 'CLAUSE';
274:
275: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
276: FND_LOG.STRING(G_PROC_LEVEL,
277: G_PKG_NAME, '130: sync_rwa_with_document : Outcome clauses '|| l_outcome_tbl.count);
278: END IF;
279:
280: -- Create structure similar to Hasmap from the input articles.

Line 287: FND_LOG.STRING(G_PROC_LEVEL,

283: l_clause_id_tbl(p_article_id_tbl(i)) := 1;
284: END LOOP;
285:
286: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
287: FND_LOG.STRING(G_PROC_LEVEL,
288: G_PKG_NAME, '140: sync_rwa_with_document : Created Hash');
289: END IF;
290:
291: END IF;

Line 302: FND_LOG.STRING(G_PROC_LEVEL,

298: END IF;
299: END LOOP;
300:
301: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
302: FND_LOG.STRING(G_PROC_LEVEL,
303: G_PKG_NAME, '140: sync_rwa_with_document : After setting Outcome table');
304: END IF;
305:
306: -- Execute the update statement

Line 317: FND_LOG.STRING(G_PROC_LEVEL,

313: AND document_id = p_doc_id
314: AND sav_sae_id = l_outcome_tbl(i).clause_id ;
315:
316: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
317: FND_LOG.STRING(G_PROC_LEVEL,
318: G_PKG_NAME, '140: sync_rwa_with_document : After updating okc_k_articles_b table');
319: END IF;
320:
321: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 322: FND_LOG.STRING(G_PROC_LEVEL,

318: G_PKG_NAME, '140: sync_rwa_with_document : After updating okc_k_articles_b table');
319: END IF;
320:
321: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
322: FND_LOG.STRING(G_PROC_LEVEL,
323: G_PKG_NAME, '100: sync_rwa_with_document End');
324: END IF;
325:
326: */ -- Comment End -- Comment this line if you want sync RWA

Line 335: FND_LOG.STRING(G_PROC_LEVEL,

331: EXCEPTION
332: WHEN OTHERS
333: THEN
334: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
335: FND_LOG.STRING(G_PROC_LEVEL,
336: G_PKG_NAME, '100: sync_rwa_with_document Exception');
337: END IF;
338:
339: RAISE;