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_USERS_PVT dependencies on FND_API

Line 4: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1: PACKAGE BODY IGW_PROP_USERS_PVT as
2: /* $Header: igwvprub.pls 115.9 2002/11/15 00:46:16 ashkumar ship $*/
3: PROCEDURE create_prop_user (
4: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
7: ,x_rowid OUT NOCOPY VARCHAR2
8: ,p_proposal_id IN NUMBER

Line 5: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1: PACKAGE BODY IGW_PROP_USERS_PVT as
2: /* $Header: igwvprub.pls 115.9 2002/11/15 00:46:16 ashkumar ship $*/
3: PROCEDURE create_prop_user (
4: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
7: ,x_rowid OUT NOCOPY VARCHAR2
8: ,p_proposal_id IN NUMBER
9: ,p_proposal_number IN VARCHAR2

Line 6: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

2: /* $Header: igwvprub.pls 115.9 2002/11/15 00:46:16 ashkumar ship $*/
3: PROCEDURE create_prop_user (
4: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
7: ,x_rowid OUT NOCOPY VARCHAR2
8: ,p_proposal_id IN NUMBER
9: ,p_proposal_number IN VARCHAR2
10: ,p_user_id IN NUMBER

Line 38: IF p_commit = FND_API.G_TRUE THEN

34:
35: BEGIN
36:
37: -- create savepoint if p_commit is true
38: IF p_commit = FND_API.G_TRUE THEN
39: SAVEPOINT create_user;
40: END IF;
41:
42: -- initialize message list if p_init_msg_list is set to true

Line 43: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

39: SAVEPOINT create_user;
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

Line 48: x_return_status := fnd_api.g_ret_sts_success;

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;
49:
50: ------------------------------------- value_id conversion ------------------------------------
51: -- if proposal_id is null, then get it
52:

Line 122: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then

118: ,x_return_status => x_return_status );
119:
120: check_errors;
121:
122: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
123:
124: igw_prop_users_tbh.insert_row (
125: x_rowid => x_rowid,
126: p_proposal_id => l_proposal_id,

Line 138: if fnd_api.to_boolean(p_commit) then

134:
135: check_errors;
136:
137: -- standard check of p_commit
138: if fnd_api.to_boolean(p_commit) then
139: commit work;
140: end if;
141:
142:

Line 149: WHEN FND_API.G_EXC_ERROR THEN

145: p_data => x_msg_data);
146:
147:
148: EXCEPTION
149: WHEN FND_API.G_EXC_ERROR THEN
150: IF p_commit = FND_API.G_TRUE THEN
151: ROLLBACK TO create_user;
152: END IF;
153:

Line 150: IF p_commit = FND_API.G_TRUE THEN

146:
147:
148: EXCEPTION
149: WHEN FND_API.G_EXC_ERROR THEN
150: IF p_commit = FND_API.G_TRUE THEN
151: ROLLBACK TO create_user;
152: END IF;
153:
154: x_return_status := FND_API.G_RET_STS_ERROR;

Line 154: x_return_status := FND_API.G_RET_STS_ERROR;

150: IF p_commit = FND_API.G_TRUE THEN
151: ROLLBACK TO create_user;
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:

Line 160: IF p_commit = FND_API.G_TRUE THEN

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
161: ROLLBACK TO create_user;
162: END IF;
163:
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

160: IF p_commit = FND_API.G_TRUE THEN
161: ROLLBACK TO create_user;
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));

Line 180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

176: END create_prop_user;
177: --------------------------------------------------------------------------------------------------------------
178:
179: Procedure update_prop_user (
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
181: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
182: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
183: ,x_rowid IN VARCHAR2
184: ,p_proposal_id IN NUMBER

Line 181: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

177: --------------------------------------------------------------------------------------------------------------
178:
179: Procedure update_prop_user (
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
181: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
182: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
183: ,x_rowid IN VARCHAR2
184: ,p_proposal_id IN NUMBER
185: ,p_proposal_number IN VARCHAR2

Line 182: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

178:
179: Procedure update_prop_user (
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
181: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
182: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
183: ,x_rowid IN VARCHAR2
184: ,p_proposal_id IN NUMBER
185: ,p_proposal_number IN VARCHAR2
186: ,p_user_id IN NUMBER

Line 215: IF p_commit = FND_API.G_TRUE THEN

211: l_person_id NUMBER;
212:
213: BEGIN
214: -- create savepoint if p_commit is true
215: IF p_commit = FND_API.G_TRUE THEN
216: SAVEPOINT update_user;
217: END IF;
218:
219: -- initialize message list if p_init_msg_list is true

Line 220: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

216: SAVEPOINT update_user;
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

Line 225: x_return_status := fnd_api.g_ret_sts_success;

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;
226:
227: -- get proposal_id, user_id from igw_prop_users using x_rowid and record_version_number
228: -- and also check locking. The columns fetched are the old data, i.e., the data that is being overwritten
229: CHECK_LOCK_GET_COLS

Line 334: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then

330: ,x_return_status => x_return_status);
331:
332: check_errors;
333:
334: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
335: igw_prop_users_tbh.update_row (
336: x_rowid => x_rowid,
337: p_proposal_id => l_proposal_id2,
338: p_user_id => l_user_id2,

Line 361: if fnd_api.to_boolean(p_commit) then

357:
358: check_errors;
359:
360: -- standard check of p_commit
361: if fnd_api.to_boolean(p_commit) then
362: commit work;
363: end if;
364:
365:

Line 371: WHEN FND_API.G_EXC_ERROR THEN

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
372: IF p_commit = FND_API.G_TRUE THEN
373: ROLLBACK TO update_user;
374: END IF;
375:

Line 372: IF p_commit = FND_API.G_TRUE THEN

368: p_data => x_msg_data);
369:
370: EXCEPTION
371: WHEN FND_API.G_EXC_ERROR THEN
372: IF p_commit = FND_API.G_TRUE THEN
373: ROLLBACK TO update_user;
374: END IF;
375:
376: x_return_status := FND_API.G_RET_STS_ERROR;

Line 376: x_return_status := FND_API.G_RET_STS_ERROR;

372: IF p_commit = FND_API.G_TRUE THEN
373: ROLLBACK TO update_user;
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:

Line 382: IF p_commit = FND_API.G_TRUE THEN

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
383: ROLLBACK TO update_user;
384: END IF;
385:
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: IF p_commit = FND_API.G_TRUE THEN
383: ROLLBACK TO update_user;
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));

Line 400: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

396: END update_prop_user;
397: --------------------------------------------------------------------------------------------------------
398:
399: Procedure delete_prop_user (
400: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
401: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
402: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
403: ,x_rowid IN VARCHAR2
404: ,p_logged_user_id IN NUMBER

Line 401: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

397: --------------------------------------------------------------------------------------------------------
398:
399: Procedure delete_prop_user (
400: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
401: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
402: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
403: ,x_rowid IN VARCHAR2
404: ,p_logged_user_id IN NUMBER
405: ,p_record_version_number IN NUMBER

Line 402: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

398:
399: Procedure delete_prop_user (
400: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
401: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
402: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
403: ,x_rowid IN VARCHAR2
404: ,p_logged_user_id IN NUMBER
405: ,p_record_version_number IN NUMBER
406: ,x_return_status OUT NOCOPY VARCHAR2

Line 424: IF p_commit = FND_API.G_TRUE THEN

420: l_end_date_active DATE;
421:
422: BEGIN
423: -- create savepoint
424: IF p_commit = FND_API.G_TRUE THEN
425: SAVEPOINT delete_user;
426: END IF;
427:
428: -- initialize message list if p_init_msg_list is set to true

Line 429: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

425: SAVEPOINT delete_user;
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

Line 434: x_return_status := fnd_api.g_ret_sts_success;

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;
435:
436: -- get proposal_id, user_id, role_id from igw_prop_users using x_rowid and record_version_number
437: -- and also check locking
438: CHECK_LOCK_GET_COLS

Line 467: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then

463: ,x_return_status => x_return_status);
464:
465: check_errors;
466:
467: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
468: igw_prop_users_tbh.delete_row (
469: x_rowid => x_rowid,
470: p_record_version_number => p_record_version_number,
471: x_return_status => l_return_status);

Line 482: if fnd_api.to_boolean(p_commit) then

478:
479: check_errors;
480:
481: -- standard check of p_commit
482: if fnd_api.to_boolean(p_commit) then
483: commit work;
484: end if;
485:
486:

Line 492: WHEN FND_API.G_EXC_ERROR THEN

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
493: IF p_commit = FND_API.G_TRUE THEN
494: ROLLBACK TO delete_user;
495: END IF;
496:

Line 493: IF p_commit = FND_API.G_TRUE THEN

489: p_data => x_msg_data);
490:
491: EXCEPTION
492: WHEN FND_API.G_EXC_ERROR THEN
493: IF p_commit = FND_API.G_TRUE THEN
494: ROLLBACK TO delete_user;
495: END IF;
496:
497: x_return_status := FND_API.G_RET_STS_ERROR;

Line 497: x_return_status := FND_API.G_RET_STS_ERROR;

493: IF p_commit = FND_API.G_TRUE THEN
494: ROLLBACK TO delete_user;
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:

Line 503: IF p_commit = FND_API.G_TRUE THEN

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
504: ROLLBACK TO delete_user;
505: END IF;
506:
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

503: IF p_commit = FND_API.G_TRUE THEN
504: ROLLBACK TO delete_user;
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));

Line 528: x_return_status:= FND_API.G_RET_STS_SUCCESS;

524:
525: N NUMBER;
526:
527: BEGIN
528: x_return_status:= FND_API.G_RET_STS_SUCCESS;
529:
530: select count(*) into N
531: from igw_prop_user_roles
532: where proposal_id = p_proposal_id

Line 538: x_return_status:= FND_API.G_RET_STS_ERROR;

534: and role_id in (select role_id from igw_roles where seeded_flag = 'Y');
535:
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:

Line 545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

541: end if;
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;

Line 549: raise fnd_api.g_exc_unexpected_error;

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;
551: ------------------------------------------------------------------------------------------
552:
553: PROCEDURE CHECK_LOCK_GET_COLS

Line 571: x_return_status := FND_API.G_RET_STS_ERROR;

567: and record_version_number = p_record_version_number;
568:
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:

Line 574: raise fnd_api.g_exc_error;

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;
578: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',

Line 577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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;

Line 581: raise fnd_api.g_exc_unexpected_error;

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:
583:
584: END CHECK_LOCK_GET_COLS;
585: -------------------------------------------------------------------------------------

Line 592: RAISE FND_API.G_EXC_ERROR;

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:
595: END CHECK_ERRORS;
596: