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_OM_INT_GRP dependencies on FND_LOG

Line 13: G_STMT_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

9: -- GLOBAL VARIABLES
10: ---------------------------------------------------------------------------
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OM_INT_GRP';
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13: G_STMT_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
14: G_MODULE_NAME CONSTANT VARCHAR2(250) := 'OKC.PLSQL.'||G_PKG_NAME||'.';
15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS

Line 46: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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;
49:
50: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 50: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

46: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
47: l_debug := true;
48: END IF;
49:
50: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
51: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'10:Entering OKC_OM_INT_GRP.get_article_variable_values');
52: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'20:Calling OKC_XPRT_OM_INT_PVT.get_clause_variable_values');
53: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
54: END IF;

Line 51: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'10:Entering OKC_OM_INT_GRP.get_article_variable_values');

47: l_debug := true;
48: END IF;
49:
50: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
51: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'10:Entering OKC_OM_INT_GRP.get_article_variable_values');
52: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'20:Calling OKC_XPRT_OM_INT_PVT.get_clause_variable_values');
53: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
54: END IF;
55:

Line 52: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'20:Calling OKC_XPRT_OM_INT_PVT.get_clause_variable_values');

48: END IF;
49:
50: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
51: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'10:Entering OKC_OM_INT_GRP.get_article_variable_values');
52: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'20:Calling OKC_XPRT_OM_INT_PVT.get_clause_variable_values');
53: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
54: END IF;
55:
56: OKC_XPRT_OM_INT_PVT.get_clause_variable_values(

Line 53: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');

49:
50: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
51: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'10:Entering OKC_OM_INT_GRP.get_article_variable_values');
52: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'20:Calling OKC_XPRT_OM_INT_PVT.get_clause_variable_values');
53: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
54: END IF;
55:
56: OKC_XPRT_OM_INT_PVT.get_clause_variable_values(
57: p_api_version => l_api_version,

Line 66: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

62: x_return_status => x_return_status,
63: x_msg_data => x_msg_data,
64: x_msg_count => x_msg_count);
65:
66: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
67: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
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:

Line 67: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');

63: x_msg_data => x_msg_data,
64: x_msg_count => x_msg_count);
65:
66: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
67: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
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

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

64: x_msg_count => x_msg_count);
65:
66: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
67: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
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 ;

Line 77: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
79: END IF;
80:
81: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 78: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'30:Leaving OKC_OM_INT_GRP.get_article_variable_values');

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');
79: END IF;
80:
81: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
82:

Line 86: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 87: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'40: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception');

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

Line 94: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 95: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'50: Leaving get_article_variable_values: OKC_API.G_EXCEPT ION_UNEXPECTED_ERROR Exception');

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:
98: x_return_status := G_RET_STS_UNEXP_ERROR ;
99: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 101: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

97:
98: x_return_status := G_RET_STS_UNEXP_ERROR ;
99: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
100: WHEN OTHERS THEN
101: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
102: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'60: Leaving get_article_variable_values because of EXCEPTION: '||sqlerrm);
103: END IF;
104:
105: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 102: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'60: Leaving get_article_variable_values because of EXCEPTION: '||sqlerrm);

98: x_return_status := G_RET_STS_UNEXP_ERROR ;
99: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
100: WHEN OTHERS THEN
101: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
102: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'60: Leaving get_article_variable_values because of EXCEPTION: '||sqlerrm);
103: END IF;
104:
105: x_return_status := G_RET_STS_UNEXP_ERROR ;
106:

Line 133: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

129: l_module VARCHAR2(250) := G_MODULE_NAME||l_api_name;
130:
131: BEGIN
132:
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;

Line 142: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 143: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'70: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception');

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

Line 150: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 151: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'80: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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:
154: x_return_status := G_RET_STS_UNEXP_ERROR ;
155: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

153:
154: x_return_status := G_RET_STS_UNEXP_ERROR ;
155: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
156: WHEN OTHERS THEN
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'90: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm);
159: END IF;
160:
161: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 158: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'90: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm);

154: x_return_status := G_RET_STS_UNEXP_ERROR ;
155: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
156: WHEN OTHERS THEN
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'90: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm);
159: END IF;
160:
161: x_return_status := G_RET_STS_UNEXP_ERROR ;
162:

Line 195: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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;
198:
199: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 199: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

195: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: l_debug := true;
197: END IF;
198:
199: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
200: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'100:Entering OKC_OM_INT_GRP.g_get_item_dtl_for_expert');
201: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'110:Calling OKC_XPRT_OM_INT_PVT.get_clause_variable_values - 2');
202: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
203: END IF;

Line 200: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'100:Entering OKC_OM_INT_GRP.g_get_item_dtl_for_expert');

196: l_debug := true;
197: END IF;
198:
199: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
200: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'100:Entering OKC_OM_INT_GRP.g_get_item_dtl_for_expert');
201: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'110:Calling OKC_XPRT_OM_INT_PVT.get_clause_variable_values - 2');
202: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
203: END IF;
204:

Line 201: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'110:Calling OKC_XPRT_OM_INT_PVT.get_clause_variable_values - 2');

197: END IF;
198:
199: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
200: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'100:Entering OKC_OM_INT_GRP.g_get_item_dtl_for_expert');
201: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'110:Calling OKC_XPRT_OM_INT_PVT.get_clause_variable_values - 2');
202: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
203: END IF;
204:
205: l_line_var_tbl(0) :='OKC$S_ITEM_CATEGORY';

Line 202: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');

198:
199: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
200: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'100:Entering OKC_OM_INT_GRP.g_get_item_dtl_for_expert');
201: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'110:Calling OKC_XPRT_OM_INT_PVT.get_clause_variable_values - 2');
202: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
203: END IF;
204:
205: l_line_var_tbl(0) :='OKC$S_ITEM_CATEGORY';
206: l_line_var_tbl(1) :='OKC$S_ITEM';

Line 219: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

215: x_return_status => x_return_status,
216: x_msg_data => x_msg_data,
217: x_msg_count => x_msg_count);
218:
219: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
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:

Line 220: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');

216: x_msg_data => x_msg_data,
217: x_msg_count => x_msg_count);
218:
219: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
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

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

217: x_msg_count => x_msg_count);
218:
219: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
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 ;

Line 230: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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,' ');
232: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'117: l_sys_var_value_tbl count = '||l_sys_var_value_tbl.COUNT);
233: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
234: END IF;

Line 231: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');

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,' ');
232: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'117: l_sys_var_value_tbl count = '||l_sys_var_value_tbl.COUNT);
233: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
234: END IF;
235:

Line 232: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'117: l_sys_var_value_tbl count = '||l_sys_var_value_tbl.COUNT);

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,' ');
232: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'117: l_sys_var_value_tbl count = '||l_sys_var_value_tbl.COUNT);
233: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
234: END IF;
235:
236: IF l_sys_var_value_tbl.COUNT > 0 THEN

Line 233: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');

229:
230: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
231: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
232: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'117: l_sys_var_value_tbl count = '||l_sys_var_value_tbl.COUNT);
233: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
234: END IF;
235:
236: IF l_sys_var_value_tbl.COUNT > 0 THEN
237: FOR i in l_sys_var_value_tbl.FIRST..l_sys_var_value_tbl.LAST LOOP

Line 241: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

237: FOR i in l_sys_var_value_tbl.FIRST..l_sys_var_value_tbl.LAST LOOP
238: IF l_sys_var_value_tbl(i).variable_code = 'OKC$S_ITEM_CATEGORY' then
239: l_cat_index :=x_category_tbl.count + 1;
240: x_category_tbl(l_cat_index).name := l_sys_var_value_tbl(i).variable_value_id;
241: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
242: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'120:x_category_tbl('||l_cat_index||').name = '||x_category_tbl(l_cat_index).name);
243: END IF;
244: ELSE
245: l_item_index :=x_item_tbl.count + 1;

Line 242: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'120:x_category_tbl('||l_cat_index||').name = '||x_category_tbl(l_cat_index).name);

238: IF l_sys_var_value_tbl(i).variable_code = 'OKC$S_ITEM_CATEGORY' then
239: l_cat_index :=x_category_tbl.count + 1;
240: x_category_tbl(l_cat_index).name := l_sys_var_value_tbl(i).variable_value_id;
241: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
242: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'120:x_category_tbl('||l_cat_index||').name = '||x_category_tbl(l_cat_index).name);
243: END IF;
244: ELSE
245: l_item_index :=x_item_tbl.count + 1;
246: x_item_tbl(l_item_index).name := l_sys_var_value_tbl(i).variable_value_id;

Line 247: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

243: END IF;
244: ELSE
245: l_item_index :=x_item_tbl.count + 1;
246: x_item_tbl(l_item_index).name := l_sys_var_value_tbl(i).variable_value_id;
247: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
248: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'130:x_item_tbl('||l_item_index||').name = '||x_item_tbl(l_item_index).name);
249: END IF;
250: END IF;
251:

Line 248: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'130:x_item_tbl('||l_item_index||').name = '||x_item_tbl(l_item_index).name);

244: ELSE
245: l_item_index :=x_item_tbl.count + 1;
246: x_item_tbl(l_item_index).name := l_sys_var_value_tbl(i).variable_value_id;
247: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
248: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'130:x_item_tbl('||l_item_index||').name = '||x_item_tbl(l_item_index).name);
249: END IF;
250: END IF;
251:
252: END LOOP;

Line 255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

251:
252: END LOOP;
253: END IF;
254:
255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
256: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
257: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'140:Leaving OKC_OM_INT_GRP.get_item_dtl_for_expert');
258: END IF;
259: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 256: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');

252: END LOOP;
253: END IF;
254:
255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
256: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
257: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'140:Leaving OKC_OM_INT_GRP.get_item_dtl_for_expert');
258: END IF;
259: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
260:

Line 257: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'140:Leaving OKC_OM_INT_GRP.get_item_dtl_for_expert');

253: END IF;
254:
255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
256: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
257: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'140:Leaving OKC_OM_INT_GRP.get_item_dtl_for_expert');
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

Line 264: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 265: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'150: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception');

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

Line 272: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

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

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:
276: x_return_status := G_RET_STS_UNEXP_ERROR ;
277: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 279: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

275:
276: x_return_status := G_RET_STS_UNEXP_ERROR ;
277: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
278: WHEN OTHERS THEN
279: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
280: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'170: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm);
281: END IF;
282:
283: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 280: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'170: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm);

276: x_return_status := G_RET_STS_UNEXP_ERROR ;
277: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
278: WHEN OTHERS THEN
279: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
280: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'170: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm);
281: END IF;
282:
283: x_return_status := G_RET_STS_UNEXP_ERROR ;
284: