DBA Data[Home] [Help]

APPS.OKC_ASO_INT_GRP dependencies on FND_MSG_PUB

Line 78: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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:
80: EXCEPTION
81: WHEN FND_API.G_EXC_ERROR THEN
82:

Line 88: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

Line 96: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

Line 105: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

101: END IF;
102:
103: x_return_status := G_RET_STS_UNEXP_ERROR ;
104:
105: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
106: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
107: END IF;
108: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
109:

Line 106: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

102:
103: x_return_status := G_RET_STS_UNEXP_ERROR ;
104:
105: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
106: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
107: END IF;
108: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
109:
110: END get_article_variable_values;

Line 108: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

104:
105: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
106: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
107: END IF;
108: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
109:
110: END get_article_variable_values;
111:
112:

Line 211: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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:
213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215:

Line 221: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

Line 229: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

Line 237: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

233: END IF;
234:
235: x_return_status := G_RET_STS_UNEXP_ERROR ;
236:
237: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
239: END IF;
240: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
241:

Line 238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

234:
235: x_return_status := G_RET_STS_UNEXP_ERROR ;
236:
237: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
239: END IF;
240: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
241:
242: END get_item_dtl_for_expert;

Line 240: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

236:
237: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
239: END IF;
240: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
241:
242: END get_item_dtl_for_expert;
243:
244:

Line 290: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

286: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
287: RAISE FND_API.G_EXC_ERROR ;
288: END IF;
289:
290: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
291:
292: return l_update_allowed;
293:
294: EXCEPTION

Line 301: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

Line 310: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 );
311: return FND_API.G_FALSE;
312:
313: WHEN OTHERS THEN
314: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 320: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

316: END IF;
317:
318: x_return_status := G_RET_STS_UNEXP_ERROR ;
319:
320: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
322: END IF;
323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
324: return FND_API.G_FALSE;

Line 321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

317:
318: x_return_status := G_RET_STS_UNEXP_ERROR ;
319:
320: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
322: END IF;
323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
324: return FND_API.G_FALSE;
325:

Line 323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

319:
320: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
322: END IF;
323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
324: return FND_API.G_FALSE;
325:
326: END ok_to_commit;
327: