47: else
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;
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;
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;
57: if ar_doc_transfer_standard.isDebugOn then
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;
57: if ar_doc_transfer_standard.isDebugOn then
58: ar_doc_transfer_standard.debug('p_int_ctr_num:'||p_int_ctr_num);
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;
57: if ar_doc_transfer_standard.isDebugOn then
58: ar_doc_transfer_standard.debug('p_int_ctr_num:'||p_int_ctr_num);
59: ar_doc_transfer_standard.debug('l_msgid:'||l_msgid);
60: end if;
61: open action; fetch action into l_handler_name, l_handler_type; close action;
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;
57: if ar_doc_transfer_standard.isDebugOn then
58: ar_doc_transfer_standard.debug('p_int_ctr_num:'||p_int_ctr_num);
59: ar_doc_transfer_standard.debug('l_msgid:'||l_msgid);
60: end if;
61: open action; fetch action into l_handler_name, l_handler_type; close action;
62: if l_handler_type = 'PLSQL' and l_handler_name is not null then
55: end if;
56: open msgid; fetch msgid into l_msgid; close msgid;
57: if ar_doc_transfer_standard.isDebugOn then
58: ar_doc_transfer_standard.debug('p_int_ctr_num:'||p_int_ctr_num);
59: ar_doc_transfer_standard.debug('l_msgid:'||l_msgid);
60: end if;
61: open action; fetch action into l_handler_name, l_handler_type; close action;
62: if l_handler_type = 'PLSQL' and l_handler_name is not null then
63: l_plsql := 'BEGIN '||l_handler_name||'(:status,:id,:reason_code,:description,:msgid); END;';
60: end if;
61: open action; fetch action into l_handler_name, l_handler_type; close action;
62: if l_handler_type = 'PLSQL' and l_handler_name is not null then
63: l_plsql := 'BEGIN '||l_handler_name||'(:status,:id,:reason_code,:description,:msgid); END;';
64: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('l_plsql:'||l_plsql); end if;
65: execute immediate l_plsql using p_status, p_id, p_reason_code, p_description, l_msgid;
66:
67: elsif l_handler_type = 'EVENT' and l_handler_name is not null then
68: wf_event.AddParameterToList(
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||