APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_ORIG_SYSTEMS_B

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

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

Line 872: FROM hz_orig_systems_b

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

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

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