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_CATALOG_PVT

Line 1: PACKAGE BODY IBE_CATALOG_PVT AS

1: PACKAGE BODY IBE_CATALOG_PVT AS
2: /* $Header: IBEVCCTB.pls 120.7 2006/07/19 19:15:01 abhandar ship $ */
3:
4:
5:

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1848: IBE_UTIL.debug('In IBE_CATALOG_PVT.load_msite_languages...');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3100: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_MODEL;

3096: END IF;
3097:
3098:
3099: IF (l_model_bundle_flag = FND_API.G_TRUE OR l_configurable = FND_API.G_TRUE) THEN
3100: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_MODEL;
3101: END IF;
3102: END LOOP;
3103:
3104: -- check if the item is a service/serviceable product.

Line 3112: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_SERVICE;

3108: FETCH l_itm_attr_csr INTO l_service_item_flag, l_serviceable_product_flag;
3109: EXIT WHEN l_itm_attr_csr%NOTFOUND;
3110: IF ( ( x_item_type(l_table_index) IS NULL ) AND
3111: ( l_service_item_flag = 'Y' )) THEN
3112: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_SERVICE;
3113: ELSIF ( ( x_item_type(l_table_index) IS NULL ) AND
3114: ( l_serviceable_product_flag = 'Y') ) THEN
3115: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_SERVICEABLE;
3116: ELSIF ( x_item_type(l_table_index) IS NULL ) THEN

Line 3115: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_SERVICEABLE;

3111: ( l_service_item_flag = 'Y' )) THEN
3112: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_SERVICE;
3113: ELSIF ( ( x_item_type(l_table_index) IS NULL ) AND
3114: ( l_serviceable_product_flag = 'Y') ) THEN
3115: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_SERVICEABLE;
3116: ELSIF ( x_item_type(l_table_index) IS NULL ) THEN
3117: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_STANDARD;
3118: END IF;
3119: l_table_index := l_table_index + 1;

Line 3117: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_STANDARD;

3113: ELSIF ( ( x_item_type(l_table_index) IS NULL ) AND
3114: ( l_serviceable_product_flag = 'Y') ) THEN
3115: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_SERVICEABLE;
3116: ELSIF ( x_item_type(l_table_index) IS NULL ) THEN
3117: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_STANDARD;
3118: END IF;
3119: l_table_index := l_table_index + 1;
3120: END LOOP;
3121: l_status := IBE_UTIL.delete_from_temp_table(l_temp_key);

Line 3301: END IBE_CATALOG_PVT;

3297: x_configurable := FND_API.G_TRUE;
3298: END IF;
3299: END IS_ITEM_CONFIGURABLE;
3300:
3301: END IBE_CATALOG_PVT;