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 FND_MSG_PUB

Line 68: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

64: CLOSE C;
65: l_continue := 'N';
66: x_return_status := fnd_api.g_ret_sts_error;
67: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
68: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
69: p_count => x_msg_count,
70: p_data => x_msg_data);
71: END IF;
72: CLOSE C;

Line 87: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

83: RETURN;
84: ELSE
85: x_return_status := fnd_api.g_ret_sts_error;
86: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
87: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
88: p_count => x_msg_count,
89: p_data => x_msg_data);
90: END IF;
91: END IF;

Line 118: FND_MSG_PUB.ADD;

114: IF p_old_batch_rec.batch_status IS NULL OR p_new_batch_rec.batch_status IS NULL
115: THEN
116: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
117: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'BATCH_STATUS' );
118: FND_MSG_PUB.ADD;
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: END IF;
121:
122: IF p_old_batch_rec.transferred_status IS NULL OR p_new_batch_rec.transferred_status IS NULL

Line 126: FND_MSG_PUB.ADD;

122: IF p_old_batch_rec.transferred_status IS NULL OR p_new_batch_rec.transferred_status IS NULL
123: THEN
124: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
125: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );
126: FND_MSG_PUB.ADD;
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: END IF;
129:
130: IF p_new_batch_rec.batch_status NOT IN ('D','F') OR

Line 137: FND_MSG_PUB.ADD;

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;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: END IF;
140:
141: IF p_new_batch_rec.transferred_status NOT IN ('N','E','S','P') OR

Line 148: FND_MSG_PUB.ADD;

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;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF;
151:
152:

Line 158: FND_MSG_PUB.ADD;

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;
160: END IF;
161:
162:

Line 169: fnd_msg_pub.add;

165: AND p_new_batch_rec.transferred_status <> p_old_batch_rec.transferred_status
166: THEN
167: x_return_status := fnd_api.g_ret_sts_error;
168: fnd_message.set_name('AR', 'AR_STATUS_RESERVE_FOR_SRS');
169: fnd_msg_pub.add;
170: END IF;
171: END IF;
172:
173:

Line 179: FND_MSG_PUB.ADD;

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;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: END IF;
182:
183:

Line 188: FND_MSG_PUB.ADD;

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;
190: END IF;
191:
192: IF p_old_batch_rec.transferred_status <> 'N' AND p_new_batch_rec.transferred_status ='N' THEN

Line 200: FND_MSG_PUB.ADD;

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;
202: END IF;
203:
204: IF (p_new_batch_rec.gl_date <> fnd_api.g_miss_date) AND

Line 210: FND_MSG_PUB.ADD;

206: THEN
207: IF p_new_batch_rec.transferred_status <> 'N' THEN
208: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
209: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
210: FND_MSG_PUB.ADD;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: END IF;
213: END IF;
214:

Line 223: FND_MSG_PUB.ADD;

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;
225: END IF;
226:
227: arp_util.debug(' Validate_batch -');

Line 261: fnd_msg_pub.initialize;

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;
263:
264: x_return_status := fnd_api.G_RET_STS_SUCCESS;
265:

Line 285: fnd_msg_pub.add;

281: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
282: fnd_message.set_token('RECORD', 'ar_interest_batches');
283: fnd_message.set_token('VALUE',
284: NVL(TO_CHAR(P_INTEREST_BATCH_ID), 'null'));
285: fnd_msg_pub.add;
286: RAISE fnd_api.g_exc_error;
287: END IF;
288:
289: IF NOT ((x_object_version_number IS NULL AND

Line 297: fnd_msg_pub.add;

293: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
294: THEN
295: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
296: fnd_message.set_token('TABLE', 'ar_interest_batches');
297: fnd_msg_pub.add;
298: RAISE fnd_api.g_exc_error;
299: END IF;
300:
301: Validate_batch

Line 329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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,
330: p_count => x_msg_count,
331: p_data => x_msg_data);
332:
333: IF x_msg_count > 1 THEN

Line 334: x_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST,FND_API.G_FALSE );

330: p_count => x_msg_count,
331: p_data => x_msg_data);
332:
333: IF x_msg_count > 1 THEN
334: x_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST,FND_API.G_FALSE );
335: END IF;
336: WHEN OTHERS THEN
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 340: fnd_msg_pub.add;

336: WHEN OTHERS THEN
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
339: fnd_message.set_token('ERROR' ,SQLERRM);
340: fnd_msg_pub.add;
341: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
342: p_count => x_msg_count,
343: p_data => x_msg_data);
344:

Line 341: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
339: fnd_message.set_token('ERROR' ,SQLERRM);
340: fnd_msg_pub.add;
341: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
342: p_count => x_msg_count,
343: p_data => x_msg_data);
344:
345: END Delete_batch;

Line 386: fnd_msg_pub.initialize;

382:
383: savepoint update_batch;
384:
385: IF fnd_api.to_boolean(p_init_msg_list) THEN
386: fnd_msg_pub.initialize;
387: END IF;
388:
389: x_return_status := fnd_api.G_RET_STS_SUCCESS;
390:

Line 410: fnd_msg_pub.add;

406: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
407: fnd_message.set_token('RECORD', 'ar_interest_batches');
408: fnd_message.set_token('VALUE',
409: NVL(TO_CHAR(P_INTEREST_BATCH_ID), 'null'));
410: fnd_msg_pub.add;
411: RAISE fnd_api.g_exc_error;
412: END IF;
413:
414: IF NOT ((x_object_version_number IS NULL AND

Line 422: fnd_msg_pub.add;

418: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
419: THEN
420: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
421: fnd_message.set_token('TABLE', 'ar_interest_batches');
422: fnd_msg_pub.add;
423: RAISE fnd_api.g_exc_error;
424: END IF;
425:
426: l_new_rec.INTEREST_BATCH_ID := P_INTEREST_BATCH_ID;

Line 482: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

478: WHEN fnd_api.g_exc_error THEN
479: rollback to update_batch;
480: x_return_status := fnd_api.g_ret_sts_error;
481:
482: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
483: p_count => x_msg_count,
484: p_data => x_msg_data);
485: IF x_msg_count > 1 THEN
486: x_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST,FND_API.G_FALSE );

Line 486: x_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST,FND_API.G_FALSE );

482: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
483: p_count => x_msg_count,
484: p_data => x_msg_data);
485: IF x_msg_count > 1 THEN
486: x_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST,FND_API.G_FALSE );
487: END IF;
488:
489: WHEN OTHERS THEN
490: rollback to update_batch;

Line 494: fnd_msg_pub.add;

490: rollback to update_batch;
491: x_return_status := fnd_api.g_ret_sts_unexp_error;
492: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
493: fnd_message.set_token('ERROR' ,SQLERRM);
494: fnd_msg_pub.add;
495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
496: p_count => x_msg_count,
497: p_data => x_msg_data);
498: END;

Line 495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

491: x_return_status := fnd_api.g_ret_sts_unexp_error;
492: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
493: fnd_message.set_token('ERROR' ,SQLERRM);
494: fnd_msg_pub.add;
495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
496: p_count => x_msg_count,
497: p_data => x_msg_data);
498: END;
499: