DBA Data[Home] [Help]

APPS.AMW_OBJECT_ASSESSMENTS_PVT dependencies on FND_API

Line 39: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

35:
36: PROCEDURE create_object_assessment
37: (
38: p_api_version_number IN NUMBER := 1.0,
39: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
40: p_commit IN VARCHAR2 := FND_API.g_false,
41: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
42: p_object_type IN VARCHAR2,
43: p_assessment_id IN NUMBER,

Line 40: p_commit IN VARCHAR2 := FND_API.g_false,

36: PROCEDURE create_object_assessment
37: (
38: p_api_version_number IN NUMBER := 1.0,
39: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
40: p_commit IN VARCHAR2 := FND_API.g_false,
41: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
42: p_object_type IN VARCHAR2,
43: p_assessment_id IN NUMBER,
44: p_certification_id IN NUMBER,

Line 41: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

37: (
38: p_api_version_number IN NUMBER := 1.0,
39: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
40: p_commit IN VARCHAR2 := FND_API.g_false,
41: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
42: p_object_type IN VARCHAR2,
43: p_assessment_id IN NUMBER,
44: p_certification_id IN NUMBER,
45: p_org_id IN NUMBER,

Line 65: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

61:
62: SAVEPOINT CREATE_OBJECT;
63:
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
66: p_api_version_number,
67: l_api_name,
68: G_PKG_NAME)
69: THEN

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

66: p_api_version_number,
67: l_api_name,
68: G_PKG_NAME)
69: THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list )

Line 74: IF FND_API.to_Boolean( p_init_msg_list )

70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list )
75: THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Initialize API return status to SUCCESS
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: IF p_object_type = 'PROCESS'
83: THEN
84:

Line 129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

125: END IF;
126:
127: EXCEPTION WHEN OTHERS THEN
128: ROLLBACK TO CREATE_OBJECT;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130:
131: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
132: FND_MSG_PUB.Count_And_Get(
133: p_encoded => FND_API.G_FALSE,

Line 133: p_encoded => FND_API.G_FALSE,

129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130:
131: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
132: FND_MSG_PUB.Count_And_Get(
133: p_encoded => FND_API.G_FALSE,
134: p_count => x_msg_count,
135: p_data => x_msg_data);
136:
137:

Line 144: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

140:
141: PROCEDURE update_object_assessment
142: (
143: p_api_version_number IN NUMBER := 1.0,
144: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
145: p_commit IN VARCHAR2 := FND_API.g_false,
146: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
147: p_object_type IN VARCHAR2,
148: p_assessment_id IN NUMBER,

Line 145: p_commit IN VARCHAR2 := FND_API.g_false,

141: PROCEDURE update_object_assessment
142: (
143: p_api_version_number IN NUMBER := 1.0,
144: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
145: p_commit IN VARCHAR2 := FND_API.g_false,
146: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
147: p_object_type IN VARCHAR2,
148: p_assessment_id IN NUMBER,
149: p_certification_id IN NUMBER,

Line 146: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

142: (
143: p_api_version_number IN NUMBER := 1.0,
144: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
145: p_commit IN VARCHAR2 := FND_API.g_false,
146: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
147: p_object_type IN VARCHAR2,
148: p_assessment_id IN NUMBER,
149: p_certification_id IN NUMBER,
150: p_org_id IN NUMBER,

Line 170: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

166:
167: SAVEPOINT UPDATE_OBJECT;
168:
169: -- Standard call to check for call compatibility.
170: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
171: p_api_version_number,
172: l_api_name,
173: G_PKG_NAME)
174: THEN

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: p_api_version_number,
172: l_api_name,
173: G_PKG_NAME)
174: THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: -- Initialize message list if p_init_msg_list is set to TRUE.
179: IF FND_API.to_Boolean( p_init_msg_list )

Line 179: IF FND_API.to_Boolean( p_init_msg_list )

175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: -- Initialize message list if p_init_msg_list is set to TRUE.
179: IF FND_API.to_Boolean( p_init_msg_list )
180: THEN
181: FND_MSG_PUB.initialize;
182: END IF;
183:

Line 185: x_return_status := FND_API.G_RET_STS_SUCCESS;

181: FND_MSG_PUB.initialize;
182: END IF;
183:
184: -- Initialize API return status to SUCCESS
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186:
187: IF p_object_type = 'PROCESS'
188: THEN
189: UPDATE amw_object_assessments apa

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

195: END IF;
196:
197: EXCEPTION WHEN OTHERS THEN
198: ROLLBACK TO UPDATE_OBJECT;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200:
201: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
202: FND_MSG_PUB.Count_And_Get(
203: p_encoded => FND_API.G_FALSE,

Line 203: p_encoded => FND_API.G_FALSE,

199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200:
201: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
202: FND_MSG_PUB.Count_And_Get(
203: p_encoded => FND_API.G_FALSE,
204: p_count => x_msg_count,
205: p_data => x_msg_data);
206:
207:

Line 213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

209:
210: PROCEDURE remove_object_assessment
211: (
212: p_api_version_number IN NUMBER := 1.0,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
216: p_object_type IN VARCHAR2,
217: p_assessment_id IN NUMBER,

Line 214: p_commit IN VARCHAR2 := FND_API.g_false,

210: PROCEDURE remove_object_assessment
211: (
212: p_api_version_number IN NUMBER := 1.0,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
216: p_object_type IN VARCHAR2,
217: p_assessment_id IN NUMBER,
218: p_certification_id IN NUMBER,

Line 215: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

211: (
212: p_api_version_number IN NUMBER := 1.0,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
216: p_object_type IN VARCHAR2,
217: p_assessment_id IN NUMBER,
218: p_certification_id IN NUMBER,
219: p_org_id IN NUMBER,

Line 238: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

234: BEGIN
235: SAVEPOINT REMOVE_OBJECT;
236:
237: -- Standard call to check for call compatibility.
238: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
239: p_api_version_number,
240: l_api_name,
241: G_PKG_NAME)
242: THEN

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239: p_api_version_number,
240: l_api_name,
241: G_PKG_NAME)
242: THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- Initialize message list if p_init_msg_list is set to TRUE.
247: IF FND_API.to_Boolean( p_init_msg_list )

Line 247: IF FND_API.to_Boolean( p_init_msg_list )

243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- Initialize message list if p_init_msg_list is set to TRUE.
247: IF FND_API.to_Boolean( p_init_msg_list )
248: THEN
249: FND_MSG_PUB.initialize;
250: END IF;
251:

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: FND_MSG_PUB.initialize;
250: END IF;
251:
252: -- Initialize API return status to SUCCESS
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: IF p_object_type = 'PROCESS'
256: THEN
257: DELETE FROM amw_object_assessments apa

Line 266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

262: END IF;
263:
264: EXCEPTION WHEN OTHERS THEN
265: ROLLBACK TO REMOVE_OBJECT;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267:
268: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
269: FND_MSG_PUB.Count_And_Get(
270: p_encoded => FND_API.G_FALSE,

Line 270: p_encoded => FND_API.G_FALSE,

266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267:
268: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
269: FND_MSG_PUB.Count_And_Get(
270: p_encoded => FND_API.G_FALSE,
271: p_count => x_msg_count,
272: p_data => x_msg_data);
273:
274: END remove_object_assessment;