DBA Data[Home] [Help]

APPS.AMS_EVTREGS_PVT dependencies on JTF_PLSQL_API

Line 1204: , p_validation_mode => JTF_PLSQL_API.g_create

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

Line 1748: , p_validation_mode => JTF_PLSQL_API.g_update

1744: Validate_evtregs( p_api_version_number => l_api_version_number
1745: , p_init_msg_list => FND_API.G_FALSE
1746: , p_validation_level => p_validation_level
1747: , P_evt_regs_Rec => l_evt_regs_Rec
1748: , p_validation_mode => JTF_PLSQL_API.g_update
1749: , x_return_status => l_return_status
1750: , x_msg_count => x_msg_count
1751: , x_msg_data => x_msg_data
1752: );

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

4190: -- only needed at update_evt..check for valdation mode
4191: -- ask ravi if cross products need validate
4192: PROCEDURE check_evtRegs_uk_items( p_confirmation_code IN VARCHAR2
4193: , p_event_registration_id IN NUMBER
4194: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
4195: , x_return_status OUT NOCOPY VARCHAR2
4196: )
4197:
4198: IS

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

4209:
4210: -- check reg id, conf code only for create mode
4211: x_return_status := FND_API.g_ret_sts_success;
4212:
4213: IF ( (p_validation_mode = JTF_PLSQL_API.g_create)
4214: AND (p_event_registration_id IS NOT NULL)
4215: )
4216: THEN
4217: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'

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

4224: RETURN;
4225: END IF; -- check_uniqueness
4226: END IF; -- p_event_registration_id
4227:
4228: IF ( (p_validation_mode = JTF_PLSQL_API.g_create)
4229: AND (p_confirmation_code IS NOT NULL)
4230: )
4231: THEN
4232: /* bug#1490374 commented OUT NOCOPY this piece

Line 4357: IF (p_validation_mode = JTF_PLSQL_API.g_create)

4353:
4354: ---------------------SYSTEM STATUS CODE--------------------
4355: IF (p_evt_regs_rec.system_status_code <> FND_API.g_miss_char)
4356: THEN
4357: IF (p_validation_mode = JTF_PLSQL_API.g_create)
4358: THEN
4359: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4360: , 'system_status_code'
4361: , p_evt_regs_rec.system_status_code

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

4628: PROCEDURE Validate_evtregs( p_api_version_number IN NUMBER
4629: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
4630: , p_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
4631: , p_evt_regs_Rec IN evt_regs_Rec_Type
4632: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
4633: , X_Return_Status OUT NOCOPY VARCHAR2
4634: , X_Msg_Count OUT NOCOPY NUMBER
4635: , X_Msg_Data OUT NOCOPY VARCHAR2
4636: )

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

4676:
4677: AMS_Utility_PVT.debug_message(l_full_name||': check items');
4678:
4679: END IF;
4680: IF (p_validation_level >= JTF_PLSQL_API.g_valid_level_item)
4681: THEN
4682: check_evtRegs_items( p_evt_regs_Rec => l_evt_regs_Rec
4683: , p_validation_mode => p_validation_mode
4684: , x_return_status => l_return_status

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

4698:
4699: AMS_Utility_PVT.debug_message(l_full_name||': check record');
4700: END IF;
4701:
4702: IF (p_validation_level >= JTF_PLSQL_API.g_valid_level_record)
4703: THEN
4704: check_evtRegs_record( P_evt_regs_Rec => l_evt_regs_Rec
4705: , x_return_status => l_return_status
4706: );