44: p_encoded => Fnd_Api.G_FALSE,
45: p_data => l_msg_data,
46: p_msg_index_out => l_msg_index );
47: l_final_data := l_final_data ||l_msg_index||': '
48: ||l_msg_data||Fnd_Global.local_chr(10) ;
49: l_cnt := l_cnt + 1 ;
50: END LOOP ;
51: x_error_msg := l_final_data;
52: Wf_Engine.SetItemAttrText
287: p_source_object_id => p_activity_id,
288: p_source_object_code => 'AMS_'||p_activity_type,
289: p_notes => p_note,
290: p_note_status => NULL ,
291: p_entered_by => l_user , -- 1000050 , -- FND_GLOBAL.USER_ID,
292: p_entered_date => SYSDATE,
293: p_last_updated_by => l_user , -- 1000050 , -- FND_GLOBAL.USER_ID,
294: x_jtf_note_id => l_id ,
295: p_note_type => 'AMS_APPROVAL' ,
289: p_notes => p_note,
290: p_note_status => NULL ,
291: p_entered_by => l_user , -- 1000050 , -- FND_GLOBAL.USER_ID,
292: p_entered_date => SYSDATE,
293: p_last_updated_by => l_user , -- 1000050 , -- FND_GLOBAL.USER_ID,
294: x_jtf_note_id => l_id ,
295: p_note_type => 'AMS_APPROVAL' ,
296: p_last_update_date => SYSDATE ,
297: p_creation_date => SYSDATE ) ;
383: p_source_object_id => p_activity_id,
384: p_source_object_code => 'AMS_'||p_activity_type,
385: p_notes => p_note,
386: p_note_status => NULL ,
387: p_entered_by => l_user , -- 1000050 , -- FND_GLOBAL.USER_ID,
388: p_entered_date => SYSDATE,
389: p_last_updated_by => l_user , -- 1000050 , -- FND_GLOBAL.USER_ID,
390: x_jtf_note_id => l_id ,
391: p_note_type => 'AMS_FREQ' ,
385: p_notes => p_note,
386: p_note_status => NULL ,
387: p_entered_by => l_user , -- 1000050 , -- FND_GLOBAL.USER_ID,
388: p_entered_date => SYSDATE,
389: p_last_updated_by => l_user , -- 1000050 , -- FND_GLOBAL.USER_ID,
390: x_jtf_note_id => l_id ,
391: p_note_type => 'AMS_FREQ' ,
392: p_last_update_date => SYSDATE ,
393: p_creation_date => SYSDATE ) ;
1705: -- workflow item attribute.It could be used later on for
1706: -- PL/SQL function to initialize the global context when the
1707: -- session is established by workflow mailer.
1708:
1709: l_user_id := FND_GLOBAL.user_id;
1710: l_resp_id := FND_GLOBAL.resp_id;
1711: l_appl_id := FND_GLOBAL.resp_appl_id;
1712: l_security_group_id := FND_GLOBAL.security_group_id;
1713:
1706: -- PL/SQL function to initialize the global context when the
1707: -- session is established by workflow mailer.
1708:
1709: l_user_id := FND_GLOBAL.user_id;
1710: l_resp_id := FND_GLOBAL.resp_id;
1711: l_appl_id := FND_GLOBAL.resp_appl_id;
1712: l_security_group_id := FND_GLOBAL.security_group_id;
1713:
1714: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
1707: -- session is established by workflow mailer.
1708:
1709: l_user_id := FND_GLOBAL.user_id;
1710: l_resp_id := FND_GLOBAL.resp_id;
1711: l_appl_id := FND_GLOBAL.resp_appl_id;
1712: l_security_group_id := FND_GLOBAL.security_group_id;
1713:
1714: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
1715: itemkey => itemkey,
1708:
1709: l_user_id := FND_GLOBAL.user_id;
1710: l_resp_id := FND_GLOBAL.resp_id;
1711: l_appl_id := FND_GLOBAL.resp_appl_id;
1712: l_security_group_id := FND_GLOBAL.security_group_id;
1713:
1714: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
1715: itemkey => itemkey,
1716: aname => 'USER_ID',
3868: -- workflow item attribute.It could be used later on for
3869: -- PL/SQL function to initialize the global context when the
3870: -- session is established by workflow mailer.
3871:
3872: l_user_id := FND_GLOBAL.user_id;
3873: l_resp_id := FND_GLOBAL.resp_id;
3874: l_appl_id := FND_GLOBAL.resp_appl_id;
3875: l_security_group_id := FND_GLOBAL.security_group_id;
3876:
3869: -- PL/SQL function to initialize the global context when the
3870: -- session is established by workflow mailer.
3871:
3872: l_user_id := FND_GLOBAL.user_id;
3873: l_resp_id := FND_GLOBAL.resp_id;
3874: l_appl_id := FND_GLOBAL.resp_appl_id;
3875: l_security_group_id := FND_GLOBAL.security_group_id;
3876:
3877: WF_ENGINE.SetItemAttrNumber(itemtype => l_itemtype ,
3870: -- session is established by workflow mailer.
3871:
3872: l_user_id := FND_GLOBAL.user_id;
3873: l_resp_id := FND_GLOBAL.resp_id;
3874: l_appl_id := FND_GLOBAL.resp_appl_id;
3875: l_security_group_id := FND_GLOBAL.security_group_id;
3876:
3877: WF_ENGINE.SetItemAttrNumber(itemtype => l_itemtype ,
3878: itemkey => l_itemkey,
3871:
3872: l_user_id := FND_GLOBAL.user_id;
3873: l_resp_id := FND_GLOBAL.resp_id;
3874: l_appl_id := FND_GLOBAL.resp_appl_id;
3875: l_security_group_id := FND_GLOBAL.security_group_id;
3876:
3877: WF_ENGINE.SetItemAttrNumber(itemtype => l_itemtype ,
3878: itemkey => l_itemkey,
3879: aname => 'USER_ID',