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 2051: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');

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

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

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:

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

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(

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

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,

Line 2249: FND_MESSAGE.SET_NAME

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:

Line 2254: FND_MESSAGE.RAISE_ERROR;

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:

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

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

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

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:

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

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(

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

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,

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

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

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

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,

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

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

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

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:

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

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

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

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

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

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;

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

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: