eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROGRAM_BR_REMIT dependencies on ARP_PROGRAM_BR_REMIT

Line 1: PACKAGE BODY ARP_PROGRAM_BR_REMIT AS

1: PACKAGE BODY ARP_PROGRAM_BR_REMIT AS
2: /* $Header: ARBRRMPB.pls 120.15 2010/06/02 10:19:03 dgaurab ship $*/
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'ARP_PROGRAM_BR_REMIT';
5:

Line 4: G_PKG_NAME CONSTANT varchar2(30) := 'ARP_PROGRAM_BR_REMIT';

1: PACKAGE BODY ARP_PROGRAM_BR_REMIT AS
2: /* $Header: ARBRRMPB.pls 120.15 2010/06/02 10:19:03 dgaurab ship $*/
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'ARP_PROGRAM_BR_REMIT';
5:
6: pg_Date_Format CONSTANT VARCHAR2(20) := 'DD-MON-RR';
7:
8: TYPE CUR_TYP IS REF CURSOR;

Line 201: ARP_PROGRAM_BR_REMIT.create_remit_pvt(

197:
198: -- Create remittance
199: IF (p_create_flag = 'Y') THEN
200:
201: ARP_PROGRAM_BR_REMIT.create_remit_pvt(
202: l_batch_id,
203: l_remit_total_low,
204: l_remit_total_high,
205: l_maturity_date_low,

Line 238: ARP_PROGRAM_BR_REMIT.cancel_remit_pvt(l_batch_id);

234: -- an EXCEPTION do not proceed
235:
236: -- Cancel remittance
237: IF p_cancel_flag = 'Y' and instr(process_status,'EXCEPTION') = 0 THEN
238: ARP_PROGRAM_BR_REMIT.cancel_remit_pvt(l_batch_id);
239: END IF;
240:
241: -- Approve remittance
242: IF p_approve_flag = 'Y' and instr(process_status,'EXCEPTION') = 0 THEN

Line 243: ARP_PROGRAM_BR_REMIT.approve_remit_pvt(l_batch_id);

239: END IF;
240:
241: -- Approve remittance
242: IF p_approve_flag = 'Y' and instr(process_status,'EXCEPTION') = 0 THEN
243: ARP_PROGRAM_BR_REMIT.approve_remit_pvt(l_batch_id);
244: END IF;
245:
246: -- Process Payment
247: /* Payment uptake call the iby api for AUTH and settlement */

Line 249: ARP_PROGRAM_BR_REMIT.process_br_payment(l_batch_id);

245:
246: -- Process Payment
247: /* Payment uptake call the iby api for AUTH and settlement */
248:
249: ARP_PROGRAM_BR_REMIT.process_br_payment(l_batch_id);
250:
251: -- Format remittance
252: IF p_format_flag = 'Y' and instr(process_status,'EXCEPTION') = 0 THEN
253: ARP_PROGRAM_BR_REMIT.format_remit_pvt(l_batch_id,p_physical_bill);

Line 253: ARP_PROGRAM_BR_REMIT.format_remit_pvt(l_batch_id,p_physical_bill);

249: ARP_PROGRAM_BR_REMIT.process_br_payment(l_batch_id);
250:
251: -- Format remittance
252: IF p_format_flag = 'Y' and instr(process_status,'EXCEPTION') = 0 THEN
253: ARP_PROGRAM_BR_REMIT.format_remit_pvt(l_batch_id,p_physical_bill);
254: END IF;
255:
256: -- Print remittance
257: IF p_print_flag = 'Y' and instr(process_status,'EXCEPTION') = 0 THEN

Line 258: ARP_PROGRAM_BR_REMIT.print_remit_pvt(l_batch_id);

254: END IF;
255:
256: -- Print remittance
257: IF p_print_flag = 'Y' and instr(process_status,'EXCEPTION') = 0 THEN
258: ARP_PROGRAM_BR_REMIT.print_remit_pvt(l_batch_id);
259: END IF;
260:
261: -- Print Remittance 's Bills receivable
262: IF p_print_bills_flag = 'Y' and instr(process_status,'EXCEPTION') = 0 THEN

Line 263: ARP_PROGRAM_BR_REMIT.print_bills_remit_pvt(l_batch_id);

259: END IF;
260:
261: -- Print Remittance 's Bills receivable
262: IF p_print_bills_flag = 'Y' and instr(process_status,'EXCEPTION') = 0 THEN
263: ARP_PROGRAM_BR_REMIT.print_bills_remit_pvt(l_batch_id);
264: END IF;
265:
266: FND_FILE.PUT_LINE(FND_FILE.LOG,'auto_create_remit_program(-)');
267:

Line 272: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.auto_create_remit_program');

268: process_status := 'COMPLETED AUTO_CREATE_REMIT_PROGRAM';
269:
270: EXCEPTION
271: WHEN OTHERS THEN
272: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.auto_create_remit_program');
273: RAISE;
274:
275: END auto_create_remit_program;
276:

Line 458: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.create_remit_pvt - ROLLBACK');

454: WHEN OTHERS THEN
455:
456: process_status := 'EXCEPTION CREATE_REMIT_PVT';
457:
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.create_remit_pvt - ROLLBACK');
459: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
460: ROLLBACK TO create_remit_PVT;
461: RAISE;
462:

Line 534: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.cancel_remit_pvt - ROLLBACK');

530: WHEN OTHERS THEN
531:
532: process_status := 'EXCEPTION CANCEL_REMIT_PVT';
533:
534: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.cancel_remit_pvt - ROLLBACK');
535: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
536: ROLLBACK TO cancel_remit_PVT;
537:
538: END cancel_remit_pvt;

Line 632: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.approve_remit_pvt - ROLLBACK');

628: WHEN OTHERS THEN
629:
630: process_status := 'EXCEPTION APPROVE_REMIT_PVT';
631:
632: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.approve_remit_pvt - ROLLBACK');
633: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
634: ROLLBACK TO approve_remit_PVT;
635:
636: IF cur_br%ISOPEN THEN

Line 751: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.format_remit_pvt');

747: END IF;
748:
749: IF (l_request_id = 0) THEN
750: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
751: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.format_remit_pvt');
752: APP_EXCEPTION.raise_exception;
753: ELSE
754: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submitted Request -'||format_program||'. Request ID ='||to_char(l_request_id));
755: END IF;

Line 774: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.format_remit_pvt - ROLLBACK');

770: WHEN OTHERS THEN
771:
772: process_status := 'EXCEPTION FORMAT_REMIT_PVT';
773:
774: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.format_remit_pvt - ROLLBACK');
775: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
776: ROLLBACK TO format_remit_PVT;
777:
778:

Line 933: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.print_remit_pvt');

929: End If;
930:
931: IF (l_request_id = 0) THEN
932: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
933: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.print_remit_pvt');
934: APP_EXCEPTION.raise_exception;
935: ELSE
936: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submitted Request - '||print_program||'. Request ID ='||to_char(l_request_id));
937: END IF;

Line 948: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.print_remit_pvt - ROLLBACK');

944:
945: EXCEPTION
946: WHEN OTHERS THEN
947:
948: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.print_remit_pvt - ROLLBACK');
949: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
950: ROLLBACK TO print_remit_PVT;
951:
952: END print_remit_pvt;

Line 1019: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.print_bills_remit_pvt');

1015: ,arp_global.set_of_books_id);
1016:
1017: IF (l_request_id = 0) THEN
1018: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1019: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.print_bills_remit_pvt');
1020: APP_EXCEPTION.raise_exception;
1021: ELSE
1022: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submitted Request - ARBRFMTW. Request ID ='||to_char(l_request_id));
1023: END IF;

Line 1034: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.print_bills_remit_pvt - ROLLBACK');

1030:
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033:
1034: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_BR_REMIT.print_bills_remit_pvt - ROLLBACK');
1035: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1036: ROLLBACK TO print_bills_remit_PVT;
1037:
1038: END print_bills_remit_pvt;

Line 1509: arp_util.debug('ARP_PROGRAM_BR_REMIT.get_site_use_id (+)');

1505: l_cust_acct_site_id NUMBER;
1506:
1507: BEGIN
1508: IF PG_DEBUG in ('Y', 'C') THEN
1509: arp_util.debug('ARP_PROGRAM_BR_REMIT.get_site_use_id (+)');
1510: END IF;
1511:
1512: IF p_pay_trxn_extn_id IS NOT NULL THEN
1513:

Line 1552: arp_util.debug('Error: In ARP_PROGRAM_BR_REMIT.get_site_use_id');

1548: END;
1549:
1550: ELSE
1551: IF PG_DEBUG in ('Y', 'C') THEN
1552: arp_util.debug('Error: In ARP_PROGRAM_BR_REMIT.get_site_use_id');
1553: arp_util.debug('>>.Payment_trxn_extn_id and instrument_assignment_id are NULL');
1554: arp_util.debug('>>.Either one of two should be passed while calling this function.');
1555: END IF;
1556: END IF;

Line 1560: arp_util.debug('ARP_PROGRAM_BR_REMIT.get_site_use_id (-)');

1556: END IF;
1557:
1558: IF PG_DEBUG in ('Y', 'C') THEN
1559: arp_util.debug('Site_Use_ID: '|| l_cust_acct_site_id);
1560: arp_util.debug('ARP_PROGRAM_BR_REMIT.get_site_use_id (-)');
1561: END IF;
1562:
1563: RETURN l_cust_acct_site_id;
1564: END;

Line 1567: END ARP_PROGRAM_BR_REMIT;

1563: RETURN l_cust_acct_site_id;
1564: END;
1565:
1566:
1567: END ARP_PROGRAM_BR_REMIT;