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.
2047: itemkey => p_itemkey,
2048: aname => 'TC_APPROVER_FROM_ROLE',
2049: avalue => l_login);
2050:
2051: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2052: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2053: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2054:
2055: l_title := fnd_message.get();
2048: aname => 'TC_APPROVER_FROM_ROLE',
2049: avalue => l_login);
2050:
2051: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2052: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2053: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2054:
2055: l_title := fnd_message.get();
2056:
2049: avalue => l_login);
2050:
2051: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2052: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2053: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2054:
2055: l_title := fnd_message.get();
2056:
2057: wf_engine.SetItemAttrText(
2051: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2052: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2053: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2054:
2055: l_title := fnd_message.get();
2056:
2057: wf_engine.SetItemAttrText(
2058: itemtype => p_itemtype,
2059: itemkey => p_itemkey,
2245: IF l_message_table.count > 0
2246: THEN
2247: l_message_index := l_message_table.first;
2248:
2249: FND_MESSAGE.SET_NAME
2250: (l_message_table(l_message_index).application_short_name
2251: ,l_message_table(l_message_index).message_name
2252: );
2253:
2250: (l_message_table(l_message_index).application_short_name
2251: ,l_message_table(l_message_index).message_name
2252: );
2253:
2254: FND_MESSAGE.RAISE_ERROR;
2255: END IF;
2256:
2257: END IF;
2258:
2771: itemkey => p_itemkey,
2772: aname => 'APP_START_DATE');
2773:
2774:
2775: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2776: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2777: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2778:
2779: l_title := fnd_message.get();
2772: aname => 'APP_START_DATE');
2773:
2774:
2775: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2776: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2777: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2778:
2779: l_title := fnd_message.get();
2780:
2773:
2774:
2775: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2776: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2777: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2778:
2779: l_title := fnd_message.get();
2780:
2781: wf_engine.SetItemAttrText(
2775: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
2776: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2777: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
2778:
2779: l_title := fnd_message.get();
2780:
2781: wf_engine.SetItemAttrText(
2782: itemtype => p_itemtype,
2783: itemkey => p_itemkey,
2798: fetch c_find_app_per_id into l_validate_flag;
2799: close c_find_app_per_id;
2800:
2801: if l_validate_flag = 'Y' then
2802: fnd_message.set_name('HXC','HXC_APPR_WF_DESC_NO_PA_MANAGER');
2803: l_description := l_description || fnd_message.get();
2804: end if;
2805:
2806: wf_engine.SetItemAttrText
2799: close c_find_app_per_id;
2800:
2801: if l_validate_flag = 'Y' then
2802: fnd_message.set_name('HXC','HXC_APPR_WF_DESC_NO_PA_MANAGER');
2803: l_description := l_description || fnd_message.get();
2804: end if;
2805:
2806: wf_engine.SetItemAttrText
2807: (itemtype => p_itemtype,
3474: --
3475: -- user not defined an error message, raise OTC default message
3476: -- stub - need our own error message
3477: --
3478: fnd_message.set_name('PAY', 'HR_6648_ELE_ENTRY_FORMULA_ERR');
3479: hr_utility.raise_error;
3480: else
3481: --
3482: -- user has defined message, raise it
3480: else
3481: --
3482: -- user has defined message, raise it
3483: --
3484: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');
3485: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
3486: hr_utility.raise_error;
3487: end if;
3488:
3481: --
3482: -- user has defined message, raise it
3483: --
3484: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');
3485: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
3486: hr_utility.raise_error;
3487: end if;
3488:
3489: elsif l_formula_status = 'W' then
3497: if l_formula_message is null then
3498: --
3499: -- user has not defined an error message
3500: --
3501: fnd_message.set_name('PAY', 'HR_6648_ELE_ENTRY_FORMULA_ERR');
3502: hr_utility.set_warning;
3503: else
3504: --
3505: -- user has defined message, raise it
3503: else
3504: --
3505: -- user has defined message, raise it
3506: --
3507: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');
3508: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
3509: hr_utility.set_warning;
3510: end if;
3511: end if;
3504: --
3505: -- user has defined message, raise it
3506: --
3507: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');
3508: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
3509: hr_utility.set_warning;
3510: end if;
3511: end if;
3512: