91: l_subject varchar2(200);
92: l_body varchar2(4000);
93: begin
94: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_CONFIRMATION_ACTION.notifyToSysadmin(+)'); end if;
95: fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_SBJ');
96: l_subject := fnd_message.get;
97: fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_BODY');
98: fnd_message.set_token('P_ID', p_id);
99: l_body := fnd_message.get;
92: l_body varchar2(4000);
93: begin
94: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_CONFIRMATION_ACTION.notifyToSysadmin(+)'); end if;
95: fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_SBJ');
96: l_subject := fnd_message.get;
97: fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_BODY');
98: fnd_message.set_token('P_ID', p_id);
99: l_body := fnd_message.get;
100: ar_notification_standard.notifyToSysadmin(l_subject, l_body);
93: begin
94: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_CONFIRMATION_ACTION.notifyToSysadmin(+)'); end if;
95: fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_SBJ');
96: l_subject := fnd_message.get;
97: fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_BODY');
98: fnd_message.set_token('P_ID', p_id);
99: l_body := fnd_message.get;
100: ar_notification_standard.notifyToSysadmin(l_subject, l_body);
101: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_CONFIRMATION_ACTION.notifyToSysadmin(-)'); end if;
94: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_CONFIRMATION_ACTION.notifyToSysadmin(+)'); end if;
95: fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_SBJ');
96: l_subject := fnd_message.get;
97: fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_BODY');
98: fnd_message.set_token('P_ID', p_id);
99: l_body := fnd_message.get;
100: ar_notification_standard.notifyToSysadmin(l_subject, l_body);
101: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_CONFIRMATION_ACTION.notifyToSysadmin(-)'); end if;
102: end;
95: fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_SBJ');
96: l_subject := fnd_message.get;
97: fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_BODY');
98: fnd_message.set_token('P_ID', p_id);
99: l_body := fnd_message.get;
100: ar_notification_standard.notifyToSysadmin(l_subject, l_body);
101: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_CONFIRMATION_ACTION.notifyToSysadmin(-)'); end if;
102: end;
103:
129: p_trx_number => l_trx_number,
130: p_trx_date => l_trx_date,
131: p_currency => l_invoice_currency,
132: p_line_number => l_line_number) then
133: fnd_message.set_name('AR', 'AR_CONF_ACT_CUST_MSG_SBJ');
134: l_subject := fnd_message.get;
135: if l_line_number is null then
136: fnd_message.set_name('AR','AR_CONF_ACT_CUST_MSG_BODY1');
137: else
130: p_trx_date => l_trx_date,
131: p_currency => l_invoice_currency,
132: p_line_number => l_line_number) then
133: fnd_message.set_name('AR', 'AR_CONF_ACT_CUST_MSG_SBJ');
134: l_subject := fnd_message.get;
135: if l_line_number is null then
136: fnd_message.set_name('AR','AR_CONF_ACT_CUST_MSG_BODY1');
137: else
138: fnd_message.set_name('AR','AR_CONF_ACT_CUST_MSG_BODY2');
132: p_line_number => l_line_number) then
133: fnd_message.set_name('AR', 'AR_CONF_ACT_CUST_MSG_SBJ');
134: l_subject := fnd_message.get;
135: if l_line_number is null then
136: fnd_message.set_name('AR','AR_CONF_ACT_CUST_MSG_BODY1');
137: else
138: fnd_message.set_name('AR','AR_CONF_ACT_CUST_MSG_BODY2');
139: fnd_message.set_token('LINE_NUMBER',to_char(l_line_number));
140: end if;
134: l_subject := fnd_message.get;
135: if l_line_number is null then
136: fnd_message.set_name('AR','AR_CONF_ACT_CUST_MSG_BODY1');
137: else
138: fnd_message.set_name('AR','AR_CONF_ACT_CUST_MSG_BODY2');
139: fnd_message.set_token('LINE_NUMBER',to_char(l_line_number));
140: end if;
141: fnd_message.set_token('TRX_NUMBER', l_trx_number);
142: --Int'l Calendar Project
135: if l_line_number is null then
136: fnd_message.set_name('AR','AR_CONF_ACT_CUST_MSG_BODY1');
137: else
138: fnd_message.set_name('AR','AR_CONF_ACT_CUST_MSG_BODY2');
139: fnd_message.set_token('LINE_NUMBER',to_char(l_line_number));
140: end if;
141: fnd_message.set_token('TRX_NUMBER', l_trx_number);
142: --Int'l Calendar Project
143: fnd_message.set_token('TRX_DATE', fnd_date.date_to_chardate(l_trx_date, calendar_aware=> FND_DATE.calendar_aware_alt));
137: else
138: fnd_message.set_name('AR','AR_CONF_ACT_CUST_MSG_BODY2');
139: fnd_message.set_token('LINE_NUMBER',to_char(l_line_number));
140: end if;
141: fnd_message.set_token('TRX_NUMBER', l_trx_number);
142: --Int'l Calendar Project
143: fnd_message.set_token('TRX_DATE', fnd_date.date_to_chardate(l_trx_date, calendar_aware=> FND_DATE.calendar_aware_alt));
144: fnd_message.set_token('CURRENCY', l_invoice_currency);
145: l_body := fnd_message.get||fnd_global.newline||fnd_global.newline;
139: fnd_message.set_token('LINE_NUMBER',to_char(l_line_number));
140: end if;
141: fnd_message.set_token('TRX_NUMBER', l_trx_number);
142: --Int'l Calendar Project
143: fnd_message.set_token('TRX_DATE', fnd_date.date_to_chardate(l_trx_date, calendar_aware=> FND_DATE.calendar_aware_alt));
144: fnd_message.set_token('CURRENCY', l_invoice_currency);
145: l_body := fnd_message.get||fnd_global.newline||fnd_global.newline;
146: open ap_lookups; fetch ap_lookups into l_msg; close ap_lookups;
147: l_body := l_body||l_msg;
140: end if;
141: fnd_message.set_token('TRX_NUMBER', l_trx_number);
142: --Int'l Calendar Project
143: fnd_message.set_token('TRX_DATE', fnd_date.date_to_chardate(l_trx_date, calendar_aware=> FND_DATE.calendar_aware_alt));
144: fnd_message.set_token('CURRENCY', l_invoice_currency);
145: l_body := fnd_message.get||fnd_global.newline||fnd_global.newline;
146: open ap_lookups; fetch ap_lookups into l_msg; close ap_lookups;
147: l_body := l_body||l_msg;
148: l_url := 'JSP:/OA_HTML/OA.jsp?akRegionCode=ARDOCTRSPG'||'&'||
141: fnd_message.set_token('TRX_NUMBER', l_trx_number);
142: --Int'l Calendar Project
143: fnd_message.set_token('TRX_DATE', fnd_date.date_to_chardate(l_trx_date, calendar_aware=> FND_DATE.calendar_aware_alt));
144: fnd_message.set_token('CURRENCY', l_invoice_currency);
145: l_body := fnd_message.get||fnd_global.newline||fnd_global.newline;
146: open ap_lookups; fetch ap_lookups into l_msg; close ap_lookups;
147: l_body := l_body||l_msg;
148: l_url := 'JSP:/OA_HTML/OA.jsp?akRegionCode=ARDOCTRSPG'||'&'||
149: 'akRegionApplicationId=222'||'&'||