[Home] [Help]
567: l_evh_rec.event_header_id
568: );
569: END IF;
570: -- The AMS_SourceCode_PVT takes care of inserting the newly generated
571: -- Source Code in ams_source_codes table.
572: IF l_evh_rec.event_level = 'MAIN' THEN
573: -- attach seeded metrics
574: AMS_RefreshMetric_PVT.copy_seeded_metric(
575: p_api_version => l_api_version,
2161:
2162: l_valid_flag VARCHAR2(1);
2163: l_dummy NUMBER;
2164: cursor c_src_code(src_code_in IN VARCHAR2) IS
2165: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_source_codes
2166: where SOURCE_CODE = src_code_in);
2167: BEGIN
2168:
2169: x_return_status := FND_API.g_ret_sts_success;
2198: END IF;
2199:
2200: -- For create_event_header, when source_code is passed in, we need to
2201: -- check if this source_code is unique.
2202: -- For creating, check if source_code is unique in ams_source_codes.
2203: -- Update of source_code is not allowed.
2204: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2205: IF p_evh_rec.source_code IS NOT NULL THEN
2206: /*
2204: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2205: IF p_evh_rec.source_code IS NOT NULL THEN
2206: /*
2207: IF AMS_Utility_PVT.check_uniqueness(
2208: 'ams_source_codes',
2209: 'source_code = ''' || p_evh_rec.source_code ||''''
2210: ) = FND_API.g_false
2211: */
2212: open c_src_code(p_evh_rec.source_code);
3287: END IF;
3288: ------------------------------Source code-------------------
3289: /* IF ((p_evh_rec.source_code IS NOT NULL) AND (p_evh_rec.source_code <> p_complete_rec.source_code)) THEN
3290: IF AMS_Utility_PVT.check_uniqueness(
3291: 'ams_source_codes',
3292: 'source_code = ''' || p_evh_rec.source_code ||
3293: ''' AND active_flag = ''Y'''
3294: ) = FND_API.g_false
3295: THEN