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 1344: FROM ar_interest_batches

1340: IS
1341: CURSOR c_gl_date IS
1342: SELECT gl_date,
1343: calculate_interest_to_date
1344: FROM ar_interest_batches
1345: WHERE interest_batch_id = g_interest_batch_id;
1346:
1347: l_current_trx_id NUMBER := -9;
1348: l_return_status VARCHAR2(10);

Line 1633: ar_interest_batches b,

1629: header_type,
1630: p_worker_num
1631: FROM ar_interest_lines l,
1632: ar_interest_headers h,
1633: ar_interest_batches b,
1634: ar_receivables_trx rtrx,
1635: ar_payment_schedules psch
1636: WHERE b.interest_batch_id = g_interest_batch_id
1637: AND h.interest_batch_id = b.interest_batch_id

Line 1670: FROM ar_interest_batches

1666: IS
1667: CURSOR c_gl_date IS
1668: SELECT gl_date,
1669: calculate_interest_to_date
1670: FROM ar_interest_batches
1671: WHERE interest_batch_id = g_interest_batch_id;
1672:
1673: CURSOR cadj IS
1674: SELECT INTEREST_CHARGED,

Line 2479: FROM ar_interest_batches

2475: object_version_number,
2476: CALCULATE_INTEREST_TO_DATE,
2477: BATCH_STATUS,
2478: GL_DATE
2479: FROM ar_interest_batches
2480: WHERE interest_batch_id = g_interest_batch_id;
2481:
2482: l_transferred_status VARCHAR2(1);
2483: x_object_version_number NUMBER;

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

2550: IF c%NOTFOUND THEN
2551: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2552: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
2553: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_id' );
2554: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');
2555: FND_MSG_PUB.ADD;
2556: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2557: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
2558: ELSE

Line 2625: AR_INTEREST_BATCHES_PKG.update_batch

2621: RAISE fnd_Api.g_exc_unexpected_error;
2622: END IF;
2623:
2624: log('Updating the batch status to Pending to start the process...');
2625: AR_INTEREST_BATCHES_PKG.update_batch
2626: (p_init_msg_list => 'T',
2627: P_INTEREST_BATCH_ID => g_interest_batch_id,
2628: P_BATCH_STATUS => 'F',
2629: P_TRANSFERRED_status => 'P',

Line 2669: -- UPDATE ar_interest_batches

2665: get_status_for_sub_process
2666: (p_sub_name => 'ARLCPS',
2667: x_status => l_transferred_status);
2668:
2669: -- UPDATE ar_interest_batches
2670: -- SET TRANSFERRED_STATUS = l_transferred_status,
2671: -- object_version_number = x_object_version_number + 1
2672: -- WHERE interest_batch_id = g_interest_batch_id;
2673:

Line 2677: AR_INTEREST_BATCHES_PKG.update_batch

2673:
2674: OPEN c_err;
2675: FETCH c_err INTO l_err;
2676: IF c_err%NOTFOUND THEN
2677: AR_INTEREST_BATCHES_PKG.update_batch
2678: (p_init_msg_list => 'T',
2679: P_INTEREST_BATCH_ID => g_interest_batch_id,
2680: P_BATCH_STATUS => 'F',
2681: P_TRANSFERRED_STATUS => l_transferred_status,

Line 2688: AR_INTEREST_BATCHES_PKG.update_batch

2684: x_return_status => x_return_status,
2685: x_msg_count => x_msg_count,
2686: x_msg_data => x_msg_data);
2687: ELSE
2688: AR_INTEREST_BATCHES_PKG.update_batch
2689: (p_init_msg_list => 'T',
2690: P_INTEREST_BATCH_ID => g_interest_batch_id,
2691: P_BATCH_STATUS => 'F',
2692: P_TRANSFERRED_STATUS => 'E',

Line 2952: FROM ar_interest_batches_all b,

2948: b.gl_date,
2949: b.calculate_interest_to_date,
2950: s.late_charge_batch_source_id,
2951: lg.currency_code
2952: FROM ar_interest_batches_all b,
2953: ar_interest_headers_all h,
2954: ar_system_parameters_all s,
2955: gl_ledgers lg
2956: WHERE b.request_id = p_request_id

Line 3197: FROM ar_interest_batches

3193: object_version_number,
3194: CALCULATE_INTEREST_TO_DATE,
3195: BATCH_STATUS,
3196: GL_DATE
3197: FROM ar_interest_batches
3198: WHERE interest_batch_id = g_interest_batch_id;
3199:
3200: l_transferred_status VARCHAR2(1);
3201: x_object_version_number NUMBER;

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

3287: IF c%NOTFOUND THEN
3288: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3289: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
3290: FND_MESSAGE.SET_TOKEN( 'COLUMN',p_batch_id );
3291: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );
3292: FND_MSG_PUB.ADD;
3293: x_return_status := FND_API.G_RET_STS_ERROR;
3294: retcode := 2;
3295: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3384: AR_INTEREST_BATCHES_PKG.update_batch

3380: RAISE fnd_Api.g_exc_unexpected_error;
3381: END IF;
3382:
3383: log('Updating the batch status to Pending to start the process...');
3384: AR_INTEREST_BATCHES_PKG.update_batch
3385: (p_init_msg_list => 'T',
3386: P_INTEREST_BATCH_ID => g_interest_batch_id,
3387: P_BATCH_STATUS => 'F',
3388: P_TRANSFERRED_STATUS => 'P',

Line 3426: -- UPDATE ar_interest_batches

3422: get_status_for_sub_process
3423: (p_sub_name => 'ARLCPW',
3424: x_status => l_transferred_status);
3425:
3426: -- UPDATE ar_interest_batches
3427: -- SET TRANSFERRED_status = l_transferred_status,
3428: -- object_version_number = x_object_version_number + 1
3429: -- WHERE interest_batch_id = g_interest_batch_id;
3430:

Line 3434: AR_INTEREST_BATCHES_PKG.update_batch

3430:
3431: OPEN c_err;
3432: FETCH c_err INTO l_err;
3433: IF c_err%NOTFOUND THEN
3434: AR_INTEREST_BATCHES_PKG.update_batch
3435: (p_init_msg_list => 'T',
3436: P_INTEREST_BATCH_ID => g_interest_batch_id,
3437: P_BATCH_STATUS => 'F',
3438: P_TRANSFERRED_status => l_transferred_status,

Line 3445: AR_INTEREST_BATCHES_PKG.update_batch

3441: x_return_status => x_return_status,
3442: x_msg_count => x_msg_count,
3443: x_msg_data => x_msg_data);
3444: ELSE
3445: AR_INTEREST_BATCHES_PKG.update_batch
3446: (p_init_msg_list => 'T',
3447: P_INTEREST_BATCH_ID => g_interest_batch_id,
3448: P_BATCH_STATUS => 'F',
3449: P_TRANSFERRED_status => 'E',

Line 3469: AR_INTEREST_BATCHES_PKG.update_batch

3465: outandlog( message =>'End create_late_charge_by_worker for the batch:'||p_batch_id||' Please check log files' );
3466: EXCEPTION
3467: WHEN nothing_to_process THEN
3468: outandlog( message =>' Empty batch' );
3469: AR_INTEREST_BATCHES_PKG.update_batch
3470: (p_init_msg_list => 'T',
3471: P_INTEREST_BATCH_ID => g_interest_batch_id,
3472: P_BATCH_STATUS => 'F',
3473: P_TRANSFERRED_status => 'S',