eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGW_PROP_USER_ROLES_PVT dependencies on FND_MSG_PUB

Line 42: fnd_msg_pub.initialize;

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

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

119: end if;
120:
121:
122: -- standard call to get message count and if count is 1, get message info
123: fnd_msg_pub.count_and_get(p_count => x_msg_count,
124: p_data => x_msg_data);
125:
126:
127: EXCEPTION

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

131: END IF;
132:
133: x_return_status := FND_API.G_RET_STS_ERROR;
134:
135: fnd_msg_pub.count_and_get(p_count => x_msg_count,
136: p_data => x_msg_data);
137:
138: WHEN OTHERS THEN
139: IF p_commit = FND_API.G_TRUE THEN

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

141: END IF;
142:
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144:
145: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',
146: p_procedure_name => 'CREATE_USER_ROLE',
147: p_error_text => SUBSTRB(SQLERRM,1,240));
148:
149: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

145: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',
146: p_procedure_name => 'CREATE_USER_ROLE',
147: p_error_text => SUBSTRB(SQLERRM,1,240));
148:
149: fnd_msg_pub.count_and_get(p_count => x_msg_count,
150: p_data => x_msg_data);
151:
152:
153: END create_prop_user_role;

Line 198: fnd_msg_pub.initialize;

194: END IF;
195:
196: -- initialize message list if p_init_msg_list is true
197: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
198: fnd_msg_pub.initialize;
199: end if;
200:
201: -- initialize return_status to success
202: x_return_status := fnd_api.g_ret_sts_success;

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

300: end if;
301:
302:
303: -- standard call to get message count and if count is 1, get message info
304: fnd_msg_pub.count_and_get(p_count => x_msg_count,
305: p_data => x_msg_data);
306:
307:
308: EXCEPTION

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

312: END IF;
313:
314: x_return_status := FND_API.G_RET_STS_ERROR;
315:
316: fnd_msg_pub.count_and_get(p_count => x_msg_count,
317: p_data => x_msg_data);
318:
319:
320: WHEN OTHERS THEN

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

323: END IF;
324:
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326:
327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',
328: p_procedure_name => 'UPDATE_USER_ROLE',
329: p_error_text => SUBSTRB(SQLERRM,1,240));
330:
331: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',
328: p_procedure_name => 'UPDATE_USER_ROLE',
329: p_error_text => SUBSTRB(SQLERRM,1,240));
330:
331: fnd_msg_pub.count_and_get(p_count => x_msg_count,
332: p_data => x_msg_data);
333:
334:
335: END update_prop_user_role;

Line 371: fnd_msg_pub.initialize;

367: END IF;
368:
369: -- initialize message list if p_init_msg_list is set to true
370: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
371: fnd_msg_pub.initialize;
372: end if;
373:
374: -- initialize return_status to sucess
375: x_return_status := fnd_api.g_ret_sts_success;

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

424: end if;
425:
426:
427: -- standard call to get message count and if count is 1, get message info
428: fnd_msg_pub.count_and_get(p_count => x_msg_count,
429: p_data => x_msg_data);
430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN

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

435: END IF;
436:
437: x_return_status := FND_API.G_RET_STS_ERROR;
438:
439: fnd_msg_pub.count_and_get(p_count => x_msg_count,
440: p_data => x_msg_data);
441:
442:
443: WHEN OTHERS THEN

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

446: END IF;
447:
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449:
450: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',
451: p_procedure_name => 'DELETE_USER_ROLE',
452: p_error_text => SUBSTRB(SQLERRM,1,240));
453:
454: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

450: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',
451: p_procedure_name => 'DELETE_USER_ROLE',
452: p_error_text => SUBSTRB(SQLERRM,1,240));
453:
454: fnd_msg_pub.count_and_get(p_count => x_msg_count,
455: p_data => x_msg_data);
456:
457: END delete_prop_user_role;
458: -----------------------------------------------------------------------------------

Line 487: fnd_msg_pub.add;

483:
484: WHEN NO_DATA_FOUND THEN
485: x_return_status:= FND_API.G_RET_STS_ERROR;
486: fnd_message.set_name('IGW', 'IGW_NO_RIGHTS');
487: fnd_msg_pub.add;
488:
489: WHEN too_many_rows THEN
490: NULL;
491:

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

490: NULL;
491:
492: WHEN OTHERS THEN
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',
495: p_procedure_name => 'VALIDATE_LOGGED_USER_RIGHTS',
496: p_error_text => SUBSTRB(SQLERRM,1,240));
497: raise fnd_api.g_exc_unexpected_error;
498: END VALIDATE_LOGGED_USER_RIGHTS;

Line 520: FND_MSG_PUB.Add;

516: EXCEPTION
517: WHEN NO_DATA_FOUND THEN
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
520: FND_MSG_PUB.Add;
521: raise fnd_api.g_exc_error;
522:
523: WHEN OTHERS THEN
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

521: raise fnd_api.g_exc_error;
522:
523: WHEN OTHERS THEN
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',
526: p_procedure_name => 'CHECK_LOCK_GET_PK',
527: p_error_text => SUBSTRB(SQLERRM,1,240));
528: raise fnd_api.g_exc_unexpected_error;
529:

Line 553: fnd_msg_pub.add;

549: EXCEPTION
550: WHEN no_data_found THEN
551: x_return_status:= FND_API.G_RET_STS_ERROR;
552: fnd_message.set_name('IGW', 'IGW_SS_ROLE_INVALID');
553: fnd_msg_pub.add;
554:
555: WHEN too_many_rows THEN
556: x_return_status:= FND_API.G_RET_STS_ERROR;
557: fnd_message.set_name('IGW', 'IGW_SS_ROLE_INVALID');

Line 558: fnd_msg_pub.add;

554:
555: WHEN too_many_rows THEN
556: x_return_status:= FND_API.G_RET_STS_ERROR;
557: fnd_message.set_name('IGW', 'IGW_SS_ROLE_INVALID');
558: fnd_msg_pub.add;
559:
560: WHEN OTHERS THEN
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PUB',

Line 562: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PUB',

558: fnd_msg_pub.add;
559:
560: WHEN OTHERS THEN
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PUB',
563: p_procedure_name => 'GET_ROLE_ID',
564: p_error_text => SUBSTRB(SQLERRM,1,240));
565: raise fnd_api.g_exc_unexpected_error;
566: END GET_ROLE_ID;

Line 586: fnd_msg_pub.add;

582:
583: if (N <> 0) then
584: x_return_status:= FND_API.G_RET_STS_ERROR;
585: fnd_message.set_name ('IGW', 'IGW_SEEDED_ROLE');
586: fnd_msg_pub.add;
587: end if;
588:
589: EXCEPTION
590: WHEN OTHERS THEN

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

588:
589: EXCEPTION
590: WHEN OTHERS THEN
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',
593: p_procedure_name => 'CHECK_IF_SEEDED_ROLE',
594: p_error_text => SUBSTRB(SQLERRM,1,240));
595: raise fnd_api.g_exc_unexpected_error;
596: END CHECK_IF_SEEDED_ROLE;

Line 603: l_msg_count := fnd_msg_pub.count_msg;

599: -------------------------------------------------------------------------------------------------------
600: PROCEDURE CHECK_ERRORS is
601: l_msg_count NUMBER;
602: BEGIN
603: l_msg_count := fnd_msg_pub.count_msg;
604: IF (l_msg_count > 0) THEN
605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
607: