DBA Data[Home] [Help]

APPS.AR_CONFIRMATION dependencies on STANDARD

Line 45: ar_notification_standard.notifyToSysadmin(l_subject, l_sqlerrm);

41: l_subject := fnd_message.get;
42: fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_BODY');
43: fnd_message.set_token('P_ID', p_id);
44: l_sqlerrm := fnd_message.get;
45: ar_notification_standard.notifyToSysadmin(l_subject, l_sqlerrm);
46: return;
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);

Line 51: if ar_doc_transfer_standard.isDebugOn then

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;

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 53: ar_doc_transfer_standard.debug('p_status:'||p_status);

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

Line 54: ar_doc_transfer_standard.debug('p_reason_code:'||p_reason_code);

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

Line 57: if ar_doc_transfer_standard.isDebugOn then

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;

Line 58: ar_doc_transfer_standard.debug('p_int_ctr_num:'||p_int_ctr_num);

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

Line 59: ar_doc_transfer_standard.debug('l_msgid:'||l_msgid);

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;';

Line 64: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('l_plsql:'||l_plsql); end if;

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(

Line 105: ar_notification_standard.notify(l_subject,

101:
102: l_url := 'JSP:/OA_HTML/OA.jsp?akRegionCode=CONFIRMATIONACTIONS_PG'||'&'||
103: 'akRegionApplicationId=222';
104: for ar_rec in ar loop
105: ar_notification_standard.notify(l_subject,
106: l_sqlerrm,
107: ar_rec.role_name,
108: l_url);
109: end loop;

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 119: ar_notification_standard.notifyToSysadmin(l_subject, l_sqlerrm);

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);
120: end;
121: end;