APPS.GCS_IC_LOB_ELIM_PARENT_PKG dependencies on FND_LOG

Line 19: g_fnd_login_id NUMBER := fnd_global.login_id;

15: g_pkg_name VARCHAR2(80) := 'gcs.plsql.GCS_IC_LOB_ELIM_PARENT_PKG';
16: g_nl CONSTANT VARCHAR2(1) := fnd_global.newline;
17: g_no_rows NUMBER := 0;
18: g_fnd_user_id NUMBER := fnd_global.user_id;
19: g_fnd_login_id NUMBER := fnd_global.login_id;
20:
21:
22: -- Bug fix : 5257413, removed the parameter values_set_id
23:

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

152: WHERE object_id = p_hierarchy_obj_id
153: AND display_name = p_version_name;
154:
155: -- Retreiving the value_set_id of user dimension-1
156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: fnd_log.STRING (fnd_log.level_procedure,
158: g_pkg_name || '.' || l_api_name,
159: 'Retreive the value_set_id of user dimension-1' );
160: END IF;

Line 157: fnd_log.STRING (fnd_log.level_procedure,

153: AND display_name = p_version_name;
154:
155: -- Retreiving the value_set_id of user dimension-1
156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: fnd_log.STRING (fnd_log.level_procedure,
158: g_pkg_name || '.' || l_api_name,
159: 'Retreive the value_set_id of user dimension-1' );
160: END IF;
161:

Line 212: g_fnd_login_id,

208: sysdate,
209: g_fnd_user_id,
210: g_fnd_user_id,
211: sysdate,
212: g_fnd_login_id,
213: v_additional_lobs.read_only_flag,
214: v_additional_lobs.object_version_number,
215: NULL
216: FROM DUAL;

Line 249: g_fnd_login_id

245: sysdate,
246: g_fnd_user_id,
247: g_fnd_user_id,
248: sysdate,
249: g_fnd_login_id
250: FROM fem_user_dim1_b fudb,
251: fnd_languages fl
252: WHERE fl.installed_flag in ('I', 'B')
253: AND fudb.user_dim1_display_code like '%'||l_elims_const

Line 290: g_fnd_login_id,

286: sysdate,
287: g_fnd_user_id,
288: g_fnd_user_id,
289: sysdate,
290: g_fnd_login_id,
291: 1,
292: 'N',
293: DECODE(fdab.attribute_varchar_label, 'SOURCE_SYSTEM_CODE', fdab.default_assignment, NULL),
294: DECODE(fdab.attribute_varchar_label, 'RECON_LEAF_NODE_FLAG', fdab.default_assignment, NULL)

Line 340: g_fnd_login_id ,

336: sysdate,
337: g_fnd_user_id,
338: g_fnd_user_id,
339: sysdate,
340: g_fnd_login_id ,
341: 1,
342: 'N'
343: FROM fem_user_dim1_hier fudh,
344: fem_user_dim1_b fudb,

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

395: fem_hierarchies fh
396: WHERE fodb.object_definition_id = l_hierarchy_obj_def_id
397: AND fodb.object_id = fh.hierarchy_obj_id;
398:
399: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
400: fnd_log.STRING(fnd_log.level_procedure,
401: g_pkg_name || '.' || l_api_name,
402: 'Insert new hierarchy value set '
403: ||' into FEM_HIER_VALUE_SETS_T ');

Line 400: fnd_log.STRING(fnd_log.level_procedure,

396: WHERE fodb.object_definition_id = l_hierarchy_obj_def_id
397: AND fodb.object_id = fh.hierarchy_obj_id;
398:
399: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
400: fnd_log.STRING(fnd_log.level_procedure,
401: g_pkg_name || '.' || l_api_name,
402: 'Insert new hierarchy value set '
403: ||' into FEM_HIER_VALUE_SETS_T ');
404: END IF;

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

413: USERENV('LANG'),
414: 'LOAD'
415: );
416:
417: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: fnd_log.STRING(fnd_log.level_procedure,
419: g_pkg_name || '.' || l_api_name,
420: 'Insert existing hierarchy members '
421: ||' into fem_user_dim1_hier_T ');

Line 418: fnd_log.STRING(fnd_log.level_procedure,

414: 'LOAD'
415: );
416:
417: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: fnd_log.STRING(fnd_log.level_procedure,
419: g_pkg_name || '.' || l_api_name,
420: 'Insert existing hierarchy members '
421: ||' into fem_user_dim1_hier_T ');
422: END IF;