DBA Data[Home] [Help]

APPS.IBE_MSITE_INFORMATION_MGR_PVT dependencies on IBE_MSITE_INFORMATION

Line 1: PACKAGE BODY Ibe_Msite_Information_Mgr_Pvt AS

1: PACKAGE BODY Ibe_Msite_Information_Mgr_Pvt AS
2: /* $Header: IBEVMIMB.pls 120.0 2005/05/30 03:21:16 appldev noship $ */
3:
4: -- HISTORY
5: -- 12/13/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBE_MSITE_INFORMATION_MGR_PVT';

4: -- HISTORY
5: -- 12/13/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.
6: -- *********************************************************************************
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBE_MSITE_INFORMATION_MGR_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(12):= 'IBEVMIMB.pls';
10:
11: --
12: --

Line 107: Ibe_Msite_Information_Pvt.Create_Msite_Information

103: x_msite_info_return_statuses(i) := FND_API.G_RET_STS_SUCCESS;
104:
105: IF (p_operation_flags(i) = 'C') THEN
106:
107: Ibe_Msite_Information_Pvt.Create_Msite_Information
108: (
109: p_api_version => p_api_version,
110: p_init_msg_list => FND_API.G_FALSE,
111: p_commit => FND_API.G_FALSE,

Line 169: Ibe_Msite_Information_Pvt.Update_Msite_Information

165: END IF;
166:
167: ELSIF (p_operation_flags(i) = 'U') THEN
168:
169: Ibe_Msite_Information_Pvt.Update_Msite_Information
170: (
171: p_api_version => p_api_version,
172: p_init_msg_list => FND_API.G_FALSE,
173: p_commit => FND_API.G_FALSE,

Line 232: Ibe_Msite_Information_Pvt.Delete_Msite_Information

228: x_msite_information_ids(i) := p_msite_information_ids(i);
229:
230: ELSIF (p_operation_flags(i) = 'D') THEN
231:
232: Ibe_Msite_Information_Pvt.Delete_Msite_Information
233: (
234: p_api_version => p_api_version,
235: p_init_msg_list => FND_API.G_FALSE,
236: p_commit => FND_API.G_FALSE,

Line 367: FROM ibe_msite_information

363: msite_information19, msite_information20, attribute_category, attribute1,
364: attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
365: attribute8, attribute9, attribute10, attribute11, attribute12,
366: attribute13, attribute14, attribute15
367: FROM ibe_msite_information
368: WHERE msite_id = p_msite_id
369: AND msite_information_context = p_msite_information_context;
370:
371: EXCEPTION

Line 512: FROM IBE_MSITE_INFORMATION

508: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
509: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
510: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
511: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15
512: FROM IBE_MSITE_INFORMATION
513: WHERE MSITE_ID = c_msite_id;
514: BEGIN
515: SAVEPOINT DUPLICATE_MSITE_INFO_SAVE;
516: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

Line 680: IBE_MSITE_INFORMATION_MGR_PVT.Change_Msite_Info (

676: l_i := l_i + 1;
677: END LOOP;
678: CLOSE c_get_msite_info_csr;
679: IF (l_i > 1) THEN
680: IBE_MSITE_INFORMATION_MGR_PVT.Change_Msite_Info (
681: p_api_version => 1.0,
682: p_init_msg_list => FND_API.G_FALSE,
683: p_commit => p_commit,
684: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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 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 799: END Ibe_Msite_Information_Mgr_Pvt;

795: p_data => x_msg_data,
796: p_encoded => 'F');
797: END duplicate_msite_info;
798:
799: END Ibe_Msite_Information_Mgr_Pvt;