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_CAT_POPULATE_CATG_PVT dependencies on ICX_CAT_UTIL_PVT

Line 88: ICX_CAT_UTIL_PVT.getTableElement(gInsMapRtCategoryIdTbl, p_index) || ', ';

84: l_string := 'logPLSQLTableRow('||p_action_mode||')['||p_index||']--';
85: IF (p_action_mode = 'INSERT_MAPPING') THEN
86: -- Insert into icx_por_category_data_sources and icx_por_category_order_map
87: l_string := l_string || ' gInsMapRtCategoryIdTbl: ' ||
88: ICX_CAT_UTIL_PVT.getTableElement(gInsMapRtCategoryIdTbl, p_index) || ', ';
89: l_string := l_string || ' gInsMapCategoryKeyTbl: ' ||
90: ICX_CAT_UTIL_PVT.getTableElement(gInsMapCategoryKeyTbl, p_index) || ', ';
91: l_string := l_string || ' gInsMapLanguageTbl: ' ||
92: ICX_CAT_UTIL_PVT.getTableElement(gInsMapLanguageTbl, p_index) || ', ';

Line 90: ICX_CAT_UTIL_PVT.getTableElement(gInsMapCategoryKeyTbl, p_index) || ', ';

86: -- Insert into icx_por_category_data_sources and icx_por_category_order_map
87: l_string := l_string || ' gInsMapRtCategoryIdTbl: ' ||
88: ICX_CAT_UTIL_PVT.getTableElement(gInsMapRtCategoryIdTbl, p_index) || ', ';
89: l_string := l_string || ' gInsMapCategoryKeyTbl: ' ||
90: ICX_CAT_UTIL_PVT.getTableElement(gInsMapCategoryKeyTbl, p_index) || ', ';
91: l_string := l_string || ' gInsMapLanguageTbl: ' ||
92: ICX_CAT_UTIL_PVT.getTableElement(gInsMapLanguageTbl, p_index) || ', ';
93: END IF;
94:

Line 92: ICX_CAT_UTIL_PVT.getTableElement(gInsMapLanguageTbl, p_index) || ', ';

88: ICX_CAT_UTIL_PVT.getTableElement(gInsMapRtCategoryIdTbl, p_index) || ', ';
89: l_string := l_string || ' gInsMapCategoryKeyTbl: ' ||
90: ICX_CAT_UTIL_PVT.getTableElement(gInsMapCategoryKeyTbl, p_index) || ', ';
91: l_string := l_string || ' gInsMapLanguageTbl: ' ||
92: ICX_CAT_UTIL_PVT.getTableElement(gInsMapLanguageTbl, p_index) || ', ';
93: END IF;
94:
95: IF (p_action_mode = 'INSERT_CATEGORY') THEN
96: -- Insert into icx_cat_categories_tl

Line 98: ICX_CAT_UTIL_PVT.getTableElement(gInsRtCategoryIdTbl, p_index) || ', ';

94:
95: IF (p_action_mode = 'INSERT_CATEGORY') THEN
96: -- Insert into icx_cat_categories_tl
97: l_string := l_string || ' gInsRtCategoryIdTbl: ' ||
98: ICX_CAT_UTIL_PVT.getTableElement(gInsRtCategoryIdTbl, p_index) || ', ';
99: l_string := l_string || ' gInsCategoryKeyTbl: ' ||
100: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryKeyTbl, p_index) || ', ';
101: l_string := l_string || ' gInsCategoryNameTbl: ' ||
102: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryNameTbl, p_index) || ', ';

Line 100: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryKeyTbl, p_index) || ', ';

96: -- Insert into icx_cat_categories_tl
97: l_string := l_string || ' gInsRtCategoryIdTbl: ' ||
98: ICX_CAT_UTIL_PVT.getTableElement(gInsRtCategoryIdTbl, p_index) || ', ';
99: l_string := l_string || ' gInsCategoryKeyTbl: ' ||
100: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryKeyTbl, p_index) || ', ';
101: l_string := l_string || ' gInsCategoryNameTbl: ' ||
102: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryNameTbl, p_index) || ', ';
103: l_string := l_string || ' gInsLanguageTbl: ' ||
104: ICX_CAT_UTIL_PVT.getTableElement(gInsLanguageTbl, p_index) || ', ';

Line 102: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryNameTbl, p_index) || ', ';

98: ICX_CAT_UTIL_PVT.getTableElement(gInsRtCategoryIdTbl, p_index) || ', ';
99: l_string := l_string || ' gInsCategoryKeyTbl: ' ||
100: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryKeyTbl, p_index) || ', ';
101: l_string := l_string || ' gInsCategoryNameTbl: ' ||
102: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryNameTbl, p_index) || ', ';
103: l_string := l_string || ' gInsLanguageTbl: ' ||
104: ICX_CAT_UTIL_PVT.getTableElement(gInsLanguageTbl, p_index) || ', ';
105: l_string := l_string || ' gInsSourceLangTbl: ' ||
106: ICX_CAT_UTIL_PVT.getTableElement(gInsSourceLangTbl, p_index) || ', ';

Line 104: ICX_CAT_UTIL_PVT.getTableElement(gInsLanguageTbl, p_index) || ', ';

100: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryKeyTbl, p_index) || ', ';
101: l_string := l_string || ' gInsCategoryNameTbl: ' ||
102: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryNameTbl, p_index) || ', ';
103: l_string := l_string || ' gInsLanguageTbl: ' ||
104: ICX_CAT_UTIL_PVT.getTableElement(gInsLanguageTbl, p_index) || ', ';
105: l_string := l_string || ' gInsSourceLangTbl: ' ||
106: ICX_CAT_UTIL_PVT.getTableElement(gInsSourceLangTbl, p_index) || ', ';
107: END IF;
108:

Line 106: ICX_CAT_UTIL_PVT.getTableElement(gInsSourceLangTbl, p_index) || ', ';

102: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryNameTbl, p_index) || ', ';
103: l_string := l_string || ' gInsLanguageTbl: ' ||
104: ICX_CAT_UTIL_PVT.getTableElement(gInsLanguageTbl, p_index) || ', ';
105: l_string := l_string || ' gInsSourceLangTbl: ' ||
106: ICX_CAT_UTIL_PVT.getTableElement(gInsSourceLangTbl, p_index) || ', ';
107: END IF;
108:
109: IF (p_action_mode IN ('ALL', 'INSERT_ITEM_CATEGORY')) THEN
110: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

Line 112: ICX_CAT_UTIL_PVT.getTableElement(gInsPOCategoryIdTbl, p_index) || ', ';

108:
109: IF (p_action_mode IN ('ALL', 'INSERT_ITEM_CATEGORY')) THEN
110: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
111: l_string := l_string || ' gInsPOCategoryIdTbl: ' ||
112: ICX_CAT_UTIL_PVT.getTableElement(gInsPOCategoryIdTbl, p_index) || ', ';
113: END IF;
114:
115: IF (p_action_mode = 'UPDATE_CATEGORY') THEN
116: -- Update icx_cat_categories_tl

Line 118: ICX_CAT_UTIL_PVT.getTableElement(gUpdRtCategoryIdTbl, p_index) || ', ';

114:
115: IF (p_action_mode = 'UPDATE_CATEGORY') THEN
116: -- Update icx_cat_categories_tl
117: l_string := l_string || ' gUpdRtCategoryIdTbl: ' ||
118: ICX_CAT_UTIL_PVT.getTableElement(gUpdRtCategoryIdTbl, p_index) || ', ';
119: l_string := l_string || ' gUpdCategoryNameTbl: ' ||
120: ICX_CAT_UTIL_PVT.getTableElement(gUpdCategoryNameTbl, p_index) || ', ';
121: l_string := l_string || ' gUpdLanguageTbl: ' ||
122: ICX_CAT_UTIL_PVT.getTableElement(gUpdLanguageTbl, p_index) || ', ';

Line 120: ICX_CAT_UTIL_PVT.getTableElement(gUpdCategoryNameTbl, p_index) || ', ';

116: -- Update icx_cat_categories_tl
117: l_string := l_string || ' gUpdRtCategoryIdTbl: ' ||
118: ICX_CAT_UTIL_PVT.getTableElement(gUpdRtCategoryIdTbl, p_index) || ', ';
119: l_string := l_string || ' gUpdCategoryNameTbl: ' ||
120: ICX_CAT_UTIL_PVT.getTableElement(gUpdCategoryNameTbl, p_index) || ', ';
121: l_string := l_string || ' gUpdLanguageTbl: ' ||
122: ICX_CAT_UTIL_PVT.getTableElement(gUpdLanguageTbl, p_index) || ', ';
123: l_string := l_string || ' gUpdSourceLangTbl: ' ||
124: ICX_CAT_UTIL_PVT.getTableElement(gUpdSourceLangTbl, p_index) || ', ';

Line 122: ICX_CAT_UTIL_PVT.getTableElement(gUpdLanguageTbl, p_index) || ', ';

118: ICX_CAT_UTIL_PVT.getTableElement(gUpdRtCategoryIdTbl, p_index) || ', ';
119: l_string := l_string || ' gUpdCategoryNameTbl: ' ||
120: ICX_CAT_UTIL_PVT.getTableElement(gUpdCategoryNameTbl, p_index) || ', ';
121: l_string := l_string || ' gUpdLanguageTbl: ' ||
122: ICX_CAT_UTIL_PVT.getTableElement(gUpdLanguageTbl, p_index) || ', ';
123: l_string := l_string || ' gUpdSourceLangTbl: ' ||
124: ICX_CAT_UTIL_PVT.getTableElement(gUpdSourceLangTbl, p_index) || ', ';
125: END IF;
126:

Line 124: ICX_CAT_UTIL_PVT.getTableElement(gUpdSourceLangTbl, p_index) || ', ';

120: ICX_CAT_UTIL_PVT.getTableElement(gUpdCategoryNameTbl, p_index) || ', ';
121: l_string := l_string || ' gUpdLanguageTbl: ' ||
122: ICX_CAT_UTIL_PVT.getTableElement(gUpdLanguageTbl, p_index) || ', ';
123: l_string := l_string || ' gUpdSourceLangTbl: ' ||
124: ICX_CAT_UTIL_PVT.getTableElement(gUpdSourceLangTbl, p_index) || ', ';
125: END IF;
126:
127: IF (p_action_mode = 'DELETE_CATEGORY') THEN
128: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

Line 130: ICX_CAT_UTIL_PVT.getTableElement(gDelPoCategoryIdTbl, p_index) || ', ';

126:
127: IF (p_action_mode = 'DELETE_CATEGORY') THEN
128: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
129: l_string := l_string || ' gDelPoCategoryIdTbl: ' ||
130: ICX_CAT_UTIL_PVT.getTableElement(gDelPoCategoryIdTbl, p_index) || ', ';
131: END IF;
132:
133: RETURN l_string;
134:

Line 151: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, p_api_name);

147: BEGIN
148: l_err_loc := 100;
149: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
150: l_err_loc := 200;
151: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, p_api_name);
152:
153: l_err_loc := 300;
154: l_log_string := 'logPLSQLTableRow('||p_action_mode||')['||p_index||']--';
155: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 162: ICX_CAT_UTIL_PVT.getTableElement(gInsMapRtCategoryIdTbl, p_index) || ', ';

158: IF (p_action_mode = 'INSERT_MAPPING') THEN
159: l_err_loc := 500;
160: -- Insert into icx_por_category_data_sources and icx_por_category_order_map
161: l_log_string := ' gInsMapRtCategoryIdTbl['||p_index||']: ' ||
162: ICX_CAT_UTIL_PVT.getTableElement(gInsMapRtCategoryIdTbl, p_index) || ', ';
163: FND_LOG.string(p_log_level, l_module_name, l_log_string);
164:
165: l_log_string := ' gInsMapCategoryKeyTbl['||p_index||']: ' ||
166: ICX_CAT_UTIL_PVT.getTableElement(gInsMapCategoryKeyTbl, p_index) || ', ';

Line 166: ICX_CAT_UTIL_PVT.getTableElement(gInsMapCategoryKeyTbl, p_index) || ', ';

162: ICX_CAT_UTIL_PVT.getTableElement(gInsMapRtCategoryIdTbl, p_index) || ', ';
163: FND_LOG.string(p_log_level, l_module_name, l_log_string);
164:
165: l_log_string := ' gInsMapCategoryKeyTbl['||p_index||']: ' ||
166: ICX_CAT_UTIL_PVT.getTableElement(gInsMapCategoryKeyTbl, p_index) || ', ';
167: FND_LOG.string(p_log_level, l_module_name, l_log_string);
168:
169: l_log_string := ' gInsMapLanguageTbl['||p_index||']: ' ||
170: ICX_CAT_UTIL_PVT.getTableElement(gInsMapLanguageTbl, p_index) || ', ';

Line 170: ICX_CAT_UTIL_PVT.getTableElement(gInsMapLanguageTbl, p_index) || ', ';

166: ICX_CAT_UTIL_PVT.getTableElement(gInsMapCategoryKeyTbl, p_index) || ', ';
167: FND_LOG.string(p_log_level, l_module_name, l_log_string);
168:
169: l_log_string := ' gInsMapLanguageTbl['||p_index||']: ' ||
170: ICX_CAT_UTIL_PVT.getTableElement(gInsMapLanguageTbl, p_index) || ', ';
171: FND_LOG.string(p_log_level, l_module_name, l_log_string);
172: END IF;
173:
174: l_err_loc := 600;

Line 182: ICX_CAT_UTIL_PVT.getTableElement(gInsRtCategoryIdTbl, p_index) || ', ';

178: -- Insert into icx_cat_categories_tl
179: FND_LOG.string(p_log_level, l_module_name, l_log_string);
180:
181: l_log_string := ' gInsRtCategoryIdTbl['||p_index||']: ' ||
182: ICX_CAT_UTIL_PVT.getTableElement(gInsRtCategoryIdTbl, p_index) || ', ';
183: FND_LOG.string(p_log_level, l_module_name, l_log_string);
184:
185: l_log_string := ' gInsCategoryKeyTbl['||p_index||']: ' ||
186: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryKeyTbl, p_index) || ', ';

Line 186: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryKeyTbl, p_index) || ', ';

182: ICX_CAT_UTIL_PVT.getTableElement(gInsRtCategoryIdTbl, p_index) || ', ';
183: FND_LOG.string(p_log_level, l_module_name, l_log_string);
184:
185: l_log_string := ' gInsCategoryKeyTbl['||p_index||']: ' ||
186: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryKeyTbl, p_index) || ', ';
187: FND_LOG.string(p_log_level, l_module_name, l_log_string);
188:
189: l_log_string := ' gInsCategoryNameTbl['||p_index||']: ' ||
190: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryNameTbl, p_index) || ', ';

Line 190: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryNameTbl, p_index) || ', ';

186: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryKeyTbl, p_index) || ', ';
187: FND_LOG.string(p_log_level, l_module_name, l_log_string);
188:
189: l_log_string := ' gInsCategoryNameTbl['||p_index||']: ' ||
190: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryNameTbl, p_index) || ', ';
191: FND_LOG.string(p_log_level, l_module_name, l_log_string);
192:
193: l_log_string := ' gInsLanguageTbl['||p_index||']: ' ||
194: ICX_CAT_UTIL_PVT.getTableElement(gInsLanguageTbl, p_index) || ', ';

Line 194: ICX_CAT_UTIL_PVT.getTableElement(gInsLanguageTbl, p_index) || ', ';

190: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryNameTbl, p_index) || ', ';
191: FND_LOG.string(p_log_level, l_module_name, l_log_string);
192:
193: l_log_string := ' gInsLanguageTbl['||p_index||']: ' ||
194: ICX_CAT_UTIL_PVT.getTableElement(gInsLanguageTbl, p_index) || ', ';
195: FND_LOG.string(p_log_level, l_module_name, l_log_string);
196:
197: l_log_string := ' gInsSourceLangTbl['||p_index||']: ' ||
198: ICX_CAT_UTIL_PVT.getTableElement(gInsSourceLangTbl, p_index) || ', ';

Line 198: ICX_CAT_UTIL_PVT.getTableElement(gInsSourceLangTbl, p_index) || ', ';

194: ICX_CAT_UTIL_PVT.getTableElement(gInsLanguageTbl, p_index) || ', ';
195: FND_LOG.string(p_log_level, l_module_name, l_log_string);
196:
197: l_log_string := ' gInsSourceLangTbl['||p_index||']: ' ||
198: ICX_CAT_UTIL_PVT.getTableElement(gInsSourceLangTbl, p_index) || ', ';
199: FND_LOG.string(p_log_level, l_module_name, l_log_string);
200: END IF;
201:
202: l_err_loc := 800;

Line 210: ICX_CAT_UTIL_PVT.getTableElement(gInsPOCategoryIdTbl, p_index) || ', ';

206: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
207: FND_LOG.string(p_log_level, l_module_name, l_log_string);
208:
209: l_log_string := ' gInsPOCategoryIdTbl['||p_index||']: ' ||
210: ICX_CAT_UTIL_PVT.getTableElement(gInsPOCategoryIdTbl, p_index) || ', ';
211: FND_LOG.string(p_log_level, l_module_name, l_log_string);
212: END IF;
213:
214: l_err_loc := 900;

Line 222: ICX_CAT_UTIL_PVT.getTableElement(gUpdRtCategoryIdTbl, p_index) || ', ';

218: -- Update icx_cat_categories_tl
219: FND_LOG.string(p_log_level, l_module_name, l_log_string);
220:
221: l_log_string := ' gUpdRtCategoryIdTbl['||p_index||']: ' ||
222: ICX_CAT_UTIL_PVT.getTableElement(gUpdRtCategoryIdTbl, p_index) || ', ';
223: FND_LOG.string(p_log_level, l_module_name, l_log_string);
224:
225: l_log_string := ' gUpdCategoryNameTbl['||p_index||']: ' ||
226: ICX_CAT_UTIL_PVT.getTableElement(gUpdCategoryNameTbl, p_index) || ', ';

Line 226: ICX_CAT_UTIL_PVT.getTableElement(gUpdCategoryNameTbl, p_index) || ', ';

222: ICX_CAT_UTIL_PVT.getTableElement(gUpdRtCategoryIdTbl, p_index) || ', ';
223: FND_LOG.string(p_log_level, l_module_name, l_log_string);
224:
225: l_log_string := ' gUpdCategoryNameTbl['||p_index||']: ' ||
226: ICX_CAT_UTIL_PVT.getTableElement(gUpdCategoryNameTbl, p_index) || ', ';
227: FND_LOG.string(p_log_level, l_module_name, l_log_string);
228:
229: l_log_string := ' gUpdLanguageTbl['||p_index||']: ' ||
230: ICX_CAT_UTIL_PVT.getTableElement(gUpdLanguageTbl, p_index) || ', ';

Line 230: ICX_CAT_UTIL_PVT.getTableElement(gUpdLanguageTbl, p_index) || ', ';

226: ICX_CAT_UTIL_PVT.getTableElement(gUpdCategoryNameTbl, p_index) || ', ';
227: FND_LOG.string(p_log_level, l_module_name, l_log_string);
228:
229: l_log_string := ' gUpdLanguageTbl['||p_index||']: ' ||
230: ICX_CAT_UTIL_PVT.getTableElement(gUpdLanguageTbl, p_index) || ', ';
231: FND_LOG.string(p_log_level, l_module_name, l_log_string);
232:
233: l_log_string := ' gUpdSourceLangTbl['||p_index||']: ' ||
234: ICX_CAT_UTIL_PVT.getTableElement(gUpdSourceLangTbl, p_index) || ', ';

Line 234: ICX_CAT_UTIL_PVT.getTableElement(gUpdSourceLangTbl, p_index) || ', ';

230: ICX_CAT_UTIL_PVT.getTableElement(gUpdLanguageTbl, p_index) || ', ';
231: FND_LOG.string(p_log_level, l_module_name, l_log_string);
232:
233: l_log_string := ' gUpdSourceLangTbl['||p_index||']: ' ||
234: ICX_CAT_UTIL_PVT.getTableElement(gUpdSourceLangTbl, p_index) || ', ';
235: FND_LOG.string(p_log_level, l_module_name, l_log_string);
236: END IF;
237:
238: l_err_loc := 1100;

Line 246: ICX_CAT_UTIL_PVT.getTableElement(gDelPoCategoryIdTbl, p_index) || ', ';

242: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
243: FND_LOG.string(p_log_level, l_module_name, l_log_string);
244:
245: l_log_string := ' gDelPoCategoryIdTbl['||p_index||']: ' ||
246: ICX_CAT_UTIL_PVT.getTableElement(gDelPoCategoryIdTbl, p_index) || ', ';
247: FND_LOG.string(p_log_level, l_module_name, l_log_string);
248: END IF;
249:
250: l_err_loc := 1300;

Line 276: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,

272: gInsCategoryKeyTbl(i), 'Oracle', 2,
273: gInsLanguageTbl(i), gInsSourceLangTbl(i),
274: upper(gInsCategoryNameTbl(i)), upper(gInsCategoryKeyTbl(i)),
275: rpad('0', 300, 0),
276: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,
277: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate, ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
278: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
279:
280: l_err_loc := 200;

Line 277: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate, ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,

273: gInsLanguageTbl(i), gInsSourceLangTbl(i),
274: upper(gInsCategoryNameTbl(i)), upper(gInsCategoryKeyTbl(i)),
275: rpad('0', 300, 0),
276: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,
277: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate, ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
278: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
279:
280: l_err_loc := 200;
281: IF (gInsRtCategoryIdTbl.COUNT > 0) THEN

Line 278: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);

274: upper(gInsCategoryNameTbl(i)), upper(gInsCategoryKeyTbl(i)),
275: rpad('0', 300, 0),
276: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,
277: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate, ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
278: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
279:
280: l_err_loc := 200;
281: IF (gInsRtCategoryIdTbl.COUNT > 0) THEN
282: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 284: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

280: l_err_loc := 200;
281: IF (gInsRtCategoryIdTbl.COUNT > 0) THEN
282: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
283: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
284: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
285: 'Num. of rows inserted into categories_tl:' ||SQL%ROWCOUNT);
286: END IF;
287: END IF;
288:

Line 302: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,

298: last_update_login, last_updated_by, last_update_date,
299: created_by, creation_date, request_id,
300: program_application_id, program_id)
301: SELECT rt_category_id, key, 'Oracle', key,
302: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,
303: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate, ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
304: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id
305: FROM icx_cat_categories_tl
306: WHERE rt_category_id = gInsMapRtCategoryIdTbl(i)

Line 303: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate, ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,

299: created_by, creation_date, request_id,
300: program_application_id, program_id)
301: SELECT rt_category_id, key, 'Oracle', key,
302: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,
303: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate, ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
304: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id
305: FROM icx_cat_categories_tl
306: WHERE rt_category_id = gInsMapRtCategoryIdTbl(i)
307: AND language = gInsMapLanguageTbl(i)

Line 304: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id

300: program_application_id, program_id)
301: SELECT rt_category_id, key, 'Oracle', key,
302: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,
303: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate, ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
304: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id
305: FROM icx_cat_categories_tl
306: WHERE rt_category_id = gInsMapRtCategoryIdTbl(i)
307: AND language = gInsMapLanguageTbl(i)
308: AND NOT EXISTS (SELECT 1

Line 317: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

313: l_err_loc := 500;
314: IF (gInsMapRtCategoryIdTbl.COUNT > 0) THEN
315: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
316: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
317: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
318: 'Num. of rows inserted into category_data_sources:' ||SQL%ROWCOUNT);
319: END IF;
320: END IF;
321:

Line 330: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,

326: rt_category_id, external_source, external_source_key,
327: last_update_login, last_updated_by, last_update_date,
328: created_by, creation_date)
329: VALUES(gInsMapRtCategoryIdTbl(i), 'Oracle', gInsMapCategoryKeyTbl(i),
330: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,
331: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate);
332:
333: l_err_loc := 700;
334: IF (gInsMapRtCategoryIdTbl.COUNT > 0) THEN

Line 331: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate);

327: last_update_login, last_updated_by, last_update_date,
328: created_by, creation_date)
329: VALUES(gInsMapRtCategoryIdTbl(i), 'Oracle', gInsMapCategoryKeyTbl(i),
330: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,
331: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate);
332:
333: l_err_loc := 700;
334: IF (gInsMapRtCategoryIdTbl.COUNT > 0) THEN
335: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 337: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

333: l_err_loc := 700;
334: IF (gInsMapRtCategoryIdTbl.COUNT > 0) THEN
335: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
336: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
337: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
338: 'Num. of rows inserted into category_order_map:' ||SQL%ROWCOUNT);
339: END IF;
340: END IF;
341:

Line 349: ICX_CAT_UTIL_PVT.logUnexpectedException(

345: l_err_loc := 900;
346: EXCEPTION
347: WHEN OTHERS THEN
348: logPLSQLTableRow(l_api_name, FND_LOG.LEVEL_UNEXPECTED, SQL%ROWCOUNT+1, l_action_mode);
349: ICX_CAT_UTIL_PVT.logUnexpectedException(
350: G_PKG_NAME, l_api_name,
351: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
352: RAISE;
353: END addCategories;

Line 379: ICX_CAT_UTIL_PVT.logUnexpectedException(

375: l_err_loc := 400;
376: EXCEPTION
377: WHEN OTHERS THEN
378: logPLSQLTableRow(l_api_name, FND_LOG.LEVEL_UNEXPECTED, SQL%ROWCOUNT+1, l_action_mode);
379: ICX_CAT_UTIL_PVT.logUnexpectedException(
380: G_PKG_NAME, l_api_name,
381: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
382: RAISE;
383: END addItemCategories;

Line 413: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,

409: l_err_loc := 500;
410: UPDATE icx_cat_items_ctx_hdrs_tlp
411: SET ctx_desc = null,
412: ip_category_name = gUpdCategoryNameTbl(i),
413: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
414: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
415: last_update_date = sysdate,
416: internal_request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id,
417: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,

Line 414: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,

410: UPDATE icx_cat_items_ctx_hdrs_tlp
411: SET ctx_desc = null,
412: ip_category_name = gUpdCategoryNameTbl(i),
413: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
414: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
415: last_update_date = sysdate,
416: internal_request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id,
417: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
418: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,

Line 416: internal_request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id,

412: ip_category_name = gUpdCategoryNameTbl(i),
413: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
414: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
415: last_update_date = sysdate,
416: internal_request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id,
417: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
418: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
419: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
420: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id

Line 417: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,

413: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
414: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
415: last_update_date = sysdate,
416: internal_request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id,
417: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
418: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
419: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
420: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
421: WHERE ip_category_id = gUpdRtCategoryIdTbl(i)

Line 418: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,

414: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
415: last_update_date = sysdate,
416: internal_request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id,
417: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
418: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
419: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
420: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
421: WHERE ip_category_id = gUpdRtCategoryIdTbl(i)
422: AND language = gUpdLanguageTbl(i)

Line 419: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,

415: last_update_date = sysdate,
416: internal_request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id,
417: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
418: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
419: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
420: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
421: WHERE ip_category_id = gUpdRtCategoryIdTbl(i)
422: AND language = gUpdLanguageTbl(i)
423: AND ip_category_name <> gUpdCategoryNameTbl(i)

Line 420: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id

416: internal_request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id,
417: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
418: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
419: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
420: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
421: WHERE ip_category_id = gUpdRtCategoryIdTbl(i)
422: AND language = gUpdLanguageTbl(i)
423: AND ip_category_name <> gUpdCategoryNameTbl(i)
424: AND rownum <= ICX_CAT_UTIL_PVT.g_batch_size

Line 424: AND rownum <= ICX_CAT_UTIL_PVT.g_batch_size

420: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
421: WHERE ip_category_id = gUpdRtCategoryIdTbl(i)
422: AND language = gUpdLanguageTbl(i)
423: AND ip_category_name <> gUpdCategoryNameTbl(i)
424: AND rownum <= ICX_CAT_UTIL_PVT.g_batch_size
425: RETURNING rowid BULK COLLECT INTO l_rowid_tbl;
426:
427: l_err_loc := 600;
428: l_row_count := SQL%ROWCOUNT;

Line 432: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

428: l_row_count := SQL%ROWCOUNT;
429: IF (l_row_count = 0) THEN
430: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
431: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
432: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
433: 'No rows updated in icx_cat_ctx_hdrs_tlp for category rename');
434: END IF;
435: EXIT;
436: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN

Line 436: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN

432: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
433: 'No rows updated in icx_cat_ctx_hdrs_tlp for category rename');
434: END IF;
435: EXIT;
436: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
437: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
438: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
439: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
440: 'Num. of rows updated in icx_cat_ctx_hdrs_tlp for category rename:' ||

Line 439: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

435: EXIT;
436: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
437: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
438: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
439: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
440: 'Num. of rows updated in icx_cat_ctx_hdrs_tlp for category rename:' ||
441: l_row_count);
442: END IF;
443: l_err_loc := 700;

Line 481: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

477:
478: IF (l_rowid_tbl.COUNT > 0) THEN
479: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
480: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
481: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
482: 'Num. of rows updated in icx_cat_ctx_dtls_tlp for category rename:' ||
483: SQL%ROWCOUNT);
484: END IF;
485: END IF;

Line 491: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

487: l_err_loc := 1200;
488: -- Must log
489: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
491: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
492: 'Shopping Category attribute is not searchable, ' ||
493: 'so no changes needed in icx_cat_items_ctx_dtls_tlp; ' ||
494: 'l_searchable:' || l_searchable || ', l_section_tag:' || l_section_tag );
495: END IF;

Line 499: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

495: END IF;
496: END IF; -- IF (l_searchable = 1) THEN
497:
498: l_err_loc := 1100;
499: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
500: COMMIT;
501: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
502: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
503: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

Line 503: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

499: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
500: COMMIT;
501: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
502: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
503: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
504: 'Commit done.');
505: END IF;
506: ELSE
507: l_err_loc := 1200;

Line 510: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

506: ELSE
507: l_err_loc := 1200;
508: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
509: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
510: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
511: 'Commit not done.');
512: END IF;
513: END IF;
514: END LOOP;

Line 525: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,

521: UPDATE icx_cat_categories_tl
522: SET category_name = gUpdCategoryNameTbl(i),
523: upper_category_name = upper(gUpdCategoryNameTbl(i)),
524: source_lang = gUpdSourceLangTbl(i),
525: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
526: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
527: last_update_date = sysdate,
528: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
529: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,

Line 526: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,

522: SET category_name = gUpdCategoryNameTbl(i),
523: upper_category_name = upper(gUpdCategoryNameTbl(i)),
524: source_lang = gUpdSourceLangTbl(i),
525: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
526: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
527: last_update_date = sysdate,
528: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
529: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
530: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,

Line 528: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,

524: source_lang = gUpdSourceLangTbl(i),
525: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
526: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
527: last_update_date = sysdate,
528: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
529: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
530: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
531: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
532: WHERE rt_category_id = gUpdRtCategoryIdTbl(i)

Line 529: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,

525: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
526: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
527: last_update_date = sysdate,
528: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
529: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
530: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
531: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
532: WHERE rt_category_id = gUpdRtCategoryIdTbl(i)
533: AND language = gUpdLanguageTbl(i);

Line 530: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,

526: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
527: last_update_date = sysdate,
528: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
529: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
530: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
531: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
532: WHERE rt_category_id = gUpdRtCategoryIdTbl(i)
533: AND language = gUpdLanguageTbl(i);
534:

Line 531: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id

527: last_update_date = sysdate,
528: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
529: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
530: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
531: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
532: WHERE rt_category_id = gUpdRtCategoryIdTbl(i)
533: AND language = gUpdLanguageTbl(i);
534:
535: l_err_loc := 1500;

Line 539: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

535: l_err_loc := 1500;
536: IF (gUpdRtCategoryIdTbl.COUNT > 0) THEN
537: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
539: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
540: 'Num. of rows updated in icx_cat_categories_tl:' ||SQL%ROWCOUNT);
541: END IF;
542: END IF;
543:

Line 549: ICX_CAT_UTIL_PVT.logUnexpectedException(

545: clearTables(l_action_mode);
546: EXCEPTION
547: WHEN OTHERS THEN
548: logPLSQLTableRow(l_api_name, FND_LOG.LEVEL_UNEXPECTED, SQL%ROWCOUNT+1, l_action_mode);
549: ICX_CAT_UTIL_PVT.logUnexpectedException(
550: G_PKG_NAME, l_api_name,
551: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
552: RAISE;
553: END updateCategories;

Line 598: AND rownum <= ICX_CAT_UTIL_PVT.g_batch_size

594: -- Category deletion, in R12 we only delete the master items
595: DELETE FROM icx_cat_items_ctx_hdrs_tlp
596: WHERE po_category_id = gDelPoCategoryIdTbl(i)
597: AND source_type = 'MASTER_ITEM'
598: AND rownum <= ICX_CAT_UTIL_PVT.g_batch_size
599: RETURNING po_line_id, req_template_name, req_template_line_num,
600: inventory_item_id, org_id, language
601: BULK COLLECT INTO l_po_line_id_tbl, l_req_template_name_tbl, l_req_template_line_num_tbl,
602: l_inventory_item_id_tbl, l_org_id_tbl, l_language_tbl;

Line 606: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN

602: l_inventory_item_id_tbl, l_org_id_tbl, l_language_tbl;
603:
604: l_err_loc := 500;
605: l_row_count := SQL%ROWCOUNT;
606: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
607: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
608: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
609: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
610: 'Num. of rows deleted from icx_cat_ctx_hdrs_tlp for category delete:' ||

Line 609: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

605: l_row_count := SQL%ROWCOUNT;
606: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
607: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
608: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
609: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
610: 'Num. of rows deleted from icx_cat_ctx_hdrs_tlp for category delete:' ||
611: l_row_count);
612: END IF;
613: l_continue := FALSE;

Line 629: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

625:
626: IF (l_po_line_id_tbl.COUNT > 0) THEN
627: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
629: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
630: 'Num. of rows delete from icx_cat_ctx_dtls_tlp for category delete:' ||
631: SQL%ROWCOUNT);
632: END IF;
633: END IF;

Line 636: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

632: END IF;
633: END IF;
634:
635: l_err_loc := 700;
636: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
637: COMMIT;
638: l_err_loc := 800;
639: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
640: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 641: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

637: COMMIT;
638: l_err_loc := 800;
639: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
640: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
641: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
642: 'Commit done. after deleting items for the category');
643: END IF;
644: ELSE
645: l_err_loc := 900;

Line 648: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

644: ELSE
645: l_err_loc := 900;
646: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
648: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
649: 'Commit not done. after deleting items for the category');
650: END IF;
651: END IF;
652: END LOOP;

Line 660: ICX_CAT_UTIL_PVT.logUnexpectedException(

656: clearTables(l_action_mode);
657: EXCEPTION
658: WHEN OTHERS THEN
659: logPLSQLTableRow(l_api_name, FND_LOG.LEVEL_UNEXPECTED, SQL%ROWCOUNT+1, l_action_mode);
660: ICX_CAT_UTIL_PVT.logUnexpectedException(
661: G_PKG_NAME, l_api_name,
662: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
663: RAISE;
664: END deleteCategories;

Line 676: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

672: BEGIN
673: l_err_loc := 100;
674: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
675: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
676: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
677: 'Enter populateCategoryTables(' || p_mode ||')gTotalRowCount: ' || gTotalRowCount);
678: END IF;
679:
680: l_err_loc := 200;

Line 681: IF (p_mode = 'OUTLOOP' OR gTotalRowCount >= ICX_CAT_UTIL_PVT.g_batch_size) THEN

677: 'Enter populateCategoryTables(' || p_mode ||')gTotalRowCount: ' || gTotalRowCount);
678: END IF;
679:
680: l_err_loc := 200;
681: IF (p_mode = 'OUTLOOP' OR gTotalRowCount >= ICX_CAT_UTIL_PVT.g_batch_size) THEN
682: l_err_loc := 300;
683: gTotalRowCount := 0;
684:
685: l_err_loc := 400;

Line 691: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

687: addCategories;
688: ELSE
689: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
691: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
692: ' No category insert done.');
693: END IF;
694: END IF;
695:

Line 702: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

698: addItemCategories;
699: ELSE
700: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
701: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
702: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
703: ' addItemCategories not called.');
704: END IF;
705: END IF;
706:

Line 713: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

709: updateCategories;
710: ELSE
711: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
712: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
713: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
714: ' No category update done.');
715: END IF;
716: END IF;
717:

Line 724: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

720: deleteCategories;
721: ELSE
722: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
724: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
725: ' No category delete done.');
726: END IF;
727: END IF;
728:

Line 730: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

726: END IF;
727: END IF;
728:
729: l_err_loc := 700;
730: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
731: COMMIT;
732: l_err_loc := 800;
733: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 735: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

731: COMMIT;
732: l_err_loc := 800;
733: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
735: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
736: 'Commit done.');
737: END IF;
738: ELSE
739: l_err_loc := 900;

Line 742: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

738: ELSE
739: l_err_loc := 900;
740: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
741: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
742: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
743: 'Commit not done.');
744: END IF;
745: END IF;
746: l_err_loc := 1100;

Line 748: END IF; --(p_mode = 'OUTLOOP' OR gTotalRowCount >= ICX_CAT_UTIL_PVT.g_batch_size)

744: END IF;
745: END IF;
746: l_err_loc := 1100;
747:
748: END IF; --(p_mode = 'OUTLOOP' OR gTotalRowCount >= ICX_CAT_UTIL_PVT.g_batch_size)
749: l_err_loc := 1200;
750: EXCEPTION
751: WHEN OTHERS THEN
752: ICX_CAT_UTIL_PVT.logUnexpectedException(

Line 752: ICX_CAT_UTIL_PVT.logUnexpectedException(

748: END IF; --(p_mode = 'OUTLOOP' OR gTotalRowCount >= ICX_CAT_UTIL_PVT.g_batch_size)
749: l_err_loc := 1200;
750: EXCEPTION
751: WHEN OTHERS THEN
752: ICX_CAT_UTIL_PVT.logUnexpectedException(
753: G_PKG_NAME, l_api_name,
754: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
755: RAISE;
756: END populateCategoryTables;

Line 837: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

833: FETCH p_catg_csr BULK COLLECT INTO
834: l_mtl_category_id_tbl, l_mtl_category_name_tbl, l_mtl_language_tbl,
835: l_mtl_source_lang_tbl, l_rt_category_id_tbl, l_old_category_name_tbl,
836: l_end_date_active_tbl, l_disable_date_tbl, l_system_date_tbl
837: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
838:
839: l_err_loc := 400;
840: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 842: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

838:
839: l_err_loc := 400;
840: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
842: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
843: 'Num. of rows fetched: ' || to_char(l_mtl_category_id_tbl.COUNT));
844: END IF;
845:
846: l_err_loc := 500;

Line 874: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

870:
871: IF (NOT l_category_name_is_valid) THEN
872: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
873: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
874: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
875: 'Row, with l_mtl_category_id_tbl:' || l_mtl_category_id_tbl(i) ||
876: ', l_rt_category_id_tbl:' || l_rt_category_id_tbl(i) ||
877: ', l_mtl_category_name_tbl:' || l_mtl_category_name_tbl(i) ||
878: ', l_old_category_name_tbl:' || l_old_category_name_tbl(i) ||

Line 960: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

956: ELSE
957: l_err_loc := 2100;
958: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
959: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
960: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
961: 'Row #:' || i ||
962: ', with l_mtl_category_id_tbl:' || l_mtl_category_id_tbl(i) ||
963: ', l_rt_category_id_tbl:' || l_rt_category_id_tbl(i) ||
964: ', l_mtl_category_name_tbl:' || l_mtl_category_name_tbl(i) ||

Line 977: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

973: IF (l_prev_category_key <> l_mtl_category_id_tbl(i)) THEN
974: -- Category is not valid any more and needs to be deleted
975: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
976: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
977: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
978: 'Row #:' || i ||
979: ', with l_mtl_category_id_tbl:' || l_mtl_category_id_tbl(i) ||
980: ', l_rt_category_id_tbl:' || l_rt_category_id_tbl(i) ||
981: ', l_end_date_active_tbl:' || l_end_date_active_tbl(i) ||

Line 1002: EXIT WHEN l_mtl_category_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

998: populateCategoryTables('INLOOP');
999: END LOOP; --FOR LOOP of l_mtl_category_id_tbl
1000:
1001: l_err_loc := 2400;
1002: EXIT WHEN l_mtl_category_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1003: END LOOP; --Cursor loop
1004:
1005: l_err_loc := 2500;
1006: populateCategoryTables('OUTLOOP');

Line 1011: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1007:
1008: l_err_loc := 2600;
1009: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1011: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1012: ' done; '||
1013: 'Total num. of batches processed:' ||l_batch_count ||
1014: ', Total num. of rows processed:' ||l_row_count);
1015: END IF;

Line 1018: ICX_CAT_UTIL_PVT.logUnexpectedException(

1014: ', Total num. of rows processed:' ||l_row_count);
1015: END IF;
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: ICX_CAT_UTIL_PVT.logUnexpectedException(
1019: G_PKG_NAME, l_api_name,
1020: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1021: RAISE;
1022: END processCategory;

Line 1035: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1031: BEGIN
1032: l_err_loc := 100;
1033: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1034: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1035: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1036: 'Processing cursor:' || l_api_name ||
1037: '; p_category_id:' || p_category_id ||
1038: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);
1039: END IF;

Line 1038: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);

1034: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1035: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1036: 'Processing cursor:' || l_api_name ||
1037: '; p_category_id:' || p_category_id ||
1038: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);
1039: END IF;
1040:
1041: l_err_loc := 200;
1042: --First close the cursor

Line 1061: AND mck.structure_id = ICX_CAT_UTIL_PVT.g_structure_id

1057: mtl_categories_tl mctl,
1058: icx_cat_categories_tl icat,
1059: icx_cat_categories_tl icat2
1060: WHERE mck.category_id = P_CATEGORY_ID
1061: AND mck.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
1062: AND mctl.category_id = mck.category_id
1063: AND mctl.language IN (SELECT language_code FROM fnd_languages WHERE installed_flag IN ('B', 'I'))
1064: AND to_char(mctl.category_id) = icat.key (+)
1065: AND to_char(mctl.category_id) = icat2.key (+)

Line 1077: ICX_CAT_UTIL_PVT.logUnexpectedException(

1073: CLOSE l_catg_csr;
1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: ICX_CAT_UTIL_PVT.logUnexpectedException(
1078: G_PKG_NAME, l_api_name,
1079: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1080: RAISE;
1081: END openCategoryCursor;

Line 1094: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1090: BEGIN
1091: l_err_loc := 100;
1092: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1093: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1094: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1095: 'Processing cursor:' || l_api_name ||
1096: '; p_category_id:' || p_category_id ||
1097: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
1098: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id);

Line 1097: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||

1093: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1094: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1095: 'Processing cursor:' || l_api_name ||
1096: '; p_category_id:' || p_category_id ||
1097: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
1098: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id);
1099: END IF;
1100:
1101: l_err_loc := 150;

Line 1098: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id);

1094: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1095: 'Processing cursor:' || l_api_name ||
1096: '; p_category_id:' || p_category_id ||
1097: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
1098: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id);
1099: END IF;
1100:
1101: l_err_loc := 150;
1102: --First close the cursor

Line 1122: AND mck.structure_id = ICX_CAT_UTIL_PVT.g_structure_id

1118: mtl_category_set_valid_cats mcsvc,
1119: icx_cat_categories_tl icat,
1120: icx_cat_categories_tl icat2
1121: WHERE mck.category_id = P_CATEGORY_ID
1122: AND mck.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
1123: AND mctl.category_id = mck.category_id
1124: AND mctl.language IN (SELECT language_code FROM fnd_languages WHERE installed_flag IN ('B', 'I'))
1125: AND to_char(mctl.category_id) = icat.key (+)
1126: AND to_char(mctl.category_id) = icat2.key (+)

Line 1128: AND mcsvc.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

1124: AND mctl.language IN (SELECT language_code FROM fnd_languages WHERE installed_flag IN ('B', 'I'))
1125: AND to_char(mctl.category_id) = icat.key (+)
1126: AND to_char(mctl.category_id) = icat2.key (+)
1127: AND mctl.language = icat2.language (+)
1128: AND mcsvc.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
1129: AND mcsvc.category_id = mck.category_id
1130: ORDER BY 1;
1131:
1132: l_err_loc := 400;

Line 1140: ICX_CAT_UTIL_PVT.logUnexpectedException(

1136: CLOSE l_catg_csr;
1137:
1138: EXCEPTION
1139: WHEN OTHERS THEN
1140: ICX_CAT_UTIL_PVT.logUnexpectedException(
1141: G_PKG_NAME, l_api_name,
1142: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1143: RAISE;
1144: END openValidCategorySetCursor;

Line 1155: ICX_CAT_UTIL_PVT.setBatchSize;

1151: l_api_name CONSTANT VARCHAR2(30) := 'populateCategoryChange';
1152: l_err_loc PLS_INTEGER;
1153: BEGIN
1154: l_err_loc := 100;
1155: ICX_CAT_UTIL_PVT.setBatchSize;
1156:
1157: l_err_loc := 300;
1158: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1159:

Line 1158: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1154: l_err_loc := 100;
1155: ICX_CAT_UTIL_PVT.setBatchSize;
1156:
1157: l_err_loc := 300;
1158: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1159:
1160: l_err_loc := 400;
1161: setAutoCreateShopCatg;
1162:

Line 1169: IF (ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN

1165: -- 1. Category may have just been created, so no item assignment is done so far.
1166: -- 2. If the category is updated, even if the category was not present in iProcurement
1167: -- we donot create mapping for the category, so items cannot be processed.
1168:
1169: IF (ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
1170: l_err_loc := 500;
1171: openCategoryCursor(P_CATEGORY_ID);
1172: ELSE
1173: l_err_loc := 600;

Line 1178: ICX_CAT_UTIL_PVT.logUnexpectedException(

1174: openValidCategorySetCursor(P_CATEGORY_ID);
1175: END IF;
1176: EXCEPTION
1177: WHEN OTHERS THEN
1178: ICX_CAT_UTIL_PVT.logUnexpectedException(
1179: G_PKG_NAME, l_api_name,
1180: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1181: RAISE;
1182: END populateCategoryChange;

Line 1192: ICX_CAT_UTIL_PVT.setBatchSize;

1188: l_api_name CONSTANT VARCHAR2(30) := 'populateValidCategorySetInsert';
1189: l_err_loc PLS_INTEGER;
1190: BEGIN
1191: l_err_loc := 100;
1192: ICX_CAT_UTIL_PVT.setBatchSize;
1193:
1194: l_err_loc := 300;
1195: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1196:

Line 1195: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1191: l_err_loc := 100;
1192: ICX_CAT_UTIL_PVT.setBatchSize;
1193:
1194: l_err_loc := 300;
1195: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1196:
1197: l_err_loc := 400;
1198: setAutoCreateShopCatg;
1199:

Line 1206: ICX_CAT_UTIL_PVT.logUnexpectedException(

1202:
1203: l_err_loc := 700;
1204: EXCEPTION
1205: WHEN OTHERS THEN
1206: ICX_CAT_UTIL_PVT.logUnexpectedException(
1207: G_PKG_NAME, l_api_name,
1208: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1209: RAISE;
1210: END populateValidCategorySetInsert;

Line 1221: ICX_CAT_UTIL_PVT.setBatchSize;

1217: l_api_name CONSTANT VARCHAR2(30) := 'populateValidCategorySetUpdate';
1218: l_err_loc PLS_INTEGER;
1219: BEGIN
1220: l_err_loc := 100;
1221: ICX_CAT_UTIL_PVT.setBatchSize;
1222:
1223: l_err_loc := 300;
1224: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1225:

Line 1224: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1220: l_err_loc := 100;
1221: ICX_CAT_UTIL_PVT.setBatchSize;
1222:
1223: l_err_loc := 300;
1224: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1225:
1226: l_err_loc := 400;
1227: setAutoCreateShopCatg;
1228:

Line 1245: ICX_CAT_UTIL_PVT.logUnexpectedException(

1241:
1242: l_err_loc := 800;
1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: ICX_CAT_UTIL_PVT.logUnexpectedException(
1246: G_PKG_NAME, l_api_name,
1247: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1248: RAISE;
1249: END populateValidCategorySetUpdate;

Line 1260: ICX_CAT_UTIL_PVT.setBatchSize;

1256: l_err_loc PLS_INTEGER;
1257: l_index PLS_INTEGER;
1258: BEGIN
1259: l_err_loc := 100;
1260: ICX_CAT_UTIL_PVT.setBatchSize;
1261:
1262: l_err_loc := 200;
1263: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1264:

Line 1263: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1259: l_err_loc := 100;
1260: ICX_CAT_UTIL_PVT.setBatchSize;
1261:
1262: l_err_loc := 200;
1263: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1264:
1265: l_err_loc := 300;
1266: gDelPoCategoryIdTbl.DELETE;
1267:

Line 1278: ICX_CAT_UTIL_PVT.logUnexpectedException(

1274:
1275: l_err_loc := 600;
1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: ICX_CAT_UTIL_PVT.logUnexpectedException(
1279: G_PKG_NAME, l_api_name,
1280: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1281: RAISE;
1282: END populateValidCategorySetDelete;

Line 1299: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1295:
1296: l_err_loc := 300;
1297: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1298: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1299: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1300: 'Auto create shop category set to:' || g_auto_create_shop_catg);
1301: END IF;
1302: EXCEPTION
1303: WHEN OTHERS THEN

Line 1304: ICX_CAT_UTIL_PVT.logUnexpectedException(

1300: 'Auto create shop category set to:' || g_auto_create_shop_catg);
1301: END IF;
1302: EXCEPTION
1303: WHEN OTHERS THEN
1304: ICX_CAT_UTIL_PVT.logUnexpectedException(
1305: G_PKG_NAME, l_api_name,
1306: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1307: g_auto_create_shop_catg := 'N';
1308: END setAutoCreateShopCatg;