308:
309: l_description fnd_new_messages.message_text%type;
310: begin
311:
312: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
313: l_description := fnd_message.get();
314: -- After getting the message, must reset it
315:
316: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
309: l_description fnd_new_messages.message_text%type;
310: begin
311:
312: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
313: l_description := fnd_message.get();
314: -- After getting the message, must reset it
315:
316: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
317: if(instr(l_description,'TOTAL_HOURS')>0) then
312: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
313: l_description := fnd_message.get();
314: -- After getting the message, must reset it
315:
316: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
317: if(instr(l_description,'TOTAL_HOURS')>0) then
318: fnd_message.set_token('TOTAL_HOURS',category_timecard_hrs(p_application_period_id,''));
319: end if;
320:
314: -- After getting the message, must reset it
315:
316: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
317: if(instr(l_description,'TOTAL_HOURS')>0) then
318: fnd_message.set_token('TOTAL_HOURS',category_timecard_hrs(p_application_period_id,''));
319: end if;
320:
321: if(instr(l_description,'PREMIUM_HOURS')>0) then
322: fnd_message.set_token('PREMIUM_HOURS',category_timecard_hrs(p_application_period_id,'Total2'));
318: fnd_message.set_token('TOTAL_HOURS',category_timecard_hrs(p_application_period_id,''));
319: end if;
320:
321: if(instr(l_description,'PREMIUM_HOURS')>0) then
322: fnd_message.set_token('PREMIUM_HOURS',category_timecard_hrs(p_application_period_id,'Total2'));
323: end if;
324:
325: if(instr(l_description,'NON_WORKED_HOURS')>0) then
326: fnd_message.set_token('NON_WORKED_HOURS',category_timecard_hrs(p_application_period_id,'Total3'));
322: fnd_message.set_token('PREMIUM_HOURS',category_timecard_hrs(p_application_period_id,'Total2'));
323: end if;
324:
325: if(instr(l_description,'NON_WORKED_HOURS')>0) then
326: fnd_message.set_token('NON_WORKED_HOURS',category_timecard_hrs(p_application_period_id,'Total3'));
327: end if;
328:
329: return fnd_message.get();
330:
325: if(instr(l_description,'NON_WORKED_HOURS')>0) then
326: fnd_message.set_token('NON_WORKED_HOURS',category_timecard_hrs(p_application_period_id,'Total3'));
327: end if;
328:
329: return fnd_message.get();
330:
331: end get_description;
332:
333: function get_description_tc
338: l_description fnd_new_messages.message_text%type;
339:
340: begin
341:
342: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
343: l_description := fnd_message.get();
344: -- After getting the message, must reset it
345:
346: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
339:
340: begin
341:
342: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
343: l_description := fnd_message.get();
344: -- After getting the message, must reset it
345:
346: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
347: if(instr(l_description,'TOTAL_HOURS')>0) then
342: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
343: l_description := fnd_message.get();
344: -- After getting the message, must reset it
345:
346: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
347: if(instr(l_description,'TOTAL_HOURS')>0) then
348: fnd_message.set_token
349: ('TOTAL_HOURS',
350: hxc_time_category_utils_pkg.category_timecard_hrs_ind(p_timecard_id,p_timecard_ovn,'')
344: -- After getting the message, must reset it
345:
346: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
347: if(instr(l_description,'TOTAL_HOURS')>0) then
348: fnd_message.set_token
349: ('TOTAL_HOURS',
350: hxc_time_category_utils_pkg.category_timecard_hrs_ind(p_timecard_id,p_timecard_ovn,'')
351: );
352: end if;
351: );
352: end if;
353:
354: if(instr(l_description,'PREMIUM_HOURS')>0) then
355: fnd_message.set_token
356: ('PREMIUM_HOURS',
357: hxc_time_category_utils_pkg.category_timecard_hrs_ind(p_timecard_id, p_timecard_ovn,'Total2')
358: );
359: end if;
358: );
359: end if;
360:
361: if(instr(l_description,'NON_WORKED_HOURS')>0) then
362: fnd_message.set_token
363: ('NON_WORKED_HOURS',
364: hxc_time_category_utils_pkg.category_timecard_hrs_ind(p_timecard_id, p_timecard_ovn,'Total3')
365: );
366: end if;
364: hxc_time_category_utils_pkg.category_timecard_hrs_ind(p_timecard_id, p_timecard_ovn,'Total3')
365: );
366: end if;
367:
368: return fnd_message.get();
369: end get_description_tc;
370:
371: function get_description_date
372: (p_start_date in date,
377: l_description fnd_new_messages.message_text%type;
378:
379: begin
380:
381: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
382: l_description := fnd_message.get();
383: -- After getting the message, must reset it
384:
385: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
378:
379: begin
380:
381: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
382: l_description := fnd_message.get();
383: -- After getting the message, must reset it
384:
385: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
386: if(instr(l_description,'TOTAL_HOURS')>0) then
381: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
382: l_description := fnd_message.get();
383: -- After getting the message, must reset it
384:
385: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
386: if(instr(l_description,'TOTAL_HOURS')>0) then
387: fnd_message.set_token('TOTAL_HOURS',category_timecard_hrs(p_start_date,p_end_date,p_resource_id,''));
388: end if;
389:
383: -- After getting the message, must reset it
384:
385: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');
386: if(instr(l_description,'TOTAL_HOURS')>0) then
387: fnd_message.set_token('TOTAL_HOURS',category_timecard_hrs(p_start_date,p_end_date,p_resource_id,''));
388: end if;
389:
390: if(instr(l_description,'PREMIUM_HOURS')>0) then
391: fnd_message.set_token('PREMIUM_HOURS',category_timecard_hrs(p_start_date,p_end_date,p_resource_id,'Total2'));
387: fnd_message.set_token('TOTAL_HOURS',category_timecard_hrs(p_start_date,p_end_date,p_resource_id,''));
388: end if;
389:
390: if(instr(l_description,'PREMIUM_HOURS')>0) then
391: fnd_message.set_token('PREMIUM_HOURS',category_timecard_hrs(p_start_date,p_end_date,p_resource_id,'Total2'));
392: end if;
393:
394: if(instr(l_description,'NON_WORKED_HOURS')>0) then
395: fnd_message.set_token('NON_WORKED_HOURS',category_timecard_hrs(p_start_date,p_end_date,p_resource_id,'Total3'));
391: fnd_message.set_token('PREMIUM_HOURS',category_timecard_hrs(p_start_date,p_end_date,p_resource_id,'Total2'));
392: end if;
393:
394: if(instr(l_description,'NON_WORKED_HOURS')>0) then
395: fnd_message.set_token('NON_WORKED_HOURS',category_timecard_hrs(p_start_date,p_end_date,p_resource_id,'Total3'));
396: end if;
397:
398: return fnd_message.get();
399: end get_description_date;
394: if(instr(l_description,'NON_WORKED_HOURS')>0) then
395: fnd_message.set_token('NON_WORKED_HOURS',category_timecard_hrs(p_start_date,p_end_date,p_resource_id,'Total3'));
396: end if;
397:
398: return fnd_message.get();
399: end get_description_date;
400:
401: --this procedure is called to cancel the other outstanding
402: --notifications for the same application period.
1906: itemkey => p_itemkey,
1907: aname => 'TC_APPROVER_FROM_ROLE',
1908: avalue => l_login);
1909:
1910: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1911: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1912: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1913:
1914: l_title := fnd_message.get();
1907: aname => 'TC_APPROVER_FROM_ROLE',
1908: avalue => l_login);
1909:
1910: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1911: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1912: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1913:
1914: l_title := fnd_message.get();
1915:
1908: avalue => l_login);
1909:
1910: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1911: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1912: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1913:
1914: l_title := fnd_message.get();
1915:
1916: wf_engine.SetItemAttrText(
1910: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1911: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1912: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1913:
1914: l_title := fnd_message.get();
1915:
1916: wf_engine.SetItemAttrText(
1917: itemtype => p_itemtype,
1918: itemkey => p_itemkey,
2104: IF l_message_table.count > 0
2105: THEN
2106: l_message_index := l_message_table.first;
2107:
2108: FND_MESSAGE.SET_NAME
2109: (l_message_table(l_message_index).application_short_name
2110: ,l_message_table(l_message_index).message_name
2111: );
2112:
2109: (l_message_table(l_message_index).application_short_name
2110: ,l_message_table(l_message_index).message_name
2111: );
2112:
2113: FND_MESSAGE.RAISE_ERROR;
2114: END IF;
2115:
2116: END IF;
2117:
2630: itemkey => p_itemkey,
2631: aname => 'APP_START_DATE');
2632:
2633:
2634: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2635: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2636: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2637:
2638: l_title := fnd_message.get();
2631: aname => 'APP_START_DATE');
2632:
2633:
2634: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2635: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2636: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2637:
2638: l_title := fnd_message.get();
2639:
2632:
2633:
2634: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2635: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2636: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2637:
2638: l_title := fnd_message.get();
2639:
2640: wf_engine.SetItemAttrText(
2634: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2635: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2636: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2637:
2638: l_title := fnd_message.get();
2639:
2640: wf_engine.SetItemAttrText(
2641: itemtype => p_itemtype,
2642: itemkey => p_itemkey,
2657: fetch c_find_app_per_id into l_validate_flag;
2658: close c_find_app_per_id;
2659:
2660: if l_validate_flag = 'Y' then
2661: fnd_message.set_name('HXC','HXC_APPR_WF_DESC_NO_PA_MANAGER');
2662: l_description := l_description || fnd_message.get();
2663: end if;
2664:
2665: wf_engine.SetItemAttrText
2658: close c_find_app_per_id;
2659:
2660: if l_validate_flag = 'Y' then
2661: fnd_message.set_name('HXC','HXC_APPR_WF_DESC_NO_PA_MANAGER');
2662: l_description := l_description || fnd_message.get();
2663: end if;
2664:
2665: wf_engine.SetItemAttrText
2666: (itemtype => p_itemtype,
3268: --
3269: -- user not defined an error message, raise OTC default message
3270: -- stub - need our own error message
3271: --
3272: fnd_message.set_name('PAY', 'HR_6648_ELE_ENTRY_FORMULA_ERR');
3273: hr_utility.raise_error;
3274: else
3275: --
3276: -- user has defined message, raise it
3274: else
3275: --
3276: -- user has defined message, raise it
3277: --
3278: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');
3279: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
3280: hr_utility.raise_error;
3281: end if;
3282:
3275: --
3276: -- user has defined message, raise it
3277: --
3278: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');
3279: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
3280: hr_utility.raise_error;
3281: end if;
3282:
3283: elsif l_formula_status = 'W' then
3291: if l_formula_message is null then
3292: --
3293: -- user has not defined an error message
3294: --
3295: fnd_message.set_name('PAY', 'HR_6648_ELE_ENTRY_FORMULA_ERR');
3296: hr_utility.set_warning;
3297: else
3298: --
3299: -- user has defined message, raise it
3297: else
3298: --
3299: -- user has defined message, raise it
3300: --
3301: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');
3302: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
3303: hr_utility.set_warning;
3304: end if;
3305: end if;
3298: --
3299: -- user has defined message, raise it
3300: --
3301: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');
3302: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
3303: hr_utility.set_warning;
3304: end if;
3305: end if;
3306: