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;
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;
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;
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:
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(
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,
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;
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;
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;
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:
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:
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(
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,