DBA Data[Home] [Help]

APPS.IGW_PROP_USERS_PVT dependencies on FND_MSG_PUB

Line 44: fnd_msg_pub.initialize;

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

Line 67: fnd_msg_pub.add;

63: -- get user_id from LOV only, suspend validations for now
64:
65: IF ((p_user_id is null) OR (p_full_name is null)) THEN
66: fnd_message.set_name('IGW', 'IGW_SS_UTL_PERSON_NAME_INVALID');
67: fnd_msg_pub.add;
68: END IF;
69:
70: /*
71: IF (p_full_name is null) THEN

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

140: end if;
141:
142:
143: -- standard call to get message count and if count is 1, get message info
144: fnd_msg_pub.count_and_get(p_count => x_msg_count,
145: p_data => x_msg_data);
146:
147:
148: EXCEPTION

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

152: END IF;
153:
154: x_return_status := FND_API.G_RET_STS_ERROR;
155:
156: fnd_msg_pub.count_and_get(p_count => x_msg_count,
157: p_data => x_msg_data);
158:
159: WHEN OTHERS THEN
160: IF p_commit = FND_API.G_TRUE THEN

Line 166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',

162: END IF;
163:
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165:
166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',
167: p_procedure_name => 'CREATE_PROP_USER',
168: p_error_text => SUBSTRB(SQLERRM,1,240));
169:
170: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',
167: p_procedure_name => 'CREATE_PROP_USER',
168: p_error_text => SUBSTRB(SQLERRM,1,240));
169:
170: fnd_msg_pub.count_and_get(p_count => x_msg_count,
171: p_data => x_msg_data);
172:
173:
174:

Line 221: fnd_msg_pub.initialize;

217: END IF;
218:
219: -- initialize message list if p_init_msg_list is true
220: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
221: fnd_msg_pub.initialize;
222: end if;
223:
224: -- initialize return_status to success
225: x_return_status := fnd_api.g_ret_sts_success;

Line 269: fnd_msg_pub.add;

265: -- get user_id from LOV only, suspend validations for now
266:
267: IF ((p_user_id is null) OR (p_full_name is null)) THEN
268: fnd_message.set_name('IGW', 'IGW_SS_UTL_PERSON_NAME_INVALID');
269: fnd_msg_pub.add;
270: END IF;
271:
272:
273:

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

363: end if;
364:
365:
366: -- standard call to get message count and if count is 1, get message info
367: fnd_msg_pub.count_and_get(p_count => x_msg_count,
368: p_data => x_msg_data);
369:
370: EXCEPTION
371: WHEN FND_API.G_EXC_ERROR THEN

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

374: END IF;
375:
376: x_return_status := FND_API.G_RET_STS_ERROR;
377:
378: fnd_msg_pub.count_and_get(p_count => x_msg_count,
379: p_data => x_msg_data);
380:
381: WHEN OTHERS THEN
382: IF p_commit = FND_API.G_TRUE THEN

Line 388: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',

384: END IF;
385:
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',
389: p_procedure_name => 'UPDATE_PROP_USER',
390: p_error_text => SUBSTRB(SQLERRM,1,240));
391:
392: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

388: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',
389: p_procedure_name => 'UPDATE_PROP_USER',
390: p_error_text => SUBSTRB(SQLERRM,1,240));
391:
392: fnd_msg_pub.count_and_get(p_count => x_msg_count,
393: p_data => x_msg_data);
394:
395:
396: END update_prop_user;

Line 430: fnd_msg_pub.initialize;

426: END IF;
427:
428: -- initialize message list if p_init_msg_list is set to true
429: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
430: fnd_msg_pub.initialize;
431: end if;
432:
433: -- initialize return_status to sucess
434: x_return_status := fnd_api.g_ret_sts_success;

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

484: end if;
485:
486:
487: -- standard call to get message count and if count is 1, get message info
488: fnd_msg_pub.count_and_get(p_count => x_msg_count,
489: p_data => x_msg_data);
490:
491: EXCEPTION
492: WHEN FND_API.G_EXC_ERROR THEN

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

495: END IF;
496:
497: x_return_status := FND_API.G_RET_STS_ERROR;
498:
499: fnd_msg_pub.count_and_get(p_count => x_msg_count,
500: p_data => x_msg_data);
501:
502: WHEN OTHERS THEN
503: IF p_commit = FND_API.G_TRUE THEN

Line 509: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',

505: END IF;
506:
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508:
509: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',
510: p_procedure_name => 'DELETE_PROP_USER',
511: p_error_text => SUBSTRB(SQLERRM,1,240));
512:
513: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

509: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',
510: p_procedure_name => 'DELETE_PROP_USER',
511: p_error_text => SUBSTRB(SQLERRM,1,240));
512:
513: fnd_msg_pub.count_and_get(p_count => x_msg_count,
514: p_data => x_msg_data);
515:
516:
517: END delete_prop_user;

Line 540: fnd_msg_pub.add;

536:
537: if (N <> 0) then
538: x_return_status:= FND_API.G_RET_STS_ERROR;
539: fnd_message.set_name ('IGW', 'IGW_SEEDED_ROLE');
540: fnd_msg_pub.add;
541: end if;
542:
543: EXCEPTION
544: WHEN OTHERS THEN

Line 546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',

542:
543: EXCEPTION
544: WHEN OTHERS THEN
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',
547: p_procedure_name => 'CHECK_IF_SEEDED_ROLE',
548: p_error_text => SUBSTRB(SQLERRM,1,240));
549: raise fnd_api.g_exc_unexpected_error;
550: END CHECK_IF_USER_HAS_SEEDED_ROLE;

Line 573: FND_MSG_PUB.Add;

569: EXCEPTION
570: WHEN NO_DATA_FOUND THEN
571: x_return_status := FND_API.G_RET_STS_ERROR;
572: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
573: FND_MSG_PUB.Add;
574: raise fnd_api.g_exc_error;
575:
576: WHEN OTHERS THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 578: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',

574: raise fnd_api.g_exc_error;
575:
576: WHEN OTHERS THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',
579: p_procedure_name => 'CHECK_LOCK_GET_PK',
580: p_error_text => SUBSTRB(SQLERRM,1,240));
581: raise fnd_api.g_exc_unexpected_error;
582:

Line 590: l_msg_count := fnd_msg_pub.count_msg;

586:
587: PROCEDURE CHECK_ERRORS is
588: l_msg_count NUMBER;
589: BEGIN
590: l_msg_count := fnd_msg_pub.count_msg;
591: IF (l_msg_count > 0) THEN
592: RAISE FND_API.G_EXC_ERROR;
593: END IF;
594: