DBA Data[Home] [Help]

APPS.AR_INTEREST_HEADERS_PKG dependencies on FND_MSG_PUB

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

100: FETCH C INTO Recinfo;
101: IF (C%NOTFOUND) THEN
102: x_return_status := fnd_api.g_ret_sts_error;
103: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
104: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
105: p_count => x_msg_count,
106: p_data => x_msg_data);
107: l_continue := 'N';
108: END IF;

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

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,
173: p_data => x_msg_data);
174: END IF;
175: END IF;

Line 202: FND_MSG_PUB.ADD;

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;
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

Line 210: FND_MSG_PUB.ADD;

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;
212: END IF;
213:
214: IF (p_old_rec.process_status <> 'S')

Line 220: fnd_msg_pub.add;

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;
223: END IF;
224: END IF;

Line 231: FND_MSG_PUB.ADD;

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;
233: ELSE
234: OPEN c;
235: FETCH c INTO l_flag;

Line 241: FND_MSG_PUB.ADD;

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;
243: END IF;
244: END IF;
245: CLOSE c;

Line 277: fnd_msg_pub.initialize;

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;
278: END IF;
279:
280: x_return_status := fnd_api.G_RET_STS_SUCCESS;
281:

Line 291: fnd_msg_pub.add;

287: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
288: fnd_message.set_token('RECORD', 'ar_interest_headers');
289: fnd_message.set_token('VALUE',
290: NVL(TO_CHAR(P_INTEREST_header_ID), 'null'));
291: fnd_msg_pub.add;
292: RAISE fnd_api.g_exc_error;
293: END IF;
294:
295: IF NOT ((x_object_version_number IS NULL AND

Line 303: fnd_msg_pub.add;

299: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
300: THEN
301: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
302: fnd_message.set_token('TABLE', 'ar_interest_batches');
303: fnd_msg_pub.add;
304: RAISE fnd_api.g_exc_error;
305: END IF;
306:
307: l_new_rec.process_status := P_PROCESS_STATUS;

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

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;
337: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
338: p_count => x_msg_count,
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 );

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

337: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
338: p_count => x_msg_count,
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;

Line 349: fnd_msg_pub.add;

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');
348: fnd_message.set_token('ERROR' ,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);

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

346: x_return_status := fnd_api.g_ret_sts_unexp_error;
347: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
348: fnd_message.set_token('ERROR' ,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;

Line 375: fnd_msg_pub.initialize;

371: BEGIN
372: SAVEPOINT delete_header;
373:
374: IF fnd_api.to_boolean(p_init_msg_list) THEN
375: fnd_msg_pub.initialize;
376: END IF;
377:
378: x_return_status := fnd_api.G_RET_STS_SUCCESS;
379:

Line 389: fnd_msg_pub.add;

385: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
386: fnd_message.set_token('RECORD', 'ar_interest_headers');
387: fnd_message.set_token('VALUE',
388: NVL(TO_CHAR(P_INTEREST_header_ID), 'null'));
389: fnd_msg_pub.add;
390: RAISE fnd_api.g_exc_error;
391: END IF;
392:
393: validate_header

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

409: EXCEPTION
410: WHEN fnd_api.g_exc_error THEN
411: ROLLBACK TO SAVEPOINT delete_header;
412: x_return_status := fnd_api.g_ret_sts_error;
413: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
414: p_count => x_msg_count,
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 );

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

413: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
414: p_count => x_msg_count,
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;

Line 425: fnd_msg_pub.add;

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');
424: fnd_message.set_token('ERROR' ,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);

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

422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
424: fnd_message.set_token('ERROR' ,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;