DBA Data[Home] [Help]

APPS.HXC_ALIAS_UTILITY dependencies on FND_LOG

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

4626: l_alias_definition t_alias_def_item;
4627: l_index NUMBER;
4628:
4629: BEGIN
4630: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4631: fnd_log.string(1
4632: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4633: ,'p_alias_type:'||p_alias_type||
4634: ' p_start_time:'||p_start_time||

Line 4631: fnd_log.string(1

4627: l_index NUMBER;
4628:
4629: BEGIN
4630: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4631: fnd_log.string(1
4632: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4633: ,'p_alias_type:'||p_alias_type||
4634: ' p_start_time:'||p_start_time||
4635: ' p_stop_time :'||p_stop_time||

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

4653:
4654: IF (l_index = l_alias_definition.FIRST) THEN
4655: l_alias_def_comma := ','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4656:
4657: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4658: fnd_log.string(1
4659: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4660: ,'l_alias_def_comma1:'||l_alias_def_comma);
4661: END IF;

Line 4658: fnd_log.string(1

4654: IF (l_index = l_alias_definition.FIRST) THEN
4655: l_alias_def_comma := ','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4656:
4657: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4658: fnd_log.string(1
4659: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4660: ,'l_alias_def_comma1:'||l_alias_def_comma);
4661: END IF;
4662: ELSE

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

4660: ,'l_alias_def_comma1:'||l_alias_def_comma);
4661: END IF;
4662: ELSE
4663: l_alias_def_comma := l_alias_def_comma||','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4664: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4665: fnd_log.string(1
4666: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4667: ,'l_alias_def_comma2:'||l_alias_def_comma);
4668: END IF;

Line 4665: fnd_log.string(1

4661: END IF;
4662: ELSE
4663: l_alias_def_comma := l_alias_def_comma||','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4664: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4665: fnd_log.string(1
4666: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4667: ,'l_alias_def_comma2:'||l_alias_def_comma);
4668: END IF;
4669: END IF;

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

4673:
4674: END LOOP;
4675:
4676: l_alias_def_comma := l_alias_def_comma||',';
4677: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4678: fnd_log.string(1
4679: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4680: ,'l_alias_def_comma3:'||l_alias_def_comma);
4681: END IF;

Line 4678: fnd_log.string(1

4674: END LOOP;
4675:
4676: l_alias_def_comma := l_alias_def_comma||',';
4677: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4678: fnd_log.string(1
4679: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4680: ,'l_alias_def_comma3:'||l_alias_def_comma);
4681: END IF;
4682:

Line 4700: fnd_log.string(1

4696:
4697:
4698: BEGIN
4699:
4700: fnd_log.string(1
4701: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4702: ,'p_alias_type:'||p_alias_type||
4703: ' p_start_time:'||p_start_time||
4704: ' p_stop_time :'||p_stop_time||

Line 5237: fnd_log.string(1

5233: l_found BOOLEAN := FALSE;
5234:
5235: BEGIN
5236: /*
5237: fnd_log.string(1
5238: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5239: ,'arrived:');
5240:
5241: fnd_log.string(1

Line 5241: fnd_log.string(1

5237: fnd_log.string(1
5238: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5239: ,'arrived:');
5240:
5241: fnd_log.string(1
5242: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5243: ,'p_alias_type:'||p_alias_type||
5244: ' p_start_time:'||p_start_time||
5245: ' p_stop_time :'||p_stop_time||

Line 5258: fnd_log.string(1

5254: p_pref_table => l_pref_table);
5255:
5256: l_index:=l_pref_table.FIRST;
5257: /*
5258: fnd_log.string(1
5259: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5260: ,'passed the pref :');
5261: */
5262:

Line 5333: --fnd_log.string(1

5329: l_index_pref_val := l_index_pref_val + 1;
5330: l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID := l_pref_table(l_index).attribute30;
5331: l_index_pref_val := l_index_pref_val + 1;
5332:
5333: --fnd_log.string(1
5334: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5335: -- ,'l_index_pref_val1:'||l_index_pref_val);
5336:
5337: l_index_pref_val := l_pref_value.first;

Line 5339: --fnd_log.string(1

5335: -- ,'l_index_pref_val1:'||l_index_pref_val);
5336:
5337: l_index_pref_val := l_pref_value.first;
5338:
5339: --fnd_log.string(1
5340: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5341: -- ,'l_index_pref_val2:'||l_index_pref_val);
5342:
5343:

Line 5350: --fnd_log.string(1

5346: (NOT l_pref_value.exists(l_index_pref_val));
5347:
5348: IF (l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID is not null) THEN
5349:
5350: --fnd_log.string(1
5351: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5352: --,'l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID :'||
5353: -- l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID);
5354:

Line 5363: --fnd_log.string(1

5359: where hat.alias_type_id =had.alias_type_id
5360: and alias_definition_id =
5361: l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID;
5362:
5363: --fnd_log.string(1
5364: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5365: --,'l_alias_type:'||l_alias_type||
5366: --' p_alias_type:'||p_alias_type);
5367:

Line 5379: --fnd_log.string(1

5375: l_alias_definition(l_alias_index).PREF_END_DATE :=
5376: l_pref_table(l_index).END_DATE;
5377: l_alias_index := l_alias_index + 1;
5378: l_found := true;
5379: --fnd_log.string(1
5380: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5381: --,'l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID'||
5382: -- l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID||
5383: --' l_alias_definition(l_alias_index).START_DATE'||