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_API

Line 4: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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
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_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
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: 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
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 36: IF p_commit = FND_API.G_TRUE THEN

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

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

37: SAVEPOINT create_user_role;
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

Line 46: x_return_status := fnd_api.g_ret_sts_success;

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;
47:
48: ------------------------------------- value_id conversion ------------------------------------
49: /*
50: -- if proposal_id is null, then get it

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

98:
99: check_errors;
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,

Line 117: if fnd_api.to_boolean(p_commit) then

113:
114: check_errors;
115:
116: -- standard check of p_commit
117: if fnd_api.to_boolean(p_commit) then
118: commit work;
119: end if;
120:
121:

Line 128: WHEN FND_API.G_EXC_ERROR THEN

124: p_data => x_msg_data);
125:
126:
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129: IF p_commit = FND_API.G_TRUE THEN
130: ROLLBACK TO create_user_role;
131: END IF;
132:

Line 129: IF p_commit = FND_API.G_TRUE THEN

125:
126:
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129: IF p_commit = FND_API.G_TRUE THEN
130: ROLLBACK TO create_user_role;
131: END IF;
132:
133: x_return_status := FND_API.G_RET_STS_ERROR;

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

129: IF p_commit = FND_API.G_TRUE THEN
130: ROLLBACK TO create_user_role;
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:

Line 139: IF p_commit = FND_API.G_TRUE THEN

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
140: ROLLBACK TO create_user_role;
141: END IF;
142:
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

139: IF p_commit = FND_API.G_TRUE THEN
140: ROLLBACK TO create_user_role;
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));

Line 157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

153: END create_prop_user_role;
154: --------------------------------------------------------------------------------------------------------------
155:
156: Procedure update_prop_user_role (
157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
160: ,x_rowid IN VARCHAR2
161: ,p_proposal_id IN NUMBER

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

154: --------------------------------------------------------------------------------------------------------------
155:
156: Procedure update_prop_user_role (
157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
160: ,x_rowid IN VARCHAR2
161: ,p_proposal_id IN NUMBER
162: ,p_proposal_number IN VARCHAR2

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

155:
156: Procedure update_prop_user_role (
157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
160: ,x_rowid IN VARCHAR2
161: ,p_proposal_id IN NUMBER
162: ,p_proposal_number IN VARCHAR2
163: ,p_user_id IN NUMBER

Line 192: IF p_commit = FND_API.G_TRUE THEN

188: l_msg_index_out NUMBER;
189:
190: BEGIN
191: -- create savepoint if p_commit is true
192: IF p_commit = FND_API.G_TRUE THEN
193: SAVEPOINT update_user_role;
194: END IF;
195:
196: -- initialize message list if p_init_msg_list is true

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

193: SAVEPOINT update_user_role;
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

Line 202: x_return_status := fnd_api.g_ret_sts_success;

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

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

279:
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,

Line 298: if fnd_api.to_boolean(p_commit) then

294: end if;
295: check_errors;
296:
297: -- standard check of p_commit
298: if fnd_api.to_boolean(p_commit) then
299: commit work;
300: end if;
301:
302:

Line 309: WHEN FND_API.G_EXC_ERROR THEN

305: p_data => x_msg_data);
306:
307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: IF p_commit = FND_API.G_TRUE THEN
311: ROLLBACK TO update_user_role;
312: END IF;
313:

Line 310: IF p_commit = FND_API.G_TRUE THEN

306:
307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: IF p_commit = FND_API.G_TRUE THEN
311: ROLLBACK TO update_user_role;
312: END IF;
313:
314: x_return_status := FND_API.G_RET_STS_ERROR;

Line 314: x_return_status := FND_API.G_RET_STS_ERROR;

310: IF p_commit = FND_API.G_TRUE THEN
311: ROLLBACK TO update_user_role;
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:

Line 321: IF p_commit = FND_API.G_TRUE THEN

317: p_data => x_msg_data);
318:
319:
320: WHEN OTHERS THEN
321: IF p_commit = FND_API.G_TRUE THEN
322: ROLLBACK TO update_user_role;
323: END IF;
324:
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

321: IF p_commit = FND_API.G_TRUE THEN
322: ROLLBACK TO update_user_role;
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));

Line 339: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

335: END update_prop_user_role;
336: --------------------------------------------------------------------------------------------------------
337:
338: Procedure delete_prop_user_role (
339: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
340: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
341: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
342: ,x_rowid IN VARCHAR2
343: ,p_logged_user_id IN NUMBER

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

336: --------------------------------------------------------------------------------------------------------
337:
338: Procedure delete_prop_user_role (
339: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
340: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
341: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
342: ,x_rowid IN VARCHAR2
343: ,p_logged_user_id IN NUMBER
344: ,p_record_version_number IN NUMBER

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

337:
338: Procedure delete_prop_user_role (
339: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
340: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
341: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
342: ,x_rowid IN VARCHAR2
343: ,p_logged_user_id IN NUMBER
344: ,p_record_version_number IN NUMBER
345: ,x_return_status OUT NOCOPY VARCHAR2

Line 365: IF p_commit = FND_API.G_TRUE THEN

361: l_msg_index_out NUMBER;
362:
363: BEGIN
364: -- create savepoint
365: IF p_commit = FND_API.G_TRUE THEN
366: SAVEPOINT delete_user_role;
367: END IF;
368:
369: -- initialize message list if p_init_msg_list is set to true

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

366: SAVEPOINT delete_user_role;
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

Line 375: x_return_status := fnd_api.g_ret_sts_success;

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

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

405:
406: check_errors;
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,

Line 422: if fnd_api.to_boolean(p_commit) then

418:
419: check_errors;
420:
421: -- standard check of p_commit
422: if fnd_api.to_boolean(p_commit) then
423: commit work;
424: end if;
425:
426:

Line 432: WHEN FND_API.G_EXC_ERROR THEN

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
433: IF p_commit = FND_API.G_TRUE THEN
434: ROLLBACK TO delete_user_role;
435: END IF;
436:

Line 433: IF p_commit = FND_API.G_TRUE THEN

429: p_data => x_msg_data);
430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: IF p_commit = FND_API.G_TRUE THEN
434: ROLLBACK TO delete_user_role;
435: END IF;
436:
437: x_return_status := FND_API.G_RET_STS_ERROR;

Line 437: x_return_status := FND_API.G_RET_STS_ERROR;

433: IF p_commit = FND_API.G_TRUE THEN
434: ROLLBACK TO delete_user_role;
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:

Line 444: IF p_commit = FND_API.G_TRUE THEN

440: p_data => x_msg_data);
441:
442:
443: WHEN OTHERS THEN
444: IF p_commit = FND_API.G_TRUE THEN
445: ROLLBACK TO delete_user_role;
446: END IF;
447:
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

444: IF p_commit = FND_API.G_TRUE THEN
445: ROLLBACK TO delete_user_role;
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));

Line 469: x_return_status:= FND_API.G_RET_STS_SUCCESS;

465: x VARCHAR2(1);
466: y VARCHAR2(1);
467:
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

Line 485: x_return_status:= FND_API.G_RET_STS_ERROR;

481:
482: EXCEPTION
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

Line 493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

489: WHEN too_many_rows THEN
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;

Line 497: raise fnd_api.g_exc_unexpected_error;

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;
499:
500: ------------------------------------------------------------------------------------------
501: PROCEDURE CHECK_LOCK_GET_PK

Line 518: x_return_status := FND_API.G_RET_STS_ERROR;

514: and record_version_number = p_record_version_number;
515:
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:

Line 521: raise fnd_api.g_exc_error;

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

Line 524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 528: raise fnd_api.g_exc_unexpected_error;

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:
530: END CHECK_LOCK_GET_PK;
531:
532: ---------------------------------------------------------------------------------------------------------

Line 539: x_return_status := FND_API.G_RET_STS_SUCCESS;

535: ,x_role_id OUT NOCOPY NUMBER
536: ,x_return_status OUT NOCOPY VARCHAR2) is
537:
538: BEGIN
539: x_return_status := FND_API.G_RET_STS_SUCCESS;
540:
541: IF p_role_name IS NOT NULL THEN
542: SELECT role_id
543: INTO x_role_id

Line 551: x_return_status:= FND_API.G_RET_STS_ERROR;

547: END IF;
548:
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

Line 556: 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');
558: fnd_msg_pub.add;
559:
560: WHEN OTHERS THEN

Line 561: x_return_status := FND_API.G_RET_STS_UNEXP_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',
563: p_procedure_name => 'GET_ROLE_ID',
564: p_error_text => SUBSTRB(SQLERRM,1,240));
565: raise fnd_api.g_exc_unexpected_error;

Line 565: raise fnd_api.g_exc_unexpected_error;

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;
567:
568: ------------------------------------------------------------------------------------
569: PROCEDURE CHECK_IF_SEEDED_ROLE

Line 576: x_return_status:= FND_API.G_RET_STS_SUCCESS;

572:
573: N NUMBER;
574:
575: BEGIN
576: x_return_status:= FND_API.G_RET_STS_SUCCESS;
577:
578: select count(*) into N
579: from igw_roles
580: where role_id = p_role_id AND

Line 584: x_return_status:= FND_API.G_RET_STS_ERROR;

580: where role_id = p_role_id AND
581: seeded_flag = 'Y';
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:

Line 591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 595: raise fnd_api.g_exc_unexpected_error;

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;
597:
598:
599: -------------------------------------------------------------------------------------------------------

Line 605: RAISE FND_API.G_EXC_ERROR;

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:
608: END CHECK_ERRORS;
609: