123: , lv_usage_name;
124: EXIT WHEN asset_detail_cur%NOTFOUND;
125: ln_row_count := ln_row_count + 1;
126:
127: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
128: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
129: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
130: );
131: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
124: EXIT WHEN asset_detail_cur%NOTFOUND;
125: ln_row_count := ln_row_count + 1;
126:
127: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
128: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
129: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
130: );
131: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
132: , pv_text_node_value => lv_usage_status_code
125: ln_row_count := ln_row_count + 1;
126:
127: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
128: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
129: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
130: );
131: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
132: , pv_text_node_value => lv_usage_status_code
133: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
127: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
128: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
129: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
130: );
131: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
132: , pv_text_node_value => lv_usage_status_code
133: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
134: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
135: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
129: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
130: );
131: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
132: , pv_text_node_value => lv_usage_status_code
133: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
134: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
135: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
136: );
137: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
130: );
131: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
132: , pv_text_node_value => lv_usage_status_code
133: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
134: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
135: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
136: );
137: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
138: , pv_text_node_value => lv_usage_name
131: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
132: , pv_text_node_value => lv_usage_status_code
133: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
134: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
135: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
136: );
137: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
138: , pv_text_node_value => lv_usage_name
139: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
133: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
134: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
135: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
136: );
137: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
138: , pv_text_node_value => lv_usage_name
139: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
140: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
141: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
135: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
136: );
137: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
138: , pv_text_node_value => lv_usage_name
139: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
140: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
141: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
142: );
143: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
136: );
137: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
138: , pv_text_node_value => lv_usage_name
139: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
140: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
141: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
142: );
143: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
137: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
138: , pv_text_node_value => lv_usage_name
139: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
140: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
141: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
142: );
143: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
145: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
139: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
140: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
141: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
142: );
143: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
145: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
146: );
147: EXCEPTION
140: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
141: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
142: );
143: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
145: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
146: );
147: EXCEPTION
148: WHEN OTHERS THEN
141: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
142: );
143: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
145: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
146: );
147: EXCEPTION
148: WHEN OTHERS THEN
149: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
160:
161: IF (ln_row_count = 0)
162: THEN
163:
164: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ASSET_USAGE',
165: Ja_Cn_Utility.GV_MODULE_FA);
166:
167: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
168: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
161: IF (ln_row_count = 0)
162: THEN
163:
164: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ASSET_USAGE',
165: Ja_Cn_Utility.GV_MODULE_FA);
166:
167: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
168: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
169: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
163:
164: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ASSET_USAGE',
165: Ja_Cn_Utility.GV_MODULE_FA);
166:
167: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
168: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
169: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
170: );
171: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
164: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ASSET_USAGE',
165: Ja_Cn_Utility.GV_MODULE_FA);
166:
167: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
168: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
169: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
170: );
171: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
172: , pv_text_node_value => NULL
165: Ja_Cn_Utility.GV_MODULE_FA);
166:
167: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
168: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
169: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
170: );
171: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
172: , pv_text_node_value => NULL
173: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
167: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
168: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
169: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
170: );
171: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
172: , pv_text_node_value => NULL
173: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
174: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
175: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
169: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
170: );
171: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
172: , pv_text_node_value => NULL
173: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
174: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
175: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
176: );
177: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
170: );
171: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
172: , pv_text_node_value => NULL
173: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
174: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
175: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
176: );
177: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
178: , pv_text_node_value => NULL
171: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'
172: , pv_text_node_value => NULL
173: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
174: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
175: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
176: );
177: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
178: , pv_text_node_value => NULL
179: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
173: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
174: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
175: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
176: );
177: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
178: , pv_text_node_value => NULL
179: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
180: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
181: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
175: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
176: );
177: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
178: , pv_text_node_value => NULL
179: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
180: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
181: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
182: );
183: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
176: );
177: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
178: , pv_text_node_value => NULL
179: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
180: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
181: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
182: );
183: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
184: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
177: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'
178: , pv_text_node_value => NULL
179: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
180: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
181: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
182: );
183: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
184: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
185: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
179: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
180: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
181: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
182: );
183: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
184: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
185: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
186: );
187: END IF; --(ln_row_count = 0)
180: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
181: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
182: );
183: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
184: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
185: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
186: );
187: END IF; --(ln_row_count = 0)
188: --logging for debug
181: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
182: );
183: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'
184: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
185: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
186: );
187: END IF; --(ln_row_count = 0)
188: --logging for debug
189: IF (ln_proc_level>=ln_dbg_level)