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_HIERARCHY_PVT dependencies on CN_IMPORT_PVT

Line 83: CN_IMPORT_PVT.update_imp_headers

79: RAISE NO_DATA_FOUND;
80: END IF;
81: COMMIT;
82:
83: CN_IMPORT_PVT.update_imp_headers
84: (p_imp_header_id => p_hier_record.imp_header_id,
85: p_status_code => 'IMPORT_FAIL',
86: p_failed_row => x_failed_row,
87: p_processed_row => x_processed_row);

Line 760: CN_IMPORT_PVT.update_imp_lines

756: END;
757: END IF;
758:
759: -- create complete or default node or edge exists
760: CN_IMPORT_PVT.update_imp_lines
761: (p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
762: p_status_code => 'COMPLETE',
763: p_error_code => '');
764:

Line 773: CN_IMPORT_PVT.update_imp_lines

769: x_failed_row := x_failed_row + 1;
770: x_processed_row := x_processed_row + 1;
771: x_return_status := FND_API.G_RET_STS_ERROR ;
772: x_error_msg := l_message;
773: CN_IMPORT_PVT.update_imp_lines
774: (p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
775: p_status_code => 'FAIL',
776: p_error_code => l_error_code,
777: p_error_msg => l_message);

Line 778: CN_IMPORT_PVT.update_imp_headers

774: (p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
775: p_status_code => 'FAIL',
776: p_error_code => l_error_code,
777: p_error_msg => l_message);
778: CN_IMPORT_PVT.update_imp_headers
779: (p_imp_header_id => p_imp_header_id,
780: p_status_code => 'IMPORT_FAIL',
781: p_failed_row => x_failed_row,
782: p_processed_row => x_processed_row);

Line 787: CN_IMPORT_PVT.write_error_rec

783: cn_message_pkg.write
784: (p_message_text => 'Record ' ||
785: l_hierarchy_node_csr.record_num || ':' || l_message,
786: p_message_type => 'ERROR');
787: CN_IMPORT_PVT.write_error_rec
788: (p_imp_header_id => p_imp_header_id,
789: p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
790: p_header_list => p_header_list,
791: p_sql_stmt => p_sql_stmt);

Line 799: CN_IMPORT_PVT.update_imp_lines

795: x_return_status := FND_API.G_RET_STS_ERROR ;
796: l_error_code := SQLCODE;
797: l_message := SUBSTR (SQLERRM , 1 , 2000);
798: x_error_msg := l_message;
799: CN_IMPORT_PVT.update_imp_lines
800: (p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
801: p_status_code => 'FAIL',
802: p_error_code => l_error_code,
803: p_error_msg => l_message);

Line 804: CN_IMPORT_PVT.update_imp_headers

800: (p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
801: p_status_code => 'FAIL',
802: p_error_code => l_error_code,
803: p_error_msg => l_message);
804: CN_IMPORT_PVT.update_imp_headers
805: (p_imp_header_id => p_imp_header_id,
806: p_status_code => 'IMPORT_FAIL',
807: p_failed_row => x_failed_row,
808: p_processed_row => x_processed_row);

Line 813: CN_IMPORT_PVT.write_error_rec

809: cn_message_pkg.write
810: (p_message_text => 'Record ' ||
811: l_hierarchy_node_csr.record_num || ':' || l_message,
812: p_message_type => 'ERROR');
813: CN_IMPORT_PVT.write_error_rec
814: (p_imp_header_id => p_imp_header_id,
815: p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
816: p_header_list => p_header_list,
817: p_sql_stmt => p_sql_stmt);

Line 978: CN_IMPORT_PVT.build_error_rec

974: || To_char(p_imp_header_id),
975: p_message_type => 'MILESTONE');
976:
977: -- Get source column name list and target column dynamic sql statement
978: CN_IMPORT_PVT.build_error_rec
979: (p_imp_header_id => p_imp_header_id,
980: x_header_list => l_header_list,
981: x_sql_stmt => l_sql_stmt);
982:

Line 990: CN_IMPORT_PVT.update_imp_lines

986: l_failed_row := l_failed_row + 1;
987: l_processed_row := l_processed_row + 1;
988: l_error_code := 'CN_IMP_MISS_REQUIRED';
989: l_message := fnd_message.get_string('CN','CN_IMP_MISS_REQUIRED');
990: CN_IMPORT_PVT.update_imp_lines
991: (p_imp_line_id => l_miss_required_csr.imp_line_id,
992: p_status_code => 'FAIL',
993: p_error_code => l_error_code,
994: p_error_msg => l_message);

Line 995: CN_IMPORT_PVT.update_imp_headers

991: (p_imp_line_id => l_miss_required_csr.imp_line_id,
992: p_status_code => 'FAIL',
993: p_error_code => l_error_code,
994: p_error_msg => l_message);
995: CN_IMPORT_PVT.update_imp_headers
996: (p_imp_header_id => p_imp_header_id,
997: p_status_code => 'IMPORT_FAIL',
998: p_failed_row => l_failed_row);
999: cn_message_pkg.write

Line 1003: CN_IMPORT_PVT.write_error_rec

999: cn_message_pkg.write
1000: (p_message_text => 'Record ' ||
1001: To_char(l_miss_required_csr.record_num) || ':' || l_message,
1002: p_message_type => 'ERROR');
1003: CN_IMPORT_PVT.write_error_rec
1004: (p_imp_header_id => p_imp_header_id,
1005: p_imp_line_id => l_miss_required_csr.imp_line_id,
1006: p_header_list => l_header_list,
1007: p_sql_stmt => l_sql_stmt);

Line 1020: CN_IMPORT_PVT.update_imp_lines

1016: l_failed_row := l_failed_row + 1;
1017: l_processed_row := l_processed_row + 1;
1018: l_error_code := 'CN_HIER_ERR_NODEFLAG';
1019: l_message := fnd_message.get_string('CN','CN_HIER_ERR_NODEFLAG');
1020: CN_IMPORT_PVT.update_imp_lines
1021: (p_imp_line_id => l_err_dflt_node_csr.imp_line_id,
1022: p_status_code => 'FAIL',
1023: p_error_code => l_error_code,
1024: p_error_msg => l_message);

Line 1025: CN_IMPORT_PVT.update_imp_headers

1021: (p_imp_line_id => l_err_dflt_node_csr.imp_line_id,
1022: p_status_code => 'FAIL',
1023: p_error_code => l_error_code,
1024: p_error_msg => l_message);
1025: CN_IMPORT_PVT.update_imp_headers
1026: (p_imp_header_id => p_imp_header_id,
1027: p_status_code => 'IMPORT_FAIL',
1028: p_failed_row => l_failed_row);
1029: cn_message_pkg.write

Line 1033: CN_IMPORT_PVT.write_error_rec

1029: cn_message_pkg.write
1030: (p_message_text => 'Record ' ||
1031: To_char(l_err_dflt_node_csr.record_num) || ':' || l_message,
1032: p_message_type => 'ERROR');
1033: CN_IMPORT_PVT.write_error_rec
1034: (p_imp_header_id => p_imp_header_id,
1035: p_imp_line_id => l_err_dflt_node_csr.imp_line_id,
1036: p_header_list => l_header_list,
1037: p_sql_stmt => l_sql_stmt);

Line 1287: CN_IMPORT_PVT.update_imp_headers

1283: END IF;
1284: CLOSE c_hierarchy_type_csr;
1285: IF l_failed_row = 0 AND retcode = 0 THEN
1286: -- update update_imp_headers
1287: CN_IMPORT_PVT.update_imp_headers
1288: (p_imp_header_id => p_imp_header_id,
1289: p_status_code => 'COMPLETE',
1290: p_processed_row => l_processed_row,
1291: p_failed_row => l_failed_row);