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

Line 47: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_line+');

43: WHERE interest_line_id = p_interest_line_id
44: FOR UPDATE of Interest_Line_Id NOWAIT;
45: Recinfo C%ROWTYPE;
46: BEGIN
47: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_line+');
48: x_return_status := fnd_api.g_ret_sts_success;
49:
50: OPEN C;
51: FETCH C INTO Recinfo;

Line 96: arp_util.debug(' Line Record Changed');

92: AND (NVL(Recinfo.object_version_number,1) = NVL(P_object_version_number,1))
93: THEN
94: RETURN;
95: ELSE
96: arp_util.debug(' Line Record Changed');
97: x_return_status := fnd_api.g_ret_sts_error;
98: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
99: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
100: p_count => x_msg_count,

Line 103: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_line-');

99: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
100: p_count => x_msg_count,
101: p_data => x_msg_data);
102: END IF;
103: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_line-');
104: END Lock_line;
105:
106: PROCEDURE validate_line
107: (p_action IN VARCHAR2,

Line 118: arp_util.debug('validate_line +');

114: FROM ar_interest_headers
115: WHERE interest_header_id = p_old_rec.interest_header_id;
116: l_header_status VARCHAR2(1);
117: BEGIN
118: arp_util.debug('validate_line +');
119: arp_util.debug(' p_action :'||p_action);
120: OPEN c;
121: FETCH c INTO l_header_status;
122: IF c%NOTFOUND THEN

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

115: WHERE interest_header_id = p_old_rec.interest_header_id;
116: l_header_status VARCHAR2(1);
117: BEGIN
118: arp_util.debug('validate_line +');
119: arp_util.debug(' p_action :'||p_action);
120: OPEN c;
121: FETCH c INTO l_header_status;
122: IF c%NOTFOUND THEN
123: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

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

131:
132: IF p_action = 'UPDATE' THEN
133: IF l_header_status = 'S' THEN
134: IF p_old_rec.process_status <> p_new_rec.process_status THEN
135: arp_util.debug('Column process_status not updatable');
136: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
137: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');
138: FND_MSG_PUB.ADD;
139: x_return_status := FND_API.G_RET_STS_ERROR;

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

144:
145: IF p_action = 'DELETE' THEN
146: IF l_header_status = 'S' THEN
147: IF p_old_rec.process_status <> p_new_rec.process_status THEN
148: arp_util.debug('Column process_status not updatable');
149: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
150: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');
151: FND_MSG_PUB.ADD;
152: x_return_status := FND_API.G_RET_STS_ERROR;

Line 156: arp_util.debug('validate_line -');

152: x_return_status := FND_API.G_RET_STS_ERROR;
153: END IF;
154: END IF;
155: END IF;
156: arp_util.debug('validate_line -');
157: END;
158:
159:
160: PROCEDURE Update_line

Line 180: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line +');

176: FOR UPDATE OF INTEREST_line_ID;
177: l_rec ar_interest_lines%ROWTYPE;
178: l_new_rec ar_interest_lines%ROWTYPE;
179: BEGIN
180: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line +');
181: arp_util.debug(' p_interest_line_id :' ||P_INTEREST_LINE_ID);
182: SAVEPOINT Update_line;
183: x_return_status := fnd_api.g_ret_sts_success;
184:

Line 181: arp_util.debug(' p_interest_line_id :' ||P_INTEREST_LINE_ID);

177: l_rec ar_interest_lines%ROWTYPE;
178: l_new_rec ar_interest_lines%ROWTYPE;
179: BEGIN
180: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line +');
181: arp_util.debug(' p_interest_line_id :' ||P_INTEREST_LINE_ID);
182: SAVEPOINT Update_line;
183: x_return_status := fnd_api.g_ret_sts_success;
184:
185: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 231: arp_util.debug(' updating ar_interest_lines');

227: END IF;
228:
229: x_object_version_number := NVL(x_object_version_number,1) + 1;
230:
231: arp_util.debug(' updating ar_interest_lines');
232: UPDATE AR_INTEREST_LINES
233: SET
234: LAST_UPDATE_DATE = SYSDATE,
235: LAST_UPDATED_BY = NVL(arp_global.last_updated_by,-1),

Line 244: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line -');

240: DAYS_OF_INTEREST = P_DAYS_INTEREST,
241: INTEREST_CHARGED = P_INTEREST_CHARGED
242: WHERE interest_line_id = P_INTEREST_LINE_ID;
243:
244: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line -');
245: EXCEPTION
246: WHEN fnd_api.g_exc_error THEN
247: ROLLBACK TO SAVEPOINT Update_line;
248: x_return_status := fnd_api.g_ret_sts_error;

Line 252: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.update_line :'||x_msg_data);

248: x_return_status := fnd_api.g_ret_sts_error;
249: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
250: p_count => x_msg_count,
251: p_data => x_msg_data);
252: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.update_line :'||x_msg_data);
253: WHEN OTHERS THEN
254: ROLLBACK TO SAVEPOINT Update_line;
255: x_return_status := fnd_api.g_ret_sts_unexp_error;
256: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 262: arp_util.debug('EXCEPTION OTHERS AR_INTEREST_BATCHES_PKG.update_line :'||SQLERRM);

258: fnd_msg_pub.add;
259: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
260: p_count => x_msg_count,
261: p_data => x_msg_data);
262: arp_util.debug('EXCEPTION OTHERS AR_INTEREST_BATCHES_PKG.update_line :'||SQLERRM);
263: END Update_Line;
264:
265:
266:

Line 283: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line +');

279: FOR UPDATE OF INTEREST_line_ID;
280: l_rec ar_interest_lines%ROWTYPE;
281: l_new_rec ar_interest_lines%ROWTYPE;
282: BEGIN
283: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line +');
284: SAVEPOINT Delete_line;
285: x_return_status := fnd_api.g_ret_sts_success;
286:
287: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 331: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line -');

327:
328: DELETE FROM AR_INTEREST_LINES
329: WHERE interest_line_id = p_interest_line_id;
330:
331: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line -');
332: EXCEPTION
333: WHEN fnd_api.g_exc_error THEN
334: ROLLBACK TO SAVEPOINT Delete_line;
335: x_return_status := fnd_api.g_ret_sts_error;

Line 339: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.delete_line :'||x_msg_data);

335: x_return_status := fnd_api.g_ret_sts_error;
336: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
337: p_count => x_msg_count,
338: p_data => x_msg_data);
339: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.delete_line :'||x_msg_data);
340: WHEN OTHERS THEN
341: ROLLBACK TO SAVEPOINT Delete_line;
342: x_return_status := fnd_api.g_ret_sts_unexp_error;
343: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 349: arp_util.debug('EXCEPTION OTHERS AR_INTEREST_BATCHES_PKG.delete_line :'||SQLERRM);

345: fnd_msg_pub.add;
346: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
347: p_count => x_msg_count,
348: p_data => x_msg_data);
349: arp_util.debug('EXCEPTION OTHERS AR_INTEREST_BATCHES_PKG.delete_line :'||SQLERRM);
350:
351: END Delete_line;
352:
353: