APPS.FEM_FOLDERS_UTL_PKG dependencies on FND_API

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

5: -- Package constants
6: -- ***********************
7: g_pkg_name CONSTANT VARCHAR2(30) := 'fem_folders_utl_pkg';
8:
9: g_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;
10: g_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;
11: g_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
12:
13: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;

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

6: -- ***********************
7: g_pkg_name CONSTANT VARCHAR2(30) := 'fem_folders_utl_pkg';
8:
9: g_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;
10: g_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;
11: g_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
12:
13: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
14:

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

7: g_pkg_name CONSTANT VARCHAR2(30) := 'fem_folders_utl_pkg';
8:
9: g_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;
10: g_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;
11: g_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
12:
13: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
14:
15: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;

Line 90: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

86: END get_personal_folder;
87:
88: -- ******************************************************************************
89: PROCEDURE assign_user_to_folder (p_api_version IN NUMBER,
90: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: p_user_id IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
92: p_folder_id IN NUMBER,
93: p_write_flag IN VARCHAR2 DEFAULT 'N',
94: x_msg_count OUT NOCOPY NUMBER,

Line 117: IF NOT FND_API.Compatible_API_Call (l_api_version,

113: -- Standard Start of API savepoint
114: SAVEPOINT assign_user_to_folder_pub;
115:
116: -- Standard call to check for call compatibility.
117: IF NOT FND_API.Compatible_API_Call (l_api_version,
118: p_api_version,
119: l_api_name,
120: g_pkg_name)
121: THEN

Line 122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

118: p_api_version,
119: l_api_name,
120: g_pkg_name)
121: THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: -- Initialize API return status to success
126: x_return_status := G_RET_STS_SUCCESS;

Line 140: IF FND_API.To_Boolean( p_commit ) THEN

136: sysdate, v_last_update_login
137: FROM fem_folders_vl
138: WHERE folder_id = p_folder_id;
139:
140: IF FND_API.To_Boolean( p_commit ) THEN
141: COMMIT WORK;
142: END IF;
143:
144: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

Line 181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

177: fem_engines_pkg.tech_message(p_severity => c_log_level_3,
178: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
179: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
180:
181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
182: ROLLBACK TO assign_user_to_folder_pub;
183: x_return_status := g_ret_sts_unexp_error;
184:
185: fem_engines_pkg.tech_message(p_severity => c_log_level_2,