15: IF p_object_type IS NULL THEN
16: /* object type is invalid */
17: FND_MESSAGE.SET_NAME('IMC', g_invalid_object_type);
18: FND_MSG_PUB.ADD;
19: RAISE FND_API.G_EXC_ERROR;
20: END IF;
21:
22: SELECT 1
23: INTO l_dummy
30: EXCEPTION
31: WHEN NO_DATA_FOUND THEN
32: RETURN 'N';
33:
34: WHEN FND_API.G_EXC_ERROR THEN
35: RETURN FND_API.G_RET_STS_ERROR;
36:
37: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
38: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
31: WHEN NO_DATA_FOUND THEN
32: RETURN 'N';
33:
34: WHEN FND_API.G_EXC_ERROR THEN
35: RETURN FND_API.G_RET_STS_ERROR;
36:
37: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
38: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
39:
33:
34: WHEN FND_API.G_EXC_ERROR THEN
35: RETURN FND_API.G_RET_STS_ERROR;
36:
37: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
38: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
39:
40: WHEN OTHERS THEN
41: FND_MESSAGE.SET_NAME('IMC', g_metadata_api_others_ex);
34: WHEN FND_API.G_EXC_ERROR THEN
35: RETURN FND_API.G_RET_STS_ERROR;
36:
37: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
38: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
39:
40: WHEN OTHERS THEN
41: FND_MESSAGE.SET_NAME('IMC', g_metadata_api_others_ex);
42: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
40: WHEN OTHERS THEN
41: FND_MESSAGE.SET_NAME('IMC', g_metadata_api_others_ex);
42: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
43: FND_MSG_PUB.ADD;
44: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
45:
46: END Object_Metadata_Exists;
47:
48: /*=======================================================================*/
72: DESCRIPTION = p_description,
73: FUNCTION_NAME = p_function_name,
74: PARAMETER_NAME = p_parameter_name,
75: ENABLED = p_enabled,
76: APPLICATION_ID = DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
77: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
78: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
79: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
80: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
73: FUNCTION_NAME = p_function_name,
74: PARAMETER_NAME = p_parameter_name,
75: ENABLED = p_enabled,
76: APPLICATION_ID = DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
77: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
78: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
79: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
80: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
81: ADDITIONAL_VALUE5 = DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
74: PARAMETER_NAME = p_parameter_name,
75: ENABLED = p_enabled,
76: APPLICATION_ID = DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
77: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
78: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
79: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
80: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
81: ADDITIONAL_VALUE5 = DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
82: CREATED_BY = p_created_by,
75: ENABLED = p_enabled,
76: APPLICATION_ID = DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
77: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
78: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
79: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
80: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
81: ADDITIONAL_VALUE5 = DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
82: CREATED_BY = p_created_by,
83: CREATION_DATE = p_creation_date,
76: APPLICATION_ID = DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
77: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
78: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
79: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
80: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
81: ADDITIONAL_VALUE5 = DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
82: CREATED_BY = p_created_by,
83: CREATION_DATE = p_creation_date,
84: LAST_UPDATED_BY = p_last_updated_by,
77: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
78: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
79: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
80: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
81: ADDITIONAL_VALUE5 = DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
82: CREATED_BY = p_created_by,
83: CREATION_DATE = p_creation_date,
84: LAST_UPDATED_BY = p_last_updated_by,
85: LAST_UPDATE_DATE = p_last_update_date,
142: p_description,
143: p_function_name,
144: p_parameter_name,
145: p_enabled,
146: DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
147: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
148: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
149: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
150: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
143: p_function_name,
144: p_parameter_name,
145: p_enabled,
146: DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
147: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
148: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
149: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
150: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
151: DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
144: p_parameter_name,
145: p_enabled,
146: DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
147: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
148: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
149: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
150: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
151: DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
152: p_created_by,
145: p_enabled,
146: DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
147: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
148: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
149: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
150: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
151: DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
152: p_created_by,
153: p_creation_date,
146: DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
147: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
148: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
149: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
150: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
151: DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
152: p_created_by,
153: p_creation_date,
154: p_last_updated_by,
147: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
148: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
149: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
150: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
151: DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
152: p_created_by,
153: p_creation_date,
154: p_last_updated_by,
155: p_last_update_date,
234: l_last_update_login /* Last update login */
235: );
236: END IF;
237:
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239:
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: x_return_status := FND_API.G_RET_STS_ERROR;
237:
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239:
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239:
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: FND_MSG_PUB.Count_And_Get (
251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,
245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: FND_MSG_PUB.Count_And_Get (
251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,
253: p_data => x_msg_data
247: );
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: FND_MSG_PUB.Count_And_Get (
251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,
253: p_data => x_msg_data
254: );
255: WHEN OTHERS THEN
252: p_count => x_msg_count,
253: p_data => x_msg_data
254: );
255: WHEN OTHERS THEN
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: FND_MSG_PUB.Count_And_Get (
258: p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data
254: );
255: WHEN OTHERS THEN
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: FND_MSG_PUB.Count_And_Get (
258: p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data
261: );
262:
279: IF SQL%NOTFOUND THEN
280: RAISE NO_DATA_FOUND;
281: END IF;
282:
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284:
285: EXCEPTION
286: WHEN NO_DATA_FOUND THEN
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284:
285: EXCEPTION
286: WHEN NO_DATA_FOUND THEN
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288: FND_MESSAGE.SET_NAME('IMC', g_no_metadata_for_obj_type);
289: FND_MSG_PUB.ADD;
290: FND_MSG_PUB.Count_And_Get (
291: p_encoded => FND_API.G_FALSE,
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288: FND_MESSAGE.SET_NAME('IMC', g_no_metadata_for_obj_type);
289: FND_MSG_PUB.ADD;
290: FND_MSG_PUB.Count_And_Get (
291: p_encoded => FND_API.G_FALSE,
292: p_count => x_msg_count,
293: p_data => x_msg_data
294: );
295: WHEN OTHERS THEN
292: p_count => x_msg_count,
293: p_data => x_msg_data
294: );
295: WHEN OTHERS THEN
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: FND_MSG_PUB.Count_And_Get (
298: p_encoded => FND_API.G_FALSE,
299: p_count => x_msg_count,
300: p_data => x_msg_data
294: );
295: WHEN OTHERS THEN
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: FND_MSG_PUB.Count_And_Get (
298: p_encoded => FND_API.G_FALSE,
299: p_count => x_msg_count,
300: p_data => x_msg_data
301: );
302:
330: IF x_metadata_info%NOTFOUND THEN
331: RAISE NO_DATA_FOUND;
332: END IF;
333:
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335:
336: EXCEPTION
337: WHEN NO_DATA_FOUND THEN
338: x_return_status := FND_API.G_RET_STS_ERROR;
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335:
336: EXCEPTION
337: WHEN NO_DATA_FOUND THEN
338: x_return_status := FND_API.G_RET_STS_ERROR;
339: FND_MESSAGE.SET_NAME('IMC', g_no_metadata_for_obj_type);
340: FND_MSG_PUB.ADD;
341: FND_MSG_PUB.Count_And_Get (
342: p_encoded => FND_API.G_FALSE,
338: x_return_status := FND_API.G_RET_STS_ERROR;
339: FND_MESSAGE.SET_NAME('IMC', g_no_metadata_for_obj_type);
340: FND_MSG_PUB.ADD;
341: FND_MSG_PUB.Count_And_Get (
342: p_encoded => FND_API.G_FALSE,
343: p_count => x_msg_count,
344: p_data => x_msg_data
345: );
346: WHEN FND_API.G_EXC_ERROR THEN
342: p_encoded => FND_API.G_FALSE,
343: p_count => x_msg_count,
344: p_data => x_msg_data
345: );
346: WHEN FND_API.G_EXC_ERROR THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
343: p_count => x_msg_count,
344: p_data => x_msg_data
345: );
346: WHEN FND_API.G_EXC_ERROR THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
345: );
346: WHEN FND_API.G_EXC_ERROR THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: FND_MSG_PUB.Count_And_Get (
356: p_encoded => FND_API.G_FALSE,
357: p_count => x_msg_count,
350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: FND_MSG_PUB.Count_And_Get (
356: p_encoded => FND_API.G_FALSE,
357: p_count => x_msg_count,
358: p_data => x_msg_data
352: );
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: FND_MSG_PUB.Count_And_Get (
356: p_encoded => FND_API.G_FALSE,
357: p_count => x_msg_count,
358: p_data => x_msg_data
359: );
360: WHEN OTHERS THEN
357: p_count => x_msg_count,
358: p_data => x_msg_data
359: );
360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: FND_MSG_PUB.Count_And_Get (
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_msg_count,
365: p_data => x_msg_data
359: );
360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: FND_MSG_PUB.Count_And_Get (
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_msg_count,
365: p_data => x_msg_data
366: );
367: