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

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

9:
10:
11: PROCEDURE delete_logical_content(
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
14: p_commit IN VARCHAR2 := FND_API.g_false,
15: x_return_status OUT VARCHAR2,
16: x_msg_count OUT NUMBER,
17: x_msg_data OUT VARCHAR2,

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

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

Line 35: IF NOT FND_API.compatible_api_call(

31: SAVEPOINT delete_logical_content;
32:
33: --dbms_output.put_line('delete_logical_content: checking the object existence');
34:
35: IF NOT FND_API.compatible_api_call(
36: g_api_version,
37: p_api_version,
38: l_api_name,
39: g_pkg_name

Line 41: RAISE FND_API.g_exc_unexpected_error;

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

Line 44: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44: IF FND_API.to_boolean(p_init_msg_list) 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 56: raise FND_API.g_exc_error;

52: --- Check if the object logical content exists
53:
54: if jtf_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(p_lgl_ctnt_rec.obj_lgl_ctnt_id,
55: p_lgl_ctnt_rec.object_version_number) = false then
56: raise FND_API.g_exc_error;
57: end if;
58:
59: --dbms_output.put_line('delete_logical_content: passed the object existence');
60:

Line 71: IF FND_API.to_boolean(p_commit) THEN

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

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: IF FND_API.to_boolean(p_commit) 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: );
82:

Line 85: WHEN FND_API.g_exc_error THEN

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

Line 87: x_return_status := FND_API.g_ret_sts_error;

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

Line 89: p_encoded => FND_API.g_false,

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

Line 94: WHEN FND_API.g_exc_unexpected_error THEN

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

Line 96: x_return_status := FND_API.g_ret_sts_error ;

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

Line 98: p_encoded => FND_API.g_false,

94: WHEN FND_API.g_exc_unexpected_error THEN
95: ROLLBACK TO delete_logical_content;
96: x_return_status := FND_API.g_ret_sts_error ;
97: FND_MSG_PUB.count_and_get(
98: p_encoded => FND_API.g_false,
99: p_count => x_msg_count,
100: p_data => x_msg_data
101: );
102:

Line 106: x_return_status := FND_API.g_ret_sts_error;

102:
103:
104: WHEN jtf_dspmgrvalidation_grp.lglctnt_id_req_exception THEN
105: ROLLBACK TO delete_logical_content;
106: x_return_status := FND_API.g_ret_sts_error;
107: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_REQ');
108: FND_MSG_PUB.ADD;
109: FND_MSG_PUB.count_and_get(
110: p_encoded => FND_API.g_false,

Line 110: p_encoded => FND_API.g_false,

106: x_return_status := FND_API.g_ret_sts_error;
107: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_REQ');
108: FND_MSG_PUB.ADD;
109: FND_MSG_PUB.count_and_get(
110: p_encoded => FND_API.g_false,
111: p_count => x_msg_count,
112: p_data => x_msg_data
113: );
114:

Line 117: x_return_status := FND_API.g_ret_sts_unexp_error ;

113: );
114:
115: WHEN OTHERS THEN
116: ROLLBACK TO delete_logical_content;
117: x_return_status := FND_API.g_ret_sts_unexp_error ;
118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
119: THEN
120: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
121: END IF;

Line 123: p_encoded => FND_API.g_false,

119: THEN
120: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
121: END IF;
122: FND_MSG_PUB.count_and_get(
123: p_encoded => FND_API.g_false,
124: p_count => x_msg_count,
125: p_data => x_msg_data
126: );
127:

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

129:
130:
131: PROCEDURE save_logical_content(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
134: p_commit IN VARCHAR2 := FND_API.g_false,
135: x_return_status OUT VARCHAR2,
136: x_msg_count OUT NUMBER,
137: x_msg_data OUT VARCHAR2,

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

130:
131: PROCEDURE save_logical_content(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
134: p_commit IN VARCHAR2 := FND_API.g_false,
135: x_return_status OUT VARCHAR2,
136: x_msg_count OUT NUMBER,
137: x_msg_data OUT VARCHAR2,
138: p_object_type IN VARCHAR2,

Line 159: IF NOT FND_API.compatible_api_call(

155:
156: --------------------- initialize -----------------------
157: SAVEPOINT save_logical_content;
158:
159: IF NOT FND_API.compatible_api_call(
160: g_api_version,
161: p_api_version,
162: l_api_name,
163: g_pkg_name

Line 165: RAISE FND_API.g_exc_unexpected_error;

161: p_api_version,
162: l_api_name,
163: g_pkg_name
164: ) THEN
165: RAISE FND_API.g_exc_unexpected_error;
166: END IF;
167:
168:
169: --dbms_output.put_line('save_logical_content: checking the object existence');

Line 171: IF FND_API.to_boolean(p_init_msg_list) THEN

167:
168:
169: --dbms_output.put_line('save_logical_content: checking the object existence');
170:
171: IF FND_API.to_boolean(p_init_msg_list) THEN
172: FND_MSG_PUB.initialize;
173: END IF;
174:
175:

Line 177: x_return_status := FND_API.g_ret_sts_success;

173: END IF;
174:
175:
176: --- Initialize API return status to success
177: x_return_status := FND_API.g_ret_sts_success;
178:
179: --- check for existence of the object id
180:
181: l_object_type := trim(p_object_type);

Line 190: IF FND_API.to_boolean(p_commit) THEN

186: if l_object_type = 'I' and
187: p_lgl_ctnt_rec.obj_lgl_ctnt_id is null and
188: p_lgl_ctnt_rec.deliverable_id is null
189: then
190: IF FND_API.to_boolean(p_commit) THEN
191: COMMIT;
192: END IF;
193:
194: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 194: x_return_status := FND_API.G_RET_STS_SUCCESS;

190: IF FND_API.to_boolean(p_commit) THEN
191: COMMIT;
192: END IF;
193:
194: x_return_status := FND_API.G_RET_STS_SUCCESS;
195:
196: FND_MSG_PUB.count_and_get(
197: p_encoded => FND_API.g_false,
198: p_count => x_msg_count,

Line 197: p_encoded => FND_API.g_false,

193:
194: x_return_status := FND_API.G_RET_STS_SUCCESS;
195:
196: FND_MSG_PUB.count_and_get(
197: p_encoded => FND_API.g_false,
198: p_count => x_msg_count,
199: p_data => x_msg_data
200: );
201:

Line 210: raise FND_API.g_exc_error;

206:
207: --dbms_output.put_line('save_logical_content: checking the object existence and id ');
208:
209: if jtf_dspmgrvalidation_grp.check_lgl_object_exists(p_object_type,p_lgl_ctnt_rec.object_id) = false then
210: raise FND_API.g_exc_error;
211: end if;
212:
213: --dbms_output.put_line('save_logical_content: passed the object existence');
214: --- check if the context exists

Line 216: if p_lgl_ctnt_rec.context_id is not null or p_lgl_ctnt_rec.context_id <> FND_API.g_miss_num

212:
213: --dbms_output.put_line('save_logical_content: passed the object existence');
214: --- check if the context exists
215:
216: if p_lgl_ctnt_rec.context_id is not null or p_lgl_ctnt_rec.context_id <> FND_API.g_miss_num
217: then
218:
219: l_context_type := jtf_dspmgrvalidation_grp.check_context_type_code(p_lgl_ctnt_rec.context_id);
220:

Line 224: raise FND_API.g_exc_error;

220:
221: --dbms_output.put_line('save_logical_content: passed the context_type validation');
222:
223: if l_context_type is NULL then
224: raise FND_API.g_exc_error;
225: end if;
226:
227: else
228: raise jtf_dspmgrvalidation_grp.context_req_exception;

Line 257: raise FND_API.g_exc_error;

253:
254: if jtf_dspmgrvalidation_grp.check_deliverable_type_exists(p_lgl_ctnt_rec.deliverable_id, l_context_type,
255: l_applicable_to) = false
256: then
257: raise FND_API.g_exc_error;
258: end if;
259: --dbms_output.put_line('save_logical_content: passed checking for deliverable type_exists ');
260:
261: if l_context_type = 'TEMPLATE'

Line 270: raise FND_API.g_exc_error;

266: --- belongs to , otherwise raise an exception
267:
268: if jtf_dspmgrvalidation_grp.check_item_deliverable(p_lgl_ctnt_rec.object_id,p_lgl_ctnt_rec.deliverable_id) = false
269: then
270: raise FND_API.g_exc_error;
271: end if;
272: elsif(l_object_type = 'C') then
273: --- Make sure that the deliverable id is associated to the category
274: --- , otherwise raise an exception

Line 278: raise FND_API.g_exc_error;

274: --- , otherwise raise an exception
275:
276: if jtf_dspmgrvalidation_grp.check_category_deliverable(p_lgl_ctnt_rec.object_id,p_lgl_ctnt_rec.deliverable_id) = false
277: then
278: raise FND_API.g_exc_error;
279: end if;
280:
281: end if;
282: end if;

Line 294: raise FND_API.g_exc_error;

290: --- Check if the object logical content id exists
291:
292: if jtf_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(p_lgl_ctnt_rec.obj_lgl_ctnt_id,
293: p_lgl_ctnt_rec.object_version_number) = false then
294: raise FND_API.g_exc_error;
295: end if;
296: delete from JTF_DSP_OBJ_LGL_CTNT where
297: obj_lgl_ctnt_id = p_lgl_ctnt_rec.obj_lgl_ctnt_id and
298: object_version_number = p_lgl_ctnt_rec.object_version_number and

Line 340: raise FND_API.g_exc_error;

336: --- Check if the object logical content id exists
337:
338: if jtf_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(p_lgl_ctnt_rec.obj_lgl_ctnt_id,
339: p_lgl_ctnt_rec.object_version_number) = false then
340: raise FND_API.g_exc_error;
341: end if;
342:
343: UPDATE JTF_DSP_OBJ_LGL_CTNT SET
344: LAST_UPDATE_DATE = SYSDATE,

Line 361: IF FND_API.to_boolean(p_commit) THEN

357: END IF;
358: --- Check if the caller requested to commit ,
359: --- If p_commit set to true, commit the transaction
360:
361: IF FND_API.to_boolean(p_commit) THEN
362: COMMIT;
363: END IF;
364:
365: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 365: x_return_status := FND_API.G_RET_STS_SUCCESS;

361: IF FND_API.to_boolean(p_commit) THEN
362: COMMIT;
363: END IF;
364:
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366:
367: FND_MSG_PUB.count_and_get(
368: p_encoded => FND_API.g_false,
369: p_count => x_msg_count,

Line 368: p_encoded => FND_API.g_false,

364:
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366:
367: FND_MSG_PUB.count_and_get(
368: p_encoded => FND_API.g_false,
369: p_count => x_msg_count,
370: p_data => x_msg_data
371: );
372:

Line 375: WHEN FND_API.g_exc_error THEN

371: );
372:
373: EXCEPTION
374:
375: WHEN FND_API.g_exc_error THEN
376: ROLLBACK TO save_logical_content;
377: x_return_status := FND_API.g_ret_sts_error;
378: FND_MSG_PUB.count_and_get(
379: p_encoded => FND_API.g_false,

Line 377: x_return_status := FND_API.g_ret_sts_error;

373: EXCEPTION
374:
375: WHEN FND_API.g_exc_error THEN
376: ROLLBACK TO save_logical_content;
377: x_return_status := FND_API.g_ret_sts_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: WHEN FND_API.g_exc_error THEN
376: ROLLBACK TO save_logical_content;
377: x_return_status := FND_API.g_ret_sts_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: );
383:

Line 386: x_return_status := FND_API.g_ret_sts_error ;

382: );
383:
384: WHEN DUP_VAL_ON_INDEX THEN
385: ROLLBACK TO save_logical_content;
386: x_return_status := FND_API.g_ret_sts_error ;
387: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ROW_EXISTS');
388: FND_MESSAGE.set_token('ID', p_lgl_ctnt_rec.object_id);
389: FND_MESSAGE.set_token('TYPE', p_object_type);
390: FND_MESSAGE.set_token('CTX_ID', p_lgl_ctnt_rec.context_id);

Line 393: p_encoded => FND_API.g_false,

389: FND_MESSAGE.set_token('TYPE', p_object_type);
390: FND_MESSAGE.set_token('CTX_ID', p_lgl_ctnt_rec.context_id);
391: FND_MSG_PUB.ADD;
392: FND_MSG_PUB.count_and_get(
393: p_encoded => FND_API.g_false,
394: p_count => x_msg_count,
395: p_data => x_msg_data
396: );
397: WHEN FND_API.g_exc_unexpected_error THEN

Line 397: WHEN FND_API.g_exc_unexpected_error THEN

393: p_encoded => FND_API.g_false,
394: p_count => x_msg_count,
395: p_data => x_msg_data
396: );
397: WHEN FND_API.g_exc_unexpected_error THEN
398: ROLLBACK TO save_logical_content;
399: x_return_status := FND_API.g_ret_sts_error ;
400: FND_MSG_PUB.count_and_get(
401: p_encoded => FND_API.g_false,

Line 399: x_return_status := FND_API.g_ret_sts_error ;

395: p_data => x_msg_data
396: );
397: WHEN FND_API.g_exc_unexpected_error THEN
398: ROLLBACK TO save_logical_content;
399: x_return_status := FND_API.g_ret_sts_error ;
400: FND_MSG_PUB.count_and_get(
401: p_encoded => FND_API.g_false,
402: p_count => x_msg_count,
403: p_data => x_msg_data

Line 401: p_encoded => FND_API.g_false,

397: WHEN FND_API.g_exc_unexpected_error THEN
398: ROLLBACK TO save_logical_content;
399: x_return_status := FND_API.g_ret_sts_error ;
400: FND_MSG_PUB.count_and_get(
401: p_encoded => FND_API.g_false,
402: p_count => x_msg_count,
403: p_data => x_msg_data
404: );
405: WHEN jtf_dspmgrvalidation_grp.context_req_exception THEN

Line 407: x_return_status := FND_API.g_ret_sts_unexp_error ;

403: p_data => x_msg_data
404: );
405: WHEN jtf_dspmgrvalidation_grp.context_req_exception THEN
406: ROLLBACK TO save_logical_content;
407: x_return_status := FND_API.g_ret_sts_unexp_error ;
408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
409: THEN
410: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_REQ');
411: FND_MSG_PUB.ADD;

Line 414: p_encoded => FND_API.g_false,

410: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_REQ');
411: FND_MSG_PUB.ADD;
412: END IF;
413: FND_MSG_PUB.count_and_get(
414: p_encoded => FND_API.g_false,
415: p_count => x_msg_count,
416: p_data => x_msg_data
417: );
418:

Line 421: x_return_status := FND_API.g_ret_sts_unexp_error ;

417: );
418:
419: WHEN OTHERS THEN
420: ROLLBACK TO save_logical_content;
421: x_return_status := FND_API.g_ret_sts_unexp_error ;
422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
423: THEN
424: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
425: END IF;

Line 427: p_encoded => FND_API.g_false,

423: THEN
424: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
425: END IF;
426: FND_MSG_PUB.count_and_get(
427: p_encoded => FND_API.g_false,
428: p_count => x_msg_count,
429: p_data => x_msg_data
430: );
431:

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

433:
434:
435: PROCEDURE save_delete_lgl_ctnt(
436: p_api_version IN NUMBER,
437: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
438: p_commit IN VARCHAR2 := FND_API.g_false,
439: x_return_status OUT VARCHAR2,
440: x_msg_count OUT NUMBER,
441: x_msg_data OUT VARCHAR2,

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

434:
435: PROCEDURE save_delete_lgl_ctnt(
436: p_api_version IN NUMBER,
437: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
438: p_commit IN VARCHAR2 := FND_API.g_false,
439: x_return_status OUT VARCHAR2,
440: x_msg_count OUT NUMBER,
441: x_msg_data OUT VARCHAR2,
442: p_object_type_code IN VARCHAR2,

Line 461: IF NOT FND_API.compatible_api_call(

457:
458: --------------------- initialize -----------------------
459: SAVEPOINT save_delete_itm_lgl_ctnt;
460:
461: IF NOT FND_API.compatible_api_call(
462: g_api_version,
463: p_api_version,
464: l_api_name,
465: g_pkg_name

Line 467: RAISE FND_API.g_exc_unexpected_error;

463: p_api_version,
464: l_api_name,
465: g_pkg_name
466: ) THEN
467: RAISE FND_API.g_exc_unexpected_error;
468: END IF;
469:
470:
471: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 471: IF FND_API.to_boolean(p_init_msg_list) THEN

467: RAISE FND_API.g_exc_unexpected_error;
468: END IF;
469:
470:
471: IF FND_API.to_boolean(p_init_msg_list) THEN
472: FND_MSG_PUB.initialize;
473: END IF;
474:
475:

Line 477: x_return_status := FND_API.g_ret_sts_success;

473: END IF;
474:
475:
476: --- Initialize API return status to success
477: x_return_status := FND_API.g_ret_sts_success;
478:
479:
480: --dbms_output.put_line('PASSED THE VERSION NUMBER TEST:' || p_object_type_code || ':' || length(p_object_type_code));
481:

Line 483: raise FND_API.g_exc_error;

479:
480: --dbms_output.put_line('PASSED THE VERSION NUMBER TEST:' || p_object_type_code || ':' || length(p_object_type_code));
481:
482: if jtf_dspmgrvalidation_grp.check_valid_object_type(p_object_type_code) = false then
483: raise FND_API.g_exc_error;
484: end if;
485:
486:
487: --dbms_output.put_line('PASSED THE TYPE TEST');

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

489:
490: FOR l_index IN 1..p_lgl_ctnt_tbl.COUNT
491: LOOP
492: ---
493: IF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_true
494: then
495:
496: --dbms_output.put_line('CALLING DELETE_LOGICAL_CONTENT');
497: delete_logical_content(

Line 499: FND_API.g_false,

495:
496: --dbms_output.put_line('CALLING DELETE_LOGICAL_CONTENT');
497: delete_logical_content(
498: p_api_version,
499: FND_API.g_false,
500: FND_API.g_false,
501: l_return_status,
502: l_msg_count,
503: l_msg_data,

Line 500: FND_API.g_false,

496: --dbms_output.put_line('CALLING DELETE_LOGICAL_CONTENT');
497: delete_logical_content(
498: p_api_version,
499: FND_API.g_false,
500: FND_API.g_false,
501: l_return_status,
502: l_msg_count,
503: l_msg_data,
504: p_object_type_code,

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

503: l_msg_data,
504: p_object_type_code,
505: p_lgl_ctnt_tbl(l_index));
506:
507: ELSIF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_false
508: then
509:
510: --dbms_output.put_line('CALLING SAVE_LOGICAL_CONTENT');
511: save_logical_content(

Line 513: FND_API.g_false,

509:
510: --dbms_output.put_line('CALLING SAVE_LOGICAL_CONTENT');
511: save_logical_content(
512: p_api_version,
513: FND_API.g_false,
514: FND_API.g_false,
515: l_return_status,
516: l_msg_count,
517: l_msg_data,

Line 514: FND_API.g_false,

510: --dbms_output.put_line('CALLING SAVE_LOGICAL_CONTENT');
511: save_logical_content(
512: p_api_version,
513: FND_API.g_false,
514: FND_API.g_false,
515: l_return_status,
516: l_msg_count,
517: l_msg_data,
518: p_object_type_code,

Line 524: if l_return_status <> FND_API.G_RET_STS_SUCCESS

520: END IF;
521:
522: --dbms_output.put_line('CALLED LOGICAL_CONTENT' || l_return_status );
523:
524: if l_return_status <> FND_API.G_RET_STS_SUCCESS
525: then
526: --dbms_output.put_line('retirn status from save' || l_return_status);
527: x_return_status := l_return_status;
528: end if;

Line 535: p_encoded => FND_API.g_false,

531: END LOOP;
532:
533:
534: FND_MSG_PUB.count_and_get(
535: p_encoded => FND_API.g_false,
536: p_count => x_msg_count,
537: p_data => x_msg_data
538: );
539:

Line 542: WHEN FND_API.g_exc_error THEN

538: );
539:
540: EXCEPTION
541:
542: WHEN FND_API.g_exc_error THEN
543: ROLLBACK TO save_delete_itm_lgl_ctnt;
544: x_return_status := FND_API.g_ret_sts_error;
545: FND_MSG_PUB.count_and_get(
546: p_encoded => FND_API.g_false,

Line 544: x_return_status := FND_API.g_ret_sts_error;

540: EXCEPTION
541:
542: WHEN FND_API.g_exc_error THEN
543: ROLLBACK TO save_delete_itm_lgl_ctnt;
544: x_return_status := FND_API.g_ret_sts_error;
545: FND_MSG_PUB.count_and_get(
546: p_encoded => FND_API.g_false,
547: p_count => x_msg_count,
548: p_data => x_msg_data

Line 546: p_encoded => FND_API.g_false,

542: WHEN FND_API.g_exc_error THEN
543: ROLLBACK TO save_delete_itm_lgl_ctnt;
544: x_return_status := FND_API.g_ret_sts_error;
545: FND_MSG_PUB.count_and_get(
546: p_encoded => FND_API.g_false,
547: p_count => x_msg_count,
548: p_data => x_msg_data
549: );
550:

Line 551: WHEN FND_API.g_exc_unexpected_error THEN

547: p_count => x_msg_count,
548: p_data => x_msg_data
549: );
550:
551: WHEN FND_API.g_exc_unexpected_error THEN
552: ROLLBACK TO save_delete_itm_lgl_ctnt;
553: x_return_status := FND_API.g_ret_sts_error ;
554: FND_MSG_PUB.count_and_get(
555: p_encoded => FND_API.g_false,

Line 553: x_return_status := FND_API.g_ret_sts_error ;

549: );
550:
551: WHEN FND_API.g_exc_unexpected_error THEN
552: ROLLBACK TO save_delete_itm_lgl_ctnt;
553: x_return_status := FND_API.g_ret_sts_error ;
554: FND_MSG_PUB.count_and_get(
555: p_encoded => FND_API.g_false,
556: p_count => x_msg_count,
557: p_data => x_msg_data

Line 555: p_encoded => FND_API.g_false,

551: WHEN FND_API.g_exc_unexpected_error THEN
552: ROLLBACK TO save_delete_itm_lgl_ctnt;
553: x_return_status := FND_API.g_ret_sts_error ;
554: FND_MSG_PUB.count_and_get(
555: p_encoded => FND_API.g_false,
556: p_count => x_msg_count,
557: p_data => x_msg_data
558: );
559:

Line 563: x_return_status := FND_API.g_ret_sts_unexp_error ;

559:
560:
561: WHEN OTHERS THEN
562: ROLLBACK TO save_delete_itm_lgl_ctnt;
563: x_return_status := FND_API.g_ret_sts_unexp_error ;
564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
565: THEN
566: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
567: END IF;

Line 569: p_encoded => FND_API.g_false,

565: THEN
566: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
567: END IF;
568: FND_MSG_PUB.count_and_get(
569: p_encoded => FND_API.g_false,
570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );
573:

Line 586: raise FND_API.g_exc_error;

582:
583: SAVEPOINT delete_section;
584:
585: if jtf_dspmgrvalidation_grp.check_section_exists(p_section_id) = false then
586: raise FND_API.g_exc_error;
587: end if;
588:
589: DELETE FROM JTF_DSP_OBJ_LGL_CTNT where
590: OBJECT_TYPE = 'S' and