DBA Data[Home] [Help]

APPS.HZ_IMP_BATCH_SUMMARY_V2PUB dependencies on FND_MESSAGE

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

115: AND orig_system<>'SST'
116: AND status='A';
117: EXCEPTION
118: WHEN NO_DATA_FOUND THEN
119: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');
120: FND_MESSAGE.SET_TOKEN('FK','orig_system');
121: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
122: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');
123: FND_MSG_PUB.ADD;

Line 120: FND_MESSAGE.SET_TOKEN('FK','orig_system');

116: AND status='A';
117: EXCEPTION
118: WHEN NO_DATA_FOUND THEN
119: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');
120: FND_MESSAGE.SET_TOKEN('FK','orig_system');
121: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
122: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');
123: FND_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;

Line 121: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');

117: EXCEPTION
118: WHEN NO_DATA_FOUND THEN
119: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');
120: FND_MESSAGE.SET_TOKEN('FK','orig_system');
121: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
122: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');
123: FND_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END;

Line 122: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');

118: WHEN NO_DATA_FOUND THEN
119: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');
120: FND_MESSAGE.SET_TOKEN('FK','orig_system');
121: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
122: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');
123: FND_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END;
126:

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

242: ROLLBACK TO create_import_batch;
243:
244: x_return_status := fnd_api.g_ret_sts_unexp_error;
245:
246: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
247: fnd_message.set_token('ERROR',SQLERRM);
248: fnd_msg_pub.add;
249:
250: fnd_msg_pub.count_and_get(

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

243:
244: x_return_status := fnd_api.g_ret_sts_unexp_error;
245:
246: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
247: fnd_message.set_token('ERROR',SQLERRM);
248: fnd_msg_pub.add;
249:
250: fnd_msg_pub.count_and_get(
251: p_encoded => fnd_api.g_false,

Line 345: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

341: WHERE batch_id = p_batch_id;
342:
343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN
345: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
346: fnd_message.set_token('FK', 'p_batch_id');
347: fnd_message.set_token('COLUMN', 'batch_id');
348: fnd_message.set_token('TABLE', 'hz_imp_batch_summary');
349: fnd_msg_pub.add;

Line 346: fnd_message.set_token('FK', 'p_batch_id');

342:
343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN
345: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
346: fnd_message.set_token('FK', 'p_batch_id');
347: fnd_message.set_token('COLUMN', 'batch_id');
348: fnd_message.set_token('TABLE', 'hz_imp_batch_summary');
349: fnd_msg_pub.add;
350: x_return_status := fnd_api.g_ret_sts_error;

Line 347: fnd_message.set_token('COLUMN', 'batch_id');

343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN
345: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
346: fnd_message.set_token('FK', 'p_batch_id');
347: fnd_message.set_token('COLUMN', 'batch_id');
348: fnd_message.set_token('TABLE', 'hz_imp_batch_summary');
349: fnd_msg_pub.add;
350: x_return_status := fnd_api.g_ret_sts_error;
351: END;

Line 348: fnd_message.set_token('TABLE', 'hz_imp_batch_summary');

344: WHEN NO_DATA_FOUND THEN
345: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
346: fnd_message.set_token('FK', 'p_batch_id');
347: fnd_message.set_token('COLUMN', 'batch_id');
348: fnd_message.set_token('TABLE', 'hz_imp_batch_summary');
349: fnd_msg_pub.add;
350: x_return_status := fnd_api.g_ret_sts_error;
351: END;
352:

Line 367: fnd_message.set_name('AR', 'HZ_INVALID_IMP_BATCH');

363: AND NVL(batch_status,'ACTIVE') NOT IN ('PURGED', 'REJECTED', 'PROCESSING', 'COMPLETED', 'ACTION_REQUIRED');
364:
365: EXCEPTION
366: WHEN NO_DATA_FOUND THEN
367: fnd_message.set_name('AR', 'HZ_INVALID_IMP_BATCH');
368: fnd_msg_pub.add;
369: x_return_status := fnd_api.g_ret_sts_error;
370: END;
371:

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

432: ROLLBACK TO activate_batch;
433:
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435:
436: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
437: fnd_message.set_token('ERROR',SQLERRM);
438: fnd_msg_pub.add;
439:
440: fnd_msg_pub.count_and_get(

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

433:
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435:
436: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
437: fnd_message.set_token('ERROR',SQLERRM);
438: fnd_msg_pub.add;
439:
440: fnd_msg_pub.count_and_get(
441: p_encoded => fnd_api.g_false,