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

Line 78: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

74: l_proc_begin_module VARCHAR2(80);
75: l_err_loc PLS_INTEGER;
76: BEGIN
77: l_err_loc := 100;
78: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: l_err_loc := 200;
80: l_proc_begin_module := getModuleNameForDebug(p_pkg_name, p_proc_name) || g_log_module_seperator || g_log_module_begin;
81: l_err_loc := 300;
82: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_proc_begin_module, p_log_string);

Line 82: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_proc_begin_module, p_log_string);

78: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: l_err_loc := 200;
80: l_proc_begin_module := getModuleNameForDebug(p_pkg_name, p_proc_name) || g_log_module_seperator || g_log_module_begin;
81: l_err_loc := 300;
82: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_proc_begin_module, p_log_string);
83: l_err_loc := 400;
84: END IF;
85: EXCEPTION
86: WHEN OTHERS THEN

Line 101: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

97: l_proc_end_module VARCHAR2(80);
98: l_err_loc PLS_INTEGER;
99: BEGIN
100: l_err_loc := 100;
101: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
102: l_err_loc := 200;
103: l_proc_end_module := getModuleNameForDebug(p_pkg_name, p_proc_name) || g_log_module_seperator || g_log_module_end;
104: l_err_loc := 300;
105: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_proc_end_module, p_log_string);

Line 105: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_proc_end_module, p_log_string);

101: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
102: l_err_loc := 200;
103: l_proc_end_module := getModuleNameForDebug(p_pkg_name, p_proc_name) || g_log_module_seperator || g_log_module_end;
104: l_err_loc := 300;
105: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_proc_end_module, p_log_string);
106: l_err_loc := 400;
107: END IF;
108: EXCEPTION
109: WHEN OTHERS THEN

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

119: IS
120: l_err_loc PLS_INTEGER;
121: BEGIN
122: l_err_loc := 100;
123: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
124: l_err_loc := 200;
125: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, getModuleNameForDebug(p_pkg_name, p_proc_name), p_log_string);
126: l_err_loc := 300;
127: END IF;

Line 125: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, getModuleNameForDebug(p_pkg_name, p_proc_name), p_log_string);

121: BEGIN
122: l_err_loc := 100;
123: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
124: l_err_loc := 200;
125: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, getModuleNameForDebug(p_pkg_name, p_proc_name), p_log_string);
126: l_err_loc := 300;
127: END IF;
128: EXCEPTION
129: WHEN OTHERS THEN

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

186:
187: EXIT WHEN l_key_tbl.COUNT = 0;
188:
189: l_err_loc := 500;
190: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
192: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
193: 'For p_key:' || p_key || ', PO_SESSION_GT rowcount:' || l_key_tbl.COUNT );
194: END IF;

Line 191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

187: EXIT WHEN l_key_tbl.COUNT = 0;
188:
189: l_err_loc := 500;
190: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
192: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
193: 'For p_key:' || p_key || ', PO_SESSION_GT rowcount:' || l_key_tbl.COUNT );
194: END IF;
195:

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

194: END IF;
195:
196: l_err_loc := 600;
197: FOR i IN 1..l_key_tbl.COUNT LOOP
198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
201: 'PO_SESSION_GT Row # ' || i ||
202: '; l_key_tbl: ' || l_key_tbl(i) ||

Line 199: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

195:
196: l_err_loc := 600;
197: FOR i IN 1..l_key_tbl.COUNT LOOP
198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
201: 'PO_SESSION_GT Row # ' || i ||
202: '; l_key_tbl: ' || l_key_tbl(i) ||
203: ', l_index_num1_tbl: ' || l_index_num1_tbl(i) ||

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

267:
268: EXIT WHEN l_inventory_item_id_tbl.COUNT = 0;
269:
270: l_err_loc := 500;
271: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
272: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
273: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
274: 'For p_request_id:' || p_request_id ||
275: ', MTL_ITEM_BULKLOAD_RECS rowcount:' || l_inventory_item_id_tbl.COUNT);

Line 272: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

268: EXIT WHEN l_inventory_item_id_tbl.COUNT = 0;
269:
270: l_err_loc := 500;
271: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
272: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
273: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
274: 'For p_request_id:' || p_request_id ||
275: ', MTL_ITEM_BULKLOAD_RECS rowcount:' || l_inventory_item_id_tbl.COUNT);
276: END IF;

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

276: END IF;
277:
278: l_err_loc := 600;
279: FOR i IN 1..l_inventory_item_id_tbl.COUNT LOOP
280: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
282: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
283: 'MTL_ITEM_BULKLOAD_RECS Row # ' || i ||
284: '; l_inventory_item_id_tbl: ' || l_inventory_item_id_tbl(i) ||

Line 281: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

277:
278: l_err_loc := 600;
279: FOR i IN 1..l_inventory_item_id_tbl.COUNT LOOP
280: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
282: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
283: 'MTL_ITEM_BULKLOAD_RECS Row # ' || i ||
284: '; l_inventory_item_id_tbl: ' || l_inventory_item_id_tbl(i) ||
285: ', l_organization_id_tbl: ' || l_organization_id_tbl(i) ||

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

440: BEGIN
441: FOR j IN 1..p_table.COUNT LOOP
442: l_ret_value := 'N';
443: IF (p_value = p_table(j)) THEN
444: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
445: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
446: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
447: ' p_value:' || p_value ||
448: ', already exists in the p_table at index:' || j ||

Line 445: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

441: FOR j IN 1..p_table.COUNT LOOP
442: l_ret_value := 'N';
443: IF (p_value = p_table(j)) THEN
444: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
445: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
446: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
447: ' p_value:' || p_value ||
448: ', already exists in the p_table at index:' || j ||
449: '; about to exit from table check');

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

500: FROM dual;
501:
502: l_err_loc := 200;
503:
504: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
506: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
507: 'Next Seq from icx_cat_items_ctx_requestid_s:' || l_internal_request_id);
508: END IF;

Line 505: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

501:
502: l_err_loc := 200;
503:
504: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
506: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
507: 'Next Seq from icx_cat_items_ctx_requestid_s:' || l_internal_request_id);
508: END IF;
509:

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

535: END IF;
536:
537: l_err_loc := 500;
538:
539: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
540: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
541: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
542: 'Batch Size set to:' || ICX_CAT_UTIL_PVT.g_batch_size);
543: END IF;

Line 540: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

536:
537: l_err_loc := 500;
538:
539: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
540: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
541: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
542: 'Batch Size set to:' || ICX_CAT_UTIL_PVT.g_batch_size);
543: END IF;
544: EXCEPTION

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

556: BEGIN
557: l_err_loc := 100;
558: g_COMMIT := p_commit;
559:
560: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
561: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
562: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
563: 'g_COMMIT set to:' || g_COMMIT);
564: END IF;

Line 561: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

557: l_err_loc := 100;
558: g_COMMIT := p_commit;
559:
560: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
561: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
562: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
563: 'g_COMMIT set to:' || g_COMMIT);
564: END IF;
565: END setCommitParameter;

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

591: g_who_columns_rec.program_id := fnd_global.conc_program_id;
592: g_who_columns_rec.program_login_id := fnd_global.conc_login_id;
593: END IF;
594: l_err_loc := 400;
595: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
596: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
597: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
598: 'Who columns; internal_request_id:' || l_internal_request_id ||
599: ', request_id:' || p_request_id ||

Line 596: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

592: g_who_columns_rec.program_login_id := fnd_global.conc_login_id;
593: END IF;
594: l_err_loc := 400;
595: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
596: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
597: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
598: 'Who columns; internal_request_id:' || l_internal_request_id ||
599: ', request_id:' || p_request_id ||
600: ', user_id:' || g_who_columns_rec.user_id ||

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

613: FROM fnd_languages
614: WHERE installed_flag='B';
615:
616: l_err_loc := 200;
617: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
619: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
620: 'Base language:' || g_base_language);
621: END IF;

Line 618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

614: WHERE installed_flag='B';
615:
616: l_err_loc := 200;
617: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
619: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
620: 'Base language:' || g_base_language);
621: END IF;
622: EXCEPTION

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

642: FROM mtl_default_sets_view
643: WHERE functional_area_id = 2;
644:
645: l_err_loc := 200;
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: 'Purchasing category set info: g_category_set_id:' || g_category_set_id ||
650: ', g_validate_flag:' || g_validate_flag ||

Line 647: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

643: WHERE functional_area_id = 2;
644:
645: l_err_loc := 200;
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: 'Purchasing category set info: g_category_set_id:' || g_category_set_id ||
650: ', g_validate_flag:' || g_validate_flag ||
651: ', g_structure_id:' || g_structure_id);

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

695: END IF;
696: END LOOP;
697:
698: l_err_loc := 600;
699: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
700: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
701: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
702: 'Concatenated Segment Clause for master items: ' || g_mi_concat_seg_clause);
703: END IF;

Line 700: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

696: END LOOP;
697:
698: l_err_loc := 600;
699: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
700: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
701: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
702: 'Concatenated Segment Clause for master items: ' || g_mi_concat_seg_clause);
703: END IF;
704: