DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_BPA_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_PODOCS_PVT.populateOnlineBlankets(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: EXCEPTION
87: WHEN OTHERS THEN

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: EXCEPTION
87: WHEN OTHERS THEN
88: BEGIN

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

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

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

131: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
132: ', p_api_version:' || p_api_version ||
133: ', p_commit:' || p_commit ||
134: ', p_key:' || p_key;
135: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
136: END IF;
137:
138: l_err_loc := 400;
139: -- Standard call to check for call compatibility.

Line 149: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END IF;
147:
148: l_err_loc := 500;
149: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
150:
151: l_err_loc := 600;
152: ICX_CAT_POPULATE_PODOCS_PVT.populateOnlineOrgAssgnmnts(p_key);
153:

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

160: -- Call the rebuild index
161: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
162: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
163: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
164: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
165: 'Rebuild indexes called.');
166: END IF;
167: ELSE
168: l_err_loc := 1000;

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

167: ELSE
168: l_err_loc := 1000;
169: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
171: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
172: 'p_commit is false, so Rebuild indexes is not called.');
173: END IF;
174: END IF;
175:

Line 179: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

175:
176: l_err_loc := 1100;
177: l_end_date := sysdate;
178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
179: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
180: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
181: END IF;
182: EXCEPTION
183: WHEN OTHERS THEN

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

176: l_err_loc := 1100;
177: l_end_date := sysdate;
178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
179: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
180: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
181: END IF;
182: EXCEPTION
183: WHEN OTHERS THEN
184: BEGIN

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

186: EXCEPTION
187: WHEN OTHERS THEN
188: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
190: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
191: 'ROLLBACK TO the savepoint caused the exception -->'
192: || SQLERRM);
193: END IF;
194: NULL;