DBA Data[Home] [Help]

APPS.HXC_ALIAS_UTILITY dependencies on FND_LOG

Line 4314: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4310: l_alias_definition t_alias_def_item;
4311: l_index NUMBER;
4312:
4313: BEGIN
4314: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4315: fnd_log.string(1
4316: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4317: ,'p_alias_type:'||p_alias_type||
4318: ' p_start_time:'||p_start_time||

Line 4315: fnd_log.string(1

4311: l_index NUMBER;
4312:
4313: BEGIN
4314: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4315: fnd_log.string(1
4316: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4317: ,'p_alias_type:'||p_alias_type||
4318: ' p_start_time:'||p_start_time||
4319: ' p_stop_time :'||p_stop_time||

Line 4341: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4337:
4338: IF (l_index = l_alias_definition.FIRST) THEN
4339: l_alias_def_comma := ','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4340:
4341: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4342: fnd_log.string(1
4343: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4344: ,'l_alias_def_comma1:'||l_alias_def_comma);
4345: END IF;

Line 4342: fnd_log.string(1

4338: IF (l_index = l_alias_definition.FIRST) THEN
4339: l_alias_def_comma := ','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4340:
4341: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4342: fnd_log.string(1
4343: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4344: ,'l_alias_def_comma1:'||l_alias_def_comma);
4345: END IF;
4346: ELSE

Line 4348: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4344: ,'l_alias_def_comma1:'||l_alias_def_comma);
4345: END IF;
4346: ELSE
4347: l_alias_def_comma := l_alias_def_comma||','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4348: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4349: fnd_log.string(1
4350: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4351: ,'l_alias_def_comma2:'||l_alias_def_comma);
4352: END IF;

Line 4349: fnd_log.string(1

4345: END IF;
4346: ELSE
4347: l_alias_def_comma := l_alias_def_comma||','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4348: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4349: fnd_log.string(1
4350: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4351: ,'l_alias_def_comma2:'||l_alias_def_comma);
4352: END IF;
4353: END IF;

Line 4361: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4357:
4358: END LOOP;
4359:
4360: l_alias_def_comma := l_alias_def_comma||',';
4361: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4362: fnd_log.string(1
4363: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4364: ,'l_alias_def_comma3:'||l_alias_def_comma);
4365: END IF;

Line 4362: fnd_log.string(1

4358: END LOOP;
4359:
4360: l_alias_def_comma := l_alias_def_comma||',';
4361: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4362: fnd_log.string(1
4363: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4364: ,'l_alias_def_comma3:'||l_alias_def_comma);
4365: END IF;
4366:

Line 4384: fnd_log.string(1

4380:
4381:
4382: BEGIN
4383:
4384: fnd_log.string(1
4385: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4386: ,'p_alias_type:'||p_alias_type||
4387: ' p_start_time:'||p_start_time||
4388: ' p_stop_time :'||p_stop_time||

Line 4921: fnd_log.string(1

4917: l_found BOOLEAN := FALSE;
4918:
4919: BEGIN
4920: /*
4921: fnd_log.string(1
4922: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
4923: ,'arrived:');
4924:
4925: fnd_log.string(1

Line 4925: fnd_log.string(1

4921: fnd_log.string(1
4922: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
4923: ,'arrived:');
4924:
4925: fnd_log.string(1
4926: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
4927: ,'p_alias_type:'||p_alias_type||
4928: ' p_start_time:'||p_start_time||
4929: ' p_stop_time :'||p_stop_time||

Line 4942: fnd_log.string(1

4938: p_pref_table => l_pref_table);
4939:
4940: l_index:=l_pref_table.FIRST;
4941: /*
4942: fnd_log.string(1
4943: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
4944: ,'passed the pref :');
4945: */
4946:

Line 5017: --fnd_log.string(1

5013: l_index_pref_val := l_index_pref_val + 1;
5014: l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID := l_pref_table(l_index).attribute30;
5015: l_index_pref_val := l_index_pref_val + 1;
5016:
5017: --fnd_log.string(1
5018: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5019: -- ,'l_index_pref_val1:'||l_index_pref_val);
5020:
5021: l_index_pref_val := l_pref_value.first;

Line 5023: --fnd_log.string(1

5019: -- ,'l_index_pref_val1:'||l_index_pref_val);
5020:
5021: l_index_pref_val := l_pref_value.first;
5022:
5023: --fnd_log.string(1
5024: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5025: -- ,'l_index_pref_val2:'||l_index_pref_val);
5026:
5027:

Line 5034: --fnd_log.string(1

5030: (NOT l_pref_value.exists(l_index_pref_val));
5031:
5032: IF (l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID is not null) THEN
5033:
5034: --fnd_log.string(1
5035: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5036: --,'l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID :'||
5037: -- l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID);
5038:

Line 5047: --fnd_log.string(1

5043: where hat.alias_type_id =had.alias_type_id
5044: and alias_definition_id =
5045: l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID;
5046:
5047: --fnd_log.string(1
5048: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5049: --,'l_alias_type:'||l_alias_type||
5050: --' p_alias_type:'||p_alias_type);
5051:

Line 5063: --fnd_log.string(1

5059: l_alias_definition(l_alias_index).PREF_END_DATE :=
5060: l_pref_table(l_index).END_DATE;
5061: l_alias_index := l_alias_index + 1;
5062: l_found := true;
5063: --fnd_log.string(1
5064: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5065: --,'l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID'||
5066: -- l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID||
5067: --' l_alias_definition(l_alias_index).START_DATE'||