APPS.GCS_DIMENSION_SET_LINES_PKG dependencies on GCS_UTILITY_PKG

Line 39: GCS_UTILITY_PKG.g_module_enter || fn_name ||

35: BEGIN
36: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
37: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
38: g_api || '.' || fn_name,
39: GCS_UTILITY_PKG.g_module_enter || fn_name ||
40: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
41: END IF;
42: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
43: fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 42: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

38: g_api || '.' || fn_name,
39: GCS_UTILITY_PKG.g_module_enter || fn_name ||
40: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
41: END IF;
42: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
43: fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
44:
45: -- In case of an error, roll back to this point
46: SAVEPOINT gcs_dms_line_assign_start;

Line 65: GCS_UTILITY_PKG.init_dimension_info;

61: where_clause := '';
62:
63: -- build the statement parts
64: IF (l_dimension_set_type = 'TARGET_ONLY') THEN
65: GCS_UTILITY_PKG.init_dimension_info;
66: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.FIRST;
67: ELSE
68: OPEN src_tgt_dims;
69: FETCH src_tgt_dims INTO l_col_name;

Line 66: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.FIRST;

62:
63: -- build the statement parts
64: IF (l_dimension_set_type = 'TARGET_ONLY') THEN
65: GCS_UTILITY_PKG.init_dimension_info;
66: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.FIRST;
67: ELSE
68: OPEN src_tgt_dims;
69: FETCH src_tgt_dims INTO l_col_name;
70: END IF;

Line 102: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.NEXT(l_col_name);

98: l_col_name || '''';
99:
100: <>
101: IF (l_dimension_set_type = 'TARGET_ONLY') THEN
102: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.NEXT(l_col_name);
103: ELSE
104: FETCH src_tgt_dims INTO l_col_name;
105: EXIT WHEN (src_tgt_dims%NOTFOUND);
106: END IF;

Line 178: GCS_UTILITY_PKG.g_module_success || fn_name ||

174: <>
175: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
177: g_api || '.' || fn_name,
178: GCS_UTILITY_PKG.g_module_success || fn_name ||
179: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
180: END IF;
181: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
182: fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 181: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

177: g_api || '.' || fn_name,
178: GCS_UTILITY_PKG.g_module_success || fn_name ||
179: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
180: END IF;
181: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
182: fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
183:
184: EXCEPTION
185: WHEN OTHERS THEN

Line 192: GCS_UTILITY_PKG.g_module_failure || fn_name ||

188: g_api || '.' || fn_name,
189: SUBSTR(SQLERRM, 1, 4000));
190: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
191: g_api || '.' || fn_name,
192: GCS_UTILITY_PKG.g_module_failure || fn_name ||
193: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
194: END IF;
195: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
196: fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 195: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

191: g_api || '.' || fn_name,
192: GCS_UTILITY_PKG.g_module_failure || fn_name ||
193: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
194: END IF;
195: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
196: fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
197:
198: ROLLBACK TO gcs_dms_line_assign_start;
199: p_errbuf := 'GCS_DMSL_UNHANDLED_EXCEPTION';