APPS.CN_IMP_REV_CL_PVT dependencies on CN_MESSAGE_PKG

Line 94: cn_message_pkg.begin_batch

90: FROM cn_imp_headers
91: WHERE imp_header_id = p_imp_header_id;
92:
93: -- open process audit batch
94: cn_message_pkg.begin_batch
95: ( x_process_type => l_imp_header.import_type_code,
96: x_parent_proc_audit_id => p_imp_header_id ,
97: x_process_audit_id => l_process_audit_id,
98: x_request_id => null,

Line 101: cn_message_pkg.write

97: x_process_audit_id => l_process_audit_id,
98: x_request_id => null,
99: p_org_id => p_org_id);
100:
101: cn_message_pkg.write
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

Line 118: cn_message_pkg.debug('REVCL:Record ' || To_char(l_processed_row) || ' imp_line_id = ' || To_char(l_rev_cl_imp.imp_line_id));

114: EXIT WHEN c_rev_cl_imp_csr%notfound;
115:
116: l_processed_row := l_processed_row + 1;
117:
118: cn_message_pkg.debug('REVCL:Record ' || To_char(l_processed_row) || ' imp_line_id = ' || To_char(l_rev_cl_imp.imp_line_id));
119: -- -------- Checking for all required fields ----------------- --
120: -- Check required field
121:
122: -- insert into cn_comm_lines_api

Line 154: cn_message_pkg.write

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);
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,

Line 176: cn_message_pkg.debug('REVCL:Import completed. revenue_classes_id = ' || To_char(l_revenue_class_id));

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));
177: end;
178: end if;
179: << end_loop>>
180: NULL;

Line 195: cn_message_pkg.write

191: p_processed_row => l_processed_row,
192: p_failed_row => l_failed_row);
193: END IF;
194:
195: cn_message_pkg.write
196: (p_message_text => 'REVCL: End Transfer Data. imp_header_id = ' || To_char(p_imp_header_id),
197: p_message_type => 'MILESTONE');
198:
199: -- close process batch

Line 200: cn_message_pkg.end_batch(l_process_audit_id);

196: (p_message_text => 'REVCL: End Transfer Data. imp_header_id = ' || To_char(p_imp_header_id),
197: p_message_type => 'MILESTONE');
198:
199: -- close process batch
200: cn_message_pkg.end_batch(l_process_audit_id);
201:
202: -- Commit all imports
203: COMMIT;
204: