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_SR_EXPORT_PKG dependencies on JA_CN_UTILITY

Line 103: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',

99: --Open and loop the Cursor to add the data to XML file
100: FOR v_row IN supplier_cur
101: LOOP
102: ln_row_count := ln_row_count + 1;
103: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
104: Ja_Cn_Utility.GV_TAG_TYPE_START);
105: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',
106: v_row.supplier_number);
107: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',

Line 104: Ja_Cn_Utility.GV_TAG_TYPE_START);

100: FOR v_row IN supplier_cur
101: LOOP
102: ln_row_count := ln_row_count + 1;
103: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
104: Ja_Cn_Utility.GV_TAG_TYPE_START);
105: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',
106: v_row.supplier_number);
107: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',
108: v_row.supplier_name);

Line 105: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',

101: LOOP
102: ln_row_count := ln_row_count + 1;
103: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
104: Ja_Cn_Utility.GV_TAG_TYPE_START);
105: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',
106: v_row.supplier_number);
107: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',
108: v_row.supplier_name);
109: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',

Line 107: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',

103: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
104: Ja_Cn_Utility.GV_TAG_TYPE_START);
105: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',
106: v_row.supplier_number);
107: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',
108: v_row.supplier_name);
109: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',
110: v_row.supplier_short_name);
111: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',

Line 109: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',

105: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',
106: v_row.supplier_number);
107: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',
108: v_row.supplier_name);
109: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',
110: v_row.supplier_short_name);
111: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
112: Ja_Cn_Utility.GV_TAG_TYPE_END);
113: END LOOP;

Line 111: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',

107: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',
108: v_row.supplier_name);
109: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',
110: v_row.supplier_short_name);
111: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
112: Ja_Cn_Utility.GV_TAG_TYPE_END);
113: END LOOP;
114:
115: -- To judge if the Cursor fetchs data. If the row count is 0 and the

Line 112: Ja_Cn_Utility.GV_TAG_TYPE_END);

108: v_row.supplier_name);
109: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',
110: v_row.supplier_short_name);
111: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
112: Ja_Cn_Utility.GV_TAG_TYPE_END);
113: END LOOP;
114:
115: -- To judge if the Cursor fetchs data. If the row count is 0 and the
116: -- minOccurs=0 specified in xml schema, then need to handle it and raise exception

Line 119: Ja_Cn_Utility.Print_No_Data_Found_For_Log('SUPPLIER_RECORD');

115: -- To judge if the Cursor fetchs data. If the row count is 0 and the
116: -- minOccurs=0 specified in xml schema, then need to handle it and raise exception
117: IF (ln_row_count = 0)
118: THEN
119: Ja_Cn_Utility.Print_No_Data_Found_For_Log('SUPPLIER_RECORD');
120:
121: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',

Line 121: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',

117: IF (ln_row_count = 0)
118: THEN
119: Ja_Cn_Utility.Print_No_Data_Found_For_Log('SUPPLIER_RECORD');
120:
121: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',
124: NULL);
125: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',

Line 122: Ja_Cn_Utility.GV_TAG_TYPE_START);

118: THEN
119: Ja_Cn_Utility.Print_No_Data_Found_For_Log('SUPPLIER_RECORD');
120:
121: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',
124: NULL);
125: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',
126: NULL);

Line 123: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',

119: Ja_Cn_Utility.Print_No_Data_Found_For_Log('SUPPLIER_RECORD');
120:
121: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',
124: NULL);
125: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',
126: NULL);
127: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',

Line 125: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',

121: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
122: Ja_Cn_Utility.GV_TAG_TYPE_START);
123: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',
124: NULL);
125: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',
126: NULL);
127: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',
128: NULL);
129: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',

Line 127: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',

123: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NUMBER',
124: NULL);
125: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',
126: NULL);
127: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',
128: NULL);
129: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
130: Ja_Cn_Utility.GV_TAG_TYPE_END);
131: END IF;

Line 129: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',

125: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_NAME',
126: NULL);
127: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',
128: NULL);
129: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
130: Ja_Cn_Utility.GV_TAG_TYPE_END);
131: END IF;
132:
133: --logging for debug

Line 130: Ja_Cn_Utility.GV_TAG_TYPE_END);

126: NULL);
127: Ja_Cn_Utility.Add_Child_Node('SUPPLIER_SHORT_NAME',
128: NULL);
129: Ja_Cn_Utility.Add_Sub_Root_Node('SUPPLIER_RECORD',
130: Ja_Cn_Utility.GV_TAG_TYPE_END);
131: END IF;
132:
133: --logging for debug
134: IF (ln_proc_level >= ln_dbg_level)