109: ln_row_count := 0;
110: FOR v_row IN exchange_rate_types_cur(pn_legal_entity_id,
111: pn_accounting_year) LOOP
112: ln_row_count := ln_row_count + 1;
113: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
114: Ja_Cn_Utility.GV_TAG_TYPE_START);
115: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER',
116: v_row.Conversion_Type);
117: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME',
110: FOR v_row IN exchange_rate_types_cur(pn_legal_entity_id,
111: pn_accounting_year) LOOP
112: ln_row_count := ln_row_count + 1;
113: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
114: Ja_Cn_Utility.GV_TAG_TYPE_START);
115: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER',
116: v_row.Conversion_Type);
117: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME',
118: v_row.User_Conversion_Type);
111: pn_accounting_year) LOOP
112: ln_row_count := ln_row_count + 1;
113: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
114: Ja_Cn_Utility.GV_TAG_TYPE_START);
115: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER',
116: v_row.Conversion_Type);
117: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME',
118: v_row.User_Conversion_Type);
119: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
113: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
114: Ja_Cn_Utility.GV_TAG_TYPE_START);
115: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER',
116: v_row.Conversion_Type);
117: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME',
118: v_row.User_Conversion_Type);
119: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
120: Ja_Cn_Utility.GV_TAG_TYPE_END);
121:
115: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER',
116: v_row.Conversion_Type);
117: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME',
118: v_row.User_Conversion_Type);
119: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
120: Ja_Cn_Utility.GV_TAG_TYPE_END);
121:
122: END LOOP;
123:
116: v_row.Conversion_Type);
117: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME',
118: v_row.User_Conversion_Type);
119: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
120: Ja_Cn_Utility.GV_TAG_TYPE_END);
121:
122: END LOOP;
123:
124: IF (ln_row_count = 0) THEN
121:
122: END LOOP;
123:
124: IF (ln_row_count = 0) THEN
125: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EXCHANGE_RATE_TYPE');
126: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
127: Ja_Cn_Utility.GV_TAG_TYPE_START);
128: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER', NULL);
129: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME', NULL);
122: END LOOP;
123:
124: IF (ln_row_count = 0) THEN
125: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EXCHANGE_RATE_TYPE');
126: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
127: Ja_Cn_Utility.GV_TAG_TYPE_START);
128: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER', NULL);
129: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME', NULL);
130: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
123:
124: IF (ln_row_count = 0) THEN
125: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EXCHANGE_RATE_TYPE');
126: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
127: Ja_Cn_Utility.GV_TAG_TYPE_START);
128: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER', NULL);
129: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME', NULL);
130: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
131: Ja_Cn_Utility.GV_TAG_TYPE_END);
124: IF (ln_row_count = 0) THEN
125: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EXCHANGE_RATE_TYPE');
126: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
127: Ja_Cn_Utility.GV_TAG_TYPE_START);
128: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER', NULL);
129: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME', NULL);
130: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
131: Ja_Cn_Utility.GV_TAG_TYPE_END);
132:
125: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EXCHANGE_RATE_TYPE');
126: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
127: Ja_Cn_Utility.GV_TAG_TYPE_START);
128: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER', NULL);
129: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME', NULL);
130: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
131: Ja_Cn_Utility.GV_TAG_TYPE_END);
132:
133: END IF; --ln_row_count = 0
126: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
127: Ja_Cn_Utility.GV_TAG_TYPE_START);
128: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER', NULL);
129: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME', NULL);
130: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
131: Ja_Cn_Utility.GV_TAG_TYPE_END);
132:
133: END IF; --ln_row_count = 0
134: --logging for debug
127: Ja_Cn_Utility.GV_TAG_TYPE_START);
128: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NUMBER', NULL);
129: Ja_Cn_Utility.Add_Child_Node('EXCHANGE_RATE_TYPE_NAME', NULL);
130: Ja_Cn_Utility.Add_Sub_Root_Node('EXCHANGE_RATE_TYPE',
131: Ja_Cn_Utility.GV_TAG_TYPE_END);
132:
133: END IF; --ln_row_count = 0
134: --logging for debug
135: IF (ln_proc_level >= ln_dbg_level) THEN