DBA Data[Home] [Help]

APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on OKC_TERMS_TMPL_APPROVAL_PVT

Line 1: PACKAGE BODY OKC_TERMS_TMPL_APPROVAL_PVT as

1: PACKAGE BODY OKC_TERMS_TMPL_APPROVAL_PVT as
2: /* $Header: OKCVTMPLAPPB.pls 120.5.12000000.2 2007/10/10 12:37:55 kkolukul ship $ */
3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS

Line 21: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_TMPL_APPROVAL_PVT';

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

Line 199: WF_CORE.context('OKC_TERMS_TMPL_APPROVAL_PVT','Selector',itemtype,itemkey,actid,funcmode);

195: END IF;
196:
197: EXCEPTION
198: WHEN OTHERS THEN
199: WF_CORE.context('OKC_TERMS_TMPL_APPROVAL_PVT','Selector',itemtype,itemkey,actid,funcmode);
200: RAISE;
201: END selector;
202:
203: ---------------------------------------------------------------------------

Line 414: okc_debug.log('100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.start_approval', 2);

410:
411: BEGIN
412:
413: /*IF (l_debug = 'Y') THEN
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,

Line 419: G_PKG_NAME, '100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.start_approval' );

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
423: SAVEPOINT g_start_approval_PVT;

Line 1165: WF_CORE.CONTEXT('OKC_TERMS_TMPL_APPROVAL_PVT', 'Change_clause_status', itemtype,

1161:
1162: EXCEPTION
1163: WHEN clause_sts_exception_1 THEN
1164: -- try to send as much info as possible to the workflow error stack from validation results
1165: WF_CORE.CONTEXT('OKC_TERMS_TMPL_APPROVAL_PVT', 'Change_clause_status', itemtype,
1166: itemkey, to_char(actid)||funcmode,
1167: get_error_string(l_validation_results));
1168: RAISE;
1169:

Line 1187: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'Reject_Template', itemtype,

1183: itemkey, to_char(actid), funcmode);
1184: RAISE;
1185:
1186: WHEN OTHERS THEN
1187: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'Reject_Template', itemtype,
1188: itemkey, to_char(actid), funcmode);
1189: RAISE;
1190: END reject_template;
1191:

Line 1499: okc_debug.log('100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.change_clause_status', 2);

1495:
1496: BEGIN
1497:
1498: /*IF (l_debug = 'Y') THEN
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,

Line 1504: G_PKG_NAME, '100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.change_clause_status' );

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
1508: SAVEPOINT change_clause_status_pvt;

Line 1790: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified_list', itemtype,

1786: END IF;
1787: EXCEPTION
1788:
1789: WHEN OTHERS THEN
1790: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified_list', itemtype,
1791: itemkey, to_char(actid), funcmode);
1792: RAISE;
1793: END set_notified_list;
1794:

Line 1894: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified ', itemtype,

1890: RETURN;
1891: END IF; --if func mode is 'RUN'
1892: EXCEPTION
1893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1894: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified ', itemtype,
1895: itemkey, to_char(actid), funcmode);
1896: RAISE;
1897: WHEN OTHERS THEN
1898: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified', itemtype,

Line 1898: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified', itemtype,

1894: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified ', itemtype,
1895: itemkey, to_char(actid), funcmode);
1896: RAISE;
1897: WHEN OTHERS THEN
1898: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'set_notified', itemtype,
1899: itemkey, to_char(actid), funcmode);
1900: RAISE;
1901: END set_notified;
1902:

Line 1943: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'decrement_counter', itemtype,

1939: RETURN;
1940: END IF; -- if funcmode = 'RUN'
1941: EXCEPTION
1942: WHEN OTHERS THEN
1943: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'decrement_counter', itemtype,
1944: itemkey, to_char(actid), funcmode);
1945: RAISE;
1946: END decrement_counter;
1947:

Line 2040: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'global_articles_exist', itemtype,

2036: RETURN;
2037: END IF; -- if funcmode = 'RUN'
2038: EXCEPTION
2039: WHEN OTHERS THEN
2040: WF_CORE.CONTEXT ( 'OKC_TERMS_TMPL_APPROVAL_PVT', 'global_articles_exist', itemtype,
2041: itemkey, to_char(actid), funcmode);
2042: RAISE;
2043: END global_articles_exist;
2044:

Line 2071: okc_debug.log('100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.select_draft_clauses, p_template_id' || p_template_id, 2);

2067:
2068: BEGIN
2069:
2070: /*IF (l_debug = 'Y') THEN
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,

Line 2076: G_PKG_NAME, '100: Entered OKC_TERMS_TMPL_APPROVAL_PVT.select_draft_clauses, p_template_id' || p_template_id );

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
2080: SAVEPOINT select_draft_clauses_pvt;

Line 2166: end OKC_TERMS_TMPL_APPROVAL_PVT;

2162: END IF;
2163: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2164: END select_draft_clauses;
2165:
2166: end OKC_TERMS_TMPL_APPROVAL_PVT;