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.IBE_DISPLAYCONTEXT_GRP dependencies on FND_API

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

17: -- 7. Raises an exception if the access name is null
18: ---------------------------------------------------------------------+
19: PROCEDURE save_display_context(
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
22: p_commit IN VARCHAR2 := FND_API.g_false,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,

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

18: ---------------------------------------------------------------------+
19: PROCEDURE save_display_context(
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
22: p_commit IN VARCHAR2 := FND_API.g_false,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,
26: p_display_context_rec IN OUT NOCOPY DISPLAY_CONTEXT_REC_TYPE )

Line 46: IF NOT FND_API.compatible_api_call( g_api_version,

42:
43: --------------------- initialize -----------------------+
44: SAVEPOINT save_display_context;
45:
46: IF NOT FND_API.compatible_api_call( g_api_version,
47: p_api_version,
48: l_api_name,
49: g_pkg_name )
50: THEN

Line 51: RAISE FND_API.g_exc_unexpected_error;

47: p_api_version,
48: l_api_name,
49: g_pkg_name )
50: THEN
51: RAISE FND_API.g_exc_unexpected_error;
52: END IF;
53:
54: IF FND_API.to_boolean(p_init_msg_list)
55: THEN

Line 54: IF FND_API.to_boolean(p_init_msg_list)

50: THEN
51: RAISE FND_API.g_exc_unexpected_error;
52: END IF;
53:
54: IF FND_API.to_boolean(p_init_msg_list)
55: THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

55: THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60:
61: -- Check if the context type is valid
62: IF ibe_dspmgrvalidation_grp.check_valid_context_type(
63: p_display_context_rec.context_type) = false

Line 65: RAISE FND_API.g_exc_error;

61: -- Check if the context type is valid
62: IF ibe_dspmgrvalidation_grp.check_valid_context_type(
63: p_display_context_rec.context_type) = false
64: THEN
65: RAISE FND_API.g_exc_error;
66: END IF;
67:
68: --- Check if the context_id exists if not null
69: IF p_display_context_rec.context_id IS NOT NULL

Line 76: RAISE FND_API.g_exc_error;

72: p_display_context_rec.context_id,
73: p_display_context_rec.context_type,
74: p_display_context_rec.Object_version_Number) = false
75: THEN
76: RAISE FND_API.g_exc_error;
77: END IF;
78:
79: l_operation_type:='UPDATE';
80: END IF;

Line 91: RAISE FND_API.g_exc_error;

87: l_access_name,
88: p_display_context_rec.context_type,
89: p_display_context_rec.context_id)
90: THEN
91: RAISE FND_API.g_exc_error;
92: END IF;
93: ELSE
94: RAISE ibe_dspmgrvalidation_grp.context_accname_req_exception;
95: END IF;

Line 100: p_display_context_rec.default_deliverable_id <> FND_API.g_miss_num

96:
97: --- Check if the deliverable id exists if deliverable is not null,
98: --- else ignore.
99: IF p_display_context_rec.default_deliverable_id is not null AND
100: p_display_context_rec.default_deliverable_id <> FND_API.g_miss_num
101: THEN
102: IF ibe_dspmgrvalidation_grp.check_deliverable_type_exists(
103: p_display_context_rec.Default_deliverable_id ,
104: p_display_context_rec.context_type)

Line 108: RAISE FND_API.g_exc_error;

104: p_display_context_rec.context_type)
105: THEN
106: l_deliverable_id := p_display_context_rec.Default_deliverable_id;
107: ELSE
108: RAISE FND_API.g_exc_error;
109: END IF;
110: END IF;
111:
112: IF l_operation_type = 'INSERT'

Line 199: FND_API.G_MISS_CHAR, NAME,

195:
196: --- Update the TL table
197: UPDATE IBE_DSP_CONTEXT_TL
198: SET NAME = DECODE( p_display_context_rec.display_name,
199: FND_API.G_MISS_CHAR, NAME,
200: p_display_context_rec.display_name),
201: DESCRIPTION = decode( p_display_context_rec.description,
202: FND_API.G_MISS_CHAR, DESCRIPTION,
203: p_display_context_rec.description),

Line 202: FND_API.G_MISS_CHAR, DESCRIPTION,

198: SET NAME = DECODE( p_display_context_rec.display_name,
199: FND_API.G_MISS_CHAR, NAME,
200: p_display_context_rec.display_name),
201: DESCRIPTION = decode( p_display_context_rec.description,
202: FND_API.G_MISS_CHAR, DESCRIPTION,
203: p_display_context_rec.description),
204: LAST_UPDATE_DATE = SYSDATE,
205: LAST_UPDATED_BY = FND_GLOBAL.user_id,
206: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,

Line 216: IF FND_API.to_boolean(p_commit)

212: END IF;
213:
214: --- Check if the caller requested to commit ,
215: --- If p_commit set to true, commit the transaction
216: IF FND_API.to_boolean(p_commit)
217: THEN
218: COMMIT;
219: END IF;
220:

Line 221: x_return_status := FND_API.G_RET_STS_SUCCESS;

217: THEN
218: COMMIT;
219: END IF;
220:
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false,
224: p_count => x_msg_count,
225: p_data => x_msg_data );

Line 223: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false,

219: END IF;
220:
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false,
224: p_count => x_msg_count,
225: p_data => x_msg_data );
226: EXCEPTION
227: WHEN FND_API.g_exc_error

Line 227: WHEN FND_API.g_exc_error

223: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false,
224: p_count => x_msg_count,
225: p_data => x_msg_data );
226: EXCEPTION
227: WHEN FND_API.g_exc_error
228: THEN
229: ROLLBACK TO save_display_context;
230: x_return_status := FND_API.g_ret_sts_error;
231: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,

Line 230: x_return_status := FND_API.g_ret_sts_error;

226: EXCEPTION
227: WHEN FND_API.g_exc_error
228: THEN
229: ROLLBACK TO save_display_context;
230: x_return_status := FND_API.g_ret_sts_error;
231: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,
232: p_count => x_msg_count,
233: p_data => x_msg_data );
234: WHEN FND_API.g_exc_unexpected_error

Line 231: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,

227: WHEN FND_API.g_exc_error
228: THEN
229: ROLLBACK TO save_display_context;
230: x_return_status := FND_API.g_ret_sts_error;
231: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,
232: p_count => x_msg_count,
233: p_data => x_msg_data );
234: WHEN FND_API.g_exc_unexpected_error
235: THEN

Line 234: WHEN FND_API.g_exc_unexpected_error

230: x_return_status := FND_API.g_ret_sts_error;
231: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,
232: p_count => x_msg_count,
233: p_data => x_msg_data );
234: WHEN FND_API.g_exc_unexpected_error
235: THEN
236: ROLLBACK TO save_display_context;
237: x_return_status := FND_API.g_ret_sts_unexp_error ;
238: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,

Line 237: x_return_status := FND_API.g_ret_sts_unexp_error ;

233: p_data => x_msg_data );
234: WHEN FND_API.g_exc_unexpected_error
235: THEN
236: ROLLBACK TO save_display_context;
237: x_return_status := FND_API.g_ret_sts_unexp_error ;
238: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,
239: p_count => x_msg_count,
240: p_data => x_msg_data );
241: WHEN ibe_dspmgrvalidation_grp.context_accname_req_exception

Line 238: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,

234: WHEN FND_API.g_exc_unexpected_error
235: THEN
236: ROLLBACK TO save_display_context;
237: x_return_status := FND_API.g_ret_sts_unexp_error ;
238: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,
239: p_count => x_msg_count,
240: p_data => x_msg_data );
241: WHEN ibe_dspmgrvalidation_grp.context_accname_req_exception
242: THEN

Line 244: x_return_status := FND_API.g_ret_sts_error;

240: p_data => x_msg_data );
241: WHEN ibe_dspmgrvalidation_grp.context_accname_req_exception
242: THEN
243: ROLLBACK TO save_display_context;
244: x_return_status := FND_API.g_ret_sts_error;
245: FND_MESSAGE.SET_NAME('IBE','IBE_DSP_CONTEXT_ACCNAME_REQ');
246: FND_MSG_PUB.ADD;
247: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,
248: p_count => x_msg_count,

Line 247: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,

243: ROLLBACK TO save_display_context;
244: x_return_status := FND_API.g_ret_sts_error;
245: FND_MESSAGE.SET_NAME('IBE','IBE_DSP_CONTEXT_ACCNAME_REQ');
246: FND_MSG_PUB.ADD;
247: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,
248: p_count => x_msg_count,
249: p_data => x_msg_data );
250: WHEN OTHERS
251: THEN

Line 253: x_return_status := FND_API.g_ret_sts_unexp_error ;

249: p_data => x_msg_data );
250: WHEN OTHERS
251: THEN
252: ROLLBACK TO save_display_context;
253: x_return_status := FND_API.g_ret_sts_unexp_error ;
254: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error)
255: THEN
256: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
257: END IF;

Line 258: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,

254: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error)
255: THEN
256: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
257: END IF;
258: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.g_false,
259: p_count => x_msg_count,
260: p_data => x_msg_data );
261:
262: END save_display_context;

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

271: -- from TL tables
272: --------------------------------------------------------------------+
273: PROCEDURE delete_display_context(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
276: p_commit IN VARCHAR2 := FND_API.g_false,
277: x_return_status OUT NOCOPY VARCHAR2,
278: x_msg_count OUT NOCOPY NUMBER,
279: x_msg_data OUT NOCOPY VARCHAR2,

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

272: --------------------------------------------------------------------+
273: PROCEDURE delete_display_context(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
276: p_commit IN VARCHAR2 := FND_API.g_false,
277: x_return_status OUT NOCOPY VARCHAR2,
278: x_msg_count OUT NOCOPY NUMBER,
279: x_msg_data OUT NOCOPY VARCHAR2,
280: p_display_context_rec IN OUT NOCOPY DISPLAY_CONTEXT_REC_TYPE )

Line 290: IF NOT FND_API.compatible_api_call(g_api_version,

286: BEGIN
287: --------------------- initialize -----------------------+
288: SAVEPOINT delete_display_context;
289:
290: IF NOT FND_API.compatible_api_call(g_api_version,
291: p_api_version,
292: l_api_name,
293: g_pkg_name )
294: THEN

Line 295: RAISE FND_API.g_exc_unexpected_error;

291: p_api_version,
292: l_api_name,
293: g_pkg_name )
294: THEN
295: RAISE FND_API.g_exc_unexpected_error;
296: END IF;
297:
298: IF FND_API.to_boolean(p_init_msg_list)
299: THEN

Line 298: IF FND_API.to_boolean(p_init_msg_list)

294: THEN
295: RAISE FND_API.g_exc_unexpected_error;
296: END IF;
297:
298: IF FND_API.to_boolean(p_init_msg_list)
299: THEN
300: FND_MSG_PUB.initialize;
301: END IF;
302:

Line 303: x_return_status := FND_API.G_RET_STS_SUCCESS;

299: THEN
300: FND_MSG_PUB.initialize;
301: END IF;
302:
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304: --- Check if the context_id exists
305: IF p_display_context_rec.context_id <> FND_API.g_miss_num AND
306: p_display_context_rec.context_id IS NOT NULL
307: THEN

Line 305: IF p_display_context_rec.context_id <> FND_API.g_miss_num AND

301: END IF;
302:
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304: --- Check if the context_id exists
305: IF p_display_context_rec.context_id <> FND_API.g_miss_num AND
306: p_display_context_rec.context_id IS NOT NULL
307: THEN
308: -- Check if the context_id is valid
309: IF ibe_dspmgrvalidation_grp.check_context_exists(

Line 314: RAISE FND_API.g_exc_error;

310: p_display_context_rec.context_id,
311: p_display_context_rec.context_type,
312: p_display_context_rec.Object_version_Number) = false
313: THEN
314: RAISE FND_API.g_exc_error;
315: END IF;
316:
317: DELETE FROM IBE_DSP_CONTEXT_B
318: WHERE CONTEXT_ID = p_display_context_rec.context_id

Line 332: FND_API.g_false,

328: IBE_LogicalContent_GRP.delete_context(p_display_context_rec.context_id);
329:
330: IBE_DSP_SECTION_GRP.Update_Dsp_Context_To_Null(
331: p_api_version,
332: FND_API.g_false,
333: FND_API.g_false,
334: FND_API.G_VALID_LEVEL_FULL,
335: p_display_context_rec.context_id,
336: x_return_status,

Line 333: FND_API.g_false,

329:
330: IBE_DSP_SECTION_GRP.Update_Dsp_Context_To_Null(
331: p_api_version,
332: FND_API.g_false,
333: FND_API.g_false,
334: FND_API.G_VALID_LEVEL_FULL,
335: p_display_context_rec.context_id,
336: x_return_status,
337: x_msg_count,

Line 334: FND_API.G_VALID_LEVEL_FULL,

330: IBE_DSP_SECTION_GRP.Update_Dsp_Context_To_Null(
331: p_api_version,
332: FND_API.g_false,
333: FND_API.g_false,
334: FND_API.G_VALID_LEVEL_FULL,
335: p_display_context_rec.context_id,
336: x_return_status,
337: x_msg_count,
338: x_msg_data );

Line 340: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

336: x_return_status,
337: x_msg_count,
338: x_msg_data );
339:
340: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
341: RAISE FND_API.G_EXC_ERROR;
342: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;

Line 341: RAISE FND_API.G_EXC_ERROR;

337: x_msg_count,
338: x_msg_data );
339:
340: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
341: RAISE FND_API.G_EXC_ERROR;
342: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:

Line 342: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

338: x_msg_data );
339:
340: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
341: RAISE FND_API.G_EXC_ERROR;
342: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:
346: ELSE

Line 343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

339:
340: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
341: RAISE FND_API.G_EXC_ERROR;
342: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:
346: ELSE
347: FND_MESSAGE.SET_NAME('IBE','IBE_DSP_CONTEXT_ID_REQ');

Line 349: RAISE FND_API.g_exc_error;

345:
346: ELSE
347: FND_MESSAGE.SET_NAME('IBE','IBE_DSP_CONTEXT_ID_REQ');
348: FND_MSG_PUB.ADD;
349: RAISE FND_API.g_exc_error;
350: END IF;
351:
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353:

Line 352: x_return_status := FND_API.G_RET_STS_SUCCESS;

348: FND_MSG_PUB.ADD;
349: RAISE FND_API.g_exc_error;
350: END IF;
351:
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353:
354: --- Check if the caller requested to commit ,
355: --- If p_commit set to true, commit the transaction
356: IF FND_API.to_boolean(p_commit)

Line 356: IF FND_API.to_boolean(p_commit)

352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353:
354: --- Check if the caller requested to commit ,
355: --- If p_commit set to true, commit the transaction
356: IF FND_API.to_boolean(p_commit)
357: THEN
358: COMMIT;
359: END IF;
360:

Line 362: p_encoded => FND_API.g_false,

358: COMMIT;
359: END IF;
360:
361: FND_MSG_PUB.COUNT_AND_GET(
362: p_encoded => FND_API.g_false,
363: p_count => x_msg_count,
364: p_data => x_msg_data );
365: EXCEPTION
366: WHEN FND_API.g_exc_error

Line 366: WHEN FND_API.g_exc_error

362: p_encoded => FND_API.g_false,
363: p_count => x_msg_count,
364: p_data => x_msg_data );
365: EXCEPTION
366: WHEN FND_API.g_exc_error
367: THEN
368: ROLLBACK TO delete_display_context;
369: x_return_status := FND_API.g_ret_sts_error;
370: FND_MSG_PUB.COUNT_AND_GET(

Line 369: x_return_status := FND_API.g_ret_sts_error;

365: EXCEPTION
366: WHEN FND_API.g_exc_error
367: THEN
368: ROLLBACK TO delete_display_context;
369: x_return_status := FND_API.g_ret_sts_error;
370: FND_MSG_PUB.COUNT_AND_GET(
371: p_encoded => FND_API.g_false,
372: p_count => x_msg_count,
373: p_data => x_msg_data );

Line 371: p_encoded => FND_API.g_false,

367: THEN
368: ROLLBACK TO delete_display_context;
369: x_return_status := FND_API.g_ret_sts_error;
370: FND_MSG_PUB.COUNT_AND_GET(
371: p_encoded => FND_API.g_false,
372: p_count => x_msg_count,
373: p_data => x_msg_data );
374: WHEN FND_API.g_exc_unexpected_error
375: THEN

Line 374: WHEN FND_API.g_exc_unexpected_error

370: FND_MSG_PUB.COUNT_AND_GET(
371: p_encoded => FND_API.g_false,
372: p_count => x_msg_count,
373: p_data => x_msg_data );
374: WHEN FND_API.g_exc_unexpected_error
375: THEN
376: ROLLBACK TO delete_display_context;
377: x_return_status := FND_API.g_ret_sts_unexp_error ;
378: FND_MSG_PUB.COUNT_AND_GET(

Line 377: x_return_status := FND_API.g_ret_sts_unexp_error ;

373: p_data => x_msg_data );
374: WHEN FND_API.g_exc_unexpected_error
375: THEN
376: ROLLBACK TO delete_display_context;
377: x_return_status := FND_API.g_ret_sts_unexp_error ;
378: FND_MSG_PUB.COUNT_AND_GET(
379: p_encoded => FND_API.g_false,
380: p_count => x_msg_count,
381: p_data => x_msg_data );

Line 379: p_encoded => FND_API.g_false,

375: THEN
376: ROLLBACK TO delete_display_context;
377: x_return_status := FND_API.g_ret_sts_unexp_error ;
378: FND_MSG_PUB.COUNT_AND_GET(
379: p_encoded => FND_API.g_false,
380: p_count => x_msg_count,
381: p_data => x_msg_data );
382: WHEN OTHERS THEN
383: ROLLBACK TO delete_display_context;

Line 384: x_return_status := FND_API.g_ret_sts_unexp_error ;

380: p_count => x_msg_count,
381: p_data => x_msg_data );
382: WHEN OTHERS THEN
383: ROLLBACK TO delete_display_context;
384: x_return_status := FND_API.g_ret_sts_unexp_error ;
385: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error)
386: THEN
387: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
388: END IF;

Line 390: p_encoded => FND_API.g_false,

386: THEN
387: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
388: END IF;
389: FND_MSG_PUB.COUNT_AND_GET(
390: p_encoded => FND_API.g_false,
391: p_count => x_msg_count,
392: p_data => x_msg_data );
393: END delete_display_context;
394:

Line 398: -- 2. If context_delete is FND_API.g_true, then operation is

394:
395: ---------------------------------------------------------------
396: -- NOTES
397: -- 1. Raise exception if the p_api_version doesn't match.
398: -- 2. If context_delete is FND_API.g_true, then operation is
399: -- delete and delete_display_context is called with appropriate
400: -- parameters
401: -- 3. If the context_id is passed in the record, the existing display
402: -- context is updated.

Line 404: -- is inserted and context_delete is FND_API.g_false

400: -- parameters
401: -- 3. If the context_id is passed in the record, the existing display
402: -- context is updated.
403: -- 4. If the context_id is set to null, a new display context record
404: -- is inserted and context_delete is FND_API.g_false
405: -- 5. If the operation is an insert/update, save_display_context with
406: -- appropriate parameters is called
407: -- 6. Raises exception if the context_id does not exist for an update
408: -- operation

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

413: -- updated,deleted from TL tables depending on the operation (2,3)
414: --------------------------------------------------------------------
415: PROCEDURE save_delete_display_context(
416: p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
418: p_commit IN VARCHAR2 := FND_API.g_false,
419: x_return_status OUT NOCOPY VARCHAR2,
420: x_msg_count OUT NOCOPY NUMBER,
421: x_msg_data OUT NOCOPY VARCHAR2,

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

414: --------------------------------------------------------------------
415: PROCEDURE save_delete_display_context(
416: p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
418: p_commit IN VARCHAR2 := FND_API.g_false,
419: x_return_status OUT NOCOPY VARCHAR2,
420: x_msg_count OUT NOCOPY NUMBER,
421: x_msg_data OUT NOCOPY VARCHAR2,
422: p_display_context_tbl IN OUT NOCOPY DISPLAY_CONTEXT_TBL_TYPE )

Line 435: IF NOT FND_API.compatible_api_call(

431: BEGIN
432: --------------------- initialize -----------------------+
433: SAVEPOINT save_delete_display_context;
434:
435: IF NOT FND_API.compatible_api_call(
436: g_api_version,
437: p_api_version,
438: l_api_name,
439: g_pkg_name )

Line 441: RAISE FND_API.g_exc_unexpected_error;

437: p_api_version,
438: l_api_name,
439: g_pkg_name )
440: THEN
441: RAISE FND_API.g_exc_unexpected_error;
442: END IF;
443:
444: IF FND_API.to_boolean(p_init_msg_list)
445: THEN

Line 444: IF FND_API.to_boolean(p_init_msg_list)

440: THEN
441: RAISE FND_API.g_exc_unexpected_error;
442: END IF;
443:
444: IF FND_API.to_boolean(p_init_msg_list)
445: THEN
446: FND_MSG_PUB.initialize;
447: END IF;
448:

Line 449: x_return_status := FND_API.G_RET_STS_SUCCESS;

445: THEN
446: FND_MSG_PUB.initialize;
447: END IF;
448:
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: FOR l_index IN 1..p_display_context_tbl.COUNT
452: LOOP
453: IF p_display_context_tbl(l_index).context_delete = FND_API.g_true

Line 453: IF p_display_context_tbl(l_index).context_delete = FND_API.g_true

449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: FOR l_index IN 1..p_display_context_tbl.COUNT
452: LOOP
453: IF p_display_context_tbl(l_index).context_delete = FND_API.g_true
454: THEN
455: delete_display_context(
456: p_api_version,
457: FND_API.g_false,

Line 457: FND_API.g_false,

453: IF p_display_context_tbl(l_index).context_delete = FND_API.g_true
454: THEN
455: delete_display_context(
456: p_api_version,
457: FND_API.g_false,
458: FND_API.g_false,
459: l_return_status,
460: l_msg_count,
461: l_msg_data,

Line 458: FND_API.g_false,

454: THEN
455: delete_display_context(
456: p_api_version,
457: FND_API.g_false,
458: FND_API.g_false,
459: l_return_status,
460: l_msg_count,
461: l_msg_data,
462: p_display_context_tbl(l_index));

Line 464: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

460: l_msg_count,
461: l_msg_data,
462: p_display_context_tbl(l_index));
463:
464: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
465: RAISE FND_API.G_EXC_ERROR;
466: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;

Line 465: RAISE FND_API.G_EXC_ERROR;

461: l_msg_data,
462: p_display_context_tbl(l_index));
463:
464: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
465: RAISE FND_API.G_EXC_ERROR;
466: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469:

Line 466: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

462: p_display_context_tbl(l_index));
463:
464: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
465: RAISE FND_API.G_EXC_ERROR;
466: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469:
470: ELSIF p_display_context_tbl(l_index).context_delete = FND_API.g_false

Line 467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

463:
464: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
465: RAISE FND_API.G_EXC_ERROR;
466: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469:
470: ELSIF p_display_context_tbl(l_index).context_delete = FND_API.g_false
471: THEN

Line 470: ELSIF p_display_context_tbl(l_index).context_delete = FND_API.g_false

466: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469:
470: ELSIF p_display_context_tbl(l_index).context_delete = FND_API.g_false
471: THEN
472: save_display_context(
473: p_api_version,
474: FND_API.g_false,

Line 474: FND_API.g_false,

470: ELSIF p_display_context_tbl(l_index).context_delete = FND_API.g_false
471: THEN
472: save_display_context(
473: p_api_version,
474: FND_API.g_false,
475: FND_API.g_false,
476: l_return_status,
477: l_msg_count,
478: l_msg_data,

Line 475: FND_API.g_false,

471: THEN
472: save_display_context(
473: p_api_version,
474: FND_API.g_false,
475: FND_API.g_false,
476: l_return_status,
477: l_msg_count,
478: l_msg_data,
479: p_display_context_tbl(l_index));

Line 481: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

477: l_msg_count,
478: l_msg_data,
479: p_display_context_tbl(l_index));
480:
481: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
482: RAISE FND_API.G_EXC_ERROR;
483: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;

Line 482: RAISE FND_API.G_EXC_ERROR;

478: l_msg_data,
479: p_display_context_tbl(l_index));
480:
481: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
482: RAISE FND_API.G_EXC_ERROR;
483: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:

Line 483: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

479: p_display_context_tbl(l_index));
480:
481: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
482: RAISE FND_API.G_EXC_ERROR;
483: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:
487: END IF;

Line 484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

480:
481: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
482: RAISE FND_API.G_EXC_ERROR;
483: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:
487: END IF;
488:

Line 489: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

485: END IF;
486:
487: END IF;
488:
489: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
490: THEN
491: x_return_status := l_return_status;
492: END IF;
493: END LOOP;

Line 497: IF FND_API.to_boolean(p_commit)

493: END LOOP;
494:
495: --- Check if the caller requested to commit ,
496: --- If p_commit set to true, commit the transaction
497: IF FND_API.to_boolean(p_commit)
498: THEN
499: COMMIT;
500: END IF;
501:

Line 503: p_encoded => FND_API.g_false,

499: COMMIT;
500: END IF;
501:
502: FND_MSG_PUB.COUNT_AND_GET(
503: p_encoded => FND_API.g_false,
504: p_count => x_msg_count,
505: p_data => x_msg_data );
506: EXCEPTION
507: WHEN FND_API.g_exc_unexpected_error

Line 507: WHEN FND_API.g_exc_unexpected_error

503: p_encoded => FND_API.g_false,
504: p_count => x_msg_count,
505: p_data => x_msg_data );
506: EXCEPTION
507: WHEN FND_API.g_exc_unexpected_error
508: THEN
509: ROLLBACK TO save_delete_display_context;
510: x_return_status := FND_API.g_ret_sts_unexp_error ;
511: FND_MSG_PUB.COUNT_AND_GET(

Line 510: x_return_status := FND_API.g_ret_sts_unexp_error ;

506: EXCEPTION
507: WHEN FND_API.g_exc_unexpected_error
508: THEN
509: ROLLBACK TO save_delete_display_context;
510: x_return_status := FND_API.g_ret_sts_unexp_error ;
511: FND_MSG_PUB.COUNT_AND_GET(
512: p_encoded => FND_API.g_false,
513: p_count => x_msg_count,
514: p_data => x_msg_data );

Line 512: p_encoded => FND_API.g_false,

508: THEN
509: ROLLBACK TO save_delete_display_context;
510: x_return_status := FND_API.g_ret_sts_unexp_error ;
511: FND_MSG_PUB.COUNT_AND_GET(
512: p_encoded => FND_API.g_false,
513: p_count => x_msg_count,
514: p_data => x_msg_data );
515: WHEN OTHERS THEN
516: ROLLBACK TO save_delete_display_context;

Line 517: x_return_status := FND_API.g_ret_sts_unexp_error ;

513: p_count => x_msg_count,
514: p_data => x_msg_data );
515: WHEN OTHERS THEN
516: ROLLBACK TO save_delete_display_context;
517: x_return_status := FND_API.g_ret_sts_unexp_error ;
518: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error)
519: THEN
520: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
521: END IF;

Line 523: p_encoded => FND_API.g_false,

519: THEN
520: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
521: END IF;
522: FND_MSG_PUB.COUNT_AND_GET(
523: p_encoded => FND_API.g_false,
524: p_count => x_msg_count,
525: p_data => x_msg_data);
526: END save_delete_display_context;
527:

Line 540: IF p_deliverable_id <> FND_API.g_miss_num OR

536: IS
537: BEGIN
538: SAVEPOINT delete_deliverable;
539:
540: IF p_deliverable_id <> FND_API.g_miss_num OR
541: p_deliverable_id IS NOT NULL
542: THEN
543: -- Set the deliverable id to null for any display context
544: UPDATE IBE_DSP_CONTEXT_B