446: EXCEPTION
447: WHEN OTHERS THEN
448:
449: ROLLBACK TO gcs_import_hier_grp_start;
450: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
451: -- Write the appropriate information to the execution report
452:
453: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
454: fnd_log.STRING(fnd_log.level_error,
743: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
744: EXCEPTION
745: WHEN OTHERS THEN
746: ROLLBACK TO gcs_entry_upload_headers_start;
747: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
748: -- Write the appropriate information to the execution report
749: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
750: fnd_log.STRING(fnd_log.level_error,
751: g_pkg_name || '.' || l_api_name,
955: END IF;
956: EXCEPTION
957: WHEN DUP_VAL_ON_INDEX THEN
958: ROLLBACK TO gcs_insert_header_start;
959: fnd_message.set_name('GCS', 'GCS_INVALID_ENTRY_ID');
960: x_errbuf := fnd_message.get;
961: x_retcode := fnd_api.g_ret_sts_error;
962: -- Write the appropriate information to the execution report
963: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
956: EXCEPTION
957: WHEN DUP_VAL_ON_INDEX THEN
958: ROLLBACK TO gcs_insert_header_start;
959: fnd_message.set_name('GCS', 'GCS_INVALID_ENTRY_ID');
960: x_errbuf := fnd_message.get;
961: x_retcode := fnd_api.g_ret_sts_error;
962: -- Write the appropriate information to the execution report
963: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
964: fnd_log.STRING(fnd_log.level_error,
1027: END IF;
1028: EXCEPTION
1029: WHEN invalid_entity_error THEN
1030: ROLLBACK TO gcs_create_header_start;
1031: fnd_message.set_name('GCS', 'GCS_INVALID_ENTITY_ERR');
1032: x_errbuf := fnd_message.get;
1033: x_retcode := fnd_api.g_ret_sts_unexp_error;
1034: -- Write the appropriate information to the execution report
1035: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1028: EXCEPTION
1029: WHEN invalid_entity_error THEN
1030: ROLLBACK TO gcs_create_header_start;
1031: fnd_message.set_name('GCS', 'GCS_INVALID_ENTITY_ERR');
1032: x_errbuf := fnd_message.get;
1033: x_retcode := fnd_api.g_ret_sts_unexp_error;
1034: -- Write the appropriate information to the execution report
1035: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1036: fnd_log.STRING(fnd_log.level_error,
1039: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1040: END IF;
1041: WHEN invalid_rule_error THEN
1042: ROLLBACK TO gcs_create_header_start;
1043: fnd_message.set_name('GCS', 'GCS_INVALID_RULE_ERR');
1044: x_errbuf := fnd_message.get;
1045: x_retcode := fnd_api.g_ret_sts_unexp_error;
1046: -- Write the appropriate information to the execution report
1047: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1040: END IF;
1041: WHEN invalid_rule_error THEN
1042: ROLLBACK TO gcs_create_header_start;
1043: fnd_message.set_name('GCS', 'GCS_INVALID_RULE_ERR');
1044: x_errbuf := fnd_message.get;
1045: x_retcode := fnd_api.g_ret_sts_unexp_error;
1046: -- Write the appropriate information to the execution report
1047: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1048: fnd_log.STRING(fnd_log.level_error,
1051: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1052: END IF;
1053: WHEN OTHERS THEN
1054: ROLLBACK TO gcs_create_header_start;
1055: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
1056: x_errbuf := fnd_message.get;
1057: x_retcode := fnd_api.g_ret_sts_unexp_error;
1058: -- Write the appropriate information to the execution report
1059: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1052: END IF;
1053: WHEN OTHERS THEN
1054: ROLLBACK TO gcs_create_header_start;
1055: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
1056: x_errbuf := fnd_message.get;
1057: x_retcode := fnd_api.g_ret_sts_unexp_error;
1058: -- Write the appropriate information to the execution report
1059: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1060: fnd_log.STRING(fnd_log.level_error,
1397: EXCEPTION
1398: WHEN OTHERS THEN
1399:
1400: ROLLBACK TO gcs_me_import_start;
1401: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
1402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1403: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
1404: SQLERRM);
1405: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
1482: END IF;
1483: EXCEPTION
1484: WHEN NO_DATA_FOUND THEN
1485: ROLLBACK TO gcs_delete_entry_start;
1486: fnd_message.set_name('GCS', 'GCS_INVALID_ENTRY_ID');
1487: x_errbuf := fnd_message.get;
1488: x_retcode := fnd_api.g_ret_sts_error;
1489: -- Write the appropriate information to the execution report
1490: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1483: EXCEPTION
1484: WHEN NO_DATA_FOUND THEN
1485: ROLLBACK TO gcs_delete_entry_start;
1486: fnd_message.set_name('GCS', 'GCS_INVALID_ENTRY_ID');
1487: x_errbuf := fnd_message.get;
1488: x_retcode := fnd_api.g_ret_sts_error;
1489: -- Write the appropriate information to the execution report
1490: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1491: fnd_log.STRING(fnd_log.level_error,
1494: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1495: END IF;
1496: WHEN OTHERS THEN
1497: ROLLBACK TO gcs_delete_entry_start;
1498: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
1499: x_errbuf := fnd_message.get;
1500: x_retcode := fnd_api.g_ret_sts_unexp_error;
1501: -- Write the appropriate information to the execution report
1502: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1495: END IF;
1496: WHEN OTHERS THEN
1497: ROLLBACK TO gcs_delete_entry_start;
1498: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
1499: x_errbuf := fnd_message.get;
1500: x_retcode := fnd_api.g_ret_sts_unexp_error;
1501: -- Write the appropriate information to the execution report
1502: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1503: fnd_log.STRING(fnd_log.level_error,