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_POR_CTX_DESC dependencies on ICX_POR_EXT_UTL

Line 64: icx_por_ext_utl.debug('about to update icx_cat_items_tlp.ctx_desc');

60:
61: xErrLoc := 720;
62:
63: --Debugging
64: icx_por_ext_utl.debug('about to update icx_cat_items_tlp.ctx_desc');
65: xErrLoc := 730;
66: LOOP
67: FETCH items_tl_csr BULK COLLECT INTO
68: vRowids

Line 90: icx_por_ext_utl.debug('done updating icx_cat_items_tlp.ctx_desc');

86:
87: END LOOP;
88: xErrLoc := 910;
89: --Debugging
90: icx_por_ext_utl.debug('done updating icx_cat_items_tlp.ctx_desc');
91: xErrLoc := 920;
92:
93: CLOSE items_tl_csr;
94:

Line 97: icx_por_ext_utl.debug('start to rebuild index');

93: CLOSE items_tl_csr;
94:
95: xErrLoc := 930;
96: --Debugging
97: icx_por_ext_utl.debug('start to rebuild index');
98: xErrLoc := 940;
99: -- rebuild the intermedia or context indexes
100: ICX_POR_INTERMEDIA_INDEX.rebuild_index;
101: xErrLoc := 1000;

Line 103: icx_por_ext_utl.debug('rebuild index done');

99: -- rebuild the intermedia or context indexes
100: ICX_POR_INTERMEDIA_INDEX.rebuild_index;
101: xErrLoc := 1000;
102: --Debugging
103: icx_por_ext_utl.debug('rebuild index done');
104: END IF;
105: xErrLoc := 1010;
106:
107: EXCEPTION

Line 109: icx_por_ext_utl.debug(icx_por_ext_utl.DEBUG_LEVEL,

105: xErrLoc := 1010;
106:
107: EXCEPTION
108: WHEN OTHERS THEN
109: icx_por_ext_utl.debug(icx_por_ext_utl.DEBUG_LEVEL,
110: 'Exception at ICX_POR_CTX_DESC.populateCtxDescAll('||
111: xErrLoc || '), ' || SQLERRM);
112: rollback;
113: ICX_POR_EXT_UTL.printStackTrace;

Line 113: ICX_POR_EXT_UTL.printStackTrace;

109: icx_por_ext_utl.debug(icx_por_ext_utl.DEBUG_LEVEL,
110: 'Exception at ICX_POR_CTX_DESC.populateCtxDescAll('||
111: xErrLoc || '), ' || SQLERRM);
112: rollback;
113: ICX_POR_EXT_UTL.printStackTrace;
114: ICX_POR_EXT_UTL.closeLog;
115:
116: IF items_tl_cv%ISOPEN THEN
117: CLOSE items_tl_cv;

Line 114: ICX_POR_EXT_UTL.closeLog;

110: 'Exception at ICX_POR_CTX_DESC.populateCtxDescAll('||
111: xErrLoc || '), ' || SQLERRM);
112: rollback;
113: ICX_POR_EXT_UTL.printStackTrace;
114: ICX_POR_EXT_UTL.closeLog;
115:
116: IF items_tl_cv%ISOPEN THEN
117: CLOSE items_tl_cv;
118: END IF;

Line 136: --Debugging added icx_por_ext_utl.debug

132: PROCEDURE populateDescAll(p_log_type in VARCHAR2 DEFAULT 'CONCURRENT')
133: IS
134: v_sql varchar2(255);
135: BEGIN
136: --Debugging added icx_por_ext_utl.debug
137: v_sql := 'truncate table '|| ICX_POR_EXT_UTL.getIcxSchema ||'.icx_cat_items_ctx_tlp';
138: icx_por_ext_utl.debug('populateDescAll, about to truncate icx_cat_items_ctx_tlp');
139: EXECUTE IMMEDIATE v_sql;
140: icx_por_ext_utl.debug('populateDescAll, icx_cat_items_ctx_tlp truncated ');

Line 137: v_sql := 'truncate table '|| ICX_POR_EXT_UTL.getIcxSchema ||'.icx_cat_items_ctx_tlp';

133: IS
134: v_sql varchar2(255);
135: BEGIN
136: --Debugging added icx_por_ext_utl.debug
137: v_sql := 'truncate table '|| ICX_POR_EXT_UTL.getIcxSchema ||'.icx_cat_items_ctx_tlp';
138: icx_por_ext_utl.debug('populateDescAll, about to truncate icx_cat_items_ctx_tlp');
139: EXECUTE IMMEDIATE v_sql;
140: icx_por_ext_utl.debug('populateDescAll, icx_cat_items_ctx_tlp truncated ');
141:

Line 138: icx_por_ext_utl.debug('populateDescAll, about to truncate icx_cat_items_ctx_tlp');

134: v_sql varchar2(255);
135: BEGIN
136: --Debugging added icx_por_ext_utl.debug
137: v_sql := 'truncate table '|| ICX_POR_EXT_UTL.getIcxSchema ||'.icx_cat_items_ctx_tlp';
138: icx_por_ext_utl.debug('populateDescAll, about to truncate icx_cat_items_ctx_tlp');
139: EXECUTE IMMEDIATE v_sql;
140: icx_por_ext_utl.debug('populateDescAll, icx_cat_items_ctx_tlp truncated ');
141:
142: ICX_POR_INTERMEDIA_INDEX.drop_index;

Line 140: icx_por_ext_utl.debug('populateDescAll, icx_cat_items_ctx_tlp truncated ');

136: --Debugging added icx_por_ext_utl.debug
137: v_sql := 'truncate table '|| ICX_POR_EXT_UTL.getIcxSchema ||'.icx_cat_items_ctx_tlp';
138: icx_por_ext_utl.debug('populateDescAll, about to truncate icx_cat_items_ctx_tlp');
139: EXECUTE IMMEDIATE v_sql;
140: icx_por_ext_utl.debug('populateDescAll, icx_cat_items_ctx_tlp truncated ');
141:
142: ICX_POR_INTERMEDIA_INDEX.drop_index;
143: icx_por_ext_utl.debug('populateDescAll, drop_index done ');
144:

Line 143: icx_por_ext_utl.debug('populateDescAll, drop_index done ');

139: EXECUTE IMMEDIATE v_sql;
140: icx_por_ext_utl.debug('populateDescAll, icx_cat_items_ctx_tlp truncated ');
141:
142: ICX_POR_INTERMEDIA_INDEX.drop_index;
143: icx_por_ext_utl.debug('populateDescAll, drop_index done ');
144:
145: populateBaseAttributes('N', 'N', p_log_type);
146: icx_por_ext_utl.debug('populateDescAll, populateBaseAttributes done ');
147:

Line 146: icx_por_ext_utl.debug('populateDescAll, populateBaseAttributes done ');

142: ICX_POR_INTERMEDIA_INDEX.drop_index;
143: icx_por_ext_utl.debug('populateDescAll, drop_index done ');
144:
145: populateBaseAttributes('N', 'N', p_log_type);
146: icx_por_ext_utl.debug('populateDescAll, populateBaseAttributes done ');
147:
148: populateBuyerInfo('N','N', p_log_type);
149: icx_por_ext_utl.debug('populateDescAll, populateBuyerInfo done ');
150:

Line 149: icx_por_ext_utl.debug('populateDescAll, populateBuyerInfo done ');

145: populateBaseAttributes('N', 'N', p_log_type);
146: icx_por_ext_utl.debug('populateDescAll, populateBaseAttributes done ');
147:
148: populateBuyerInfo('N','N', p_log_type);
149: icx_por_ext_utl.debug('populateDescAll, populateBuyerInfo done ');
150:
151: populateCategoryAttributes('N', 'N', p_log_type);
152: icx_por_ext_utl.debug('populateDescAll, populateCategoryAttributes done ');
153:

Line 152: icx_por_ext_utl.debug('populateDescAll, populateCategoryAttributes done ');

148: populateBuyerInfo('N','N', p_log_type);
149: icx_por_ext_utl.debug('populateDescAll, populateBuyerInfo done ');
150:
151: populateCategoryAttributes('N', 'N', p_log_type);
152: icx_por_ext_utl.debug('populateDescAll, populateCategoryAttributes done ');
153:
154: ICX_POR_INTERMEDIA_INDEX.create_index;
155: icx_por_ext_utl.debug('populateDescAll, create_index done ');
156:

Line 155: icx_por_ext_utl.debug('populateDescAll, create_index done ');

151: populateCategoryAttributes('N', 'N', p_log_type);
152: icx_por_ext_utl.debug('populateDescAll, populateCategoryAttributes done ');
153:
154: ICX_POR_INTERMEDIA_INDEX.create_index;
155: icx_por_ext_utl.debug('populateDescAll, create_index done ');
156:
157: -- disable the intermedia index concurrent program once it has been run successfully
158: -- we will use FND API FND_PROGRAM.ENABLE_PROGRAM for achieving the same
159: icx_por_ext_utl.debug('populateDescAll, disabling intermedia index concurrent program to prevent re-run');

Line 159: icx_por_ext_utl.debug('populateDescAll, disabling intermedia index concurrent program to prevent re-run');

155: icx_por_ext_utl.debug('populateDescAll, create_index done ');
156:
157: -- disable the intermedia index concurrent program once it has been run successfully
158: -- we will use FND API FND_PROGRAM.ENABLE_PROGRAM for achieving the same
159: icx_por_ext_utl.debug('populateDescAll, disabling intermedia index concurrent program to prevent re-run');
160: fnd_program.enable_program('ICXCICRI', 'ICX', 'N');
161: icx_por_ext_utl.debug('populateDescAll, intermedia index concurrent program disabled ');
162:
163: END;

Line 161: icx_por_ext_utl.debug('populateDescAll, intermedia index concurrent program disabled ');

157: -- disable the intermedia index concurrent program once it has been run successfully
158: -- we will use FND API FND_PROGRAM.ENABLE_PROGRAM for achieving the same
159: icx_por_ext_utl.debug('populateDescAll, disabling intermedia index concurrent program to prevent re-run');
160: fnd_program.enable_program('ICXCICRI', 'ICX', 'N');
161: icx_por_ext_utl.debug('populateDescAll, intermedia index concurrent program disabled ');
162:
163: END;
164:
165: /*

Line 291: icx_por_ext_utl.debug('start of populateCategoryAttribsByJob');

287:
288: --Debugging
289: --icx_por_track_validate_job_s.log('populateCategoryAttribsByJob', p_log_type);
290: --Debugging
291: icx_por_ext_utl.debug('start of populateCategoryAttribsByJob');
292: xErrLoc := 110;
293:
294: BEGIN
295: SELECT language_code

Line 329: icx_por_ext_utl.debug('populateCategoryAttribsByJob done');

325: xErrLoc:=280;
326: END LOOP;
327: xErrLoc:=300;
328: --Debugging
329: icx_por_ext_utl.debug('populateCategoryAttribsByJob done');
330: xErrLoc := 1001;
331: EXCEPTION
332: WHEN OTHERS THEN
333: ROLLBACK;

Line 375: icx_por_ext_utl.debug('start of populateCategoryAttributes ');

371: where cit.rt_category_id = cat.rt_category_id);
372: BEGIN
373: xErrLoc:=100;
374: --Debugging
375: icx_por_ext_utl.debug('start of populateCategoryAttributes ');
376: xErrLoc := 101;
377: BEGIN
378: SELECT language_code
379: INTO vLang

Line 412: icx_por_ext_utl.debug('populateCategoryAttributes done');

408: xErrLoc:=280;
409: END LOOP;
410: xErrLoc:=300;
411: --Debugging
412: icx_por_ext_utl.debug('populateCategoryAttributes done');
413: xErrLoc := 1001;
414: EXCEPTION
415: WHEN OTHERS THEN
416: ROLLBACK;

Line 448: icx_por_ext_utl.debug('start to process populateCtxDescBaseAtt');

444: BEGIN
445:
446: xErrLoc := 0;
447: --Debugging
448: icx_por_ext_utl.debug('start to process populateCtxDescBaseAtt');
449: xErrLoc := 10;
450: IF (pSourceType = 'ROWID') THEN
451: ICX_POR_CTX_SQL_PKG.build_ctx_sql(0,
452: ICX_POR_CTX_SQL_PKG.ROWID_WHERE_CLAUSE, pLanguage, vInsertSqlTab, vUpdateSqlTab);

Line 460: icx_por_ext_utl.debug('populateCtxDescBaseAtt, vUpdateSqlTab count:' ||

456: END IF;
457:
458: xErrLoc := 15;
459: --Debugging
460: icx_por_ext_utl.debug('populateCtxDescBaseAtt, vUpdateSqlTab count:' ||
461: to_char(vUpdateSqlTab.COUNT) );
462:
463: xErrLoc := 11;
464:

Line 479: icx_por_ext_utl.debug('populateCtxDescBaseAtt, vItemIdTab count:' ||

475: END IF;
476:
477: xErrLoc := 110;
478: --Debugging
479: icx_por_ext_utl.debug('populateCtxDescBaseAtt, vItemIdTab count:' ||
480: to_char(vItemIdTab.COUNT) );
481:
482: xErrLoc := 200;
483: IF vItemIdTab.COUNT = 0 THEN

Line 542: icx_por_ext_utl.debug('populateCtxDescBaseAtt done');

538: COMMIT;
539: END LOOP;
540: xErrLoc := 1001;
541: --Debugging
542: icx_por_ext_utl.debug('populateCtxDescBaseAtt done');
543: EXCEPTION
544: WHEN OTHERS THEN
545: ROLLBACK;
546:

Line 583: icx_por_ext_utl.debug('start of populateCtxDescCatAtt for pCategoryId:' ||

579: xErrLoc PLS_INTEGER;
580: BEGIN
581: xErrLoc := 100;
582: --Debugging
583: icx_por_ext_utl.debug('start of populateCtxDescCatAtt for pCategoryId:' ||
584: to_char(pCategoryId) );
585: xErrLoc := 101;
586: vCInsertSqlTab.DELETE;
587: vCUpdateSqlTab.DELETE;

Line 606: icx_por_ext_utl.debug('populateCtxDescCatAtt, vCUpdateSqlTab count:' ||

602: END IF;
603:
604: xErrLoc := 190;
605: --Debugging
606: icx_por_ext_utl.debug('populateCtxDescCatAtt, vCUpdateSqlTab count:' ||
607: to_char(vCUpdateSqlTab.COUNT) );
608:
609:
610: -----------------------------------------------------------------------

Line 655: icx_por_ext_utl.debug('populateCtxDescCatAtt, vCItemIdTab count:' ||

651: END IF;
652:
653: xErrLoc := 310;
654: --Debugging
655: icx_por_ext_utl.debug('populateCtxDescCatAtt, vCItemIdTab count:' ||
656: to_char(vCItemIdTab.COUNT) );
657:
658: xErrLoc := 320;
659: IF (vCItemIdTab.COUNT = 0) THEN

Line 744: icx_por_ext_utl.debug('populateCtxDescCatAtt done');

740: EXIT when vCStatus <> BATCH_SIZE;
741: END LOOP;
742: xErrLoc := 1001;
743: --Debugging
744: icx_por_ext_utl.debug('populateCtxDescCatAtt done');
745:
746: EXCEPTION
747: WHEN OTHERS THEN
748: ROLLBACK;

Line 780: icx_por_ext_utl.debug('start of populateCtxDescLang for itemId:' ||

776: BEGIN
777:
778: xErrLoc := 11;
779: --Debugging
780: icx_por_ext_utl.debug('start of populateCtxDescLang for itemId:' ||
781: to_char(p_item_id) ||', categoryId:' ||
782: to_char(p_category_id) ||', lang:' ||p_lang);
783: xErrLoc := 12;
784:

Line 889: icx_por_ext_utl.debug('populateCtxDescLang done');

885: xErrLoc := 900;
886: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
887: xErrLoc := 1000;
888: --Debugging
889: icx_por_ext_utl.debug('populateCtxDescLang done');
890: xErrLoc := 1001;
891: EXCEPTION
892: WHEN OTHERS THEN
893: ROLLBACK;

Line 930: icx_por_ext_utl.debug('*****<<<>>>* REBUILD_INDEX');

926: --icx_por_track_validate_job_s.log('*******<<<>>>*** REBUILD_INDEX', 'LOADER');
927:
928: xErrLoc := 11;
929: --Debugging
930: icx_por_ext_utl.debug('*******<<<>>>*** REBUILD_INDEX');
931: xErrLoc := 20;
932: /*
933: majorVersion := substr(versionString, 1, 1);
934: minorVersion := substr(versionString, 3, 1);

Line 961: icx_por_ext_utl.debug('plsql call made in rebuild_indexes:' || plsqlBlock);

957: /*icx_item_context_index_create.rebuild_item_context('N');*/
958: END IF;
959: xErrLoc := 121;
960: --Debugging
961: icx_por_ext_utl.debug('plsql call made in rebuild_indexes:' || plsqlBlock);
962: xErrLoc := 122;
963: dbms_sql.parse(cursorID, plsqlBlock, dbms_sql.NATIVE);
964: xErrLoc := 123;
965: --Debugging

Line 966: icx_por_ext_utl.debug('start to rebuild_indexes');

962: xErrLoc := 122;
963: dbms_sql.parse(cursorID, plsqlBlock, dbms_sql.NATIVE);
964: xErrLoc := 123;
965: --Debugging
966: icx_por_ext_utl.debug('start to rebuild_indexes');
967: xErrLoc := 130;
968: result := DBMS_SQL.execute(cursorID);
969: xErrLoc := 133;
970: --Debugging

Line 971: icx_por_ext_utl.debug('rebuild_indexes done');

967: xErrLoc := 130;
968: result := DBMS_SQL.execute(cursorID);
969: xErrLoc := 133;
970: --Debugging
971: icx_por_ext_utl.debug('rebuild_indexes done');
972: xErrLoc := 170;
973: dbms_sql.close_cursor(cursorID);
974:
975: EXCEPTION

Line 1000: icx_por_ext_utl.debug('start of populateBuyerInfo');

996: getItemsTlCur item_source_cv_type;
997: BEGIN
998: xErrLoc := 11;
999: --Debugging
1000: icx_por_ext_utl.debug('start of populateBuyerInfo');
1001:
1002: xErrLoc := 100;
1003:
1004: OPEN getItemsTlCur FOR

Line 1015: icx_por_ext_utl.debug('populateBuyerInfo done');

1011:
1012: CLOSE getItemsTlCur;
1013: xErrLoc := 101;
1014: --Debugging
1015: icx_por_ext_utl.debug('populateBuyerInfo done');
1016:
1017: EXCEPTION
1018: WHEN OTHERS THEN
1019: ROLLBACK;

Line 1050: icx_por_ext_utl.debug('start to process populateCtxDescBuyerInfo');

1046: BEGIN
1047:
1048: xErrLoc := 0;
1049: --Debugging
1050: icx_por_ext_utl.debug('start to process populateCtxDescBuyerInfo');
1051: xErrLoc := 11;
1052:
1053: LOOP
1054: vRowidTab.DELETE;

Line 1070: icx_por_ext_utl.debug('populateCtxDescBuyerInfo vItemIdTab count:' ||

1066: END IF;
1067:
1068: xErrLoc := 110;
1069: --Debugging
1070: icx_por_ext_utl.debug('populateCtxDescBuyerInfo vItemIdTab count:' ||
1071: to_char(vItemIdTab.COUNT) );
1072:
1073: xErrLoc := 200;
1074:

Line 1124: icx_por_ext_utl.debug('populateCtxDescBuyerInfo done');

1120:
1121: END LOOP;
1122: xErrLoc := 1001;
1123: --Debugging
1124: icx_por_ext_utl.debug('populateCtxDescBuyerInfo done');
1125:
1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: ROLLBACK;