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.AR_BR_REMIT_IMPORT_API_PUB dependencies on ARP_STANDARD

Line 31: arp_standard.debug ('impremapi.dummy_remittance()+');

27: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
28: BEGIN
29: --Check if the remittance is empty, i.e. has no Br's assiged to i,
30:
31: arp_standard.debug ('impremapi.dummy_remittance()+');
32:
33: select count(*)
34: into count_brs
35: from ar_transaction_history

Line 48: arp_standard.debug ('impremapi.dummy_remittance()-');

44: if count_brs = 0 and l_batch_applied_status in ('COMPLETED_CREATION','STARTED_CREATION') THEN
45: ARP_BR_REMIT_BATCHES.cancel_remit(p_reserved_value,l_batch_applied_status);
46: end if;
47:
48: arp_standard.debug ('impremapi.dummy_remittance()-');
49:
50: EXCEPTION
51: WHEN OTHERS THEN
52: x_return_status := FND_API.G_RET_STS_ERROR;

Line 54: arp_standard.debug('EXCEPTION OTHERS: impremapi.Dummy_Remittance');

50: EXCEPTION
51: WHEN OTHERS THEN
52: x_return_status := FND_API.G_RET_STS_ERROR;
53: ROLLBACK TO IMPORT_MAIN;
54: arp_standard.debug('EXCEPTION OTHERS: impremapi.Dummy_Remittance');
55: app_exception.raise_exception;
56: END;
57:
58:

Line 77: arp_standard.debug ('impremapi.Check_BR_and_Batch_Status()+');

73: Invalid_Remittance_Status Exception;
74:
75: BEGIN
76:
77: arp_standard.debug ('impremapi.Check_BR_and_Batch_Status()+');
78:
79: /*---------------------------------------------------------------------------------------
80: | Firstly check if the BR is currently assigned to an approved batch |
81: --------------------------------------------------------------------------------------*/

Line 114: arp_standard.debug ('impremapi.Check_BR_and_Batch_Status()-');

110: IF l_status <> 'OP' THEN
111: RAISE invalid_remittance_status;
112: END IF;
113:
114: arp_standard.debug ('impremapi.Check_BR_and_Batch_Status()-');
115:
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: ROLLBACK TO IMPORT_MAIN;

Line 120: arp_standard.debug ('EXCEPTION NO_DATA impremapi.Check_BR_and_Batch_Status');

116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: ROLLBACK TO IMPORT_MAIN;
119: fnd_message.set_name ('AR_BR','AR_BR_TRX_INVALID');
120: arp_standard.debug ('EXCEPTION NO_DATA impremapi.Check_BR_and_Batch_Status');
121: app_exception.raise_exception;
122:
123: WHEN invalid_remittance_status THEN
124: ROLLBACK TO IMPORT_MAIN;

Line 126: arp_standard.debug ('EXCEPTION invalid_remittance_status.Check_BR_and_Batch_Status');

122:
123: WHEN invalid_remittance_status THEN
124: ROLLBACK TO IMPORT_MAIN;
125: fnd_message.set_name ('AR_BR','AR_BR_TRX_INVALID');
126: arp_standard.debug ('EXCEPTION invalid_remittance_status.Check_BR_and_Batch_Status');
127: app_exception.raise_exception;
128:
129: WHEN OTHERS THEN
130: ROLLBACK TO IMPORT_MAIN;

Line 131: arp_standard.debug ('EXCEPTION WHEN_OTHERS impremapi.Check_BR_and_Batch_Status');

127: app_exception.raise_exception;
128:
129: WHEN OTHERS THEN
130: ROLLBACK TO IMPORT_MAIN;
131: arp_standard.debug ('EXCEPTION WHEN_OTHERS impremapi.Check_BR_and_Batch_Status');
132: app_exception.raise_exception;
133: END;
134:
135: /*---------------------------------------------------------------------------------------------------------------------------|

Line 175: arp_standard.debug ('impremapi.Compare_old_versus_new_values ()+');

171: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
172:
173: BEGIN
174:
175: arp_standard.debug ('impremapi.Compare_old_versus_new_values ()+');
176:
177: select remit_bank_acct_use_id,
178: currency_code,
179: gl_date,

Line 270: arp_standard.debug ('impremapi.Compare_old_versus_new_values ()-');

266: FND_MESSAGE.set_token('PARAMETER',' payment method ');
267: app_exception.raise_exception;
268: END IF;
269:
270: arp_standard.debug ('impremapi.Compare_old_versus_new_values ()-');
271:
272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN
274: ROLLBACK TO IMPORT_MAIN;

Line 275: arp_standard.debug ('EXCEPTION NO_DATA impremapi.Compare_old_versus_new_values');

271:
272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN
274: ROLLBACK TO IMPORT_MAIN;
275: arp_standard.debug ('EXCEPTION NO_DATA impremapi.Compare_old_versus_new_values');
276: app_exception.raise_exception;
277:
278: WHEN OTHERS THEN
279: ROLLBACK TO IMPORT_MAIN;

Line 280: arp_standard.debug ('EXCEPTION WHEN OTHERS impremapi.Compare_old_versus_new_values');

276: app_exception.raise_exception;
277:
278: WHEN OTHERS THEN
279: ROLLBACK TO IMPORT_MAIN;
280: arp_standard.debug ('EXCEPTION WHEN OTHERS impremapi.Compare_old_versus_new_values');
281: app_exception.raise_exception;
282:
283: END;
284:

Line 335: arp_standard.debug ('impremapi.Existing_Remittance ()+');

331: invalid_Remittance_status Exception;
332:
333: BEGIN
334:
335: arp_standard.debug ('impremapi.Existing_Remittance ()+');
336:
337: compare_old_versus_new_values(p_media_reference,
338: p_remittance_accounting_Date,
339: p_remittance_method,

Line 356: arp_standard.debug ('impremapi.Existing_Remittance - call deselect');

352: | to the new one |
353: |---------------------------------------------------------------------------------------*/
354:
355: IF l_media_reference <> p_media_reference or l_media_reference is null then
356: arp_standard.debug ('impremapi.Existing_Remittance - call deselect');
357: AR_BILLS_MAINTAIN_PUB.Deselect_BR_Remit(l_payment_schedule_id,x_return_status);
358: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(l_batch_id,l_payment_schedule_id,x_return_status);
359: dummy_remittance(l_reserved_value, x_return_status);
360: END IF;

Line 362: arp_standard.debug ('impremapi.Existing_Remittance ()-');

358: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(l_batch_id,l_payment_schedule_id,x_return_status);
359: dummy_remittance(l_reserved_value, x_return_status);
360: END IF;
361:
362: arp_standard.debug ('impremapi.Existing_Remittance ()-');
363:
364: EXCEPTION
365: WHEN OTHERS THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;

Line 368: arp_standard.debug ('EXCEPTION WHEN OTHERS impremapi.Existing_Remittance');

364: EXCEPTION
365: WHEN OTHERS THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: ROLLBACK TO IMPORT_MAIN;
368: arp_standard.debug ('EXCEPTION WHEN OTHERS impremapi.Existing_Remittance');
369: app_exception.raise_exception;
370:
371: END;
372:

Line 443: arp_standard.debug ('impremapi.New_Remittance ()+');

439: AND cba.account_classification = 'INTERNAL';
440:
441: BEGIN
442:
443: arp_standard.debug ('impremapi.New_Remittance ()+');
444:
445: check_br_and_batch_status (p_internal_reference,
446: l_reserved_value,l_payment_schedule_id,l_media_reference);
447:

Line 462: arp_standard.debug('EXCEPTION Branch no_data : ' ||

458: EXCEPTION
459: WHEN NO_DATA_FOUND THEN
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: ROLLBACK TO IMPORT_MAIN;
462: arp_standard.debug('EXCEPTION Branch no_data : ' ||
463: 'impremapi.New_Remittance');
464: fnd_message.set_name ( 'AR', 'AR_MUST_ENTER_REMIT_BANK');
465: app_exception.raise_exception;
466: END;

Line 480: arp_standard.debug('EXCEPTION Bank acc id no_data : ' ||

476: EXCEPTION
477: WHEN NO_DATA_FOUND THEN
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: ROLLBACK TO IMPORT_MAIN;
480: arp_standard.debug('EXCEPTION Bank acc id no_data : ' ||
481: 'impremapi.New_Remittance');
482: fnd_message.set_name ( 'AR', 'Invalid Remittance Bank Branch');
483: app_exception.raise_exception;
484: END;

Line 502: arp_standard.debug('EXCEPTION Receipt Method : impremapi.New_Remittance');

498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: ROLLBACK TO IMPORT_MAIN;
502: arp_standard.debug('EXCEPTION Receipt Method : impremapi.New_Remittance');
503: fnd_message.set_name('AR','AR_BR_INVALID_REMIT_PROGRAM');
504: app_exception.raise_exception;
505:
506: END;

Line 523: arp_standard.debug('EXCEPTION Receipt Method Progs : impremapi.New_Remittance');

519: EXCEPTION
520: WHEN NO_DATA_FOUND THEN
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: ROLLBACK TO IMPORT_MAIN;
523: arp_standard.debug('EXCEPTION Receipt Method Progs : impremapi.New_Remittance');
524: fnd_message.set_name ( 'AR', 'AR_BR_INVALID_RECEIPT_METHOD');
525: app_exception.raise_exception;
526: END;
527:

Line 530: arp_standard.debug('Call insert_remit : impremapi.New_Remittance');

526: END;
527:
528: l_batch_id := null;
529:
530: arp_standard.debug('Call insert_remit : impremapi.New_Remittance');
531:
532: ARP_BR_REMIT_BATCHES.insert_remit(
533: p_remittance_date,
534: p_remittance_accounting_date,

Line 562: arp_standard.debug ('impremapi.New_Remittance Called Insert_remit');

558: x_batch_id,
559: x_batch_name,
560: x_batch_applied_status);
561:
562: arp_standard.debug ('impremapi.New_Remittance Called Insert_remit');
563:
564: /*---------------------------------------------------------------------------------------
565: | Deselect the BR from the batch it is currently assigned to |
566: ---------------------------------------------------------------------------------------*/

Line 569: arp_standard.debug ('impremapi.New_Remittance : call Deselect_BR_Remit');

565: | Deselect the BR from the batch it is currently assigned to |
566: ---------------------------------------------------------------------------------------*/
567:
568: IF l_reserved_value is not null THEN
569: arp_standard.debug ('impremapi.New_Remittance : call Deselect_BR_Remit');
570: AR_BILLS_MAINTAIN_PUB.Deselect_BR_Remit(l_payment_schedule_id,x_return_status);
571: arp_standard.debug ('impremapi.New_Remittance : called Deselect_BR_Remit');
572: dummy_remittance(l_reserved_value, x_return_status);
573: END IF;

Line 571: arp_standard.debug ('impremapi.New_Remittance : called Deselect_BR_Remit');

567:
568: IF l_reserved_value is not null THEN
569: arp_standard.debug ('impremapi.New_Remittance : call Deselect_BR_Remit');
570: AR_BILLS_MAINTAIN_PUB.Deselect_BR_Remit(l_payment_schedule_id,x_return_status);
571: arp_standard.debug ('impremapi.New_Remittance : called Deselect_BR_Remit');
572: dummy_remittance(l_reserved_value, x_return_status);
573: END IF;
574:
575: /*---------------------------------------------------------------------------------------

Line 580: arp_standard.debug ('impremapi.New_Remittance ()-');

576: | Assign the BR to the new remittance batch. |
577: ---------------------------------------------------------------------------------------*/
578: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(x_batch_id,l_payment_schedule_id,x_return_status);
579:
580: arp_standard.debug ('impremapi.New_Remittance ()-');
581:
582: EXCEPTION
583: WHEN OTHERS THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;

Line 586: arp_standard.debug('EXCEPTION OTHERS: impremapi.New_Remittance');

582: EXCEPTION
583: WHEN OTHERS THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: ROLLBACK TO IMPORT_MAIN;
586: arp_standard.debug('EXCEPTION OTHERS: impremapi.New_Remittance');
587: app_exception.raise_exception;
588: END;
589:
590: /*---------------------------------------------------------------------------------------------------------------------------|

Line 609: arp_standard.debug ('impremapi.remittance_Exists()+');

605: l_status AR_BATCHES.status%TYPE;
606:
607: BEGIN
608:
609: arp_standard.debug ('impremapi.remittance_Exists()+');
610:
611: select batch_applied_status,
612: status
613: into

Line 626: arp_standard.debug ('impremapi.remittance_Exists()-');

622: ELSE
623: return false;
624: END IF;
625:
626: arp_standard.debug ('impremapi.remittance_Exists()-');
627:
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: arp_standard.debug ('EXCEPTION NO_DATA : impremapi.remittance_Exists');

Line 630: arp_standard.debug ('EXCEPTION NO_DATA : impremapi.remittance_Exists');

626: arp_standard.debug ('impremapi.remittance_Exists()-');
627:
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: arp_standard.debug ('EXCEPTION NO_DATA : impremapi.remittance_Exists');
631: return false;
632:
633:
634: WHEN OTHERS THEN

Line 635: arp_standard.debug('EXCEPTION OTHERS: impremapi.remittance_Exists');

631: return false;
632:
633:
634: WHEN OTHERS THEN
635: arp_standard.debug('EXCEPTION OTHERS: impremapi.remittance_Exists');
636: app_exception.raise_exception;
637:
638: END;
639:

Line 687: arp_standard.debug('Impremapi.Import_Remittance_Main (+)');

683: l_org_id NUMBER;
684:
685: BEGIN
686:
687: arp_standard.debug('Impremapi.Import_Remittance_Main (+)');
688:
689: -- Standard start of API savepoint
690:
691: SAVEPOINT IMPORT_MAIN;

Line 736: arp_standard.debug('Impremapi.Import_Remittance_Main media_ref null');

732: ---------------------------------------------------------------------------------------*/
733:
734: IF p_media_reference is null THEN
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: arp_standard.debug('Impremapi.Import_Remittance_Main media_ref null');
737: --bug 1644533
738: fnd_message.set_name('AR_BR','AR_BR_MEDIA_REF_NULL');
739: app_exception.raise_exception;
740: end if;

Line 748: arp_standard.debug('Impremapi.Import_Remittance_Main new remittance');

744: | existing_remittance procedure. |
745: ---------------------------------------------------------------------------------------*/
746:
747: IF not remittance_exists (p_media_reference) THEN
748: arp_standard.debug('Impremapi.Import_Remittance_Main new remittance');
749: new_remittance (p_media_reference,p_remittance_accounting_date,p_remittance_Date,p_internal_reference,
750: p_with_recourse_flag,p_currency_code,p_remittance_method,p_remittance_bnk_branch_number,
751: p_remittance_bank_number,p_remittance_bnk_acct_number,p_payment_method,p_remittance_name,
752: x_return_status);

Line 754: arp_standard.debug('Impremapi.Import_Remittance_Main existing remittance');

750: p_with_recourse_flag,p_currency_code,p_remittance_method,p_remittance_bnk_branch_number,
751: p_remittance_bank_number,p_remittance_bnk_acct_number,p_payment_method,p_remittance_name,
752: x_return_status);
753: else
754: arp_standard.debug('Impremapi.Import_Remittance_Main existing remittance');
755: existing_remittance (p_media_reference,p_remittance_accounting_Date,p_internal_reference,p_remittance_method,
756: p_with_recourse_flag,p_payment_method,p_remittance_date,p_Currency_code,
757: p_remittance_bnk_acct_number,x_return_status);
758: end if;

Line 764: IF FND_API.To_Boolean( p_commit ) THEN arp_standard.debug('committing');

760: /*-----------------------------------------------+
761: | Standard check of p_commit |
762: ------------------------------------------------*/
763:
764: IF FND_API.To_Boolean( p_commit ) THEN arp_standard.debug('committing');
765: Commit;
766: END IF;
767: END IF;
768:

Line 769: arp_standard.debug('Impremapi.Import_Remittance_Main (-)');

765: Commit;
766: END IF;
767: END IF;
768:
769: arp_standard.debug('Impremapi.Import_Remittance_Main (-)');
770:
771: EXCEPTION
772: WHEN OTHERS THEN
773: ROLLBACK TO IMPORT_MAIN;

Line 774: arp_standard.debug('EXCEPTION OTHERS: impremapi.Import_Remittance_Main');

770:
771: EXCEPTION
772: WHEN OTHERS THEN
773: ROLLBACK TO IMPORT_MAIN;
774: arp_standard.debug('EXCEPTION OTHERS: impremapi.Import_Remittance_Main');
775: RAISE;
776:
777: END;
778: