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 ICX_CAT_UTIL_PVT

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

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 );
32: END IF;

Line 35: ICX_CAT_UTIL_PVT.logUnexpectedException(

31: ', p_section_tag:' || p_section_tag );
32: END IF;
33: EXCEPTION
34: WHEN OTHERS THEN
35: ICX_CAT_UTIL_PVT.logUnexpectedException(
36: G_PKG_NAME, l_api_name,
37: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
38: p_searchable := 0;
39: p_section_tag:= -1;

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

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 );
46: END IF;

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

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:
89: OPEN getSearchableMetadataCsr(p_category_id);

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

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 ||
151: ', p_category_id:' || p_category_id);

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

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 ||
167: ', length:' || l_metadata_rec.attribute_length ||

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

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 ||
180: ', length:' || l_metadata_rec.attribute_length ||

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

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
194: WHEN OTHERS THEN

Line 195: ICX_CAT_UTIL_PVT.logUnexpectedException(

191: 'done.');
192: END IF;
193: EXCEPTION
194: WHEN OTHERS THEN
195: ICX_CAT_UTIL_PVT.logUnexpectedException(
196: G_PKG_NAME, l_api_name,
197: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
198: RAISE;
199: END buildMetadataInfo;

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

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 );
230: END IF;

Line 233: ICX_CAT_UTIL_PVT.logUnexpectedException(

229: ', p_metadata_rec.section_tag:' || p_metadata_rec.section_tag );
230: END IF;
231: EXCEPTION
232: WHEN OTHERS THEN
233: ICX_CAT_UTIL_PVT.logUnexpectedException(
234: G_PKG_NAME, l_api_name,
235: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
236: RAISE;
237: END getAttributeDetails;

Line 242: ICX_CAT_UTIL_PVT.g_PODoc_const VARCHAR2(15) := 'PO_DOCUMENTS';

238:
239: /*
240: Values of p_doc_source:
241:
242: ICX_CAT_UTIL_PVT.g_PODoc_const VARCHAR2(15) := 'PO_DOCUMENTS';
243: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const VARCHAR2(15) := 'ReqTemplate';
244: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';
245: Values of p_where_clause:
246: ROWID / NOTROWID

Line 243: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const VARCHAR2(15) := 'ReqTemplate';

239: /*
240: Values of p_doc_source:
241:
242: ICX_CAT_UTIL_PVT.g_PODoc_const VARCHAR2(15) := 'PO_DOCUMENTS';
243: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const VARCHAR2(15) := 'ReqTemplate';
244: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';
245: Values of p_where_clause:
246: ROWID / NOTROWID
247: p_where_clause = NOTROWID; when we are dealing with only one source i.e. BLANKETS, GBPAs, Quotes,

Line 244: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';

240: Values of p_doc_source:
241:
242: ICX_CAT_UTIL_PVT.g_PODoc_const VARCHAR2(15) := 'PO_DOCUMENTS';
243: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const VARCHAR2(15) := 'ReqTemplate';
244: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';
245: Values of p_where_clause:
246: ROWID / NOTROWID
247: p_where_clause = NOTROWID; when we are dealing with only one source i.e. BLANKETS, GBPAs, Quotes,
248: ReqTemplates and Master Items

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

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 ||
288: ', p_special_metadata_tbl.COUNT:' || p_special_metadata_tbl.COUNT ||

Line 386: IF (p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) THEN

382: l_special_ctx_sql_index := l_special_ctx_sql_index + 1;
383: p_special_ctx_sql_tbl(l_special_ctx_sql_index) := l_ctx_sql_rec;
384:
385: l_err_loc := 1000;
386: IF (p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) THEN
387: l_err_loc := 1100;
388: l_searchable := NULL;
389: l_metadata_rec := NULL;
390: getAttributeDetails(p_special_metadata_tbl, 'SUPPLIER', l_searchable, l_metadata_rec);

Line 418: IF ( ICX_CAT_UTIL_PVT.g_mi_concat_seg_clause IS NULL) THEN

414: l_metadata_rec := NULL;
415: getAttributeDetails(p_special_metadata_tbl, 'INTERNAL_ITEM_NUM', l_searchable, l_metadata_rec);
416: IF (l_searchable = 'Y') THEN
417: l_err_loc := 1500;
418: IF ( ICX_CAT_UTIL_PVT.g_mi_concat_seg_clause IS NULL) THEN
419: ICX_CAT_UTIL_PVT.getMIConcatSegmentClause;
420: END IF;
421: l_ctxsql_string := l_ctxfspsql_prefixStr;
422: l_ctxsql_string := l_ctxsql_string ||

Line 419: ICX_CAT_UTIL_PVT.getMIConcatSegmentClause;

415: getAttributeDetails(p_special_metadata_tbl, 'INTERNAL_ITEM_NUM', l_searchable, l_metadata_rec);
416: IF (l_searchable = 'Y') THEN
417: l_err_loc := 1500;
418: IF ( ICX_CAT_UTIL_PVT.g_mi_concat_seg_clause IS NULL) THEN
419: ICX_CAT_UTIL_PVT.getMIConcatSegmentClause;
420: END IF;
421: l_ctxsql_string := l_ctxfspsql_prefixStr;
422: l_ctxsql_string := l_ctxsql_string ||
423: ' || ''<' || to_char(l_metadata_rec.section_tag) || '>'' ||

Line 424: ' || 'replace(replace(' || ICX_CAT_UTIL_PVT.g_mi_concat_seg_clause || ',' || '''<''' || ',' || ''' ''' || ')' || ',' || '''>''' || ',' || ''' ''' || ')' ||

420: END IF;
421: l_ctxsql_string := l_ctxfspsql_prefixStr;
422: l_ctxsql_string := l_ctxsql_string ||
423: ' || ''<' || to_char(l_metadata_rec.section_tag) || '>'' ||
424: ' || 'replace(replace(' || ICX_CAT_UTIL_PVT.g_mi_concat_seg_clause || ',' || '''<''' || ',' || ''' ''' || ')' || ',' || '''>''' || ',' || ''' ''' || ')' ||
425: ' || ''''';
426: l_ctxsql_string := l_ctxsql_string ||
427: ' FROM (SELECT hdrs.inventory_item_id, hdrs.po_line_id, hdrs.req_template_name, ' ||
428: ' hdrs.req_template_line_num, hdrs.org_id, hdrs.language, ' ||

Line 449: IF (p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) THEN

445: p_special_ctx_sql_tbl(l_special_ctx_sql_index) := l_ctx_sql_rec;
446: END IF;
447:
448: l_err_loc := 1700;
449: IF (p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) THEN
450: l_err_loc := 1800;
451: l_searchable := NULL;
452: l_metadata_rec := NULL;
453: getAttributeDetails(p_special_metadata_tbl, 'SOURCE', l_searchable, l_metadata_rec);

Line 457: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN

453: getAttributeDetails(p_special_metadata_tbl, 'SOURCE', l_searchable, l_metadata_rec);
454: IF (l_searchable = 'Y') THEN
455: l_err_loc := 1900;
456: l_ctxsql_string := l_ctxsql_prefixStr;
457: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
458: l_err_loc := 2000;
459: l_ctxsql_string := l_ctxsql_string ||
460: ' || ''<' || to_char(l_metadata_rec.section_tag) || '>'' ||
461: ' || 'replace(replace(ph.segment1, ''<'', '' ''), ''>'', '' '')' ||

Line 469: ELSIF (p_doc_source = ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const) THEN

465: ' WHERE hdrs.po_line_id = pl.po_line_id ' ||
466: ' AND hdrs.org_id = pl.org_id ' ||
467: ' AND pl.po_header_id = ph.po_header_id ' ||
468: ' AND ' || l_ctxsql_suffixStr;
469: ELSIF (p_doc_source = ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const) THEN
470: l_err_loc := 2100;
471: l_ctxsql_string := l_ctxsql_string ||
472: ' || ''<' || to_char(l_metadata_rec.section_tag) || '>'' ||
473: ' || 'replace(replace(hdrs.req_template_name, ''<'', '' ''), ''>'', '' '')' ||

Line 493: IF (p_doc_source IN (ICX_CAT_UTIL_PVT.g_PODoc_const,

489: END IF;
490: END IF;
491:
492: l_err_loc := 2400;
493: IF (p_doc_source IN (ICX_CAT_UTIL_PVT.g_PODoc_const,
494: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const))
495: THEN
496: l_err_loc := 2500;
497: l_searchable := NULL;

Line 494: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const))

490: END IF;
491:
492: l_err_loc := 2400;
493: IF (p_doc_source IN (ICX_CAT_UTIL_PVT.g_PODoc_const,
494: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const))
495: THEN
496: l_err_loc := 2500;
497: l_searchable := NULL;
498: l_metadata_rec := NULL;

Line 507: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN

503: l_ctxsql_string := l_ctxsql_string ||
504: ' || ''<' || to_char(l_metadata_rec.section_tag) || '>'' ||
505: ' || 'replace(replace(pl.item_revision,' || '''<''' || ',' || ''' ''' || ')' || ',' || '''>''' || ',' || ''' ''' || ')' ||
506: ' || ''''';
507: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
508: l_err_loc := 2700;
509: l_ctxsql_string := l_ctxsql_string ||
510: ' FROM icx_cat_items_ctx_hdrs_tlp hdrs, po_headers_all ph, po_lines_all pl ' ||
511: ' WHERE hdrs.po_line_id = pl.po_line_id ' ||

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

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:
573: l_err_loc := 3600;

Line 582: IF (p_doc_source IS NULL OR p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) THEN*/

578: -- For category attributes, the ctx sqls are only created for all sources except Master Items.
579: -- While online populate of master items, we donot call the buildCtxSQl for category attributes
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),

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

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:
590: -- Loop thru the regular non-tl metadata table and form the sqls

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

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)
692: -- Only need to populate description if it is searchable.

Line 691: -- i.e. (p_doc_source = ICX_CAT_UTIL_PVT.g_MasterItemCsr_const)

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)
692: -- Only need to populate description if it is searchable.
693: -- Other attributes are not available for master items
694: IF (p_category_id = 0) THEN
695: l_err_loc := 5000;

Line 732: --bug 6599217 : if clause commented END IF; -- IF (p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const)*/

728: l_ctxsql_string := l_ctxsql_prefixStr;
729: l_current_length := 0;
730: END IF;
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

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

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) );
743: END LOOP;

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

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) );
752: END LOOP;

Line 757: ICX_CAT_UTIL_PVT.logUnexpectedException(

753: END IF;
754:
755: EXCEPTION
756: WHEN OTHERS THEN
757: ICX_CAT_UTIL_PVT.logUnexpectedException(
758: G_PKG_NAME, l_api_name,
759: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
760: RAISE;
761: END;