[Home] [Help]
1: PACKAGE BODY OKC_TERMS_TMPL_APPROVAL_PVT as
2: /* $Header: OKCVTMPLAPPB.pls 120.7.12020000.4 2013/02/06 08:13:29 skavutha ship $ */
3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
17:
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
210: WHEN OTHERS THEN
211: IF (get_resp_id_csr%ISOPEN) THEN
212: CLOSE get_resp_id_csr;
213: END IF;
214: WF_CORE.context('OKC_TERMS_TMPL_APPROVAL_PVT','Selector',itemtype,itemkey,actid,funcmode);
215: RAISE;
216: END selector;
217:
218: ---------------------------------------------------------------------------
425:
426: BEGIN
427:
428: /*IF (l_debug = 'Y') THEN
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,
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
438: SAVEPOINT g_start_approval_PVT;
1210:
1211: EXCEPTION
1212: WHEN clause_sts_exception_1 THEN
1213: -- try to send as much info as possible to the workflow error stack from validation results
1214: WF_CORE.CONTEXT('OKC_TERMS_TMPL_APPROVAL_PVT', 'Change_clause_status', itemtype,
1215: itemkey, to_char(actid)||funcmode,
1216: get_error_string(l_validation_results));
1217: RAISE;
1218:
1232: itemkey, to_char(actid), funcmode);
1233: RAISE;
1234:
1235: WHEN OTHERS THEN
1236: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'Reject_Template', itemtype,
1237: itemkey, to_char(actid), funcmode);
1238: RAISE;
1239: END reject_template;
1240:
1544:
1545: BEGIN
1546:
1547: /*IF (l_debug = 'Y') THEN
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,
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
1557: SAVEPOINT change_clause_status_pvt;
1835: END IF;
1836: EXCEPTION
1837:
1838: WHEN OTHERS THEN
1839: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified_list', itemtype,
1840: itemkey, to_char(actid), funcmode);
1841: RAISE;
1842: END set_notified_list;
1843:
1939: RETURN;
1940: END IF; --if func mode is 'RUN'
1941: EXCEPTION
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified ', itemtype,
1944: itemkey, to_char(actid), funcmode);
1945: RAISE;
1946: WHEN OTHERS THEN
1947: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified', itemtype,
1943: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified ', itemtype,
1944: itemkey, to_char(actid), funcmode);
1945: RAISE;
1946: WHEN OTHERS THEN
1947: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified', itemtype,
1948: itemkey, to_char(actid), funcmode);
1949: RAISE;
1950: END set_notified;
1951:
1988: RETURN;
1989: END IF; -- if funcmode = 'RUN'
1990: EXCEPTION
1991: WHEN OTHERS THEN
1992: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'decrement_counter', itemtype,
1993: itemkey, to_char(actid), funcmode);
1994: RAISE;
1995: END decrement_counter;
1996:
2106: RETURN;
2107: END IF; -- if funcmode = 'RUN'
2108: EXCEPTION
2109: WHEN OTHERS THEN
2110: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'global_articles_exist', itemtype,
2111: itemkey, to_char(actid), funcmode);
2112: RAISE;
2113: END global_articles_exist;
2114:
2137:
2138: BEGIN
2139:
2140: /*IF (l_debug = 'Y') THEN
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,
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
2150: SAVEPOINT select_draft_clauses_pvt;
2232: END IF;
2233: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2234: END select_draft_clauses;
2235:
2236: end OKC_TERMS_TMPL_APPROVAL_PVT;