DBA Data[Home] [Help]

APPS.HXC_WF_ERROR_HELPER dependencies on FND_MESSAGE

Line 153: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');

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

Line 158: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

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')));

Line 159: fnd_message.set_token('END_DATE',to_char(l_tc_stop_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;

Line 161: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

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();

Line 162: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

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:

Line 165: l_title := fnd_message.get();

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,

Line 202: fnd_message.set_name('HXC','HXC_APPR_ERROR_SUBJECT');

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')));

Line 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')));

Line 207: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_tc_stop_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;

Line 209: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

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);

Line 210: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

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);

Line 213: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

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(

Line 214: fnd_message.set_token('ERROR',l_error);

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,

Line 215: l_fyi_subject :=fnd_message.get();

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,

Line 230: fnd_message.set_name('HXC','HXC_APPR_ERROR_BODY');

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);

Line 231: fnd_message.set_token('ITEM_TYPE_DESC',l_item_type_desc);

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();

Line 232: fnd_message.set_token('ITEM_TYPE',itemtype);

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:

Line 233: fnd_message.set_token('ITEM_KEY',l_itemkey);

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(

Line 234: fnd_message.set_token('ERROR_INFORMATION',l_error);

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,

Line 235: l_error_body := fnd_message.get();

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,