DBA Data[Home] [Help]

APPS.IBE_MSITE_INFORMATION_MGR_PVT dependencies on IBE_UTIL

Line 518: IBE_UTIL.debug('duplicate_msite Starts +');

514: BEGIN
515: SAVEPOINT DUPLICATE_MSITE_INFO_SAVE;
516: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
517: IF (l_debug = 'Y') THEN
518: IBE_UTIL.debug('duplicate_msite Starts +');
519: IBE_UTIL.debug('p_api_version = '||p_api_version);
520: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
521: IBE_UTIL.debug('p_commit = '||p_commit);
522: IBE_UTIL.debug('p_source_msite_id = '||p_source_msite_id);

Line 519: IBE_UTIL.debug('p_api_version = '||p_api_version);

515: SAVEPOINT DUPLICATE_MSITE_INFO_SAVE;
516: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
517: IF (l_debug = 'Y') THEN
518: IBE_UTIL.debug('duplicate_msite Starts +');
519: IBE_UTIL.debug('p_api_version = '||p_api_version);
520: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
521: IBE_UTIL.debug('p_commit = '||p_commit);
522: IBE_UTIL.debug('p_source_msite_id = '||p_source_msite_id);
523: IBE_UTIL.debug('p_target_msite_id = '||p_target_msite_id);

Line 520: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);

516: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
517: IF (l_debug = 'Y') THEN
518: IBE_UTIL.debug('duplicate_msite Starts +');
519: IBE_UTIL.debug('p_api_version = '||p_api_version);
520: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
521: IBE_UTIL.debug('p_commit = '||p_commit);
522: IBE_UTIL.debug('p_source_msite_id = '||p_source_msite_id);
523: IBE_UTIL.debug('p_target_msite_id = '||p_target_msite_id);
524: END IF;

Line 521: IBE_UTIL.debug('p_commit = '||p_commit);

517: IF (l_debug = 'Y') THEN
518: IBE_UTIL.debug('duplicate_msite Starts +');
519: IBE_UTIL.debug('p_api_version = '||p_api_version);
520: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
521: IBE_UTIL.debug('p_commit = '||p_commit);
522: IBE_UTIL.debug('p_source_msite_id = '||p_source_msite_id);
523: IBE_UTIL.debug('p_target_msite_id = '||p_target_msite_id);
524: END IF;
525: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 522: IBE_UTIL.debug('p_source_msite_id = '||p_source_msite_id);

518: IBE_UTIL.debug('duplicate_msite Starts +');
519: IBE_UTIL.debug('p_api_version = '||p_api_version);
520: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
521: IBE_UTIL.debug('p_commit = '||p_commit);
522: IBE_UTIL.debug('p_source_msite_id = '||p_source_msite_id);
523: IBE_UTIL.debug('p_target_msite_id = '||p_target_msite_id);
524: END IF;
525: IF NOT FND_API.Compatible_API_Call(l_api_version,
526: p_api_version,

Line 523: IBE_UTIL.debug('p_target_msite_id = '||p_target_msite_id);

519: IBE_UTIL.debug('p_api_version = '||p_api_version);
520: IBE_UTIL.debug('p_init_msg_list = '||p_init_msg_list);
521: IBE_UTIL.debug('p_commit = '||p_commit);
522: IBE_UTIL.debug('p_source_msite_id = '||p_source_msite_id);
523: IBE_UTIL.debug('p_target_msite_id = '||p_target_msite_id);
524: END IF;
525: IF NOT FND_API.Compatible_API_Call(l_api_version,
526: p_api_version,
527: l_api_name,

Line 734: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||

730: x_msg_data => l_msg_data
731: );
732: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
733: IF (l_debug = 'Y') THEN
734: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
735: 'Change_Msite_Info');
736: for i in 1..l_msg_count loop
737: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
738: IBE_UTIL.debug(l_msg_data);

Line 738: IBE_UTIL.debug(l_msg_data);

734: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
735: 'Change_Msite_Info');
736: for i in 1..l_msg_count loop
737: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
738: IBE_UTIL.debug(l_msg_data);
739: end loop;
740: END IF;
741: RAISE FND_API.G_EXC_ERROR;
742: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 744: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||

740: END IF;
741: RAISE FND_API.G_EXC_ERROR;
742: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
743: IF (l_debug = 'Y') THEN
744: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
745: 'Change_Msite_Info');
746: for i in 1..l_msg_count loop
747: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
748: IBE_UTIL.debug(l_msg_data);

Line 748: IBE_UTIL.debug(l_msg_data);

744: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
745: 'Change_Msite_Info');
746: for i in 1..l_msg_count loop
747: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
748: IBE_UTIL.debug(l_msg_data);
749: end loop;
750: END IF;
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END IF;

Line 755: IBE_UTIL.debug('Before committing the work:'||p_commit);

751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END IF;
753: END IF;
754: IF (l_debug = 'Y') THEN
755: IBE_UTIL.debug('Before committing the work:'||p_commit);
756: END IF;
757: IF (FND_API.To_Boolean(p_commit)) THEN
758: COMMIT WORK;
759: END IF;

Line 764: IBE_UTIL.debug('duplicate_msite Ends +');

760: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
761: p_data => x_msg_data,
762: p_encoded => 'F');
763: IF (l_debug = 'Y') THEN
764: IBE_UTIL.debug('duplicate_msite Ends +');
765: END IF;
766: EXCEPTION
767: WHEN FND_API.G_EXC_ERROR THEN
768: ROLLBACK TO DUPLICATE_MSITE_INFO_SAVE;

Line 787: IBE_UTIL.debug('SQLCODE:'||SQLCODE);

783: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
784: FND_MESSAGE.Set_Token('REASON', SQLERRM);
785: FND_MSG_PUB.Add;
786: IF (l_debug = 'Y') THEN
787: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
788: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
789: END IF;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 788: IBE_UTIL.debug('SQLERRM:'||SQLERRM);

784: FND_MESSAGE.Set_Token('REASON', SQLERRM);
785: FND_MSG_PUB.Add;
786: IF (l_debug = 'Y') THEN
787: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
788: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
789: END IF;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
792: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);