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 754: CN_IMPORT_PVT.update_imp_lines

750: END;
751: END IF;
752:
753: -- create complete or default node or edge exists
754: CN_IMPORT_PVT.update_imp_lines
755: (p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
756: p_status_code => 'COMPLETE',
757: p_error_code => '');
758:

Line 767: CN_IMPORT_PVT.update_imp_lines

763: x_failed_row := x_failed_row + 1;
764: x_processed_row := x_processed_row + 1;
765: x_return_status := FND_API.G_RET_STS_ERROR ;
766: x_error_msg := l_message;
767: CN_IMPORT_PVT.update_imp_lines
768: (p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
769: p_status_code => 'FAIL',
770: p_error_code => l_error_code,
771: p_error_msg => l_message);

Line 772: CN_IMPORT_PVT.update_imp_headers

768: (p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
769: p_status_code => 'FAIL',
770: p_error_code => l_error_code,
771: p_error_msg => l_message);
772: CN_IMPORT_PVT.update_imp_headers
773: (p_imp_header_id => p_imp_header_id,
774: p_status_code => 'IMPORT_FAIL',
775: p_failed_row => x_failed_row,
776: p_processed_row => x_processed_row);

Line 781: CN_IMPORT_PVT.write_error_rec

777: cn_message_pkg.write
778: (p_message_text => 'Record ' ||
779: l_hierarchy_node_csr.record_num || ':' || l_message,
780: p_message_type => 'ERROR');
781: CN_IMPORT_PVT.write_error_rec
782: (p_imp_header_id => p_imp_header_id,
783: p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
784: p_header_list => p_header_list,
785: p_sql_stmt => p_sql_stmt);

Line 793: CN_IMPORT_PVT.update_imp_lines

789: x_return_status := FND_API.G_RET_STS_ERROR ;
790: l_error_code := SQLCODE;
791: l_message := SUBSTR (SQLERRM , 1 , 2000);
792: x_error_msg := l_message;
793: CN_IMPORT_PVT.update_imp_lines
794: (p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
795: p_status_code => 'FAIL',
796: p_error_code => l_error_code,
797: p_error_msg => l_message);

Line 798: CN_IMPORT_PVT.update_imp_headers

794: (p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
795: p_status_code => 'FAIL',
796: p_error_code => l_error_code,
797: p_error_msg => l_message);
798: CN_IMPORT_PVT.update_imp_headers
799: (p_imp_header_id => p_imp_header_id,
800: p_status_code => 'IMPORT_FAIL',
801: p_failed_row => x_failed_row,
802: p_processed_row => x_processed_row);

Line 807: CN_IMPORT_PVT.write_error_rec

803: cn_message_pkg.write
804: (p_message_text => 'Record ' ||
805: l_hierarchy_node_csr.record_num || ':' || l_message,
806: p_message_type => 'ERROR');
807: CN_IMPORT_PVT.write_error_rec
808: (p_imp_header_id => p_imp_header_id,
809: p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
810: p_header_list => p_header_list,
811: p_sql_stmt => p_sql_stmt);

Line 972: CN_IMPORT_PVT.build_error_rec

968: || To_char(p_imp_header_id),
969: p_message_type => 'MILESTONE');
970:
971: -- Get source column name list and target column dynamic sql statement
972: CN_IMPORT_PVT.build_error_rec
973: (p_imp_header_id => p_imp_header_id,
974: x_header_list => l_header_list,
975: x_sql_stmt => l_sql_stmt);
976:

Line 984: CN_IMPORT_PVT.update_imp_lines

980: l_failed_row := l_failed_row + 1;
981: l_processed_row := l_processed_row + 1;
982: l_error_code := 'CN_IMP_MISS_REQUIRED';
983: l_message := fnd_message.get_string('CN','CN_IMP_MISS_REQUIRED');
984: CN_IMPORT_PVT.update_imp_lines
985: (p_imp_line_id => l_miss_required_csr.imp_line_id,
986: p_status_code => 'FAIL',
987: p_error_code => l_error_code,
988: p_error_msg => l_message);

Line 989: CN_IMPORT_PVT.update_imp_headers

985: (p_imp_line_id => l_miss_required_csr.imp_line_id,
986: p_status_code => 'FAIL',
987: p_error_code => l_error_code,
988: p_error_msg => l_message);
989: CN_IMPORT_PVT.update_imp_headers
990: (p_imp_header_id => p_imp_header_id,
991: p_status_code => 'IMPORT_FAIL',
992: p_failed_row => l_failed_row);
993: cn_message_pkg.write

Line 997: CN_IMPORT_PVT.write_error_rec

993: cn_message_pkg.write
994: (p_message_text => 'Record ' ||
995: To_char(l_miss_required_csr.record_num) || ':' || l_message,
996: p_message_type => 'ERROR');
997: CN_IMPORT_PVT.write_error_rec
998: (p_imp_header_id => p_imp_header_id,
999: p_imp_line_id => l_miss_required_csr.imp_line_id,
1000: p_header_list => l_header_list,
1001: p_sql_stmt => l_sql_stmt);

Line 1014: CN_IMPORT_PVT.update_imp_lines

1010: l_failed_row := l_failed_row + 1;
1011: l_processed_row := l_processed_row + 1;
1012: l_error_code := 'CN_HIER_ERR_NODEFLAG';
1013: l_message := fnd_message.get_string('CN','CN_HIER_ERR_NODEFLAG');
1014: CN_IMPORT_PVT.update_imp_lines
1015: (p_imp_line_id => l_err_dflt_node_csr.imp_line_id,
1016: p_status_code => 'FAIL',
1017: p_error_code => l_error_code,
1018: p_error_msg => l_message);

Line 1019: CN_IMPORT_PVT.update_imp_headers

1015: (p_imp_line_id => l_err_dflt_node_csr.imp_line_id,
1016: p_status_code => 'FAIL',
1017: p_error_code => l_error_code,
1018: p_error_msg => l_message);
1019: CN_IMPORT_PVT.update_imp_headers
1020: (p_imp_header_id => p_imp_header_id,
1021: p_status_code => 'IMPORT_FAIL',
1022: p_failed_row => l_failed_row);
1023: cn_message_pkg.write

Line 1027: CN_IMPORT_PVT.write_error_rec

1023: cn_message_pkg.write
1024: (p_message_text => 'Record ' ||
1025: To_char(l_err_dflt_node_csr.record_num) || ':' || l_message,
1026: p_message_type => 'ERROR');
1027: CN_IMPORT_PVT.write_error_rec
1028: (p_imp_header_id => p_imp_header_id,
1029: p_imp_line_id => l_err_dflt_node_csr.imp_line_id,
1030: p_header_list => l_header_list,
1031: p_sql_stmt => l_sql_stmt);

Line 1281: CN_IMPORT_PVT.update_imp_headers

1277: END IF;
1278: CLOSE c_hierarchy_type_csr;
1279: IF l_failed_row = 0 AND retcode = 0 THEN
1280: -- update update_imp_headers
1281: CN_IMPORT_PVT.update_imp_headers
1282: (p_imp_header_id => p_imp_header_id,
1283: p_status_code => 'COMPLETE',
1284: p_processed_row => l_processed_row,
1285: p_failed_row => l_failed_row);