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

Line 42: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

38:
39: G_OKC_MSG_INVALID_ARGUMENT CONSTANT VARCHAR2(200) := 'OKC_INVALID_ARGUMENT';
40: -- ARG_NAME ARG_VALUE is invalid.
41:
42: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
43: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
44: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
45:
46:

Line 43: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

39: G_OKC_MSG_INVALID_ARGUMENT CONSTANT VARCHAR2(200) := 'OKC_INVALID_ARGUMENT';
40: -- ARG_NAME ARG_VALUE is invalid.
41:
42: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
43: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
44: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
45:
46:
47: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 44: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

40: -- ARG_NAME ARG_VALUE is invalid.
41:
42: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
43: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
44: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
45:
46:
47: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
48:

Line 246: FND_LOG.STRING(G_PROC_LEVEL,

242: Okc_Debug.Log('4900: Entered Lock_Row', 2);
243: END IF;*/
244:
245: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
246: FND_LOG.STRING(G_PROC_LEVEL,
247: G_PKG_NAME, '4900: Entered Lock_Row' );
248: END IF;
249:
250:

Line 266: FND_LOG.STRING(G_EXCP_LEVEL,

262: Okc_Debug.Log('5000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
263: END IF;*/
264:
265: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
266: FND_LOG.STRING(G_EXCP_LEVEL,
267: G_PKG_NAME, '5000: Leaving Lock_Row:E_Resource_Busy Exception' );
268: END IF;
269:
270: IF (tmpl_csr%ISOPEN) THEN

Line 305: FND_LOG.STRING(G_PROC_LEVEL,

301: Okc_Debug.Log('5100: Leaving Lock_Row', 2);
302: END IF;*/
303:
304: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
305: FND_LOG.STRING(G_PROC_LEVEL,
306: G_PKG_NAME, '5100: Leaving Lock_Row' );
307: END IF;
308:
309: RETURN( l_return_status );

Line 326: FND_LOG.STRING(G_EXCP_LEVEL,

322: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
323: END IF;*/
324:
325: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
326: FND_LOG.STRING(G_EXCP_LEVEL,
327: G_PKG_NAME, '5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
328: END IF;
329:
330: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 433: FND_LOG.STRING(G_PROC_LEVEL,

429: okc_debug.log('100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.start_approval', 2);
430: END IF;*/
431:
432: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
433: FND_LOG.STRING(G_PROC_LEVEL,
434: G_PKG_NAME, '100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.start_approval' );
435: END IF;
436:
437: -- Standard Start of API savepoint

Line 459: FND_LOG.STRING(G_PROC_LEVEL,

455: okc_debug.log('600: opening tmpl_exits_csr', 2);
456: END IF;*/
457:
458: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
459: FND_LOG.STRING(G_PROC_LEVEL,
460: G_PKG_NAME, '600: opening tmpl_exits_csr' );
461: END IF;
462:
463: OPEN tmpl_exists_csr;

Line 472: FND_LOG.STRING(G_PROC_LEVEL,

468: Okc_Debug.Log('2300: - attribute TEMPLATE_ID is invalid', 2);
469: END IF;*/
470:
471: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
472: FND_LOG.STRING(G_PROC_LEVEL,
473: G_PKG_NAME, '2300: - attribute TEMPLATE_ID is invalid' );
474: END IF;
475: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_ID');
476: x_return_status := G_RET_STS_ERROR;

Line 495: FND_LOG.STRING(G_PROC_LEVEL,

491: Okc_Debug.Log('2310: - Status not in DRAFT/REJECTED', 2);
492: END IF;*/
493:
494: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
495: FND_LOG.STRING(G_PROC_LEVEL,
496: G_PKG_NAME, '2310: - Status not in DRAFT/REJECTED' );
497: END IF;
498:
499: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_APP_INVALID_STATUS','STATUS',okc_util.decode_lookup('OKC_TERMS_TMPL_STATUS',l_tmpl_rec.status_code));

Line 592: FND_LOG.STRING(G_PROC_LEVEL,

588: -- Okc_Debug.Log('2320: - Errors found in Template QA', 2);
589: --END IF;
590:
591: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
592: FND_LOG.STRING(G_PROC_LEVEL,
593: G_PKG_NAME, '2320: - Errors found in Template QA' );
594: END IF;
595: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_APP_QA_ERROR');
596: x_return_status := G_RET_STS_ERROR;

Line 842: FND_LOG.STRING(G_PROC_LEVEL,

838: okc_debug.log('1000: Leaving start_approval', 2);
839: END IF;*/
840:
841: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
842: FND_LOG.STRING(G_PROC_LEVEL,
843: G_PKG_NAME, '1000: Leaving start_approval' );
844: END IF;
845:
846: EXCEPTION

Line 855: FND_LOG.STRING(G_EXCP_LEVEL,

851: okc_debug.log('800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception', 2);
852: END IF;*/
853:
854: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
855: FND_LOG.STRING(G_EXCP_LEVEL,
856: G_PKG_NAME, '800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception' );
857: END IF;
858:
859: ROLLBACK TO g_start_approval_pvt;

Line 869: FND_LOG.STRING(G_EXCP_LEVEL,

865: okc_debug.log('900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
866: END IF;*/
867:
868: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
869: FND_LOG.STRING(G_EXCP_LEVEL,
870: G_PKG_NAME, '900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
871: END IF;
872:
873: ROLLBACK TO g_start_approval_pvt;

Line 883: FND_LOG.STRING(G_EXCP_LEVEL,

879: okc_debug.log('1000: Leaving start_approval because of EXCEPTION: '||sqlerrm, 2);
880: END IF;*/
881:
882: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
883: FND_LOG.STRING(G_EXCP_LEVEL,
884: G_PKG_NAME, '1000: Leaving start_approval because of EXCEPTION: '||sqlerrm );
885: END IF;
886:
887: ROLLBACK TO g_start_approval_pvt;

Line 1552: FND_LOG.STRING(G_PROC_LEVEL,

1548: okc_debug.log('100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.change_clause_status', 2);
1549: END IF;*/
1550:
1551: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1552: FND_LOG.STRING(G_PROC_LEVEL,
1553: G_PKG_NAME, '100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.change_clause_status' );
1554: END IF;
1555:
1556: -- Standard Start of API savepoint

Line 1671: FND_LOG.STRING(G_PROC_LEVEL,

1667: okc_debug.log('1000: Leaving change_clause_status', 2);
1668: END IF;*/
1669:
1670: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1671: FND_LOG.STRING(G_PROC_LEVEL,
1672: G_PKG_NAME, '1000: Leaving change_clause_status' );
1673: END IF;
1674:
1675: EXCEPTION

Line 1684: FND_LOG.STRING(G_EXCP_LEVEL,

1680: okc_debug.log('800: Leaving change_clause_status: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1681: END IF;*/
1682:
1683: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1684: FND_LOG.STRING(G_EXCP_LEVEL,
1685: G_PKG_NAME, '800: Leaving change_clause_status: OKC_API.G_EXCEPTION_ERROR Exception' );
1686: END IF;
1687:
1688: IF (l_tmpl_csr%ISOPEN) THEN

Line 1705: FND_LOG.STRING(G_EXCP_LEVEL,

1701: okc_debug.log('900: Leaving change_clause_status: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1702: END IF;*/
1703:
1704: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1705: FND_LOG.STRING(G_EXCP_LEVEL,
1706: G_PKG_NAME, '900: Leaving change_clause_status: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1707: END IF;
1708:
1709: IF (l_tmpl_csr%ISOPEN) THEN

Line 1726: FND_LOG.STRING(G_EXCP_LEVEL,

1722: okc_debug.log('1000: Leaving change_clause_status because of EXCEPTION: '||sqlerrm, 2);
1723: END IF;*/
1724:
1725: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1726: FND_LOG.STRING(G_EXCP_LEVEL,
1727: G_PKG_NAME, '1000: Leaving change_clause_status because of EXCEPTION: '||sqlerrm );
1728: END IF;
1729:
1730: IF (l_tmpl_csr%ISOPEN) THEN

Line 2090: FND_LOG.STRING(G_PROC_LEVEL,

2086: and hr.organization_id <> global_org_id;
2087:
2088: IF l_org_count = 0 THEN
2089: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2090: FND_LOG.STRING(G_PROC_LEVEL,
2091: G_PKG_NAME, 'NO active local orgs exist.' );
2092: END IF;
2093:
2094: resultout := 'COMPLETE:F';

Line 2145: FND_LOG.STRING(G_PROC_LEVEL,

2141: okc_debug.log('100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.select_draft_clauses, p_template_id' || p_template_id, 2);
2142: END IF;*/
2143:
2144: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2145: FND_LOG.STRING(G_PROC_LEVEL,
2146: G_PKG_NAME, '100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.select_draft_clauses, p_template_id' || p_template_id );
2147: END IF;
2148:
2149: -- Standard Start of API savepoint

Line 2183: FND_LOG.STRING(G_PROC_LEVEL,

2179: okc_debug.log('1000: Leaving select_draft_clauses', 2);
2180: END IF;*/
2181:
2182: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2183: FND_LOG.STRING(G_PROC_LEVEL,
2184: G_PKG_NAME, '1000: Leaving select_draft_clauses' );
2185: END IF;
2186:
2187: EXCEPTION

Line 2196: FND_LOG.STRING(G_EXCP_LEVEL,

2192: okc_debug.log('800: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2193: END IF;*/
2194:
2195: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2196: FND_LOG.STRING(G_EXCP_LEVEL,
2197: G_PKG_NAME, '800: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_ERROR Exception' );
2198: END IF;
2199:
2200: ROLLBACK TO change_clause_status_pvt;

Line 2210: FND_LOG.STRING(G_EXCP_LEVEL,

2206: okc_debug.log('900: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2207: END IF;*/
2208:
2209: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2210: FND_LOG.STRING(G_EXCP_LEVEL,
2211: G_PKG_NAME, '900: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
2212: END IF;
2213:
2214: ROLLBACK TO change_clause_status_pvt;

Line 2224: FND_LOG.STRING(G_EXCP_LEVEL,

2220: okc_debug.log('1000: Leaving select_draft_clauses because of EXCEPTION: '||sqlerrm, 2);
2221: END IF;*/
2222:
2223: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2224: FND_LOG.STRING(G_EXCP_LEVEL,
2225: G_PKG_NAME, '1000: Leaving select_draft_clauses because of EXCEPTION: '||sqlerrm );
2226: END IF;
2227:
2228: ROLLBACK TO change_clause_status_pvt;