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_AUTOREM_API dependencies on ARP_STANDARD

Line 133: --arp_standard.enable_debug;

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);

Line 134: --arp_standard.enable_file_debug('/appslog/fin_top/utl/finixud/out','chat67.log');

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));

Line 216: l_request_id := arp_standard.profile.request_id;

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 ;

Line 217: l_last_updated_by := arp_standard.profile.last_update_login ;

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;

Line 218: l_created_by := arp_standard.profile.user_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;

Line 219: l_last_update_login := arp_standard.profile.last_update_login ;

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;

Line 220: l_program_application_id := arp_standard.application_id ;

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;

Line 221: l_program_id := arp_standard.profile.program_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;
225:

Line 1071: arp_standard.debug( 'This is an error condition');

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;

Line 1072: arp_standard.debug('Batch is already created.');

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

Line 1077: arp_standard.debug( 'This is an error condition');

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;

Line 1078: arp_standard.debug('Batch should be Approved before Formatting.');

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;

Line 1085: arp_standard.debug( 'This is an error condition');

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;

Line 1086: arp_standard.debug( 'Batch is already Approved.');

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

Line 1092: arp_standard.debug( 'This is an error condition');

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;

Line 1093: arp_standard.debug( 'Batch is already Formatted.');

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;

Line 1150: arp_standard.debug( 'This is an error condition');

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;

Line 1151: arp_standard.debug( 'Batch Name is not supplied.');

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

Line 1161: arp_standard.debug( 'This is an error condition');

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

Line 1168: arp_standard.debug ( 'calling the report - batch_id ' || -333 );

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);

Line 1169: arp_standard.debug ( 'calling the report ' || 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;

Line 1311: arp_standard.debug ( 'The Master program waits for child processes');

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:

Line 1506: l_request_id := arp_standard.profile.request_id;

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 ;

Line 1507: l_last_updated_by := arp_standard.profile.last_update_login ;

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;

Line 1508: l_created_by := arp_standard.profile.user_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:

Line 1509: l_last_update_login := arp_standard.profile.last_update_login ;

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

Line 1510: l_program_application_id := arp_standard.application_id ;

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 ()+');

Line 1511: l_program_id := arp_standard.profile.program_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 ()+');
1515: END IF;

Line 1636: arp_standard.debug ('WAIT HERE THE VALUE OF BATCH_ID IS NULL ERROR');

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

Line 1652: arp_standard.debug ('WAIT HERE THE VALUE OF BATCH_ID IS NULL ERROR');

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);

Line 1860: l_request_id := arp_standard.profile.request_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 ;

Line 1861: l_last_updated_by := arp_standard.profile.last_update_login ;

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;

Line 1862: l_created_by := arp_standard.profile.user_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;

Line 1863: l_last_update_login := arp_standard.profile.last_update_login ;

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:

Line 1864: l_program_application_id := arp_standard.application_id ;

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:

Line 1865: l_program_id := arp_standard.profile.program_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:
1869: l_sel_stmt := ' SELECT cr.cash_receipt_id,

Line 1866: l_org_id := arp_standard.sysparm.org_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,

Line 2146: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');

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

Line 2640: l_request_id := arp_standard.profile.request_id;

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 ;

Line 2641: l_last_updated_by := arp_standard.profile.last_update_login ;

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;

Line 2642: l_created_by := arp_standard.profile.user_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;

Line 2643: l_last_update_login := arp_standard.profile.last_update_login ;

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:

Line 2644: l_program_application_id := arp_standard.application_id ;

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:

Line 2645: l_program_id := arp_standard.profile.program_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:
2649: l_sel_stmt := ' SELECT cash_receipt_id,

Line 2646: l_org_id := arp_standard.sysparm.org_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,

Line 2905: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');

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

Line 3328: l_request_id := arp_standard.profile.request_id;

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 ;

Line 3329: l_last_updated_by := arp_standard.profile.last_update_login ;

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;

Line 3330: l_created_by := arp_standard.profile.user_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:

Line 3331: l_last_update_login := arp_standard.profile.last_update_login ;

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

Line 3332: l_program_application_id := arp_standard.application_id ;

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 ()+');

Line 3333: l_program_id := arp_standard.profile.program_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 ()+');
3337: fnd_file.put_line(FND_FILE.LOG,'the input parameters are ');

Line 3731: l_request_id := arp_standard.profile.request_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 ;

Line 3732: l_last_updated_by := arp_standard.profile.last_update_login ;

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;

Line 3733: l_created_by := arp_standard.profile.user_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:

Line 3734: l_last_update_login := arp_standard.profile.last_update_login ;

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:

Line 3735: l_program_application_id := arp_standard.application_id ;

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:

Line 3736: l_program_id := arp_standard.profile.program_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:
3740:

Line 3787: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;

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:

Line 4484: l_request_id := arp_standard.profile.request_id;

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 ;

Line 4485: l_last_updated_by := arp_standard.profile.last_update_login ;

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;

Line 4486: l_created_by := arp_standard.profile.user_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:

Line 4487: l_last_update_login := arp_standard.profile.last_update_login ;

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:

Line 4488: l_program_application_id := arp_standard.application_id ;

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:

Line 4489: l_program_id := arp_standard.profile.program_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:
4493:

Line 4540: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;

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:

Line 5202: l_request_id := arp_standard.profile.request_id;

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 ;

Line 5203: l_last_updated_by := arp_standard.profile.last_update_login ;

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;

Line 5204: l_created_by := arp_standard.profile.user_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:

Line 5205: l_last_update_login := arp_standard.profile.last_update_login ;

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

Line 5206: l_program_application_id := arp_standard.application_id ;

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:

Line 5207: l_program_id := arp_standard.profile.program_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:
5211: fnd_file.put_line(FND_FILE.LOG, 'value of l_request_id ' || l_request_id );

Line 5443: l_request_id := arp_standard.profile.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 ;

Line 5444: l_last_updated_by := arp_standard.profile.last_update_login ;

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;

Line 5445: l_created_by := arp_standard.profile.user_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:

Line 5446: l_last_update_login := arp_standard.profile.last_update_login ;

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

Line 5447: l_program_application_id := arp_standard.application_id ;

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',

Line 5448: l_program_id := arp_standard.profile.program_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',
5452: last_updated_by = l_last_updated_by,

Line 5752: arp_standard.debug('rec_reset ERROR.'|| SQLERRM );

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: