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

Line 443: P_INIT_MSG_LIST => fnd_api.g_false,

439: where role_resource_type = 'RS_GROUP'
440: and role_resource_id = l_group_id;
441: jtf_rs_role_relate_pub.UPDATE_RESOURCE_ROLE_RELATE (
442: P_API_VERSION => 1.0,
443: P_INIT_MSG_LIST => fnd_api.g_false,
444: P_COMMIT => FND_API.G_FALSE,
445: P_ROLE_RELATE_ID => l_role_relate_id,
446: P_START_DATE_ACTIVE => l_start_date_active,
447: P_END_DATE_ACTIVE => l_end_date_active,

Line 444: P_COMMIT => FND_API.G_FALSE,

440: and role_resource_id = l_group_id;
441: jtf_rs_role_relate_pub.UPDATE_RESOURCE_ROLE_RELATE (
442: P_API_VERSION => 1.0,
443: P_INIT_MSG_LIST => fnd_api.g_false,
444: P_COMMIT => FND_API.G_FALSE,
445: P_ROLE_RELATE_ID => l_role_relate_id,
446: P_START_DATE_ACTIVE => l_start_date_active,
447: P_END_DATE_ACTIVE => l_end_date_active,
448: P_OBJECT_VERSION_NUM => l_object_version_number,

Line 459: P_INIT_MSG_LIST => FND_API.G_FALSE,

455:
456: /* Update Resource Group.*/
457: JTF_RS_GROUPS_PUB.UPDATE_RESOURCE_GROUP(
458: P_API_VERSION => 1,
459: P_INIT_MSG_LIST => FND_API.G_FALSE,
460: P_COMMIT => FND_API.G_FALSE,
461: P_GROUP_ID => l_group_id,
462: P_GROUP_NUMBER => l_group_number,
463: P_GROUP_NAME => l_group_name,

Line 460: P_COMMIT => FND_API.G_FALSE,

456: /* Update Resource Group.*/
457: JTF_RS_GROUPS_PUB.UPDATE_RESOURCE_GROUP(
458: P_API_VERSION => 1,
459: P_INIT_MSG_LIST => FND_API.G_FALSE,
460: P_COMMIT => FND_API.G_FALSE,
461: P_GROUP_ID => l_group_id,
462: P_GROUP_NUMBER => l_group_number,
463: P_GROUP_NAME => l_group_name,
464: P_GROUP_DESC => l_group_desc,

Line 488: P_INIT_MSG_LIST =>FND_API.G_FALSE,

484: /* Delete existing members in the group who should not be part of this user group. Reason : because of change in the user group query */
485: For l_del_mem_rec IN l_del_mem_csr(l_group_id) Loop
486: JTF_RS_GROUP_MEMBERS_PUB.delete_resource_group_members
487: (P_API_VERSION => 1,
488: P_INIT_MSG_LIST =>FND_API.G_FALSE,
489: P_COMMIT =>FND_API.G_FALSE,
490: P_GROUP_ID =>l_upd_rec.group_id ,
491: P_GROUP_NUMBER => l_upd_rec.group_number,
492: P_RESOURCE_ID => l_del_mem_rec.resource_id,

Line 489: P_COMMIT =>FND_API.G_FALSE,

485: For l_del_mem_rec IN l_del_mem_csr(l_group_id) Loop
486: JTF_RS_GROUP_MEMBERS_PUB.delete_resource_group_members
487: (P_API_VERSION => 1,
488: P_INIT_MSG_LIST =>FND_API.G_FALSE,
489: P_COMMIT =>FND_API.G_FALSE,
490: P_GROUP_ID =>l_upd_rec.group_id ,
491: P_GROUP_NUMBER => l_upd_rec.group_number,
492: P_RESOURCE_ID => l_del_mem_rec.resource_id,
493: P_RESOURCE_NUMBER => l_del_mem_rec.resource_number,

Line 550: P_INIT_MSG_LIST => FND_API.G_FALSE,

546: end if;
547:
548: JTF_RS_RESOURCE_PUB.CREATE_RESOURCE(
549: P_API_VERSION => 1.0,
550: P_INIT_MSG_LIST => FND_API.G_FALSE,
551: P_COMMIT => FND_API.G_FALSE,
552: P_CATEGORY => l_cre_res_rec.category,
553: P_SOURCE_ID => l_cre_res_rec.source_id,
554: P_SOURCE_NAME => l_source_name,

Line 551: P_COMMIT => FND_API.G_FALSE,

547:
548: JTF_RS_RESOURCE_PUB.CREATE_RESOURCE(
549: P_API_VERSION => 1.0,
550: P_INIT_MSG_LIST => FND_API.G_FALSE,
551: P_COMMIT => FND_API.G_FALSE,
552: P_CATEGORY => l_cre_res_rec.category,
553: P_SOURCE_ID => l_cre_res_rec.source_id,
554: P_SOURCE_NAME => l_source_name,
555: P_START_DATE_ACTIVE => l_res_start_date_active,

Line 562: If (l_return_status <> fnd_api.g_ret_sts_success) Then

558: X_MSG_DATA => l_msg_data,
559: X_RESOURCE_ID => l_resource_id,
560: X_RESOURCE_NUMBER => l_resource_number
561: );
562: If (l_return_status <> fnd_api.g_ret_sts_success) Then
563: Status_Log_Message('Return status of JTF_RS_RESOURCE_PUB.create_resource api ' ||
564: ' l_cre_res_rec.category = ' || l_cre_res_rec.category ||
565: ' l_source_name = ' || l_source_name ||
566: ' l_res_start_date_active = ' || l_res_start_date_active ||

Line 620: P_INIT_MSG_LIST => FND_API.G_FALSE,

616:
617: /* create news members in the group who are not part of this user group. Reason : because of change in the user group query */
618: For l_cre_rec IN l_cre_csr(l_group_id) Loop
619: JTF_RS_GROUP_MEMBERS_PUB.create_resource_group_members(P_API_VERSION => 1.0,
620: P_INIT_MSG_LIST => FND_API.G_FALSE,
621: P_COMMIT => FND_API.G_FALSE,
622: P_GROUP_ID => l_group_id,
623: P_GROUP_NUMBER => l_group_number,
624: P_RESOURCE_ID => l_cre_rec.resource_id,

Line 621: P_COMMIT => FND_API.G_FALSE,

617: /* create news members in the group who are not part of this user group. Reason : because of change in the user group query */
618: For l_cre_rec IN l_cre_csr(l_group_id) Loop
619: JTF_RS_GROUP_MEMBERS_PUB.create_resource_group_members(P_API_VERSION => 1.0,
620: P_INIT_MSG_LIST => FND_API.G_FALSE,
621: P_COMMIT => FND_API.G_FALSE,
622: P_GROUP_ID => l_group_id,
623: P_GROUP_NUMBER => l_group_number,
624: P_RESOURCE_ID => l_cre_rec.resource_id,
625: P_RESOURCE_NUMBER => l_cre_rec.resource_number,

Line 631: If (l_return_status <> fnd_api.g_ret_sts_success) Then

627: X_MSG_COUNT => l_msg_count,
628: X_MSG_DATA => l_msg_data,
629: X_GROUP_MEMBER_ID => l_group_member_id
630: );
631: If (l_return_status <> fnd_api.g_ret_sts_success) Then
632: Status_Log_Message('Return status of JTF_RS_GROUP_MEMBERS_PUB.create_resource_group_members api ' ||
633: ' l_cre_rec.resource_id = ' || to_char(l_cre_rec.resource_id) || ' ',
634: l_return_status , l_msg_count , l_msg_data );
635: End If;

Line 746: P_INIT_MSG_LIST => FND_API.G_FALSE,

742: Log_Message( '%%%Start Create Processing for Group Name = ' || l_cre_rec.static_group_name || '%%%');
743: /* Call the Resource Group API, to create the group and it's members */
744: jtf_rs_groups_pub.create_resource_group
745: (P_API_VERSION => 1.0,
746: P_INIT_MSG_LIST => FND_API.G_FALSE,
747: P_COMMIT => FND_API.G_FALSE,
748: P_GROUP_NAME => l_cre_rec.static_group_name,
749: P_GROUP_DESC => l_cre_rec.group_desc,
750: P_EXCLUSIVE_FLAG => l_exclusive_flag, --'N'

Line 747: P_COMMIT => FND_API.G_FALSE,

743: /* Call the Resource Group API, to create the group and it's members */
744: jtf_rs_groups_pub.create_resource_group
745: (P_API_VERSION => 1.0,
746: P_INIT_MSG_LIST => FND_API.G_FALSE,
747: P_COMMIT => FND_API.G_FALSE,
748: P_GROUP_NAME => l_cre_rec.static_group_name,
749: P_GROUP_DESC => l_cre_rec.group_desc,
750: P_EXCLUSIVE_FLAG => l_exclusive_flag, --'N'
751: P_START_DATE_ACTIVE => l_cre_rec.start_date_active,

Line 764: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

760: Status_Log_Message('Return status of jtf_rs_groups_pub.create_resource_group api ' ||
761: ' l_cre_rec.static_group_name = ' || l_cre_rec.static_group_name ||
762: ' ; l_group_id = ' || to_char(l_group_id) || ' ',
763: l_return_status , l_msg_count , l_msg_data );
764: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
765: raise createResGrpExp;
766: End If;
767:
768: /* for MES channel_rec, to pass a valid resource_id for owner id.

Line 775: l_channel_rec.CHANNEL_ID := FND_API.G_MISS_NUM;

771: -- get the sysadmin's resource_id, resource_number
772: get_curr_usr_resouce_info(l_creby_resource_id, l_creby_resource_number);
773:
774: /* Call the MES Channel API to Create a Channel for the Group */
775: l_channel_rec.CHANNEL_ID := FND_API.G_MISS_NUM;
776: l_channel_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
777: l_channel_rec.CHANNEL_NAME := FND_API.G_MISS_CHAR;
778: l_channel_rec.DESCRIPTION := FND_API.G_MISS_CHAR;
779: l_channel_rec.CHANNEL_TYPE := 'GROUP';

Line 776: l_channel_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;

772: get_curr_usr_resouce_info(l_creby_resource_id, l_creby_resource_number);
773:
774: /* Call the MES Channel API to Create a Channel for the Group */
775: l_channel_rec.CHANNEL_ID := FND_API.G_MISS_NUM;
776: l_channel_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
777: l_channel_rec.CHANNEL_NAME := FND_API.G_MISS_CHAR;
778: l_channel_rec.DESCRIPTION := FND_API.G_MISS_CHAR;
779: l_channel_rec.CHANNEL_TYPE := 'GROUP';
780: l_channel_rec.CHANNEL_CATEGORY_ID := FND_API.G_MISS_NUM;

Line 777: l_channel_rec.CHANNEL_NAME := FND_API.G_MISS_CHAR;

773:
774: /* Call the MES Channel API to Create a Channel for the Group */
775: l_channel_rec.CHANNEL_ID := FND_API.G_MISS_NUM;
776: l_channel_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
777: l_channel_rec.CHANNEL_NAME := FND_API.G_MISS_CHAR;
778: l_channel_rec.DESCRIPTION := FND_API.G_MISS_CHAR;
779: l_channel_rec.CHANNEL_TYPE := 'GROUP';
780: l_channel_rec.CHANNEL_CATEGORY_ID := FND_API.G_MISS_NUM;
781: l_channel_rec.STATUS := FND_API.G_MISS_CHAR;

Line 778: l_channel_rec.DESCRIPTION := FND_API.G_MISS_CHAR;

774: /* Call the MES Channel API to Create a Channel for the Group */
775: l_channel_rec.CHANNEL_ID := FND_API.G_MISS_NUM;
776: l_channel_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
777: l_channel_rec.CHANNEL_NAME := FND_API.G_MISS_CHAR;
778: l_channel_rec.DESCRIPTION := FND_API.G_MISS_CHAR;
779: l_channel_rec.CHANNEL_TYPE := 'GROUP';
780: l_channel_rec.CHANNEL_CATEGORY_ID := FND_API.G_MISS_NUM;
781: l_channel_rec.STATUS := FND_API.G_MISS_CHAR;
782: l_channel_rec.OWNER_USER_ID := l_creby_resource_id;

Line 780: l_channel_rec.CHANNEL_CATEGORY_ID := FND_API.G_MISS_NUM;

776: l_channel_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
777: l_channel_rec.CHANNEL_NAME := FND_API.G_MISS_CHAR;
778: l_channel_rec.DESCRIPTION := FND_API.G_MISS_CHAR;
779: l_channel_rec.CHANNEL_TYPE := 'GROUP';
780: l_channel_rec.CHANNEL_CATEGORY_ID := FND_API.G_MISS_NUM;
781: l_channel_rec.STATUS := FND_API.G_MISS_CHAR;
782: l_channel_rec.OWNER_USER_ID := l_creby_resource_id;
783: l_channel_rec.DEFAULT_APPROVER_USER_ID:=l_creby_resource_id;
784: l_channel_rec.EFFECTIVE_START_DATE := FND_API.G_MISS_DATE;

Line 781: l_channel_rec.STATUS := FND_API.G_MISS_CHAR;

777: l_channel_rec.CHANNEL_NAME := FND_API.G_MISS_CHAR;
778: l_channel_rec.DESCRIPTION := FND_API.G_MISS_CHAR;
779: l_channel_rec.CHANNEL_TYPE := 'GROUP';
780: l_channel_rec.CHANNEL_CATEGORY_ID := FND_API.G_MISS_NUM;
781: l_channel_rec.STATUS := FND_API.G_MISS_CHAR;
782: l_channel_rec.OWNER_USER_ID := l_creby_resource_id;
783: l_channel_rec.DEFAULT_APPROVER_USER_ID:=l_creby_resource_id;
784: l_channel_rec.EFFECTIVE_START_DATE := FND_API.G_MISS_DATE;
785: l_channel_rec.EXPIRATION_DATE := FND_API.G_MISS_DATE;

Line 784: l_channel_rec.EFFECTIVE_START_DATE := FND_API.G_MISS_DATE;

780: l_channel_rec.CHANNEL_CATEGORY_ID := FND_API.G_MISS_NUM;
781: l_channel_rec.STATUS := FND_API.G_MISS_CHAR;
782: l_channel_rec.OWNER_USER_ID := l_creby_resource_id;
783: l_channel_rec.DEFAULT_APPROVER_USER_ID:=l_creby_resource_id;
784: l_channel_rec.EFFECTIVE_START_DATE := FND_API.G_MISS_DATE;
785: l_channel_rec.EXPIRATION_DATE := FND_API.G_MISS_DATE;
786: l_channel_rec.ACCESS_LEVEL_TYPE := 'PUBLIC';
787: l_channel_rec.PUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
788: l_channel_rec.SUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;

Line 785: l_channel_rec.EXPIRATION_DATE := FND_API.G_MISS_DATE;

781: l_channel_rec.STATUS := FND_API.G_MISS_CHAR;
782: l_channel_rec.OWNER_USER_ID := l_creby_resource_id;
783: l_channel_rec.DEFAULT_APPROVER_USER_ID:=l_creby_resource_id;
784: l_channel_rec.EFFECTIVE_START_DATE := FND_API.G_MISS_DATE;
785: l_channel_rec.EXPIRATION_DATE := FND_API.G_MISS_DATE;
786: l_channel_rec.ACCESS_LEVEL_TYPE := 'PUBLIC';
787: l_channel_rec.PUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
788: l_channel_rec.SUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
789: l_channel_rec.MATCH_ON_ALL_CRITERIA_FLAG := FND_API.G_FALSE;

Line 787: l_channel_rec.PUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;

783: l_channel_rec.DEFAULT_APPROVER_USER_ID:=l_creby_resource_id;
784: l_channel_rec.EFFECTIVE_START_DATE := FND_API.G_MISS_DATE;
785: l_channel_rec.EXPIRATION_DATE := FND_API.G_MISS_DATE;
786: l_channel_rec.ACCESS_LEVEL_TYPE := 'PUBLIC';
787: l_channel_rec.PUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
788: l_channel_rec.SUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
789: l_channel_rec.MATCH_ON_ALL_CRITERIA_FLAG := FND_API.G_FALSE;
790: l_channel_rec.MATCH_ON_KEYWORD_FLAG := FND_API.G_FALSE;
791: l_channel_rec.MATCH_ON_AUTHOR_FLAG := FND_API.G_FALSE;

Line 788: l_channel_rec.SUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;

784: l_channel_rec.EFFECTIVE_START_DATE := FND_API.G_MISS_DATE;
785: l_channel_rec.EXPIRATION_DATE := FND_API.G_MISS_DATE;
786: l_channel_rec.ACCESS_LEVEL_TYPE := 'PUBLIC';
787: l_channel_rec.PUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
788: l_channel_rec.SUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
789: l_channel_rec.MATCH_ON_ALL_CRITERIA_FLAG := FND_API.G_FALSE;
790: l_channel_rec.MATCH_ON_KEYWORD_FLAG := FND_API.G_FALSE;
791: l_channel_rec.MATCH_ON_AUTHOR_FLAG := FND_API.G_FALSE;
792: l_channel_rec.MATCH_ON_PERSPECTIVE_FLAG := FND_API.G_FALSE;

Line 789: l_channel_rec.MATCH_ON_ALL_CRITERIA_FLAG := FND_API.G_FALSE;

785: l_channel_rec.EXPIRATION_DATE := FND_API.G_MISS_DATE;
786: l_channel_rec.ACCESS_LEVEL_TYPE := 'PUBLIC';
787: l_channel_rec.PUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
788: l_channel_rec.SUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
789: l_channel_rec.MATCH_ON_ALL_CRITERIA_FLAG := FND_API.G_FALSE;
790: l_channel_rec.MATCH_ON_KEYWORD_FLAG := FND_API.G_FALSE;
791: l_channel_rec.MATCH_ON_AUTHOR_FLAG := FND_API.G_FALSE;
792: l_channel_rec.MATCH_ON_PERSPECTIVE_FLAG := FND_API.G_FALSE;
793: l_channel_rec.MATCH_ON_ITEM_TYPE_FLAG := FND_API.G_FALSE;

Line 790: l_channel_rec.MATCH_ON_KEYWORD_FLAG := FND_API.G_FALSE;

786: l_channel_rec.ACCESS_LEVEL_TYPE := 'PUBLIC';
787: l_channel_rec.PUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
788: l_channel_rec.SUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
789: l_channel_rec.MATCH_ON_ALL_CRITERIA_FLAG := FND_API.G_FALSE;
790: l_channel_rec.MATCH_ON_KEYWORD_FLAG := FND_API.G_FALSE;
791: l_channel_rec.MATCH_ON_AUTHOR_FLAG := FND_API.G_FALSE;
792: l_channel_rec.MATCH_ON_PERSPECTIVE_FLAG := FND_API.G_FALSE;
793: l_channel_rec.MATCH_ON_ITEM_TYPE_FLAG := FND_API.G_FALSE;
794: l_channel_rec.MATCH_ON_CONTENT_TYPE_FLAG := FND_API.G_FALSE;

Line 791: l_channel_rec.MATCH_ON_AUTHOR_FLAG := FND_API.G_FALSE;

787: l_channel_rec.PUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
788: l_channel_rec.SUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
789: l_channel_rec.MATCH_ON_ALL_CRITERIA_FLAG := FND_API.G_FALSE;
790: l_channel_rec.MATCH_ON_KEYWORD_FLAG := FND_API.G_FALSE;
791: l_channel_rec.MATCH_ON_AUTHOR_FLAG := FND_API.G_FALSE;
792: l_channel_rec.MATCH_ON_PERSPECTIVE_FLAG := FND_API.G_FALSE;
793: l_channel_rec.MATCH_ON_ITEM_TYPE_FLAG := FND_API.G_FALSE;
794: l_channel_rec.MATCH_ON_CONTENT_TYPE_FLAG := FND_API.G_FALSE;
795: l_channel_rec.MATCH_ON_TIME_FLAG := FND_API.G_FALSE;

Line 792: l_channel_rec.MATCH_ON_PERSPECTIVE_FLAG := FND_API.G_FALSE;

788: l_channel_rec.SUB_NEED_APPROVAL_FLAG := FND_API.G_FALSE;
789: l_channel_rec.MATCH_ON_ALL_CRITERIA_FLAG := FND_API.G_FALSE;
790: l_channel_rec.MATCH_ON_KEYWORD_FLAG := FND_API.G_FALSE;
791: l_channel_rec.MATCH_ON_AUTHOR_FLAG := FND_API.G_FALSE;
792: l_channel_rec.MATCH_ON_PERSPECTIVE_FLAG := FND_API.G_FALSE;
793: l_channel_rec.MATCH_ON_ITEM_TYPE_FLAG := FND_API.G_FALSE;
794: l_channel_rec.MATCH_ON_CONTENT_TYPE_FLAG := FND_API.G_FALSE;
795: l_channel_rec.MATCH_ON_TIME_FLAG := FND_API.G_FALSE;
796: l_channel_rec.APPLICATION_ID := 170;

Line 793: l_channel_rec.MATCH_ON_ITEM_TYPE_FLAG := FND_API.G_FALSE;

789: l_channel_rec.MATCH_ON_ALL_CRITERIA_FLAG := FND_API.G_FALSE;
790: l_channel_rec.MATCH_ON_KEYWORD_FLAG := FND_API.G_FALSE;
791: l_channel_rec.MATCH_ON_AUTHOR_FLAG := FND_API.G_FALSE;
792: l_channel_rec.MATCH_ON_PERSPECTIVE_FLAG := FND_API.G_FALSE;
793: l_channel_rec.MATCH_ON_ITEM_TYPE_FLAG := FND_API.G_FALSE;
794: l_channel_rec.MATCH_ON_CONTENT_TYPE_FLAG := FND_API.G_FALSE;
795: l_channel_rec.MATCH_ON_TIME_FLAG := FND_API.G_FALSE;
796: l_channel_rec.APPLICATION_ID := 170;
797: l_channel_rec.EXTERNAL_ACCESS_FLAG := FND_API.G_FALSE;

Line 794: l_channel_rec.MATCH_ON_CONTENT_TYPE_FLAG := FND_API.G_FALSE;

790: l_channel_rec.MATCH_ON_KEYWORD_FLAG := FND_API.G_FALSE;
791: l_channel_rec.MATCH_ON_AUTHOR_FLAG := FND_API.G_FALSE;
792: l_channel_rec.MATCH_ON_PERSPECTIVE_FLAG := FND_API.G_FALSE;
793: l_channel_rec.MATCH_ON_ITEM_TYPE_FLAG := FND_API.G_FALSE;
794: l_channel_rec.MATCH_ON_CONTENT_TYPE_FLAG := FND_API.G_FALSE;
795: l_channel_rec.MATCH_ON_TIME_FLAG := FND_API.G_FALSE;
796: l_channel_rec.APPLICATION_ID := 170;
797: l_channel_rec.EXTERNAL_ACCESS_FLAG := FND_API.G_FALSE;
798: l_channel_rec.ITEM_MATCH_COUNT := 0;

Line 795: l_channel_rec.MATCH_ON_TIME_FLAG := FND_API.G_FALSE;

791: l_channel_rec.MATCH_ON_AUTHOR_FLAG := FND_API.G_FALSE;
792: l_channel_rec.MATCH_ON_PERSPECTIVE_FLAG := FND_API.G_FALSE;
793: l_channel_rec.MATCH_ON_ITEM_TYPE_FLAG := FND_API.G_FALSE;
794: l_channel_rec.MATCH_ON_CONTENT_TYPE_FLAG := FND_API.G_FALSE;
795: l_channel_rec.MATCH_ON_TIME_FLAG := FND_API.G_FALSE;
796: l_channel_rec.APPLICATION_ID := 170;
797: l_channel_rec.EXTERNAL_ACCESS_FLAG := FND_API.G_FALSE;
798: l_channel_rec.ITEM_MATCH_COUNT := 0;
799: l_channel_rec.LAST_MATCH_TIME := null;

Line 797: l_channel_rec.EXTERNAL_ACCESS_FLAG := FND_API.G_FALSE;

793: l_channel_rec.MATCH_ON_ITEM_TYPE_FLAG := FND_API.G_FALSE;
794: l_channel_rec.MATCH_ON_CONTENT_TYPE_FLAG := FND_API.G_FALSE;
795: l_channel_rec.MATCH_ON_TIME_FLAG := FND_API.G_FALSE;
796: l_channel_rec.APPLICATION_ID := 170;
797: l_channel_rec.EXTERNAL_ACCESS_FLAG := FND_API.G_FALSE;
798: l_channel_rec.ITEM_MATCH_COUNT := 0;
799: l_channel_rec.LAST_MATCH_TIME := null;
800: l_channel_rec.NOTIFICATION_INTERVAL_TYPE := null;
801: l_channel_rec.LAST_NOTIFICATION_TIME := null;

Line 820: P_INIT_MSG_LIST => FND_API.G_FALSE,

816: l_channel_rec.ATTRIBUTE14 := null;
817: l_channel_rec.ATTRIBUTE15 := null;
818:
819: AMV_CHANNEL_GRP.ADD_GROUPCHANNEL ( P_API_VERSION => 1.0,
820: P_INIT_MSG_LIST => FND_API.G_FALSE,
821: P_COMMIT => FND_API.G_FALSE,
822: P_CHECK_LOGIN_USER => fnd_api.g_false,
823: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
824: P_GROUP_ID => l_group_id,

Line 821: P_COMMIT => FND_API.G_FALSE,

817: l_channel_rec.ATTRIBUTE15 := null;
818:
819: AMV_CHANNEL_GRP.ADD_GROUPCHANNEL ( P_API_VERSION => 1.0,
820: P_INIT_MSG_LIST => FND_API.G_FALSE,
821: P_COMMIT => FND_API.G_FALSE,
822: P_CHECK_LOGIN_USER => fnd_api.g_false,
823: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
824: P_GROUP_ID => l_group_id,
825: P_CHANNEL_RECORD => l_channel_rec,

Line 822: P_CHECK_LOGIN_USER => fnd_api.g_false,

818:
819: AMV_CHANNEL_GRP.ADD_GROUPCHANNEL ( P_API_VERSION => 1.0,
820: P_INIT_MSG_LIST => FND_API.G_FALSE,
821: P_COMMIT => FND_API.G_FALSE,
822: P_CHECK_LOGIN_USER => fnd_api.g_false,
823: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
824: P_GROUP_ID => l_group_id,
825: P_CHANNEL_RECORD => l_channel_rec,
826: X_RETURN_STATUS => l_return_status,

Line 823: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

819: AMV_CHANNEL_GRP.ADD_GROUPCHANNEL ( P_API_VERSION => 1.0,
820: P_INIT_MSG_LIST => FND_API.G_FALSE,
821: P_COMMIT => FND_API.G_FALSE,
822: P_CHECK_LOGIN_USER => fnd_api.g_false,
823: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
824: P_GROUP_ID => l_group_id,
825: P_CHANNEL_RECORD => l_channel_rec,
826: X_RETURN_STATUS => l_return_status,
827: X_MSG_COUNT => l_msg_count,

Line 839: P_INIT_MSG_LIST => fnd_api.g_false,

835:
836: /* Call the resource roles API to create a role relationship for the group. */
837: jtf_rs_role_relate_pub.create_resource_role_relate
838: (P_API_VERSION => 1,
839: P_INIT_MSG_LIST => fnd_api.g_false,
840: P_COMMIT => fnd_api.g_false,
841: P_ROLE_RESOURCE_TYPE => 'RS_GROUP',
842: P_ROLE_RESOURCE_ID => l_group_id,
843: P_ROLE_ID => NULL,

Line 840: P_COMMIT => fnd_api.g_false,

836: /* Call the resource roles API to create a role relationship for the group. */
837: jtf_rs_role_relate_pub.create_resource_role_relate
838: (P_API_VERSION => 1,
839: P_INIT_MSG_LIST => fnd_api.g_false,
840: P_COMMIT => fnd_api.g_false,
841: P_ROLE_RESOURCE_TYPE => 'RS_GROUP',
842: P_ROLE_RESOURCE_ID => l_group_id,
843: P_ROLE_ID => NULL,
844: P_ROLE_CODE => l_role_code, --'IBUUG'

Line 860: P_INIT_MSG_LIST => FND_API.G_FALSE,

856:
857: /* Call the Usage API to create a relationship between the usage and Group */
858: jtf_rs_group_usages_pub.create_group_usage
859: (P_API_VERSION => 1,
860: P_INIT_MSG_LIST => FND_API.G_FALSE,
861: P_COMMIT => FND_API.G_FALSE,
862: P_GROUP_ID => l_group_id,
863: P_GROUP_NUMBER => l_group_number,
864: P_USAGE => l_usage,

Line 861: P_COMMIT => FND_API.G_FALSE,

857: /* Call the Usage API to create a relationship between the usage and Group */
858: jtf_rs_group_usages_pub.create_group_usage
859: (P_API_VERSION => 1,
860: P_INIT_MSG_LIST => FND_API.G_FALSE,
861: P_COMMIT => FND_API.G_FALSE,
862: P_GROUP_ID => l_group_id,
863: P_GROUP_NUMBER => l_group_number,
864: P_USAGE => l_usage,
865: X_RETURN_STATUS => l_return_status,

Line 928: P_INIT_MSG_LIST => FND_API.G_FALSE,

924:
925: -- create a resource
926: JTF_RS_RESOURCE_PUB.CREATE_RESOURCE(
927: P_API_VERSION => 1.0,
928: P_INIT_MSG_LIST => FND_API.G_FALSE,
929: P_COMMIT => FND_API.G_FALSE,
930: P_CATEGORY => l_cre_mem_rec.category,
931: P_SOURCE_ID => l_cre_mem_rec.source_id,
932: P_SOURCE_NAME => l_source_name,

Line 929: P_COMMIT => FND_API.G_FALSE,

925: -- create a resource
926: JTF_RS_RESOURCE_PUB.CREATE_RESOURCE(
927: P_API_VERSION => 1.0,
928: P_INIT_MSG_LIST => FND_API.G_FALSE,
929: P_COMMIT => FND_API.G_FALSE,
930: P_CATEGORY => l_cre_mem_rec.category,
931: P_SOURCE_ID => l_cre_mem_rec.source_id,
932: P_SOURCE_NAME => l_source_name,
933: P_START_DATE_ACTIVE => l_res_start_date_active,

Line 940: If (l_return_status <> fnd_api.g_ret_sts_success) Then

936: X_MSG_DATA => l_msg_data,
937: X_RESOURCE_ID => l_resource_id,
938: X_RESOURCE_NUMBER => l_resource_number
939: );
940: If (l_return_status <> fnd_api.g_ret_sts_success) Then
941: Status_Log_Message('Return status of JTF_RS_RESOURCE_PUB.create_resource api ' ||
942: ' l_cre_mem_rec.category = ' || l_cre_mem_rec.category ||
943: ' l_source_name = ' || l_source_name ||
944: ' l_res_start_date_active = ' || l_res_start_date_active ||

Line 1017: P_INIT_MSG_LIST => FND_API.G_FALSE,

1013: If l_resource_id <> 0 Then
1014: /* resource already exists and it is active. So, call create group members api */
1015: jtf_rs_group_members_pub.create_resource_group_members
1016: (P_API_VERSION => 1.0,
1017: P_INIT_MSG_LIST => FND_API.G_FALSE,
1018: P_COMMIT => FND_API.G_FALSE,
1019: P_GROUP_ID => l_group_id,
1020: P_GROUP_NUMBER => l_group_number,
1021: P_RESOURCE_ID => l_resource_id,

Line 1018: P_COMMIT => FND_API.G_FALSE,

1014: /* resource already exists and it is active. So, call create group members api */
1015: jtf_rs_group_members_pub.create_resource_group_members
1016: (P_API_VERSION => 1.0,
1017: P_INIT_MSG_LIST => FND_API.G_FALSE,
1018: P_COMMIT => FND_API.G_FALSE,
1019: P_GROUP_ID => l_group_id,
1020: P_GROUP_NUMBER => l_group_number,
1021: P_RESOURCE_ID => l_resource_id,
1022: P_RESOURCE_NUMBER => l_resource_number,

Line 1028: If (l_return_status <> fnd_api.g_ret_sts_success) Then

1024: X_MSG_COUNT => l_msg_count,
1025: X_MSG_DATA => l_msg_data,
1026: X_GROUP_MEMBER_ID => l_group_member_id
1027: );
1028: If (l_return_status <> fnd_api.g_ret_sts_success) Then
1029: select count(*) into l_temp_cnt
1030: from jtf_rs_group_members
1031: Where group_id = l_group_id
1032: and resource_id = l_resource_id

Line 1129: P_INIT_MSG_LIST => FND_API.G_FALSE,

1125:
1126: /* call the delete channel api of MES */
1127: For l_del_chnl_rec IN l_del_chnl_csr(l_del_rec.static_group_name) Loop
1128: AMV_CHANNEL_GRP.DELETE_CHANNEL( P_API_VERSION => 1.0,
1129: P_INIT_MSG_LIST => FND_API.G_FALSE,
1130: P_COMMIT => FND_API.G_FALSE,
1131: P_VALIDATION_LEVEL =>FND_API.G_VALID_LEVEL_FULL,
1132: P_CHECK_LOGIN_USER =>FND_API.G_FALSE,
1133: P_CHANNEL_ID => l_del_chnl_rec.channel_id,

Line 1130: P_COMMIT => FND_API.G_FALSE,

1126: /* call the delete channel api of MES */
1127: For l_del_chnl_rec IN l_del_chnl_csr(l_del_rec.static_group_name) Loop
1128: AMV_CHANNEL_GRP.DELETE_CHANNEL( P_API_VERSION => 1.0,
1129: P_INIT_MSG_LIST => FND_API.G_FALSE,
1130: P_COMMIT => FND_API.G_FALSE,
1131: P_VALIDATION_LEVEL =>FND_API.G_VALID_LEVEL_FULL,
1132: P_CHECK_LOGIN_USER =>FND_API.G_FALSE,
1133: P_CHANNEL_ID => l_del_chnl_rec.channel_id,
1134: X_RETURN_STATUS => l_return_status,

Line 1131: P_VALIDATION_LEVEL =>FND_API.G_VALID_LEVEL_FULL,

1127: For l_del_chnl_rec IN l_del_chnl_csr(l_del_rec.static_group_name) Loop
1128: AMV_CHANNEL_GRP.DELETE_CHANNEL( P_API_VERSION => 1.0,
1129: P_INIT_MSG_LIST => FND_API.G_FALSE,
1130: P_COMMIT => FND_API.G_FALSE,
1131: P_VALIDATION_LEVEL =>FND_API.G_VALID_LEVEL_FULL,
1132: P_CHECK_LOGIN_USER =>FND_API.G_FALSE,
1133: P_CHANNEL_ID => l_del_chnl_rec.channel_id,
1134: X_RETURN_STATUS => l_return_status,
1135: X_MSG_COUNT => l_msg_count,

Line 1132: P_CHECK_LOGIN_USER =>FND_API.G_FALSE,

1128: AMV_CHANNEL_GRP.DELETE_CHANNEL( P_API_VERSION => 1.0,
1129: P_INIT_MSG_LIST => FND_API.G_FALSE,
1130: P_COMMIT => FND_API.G_FALSE,
1131: P_VALIDATION_LEVEL =>FND_API.G_VALID_LEVEL_FULL,
1132: P_CHECK_LOGIN_USER =>FND_API.G_FALSE,
1133: P_CHANNEL_ID => l_del_chnl_rec.channel_id,
1134: X_RETURN_STATUS => l_return_status,
1135: X_MSG_COUNT => l_msg_count,
1136: X_MSG_DATA =>l_msg_data

Line 1159: P_INIT_MSG_LIST => fnd_api.g_false,

1155: raise;
1156: End;
1157: If l_role_relate_id <> 0 then
1158: jtf_rs_role_relate_pub.UPDATE_RESOURCE_ROLE_RELATE( P_API_VERSION => 1.0,
1159: P_INIT_MSG_LIST => fnd_api.g_false,
1160: P_COMMIT => FND_API.G_FALSE,
1161: P_ROLE_RELATE_ID => l_role_relate_id,
1162: P_START_DATE_ACTIVE => l_del_rec.start_date_active,
1163: P_END_DATE_ACTIVE => l_del_rec.end_date_active,

Line 1160: P_COMMIT => FND_API.G_FALSE,

1156: End;
1157: If l_role_relate_id <> 0 then
1158: jtf_rs_role_relate_pub.UPDATE_RESOURCE_ROLE_RELATE( P_API_VERSION => 1.0,
1159: P_INIT_MSG_LIST => fnd_api.g_false,
1160: P_COMMIT => FND_API.G_FALSE,
1161: P_ROLE_RELATE_ID => l_role_relate_id,
1162: P_START_DATE_ACTIVE => l_del_rec.start_date_active,
1163: P_END_DATE_ACTIVE => l_del_rec.end_date_active,
1164: P_OBJECT_VERSION_NUM => l_object_version_number,

Line 1176: P_INIT_MSG_LIST => fnd_api.g_false,

1172:
1173: /* call update resource group */
1174: jtf_rs_groups_pub.update_resource_group
1175: (P_API_VERSION => 1,
1176: P_INIT_MSG_LIST => fnd_api.g_false,
1177: P_COMMIT => FND_API.G_FALSE,
1178: P_GROUP_ID => l_del_rec.static_group_id,
1179: P_GROUP_NUMBER => l_del_rec.static_group_number,
1180: P_GROUP_NAME => l_del_rec.static_group_name,

Line 1177: P_COMMIT => FND_API.G_FALSE,

1173: /* call update resource group */
1174: jtf_rs_groups_pub.update_resource_group
1175: (P_API_VERSION => 1,
1176: P_INIT_MSG_LIST => fnd_api.g_false,
1177: P_COMMIT => FND_API.G_FALSE,
1178: P_GROUP_ID => l_del_rec.static_group_id,
1179: P_GROUP_NUMBER => l_del_rec.static_group_number,
1180: P_GROUP_NAME => l_del_rec.static_group_name,
1181: P_GROUP_DESC => l_del_rec.group_desc,

Line 1199: P_INIT_MSG_LIST => FND_API.G_FALSE,

1195: get_category(l_del_rec.sql_text, l_category);
1196:
1197: For l_del_mem_rec IN l_del_mem_csr(l_del_rec.static_group_id) Loop
1198: jtf_rs_group_members_pub.delete_resource_group_members(P_API_VERSION => 1.0,
1199: P_INIT_MSG_LIST => FND_API.G_FALSE,
1200: P_COMMIT => FND_API.G_FALSE,
1201: P_GROUP_ID => l_del_mem_rec.group_id,
1202: P_GROUP_NUMBER => l_del_mem_rec.group_number,
1203: P_RESOURCE_ID => l_del_mem_rec.resource_id,

Line 1200: P_COMMIT => FND_API.G_FALSE,

1196:
1197: For l_del_mem_rec IN l_del_mem_csr(l_del_rec.static_group_id) Loop
1198: jtf_rs_group_members_pub.delete_resource_group_members(P_API_VERSION => 1.0,
1199: P_INIT_MSG_LIST => FND_API.G_FALSE,
1200: P_COMMIT => FND_API.G_FALSE,
1201: P_GROUP_ID => l_del_mem_rec.group_id,
1202: P_GROUP_NUMBER => l_del_mem_rec.group_number,
1203: P_RESOURCE_ID => l_del_mem_rec.resource_id,
1204: P_RESOURCE_NUMBER => l_del_mem_rec.resource_number,

Line 1210: If (l_return_status <> fnd_api.g_ret_sts_success) Then

1206: X_RETURN_STATUS => l_return_status,
1207: X_MSG_COUNT => l_msg_count,
1208: X_MSG_DATA => l_msg_data
1209: );
1210: If (l_return_status <> fnd_api.g_ret_sts_success) Then
1211: Status_Log_Message('Return status of JTF_RS_GROUP_MEMBERS_PUB.delete_resource_group_members api ' ||
1212: ' l_mem_id = ' || to_char(l_del_mem_rec.group_member_id) || ' ',
1213: l_return_status , l_msg_count , l_msg_data );
1214: End If;

Line 1360: P_INIT_MSG_LIST => FND_API.G_FALSE,

1356:
1357: -- Resource needs to be created for created_by
1358: JTF_RS_RESOURCE_PUB.CREATE_RESOURCE(
1359: P_API_VERSION => 1.0,
1360: P_INIT_MSG_LIST => FND_API.G_FALSE,
1361: P_COMMIT => FND_API.G_FALSE,
1362: P_CATEGORY => l_creby_category,
1363: P_SOURCE_ID => l_creby_source_id,
1364: P_SOURCE_NAME => l_source_name,

Line 1361: P_COMMIT => FND_API.G_FALSE,

1357: -- Resource needs to be created for created_by
1358: JTF_RS_RESOURCE_PUB.CREATE_RESOURCE(
1359: P_API_VERSION => 1.0,
1360: P_INIT_MSG_LIST => FND_API.G_FALSE,
1361: P_COMMIT => FND_API.G_FALSE,
1362: P_CATEGORY => l_creby_category,
1363: P_SOURCE_ID => l_creby_source_id,
1364: P_SOURCE_NAME => l_source_name,
1365: P_START_DATE_ACTIVE => l_res_start_date_active,

Line 1430: P_INIT_MSG_LIST => fnd_api.g_false,

1426: /* MES Delete Channel API expects sysadmin to have MES_ADMIN, MES_SETUP_CHANNEL role_codes */
1427: Log_Message ('Assigning MES_ADMIN, MES_SETUP_CHANNEL roles to current login user. Ignore exceptions raised by these APIs');
1428: jtf_rs_role_relate_pub.create_resource_role_relate
1429: (P_API_VERSION => 1,
1430: P_INIT_MSG_LIST => fnd_api.g_false,
1431: P_COMMIT => fnd_api.g_false,
1432: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL',
1433: P_ROLE_RESOURCE_ID => x_resource_id,
1434: P_ROLE_ID => NULL,

Line 1431: P_COMMIT => fnd_api.g_false,

1427: Log_Message ('Assigning MES_ADMIN, MES_SETUP_CHANNEL roles to current login user. Ignore exceptions raised by these APIs');
1428: jtf_rs_role_relate_pub.create_resource_role_relate
1429: (P_API_VERSION => 1,
1430: P_INIT_MSG_LIST => fnd_api.g_false,
1431: P_COMMIT => fnd_api.g_false,
1432: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL',
1433: P_ROLE_RESOURCE_ID => x_resource_id,
1434: P_ROLE_ID => NULL,
1435: P_ROLE_CODE => 'MES_ADMIN',

Line 1446: P_INIT_MSG_LIST => fnd_api.g_false,

1442: Status_Log_Message('Return status of jtf_rs_role_relate_pub.create_resource_role_relate api MES_ADMIN',
1443: l_return_status , l_msg_count , l_msg_data );
1444: jtf_rs_role_relate_pub.create_resource_role_relate
1445: (P_API_VERSION => 1,
1446: P_INIT_MSG_LIST => fnd_api.g_false,
1447: P_COMMIT => fnd_api.g_false,
1448: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL',
1449: P_ROLE_RESOURCE_ID => x_resource_id,
1450: P_ROLE_ID => NULL,

Line 1447: P_COMMIT => fnd_api.g_false,

1443: l_return_status , l_msg_count , l_msg_data );
1444: jtf_rs_role_relate_pub.create_resource_role_relate
1445: (P_API_VERSION => 1,
1446: P_INIT_MSG_LIST => fnd_api.g_false,
1447: P_COMMIT => fnd_api.g_false,
1448: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL',
1449: P_ROLE_RESOURCE_ID => x_resource_id,
1450: P_ROLE_ID => NULL,
1451: P_ROLE_CODE => 'MES_SETUP_CHANNEL',