APPS.HZ_MOSR_VALIDATE_PKG dependencies on HZ_ORIG_SYSTEMS_B

Line 125: -- Cursor to validate orig_system against table hz_orig_systems_b

121: group by owner_table_id
122: having count(1) > 1;
123:
124: -- SST SSM Integration and Extension
125: -- Cursor to validate orig_system against table hz_orig_systems_b
126: cursor orig_system_exist is
127: select 'Y'
128: from hz_orig_systems_b
129: where orig_system = p_orig_sys_entity_map_rec.orig_system

Line 128: from hz_orig_systems_b

124: -- SST SSM Integration and Extension
125: -- Cursor to validate orig_system against table hz_orig_systems_b
126: cursor orig_system_exist is
127: select 'Y'
128: from hz_orig_systems_b
129: where orig_system = p_orig_sys_entity_map_rec.orig_system
130: /* and status= 'A'*/;
131: l_orig_sys VARCHAR2(1);
132:

Line 164: -- table HZ_ORIG_SYSTEMS_B instead of lookup ORIG_SYSTEM

160: end if;
161:
162: -- SST SSM Integration and Extension
163: -- Validate p_orig_sys_entity_map_rec.orig_system against
164: -- table HZ_ORIG_SYSTEMS_B instead of lookup ORIG_SYSTEM
165: /*
166: HZ_UTILITY_V2PUB.validate_lookup (
167: p_column => 'orig_system',
168: p_lookup_type => 'ORIG_SYSTEM',

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

174: if orig_system_exist%notfound then
175: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
176: FND_MESSAGE.SET_TOKEN('FK','orig_system');
177: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
178: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');
179: FND_MSG_PUB.ADD;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: end if;
182:

Line 363: FROM HZ_ORIG_SYSTEMS_B

359:
360: -- SSM SST Integration and Extension
361: CURSOR c_active_orig_system_exists IS
362: SELECT 'Y'
363: FROM HZ_ORIG_SYSTEMS_B
364: WHERE orig_system = p_orig_sys_reference_rec.orig_system
365: AND status = 'A';
366: l_temp VARCHAR2(1);
367:

Line 387: -- HZ_ORIG_SYSTEMS_B and owner_table_name is a valid value from lookup TCA_OWNER_TABLE.

383:
384: -- SSM SST Integration and Extension
385: -- Instead of checking if the combination of orig_system and owner_table_name
386: -- exists in HZ_ORIG_SYS_MAPPING, check if the orig_system is a valid value from
387: -- HZ_ORIG_SYSTEMS_B and owner_table_name is a valid value from lookup TCA_OWNER_TABLE.
388: -- If these validations are satisfied, then an record will be there in HZ_ORIG_SYS_MAPPING
389: -- anyway.
390: -- Logic behind this change: The status field in HZ_ORIG_SYS_MAPPING should not be considered.
391: -- However the status in HZ_ORIG_SYSTEMS_B has to be checked.

Line 391: -- However the status in HZ_ORIG_SYSTEMS_B has to be checked.

387: -- HZ_ORIG_SYSTEMS_B and owner_table_name is a valid value from lookup TCA_OWNER_TABLE.
388: -- If these validations are satisfied, then an record will be there in HZ_ORIG_SYS_MAPPING
389: -- anyway.
390: -- Logic behind this change: The status field in HZ_ORIG_SYS_MAPPING should not be considered.
391: -- However the status in HZ_ORIG_SYSTEMS_B has to be checked.
392:
393: /* -- Make sure passing in orig_system and owner_table_name are validate
394: if orig_sys_entity_map_exist(p_orig_sys_reference_rec.orig_system,
395: p_orig_sys_reference_rec.owner_table_name/*,'A'*//*) = 'N'

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

409: IF c_active_orig_system_exists%notFOUND THEN
410: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');
411: FND_MESSAGE.SET_TOKEN('FK','orig_system');
412: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
413: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');
414: FND_MSG_PUB.ADD;
415: -- Bug 5104024
416: x_return_status := fnd_api.g_ret_sts_error;
417: END IF;

Line 948: from hz_orig_systems_b

944: select sst_flag,
945: created_by_module,
946: orig_system,
947: orig_system_type
948: from hz_orig_systems_b
949: where orig_system = p_orig_sys_rec.orig_system;
950:
951: l_sst_flag VARCHAR2(1);
952: l_created_by_module VARCHAR2(150);