DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_PUB dependencies on FND_LOOKUPS

Line 3934: p_object_code IN fnd_lookups.lookup_code%TYPE,

3930: | NOTES:
3931: |
3932: *---------------------------------------------------------------------*/
3933: PROCEDURE retrieveErrorMSG (
3934: p_object_code IN fnd_lookups.lookup_code%TYPE,
3935: p_msg_name IN fnd_new_messages.message_name%TYPE,
3936: p_message IN OUT NOCOPY fnd_new_messages.message_text%TYPE
3937: ) IS
3938:

Line 3939: l_msg_token fnd_lookups.meaning%TYPE;

3935: p_msg_name IN fnd_new_messages.message_name%TYPE,
3936: p_message IN OUT NOCOPY fnd_new_messages.message_text%TYPE
3937: ) IS
3938:
3939: l_msg_token fnd_lookups.meaning%TYPE;
3940:
3941: BEGIN
3942:
3943: -- Retrieve the message token

Line 3946: FROM fnd_lookups

3942:
3943: -- Retrieve the message token
3944: SELECT meaning
3945: INTO l_msg_token
3946: FROM fnd_lookups
3947: WHERE lookup_type = 'IBY_VALIDATION_FIELDS'
3948: AND lookup_code = p_object_code;
3949:
3950: FND_MESSAGE.SET_NAME('IBY', p_msg_name);

Line 4205: from fnd_lookups

4201: END IF;
4202: ELSIF (p_token = 'INLOOKUPTYPE') THEN
4203: select count(*)
4204: into l_lookup_code_cnt
4205: from fnd_lookups
4206: where lookup_type = p_char_value
4207: and lookup_code = p_fieldValue;
4208:
4209: IF l_lookup_code_cnt = 0 THEN