145: FOR v_row IN cash_flow_item_detail_cur(lv_added_zero
146: ,pn_cfs_report_id
147: ,pn_chart_of_account_id)
148: LOOP
149: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
150: ,Ja_Cn_Utility.GV_TAG_TYPE_START
151: );
152: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER'
153: ,v_row.CFI_NUM
146: ,pn_cfs_report_id
147: ,pn_chart_of_account_id)
148: LOOP
149: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
150: ,Ja_Cn_Utility.GV_TAG_TYPE_START
151: );
152: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER'
153: ,v_row.CFI_NUM
154: );
148: LOOP
149: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
150: ,Ja_Cn_Utility.GV_TAG_TYPE_START
151: );
152: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER'
153: ,v_row.CFI_NUM
154: );
155: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NAME',
156: v_row.CFI_NAME);
151: );
152: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER'
153: ,v_row.CFI_NUM
154: );
155: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NAME',
156: v_row.CFI_NAME);
157: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_DESCRIPTION'
158: ,v_row.CFI_DESC
159: );
153: ,v_row.CFI_NUM
154: );
155: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NAME',
156: v_row.CFI_NAME);
157: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_DESCRIPTION'
158: ,v_row.CFI_DESC
159: );
160: Ja_Cn_Utility.Add_Fixed_Child_Node('IS_THE_LAST_LEVEL'
161: ,v_row.IS_LAST_LEVEL
156: v_row.CFI_NAME);
157: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_DESCRIPTION'
158: ,v_row.CFI_DESC
159: );
160: Ja_Cn_Utility.Add_Fixed_Child_Node('IS_THE_LAST_LEVEL'
161: ,v_row.IS_LAST_LEVEL
162: ,1
163: );
164: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_LEVEL'
160: Ja_Cn_Utility.Add_Fixed_Child_Node('IS_THE_LAST_LEVEL'
161: ,v_row.IS_LAST_LEVEL
162: ,1
163: );
164: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_LEVEL'
165: ,v_row.CFI_LEVEL
166: );
167: Ja_Cn_Utility.Add_Child_Node('PARENT_CASH_FLOW_ITEM_NUMBER'
168: ,v_row.PARENT_CFI_LEVEL
163: );
164: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_LEVEL'
165: ,v_row.CFI_LEVEL
166: );
167: Ja_Cn_Utility.Add_Child_Node('PARENT_CASH_FLOW_ITEM_NUMBER'
168: ,v_row.PARENT_CFI_LEVEL
169: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
170: ,Ja_Cn_Utility.GV_REQUIRED_NO
171: );
165: ,v_row.CFI_LEVEL
166: );
167: Ja_Cn_Utility.Add_Child_Node('PARENT_CASH_FLOW_ITEM_NUMBER'
168: ,v_row.PARENT_CFI_LEVEL
169: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
170: ,Ja_Cn_Utility.GV_REQUIRED_NO
171: );
172: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_SOURCE'
173: ,v_row.CFI_SOURCE
166: );
167: Ja_Cn_Utility.Add_Child_Node('PARENT_CASH_FLOW_ITEM_NUMBER'
168: ,v_row.PARENT_CFI_LEVEL
169: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
170: ,Ja_Cn_Utility.GV_REQUIRED_NO
171: );
172: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_SOURCE'
173: ,v_row.CFI_SOURCE
174: ,1
168: ,v_row.PARENT_CFI_LEVEL
169: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
170: ,Ja_Cn_Utility.GV_REQUIRED_NO
171: );
172: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_SOURCE'
173: ,v_row.CFI_SOURCE
174: ,1
175: );
176: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE'
172: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_SOURCE'
173: ,v_row.CFI_SOURCE
174: ,1
175: );
176: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE'
177: ,v_row.CFI_ATTRIBUTE
178: ,1
179: );
180: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
176: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE'
177: ,v_row.CFI_ATTRIBUTE
178: ,1
179: );
180: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
181: ,Ja_Cn_Utility.GV_TAG_TYPE_END
182: );
183: ln_rec_count := ln_rec_count + 1;
184:
177: ,v_row.CFI_ATTRIBUTE
178: ,1
179: );
180: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
181: ,Ja_Cn_Utility.GV_TAG_TYPE_END
182: );
183: ln_rec_count := ln_rec_count + 1;
184:
185: END LOOP;
200: -- no need to handle if minOccurs=0 specified in xml schema
201: IF ln_rec_count = 0
202: THEN
203: --Begin: Added for bug# 9722570
204: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CASH_FLOW_ITEMS');
205: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
206: ,Ja_Cn_Utility.GV_TAG_TYPE_START
207: );
208: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER'
201: IF ln_rec_count = 0
202: THEN
203: --Begin: Added for bug# 9722570
204: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CASH_FLOW_ITEMS');
205: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
206: ,Ja_Cn_Utility.GV_TAG_TYPE_START
207: );
208: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER'
209: ,NULL
202: THEN
203: --Begin: Added for bug# 9722570
204: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CASH_FLOW_ITEMS');
205: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
206: ,Ja_Cn_Utility.GV_TAG_TYPE_START
207: );
208: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER'
209: ,NULL
210: );
204: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CASH_FLOW_ITEMS');
205: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
206: ,Ja_Cn_Utility.GV_TAG_TYPE_START
207: );
208: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER'
209: ,NULL
210: );
211: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NAME'
212: ,NULL
207: );
208: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER'
209: ,NULL
210: );
211: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NAME'
212: ,NULL
213: );
214: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_DESCRIPTION'
215: ,NULL
210: );
211: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NAME'
212: ,NULL
213: );
214: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_DESCRIPTION'
215: ,NULL
216: );
217: Ja_Cn_Utility.Add_Fixed_Child_Node('IS_THE_LAST_LEVEL'
218: ,NULL
213: );
214: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_DESCRIPTION'
215: ,NULL
216: );
217: Ja_Cn_Utility.Add_Fixed_Child_Node('IS_THE_LAST_LEVEL'
218: ,NULL
219: ,1
220: );
221: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_LEVEL'
217: Ja_Cn_Utility.Add_Fixed_Child_Node('IS_THE_LAST_LEVEL'
218: ,NULL
219: ,1
220: );
221: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_LEVEL'
222: ,NULL
223: );
224: Ja_Cn_Utility.Add_Child_Node('PARENT_CASH_FLOW_ITEM_NUMBER'
225: ,NULL
220: );
221: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_LEVEL'
222: ,NULL
223: );
224: Ja_Cn_Utility.Add_Child_Node('PARENT_CASH_FLOW_ITEM_NUMBER'
225: ,NULL
226: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
227: ,Ja_Cn_Utility.GV_REQUIRED_NO
228: );
222: ,NULL
223: );
224: Ja_Cn_Utility.Add_Child_Node('PARENT_CASH_FLOW_ITEM_NUMBER'
225: ,NULL
226: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
227: ,Ja_Cn_Utility.GV_REQUIRED_NO
228: );
229: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_SOURCE'
230: ,NULL
223: );
224: Ja_Cn_Utility.Add_Child_Node('PARENT_CASH_FLOW_ITEM_NUMBER'
225: ,NULL
226: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
227: ,Ja_Cn_Utility.GV_REQUIRED_NO
228: );
229: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_SOURCE'
230: ,NULL
231: ,1
225: ,NULL
226: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
227: ,Ja_Cn_Utility.GV_REQUIRED_NO
228: );
229: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_SOURCE'
230: ,NULL
231: ,1
232: );
233: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE'
229: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_SOURCE'
230: ,NULL
231: ,1
232: );
233: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE'
234: ,NULL
235: ,1
236: );
237: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
233: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE'
234: ,NULL
235: ,1
236: );
237: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
238: ,Ja_Cn_Utility.GV_TAG_TYPE_END
239: );
240: --End: Added for bug# 9722570
241: --Get cfs report name for error message
234: ,NULL
235: ,1
236: );
237: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_ITEMS'
238: ,Ja_Cn_Utility.GV_TAG_TYPE_END
239: );
240: --End: Added for bug# 9722570
241: --Get cfs report name for error message
242: BEGIN
280: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
281: 'exception',
282: 'No data for Cash Flow Items');
283: END IF; --ln_proc_level>=ln_dbg_level
284: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CASH_FLOW_ITEMS');
285: RAISE;*/
286: --End: Deleted for bug# 9722570
287: WHEN OTHERS THEN
288: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)