DBA Data[Home] [Help]

APPS.IGW_PROP_NARRATIVES_PVT dependencies on FND_MSG_PUB

Line 40: fnd_msg_pub.initialize;

36: END IF;
37:
38: -- initialize message list if p_init_msg_list is set to true
39: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
40: fnd_msg_pub.initialize;
41: end if;
42:
43: -- initialize return status to success
44: x_return_status := fnd_api.g_ret_sts_success;

Line 86: fnd_msg_pub.count_and_get(p_count => x_msg_count,

82: end if;
83:
84:
85: -- standard call to get message count and if count is 1, get message info
86: fnd_msg_pub.count_and_get(p_count => x_msg_count,
87: p_data => x_msg_data);
88:
89:
90: EXCEPTION

Line 98: fnd_msg_pub.count_and_get(p_count => x_msg_count,

94: END IF;
95:
96: x_return_status := FND_API.G_RET_STS_ERROR;
97:
98: fnd_msg_pub.count_and_get(p_count => x_msg_count,
99: p_data => x_msg_data);
100:
101: WHEN OTHERS THEN
102: IF p_commit = FND_API.G_TRUE THEN

Line 108: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

104: END IF;
105:
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107:
108: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
109: p_procedure_name => 'CREATE_PROP_NARRATIVE',
110: p_error_text => SUBSTRB(SQLERRM,1,240));
111:
112: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 112: fnd_msg_pub.count_and_get(p_count => x_msg_count,

108: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
109: p_procedure_name => 'CREATE_PROP_NARRATIVE',
110: p_error_text => SUBSTRB(SQLERRM,1,240));
111:
112: fnd_msg_pub.count_and_get(p_count => x_msg_count,
113: p_data => x_msg_data);
114:
115:
116: END create_prop_narrative;

Line 155: fnd_msg_pub.initialize;

151: END IF;
152:
153: -- initialize message list if p_init_msg_list is true
154: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
155: fnd_msg_pub.initialize;
156: end if;
157:
158: -- initialize return_status to success
159: x_return_status := fnd_api.g_ret_sts_success;

Line 210: fnd_msg_pub.count_and_get(p_count => x_msg_count,

206: end if;
207:
208:
209: -- standard call to get message count and if count is 1, get message info
210: fnd_msg_pub.count_and_get(p_count => x_msg_count,
211: p_data => x_msg_data);
212:
213:
214: EXCEPTION

Line 222: fnd_msg_pub.count_and_get(p_count => x_msg_count,

218: END IF;
219:
220: x_return_status := FND_API.G_RET_STS_ERROR;
221:
222: fnd_msg_pub.count_and_get(p_count => x_msg_count,
223: p_data => x_msg_data);
224:
225:
226: WHEN OTHERS THEN

Line 233: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

229: END IF;
230:
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232:
233: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
234: p_procedure_name => 'UPDATE_PROP_NARRATIVE',
235: p_error_text => SUBSTRB(SQLERRM,1,240));
236:
237: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 237: fnd_msg_pub.count_and_get(p_count => x_msg_count,

233: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
234: p_procedure_name => 'UPDATE_PROP_NARRATIVE',
235: p_error_text => SUBSTRB(SQLERRM,1,240));
236:
237: fnd_msg_pub.count_and_get(p_count => x_msg_count,
238: p_data => x_msg_data);
239:
240:
241: END update_prop_narrative;

Line 273: fnd_msg_pub.initialize;

269: END IF;
270:
271: -- initialize message list if p_init_msg_list is set to true
272: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
273: fnd_msg_pub.initialize;
274: end if;
275:
276: -- initialize return_status to sucess
277: x_return_status := fnd_api.g_ret_sts_success;

Line 325: fnd_msg_pub.count_and_get(p_count => x_msg_count,

321: end if;
322:
323:
324: -- standard call to get message count and if count is 1, get message info
325: fnd_msg_pub.count_and_get(p_count => x_msg_count,
326: p_data => x_msg_data);
327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN

Line 336: fnd_msg_pub.count_and_get(p_count => x_msg_count,

332: END IF;
333:
334: x_return_status := FND_API.G_RET_STS_ERROR;
335:
336: fnd_msg_pub.count_and_get(p_count => x_msg_count,
337: p_data => x_msg_data);
338:
339:
340: WHEN OTHERS THEN

Line 347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

343: END IF;
344:
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346:
347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
348: p_procedure_name => 'DELETE_PROP_NARRATIVE',
349: p_error_text => SUBSTRB(SQLERRM,1,240));
350:
351: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 351: fnd_msg_pub.count_and_get(p_count => x_msg_count,

347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
348: p_procedure_name => 'DELETE_PROP_NARRATIVE',
349: p_error_text => SUBSTRB(SQLERRM,1,240));
350:
351: fnd_msg_pub.count_and_get(p_count => x_msg_count,
352: p_data => x_msg_data);
353:
354: END delete_prop_narrative;
355:

Line 383: fnd_msg_pub.initialize;

379: END IF;
380:
381: -- initialize message list if p_init_msg_list is true
382: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
383: fnd_msg_pub.initialize;
384: end if;
385:
386: -- initialize return_status to success
387: x_return_status := fnd_api.g_ret_sts_success;

Line 421: fnd_msg_pub.count_and_get(p_count => x_msg_count,

417: end if;
418:
419:
420: -- standard call to get message count and if count is 1, get message info
421: fnd_msg_pub.count_and_get(p_count => x_msg_count,
422: p_data => x_msg_data);
423:
424:
425: EXCEPTION

Line 433: fnd_msg_pub.count_and_get(p_count => x_msg_count,

429: END IF;
430:
431: x_return_status := FND_API.G_RET_STS_ERROR;
432:
433: fnd_msg_pub.count_and_get(p_count => x_msg_count,
434: p_data => x_msg_data);
435:
436:
437: WHEN OTHERS THEN

Line 444: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

440: END IF;
441:
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443:
444: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
445: p_procedure_name => 'UPDATE_PROP_NARRATIVE',
446: p_error_text => SUBSTRB(SQLERRM,1,240));
447:
448: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 448: fnd_msg_pub.count_and_get(p_count => x_msg_count,

444: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
445: p_procedure_name => 'UPDATE_PROP_NARRATIVE',
446: p_error_text => SUBSTRB(SQLERRM,1,240));
447:
448: fnd_msg_pub.count_and_get(p_count => x_msg_count,
449: p_data => x_msg_data);
450:
451:
452: END update_narrative_type_code;

Line 471: FND_MSG_PUB.Add;

467: EXCEPTION
468: WHEN NO_DATA_FOUND THEN
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
471: FND_MSG_PUB.Add;
472: raise fnd_api.g_exc_error;
473:
474: WHEN OTHERS THEN
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 476: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

472: raise fnd_api.g_exc_error;
473:
474: WHEN OTHERS THEN
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
477: p_procedure_name => 'CHECK_LOCK',
478: p_error_text => SUBSTRB(SQLERRM,1,240));
479: raise fnd_api.g_exc_unexpected_error;
480:

Line 487: l_msg_count := fnd_msg_pub.count_msg;

483: -------------------------------------------------------------------------------------------------------
484: PROCEDURE CHECK_ERRORS is
485: l_msg_count NUMBER;
486: BEGIN
487: l_msg_count := fnd_msg_pub.count_msg;
488: IF (l_msg_count > 0) THEN
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491:

Line 509: fnd_msg_pub.add;

505:
506: IF (IGW_SECURITY.ALLOW_MODIFY ('NARRATIVE', P_PROPOSAL_ID, FND_GLOBAL.USER_ID) = 'N') THEN
507: x_return_status:= FND_API.G_RET_STS_ERROR;
508: fnd_message.set_name('IGW', 'IGW_NO_RIGHTS');
509: fnd_msg_pub.add;
510: END IF;
511:
512: EXCEPTION
513:

Line 516: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

512: EXCEPTION
513:
514: WHEN OTHERS THEN
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
517: p_procedure_name => 'VALIDATE_LOGGED_USER_RIGHTS',
518: p_error_text => SUBSTRB(SQLERRM,1,240));
519: raise fnd_api.g_exc_unexpected_error;
520: END VALIDATE_LOGGED_USER_RIGHTS;