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.CN_IMP_TRXAPI_PVT dependencies on CN_MESSAGE_PKG

Line 214: cn_message_pkg.begin_batch

210: FROM cn_imp_headers
211: WHERE imp_header_id = p_imp_header_id;
212:
213: -- open process audit batch
214: cn_message_pkg.begin_batch
215: ( x_process_type => l_imp_header.import_type_code,
216: x_parent_proc_audit_id => p_imp_header_id ,
217: x_process_audit_id => l_process_audit_id,
218: x_request_id => null,

Line 221: cn_message_pkg.write

217: x_process_audit_id => l_process_audit_id,
218: x_request_id => null,
219: p_org_id => p_org_id);
220:
221: cn_message_pkg.write
222: (p_message_text => 'TRXAPI: Start Transfer Data. imp_header_id = ' || To_char(p_imp_header_id),
223: p_message_type => 'MILESTONE');
224:
225: -- Get source column name list and target column dynamic sql statement

Line 242: cn_message_pkg.write

238: l_processed_row := l_processed_row + 1;
239: l_rev_class_id := NULL;
240: l_salesrep_id := NULL;
241:
242: cn_message_pkg.write
243: (p_message_text => 'TRXAPI:Record ' || To_char(l_processed_row) || ' imp_line_id = ' || To_char(l_trxapi_imp.imp_line_id),
244: p_message_type => 'DEBUG');
245:
246: -- -------- Checking for all required fields ----------------- --

Line 264: cn_message_pkg.write

260: CN_IMPORT_PVT.update_imp_headers
261: (p_imp_header_id => p_imp_header_id,
262: p_status_code => 'IMPORT_FAIL',
263: p_failed_row => l_failed_row);
264: cn_message_pkg.write
265: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
266: p_message_type => 'ERROR');
267: CN_IMPORT_PVT.write_error_rec
268: (p_imp_header_id => p_imp_header_id,

Line 298: cn_message_pkg.write

294: CN_IMPORT_PVT.update_imp_headers
295: (p_imp_header_id => p_imp_header_id,
296: p_status_code => 'IMPORT_FAIL',
297: p_failed_row => l_failed_row);
298: cn_message_pkg.write
299: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
300: p_message_type => 'ERROR');
301: CN_IMPORT_PVT.write_error_rec
302: (p_imp_header_id => p_imp_header_id,

Line 333: cn_message_pkg.write

329: CN_IMPORT_PVT.update_imp_headers
330: (p_imp_header_id => p_imp_header_id,
331: p_status_code => 'IMPORT_FAIL',
332: p_failed_row => l_failed_row);
333: cn_message_pkg.write
334: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
335: p_message_type => 'ERROR');
336: CN_IMPORT_PVT.write_error_rec
337: (p_imp_header_id => p_imp_header_id,

Line 367: cn_message_pkg.write

363: CN_IMPORT_PVT.update_imp_headers
364: (p_imp_header_id => p_imp_header_id,
365: p_status_code => 'IMPORT_FAIL',
366: p_failed_row => l_failed_row);
367: cn_message_pkg.write
368: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
369: p_message_type => 'ERROR');
370: CN_IMPORT_PVT.write_error_rec
371: (p_imp_header_id => p_imp_header_id,

Line 404: cn_message_pkg.write

400: CN_IMPORT_PVT.update_imp_headers
401: (p_imp_header_id => p_imp_header_id,
402: p_status_code => 'IMPORT_FAIL',
403: p_failed_row => l_failed_row);
404: cn_message_pkg.write
405: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
406: p_message_type => 'ERROR');
407: CN_IMPORT_PVT.write_error_rec
408: (p_imp_header_id => p_imp_header_id,

Line 442: cn_message_pkg.write

438: CN_IMPORT_PVT.update_imp_headers
439: (p_imp_header_id => p_imp_header_id,
440: p_status_code => 'IMPORT_FAIL',
441: p_failed_row => l_failed_row);
442: cn_message_pkg.write
443: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
444: p_message_type => 'ERROR');
445: CN_IMPORT_PVT.write_error_rec
446: (p_imp_header_id => p_imp_header_id,

Line 474: cn_message_pkg.write

470: CN_IMPORT_PVT.update_imp_headers
471: (p_imp_header_id => p_imp_header_id,
472: p_status_code => 'IMPORT_FAIL',
473: p_failed_row => l_failed_row);
474: cn_message_pkg.write
475: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
476: p_message_type => 'ERROR');
477: CN_IMPORT_PVT.write_error_rec
478: (p_imp_header_id => p_imp_header_id,

Line 511: cn_message_pkg.write

507: CN_IMPORT_PVT.update_imp_headers
508: (p_imp_header_id => p_imp_header_id,
509: p_status_code => 'IMPORT_FAIL',
510: p_failed_row => l_failed_row);
511: cn_message_pkg.write
512: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
513: p_message_type => 'ERROR');
514: CN_IMPORT_PVT.write_error_rec
515: (p_imp_header_id => p_imp_header_id,

Line 545: cn_message_pkg.write

541: CN_IMPORT_PVT.update_imp_headers
542: (p_imp_header_id => p_imp_header_id,
543: p_status_code => 'IMPORT_FAIL',
544: p_failed_row => l_failed_row);
545: cn_message_pkg.write
546: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
547: p_message_type => 'ERROR');
548: CN_IMPORT_PVT.write_error_rec
549: (p_imp_header_id => p_imp_header_id,

Line 578: cn_message_pkg.write

574: CN_IMPORT_PVT.update_imp_headers
575: (p_imp_header_id => p_imp_header_id,
576: p_status_code => 'IMPORT_FAIL',
577: p_failed_row => l_failed_row);
578: cn_message_pkg.write
579: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
580: p_message_type => 'ERROR');
581: CN_IMPORT_PVT.write_error_rec
582: (p_imp_header_id => p_imp_header_id,

Line 611: cn_message_pkg.write

607: CN_IMPORT_PVT.update_imp_headers
608: (p_imp_header_id => p_imp_header_id,
609: p_status_code => 'IMPORT_FAIL',
610: p_failed_row => l_failed_row);
611: cn_message_pkg.write
612: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
613: p_message_type => 'ERROR');
614: CN_IMPORT_PVT.write_error_rec
615: (p_imp_header_id => p_imp_header_id,

Line 648: cn_message_pkg.write

644: CN_IMPORT_PVT.update_imp_headers
645: (p_imp_header_id => p_imp_header_id,
646: p_status_code => 'IMPORT_FAIL',
647: p_failed_row => l_failed_row);
648: cn_message_pkg.write
649: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
650: p_message_type => 'ERROR');
651: CN_IMPORT_PVT.write_error_rec
652: (p_imp_header_id => p_imp_header_id,

Line 697: cn_message_pkg.write

693: (p_imp_header_id => p_imp_header_id,
694: p_status_code => 'IMPORT_FAIL',
695: p_failed_row => l_failed_row);
696:
697: cn_message_pkg.write
698: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
699: p_message_type => 'ERROR');
700:
701: CN_IMPORT_PVT.write_error_rec

Line 730: cn_message_pkg.write

726: (p_imp_header_id => p_imp_header_id,
727: p_status_code => 'IMPORT_FAIL',
728: p_failed_row => l_failed_row);
729:
730: cn_message_pkg.write
731: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
732: p_message_type => 'ERROR');
733:
734: CN_IMPORT_PVT.write_error_rec

Line 765: cn_message_pkg.write

761: (p_imp_header_id => p_imp_header_id,
762: p_status_code => 'IMPORT_FAIL',
763: p_failed_row => l_failed_row);
764:
765: cn_message_pkg.write
766: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
767: p_message_type => 'ERROR');
768:
769: CN_IMPORT_PVT.write_error_rec

Line 1079: cn_message_pkg.write

1075: (p_imp_line_id => l_trxapi_imp.imp_line_id,
1076: p_status_code => 'COMPLETE',
1077: p_error_code => l_error_code);
1078:
1079: cn_message_pkg.write
1080: (p_message_text => 'TRXAPI:Import completed. comm_lines_api_id = ' || To_char(l_comm_lines_api_id),
1081: p_message_type => 'DEBUG');
1082:
1083: << end_loop>>

Line 1107: cn_message_pkg.write

1103: (p_imp_header_id => p_imp_header_id,
1104: p_status_code => 'IMPORT_FAIL',
1105: p_processed_row => l_processed_row,
1106: p_failed_row => l_failed_row);
1107: cn_message_pkg.write
1108: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
1109: p_message_type => 'ERROR');
1110: CN_IMPORT_PVT.write_error_rec
1111: (p_imp_header_id => p_imp_header_id,

Line 1133: cn_message_pkg.write

1129: p_processed_row => l_processed_row,
1130: p_failed_row => l_failed_row);
1131: END IF;
1132:
1133: cn_message_pkg.write
1134: (p_message_text => 'TRXAPI: End Transfer Data. imp_header_id = ' || To_char(p_imp_header_id),
1135: p_message_type => 'MILESTONE');
1136:
1137: -- close process batch

Line 1138: cn_message_pkg.end_batch(l_process_audit_id);

1134: (p_message_text => 'TRXAPI: End Transfer Data. imp_header_id = ' || To_char(p_imp_header_id),
1135: p_message_type => 'MILESTONE');
1136:
1137: -- close process batch
1138: cn_message_pkg.end_batch(l_process_audit_id);
1139:
1140: -- Commit all imports
1141: COMMIT;
1142:

Line 1146: cn_message_pkg.end_batch(l_process_audit_id);

1142:
1143: EXCEPTION
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: retcode := 2 ;
1146: cn_message_pkg.end_batch(l_process_audit_id);
1147: FND_MSG_PUB.count_and_get
1148: (p_count => l_msg_count ,
1149: p_data => errbuf ,
1150: p_encoded => FND_API.G_FALSE

Line 1170: cn_message_pkg.set_error(l_api_name,errbuf);

1166: p_data => errbuf ,
1167: p_encoded => FND_API.G_FALSE
1168: );
1169: END IF;
1170: cn_message_pkg.set_error(l_api_name,errbuf);
1171: cn_message_pkg.end_batch(l_process_audit_id);
1172:
1173: END Trxapi_Import;
1174:

Line 1171: cn_message_pkg.end_batch(l_process_audit_id);

1167: p_encoded => FND_API.G_FALSE
1168: );
1169: END IF;
1170: cn_message_pkg.set_error(l_api_name,errbuf);
1171: cn_message_pkg.end_batch(l_process_audit_id);
1172:
1173: END Trxapi_Import;
1174:
1175: END CN_IMP_TRXAPI_PVT;