APPS.FEM_OBJECT_CATALOG_UTIL_PKG dependencies on FND_API

Line 9: pc_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;

5: ** Package constants
6: ** ***********************/
7: pc_pkg_name CONSTANT VARCHAR2(30) := 'fem_object_catalog_util_pkg';
8:
9: pc_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;
10: pc_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;
11: pc_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
12:
13: pc_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;

Line 10: pc_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;

6: ** ***********************/
7: pc_pkg_name CONSTANT VARCHAR2(30) := 'fem_object_catalog_util_pkg';
8:
9: pc_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;
10: pc_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;
11: pc_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
12:
13: pc_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
14: pc_last_update_login CONSTANT NUMBER := FND_GLOBAL.Login_Id;

Line 11: pc_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;

7: pc_pkg_name CONSTANT VARCHAR2(30) := 'fem_object_catalog_util_pkg';
8:
9: pc_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;
10: pc_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;
11: pc_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
12:
13: pc_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
14: pc_last_update_login CONSTANT NUMBER := FND_GLOBAL.Login_Id;
15: pc_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;

Line 102: IF NOT FND_API.Compatible_API_Call (c_api_version,

98: /* Standard Start of API savepoint */
99: SAVEPOINT create_object_pub;
100:
101: /* Standard call to check for call compatibility. */
102: IF NOT FND_API.Compatible_API_Call (c_api_version,
103: p_api_version,
104: c_api_name,
105: pc_pkg_name)
106: THEN

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

103: p_api_version,
104: c_api_name,
105: pc_pkg_name)
106: THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109:
110: /* Initialize API return status to success */
111: x_return_status := pc_ret_sts_success;

Line 216: p_commit => FND_API.G_FALSE,

212: WHEN dup_val_on_index THEN raise e_duplicate_obj_name;
213: END;
214:
215: create_object_definition (p_api_version => 1.0,
216: p_commit => FND_API.G_FALSE,
217: p_object_id => x_object_id,
218: p_effective_start_date => p_effective_start_date,
219: p_effective_end_date => p_effective_end_date,
220: p_obj_def_name => p_obj_def_name,

Line 232: IF FND_API.To_Boolean( p_commit ) THEN

228: IF x_return_status <> pc_ret_sts_success THEN
229: RAISE e_cannot_create_definition;
230: END IF;
231:
232: IF FND_API.To_Boolean( p_commit ) THEN
233: COMMIT WORK;
234: END IF;
235:
236: fem_engines_pkg.put_message(p_app_name =>'FEM',

Line 360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

356: FND_MSG_PUB.Count_And_Get
357: (p_count => x_msg_count,
358: p_data => x_msg_data);
359:
360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361: ROLLBACK TO create_object_pub;
362: x_return_status := pc_ret_sts_unexp_error;
363:
364: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

Line 451: IF NOT FND_API.Compatible_API_Call (c_api_version,

447: /* Standard Start of API savepoint */
448: SAVEPOINT create_object_definition_pub;
449:
450: /* Standard call to check for call compatibility. */
451: IF NOT FND_API.Compatible_API_Call (c_api_version,
452: p_api_version,
453: c_api_name,
454: pc_pkg_name)
455: THEN

Line 456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

452: p_api_version,
453: c_api_name,
454: pc_pkg_name)
455: THEN
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: END IF;
458:
459: -- Initialize API return status to success
460: x_return_status := pc_ret_sts_success;

Line 551: IF FND_API.To_Boolean( p_commit ) THEN

547: RAISE e_invalid_effective_date_range;
548:
549: END IF;
550:
551: IF FND_API.To_Boolean( p_commit ) THEN
552: COMMIT WORK;
553: END IF;
554:
555: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,

Line 596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

592: FND_MSG_PUB.Count_And_Get
593: (p_count => x_msg_count,
594: p_data => x_msg_data);
595:
596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
597: ROLLBACK TO create_object_definition_pub;
598: x_return_status := pc_ret_sts_unexp_error;
599:
600: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

Line 751: IF NOT FND_API.Compatible_API_Call (c_api_version,

747: /* Standard Start of API savepoint */
748: SAVEPOINT delete_object_pub;
749:
750: /* Standard call to check for call compatibility. */
751: IF NOT FND_API.Compatible_API_Call (c_api_version,
752: p_api_version,
753: c_api_name,
754: pc_pkg_name)
755: THEN

Line 756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

752: p_api_version,
753: c_api_name,
754: pc_pkg_name)
755: THEN
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: END IF;
758:
759: /* Initialize API return status to success */
760: x_return_status := pc_ret_sts_success;

Line 829: IF FND_API.To_Boolean( p_commit ) THEN

825: RAISE e_cannot_delete_object;
826:
827: END IF;
828:
829: IF FND_API.To_Boolean( p_commit ) THEN
830: COMMIT WORK;
831: END IF;
832:
833: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,

Line 861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

857: FND_MSG_PUB.Count_And_Get
858: (p_count => x_msg_count,
859: p_data => x_msg_data);
860:
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: ROLLBACK TO delete_object_pub;
863: x_return_status := pc_ret_sts_unexp_error;
864:
865: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,