APPS.ICX_CAT_POPULATE_REQTMPL_GRP dependencies on ICX_CAT_UTIL_PVT

Line 39: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

35: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
36: ', p_api_version:' || p_api_version ||
37: ', p_commit:' || p_commit ||
38: ', p_key:' || p_key;
39: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
40: END IF;
41:
42: l_err_loc := 400;
43: -- Standard call to check for call compatibility.

Line 53: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52: l_err_loc := 500;
53: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
54:
55: l_err_loc := 600;
56: ICX_CAT_POPULATE_REQTMPL_PVT.populateOnlineReqTemplates(p_key);
57:

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

64: -- Call the rebuild index
65: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
66: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
67: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
68: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
69: 'Rebuild indexes called.');
70: END IF;
71: ELSE
72: l_err_loc := 1000;

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

71: ELSE
72: l_err_loc := 1000;
73: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
74: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
75: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
76: 'p_commit is false, so Rebuild indexes is not called.');
77: END IF;
78: END IF;
79:

Line 83: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

79:
80: l_err_loc := 1100;
81: l_end_date := sysdate;
82: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
83: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
84: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
85: END IF;
86:
87: EXCEPTION

Line 84: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));

80: l_err_loc := 1100;
81: l_end_date := sysdate;
82: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
83: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
84: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
85: END IF;
86:
87: EXCEPTION
88: WHEN OTHERS THEN

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

91: EXCEPTION
92: WHEN OTHERS THEN
93: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
94: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
95: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
96: 'ROLLBACK TO the savepoint caused the exception -->'
97: || SQLERRM);
98: END IF;
99: NULL;