DBA Data[Home] [Help]

APPS.JA_CN_FA_AU_EXPORT_PKG dependencies on JA_CN_UTILITY

Line 127: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'

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'

Line 128: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START

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

Line 129: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 131: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'

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

Line 133: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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'

Line 134: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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

Line 135: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 137: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'

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

Line 139: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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'

Line 140: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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

Line 141: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 143: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'

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

Line 144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END

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

Line 145: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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)

Line 164: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ASSET_USAGE',

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

Line 165: Ja_Cn_Utility.GV_MODULE_FA);

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

Line 167: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'

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'

Line 168: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START

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

Line 169: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 171: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_CODE'

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

Line 173: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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'

Line 174: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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

Line 175: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 177: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'USAGE_STATUS_NAME'

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

Line 179: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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'

Line 180: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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

Line 181: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 183: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'ASSET_USAGE'

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)

Line 184: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END

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

Line 185: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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)