DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_PUB dependencies on FND_LOOKUPS

Line 4011: p_object_code IN fnd_lookups.lookup_code%TYPE,

4007: | NOTES:
4008: |
4009: *---------------------------------------------------------------------*/
4010: PROCEDURE retrieveErrorMSG (
4011: p_object_code IN fnd_lookups.lookup_code%TYPE,
4012: p_msg_name IN fnd_new_messages.message_name%TYPE,
4013: p_message IN OUT NOCOPY fnd_new_messages.message_text%TYPE
4014: ) IS
4015:

Line 4016: l_msg_token fnd_lookups.meaning%TYPE;

4012: p_msg_name IN fnd_new_messages.message_name%TYPE,
4013: p_message IN OUT NOCOPY fnd_new_messages.message_text%TYPE
4014: ) IS
4015:
4016: l_msg_token fnd_lookups.meaning%TYPE;
4017:
4018: BEGIN
4019:
4020: -- Retrieve the message token

Line 4023: FROM fnd_lookups

4019:
4020: -- Retrieve the message token
4021: SELECT meaning
4022: INTO l_msg_token
4023: FROM fnd_lookups
4024: WHERE lookup_type = 'IBY_VALIDATION_FIELDS'
4025: AND lookup_code = p_object_code;
4026:
4027: FND_MESSAGE.SET_NAME('IBY', p_msg_name);

Line 4286: from fnd_lookups

4282: END IF;
4283: ELSIF (p_token = 'INLOOKUPTYPE') THEN
4284: select count(*)
4285: into l_lookup_code_cnt
4286: from fnd_lookups
4287: where lookup_type = p_char_value
4288: and lookup_code = p_fieldValue;
4289:
4290: IF l_lookup_code_cnt = 0 THEN