APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_ORIG_SYSTEMS_B

Line 857: -- Bug 4079902. Validated orig_system against HZ_ORIG_SYSTEMS_B instead of

853: ---------------------
854:
855: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Validating the batch');
856:
857: -- Bug 4079902. Validated orig_system against HZ_ORIG_SYSTEMS_B instead of
858: -- the lookup.
859:
860: -- validate original_system against lookup ORIG_SYSTEM
861: /*

Line 870: FROM hz_orig_systems_b

866: x_return_status => l_return_status);
867: */
868: BEGIN
869: SELECT 'Y' INTO os_exists_flag
870: FROM hz_orig_systems_b
871: WHERE
872: orig_system= r_batch_info.original_system
873: AND orig_system<>'SST'
874: AND status='A';

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

876: WHEN NO_DATA_FOUND THEN
877: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');
878: FND_MESSAGE.SET_TOKEN('FK','orig_system');
879: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
880: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');
881:
882: -- Bug 4530477
883: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error***** '||FND_MESSAGE.GET);
884: