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

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

14: l_err_loc PLS_INTEGER;
15: l_reqTemplate_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
16: BEGIN
17: l_err_loc := 100;
18: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
19: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
20: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
21: 'Processing cursor:' || l_api_name ||
22: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||

Line 19: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

15: l_reqTemplate_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
16: BEGIN
17: l_err_loc := 100;
18: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
19: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
20: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
21: 'Processing cursor:' || l_api_name ||
22: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
23: ', g_start_rowid:' || g_start_rowid ||

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

266: l_err_loc PLS_INTEGER;
267: l_reqTemplate_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
268: BEGIN
269: l_err_loc := 100;
270: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
272: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
273: 'Processing cursor:' || l_api_name ||
274: ', p_key:' || p_key );

Line 271: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

267: l_reqTemplate_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
268: BEGIN
269: l_err_loc := 100;
270: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
272: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
273: 'Processing cursor:' || l_api_name ||
274: ', p_key:' || p_key );
275: END IF;

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

612: l_batch_count := l_batch_count + 1;
613:
614: l_err_loc := 600;
615: l_count := l_inv_item_id_tbl.COUNT;
616: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
618: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
619: 'Num. of rows returned from the cursor:' || l_count);
620: END IF;

Line 617: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

613:
614: l_err_loc := 600;
615: l_count := l_inv_item_id_tbl.COUNT;
616: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
618: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
619: 'Num. of rows returned from the cursor:' || l_count);
620: END IF;
621: l_row_count := l_row_count + l_count;

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

706: l_err_loc := 1300;
707: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);
708: ELSE
709: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
710: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
711: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
712: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
713: 'Row #:' || i ||
714: ', with req_template_line:(' || l_req_template_name_tbl(i) ||

Line 711: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

707: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);
708: ELSE
709: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
710: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
711: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
712: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
713: 'Row #:' || i ||
714: ', with req_template_line:(' || l_req_template_name_tbl(i) ||
715: ', ' || l_req_template_line_num_tbl(i) ||

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

728: ', l_system_date_tbl:' || l_system_date_tbl(i) ||
729: ', status: ' || l_ReqTmplt_line_status);
730: END IF;
731: ELSE
732: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
733: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
734: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
735: 'Row #:' || i ||
736: ', with req_template_line:(' || l_req_template_name_tbl(i) ||

Line 733: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

729: ', status: ' || l_ReqTmplt_line_status);
730: END IF;
731: ELSE
732: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
733: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
734: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
735: 'Row #:' || i ||
736: ', with req_template_line:(' || l_req_template_name_tbl(i) ||
737: ', ' || l_req_template_line_num_tbl(i) ||

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

780: l_err_loc := 1700;
781: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);
782:
783: l_err_loc := 1800;
784: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
786: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
787: 'populateReqTemplates done; '||
788: 'Total num. of batches processed:' ||l_batch_count ||

Line 785: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

781: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);
782:
783: l_err_loc := 1800;
784: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
786: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
787: 'populateReqTemplates done; '||
788: 'Total num. of batches processed:' ||l_batch_count ||
789: ', Total num. of rows processed:' ||l_row_count);

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

846: l_err_loc := 300;
847: g_key := p_key;
848:
849: l_err_loc := 350;
850: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
851: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
852: END IF;
853:
854: l_err_loc := 400;

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

879: l_err_loc PLS_INTEGER;
880: BEGIN
881: l_err_loc := 100;
882: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_metadataTblFormed) THEN
883: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
885: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
886: 'about to call buildmetadatinfo');
887: END IF;

Line 884: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

880: BEGIN
881: l_err_loc := 100;
882: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_metadataTblFormed) THEN
883: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
885: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
886: 'about to call buildmetadatinfo');
887: END IF;
888:

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

895: END IF;
896:
897: l_err_loc := 400;
898: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_CtxSqlForPODocsFormed) THEN
899: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
900: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
901: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
902: 'about to call buildctxsql');
903: END IF;

Line 900: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

896:
897: l_err_loc := 400;
898: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_CtxSqlForPODocsFormed) THEN
899: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
900: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
901: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
902: 'about to call buildctxsql');
903: END IF;
904: