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.AMS_ACCESS_PVT dependencies on FND_API

Line 29: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

25: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: PROCEDURE create_access(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
30: p_commit IN VARCHAR2 := FND_API.g_false,
31: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,

Line 30: p_commit IN VARCHAR2 := FND_API.g_false,

26:
27: PROCEDURE create_access(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
30: p_commit IN VARCHAR2 := FND_API.g_false,
31: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,

Line 31: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

27: PROCEDURE create_access(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
30: p_commit IN VARCHAR2 := FND_API.g_false,
31: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_access_rec IN access_rec_type,

Line 119: IF FND_API.to_boolean(p_init_msg_list) THEN

115: AMS_Utility_PVT.debug_message(l_full_name||': start');
116:
117: END IF;
118:
119: IF FND_API.to_boolean(p_init_msg_list) THEN
120: FND_MSG_PUB.initialize;
121: END IF;
122:
123: IF NOT FND_API.compatible_api_call(

Line 123: IF NOT FND_API.compatible_api_call(

119: IF FND_API.to_boolean(p_init_msg_list) THEN
120: FND_MSG_PUB.initialize;
121: END IF;
122:
123: IF NOT FND_API.compatible_api_call(
124: l_api_version,
125: p_api_version,
126: l_api_name,
127: g_pkg_name

Line 129: RAISE FND_API.g_exc_unexpected_error;

125: p_api_version,
126: l_api_name,
127: g_pkg_name
128: ) THEN
129: RAISE FND_API.g_exc_unexpected_error;
130: END IF;
131:
132: x_return_status := FND_API.g_ret_sts_success;
133:

Line 132: x_return_status := FND_API.g_ret_sts_success;

128: ) THEN
129: RAISE FND_API.g_exc_unexpected_error;
130: END IF;
131:
132: x_return_status := FND_API.g_ret_sts_success;
133:
134: ----------------------- validate -----------------------
135: IF (AMS_DEBUG_HIGH_ON) THEN
136:

Line 150: IF l_return_status = FND_API.g_ret_sts_error THEN

146: x_msg_data => x_msg_data,
147: p_access_rec => l_access_rec
148: );
149:
150: IF l_return_status = FND_API.g_ret_sts_error THEN
151: RAISE FND_API.g_exc_error;
152: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
153: RAISE FND_API.g_exc_unexpected_error;
154: END IF;

Line 151: RAISE FND_API.g_exc_error;

147: p_access_rec => l_access_rec
148: );
149:
150: IF l_return_status = FND_API.g_ret_sts_error THEN
151: RAISE FND_API.g_exc_error;
152: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
153: RAISE FND_API.g_exc_unexpected_error;
154: END IF;
155:

Line 152: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

148: );
149:
150: IF l_return_status = FND_API.g_ret_sts_error THEN
151: RAISE FND_API.g_exc_error;
152: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
153: RAISE FND_API.g_exc_unexpected_error;
154: END IF;
155:
156:

Line 153: RAISE FND_API.g_exc_unexpected_error;

149:
150: IF l_return_status = FND_API.g_ret_sts_error THEN
151: RAISE FND_API.g_exc_error;
152: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
153: RAISE FND_API.g_exc_unexpected_error;
154: END IF;
155:
156:
157: -------------------------- insert --------------------------

Line 173: RAISE FND_API.g_exc_error;

169: FETCH c_group_exists INTO l_group_exists;
170: IF p_access_rec.arc_user_or_role_type = 'GROUP' AND c_group_exists%NOTFOUND THEN
171: FND_MESSAGE.set_name('AMS', 'AMS_RUN_ACCESS_REFRESH_PROGRAM');
172: FND_MSG_PUB.add;
173: RAISE FND_API.g_exc_error;
174: END IF;
175: CLOSE c_group_exists;
176: IF l_access_rec.activity_access_id IS NULL THEN
177: LOOP

Line 244: IF l_return_status = FND_API.g_ret_sts_error THEN

240: x_msg_count => x_msg_count,
241: x_msg_data => x_msg_data
242: );
243:
244: IF l_return_status = FND_API.g_ret_sts_error THEN
245: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
246: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
247: FND_MSG_PUB.add;
248: RAISE FND_API.g_exc_error;

Line 248: RAISE FND_API.g_exc_error;

244: IF l_return_status = FND_API.g_ret_sts_error THEN
245: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
246: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
247: FND_MSG_PUB.add;
248: RAISE FND_API.g_exc_error;
249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
250: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
251: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
252: FND_MSG_PUB.add;

Line 249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

245: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
246: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
247: FND_MSG_PUB.add;
248: RAISE FND_API.g_exc_error;
249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
250: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
251: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
252: FND_MSG_PUB.add;
253: RAISE FND_API.g_exc_unexpected_error;

Line 253: RAISE FND_API.g_exc_unexpected_error;

249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
250: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
251: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
252: FND_MSG_PUB.add;
253: RAISE FND_API.g_exc_unexpected_error;
254: END IF;
255:
256: END IF;
257: -- if (l_access_rec.arc_act_access_to_object <> 'FUND' ) then

Line 263: p_init_msg_list => FND_API.g_false,

259: /************* Modify Attribute ******************************/
260: /***
261: AMS_ObjectAttribute_PVT.modify_object_attribute(
262: p_api_version => l_api_version,
263: p_init_msg_list => FND_API.g_false,
264: p_commit => FND_API.g_false,
265: p_validation_level => FND_API.g_valid_level_full,
266:
267: x_return_status => l_return_status,

Line 264: p_commit => FND_API.g_false,

260: /***
261: AMS_ObjectAttribute_PVT.modify_object_attribute(
262: p_api_version => l_api_version,
263: p_init_msg_list => FND_API.g_false,
264: p_commit => FND_API.g_false,
265: p_validation_level => FND_API.g_valid_level_full,
266:
267: x_return_status => l_return_status,
268: x_msg_count => x_msg_count,

Line 265: p_validation_level => FND_API.g_valid_level_full,

261: AMS_ObjectAttribute_PVT.modify_object_attribute(
262: p_api_version => l_api_version,
263: p_init_msg_list => FND_API.g_false,
264: p_commit => FND_API.g_false,
265: p_validation_level => FND_API.g_valid_level_full,
266:
267: x_return_status => l_return_status,
268: x_msg_count => x_msg_count,
269: x_msg_data => x_msg_data,

Line 352: IF l_return_status = FND_API.g_ret_sts_error THEN

348: x_msg_count => x_msg_count,
349: x_msg_data => x_msg_data
350: );
351:
352: IF l_return_status = FND_API.g_ret_sts_error THEN
353: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
354: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
355: FND_MSG_PUB.add;
356: RAISE FND_API.g_exc_error;

Line 356: RAISE FND_API.g_exc_error;

352: IF l_return_status = FND_API.g_ret_sts_error THEN
353: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
354: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
355: FND_MSG_PUB.add;
356: RAISE FND_API.g_exc_error;
357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
358: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
359: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
360: FND_MSG_PUB.add;

Line 357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

353: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
354: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
355: FND_MSG_PUB.add;
356: RAISE FND_API.g_exc_error;
357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
358: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
359: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
360: FND_MSG_PUB.add;
361: RAISE FND_API.g_exc_unexpected_error;

Line 361: RAISE FND_API.g_exc_unexpected_error;

357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
358: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
359: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
360: FND_MSG_PUB.add;
361: RAISE FND_API.g_exc_unexpected_error;
362: END IF;
363:
364: END IF;
365:

Line 457: IF l_return_status = FND_API.g_ret_sts_error THEN

453: x_msg_count => x_msg_count,
454: x_msg_data => x_msg_data
455: );
456:
457: IF l_return_status = FND_API.g_ret_sts_error THEN
458: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
459: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
460: FND_MSG_PUB.add;
461: RAISE FND_API.g_exc_error;

Line 461: RAISE FND_API.g_exc_error;

457: IF l_return_status = FND_API.g_ret_sts_error THEN
458: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
459: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
460: FND_MSG_PUB.add;
461: RAISE FND_API.g_exc_error;
462: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
463: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
464: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
465: FND_MSG_PUB.add;

Line 462: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

458: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
459: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
460: FND_MSG_PUB.add;
461: RAISE FND_API.g_exc_error;
462: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
463: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
464: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
465: FND_MSG_PUB.add;
466: RAISE FND_API.g_exc_unexpected_error;

Line 466: RAISE FND_API.g_exc_unexpected_error;

462: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
463: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
464: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
465: FND_MSG_PUB.add;
466: RAISE FND_API.g_exc_unexpected_error;
467: END IF;
468: END IF; --for arc_user_or_role_type = 'USER'
469: END IF; --for l_qp_list_header_id IS NOT NULL
470: END IF; -- for l_fund_type = 'FULLY_ACCRUED'

Line 477: IF l_return_status = FND_API.g_ret_sts_error THEN

473: END IF ;-- obj_type
474: -- end change for schedule level access
475:
476: /*****************************************************************/
477: IF l_return_status = FND_API.g_ret_sts_error THEN
478: RAISE FND_API.g_exc_error;
479: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
480: RAISE FND_API.g_exc_unexpected_error;
481: END IF;

Line 478: RAISE FND_API.g_exc_error;

474: -- end change for schedule level access
475:
476: /*****************************************************************/
477: IF l_return_status = FND_API.g_ret_sts_error THEN
478: RAISE FND_API.g_exc_error;
479: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
480: RAISE FND_API.g_exc_unexpected_error;
481: END IF;
482: -----------------------------------------------------------------

Line 479: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

475:
476: /*****************************************************************/
477: IF l_return_status = FND_API.g_ret_sts_error THEN
478: RAISE FND_API.g_exc_error;
479: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
480: RAISE FND_API.g_exc_unexpected_error;
481: END IF;
482: -----------------------------------------------------------------
483:

Line 480: RAISE FND_API.g_exc_unexpected_error;

476: /*****************************************************************/
477: IF l_return_status = FND_API.g_ret_sts_error THEN
478: RAISE FND_API.g_exc_error;
479: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
480: RAISE FND_API.g_exc_unexpected_error;
481: END IF;
482: -----------------------------------------------------------------
483:
484: IF FND_API.to_boolean(p_commit) THEN

Line 484: IF FND_API.to_boolean(p_commit) THEN

480: RAISE FND_API.g_exc_unexpected_error;
481: END IF;
482: -----------------------------------------------------------------
483:
484: IF FND_API.to_boolean(p_commit) THEN
485: COMMIT;
486: END IF;
487:
488: FND_MSG_PUB.count_and_get(

Line 489: p_encoded => FND_API.g_false,

485: COMMIT;
486: END IF;
487:
488: FND_MSG_PUB.count_and_get(
489: p_encoded => FND_API.g_false,
490: p_count => x_msg_count,
491: p_data => x_msg_data
492: );
493:

Line 504: WHEN FND_API.g_exc_error THEN

500: END IF;
501:
502: EXCEPTION
503:
504: WHEN FND_API.g_exc_error THEN
505: ROLLBACK TO create_access;
506: x_return_status := FND_API.g_ret_sts_error;
507: FND_MSG_PUB.count_and_get(
508: p_encoded => FND_API.g_false,

Line 506: x_return_status := FND_API.g_ret_sts_error;

502: EXCEPTION
503:
504: WHEN FND_API.g_exc_error THEN
505: ROLLBACK TO create_access;
506: x_return_status := FND_API.g_ret_sts_error;
507: FND_MSG_PUB.count_and_get(
508: p_encoded => FND_API.g_false,
509: p_count => x_msg_count,
510: p_data => x_msg_data

Line 508: p_encoded => FND_API.g_false,

504: WHEN FND_API.g_exc_error THEN
505: ROLLBACK TO create_access;
506: x_return_status := FND_API.g_ret_sts_error;
507: FND_MSG_PUB.count_and_get(
508: p_encoded => FND_API.g_false,
509: p_count => x_msg_count,
510: p_data => x_msg_data
511: );
512:

Line 513: WHEN FND_API.g_exc_unexpected_error THEN

509: p_count => x_msg_count,
510: p_data => x_msg_data
511: );
512:
513: WHEN FND_API.g_exc_unexpected_error THEN
514: ROLLBACK TO create_access;
515: x_return_status := FND_API.g_ret_sts_unexp_error ;
516: FND_MSG_PUB.count_and_get(
517: p_encoded => FND_API.g_false,

Line 515: x_return_status := FND_API.g_ret_sts_unexp_error ;

511: );
512:
513: WHEN FND_API.g_exc_unexpected_error THEN
514: ROLLBACK TO create_access;
515: x_return_status := FND_API.g_ret_sts_unexp_error ;
516: FND_MSG_PUB.count_and_get(
517: p_encoded => FND_API.g_false,
518: p_count => x_msg_count,
519: p_data => x_msg_data

Line 517: p_encoded => FND_API.g_false,

513: WHEN FND_API.g_exc_unexpected_error THEN
514: ROLLBACK TO create_access;
515: x_return_status := FND_API.g_ret_sts_unexp_error ;
516: FND_MSG_PUB.count_and_get(
517: p_encoded => FND_API.g_false,
518: p_count => x_msg_count,
519: p_data => x_msg_data
520: );
521:

Line 525: x_return_status := FND_API.g_ret_sts_unexp_error ;

521:
522:
523: WHEN OTHERS THEN
524: ROLLBACK TO create_access;
525: x_return_status := FND_API.g_ret_sts_unexp_error ;
526:
527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
528: THEN
529: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 533: p_encoded => FND_API.g_false,

529: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
530: END IF;
531:
532: FND_MSG_PUB.count_and_get(
533: p_encoded => FND_API.g_false,
534: p_count => x_msg_count,
535: p_data => x_msg_data
536: );
537:

Line 548: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

544: -- 10/12/99 abhola Create.
545: ---------------------------------------------------------------
546: PROCEDURE delete_access(
547: p_api_version IN NUMBER,
548: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
549: p_commit IN VARCHAR2 := FND_API.g_false,
550: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
551: x_return_status OUT NOCOPY VARCHAR2,
552: x_msg_count OUT NOCOPY NUMBER,

Line 549: p_commit IN VARCHAR2 := FND_API.g_false,

545: ---------------------------------------------------------------
546: PROCEDURE delete_access(
547: p_api_version IN NUMBER,
548: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
549: p_commit IN VARCHAR2 := FND_API.g_false,
550: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
551: x_return_status OUT NOCOPY VARCHAR2,
552: x_msg_count OUT NOCOPY NUMBER,
553: x_msg_data OUT NOCOPY VARCHAR2,

Line 550: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

546: PROCEDURE delete_access(
547: p_api_version IN NUMBER,
548: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
549: p_commit IN VARCHAR2 := FND_API.g_false,
550: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
551: x_return_status OUT NOCOPY VARCHAR2,
552: x_msg_count OUT NOCOPY NUMBER,
553: x_msg_data OUT NOCOPY VARCHAR2,
554: p_access_id IN NUMBER,

Line 653: IF FND_API.to_boolean(p_init_msg_list) THEN

649: AMS_Utility_PVT.debug_message(l_full_name||': start');
650:
651: END IF;
652:
653: IF FND_API.to_boolean(p_init_msg_list) THEN
654: FND_MSG_PUB.initialize;
655: END IF;
656:
657: IF NOT FND_API.compatible_api_call(

Line 657: IF NOT FND_API.compatible_api_call(

653: IF FND_API.to_boolean(p_init_msg_list) THEN
654: FND_MSG_PUB.initialize;
655: END IF;
656:
657: IF NOT FND_API.compatible_api_call(
658: l_api_version,
659: p_api_version,
660: l_api_name,
661: g_pkg_name

Line 663: RAISE FND_API.g_exc_unexpected_error;

659: p_api_version,
660: l_api_name,
661: g_pkg_name
662: ) THEN
663: RAISE FND_API.g_exc_unexpected_error;
664: END IF;
665:
666:
667: ----- Get the object type and obj id for this access id ----

Line 675: x_return_status := FND_API.G_RET_STS_SUCCESS;

671: CLOSE c_getobj_type_id;
672:
673: --------------------------------------------------------------
674:
675: x_return_status := FND_API.G_RET_STS_SUCCESS;
676:
677: ------------------------ delete ------------------------
678: IF (AMS_DEBUG_HIGH_ON) THEN
679:

Line 695: RAISE FND_API.g_exc_error;

691: THEN
692: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
693: FND_MSG_PUB.add;
694: END IF;
695: RAISE FND_API.g_exc_error;
696: END IF;
697:
698:
699: -- Added by rrajesh on 09/12/01 - for campaign schedules

Line 730: RAISE FND_API.g_exc_error;

726: THEN
727: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
728: FND_MSG_PUB.add;
729: END IF;
730: RAISE FND_API.g_exc_error;
731: END IF;
732:
733: ams_access_denorm_pvt.delete_resource (
734: p_resource_id => l_role_id,

Line 743: IF l_return_status = FND_API.g_ret_sts_error THEN

739: x_msg_count => x_msg_count,
740: x_msg_data => x_msg_data
741: );
742:
743: IF l_return_status = FND_API.g_ret_sts_error THEN
744: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
745: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
746: FND_MSG_PUB.add;
747: RAISE FND_API.g_exc_error;

Line 747: RAISE FND_API.g_exc_error;

743: IF l_return_status = FND_API.g_ret_sts_error THEN
744: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
745: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
746: FND_MSG_PUB.add;
747: RAISE FND_API.g_exc_error;
748: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
749: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
750: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
751: FND_MSG_PUB.add;

Line 748: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

744: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
745: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
746: FND_MSG_PUB.add;
747: RAISE FND_API.g_exc_error;
748: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
749: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
750: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
751: FND_MSG_PUB.add;
752: RAISE FND_API.g_exc_unexpected_error;

Line 752: RAISE FND_API.g_exc_unexpected_error;

748: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
749: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
750: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
751: FND_MSG_PUB.add;
752: RAISE FND_API.g_exc_unexpected_error;
753: END IF;
754: END LOOP;
755: CLOSE c_access_camp_schedules;
756:

Line 778: RAISE FND_API.g_exc_error;

774: THEN
775: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
776: FND_MSG_PUB.add;
777: END IF;
778: RAISE FND_API.g_exc_error;
779: END IF;
780:
781: ams_access_denorm_pvt.delete_resource (
782: p_resource_id => l_role_id,

Line 791: IF l_return_status = FND_API.g_ret_sts_error THEN

787: x_msg_count => x_msg_count,
788: x_msg_data => x_msg_data
789: );
790:
791: IF l_return_status = FND_API.g_ret_sts_error THEN
792: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
793: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
794: FND_MSG_PUB.add;
795: RAISE FND_API.g_exc_error;

Line 795: RAISE FND_API.g_exc_error;

791: IF l_return_status = FND_API.g_ret_sts_error THEN
792: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
793: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
794: FND_MSG_PUB.add;
795: RAISE FND_API.g_exc_error;
796: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
797: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
798: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
799: FND_MSG_PUB.add;

Line 796: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

792: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
793: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
794: FND_MSG_PUB.add;
795: RAISE FND_API.g_exc_error;
796: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
797: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
798: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
799: FND_MSG_PUB.add;
800: RAISE FND_API.g_exc_unexpected_error;

Line 800: RAISE FND_API.g_exc_unexpected_error;

796: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
797: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
798: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
799: FND_MSG_PUB.add;
800: RAISE FND_API.g_exc_unexpected_error;
801: END IF;
802:
803: END IF; --for l_qp_list_header_id IS NOT NULL
804:

Line 821: IF l_return_status = FND_API.g_ret_sts_error THEN

817: x_msg_count => x_msg_count,
818: x_msg_data => x_msg_data
819: );
820:
821: IF l_return_status = FND_API.g_ret_sts_error THEN
822: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
823: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
824: FND_MSG_PUB.add;
825: RAISE FND_API.g_exc_error;

Line 825: RAISE FND_API.g_exc_error;

821: IF l_return_status = FND_API.g_ret_sts_error THEN
822: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
823: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
824: FND_MSG_PUB.add;
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
828: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
829: FND_MSG_PUB.add;

Line 826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

822: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
823: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
824: FND_MSG_PUB.add;
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
828: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
829: FND_MSG_PUB.add;
830: RAISE FND_API.g_exc_unexpected_error;

Line 830: RAISE FND_API.g_exc_unexpected_error;

826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
828: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
829: FND_MSG_PUB.add;
830: RAISE FND_API.g_exc_unexpected_error;
831: END IF;
832:
833: ELSIF l_role_type = 'GROUP' THEN
834:

Line 849: RAISE FND_API.g_exc_error;

845: THEN
846: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
847: FND_MSG_PUB.add;
848: END IF;
849: RAISE FND_API.g_exc_error;
850: END IF;
851:
852: -- Added by rrajesh on 09/12/01 - for campaign schedules
853:

Line 887: RAISE FND_API.g_exc_error;

883: THEN
884: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
885: FND_MSG_PUB.add;
886: END IF;
887: RAISE FND_API.g_exc_error;
888: END IF;
889: END LOOP;
890: CLOSE c_access_camp_schedules;
891:

Line 920: RAISE FND_API.g_exc_error;

916: THEN
917: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
918: FND_MSG_PUB.add;
919: END IF;
920: RAISE FND_API.g_exc_error;
921: END IF;
922: END IF; --for l_qp_list_header_id IS NOT NULL
923: END IF; -- for l_fund_type = 'FULLY_ACCRUED'
924:

Line 941: p_init_msg_list => FND_API.g_false,

937: if (c_getobj_attr%NOTFOUND) then
938:
939: AMS_ObjectAttribute_PVT.modify_object_attribute(
940: p_api_version => l_api_version,
941: p_init_msg_list => FND_API.g_false,
942: p_commit => FND_API.g_false,
943: p_validation_level => FND_API.g_valid_level_full,
944: x_return_status => l_return_status,
945: x_msg_count => x_msg_count,

Line 942: p_commit => FND_API.g_false,

938:
939: AMS_ObjectAttribute_PVT.modify_object_attribute(
940: p_api_version => l_api_version,
941: p_init_msg_list => FND_API.g_false,
942: p_commit => FND_API.g_false,
943: p_validation_level => FND_API.g_valid_level_full,
944: x_return_status => l_return_status,
945: x_msg_count => x_msg_count,
946: x_msg_data => x_msg_data,

Line 943: p_validation_level => FND_API.g_valid_level_full,

939: AMS_ObjectAttribute_PVT.modify_object_attribute(
940: p_api_version => l_api_version,
941: p_init_msg_list => FND_API.g_false,
942: p_commit => FND_API.g_false,
943: p_validation_level => FND_API.g_valid_level_full,
944: x_return_status => l_return_status,
945: x_msg_count => x_msg_count,
946: x_msg_data => x_msg_data,
947:

Line 953: IF l_return_status = FND_API.g_ret_sts_error THEN

949: p_object_id => l_object_id ,
950: p_attr => 'TEAM',
951: p_attr_defined_flag => 'N'
952: );
953: IF l_return_status = FND_API.g_ret_sts_error THEN
954: RAISE FND_API.g_exc_error;
955: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
956: RAISE FND_API.g_exc_unexpected_error;
957: END IF;

Line 954: RAISE FND_API.g_exc_error;

950: p_attr => 'TEAM',
951: p_attr_defined_flag => 'N'
952: );
953: IF l_return_status = FND_API.g_ret_sts_error THEN
954: RAISE FND_API.g_exc_error;
955: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
956: RAISE FND_API.g_exc_unexpected_error;
957: END IF;
958:

Line 955: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

951: p_attr_defined_flag => 'N'
952: );
953: IF l_return_status = FND_API.g_ret_sts_error THEN
954: RAISE FND_API.g_exc_error;
955: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
956: RAISE FND_API.g_exc_unexpected_error;
957: END IF;
958:
959: end if;

Line 956: RAISE FND_API.g_exc_unexpected_error;

952: );
953: IF l_return_status = FND_API.g_ret_sts_error THEN
954: RAISE FND_API.g_exc_error;
955: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
956: RAISE FND_API.g_exc_unexpected_error;
957: END IF;
958:
959: end if;
960: -- end if;

Line 966: IF FND_API.to_boolean(p_commit) THEN

962: ------------------------------------------------------
963:
964:
965: -------------------- finish --------------------------
966: IF FND_API.to_boolean(p_commit) THEN
967: COMMIT;
968: END IF;
969:
970: FND_MSG_PUB.count_and_get(

Line 971: p_encoded => FND_API.g_false,

967: COMMIT;
968: END IF;
969:
970: FND_MSG_PUB.count_and_get(
971: p_encoded => FND_API.g_false,
972: p_count => x_msg_count,
973: p_data => x_msg_data
974: );
975:

Line 986: WHEN FND_API.g_exc_error THEN

982: END IF;
983:
984: EXCEPTION
985:
986: WHEN FND_API.g_exc_error THEN
987: ROLLBACK TO delete_access;
988: x_return_status := FND_API.g_ret_sts_error;
989: FND_MSG_PUB.count_and_get(
990: p_encoded => FND_API.g_false,

Line 988: x_return_status := FND_API.g_ret_sts_error;

984: EXCEPTION
985:
986: WHEN FND_API.g_exc_error THEN
987: ROLLBACK TO delete_access;
988: x_return_status := FND_API.g_ret_sts_error;
989: FND_MSG_PUB.count_and_get(
990: p_encoded => FND_API.g_false,
991: p_count => x_msg_count,
992: p_data => x_msg_data

Line 990: p_encoded => FND_API.g_false,

986: WHEN FND_API.g_exc_error THEN
987: ROLLBACK TO delete_access;
988: x_return_status := FND_API.g_ret_sts_error;
989: FND_MSG_PUB.count_and_get(
990: p_encoded => FND_API.g_false,
991: p_count => x_msg_count,
992: p_data => x_msg_data
993: );
994:

Line 995: WHEN FND_API.g_exc_unexpected_error THEN

991: p_count => x_msg_count,
992: p_data => x_msg_data
993: );
994:
995: WHEN FND_API.g_exc_unexpected_error THEN
996: ROLLBACK TO delete_access;
997: x_return_status := FND_API.g_ret_sts_unexp_error ;
998: FND_MSG_PUB.count_and_get(
999: p_encoded => FND_API.g_false,

Line 997: x_return_status := FND_API.g_ret_sts_unexp_error ;

993: );
994:
995: WHEN FND_API.g_exc_unexpected_error THEN
996: ROLLBACK TO delete_access;
997: x_return_status := FND_API.g_ret_sts_unexp_error ;
998: FND_MSG_PUB.count_and_get(
999: p_encoded => FND_API.g_false,
1000: p_count => x_msg_count,
1001: p_data => x_msg_data

Line 999: p_encoded => FND_API.g_false,

995: WHEN FND_API.g_exc_unexpected_error THEN
996: ROLLBACK TO delete_access;
997: x_return_status := FND_API.g_ret_sts_unexp_error ;
998: FND_MSG_PUB.count_and_get(
999: p_encoded => FND_API.g_false,
1000: p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );
1003:

Line 1006: x_return_status := FND_API.g_ret_sts_unexp_error ;

1002: );
1003:
1004: WHEN OTHERS THEN
1005: ROLLBACK TO delete_access;
1006: x_return_status := FND_API.g_ret_sts_unexp_error ;
1007:
1008: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1009: THEN
1010: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1014: p_encoded => FND_API.g_false,

1010: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1011: END IF;
1012:
1013: FND_MSG_PUB.count_and_get(
1014: p_encoded => FND_API.g_false,
1015: p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );
1018:

Line 1030: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1026: -- 10/12/99 abhola Create.
1027: --------------------------------------------------------------------
1028: PROCEDURE lock_access(
1029: p_api_version IN NUMBER,
1030: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1031: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1032:
1033: x_return_status OUT NOCOPY VARCHAR2,
1034: x_msg_count OUT NOCOPY NUMBER,

Line 1031: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1027: --------------------------------------------------------------------
1028: PROCEDURE lock_access(
1029: p_api_version IN NUMBER,
1030: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1031: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1032:
1033: x_return_status OUT NOCOPY VARCHAR2,
1034: x_msg_count OUT NOCOPY NUMBER,
1035: x_msg_data OUT NOCOPY VARCHAR2,

Line 1064: IF FND_API.to_boolean(p_init_msg_list) THEN

1060:
1061: AMS_Utility_PVT.debug_message(l_full_name||': start');
1062: END IF;
1063:
1064: IF FND_API.to_boolean(p_init_msg_list) THEN
1065: FND_MSG_PUB.initialize;
1066: END IF;
1067:
1068: IF NOT FND_API.compatible_api_call(

Line 1068: IF NOT FND_API.compatible_api_call(

1064: IF FND_API.to_boolean(p_init_msg_list) THEN
1065: FND_MSG_PUB.initialize;
1066: END IF;
1067:
1068: IF NOT FND_API.compatible_api_call(
1069: l_api_version,
1070: p_api_version,
1071: l_api_name,
1072: g_pkg_name

Line 1074: RAISE FND_API.g_exc_unexpected_error;

1070: p_api_version,
1071: l_api_name,
1072: g_pkg_name
1073: ) THEN
1074: RAISE FND_API.g_exc_unexpected_error;
1075: END IF;
1076:
1077: x_return_status := FND_API.G_RET_STS_SUCCESS;
1078:

Line 1077: x_return_status := FND_API.G_RET_STS_SUCCESS;

1073: ) THEN
1074: RAISE FND_API.g_exc_unexpected_error;
1075: END IF;
1076:
1077: x_return_status := FND_API.G_RET_STS_SUCCESS;
1078:
1079: ------------------------ lock -------------------------
1080: IF (AMS_DEBUG_HIGH_ON) THEN
1081:

Line 1093: RAISE FND_API.g_exc_error;

1089: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1090: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1091: FND_MSG_PUB.add;
1092: END IF;
1093: RAISE FND_API.g_exc_error;
1094: END IF;
1095: CLOSE c_access_b;
1096: -------------------- finish --------------------------
1097: FND_MSG_PUB.count_and_get(

Line 1098: p_encoded => FND_API.g_false,

1094: END IF;
1095: CLOSE c_access_b;
1096: -------------------- finish --------------------------
1097: FND_MSG_PUB.count_and_get(
1098: p_encoded => FND_API.g_false,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data
1101: );
1102:

Line 1114: x_return_status := FND_API.g_ret_sts_error;

1110:
1111: EXCEPTION
1112:
1113: WHEN AMS_Utility_PVT.resource_locked THEN
1114: x_return_status := FND_API.g_ret_sts_error;
1115: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1116: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1117: FND_MSG_PUB.add;
1118: END IF;

Line 1121: p_encoded => FND_API.g_false,

1117: FND_MSG_PUB.add;
1118: END IF;
1119:
1120: FND_MSG_PUB.count_and_get(
1121: p_encoded => FND_API.g_false,
1122: p_count => x_msg_count,
1123: p_data => x_msg_data
1124: );
1125:

Line 1126: WHEN FND_API.g_exc_error THEN

1122: p_count => x_msg_count,
1123: p_data => x_msg_data
1124: );
1125:
1126: WHEN FND_API.g_exc_error THEN
1127: x_return_status := FND_API.g_ret_sts_error;
1128: FND_MSG_PUB.count_and_get(
1129: p_encoded => FND_API.g_false,
1130: p_count => x_msg_count,

Line 1127: x_return_status := FND_API.g_ret_sts_error;

1123: p_data => x_msg_data
1124: );
1125:
1126: WHEN FND_API.g_exc_error THEN
1127: x_return_status := FND_API.g_ret_sts_error;
1128: FND_MSG_PUB.count_and_get(
1129: p_encoded => FND_API.g_false,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data

Line 1129: p_encoded => FND_API.g_false,

1125:
1126: WHEN FND_API.g_exc_error THEN
1127: x_return_status := FND_API.g_ret_sts_error;
1128: FND_MSG_PUB.count_and_get(
1129: p_encoded => FND_API.g_false,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1132: );
1133:

Line 1134: WHEN FND_API.g_exc_unexpected_error THEN

1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1132: );
1133:
1134: WHEN FND_API.g_exc_unexpected_error THEN
1135: x_return_status := FND_API.g_ret_sts_unexp_error ;
1136: FND_MSG_PUB.count_and_get(
1137: p_encoded => FND_API.g_false,
1138: p_count => x_msg_count,

Line 1135: x_return_status := FND_API.g_ret_sts_unexp_error ;

1131: p_data => x_msg_data
1132: );
1133:
1134: WHEN FND_API.g_exc_unexpected_error THEN
1135: x_return_status := FND_API.g_ret_sts_unexp_error ;
1136: FND_MSG_PUB.count_and_get(
1137: p_encoded => FND_API.g_false,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data

Line 1137: p_encoded => FND_API.g_false,

1133:
1134: WHEN FND_API.g_exc_unexpected_error THEN
1135: x_return_status := FND_API.g_ret_sts_unexp_error ;
1136: FND_MSG_PUB.count_and_get(
1137: p_encoded => FND_API.g_false,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );
1141:

Line 1143: x_return_status := FND_API.g_ret_sts_unexp_error ;

1139: p_data => x_msg_data
1140: );
1141:
1142: WHEN OTHERS THEN
1143: x_return_status := FND_API.g_ret_sts_unexp_error ;
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1145: THEN
1146: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1147: END IF;

Line 1150: p_encoded => FND_API.g_false,

1146: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1147: END IF;
1148:
1149: FND_MSG_PUB.count_and_get(
1150: p_encoded => FND_API.g_false,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1153: );
1154:

Line 1167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1163: -- 10/12/99 abhola Create.
1164: ----------------------------------------------------------------------
1165: PROCEDURE update_access(
1166: p_api_version IN NUMBER,
1167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1168: p_commit IN VARCHAR2 := FND_API.g_false,
1169: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1170: x_return_status OUT NOCOPY VARCHAR2,
1171: x_msg_count OUT NOCOPY NUMBER,

Line 1168: p_commit IN VARCHAR2 := FND_API.g_false,

1164: ----------------------------------------------------------------------
1165: PROCEDURE update_access(
1166: p_api_version IN NUMBER,
1167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1168: p_commit IN VARCHAR2 := FND_API.g_false,
1169: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1170: x_return_status OUT NOCOPY VARCHAR2,
1171: x_msg_count OUT NOCOPY NUMBER,
1172: x_msg_data OUT NOCOPY VARCHAR2,

Line 1169: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1165: PROCEDURE update_access(
1166: p_api_version IN NUMBER,
1167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1168: p_commit IN VARCHAR2 := FND_API.g_false,
1169: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1170: x_return_status OUT NOCOPY VARCHAR2,
1171: x_msg_count OUT NOCOPY NUMBER,
1172: x_msg_data OUT NOCOPY VARCHAR2,
1173: p_access_rec IN access_rec_type

Line 1254: IF FND_API.to_boolean(p_init_msg_list) THEN

1250: AMS_Utility_PVT.debug_message(l_full_name||': start');
1251:
1252: END IF;
1253:
1254: IF FND_API.to_boolean(p_init_msg_list) THEN
1255: FND_MSG_PUB.initialize;
1256: END IF;
1257:
1258: IF NOT FND_API.compatible_api_call(

Line 1258: IF NOT FND_API.compatible_api_call(

1254: IF FND_API.to_boolean(p_init_msg_list) THEN
1255: FND_MSG_PUB.initialize;
1256: END IF;
1257:
1258: IF NOT FND_API.compatible_api_call(
1259: l_api_version,
1260: p_api_version,
1261: l_api_name,
1262: g_pkg_name

Line 1264: RAISE FND_API.g_exc_unexpected_error;

1260: p_api_version,
1261: l_api_name,
1262: g_pkg_name
1263: ) THEN
1264: RAISE FND_API.g_exc_unexpected_error;
1265: END IF;
1266:
1267: x_return_status := FND_API.G_RET_STS_SUCCESS;
1268:

Line 1267: x_return_status := FND_API.G_RET_STS_SUCCESS;

1263: ) THEN
1264: RAISE FND_API.g_exc_unexpected_error;
1265: END IF;
1266:
1267: x_return_status := FND_API.G_RET_STS_SUCCESS;
1268:
1269: ----------------------- validate ----------------------
1270: IF (AMS_DEBUG_HIGH_ON) THEN
1271:

Line 1284: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1280: p_validation_mode => JTF_PLSQL_API.g_update,
1281: x_return_status => l_return_status
1282: );
1283:
1284: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1285: RAISE FND_API.g_exc_unexpected_error;
1286: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1287: RAISE FND_API.g_exc_error;
1288: END IF;

Line 1285: RAISE FND_API.g_exc_unexpected_error;

1281: x_return_status => l_return_status
1282: );
1283:
1284: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1285: RAISE FND_API.g_exc_unexpected_error;
1286: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1287: RAISE FND_API.g_exc_error;
1288: END IF;
1289: END IF;

Line 1286: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1282: );
1283:
1284: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1285: RAISE FND_API.g_exc_unexpected_error;
1286: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1287: RAISE FND_API.g_exc_error;
1288: END IF;
1289: END IF;
1290:

Line 1287: RAISE FND_API.g_exc_error;

1283:
1284: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1285: RAISE FND_API.g_exc_unexpected_error;
1286: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1287: RAISE FND_API.g_exc_error;
1288: END IF;
1289: END IF;
1290:
1291: -- replace g_miss_char/num/date with current column values

Line 1323: RAISE FND_API.g_exc_error;

1319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1320: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1321: FND_MSG_PUB.add;
1322: END IF;
1323: RAISE FND_API.g_exc_error;
1324: END IF;
1325:
1326: /* Added by rrajesh on 09/12/01. to add access to schedules. */
1327: IF l_access_rec.arc_act_access_to_object = 'CAMP' THEN

Line 1358: RAISE FND_API.g_exc_error;

1354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1355: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1356: FND_MSG_PUB.add;
1357: END IF;
1358: RAISE FND_API.g_exc_error;
1359: END IF;
1360:
1361: ams_access_denorm_pvt.update_resource (
1362: p_resource_id => l_access_rec.user_or_role_id,

Line 1371: IF l_return_status = FND_API.g_ret_sts_error THEN

1367: x_msg_count => x_msg_count,
1368: x_msg_data => x_msg_data
1369: );
1370:
1371: IF l_return_status = FND_API.g_ret_sts_error THEN
1372: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1373: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1374: FND_MSG_PUB.add;
1375: RAISE FND_API.g_exc_error;

Line 1375: RAISE FND_API.g_exc_error;

1371: IF l_return_status = FND_API.g_ret_sts_error THEN
1372: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1373: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1374: FND_MSG_PUB.add;
1375: RAISE FND_API.g_exc_error;
1376: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1377: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1378: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1379: FND_MSG_PUB.add;

Line 1376: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1372: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1373: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1374: FND_MSG_PUB.add;
1375: RAISE FND_API.g_exc_error;
1376: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1377: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1378: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1379: FND_MSG_PUB.add;
1380: RAISE FND_API.g_exc_unexpected_error;

Line 1380: RAISE FND_API.g_exc_unexpected_error;

1376: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1377: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1378: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1379: FND_MSG_PUB.add;
1380: RAISE FND_API.g_exc_unexpected_error;
1381: END IF;
1382:
1383: END LOOP;
1384: CLOSE c_access_camp_schedules;

Line 1429: RAISE FND_API.g_exc_error;

1425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1426: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1427: FND_MSG_PUB.add;
1428: END IF;
1429: RAISE FND_API.g_exc_error;
1430: END IF;
1431:
1432: ams_access_denorm_pvt.update_resource (
1433: p_resource_id => l_access_rec.user_or_role_id,

Line 1442: IF l_return_status = FND_API.g_ret_sts_error THEN

1438: x_msg_count => x_msg_count,
1439: x_msg_data => x_msg_data
1440: );
1441:
1442: IF l_return_status = FND_API.g_ret_sts_error THEN
1443: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1444: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1445: FND_MSG_PUB.add;
1446: RAISE FND_API.g_exc_error;

Line 1446: RAISE FND_API.g_exc_error;

1442: IF l_return_status = FND_API.g_ret_sts_error THEN
1443: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1444: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1445: FND_MSG_PUB.add;
1446: RAISE FND_API.g_exc_error;
1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1448: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1449: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1450: FND_MSG_PUB.add;

Line 1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1443: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1444: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1445: FND_MSG_PUB.add;
1446: RAISE FND_API.g_exc_error;
1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1448: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1449: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1450: FND_MSG_PUB.add;
1451: RAISE FND_API.g_exc_unexpected_error;

Line 1451: RAISE FND_API.g_exc_unexpected_error;

1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1448: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1449: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1450: FND_MSG_PUB.add;
1451: RAISE FND_API.g_exc_unexpected_error;
1452: END IF;
1453: END IF; --for l_qp_list_header_id IS NOT NULL
1454: END IF; -- for l_fund_type = 'FULLY_ACCRUED'
1455:

Line 1473: IF l_return_status = FND_API.g_ret_sts_error THEN

1469: x_msg_count => x_msg_count,
1470: x_msg_data => x_msg_data
1471: );
1472:
1473: IF l_return_status = FND_API.g_ret_sts_error THEN
1474: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1475: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1476: FND_MSG_PUB.add;
1477: RAISE FND_API.g_exc_error;

Line 1477: RAISE FND_API.g_exc_error;

1473: IF l_return_status = FND_API.g_ret_sts_error THEN
1474: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1475: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1476: FND_MSG_PUB.add;
1477: RAISE FND_API.g_exc_error;
1478: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1480: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1481: FND_MSG_PUB.add;

Line 1478: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1474: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1475: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1476: FND_MSG_PUB.add;
1477: RAISE FND_API.g_exc_error;
1478: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1480: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1481: FND_MSG_PUB.add;
1482: RAISE FND_API.g_exc_unexpected_error;

Line 1482: RAISE FND_API.g_exc_unexpected_error;

1478: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1480: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1481: FND_MSG_PUB.add;
1482: RAISE FND_API.g_exc_unexpected_error;
1483: END IF;
1484:
1485: ELSIF l_access_rec.owner_flag = 'Y' THEN
1486:

Line 1497: IF l_return_status = FND_API.g_ret_sts_error THEN

1493: x_msg_count => x_msg_count,
1494: x_msg_data => x_msg_data
1495: );
1496:
1497: IF l_return_status = FND_API.g_ret_sts_error THEN
1498: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1499: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1500: FND_MSG_PUB.add;
1501: RAISE FND_API.g_exc_error;

Line 1501: RAISE FND_API.g_exc_error;

1497: IF l_return_status = FND_API.g_ret_sts_error THEN
1498: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1499: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1500: FND_MSG_PUB.add;
1501: RAISE FND_API.g_exc_error;
1502: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1503: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1504: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1505: FND_MSG_PUB.add;

Line 1502: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1498: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1499: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1500: FND_MSG_PUB.add;
1501: RAISE FND_API.g_exc_error;
1502: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1503: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1504: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1505: FND_MSG_PUB.add;
1506: RAISE FND_API.g_exc_unexpected_error;

Line 1506: RAISE FND_API.g_exc_unexpected_error;

1502: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1503: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1504: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1505: FND_MSG_PUB.add;
1506: RAISE FND_API.g_exc_unexpected_error;
1507: END IF;
1508:
1509: ams_access_denorm_pvt.insert_resource (
1510: p_resource_id => l_access_rec.user_or_role_id,

Line 1519: IF l_return_status = FND_API.g_ret_sts_error THEN

1515: x_msg_count => x_msg_count,
1516: x_msg_data => x_msg_data
1517: );
1518:
1519: IF l_return_status = FND_API.g_ret_sts_error THEN
1520: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1521: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1522: FND_MSG_PUB.add;
1523: RAISE FND_API.g_exc_error;

Line 1523: RAISE FND_API.g_exc_error;

1519: IF l_return_status = FND_API.g_ret_sts_error THEN
1520: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1521: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1522: FND_MSG_PUB.add;
1523: RAISE FND_API.g_exc_error;
1524: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1525: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1526: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1527: FND_MSG_PUB.add;

Line 1524: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1520: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1521: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1522: FND_MSG_PUB.add;
1523: RAISE FND_API.g_exc_error;
1524: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1525: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1526: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1527: FND_MSG_PUB.add;
1528: RAISE FND_API.g_exc_unexpected_error;

Line 1528: RAISE FND_API.g_exc_unexpected_error;

1524: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1525: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1526: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1527: FND_MSG_PUB.add;
1528: RAISE FND_API.g_exc_unexpected_error;
1529: END IF;
1530: END IF;
1531: END IF;
1532: -------------------- finish --------------------------

Line 1533: IF FND_API.to_boolean(p_commit) THEN

1529: END IF;
1530: END IF;
1531: END IF;
1532: -------------------- finish --------------------------
1533: IF FND_API.to_boolean(p_commit) THEN
1534: COMMIT;
1535: END IF;
1536:
1537: FND_MSG_PUB.count_and_get(

Line 1538: p_encoded => FND_API.g_false,

1534: COMMIT;
1535: END IF;
1536:
1537: FND_MSG_PUB.count_and_get(
1538: p_encoded => FND_API.g_false,
1539: p_count => x_msg_count,
1540: p_data => x_msg_data
1541: );
1542:

Line 1553: WHEN FND_API.g_exc_error THEN

1549: END IF;
1550:
1551: EXCEPTION
1552:
1553: WHEN FND_API.g_exc_error THEN
1554: ROLLBACK TO update_access;
1555: x_return_status := FND_API.g_ret_sts_error;
1556: FND_MSG_PUB.count_and_get(
1557: p_encoded => FND_API.g_false,

Line 1555: x_return_status := FND_API.g_ret_sts_error;

1551: EXCEPTION
1552:
1553: WHEN FND_API.g_exc_error THEN
1554: ROLLBACK TO update_access;
1555: x_return_status := FND_API.g_ret_sts_error;
1556: FND_MSG_PUB.count_and_get(
1557: p_encoded => FND_API.g_false,
1558: p_count => x_msg_count,
1559: p_data => x_msg_data

Line 1557: p_encoded => FND_API.g_false,

1553: WHEN FND_API.g_exc_error THEN
1554: ROLLBACK TO update_access;
1555: x_return_status := FND_API.g_ret_sts_error;
1556: FND_MSG_PUB.count_and_get(
1557: p_encoded => FND_API.g_false,
1558: p_count => x_msg_count,
1559: p_data => x_msg_data
1560: );
1561:

Line 1562: WHEN FND_API.g_exc_unexpected_error THEN

1558: p_count => x_msg_count,
1559: p_data => x_msg_data
1560: );
1561:
1562: WHEN FND_API.g_exc_unexpected_error THEN
1563: ROLLBACK TO update_access;
1564: x_return_status := FND_API.g_ret_sts_unexp_error ;
1565: FND_MSG_PUB.count_and_get(
1566: p_encoded => FND_API.g_false,

Line 1564: x_return_status := FND_API.g_ret_sts_unexp_error ;

1560: );
1561:
1562: WHEN FND_API.g_exc_unexpected_error THEN
1563: ROLLBACK TO update_access;
1564: x_return_status := FND_API.g_ret_sts_unexp_error ;
1565: FND_MSG_PUB.count_and_get(
1566: p_encoded => FND_API.g_false,
1567: p_count => x_msg_count,
1568: p_data => x_msg_data

Line 1566: p_encoded => FND_API.g_false,

1562: WHEN FND_API.g_exc_unexpected_error THEN
1563: ROLLBACK TO update_access;
1564: x_return_status := FND_API.g_ret_sts_unexp_error ;
1565: FND_MSG_PUB.count_and_get(
1566: p_encoded => FND_API.g_false,
1567: p_count => x_msg_count,
1568: p_data => x_msg_data
1569: );
1570:

Line 1573: x_return_status := FND_API.g_ret_sts_unexp_error ;

1569: );
1570:
1571: WHEN OTHERS THEN
1572: ROLLBACK TO update_access;
1573: x_return_status := FND_API.g_ret_sts_unexp_error ;
1574:
1575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1576: THEN
1577: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1581: p_encoded => FND_API.g_false,

1577: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1578: END IF;
1579:
1580: FND_MSG_PUB.count_and_get(
1581: p_encoded => FND_API.g_false,
1582: p_count => x_msg_count,
1583: p_data => x_msg_data
1584: );
1585:

Line 1596: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1592: -- 02/12/2001 skarumur Create.
1593: ----------------------------------------------------------------------
1594: PROCEDURE update_object_owner(
1595: p_api_version IN NUMBER,
1596: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1597: p_commit IN VARCHAR2 := FND_API.g_false,
1598: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1599: x_return_status OUT NOCOPY VARCHAR2,
1600: x_msg_count OUT NOCOPY NUMBER,

Line 1597: p_commit IN VARCHAR2 := FND_API.g_false,

1593: ----------------------------------------------------------------------
1594: PROCEDURE update_object_owner(
1595: p_api_version IN NUMBER,
1596: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1597: p_commit IN VARCHAR2 := FND_API.g_false,
1598: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1599: x_return_status OUT NOCOPY VARCHAR2,
1600: x_msg_count OUT NOCOPY NUMBER,
1601: x_msg_data OUT NOCOPY VARCHAR2,

Line 1598: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1594: PROCEDURE update_object_owner(
1595: p_api_version IN NUMBER,
1596: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1597: p_commit IN VARCHAR2 := FND_API.g_false,
1598: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1599: x_return_status OUT NOCOPY VARCHAR2,
1600: x_msg_count OUT NOCOPY NUMBER,
1601: x_msg_data OUT NOCOPY VARCHAR2,
1602: p_object_type IN VARCHAR2,

Line 1637: IF FND_API.to_boolean(p_init_msg_list) THEN

1633: AMS_Utility_PVT.debug_message(l_full_name||': start');
1634:
1635: END IF;
1636:
1637: IF FND_API.to_boolean(p_init_msg_list) THEN
1638: FND_MSG_PUB.initialize;
1639: END IF;
1640:
1641: IF NOT FND_API.compatible_api_call(

Line 1641: IF NOT FND_API.compatible_api_call(

1637: IF FND_API.to_boolean(p_init_msg_list) THEN
1638: FND_MSG_PUB.initialize;
1639: END IF;
1640:
1641: IF NOT FND_API.compatible_api_call(
1642: l_api_version,
1643: p_api_version,
1644: l_api_name,
1645: g_pkg_name

Line 1647: RAISE FND_API.g_exc_unexpected_error;

1643: p_api_version,
1644: l_api_name,
1645: g_pkg_name
1646: ) THEN
1647: RAISE FND_API.g_exc_unexpected_error;
1648: END IF;
1649:
1650: x_return_status := FND_API.G_RET_STS_SUCCESS;
1651:

Line 1650: x_return_status := FND_API.G_RET_STS_SUCCESS;

1646: ) THEN
1647: RAISE FND_API.g_exc_unexpected_error;
1648: END IF;
1649:
1650: x_return_status := FND_API.G_RET_STS_SUCCESS;
1651:
1652: ----------------------- validate ----------------------
1653: IF (AMS_DEBUG_HIGH_ON) THEN
1654:

Line 1699: RAISE FND_API.g_exc_error;

1695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1696: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1697: FND_MSG_PUB.add;
1698: END IF;
1699: RAISE FND_API.g_exc_error;
1700: END IF;
1701: -- END IF;
1702:
1703: ams_access_denorm_pvt.delete_resource (

Line 1713: IF l_return_status = FND_API.g_ret_sts_error THEN

1709: x_msg_count => x_msg_count,
1710: x_msg_data => x_msg_data
1711: );
1712:
1713: IF l_return_status = FND_API.g_ret_sts_error THEN
1714: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1715: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1716: FND_MSG_PUB.add;
1717: RAISE FND_API.g_exc_error;

Line 1717: RAISE FND_API.g_exc_error;

1713: IF l_return_status = FND_API.g_ret_sts_error THEN
1714: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1715: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1716: FND_MSG_PUB.add;
1717: RAISE FND_API.g_exc_error;
1718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1719: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1720: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1721: FND_MSG_PUB.add;

Line 1718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1714: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1715: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1716: FND_MSG_PUB.add;
1717: RAISE FND_API.g_exc_error;
1718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1719: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1720: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1721: FND_MSG_PUB.add;
1722: RAISE FND_API.g_exc_unexpected_error;

Line 1722: RAISE FND_API.g_exc_unexpected_error;

1718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1719: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1720: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1721: FND_MSG_PUB.add;
1722: RAISE FND_API.g_exc_unexpected_error;
1723: END IF;
1724:
1725: ams_access_denorm_pvt.insert_resource (
1726: p_resource_id => p_resource_id,

Line 1735: IF l_return_status = FND_API.g_ret_sts_error THEN

1731: x_msg_count => x_msg_count,
1732: x_msg_data => x_msg_data
1733: );
1734:
1735: IF l_return_status = FND_API.g_ret_sts_error THEN
1736: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1737: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1738: FND_MSG_PUB.add;
1739: RAISE FND_API.g_exc_error;

Line 1739: RAISE FND_API.g_exc_error;

1735: IF l_return_status = FND_API.g_ret_sts_error THEN
1736: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1737: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1738: FND_MSG_PUB.add;
1739: RAISE FND_API.g_exc_error;
1740: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1741: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1742: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1743: FND_MSG_PUB.add;

Line 1740: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1736: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1737: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1738: FND_MSG_PUB.add;
1739: RAISE FND_API.g_exc_error;
1740: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1741: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1742: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1743: FND_MSG_PUB.add;
1744: RAISE FND_API.g_exc_unexpected_error;

Line 1744: RAISE FND_API.g_exc_unexpected_error;

1740: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1741: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1742: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1743: FND_MSG_PUB.add;
1744: RAISE FND_API.g_exc_unexpected_error;
1745: END IF;
1746:
1747: -------------------- finish --------------------------
1748: IF FND_API.to_boolean(p_commit) THEN

Line 1748: IF FND_API.to_boolean(p_commit) THEN

1744: RAISE FND_API.g_exc_unexpected_error;
1745: END IF;
1746:
1747: -------------------- finish --------------------------
1748: IF FND_API.to_boolean(p_commit) THEN
1749: COMMIT;
1750: END IF;
1751:
1752: FND_MSG_PUB.count_and_get(

Line 1753: p_encoded => FND_API.g_false,

1749: COMMIT;
1750: END IF;
1751:
1752: FND_MSG_PUB.count_and_get(
1753: p_encoded => FND_API.g_false,
1754: p_count => x_msg_count,
1755: p_data => x_msg_data
1756: );
1757:

Line 1768: WHEN FND_API.g_exc_error THEN

1764: END IF;
1765:
1766: EXCEPTION
1767:
1768: WHEN FND_API.g_exc_error THEN
1769: ROLLBACK TO update_owner;
1770: x_return_status := FND_API.g_ret_sts_error;
1771: FND_MSG_PUB.count_and_get(
1772: p_encoded => FND_API.g_false,

Line 1770: x_return_status := FND_API.g_ret_sts_error;

1766: EXCEPTION
1767:
1768: WHEN FND_API.g_exc_error THEN
1769: ROLLBACK TO update_owner;
1770: x_return_status := FND_API.g_ret_sts_error;
1771: FND_MSG_PUB.count_and_get(
1772: p_encoded => FND_API.g_false,
1773: p_count => x_msg_count,
1774: p_data => x_msg_data

Line 1772: p_encoded => FND_API.g_false,

1768: WHEN FND_API.g_exc_error THEN
1769: ROLLBACK TO update_owner;
1770: x_return_status := FND_API.g_ret_sts_error;
1771: FND_MSG_PUB.count_and_get(
1772: p_encoded => FND_API.g_false,
1773: p_count => x_msg_count,
1774: p_data => x_msg_data
1775: );
1776:

Line 1777: WHEN FND_API.g_exc_unexpected_error THEN

1773: p_count => x_msg_count,
1774: p_data => x_msg_data
1775: );
1776:
1777: WHEN FND_API.g_exc_unexpected_error THEN
1778: ROLLBACK TO update_owner;
1779: x_return_status := FND_API.g_ret_sts_unexp_error ;
1780: FND_MSG_PUB.count_and_get(
1781: p_encoded => FND_API.g_false,

Line 1779: x_return_status := FND_API.g_ret_sts_unexp_error ;

1775: );
1776:
1777: WHEN FND_API.g_exc_unexpected_error THEN
1778: ROLLBACK TO update_owner;
1779: x_return_status := FND_API.g_ret_sts_unexp_error ;
1780: FND_MSG_PUB.count_and_get(
1781: p_encoded => FND_API.g_false,
1782: p_count => x_msg_count,
1783: p_data => x_msg_data

Line 1781: p_encoded => FND_API.g_false,

1777: WHEN FND_API.g_exc_unexpected_error THEN
1778: ROLLBACK TO update_owner;
1779: x_return_status := FND_API.g_ret_sts_unexp_error ;
1780: FND_MSG_PUB.count_and_get(
1781: p_encoded => FND_API.g_false,
1782: p_count => x_msg_count,
1783: p_data => x_msg_data
1784: );
1785:

Line 1788: x_return_status := FND_API.g_ret_sts_unexp_error ;

1784: );
1785:
1786: WHEN OTHERS THEN
1787: ROLLBACK TO update_owner;
1788: x_return_status := FND_API.g_ret_sts_unexp_error ;
1789:
1790: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1791: THEN
1792: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1796: p_encoded => FND_API.g_false,

1792: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1793: END IF;
1794:
1795: FND_MSG_PUB.count_and_get(
1796: p_encoded => FND_API.g_false,
1797: p_count => x_msg_count,
1798: p_data => x_msg_data
1799: );
1800:

Line 1811: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1807: -- 10/12/99 abhola Create.
1808: --------------------------------------------------------------------
1809: PROCEDURE validate_access(
1810: p_api_version IN NUMBER,
1811: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1812: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1813:
1814: x_return_status OUT NOCOPY VARCHAR2,
1815: x_msg_count OUT NOCOPY NUMBER,

Line 1812: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1808: --------------------------------------------------------------------
1809: PROCEDURE validate_access(
1810: p_api_version IN NUMBER,
1811: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1812: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1813:
1814: x_return_status OUT NOCOPY VARCHAR2,
1815: x_msg_count OUT NOCOPY NUMBER,
1816: x_msg_data OUT NOCOPY VARCHAR2,

Line 1850: IF FND_API.to_boolean(p_init_msg_list) THEN

1846:
1847: AMS_Utility_PVT.debug_message(l_full_name||': start validate');
1848: END IF;
1849:
1850: IF FND_API.to_boolean(p_init_msg_list) THEN
1851: FND_MSG_PUB.initialize;
1852: END IF;
1853:
1854: IF NOT FND_API.compatible_api_call(

Line 1854: IF NOT FND_API.compatible_api_call(

1850: IF FND_API.to_boolean(p_init_msg_list) THEN
1851: FND_MSG_PUB.initialize;
1852: END IF;
1853:
1854: IF NOT FND_API.compatible_api_call(
1855: l_api_version,
1856: p_api_version,
1857: l_api_name,
1858: g_pkg_name

Line 1860: RAISE FND_API.g_exc_unexpected_error;

1856: p_api_version,
1857: l_api_name,
1858: g_pkg_name
1859: ) THEN
1860: RAISE FND_API.g_exc_unexpected_error;
1861: END IF;
1862:
1863: x_return_status := FND_API.g_ret_sts_success;
1864:

Line 1863: x_return_status := FND_API.g_ret_sts_success;

1859: ) THEN
1860: RAISE FND_API.g_exc_unexpected_error;
1861: END IF;
1862:
1863: x_return_status := FND_API.g_ret_sts_success;
1864:
1865: ---------------------- validate ------------------------
1866: IF (AMS_DEBUG_HIGH_ON) THEN
1867:

Line 1878: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1874: p_validation_mode => JTF_PLSQL_API.g_create,
1875: x_return_status => l_return_status
1876: );
1877:
1878: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1879: RAISE FND_API.g_exc_unexpected_error;
1880: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1881: RAISE FND_API.g_exc_error;
1882: END IF;

Line 1879: RAISE FND_API.g_exc_unexpected_error;

1875: x_return_status => l_return_status
1876: );
1877:
1878: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1879: RAISE FND_API.g_exc_unexpected_error;
1880: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1881: RAISE FND_API.g_exc_error;
1882: END IF;
1883: END IF;

Line 1880: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1876: );
1877:
1878: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1879: RAISE FND_API.g_exc_unexpected_error;
1880: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1881: RAISE FND_API.g_exc_error;
1882: END IF;
1883: END IF;
1884:

Line 1881: RAISE FND_API.g_exc_error;

1877:
1878: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1879: RAISE FND_API.g_exc_unexpected_error;
1880: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1881: RAISE FND_API.g_exc_error;
1882: END IF;
1883: END IF;
1884:
1885: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1914: RAISE FND_API.g_exc_error;

1910: END IF;
1911: FND_MSG_PUB.add;
1912: END IF;
1913: CLOSE c_check_dup;
1914: RAISE FND_API.g_exc_error;
1915: END IF;
1916: CLOSE c_check_dup;
1917: -------------------- finish --------------------------
1918: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1925: WHEN FND_API.g_exc_error THEN

1921: END IF;
1922:
1923: EXCEPTION
1924:
1925: WHEN FND_API.g_exc_error THEN
1926: x_return_status := FND_API.g_ret_sts_error;
1927: FND_MSG_PUB.count_and_get(
1928: p_encoded => FND_API.g_false,
1929: p_count => x_msg_count,

Line 1926: x_return_status := FND_API.g_ret_sts_error;

1922:
1923: EXCEPTION
1924:
1925: WHEN FND_API.g_exc_error THEN
1926: x_return_status := FND_API.g_ret_sts_error;
1927: FND_MSG_PUB.count_and_get(
1928: p_encoded => FND_API.g_false,
1929: p_count => x_msg_count,
1930: p_data => x_msg_data

Line 1928: p_encoded => FND_API.g_false,

1924:
1925: WHEN FND_API.g_exc_error THEN
1926: x_return_status := FND_API.g_ret_sts_error;
1927: FND_MSG_PUB.count_and_get(
1928: p_encoded => FND_API.g_false,
1929: p_count => x_msg_count,
1930: p_data => x_msg_data
1931: );
1932:

Line 1933: WHEN FND_API.g_exc_unexpected_error THEN

1929: p_count => x_msg_count,
1930: p_data => x_msg_data
1931: );
1932:
1933: WHEN FND_API.g_exc_unexpected_error THEN
1934: x_return_status := FND_API.g_ret_sts_unexp_error ;
1935: FND_MSG_PUB.count_and_get(
1936: p_encoded => FND_API.g_false,
1937: p_count => x_msg_count,

Line 1934: x_return_status := FND_API.g_ret_sts_unexp_error ;

1930: p_data => x_msg_data
1931: );
1932:
1933: WHEN FND_API.g_exc_unexpected_error THEN
1934: x_return_status := FND_API.g_ret_sts_unexp_error ;
1935: FND_MSG_PUB.count_and_get(
1936: p_encoded => FND_API.g_false,
1937: p_count => x_msg_count,
1938: p_data => x_msg_data

Line 1936: p_encoded => FND_API.g_false,

1932:
1933: WHEN FND_API.g_exc_unexpected_error THEN
1934: x_return_status := FND_API.g_ret_sts_unexp_error ;
1935: FND_MSG_PUB.count_and_get(
1936: p_encoded => FND_API.g_false,
1937: p_count => x_msg_count,
1938: p_data => x_msg_data
1939: );
1940:

Line 1942: x_return_status := FND_API.g_ret_sts_unexp_error;

1938: p_data => x_msg_data
1939: );
1940:
1941: WHEN OTHERS THEN
1942: x_return_status := FND_API.g_ret_sts_unexp_error;
1943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1944: THEN
1945: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1946: END IF;

Line 1949: p_encoded => FND_API.g_false,

1945: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1946: END IF;
1947:
1948: FND_MSG_PUB.count_and_get(
1949: p_encoded => FND_API.g_false,
1950: p_count => x_msg_count,
1951: p_data => x_msg_data
1952: );
1953:

Line 2412: x_return_status := FND_API.g_ret_sts_success;

2408: AMS_Utility_PVT.debug_message(' start req item');
2409:
2410: END IF;
2411:
2412: x_return_status := FND_API.g_ret_sts_success;
2413:
2414: ------------------------ user_status_id --------------------------
2415: IF p_Access_rec.act_access_to_object_id IS NULL THEN
2416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 2422: x_return_status := FND_API.g_ret_sts_error;

2418: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_OBJECT_ID');
2419: FND_MSG_PUB.add;
2420: END IF;
2421:
2422: x_return_status := FND_API.g_ret_sts_error;
2423: RETURN;
2424: END IF;
2425:
2426: IF p_Access_rec.arc_act_access_to_object IS NULL THEN

Line 2433: x_return_status := FND_API.g_ret_sts_error;

2429: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_OBJECT');
2430: FND_MSG_PUB.add;
2431: END IF;
2432:
2433: x_return_status := FND_API.g_ret_sts_error;
2434: RETURN;
2435: END IF;
2436:
2437: IF p_Access_rec.user_or_role_id IS NULL THEN

Line 2444: x_return_status := FND_API.g_ret_sts_error;

2440: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_UR_ID');
2441: FND_MSG_PUB.add;
2442: END IF;
2443:
2444: x_return_status := FND_API.g_ret_sts_error;
2445: RETURN;
2446: END IF;
2447:
2448: IF p_Access_rec.arc_user_or_role_type IS NULL THEN

Line 2455: x_return_status := FND_API.g_ret_sts_error;

2451: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_UR_TYPE');
2452: FND_MSG_PUB.add;
2453: END IF;
2454:
2455: x_return_status := FND_API.g_ret_sts_error;
2456: RETURN;
2457: END IF;
2458:
2459: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2482: x_return_status := FND_API.g_ret_sts_error;

2478: THEN
2479: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_USER');
2480: FND_MSG_PUB.add;
2481: END IF;
2482: x_return_status := FND_API.g_ret_sts_error;
2483: RETURN;
2484: end if;
2485:
2486: END IF;

Line 2511: x_return_status := FND_API.g_ret_sts_success;

2507: IS
2508: l_valid_flag VARCHAR2(1);
2509: BEGIN
2510:
2511: x_return_status := FND_API.g_ret_sts_success;
2512:
2513: -- For create_Access, when Access_id is passed in, we need to
2514: -- check if this Access_id is unique.
2515: --

Line 2522: ) = FND_API.g_false

2518: THEN
2519: IF AMS_Utility_PVT.check_uniqueness(
2520: 'ams_act_access',
2521: 'activity_access_id = ' || p_Access_rec.activity_access_id
2522: ) = FND_API.g_false
2523: THEN
2524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2525: THEN
2526: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUPLICATE_ID');

Line 2529: x_return_status := FND_API.g_ret_sts_error;

2525: THEN
2526: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUPLICATE_ID');
2527: FND_MSG_PUB.add;
2528: END IF;
2529: x_return_status := FND_API.g_ret_sts_error;
2530: RETURN;
2531: END IF;
2532: END IF;
2533:

Line 2551: x_return_status := FND_API.g_ret_sts_success;

2547: )
2548: IS
2549: BEGIN
2550:
2551: x_return_status := FND_API.g_ret_sts_success;
2552:
2553: ------------------user or role id ---------------------------------------
2554: IF p_Access_rec.user_or_role_id <> FND_API.g_miss_num THEN
2555:

Line 2554: IF p_Access_rec.user_or_role_id <> FND_API.g_miss_num THEN

2550:
2551: x_return_status := FND_API.g_ret_sts_success;
2552:
2553: ------------------user or role id ---------------------------------------
2554: IF p_Access_rec.user_or_role_id <> FND_API.g_miss_num THEN
2555:
2556: if UPPER(p_Access_rec.arc_user_or_role_type) = 'USER' THEN
2557:
2558: IF AMS_Utility_PVT.check_fk_exists(

Line 2562: ) = FND_API.g_false

2558: IF AMS_Utility_PVT.check_fk_exists(
2559: 'ams_jtf_rs_emp_v',
2560: 'RESOURCE_ID',
2561: p_Access_rec.user_or_role_id
2562: ) = FND_API.g_false
2563: THEN
2564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2565: THEN
2566: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_USER_ID');

Line 2570: x_return_status := FND_API.g_ret_sts_error;

2566: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_USER_ID');
2567: FND_MSG_PUB.add;
2568: END IF;
2569:
2570: x_return_status := FND_API.g_ret_sts_error;
2571: RETURN;
2572: END IF;
2573: END IF;
2574:

Line 2584: ) = FND_API.g_false

2580: --'JTF_RS_GROUPS_VL',
2581: 'JTF_RS_GROUPS_B',
2582: 'GROUP_ID',
2583: p_Access_rec.user_or_role_id
2584: ) = FND_API.g_false
2585: THEN
2586: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2587: THEN
2588: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_GROUP_ID');

Line 2592: x_return_status := FND_API.g_ret_sts_error;

2588: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_GROUP_ID');
2589: FND_MSG_PUB.add;
2590: END IF;
2591:
2592: x_return_status := FND_API.g_ret_sts_error;
2593: RETURN;
2594: END IF;
2595: END IF;
2596:

Line 2620: x_return_status := FND_API.g_ret_sts_success;

2616: )
2617: IS
2618: BEGIN
2619:
2620: x_return_status := FND_API.g_ret_sts_success;
2621:
2622: ----------------------- access to object ------------------------
2623: IF p_Access_rec.arc_act_access_to_object <> FND_API.g_miss_char THEN
2624:

Line 2623: IF p_Access_rec.arc_act_access_to_object <> FND_API.g_miss_char THEN

2619:
2620: x_return_status := FND_API.g_ret_sts_success;
2621:
2622: ----------------------- access to object ------------------------
2623: IF p_Access_rec.arc_act_access_to_object <> FND_API.g_miss_char THEN
2624:
2625: /*
2626: IF AMS_Utility_PVT.check_lookup_exists(
2627: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',

Line 2629: ) = FND_API.g_false

2625: /*
2626: IF AMS_Utility_PVT.check_lookup_exists(
2627: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2628: p_lookup_code => p_Access_rec.arc_act_access_to_object
2629: ) = FND_API.g_false
2630: THEN
2631: */
2632: /*
2633: IF AMS_Utility_PVT.check_lookup_exists(

Line 2637: ) = FND_API.g_false

2633: IF AMS_Utility_PVT.check_lookup_exists(
2634: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2635: p_lookup_code => p_Access_rec.arc_user_or_role_type,
2636: p_view_application_id => fnd_global.resp_appl_id
2637: ) = FND_API.g_false
2638: THEN
2639: */
2640: -- Correcting the p_lookup_code value getting passed for bug# 2419540
2641: -- Team concept is being used by mulitple applications. In some cases

Line 2651: ) = FND_API.g_false

2647: IF AMS_Utility_PVT.check_lookup_exists(
2648: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2649: p_lookup_code => p_Access_rec.arc_act_access_to_object,
2650: p_view_application_id => fnd_global.resp_appl_id
2651: ) = FND_API.g_false
2652: THEN
2653: IF AMS_Utility_PVT.check_lookup_exists(
2654: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2655: p_lookup_code => p_Access_rec.arc_act_access_to_object,

Line 2657: ) = FND_API.g_false

2653: IF AMS_Utility_PVT.check_lookup_exists(
2654: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2655: p_lookup_code => p_Access_rec.arc_act_access_to_object,
2656: p_view_application_id => 530
2657: ) = FND_API.g_false
2658: THEN
2659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2660: THEN
2661: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_SYS_ARC');

Line 2664: x_return_status := FND_API.g_ret_sts_error;

2660: THEN
2661: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_SYS_ARC');
2662: FND_MSG_PUB.add;
2663: END IF;
2664: x_return_status := FND_API.g_ret_sts_error;
2665: RETURN;
2666: END IF;
2667: END IF;
2668: END IF;

Line 2671: IF p_Access_rec.arc_user_or_role_type <> FND_API.g_miss_char THEN

2667: END IF;
2668: END IF;
2669:
2670: ------------------user or role type ---------------------------------------
2671: IF p_Access_rec.arc_user_or_role_type <> FND_API.g_miss_char THEN
2672: /*
2673: IF AMS_Utility_PVT.check_lookup_exists(
2674: p_lookup_type => 'AMS_ACCESS_TYPE',
2675: p_lookup_code => p_Access_rec.arc_user_or_role_type

Line 2676: ) = FND_API.g_false

2672: /*
2673: IF AMS_Utility_PVT.check_lookup_exists(
2674: p_lookup_type => 'AMS_ACCESS_TYPE',
2675: p_lookup_code => p_Access_rec.arc_user_or_role_type
2676: ) = FND_API.g_false
2677: THEN
2678: */
2679: -- User and Group lookups should exist only in AMS, and hence using 530
2680: IF AMS_Utility_PVT.check_lookup_exists(

Line 2684: ) = FND_API.g_false

2680: IF AMS_Utility_PVT.check_lookup_exists(
2681: p_lookup_type => 'AMS_ACCESS_TYPE',
2682: p_lookup_code => p_Access_rec.arc_user_or_role_type,
2683: p_view_application_id => 530
2684: ) = FND_API.g_false
2685: THEN
2686: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2687: THEN
2688: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_USER_TYPE');

Line 2692: x_return_status := FND_API.g_ret_sts_error;

2688: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_USER_TYPE');
2689: FND_MSG_PUB.add;
2690: END IF;
2691:
2692: x_return_status := FND_API.g_ret_sts_error;
2693: RETURN;
2694: END IF;
2695: END IF;
2696:

Line 2714: x_return_status := FND_API.g_ret_sts_success;

2710: )
2711: IS
2712: BEGIN
2713:
2714: x_return_status := FND_API.g_ret_sts_success;
2715:
2716: ----------------------- admin_flag ------------------------
2717: IF p_Access_rec.admin_flag <> FND_API.g_miss_char
2718: AND p_Access_rec.admin_flag IS NOT NULL

Line 2717: IF p_Access_rec.admin_flag <> FND_API.g_miss_char

2713:
2714: x_return_status := FND_API.g_ret_sts_success;
2715:
2716: ----------------------- admin_flag ------------------------
2717: IF p_Access_rec.admin_flag <> FND_API.g_miss_char
2718: AND p_Access_rec.admin_flag IS NOT NULL
2719: THEN
2720: IF AMS_Utility_PVT.is_Y_or_N(p_access_rec.admin_flag) = FND_API.g_false
2721: THEN

Line 2720: IF AMS_Utility_PVT.is_Y_or_N(p_access_rec.admin_flag) = FND_API.g_false

2716: ----------------------- admin_flag ------------------------
2717: IF p_Access_rec.admin_flag <> FND_API.g_miss_char
2718: AND p_Access_rec.admin_flag IS NOT NULL
2719: THEN
2720: IF AMS_Utility_PVT.is_Y_or_N(p_access_rec.admin_flag) = FND_API.g_false
2721: THEN
2722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2723: THEN
2724: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_ADMIN_FLAG');

Line 2728: x_return_status := FND_API.g_ret_sts_error;

2724: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_ADMIN_FLAG');
2725: FND_MSG_PUB.add;
2726: END IF;
2727:
2728: x_return_status := FND_API.g_ret_sts_error;
2729: RETURN;
2730: END IF;
2731: END IF;
2732:

Line 2765: x_return_status := FND_API.g_ret_sts_success;

2761:
2762: l_user_exist NUMBER;
2763: */
2764: BEGIN
2765: x_return_status := FND_API.g_ret_sts_success;
2766:
2767: IF (AMS_DEBUG_HIGH_ON) THEN
2768:
2769:

Line 2779: IF x_return_status <> FND_API.g_ret_sts_success THEN

2775: p_Access_rec => p_Access_rec,
2776: x_return_status => x_return_status
2777: );
2778:
2779: IF x_return_status <> FND_API.g_ret_sts_success THEN
2780: RETURN;
2781: END IF;
2782:
2783: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2815: IF x_return_status <> FND_API.g_ret_sts_success THEN

2811:
2812:
2813: END IF;
2814:
2815: IF x_return_status <> FND_API.g_ret_sts_success THEN
2816: RETURN;
2817: END IF;
2818: END;
2819: END IF;

Line 2833: IF x_return_status <> FND_API.g_ret_sts_success THEN

2829: AMS_Utility_PVT.debug_message('FK check items success ');
2830:
2831: END IF;
2832:
2833: IF x_return_status <> FND_API.g_ret_sts_success THEN
2834: RETURN;
2835: END IF;
2836:
2837: check_Access_lookup_items(

Line 2842: IF x_return_status <> FND_API.g_ret_sts_success THEN

2838: p_Access_rec => p_Access_rec,
2839: x_return_status => x_return_status
2840: );
2841:
2842: IF x_return_status <> FND_API.g_ret_sts_success THEN
2843: RETURN;
2844: END IF;
2845:
2846: check_Access_flag_items(

Line 2859: IF x_return_status <> FND_API.g_ret_sts_success THEN

2855: AMS_Utility_PVT.debug_message(' Flag check items success ');
2856:
2857: END IF;
2858:
2859: IF x_return_status <> FND_API.g_ret_sts_success THEN
2860: RETURN;
2861: END IF;
2862: -- addee by julou 29-nov-2001 ref. bug 2117645
2863: /*

Line 2874: x_return_status := FND_API.g_ret_sts_error;

2870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2871: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_USER_EXIST');
2872: FND_MSG_PUB.add;
2873: END IF;
2874: x_return_status := FND_API.g_ret_sts_error;
2875: END IF;
2876: END IF;
2877: */
2878: END check_Access_items;

Line 2898: x_return_status := FND_API.g_ret_sts_success;

2894: l_end_date DATE;
2895:
2896: BEGIN
2897:
2898: x_return_status := FND_API.g_ret_sts_success;
2899:
2900: IF p_Access_rec.active_from_date <> FND_API.g_miss_date
2901: OR p_Access_rec.active_to_date <> FND_API.g_miss_date
2902: THEN

Line 2900: IF p_Access_rec.active_from_date <> FND_API.g_miss_date

2896: BEGIN
2897:
2898: x_return_status := FND_API.g_ret_sts_success;
2899:
2900: IF p_Access_rec.active_from_date <> FND_API.g_miss_date
2901: OR p_Access_rec.active_to_date <> FND_API.g_miss_date
2902: THEN
2903: IF p_Access_rec.active_from_date = FND_API.g_miss_date THEN
2904: l_start_date := p_complete_rec.active_from_date;

Line 2901: OR p_Access_rec.active_to_date <> FND_API.g_miss_date

2897:
2898: x_return_status := FND_API.g_ret_sts_success;
2899:
2900: IF p_Access_rec.active_from_date <> FND_API.g_miss_date
2901: OR p_Access_rec.active_to_date <> FND_API.g_miss_date
2902: THEN
2903: IF p_Access_rec.active_from_date = FND_API.g_miss_date THEN
2904: l_start_date := p_complete_rec.active_from_date;
2905: ELSE

Line 2903: IF p_Access_rec.active_from_date = FND_API.g_miss_date THEN

2899:
2900: IF p_Access_rec.active_from_date <> FND_API.g_miss_date
2901: OR p_Access_rec.active_to_date <> FND_API.g_miss_date
2902: THEN
2903: IF p_Access_rec.active_from_date = FND_API.g_miss_date THEN
2904: l_start_date := p_complete_rec.active_from_date;
2905: ELSE
2906: l_start_date := p_Access_rec.active_from_date;
2907: END IF;

Line 2909: IF p_Access_rec.active_to_date = FND_API.g_miss_date THEN

2905: ELSE
2906: l_start_date := p_Access_rec.active_from_date;
2907: END IF;
2908:
2909: IF p_Access_rec.active_to_date = FND_API.g_miss_date THEN
2910: l_end_date := p_complete_rec.active_to_date;
2911: ELSE
2912: l_end_date := p_Access_rec.active_to_date;
2913: END IF;

Line 2921: x_return_status := FND_API.g_ret_sts_error;

2917: THEN
2918: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_INV_DATES');
2919: FND_MSG_PUB.add;
2920: END IF;
2921: x_return_status := FND_API.g_ret_sts_error;
2922: END IF;
2923: END IF;
2924:
2925: -- do other record level checkings

Line 2943: x_Access_rec.activity_access_id := FND_API.g_miss_num;

2939: )
2940: IS
2941: BEGIN
2942:
2943: x_Access_rec.activity_access_id := FND_API.g_miss_num;
2944: x_Access_rec.last_update_date := FND_API.g_miss_date;
2945: x_Access_rec.last_updated_by := FND_API.g_miss_num;
2946: x_Access_rec.creation_date := FND_API.g_miss_date;
2947: x_Access_rec.created_by := FND_API.g_miss_num;

Line 2944: x_Access_rec.last_update_date := FND_API.g_miss_date;

2940: IS
2941: BEGIN
2942:
2943: x_Access_rec.activity_access_id := FND_API.g_miss_num;
2944: x_Access_rec.last_update_date := FND_API.g_miss_date;
2945: x_Access_rec.last_updated_by := FND_API.g_miss_num;
2946: x_Access_rec.creation_date := FND_API.g_miss_date;
2947: x_Access_rec.created_by := FND_API.g_miss_num;
2948: x_Access_rec.last_update_login := FND_API.g_miss_num;

Line 2945: x_Access_rec.last_updated_by := FND_API.g_miss_num;

2941: BEGIN
2942:
2943: x_Access_rec.activity_access_id := FND_API.g_miss_num;
2944: x_Access_rec.last_update_date := FND_API.g_miss_date;
2945: x_Access_rec.last_updated_by := FND_API.g_miss_num;
2946: x_Access_rec.creation_date := FND_API.g_miss_date;
2947: x_Access_rec.created_by := FND_API.g_miss_num;
2948: x_Access_rec.last_update_login := FND_API.g_miss_num;
2949: x_Access_rec.object_version_number := FND_API.g_miss_num;

Line 2946: x_Access_rec.creation_date := FND_API.g_miss_date;

2942:
2943: x_Access_rec.activity_access_id := FND_API.g_miss_num;
2944: x_Access_rec.last_update_date := FND_API.g_miss_date;
2945: x_Access_rec.last_updated_by := FND_API.g_miss_num;
2946: x_Access_rec.creation_date := FND_API.g_miss_date;
2947: x_Access_rec.created_by := FND_API.g_miss_num;
2948: x_Access_rec.last_update_login := FND_API.g_miss_num;
2949: x_Access_rec.object_version_number := FND_API.g_miss_num;
2950: x_Access_rec.act_access_to_object_id := FND_API.g_miss_num;

Line 2947: x_Access_rec.created_by := FND_API.g_miss_num;

2943: x_Access_rec.activity_access_id := FND_API.g_miss_num;
2944: x_Access_rec.last_update_date := FND_API.g_miss_date;
2945: x_Access_rec.last_updated_by := FND_API.g_miss_num;
2946: x_Access_rec.creation_date := FND_API.g_miss_date;
2947: x_Access_rec.created_by := FND_API.g_miss_num;
2948: x_Access_rec.last_update_login := FND_API.g_miss_num;
2949: x_Access_rec.object_version_number := FND_API.g_miss_num;
2950: x_Access_rec.act_access_to_object_id := FND_API.g_miss_num;
2951: x_Access_rec.arc_act_access_to_object := FND_API.g_miss_char;

Line 2948: x_Access_rec.last_update_login := FND_API.g_miss_num;

2944: x_Access_rec.last_update_date := FND_API.g_miss_date;
2945: x_Access_rec.last_updated_by := FND_API.g_miss_num;
2946: x_Access_rec.creation_date := FND_API.g_miss_date;
2947: x_Access_rec.created_by := FND_API.g_miss_num;
2948: x_Access_rec.last_update_login := FND_API.g_miss_num;
2949: x_Access_rec.object_version_number := FND_API.g_miss_num;
2950: x_Access_rec.act_access_to_object_id := FND_API.g_miss_num;
2951: x_Access_rec.arc_act_access_to_object := FND_API.g_miss_char;
2952: x_Access_rec.user_or_role_id := FND_API.g_miss_num;

Line 2949: x_Access_rec.object_version_number := FND_API.g_miss_num;

2945: x_Access_rec.last_updated_by := FND_API.g_miss_num;
2946: x_Access_rec.creation_date := FND_API.g_miss_date;
2947: x_Access_rec.created_by := FND_API.g_miss_num;
2948: x_Access_rec.last_update_login := FND_API.g_miss_num;
2949: x_Access_rec.object_version_number := FND_API.g_miss_num;
2950: x_Access_rec.act_access_to_object_id := FND_API.g_miss_num;
2951: x_Access_rec.arc_act_access_to_object := FND_API.g_miss_char;
2952: x_Access_rec.user_or_role_id := FND_API.g_miss_num;
2953: x_Access_rec.arc_user_or_role_type := FND_API.g_miss_char;

Line 2950: x_Access_rec.act_access_to_object_id := FND_API.g_miss_num;

2946: x_Access_rec.creation_date := FND_API.g_miss_date;
2947: x_Access_rec.created_by := FND_API.g_miss_num;
2948: x_Access_rec.last_update_login := FND_API.g_miss_num;
2949: x_Access_rec.object_version_number := FND_API.g_miss_num;
2950: x_Access_rec.act_access_to_object_id := FND_API.g_miss_num;
2951: x_Access_rec.arc_act_access_to_object := FND_API.g_miss_char;
2952: x_Access_rec.user_or_role_id := FND_API.g_miss_num;
2953: x_Access_rec.arc_user_or_role_type := FND_API.g_miss_char;
2954:

Line 2951: x_Access_rec.arc_act_access_to_object := FND_API.g_miss_char;

2947: x_Access_rec.created_by := FND_API.g_miss_num;
2948: x_Access_rec.last_update_login := FND_API.g_miss_num;
2949: x_Access_rec.object_version_number := FND_API.g_miss_num;
2950: x_Access_rec.act_access_to_object_id := FND_API.g_miss_num;
2951: x_Access_rec.arc_act_access_to_object := FND_API.g_miss_char;
2952: x_Access_rec.user_or_role_id := FND_API.g_miss_num;
2953: x_Access_rec.arc_user_or_role_type := FND_API.g_miss_char;
2954:
2955: x_Access_rec.active_from_date := FND_API.g_miss_date;

Line 2952: x_Access_rec.user_or_role_id := FND_API.g_miss_num;

2948: x_Access_rec.last_update_login := FND_API.g_miss_num;
2949: x_Access_rec.object_version_number := FND_API.g_miss_num;
2950: x_Access_rec.act_access_to_object_id := FND_API.g_miss_num;
2951: x_Access_rec.arc_act_access_to_object := FND_API.g_miss_char;
2952: x_Access_rec.user_or_role_id := FND_API.g_miss_num;
2953: x_Access_rec.arc_user_or_role_type := FND_API.g_miss_char;
2954:
2955: x_Access_rec.active_from_date := FND_API.g_miss_date;
2956: x_Access_rec.active_to_date := FND_API.g_miss_date;

Line 2953: x_Access_rec.arc_user_or_role_type := FND_API.g_miss_char;

2949: x_Access_rec.object_version_number := FND_API.g_miss_num;
2950: x_Access_rec.act_access_to_object_id := FND_API.g_miss_num;
2951: x_Access_rec.arc_act_access_to_object := FND_API.g_miss_char;
2952: x_Access_rec.user_or_role_id := FND_API.g_miss_num;
2953: x_Access_rec.arc_user_or_role_type := FND_API.g_miss_char;
2954:
2955: x_Access_rec.active_from_date := FND_API.g_miss_date;
2956: x_Access_rec.active_to_date := FND_API.g_miss_date;
2957:

Line 2955: x_Access_rec.active_from_date := FND_API.g_miss_date;

2951: x_Access_rec.arc_act_access_to_object := FND_API.g_miss_char;
2952: x_Access_rec.user_or_role_id := FND_API.g_miss_num;
2953: x_Access_rec.arc_user_or_role_type := FND_API.g_miss_char;
2954:
2955: x_Access_rec.active_from_date := FND_API.g_miss_date;
2956: x_Access_rec.active_to_date := FND_API.g_miss_date;
2957:
2958: x_Access_rec.admin_flag := FND_API.g_miss_char;
2959: x_Access_rec.owner_flag := FND_API.g_miss_char;

Line 2956: x_Access_rec.active_to_date := FND_API.g_miss_date;

2952: x_Access_rec.user_or_role_id := FND_API.g_miss_num;
2953: x_Access_rec.arc_user_or_role_type := FND_API.g_miss_char;
2954:
2955: x_Access_rec.active_from_date := FND_API.g_miss_date;
2956: x_Access_rec.active_to_date := FND_API.g_miss_date;
2957:
2958: x_Access_rec.admin_flag := FND_API.g_miss_char;
2959: x_Access_rec.owner_flag := FND_API.g_miss_char;
2960: x_Access_rec.delete_flag := FND_API.g_miss_char;

Line 2958: x_Access_rec.admin_flag := FND_API.g_miss_char;

2954:
2955: x_Access_rec.active_from_date := FND_API.g_miss_date;
2956: x_Access_rec.active_to_date := FND_API.g_miss_date;
2957:
2958: x_Access_rec.admin_flag := FND_API.g_miss_char;
2959: x_Access_rec.owner_flag := FND_API.g_miss_char;
2960: x_Access_rec.delete_flag := FND_API.g_miss_char;
2961:
2962:

Line 2959: x_Access_rec.owner_flag := FND_API.g_miss_char;

2955: x_Access_rec.active_from_date := FND_API.g_miss_date;
2956: x_Access_rec.active_to_date := FND_API.g_miss_date;
2957:
2958: x_Access_rec.admin_flag := FND_API.g_miss_char;
2959: x_Access_rec.owner_flag := FND_API.g_miss_char;
2960: x_Access_rec.delete_flag := FND_API.g_miss_char;
2961:
2962:
2963: END init_Access_rec;

Line 2960: x_Access_rec.delete_flag := FND_API.g_miss_char;

2956: x_Access_rec.active_to_date := FND_API.g_miss_date;
2957:
2958: x_Access_rec.admin_flag := FND_API.g_miss_char;
2959: x_Access_rec.owner_flag := FND_API.g_miss_char;
2960: x_Access_rec.delete_flag := FND_API.g_miss_char;
2961:
2962:
2963: END init_Access_rec;
2964:

Line 2998: RAISE FND_API.g_exc_error;

2994: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2995: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2996: FND_MSG_PUB.add;
2997: END IF;
2998: RAISE FND_API.g_exc_error;
2999: END IF;
3000: CLOSE c_access;
3001:
3002:

Line 3003: IF p_Access_rec.act_access_to_object_id = FND_API.g_miss_num THEN

2999: END IF;
3000: CLOSE c_access;
3001:
3002:
3003: IF p_Access_rec.act_access_to_object_id = FND_API.g_miss_num THEN
3004: x_complete_rec.act_access_to_object_id := l_Access_rec.act_access_to_object_id;
3005: END IF;
3006:
3007: IF p_Access_rec.arc_act_access_to_object = FND_API.g_miss_char THEN

Line 3007: IF p_Access_rec.arc_act_access_to_object = FND_API.g_miss_char THEN

3003: IF p_Access_rec.act_access_to_object_id = FND_API.g_miss_num THEN
3004: x_complete_rec.act_access_to_object_id := l_Access_rec.act_access_to_object_id;
3005: END IF;
3006:
3007: IF p_Access_rec.arc_act_access_to_object = FND_API.g_miss_char THEN
3008: x_complete_rec.arc_act_access_to_object := l_Access_rec.arc_act_access_to_object;
3009: END IF;
3010:
3011: IF p_Access_rec.user_or_role_id = FND_API.g_miss_num THEN

Line 3011: IF p_Access_rec.user_or_role_id = FND_API.g_miss_num THEN

3007: IF p_Access_rec.arc_act_access_to_object = FND_API.g_miss_char THEN
3008: x_complete_rec.arc_act_access_to_object := l_Access_rec.arc_act_access_to_object;
3009: END IF;
3010:
3011: IF p_Access_rec.user_or_role_id = FND_API.g_miss_num THEN
3012: x_complete_rec.user_or_role_id := l_Access_rec.user_or_role_id;
3013: END IF;
3014:
3015: IF p_Access_rec.arc_user_or_role_type = FND_API.g_miss_char THEN

Line 3015: IF p_Access_rec.arc_user_or_role_type = FND_API.g_miss_char THEN

3011: IF p_Access_rec.user_or_role_id = FND_API.g_miss_num THEN
3012: x_complete_rec.user_or_role_id := l_Access_rec.user_or_role_id;
3013: END IF;
3014:
3015: IF p_Access_rec.arc_user_or_role_type = FND_API.g_miss_char THEN
3016: x_complete_rec.arc_user_or_role_type := l_Access_rec.arc_user_or_role_type;
3017: END IF;
3018:
3019: IF p_Access_rec.active_from_date = FND_API.g_miss_date THEN

Line 3019: IF p_Access_rec.active_from_date = FND_API.g_miss_date THEN

3015: IF p_Access_rec.arc_user_or_role_type = FND_API.g_miss_char THEN
3016: x_complete_rec.arc_user_or_role_type := l_Access_rec.arc_user_or_role_type;
3017: END IF;
3018:
3019: IF p_Access_rec.active_from_date = FND_API.g_miss_date THEN
3020: x_complete_rec.active_from_date := l_Access_rec.active_from_date;
3021: END IF;
3022:
3023: IF p_Access_rec.active_to_date = FND_API.g_miss_date THEN

Line 3023: IF p_Access_rec.active_to_date = FND_API.g_miss_date THEN

3019: IF p_Access_rec.active_from_date = FND_API.g_miss_date THEN
3020: x_complete_rec.active_from_date := l_Access_rec.active_from_date;
3021: END IF;
3022:
3023: IF p_Access_rec.active_to_date = FND_API.g_miss_date THEN
3024: x_complete_rec.active_to_date := l_Access_rec.active_to_date;
3025: END IF;
3026:
3027: IF p_Access_rec.admin_flag = FND_API.g_miss_char THEN

Line 3027: IF p_Access_rec.admin_flag = FND_API.g_miss_char THEN

3023: IF p_Access_rec.active_to_date = FND_API.g_miss_date THEN
3024: x_complete_rec.active_to_date := l_Access_rec.active_to_date;
3025: END IF;
3026:
3027: IF p_Access_rec.admin_flag = FND_API.g_miss_char THEN
3028: x_complete_rec.admin_flag := l_Access_rec.admin_flag ;
3029: END IF;
3030:
3031: IF p_Access_rec.owner_flag = FND_API.g_miss_char THEN

Line 3031: IF p_Access_rec.owner_flag = FND_API.g_miss_char THEN

3027: IF p_Access_rec.admin_flag = FND_API.g_miss_char THEN
3028: x_complete_rec.admin_flag := l_Access_rec.admin_flag ;
3029: END IF;
3030:
3031: IF p_Access_rec.owner_flag = FND_API.g_miss_char THEN
3032: x_complete_rec.owner_flag := l_Access_rec.owner_flag ;
3033: END IF;
3034:
3035: IF p_Access_rec.delete_flag = FND_API.g_miss_char THEN

Line 3035: IF p_Access_rec.delete_flag = FND_API.g_miss_char THEN

3031: IF p_Access_rec.owner_flag = FND_API.g_miss_char THEN
3032: x_complete_rec.owner_flag := l_Access_rec.owner_flag ;
3033: END IF;
3034:
3035: IF p_Access_rec.delete_flag = FND_API.g_miss_char THEN
3036: x_complete_rec.delete_flag := l_Access_rec.delete_flag ;
3037: END IF;
3038:
3039: END complete_Access_rec;