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

Line 392: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

388: --
389: -- IN: p_business_area_id NUMBER - The Business Area ID to work under
390: -------------------------------------------------------------------------------
391: PROCEDURE INITIALIZE(p_api_version IN NUMBER,
392: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
393: p_validation_level IN NUMBER
394: := FND_API.G_VALID_LEVEL_FULL,
395: x_return_status OUT NOCOPY varchar2,
396: x_msg_count OUT NOCOPY number,

Line 394: := FND_API.G_VALID_LEVEL_FULL,

390: -------------------------------------------------------------------------------
391: PROCEDURE INITIALIZE(p_api_version IN NUMBER,
392: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
393: p_validation_level IN NUMBER
394: := FND_API.G_VALID_LEVEL_FULL,
395: x_return_status OUT NOCOPY varchar2,
396: x_msg_count OUT NOCOPY number,
397: x_msg_data OUT NOCOPY varchar2,
398: p_business_area_id IN NUMBER,

Line 400: p_shared_rw IN VARCHAR2 := FND_API.G_FALSE,

396: x_msg_count OUT NOCOPY number,
397: x_msg_data OUT NOCOPY varchar2,
398: p_business_area_id IN NUMBER,
399: p_shadow_id IN NUMBER,
400: p_shared_rw IN VARCHAR2 := FND_API.G_FALSE,
401: p_annot_rw IN VARCHAR2 := FND_API.G_FALSE,
402: p_detach_all IN VARCHAR2 := FND_API.G_TRUE)
403: is
404: l_api_name CONSTANT VARCHAR2(20) := G_PKG_NAME||'.initialize';

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

397: x_msg_data OUT NOCOPY varchar2,
398: p_business_area_id IN NUMBER,
399: p_shadow_id IN NUMBER,
400: p_shared_rw IN VARCHAR2 := FND_API.G_FALSE,
401: p_annot_rw IN VARCHAR2 := FND_API.G_FALSE,
402: p_detach_all IN VARCHAR2 := FND_API.G_TRUE)
403: is
404: l_api_name CONSTANT VARCHAR2(20) := G_PKG_NAME||'.initialize';
405: l_api_version CONSTANT NUMBER := 1.0;

Line 402: p_detach_all IN VARCHAR2 := FND_API.G_TRUE)

398: p_business_area_id IN NUMBER,
399: p_shadow_id IN NUMBER,
400: p_shared_rw IN VARCHAR2 := FND_API.G_FALSE,
401: p_annot_rw IN VARCHAR2 := FND_API.G_FALSE,
402: p_detach_all IN VARCHAR2 := FND_API.G_TRUE)
403: is
404: l_api_name CONSTANT VARCHAR2(20) := G_PKG_NAME||'.initialize';
405: l_api_version CONSTANT NUMBER := 1.0;
406: l_code_AW VARCHAR2(30);

Line 414: IF NOT FND_API.Compatible_API_Call( l_api_version,

410: l_comm VARCHAR2(200);
411: l_user_id NUMBER;
412: begin
413: -- Standard call to check for call compatibility.
414: IF NOT FND_API.Compatible_API_Call( l_api_version,
415: p_api_version, l_api_name, G_PKG_NAME)
416: THEN
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END IF;

Line 417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

413: -- Standard call to check for call compatibility.
414: IF NOT FND_API.Compatible_API_Call( l_api_version,
415: p_api_version, l_api_name, G_PKG_NAME)
416: THEN
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419: -- Initialize message list if p_init_msg_list is set to TRUE.
420: IF FND_API.to_Boolean(p_init_msg_list) THEN
421: FND_MSG_PUB.initialize;

Line 420: IF FND_API.to_Boolean(p_init_msg_list) THEN

416: THEN
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419: -- Initialize message list if p_init_msg_list is set to TRUE.
420: IF FND_API.to_Boolean(p_init_msg_list) THEN
421: FND_MSG_PUB.initialize;
422: END IF;
423:
424: -- Initialize API return status to success

Line 425: x_return_status := FND_API.G_RET_STS_SUCCESS;

421: FND_MSG_PUB.initialize;
422: END IF;
423:
424: -- Initialize API return status to success
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: ZPB_LOG.WRITE (l_api_name||'.begin',
428: 'Initializing Bus Area '||p_business_area_id);
429:

Line 430: if p_detach_all = FND_API.G_TRUE then

426:
427: ZPB_LOG.WRITE (l_api_name||'.begin',
428: 'Initializing Bus Area '||p_business_area_id);
429:
430: if p_detach_all = FND_API.G_TRUE then
431: DETACH_ALL;
432: end if;
433:
434: if (FND_GLOBAL.USER_ID = -1) then

Line 464: if (p_annot_rw = FND_API.G_TRUE) then

460: l_comm := substr(l_trace, instr(l_trace, 'AWLOG:')+6);
461: ZPB_AW.EXECUTE ('CM.LOGFILE = '''||l_comm||'''');
462: end if;
463:
464: if (p_annot_rw = FND_API.G_TRUE) then
465: EXECUTE('aw attach '||l_annot_AW||' rw');
466: else
467: EXECUTE('aw attach '||l_annot_AW||' ro');
468: end if;

Line 469: if (p_shared_rw = FND_API.G_TRUE) then

465: EXECUTE('aw attach '||l_annot_AW||' rw');
466: else
467: EXECUTE('aw attach '||l_annot_AW||' ro');
468: end if;
469: if (p_shared_rw = FND_API.G_TRUE) then
470: EXECUTE('aw attach '||l_schema||GET_SHARED_AW||' rw');
471: EXECUTE('aw aliaslist '||l_schema||GET_SHARED_AW||' alias shared');
472: EXECUTE('aw aliaslist '||l_schema||GET_SHARED_AW||' alias s');
473: EXECUTE('aw aliaslist '||l_schema||GET_SHARED_AW||' alias aggaw');

Line 495: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

491: --
492: -- IN: p_analysis_cycle_id NUMBER - The Analysis Cycle to initialize against
493: -------------------------------------------------------------------------------
494: PROCEDURE INITIALIZE_FOR_AC(p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
496: p_validation_level IN NUMBER
497: := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY varchar2,
499: x_msg_count OUT NOCOPY number,

Line 497: := FND_API.G_VALID_LEVEL_FULL,

493: -------------------------------------------------------------------------------
494: PROCEDURE INITIALIZE_FOR_AC(p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
496: p_validation_level IN NUMBER
497: := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY varchar2,
499: x_msg_count OUT NOCOPY number,
500: x_msg_data OUT NOCOPY varchar2,
501: p_analysis_cycle_id IN NUMBER,

Line 502: p_shared_rw IN VARCHAR2:=FND_API.G_FALSE,

498: x_return_status OUT NOCOPY varchar2,
499: x_msg_count OUT NOCOPY number,
500: x_msg_data OUT NOCOPY varchar2,
501: p_analysis_cycle_id IN NUMBER,
502: p_shared_rw IN VARCHAR2:=FND_API.G_FALSE,
503: p_annot_rw IN VARCHAR2:=FND_API.G_FALSE)
504: is
505: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
506: begin

Line 503: p_annot_rw IN VARCHAR2:=FND_API.G_FALSE)

499: x_msg_count OUT NOCOPY number,
500: x_msg_data OUT NOCOPY varchar2,
501: p_analysis_cycle_id IN NUMBER,
502: p_shared_rw IN VARCHAR2:=FND_API.G_FALSE,
503: p_annot_rw IN VARCHAR2:=FND_API.G_FALSE)
504: is
505: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
506: begin
507:

Line 545: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

541: --
542: -- IN: p_business_area_id NUMBER - The Business Area ID to work under
543: -------------------------------------------------------------------------------
544: PROCEDURE INITIALIZE_USER(p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
546: p_validation_level IN NUMBER
547: := FND_API.G_VALID_LEVEL_FULL,
548: x_return_status OUT NOCOPY varchar2,
549: x_msg_count OUT NOCOPY number,

Line 547: := FND_API.G_VALID_LEVEL_FULL,

543: -------------------------------------------------------------------------------
544: PROCEDURE INITIALIZE_USER(p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
546: p_validation_level IN NUMBER
547: := FND_API.G_VALID_LEVEL_FULL,
548: x_return_status OUT NOCOPY varchar2,
549: x_msg_count OUT NOCOPY number,
550: x_msg_data OUT NOCOPY varchar2,
551: p_user IN FND_USER.USER_ID%type,

Line 555: p_detach_all IN VARCHAR2 :=FND_API.G_FALSE)

551: p_user IN FND_USER.USER_ID%type,
552: p_business_area_id IN NUMBER,
553: p_attach_readwrite IN VARCHAR2,
554: p_sync_shared IN VARCHAR2,
555: p_detach_all IN VARCHAR2 :=FND_API.G_FALSE)
556: is
557: l_api_name CONSTANT VARCHAR2(30) := G_PKG_NAME||'.initialize_user';
558: l_api_version CONSTANT NUMBER := 1.0;
559: l_code_AW VARCHAR2(30);

Line 566: IF NOT FND_API.Compatible_API_Call( l_api_version,

562: l_schema VARCHAR2(10);
563: l_onattach BOOLEAN;
564: begin
565: -- Standard call to check for call compatibility.
566: IF NOT FND_API.Compatible_API_Call( l_api_version,
567: p_api_version, l_api_name, G_PKG_NAME)
568: THEN
569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;

Line 569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

565: -- Standard call to check for call compatibility.
566: IF NOT FND_API.Compatible_API_Call( l_api_version,
567: p_api_version, l_api_name, G_PKG_NAME)
568: THEN
569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571: -- Initialize message list if p_init_msg_list is set to TRUE.
572: IF FND_API.to_Boolean(p_init_msg_list) THEN
573: FND_MSG_PUB.initialize;

Line 572: IF FND_API.to_Boolean(p_init_msg_list) THEN

568: THEN
569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571: -- Initialize message list if p_init_msg_list is set to TRUE.
572: IF FND_API.to_Boolean(p_init_msg_list) THEN
573: FND_MSG_PUB.initialize;
574: END IF;
575:
576: -- Initialize API return status to success

Line 577: x_return_status := FND_API.G_RET_STS_SUCCESS;

573: FND_MSG_PUB.initialize;
574: END IF;
575:
576: -- Initialize API return status to success
577: x_return_status := FND_API.G_RET_STS_SUCCESS;
578:
579: ZPB_LOG.WRITE (l_api_name||'.begin', 'Initializing User '||p_user);
580:
581: if (p_business_area_id is null) then

Line 585: if p_detach_all = FND_API.G_TRUE then

581: if (p_business_area_id is null) then
582: null;
583: end if;
584:
585: if p_detach_all = FND_API.G_TRUE then
586: DETACH_ALL;
587: end if;
588:
589: l_schema := GET_SCHEMA||'.';

Line 629: if (p_attach_readwrite = FND_API.G_TRUE) then

625: end if;
626: end if;
627: end if;
628:
629: if (p_attach_readwrite = FND_API.G_TRUE) then
630: EXECUTE('call PA.ATTACH.PERSONAL('''||p_user||''' ''rw'')');
631: else
632: EXECUTE('call PA.ATTACH.PERSONAL('''||p_user||''' ''ro'')');
633: end if;

Line 655: FND_API.G_FALSE,

651: x_msg_count,
652: x_msg_data,
653: p_business_area_id,
654: p_user,
655: FND_API.G_FALSE,
656: FND_API.G_FALSE,
657: FND_API.G_FALSE);
658: end if;
659:

Line 656: FND_API.G_FALSE,

652: x_msg_data,
653: p_business_area_id,
654: p_user,
655: FND_API.G_FALSE,
656: FND_API.G_FALSE,
657: FND_API.G_FALSE);
658: end if;
659:
660: if (p_sync_shared = FND_API.G_TRUE) then

Line 657: FND_API.G_FALSE);

653: p_business_area_id,
654: p_user,
655: FND_API.G_FALSE,
656: FND_API.G_FALSE,
657: FND_API.G_FALSE);
658: end if;
659:
660: if (p_sync_shared = FND_API.G_TRUE) then
661: EXECUTE('call PA.ATTACH.SHARED('''||p_user||''' yes)');

Line 660: if (p_sync_shared = FND_API.G_TRUE) then

656: FND_API.G_FALSE,
657: FND_API.G_FALSE);
658: end if;
659:
660: if (p_sync_shared = FND_API.G_TRUE) then
661: EXECUTE('call PA.ATTACH.SHARED('''||p_user||''' yes)');
662: end if;
663:
664: end INITIALIZE_USER;

Line 690: IF NOT FND_API.Compatible_API_Call( l_api_version,

686: BEGIN
687: -- Standard Start of API savepoint
688: SAVEPOINT zpb_aw_clean_workspace;
689: -- Standard call to check for call compatibility.
690: IF NOT FND_API.Compatible_API_Call( l_api_version,
691: p_api_version,
692: l_api_name,
693: G_PKG_NAME)
694: THEN

Line 695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

691: p_api_version,
692: l_api_name,
693: G_PKG_NAME)
694: THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697: -- Initialize message list if p_init_msg_list is set to TRUE.
698: IF FND_API.to_Boolean(p_init_msg_list) THEN
699: FND_MSG_PUB.initialize;

Line 698: IF FND_API.to_Boolean(p_init_msg_list) THEN

694: THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697: -- Initialize message list if p_init_msg_list is set to TRUE.
698: IF FND_API.to_Boolean(p_init_msg_list) THEN
699: FND_MSG_PUB.initialize;
700: END IF;
701: -- Initialize API return status to success
702: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 702: x_return_status := FND_API.G_RET_STS_SUCCESS;

698: IF FND_API.to_Boolean(p_init_msg_list) THEN
699: FND_MSG_PUB.initialize;
700: END IF;
701: -- Initialize API return status to success
702: x_return_status := FND_API.G_RET_STS_SUCCESS;
703:
704: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME||'.'||l_api_name||'.begin',
705: 'Begin OLAP workspace cleaning');
706:

Line 723: WHEN FND_API.G_EXC_ERROR THEN

719: -- Standard call to get message count and if count is 1, get message info.
720: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data );
721:
722: EXCEPTION
723: WHEN FND_API.G_EXC_ERROR THEN
724: ROLLBACK TO zpb_aw_clean_workspace;
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: FND_MSG_PUB.Count_And_Get(
727: p_count => x_msg_count,

Line 725: x_return_status := FND_API.G_RET_STS_ERROR;

721:
722: EXCEPTION
723: WHEN FND_API.G_EXC_ERROR THEN
724: ROLLBACK TO zpb_aw_clean_workspace;
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: FND_MSG_PUB.Count_And_Get(
727: p_count => x_msg_count,
728: p_data => x_msg_data
729: );

Line 730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

726: FND_MSG_PUB.Count_And_Get(
727: p_count => x_msg_count,
728: p_data => x_msg_data
729: );
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: ROLLBACK TO zpb_aw_clean_workspace;
732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
733: FND_MSG_PUB.Count_And_Get(
734: p_count => x_msg_count,

Line 732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

728: p_data => x_msg_data
729: );
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: ROLLBACK TO zpb_aw_clean_workspace;
732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
733: FND_MSG_PUB.Count_And_Get(
734: p_count => x_msg_count,
735: p_data => x_msg_data
736: );

Line 739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

735: p_data => x_msg_data
736: );
737: WHEN OTHERS THEN
738: ROLLBACK TO zpb_aw_clean_workspace;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
741: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name );
742: END IF;
743: FND_MSG_PUB.Count_And_Get(