DBA Data[Home] [Help]

APPS.OKC_OM_INT_GRP dependencies on FND_API

Line 19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

Line 21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
25: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

Line 22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;

18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
25: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
26: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

Line 23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR ;
23: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
25: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
26: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
27:

Line 44: x_return_status := FND_API.G_RET_STS_SUCCESS;

40: l_debug Boolean;
41: l_module VARCHAR2(250) := G_MODULE_NAME||l_api_name;
42:
43: BEGIN
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:
46: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
47: l_debug := true;
48: END IF;

Line 58: p_init_msg_list => FND_API.G_FALSE,

54: END IF;
55:
56: OKC_XPRT_OM_INT_PVT.get_clause_variable_values(
57: p_api_version => l_api_version,
58: p_init_msg_list => FND_API.G_FALSE,
59: p_doc_type => p_doc_type,
60: p_doc_id => p_doc_id,
61: p_sys_var_value_tbl => p_sys_var_value_tbl,
62: x_return_status => x_return_status,

Line 72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

68: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'25:Status from OKC_XPRT_OM_INT_PVT.get_clause_variable_values = '||x_return_status);
69: END IF;
70:
71: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
73: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
74: RAISE FND_API.G_EXC_ERROR ;
75: END IF;
76:

Line 74: RAISE FND_API.G_EXC_ERROR ;

70:
71: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
73: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
74: RAISE FND_API.G_EXC_ERROR ;
75: END IF;
76:
77: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
78: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'30:Leaving OKC_OM_INT_GRP.get_article_variable_values');

Line 84: WHEN FND_API.G_EXC_ERROR THEN

80:
81: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
82:
83: EXCEPTION
84: WHEN FND_API.G_EXC_ERROR THEN
85:
86: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
87: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'40: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception');
88: END IF;

Line 93: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

89:
90: x_return_status := G_RET_STS_ERROR ;
91: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
92:
93: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
94: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
95: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'50: Leaving get_article_variable_values: OKC_API.G_EXCEPT ION_UNEXPECTED_ERROR Exception');
96: END IF;
97:

Line 137: Return FND_API.G_TRUE;

133: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
134: l_debug := true;
135: END IF;
136:
137: Return FND_API.G_TRUE;
138:
139: EXCEPTION
140:
141: WHEN FND_API.G_EXC_ERROR THEN

Line 141: WHEN FND_API.G_EXC_ERROR THEN

137: Return FND_API.G_TRUE;
138:
139: EXCEPTION
140:
141: WHEN FND_API.G_EXC_ERROR THEN
142: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'70: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception');
144: END IF;
145:

Line 149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

145:
146: x_return_status := G_RET_STS_ERROR ;
147: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
148:
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
151: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'80: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
152: END IF;
153:

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: l_cat_index NUMBER := -1;
190: l_item_index NUMBER := -1;
191:
192: BEGIN
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194:
195: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: l_debug := true;
197: END IF;

Line 210: p_init_msg_list => FND_API.G_FALSE,

206: l_line_var_tbl(1) :='OKC$S_ITEM';
207:
208: OKC_XPRT_OM_INT_PVT.get_clause_variable_values(
209: p_api_version => l_api_version,
210: p_init_msg_list => FND_API.G_FALSE,
211: p_doc_type => p_doc_type,
212: p_doc_id => p_doc_id,
213: p_line_var_tbl => l_line_var_tbl,
214: x_line_var_value_tbl => l_sys_var_value_tbl,

Line 225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

221: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'115:Status from OKC_XPRT_OM_INT_PVT.Get_clause_Variable_Values - 2 = '||x_return_status);
222: END IF;
223:
224: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
226: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
227: RAISE FND_API.G_EXC_ERROR ;
228: END IF;
229:

Line 227: RAISE FND_API.G_EXC_ERROR ;

223:
224: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
226: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
227: RAISE FND_API.G_EXC_ERROR ;
228: END IF;
229:
230: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
231: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');

Line 262: WHEN FND_API.G_EXC_ERROR THEN

258: END IF;
259: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
260:
261: EXCEPTION
262: WHEN FND_API.G_EXC_ERROR THEN
263:
264: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
265: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'150: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception');
266: END IF;

Line 271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

267:
268: x_return_status := G_RET_STS_ERROR ;
269: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
270:
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
273: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'160: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPT ION_UNEXPECTED_ERROR Exception');
274: END IF;
275: