[Home] [Help]
73: END get_user_id;
74:
75: PROCEDURE Insert_evtregs( p_evt_regs_Rec IN evt_regs_Rec_Type
76: , p_system_status_code IN VARCHAR2
77: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
78: , x_confirmation_code OUT NOCOPY VARCHAR2
79: , x_event_registration_id OUT NOCOPY NUMBER
80: )
81: IS
224: -- error out if user status not found...
225: CLOSE c_evt_reg_status;
226:
227: -- added by dbiswas on Mar 12, 2003 for bug 2845867
228: IF l_date_reg_placed = Fnd_Api.g_miss_date THEN
229: l_date_reg_placed := sysdate;
230: END IF;
231: -- end update on Mar 12, 2003
232:
441: );
442:
443: -- Fulfillment
444: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
445: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
446: )
447: THEN
448: IF (AMS_DEBUG_HIGH_ON) THEN
449:
449:
450: AMS_Utility_PVT.Debug_Message('Calling check_content_rule for fulfillment (registered)');
451: END IF;
452: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
453: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
454: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
455: , p_object_type => l_object_type -- IN VARCHAR2
456: , p_object_id => l_object_id --l_evt_regs_rec.event_offer_id -- IN NUMBER
457: , p_trigger_type => 'REG_CONFIRM' -- IN VARCHAR2
450: AMS_Utility_PVT.Debug_Message('Calling check_content_rule for fulfillment (registered)');
451: END IF;
452: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
453: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
454: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
455: , p_object_type => l_object_type -- IN VARCHAR2
456: , p_object_id => l_object_id --l_evt_regs_rec.event_offer_id -- IN NUMBER
457: , p_trigger_type => 'REG_CONFIRM' -- IN VARCHAR2
458: -- , p_requestor_type => -- IN VARCHAR2 := NULL
483: IF (AMS_DEBUG_HIGH_ON) THEN
484: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
485: END IF;
486:
487: IF l_return_status = FND_API.g_ret_sts_error THEN
488: RAISE FND_API.g_exc_error;
489: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;
484: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
485: END IF;
486:
487: IF l_return_status = FND_API.g_ret_sts_error THEN
488: RAISE FND_API.g_exc_error;
489: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;
492:
485: END IF;
486:
487: IF l_return_status = FND_API.g_ret_sts_error THEN
488: RAISE FND_API.g_exc_error;
489: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;
492:
493:
486:
487: IF l_return_status = FND_API.g_ret_sts_error THEN
488: RAISE FND_API.g_exc_error;
489: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;
492:
493:
494: END IF;
495: ELSIF (l_system_status_code = 'WAITLISTED')
496: THEN
497: -- Fulfillment
498: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
499: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
500: )
501: THEN
502: IF (AMS_DEBUG_HIGH_ON) THEN
503:
503:
504: AMS_Utility_PVT.Debug_Message('Calling check_content_rule for fulfillment (waitlisted)');
505: END IF;
506: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
507: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
508: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
509: , p_object_type => l_object_type -- IN VARCHAR2
510: , p_object_id => l_object_id --l_evt_regs_rec.event_offer_id -- IN NUMBER
511: , p_trigger_type => 'REG_WAITLIST' -- IN VARCHAR2
504: AMS_Utility_PVT.Debug_Message('Calling check_content_rule for fulfillment (waitlisted)');
505: END IF;
506: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
507: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
508: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
509: , p_object_type => l_object_type -- IN VARCHAR2
510: , p_object_id => l_object_id --l_evt_regs_rec.event_offer_id -- IN NUMBER
511: , p_trigger_type => 'REG_WAITLIST' -- IN VARCHAR2
512: -- , p_requestor_type => -- IN VARCHAR2 := NULL
537: IF (AMS_DEBUG_HIGH_ON) THEN
538: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
539: END IF;
540:
541: IF l_return_status = FND_API.g_ret_sts_error THEN
542: RAISE FND_API.g_exc_error;
543: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
544: RAISE FND_API.g_exc_unexpected_error;
545: END IF;
538: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
539: END IF;
540:
541: IF l_return_status = FND_API.g_ret_sts_error THEN
542: RAISE FND_API.g_exc_error;
543: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
544: RAISE FND_API.g_exc_unexpected_error;
545: END IF;
546:
539: END IF;
540:
541: IF l_return_status = FND_API.g_ret_sts_error THEN
542: RAISE FND_API.g_exc_error;
543: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
544: RAISE FND_API.g_exc_unexpected_error;
545: END IF;
546:
547: END IF;
540:
541: IF l_return_status = FND_API.g_ret_sts_error THEN
542: RAISE FND_API.g_exc_error;
543: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
544: RAISE FND_API.g_exc_unexpected_error;
545: END IF;
546:
547: END IF;
548: END IF;
626: FUNCTION check_waitlist_availability( l_reg_waitlist_pct IN NUMBER
627: , l_effective_capacity IN NUMBER
628: , l_event_offer_id IN NUMBER
629: )
630: RETURN VARCHAR2 -- FND_API.g_true or false
631: IS
632:
633: cursor c_num_waitlist_done is
634: select count(*)
642: BEGIN
643:
644: IF (l_reg_waitlist_pct is NULL)
645: THEN
646: return FND_API.g_true;
647: ELSE
648: open c_num_waitlist_done;
649: fetch c_num_waitlist_done
650: into l_num_of_waitlist_done;
653: l_availability := (round(l_reg_waitlist_pct*l_effective_capacity/100) - l_num_of_waitlist_done);
654:
655: IF (l_availability > 0)
656: THEN
657: return FND_API.g_true;
658: ELSE
659: return FND_API.g_false;
660: END IF; -- l_availabilty > 0
661: END IF; -- l_reg_waitlist_pct is NULL
655: IF (l_availability > 0)
656: THEN
657: return FND_API.g_true;
658: ELSE
659: return FND_API.g_false;
660: END IF; -- l_availabilty > 0
661: END IF; -- l_reg_waitlist_pct is NULL
662:
663: END check_waitlist_availability;
665: FUNCTION contact_in_invite_list( p_event_offer_id IN NUMBER
666: , p_attendant_contact_id IN NUMBER
667: , p_attendant_party_id IN NUMBER
668: )
669: RETURN VARCHAR2 -- FND_API.g_true or false
670: IS
671: l_count NUMBER := 0;
672:
673:
780: END IF;
781:
782: IF (l_count > 0)
783: THEN
784: return FND_API.g_true;
785: END IF; -- l_count > 0
786:
787: return FND_API.g_false;
788:
783: THEN
784: return FND_API.g_true;
785: END IF; -- l_count > 0
786:
787: return FND_API.g_false;
788:
789: END contact_in_invite_list;
790:
791: -- SUB PART OF FK VALIDATION BELOW
797: IS
798:
799: BEGIN
800:
801: x_return_status := FND_API.g_ret_sts_success;
802:
803: ------------------------- registrant party id -------------------
804: IF ( (p_registrant_party_id is NOT NULL)
805: OR (p_registrant_party_id <> FND_API.g_miss_num)
801: x_return_status := FND_API.g_ret_sts_success;
802:
803: ------------------------- registrant party id -------------------
804: IF ( (p_registrant_party_id is NOT NULL)
805: OR (p_registrant_party_id <> FND_API.g_miss_num)
806: )
807: THEN
808: IF (AMS_Utility_PVT.check_fk_exists( 'hz_parties'
809: , 'party_id'
807: THEN
808: IF (AMS_Utility_PVT.check_fk_exists( 'hz_parties'
809: , 'party_id'
810: , p_registrant_party_id
811: ) = FND_API.g_false
812: )
813: THEN
814: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_EVT_REG_BAD_PARTY_ID');
815: x_return_status := FND_API.g_ret_sts_error;
811: ) = FND_API.g_false
812: )
813: THEN
814: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_EVT_REG_BAD_PARTY_ID');
815: x_return_status := FND_API.g_ret_sts_error;
816: RETURN;
817: END IF; -- check_fk_exists
818: END IF; -- p_registrant_party_id
819:
818: END IF; -- p_registrant_party_id
819:
820: /*
821: -------------------------registration CONTACT id-------------------
822: IF p_registrant_contact_id IS NOT NULL OR p_registrant_contact_id <> FND_API.g_miss_num THEN
823: IF AMS_Utility_PVT.check_fk_exists(
824: 'hz_org_contacts',
825: 'org_contact_id',
826: p_registrant_contact_id,
825: 'org_contact_id',
826: p_registrant_contact_id,
827: AMS_Utility_PVT.g_number,
828: 'party_relationship_id ='|| p_registrant_party_id
829: ) = FND_API.g_false
830: THEN
831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
832: THEN
833: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_BAD_CONTACT_ID');
833: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_BAD_CONTACT_ID');
834: FND_MSG_PUB.add;
835: END IF;
836:
837: x_return_status := FND_API.g_ret_sts_error;
838: --RETURN;
839: END IF;
840: END IF;
841: */
841: */
842:
843: -------------------------registration account id-------------------
844: IF ( (p_registrant_account_id IS NOT NULL)
845: AND (p_registrant_account_id <> FND_API.g_miss_num)
846: )
847: THEN
848: IF (AMS_Utility_PVT.check_fk_exists( 'hz_cust_accounts'
849: , 'cust_account_id'
849: , 'cust_account_id'
850: , p_registrant_account_id
851: , AMS_Utility_PVT.g_number
852: , 'party_id ='|| p_registrant_party_id
853: ) = FND_API.g_false
854: )
855: THEN
856: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_EVT_REG_BAD_ACCOUNT_ID');
857: x_return_status := FND_API.g_ret_sts_error;
853: ) = FND_API.g_false
854: )
855: THEN
856: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_EVT_REG_BAD_ACCOUNT_ID');
857: x_return_status := FND_API.g_ret_sts_error;
858: RETURN;
859: END IF; -- check_fk_exists
860: END IF; -- p_registrant_account_id
861:
861:
862: END check_registrant_fk_info;
863:
864: PROCEDURE transfer_insert( p_Api_Version_Number IN NUMBER
865: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
866: , p_Commit IN VARCHAR2 := FND_API.G_FALSE
867: , p_old_offer_id IN NUMBER
868: , p_new_offer_id IN NUMBER
869: , p_system_status_code IN VARCHAR2
862: END check_registrant_fk_info;
863:
864: PROCEDURE transfer_insert( p_Api_Version_Number IN NUMBER
865: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
866: , p_Commit IN VARCHAR2 := FND_API.G_FALSE
867: , p_old_offer_id IN NUMBER
868: , p_new_offer_id IN NUMBER
869: , p_system_status_code IN VARCHAR2
870: , p_reg_status_date IN DATE
975:
976: AMS_Utility_PVT.debug_message(l_full_name||': start');
977: END IF;
978:
979: IF (FND_API.to_boolean(p_init_msg_list))
980: THEN
981: FND_MSG_PUB.initialize;
982: END IF; -- p_init_msg_list
983:
981: FND_MSG_PUB.initialize;
982: END IF; -- p_init_msg_list
983:
984: -- Standard call to check for call compatibility.
985: IF (NOT FND_API.Compatible_API_Call( l_api_version_number
986: , p_api_version_number
987: , l_api_name
988: , G_PKG_NAME
989: )
988: , G_PKG_NAME
989: )
990: )
991: THEN
992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
993: END IF; -- compatible API call
994:
995: -- Initialize API return status to SUCCESS
996: x_return_status := FND_API.G_RET_STS_SUCCESS;
992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
993: END IF; -- compatible API call
994:
995: -- Initialize API return status to SUCCESS
996: x_return_status := FND_API.G_RET_STS_SUCCESS;
997:
998: OPEN c_reg;
999: FETCH c_reg
1000: INTO l_evt_regs_rec;
1001: IF (c_reg%NOTFOUND)
1002: THEN
1003: CLOSE c_reg;
1004: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RECORD_NOT_FOUND');
1005: RAISE FND_API.g_exc_error;
1006: END IF; -- c_reg%NOTFOUND
1007: CLOSE c_reg;
1008:
1009:
1013: , p_registrant_account_id
1014: , l_return_status
1015: );
1016:
1017: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
1018: THEN
1019: RAISE FND_API.g_exc_unexpected_error;
1020: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1021: THEN
1015: );
1016:
1017: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
1018: THEN
1019: RAISE FND_API.g_exc_unexpected_error;
1020: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1021: THEN
1022: RAISE FND_API.g_exc_error;
1023: END IF; -- l_return_status
1016:
1017: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
1018: THEN
1019: RAISE FND_API.g_exc_unexpected_error;
1020: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1021: THEN
1022: RAISE FND_API.g_exc_error;
1023: END IF; -- l_return_status
1024:
1018: THEN
1019: RAISE FND_API.g_exc_unexpected_error;
1020: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1021: THEN
1022: RAISE FND_API.g_exc_error;
1023: END IF; -- l_return_status
1024:
1025: -- make changes to the record...
1026: l_evt_regs_rec.event_registration_id := NULL;
1043: l_evt_regs_rec.ATTENDANT_CONTACT_ID := nvl(p_attendant_contact_id,l_evt_regs_rec.ATTENDANT_CONTACT_ID);
1044:
1045: Insert_evtRegs( l_evt_regs_rec
1046: , p_system_status_code
1047: , FND_API.G_FALSE
1048: , x_new_confirmation_code
1049: , x_new_registration_id
1050: );
1051: x_new_system_status_code := p_system_status_code;
1051: x_new_system_status_code := p_system_status_code;
1052: -- should i be committing before cancel_evtregs call....or just use cancel_evtregs commit call
1053: -- something wrong happens...rollback...called in transfer and validate....return l_return status
1054:
1055: IF FND_API.to_boolean(p_commit)
1056: THEN
1057: COMMIT;
1058: END IF; -- p_commit
1059:
1056: THEN
1057: COMMIT;
1058: END IF; -- p_commit
1059:
1060: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1061: , p_count => x_msg_count
1062: , p_data => x_msg_data
1063: );
1064:
1071: END IF;
1072:
1073: EXCEPTION
1074:
1075: WHEN FND_API.g_exc_error
1076: THEN
1077: ROLLBACK TO transfer_insert_PVT;
1078: x_return_status := FND_API.g_ret_sts_error;
1079: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1074:
1075: WHEN FND_API.g_exc_error
1076: THEN
1077: ROLLBACK TO transfer_insert_PVT;
1078: x_return_status := FND_API.g_ret_sts_error;
1079: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1080: , p_count => x_msg_count
1081: , p_data => x_msg_data
1082: );
1075: WHEN FND_API.g_exc_error
1076: THEN
1077: ROLLBACK TO transfer_insert_PVT;
1078: x_return_status := FND_API.g_ret_sts_error;
1079: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1080: , p_count => x_msg_count
1081: , p_data => x_msg_data
1082: );
1083:
1080: , p_count => x_msg_count
1081: , p_data => x_msg_data
1082: );
1083:
1084: WHEN FND_API.g_exc_unexpected_error
1085: THEN
1086: ROLLBACK TO transfer_insert_PVT;
1087: x_return_status := FND_API.g_ret_sts_unexp_error;
1088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1083:
1084: WHEN FND_API.g_exc_unexpected_error
1085: THEN
1086: ROLLBACK TO transfer_insert_PVT;
1087: x_return_status := FND_API.g_ret_sts_unexp_error;
1088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1089: , p_count => x_msg_count
1090: , p_data => x_msg_data
1091: );
1084: WHEN FND_API.g_exc_unexpected_error
1085: THEN
1086: ROLLBACK TO transfer_insert_PVT;
1087: x_return_status := FND_API.g_ret_sts_unexp_error;
1088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1089: , p_count => x_msg_count
1090: , p_data => x_msg_data
1091: );
1092:
1092:
1093: WHEN OTHERS
1094: THEN
1095: ROLLBACK TO transfer_insert_PVT;
1096: x_return_status := FND_API.g_ret_sts_unexp_error;
1097:
1098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1099: THEN
1100: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1099: THEN
1100: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1101: END IF; -- check_msg_level
1102:
1103: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1104: , p_count => x_msg_count
1105: , p_data => x_msg_data
1106: );
1107:
1117: END Get_Reg_Rec;
1118:
1119:
1120: PROCEDURE Create_evtregs( P_Api_Version_Number IN NUMBER
1121: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1122: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1123: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1124: , p_evt_regs_rec IN evt_regs_Rec_Type
1125: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1118:
1119:
1120: PROCEDURE Create_evtregs( P_Api_Version_Number IN NUMBER
1121: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1122: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1123: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1124: , p_evt_regs_rec IN evt_regs_Rec_Type
1125: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1126: , x_event_registration_id OUT NOCOPY NUMBER
1119:
1120: PROCEDURE Create_evtregs( P_Api_Version_Number IN NUMBER
1121: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1122: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1123: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1124: , p_evt_regs_rec IN evt_regs_Rec_Type
1125: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1126: , x_event_registration_id OUT NOCOPY NUMBER
1127: , x_confirmation_code OUT NOCOPY VARCHAR2
1121: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1122: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1123: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1124: , p_evt_regs_rec IN evt_regs_Rec_Type
1125: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1126: , x_event_registration_id OUT NOCOPY NUMBER
1127: , x_confirmation_code OUT NOCOPY VARCHAR2
1128: , x_system_status_code OUT NOCOPY VARCHAR2
1129: , x_return_status OUT NOCOPY VARCHAR2
1174:
1175: AMS_Utility_PVT.debug_message(l_full_name||': start');
1176: END IF;
1177:
1178: IF FND_API.to_boolean(p_init_msg_list)
1179: THEN
1180: FND_MSG_PUB.initialize;
1181: END IF; -- p_init_msg_list
1182:
1180: FND_MSG_PUB.initialize;
1181: END IF; -- p_init_msg_list
1182:
1183: -- Standard call to check for call compatibility.
1184: IF (NOT FND_API.Compatible_API_Call( l_api_version_number
1185: , p_api_version_number
1186: , l_api_name
1187: , G_PKG_NAME
1188: )
1187: , G_PKG_NAME
1188: )
1189: )
1190: THEN
1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1192: END IF; -- compatible API call
1193:
1194: -- Initialize API return status to SUCCESS
1195: x_return_status := FND_API.G_RET_STS_SUCCESS;
1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1192: END IF; -- compatible API call
1193:
1194: -- Initialize API return status to SUCCESS
1195: x_return_status := FND_API.G_RET_STS_SUCCESS;
1196:
1197: -- Validate Environment
1198: IF (AMS_DEBUG_HIGH_ON) THEN
1199:
1209: , x_msg_count => x_msg_count
1210: , x_msg_data => x_msg_data
1211: );
1212:
1213: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1214: THEN
1215: RAISE FND_API.G_EXC_ERROR;
1216: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error
1217: THEN
1211: );
1212:
1213: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1214: THEN
1215: RAISE FND_API.G_EXC_ERROR;
1216: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error
1217: THEN
1218: RAISE FND_API.g_exc_unexpected_error;
1219: END IF; -- l_return_status
1212:
1213: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1214: THEN
1215: RAISE FND_API.G_EXC_ERROR;
1216: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error
1217: THEN
1218: RAISE FND_API.g_exc_unexpected_error;
1219: END IF; -- l_return_status
1220:
1214: THEN
1215: RAISE FND_API.G_EXC_ERROR;
1216: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error
1217: THEN
1218: RAISE FND_API.g_exc_unexpected_error;
1219: END IF; -- l_return_status
1220:
1221: -----------------------insert------------------
1222: IF (AMS_DEBUG_HIGH_ON) THEN
1264: IF ( (l_invite_only_override_flag = 'N')
1265: AND (contact_in_invite_list( l_event_offer_id
1266: , l_attendant_contact_id
1267: , l_attendant_party_id
1268: ) = FND_API.g_false
1269: )
1270: )
1271: THEN
1272: IF (AMS_DEBUG_HIGH_ON) THEN
1273:
1274: AMS_UTILITY_PVT.debug_message('The attendant is not on the invite list');
1275: END IF;
1276: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NOT_INVITED');
1277: x_return_status := FND_API.g_ret_sts_error;
1278: RAISE FND_API.G_EXC_ERROR;
1279: ELSE
1280: l_system_status_code := 'REGISTERED';
1281:
1274: AMS_UTILITY_PVT.debug_message('The attendant is not on the invite list');
1275: END IF;
1276: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NOT_INVITED');
1277: x_return_status := FND_API.g_ret_sts_error;
1278: RAISE FND_API.G_EXC_ERROR;
1279: ELSE
1280: l_system_status_code := 'REGISTERED';
1281:
1282: Insert_evtRegs( p_evt_regs_rec => l_evt_regs_rec
1295:
1296: AMS_UTILITY_PVT.DEBUG_MESSAGE ('Registration for this event offering is not required');
1297: END IF;
1298: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NOT_REQ');
1299: x_return_status := FND_API.g_ret_sts_error;
1300: RAISE FND_API.G_EXC_ERROR;
1301: ELSE --reg required flag is Y
1302: IF (sysdate < l_reg_start_date OR sysdate > l_reg_end_date OR (l_reg_start_date is null AND l_reg_end_date is null))
1303: THEN
1296: AMS_UTILITY_PVT.DEBUG_MESSAGE ('Registration for this event offering is not required');
1297: END IF;
1298: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NOT_REQ');
1299: x_return_status := FND_API.g_ret_sts_error;
1300: RAISE FND_API.G_EXC_ERROR;
1301: ELSE --reg required flag is Y
1302: IF (sysdate < l_reg_start_date OR sysdate > l_reg_end_date OR (l_reg_start_date is null AND l_reg_end_date is null))
1303: THEN
1304: IF (AMS_DEBUG_HIGH_ON) THEN
1304: IF (AMS_DEBUG_HIGH_ON) THEN
1305: AMS_UTILITY_PVT.debug_message('Registrations for this event is not open');
1306: END IF;
1307: AMS_UTILITY_PVT.error_message('AMS_EVENT_UNAVAIL_FOR_REG');
1308: x_return_status := FND_API.g_ret_sts_error;
1309: RAISE FND_API.G_EXC_ERROR;
1310: END IF;
1311:
1312: IF (l_reg_frozen_flag = 'Y')
1305: AMS_UTILITY_PVT.debug_message('Registrations for this event is not open');
1306: END IF;
1307: AMS_UTILITY_PVT.error_message('AMS_EVENT_UNAVAIL_FOR_REG');
1308: x_return_status := FND_API.g_ret_sts_error;
1309: RAISE FND_API.G_EXC_ERROR;
1310: END IF;
1311:
1312: IF (l_reg_frozen_flag = 'Y')
1313: THEN
1315:
1316: AMS_UTILITY_PVT.debug_message('Registrations for this event offering are no longer accepted');
1317: END IF;
1318: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_FROZEN');
1319: x_return_status := FND_API.g_ret_sts_error;
1320: RAISE FND_API.G_EXC_ERROR;
1321: END IF;
1322:
1323: IF ( (l_max_attendee_override_flag = 'Y')
1316: AMS_UTILITY_PVT.debug_message('Registrations for this event offering are no longer accepted');
1317: END IF;
1318: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_FROZEN');
1319: x_return_status := FND_API.g_ret_sts_error;
1320: RAISE FND_API.G_EXC_ERROR;
1321: END IF;
1322:
1323: IF ( (l_max_attendee_override_flag = 'Y')
1324: OR (l_waitlist_flag = 'N')
1345:
1346: AMS_UTILITY_PVT.debug_message('Registrations sold out. Waitlist not allowed for this event offering');
1347: END IF;
1348: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_WAIT_ALLOWED');
1349: x_return_status := FND_API.g_ret_sts_error;
1350: RAISE FND_API.G_EXC_ERROR;
1351: ELSE -- wailist allowed
1352: -- if (l_reg_waitlist_pct is NOT NULL)
1353: -- then
1346: AMS_UTILITY_PVT.debug_message('Registrations sold out. Waitlist not allowed for this event offering');
1347: END IF;
1348: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_WAIT_ALLOWED');
1349: x_return_status := FND_API.g_ret_sts_error;
1350: RAISE FND_API.G_EXC_ERROR;
1351: ELSE -- wailist allowed
1352: -- if (l_reg_waitlist_pct is NOT NULL)
1353: -- then
1354: if ( (nvl(l_waitlist_flag, 'X') <> 'Y')
1354: if ( (nvl(l_waitlist_flag, 'X') <> 'Y')
1355: AND (check_waitlist_availability( l_reg_waitlist_pct
1356: , l_effective_capacity
1357: , l_event_offer_id
1358: ) = FND_API.g_false
1359: )
1360: )
1361: THEN
1362: IF (AMS_DEBUG_HIGH_ON) THEN
1367:
1368: AMS_UTILITY_PVT.debug_message('Waiting list for this event offer ing is full');
1369: END IF;
1370: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_WAIT_AVAILABLE');
1371: x_return_status := FND_API.g_ret_sts_error;
1372: RAISE FND_API.G_EXC_ERROR;
1373: end if; -- check_waitlist_availability
1374: -- end if; -- l_reg_waitlist_pct
1375: l_system_status_code := 'WAITLISTED';
1368: AMS_UTILITY_PVT.debug_message('Waiting list for this event offer ing is full');
1369: END IF;
1370: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_WAIT_AVAILABLE');
1371: x_return_status := FND_API.g_ret_sts_error;
1372: RAISE FND_API.G_EXC_ERROR;
1373: end if; -- check_waitlist_availability
1374: -- end if; -- l_reg_waitlist_pct
1375: l_system_status_code := 'WAITLISTED';
1376: Insert_evtRegs( p_evt_regs_rec => l_evt_regs_rec
1386: END IF; -- Reg required flag is Y else N
1387: END IF; -- invite only flag is Y else N
1388: END IF; -- event offer id not null
1389:
1390: IF FND_API.to_boolean(p_commit)
1391: THEN
1392: COMMIT;
1393: END IF; -- p_commit
1394:
1391: THEN
1392: COMMIT;
1393: END IF; -- p_commit
1394:
1395: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1396: , p_count => x_msg_count
1397: , p_data => x_msg_data
1398: );
1399:
1406: END IF;
1407:
1408: EXCEPTION
1409:
1410: WHEN FND_API.g_exc_error
1411: THEN
1412: ROLLBACK TO CREATE_EvtRegs_PVT;
1413: x_return_status := FND_API.g_ret_sts_error;
1414: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1409:
1410: WHEN FND_API.g_exc_error
1411: THEN
1412: ROLLBACK TO CREATE_EvtRegs_PVT;
1413: x_return_status := FND_API.g_ret_sts_error;
1414: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1415: , p_count => x_msg_count
1416: , p_data => x_msg_data
1417: );
1410: WHEN FND_API.g_exc_error
1411: THEN
1412: ROLLBACK TO CREATE_EvtRegs_PVT;
1413: x_return_status := FND_API.g_ret_sts_error;
1414: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1415: , p_count => x_msg_count
1416: , p_data => x_msg_data
1417: );
1418:
1415: , p_count => x_msg_count
1416: , p_data => x_msg_data
1417: );
1418:
1419: WHEN FND_API.g_exc_unexpected_error
1420: THEN
1421: ROLLBACK TO CREATE_EvtRegs_PVT;
1422: x_return_status := FND_API.g_ret_sts_unexp_error ;
1423: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1418:
1419: WHEN FND_API.g_exc_unexpected_error
1420: THEN
1421: ROLLBACK TO CREATE_EvtRegs_PVT;
1422: x_return_status := FND_API.g_ret_sts_unexp_error ;
1423: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1424: , p_count => x_msg_count
1425: , p_data => x_msg_data
1426: );
1419: WHEN FND_API.g_exc_unexpected_error
1420: THEN
1421: ROLLBACK TO CREATE_EvtRegs_PVT;
1422: x_return_status := FND_API.g_ret_sts_unexp_error ;
1423: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1424: , p_count => x_msg_count
1425: , p_data => x_msg_data
1426: );
1427:
1427:
1428: WHEN OTHERS
1429: THEN
1430: ROLLBACK TO CREATE_EvtRegs_PVT;
1431: x_return_status := FND_API.g_ret_sts_unexp_error ;
1432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1433: THEN
1434: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1435: END IF;
1432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1433: THEN
1434: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1435: END IF;
1436: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1437: , p_count => x_msg_count
1438: , p_data => x_msg_data
1439: );
1440:
1440:
1441: End Create_evtregs;
1442:
1443: PROCEDURE UPDATE_evtregs_wrapper( P_Api_Version_Number IN NUMBER
1444: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1445: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1446: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1447: , P_evt_regs_Rec IN evt_regs_Rec_Type
1448: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1441: End Create_evtregs;
1442:
1443: PROCEDURE UPDATE_evtregs_wrapper( P_Api_Version_Number IN NUMBER
1444: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1445: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1446: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1447: , P_evt_regs_Rec IN evt_regs_Rec_Type
1448: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1449: , p_cancellation_reason_code IN VARCHAR2 := NULL
1442:
1443: PROCEDURE UPDATE_evtregs_wrapper( P_Api_Version_Number IN NUMBER
1444: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1445: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1446: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1447: , P_evt_regs_Rec IN evt_regs_Rec_Type
1448: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1449: , p_cancellation_reason_code IN VARCHAR2 := NULL
1450: , x_cancellation_code OUT NOCOPY VARCHAR2
1444: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1445: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1446: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1447: , P_evt_regs_Rec IN evt_regs_Rec_Type
1448: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1449: , p_cancellation_reason_code IN VARCHAR2 := NULL
1450: , x_cancellation_code OUT NOCOPY VARCHAR2
1451: , X_Return_Status OUT NOCOPY VARCHAR2
1452: , X_Msg_Count OUT NOCOPY NUMBER
1483: -- Standard Start of API savepoint
1484: SAVEPOINT UPDATE_evtregs_wrapper;
1485:
1486: -- Standard call to check for call compatibility.
1487: IF (NOT FND_API.Compatible_API_Call( l_api_version_number
1488: , p_api_version_number
1489: , l_api_name
1490: , G_PKG_NAME
1491: )
1490: , G_PKG_NAME
1491: )
1492: )
1493: THEN
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: END IF; -- compatible API call
1496:
1497:
1498: -- Initialize message list if p_init_msg_list is set to TRUE.
1495: END IF; -- compatible API call
1496:
1497:
1498: -- Initialize message list if p_init_msg_list is set to TRUE.
1499: IF (FND_API.to_Boolean(p_init_msg_list))
1500: THEN
1501: FND_MSG_PUB.initialize;
1502: END IF; -- p_init_msg_list
1503:
1501: FND_MSG_PUB.initialize;
1502: END IF; -- p_init_msg_list
1503:
1504: -- Initialize API return status to SUCCESS
1505: x_return_status := FND_API.G_RET_STS_SUCCESS;
1506:
1507: OPEN c_reg;
1508: FETCH c_reg
1509: INTO l_evt_regs_rec;
1509: INTO l_evt_regs_rec;
1510: IF c_reg%NOTFOUND THEN
1511: CLOSE c_reg;
1512: AMS_UTILITY_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
1513: RAISE FND_API.g_exc_error;
1514: END IF; -- c_reg%NOTFOUND
1515: CLOSE c_reg;
1516:
1517: open c_cancel_status_id;
1520: close c_cancel_status_id;
1521:
1522: -- soagrawa added on 29-jan-2003
1523: /* IF ((l_evt_regs_rec.user_status_id = p_evt_regs_rec.user_status_id
1524: OR p_evt_regs_rec.user_status_id = FND_API.g_miss_num)
1525: AND (l_evt_regs_rec.attended_flag = p_evt_regs_rec.attended_flag
1526: OR p_evt_regs_rec.attended_flag = FND_API.g_miss_char)
1527: AND (l_evt_regs_rec.reg_source_type_code = p_evt_regs_rec.reg_source_type_code
1528: OR p_evt_regs_rec.reg_source_type_code = FND_API.g_miss_char)
1522: -- soagrawa added on 29-jan-2003
1523: /* IF ((l_evt_regs_rec.user_status_id = p_evt_regs_rec.user_status_id
1524: OR p_evt_regs_rec.user_status_id = FND_API.g_miss_num)
1525: AND (l_evt_regs_rec.attended_flag = p_evt_regs_rec.attended_flag
1526: OR p_evt_regs_rec.attended_flag = FND_API.g_miss_char)
1527: AND (l_evt_regs_rec.reg_source_type_code = p_evt_regs_rec.reg_source_type_code
1528: OR p_evt_regs_rec.reg_source_type_code = FND_API.g_miss_char)
1529: )
1530: THEN
1524: OR p_evt_regs_rec.user_status_id = FND_API.g_miss_num)
1525: AND (l_evt_regs_rec.attended_flag = p_evt_regs_rec.attended_flag
1526: OR p_evt_regs_rec.attended_flag = FND_API.g_miss_char)
1527: AND (l_evt_regs_rec.reg_source_type_code = p_evt_regs_rec.reg_source_type_code
1528: OR p_evt_regs_rec.reg_source_type_code = FND_API.g_miss_char)
1529: )
1530: THEN
1531: AMS_UTILITY_PVT.debug_message('Nothing changed');
1532: RETURN;
1545: THEN
1546: -- trying to update both attended flag to Y and status to cancel
1547: -- A registrant who has already attended cannot have his registration cancelled.
1548: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_ATTENDED_1');
1549: RAISE FND_API.g_exc_error;
1550:
1551: ELSIF l_evt_regs_rec.user_status_id <> p_evt_regs_rec.user_status_id
1552: THEN
1553: -- trying to update status to cancel when attended flag is already Y
1552: THEN
1553: -- trying to update status to cancel when attended flag is already Y
1554: -- A registrant who has already attended cannot have his registration cancelled.
1555: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_ATTENDED_1');
1556: RAISE FND_API.g_exc_error;
1557:
1558: ELSIF p_evt_regs_Rec.attended_flag <> l_evt_regs_Rec.attended_flag
1559: THEN
1560: -- trying to update attended flag to Y when status is already cancelled
1559: THEN
1560: -- trying to update attended flag to Y when status is already cancelled
1561: -- Cannot update the Attended flag for the Registrant whose Registration Status is Cancelled.
1562: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_ATTENDED');
1563: RAISE FND_API.g_exc_error;
1564: END IF;
1565: END IF;
1566:
1567:
1599: END IF; -- l_cancel_id
1600:
1601: EXCEPTION
1602:
1603: WHEN FND_API.g_exc_error
1604: THEN
1605: ROLLBACK TO UPDATE_evtregs_wrapper;
1606: x_return_status := FND_API.g_ret_sts_error;
1607: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1602:
1603: WHEN FND_API.g_exc_error
1604: THEN
1605: ROLLBACK TO UPDATE_evtregs_wrapper;
1606: x_return_status := FND_API.g_ret_sts_error;
1607: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1608: , p_count => x_msg_count
1609: , p_data => x_msg_data
1610: );
1603: WHEN FND_API.g_exc_error
1604: THEN
1605: ROLLBACK TO UPDATE_evtregs_wrapper;
1606: x_return_status := FND_API.g_ret_sts_error;
1607: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1608: , p_count => x_msg_count
1609: , p_data => x_msg_data
1610: );
1611:
1608: , p_count => x_msg_count
1609: , p_data => x_msg_data
1610: );
1611:
1612: WHEN FND_API.g_exc_unexpected_error
1613: THEN
1614: ROLLBACK TO UPDATE_evtregs_wrapper;
1615: x_return_status := FND_API.g_ret_sts_unexp_error ;
1616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1611:
1612: WHEN FND_API.g_exc_unexpected_error
1613: THEN
1614: ROLLBACK TO UPDATE_evtregs_wrapper;
1615: x_return_status := FND_API.g_ret_sts_unexp_error ;
1616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1617: , p_count => x_msg_count
1618: , p_data => x_msg_data
1619: );
1612: WHEN FND_API.g_exc_unexpected_error
1613: THEN
1614: ROLLBACK TO UPDATE_evtregs_wrapper;
1615: x_return_status := FND_API.g_ret_sts_unexp_error ;
1616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1617: , p_count => x_msg_count
1618: , p_data => x_msg_data
1619: );
1620:
1620:
1621: WHEN OTHERS
1622: THEN
1623: ROLLBACK TO UPDATE_evtregs_wrapper;
1624: x_return_status := FND_API.g_ret_sts_unexp_error ;
1625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1626: THEN
1627: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1628: END IF;
1625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1626: THEN
1627: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1628: END IF;
1629: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1630: , p_count => x_msg_count
1631: , p_data => x_msg_data
1632: );
1633: END Update_evtregs_wrapper;
1632: );
1633: END Update_evtregs_wrapper;
1634:
1635: PROCEDURE Update_evtregs( P_Api_Version_Number IN NUMBER
1636: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1637: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1638: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1639: , P_evt_regs_Rec IN evt_regs_Rec_Type
1640: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1633: END Update_evtregs_wrapper;
1634:
1635: PROCEDURE Update_evtregs( P_Api_Version_Number IN NUMBER
1636: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1637: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1638: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1639: , P_evt_regs_Rec IN evt_regs_Rec_Type
1640: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1641: , X_Return_Status OUT NOCOPY VARCHAR2
1634:
1635: PROCEDURE Update_evtregs( P_Api_Version_Number IN NUMBER
1636: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1637: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1638: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1639: , P_evt_regs_Rec IN evt_regs_Rec_Type
1640: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1641: , X_Return_Status OUT NOCOPY VARCHAR2
1642: , X_Msg_Count OUT NOCOPY NUMBER
1636: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1637: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1638: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1639: , P_evt_regs_Rec IN evt_regs_Rec_Type
1640: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1641: , X_Return_Status OUT NOCOPY VARCHAR2
1642: , X_Msg_Count OUT NOCOPY NUMBER
1643: , X_Msg_Data OUT NOCOPY VARCHAR2
1644: )
1719: -- Standard Start of API savepoint
1720: SAVEPOINT UPDATE_EvtRegs_PVT;
1721:
1722: -- Standard call to check for call compatibility.
1723: IF (NOT FND_API.Compatible_API_Call( l_api_version_number
1724: , p_api_version_number
1725: , l_api_name
1726: , G_PKG_NAME
1727: )
1726: , G_PKG_NAME
1727: )
1728: )
1729: THEN
1730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1731: END IF; -- compatible API call
1732:
1733:
1734: -- Initialize message list if p_init_msg_list is set to TRUE.
1731: END IF; -- compatible API call
1732:
1733:
1734: -- Initialize message list if p_init_msg_list is set to TRUE.
1735: IF (FND_API.to_Boolean(p_init_msg_list))
1736: THEN
1737: FND_MSG_PUB.initialize;
1738: END IF; -- p_init_msg_list
1739:
1737: FND_MSG_PUB.initialize;
1738: END IF; -- p_init_msg_list
1739:
1740: -- Initialize API return status to SUCCESS
1741: x_return_status := FND_API.G_RET_STS_SUCCESS;
1742:
1743: -- add complete_evtreg_rec to complete rec with existing values instead of empty FND_API.g_miss_char
1744: -- replace g_miss_char/num/date with current column values
1745: IF (AMS_DEBUG_HIGH_ON) THEN
1739:
1740: -- Initialize API return status to SUCCESS
1741: x_return_status := FND_API.G_RET_STS_SUCCESS;
1742:
1743: -- add complete_evtreg_rec to complete rec with existing values instead of empty FND_API.g_miss_char
1744: -- replace g_miss_char/num/date with current column values
1745: IF (AMS_DEBUG_HIGH_ON) THEN
1746:
1747: AMS_Utility_PVT.debug_message(l_full_name ||': complete');
1756: END IF;
1757:
1758: -- Invoke validation procedures
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: );
1768:
1769: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
1770: THEN
1771: RAISE FND_API.g_exc_unexpected_error;
1772: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1773: THEN
1767: );
1768:
1769: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
1770: THEN
1771: RAISE FND_API.g_exc_unexpected_error;
1772: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1773: THEN
1774: RAISE FND_API.g_exc_error;
1775: END IF; -- l_return_status
1768:
1769: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
1770: THEN
1771: RAISE FND_API.g_exc_unexpected_error;
1772: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1773: THEN
1774: RAISE FND_API.g_exc_error;
1775: END IF; -- l_return_status
1776:
1770: THEN
1771: RAISE FND_API.g_exc_unexpected_error;
1772: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1773: THEN
1774: RAISE FND_API.g_exc_error;
1775: END IF; -- l_return_status
1776:
1777: OPEN c_old_reg_status(l_evt_regs_Rec.event_registration_id);
1778: FETCH c_old_reg_status
1788:
1789: IF (nvl(l_event_status, 'X') in ('ARCHIVED', 'CLOSED'))
1790: THEN
1791: AMS_Utility_PVT.Error_Message('AMS_EVENT_REG_UPDATE_ERROR', 'STATUS', l_event_status_name);
1792: RAISE FND_API.g_exc_error;
1793: END IF;
1794:
1795: -- make sure the status code matches the user status id
1796: OPEN c_get_status_code(l_evt_regs_Rec.user_status_id);
1807: )
1808: )
1809: THEN
1810: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_WAIT_AVAILABLE');
1811: RAISE FND_API.g_exc_error;
1812: END IF;
1813:
1814: IF ( (l_old_reg_status = 'WAITLISTED')
1815: AND (l_evt_regs_Rec.system_status_code = 'REGISTERED')
1893: and object_version_number = l_evt_regs_Rec.object_version_number;
1894:
1895: IF (SQL%NOTFOUND) THEN
1896: AMS_UTILITY_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
1897: RAISE FND_API.g_exc_error;
1898: END IF; -- SQL%NOTFOUND
1899:
1900: IF ( (l_old_reg_status = 'WAITLISTED')
1901: AND (l_evt_regs_Rec.system_status_code = 'REGISTERED')
1946: l_bind_values(1) := TO_CHAR(l_evt_regs_Rec.event_registration_id);
1947:
1948:
1949: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
1950: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
1951: )
1952: THEN
1953: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
1954: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
1950: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
1951: )
1952: THEN
1953: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
1954: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
1955: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
1956: , p_object_type => l_object_type -- IN VARCHAR2
1957: , p_object_id => l_object_id -- l_evt_regs_rec.event_offer_id -- IN NUMBER
1958: , p_trigger_type => 'REG_CONFIRM' -- IN VARCHAR2
1951: )
1952: THEN
1953: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
1954: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
1955: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
1956: , p_object_type => l_object_type -- IN VARCHAR2
1957: , p_object_id => l_object_id -- l_evt_regs_rec.event_offer_id -- IN NUMBER
1958: , p_trigger_type => 'REG_CONFIRM' -- IN VARCHAR2
1959: -- , p_requestor_type => -- IN VARCHAR2 := NULL
1984: IF (AMS_DEBUG_HIGH_ON) THEN
1985: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
1986: END IF;
1987:
1988: IF l_return_status = FND_API.g_ret_sts_error THEN
1989: RAISE FND_API.g_exc_error;
1990: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1991: RAISE FND_API.g_exc_unexpected_error;
1992: END IF;
1985: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
1986: END IF;
1987:
1988: IF l_return_status = FND_API.g_ret_sts_error THEN
1989: RAISE FND_API.g_exc_error;
1990: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1991: RAISE FND_API.g_exc_unexpected_error;
1992: END IF;
1993:
1986: END IF;
1987:
1988: IF l_return_status = FND_API.g_ret_sts_error THEN
1989: RAISE FND_API.g_exc_error;
1990: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1991: RAISE FND_API.g_exc_unexpected_error;
1992: END IF;
1993:
1994: END IF;
1987:
1988: IF l_return_status = FND_API.g_ret_sts_error THEN
1989: RAISE FND_API.g_exc_error;
1990: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1991: RAISE FND_API.g_exc_unexpected_error;
1992: END IF;
1993:
1994: END IF;
1995: END IF; -- ATTENDANCE FLAG
1996: END IF;
1997:
1998:
1999: -- Standard check for p_commit
2000: IF FND_API.to_Boolean( p_commit )
2001: THEN
2002: COMMIT WORK;
2003: END IF; -- p_commit
2004:
2001: THEN
2002: COMMIT WORK;
2003: END IF; -- p_commit
2004:
2005: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2006: , p_count => x_msg_count
2007: , p_data => x_msg_data
2008: );
2009:
2017:
2018:
2019: EXCEPTION
2020:
2021: WHEN FND_API.g_exc_error
2022: THEN
2023: ROLLBACK TO UPDATE_EvtRegs_PVT;
2024: x_return_status := FND_API.g_ret_sts_error;
2025: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2020:
2021: WHEN FND_API.g_exc_error
2022: THEN
2023: ROLLBACK TO UPDATE_EvtRegs_PVT;
2024: x_return_status := FND_API.g_ret_sts_error;
2025: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2026: , p_count => x_msg_count
2027: , p_data => x_msg_data
2028: );
2021: WHEN FND_API.g_exc_error
2022: THEN
2023: ROLLBACK TO UPDATE_EvtRegs_PVT;
2024: x_return_status := FND_API.g_ret_sts_error;
2025: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2026: , p_count => x_msg_count
2027: , p_data => x_msg_data
2028: );
2029:
2026: , p_count => x_msg_count
2027: , p_data => x_msg_data
2028: );
2029:
2030: WHEN FND_API.g_exc_unexpected_error
2031: THEN
2032: ROLLBACK TO UPDATE_EvtRegs_PVT;
2033: x_return_status := FND_API.g_ret_sts_unexp_error ;
2034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2029:
2030: WHEN FND_API.g_exc_unexpected_error
2031: THEN
2032: ROLLBACK TO UPDATE_EvtRegs_PVT;
2033: x_return_status := FND_API.g_ret_sts_unexp_error ;
2034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2035: , p_count => x_msg_count
2036: , p_data => x_msg_data
2037: );
2030: WHEN FND_API.g_exc_unexpected_error
2031: THEN
2032: ROLLBACK TO UPDATE_EvtRegs_PVT;
2033: x_return_status := FND_API.g_ret_sts_unexp_error ;
2034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2035: , p_count => x_msg_count
2036: , p_data => x_msg_data
2037: );
2038:
2038:
2039: WHEN OTHERS
2040: THEN
2041: ROLLBACK TO UPDATE_EvtRegs_PVT;
2042: x_return_status := FND_API.g_ret_sts_unexp_error ;
2043: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2044: THEN
2045: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2046: END IF; -- check_msg_level
2043: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2044: THEN
2045: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2046: END IF; -- check_msg_level
2047: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2048: , p_count => x_msg_count
2049: , p_data => x_msg_data
2050: );
2051:
2054: -- modified sugupta 06/21/2000
2055: -- return cancellation code as Varchar2
2056:
2057: PROCEDURE Cancel_evtregs( P_Api_Version_Number IN NUMBER
2058: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2059: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
2060: , p_object_version IN NUMBER
2061: , p_event_offer_id IN NUMBER
2062: , p_registrant_party_id IN NUMBER
2055: -- return cancellation code as Varchar2
2056:
2057: PROCEDURE Cancel_evtregs( P_Api_Version_Number IN NUMBER
2058: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2059: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
2060: , p_object_version IN NUMBER
2061: , p_event_offer_id IN NUMBER
2062: , p_registrant_party_id IN NUMBER
2063: , p_confirmation_code IN VARCHAR2
2062: , p_registrant_party_id IN NUMBER
2063: , p_confirmation_code IN VARCHAR2
2064: , p_registration_group_id IN NUMBER
2065: , p_cancellation_reason_code IN VARCHAR2
2066: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
2067: , x_cancellation_code OUT NOCOPY VARCHAR2
2068: , X_Return_Status OUT NOCOPY VARCHAR2
2069: , X_Msg_Count OUT NOCOPY NUMBER
2070: , X_Msg_Data OUT NOCOPY VARCHAR2
2196: AMS_Utility_PVT.debug_message(l_full_name || ': start');
2197: END IF;
2198:
2199: -- Standard call to check for call compatibility.
2200: IF (NOT FND_API.Compatible_API_Call( l_api_version_number
2201: , p_api_version_number
2202: , l_api_name
2203: , G_PKG_NAME
2204: )
2203: , G_PKG_NAME
2204: )
2205: )
2206: THEN
2207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2208: END IF; -- compatible API call
2209:
2210: -- Initialize message list if p_init_msg_list is set to TRUE.
2211: IF (FND_API.to_Boolean(p_init_msg_list))
2207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2208: END IF; -- compatible API call
2209:
2210: -- Initialize message list if p_init_msg_list is set to TRUE.
2211: IF (FND_API.to_Boolean(p_init_msg_list))
2212: THEN
2213: FND_MSG_PUB.initialize;
2214: END IF; -- p_init_msg_list
2215:
2213: FND_MSG_PUB.initialize;
2214: END IF; -- p_init_msg_list
2215:
2216: -- Initialize API return status to SUCCESS
2217: x_return_status := FND_API.G_RET_STS_SUCCESS;
2218:
2219: IF (AMS_DEBUG_HIGH_ON) THEN
2220: AMS_Utility_PVT.debug_message(l_full_name || ': cancel');
2221: END IF;
2256:
2257: AMS_UTILITY_PVT.debug_message(' Corresponding event offering information is not provided');
2258: END IF;
2259: AMS_Utility_PVT.error_message('AMS_EVT_REG_CANC_NO_EVOID');
2260: x_return_status := FND_API.g_ret_sts_error;
2261: RAISE FND_API.G_EXC_ERROR;
2262: ELSE
2263: IF l_registration_group_id is NULL
2264: THEN
2257: AMS_UTILITY_PVT.debug_message(' Corresponding event offering information is not provided');
2258: END IF;
2259: AMS_Utility_PVT.error_message('AMS_EVT_REG_CANC_NO_EVOID');
2260: x_return_status := FND_API.g_ret_sts_error;
2261: RAISE FND_API.G_EXC_ERROR;
2262: ELSE
2263: IF l_registration_group_id is NULL
2264: THEN
2265: IF l_confirmation_code is NULL
2268:
2269: AMS_UTILITY_PVT.debug_message(' Corresponding confirmation code for the event offering is not provided');
2270: END IF;
2271: AMS_Utility_PVT.error_message('AMS_EVT_REG_CANC_NO_CODE');
2272: x_return_status := FND_API.g_ret_sts_error;
2273: RAISE FND_API.G_EXC_ERROR;
2274: ELSE
2275: IF (AMS_DEBUG_HIGH_ON) THEN
2276:
2269: AMS_UTILITY_PVT.debug_message(' Corresponding confirmation code for the event offering is not provided');
2270: END IF;
2271: AMS_Utility_PVT.error_message('AMS_EVT_REG_CANC_NO_CODE');
2272: x_return_status := FND_API.g_ret_sts_error;
2273: RAISE FND_API.G_EXC_ERROR;
2274: ELSE
2275: IF (AMS_DEBUG_HIGH_ON) THEN
2276:
2277: AMS_Utility_PVT.debug_message(l_full_name ||': before off det cursor');
2299: END IF;
2300: IF (nvl(l_event_status, 'X') in ('ARCHIVED', 'CLOSED'))
2301: THEN
2302: AMS_Utility_PVT.Error_Message('AMS_EVENT_REG_UPDATE_ERROR', 'STATUS', l_event_status_name);
2303: RAISE FND_API.g_exc_error;
2304: END IF;
2305:
2306: IF (l_reg_charge_flag = 'N')
2307: THEN
2340: l_bind_names(1) := 'REGISTRATION_ID' ;
2341: l_bind_values(1):= TO_CHAR(l_event_registration_id) ;
2342:
2343: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2344: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2345: )
2346: THEN
2347:
2348: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2345: )
2346: THEN
2347:
2348: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2349: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2350: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2351: , p_object_type => l_object_type -- IN VARCHAR2
2352: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2353: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2346: THEN
2347:
2348: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2349: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2350: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2351: , p_object_type => l_object_type -- IN VARCHAR2
2352: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2353: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2354: -- , p_requestor_type => -- IN VARCHAR2 := NULL
2378: IF (AMS_DEBUG_HIGH_ON) THEN
2379: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2380: END IF;
2381:
2382: IF l_return_status = FND_API.g_ret_sts_error THEN
2383: RAISE FND_API.g_exc_error;
2384: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2385: RAISE FND_API.g_exc_unexpected_error;
2386: END IF;
2379: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2380: END IF;
2381:
2382: IF l_return_status = FND_API.g_ret_sts_error THEN
2383: RAISE FND_API.g_exc_error;
2384: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2385: RAISE FND_API.g_exc_unexpected_error;
2386: END IF;
2387:
2380: END IF;
2381:
2382: IF l_return_status = FND_API.g_ret_sts_error THEN
2383: RAISE FND_API.g_exc_error;
2384: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2385: RAISE FND_API.g_exc_unexpected_error;
2386: END IF;
2387:
2388: END IF;
2381:
2382: IF l_return_status = FND_API.g_ret_sts_error THEN
2383: RAISE FND_API.g_exc_error;
2384: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2385: RAISE FND_API.g_exc_unexpected_error;
2386: END IF;
2387:
2388: END IF;
2389: END IF; -- attended flag and sysdate
2396: , X_Return_Status => l_return_status
2397: , X_Msg_Count => x_msg_count
2398: , X_Msg_Data => x_msg_data
2399: );
2400: IF l_return_status = FND_API.g_ret_sts_unexp_error
2401: THEN
2402: RAISE FND_API.g_exc_unexpected_error;
2403: ELSIF l_return_status = FND_API.g_ret_sts_error
2404: THEN
2398: , X_Msg_Data => x_msg_data
2399: );
2400: IF l_return_status = FND_API.g_ret_sts_unexp_error
2401: THEN
2402: RAISE FND_API.g_exc_unexpected_error;
2403: ELSIF l_return_status = FND_API.g_ret_sts_error
2404: THEN
2405: RAISE FND_API.g_exc_error;
2406: END IF; -- l_return_status
2399: );
2400: IF l_return_status = FND_API.g_ret_sts_unexp_error
2401: THEN
2402: RAISE FND_API.g_exc_unexpected_error;
2403: ELSIF l_return_status = FND_API.g_ret_sts_error
2404: THEN
2405: RAISE FND_API.g_exc_error;
2406: END IF; -- l_return_status
2407:
2401: THEN
2402: RAISE FND_API.g_exc_unexpected_error;
2403: ELSIF l_return_status = FND_API.g_ret_sts_error
2404: THEN
2405: RAISE FND_API.g_exc_error;
2406: END IF; -- l_return_status
2407:
2408: ELSE
2409: IF (nvl(l_event_end_date, sysdate+1) < sysdate)
2447: l_bind_names(1) := 'REGISTRATION_ID' ;
2448: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2449:
2450: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2451: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2452: )
2453: THEN
2454: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2455: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2451: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2452: )
2453: THEN
2454: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2455: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2456: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2457: , p_object_type => l_object_type -- IN VARCHAR2
2458: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2459: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2452: )
2453: THEN
2454: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2455: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2456: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2457: , p_object_type => l_object_type -- IN VARCHAR2
2458: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2459: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2460: -- , p_requestor_type => -- IN VARCHAR2 := NULL
2486: IF (AMS_DEBUG_HIGH_ON) THEN
2487: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2488: END IF;
2489:
2490: IF l_return_status = FND_API.g_ret_sts_error THEN
2491: RAISE FND_API.g_exc_error;
2492: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2493: RAISE FND_API.g_exc_unexpected_error;
2494: END IF;
2487: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2488: END IF;
2489:
2490: IF l_return_status = FND_API.g_ret_sts_error THEN
2491: RAISE FND_API.g_exc_error;
2492: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2493: RAISE FND_API.g_exc_unexpected_error;
2494: END IF;
2495: END IF;
2488: END IF;
2489:
2490: IF l_return_status = FND_API.g_ret_sts_error THEN
2491: RAISE FND_API.g_exc_error;
2492: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2493: RAISE FND_API.g_exc_unexpected_error;
2494: END IF;
2495: END IF;
2496: END IF;
2489:
2490: IF l_return_status = FND_API.g_ret_sts_error THEN
2491: RAISE FND_API.g_exc_error;
2492: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2493: RAISE FND_API.g_exc_unexpected_error;
2494: END IF;
2495: END IF;
2496: END IF;
2497: x_cancellation_code := l_cancellation_code;
2503: , X_Return_Status => l_return_status
2504: , X_Msg_Count => x_msg_count
2505: , X_Msg_Data => x_msg_data
2506: );
2507: IF l_return_status = FND_API.g_ret_sts_unexp_error
2508: THEN
2509: RAISE FND_API.g_exc_unexpected_error;
2510: ELSIF l_return_status = FND_API.g_ret_sts_error
2511: THEN
2505: , X_Msg_Data => x_msg_data
2506: );
2507: IF l_return_status = FND_API.g_ret_sts_unexp_error
2508: THEN
2509: RAISE FND_API.g_exc_unexpected_error;
2510: ELSIF l_return_status = FND_API.g_ret_sts_error
2511: THEN
2512: RAISE FND_API.g_exc_error;
2513: END IF; -- l_return_status
2506: );
2507: IF l_return_status = FND_API.g_ret_sts_unexp_error
2508: THEN
2509: RAISE FND_API.g_exc_unexpected_error;
2510: ELSIF l_return_status = FND_API.g_ret_sts_error
2511: THEN
2512: RAISE FND_API.g_exc_error;
2513: END IF; -- l_return_status
2514:
2508: THEN
2509: RAISE FND_API.g_exc_unexpected_error;
2510: ELSIF l_return_status = FND_API.g_ret_sts_error
2511: THEN
2512: RAISE FND_API.g_exc_error;
2513: END IF; -- l_return_status
2514:
2515: END IF; -- event end date < sysdate
2516: END IF; -- reg charge flag
2556: END IF;
2557: IF (nvl(l_event_status, 'X') in ('ARCHIVED', 'CLOSED'))
2558: THEN
2559: AMS_Utility_PVT.Error_Message('AMS_EVENT_REG_UPDATE_ERROR', 'STATUS', l_event_status_name);
2560: RAISE FND_API.g_exc_error;
2561: END IF;
2562:
2563: IF (l_reg_charge_flag = 'N')
2564: THEN
2597: l_bind_names(1) := 'REGISTRATION_ID' ;
2598: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2599:
2600: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2601: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2602: )
2603: THEN
2604: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2605: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2601: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2602: )
2603: THEN
2604: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2605: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2606: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2607: , p_object_type => l_object_type -- IN VARCHAR2
2608: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2609: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2602: )
2603: THEN
2604: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2605: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2606: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2607: , p_object_type => l_object_type -- IN VARCHAR2
2608: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2609: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2610: -- , p_requestor_type => -- IN VARCHAR2 := NULL
2636: IF (AMS_DEBUG_HIGH_ON) THEN
2637: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2638: END IF;
2639:
2640: IF l_return_status = FND_API.g_ret_sts_error THEN
2641: RAISE FND_API.g_exc_error;
2642: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2643: RAISE FND_API.g_exc_unexpected_error;
2644: END IF;
2637: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2638: END IF;
2639:
2640: IF l_return_status = FND_API.g_ret_sts_error THEN
2641: RAISE FND_API.g_exc_error;
2642: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2643: RAISE FND_API.g_exc_unexpected_error;
2644: END IF;
2645: END IF;
2638: END IF;
2639:
2640: IF l_return_status = FND_API.g_ret_sts_error THEN
2641: RAISE FND_API.g_exc_error;
2642: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2643: RAISE FND_API.g_exc_unexpected_error;
2644: END IF;
2645: END IF;
2646: END IF;
2639:
2640: IF l_return_status = FND_API.g_ret_sts_error THEN
2641: RAISE FND_API.g_exc_error;
2642: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2643: RAISE FND_API.g_exc_unexpected_error;
2644: END IF;
2645: END IF;
2646: END IF;
2647: x_cancellation_code := l_cancellation_code;
2653: , X_Return_Status => l_return_status
2654: , X_Msg_Count => x_msg_count
2655: , X_Msg_Data => x_msg_data
2656: );
2657: IF l_return_status = FND_API.g_ret_sts_unexp_error
2658: THEN
2659: RAISE FND_API.g_exc_unexpected_error;
2660: ELSIF l_return_status = FND_API.g_ret_sts_error
2661: THEN
2655: , X_Msg_Data => x_msg_data
2656: );
2657: IF l_return_status = FND_API.g_ret_sts_unexp_error
2658: THEN
2659: RAISE FND_API.g_exc_unexpected_error;
2660: ELSIF l_return_status = FND_API.g_ret_sts_error
2661: THEN
2662: RAISE FND_API.g_exc_error;
2663: END IF; -- l_return_status
2656: );
2657: IF l_return_status = FND_API.g_ret_sts_unexp_error
2658: THEN
2659: RAISE FND_API.g_exc_unexpected_error;
2660: ELSIF l_return_status = FND_API.g_ret_sts_error
2661: THEN
2662: RAISE FND_API.g_exc_error;
2663: END IF; -- l_return_status
2664:
2658: THEN
2659: RAISE FND_API.g_exc_unexpected_error;
2660: ELSIF l_return_status = FND_API.g_ret_sts_error
2661: THEN
2662: RAISE FND_API.g_exc_error;
2663: END IF; -- l_return_status
2664:
2665: ELSE
2666: IF (l_event_end_date < sysdate)
2672: IF (AMS_DEBUG_HIGH_ON) THEN
2673:
2674: AMS_UTILITY_PVT.debug_message('AMS_EVT_REG_CANC_DATE');
2675: END IF;
2676: x_return_status := FND_API.g_ret_sts_error;
2677: RAISE FND_API.G_EXC_ERROR;
2678: ELSE
2679: IF (l_cancellation_code IS NULL)
2680: THEN
2673:
2674: AMS_UTILITY_PVT.debug_message('AMS_EVT_REG_CANC_DATE');
2675: END IF;
2676: x_return_status := FND_API.g_ret_sts_error;
2677: RAISE FND_API.G_EXC_ERROR;
2678: ELSE
2679: IF (l_cancellation_code IS NULL)
2680: THEN
2681: OPEN c_evtregs_cancel_seq;
2711: l_bind_names(1) := 'REGISTRATION_ID' ;
2712: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2713:
2714: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2715: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2716: )
2717: THEN
2718: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2719: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2715: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2716: )
2717: THEN
2718: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2719: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2720: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2721: , p_object_type => l_object_type -- IN VARCHAR2
2722: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2723: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2716: )
2717: THEN
2718: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2719: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2720: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2721: , p_object_type => l_object_type -- IN VARCHAR2
2722: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2723: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2724: -- , p_requestor_type => -- IN VARCHAR2 := NULL
2750: IF (AMS_DEBUG_HIGH_ON) THEN
2751: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2752: END IF;
2753:
2754: IF l_return_status = FND_API.g_ret_sts_error THEN
2755: RAISE FND_API.g_exc_error;
2756: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2757: RAISE FND_API.g_exc_unexpected_error;
2758: END IF;
2751: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2752: END IF;
2753:
2754: IF l_return_status = FND_API.g_ret_sts_error THEN
2755: RAISE FND_API.g_exc_error;
2756: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2757: RAISE FND_API.g_exc_unexpected_error;
2758: END IF;
2759: END IF;
2752: END IF;
2753:
2754: IF l_return_status = FND_API.g_ret_sts_error THEN
2755: RAISE FND_API.g_exc_error;
2756: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2757: RAISE FND_API.g_exc_unexpected_error;
2758: END IF;
2759: END IF;
2760: END IF;
2753:
2754: IF l_return_status = FND_API.g_ret_sts_error THEN
2755: RAISE FND_API.g_exc_error;
2756: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2757: RAISE FND_API.g_exc_unexpected_error;
2758: END IF;
2759: END IF;
2760: END IF;
2761: x_cancellation_code := l_cancellation_code;
2767: , X_Return_Status => l_return_status
2768: , X_Msg_Count => x_msg_count
2769: , X_Msg_Data => x_msg_data
2770: );
2771: IF l_return_status = FND_API.g_ret_sts_unexp_error
2772: THEN
2773: RAISE FND_API.g_exc_unexpected_error;
2774: ELSIF l_return_status = FND_API.g_ret_sts_error
2775: THEN
2769: , X_Msg_Data => x_msg_data
2770: );
2771: IF l_return_status = FND_API.g_ret_sts_unexp_error
2772: THEN
2773: RAISE FND_API.g_exc_unexpected_error;
2774: ELSIF l_return_status = FND_API.g_ret_sts_error
2775: THEN
2776: RAISE FND_API.g_exc_error;
2777: END IF; -- l_return_status
2770: );
2771: IF l_return_status = FND_API.g_ret_sts_unexp_error
2772: THEN
2773: RAISE FND_API.g_exc_unexpected_error;
2774: ELSIF l_return_status = FND_API.g_ret_sts_error
2775: THEN
2776: RAISE FND_API.g_exc_error;
2777: END IF; -- l_return_status
2778: END IF; -- event end date
2772: THEN
2773: RAISE FND_API.g_exc_unexpected_error;
2774: ELSIF l_return_status = FND_API.g_ret_sts_error
2775: THEN
2776: RAISE FND_API.g_exc_error;
2777: END IF; -- l_return_status
2778: END IF; -- event end date
2779: END IF; -- reg charge flag
2780: END IF; -- CONF CODE NOT NULL
2782: END IF; -- registration group id null
2783: END IF; -- event offer id
2784:
2785: -- Standard check for p_commit
2786: IF (FND_API.to_Boolean(p_commit))
2787: THEN
2788: COMMIT WORK;
2789: END IF; -- p_commit
2790:
2788: COMMIT WORK;
2789: END IF; -- p_commit
2790:
2791: -- Standard call to get message count and if count is 1, get message info.
2792: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2793: , p_count => x_msg_count
2794: , p_data => x_msg_data
2795: );
2796:
2803: END IF;
2804:
2805: EXCEPTION
2806:
2807: WHEN FND_API.g_exc_error
2808: THEN
2809: ROLLBACK TO Cancel_EvtRegs_PVT;
2810: x_return_status := FND_API.g_ret_sts_error;
2811: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2806:
2807: WHEN FND_API.g_exc_error
2808: THEN
2809: ROLLBACK TO Cancel_EvtRegs_PVT;
2810: x_return_status := FND_API.g_ret_sts_error;
2811: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2812: , p_count => x_msg_count
2813: , p_data => x_msg_data
2814: );
2807: WHEN FND_API.g_exc_error
2808: THEN
2809: ROLLBACK TO Cancel_EvtRegs_PVT;
2810: x_return_status := FND_API.g_ret_sts_error;
2811: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2812: , p_count => x_msg_count
2813: , p_data => x_msg_data
2814: );
2815:
2812: , p_count => x_msg_count
2813: , p_data => x_msg_data
2814: );
2815:
2816: WHEN FND_API.g_exc_unexpected_error
2817: THEN
2818: ROLLBACK TO Cancel_EvtRegs_PVT;
2819: x_return_status := FND_API.g_ret_sts_unexp_error;
2820: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2815:
2816: WHEN FND_API.g_exc_unexpected_error
2817: THEN
2818: ROLLBACK TO Cancel_EvtRegs_PVT;
2819: x_return_status := FND_API.g_ret_sts_unexp_error;
2820: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2821: , p_count => x_msg_count
2822: , p_data => x_msg_data
2823: );
2816: WHEN FND_API.g_exc_unexpected_error
2817: THEN
2818: ROLLBACK TO Cancel_EvtRegs_PVT;
2819: x_return_status := FND_API.g_ret_sts_unexp_error;
2820: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2821: , p_count => x_msg_count
2822: , p_data => x_msg_data
2823: );
2824:
2824:
2825: WHEN OTHERS
2826: THEN
2827: ROLLBACK TO Cancel_EvtRegs_PVT;
2828: x_return_status := FND_API.g_ret_sts_unexp_error;
2829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2830: THEN
2831: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2832: END IF; -- check_msg_level
2829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2830: THEN
2831: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2832: END IF; -- check_msg_level
2833: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2834: , p_count => x_msg_count
2835: , p_data => x_msg_data
2836: );
2837:
2837:
2838: End Cancel_evtregs;
2839:
2840: PROCEDURE lock_evtregs( p_api_version_Number IN NUMBER
2841: , p_init_msg_list IN VARCHAR2 := FND_API.g_false
2842: , p_validation_level IN NUMBER := FND_API.g_valid_level_full
2843: , x_return_status OUT NOCOPY VARCHAR2
2844: , x_msg_count OUT NOCOPY NUMBER
2845: , x_msg_data OUT NOCOPY VARCHAR2
2838: End Cancel_evtregs;
2839:
2840: PROCEDURE lock_evtregs( p_api_version_Number IN NUMBER
2841: , p_init_msg_list IN VARCHAR2 := FND_API.g_false
2842: , p_validation_level IN NUMBER := FND_API.g_valid_level_full
2843: , x_return_status OUT NOCOPY VARCHAR2
2844: , x_msg_count OUT NOCOPY NUMBER
2845: , x_msg_data OUT NOCOPY VARCHAR2
2846: , p_event_registration_id IN NUMBER
2868:
2869: AMS_Utility_PVT.debug_message(l_full_name||': start');
2870: END IF;
2871:
2872: IF FND_API.to_boolean(p_init_msg_list)
2873: THEN
2874: FND_MSG_PUB.initialize;
2875: END IF; -- p_init_msg_list
2876:
2873: THEN
2874: FND_MSG_PUB.initialize;
2875: END IF; -- p_init_msg_list
2876:
2877: IF (NOT FND_API.compatible_api_call( l_api_version_number
2878: , p_api_version_number
2879: , l_api_name
2880: , g_pkg_name
2881: )
2880: , g_pkg_name
2881: )
2882: )
2883: THEN
2884: RAISE FND_API.g_exc_unexpected_error;
2885: END IF; -- compatible API call
2886:
2887: x_return_status := FND_API.G_RET_STS_SUCCESS;
2888:
2883: THEN
2884: RAISE FND_API.g_exc_unexpected_error;
2885: END IF; -- compatible API call
2886:
2887: x_return_status := FND_API.G_RET_STS_SUCCESS;
2888:
2889: ------------------------ lock -------------------------
2890: IF (AMS_DEBUG_HIGH_ON) THEN
2891:
2898: IF (c_reg_b%NOTFOUND)
2899: THEN
2900: CLOSE c_reg_b;
2901: AMS_Utility_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
2902: RAISE FND_API.g_exc_error;
2903: END IF;
2904: CLOSE c_reg_b;
2905:
2906: -------------------- finish --------------------------
2903: END IF;
2904: CLOSE c_reg_b;
2905:
2906: -------------------- finish --------------------------
2907: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2908: , p_count => x_msg_count
2909: , p_data => x_msg_data
2910: );
2911:
2920: EXCEPTION
2921:
2922: WHEN AMS_Utility_PVT.resource_locked
2923: THEN
2924: x_return_status := FND_API.g_ret_sts_error;
2925: AMS_Utility_PVT.error_message('AMS_API_RESOURCE_LOCKED');
2926: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2927: , p_count => x_msg_count
2928: , p_data => x_msg_data
2922: WHEN AMS_Utility_PVT.resource_locked
2923: THEN
2924: x_return_status := FND_API.g_ret_sts_error;
2925: AMS_Utility_PVT.error_message('AMS_API_RESOURCE_LOCKED');
2926: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2927: , p_count => x_msg_count
2928: , p_data => x_msg_data
2929: );
2930:
2927: , p_count => x_msg_count
2928: , p_data => x_msg_data
2929: );
2930:
2931: WHEN FND_API.g_exc_error
2932: THEN
2933: x_return_status := FND_API.g_ret_sts_error;
2934: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2935: , p_count => x_msg_count
2929: );
2930:
2931: WHEN FND_API.g_exc_error
2932: THEN
2933: x_return_status := FND_API.g_ret_sts_error;
2934: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2935: , p_count => x_msg_count
2936: , p_data => x_msg_data
2937: );
2930:
2931: WHEN FND_API.g_exc_error
2932: THEN
2933: x_return_status := FND_API.g_ret_sts_error;
2934: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2935: , p_count => x_msg_count
2936: , p_data => x_msg_data
2937: );
2938:
2935: , p_count => x_msg_count
2936: , p_data => x_msg_data
2937: );
2938:
2939: WHEN FND_API.g_exc_unexpected_error
2940: THEN
2941: x_return_status := FND_API.g_ret_sts_unexp_error;
2942: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2943: , p_count => x_msg_count
2937: );
2938:
2939: WHEN FND_API.g_exc_unexpected_error
2940: THEN
2941: x_return_status := FND_API.g_ret_sts_unexp_error;
2942: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2943: , p_count => x_msg_count
2944: , p_data => x_msg_data
2945: );
2938:
2939: WHEN FND_API.g_exc_unexpected_error
2940: THEN
2941: x_return_status := FND_API.g_ret_sts_unexp_error;
2942: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2943: , p_count => x_msg_count
2944: , p_data => x_msg_data
2945: );
2946:
2945: );
2946:
2947: WHEN OTHERS
2948: THEN
2949: x_return_status := FND_API.g_ret_sts_unexp_error;
2950: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
2951: THEN
2952: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2953: END IF; -- check_msg_Level
2950: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
2951: THEN
2952: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2953: END IF; -- check_msg_Level
2954: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2955: , p_count => x_msg_count
2956: , p_data => x_msg_data
2957: );
2958:
2958:
2959: END lock_evtregs;
2960:
2961: PROCEDURE delete_evtRegs( p_api_version_number IN NUMBER
2962: , p_init_msg_list IN VARCHAR2 := FND_API.g_false
2963: , p_commit IN VARCHAR2 := FND_API.g_false
2964: , p_object_version IN NUMBER
2965: , p_event_registration_id IN NUMBER
2966: , x_return_status OUT NOCOPY VARCHAR2
2959: END lock_evtregs;
2960:
2961: PROCEDURE delete_evtRegs( p_api_version_number IN NUMBER
2962: , p_init_msg_list IN VARCHAR2 := FND_API.g_false
2963: , p_commit IN VARCHAR2 := FND_API.g_false
2964: , p_object_version IN NUMBER
2965: , p_event_registration_id IN NUMBER
2966: , x_return_status OUT NOCOPY VARCHAR2
2967: , x_msg_count OUT NOCOPY NUMBER
2982:
2983: AMS_Utility_PVT.debug_message(l_full_name||': start');
2984: END IF;
2985:
2986: IF FND_API.to_boolean(p_init_msg_list)
2987: THEN
2988: FND_MSG_PUB.initialize;
2989: END IF; -- p_init_msg_list
2990:
2987: THEN
2988: FND_MSG_PUB.initialize;
2989: END IF; -- p_init_msg_list
2990:
2991: IF (NOT FND_API.compatible_api_call( l_api_version_number
2992: , p_api_version_number
2993: , l_api_name
2994: , g_pkg_name
2995: )
2994: , g_pkg_name
2995: )
2996: )
2997: THEN
2998: RAISE FND_API.g_exc_unexpected_error;
2999: END IF; -- compatible API call
3000:
3001: x_return_status := FND_API.G_RET_STS_SUCCESS;
3002:
2997: THEN
2998: RAISE FND_API.g_exc_unexpected_error;
2999: END IF; -- compatible API call
3000:
3001: x_return_status := FND_API.G_RET_STS_SUCCESS;
3002:
3003: ------------------------ delete ------------------------
3004: IF (AMS_DEBUG_HIGH_ON) THEN
3005:
3013:
3014: IF (SQL%NOTFOUND)
3015: THEN
3016: AMS_Utility_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
3017: RAISE FND_API.g_exc_error;
3018: END IF; -- SQL%NOTFOUND
3019:
3020: -------------------- finish --------------------------
3021: IF (FND_API.to_boolean(p_commit))
3017: RAISE FND_API.g_exc_error;
3018: END IF; -- SQL%NOTFOUND
3019:
3020: -------------------- finish --------------------------
3021: IF (FND_API.to_boolean(p_commit))
3022: THEN
3023: COMMIT;
3024: END IF; -- p_commit
3025:
3022: THEN
3023: COMMIT;
3024: END IF; -- p_commit
3025:
3026: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3027: , p_count => x_msg_count
3028: , p_data => x_msg_data
3029: );
3030:
3037: END IF;
3038:
3039: EXCEPTION
3040:
3041: WHEN FND_API.g_exc_error
3042: THEN
3043: ROLLBACK TO delete_evtRegs;
3044: x_return_status := FND_API.g_ret_sts_error;
3045: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3040:
3041: WHEN FND_API.g_exc_error
3042: THEN
3043: ROLLBACK TO delete_evtRegs;
3044: x_return_status := FND_API.g_ret_sts_error;
3045: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3046: , p_count => x_msg_count
3047: , p_data => x_msg_data
3048: );
3041: WHEN FND_API.g_exc_error
3042: THEN
3043: ROLLBACK TO delete_evtRegs;
3044: x_return_status := FND_API.g_ret_sts_error;
3045: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3046: , p_count => x_msg_count
3047: , p_data => x_msg_data
3048: );
3049:
3046: , p_count => x_msg_count
3047: , p_data => x_msg_data
3048: );
3049:
3050: WHEN FND_API.g_exc_unexpected_error
3051: THEN
3052: ROLLBACK TO delete_evtRegs;
3053: x_return_status := FND_API.g_ret_sts_unexp_error ;
3054: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3049:
3050: WHEN FND_API.g_exc_unexpected_error
3051: THEN
3052: ROLLBACK TO delete_evtRegs;
3053: x_return_status := FND_API.g_ret_sts_unexp_error ;
3054: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3055: , p_count => x_msg_count
3056: , p_data => x_msg_data
3057: );
3050: WHEN FND_API.g_exc_unexpected_error
3051: THEN
3052: ROLLBACK TO delete_evtRegs;
3053: x_return_status := FND_API.g_ret_sts_unexp_error ;
3054: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3055: , p_count => x_msg_count
3056: , p_data => x_msg_data
3057: );
3058:
3058:
3059: WHEN OTHERS
3060: THEN
3061: ROLLBACK TO delete_evtRegs;
3062: x_return_status := FND_API.g_ret_sts_unexp_error ;
3063: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3064: THEN
3065: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3066: END IF; -- check_msg_level
3063: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3064: THEN
3065: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3066: END IF; -- check_msg_level
3067: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3068: , p_count => x_msg_count
3069: , p_data => x_msg_data
3070: );
3071:
3071:
3072: END delete_evtRegs;
3073:
3074: PROCEDURE prioritize_waitlist( p_api_version_number IN NUMBER
3075: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3076: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3077: , p_override_availability IN VARCHAR2 := FND_API.G_FALSE
3078: , p_event_offer_id IN NUMBER
3079: , x_return_status OUT NOCOPY VARCHAR2
3072: END delete_evtRegs;
3073:
3074: PROCEDURE prioritize_waitlist( p_api_version_number IN NUMBER
3075: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3076: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3077: , p_override_availability IN VARCHAR2 := FND_API.G_FALSE
3078: , p_event_offer_id IN NUMBER
3079: , x_return_status OUT NOCOPY VARCHAR2
3080: , x_msg_count OUT NOCOPY NUMBER
3073:
3074: PROCEDURE prioritize_waitlist( p_api_version_number IN NUMBER
3075: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3076: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3077: , p_override_availability IN VARCHAR2 := FND_API.G_FALSE
3078: , p_event_offer_id IN NUMBER
3079: , x_return_status OUT NOCOPY VARCHAR2
3080: , x_msg_count OUT NOCOPY NUMBER
3081: , x_msg_data OUT NOCOPY VARCHAR2
3170:
3171: AMS_Utility_PVT.debug_message(l_full_name||': start');
3172: END IF;
3173:
3174: IF FND_API.to_boolean(p_init_msg_list)
3175: THEN
3176: FND_MSG_PUB.initialize;
3177: END IF; -- p_init_msg_list
3178:
3175: THEN
3176: FND_MSG_PUB.initialize;
3177: END IF; -- p_init_msg_list
3178:
3179: IF (NOT FND_API.compatible_api_call( l_api_version_number
3180: , p_api_version_number
3181: , l_api_name
3182: , g_pkg_name
3183: )
3182: , g_pkg_name
3183: )
3184: )
3185: THEN
3186: RAISE FND_API.g_exc_unexpected_error;
3187: END IF; -- compatible API call
3188:
3189: -- Initialize API return status to SUCCESS
3190: l_return_status := FND_API.G_RET_STS_SUCCESS;
3186: RAISE FND_API.g_exc_unexpected_error;
3187: END IF; -- compatible API call
3188:
3189: -- Initialize API return status to SUCCESS
3190: l_return_status := FND_API.G_RET_STS_SUCCESS;
3191:
3192: -- validate not null values passed for required parameters...
3193: IF (p_event_offer_id IS NULL)
3194: THEN
3192: -- validate not null values passed for required parameters...
3193: IF (p_event_offer_id IS NULL)
3194: THEN
3195: AMS_Utility_PVT.error_message('AMS_EVT_REG_PR_NULL_PARAM');
3196: l_return_status := FND_API.g_ret_sts_error;
3197: END IF; -- p_event_offer_id
3198:
3199: /* check Offer id's fk .....*/
3200: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3199: /* check Offer id's fk .....*/
3200: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3201: , 'event_offer_id'
3202: , p_event_offer_id
3203: ) = FND_API.g_false
3204: )
3205: THEN
3206: AMS_Utility_PVT.error_message('AMS_EVT_REG_PR_BAD_EVOID');
3207: l_return_status := FND_API.g_ret_sts_error;
3203: ) = FND_API.g_false
3204: )
3205: THEN
3206: AMS_Utility_PVT.error_message('AMS_EVT_REG_PR_BAD_EVOID');
3207: l_return_status := FND_API.g_ret_sts_error;
3208: -- RAISE FND_API.g_exc_error;
3209: END IF; -- check_fk_exists
3210:
3211: ------------------api logic-----------------------
3204: )
3205: THEN
3206: AMS_Utility_PVT.error_message('AMS_EVT_REG_PR_BAD_EVOID');
3207: l_return_status := FND_API.g_ret_sts_error;
3208: -- RAISE FND_API.g_exc_error;
3209: END IF; -- check_fk_exists
3210:
3211: ------------------api logic-----------------------
3212: -- Get the offering details of offer id
3248:
3249: AMS_UTILITY_PVT.debug_message('Registrations for the event offering are frozen- Cannot prioritize your wait');
3250: END IF;
3251: -- AMS_Utility_PVT.error_message('AMS_EVT_REG_PRI_FROZEN');
3252: -- RAISE FND_API.G_EXC_ERROR;
3253: RETURN;
3254: END IF; -- l_reg_frozen_flag
3255:
3256: if ( (p_override_availability = FND_API.G_FALSE)
3252: -- RAISE FND_API.G_EXC_ERROR;
3253: RETURN;
3254: END IF; -- l_reg_frozen_flag
3255:
3256: if ( (p_override_availability = FND_API.G_FALSE)
3257: AND
3258: (check_reg_availability( l_effective_capacity
3259: , p_event_offer_id
3260: ) <= 0
3265:
3266: AMS_UTILITY_PVT.debug_message('No Waitlist Available');
3267: END IF;
3268: -- AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_WAIT_ALLOWED');
3269: -- RAISE FND_API.G_EXC_ERROR;
3270: RETURN;
3271: END IF;
3272:
3273: OPEN c_prioritize_waiting_minnum(p_event_offer_id);
3287: THEN
3288: /*
3289: -- create task for notification
3290: AMS_TASK_PVT.Create_task( p_api_version => l_api_version_number
3291: , p_init_msg_list => FND_API.g_false
3292: , p_commit => FND_API.g_false
3293: , p_task_id => NULL
3294: , p_task_name => 'wait list registration task for - '||l_event_offer_name
3295: , p_task_type_id => 15 -- from jtf_task_types_vl
3288: /*
3289: -- create task for notification
3290: AMS_TASK_PVT.Create_task( p_api_version => l_api_version_number
3291: , p_init_msg_list => FND_API.g_false
3292: , p_commit => FND_API.g_false
3293: , p_task_id => NULL
3294: , p_task_name => 'wait list registration task for - '||l_event_offer_name
3295: , p_task_type_id => 15 -- from jtf_task_types_vl
3296: , p_task_status_id => 13 -- in jtf_task_statuses_vl, 13
3308: , x_msg_count => x_msg_count
3309: , x_msg_data => x_msg_data
3310: , x_task_id => l_task_id
3311: );
3312: IF (l_return_status = FND_API.g_ret_sts_error)
3313: THEN
3314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3315: THEN
3316: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3315: THEN
3316: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3317: END IF; -- check_msg_level
3318: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3319: , p_count => x_msg_count
3320: , p_data => x_msg_data
3321: );
3322: RAISE FND_API.g_exc_error;
3318: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3319: , p_count => x_msg_count
3320: , p_data => x_msg_data
3321: );
3322: RAISE FND_API.g_exc_error;
3323: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3324: THEN
3325: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3326: THEN
3319: , p_count => x_msg_count
3320: , p_data => x_msg_data
3321: );
3322: RAISE FND_API.g_exc_error;
3323: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3324: THEN
3325: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3326: THEN
3327: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3325: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3326: THEN
3327: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3328: END IF; -- check_msg_level
3329: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3330: , p_count => x_msg_count
3331: , p_data => x_msg_data
3332: );
3333: RAISE FND_API.g_exc_unexpected_error;
3329: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3330: , p_count => x_msg_count
3331: , p_data => x_msg_data
3332: );
3333: RAISE FND_API.g_exc_unexpected_error;
3334: END IF; -- l_return_status
3335: -- create task assignment
3336: IF (AMS_DEBUG_HIGH_ON) THEN
3337:
3337:
3338: AMS_Utility_PVT.debug_message('calling AMS_TASK_PVT.Create_Task_Assignment');
3339: END IF;
3340: AMS_TASK_PVT.Create_Task_Assignment( p_api_version => l_api_version_number
3341: , p_init_msg_list => FND_API.g_false
3342: , p_commit => FND_API.g_false
3343: , p_task_id => l_task_id
3344: , p_resource_type_code => 'RS_EMPLOYEE'
3345: , p_resource_id => l_sales_rep_id
3338: AMS_Utility_PVT.debug_message('calling AMS_TASK_PVT.Create_Task_Assignment');
3339: END IF;
3340: AMS_TASK_PVT.Create_Task_Assignment( p_api_version => l_api_version_number
3341: , p_init_msg_list => FND_API.g_false
3342: , p_commit => FND_API.g_false
3343: , p_task_id => l_task_id
3344: , p_resource_type_code => 'RS_EMPLOYEE'
3345: , p_resource_id => l_sales_rep_id
3346: , p_assignment_status_id => 1
3348: , x_msg_count => x_msg_count
3349: , x_msg_data => x_msg_data
3350: , x_task_assignment_id => l_task_assignment_id
3351: );
3352: IF (l_return_status = FND_API.g_ret_sts_error)
3353: THEN
3354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3355: THEN
3356: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3355: THEN
3356: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3357: END IF; -- check_msg_level
3358: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3359: , p_count => x_msg_count
3360: , p_data => x_msg_data
3361: );
3362: RAISE FND_API.g_exc_error;
3358: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3359: , p_count => x_msg_count
3360: , p_data => x_msg_data
3361: );
3362: RAISE FND_API.g_exc_error;
3363: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3364: THEN
3365: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3366: THEN
3359: , p_count => x_msg_count
3360: , p_data => x_msg_data
3361: );
3362: RAISE FND_API.g_exc_error;
3363: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3364: THEN
3365: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3366: THEN
3367: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3365: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3366: THEN
3367: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3368: END IF; -- check_msg_level
3369: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3370: , p_count => x_msg_count
3371: , p_data => x_msg_data
3372: );
3373: RAISE FND_API.g_exc_unexpected_error;
3369: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3370: , p_count => x_msg_count
3371: , p_data => x_msg_data
3372: );
3373: RAISE FND_API.g_exc_unexpected_error;
3374: END IF; -- l_return_status
3375: ELSE -- l_e_auto_register_flag
3376: */
3377: update ams_event_registrations set
3394:
3395: IF (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
3396: THEN
3397: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
3398: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
3399: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
3400: , p_object_type => l_object_type -- IN VARCHAR2
3401: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
3402: , p_trigger_type => 'REG_CONFIRM' -- IN VARCHAR2
3395: IF (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
3396: THEN
3397: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
3398: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
3399: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
3400: , p_object_type => l_object_type -- IN VARCHAR2
3401: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
3402: , p_trigger_type => 'REG_CONFIRM' -- IN VARCHAR2
3403: -- , p_requestor_type => -- IN VARCHAR2 := NULL
3429: IF (AMS_DEBUG_HIGH_ON) THEN
3430: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
3431: END IF;
3432:
3433: IF l_return_status = FND_API.g_ret_sts_error THEN
3434: RAISE FND_API.g_exc_error;
3435: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3436: RAISE FND_API.g_exc_unexpected_error;
3437: END IF;
3430: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
3431: END IF;
3432:
3433: IF l_return_status = FND_API.g_ret_sts_error THEN
3434: RAISE FND_API.g_exc_error;
3435: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3436: RAISE FND_API.g_exc_unexpected_error;
3437: END IF;
3438:
3431: END IF;
3432:
3433: IF l_return_status = FND_API.g_ret_sts_error THEN
3434: RAISE FND_API.g_exc_error;
3435: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3436: RAISE FND_API.g_exc_unexpected_error;
3437: END IF;
3438:
3439: END IF;
3432:
3433: IF l_return_status = FND_API.g_ret_sts_error THEN
3434: RAISE FND_API.g_exc_error;
3435: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3436: RAISE FND_API.g_exc_unexpected_error;
3437: END IF;
3438:
3439: END IF;
3440:
3452:
3453: x_return_status := l_return_status;
3454:
3455: -- Standard check for p_commit
3456: IF (FND_API.to_Boolean(p_commit))
3457: THEN
3458: COMMIT WORK;
3459: END IF; -- p_commit
3460:
3457: THEN
3458: COMMIT WORK;
3459: END IF; -- p_commit
3460:
3461: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3462: , p_count => x_msg_count
3463: , p_data => x_msg_data
3464: );
3465:
3472: END IF;
3473:
3474: EXCEPTION
3475:
3476: WHEN FND_API.g_exc_error
3477: THEN
3478: ROLLBACK TO prioritize_waitlist;
3479: x_return_status := FND_API.g_ret_sts_error;
3480: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3475:
3476: WHEN FND_API.g_exc_error
3477: THEN
3478: ROLLBACK TO prioritize_waitlist;
3479: x_return_status := FND_API.g_ret_sts_error;
3480: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3481: , p_count => x_msg_count
3482: , p_data => x_msg_data
3483: );
3476: WHEN FND_API.g_exc_error
3477: THEN
3478: ROLLBACK TO prioritize_waitlist;
3479: x_return_status := FND_API.g_ret_sts_error;
3480: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3481: , p_count => x_msg_count
3482: , p_data => x_msg_data
3483: );
3484:
3481: , p_count => x_msg_count
3482: , p_data => x_msg_data
3483: );
3484:
3485: WHEN FND_API.g_exc_unexpected_error
3486: THEN
3487: ROLLBACK TO prioritize_waitlist;
3488: x_return_status := FND_API.g_ret_sts_unexp_error;
3489: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3484:
3485: WHEN FND_API.g_exc_unexpected_error
3486: THEN
3487: ROLLBACK TO prioritize_waitlist;
3488: x_return_status := FND_API.g_ret_sts_unexp_error;
3489: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3490: , p_count => x_msg_count
3491: , p_data => x_msg_data
3492: );
3485: WHEN FND_API.g_exc_unexpected_error
3486: THEN
3487: ROLLBACK TO prioritize_waitlist;
3488: x_return_status := FND_API.g_ret_sts_unexp_error;
3489: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3490: , p_count => x_msg_count
3491: , p_data => x_msg_data
3492: );
3493:
3493:
3494: WHEN OTHERS
3495: THEN
3496: ROLLBACK TO prioritize_waitlist;
3497: x_return_status := FND_API.g_ret_sts_unexp_error;
3498: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3499: THEN
3500: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3501: END IF; -- check_msg_level
3498: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3499: THEN
3500: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3501: END IF; -- check_msg_level
3502: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3503: , p_count => x_msg_count
3504: , p_data => x_msg_data
3505: );
3506:
3524: -- 'Attendant information' is mandatory, but for account information...
3525: -- if registrant info is changed, reg_contact id is stored in original_reg_contact_id column..
3526: -------------------------------------------------------------
3527: PROCEDURE substitute_and_validate( P_Api_Version_Number IN NUMBER
3528: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3529: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3530: , p_confirmation_code IN VARCHAR2
3531: , p_attendant_party_id IN NUMBER
3532: , p_attendant_contact_id IN NUMBER
3525: -- if registrant info is changed, reg_contact id is stored in original_reg_contact_id column..
3526: -------------------------------------------------------------
3527: PROCEDURE substitute_and_validate( P_Api_Version_Number IN NUMBER
3528: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3529: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3530: , p_confirmation_code IN VARCHAR2
3531: , p_attendant_party_id IN NUMBER
3532: , p_attendant_contact_id IN NUMBER
3533: , p_attendant_account_id IN NUMBER
3555:
3556: AMS_Utility_PVT.debug_message(l_full_name || ': start');
3557: END IF;
3558:
3559: IF FND_API.to_boolean(p_init_msg_list)
3560: THEN
3561: FND_MSG_PUB.initialize;
3562: END IF; -- p_init_msg_list
3563:
3560: THEN
3561: FND_MSG_PUB.initialize;
3562: END IF; -- p_init_msg_list
3563:
3564: IF (NOT FND_API.compatible_api_call( l_api_version_number
3565: , p_api_version_number
3566: , l_api_name
3567: , g_pkg_name
3568: )
3567: , g_pkg_name
3568: )
3569: )
3570: THEN
3571: RAISE FND_API.g_exc_unexpected_error;
3572: END IF; -- compatible API call
3573:
3574: -- Initialize API return status to SUCCESS
3575: l_return_status := FND_API.G_RET_STS_SUCCESS;
3571: RAISE FND_API.g_exc_unexpected_error;
3572: END IF; -- compatible API call
3573:
3574: -- Initialize API return status to SUCCESS
3575: l_return_status := FND_API.G_RET_STS_SUCCESS;
3576:
3577: -- validate not null values passed for required parameters...
3578: IF ( (p_confirmation_code IS NULL)
3579: OR (p_attendant_party_id IS NULL)
3581: OR (p_registrant_contact_id IS NULL)
3582: )
3583: THEN
3584: AMS_Utility_PVT.error_message('AMS_EVT_REG_SUBST_NULL_PARAM');
3585: x_return_status := FND_API.g_ret_sts_error;
3586: RAISE FND_API.g_exc_error;
3587: END IF; -- null ids
3588:
3589: -- validate the registrant fk info....
3582: )
3583: THEN
3584: AMS_Utility_PVT.error_message('AMS_EVT_REG_SUBST_NULL_PARAM');
3585: x_return_status := FND_API.g_ret_sts_error;
3586: RAISE FND_API.g_exc_error;
3587: END IF; -- null ids
3588:
3589: -- validate the registrant fk info....
3590: check_registrant_fk_info( p_registrant_party_id
3592: , p_registrant_account_id
3593: , x_return_status => l_return_status
3594: );
3595:
3596: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3597: THEN
3598: RAISE FND_API.g_exc_unexpected_error;
3599: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3600: THEN
3594: );
3595:
3596: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3597: THEN
3598: RAISE FND_API.g_exc_unexpected_error;
3599: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3600: THEN
3601: RAISE FND_API.g_exc_error;
3602: END IF; -- l_return_status
3595:
3596: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3597: THEN
3598: RAISE FND_API.g_exc_unexpected_error;
3599: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3600: THEN
3601: RAISE FND_API.g_exc_error;
3602: END IF; -- l_return_status
3603:
3597: THEN
3598: RAISE FND_API.g_exc_unexpected_error;
3599: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3600: THEN
3601: RAISE FND_API.g_exc_error;
3602: END IF; -- l_return_status
3603:
3604: -- update sql stmt
3605: -------------------------- update --------------------
3620:
3621: IF (SQL%NOTFOUND)
3622: THEN
3623: AMS_Utility_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
3624: RAISE FND_API.g_exc_error;
3625: END IF; -- SQL%NOTFOUND
3626:
3627: -- Standard check for p_commit
3628: IF (FND_API.to_Boolean(p_commit))
3624: RAISE FND_API.g_exc_error;
3625: END IF; -- SQL%NOTFOUND
3626:
3627: -- Standard check for p_commit
3628: IF (FND_API.to_Boolean(p_commit))
3629: THEN
3630: COMMIT WORK;
3631: END IF; -- p_commit
3632:
3629: THEN
3630: COMMIT WORK;
3631: END IF; -- p_commit
3632:
3633: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3634: , p_count => x_msg_count
3635: , p_data => x_msg_data
3636: );
3637:
3643:
3644: END IF;
3645:
3646: EXCEPTION
3647: WHEN FND_API.g_exc_error
3648: THEN
3649: ROLLBACK TO substitute_validate_PVT;
3650: x_return_status := FND_API.g_ret_sts_error;
3651: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3646: EXCEPTION
3647: WHEN FND_API.g_exc_error
3648: THEN
3649: ROLLBACK TO substitute_validate_PVT;
3650: x_return_status := FND_API.g_ret_sts_error;
3651: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3652: , p_count => x_msg_count
3653: , p_data => x_msg_data
3654: );
3647: WHEN FND_API.g_exc_error
3648: THEN
3649: ROLLBACK TO substitute_validate_PVT;
3650: x_return_status := FND_API.g_ret_sts_error;
3651: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3652: , p_count => x_msg_count
3653: , p_data => x_msg_data
3654: );
3655:
3652: , p_count => x_msg_count
3653: , p_data => x_msg_data
3654: );
3655:
3656: WHEN FND_API.g_exc_unexpected_error
3657: THEN
3658: ROLLBACK TO substitute_validate_PVT;
3659: x_return_status := FND_API.g_ret_sts_unexp_error;
3660: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3655:
3656: WHEN FND_API.g_exc_unexpected_error
3657: THEN
3658: ROLLBACK TO substitute_validate_PVT;
3659: x_return_status := FND_API.g_ret_sts_unexp_error;
3660: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3661: , p_count => x_msg_count
3662: , p_data => x_msg_data
3663: );
3656: WHEN FND_API.g_exc_unexpected_error
3657: THEN
3658: ROLLBACK TO substitute_validate_PVT;
3659: x_return_status := FND_API.g_ret_sts_unexp_error;
3660: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3661: , p_count => x_msg_count
3662: , p_data => x_msg_data
3663: );
3664:
3664:
3665: WHEN OTHERS
3666: THEN
3667: ROLLBACK TO substitute_validate_PVT;
3668: x_return_status := FND_API.g_ret_sts_unexp_error;
3669: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3670: THEN
3671: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3672: END IF; -- check_msg_level
3669: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3670: THEN
3671: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3672: END IF; -- check_msg_level
3673: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3674: , p_count => x_msg_count
3675: , p_data => x_msg_data
3676: );
3677:
3696: -- the transfer will fail...
3697: -- PAYMENT details are not taken care of in this API call....
3698: -------------------------------------------------------------
3699: PROCEDURE transfer_and_validate( P_Api_Version_Number IN NUMBER
3700: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3701: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3702: , p_object_version IN NUMBER
3703: , p_old_confirmation_code IN VARCHAR2
3704: , p_old_offer_id IN NUMBER
3697: -- PAYMENT details are not taken care of in this API call....
3698: -------------------------------------------------------------
3699: PROCEDURE transfer_and_validate( P_Api_Version_Number IN NUMBER
3700: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3701: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3702: , p_object_version IN NUMBER
3703: , p_old_confirmation_code IN VARCHAR2
3704: , p_old_offer_id IN NUMBER
3705: , p_new_offer_id IN NUMBER
3759:
3760: AMS_Utility_PVT.debug_message(l_full_name || ': start');
3761: END IF;
3762:
3763: IF FND_API.to_boolean(p_init_msg_list)
3764: THEN
3765: FND_MSG_PUB.initialize;
3766: END IF; -- p_init_msg_list
3767:
3764: THEN
3765: FND_MSG_PUB.initialize;
3766: END IF; -- p_init_msg_list
3767:
3768: IF (NOT FND_API.compatible_api_call( l_api_version_number
3769: , p_api_version_number
3770: , l_api_name
3771: , g_pkg_name
3772: )
3771: , g_pkg_name
3772: )
3773: )
3774: THEN
3775: RAISE FND_API.g_exc_unexpected_error;
3776: END IF; -- compatible API call
3777:
3778: -- Initialize API return status to SUCCESS
3779: l_return_status := FND_API.G_RET_STS_SUCCESS;
3775: RAISE FND_API.g_exc_unexpected_error;
3776: END IF; -- compatible API call
3777:
3778: -- Initialize API return status to SUCCESS
3779: l_return_status := FND_API.G_RET_STS_SUCCESS;
3780:
3781: -- validate not null values passed for required parameters...
3782: IF ( (p_old_confirmation_code IS NULL)
3783: OR (p_old_offer_id IS NULL)
3785: OR (p_waitlist_flag IS NULL)
3786: )
3787: THEN
3788: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_NULL_PARAM');
3789: x_return_status := FND_API.g_ret_sts_error;
3790: RAISE FND_API.g_exc_error;
3791: END IF; -- null ids
3792:
3793: -- check Offer id's fk .....
3786: )
3787: THEN
3788: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_NULL_PARAM');
3789: x_return_status := FND_API.g_ret_sts_error;
3790: RAISE FND_API.g_exc_error;
3791: END IF; -- null ids
3792:
3793: -- check Offer id's fk .....
3794: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3793: -- check Offer id's fk .....
3794: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3795: , 'event_offer_id'
3796: , p_old_offer_id
3797: ) = FND_API.g_false
3798: )
3799: THEN
3800: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3801: x_return_status := FND_API.g_ret_sts_error;
3797: ) = FND_API.g_false
3798: )
3799: THEN
3800: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3801: x_return_status := FND_API.g_ret_sts_error;
3802: RAISE FND_API.g_exc_error;
3803: END IF; -- check_fk_exists
3804:
3805: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3798: )
3799: THEN
3800: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3801: x_return_status := FND_API.g_ret_sts_error;
3802: RAISE FND_API.g_exc_error;
3803: END IF; -- check_fk_exists
3804:
3805: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3806: , 'event_offer_id'
3804:
3805: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3806: , 'event_offer_id'
3807: , p_new_offer_id
3808: ) = FND_API.g_false
3809: )
3810: THEN
3811: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3812: x_return_status := FND_API.g_ret_sts_error;
3808: ) = FND_API.g_false
3809: )
3810: THEN
3811: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3812: x_return_status := FND_API.g_ret_sts_error;
3813: RAISE FND_API.g_exc_error;
3814: END IF; -- check_fk_exists
3815:
3816: -- Prevent cancelled registrants from cancelled (probably should not be at this level in the tech stack)
3809: )
3810: THEN
3811: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3812: x_return_status := FND_API.g_ret_sts_error;
3813: RAISE FND_API.g_exc_error;
3814: END IF; -- check_fk_exists
3815:
3816: -- Prevent cancelled registrants from cancelled (probably should not be at this level in the tech stack)
3817: open get_registrant_status(p_old_confirmation_code);
3821:
3822: IF (nvl(l_system_status_code,'X') = 'CANCELLED')
3823: THEN
3824: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_CANCEL');
3825: RAISE FND_API.g_exc_error;
3826: END IF; -- l_system_status_code
3827:
3828: ------------------api logic-----------------------
3829: -- Get the offering details of new offer id
3861: , X_Return_Status => l_return_status
3862: , X_Msg_Count => x_msg_count
3863: , X_Msg_Data => x_msg_data
3864: );
3865: IF l_return_status = FND_API.g_ret_sts_unexp_error
3866: THEN
3867: RAISE FND_API.g_exc_unexpected_error;
3868: ELSIF l_return_status = FND_API.g_ret_sts_error
3869: THEN
3863: , X_Msg_Data => x_msg_data
3864: );
3865: IF l_return_status = FND_API.g_ret_sts_unexp_error
3866: THEN
3867: RAISE FND_API.g_exc_unexpected_error;
3868: ELSIF l_return_status = FND_API.g_ret_sts_error
3869: THEN
3870: RAISE FND_API.g_exc_error;
3871: END IF; -- l_return_status
3864: );
3865: IF l_return_status = FND_API.g_ret_sts_unexp_error
3866: THEN
3867: RAISE FND_API.g_exc_unexpected_error;
3868: ELSIF l_return_status = FND_API.g_ret_sts_error
3869: THEN
3870: RAISE FND_API.g_exc_error;
3871: END IF; -- l_return_status
3872:
3866: THEN
3867: RAISE FND_API.g_exc_unexpected_error;
3868: ELSIF l_return_status = FND_API.g_ret_sts_error
3869: THEN
3870: RAISE FND_API.g_exc_error;
3871: END IF; -- l_return_status
3872:
3873: x_old_system_status_code := 'CANCELLED';
3874: IF (AMS_DEBUG_HIGH_ON) THEN
3915: , x_Msg_Count => x_msg_count
3916: , x_Msg_Data => x_msg_data
3917: );
3918:
3919: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3920: THEN
3921: RAISE FND_API.g_exc_unexpected_error;
3922: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3923: THEN
3917: );
3918:
3919: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3920: THEN
3921: RAISE FND_API.g_exc_unexpected_error;
3922: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3923: THEN
3924: RAISE FND_API.g_exc_error;
3925: END IF; -- l_return_status
3918:
3919: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3920: THEN
3921: RAISE FND_API.g_exc_unexpected_error;
3922: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3923: THEN
3924: RAISE FND_API.g_exc_error;
3925: END IF; -- l_return_status
3926: x_new_system_status_code := l_system_status_code;
3920: THEN
3921: RAISE FND_API.g_exc_unexpected_error;
3922: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3923: THEN
3924: RAISE FND_API.g_exc_error;
3925: END IF; -- l_return_status
3926: x_new_system_status_code := l_system_status_code;
3927:
3928: -- if reg successfull....call cancel_reg for old event offer id and pass out cancellation code for old
3941: , X_Msg_Count => x_msg_count
3942: , X_Msg_Data => x_msg_data
3943: );
3944:
3945: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3946: THEN
3947: RAISE FND_API.g_exc_unexpected_error;
3948: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3949: THEN
3943: );
3944:
3945: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3946: THEN
3947: RAISE FND_API.g_exc_unexpected_error;
3948: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3949: THEN
3950: RAISE FND_API.g_exc_error;
3951: END IF; -- l_return_status
3944:
3945: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3946: THEN
3947: RAISE FND_API.g_exc_unexpected_error;
3948: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3949: THEN
3950: RAISE FND_API.g_exc_error;
3951: END IF; -- l_return_status
3952: x_old_system_status_code := 'CANCELLED';
3946: THEN
3947: RAISE FND_API.g_exc_unexpected_error;
3948: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3949: THEN
3950: RAISE FND_API.g_exc_error;
3951: END IF; -- l_return_status
3952: x_old_system_status_code := 'CANCELLED';
3953:
3954: ELSE -- check_reg_availability
3965: ELSE -- wailist allowed
3966: if (check_waitlist_availability( l_reg_waitlist_pct
3967: , l_effective_capacity
3968: , p_new_offer_id
3969: ) = FND_API.g_false
3970: )
3971: then
3972: IF (AMS_DEBUG_HIGH_ON) THEN
3973:
3998: , x_Msg_Count => x_msg_count
3999: , x_Msg_Data => x_msg_data
4000: );
4001:
4002: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4003: RAISE FND_API.g_exc_unexpected_error;
4004: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4005: RAISE FND_API.g_exc_error;
4006: END IF;
3999: , x_Msg_Data => x_msg_data
4000: );
4001:
4002: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4003: RAISE FND_API.g_exc_unexpected_error;
4004: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4005: RAISE FND_API.g_exc_error;
4006: END IF;
4007: x_new_system_status_code := l_system_status_code;
4000: );
4001:
4002: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4003: RAISE FND_API.g_exc_unexpected_error;
4004: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4005: RAISE FND_API.g_exc_error;
4006: END IF;
4007: x_new_system_status_code := l_system_status_code;
4008:
4001:
4002: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4003: RAISE FND_API.g_exc_unexpected_error;
4004: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4005: RAISE FND_API.g_exc_error;
4006: END IF;
4007: x_new_system_status_code := l_system_status_code;
4008:
4009: -- if waitlisting is successfull....call cancel_reg for old event offer id....
4023: , X_Msg_Count => x_msg_count
4024: , X_Msg_Data => x_msg_data
4025: );
4026:
4027: IF l_return_status = FND_API.g_ret_sts_unexp_error
4028: THEN
4029: RAISE FND_API.g_exc_unexpected_error;
4030: ELSIF l_return_status = FND_API.g_ret_sts_error
4031: THEN
4025: );
4026:
4027: IF l_return_status = FND_API.g_ret_sts_unexp_error
4028: THEN
4029: RAISE FND_API.g_exc_unexpected_error;
4030: ELSIF l_return_status = FND_API.g_ret_sts_error
4031: THEN
4032: RAISE FND_API.g_exc_error;
4033: END IF;
4026:
4027: IF l_return_status = FND_API.g_ret_sts_unexp_error
4028: THEN
4029: RAISE FND_API.g_exc_unexpected_error;
4030: ELSIF l_return_status = FND_API.g_ret_sts_error
4031: THEN
4032: RAISE FND_API.g_exc_error;
4033: END IF;
4034: x_old_system_status_code := 'CANCELLED';
4028: THEN
4029: RAISE FND_API.g_exc_unexpected_error;
4030: ELSIF l_return_status = FND_API.g_ret_sts_error
4031: THEN
4032: RAISE FND_API.g_exc_error;
4033: END IF;
4034: x_old_system_status_code := 'CANCELLED';
4035: end if; -- waitlist available
4036: END IF; -- wailist allowed
4039: END IF; --Reg required flag
4040:
4041:
4042: -- Standard check for p_commit
4043: IF (FND_API.to_Boolean(p_commit))
4044: THEN
4045: COMMIT WORK;
4046: END IF; -- p_commit
4047:
4044: THEN
4045: COMMIT WORK;
4046: END IF; -- p_commit
4047:
4048: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4049: , p_count => x_msg_count
4050: , p_data => x_msg_data
4051: );
4052:
4058:
4059: END IF;
4060:
4061: EXCEPTION
4062: WHEN FND_API.g_exc_error
4063: THEN
4064: ROLLBACK TO transfer_validate_PVT;
4065: x_return_status := FND_API.g_ret_sts_error;
4066: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4061: EXCEPTION
4062: WHEN FND_API.g_exc_error
4063: THEN
4064: ROLLBACK TO transfer_validate_PVT;
4065: x_return_status := FND_API.g_ret_sts_error;
4066: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4067: , p_count => x_msg_count
4068: , p_data => x_msg_data
4069: );
4062: WHEN FND_API.g_exc_error
4063: THEN
4064: ROLLBACK TO transfer_validate_PVT;
4065: x_return_status := FND_API.g_ret_sts_error;
4066: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4067: , p_count => x_msg_count
4068: , p_data => x_msg_data
4069: );
4070:
4067: , p_count => x_msg_count
4068: , p_data => x_msg_data
4069: );
4070:
4071: WHEN FND_API.g_exc_unexpected_error
4072: THEN
4073: ROLLBACK TO transfer_validate_PVT;
4074: x_return_status := FND_API.g_ret_sts_unexp_error ;
4075: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4070:
4071: WHEN FND_API.g_exc_unexpected_error
4072: THEN
4073: ROLLBACK TO transfer_validate_PVT;
4074: x_return_status := FND_API.g_ret_sts_unexp_error ;
4075: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4076: , p_count => x_msg_count
4077: , p_data => x_msg_data
4078: );
4071: WHEN FND_API.g_exc_unexpected_error
4072: THEN
4073: ROLLBACK TO transfer_validate_PVT;
4074: x_return_status := FND_API.g_ret_sts_unexp_error ;
4075: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4076: , p_count => x_msg_count
4077: , p_data => x_msg_data
4078: );
4079:
4079:
4080: WHEN OTHERS
4081: THEN
4082: ROLLBACK TO transfer_validate_PVT;
4083: x_return_status := FND_API.g_ret_sts_unexp_error ;
4084: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4085: THEN
4086: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4087: END IF; -- check_msg_level
4084: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4085: THEN
4086: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4087: END IF; -- check_msg_level
4088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4089: , p_count => x_msg_count
4090: , p_data => x_msg_data
4091: );
4092:
4112: IS
4113:
4114: BEGIN
4115:
4116: x_return_status := FND_API.g_ret_sts_success;
4117: ------------------------ owner_user_id --------------------------
4118: IF (p_evt_Regs_rec.owner_user_id IS NULL)
4119: THEN
4120: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_OWNER_ID');
4117: ------------------------ owner_user_id --------------------------
4118: IF (p_evt_Regs_rec.owner_user_id IS NULL)
4119: THEN
4120: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_OWNER_ID');
4121: x_return_status := FND_API.g_ret_sts_error;
4122: RETURN;
4123: END IF;
4124:
4125: /* Should user status be mandatory .. it wont be passed from screen, but derived from system status
4130: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_NO_USER_STATUS');
4131: FND_MSG_PUB.add;
4132: END IF;
4133:
4134: x_return_status := FND_API.g_ret_sts_error;
4135: RETURN;
4136: END IF;
4137: */
4138:
4139: ----------------------REG PARTY ID---------------------------------
4140: IF (p_evt_Regs_rec.registrant_party_id IS NULL)
4141: THEN
4142: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_PARTY');
4143: x_return_status := FND_API.g_ret_sts_error;
4144: RETURN;
4145: END IF;
4146:
4147: ------------------------ payment status-Order header/line id --------------------------
4151: THEN
4152: IF (p_evt_Regs_rec.order_header_id IS NULL)
4153: THEN
4154: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_ORDER_HEADER');
4155: x_return_status := FND_API.g_ret_sts_error;
4156: RETURN;
4157: END IF; -- order_header_id
4158: ELSIF (p_evt_Regs_rec.payment_status_code = 'FREE')
4159: THEN
4159: THEN
4160: IF (p_evt_Regs_rec.order_header_id IS NOT NULL)
4161: THEN
4162: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_ORDER_HEADER');
4163: x_return_status := FND_API.g_ret_sts_error;
4164: RETURN;
4165: END IF; -- order_header_id
4166: END IF; -- payment_status_code
4167: END IF; -- payment_status_code is not null
4171: AND (p_evt_Regs_rec.order_header_id IS NULL)
4172: )
4173: THEN
4174: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_ORDER_HEADER');
4175: x_return_status := FND_API.g_ret_sts_error;
4176: RETURN;
4177: END IF; -- order_line_id/order_header_id
4178:
4179: ------------------------ Order header/line id-Account needed------------------
4185: AND (p_evt_regs_rec.attendant_account_id IS NULL)
4186: )
4187: THEN
4188: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_ACCT_FOR_ORDER');
4189: x_return_status := FND_API.g_ret_sts_error;
4190: RETURN;
4191: END IF; -- registrant_account_id/attendant_account_id
4192: END IF; -- order_line_id/order_header_id
4193:
4194: -----------------------REG CONTACT ID-----------------------------------
4195: IF (p_evt_Regs_rec.registrant_contact_id IS NULL)
4196: THEN
4197: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_CONTACT_ID');
4198: x_return_status := FND_API.g_ret_sts_error;
4199: RETURN;
4200: END IF; -- registrant_contact_id
4201:
4202: END check_evtRegs_req_items;
4222:
4223: BEGIN
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: )
4230: )
4231: THEN
4232: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'
4233: , 'event_registration_id = ' || p_event_registration_id
4234: ) = FND_API.g_false
4235: )
4236: THEN
4237: AMS_Utility_PVT.error_message('AMS_EVT_REG_DUPLICATE_ID');
4238: x_return_status := FND_API.g_ret_sts_error;
4234: ) = FND_API.g_false
4235: )
4236: THEN
4237: AMS_Utility_PVT.error_message('AMS_EVT_REG_DUPLICATE_ID');
4238: x_return_status := FND_API.g_ret_sts_error;
4239: RETURN;
4240: END IF; -- check_uniqueness
4241: END IF; -- p_event_registration_id
4242:
4246: THEN
4247: /* bug#1490374 commented OUT NOCOPY this piece
4248: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'
4249: , 'confirmation_code = ''' || p_confirmation_code || ''''
4250: ) = FND_API.g_false
4251: )
4252: */
4253: open c_conf_code(p_confirmation_code);
4254: fetch c_conf_code
4256: close c_conf_code;
4257: IF (l_dummy <> 1)
4258: THEN
4259: AMS_Utility_PVT.error_message('AMS_EVT_REG_DUPLICATE_CODE');
4260: x_return_status := FND_API.g_ret_sts_error;
4261: RETURN;
4262: END IF; -- l_dummy
4263: END IF; -- p_confirmation_code
4264:
4275:
4276: BEGIN
4277:
4278: ------------------- EVENT OFFER ID ----------------
4279: IF (p_evt_regs_rec.event_offer_id <> FND_API.g_miss_num)
4280: THEN
4281: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
4282: , 'event_offer_id'
4283: , p_evt_regs_rec.event_offer_id
4280: THEN
4281: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
4282: , 'event_offer_id'
4283: , p_evt_regs_rec.event_offer_id
4284: ) = FND_API.g_false
4285: )
4286: THEN
4287: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_EVENT_OFFER_ID');
4288: x_return_status := FND_API.g_ret_sts_error;
4284: ) = FND_API.g_false
4285: )
4286: THEN
4287: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_EVENT_OFFER_ID');
4288: x_return_status := FND_API.g_ret_sts_error;
4289: RETURN;
4290: END IF; -- check_fk_exists
4291: END IF; -- event_offer_id
4292:
4290: END IF; -- check_fk_exists
4291: END IF; -- event_offer_id
4292:
4293: ------------APPLICATION ID---------------------
4294: IF (p_evt_regs_rec.application_id <> FND_API.g_miss_num)
4295: THEN
4296: IF (AMS_Utility_PVT.check_fk_exists( 'fnd_application'
4297: , 'application_id'
4298: , p_evt_regs_rec.application_id
4295: THEN
4296: IF (AMS_Utility_PVT.check_fk_exists( 'fnd_application'
4297: , 'application_id'
4298: , p_evt_regs_rec.application_id
4299: ) = FND_API.g_false
4300: )
4301: THEN
4302: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_APPLICATION_ID');
4303: x_return_status := FND_API.g_ret_sts_error;
4299: ) = FND_API.g_false
4300: )
4301: THEN
4302: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_APPLICATION_ID');
4303: x_return_status := FND_API.g_ret_sts_error;
4304: RETURN;
4305: END IF; -- check_fk_exists
4306: END IF; -- application_id
4307:
4305: END IF; -- check_fk_exists
4306: END IF; -- application_id
4307:
4308: --------------user status id------------------------
4309: IF (p_evt_regs_rec.user_status_id <> FND_API.g_miss_num)
4310: THEN
4311: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4312: , 'user_status_id'
4313: , p_evt_regs_rec.user_status_id
4310: THEN
4311: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4312: , 'user_status_id'
4313: , p_evt_regs_rec.user_status_id
4314: ) = FND_API.g_false
4315: )
4316: THEN
4317: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_USER_STATUS_ID');
4318: x_return_status := FND_API.g_ret_sts_error;
4314: ) = FND_API.g_false
4315: )
4316: THEN
4317: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_USER_STATUS_ID');
4318: x_return_status := FND_API.g_ret_sts_error;
4319: RETURN;
4320: END IF; -- check_fk_exists
4321: END IF; -- user_status_id
4322:
4320: END IF; -- check_fk_exists
4321: END IF; -- user_status_id
4322:
4323: --------------------------SOURCE CODE-------------------
4324: IF p_evt_regs_rec.source_code <> FND_API.g_miss_char THEN
4325: IF (AMS_Utility_PVT.check_fk_exists( 'ams_source_codes'
4326: , 'source_code'
4327: , p_evt_regs_rec.source_code
4328: , AMS_Utility_PVT.g_varchar2
4325: IF (AMS_Utility_PVT.check_fk_exists( 'ams_source_codes'
4326: , 'source_code'
4327: , p_evt_regs_rec.source_code
4328: , AMS_Utility_PVT.g_varchar2
4329: ) = FND_API.g_false
4330: )
4331: THEN
4332: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_SOURCE_CODE');
4333: x_return_status := FND_API.g_ret_sts_error;
4329: ) = FND_API.g_false
4330: )
4331: THEN
4332: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_SOURCE_CODE');
4333: x_return_status := FND_API.g_ret_sts_error;
4334: RETURN;
4335: END IF; -- check_fk_exists
4336: END IF; -- source_code
4337:
4335: END IF; -- check_fk_exists
4336: END IF; -- source_code
4337:
4338: --------------- attendant language-----------------------
4339: IF (p_evt_regs_rec.attendant_language <> FND_API.g_miss_char)
4340: THEN
4341: IF (AMS_Utility_PVT.check_fk_exists( 'fnd_languages'
4342: , 'language_code'
4343: , p_evt_regs_rec.attendant_language
4341: IF (AMS_Utility_PVT.check_fk_exists( 'fnd_languages'
4342: , 'language_code'
4343: , p_evt_regs_rec.attendant_language
4344: , AMS_Utility_PVT.g_varchar2
4345: ) = FND_API.g_false
4346: )
4347: THEN
4348: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_LANGUAGE');
4349: x_return_status := FND_API.g_ret_sts_error;
4345: ) = FND_API.g_false
4346: )
4347: THEN
4348: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_LANGUAGE');
4349: x_return_status := FND_API.g_ret_sts_error;
4350: RETURN;
4351: END IF; -- check_fk_exists
4352: END IF; -- attendant_language
4353:
4351: END IF; -- check_fk_exists
4352: END IF; -- attendant_language
4353:
4354: ---------------------TARGET LIST ID------------------
4355: IF (p_evt_regs_rec.target_list_id <> FND_API.g_miss_num)
4356: THEN
4357: IF (AMS_Utility_PVT.check_fk_exists( 'ams_list_headers_all'
4358: , 'list_header_id'
4359: , p_evt_regs_rec.target_list_id
4356: THEN
4357: IF (AMS_Utility_PVT.check_fk_exists( 'ams_list_headers_all'
4358: , 'list_header_id'
4359: , p_evt_regs_rec.target_list_id
4360: ) = FND_API.g_false
4361: )
4362: THEN
4363: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_TARGET_LIST_ID');
4364: x_return_status := FND_API.g_ret_sts_error;
4360: ) = FND_API.g_false
4361: )
4362: THEN
4363: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_TARGET_LIST_ID');
4364: x_return_status := FND_API.g_ret_sts_error;
4365: RETURN;
4366: END IF; -- check_fk_exists
4367: END IF; -- target_list_id
4368:
4366: END IF; -- check_fk_exists
4367: END IF; -- target_list_id
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'
4374: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4375: , 'system_status_code'
4376: , p_evt_regs_rec.system_status_code
4377: , AMS_Utility_PVT.g_varchar2
4378: ) = FND_API.g_false
4379: )
4380: THEN
4381: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_SYS_STATUS');
4382: x_return_status := FND_API.g_ret_sts_error;
4378: ) = FND_API.g_false
4379: )
4380: THEN
4381: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_SYS_STATUS');
4382: x_return_status := FND_API.g_ret_sts_error;
4383: RETURN;
4384: END IF; -- check_fk_exists
4385: ELSE
4386: -- will have to validate system status rules against ams_status_order_rules
4407: IS
4408:
4409: BEGIN
4410:
4411: x_return_status := FND_API.g_ret_sts_success;
4412: ----------------------- registration_source_type--------------
4413: IF (p_evt_regs_rec.reg_source_type_code <> FND_API.g_miss_char)
4414: THEN
4415: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_REG_SOURCE'
4409: BEGIN
4410:
4411: x_return_status := FND_API.g_ret_sts_success;
4412: ----------------------- registration_source_type--------------
4413: IF (p_evt_regs_rec.reg_source_type_code <> FND_API.g_miss_char)
4414: THEN
4415: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_REG_SOURCE'
4416: , p_lookup_code => p_evt_regs_rec.reg_source_type_code
4417: ) = FND_API.g_false
4413: IF (p_evt_regs_rec.reg_source_type_code <> FND_API.g_miss_char)
4414: THEN
4415: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_REG_SOURCE'
4416: , p_lookup_code => p_evt_regs_rec.reg_source_type_code
4417: ) = FND_API.g_false
4418: )
4419: THEN
4420: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_SOURCE_TYPE');
4421: x_return_status := FND_API.g_ret_sts_error;
4417: ) = FND_API.g_false
4418: )
4419: THEN
4420: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_SOURCE_TYPE');
4421: x_return_status := FND_API.g_ret_sts_error;
4422: RETURN;
4423: END IF; -- check_lookup_exists
4424: END IF; -- reg_source_type_code
4425:
4423: END IF; -- check_lookup_exists
4424: END IF; -- reg_source_type_code
4425:
4426: -----------------------PAYMENT STATUS_CODE--------------
4427: IF (p_evt_regs_rec.payment_status_code <> FND_API.g_miss_char)
4428: THEN
4429: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_PAYMENT_STATUS'
4430: , p_lookup_code => p_evt_regs_rec.payment_status_code
4431: ) = FND_API.g_false
4427: IF (p_evt_regs_rec.payment_status_code <> FND_API.g_miss_char)
4428: THEN
4429: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_PAYMENT_STATUS'
4430: , p_lookup_code => p_evt_regs_rec.payment_status_code
4431: ) = FND_API.g_false
4432: )
4433: THEN
4434: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_PAY_STAT');
4435: x_return_status := FND_API.g_ret_sts_error;
4431: ) = FND_API.g_false
4432: )
4433: THEN
4434: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_PAY_STAT');
4435: x_return_status := FND_API.g_ret_sts_error;
4436: RETURN;
4437: END IF; -- check_lookup_exists
4438: END IF; -- payment_status_code
4439:
4437: END IF; -- check_lookup_exists
4438: END IF; -- payment_status_code
4439:
4440: ------------------------CANCELLATION REASON CODE-------------------
4441: IF (p_evt_regs_rec.cancellation_reason_code <> FND_API.g_miss_char)
4442: THEN
4443: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_CANCEL_REASON_CODE'
4444: , p_lookup_code => p_evt_regs_rec.cancellation_reason_code
4445: ) = FND_API.g_false
4441: IF (p_evt_regs_rec.cancellation_reason_code <> FND_API.g_miss_char)
4442: THEN
4443: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_CANCEL_REASON_CODE'
4444: , p_lookup_code => p_evt_regs_rec.cancellation_reason_code
4445: ) = FND_API.g_false
4446: )
4447: THEN
4448: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_CANCEL_REASON');
4449: x_return_status := FND_API.g_ret_sts_error;
4445: ) = FND_API.g_false
4446: )
4447: THEN
4448: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_CANCEL_REASON');
4449: x_return_status := FND_API.g_ret_sts_error;
4450: RETURN;
4451: END IF; -- check_lookup_exists
4452: END IF; -- cancellation_reason_code
4453:
4451: END IF; -- check_lookup_exists
4452: END IF; -- cancellation_reason_code
4453:
4454: ------------------------ATTENDANCE FAILURE REASON-------------------
4455: IF (p_evt_regs_rec.attendance_failure_reason <> FND_API.g_miss_char)
4456: THEN
4457: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_ATTENDANCE_FAILURE'
4458: , p_lookup_code => p_evt_regs_rec.attendance_failure_reason
4459: ) = FND_API.g_false
4455: IF (p_evt_regs_rec.attendance_failure_reason <> FND_API.g_miss_char)
4456: THEN
4457: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_ATTENDANCE_FAILURE'
4458: , p_lookup_code => p_evt_regs_rec.attendance_failure_reason
4459: ) = FND_API.g_false
4460: )
4461: THEN
4462: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_ATTEN_FAILURE');
4463: x_return_status := FND_API.g_ret_sts_error;
4459: ) = FND_API.g_false
4460: )
4461: THEN
4462: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_ATTEN_FAILURE');
4463: x_return_status := FND_API.g_ret_sts_error;
4464: RETURN;
4465: END IF; -- check_lookup_exists
4466: END IF; -- attendance_failure_reason
4467:
4499: END IF;
4500: check_evtRegs_req_items( p_evt_Regs_rec => p_evt_Regs_rec
4501: , x_return_status => x_return_status
4502: );
4503: IF (x_return_status <> FND_API.g_ret_sts_success)
4504: THEN
4505: RETURN;
4506: END IF;
4507:
4516: , p_event_registration_id => p_evt_Regs_rec.event_registration_id
4517: , x_return_status => x_return_status
4518: , p_validation_mode => p_validation_mode
4519: );
4520: IF (x_return_status <> FND_API.g_ret_sts_success)
4521: THEN
4522: RETURN;
4523: END IF;
4524:
4532: check_evtRegs_fk_items( p_evt_Regs_rec => p_evt_Regs_rec
4533: , x_return_status => x_return_status
4534: , p_validation_mode => p_validation_mode
4535: );
4536: IF (x_return_status <> FND_API.g_ret_sts_success)
4537: THEN
4538: RETURN;
4539: END IF;
4540:
4547: END IF;
4548: check_evtRegs_lookup_items( p_evt_Regs_rec => p_evt_Regs_rec
4549: , x_return_status => x_return_status
4550: );
4551: IF (x_return_status <> FND_API.g_ret_sts_success)
4552: THEN
4553: RETURN;
4554: END IF;
4555:
4562: END IF;
4563: check_evtRegs_flag_items( p_evt_Regs_rec => p_evt_Regs_rec
4564: , x_return_status => x_return_status
4565: );
4566: IF (x_return_status <> FND_API.g_ret_sts_success)
4567: THEN
4568: RETURN;
4569: END IF;
4570:
4626: temp_attendant_contact_id,
4627: temp_event_offer_id;
4628: IF (chkexists%NOTFOUND)
4629: THEN
4630: x_return_status := FND_API.g_ret_sts_success;
4631: ELSE
4632: IF (AMS_DEBUG_HIGH_ON) THEN
4633:
4634: AMS_Utility_PVT.debug_message('This record already exists');
4633:
4634: AMS_Utility_PVT.debug_message('This record already exists');
4635: END IF;
4636: AMS_Utility_PVT.error_message('AMS_EVENT_REGISTRANT_EXISTS');
4637: x_return_status := FND_API.g_ret_sts_error;
4638: END IF;
4639: CLOSE chkexists;
4640:
4641: END CHECK_EVTREGS_RECORD;
4640:
4641: END CHECK_EVTREGS_RECORD;
4642:
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
4641: END CHECK_EVTREGS_RECORD;
4642:
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
4665:
4666: AMS_Utility_PVT.debug_message(l_full_name||': start');
4667: END IF;
4668:
4669: IF (FND_API.to_boolean(p_init_msg_list))
4670: THEN
4671: FND_MSG_PUB.initialize;
4672: END IF; -- p_init_msg_list
4673:
4670: THEN
4671: FND_MSG_PUB.initialize;
4672: END IF; -- p_init_msg_list
4673:
4674: IF (NOT FND_API.compatible_api_call( l_api_version_number
4675: , p_api_version_number
4676: , l_api_name
4677: , g_pkg_name
4678: )
4677: , g_pkg_name
4678: )
4679: )
4680: THEN
4681: RAISE FND_API.g_exc_unexpected_error;
4682: END IF; -- compatible API call
4683:
4684: x_return_status := FND_API.g_ret_sts_success;
4685:
4680: THEN
4681: RAISE FND_API.g_exc_unexpected_error;
4682: END IF; -- compatible API call
4683:
4684: x_return_status := FND_API.g_ret_sts_success;
4685:
4686: ---------------------- validate ------------------------
4687:
4688: IF (AMS_DEBUG_HIGH_ON) THEN
4698: , p_validation_mode => p_validation_mode
4699: , x_return_status => l_return_status
4700: );
4701:
4702: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4703: THEN
4704: RAISE FND_API.g_exc_unexpected_error;
4705: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4706: THEN
4700: );
4701:
4702: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4703: THEN
4704: RAISE FND_API.g_exc_unexpected_error;
4705: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4706: THEN
4707: RAISE FND_API.g_exc_error;
4708: END IF; -- l_return_status
4701:
4702: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4703: THEN
4704: RAISE FND_API.g_exc_unexpected_error;
4705: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4706: THEN
4707: RAISE FND_API.g_exc_error;
4708: END IF; -- l_return_status
4709: END IF; -- p_validation_level
4703: THEN
4704: RAISE FND_API.g_exc_unexpected_error;
4705: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4706: THEN
4707: RAISE FND_API.g_exc_error;
4708: END IF; -- l_return_status
4709: END IF; -- p_validation_level
4710:
4711: /*
4718: THEN
4719: check_evtRegs_record( P_evt_regs_Rec => l_evt_regs_Rec
4720: , x_return_status => l_return_status
4721: );
4722: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4723: THEN
4724: RAISE FND_API.g_exc_unexpected_error;
4725: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4726: THEN
4720: , x_return_status => l_return_status
4721: );
4722: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4723: THEN
4724: RAISE FND_API.g_exc_unexpected_error;
4725: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4726: THEN
4727: RAISE FND_API.g_exc_error;
4728: END IF; -- l_return_status
4721: );
4722: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4723: THEN
4724: RAISE FND_API.g_exc_unexpected_error;
4725: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4726: THEN
4727: RAISE FND_API.g_exc_error;
4728: END IF; -- l_return_status
4729: END IF; -- p_validation_level
4723: THEN
4724: RAISE FND_API.g_exc_unexpected_error;
4725: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4726: THEN
4727: RAISE FND_API.g_exc_error;
4728: END IF; -- l_return_status
4729: END IF; -- p_validation_level
4730:
4731: -------------------- finish --------------------------
4728: END IF; -- l_return_status
4729: END IF; -- p_validation_level
4730:
4731: -------------------- finish --------------------------
4732: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
4733: , p_count => x_msg_count,
4734: , p_data => x_msg_data
4735: );
4736: */
4740: END IF;
4741:
4742: EXCEPTION
4743:
4744: WHEN FND_API.g_exc_error
4745: THEN
4746: x_return_status := FND_API.g_ret_sts_error;
4747: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4748: , p_count => x_msg_count
4742: EXCEPTION
4743:
4744: WHEN FND_API.g_exc_error
4745: THEN
4746: x_return_status := FND_API.g_ret_sts_error;
4747: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4748: , p_count => x_msg_count
4749: , p_data => x_msg_data
4750: );
4743:
4744: WHEN FND_API.g_exc_error
4745: THEN
4746: x_return_status := FND_API.g_ret_sts_error;
4747: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4748: , p_count => x_msg_count
4749: , p_data => x_msg_data
4750: );
4751:
4748: , p_count => x_msg_count
4749: , p_data => x_msg_data
4750: );
4751:
4752: WHEN FND_API.g_exc_unexpected_error
4753: THEN
4754: x_return_status := FND_API.g_ret_sts_unexp_error;
4755: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4756: , p_count => x_msg_count
4750: );
4751:
4752: WHEN FND_API.g_exc_unexpected_error
4753: THEN
4754: x_return_status := FND_API.g_ret_sts_unexp_error;
4755: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4756: , p_count => x_msg_count
4757: , p_data => x_msg_data
4758: );
4751:
4752: WHEN FND_API.g_exc_unexpected_error
4753: THEN
4754: x_return_status := FND_API.g_ret_sts_unexp_error;
4755: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4756: , p_count => x_msg_count
4757: , p_data => x_msg_data
4758: );
4759:
4758: );
4759:
4760: WHEN OTHERS
4761: THEN
4762: x_return_status := FND_API.g_ret_sts_unexp_error;
4763: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4764: THEN
4765: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4766: END IF; -- check_msg_level
4763: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4764: THEN
4765: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4766: END IF; -- check_msg_level
4767: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4768: , p_count => x_msg_count
4769: , p_data => x_msg_data
4770: );
4771:
4783: IS
4784:
4785: BEGIN
4786:
4787: x_evt_regs_rec.EVENT_REGISTRATION_ID := FND_API.g_miss_num;
4788: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4789: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4790: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4791: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4784:
4785: BEGIN
4786:
4787: x_evt_regs_rec.EVENT_REGISTRATION_ID := FND_API.g_miss_num;
4788: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4789: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4790: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4791: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4792: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4785: BEGIN
4786:
4787: x_evt_regs_rec.EVENT_REGISTRATION_ID := FND_API.g_miss_num;
4788: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4789: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4790: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4791: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4792: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4793: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4786:
4787: x_evt_regs_rec.EVENT_REGISTRATION_ID := FND_API.g_miss_num;
4788: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4789: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4790: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4791: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4792: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4793: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4794: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4787: x_evt_regs_rec.EVENT_REGISTRATION_ID := FND_API.g_miss_num;
4788: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4789: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4790: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4791: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4792: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4793: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4794: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4788: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4789: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4790: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4791: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4792: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4793: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4794: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4796: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4789: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4790: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4791: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4792: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4793: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4794: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4796: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4797: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4790: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4791: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4792: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4793: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4794: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4796: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4797: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4791: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4792: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4793: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4794: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4796: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4797: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4799: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4792: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4793: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4794: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4796: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4797: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4799: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4800: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4793: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4794: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4796: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4797: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4799: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4800: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4801: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4794: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4796: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4797: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4799: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4800: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4801: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4802: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4795: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4796: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4797: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4799: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4800: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4801: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4802: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4803: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4796: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4797: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4799: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4800: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4801: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4802: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4803: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4804: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4797: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4799: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4800: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4801: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4802: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4803: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4804: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4805: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4798: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4799: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4800: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4801: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4802: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4803: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4804: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4805: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4806: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4799: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4800: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4801: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4802: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4803: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4804: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4805: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4806: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4807: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4800: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4801: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4802: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4803: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4804: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4805: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4806: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4807: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4808: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4801: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4802: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4803: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4804: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4805: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4806: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4807: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4808: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4809: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4802: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4803: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4804: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4805: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4806: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4807: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4808: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4809: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4810: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4803: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4804: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4805: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4806: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4807: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4808: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4809: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4810: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4811: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4804: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4805: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4806: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4807: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4808: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4809: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4810: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4811: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4812: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4805: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4806: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4807: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4808: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4809: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4810: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4811: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4812: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4813: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4806: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4807: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4808: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4809: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4810: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4811: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4812: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4813: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4814: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4807: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4808: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4809: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4810: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4811: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4812: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4813: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4814: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4815: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4808: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4809: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4810: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4811: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4812: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4813: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4814: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4815: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4816: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4809: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4810: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4811: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4812: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4813: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4814: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4815: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4816: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4817: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4810: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4811: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4812: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4813: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4814: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4815: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4816: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4817: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4818: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4811: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4812: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4813: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4814: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4815: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4816: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4817: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4818: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4819: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4812: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4813: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4814: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4815: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4816: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4817: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4818: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4819: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4820: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4813: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4814: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4815: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4816: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4817: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4818: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4819: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4820: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4821: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4814: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4815: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4816: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4817: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4818: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4819: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4820: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4821: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4822: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4815: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4816: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4817: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4818: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4819: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4820: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4821: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4822: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4823: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4816: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4817: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4818: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4819: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4820: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4821: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4822: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4823: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4824: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4817: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4818: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4819: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4820: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4821: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4822: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4823: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4824: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4825: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4818: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4819: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4820: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4821: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4822: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4823: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4824: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4825: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4826: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4819: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4820: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4821: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4822: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4823: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4824: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4825: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4826: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4827: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4820: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4821: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4822: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4823: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4824: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4825: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4826: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4827: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4828: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4821: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4822: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4823: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4824: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4825: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4826: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4827: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4828: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4829: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4822: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4823: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4824: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4825: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4826: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4827: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4828: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4829: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4830: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4823: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4824: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4825: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4826: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4827: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4828: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4829: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4830: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4831: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4824: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4825: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4826: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4827: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4828: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4829: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4830: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4831: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4832: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4825: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4826: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4827: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4828: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4829: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4830: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4831: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4832: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4833: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4826: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4827: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4828: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4829: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4830: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4831: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4832: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4833: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4834: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4827: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4828: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4829: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4830: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4831: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4832: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4833: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4834: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4835: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4828: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4829: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4830: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4831: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4832: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4833: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4834: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4835: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4836: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4829: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4830: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4831: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4832: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4833: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4834: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4835: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4836: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4837: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4830: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4831: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4832: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4833: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4834: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4835: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4836: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4837: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4838: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4831: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4832: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4833: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4834: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4835: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4836: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4837: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4838: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4839: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4832: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4833: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4834: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4835: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4836: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4837: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4838: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4839: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4840: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4833: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4834: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4835: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4836: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4837: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4838: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4839: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4840: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4841: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4834: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4835: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4836: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4837: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4838: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4839: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4840: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4841: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4842: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4835: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4836: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4837: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4838: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4839: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4840: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4841: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4842: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4843: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4836: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4837: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4838: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4839: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4840: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4841: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4842: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4843: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4844: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4837: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4838: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4839: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4840: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4841: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4842: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4843: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4844: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4845: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4838: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4839: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4840: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4841: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4842: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4843: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4844: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4845: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4846: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4839: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4840: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4841: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4842: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4843: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4844: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4845: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4846: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4847: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4840: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4841: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4842: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4843: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4844: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4845: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4846: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4847: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4848: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4841: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4842: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4843: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4844: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4845: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4846: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4847: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4848: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4849: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4842: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4843: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4844: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4845: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4846: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4847: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4848: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4849: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4850: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4843: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4844: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4845: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4846: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4847: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4848: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4849: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4850: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4851: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4844: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4845: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4846: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4847: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4848: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4849: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4850: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4851: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4852: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4845: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4846: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4847: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4848: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4849: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4850: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4851: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4852: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4853: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4846: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4847: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4848: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4849: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4850: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4851: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4852: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4853: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4854: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4847: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4848: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4849: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4850: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4851: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4852: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4853: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4854: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4855: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4848: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4849: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4850: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4851: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4852: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4853: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4854: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4855: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4856: x_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE := FND_API.g_miss_char; --Hornet : added for imeeting integration
4849: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4850: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4851: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4852: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4853: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4854: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4855: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4856: x_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE := FND_API.g_miss_char; --Hornet : added for imeeting integration
4857:
4850: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4851: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4852: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4853: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4854: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4855: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4856: x_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE := FND_API.g_miss_char; --Hornet : added for imeeting integration
4857:
4858: END init_evtregs_rec;
4851: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4852: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4853: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4854: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4855: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4856: x_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE := FND_API.g_miss_char; --Hornet : added for imeeting integration
4857:
4858: END init_evtregs_rec;
4859:
4852: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4853: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4854: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4855: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4856: x_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE := FND_API.g_miss_char; --Hornet : added for imeeting integration
4857:
4858: END init_evtregs_rec;
4859:
4860: --------------complete evtregs rec for update-------------------------
4889: IF (c_reg%NOTFOUND)
4890: THEN
4891: CLOSE c_reg;
4892: AMS_UTILITY_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
4893: -- RAISE FND_API.g_exc_error;
4894: END IF; -- c_reg%NOTFOUND
4895: CLOSE c_reg;
4896:
4897: -- This procedure should complete the record by going through all the items in the incoming record.
4894: END IF; -- c_reg%NOTFOUND
4895: CLOSE c_reg;
4896:
4897: -- This procedure should complete the record by going through all the items in the incoming record.
4898: IF (p_evt_regs_rec.EVENT_OFFER_ID = FND_API.g_miss_num)
4899: THEN
4900: x_complete_rec.EVENT_OFFER_ID := l_reg_rec.EVENT_OFFER_ID;
4901: END IF; -- EVENT_OFFER_ID
4902:
4899: THEN
4900: x_complete_rec.EVENT_OFFER_ID := l_reg_rec.EVENT_OFFER_ID;
4901: END IF; -- EVENT_OFFER_ID
4902:
4903: IF (p_evt_regs_rec.APPLICATION_ID = FND_API.g_miss_num)
4904: THEN
4905: x_complete_rec.APPLICATION_ID := l_reg_rec.APPLICATION_ID;
4906: END IF; -- APPLICATION_ID
4907:
4904: THEN
4905: x_complete_rec.APPLICATION_ID := l_reg_rec.APPLICATION_ID;
4906: END IF; -- APPLICATION_ID
4907:
4908: IF (p_evt_regs_rec.ACTIVE_FLAG = FND_API.g_miss_char)
4909: THEN
4910: x_complete_rec.ACTIVE_FLAG := l_reg_rec.ACTIVE_FLAG;
4911: END IF; -- ACTIVE_FLAG
4912:
4909: THEN
4910: x_complete_rec.ACTIVE_FLAG := l_reg_rec.ACTIVE_FLAG;
4911: END IF; -- ACTIVE_FLAG
4912:
4913: IF (p_evt_regs_rec.OWNER_USER_ID = FND_API.g_miss_num)
4914: THEN
4915: x_complete_rec.OWNER_USER_ID := l_reg_rec.OWNER_USER_ID;
4916: END IF; -- OWNER_USER_ID
4917:
4914: THEN
4915: x_complete_rec.OWNER_USER_ID := l_reg_rec.OWNER_USER_ID;
4916: END IF; -- OWNER_USER_ID
4917:
4918: IF (p_evt_regs_rec.SYSTEM_STATUS_CODE = FND_API.g_miss_char)
4919: THEN
4920: x_complete_rec.SYSTEM_STATUS_CODE := l_reg_rec.SYSTEM_STATUS_CODE;
4921: END IF; -- SYSTEM_STATUS_CODE
4922:
4919: THEN
4920: x_complete_rec.SYSTEM_STATUS_CODE := l_reg_rec.SYSTEM_STATUS_CODE;
4921: END IF; -- SYSTEM_STATUS_CODE
4922:
4923: IF (p_evt_regs_rec.DATE_REGISTRATION_PLACED = FND_API.g_miss_date)
4924: THEN
4925: x_complete_rec.DATE_REGISTRATION_PLACED := l_reg_rec.DATE_REGISTRATION_PLACED;
4926: END IF; -- DATE_REGISTRATION_PLACED
4927:
4924: THEN
4925: x_complete_rec.DATE_REGISTRATION_PLACED := l_reg_rec.DATE_REGISTRATION_PLACED;
4926: END IF; -- DATE_REGISTRATION_PLACED
4927:
4928: IF (p_evt_regs_rec.USER_STATUS_ID = FND_API.g_miss_num)
4929: THEN
4930: x_complete_rec.USER_STATUS_ID := l_reg_rec.USER_STATUS_ID;
4931: END IF; -- USER_STATUS_ID
4932:
4929: THEN
4930: x_complete_rec.USER_STATUS_ID := l_reg_rec.USER_STATUS_ID;
4931: END IF; -- USER_STATUS_ID
4932:
4933: IF (p_evt_regs_rec.LAST_REG_STATUS_DATE = FND_API.g_miss_date)
4934: THEN
4935: x_complete_rec.LAST_REG_STATUS_DATE := l_reg_rec.LAST_REG_STATUS_DATE;
4936: END IF; -- LAST_REG_STATUS_DATE
4937:
4934: THEN
4935: x_complete_rec.LAST_REG_STATUS_DATE := l_reg_rec.LAST_REG_STATUS_DATE;
4936: END IF; -- LAST_REG_STATUS_DATE
4937:
4938: IF (p_evt_regs_rec.REG_SOURCE_TYPE_CODE = FND_API.g_miss_char)
4939: THEN
4940: x_complete_rec.REG_SOURCE_TYPE_CODE := l_reg_rec.REG_SOURCE_TYPE_CODE;
4941: END IF; -- REG_SOURCE_TYPE_CODE
4942:
4939: THEN
4940: x_complete_rec.REG_SOURCE_TYPE_CODE := l_reg_rec.REG_SOURCE_TYPE_CODE;
4941: END IF; -- REG_SOURCE_TYPE_CODE
4942:
4943: IF (p_evt_regs_rec.REGISTRATION_SOURCE_ID = FND_API.g_miss_num)
4944: THEN
4945: x_complete_rec.REGISTRATION_SOURCE_ID := l_reg_rec.REGISTRATION_SOURCE_ID;
4946: END IF; -- REGISTRATION_SOURCE_ID
4947:
4944: THEN
4945: x_complete_rec.REGISTRATION_SOURCE_ID := l_reg_rec.REGISTRATION_SOURCE_ID;
4946: END IF; -- REGISTRATION_SOURCE_ID
4947:
4948: IF (p_evt_regs_rec.CONFIRMATION_CODE = FND_API.g_miss_char)
4949: THEN
4950: x_complete_rec.CONFIRMATION_CODE := l_reg_rec.CONFIRMATION_CODE;
4951: END IF; -- CONFIRMATION_CODE
4952:
4949: THEN
4950: x_complete_rec.CONFIRMATION_CODE := l_reg_rec.CONFIRMATION_CODE;
4951: END IF; -- CONFIRMATION_CODE
4952:
4953: IF (p_evt_regs_rec.SOURCE_CODE = FND_API.g_miss_char)
4954: THEN
4955: x_complete_rec.SOURCE_CODE := l_reg_rec.SOURCE_CODE;
4956: END IF; -- SOURCE_CODE
4957:
4954: THEN
4955: x_complete_rec.SOURCE_CODE := l_reg_rec.SOURCE_CODE;
4956: END IF; -- SOURCE_CODE
4957:
4958: IF (p_evt_regs_rec.REGISTRATION_GROUP_ID = FND_API.g_miss_num)
4959: THEN
4960: x_complete_rec.REGISTRATION_GROUP_ID := l_reg_rec.REGISTRATION_GROUP_ID;
4961: END IF; -- REGISTRATION_GROUP_ID
4962:
4959: THEN
4960: x_complete_rec.REGISTRATION_GROUP_ID := l_reg_rec.REGISTRATION_GROUP_ID;
4961: END IF; -- REGISTRATION_GROUP_ID
4962:
4963: IF (p_evt_regs_rec.REGISTRANT_PARTY_ID = FND_API.g_miss_num)
4964: THEN
4965: x_complete_rec.REGISTRANT_PARTY_ID := l_reg_rec.REGISTRANT_PARTY_ID;
4966: END IF; -- REGISTRANT_PARTY_ID
4967:
4964: THEN
4965: x_complete_rec.REGISTRANT_PARTY_ID := l_reg_rec.REGISTRANT_PARTY_ID;
4966: END IF; -- REGISTRANT_PARTY_ID
4967:
4968: IF (p_evt_regs_rec.REGISTRANT_CONTACT_ID = FND_API.g_miss_num)
4969: THEN
4970: x_complete_rec.REGISTRANT_CONTACT_ID := l_reg_rec.REGISTRANT_CONTACT_ID;
4971: END IF; -- REGISTRANT_CONTACT_ID
4972:
4969: THEN
4970: x_complete_rec.REGISTRANT_CONTACT_ID := l_reg_rec.REGISTRANT_CONTACT_ID;
4971: END IF; -- REGISTRANT_CONTACT_ID
4972:
4973: IF (p_evt_regs_rec.REGISTRANT_ACCOUNT_ID = FND_API.g_miss_num)
4974: THEN
4975: x_complete_rec.REGISTRANT_ACCOUNT_ID := l_reg_rec.REGISTRANT_ACCOUNT_ID;
4976: END IF; -- REGISTRANT_ACCOUNT_ID
4977:
4974: THEN
4975: x_complete_rec.REGISTRANT_ACCOUNT_ID := l_reg_rec.REGISTRANT_ACCOUNT_ID;
4976: END IF; -- REGISTRANT_ACCOUNT_ID
4977:
4978: IF (p_evt_regs_rec.ATTENDANT_PARTY_ID = FND_API.g_miss_num)
4979: THEN
4980: x_complete_rec.ATTENDANT_PARTY_ID := l_reg_rec.ATTENDANT_PARTY_ID;
4981: END IF; -- ATTENDANT_PARTY_ID
4982:
4979: THEN
4980: x_complete_rec.ATTENDANT_PARTY_ID := l_reg_rec.ATTENDANT_PARTY_ID;
4981: END IF; -- ATTENDANT_PARTY_ID
4982:
4983: IF (p_evt_regs_rec.ATTENDANT_CONTACT_ID = FND_API.g_miss_num)
4984: THEN
4985: x_complete_rec.ATTENDANT_CONTACT_ID := l_reg_rec.ATTENDANT_CONTACT_ID;
4986: END IF; -- ATTENDANT_CONTACT_ID
4987:
4984: THEN
4985: x_complete_rec.ATTENDANT_CONTACT_ID := l_reg_rec.ATTENDANT_CONTACT_ID;
4986: END IF; -- ATTENDANT_CONTACT_ID
4987:
4988: IF (p_evt_regs_rec.ATTENDANT_ACCOUNT_ID = FND_API.g_miss_num)
4989: THEN
4990: x_complete_rec.ATTENDANT_ACCOUNT_ID := l_reg_rec.ATTENDANT_ACCOUNT_ID;
4991: END IF; -- ATTENDANT_ACCOUNT_ID
4992:
4989: THEN
4990: x_complete_rec.ATTENDANT_ACCOUNT_ID := l_reg_rec.ATTENDANT_ACCOUNT_ID;
4991: END IF; -- ATTENDANT_ACCOUNT_ID
4992:
4993: IF (p_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID = FND_API.g_miss_num)
4994: THEN
4995: x_complete_rec.ORIGINAL_REGISTRANT_CONTACT_ID := l_reg_rec.ORIGINAL_REGISTRANT_CONTACT_ID;
4996: END IF; -- ORIGINAL_REGISTRANT_CONTACT_ID
4997:
4994: THEN
4995: x_complete_rec.ORIGINAL_REGISTRANT_CONTACT_ID := l_reg_rec.ORIGINAL_REGISTRANT_CONTACT_ID;
4996: END IF; -- ORIGINAL_REGISTRANT_CONTACT_ID
4997:
4998: IF (p_evt_regs_rec.PROSPECT_FLAG = FND_API.g_miss_char)
4999: THEN
5000: x_complete_rec.PROSPECT_FLAG := l_reg_rec.PROSPECT_FLAG;
5001: END IF; -- PROSPECT_FLAG
5002:
4999: THEN
5000: x_complete_rec.PROSPECT_FLAG := l_reg_rec.PROSPECT_FLAG;
5001: END IF; -- PROSPECT_FLAG
5002:
5003: IF (p_evt_regs_rec.ATTENDED_FLAG = FND_API.g_miss_char)
5004: THEN
5005: x_complete_rec.ATTENDED_FLAG := l_reg_rec.ATTENDED_FLAG;
5006: END IF; -- ATTENDED_FLAG
5007:
5004: THEN
5005: x_complete_rec.ATTENDED_FLAG := l_reg_rec.ATTENDED_FLAG;
5006: END IF; -- ATTENDED_FLAG
5007:
5008: IF (p_evt_regs_rec.EVALUATED_FLAG = FND_API.g_miss_char)
5009: THEN
5010: x_complete_rec.EVALUATED_FLAG := l_reg_rec.EVALUATED_FLAG;
5011: END IF; -- EVALUATED_FLAG
5012:
5009: THEN
5010: x_complete_rec.EVALUATED_FLAG := l_reg_rec.EVALUATED_FLAG;
5011: END IF; -- EVALUATED_FLAG
5012:
5013: IF (p_evt_regs_rec.CONFIRMED_FLAG = FND_API.g_miss_char)
5014: THEN
5015: x_complete_rec.CONFIRMED_FLAG := l_reg_rec.CONFIRMED_FLAG;
5016: END IF; -- CONFIRMED_FLAG
5017:
5014: THEN
5015: x_complete_rec.CONFIRMED_FLAG := l_reg_rec.CONFIRMED_FLAG;
5016: END IF; -- CONFIRMED_FLAG
5017:
5018: IF (p_evt_regs_rec.ATTENDANCE_RESULT_CODE = FND_API.g_miss_char)
5019: THEN
5020: x_complete_rec.ATTENDANCE_RESULT_CODE := l_reg_rec.ATTENDANCE_RESULT_CODE;
5021: END IF; -- ATTENDANCE_RESULT_CODE
5022:
5019: THEN
5020: x_complete_rec.ATTENDANCE_RESULT_CODE := l_reg_rec.ATTENDANCE_RESULT_CODE;
5021: END IF; -- ATTENDANCE_RESULT_CODE
5022:
5023: IF (p_evt_regs_rec.WAITLISTED_PRIORITY = FND_API.g_miss_num)
5024: THEN
5025: x_complete_rec.WAITLISTED_PRIORITY := l_reg_rec.WAITLISTED_PRIORITY;
5026: END IF; -- WAITLISTED_PRIORITY
5027:
5024: THEN
5025: x_complete_rec.WAITLISTED_PRIORITY := l_reg_rec.WAITLISTED_PRIORITY;
5026: END IF; -- WAITLISTED_PRIORITY
5027:
5028: IF (p_evt_regs_rec.TARGET_LIST_ID = FND_API.g_miss_num)
5029: THEN
5030: x_complete_rec.TARGET_LIST_ID := l_reg_rec.TARGET_LIST_ID;
5031: END IF; -- TARGET_LIST_ID
5032:
5029: THEN
5030: x_complete_rec.TARGET_LIST_ID := l_reg_rec.TARGET_LIST_ID;
5031: END IF; -- TARGET_LIST_ID
5032:
5033: IF (p_evt_regs_rec.INBOUND_MEDIA_ID = FND_API.g_miss_num)
5034: THEN
5035: x_complete_rec.INBOUND_MEDIA_ID := l_reg_rec.INBOUND_MEDIA_ID;
5036: END IF; -- INBOUND_MEDIA_ID
5037:
5034: THEN
5035: x_complete_rec.INBOUND_MEDIA_ID := l_reg_rec.INBOUND_MEDIA_ID;
5036: END IF; -- INBOUND_MEDIA_ID
5037:
5038: IF (p_evt_regs_rec.INBOUND_CHANNEL_ID = FND_API.g_miss_num)
5039: THEN
5040: x_complete_rec.INBOUND_CHANNEL_ID := l_reg_rec.INBOUND_CHANNEL_ID;
5041: END IF; -- INBOUND_CHANNEL_ID
5042:
5039: THEN
5040: x_complete_rec.INBOUND_CHANNEL_ID := l_reg_rec.INBOUND_CHANNEL_ID;
5041: END IF; -- INBOUND_CHANNEL_ID
5042:
5043: IF (p_evt_regs_rec.CANCELLATION_CODE = FND_API.g_miss_char)
5044: THEN
5045: x_complete_rec.CANCELLATION_CODE := l_reg_rec.CANCELLATION_CODE;
5046: END IF; -- CANCELLATION_CODE
5047:
5044: THEN
5045: x_complete_rec.CANCELLATION_CODE := l_reg_rec.CANCELLATION_CODE;
5046: END IF; -- CANCELLATION_CODE
5047:
5048: IF (p_evt_regs_rec.CANCELLATION_REASON_CODE = FND_API.g_miss_char)
5049: THEN
5050: x_complete_rec.CANCELLATION_REASON_CODE := l_reg_rec.CANCELLATION_REASON_CODE;
5051: END IF; -- CANCELLATION_REASON_CODE
5052:
5049: THEN
5050: x_complete_rec.CANCELLATION_REASON_CODE := l_reg_rec.CANCELLATION_REASON_CODE;
5051: END IF; -- CANCELLATION_REASON_CODE
5052:
5053: IF (p_evt_regs_rec.ATTENDANCE_FAILURE_REASON = FND_API.g_miss_char)
5054: THEN
5055: x_complete_rec.ATTENDANCE_FAILURE_REASON := l_reg_rec.ATTENDANCE_FAILURE_REASON;
5056: END IF; -- ATTENDANCE_FAILURE_REASON
5057:
5054: THEN
5055: x_complete_rec.ATTENDANCE_FAILURE_REASON := l_reg_rec.ATTENDANCE_FAILURE_REASON;
5056: END IF; -- ATTENDANCE_FAILURE_REASON
5057:
5058: IF (p_evt_regs_rec.ATTENDANT_LANGUAGE = FND_API.g_miss_char)
5059: THEN
5060: x_complete_rec.ATTENDANT_LANGUAGE := l_reg_rec.ATTENDANT_LANGUAGE;
5061: END IF; -- ATTENDANT_LANGUAGE
5062:
5059: THEN
5060: x_complete_rec.ATTENDANT_LANGUAGE := l_reg_rec.ATTENDANT_LANGUAGE;
5061: END IF; -- ATTENDANT_LANGUAGE
5062:
5063: IF (p_evt_regs_rec.SALESREP_ID = FND_API.g_miss_num)
5064: THEN
5065: x_complete_rec.SALESREP_ID := l_reg_rec.SALESREP_ID;
5066: END IF; -- SALESREP_ID
5067:
5064: THEN
5065: x_complete_rec.SALESREP_ID := l_reg_rec.SALESREP_ID;
5066: END IF; -- SALESREP_ID
5067:
5068: IF (p_evt_regs_rec.ORDER_HEADER_ID = FND_API.g_miss_num)
5069: THEN
5070: x_complete_rec.ORDER_HEADER_ID := l_reg_rec.ORDER_HEADER_ID;
5071: END IF; -- ORDER_HEADER_ID
5072:
5069: THEN
5070: x_complete_rec.ORDER_HEADER_ID := l_reg_rec.ORDER_HEADER_ID;
5071: END IF; -- ORDER_HEADER_ID
5072:
5073: IF (p_evt_regs_rec.ORDER_LINE_ID = FND_API.g_miss_num)
5074: THEN
5075: x_complete_rec.ORDER_LINE_ID := l_reg_rec.ORDER_LINE_ID;
5076: END IF; -- ORDER_LINE_ID
5077:
5074: THEN
5075: x_complete_rec.ORDER_LINE_ID := l_reg_rec.ORDER_LINE_ID;
5076: END IF; -- ORDER_LINE_ID
5077:
5078: IF (p_evt_regs_rec.DESCRIPTION = FND_API.g_miss_char)
5079: THEN
5080: x_complete_rec.DESCRIPTION := l_reg_rec.DESCRIPTION;
5081: END IF; -- DESCRIPTION
5082:
5079: THEN
5080: x_complete_rec.DESCRIPTION := l_reg_rec.DESCRIPTION;
5081: END IF; -- DESCRIPTION
5082:
5083: IF (p_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG = FND_API.g_miss_char)
5084: THEN
5085: x_complete_rec.MAX_ATTENDEE_OVERRIDE_FLAG := l_reg_rec.MAX_ATTENDEE_OVERRIDE_FLAG;
5086: END IF; -- MAX_ATTENDEE_OVERRIDE_FLAG
5087:
5084: THEN
5085: x_complete_rec.MAX_ATTENDEE_OVERRIDE_FLAG := l_reg_rec.MAX_ATTENDEE_OVERRIDE_FLAG;
5086: END IF; -- MAX_ATTENDEE_OVERRIDE_FLAG
5087:
5088: IF (p_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG = FND_API.g_miss_char)
5089: THEN
5090: x_complete_rec.INVITE_ONLY_OVERRIDE_FLAG := l_reg_rec.INVITE_ONLY_OVERRIDE_FLAG;
5091: END IF; -- INVITE_ONLY_OVERRIDE_FLAG
5092:
5089: THEN
5090: x_complete_rec.INVITE_ONLY_OVERRIDE_FLAG := l_reg_rec.INVITE_ONLY_OVERRIDE_FLAG;
5091: END IF; -- INVITE_ONLY_OVERRIDE_FLAG
5092:
5093: IF (p_evt_regs_rec.PAYMENT_STATUS_CODE = FND_API.g_miss_char)
5094: THEN
5095: x_complete_rec.PAYMENT_STATUS_CODE := l_reg_rec.PAYMENT_STATUS_CODE;
5096: END IF; -- PAYMENT_STATUS_CODE
5097:
5094: THEN
5095: x_complete_rec.PAYMENT_STATUS_CODE := l_reg_rec.PAYMENT_STATUS_CODE;
5096: END IF; -- PAYMENT_STATUS_CODE
5097:
5098: IF (p_evt_regs_rec.AUTO_REGISTER_FLAG = FND_API.g_miss_char)
5099: THEN
5100: x_complete_rec.AUTO_REGISTER_FLAG := l_reg_rec.AUTO_REGISTER_FLAG;
5101: END IF; -- AUTO_REGISTER_FLAG
5102:
5099: THEN
5100: x_complete_rec.AUTO_REGISTER_FLAG := l_reg_rec.AUTO_REGISTER_FLAG;
5101: END IF; -- AUTO_REGISTER_FLAG
5102:
5103: IF (p_evt_regs_rec.ATTRIBUTE_CATEGORY = FND_API.g_miss_char)
5104: THEN
5105: x_complete_rec.ATTRIBUTE_CATEGORY := l_reg_rec.ATTRIBUTE_CATEGORY;
5106: END IF; -- ATTRIBUTE_CATEGORY
5107:
5104: THEN
5105: x_complete_rec.ATTRIBUTE_CATEGORY := l_reg_rec.ATTRIBUTE_CATEGORY;
5106: END IF; -- ATTRIBUTE_CATEGORY
5107:
5108: IF (p_evt_regs_rec.ATTRIBUTE1 = FND_API.g_miss_char)
5109: THEN
5110: x_complete_rec.ATTRIBUTE1 := l_reg_rec.ATTRIBUTE1;
5111: END IF; -- ATTRIBUTE1
5112:
5109: THEN
5110: x_complete_rec.ATTRIBUTE1 := l_reg_rec.ATTRIBUTE1;
5111: END IF; -- ATTRIBUTE1
5112:
5113: IF (p_evt_regs_rec.ATTRIBUTE2 = FND_API.g_miss_char)
5114: THEN
5115: x_complete_rec.ATTRIBUTE2 := l_reg_rec.ATTRIBUTE2;
5116: END IF; -- ATTRIBUTE2
5117:
5114: THEN
5115: x_complete_rec.ATTRIBUTE2 := l_reg_rec.ATTRIBUTE2;
5116: END IF; -- ATTRIBUTE2
5117:
5118: IF (p_evt_regs_rec.ATTRIBUTE3 = FND_API.g_miss_char)
5119: THEN
5120: x_complete_rec.ATTRIBUTE3 := l_reg_rec.ATTRIBUTE3;
5121: END IF; -- ATTRIBUTE3
5122:
5119: THEN
5120: x_complete_rec.ATTRIBUTE3 := l_reg_rec.ATTRIBUTE3;
5121: END IF; -- ATTRIBUTE3
5122:
5123: IF (p_evt_regs_rec.ATTRIBUTE4 = FND_API.g_miss_char)
5124: THEN
5125: x_complete_rec.ATTRIBUTE4 := l_reg_rec.ATTRIBUTE4;
5126: END IF; -- ATTRIBUTE4
5127:
5124: THEN
5125: x_complete_rec.ATTRIBUTE4 := l_reg_rec.ATTRIBUTE4;
5126: END IF; -- ATTRIBUTE4
5127:
5128: IF (p_evt_regs_rec.ATTRIBUTE5 = FND_API.g_miss_char)
5129: THEN
5130: x_complete_rec.ATTRIBUTE5 := l_reg_rec.ATTRIBUTE5;
5131: END IF; -- ATTRIBUTE5
5132:
5129: THEN
5130: x_complete_rec.ATTRIBUTE5 := l_reg_rec.ATTRIBUTE5;
5131: END IF; -- ATTRIBUTE5
5132:
5133: IF (p_evt_regs_rec.ATTRIBUTE6 = FND_API.g_miss_char)
5134: THEN
5135: x_complete_rec.ATTRIBUTE6 := l_reg_rec.ATTRIBUTE6;
5136: END IF; -- ATTRIBUTE6
5137:
5134: THEN
5135: x_complete_rec.ATTRIBUTE6 := l_reg_rec.ATTRIBUTE6;
5136: END IF; -- ATTRIBUTE6
5137:
5138: IF (p_evt_regs_rec.ATTRIBUTE7 = FND_API.g_miss_char)
5139: THEN
5140: x_complete_rec.ATTRIBUTE7 := l_reg_rec.ATTRIBUTE7;
5141: END IF; -- ATTRIBUTE7
5142:
5139: THEN
5140: x_complete_rec.ATTRIBUTE7 := l_reg_rec.ATTRIBUTE7;
5141: END IF; -- ATTRIBUTE7
5142:
5143: IF (p_evt_regs_rec.ATTRIBUTE8 = FND_API.g_miss_char)
5144: THEN
5145: x_complete_rec.ATTRIBUTE8 := l_reg_rec.ATTRIBUTE8;
5146: END IF; -- ATTRIBUTE8
5147:
5144: THEN
5145: x_complete_rec.ATTRIBUTE8 := l_reg_rec.ATTRIBUTE8;
5146: END IF; -- ATTRIBUTE8
5147:
5148: IF (p_evt_regs_rec.ATTRIBUTE9 = FND_API.g_miss_char)
5149: THEN
5150: x_complete_rec.ATTRIBUTE9 := l_reg_rec.ATTRIBUTE9;
5151: END IF; -- ATTRIBUTE9
5152:
5149: THEN
5150: x_complete_rec.ATTRIBUTE9 := l_reg_rec.ATTRIBUTE9;
5151: END IF; -- ATTRIBUTE9
5152:
5153: IF (p_evt_regs_rec.ATTRIBUTE10 = FND_API.g_miss_char)
5154: THEN
5155: x_complete_rec.ATTRIBUTE10 := l_reg_rec.ATTRIBUTE10;
5156: END IF; -- ATTRIBUTE10
5157:
5154: THEN
5155: x_complete_rec.ATTRIBUTE10 := l_reg_rec.ATTRIBUTE10;
5156: END IF; -- ATTRIBUTE10
5157:
5158: IF (p_evt_regs_rec.ATTRIBUTE11 = FND_API.g_miss_char)
5159: THEN
5160: x_complete_rec.ATTRIBUTE11 := l_reg_rec.ATTRIBUTE11;
5161: END IF; -- ATTRIBUTE11
5162:
5159: THEN
5160: x_complete_rec.ATTRIBUTE11 := l_reg_rec.ATTRIBUTE11;
5161: END IF; -- ATTRIBUTE11
5162:
5163: IF (p_evt_regs_rec.ATTRIBUTE12 = FND_API.g_miss_char)
5164: THEN
5165: x_complete_rec.ATTRIBUTE12 := l_reg_rec.ATTRIBUTE12;
5166: END IF; -- ATTRIBUTE12
5167:
5164: THEN
5165: x_complete_rec.ATTRIBUTE12 := l_reg_rec.ATTRIBUTE12;
5166: END IF; -- ATTRIBUTE12
5167:
5168: IF (p_evt_regs_rec.ATTRIBUTE13 = FND_API.g_miss_char)
5169: THEN
5170: x_complete_rec.ATTRIBUTE13 := l_reg_rec.ATTRIBUTE13;
5171: END IF; -- ATTRIBUTE13
5172:
5169: THEN
5170: x_complete_rec.ATTRIBUTE13 := l_reg_rec.ATTRIBUTE13;
5171: END IF; -- ATTRIBUTE13
5172:
5173: IF (p_evt_regs_rec.ATTRIBUTE14 = FND_API.g_miss_char)
5174: THEN
5175: x_complete_rec.ATTRIBUTE14 := l_reg_rec.ATTRIBUTE14;
5176: END IF; -- ATTRIBUTE14
5177:
5174: THEN
5175: x_complete_rec.ATTRIBUTE14 := l_reg_rec.ATTRIBUTE14;
5176: END IF; -- ATTRIBUTE14
5177:
5178: IF (p_evt_regs_rec.ATTRIBUTE15 = FND_API.g_miss_char)
5179: THEN
5180: x_complete_rec.ATTRIBUTE15 := l_reg_rec.ATTRIBUTE15;
5181: END IF; -- ATTRIBUTE15
5182:
5180: x_complete_rec.ATTRIBUTE15 := l_reg_rec.ATTRIBUTE15;
5181: END IF; -- ATTRIBUTE15
5182:
5183: -- Hornet: following six fields added for imeeting integration
5184: IF (p_evt_regs_rec.attendee_role_type = FND_API.g_miss_char)
5185: THEN
5186: x_complete_rec.attendee_role_type := l_reg_rec.attendee_role_type;
5187: END IF; -- attendee_role_type
5188:
5185: THEN
5186: x_complete_rec.attendee_role_type := l_reg_rec.attendee_role_type;
5187: END IF; -- attendee_role_type
5188:
5189: IF (p_evt_regs_rec.notification_type = FND_API.g_miss_char)
5190: THEN
5191: x_complete_rec.notification_type := l_reg_rec.notification_type;
5192: END IF; -- notification_type
5193:
5190: THEN
5191: x_complete_rec.notification_type := l_reg_rec.notification_type;
5192: END IF; -- notification_type
5193:
5194: IF (p_evt_regs_rec.last_notified_time = FND_API.g_miss_date)
5195: THEN
5196: x_complete_rec.last_notified_time := l_reg_rec.last_notified_time;
5197: END IF; -- last_notified_time
5198:
5195: THEN
5196: x_complete_rec.last_notified_time := l_reg_rec.last_notified_time;
5197: END IF; -- last_notified_time
5198:
5199: IF (p_evt_regs_rec.EVENT_JOIN_TIME = FND_API.g_miss_date)
5200: THEN
5201: x_complete_rec.EVENT_JOIN_TIME := l_reg_rec.EVENT_JOIN_TIME;
5202: END IF; -- EVENT_JOIN_TIME
5203:
5200: THEN
5201: x_complete_rec.EVENT_JOIN_TIME := l_reg_rec.EVENT_JOIN_TIME;
5202: END IF; -- EVENT_JOIN_TIME
5203:
5204: IF (p_evt_regs_rec.EVENT_EXIT_TIME = FND_API.g_miss_date)
5205: THEN
5206: x_complete_rec.EVENT_EXIT_TIME := l_reg_rec.EVENT_EXIT_TIME;
5207: END IF; -- EVENT_EXIT_TIME
5208:
5205: THEN
5206: x_complete_rec.EVENT_EXIT_TIME := l_reg_rec.EVENT_EXIT_TIME;
5207: END IF; -- EVENT_EXIT_TIME
5208:
5209: IF (p_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE = FND_API.g_miss_char)
5210: THEN
5211: x_complete_rec.MEETING_ENCRYPTION_KEY_CODE := l_reg_rec.MEETING_ENCRYPTION_KEY_CODE;
5212: END IF; -- MEETING_ENCRYPTION_KEY_CODE
5213:
5315: -- create media_rec
5316: JTF_IH_PUB.Create_MediaItem
5317: (
5318: p_api_version => 1.0,
5319: p_init_msg_list => FND_API.g_false,
5320: p_commit => FND_API.g_false,
5321: -- p_resp_appl_id => l_resp_appl_id,
5322: -- p_resp_id => l_resp_id,
5323: p_user_id => l_user_id,
5316: JTF_IH_PUB.Create_MediaItem
5317: (
5318: p_api_version => 1.0,
5319: p_init_msg_list => FND_API.g_false,
5320: p_commit => FND_API.g_false,
5321: -- p_resp_appl_id => l_resp_appl_id,
5322: -- p_resp_id => l_resp_id,
5323: p_user_id => l_user_id,
5324: -- p_login_id => l_login_id,
5327: x_msg_data => l_msg_data,
5328: p_media_rec => l_media_rec,
5329: x_media_id => l_media_id
5330: );
5331: IF l_return_status <> FND_API.g_ret_sts_success THEN
5332: RAISE FND_API.g_exc_error;
5333: RETURN;
5334: END IF;
5335:
5328: p_media_rec => l_media_rec,
5329: x_media_id => l_media_id
5330: );
5331: IF l_return_status <> FND_API.g_ret_sts_success THEN
5332: RAISE FND_API.g_exc_error;
5333: RETURN;
5334: END IF;
5335:
5336: IF (AMS_DEBUG_HIGH_ON) THEN
5392: -- create interaction
5393: JTF_IH_PUB.Create_Interaction
5394: (
5395: p_api_version => 1.0,
5396: p_init_msg_list => FND_API.g_false,
5397: p_commit => FND_API.g_false,
5398: -- p_resp_appl_id => l_resp_appl_id, -- 530
5399: -- p_resp_id => l_resp_id, -- fnd global
5400: p_user_id => l_user_id,
5393: JTF_IH_PUB.Create_Interaction
5394: (
5395: p_api_version => 1.0,
5396: p_init_msg_list => FND_API.g_false,
5397: p_commit => FND_API.g_false,
5398: -- p_resp_appl_id => l_resp_appl_id, -- 530
5399: -- p_resp_id => l_resp_id, -- fnd global
5400: p_user_id => l_user_id,
5401: -- p_login_id => l_login_id,
5404: x_msg_data => l_msg_data,
5405: p_interaction_rec => l_interaction_rec,
5406: p_activities => l_activities
5407: );
5408: IF l_return_status <> FND_API.g_ret_sts_success THEN
5409: RAISE FND_API.g_exc_error;
5410: RETURN;
5411: END IF;
5412:
5405: p_interaction_rec => l_interaction_rec,
5406: p_activities => l_activities
5407: );
5408: IF l_return_status <> FND_API.g_ret_sts_success THEN
5409: RAISE FND_API.g_exc_error;
5410: RETURN;
5411: END IF;
5412:
5413: END write_interaction;