DBA Data[Home] [Help]

APPS.IBE_CATALOG_PRELOAD_PUB dependencies on FND_MSG_PUB

Line 64: FND_MSG_PUB.initialize;

60: END IF;
61:
62: -- initialize message list if p_init_msg_list is set to TRUE
63: IF FND_API.to_Boolean(p_init_msg_list) THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66:
67: -- initialize API return status to success
68: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 86: FND_MSG_PUB.Count_And_Get

82: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(-)');
83: END IF;
84:
85: -- standard call to get message count and if count is 1, get message info.
86: FND_MSG_PUB.Count_And_Get
87: ( p_encoded => FND_API.G_FALSE,
88: p_count => x_msg_count,
89: p_data => x_msg_data
90: );

Line 96: FND_MSG_PUB.Count_And_Get

92: --ibe_util.disable_debug;
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: x_return_status := FND_API.G_RET_STS_ERROR;
96: FND_MSG_PUB.Count_And_Get
97: ( p_encoded => FND_API.G_FALSE,
98: p_count => x_msg_count,
99: p_data => x_msg_data
100: );

Line 105: FND_MSG_PUB.Count_And_Get

101: --gzhang 08/08/2002, bug#2488246
102: --ibe_util.disable_debug;
103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: FND_MSG_PUB.Count_And_Get
106: ( p_encoded => FND_API.G_FALSE,
107: p_count => x_msg_count,
108: p_data => x_msg_data
109: );

Line 118: FND_MSG_PUB.Add;

114: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
115: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || '4');
116: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
117: FND_MESSAGE.Set_Token('REASON', SQLERRM);
118: FND_MSG_PUB.Add;
119: IF FND_MSG_PUB.Check_Msg_Level
120: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
121: THEN FND_MSG_PUB.Add_Exc_Msg
122: ( G_PKG_NAME,

Line 119: IF FND_MSG_PUB.Check_Msg_Level

115: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || '4');
116: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
117: FND_MESSAGE.Set_Token('REASON', SQLERRM);
118: FND_MSG_PUB.Add;
119: IF FND_MSG_PUB.Check_Msg_Level
120: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
121: THEN FND_MSG_PUB.Add_Exc_Msg
122: ( G_PKG_NAME,
123: l_api_name

Line 120: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

116: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
117: FND_MESSAGE.Set_Token('REASON', SQLERRM);
118: FND_MSG_PUB.Add;
119: IF FND_MSG_PUB.Check_Msg_Level
120: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
121: THEN FND_MSG_PUB.Add_Exc_Msg
122: ( G_PKG_NAME,
123: l_api_name
124: );

Line 121: THEN FND_MSG_PUB.Add_Exc_Msg

117: FND_MESSAGE.Set_Token('REASON', SQLERRM);
118: FND_MSG_PUB.Add;
119: IF FND_MSG_PUB.Check_Msg_Level
120: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
121: THEN FND_MSG_PUB.Add_Exc_Msg
122: ( G_PKG_NAME,
123: l_api_name
124: );
125: END IF;

Line 126: FND_MSG_PUB.Count_And_Get

122: ( G_PKG_NAME,
123: l_api_name
124: );
125: END IF;
126: FND_MSG_PUB.Count_And_Get
127: ( p_encoded => FND_API.G_FALSE,
128: p_count => x_msg_count,
129: p_data => x_msg_data
130: );

Line 194: FND_MSG_PUB.initialize;

190: END IF;
191:
192: -- initialize message list if p_init_msg_list is set to TRUE
193: IF FND_API.to_Boolean(p_init_msg_list) THEN
194: FND_MSG_PUB.initialize;
195: END IF;
196:
197: -- initialize API return status to success
198: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 214: FND_MSG_PUB.Count_And_Get

210: -- end API body
211: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(-)');
212:
213: -- standard call to get message count and if count is 1, get message info.
214: FND_MSG_PUB.Count_And_Get
215: ( p_encoded => FND_API.G_FALSE,
216: p_count => x_msg_count,
217: p_data => x_msg_data
218: );

Line 224: FND_MSG_PUB.Count_And_Get

220: --ibe_util.disable_debug;
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: FND_MSG_PUB.Count_And_Get
225: ( p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data
228: );

Line 233: FND_MSG_PUB.Count_And_Get

229: --gzhang 08/08/2002, bug#2488246
230: --ibe_util.disable_debug;
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Count_And_Get
234: ( p_encoded => FND_API.G_FALSE,
235: p_count => x_msg_count,
236: p_data => x_msg_data
237: );

Line 246: FND_MSG_PUB.Add;

242: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
243: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
244: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
245: FND_MESSAGE.Set_Token('REASON', SQLERRM);
246: FND_MSG_PUB.Add;
247: IF FND_MSG_PUB.Check_Msg_Level
248: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN FND_MSG_PUB.Add_Exc_Msg
250: ( G_PKG_NAME,

Line 247: IF FND_MSG_PUB.Check_Msg_Level

243: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
244: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
245: FND_MESSAGE.Set_Token('REASON', SQLERRM);
246: FND_MSG_PUB.Add;
247: IF FND_MSG_PUB.Check_Msg_Level
248: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN FND_MSG_PUB.Add_Exc_Msg
250: ( G_PKG_NAME,
251: l_api_name

Line 248: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

244: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
245: FND_MESSAGE.Set_Token('REASON', SQLERRM);
246: FND_MSG_PUB.Add;
247: IF FND_MSG_PUB.Check_Msg_Level
248: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN FND_MSG_PUB.Add_Exc_Msg
250: ( G_PKG_NAME,
251: l_api_name
252: );

Line 249: THEN FND_MSG_PUB.Add_Exc_Msg

245: FND_MESSAGE.Set_Token('REASON', SQLERRM);
246: FND_MSG_PUB.Add;
247: IF FND_MSG_PUB.Check_Msg_Level
248: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN FND_MSG_PUB.Add_Exc_Msg
250: ( G_PKG_NAME,
251: l_api_name
252: );
253: END IF;

Line 254: FND_MSG_PUB.Count_And_Get

250: ( G_PKG_NAME,
251: l_api_name
252: );
253: END IF;
254: FND_MSG_PUB.Count_And_Get
255: ( p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data
258: );