DBA Data[Home] [Help]

APPS.PV_PRGM_APPROVAL_PVT dependencies on FND_GLOBAL

Line 61: AND APPROVER_ID=DECODE( APPROVER_TYPE_CODE,'PERSON',apprid,'USER',FND_GLOBAL.USER_ID,null );

57: SELECT entity_approver_id, object_version_number,approval_status_code
58: FROM pv_ge_temp_approvers
59: WHERE APPR_FOR_ENTITY_ID =enrl_id
60: AND ARC_APPR_FOR_ENTITY_CODE='ENRQ'
61: AND APPROVER_ID=DECODE( APPROVER_TYPE_CODE,'PERSON',apprid,'USER',FND_GLOBAL.USER_ID,null );
62:
63:
64: BEGIN
65: OPEN temp_appr_csr( p_enrl_request_id,p_approver_id );

Line 907: || fnd_global.local_chr (10)

903: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
904:
905:
906: l_fyi_notification := SUBSTR(l_string
907: || fnd_global.local_chr (10)
908: || l_string1
909: || fnd_global.local_chr (10)
910: || l_string2,1,10000);
911: document := document

Line 909: || fnd_global.local_chr (10)

905:
906: l_fyi_notification := SUBSTR(l_string
907: || fnd_global.local_chr (10)
908: || l_string1
909: || fnd_global.local_chr (10)
910: || l_string2,1,10000);
911: document := document
912: || l_fyi_notification;
913: document_type := 'text/plain';

Line 1065: || fnd_global.local_chr (10)

1061: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1062:
1063: -- IF (display_type = 'text/plain') THEN
1064: l_appr_notification := SUBSTR(l_string
1065: || fnd_global.local_chr (10)
1066: || l_string1
1067: || fnd_global.local_chr (10)
1068: || l_string2,1,10000);
1069: document := document

Line 1067: || fnd_global.local_chr (10)

1063: -- IF (display_type = 'text/plain') THEN
1064: l_appr_notification := SUBSTR(l_string
1065: || fnd_global.local_chr (10)
1066: || l_string1
1067: || fnd_global.local_chr (10)
1068: || l_string2,1,10000);
1069: document := document
1070: || l_appr_notification;
1071: document_type := 'text/plain';

Line 1220: || fnd_global.local_chr (10)

1216:
1217: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1218:
1219: l_rej_notification := SUBSTR(l_string
1220: || fnd_global.local_chr (10)
1221: || l_string1
1222: || fnd_global.local_chr (10)
1223: || l_string2,1,10000);
1224: document := document

Line 1222: || fnd_global.local_chr (10)

1218:
1219: l_rej_notification := SUBSTR(l_string
1220: || fnd_global.local_chr (10)
1221: || l_string1
1222: || fnd_global.local_chr (10)
1223: || l_string2,1,10000);
1224: document := document
1225: || l_rej_notification;
1226: document_type := 'text/plain';

Line 1371: || fnd_global.local_chr (10)

1367: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1368:
1369:
1370: l_appreq_notification := l_string
1371: || fnd_global.local_chr (10)
1372: || l_string1
1373: || fnd_global.local_chr (10)
1374: || l_string2;
1375: document := document

Line 1373: || fnd_global.local_chr (10)

1369:
1370: l_appreq_notification := l_string
1371: || fnd_global.local_chr (10)
1372: || l_string1
1373: || fnd_global.local_chr (10)
1374: || l_string2;
1375: document := document
1376: || l_appreq_notification;
1377: document_type := 'text/plain';

Line 1519: || fnd_global.local_chr (10)

1515: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1516: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1517:
1518: l_apprem_notification := l_string
1519: || fnd_global.local_chr (10)
1520: || l_string1
1521: || fnd_global.local_chr (10)
1522: || l_string2;
1523: document := document

Line 1521: || fnd_global.local_chr (10)

1517:
1518: l_apprem_notification := l_string
1519: || fnd_global.local_chr (10)
1520: || l_string1
1521: || fnd_global.local_chr (10)
1522: || l_string2;
1523: document := document
1524: || l_apprem_notification;
1525: document_type := 'text/plain';

Line 3369: l_approverPersonId:= FND_GLOBAL.EMPLOYEE_ID;

3365: IF l_check_row_pa =true AND g_isApproverInList=true THEN
3366:
3367:
3368: -- update temp approvers with status approved
3369: l_approverPersonId:= FND_GLOBAL.EMPLOYEE_ID;
3370: l_approverUserId:= FND_GLOBAL.USER_ID;
3371:
3372: OPEN approver_dtl_cur(enrl_request_id,l_approverPersonId, l_approverUserId);
3373: FETCH approver_dtl_cur into l_rec_appr.object_version_number,

Line 3370: l_approverUserId:= FND_GLOBAL.USER_ID;

3366:
3367:
3368: -- update temp approvers with status approved
3369: l_approverPersonId:= FND_GLOBAL.EMPLOYEE_ID;
3370: l_approverUserId:= FND_GLOBAL.USER_ID;
3371:
3372: OPEN approver_dtl_cur(enrl_request_id,l_approverPersonId, l_approverUserId);
3373: FETCH approver_dtl_cur into l_rec_appr.object_version_number,
3374: l_rec_appr.entity_approver_id,

Line 3751: l_approverPersonId:= FND_GLOBAL.EMPLOYEE_ID;

3747: for the logged in user for this enrollment request. The approval status
3748: for the logged in user can be only approved in this scenario.
3749: */
3750:
3751: l_approverPersonId:= FND_GLOBAL.EMPLOYEE_ID;
3752: l_approverUserId:= FND_GLOBAL.USER_ID;
3753:
3754: OPEN approver_dtl_cur(enrl_request_id,l_approverPersonId, l_approverUserId);
3755: FETCH approver_dtl_cur into l_rec_appr.object_version_number,

Line 3752: l_approverUserId:= FND_GLOBAL.USER_ID;

3748: for the logged in user can be only approved in this scenario.
3749: */
3750:
3751: l_approverPersonId:= FND_GLOBAL.EMPLOYEE_ID;
3752: l_approverUserId:= FND_GLOBAL.USER_ID;
3753:
3754: OPEN approver_dtl_cur(enrl_request_id,l_approverPersonId, l_approverUserId);
3755: FETCH approver_dtl_cur into l_rec_appr.object_version_number,
3756: l_rec_appr.entity_approver_id,

Line 3901: OPEN is_partner_usr_csr (FND_GLOBAL.USER_ID);

3897: IF currApprRec.orig_system='PER' THEN
3898: l_personid:=currApprRec.orig_system_id;
3899: l_approver_type:='PERSON';
3900: ELSE
3901: OPEN is_partner_usr_csr (FND_GLOBAL.USER_ID);
3902: FETCH is_partner_usr_csr INTO l_isPartnerFlag;
3903: CLOSE is_partner_usr_csr;
3904: IF l_isPartnerFlag IS NULL THEN
3905: FND_MESSAGE.set_name('PV', 'PV_ENRQ_INCAPPRMSG_TO_CM');

Line 4149: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );

4145: -- Initialize message list if p_init_msg_list is set to TRUE.
4146: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4147: FND_MSG_PUB.initialize;
4148: END IF;
4149: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );
4150: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4151: -- Debug Message
4152: IF (PV_DEBUG_HIGH_ON) THEN
4153: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 4150: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );

4146: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4147: FND_MSG_PUB.initialize;
4148: END IF;
4149: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );
4150: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4151: -- Debug Message
4152: IF (PV_DEBUG_HIGH_ON) THEN
4153: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4154: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );

Line 4154: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );

4150: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4151: -- Debug Message
4152: IF (PV_DEBUG_HIGH_ON) THEN
4153: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4154: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );
4155: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4156: END IF;
4157: -- Initialize API return status to SUCCESS
4158: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4155: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );

4151: -- Debug Message
4152: IF (PV_DEBUG_HIGH_ON) THEN
4153: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4154: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );
4155: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4156: END IF;
4157: -- Initialize API return status to SUCCESS
4158: x_return_status := FND_API.G_RET_STS_SUCCESS;
4159: --RAISE FND_API.g_exc_error;

Line 4161: l_approverPersonId:= FND_GLOBAL.EMPLOYEE_ID;

4157: -- Initialize API return status to SUCCESS
4158: x_return_status := FND_API.G_RET_STS_SUCCESS;
4159: --RAISE FND_API.g_exc_error;
4160: g_approver_response:=approvalStatus;
4161: l_approverPersonId:= FND_GLOBAL.EMPLOYEE_ID;
4162: l_approverUserId:= FND_GLOBAL.USER_ID;
4163:
4164: WF_DIRECTORY.getrolename
4165: ( p_orig_system => 'PER'

Line 4162: l_approverUserId:= FND_GLOBAL.USER_ID;

4158: x_return_status := FND_API.G_RET_STS_SUCCESS;
4159: --RAISE FND_API.g_exc_error;
4160: g_approver_response:=approvalStatus;
4161: l_approverPersonId:= FND_GLOBAL.EMPLOYEE_ID;
4162: l_approverUserId:= FND_GLOBAL.USER_ID;
4163:
4164: WF_DIRECTORY.getrolename
4165: ( p_orig_system => 'PER'
4166: , p_orig_system_id => l_approverPersonId

Line 4709: IF FND_GLOBAL.USER_ID IS NULL THEN

4705: -- =========================================================================
4706: -- Validate Environment
4707: -- =========================================================================
4708:
4709: IF FND_GLOBAL.USER_ID IS NULL THEN
4710: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4711: RAISE FND_API.G_EXC_ERROR;
4712: END IF;
4713:

Line 5044: IF FND_GLOBAL.USER_ID IS NULL THEN

5040: -- =========================================================================
5041: -- Validate Environment
5042: -- =========================================================================
5043:
5044: IF FND_GLOBAL.USER_ID IS NULL THEN
5045: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
5046: RAISE FND_API.G_EXC_ERROR;
5047: END IF;
5048: --create an enrollment request with approved status

Line 5316: IF FND_GLOBAL.USER_ID IS NULL THEN

5312: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_api_name || 'start' );
5313: -- Initialize API return status to SUCCESS
5314: x_return_status := FND_API.G_RET_STS_SUCCESS;
5315: -- Validate Environment
5316: IF FND_GLOBAL.USER_ID IS NULL THEN
5317: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
5318: RAISE FND_API.G_EXC_ERROR;
5319: END IF;
5320: