46:
47: -- return NULL;
48: EXCEPTION
49: WHEN OTHERS THEN
50: htp.p('Exception in Lov package Q_Comp_subinventory');
51: htp.p(SQLERRM);
52: END;
53: -------------------------------------------------------------------------------------------
54: --
47: -- return NULL;
48: EXCEPTION
49: WHEN OTHERS THEN
50: htp.p('Exception in Lov package Q_Comp_subinventory');
51: htp.p(SQLERRM);
52: END;
53: -------------------------------------------------------------------------------------------
54: --
55: -- Bug 5003509. R12 Performance fix. Obsoleted the function.
91: */
92: return NULL;
93: EXCEPTION
94: WHEN OTHERS THEN
95: htp.p('Exception in Lov package Q_Customers');
96: htp.p(SQLERRM);
97: END;
98: -------------------------------------------------------------------------------------------
99:
92: return NULL;
93: EXCEPTION
94: WHEN OTHERS THEN
95: htp.p('Exception in Lov package Q_Customers');
96: htp.p(SQLERRM);
97: END;
98: -------------------------------------------------------------------------------------------
99:
100: function Q_Department (
119:
120: -- return NULL;
121: EXCEPTION
122: WHEN OTHERS THEN
123: htp.p('Exception in Lov package Q_Department');
124: htp.p(SQLERRM);
125: END;
126: -------------------------------------------------------------------------------------------
127: --
120: -- return NULL;
121: EXCEPTION
122: WHEN OTHERS THEN
123: htp.p('Exception in Lov package Q_Department');
124: htp.p(SQLERRM);
125: END;
126: -------------------------------------------------------------------------------------------
127: --
128: -- Bug 5003509. R12 Performance fix. Obsoleted the function.
156: Return sql_stmt;
157: -- return NULL;
158: EXCEPTION
159: WHEN OTHERS THEN
160: htp.p('Exception in Lov package Q_Line');
161: htp.p(SQLERRM);
162: END;
163: -------------------------------------------------------------------------------------------
164:
157: -- return NULL;
158: EXCEPTION
159: WHEN OTHERS THEN
160: htp.p('Exception in Lov package Q_Line');
161: htp.p(SQLERRM);
162: END;
163: -------------------------------------------------------------------------------------------
164:
165: function Q_Lot_Number (
175: -- equivalent in selfservice
176: return 'DEP_ERROR';
177: EXCEPTION
178: WHEN OTHERS THEN
179: htp.p('Exception in Lov package Q_Lot_Number');
180: htp.p(SQLERRM);
181: END;
182: -------------------------------------------------------------------------------------------
183:
176: return 'DEP_ERROR';
177: EXCEPTION
178: WHEN OTHERS THEN
179: htp.p('Exception in Lov package Q_Lot_Number');
180: htp.p(SQLERRM);
181: END;
182: -------------------------------------------------------------------------------------------
183:
184: function Q_Po_Headers (
199: */
200: return NULL;
201: EXCEPTION
202: WHEN OTHERS THEN
203: htp.p('Exception in Lov package Q_Po_Headers');
204: htp.p(SQLERRM);
205: END;
206: -------------------------------------------------------------------------------------------
207: --
200: return NULL;
201: EXCEPTION
202: WHEN OTHERS THEN
203: htp.p('Exception in Lov package Q_Po_Headers');
204: htp.p(SQLERRM);
205: END;
206: -------------------------------------------------------------------------------------------
207: --
208: -- Bug 5003509. R12 Performance fix. Obsoleted the function.
273: */
274: return NULL;
275: EXCEPTION
276: WHEN OTHERS THEN
277: htp.p('Exception in Lov package Q_Project');
278: htp.p(SQLERRM);
279: END;
280: -------------------------------------------------------------------------------------------
281:
274: return NULL;
275: EXCEPTION
276: WHEN OTHERS THEN
277: htp.p('Exception in Lov package Q_Project');
278: htp.p(SQLERRM);
279: END;
280: -------------------------------------------------------------------------------------------
281:
282: function Q_Receipt_Nums (
300: */
301: return NULL;
302: EXCEPTION
303: WHEN OTHERS THEN
304: htp.p('Exception in Lov package Q_Receipt_Nums');
305: htp.p(SQLERRM);
306: END;
307: -------------------------------------------------------------------------------------------
308:
301: return NULL;
302: EXCEPTION
303: WHEN OTHERS THEN
304: htp.p('Exception in Lov package Q_Receipt_Nums');
305: htp.p(SQLERRM);
306: END;
307: -------------------------------------------------------------------------------------------
308:
309: function Q_Resource (
322: Return sql_stmt;
323: -- return NULL;
324: EXCEPTION
325: WHEN OTHERS THEN
326: htp.p('Exception in Lov package Q_Resource');
327: htp.p(SQLERRM);
328: END;
329: -------------------------------------------------------------------------------------------
330: --
323: -- return NULL;
324: EXCEPTION
325: WHEN OTHERS THEN
326: htp.p('Exception in Lov package Q_Resource');
327: htp.p(SQLERRM);
328: END;
329: -------------------------------------------------------------------------------------------
330: --
331: -- Bug 5003509. R12 Performance fix. Obsoleted the function.
364: */
365: return NULL;
366: EXCEPTION
367: WHEN OTHERS THEN
368: htp.p('Exception in Lov package Q_Rma_Number');
369: htp.p(SQLERRM);
370: END;
371: -------------------------------------------------------------------------------------------
372:
365: return NULL;
366: EXCEPTION
367: WHEN OTHERS THEN
368: htp.p('Exception in Lov package Q_Rma_Number');
369: htp.p(SQLERRM);
370: END;
371: -------------------------------------------------------------------------------------------
372:
373: function Q_Serial_Number (
381: -- not in selfservice - look at lot num for similar comment
382: return 'DEP_ERROR';
383: EXCEPTION
384: WHEN OTHERS THEN
385: htp.p('Exception in Lov package Q_Serial_Number');
386: htp.p(SQLERRM);
387: END;
388: -------------------------------------------------------------------------------------------
389:
382: return 'DEP_ERROR';
383: EXCEPTION
384: WHEN OTHERS THEN
385: htp.p('Exception in Lov package Q_Serial_Number');
386: htp.p(SQLERRM);
387: END;
388: -------------------------------------------------------------------------------------------
389:
390: function Q_Sales_Orders (
408: */
409: return NULL;
410: EXCEPTION
411: WHEN OTHERS THEN
412: htp.p('Exception in Lov package Q_Sales_Orders');
413: htp.p(SQLERRM);
414: END;
415: -------------------------------------------------------------------------------------------
416:
409: return NULL;
410: EXCEPTION
411: WHEN OTHERS THEN
412: htp.p('Exception in Lov package Q_Sales_Orders');
413: htp.p(SQLERRM);
414: END;
415: -------------------------------------------------------------------------------------------
416:
417: function Q_Subinventory (
430:
431: RETURN sql_stmt;
432: EXCEPTION
433: WHEN OTHERS THEN
434: htp.p('Exception in Lov package Q_Subinventory');
435: htp.p(SQLERRM);
436: END;
437: -------------------------------------------------------------------------------------------
438: --
431: RETURN sql_stmt;
432: EXCEPTION
433: WHEN OTHERS THEN
434: htp.p('Exception in Lov package Q_Subinventory');
435: htp.p(SQLERRM);
436: END;
437: -------------------------------------------------------------------------------------------
438: --
439: -- Bug 5003509. R12 Performance fix. Obsoleted the function.
483: */
484: return NULL;
485: EXCEPTION
486: WHEN OTHERS THEN
487: htp.p('Exception in Lov package Q_Vendors');
488: htp.p(SQLERRM);
489: END;
490: -------------------------------------------------------------------------------------------
491:
484: return NULL;
485: EXCEPTION
486: WHEN OTHERS THEN
487: htp.p('Exception in Lov package Q_Vendors');
488: htp.p(SQLERRM);
489: END;
490: -------------------------------------------------------------------------------------------
491:
492: function Q_Job (
511: Return sql_stmt;
512: -- return NULL;
513: EXCEPTION
514: WHEN OTHERS THEN
515: htp.p('Exception in Lov package Q_Job');
516: htp.p(SQLERRM);
517: END;
518: -------------------------------------------------------------------------------------------
519: --
512: -- return NULL;
513: EXCEPTION
514: WHEN OTHERS THEN
515: htp.p('Exception in Lov package Q_Job');
516: htp.p(SQLERRM);
517: END;
518: -------------------------------------------------------------------------------------------
519: --
520: -- Bug 5003509. R12 Performance fix. Obsoleted the function.
547:
548: -- return NULL;
549: EXCEPTION
550: WHEN OTHERS THEN
551: htp.p('Exception in Lov package Q_Item');
552: htp.p(SQLERRM);
553: END;
554: -------------------------------------------------------------------------------------------
555:
548: -- return NULL;
549: EXCEPTION
550: WHEN OTHERS THEN
551: htp.p('Exception in Lov package Q_Item');
552: htp.p(SQLERRM);
553: END;
554: -------------------------------------------------------------------------------------------
555:
556: --
577: ||'&' ||'cnumb='||cnumb
578: ||'&' || 'find_str=' || find_str;
579:
580:
581: htp.p('');
582: htp.p('');
583: htp.p('');
585: htp.p('');
578: ||'&' || 'find_str=' || find_str;
579:
580:
581: htp.p('');
582: htp.p('');
583: htp.p('');
585: htp.p('');
586: htp.p('');
580:
581: htp.p('');
582: htp.p('');
583: htp.p('');
585: htp.p('');
586: htp.p('');
587: htp.p('');
588: htp.p('');
581: htp.p('');
582: htp.p('');
583: htp.p('');
585: htp.p('');
586: htp.p('');
587: htp.p('');
588: htp.p('');
589: htp.p('');
582: htp.p('');
583: htp.p('');
585: htp.p('');
586: htp.p('');
587: htp.p('');
588: htp.p('');
589: htp.p('');
590: htp.p('');
583: htp.p('');
585: htp.p('');
586: htp.p('');
587: htp.p('');
588: htp.p('');
589: htp.p('');
590: htp.p('');
591:
584: htp.p('');
585: htp.p('');
586: htp.p('');
587: htp.p('');
588: htp.p('');
589: htp.p('');
590: htp.p('');
591:
592:
585: htp.p('');
586: htp.p('');
587: htp.p('');
588: htp.p('');
589: htp.p('');
590: htp.p('');
591:
592:
593: end if; -- end icx session
586: htp.p('');
587: htp.p('');
588: htp.p('');
589: htp.p('');
590: htp.p('');
591:
592:
593: end if; -- end icx session
594:
594:
595: EXCEPTION
596:
597: WHEN OTHERS THEN
598: htp.p('Exception in procedure gen_list');
599: htp.p(SQLERRM);
600:
601: END gen_list;
602: --------------------------------------------------------------------------------------
595: EXCEPTION
596:
597: WHEN OTHERS THEN
598: htp.p('Exception in procedure gen_list');
599: htp.p(SQLERRM);
600:
601: END gen_list;
602: --------------------------------------------------------------------------------------
603:
616: if (icx_sec.validatesession) then
617: fnd_message.clear;
618: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
619:
620: htp.p('');
621: htp.p('');
622: htp.p('');
617: fnd_message.clear;
618: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
619:
620: htp.p('');
621: htp.p('');
622: htp.p('');
622: htp.p('');
622: htp.p('');
791: {
792: document.write("queryText function");
793: }');
794:
795: htp.p('');
796: htp.p('');
797: htp.p('');
798: htp.p('