eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDPCORE_ERROR dependencies on FND_MESSAGE

Line 407: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_RESUB_NTF_SUBJECT');

403: l_ResubmissionJobID := GetResubmissionJobID(itemtype => PrepareErrorMessage.itemtype,
404: itemkey => PrepareErrorMessage.itemkey);
405:
406: if l_ResubmissionJobID <> 0 then
407: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_RESUB_NTF_SUBJECT');
408: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
409: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
410: FND_MESSAGE.SET_TOKEN('JOBID', to_char(l_ResubmissionJobID));
411: l_NtfSubject := FND_MESSAGE.GET;

Line 408: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);

404: itemkey => PrepareErrorMessage.itemkey);
405:
406: if l_ResubmissionJobID <> 0 then
407: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_RESUB_NTF_SUBJECT');
408: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
409: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
410: FND_MESSAGE.SET_TOKEN('JOBID', to_char(l_ResubmissionJobID));
411: l_NtfSubject := FND_MESSAGE.GET;
412: elsif (l_ErrorType = 'NOTIFY_ERROR') then

Line 409: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);

405:
406: if l_ResubmissionJobID <> 0 then
407: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_RESUB_NTF_SUBJECT');
408: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
409: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
410: FND_MESSAGE.SET_TOKEN('JOBID', to_char(l_ResubmissionJobID));
411: l_NtfSubject := FND_MESSAGE.GET;
412: elsif (l_ErrorType = 'NOTIFY_ERROR') then
413: -- user sent error using NOTIFY_ERROR Macro..

Line 410: FND_MESSAGE.SET_TOKEN('JOBID', to_char(l_ResubmissionJobID));

406: if l_ResubmissionJobID <> 0 then
407: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_RESUB_NTF_SUBJECT');
408: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
409: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
410: FND_MESSAGE.SET_TOKEN('JOBID', to_char(l_ResubmissionJobID));
411: l_NtfSubject := FND_MESSAGE.GET;
412: elsif (l_ErrorType = 'NOTIFY_ERROR') then
413: -- user sent error using NOTIFY_ERROR Macro..
414: FND_MESSAGE.SET_NAME('XDP','XDP_NTF_SBJCT_NTF_ERR');

Line 411: l_NtfSubject := FND_MESSAGE.GET;

407: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_RESUB_NTF_SUBJECT');
408: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
409: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
410: FND_MESSAGE.SET_TOKEN('JOBID', to_char(l_ResubmissionJobID));
411: l_NtfSubject := FND_MESSAGE.GET;
412: elsif (l_ErrorType = 'NOTIFY_ERROR') then
413: -- user sent error using NOTIFY_ERROR Macro..
414: FND_MESSAGE.SET_NAME('XDP','XDP_NTF_SBJCT_NTF_ERR');
415: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);

Line 414: FND_MESSAGE.SET_NAME('XDP','XDP_NTF_SBJCT_NTF_ERR');

410: FND_MESSAGE.SET_TOKEN('JOBID', to_char(l_ResubmissionJobID));
411: l_NtfSubject := FND_MESSAGE.GET;
412: elsif (l_ErrorType = 'NOTIFY_ERROR') then
413: -- user sent error using NOTIFY_ERROR Macro..
414: FND_MESSAGE.SET_NAME('XDP','XDP_NTF_SBJCT_NTF_ERR');
415: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
416: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
417: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);
418: FND_MESSAGE.SET_TOKEN('NOTIFY_ERROR', substr(l_ErrorDesc,1,100));

Line 415: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);

411: l_NtfSubject := FND_MESSAGE.GET;
412: elsif (l_ErrorType = 'NOTIFY_ERROR') then
413: -- user sent error using NOTIFY_ERROR Macro..
414: FND_MESSAGE.SET_NAME('XDP','XDP_NTF_SBJCT_NTF_ERR');
415: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
416: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
417: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);
418: FND_MESSAGE.SET_TOKEN('NOTIFY_ERROR', substr(l_ErrorDesc,1,100));
419: l_NtfSubject := FND_MESSAGE.GET;

Line 416: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);

412: elsif (l_ErrorType = 'NOTIFY_ERROR') then
413: -- user sent error using NOTIFY_ERROR Macro..
414: FND_MESSAGE.SET_NAME('XDP','XDP_NTF_SBJCT_NTF_ERR');
415: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
416: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
417: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);
418: FND_MESSAGE.SET_TOKEN('NOTIFY_ERROR', substr(l_ErrorDesc,1,100));
419: l_NtfSubject := FND_MESSAGE.GET;
420: elsif (l_ErrorType = 'SESSION_LOST') then

Line 417: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);

413: -- user sent error using NOTIFY_ERROR Macro..
414: FND_MESSAGE.SET_NAME('XDP','XDP_NTF_SBJCT_NTF_ERR');
415: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
416: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
417: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);
418: FND_MESSAGE.SET_TOKEN('NOTIFY_ERROR', substr(l_ErrorDesc,1,100));
419: l_NtfSubject := FND_MESSAGE.GET;
420: elsif (l_ErrorType = 'SESSION_LOST') then
421: -- user sent error using NOTIFY_ERROR Macro..

Line 418: FND_MESSAGE.SET_TOKEN('NOTIFY_ERROR', substr(l_ErrorDesc,1,100));

414: FND_MESSAGE.SET_NAME('XDP','XDP_NTF_SBJCT_NTF_ERR');
415: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
416: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
417: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);
418: FND_MESSAGE.SET_TOKEN('NOTIFY_ERROR', substr(l_ErrorDesc,1,100));
419: l_NtfSubject := FND_MESSAGE.GET;
420: elsif (l_ErrorType = 'SESSION_LOST') then
421: -- user sent error using NOTIFY_ERROR Macro..
422: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_SESSION_LOST');

Line 419: l_NtfSubject := FND_MESSAGE.GET;

415: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
416: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
417: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);
418: FND_MESSAGE.SET_TOKEN('NOTIFY_ERROR', substr(l_ErrorDesc,1,100));
419: l_NtfSubject := FND_MESSAGE.GET;
420: elsif (l_ErrorType = 'SESSION_LOST') then
421: -- user sent error using NOTIFY_ERROR Macro..
422: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_SESSION_LOST');
423: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);

Line 422: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_SESSION_LOST');

418: FND_MESSAGE.SET_TOKEN('NOTIFY_ERROR', substr(l_ErrorDesc,1,100));
419: l_NtfSubject := FND_MESSAGE.GET;
420: elsif (l_ErrorType = 'SESSION_LOST') then
421: -- user sent error using NOTIFY_ERROR Macro..
422: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_SESSION_LOST');
423: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
424: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
425: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FeName);
426: l_NtfSubject := FND_MESSAGE.GET;

Line 423: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);

419: l_NtfSubject := FND_MESSAGE.GET;
420: elsif (l_ErrorType = 'SESSION_LOST') then
421: -- user sent error using NOTIFY_ERROR Macro..
422: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_SESSION_LOST');
423: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
424: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
425: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FeName);
426: l_NtfSubject := FND_MESSAGE.GET;
427: else

Line 424: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);

420: elsif (l_ErrorType = 'SESSION_LOST') then
421: -- user sent error using NOTIFY_ERROR Macro..
422: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_SESSION_LOST');
423: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
424: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
425: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FeName);
426: l_NtfSubject := FND_MESSAGE.GET;
427: else
428: --unhandled exception..

Line 425: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FeName);

421: -- user sent error using NOTIFY_ERROR Macro..
422: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_SESSION_LOST');
423: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
424: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
425: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FeName);
426: l_NtfSubject := FND_MESSAGE.GET;
427: else
428: --unhandled exception..
429: lv_fp_name := wf_engine.GetItemAttrText(itemtype => PrepareErrorMessage.itemtype,

Line 426: l_NtfSubject := FND_MESSAGE.GET;

422: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_SESSION_LOST');
423: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
424: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
425: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FeName);
426: l_NtfSubject := FND_MESSAGE.GET;
427: else
428: --unhandled exception..
429: lv_fp_name := wf_engine.GetItemAttrText(itemtype => PrepareErrorMessage.itemtype,
430: itemkey => PrepareErrorMessage.itemkey,

Line 438: FND_MESSAGE.SET_NAME('XDP','XDP_FP_ERR_THRSHD_EXCDED');

434: itemkey =>PrepareErrorMessage.itemkey,
435: actid =>PrepareErrorMessage.actid,
436: aname =>'FP_RETRY');
437: IF ( l_status = 'N' ) THEN
438: FND_MESSAGE.SET_NAME('XDP','XDP_FP_ERR_THRSHD_EXCDED');
439: SELECT display_name INTO lv_fp_disp_name
440: FROM xdp_proc_body_vl
441: WHERE proc_name = lv_fp_name;
442: FND_MESSAGE.SET_TOKEN('FP_NAME', lv_fp_disp_name);

Line 442: FND_MESSAGE.SET_TOKEN('FP_NAME', lv_fp_disp_name);

438: FND_MESSAGE.SET_NAME('XDP','XDP_FP_ERR_THRSHD_EXCDED');
439: SELECT display_name INTO lv_fp_disp_name
440: FROM xdp_proc_body_vl
441: WHERE proc_name = lv_fp_name;
442: FND_MESSAGE.SET_TOKEN('FP_NAME', lv_fp_disp_name);
443: ELSE
444: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_NTF_SUBJECT');
445: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);
446: END IF;

Line 444: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_NTF_SUBJECT');

440: FROM xdp_proc_body_vl
441: WHERE proc_name = lv_fp_name;
442: FND_MESSAGE.SET_TOKEN('FP_NAME', lv_fp_disp_name);
443: ELSE
444: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_NTF_SUBJECT');
445: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);
446: END IF;
447:
448: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);

Line 445: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);

441: WHERE proc_name = lv_fp_name;
442: FND_MESSAGE.SET_TOKEN('FP_NAME', lv_fp_disp_name);
443: ELSE
444: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_NTF_SUBJECT');
445: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);
446: END IF;
447:
448: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
449: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);

Line 448: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);

444: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_NTF_SUBJECT');
445: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);
446: END IF;
447:
448: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
449: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
450: l_NtfSubject := FND_MESSAGE.GET;
451: end if;
452: wf_engine.SetItemAttrText(itemtype => PrepareErrorMessage.itemtype,

Line 449: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);

445: FND_MESSAGE.SET_TOKEN('FA_DISP_NAME', l_FAName);
446: END IF;
447:
448: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
449: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
450: l_NtfSubject := FND_MESSAGE.GET;
451: end if;
452: wf_engine.SetItemAttrText(itemtype => PrepareErrorMessage.itemtype,
453: itemkey => PrepareErrorMessage.itemkey,

Line 450: l_NtfSubject := FND_MESSAGE.GET;

446: END IF;
447:
448: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_OrderNumber);
449: FND_MESSAGE.SET_TOKEN('ORD_VER', l_OrderVersion);
450: l_NtfSubject := FND_MESSAGE.GET;
451: end if;
452: wf_engine.SetItemAttrText(itemtype => PrepareErrorMessage.itemtype,
453: itemkey => PrepareErrorMessage.itemkey,
454: aname => 'NTF_SUBJECT',

Line 459: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_NTF_ORD_DESC');

455: avalue => l_NtfSubject);
456:
457:
458:
459: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_NTF_ORD_DESC');
460: FND_MESSAGE.SET_TOKEN('ORDER_ID', to_char(l_OrderID));
461: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', l_OrderNumber);
462: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', l_OrderVersion);
463: FND_MESSAGE.SET_TOKEN('FA', l_FAName);

Line 460: FND_MESSAGE.SET_TOKEN('ORDER_ID', to_char(l_OrderID));

456:
457:
458:
459: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_NTF_ORD_DESC');
460: FND_MESSAGE.SET_TOKEN('ORDER_ID', to_char(l_OrderID));
461: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', l_OrderNumber);
462: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', l_OrderVersion);
463: FND_MESSAGE.SET_TOKEN('FA', l_FAName);
464: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FEName);

Line 461: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', l_OrderNumber);

457:
458:
459: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_NTF_ORD_DESC');
460: FND_MESSAGE.SET_TOKEN('ORDER_ID', to_char(l_OrderID));
461: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', l_OrderNumber);
462: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', l_OrderVersion);
463: FND_MESSAGE.SET_TOKEN('FA', l_FAName);
464: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FEName);
465: FND_MESSAGE.SET_TOKEN('WI', l_WIName);

Line 462: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', l_OrderVersion);

458:
459: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_NTF_ORD_DESC');
460: FND_MESSAGE.SET_TOKEN('ORDER_ID', to_char(l_OrderID));
461: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', l_OrderNumber);
462: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', l_OrderVersion);
463: FND_MESSAGE.SET_TOKEN('FA', l_FAName);
464: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FEName);
465: FND_MESSAGE.SET_TOKEN('WI', l_WIName);
466: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);

Line 463: FND_MESSAGE.SET_TOKEN('FA', l_FAName);

459: FND_MESSAGE.SET_NAME('XDP','XDP_FMC_NTF_ORD_DESC');
460: FND_MESSAGE.SET_TOKEN('ORDER_ID', to_char(l_OrderID));
461: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', l_OrderNumber);
462: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', l_OrderVersion);
463: FND_MESSAGE.SET_TOKEN('FA', l_FAName);
464: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FEName);
465: FND_MESSAGE.SET_TOKEN('WI', l_WIName);
466: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);
467:

Line 464: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FEName);

460: FND_MESSAGE.SET_TOKEN('ORDER_ID', to_char(l_OrderID));
461: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', l_OrderNumber);
462: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', l_OrderVersion);
463: FND_MESSAGE.SET_TOKEN('FA', l_FAName);
464: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FEName);
465: FND_MESSAGE.SET_TOKEN('WI', l_WIName);
466: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);
467:
468: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

Line 465: FND_MESSAGE.SET_TOKEN('WI', l_WIName);

461: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', l_OrderNumber);
462: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', l_OrderVersion);
463: FND_MESSAGE.SET_TOKEN('FA', l_FAName);
464: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FEName);
465: FND_MESSAGE.SET_TOKEN('WI', l_WIName);
466: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);
467:
468: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
469: FND_MESSAGE.SET_TOKEN('ERROR_DESCRIPTION', substr(l_ErrorDesc,1,1000));

Line 466: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);

462: FND_MESSAGE.SET_TOKEN('ORDER_VERSION', l_OrderVersion);
463: FND_MESSAGE.SET_TOKEN('FA', l_FAName);
464: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FEName);
465: FND_MESSAGE.SET_TOKEN('WI', l_WIName);
466: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);
467:
468: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
469: FND_MESSAGE.SET_TOKEN('ERROR_DESCRIPTION', substr(l_ErrorDesc,1,1000));
470:

Line 468: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

464: FND_MESSAGE.SET_TOKEN('FE_NAME', l_FEName);
465: FND_MESSAGE.SET_TOKEN('WI', l_WIName);
466: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);
467:
468: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
469: FND_MESSAGE.SET_TOKEN('ERROR_DESCRIPTION', substr(l_ErrorDesc,1,1000));
470:
471: l_NtfDesc := FND_MESSAGE.GET;
472: --l_NtfDesc := l_NtfDesc || chr(10) || XDPCORE.error_stack;

Line 469: FND_MESSAGE.SET_TOKEN('ERROR_DESCRIPTION', substr(l_ErrorDesc,1,1000));

465: FND_MESSAGE.SET_TOKEN('WI', l_WIName);
466: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);
467:
468: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
469: FND_MESSAGE.SET_TOKEN('ERROR_DESCRIPTION', substr(l_ErrorDesc,1,1000));
470:
471: l_NtfDesc := FND_MESSAGE.GET;
472: --l_NtfDesc := l_NtfDesc || chr(10) || XDPCORE.error_stack;
473:

Line 471: l_NtfDesc := FND_MESSAGE.GET;

467:
468: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
469: FND_MESSAGE.SET_TOKEN('ERROR_DESCRIPTION', substr(l_ErrorDesc,1,1000));
470:
471: l_NtfDesc := FND_MESSAGE.GET;
472: --l_NtfDesc := l_NtfDesc || chr(10) || XDPCORE.error_stack;
473:
474: --Date: 21-Feb-2005 Author:dputhiye Bug#:4112678 (Bug 3998762 on 11.5.9)
475: --l_NtfDesc := l_NtfDesc || fnd_global.local_chr(10) || XDPCORE.error_stack;

Line 612: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_DETAILS');

608: aname => 'LINE_ITEM_ID');
609:
610: SELECT line_item_name INTO l_LineName FROM xdp_order_line_items WHERE line_item_id = l_LineID;
611:
612: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_DETAILS');
613: FND_MESSAGE.SET_TOKEN('ORD_NUM', l_order_number);
614: FND_MESSAGE.SET_TOKEN('ORD_VER', l_order_version);
615: FND_MESSAGE.SET_TOKEN('ORD_ID', l_OrderID);
616: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);

Line 613: FND_MESSAGE.SET_TOKEN('ORD_NUM', l_order_number);

609:
610: SELECT line_item_name INTO l_LineName FROM xdp_order_line_items WHERE line_item_id = l_LineID;
611:
612: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_DETAILS');
613: FND_MESSAGE.SET_TOKEN('ORD_NUM', l_order_number);
614: FND_MESSAGE.SET_TOKEN('ORD_VER', l_order_version);
615: FND_MESSAGE.SET_TOKEN('ORD_ID', l_OrderID);
616: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);
617: l_NtfBody := l_NtfBody || FND_MESSAGE.GET;

Line 614: FND_MESSAGE.SET_TOKEN('ORD_VER', l_order_version);

610: SELECT line_item_name INTO l_LineName FROM xdp_order_line_items WHERE line_item_id = l_LineID;
611:
612: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_DETAILS');
613: FND_MESSAGE.SET_TOKEN('ORD_NUM', l_order_number);
614: FND_MESSAGE.SET_TOKEN('ORD_VER', l_order_version);
615: FND_MESSAGE.SET_TOKEN('ORD_ID', l_OrderID);
616: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);
617: l_NtfBody := l_NtfBody || FND_MESSAGE.GET;
618:

Line 615: FND_MESSAGE.SET_TOKEN('ORD_ID', l_OrderID);

611:
612: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_DETAILS');
613: FND_MESSAGE.SET_TOKEN('ORD_NUM', l_order_number);
614: FND_MESSAGE.SET_TOKEN('ORD_VER', l_order_version);
615: FND_MESSAGE.SET_TOKEN('ORD_ID', l_OrderID);
616: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);
617: l_NtfBody := l_NtfBody || FND_MESSAGE.GET;
618:
619: begin

Line 616: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);

612: FND_MESSAGE.SET_NAME('XDP','XDP_ORDER_DETAILS');
613: FND_MESSAGE.SET_TOKEN('ORD_NUM', l_order_number);
614: FND_MESSAGE.SET_TOKEN('ORD_VER', l_order_version);
615: FND_MESSAGE.SET_TOKEN('ORD_ID', l_OrderID);
616: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);
617: l_NtfBody := l_NtfBody || FND_MESSAGE.GET;
618:
619: begin
620: l_WIInstaceID := wf_engine.GetItemAttrNumber(itemtype => SetErrorContext.itemtype,

Line 617: l_NtfBody := l_NtfBody || FND_MESSAGE.GET;

613: FND_MESSAGE.SET_TOKEN('ORD_NUM', l_order_number);
614: FND_MESSAGE.SET_TOKEN('ORD_VER', l_order_version);
615: FND_MESSAGE.SET_TOKEN('ORD_ID', l_OrderID);
616: FND_MESSAGE.SET_TOKEN('LINE_NAME', l_LineName);
617: l_NtfBody := l_NtfBody || FND_MESSAGE.GET;
618:
619: begin
620: l_WIInstaceID := wf_engine.GetItemAttrNumber(itemtype => SetErrorContext.itemtype,
621: itemkey => SetErrorContext.itemkey,

Line 626: FND_MESSAGE.SET_NAME('XDP','XDP_WI_DISP_NAME');

622: aname => 'WORKITEM_INSTANCE_ID');
623:
624: l_wi_disp_name := XDPCORE_WI.get_display_name( l_WIInstaceID );
625:
626: FND_MESSAGE.SET_NAME('XDP','XDP_WI_DISP_NAME');
627: FND_MESSAGE.SET_TOKEN('WI', l_wi_disp_name);
628: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
629: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
630:

Line 627: FND_MESSAGE.SET_TOKEN('WI', l_wi_disp_name);

623:
624: l_wi_disp_name := XDPCORE_WI.get_display_name( l_WIInstaceID );
625:
626: FND_MESSAGE.SET_NAME('XDP','XDP_WI_DISP_NAME');
627: FND_MESSAGE.SET_TOKEN('WI', l_wi_disp_name);
628: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
629: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
630:
631:

Line 628: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);

624: l_wi_disp_name := XDPCORE_WI.get_display_name( l_WIInstaceID );
625:
626: FND_MESSAGE.SET_NAME('XDP','XDP_WI_DISP_NAME');
627: FND_MESSAGE.SET_TOKEN('WI', l_wi_disp_name);
628: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
629: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
630:
631:
632: XDP_NOTIFICATIONS.Get_WI_Update_URL(l_WIInstaceID,

Line 629: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);

625:
626: FND_MESSAGE.SET_NAME('XDP','XDP_WI_DISP_NAME');
627: FND_MESSAGE.SET_TOKEN('WI', l_wi_disp_name);
628: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
629: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
630:
631:
632: XDP_NOTIFICATIONS.Get_WI_Update_URL(l_WIInstaceID,
633: l_OrderID,

Line 658: FND_MESSAGE.SET_NAME('XDP','XDP_FA_DISP_NAME');

654: aname => 'FA_INSTANCE_ID');
655:
656: l_fa_disp_name := XDPCORE_FA.get_display_name( l_FAInstanceID );
657:
658: FND_MESSAGE.SET_NAME('XDP','XDP_FA_DISP_NAME');
659: FND_MESSAGE.SET_TOKEN('FA', l_fa_disp_name);
660: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
661: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
662: exception

Line 659: FND_MESSAGE.SET_TOKEN('FA', l_fa_disp_name);

655:
656: l_fa_disp_name := XDPCORE_FA.get_display_name( l_FAInstanceID );
657:
658: FND_MESSAGE.SET_NAME('XDP','XDP_FA_DISP_NAME');
659: FND_MESSAGE.SET_TOKEN('FA', l_fa_disp_name);
660: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
661: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
662: exception
663: when others then

Line 660: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);

656: l_fa_disp_name := XDPCORE_FA.get_display_name( l_FAInstanceID );
657:
658: FND_MESSAGE.SET_NAME('XDP','XDP_FA_DISP_NAME');
659: FND_MESSAGE.SET_TOKEN('FA', l_fa_disp_name);
660: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
661: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
662: exception
663: when others then
664: --not at FA level do nothing..

Line 661: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);

657:
658: FND_MESSAGE.SET_NAME('XDP','XDP_FA_DISP_NAME');
659: FND_MESSAGE.SET_TOKEN('FA', l_fa_disp_name);
660: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
661: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
662: exception
663: when others then
664: --not at FA level do nothing..
665: null;

Line 669: FND_MESSAGE.SET_NAME('XDP', 'XDP_ERROR_DATE');

665: null;
666: end;
667:
668: -- set error date..
669: FND_MESSAGE.SET_NAME('XDP', 'XDP_ERROR_DATE');
670: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
671: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
672: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
673:

Line 670: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

666: end;
667:
668: -- set error date..
669: FND_MESSAGE.SET_NAME('XDP', 'XDP_ERROR_DATE');
670: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
671: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
672: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
673:
674: l_NtfSubject := l_order_number||' ( '||l_order_version||' ):';

Line 671: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);

667:
668: -- set error date..
669: FND_MESSAGE.SET_NAME('XDP', 'XDP_ERROR_DATE');
670: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
671: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
672: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
673:
674: l_NtfSubject := l_order_number||' ( '||l_order_version||' ):';
675: -- get error set in the context..

Line 672: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);

668: -- set error date..
669: FND_MESSAGE.SET_NAME('XDP', 'XDP_ERROR_DATE');
670: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
671: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);
672: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
673:
674: l_NtfSubject := l_order_number||' ( '||l_order_version||' ):';
675: -- get error set in the context..
676: XDPCORE.get_error(l_object_type, l_object_key,