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.ICX_ITEM_DIAG_PVT dependencies on ICX_ITEM_DIAG_PVT

Line 1: PACKAGE body ICX_ITEM_DIAG_PVT AS

1: PACKAGE body ICX_ITEM_DIAG_PVT AS
2: /* $Header: ICX_ITEM_DIAG_PVT.plb 120.7.12020000.2 2013/02/11 13:33:30 vegajula noship $*/
3: procedure create_missing_data;
4:
5: PROCEDURE logUnexpectedException

Line 2: /* $Header: ICX_ITEM_DIAG_PVT.plb 120.7.12020000.2 2013/02/11 13:33:30 vegajula noship $*/

1: PACKAGE body ICX_ITEM_DIAG_PVT AS
2: /* $Header: ICX_ITEM_DIAG_PVT.plb 120.7.12020000.2 2013/02/11 13:33:30 vegajula noship $*/
3: procedure create_missing_data;
4:
5: PROCEDURE logUnexpectedException
6: ( p_pkg_name IN VARCHAR2 ,

Line 126: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start check_file');

122: l_br_iv varchar2(100); -- rep 69 of 120.69.12010000.2 of instance version
123: l_br_sv varchar2(100); -- rep 69 of 120.69.12010000.2 of should have version
124: l_api_name varchar2(30):= 'check_file';
125: BEGIN
126: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start check_file');
127: forall i IN 1 .. g_file_count
128: UPDATE po_session_gt
129: SET num3 = update_num( g_instance_versions_tbl(i) ) ,
130: num2 = update_num( g_file_versions_tbl(i) )

Line 131: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key

127: forall i IN 1 .. g_file_count
128: UPDATE po_session_gt
129: SET num3 = update_num( g_instance_versions_tbl(i) ) ,
130: num2 = update_num( g_file_versions_tbl(i) )
131: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key
132: AND char1 = g_file_tbl(i);
133:
134: for i IN 1 .. g_file_count loop
135: -- check if instance file is less than should have version then update apply patch as Y

Line 138: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key

134: for i IN 1 .. g_file_count loop
135: -- check if instance file is less than should have version then update apply patch as Y
136: select char2, char3, num2, num3 into l_shld_ver, l_inst_ver , l_num2,l_num3
137: FROM po_session_gt
138: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key
139: AND char1 = g_file_tbl(i);
140:
141: if ( l_num2 <> l_num3) then
142: l_apply_patch:= 'TRUE';

Line 163: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'char4 ver 1 ' ||l_shld_ver || ' ver2 ' || l_inst_ver);

159: end if;
160: else
161: l_br_sv:= to_number(split(l_shld_ver,2,'.') );
162: l_br_iv:= to_number(split(l_inst_ver,2,'.') );
163: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'char4 ver 1 ' ||l_shld_ver || ' ver2 ' || l_inst_ver);
164: if l_br_sv > l_br_iv then
165: l_apply_patch:= 'TRUE';
166: else
167: l_apply_patch:= 'FALSE';

Line 170: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'char4 check_file' ||g_file_tbl(i) || l_apply_patch);

166: else
167: l_apply_patch:= 'FALSE';
168: end if;
169: end if;
170: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'char4 check_file' ||g_file_tbl(i) || l_apply_patch);
171: UPDATE po_session_gt set char4 = l_apply_patch
172: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key
173: AND char1 = g_file_tbl(i);
174:

Line 172: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key

168: end if;
169: end if;
170: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'char4 check_file' ||g_file_tbl(i) || l_apply_patch);
171: UPDATE po_session_gt set char4 = l_apply_patch
172: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key
173: AND char1 = g_file_tbl(i);
174:
175: end loop;
176: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'end check_file');

Line 176: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'end check_file');

172: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key
173: AND char1 = g_file_tbl(i);
174:
175: end loop;
176: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'end check_file');
177: RETURN 'Y';
178: exception when others then
179: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'check_file '||sqlerrm||' code='||sqlcode);
180: END check_file;

Line 179: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'check_file '||sqlerrm||' code='||sqlcode);

175: end loop;
176: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'end check_file');
177: RETURN 'Y';
178: exception when others then
179: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'check_file '||sqlerrm||' code='||sqlcode);
180: END check_file;
181:
182: FUNCTION init_file_versions
183: RETURN VARCHAR2

Line 208: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start init_file_versions');

204: )
205: WHERE rownum = 1
206: ORDER BY filename;
207: BEGIN
208: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start init_file_versions');
209: /*g_file_tbl := DBMS_SQL.VARCHAR2_TABLE(null);
210: g_file_versions_tbl := DBMS_SQL.VARCHAR2_TABLE(null);
211: g_instance_versions_tbl := DBMS_SQL.VARCHAR2_TABLE (null);
212: */

Line 245: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'g_file_tbl.count '|| g_file_tbl.count );

241: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'PO_ATTRIBUTE_VALUES_PVT.plb'; g_file_versions_tbl(l_ctr) := '120.30.12010000.7';
242: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'PO_ATTRIBUTE_VALUES_PVT.pls'; g_file_versions_tbl(l_ctr) := '120.12.12010000.3';
243:
244:
245: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'g_file_tbl.count '|| g_file_tbl.count );
246: FOR idx IN 1 .. g_file_tbl.count
247: LOOP
248: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'global variables '|| idx);
249: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, ' file :' || g_file_tbl(idx) || ' version :' ||g_file_versions_tbl(idx));

Line 248: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'global variables '|| idx);

244:
245: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'g_file_tbl.count '|| g_file_tbl.count );
246: FOR idx IN 1 .. g_file_tbl.count
247: LOOP
248: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'global variables '|| idx);
249: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, ' file :' || g_file_tbl(idx) || ' version :' ||g_file_versions_tbl(idx));
250: END LOOP;
251: -- populate instance versions
252: FOR i IN 1 .. g_file_count

Line 249: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, ' file :' || g_file_tbl(idx) || ' version :' ||g_file_versions_tbl(idx));

245: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'g_file_tbl.count '|| g_file_tbl.count );
246: FOR idx IN 1 .. g_file_tbl.count
247: LOOP
248: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'global variables '|| idx);
249: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, ' file :' || g_file_tbl(idx) || ' version :' ||g_file_versions_tbl(idx));
250: END LOOP;
251: -- populate instance versions
252: FOR i IN 1 .. g_file_count
253: LOOP

Line 257: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'in loop init_file_versions i='|| i|| ' '||l_file_name||' g_instance_versions_tbl(i)='||l_file_version);

253: LOOP
254: OPEN instance_ver(i);
255: FETCH instance_ver INTO l_file_name,l_file_version;
256:
257: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'in loop init_file_versions i='|| i|| ' '||l_file_name||' g_instance_versions_tbl(i)='||l_file_version);
258: g_instance_versions_tbl(i):=l_file_version;
259: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,g_instance_versions_tbl(i));
260: CLOSE instance_ver;
261: END LOOP;

Line 259: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,g_instance_versions_tbl(i));

255: FETCH instance_ver INTO l_file_name,l_file_version;
256:
257: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'in loop init_file_versions i='|| i|| ' '||l_file_name||' g_instance_versions_tbl(i)='||l_file_version);
258: g_instance_versions_tbl(i):=l_file_version;
259: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,g_instance_versions_tbl(i));
260: CLOSE instance_ver;
261: END LOOP;
262:
263: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting done');

Line 263: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting done');

259: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,g_instance_versions_tbl(i));
260: CLOSE instance_ver;
261: END LOOP;
262:
263: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting done');
264: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start for' ||g_file_count );
265: FOR i IN 1 .. g_file_count
266: LOOP
267: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start of insert '|| i || ' file :' || g_file_tbl(i)||g_file_versions_tbl(i)|| g_instance_versions_tbl(i));

Line 264: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start for' ||g_file_count );

260: CLOSE instance_ver;
261: END LOOP;
262:
263: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting done');
264: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start for' ||g_file_count );
265: FOR i IN 1 .. g_file_count
266: LOOP
267: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start of insert '|| i || ' file :' || g_file_tbl(i)||g_file_versions_tbl(i)|| g_instance_versions_tbl(i));
268: INSERT

Line 267: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start of insert '|| i || ' file :' || g_file_tbl(i)||g_file_versions_tbl(i)|| g_instance_versions_tbl(i));

263: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting done');
264: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start for' ||g_file_count );
265: FOR i IN 1 .. g_file_count
266: LOOP
267: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start of insert '|| i || ' file :' || g_file_tbl(i)||g_file_versions_tbl(i)|| g_instance_versions_tbl(i));
268: INSERT
269: INTO po_session_gt
270: (
271: index_char1 --'ITEM_DIAG_FILE_VERSIONS'

Line 281: ICX_ITEM_DIAG_PVT.g_file_key ,

277: char3 -- instance version
278: )
279: VALUES
280: (
281: ICX_ITEM_DIAG_PVT.g_file_key ,
282: g_file_tbl(i) ,
283: g_file_versions_tbl(i) ,
284: g_instance_versions_tbl(i)
285: );

Line 287: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, 'for alll completed calll check file' );

283: g_file_versions_tbl(i) ,
284: g_instance_versions_tbl(i)
285: );
286:
287: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, 'for alll completed calll check file' );
288:
289: END LOOP;
290: -- check old files.
291: l_return_status:= check_file;

Line 293: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, 'end check file' );

289: END LOOP;
290: -- check old files.
291: l_return_status:= check_file;
292:
293: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, 'end check file' );
294: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, 'end init_file_versions' );
295:
296: RETURN l_return_status;
297:

Line 294: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, 'end init_file_versions' );

290: -- check old files.
291: l_return_status:= check_file;
292:
293: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, 'end check file' );
294: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name, 'end init_file_versions' );
295:
296: RETURN l_return_status;
297:
298: EXCEPTION

Line 332: WHERE index_char1 = ICX_ITEM_DIAG_PVT.g_file_key;

328: num1,
329: num2,
330: num3
331: FROM po_session_gt
332: WHERE index_char1 = ICX_ITEM_DIAG_PVT.g_file_key;
333:
334: l_limit NUMBER:=100;
335: BEGIN
336: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start file_versions');

Line 336: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start file_versions');

332: WHERE index_char1 = ICX_ITEM_DIAG_PVT.g_file_key;
333:
334: l_limit NUMBER:=100;
335: BEGIN
336: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start file_versions');
337: l_ret := init_file_versions;
338: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'printing session gt ');
339: OPEN c ;
340: LOOP

Line 338: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'printing session gt ');

334: l_limit NUMBER:=100;
335: BEGIN
336: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start file_versions');
337: l_ret := init_file_versions;
338: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'printing session gt ');
339: OPEN c ;
340: LOOP
341: FETCH c BULK COLLECT
342: INTO l_char1_tbl,

Line 352: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'finally i='|| l_char1_tbl(i)|| ' l_char2_tbl='||l_char2_tbl(i)||' l_char3_tbl='||l_char3_tbl(i)||' num1_tbl='||num1_tbl(i)||' num2_tbl='||num2_tbl(i)||' num3_tbl='||num3_tbl(i));

348: EXIT
349: WHEN l_char1_tbl.COUNT = 0;
350: FOR i IN 1 .. l_char1_tbl.COUNT
351: LOOP
352: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'finally i='|| l_char1_tbl(i)|| ' l_char2_tbl='||l_char2_tbl(i)||' l_char3_tbl='||l_char3_tbl(i)||' num1_tbl='||num1_tbl(i)||' num2_tbl='||num2_tbl(i)||' num3_tbl='||num3_tbl(i));
353: END LOOP ;
354: END LOOP ;
355: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'end file_versions');
356: EXCEPTION

Line 355: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'end file_versions');

351: LOOP
352: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'finally i='|| l_char1_tbl(i)|| ' l_char2_tbl='||l_char2_tbl(i)||' l_char3_tbl='||l_char3_tbl(i)||' num1_tbl='||num1_tbl(i)||' num2_tbl='||num2_tbl(i)||' num3_tbl='||num3_tbl(i));
353: END LOOP ;
354: END LOOP ;
355: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'end file_versions');
356: EXCEPTION
357: WHEN OTHERS THEN
358: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'exception file_versions'||sqlerrm||SQLCODE );
359: END file_versions;

Line 358: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'exception file_versions'||sqlerrm||SQLCODE );

354: END LOOP ;
355: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'end file_versions');
356: EXCEPTION
357: WHEN OTHERS THEN
358: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'exception file_versions'||sqlerrm||SQLCODE );
359: END file_versions;
360:
361: procedure get_setup_values ( p_table_name in VARCHAR2 ,
362: p_col_val out NOCOPY DBMS_SQL.VARCHAR2_TABLE,

Line 371: where fsp.org_id =ICX_ITEM_DIAG_PVT.g_org_id

367: select ORG_ID, org.SHORT_CODE OU_CODE, org.NAME OU_NAME ,
368: fsp.INVENTORY_ORGANIZATION_ID inventory_ORGANIZATION, org1.ORGANIZATION_CODE INV_ORG_CODE,org1.ORGANIZATION_NAME INV_ORG_NAME
369: ,mparams.MASTER_ORGANIZATION_ID
370: from financials_system_params_all fsp, hr_operating_units org ,org_organization_definitions org1 ,mtl_parameters mparams
371: where fsp.org_id =ICX_ITEM_DIAG_PVT.g_org_id
372: and fsp.org_id =org.ORGANIZATION_ID
373: and fsp.INVENTORY_ORGANIZATION_ID=org1.ORGANIZATION_ID
374: AND mparams.organization_id=fsp.INVENTORY_ORGANIZATION_ID;
375:

Line 411: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'g_organization_id='||g_organization_id||' g_master_organization_id'||g_master_organization_id||' g_category_set_id'||g_category_set_id);

407:
408: g_organization_id := p_row_val(1)(4);
409: g_master_organization_id := p_row_val(1)(7);
410: g_category_set_id := p_row_val(1)(9);
411: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'g_organization_id='||g_organization_id||' g_master_organization_id'||g_master_organization_id||' g_category_set_id'||g_category_set_id);
412: exception when others then
413: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'get_setup_values '||sqlerrm||' code='||sqlcode);
414:
415: end get_setup_values ;

Line 413: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'get_setup_values '||sqlerrm||' code='||sqlcode);

409: g_master_organization_id := p_row_val(1)(7);
410: g_category_set_id := p_row_val(1)(9);
411: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'g_organization_id='||g_organization_id||' g_master_organization_id'||g_master_organization_id||' g_category_set_id'||g_category_set_id);
412: exception when others then
413: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'get_setup_values '||sqlerrm||' code='||sqlcode);
414:
415: end get_setup_values ;
416:
417: procedure get_IDs_values ( p_table_name in VARCHAR2

Line 539: WHERE index_char1 = ICX_ITEM_DIAG_PVT.g_error_key ;

535:
536: cursor po_gt is
537: select index_char1,num1,num2,num3,num4,char1,char2,char3,char4
538: from po_session_gt
539: WHERE index_char1 = ICX_ITEM_DIAG_PVT.g_error_key ;
540:
541: l_api_name VARCHAR2 (20):='get_IDs_values';
542:
543: begin

Line 544: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start');

540:
541: l_api_name VARCHAR2 (20):='get_IDs_values';
542:
543: begin
544: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start');
545: if p_table_name = 'MTL_SYSTEM_ITEMS_B' then
546: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'1');
547: p_col_val(1):= 'INVENTORY_ITEM_ID';
548: p_col_val(2):= 'ORGANIZATION_ID';

Line 546: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'1');

542:
543: begin
544: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start');
545: if p_table_name = 'MTL_SYSTEM_ITEMS_B' then
546: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'1');
547: p_col_val(1):= 'INVENTORY_ITEM_ID';
548: p_col_val(2):= 'ORGANIZATION_ID';
549: p_col_val(3):= 'SEGMENT1';
550: p_col_val(4):= 'IS INTERNAL?';

Line 564: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12 g_source_ids.count'||g_source_ids.count);

560: p_col_val(14):= 'Rule 2';
561:
562: p_row_num:=1;
563:
564: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12 g_source_ids.count'||g_source_ids.count);
565: for j in 1.. g_source_ids.count loop
566: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
567: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
568:

Line 566: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

562: p_row_num:=1;
563:
564: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12 g_source_ids.count'||g_source_ids.count);
565: for j in 1.. g_source_ids.count loop
566: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
567: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
568:
569: open mi(j);
570: loop

Line 567: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

563:
564: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12 g_source_ids.count'||g_source_ids.count);
565: for j in 1.. g_source_ids.count loop
566: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
567: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
568:
569: open mi(j);
570: loop
571: fetch mi into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 577: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(5),

573: p_row_val(p_row_num)(7),p_row_val(p_row_num)(8),p_row_val(p_row_num)(9),
574: p_row_val(p_row_num)(10),p_row_val(p_row_num)(11),p_row_val(p_row_num)(12),
575: p_row_val(p_row_num)(13),p_row_val(p_row_num)(14);
576: if mi%ROWCOUNT <1 then
577: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(5),
578: num1 => g_source_ids(j),
579: num2 => g_organization_id,
580: num3 => -2,
581: num4 => g_org_id,

Line 593: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

589: close mi;
590: end loop;
591: p_col_num :=14;
592: p_row_num:=p_row_num-1;
593: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
594:
595: elsif p_table_name = 'MTL_SYSTEM_ITEMS_TL' then
596: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'2');
597: p_col_val(1):= 'INVENTORY_ITEM_ID';

Line 596: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'2');

592: p_row_num:=p_row_num-1;
593: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
594:
595: elsif p_table_name = 'MTL_SYSTEM_ITEMS_TL' then
596: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'2');
597: p_col_val(1):= 'INVENTORY_ITEM_ID';
598: p_col_val(2):= 'ORGANIZATION_ID';
599: p_col_val(3):= 'LANGUAGE';
600: p_col_val(4):= 'SOURCE_LANG';

Line 605: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'22 g_source_ids.count'||g_source_ids.count);

601: p_col_val(5):= 'DESCRIPTION';
602: p_col_val(6):= 'LONG_DESCRIPTION';
603: p_col_val(7):= 'Rule 1';
604: p_row_num:=1;
605: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'22 g_source_ids.count'||g_source_ids.count);
606: for j in 1.. g_source_ids.count loop
607: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'22 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
608: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
609: open mtl(j);

Line 607: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'22 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

603: p_col_val(7):= 'Rule 1';
604: p_row_num:=1;
605: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'22 g_source_ids.count'||g_source_ids.count);
606: for j in 1.. g_source_ids.count loop
607: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'22 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
608: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
609: open mtl(j);
610: loop
611: fetch mtl into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 608: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

604: p_row_num:=1;
605: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'22 g_source_ids.count'||g_source_ids.count);
606: for j in 1.. g_source_ids.count loop
607: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'22 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
608: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
609: open mtl(j);
610: loop
611: fetch mtl into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),
612: p_row_val(p_row_num)(4),p_row_val(p_row_num)(5),p_row_val(p_row_num)(6),

Line 621: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

617: close mtl;
618: end loop;
619: p_col_num :=7;
620: p_row_num:=p_row_num-1;
621: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
622:
623: elsif p_table_name = 'MTL_ITEM_CATEGORIES' then
624: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'3');
625: p_col_val(1):= 'INVENTORY_ITEM_ID';

Line 624: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'3');

620: p_row_num:=p_row_num-1;
621: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
622:
623: elsif p_table_name = 'MTL_ITEM_CATEGORIES' then
624: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'3');
625: p_col_val(1):= 'INVENTORY_ITEM_ID';
626: p_col_val(2):= 'ORGANIZATION_ID';
627: p_col_val(3):= 'CATEGORY_SET_ID';
628: p_col_val(4):= 'PO_CATEGORY_ID';

Line 632: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'32 g_source_ids.count'||g_source_ids.count);

628: p_col_val(4):= 'PO_CATEGORY_ID';
629: p_col_val(5):= 'CATEGORY_KEY';
630: p_col_val(6):= 'Rule 1';
631: p_row_num:=1;
632: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'32 g_source_ids.count'||g_source_ids.count);
633: for j in 1.. g_source_ids.count loop
634: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'32 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
635: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
636: l_cat_num:=0;

Line 634: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'32 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

630: p_col_val(6):= 'Rule 1';
631: p_row_num:=1;
632: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'32 g_source_ids.count'||g_source_ids.count);
633: for j in 1.. g_source_ids.count loop
634: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'32 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
635: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
636: l_cat_num:=0;
637: l_old_organization_id :='-2';
638: open mic(j);

Line 635: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

631: p_row_num:=1;
632: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'32 g_source_ids.count'||g_source_ids.count);
633: for j in 1.. g_source_ids.count loop
634: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'32 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
635: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
636: l_cat_num:=0;
637: l_old_organization_id :='-2';
638: open mic(j);
639: loop

Line 647: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'32 categoryid='||g_category_key(j)||' l_old_organization_id='||l_old_organization_id|| ' compare with '||p_row_val(p_row_num)(2) || ' l_cat_num='||l_cat_num);

643: if(l_old_organization_id = '-2') then
644: l_old_organization_id:=p_row_val(p_row_num)(2);
645: end if;
646: g_category_key(j) := p_row_val(p_row_num)(5);
647: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'32 categoryid='||g_category_key(j)||' l_old_organization_id='||l_old_organization_id|| ' compare with '||p_row_val(p_row_num)(2) || ' l_cat_num='||l_cat_num);
648:
649:
650: if(l_old_organization_id=p_row_val(p_row_num)(2)) then
651: l_cat_num:=l_cat_num+1;

Line 655: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(1),

651: l_cat_num:=l_cat_num+1;
652: else
653: if l_cat_num >1 then
654: p_row_val(p_row_num-1)(6):='NOT VALID';
655: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(1),
656: num1 => g_source_ids(j),
657: num2 => p_row_val(p_row_num-1)(2),
658: num3 => -2,
659: num4 => g_org_id,

Line 665: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(2),

661: char3 =>'-2',
662: char4 => p_row_val(p_row_num-1)(4) );
663: elsif l_cat_num =1 AND p_row_val(p_row_num-1)(5) ='-2' then
664: p_row_val(p_row_num-1)(6):='May not be searchable';
665: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(2),
666: num1 => g_source_ids(j),
667: num2 => p_row_val(p_row_num-1)(2),
668: num3 => -2,
669: num4 => g_org_id,

Line 678: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'l_cat_num='||l_cat_num );

674: end if;
675:
676: /*-- l_cat_num:=l_cat_num+1;
677: if(l_old_organization_id<>p_row_val(p_row_num)(2)) then
678: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'l_cat_num='||l_cat_num );
679: -- too many po category assigned to master item.
680: if l_cat_num <>1 then
681: p_row_val(p_row_num-1)(6):='May not be searchable';
682: g_category_key(j) := '-2';

Line 684: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(1),

680: if l_cat_num <>1 then
681: p_row_val(p_row_num-1)(6):='May not be searchable';
682: g_category_key(j) := '-2';
683: if l_cat_num >1 then
684: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(1),
685: num1 => g_source_ids(j),
686: num2 => p_row_val(p_row_num)(2),
687: num3 => -2,
688: num4 => g_org_id,

Line 693: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(2),

689: char2 =>'-2',
690: char3 =>'-2',
691: char4 => p_row_val(1)(4) );
692: else
693: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(2),
694: num1 => g_source_ids(j),
695: num2 => p_row_val(p_row_num)(2),
696: num3 => -2,
697: num4 => g_org_id,

Line 705: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(3),

701: end if;
702: else
703: g_category_key(j) := p_row_val(1)(5);
704: if ( g_category_key(j) ='-2' ) then
705: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(3),
706: num1 => g_source_ids(j),
707: num2 => p_row_val(p_row_num)(2),
708: num3 => -2,
709: num4 => g_org_id,

Line 714: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'po category id='||p_row_val(1)(4)||'g_category_key='||g_category_key(j) );

710: char2 =>'-2',
711: char3 =>'-2',
712: char4 => p_row_val(1)(4));
713: end if;
714: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'po category id='||p_row_val(1)(4)||'g_category_key='||g_category_key(j) );
715: end if;
716:
717: l_old_organization_id:=p_row_val(p_row_num)(2);
718: l_cat_num:=1;

Line 734: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

730: close mic;
731: end loop;
732: p_col_num :=6;
733: p_row_num:=p_row_num-1;
734: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
735:
736: elsif p_table_name = 'MTL_UNITS_OF_MEASURE' then
737: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'4');
738: p_col_val(1):= 'INVENTORY_ITEM_ID';

Line 737: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'4');

733: p_row_num:=p_row_num-1;
734: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
735:
736: elsif p_table_name = 'MTL_UNITS_OF_MEASURE' then
737: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'4');
738: p_col_val(1):= 'INVENTORY_ITEM_ID';
739: p_col_val(2):= 'ORGANIZATION_ID';
740: p_col_val(3):= 'Unit of Measure';
741: p_col_val(4):= 'UOM Code';

Line 743: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'42 g_source_ids.count'||g_source_ids.count);

739: p_col_val(2):= 'ORGANIZATION_ID';
740: p_col_val(3):= 'Unit of Measure';
741: p_col_val(4):= 'UOM Code';
742: p_row_num:=1;
743: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'42 g_source_ids.count'||g_source_ids.count);
744: for j in 1.. g_source_ids.count loop
745: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'42 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
746: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
747: open muom(j);

Line 745: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'42 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

741: p_col_val(4):= 'UOM Code';
742: p_row_num:=1;
743: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'42 g_source_ids.count'||g_source_ids.count);
744: for j in 1.. g_source_ids.count loop
745: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'42 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
746: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
747: open muom(j);
748: loop
749: fetch muom into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 746: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

742: p_row_num:=1;
743: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'42 g_source_ids.count'||g_source_ids.count);
744: for j in 1.. g_source_ids.count loop
745: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'42 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
746: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
747: open muom(j);
748: loop
749: fetch muom into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),
750: p_row_val(p_row_num)(4);

Line 758: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

754: close muom;
755: end loop;
756: p_col_num :=4;
757: p_row_num:=p_row_num-1;
758: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
759:
760: elsif p_table_name = 'ICX_CAT_CATEGORIES_TL' then
761: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'5');
762: p_col_val(1):= 'INVENTORY_ITEM_ID';

Line 761: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'5');

757: p_row_num:=p_row_num-1;
758: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
759:
760: elsif p_table_name = 'ICX_CAT_CATEGORIES_TL' then
761: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'5');
762: p_col_val(1):= 'INVENTORY_ITEM_ID';
763: p_col_val(2):= 'ORGANIZATION_ID';
764: p_col_val(3):= 'Language';
765: p_col_val(4):= 'IP Category ID';

Line 768: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'52 g_source_ids.count'||g_source_ids.count);

764: p_col_val(3):= 'Language';
765: p_col_val(4):= 'IP Category ID';
766: p_col_val(5):= 'IP Category Name';
767: p_row_num:=1;
768: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'52 g_source_ids.count'||g_source_ids.count);
769: for j in 1.. g_source_ids.count loop
770: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'52 g_category_key(j) ='||g_category_key(j) );
771: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
772: if g_category_key(j) <> '-2' then

Line 770: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'52 g_category_key(j) ='||g_category_key(j) );

766: p_col_val(5):= 'IP Category Name';
767: p_row_num:=1;
768: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'52 g_source_ids.count'||g_source_ids.count);
769: for j in 1.. g_source_ids.count loop
770: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'52 g_category_key(j) ='||g_category_key(j) );
771: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
772: if g_category_key(j) <> '-2' then
773: open ip_cat(j);
774: loop

Line 771: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

767: p_row_num:=1;
768: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'52 g_source_ids.count'||g_source_ids.count);
769: for j in 1.. g_source_ids.count loop
770: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'52 g_category_key(j) ='||g_category_key(j) );
771: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
772: if g_category_key(j) <> '-2' then
773: open ip_cat(j);
774: loop
775: fetch ip_cat into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 786: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

782: end if;
783: end loop;
784: p_col_num :=5;
785: p_row_num:=p_row_num-1;
786: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
787:
788: elsif p_table_name = 'ICX_CAT_ITEMS_CTX_HDRS_TLP' then
789: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'6');
790: p_col_val(1):='INVENTORY_ITEM_ID';

Line 789: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'6');

785: p_row_num:=p_row_num-1;
786: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
787:
788: elsif p_table_name = 'ICX_CAT_ITEMS_CTX_HDRS_TLP' then
789: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'6');
790: p_col_val(1):='INVENTORY_ITEM_ID';
791: p_col_val(2):='PO_LINE_ID';
792: p_col_val(3):='REQ_TEMPLATE_NAME';
793: p_col_val(4):='REQ_TEMPLATE_LINE_NUM';

Line 810: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'62 g_source_ids.count'||g_source_ids.count);

806: p_col_val(17):='SOURCE_TYPE';
807: p_col_val(18):='WARNING';
808:
809: p_row_num:=1;
810: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'62 g_source_ids.count'||g_source_ids.count);
811: for j in 1.. g_source_ids.count loop
812: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'62 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
813: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
814:

Line 812: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'62 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

808:
809: p_row_num:=1;
810: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'62 g_source_ids.count'||g_source_ids.count);
811: for j in 1.. g_source_ids.count loop
812: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'62 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
813: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
814:
815: open hdrs(j);
816: loop

Line 813: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

809: p_row_num:=1;
810: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'62 g_source_ids.count'||g_source_ids.count);
811: for j in 1.. g_source_ids.count loop
812: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'62 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
813: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
814:
815: open hdrs(j);
816: loop
817: fetch hdrs into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 830: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

826: close hdrs;
827: end loop;
828: p_col_num :=18;
829: p_row_num:=p_row_num-1;
830: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
831:
832: elsif p_table_name = 'ICX_CAT_ITEMS_CTX_DTLS_TLP' then
833: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'7');
834: p_col_val(1):='INVENTORY_ITEM_ID';

Line 833: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'7');

829: p_row_num:=p_row_num-1;
830: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
831:
832: elsif p_table_name = 'ICX_CAT_ITEMS_CTX_DTLS_TLP' then
833: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'7');
834: p_col_val(1):='INVENTORY_ITEM_ID';
835: p_col_val(2):='PO_LINE_ID';
836: p_col_val(3):='REQ_TEMPLATE_NAME';
837: p_col_val(4):='REQ_TEMPLATE_LINE_NUM';

Line 844: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'72 g_source_ids.count'||g_source_ids.count);

840: p_col_val(7):='SEQUENCE';
841: p_col_val(8):='CTX_DESC';
842:
843: p_row_num:=1;
844: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'72 g_source_ids.count'||g_source_ids.count);
845: for j in 1.. g_source_ids.count loop
846: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'72 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
847: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
848:

Line 846: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'72 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

842:
843: p_row_num:=1;
844: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'72 g_source_ids.count'||g_source_ids.count);
845: for j in 1.. g_source_ids.count loop
846: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'72 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
847: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
848:
849: open dtls(j);
850: loop

Line 847: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

843: p_row_num:=1;
844: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'72 g_source_ids.count'||g_source_ids.count);
845: for j in 1.. g_source_ids.count loop
846: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'72 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
847: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
848:
849: open dtls(j);
850: loop
851: fetch dtls into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 861: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

857: close dtls;
858: end loop;
859: p_col_num :=8;
860: p_row_num:=p_row_num-1;
861: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
862:
863: elsif p_table_name = 'DR$SQE' then
864: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'8');
865: p_col_val(1):='ROWNUM';

Line 864: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'8');

860: p_row_num:=p_row_num-1;
861: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
862:
863: elsif p_table_name = 'DR$SQE' then
864: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'8');
865: p_col_val(1):='ROWNUM';
866: p_col_val(2):='SQE_OWNER#';
867: p_col_val(3):='SQE_NAME';
868: p_col_val(4):='SQE_QUERY';

Line 872: --ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'82 g_source_ids.count'||g_source_ids.count);

868: p_col_val(4):='SQE_QUERY';
869:
870:
871: p_row_num:=1;
872: --ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'82 g_source_ids.count'||g_source_ids.count);
873: for j in 1.. g_source_ids.count loop
874: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'82 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
875: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
876:

Line 874: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'82 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

870:
871: p_row_num:=1;
872: --ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'82 g_source_ids.count'||g_source_ids.count);
873: for j in 1.. g_source_ids.count loop
874: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'82 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
875: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
876:
877: open sqe;
878: loop

Line 875: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

871: p_row_num:=1;
872: --ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'82 g_source_ids.count'||g_source_ids.count);
873: for j in 1.. g_source_ids.count loop
874: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'82 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
875: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
876:
877: open sqe;
878: loop
879: fetch sqe into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 888: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

884: close sqe;
885: end loop;
886: p_col_num :=4;
887: p_row_num:=p_row_num-1;
888: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
889:
890: elsif p_table_name = 'PO_ATTRIBUTE_VALUES' then
891: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'9');
892: p_col_val(1):='INVENTORY_ITEM_ID';

Line 891: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'9');

887: p_row_num:=p_row_num-1;
888: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
889:
890: elsif p_table_name = 'PO_ATTRIBUTE_VALUES' then
891: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'9');
892: p_col_val(1):='INVENTORY_ITEM_ID';
893: p_col_val(2):='ORG_ID';
894: p_col_val(3):='PO_LINE_ID';
895: p_col_val(4):='REQ_TEMPLATE_NAME';

Line 910: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'92 g_source_ids.count'||g_source_ids.count);

906: p_col_val(15):='AVAILABILITY';
907:
908:
909: p_row_num:=1;
910: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'92 g_source_ids.count'||g_source_ids.count);
911: for j in 1.. g_source_ids.count loop
912: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'92 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
913: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
914:

Line 912: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'92 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

908:
909: p_row_num:=1;
910: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'92 g_source_ids.count'||g_source_ids.count);
911: for j in 1.. g_source_ids.count loop
912: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'92 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
913: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
914:
915: open po_attr(j);
916: loop

Line 913: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

909: p_row_num:=1;
910: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'92 g_source_ids.count'||g_source_ids.count);
911: for j in 1.. g_source_ids.count loop
912: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'92 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
913: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
914:
915: open po_attr(j);
916: loop
917: fetch po_attr into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 929: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

925: close po_attr;
926: end loop;
927: p_col_num :=15;
928: p_row_num:=p_row_num-1;
929: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
930:
931:
932: elsif p_table_name = 'PO_ATTRIBUTE_VALUES_TLP' then
933: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'10');

Line 933: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'10');

929: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
930:
931:
932: elsif p_table_name = 'PO_ATTRIBUTE_VALUES_TLP' then
933: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'10');
934: p_col_val(1):='INVENTORY_ITEM_ID';
935: p_col_val(2):='ORG_ID';
936: p_col_val(3):='LANGUAGE';
937: p_col_val(4):='PO_LINE_ID';

Line 946: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'102 g_source_ids.count'||g_source_ids.count);

942: p_col_val(9):='MANUFACTURER';
943: p_col_val(10):='LONG_DESCRIPTION';
944:
945: p_row_num:=1;
946: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'102 g_source_ids.count'||g_source_ids.count);
947: for j in 1.. g_source_ids.count loop
948: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'102 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
949: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
950:

Line 948: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'102 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

944:
945: p_row_num:=1;
946: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'102 g_source_ids.count'||g_source_ids.count);
947: for j in 1.. g_source_ids.count loop
948: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'102 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
949: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
950:
951: open po_attr_tlp(j);
952: loop

Line 949: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

945: p_row_num:=1;
946: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'102 g_source_ids.count'||g_source_ids.count);
947: for j in 1.. g_source_ids.count loop
948: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'102 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
949: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
950:
951: open po_attr_tlp(j);
952: loop
953: fetch po_attr_tlp into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 964: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

960: close po_attr_tlp;
961: end loop;
962: p_col_num :=10;
963: p_row_num:=p_row_num-1;
964: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
965:
966: elsif p_table_name = 'ICX_CAT_ATTRIBUTE_VALUES' then
967: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'11');
968: p_col_val(1):='INVENTORY_ITEM_ID';

Line 967: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'11');

963: p_row_num:=p_row_num-1;
964: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
965:
966: elsif p_table_name = 'ICX_CAT_ATTRIBUTE_VALUES' then
967: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'11');
968: p_col_val(1):='INVENTORY_ITEM_ID';
969: p_col_val(2):='ORG_ID';
970: p_col_val(3):='PO_LINE_ID';
971: p_col_val(4):='REQ_TEMPLATE_NAME';

Line 986: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'112 g_source_ids.count'||g_source_ids.count);

982: p_col_val(15):='AVAILABILITY';
983:
984:
985: p_row_num:=1;
986: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'112 g_source_ids.count'||g_source_ids.count);
987: for j in 1.. g_source_ids.count loop
988: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'112 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
989: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
990:

Line 988: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'112 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

984:
985: p_row_num:=1;
986: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'112 g_source_ids.count'||g_source_ids.count);
987: for j in 1.. g_source_ids.count loop
988: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'112 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
989: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
990:
991: open icx_attr(j);
992: loop

Line 989: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

985: p_row_num:=1;
986: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'112 g_source_ids.count'||g_source_ids.count);
987: for j in 1.. g_source_ids.count loop
988: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'112 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
989: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
990:
991: open icx_attr(j);
992: loop
993: fetch icx_attr into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 1005: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

1001: close icx_attr;
1002: end loop;
1003: p_col_num :=15;
1004: p_row_num:=p_row_num-1;
1005: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
1006:
1007:
1008: elsif p_table_name = 'ICX_CAT_ATTRIBUTE_VALUES_TLP' then
1009: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12');

Line 1009: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12');

1005: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
1006:
1007:
1008: elsif p_table_name = 'ICX_CAT_ATTRIBUTE_VALUES_TLP' then
1009: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12');
1010: p_col_val(1):='INVENTORY_ITEM_ID';
1011: p_col_val(2):='ORG_ID';
1012: p_col_val(3):='LANGUAGE';
1013: p_col_val(4):='PO_LINE_ID';

Line 1022: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'122 g_source_ids.count'||g_source_ids.count);

1018: p_col_val(9):='MANUFACTURER';
1019: p_col_val(10):='LONG_DESCRIPTION';
1020:
1021: p_row_num:=1;
1022: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'122 g_source_ids.count'||g_source_ids.count);
1023: for j in 1.. g_source_ids.count loop
1024: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'122 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
1025: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
1026:

Line 1024: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'122 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

1020:
1021: p_row_num:=1;
1022: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'122 g_source_ids.count'||g_source_ids.count);
1023: for j in 1.. g_source_ids.count loop
1024: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'122 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
1025: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
1026:
1027: open icx_attr_tlp(j);
1028: loop

Line 1025: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

1021: p_row_num:=1;
1022: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'122 g_source_ids.count'||g_source_ids.count);
1023: for j in 1.. g_source_ids.count loop
1024: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'122 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
1025: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
1026:
1027: open icx_attr_tlp(j);
1028: loop
1029: fetch icx_attr_tlp into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 1040: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

1036: close icx_attr_tlp;
1037: end loop;
1038: p_col_num :=10;
1039: p_row_num:=p_row_num-1;
1040: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
1041:
1042: elsif p_table_name = 'PO_SESSION_GT' then
1043: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'13');
1044: p_col_val(1):='INDEX_CHAR1';

Line 1043: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'13');

1039: p_row_num:=p_row_num-1;
1040: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
1041:
1042: elsif p_table_name = 'PO_SESSION_GT' then
1043: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'13');
1044: p_col_val(1):='INDEX_CHAR1';
1045: p_col_val(2):='NUM1';
1046: p_col_val(3):='NUM2';
1047: p_col_val(4):='NUM3';

Line 1056: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'132 g_source_ids.count'||g_source_ids.count);

1052: p_col_val(9):='CHAR4';
1053:
1054:
1055: p_row_num:=1;
1056: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'132 g_source_ids.count'||g_source_ids.count);
1057: for j in 1.. g_source_ids.count loop
1058: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'132 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
1059: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
1060:

Line 1058: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'132 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);

1054:
1055: p_row_num:=1;
1056: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'132 g_source_ids.count'||g_source_ids.count);
1057: for j in 1.. g_source_ids.count loop
1058: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'132 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
1059: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
1060:
1061: open po_gt;
1062: loop

Line 1059: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);

1055: p_row_num:=1;
1056: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'132 g_source_ids.count'||g_source_ids.count);
1057: for j in 1.. g_source_ids.count loop
1058: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'132 g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id'||g_organization_id);
1059: -- ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num);
1060:
1061: open po_gt;
1062: loop
1063: fetch po_gt into p_row_val(p_row_num)(1),p_row_val(p_row_num)(2),p_row_val(p_row_num)(3),

Line 1073: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);

1069: close po_gt;
1070: end loop;
1071: p_col_num :=9;
1072: p_row_num:=p_row_num-1;
1073: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
1074:
1075: end if;
1076: exception when others then
1077: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'get_IDs_values '||sqlerrm||' code='||sqlcode);

Line 1077: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'get_IDs_values '||sqlerrm||' code='||sqlcode);

1073: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
1074:
1075: end if;
1076: exception when others then
1077: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'get_IDs_values '||sqlerrm||' code='||sqlcode);
1078:
1079: end get_IDs_values;
1080:
1081:

Line 1209: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'validate g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id='||g_organization_id);

1205: p_col_val(35):='IS VALID?';
1206:
1207: p_row_num:=1;
1208: for j in 1.. g_source_ids.count loop
1209: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'validate g_source_ids(j)='||g_source_ids(j)|| ' g_organization_id='||g_organization_id);
1210:
1211: --if generic mode then at j=1 open validate(null) ; at j=2 exit
1212:
1213: open validate(j);

Line 1260: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(3),

1256: char3 =>l_row_val(p_row_num)(4));
1257:
1258: elsif l_row_val(p_row_num)(31) is null or l_row_val(p_row_num)(31) = '-2' then
1259: l_row_val(p_row_num)(35):=g_error_code(3);
1260: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(3),
1261: num1 => l_row_val(p_row_num)(1),
1262: num2 => l_row_val(p_row_num)(19),
1263: num3 => l_row_val(p_row_num)(2),
1264: num4 => l_row_val(p_row_num)(5),

Line 1277: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(7),

1273: to_number(l_row_val(p_row_num)(9)),
1274: to_number(l_row_val(p_row_num)(5))
1275: ) =0 ) then
1276: l_row_val(p_row_num)(35):=g_error_code(7);
1277: add_error(char1 => ICX_ITEM_DIAG_PVT.g_error_code(7),
1278: num1 => l_row_val(p_row_num)(9), --po_category_id
1279: num2 => l_row_val(p_row_num)(19),
1280: num3 => l_row_val(p_row_num)(2),
1281: num4 => l_row_val(p_row_num)(5),

Line 1297: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || 'p_col_num='||p_col_num);

1293: close validate;
1294: end loop;
1295: p_col_num :=35;
1296: p_row_num:=p_row_num-1;
1297: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || 'p_col_num='||p_col_num);
1298:
1299:
1300: create_missing_data;
1301:

Line 1303: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'validate_values '||sqlerrm||' code='||sqlcode);

1299:
1300: create_missing_data;
1301:
1302: exception when others then
1303: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'validate_values '||sqlerrm||' code='||sqlcode);
1304:
1305: end validate_values;
1306:
1307: procedure create_missing_data

Line 1337: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'1 POR_AUTO_CREATE_SHOPPING_CAT='||l_option_value);

1333: l_ret varchar2(1000);
1334: begin
1335: IF g_auto_map_category = 'Y' THEN
1336: fnd_profile.get('POR_AUTO_CREATE_SHOPPING_CAT', l_option_value);
1337: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'1 POR_AUTO_CREATE_SHOPPING_CAT='||l_option_value);
1338: fnd_profile.put('POR_AUTO_CREATE_SHOPPING_CAT', 'Y');
1339:
1340: open create_ip_cat;
1341: loop

Line 1344: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting po_category_id='||l_po_category_id);

1340: open create_ip_cat;
1341: loop
1342: fetch create_ip_cat into l_po_category_id;
1343: exit when create_ip_cat%NOTFOUND;
1344: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting po_category_id='||l_po_category_id);
1345: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;
1346: ICX_CAT_POPULATE_CATG_GRP.populateValidCategorySetInsert
1347: ( p_api_version =>1.0 ,
1348: p_commit =>FND_API.G_TRUE ,

Line 1353: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting over');

1349: x_return_status => l_ret ,
1350: p_category_set_id => g_category_set_id ,
1351: p_category_id =>l_po_category_id
1352: );
1353: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting over');
1354:
1355: end loop;
1356: close create_ip_cat;
1357:

Line 1367: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting item='||l_po_category_id);

1363: open create_mappings;
1364: loop
1365: fetch create_mappings into l_po_category_id;
1366: exit when create_mappings%NOTFOUND;
1367: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting item='||l_po_category_id);
1368: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;
1369: ICX_CAT_POPULATE_CATG_GRP.populateValidCategorySetInsert
1370: (p_api_version =>1.0 ,
1371: p_commit =>FND_API.G_TRUE ,

Line 1377: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting over');

1373: p_category_set_id => g_category_set_id ,
1374: p_category_id =>l_po_category_id
1375: );
1376:
1377: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting over');
1378:
1379: end loop;
1380: close create_mappings;
1381:

Line 1386: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting inv_item_id='||l_inv_item_id|| ' organization_id'||l_organization_id );

1382: open create_ctx_hdrs;
1383: loop
1384: fetch create_ctx_hdrs into l_inv_item_id,l_organization_id;
1385: exit when create_ctx_hdrs%NOTFOUND;
1386: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting inv_item_id='||l_inv_item_id|| ' organization_id'||l_organization_id );
1387:
1388: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1389: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := FALSE;
1390: ICX_CAT_POPULATE_MI_PVT.populateItemChange(l_inv_item_id, l_organization_id, NULL, NULL);

Line 1744: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'exception '||sqlerrm||' code='||sqlcode);

1740:
1741: logStatement(g_pkg_name, l_api_name ,'END of data fix');
1742:
1743: exception when others then
1744: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'exception '||sqlerrm||' code='||sqlcode);
1745:
1746: END PO_ATTRIBUTE_VALUES_DATA_FIX;
1747:
1748: procedure sync_sources(p_org_id in number,

Line 1849: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);

1845: l_end_date DATE;
1846: l_log_string VARCHAR2(2000);
1847: BEGIN
1848: l_err_loc := 100;
1849: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1850:
1851: x_return_status := FND_API.G_RET_STS_SUCCESS;
1852: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1853:

Line 1852: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);

1848: l_err_loc := 100;
1849: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1850:
1851: x_return_status := FND_API.G_RET_STS_SUCCESS;
1852: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1853:
1854: l_err_loc := 200;
1855: -- Standard Start of API savepoint
1856: SAVEPOINT populateItemSync_sp;

Line 1857: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);

1853:
1854: l_err_loc := 200;
1855: -- Standard Start of API savepoint
1856: SAVEPOINT populateItemSync_sp;
1857: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1858:
1859: l_err_loc := 300;
1860: l_start_date := sysdate;
1861: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);

Line 1861: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);

1857: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1858:
1859: l_err_loc := 300;
1860: l_start_date := sysdate;
1861: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1862: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')|| ' p_source_type=' ||p_source_type ;
1863:
1864: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

Line 1867: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);

1863:
1864: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1866: END IF;
1867: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1868:
1869: l_err_loc := 600;
1870: --Initialize the purchasing category set info.
1871: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;

Line 1872: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);

1868:
1869: l_err_loc := 600;
1870: --Initialize the purchasing category set info.
1871: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1872: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1873:
1874: l_err_loc := 800;
1875: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1876: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);

Line 1876: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);

1872: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1873:
1874: l_err_loc := 800;
1875: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1876: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1877:
1878: l_err_loc := 900;
1879: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
1880: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;

Line 1881: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);

1877:
1878: l_err_loc := 900;
1879: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
1880: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;
1881: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1882:
1883: l_err_loc := 1000;
1884: -- Set the batch_size for the online case
1885: ICX_CAT_UTIL_PVT.setBatchSize;

Line 1886: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);

1882:
1883: l_err_loc := 1000;
1884: -- Set the batch_size for the online case
1885: ICX_CAT_UTIL_PVT.setBatchSize;
1886: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1887:
1888: l_err_loc := 400;
1889: ICX_CAT_UTIL_PVT.setWhoColumns(g_request_id);
1890: if p_source_type = 'MASTER_ITEM' then

Line 1898: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting inv_item_id='||l_inv_item_id|| ' organization_id'||l_organization_id );

1894: open master_item_sync;
1895: loop
1896: fetch master_item_sync into l_inv_item_id,l_organization_id;
1897: exit when master_item_sync%NOTFOUND;
1898: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting inv_item_id='||l_inv_item_id|| ' organization_id'||l_organization_id );
1899:
1900: ICX_CAT_POPULATE_MI_PVT.populateItemChange(l_inv_item_id, l_ORGANIZATION_ID,null,null);
1901: end loop;
1902: close master_item_sync;

Line 1905: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,p_source_type);

1901: end loop;
1902: close master_item_sync;
1903: end if;
1904: if p_source_type = 'BLANKET' then
1905: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,p_source_type);
1906:
1907: update po_headers_all set last_update_date = sysdate
1908: where po_header_id in ( select distinct pol.po_header_id from po_attribute_values_tlp po , icx_cat_items_ctx_hdrs_tlp ctx, po_lines_all pol
1909: where po.po_line_id=ctx.po_line_id

Line 1914: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting BPA count='||Sql%ROWCOUNT);

1910: and po.po_line_id=pol.po_line_id
1911: and ctx.source_type in ('BLANKET','QUOTATION','GLOBAL_BLANKET')
1912: and (po.ip_category_id <> ctx.ip_category_id or pol.unit_price <> ctx.unit_price)
1913: );
1914: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting BPA count='||Sql%ROWCOUNT);
1915:
1916: select min(rowid), max(rowid) into l_min_row_id,l_max_row_id from po_headers_all;
1917: ICX_CAT_POPULATE_PODOCS_PVT.upgradeR12PODocs(sysdate-1,l_min_row_id,l_max_row_id);
1918: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting done for bpa ');

Line 1918: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting done for bpa ');

1914: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting BPA count='||Sql%ROWCOUNT);
1915:
1916: select min(rowid), max(rowid) into l_min_row_id,l_max_row_id from po_headers_all;
1917: ICX_CAT_POPULATE_PODOCS_PVT.upgradeR12PODocs(sysdate-1,l_min_row_id,l_max_row_id);
1918: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting done for bpa ');
1919:
1920: end if;
1921: l_err_loc := 1200;
1922: COMMIT;

Line 1979: END ICX_ITEM_DIAG_PVT;

1975: l_err_loc := 500;
1976: END logStatement;
1977:
1978:
1979: END ICX_ITEM_DIAG_PVT;