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

Line 37: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'split out_str='||out_str||' remaining_str='||in_str);

33: IF l_int2 = 0 THEN l_int2 := LENGTH( l_str ) + 1 ; END IF ;
34: out_str:= SUBSTR( l_str, l_int+1, l_int2 - l_int- 1) ;
35: in_str:= trim(SUBSTR( l_str, l_int2+1) );
36: END IF ;
37: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'split out_str='||out_str||' remaining_str='||in_str);
38:
39: exception when others then
40: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'split EXCEPTION::'||sqlerrm||' code='||sqlcode);
41: END Split;

Line 40: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'split EXCEPTION::'||sqlerrm||' code='||sqlcode);

36: END IF ;
37: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'split out_str='||out_str||' remaining_str='||in_str);
38:
39: exception when others then
40: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'split EXCEPTION::'||sqlerrm||' code='||sqlcode);
41: END Split;
42:
43: PROCEDURE ol
44: (

Line 51: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, 'ol EXCEPTION::',sqlerrm||' code='||sqlcode);

47: PRAGMA AUTONOMOUS_TRANSACTION;
48: BEGIN
49: fnd_file.put_line(fnd_file.output,p_str);
50: exception when others then
51: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, 'ol EXCEPTION::',sqlerrm||' code='||sqlcode);
52: END ol;
53:
54: function parse( p_str IN VARCHAR2)
55: RETURN VARCHAR2 IS

Line 61: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'parse p_str='||p_str);

57: substr VARCHAR2(4000):= '';
58: l_ctr number := 1;
59: l_api_name CONSTANT VARCHAR2(30) := 'parse';
60: BEGIN
61: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'parse p_str='||p_str);
62: str:=trim(p_str);
63: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'str '||str);
64: while ( str is not null )loop
65: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'next string ||' ||str);

Line 63: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'str '||str);

59: l_api_name CONSTANT VARCHAR2(30) := 'parse';
60: BEGIN
61: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'parse p_str='||p_str);
62: str:=trim(p_str);
63: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'str '||str);
64: while ( str is not null )loop
65: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'next string ||' ||str);
66: split(in_str=>str,
67: token_num=>1,

Line 65: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'next string ||' ||str);

61: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'parse p_str='||p_str);
62: str:=trim(p_str);
63: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'str '||str);
64: while ( str is not null )loop
65: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'next string ||' ||str);
66: split(in_str=>str,
67: token_num=>1,
68: delim=> ',',
69: out_str=>substr);

Line 70: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'at ctr= '||l_ctr|| ' string='|| str||' token='||substr );

66: split(in_str=>str,
67: token_num=>1,
68: delim=> ',',
69: out_str=>substr);
70: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'at ctr= '||l_ctr|| ' string='|| str||' token='||substr );
71: begin
72: ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) := to_number(substr);
73: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,' g_source_ids('||l_ctr||') :='|| ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) );
74:

Line 72: ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) := to_number(substr);

68: delim=> ',',
69: out_str=>substr);
70: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'at ctr= '||l_ctr|| ' string='|| str||' token='||substr );
71: begin
72: ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) := to_number(substr);
73: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,' g_source_ids('||l_ctr||') :='|| ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) );
74:
75: if ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) is null then
76: goto END_LOOP;

Line 73: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,' g_source_ids('||l_ctr||') :='|| ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) );

69: out_str=>substr);
70: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'at ctr= '||l_ctr|| ' string='|| str||' token='||substr );
71: begin
72: ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) := to_number(substr);
73: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,' g_source_ids('||l_ctr||') :='|| ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) );
74:
75: if ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) is null then
76: goto END_LOOP;
77: end if;

Line 75: if ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) is null then

71: begin
72: ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) := to_number(substr);
73: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,' g_source_ids('||l_ctr||') :='|| ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) );
74:
75: if ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) is null then
76: goto END_LOOP;
77: end if;
78: exception when others then
79: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'at ctr= exception');

Line 79: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'at ctr= exception');

75: if ICX_ITEM_DIAG_PVT.g_source_ids(l_ctr) is null then
76: goto END_LOOP;
77: end if;
78: exception when others then
79: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'at ctr= exception');
80: end;
81:
82: l_ctr:=l_ctr+1;
83: <> null;

Line 88: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'parse EXCEPTION::'||sqlerrm||' code='||sqlcode);

84: end loop;
85:
86: return 'Y';
87: exception when others then
88: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'parse EXCEPTION::'||sqlerrm||' code='||sqlcode);
89: return 'N';
90: END parse;
91:
92: FUNCTION row1

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

98: l_api_name CONSTANT VARCHAR2(30) := 'row1';
99: BEGIN
100: RETURN str|| str1 ||'';
101: exception when others then
102: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'row1 '||sqlerrm||' code='||sqlcode);
103: return 'N';
104:
105: END row1;
106:

Line 118: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'col EXCEPTION::'||sqlerrm||' code='||sqlcode);

114: BEGIN
115: RETURN str|| str1 ||'';
116:
117: exception when others then
118: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'col EXCEPTION::'||sqlerrm||' code='||sqlcode);
119: return 'N';
120: END col;
121:
122: FUNCTION table_hdr

Line 131: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'table_hdr EXCEPTION::'||sqlerrm||' code='||sqlcode);

127: l_api_name CONSTANT VARCHAR2(30) := 'table_hdr';
128: BEGIN
129: RETURN ''||str1 ||'';
130: exception when others then
131: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'table_hdr EXCEPTION::'||sqlerrm||' code='||sqlcode);
132: return 'N';
133:
134: END table_hdr;
135:
Line 167: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'print_table exception'|| sqlerrm||' '||sqlcode);

163: END LOOP;
164: ol('

');
165: return 'Y';
166: exception when others then
167: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'print_table exception'|| sqlerrm||' '||sqlcode);
168: return 'N';
169: END print_table;
170:
171: function init (org_id in varchar2,

Line 178: ICX_ITEM_DIAG_PVT.g_org_id := to_number(org_id);

174: l_api_name CONSTANT VARCHAR2(30) := 'init';
175: begin
176: /* Init values*/
177:
178: ICX_ITEM_DIAG_PVT.g_org_id := to_number(org_id);
179: if action_code ='SYNC_MASTER' then
180: ICX_ITEM_DIAG_PVT.g_source_type :='MASTER_ITEM';
181: elsif action_code ='SYNC_BPA' then
182: ICX_ITEM_DIAG_PVT.g_source_type :='BLANKET';

Line 180: ICX_ITEM_DIAG_PVT.g_source_type :='MASTER_ITEM';

176: /* Init values*/
177:
178: ICX_ITEM_DIAG_PVT.g_org_id := to_number(org_id);
179: if action_code ='SYNC_MASTER' then
180: ICX_ITEM_DIAG_PVT.g_source_type :='MASTER_ITEM';
181: elsif action_code ='SYNC_BPA' then
182: ICX_ITEM_DIAG_PVT.g_source_type :='BLANKET';
183: end if;
184: ICX_ITEM_DIAG_PVT.g_source_type_values(1):='ALL';ICX_ITEM_DIAG_PVT.g_source_type_values(2):='BPA';ICX_ITEM_DIAG_PVT.g_source_type_values(3):='MASTER ITEM';

Line 182: ICX_ITEM_DIAG_PVT.g_source_type :='BLANKET';

178: ICX_ITEM_DIAG_PVT.g_org_id := to_number(org_id);
179: if action_code ='SYNC_MASTER' then
180: ICX_ITEM_DIAG_PVT.g_source_type :='MASTER_ITEM';
181: elsif action_code ='SYNC_BPA' then
182: ICX_ITEM_DIAG_PVT.g_source_type :='BLANKET';
183: end if;
184: ICX_ITEM_DIAG_PVT.g_source_type_values(1):='ALL';ICX_ITEM_DIAG_PVT.g_source_type_values(2):='BPA';ICX_ITEM_DIAG_PVT.g_source_type_values(3):='MASTER ITEM';
185: ICX_ITEM_DIAG_PVT.g_auto_map_category:=nvl(auto_map_category,'N');
186:

Line 184: ICX_ITEM_DIAG_PVT.g_source_type_values(1):='ALL';ICX_ITEM_DIAG_PVT.g_source_type_values(2):='BPA';ICX_ITEM_DIAG_PVT.g_source_type_values(3):='MASTER ITEM';

180: ICX_ITEM_DIAG_PVT.g_source_type :='MASTER_ITEM';
181: elsif action_code ='SYNC_BPA' then
182: ICX_ITEM_DIAG_PVT.g_source_type :='BLANKET';
183: end if;
184: ICX_ITEM_DIAG_PVT.g_source_type_values(1):='ALL';ICX_ITEM_DIAG_PVT.g_source_type_values(2):='BPA';ICX_ITEM_DIAG_PVT.g_source_type_values(3):='MASTER ITEM';
185: ICX_ITEM_DIAG_PVT.g_auto_map_category:=nvl(auto_map_category,'N');
186:
187: ICX_ITEM_DIAG_PVT.g_table_names(1):='MTL_SYSTEM_ITEMS_B';ICX_ITEM_DIAG_PVT.g_table_names(2):='MTL_SYSTEM_ITEMS_TL';ICX_ITEM_DIAG_PVT.g_table_names(3):='MTL_ITEM_CATEGORIES';
188: ICX_ITEM_DIAG_PVT.g_table_names(4):='MTL_UNITS_OF_MEASURE';ICX_ITEM_DIAG_PVT.g_table_names(5):='ICX_CAT_CATEGORIES_TL';ICX_ITEM_DIAG_PVT.g_table_names(6):='ICX_CAT_ITEMS_CTX_HDRS_TLP';

Line 185: ICX_ITEM_DIAG_PVT.g_auto_map_category:=nvl(auto_map_category,'N');

181: elsif action_code ='SYNC_BPA' then
182: ICX_ITEM_DIAG_PVT.g_source_type :='BLANKET';
183: end if;
184: ICX_ITEM_DIAG_PVT.g_source_type_values(1):='ALL';ICX_ITEM_DIAG_PVT.g_source_type_values(2):='BPA';ICX_ITEM_DIAG_PVT.g_source_type_values(3):='MASTER ITEM';
185: ICX_ITEM_DIAG_PVT.g_auto_map_category:=nvl(auto_map_category,'N');
186:
187: ICX_ITEM_DIAG_PVT.g_table_names(1):='MTL_SYSTEM_ITEMS_B';ICX_ITEM_DIAG_PVT.g_table_names(2):='MTL_SYSTEM_ITEMS_TL';ICX_ITEM_DIAG_PVT.g_table_names(3):='MTL_ITEM_CATEGORIES';
188: ICX_ITEM_DIAG_PVT.g_table_names(4):='MTL_UNITS_OF_MEASURE';ICX_ITEM_DIAG_PVT.g_table_names(5):='ICX_CAT_CATEGORIES_TL';ICX_ITEM_DIAG_PVT.g_table_names(6):='ICX_CAT_ITEMS_CTX_HDRS_TLP';
189: ICX_ITEM_DIAG_PVT.g_table_names(7):='ICX_CAT_ITEMS_CTX_DTLS_TLP';ICX_ITEM_DIAG_PVT.g_table_names(8):='DR$SQE';ICX_ITEM_DIAG_PVT.g_table_names(9):='PO_ATTRIBUTE_VALUES';

Line 187: ICX_ITEM_DIAG_PVT.g_table_names(1):='MTL_SYSTEM_ITEMS_B';ICX_ITEM_DIAG_PVT.g_table_names(2):='MTL_SYSTEM_ITEMS_TL';ICX_ITEM_DIAG_PVT.g_table_names(3):='MTL_ITEM_CATEGORIES';

183: end if;
184: ICX_ITEM_DIAG_PVT.g_source_type_values(1):='ALL';ICX_ITEM_DIAG_PVT.g_source_type_values(2):='BPA';ICX_ITEM_DIAG_PVT.g_source_type_values(3):='MASTER ITEM';
185: ICX_ITEM_DIAG_PVT.g_auto_map_category:=nvl(auto_map_category,'N');
186:
187: ICX_ITEM_DIAG_PVT.g_table_names(1):='MTL_SYSTEM_ITEMS_B';ICX_ITEM_DIAG_PVT.g_table_names(2):='MTL_SYSTEM_ITEMS_TL';ICX_ITEM_DIAG_PVT.g_table_names(3):='MTL_ITEM_CATEGORIES';
188: ICX_ITEM_DIAG_PVT.g_table_names(4):='MTL_UNITS_OF_MEASURE';ICX_ITEM_DIAG_PVT.g_table_names(5):='ICX_CAT_CATEGORIES_TL';ICX_ITEM_DIAG_PVT.g_table_names(6):='ICX_CAT_ITEMS_CTX_HDRS_TLP';
189: ICX_ITEM_DIAG_PVT.g_table_names(7):='ICX_CAT_ITEMS_CTX_DTLS_TLP';ICX_ITEM_DIAG_PVT.g_table_names(8):='DR$SQE';ICX_ITEM_DIAG_PVT.g_table_names(9):='PO_ATTRIBUTE_VALUES';
190: ICX_ITEM_DIAG_PVT.g_table_names(10):='PO_ATTRIBUTE_VALUES_TLP';ICX_ITEM_DIAG_PVT.g_table_names(11):='ICX_CAT_ATTRIBUTE_VALUES';ICX_ITEM_DIAG_PVT.g_table_names(12):='ICX_CAT_ATTRIBUTE_VALUES_TLP';
191: ICX_ITEM_DIAG_PVT.g_table_names(13):='PO_SESSION_GT';

Line 188: ICX_ITEM_DIAG_PVT.g_table_names(4):='MTL_UNITS_OF_MEASURE';ICX_ITEM_DIAG_PVT.g_table_names(5):='ICX_CAT_CATEGORIES_TL';ICX_ITEM_DIAG_PVT.g_table_names(6):='ICX_CAT_ITEMS_CTX_HDRS_TLP';

184: ICX_ITEM_DIAG_PVT.g_source_type_values(1):='ALL';ICX_ITEM_DIAG_PVT.g_source_type_values(2):='BPA';ICX_ITEM_DIAG_PVT.g_source_type_values(3):='MASTER ITEM';
185: ICX_ITEM_DIAG_PVT.g_auto_map_category:=nvl(auto_map_category,'N');
186:
187: ICX_ITEM_DIAG_PVT.g_table_names(1):='MTL_SYSTEM_ITEMS_B';ICX_ITEM_DIAG_PVT.g_table_names(2):='MTL_SYSTEM_ITEMS_TL';ICX_ITEM_DIAG_PVT.g_table_names(3):='MTL_ITEM_CATEGORIES';
188: ICX_ITEM_DIAG_PVT.g_table_names(4):='MTL_UNITS_OF_MEASURE';ICX_ITEM_DIAG_PVT.g_table_names(5):='ICX_CAT_CATEGORIES_TL';ICX_ITEM_DIAG_PVT.g_table_names(6):='ICX_CAT_ITEMS_CTX_HDRS_TLP';
189: ICX_ITEM_DIAG_PVT.g_table_names(7):='ICX_CAT_ITEMS_CTX_DTLS_TLP';ICX_ITEM_DIAG_PVT.g_table_names(8):='DR$SQE';ICX_ITEM_DIAG_PVT.g_table_names(9):='PO_ATTRIBUTE_VALUES';
190: ICX_ITEM_DIAG_PVT.g_table_names(10):='PO_ATTRIBUTE_VALUES_TLP';ICX_ITEM_DIAG_PVT.g_table_names(11):='ICX_CAT_ATTRIBUTE_VALUES';ICX_ITEM_DIAG_PVT.g_table_names(12):='ICX_CAT_ATTRIBUTE_VALUES_TLP';
191: ICX_ITEM_DIAG_PVT.g_table_names(13):='PO_SESSION_GT';
192:

Line 189: ICX_ITEM_DIAG_PVT.g_table_names(7):='ICX_CAT_ITEMS_CTX_DTLS_TLP';ICX_ITEM_DIAG_PVT.g_table_names(8):='DR$SQE';ICX_ITEM_DIAG_PVT.g_table_names(9):='PO_ATTRIBUTE_VALUES';

185: ICX_ITEM_DIAG_PVT.g_auto_map_category:=nvl(auto_map_category,'N');
186:
187: ICX_ITEM_DIAG_PVT.g_table_names(1):='MTL_SYSTEM_ITEMS_B';ICX_ITEM_DIAG_PVT.g_table_names(2):='MTL_SYSTEM_ITEMS_TL';ICX_ITEM_DIAG_PVT.g_table_names(3):='MTL_ITEM_CATEGORIES';
188: ICX_ITEM_DIAG_PVT.g_table_names(4):='MTL_UNITS_OF_MEASURE';ICX_ITEM_DIAG_PVT.g_table_names(5):='ICX_CAT_CATEGORIES_TL';ICX_ITEM_DIAG_PVT.g_table_names(6):='ICX_CAT_ITEMS_CTX_HDRS_TLP';
189: ICX_ITEM_DIAG_PVT.g_table_names(7):='ICX_CAT_ITEMS_CTX_DTLS_TLP';ICX_ITEM_DIAG_PVT.g_table_names(8):='DR$SQE';ICX_ITEM_DIAG_PVT.g_table_names(9):='PO_ATTRIBUTE_VALUES';
190: ICX_ITEM_DIAG_PVT.g_table_names(10):='PO_ATTRIBUTE_VALUES_TLP';ICX_ITEM_DIAG_PVT.g_table_names(11):='ICX_CAT_ATTRIBUTE_VALUES';ICX_ITEM_DIAG_PVT.g_table_names(12):='ICX_CAT_ATTRIBUTE_VALUES_TLP';
191: ICX_ITEM_DIAG_PVT.g_table_names(13):='PO_SESSION_GT';
192:
193: ICX_ITEM_DIAG_PVT.g_error_code(1):='TOO_MANY_PO_CATEGORY_ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(2):='IP_CATEGORY_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(3):='CATEGORY_MAPPING_MISSING';

Line 190: ICX_ITEM_DIAG_PVT.g_table_names(10):='PO_ATTRIBUTE_VALUES_TLP';ICX_ITEM_DIAG_PVT.g_table_names(11):='ICX_CAT_ATTRIBUTE_VALUES';ICX_ITEM_DIAG_PVT.g_table_names(12):='ICX_CAT_ATTRIBUTE_VALUES_TLP';

186:
187: ICX_ITEM_DIAG_PVT.g_table_names(1):='MTL_SYSTEM_ITEMS_B';ICX_ITEM_DIAG_PVT.g_table_names(2):='MTL_SYSTEM_ITEMS_TL';ICX_ITEM_DIAG_PVT.g_table_names(3):='MTL_ITEM_CATEGORIES';
188: ICX_ITEM_DIAG_PVT.g_table_names(4):='MTL_UNITS_OF_MEASURE';ICX_ITEM_DIAG_PVT.g_table_names(5):='ICX_CAT_CATEGORIES_TL';ICX_ITEM_DIAG_PVT.g_table_names(6):='ICX_CAT_ITEMS_CTX_HDRS_TLP';
189: ICX_ITEM_DIAG_PVT.g_table_names(7):='ICX_CAT_ITEMS_CTX_DTLS_TLP';ICX_ITEM_DIAG_PVT.g_table_names(8):='DR$SQE';ICX_ITEM_DIAG_PVT.g_table_names(9):='PO_ATTRIBUTE_VALUES';
190: ICX_ITEM_DIAG_PVT.g_table_names(10):='PO_ATTRIBUTE_VALUES_TLP';ICX_ITEM_DIAG_PVT.g_table_names(11):='ICX_CAT_ATTRIBUTE_VALUES';ICX_ITEM_DIAG_PVT.g_table_names(12):='ICX_CAT_ATTRIBUTE_VALUES_TLP';
191: ICX_ITEM_DIAG_PVT.g_table_names(13):='PO_SESSION_GT';
192:
193: ICX_ITEM_DIAG_PVT.g_error_code(1):='TOO_MANY_PO_CATEGORY_ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(2):='IP_CATEGORY_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(3):='CATEGORY_MAPPING_MISSING';
194: ICX_ITEM_DIAG_PVT.g_error_code(4):='PO_ATTRIBUTE_RECORDS_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(5):='MASTER ITEM NOT ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(6):='ICX_CTX_HDRS_MISSING';

Line 191: ICX_ITEM_DIAG_PVT.g_table_names(13):='PO_SESSION_GT';

187: ICX_ITEM_DIAG_PVT.g_table_names(1):='MTL_SYSTEM_ITEMS_B';ICX_ITEM_DIAG_PVT.g_table_names(2):='MTL_SYSTEM_ITEMS_TL';ICX_ITEM_DIAG_PVT.g_table_names(3):='MTL_ITEM_CATEGORIES';
188: ICX_ITEM_DIAG_PVT.g_table_names(4):='MTL_UNITS_OF_MEASURE';ICX_ITEM_DIAG_PVT.g_table_names(5):='ICX_CAT_CATEGORIES_TL';ICX_ITEM_DIAG_PVT.g_table_names(6):='ICX_CAT_ITEMS_CTX_HDRS_TLP';
189: ICX_ITEM_DIAG_PVT.g_table_names(7):='ICX_CAT_ITEMS_CTX_DTLS_TLP';ICX_ITEM_DIAG_PVT.g_table_names(8):='DR$SQE';ICX_ITEM_DIAG_PVT.g_table_names(9):='PO_ATTRIBUTE_VALUES';
190: ICX_ITEM_DIAG_PVT.g_table_names(10):='PO_ATTRIBUTE_VALUES_TLP';ICX_ITEM_DIAG_PVT.g_table_names(11):='ICX_CAT_ATTRIBUTE_VALUES';ICX_ITEM_DIAG_PVT.g_table_names(12):='ICX_CAT_ATTRIBUTE_VALUES_TLP';
191: ICX_ITEM_DIAG_PVT.g_table_names(13):='PO_SESSION_GT';
192:
193: ICX_ITEM_DIAG_PVT.g_error_code(1):='TOO_MANY_PO_CATEGORY_ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(2):='IP_CATEGORY_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(3):='CATEGORY_MAPPING_MISSING';
194: ICX_ITEM_DIAG_PVT.g_error_code(4):='PO_ATTRIBUTE_RECORDS_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(5):='MASTER ITEM NOT ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(6):='ICX_CTX_HDRS_MISSING';
195: ICX_ITEM_DIAG_PVT.g_error_code(7):='NOT_VALID_FOR_SEARCH';

Line 193: ICX_ITEM_DIAG_PVT.g_error_code(1):='TOO_MANY_PO_CATEGORY_ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(2):='IP_CATEGORY_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(3):='CATEGORY_MAPPING_MISSING';

189: ICX_ITEM_DIAG_PVT.g_table_names(7):='ICX_CAT_ITEMS_CTX_DTLS_TLP';ICX_ITEM_DIAG_PVT.g_table_names(8):='DR$SQE';ICX_ITEM_DIAG_PVT.g_table_names(9):='PO_ATTRIBUTE_VALUES';
190: ICX_ITEM_DIAG_PVT.g_table_names(10):='PO_ATTRIBUTE_VALUES_TLP';ICX_ITEM_DIAG_PVT.g_table_names(11):='ICX_CAT_ATTRIBUTE_VALUES';ICX_ITEM_DIAG_PVT.g_table_names(12):='ICX_CAT_ATTRIBUTE_VALUES_TLP';
191: ICX_ITEM_DIAG_PVT.g_table_names(13):='PO_SESSION_GT';
192:
193: ICX_ITEM_DIAG_PVT.g_error_code(1):='TOO_MANY_PO_CATEGORY_ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(2):='IP_CATEGORY_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(3):='CATEGORY_MAPPING_MISSING';
194: ICX_ITEM_DIAG_PVT.g_error_code(4):='PO_ATTRIBUTE_RECORDS_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(5):='MASTER ITEM NOT ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(6):='ICX_CTX_HDRS_MISSING';
195: ICX_ITEM_DIAG_PVT.g_error_code(7):='NOT_VALID_FOR_SEARCH';
196:
197: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting po_session_gt');

Line 194: ICX_ITEM_DIAG_PVT.g_error_code(4):='PO_ATTRIBUTE_RECORDS_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(5):='MASTER ITEM NOT ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(6):='ICX_CTX_HDRS_MISSING';

190: ICX_ITEM_DIAG_PVT.g_table_names(10):='PO_ATTRIBUTE_VALUES_TLP';ICX_ITEM_DIAG_PVT.g_table_names(11):='ICX_CAT_ATTRIBUTE_VALUES';ICX_ITEM_DIAG_PVT.g_table_names(12):='ICX_CAT_ATTRIBUTE_VALUES_TLP';
191: ICX_ITEM_DIAG_PVT.g_table_names(13):='PO_SESSION_GT';
192:
193: ICX_ITEM_DIAG_PVT.g_error_code(1):='TOO_MANY_PO_CATEGORY_ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(2):='IP_CATEGORY_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(3):='CATEGORY_MAPPING_MISSING';
194: ICX_ITEM_DIAG_PVT.g_error_code(4):='PO_ATTRIBUTE_RECORDS_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(5):='MASTER ITEM NOT ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(6):='ICX_CTX_HDRS_MISSING';
195: ICX_ITEM_DIAG_PVT.g_error_code(7):='NOT_VALID_FOR_SEARCH';
196:
197: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting po_session_gt');
198: DELETE FROM po_session_gt WHERE index_char1 in ( ICX_ITEM_DIAG_PVT.g_file_key , ICX_ITEM_DIAG_PVT.g_error_key,ICX_ITEM_DIAG_PVT.g_id_values_key) ;

Line 195: ICX_ITEM_DIAG_PVT.g_error_code(7):='NOT_VALID_FOR_SEARCH';

191: ICX_ITEM_DIAG_PVT.g_table_names(13):='PO_SESSION_GT';
192:
193: ICX_ITEM_DIAG_PVT.g_error_code(1):='TOO_MANY_PO_CATEGORY_ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(2):='IP_CATEGORY_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(3):='CATEGORY_MAPPING_MISSING';
194: ICX_ITEM_DIAG_PVT.g_error_code(4):='PO_ATTRIBUTE_RECORDS_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(5):='MASTER ITEM NOT ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(6):='ICX_CTX_HDRS_MISSING';
195: ICX_ITEM_DIAG_PVT.g_error_code(7):='NOT_VALID_FOR_SEARCH';
196:
197: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting po_session_gt');
198: DELETE FROM po_session_gt WHERE index_char1 in ( ICX_ITEM_DIAG_PVT.g_file_key , ICX_ITEM_DIAG_PVT.g_error_key,ICX_ITEM_DIAG_PVT.g_id_values_key) ;
199:

Line 197: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting po_session_gt');

193: ICX_ITEM_DIAG_PVT.g_error_code(1):='TOO_MANY_PO_CATEGORY_ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(2):='IP_CATEGORY_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(3):='CATEGORY_MAPPING_MISSING';
194: ICX_ITEM_DIAG_PVT.g_error_code(4):='PO_ATTRIBUTE_RECORDS_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(5):='MASTER ITEM NOT ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(6):='ICX_CTX_HDRS_MISSING';
195: ICX_ITEM_DIAG_PVT.g_error_code(7):='NOT_VALID_FOR_SEARCH';
196:
197: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting po_session_gt');
198: DELETE FROM po_session_gt WHERE index_char1 in ( ICX_ITEM_DIAG_PVT.g_file_key , ICX_ITEM_DIAG_PVT.g_error_key,ICX_ITEM_DIAG_PVT.g_id_values_key) ;
199:
200: return 'Y';
201: exception when others then

Line 198: DELETE FROM po_session_gt WHERE index_char1 in ( ICX_ITEM_DIAG_PVT.g_file_key , ICX_ITEM_DIAG_PVT.g_error_key,ICX_ITEM_DIAG_PVT.g_id_values_key) ;

194: ICX_ITEM_DIAG_PVT.g_error_code(4):='PO_ATTRIBUTE_RECORDS_MISSING';ICX_ITEM_DIAG_PVT.g_error_code(5):='MASTER ITEM NOT ASSIGNED';ICX_ITEM_DIAG_PVT.g_error_code(6):='ICX_CTX_HDRS_MISSING';
195: ICX_ITEM_DIAG_PVT.g_error_code(7):='NOT_VALID_FOR_SEARCH';
196:
197: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'deleting po_session_gt');
198: DELETE FROM po_session_gt WHERE index_char1 in ( ICX_ITEM_DIAG_PVT.g_file_key , ICX_ITEM_DIAG_PVT.g_error_key,ICX_ITEM_DIAG_PVT.g_id_values_key) ;
199:
200: return 'Y';
201: exception when others then
202: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'init EXCEPTION::'||sqlerrm||' code='||sqlcode);

Line 202: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'init EXCEPTION::'||sqlerrm||' code='||sqlcode);

198: DELETE FROM po_session_gt WHERE index_char1 in ( ICX_ITEM_DIAG_PVT.g_file_key , ICX_ITEM_DIAG_PVT.g_error_key,ICX_ITEM_DIAG_PVT.g_id_values_key) ;
199:
200: return 'Y';
201: exception when others then
202: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'init EXCEPTION::'||sqlerrm||' code='||sqlcode);
203: return 'N';
204:
205: end init;
206:

Line 225: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string);

221: l_log_string VARCHAR2(1000);
222: BEGIN
223: l_start_date := sysdate;
224: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS');
225: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string);
226:
227: l_html_out :=l_html_out || '