[Home] [Help]
1: PACKAGE BODY pa_mass_asgmt_trx AS
2: -- $Header: PARMATXB.pls 120.3.12000000.2 2007/09/11 06:12:54 admarath ship $
3:
4: PROCEDURE start_mass_asgmt_trx_wf
5: (p_mode IN VARCHAR2
164: END IF;
165: wf_engine.threshold := -1;
166:
167: --get item key
168: SELECT pa_mass_asgmt_trx_wf_s.nextval
169: INTO l_item_key
170: FROM dual;
171:
172: ---------------------------------------------------------------------------
196:
197: -- Creating the work flow process
198: WF_ENGINE.CreateProcess( itemtype => l_item_type,
199: itemkey => l_item_key,
200: process => 'PA_MASS_ASGMT_TRX_WF') ;
201:
202: --if project id is not passed (could only happen when adding a delivery or
203: --an admin assignment from the resource context) then get the project id
204: --from the project number. Project number is required.
747: --Setting the original value
748: wf_engine.threshold := l_save_threshold;
749:
750: -- Set the excetption Message and the stack
751: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'pa_mass_asgmt_trx.start_mass_asgmt_trx_wf'
752: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
753: --
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
755: RAISE;
855: --no commits are allowed in the workflow transaction, so call this
856: --API which will start an autonomous transaction.
857: --pa_wf_process_details.process_status_code will be updated inside
858: --the autonomous transaction
859: PA_MASS_ASGMT_TRX.mass_asgmt_autonomous_trx
860: (p_item_type => p_item_type,
861: p_item_key => p_item_key,
862: p_actid => p_actid,
863: p_funcmode => p_funcmode,
945: l_num_attr_value_tbl(l_num_attr_value_tbl.COUNT+1) := l_failure_assignments;
946:
947: --link to view errors page from the notification
948: l_failure_assignments_link := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275'||'&'||'akRegionCode=PA_ERROR_LAYOUT'||'&'||'paProjectId='||l_project_id||'&'||'paSrcType1=MASS_ASSIGNMENT_TRANSACTION'
949: ||'&'||'paSrcType2='||l_mode||'&'||'paSrcId1='||PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE||'&'||'paSrcId2='||PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY||'&'||'addBreadCrumb=RP';
950:
951: --store the failure assignments link the the name/value plsql tables.
952: l_text_attr_name_tbl(l_text_attr_name_tbl.COUNT+1) := 'FAILURE_ASSIGNMENTS_LINK';
953: l_text_attr_value_tbl(l_text_attr_value_tbl.COUNT+1) := l_failure_assignments_link;
1155: --regarding Document types.
1156: WF_ENGINE.SetItemAttrDocument(itemtype => p_item_type,
1157: itemkey => p_item_key,
1158: aname => 'UPDATED_INFORMATION_DOCUMENT',
1159: documentid => 'plsql:PA_MASS_ASGMT_TRX.Display_Updated_Attributes/' ||l_document);
1160:
1161: END IF; --p_funcmode = 'RUN'
1162:
1163: EXCEPTION
1166: -- 4537865 : Need to ask Rajnish whether p_result to be set as NONE
1167: p_result := 'NONE' ; -- In case of Unexpected Error,No Notification will be sent. Simply Exception will be RAISED.
1168:
1169: -- Included as per discussion with Rajnish : 4537865
1170: Wf_Core.Context('pa_mass_asgmt_trx','start_mass_asgmt_trx_wf',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
1171:
1172: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'pa_mass_asgmt_trx.start_mass_asgmt_trx_wf'
1173: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1174: RAISE;
1168:
1169: -- Included as per discussion with Rajnish : 4537865
1170: Wf_Core.Context('pa_mass_asgmt_trx','start_mass_asgmt_trx_wf',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
1171:
1172: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'pa_mass_asgmt_trx.start_mass_asgmt_trx_wf'
1173: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1174: RAISE;
1175:
1176: END mass_asgmt_trx_wf;
1364: , resp_appl_id => l_submitter_resp_appl_id
1365: );
1366:
1367: --set globals to be used by APIs called by this API.
1368: PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID := l_submitter_user_id;
1369: PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY := p_item_key;
1370:
1371: --get the following wf item attributes regardless of the mode
1372: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1365: );
1366:
1367: --set globals to be used by APIs called by this API.
1368: PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID := l_submitter_user_id;
1369: PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY := p_item_key;
1370:
1371: --get the following wf item attributes regardless of the mode
1372: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1373: itemkey => p_item_key,
2496: x_end_date := NULL ;
2497: x_project_id := NULL ;
2498: x_document := 'An Unexpected error has occured - ' || SUBSTRB(SQLERRM,1,240) ;
2499:
2500: WF_CORE.CONTEXT('pa_mass_asgmt_trx','mass_asgmt_autonomous_trx' ,p_item_type,p_item_key,to_char(p_actid),p_funcmode);
2501: -- End : 4537865
2502:
2503: ROLLBACK;
2504: RAISE;
2641: -- I havent reset value of p_result as this param is not assigned value anywhere in this API.
2642: -- The Workflow function (Start Apprvl WF If Required) doesnt expect any result type
2643:
2644: -- Included as per discussion with Rajnish : 4537865
2645: 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);
2646: RAISE ;
2647: END Start_Mass_Apprvl_WF_If_Req;
2648:
2649:
2699: -- I havent reset value of p_result as this param is not assigned value anywhere in this API.
2700: -- The Workflow function (Revert/Cancel Overcom Items) doesnt expect any result type
2701:
2702: -- Included as per discussion with Rajnish : 4537865
2703: Wf_Core.Context('pa_mass_asgmt_trx','Revert_Cancel_Overcom_Items',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
2704: RAISE;
2705: END Revert_Cancel_Overcom_Items;
2706:
2707: --this function is not currently used.
2788: EXCEPTION
2789: WHEN OTHERS THEN
2790: -- p_result := 'NONE' ; No need for populating this value - Verified with the WF Function
2791: -- Included as per discussion with Rajnish : 4537865
2792: Wf_Core.Context('pa_mass_asgmt_trx','check_action_on_conflicts',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
2793: RAISE ;
2794: END check_action_on_conflicts;
2795:
2796: --this API is called in case response required workflow notifications time out.
2826: -- I havent reset value of p_result as this param is not assigned value anywhere in this API.
2827: -- The Workflow function (Cancel Mass Transaction) doesnt expect any result type
2828:
2829: -- Included as per discussion with Rajnish : 4537865
2830: Wf_Core.Context('pa_mass_asgmt_trx','Cancel_Mass_Trx_WF',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
2831: -- 4537865 : End
2832: RAISE;
2833:
2834: END;
2931: l_assignment_id := l_object_id1_tbl(i);
2932: END IF;
2933:
2934: PA_MESSAGE_UTILS.save_messages(p_user_id => l_submitter_user_id,
2935: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
2936: p_source_type2 => l_mode,
2937: p_source_identifier1 => l_error_item_type,
2938: p_source_identifier2 => l_error_item_key,
2939: p_context1 => l_project_id,
2953: -- I havent reset value of p_result as this param is not assigned value anywhere in this API.
2954: -- The Workflow function (Abort Remaining Transactions) doesnt expect any result type
2955:
2956: -- Included as per discussion with Rajnish : 4537865
2957: Wf_Core.Context('pa_mass_asgmt_trx','Abort_Remaining_Trx',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
2958: -- 4537865 : End
2959:
2960: RAISE;
2961:
3000: -- I havent reset value of p_result as this param is not assigned value anywhere in this API.
3001: -- The Workflow function (Set Submitter User Name) doesnt expect any result type
3002:
3003: -- Included as per discussion with Rajnish : 4537865
3004: Wf_Core.Context('pa_mass_asgmt_trx','Set_Submitter_User_Name',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
3005: RAISE;
3006:
3007: END;
3008:
3037:
3038: document := 'An Unexpected Error has occured - ' || SUBSTRB(SQLERRM,1,240) ;
3039: document_type := l_original_document_type ;
3040:
3041: WF_CORE.CONTEXT('pa_mass_asgmt_trx','Display_Updated_Attributes' );
3042: RAISE ;
3043: END;
3044:
3045: FUNCTION get_translated_attr_name (p_lookup_code IN VARCHAR2)