DBA Data[Home] [Help]

APPS.AR_INTEREST_LINES_PKG dependencies on FND_MESSAGE

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

51: FETCH C INTO Recinfo;
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;

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

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

Line 123: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

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

Line 124: FND_MESSAGE.SET_TOKEN( 'FK', 'interest_header_id' );

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

Line 125: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_old_rec.interest_header_id);

121: FETCH c INTO l_header_status;
122: IF c%NOTFOUND THEN
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;

Line 126: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_headers' );

122: IF c%NOTFOUND THEN
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;

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

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

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

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

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

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

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

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

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

192: FETCH c INTO l_rec;
193: CLOSE c;
194:
195: IF l_rec.INTEREST_line_ID IS NULL THEN
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;

Line 197: fnd_message.set_token('RECORD', 'ar_interest_lines');

193: CLOSE c;
194:
195: IF l_rec.INTEREST_line_ID IS NULL THEN
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;

Line 198: fnd_message.set_token('VALUE',

194:
195: IF l_rec.INTEREST_line_ID IS NULL THEN
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;

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

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

Line 211: fnd_message.set_token('TABLE', 'ar_interest_lines');

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

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

252: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.update_line :'||x_msg_data);
253: WHEN OTHERS THEN
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,

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

253: WHEN OTHERS THEN
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);

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

294: FETCH c INTO l_rec;
295: CLOSE c;
296:
297: IF l_rec.INTEREST_line_ID IS NULL THEN
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;

Line 299: fnd_message.set_token('RECORD', 'ar_interest_lines');

295: CLOSE c;
296:
297: IF l_rec.INTEREST_line_ID IS NULL THEN
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;

Line 300: fnd_message.set_token('VALUE',

296:
297: IF l_rec.INTEREST_line_ID IS NULL THEN
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;

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

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

Line 313: fnd_message.set_token('TABLE', 'ar_interest_lines');

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

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

339: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.delete_line :'||x_msg_data);
340: WHEN OTHERS THEN
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,

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

340: WHEN OTHERS THEN
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);