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_XPRT_TMPL_RULE_ASSNS_PVT dependencies on FND_LOG

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

7: ------------------------------------------------------------------------------
8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_TMPL_RULE_ASSNS_PVT';
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10:
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
13: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
14:
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

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

88:
89: BEGIN
90:
91: -- start debug log
92: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
93: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
94: G_MODULE||l_api_name,
95: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 93: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

89: BEGIN
90:
91: -- start debug log
92: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
93: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
94: G_MODULE||l_api_name,
95: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
97: G_MODULE||l_api_name,

Line 96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

92: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
93: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
94: G_MODULE||l_api_name,
95: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
97: G_MODULE||l_api_name,
98: '100: p_source_template_id : '||p_source_template_id);
99: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
100: G_MODULE||l_api_name,

Line 99: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

95: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
97: G_MODULE||l_api_name,
98: '100: p_source_template_id : '||p_source_template_id);
99: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
100: G_MODULE||l_api_name,
101: '100: p_target_template_id : '||p_target_template_id);
102: END IF;
103:

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

123: FETCH csr_template_org INTO l_target_template_org_id;
124: CLOSE csr_template_org;
125:
126: -- debug log
127: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
128: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
129: G_MODULE||l_api_name,
130: '110: l_source_template_org_id : '||l_source_template_org_id);
131: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 128: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

124: CLOSE csr_template_org;
125:
126: -- debug log
127: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
128: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
129: G_MODULE||l_api_name,
130: '110: l_source_template_org_id : '||l_source_template_org_id);
131: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
132: G_MODULE||l_api_name,

Line 131: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

127: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
128: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
129: G_MODULE||l_api_name,
130: '110: l_source_template_org_id : '||l_source_template_org_id);
131: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
132: G_MODULE||l_api_name,
133: '110: l_target_template_org_id : '||l_target_template_org_id);
134: END IF;
135:

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

234: -- Standard call to get message count and if count is 1, get message info.
235: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
236:
237: -- end debug log
238: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
240: G_MODULE||l_api_name,
241: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
242: END IF;

Line 239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

235: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
236:
237: -- end debug log
238: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
240: G_MODULE||l_api_name,
241: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
242: END IF;
243:

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

243:
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
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: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
251: END IF;

Line 248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
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: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
251: END IF;
252:

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

254: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257:
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
260: G_MODULE||l_api_name,
261: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
262: END IF;

Line 259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257:
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
260: G_MODULE||l_api_name,
261: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
262: END IF;
263:

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

265: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
266:
267: WHEN OTHERS THEN
268:
269: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
271: G_MODULE||l_api_name,
272: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
273: END IF;

Line 270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

266:
267: WHEN OTHERS THEN
268:
269: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
271: G_MODULE||l_api_name,
272: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
273: END IF;
274:

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

302:
303: BEGIN
304:
305: -- start debug log
306: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
307: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
308: G_MODULE||l_api_name,
309: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
310: END IF;

Line 307: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

303: BEGIN
304:
305: -- start debug log
306: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
307: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
308: G_MODULE||l_api_name,
309: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
310: END IF;
311:

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

336: -- Standard call to get message count and if count is 1, get message info.
337: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
338:
339: -- end debug log
340: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
342: G_MODULE||l_api_name,
343: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
344: END IF;

Line 341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

337: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
338:
339: -- end debug log
340: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
342: G_MODULE||l_api_name,
343: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
344: END IF;
345:

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

345:
346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348:
349: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
351: G_MODULE||l_api_name,
352: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
353: END IF;

Line 350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348:
349: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
351: G_MODULE||l_api_name,
352: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
353: END IF;
354:

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

356: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359:
360: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
361: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
362: G_MODULE||l_api_name,
363: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
364: END IF;

Line 361: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359:
360: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
361: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
362: G_MODULE||l_api_name,
363: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
364: END IF;
365:

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

367: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
368:
369: WHEN OTHERS THEN
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: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
375: END IF;

Line 372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

368:
369: WHEN OTHERS THEN
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: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
375: END IF;
376:

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

410:
411: BEGIN
412:
413: -- start debug log
414: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
416: G_MODULE||l_api_name,
417: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
418: END IF;

Line 415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

411: BEGIN
412:
413: -- start debug log
414: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
416: G_MODULE||l_api_name,
417: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
418: END IF;
419:

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

480: -- Standard call to get message count and if count is 1, get message info.
481: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
482:
483: -- end debug log
484: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
486: G_MODULE||l_api_name,
487: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
488: END IF;

Line 485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

481: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
482:
483: -- end debug log
484: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
486: G_MODULE||l_api_name,
487: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
488: END IF;
489:

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

489:
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN
492:
493: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
495: G_MODULE||l_api_name,
496: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
497: END IF;

Line 494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN
492:
493: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
495: G_MODULE||l_api_name,
496: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
497: END IF;
498:

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

500: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503:
504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
506: G_MODULE||l_api_name,
507: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
508: END IF;

Line 505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503:
504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
506: G_MODULE||l_api_name,
507: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
508: END IF;
509:

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

511: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
512:
513: WHEN OTHERS THEN
514:
515: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
517: G_MODULE||l_api_name,
518: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
519: END IF;

Line 516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

512:
513: WHEN OTHERS THEN
514:
515: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
517: G_MODULE||l_api_name,
518: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
519: END IF;
520: