DBA Data[Home] [Help]

APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on FND_MESSAGE

Line 312: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');

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

Line 313: l_description := fnd_message.get();

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

Line 316: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');

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:

Line 318: fnd_message.set_token('TOTAL_HOURS',category_timecard_hrs(p_application_period_id,''));

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

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

Line 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:

Line 329: return fnd_message.get();

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

Line 342: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');

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

Line 343: l_description := fnd_message.get();

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

Line 346: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');

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

Line 348: fnd_message.set_token

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;

Line 355: fnd_message.set_token

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;

Line 362: fnd_message.set_token

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;

Line 368: return fnd_message.get();

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,

Line 381: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');

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

Line 382: l_description := fnd_message.get();

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

Line 385: fnd_message.set_name('HXC','HXC_APPR_WF_DESCRIPTION');

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:

Line 387: fnd_message.set_token('TOTAL_HOURS',category_timecard_hrs(p_start_date,p_end_date,p_resource_id,''));

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

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

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

Line 398: return fnd_message.get();

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.

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

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

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

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:

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

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(

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

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,

Line 2108: FND_MESSAGE.SET_NAME

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:

Line 2113: FND_MESSAGE.RAISE_ERROR;

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:

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

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

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

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:

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

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(

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

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,

Line 2661: fnd_message.set_name('HXC','HXC_APPR_WF_DESC_NO_PA_MANAGER');

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

Line 2662: l_description := l_description || fnd_message.get();

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,

Line 3272: fnd_message.set_name('PAY', 'HR_6648_ELE_ENTRY_FORMULA_ERR');

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

Line 3278: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');

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:

Line 3279: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);

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

Line 3295: fnd_message.set_name('PAY', 'HR_6648_ELE_ENTRY_FORMULA_ERR');

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

Line 3301: fnd_message.set_name('PAY', 'HR_ELE_ENTRY_FORMULA_HINT');

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;

Line 3302: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);

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: