APPS.AR_CONFIRMATION dependencies on AR_CONFIRMATION

Line 1: package body AR_CONFIRMATION AS

1: package body AR_CONFIRMATION AS
2: /*$Header: ARCONFMB.pls 115.3 2002/12/23 22:23:36 tkoshio noship $ */
3:
4: procedure initiate_confirmation_process(P_STATUS in VARCHAR2,
5: P_ID in VARCHAR2,

Line 14: select handler_name, handler_type from ar_confirmation_actions

10: select DISTINCT 'FND_RESP222:'||to_char(responsibility_id) role_name
11: from fnd_responsibility_tl
12: where application_id = 222;
13: cursor action is
14: select handler_name, handler_type from ar_confirmation_actions
15: where status = p_status and (reason_code = p_reason_code or p_reason_code is null);
16: cursor msgid is
17: select msgid from ecx_doclogs where internal_control_number = p_int_ctr_num;
18: l_handler_name varchar2(70);

Line 52: ar_doc_transfer_standard.debug('AR_CONFIRMATION.initiate_confirmation_process(+)');

48: fnd_global.initialize(l_sid, global_rec.last_updated_by, global_rec.responsibility_id,
49: global_rec.application_id, null,null,0,0,null,null,null,null);
50: end if;
51: if ar_doc_transfer_standard.isDebugOn then
52: ar_doc_transfer_standard.debug('AR_CONFIRMATION.initiate_confirmation_process(+)');
53: ar_doc_transfer_standard.debug('p_status:'||p_status);
54: ar_doc_transfer_standard.debug('p_reason_code:'||p_reason_code);
55: end if;
56: open msgid; fetch msgid into l_msgid; close msgid;

Line 111: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_CONFIRMATION.initiate_confirmation_process(-)'); end if;

107: ar_rec.role_name,
108: l_url);
109: end loop;
110: end if;
111: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_CONFIRMATION.initiate_confirmation_process(-)'); end if;
112: exception
113: when others then
114: l_sqlerrm := sqlerrm || fnd_global.newline||
115: 'Location: AR_CONFIRMATION.initiate_confirmation_process()'||fnd_global.newline||

Line 115: 'Location: AR_CONFIRMATION.initiate_confirmation_process()'||fnd_global.newline||

111: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_CONFIRMATION.initiate_confirmation_process(-)'); end if;
112: exception
113: when others then
114: l_sqlerrm := sqlerrm || fnd_global.newline||
115: 'Location: AR_CONFIRMATION.initiate_confirmation_process()'||fnd_global.newline||
116: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
117: fnd_message.set_name('AR','AR_CONF_ERROR');
118: l_subject := fnd_message.get;
119: ar_notification_standard.notifyToSysadmin(l_subject, l_sqlerrm);