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 IGW_PROP_USER_ROLES

Line 1: PACKAGE BODY IGW_PROP_USER_ROLES_PVT as

1: PACKAGE BODY IGW_PROP_USER_ROLES_PVT as
2: /* $Header: igwvpurb.pls 115.8 2002/11/18 19:20:06 ashkumar ship $*/
3: PROCEDURE create_prop_user_role (
4: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 104: igw_prop_user_roles_tbh.insert_row(

100:
101: -- call table handler
102: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
103:
104: igw_prop_user_roles_tbh.insert_row(
105: x_rowid => x_rowid,
106: p_proposal_id => l_proposal_id,
107: p_user_id => l_user_id,
108: p_role_id => l_role_id,

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 204: -- get proposal_id, user_id, role_id from igw_prop_user_roles using x_rowid and record_version_number

200:
201: -- initialize return_status to success
202: x_return_status := fnd_api.g_ret_sts_success;
203:
204: -- get proposal_id, user_id, role_id from igw_prop_user_roles using x_rowid and record_version_number
205: -- and also check locking. The columns fetched are the old data, i.e., the data that is being overwritten
206: CHECK_LOCK_GET_PK
207: (x_rowid => x_rowid
208: ,p_record_version_number => p_record_version_number

Line 284: igw_prop_user_roles_tbh.update_row (

280:
281: check_errors;
282:
283: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
284: igw_prop_user_roles_tbh.update_row (
285: x_rowid => x_rowid,
286: p_proposal_id => l_proposal_id2,
287: p_user_id => l_user_id2,
288: p_role_id => l_role_id2,

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 378: -- get proposal_id, user_id, role_id from igw_prop_user_roles using x_rowid and record_version_number

374: -- initialize return_status to sucess
375: x_return_status := fnd_api.g_ret_sts_success;
376:
377:
378: -- get proposal_id, user_id, role_id from igw_prop_user_roles using x_rowid and record_version_number
379: -- and also check locking
380: CHECK_LOCK_GET_PK
381: (x_rowid => x_rowid
382: ,p_record_version_number => p_record_version_number

Line 411: igw_prop_user_roles_tbh.delete_row(

407:
408:
409: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
410:
411: igw_prop_user_roles_tbh.delete_row(
412: x_rowid => x_rowid,
413: p_record_version_number => p_record_version_number,
414: x_return_status => x_return_status);
415:

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 472: from igw_prop_user_roles ppr,

468: BEGIN
469: x_return_status:= FND_API.G_RET_STS_SUCCESS;
470:
471: select x into y
472: from igw_prop_user_roles ppr,
473: igw_prop_users ppu
474: where ppr.proposal_id = p_proposal_id AND
475: ppr.proposal_id = ppu.proposal_id AND
476: ppr.user_id = ppu.user_id AND

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 512: from igw_prop_user_roles

508:
509: BEGIN
510: select proposal_id, user_id, role_id
511: into x_proposal_id, x_user_id, x_role_id
512: from igw_prop_user_roles
513: where rowid = x_rowid
514: and record_version_number = p_record_version_number;
515:
516: EXCEPTION

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 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 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 611: END IGW_PROP_USER_ROLES_PVT;

607:
608: END CHECK_ERRORS;
609:
610:
611: END IGW_PROP_USER_ROLES_PVT;