APPS.IBE_M_IBC_INT_PVT dependencies on FND_API

Line 205: IF NOT FND_API.Compatible_API_Call(l_api_version,

201: IBE_UTIL.debug('p_commit = '||p_commit);
202: IBE_UTIL.debug('p_content_item_id_tbl number:'||p_content_item_id_tbl.Count);
203: IBE_UTIL.debug('p_version_number_tbl:'||p_version_number_tbl.Count);
204: END IF;
205: IF NOT FND_API.Compatible_API_Call(l_api_version,
206: p_api_version,
207: l_api_name,
208: G_PKG_NAME) THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

205: IF NOT FND_API.Compatible_API_Call(l_api_version,
206: p_api_version,
207: l_api_name,
208: G_PKG_NAME) THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211: IF FND_API.to_Boolean(p_init_msg_list) THEN
212: FND_MSG_PUB.initialize;
213: END IF;

Line 211: IF FND_API.to_Boolean(p_init_msg_list) THEN

207: l_api_name,
208: G_PKG_NAME) THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211: IF FND_API.to_Boolean(p_init_msg_list) THEN
212: FND_MSG_PUB.initialize;
213: END IF;
214: -- Initialize API return status to SUCCESS
215: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 215: x_return_status := FND_API.G_RET_STS_SUCCESS;

211: IF FND_API.to_Boolean(p_init_msg_list) THEN
212: FND_MSG_PUB.initialize;
213: END IF;
214: -- Initialize API return status to SUCCESS
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216:
217: IF (l_debug = 'Y') THEN
218: IBE_UTIL.debug('Calling Ibc_Cv_Label_Grp.Upsert_Cv_Labels starts');
219: IBE_UTIL.debug('p_label_code = '||l_label_code);

Line 237: p_commit => FND_API.G_FALSE,

233: Ibc_Cv_Label_Grp.Upsert_Cv_Labels(
234: p_label_code => l_label_code,
235: p_content_item_ids => p_content_item_id_tbl,
236: p_version_number => p_version_number_tbl,
237: p_commit => FND_API.G_FALSE,
238: p_api_version_number => 1.0,
239: x_return_status => x_return_status,
240: x_msg_count => x_msg_count,
241: x_msg_data => x_msg_data);

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

241: x_msg_data => x_msg_data);
242: IF (l_debug = 'Y') THEN
243: IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Upsert_Cv_Labels:'||x_return_status);
244: END IF;
245: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
246: IF (l_debug = 'Y') THEN
247: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Upsert_Cv_Labels');
248: for i in 1..x_msg_count loop
249: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 249: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

245: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
246: IF (l_debug = 'Y') THEN
247: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Upsert_Cv_Labels');
248: for i in 1..x_msg_count loop
249: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
250: IBE_UTIL.debug(l_msg_data);
251: end loop;
252: END IF;
253: RAISE FND_API.G_EXC_ERROR;

Line 253: RAISE FND_API.G_EXC_ERROR;

249: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
250: IBE_UTIL.debug(l_msg_data);
251: end loop;
252: END IF;
253: RAISE FND_API.G_EXC_ERROR;
254: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
255: IF (l_debug = 'Y') THEN
256: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Upsert_Cv_Labels');
257: for i in 1..x_msg_count loop

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

250: IBE_UTIL.debug(l_msg_data);
251: end loop;
252: END IF;
253: RAISE FND_API.G_EXC_ERROR;
254: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
255: IF (l_debug = 'Y') THEN
256: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Upsert_Cv_Labels');
257: for i in 1..x_msg_count loop
258: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 258: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

254: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
255: IF (l_debug = 'Y') THEN
256: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Upsert_Cv_Labels');
257: for i in 1..x_msg_count loop
258: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
259: IBE_UTIL.debug(l_msg_data);
260: end loop;
261: END IF;
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
259: IBE_UTIL.debug(l_msg_data);
260: end loop;
261: END IF;
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264:
265: IF (l_debug = 'Y') THEN
266: IBE_UTIL.debug('Before committing the work:'||p_commit);

Line 268: IF (FND_API.To_Boolean(p_commit)) THEN

264:
265: IF (l_debug = 'Y') THEN
266: IBE_UTIL.debug('Before committing the work:'||p_commit);
267: END IF;
268: IF (FND_API.To_Boolean(p_commit)) THEN
269: COMMIT WORK;
270: END IF;
271: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
272: p_data => x_msg_data,

Line 278: WHEN FND_API.G_EXC_ERROR THEN

274: IF (l_debug = 'Y') THEN
275: IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Batch_Update_Labels Ends +');
276: END IF;
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
282: p_data => x_msg_data,

Line 280: x_return_status := FND_API.G_RET_STS_ERROR;

276: END IF;
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
282: p_data => x_msg_data,
283: p_encoded => 'F');
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

280: x_return_status := FND_API.G_RET_STS_ERROR;
281: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
282: p_data => x_msg_data,
283: p_encoded => 'F');
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285: ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
288: p_data => x_msg_data,

Line 286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

282: p_data => x_msg_data,
283: p_encoded => 'F');
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285: ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
288: p_data => x_msg_data,
289: p_encoded => 'F');
290: WHEN OTHERS THEN

Line 301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

297: IF (l_debug = 'Y') THEN
298: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
299: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
300: END IF;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
303: THEN
304: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
305: END IF;

Line 392: IF NOT FND_API.Compatible_API_Call(l_api_version,

388: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
389: IF (l_debug = 'Y') THEN
390: IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Update_Label_Association starts +');
391: END IF;
392: IF NOT FND_API.Compatible_API_Call(l_api_version,
393: p_api_version,
394: l_api_name,
395: G_PKG_NAME) THEN
396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

392: IF NOT FND_API.Compatible_API_Call(l_api_version,
393: p_api_version,
394: l_api_name,
395: G_PKG_NAME) THEN
396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
397: END IF;
398: IF FND_API.to_Boolean(p_init_msg_list) THEN
399: FND_MSG_PUB.initialize;
400: END IF;

Line 398: IF FND_API.to_Boolean(p_init_msg_list) THEN

394: l_api_name,
395: G_PKG_NAME) THEN
396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
397: END IF;
398: IF FND_API.to_Boolean(p_init_msg_list) THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401: x_return_status := FND_API.g_ret_sts_success;
402: l_content_item_id := p_new_content_item_id;

Line 401: x_return_status := FND_API.g_ret_sts_success;

397: END IF;
398: IF FND_API.to_Boolean(p_init_msg_list) THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401: x_return_status := FND_API.g_ret_sts_success;
402: l_content_item_id := p_new_content_item_id;
403: l_version_number := p_new_version_number;
404: IF (l_debug = 'Y') THEN
405: IBE_UTIL.debug('Before getting version id');

Line 416: raise FND_API.G_EXC_ERROR;

412: CLOSE c_get_version_id;
413: IF (l_debug = 'Y') THEN
414: IBE_UTIL.debug('version id is not found');
415: END IF;
416: raise FND_API.G_EXC_ERROR;
417: END IF;
418: CLOSE c_get_version_id;
419: IF (l_debug = 'Y') THEN
420: IBE_UTIL.debug('After getting version id: '||l_item_version_id);

Line 436: raise FND_API.G_EXC_ERROR;

432: IF (p_media_object_id IS NULL) THEN
433: IF (l_debug = 'Y') THEN
434: IBE_UTIL.debug('p_media_object_id IS NULL, RAISE ERROR');
435: END IF;
436: raise FND_API.G_EXC_ERROR;
437: END IF;
438: l_old_item_ids := JTF_NUMBER_TABLE();
439: l_old_item_ids.extend(1);
440: l_old_item_ids(1) := NULL;

Line 522: p_init_msg_list => FND_API.G_FALSE,

518: IBE_UTIL.debug('Calling Ibc_Associations_Grp.Move_Associations');
519: END IF;
520: Ibc_Associations_Grp.Move_Associations (
521: p_api_version => 1.0,
522: p_init_msg_list => FND_API.G_FALSE,
523: p_commit => FND_API.G_FALSE,
524: p_old_content_item_ids => l_old_item_ids,
525: p_new_content_item_ids => l_new_item_ids,
526: p_assoc_type_codes => l_assoc_type_codes,

Line 523: p_commit => FND_API.G_FALSE,

519: END IF;
520: Ibc_Associations_Grp.Move_Associations (
521: p_api_version => 1.0,
522: p_init_msg_list => FND_API.G_FALSE,
523: p_commit => FND_API.G_FALSE,
524: p_old_content_item_ids => l_old_item_ids,
525: p_new_content_item_ids => l_new_item_ids,
526: p_assoc_type_codes => l_assoc_type_codes,
527: p_assoc_objects1 => l_assoc_objects,

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

535: IF (l_debug = 'Y') THEN
536: IBE_UTIL.debug('After calling Ibc_Associations_Grp.Move_Associations:'
537: ||x_return_status);
538: END IF;
539: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
540: IF (l_debug = 'Y') THEN
541: IBE_UTIL.debug('Error in Ibc_Associations_Grp.Move_Associations');
542: for i in 1..x_msg_count loop
543: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 543: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

539: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
540: IF (l_debug = 'Y') THEN
541: IBE_UTIL.debug('Error in Ibc_Associations_Grp.Move_Associations');
542: for i in 1..x_msg_count loop
543: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
544: IBE_UTIL.debug(l_msg_data);
545: end loop;
546: END IF;
547: RAISE FND_API.G_EXC_ERROR;

Line 547: RAISE FND_API.G_EXC_ERROR;

543: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
544: IBE_UTIL.debug(l_msg_data);
545: end loop;
546: END IF;
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
549: IF (l_debug = 'Y') THEN
550: IBE_UTIL.debug('Error in Ibc_Associations_Grp.Move_Associations');
551: for i in 1..x_msg_count loop

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

544: IBE_UTIL.debug(l_msg_data);
545: end loop;
546: END IF;
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
549: IF (l_debug = 'Y') THEN
550: IBE_UTIL.debug('Error in Ibc_Associations_Grp.Move_Associations');
551: for i in 1..x_msg_count loop
552: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 552: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

548: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
549: IF (l_debug = 'Y') THEN
550: IBE_UTIL.debug('Error in Ibc_Associations_Grp.Move_Associations');
551: for i in 1..x_msg_count loop
552: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
553: IBE_UTIL.debug(l_msg_data);
554: end loop;
555: END IF;
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

552: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
553: IBE_UTIL.debug(l_msg_data);
554: end loop;
555: END IF;
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558: END IF;
559:
560: -- Process label

Line 582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

578: CLOSE c_label_flag;
579: IF (l_debug = 'Y') THEN
580: IBE_UTIL.debug('Cannot find label item, exception');
581: END IF;
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: END IF;
584: CLOSE c_label_flag;
585: IF (l_debug = 'Y') THEN
586: IBE_UTIL.debug('After finding label version');

Line 606: P_Init_Msg_List => FND_API.G_FALSE,

602: ||l_cv_label_rec.object_version_number);
603: END IF;
604: Ibc_Cv_Label_Grp.Update_CV_Label(
605: p_api_version_number => 1.0,
606: P_Init_Msg_List => FND_API.G_FALSE,
607: P_Commit => FND_API.G_FALSE,
608: P_CV_Label_Rec => l_cv_label_rec,
609: x_CV_Label_Rec => r_cv_label_rec,
610: x_return_status => x_return_status,

Line 607: P_Commit => FND_API.G_FALSE,

603: END IF;
604: Ibc_Cv_Label_Grp.Update_CV_Label(
605: p_api_version_number => 1.0,
606: P_Init_Msg_List => FND_API.G_FALSE,
607: P_Commit => FND_API.G_FALSE,
608: P_CV_Label_Rec => l_cv_label_rec,
609: x_CV_Label_Rec => r_cv_label_rec,
610: x_return_status => x_return_status,
611: x_msg_count => x_msg_count,

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

612: x_msg_data => x_msg_data);
613: IF (l_debug = 'Y') THEN
614: IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Update_CV_Label:'||x_return_status);
615: END IF;
616: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
617: IF (l_debug = 'Y') THEN
618: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label');
619: for i in 1..x_msg_count loop
620: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 620: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

616: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
617: IF (l_debug = 'Y') THEN
618: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label');
619: for i in 1..x_msg_count loop
620: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
621: IBE_UTIL.debug(l_msg_data);
622: end loop;
623: END IF;
624: RAISE FND_API.G_EXC_ERROR;

Line 624: RAISE FND_API.G_EXC_ERROR;

620: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
621: IBE_UTIL.debug(l_msg_data);
622: end loop;
623: END IF;
624: RAISE FND_API.G_EXC_ERROR;
625: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
626: IF (l_debug = 'Y') THEN
627: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label');
628: for i in 1..x_msg_count loop

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

621: IBE_UTIL.debug(l_msg_data);
622: end loop;
623: END IF;
624: RAISE FND_API.G_EXC_ERROR;
625: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
626: IF (l_debug = 'Y') THEN
627: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label');
628: for i in 1..x_msg_count loop
629: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 629: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

625: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
626: IF (l_debug = 'Y') THEN
627: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label');
628: for i in 1..x_msg_count loop
629: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
630: IBE_UTIL.debug(l_msg_data);
631: end loop;
632: END IF;
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

629: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
630: IBE_UTIL.debug(l_msg_data);
631: end loop;
632: END IF;
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: END IF;
635: ELSE
636: IF (p_old_content_item_id IS NOT NULL) THEN
637: -- Check the old content item has association or not

Line 667: P_Init_Msg_List => FND_API.G_FALSE,

663: IBE_UTIL.debug('p_content_item_id = '||l_old_item_id);
664: END IF;
665: Ibc_Cv_Label_Grp.Delete_CV_Label(
666: P_Api_Version_Number => 1.0,
667: P_Init_Msg_List => FND_API.G_FALSE,
668: P_Commit => FND_API.G_FALSE,
669: p_label_code => l_label_code,
670: p_content_item_id => l_old_item_id,
671: x_return_status => x_return_status,

Line 668: P_Commit => FND_API.G_FALSE,

664: END IF;
665: Ibc_Cv_Label_Grp.Delete_CV_Label(
666: P_Api_Version_Number => 1.0,
667: P_Init_Msg_List => FND_API.G_FALSE,
668: P_Commit => FND_API.G_FALSE,
669: p_label_code => l_label_code,
670: p_content_item_id => l_old_item_id,
671: x_return_status => x_return_status,
672: x_msg_count => x_msg_count,

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

673: x_msg_data => x_msg_data);
674: IF (l_debug = 'Y') THEN
675: IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Delete_CV_Label:'||x_return_status);
676: END IF;
677: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
678: IF (l_debug = 'Y') THEN
679: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
680: for i in 1..x_msg_count loop
681: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 681: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

677: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
678: IF (l_debug = 'Y') THEN
679: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
680: for i in 1..x_msg_count loop
681: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
682: IBE_UTIL.debug(l_msg_data);
683: end loop;
684: END IF;
685: RAISE FND_API.G_EXC_ERROR;

Line 685: RAISE FND_API.G_EXC_ERROR;

681: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
682: IBE_UTIL.debug(l_msg_data);
683: end loop;
684: END IF;
685: RAISE FND_API.G_EXC_ERROR;
686: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
687: IF (l_debug = 'Y') THEN
688: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
689: for i in 1..x_msg_count loop

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

682: IBE_UTIL.debug(l_msg_data);
683: end loop;
684: END IF;
685: RAISE FND_API.G_EXC_ERROR;
686: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
687: IF (l_debug = 'Y') THEN
688: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
689: for i in 1..x_msg_count loop
690: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 690: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

686: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
687: IF (l_debug = 'Y') THEN
688: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
689: for i in 1..x_msg_count loop
690: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
691: IBE_UTIL.debug(l_msg_data);
692: end loop;
693: END IF;
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

690: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
691: IBE_UTIL.debug(l_msg_data);
692: end loop;
693: END IF;
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696: END IF;
697: END IF;
698: l_temp := 0;

Line 737: P_Init_Msg_List => FND_API.G_FALSE,

733: ||l_cv_label_rec.last_update_login);
734: END IF;
735: Ibc_Cv_Label_Grp.Update_CV_Label(
736: p_api_version_number => 1.0,
737: P_Init_Msg_List => FND_API.G_FALSE,
738: P_Commit => FND_API.G_FALSE,
739: P_CV_Label_Rec => l_cv_label_rec,
740: x_CV_Label_Rec => r_cv_label_rec,
741: x_return_status => x_return_status,

Line 738: P_Commit => FND_API.G_FALSE,

734: END IF;
735: Ibc_Cv_Label_Grp.Update_CV_Label(
736: p_api_version_number => 1.0,
737: P_Init_Msg_List => FND_API.G_FALSE,
738: P_Commit => FND_API.G_FALSE,
739: P_CV_Label_Rec => l_cv_label_rec,
740: x_CV_Label_Rec => r_cv_label_rec,
741: x_return_status => x_return_status,
742: x_msg_count => x_msg_count,

Line 771: P_Init_Msg_List => FND_API.G_FALSE,

767: IBE_UTIL.debug('Calling Ibc_Cv_Label_Grp.Create_CV_Label');
768: END IF;
769: Ibc_Cv_Label_Grp.Create_CV_Label(
770: p_api_version_number => 1.0,
771: P_Init_Msg_List => FND_API.G_FALSE,
772: P_Commit => FND_API.G_FALSE,
773: P_CV_Label_Rec => l_cv_label_rec,
774: x_CV_Label_Rec => r_cv_label_rec,
775: x_return_status => x_return_status,

Line 772: P_Commit => FND_API.G_FALSE,

768: END IF;
769: Ibc_Cv_Label_Grp.Create_CV_Label(
770: p_api_version_number => 1.0,
771: P_Init_Msg_List => FND_API.G_FALSE,
772: P_Commit => FND_API.G_FALSE,
773: P_CV_Label_Rec => l_cv_label_rec,
774: x_CV_Label_Rec => r_cv_label_rec,
775: x_return_status => x_return_status,
776: x_msg_count => x_msg_count,

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

778: IF (l_debug = 'Y') THEN
779: IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Create_CV_Label:'||x_return_status);
780: END IF;
781: END IF;
782: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
783: IF (l_debug = 'Y') THEN
784: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label/Create_CV_Label');
785: for i in 1..x_msg_count loop
786: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 786: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

782: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
783: IF (l_debug = 'Y') THEN
784: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label/Create_CV_Label');
785: for i in 1..x_msg_count loop
786: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
787: IBE_UTIL.debug(l_msg_data);
788: end loop;
789: END IF;
790: RAISE FND_API.G_EXC_ERROR;

Line 790: RAISE FND_API.G_EXC_ERROR;

786: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
787: IBE_UTIL.debug(l_msg_data);
788: end loop;
789: END IF;
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
792: IF (l_debug = 'Y') THEN
793: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label/Create_CV_Label');
794: for i in 1..x_msg_count loop

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

787: IBE_UTIL.debug(l_msg_data);
788: end loop;
789: END IF;
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
792: IF (l_debug = 'Y') THEN
793: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label/Create_CV_Label');
794: for i in 1..x_msg_count loop
795: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 795: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

791: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
792: IF (l_debug = 'Y') THEN
793: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label/Create_CV_Label');
794: for i in 1..x_msg_count loop
795: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
796: IBE_UTIL.debug(l_msg_data);
797: end loop;
798: END IF;
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

795: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
796: IBE_UTIL.debug(l_msg_data);
797: end loop;
798: END IF;
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801: END IF;
802: IF (l_debug = 'Y') THEN
803: IBE_UTIL.debug('Before committing work:'||p_commit);

Line 805: IF (FND_API.To_Boolean(p_commit)) THEN

801: END IF;
802: IF (l_debug = 'Y') THEN
803: IBE_UTIL.debug('Before committing work:'||p_commit);
804: END IF;
805: IF (FND_API.To_Boolean(p_commit)) THEN
806: COMMIT WORK;
807: END IF;
808: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
809: p_data => x_msg_data,

Line 815: WHEN FND_API.G_EXC_ERROR THEN

811: IF (l_debug = 'Y') THEN
812: IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Update_Label_Association ends +');
813: END IF;
814: EXCEPTION
815: WHEN FND_API.G_EXC_ERROR THEN
816: ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
819: p_data => x_msg_data,

Line 817: x_return_status := FND_API.G_RET_STS_ERROR;

813: END IF;
814: EXCEPTION
815: WHEN FND_API.G_EXC_ERROR THEN
816: ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
819: p_data => x_msg_data,
820: p_encoded => 'F');
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

817: x_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
819: p_data => x_msg_data,
820: p_encoded => 'F');
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
825: p_data => x_msg_data,

Line 823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

819: p_data => x_msg_data,
820: p_encoded => 'F');
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
825: p_data => x_msg_data,
826: p_encoded => 'F');
827: WHEN OTHERS THEN

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

834: IF (l_debug = 'Y') THEN
835: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
836: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
837: END IF;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
842: END IF;

Line 891: IF NOT FND_API.Compatible_API_Call(l_api_version,

887: IBE_UTIL.debug('p_version_number = '||p_version_number);
888: IBE_UTIL.debug('p_media_object_id = '||p_media_object_id);
889: IBE_UTIL.debug('p_association_type_code = '||p_association_type_code);
890: END IF;
891: IF NOT FND_API.Compatible_API_Call(l_api_version,
892: p_api_version,
893: l_api_name,
894: G_PKG_NAME) THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

891: IF NOT FND_API.Compatible_API_Call(l_api_version,
892: p_api_version,
893: l_api_name,
894: G_PKG_NAME) THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897: IF FND_API.to_Boolean(p_init_msg_list) THEN
898: FND_MSG_PUB.initialize;
899: END IF;

Line 897: IF FND_API.to_Boolean(p_init_msg_list) THEN

893: l_api_name,
894: G_PKG_NAME) THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897: IF FND_API.to_Boolean(p_init_msg_list) THEN
898: FND_MSG_PUB.initialize;
899: END IF;
900:
901: x_return_status := FND_API.g_ret_sts_success;

Line 901: x_return_status := FND_API.g_ret_sts_success;

897: IF FND_API.to_Boolean(p_init_msg_list) THEN
898: FND_MSG_PUB.initialize;
899: END IF;
900:
901: x_return_status := FND_API.g_ret_sts_success;
902: l_content_item_id := p_content_item_id;
903: l_association_type_code := NVL(p_association_type_code,
904: g_association_type_code);
905: IF (l_debug = 'Y') THEN

Line 915: p_commit => FND_API.g_false,

911: IBC_CITEM_ADMIN_GRP.delete_association(
912: p_content_item_id => l_content_item_id,
913: p_association_type_code => l_association_type_code,
914: p_associated_object_val1 => TO_CHAR(p_media_object_id),
915: p_commit => FND_API.g_false,
916: p_api_version_number => 1.0,
917: p_init_msg_list => FND_API.g_false,
918: x_return_status => x_return_status,
919: x_msg_count => x_msg_count,

Line 917: p_init_msg_list => FND_API.g_false,

913: p_association_type_code => l_association_type_code,
914: p_associated_object_val1 => TO_CHAR(p_media_object_id),
915: p_commit => FND_API.g_false,
916: p_api_version_number => 1.0,
917: p_init_msg_list => FND_API.g_false,
918: x_return_status => x_return_status,
919: x_msg_count => x_msg_count,
920: x_msg_data => x_msg_data);
921: IF (l_debug = 'Y') THEN

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

920: x_msg_data => x_msg_data);
921: IF (l_debug = 'Y') THEN
922: IBE_UTIL.debug('Calling IBC_CITEM_ADMIN_GRP.delete_association ends:'||x_return_status);
923: END IF;
924: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
925: IF (l_debug = 'Y') THEN
926: IBE_UTIL.debug('Error in IBC_CITEM_ADMIN_GRP.delete_association');
927: for i in 1..x_msg_count loop
928: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 928: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

924: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
925: IF (l_debug = 'Y') THEN
926: IBE_UTIL.debug('Error in IBC_CITEM_ADMIN_GRP.delete_association');
927: for i in 1..x_msg_count loop
928: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
929: IBE_UTIL.debug(l_msg_data);
930: end loop;
931: END IF;
932: RAISE FND_API.G_EXC_ERROR;

Line 932: RAISE FND_API.G_EXC_ERROR;

928: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
929: IBE_UTIL.debug(l_msg_data);
930: end loop;
931: END IF;
932: RAISE FND_API.G_EXC_ERROR;
933: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
934: IF (l_debug = 'Y') THEN
935: IBE_UTIL.debug('Error in IBC_CITEM_ADMIN_GRP.delete_association');
936: for i in 1..x_msg_count loop

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

929: IBE_UTIL.debug(l_msg_data);
930: end loop;
931: END IF;
932: RAISE FND_API.G_EXC_ERROR;
933: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
934: IF (l_debug = 'Y') THEN
935: IBE_UTIL.debug('Error in IBC_CITEM_ADMIN_GRP.delete_association');
936: for i in 1..x_msg_count loop
937: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 937: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

933: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
934: IF (l_debug = 'Y') THEN
935: IBE_UTIL.debug('Error in IBC_CITEM_ADMIN_GRP.delete_association');
936: for i in 1..x_msg_count loop
937: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
938: IBE_UTIL.debug(l_msg_data);
939: end loop;
940: END IF;
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

937: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
938: IBE_UTIL.debug(l_msg_data);
939: end loop;
940: END IF;
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: END IF;
943: l_temp := 0;
944: IF (l_debug = 'Y') THEN
945: IBE_UTIL.debug('Check the association for the content item');

Line 967: P_Init_Msg_List => FND_API.G_FALSE,

963: IBE_UTIL.debug('p_content_item_id = '||l_content_item_id);
964: END IF;
965: Ibc_Cv_Label_Grp.Delete_CV_Label(
966: P_Api_Version_Number => 1.0,
967: P_Init_Msg_List => FND_API.G_FALSE,
968: P_Commit => FND_API.G_FALSE,
969: p_label_code => l_label_code,
970: p_content_item_id => l_content_item_id,
971: x_return_status => x_return_status,

Line 968: P_Commit => FND_API.G_FALSE,

964: END IF;
965: Ibc_Cv_Label_Grp.Delete_CV_Label(
966: P_Api_Version_Number => 1.0,
967: P_Init_Msg_List => FND_API.G_FALSE,
968: P_Commit => FND_API.G_FALSE,
969: p_label_code => l_label_code,
970: p_content_item_id => l_content_item_id,
971: x_return_status => x_return_status,
972: x_msg_count => x_msg_count,

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

973: x_msg_data => x_msg_data);
974: IF (l_debug = 'Y') THEN
975: IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Delete_CV_Label:'||x_return_status);
976: END IF;
977: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
978: IF (l_debug = 'Y') THEN
979: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
980: for i in 1..x_msg_count loop
981: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 981: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

977: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
978: IF (l_debug = 'Y') THEN
979: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
980: for i in 1..x_msg_count loop
981: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
982: IBE_UTIL.debug(l_msg_data);
983: end loop;
984: END IF;
985: RAISE FND_API.G_EXC_ERROR;

Line 985: RAISE FND_API.G_EXC_ERROR;

981: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
982: IBE_UTIL.debug(l_msg_data);
983: end loop;
984: END IF;
985: RAISE FND_API.G_EXC_ERROR;
986: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
987: IF (l_debug = 'Y') THEN
988: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
989: for i in 1..x_msg_count loop

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

982: IBE_UTIL.debug(l_msg_data);
983: end loop;
984: END IF;
985: RAISE FND_API.G_EXC_ERROR;
986: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
987: IF (l_debug = 'Y') THEN
988: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
989: for i in 1..x_msg_count loop
990: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 990: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

986: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
987: IF (l_debug = 'Y') THEN
988: IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
989: for i in 1..x_msg_count loop
990: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
991: IBE_UTIL.debug(l_msg_data);
992: end loop;
993: END IF;
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

990: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
991: IBE_UTIL.debug(l_msg_data);
992: end loop;
993: END IF;
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: END IF;
996: END IF;
997: IF (l_debug = 'Y') THEN
998: IBE_UTIL.debug('Before committing the result:'||p_commit);

Line 1000: IF (FND_API.To_Boolean(p_commit)) THEN

996: END IF;
997: IF (l_debug = 'Y') THEN
998: IBE_UTIL.debug('Before committing the result:'||p_commit);
999: END IF;
1000: IF (FND_API.To_Boolean(p_commit)) THEN
1001: COMMIT WORK;
1002: END IF;
1003: IF (l_debug = 'Y') THEN
1004: IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Delete_Label_Association ends +');

Line 1010: WHEN FND_API.G_EXC_ERROR THEN

1006: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1007: p_data => x_msg_data,
1008: p_encoded => 'F');
1009: EXCEPTION
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1014: p_data => x_msg_data,

Line 1012: x_return_status := FND_API.G_RET_STS_ERROR;

1008: p_encoded => 'F');
1009: EXCEPTION
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1014: p_data => x_msg_data,
1015: p_encoded => 'F');
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1014: p_data => x_msg_data,
1015: p_encoded => 'F');
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1017: ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1020: p_data => x_msg_data,

Line 1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1014: p_data => x_msg_data,
1015: p_encoded => 'F');
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1017: ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1020: p_data => x_msg_data,
1021: p_encoded => 'F');
1022: WHEN OTHERS THEN

Line 1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1029: IF (l_debug = 'Y') THEN
1030: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
1031: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
1032: END IF;
1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1034: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1035: THEN
1036: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1037: END IF;

Line 1062: x_return_status := FND_API.G_RET_STS_SUCCESS;

1058: SELECT item_name, access_name
1059: FROM JTF_AMV_ITEMS_VL
1060: WHERE item_id = c_media_obj_id;
1061: BEGIN
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063: IF p_association_type_code = g_association_type_code THEN
1064: OPEN c_get_media_obj_csr(p_associated_object_val1);
1065: FETCH c_get_media_obj_csr INTO x_object_name, x_object_code;
1066: CLOSE c_get_media_obj_csr;

Line 1069: WHEN FND_API.G_EXC_ERROR THEN

1065: FETCH c_get_media_obj_csr INTO x_object_name, x_object_code;
1066: CLOSE c_get_media_obj_csr;
1067: END IF;
1068: EXCEPTION
1069: WHEN FND_API.G_EXC_ERROR THEN
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1072: p_data => x_msg_data);
1073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1070: x_return_status := FND_API.G_RET_STS_ERROR;

1066: CLOSE c_get_media_obj_csr;
1067: END IF;
1068: EXCEPTION
1069: WHEN FND_API.G_EXC_ERROR THEN
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1072: p_data => x_msg_data);
1073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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