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_AUTOREC_API dependencies on STANDARD

Line 545: pg_request_id := arp_standard.profile.request_id;

541: l_current_worker_number := to_number(nvl(p_current_worker_number,0));
542: l_total_workers := to_number(nvl(p_total_workers,0));
543:
544: /* Bug 8903995 */
545: pg_request_id := arp_standard.profile.request_id;
546: pg_last_updated_by := arp_standard.profile.last_update_login ;
547: pg_created_by := arp_standard.profile.user_id ;
548: pg_last_update_login := arp_standard.profile.last_update_login ;
549: pg_program_application_id := arp_standard.application_id ;

Line 546: pg_last_updated_by := arp_standard.profile.last_update_login ;

542: l_total_workers := to_number(nvl(p_total_workers,0));
543:
544: /* Bug 8903995 */
545: pg_request_id := arp_standard.profile.request_id;
546: pg_last_updated_by := arp_standard.profile.last_update_login ;
547: pg_created_by := arp_standard.profile.user_id ;
548: pg_last_update_login := arp_standard.profile.last_update_login ;
549: pg_program_application_id := arp_standard.application_id ;
550: pg_program_id := arp_standard.profile.program_id;

Line 547: pg_created_by := arp_standard.profile.user_id ;

543:
544: /* Bug 8903995 */
545: pg_request_id := arp_standard.profile.request_id;
546: pg_last_updated_by := arp_standard.profile.last_update_login ;
547: pg_created_by := arp_standard.profile.user_id ;
548: pg_last_update_login := arp_standard.profile.last_update_login ;
549: pg_program_application_id := arp_standard.application_id ;
550: pg_program_id := arp_standard.profile.program_id;
551:

Line 548: pg_last_update_login := arp_standard.profile.last_update_login ;

544: /* Bug 8903995 */
545: pg_request_id := arp_standard.profile.request_id;
546: pg_last_updated_by := arp_standard.profile.last_update_login ;
547: pg_created_by := arp_standard.profile.user_id ;
548: pg_last_update_login := arp_standard.profile.last_update_login ;
549: pg_program_application_id := arp_standard.application_id ;
550: pg_program_id := arp_standard.profile.program_id;
551:
552: IF PG_DEBUG in ('Y', 'C') THEN

Line 549: pg_program_application_id := arp_standard.application_id ;

545: pg_request_id := arp_standard.profile.request_id;
546: pg_last_updated_by := arp_standard.profile.last_update_login ;
547: pg_created_by := arp_standard.profile.user_id ;
548: pg_last_update_login := arp_standard.profile.last_update_login ;
549: pg_program_application_id := arp_standard.application_id ;
550: pg_program_id := arp_standard.profile.program_id;
551:
552: IF PG_DEBUG in ('Y', 'C') THEN
553: arp_debug.debug('pg_request_id ' || pg_request_id);

Line 550: pg_program_id := arp_standard.profile.program_id;

546: pg_last_updated_by := arp_standard.profile.last_update_login ;
547: pg_created_by := arp_standard.profile.user_id ;
548: pg_last_update_login := arp_standard.profile.last_update_login ;
549: pg_program_application_id := arp_standard.application_id ;
550: pg_program_id := arp_standard.profile.program_id;
551:
552: IF PG_DEBUG in ('Y', 'C') THEN
553: arp_debug.debug('pg_request_id ' || pg_request_id);
554: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);

Line 1110: pg_request_id := arp_standard.profile.request_id;

1106: l_approve_flag := p_approve_flag;
1107: l_format_flag := p_format_flag;
1108:
1109: /* Bug 8903995 */
1110: pg_request_id := arp_standard.profile.request_id;
1111: pg_last_updated_by := arp_standard.profile.last_update_login ;
1112: pg_created_by := arp_standard.profile.user_id ;
1113: pg_last_update_login := arp_standard.profile.last_update_login ;
1114: pg_program_application_id := arp_standard.application_id ;

Line 1111: pg_last_updated_by := arp_standard.profile.last_update_login ;

1107: l_format_flag := p_format_flag;
1108:
1109: /* Bug 8903995 */
1110: pg_request_id := arp_standard.profile.request_id;
1111: pg_last_updated_by := arp_standard.profile.last_update_login ;
1112: pg_created_by := arp_standard.profile.user_id ;
1113: pg_last_update_login := arp_standard.profile.last_update_login ;
1114: pg_program_application_id := arp_standard.application_id ;
1115: pg_program_id := arp_standard.profile.program_id;

Line 1112: pg_created_by := arp_standard.profile.user_id ;

1108:
1109: /* Bug 8903995 */
1110: pg_request_id := arp_standard.profile.request_id;
1111: pg_last_updated_by := arp_standard.profile.last_update_login ;
1112: pg_created_by := arp_standard.profile.user_id ;
1113: pg_last_update_login := arp_standard.profile.last_update_login ;
1114: pg_program_application_id := arp_standard.application_id ;
1115: pg_program_id := arp_standard.profile.program_id;
1116:

Line 1113: pg_last_update_login := arp_standard.profile.last_update_login ;

1109: /* Bug 8903995 */
1110: pg_request_id := arp_standard.profile.request_id;
1111: pg_last_updated_by := arp_standard.profile.last_update_login ;
1112: pg_created_by := arp_standard.profile.user_id ;
1113: pg_last_update_login := arp_standard.profile.last_update_login ;
1114: pg_program_application_id := arp_standard.application_id ;
1115: pg_program_id := arp_standard.profile.program_id;
1116:
1117: IF PG_DEBUG in ('Y', 'C') THEN

Line 1114: pg_program_application_id := arp_standard.application_id ;

1110: pg_request_id := arp_standard.profile.request_id;
1111: pg_last_updated_by := arp_standard.profile.last_update_login ;
1112: pg_created_by := arp_standard.profile.user_id ;
1113: pg_last_update_login := arp_standard.profile.last_update_login ;
1114: pg_program_application_id := arp_standard.application_id ;
1115: pg_program_id := arp_standard.profile.program_id;
1116:
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_debug.debug('pg_request_id ' || pg_request_id);

Line 1115: pg_program_id := arp_standard.profile.program_id;

1111: pg_last_updated_by := arp_standard.profile.last_update_login ;
1112: pg_created_by := arp_standard.profile.user_id ;
1113: pg_last_update_login := arp_standard.profile.last_update_login ;
1114: pg_program_application_id := arp_standard.application_id ;
1115: pg_program_id := arp_standard.profile.program_id;
1116:
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_debug.debug('pg_request_id ' || pg_request_id);
1119: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);

Line 1188: pg_request_id := arp_standard.profile.request_id;

1184: END IF;
1185:
1186: --fetch org id,need to set it for child requests
1187: l_org_id := mo_global.get_current_org_id;
1188: pg_request_id := arp_standard.profile.request_id;
1189:
1190:
1191: IF p_approve_flag = 'Y' THEN
1192: BEGIN

Line 2555: and xte.ledger_id = ARP_STANDARD.sysparm.set_of_books_id

2551: and xte.entity_code = 'RECEIPTS'
2552: and xe.application_id = 222
2553: and xe.event_number > 0
2554: and xe.entity_id = xte.entity_id
2555: and xte.ledger_id = ARP_STANDARD.sysparm.set_of_books_id
2556: and NVL(xte.source_id_int_1, -99) IN
2557: (select distinct cash_receipt_id
2558: from ar_autorec_exceptions
2559: where request_id = pg_request_id));

Line 3269: p_request_id => arp_standard.profile.request_id,

3265: end if;
3266: arp_debug.debug('update_ar_receipts_gt : error code() '|| to_char(SQLCODE));
3267:
3268: insert_exceptions( p_batch_id => NVL(g_batch_id, -333),
3269: p_request_id => arp_standard.profile.request_id,
3270: p_exception_code => 'AUTORECERR',
3271: p_additional_message => 'update_ar_receipts_gt() '|| SQLERRM );
3272:
3273: END update_ar_receipts_gt;

Line 4084: pg_request_id := arp_standard.profile.request_id;

4080: arp_debug.debug('batch_id '||p_batch_id);
4081: arp_debug.debug('p_receipt_method_id '||p_receipt_method_id);
4082: END IF;
4083:
4084: pg_request_id := arp_standard.profile.request_id;
4085:
4086: IF PG_DEBUG in ('Y', 'C') THEN
4087: arp_debug.debug('request_id :'||pg_request_id);
4088: END IF;

Line 4485: arp_standard.debug('Receipt_create: Min receipt id: '||l_from_cr_id);

4481: END LOOP; -- end of create/process receipts loop
4482:
4483: l_unbal_rcpt_tab.delete;
4484:
4485: arp_standard.debug('Receipt_create: Min receipt id: '||l_from_cr_id);
4486: arp_standard.debug('Receipt_create: Max receipt id: '||l_to_cr_id);
4487:
4488: IF l_from_cr_id IS NOT NULL AND l_to_cr_id IS NOT NULL THEN
4489:

Line 4486: arp_standard.debug('Receipt_create: Max receipt id: '||l_to_cr_id);

4482:
4483: l_unbal_rcpt_tab.delete;
4484:
4485: arp_standard.debug('Receipt_create: Min receipt id: '||l_from_cr_id);
4486: arp_standard.debug('Receipt_create: Max receipt id: '||l_to_cr_id);
4487:
4488: IF l_from_cr_id IS NOT NULL AND l_to_cr_id IS NOT NULL THEN
4489:
4490: arp_standard.debug(' Checking Journal Balance in Bulk: for receipt_create');

Line 4490: arp_standard.debug(' Checking Journal Balance in Bulk: for receipt_create');

4486: arp_standard.debug('Receipt_create: Max receipt id: '||l_to_cr_id);
4487:
4488: IF l_from_cr_id IS NOT NULL AND l_to_cr_id IS NOT NULL THEN
4489:
4490: arp_standard.debug(' Checking Journal Balance in Bulk: for receipt_create');
4491: ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK(
4492: p_cr_id_low => l_from_cr_id,
4493: p_cr_id_high => l_to_cr_id,
4494: p_unbalanced_cr_tbl => l_unbal_rcpt_tab );

Line 4496: arp_standard.debug('Receipt_create: Count of unbalanced receipts:'||l_unbal_rcpt_tab.COUNT);

4492: p_cr_id_low => l_from_cr_id,
4493: p_cr_id_high => l_to_cr_id,
4494: p_unbalanced_cr_tbl => l_unbal_rcpt_tab );
4495:
4496: arp_standard.debug('Receipt_create: Count of unbalanced receipts:'||l_unbal_rcpt_tab.COUNT);
4497:
4498: --loop over the array to mark unbalanced receipts
4499: IF l_unbal_rcpt_tab.COUNT > 0 THEN
4500:

Line 4502: arp_standard.debug('Receipt_create: inside, l_unbal_rcpt_tab.FIRST : '||l_unbal_rcpt_tab.FIRST);

4498: --loop over the array to mark unbalanced receipts
4499: IF l_unbal_rcpt_tab.COUNT > 0 THEN
4500:
4501: IF PG_DEBUG in ('Y', 'C') THEN
4502: arp_standard.debug('Receipt_create: inside, l_unbal_rcpt_tab.FIRST : '||l_unbal_rcpt_tab.FIRST);
4503: arp_standard.debug('Receipt_create: inside, l_unbal_rcpt_tab.LAST : '||l_unbal_rcpt_tab.LAST);
4504: END IF;
4505:
4506: FOR i IN l_unbal_rcpt_tab.FIRST..l_unbal_rcpt_tab.LAST LOOP

Line 4503: arp_standard.debug('Receipt_create: inside, l_unbal_rcpt_tab.LAST : '||l_unbal_rcpt_tab.LAST);

4499: IF l_unbal_rcpt_tab.COUNT > 0 THEN
4500:
4501: IF PG_DEBUG in ('Y', 'C') THEN
4502: arp_standard.debug('Receipt_create: inside, l_unbal_rcpt_tab.FIRST : '||l_unbal_rcpt_tab.FIRST);
4503: arp_standard.debug('Receipt_create: inside, l_unbal_rcpt_tab.LAST : '||l_unbal_rcpt_tab.LAST);
4504: END IF;
4505:
4506: FOR i IN l_unbal_rcpt_tab.FIRST..l_unbal_rcpt_tab.LAST LOOP
4507: FOR j IN l_rcpt_info_tab.FIRST..l_rcpt_info_tab.LAST LOOP

Line 4510: arp_standard.debug('Receipt_create: inside, l_unbal_rcpt_tab(i).cash_receipt_id : '||l_unbal_rcpt_tab(i).cash_receipt_id);

4506: FOR i IN l_unbal_rcpt_tab.FIRST..l_unbal_rcpt_tab.LAST LOOP
4507: FOR j IN l_rcpt_info_tab.FIRST..l_rcpt_info_tab.LAST LOOP
4508:
4509: IF PG_DEBUG in ('Y', 'C') THEN
4510: arp_standard.debug('Receipt_create: inside, l_unbal_rcpt_tab(i).cash_receipt_id : '||l_unbal_rcpt_tab(i).cash_receipt_id);
4511: arp_standard.debug('Receipt_create: inside, l_receipt_id_array(j) : '||l_receipt_id_array(j));
4512: END IF;
4513:
4514: IF l_receipt_id_array(j) = l_unbal_rcpt_tab(i).cash_receipt_id THEN

Line 4511: arp_standard.debug('Receipt_create: inside, l_receipt_id_array(j) : '||l_receipt_id_array(j));

4507: FOR j IN l_rcpt_info_tab.FIRST..l_rcpt_info_tab.LAST LOOP
4508:
4509: IF PG_DEBUG in ('Y', 'C') THEN
4510: arp_standard.debug('Receipt_create: inside, l_unbal_rcpt_tab(i).cash_receipt_id : '||l_unbal_rcpt_tab(i).cash_receipt_id);
4511: arp_standard.debug('Receipt_create: inside, l_receipt_id_array(j) : '||l_receipt_id_array(j));
4512: END IF;
4513:
4514: IF l_receipt_id_array(j) = l_unbal_rcpt_tab(i).cash_receipt_id THEN
4515:

Line 4523: arp_standard.debug('Delete unbalanced receipt with receipt_id : '||l_receipt_id_array(j));

4519: l_err_code_array( l_err_rcpt_index ) := 'RCPT_CREATION_FAILED';
4520: l_cc_err_text_array( l_err_rcpt_index ) := l_err_text;
4521:
4522: IF PG_DEBUG in ('Y','C') THEN
4523: arp_standard.debug('Delete unbalanced receipt with receipt_id : '||l_receipt_id_array(j));
4524: END IF;
4525:
4526: delete from ar_payment_schedules
4527: where cash_receipt_id = l_receipt_id_array(j);

Line 4530: arp_standard.debug ( ' rows DELETED PS = ' || SQL%ROWCOUNT );

4526: delete from ar_payment_schedules
4527: where cash_receipt_id = l_receipt_id_array(j);
4528:
4529: IF PG_DEBUG in ('Y','C') THEN
4530: arp_standard.debug ( ' rows DELETED PS = ' || SQL%ROWCOUNT );
4531: END IF;
4532:
4533: delete from ar_distributions
4534: where source_table = 'CRH'

Line 4541: arp_standard.debug ( ' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );

4537: from ar_cash_receipt_history
4538: where cash_receipt_id = l_receipt_id_array(j));
4539:
4540: IF PG_DEBUG in ('Y','C') THEN
4541: arp_standard.debug ( ' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );
4542: END IF;
4543:
4544: delete from ar_distributions
4545: where source_table = 'RA'

Line 4552: arp_standard.debug ( ' rows DELETED AR_DIST2 = ' || SQL%ROWCOUNT );

4548: from ar_receivable_applications
4549: where cash_receipt_id = l_receipt_id_array(j));
4550:
4551: IF PG_DEBUG in ('Y','C') THEN
4552: arp_standard.debug ( ' rows DELETED AR_DIST2 = ' || SQL%ROWCOUNT );
4553: END IF;
4554:
4555: delete from ar_receivable_applications
4556: where cash_receipt_id = l_receipt_id_array(j);

Line 4559: arp_standard.debug ( ' rows DELETED REC_APPS = ' || SQL%ROWCOUNT );

4555: delete from ar_receivable_applications
4556: where cash_receipt_id = l_receipt_id_array(j);
4557:
4558: IF PG_DEBUG in ('Y','C') THEN
4559: arp_standard.debug ( ' rows DELETED REC_APPS = ' || SQL%ROWCOUNT );
4560: END IF;
4561:
4562: delete from ar_cash_receipt_history
4563: where cash_receipt_id = l_receipt_id_array(j);

Line 4566: arp_standard.debug ( ' rows DELETED CRH = ' || SQL%ROWCOUNT );

4562: delete from ar_cash_receipt_history
4563: where cash_receipt_id = l_receipt_id_array(j);
4564:
4565: IF PG_DEBUG in ('Y','C') THEN
4566: arp_standard.debug ( ' rows DELETED CRH = ' || SQL%ROWCOUNT );
4567: END IF;
4568:
4569: delete from ar_cash_receipts
4570: where cash_receipt_id = l_receipt_id_array(j);

Line 4573: arp_standard.debug ( ' rows DELETED CR = ' || SQL%ROWCOUNT );

4569: delete from ar_cash_receipts
4570: where cash_receipt_id = l_receipt_id_array(j);
4571:
4572: IF PG_DEBUG in ('Y','C') THEN
4573: arp_standard.debug ( ' rows DELETED CR = ' || SQL%ROWCOUNT );
4574: END IF;
4575:
4576: l_receipt_id_array(j) := null;
4577: EXIT;

Line 4599: arp_standard.debug( 'l_receipt_id_array(i)= '|| l_receipt_id_array(i));

4595: IF l_process_payment_flag = 1 AND l_receipt_id_array(i) is not null THEN
4596:
4597: IF PG_DEBUG in ('Y', 'C') THEN
4598: arp_debug.debug( 'Calling process_payments ');
4599: arp_standard.debug( 'l_receipt_id_array(i)= '|| l_receipt_id_array(i));
4600: END IF;
4601:
4602: l_cc_error_code := null;
4603: l_cc_error_text := null;

Line 4834: arp_standard.debug('Checking Journal Balance in Bulk: After Application');

4830: where gt.gt_id = l_gt_id;
4831:
4832: IF l_from_cr_id IS NOT NULL AND l_to_cr_id IS NOT NULL THEN
4833:
4834: arp_standard.debug('Checking Journal Balance in Bulk: After Application');
4835: ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK(
4836: p_cr_id_low => l_from_cr_id,
4837: p_cr_id_high => l_to_cr_id,
4838: p_unbalanced_cr_tbl => l_unbal_rcpt_tab );

Line 4843: arp_standard.debug('Check Journal Balance for each application for balance failed receipts');

4839:
4840: IF l_unbal_rcpt_tab.count > 0 THEN
4841: FOR i IN l_unbal_rcpt_tab.FIRST..l_unbal_rcpt_tab.LAST LOOP
4842:
4843: arp_standard.debug('Check Journal Balance for each application for balance failed receipts');
4844: FOR unbal_rec_appln IN unbal_rec_applns(l_unbal_rcpt_tab(i).cash_receipt_id, l_gt_id) LOOP
4845:
4846: BEGIN
4847: ARP_BALANCE_CHECK.CHECK_APPLN_BALANCE(

Line 4854: arp_standard.debug('Exception: Application Balance Failure');

4850: p_request_id => pg_request_id,
4851: p_called_from_api => 'Y' );
4852: EXCEPTION
4853: WHEN OTHERS THEN
4854: arp_standard.debug('Exception: Application Balance Failure');
4855: arp_standard.debug('Exception: Invoice PS ID: '||unbal_rec_appln.applied_payment_schedule_id);
4856: arp_standard.debug('Exception: CR ID: '||l_unbal_rcpt_tab(i).cash_receipt_id);
4857:
4858: arp_standard.debug('Update Invoice PS Before deleting Application');

Line 4855: arp_standard.debug('Exception: Invoice PS ID: '||unbal_rec_appln.applied_payment_schedule_id);

4851: p_called_from_api => 'Y' );
4852: EXCEPTION
4853: WHEN OTHERS THEN
4854: arp_standard.debug('Exception: Application Balance Failure');
4855: arp_standard.debug('Exception: Invoice PS ID: '||unbal_rec_appln.applied_payment_schedule_id);
4856: arp_standard.debug('Exception: CR ID: '||l_unbal_rcpt_tab(i).cash_receipt_id);
4857:
4858: arp_standard.debug('Update Invoice PS Before deleting Application');
4859: UPDATE AR_PAYMENT_SCHEDULES PS SET (

Line 4856: arp_standard.debug('Exception: CR ID: '||l_unbal_rcpt_tab(i).cash_receipt_id);

4852: EXCEPTION
4853: WHEN OTHERS THEN
4854: arp_standard.debug('Exception: Application Balance Failure');
4855: arp_standard.debug('Exception: Invoice PS ID: '||unbal_rec_appln.applied_payment_schedule_id);
4856: arp_standard.debug('Exception: CR ID: '||l_unbal_rcpt_tab(i).cash_receipt_id);
4857:
4858: arp_standard.debug('Update Invoice PS Before deleting Application');
4859: UPDATE AR_PAYMENT_SCHEDULES PS SET (
4860: PS.AMOUNT_DUE_REMAINING,

Line 4858: arp_standard.debug('Update Invoice PS Before deleting Application');

4854: arp_standard.debug('Exception: Application Balance Failure');
4855: arp_standard.debug('Exception: Invoice PS ID: '||unbal_rec_appln.applied_payment_schedule_id);
4856: arp_standard.debug('Exception: CR ID: '||l_unbal_rcpt_tab(i).cash_receipt_id);
4857:
4858: arp_standard.debug('Update Invoice PS Before deleting Application');
4859: UPDATE AR_PAYMENT_SCHEDULES PS SET (
4860: PS.AMOUNT_DUE_REMAINING,
4861: PS.AMOUNT_APPLIED,
4862: PS.AMOUNT_LINE_ITEMS_REMAINING,

Line 4914: arp_standard.debug('Update Receipt PS Before deleting Application');

4910: AND RA1.CASH_RECEIPT_ID = l_unbal_rcpt_tab(i).cash_receipt_id
4911: AND RA1.RECEIVABLE_APPLICATION_ID = unbal_rec_appln.source_id_secondary )
4912: WHERE PS.PAYMENT_SCHEDULE_ID = unbal_rec_appln.applied_payment_schedule_id;
4913:
4914: arp_standard.debug('Update Receipt PS Before deleting Application');
4915: UPDATE AR_PAYMENT_SCHEDULES PS SET (
4916: PS.AMOUNT_DUE_REMAINING,
4917: PS.AMOUNT_APPLIED,
4918: PS.ACCTD_AMOUNT_DUE_REMAINING,

Line 4936: arp_standard.debug('Delete Application Distribution Entires');

4932: WHERE RA1.PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID
4933: AND RA1.RECEIVABLE_APPLICATION_ID = unbal_rec_appln.source_id_secondary )
4934: WHERE PS.PAYMENT_SCHEDULE_ID = unbal_rec_appln.payment_schedule_id;
4935:
4936: arp_standard.debug('Delete Application Distribution Entires');
4937: DELETE FROM AR_DISTRIBUTIONS WHERE SOURCE_ID IN
4938: (unbal_rec_appln.source_id,
4939: unbal_rec_appln.source_id_secondary)
4940: AND SOURCE_TABLE = 'RA';

Line 4942: arp_standard.debug('Delete Application Entries');

4938: (unbal_rec_appln.source_id,
4939: unbal_rec_appln.source_id_secondary)
4940: AND SOURCE_TABLE = 'RA';
4941:
4942: arp_standard.debug('Delete Application Entries');
4943: DELETE FROM AR_RECEIVABLE_APPLICATIONS WHERE RECEIVABLE_APPLICATION_ID IN
4944: (unbal_rec_appln.source_id,
4945: unbal_rec_appln.source_id_secondary);
4946:

Line 4947: arp_standard.debug('Reset Invoice Line Level Balances If maintained on the invoice');

4943: DELETE FROM AR_RECEIVABLE_APPLICATIONS WHERE RECEIVABLE_APPLICATION_ID IN
4944: (unbal_rec_appln.source_id,
4945: unbal_rec_appln.source_id_secondary);
4946:
4947: arp_standard.debug('Reset Invoice Line Level Balances If maintained on the invoice');
4948: IF unbal_rec_appln.upgrade_method IN ('R12', 'R12_11IMFAR') THEN
4949:
4950: UPDATE RA_CUSTOMER_TRX_LINES TL SET (
4951: AMOUNT_DUE_REMAINING,

Line 5041: arp_standard.debug('Inserting Exception');

5037: l_msg_data := 'Application failure. You need to nullify the SELECTED FOR RECEIPT BATCH ID on the invoice.'||
5038: ' When the invoice is fixed, then apply the invoice manually to the receipt with receipt id: '||
5039: l_unbal_rcpt_tab(i).cash_receipt_id||', created by automatic receipts for that invoice';
5040:
5041: arp_standard.debug('Inserting Exception');
5042:
5043: insert_exceptions(
5044: p_batch_id => p_batch_id,
5045: p_request_id => pg_request_id,