149: itemkey => itemkey,
150: aname => 'TC_FROM_ROLE',
151: avalue => l_worker_role);
152: --set TITLE
153: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
154:
155: --l_effective_start_date and l_effective_end_date 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 we need to pass --timecard start and stop times.
156:
157: if(l_effective_start_date is null and l_effective_end_date is null) then
154:
155: --l_effective_start_date and l_effective_end_date 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 we need to pass --timecard start and stop times.
156:
157: if(l_effective_start_date is null and l_effective_end_date is null) then
158: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
159: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
160: else
161: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
162: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
155: --l_effective_start_date and l_effective_end_date 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 we need to pass --timecard start and stop times.
156:
157: if(l_effective_start_date is null and l_effective_end_date is null) then
158: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
159: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
160: else
161: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
162: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
163: end if;
157: if(l_effective_start_date is null and l_effective_end_date is null) then
158: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
159: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
160: else
161: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
162: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
163: end if;
164:
165: l_title := fnd_message.get();
158: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
159: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
160: else
161: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
162: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
163: end if;
164:
165: l_title := fnd_message.get();
166:
161: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
162: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
163: end if;
164:
165: l_title := fnd_message.get();
166:
167: wf_engine.SetItemAttrText(
168: itemtype => itemtype,
169: itemkey => itemkey,
198: fetch c_get_error into l_error;
199: close c_get_error;
200:
201: --set FYI_SUBJECT
202: fnd_message.set_name('HXC','HXC_APPR_ERROR_SUBJECT');
203:
204: --l_effective_start_date and l_effective_end_date 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 we need to pass --timecard start and stop times.
205: if(l_effective_start_date is null and l_effective_end_date is null) then
206: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
202: fnd_message.set_name('HXC','HXC_APPR_ERROR_SUBJECT');
203:
204: --l_effective_start_date and l_effective_end_date 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 we need to pass --timecard start and stop times.
205: if(l_effective_start_date is null and l_effective_end_date is null) then
206: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
207: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
208: else
209: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
210: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
203:
204: --l_effective_start_date and l_effective_end_date 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 we need to pass --timecard start and stop times.
205: if(l_effective_start_date is null and l_effective_end_date is null) then
206: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
207: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
208: else
209: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
210: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
211: end if;
205: if(l_effective_start_date is null and l_effective_end_date is null) then
206: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
207: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
208: else
209: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
210: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
211: end if;
212:
213: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
206: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
207: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
208: else
209: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
210: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
211: end if;
212:
213: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
214: fnd_message.set_token('ERROR',l_error);
209: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
210: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
211: end if;
212:
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(
210: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
211: end if;
212:
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,
211: end if;
212:
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,
226: itemkey => itemkey,
227: aname => 'ERROR_ROLE',
228: avalue =>l_error_admin_role);
229:
230: fnd_message.set_name('HXC','HXC_APPR_ERROR_BODY');
231: fnd_message.set_token('ITEM_TYPE_DESC',l_item_type_desc);
232: fnd_message.set_token('ITEM_TYPE',itemtype);
233: fnd_message.set_token('ITEM_KEY',l_itemkey);
234: fnd_message.set_token('ERROR_INFORMATION',l_error);
227: aname => 'ERROR_ROLE',
228: avalue =>l_error_admin_role);
229:
230: fnd_message.set_name('HXC','HXC_APPR_ERROR_BODY');
231: fnd_message.set_token('ITEM_TYPE_DESC',l_item_type_desc);
232: fnd_message.set_token('ITEM_TYPE',itemtype);
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();
228: avalue =>l_error_admin_role);
229:
230: fnd_message.set_name('HXC','HXC_APPR_ERROR_BODY');
231: fnd_message.set_token('ITEM_TYPE_DESC',l_item_type_desc);
232: fnd_message.set_token('ITEM_TYPE',itemtype);
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:
229:
230: fnd_message.set_name('HXC','HXC_APPR_ERROR_BODY');
231: fnd_message.set_token('ITEM_TYPE_DESC',l_item_type_desc);
232: fnd_message.set_token('ITEM_TYPE',itemtype);
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(
230: fnd_message.set_name('HXC','HXC_APPR_ERROR_BODY');
231: fnd_message.set_token('ITEM_TYPE_DESC',l_item_type_desc);
232: fnd_message.set_token('ITEM_TYPE',itemtype);
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,
231: fnd_message.set_token('ITEM_TYPE_DESC',l_item_type_desc);
232: fnd_message.set_token('ITEM_TYPE',itemtype);
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,