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 1797: --ibe_util.disable_debug;

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

Line 1806: --ibe_util.disable_debug;

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

Line 1827: --ibe_util.disable_debug;

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

Line 1847: --ibe_util.enable_debug;

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

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

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

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

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

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

1862: x_lang_code_tbl(l_index) := l_lang_rec.language_code;
1863: x_tran_lang_code_tbl(l_index) := l_lang_rec.language;
1864: x_desc_tbl(l_index) := l_lang_rec.description;
1865:
1866: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1867: 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));
1868: END IF;
1869:
1870: l_index := l_index + 1;

Line 1867: 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));

1863: x_tran_lang_code_tbl(l_index) := l_lang_rec.language;
1864: x_desc_tbl(l_index) := l_lang_rec.description;
1865:
1866: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1867: 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));
1868: END IF;
1869:
1870: l_index := l_index + 1;
1871: END LOOP;

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

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

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

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

Line 1876: --ibe_util.disable_debug;

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

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

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

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

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

Line 1883: --ibe_util.disable_debug;

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

Line 1907: --ibe_util.enable_debug;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1939: --ibe_util.disable_debug;

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

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

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

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

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

Line 1946: --ibe_util.disable_debug;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2136: --ibe_util.disable_debug;

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

Line 2145: --ibe_util.disable_debug;

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

Line 2166: --ibe_util.disable_debug;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2814: --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));

2810: l_model_id_tbl(idx) := p_model_id_tbl(l_table_index);
2811: --ELSE
2812: --l_model_id_tbl(idx) := FND_API.G_MISS_NUM;
2813: --END IF;
2814: --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));
2815: idx := idx + 1;
2816: END LOOP;
2817: END IF;
2818: END LOOP;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2977: --ibe_util.disable_debug;

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

Line 2986: --ibe_util.disable_debug;

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

Line 3007: --ibe_util.disable_debug;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3133: --ibe_util.disable_debug;

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

Line 3142: --ibe_util.disable_debug;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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