[Home] [Help]
1: PACKAGE BODY pa_mass_asgmt_trx AS
2: -- $Header: PARMATXB.pls 120.9 2010/10/22 09:55:51 nisinha ship $
3:
4: PROCEDURE start_mass_asgmt_trx_wf
5: (p_mode IN VARCHAR2
165: END IF;
166: wf_engine.threshold := -1;
167:
168: --get item key
169: SELECT pa_mass_asgmt_trx_wf_s.nextval
170: INTO l_item_key
171: FROM dual;
172:
173: /* Commented for bug 9114634
198: */
199: -- Creating the work flow process
200: WF_ENGINE.CreateProcess( itemtype => l_item_type,
201: itemkey => l_item_key,
202: process => 'PA_MASS_ASGMT_TRX_WF') ;
203:
204: --if project id is not passed (could only happen when adding a delivery or
205: --an admin assignment from the resource context) then get the project id
206: --from the project number. Project number is required.
749: --Setting the original value
750: wf_engine.threshold := l_save_threshold;
751:
752: -- Set the excetption Message and the stack
753: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'pa_mass_asgmt_trx.start_mass_asgmt_trx_wf'
754: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
755: --
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757: RAISE;
866: --no commits are allowed in the workflow transaction, so call this
867: --API which will start an autonomous transaction.
868: --pa_wf_process_details.process_status_code will be updated inside
869: --the autonomous transaction
870: PA_MASS_ASGMT_TRX.mass_asgmt_autonomous_trx
871: (p_item_type => p_item_type,
872: p_item_key => p_item_key,
873: p_actid => p_actid,
874: p_funcmode => p_funcmode,
956: l_num_attr_value_tbl(l_num_attr_value_tbl.COUNT+1) := l_failure_assignments;
957:
958: --link to view errors page from the notification
959: l_failure_assignments_link := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275'||'&'||'akRegionCode=PA_ERROR_LAYOUT'||'&'||'paProjectId='||l_project_id||'&'||'paSrcType1=MASS_ASSIGNMENT_TRANSACTION'
960: ||'&'||'paSrcType2='||l_mode||'&'||'paSrcId1='||PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE||'&'||'paSrcId2='||PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY||'&'||'addBreadCrumb=RP';
961:
962: --store the failure assignments link the the name/value plsql tables.
963: l_text_attr_name_tbl(l_text_attr_name_tbl.COUNT+1) := 'FAILURE_ASSIGNMENTS_LINK';
964: l_text_attr_value_tbl(l_text_attr_value_tbl.COUNT+1) := l_failure_assignments_link;
1211: --regarding Document types.
1212: WF_ENGINE.SetItemAttrDocument(itemtype => p_item_type,
1213: itemkey => p_item_key,
1214: aname => 'UPDATED_INFORMATION_DOCUMENT',
1215: documentid => SubStrB('plsql:PA_MASS_ASGMT_TRX.Display_Updated_Attributes/' ||l_document,1,4000));
1216: -- bug#9786779
1217:
1218: END IF; --p_funcmode = 'RUN'
1219:
1223: -- 4537865 : Need to ask Rajnish whether p_result to be set as NONE
1224: p_result := 'NONE' ; -- In case of Unexpected Error,No Notification will be sent. Simply Exception will be RAISED.
1225:
1226: -- Included as per discussion with Rajnish : 4537865
1227: Wf_Core.Context('pa_mass_asgmt_trx','start_mass_asgmt_trx_wf',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
1228:
1229: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'pa_mass_asgmt_trx.start_mass_asgmt_trx_wf'
1230: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1231: RAISE;
1225:
1226: -- Included as per discussion with Rajnish : 4537865
1227: Wf_Core.Context('pa_mass_asgmt_trx','start_mass_asgmt_trx_wf',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
1228:
1229: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'pa_mass_asgmt_trx.start_mass_asgmt_trx_wf'
1230: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1231: RAISE;
1232:
1233: END mass_asgmt_trx_wf;
1421: , resp_appl_id => l_submitter_resp_appl_id
1422: );
1423:
1424: --set globals to be used by APIs called by this API.
1425: PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID := l_submitter_user_id;
1426: PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY := p_item_key;
1427:
1428: --get the following wf item attributes regardless of the mode
1429: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1422: );
1423:
1424: --set globals to be used by APIs called by this API.
1425: PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID := l_submitter_user_id;
1426: PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY := p_item_key;
1427:
1428: --get the following wf item attributes regardless of the mode
1429: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1430: itemkey => p_item_key,
2553: x_end_date := NULL ;
2554: x_project_id := NULL ;
2555: x_document := 'An Unexpected error has occured - ' || SUBSTRB(SQLERRM,1,240) ;
2556:
2557: WF_CORE.CONTEXT('pa_mass_asgmt_trx','mass_asgmt_autonomous_trx' ,p_item_type,p_item_key,to_char(p_actid),p_funcmode);
2558: -- End : 4537865
2559:
2560: ROLLBACK;
2561: RAISE;
2700: -- I havent reset value of p_result as this param is not assigned value anywhere in this API.
2701: -- The Workflow function (Start Apprvl WF If Required) doesnt expect any result type
2702:
2703: -- Included as per discussion with Rajnish : 4537865
2704: Wf_Core.Context('pa_mass_asgmt_trx','Start_Mass_Apprvl_WF_If_Req',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
2705: RAISE ;
2706: END Start_Mass_Apprvl_WF_If_Req;
2707:
2708:
2758: -- I havent reset value of p_result as this param is not assigned value anywhere in this API.
2759: -- The Workflow function (Revert/Cancel Overcom Items) doesnt expect any result type
2760:
2761: -- Included as per discussion with Rajnish : 4537865
2762: Wf_Core.Context('pa_mass_asgmt_trx','Revert_Cancel_Overcom_Items',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
2763: RAISE;
2764: END Revert_Cancel_Overcom_Items;
2765:
2766: --this function is not currently used.
2847: EXCEPTION
2848: WHEN OTHERS THEN
2849: -- p_result := 'NONE' ; No need for populating this value - Verified with the WF Function
2850: -- Included as per discussion with Rajnish : 4537865
2851: Wf_Core.Context('pa_mass_asgmt_trx','check_action_on_conflicts',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
2852: RAISE ;
2853: END check_action_on_conflicts;
2854:
2855: --this API is called in case response required workflow notifications time out.
2885: -- I havent reset value of p_result as this param is not assigned value anywhere in this API.
2886: -- The Workflow function (Cancel Mass Transaction) doesnt expect any result type
2887:
2888: -- Included as per discussion with Rajnish : 4537865
2889: Wf_Core.Context('pa_mass_asgmt_trx','Cancel_Mass_Trx_WF',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
2890: -- 4537865 : End
2891: RAISE;
2892:
2893: END;
2990: l_assignment_id := l_object_id1_tbl(i);
2991: END IF;
2992:
2993: PA_MESSAGE_UTILS.save_messages(p_user_id => l_submitter_user_id,
2994: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
2995: p_source_type2 => l_mode,
2996: p_source_identifier1 => l_error_item_type,
2997: p_source_identifier2 => l_error_item_key,
2998: p_context1 => l_project_id,
3012: -- I havent reset value of p_result as this param is not assigned value anywhere in this API.
3013: -- The Workflow function (Abort Remaining Transactions) doesnt expect any result type
3014:
3015: -- Included as per discussion with Rajnish : 4537865
3016: Wf_Core.Context('pa_mass_asgmt_trx','Abort_Remaining_Trx',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
3017: -- 4537865 : End
3018:
3019: RAISE;
3020:
3059: -- I havent reset value of p_result as this param is not assigned value anywhere in this API.
3060: -- The Workflow function (Set Submitter User Name) doesnt expect any result type
3061:
3062: -- Included as per discussion with Rajnish : 4537865
3063: Wf_Core.Context('pa_mass_asgmt_trx','Set_Submitter_User_Name',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
3064: RAISE;
3065:
3066: END;
3067:
3096:
3097: document := 'An Unexpected Error has occured - ' || SUBSTRB(SQLERRM,1,240) ;
3098: document_type := l_original_document_type ;
3099:
3100: WF_CORE.CONTEXT('pa_mass_asgmt_trx','Display_Updated_Attributes' );
3101: RAISE ;
3102: END;
3103:
3104: FUNCTION get_translated_attr_name (p_lookup_code IN VARCHAR2)