eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CLM_PKG dependencies on FND_LOG

Line 9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: ------------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CLM_PKG';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
8:
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
11: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13:

Line 59: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

55:
56: BEGIN
57:
58: -- start debug log
59: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
60: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
61: G_MODULE||l_api_name,
62: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
63: END IF;

Line 60: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

56: BEGIN
57:
58: -- start debug log
59: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
60: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
61: G_MODULE||l_api_name,
62: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
63: END IF;
64:

Line 109: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

105: l_api_version CONSTANT NUMBER := 1.0;
106:
107: BEGIN
108: -- start debug log
109: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
111: G_MODULE||l_api_name,
112: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
113: END IF;

Line 110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

106:
107: BEGIN
108: -- start debug log
109: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
111: G_MODULE||l_api_name,
112: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
113: END IF;
114:

Line 204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

200: END;
201:
202: BEGIN
203:
204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
206: G_MODULE||l_api_name,
207: '100: Entered '||G_PKG_NAME ||'.'||'get_clm_udv_value');
208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

201:
202: BEGIN
203:
204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
206: G_MODULE||l_api_name,
207: '100: Entered '||G_PKG_NAME ||'.'||'get_clm_udv_value');
208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
209: G_MODULE||l_api_name,

Line 208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
206: G_MODULE||l_api_name,
207: '100: Entered '||G_PKG_NAME ||'.'||'get_clm_udv_value');
208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
209: G_MODULE||l_api_name,
210: '100: Parameter p_doc_type'||' '||p_doc_type);
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
212: G_MODULE||l_api_name,

Line 211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

207: '100: Entered '||G_PKG_NAME ||'.'||'get_clm_udv_value');
208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
209: G_MODULE||l_api_name,
210: '100: Parameter p_doc_type'||' '||p_doc_type);
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
212: G_MODULE||l_api_name,
213: '100: Parameter p_doc_id'||' '||p_doc_id);
214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
215: G_MODULE||l_api_name,

Line 214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

210: '100: Parameter p_doc_type'||' '||p_doc_type);
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
212: G_MODULE||l_api_name,
213: '100: Parameter p_doc_id'||' '||p_doc_id);
214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
215: G_MODULE||l_api_name,
216: '100: Parameter p_variable_code'||' '||p_variable_code);
217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
218: G_MODULE||l_api_name,

Line 217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

213: '100: Parameter p_doc_id'||' '||p_doc_id);
214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
215: G_MODULE||l_api_name,
216: '100: Parameter p_variable_code'||' '||p_variable_code);
217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
218: G_MODULE||l_api_name,
219: '100: Parameter p_clm_ref1'||' '||p_clm_ref1);
220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
221: G_MODULE||l_api_name,

Line 220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

216: '100: Parameter p_variable_code'||' '||p_variable_code);
217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
218: G_MODULE||l_api_name,
219: '100: Parameter p_clm_ref1'||' '||p_clm_ref1);
220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
221: G_MODULE||l_api_name,
222: '100: Parameter p_clm_ref2'||' '||p_clm_ref2);
223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
224: G_MODULE||l_api_name,

Line 223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

219: '100: Parameter p_clm_ref1'||' '||p_clm_ref1);
220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
221: G_MODULE||l_api_name,
222: '100: Parameter p_clm_ref2'||' '||p_clm_ref2);
223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
224: G_MODULE||l_api_name,
225: '100: Parameter p_clm_ref3'||' '||p_clm_ref3);
226: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
227: G_MODULE||l_api_name,

Line 226: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

222: '100: Parameter p_clm_ref2'||' '||p_clm_ref2);
223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
224: G_MODULE||l_api_name,
225: '100: Parameter p_clm_ref3'||' '||p_clm_ref3);
226: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
227: G_MODULE||l_api_name,
228: '100: Parameter p_clm_ref4'||' '||p_clm_ref4);
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
230: G_MODULE||l_api_name,

Line 229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

225: '100: Parameter p_clm_ref3'||' '||p_clm_ref3);
226: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
227: G_MODULE||l_api_name,
228: '100: Parameter p_clm_ref4'||' '||p_clm_ref4);
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
230: G_MODULE||l_api_name,
231: '100: Parameter p_clm_ref5'||' '||p_clm_ref5);
232: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
233: G_MODULE||l_api_name,

Line 232: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

228: '100: Parameter p_clm_ref4'||' '||p_clm_ref4);
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
230: G_MODULE||l_api_name,
231: '100: Parameter p_clm_ref5'||' '||p_clm_ref5);
232: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
233: G_MODULE||l_api_name,
234: '100: Parameter p_clm_source'||' '||p_clm_source);
235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
236: G_MODULE||l_api_name,

Line 235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

231: '100: Parameter p_clm_ref5'||' '||p_clm_ref5);
232: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
233: G_MODULE||l_api_name,
234: '100: Parameter p_clm_source'||' '||p_clm_source);
235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
236: G_MODULE||l_api_name,
237: '100: Parameter p_variable_name'||' '||p_variable_name);
238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
239: G_MODULE||l_api_name,

Line 238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

234: '100: Parameter p_clm_source'||' '||p_clm_source);
235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
236: G_MODULE||l_api_name,
237: '100: Parameter p_variable_name'||' '||p_variable_name);
238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
239: G_MODULE||l_api_name,
240: '100: Parameter p_uda_mode'||' '||p_uda_mode);
241: END IF;
242:

Line 247: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

243: OPEN c_get_doc_type_class(p_doc_type);
244: FETCH c_get_doc_type_class INTO l_doc_type_class;
245: CLOSE c_get_doc_type_class;
246:
247: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
249: G_MODULE||l_api_name,
250: '110: value l_doc_type_class'||' '||l_doc_type_class);
251: END IF;

Line 248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

244: FETCH c_get_doc_type_class INTO l_doc_type_class;
245: CLOSE c_get_doc_type_class;
246:
247: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
249: G_MODULE||l_api_name,
250: '110: value l_doc_type_class'||' '||l_doc_type_class);
251: END IF;
252:

Line 279: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

275: l_address_type := p_clm_ref4;
276:
277: IF p_clm_ref1='single' THEN
278:
279: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
280: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
281: G_MODULE||l_api_name,
282: '120: Parameter l_entity_name'||' '||l_entity_name);
283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 280: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

276:
277: IF p_clm_ref1='single' THEN
278:
279: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
280: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
281: G_MODULE||l_api_name,
282: '120: Parameter l_entity_name'||' '||l_entity_name);
283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
284: G_MODULE||l_api_name,

Line 283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

279: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
280: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
281: G_MODULE||l_api_name,
282: '120: Parameter l_entity_name'||' '||l_entity_name);
283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
284: G_MODULE||l_api_name,
285: '120: Parameter l_pk1_value'||' '||l_pk1_value);
286: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
287: G_MODULE||l_api_name,

Line 286: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

282: '120: Parameter l_entity_name'||' '||l_entity_name);
283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
284: G_MODULE||l_api_name,
285: '120: Parameter l_pk1_value'||' '||l_pk1_value);
286: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
287: G_MODULE||l_api_name,
288: '120: Parameter l_pk2_value'||' '||l_pk2_value);
289: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
290: G_MODULE||l_api_name,

Line 289: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

285: '120: Parameter l_pk1_value'||' '||l_pk1_value);
286: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
287: G_MODULE||l_api_name,
288: '120: Parameter l_pk2_value'||' '||l_pk2_value);
289: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
290: G_MODULE||l_api_name,
291: '120: Parameter l_attr_grp'||' '||l_attr_grp);
292: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
293: G_MODULE||l_api_name,

Line 292: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

288: '120: Parameter l_pk2_value'||' '||l_pk2_value);
289: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
290: G_MODULE||l_api_name,
291: '120: Parameter l_attr_grp'||' '||l_attr_grp);
292: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
293: G_MODULE||l_api_name,
294: '120: Parameter l_attr'||' '||l_attr);
295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
296: G_MODULE||l_api_name,

Line 295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

291: '120: Parameter l_attr_grp'||' '||l_attr_grp);
292: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
293: G_MODULE||l_api_name,
294: '120: Parameter l_attr'||' '||l_attr);
295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
296: G_MODULE||l_api_name,
297: '120: Parameter p_uda_mode'||' '||p_uda_mode);
298: END IF;
299:

Line 320: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

316: USING l_entity_name,l_pk1_value,l_pk2_value,l_attr_grp,l_attr,p_uda_mode;
317:
318: ELSIF p_clm_ref1='address' THEN
319:
320: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
322: G_MODULE||l_api_name,
323: '130: Parameter l_entity_name'||' '||l_entity_name);
324: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

317:
318: ELSIF p_clm_ref1='address' THEN
319:
320: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
322: G_MODULE||l_api_name,
323: '130: Parameter l_entity_name'||' '||l_entity_name);
324: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
325: G_MODULE||l_api_name,

Line 324: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

320: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
322: G_MODULE||l_api_name,
323: '130: Parameter l_entity_name'||' '||l_entity_name);
324: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
325: G_MODULE||l_api_name,
326: '130: Parameter l_pk1_value'||' '||l_pk1_value);
327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
328: G_MODULE||l_api_name,

Line 327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

323: '130: Parameter l_entity_name'||' '||l_entity_name);
324: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
325: G_MODULE||l_api_name,
326: '130: Parameter l_pk1_value'||' '||l_pk1_value);
327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
328: G_MODULE||l_api_name,
329: '130: Parameter l_pk2_value'||' '||l_pk2_value);
330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
331: G_MODULE||l_api_name,

Line 330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

326: '130: Parameter l_pk1_value'||' '||l_pk1_value);
327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
328: G_MODULE||l_api_name,
329: '130: Parameter l_pk2_value'||' '||l_pk2_value);
330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
331: G_MODULE||l_api_name,
332: '130: Parameter p_clm_ref2'||' '||p_clm_ref2);
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
334: G_MODULE||l_api_name,

Line 333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

329: '130: Parameter l_pk2_value'||' '||l_pk2_value);
330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
331: G_MODULE||l_api_name,
332: '130: Parameter p_clm_ref2'||' '||p_clm_ref2);
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
334: G_MODULE||l_api_name,
335: '130: Parameter p_clm_ref3'||' '||p_clm_ref3);
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
337: G_MODULE||l_api_name,

Line 336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

332: '130: Parameter p_clm_ref2'||' '||p_clm_ref2);
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
334: G_MODULE||l_api_name,
335: '130: Parameter p_clm_ref3'||' '||p_clm_ref3);
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
337: G_MODULE||l_api_name,
338: '130: Parameter p_clm_ref4'||' '||p_clm_ref4);
339: END IF;
340:

Line 371: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

367: INTO l_variable_value
368: USING l_entity_name,l_pk1_value,l_pk2_value,p_clm_ref2,p_clm_ref3,p_clm_ref4;
369:
370:
371: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
373: G_MODULE||l_api_name,
374: '140: Parameter l_variable_value'||' '||l_variable_value);
375: END IF;

Line 372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

368: USING l_entity_name,l_pk1_value,l_pk2_value,p_clm_ref2,p_clm_ref3,p_clm_ref4;
369:
370:
371: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
373: G_MODULE||l_api_name,
374: '140: Parameter l_variable_value'||' '||l_variable_value);
375: END IF;
376:

Line 383: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

379:
380: l_variable_value := extract_value_from_xml(p_address_type => p_clm_ref4,
381: p_attribute => p_clm_ref5,
382: p_xml_string => l_variable_value);
383: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
384: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
385: G_MODULE||l_api_name,
386: '150: Parameter l_variable_value'||' '||l_variable_value);
387: END IF;

Line 384: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

380: l_variable_value := extract_value_from_xml(p_address_type => p_clm_ref4,
381: p_attribute => p_clm_ref5,
382: p_xml_string => l_variable_value);
383: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
384: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
385: G_MODULE||l_api_name,
386: '150: Parameter l_variable_value'||' '||l_variable_value);
387: END IF;
388:

Line 404: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

400: END IF; -- clm_source
401:
402: x_variable_value := l_variable_value;
403:
404: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
406: G_MODULE||l_api_name,
407: '100: Parameter l_variable_value'||' '||x_variable_value);
408: END IF;

Line 405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

401:
402: x_variable_value := l_variable_value;
403:
404: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
406: G_MODULE||l_api_name,
407: '100: Parameter l_variable_value'||' '||x_variable_value);
408: END IF;
409: END get_clm_udv_value;

Line 528: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

524:
525: BEGIN
526:
527: -- start debug log
528: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
529: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
530: G_MODULE||l_api_name,
531: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
532: END IF;

Line 529: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

525: BEGIN
526:
527: -- start debug log
528: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
529: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
530: G_MODULE||l_api_name,
531: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
532: END IF;
533:

Line 584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

580:
581: END IF;
582:
583:
584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
586: G_MODULE||l_api_name,
587: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
588: END IF;

Line 585: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

581: END IF;
582:
583:
584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
586: G_MODULE||l_api_name,
587: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
588: END IF;
589:

Line 594: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

590: EXCEPTION
591:
592:
593: WHEN FND_API.G_EXC_ERROR THEN
594: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
595: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
596: G_MODULE||l_api_name,
597: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
598: END IF;

Line 595: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

591:
592:
593: WHEN FND_API.G_EXC_ERROR THEN
594: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
595: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
596: G_MODULE||l_api_name,
597: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
598: END IF;
599:

Line 604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

600: x_return_status := G_RET_STS_ERROR ;
601: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
606: G_MODULE||l_api_name,
607: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
608: END IF;

Line 605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

601: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
606: G_MODULE||l_api_name,
607: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
608: END IF;
609:

Line 614: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

610: x_return_status := G_RET_STS_UNEXP_ERROR ;
611: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
612:
613: WHEN OTHERS THEN
614: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
615: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
616: G_MODULE||l_api_name,
617: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
618: END IF;

Line 615: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

611: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
612:
613: WHEN OTHERS THEN
614: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
615: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
616: G_MODULE||l_api_name,
617: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
618: END IF;
619:

Line 672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

668: AND KA.document_id = p_document_id
669: ORDER BY VB.variable_code;
670:
671: BEGIN
672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered set_clm_udv');
674: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_type:'||p_document_type);
675: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_id:'||p_document_id);
676: END IF;

Line 673: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered set_clm_udv');

669: ORDER BY VB.variable_code;
670:
671: BEGIN
672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered set_clm_udv');
674: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_type:'||p_document_type);
675: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_id:'||p_document_id);
676: END IF;
677:

Line 674: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_type:'||p_document_type);

670:
671: BEGIN
672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered set_clm_udv');
674: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_type:'||p_document_type);
675: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_id:'||p_document_id);
676: END IF;
677:
678: /* Standard call to check for call compatibility */

Line 675: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_id:'||p_document_id);

671: BEGIN
672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered set_clm_udv');
674: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_type:'||p_document_type);
675: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_id:'||p_document_id);
676: END IF;
677:
678: /* Standard call to check for call compatibility */
679: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 750: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

746: x_return_status := G_RET_STS_ERROR;
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749:
750: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
751: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving set_clm_udv');
752: END IF;
753:
754: EXCEPTION

Line 751: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving set_clm_udv');

747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749:
750: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
751: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving set_clm_udv');
752: END IF;
753:
754: EXCEPTION
755: WHEN FND_API.G_EXC_ERROR THEN

Line 757: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

753:
754: EXCEPTION
755: WHEN FND_API.G_EXC_ERROR THEN
756:
757: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
758: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_ERROR Exception');
759: END IF;
760:
761: IF csr_get_clm_udv%ISOPEN THEN

Line 758: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_ERROR Exception');

754: EXCEPTION
755: WHEN FND_API.G_EXC_ERROR THEN
756:
757: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
758: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_ERROR Exception');
759: END IF;
760:
761: IF csr_get_clm_udv%ISOPEN THEN
762: CLOSE csr_get_clm_udv;

Line 770: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

766: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
767:
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769:
770: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
771: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
772: END IF;
773:
774: IF csr_get_clm_udv%ISOPEN THEN

Line 771: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

767:
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769:
770: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
771: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
772: END IF;
773:
774: IF csr_get_clm_udv%ISOPEN THEN
775: CLOSE csr_get_clm_udv;

Line 783: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

779: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
780:
781: WHEN OTHERS THEN
782:
783: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
784: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3000: Leaving set_clm_udv because of EXCEPTION: '||sqlerrm);
785: END IF;
786:
787: IF csr_get_clm_udv%ISOPEN THEN

Line 784: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3000: Leaving set_clm_udv because of EXCEPTION: '||sqlerrm);

780:
781: WHEN OTHERS THEN
782:
783: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
784: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3000: Leaving set_clm_udv because of EXCEPTION: '||sqlerrm);
785: END IF;
786:
787: IF csr_get_clm_udv%ISOPEN THEN
788: CLOSE csr_get_clm_udv;

Line 913: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

909: l_udf_var_value_tbl okc_xprt_xrule_values_pvt.udf_var_value_tbl_type;
910:
911: BEGIN
912: -- start debug log
913: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
914: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
915: G_MODULE||l_api_name,
916: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
917: END IF;

Line 914: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

910:
911: BEGIN
912: -- start debug log
913: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
914: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
915: G_MODULE||l_api_name,
916: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
917: END IF;
918:

Line 1137: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1133: AND scn_code = p_scn_code
1134: ORDER BY id;
1135:
1136: BEGIN
1137: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1138: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_scn_art');
1139: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1140: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1141: END IF;

Line 1138: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_scn_art');

1134: ORDER BY id;
1135:
1136: BEGIN
1137: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1138: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_scn_art');
1139: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1140: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1141: END IF;
1142:

Line 1139: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);

1135:
1136: BEGIN
1137: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1138: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_scn_art');
1139: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1140: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1141: END IF;
1142:
1143: /*for each duplicate section_code in the document find their

Line 1140: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);

1136: BEGIN
1137: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1138: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_scn_art');
1139: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1140: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1141: END IF;
1142:
1143: /*for each duplicate section_code in the document find their
1144: first section_id and replace all the remaining ones with first Id*/

Line 1150: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1146: OPEN l_get_dup_sec_ids_csr(rec.scn_code);
1147: FETCH l_get_dup_sec_ids_csr BULK COLLECT INTO l_dup_scn_id_tbl;
1148: CLOSE l_get_dup_sec_ids_csr;
1149: FOR i IN l_dup_scn_id_tbl.first..l_dup_scn_id_tbl.last LOOP
1150: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: in FOR loop');
1152: END IF;
1153:
1154: l_remaining_scn_ids := NULL;

Line 1151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: in FOR loop');

1147: FETCH l_get_dup_sec_ids_csr BULK COLLECT INTO l_dup_scn_id_tbl;
1148: CLOSE l_get_dup_sec_ids_csr;
1149: FOR i IN l_dup_scn_id_tbl.first..l_dup_scn_id_tbl.last LOOP
1150: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: in FOR loop');
1152: END IF;
1153:
1154: l_remaining_scn_ids := NULL;
1155:

Line 1165: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1161: END IF;
1162: END IF;
1163: END LOOP;
1164:
1165: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1166: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'500: l_dup_scn_id_tbl(1): '|| l_dup_scn_id_tbl(1));
1167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: l_remaining_scn_ids: '|| l_remaining_scn_ids);
1168: END IF;
1169:

Line 1166: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'500: l_dup_scn_id_tbl(1): '|| l_dup_scn_id_tbl(1));

1162: END IF;
1163: END LOOP;
1164:
1165: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1166: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'500: l_dup_scn_id_tbl(1): '|| l_dup_scn_id_tbl(1));
1167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: l_remaining_scn_ids: '|| l_remaining_scn_ids);
1168: END IF;
1169:
1170: IF l_remaining_scn_ids IS NOT NULL THEN

Line 1167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: l_remaining_scn_ids: '|| l_remaining_scn_ids);

1163: END LOOP;
1164:
1165: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1166: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'500: l_dup_scn_id_tbl(1): '|| l_dup_scn_id_tbl(1));
1167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: l_remaining_scn_ids: '|| l_remaining_scn_ids);
1168: END IF;
1169:
1170: IF l_remaining_scn_ids IS NOT NULL THEN
1171: UPDATE okc_k_articles_b

Line 1180: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1176: WHERE document_type = p_document_type
1177: AND document_id = p_document_id
1178: AND scn_id IN (l_remaining_scn_ids);
1179:
1180: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1181: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Update done on okc_k_articles_b table ');
1182: END IF;
1183:
1184: /*When all the articles are updated with the first section_id, delete the remaining sections from okc_sections_b table*/

Line 1181: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Update done on okc_k_articles_b table ');

1177: AND document_id = p_document_id
1178: AND scn_id IN (l_remaining_scn_ids);
1179:
1180: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1181: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Update done on okc_k_articles_b table ');
1182: END IF;
1183:
1184: /*When all the articles are updated with the first section_id, delete the remaining sections from okc_sections_b table*/
1185:

Line 1191: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1187: EXECUTE IMMEDIATE l_del_stmt;
1188:
1189: END IF;
1190:
1191: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'800: Delete done on okc_sections_b table ');
1193: END IF;
1194: END LOOP; -- FOR rec IN l_get_dup_sec_csr LOOP
1195:

Line 1192: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'800: Delete done on okc_sections_b table ');

1188:
1189: END IF;
1190:
1191: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'800: Delete done on okc_sections_b table ');
1193: END IF;
1194: END LOOP; -- FOR rec IN l_get_dup_sec_csr LOOP
1195:
1196: x_return_status := 'S';

Line 1200: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1196: x_return_status := 'S';
1197: EXCEPTION
1198:
1199: WHEN NO_DATA_FOUND THEN
1200: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1201: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving clm_remove_dup_scn_art No Data in Source');
1202: END IF;
1203: null;
1204:

Line 1201: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving clm_remove_dup_scn_art No Data in Source');

1197: EXCEPTION
1198:
1199: WHEN NO_DATA_FOUND THEN
1200: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1201: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving clm_remove_dup_scn_art No Data in Source');
1202: END IF;
1203: null;
1204:
1205: WHEN FND_API.G_EXC_ERROR THEN

Line 1207: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1203: null;
1204:
1205: WHEN FND_API.G_EXC_ERROR THEN
1206:
1207: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1208: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_scn_art: OKC_API.G_EXCEPTION_ERROR Exception');
1209: END IF;
1210:
1211: IF l_get_dup_sec_csr%ISOPEN THEN

Line 1208: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_scn_art: OKC_API.G_EXCEPTION_ERROR Exception');

1204:
1205: WHEN FND_API.G_EXC_ERROR THEN
1206:
1207: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1208: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_scn_art: OKC_API.G_EXCEPTION_ERROR Exception');
1209: END IF;
1210:
1211: IF l_get_dup_sec_csr%ISOPEN THEN
1212: CLOSE l_get_dup_sec_csr;

Line 1223: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1219: x_return_status := G_RET_STS_UNEXP_ERROR ;
1220:
1221: WHEN OTHERS THEN
1222:
1223: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1224: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_archived_doc because of EXCEPTION: '||sqlerrm);
1225: END IF;
1226:
1227: IF l_get_dup_sec_csr%ISOPEN THEN

Line 1224: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_archived_doc because of EXCEPTION: '||sqlerrm);

1220:
1221: WHEN OTHERS THEN
1222:
1223: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1224: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_archived_doc because of EXCEPTION: '||sqlerrm);
1225: END IF;
1226:
1227: IF l_get_dup_sec_csr%ISOPEN THEN
1228: CLOSE l_get_dup_sec_csr;

Line 1277: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1273: AND scn_id = p_scn_id
1274: ORDER BY id asc;
1275:
1276: BEGIN
1277: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_articles');
1279: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1280: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1281: END IF;

Line 1278: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_articles');

1274: ORDER BY id asc;
1275:
1276: BEGIN
1277: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_articles');
1279: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1280: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1281: END IF;
1282:

Line 1279: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);

1275:
1276: BEGIN
1277: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_articles');
1279: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1280: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1281: END IF;
1282:
1283: FOR rec IN l_get_dup_articles_csr LOOP

Line 1280: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);

1276: BEGIN
1277: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_articles');
1279: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1280: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1281: END IF;
1282:
1283: FOR rec IN l_get_dup_articles_csr LOOP
1284: OPEN l_get_dup_art_ids(rec.sav_sae_id, rec.scn_id);

Line 1308: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1304: END LOOP;
1305:
1306: EXCEPTION
1307: WHEN NO_DATA_FOUND THEN
1308: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1309: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving clm_remove_dup_articles No Data in Source');
1310: END IF;
1311: null;
1312:

Line 1309: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving clm_remove_dup_articles No Data in Source');

1305:
1306: EXCEPTION
1307: WHEN NO_DATA_FOUND THEN
1308: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1309: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving clm_remove_dup_articles No Data in Source');
1310: END IF;
1311: null;
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN

Line 1315: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1311: null;
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314:
1315: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1316: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_articles: OKC_API.G_EXCEPTION_ERROR Exception');
1317: END IF;
1318:
1319: IF l_get_dup_articles_csr%ISOPEN THEN

Line 1316: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_articles: OKC_API.G_EXCEPTION_ERROR Exception');

1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314:
1315: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1316: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_articles: OKC_API.G_EXCEPTION_ERROR Exception');
1317: END IF;
1318:
1319: IF l_get_dup_articles_csr%ISOPEN THEN
1320: CLOSE l_get_dup_articles_csr;

Line 1331: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1327: x_return_status := G_RET_STS_UNEXP_ERROR ;
1328:
1329: WHEN OTHERS THEN
1330:
1331: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1332: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_archived_doc because of EXCEPTION: '||sqlerrm);
1333: END IF;
1334:
1335: IF l_get_dup_articles_csr%ISOPEN THEN

Line 1332: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_archived_doc because of EXCEPTION: '||sqlerrm);

1328:
1329: WHEN OTHERS THEN
1330:
1331: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1332: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_archived_doc because of EXCEPTION: '||sqlerrm);
1333: END IF;
1334:
1335: IF l_get_dup_articles_csr%ISOPEN THEN
1336: CLOSE l_get_dup_articles_csr;

Line 1361: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1357:
1358: l_api_name CONSTANT VARCHAR2(30) := 'clm_remove_dup_scn_art';
1359:
1360: BEGIN
1361: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_scn_art');
1363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1365: END IF;

Line 1362: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_scn_art');

1358: l_api_name CONSTANT VARCHAR2(30) := 'clm_remove_dup_scn_art';
1359:
1360: BEGIN
1361: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_scn_art');
1363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1365: END IF;
1366:

Line 1363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);

1359:
1360: BEGIN
1361: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_scn_art');
1363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1365: END IF;
1366:
1367: clm_remove_dup_sections( p_document_type => p_document_type,

Line 1364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);

1360: BEGIN
1361: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: entered okc_terms_copy_pvt.clm_remove_dup_scn_art');
1363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: param p_document_type: ' || p_document_type);
1364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: param p_document_id: ' || p_document_id);
1365: END IF;
1366:
1367: clm_remove_dup_sections( p_document_type => p_document_type,
1368: p_document_id => p_document_id,

Line 1373: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1369: x_return_status => x_return_status,
1370: x_msg_data => x_msg_data,
1371: x_msg_count => x_msg_count);
1372:
1373: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1374: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: After clm_remove_dup_sections : x_return_status' || x_return_status);
1375: END IF;
1376:
1377:

Line 1374: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: After clm_remove_dup_sections : x_return_status' || x_return_status);

1370: x_msg_data => x_msg_data,
1371: x_msg_count => x_msg_count);
1372:
1373: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1374: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: After clm_remove_dup_sections : x_return_status' || x_return_status);
1375: END IF;
1376:
1377:
1378: clm_remove_dup_articles( p_document_type => p_document_type,

Line 1384: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1380: x_return_status => x_return_status,
1381: x_msg_data => x_msg_data,
1382: x_msg_count => x_msg_count);
1383:
1384: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1385: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'500: After clm_remove_dup_articles : x_return_status' || x_return_status);
1386: END IF;
1387:
1388: END clm_remove_dup_scn_art;

Line 1385: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'500: After clm_remove_dup_articles : x_return_status' || x_return_status);

1381: x_msg_data => x_msg_data,
1382: x_msg_count => x_msg_count);
1383:
1384: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1385: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'500: After clm_remove_dup_articles : x_return_status' || x_return_status);
1386: END IF;
1387:
1388: END clm_remove_dup_scn_art;
1389:

Line 1428: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1424: AND document_id = p_document_id
1425: AND template_id = p_template_id;
1426:
1427: BEGIN
1428: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1429: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered insert_usages_row ');
1430: END IF;
1431:
1432: -- Set Internal columns

Line 1429: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered insert_usages_row ');

1425: AND template_id = p_template_id;
1426:
1427: BEGIN
1428: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1429: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered insert_usages_row ');
1430: END IF;
1431:
1432: -- Set Internal columns
1433: l_object_version_number := 1;

Line 1443: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1439:
1440: --Item level validations
1441:
1442: IF ( p_valid_config_yn NOT IN ('Y','N') AND p_valid_config_yn IS NOT NULL) THEN
1443: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: - attribute VALID_CONFIG_YN is invalid');
1445: END IF;
1446: -- Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'VALID_CONFIG_YN');
1447: x_return_status := G_RET_STS_ERROR;

Line 1444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: - attribute VALID_CONFIG_YN is invalid');

1440: --Item level validations
1441:
1442: IF ( p_valid_config_yn NOT IN ('Y','N') AND p_valid_config_yn IS NOT NULL) THEN
1443: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: - attribute VALID_CONFIG_YN is invalid');
1445: END IF;
1446: -- Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'VALID_CONFIG_YN');
1447: x_return_status := G_RET_STS_ERROR;
1448: END IF;

Line 1502: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1498: p_primary_template
1499: );
1500: END IF;
1501:
1502: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1503: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Insert_Row');
1504: END IF;
1505:
1506: x_return_status := G_RET_STS_SUCCESS;

Line 1503: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Insert_Row');

1499: );
1500: END IF;
1501:
1502: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1503: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Insert_Row');
1504: END IF;
1505:
1506: x_return_status := G_RET_STS_SUCCESS;
1507:

Line 1511: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1507:
1508: EXCEPTION
1509: WHEN OTHERS THEN
1510:
1511: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1512: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Insert_Row:OTHERS Exception');
1513: END IF;
1514:
1515: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1512: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Insert_Row:OTHERS Exception');

1508: EXCEPTION
1509: WHEN OTHERS THEN
1510:
1511: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1512: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Insert_Row:OTHERS Exception');
1513: END IF;
1514:
1515: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1516: p_msg_name => G_UNEXPECTED_ERROR,

Line 1553: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1549:
1550: l_row_notfound BOOLEAN := FALSE;
1551: BEGIN
1552:
1553: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1554: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered Lock_Row');
1555: END IF;
1556:
1557: BEGIN

Line 1554: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered Lock_Row');

1550: l_row_notfound BOOLEAN := FALSE;
1551: BEGIN
1552:
1553: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1554: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered Lock_Row');
1555: END IF;
1556:
1557: BEGIN
1558:

Line 1567: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1563:
1564: EXCEPTION
1565: WHEN E_Resource_Busy THEN
1566:
1567: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1568: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving Lock_Row:E_Resource_Busy Exception');
1569: END IF;
1570:
1571: IF (lock_csr%ISOPEN) THEN

Line 1568: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving Lock_Row:E_Resource_Busy Exception');

1564: EXCEPTION
1565: WHEN E_Resource_Busy THEN
1566:
1567: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1568: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving Lock_Row:E_Resource_Busy Exception');
1569: END IF;
1570:
1571: IF (lock_csr%ISOPEN) THEN
1572: CLOSE lock_csr;

Line 1603: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1599: ELSE
1600: l_return_status := G_RET_STS_SUCCESS;
1601: END IF;
1602:
1603: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1604: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Lock_Row');
1605: END IF;
1606:
1607: RETURN( l_return_status );

Line 1604: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Lock_Row');

1600: l_return_status := G_RET_STS_SUCCESS;
1601: END IF;
1602:
1603: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1604: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Lock_Row');
1605: END IF;
1606:
1607: RETURN( l_return_status );
1608:

Line 1619: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1615: IF (lchk_csr%ISOPEN) THEN
1616: CLOSE lchk_csr;
1617: END IF;
1618:
1619: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);
1621: END IF;
1622:
1623: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1620: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);

1616: CLOSE lchk_csr;
1617: END IF;
1618:
1619: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);
1621: END IF;
1622:
1623: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1624: p_msg_name => G_UNEXPECTED_ERROR,

Line 1642: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1638: ) IS
1639: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Usages_Row';
1640: BEGIN
1641:
1642: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1643: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered Delete_Usages_Row');
1644: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Locking row');
1645: END IF;
1646:

Line 1643: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered Delete_Usages_Row');

1639: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Usages_Row';
1640: BEGIN
1641:
1642: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1643: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered Delete_Usages_Row');
1644: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Locking row');
1645: END IF;
1646:
1647: x_return_status := Lock_row(

Line 1644: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Locking row');

1640: BEGIN
1641:
1642: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1643: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered Delete_Usages_Row');
1644: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Locking row');
1645: END IF;
1646:
1647: x_return_status := Lock_row(
1648: p_document_type => p_document_type,

Line 1658: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1654: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1655: RAISE FND_API.G_EXC_ERROR;
1656: END IF;
1657:
1658: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1659: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Removing rows');
1660: END IF;
1661:
1662: DELETE FROM OKC_MLP_TEMPLATE_USAGES WHERE DOCUMENT_TYPE = p_document_type AND DOCUMENT_ID = p_document_id;

Line 1659: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Removing rows');

1655: RAISE FND_API.G_EXC_ERROR;
1656: END IF;
1657:
1658: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1659: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Removing rows');
1660: END IF;
1661:
1662: DELETE FROM OKC_MLP_TEMPLATE_USAGES WHERE DOCUMENT_TYPE = p_document_type AND DOCUMENT_ID = p_document_id;
1663:

Line 1670: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1666: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669:
1670: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: Leaving Delete_Row');
1672: END IF;
1673:
1674: EXCEPTION

Line 1671: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: Leaving Delete_Row');

1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669:
1670: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: Leaving Delete_Row');
1672: END IF;
1673:
1674: EXCEPTION
1675: WHEN FND_API.G_EXC_ERROR THEN

Line 1676: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1672: END IF;
1673:
1674: EXCEPTION
1675: WHEN FND_API.G_EXC_ERROR THEN
1676: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1677: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Usages_Row:FND_API.G_EXC_ERROR Exception');
1678: END IF;
1679: x_return_status := G_RET_STS_ERROR;
1680:

Line 1677: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Usages_Row:FND_API.G_EXC_ERROR Exception');

1673:
1674: EXCEPTION
1675: WHEN FND_API.G_EXC_ERROR THEN
1676: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1677: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Usages_Row:FND_API.G_EXC_ERROR Exception');
1678: END IF;
1679: x_return_status := G_RET_STS_ERROR;
1680:
1681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1682: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1678: END IF;
1679: x_return_status := G_RET_STS_ERROR;
1680:
1681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1682: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1683: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Usages_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1684: END IF;
1685: x_return_status := G_RET_STS_UNEXP_ERROR;
1686:

Line 1683: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Usages_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1679: x_return_status := G_RET_STS_ERROR;
1680:
1681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1682: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1683: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Usages_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1684: END IF;
1685: x_return_status := G_RET_STS_UNEXP_ERROR;
1686:
1687: WHEN OTHERS THEN

Line 1688: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1684: END IF;
1685: x_return_status := G_RET_STS_UNEXP_ERROR;
1686:
1687: WHEN OTHERS THEN
1688: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1689: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving Delete_Usages_Row because of EXCEPTION: '||sqlerrm);
1690: END IF;
1691: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1692: p_msg_name => G_UNEXPECTED_ERROR,

Line 1689: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving Delete_Usages_Row because of EXCEPTION: '||sqlerrm);

1685: x_return_status := G_RET_STS_UNEXP_ERROR;
1686:
1687: WHEN OTHERS THEN
1688: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1689: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving Delete_Usages_Row because of EXCEPTION: '||sqlerrm);
1690: END IF;
1691: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1692: p_msg_name => G_UNEXPECTED_ERROR,
1693: p_token1 => G_SQLCODE_TOKEN,

Line 1719: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1715:
1716: l_template_exists VARCHAR2(1) := 'N';
1717:
1718: BEGIN
1719: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered check_dup_templates');
1721: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_document_type ' || p_document_type);
1722: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_document_id ' || p_document_id);
1723: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_template_id ' || p_template_id);

Line 1720: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered check_dup_templates');

1716: l_template_exists VARCHAR2(1) := 'N';
1717:
1718: BEGIN
1719: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered check_dup_templates');
1721: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_document_type ' || p_document_type);
1722: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_document_id ' || p_document_id);
1723: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_template_id ' || p_template_id);
1724: END IF;

Line 1721: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_document_type ' || p_document_type);

1717:
1718: BEGIN
1719: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered check_dup_templates');
1721: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_document_type ' || p_document_type);
1722: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_document_id ' || p_document_id);
1723: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_template_id ' || p_template_id);
1724: END IF;
1725:

Line 1722: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_document_id ' || p_document_id);

1718: BEGIN
1719: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered check_dup_templates');
1721: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_document_type ' || p_document_type);
1722: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_document_id ' || p_document_id);
1723: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_template_id ' || p_template_id);
1724: END IF;
1725:
1726: OPEN l_template_exists_csr;

Line 1723: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_template_id ' || p_template_id);

1719: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered check_dup_templates');
1721: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_document_type ' || p_document_type);
1722: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_document_id ' || p_document_id);
1723: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_template_id ' || p_template_id);
1724: END IF;
1725:
1726: OPEN l_template_exists_csr;
1727: FETCH l_template_exists_csr INTO l_template_exists;

Line 1734: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1730: RETURN l_template_exists;
1731:
1732: EXCEPTION
1733: WHEN FND_API.G_EXC_ERROR THEN
1734: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1735: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving check_dup_templates:FND_API.G_EXC_ERROR Exception');
1736: END IF;
1737: --x_return_status := G_RET_STS_ERROR;
1738:

Line 1735: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving check_dup_templates:FND_API.G_EXC_ERROR Exception');

1731:
1732: EXCEPTION
1733: WHEN FND_API.G_EXC_ERROR THEN
1734: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1735: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving check_dup_templates:FND_API.G_EXC_ERROR Exception');
1736: END IF;
1737: --x_return_status := G_RET_STS_ERROR;
1738:
1739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1740: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1736: END IF;
1737: --x_return_status := G_RET_STS_ERROR;
1738:
1739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1740: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1741: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving check_dup_templates:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1742: END IF;
1743: --x_return_status := G_RET_STS_UNEXP_ERROR;
1744:

Line 1741: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving check_dup_templates:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1737: --x_return_status := G_RET_STS_ERROR;
1738:
1739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1740: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1741: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving check_dup_templates:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1742: END IF;
1743: --x_return_status := G_RET_STS_UNEXP_ERROR;
1744:
1745: WHEN OTHERS THEN

Line 1746: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1742: END IF;
1743: --x_return_status := G_RET_STS_UNEXP_ERROR;
1744:
1745: WHEN OTHERS THEN
1746: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1747: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving check_dup_templates because of EXCEPTION: '||sqlerrm);
1748: END IF;
1749: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1750: p_msg_name => G_UNEXPECTED_ERROR,

Line 1747: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving check_dup_templates because of EXCEPTION: '||sqlerrm);

1743: --x_return_status := G_RET_STS_UNEXP_ERROR;
1744:
1745: WHEN OTHERS THEN
1746: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1747: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving check_dup_templates because of EXCEPTION: '||sqlerrm);
1748: END IF;
1749: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1750: p_msg_name => G_UNEXPECTED_ERROR,
1751: p_token1 => G_SQLCODE_TOKEN,

Line 1816: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1812: WHERE document_type = p_source_doc_type
1813: AND document_id = p_source_doc_id;
1814:
1815: BEGIN
1816: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1817: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered copy_usages_row');
1818: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_target_doc_type ' || p_target_doc_type);
1819: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_source_doc_type ' || p_source_doc_type);
1820: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_source_doc_id ' || p_source_doc_id);

Line 1817: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered copy_usages_row');

1813: AND document_id = p_source_doc_id;
1814:
1815: BEGIN
1816: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1817: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered copy_usages_row');
1818: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_target_doc_type ' || p_target_doc_type);
1819: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_source_doc_type ' || p_source_doc_type);
1820: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_source_doc_id ' || p_source_doc_id);
1821: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500: p_target_doc_id ' || p_target_doc_id);

Line 1818: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_target_doc_type ' || p_target_doc_type);

1814:
1815: BEGIN
1816: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1817: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered copy_usages_row');
1818: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_target_doc_type ' || p_target_doc_type);
1819: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_source_doc_type ' || p_source_doc_type);
1820: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_source_doc_id ' || p_source_doc_id);
1821: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500: p_target_doc_id ' || p_target_doc_id);
1822: END IF;

Line 1819: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_source_doc_type ' || p_source_doc_type);

1815: BEGIN
1816: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1817: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered copy_usages_row');
1818: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_target_doc_type ' || p_target_doc_type);
1819: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_source_doc_type ' || p_source_doc_type);
1820: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_source_doc_id ' || p_source_doc_id);
1821: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500: p_target_doc_id ' || p_target_doc_id);
1822: END IF;
1823:

Line 1820: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_source_doc_id ' || p_source_doc_id);

1816: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1817: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered copy_usages_row');
1818: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_target_doc_type ' || p_target_doc_type);
1819: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_source_doc_type ' || p_source_doc_type);
1820: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_source_doc_id ' || p_source_doc_id);
1821: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500: p_target_doc_id ' || p_target_doc_id);
1822: END IF;
1823:
1824: OPEN l_get_mlp_temp_csr;

Line 1821: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500: p_target_doc_id ' || p_target_doc_id);

1817: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered copy_usages_row');
1818: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_target_doc_type ' || p_target_doc_type);
1819: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: p_source_doc_type ' || p_source_doc_type);
1820: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: p_source_doc_id ' || p_source_doc_id);
1821: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500: p_target_doc_id ' || p_target_doc_id);
1822: END IF;
1823:
1824: OPEN l_get_mlp_temp_csr;
1825: FETCH l_get_mlp_temp_csr BULK COLLECT INTO TemplateIdTbl,

Line 1890: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1886: PrimaryTemplateTbl(i)
1887: );
1888: END IF;
1889:
1890: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1891: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Leaving copy_usages_row '||x_return_status);
1892: END IF;
1893:
1894: EXCEPTION

Line 1891: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Leaving copy_usages_row '||x_return_status);

1887: );
1888: END IF;
1889:
1890: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1891: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Leaving copy_usages_row '||x_return_status);
1892: END IF;
1893:
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN

Line 1896: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1892: END IF;
1893:
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1897: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving copy_usages_row:FND_API.G_EXC_ERROR Exception');
1898: END IF;
1899: x_return_status := G_RET_STS_ERROR;
1900:

Line 1897: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving copy_usages_row:FND_API.G_EXC_ERROR Exception');

1893:
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1897: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving copy_usages_row:FND_API.G_EXC_ERROR Exception');
1898: END IF;
1899: x_return_status := G_RET_STS_ERROR;
1900:
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1902: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1898: END IF;
1899: x_return_status := G_RET_STS_ERROR;
1900:
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1902: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_usages_row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1904: END IF;
1905: x_return_status := G_RET_STS_UNEXP_ERROR;
1906:

Line 1903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_usages_row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1899: x_return_status := G_RET_STS_ERROR;
1900:
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1902: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_usages_row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1904: END IF;
1905: x_return_status := G_RET_STS_UNEXP_ERROR;
1906:
1907: WHEN OTHERS THEN

Line 1908: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1904: END IF;
1905: x_return_status := G_RET_STS_UNEXP_ERROR;
1906:
1907: WHEN OTHERS THEN
1908: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1909: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_usages_row because of EXCEPTION: '||sqlerrm);
1910: END IF;
1911: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1912: p_msg_name => G_UNEXPECTED_ERROR,

Line 1909: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_usages_row because of EXCEPTION: '||sqlerrm);

1905: x_return_status := G_RET_STS_UNEXP_ERROR;
1906:
1907: WHEN OTHERS THEN
1908: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1909: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_usages_row because of EXCEPTION: '||sqlerrm);
1910: END IF;
1911: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1912: p_msg_name => G_UNEXPECTED_ERROR,
1913: p_token1 => G_SQLCODE_TOKEN,