DBA Data[Home] [Help]

APPS.ZPB_EXCP_PVT dependencies on FND_MSG_PUB

Line 63: FND_MSG_PUB.initialize;

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

Line 166: FND_MSG_PUB.Count_And_Get(

162: IF FND_API.To_Boolean( p_commit ) THEN
163: COMMIT WORK;
164: END IF;
165: -- Standard call to get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get(
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170:

Line 175: FND_MSG_PUB.Count_And_Get(

171: EXCEPTION
172: WHEN FND_API.G_EXC_ERROR THEN
173: ROLLBACK TO zpb_excp_pvt_run_exception;
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: FND_MSG_PUB.Count_And_Get(
176: p_count => x_msg_count,
177: p_data => x_msg_data
178: );
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 182: FND_MSG_PUB.Count_And_Get(

178: );
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: ROLLBACK TO zpb_excp_pvt_run_exception;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MSG_PUB.Count_And_Get(
183: p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186: WHEN OTHERS THEN

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

185: );
186: WHEN OTHERS THEN
187: ROLLBACK TO zpb_excp_pvt_run_exception;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
190: FND_MSG_PUB.Add_Exc_Msg(
191: G_PKG_NAME,
192: l_api_name
193: );

Line 190: FND_MSG_PUB.Add_Exc_Msg(

186: WHEN OTHERS THEN
187: ROLLBACK TO zpb_excp_pvt_run_exception;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
190: FND_MSG_PUB.Add_Exc_Msg(
191: G_PKG_NAME,
192: l_api_name
193: );
194: END IF;

Line 195: FND_MSG_PUB.Count_And_Get(

191: G_PKG_NAME,
192: l_api_name
193: );
194: END IF;
195: FND_MSG_PUB.Count_And_Get(
196: p_count => x_msg_count,
197: p_data => x_msg_data
198: );
199:

Line 258: FND_MSG_PUB.initialize;

254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: IF FND_API.to_Boolean(p_init_msg_list) THEN
258: FND_MSG_PUB.initialize;
259: END IF;
260: -- Initialize API return status to success
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:

Line 298: FND_MSG_PUB.Count_And_Get(

294: IF FND_API.To_Boolean( p_commit ) THEN
295: COMMIT WORK;
296: END IF;
297: -- Standard call to get message count and if count is 1, get message info.
298: FND_MSG_PUB.Count_And_Get(
299: p_count => x_msg_count,
300: p_data => x_msg_data
301: );
302:

Line 307: FND_MSG_PUB.Count_And_Get(

303: EXCEPTION
304: WHEN FND_API.G_EXC_ERROR THEN
305: ROLLBACK TO zpb_excp_populate_child_nodes;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: FND_MSG_PUB.Count_And_Get(
308: p_count => x_msg_count,
309: p_data => x_msg_data
310: );
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 314: FND_MSG_PUB.Count_And_Get(

310: );
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
312: ROLLBACK TO zpb_excp_populate_child_nodes;
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: FND_MSG_PUB.Count_And_Get(
315: p_count => x_msg_count,
316: p_data => x_msg_data
317: );
318: WHEN OTHERS THEN

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

317: );
318: WHEN OTHERS THEN
319: ROLLBACK TO zpb_excp_populate_child_nodes;
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
322: FND_MSG_PUB.Add_Exc_Msg(
323: G_PKG_NAME,
324: l_api_name
325: );

Line 322: FND_MSG_PUB.Add_Exc_Msg(

318: WHEN OTHERS THEN
319: ROLLBACK TO zpb_excp_populate_child_nodes;
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
322: FND_MSG_PUB.Add_Exc_Msg(
323: G_PKG_NAME,
324: l_api_name
325: );
326: END IF;

Line 327: FND_MSG_PUB.Count_And_Get(

323: G_PKG_NAME,
324: l_api_name
325: );
326: END IF;
327: FND_MSG_PUB.Count_And_Get(
328: p_count => x_msg_count,
329: p_data => x_msg_data
330: );
331:

Line 390: FND_MSG_PUB.initialize;

386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388: -- Initialize message list if p_init_msg_list is set to TRUE.
389: IF FND_API.to_Boolean(p_init_msg_list) THEN
390: FND_MSG_PUB.initialize;
391: END IF;
392: -- Initialize API return status to success
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:

Line 479: FND_MSG_PUB.Count_And_Get(

475: IF FND_API.To_Boolean( p_commit ) THEN
476: COMMIT WORK;
477: END IF;
478: -- Standard call to get message count and if count is 1, get message info.
479: FND_MSG_PUB.Count_And_Get(
480: p_count => x_msg_count,
481: p_data => x_msg_data
482: );
483:

Line 488: FND_MSG_PUB.Count_And_Get(

484: EXCEPTION
485: WHEN FND_API.G_EXC_ERROR THEN
486: ROLLBACK TO zpb_excp_pvt_run_exception;
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: FND_MSG_PUB.Count_And_Get(
489: p_count => x_msg_count,
490: p_data => x_msg_data
491: );
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 495: FND_MSG_PUB.Count_And_Get(

491: );
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493: ROLLBACK TO zpb_excp_pvt_run_exception;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: FND_MSG_PUB.Count_And_Get(
496: p_count => x_msg_count,
497: p_data => x_msg_data
498: );
499: WHEN OTHERS THEN

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

498: );
499: WHEN OTHERS THEN
500: ROLLBACK TO zpb_excp_pvt_run_exception;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
503: FND_MSG_PUB.Add_Exc_Msg(
504: G_PKG_NAME,
505: l_api_name
506: );

Line 503: FND_MSG_PUB.Add_Exc_Msg(

499: WHEN OTHERS THEN
500: ROLLBACK TO zpb_excp_pvt_run_exception;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
503: FND_MSG_PUB.Add_Exc_Msg(
504: G_PKG_NAME,
505: l_api_name
506: );
507: END IF;

Line 508: FND_MSG_PUB.Count_And_Get(

504: G_PKG_NAME,
505: l_api_name
506: );
507: END IF;
508: FND_MSG_PUB.Count_And_Get(
509: p_count => x_msg_count,
510: p_data => x_msg_data
511: );
512:

Line 534: --select fnd_msg_pub.get(-1) into msg_out from dual;

530: dbms_output.put_line(return_status);
531: dbms_output.put_line(msg_count);
532: --dbms_output.put_line(msg_data);
533: --i := 1;
534: --select fnd_msg_pub.get(-1) into msg_out from dual;
535: --dbms_output.put_line(msg_out);
536: --while i < msg_count loop
537: -- select fnd_msg_pub.get(-2) into msg_out from dual;
538: -- dbms_output.put_line(msg_out);

Line 537: -- select fnd_msg_pub.get(-2) into msg_out from dual;

533: --i := 1;
534: --select fnd_msg_pub.get(-1) into msg_out from dual;
535: --dbms_output.put_line(msg_out);
536: --while i < msg_count loop
537: -- select fnd_msg_pub.get(-2) into msg_out from dual;
538: -- dbms_output.put_line(msg_out);
539: -- i := i + 1;
540: --end loop;
541: dbms_output.put_line('request children test complete');