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_LOGICALCONTENT_GRP dependencies on FND_API

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

12:
13:
14: PROCEDURE delete_logical_content(
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
17: p_commit IN VARCHAR2 := FND_API.g_false,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2,

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

13:
14: PROCEDURE delete_logical_content(
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
17: p_commit IN VARCHAR2 := FND_API.g_false,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2,
21: p_object_type IN VARCHAR2,

Line 34: IF NOT FND_API.compatible_api_call(

30: BEGIN
31: --------------------- initialize -----------------------+
32: SAVEPOINT delete_logical_content;
33:
34: IF NOT FND_API.compatible_api_call(
35: g_api_version,
36: p_api_version,
37: l_api_name,
38: g_pkg_name )

Line 40: RAISE FND_API.g_exc_unexpected_error;

36: p_api_version,
37: l_api_name,
38: g_pkg_name )
39: THEN
40: RAISE FND_API.g_exc_unexpected_error;
41: END IF;
42:
43: IF FND_API.to_boolean(p_init_msg_list)
44: THEN

Line 43: IF FND_API.to_boolean(p_init_msg_list)

39: THEN
40: RAISE FND_API.g_exc_unexpected_error;
41: END IF;
42:
43: IF FND_API.to_boolean(p_init_msg_list)
44: THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44: THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50: IF p_lgl_ctnt_rec.obj_lgl_ctnt_id IS NOT NULL
51: THEN
52: --- Check if the object logical content exists

Line 57: RAISE FND_API.g_exc_error;

53: IF ibe_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(
54: p_lgl_ctnt_rec.obj_lgl_ctnt_id,
55: p_lgl_ctnt_rec.object_version_number) = false
56: THEN
57: RAISE FND_API.g_exc_error;
58: END IF;
59:
60: DELETE FROM ibe_dsp_obj_lgl_ctnt
61: WHERE obj_lgl_ctnt_id = p_lgl_ctnt_rec.obj_lgl_ctnt_id

Line 70: IF FND_API.to_boolean(p_commit)

66:
67: --- Check if the caller requested to commit ,
68: --- If p_commit set to true, commit the transaction
69:
70: IF FND_API.to_boolean(p_commit)
71: THEN
72: COMMIT;
73: END IF;
74:

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: THEN
72: COMMIT;
73: END IF;
74:
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: FND_MSG_PUB.count_and_get(
78: p_encoded => FND_API.g_false,
79: p_count => x_msg_count,

Line 78: p_encoded => FND_API.g_false,

74:
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: FND_MSG_PUB.count_and_get(
78: p_encoded => FND_API.g_false,
79: p_count => x_msg_count,
80: p_data => x_msg_data );
81: EXCEPTION
82: WHEN FND_API.g_exc_error THEN

Line 82: WHEN FND_API.g_exc_error THEN

78: p_encoded => FND_API.g_false,
79: p_count => x_msg_count,
80: p_data => x_msg_data );
81: EXCEPTION
82: WHEN FND_API.g_exc_error THEN
83: ROLLBACK TO delete_logical_content;
84: x_return_status := FND_API.g_ret_sts_error;
85: FND_MSG_PUB.count_and_get(
86: p_encoded => FND_API.g_false,

Line 84: x_return_status := FND_API.g_ret_sts_error;

80: p_data => x_msg_data );
81: EXCEPTION
82: WHEN FND_API.g_exc_error THEN
83: ROLLBACK TO delete_logical_content;
84: x_return_status := FND_API.g_ret_sts_error;
85: FND_MSG_PUB.count_and_get(
86: p_encoded => FND_API.g_false,
87: p_count => x_msg_count,
88: p_data => x_msg_data );

Line 86: p_encoded => FND_API.g_false,

82: WHEN FND_API.g_exc_error THEN
83: ROLLBACK TO delete_logical_content;
84: x_return_status := FND_API.g_ret_sts_error;
85: FND_MSG_PUB.count_and_get(
86: p_encoded => FND_API.g_false,
87: p_count => x_msg_count,
88: p_data => x_msg_data );
89:
90: WHEN FND_API.g_exc_unexpected_error THEN

Line 90: WHEN FND_API.g_exc_unexpected_error THEN

86: p_encoded => FND_API.g_false,
87: p_count => x_msg_count,
88: p_data => x_msg_data );
89:
90: WHEN FND_API.g_exc_unexpected_error THEN
91: ROLLBACK TO delete_logical_content;
92: x_return_status := FND_API.g_ret_sts_error ;
93: FND_MSG_PUB.count_and_get(
94: p_encoded => FND_API.g_false,

Line 92: x_return_status := FND_API.g_ret_sts_error ;

88: p_data => x_msg_data );
89:
90: WHEN FND_API.g_exc_unexpected_error THEN
91: ROLLBACK TO delete_logical_content;
92: x_return_status := FND_API.g_ret_sts_error ;
93: FND_MSG_PUB.count_and_get(
94: p_encoded => FND_API.g_false,
95: p_count => x_msg_count,
96: p_data => x_msg_data );

Line 94: p_encoded => FND_API.g_false,

90: WHEN FND_API.g_exc_unexpected_error THEN
91: ROLLBACK TO delete_logical_content;
92: x_return_status := FND_API.g_ret_sts_error ;
93: FND_MSG_PUB.count_and_get(
94: p_encoded => FND_API.g_false,
95: p_count => x_msg_count,
96: p_data => x_msg_data );
97:
98: WHEN ibe_dspmgrvalidation_grp.lglctnt_id_req_exception THEN

Line 100: x_return_status := FND_API.g_ret_sts_error;

96: p_data => x_msg_data );
97:
98: WHEN ibe_dspmgrvalidation_grp.lglctnt_id_req_exception THEN
99: ROLLBACK TO delete_logical_content;
100: x_return_status := FND_API.g_ret_sts_error;
101: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_ID_REQ');
102: FND_MSG_PUB.ADD;
103: FND_MSG_PUB.count_and_get(
104: p_encoded => FND_API.g_false,

Line 104: p_encoded => FND_API.g_false,

100: x_return_status := FND_API.g_ret_sts_error;
101: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_ID_REQ');
102: FND_MSG_PUB.ADD;
103: FND_MSG_PUB.count_and_get(
104: p_encoded => FND_API.g_false,
105: p_count => x_msg_count,
106: p_data => x_msg_data );
107:
108: WHEN OTHERS THEN

Line 110: x_return_status := FND_API.g_ret_sts_unexp_error ;

106: p_data => x_msg_data );
107:
108: WHEN OTHERS THEN
109: ROLLBACK TO delete_logical_content;
110: x_return_status := FND_API.g_ret_sts_unexp_error ;
111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
112: THEN
113: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
114: END IF;

Line 116: p_encoded => FND_API.g_false,

112: THEN
113: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
114: END IF;
115: FND_MSG_PUB.count_and_get(
116: p_encoded => FND_API.g_false,
117: p_count => x_msg_count,
118: p_data => x_msg_data);
119: END delete_logical_content;
120:

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

119: END delete_logical_content;
120:
121: PROCEDURE save_logical_content(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
124: p_commit IN VARCHAR2 := FND_API.g_false,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,

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

120:
121: PROCEDURE save_logical_content(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
124: p_commit IN VARCHAR2 := FND_API.g_false,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_object_type IN VARCHAR2,

Line 147: IF NOT FND_API.compatible_api_call(

143: BEGIN
144: --------------------- initialize -----------------------+
145: SAVEPOINT save_logical_content;
146:
147: IF NOT FND_API.compatible_api_call(
148: g_api_version,
149: p_api_version,
150: l_api_name,
151: g_pkg_name )

Line 153: RAISE FND_API.g_exc_unexpected_error;

149: p_api_version,
150: l_api_name,
151: g_pkg_name )
152: THEN
153: RAISE FND_API.g_exc_unexpected_error;
154: END IF;
155:
156: IF FND_API.to_boolean(p_init_msg_list)
157: THEN

Line 156: IF FND_API.to_boolean(p_init_msg_list)

152: THEN
153: RAISE FND_API.g_exc_unexpected_error;
154: END IF;
155:
156: IF FND_API.to_boolean(p_init_msg_list)
157: THEN
158: FND_MSG_PUB.initialize;
159: END IF;
160:

Line 162: x_return_status := FND_API.g_ret_sts_success;

158: FND_MSG_PUB.initialize;
159: END IF;
160:
161: --- Initialize API return status to success
162: x_return_status := FND_API.g_ret_sts_success;
163:
164: --- check for existence of the object id
165: l_object_type := trim(p_object_type);
166:

Line 171: IF FND_API.to_boolean(p_commit)

167: IF l_object_type = 'I' AND
168: p_lgl_ctnt_rec.obj_lgl_ctnt_id IS NULL AND
169: p_lgl_ctnt_rec.deliverable_id IS NULL
170: THEN
171: IF FND_API.to_boolean(p_commit)
172: THEN
173: COMMIT;
174: END IF;
175:

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS;

172: THEN
173: COMMIT;
174: END IF;
175:
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: FND_MSG_PUB.count_and_get(
179: p_encoded => FND_API.g_false,
180: p_count => x_msg_count,

Line 179: p_encoded => FND_API.g_false,

175:
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: FND_MSG_PUB.count_and_get(
179: p_encoded => FND_API.g_false,
180: p_count => x_msg_count,
181: p_data => x_msg_data );
182:
183: RETURN;

Line 189: RAISE FND_API.g_exc_error;

185:
186: IF ibe_dspmgrvalidation_grp.check_lgl_object_exists(
187: p_object_type,p_lgl_ctnt_rec.object_id) = false
188: THEN
189: RAISE FND_API.g_exc_error;
190: END IF;
191:
192: --- check if the context exists
193: IF p_lgl_ctnt_rec.context_id IS NOT NULL OR

Line 194: p_lgl_ctnt_rec.context_id <> FND_API.g_miss_num

190: END IF;
191:
192: --- check if the context exists
193: IF p_lgl_ctnt_rec.context_id IS NOT NULL OR
194: p_lgl_ctnt_rec.context_id <> FND_API.g_miss_num
195: THEN
196: l_context_type := ibe_dspmgrvalidation_grp.check_context_type_code(
197: p_lgl_ctnt_rec.context_id);
198:

Line 201: RAISE FND_API.g_exc_error;

197: p_lgl_ctnt_rec.context_id);
198:
199: IF l_context_type IS NULL
200: THEN
201: RAISE FND_API.g_exc_error;
202: END IF;
203: ELSE
204: RAISE ibe_dspmgrvalidation_grp.context_req_exception;
205: END IF;

Line 237: RAISE FND_API.g_exc_error;

233: p_lgl_ctnt_rec.deliverable_id,
234: l_context_type,
235: l_applicable_to) = false
236: THEN
237: RAISE FND_API.g_exc_error;
238: END IF;
239:
240: END IF;
241:

Line 251: RAISE FND_API.g_exc_error;

247: IF ibe_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(
248: p_lgl_ctnt_rec.obj_lgl_ctnt_id,
249: p_lgl_ctnt_rec.object_version_number) = false
250: THEN
251: RAISE FND_API.g_exc_error;
252: END IF;
253:
254: DELETE FROM IBE_DSP_OBJ_LGL_ctnt
255: WHERE obj_lgl_ctnt_id = p_lgl_ctnt_rec.obj_lgl_ctnt_id

Line 295: RAISE FND_API.g_exc_error;

291: IF ibe_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(
292: p_lgl_ctnt_rec.obj_lgl_ctnt_id,
293: p_lgl_ctnt_rec.object_version_number) = false
294: THEN
295: RAISE FND_API.g_exc_error;
296: END IF;
297:
298: UPDATE IBE_DSP_OBJ_LGL_CTNT
299: SET LAST_UPDATE_DATE = SYSDATE,

Line 314: IF FND_API.to_boolean(p_commit)

310: END IF;
311: --- Check if the caller requested to commit ,
312: --- If p_commit set to true, commit the transaction
313:
314: IF FND_API.to_boolean(p_commit)
315: THEN
316: COMMIT;
317: END IF;
318:

Line 319: x_return_status := FND_API.G_RET_STS_SUCCESS;

315: THEN
316: COMMIT;
317: END IF;
318:
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: FND_MSG_PUB.count_and_get(
322: p_encoded => FND_API.g_false,
323: p_count => x_msg_count,

Line 322: p_encoded => FND_API.g_false,

318:
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: FND_MSG_PUB.count_and_get(
322: p_encoded => FND_API.g_false,
323: p_count => x_msg_count,
324: p_data => x_msg_data );
325: EXCEPTION
326: WHEN FND_API.g_exc_error THEN

Line 326: WHEN FND_API.g_exc_error THEN

322: p_encoded => FND_API.g_false,
323: p_count => x_msg_count,
324: p_data => x_msg_data );
325: EXCEPTION
326: WHEN FND_API.g_exc_error THEN
327: ROLLBACK TO save_logical_content;
328: x_return_status := FND_API.g_ret_sts_error;
329: FND_MSG_PUB.count_and_get(
330: p_encoded => FND_API.g_false,

Line 328: x_return_status := FND_API.g_ret_sts_error;

324: p_data => x_msg_data );
325: EXCEPTION
326: WHEN FND_API.g_exc_error THEN
327: ROLLBACK TO save_logical_content;
328: x_return_status := FND_API.g_ret_sts_error;
329: FND_MSG_PUB.count_and_get(
330: p_encoded => FND_API.g_false,
331: p_count => x_msg_count,
332: p_data => x_msg_data );

Line 330: p_encoded => FND_API.g_false,

326: WHEN FND_API.g_exc_error THEN
327: ROLLBACK TO save_logical_content;
328: x_return_status := FND_API.g_ret_sts_error;
329: FND_MSG_PUB.count_and_get(
330: p_encoded => FND_API.g_false,
331: p_count => x_msg_count,
332: p_data => x_msg_data );
333:
334: WHEN DUP_VAL_ON_INDEX THEN

Line 336: x_return_status := FND_API.g_ret_sts_error ;

332: p_data => x_msg_data );
333:
334: WHEN DUP_VAL_ON_INDEX THEN
335: ROLLBACK TO save_logical_content;
336: x_return_status := FND_API.g_ret_sts_error ;
337: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_ROW_EXISTS');
338: FND_MESSAGE.set_token('ID', p_lgl_ctnt_rec.object_id);
339: FND_MESSAGE.set_token('TYPE', p_object_type);
340: FND_MESSAGE.set_token('CTX_ID', p_lgl_ctnt_rec.context_id);

Line 343: p_encoded => FND_API.g_false,

339: FND_MESSAGE.set_token('TYPE', p_object_type);
340: FND_MESSAGE.set_token('CTX_ID', p_lgl_ctnt_rec.context_id);
341: FND_MSG_PUB.ADD;
342: FND_MSG_PUB.count_and_get(
343: p_encoded => FND_API.g_false,
344: p_count => x_msg_count,
345: p_data => x_msg_data );
346:
347: WHEN FND_API.g_exc_unexpected_error THEN

Line 347: WHEN FND_API.g_exc_unexpected_error THEN

343: p_encoded => FND_API.g_false,
344: p_count => x_msg_count,
345: p_data => x_msg_data );
346:
347: WHEN FND_API.g_exc_unexpected_error THEN
348: ROLLBACK TO save_logical_content;
349: x_return_status := FND_API.g_ret_sts_error ;
350: FND_MSG_PUB.count_and_get(
351: p_encoded => FND_API.g_false,

Line 349: x_return_status := FND_API.g_ret_sts_error ;

345: p_data => x_msg_data );
346:
347: WHEN FND_API.g_exc_unexpected_error THEN
348: ROLLBACK TO save_logical_content;
349: x_return_status := FND_API.g_ret_sts_error ;
350: FND_MSG_PUB.count_and_get(
351: p_encoded => FND_API.g_false,
352: p_count => x_msg_count,
353: p_data => x_msg_data );

Line 351: p_encoded => FND_API.g_false,

347: WHEN FND_API.g_exc_unexpected_error THEN
348: ROLLBACK TO save_logical_content;
349: x_return_status := FND_API.g_ret_sts_error ;
350: FND_MSG_PUB.count_and_get(
351: p_encoded => FND_API.g_false,
352: p_count => x_msg_count,
353: p_data => x_msg_data );
354:
355: WHEN ibe_dspmgrvalidation_grp.context_req_exception THEN

Line 357: x_return_status := FND_API.g_ret_sts_unexp_error ;

353: p_data => x_msg_data );
354:
355: WHEN ibe_dspmgrvalidation_grp.context_req_exception THEN
356: ROLLBACK TO save_logical_content;
357: x_return_status := FND_API.g_ret_sts_unexp_error ;
358: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
359: THEN
360: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_REQ');
361: FND_MSG_PUB.ADD;

Line 364: p_encoded => FND_API.g_false,

360: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_REQ');
361: FND_MSG_PUB.ADD;
362: END IF;
363: FND_MSG_PUB.count_and_get(
364: p_encoded => FND_API.g_false,
365: p_count => x_msg_count,
366: p_data => x_msg_data );
367:
368: WHEN OTHERS THEN

Line 370: x_return_status := FND_API.g_ret_sts_unexp_error ;

366: p_data => x_msg_data );
367:
368: WHEN OTHERS THEN
369: ROLLBACK TO save_logical_content;
370: x_return_status := FND_API.g_ret_sts_unexp_error ;
371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
372: THEN
373: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
374: END IF;

Line 376: p_encoded => FND_API.g_false,

372: THEN
373: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
374: END IF;
375: FND_MSG_PUB.count_and_get(
376: p_encoded => FND_API.g_false,
377: p_count => x_msg_count,
378: p_data => x_msg_data );
379: END save_logical_content;
380:

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

379: END save_logical_content;
380:
381: PROCEDURE save_delete_lgl_ctnt(
382: p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
384: p_commit IN VARCHAR2 := FND_API.g_false,
385: x_return_status OUT NOCOPY VARCHAR2,
386: x_msg_count OUT NOCOPY NUMBER,
387: x_msg_data OUT NOCOPY VARCHAR2,

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

380:
381: PROCEDURE save_delete_lgl_ctnt(
382: p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
384: p_commit IN VARCHAR2 := FND_API.g_false,
385: x_return_status OUT NOCOPY VARCHAR2,
386: x_msg_count OUT NOCOPY NUMBER,
387: x_msg_data OUT NOCOPY VARCHAR2,
388: p_object_type_code IN VARCHAR2,

Line 404: IF NOT FND_API.compatible_api_call(

400: BEGIN
401: --------------------- initialize -----------------------+
402: SAVEPOINT save_delete_itm_lgl_ctnt;
403:
404: IF NOT FND_API.compatible_api_call(
405: g_api_version,
406: p_api_version,
407: l_api_name,
408: g_pkg_name )

Line 410: RAISE FND_API.g_exc_unexpected_error;

406: p_api_version,
407: l_api_name,
408: g_pkg_name )
409: THEN
410: RAISE FND_API.g_exc_unexpected_error;
411: END IF;
412:
413: IF FND_API.to_boolean(p_init_msg_list)
414: THEN

Line 413: IF FND_API.to_boolean(p_init_msg_list)

409: THEN
410: RAISE FND_API.g_exc_unexpected_error;
411: END IF;
412:
413: IF FND_API.to_boolean(p_init_msg_list)
414: THEN
415: FND_MSG_PUB.initialize;
416: END IF;
417:

Line 419: x_return_status := FND_API.g_ret_sts_success;

415: FND_MSG_PUB.initialize;
416: END IF;
417:
418: --- Initialize API return status to success
419: x_return_status := FND_API.g_ret_sts_success;
420:
421: IF ibe_dspmgrvalidation_grp.check_valid_object_type(
422: p_object_type_code) = false
423: THEN

Line 424: RAISE FND_API.g_exc_error;

420:
421: IF ibe_dspmgrvalidation_grp.check_valid_object_type(
422: p_object_type_code) = false
423: THEN
424: RAISE FND_API.g_exc_error;
425: END IF;
426:
427: FOR l_index IN 1..p_lgl_ctnt_tbl.COUNT
428: LOOP

Line 429: IF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_true

425: END IF;
426:
427: FOR l_index IN 1..p_lgl_ctnt_tbl.COUNT
428: LOOP
429: IF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_true
430: THEN
431: delete_logical_content(
432: p_api_version,
433: FND_API.g_false,

Line 433: FND_API.g_false,

429: IF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_true
430: THEN
431: delete_logical_content(
432: p_api_version,
433: FND_API.g_false,
434: FND_API.g_false,
435: l_return_status,
436: l_msg_count,
437: l_msg_data,

Line 434: FND_API.g_false,

430: THEN
431: delete_logical_content(
432: p_api_version,
433: FND_API.g_false,
434: FND_API.g_false,
435: l_return_status,
436: l_msg_count,
437: l_msg_data,
438: p_object_type_code,

Line 441: ELSIF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_false

437: l_msg_data,
438: p_object_type_code,
439: p_lgl_ctnt_tbl(l_index));
440:
441: ELSIF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_false
442: THEN
443: save_logical_content(
444: p_api_version,
445: FND_API.g_false,

Line 445: FND_API.g_false,

441: ELSIF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_false
442: THEN
443: save_logical_content(
444: p_api_version,
445: FND_API.g_false,
446: p_commit,
447: l_return_status,
448: l_msg_count,
449: l_msg_data,

Line 454: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

450: p_object_type_code,
451: p_lgl_ctnt_tbl(l_index));
452: END IF;
453:
454: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
455: THEN
456: x_return_status := l_return_status;
457: END IF;
458: END LOOP;

Line 461: p_encoded => FND_API.g_false,

457: END IF;
458: END LOOP;
459:
460: FND_MSG_PUB.count_and_get(
461: p_encoded => FND_API.g_false,
462: p_count => x_msg_count,
463: p_data => x_msg_data );
464: EXCEPTION
465: WHEN FND_API.g_exc_error THEN

Line 465: WHEN FND_API.g_exc_error THEN

461: p_encoded => FND_API.g_false,
462: p_count => x_msg_count,
463: p_data => x_msg_data );
464: EXCEPTION
465: WHEN FND_API.g_exc_error THEN
466: ROLLBACK TO save_delete_itm_lgl_ctnt;
467: x_return_status := FND_API.g_ret_sts_error;
468: FND_MSG_PUB.count_and_get(
469: p_encoded => FND_API.g_false,

Line 467: x_return_status := FND_API.g_ret_sts_error;

463: p_data => x_msg_data );
464: EXCEPTION
465: WHEN FND_API.g_exc_error THEN
466: ROLLBACK TO save_delete_itm_lgl_ctnt;
467: x_return_status := FND_API.g_ret_sts_error;
468: FND_MSG_PUB.count_and_get(
469: p_encoded => FND_API.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data );

Line 469: p_encoded => FND_API.g_false,

465: WHEN FND_API.g_exc_error THEN
466: ROLLBACK TO save_delete_itm_lgl_ctnt;
467: x_return_status := FND_API.g_ret_sts_error;
468: FND_MSG_PUB.count_and_get(
469: p_encoded => FND_API.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data );
472:
473: WHEN FND_API.g_exc_unexpected_error THEN

Line 473: WHEN FND_API.g_exc_unexpected_error THEN

469: p_encoded => FND_API.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data );
472:
473: WHEN FND_API.g_exc_unexpected_error THEN
474: ROLLBACK TO save_delete_itm_lgl_ctnt;
475: x_return_status := FND_API.g_ret_sts_error ;
476: FND_MSG_PUB.count_and_get(
477: p_encoded => FND_API.g_false,

Line 475: x_return_status := FND_API.g_ret_sts_error ;

471: p_data => x_msg_data );
472:
473: WHEN FND_API.g_exc_unexpected_error THEN
474: ROLLBACK TO save_delete_itm_lgl_ctnt;
475: x_return_status := FND_API.g_ret_sts_error ;
476: FND_MSG_PUB.count_and_get(
477: p_encoded => FND_API.g_false,
478: p_count => x_msg_count,
479: p_data => x_msg_data );

Line 477: p_encoded => FND_API.g_false,

473: WHEN FND_API.g_exc_unexpected_error THEN
474: ROLLBACK TO save_delete_itm_lgl_ctnt;
475: x_return_status := FND_API.g_ret_sts_error ;
476: FND_MSG_PUB.count_and_get(
477: p_encoded => FND_API.g_false,
478: p_count => x_msg_count,
479: p_data => x_msg_data );
480:
481: WHEN OTHERS THEN

Line 483: x_return_status := FND_API.g_ret_sts_unexp_error ;

479: p_data => x_msg_data );
480:
481: WHEN OTHERS THEN
482: ROLLBACK TO save_delete_itm_lgl_ctnt;
483: x_return_status := FND_API.g_ret_sts_unexp_error ;
484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
485: THEN
486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
487: END IF;

Line 489: p_encoded => FND_API.g_false,

485: THEN
486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
487: END IF;
488: FND_MSG_PUB.count_and_get(
489: p_encoded => FND_API.g_false,
490: p_count => x_msg_count,
491: p_data => x_msg_data );
492: END save_delete_lgl_ctnt;
493:

Line 503: RAISE FND_API.g_exc_error;

499:
500: IF ibe_dspmgrvalidation_grp.check_section_exists(
501: p_section_id) = false
502: THEN
503: RAISE FND_API.g_exc_error;
504: END IF;
505:
506: DELETE FROM IBE_DSP_OBJ_LGL_ctnt
507: WHERE OBJECT_TYPE = 'S'