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 215: cn_message_pkg.begin_batch

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

Line 222: cn_message_pkg.write

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

Line 243: cn_message_pkg.write

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

Line 265: cn_message_pkg.write

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

Line 299: cn_message_pkg.write

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

Line 334: cn_message_pkg.write

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

Line 368: cn_message_pkg.write

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

Line 405: cn_message_pkg.write

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

Line 443: cn_message_pkg.write

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

Line 475: cn_message_pkg.write

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

Line 512: cn_message_pkg.write

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

Line 546: cn_message_pkg.write

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

Line 579: cn_message_pkg.write

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

Line 612: cn_message_pkg.write

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

Line 649: cn_message_pkg.write

645: CN_IMPORT_PVT.update_imp_headers
646: (p_imp_header_id => p_imp_header_id,
647: p_status_code => 'IMPORT_FAIL',
648: p_failed_row => l_failed_row);
649: cn_message_pkg.write
650: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
651: p_message_type => 'ERROR');
652: CN_IMPORT_PVT.write_error_rec
653: (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 820: cn_message_pkg.write

816: (p_imp_header_id => p_imp_header_id,
817: p_status_code => 'IMPORT_FAIL',
818: p_failed_row => l_failed_row);
819:
820: cn_message_pkg.write
821: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
822: p_message_type => 'ERROR');
823:
824: CN_IMPORT_PVT.write_error_rec

Line 1137: cn_message_pkg.write

1133: (p_imp_line_id => l_trxapi_imp.imp_line_id,
1134: p_status_code => 'COMPLETE',
1135: p_error_code => l_error_code);
1136:
1137: cn_message_pkg.write
1138: (p_message_text => 'TRXAPI:Import completed. comm_lines_api_id = ' || To_char(l_comm_lines_api_id),
1139: p_message_type => 'DEBUG');
1140:
1141: << end_loop>>

Line 1165: cn_message_pkg.write

1161: (p_imp_header_id => p_imp_header_id,
1162: p_status_code => 'IMPORT_FAIL',
1163: p_processed_row => l_processed_row,
1164: p_failed_row => l_failed_row);
1165: cn_message_pkg.write
1166: (p_message_text => 'Record ' || To_char(l_processed_row) || ':' || l_message,
1167: p_message_type => 'ERROR');
1168: CN_IMPORT_PVT.write_error_rec
1169: (p_imp_header_id => p_imp_header_id,

Line 1191: cn_message_pkg.write

1187: p_processed_row => l_processed_row,
1188: p_failed_row => l_failed_row);
1189: END IF;
1190:
1191: cn_message_pkg.write
1192: (p_message_text => 'TRXAPI: End Transfer Data. imp_header_id = ' || To_char(p_imp_header_id),
1193: p_message_type => 'MILESTONE');
1194:
1195: -- close process batch

Line 1196: cn_message_pkg.end_batch(l_process_audit_id);

1192: (p_message_text => 'TRXAPI: End Transfer Data. imp_header_id = ' || To_char(p_imp_header_id),
1193: p_message_type => 'MILESTONE');
1194:
1195: -- close process batch
1196: cn_message_pkg.end_batch(l_process_audit_id);
1197:
1198: -- Commit all imports
1199: COMMIT;
1200:

Line 1204: cn_message_pkg.end_batch(l_process_audit_id);

1200:
1201: EXCEPTION
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: retcode := 2 ;
1204: cn_message_pkg.end_batch(l_process_audit_id);
1205: FND_MSG_PUB.count_and_get
1206: (p_count => l_msg_count ,
1207: p_data => errbuf ,
1208: p_encoded => FND_API.G_FALSE

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

1224: p_data => errbuf ,
1225: p_encoded => FND_API.G_FALSE
1226: );
1227: END IF;
1228: cn_message_pkg.set_error(l_api_name,errbuf);
1229: cn_message_pkg.end_batch(l_process_audit_id);
1230:
1231: END Trxapi_Import;
1232:

Line 1229: cn_message_pkg.end_batch(l_process_audit_id);

1225: p_encoded => FND_API.G_FALSE
1226: );
1227: END IF;
1228: cn_message_pkg.set_error(l_api_name,errbuf);
1229: cn_message_pkg.end_batch(l_process_audit_id);
1230:
1231: END Trxapi_Import;
1232:
1233: END CN_IMP_TRXAPI_PVT;