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_IMPORT_PVT

Line 227: CN_IMPORT_PVT.build_error_rec

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
227: CN_IMPORT_PVT.build_error_rec
228: (p_imp_header_id => p_imp_header_id,
229: x_header_list => l_header_list,
230: x_sql_stmt => l_sql_stmt);
231:

Line 256: CN_IMPORT_PVT.update_imp_lines

252: OR l_trxapi_imp.revenue_type IS NULL THEN
253: l_failed_row := l_failed_row + 1;
254: l_error_code := 'CN_IMP_MISS_REQUIRED';
255: l_message := fnd_message.get_string('CN','CN_IMP_MISS_REQUIRED');
256: CN_IMPORT_PVT.update_imp_lines
257: (p_imp_line_id => l_trxapi_imp.imp_line_id,
258: p_status_code => 'FAIL',
259: p_error_code => l_error_code,
260: p_error_msg => l_message);

Line 261: CN_IMPORT_PVT.update_imp_headers

257: (p_imp_line_id => l_trxapi_imp.imp_line_id,
258: p_status_code => 'FAIL',
259: p_error_code => l_error_code,
260: p_error_msg => l_message);
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

Line 268: CN_IMPORT_PVT.write_error_rec

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,
270: p_imp_line_id => l_trxapi_imp.imp_line_id,
271: p_header_list => l_header_list,
272: p_sql_stmt => l_sql_stmt);

Line 290: CN_IMPORT_PVT.update_imp_lines

286: WHEN no_data_found THEN
287: l_failed_row := l_failed_row + 1;
288: l_error_code := 'CN_IMP_NF_RSRC_ID';
289: l_message := fnd_message.get_string('CN','CN_IMP_NF_RSRC_ID');
290: CN_IMPORT_PVT.update_imp_lines
291: (p_imp_line_id => l_trxapi_imp.imp_line_id,
292: p_status_code => 'FAIL',
293: p_error_code => l_error_code,
294: p_error_msg => l_message);

Line 295: CN_IMPORT_PVT.update_imp_headers

291: (p_imp_line_id => l_trxapi_imp.imp_line_id,
292: p_status_code => 'FAIL',
293: p_error_code => l_error_code,
294: p_error_msg => l_message);
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

Line 302: CN_IMPORT_PVT.write_error_rec

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,
304: p_imp_line_id => l_trxapi_imp.imp_line_id,
305: p_header_list => l_header_list,
306: p_sql_stmt => l_sql_stmt);

Line 325: CN_IMPORT_PVT.update_imp_lines

321: WHEN no_data_found THEN
322: l_failed_row := l_failed_row + 1;
323: l_error_code := 'NOT_WITHIN_OPEN_PERIODS';
324: l_message := fnd_message.get_string('CN','NOT_WITHIN_OPEN_PERIODS');
325: CN_IMPORT_PVT.update_imp_lines
326: (p_imp_line_id => l_trxapi_imp.imp_line_id,
327: p_status_code => 'FAIL',
328: p_error_code => l_error_code,
329: p_error_msg => l_message);

Line 330: CN_IMPORT_PVT.update_imp_headers

326: (p_imp_line_id => l_trxapi_imp.imp_line_id,
327: p_status_code => 'FAIL',
328: p_error_code => l_error_code,
329: p_error_msg => l_message);
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

Line 337: CN_IMPORT_PVT.write_error_rec

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,
339: p_imp_line_id => l_trxapi_imp.imp_line_id,
340: p_header_list => l_header_list,
341: p_sql_stmt => l_sql_stmt);

Line 359: CN_IMPORT_PVT.update_imp_lines

355: IF l_rev_class_id IS NULL THEN
356: l_failed_row := l_failed_row + 1;
357: l_error_code := 'CN_IMP_NF_REVCLS_ID';
358: l_message := fnd_message.get_string('CN','CN_IMP_NF_REVCLS_ID');
359: CN_IMPORT_PVT.update_imp_lines
360: (p_imp_line_id => l_trxapi_imp.imp_line_id,
361: p_status_code => 'FAIL',
362: p_error_code => l_error_code,
363: p_error_msg => l_message);

Line 364: CN_IMPORT_PVT.update_imp_headers

360: (p_imp_line_id => l_trxapi_imp.imp_line_id,
361: p_status_code => 'FAIL',
362: p_error_code => l_error_code,
363: p_error_msg => l_message);
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

Line 371: CN_IMPORT_PVT.write_error_rec

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,
373: p_imp_line_id => l_trxapi_imp.imp_line_id,
374: p_header_list => l_header_list,
375: p_sql_stmt => l_sql_stmt);

Line 396: CN_IMPORT_PVT.update_imp_lines

392: l_failed_row := l_failed_row + 1;
393: l_error_code := 'CN_IMP_NF_QUOTA';
394: l_message :=
395: fnd_message.get_string('CN','CN_IMP_NF_QUOTA');
396: CN_IMPORT_PVT.update_imp_lines
397: (p_imp_line_id => l_trxapi_imp.imp_line_id,
398: p_status_code => 'FAIL',
399: p_error_code => l_error_code,
400: p_error_msg => l_message);

Line 401: CN_IMPORT_PVT.update_imp_headers

397: (p_imp_line_id => l_trxapi_imp.imp_line_id,
398: p_status_code => 'FAIL',
399: p_error_code => l_error_code,
400: p_error_msg => l_message);
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

Line 408: CN_IMPORT_PVT.write_error_rec

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,
410: p_imp_line_id => l_trxapi_imp.imp_line_id,
411: p_header_list => l_header_list,
412: p_sql_stmt => l_sql_stmt);

Line 434: CN_IMPORT_PVT.update_imp_lines

430: l_failed_row := l_failed_row + 1;
431: l_error_code := 'CN_IMP_NF_CG';
432: l_message :=
433: fnd_message.get_string('CN','CN_IMP_NF_CG');
434: CN_IMPORT_PVT.update_imp_lines
435: (p_imp_line_id => l_trxapi_imp.imp_line_id,
436: p_status_code => 'FAIL',
437: p_error_code => l_error_code,
438: p_error_msg => l_message);

Line 439: CN_IMPORT_PVT.update_imp_headers

435: (p_imp_line_id => l_trxapi_imp.imp_line_id,
436: p_status_code => 'FAIL',
437: p_error_code => l_error_code,
438: p_error_msg => l_message);
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

Line 446: CN_IMPORT_PVT.write_error_rec

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,
448: p_imp_line_id => l_trxapi_imp.imp_line_id,
449: p_header_list => l_header_list,
450: p_sql_stmt => l_sql_stmt);

Line 466: CN_IMPORT_PVT.update_imp_lines

462: IF l_role_id IS NULL THEN
463: l_failed_row := l_failed_row + 1;
464: l_error_code := 'CN_IMP_NF_ROLE';
465: l_message := fnd_message.get_string('CN','CN_IMP_NF_ROLE');
466: CN_IMPORT_PVT.update_imp_lines
467: (p_imp_line_id => l_trxapi_imp.imp_line_id,
468: p_status_code => 'FAIL',
469: p_error_code => l_error_code,
470: p_error_msg => l_message);

Line 471: CN_IMPORT_PVT.update_imp_headers

467: (p_imp_line_id => l_trxapi_imp.imp_line_id,
468: p_status_code => 'FAIL',
469: p_error_code => l_error_code,
470: p_error_msg => l_message);
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

Line 478: CN_IMPORT_PVT.write_error_rec

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,
480: p_imp_line_id => l_trxapi_imp.imp_line_id,
481: p_header_list => l_header_list,
482: p_sql_stmt => l_sql_stmt);

Line 503: CN_IMPORT_PVT.update_imp_lines

499: l_failed_row := l_failed_row + 1;
500: l_error_code := 'CN_IMP_NF_ROLLUP_DATE';
501: l_message :=
502: fnd_message.get_string('CN','CN_IMP_NF_ROLLUP_DATE');
503: CN_IMPORT_PVT.update_imp_lines
504: (p_imp_line_id => l_trxapi_imp.imp_line_id,
505: p_status_code => 'FAIL',
506: p_error_code => l_error_code,
507: p_error_msg => l_message);

Line 508: CN_IMPORT_PVT.update_imp_headers

504: (p_imp_line_id => l_trxapi_imp.imp_line_id,
505: p_status_code => 'FAIL',
506: p_error_code => l_error_code,
507: p_error_msg => l_message);
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

Line 515: CN_IMPORT_PVT.write_error_rec

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,
517: p_imp_line_id => l_trxapi_imp.imp_line_id,
518: p_header_list => l_header_list,
519: p_sql_stmt => l_sql_stmt);

Line 537: CN_IMPORT_PVT.update_imp_lines

533: IF l_meaning IS NULL THEN
534: l_failed_row := l_failed_row + 1;
535: l_error_code := 'CN_IMP_NF_REV_TYPE';
536: l_message := fnd_message.get_string('CN','CN_IMP_NF_REV_TYPE');
537: CN_IMPORT_PVT.update_imp_lines
538: (p_imp_line_id => l_trxapi_imp.imp_line_id,
539: p_status_code => 'FAIL',
540: p_error_code => l_error_code,
541: p_error_msg => l_message);

Line 542: CN_IMPORT_PVT.update_imp_headers

538: (p_imp_line_id => l_trxapi_imp.imp_line_id,
539: p_status_code => 'FAIL',
540: p_error_code => l_error_code,
541: p_error_msg => l_message);
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

Line 549: CN_IMPORT_PVT.write_error_rec

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,
551: p_imp_line_id => l_trxapi_imp.imp_line_id,
552: p_header_list => l_header_list,
553: p_sql_stmt => l_sql_stmt);

Line 570: CN_IMPORT_PVT.update_imp_lines

566: IF l_meaning IS NULL THEN
567: l_failed_row := l_failed_row + 1;
568: l_error_code := 'CN_IMP_NF_REASON_CODE';
569: l_message := fnd_message.get_string('CN','CN_IMP_NF_REASON_CODE');
570: CN_IMPORT_PVT.update_imp_lines
571: (p_imp_line_id => l_trxapi_imp.imp_line_id,
572: p_status_code => 'FAIL',
573: p_error_code => l_error_code,
574: p_error_msg => l_message);

Line 575: CN_IMPORT_PVT.update_imp_headers

571: (p_imp_line_id => l_trxapi_imp.imp_line_id,
572: p_status_code => 'FAIL',
573: p_error_code => l_error_code,
574: p_error_msg => l_message);
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

Line 582: CN_IMPORT_PVT.write_error_rec

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,
584: p_imp_line_id => l_trxapi_imp.imp_line_id,
585: p_header_list => l_header_list,
586: p_sql_stmt => l_sql_stmt);

Line 603: CN_IMPORT_PVT.update_imp_lines

599: IF l_meaning IS NULL THEN
600: l_failed_row := l_failed_row + 1;
601: l_error_code := 'CN_IMP_NF_PRE_PROC_CODE';
602: l_message := fnd_message.get_string('CN','CN_IMP_NF_PRE_PRO_CODE');
603: CN_IMPORT_PVT.update_imp_lines
604: (p_imp_line_id => l_trxapi_imp.imp_line_id,
605: p_status_code => 'FAIL',
606: p_error_code => l_error_code,
607: p_error_msg => l_message);

Line 608: CN_IMPORT_PVT.update_imp_headers

604: (p_imp_line_id => l_trxapi_imp.imp_line_id,
605: p_status_code => 'FAIL',
606: p_error_code => l_error_code,
607: p_error_msg => l_message);
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

Line 615: CN_IMPORT_PVT.write_error_rec

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,
617: p_imp_line_id => l_trxapi_imp.imp_line_id,
618: p_header_list => l_header_list,
619: p_sql_stmt => l_sql_stmt);

Line 640: CN_IMPORT_PVT.update_imp_lines

636: l_failed_row := l_failed_row + 1;
637: l_error_code := 'CN_IMP_NF_TRX_CURR_CODE';
638: l_message :=
639: fnd_message.get_string('CN','CN_IMP_NF_TRX_CURR_CODE');
640: CN_IMPORT_PVT.update_imp_lines
641: (p_imp_line_id => l_trxapi_imp.imp_line_id,
642: p_status_code => 'FAIL',
643: p_error_code => l_error_code,
644: p_error_msg => l_message);

Line 645: CN_IMPORT_PVT.update_imp_headers

641: (p_imp_line_id => l_trxapi_imp.imp_line_id,
642: p_status_code => 'FAIL',
643: p_error_code => l_error_code,
644: p_error_msg => l_message);
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

Line 652: CN_IMPORT_PVT.write_error_rec

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,
654: p_imp_line_id => l_trxapi_imp.imp_line_id,
655: p_header_list => l_header_list,
656: p_sql_stmt => l_sql_stmt);

Line 686: CN_IMPORT_PVT.update_imp_lines

682: l_failed_row := l_failed_row + 1;
683: l_error_code := 'CN_IMP_NOT_VALID_NUMBER';
684: l_message := fnd_message.get_string('CN','CN_IMP_NOT_VALID_NUMBER');
685:
686: CN_IMPORT_PVT.update_imp_lines
687: (p_imp_line_id => l_trxapi_imp.imp_line_id,
688: p_status_code => 'FAIL',
689: p_error_code => l_error_code,
690: p_error_msg => l_message);

Line 692: CN_IMPORT_PVT.update_imp_headers

688: p_status_code => 'FAIL',
689: p_error_code => l_error_code,
690: p_error_msg => l_message);
691:
692: CN_IMPORT_PVT.update_imp_headers
693: (p_imp_header_id => p_imp_header_id,
694: p_status_code => 'IMPORT_FAIL',
695: p_failed_row => l_failed_row);
696:

Line 701: CN_IMPORT_PVT.write_error_rec

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
702: (p_imp_header_id => p_imp_header_id,
703: p_imp_line_id => l_trxapi_imp.imp_line_id,
704: p_header_list => l_header_list,
705: p_sql_stmt => l_sql_stmt);

Line 719: CN_IMPORT_PVT.update_imp_lines

715: l_failed_row := l_failed_row + 1;
716: l_error_code := 'CN_IMP_NOT_ZERO_NEG';
717: l_message := fnd_message.get_string('CN','CN_IMP_NOT_ZERO_NEG');
718:
719: CN_IMPORT_PVT.update_imp_lines
720: (p_imp_line_id => l_trxapi_imp.imp_line_id,
721: p_status_code => 'FAIL',
722: p_error_code => l_error_code,
723: p_error_msg => l_message);

Line 725: CN_IMPORT_PVT.update_imp_headers

721: p_status_code => 'FAIL',
722: p_error_code => l_error_code,
723: p_error_msg => l_message);
724:
725: CN_IMPORT_PVT.update_imp_headers
726: (p_imp_header_id => p_imp_header_id,
727: p_status_code => 'IMPORT_FAIL',
728: p_failed_row => l_failed_row);
729:

Line 734: CN_IMPORT_PVT.write_error_rec

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
735: (p_imp_header_id => p_imp_header_id,
736: p_imp_line_id => l_trxapi_imp.imp_line_id,
737: p_header_list => l_header_list,
738: p_sql_stmt => l_sql_stmt);

Line 754: CN_IMPORT_PVT.update_imp_lines

750: l_failed_row := l_failed_row + 1;
751: l_error_code := 'CN_REVENUE_TYPE_SPLIT_PCT_100';
752: l_message := fnd_message.get_string('CN','CN_REVENUE_TYPE_SPLIT_PCT_100');
753:
754: CN_IMPORT_PVT.update_imp_lines
755: (p_imp_line_id => l_trxapi_imp.imp_line_id,
756: p_status_code => 'FAIL',
757: p_error_code => l_error_code,
758: p_error_msg => l_message);

Line 760: CN_IMPORT_PVT.update_imp_headers

756: p_status_code => 'FAIL',
757: p_error_code => l_error_code,
758: p_error_msg => l_message);
759:
760: CN_IMPORT_PVT.update_imp_headers
761: (p_imp_header_id => p_imp_header_id,
762: p_status_code => 'IMPORT_FAIL',
763: p_failed_row => l_failed_row);
764:

Line 769: CN_IMPORT_PVT.write_error_rec

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
770: (p_imp_header_id => p_imp_header_id,
771: p_imp_line_id => l_trxapi_imp.imp_line_id,
772: p_header_list => l_header_list,
773: p_sql_stmt => l_sql_stmt);

Line 809: CN_IMPORT_PVT.update_imp_lines

805: l_failed_row := l_failed_row + 1;
806: l_error_code := 'CN_ORDER_NUMBER_ALPHANUM';
807: l_message := fnd_message.get_string('CN','CN_ORDER_NUMBER_ALPHANUM');
808:
809: CN_IMPORT_PVT.update_imp_lines
810: (p_imp_line_id => l_trxapi_imp.imp_line_id,
811: p_status_code => 'FAIL',
812: p_error_code => l_error_code,
813: p_error_msg => l_message);

Line 815: CN_IMPORT_PVT.update_imp_headers

811: p_status_code => 'FAIL',
812: p_error_code => l_error_code,
813: p_error_msg => l_message);
814:
815: CN_IMPORT_PVT.update_imp_headers
816: (p_imp_header_id => p_imp_header_id,
817: p_status_code => 'IMPORT_FAIL',
818: p_failed_row => l_failed_row);
819:

Line 824: CN_IMPORT_PVT.write_error_rec

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
825: (p_imp_header_id => p_imp_header_id,
826: p_imp_line_id => l_trxapi_imp.imp_line_id,
827: p_header_list => l_header_list,
828: p_sql_stmt => l_sql_stmt);

Line 1132: CN_IMPORT_PVT.update_imp_lines

1128: l_trxapi_imp.adjust_comments
1129: );
1130:
1131: l_error_code := '';
1132: CN_IMPORT_PVT.update_imp_lines
1133: (p_imp_line_id => l_trxapi_imp.imp_line_id,
1134: p_status_code => 'COMPLETE',
1135: p_error_code => l_error_code);
1136:

Line 1145: CN_IMPORT_PVT.update_imp_headers

1141: << end_loop>>
1142: NULL;
1143:
1144: -- update update_imp_headers:process_row
1145: CN_IMPORT_PVT.update_imp_headers
1146: (p_imp_header_id => p_imp_header_id,
1147: p_status_code => NULL,
1148: p_processed_row => l_processed_row);
1149:

Line 1155: CN_IMPORT_PVT.update_imp_lines

1151: WHEN OTHERS THEN
1152: l_failed_row := l_failed_row + 1;
1153: l_error_code := SQLCODE;
1154: l_message := SUBSTR (SQLERRM , 1 , 2000);
1155: CN_IMPORT_PVT.update_imp_lines
1156: (p_imp_line_id => l_trxapi_imp.imp_line_id,
1157: p_status_code => 'FAIL',
1158: p_error_code => l_error_code,
1159: p_error_msg => l_message);

Line 1160: CN_IMPORT_PVT.update_imp_headers

1156: (p_imp_line_id => l_trxapi_imp.imp_line_id,
1157: p_status_code => 'FAIL',
1158: p_error_code => l_error_code,
1159: p_error_msg => l_message);
1160: CN_IMPORT_PVT.update_imp_headers
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);

Line 1168: CN_IMPORT_PVT.write_error_rec

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,
1170: p_imp_line_id => l_trxapi_imp.imp_line_id,
1171: p_header_list => l_header_list,
1172: p_sql_stmt => l_sql_stmt);

Line 1184: CN_IMPORT_PVT.update_imp_headers

1180: END IF;
1181: CLOSE c_trxapi_imp_csr;
1182: IF l_failed_row = 0 AND retcode = 0 THEN
1183: -- update update_imp_headers
1184: CN_IMPORT_PVT.update_imp_headers
1185: (p_imp_header_id => p_imp_header_id,
1186: p_status_code => 'COMPLETE',
1187: p_processed_row => l_processed_row,
1188: p_failed_row => l_failed_row);