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_CATALOG_PVT dependencies on IBE_UTIL

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

166: -- Initialize API return status to success.
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168:
169: -- Print debugging info.
170: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
171: IBE_UTIL.debug('IBE_CATALOG_PVT.Load_Sections(+)');
172: IBE_UTIL.debug('IBE_CATALOG_PVT.p_msite_id = ' || p_msite_id);
173: END IF;
174:

Line 171: IBE_UTIL.debug('IBE_CATALOG_PVT.Load_Sections(+)');

167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168:
169: -- Print debugging info.
170: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
171: IBE_UTIL.debug('IBE_CATALOG_PVT.Load_Sections(+)');
172: IBE_UTIL.debug('IBE_CATALOG_PVT.p_msite_id = ' || p_msite_id);
173: END IF;
174:
175:

Line 172: IBE_UTIL.debug('IBE_CATALOG_PVT.p_msite_id = ' || p_msite_id);

168:
169: -- Print debugging info.
170: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
171: IBE_UTIL.debug('IBE_CATALOG_PVT.Load_Sections(+)');
172: IBE_UTIL.debug('IBE_CATALOG_PVT.p_msite_id = ' || p_msite_id);
173: END IF;
174:
175:
176: ----------------------

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

178: ----------------------
179:
180: -- Verify list of section IDs is not null.
181: IF p_sectid_tbl IS NULL THEN
182: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
183: IBE_UTIL.debug('IBE_CATALOG_PVT.Error p_sect_id_tbl is NULL');
184: END IF;
185: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_ID_OR_NAME');
186: FND_MSG_PUB.Add;

Line 183: IBE_UTIL.debug('IBE_CATALOG_PVT.Error p_sect_id_tbl is NULL');

179:
180: -- Verify list of section IDs is not null.
181: IF p_sectid_tbl IS NULL THEN
182: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
183: IBE_UTIL.debug('IBE_CATALOG_PVT.Error p_sect_id_tbl is NULL');
184: END IF;
185: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_ID_OR_NAME');
186: FND_MSG_PUB.Add;
187: RAISE FND_API.G_EXC_ERROR;

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

205: l_processed_sectid_index := 1;
206:
207: FOR j IN 1..l_sectid_tbl.COUNT LOOP
208: l_get_supersects := true;
209: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
210: IBE_UTIL.debug('IBE_CATALOG_PVT.l_sectionid_tbl('||j ||')='||l_sectid_tbl(j));
211: END IF;
212:
213: -- Check whether we already retrieved supersection information for the

Line 210: IBE_UTIL.debug('IBE_CATALOG_PVT.l_sectionid_tbl('||j ||')='||l_sectid_tbl(j));

206:
207: FOR j IN 1..l_sectid_tbl.COUNT LOOP
208: l_get_supersects := true;
209: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
210: IBE_UTIL.debug('IBE_CATALOG_PVT.l_sectionid_tbl('||j ||')='||l_sectid_tbl(j));
211: END IF;
212:
213: -- Check whether we already retrieved supersection information for the
214: -- current section ID.

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

220: END LOOP;
221:
222:
223: IF l_get_supersects THEN
224: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
225: IBE_UTIL.debug('IBE_CATALOG_PVT.l_get_supersects is TRUE');
226: END IF;
227: -- Record the current section ID in our list of "already processed section IDs".
228: l_processed_sectid_tbl.extend();

Line 225: IBE_UTIL.debug('IBE_CATALOG_PVT.l_get_supersects is TRUE');

221:
222:
223: IF l_get_supersects THEN
224: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
225: IBE_UTIL.debug('IBE_CATALOG_PVT.l_get_supersects is TRUE');
226: END IF;
227: -- Record the current section ID in our list of "already processed section IDs".
228: l_processed_sectid_tbl.extend();
229: l_processed_sectid_tbl(l_processed_sectid_index) := l_sectid_tbl(j);

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

229: l_processed_sectid_tbl(l_processed_sectid_index) := l_sectid_tbl(j);
230: l_processed_sectid_index := l_processed_sectid_index + 1;
231:
232: -- Retrieve the supersection information for the current section ID.
233: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
234: IBE_UTIL.debug('Start Calling IBE_CATALOG_PVT.GetSuperSectIDs ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
235: END IF;
236: GetSuperSectIDs(p_api_version => p_api_version,
237: x_return_status => x_return_status,

Line 234: IBE_UTIL.debug('Start Calling IBE_CATALOG_PVT.GetSuperSectIDs ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

230: l_processed_sectid_index := l_processed_sectid_index + 1;
231:
232: -- Retrieve the supersection information for the current section ID.
233: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
234: IBE_UTIL.debug('Start Calling IBE_CATALOG_PVT.GetSuperSectIDs ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
235: END IF;
236: GetSuperSectIDs(p_api_version => p_api_version,
237: x_return_status => x_return_status,
238: x_msg_count => x_msg_count,

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

239: x_msg_data => x_msg_data,
240: p_sectid => l_sectid_tbl(j),
241: p_msite_id => p_msite_id,
242: x_supersectid_csr => l_supersectid_csr);
243: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
244: IBE_UTIL.debug('End Calling IBE_CATALOG_PVT.GetSuperSectIDs ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
245: END IF;
246:
247: -- Extract the supersection information into our final output arrays.

Line 244: IBE_UTIL.debug('End Calling IBE_CATALOG_PVT.GetSuperSectIDs ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

240: p_sectid => l_sectid_tbl(j),
241: p_msite_id => p_msite_id,
242: x_supersectid_csr => l_supersectid_csr);
243: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
244: IBE_UTIL.debug('End Calling IBE_CATALOG_PVT.GetSuperSectIDs ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
245: END IF;
246:
247: -- Extract the supersection information into our final output arrays.
248: LOOP

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

247: -- Extract the supersection information into our final output arrays.
248: LOOP
249: FETCH l_supersectid_csr INTO l_tmp_id;
250: EXIT WHEN l_supersectid_csr%NOTFOUND;
251: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
252: IBE_UTIL.debug('IBE_CATALOG_PVT:value of l_tmp_id= ' || l_tmp_id);
253: END IF;
254: x_supersect_sect_tbl.EXTEND;
255: x_supersect_supersect_tbl.EXTEND;

Line 252: IBE_UTIL.debug('IBE_CATALOG_PVT:value of l_tmp_id= ' || l_tmp_id);

248: LOOP
249: FETCH l_supersectid_csr INTO l_tmp_id;
250: EXIT WHEN l_supersectid_csr%NOTFOUND;
251: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
252: IBE_UTIL.debug('IBE_CATALOG_PVT:value of l_tmp_id= ' || l_tmp_id);
253: END IF;
254: x_supersect_sect_tbl.EXTEND;
255: x_supersect_supersect_tbl.EXTEND;
256: x_supersect_sect_tbl(l_table_index) := l_sectid_tbl(j);

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

258: l_table_index := l_table_index + 1;
259:
260: END LOOP;
261: close l_supersectid_csr;
262: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
263: IBE_UTIL.debug('IBE_CATALOG_PVT:closing l_supersectid_csr');
264: END IF;
265: END IF;
266:

Line 263: IBE_UTIL.debug('IBE_CATALOG_PVT:closing l_supersectid_csr');

259:
260: END LOOP;
261: close l_supersectid_csr;
262: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
263: IBE_UTIL.debug('IBE_CATALOG_PVT:closing l_supersectid_csr');
264: END IF;
265: END IF;
266:
267: END LOOP;

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

272: IF x_supersect_supersect_tbl.COUNT = 0 THEN
273: x_supersect_supersect_tbl := NULL;
274: END IF;
275:
276: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
277: IBE_UTIL.debug('IBE_CATALOG_PVT.Before get items per sections');
278: END IF;
279: ----------------------
280: -- Get item information

Line 277: IBE_UTIL.debug('IBE_CATALOG_PVT.Before get items per sections');

273: x_supersect_supersect_tbl := NULL;
274: END IF;
275:
276: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
277: IBE_UTIL.debug('IBE_CATALOG_PVT.Before get items per sections');
278: END IF;
279: ----------------------
280: -- Get item information
281: ----------------------

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

298: IF (l_str_itms_per_sct IS NOT NULL) THEN
299:
300: l_itms_per_sct := TO_NUMBER(l_str_itms_per_sct);
301: END IF;
302: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
303: IBE_UTIL.debug('IBE_CATALOG_PVT.l_itms_per_sct'||l_itms_per_sct);
304: END IF;
305:
306: -- Loop through our list of requested section IDs and retrieve item information.

Line 303: IBE_UTIL.debug('IBE_CATALOG_PVT.l_itms_per_sct'||l_itms_per_sct);

299:
300: l_itms_per_sct := TO_NUMBER(l_str_itms_per_sct);
301: END IF;
302: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
303: IBE_UTIL.debug('IBE_CATALOG_PVT.l_itms_per_sct'||l_itms_per_sct);
304: END IF;
305:
306: -- Loop through our list of requested section IDs and retrieve item information.
307: l_table_index := 1;

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

309:
310:
311: -- Get the order by clause from the database (if any).
312: l_sid := l_sectid_tbl(i);
313: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
314: IBE_UTIL.debug('IBE_CATALOG_PVT.l_sid'||l_sid);
315: END IF;
316: OPEN l_orderby_csr(l_sid);
317: FETCH l_orderby_csr INTO l_tmp_ord_by_clause;

Line 314: IBE_UTIL.debug('IBE_CATALOG_PVT.l_sid'||l_sid);

310:
311: -- Get the order by clause from the database (if any).
312: l_sid := l_sectid_tbl(i);
313: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
314: IBE_UTIL.debug('IBE_CATALOG_PVT.l_sid'||l_sid);
315: END IF;
316: OPEN l_orderby_csr(l_sid);
317: FETCH l_orderby_csr INTO l_tmp_ord_by_clause;
318: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

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

314: IBE_UTIL.debug('IBE_CATALOG_PVT.l_sid'||l_sid);
315: END IF;
316: OPEN l_orderby_csr(l_sid);
317: FETCH l_orderby_csr INTO l_tmp_ord_by_clause;
318: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
319: IBE_UTIL.debug('IBE_CATALOG_PVT.l_tmp_ord_by_clause'||l_tmp_ord_by_clause);
320: END IF;
321: CLOSE l_orderby_csr;
322: Process_Order_By_Clause(l_tmp_ord_by_clause, l_ord_by_clause);

Line 319: IBE_UTIL.debug('IBE_CATALOG_PVT.l_tmp_ord_by_clause'||l_tmp_ord_by_clause);

315: END IF;
316: OPEN l_orderby_csr(l_sid);
317: FETCH l_orderby_csr INTO l_tmp_ord_by_clause;
318: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
319: IBE_UTIL.debug('IBE_CATALOG_PVT.l_tmp_ord_by_clause'||l_tmp_ord_by_clause);
320: END IF;
321: CLOSE l_orderby_csr;
322: Process_Order_By_Clause(l_tmp_ord_by_clause, l_ord_by_clause);
323:

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

320: END IF;
321: CLOSE l_orderby_csr;
322: Process_Order_By_Clause(l_tmp_ord_by_clause, l_ord_by_clause);
323:
324: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
325: IBE_UTIL.debug('IBE_CATALOG_PVT.After Process_order_by');
326: END IF;
327:
328: -- Retrieve the item information for the current section ID.

Line 325: IBE_UTIL.debug('IBE_CATALOG_PVT.After Process_order_by');

321: CLOSE l_orderby_csr;
322: Process_Order_By_Clause(l_tmp_ord_by_clause, l_ord_by_clause);
323:
324: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
325: IBE_UTIL.debug('IBE_CATALOG_PVT.After Process_order_by');
326: END IF;
327:
328: -- Retrieve the item information for the current section ID.
329: IF (l_itms_per_sct IS NULL) THEN

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

333: l_stmt := L_MSIV_STMT || 'ORDER BY ' || l_ord_by_clause || ', '
334: || L_SECT_MSIV_ORDER_STMT;
335: END IF;
336:
337: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
338: IBE_UTIL.debug('IBE_CATALOG_PVT.l_stmt First =' ||l_stmt);
339: END IF;
340:
341: OPEN l_itmids_csr FOR l_stmt USING l_sid ;

Line 338: IBE_UTIL.debug('IBE_CATALOG_PVT.l_stmt First =' ||l_stmt);

334: || L_SECT_MSIV_ORDER_STMT;
335: END IF;
336:
337: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
338: IBE_UTIL.debug('IBE_CATALOG_PVT.l_stmt First =' ||l_stmt);
339: END IF;
340:
341: OPEN l_itmids_csr FOR l_stmt USING l_sid ;
342: ELSE

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

347: l_stmt := 'SELECT * FROM (' || L_MSIV_STMT || 'ORDER BY ' ||
348: l_ord_by_clause || ', ' || L_SECT_MSIV_ORDER_STMT ||
349: ') WHERE rownum <= :itms_per_sct';
350: END IF;
351: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
352: IBE_UTIL.debug('IBE_CATALOG_PVT.l_stmt Second =' ||l_stmt);
353: END IF;
354: OPEN l_itmids_csr FOR l_stmt USING l_sid, l_itms_per_sct;
355: END IF;

Line 352: IBE_UTIL.debug('IBE_CATALOG_PVT.l_stmt Second =' ||l_stmt);

348: l_ord_by_clause || ', ' || L_SECT_MSIV_ORDER_STMT ||
349: ') WHERE rownum <= :itms_per_sct';
350: END IF;
351: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
352: IBE_UTIL.debug('IBE_CATALOG_PVT.l_stmt Second =' ||l_stmt);
353: END IF;
354: OPEN l_itmids_csr FOR l_stmt USING l_sid, l_itms_per_sct;
355: END IF;
356:

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

360: FETCH l_itmids_csr INTO l_tmp_itmid, l_tmp_orgid, l_tmp_usage, l_tmp_status_flag,
361: l_tmp_assoc_startdt, l_tmp_assoc_enddt,l_tmp_startdt, l_tmp_enddt;
362: EXIT WHEN l_itmids_csr%NOTFOUND;
363:
364: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
365: IBE_UTIL.debug('IBE_CATALOG_PVT.l_tmp_itmid =' ||l_tmp_itmid || ':l_tmp_orgid='||l_tmp_orgid ||
366: ':l_tmp_usage='||l_tmp_usage || ':l_tmp_status_flag='||l_tmp_status_flag||':l_tmp_startdt='||l_tmp_startdt||
367: ':l_tmp_enddt='||l_tmp_enddt|| ':l_tmp_assoc_startdt='||l_tmp_assoc_startdt||':l_tmp_assoc_enddt='||l_tmp_assoc_enddt);
368: END IF;

Line 365: IBE_UTIL.debug('IBE_CATALOG_PVT.l_tmp_itmid =' ||l_tmp_itmid || ':l_tmp_orgid='||l_tmp_orgid ||

361: l_tmp_assoc_startdt, l_tmp_assoc_enddt,l_tmp_startdt, l_tmp_enddt;
362: EXIT WHEN l_itmids_csr%NOTFOUND;
363:
364: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
365: IBE_UTIL.debug('IBE_CATALOG_PVT.l_tmp_itmid =' ||l_tmp_itmid || ':l_tmp_orgid='||l_tmp_orgid ||
366: ':l_tmp_usage='||l_tmp_usage || ':l_tmp_status_flag='||l_tmp_status_flag||':l_tmp_startdt='||l_tmp_startdt||
367: ':l_tmp_enddt='||l_tmp_enddt|| ':l_tmp_assoc_startdt='||l_tmp_assoc_startdt||':l_tmp_assoc_enddt='||l_tmp_assoc_enddt);
368: END IF;
369: x_sctitm_sectid_tbl.EXTEND;

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

388: END LOOP;
389: CLOSE l_itmids_csr;
390:
391: END LOOP;
392: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
393: IBE_UTIL.debug('IBE_CATALOG_PVT.After extracting info from output arrays');
394: END IF;
395: IF x_sctitm_itmid_tbl.COUNT = 0 THEN
396: x_sctitm_itmid_tbl := NULL;

Line 393: IBE_UTIL.debug('IBE_CATALOG_PVT.After extracting info from output arrays');

389: CLOSE l_itmids_csr;
390:
391: END LOOP;
392: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
393: IBE_UTIL.debug('IBE_CATALOG_PVT.After extracting info from output arrays');
394: END IF;
395: IF x_sctitm_itmid_tbl.COUNT = 0 THEN
396: x_sctitm_itmid_tbl := NULL;
397: END IF;

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

422: ----------------------
423: -- Standard cleanup tasks
424: ----------------------
425:
426: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
427: IBE_UTIL.debug('IBE_CATALOG_PVT.Load_Sections(-)');
428: END IF;
429:
430: -- standard call to get message count and if count is 1, get message info.

Line 427: IBE_UTIL.debug('IBE_CATALOG_PVT.Load_Sections(-)');

423: -- Standard cleanup tasks
424: ----------------------
425:
426: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
427: IBE_UTIL.debug('IBE_CATALOG_PVT.Load_Sections(-)');
428: END IF;
429:
430: -- standard call to get message count and if count is 1, get message info.
431: FND_MSG_PUB.Count_And_Get

Line 445: --ibe_util.disable_debug;

441: p_count => x_msg_count,
442: p_data => x_msg_data
443: );
444: --gzhang 08/08/2002, bug#2488246
445: --ibe_util.disable_debug;
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: FND_MSG_PUB.Count_And_Get
449: ( p_encoded => FND_API.G_FALSE,

Line 454: --ibe_util.disable_debug;

450: p_count => x_msg_count,
451: p_data => x_msg_data
452: );
453: --gzhang 08/08/2002, bug#2488246
454: --ibe_util.disable_debug;
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
458: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 537: --ibe_util.enable_debug;

533: l_preview_flag VARCHAR2(5);
534:
535: BEGIN
536: --gzhang 08/08/2002, bug#2488246
537: --ibe_util.enable_debug;
538: -- standard call to check for call compatibility
539: IF NOT FND_API.Compatible_API_Call (l_api_version,
540: p_api_version,
541: l_api_name,

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

560:
561: -- initialize API return status to success
562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563:
564: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
565: IBE_UTIL.debug('IBE_CATALOG_PVT.GetLeafSubSectIDs(+)');
566: IBE_UTIL.debug('p_sectid : p_msite_id =' || p_sectid || ' : ' || p_msite_id);
567: END IF;
568:

Line 565: IBE_UTIL.debug('IBE_CATALOG_PVT.GetLeafSubSectIDs(+)');

561: -- initialize API return status to success
562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563:
564: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
565: IBE_UTIL.debug('IBE_CATALOG_PVT.GetLeafSubSectIDs(+)');
566: IBE_UTIL.debug('p_sectid : p_msite_id =' || p_sectid || ' : ' || p_msite_id);
567: END IF;
568:
569: -- API Body

Line 566: IBE_UTIL.debug('p_sectid : p_msite_id =' || p_sectid || ' : ' || p_msite_id);

562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563:
564: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
565: IBE_UTIL.debug('IBE_CATALOG_PVT.GetLeafSubSectIDs(+)');
566: IBE_UTIL.debug('p_sectid : p_msite_id =' || p_sectid || ' : ' || p_msite_id);
567: END IF;
568:
569: -- API Body
570: IF FND_API.to_Boolean(l_preview_flag) THEN

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

617: ORDER BY mss.sort_order;
618: END IF;
619:
620: -- End API Body
621: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
622: IBE_UTIL.debug('IBE_CATALOG_PVT.GetLeafSubSectIDs(-)');
623: END IF;
624: -- standard call to get message count and if count is 1, get message info.
625: FND_MSG_PUB.Count_And_Get

Line 622: IBE_UTIL.debug('IBE_CATALOG_PVT.GetLeafSubSectIDs(-)');

618: END IF;
619:
620: -- End API Body
621: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
622: IBE_UTIL.debug('IBE_CATALOG_PVT.GetLeafSubSectIDs(-)');
623: END IF;
624: -- standard call to get message count and if count is 1, get message info.
625: FND_MSG_PUB.Count_And_Get
626: ( p_encoded => FND_API.G_FALSE,

Line 631: --ibe_util.disable_debug;

627: p_count => x_msg_count,
628: p_data => x_msg_data
629: );
630: --gzhang 08/08/2002, bug#2488246
631: --ibe_util.disable_debug;
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MSG_PUB.Count_And_Get

Line 641: --ibe_util.disable_debug;

637: p_count => x_msg_count,
638: p_data => x_msg_data
639: );
640: --gzhang 08/08/2002, bug#2488246
641: --ibe_util.disable_debug;
642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: FND_MSG_PUB.Count_And_Get
645: ( p_encoded => FND_API.G_FALSE,

Line 650: --ibe_util.disable_debug;

646: p_count => x_msg_count,
647: p_data => x_msg_data
648: );
649: --gzhang 08/08/2002, bug#2488246
650: --ibe_util.disable_debug;
651: WHEN OTHERS THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: IF FND_MSG_PUB.Check_Msg_Level
654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 666: --ibe_util.disable_debug;

662: p_count => x_msg_count,
663: p_data => x_msg_data
664: );
665: --gzhang 08/08/2002, bug#2488246
666: --ibe_util.disable_debug;
667: END GETLEAFSUBSECTIDS;
668:
669:
670:

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

743: -- Initialize API return status to success.
744: x_return_status := FND_API.G_RET_STS_SUCCESS;
745:
746: -- Print debugging info.
747: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
748: IBE_UTIL.debug('IBE_CATALOG_PVT.GetSuperSectIDs(+)');
749: IBE_UTIL.debug('p_sectid : p_msite_id =' || p_sectid || ' : ' || p_msite_id);
750: END IF;
751:

Line 748: IBE_UTIL.debug('IBE_CATALOG_PVT.GetSuperSectIDs(+)');

744: x_return_status := FND_API.G_RET_STS_SUCCESS;
745:
746: -- Print debugging info.
747: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
748: IBE_UTIL.debug('IBE_CATALOG_PVT.GetSuperSectIDs(+)');
749: IBE_UTIL.debug('p_sectid : p_msite_id =' || p_sectid || ' : ' || p_msite_id);
750: END IF;
751:
752:

Line 749: IBE_UTIL.debug('p_sectid : p_msite_id =' || p_sectid || ' : ' || p_msite_id);

745:
746: -- Print debugging info.
747: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
748: IBE_UTIL.debug('IBE_CATALOG_PVT.GetSuperSectIDs(+)');
749: IBE_UTIL.debug('p_sectid : p_msite_id =' || p_sectid || ' : ' || p_msite_id);
750: END IF;
751:
752:
753: ----------------------

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

765: ----------------------
766: -- Standard cleanup tasks
767: ----------------------
768:
769: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
770: IBE_UTIL.debug('IBE_CATALOG_PVT.GetSuperSectIDs(-)');
771: END IF;
772:
773: -- standard call to get message count and if count is 1, get message info.

Line 770: IBE_UTIL.debug('IBE_CATALOG_PVT.GetSuperSectIDs(-)');

766: -- Standard cleanup tasks
767: ----------------------
768:
769: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
770: IBE_UTIL.debug('IBE_CATALOG_PVT.GetSuperSectIDs(-)');
771: END IF;
772:
773: -- standard call to get message count and if count is 1, get message info.
774: FND_MSG_PUB.Count_And_Get

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

883:
884: -- new
885: BEGIN
886: SAVEPOINT AVAILABLE_SERVICES_PUB;
887: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
888: IBE_UTIL.Debug('Start IBE_CATALOG_PVT.GetAvailableServices');
889: IBE_UTIL.Debug(' Parms: [p_product_item_id=' || p_product_item_id || ', ' ||
890: p_customer_id || ', ' || p_product_revision || ', ' ||
891: p_request_date || ']');

Line 888: IBE_UTIL.Debug('Start IBE_CATALOG_PVT.GetAvailableServices');

884: -- new
885: BEGIN
886: SAVEPOINT AVAILABLE_SERVICES_PUB;
887: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
888: IBE_UTIL.Debug('Start IBE_CATALOG_PVT.GetAvailableServices');
889: IBE_UTIL.Debug(' Parms: [p_product_item_id=' || p_product_item_id || ', ' ||
890: p_customer_id || ', ' || p_product_revision || ', ' ||
891: p_request_date || ']');
892: END IF;

Line 889: IBE_UTIL.Debug(' Parms: [p_product_item_id=' || p_product_item_id || ', ' ||

885: BEGIN
886: SAVEPOINT AVAILABLE_SERVICES_PUB;
887: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
888: IBE_UTIL.Debug('Start IBE_CATALOG_PVT.GetAvailableServices');
889: IBE_UTIL.Debug(' Parms: [p_product_item_id=' || p_product_item_id || ', ' ||
890: p_customer_id || ', ' || p_product_revision || ', ' ||
891: p_request_date || ']');
892: END IF;
893:

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

922: l_avail_service_rec.request_date := p_request_date;
923: END IF;
924:
925:
926: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
927: IBE_UTIL.Debug('OKS_OMINT_PUB.Available_Services Starts');
928: END IF;
929:
930:

Line 927: IBE_UTIL.Debug('OKS_OMINT_PUB.Available_Services Starts');

923: END IF;
924:
925:
926: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
927: IBE_UTIL.Debug('OKS_OMINT_PUB.Available_Services Starts');
928: END IF;
929:
930:
931: OKS_OMINT_PUB.Available_Services(

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

946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
947: END IF;
948:
949: l_count := l_orderable_service_tbl.COUNT;
950: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
951: IBE_UTIL.Debug(' OKS_OMINT_PUB.Available_Services Finishes ' || x_return_status || ' ' ||
952: 'l_orderable_service_tbl.COUNT=' || l_count);
953: END IF;
954:

Line 951: IBE_UTIL.Debug(' OKS_OMINT_PUB.Available_Services Finishes ' || x_return_status || ' ' ||

947: END IF;
948:
949: l_count := l_orderable_service_tbl.COUNT;
950: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
951: IBE_UTIL.Debug(' OKS_OMINT_PUB.Available_Services Finishes ' || x_return_status || ' ' ||
952: 'l_orderable_service_tbl.COUNT=' || l_count);
953: END IF;
954:
955: x_service_item_ids := JTF_NUMBER_TABLE();

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

960: x_service_item_ids(i) := l_orderable_service_tbl(i).service_item_id;
961: END LOOP;
962: END IF;
963:
964: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
965: IBE_UTIL.Debug('End IBE_CATALOG_PVT.GetAvailableServices');
966: END IF;
967:
968: EXCEPTION

Line 965: IBE_UTIL.Debug('End IBE_CATALOG_PVT.GetAvailableServices');

961: END LOOP;
962: END IF;
963:
964: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
965: IBE_UTIL.Debug('End IBE_CATALOG_PVT.GetAvailableServices');
966: END IF;
967:
968: EXCEPTION
969: WHEN FND_API.G_EXC_ERROR THEN

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

966: END IF;
967:
968: EXCEPTION
969: WHEN FND_API.G_EXC_ERROR THEN
970: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
971: IBE_Util.Debug('Expected error IBE_CATALOG_PVT.GetAvailableServices');
972: END IF;
973:
974: ROLLBACK TO AVAILABLE_SERVICES_PUB;

Line 971: IBE_Util.Debug('Expected error IBE_CATALOG_PVT.GetAvailableServices');

967:
968: EXCEPTION
969: WHEN FND_API.G_EXC_ERROR THEN
970: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
971: IBE_Util.Debug('Expected error IBE_CATALOG_PVT.GetAvailableServices');
972: END IF;
973:
974: ROLLBACK TO AVAILABLE_SERVICES_PUB;
975: x_return_status := FND_API.G_RET_STS_ERROR;

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

976: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
977: p_count => x_msg_count,
978: p_data => x_msg_data);
979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
980: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
981: IBE_Util.Debug('Expected error IBE_CATALOG_PVT.GetAvailableServices');
982: END IF;
983:
984: ROLLBACK TO AVAILABLE_SERVICES_PUB;

Line 981: IBE_Util.Debug('Expected error IBE_CATALOG_PVT.GetAvailableServices');

977: p_count => x_msg_count,
978: p_data => x_msg_data);
979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
980: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
981: IBE_Util.Debug('Expected error IBE_CATALOG_PVT.GetAvailableServices');
982: END IF;
983:
984: ROLLBACK TO AVAILABLE_SERVICES_PUB;
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

986: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
987: p_count => x_msg_count,
988: p_data => x_msg_data);
989: WHEN OTHERS THEN
990: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
991: IBE_Util.Debug('unknown error IBE_CATALOG_PVT.GetAvailableServices');
992: END IF;
993:
994: ROLLBACK TO AVAILABLE_SERVICES_PUB;

Line 991: IBE_Util.Debug('unknown error IBE_CATALOG_PVT.GetAvailableServices');

987: p_count => x_msg_count,
988: p_data => x_msg_data);
989: WHEN OTHERS THEN
990: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
991: IBE_Util.Debug('unknown error IBE_CATALOG_PVT.GetAvailableServices');
992: END IF;
993:
994: ROLLBACK TO AVAILABLE_SERVICES_PUB;
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1087: --ibe_util.enable_debug;

1083:
1084:
1085: BEGIN
1086: --gzhang 08/08/2002, bug#2488246
1087: --ibe_util.enable_debug;
1088: -- standard call to check for call compatibility
1089: IF NOT FND_API.Compatible_API_Call (l_api_version,
1090: p_api_version,
1091: l_api_name,

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

1109:
1110: -- initialize API return status to success
1111: x_return_status := FND_API.G_RET_STS_SUCCESS;
1112:
1113: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1114: IBE_UTIL.debug('IBE_CATALOG_PVT.GETRELATEDCATORSECTIDS(+)');
1115: IBE_UTIL.debug('p_originid : p_origintype : p_reltype_code : p_dest_type ='
1116: || p_originid || ' : ' || p_origintype || ' : ' || p_reltype_code ||
1117: ' : ' || p_dest_type);

Line 1114: IBE_UTIL.debug('IBE_CATALOG_PVT.GETRELATEDCATORSECTIDS(+)');

1110: -- initialize API return status to success
1111: x_return_status := FND_API.G_RET_STS_SUCCESS;
1112:
1113: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1114: IBE_UTIL.debug('IBE_CATALOG_PVT.GETRELATEDCATORSECTIDS(+)');
1115: IBE_UTIL.debug('p_originid : p_origintype : p_reltype_code : p_dest_type ='
1116: || p_originid || ' : ' || p_origintype || ' : ' || p_reltype_code ||
1117: ' : ' || p_dest_type);
1118: END IF;

Line 1115: IBE_UTIL.debug('p_originid : p_origintype : p_reltype_code : p_dest_type ='

1111: x_return_status := FND_API.G_RET_STS_SUCCESS;
1112:
1113: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1114: IBE_UTIL.debug('IBE_CATALOG_PVT.GETRELATEDCATORSECTIDS(+)');
1115: IBE_UTIL.debug('p_originid : p_origintype : p_reltype_code : p_dest_type ='
1116: || p_originid || ' : ' || p_origintype || ' : ' || p_reltype_code ||
1117: ' : ' || p_dest_type);
1118: END IF;
1119: -- API Body

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

1196: x_relatedid_tbl := NULL;
1197: END IF;
1198:
1199: -- End API Body
1200: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1201: IBE_UTIL.debug('IBE_CATALOG_PVT.GETRELATEDCATORSECTIDS(-)');
1202: END IF ;
1203:
1204: -- standard call to get messgae count and if count is 1, get message info.

Line 1201: IBE_UTIL.debug('IBE_CATALOG_PVT.GETRELATEDCATORSECTIDS(-)');

1197: END IF;
1198:
1199: -- End API Body
1200: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1201: IBE_UTIL.debug('IBE_CATALOG_PVT.GETRELATEDCATORSECTIDS(-)');
1202: END IF ;
1203:
1204: -- standard call to get messgae count and if count is 1, get message info.
1205: FND_MSG_PUB.Count_And_Get

Line 1211: --ibe_util.disable_debug;

1207: p_count => x_msg_count,
1208: p_data => x_msg_data
1209: );
1210: --gzhang 08/08/2002, bug#2488246
1211: --ibe_util.disable_debug;
1212: EXCEPTION
1213: WHEN FND_API.G_EXC_ERROR THEN
1214: x_return_status := FND_API.G_RET_STS_ERROR;
1215: FND_MSG_PUB.Count_And_Get

Line 1221: --ibe_util.disable_debug;

1217: p_count => x_msg_count,
1218: p_data => x_msg_data
1219: );
1220: --gzhang 08/08/2002, bug#2488246
1221: --ibe_util.disable_debug;
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1224: FND_MSG_PUB.Count_And_Get
1225: ( p_encoded => FND_API.G_FALSE,

Line 1230: --ibe_util.disable_debug;

1226: p_count => x_msg_count,
1227: p_data => x_msg_data
1228: );
1229: --gzhang 08/08/2002, bug#2488246
1230: --ibe_util.disable_debug;
1231: WHEN OTHERS THEN
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: IF FND_MSG_PUB.Check_Msg_Level
1234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1246: --ibe_util.disable_debug;

1242: p_count => x_msg_count,
1243: p_data => x_msg_data
1244: );
1245: --gzhang 08/08/2002, bug#2488246
1246: --ibe_util.disable_debug;
1247: END GetRelatedCatOrSectIDs;
1248:
1249: -- Start of comments
1250: -- API name : Get_Basic_Item_Load_Query

Line 1457: --ibe_util.enable_debug;

1453: l_init_msg_list VARCHAR2(5);
1454:
1455: BEGIN
1456: --gzhang 08/08/2002, bug#2488246
1457: --ibe_util.enable_debug;
1458: -- standard call to check for call compatibility
1459: IF NOT FND_API.Compatible_API_Call (l_api_version,
1460: p_api_version,
1461: l_api_name,

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

1474:
1475: -- initialize API return status to success
1476: x_return_status := FND_API.G_RET_STS_SUCCESS;
1477:
1478: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1479: IBE_UTIL.debug('IBE_CATALOG_PVT.Get_Format_Mask_and_Symbol(+)');
1480: IBE_UTIL.debug('p_currency_code : p_length = ' || p_currency_code ||
1481: ' : ' || p_length);
1482: END IF;

Line 1479: IBE_UTIL.debug('IBE_CATALOG_PVT.Get_Format_Mask_and_Symbol(+)');

1475: -- initialize API return status to success
1476: x_return_status := FND_API.G_RET_STS_SUCCESS;
1477:
1478: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1479: IBE_UTIL.debug('IBE_CATALOG_PVT.Get_Format_Mask_and_Symbol(+)');
1480: IBE_UTIL.debug('p_currency_code : p_length = ' || p_currency_code ||
1481: ' : ' || p_length);
1482: END IF;
1483: -- begin API body

Line 1480: IBE_UTIL.debug('p_currency_code : p_length = ' || p_currency_code ||

1476: x_return_status := FND_API.G_RET_STS_SUCCESS;
1477:
1478: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1479: IBE_UTIL.debug('IBE_CATALOG_PVT.Get_Format_Mask_and_Symbol(+)');
1480: IBE_UTIL.debug('p_currency_code : p_length = ' || p_currency_code ||
1481: ' : ' || p_length);
1482: END IF;
1483: -- begin API body
1484: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

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

1480: IBE_UTIL.debug('p_currency_code : p_length = ' || p_currency_code ||
1481: ' : ' || p_length);
1482: END IF;
1483: -- begin API body
1484: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1485: IBE_UTIL.debug('Calling FND_CURRENCY.Get_Format_Mask ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1486: END IF;
1487: x_format_mask := FND_CURRENCY.Get_Format_Mask(p_currency_code, p_length);
1488: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 1485: IBE_UTIL.debug('Calling FND_CURRENCY.Get_Format_Mask ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

1481: ' : ' || p_length);
1482: END IF;
1483: -- begin API body
1484: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1485: IBE_UTIL.debug('Calling FND_CURRENCY.Get_Format_Mask ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1486: END IF;
1487: x_format_mask := FND_CURRENCY.Get_Format_Mask(p_currency_code, p_length);
1488: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1489: IBE_UTIL.debug('Return from FND_CURRENCY.Get_Format_Mask ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

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

1484: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1485: IBE_UTIL.debug('Calling FND_CURRENCY.Get_Format_Mask ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1486: END IF;
1487: x_format_mask := FND_CURRENCY.Get_Format_Mask(p_currency_code, p_length);
1488: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1489: IBE_UTIL.debug('Return from FND_CURRENCY.Get_Format_Mask ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1490: END IF;
1491: OPEN l_currency_symbol_csr(p_currency_code);
1492: FETCH l_currency_symbol_csr INTO x_currency_symbol;

Line 1489: IBE_UTIL.debug('Return from FND_CURRENCY.Get_Format_Mask ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

1485: IBE_UTIL.debug('Calling FND_CURRENCY.Get_Format_Mask ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1486: END IF;
1487: x_format_mask := FND_CURRENCY.Get_Format_Mask(p_currency_code, p_length);
1488: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1489: IBE_UTIL.debug('Return from FND_CURRENCY.Get_Format_Mask ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1490: END IF;
1491: OPEN l_currency_symbol_csr(p_currency_code);
1492: FETCH l_currency_symbol_csr INTO x_currency_symbol;
1493: CLOSE l_currency_symbol_csr;

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

1492: FETCH l_currency_symbol_csr INTO x_currency_symbol;
1493: CLOSE l_currency_symbol_csr;
1494:
1495: -- end API body
1496: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1497: IBE_UTIL.debug('IBE_CATALOG_PVT.Get_Format_Mask_and_Symbol(-)');
1498: END IF;
1499: -- standard call to get message count and if count is 1, get message info.
1500: FND_MSG_PUB.Count_And_Get

Line 1497: IBE_UTIL.debug('IBE_CATALOG_PVT.Get_Format_Mask_and_Symbol(-)');

1493: CLOSE l_currency_symbol_csr;
1494:
1495: -- end API body
1496: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1497: IBE_UTIL.debug('IBE_CATALOG_PVT.Get_Format_Mask_and_Symbol(-)');
1498: END IF;
1499: -- standard call to get message count and if count is 1, get message info.
1500: FND_MSG_PUB.Count_And_Get
1501: ( p_encoded => FND_API.G_FALSE,

Line 1506: --ibe_util.disable_debug;

1502: p_count => x_msg_count,
1503: p_data => x_msg_data
1504: );
1505: --gzhang 08/08/2002, bug#2488246
1506: --ibe_util.disable_debug;
1507: EXCEPTION
1508: WHEN FND_API.G_EXC_ERROR THEN
1509: x_return_status := FND_API.G_RET_STS_ERROR;
1510: FND_MSG_PUB.Count_And_Get

Line 1516: --ibe_util.disable_debug;

1512: p_count => x_msg_count,
1513: p_data => x_msg_data
1514: );
1515: --gzhang 08/08/2002, bug#2488246
1516: --ibe_util.disable_debug;
1517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: FND_MSG_PUB.Count_And_Get
1520: ( p_encoded => FND_API.G_FALSE,

Line 1525: --ibe_util.disable_debug;

1521: p_count => x_msg_count,
1522: p_data => x_msg_data
1523: );
1524: --gzhang 08/08/2002, bug#2488246
1525: --ibe_util.disable_debug;
1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1528: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1529: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 1546: --ibe_util.disable_debug;

1542: p_count => x_msg_count,
1543: p_data => x_msg_data
1544: );
1545: --gzhang 08/08/2002, bug#2488246
1546: --ibe_util.disable_debug;
1547: end Get_Format_Mask_and_Symbol;
1548:
1549: procedure validate_quantity
1550: (p_api_version IN NUMBER,

Line 1572: --ibe_util.enable_debug;

1568: l_init_msg_list VARCHAR2(5);
1569: begin
1570:
1571: --gzhang 08/08/2002, bug#2488246
1572: --ibe_util.enable_debug;
1573: -- standard call to check for call compatibility
1574: IF NOT FND_API.Compatible_API_Call (l_api_version,
1575: p_api_version,
1576: l_api_name,

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

1590:
1591: -- initialize API return status to success
1592: x_return_status := FND_API.G_RET_STS_SUCCESS;
1593:
1594: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1595: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(+)');
1596: END IF;
1597: -- begin API body
1598:

Line 1595: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(+)');

1591: -- initialize API return status to success
1592: x_return_status := FND_API.G_RET_STS_SUCCESS;
1593:
1594: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1595: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(+)');
1596: END IF;
1597: -- begin API body
1598:
1599: x_valid_qty_tbl := JTF_VARCHAR2_TABLE_100();

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

1600: x_valid_qty_tbl.extend(p_item_id_tbl.count);
1601:
1602: for i in 1..p_item_id_tbl.count loop
1603:
1604: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1605: IBE_UTIL.debug('Calling INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1606: END IF;
1607: inv_decimals_pub.validate_quantity(p_item_id_tbl(i), p_organization_id_tbl(i), p_qty_tbl(i),
1608: p_uom_code_tbl(i), l_output_qty, l_primary_qty, x_valid_qty_tbl(i));

Line 1605: IBE_UTIL.debug('Calling INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

1601:
1602: for i in 1..p_item_id_tbl.count loop
1603:
1604: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1605: IBE_UTIL.debug('Calling INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1606: END IF;
1607: inv_decimals_pub.validate_quantity(p_item_id_tbl(i), p_organization_id_tbl(i), p_qty_tbl(i),
1608: p_uom_code_tbl(i), l_output_qty, l_primary_qty, x_valid_qty_tbl(i));
1609: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

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

1605: IBE_UTIL.debug('Calling INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1606: END IF;
1607: inv_decimals_pub.validate_quantity(p_item_id_tbl(i), p_organization_id_tbl(i), p_qty_tbl(i),
1608: p_uom_code_tbl(i), l_output_qty, l_primary_qty, x_valid_qty_tbl(i));
1609: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1610: IBE_UTIL.debug('Return from INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1611: END IF;
1612: end loop;
1613:

Line 1610: IBE_UTIL.debug('Return from INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

1606: END IF;
1607: inv_decimals_pub.validate_quantity(p_item_id_tbl(i), p_organization_id_tbl(i), p_qty_tbl(i),
1608: p_uom_code_tbl(i), l_output_qty, l_primary_qty, x_valid_qty_tbl(i));
1609: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1610: IBE_UTIL.debug('Return from INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1611: END IF;
1612: end loop;
1613:
1614: -- end API body

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

1611: END IF;
1612: end loop;
1613:
1614: -- end API body
1615: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1616: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(-)');
1617: END IF;
1618:
1619: -- standard call to get message count and if count is 1, get message info.

Line 1616: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(-)');

1612: end loop;
1613:
1614: -- end API body
1615: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1616: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(-)');
1617: END IF;
1618:
1619: -- standard call to get message count and if count is 1, get message info.
1620: FND_MSG_PUB.Count_And_Get

Line 1626: --ibe_util.disable_debug;

1622: p_count => x_msg_count,
1623: p_data => x_msg_data
1624: );
1625: --gzhang 08/08/2002, bug#2488246
1626: --ibe_util.disable_debug;
1627: EXCEPTION
1628: WHEN FND_API.G_EXC_ERROR THEN
1629: x_return_status := FND_API.G_RET_STS_ERROR;
1630: FND_MSG_PUB.Count_And_Get

Line 1636: --ibe_util.disable_debug;

1632: p_count => x_msg_count,
1633: p_data => x_msg_data
1634: );
1635: --gzhang 08/08/2002, bug#2488246
1636: --ibe_util.disable_debug;
1637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1639: FND_MSG_PUB.Count_And_Get
1640: ( p_encoded => FND_API.G_FALSE,

Line 1645: --ibe_util.disable_debug;

1641: p_count => x_msg_count,
1642: p_data => x_msg_data
1643: );
1644: --gzhang 08/08/2002, bug#2488246
1645: --ibe_util.disable_debug;
1646: WHEN OTHERS THEN
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1649: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 1666: --ibe_util.disable_debug;

1662: p_count => x_msg_count,
1663: p_data => x_msg_data
1664: );
1665: --gzhang 08/08/2002, bug#2488246
1666: --ibe_util.disable_debug;
1667: end validate_quantity;
1668:
1669: --Bug 3063233
1670: procedure validate_de_qty_msite_check

Line 1695: --ibe_util.enable_debug;

1691:
1692: begin
1693:
1694: --gzhang 08/08/2002, bug#2488246
1695: --ibe_util.enable_debug;
1696: -- standard call to check for call compatibility
1697: IF NOT FND_API.Compatible_API_Call (l_api_version,
1698: p_api_version,
1699: l_api_name,

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

1713:
1714: -- initialize API return status to success
1715: x_return_status := FND_API.G_RET_STS_SUCCESS;
1716:
1717: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1718: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(+)');
1719: END IF;
1720:
1721: -- begin API body

Line 1718: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(+)');

1714: -- initialize API return status to success
1715: x_return_status := FND_API.G_RET_STS_SUCCESS;
1716:
1717: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1718: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(+)');
1719: END IF;
1720:
1721: -- begin API body
1722:

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

1724: x_valid_qty_tbl.extend(p_item_id_tbl.count);
1725:
1726: for i in 1..p_item_id_tbl.count loop
1727:
1728: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1729: IBE_UTIL.debug('Calling INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1730: END IF;
1731: inv_decimals_pub.validate_quantity(p_item_id_tbl(i), p_organization_id_tbl(i), p_qty_tbl(i),
1732: p_uom_code_tbl(i), l_output_qty, l_primary_qty, x_valid_qty_tbl(i));

Line 1729: IBE_UTIL.debug('Calling INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

1725:
1726: for i in 1..p_item_id_tbl.count loop
1727:
1728: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1729: IBE_UTIL.debug('Calling INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1730: END IF;
1731: inv_decimals_pub.validate_quantity(p_item_id_tbl(i), p_organization_id_tbl(i), p_qty_tbl(i),
1732: p_uom_code_tbl(i), l_output_qty, l_primary_qty, x_valid_qty_tbl(i));
1733: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

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

1729: IBE_UTIL.debug('Calling INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1730: END IF;
1731: inv_decimals_pub.validate_quantity(p_item_id_tbl(i), p_organization_id_tbl(i), p_qty_tbl(i),
1732: p_uom_code_tbl(i), l_output_qty, l_primary_qty, x_valid_qty_tbl(i));
1733: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1734: IBE_UTIL.debug('Return from INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1735: END IF;
1736: end loop;
1737:

Line 1734: IBE_UTIL.debug('Return from INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

1730: END IF;
1731: inv_decimals_pub.validate_quantity(p_item_id_tbl(i), p_organization_id_tbl(i), p_qty_tbl(i),
1732: p_uom_code_tbl(i), l_output_qty, l_primary_qty, x_valid_qty_tbl(i));
1733: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1734: IBE_UTIL.debug('Return from INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
1735: END IF;
1736: end loop;
1737:
1738: -- end API body

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

1735: END IF;
1736: end loop;
1737:
1738: -- end API body
1739: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1740: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(-)');
1741: END IF;
1742:
1743: for i in 1..x_valid_qty_tbl.count loop

Line 1740: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(-)');

1736: end loop;
1737:
1738: -- end API body
1739: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1740: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(-)');
1741: END IF;
1742:
1743: for i in 1..x_valid_qty_tbl.count loop
1744: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

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

1740: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(-)');
1741: END IF;
1742:
1743: for i in 1..x_valid_qty_tbl.count loop
1744: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1745: IBE_UTIL.debug('checking the value in x_valid_qty_tbl');
1746: END IF;
1747: if (x_valid_qty_tbl(i) = 'S') then
1748: x_valid_qty_tbl(i) := '';

Line 1745: IBE_UTIL.debug('checking the value in x_valid_qty_tbl');

1741: END IF;
1742:
1743: for i in 1..x_valid_qty_tbl.count loop
1744: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1745: IBE_UTIL.debug('checking the value in x_valid_qty_tbl');
1746: END IF;
1747: if (x_valid_qty_tbl(i) = 'S') then
1748: x_valid_qty_tbl(i) := '';
1749: else

Line 1761: --ibe_util.disable_debug;

1757: p_count => x_msg_count,
1758: p_data => x_msg_data
1759: );
1760: --gzhang 08/08/2002, bug#2488246
1761: --ibe_util.disable_debug;
1762:
1763: --do the check to see whether item belongs to a section in the minisite
1764: FOR i in 1..p_item_id_tbl.count LOOP
1765: IF (x_valid_qty_tbl(i) IS null or

Line 1796: --ibe_util.disable_debug;

1792: p_count => x_msg_count,
1793: p_data => x_msg_data
1794: );
1795: --gzhang 08/08/2002, bug#2488246
1796: --ibe_util.disable_debug;
1797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1799: FND_MSG_PUB.Count_And_Get
1800: ( p_encoded => FND_API.G_FALSE,

Line 1805: --ibe_util.disable_debug;

1801: p_count => x_msg_count,
1802: p_data => x_msg_data
1803: );
1804: --gzhang 08/08/2002, bug#2488246
1805: --ibe_util.disable_debug;
1806: WHEN OTHERS THEN
1807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1808: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1809: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 1826: --ibe_util.disable_debug;

1822: p_count => x_msg_count,
1823: p_data => x_msg_data
1824: );
1825: --gzhang 08/08/2002, bug#2488246
1826: --ibe_util.disable_debug;
1827: end validate_de_qty_msite_check;
1828:
1829: -- gzhang, 04/23/02, new APIs for Global Store Selection phase 2
1830: procedure load_msite_languages

Line 1846: --ibe_util.enable_debug;

1842: l_index NUMBER := 1;
1843:
1844: BEGIN
1845: --gzhang 08/08/2002, bug#2488246
1846: --ibe_util.enable_debug;
1847: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1848: IBE_UTIL.debug('In IBE_CATALOG_PVT.load_msite_languages...');
1849: END IF;
1850:

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

1843:
1844: BEGIN
1845: --gzhang 08/08/2002, bug#2488246
1846: --ibe_util.enable_debug;
1847: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1848: IBE_UTIL.debug('In IBE_CATALOG_PVT.load_msite_languages...');
1849: END IF;
1850:
1851: x_lang_code_tbl := JTF_VARCHAR2_TABLE_100();

Line 1848: IBE_UTIL.debug('In IBE_CATALOG_PVT.load_msite_languages...');

1844: BEGIN
1845: --gzhang 08/08/2002, bug#2488246
1846: --ibe_util.enable_debug;
1847: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1848: IBE_UTIL.debug('In IBE_CATALOG_PVT.load_msite_languages...');
1849: END IF;
1850:
1851: x_lang_code_tbl := JTF_VARCHAR2_TABLE_100();
1852: x_tran_lang_code_tbl := JTF_VARCHAR2_TABLE_100();

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

1861: x_lang_code_tbl(l_index) := l_lang_rec.language_code;
1862: x_tran_lang_code_tbl(l_index) := l_lang_rec.language;
1863: x_desc_tbl(l_index) := l_lang_rec.description;
1864:
1865: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1866: IBE_UTIL.debug('language code='||x_lang_code_tbl(l_index)||',translated language code='||x_tran_lang_code_tbl(l_index)||',desc='||x_desc_tbl(l_index));
1867: END IF;
1868:
1869: l_index := l_index + 1;

Line 1866: IBE_UTIL.debug('language code='||x_lang_code_tbl(l_index)||',translated language code='||x_tran_lang_code_tbl(l_index)||',desc='||x_desc_tbl(l_index));

1862: x_tran_lang_code_tbl(l_index) := l_lang_rec.language;
1863: x_desc_tbl(l_index) := l_lang_rec.description;
1864:
1865: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1866: IBE_UTIL.debug('language code='||x_lang_code_tbl(l_index)||',translated language code='||x_tran_lang_code_tbl(l_index)||',desc='||x_desc_tbl(l_index));
1867: END IF;
1868:
1869: l_index := l_index + 1;
1870: END LOOP;

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

1867: END IF;
1868:
1869: l_index := l_index + 1;
1870: END LOOP;
1871: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1872: IBE_UTIL.debug('IBE_CATALOG_PVT.load_msite_languages:done');
1873: END IF;
1874: --gzhang 08/08/2002, bug#2488246
1875: --ibe_util.disable_debug;

Line 1872: IBE_UTIL.debug('IBE_CATALOG_PVT.load_msite_languages:done');

1868:
1869: l_index := l_index + 1;
1870: END LOOP;
1871: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1872: IBE_UTIL.debug('IBE_CATALOG_PVT.load_msite_languages:done');
1873: END IF;
1874: --gzhang 08/08/2002, bug#2488246
1875: --ibe_util.disable_debug;
1876: EXCEPTION

Line 1875: --ibe_util.disable_debug;

1871: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1872: IBE_UTIL.debug('IBE_CATALOG_PVT.load_msite_languages:done');
1873: END IF;
1874: --gzhang 08/08/2002, bug#2488246
1875: --ibe_util.disable_debug;
1876: EXCEPTION
1877: WHEN OTHERS THEN
1878: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1879: IBE_UTIL.debug('Exception in IBE_CATALOG_PVT.load_msite_languages');

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

1874: --gzhang 08/08/2002, bug#2488246
1875: --ibe_util.disable_debug;
1876: EXCEPTION
1877: WHEN OTHERS THEN
1878: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1879: IBE_UTIL.debug('Exception in IBE_CATALOG_PVT.load_msite_languages');
1880: END IF;
1881: --gzhang 08/08/2002, bug#2488246
1882: --ibe_util.disable_debug;

Line 1879: IBE_UTIL.debug('Exception in IBE_CATALOG_PVT.load_msite_languages');

1875: --ibe_util.disable_debug;
1876: EXCEPTION
1877: WHEN OTHERS THEN
1878: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1879: IBE_UTIL.debug('Exception in IBE_CATALOG_PVT.load_msite_languages');
1880: END IF;
1881: --gzhang 08/08/2002, bug#2488246
1882: --ibe_util.disable_debug;
1883:

Line 1882: --ibe_util.disable_debug;

1878: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1879: IBE_UTIL.debug('Exception in IBE_CATALOG_PVT.load_msite_languages');
1880: END IF;
1881: --gzhang 08/08/2002, bug#2488246
1882: --ibe_util.disable_debug;
1883:
1884: END load_msite_languages;
1885:
1886: procedure load_language

Line 1906: --ibe_util.enable_debug;

1902: l_index NUMBER := 1;
1903:
1904: BEGIN
1905: --gzhang 08/08/2002, bug#2488246
1906: --ibe_util.enable_debug;
1907: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1908: IBE_UTIL.debug('In IBE_CATALOG_PVT.LOAD_LANGUAGE...');
1909: IBE_UTIL.debug('p_lang_code ='||p_lang_code);
1910: END IF;

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

1903:
1904: BEGIN
1905: --gzhang 08/08/2002, bug#2488246
1906: --ibe_util.enable_debug;
1907: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1908: IBE_UTIL.debug('In IBE_CATALOG_PVT.LOAD_LANGUAGE...');
1909: IBE_UTIL.debug('p_lang_code ='||p_lang_code);
1910: END IF;
1911:

Line 1908: IBE_UTIL.debug('In IBE_CATALOG_PVT.LOAD_LANGUAGE...');

1904: BEGIN
1905: --gzhang 08/08/2002, bug#2488246
1906: --ibe_util.enable_debug;
1907: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1908: IBE_UTIL.debug('In IBE_CATALOG_PVT.LOAD_LANGUAGE...');
1909: IBE_UTIL.debug('p_lang_code ='||p_lang_code);
1910: END IF;
1911:
1912: x_tran_lang_code_tbl := JTF_VARCHAR2_TABLE_100();

Line 1909: IBE_UTIL.debug('p_lang_code ='||p_lang_code);

1905: --gzhang 08/08/2002, bug#2488246
1906: --ibe_util.enable_debug;
1907: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1908: IBE_UTIL.debug('In IBE_CATALOG_PVT.LOAD_LANGUAGE...');
1909: IBE_UTIL.debug('p_lang_code ='||p_lang_code);
1910: END IF;
1911:
1912: x_tran_lang_code_tbl := JTF_VARCHAR2_TABLE_100();
1913: x_desc_tbl := JTF_VARCHAR2_TABLE_300(); --gzhang 07/19/2002, bug#2469521

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

1919:
1920: x_tran_lang_code_tbl(l_index) := l_lang_rec.language;
1921: x_desc_tbl(l_index) := l_lang_rec.description;
1922:
1923: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1924: IBE_UTIL.debug('translated language code='||x_tran_lang_code_tbl(l_index)||',desc='||x_desc_tbl(l_index));
1925: END IF;
1926:
1927: l_index := l_index + 1;

Line 1924: IBE_UTIL.debug('translated language code='||x_tran_lang_code_tbl(l_index)||',desc='||x_desc_tbl(l_index));

1920: x_tran_lang_code_tbl(l_index) := l_lang_rec.language;
1921: x_desc_tbl(l_index) := l_lang_rec.description;
1922:
1923: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1924: IBE_UTIL.debug('translated language code='||x_tran_lang_code_tbl(l_index)||',desc='||x_desc_tbl(l_index));
1925: END IF;
1926:
1927: l_index := l_index + 1;
1928: END LOOP;

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

1930: OPEN l_nls_lang_csr(p_lang_code);
1931: FETCH l_nls_lang_csr INTO x_nls_lang;
1932: CLOSE l_nls_lang_csr;
1933:
1934: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1935: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_LANGUAGE:done');
1936: END IF;
1937: --gzhang 08/08/2002, bug#2488246
1938: --ibe_util.disable_debug;

Line 1935: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_LANGUAGE:done');

1931: FETCH l_nls_lang_csr INTO x_nls_lang;
1932: CLOSE l_nls_lang_csr;
1933:
1934: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1935: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_LANGUAGE:done');
1936: END IF;
1937: --gzhang 08/08/2002, bug#2488246
1938: --ibe_util.disable_debug;
1939: EXCEPTION

Line 1938: --ibe_util.disable_debug;

1934: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1935: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_LANGUAGE:done');
1936: END IF;
1937: --gzhang 08/08/2002, bug#2488246
1938: --ibe_util.disable_debug;
1939: EXCEPTION
1940: WHEN OTHERS THEN
1941: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1942: IBE_UTIL.debug('Exception in IBE_CATALOG_PVT.load_language');

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

1937: --gzhang 08/08/2002, bug#2488246
1938: --ibe_util.disable_debug;
1939: EXCEPTION
1940: WHEN OTHERS THEN
1941: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1942: IBE_UTIL.debug('Exception in IBE_CATALOG_PVT.load_language');
1943: END IF ;
1944: --gzhang 08/08/2002, bug#2488246
1945: --ibe_util.disable_debug;

Line 1942: IBE_UTIL.debug('Exception in IBE_CATALOG_PVT.load_language');

1938: --ibe_util.disable_debug;
1939: EXCEPTION
1940: WHEN OTHERS THEN
1941: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1942: IBE_UTIL.debug('Exception in IBE_CATALOG_PVT.load_language');
1943: END IF ;
1944: --gzhang 08/08/2002, bug#2488246
1945: --ibe_util.disable_debug;
1946:

Line 1945: --ibe_util.disable_debug;

1941: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1942: IBE_UTIL.debug('Exception in IBE_CATALOG_PVT.load_language');
1943: END IF ;
1944: --gzhang 08/08/2002, bug#2488246
1945: --ibe_util.disable_debug;
1946:
1947: END load_language;
1948: -- gzhang, 04/23/02, end of new APIs for Global Store Selection phase 2
1949:

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

2008: -- initialize API return status to success
2009: x_return_status := FND_API.G_RET_STS_SUCCESS;
2010:
2011:
2012: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2013: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEM(+)');
2014: END IF;
2015: l_start_time := DBMS_UTILITY.GET_TIME;
2016:

Line 2013: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEM(+)');

2009: x_return_status := FND_API.G_RET_STS_SUCCESS;
2010:
2011:
2012: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2013: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEM(+)');
2014: END IF;
2015: l_start_time := DBMS_UTILITY.GET_TIME;
2016:
2017: -- get the select and from clauses of the query

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

2018: Get_Basic_Item_Load_Query(p_load_level, l_itm_stmt);
2019:
2020: IF p_itmid IS NULL THEN
2021: IF p_partnum IS NULL THEN
2022: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2023: IBE_UTIL.debug('Error: p_itm_id and p_accessname are both NULL');
2024: END IF;
2025: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_ID_OR_NAME');
2026: FND_MESSAGE.Set_Token('ID_NAME', p_partnum);

Line 2023: IBE_UTIL.debug('Error: p_itm_id and p_accessname are both NULL');

2019:
2020: IF p_itmid IS NULL THEN
2021: IF p_partnum IS NULL THEN
2022: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2023: IBE_UTIL.debug('Error: p_itm_id and p_accessname are both NULL');
2024: END IF;
2025: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_ID_OR_NAME');
2026: FND_MESSAGE.Set_Token('ID_NAME', p_partnum);
2027: FND_MSG_PUB.Add;

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

2084:
2085: -- call configurator API
2086: l_resp_id := FND_PROFILE.value('RESP_ID');
2087: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2088: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2089: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2090: ibe_util.debug('item id=' || l_itmid);
2091: ibe_util.debug('organization id=' || p_organization_id);
2092: ibe_util.debug('responsibility id=' || l_resp_id);

Line 2089: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

2085: -- call configurator API
2086: l_resp_id := FND_PROFILE.value('RESP_ID');
2087: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2088: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2089: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2090: ibe_util.debug('item id=' || l_itmid);
2091: ibe_util.debug('organization id=' || p_organization_id);
2092: ibe_util.debug('responsibility id=' || l_resp_id);
2093: ibe_util.debug('application id=' || l_resp_appl_id);

Line 2090: ibe_util.debug('item id=' || l_itmid);

2086: l_resp_id := FND_PROFILE.value('RESP_ID');
2087: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2088: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2089: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2090: ibe_util.debug('item id=' || l_itmid);
2091: ibe_util.debug('organization id=' || p_organization_id);
2092: ibe_util.debug('responsibility id=' || l_resp_id);
2093: ibe_util.debug('application id=' || l_resp_appl_id);
2094: END IF;

Line 2091: ibe_util.debug('organization id=' || p_organization_id);

2087: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2088: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2089: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2090: ibe_util.debug('item id=' || l_itmid);
2091: ibe_util.debug('organization id=' || p_organization_id);
2092: ibe_util.debug('responsibility id=' || l_resp_id);
2093: ibe_util.debug('application id=' || l_resp_appl_id);
2094: END IF;
2095:

Line 2092: ibe_util.debug('responsibility id=' || l_resp_id);

2088: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2089: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2090: ibe_util.debug('item id=' || l_itmid);
2091: ibe_util.debug('organization id=' || p_organization_id);
2092: ibe_util.debug('responsibility id=' || l_resp_id);
2093: ibe_util.debug('application id=' || l_resp_appl_id);
2094: END IF;
2095:
2096: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (l_itmid, p_organization_id, SYSDATE,

Line 2093: ibe_util.debug('application id=' || l_resp_appl_id);

2089: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2090: ibe_util.debug('item id=' || l_itmid);
2091: ibe_util.debug('organization id=' || p_organization_id);
2092: ibe_util.debug('responsibility id=' || l_resp_id);
2093: ibe_util.debug('application id=' || l_resp_appl_id);
2094: END IF;
2095:
2096: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (l_itmid, p_organization_id, SYSDATE,
2097: 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id);

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

2094: END IF;
2095:
2096: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (l_itmid, p_organization_id, SYSDATE,
2097: 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id);
2098: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2099: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2100: ibe_util.debug('ui_def_id=' || l_ui_def_id);
2101: END IF;
2102: IF l_ui_def_id IS NULL THEN

Line 2099: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

2095:
2096: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (l_itmid, p_organization_id, SYSDATE,
2097: 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id);
2098: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2099: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2100: ibe_util.debug('ui_def_id=' || l_ui_def_id);
2101: END IF;
2102: IF l_ui_def_id IS NULL THEN
2103: x_configurable := FND_API.G_FALSE;

Line 2100: ibe_util.debug('ui_def_id=' || l_ui_def_id);

2096: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (l_itmid, p_organization_id, SYSDATE,
2097: 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id);
2098: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2099: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2100: ibe_util.debug('ui_def_id=' || l_ui_def_id);
2101: END IF;
2102: IF l_ui_def_id IS NULL THEN
2103: x_configurable := FND_API.G_FALSE;
2104: ELSE

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

2111: x_model_bundle_flag := FND_API.G_FALSE;
2112: END IF;
2113:
2114: l_end_time := DBMS_UTILITY.GET_TIME;
2115: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2116: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEM(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2117: END IF;
2118: --end API body
2119:

Line 2116: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEM(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);

2112: END IF;
2113:
2114: l_end_time := DBMS_UTILITY.GET_TIME;
2115: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2116: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEM(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2117: END IF;
2118: --end API body
2119:
2120: -- standard call to get message count and if count is 1, get message info.

Line 2135: --ibe_util.disable_debug;

2131: p_count => x_msg_count,
2132: p_data => x_msg_data
2133: );
2134: --gzhang 08/08/2002, bug#2488246
2135: --ibe_util.disable_debug;
2136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2138: FND_MSG_PUB.Count_And_Get
2139: ( p_encoded => FND_API.G_FALSE,

Line 2144: --ibe_util.disable_debug;

2140: p_count => x_msg_count,
2141: p_data => x_msg_data
2142: );
2143: --gzhang 08/08/2002, bug#2488246
2144: --ibe_util.disable_debug;
2145: WHEN OTHERS THEN
2146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2147: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2148: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 2165: --ibe_util.disable_debug;

2161: p_count => x_msg_count,
2162: p_data => x_msg_data
2163: );
2164: --gzhang 08/08/2002, bug#2488246
2165: --ibe_util.disable_debug;
2166: END FETCH_ITEM;
2167:
2168: Procedure FETCH_PRICE
2169: (p_itmid IN NUMBER,

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

2217: l_end_time NUMBER;
2218:
2219:
2220: BEGIN
2221: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2222: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_PRICE(+), item ='||p_itmid);
2223: END IF;
2224: l_start_time := DBMS_UTILITY.GET_TIME;
2225:

Line 2222: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_PRICE(+), item ='||p_itmid);

2218:
2219:
2220: BEGIN
2221: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2222: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_PRICE(+), item ='||p_itmid);
2223: END IF;
2224: l_start_time := DBMS_UTILITY.GET_TIME;
2225:
2226: --don't convert model_id=-1 here

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

2232: l_model_id_tbl := JTF_NUMBER_TABLE();
2233: idx := 1;
2234: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2235: IF p_model_bundle_flag = FND_API.G_TRUE OR l_retrieve_all_uom = 'N' THEN
2236: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2237: IBE_UTIL.debug('pricing for primary uom only...');
2238: END IF;
2239: OPEN l_primary_uom_csr;
2240: FETCH l_primary_uom_csr INTO l_primary_uom;

Line 2237: IBE_UTIL.debug('pricing for primary uom only...');

2233: idx := 1;
2234: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2235: IF p_model_bundle_flag = FND_API.G_TRUE OR l_retrieve_all_uom = 'N' THEN
2236: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2237: IBE_UTIL.debug('pricing for primary uom only...');
2238: END IF;
2239: OPEN l_primary_uom_csr;
2240: FETCH l_primary_uom_csr INTO l_primary_uom;
2241: IF l_primary_uom_csr%FOUND THEN

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

2241: IF l_primary_uom_csr%FOUND THEN
2242: l_uom_code_tbl(idx) := l_primary_uom;
2243: ELSE
2244: l_uom_code_tbl(idx) := FND_API.G_MISS_CHAR;
2245: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2246: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':no primary uom code found');
2247: END IF;
2248: END IF;
2249: CLOSE l_primary_uom_csr;

Line 2246: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':no primary uom code found');

2242: l_uom_code_tbl(idx) := l_primary_uom;
2243: ELSE
2244: l_uom_code_tbl(idx) := FND_API.G_MISS_CHAR;
2245: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2246: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':no primary uom code found');
2247: END IF;
2248: END IF;
2249: CLOSE l_primary_uom_csr;
2250:

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

2253: l_model_id_tbl.EXTEND;
2254: l_model_id_tbl(idx) := l_model_id;
2255: idx := idx + 1;
2256: IF p_model_bundle_flag = FND_API.G_TRUE THEN
2257: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2258: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':loading component items...');
2259: END IF;
2260: IBE_CCTBOM_PVT.Load_Components(p_api_version =>1.0,
2261: x_return_status=>l_return_status,

Line 2258: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':loading component items...');

2254: l_model_id_tbl(idx) := l_model_id;
2255: idx := idx + 1;
2256: IF p_model_bundle_flag = FND_API.G_TRUE THEN
2257: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2258: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':loading component items...');
2259: END IF;
2260: IBE_CCTBOM_PVT.Load_Components(p_api_version =>1.0,
2261: x_return_status=>l_return_status,
2262: x_msg_data=>l_msg_data,

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

2264: p_model_id =>p_itmid,
2265: p_organization_id =>p_organization_id,
2266: x_item_csr =>l_bom_item_csr);
2267: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2268: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2269: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':adding component items..., idx='||idx);
2270: END IF;
2271: FETCH l_bom_item_csr INTO l_bom_exp_rec;
2272: WHILE l_bom_item_csr%FOUND LOOP

Line 2269: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':adding component items..., idx='||idx);

2265: p_organization_id =>p_organization_id,
2266: x_item_csr =>l_bom_item_csr);
2267: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2268: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2269: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':adding component items..., idx='||idx);
2270: END IF;
2271: FETCH l_bom_item_csr INTO l_bom_exp_rec;
2272: WHILE l_bom_item_csr%FOUND LOOP
2273: l_itmid_tbl(idx) := l_bom_exp_rec.component_item_id;

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

2278: idx := idx + 1;
2279: FETCH l_bom_item_csr INTO l_bom_exp_rec;
2280: END LOOP;
2281: CLOSE l_bom_item_csr;
2282: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2283: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':component items added to request line, idx='||idx);
2284: END IF;
2285: ELSE
2286: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 2283: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':component items added to request line, idx='||idx);

2279: FETCH l_bom_item_csr INTO l_bom_exp_rec;
2280: END LOOP;
2281: CLOSE l_bom_item_csr;
2282: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2283: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':component items added to request line, idx='||idx);
2284: END IF;
2285: ELSE
2286: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2287: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':Failed to load component items');

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

2282: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2283: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':component items added to request line, idx='||idx);
2284: END IF;
2285: ELSE
2286: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2287: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':Failed to load component items');
2288: END IF;
2289: RAISE FND_API.G_EXC_ERROR;
2290: END IF;

Line 2287: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':Failed to load component items');

2283: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':component items added to request line, idx='||idx);
2284: END IF;
2285: ELSE
2286: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2287: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':Failed to load component items');
2288: END IF;
2289: RAISE FND_API.G_EXC_ERROR;
2290: END IF;
2291: END IF;

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

2289: RAISE FND_API.G_EXC_ERROR;
2290: END IF;
2291: END IF;
2292: ELSE
2293: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2294: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': pricing for all uom codes...');
2295: END IF;
2296: FOR uom_rec IN l_item_uom_csr LOOP
2297: l_uom_code_tbl(idx) := uom_rec.UOM_CODE;

Line 2294: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': pricing for all uom codes...');

2290: END IF;
2291: END IF;
2292: ELSE
2293: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2294: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': pricing for all uom codes...');
2295: END IF;
2296: FOR uom_rec IN l_item_uom_csr LOOP
2297: l_uom_code_tbl(idx) := uom_rec.UOM_CODE;
2298: l_itmid_tbl(idx) := uom_rec.INVENTORY_ITEM_ID;

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

2302: idx := idx + 1;
2303: END LOOP;
2304: END IF;
2305:
2306: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2307: IBE_UTIL.debug('Calling IBE_PRICE_PVT.PRICE_REQUEST...');
2308: END IF;
2309: IBE_PRICE_PVT.PRICE_REQUEST(
2310: p_price_list_id => p_price_list_id,

Line 2307: IBE_UTIL.debug('Calling IBE_PRICE_PVT.PRICE_REQUEST...');

2303: END LOOP;
2304: END IF;
2305:
2306: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2307: IBE_UTIL.debug('Calling IBE_PRICE_PVT.PRICE_REQUEST...');
2308: END IF;
2309: IBE_PRICE_PVT.PRICE_REQUEST(
2310: p_price_list_id => p_price_list_id,
2311: p_currency_code => p_currency_code,

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

2323: x_return_status => x_return_status,
2324: x_return_status_text=> x_return_status_text);
2325:
2326: l_end_time := DBMS_UTILITY.GET_TIME;
2327: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2328: IBE_UTIL.debug('Return from IBE_PRICE_PVT.PRICE_REQUEST');
2329: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_PRICE(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2330: END IF;
2331: --end API body

Line 2328: IBE_UTIL.debug('Return from IBE_PRICE_PVT.PRICE_REQUEST');

2324: x_return_status_text=> x_return_status_text);
2325:
2326: l_end_time := DBMS_UTILITY.GET_TIME;
2327: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2328: IBE_UTIL.debug('Return from IBE_PRICE_PVT.PRICE_REQUEST');
2329: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_PRICE(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2330: END IF;
2331: --end API body
2332:

Line 2329: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_PRICE(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);

2325:
2326: l_end_time := DBMS_UTILITY.GET_TIME;
2327: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2328: IBE_UTIL.debug('Return from IBE_PRICE_PVT.PRICE_REQUEST');
2329: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_PRICE(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2330: END IF;
2331: --end API body
2332:
2333: EXCEPTION

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

2398:
2399: -- initialize API return status to success
2400: x_return_status := FND_API.G_RET_STS_SUCCESS;
2401:
2402: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2403: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_ITEM(+)');
2404: END IF;
2405: l_start_time := DBMS_UTILITY.GET_TIME;
2406: -- load item inventory info

Line 2403: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_ITEM(+)');

2399: -- initialize API return status to success
2400: x_return_status := FND_API.G_RET_STS_SUCCESS;
2401:
2402: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2403: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_ITEM(+)');
2404: END IF;
2405: l_start_time := DBMS_UTILITY.GET_TIME;
2406: -- load item inventory info
2407: FETCH_ITEM(

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

2443: x_return_status_text => x_price_status_text);
2444: END IF;
2445:
2446: l_end_time := DBMS_UTILITY.GET_TIME;
2447: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2448: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_ITEM(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2449: END IF;
2450: --end API body
2451:

Line 2448: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_ITEM(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);

2444: END IF;
2445:
2446: l_end_time := DBMS_UTILITY.GET_TIME;
2447: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2448: IBE_UTIL.debug('IBE_CATALOG_PVT.LOAD_ITEM(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2449: END IF;
2450: --end API body
2451:
2452: -- standard call to get message count and if count is 1, get message info.

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

2543:
2544: -- initialize API return status to success
2545: x_return_status := FND_API.G_RET_STS_SUCCESS;
2546:
2547: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2548: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEMS(+)');
2549: END IF;
2550: l_start_time := DBMS_UTILITY.GET_TIME;
2551:

Line 2548: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEMS(+)');

2544: -- initialize API return status to success
2545: x_return_status := FND_API.G_RET_STS_SUCCESS;
2546:
2547: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2548: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEMS(+)');
2549: END IF;
2550: l_start_time := DBMS_UTILITY.GET_TIME;
2551:
2552: -- get the select and from clauses of the query

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

2553: l_itmid_tbl := JTF_NUMBER_TABLE();
2554:
2555: IF p_itmid_tbl IS NULL THEN
2556: IF p_partnum_tbl IS NULL THEN
2557: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2558: IBE_UTIL.debug('Error: p_itmid_tbl and p_partnum_tbl are both NULL');
2559: END IF;
2560: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_ID_OR_NAME');
2561: FND_MESSAGE.Set_Token('ID_NAME', 'NULL');

Line 2558: IBE_UTIL.debug('Error: p_itmid_tbl and p_partnum_tbl are both NULL');

2554:
2555: IF p_itmid_tbl IS NULL THEN
2556: IF p_partnum_tbl IS NULL THEN
2557: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2558: IBE_UTIL.debug('Error: p_itmid_tbl and p_partnum_tbl are both NULL');
2559: END IF;
2560: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_ID_OR_NAME');
2561: FND_MESSAGE.Set_Token('ID_NAME', 'NULL');
2562: FND_MSG_PUB.Add;

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

2625: l_resp_id := FND_PROFILE.value('RESP_ID');
2626: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2627:
2628: FOR l_table_index IN 1..x_configurable_tbl.COUNT LOOP
2629: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2630: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2631: ibe_util.debug('item id=' || l_itmid_tbl(l_table_index));
2632: ibe_util.debug('organization id=' || p_organization_id);
2633: ibe_util.debug('responsibility id=' || l_resp_id);

Line 2630: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

2626: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2627:
2628: FOR l_table_index IN 1..x_configurable_tbl.COUNT LOOP
2629: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2630: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2631: ibe_util.debug('item id=' || l_itmid_tbl(l_table_index));
2632: ibe_util.debug('organization id=' || p_organization_id);
2633: ibe_util.debug('responsibility id=' || l_resp_id);
2634: ibe_util.debug('application id=' || l_resp_appl_id);

Line 2631: ibe_util.debug('item id=' || l_itmid_tbl(l_table_index));

2627:
2628: FOR l_table_index IN 1..x_configurable_tbl.COUNT LOOP
2629: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2630: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2631: ibe_util.debug('item id=' || l_itmid_tbl(l_table_index));
2632: ibe_util.debug('organization id=' || p_organization_id);
2633: ibe_util.debug('responsibility id=' || l_resp_id);
2634: ibe_util.debug('application id=' || l_resp_appl_id);
2635: END IF;

Line 2632: ibe_util.debug('organization id=' || p_organization_id);

2628: FOR l_table_index IN 1..x_configurable_tbl.COUNT LOOP
2629: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2630: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2631: ibe_util.debug('item id=' || l_itmid_tbl(l_table_index));
2632: ibe_util.debug('organization id=' || p_organization_id);
2633: ibe_util.debug('responsibility id=' || l_resp_id);
2634: ibe_util.debug('application id=' || l_resp_appl_id);
2635: END IF;
2636: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (l_itmid_tbl(l_table_index), p_organization_id,

Line 2633: ibe_util.debug('responsibility id=' || l_resp_id);

2629: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2630: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2631: ibe_util.debug('item id=' || l_itmid_tbl(l_table_index));
2632: ibe_util.debug('organization id=' || p_organization_id);
2633: ibe_util.debug('responsibility id=' || l_resp_id);
2634: ibe_util.debug('application id=' || l_resp_appl_id);
2635: END IF;
2636: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (l_itmid_tbl(l_table_index), p_organization_id,
2637: SYSDATE, 'DHTML', FND_API.G_MISS_NUM,

Line 2634: ibe_util.debug('application id=' || l_resp_appl_id);

2630: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2631: ibe_util.debug('item id=' || l_itmid_tbl(l_table_index));
2632: ibe_util.debug('organization id=' || p_organization_id);
2633: ibe_util.debug('responsibility id=' || l_resp_id);
2634: ibe_util.debug('application id=' || l_resp_appl_id);
2635: END IF;
2636: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (l_itmid_tbl(l_table_index), p_organization_id,
2637: SYSDATE, 'DHTML', FND_API.G_MISS_NUM,
2638: l_resp_id, l_resp_appl_id);

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

2635: END IF;
2636: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (l_itmid_tbl(l_table_index), p_organization_id,
2637: SYSDATE, 'DHTML', FND_API.G_MISS_NUM,
2638: l_resp_id, l_resp_appl_id);
2639: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2640: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2641: ibe_util.debug('ui_def_id=' || l_ui_def_id);
2642: END IF;
2643:

Line 2640: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

2636: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (l_itmid_tbl(l_table_index), p_organization_id,
2637: SYSDATE, 'DHTML', FND_API.G_MISS_NUM,
2638: l_resp_id, l_resp_appl_id);
2639: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2640: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2641: ibe_util.debug('ui_def_id=' || l_ui_def_id);
2642: END IF;
2643:
2644: IF l_ui_def_id IS NULL THEN

Line 2641: ibe_util.debug('ui_def_id=' || l_ui_def_id);

2637: SYSDATE, 'DHTML', FND_API.G_MISS_NUM,
2638: l_resp_id, l_resp_appl_id);
2639: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2640: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2641: ibe_util.debug('ui_def_id=' || l_ui_def_id);
2642: END IF;
2643:
2644: IF l_ui_def_id IS NULL THEN
2645: x_configurable_tbl(l_table_index) := FND_API.G_FALSE;

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

2654: END IF;
2655: END LOOP;
2656:
2657: l_end_time := DBMS_UTILITY.GET_TIME;
2658: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2659: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEMS(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2660: END IF;
2661: --end API body
2662:

Line 2659: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEMS(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);

2655: END LOOP;
2656:
2657: l_end_time := DBMS_UTILITY.GET_TIME;
2658: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2659: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_ITEMS(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2660: END IF;
2661: --end API body
2662:
2663: -- standard call to get message count and if count is 1, get message info.

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

2720: l_start_time NUMBER;
2721: l_end_time NUMBER;
2722:
2723: BEGIN
2724: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2725: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':BEGIN');
2726: END IF;
2727: l_start_time := DBMS_UTILITY.GET_TIME;
2728: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);

Line 2725: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':BEGIN');

2721: l_end_time NUMBER;
2722:
2723: BEGIN
2724: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2725: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':BEGIN');
2726: END IF;
2727: l_start_time := DBMS_UTILITY.GET_TIME;
2728: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2729: l_model_id_tbl := JTF_NUMBER_TABLE();

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

2727: l_start_time := DBMS_UTILITY.GET_TIME;
2728: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2729: l_model_id_tbl := JTF_NUMBER_TABLE();
2730: idx := 1;
2731: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2732: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':l_retrieve_all_uom='||l_retrieve_all_uom);
2733: END IF;
2734: FOR l_table_index IN 1..p_itmid_tbl.COUNT LOOP
2735: -- construct item id tbl, uomcode tbl to pass into pricing engine if retrieving price

Line 2732: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':l_retrieve_all_uom='||l_retrieve_all_uom);

2728: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2729: l_model_id_tbl := JTF_NUMBER_TABLE();
2730: idx := 1;
2731: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2732: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':l_retrieve_all_uom='||l_retrieve_all_uom);
2733: END IF;
2734: FOR l_table_index IN 1..p_itmid_tbl.COUNT LOOP
2735: -- construct item id tbl, uomcode tbl to pass into pricing engine if retrieving price
2736: l_itmid := p_itmid_tbl(l_table_index);

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

2734: FOR l_table_index IN 1..p_itmid_tbl.COUNT LOOP
2735: -- construct item id tbl, uomcode tbl to pass into pricing engine if retrieving price
2736: l_itmid := p_itmid_tbl(l_table_index);
2737: IF p_model_bundle_flag_tbl(l_table_index) = FND_API.G_TRUE OR l_retrieve_all_uom = 'N' THEN
2738: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2739: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': only pricing primary uom');
2740: END IF;
2741: OPEN l_primary_uom_csr(l_itmid);
2742: FETCH l_primary_uom_csr INTO l_primary_uom;

Line 2739: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': only pricing primary uom');

2735: -- construct item id tbl, uomcode tbl to pass into pricing engine if retrieving price
2736: l_itmid := p_itmid_tbl(l_table_index);
2737: IF p_model_bundle_flag_tbl(l_table_index) = FND_API.G_TRUE OR l_retrieve_all_uom = 'N' THEN
2738: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2739: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': only pricing primary uom');
2740: END IF;
2741: OPEN l_primary_uom_csr(l_itmid);
2742: FETCH l_primary_uom_csr INTO l_primary_uom;
2743: IF l_primary_uom_csr%FOUND THEN

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

2743: IF l_primary_uom_csr%FOUND THEN
2744: l_uom_code_tbl(idx) := l_primary_uom;
2745: ELSE
2746: l_uom_code_tbl(idx) := FND_API.G_MISS_CHAR;
2747: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2748: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':item has no primary uom code, item='||l_itmid);
2749: END IF;
2750: END IF;
2751: CLOSE l_primary_uom_csr;

Line 2748: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':item has no primary uom code, item='||l_itmid);

2744: l_uom_code_tbl(idx) := l_primary_uom;
2745: ELSE
2746: l_uom_code_tbl(idx) := FND_API.G_MISS_CHAR;
2747: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2748: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':item has no primary uom code, item='||l_itmid);
2749: END IF;
2750: END IF;
2751: CLOSE l_primary_uom_csr;
2752: l_itmid_tbl(idx) := l_itmid;

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

2757: l_model_id_tbl(idx) := p_model_id_tbl(l_table_index);
2758: --ELSE
2759: --l_model_id_tbl(idx) := FND_API.G_MISS_NUM;
2760: --END IF;
2761: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2762: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': item ='||l_itmid||', primary uom='||l_primary_uom);
2763: END IF;
2764: idx := idx + 1;
2765:

Line 2762: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': item ='||l_itmid||', primary uom='||l_primary_uom);

2758: --ELSE
2759: --l_model_id_tbl(idx) := FND_API.G_MISS_NUM;
2760: --END IF;
2761: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2762: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': item ='||l_itmid||', primary uom='||l_primary_uom);
2763: END IF;
2764: idx := idx + 1;
2765:
2766: IF p_model_bundle_flag_tbl(l_table_index) = FND_API.G_TRUE THEN

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

2763: END IF;
2764: idx := idx + 1;
2765:
2766: IF p_model_bundle_flag_tbl(l_table_index) = FND_API.G_TRUE THEN
2767: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2768: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':loading component items...');
2769: END IF;
2770: IBE_CCTBOM_PVT.Load_Components(p_api_version =>1.0,
2771: x_return_status=>l_return_status,

Line 2768: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':loading component items...');

2764: idx := idx + 1;
2765:
2766: IF p_model_bundle_flag_tbl(l_table_index) = FND_API.G_TRUE THEN
2767: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2768: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':loading component items...');
2769: END IF;
2770: IBE_CCTBOM_PVT.Load_Components(p_api_version =>1.0,
2771: x_return_status=>l_return_status,
2772: x_msg_data=>l_msg_data,

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

2774: p_model_id =>l_itmid,
2775: p_organization_id =>p_organization_id,
2776: x_item_csr =>l_bom_item_csr);
2777: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2778: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2779: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':adding component items..., idx='||idx);
2780: END IF;
2781: FETCH l_bom_item_csr INTO l_bom_exp_rec;
2782: WHILE l_bom_item_csr%FOUND LOOP

Line 2779: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':adding component items..., idx='||idx);

2775: p_organization_id =>p_organization_id,
2776: x_item_csr =>l_bom_item_csr);
2777: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2778: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2779: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':adding component items..., idx='||idx);
2780: END IF;
2781: FETCH l_bom_item_csr INTO l_bom_exp_rec;
2782: WHILE l_bom_item_csr%FOUND LOOP
2783: l_itmid_tbl(idx) := l_bom_exp_rec.component_item_id;

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

2788: idx := idx + 1;
2789: FETCH l_bom_item_csr INTO l_bom_exp_rec;
2790: END LOOP;
2791: CLOSE l_bom_item_csr;
2792: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2793: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':component items added to request line, idx='||idx);
2794: END IF;
2795: ELSE
2796: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 2793: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':component items added to request line, idx='||idx);

2789: FETCH l_bom_item_csr INTO l_bom_exp_rec;
2790: END LOOP;
2791: CLOSE l_bom_item_csr;
2792: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2793: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':component items added to request line, idx='||idx);
2794: END IF;
2795: ELSE
2796: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2797: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':failed to load component items');

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

2792: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2793: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':component items added to request line, idx='||idx);
2794: END IF;
2795: ELSE
2796: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2797: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':failed to load component items');
2798: END IF;
2799: END IF;
2800: END IF;

Line 2797: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':failed to load component items');

2793: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':component items added to request line, idx='||idx);
2794: END IF;
2795: ELSE
2796: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2797: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':failed to load component items');
2798: END IF;
2799: END IF;
2800: END IF;
2801: ELSE

Line 2813: --IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': line '||idx||', item='||l_itmid_tbl(idx)||',uom='||l_uom_code_tbl(idx)||',model id='||l_model_id_tbl(idx));

2809: l_model_id_tbl(idx) := p_model_id_tbl(l_table_index);
2810: --ELSE
2811: --l_model_id_tbl(idx) := FND_API.G_MISS_NUM;
2812: --END IF;
2813: --IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': line '||idx||', item='||l_itmid_tbl(idx)||',uom='||l_uom_code_tbl(idx)||',model id='||l_model_id_tbl(idx));
2814: idx := idx + 1;
2815: END LOOP;
2816: END IF;
2817: END LOOP;

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

2814: idx := idx + 1;
2815: END LOOP;
2816: END IF;
2817: END LOOP;
2818: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2819: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':uom codes loaded');
2820: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':request pricing...');
2821: END IF;
2822:

Line 2819: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':uom codes loaded');

2815: END LOOP;
2816: END IF;
2817: END LOOP;
2818: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2819: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':uom codes loaded');
2820: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':request pricing...');
2821: END IF;
2822:
2823: -- pricing

Line 2820: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':request pricing...');

2816: END IF;
2817: END LOOP;
2818: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2819: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':uom codes loaded');
2820: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':request pricing...');
2821: END IF;
2822:
2823: -- pricing
2824:

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

2840: x_return_status_text=> x_return_status_text);
2841:
2842:
2843: l_end_time := DBMS_UTILITY.GET_TIME;
2844: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2845: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':pricing done');
2846: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':END, elapsed time (s) ='||(l_end_time-l_start_time)/100);
2847: END IF;
2848: --end API body

Line 2845: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':pricing done');

2841:
2842:
2843: l_end_time := DBMS_UTILITY.GET_TIME;
2844: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2845: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':pricing done');
2846: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':END, elapsed time (s) ='||(l_end_time-l_start_time)/100);
2847: END IF;
2848: --end API body
2849:

Line 2846: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':END, elapsed time (s) ='||(l_end_time-l_start_time)/100);

2842:
2843: l_end_time := DBMS_UTILITY.GET_TIME;
2844: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2845: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':pricing done');
2846: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':END, elapsed time (s) ='||(l_end_time-l_start_time)/100);
2847: END IF;
2848: --end API body
2849:
2850: EXCEPTION

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

2850: EXCEPTION
2851: WHEN OTHERS THEN
2852: x_return_status := FND_API.G_RET_STS_ERROR;
2853: x_return_status_text :=SQLERRM;
2854: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2855: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':'||SQLERRM);
2856: END IF;
2857: END FETCH_PRICES;
2858:

Line 2855: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':'||SQLERRM);

2851: WHEN OTHERS THEN
2852: x_return_status := FND_API.G_RET_STS_ERROR;
2853: x_return_status_text :=SQLERRM;
2854: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2855: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':'||SQLERRM);
2856: END IF;
2857: END FETCH_PRICES;
2858:
2859: Procedure LOAD_ITEMS

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

2893: l_start_time NUMBER;
2894: l_end_time NUMBER;
2895: l_init_msg_list VARCHAR2(5);
2896: BEGIN
2897: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2898: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':BEGIN');
2899: END IF;
2900: IF NOT FND_API.Compatible_API_Call (l_api_version,
2901: p_api_version,

Line 2898: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':BEGIN');

2894: l_end_time NUMBER;
2895: l_init_msg_list VARCHAR2(5);
2896: BEGIN
2897: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2898: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':BEGIN');
2899: END IF;
2900: IF NOT FND_API.Compatible_API_Call (l_api_version,
2901: p_api_version,
2902: l_api_name,

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

2915: -- initialize API return status to success
2916: x_return_status := FND_API.G_RET_STS_SUCCESS;
2917:
2918: -- load inv info
2919: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2920: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': Loading inventory info...');
2921: END IF;
2922: l_start_time := DBMS_UTILITY.GET_TIME;
2923: FETCH_ITEMS(p_load_level =>p_load_level,

Line 2920: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': Loading inventory info...');

2916: x_return_status := FND_API.G_RET_STS_SUCCESS;
2917:
2918: -- load inv info
2919: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2920: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': Loading inventory info...');
2921: END IF;
2922: l_start_time := DBMS_UTILITY.GET_TIME;
2923: FETCH_ITEMS(p_load_level =>p_load_level,
2924: p_itmid_tbl =>p_itmid_tbl,

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

2933:
2934:
2935: -- pricing
2936: IF FND_API.to_Boolean(p_retrieve_price) THEN
2937: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2938: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': Loading prices...');
2939: END IF;
2940: FETCH_PRICES(
2941: p_itmid_tbl =>p_itmid_tbl,

Line 2938: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': Loading prices...');

2934:
2935: -- pricing
2936: IF FND_API.to_Boolean(p_retrieve_price) THEN
2937: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2938: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': Loading prices...');
2939: END IF;
2940: FETCH_PRICES(
2941: p_itmid_tbl =>p_itmid_tbl,
2942: p_model_bundle_flag_tbl => x_model_bundle_flag_tbl,

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

2950: x_price_csr => x_price_csr,
2951: x_line_index_tbl=> x_line_index_tbl,
2952: x_return_status => x_price_status_code,
2953: x_return_status_text => x_price_status_text);
2954: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2955: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': prices loaded');
2956: END IF;
2957: END IF;
2958: --end API body

Line 2955: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': prices loaded');

2951: x_line_index_tbl=> x_line_index_tbl,
2952: x_return_status => x_price_status_code,
2953: x_return_status_text => x_price_status_text);
2954: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2955: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||': prices loaded');
2956: END IF;
2957: END IF;
2958: --end API body
2959:

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

2959:
2960: -- standard call to get message count and if count is 1, get message info.
2961: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
2962: l_end_time := DBMS_UTILITY.GET_TIME;
2963: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2964: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':END, elapsed time (s) ='||(l_end_time-l_start_time)/100);
2965: END IF;
2966:
2967: EXCEPTION

Line 2964: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':END, elapsed time (s) ='||(l_end_time-l_start_time)/100);

2960: -- standard call to get message count and if count is 1, get message info.
2961: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
2962: l_end_time := DBMS_UTILITY.GET_TIME;
2963: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2964: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':END, elapsed time (s) ='||(l_end_time-l_start_time)/100);
2965: END IF;
2966:
2967: EXCEPTION
2968: WHEN FND_API.G_EXC_ERROR THEN

Line 2976: --ibe_util.disable_debug;

2972: p_count => x_msg_count,
2973: p_data => x_msg_data
2974: );
2975: --gzhang 08/08/2002, bug#2488246
2976: --ibe_util.disable_debug;
2977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2979: FND_MSG_PUB.Count_And_Get
2980: ( p_encoded => FND_API.G_FALSE,

Line 2985: --ibe_util.disable_debug;

2981: p_count => x_msg_count,
2982: p_data => x_msg_data
2983: );
2984: --gzhang 08/08/2002, bug#2488246
2985: --ibe_util.disable_debug;
2986: WHEN OTHERS THEN
2987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2988: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2989: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 3006: --ibe_util.disable_debug;

3002: p_count => x_msg_count,
3003: p_data => x_msg_data
3004: );
3005: --gzhang 08/08/2002, bug#2488246
3006: --ibe_util.disable_debug;
3007: END LOAD_ITEMS;
3008:
3009: PROCEDURE GET_ITEM_TYPE
3010: (

Line 3062: IBE_UTIL.INSERT_INTO_TEMP_TABLE(p_item_ids(i), 'NUM',l_temp_key, x_query_string);

3058: -- Populate the itemIds into a temporary table.
3059: FOR i in p_item_ids.FIRST .. p_item_ids.LAST
3060: LOOP
3061:
3062: IBE_UTIL.INSERT_INTO_TEMP_TABLE(p_item_ids(i), 'NUM',l_temp_key, x_query_string);
3063: END LOOP;
3064:
3065: l_resp_id := FND_PROFILE.value('RESP_ID');
3066: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');

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

3068: x_item_type := JTF_VARCHAR2_TABLE_100();
3069: x_item_type.extend(p_item_ids.COUNT);
3070:
3071: FOR l_table_index IN 1..p_item_ids.COUNT LOOP
3072: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3073: ibe_util.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3074: ibe_util.debug('item id=' || p_item_ids(l_table_index));
3075: ibe_util.debug('organization id=' || p_organization_id);
3076: ibe_util.debug('responsibility id=' || l_resp_id);

Line 3073: ibe_util.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

3069: x_item_type.extend(p_item_ids.COUNT);
3070:
3071: FOR l_table_index IN 1..p_item_ids.COUNT LOOP
3072: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3073: ibe_util.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3074: ibe_util.debug('item id=' || p_item_ids(l_table_index));
3075: ibe_util.debug('organization id=' || p_organization_id);
3076: ibe_util.debug('responsibility id=' || l_resp_id);
3077: ibe_util.debug('application id=' || l_resp_appl_id);

Line 3074: ibe_util.debug('item id=' || p_item_ids(l_table_index));

3070:
3071: FOR l_table_index IN 1..p_item_ids.COUNT LOOP
3072: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3073: ibe_util.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3074: ibe_util.debug('item id=' || p_item_ids(l_table_index));
3075: ibe_util.debug('organization id=' || p_organization_id);
3076: ibe_util.debug('responsibility id=' || l_resp_id);
3077: ibe_util.debug('application id=' || l_resp_appl_id);
3078: END IF;

Line 3075: ibe_util.debug('organization id=' || p_organization_id);

3071: FOR l_table_index IN 1..p_item_ids.COUNT LOOP
3072: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3073: ibe_util.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3074: ibe_util.debug('item id=' || p_item_ids(l_table_index));
3075: ibe_util.debug('organization id=' || p_organization_id);
3076: ibe_util.debug('responsibility id=' || l_resp_id);
3077: ibe_util.debug('application id=' || l_resp_appl_id);
3078: END IF;
3079: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_ids(l_table_index), p_organization_id,

Line 3076: ibe_util.debug('responsibility id=' || l_resp_id);

3072: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3073: ibe_util.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3074: ibe_util.debug('item id=' || p_item_ids(l_table_index));
3075: ibe_util.debug('organization id=' || p_organization_id);
3076: ibe_util.debug('responsibility id=' || l_resp_id);
3077: ibe_util.debug('application id=' || l_resp_appl_id);
3078: END IF;
3079: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_ids(l_table_index), p_organization_id,
3080: SYSDATE, 'DHTML', FND_API.G_MISS_NUM,

Line 3077: ibe_util.debug('application id=' || l_resp_appl_id);

3073: ibe_util.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3074: ibe_util.debug('item id=' || p_item_ids(l_table_index));
3075: ibe_util.debug('organization id=' || p_organization_id);
3076: ibe_util.debug('responsibility id=' || l_resp_id);
3077: ibe_util.debug('application id=' || l_resp_appl_id);
3078: END IF;
3079: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_ids(l_table_index), p_organization_id,
3080: SYSDATE, 'DHTML', FND_API.G_MISS_NUM,
3081: l_resp_id, l_resp_appl_id);

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

3078: END IF;
3079: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_ids(l_table_index), p_organization_id,
3080: SYSDATE, 'DHTML', FND_API.G_MISS_NUM,
3081: l_resp_id, l_resp_appl_id);
3082: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3083: ibe_util.debug('Return from CZ_CF_API.UI_FOR_ITEM ' ||
3084: TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3085: END IF;
3086: IF l_ui_def_id IS NULL THEN

Line 3083: ibe_util.debug('Return from CZ_CF_API.UI_FOR_ITEM ' ||

3079: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_ids(l_table_index), p_organization_id,
3080: SYSDATE, 'DHTML', FND_API.G_MISS_NUM,
3081: l_resp_id, l_resp_appl_id);
3082: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3083: ibe_util.debug('Return from CZ_CF_API.UI_FOR_ITEM ' ||
3084: TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3085: END IF;
3086: IF l_ui_def_id IS NULL THEN
3087: l_configurable := FND_API.G_FALSE;

Line 3121: l_status := IBE_UTIL.delete_from_temp_table(l_temp_key);

3117: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_STANDARD;
3118: END IF;
3119: l_table_index := l_table_index + 1;
3120: END LOOP;
3121: l_status := IBE_UTIL.delete_from_temp_table(l_temp_key);
3122: CLOSE l_itm_attr_csr;
3123: EXCEPTION
3124: WHEN FND_API.G_EXC_ERROR THEN
3125: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3132: --ibe_util.disable_debug;

3128: p_count => x_msg_count,
3129: p_data => x_msg_data
3130: );
3131: --gzhang 08/08/2002, bug#2488246
3132: --ibe_util.disable_debug;
3133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3135: FND_MSG_PUB.Count_And_Get
3136: ( p_encoded => FND_API.G_FALSE,

Line 3141: --ibe_util.disable_debug;

3137: p_count => x_msg_count,
3138: p_data => x_msg_data
3139: );
3140: --gzhang 08/08/2002, bug#2488246
3141: --ibe_util.disable_debug;
3142: WHEN OTHERS THEN
3143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3144: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3145: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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

3203: END IF;
3204:
3205: -- initialize API return status to success
3206: x_return_status := FND_API.G_RET_STS_SUCCESS;
3207: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3208: ibe_util.debug('Calling IS_ITEM_IN_MINISITE ' );
3209: END IF;
3210:
3211: -- Populate the itemIds into a temporary table.

Line 3208: ibe_util.debug('Calling IS_ITEM_IN_MINISITE ' );

3204:
3205: -- initialize API return status to success
3206: x_return_status := FND_API.G_RET_STS_SUCCESS;
3207: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3208: ibe_util.debug('Calling IS_ITEM_IN_MINISITE ' );
3209: END IF;
3210:
3211: -- Populate the itemIds into a temporary table.
3212: FOR i in p_item_ids.FIRST .. p_item_ids.LAST

Line 3214: IBE_UTIL.INSERT_INTO_TEMP_TABLE(p_item_ids(i), 'NUM',l_temp_key, x_query_string);

3210:
3211: -- Populate the itemIds into a temporary table.
3212: FOR i in p_item_ids.FIRST .. p_item_ids.LAST
3213: LOOP
3214: IBE_UTIL.INSERT_INTO_TEMP_TABLE(p_item_ids(i), 'NUM',l_temp_key, x_query_string);
3215: END LOOP;
3216:
3217: x_minisite_item_ids := JTF_NUMBER_TABLE();
3218: l_item_index :=1;

Line 3228: l_status := IBE_UTIL.delete_from_temp_table(l_temp_key);

3224: x_minisite_item_ids.extend();
3225: x_minisite_item_ids(l_item_index) := l_item_id;
3226: l_item_index := l_item_index + 1;
3227: END LOOP;
3228: l_status := IBE_UTIL.delete_from_temp_table(l_temp_key);
3229: CLOSE l_itms_msite_csr;
3230: EXCEPTION
3231: WHEN FND_API.G_EXC_ERROR THEN
3232: x_return_status := FND_API.G_RET_STS_ERROR;

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

3276: l_resp_appl_id NUMBER;
3277: BEGIN
3278: l_resp_id := FND_PROFILE.value('RESP_ID');
3279: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3280: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3281: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3282: ibe_util.debug('item id=' || p_item_id);
3283: ibe_util.debug('organization id=' || p_organization_id);
3284: ibe_util.debug('responsibility id=' || l_resp_id);

Line 3281: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

3277: BEGIN
3278: l_resp_id := FND_PROFILE.value('RESP_ID');
3279: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3280: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3281: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3282: ibe_util.debug('item id=' || p_item_id);
3283: ibe_util.debug('organization id=' || p_organization_id);
3284: ibe_util.debug('responsibility id=' || l_resp_id);
3285: ibe_util.debug('application id=' || l_resp_appl_id);

Line 3282: ibe_util.debug('item id=' || p_item_id);

3278: l_resp_id := FND_PROFILE.value('RESP_ID');
3279: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3280: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3281: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3282: ibe_util.debug('item id=' || p_item_id);
3283: ibe_util.debug('organization id=' || p_organization_id);
3284: ibe_util.debug('responsibility id=' || l_resp_id);
3285: ibe_util.debug('application id=' || l_resp_appl_id);
3286: END IF;

Line 3283: ibe_util.debug('organization id=' || p_organization_id);

3279: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3280: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3281: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3282: ibe_util.debug('item id=' || p_item_id);
3283: ibe_util.debug('organization id=' || p_organization_id);
3284: ibe_util.debug('responsibility id=' || l_resp_id);
3285: ibe_util.debug('application id=' || l_resp_appl_id);
3286: END IF;
3287:

Line 3284: ibe_util.debug('responsibility id=' || l_resp_id);

3280: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3281: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3282: ibe_util.debug('item id=' || p_item_id);
3283: ibe_util.debug('organization id=' || p_organization_id);
3284: ibe_util.debug('responsibility id=' || l_resp_id);
3285: ibe_util.debug('application id=' || l_resp_appl_id);
3286: END IF;
3287:
3288: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_id, p_organization_id, SYSDATE,

Line 3285: ibe_util.debug('application id=' || l_resp_appl_id);

3281: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3282: ibe_util.debug('item id=' || p_item_id);
3283: ibe_util.debug('organization id=' || p_organization_id);
3284: ibe_util.debug('responsibility id=' || l_resp_id);
3285: ibe_util.debug('application id=' || l_resp_appl_id);
3286: END IF;
3287:
3288: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_id, p_organization_id, SYSDATE,
3289: 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id);

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

3286: END IF;
3287:
3288: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_id, p_organization_id, SYSDATE,
3289: 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id);
3290: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3291: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3292: ibe_util.debug('ui_def_id=' || l_ui_def_id);
3293: END IF;
3294: IF l_ui_def_id IS NULL THEN

Line 3291: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

3287:
3288: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_id, p_organization_id, SYSDATE,
3289: 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id);
3290: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3291: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3292: ibe_util.debug('ui_def_id=' || l_ui_def_id);
3293: END IF;
3294: IF l_ui_def_id IS NULL THEN
3295: x_configurable := FND_API.G_FALSE;

Line 3292: ibe_util.debug('ui_def_id=' || l_ui_def_id);

3288: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM (p_item_id, p_organization_id, SYSDATE,
3289: 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id);
3290: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3291: IBE_UTIL.debug('Return from CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3292: ibe_util.debug('ui_def_id=' || l_ui_def_id);
3293: END IF;
3294: IF l_ui_def_id IS NULL THEN
3295: x_configurable := FND_API.G_FALSE;
3296: ELSE