APPS.AHL_APPR_SPACE_CAPB_PVT dependencies on JTF_PLSQL_API

Line 492: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

488: -- End of Comments
489: -------------------------------------------------------------------------------
490: PROCEDURE Validate_Space_Items
491: ( p_space_rec IN space_rec,
492: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
493: x_return_status OUT NOCOPY VARCHAR2
494: ) IS
495: --
496: CURSOR space_name_cur (c_space_name IN VARCHAR2,

Line 565: IF p_validation_mode = Jtf_Plsql_Api.g_create

561: END IF;
562: x_return_status := Fnd_Api.G_RET_STS_ERROR;
563: END IF;
564: -- Validate uniqueness
565: IF p_validation_mode = Jtf_Plsql_Api.g_create
566: AND (p_space_rec.space_id = FND_API.G_MISS_NUM OR
567: p_space_rec.space_id IS NULL)
568: THEN
569: IF Ahl_Utility_Pvt.check_uniqueness(

Line 689: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item

685: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
686: --
687: -- API body
688: --
689: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item
690: THEN
691: Validate_Space_Items
692: ( p_space_rec => p_space_rec,
693: p_validation_mode => Jtf_Plsql_Api.g_create,

Line 693: p_validation_mode => Jtf_Plsql_Api.g_create,

689: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item
690: THEN
691: Validate_Space_Items
692: ( p_space_rec => p_space_rec,
693: p_validation_mode => Jtf_Plsql_Api.g_create,
694: x_return_status => l_return_status
695: );
696: -- If any errors happen abort API.
697: IF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR

Line 707: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record

703: END IF;
704: END IF;
705: -- Perform cross attribute validation and missing attribute checks. Record
706: -- level validation.
707: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record
708: THEN
709: Validate_Space_Record(
710: p_space_rec => p_space_rec,
711: x_return_status => l_return_status

Line 2022: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

2018: -- End of Comments
2019: -------------------------------------------------------------------------------
2020: PROCEDURE Validate_Space_Capbl_Items
2021: ( p_space_capbl_rec IN space_capbl_rec,
2022: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
2023: x_return_status OUT NOCOPY VARCHAR2
2024: ) IS
2025: l_table_name VARCHAR2(30);
2026: l_pk_name VARCHAR2(30);

Line 2099: /* IF p_validation_mode = Jtf_Plsql_Api.g_create

2095: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2096: END IF;
2097:
2098: -- Validate uniqueness
2099: /* IF p_validation_mode = Jtf_Plsql_Api.g_create
2100: AND p_space_capbl_rec.visit_type_code IS NOT NULL
2101: THEN
2102: IF Ahl_Utility_Pvt.check_uniqueness(
2103: 'ahl_space_capabilities',

Line 2212: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item

2208: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2209: --
2210: -- API body
2211: --
2212: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item
2213: THEN
2214: Validate_Space_capbl_Items
2215: ( p_space_capbl_rec => p_space_capblts_rec,
2216: p_validation_mode => Jtf_Plsql_Api.g_create,

Line 2216: p_validation_mode => Jtf_Plsql_Api.g_create,

2212: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item
2213: THEN
2214: Validate_Space_capbl_Items
2215: ( p_space_capbl_rec => p_space_capblts_rec,
2216: p_validation_mode => Jtf_Plsql_Api.g_create,
2217: x_return_status => l_return_status
2218: );
2219: -- If any errors happen abort API.
2220: IF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR

Line 2230: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record

2226: END IF;
2227: END IF;
2228: -- Perform cross attribute validation and missing attribute checks. Record
2229: -- level validation.
2230: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record
2231: THEN
2232: Validate_Space_Capbl_Record(
2233: p_space_capbl_rec => p_space_capblts_rec,
2234: x_return_status => l_return_status