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 231: FND_LOG.STRING(G_PROC_LEVEL,

227: Okc_Debug.Log('4900: Entered Lock_Row', 2);
228: END IF;*/
229:
230: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
231: FND_LOG.STRING(G_PROC_LEVEL,
232: G_PKG_NAME, '4900: Entered Lock_Row' );
233: END IF;
234:
235:

Line 251: FND_LOG.STRING(G_EXCP_LEVEL,

247: Okc_Debug.Log('5000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
248: END IF;*/
249:
250: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
251: FND_LOG.STRING(G_EXCP_LEVEL,
252: G_PKG_NAME, '5000: Leaving Lock_Row:E_Resource_Busy Exception' );
253: END IF;
254:
255: IF (tmpl_csr%ISOPEN) THEN

Line 290: FND_LOG.STRING(G_PROC_LEVEL,

286: Okc_Debug.Log('5100: Leaving Lock_Row', 2);
287: END IF;*/
288:
289: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
290: FND_LOG.STRING(G_PROC_LEVEL,
291: G_PKG_NAME, '5100: Leaving Lock_Row' );
292: END IF;
293:
294: RETURN( l_return_status );

Line 311: FND_LOG.STRING(G_EXCP_LEVEL,

307: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
308: END IF;*/
309:
310: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
311: FND_LOG.STRING(G_EXCP_LEVEL,
312: G_PKG_NAME, '5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
313: END IF;
314:
315: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 418: FND_LOG.STRING(G_PROC_LEVEL,

414: okc_debug.log('100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.start_approval', 2);
415: END IF;*/
416:
417: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
418: FND_LOG.STRING(G_PROC_LEVEL,
419: G_PKG_NAME, '100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.start_approval' );
420: END IF;
421:
422: -- Standard Start of API savepoint

Line 444: FND_LOG.STRING(G_PROC_LEVEL,

440: okc_debug.log('600: opening tmpl_exits_csr', 2);
441: END IF;*/
442:
443: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
444: FND_LOG.STRING(G_PROC_LEVEL,
445: G_PKG_NAME, '600: opening tmpl_exits_csr' );
446: END IF;
447:
448: OPEN tmpl_exists_csr;

Line 457: FND_LOG.STRING(G_PROC_LEVEL,

453: Okc_Debug.Log('2300: - attribute TEMPLATE_ID is invalid', 2);
454: END IF;*/
455:
456: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
457: FND_LOG.STRING(G_PROC_LEVEL,
458: G_PKG_NAME, '2300: - attribute TEMPLATE_ID is invalid' );
459: END IF;
460: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_ID');
461: x_return_status := G_RET_STS_ERROR;

Line 480: FND_LOG.STRING(G_PROC_LEVEL,

476: Okc_Debug.Log('2310: - Status not in DRAFT/REJECTED', 2);
477: END IF;*/
478:
479: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
480: FND_LOG.STRING(G_PROC_LEVEL,
481: G_PKG_NAME, '2310: - Status not in DRAFT/REJECTED' );
482: END IF;
483:
484: 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 577: FND_LOG.STRING(G_PROC_LEVEL,

573: -- Okc_Debug.Log('2320: - Errors found in Template QA', 2);
574: --END IF;
575:
576: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
577: FND_LOG.STRING(G_PROC_LEVEL,
578: G_PKG_NAME, '2320: - Errors found in Template QA' );
579: END IF;
580: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_APP_QA_ERROR');
581: x_return_status := G_RET_STS_ERROR;

Line 827: FND_LOG.STRING(G_PROC_LEVEL,

823: okc_debug.log('1000: Leaving start_approval', 2);
824: END IF;*/
825:
826: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
827: FND_LOG.STRING(G_PROC_LEVEL,
828: G_PKG_NAME, '1000: Leaving start_approval' );
829: END IF;
830:
831: EXCEPTION

Line 840: FND_LOG.STRING(G_EXCP_LEVEL,

836: okc_debug.log('800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception', 2);
837: END IF;*/
838:
839: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
840: FND_LOG.STRING(G_EXCP_LEVEL,
841: G_PKG_NAME, '800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception' );
842: END IF;
843:
844: ROLLBACK TO g_start_approval_pvt;

Line 854: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 868: FND_LOG.STRING(G_EXCP_LEVEL,

864: okc_debug.log('1000: Leaving start_approval because of EXCEPTION: '||sqlerrm, 2);
865: END IF;*/
866:
867: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
868: FND_LOG.STRING(G_EXCP_LEVEL,
869: G_PKG_NAME, '1000: Leaving start_approval because of EXCEPTION: '||sqlerrm );
870: END IF;
871:
872: ROLLBACK TO g_start_approval_pvt;

Line 1503: FND_LOG.STRING(G_PROC_LEVEL,

1499: okc_debug.log('100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.change_clause_status', 2);
1500: END IF;*/
1501:
1502: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1503: FND_LOG.STRING(G_PROC_LEVEL,
1504: G_PKG_NAME, '100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.change_clause_status' );
1505: END IF;
1506:
1507: -- Standard Start of API savepoint

Line 1622: FND_LOG.STRING(G_PROC_LEVEL,

1618: okc_debug.log('1000: Leaving change_clause_status', 2);
1619: END IF;*/
1620:
1621: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1622: FND_LOG.STRING(G_PROC_LEVEL,
1623: G_PKG_NAME, '1000: Leaving change_clause_status' );
1624: END IF;
1625:
1626: EXCEPTION

Line 1635: FND_LOG.STRING(G_EXCP_LEVEL,

1631: okc_debug.log('800: Leaving change_clause_status: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1632: END IF;*/
1633:
1634: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1635: FND_LOG.STRING(G_EXCP_LEVEL,
1636: G_PKG_NAME, '800: Leaving change_clause_status: OKC_API.G_EXCEPTION_ERROR Exception' );
1637: END IF;
1638:
1639: IF (l_tmpl_csr%ISOPEN) THEN

Line 1656: FND_LOG.STRING(G_EXCP_LEVEL,

1652: okc_debug.log('900: Leaving change_clause_status: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1653: END IF;*/
1654:
1655: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1656: FND_LOG.STRING(G_EXCP_LEVEL,
1657: G_PKG_NAME, '900: Leaving change_clause_status: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1658: END IF;
1659:
1660: IF (l_tmpl_csr%ISOPEN) THEN

Line 1677: FND_LOG.STRING(G_EXCP_LEVEL,

1673: okc_debug.log('1000: Leaving change_clause_status because of EXCEPTION: '||sqlerrm, 2);
1674: END IF;*/
1675:
1676: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1677: FND_LOG.STRING(G_EXCP_LEVEL,
1678: G_PKG_NAME, '1000: Leaving change_clause_status because of EXCEPTION: '||sqlerrm );
1679: END IF;
1680:
1681: IF (l_tmpl_csr%ISOPEN) THEN

Line 2075: FND_LOG.STRING(G_PROC_LEVEL,

2071: okc_debug.log('100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.select_draft_clauses, p_template_id' || p_template_id, 2);
2072: END IF;*/
2073:
2074: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2075: FND_LOG.STRING(G_PROC_LEVEL,
2076: G_PKG_NAME, '100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.select_draft_clauses, p_template_id' || p_template_id );
2077: END IF;
2078:
2079: -- Standard Start of API savepoint

Line 2113: FND_LOG.STRING(G_PROC_LEVEL,

2109: okc_debug.log('1000: Leaving select_draft_clauses', 2);
2110: END IF;*/
2111:
2112: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2113: FND_LOG.STRING(G_PROC_LEVEL,
2114: G_PKG_NAME, '1000: Leaving select_draft_clauses' );
2115: END IF;
2116:
2117: EXCEPTION

Line 2126: FND_LOG.STRING(G_EXCP_LEVEL,

2122: okc_debug.log('800: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2123: END IF;*/
2124:
2125: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2126: FND_LOG.STRING(G_EXCP_LEVEL,
2127: G_PKG_NAME, '800: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_ERROR Exception' );
2128: END IF;
2129:
2130: ROLLBACK TO change_clause_status_pvt;

Line 2140: FND_LOG.STRING(G_EXCP_LEVEL,

2136: okc_debug.log('900: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2137: END IF;*/
2138:
2139: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2140: FND_LOG.STRING(G_EXCP_LEVEL,
2141: G_PKG_NAME, '900: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
2142: END IF;
2143:
2144: ROLLBACK TO change_clause_status_pvt;

Line 2154: FND_LOG.STRING(G_EXCP_LEVEL,

2150: okc_debug.log('1000: Leaving select_draft_clauses because of EXCEPTION: '||sqlerrm, 2);
2151: END IF;*/
2152:
2153: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2154: FND_LOG.STRING(G_EXCP_LEVEL,
2155: G_PKG_NAME, '1000: Leaving select_draft_clauses because of EXCEPTION: '||sqlerrm );
2156: END IF;
2157:
2158: ROLLBACK TO change_clause_status_pvt;