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

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

22: -- no error is raised
23: ---------------------------------------------------------------------+
24: PROCEDURE add_tpl_ctg_rec(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
27: p_commit IN VARCHAR2 := FND_API.g_false,
28: x_return_status OUT NOCOPY VARCHAR2,
29: p_template_id IN NUMBER,
30: p_category_id IN NUMBER )

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

23: ---------------------------------------------------------------------+
24: PROCEDURE add_tpl_ctg_rec(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
27: p_commit IN VARCHAR2 := FND_API.g_false,
28: x_return_status OUT NOCOPY VARCHAR2,
29: p_template_id IN NUMBER,
30: p_category_id IN NUMBER )
31: IS

Line 43: IF NOT FND_API.compatible_api_call(

39: l_applicable_to VARCHAR2(30) := 'CATEGORY';
40: BEGIN
41: SAVEPOINT add_tpl_ctg_rec;
42:
43: IF NOT FND_API.compatible_api_call(
44: g_api_version,
45: p_api_version,
46: l_api_name,
47: g_pkg_name )

Line 49: RAISE FND_API.g_exc_unexpected_error;

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

Line 52: IF FND_API.to_boolean(p_init_msg_list) THEN

48: THEN
49: RAISE FND_API.g_exc_unexpected_error;
50: END IF;
51:
52: IF FND_API.to_boolean(p_init_msg_list) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: x_return_status := FND_API.g_ret_sts_success;

Line 56: x_return_status := FND_API.g_ret_sts_success;

52: IF FND_API.to_boolean(p_init_msg_list) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: x_return_status := FND_API.g_ret_sts_success;
57:
58: --- Check if the deliverable id exists .
59: IF p_template_id <> FND_API.g_miss_num AND
60: p_template_id IS NOT NULL

Line 59: IF p_template_id <> FND_API.g_miss_num AND

55:
56: x_return_status := FND_API.g_ret_sts_success;
57:
58: --- Check if the deliverable id exists .
59: IF p_template_id <> FND_API.g_miss_num AND
60: p_template_id IS NOT NULL
61: THEN
62: IF ibe_dspmgrvalidation_grp.check_deliverable_type_exists(
63: p_template_id,l_type ,l_applicable_to)

Line 65: IF p_category_id <> FND_API.g_miss_num AND

61: THEN
62: IF ibe_dspmgrvalidation_grp.check_deliverable_type_exists(
63: p_template_id,l_type ,l_applicable_to)
64: THEN
65: IF p_category_id <> FND_API.g_miss_num AND
66: p_category_id IS NOT NULL
67: THEN
68: IF ibe_dspmgrvalidation_grp.check_category_exists(p_category_id)
69: THEN

Line 101: RAISE FND_API.g_exc_error;

97: p_category_id);
98:
99: END IF; /* category - template relation not exists check */
100: ELSE
101: RAISE FND_API.g_exc_error;
102: END IF; /* category exists check */
103: ELSE
104: RAISE ibe_dspmgrvalidation_grp.category_req_exception;
105: END IF; /* category id is not null check */

Line 107: RAISE FND_API.g_exc_error;

103: ELSE
104: RAISE ibe_dspmgrvalidation_grp.category_req_exception;
105: END IF; /* category id is not null check */
106: ELSE
107: RAISE FND_API.g_exc_error;
108: END IF;/* deliverable exists check */
109: ELSE
110: RAISE ibe_dspmgrvalidation_grp.template_req_exception;
111: END IF; /*deliverable id is not null check */

Line 115: IF FND_API.to_boolean(p_commit)

111: END IF; /*deliverable id is not null check */
112:
113: --- Check if the caller requested to commit ,
114: --- If p_commit set to true, commit the transaction
115: IF FND_API.to_boolean(p_commit)
116: THEN
117: COMMIT;
118: END IF;
119:

Line 120: x_return_status := FND_API.g_ret_sts_success;

116: THEN
117: COMMIT;
118: END IF;
119:
120: x_return_status := FND_API.g_ret_sts_success;
121: EXCEPTION
122: WHEN FND_API.g_exc_error THEN
123: ROLLBACK TO add_tpl_ctg_rec;
124: x_return_status := FND_API.g_ret_sts_error;

Line 122: WHEN FND_API.g_exc_error THEN

118: END IF;
119:
120: x_return_status := FND_API.g_ret_sts_success;
121: EXCEPTION
122: WHEN FND_API.g_exc_error THEN
123: ROLLBACK TO add_tpl_ctg_rec;
124: x_return_status := FND_API.g_ret_sts_error;
125:
126: WHEN FND_API.g_exc_unexpected_error THEN

Line 124: x_return_status := FND_API.g_ret_sts_error;

120: x_return_status := FND_API.g_ret_sts_success;
121: EXCEPTION
122: WHEN FND_API.g_exc_error THEN
123: ROLLBACK TO add_tpl_ctg_rec;
124: x_return_status := FND_API.g_ret_sts_error;
125:
126: WHEN FND_API.g_exc_unexpected_error THEN
127: ROLLBACK TO add_tpl_ctg_rec;
128: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 126: WHEN FND_API.g_exc_unexpected_error THEN

122: WHEN FND_API.g_exc_error THEN
123: ROLLBACK TO add_tpl_ctg_rec;
124: x_return_status := FND_API.g_ret_sts_error;
125:
126: WHEN FND_API.g_exc_unexpected_error THEN
127: ROLLBACK TO add_tpl_ctg_rec;
128: x_return_status := FND_API.g_ret_sts_unexp_error ;
129:
130: WHEN ibe_dspmgrvalidation_grp.category_req_exception THEN

Line 128: x_return_status := FND_API.g_ret_sts_unexp_error ;

124: x_return_status := FND_API.g_ret_sts_error;
125:
126: WHEN FND_API.g_exc_unexpected_error THEN
127: ROLLBACK TO add_tpl_ctg_rec;
128: x_return_status := FND_API.g_ret_sts_unexp_error ;
129:
130: WHEN ibe_dspmgrvalidation_grp.category_req_exception THEN
131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
132: THEN

Line 133: x_return_status := FND_API.g_ret_sts_error;

129:
130: WHEN ibe_dspmgrvalidation_grp.category_req_exception THEN
131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
132: THEN
133: x_return_status := FND_API.g_ret_sts_error;
134: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
135: FND_MSG_PUB.add;
136: END IF;
137:

Line 141: x_return_status := FND_API.g_ret_sts_error;

137:
138: WHEN ibe_dspmgrvalidation_grp.template_req_exception THEN
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
140: THEN
141: x_return_status := FND_API.g_ret_sts_error;
142: FND_MESSAGE.set_name('IBE','IBE_DSP_TEMPLATE_REQ');
143: FND_MSG_PUB.add;
144: END IF;
145:

Line 148: x_return_status := FND_API.g_ret_sts_unexp_error ;

144: END IF;
145:
146: WHEN OTHERS THEN
147: ROLLBACK TO add_tpl_ctg_rec;
148: x_return_status := FND_API.g_ret_sts_unexp_error ;
149:
150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
151: THEN
152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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

163: --
164: ---------------------------------------------------------------------+
165: PROCEDURE add_tpl_ctg(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
168: p_commit IN VARCHAR2 := FND_API.g_false,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,

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

164: ---------------------------------------------------------------------+
165: PROCEDURE add_tpl_ctg(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
168: p_commit IN VARCHAR2 := FND_API.g_false,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_template_id IN NUMBER,

Line 188: IF NOT FND_API.compatible_api_call(

184: l_applicable_to VARCHAR2(30) := 'CATEGORY';
185: BEGIN
186: --------------------- initialize -----------------------+
187: SAVEPOINT add_tpl_ctg;
188: IF NOT FND_API.compatible_api_call(
189: g_api_version,
190: p_api_version,
191: l_api_name,
192: g_pkg_name )

Line 194: RAISE FND_API.g_exc_unexpected_error;

190: p_api_version,
191: l_api_name,
192: g_pkg_name )
193: THEN
194: RAISE FND_API.g_exc_unexpected_error;
195: END IF;
196:
197: IF FND_API.to_boolean(p_init_msg_list)
198: THEN

Line 197: IF FND_API.to_boolean(p_init_msg_list)

193: THEN
194: RAISE FND_API.g_exc_unexpected_error;
195: END IF;
196:
197: IF FND_API.to_boolean(p_init_msg_list)
198: THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:

Line 202: x_return_status := FND_API.G_RET_STS_SUCCESS;

198: THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: IF p_template_id IS NOT NULL AND
205: p_template_id <> FND_API.g_miss_num
206: THEN

Line 205: p_template_id <> FND_API.g_miss_num

201:
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: IF p_template_id IS NOT NULL AND
205: p_template_id <> FND_API.g_miss_num
206: THEN
207: IF ibe_dspmgrvalidation_grp.check_deliverable_type_exists(
208: p_template_id ,
209: l_type,

Line 212: RAISE FND_API.g_exc_error;

208: p_template_id ,
209: l_type,
210: l_applicable_to) = false
211: THEN
212: RAISE FND_API.g_exc_error;
213: END IF;/* deliverable exists check */
214: ELSE
215: RAISE ibe_dspmgrvalidation_grp.template_req_exception;
216: END IF; /*deliverable id is not null check */

Line 222: FND_API.g_false,

218: FOR l_index IN 1..p_category_id_tbl.COUNT
219: LOOP
220: add_tpl_ctg_rec(
221: p_api_version,
222: FND_API.g_false,
223: FND_API.g_false,
224: l_return_status ,
225: p_template_id,
226: p_category_id_tbl(l_index));

Line 223: FND_API.g_false,

219: LOOP
220: add_tpl_ctg_rec(
221: p_api_version,
222: FND_API.g_false,
223: FND_API.g_false,
224: l_return_status ,
225: p_template_id,
226: p_category_id_tbl(l_index));
227:

Line 228: IF l_return_status <> FND_API.g_ret_sts_success

224: l_return_status ,
225: p_template_id,
226: p_category_id_tbl(l_index));
227:
228: IF l_return_status <> FND_API.g_ret_sts_success
229: THEN
230: x_return_status := l_return_status;
231: END IF;
232: END LOOP;

Line 236: IF FND_API.to_boolean(p_commit)

232: END LOOP;
233:
234: --- Check if the caller requested to commit ,
235: --- If p_commit set to true, commit the transaction
236: IF FND_API.to_boolean(p_commit)
237: THEN
238: COMMIT;
239: END IF;
240:

Line 242: p_encoded => FND_API.g_false,

238: COMMIT;
239: END IF;
240:
241: FND_MSG_PUB.count_and_get(
242: p_encoded => FND_API.g_false,
243: p_count => x_msg_count,
244: p_data => x_msg_data );
245: EXCEPTION
246: WHEN FND_API.g_exc_error THEN

Line 246: WHEN FND_API.g_exc_error THEN

242: p_encoded => FND_API.g_false,
243: p_count => x_msg_count,
244: p_data => x_msg_data );
245: EXCEPTION
246: WHEN FND_API.g_exc_error THEN
247: ROLLBACK TO add_tpl_ctg;
248: x_return_status := FND_API.g_ret_sts_error;
249: FND_MSG_PUB.count_and_get(
250: p_encoded => FND_API.g_false,

Line 248: x_return_status := FND_API.g_ret_sts_error;

244: p_data => x_msg_data );
245: EXCEPTION
246: WHEN FND_API.g_exc_error THEN
247: ROLLBACK TO add_tpl_ctg;
248: x_return_status := FND_API.g_ret_sts_error;
249: FND_MSG_PUB.count_and_get(
250: p_encoded => FND_API.g_false,
251: p_count => x_msg_count,
252: p_data => x_msg_data );

Line 250: p_encoded => FND_API.g_false,

246: WHEN FND_API.g_exc_error THEN
247: ROLLBACK TO add_tpl_ctg;
248: x_return_status := FND_API.g_ret_sts_error;
249: FND_MSG_PUB.count_and_get(
250: p_encoded => FND_API.g_false,
251: p_count => x_msg_count,
252: p_data => x_msg_data );
253:
254: WHEN FND_API.g_exc_unexpected_error THEN

Line 254: WHEN FND_API.g_exc_unexpected_error THEN

250: p_encoded => FND_API.g_false,
251: p_count => x_msg_count,
252: p_data => x_msg_data );
253:
254: WHEN FND_API.g_exc_unexpected_error THEN
255: ROLLBACK TO add_tpl_ctg;
256: x_return_status := FND_API.g_ret_sts_unexp_error ;
257: FND_MSG_PUB.count_and_get(
258: p_encoded => FND_API.g_false,

Line 256: x_return_status := FND_API.g_ret_sts_unexp_error ;

252: p_data => x_msg_data );
253:
254: WHEN FND_API.g_exc_unexpected_error THEN
255: ROLLBACK TO add_tpl_ctg;
256: x_return_status := FND_API.g_ret_sts_unexp_error ;
257: FND_MSG_PUB.count_and_get(
258: p_encoded => FND_API.g_false,
259: p_count => x_msg_count,
260: p_data => x_msg_data );

Line 258: p_encoded => FND_API.g_false,

254: WHEN FND_API.g_exc_unexpected_error THEN
255: ROLLBACK TO add_tpl_ctg;
256: x_return_status := FND_API.g_ret_sts_unexp_error ;
257: FND_MSG_PUB.count_and_get(
258: p_encoded => FND_API.g_false,
259: p_count => x_msg_count,
260: p_data => x_msg_data );
261:
262: WHEN ibe_dspmgrvalidation_grp.template_req_exception THEN

Line 265: x_return_status := FND_API.g_ret_sts_error;

261:
262: WHEN ibe_dspmgrvalidation_grp.template_req_exception THEN
263: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
264: THEN
265: x_return_status := FND_API.g_ret_sts_error;
266: FND_MESSAGE.set_name('IBE','IBE_DSP_TEMPLATE_REQ');
267: FND_MSG_PUB.add;
268: END IF;
269: FND_MSG_PUB.count_and_get(

Line 270: p_encoded => FND_API.g_false,

266: FND_MESSAGE.set_name('IBE','IBE_DSP_TEMPLATE_REQ');
267: FND_MSG_PUB.add;
268: END IF;
269: FND_MSG_PUB.count_and_get(
270: p_encoded => FND_API.g_false,
271: p_count => x_msg_count,
272: p_data => x_msg_data );
273:
274: WHEN OTHERS THEN

Line 276: x_return_status := FND_API.g_ret_sts_unexp_error ;

272: p_data => x_msg_data );
273:
274: WHEN OTHERS THEN
275: ROLLBACK TO add_tpl_ctg;
276: x_return_status := FND_API.g_ret_sts_unexp_error ;
277:
278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
279: THEN
280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 284: p_encoded => FND_API.g_false,

280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
281: END IF;
282:
283: FND_MSG_PUB.count_and_get(
284: p_encoded => FND_API.g_false,
285: p_count => x_msg_count,
286: p_data => x_msg_data );
287: END add_tpl_ctg;
288:

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

294: -- for all display contexts
295: --------------------------------------------------------------------+
296: PROCEDURE delete_tpl_ctg_relation(
297: p_api_version IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
299: p_commit IN VARCHAR2 := FND_API.g_false,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
302: x_msg_data OUT NOCOPY VARCHAR2,

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

295: --------------------------------------------------------------------+
296: PROCEDURE delete_tpl_ctg_relation(
297: p_api_version IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
299: p_commit IN VARCHAR2 := FND_API.g_false,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
302: x_msg_data OUT NOCOPY VARCHAR2,
303: p_tpl_ctg_id_tbl IN tpl_ctg_id_TBL_TYPE )

Line 318: IF NOT FND_API.compatible_api_call(

314: WHERE tpl_ctg_id = p_tpl_ctg_id;
315: BEGIN
316: --------------------- initialize -----------------------+
317: SAVEPOINT delete_tpl_ctg_relation;
318: IF NOT FND_API.compatible_api_call(
319: g_api_version,
320: p_api_version,
321: l_api_name,
322: g_pkg_name )

Line 324: RAISE FND_API.g_exc_unexpected_error;

320: p_api_version,
321: l_api_name,
322: g_pkg_name )
323: THEN
324: RAISE FND_API.g_exc_unexpected_error;
325: END IF;
326:
327: IF FND_API.to_boolean(p_init_msg_list)
328: THEN

Line 327: IF FND_API.to_boolean(p_init_msg_list)

323: THEN
324: RAISE FND_API.g_exc_unexpected_error;
325: END IF;
326:
327: IF FND_API.to_boolean(p_init_msg_list)
328: THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:

Line 332: x_return_status := FND_API.G_RET_STS_SUCCESS;

328: THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS;
333:
334: FOR l_index IN 1..p_tpl_ctg_id_tbl.COUNT
335: LOOP
336: BEGIN

Line 339: IF p_tpl_ctg_id_tbl(l_index) <> FND_API.g_miss_num AND

335: LOOP
336: BEGIN
337: SAVEPOINT delete_ctg_relation;
338: --- Check if the context_id exists
339: IF p_tpl_ctg_id_tbl(l_index) <> FND_API.g_miss_num AND
340: p_tpl_ctg_id_tbl(l_index) IS NOT NULL
341: THEN
342: --- Delete all the entries matching category id and deliverable id
343: OPEN category_cur(p_tpl_ctg_id_tbl(l_index) );

Line 357: x_return_status := FND_API.g_ret_sts_error;

353: END IF;
354: EXCEPTION
355: WHEN OTHERS THEN
356: ROLLBACK TO delete_ctg_relation;
357: x_return_status := FND_API.g_ret_sts_error;
358: END;
359: END LOOP;
360:
361: --- Check if the caller requested to commit ,

Line 363: IF FND_API.to_boolean(p_commit)

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

Line 369: p_encoded => FND_API.g_false,

365: COMMIT;
366: END IF;
367:
368: FND_MSG_PUB.count_and_get(
369: p_encoded => FND_API.g_false,
370: p_count => x_msg_count,
371: p_data => x_msg_data );
372: EXCEPTION
373: WHEN FND_API.g_exc_error THEN

Line 373: WHEN FND_API.g_exc_error THEN

369: p_encoded => FND_API.g_false,
370: p_count => x_msg_count,
371: p_data => x_msg_data );
372: EXCEPTION
373: WHEN FND_API.g_exc_error THEN
374: ROLLBACK TO delete_tpl_ctg_relation;
375: x_return_status := FND_API.g_ret_sts_error;
376: FND_MSG_PUB.count_and_get(
377: p_encoded => FND_API.g_false,

Line 375: x_return_status := FND_API.g_ret_sts_error;

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

Line 377: p_encoded => FND_API.g_false,

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

Line 381: WHEN FND_API.g_exc_unexpected_error THEN

377: p_encoded => FND_API.g_false,
378: p_count => x_msg_count,
379: p_data => x_msg_data );
380:
381: WHEN FND_API.g_exc_unexpected_error THEN
382: ROLLBACK TO delete_tpl_ctg_relation;
383: x_return_status := FND_API.g_ret_sts_unexp_error ;
384: FND_MSG_PUB.count_and_get(
385: p_encoded => FND_API.g_false,

Line 383: x_return_status := FND_API.g_ret_sts_unexp_error ;

379: p_data => x_msg_data );
380:
381: WHEN FND_API.g_exc_unexpected_error THEN
382: ROLLBACK TO delete_tpl_ctg_relation;
383: x_return_status := FND_API.g_ret_sts_unexp_error ;
384: FND_MSG_PUB.count_and_get(
385: p_encoded => FND_API.g_false,
386: p_count => x_msg_count,
387: p_data => x_msg_data );

Line 385: p_encoded => FND_API.g_false,

381: WHEN FND_API.g_exc_unexpected_error THEN
382: ROLLBACK TO delete_tpl_ctg_relation;
383: x_return_status := FND_API.g_ret_sts_unexp_error ;
384: FND_MSG_PUB.count_and_get(
385: p_encoded => FND_API.g_false,
386: p_count => x_msg_count,
387: p_data => x_msg_data );
388:
389: WHEN OTHERS THEN

Line 391: x_return_status := FND_API.g_ret_sts_unexp_error ;

387: p_data => x_msg_data );
388:
389: WHEN OTHERS THEN
390: ROLLBACK TO delete_tpl_ctg_relation;
391: x_return_status := FND_API.g_ret_sts_unexp_error ;
392:
393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
394: THEN
395: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 399: p_encoded => FND_API.g_false,

395: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
396: END IF;
397:
398: FND_MSG_PUB.count_and_get(
399: p_encoded => FND_API.g_false,
400: p_count => x_msg_count,
401: p_data => x_msg_data );
402: END delete_tpl_ctg_relation;
403:

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

410: -- 4. Creates a category to templates relationship (IBE_DSP_TPL_CTG)
411: ---------------------------------------------------------------------+
412: PROCEDURE add_ctg_tpl(
413: p_api_version IN NUMBER,
414: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
415: p_commit IN VARCHAR2 := FND_API.g_false,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2,

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

411: ---------------------------------------------------------------------+
412: PROCEDURE add_ctg_tpl(
413: p_api_version IN NUMBER,
414: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
415: p_commit IN VARCHAR2 := FND_API.g_false,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2,
419: p_category_id IN NUMBER,

Line 434: IF NOT FND_API.compatible_api_call(

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

Line 440: RAISE FND_API.g_exc_unexpected_error;

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

Line 443: IF FND_API.to_boolean(p_init_msg_list)

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

Line 448: x_return_status := FND_API.g_ret_sts_success;

444: THEN
445: FND_MSG_PUB.initialize;
446: END IF;
447:
448: x_return_status := FND_API.g_ret_sts_success;
449:
450: IF p_category_id <> FND_API.g_miss_num OR
451: p_category_id IS NOT NULL
452: THEN

Line 450: IF p_category_id <> FND_API.g_miss_num OR

446: END IF;
447:
448: x_return_status := FND_API.g_ret_sts_success;
449:
450: IF p_category_id <> FND_API.g_miss_num OR
451: p_category_id IS NOT NULL
452: THEN
453: IF ibe_dspmgrvalidation_grp.check_category_exists(
454: p_category_id) = false

Line 456: RAISE FND_API.g_exc_error;

452: THEN
453: IF ibe_dspmgrvalidation_grp.check_category_exists(
454: p_category_id) = false
455: THEN
456: RAISE FND_API.g_exc_error;
457: END IF; /* category exists check */
458: ELSE
459: RAISE ibe_dspmgrvalidation_grp.category_req_exception;
460: end if; /* category id is not null check */

Line 467: FND_API.g_false,

463: FOR l_index IN 1..p_template_id_tbl.COUNT
464: LOOP
465: add_tpl_ctg_rec(
466: p_api_version,
467: FND_API.g_false,
468: FND_API.g_false,
469: l_return_status ,
470: p_template_id_tbl(l_index),
471: p_category_id);

Line 468: FND_API.g_false,

464: LOOP
465: add_tpl_ctg_rec(
466: p_api_version,
467: FND_API.g_false,
468: FND_API.g_false,
469: l_return_status ,
470: p_template_id_tbl(l_index),
471: p_category_id);
472:

Line 473: IF l_return_status <> FND_API.g_ret_sts_success

469: l_return_status ,
470: p_template_id_tbl(l_index),
471: p_category_id);
472:
473: IF l_return_status <> FND_API.g_ret_sts_success
474: THEN
475: x_return_status := l_return_status;
476: END IF;
477: END LOOP;

Line 481: IF FND_API.to_boolean(p_commit)

477: END LOOP;
478:
479: --- Check if the caller requested to commit ,
480: --- If p_commit set to true, commit the transaction
481: IF FND_API.to_boolean(p_commit)
482: THEN
483: COMMIT;
484: END IF;
485:

Line 487: p_encoded => FND_API.g_false,

483: COMMIT;
484: END IF;
485:
486: FND_MSG_PUB.count_and_get(
487: p_encoded => FND_API.g_false,
488: p_count => x_msg_count,
489: p_data => x_msg_data );
490: EXCEPTION
491: WHEN FND_API.g_exc_error THEN

Line 491: WHEN FND_API.g_exc_error THEN

487: p_encoded => FND_API.g_false,
488: p_count => x_msg_count,
489: p_data => x_msg_data );
490: EXCEPTION
491: WHEN FND_API.g_exc_error THEN
492: ROLLBACK TO add_ctg_tpl;
493: x_return_status := FND_API.g_ret_sts_error;
494: FND_MSG_PUB.count_and_get(
495: p_encoded => FND_API.g_false,

Line 493: x_return_status := FND_API.g_ret_sts_error;

489: p_data => x_msg_data );
490: EXCEPTION
491: WHEN FND_API.g_exc_error THEN
492: ROLLBACK TO add_ctg_tpl;
493: x_return_status := FND_API.g_ret_sts_error;
494: FND_MSG_PUB.count_and_get(
495: p_encoded => FND_API.g_false,
496: p_count => x_msg_count,
497: p_data => x_msg_data );

Line 495: p_encoded => FND_API.g_false,

491: WHEN FND_API.g_exc_error THEN
492: ROLLBACK TO add_ctg_tpl;
493: x_return_status := FND_API.g_ret_sts_error;
494: FND_MSG_PUB.count_and_get(
495: p_encoded => FND_API.g_false,
496: p_count => x_msg_count,
497: p_data => x_msg_data );
498:
499: WHEN FND_API.g_exc_unexpected_error THEN

Line 499: WHEN FND_API.g_exc_unexpected_error THEN

495: p_encoded => FND_API.g_false,
496: p_count => x_msg_count,
497: p_data => x_msg_data );
498:
499: WHEN FND_API.g_exc_unexpected_error THEN
500: ROLLBACK TO add_ctg_tpl;
501: x_return_status := FND_API.g_ret_sts_unexp_error ;
502: FND_MSG_PUB.count_and_get(
503: p_encoded => FND_API.g_false,

Line 501: x_return_status := FND_API.g_ret_sts_unexp_error ;

497: p_data => x_msg_data );
498:
499: WHEN FND_API.g_exc_unexpected_error THEN
500: ROLLBACK TO add_ctg_tpl;
501: x_return_status := FND_API.g_ret_sts_unexp_error ;
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 );

Line 503: p_encoded => FND_API.g_false,

499: WHEN FND_API.g_exc_unexpected_error THEN
500: ROLLBACK TO add_ctg_tpl;
501: x_return_status := FND_API.g_ret_sts_unexp_error ;
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:
507: WHEN ibe_dspmgrvalidation_grp.category_req_exception THEN

Line 511: x_return_status := FND_API.g_ret_sts_error;

507: WHEN ibe_dspmgrvalidation_grp.category_req_exception THEN
508: ROLLBACK TO add_ctg_tpl;
509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
510: THEN
511: x_return_status := FND_API.g_ret_sts_error;
512: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
513: FND_MSG_PUB.add;
514: END IF;
515: FND_MSG_PUB.count_and_get(

Line 516: p_encoded => FND_API.g_false,

512: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
513: FND_MSG_PUB.add;
514: END IF;
515: FND_MSG_PUB.count_and_get(
516: p_encoded => FND_API.g_false,
517: p_count => x_msg_count,
518: p_data => x_msg_data );
519:
520: WHEN OTHERS THEN

Line 522: x_return_status := FND_API.g_ret_sts_unexp_error ;

518: p_data => x_msg_data );
519:
520: WHEN OTHERS THEN
521: ROLLBACK TO add_ctg_tpl;
522: x_return_status := FND_API.g_ret_sts_unexp_error ;
523:
524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
525: THEN
526: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 530: p_encoded => FND_API.g_false,

526: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
527: END IF;
528:
529: FND_MSG_PUB.count_and_get(
530: p_encoded => FND_API.g_false,
531: p_count => x_msg_count,
532: p_data => x_msg_data );
533: END ADD_CTG_TPL;
534: