DBA Data[Home] [Help]

APPS.AR_INTEREST_HEADERS_PKG dependencies on FND_MESSAGE

Line 103: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

99: OPEN C;
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';

Line 170: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');

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

Line 199: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );

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;
203: x_return_status := FND_API.G_RET_STS_ERROR;

Line 200: FND_MESSAGE.SET_NAME( 'COLUMN', 'PROCESS_STATUS' );

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;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: END IF;

Line 201: FND_MESSAGE.SET_TOKEN( 'VALUES', g_error||','||g_success||','||g_not);

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;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: END IF;
205:

Line 208: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );

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

Line 209: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');

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;
212: END IF;
213:

Line 219: fnd_message.set_name('AR', 'AR_STATUS_RESERVE_FOR_SRS');

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

Line 229: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );

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;
233: ELSE

Line 230: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');

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;
233: ELSE
234: OPEN c;

Line 239: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );

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

Line 240: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');

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

Line 287: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

283: FETCH c INTO l_rec;
284: CLOSE c;
285:
286: IF l_rec.INTEREST_header_ID IS NULL THEN
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;

Line 288: fnd_message.set_token('RECORD', 'ar_interest_headers');

284: CLOSE c;
285:
286: IF l_rec.INTEREST_header_ID IS NULL THEN
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;

Line 289: fnd_message.set_token('VALUE',

285:
286: IF l_rec.INTEREST_header_ID IS NULL THEN
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;

Line 301: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

297: (x_object_version_number IS NOT NULL AND
298: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
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;

Line 302: fnd_message.set_token('TABLE', 'ar_interest_batches');

298: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
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:

Line 347: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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');
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,

Line 348: fnd_message.set_token('ERROR' ,SQLERRM);

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

Line 385: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

381: FETCH c INTO l_rec;
382: CLOSE c;
383:
384: IF l_rec.INTEREST_header_ID IS NULL THEN
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;

Line 386: fnd_message.set_token('RECORD', 'ar_interest_headers');

382: CLOSE c;
383:
384: IF l_rec.INTEREST_header_ID IS NULL THEN
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;

Line 387: fnd_message.set_token('VALUE',

383:
384: IF l_rec.INTEREST_header_ID IS NULL THEN
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;

Line 423: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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');
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,

Line 424: fnd_message.set_token('ERROR' ,SQLERRM);

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