[Home] [Help]
107: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
108: OPEN c_sys_stat(p_next_stat_id) ;
109: FETCH c_sys_stat INTO p_next_stat_code ;
110: CLOSE c_sys_stat ;
111: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
112: p_arc_log_used_by => 'AMS Markeing Approval',
113: p_log_used_by_id => 0,
114: p_msg_data => 'Update_Status: p_activity_type' || p_activity_type ||
115: ' p_activity_id' || p_activity_id || 'p_next_stat_id' || p_next_stat_id);
193: Ams_Evhrules_Pvt.Update_Event_Schedule_Status(p_event_offer_id => p_activity_id,
194: p_new_status_id => p_next_stat_id,
195: p_new_status_code => p_next_stat_code);
196: END IF;
197: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
198: p_arc_log_used_by => 'AMS Markeing Approval',
199: p_log_used_by_id => 0,
200: p_msg_data => 'Update_Status: Exiting sucessfully'); */
201:
301: Fnd_Msg_Pub.ADD;
302: x_return_status := Fnd_Api.G_RET_STS_ERROR;
303: RETURN;
304: END IF;
305: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
306: p_arc_log_used_by => 'AMS Markeing Approval',
307: p_log_used_by_id => 0,
308: p_msg_data => 'Update_Note: Exiting sucessfully'); */
309:
397: Fnd_Msg_Pub.ADD;
398: x_return_status := Fnd_Api.G_RET_STS_ERROR;
399: RETURN;
400: END IF;
401: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
402: p_arc_log_used_by => 'AMS Markeing Approval',
403: p_log_used_by_id => 0,
404: p_msg_data => 'Update_Note: Exiting sucessfully'); */
405:
431: SELECT full_name
432: FROM ams_jtf_rs_emp_v
433: WHERE resource_id = p_user_id ;
434: BEGIN
435: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
436: p_arc_log_used_by => 'AMS Markeing Approval',
437: p_log_used_by_id => 0,
438: p_msg_data => 'Get_User_Name: p_user_id' || p_user_id); */
439:
872: -- Bug 2789111 Priority for CSCH and EONE too
873: IF x_object_details.priority IS NOT NULL THEN
874: IF p_activity_type IN ('CAMP','EVEH','EVEO','CSCH','EONE') THEN
875:
876: Ams_Utility_Pvt.get_lookup_meaning( 'AMS_PRIORITY',
877: x_object_details.priority,
878: x_return_status,
879: l_meaning
880: );
1415: -- then that rule would be the first choice
1416: -- Convert l_amount from the Object Currency to the currency of the
1417: -- Budget
1418:
1419: AMS_Utility_Pvt.Convert_Currency (
1420: p_from_currency => l_obj_curr_code,
1421: p_to_currency => l_curr_code,
1422: p_from_amount => l_amount,
1423: x_to_amount => l_budget_amount,
1451: FETCH c_approver_detail_id INTO x_approval_detail_id, l_rule_curr_code,
1452: l_lower_limit, l_upper_limit;
1453: EXIT WHEN c_approver_detail_id%NOTFOUND;
1454:
1455: AMS_Utility_Pvt.Convert_Currency (
1456: p_from_currency => l_curr_code,
1457: p_to_currency => l_rule_curr_code,
1458: p_from_amount => l_budget_amount,
1459: x_to_amount => l_appr_amount,
1688: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1689: RAISE Fnd_Api.G_EXC_ERROR;
1690: END IF;
1691:
1692: Ams_Utility_Pvt.debug_message('START :Item TYPE : '||itemtype
1693: ||' Item KEY : '||itemkey);
1694:
1695: -- wf_engine.threshold := -1;
1696: Wf_Engine.CreateProcess (itemtype => itemtype,
1799:
1800: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1801:
1802: -- check for description of activity For ex. CAMP Campaign
1803: Ams_Utility_Pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
1804: p_activity_type,
1805: l_return_status,
1806: l_appr_meaning
1807: );
3562: IS
3563: itemkey VARCHAR2(30) := p_itemkey ;
3564: itemtype VARCHAR2(30) := NVL(p_itemtype,'AMS_APPROVAL') ;
3565: BEGIN
3566: Ams_Utility_Pvt.debug_message('Process ABORT Process');
3567: Wf_Engine.AbortProcess (itemtype => itemtype,
3568: itemkey => itemkey ,
3569: process => p_workflowprocess);
3570: EXCEPTION
3634: OPEN c_campaign;
3635: FETCH c_campaign INTO l_currency_code;
3636: IF c_campaign%NOTFOUND THEN
3637: CLOSE c_campaign;
3638: Ams_Utility_Pvt.error_message ('AMS_BUDGET_NO_OWNER');
3639: RAISE Fnd_Api.g_exc_error;
3640: END IF;
3641: CLOSE c_campaign;
3642: /* code added by murali code done by ravi start*/
3645: OPEN c_schedule;
3646: FETCH c_schedule INTO l_currency_code;
3647: IF c_schedule%NOTFOUND THEN
3648: CLOSE c_schedule;
3649: Ams_Utility_Pvt.error_message ('AMS_BUDGET_NO_OWNER');
3650: RAISE Fnd_Api.g_exc_error;
3651: END IF;
3652: CLOSE c_schedule;
3653: -- Offer
3655: OPEN c_offer;
3656: FETCH c_offer INTO l_currency_code;
3657: IF c_offer%NOTFOUND THEN
3658: CLOSE c_offer;
3659: Ams_Utility_Pvt.error_message ('AMS_BUDGET_NO_OWNER');
3660: RAISE Fnd_Api.g_exc_error;
3661: END IF;
3662: CLOSE c_offer;
3663: /* code added by murali code done by ravi end*/
3666: OPEN c_eheader;
3667: FETCH c_eheader INTO l_currency_code;
3668: IF c_eheader%NOTFOUND THEN
3669: CLOSE c_eheader;
3670: Ams_Utility_Pvt.error_message ('AMS_BUDGET_NO_OWNER');
3671: RAISE Fnd_Api.g_exc_error;
3672: END IF;
3673: CLOSE c_eheader;
3674: -- Event Offer/Execution Event
3676: OPEN c_eoffer;
3677: FETCH c_eoffer INTO l_currency_code;
3678: IF c_eoffer%NOTFOUND THEN
3679: CLOSE c_eoffer;
3680: Ams_Utility_Pvt.error_message ('AMS_BUDGET_NO_OWNER');
3681: RAISE Fnd_Api.g_exc_error;
3682: END IF;
3683: CLOSE c_eoffer;
3684: -- Deliverable
3686: OPEN c_deliverable;
3687: FETCH c_deliverable INTO l_currency_code;
3688: IF c_deliverable%NOTFOUND THEN
3689: CLOSE c_deliverable;
3690: Ams_Utility_Pvt.error_message ('AMS_ACT_BUDG_NO_OWNER');
3691: RAISE Fnd_Api.g_exc_error;
3692: END IF;
3693: CLOSE c_deliverable;
3694: ELSIF p_object = 'FUND' THEN
3695: OPEN c_fund;
3696: FETCH c_fund INTO l_currency_code;
3697: IF c_fund%NOTFOUND THEN
3698: CLOSE c_fund;
3699: Ams_Utility_Pvt.error_message ('AMS_ACT_BUDG_NO_OWNER');
3700: RAISE Fnd_Api.g_exc_error;
3701: END IF;
3702: CLOSE c_fund;
3703: ELSE
3995: itemkey => l_itemkey,
3996: aname => 'AMS_PARENT_OBJECT',
3997: avalue => l_parent_object_details.parent_name);
3998:
3999: Ams_Utility_Pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
4000: l_activity_type,
4001: l_return_status,
4002: l_appr_meaning);
4003:
4138: */
4139:
4140: IF l_budget_amount IS NULL THEN
4141: -- convert budget line amount to transaction currency of the source
4142: Ams_Utility_Pvt.Convert_Currency (
4143: p_from_currency => l_request_currency,
4144: p_to_currency => l_budget_currency,
4145: p_from_amount => l_request_amount,
4146: x_to_amount => l_budget_amount,
4214: aname => 'AMS_ACTIVITY_DETAIL_ID',
4215: avalue => l_activity_detail_id);
4216:
4217: /*
4218: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
4219: l_budget_type,
4220: l_return_status,
4221: l_appr_meaning);
4222:
4580:
4581: l_budget_rec.activity_budget_id := l_act_budget_id;
4582: l_budget_rec.status_code := 'APPROVED';
4583: --following block of code added for mumu start
4584: l_budget_rec.user_status_id := Ams_Utility_Pvt.get_default_user_status (
4585: 'OZF_BUDGETSOURCE_STATUS',
4586: l_budget_rec.status_code
4587: );
4588: l_budget_rec.object_version_number := l_object_version_number;
6717: If workflowprocess is NOT passed, the selector function
6718: defined in the item type will determine which process to run.
6719: *****************************************************************/
6720:
6721: Ams_Utility_Pvt.debug_message('Start :Item Type : '||itemtype
6722: ||' Item key : '||itemkey);
6723:
6724: Wf_Engine.CreateProcess (itemtype => itemtype,
6725: itemkey => itemkey ,
6799: RAISE;
6800: WHEN OTHERS THEN
6801: Wf_Core.context ('ams_approval_pvt', 'DelvStartProcess'
6802: ,p_deliverable_id ,p_workflowprocess);
6803: Ams_Utility_Pvt.debug_message('Inside Exception');
6804: RAISE;
6805: END DelvStartProcess;
6806: --------------------------------------------------------------------------------
6807: