eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AST_WRAPUP_ADM_PVT dependencies on FND_API

Line 14: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
12: PROCEDURE INSERT_OUTCOME(
13: P_API_VERSION IN NUMBER,
14: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
15: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
16: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: X_RETURN_STATUS OUT VARCHAR2,
18: X_MSG_COUNT OUT NUMBER,

Line 15: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

11:
12: PROCEDURE INSERT_OUTCOME(
13: P_API_VERSION IN NUMBER,
14: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
15: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
16: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: X_RETURN_STATUS OUT VARCHAR2,
18: X_MSG_COUNT OUT NUMBER,
19: X_MSG_DATA OUT VARCHAR2,

Line 16: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

12: PROCEDURE INSERT_OUTCOME(
13: P_API_VERSION IN NUMBER,
14: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
15: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
16: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: X_RETURN_STATUS OUT VARCHAR2,
18: X_MSG_COUNT OUT NUMBER,
19: X_MSG_DATA OUT VARCHAR2,
20: P_RESULT_REQUIRED IN VARCHAR2,

Line 65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

61: -- Standard start of API savepoint
62: SAVEPOINT INSERT_OUTCOME_PVT;
63:
64: -- Standard call to check for call compatibility
65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE

Line 66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

62: SAVEPOINT INSERT_OUTCOME_PVT;
63:
64: -- Standard call to check for call compatibility
65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE
70: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 70: IF FND_API.To_Boolean(p_init_msg_list) THEN

66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE
70: IF FND_API.To_Boolean(p_init_msg_list) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: -- Initialize API return status to success

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: -- Initialize API return status to success
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: -- API body
78:
79: -- get new outcome id

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

119: OPEN l_insert_tl_check_csr;
120: FETCH l_insert_tl_check_csr INTO l_dummy;
121: IF (l_insert_tl_check_csr%notfound) THEN
122: CLOSE l_insert_tl_check_csr;
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;
125: CLOSE l_insert_tl_check_csr;
126:
127: -- insert new outcome into JTF_IH_OUTCOMES_B

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162: OPEN l_insert_b_check_csr;
163: FETCH l_insert_b_check_csr INTO l_dummy;
164: IF (l_insert_b_check_csr%notfound) THEN
165: CLOSE l_insert_b_check_csr;
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168: CLOSE l_insert_b_check_csr;
169:
170: X_OUTCOME_ID := L_OUTCOME_ID;

Line 174: IF FND_API.To_Boolean(p_commit) THEN

170: X_OUTCOME_ID := L_OUTCOME_ID;
171: -- End of API body
172:
173: -- Standard check of p_commit
174: IF FND_API.To_Boolean(p_commit) THEN
175: COMMIT WORK;
176: END IF;
177:
178: -- Standard call to get message count and if count is 1, get message info

Line 182: WHEN FND_API.G_EXC_ERROR THEN

178: -- Standard call to get message count and if count is 1, get message info
179: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
180:
181: EXCEPTION
182: WHEN FND_API.G_EXC_ERROR THEN
183: ROLLBACK TO INSERT_OUTCOME_PVT;
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
186:

Line 184: x_return_status := FND_API.G_RET_STS_ERROR;

180:
181: EXCEPTION
182: WHEN FND_API.G_EXC_ERROR THEN
183: ROLLBACK TO INSERT_OUTCOME_PVT;
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO INSERT_OUTCOME_PVT;

Line 187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

183: ROLLBACK TO INSERT_OUTCOME_PVT;
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO INSERT_OUTCOME_PVT;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
191:

Line 189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO INSERT_OUTCOME_PVT;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
191:
192: WHEN OTHERS THEN
193: ROLLBACK TO INSERT_OUTCOME_PVT;

Line 194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

190: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
191:
192: WHEN OTHERS THEN
193: ROLLBACK TO INSERT_OUTCOME_PVT;
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
196: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
197: END IF;
198: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 204: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

200: END INSERT_OUTCOME;
201:
202: PROCEDURE UPDATE_OUTCOME(
203: P_API_VERSION IN NUMBER,
204: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
205: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
206: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207: X_RETURN_STATUS OUT VARCHAR2,
208: X_MSG_COUNT OUT NUMBER,

Line 205: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

201:
202: PROCEDURE UPDATE_OUTCOME(
203: P_API_VERSION IN NUMBER,
204: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
205: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
206: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207: X_RETURN_STATUS OUT VARCHAR2,
208: X_MSG_COUNT OUT NUMBER,
209: X_MSG_DATA OUT VARCHAR2,

Line 206: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

202: PROCEDURE UPDATE_OUTCOME(
203: P_API_VERSION IN NUMBER,
204: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
205: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
206: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207: X_RETURN_STATUS OUT VARCHAR2,
208: X_MSG_COUNT OUT NUMBER,
209: X_MSG_DATA OUT VARCHAR2,
210: P_OUTCOME_ID IN NUMBER,

Line 235: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

231: -- Standard start of API savepoint
232: SAVEPOINT UPDATE_OUTCOME_PVT;
233:
234: -- Standard call to check for call compatibility
235: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: -- Initialize message list if p_init_msg_list is set to TRUE

Line 236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

232: SAVEPOINT UPDATE_OUTCOME_PVT;
233:
234: -- Standard call to check for call compatibility
235: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: -- Initialize message list if p_init_msg_list is set to TRUE
240: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 240: IF FND_API.To_Boolean(p_init_msg_list) THEN

236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: -- Initialize message list if p_init_msg_list is set to TRUE
240: IF FND_API.To_Boolean(p_init_msg_list) THEN
241: FND_MSG_PUB.initialize;
242: END IF;
243:
244: -- Initialize API return status to success

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: FND_MSG_PUB.initialize;
242: END IF;
243:
244: -- Initialize API return status to success
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: -- API body
248:
249: -- update outcome in JTF_IH_OUTCOMES_TL

Line 283: IF FND_API.To_Boolean(p_commit) THEN

279:
280: -- End of API body
281:
282: -- Standard check of p_commit
283: IF FND_API.To_Boolean(p_commit) THEN
284: COMMIT WORK;
285: END IF;
286:
287: -- Standard call to get message count and if count is 1, get message info

Line 291: WHEN FND_API.G_EXC_ERROR THEN

287: -- Standard call to get message count and if count is 1, get message info
288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
289:
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
292: ROLLBACK TO UPDATE_OUTCOME_PVT;
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
295:

Line 293: x_return_status := FND_API.G_RET_STS_ERROR;

289:
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
292: ROLLBACK TO UPDATE_OUTCOME_PVT;
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: ROLLBACK TO UPDATE_OUTCOME_PVT;

Line 296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

292: ROLLBACK TO UPDATE_OUTCOME_PVT;
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: ROLLBACK TO UPDATE_OUTCOME_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
300:

Line 298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: ROLLBACK TO UPDATE_OUTCOME_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
300:
301: WHEN OTHERS THEN
302: ROLLBACK TO UPDATE_OUTCOME_PVT;

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
300:
301: WHEN OTHERS THEN
302: ROLLBACK TO UPDATE_OUTCOME_PVT;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
305: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
306: END IF;
307: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 313: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

309: END UPDATE_OUTCOME;
310:
311: PROCEDURE INSERT_RESULT(
312: P_API_VERSION IN NUMBER,
313: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
314: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
315: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
316: X_RETURN_STATUS OUT VARCHAR2,
317: X_MSG_COUNT OUT NUMBER,

Line 314: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

310:
311: PROCEDURE INSERT_RESULT(
312: P_API_VERSION IN NUMBER,
313: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
314: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
315: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
316: X_RETURN_STATUS OUT VARCHAR2,
317: X_MSG_COUNT OUT NUMBER,
318: X_MSG_DATA OUT VARCHAR2,

Line 315: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

311: PROCEDURE INSERT_RESULT(
312: P_API_VERSION IN NUMBER,
313: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
314: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
315: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
316: X_RETURN_STATUS OUT VARCHAR2,
317: X_MSG_COUNT OUT NUMBER,
318: X_MSG_DATA OUT VARCHAR2,
319: P_REASON_REQUIRED IN VARCHAR2,

Line 363: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

359: -- Standard start of API savepoint
360: SAVEPOINT INSERT_RESULT_PVT;
361:
362: -- Standard call to check for call compatibility
363: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: -- Initialize message list if p_init_msg_list is set to TRUE

Line 364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

360: SAVEPOINT INSERT_RESULT_PVT;
361:
362: -- Standard call to check for call compatibility
363: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: -- Initialize message list if p_init_msg_list is set to TRUE
368: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 368: IF FND_API.To_Boolean(p_init_msg_list) THEN

364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: -- Initialize message list if p_init_msg_list is set to TRUE
368: IF FND_API.To_Boolean(p_init_msg_list) THEN
369: FND_MSG_PUB.initialize;
370: END IF;
371:
372: -- Initialize API return status to success

Line 373: x_return_status := FND_API.G_RET_STS_SUCCESS;

369: FND_MSG_PUB.initialize;
370: END IF;
371:
372: -- Initialize API return status to success
373: x_return_status := FND_API.G_RET_STS_SUCCESS;
374:
375: -- API body
376:
377: -- get new RESULT id

Line 421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

417: OPEN l_insert_tl_check_csr;
418: FETCH l_insert_tl_check_csr INTO l_dummy;
419: IF (l_insert_tl_check_csr%notfound) THEN
420: CLOSE l_insert_tl_check_csr;
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423: CLOSE l_insert_tl_check_csr;
424:
425: -- insert new RESULT into JTF_IH_RESULTS_B

Line 462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

458: OPEN l_insert_b_check_csr;
459: FETCH l_insert_b_check_csr INTO l_dummy;
460: IF (l_insert_b_check_csr%notfound) THEN
461: CLOSE l_insert_b_check_csr;
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END IF;
464: CLOSE l_insert_b_check_csr;
465:
466: X_RESULT_ID := L_RESULT_ID;

Line 470: IF FND_API.To_Boolean(p_commit) THEN

466: X_RESULT_ID := L_RESULT_ID;
467: -- End of API body
468:
469: -- Standard check of p_commit
470: IF FND_API.To_Boolean(p_commit) THEN
471: COMMIT WORK;
472: END IF;
473:
474: -- Standard call to get message count and if count is 1, get message info

Line 478: WHEN FND_API.G_EXC_ERROR THEN

474: -- Standard call to get message count and if count is 1, get message info
475: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
476:
477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN
479: ROLLBACK TO INSERT_RESULT_PVT;
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:

Line 480: x_return_status := FND_API.G_RET_STS_ERROR;

476:
477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN
479: ROLLBACK TO INSERT_RESULT_PVT;
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO INSERT_RESULT_PVT;

Line 483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

479: ROLLBACK TO INSERT_RESULT_PVT;
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO INSERT_RESULT_PVT;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
487:

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO INSERT_RESULT_PVT;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
487:
488: WHEN OTHERS THEN
489: ROLLBACK TO INSERT_RESULT_PVT;

Line 490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
487:
488: WHEN OTHERS THEN
489: ROLLBACK TO INSERT_RESULT_PVT;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
492: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
493: END IF;
494: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 500: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

496: END INSERT_RESULT;
497:
498: PROCEDURE UPDATE_RESULT(
499: P_API_VERSION IN NUMBER,
500: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
501: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
502: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
503: X_RETURN_STATUS OUT VARCHAR2,
504: X_MSG_COUNT OUT NUMBER,

Line 501: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

497:
498: PROCEDURE UPDATE_RESULT(
499: P_API_VERSION IN NUMBER,
500: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
501: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
502: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
503: X_RETURN_STATUS OUT VARCHAR2,
504: X_MSG_COUNT OUT NUMBER,
505: X_MSG_DATA OUT VARCHAR2,

Line 502: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

498: PROCEDURE UPDATE_RESULT(
499: P_API_VERSION IN NUMBER,
500: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
501: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
502: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
503: X_RETURN_STATUS OUT VARCHAR2,
504: X_MSG_COUNT OUT NUMBER,
505: X_MSG_DATA OUT VARCHAR2,
506: P_RESULT_ID IN NUMBER,

Line 530: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

526: -- Standard start of API savepoint
527: SAVEPOINT UPDATE_RESULT_PVT;
528:
529: -- Standard call to check for call compatibility
530: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533:
534: -- Initialize message list if p_init_msg_list is set to TRUE

Line 531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

527: SAVEPOINT UPDATE_RESULT_PVT;
528:
529: -- Standard call to check for call compatibility
530: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533:
534: -- Initialize message list if p_init_msg_list is set to TRUE
535: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 535: IF FND_API.To_Boolean(p_init_msg_list) THEN

531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533:
534: -- Initialize message list if p_init_msg_list is set to TRUE
535: IF FND_API.To_Boolean(p_init_msg_list) THEN
536: FND_MSG_PUB.initialize;
537: END IF;
538:
539: -- Initialize API return status to success

Line 540: x_return_status := FND_API.G_RET_STS_SUCCESS;

536: FND_MSG_PUB.initialize;
537: END IF;
538:
539: -- Initialize API return status to success
540: x_return_status := FND_API.G_RET_STS_SUCCESS;
541:
542: -- API body
543:
544: -- update outcome in JTF_IH_RESULTS_TL

Line 577: IF FND_API.To_Boolean(p_commit) THEN

573:
574: -- End of API body
575:
576: -- Standard check of p_commit
577: IF FND_API.To_Boolean(p_commit) THEN
578: COMMIT WORK;
579: END IF;
580:
581: -- Standard call to get message count and if count is 1, get message info

Line 585: WHEN FND_API.G_EXC_ERROR THEN

581: -- Standard call to get message count and if count is 1, get message info
582: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
583:
584: EXCEPTION
585: WHEN FND_API.G_EXC_ERROR THEN
586: ROLLBACK TO UPDATE_RESULT_PVT;
587: x_return_status := FND_API.G_RET_STS_ERROR;
588: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
589:

Line 587: x_return_status := FND_API.G_RET_STS_ERROR;

583:
584: EXCEPTION
585: WHEN FND_API.G_EXC_ERROR THEN
586: ROLLBACK TO UPDATE_RESULT_PVT;
587: x_return_status := FND_API.G_RET_STS_ERROR;
588: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
589:
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
591: ROLLBACK TO UPDATE_RESULT_PVT;

Line 590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

586: ROLLBACK TO UPDATE_RESULT_PVT;
587: x_return_status := FND_API.G_RET_STS_ERROR;
588: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
589:
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
591: ROLLBACK TO UPDATE_RESULT_PVT;
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
594:

Line 592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

588: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
589:
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
591: ROLLBACK TO UPDATE_RESULT_PVT;
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
594:
595: WHEN OTHERS THEN
596: ROLLBACK TO UPDATE_RESULT_PVT;

Line 597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

593: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
594:
595: WHEN OTHERS THEN
596: ROLLBACK TO UPDATE_RESULT_PVT;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
599: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
600: END IF;
601: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 607: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

603: END UPDATE_RESULT;
604:
605: PROCEDURE INSERT_REASON(
606: P_API_VERSION IN NUMBER,
607: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
608: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
609: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
610: X_RETURN_STATUS OUT VARCHAR2,
611: X_MSG_COUNT OUT NUMBER,

Line 608: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

604:
605: PROCEDURE INSERT_REASON(
606: P_API_VERSION IN NUMBER,
607: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
608: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
609: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
610: X_RETURN_STATUS OUT VARCHAR2,
611: X_MSG_COUNT OUT NUMBER,
612: X_MSG_DATA OUT VARCHAR2,

Line 609: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

605: PROCEDURE INSERT_REASON(
606: P_API_VERSION IN NUMBER,
607: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
608: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
609: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
610: X_RETURN_STATUS OUT VARCHAR2,
611: X_MSG_COUNT OUT NUMBER,
612: X_MSG_DATA OUT VARCHAR2,
613: P_VERSATILITY_CODE IN NUMBER,

Line 655: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

651: -- Standard start of API savepoint
652: SAVEPOINT INSERT_REASON_PVT;
653:
654: -- Standard call to check for call compatibility
655: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658:
659: -- Initialize message list if p_init_msg_list is set to TRUE

Line 656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

652: SAVEPOINT INSERT_REASON_PVT;
653:
654: -- Standard call to check for call compatibility
655: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658:
659: -- Initialize message list if p_init_msg_list is set to TRUE
660: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 660: IF FND_API.To_Boolean(p_init_msg_list) THEN

656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658:
659: -- Initialize message list if p_init_msg_list is set to TRUE
660: IF FND_API.To_Boolean(p_init_msg_list) THEN
661: FND_MSG_PUB.initialize;
662: END IF;
663:
664: -- Initialize API return status to success

Line 665: x_return_status := FND_API.G_RET_STS_SUCCESS;

661: FND_MSG_PUB.initialize;
662: END IF;
663:
664: -- Initialize API return status to success
665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666:
667: -- API body
668:
669: -- get new REASON id

Line 713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

709: OPEN l_insert_tl_check_csr;
710: FETCH l_insert_tl_check_csr INTO l_dummy;
711: IF (l_insert_tl_check_csr%notfound) THEN
712: CLOSE l_insert_tl_check_csr;
713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
714: END IF;
715: CLOSE l_insert_tl_check_csr;
716:
717: -- insert new REASON into JTF_IH_REASONS_B

Line 750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

746: OPEN l_insert_b_check_csr;
747: FETCH l_insert_b_check_csr INTO l_dummy;
748: IF (l_insert_b_check_csr%notfound) THEN
749: CLOSE l_insert_b_check_csr;
750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
751: END IF;
752: CLOSE l_insert_b_check_csr;
753:
754: X_REASON_ID := L_REASON_ID;

Line 758: IF FND_API.To_Boolean(p_commit) THEN

754: X_REASON_ID := L_REASON_ID;
755: -- End of API body
756:
757: -- Standard check of p_commit
758: IF FND_API.To_Boolean(p_commit) THEN
759: COMMIT WORK;
760: END IF;
761:
762: -- Standard call to get message count and if count is 1, get message info

Line 766: WHEN FND_API.G_EXC_ERROR THEN

762: -- Standard call to get message count and if count is 1, get message info
763: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
764:
765: EXCEPTION
766: WHEN FND_API.G_EXC_ERROR THEN
767: ROLLBACK TO INSERT_REASON_PVT;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
770:

Line 768: x_return_status := FND_API.G_RET_STS_ERROR;

764:
765: EXCEPTION
766: WHEN FND_API.G_EXC_ERROR THEN
767: ROLLBACK TO INSERT_REASON_PVT;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
770:
771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
772: ROLLBACK TO INSERT_REASON_PVT;

Line 771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

767: ROLLBACK TO INSERT_REASON_PVT;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
770:
771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
772: ROLLBACK TO INSERT_REASON_PVT;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
775:

Line 773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

769: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
770:
771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
772: ROLLBACK TO INSERT_REASON_PVT;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
775:
776: WHEN OTHERS THEN
777: ROLLBACK TO INSERT_REASON_PVT;

Line 778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

774: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
775:
776: WHEN OTHERS THEN
777: ROLLBACK TO INSERT_REASON_PVT;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
780: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
781: END IF;
782: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 788: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

784: END INSERT_REASON;
785:
786: PROCEDURE UPDATE_REASON(
787: P_API_VERSION IN NUMBER,
788: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
789: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
790: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
791: X_RETURN_STATUS OUT VARCHAR2,
792: X_MSG_COUNT OUT NUMBER,

Line 789: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

785:
786: PROCEDURE UPDATE_REASON(
787: P_API_VERSION IN NUMBER,
788: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
789: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
790: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
791: X_RETURN_STATUS OUT VARCHAR2,
792: X_MSG_COUNT OUT NUMBER,
793: X_MSG_DATA OUT VARCHAR2,

Line 790: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

786: PROCEDURE UPDATE_REASON(
787: P_API_VERSION IN NUMBER,
788: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
789: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
790: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
791: X_RETURN_STATUS OUT VARCHAR2,
792: X_MSG_COUNT OUT NUMBER,
793: X_MSG_DATA OUT VARCHAR2,
794: P_REASON_ID IN NUMBER,

Line 816: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

812: -- Standard start of API savepoint
813: SAVEPOINT UPDATE_REASON_PVT;
814:
815: -- Standard call to check for call compatibility
816: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END IF;
819:
820: -- Initialize message list if p_init_msg_list is set to TRUE

Line 817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

813: SAVEPOINT UPDATE_REASON_PVT;
814:
815: -- Standard call to check for call compatibility
816: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END IF;
819:
820: -- Initialize message list if p_init_msg_list is set to TRUE
821: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 821: IF FND_API.To_Boolean(p_init_msg_list) THEN

817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END IF;
819:
820: -- Initialize message list if p_init_msg_list is set to TRUE
821: IF FND_API.To_Boolean(p_init_msg_list) THEN
822: FND_MSG_PUB.initialize;
823: END IF;
824:
825: -- Initialize API return status to success

Line 826: x_return_status := FND_API.G_RET_STS_SUCCESS;

822: FND_MSG_PUB.initialize;
823: END IF;
824:
825: -- Initialize API return status to success
826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827:
828: -- API body
829:
830: -- update outcome in JTF_IH_REASONS_TL

Line 861: IF FND_API.To_Boolean(p_commit) THEN

857:
858: -- End of API body
859:
860: -- Standard check of p_commit
861: IF FND_API.To_Boolean(p_commit) THEN
862: COMMIT WORK;
863: END IF;
864:
865: -- Standard call to get message count and if count is 1, get message info

Line 869: WHEN FND_API.G_EXC_ERROR THEN

865: -- Standard call to get message count and if count is 1, get message info
866: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
867:
868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN
870: ROLLBACK TO UPDATE_REASON_PVT;
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
873:

Line 871: x_return_status := FND_API.G_RET_STS_ERROR;

867:
868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN
870: ROLLBACK TO UPDATE_REASON_PVT;
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
873:
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: ROLLBACK TO UPDATE_REASON_PVT;

Line 874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

870: ROLLBACK TO UPDATE_REASON_PVT;
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
873:
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: ROLLBACK TO UPDATE_REASON_PVT;
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
878:

Line 876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

872: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
873:
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: ROLLBACK TO UPDATE_REASON_PVT;
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
878:
879: WHEN OTHERS THEN
880: ROLLBACK TO UPDATE_REASON_PVT;

Line 881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

877: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
878:
879: WHEN OTHERS THEN
880: ROLLBACK TO UPDATE_REASON_PVT;
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
884: END IF;
885: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 891: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

887: END UPDATE_REASON;
888:
889: PROCEDURE ALTER_OUTCOME_RESULT_LINK(
890: P_API_VERSION IN NUMBER,
891: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
892: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
893: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
894: X_RETURN_STATUS OUT VARCHAR2,
895: X_MSG_COUNT OUT NUMBER,

Line 892: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

888:
889: PROCEDURE ALTER_OUTCOME_RESULT_LINK(
890: P_API_VERSION IN NUMBER,
891: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
892: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
893: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
894: X_RETURN_STATUS OUT VARCHAR2,
895: X_MSG_COUNT OUT NUMBER,
896: X_MSG_DATA OUT VARCHAR2,

Line 893: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

889: PROCEDURE ALTER_OUTCOME_RESULT_LINK(
890: P_API_VERSION IN NUMBER,
891: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
892: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
893: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
894: X_RETURN_STATUS OUT VARCHAR2,
895: X_MSG_COUNT OUT NUMBER,
896: X_MSG_DATA OUT VARCHAR2,
897: P_ACTION IN VARCHAR2,

Line 913: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

909: -- Standard start of API savepoint
910: SAVEPOINT ALTER_OUTCOME_RESULT_LINK_PVT;
911:
912: -- Standard call to check for call compatibility
913: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: END IF;
916:
917: -- Initialize message list if p_init_msg_list is set to TRUE

Line 914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

910: SAVEPOINT ALTER_OUTCOME_RESULT_LINK_PVT;
911:
912: -- Standard call to check for call compatibility
913: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: END IF;
916:
917: -- Initialize message list if p_init_msg_list is set to TRUE
918: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 918: IF FND_API.To_Boolean(p_init_msg_list) THEN

914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: END IF;
916:
917: -- Initialize message list if p_init_msg_list is set to TRUE
918: IF FND_API.To_Boolean(p_init_msg_list) THEN
919: FND_MSG_PUB.initialize;
920: END IF;
921:
922: -- Initialize API return status to success

Line 923: x_return_status := FND_API.G_RET_STS_SUCCESS;

919: FND_MSG_PUB.initialize;
920: END IF;
921:
922: -- Initialize API return status to success
923: x_return_status := FND_API.G_RET_STS_SUCCESS;
924:
925: -- API body
926:
927: -- delete existing association first

Line 960: IF FND_API.To_Boolean(p_commit) THEN

956:
957: -- End of API body
958:
959: -- Standard check of p_commit
960: IF FND_API.To_Boolean(p_commit) THEN
961: COMMIT WORK;
962: END IF;
963:
964: -- Standard call to get message count and if count is 1, get message info

Line 968: WHEN FND_API.G_EXC_ERROR THEN

964: -- Standard call to get message count and if count is 1, get message info
965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
966:
967: EXCEPTION
968: WHEN FND_API.G_EXC_ERROR THEN
969: ROLLBACK TO ALTER_OUTCOME_RESULT_LINK_PVT;
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
972:

Line 970: x_return_status := FND_API.G_RET_STS_ERROR;

966:
967: EXCEPTION
968: WHEN FND_API.G_EXC_ERROR THEN
969: ROLLBACK TO ALTER_OUTCOME_RESULT_LINK_PVT;
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: ROLLBACK TO ALTER_OUTCOME_RESULT_LINK_PVT;

Line 973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

969: ROLLBACK TO ALTER_OUTCOME_RESULT_LINK_PVT;
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: ROLLBACK TO ALTER_OUTCOME_RESULT_LINK_PVT;
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
977:

Line 975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: ROLLBACK TO ALTER_OUTCOME_RESULT_LINK_PVT;
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
977:
978: WHEN OTHERS THEN
979: ROLLBACK TO ALTER_OUTCOME_RESULT_LINK_PVT;

Line 980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
977:
978: WHEN OTHERS THEN
979: ROLLBACK TO ALTER_OUTCOME_RESULT_LINK_PVT;
980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
981: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
982: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
983: END IF;
984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 990: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

986: END ALTER_OUTCOME_RESULT_LINK;
987:
988: PROCEDURE ALTER_RESULT_REASON_LINK(
989: P_API_VERSION IN NUMBER,
990: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
991: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
992: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
993: X_RETURN_STATUS OUT VARCHAR2,
994: X_MSG_COUNT OUT NUMBER,

Line 991: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

987:
988: PROCEDURE ALTER_RESULT_REASON_LINK(
989: P_API_VERSION IN NUMBER,
990: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
991: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
992: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
993: X_RETURN_STATUS OUT VARCHAR2,
994: X_MSG_COUNT OUT NUMBER,
995: X_MSG_DATA OUT VARCHAR2,

Line 992: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

988: PROCEDURE ALTER_RESULT_REASON_LINK(
989: P_API_VERSION IN NUMBER,
990: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
991: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
992: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
993: X_RETURN_STATUS OUT VARCHAR2,
994: X_MSG_COUNT OUT NUMBER,
995: X_MSG_DATA OUT VARCHAR2,
996: P_ACTION IN VARCHAR2,

Line 1012: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1008: -- Standard start of API savepoint
1009: SAVEPOINT ALTER_RESULT_REASON_LINK_PVT;
1010:
1011: -- Standard call to check for call compatibility
1012: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1014: END IF;
1015:
1016: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1009: SAVEPOINT ALTER_RESULT_REASON_LINK_PVT;
1010:
1011: -- Standard call to check for call compatibility
1012: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1014: END IF;
1015:
1016: -- Initialize message list if p_init_msg_list is set to TRUE
1017: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1017: IF FND_API.To_Boolean(p_init_msg_list) THEN

1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1014: END IF;
1015:
1016: -- Initialize message list if p_init_msg_list is set to TRUE
1017: IF FND_API.To_Boolean(p_init_msg_list) THEN
1018: FND_MSG_PUB.initialize;
1019: END IF;
1020:
1021: -- Initialize API return status to success

Line 1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

1018: FND_MSG_PUB.initialize;
1019: END IF;
1020:
1021: -- Initialize API return status to success
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023:
1024: -- API body
1025:
1026: -- delete existing association first

Line 1059: IF FND_API.To_Boolean(p_commit) THEN

1055:
1056: -- End of API body
1057:
1058: -- Standard check of p_commit
1059: IF FND_API.To_Boolean(p_commit) THEN
1060: COMMIT WORK;
1061: END IF;
1062:
1063: -- Standard call to get message count and if count is 1, get message info

Line 1067: WHEN FND_API.G_EXC_ERROR THEN

1063: -- Standard call to get message count and if count is 1, get message info
1064: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1065:
1066: EXCEPTION
1067: WHEN FND_API.G_EXC_ERROR THEN
1068: ROLLBACK TO ALTER_RESULT_REASON_LINK_PVT;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1071:

Line 1069: x_return_status := FND_API.G_RET_STS_ERROR;

1065:
1066: EXCEPTION
1067: WHEN FND_API.G_EXC_ERROR THEN
1068: ROLLBACK TO ALTER_RESULT_REASON_LINK_PVT;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1071:
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073: ROLLBACK TO ALTER_RESULT_REASON_LINK_PVT;

Line 1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1068: ROLLBACK TO ALTER_RESULT_REASON_LINK_PVT;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1071:
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073: ROLLBACK TO ALTER_RESULT_REASON_LINK_PVT;
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1075: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1076:

Line 1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1070: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1071:
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073: ROLLBACK TO ALTER_RESULT_REASON_LINK_PVT;
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1075: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1076:
1077: WHEN OTHERS THEN
1078: ROLLBACK TO ALTER_RESULT_REASON_LINK_PVT;

Line 1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1075: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1076:
1077: WHEN OTHERS THEN
1078: ROLLBACK TO ALTER_RESULT_REASON_LINK_PVT;
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1081: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1082: END IF;
1083: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);