APPS.INVICGDS dependencies on INVICGDS

Line 1: PACKAGE BODY INVICGDS AS

1: PACKAGE BODY INVICGDS AS
2: /* $Header: INVICGDB.pls 120.2.12020000.2 2012/07/11 08:22:55 yifwang ship $ */
3:
4: PROCEDURE inv_update_item_desc(
5: inv_item_id IN NUMBER DEFAULT NULL,

Line 78: INVICGDS.inv_get_icg_desc(gir.inventory_item_id,

74:
75: counter := 1;
76: FOR gir in get_item_rows(inv_item_id, org_id) LOOP
77:
78: INVICGDS.inv_get_icg_desc(gir.inventory_item_id,
79: first_elem_break,
80: use_name_as_first_elem,
81: delim_val,
82: show_all_delim,

Line 227: INVICGDS.inv_get_icg_desc(inv_item_id,

223:
224: BEGIN
225: errtxt := NULL;
226:
227: INVICGDS.inv_get_icg_desc(inv_item_id,
228: first_elem_break,
229: use_name_as_first_elem,
230: delimiter,
231: show_all_delim,

Line 252: dummy_err := 'INVICGDS(2):'||SQLCODE||':'||substrb(SQLERRM, 1,30)||errtxt ;

248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: IF (show_error_flag = 'Y') THEN
252: dummy_err := 'INVICGDS(2):'||SQLCODE||':'||substrb(SQLERRM, 1,30)||errtxt ;
253: desc_err := substr( dummy_err, 1, 240);
254: return(desc_err);
255: ELSE
256: return(NULL);

Line 302: dummyerr:= error_text|| ' INVICGDS(3-1): '||SQLCODE||':'

298: description_for_item := NULL;
299: error_text := NULL;
300: raise NO_DATA_FOUND; /* to be handled by enclosing block*/
301: WHEN OTHERS THEN
302: dummyerr:= error_text|| ' INVICGDS(3-1): '||SQLCODE||':'
303: ||substrb(SQLERRM,1,30);
304: error_text := substr(dummyerr, 1, 240);
305: END;
306:

Line 310: INVICGDS.inv_concat_desc_values(

306:
307: c_desc_el_values := NULL;
308: icg_desc_or_name := NULL;
309:
310: INVICGDS.inv_concat_desc_values(
311: inv_item_id,
312: icg_id_val,
313: delimiter,
314: show_all_delim,

Line 328: error_text:= error_text||' INVICGDS(3-2): use_name_as_first_elem should be Y/N';

324: SELECT MICG.description into icg_desc_or_name
325: FROM mtl_item_catalog_groups MICG
326: WHERE MICG.item_catalog_group_id = icg_id_val;
327: ELSE
328: error_text:= error_text||' INVICGDS(3-2): use_name_as_first_elem should be Y/N';
329: /*Error in parameter*/
330: END IF;
331:
332: IF (delimiter is NULL) THEN

Line 395: dummyerr:= error_text|| ' INVICGDS(3-3): '||SQLCODE||':'

391: to work okay
392: */
393:
394: WHEN OTHERS THEN
395: dummyerr:= error_text|| ' INVICGDS(3-3): '||SQLCODE||':'
396: ||substrb(SQLERRM,1,30);
397: error_text := substr(dummyerr, 1, 240);
398:
399: END inv_get_icg_desc;

Line 489: dummyerr := err_text||'INVICGDS(4):'||SQLCODE||':'||substrb(SQLERRM, 1,30);

485: concat_desc := c_desc;
486:
487: EXCEPTION
488: WHEN OTHERS THEN
489: dummyerr := err_text||'INVICGDS(4):'||SQLCODE||':'||substrb(SQLERRM, 1,30);
490: err_text := substr(dummyerr, 1, 240);
491:
492: END inv_concat_desc_values;
493:

Line 495: END INVICGDS;

491:
492: END inv_concat_desc_values;
493:
494:
495: END INVICGDS;