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.8 2010/09/14 08:47:50 amaheshw 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 3101: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_MODEL;

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

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

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

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

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

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

3114: ELSIF ( ( x_item_type(l_table_index) IS NULL ) AND
3115: ( l_serviceable_product_flag = 'Y') ) THEN
3116: x_item_type(l_table_index) := IBE_CATALOG_PVT.G_ITEM_SERVICEABLE;
3117: ELSIF ( x_item_type(l_table_index) IS NULL ) THEN
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);

Line 3302: END IBE_CATALOG_PVT;

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