DBA Data[Home] [Help]

APPS.IBE_DSP_HIERARCHY_SETUP_PUB dependencies on FND_MSG_PUB

Line 83: FND_MSG_PUB.initialize;

79: END IF;
80:
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean(p_init_msg_list) THEN
83: FND_MSG_PUB.initialize;
84: END IF;
85: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
86:
87: -- Initialize API return status to success

Line 141: IBE_UTIL.debug(FND_MSG_PUB.get(i,FND_API.G_FALSE));

137: --
138: -- End of main API body.
139: IF (l_debug='Y') AND ( x_return_status <> FND_API.G_RET_STS_ERROR) THEN
140: FOR i in 1..x_msg_count loop
141: IBE_UTIL.debug(FND_MSG_PUB.get(i,FND_API.G_FALSE));
142: END LOOP;
143: END IF;
144:
145: -- Standard check of p_commit.

Line 151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

147: COMMIT WORK;
148: END IF;
149:
150: -- Standard call to get message count and if count is 1, get message info.
151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
152: p_data => x_msg_data,
153: p_encoded => 'F');
154:
155: EXCEPTION

Line 160: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

156:
157: WHEN FND_API.G_EXC_ERROR THEN
158: ROLLBACK TO CREATE_HIERARCHY_SECTION_PUB;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
161: p_data => x_msg_data,
162: p_encoded => 'F');
163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 167: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: ROLLBACK TO CREATE_HIERARCHY_SECTION_PUB;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
168: p_data => x_msg_data,
169: p_encoded => 'F');
170:
171: WHEN OTHERS THEN

Line 177: FND_MSG_PUB.Add;

173: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
174: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
175: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
176: FND_MESSAGE.Set_Token('REASON', SQLERRM);
177: FND_MSG_PUB.Add;
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179:
180: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
181: THEN

Line 180: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

176: FND_MESSAGE.Set_Token('REASON', SQLERRM);
177: FND_MSG_PUB.Add;
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179:
180: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
181: THEN
182: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
183: END IF;
184:

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

178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179:
180: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
181: THEN
182: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
183: END IF;
184:
185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
186: p_data => x_msg_data,

Line 185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

181: THEN
182: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
183: END IF;
184:
185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
186: p_data => x_msg_data,
187: p_encoded => 'F');
188:
189: END Create_Section;

Line 224: FND_MSG_PUB.initialize;

220: END IF;
221:
222: -- Initialize message list if p_init_msg_list is set to TRUE.
223: IF FND_API.to_Boolean(p_init_msg_list) THEN
224: FND_MSG_PUB.initialize;
225: END IF;
226:
227: -- Initialize API return status to success
228: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 253: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

249: COMMIT WORK;
250: END IF;
251:
252: -- Standard call to get message count and if count is 1, get message info.
253: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
254: p_data => x_msg_data,
255: p_encoded => 'F');
256:
257: EXCEPTION

Line 262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

258:
259: WHEN FND_API.G_EXC_ERROR THEN
260: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PUB;
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
263: p_data => x_msg_data,
264: p_encoded => 'F');
265:
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

265:
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PUB;
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
270: p_data => x_msg_data,
271: p_encoded => 'F');
272:
273: WHEN OTHERS THEN

Line 279: FND_MSG_PUB.Add;

275: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
276: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
277: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
278: FND_MESSAGE.Set_Token('REASON', SQLERRM);
279: FND_MSG_PUB.Add;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281:
282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
283: THEN

Line 282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

278: FND_MESSAGE.Set_Token('REASON', SQLERRM);
279: FND_MSG_PUB.Add;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281:
282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
283: THEN
284: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
285: END IF;
286:

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

280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281:
282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
283: THEN
284: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
285: END IF;
286:
287: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
288: p_data => x_msg_data,

Line 287: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

283: THEN
284: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
285: END IF;
286:
287: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
288: p_data => x_msg_data,
289: p_encoded => 'F');
290:
291: END Create_Section_Items;

Line 330: FND_MSG_PUB.initialize;

326: END IF;
327:
328: -- Initialize message list if p_init_msg_list is set to TRUE.
329: IF FND_API.to_Boolean(p_init_msg_list) THEN
330: FND_MSG_PUB.initialize;
331: END IF;
332:
333: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
334:

Line 377: IBE_UTIL.debug(FND_MSG_PUB.get(i,FND_API.G_FALSE));

373: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
374: l_overall_return_status:= FND_API.G_RET_STS_ERROR;
375: IF (l_debug = 'Y') THEN
376: FOR i in 1..x_msg_count loop
377: IBE_UTIL.debug(FND_MSG_PUB.get(i,FND_API.G_FALSE));
378: END LOOP;
379: END IF;
380: END IF;
381: END LOOP;

Line 395: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

391:
392: -- End of main API body.
393:
394: -- Standard call to get message count and if count is 1, get message info.
395: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
396: p_data => x_msg_data,
397: p_encoded => 'F');
398:
399: EXCEPTION

Line 404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

400:
401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO ASSOCIATE_LOGICAL_CONTENT_PUB;
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
405: p_data => x_msg_data,
406: p_encoded => 'F');
407:
408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 411: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

407:
408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
409: ROLLBACK TO ASSOCIATE_LOGICAL_CONTENT_PUB;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
412: p_data => x_msg_data,
413: p_encoded => 'F');
414:
415: WHEN OTHERS THEN

Line 421: FND_MSG_PUB.Add;

417: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
418: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
419: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
420: FND_MESSAGE.Set_Token('REASON', SQLERRM);
421: FND_MSG_PUB.Add;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423:
424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN

Line 424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

420: FND_MESSAGE.Set_Token('REASON', SQLERRM);
421: FND_MSG_PUB.Add;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423:
424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
427: END IF;
428:

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

422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423:
424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
427: END IF;
428:
429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
430: p_data => x_msg_data,

Line 429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

425: THEN
426: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
427: END IF;
428:
429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
430: p_data => x_msg_data,
431: p_encoded => 'F');
432:
433: END Create_Object_Logical_Content;