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

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

11: ---------------------------------------------------------------------------
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ASO_INT_GRP';
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
14: G_MODULE_NAME CONSTANT VARCHAR2(250) := 'OKC.PLSQL.'||G_PKG_NAME||'.';
15: G_STMT_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

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

43:
44: BEGIN
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46:
47: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
48: l_debug := true;
49: END IF;
50:
51: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

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

Line 52: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'10:Entering OKC_ASO_INT_GRP.Get_Article_Variable_Values');

48: l_debug := true;
49: END IF;
50:
51: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
52: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'10:Entering OKC_ASO_INT_GRP.Get_Article_Variable_Values');
53: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'20:Calling OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values');
54: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
55: END IF;
56:

Line 53: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'20:Calling OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values');

49: END IF;
50:
51: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
52: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'10:Entering OKC_ASO_INT_GRP.Get_Article_Variable_Values');
53: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'20:Calling OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values');
54: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
55: END IF;
56:
57: OKC_XPRT_QUOTE_INT_PVT.get_clause_variable_values(

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

50:
51: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
52: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'10:Entering OKC_ASO_INT_GRP.Get_Article_Variable_Values');
53: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'20:Calling OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values');
54: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
55: END IF;
56:
57: OKC_XPRT_QUOTE_INT_PVT.get_clause_variable_values(
58: p_api_version => l_api_version,

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

68: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
69: RAISE FND_API.G_EXC_ERROR ;
70: END IF;
71:
72: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
73: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
74: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'30:Return status from OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values = '||x_return_status);
75: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'40:Leaving OKC_ASO_INT_GRP.get_article_variable_values');
76: END IF;

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

69: RAISE FND_API.G_EXC_ERROR ;
70: END IF;
71:
72: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
73: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
74: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'30:Return status from OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values = '||x_return_status);
75: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'40:Leaving OKC_ASO_INT_GRP.get_article_variable_values');
76: END IF;
77:

Line 74: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'30:Return status from OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values = '||x_return_status);

70: END IF;
71:
72: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
73: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
74: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'30:Return status from OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values = '||x_return_status);
75: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'40:Leaving OKC_ASO_INT_GRP.get_article_variable_values');
76: END IF;
77:
78: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 75: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'40:Leaving OKC_ASO_INT_GRP.get_article_variable_values');

71:
72: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
73: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
74: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'30:Return status from OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values = '||x_return_status);
75: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'40:Leaving OKC_ASO_INT_GRP.get_article_variable_values');
76: END IF;
77:
78: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
79:

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

79:
80: EXCEPTION
81: WHEN FND_API.G_EXC_ERROR THEN
82:
83: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
84: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'50: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception');
85: END IF;
86:
87: x_return_status := G_RET_STS_ERROR ;

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

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

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

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

Line 92: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'60: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

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

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

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

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

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

135:
136: BEGIN
137: x_return_status := FND_API.G_RET_STS_SUCCESS;
138:
139: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
140: l_debug := true;
141: END IF;
142:
143: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

139: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
140: l_debug := true;
141: END IF;
142:
143: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
144: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'80:Entering OKC_ASO_INT_GRP.get_item_dtl_for_expert');
145: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'90:Calling OKC_XPRT_QUOTE_INT_PVT.get_clause_variable_values - 2 ');
146: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
147: END IF;

Line 144: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'80:Entering OKC_ASO_INT_GRP.get_item_dtl_for_expert');

140: l_debug := true;
141: END IF;
142:
143: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
144: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'80:Entering OKC_ASO_INT_GRP.get_item_dtl_for_expert');
145: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'90:Calling OKC_XPRT_QUOTE_INT_PVT.get_clause_variable_values - 2 ');
146: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
147: END IF;
148:

Line 145: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'90:Calling OKC_XPRT_QUOTE_INT_PVT.get_clause_variable_values - 2 ');

141: END IF;
142:
143: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
144: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'80:Entering OKC_ASO_INT_GRP.get_item_dtl_for_expert');
145: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'90:Calling OKC_XPRT_QUOTE_INT_PVT.get_clause_variable_values - 2 ');
146: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
147: END IF;
148:
149: l_sys_var_value_tbl(0).variable_code :='OKC$S_ITEM_CATEGORY';

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

142:
143: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
144: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'80:Entering OKC_ASO_INT_GRP.get_item_dtl_for_expert');
145: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'90:Calling OKC_XPRT_QUOTE_INT_PVT.get_clause_variable_values - 2 ');
146: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
147: END IF;
148:
149: l_sys_var_value_tbl(0).variable_code :='OKC$S_ITEM_CATEGORY';
150: l_sys_var_value_tbl(1).variable_code :='OKC$S_ITEM';

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

158: x_return_status => x_return_status,
159: x_msg_data => x_msg_data,
160: x_msg_count => x_msg_count);
161:
162: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
163: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
164: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'95:Return status from OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values - 2 = '||x_return_status);
165: END IF;
166:

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

159: x_msg_data => x_msg_data,
160: x_msg_count => x_msg_count);
161:
162: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
163: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
164: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'95:Return status from OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values - 2 = '||x_return_status);
165: END IF;
166:
167: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 164: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'95:Return status from OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values - 2 = '||x_return_status);

160: x_msg_count => x_msg_count);
161:
162: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
163: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
164: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'95:Return status from OKC_XPRT_QUOTE_INT_PVT.Get_clause_Variable_Values - 2 = '||x_return_status);
165: END IF;
166:
167: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

170: RAISE FND_API.G_EXC_ERROR ;
171: END IF;
172:
173:
174: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'100:Category count = '||x_variables_tbl.category.COUNT);
176: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'110:Item count = '||x_variables_tbl.item.COUNT);
177: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
178: END IF;

Line 175: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'100:Category count = '||x_variables_tbl.category.COUNT);

171: END IF;
172:
173:
174: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'100:Category count = '||x_variables_tbl.category.COUNT);
176: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'110:Item count = '||x_variables_tbl.item.COUNT);
177: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
178: END IF;
179:

Line 176: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'110:Item count = '||x_variables_tbl.item.COUNT);

172:
173:
174: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'100:Category count = '||x_variables_tbl.category.COUNT);
176: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'110:Item count = '||x_variables_tbl.item.COUNT);
177: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
178: END IF;
179:
180: -- Populate the categories

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

173:
174: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'100:Category count = '||x_variables_tbl.category.COUNT);
176: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'110:Item count = '||x_variables_tbl.item.COUNT);
177: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
178: END IF;
179:
180: -- Populate the categories
181: IF x_variables_tbl.category.COUNT > 0 THEN

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

181: IF x_variables_tbl.category.COUNT > 0 THEN
182: FOR i in x_variables_tbl.category.FIRST.. x_variables_tbl.category.LAST LOOP
183: l_cat_index :=x_category_tbl.count + 1;
184: x_category_tbl(l_cat_index).name := x_variables_tbl.category(i);
185: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
186: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'120:x_category_tbl('||l_cat_index||').name = '||x_category_tbl(l_cat_index).name);
187: END IF;
188: END LOOP;
189: END IF;

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

182: FOR i in x_variables_tbl.category.FIRST.. x_variables_tbl.category.LAST LOOP
183: l_cat_index :=x_category_tbl.count + 1;
184: x_category_tbl(l_cat_index).name := x_variables_tbl.category(i);
185: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
186: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'120:x_category_tbl('||l_cat_index||').name = '||x_category_tbl(l_cat_index).name);
187: END IF;
188: END LOOP;
189: END IF;
190:

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

187: END IF;
188: END LOOP;
189: END IF;
190:
191: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
192: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
193: END IF;
194: -- Populate the Items
195:

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

188: END LOOP;
189: END IF;
190:
191: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
192: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
193: END IF;
194: -- Populate the Items
195:
196: IF x_variables_tbl.item.COUNT > 0 THEN

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

196: IF x_variables_tbl.item.COUNT > 0 THEN
197: FOR i in x_variables_tbl.item.FIRST.. x_variables_tbl.item.LAST LOOP
198: l_item_index :=x_item_tbl.count + 1;
199: x_item_tbl(l_item_index).name := x_variables_tbl.item(i);
200: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
201: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'130:x_item_tbl('||l_item_index||').name = '||x_item_tbl(l_item_index).name);
202: END IF;
203: END LOOP;
204: END IF;

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

197: FOR i in x_variables_tbl.item.FIRST.. x_variables_tbl.item.LAST LOOP
198: l_item_index :=x_item_tbl.count + 1;
199: x_item_tbl(l_item_index).name := x_variables_tbl.item(i);
200: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
201: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'130:x_item_tbl('||l_item_index||').name = '||x_item_tbl(l_item_index).name);
202: END IF;
203: END LOOP;
204: END IF;
205:

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

202: END IF;
203: END LOOP;
204: END IF;
205:
206: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
207: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
208: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'140:Leaving OKC_ASO_INT_GRP.g_get_item_dtl_for_expert');
209: END IF;
210:

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

203: END LOOP;
204: END IF;
205:
206: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
207: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
208: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'140:Leaving OKC_ASO_INT_GRP.g_get_item_dtl_for_expert');
209: END IF;
210:
211: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 208: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'140:Leaving OKC_ASO_INT_GRP.g_get_item_dtl_for_expert');

204: END IF;
205:
206: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
207: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
208: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'140:Leaving OKC_ASO_INT_GRP.g_get_item_dtl_for_expert');
209: END IF;
210:
211: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
212:

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

212:
213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215:
216: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
217: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'160: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception');
218: END IF;
219:
220: x_return_status := G_RET_STS_ERROR ;

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

213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215:
216: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
217: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'160: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception');
218: END IF;
219:
220: x_return_status := G_RET_STS_ERROR ;
221: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

220: x_return_status := G_RET_STS_ERROR ;
221: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
225: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'170: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
226: END IF;
227:
228: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 225: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'170: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

221: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
225: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'170: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
226: END IF;
227:
228: x_return_status := G_RET_STS_UNEXP_ERROR ;
229: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

227:
228: x_return_status := G_RET_STS_UNEXP_ERROR ;
229: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
230: WHEN OTHERS THEN
231: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'180: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm);
233: END IF;
234:
235: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

228: x_return_status := G_RET_STS_UNEXP_ERROR ;
229: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
230: WHEN OTHERS THEN
231: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'180: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm);
233: END IF;
234:
235: x_return_status := G_RET_STS_UNEXP_ERROR ;
236:

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

266: BEGIN
267:
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: l_debug := true;
272: END IF;
273:
274: l_update_allowed := ASO_CONTRACT_TERMS_PUB.ok_to_commit(

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

292: return l_update_allowed;
293:
294: EXCEPTION
295: WHEN FND_API.G_EXC_ERROR THEN
296: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
297: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'190: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception');
298: END IF;
299:
300: x_return_status := G_RET_STS_ERROR ;

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

293:
294: EXCEPTION
295: WHEN FND_API.G_EXC_ERROR THEN
296: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
297: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'190: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception');
298: END IF;
299:
300: x_return_status := G_RET_STS_ERROR ;
301: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

301: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
302: return FND_API.G_FALSE;
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
306: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'200: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
307: END IF;
308:
309: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

302: return FND_API.G_FALSE;
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
306: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'200: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
307: END IF;
308:
309: x_return_status := G_RET_STS_UNEXP_ERROR ;
310: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

310: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
311: return FND_API.G_FALSE;
312:
313: WHEN OTHERS THEN
314: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
315: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'210: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm);
316: END IF;
317:
318: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

311: return FND_API.G_FALSE;
312:
313: WHEN OTHERS THEN
314: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
315: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'210: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm);
316: END IF;
317:
318: x_return_status := G_RET_STS_UNEXP_ERROR ;
319: