DBA Data[Home] [Help]

APPS.IBE_CATALOG_PRELOAD_PUB dependencies on IBE_UTIL

Line 52: --ibe_util.enable_debug;

48:
49:
50: BEGIN
51: --gzhang 08/08/2002, bug#2488246
52: --ibe_util.enable_debug;
53: -- standard call to check for call compatibility
54: IF NOT FND_API.Compatible_API_Call (l_api_version,
55: p_api_version,
56: l_api_name,

Line 70: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

66:
67: -- initialize API return status to success
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
71: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(+)');
72: END IF;
73: -- begin API body
74:

Line 71: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(+)');

67: -- initialize API return status to success
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
71: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(+)');
72: END IF;
73: -- begin API body
74:
75: OPEN x_section_id_csr FOR

Line 81: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

77: FROM IBE_DSP_SECTIONS_B s
78: WHERE sysdate between s.start_date_active and nvl(s.end_date_active,sysdate);
79:
80: -- end API body
81: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
82: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(-)');
83: END IF;
84:
85: -- standard call to get message count and if count is 1, get message info.

Line 82: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(-)');

78: WHERE sysdate between s.start_date_active and nvl(s.end_date_active,sysdate);
79:
80: -- end API body
81: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
82: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(-)');
83: END IF;
84:
85: -- standard call to get message count and if count is 1, get message info.
86: FND_MSG_PUB.Count_And_Get

Line 92: --ibe_util.disable_debug;

88: p_count => x_msg_count,
89: p_data => x_msg_data
90: );
91: --gzhang 08/08/2002, bug#2488246
92: --ibe_util.disable_debug;
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: x_return_status := FND_API.G_RET_STS_ERROR;
96: FND_MSG_PUB.Count_And_Get

Line 102: --ibe_util.disable_debug;

98: p_count => x_msg_count,
99: p_data => x_msg_data
100: );
101: --gzhang 08/08/2002, bug#2488246
102: --ibe_util.disable_debug;
103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: FND_MSG_PUB.Count_And_Get
106: ( p_encoded => FND_API.G_FALSE,

Line 111: --ibe_util.disable_debug;

107: p_count => x_msg_count,
108: p_data => x_msg_data
109: );
110: --gzhang 08/08/2002, bug#2488246
111: --ibe_util.disable_debug;
112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
115: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || '4');

Line 132: --ibe_util.disable_debug;

128: p_count => x_msg_count,
129: p_data => x_msg_data
130: );
131: --gzhang 08/08/2002, bug#2488246
132: --ibe_util.disable_debug;
133: END Get_Preload_Section_Ids;
134:
135:
136: -- Start of comments

Line 182: --ibe_util.enable_debug;

178:
179:
180: BEGIN
181: --gzhang 08/08/2002, bug#2488246
182: --ibe_util.enable_debug;
183: -- standard call to check for call compatibility
184: IF NOT FND_API.Compatible_API_Call (l_api_version,
185: p_api_version,
186: l_api_name,

Line 200: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(+)');

196:
197: -- initialize API return status to success
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199:
200: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(+)');
201: -- begin API body
202: OPEN x_item_id_csr FOR
203: SELECT DISTINCT si.INVENTORY_ITEM_ID
204: FROM IBE_DSP_SECTIONS_B s, IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_B i

Line 211: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(-)');

207: AND sysdate between s.start_date_active and nvl(s.end_date_active,sysdate)
208: AND sysdate between si.start_date_active and nvl(si.end_date_active,sysdate);
209:
210: -- end API body
211: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(-)');
212:
213: -- standard call to get message count and if count is 1, get message info.
214: FND_MSG_PUB.Count_And_Get
215: ( p_encoded => FND_API.G_FALSE,

Line 220: --ibe_util.disable_debug;

216: p_count => x_msg_count,
217: p_data => x_msg_data
218: );
219: --gzhang 08/08/2002, bug#2488246
220: --ibe_util.disable_debug;
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: FND_MSG_PUB.Count_And_Get

Line 230: --ibe_util.disable_debug;

226: p_count => x_msg_count,
227: p_data => x_msg_data
228: );
229: --gzhang 08/08/2002, bug#2488246
230: --ibe_util.disable_debug;
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Count_And_Get
234: ( p_encoded => FND_API.G_FALSE,

Line 239: --ibe_util.disable_debug;

235: p_count => x_msg_count,
236: p_data => x_msg_data
237: );
238: --gzhang 08/08/2002, bug#2488246
239: --ibe_util.disable_debug;
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
243: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 260: --ibe_util.disable_debug;

256: p_count => x_msg_count,
257: p_data => x_msg_data
258: );
259: --gzhang 08/08/2002, bug#2488246
260: --ibe_util.disable_debug;
261: END Get_Preload_Item_Ids;
262:
263:
264: