DBA Data[Home] [Help]

APPS.HXC_WF_ERROR_HELPER dependencies on WF_ENGINE

Line 92: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,

88: open c_get_parent_itemkey(itemkey);
89: fetch c_get_parent_itemkey into l_itemkey;
90: close c_get_parent_itemkey;
91:
92: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
93: itemkey => l_itemkey,
94: aname => 'APP_BB_ID');
95:
96: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 96: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,

92: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
93: itemkey => l_itemkey,
94: aname => 'APP_BB_ID');
95:
96: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
97: itemkey => l_itemkey,
98: aname => 'APP_BB_OVN');
99:
100: l_timecard_id := wf_engine.GetItemAttrNumber

Line 100: l_timecard_id := wf_engine.GetItemAttrNumber

96: l_app_bb_ovn:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
97: itemkey => l_itemkey,
98: aname => 'APP_BB_OVN');
99:
100: l_timecard_id := wf_engine.GetItemAttrNumber
101: (itemtype => itemtype,
102: itemkey => l_itemkey,
103: aname => 'TC_BLD_BLK_ID');
104: l_timecard_ovn := wf_engine.GetItemAttrNumber

Line 104: l_timecard_ovn := wf_engine.GetItemAttrNumber

100: l_timecard_id := wf_engine.GetItemAttrNumber
101: (itemtype => itemtype,
102: itemkey => l_itemkey,
103: aname => 'TC_BLD_BLK_ID');
104: l_timecard_ovn := wf_engine.GetItemAttrNumber
105: (itemtype => itemtype,
106: itemkey => l_itemkey,
107: aname => 'TC_BLD_BLK_OVN');
108:

Line 110: l_effective_end_date := wf_engine.GetItemAttrDate(

106: itemkey => l_itemkey,
107: aname => 'TC_BLD_BLK_OVN');
108:
109:
110: l_effective_end_date := wf_engine.GetItemAttrDate(
111: itemtype => itemtype,
112: itemkey => l_itemkey,
113: aname => 'APP_END_DATE');
114:

Line 115: l_effective_start_date := wf_engine.GetItemAttrDate(

111: itemtype => itemtype,
112: itemkey => l_itemkey,
113: aname => 'APP_END_DATE');
114:
115: l_effective_start_date := wf_engine.GetItemAttrDate(
116: itemtype => itemtype,
117: itemkey => l_itemkey,
118: aname => 'APP_START_DATE');
119: --Instead of fetching these from item attributes, fetch it from sumary table since in the case of

Line 148: wf_engine.SetItemAttrText(itemtype => itemtype,

144:
145: if g_debug then
146: hr_utility.set_location(l_proc, 20);
147: end if;
148: wf_engine.SetItemAttrText(itemtype => itemtype,
149: itemkey => itemkey,
150: aname => 'TC_FROM_ROLE',
151: avalue => l_worker_role);
152: --set TITLE

Line 167: wf_engine.SetItemAttrText(

163: end if;
164:
165: l_title := fnd_message.get();
166:
167: wf_engine.SetItemAttrText(
168: itemtype => itemtype,
169: itemkey => itemkey,
170: aname => 'TITLE',
171: avalue => l_title);

Line 176: wf_engine.SetItemAttrText

172: --set DESCRIPTION
173:
174: --l_app_bb_id will be null when error happens in create_app_period_info, since in this procedure the itemkey will --be the itelkey ascoaited with the timecard,hence when l_app_bb_id is null total hours should be calculated --based on timecard id
175: if l_app_bb_id is null then
176: wf_engine.SetItemAttrText
177: (itemtype => itemtype,
178: itemkey => itemkey,
179: aname => 'DESCRIPTION',
180: avalue => hxc_find_notify_aprs_pkg.get_description_tc(l_timecard_id,l_timecard_ovn)

Line 183: wf_engine.SetItemAttrText

179: aname => 'DESCRIPTION',
180: avalue => hxc_find_notify_aprs_pkg.get_description_tc(l_timecard_id,l_timecard_ovn)
181: );
182: else
183: wf_engine.SetItemAttrText
184: (itemtype => itemtype,
185: itemkey => itemkey,
186: aname => 'DESCRIPTION',
187: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id)

Line 217: wf_engine.SetItemAttrText(

213: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
214: fnd_message.set_token('ERROR',l_error);
215: l_fyi_subject :=fnd_message.get();
216:
217: wf_engine.SetItemAttrText(
218: itemtype => itemtype,
219: itemkey => itemkey,
220: aname => 'FYI_SUBJECT',
221: avalue => l_fyi_subject);

Line 224: wf_engine.SetItemAttrText(

220: aname => 'FYI_SUBJECT',
221: avalue => l_fyi_subject);
222:
223: --set FYI_RECIPIENT_LOGIN
224: wf_engine.SetItemAttrText(
225: itemtype => itemtype,
226: itemkey => itemkey,
227: aname => 'ERROR_ROLE',
228: avalue =>l_error_admin_role);

Line 237: wf_engine.SetItemAttrText(

233: fnd_message.set_token('ITEM_KEY',l_itemkey);
234: fnd_message.set_token('ERROR_INFORMATION',l_error);
235: l_error_body := fnd_message.get();
236:
237: wf_engine.SetItemAttrText(
238: itemtype => itemtype,
239: itemkey => itemkey,
240: aname => 'ERROR_BODY',
241: avalue =>l_error_body);