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 272: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 273: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 620: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 714: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 736: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 788: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

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

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

Line 887: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 903: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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