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.FPA_SECURITY_PVT dependencies on FPA_UTILITIES_PVT

Line 5: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;

1: package body FPA_SECURITY_PVT as
2: /* $Header: FPAVSECB.pls 120.4 2005/08/18 11:50:33 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_SECURITY_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;
6: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
7: L_API_NAME CONSTANT VARCHAR2(35) := 'SECURITY_PVT';
8:
9: /* ***************************************************************

Line 284: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

280: l_role VARCHAR2(100);
281:
282: BEGIN
283:
284: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
285: l_exists := 'F';
286:
287: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
288: -- call START_ACTIVITY to create savepoint, check compatibility

Line 287: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

283:
284: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
285: l_exists := 'F';
286:
287: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
288: -- call START_ACTIVITY to create savepoint, check compatibility
289: -- and initialize message list
290: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
291: p_api_name => l_api_name,

Line 290: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

286:
287: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
288: -- call START_ACTIVITY to create savepoint, check compatibility
289: -- and initialize message list
290: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
291: p_api_name => l_api_name,
292: p_pkg_name => G_PKG_NAME,
293: p_init_msg_list => p_init_msg_list,
294: l_api_version => l_api_version,

Line 301: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

297: p_msg_log => 'Entering fpa_security_pvt.grant_role',
298: x_return_status => x_return_status);
299:
300: -- check if activity started successfully
301: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
302: l_msg_log := 'start_activity';
303: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
304: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
305: l_msg_log := 'start_activity';

Line 303: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

299:
300: -- check if activity started successfully
301: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
302: l_msg_log := 'start_activity';
303: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
304: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
305: l_msg_log := 'start_activity';
306: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
307: end if;

Line 304: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

300: -- check if activity started successfully
301: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
302: l_msg_log := 'start_activity';
303: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
304: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
305: l_msg_log := 'start_activity';
306: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
307: end if;
308:

Line 306: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

302: l_msg_log := 'start_activity';
303: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
304: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
305: l_msg_log := 'start_activity';
306: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
307: end if;
308:
309: l_grantee_key:= PA_SECURITY_PVT.Get_Grantee_Key(
310: p_source_type,

Line 325: FPA_UTILITIES_PVT.END_ACTIVITY(

321: x_ret_code => l_exists);
322:
323: if(l_exists = FND_API.G_TRUE) then
324:
325: FPA_UTILITIES_PVT.END_ACTIVITY(
326: p_api_name => l_api_name,
327: p_pkg_name => G_PKG_NAME,
328: p_msg_log => null,
329: x_msg_count => x_msg_count,

Line 332: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

328: p_msg_log => null,
329: x_msg_count => x_msg_count,
330: x_msg_data => x_msg_data);
331:
332: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
333:
334: return;
335:
336: end if;

Line 341: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

337:
338: l_secured_role_menu := PA_SECURITY_PVT.Get_Menu_Name(p_project_role_id);
339:
340: if l_secured_role_menu is null then
341: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
342: FPA_UTILITIES_PVT.SET_MESSAGE(
343: p_app_name => g_app_name
344: , p_msg_name => 'PA_INVALID_PROJECT_ROLE');
345: -- l_msg_log := p_portfolio_party_id;

Line 342: FPA_UTILITIES_PVT.SET_MESSAGE(

338: l_secured_role_menu := PA_SECURITY_PVT.Get_Menu_Name(p_project_role_id);
339:
340: if l_secured_role_menu is null then
341: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
342: FPA_UTILITIES_PVT.SET_MESSAGE(
343: p_app_name => g_app_name
344: , p_msg_name => 'PA_INVALID_PROJECT_ROLE');
345: -- l_msg_log := p_portfolio_party_id;
346: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

Line 346: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

342: FPA_UTILITIES_PVT.SET_MESSAGE(
343: p_app_name => g_app_name
344: , p_msg_name => 'PA_INVALID_PROJECT_ROLE');
345: -- l_msg_log := p_portfolio_party_id;
346: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
347: end if;
348: l_instance_set_id := PA_SECURITY_PVT.Get_Instance_Set_Id(p_object_set);
349:
350:

Line 351: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

347: end if;
348: l_instance_set_id := PA_SECURITY_PVT.Get_Instance_Set_Id(p_object_set);
349:
350:
351: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
352:
353: FND_GRANTS_PKG.Grant_Function(
354: p_api_version => l_api_version,
355: p_menu_name => l_secured_role_menu,

Line 372: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

368:
369:
370: if l_success <> FND_API.G_TRUE then
371: if l_error_code > 0 then
372: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
373: else
374: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR;
375: end if;
376: end if;

Line 374: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR;

370: if l_success <> FND_API.G_TRUE then
371: if l_error_code > 0 then
372: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
373: else
374: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR;
375: end if;
376: end if;
377:
378: -- check if activity started successfully

Line 379: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

375: end if;
376: end if;
377:
378: -- check if activity started successfully
379: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
380: l_msg_log := l_secured_role_menu||','||to_char(l_grant_id);
381: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
382: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
383: l_msg_log := l_secured_role_menu||','||l_grant_id;

Line 381: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

377:
378: -- check if activity started successfully
379: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
380: l_msg_log := l_secured_role_menu||','||to_char(l_grant_id);
381: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
382: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
383: l_msg_log := l_secured_role_menu||','||l_grant_id;
384: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
385: end if;

Line 382: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

378: -- check if activity started successfully
379: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
380: l_msg_log := l_secured_role_menu||','||to_char(l_grant_id);
381: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
382: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
383: l_msg_log := l_secured_role_menu||','||l_grant_id;
384: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
385: end if;
386:

Line 384: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

380: l_msg_log := l_secured_role_menu||','||to_char(l_grant_id);
381: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
382: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
383: l_msg_log := l_secured_role_menu||','||l_grant_id;
384: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
385: end if;
386:
387: FPA_UTILITIES_PVT.END_ACTIVITY(
388: p_api_name => l_api_name,

Line 387: FPA_UTILITIES_PVT.END_ACTIVITY(

383: l_msg_log := l_secured_role_menu||','||l_grant_id;
384: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
385: end if;
386:
387: FPA_UTILITIES_PVT.END_ACTIVITY(
388: p_api_name => l_api_name,
389: p_pkg_name => G_PKG_NAME,
390: p_msg_log => null,
391: x_msg_count => x_msg_count,

Line 395: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

391: x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data);
393:
394: EXCEPTION
395: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
396: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
397: p_api_name => l_api_name,
398: p_pkg_name => G_PKG_NAME,
399: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 396: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

392: x_msg_data => x_msg_data);
393:
394: EXCEPTION
395: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
396: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
397: p_api_name => l_api_name,
398: p_pkg_name => G_PKG_NAME,
399: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
400: p_msg_log => l_msg_log,

Line 399: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

395: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
396: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
397: p_api_name => l_api_name,
398: p_pkg_name => G_PKG_NAME,
399: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
400: p_msg_log => l_msg_log,
401: x_msg_count => x_msg_count,
402: x_msg_data => x_msg_data,
403: p_api_type => G_API_TYPE);

Line 405: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

401: x_msg_count => x_msg_count,
402: x_msg_data => x_msg_data,
403: p_api_type => G_API_TYPE);
404:
405: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
406: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
407: p_api_name => l_api_name,
408: p_pkg_name => G_PKG_NAME,
409: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 406: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

402: x_msg_data => x_msg_data,
403: p_api_type => G_API_TYPE);
404:
405: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
406: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
407: p_api_name => l_api_name,
408: p_pkg_name => G_PKG_NAME,
409: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
410: p_msg_log => l_msg_log,

Line 409: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

405: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
406: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
407: p_api_name => l_api_name,
408: p_pkg_name => G_PKG_NAME,
409: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
410: p_msg_log => l_msg_log,
411: x_msg_count => x_msg_count,
412: x_msg_data => x_msg_data,
413: p_api_type => G_API_TYPE);

Line 416: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

412: x_msg_data => x_msg_data,
413: p_api_type => G_API_TYPE);
414:
415: when OTHERS then
416: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
417: p_api_name => l_api_name,
418: p_pkg_name => G_PKG_NAME,
419: p_exc_name => 'OTHERS',
420: p_msg_log => l_msg_log||SQLERRM,

Line 492: -- l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

488: l_instance_set_id NUMBER;
489: l_exists VARCHAR2(1);
490:
491: BEGIN
492: -- l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
493:
494: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
495: -- call START_ACTIVITY to create savepoint, check compatibility
496: -- and initialize message list

Line 494: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

490:
491: BEGIN
492: -- l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
493:
494: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
495: -- call START_ACTIVITY to create savepoint, check compatibility
496: -- and initialize message list
497: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
498: p_api_name => l_api_name,

Line 497: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

493:
494: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
495: -- call START_ACTIVITY to create savepoint, check compatibility
496: -- and initialize message list
497: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
498: p_api_name => l_api_name,
499: p_pkg_name => G_PKG_NAME,
500: p_init_msg_list => p_init_msg_list,
501: l_api_version => l_api_version,

Line 508: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

504: p_msg_log => 'Entering fpa_security_pvt.grant_role',
505: x_return_status => x_return_status);
506:
507: -- check if activity started successfully
508: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
509: l_msg_log := 'start_activity';
510: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
511: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
512: l_msg_log := 'start_activity';

Line 510: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

506:
507: -- check if activity started successfully
508: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
509: l_msg_log := 'start_activity';
510: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
511: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
512: l_msg_log := 'start_activity';
513: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
514: end if;

Line 511: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

507: -- check if activity started successfully
508: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
509: l_msg_log := 'start_activity';
510: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
511: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
512: l_msg_log := 'start_activity';
513: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
514: end if;
515:

Line 513: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

509: l_msg_log := 'start_activity';
510: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
511: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
512: l_msg_log := 'start_activity';
513: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
514: end if;
515:
516: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
517:

Line 516: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

512: l_msg_log := 'start_activity';
513: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
514: end if;
515:
516: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
517:
518: open parties_csr(p_project_role_id,
519: p_party_id);
520:

Line 526: FPA_UTILITIES_PVT.END_ACTIVITY(

522: close parties_csr;
523:
524: if(l_exists = FND_API.G_TRUE) then
525:
526: FPA_UTILITIES_PVT.END_ACTIVITY(
527: p_api_name => l_api_name,
528: p_pkg_name => G_PKG_NAME,
529: p_msg_log => null,
530: x_msg_count => x_msg_count,

Line 554: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

550: x_grant_id => l_grant_id,
551: x_ret_code => l_exists);
552:
553: if(l_exists = FND_API.G_FALSE) then
554: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
555: l_user := Get_party_Name(p_party_id);
556: FPA_UTILITIES_PVT.SET_MESSAGE(
557: p_app_name => g_app_name
558: , p_msg_name => 'FPA_SEC_NO_GRANT'

Line 556: FPA_UTILITIES_PVT.SET_MESSAGE(

552:
553: if(l_exists = FND_API.G_FALSE) then
554: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
555: l_user := Get_party_Name(p_party_id);
556: FPA_UTILITIES_PVT.SET_MESSAGE(
557: p_app_name => g_app_name
558: , p_msg_name => 'FPA_SEC_NO_GRANT'
559: , p_token1 => 'USER'
560: ,p_token1_value => l_user);

Line 563: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

559: , p_token1 => 'USER'
560: ,p_token1_value => l_user);
561:
562: l_msg_log := 'FPA_SEC_NO_GRANT '||l_grantee_key||','||p_project_role_id;
563: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
564: end if;
565:
566:
567: FND_GRANTS_PKG.Revoke_Grant(

Line 576: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

572:
573: if l_success <> FND_API.G_TRUE then
574: -- x_revoked := FND_API.G_FALSE;
575: if l_error_code > 0 then
576: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
577: else
578: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR;
579: end if;
580: end if;

Line 578: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR;

574: -- x_revoked := FND_API.G_FALSE;
575: if l_error_code > 0 then
576: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
577: else
578: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR;
579: end if;
580: end if;
581:
582: -- check if activity started successfully

Line 583: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

579: end if;
580: end if;
581:
582: -- check if activity started successfully
583: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
584: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;
585: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
586: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
587: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;

Line 585: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

581:
582: -- check if activity started successfully
583: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
584: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;
585: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
586: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
587: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;
588: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
589: end if;

Line 586: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

582: -- check if activity started successfully
583: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
584: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;
585: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
586: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
587: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;
588: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
589: end if;
590:

Line 588: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

584: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;
585: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
586: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
587: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;
588: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
589: end if;
590:
591: --x_revoked := FND_API.G_TRUE;
592:

Line 593: FPA_UTILITIES_PVT.END_ACTIVITY(

589: end if;
590:
591: --x_revoked := FND_API.G_TRUE;
592:
593: FPA_UTILITIES_PVT.END_ACTIVITY(
594: p_api_name => l_api_name,
595: p_pkg_name => G_PKG_NAME,
596: p_msg_log => null,
597: x_msg_count => x_msg_count,

Line 602: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

598: x_msg_data => x_msg_data);
599:
600:
601: EXCEPTION
602: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
603: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
604: p_api_name => l_api_name,
605: p_pkg_name => G_PKG_NAME,
606: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 603: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

599:
600:
601: EXCEPTION
602: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
603: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
604: p_api_name => l_api_name,
605: p_pkg_name => G_PKG_NAME,
606: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
607: p_msg_log => l_msg_log,

Line 606: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

602: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
603: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
604: p_api_name => l_api_name,
605: p_pkg_name => G_PKG_NAME,
606: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
607: p_msg_log => l_msg_log,
608: x_msg_count => x_msg_count,
609: x_msg_data => x_msg_data,
610: p_api_type => G_API_TYPE);

Line 612: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

608: x_msg_count => x_msg_count,
609: x_msg_data => x_msg_data,
610: p_api_type => G_API_TYPE);
611:
612: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
613: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
614: p_api_name => l_api_name,
615: p_pkg_name => G_PKG_NAME,
616: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 613: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

609: x_msg_data => x_msg_data,
610: p_api_type => G_API_TYPE);
611:
612: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
613: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
614: p_api_name => l_api_name,
615: p_pkg_name => G_PKG_NAME,
616: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
617: p_msg_log => l_msg_log,

Line 616: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

612: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
613: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
614: p_api_name => l_api_name,
615: p_pkg_name => G_PKG_NAME,
616: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
617: p_msg_log => l_msg_log,
618: x_msg_count => x_msg_count,
619: x_msg_data => x_msg_data,
620: p_api_type => G_API_TYPE);

Line 623: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

619: x_msg_data => x_msg_data,
620: p_api_type => G_API_TYPE);
621:
622: when OTHERS then
623: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
624: p_api_name => l_api_name,
625: p_pkg_name => G_PKG_NAME,
626: p_exc_name => 'OTHERS',
627: p_msg_log => l_msg_log||SQLERRM,

Line 691: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

687: ----------------------------------------------------------------------------
688:
689: BEGIN
690:
691: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
692: l_end_date_active := p_end_date_active;
693:
694: if p_start_date_active is null then
695: l_start_date_active := sysdate;

Line 701: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

697: l_start_date_active := p_start_date_active;
698: end if;
699:
700:
701: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
702: -- call START_ACTIVITY to create savepoint, check compatibility
703: -- and initialize message list
704:
705: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

Line 705: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

701: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
702: -- call START_ACTIVITY to create savepoint, check compatibility
703: -- and initialize message list
704:
705: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
706: p_api_name => l_api_name,
707: p_pkg_name => G_PKG_NAME,
708: p_init_msg_list => p_init_msg_list,
709: l_api_version => l_api_version,

Line 716: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

712: p_msg_log => 'Entering fpa_security_pvt.create_portfolio_user',
713: x_return_status => x_return_status);
714:
715: -- check if activity started successfully
716: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
717: l_msg_log := 'start_activity';
718: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
719: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
720: l_msg_log := 'start_activity';

Line 718: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

714:
715: -- check if activity started successfully
716: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
717: l_msg_log := 'start_activity';
718: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
719: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
720: l_msg_log := 'start_activity';
721: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
722: end if;

Line 719: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

715: -- check if activity started successfully
716: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
717: l_msg_log := 'start_activity';
718: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
719: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
720: l_msg_log := 'start_activity';
721: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
722: end if;
723: /*

Line 721: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

717: l_msg_log := 'start_activity';
718: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
719: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
720: l_msg_log := 'start_activity';
721: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
722: end if;
723: /*
724: if (check_user(p_party_id, p_object_id)) then
725: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

Line 725: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

721: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
722: end if;
723: /*
724: if (check_user(p_party_id, p_object_id)) then
725: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
726: l_user := Get_party_Name(p_party_id);
727: FPA_UTILITIES_PVT.SET_MESSAGE(
728: p_app_name => g_app_name
729: , p_msg_name => 'FPA_SEC_USER_EXISTS'

Line 727: FPA_UTILITIES_PVT.SET_MESSAGE(

723: /*
724: if (check_user(p_party_id, p_object_id)) then
725: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
726: l_user := Get_party_Name(p_party_id);
727: FPA_UTILITIES_PVT.SET_MESSAGE(
728: p_app_name => g_app_name
729: , p_msg_name => 'FPA_SEC_USER_EXISTS'
730: , p_token1 => 'USER'
731: ,p_token1_value => l_user);

Line 733: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

729: , p_msg_name => 'FPA_SEC_USER_EXISTS'
730: , p_token1 => 'USER'
731: ,p_token1_value => l_user);
732: l_msg_log := 'FPA_SEC_USER_EXISTS'||p_party_id||','||p_object_id;
733: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
734: end if;
735: */
736: if (Get_Role(p_project_role_id) = G_OWNER AND Get_Owner(p_object_id) is not null) then
737: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

Line 737: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

733: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
734: end if;
735: */
736: if (Get_Role(p_project_role_id) = G_OWNER AND Get_Owner(p_object_id) is not null) then
737: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
738: l_role := PA_SECURITY_PVT.get_proj_role_name(p_project_role_id);
739: FPA_UTILITIES_PVT.SET_MESSAGE(
740: p_app_name => g_app_name
741: , p_msg_name => 'FPA_SEC_OWNER_ROLE_EXISTS'

Line 739: FPA_UTILITIES_PVT.SET_MESSAGE(

735: */
736: if (Get_Role(p_project_role_id) = G_OWNER AND Get_Owner(p_object_id) is not null) then
737: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
738: l_role := PA_SECURITY_PVT.get_proj_role_name(p_project_role_id);
739: FPA_UTILITIES_PVT.SET_MESSAGE(
740: p_app_name => g_app_name
741: , p_msg_name => 'FPA_SEC_OWNER_ROLE_EXISTS'
742: , p_token1 => 'ROLE'
743: ,p_token1_value => l_role);

Line 745: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

741: , p_msg_name => 'FPA_SEC_OWNER_ROLE_EXISTS'
742: , p_token1 => 'ROLE'
743: ,p_token1_value => l_role);
744: l_msg_log := 'FPA_SEC_OWNER_ROLE_EXISTS'||p_project_role_id||','||p_object_id;
745: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
746: end if;
747:
748: PA_PROJECT_PARTIES_PVT.Create_Project_Party(
749: p_commit => FND_API.G_FALSE,

Line 774: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

770: x_Return_Status => x_return_status,
771: x_Msg_Count => x_msg_count,
772: x_Msg_Data => x_msg_data);
773:
774: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
775: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id;
776: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
777: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
778: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id;

Line 776: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

772: x_Msg_Data => x_msg_data);
773:
774: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
775: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id;
776: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
777: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
778: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id;
779: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
780: end if;

Line 777: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

773:
774: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
775: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id;
776: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
777: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
778: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id;
779: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
780: end if;
781:

Line 779: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

775: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id;
776: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
777: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
778: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id;
779: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
780: end if;
781:
782: Grant_Role(p_api_version => p_api_version,
783: p_init_msg_list => p_init_msg_list,

Line 795: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

791: x_msg_count => x_msg_count,
792: x_msg_data => x_msg_data);
793:
794:
795: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
796: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id||','||l_grant_id;
797: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
798: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
799: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id||','||l_grant_id;

Line 797: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

793:
794:
795: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
796: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id||','||l_grant_id;
797: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
798: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
799: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id||','||l_grant_id;
800: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
801: end if;

Line 798: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

794:
795: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
796: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id||','||l_grant_id;
797: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
798: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
799: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id||','||l_grant_id;
800: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
801: end if;
802:

Line 800: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

796: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id||','||l_grant_id;
797: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
798: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
799: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id||','||l_grant_id;
800: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
801: end if;
802:
803: FPA_UTILITIES_PVT.END_ACTIVITY(
804: p_api_name => l_api_name,

Line 803: FPA_UTILITIES_PVT.END_ACTIVITY(

799: l_msg_log := p_object_id||','||p_project_role_id||','||p_party_id||','||l_grant_id;
800: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
801: end if;
802:
803: FPA_UTILITIES_PVT.END_ACTIVITY(
804: p_api_name => l_api_name,
805: p_pkg_name => G_PKG_NAME,
806: p_msg_log => null,
807: x_msg_count => x_msg_count,

Line 811: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

807: x_msg_count => x_msg_count,
808: x_msg_data => x_msg_data);
809:
810: EXCEPTION
811: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
812: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
813: p_api_name => l_api_name,
814: p_pkg_name => G_PKG_NAME,
815: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 812: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

808: x_msg_data => x_msg_data);
809:
810: EXCEPTION
811: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
812: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
813: p_api_name => l_api_name,
814: p_pkg_name => G_PKG_NAME,
815: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
816: p_msg_log => l_msg_log,

Line 815: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

811: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
812: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
813: p_api_name => l_api_name,
814: p_pkg_name => G_PKG_NAME,
815: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
816: p_msg_log => l_msg_log,
817: x_msg_count => x_msg_count,
818: x_msg_data => x_msg_data,
819: p_api_type => G_API_TYPE);

Line 821: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

817: x_msg_count => x_msg_count,
818: x_msg_data => x_msg_data,
819: p_api_type => G_API_TYPE);
820:
821: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
822: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
823: p_api_name => l_api_name,
824: p_pkg_name => G_PKG_NAME,
825: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 822: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

818: x_msg_data => x_msg_data,
819: p_api_type => G_API_TYPE);
820:
821: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
822: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
823: p_api_name => l_api_name,
824: p_pkg_name => G_PKG_NAME,
825: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
826: p_msg_log => l_msg_log,

Line 825: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

821: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
822: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
823: p_api_name => l_api_name,
824: p_pkg_name => G_PKG_NAME,
825: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
826: p_msg_log => l_msg_log,
827: x_msg_count => x_msg_count,
828: x_msg_data => x_msg_data,
829: p_api_type => G_API_TYPE);

Line 832: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

828: x_msg_data => x_msg_data,
829: p_api_type => G_API_TYPE);
830:
831: when OTHERS then
832: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
833: p_api_name => l_api_name,
834: p_pkg_name => G_PKG_NAME,
835: p_exc_name => 'OTHERS',
836: p_msg_log => l_msg_log||SQLERRM,

Line 908: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

904: x_assignment_action VARCHAR2(20) := 'NOACTION';
905:
906: BEGIN
907:
908: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
909: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
910:
911: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
912: p_api_name => l_api_name,

Line 909: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

905:
906: BEGIN
907:
908: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
909: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
910:
911: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
912: p_api_name => l_api_name,
913: p_pkg_name => G_PKG_NAME,

Line 911: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

907:
908: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
909: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
910:
911: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
912: p_api_name => l_api_name,
913: p_pkg_name => G_PKG_NAME,
914: p_init_msg_list => p_init_msg_list,
915: l_api_version => l_api_version,

Line 922: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

918: p_msg_log => 'Entering fpa_security_pvt.update_portfolio_user',
919: x_return_status => x_return_status);
920:
921: -- check if activity started successfully
922: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
923: l_msg_log := 'start_activity';
924: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
925: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
926: l_msg_log := 'start_activity';

Line 924: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

920:
921: -- check if activity started successfully
922: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
923: l_msg_log := 'start_activity';
924: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
925: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
926: l_msg_log := 'start_activity';
927: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
928: end if;

Line 925: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

921: -- check if activity started successfully
922: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
923: l_msg_log := 'start_activity';
924: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
925: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
926: l_msg_log := 'start_activity';
927: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
928: end if;
929:

Line 927: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

923: l_msg_log := 'start_activity';
924: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
925: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
926: l_msg_log := 'start_activity';
927: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
928: end if;
929:
930:
931: open update_rec_csr(p_portfolio_party_id);

Line 949: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

945: close update_rec_csr;
946:
947: if(p_project_role_id <> l_project_role_id) then
948: if (Get_Role(p_project_role_id) = G_OWNER AND Get_Owner(l_object_id) is not null) then
949: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
950: l_user := Get_party_Name(p_project_role_id);
951: FPA_UTILITIES_PVT.SET_MESSAGE(
952: p_app_name => g_app_name
953: , p_msg_name => 'FPA_SEC_OWNER_ROLE_EXISTS'

Line 951: FPA_UTILITIES_PVT.SET_MESSAGE(

947: if(p_project_role_id <> l_project_role_id) then
948: if (Get_Role(p_project_role_id) = G_OWNER AND Get_Owner(l_object_id) is not null) then
949: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
950: l_user := Get_party_Name(p_project_role_id);
951: FPA_UTILITIES_PVT.SET_MESSAGE(
952: p_app_name => g_app_name
953: , p_msg_name => 'FPA_SEC_OWNER_ROLE_EXISTS'
954: , p_token1 => 'USER'
955: ,p_token1_value => l_user);

Line 957: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

953: , p_msg_name => 'FPA_SEC_OWNER_ROLE_EXISTS'
954: , p_token1 => 'USER'
955: ,p_token1_value => l_user);
956: l_msg_log := 'FPA_SEC_OWNER_ROLE_EXISTS'||p_project_role_id||','||l_object_id;
957: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
958: end if;
959: end if;
960:
961: -- l_start_date_active := p_start_date_active;

Line 1006: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

1002: x_return_status => l_return_status,
1003: x_msg_count => x_msg_count,
1004: x_msg_data => x_msg_data);
1005:
1006: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1007: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1008: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1009: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1010: l_msg_log := p_portfolio_party_id||','||l_project_role_id;

Line 1008: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1004: x_msg_data => x_msg_data);
1005:
1006: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1007: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1008: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1009: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1010: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1011: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1012: end if;

Line 1009: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1005:
1006: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1007: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1008: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1009: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1010: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1011: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1012: end if;
1013: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

Line 1011: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1007: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1008: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1009: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1010: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1011: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1012: end if;
1013: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1014: */
1015:

Line 1013: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

1009: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1010: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1011: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1012: end if;
1013: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1014: */
1015:
1016: pa_project_parties_utils.validate_project_party(
1017: FND_API.G_VALID_LEVEL_FULL,

Line 1037: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

1033: x_call_overlap,
1034: x_assignment_action,
1035: x_return_status);
1036:
1037: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1038: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1039: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1040: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1041: l_msg_log := p_portfolio_party_id||','||l_project_role_id;

Line 1039: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1035: x_return_status);
1036:
1037: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1038: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1039: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1040: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1041: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1042: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1043: end if;

Line 1040: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1036:
1037: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1038: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1039: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1040: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1041: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1042: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1043: end if;
1044:

Line 1042: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1038: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1039: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1040: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1041: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1042: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1043: end if;
1044:
1045: UPDATE pa_project_parties SET
1046: project_role_id = p_project_role_id,

Line 1065: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

1061: x_return_status => x_return_status,
1062: x_msg_count => x_msg_count,
1063: x_msg_data => x_msg_data);
1064:
1065: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1066: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1067: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1068: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1069: l_msg_log := p_portfolio_party_id||','||l_project_role_id;

Line 1067: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1063: x_msg_data => x_msg_data);
1064:
1065: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1066: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1067: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1068: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1069: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1070: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1071: end if;

Line 1068: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1064:
1065: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1066: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1067: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1068: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1069: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1070: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1071: end if;
1072:

Line 1070: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1066: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1067: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1068: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1069: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1070: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1071: end if;
1072:
1073:
1074: Grant_Role(p_api_version => p_api_version,

Line 1086: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

1082: x_return_status => x_return_status,
1083: x_msg_count => x_msg_count,
1084: x_msg_data => x_msg_data);
1085:
1086: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1087: l_msg_log := p_portfolio_party_id||','||l_resource_source_id||','||l_project_role_id;
1088: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1089: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1090: l_msg_log := p_portfolio_party_id||','||l_resource_source_id||','||l_project_role_id;

Line 1088: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1084: x_msg_data => x_msg_data);
1085:
1086: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1087: l_msg_log := p_portfolio_party_id||','||l_resource_source_id||','||l_project_role_id;
1088: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1089: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1090: l_msg_log := p_portfolio_party_id||','||l_resource_source_id||','||l_project_role_id;
1091: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1092: end if;

Line 1089: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1085:
1086: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1087: l_msg_log := p_portfolio_party_id||','||l_resource_source_id||','||l_project_role_id;
1088: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1089: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1090: l_msg_log := p_portfolio_party_id||','||l_resource_source_id||','||l_project_role_id;
1091: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1092: end if;
1093:

Line 1091: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1087: l_msg_log := p_portfolio_party_id||','||l_resource_source_id||','||l_project_role_id;
1088: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1089: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1090: l_msg_log := p_portfolio_party_id||','||l_resource_source_id||','||l_project_role_id;
1091: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1092: end if;
1093:
1094: -- end if;
1095:

Line 1096: FPA_UTILITIES_PVT.END_ACTIVITY(

1092: end if;
1093:
1094: -- end if;
1095:
1096: FPA_UTILITIES_PVT.END_ACTIVITY(
1097: p_api_name => l_api_name,
1098: p_pkg_name => G_PKG_NAME,
1099: p_msg_log => l_msg_log,
1100: x_msg_count => x_msg_count,

Line 1104: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

1100: x_msg_count => x_msg_count,
1101: x_msg_data => x_msg_data);
1102:
1103: EXCEPTION
1104: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1105: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1106: p_api_name => l_api_name,
1107: p_pkg_name => G_PKG_NAME,
1108: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 1105: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1101: x_msg_data => x_msg_data);
1102:
1103: EXCEPTION
1104: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1105: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1106: p_api_name => l_api_name,
1107: p_pkg_name => G_PKG_NAME,
1108: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1109: p_msg_log => l_msg_log,

Line 1108: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

1104: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1105: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1106: p_api_name => l_api_name,
1107: p_pkg_name => G_PKG_NAME,
1108: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1109: p_msg_log => l_msg_log,
1110: x_msg_count => x_msg_count,
1111: x_msg_data => x_msg_data,
1112: p_api_type => G_API_TYPE);

Line 1114: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

1110: x_msg_count => x_msg_count,
1111: x_msg_data => x_msg_data,
1112: p_api_type => G_API_TYPE);
1113:
1114: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1115: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1116: p_api_name => l_api_name,
1117: p_pkg_name => G_PKG_NAME,
1118: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 1115: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1111: x_msg_data => x_msg_data,
1112: p_api_type => G_API_TYPE);
1113:
1114: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1115: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1116: p_api_name => l_api_name,
1117: p_pkg_name => G_PKG_NAME,
1118: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1119: p_msg_log => l_msg_log,

Line 1118: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

1114: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1115: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1116: p_api_name => l_api_name,
1117: p_pkg_name => G_PKG_NAME,
1118: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1119: p_msg_log => l_msg_log,
1120: x_msg_count => x_msg_count,
1121: x_msg_data => x_msg_data,
1122: p_api_type => G_API_TYPE);

Line 1125: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1121: x_msg_data => x_msg_data,
1122: p_api_type => G_API_TYPE);
1123:
1124: when OTHERS then
1125: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1126: p_api_name => l_api_name,
1127: p_pkg_name => G_PKG_NAME,
1128: p_exc_name => 'OTHERS',
1129: p_msg_log => l_msg_log||SQLERRM,

Line 1179: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

1175: l_user VARCHAR2(200);
1176:
1177: BEGIN
1178:
1179: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1180: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1181:
1182: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
1183: p_api_name => l_api_name,

Line 1180: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

1176:
1177: BEGIN
1178:
1179: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1180: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1181:
1182: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
1183: p_api_name => l_api_name,
1184: p_pkg_name => G_PKG_NAME,

Line 1182: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

1178:
1179: l_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1180: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1181:
1182: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
1183: p_api_name => l_api_name,
1184: p_pkg_name => G_PKG_NAME,
1185: p_init_msg_list => p_init_msg_list,
1186: l_api_version => l_api_version,

Line 1193: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

1189: p_msg_log => 'Entering fpa_security_pvt.update_portfolio_owner',
1190: x_return_status => x_return_status);
1191:
1192: -- check if activity started successfully
1193: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1194: l_msg_log := 'start_activity';
1195: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1196: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1197: l_msg_log := 'start_activity';

Line 1195: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1191:
1192: -- check if activity started successfully
1193: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1194: l_msg_log := 'start_activity';
1195: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1196: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1197: l_msg_log := 'start_activity';
1198: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1199: end if;

Line 1196: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1192: -- check if activity started successfully
1193: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1194: l_msg_log := 'start_activity';
1195: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1196: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1197: l_msg_log := 'start_activity';
1198: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1199: end if;
1200:

Line 1198: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1194: l_msg_log := 'start_activity';
1195: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1196: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1197: l_msg_log := 'start_activity';
1198: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1199: end if;
1200:
1201:
1202: open owner_rec_csr(p_portfolio_id);

Line 1211: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

1207: close owner_rec_csr;
1208:
1209:
1210: if(p_person_id = l_resource_source_id) then
1211: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1212: FPA_UTILITIES_PVT.END_ACTIVITY(
1213: p_api_name => l_api_name,
1214: p_pkg_name => G_PKG_NAME,
1215: p_msg_log => 'Exiting fpa_security_pvt.update_portfolio_owner',

Line 1212: FPA_UTILITIES_PVT.END_ACTIVITY(

1208:
1209:
1210: if(p_person_id = l_resource_source_id) then
1211: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1212: FPA_UTILITIES_PVT.END_ACTIVITY(
1213: p_api_name => l_api_name,
1214: p_pkg_name => G_PKG_NAME,
1215: p_msg_log => 'Exiting fpa_security_pvt.update_portfolio_owner',
1216: x_msg_count => x_msg_count,

Line 1224: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

1220:
1221: /*
1222: if(p_person_id <> l_resource_source_id) then
1223: if (check_user(p_person_id, p_portfolio_id)) then
1224: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
1225: l_user := Get_party_Name(p_person_id);
1226: FPA_UTILITIES_PVT.SET_MESSAGE(
1227: p_app_name => g_app_name
1228: , p_msg_name => 'FPA_SEC_USER_EXISTS'

Line 1226: FPA_UTILITIES_PVT.SET_MESSAGE(

1222: if(p_person_id <> l_resource_source_id) then
1223: if (check_user(p_person_id, p_portfolio_id)) then
1224: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
1225: l_user := Get_party_Name(p_person_id);
1226: FPA_UTILITIES_PVT.SET_MESSAGE(
1227: p_app_name => g_app_name
1228: , p_msg_name => 'FPA_SEC_USER_EXISTS'
1229: , p_token1 => 'USER'
1230: ,p_token1_value => l_user);

Line 1232: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1228: , p_msg_name => 'FPA_SEC_USER_EXISTS'
1229: , p_token1 => 'USER'
1230: ,p_token1_value => l_user);
1231: l_msg_log := 'FPA_SEC_USER_EXISTS'||p_person_id||','||p_portfolio_id;
1232: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1233: end if;
1234: end if;
1235: */
1236:

Line 1268: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

1264: x_return_status => l_return_status,
1265: x_msg_count => x_msg_count,
1266: x_msg_data => x_msg_data);
1267:
1268: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1269: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1270: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1271: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1272: l_msg_log := p_portfolio_party_id||','||l_project_role_id;

Line 1270: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1266: x_msg_data => x_msg_data);
1267:
1268: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1269: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1270: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1271: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1272: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1273: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1274: end if;

Line 1271: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1267:
1268: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1269: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1270: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1271: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1272: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1273: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1274: end if;
1275: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

Line 1273: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1269: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1270: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1271: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1272: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1273: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1274: end if;
1275: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1276:
1277: */

Line 1275: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

1271: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1272: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1273: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1274: end if;
1275: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1276:
1277: */
1278:
1279: /*

Line 1300: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

1296: x_return_status => x_return_status,
1297: x_msg_count => x_msg_count,
1298: x_msg_data => x_msg_data);
1299:
1300: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1301: l_msg_log := l_project_party_id||','||l_resource_source_id;
1302: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1303: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1304: l_msg_log := l_project_party_id||','||l_resource_source_id;

Line 1302: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1298: x_msg_data => x_msg_data);
1299:
1300: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1301: l_msg_log := l_project_party_id||','||l_resource_source_id;
1302: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1303: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1304: l_msg_log := l_project_party_id||','||l_resource_source_id;
1305: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1306: end if;

Line 1303: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1299:
1300: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1301: l_msg_log := l_project_party_id||','||l_resource_source_id;
1302: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1303: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1304: l_msg_log := l_project_party_id||','||l_resource_source_id;
1305: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1306: end if;
1307:

Line 1305: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1301: l_msg_log := l_project_party_id||','||l_resource_source_id;
1302: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1303: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1304: l_msg_log := l_project_party_id||','||l_resource_source_id;
1305: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1306: end if;
1307:
1308:
1309: Grant_Role(p_api_version => p_api_version,

Line 1321: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

1317: x_return_status => x_return_status,
1318: x_msg_count => x_msg_count,
1319: x_msg_data => x_msg_data);
1320:
1321: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1322: l_msg_log := l_project_role_id||','||p_person_id;
1323: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1324: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1325: l_msg_log := l_project_role_id||','||p_person_id;

Line 1323: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1319: x_msg_data => x_msg_data);
1320:
1321: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1322: l_msg_log := l_project_role_id||','||p_person_id;
1323: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1324: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1325: l_msg_log := l_project_role_id||','||p_person_id;
1326: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1327: end if;

Line 1324: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1320:
1321: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1322: l_msg_log := l_project_role_id||','||p_person_id;
1323: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1324: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1325: l_msg_log := l_project_role_id||','||p_person_id;
1326: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1327: end if;
1328:

Line 1326: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1322: l_msg_log := l_project_role_id||','||p_person_id;
1323: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1324: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1325: l_msg_log := l_project_role_id||','||p_person_id;
1326: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1327: end if;
1328:
1329: -- end if;
1330:

Line 1331: FPA_UTILITIES_PVT.END_ACTIVITY(

1327: end if;
1328:
1329: -- end if;
1330:
1331: FPA_UTILITIES_PVT.END_ACTIVITY(
1332: p_api_name => l_api_name,
1333: p_pkg_name => G_PKG_NAME,
1334: p_msg_log => l_msg_log,
1335: x_msg_count => x_msg_count,

Line 1339: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

1335: x_msg_count => x_msg_count,
1336: x_msg_data => x_msg_data);
1337:
1338: EXCEPTION
1339: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1340: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1341: p_api_name => l_api_name,
1342: p_pkg_name => G_PKG_NAME,
1343: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 1340: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1336: x_msg_data => x_msg_data);
1337:
1338: EXCEPTION
1339: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1340: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1341: p_api_name => l_api_name,
1342: p_pkg_name => G_PKG_NAME,
1343: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1344: p_msg_log => l_msg_log,

Line 1343: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

1339: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1340: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1341: p_api_name => l_api_name,
1342: p_pkg_name => G_PKG_NAME,
1343: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1344: p_msg_log => l_msg_log,
1345: x_msg_count => x_msg_count,
1346: x_msg_data => x_msg_data,
1347: p_api_type => G_API_TYPE);

Line 1349: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

1345: x_msg_count => x_msg_count,
1346: x_msg_data => x_msg_data,
1347: p_api_type => G_API_TYPE);
1348:
1349: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1350: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1351: p_api_name => l_api_name,
1352: p_pkg_name => G_PKG_NAME,
1353: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 1350: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1346: x_msg_data => x_msg_data,
1347: p_api_type => G_API_TYPE);
1348:
1349: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1350: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1351: p_api_name => l_api_name,
1352: p_pkg_name => G_PKG_NAME,
1353: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1354: p_msg_log => l_msg_log,

Line 1353: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

1349: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1350: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1351: p_api_name => l_api_name,
1352: p_pkg_name => G_PKG_NAME,
1353: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1354: p_msg_log => l_msg_log,
1355: x_msg_count => x_msg_count,
1356: x_msg_data => x_msg_data,
1357: p_api_type => G_API_TYPE);

Line 1360: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1356: x_msg_data => x_msg_data,
1357: p_api_type => G_API_TYPE);
1358:
1359: when OTHERS then
1360: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1361: p_api_name => l_api_name,
1362: p_pkg_name => G_PKG_NAME,
1363: p_exc_name => 'OTHERS',
1364: p_msg_log => l_msg_log||SQLERRM,

Line 1418: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

1414: ----------------------------------------------------------------------------
1415: BEGIN
1416: l_exists := FND_API.G_FALSE;
1417:
1418: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1419: -- call START_ACTIVITY to create savepoint, check compatibility
1420: -- and initialize message list
1421: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
1422: p_api_name => l_api_name,

Line 1421: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

1417:
1418: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1419: -- call START_ACTIVITY to create savepoint, check compatibility
1420: -- and initialize message list
1421: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
1422: p_api_name => l_api_name,
1423: p_pkg_name => G_PKG_NAME,
1424: p_init_msg_list => p_init_msg_list,
1425: l_api_version => l_api_version,

Line 1432: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

1428: p_msg_log => 'Entering fpa_security_pvt.delete_portfolio_user',
1429: x_return_status => x_return_status);
1430:
1431: -- check if activity started successfully
1432: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1433: l_msg_log := 'start_activity';
1434: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1435: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1436: l_msg_log := 'start_activity';

Line 1434: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1430:
1431: -- check if activity started successfully
1432: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1433: l_msg_log := 'start_activity';
1434: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1435: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1436: l_msg_log := 'start_activity';
1437: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1438: end if;

Line 1435: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1431: -- check if activity started successfully
1432: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1433: l_msg_log := 'start_activity';
1434: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1435: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1436: l_msg_log := 'start_activity';
1437: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1438: end if;
1439:

Line 1437: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1433: l_msg_log := 'start_activity';
1434: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1435: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1436: l_msg_log := 'start_activity';
1437: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1438: end if;
1439:
1440: open project_parties_csr(p_portfolio_party_id => p_portfolio_party_id);
1441: fetch project_parties_csr into l_role_id, l_party_id, l_object_id;

Line 1444: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

1440: open project_parties_csr(p_portfolio_party_id => p_portfolio_party_id);
1441: fetch project_parties_csr into l_role_id, l_party_id, l_object_id;
1442: if project_parties_csr%NOTFOUND then
1443: close project_parties_csr;
1444: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
1445: l_user := Get_party_Name(l_party_id);
1446: FPA_UTILITIES_PVT.SET_MESSAGE(
1447: p_app_name => g_app_name
1448: , p_msg_name => 'FPA_SEC_DELETE_FAILED'

Line 1446: FPA_UTILITIES_PVT.SET_MESSAGE(

1442: if project_parties_csr%NOTFOUND then
1443: close project_parties_csr;
1444: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
1445: l_user := Get_party_Name(l_party_id);
1446: FPA_UTILITIES_PVT.SET_MESSAGE(
1447: p_app_name => g_app_name
1448: , p_msg_name => 'FPA_SEC_DELETE_FAILED'
1449: , p_token1 => 'USER'
1450: ,p_token1_value => l_user);

Line 1452: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1448: , p_msg_name => 'FPA_SEC_DELETE_FAILED'
1449: , p_token1 => 'USER'
1450: ,p_token1_value => l_user);
1451: l_msg_log := 'FPA_SEC_DELETE_FAILED'||p_portfolio_party_id;
1452: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1453: end if;
1454: close project_parties_csr;
1455: -- l_grant_id := pa_project_parties_utils.get_grant_id(
1456: -- p_project_party_id => p_portfolio_party_id);

Line 1470: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

1466: close verify_delete_csr;
1467:
1468:
1469: if(l_exists = FND_API.G_TRUE) then
1470: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
1471: l_user := Get_party_Name(l_party_id);
1472: FPA_UTILITIES_PVT.SET_MESSAGE(
1473: p_app_name => g_app_name
1474: , p_msg_name => 'FPA_SEC_DELETE_FAILED'

Line 1472: FPA_UTILITIES_PVT.SET_MESSAGE(

1468:
1469: if(l_exists = FND_API.G_TRUE) then
1470: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
1471: l_user := Get_party_Name(l_party_id);
1472: FPA_UTILITIES_PVT.SET_MESSAGE(
1473: p_app_name => g_app_name
1474: , p_msg_name => 'FPA_SEC_DELETE_FAILED'
1475: , p_token1 => 'USER'
1476: ,p_token1_value => l_user);

Line 1478: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1474: , p_msg_name => 'FPA_SEC_DELETE_FAILED'
1475: , p_token1 => 'USER'
1476: ,p_token1_value => l_user);
1477: l_msg_log := 'FPA_SEC_DELETE_FAILED '||p_portfolio_party_id;
1478: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1479: end if;
1480:
1481: l_instance_set_id := pa_security_pvt.get_instance_set_id(p_instance_set_name);
1482:

Line 1495: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

1491: x_msg_count => x_msg_count,
1492: x_msg_data => x_msg_data);
1493:
1494: -- check if activity started successfully
1495: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1496: l_msg_log := p_portfolio_party_id||','||l_role_id||','||l_instance_set_id||','||l_party_id;
1497: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1498: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1499: l_msg_log := p_portfolio_party_id||','||l_role_id||','||l_instance_set_id||','||l_party_id;

Line 1497: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

1493:
1494: -- check if activity started successfully
1495: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1496: l_msg_log := p_portfolio_party_id||','||l_role_id||','||l_instance_set_id||','||l_party_id;
1497: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1498: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1499: l_msg_log := p_portfolio_party_id||','||l_role_id||','||l_instance_set_id||','||l_party_id;
1500: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1501: end if;

Line 1498: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1494: -- check if activity started successfully
1495: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1496: l_msg_log := p_portfolio_party_id||','||l_role_id||','||l_instance_set_id||','||l_party_id;
1497: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1498: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1499: l_msg_log := p_portfolio_party_id||','||l_role_id||','||l_instance_set_id||','||l_party_id;
1500: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1501: end if;
1502:

Line 1500: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1496: l_msg_log := p_portfolio_party_id||','||l_role_id||','||l_instance_set_id||','||l_party_id;
1497: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
1498: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1499: l_msg_log := p_portfolio_party_id||','||l_role_id||','||l_instance_set_id||','||l_party_id;
1500: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1501: end if;
1502:
1503: FPA_UTILITIES_PVT.END_ACTIVITY(
1504: p_api_name => l_api_name,

Line 1503: FPA_UTILITIES_PVT.END_ACTIVITY(

1499: l_msg_log := p_portfolio_party_id||','||l_role_id||','||l_instance_set_id||','||l_party_id;
1500: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1501: end if;
1502:
1503: FPA_UTILITIES_PVT.END_ACTIVITY(
1504: p_api_name => l_api_name,
1505: p_pkg_name => G_PKG_NAME,
1506: p_msg_log => 'end fpa_security_pvt.Delete_Portfolio_User',
1507: x_msg_count => x_msg_count,

Line 1512: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

1508: x_msg_data => x_msg_data);
1509:
1510:
1511: EXCEPTION
1512: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1513: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1514: p_api_name => l_api_name,
1515: p_pkg_name => G_PKG_NAME,
1516: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 1513: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1509:
1510:
1511: EXCEPTION
1512: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1513: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1514: p_api_name => l_api_name,
1515: p_pkg_name => G_PKG_NAME,
1516: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1517: p_msg_log => l_msg_log,

Line 1516: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

1512: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
1513: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1514: p_api_name => l_api_name,
1515: p_pkg_name => G_PKG_NAME,
1516: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
1517: p_msg_log => l_msg_log,
1518: x_msg_count => x_msg_count,
1519: x_msg_data => x_msg_data,
1520: p_api_type => G_API_TYPE);

Line 1522: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

1518: x_msg_count => x_msg_count,
1519: x_msg_data => x_msg_data,
1520: p_api_type => G_API_TYPE);
1521:
1522: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1523: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1524: p_api_name => l_api_name,
1525: p_pkg_name => G_PKG_NAME,
1526: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 1523: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1519: x_msg_data => x_msg_data,
1520: p_api_type => G_API_TYPE);
1521:
1522: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1523: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1524: p_api_name => l_api_name,
1525: p_pkg_name => G_PKG_NAME,
1526: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1527: p_msg_log => l_msg_log,

Line 1526: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

1522: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
1523: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1524: p_api_name => l_api_name,
1525: p_pkg_name => G_PKG_NAME,
1526: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
1527: p_msg_log => l_msg_log,
1528: x_msg_count => x_msg_count,
1529: x_msg_data => x_msg_data,
1530: p_api_type => G_API_TYPE);

Line 1533: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1529: x_msg_data => x_msg_data,
1530: p_api_type => G_API_TYPE);
1531:
1532: when OTHERS then
1533: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1534: p_api_name => l_api_name,
1535: p_pkg_name => G_PKG_NAME,
1536: p_exc_name => 'OTHERS',
1537: p_msg_log => l_msg_log||SQLCODE||SQLERRM,