DBA Data[Home] [Help]

APPS.CN_IMP_REV_CL_PVT dependencies on CN_IMPORT_PVT

Line 106: CN_IMPORT_PVT.build_error_rec

102: (p_message_text => 'REVCL: Start Transfer Data. imp_header_id = ' || To_char(p_imp_header_id),
103: p_message_type => 'MILESTONE');
104:
105: -- Get source column name list and target column dynamic sql statement
106: CN_IMPORT_PVT.build_error_rec
107: (p_imp_header_id => p_imp_header_id,
108: x_header_list => l_header_list,
109: x_sql_stmt => l_sql_stmt);
110:

Line 145: CN_IMPORT_PVT.update_imp_lines

141: if (l_return_status = FND_API.G_RET_STS_ERROR) then
142: begin
143:
144: l_failed_row := l_failed_row + 1;
145: CN_IMPORT_PVT.update_imp_lines
146: (p_imp_line_id => l_rev_cl_imp.imp_line_id,
147: p_status_code => 'FAIL',
148: p_error_code => l_loading_status);
149: CN_IMPORT_PVT.update_imp_headers

Line 149: CN_IMPORT_PVT.update_imp_headers

145: CN_IMPORT_PVT.update_imp_lines
146: (p_imp_line_id => l_rev_cl_imp.imp_line_id,
147: p_status_code => 'FAIL',
148: p_error_code => l_loading_status);
149: CN_IMPORT_PVT.update_imp_headers
150: (p_imp_header_id => p_imp_header_id,
151: p_status_code => 'IMPORT_FAIL',
152: p_processed_row => l_processed_row,
153: p_failed_row => l_failed_row);

Line 157: CN_IMPORT_PVT.write_error_rec

153: p_failed_row => l_failed_row);
154: cn_message_pkg.write
155: (p_message_text => l_msg_data,
156: p_message_type => 'ERROR');
157: CN_IMPORT_PVT.write_error_rec
158: (p_imp_header_id => p_imp_header_id,
159: p_imp_line_id => l_rev_cl_imp.imp_line_id,
160: p_header_list => l_header_list,
161: p_sql_stmt => l_sql_stmt);

Line 172: CN_IMPORT_PVT.update_imp_lines

168: else
169:
170: begin
171: l_error_code := '';
172: CN_IMPORT_PVT.update_imp_lines
173: (p_imp_line_id => l_rev_cl_imp.imp_line_id,
174: p_status_code => 'COMPLETE',
175: p_error_code => l_error_code);
176: cn_message_pkg.debug('REVCL:Import completed. revenue_classes_id = ' || To_char(l_revenue_class_id));

Line 188: CN_IMPORT_PVT.update_imp_headers

184: END IF;
185: CLOSE c_rev_cl_imp_csr;
186: IF l_failed_row = 0 AND retcode = 0 THEN
187: -- update update_imp_headers
188: CN_IMPORT_PVT.update_imp_headers
189: (p_imp_header_id => p_imp_header_id,
190: p_status_code => 'COMPLETE',
191: p_processed_row => l_processed_row,
192: p_failed_row => l_failed_row);