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 OKC_API

Line 7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
9: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
10: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 8: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;

4: ---------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
9: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
10: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 9: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;

5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
9: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
10: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 10: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;

6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
9: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
10: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
9: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
10: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

8: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
9: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
10: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

9: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
10: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
17:

Line 14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

10: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
17:
18: ---------------------------------------------------------------------------

Line 15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
17:
18: ---------------------------------------------------------------------------
19: -- GLOBAL VARIABLES

Line 16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
17:
18: ---------------------------------------------------------------------------
19: -- GLOBAL VARIABLES
20: ---------------------------------------------------------------------------

Line 22: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

18: ---------------------------------------------------------------------------
19: -- GLOBAL VARIABLES
20: ---------------------------------------------------------------------------
21: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_TMPL_APPROVAL_PVT';
22: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
23:
24: ------------------------------------------------------------------------------
25: -- GLOBAL CONSTANTS
26: ------------------------------------------------------------------------------

Line 274: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);

270: IF (tmpl_csr%ISOPEN) THEN
271: CLOSE tmpl_csr;
272: END IF;
273:
274: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
275: RETURN( G_RET_STS_ERROR );
276: END; -- end inner block
277:
278: IF ( l_row_notfound ) THEN

Line 288: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);

284: l_row_notfound := lchk_csr%NOTFOUND;
285: CLOSE lchk_csr;
286:
287: IF (l_row_notfound) THEN
288: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
289: ELSIF l_object_version_number > p_object_version_number THEN
290: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
291: ELSIF l_object_version_number = -1 THEN
292: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line 290: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

286:
287: IF (l_row_notfound) THEN
288: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
289: ELSIF l_object_version_number > p_object_version_number THEN
290: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
291: ELSIF l_object_version_number = -1 THEN
292: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
293: ELSE -- it can be the only above condition. It can happen after restore version
294: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

Line 292: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

288: Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
289: ELSIF l_object_version_number > p_object_version_number THEN
290: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
291: ELSIF l_object_version_number = -1 THEN
292: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
293: ELSE -- it can be the only above condition. It can happen after restore version
294: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
295: END IF;
296: ELSE

Line 294: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

290: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
291: ELSIF l_object_version_number = -1 THEN
292: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
293: ELSE -- it can be the only above condition. It can happen after restore version
294: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
295: END IF;
296: ELSE
297: l_return_status := G_RET_STS_SUCCESS;
298: END IF;

Line 330: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

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,
331: p_msg_name => G_UNEXPECTED_ERROR,
332: p_token1 => G_SQLCODE_TOKEN,
333: p_token1_value => sqlcode,
334: p_token2 => G_SQLERRM_TOKEN,

Line 475: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_ID');

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;
477: END IF;
478: CLOSE tmpl_exists_csr;
479: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 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));

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));
500: x_return_status := G_RET_STS_ERROR;
501: END IF;
502: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 552: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_APP_NO_ARTICLE_SELL');

548: FETCH article_exists_cur INTO l_dummy_var;
549: IF article_exists_cur%NOTFOUND THEN
550: IF (l_tmpl_rec.intent = 'S') THEN
551: -- Added new message for sell side template for bug 3699018
552: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_APP_NO_ARTICLE_SELL');
553: ELSE
554: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_APP_NO_ARTICLE');
555: END IF;
556: x_return_status := G_RET_STS_ERROR;

Line 554: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_APP_NO_ARTICLE');

550: IF (l_tmpl_rec.intent = 'S') THEN
551: -- Added new message for sell side template for bug 3699018
552: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_APP_NO_ARTICLE_SELL');
553: ELSE
554: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_APP_NO_ARTICLE');
555: END IF;
556: x_return_status := G_RET_STS_ERROR;
557: END IF;
558: CLOSE article_exists_cur;

Line 595: Okc_Api.Set_Message(G_APP_NAME, 'OKC_TMPL_APP_QA_ERROR');

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;
597: END IF;
598: */
599: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 851: okc_debug.log('800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception', 2);

847:
848: WHEN FND_API.G_EXC_ERROR THEN
849:
850: /*IF (l_debug = 'Y') THEN
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,

Line 856: G_PKG_NAME, '800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception' );

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;
860: x_return_status := G_RET_STS_ERROR ;

Line 865: okc_debug.log('900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

861: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: /*IF (l_debug = 'Y') THEN
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,

Line 870: G_PKG_NAME, '900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

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;
874: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1680: okc_debug.log('800: Leaving change_clause_status: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1676:
1677: WHEN FND_API.G_EXC_ERROR THEN
1678:
1679: /*IF (l_debug = 'Y') THEN
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,

Line 1685: G_PKG_NAME, '800: Leaving change_clause_status: OKC_API.G_EXCEPTION_ERROR Exception' );

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
1689: CLOSE l_tmpl_csr;

Line 1701: okc_debug.log('900: Leaving change_clause_status: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1697: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1698:
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700: /*IF (l_debug = 'Y') THEN
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,

Line 1706: G_PKG_NAME, '900: Leaving change_clause_status: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

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
1710: CLOSE l_tmpl_csr;

Line 2192: okc_debug.log('800: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_ERROR Exception', 2);

2188:
2189: WHEN FND_API.G_EXC_ERROR THEN
2190:
2191: /*IF (l_debug = 'Y') THEN
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,

Line 2197: G_PKG_NAME, '800: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_ERROR Exception' );

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;
2201: x_return_status := G_RET_STS_ERROR ;

Line 2206: okc_debug.log('900: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2202: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2203:
2204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2205: /*IF (l_debug = 'Y') THEN
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,

Line 2211: G_PKG_NAME, '900: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

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;
2215: x_return_status := G_RET_STS_UNEXP_ERROR ;