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_BUILD_CTX_SQL_PVT dependencies on FND_LOG

Line 26: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

22: WHERE key = p_attribute_key
23: AND rownum = 1;
24:
25: l_err_loc := 200;
26: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
27: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
28: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
29: 'For p_attribute_key:' || p_attribute_key ||
30: ', p_searchable:' || p_searchable ||

Line 27: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

23: AND rownum = 1;
24:
25: l_err_loc := 200;
26: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
27: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
28: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
29: 'For p_attribute_key:' || p_attribute_key ||
30: ', p_searchable:' || p_searchable ||
31: ', p_section_tag:' || p_section_tag );

Line 40: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

36: G_PKG_NAME, l_api_name,
37: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
38: p_searchable := 0;
39: p_section_tag:= -1;
40: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
41: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
42: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
43: 'Exception caught, So for p_attribute_key:' || p_attribute_key ||
44: ', p_searchable:' || p_searchable ||

Line 41: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

37: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
38: p_searchable := 0;
39: p_section_tag:= -1;
40: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
41: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
42: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
43: 'Exception caught, So for p_attribute_key:' || p_attribute_key ||
44: ', p_searchable:' || p_searchable ||
45: ', p_section_tag:' || p_section_tag );

Line 83: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

79: l_category_index NUMBER := 0;
80: l_metadata_rec g_metadata_rec_type;
81: BEGIN
82: l_err_loc := 100;
83: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
84: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
85: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
86: ', p_category_id:' || p_category_id);
87: END IF;

Line 84: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

80: l_metadata_rec g_metadata_rec_type;
81: BEGIN
82: l_err_loc := 100;
83: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
84: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
85: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
86: ', p_category_id:' || p_category_id);
87: END IF;
88:

Line 145: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

141: THEN
142: l_err_loc := 1300;
143: l_special_index := l_special_index + 1;
144: p_special_metadata_tbl(l_special_index) := l_metadata_rec;
145: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
146: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
147: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
148: 'specialIndex:' || l_special_index ||
149: ', key:' || l_metadata_rec.key ||

Line 146: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

142: l_err_loc := 1300;
143: l_special_index := l_special_index + 1;
144: p_special_metadata_tbl(l_special_index) := l_metadata_rec;
145: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
146: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
147: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
148: 'specialIndex:' || l_special_index ||
149: ', key:' || l_metadata_rec.key ||
150: ', type:' || l_metadata_rec.type ||

Line 161: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

157: IF (l_type_tbl(i) <> 2) THEN
158: l_err_loc := 1500;
159: l_regular_nontl_index := l_regular_nontl_index + 1;
160: p_regular_nontl_metadata_tbl(l_regular_nontl_index) := l_metadata_rec;
161: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
162: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
163: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
164: 'l_regular_nontl_index:' || l_regular_nontl_index ||
165: ', key:' || l_metadata_rec.key ||

Line 162: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

158: l_err_loc := 1500;
159: l_regular_nontl_index := l_regular_nontl_index + 1;
160: p_regular_nontl_metadata_tbl(l_regular_nontl_index) := l_metadata_rec;
161: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
162: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
163: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
164: 'l_regular_nontl_index:' || l_regular_nontl_index ||
165: ', key:' || l_metadata_rec.key ||
166: ', type:' || l_metadata_rec.type ||

Line 174: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

170: ELSE
171: l_err_loc := 1600;
172: l_regular_tl_index := l_regular_tl_index + 1;
173: p_regular_tl_metadata_tbl(l_regular_tl_index) := l_metadata_rec;
174: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
176: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
177: 'l_regular_tl_index:' || l_regular_tl_index ||
178: ', key:' || l_metadata_rec.key ||

Line 175: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

171: l_err_loc := 1600;
172: l_regular_tl_index := l_regular_tl_index + 1;
173: p_regular_tl_metadata_tbl(l_regular_tl_index) := l_metadata_rec;
174: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
176: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
177: 'l_regular_tl_index:' || l_regular_tl_index ||
178: ', key:' || l_metadata_rec.key ||
179: ', type:' || l_metadata_rec.type ||

Line 188: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

184: END IF;
185: END LOOP;
186:
187: l_err_loc := 1700;
188: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
190: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
191: 'done.');
192: END IF;

Line 189: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

185: END LOOP;
186:
187: l_err_loc := 1700;
188: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
190: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
191: 'done.');
192: END IF;
193: EXCEPTION

Line 224: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

220: END IF;
221: END LOOP;
222:
223: l_err_loc := 400;
224: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
225: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
226: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
227: 'For p_attribute_key:' || p_attribute_key ||
228: ', p_attribute_searchable:' || p_attribute_searchable ||

Line 225: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

221: END LOOP;
222:
223: l_err_loc := 400;
224: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
225: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
226: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
227: 'For p_attribute_key:' || p_attribute_key ||
228: ', p_attribute_searchable:' || p_attribute_searchable ||
229: ', p_metadata_rec.section_tag:' || p_metadata_rec.section_tag );

Line 282: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

278: l_ctx_sql_next_sequence NUMBER := 0;
279: l_current_length NUMBER := 0;
280: BEGIN
281: l_err_loc := 100;
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: ' In parameters; categoryId:' || p_category_id ||
286: ', p_doc_source:' || p_doc_source ||

Line 283: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

279: l_current_length NUMBER := 0;
280: BEGIN
281: l_err_loc := 100;
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: ' In parameters; categoryId:' || p_category_id ||
286: ', p_doc_source:' || p_doc_source ||
287: ', p_where_clause:' || p_where_clause ||

Line 567: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

563: l_err_loc := 3500;
564: l_ctx_sql_next_sequence := g_seqStartRegularCatgRow;
565: END IF;
566:
567: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
568: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
569: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
570: 'l_ctx_sql_next_sequence:' ||l_ctx_sql_next_sequence);
571: END IF;

Line 568: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

564: l_ctx_sql_next_sequence := g_seqStartRegularCatgRow;
565: END IF;
566:
567: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
568: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
569: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
570: 'l_ctx_sql_next_sequence:' ||l_ctx_sql_next_sequence);
571: END IF;
572:

Line 584: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

580: -- For all other sources, to build ctx sqls for category attributes, the p_doc_source is passed as null.
581: /*BUG 6599217: commented the if clause to by pass the check on master item cursor constant
582: IF (p_doc_source IS NULL OR p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) THEN*/
583:
584: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
586: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
587: 'For mi also :not done earlier' );
588: END IF;

Line 585: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

581: /*BUG 6599217: commented the if clause to by pass the check on master item cursor constant
582: IF (p_doc_source IS NULL OR p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) THEN*/
583:
584: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
586: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
587: 'For mi also :not done earlier' );
588: END IF;
589:

Line 686: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

682: END IF;
683: END LOOP; -- p_regular_tl_metadata_tbl.COUNT
684: /* ELSE Bug 6599217 : commented if clauseand hence the else block
685: l_err_loc := 4900;
686: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
688: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
689: 'continue for MI case ' );
690: END IF;

Line 687: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

683: END LOOP; -- p_regular_tl_metadata_tbl.COUNT
684: /* ELSE Bug 6599217 : commented if clauseand hence the else block
685: l_err_loc := 4900;
686: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
688: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
689: 'continue for MI case ' );
690: END IF;
691: -- i.e. (p_doc_source = ICX_CAT_UTIL_PVT.g_MasterItemCsr_const)

Line 735: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

731: END IF;
732: --bug 6599217 : if clause commented END IF; -- IF (p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const)*/
733: l_err_loc := 5300;
734:
735: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
736: FOR i IN 1..p_special_ctx_sql_tbl.COUNT LOOP
737: l_ctx_sql_rec := p_special_ctx_sql_tbl(i);
738: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
739: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

Line 738: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

734:
735: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
736: FOR i IN 1..p_special_ctx_sql_tbl.COUNT LOOP
737: l_ctx_sql_rec := p_special_ctx_sql_tbl(i);
738: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
739: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
740: 'Special ctx SQLs..Value at i:' || i ||
741: ', sequence:' || l_ctx_sql_rec.bind_sequence ||
742: ', sql_string:' || substr(l_ctx_sql_rec.ctx_sql_string, 1, 3600) );

Line 747: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

743: END LOOP;
744:
745: FOR i IN 1..p_regular_ctx_sql_tbl.COUNT LOOP
746: l_ctx_sql_rec := p_regular_ctx_sql_tbl(i);
747: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
748: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
749: 'Regular ctx SQLs..Value at i:' || i ||
750: ', sequence:' || l_ctx_sql_rec.bind_sequence ||
751: ', sql_string:' || substr(l_ctx_sql_rec.ctx_sql_string, 1, 3600) );