[Home] [Help]
142: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
143: OPEN c_sys_stat(p_next_stat_id) ;
144: FETCH c_sys_stat INTO p_next_stat_code ;
145: CLOSE c_sys_stat ;
146: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
147: p_arc_log_used_by => 'AMS Markeing Approval',
148: p_log_used_by_id => 0,
149: p_msg_data => 'Update_Status: p_activity_type' || p_activity_type ||
150: ' p_activity_id' || p_activity_id || 'p_next_stat_id' || p_next_stat_id);
228: Ams_Evhrules_Pvt.Update_Event_Schedule_Status(p_event_offer_id => p_activity_id,
229: p_new_status_id => p_next_stat_id,
230: p_new_status_code => p_next_stat_code);
231: END IF;
232: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
233: p_arc_log_used_by => 'AMS Markeing Approval',
234: p_log_used_by_id => 0,
235: p_msg_data => 'Update_Status: Exiting sucessfully'); */
236:
336: Fnd_Msg_Pub.ADD;
337: x_return_status := Fnd_Api.G_RET_STS_ERROR;
338: RETURN;
339: END IF;
340: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
341: p_arc_log_used_by => 'AMS Markeing Approval',
342: p_log_used_by_id => 0,
343: p_msg_data => 'Update_Note: Exiting sucessfully'); */
344:
432: Fnd_Msg_Pub.ADD;
433: x_return_status := Fnd_Api.G_RET_STS_ERROR;
434: RETURN;
435: END IF;
436: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
437: p_arc_log_used_by => 'AMS Markeing Approval',
438: p_log_used_by_id => 0,
439: p_msg_data => 'Update_Note: Exiting sucessfully'); */
440:
466: SELECT full_name
467: FROM ams_jtf_rs_emp_v
468: WHERE resource_id = p_user_id ;
469: BEGIN
470: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
471: p_arc_log_used_by => 'AMS Markeing Approval',
472: p_log_used_by_id => 0,
473: p_msg_data => 'Get_User_Name: p_user_id' || p_user_id); */
474:
908: -- Bug 2789111 Priority for CSCH and EONE too
909: IF x_object_details.priority IS NOT NULL THEN
910: IF p_activity_type IN ('CAMP','EVEH','EVEO','CSCH','EONE') THEN
911:
912: Ams_Utility_Pvt.get_lookup_meaning( 'AMS_PRIORITY',
913: x_object_details.priority,
914: x_return_status,
915: l_meaning
916: );
1451: -- then that rule would be the first choice
1452: -- Convert l_amount from the Object Currency to the currency of the
1453: -- Budget
1454:
1455: AMS_Utility_Pvt.Convert_Currency (
1456: p_from_currency => l_obj_curr_code,
1457: p_to_currency => l_curr_code,
1458: p_from_amount => l_amount,
1459: x_to_amount => l_budget_amount,
1487: FETCH c_approver_detail_id INTO x_approval_detail_id, l_rule_curr_code,
1488: l_lower_limit, l_upper_limit;
1489: EXIT WHEN c_approver_detail_id%NOTFOUND;
1490:
1491: AMS_Utility_Pvt.Convert_Currency (
1492: p_from_currency => l_curr_code,
1493: p_to_currency => l_rule_curr_code,
1494: p_from_amount => l_budget_amount,
1495: x_to_amount => l_appr_amount,
1724: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1725: RAISE Fnd_Api.G_EXC_ERROR;
1726: END IF;
1727:
1728: Ams_Utility_Pvt.debug_message('START :Item TYPE : '||itemtype
1729: ||' Item KEY : '||itemkey);
1730:
1731: -- wf_engine.threshold := -1;
1732: Wf_Engine.CreateProcess (itemtype => itemtype,
1835:
1836: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1837:
1838: -- check for description of activity For ex. CAMP Campaign
1839: Ams_Utility_Pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
1840: p_activity_type,
1841: l_return_status,
1842: l_appr_meaning
1843: );
3649: IS
3650: itemkey VARCHAR2(30) := p_itemkey ;
3651: itemtype VARCHAR2(30) := NVL(p_itemtype,'AMS_APPROVAL') ;
3652: BEGIN
3653: Ams_Utility_Pvt.debug_message('Process ABORT Process');
3654: Wf_Engine.AbortProcess (itemtype => itemtype,
3655: itemkey => itemkey ,
3656: process => p_workflowprocess);
3657: EXCEPTION
3721: OPEN c_campaign;
3722: FETCH c_campaign INTO l_currency_code;
3723: IF c_campaign%NOTFOUND THEN
3724: CLOSE c_campaign;
3725: Ams_Utility_Pvt.error_message ('AMS_BUDGET_NO_OWNER');
3726: RAISE Fnd_Api.g_exc_error;
3727: END IF;
3728: CLOSE c_campaign;
3729: /* code added by murali code done by ravi start*/
3732: OPEN c_schedule;
3733: FETCH c_schedule INTO l_currency_code;
3734: IF c_schedule%NOTFOUND THEN
3735: CLOSE c_schedule;
3736: Ams_Utility_Pvt.error_message ('AMS_BUDGET_NO_OWNER');
3737: RAISE Fnd_Api.g_exc_error;
3738: END IF;
3739: CLOSE c_schedule;
3740: -- Offer
3742: OPEN c_offer;
3743: FETCH c_offer INTO l_currency_code;
3744: IF c_offer%NOTFOUND THEN
3745: CLOSE c_offer;
3746: Ams_Utility_Pvt.error_message ('AMS_BUDGET_NO_OWNER');
3747: RAISE Fnd_Api.g_exc_error;
3748: END IF;
3749: CLOSE c_offer;
3750: /* code added by murali code done by ravi end*/
3753: OPEN c_eheader;
3754: FETCH c_eheader INTO l_currency_code;
3755: IF c_eheader%NOTFOUND THEN
3756: CLOSE c_eheader;
3757: Ams_Utility_Pvt.error_message ('AMS_BUDGET_NO_OWNER');
3758: RAISE Fnd_Api.g_exc_error;
3759: END IF;
3760: CLOSE c_eheader;
3761: -- Event Offer/Execution Event
3763: OPEN c_eoffer;
3764: FETCH c_eoffer INTO l_currency_code;
3765: IF c_eoffer%NOTFOUND THEN
3766: CLOSE c_eoffer;
3767: Ams_Utility_Pvt.error_message ('AMS_BUDGET_NO_OWNER');
3768: RAISE Fnd_Api.g_exc_error;
3769: END IF;
3770: CLOSE c_eoffer;
3771: -- Deliverable
3773: OPEN c_deliverable;
3774: FETCH c_deliverable INTO l_currency_code;
3775: IF c_deliverable%NOTFOUND THEN
3776: CLOSE c_deliverable;
3777: Ams_Utility_Pvt.error_message ('AMS_ACT_BUDG_NO_OWNER');
3778: RAISE Fnd_Api.g_exc_error;
3779: END IF;
3780: CLOSE c_deliverable;
3781: ELSIF p_object = 'FUND' THEN
3782: OPEN c_fund;
3783: FETCH c_fund INTO l_currency_code;
3784: IF c_fund%NOTFOUND THEN
3785: CLOSE c_fund;
3786: Ams_Utility_Pvt.error_message ('AMS_ACT_BUDG_NO_OWNER');
3787: RAISE Fnd_Api.g_exc_error;
3788: END IF;
3789: CLOSE c_fund;
3790: ELSE
4086: itemkey => l_itemkey,
4087: aname => 'AMS_PARENT_OBJECT',
4088: avalue => l_parent_object_details.parent_name);
4089:
4090: Ams_Utility_Pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
4091: l_activity_type,
4092: l_return_status,
4093: l_appr_meaning);
4094:
4229: */
4230:
4231: IF l_budget_amount IS NULL THEN
4232: -- convert budget line amount to transaction currency of the source
4233: Ams_Utility_Pvt.Convert_Currency (
4234: p_from_currency => l_request_currency,
4235: p_to_currency => l_budget_currency,
4236: p_from_amount => l_request_amount,
4237: x_to_amount => l_budget_amount,
4305: aname => 'AMS_ACTIVITY_DETAIL_ID',
4306: avalue => l_activity_detail_id);
4307:
4308: /*
4309: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
4310: l_budget_type,
4311: l_return_status,
4312: l_appr_meaning);
4313:
4671:
4672: l_budget_rec.activity_budget_id := l_act_budget_id;
4673: l_budget_rec.status_code := 'APPROVED';
4674: --following block of code added for mumu start
4675: l_budget_rec.user_status_id := Ams_Utility_Pvt.get_default_user_status (
4676: 'OZF_BUDGETSOURCE_STATUS',
4677: l_budget_rec.status_code
4678: );
4679: l_budget_rec.object_version_number := l_object_version_number;
6808: If workflowprocess is NOT passed, the selector function
6809: defined in the item type will determine which process to run.
6810: *****************************************************************/
6811:
6812: Ams_Utility_Pvt.debug_message('Start :Item Type : '||itemtype
6813: ||' Item key : '||itemkey);
6814:
6815: Wf_Engine.CreateProcess (itemtype => itemtype,
6816: itemkey => itemkey ,
6890: RAISE;
6891: WHEN OTHERS THEN
6892: Wf_Core.context ('ams_approval_pvt', 'DelvStartProcess'
6893: ,p_deliverable_id ,p_workflowprocess);
6894: Ams_Utility_Pvt.debug_message('Inside Exception');
6895: RAISE;
6896: END DelvStartProcess;
6897: --------------------------------------------------------------------------------
6898: