129: pl_return_status VARCHAR2(1);
130: pl_msg_count NUMBER;
131: pl_msg_data VARCHAR2(240);
132: BEGIN
133: --arp_standard.enable_debug;
134: --arp_standard.enable_file_debug('/appslog/fin_top/utl/finixud/out','chat67.log');
135: IF PG_DEBUG in ('Y', 'C') THEN
136: fnd_file.put_line(FND_FILE.LOG,'autoremapi start ()+');
137: fnd_file.put_line(FND_FILE.LOG, 'value of p_errbuf ' || P_ERRBUF);
130: pl_msg_count NUMBER;
131: pl_msg_data VARCHAR2(240);
132: BEGIN
133: --arp_standard.enable_debug;
134: --arp_standard.enable_file_debug('/appslog/fin_top/utl/finixud/out','chat67.log');
135: IF PG_DEBUG in ('Y', 'C') THEN
136: fnd_file.put_line(FND_FILE.LOG,'autoremapi start ()+');
137: fnd_file.put_line(FND_FILE.LOG, 'value of p_errbuf ' || P_ERRBUF);
138: fnd_file.put_line(FND_FILE.LOG, 'value of p_retcode ' || (P_RETCODE));
212: fnd_file.put_line(FND_FILE.LOG, 'value of l_remittance_bank_branch_id '|| l_remittance_bank_branch_id);
213: fnd_file.put_line(FND_FILE.LOG, 'value of l_remittance_bank_account_id '|| l_remittance_bank_account_id);
214: END IF;
215:
216: l_request_id := arp_standard.profile.request_id;
217: l_last_updated_by := arp_standard.profile.last_update_login ;
218: l_created_by := arp_standard.profile.user_id ;
219: l_last_update_login := arp_standard.profile.last_update_login ;
220: l_program_application_id := arp_standard.application_id ;
213: fnd_file.put_line(FND_FILE.LOG, 'value of l_remittance_bank_account_id '|| l_remittance_bank_account_id);
214: END IF;
215:
216: l_request_id := arp_standard.profile.request_id;
217: l_last_updated_by := arp_standard.profile.last_update_login ;
218: l_created_by := arp_standard.profile.user_id ;
219: l_last_update_login := arp_standard.profile.last_update_login ;
220: l_program_application_id := arp_standard.application_id ;
221: l_program_id := arp_standard.profile.program_id;
214: END IF;
215:
216: l_request_id := arp_standard.profile.request_id;
217: l_last_updated_by := arp_standard.profile.last_update_login ;
218: l_created_by := arp_standard.profile.user_id ;
219: l_last_update_login := arp_standard.profile.last_update_login ;
220: l_program_application_id := arp_standard.application_id ;
221: l_program_id := arp_standard.profile.program_id;
222: pg_create_flag := p_create_flag;
215:
216: l_request_id := arp_standard.profile.request_id;
217: l_last_updated_by := arp_standard.profile.last_update_login ;
218: l_created_by := arp_standard.profile.user_id ;
219: l_last_update_login := arp_standard.profile.last_update_login ;
220: l_program_application_id := arp_standard.application_id ;
221: l_program_id := arp_standard.profile.program_id;
222: pg_create_flag := p_create_flag;
223: pg_approve_flag := p_approve_flag;
216: l_request_id := arp_standard.profile.request_id;
217: l_last_updated_by := arp_standard.profile.last_update_login ;
218: l_created_by := arp_standard.profile.user_id ;
219: l_last_update_login := arp_standard.profile.last_update_login ;
220: l_program_application_id := arp_standard.application_id ;
221: l_program_id := arp_standard.profile.program_id;
222: pg_create_flag := p_create_flag;
223: pg_approve_flag := p_approve_flag;
224: pg_format_flag := p_format_flag;
217: l_last_updated_by := arp_standard.profile.last_update_login ;
218: l_created_by := arp_standard.profile.user_id ;
219: l_last_update_login := arp_standard.profile.last_update_login ;
220: l_program_application_id := arp_standard.application_id ;
221: l_program_id := arp_standard.profile.program_id;
222: pg_create_flag := p_create_flag;
223: pg_approve_flag := p_approve_flag;
224: pg_format_flag := p_format_flag;
225:
1067: fnd_file.put_line( FND_FILE.LOG, 'Batch_Applied_Status : ' || l_batch_applied_status);
1068:
1069: IF l_batch_applied_status = 'COMPLETED_CREATION' THEN
1070: IF l_create_flag = 'Y' THEN
1071: arp_standard.debug( 'This is an error condition');
1072: arp_standard.debug('Batch is already created.');
1073: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Created.');
1074: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1075: APP_EXCEPTION.raise_exception;
1068:
1069: IF l_batch_applied_status = 'COMPLETED_CREATION' THEN
1070: IF l_create_flag = 'Y' THEN
1071: arp_standard.debug( 'This is an error condition');
1072: arp_standard.debug('Batch is already created.');
1073: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Created.');
1074: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1075: APP_EXCEPTION.raise_exception;
1076: ELSIF l_approve_flag = 'N' AND l_format_flag = 'Y' THEN
1073: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Created.');
1074: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1075: APP_EXCEPTION.raise_exception;
1076: ELSIF l_approve_flag = 'N' AND l_format_flag = 'Y' THEN
1077: arp_standard.debug( 'This is an error condition');
1078: arp_standard.debug('Batch should be Approved before Formatting.');
1079: fnd_file.put_line( FND_FILE.LOG, 'Batch should be Approved before Formatting.');
1080: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1081: APP_EXCEPTION.raise_exception;
1074: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1075: APP_EXCEPTION.raise_exception;
1076: ELSIF l_approve_flag = 'N' AND l_format_flag = 'Y' THEN
1077: arp_standard.debug( 'This is an error condition');
1078: arp_standard.debug('Batch should be Approved before Formatting.');
1079: fnd_file.put_line( FND_FILE.LOG, 'Batch should be Approved before Formatting.');
1080: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1081: APP_EXCEPTION.raise_exception;
1082: END IF;
1081: APP_EXCEPTION.raise_exception;
1082: END IF;
1083: ELSIF l_batch_applied_status = 'COMPLETED_APPROVAL' AND
1084: (l_create_flag = 'Y' OR l_approve_flag = 'Y') THEN
1085: arp_standard.debug( 'This is an error condition');
1086: arp_standard.debug( 'Batch is already Approved.');
1087: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Approved.');
1088: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1089: APP_EXCEPTION.raise_exception;
1082: END IF;
1083: ELSIF l_batch_applied_status = 'COMPLETED_APPROVAL' AND
1084: (l_create_flag = 'Y' OR l_approve_flag = 'Y') THEN
1085: arp_standard.debug( 'This is an error condition');
1086: arp_standard.debug( 'Batch is already Approved.');
1087: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Approved.');
1088: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1089: APP_EXCEPTION.raise_exception;
1090: ELSIF l_batch_applied_status = 'COMPLETED_FORMAT' AND
1088: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1089: APP_EXCEPTION.raise_exception;
1090: ELSIF l_batch_applied_status = 'COMPLETED_FORMAT' AND
1091: (l_create_flag = 'Y' OR l_approve_flag = 'Y' )THEN
1092: arp_standard.debug( 'This is an error condition');
1093: arp_standard.debug( 'Batch is already Formatted.');
1094: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Formatted.');
1095: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1096: APP_EXCEPTION.raise_exception;
1089: APP_EXCEPTION.raise_exception;
1090: ELSIF l_batch_applied_status = 'COMPLETED_FORMAT' AND
1091: (l_create_flag = 'Y' OR l_approve_flag = 'Y' )THEN
1092: arp_standard.debug( 'This is an error condition');
1093: arp_standard.debug( 'Batch is already Formatted.');
1094: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Formatted.');
1095: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1096: APP_EXCEPTION.raise_exception;
1097: END IF;
1146: p_remit_bank_account_id=> l_remittance_bank_account_id ,
1147: p_return_status=>l_return_status);
1148:
1149: ELSIF p_batch_id IS NULL and l_create_flag = 'N' THEN
1150: arp_standard.debug( 'This is an error condition');
1151: arp_standard.debug( 'Batch Name is not supplied.');
1152: fnd_file.put_line( FND_FILE.LOG, 'Create is No and No Batch Name is Supplied.');
1153: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1154: APP_EXCEPTION.raise_exception;
1147: p_return_status=>l_return_status);
1148:
1149: ELSIF p_batch_id IS NULL and l_create_flag = 'N' THEN
1150: arp_standard.debug( 'This is an error condition');
1151: arp_standard.debug( 'Batch Name is not supplied.');
1152: fnd_file.put_line( FND_FILE.LOG, 'Create is No and No Batch Name is Supplied.');
1153: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1154: APP_EXCEPTION.raise_exception;
1155: ELSE
1157: END IF;
1158:
1159: --Error condition
1160: IF o_batch_id IS NULL THEN
1161: arp_standard.debug( 'This is an error condition');
1162: insert_exceptions( p_batch_id => -333,
1163: p_request_id =>l_request_id,
1164: p_exception_code => 'NO_BATCH',
1165: p_additional_message => 'Error during inserting the
1164: p_exception_code => 'NO_BATCH',
1165: p_additional_message => 'Error during inserting the
1166: batch' );
1167:
1168: arp_standard.debug ( 'calling the report - batch_id ' || -333 );
1169: arp_standard.debug ( 'calling the report ' || l_request_id);
1170:
1171: submit_report ( p_batch_id => o_batch_id,
1172: p_request_id => l_request_id);
1165: p_additional_message => 'Error during inserting the
1166: batch' );
1167:
1168: arp_standard.debug ( 'calling the report - batch_id ' || -333 );
1169: arp_standard.debug ( 'calling the report ' || l_request_id);
1170:
1171: submit_report ( p_batch_id => o_batch_id,
1172: p_request_id => l_request_id);
1173: RETURN;
1307: fnd_file.put_line(FND_FILE.LOG,'worker # : ' || l_worker_number );
1308: submit_subrequest (l_worker_number,l_org_id);
1309: END LOOP;
1310:
1311: arp_standard.debug ( 'The Master program waits for child processes');
1312:
1313: -- Wait for the completion of the submitted requests
1314: FOR i in 1..p_total_workers LOOP
1315:
1502:
1503: --p_batch_id := 10;
1504:
1505:
1506: l_request_id := arp_standard.profile.request_id;
1507: l_last_updated_by := arp_standard.profile.last_update_login ;
1508: l_created_by := arp_standard.profile.user_id ;
1509: l_last_update_login := arp_standard.profile.last_update_login ;
1510: l_program_application_id := arp_standard.application_id ;
1503: --p_batch_id := 10;
1504:
1505:
1506: l_request_id := arp_standard.profile.request_id;
1507: l_last_updated_by := arp_standard.profile.last_update_login ;
1508: l_created_by := arp_standard.profile.user_id ;
1509: l_last_update_login := arp_standard.profile.last_update_login ;
1510: l_program_application_id := arp_standard.application_id ;
1511: l_program_id := arp_standard.profile.program_id;
1504:
1505:
1506: l_request_id := arp_standard.profile.request_id;
1507: l_last_updated_by := arp_standard.profile.last_update_login ;
1508: l_created_by := arp_standard.profile.user_id ;
1509: l_last_update_login := arp_standard.profile.last_update_login ;
1510: l_program_application_id := arp_standard.application_id ;
1511: l_program_id := arp_standard.profile.program_id;
1512:
1505:
1506: l_request_id := arp_standard.profile.request_id;
1507: l_last_updated_by := arp_standard.profile.last_update_login ;
1508: l_created_by := arp_standard.profile.user_id ;
1509: l_last_update_login := arp_standard.profile.last_update_login ;
1510: l_program_application_id := arp_standard.application_id ;
1511: l_program_id := arp_standard.profile.program_id;
1512:
1513: IF PG_DEBUG in ('Y', 'C') THEN
1506: l_request_id := arp_standard.profile.request_id;
1507: l_last_updated_by := arp_standard.profile.last_update_login ;
1508: l_created_by := arp_standard.profile.user_id ;
1509: l_last_update_login := arp_standard.profile.last_update_login ;
1510: l_program_application_id := arp_standard.application_id ;
1511: l_program_id := arp_standard.profile.program_id;
1512:
1513: IF PG_DEBUG in ('Y', 'C') THEN
1514: fnd_file.put_line(FND_FILE.LOG,'autoremapi calling auto_batch ()+');
1507: l_last_updated_by := arp_standard.profile.last_update_login ;
1508: l_created_by := arp_standard.profile.user_id ;
1509: l_last_update_login := arp_standard.profile.last_update_login ;
1510: l_program_application_id := arp_standard.application_id ;
1511: l_program_id := arp_standard.profile.program_id;
1512:
1513: IF PG_DEBUG in ('Y', 'C') THEN
1514: fnd_file.put_line(FND_FILE.LOG,'autoremapi calling auto_batch ()+');
1515: END IF;
1632:
1633: batch_id := to_char(l_batch_id);
1634:
1635: IF batch_id IS NULL THEN
1636: arp_standard.debug ('WAIT HERE THE VALUE OF BATCH_ID IS NULL ERROR');
1637: -- G_ERROR := 'Y';
1638: END IF;
1639:
1640: IF PG_DEBUG in ('Y', 'C') THEN
1648:
1649: p_batch_id := to_number(l_batch_id);
1650:
1651: IF p_batch_id IS NULL THEN
1652: arp_standard.debug ('WAIT HERE THE VALUE OF BATCH_ID IS NULL ERROR');
1653: END IF;
1654:
1655: IF PG_DEBUG in ('Y', 'C') THEN
1656: fnd_file.put_line(FND_FILE.LOG, 'value of batch_id '||p_batch_id);
1856: from ar_batches
1857: where batch_id = p_batch_id;
1858:
1859:
1860: l_request_id := arp_standard.profile.request_id;
1861: l_last_updated_by := arp_standard.profile.last_update_login ;
1862: l_created_by := arp_standard.profile.user_id ;
1863: l_last_update_login := arp_standard.profile.last_update_login ;
1864: l_program_application_id := arp_standard.application_id ;
1857: where batch_id = p_batch_id;
1858:
1859:
1860: l_request_id := arp_standard.profile.request_id;
1861: l_last_updated_by := arp_standard.profile.last_update_login ;
1862: l_created_by := arp_standard.profile.user_id ;
1863: l_last_update_login := arp_standard.profile.last_update_login ;
1864: l_program_application_id := arp_standard.application_id ;
1865: l_program_id := arp_standard.profile.program_id;
1858:
1859:
1860: l_request_id := arp_standard.profile.request_id;
1861: l_last_updated_by := arp_standard.profile.last_update_login ;
1862: l_created_by := arp_standard.profile.user_id ;
1863: l_last_update_login := arp_standard.profile.last_update_login ;
1864: l_program_application_id := arp_standard.application_id ;
1865: l_program_id := arp_standard.profile.program_id;
1866: l_org_id := arp_standard.sysparm.org_id;
1859:
1860: l_request_id := arp_standard.profile.request_id;
1861: l_last_updated_by := arp_standard.profile.last_update_login ;
1862: l_created_by := arp_standard.profile.user_id ;
1863: l_last_update_login := arp_standard.profile.last_update_login ;
1864: l_program_application_id := arp_standard.application_id ;
1865: l_program_id := arp_standard.profile.program_id;
1866: l_org_id := arp_standard.sysparm.org_id;
1867:
1860: l_request_id := arp_standard.profile.request_id;
1861: l_last_updated_by := arp_standard.profile.last_update_login ;
1862: l_created_by := arp_standard.profile.user_id ;
1863: l_last_update_login := arp_standard.profile.last_update_login ;
1864: l_program_application_id := arp_standard.application_id ;
1865: l_program_id := arp_standard.profile.program_id;
1866: l_org_id := arp_standard.sysparm.org_id;
1867:
1868:
1861: l_last_updated_by := arp_standard.profile.last_update_login ;
1862: l_created_by := arp_standard.profile.user_id ;
1863: l_last_update_login := arp_standard.profile.last_update_login ;
1864: l_program_application_id := arp_standard.application_id ;
1865: l_program_id := arp_standard.profile.program_id;
1866: l_org_id := arp_standard.sysparm.org_id;
1867:
1868:
1869: l_sel_stmt := ' SELECT cr.cash_receipt_id,
1862: l_created_by := arp_standard.profile.user_id ;
1863: l_last_update_login := arp_standard.profile.last_update_login ;
1864: l_program_application_id := arp_standard.application_id ;
1865: l_program_id := arp_standard.profile.program_id;
1866: l_org_id := arp_standard.sysparm.org_id;
1867:
1868:
1869: l_sel_stmt := ' SELECT cr.cash_receipt_id,
1870: rm.payment_channel_code,
2142:
2143: dbms_sql.close_cursor(rem_t1);
2144:
2145: IF PG_DEBUG in ('Y', 'C') THEN
2146: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2147: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');
2148: END IF;
2149:
2150: EXCEPTION WHEN OTHERS THEN
2636: into l_factor_flag
2637: from ar_batches
2638: where batch_id = p_batch_id;
2639:
2640: l_request_id := arp_standard.profile.request_id;
2641: l_last_updated_by := arp_standard.profile.last_update_login ;
2642: l_created_by := arp_standard.profile.user_id ;
2643: l_last_update_login := arp_standard.profile.last_update_login ;
2644: l_program_application_id := arp_standard.application_id ;
2637: from ar_batches
2638: where batch_id = p_batch_id;
2639:
2640: l_request_id := arp_standard.profile.request_id;
2641: l_last_updated_by := arp_standard.profile.last_update_login ;
2642: l_created_by := arp_standard.profile.user_id ;
2643: l_last_update_login := arp_standard.profile.last_update_login ;
2644: l_program_application_id := arp_standard.application_id ;
2645: l_program_id := arp_standard.profile.program_id;
2638: where batch_id = p_batch_id;
2639:
2640: l_request_id := arp_standard.profile.request_id;
2641: l_last_updated_by := arp_standard.profile.last_update_login ;
2642: l_created_by := arp_standard.profile.user_id ;
2643: l_last_update_login := arp_standard.profile.last_update_login ;
2644: l_program_application_id := arp_standard.application_id ;
2645: l_program_id := arp_standard.profile.program_id;
2646: l_org_id := arp_standard.sysparm.org_id;
2639:
2640: l_request_id := arp_standard.profile.request_id;
2641: l_last_updated_by := arp_standard.profile.last_update_login ;
2642: l_created_by := arp_standard.profile.user_id ;
2643: l_last_update_login := arp_standard.profile.last_update_login ;
2644: l_program_application_id := arp_standard.application_id ;
2645: l_program_id := arp_standard.profile.program_id;
2646: l_org_id := arp_standard.sysparm.org_id;
2647:
2640: l_request_id := arp_standard.profile.request_id;
2641: l_last_updated_by := arp_standard.profile.last_update_login ;
2642: l_created_by := arp_standard.profile.user_id ;
2643: l_last_update_login := arp_standard.profile.last_update_login ;
2644: l_program_application_id := arp_standard.application_id ;
2645: l_program_id := arp_standard.profile.program_id;
2646: l_org_id := arp_standard.sysparm.org_id;
2647:
2648:
2641: l_last_updated_by := arp_standard.profile.last_update_login ;
2642: l_created_by := arp_standard.profile.user_id ;
2643: l_last_update_login := arp_standard.profile.last_update_login ;
2644: l_program_application_id := arp_standard.application_id ;
2645: l_program_id := arp_standard.profile.program_id;
2646: l_org_id := arp_standard.sysparm.org_id;
2647:
2648:
2649: l_sel_stmt := ' SELECT cash_receipt_id,
2642: l_created_by := arp_standard.profile.user_id ;
2643: l_last_update_login := arp_standard.profile.last_update_login ;
2644: l_program_application_id := arp_standard.application_id ;
2645: l_program_id := arp_standard.profile.program_id;
2646: l_org_id := arp_standard.sysparm.org_id;
2647:
2648:
2649: l_sel_stmt := ' SELECT cash_receipt_id,
2650: payment_channel_code,
2901:
2902: dbms_sql.close_cursor(rem_t1);
2903:
2904: IF PG_DEBUG in ('Y', 'C') THEN
2905: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2906: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');
2907: END IF;
2908:
2909: EXCEPTION WHEN OTHERS THEN
3324: l_program_application_id NUMBER;
3325: l_program_id NUMBER;
3326:
3327: BEGIN
3328: l_request_id := arp_standard.profile.request_id;
3329: l_last_updated_by := arp_standard.profile.last_update_login ;
3330: l_created_by := arp_standard.profile.user_id ;
3331: l_last_update_login := arp_standard.profile.last_update_login ;
3332: l_program_application_id := arp_standard.application_id ;
3325: l_program_id NUMBER;
3326:
3327: BEGIN
3328: l_request_id := arp_standard.profile.request_id;
3329: l_last_updated_by := arp_standard.profile.last_update_login ;
3330: l_created_by := arp_standard.profile.user_id ;
3331: l_last_update_login := arp_standard.profile.last_update_login ;
3332: l_program_application_id := arp_standard.application_id ;
3333: l_program_id := arp_standard.profile.program_id;
3326:
3327: BEGIN
3328: l_request_id := arp_standard.profile.request_id;
3329: l_last_updated_by := arp_standard.profile.last_update_login ;
3330: l_created_by := arp_standard.profile.user_id ;
3331: l_last_update_login := arp_standard.profile.last_update_login ;
3332: l_program_application_id := arp_standard.application_id ;
3333: l_program_id := arp_standard.profile.program_id;
3334:
3327: BEGIN
3328: l_request_id := arp_standard.profile.request_id;
3329: l_last_updated_by := arp_standard.profile.last_update_login ;
3330: l_created_by := arp_standard.profile.user_id ;
3331: l_last_update_login := arp_standard.profile.last_update_login ;
3332: l_program_application_id := arp_standard.application_id ;
3333: l_program_id := arp_standard.profile.program_id;
3334:
3335: IF PG_DEBUG in ('Y', 'C') THEN
3328: l_request_id := arp_standard.profile.request_id;
3329: l_last_updated_by := arp_standard.profile.last_update_login ;
3330: l_created_by := arp_standard.profile.user_id ;
3331: l_last_update_login := arp_standard.profile.last_update_login ;
3332: l_program_application_id := arp_standard.application_id ;
3333: l_program_id := arp_standard.profile.program_id;
3334:
3335: IF PG_DEBUG in ('Y', 'C') THEN
3336: fnd_file.put_line(FND_FILE.LOG,'sel and upd receipts start ()+');
3329: l_last_updated_by := arp_standard.profile.last_update_login ;
3330: l_created_by := arp_standard.profile.user_id ;
3331: l_last_update_login := arp_standard.profile.last_update_login ;
3332: l_program_application_id := arp_standard.application_id ;
3333: l_program_id := arp_standard.profile.program_id;
3334:
3335: IF PG_DEBUG in ('Y', 'C') THEN
3336: fnd_file.put_line(FND_FILE.LOG,'sel and upd receipts start ()+');
3337: fnd_file.put_line(FND_FILE.LOG,'the input parameters are ');
3405: (cr.type = ''MISC'' and cr.amount < 0))
3406: AND cr.set_of_books_id = :bs_sob_id
3407: AND rm.receipt_class_id = rclass.receipt_class_id
3408: AND (rclass.remit_method_code = :bs_remit_method_code
3409: OR rclass.remit_method_code = ''STANDARD_AND_FACTORING''
3410: )
3411: AND rma1.receipt_method_id = cr.receipt_method_id
3412: AND rma1.REMIT_BANK_ACCT_USE_ID = cr.REMIT_BANK_ACCT_USE_ID
3413: AND rma2.receipt_method_id = rma1.receipt_method_id
3727: fnd_file.put_line(FND_FILE.LOG, 'Entering payment processing...');
3728: END IF;
3729:
3730:
3731: l_request_id := arp_standard.profile.request_id;
3732: l_last_updated_by := arp_standard.profile.last_update_login ;
3733: l_created_by := arp_standard.profile.user_id ;
3734: l_last_update_login := arp_standard.profile.last_update_login ;
3735: l_program_application_id := arp_standard.application_id ;
3728: END IF;
3729:
3730:
3731: l_request_id := arp_standard.profile.request_id;
3732: l_last_updated_by := arp_standard.profile.last_update_login ;
3733: l_created_by := arp_standard.profile.user_id ;
3734: l_last_update_login := arp_standard.profile.last_update_login ;
3735: l_program_application_id := arp_standard.application_id ;
3736: l_program_id := arp_standard.profile.program_id;
3729:
3730:
3731: l_request_id := arp_standard.profile.request_id;
3732: l_last_updated_by := arp_standard.profile.last_update_login ;
3733: l_created_by := arp_standard.profile.user_id ;
3734: l_last_update_login := arp_standard.profile.last_update_login ;
3735: l_program_application_id := arp_standard.application_id ;
3736: l_program_id := arp_standard.profile.program_id;
3737:
3730:
3731: l_request_id := arp_standard.profile.request_id;
3732: l_last_updated_by := arp_standard.profile.last_update_login ;
3733: l_created_by := arp_standard.profile.user_id ;
3734: l_last_update_login := arp_standard.profile.last_update_login ;
3735: l_program_application_id := arp_standard.application_id ;
3736: l_program_id := arp_standard.profile.program_id;
3737:
3738:
3731: l_request_id := arp_standard.profile.request_id;
3732: l_last_updated_by := arp_standard.profile.last_update_login ;
3733: l_created_by := arp_standard.profile.user_id ;
3734: l_last_update_login := arp_standard.profile.last_update_login ;
3735: l_program_application_id := arp_standard.application_id ;
3736: l_program_id := arp_standard.profile.program_id;
3737:
3738:
3739:
3732: l_last_updated_by := arp_standard.profile.last_update_login ;
3733: l_created_by := arp_standard.profile.user_id ;
3734: l_last_update_login := arp_standard.profile.last_update_login ;
3735: l_program_application_id := arp_standard.application_id ;
3736: l_program_id := arp_standard.profile.program_id;
3737:
3738:
3739:
3740:
3783:
3784: -- set up auth_attribs record:
3785: l_auth_attribs_rec.RiskEval_Enable_Flag := 'N';
3786: -- set up trxn_attribs record:
3787: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;
3788: l_trxn_attribs_rec.order_id := rct_info.receipt_number;
3789: l_trxn_attribs_rec.Trxn_Ref_Number1 := 'RECEIPT';
3790: l_trxn_attribs_rec.Trxn_Ref_Number2 := rct_info.cash_receipt_id;
3791:
4480: fnd_file.put_line(FND_FILE.LOG, 'Entering payment processing parallel...');
4481: END IF;
4482:
4483:
4484: l_request_id := arp_standard.profile.request_id;
4485: l_last_updated_by := arp_standard.profile.last_update_login ;
4486: l_created_by := arp_standard.profile.user_id ;
4487: l_last_update_login := arp_standard.profile.last_update_login ;
4488: l_program_application_id := arp_standard.application_id ;
4481: END IF;
4482:
4483:
4484: l_request_id := arp_standard.profile.request_id;
4485: l_last_updated_by := arp_standard.profile.last_update_login ;
4486: l_created_by := arp_standard.profile.user_id ;
4487: l_last_update_login := arp_standard.profile.last_update_login ;
4488: l_program_application_id := arp_standard.application_id ;
4489: l_program_id := arp_standard.profile.program_id;
4482:
4483:
4484: l_request_id := arp_standard.profile.request_id;
4485: l_last_updated_by := arp_standard.profile.last_update_login ;
4486: l_created_by := arp_standard.profile.user_id ;
4487: l_last_update_login := arp_standard.profile.last_update_login ;
4488: l_program_application_id := arp_standard.application_id ;
4489: l_program_id := arp_standard.profile.program_id;
4490:
4483:
4484: l_request_id := arp_standard.profile.request_id;
4485: l_last_updated_by := arp_standard.profile.last_update_login ;
4486: l_created_by := arp_standard.profile.user_id ;
4487: l_last_update_login := arp_standard.profile.last_update_login ;
4488: l_program_application_id := arp_standard.application_id ;
4489: l_program_id := arp_standard.profile.program_id;
4490:
4491:
4484: l_request_id := arp_standard.profile.request_id;
4485: l_last_updated_by := arp_standard.profile.last_update_login ;
4486: l_created_by := arp_standard.profile.user_id ;
4487: l_last_update_login := arp_standard.profile.last_update_login ;
4488: l_program_application_id := arp_standard.application_id ;
4489: l_program_id := arp_standard.profile.program_id;
4490:
4491:
4492:
4485: l_last_updated_by := arp_standard.profile.last_update_login ;
4486: l_created_by := arp_standard.profile.user_id ;
4487: l_last_update_login := arp_standard.profile.last_update_login ;
4488: l_program_application_id := arp_standard.application_id ;
4489: l_program_id := arp_standard.profile.program_id;
4490:
4491:
4492:
4493:
4536:
4537: -- set up auth_attribs record:
4538: l_auth_attribs_rec.RiskEval_Enable_Flag := 'N';
4539: -- set up trxn_attribs record:
4540: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;
4541: l_trxn_attribs_rec.order_id := rct_info.receipt_number;
4542: l_trxn_attribs_rec.Trxn_Ref_Number1 := 'RECEIPT';
4543: l_trxn_attribs_rec.Trxn_Ref_Number2 := rct_info.cash_receipt_id;
4544:
5198:
5199:
5200:
5201:
5202: l_request_id := arp_standard.profile.request_id;
5203: l_last_updated_by := arp_standard.profile.last_update_login ;
5204: l_created_by := arp_standard.profile.user_id ;
5205: l_last_update_login := arp_standard.profile.last_update_login ;
5206: l_program_application_id := arp_standard.application_id ;
5199:
5200:
5201:
5202: l_request_id := arp_standard.profile.request_id;
5203: l_last_updated_by := arp_standard.profile.last_update_login ;
5204: l_created_by := arp_standard.profile.user_id ;
5205: l_last_update_login := arp_standard.profile.last_update_login ;
5206: l_program_application_id := arp_standard.application_id ;
5207: l_program_id := arp_standard.profile.program_id;
5200:
5201:
5202: l_request_id := arp_standard.profile.request_id;
5203: l_last_updated_by := arp_standard.profile.last_update_login ;
5204: l_created_by := arp_standard.profile.user_id ;
5205: l_last_update_login := arp_standard.profile.last_update_login ;
5206: l_program_application_id := arp_standard.application_id ;
5207: l_program_id := arp_standard.profile.program_id;
5208:
5201:
5202: l_request_id := arp_standard.profile.request_id;
5203: l_last_updated_by := arp_standard.profile.last_update_login ;
5204: l_created_by := arp_standard.profile.user_id ;
5205: l_last_update_login := arp_standard.profile.last_update_login ;
5206: l_program_application_id := arp_standard.application_id ;
5207: l_program_id := arp_standard.profile.program_id;
5208:
5209: IF PG_DEBUG in ('Y','C') THEN
5202: l_request_id := arp_standard.profile.request_id;
5203: l_last_updated_by := arp_standard.profile.last_update_login ;
5204: l_created_by := arp_standard.profile.user_id ;
5205: l_last_update_login := arp_standard.profile.last_update_login ;
5206: l_program_application_id := arp_standard.application_id ;
5207: l_program_id := arp_standard.profile.program_id;
5208:
5209: IF PG_DEBUG in ('Y','C') THEN
5210:
5203: l_last_updated_by := arp_standard.profile.last_update_login ;
5204: l_created_by := arp_standard.profile.user_id ;
5205: l_last_update_login := arp_standard.profile.last_update_login ;
5206: l_program_application_id := arp_standard.application_id ;
5207: l_program_id := arp_standard.profile.program_id;
5208:
5209: IF PG_DEBUG in ('Y','C') THEN
5210:
5211: fnd_file.put_line(FND_FILE.LOG, 'value of l_request_id ' || l_request_id );
5439: IF PG_DEBUG in ('Y', 'C') THEN
5440: fnd_file.put_line(FND_FILE.LOG,'control_check()+');
5441: END IF;
5442:
5443: l_request_id := arp_standard.profile.request_id;
5444: l_last_updated_by := arp_standard.profile.last_update_login ;
5445: l_created_by := arp_standard.profile.user_id ;
5446: l_last_update_login := arp_standard.profile.last_update_login ;
5447: l_program_application_id := arp_standard.application_id ;
5440: fnd_file.put_line(FND_FILE.LOG,'control_check()+');
5441: END IF;
5442:
5443: l_request_id := arp_standard.profile.request_id;
5444: l_last_updated_by := arp_standard.profile.last_update_login ;
5445: l_created_by := arp_standard.profile.user_id ;
5446: l_last_update_login := arp_standard.profile.last_update_login ;
5447: l_program_application_id := arp_standard.application_id ;
5448: l_program_id := arp_standard.profile.program_id;
5441: END IF;
5442:
5443: l_request_id := arp_standard.profile.request_id;
5444: l_last_updated_by := arp_standard.profile.last_update_login ;
5445: l_created_by := arp_standard.profile.user_id ;
5446: l_last_update_login := arp_standard.profile.last_update_login ;
5447: l_program_application_id := arp_standard.application_id ;
5448: l_program_id := arp_standard.profile.program_id;
5449:
5442:
5443: l_request_id := arp_standard.profile.request_id;
5444: l_last_updated_by := arp_standard.profile.last_update_login ;
5445: l_created_by := arp_standard.profile.user_id ;
5446: l_last_update_login := arp_standard.profile.last_update_login ;
5447: l_program_application_id := arp_standard.application_id ;
5448: l_program_id := arp_standard.profile.program_id;
5449:
5450: UPDATE ar_cash_receipts
5443: l_request_id := arp_standard.profile.request_id;
5444: l_last_updated_by := arp_standard.profile.last_update_login ;
5445: l_created_by := arp_standard.profile.user_id ;
5446: l_last_update_login := arp_standard.profile.last_update_login ;
5447: l_program_application_id := arp_standard.application_id ;
5448: l_program_id := arp_standard.profile.program_id;
5449:
5450: UPDATE ar_cash_receipts
5451: SET cc_error_flag = 'Y',
5444: l_last_updated_by := arp_standard.profile.last_update_login ;
5445: l_created_by := arp_standard.profile.user_id ;
5446: l_last_update_login := arp_standard.profile.last_update_login ;
5447: l_program_application_id := arp_standard.application_id ;
5448: l_program_id := arp_standard.profile.program_id;
5449:
5450: UPDATE ar_cash_receipts
5451: SET cc_error_flag = 'Y',
5452: last_updated_by = l_last_updated_by,
5748:
5749: EXCEPTION
5750: WHEN OTHERS THEN
5751: IF PG_DEBUG in ('Y', 'C') THEN
5752: arp_standard.debug('rec_reset ERROR.'|| SQLERRM );
5753: END IF;
5754:
5755: END rec_reset;
5756: