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 226: CN_IMPORT_PVT.build_error_rec

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

Line 255: CN_IMPORT_PVT.update_imp_lines

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

Line 260: CN_IMPORT_PVT.update_imp_headers

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

Line 267: CN_IMPORT_PVT.write_error_rec

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

Line 289: CN_IMPORT_PVT.update_imp_lines

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

Line 294: CN_IMPORT_PVT.update_imp_headers

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

Line 301: CN_IMPORT_PVT.write_error_rec

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

Line 324: CN_IMPORT_PVT.update_imp_lines

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

Line 329: CN_IMPORT_PVT.update_imp_headers

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

Line 336: CN_IMPORT_PVT.write_error_rec

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

Line 358: CN_IMPORT_PVT.update_imp_lines

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

Line 363: CN_IMPORT_PVT.update_imp_headers

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

Line 370: CN_IMPORT_PVT.write_error_rec

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

Line 395: CN_IMPORT_PVT.update_imp_lines

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

Line 400: CN_IMPORT_PVT.update_imp_headers

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

Line 407: CN_IMPORT_PVT.write_error_rec

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

Line 433: CN_IMPORT_PVT.update_imp_lines

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

Line 438: CN_IMPORT_PVT.update_imp_headers

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

Line 445: CN_IMPORT_PVT.write_error_rec

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

Line 465: CN_IMPORT_PVT.update_imp_lines

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

Line 470: CN_IMPORT_PVT.update_imp_headers

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

Line 477: CN_IMPORT_PVT.write_error_rec

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

Line 502: CN_IMPORT_PVT.update_imp_lines

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

Line 507: CN_IMPORT_PVT.update_imp_headers

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

Line 514: CN_IMPORT_PVT.write_error_rec

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

Line 536: CN_IMPORT_PVT.update_imp_lines

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

Line 541: CN_IMPORT_PVT.update_imp_headers

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

Line 548: CN_IMPORT_PVT.write_error_rec

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

Line 569: CN_IMPORT_PVT.update_imp_lines

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

Line 574: CN_IMPORT_PVT.update_imp_headers

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

Line 581: CN_IMPORT_PVT.write_error_rec

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

Line 602: CN_IMPORT_PVT.update_imp_lines

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

Line 607: CN_IMPORT_PVT.update_imp_headers

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

Line 614: CN_IMPORT_PVT.write_error_rec

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

Line 639: CN_IMPORT_PVT.update_imp_lines

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

Line 644: CN_IMPORT_PVT.update_imp_headers

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

Line 651: CN_IMPORT_PVT.write_error_rec

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,
653: p_imp_line_id => l_trxapi_imp.imp_line_id,
654: p_header_list => l_header_list,
655: 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 1074: CN_IMPORT_PVT.update_imp_lines

1070: l_trxapi_imp.adjust_comments
1071: );
1072:
1073: l_error_code := '';
1074: CN_IMPORT_PVT.update_imp_lines
1075: (p_imp_line_id => l_trxapi_imp.imp_line_id,
1076: p_status_code => 'COMPLETE',
1077: p_error_code => l_error_code);
1078:

Line 1087: CN_IMPORT_PVT.update_imp_headers

1083: << end_loop>>
1084: NULL;
1085:
1086: -- update update_imp_headers:process_row
1087: CN_IMPORT_PVT.update_imp_headers
1088: (p_imp_header_id => p_imp_header_id,
1089: p_status_code => NULL,
1090: p_processed_row => l_processed_row);
1091:

Line 1097: CN_IMPORT_PVT.update_imp_lines

1093: WHEN OTHERS THEN
1094: l_failed_row := l_failed_row + 1;
1095: l_error_code := SQLCODE;
1096: l_message := SUBSTR (SQLERRM , 1 , 2000);
1097: CN_IMPORT_PVT.update_imp_lines
1098: (p_imp_line_id => l_trxapi_imp.imp_line_id,
1099: p_status_code => 'FAIL',
1100: p_error_code => l_error_code,
1101: p_error_msg => l_message);

Line 1102: CN_IMPORT_PVT.update_imp_headers

1098: (p_imp_line_id => l_trxapi_imp.imp_line_id,
1099: p_status_code => 'FAIL',
1100: p_error_code => l_error_code,
1101: p_error_msg => l_message);
1102: CN_IMPORT_PVT.update_imp_headers
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);

Line 1110: CN_IMPORT_PVT.write_error_rec

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,
1112: p_imp_line_id => l_trxapi_imp.imp_line_id,
1113: p_header_list => l_header_list,
1114: p_sql_stmt => l_sql_stmt);

Line 1126: CN_IMPORT_PVT.update_imp_headers

1122: END IF;
1123: CLOSE c_trxapi_imp_csr;
1124: IF l_failed_row = 0 AND retcode = 0 THEN
1125: -- update update_imp_headers
1126: CN_IMPORT_PVT.update_imp_headers
1127: (p_imp_header_id => p_imp_header_id,
1128: p_status_code => 'COMPLETE',
1129: p_processed_row => l_processed_row,
1130: p_failed_row => l_failed_row);