DBA Data[Home] [Help]

APPS.AMS_EVTREGS_PVT dependencies on JTF_PLSQL_API

Line 1207: , p_validation_mode => JTF_PLSQL_API.g_create

1203: Validate_evtregs( p_api_version_number => l_api_version_number
1204: , p_init_msg_list => p_init_msg_list
1205: , p_validation_level => p_validation_level
1206: , P_evt_regs_Rec => l_evt_regs_Rec
1207: , p_validation_mode => JTF_PLSQL_API.g_create
1208: , x_return_status => l_return_status
1209: , x_msg_count => x_msg_count
1210: , x_msg_data => x_msg_data
1211: );

Line 1763: , p_validation_mode => JTF_PLSQL_API.g_update

1759: Validate_evtregs( p_api_version_number => l_api_version_number
1760: , p_init_msg_list => FND_API.G_FALSE
1761: , p_validation_level => p_validation_level
1762: , P_evt_regs_Rec => l_evt_regs_Rec
1763: , p_validation_mode => JTF_PLSQL_API.g_update
1764: , x_return_status => l_return_status
1765: , x_msg_count => x_msg_count
1766: , x_msg_data => x_msg_data
1767: );

Line 4209: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create

4205: -- only needed at update_evt..check for valdation mode
4206: -- ask ravi if cross products need validate
4207: PROCEDURE check_evtRegs_uk_items( p_confirmation_code IN VARCHAR2
4208: , p_event_registration_id IN NUMBER
4209: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
4210: , x_return_status OUT NOCOPY VARCHAR2
4211: )
4212:
4213: IS

Line 4228: IF ( (p_validation_mode = JTF_PLSQL_API.g_create)

4224:
4225: -- check reg id, conf code only for create mode
4226: x_return_status := FND_API.g_ret_sts_success;
4227:
4228: IF ( (p_validation_mode = JTF_PLSQL_API.g_create)
4229: AND (p_event_registration_id IS NOT NULL)
4230: )
4231: THEN
4232: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'

Line 4243: IF ( (p_validation_mode = JTF_PLSQL_API.g_create)

4239: RETURN;
4240: END IF; -- check_uniqueness
4241: END IF; -- p_event_registration_id
4242:
4243: IF ( (p_validation_mode = JTF_PLSQL_API.g_create)
4244: AND (p_confirmation_code IS NOT NULL)
4245: )
4246: THEN
4247: /* bug#1490374 commented OUT NOCOPY this piece

Line 4372: IF (p_validation_mode = JTF_PLSQL_API.g_create)

4368:
4369: ---------------------SYSTEM STATUS CODE--------------------
4370: IF (p_evt_regs_rec.system_status_code <> FND_API.g_miss_char)
4371: THEN
4372: IF (p_validation_mode = JTF_PLSQL_API.g_create)
4373: THEN
4374: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4375: , 'system_status_code'
4376: , p_evt_regs_rec.system_status_code

Line 4647: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create

4643: PROCEDURE Validate_evtregs( p_api_version_number IN NUMBER
4644: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
4645: , p_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
4646: , p_evt_regs_Rec IN evt_regs_Rec_Type
4647: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
4648: , X_Return_Status OUT NOCOPY VARCHAR2
4649: , X_Msg_Count OUT NOCOPY NUMBER
4650: , X_Msg_Data OUT NOCOPY VARCHAR2
4651: )

Line 4695: IF (p_validation_level >= JTF_PLSQL_API.g_valid_level_item)

4691:
4692: AMS_Utility_PVT.debug_message(l_full_name||': check items');
4693:
4694: END IF;
4695: IF (p_validation_level >= JTF_PLSQL_API.g_valid_level_item)
4696: THEN
4697: check_evtRegs_items( p_evt_regs_Rec => l_evt_regs_Rec
4698: , p_validation_mode => p_validation_mode
4699: , x_return_status => l_return_status

Line 4717: IF (p_validation_level >= JTF_PLSQL_API.g_valid_level_record)

4713:
4714: AMS_Utility_PVT.debug_message(l_full_name||': check record');
4715: END IF;
4716:
4717: IF (p_validation_level >= JTF_PLSQL_API.g_valid_level_record)
4718: THEN
4719: check_evtRegs_record( P_evt_regs_Rec => l_evt_regs_Rec
4720: , x_return_status => l_return_status
4721: );