106: 'pn_accounting_year=' || pn_accounting_year);
107: ln_row_count := 0;
108: FOR v_row IN Currencies_cur(pn_legal_entity_id, pn_accounting_year) LOOP
109: ln_row_count := ln_row_count + 1;
110: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
111: Ja_Cn_Utility.GV_TAG_TYPE_START);
112: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', v_row.currency_code);
113: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', v_row.name);
114: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
107: ln_row_count := 0;
108: FOR v_row IN Currencies_cur(pn_legal_entity_id, pn_accounting_year) LOOP
109: ln_row_count := ln_row_count + 1;
110: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
111: Ja_Cn_Utility.GV_TAG_TYPE_START);
112: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', v_row.currency_code);
113: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', v_row.name);
114: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
115: Ja_Cn_Utility.GV_TAG_TYPE_END);
108: FOR v_row IN Currencies_cur(pn_legal_entity_id, pn_accounting_year) LOOP
109: ln_row_count := ln_row_count + 1;
110: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
111: Ja_Cn_Utility.GV_TAG_TYPE_START);
112: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', v_row.currency_code);
113: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', v_row.name);
114: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
115: Ja_Cn_Utility.GV_TAG_TYPE_END);
116:
109: ln_row_count := ln_row_count + 1;
110: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
111: Ja_Cn_Utility.GV_TAG_TYPE_START);
112: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', v_row.currency_code);
113: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', v_row.name);
114: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
115: Ja_Cn_Utility.GV_TAG_TYPE_END);
116:
117: END LOOP;
110: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
111: Ja_Cn_Utility.GV_TAG_TYPE_START);
112: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', v_row.currency_code);
113: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', v_row.name);
114: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
115: Ja_Cn_Utility.GV_TAG_TYPE_END);
116:
117: END LOOP;
118:
111: Ja_Cn_Utility.GV_TAG_TYPE_START);
112: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', v_row.currency_code);
113: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', v_row.name);
114: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
115: Ja_Cn_Utility.GV_TAG_TYPE_END);
116:
117: END LOOP;
118:
119: IF (ln_row_count = 0) THEN
116:
117: END LOOP;
118:
119: IF (ln_row_count = 0) THEN
120: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CURRENCY');
121: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
124: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', NULL);
117: END LOOP;
118:
119: IF (ln_row_count = 0) THEN
120: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CURRENCY');
121: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
124: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', NULL);
125: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
118:
119: IF (ln_row_count = 0) THEN
120: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CURRENCY');
121: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
124: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', NULL);
125: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
126: Ja_Cn_Utility.GV_TAG_TYPE_END);
119: IF (ln_row_count = 0) THEN
120: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CURRENCY');
121: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
124: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', NULL);
125: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
126: Ja_Cn_Utility.GV_TAG_TYPE_END);
127: END IF; --ln_row_count = 0
120: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CURRENCY');
121: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
124: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', NULL);
125: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
126: Ja_Cn_Utility.GV_TAG_TYPE_END);
127: END IF; --ln_row_count = 0
128: --logging for debug
121: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
124: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', NULL);
125: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
126: Ja_Cn_Utility.GV_TAG_TYPE_END);
127: END IF; --ln_row_count = 0
128: --logging for debug
129: IF (ln_proc_level >= ln_dbg_level) THEN
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
124: Ja_Cn_Utility.Add_Child_Node('CURRENCY_NAME', NULL);
125: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENCY',
126: Ja_Cn_Utility.GV_TAG_TYPE_END);
127: END IF; --ln_row_count = 0
128: --logging for debug
129: IF (ln_proc_level >= ln_dbg_level) THEN
130: FND_LOG.STRING(ln_proc_level,