1777: IF (funcmode <> wf_engine.eng_run) THEN
1778: resultout := wf_engine.eng_null;
1779: RETURN;
1780: END IF;
1781: FND_MESSAGE.SET_NAME ('PA','PA_ASGMT_URL_GEN_FAILURE');
1782: l_mesg := FND_MESSAGE.GET;
1783: wf_engine.SetItemAttrText
1784: (itemtype => itemtype
1785: ,itemkey => itemkey
1778: resultout := wf_engine.eng_null;
1779: RETURN;
1780: END IF;
1781: FND_MESSAGE.SET_NAME ('PA','PA_ASGMT_URL_GEN_FAILURE');
1782: l_mesg := FND_MESSAGE.GET;
1783: wf_engine.SetItemAttrText
1784: (itemtype => itemtype
1785: ,itemkey => itemkey
1786: ,aname => 'URL_FAILURE_INFO'
3333: IF funcmode = 'FORWARD' THEN
3334: Notification assignee validations go here
3335: get the assigned user which is available in wf_engine.context_text
3336: validate this user
3337: If not valid user fnd_message.set_name ('PA','PA_NO_RESOURCE_AUTHORITY');
3338: l_msg_text := fnd_message.get;
3339: RAISE invalid_user_exception;
3340: END IF;
3341: */
3334: Notification assignee validations go here
3335: get the assigned user which is available in wf_engine.context_text
3336: validate this user
3337: If not valid user fnd_message.set_name ('PA','PA_NO_RESOURCE_AUTHORITY');
3338: l_msg_text := fnd_message.get;
3339: RAISE invalid_user_exception;
3340: END IF;
3341: */
3342: NULL;
3827: p_msg_index_out => l_msg_index_out );
3828: document := document || '
' || l_data ||'
';' || l_data ||'
';3828: document := document || '
' || l_data ||'
';' || l_data ||'
';
3854: END IF;
3855:
3856: IF p_msg_count = 1 THEN
3857: IF p_msg_data IS NOT NULL THEN
3858: FND_MESSAGE.SET_ENCODED (p_msg_data);
3859: l_data := FND_MESSAGE.GET;
3860: wf_engine.SetItemAttrText
3861: ( itemtype => p_item_type
3862: , itemkey => p_item_key
3855:
3856: IF p_msg_count = 1 THEN
3857: IF p_msg_data IS NOT NULL THEN
3858: FND_MESSAGE.SET_ENCODED (p_msg_data);
3859: l_data := FND_MESSAGE.GET;
3860: wf_engine.SetItemAttrText
3861: ( itemtype => p_item_type
3862: , itemkey => p_item_key
3863: , aname => 'ERROR_MSG1'
4336: l_msg_desc_itemattr_name := 'MSG_DESCRIPTION_FYI';
4337: END IF;
4338:
4339: -- Now that the message codes have been set,
4340: -- get the message from fnd messages
4341: FND_MESSAGE.SET_NAME ('PA',l_msg_subj_code);
4342: l_msg_subj_text := FND_MESSAGE.GET;
4343: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
4344: l_msg_desc_text := FND_MESSAGE.GET;
4337: END IF;
4338:
4339: -- Now that the message codes have been set,
4340: -- get the message from fnd messages
4341: FND_MESSAGE.SET_NAME ('PA',l_msg_subj_code);
4342: l_msg_subj_text := FND_MESSAGE.GET;
4343: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
4344: l_msg_desc_text := FND_MESSAGE.GET;
4345:
4338:
4339: -- Now that the message codes have been set,
4340: -- get the message from fnd messages
4341: FND_MESSAGE.SET_NAME ('PA',l_msg_subj_code);
4342: l_msg_subj_text := FND_MESSAGE.GET;
4343: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
4344: l_msg_desc_text := FND_MESSAGE.GET;
4345:
4346: wf_engine.SetItemAttrText
4339: -- Now that the message codes have been set,
4340: -- get the message from fnd messages
4341: FND_MESSAGE.SET_NAME ('PA',l_msg_subj_code);
4342: l_msg_subj_text := FND_MESSAGE.GET;
4343: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
4344: l_msg_desc_text := FND_MESSAGE.GET;
4345:
4346: wf_engine.SetItemAttrText
4347: ( itemtype => p_item_type
4340: -- get the message from fnd messages
4341: FND_MESSAGE.SET_NAME ('PA',l_msg_subj_code);
4342: l_msg_subj_text := FND_MESSAGE.GET;
4343: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
4344: l_msg_desc_text := FND_MESSAGE.GET;
4345:
4346: wf_engine.SetItemAttrText
4347: ( itemtype => p_item_type
4348: , itemkey => p_item_key
5122: l_msg_subj_code := 'PA_NFSUBJ_ASGMT_REJECTED';
5123: l_msg_desc_code := 'PA_NFDESC_ASGMT_REJECTED';
5124: END IF; -- IF (l_assignments_rec.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved)
5125:
5126: -- get the message from fnd messages for subject and description
5127: FND_MESSAGE.SET_NAME ('PA',l_msg_subj_code);
5128: l_msg_subj_text := FND_MESSAGE.GET;
5129: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
5130: l_msg_desc_text := FND_MESSAGE.GET;
5123: l_msg_desc_code := 'PA_NFDESC_ASGMT_REJECTED';
5124: END IF; -- IF (l_assignments_rec.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved)
5125:
5126: -- get the message from fnd messages for subject and description
5127: FND_MESSAGE.SET_NAME ('PA',l_msg_subj_code);
5128: l_msg_subj_text := FND_MESSAGE.GET;
5129: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
5130: l_msg_desc_text := FND_MESSAGE.GET;
5131:
5124: END IF; -- IF (l_assignments_rec.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved)
5125:
5126: -- get the message from fnd messages for subject and description
5127: FND_MESSAGE.SET_NAME ('PA',l_msg_subj_code);
5128: l_msg_subj_text := FND_MESSAGE.GET;
5129: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
5130: l_msg_desc_text := FND_MESSAGE.GET;
5131:
5132: -- set resource overcommitment url
5125:
5126: -- get the message from fnd messages for subject and description
5127: FND_MESSAGE.SET_NAME ('PA',l_msg_subj_code);
5128: l_msg_subj_text := FND_MESSAGE.GET;
5129: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
5130: l_msg_desc_text := FND_MESSAGE.GET;
5131:
5132: -- set resource overcommitment url
5133: l_view_conflict_url := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275&akRegionCode='
5126: -- get the message from fnd messages for subject and description
5127: FND_MESSAGE.SET_NAME ('PA',l_msg_subj_code);
5128: l_msg_subj_text := FND_MESSAGE.GET;
5129: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
5130: l_msg_desc_text := FND_MESSAGE.GET;
5131:
5132: -- set resource overcommitment url
5133: l_view_conflict_url := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275&akRegionCode='
5134: || 'PA_RES_OVERCOMMITMENT_LAYOUT&paAssignmentId=' || p_assignment_id
7900: IF pending_txn_approvals%FOUND THEN
7901:
7902: -- resultout := 'ERROR:PA_NO_ACTION_ON_NOTIFCATIONS'; commented for Bug#5650363
7903: -- Added for the below line for Bug#5650363
7904: resultout := 'ERROR:' || substrb(fnd_message.get_string('PA','PA_NO_ACTION_ON_NOTIFCATIONS'),1,114);
7905:
7906: CLOSE pending_txn_approvals; -- Added Close statement for BUG#6328067
7907: ELSE
7908: CLOSE pending_txn_approvals; -- Added Close statement for BUG#6328067