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

Line 23: arp_util.debug('get_header_amount +');

19: WHERE ii.interest_header_id = iil.interest_header_id
20: AND ii.interest_header_id = p_interest_header_id;
21: l_header_amount number;
22: BEGIN
23: arp_util.debug('get_header_amount +');
24: arp_util.debug(' p_interest_header_id :'||p_interest_header_id);
25: OPEN c;
26: FETCH c INTO l_header_amount;
27: CLOSE c;

Line 24: arp_util.debug(' p_interest_header_id :'||p_interest_header_id);

20: AND ii.interest_header_id = p_interest_header_id;
21: l_header_amount number;
22: BEGIN
23: arp_util.debug('get_header_amount +');
24: arp_util.debug(' p_interest_header_id :'||p_interest_header_id);
25: OPEN c;
26: FETCH c INTO l_header_amount;
27: CLOSE c;
28: arp_util.debug(' result :'||l_header_amount);

Line 28: arp_util.debug(' result :'||l_header_amount);

24: arp_util.debug(' p_interest_header_id :'||p_interest_header_id);
25: OPEN c;
26: FETCH c INTO l_header_amount;
27: CLOSE c;
28: arp_util.debug(' result :'||l_header_amount);
29: arp_util.debug('get_header_amount -');
30: RETURN l_header_amount;
31: END;
32:

Line 29: arp_util.debug('get_header_amount -');

25: OPEN c;
26: FETCH c INTO l_header_amount;
27: CLOSE c;
28: arp_util.debug(' result :'||l_header_amount);
29: arp_util.debug('get_header_amount -');
30: RETURN l_header_amount;
31: END;
32:
33: PROCEDURE Lock_header

Line 97: arp_util.debug('lock_header +');

93: FOR UPDATE OF interest_header_Id NOWAIT;
94: Recinfo C%ROWTYPE;
95: l_continue VARCHAR2(1) := 'Y';
96: BEGIN
97: arp_util.debug('lock_header +');
98:
99: OPEN C;
100: FETCH C INTO Recinfo;
101: IF (C%NOTFOUND) THEN

Line 168: arp_util.debug(' Header Record Changed');

164: AND (NVL(P_OBJECT_VERSION_NUMBER,1) = NVL(Recinfo.OBJECT_VERSION_NUMBER,1))
165: THEN
166: RETURN;
167: ELSE
168: arp_util.debug(' Header Record Changed');
169: x_return_status := fnd_api.g_ret_sts_error;
170: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
171: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
172: p_count => x_msg_count,

Line 176: arp_util.debug('lock_header -');

172: p_count => x_msg_count,
173: p_data => x_msg_data);
174: END IF;
175: END IF;
176: arp_util.debug('lock_header -');
177: END Lock_Header;
178:
179:
180: PROCEDURE validate_header

Line 193: arp_util.debug('validate_header +');

189: FROM ar_interest_batches
190: WHERE interest_batch_id = p_old_rec.interest_batch_id;
191: l_flag VARCHAR2(1);
192: BEGIN
193: arp_util.debug('validate_header +');
194: arp_util.debug(' p_action :'||p_action);
195: IF p_action = 'UPDATE' THEN
196:
197: IF p_new_rec.process_status NOT IN ('E','S','N') THEN

Line 194: arp_util.debug(' p_action :'||p_action);

190: WHERE interest_batch_id = p_old_rec.interest_batch_id;
191: l_flag VARCHAR2(1);
192: BEGIN
193: arp_util.debug('validate_header +');
194: arp_util.debug(' p_action :'||p_action);
195: IF p_action = 'UPDATE' THEN
196:
197: IF p_new_rec.process_status NOT IN ('E','S','N') THEN
198: arp_util.debug('Column process_status can take values from E S or N only');

Line 198: arp_util.debug('Column process_status can take values from E S or N only');

194: arp_util.debug(' p_action :'||p_action);
195: IF p_action = 'UPDATE' THEN
196:
197: IF p_new_rec.process_status NOT IN ('E','S','N') THEN
198: arp_util.debug('Column process_status can take values from E S or N only');
199: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
200: FND_MESSAGE.SET_NAME( 'COLUMN', 'PROCESS_STATUS' );
201: FND_MESSAGE.SET_TOKEN( 'VALUES', g_error||','||g_success||','||g_not);
202: FND_MSG_PUB.ADD;

Line 207: arp_util.debug('Column process_status not updatable');

203: x_return_status := FND_API.G_RET_STS_ERROR;
204: END IF;
205:
206: IF p_old_rec.process_status = 'S' AND p_new_rec.process_status = 'S' THEN
207: arp_util.debug('Column process_status not updatable');
208: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
209: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');
210: FND_MSG_PUB.ADD;
211: x_return_status := FND_API.G_RET_STS_ERROR;

Line 218: arp_util.debug('Only creation of late charge document set the status to S');

214: IF (p_old_rec.process_status <> 'S')
215: AND (p_new_rec.process_status = 'S' OR p_new_rec.process_status = 'E')
216: THEN
217: IF p_updated_by_program = 'ARIINR' THEN
218: arp_util.debug('Only creation of late charge document set the status to S');
219: fnd_message.set_name('AR', 'AR_STATUS_RESERVE_FOR_SRS');
220: fnd_msg_pub.add;
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: END IF;

Line 228: arp_util.debug('Column process_status not updatable');

224: END IF;
225:
226: IF p_action = 'DELETE' THEN
227: IF p_old_rec.process_status = 'S' THEN
228: arp_util.debug('Column process_status not updatable');
229: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
230: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');
231: FND_MSG_PUB.ADD;
232: x_return_status := FND_API.G_RET_STS_ERROR;

Line 238: arp_util.debug('Column process_status not updatable');

234: OPEN c;
235: FETCH c INTO l_flag;
236: IF c%FOUND THEN
237: IF l_flag = 'S' THEN
238: arp_util.debug('Column process_status not updatable');
239: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
240: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');
241: FND_MSG_PUB.ADD;
242: x_return_status := FND_API.G_RET_STS_ERROR;

Line 248: arp_util.debug('validate_header -');

244: END IF;
245: CLOSE c;
246: END IF;
247: END IF;
248: arp_util.debug('validate_header -');
249: END;
250:
251:
252:

Line 273: arp_util.debug('update_header +');

269: FOR UPDATE OF INTEREST_header_ID;
270: l_rec ar_interest_headers%ROWTYPE;
271: l_new_rec ar_interest_headers%ROWTYPE;
272: BEGIN
273: arp_util.debug('update_header +');
274: SAVEPOINT update_header;
275:
276: IF fnd_api.to_boolean(p_init_msg_list) THEN
277: fnd_msg_pub.initialize;

Line 332: arp_util.debug('lock_header -');

328: LAST_UPDATED_BY = NVL(arp_global.last_updated_by,-1),
329: LAST_UPDATE_LOGIN = NVL(arp_global.LAST_UPDATE_LOGIN,-1),
330: object_version_number = x_object_version_number
331: WHERE INTEREST_HEADER_ID = p_INTEREST_HEADER_ID;
332: arp_util.debug('lock_header -');
333: EXCEPTION
334: WHEN fnd_api.g_exc_error THEN
335: ROLLBACK TO SAVEPOINT Update_header;
336: x_return_status := fnd_api.g_ret_sts_error;

Line 343: arp_util.debug('EXCEPTION AR_INTEREST_HEADERS_PKG.update_header :'||x_msg_data);

339: p_data => x_msg_data);
340: IF x_msg_count > 1 THEN
341: x_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST,FND_API.G_FALSE );
342: END IF;
343: arp_util.debug('EXCEPTION AR_INTEREST_HEADERS_PKG.update_header :'||x_msg_data);
344: WHEN OTHERS THEN
345: ROLLBACK TO SAVEPOINT Update_header;
346: x_return_status := fnd_api.g_ret_sts_unexp_error;
347: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 353: arp_util.debug('EXCEPTION OTHERS AR_INTEREST_HEADERS_PKG.update_header :'||SQLERRM);

349: fnd_msg_pub.add;
350: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
351: p_count => x_msg_count,
352: p_data => x_msg_data);
353: arp_util.debug('EXCEPTION OTHERS AR_INTEREST_HEADERS_PKG.update_header :'||SQLERRM);
354: END Update_header;
355:
356: PROCEDURE Delete_header
357: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

Line 419: arp_util.debug('EXCEPTION AR_INTEREST_HEADERS_PKG.delete_header :'||x_msg_data);

415: p_data => x_msg_data);
416: IF x_msg_count > 1 THEN
417: x_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST,FND_API.G_FALSE );
418: END IF;
419: arp_util.debug('EXCEPTION AR_INTEREST_HEADERS_PKG.delete_header :'||x_msg_data);
420: WHEN OTHERS THEN
421: ROLLBACK TO SAVEPOINT Update_header;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 429: arp_util.debug('EXCEPTION OTHERS AR_INTEREST_HEADERS_PKG.delete_header :'||SQLERRM);

425: fnd_msg_pub.add;
426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
427: p_count => x_msg_count,
428: p_data => x_msg_data);
429: arp_util.debug('EXCEPTION OTHERS AR_INTEREST_HEADERS_PKG.delete_header :'||SQLERRM);
430: END Delete_header;
431:
432:
433: END AR_INTEREST_HEADERS_PKG;