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_INTEREST_BATCHES_PKG dependencies on ARP_UTIL

Line 24: arp_util.debug('AR_INTEREST_BATCHES_PKG.get_batch_amount+');

20: AND ib.interest_batch_id = ii.interest_batch_id
21: AND ib.interest_batch_id = p_interest_batch_id;
22: l_batch_amount NUMBER := 0;
23: BEGIN
24: arp_util.debug('AR_INTEREST_BATCHES_PKG.get_batch_amount+');
25: arp_util.debug(' p_interest_batch_id :'||p_interest_batch_id);
26: OPEN c;
27: FETCH c INTO l_batch_amount;
28: IF c%NOTFOUND THEN

Line 25: arp_util.debug(' p_interest_batch_id :'||p_interest_batch_id);

21: AND ib.interest_batch_id = p_interest_batch_id;
22: l_batch_amount NUMBER := 0;
23: BEGIN
24: arp_util.debug('AR_INTEREST_BATCHES_PKG.get_batch_amount+');
25: arp_util.debug(' p_interest_batch_id :'||p_interest_batch_id);
26: OPEN c;
27: FETCH c INTO l_batch_amount;
28: IF c%NOTFOUND THEN
29: l_batch_amount := 0;

Line 32: arp_util.debug(' resultat :'||l_batch_amount);

28: IF c%NOTFOUND THEN
29: l_batch_amount := 0;
30: END IF;
31: CLOSE c;
32: arp_util.debug(' resultat :'||l_batch_amount);
33: arp_util.debug('AR_INTEREST_BATCHES_PKG.get_batch_amount-');
34: RETURN l_batch_amount;
35: END;
36:

Line 33: arp_util.debug('AR_INTEREST_BATCHES_PKG.get_batch_amount-');

29: l_batch_amount := 0;
30: END IF;
31: CLOSE c;
32: arp_util.debug(' resultat :'||l_batch_amount);
33: arp_util.debug('AR_INTEREST_BATCHES_PKG.get_batch_amount-');
34: RETURN l_batch_amount;
35: END;
36:
37: PROCEDURE Lock_batch

Line 58: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_batch+');

54: FOR UPDATE OF Interest_Batch_Id NOWAIT;
55: Recinfo C%ROWTYPE;
56: l_continue VARCHAR2(1) := 'Y';
57: BEGIN
58: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_batch+');
59: arp_util.debug(' p_Interest_Batch_Id :'||p_Interest_Batch_Id);
60: x_return_status := fnd_api.g_ret_sts_success;
61: OPEN C;
62: FETCH C INTO Recinfo;

Line 59: arp_util.debug(' p_Interest_Batch_Id :'||p_Interest_Batch_Id);

55: Recinfo C%ROWTYPE;
56: l_continue VARCHAR2(1) := 'Y';
57: BEGIN
58: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_batch+');
59: arp_util.debug(' p_Interest_Batch_Id :'||p_Interest_Batch_Id);
60: x_return_status := fnd_api.g_ret_sts_success;
61: OPEN C;
62: FETCH C INTO Recinfo;
63: IF (C%NOTFOUND) THEN

Line 92: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_batch-');

88: p_count => x_msg_count,
89: p_data => x_msg_data);
90: END IF;
91: END IF;
92: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_batch-');
93: END Lock_batch;
94:
95:
96:

Line 108: arp_util.debug(' Validate_batch +');

104: IS
105: --Batch should exists
106: BEGIN
107:
108: arp_util.debug(' Validate_batch +');
109:
110: x_cascade_update := 'N';
111:
112: IF p_action = 'UPDATE' THEN

Line 133: arp_util.debug('Value value possible for batch_status is F or D');

129:
130: IF p_new_batch_rec.batch_status NOT IN ('D','F') OR
131: p_old_batch_rec.batch_status NOT IN ('D','F')
132: THEN
133: arp_util.debug('Value value possible for batch_status is F or D');
134: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
135: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'BATCH_STATUS' );
136: FND_MESSAGE.SET_TOKEN( 'VALUES', g_draft||','||g_final);
137: FND_MSG_PUB.ADD;

Line 144: arp_util.debug('Value value possible for transferred_status are N, E , S , P');

140:
141: IF p_new_batch_rec.transferred_status NOT IN ('N','E','S','P') OR
142: p_old_batch_rec.transferred_status NOT IN ('N','E','S','P')
143: THEN
144: arp_util.debug('Value value possible for transferred_status are N, E , S , P');
145: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
146: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );
147: FND_MESSAGE.SET_TOKEN( 'VALUES', g_not||','||g_error||','||g_success);
148: FND_MSG_PUB.ADD;

Line 155: arp_util.debug('Can not update the batch status as it is F');

151:
152:
153: IF p_old_batch_rec.batch_status = 'F' AND p_new_batch_rec.batch_status <> 'F'
154: THEN
155: arp_util.debug('Can not update the batch status as it is F');
156: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
157: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');
158: FND_MSG_PUB.ADD;
159: x_return_status := FND_API.G_RET_STS_ERROR;

Line 175: arp_util.debug('Draft batch only accepts transferred status N');

171: END IF;
172:
173:
174: IF p_new_batch_rec.batch_status = 'D' AND p_new_batch_rec.transferred_status <> 'N' THEN
175: arp_util.debug('Draft batch only accepts transferred status N');
176: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
177: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );
178: FND_MESSAGE.SET_TOKEN( 'VALUES', g_not);
179: FND_MSG_PUB.ADD;

Line 185: arp_util.debug('Can not update a successfull batch transferred status');

181: END IF;
182:
183:
184: IF p_old_batch_rec.transferred_status = 'S' AND p_new_batch_rec.transferred_status <> 'S' THEN
185: arp_util.debug('Can not update a successfull batch transferred status');
186: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
187: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'transferred_status' );
188: FND_MSG_PUB.ADD;
189: x_return_status := FND_API.G_RET_STS_ERROR;

Line 197: arp_util.debug('Gl Date can not be null');

193: x_cascade_update := 'Y';
194: END IF;
195:
196: IF p_new_batch_rec.gl_date = fnd_api.g_miss_date THEN
197: arp_util.debug('Gl Date can not be null');
198: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
199: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'gl_date' );
200: FND_MSG_PUB.ADD;
201: x_return_status := FND_API.G_RET_STS_ERROR;

Line 220: arp_util.debug('Only Draft batches are delateable');

216: END IF;
217:
218: IF p_action = 'DELETE' THEN
219: IF p_old_batch_rec.batch_status <> 'D' THEN
220: arp_util.debug('Only Draft batches are delateable');
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MESSAGE.SET_NAME( 'AR', 'AR_DRAFT_BATCH_DELETABLE' );
223: FND_MSG_PUB.ADD;
224: END IF;

Line 227: arp_util.debug(' Validate_batch -');

223: FND_MSG_PUB.ADD;
224: END IF;
225: END IF;
226:
227: arp_util.debug(' Validate_batch -');
228: END;
229:
230: PROCEDURE Delete_batch
231: ( p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

Line 257: arp_util.debug('Delete_Batch +');

253: l_rec ar_interest_batches%ROWTYPE;
254: l_new_rec ar_interest_batches%ROWTYPE;
255: x_cascade_update VARCHAR2(1);
256: BEGIN
257: arp_util.debug('Delete_Batch +');
258: arp_util.debug(' p_interest_batch_id : '||p_interest_batch_id);
259:
260: IF fnd_api.to_boolean(p_init_msg_list) THEN
261: fnd_msg_pub.initialize;

Line 258: arp_util.debug(' p_interest_batch_id : '||p_interest_batch_id);

254: l_new_rec ar_interest_batches%ROWTYPE;
255: x_cascade_update VARCHAR2(1);
256: BEGIN
257: arp_util.debug('Delete_Batch +');
258: arp_util.debug(' p_interest_batch_id : '||p_interest_batch_id);
259:
260: IF fnd_api.to_boolean(p_init_msg_list) THEN
261: fnd_msg_pub.initialize;
262: END IF;

Line 325: arp_util.debug('Delete_Batch -');

321:
322: DELETE FROM AR_INTEREST_BATCHES
323: WHERE interest_batch_id = p_interest_batch_id ;
324:
325: arp_util.debug('Delete_Batch -');
326: EXCEPTION
327: WHEN fnd_api.g_exc_error THEN
328: x_return_status := fnd_api.g_ret_sts_error;
329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 380: arp_util.debug('update_batch +');

376: l_new_rec ar_interest_batches%ROWTYPE;
377: x_cascade_update VARCHAR2(1);
378:
379: BEGIN
380: arp_util.debug('update_batch +');
381: arp_util.debug(' p_interest_batch_id : '||p_interest_batch_id);
382:
383: savepoint update_batch;
384:

Line 381: arp_util.debug(' p_interest_batch_id : '||p_interest_batch_id);

377: x_cascade_update VARCHAR2(1);
378:
379: BEGIN
380: arp_util.debug('update_batch +');
381: arp_util.debug(' p_interest_batch_id : '||p_interest_batch_id);
382:
383: savepoint update_batch;
384:
385: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 476: arp_util.debug('update_batch -');

472: LAST_UPDATE_LOGIN = NVL(arp_global.LAST_UPDATE_LOGIN,-1),
473: object_version_number = x_OBJECT_VERSION_NUMBER
474: WHERE interest_batch_id = P_INTEREST_BATCH_ID;
475:
476: arp_util.debug('update_batch -');
477: EXCEPTION
478: WHEN fnd_api.g_exc_error THEN
479: rollback to update_batch;
480: x_return_status := fnd_api.g_ret_sts_error;