DBA Data[Home] [Help]

APPS.AR_INTEREST_LINES_PKG dependencies on FND_MSG_PUB

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

52: IF (C%NOTFOUND) THEN
53: CLOSE C;
54: x_return_status := fnd_api.g_ret_sts_error;
55: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
56: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
57: p_count => x_msg_count,
58: p_data => x_msg_data);
59: END IF;
60: CLOSE C;

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

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,
101: p_data => x_msg_data);
102: END IF;
103: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_line-');

Line 127: FND_MSG_PUB.ADD;

123: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
124: FND_MESSAGE.SET_TOKEN( 'FK', 'interest_header_id' );
125: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_old_rec.interest_header_id);
126: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_headers' );
127: FND_MSG_PUB.ADD;
128: x_return_status := FND_API.G_RET_STS_ERROR;
129: END IF;
130: CLOSE c;
131:

Line 138: FND_MSG_PUB.ADD;

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;
140: END IF;
141: END IF;
142: END IF;

Line 151: FND_MSG_PUB.ADD;

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;
153: END IF;
154: END IF;
155: END IF;

Line 186: fnd_msg_pub.initialize;

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
186: fnd_msg_pub.initialize;
187: END IF;
188:
189: x_return_status := fnd_api.G_RET_STS_SUCCESS;
190:

Line 200: fnd_msg_pub.add;

196: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
197: fnd_message.set_token('RECORD', 'ar_interest_lines');
198: fnd_message.set_token('VALUE',
199: NVL(TO_CHAR(P_INTEREST_line_ID), 'null'));
200: fnd_msg_pub.add;
201: RAISE fnd_api.g_exc_error;
202: END IF;
203:
204: IF NOT ((x_object_version_number IS NULL AND

Line 212: fnd_msg_pub.add;

208: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
209: THEN
210: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
211: fnd_message.set_token('TABLE', 'ar_interest_lines');
212: fnd_msg_pub.add;
213: RAISE fnd_api.g_exc_error;
214: END IF;
215:
216: l_new_rec.process_status := p_process_status;

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

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

Line 258: fnd_msg_pub.add;

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

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

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

Line 288: fnd_msg_pub.initialize;

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
288: fnd_msg_pub.initialize;
289: END IF;
290:
291: x_return_status := fnd_api.G_RET_STS_SUCCESS;
292:

Line 302: fnd_msg_pub.add;

298: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
299: fnd_message.set_token('RECORD', 'ar_interest_lines');
300: fnd_message.set_token('VALUE',
301: NVL(TO_CHAR(P_INTEREST_line_ID), 'null'));
302: fnd_msg_pub.add;
303: RAISE fnd_api.g_exc_error;
304: END IF;
305:
306: IF NOT ((x_object_version_number IS NULL AND

Line 314: fnd_msg_pub.add;

310: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
311: THEN
312: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
313: fnd_message.set_token('TABLE', 'ar_interest_lines');
314: fnd_msg_pub.add;
315: RAISE fnd_api.g_exc_error;
316: END IF;
317:
318: validate_line

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

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

Line 345: fnd_msg_pub.add;

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

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

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