346: WHERE batch_id = p_batch_id;
347:
348: EXCEPTION
349: WHEN no_data_found THEN
350: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
351: fnd_message.set_token('FK', 'p_batch_id');
352: fnd_message.set_token('COLUMN', 'batch_id');
353: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
354: fnd_msg_pub.add;
347:
348: EXCEPTION
349: WHEN no_data_found THEN
350: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
351: fnd_message.set_token('FK', 'p_batch_id');
352: fnd_message.set_token('COLUMN', 'batch_id');
353: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
354: fnd_msg_pub.add;
355: x_return_status := fnd_api.g_ret_sts_error;
348: EXCEPTION
349: WHEN no_data_found THEN
350: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
351: fnd_message.set_token('FK', 'p_batch_id');
352: fnd_message.set_token('COLUMN', 'batch_id');
353: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
354: fnd_msg_pub.add;
355: x_return_status := fnd_api.g_ret_sts_error;
356: END;
349: WHEN no_data_found THEN
350: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
351: fnd_message.set_token('FK', 'p_batch_id');
352: fnd_message.set_token('COLUMN', 'batch_id');
353: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
354: fnd_msg_pub.add;
355: x_return_status := fnd_api.g_ret_sts_error;
356: END;
357:
373: 'ACTION_REQUIRED');
374:
375: EXCEPTION
376: WHEN no_data_found THEN
377: fnd_message.set_name('AR', 'HZ_INVALID_IMP_BATCH');
378: fnd_msg_pub.add;
379: x_return_status := fnd_api.g_ret_sts_error;
380: END;
381:
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(p_encoded => fnd_api.g_false,
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(p_encoded => fnd_api.g_false,
441: p_count => x_msg_count,
468:
469: EXCEPTION
470: WHEN fnd_api.g_exc_error THEN
471: ROLLBACK WORK;
472: fnd_message.set_name('AR', 'HZ_IMP_DB_VER_CHECK');
473: fnd_msg_pub.add;
474: fnd_msg_pub.reset;
475: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
476: l_error_message := fnd_msg_pub.get(p_msg_index => i,
621: AND pos.batch_id = p_batch_id;
622:
623: EXCEPTION
624: WHEN no_data_found THEN
625: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
626: fnd_message.set_token('FK', 'p_batch_id');
627: fnd_message.set_token('COLUMN', 'batch_id');
628: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
629: fnd_msg_pub.add;
622:
623: EXCEPTION
624: WHEN no_data_found THEN
625: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
626: fnd_message.set_token('FK', 'p_batch_id');
627: fnd_message.set_token('COLUMN', 'batch_id');
628: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
629: fnd_msg_pub.add;
630: x_return_status := fnd_api.g_ret_sts_error;
623: EXCEPTION
624: WHEN no_data_found THEN
625: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
626: fnd_message.set_token('FK', 'p_batch_id');
627: fnd_message.set_token('COLUMN', 'batch_id');
628: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
629: fnd_msg_pub.add;
630: x_return_status := fnd_api.g_ret_sts_error;
631: END;
624: WHEN no_data_found THEN
625: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
626: fnd_message.set_token('FK', 'p_batch_id');
627: fnd_message.set_token('COLUMN', 'batch_id');
628: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
629: fnd_msg_pub.add;
630: x_return_status := fnd_api.g_ret_sts_error;
631: END;
632:
655: 'ACTION_REQUIRED');
656:
657: EXCEPTION
658: WHEN no_data_found THEN
659: fnd_message.set_name('AR', 'HZ_INVALID_IMP_BATCH');
660: fnd_msg_pub.add;
661: x_return_status := fnd_api.g_ret_sts_error;
662: END;
663:
714: ROLLBACK TO reject_batch;
715:
716: x_return_status := fnd_api.g_ret_sts_unexp_error;
717:
718: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
719: fnd_message.set_token('ERROR', SQLERRM);
720: fnd_msg_pub.add;
721:
722: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
715:
716: x_return_status := fnd_api.g_ret_sts_unexp_error;
717:
718: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
719: fnd_message.set_token('ERROR', SQLERRM);
720: fnd_msg_pub.add;
721:
722: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
723: p_count => x_msg_count,
772: AND orig_system <> 'SST'
773: AND status = 'A';
774: EXCEPTION
775: WHEN no_data_found THEN
776: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
777: fnd_message.set_token('FK', 'orig_system');
778: fnd_message.set_token('COLUMN', 'orig_system');
779: fnd_message.set_token('TABLE', 'HZ_ORIG_SYSTEMS_B');
780: fnd_msg_pub.add;
773: AND status = 'A';
774: EXCEPTION
775: WHEN no_data_found THEN
776: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
777: fnd_message.set_token('FK', 'orig_system');
778: fnd_message.set_token('COLUMN', 'orig_system');
779: fnd_message.set_token('TABLE', 'HZ_ORIG_SYSTEMS_B');
780: fnd_msg_pub.add;
781: x_return_status := fnd_api.g_ret_sts_error;
774: EXCEPTION
775: WHEN no_data_found THEN
776: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
777: fnd_message.set_token('FK', 'orig_system');
778: fnd_message.set_token('COLUMN', 'orig_system');
779: fnd_message.set_token('TABLE', 'HZ_ORIG_SYSTEMS_B');
780: fnd_msg_pub.add;
781: x_return_status := fnd_api.g_ret_sts_error;
782: END;
775: WHEN no_data_found THEN
776: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
777: fnd_message.set_token('FK', 'orig_system');
778: fnd_message.set_token('COLUMN', 'orig_system');
779: fnd_message.set_token('TABLE', 'HZ_ORIG_SYSTEMS_B');
780: fnd_msg_pub.add;
781: x_return_status := fnd_api.g_ret_sts_error;
782: END;
783:
842: ROLLBACK TO create_import_batch;
843:
844: x_return_status := fnd_api.g_ret_sts_unexp_error;
845:
846: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
847: fnd_message.set_token('ERROR', SQLERRM);
848: fnd_msg_pub.add;
849:
850: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
843:
844: x_return_status := fnd_api.g_ret_sts_unexp_error;
845:
846: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
847: fnd_message.set_token('ERROR', SQLERRM);
848: fnd_msg_pub.add;
849:
850: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
851: p_count => x_msg_count,