APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on WF_CORE

Line 293: l_notes := l_notes || wf_core.newline || p_notes ;

289: from WIP_EAM_WORK_REQ_NOTES wrn2
290: where wrn1.work_request_id = wrn2.work_request_id);
291:
292: If l_notes is not null then
293: l_notes := l_notes || wf_core.newline || p_notes ;
294: Else
295: l_notes := p_notes ;
296: End if ; */
297: -- Changing the code for bug 10399281. Carry entire history ( last 4000 chars).

Line 302: l_total_content_num:= l_old_content_num+l_new_content_num+Length(wf_core.newline);

298: FOR desc_history_rec in desc_history_cur(p_work_request_id) LOOP
299:
300: l_old_content_num:= Length(l_notes);
301: l_new_content_num:=Length(desc_history_rec.notes);
302: l_total_content_num:= l_old_content_num+l_new_content_num+Length(wf_core.newline);
303:
304:
305: IF (l_total_content_num)>4000 THEN
306: IF l_notes IS NOT NULL THEN

Line 307: l_notes:=SubStr(l_notes,l_new_content_num+1)||wf_core.newline||desc_history_rec.notes ;

303:
304:
305: IF (l_total_content_num)>4000 THEN
306: IF l_notes IS NOT NULL THEN
307: l_notes:=SubStr(l_notes,l_new_content_num+1)||wf_core.newline||desc_history_rec.notes ;
308: ELSE
309: l_notes:= desc_history_rec.notes;
310: END IF;
311: ELSE

Line 312: l_notes:=l_notes ||wf_core.newline || desc_history_rec.notes;

308: ELSE
309: l_notes:= desc_history_rec.notes;
310: END IF;
311: ELSE
312: l_notes:=l_notes ||wf_core.newline || desc_history_rec.notes;
313: END IF;
314:
315:
316: END LOOP ;

Line 480: wf_core.context('EAMWRAP','StartWRAProcess', itemtype, itemkey);

476: ' [Asset : ' || P_asset_number || '] Assigned Department';
477: Fnd_message.Set_token('MESSAGE', P_error_message);
478: Fnd_msg_pub.Add;
479: When others then
480: wf_core.context('EAMWRAP','StartWRAProcess', itemtype, itemkey);
481: P_resultout := Fnd_api.G_ret_sts_error;
482: P_error_message := To_char(L_stmt_number) || ' EAMWRAP'
483: || ' StartWRAProcess'|| Itemtype || Itemkey;
484: Fnd_message.Set_token('MESSAGE', P_error_message);

Line 519: IF (wf_core.error_name = 'WFENG_ITEM_ATTR') THEN

515: aname=> 'FROM_ROLE2',
516: avalue=> l_approver_name);
517: EXCEPTION/*bug#4395553 - added for WF upgraded from pre11i10*/
518: WHEN OTHERS THEN
519: IF (wf_core.error_name = 'WFENG_ITEM_ATTR') THEN
520: wf_engine.AddItemAttr(itemtype=>itemtype,
521: itemkey =>itemkey,
522: aname=>'FROM_ROLE2');
523: wf_engine.SetItemAttrText( itemtype => itemtype,

Line 600: ||') *** ' || wf_core.newline ||

596: l_comment := ' *** '||
597: l_approver_name||
598: ' (' ||
599: to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')
600: ||') *** ' || wf_core.newline ||
601: l_comment ;
602: /*
603: l_stmt_number := 30;
604: select orig_system_id

Line 662: wf_core.context('EAMWRAP','UPDATE_STATUS_AWAIT_WO '||to_char(l_stmt_number),

658:
659: EXCEPTION
660:
661: when others then
662: wf_core.context('EAMWRAP','UPDATE_STATUS_AWAIT_WO '||to_char(l_stmt_number),
663: itemtype, itemkey, actid, funcmode);
664: raise;
665:
666: END Update_Status_Await_Wo;

Line 722: ||') *** ' || wf_core.newline ||

718: l_comment := ' *** '||
719: l_user_name||
720: ' (' ||
721: to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')
722: ||') *** ' || wf_core.newline ||
723: l_comment;
724: /*
725: l_stmt_number := 30;
726: select orig_system_id

Line 784: wf_core.context('EAMWRAP','UPDATE_STATUS_REJECTED '|| to_char(l_stmt_number) ,itemtype, itemkey, actid, funcmode);

780:
781: EXCEPTION
782:
783: when others then
784: wf_core.context('EAMWRAP','UPDATE_STATUS_REJECTED '|| to_char(l_stmt_number) ,itemtype, itemkey, actid, funcmode);
785: raise;
786: END Update_status_rejected;
787:
788: /*Update status to 'Additional Information' in wip_eam_work_requests */

Line 887: ||') *** ' || wf_core.newline ||

883: l_comment := ' *** '||
884: l_user_name||
885: ' (' ||
886: to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')
887: ||') *** ' || wf_core.newline ||
888: l_comment;
889:
890:
891: If l_previous_reassign_comment is null

Line 896: wf_core.newline || l_comment ;

892: Then
893: l_previous_reassign_comment := l_comment ;
894: Else
895: l_previous_reassign_comment := l_previous_reassign_comment ||
896: wf_core.newline || l_comment ;
897: End if ;
898:
899: -- Assumption For SYSDATE , there is not much time lag betwn
900: -- comments entered on WF and time it reaches the below insert

Line 978: wf_core.context('EAMWRAP', 'UPDATE_STATUS_ADD '|| to_char(l_stmt_number),

974:
975: EXCEPTION
976:
977: when others then
978: wf_core.context('EAMWRAP', 'UPDATE_STATUS_ADD '|| to_char(l_stmt_number),
979: itemtype, itemkey, actid, funcmode);
980: raise;
981:
982: END Update_status_add;

Line 1043: wf_core.context('WIPVWRAB', 'CHECK_NOTIFY_ORIGINATOR',

1039: exception
1040: when others then
1041: -- The line below records this function call in the error system
1042: -- in the case of an exception.
1043: wf_core.context('WIPVWRAB', 'CHECK_NOTIFY_ORIGINATOR',
1044: itemtype, itemkey, to_char(actid), funcmode);
1045: raise;
1046: end CHECK_NOTIFY_ORIGINATOR;
1047: