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 178: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line +');

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

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

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

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

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

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

236: PROCESS_MESSAGE = P_PROCESS_MESSAGE,
237: object_version_number = x_object_version_number
238: WHERE interest_line_id = P_INTEREST_LINE_ID;
239:
240: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line -');
241: EXCEPTION
242: WHEN fnd_api.g_exc_error THEN
243: ROLLBACK TO SAVEPOINT Update_line;
244: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

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

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

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

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

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

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

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

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

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