APPS.CSP_PC_FORM_PICKHEADERS dependencies on FND_LOOKUPS

Line 143: from fnd_lookups

139: RAISE EXCP_USER_DEFINED;
140: ELSE
141: BEGIN
142: select distinct lookup_code into l_check_var
143: from fnd_lookups
144: where lookup_type = 'CSP_PICKLIST_STATUS'
145: and lookup_code = p_PICKLIST_STATUS;
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN

Line 156: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);

152: WHEN OTHERS THEN
153: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
154: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
155: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
156: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
157: FND_MSG_PUB.ADD;
158: RAISE EXCP_USER_DEFINED;
159: END;
160: END IF;

Line 244: from fnd_lookups

240: -- Validate the status against the lookup codes.
241: IF nvl(p_PICKLIST_STATUS, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
242: BEGIN
243: select distinct lookup_code into l_check_var
244: from fnd_lookups
245: where lookup_type = 'CSP_PICKLIST_STATUS'
246: and lookup_code = p_PICKLIST_STATUS;
247: EXCEPTION
248: WHEN NO_DATA_FOUND THEN

Line 257: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);

253: WHEN OTHERS THEN
254: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
255: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
256: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
257: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
258: FND_MSG_PUB.ADD;
259: RAISE EXCP_USER_DEFINED;
260: END;
261: END IF;