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_LATE_CHARGE_PKG dependencies on AR_INTEREST_BATCHES

Line 1309: FROM ar_interest_batches

1305: IS
1306: CURSOR c_gl_date IS
1307: SELECT gl_date,
1308: calculate_interest_to_date
1309: FROM ar_interest_batches
1310: WHERE interest_batch_id = g_interest_batch_id;
1311:
1312: l_current_trx_id NUMBER := -9;
1313: l_return_status VARCHAR2(10);

Line 1593: ar_interest_batches b,

1589: header_type,
1590: p_worker_num
1591: FROM ar_interest_lines l,
1592: ar_interest_headers h,
1593: ar_interest_batches b,
1594: ar_receivables_trx rtrx,
1595: ar_payment_schedules psch
1596: WHERE b.interest_batch_id = g_interest_batch_id
1597: AND h.interest_batch_id = b.interest_batch_id

Line 1630: FROM ar_interest_batches

1626: IS
1627: CURSOR c_gl_date IS
1628: SELECT gl_date,
1629: calculate_interest_to_date
1630: FROM ar_interest_batches
1631: WHERE interest_batch_id = g_interest_batch_id;
1632:
1633: CURSOR cadj IS
1634: SELECT INTEREST_CHARGED,

Line 2439: FROM ar_interest_batches

2435: object_version_number,
2436: CALCULATE_INTEREST_TO_DATE,
2437: BATCH_STATUS,
2438: GL_DATE
2439: FROM ar_interest_batches
2440: WHERE interest_batch_id = g_interest_batch_id;
2441:
2442: l_transferred_status VARCHAR2(1);
2443: x_object_version_number NUMBER;

Line 2514: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');

2510: IF c%NOTFOUND THEN
2511: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2512: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
2513: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_id' );
2514: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');
2515: FND_MSG_PUB.ADD;
2516: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2517: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
2518: ELSE

Line 2585: AR_INTEREST_BATCHES_PKG.update_batch

2581: RAISE fnd_Api.g_exc_unexpected_error;
2582: END IF;
2583:
2584: log('Updating the batch status to Pending to start the process...');
2585: AR_INTEREST_BATCHES_PKG.update_batch
2586: (p_init_msg_list => 'T',
2587: P_INTEREST_BATCH_ID => g_interest_batch_id,
2588: P_BATCH_STATUS => 'F',
2589: P_TRANSFERRED_status => 'P',

Line 2629: -- UPDATE ar_interest_batches

2625: get_status_for_sub_process
2626: (p_sub_name => 'ARLCPS',
2627: x_status => l_transferred_status);
2628:
2629: -- UPDATE ar_interest_batches
2630: -- SET TRANSFERRED_STATUS = l_transferred_status,
2631: -- object_version_number = x_object_version_number + 1
2632: -- WHERE interest_batch_id = g_interest_batch_id;
2633:

Line 2637: AR_INTEREST_BATCHES_PKG.update_batch

2633:
2634: OPEN c_err;
2635: FETCH c_err INTO l_err;
2636: IF c_err%NOTFOUND THEN
2637: AR_INTEREST_BATCHES_PKG.update_batch
2638: (p_init_msg_list => 'T',
2639: P_INTEREST_BATCH_ID => g_interest_batch_id,
2640: P_BATCH_STATUS => 'F',
2641: P_TRANSFERRED_STATUS => l_transferred_status,

Line 2648: AR_INTEREST_BATCHES_PKG.update_batch

2644: x_return_status => x_return_status,
2645: x_msg_count => x_msg_count,
2646: x_msg_data => x_msg_data);
2647: ELSE
2648: AR_INTEREST_BATCHES_PKG.update_batch
2649: (p_init_msg_list => 'T',
2650: P_INTEREST_BATCH_ID => g_interest_batch_id,
2651: P_BATCH_STATUS => 'F',
2652: P_TRANSFERRED_STATUS => 'E',

Line 2912: FROM ar_interest_batches_all b,

2908: b.gl_date,
2909: b.calculate_interest_to_date,
2910: s.late_charge_batch_source_id,
2911: lg.currency_code
2912: FROM ar_interest_batches_all b,
2913: ar_interest_headers_all h,
2914: ar_system_parameters_all s,
2915: gl_ledgers lg
2916: WHERE b.request_id = p_request_id

Line 3157: FROM ar_interest_batches

3153: object_version_number,
3154: CALCULATE_INTEREST_TO_DATE,
3155: BATCH_STATUS,
3156: GL_DATE
3157: FROM ar_interest_batches
3158: WHERE interest_batch_id = g_interest_batch_id;
3159:
3160: l_transferred_status VARCHAR2(1);
3161: x_object_version_number NUMBER;

Line 3251: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );

3247: IF c%NOTFOUND THEN
3248: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3249: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
3250: FND_MESSAGE.SET_TOKEN( 'COLUMN',p_batch_id );
3251: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );
3252: FND_MSG_PUB.ADD;
3253: x_return_status := FND_API.G_RET_STS_ERROR;
3254: retcode := 2;
3255: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3344: AR_INTEREST_BATCHES_PKG.update_batch

3340: RAISE fnd_Api.g_exc_unexpected_error;
3341: END IF;
3342:
3343: log('Updating the batch status to Pending to start the process...');
3344: AR_INTEREST_BATCHES_PKG.update_batch
3345: (p_init_msg_list => 'T',
3346: P_INTEREST_BATCH_ID => g_interest_batch_id,
3347: P_BATCH_STATUS => 'F',
3348: P_TRANSFERRED_STATUS => 'P',

Line 3386: -- UPDATE ar_interest_batches

3382: get_status_for_sub_process
3383: (p_sub_name => 'ARLCPW',
3384: x_status => l_transferred_status);
3385:
3386: -- UPDATE ar_interest_batches
3387: -- SET TRANSFERRED_status = l_transferred_status,
3388: -- object_version_number = x_object_version_number + 1
3389: -- WHERE interest_batch_id = g_interest_batch_id;
3390:

Line 3394: AR_INTEREST_BATCHES_PKG.update_batch

3390:
3391: OPEN c_err;
3392: FETCH c_err INTO l_err;
3393: IF c_err%NOTFOUND THEN
3394: AR_INTEREST_BATCHES_PKG.update_batch
3395: (p_init_msg_list => 'T',
3396: P_INTEREST_BATCH_ID => g_interest_batch_id,
3397: P_BATCH_STATUS => 'F',
3398: P_TRANSFERRED_status => l_transferred_status,

Line 3405: AR_INTEREST_BATCHES_PKG.update_batch

3401: x_return_status => x_return_status,
3402: x_msg_count => x_msg_count,
3403: x_msg_data => x_msg_data);
3404: ELSE
3405: AR_INTEREST_BATCHES_PKG.update_batch
3406: (p_init_msg_list => 'T',
3407: P_INTEREST_BATCH_ID => g_interest_batch_id,
3408: P_BATCH_STATUS => 'F',
3409: P_TRANSFERRED_status => 'E',

Line 3429: AR_INTEREST_BATCHES_PKG.update_batch

3425: outandlog( message =>'End create_late_charge_by_worker for the batch:'||p_batch_id||' Please check log files' );
3426: EXCEPTION
3427: WHEN nothing_to_process THEN
3428: outandlog( message =>' Empty batch' );
3429: AR_INTEREST_BATCHES_PKG.update_batch
3430: (p_init_msg_list => 'T',
3431: P_INTEREST_BATCH_ID => g_interest_batch_id,
3432: P_BATCH_STATUS => 'F',
3433: P_TRANSFERRED_status => 'S',