DBA Data[Home] [Help]

APPS.ECX_WORKFLOW_HTML dependencies on ECXMSG

Line 4: -- ListECXMSGQueueMessages

1: package body ECX_WORKFLOW_HTML as
2: /* $Header: ECXWHTMB.pls 120.9 2006/03/16 02:04:55 gsingh ship $ */
3:
4: -- ListECXMSGQueueMessages
5: -- Lists Queue Messages for ECXMSG ADT
6: -- in P_QUEUE_NAME Queue Name
7: -- in P_TRANSACTION_TYPE ECX Transaction Type
8: -- in P_DOCUMENT_NUMBER ECX Document Number

Line 5: -- Lists Queue Messages for ECXMSG ADT

1: package body ECX_WORKFLOW_HTML as
2: /* $Header: ECXWHTMB.pls 120.9 2006/03/16 02:04:55 gsingh ship $ */
3:
4: -- ListECXMSGQueueMessages
5: -- Lists Queue Messages for ECXMSG ADT
6: -- in P_QUEUE_NAME Queue Name
7: -- in P_TRANSACTION_TYPE ECX Transaction Type
8: -- in P_DOCUMENT_NUMBER ECX Document Number
9: -- in P_PARTY_SITE_ID ECX Party Site Id

Line 13: procedure ListECXMSGQueueMessages (

9: -- in P_PARTY_SITE_ID ECX Party Site Id
10: -- in P_MESSAGE_STATUS Queue Message Status
11: -- in P_MESSAGE_ID Queue Message Id
12:
13: procedure ListECXMSGQueueMessages (
14: P_QUEUE_NAME in varchar2 ,
15: P_TRANSACTION_TYPE in varchar2 ,
16: P_DOCUMENT_NUMBER in varchar2 ,
17: P_PARTY_SITE_ID in varchar2 ,

Line 49: l_message system.ecxmsg;

45: l_qtable varchar2(240);
46: l_liketranstype varchar2(240);
47: l_likedocnumber varchar2(240);
48: l_likepartysiteid varchar2(240);
49: l_message system.ecxmsg;
50: l_sqlstmt varchar2(32000);
51:
52: begin
53: -- Check current user has admin authority

Line 78: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindECXMSGQueue

74: htp.p('');
75: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
76: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
77: htp.headClose;
78: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindECXMSGQueue
79: Message?p_queue_name='||p_queue_name||'&'||'p_type=ECXMSG', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
80: htp.br;
81:
82: IF (admin_mode = 'N') THEN

Line 79: Message?p_queue_name='||p_queue_name||'&'||'p_type=ECXMSG', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);

75: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
76: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
77: htp.headClose;
78: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindECXMSGQueue
79: Message?p_queue_name='||p_queue_name||'&'||'p_type=ECXMSG', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
80: htp.br;
81:
82: IF (admin_mode = 'N') THEN
83: htp.center(htf.bold(l_error_msg));

Line 416: Wf_Core.Context('ECX_WORKFLOW_HTML', 'ListECXMSGQueueMessages',

412:
413: exception
414: when others then
415: rollback;
416: Wf_Core.Context('ECX_WORKFLOW_HTML', 'ListECXMSGQueueMessages',
417: p_queue_name);
418: wfe_html_util.Error;
419: --raise;
420: end ListECXMSGQueueMessages;

Line 420: end ListECXMSGQueueMessages;

416: Wf_Core.Context('ECX_WORKFLOW_HTML', 'ListECXMSGQueueMessages',
417: p_queue_name);
418: wfe_html_util.Error;
419: --raise;
420: end ListECXMSGQueueMessages;
421:
422:
423: -- ListECX_INENGOBJQueueMessages
424: -- Lists Queue Messages for ECX_INENGOBJ ADT