APPS.AR_AUTOREM_API dependencies on ARP_STANDARD

Line 138: --arp_standard.enable_debug;

134: pl_msg_count NUMBER;
135: pl_msg_data VARCHAR2(240);
136: l_instrument_type ar_receipt_methods.payment_channel_code%type;
137: BEGIN
138: --arp_standard.enable_debug;
139: --arp_standard.enable_file_debug('/appslog/fin_top/utl/finixud/out','chat67.log');
140:
141: pg_execution_from := 'MANUAL';
142:

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

135: pl_msg_data VARCHAR2(240);
136: l_instrument_type ar_receipt_methods.payment_channel_code%type;
137: BEGIN
138: --arp_standard.enable_debug;
139: --arp_standard.enable_file_debug('/appslog/fin_top/utl/finixud/out','chat67.log');
140:
141: pg_execution_from := 'MANUAL';
142:
143: IF PG_DEBUG in ('Y', 'C') THEN

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

220: fnd_file.put_line(FND_FILE.LOG, 'value of l_remittance_bank_branch_id '|| l_remittance_bank_branch_id);
221: fnd_file.put_line(FND_FILE.LOG, 'value of l_remittance_bank_account_id '|| l_remittance_bank_account_id);
222: END IF;
223:
224: l_request_id := arp_standard.profile.request_id;
225: l_last_updated_by := arp_standard.profile.user_id ;
226: l_created_by := arp_standard.profile.user_id ;
227: l_last_update_login := arp_standard.profile.last_update_login ;
228: l_program_application_id := arp_standard.application_id ;

Line 225: l_last_updated_by := arp_standard.profile.user_id ;

221: fnd_file.put_line(FND_FILE.LOG, 'value of l_remittance_bank_account_id '|| l_remittance_bank_account_id);
222: END IF;
223:
224: l_request_id := arp_standard.profile.request_id;
225: l_last_updated_by := arp_standard.profile.user_id ;
226: l_created_by := arp_standard.profile.user_id ;
227: l_last_update_login := arp_standard.profile.last_update_login ;
228: l_program_application_id := arp_standard.application_id ;
229: l_program_id := arp_standard.profile.program_id;

Line 226: l_created_by := arp_standard.profile.user_id ;

222: END IF;
223:
224: l_request_id := arp_standard.profile.request_id;
225: l_last_updated_by := arp_standard.profile.user_id ;
226: l_created_by := arp_standard.profile.user_id ;
227: l_last_update_login := arp_standard.profile.last_update_login ;
228: l_program_application_id := arp_standard.application_id ;
229: l_program_id := arp_standard.profile.program_id;
230: pg_create_flag := p_create_flag;

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

223:
224: l_request_id := arp_standard.profile.request_id;
225: l_last_updated_by := arp_standard.profile.user_id ;
226: l_created_by := arp_standard.profile.user_id ;
227: l_last_update_login := arp_standard.profile.last_update_login ;
228: l_program_application_id := arp_standard.application_id ;
229: l_program_id := arp_standard.profile.program_id;
230: pg_create_flag := p_create_flag;
231: pg_approve_flag := p_approve_flag;

Line 228: l_program_application_id := arp_standard.application_id ;

224: l_request_id := arp_standard.profile.request_id;
225: l_last_updated_by := arp_standard.profile.user_id ;
226: l_created_by := arp_standard.profile.user_id ;
227: l_last_update_login := arp_standard.profile.last_update_login ;
228: l_program_application_id := arp_standard.application_id ;
229: l_program_id := arp_standard.profile.program_id;
230: pg_create_flag := p_create_flag;
231: pg_approve_flag := p_approve_flag;
232: pg_format_flag := p_format_flag;

Line 229: l_program_id := arp_standard.profile.program_id;

225: l_last_updated_by := arp_standard.profile.user_id ;
226: l_created_by := arp_standard.profile.user_id ;
227: l_last_update_login := arp_standard.profile.last_update_login ;
228: l_program_application_id := arp_standard.application_id ;
229: l_program_id := arp_standard.profile.program_id;
230: pg_create_flag := p_create_flag;
231: pg_approve_flag := p_approve_flag;
232: pg_format_flag := p_format_flag;
233:

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

1119: fnd_file.put_line( FND_FILE.LOG, 'Batch_Applied_Status : ' || l_batch_applied_status);
1120:
1121: IF l_batch_applied_status = 'COMPLETED_CREATION' THEN
1122: IF l_create_flag = 'Y' THEN
1123: arp_standard.debug( 'This is an error condition');
1124: arp_standard.debug('Batch is already created.');
1125: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Created.');
1126: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1127: APP_EXCEPTION.raise_exception;

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

1120:
1121: IF l_batch_applied_status = 'COMPLETED_CREATION' THEN
1122: IF l_create_flag = 'Y' THEN
1123: arp_standard.debug( 'This is an error condition');
1124: arp_standard.debug('Batch is already created.');
1125: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Created.');
1126: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1127: APP_EXCEPTION.raise_exception;
1128: ELSIF l_approve_flag = 'N' AND l_format_flag = 'Y' THEN

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

1125: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Created.');
1126: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1127: APP_EXCEPTION.raise_exception;
1128: ELSIF l_approve_flag = 'N' AND l_format_flag = 'Y' THEN
1129: arp_standard.debug( 'This is an error condition');
1130: arp_standard.debug('Batch should be Approved before Formatting.');
1131: fnd_file.put_line( FND_FILE.LOG, 'Batch should be Approved before Formatting.');
1132: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1133: APP_EXCEPTION.raise_exception;

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

1126: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1127: APP_EXCEPTION.raise_exception;
1128: ELSIF l_approve_flag = 'N' AND l_format_flag = 'Y' THEN
1129: arp_standard.debug( 'This is an error condition');
1130: arp_standard.debug('Batch should be Approved before Formatting.');
1131: fnd_file.put_line( FND_FILE.LOG, 'Batch should be Approved before Formatting.');
1132: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1133: APP_EXCEPTION.raise_exception;
1134: END IF;

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

1133: APP_EXCEPTION.raise_exception;
1134: END IF;
1135: ELSIF l_batch_applied_status = 'COMPLETED_APPROVAL' AND
1136: (l_create_flag = 'Y' OR l_approve_flag = 'Y') THEN
1137: arp_standard.debug( 'This is an error condition');
1138: arp_standard.debug( 'Batch is already Approved.');
1139: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Approved.');
1140: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1141: APP_EXCEPTION.raise_exception;

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

1134: END IF;
1135: ELSIF l_batch_applied_status = 'COMPLETED_APPROVAL' AND
1136: (l_create_flag = 'Y' OR l_approve_flag = 'Y') THEN
1137: arp_standard.debug( 'This is an error condition');
1138: arp_standard.debug( 'Batch is already Approved.');
1139: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Approved.');
1140: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1141: APP_EXCEPTION.raise_exception;
1142: ELSIF l_batch_applied_status = 'COMPLETED_FORMAT' AND

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

1140: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1141: APP_EXCEPTION.raise_exception;
1142: ELSIF l_batch_applied_status = 'COMPLETED_FORMAT' AND
1143: (l_create_flag = 'Y' OR l_approve_flag = 'Y' )THEN
1144: arp_standard.debug( 'This is an error condition');
1145: arp_standard.debug( 'Batch is already Formatted.');
1146: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Formatted.');
1147: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1148: APP_EXCEPTION.raise_exception;

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

1141: APP_EXCEPTION.raise_exception;
1142: ELSIF l_batch_applied_status = 'COMPLETED_FORMAT' AND
1143: (l_create_flag = 'Y' OR l_approve_flag = 'Y' )THEN
1144: arp_standard.debug( 'This is an error condition');
1145: arp_standard.debug( 'Batch is already Formatted.');
1146: fnd_file.put_line( FND_FILE.LOG, 'Batch is already Formatted.');
1147: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1148: APP_EXCEPTION.raise_exception;
1149: END IF;

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

1203: p_remit_bank_account_id=> l_remittance_bank_account_id ,
1204: p_return_status=>l_return_status);
1205:
1206: ELSIF p_batch_id IS NULL and l_create_flag = 'N' THEN
1207: arp_standard.debug( 'This is an error condition');
1208: arp_standard.debug( 'Batch Name is not supplied.');
1209: fnd_file.put_line( FND_FILE.LOG, 'Create is No and No Batch Name is Supplied.');
1210: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1211: APP_EXCEPTION.raise_exception;

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

1204: p_return_status=>l_return_status);
1205:
1206: ELSIF p_batch_id IS NULL and l_create_flag = 'N' THEN
1207: arp_standard.debug( 'This is an error condition');
1208: arp_standard.debug( 'Batch Name is not supplied.');
1209: fnd_file.put_line( FND_FILE.LOG, 'Create is No and No Batch Name is Supplied.');
1210: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1211: APP_EXCEPTION.raise_exception;
1212: ELSE

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

1214: END IF;
1215:
1216: --Error condition
1217: IF o_batch_id IS NULL THEN
1218: arp_standard.debug( 'This is an error condition');
1219: insert_exceptions( p_batch_id => -333,
1220: p_request_id =>l_request_id,
1221: p_exception_code => 'NO_BATCH',
1222: p_additional_message => 'Error during inserting the

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

1221: p_exception_code => 'NO_BATCH',
1222: p_additional_message => 'Error during inserting the
1223: batch' );
1224:
1225: arp_standard.debug ( 'calling the report - batch_id ' || -333 );
1226: arp_standard.debug ( 'calling the report ' || l_request_id);
1227:
1228: submit_report ( p_batch_id => o_batch_id,
1229: p_request_id => l_request_id);

Line 1226: arp_standard.debug ( 'calling the report ' || l_request_id);

1222: p_additional_message => 'Error during inserting the
1223: batch' );
1224:
1225: arp_standard.debug ( 'calling the report - batch_id ' || -333 );
1226: arp_standard.debug ( 'calling the report ' || l_request_id);
1227:
1228: submit_report ( p_batch_id => o_batch_id,
1229: p_request_id => l_request_id);
1230: RETURN;

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

1370: fnd_file.put_line(FND_FILE.LOG,'worker # : ' || l_worker_number );
1371: submit_subrequest (l_worker_number,l_org_id);
1372: END LOOP;
1373:
1374: arp_standard.debug ( 'The Master program waits for child processes');
1375:
1376: -- Wait for the completion of the submitted requests
1377: FOR i in 1..p_total_workers LOOP
1378:

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

1566:
1567: --p_batch_id := 10;
1568:
1569:
1570: l_request_id := arp_standard.profile.request_id;
1571: l_last_updated_by := arp_standard.profile.user_id ;
1572: l_created_by := arp_standard.profile.user_id ;
1573: l_last_update_login := arp_standard.profile.last_update_login ;
1574: l_program_application_id := arp_standard.application_id ;

Line 1571: l_last_updated_by := arp_standard.profile.user_id ;

1567: --p_batch_id := 10;
1568:
1569:
1570: l_request_id := arp_standard.profile.request_id;
1571: l_last_updated_by := arp_standard.profile.user_id ;
1572: l_created_by := arp_standard.profile.user_id ;
1573: l_last_update_login := arp_standard.profile.last_update_login ;
1574: l_program_application_id := arp_standard.application_id ;
1575: l_program_id := arp_standard.profile.program_id;

Line 1572: l_created_by := arp_standard.profile.user_id ;

1568:
1569:
1570: l_request_id := arp_standard.profile.request_id;
1571: l_last_updated_by := arp_standard.profile.user_id ;
1572: l_created_by := arp_standard.profile.user_id ;
1573: l_last_update_login := arp_standard.profile.last_update_login ;
1574: l_program_application_id := arp_standard.application_id ;
1575: l_program_id := arp_standard.profile.program_id;
1576:

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

1569:
1570: l_request_id := arp_standard.profile.request_id;
1571: l_last_updated_by := arp_standard.profile.user_id ;
1572: l_created_by := arp_standard.profile.user_id ;
1573: l_last_update_login := arp_standard.profile.last_update_login ;
1574: l_program_application_id := arp_standard.application_id ;
1575: l_program_id := arp_standard.profile.program_id;
1576:
1577: IF PG_DEBUG in ('Y', 'C') THEN

Line 1574: l_program_application_id := arp_standard.application_id ;

1570: l_request_id := arp_standard.profile.request_id;
1571: l_last_updated_by := arp_standard.profile.user_id ;
1572: l_created_by := arp_standard.profile.user_id ;
1573: l_last_update_login := arp_standard.profile.last_update_login ;
1574: l_program_application_id := arp_standard.application_id ;
1575: l_program_id := arp_standard.profile.program_id;
1576:
1577: IF PG_DEBUG in ('Y', 'C') THEN
1578: fnd_file.put_line(FND_FILE.LOG,'autoremapi calling auto_batch ()+');

Line 1575: l_program_id := arp_standard.profile.program_id;

1571: l_last_updated_by := arp_standard.profile.user_id ;
1572: l_created_by := arp_standard.profile.user_id ;
1573: l_last_update_login := arp_standard.profile.last_update_login ;
1574: l_program_application_id := arp_standard.application_id ;
1575: l_program_id := arp_standard.profile.program_id;
1576:
1577: IF PG_DEBUG in ('Y', 'C') THEN
1578: fnd_file.put_line(FND_FILE.LOG,'autoremapi calling auto_batch ()+');
1579: END IF;

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

1696:
1697: batch_id := to_char(l_batch_id);
1698:
1699: IF batch_id IS NULL THEN
1700: arp_standard.debug ('WAIT HERE THE VALUE OF BATCH_ID IS NULL ERROR');
1701: -- G_ERROR := 'Y';
1702: END IF;
1703:
1704: IF PG_DEBUG in ('Y', 'C') THEN

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

1712:
1713: p_batch_id := to_number(l_batch_id);
1714:
1715: IF p_batch_id IS NULL THEN
1716: arp_standard.debug ('WAIT HERE THE VALUE OF BATCH_ID IS NULL ERROR');
1717: END IF;
1718:
1719: IF PG_DEBUG in ('Y', 'C') THEN
1720: fnd_file.put_line(FND_FILE.LOG, 'value of batch_id '||p_batch_id);

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

1920: from ar_batches
1921: where batch_id = p_batch_id;
1922:
1923:
1924: l_request_id := arp_standard.profile.request_id;
1925: l_last_updated_by := arp_standard.profile.user_id ;
1926: l_created_by := arp_standard.profile.user_id ;
1927: l_last_update_login := arp_standard.profile.last_update_login ;
1928: l_program_application_id := arp_standard.application_id ;

Line 1925: l_last_updated_by := arp_standard.profile.user_id ;

1921: where batch_id = p_batch_id;
1922:
1923:
1924: l_request_id := arp_standard.profile.request_id;
1925: l_last_updated_by := arp_standard.profile.user_id ;
1926: l_created_by := arp_standard.profile.user_id ;
1927: l_last_update_login := arp_standard.profile.last_update_login ;
1928: l_program_application_id := arp_standard.application_id ;
1929: l_program_id := arp_standard.profile.program_id;

Line 1926: l_created_by := arp_standard.profile.user_id ;

1922:
1923:
1924: l_request_id := arp_standard.profile.request_id;
1925: l_last_updated_by := arp_standard.profile.user_id ;
1926: l_created_by := arp_standard.profile.user_id ;
1927: l_last_update_login := arp_standard.profile.last_update_login ;
1928: l_program_application_id := arp_standard.application_id ;
1929: l_program_id := arp_standard.profile.program_id;
1930: l_org_id := arp_standard.sysparm.org_id;

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

1923:
1924: l_request_id := arp_standard.profile.request_id;
1925: l_last_updated_by := arp_standard.profile.user_id ;
1926: l_created_by := arp_standard.profile.user_id ;
1927: l_last_update_login := arp_standard.profile.last_update_login ;
1928: l_program_application_id := arp_standard.application_id ;
1929: l_program_id := arp_standard.profile.program_id;
1930: l_org_id := arp_standard.sysparm.org_id;
1931:

Line 1928: l_program_application_id := arp_standard.application_id ;

1924: l_request_id := arp_standard.profile.request_id;
1925: l_last_updated_by := arp_standard.profile.user_id ;
1926: l_created_by := arp_standard.profile.user_id ;
1927: l_last_update_login := arp_standard.profile.last_update_login ;
1928: l_program_application_id := arp_standard.application_id ;
1929: l_program_id := arp_standard.profile.program_id;
1930: l_org_id := arp_standard.sysparm.org_id;
1931:
1932:

Line 1929: l_program_id := arp_standard.profile.program_id;

1925: l_last_updated_by := arp_standard.profile.user_id ;
1926: l_created_by := arp_standard.profile.user_id ;
1927: l_last_update_login := arp_standard.profile.last_update_login ;
1928: l_program_application_id := arp_standard.application_id ;
1929: l_program_id := arp_standard.profile.program_id;
1930: l_org_id := arp_standard.sysparm.org_id;
1931:
1932:
1933: l_sel_stmt := ' SELECT cr.cash_receipt_id,

Line 1930: l_org_id := arp_standard.sysparm.org_id;

1926: l_created_by := arp_standard.profile.user_id ;
1927: l_last_update_login := arp_standard.profile.last_update_login ;
1928: l_program_application_id := arp_standard.application_id ;
1929: l_program_id := arp_standard.profile.program_id;
1930: l_org_id := arp_standard.sysparm.org_id;
1931:
1932:
1933: l_sel_stmt := ' SELECT cr.cash_receipt_id,
1934: rm.payment_channel_code,

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

2206:
2207: dbms_sql.close_cursor(rem_t1);
2208:
2209: IF PG_DEBUG in ('Y', 'C') THEN
2210: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2211: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');
2212: END IF;
2213:
2214: EXCEPTION WHEN OTHERS THEN

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

2700: into l_factor_flag
2701: from ar_batches
2702: where batch_id = p_batch_id;
2703:
2704: l_request_id := arp_standard.profile.request_id;
2705: l_last_updated_by := arp_standard.profile.user_id ;
2706: l_created_by := arp_standard.profile.user_id ;
2707: l_last_update_login := arp_standard.profile.last_update_login ;
2708: l_program_application_id := arp_standard.application_id ;

Line 2705: l_last_updated_by := arp_standard.profile.user_id ;

2701: from ar_batches
2702: where batch_id = p_batch_id;
2703:
2704: l_request_id := arp_standard.profile.request_id;
2705: l_last_updated_by := arp_standard.profile.user_id ;
2706: l_created_by := arp_standard.profile.user_id ;
2707: l_last_update_login := arp_standard.profile.last_update_login ;
2708: l_program_application_id := arp_standard.application_id ;
2709: l_program_id := arp_standard.profile.program_id;

Line 2706: l_created_by := arp_standard.profile.user_id ;

2702: where batch_id = p_batch_id;
2703:
2704: l_request_id := arp_standard.profile.request_id;
2705: l_last_updated_by := arp_standard.profile.user_id ;
2706: l_created_by := arp_standard.profile.user_id ;
2707: l_last_update_login := arp_standard.profile.last_update_login ;
2708: l_program_application_id := arp_standard.application_id ;
2709: l_program_id := arp_standard.profile.program_id;
2710: l_org_id := arp_standard.sysparm.org_id;

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

2703:
2704: l_request_id := arp_standard.profile.request_id;
2705: l_last_updated_by := arp_standard.profile.user_id ;
2706: l_created_by := arp_standard.profile.user_id ;
2707: l_last_update_login := arp_standard.profile.last_update_login ;
2708: l_program_application_id := arp_standard.application_id ;
2709: l_program_id := arp_standard.profile.program_id;
2710: l_org_id := arp_standard.sysparm.org_id;
2711:

Line 2708: l_program_application_id := arp_standard.application_id ;

2704: l_request_id := arp_standard.profile.request_id;
2705: l_last_updated_by := arp_standard.profile.user_id ;
2706: l_created_by := arp_standard.profile.user_id ;
2707: l_last_update_login := arp_standard.profile.last_update_login ;
2708: l_program_application_id := arp_standard.application_id ;
2709: l_program_id := arp_standard.profile.program_id;
2710: l_org_id := arp_standard.sysparm.org_id;
2711:
2712:

Line 2709: l_program_id := arp_standard.profile.program_id;

2705: l_last_updated_by := arp_standard.profile.user_id ;
2706: l_created_by := arp_standard.profile.user_id ;
2707: l_last_update_login := arp_standard.profile.last_update_login ;
2708: l_program_application_id := arp_standard.application_id ;
2709: l_program_id := arp_standard.profile.program_id;
2710: l_org_id := arp_standard.sysparm.org_id;
2711:
2712:
2713: l_sel_stmt := ' SELECT cash_receipt_id,

Line 2710: l_org_id := arp_standard.sysparm.org_id;

2706: l_created_by := arp_standard.profile.user_id ;
2707: l_last_update_login := arp_standard.profile.last_update_login ;
2708: l_program_application_id := arp_standard.application_id ;
2709: l_program_id := arp_standard.profile.program_id;
2710: l_org_id := arp_standard.sysparm.org_id;
2711:
2712:
2713: l_sel_stmt := ' SELECT cash_receipt_id,
2714: payment_channel_code,

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

2978:
2979: dbms_sql.close_cursor(rem_t1);
2980:
2981: IF PG_DEBUG in ('Y', 'C') THEN
2982: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2983: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');
2984: END IF;
2985:
2986: EXCEPTION WHEN OTHERS THEN

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

3408: l_program_application_id NUMBER;
3409: l_program_id NUMBER;
3410:
3411: BEGIN
3412: l_request_id := arp_standard.profile.request_id;
3413: l_last_updated_by := arp_standard.profile.user_id ;
3414: l_created_by := arp_standard.profile.user_id ;
3415: l_last_update_login := arp_standard.profile.last_update_login ;
3416: l_program_application_id := arp_standard.application_id ;

Line 3413: l_last_updated_by := arp_standard.profile.user_id ;

3409: l_program_id NUMBER;
3410:
3411: BEGIN
3412: l_request_id := arp_standard.profile.request_id;
3413: l_last_updated_by := arp_standard.profile.user_id ;
3414: l_created_by := arp_standard.profile.user_id ;
3415: l_last_update_login := arp_standard.profile.last_update_login ;
3416: l_program_application_id := arp_standard.application_id ;
3417: l_program_id := arp_standard.profile.program_id;

Line 3414: l_created_by := arp_standard.profile.user_id ;

3410:
3411: BEGIN
3412: l_request_id := arp_standard.profile.request_id;
3413: l_last_updated_by := arp_standard.profile.user_id ;
3414: l_created_by := arp_standard.profile.user_id ;
3415: l_last_update_login := arp_standard.profile.last_update_login ;
3416: l_program_application_id := arp_standard.application_id ;
3417: l_program_id := arp_standard.profile.program_id;
3418:

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

3411: BEGIN
3412: l_request_id := arp_standard.profile.request_id;
3413: l_last_updated_by := arp_standard.profile.user_id ;
3414: l_created_by := arp_standard.profile.user_id ;
3415: l_last_update_login := arp_standard.profile.last_update_login ;
3416: l_program_application_id := arp_standard.application_id ;
3417: l_program_id := arp_standard.profile.program_id;
3418:
3419: IF PG_DEBUG in ('Y', 'C') THEN

Line 3416: l_program_application_id := arp_standard.application_id ;

3412: l_request_id := arp_standard.profile.request_id;
3413: l_last_updated_by := arp_standard.profile.user_id ;
3414: l_created_by := arp_standard.profile.user_id ;
3415: l_last_update_login := arp_standard.profile.last_update_login ;
3416: l_program_application_id := arp_standard.application_id ;
3417: l_program_id := arp_standard.profile.program_id;
3418:
3419: IF PG_DEBUG in ('Y', 'C') THEN
3420: fnd_file.put_line(FND_FILE.LOG,'sel and upd receipts start ()+');

Line 3417: l_program_id := arp_standard.profile.program_id;

3413: l_last_updated_by := arp_standard.profile.user_id ;
3414: l_created_by := arp_standard.profile.user_id ;
3415: l_last_update_login := arp_standard.profile.last_update_login ;
3416: l_program_application_id := arp_standard.application_id ;
3417: l_program_id := arp_standard.profile.program_id;
3418:
3419: IF PG_DEBUG in ('Y', 'C') THEN
3420: fnd_file.put_line(FND_FILE.LOG,'sel and upd receipts start ()+');
3421: fnd_file.put_line(FND_FILE.LOG,'the input parameters are ');

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

4022: fnd_file.put_line(FND_FILE.LOG, 'Entering payment processing...');
4023: END IF;
4024:
4025:
4026: l_request_id := arp_standard.profile.request_id;
4027: l_last_updated_by := arp_standard.profile.user_id ;
4028: l_created_by := arp_standard.profile.user_id ;
4029: l_last_update_login := arp_standard.profile.last_update_login ;
4030: l_program_application_id := arp_standard.application_id ;

Line 4027: l_last_updated_by := arp_standard.profile.user_id ;

4023: END IF;
4024:
4025:
4026: l_request_id := arp_standard.profile.request_id;
4027: l_last_updated_by := arp_standard.profile.user_id ;
4028: l_created_by := arp_standard.profile.user_id ;
4029: l_last_update_login := arp_standard.profile.last_update_login ;
4030: l_program_application_id := arp_standard.application_id ;
4031: l_program_id := arp_standard.profile.program_id;

Line 4028: l_created_by := arp_standard.profile.user_id ;

4024:
4025:
4026: l_request_id := arp_standard.profile.request_id;
4027: l_last_updated_by := arp_standard.profile.user_id ;
4028: l_created_by := arp_standard.profile.user_id ;
4029: l_last_update_login := arp_standard.profile.last_update_login ;
4030: l_program_application_id := arp_standard.application_id ;
4031: l_program_id := arp_standard.profile.program_id;
4032:

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

4025:
4026: l_request_id := arp_standard.profile.request_id;
4027: l_last_updated_by := arp_standard.profile.user_id ;
4028: l_created_by := arp_standard.profile.user_id ;
4029: l_last_update_login := arp_standard.profile.last_update_login ;
4030: l_program_application_id := arp_standard.application_id ;
4031: l_program_id := arp_standard.profile.program_id;
4032:
4033:

Line 4030: l_program_application_id := arp_standard.application_id ;

4026: l_request_id := arp_standard.profile.request_id;
4027: l_last_updated_by := arp_standard.profile.user_id ;
4028: l_created_by := arp_standard.profile.user_id ;
4029: l_last_update_login := arp_standard.profile.last_update_login ;
4030: l_program_application_id := arp_standard.application_id ;
4031: l_program_id := arp_standard.profile.program_id;
4032:
4033:
4034:

Line 4031: l_program_id := arp_standard.profile.program_id;

4027: l_last_updated_by := arp_standard.profile.user_id ;
4028: l_created_by := arp_standard.profile.user_id ;
4029: l_last_update_login := arp_standard.profile.last_update_login ;
4030: l_program_application_id := arp_standard.application_id ;
4031: l_program_id := arp_standard.profile.program_id;
4032:
4033:
4034:
4035:

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

4079:
4080: -- set up auth_attribs record:
4081: l_auth_attribs_rec.RiskEval_Enable_Flag := 'N';
4082: -- set up trxn_attribs record:
4083: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;
4084: l_trxn_attribs_rec.order_id := rct_info.receipt_number;
4085: l_trxn_attribs_rec.Trxn_Ref_Number1 := 'RECEIPT';
4086: l_trxn_attribs_rec.Trxn_Ref_Number2 := rct_info.cash_receipt_id;
4087:

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

4778: fnd_file.put_line(FND_FILE.LOG, 'Entering payment processing parallel...');
4779: END IF;
4780:
4781:
4782: l_request_id := arp_standard.profile.request_id;
4783: l_last_updated_by := arp_standard.profile.user_id ;
4784: l_created_by := arp_standard.profile.user_id ;
4785: l_last_update_login := arp_standard.profile.last_update_login ;
4786: l_program_application_id := arp_standard.application_id ;

Line 4783: l_last_updated_by := arp_standard.profile.user_id ;

4779: END IF;
4780:
4781:
4782: l_request_id := arp_standard.profile.request_id;
4783: l_last_updated_by := arp_standard.profile.user_id ;
4784: l_created_by := arp_standard.profile.user_id ;
4785: l_last_update_login := arp_standard.profile.last_update_login ;
4786: l_program_application_id := arp_standard.application_id ;
4787: l_program_id := arp_standard.profile.program_id;

Line 4784: l_created_by := arp_standard.profile.user_id ;

4780:
4781:
4782: l_request_id := arp_standard.profile.request_id;
4783: l_last_updated_by := arp_standard.profile.user_id ;
4784: l_created_by := arp_standard.profile.user_id ;
4785: l_last_update_login := arp_standard.profile.last_update_login ;
4786: l_program_application_id := arp_standard.application_id ;
4787: l_program_id := arp_standard.profile.program_id;
4788:

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

4781:
4782: l_request_id := arp_standard.profile.request_id;
4783: l_last_updated_by := arp_standard.profile.user_id ;
4784: l_created_by := arp_standard.profile.user_id ;
4785: l_last_update_login := arp_standard.profile.last_update_login ;
4786: l_program_application_id := arp_standard.application_id ;
4787: l_program_id := arp_standard.profile.program_id;
4788:
4789:

Line 4786: l_program_application_id := arp_standard.application_id ;

4782: l_request_id := arp_standard.profile.request_id;
4783: l_last_updated_by := arp_standard.profile.user_id ;
4784: l_created_by := arp_standard.profile.user_id ;
4785: l_last_update_login := arp_standard.profile.last_update_login ;
4786: l_program_application_id := arp_standard.application_id ;
4787: l_program_id := arp_standard.profile.program_id;
4788:
4789:
4790:

Line 4787: l_program_id := arp_standard.profile.program_id;

4783: l_last_updated_by := arp_standard.profile.user_id ;
4784: l_created_by := arp_standard.profile.user_id ;
4785: l_last_update_login := arp_standard.profile.last_update_login ;
4786: l_program_application_id := arp_standard.application_id ;
4787: l_program_id := arp_standard.profile.program_id;
4788:
4789:
4790:
4791:

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

4835:
4836: -- set up auth_attribs record:
4837: l_auth_attribs_rec.RiskEval_Enable_Flag := 'N';
4838: -- set up trxn_attribs record:
4839: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;
4840: l_trxn_attribs_rec.order_id := rct_info.receipt_number;
4841: l_trxn_attribs_rec.Trxn_Ref_Number1 := 'RECEIPT';
4842: l_trxn_attribs_rec.Trxn_Ref_Number2 := rct_info.cash_receipt_id;
4843:

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

5475:
5476:
5477:
5478:
5479: l_request_id := arp_standard.profile.request_id;
5480: l_last_updated_by := arp_standard.profile.user_id ;
5481: l_created_by := arp_standard.profile.user_id ;
5482: l_last_update_login := arp_standard.profile.last_update_login ;
5483: l_program_application_id := arp_standard.application_id ;

Line 5480: l_last_updated_by := arp_standard.profile.user_id ;

5476:
5477:
5478:
5479: l_request_id := arp_standard.profile.request_id;
5480: l_last_updated_by := arp_standard.profile.user_id ;
5481: l_created_by := arp_standard.profile.user_id ;
5482: l_last_update_login := arp_standard.profile.last_update_login ;
5483: l_program_application_id := arp_standard.application_id ;
5484: l_program_id := arp_standard.profile.program_id;

Line 5481: l_created_by := arp_standard.profile.user_id ;

5477:
5478:
5479: l_request_id := arp_standard.profile.request_id;
5480: l_last_updated_by := arp_standard.profile.user_id ;
5481: l_created_by := arp_standard.profile.user_id ;
5482: l_last_update_login := arp_standard.profile.last_update_login ;
5483: l_program_application_id := arp_standard.application_id ;
5484: l_program_id := arp_standard.profile.program_id;
5485:

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

5478:
5479: l_request_id := arp_standard.profile.request_id;
5480: l_last_updated_by := arp_standard.profile.user_id ;
5481: l_created_by := arp_standard.profile.user_id ;
5482: l_last_update_login := arp_standard.profile.last_update_login ;
5483: l_program_application_id := arp_standard.application_id ;
5484: l_program_id := arp_standard.profile.program_id;
5485:
5486: IF PG_DEBUG in ('Y','C') THEN

Line 5483: l_program_application_id := arp_standard.application_id ;

5479: l_request_id := arp_standard.profile.request_id;
5480: l_last_updated_by := arp_standard.profile.user_id ;
5481: l_created_by := arp_standard.profile.user_id ;
5482: l_last_update_login := arp_standard.profile.last_update_login ;
5483: l_program_application_id := arp_standard.application_id ;
5484: l_program_id := arp_standard.profile.program_id;
5485:
5486: IF PG_DEBUG in ('Y','C') THEN
5487:

Line 5484: l_program_id := arp_standard.profile.program_id;

5480: l_last_updated_by := arp_standard.profile.user_id ;
5481: l_created_by := arp_standard.profile.user_id ;
5482: l_last_update_login := arp_standard.profile.last_update_login ;
5483: l_program_application_id := arp_standard.application_id ;
5484: l_program_id := arp_standard.profile.program_id;
5485:
5486: IF PG_DEBUG in ('Y','C') THEN
5487:
5488: fnd_file.put_line(FND_FILE.LOG, 'value of l_request_id ' || l_request_id );

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

5746: IF PG_DEBUG in ('Y', 'C') THEN
5747: fnd_file.put_line(FND_FILE.LOG,'control_check()+');
5748: END IF;
5749:
5750: l_request_id := arp_standard.profile.request_id;
5751: l_last_updated_by := arp_standard.profile.user_id ;
5752: l_created_by := arp_standard.profile.user_id ;
5753: l_last_update_login := arp_standard.profile.last_update_login ;
5754: l_program_application_id := arp_standard.application_id ;

Line 5751: l_last_updated_by := arp_standard.profile.user_id ;

5747: fnd_file.put_line(FND_FILE.LOG,'control_check()+');
5748: END IF;
5749:
5750: l_request_id := arp_standard.profile.request_id;
5751: l_last_updated_by := arp_standard.profile.user_id ;
5752: l_created_by := arp_standard.profile.user_id ;
5753: l_last_update_login := arp_standard.profile.last_update_login ;
5754: l_program_application_id := arp_standard.application_id ;
5755: l_program_id := arp_standard.profile.program_id;

Line 5752: l_created_by := arp_standard.profile.user_id ;

5748: END IF;
5749:
5750: l_request_id := arp_standard.profile.request_id;
5751: l_last_updated_by := arp_standard.profile.user_id ;
5752: l_created_by := arp_standard.profile.user_id ;
5753: l_last_update_login := arp_standard.profile.last_update_login ;
5754: l_program_application_id := arp_standard.application_id ;
5755: l_program_id := arp_standard.profile.program_id;
5756:

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

5749:
5750: l_request_id := arp_standard.profile.request_id;
5751: l_last_updated_by := arp_standard.profile.user_id ;
5752: l_created_by := arp_standard.profile.user_id ;
5753: l_last_update_login := arp_standard.profile.last_update_login ;
5754: l_program_application_id := arp_standard.application_id ;
5755: l_program_id := arp_standard.profile.program_id;
5756:
5757: UPDATE ar_cash_receipts

Line 5754: l_program_application_id := arp_standard.application_id ;

5750: l_request_id := arp_standard.profile.request_id;
5751: l_last_updated_by := arp_standard.profile.user_id ;
5752: l_created_by := arp_standard.profile.user_id ;
5753: l_last_update_login := arp_standard.profile.last_update_login ;
5754: l_program_application_id := arp_standard.application_id ;
5755: l_program_id := arp_standard.profile.program_id;
5756:
5757: UPDATE ar_cash_receipts
5758: SET cc_error_flag = 'Y',

Line 5755: l_program_id := arp_standard.profile.program_id;

5751: l_last_updated_by := arp_standard.profile.user_id ;
5752: l_created_by := arp_standard.profile.user_id ;
5753: l_last_update_login := arp_standard.profile.last_update_login ;
5754: l_program_application_id := arp_standard.application_id ;
5755: l_program_id := arp_standard.profile.program_id;
5756:
5757: UPDATE ar_cash_receipts
5758: SET cc_error_flag = 'Y',
5759: last_updated_by = l_last_updated_by,

Line 6118: AND xte.ledger_id = arp_standard.sysparm.set_of_books_id

6114: xla_events xe
6115: WHERE cr.request_id = p_request_id
6116: AND cr.cc_error_flag = 'Y'
6117: AND nvl(xte.source_id_int_1, -99) = cr.cash_receipt_id
6118: AND xte.ledger_id = arp_standard.sysparm.set_of_books_id
6119: AND xte.application_id = 222
6120: AND xte.entity_code = 'RECEIPTS'
6121: AND xe.entity_id = xte.entity_id
6122: AND xe.event_status_code <> 'P'

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

6178:
6179: EXCEPTION
6180: WHEN OTHERS THEN
6181: IF PG_DEBUG in ('Y', 'C') THEN
6182: arp_standard.debug('rec_reset ERROR.'|| SQLERRM );
6183: END IF;
6184:
6185: END rec_reset;
6186: