DBA Data[Home] [Help]

APPS.OKC_TERMS_TMPL_APPROVAL_GRP dependencies on OKC_API

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

5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_TMPL_APPROVAL_GRP';

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

10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_TMPL_APPROVAL_GRP';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------

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

24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
28: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
29: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
30: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
31: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
32: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;

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

25:
26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
28: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
29: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
30: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
31: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
32: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;
33:

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

27: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
28: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
29: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
30: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
31: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
32: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;
33:
34: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
35: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

151: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
152: FND_LOG.STRING(G_PROC_LEVEL,
153: G_PKG_NAME, '300: - attribute TEMPLATE_ID is invalid' );
154: END IF;
155: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_ID');
156: x_return_status := G_RET_STS_ERROR;
157: END IF;
158: CLOSE tmpl_csr;
159:

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

201: EXCEPTION
202:
203: WHEN FND_API.G_EXC_ERROR THEN
204: /*IF (l_debug = 'Y') THEN
205: okc_debug.log('800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception', 2);
206: END IF;*/
207:
208: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
209: FND_LOG.STRING(G_EXCP_LEVEL,

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

206: END IF;*/
207:
208: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
209: FND_LOG.STRING(G_EXCP_LEVEL,
210: G_PKG_NAME, '800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception' );
211: END IF;
212:
213: ROLLBACK TO g_start_approval_grp;
214: x_return_status := G_RET_STS_ERROR ;

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

215: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
216:
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: /*IF (l_debug = 'Y') THEN
219: okc_debug.log('900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
220: END IF;*/
221:
222: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
223: FND_LOG.STRING(G_EXCP_LEVEL,

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

220: END IF;*/
221:
222: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
223: FND_LOG.STRING(G_EXCP_LEVEL,
224: G_PKG_NAME, '900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
225: END IF;
226:
227: ROLLBACK TO g_start_approval_grp;
228: x_return_status := G_RET_STS_UNEXP_ERROR ;