eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_SM_EXPORT_PKG dependencies on JA_CN_UTILITY

Line 133: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',

129:
130: --Open and loop the Cursor to add the data to XML file
131: FOR v_row IN settlement_method_cur LOOP
132: ln_row_count := ln_row_count + 1;
133: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
134: Ja_Cn_Utility.GV_TAG_TYPE_START);
135: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER',
136: v_row.settlement_method_number);
137: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME',

Line 134: Ja_Cn_Utility.GV_TAG_TYPE_START);

130: --Open and loop the Cursor to add the data to XML file
131: FOR v_row IN settlement_method_cur LOOP
132: ln_row_count := ln_row_count + 1;
133: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
134: Ja_Cn_Utility.GV_TAG_TYPE_START);
135: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER',
136: v_row.settlement_method_number);
137: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME',
138: v_row.settlement_method_name);

Line 135: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER',

131: FOR v_row IN settlement_method_cur LOOP
132: ln_row_count := ln_row_count + 1;
133: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
134: Ja_Cn_Utility.GV_TAG_TYPE_START);
135: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER',
136: v_row.settlement_method_number);
137: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME',
138: v_row.settlement_method_name);
139: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',

Line 137: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME',

133: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
134: Ja_Cn_Utility.GV_TAG_TYPE_START);
135: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER',
136: v_row.settlement_method_number);
137: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME',
138: v_row.settlement_method_name);
139: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
140: Ja_Cn_Utility.GV_TAG_TYPE_END);
141: END LOOP;

Line 139: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',

135: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER',
136: v_row.settlement_method_number);
137: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME',
138: v_row.settlement_method_name);
139: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
140: Ja_Cn_Utility.GV_TAG_TYPE_END);
141: END LOOP;
142:
143: -- To judge if the Cursor fetchs data. If the row count is 0 and the

Line 140: Ja_Cn_Utility.GV_TAG_TYPE_END);

136: v_row.settlement_method_number);
137: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME',
138: v_row.settlement_method_name);
139: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
140: Ja_Cn_Utility.GV_TAG_TYPE_END);
141: END LOOP;
142:
143: -- To judge if the Cursor fetchs data. If the row count is 0 and the
144: -- minOccurs=0 specified in xml schema, then need to handle it and raise exception

Line 146: Ja_Cn_Utility.Print_No_Data_Found_For_Log('SETTLEMENT_METHOD');

142:
143: -- To judge if the Cursor fetchs data. If the row count is 0 and the
144: -- minOccurs=0 specified in xml schema, then need to handle it and raise exception
145: IF (ln_row_count = 0) THEN
146: Ja_Cn_Utility.Print_No_Data_Found_For_Log('SETTLEMENT_METHOD');
147:
148: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
149: Ja_Cn_Utility.GV_TAG_TYPE_START);
150: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER', NULL);

Line 148: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',

144: -- minOccurs=0 specified in xml schema, then need to handle it and raise exception
145: IF (ln_row_count = 0) THEN
146: Ja_Cn_Utility.Print_No_Data_Found_For_Log('SETTLEMENT_METHOD');
147:
148: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
149: Ja_Cn_Utility.GV_TAG_TYPE_START);
150: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER', NULL);
151: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME', NULL);
152: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',

Line 149: Ja_Cn_Utility.GV_TAG_TYPE_START);

145: IF (ln_row_count = 0) THEN
146: Ja_Cn_Utility.Print_No_Data_Found_For_Log('SETTLEMENT_METHOD');
147:
148: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
149: Ja_Cn_Utility.GV_TAG_TYPE_START);
150: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER', NULL);
151: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME', NULL);
152: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
153: Ja_Cn_Utility.GV_TAG_TYPE_END);

Line 150: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER', NULL);

146: Ja_Cn_Utility.Print_No_Data_Found_For_Log('SETTLEMENT_METHOD');
147:
148: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
149: Ja_Cn_Utility.GV_TAG_TYPE_START);
150: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER', NULL);
151: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME', NULL);
152: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
153: Ja_Cn_Utility.GV_TAG_TYPE_END);
154: END IF;

Line 151: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME', NULL);

147:
148: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
149: Ja_Cn_Utility.GV_TAG_TYPE_START);
150: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER', NULL);
151: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME', NULL);
152: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
153: Ja_Cn_Utility.GV_TAG_TYPE_END);
154: END IF;
155:

Line 152: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',

148: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
149: Ja_Cn_Utility.GV_TAG_TYPE_START);
150: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER', NULL);
151: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME', NULL);
152: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
153: Ja_Cn_Utility.GV_TAG_TYPE_END);
154: END IF;
155:
156: --logging for debug

Line 153: Ja_Cn_Utility.GV_TAG_TYPE_END);

149: Ja_Cn_Utility.GV_TAG_TYPE_START);
150: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NUMBER', NULL);
151: Ja_Cn_Utility.Add_Child_Node('SETTLEMENT_METHOD_NAME', NULL);
152: Ja_Cn_Utility.Add_Sub_Root_Node('SETTLEMENT_METHOD',
153: Ja_Cn_Utility.GV_TAG_TYPE_END);
154: END IF;
155:
156: --logging for debug
157: IF (ln_proc_level >= ln_dbg_level) THEN