[Home] [Help]
1341: itemtype=> l_item_type,
1342: itemkey=> l_item_key,
1343: aname => 'AMS_APPROVER_DISPLAY_NAME'
1344: );
1345: l_url1 := FND_PROFILE.VALUE('PV_WORKFLOW_RESPOND_URL');
1346: l_url2 := FND_PROFILE.VALUE('PV_WORKFLOW_RESPOND_SELF_SERVICE_URL');
1347:
1348: OPEN c_program_rec (l_program_id);
1349: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1342: itemkey=> l_item_key,
1343: aname => 'AMS_APPROVER_DISPLAY_NAME'
1344: );
1345: l_url1 := FND_PROFILE.VALUE('PV_WORKFLOW_RESPOND_URL');
1346: l_url2 := FND_PROFILE.VALUE('PV_WORKFLOW_RESPOND_SELF_SERVICE_URL');
1347:
1348: OPEN c_program_rec (l_program_id);
1349: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1350: CLOSE c_program_rec;
1490: itemtype=> l_item_type,
1491: itemkey=> l_item_key,
1492: aname => 'AMS_APPROVER_DISPLAY_NAME'
1493: );
1494: l_url1 := FND_PROFILE.VALUE('PV_WORKFLOW_RESPOND_URL');
1495: l_url2 := FND_PROFILE.VALUE('PV_WORKFLOW_RESPOND_SELFSERVICE_URL');
1496:
1497: OPEN c_program_rec (l_program_id);
1498: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1491: itemkey=> l_item_key,
1492: aname => 'AMS_APPROVER_DISPLAY_NAME'
1493: );
1494: l_url1 := FND_PROFILE.VALUE('PV_WORKFLOW_RESPOND_URL');
1495: l_url2 := FND_PROFILE.VALUE('PV_WORKFLOW_RESPOND_SELFSERVICE_URL');
1496:
1497: OPEN c_program_rec (l_program_id);
1498: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1499: CLOSE c_program_rec;
2332: , aname => 'APPROVER_ID'
2333: , avalue => p_approver_id
2334: );
2335:
2336: l_rem :=isnumber(FND_PROFILE.VALUE('PV_ENRQ_REM_DURATION'));
2337:
2338: IF l_rem IS NULL THEN
2339: l_rem:=30;
2340: END IF;
3466: was sent to default approver, OAM does not record that and we cannot update OAM in that case.
3467: We store the information in Pv_Ge_Temp_Approvers table that the request is awating approval
3468: from the default approver and so the approval status code is PENDING_DEFAULT
3469: */
3470: l_default_approver_id:= isnumber( FND_PROFILE.VALUE('PV_ENRQ_DEFAULT_APPR') );
3471: IF ( l_default_approver_id is NULL ) THEN
3472: FND_MESSAGE.set_name('PV', 'PV_ENRQ_APPR_NOT_SET');
3473: FND_MSG_PUB.add;
3474: RAISE FND_API.G_EXC_ERROR;
4173: CLOSE enrq_dtl_cur;
4174:
4175: IF approvalStatus='APPROVED' THEN
4176: --check the profile value first whether the request can be approved without signing contract
4177: l_allow_appr_wo_contract := FND_PROFILE.VALUE('PV_ALLOW_APPROVAL_WITHOUT_CONTRACT');
4178: IF l_allow_appr_wo_contract <> 'Y' THEN
4179: l_contract_signed:=checkcontract_status(enrl_request_id);
4180: IF l_contract_signed =false THEN
4181: FND_MESSAGE.set_name('PV', 'PV_ENRQ_CONTRACT_NOT_SIGNED');
4386: END IF;
4387: END IF;
4388: --g_isApproverInList:=true;
4389: ELSE --code if approver is deafault approver
4390: l_default_approver_id:= isnumber(FND_PROFILE.VALUE('PV_ENRQ_DEFAULT_APPR'));
4391: IF ( l_default_approver_id is NULL ) THEN
4392:
4393: FND_MESSAGE.set_name('PV', 'PV_ENRQ_APPR_NOT_SET');
4394: FND_MSG_PUB.add;
5046: RAISE FND_API.G_EXC_ERROR;
5047: END IF;
5048: --create an enrollment request with approved status
5049:
5050: l_default_program_id:= isnumber(FND_PROFILE.VALUE('PV_PARTNER_DEFAULT_PROGRAM'));
5051: IF l_default_program_id is NOT NULL THEN
5052: l_pv_pg_enrq_rec.partner_id:=p_partner_id;
5053: l_pv_pg_enrq_rec.program_id:= l_default_program_id;
5054: l_pv_pg_enrq_rec.requestor_resource_id:=p_requestor_resource_id;