[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
1171:
1172: AMS_Utility_PVT.debug_message(l_full_name||': start');
1173: END IF;
1174:
1175: IF FND_API.to_boolean(p_init_msg_list)
1176: THEN
1177: FND_MSG_PUB.initialize;
1178: END IF; -- p_init_msg_list
1179:
1177: FND_MSG_PUB.initialize;
1178: END IF; -- p_init_msg_list
1179:
1180: -- Standard call to check for call compatibility.
1181: IF (NOT FND_API.Compatible_API_Call( l_api_version_number
1182: , p_api_version_number
1183: , l_api_name
1184: , G_PKG_NAME
1185: )
1184: , G_PKG_NAME
1185: )
1186: )
1187: THEN
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF; -- compatible API call
1190:
1191: -- Initialize API return status to SUCCESS
1192: x_return_status := FND_API.G_RET_STS_SUCCESS;
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF; -- compatible API call
1190:
1191: -- Initialize API return status to SUCCESS
1192: x_return_status := FND_API.G_RET_STS_SUCCESS;
1193:
1194: -- Validate Environment
1195: IF (AMS_DEBUG_HIGH_ON) THEN
1196:
1206: , x_msg_count => x_msg_count
1207: , x_msg_data => x_msg_data
1208: );
1209:
1210: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1211: THEN
1212: RAISE FND_API.G_EXC_ERROR;
1213: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error
1214: THEN
1208: );
1209:
1210: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1211: THEN
1212: RAISE FND_API.G_EXC_ERROR;
1213: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error
1214: THEN
1215: RAISE FND_API.g_exc_unexpected_error;
1216: END IF; -- l_return_status
1209:
1210: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1211: THEN
1212: RAISE FND_API.G_EXC_ERROR;
1213: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error
1214: THEN
1215: RAISE FND_API.g_exc_unexpected_error;
1216: END IF; -- l_return_status
1217:
1211: THEN
1212: RAISE FND_API.G_EXC_ERROR;
1213: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error
1214: THEN
1215: RAISE FND_API.g_exc_unexpected_error;
1216: END IF; -- l_return_status
1217:
1218: -----------------------insert------------------
1219: IF (AMS_DEBUG_HIGH_ON) THEN
1259: IF ( (l_invite_only_override_flag = 'N')
1260: AND (contact_in_invite_list( l_event_offer_id
1261: , l_attendant_contact_id
1262: , l_attendant_party_id
1263: ) = FND_API.g_false
1264: )
1265: )
1266: THEN
1267: IF (AMS_DEBUG_HIGH_ON) THEN
1268:
1269: AMS_UTILITY_PVT.debug_message('The attendant is not on the invite list');
1270: END IF;
1271: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NOT_INVITED');
1272: x_return_status := FND_API.g_ret_sts_error;
1273: RAISE FND_API.G_EXC_ERROR;
1274: ELSE
1275: l_system_status_code := 'REGISTERED';
1276:
1269: AMS_UTILITY_PVT.debug_message('The attendant is not on the invite list');
1270: END IF;
1271: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NOT_INVITED');
1272: x_return_status := FND_API.g_ret_sts_error;
1273: RAISE FND_API.G_EXC_ERROR;
1274: ELSE
1275: l_system_status_code := 'REGISTERED';
1276:
1277: Insert_evtRegs( p_evt_regs_rec => l_evt_regs_rec
1290:
1291: AMS_UTILITY_PVT.DEBUG_MESSAGE ('Registration for this event offering is not required');
1292: END IF;
1293: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NOT_REQ');
1294: x_return_status := FND_API.g_ret_sts_error;
1295: RAISE FND_API.G_EXC_ERROR;
1296: ELSE --reg required flag is Y
1297: IF (l_reg_frozen_flag = 'Y')
1298: THEN
1291: AMS_UTILITY_PVT.DEBUG_MESSAGE ('Registration for this event offering is not required');
1292: END IF;
1293: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NOT_REQ');
1294: x_return_status := FND_API.g_ret_sts_error;
1295: RAISE FND_API.G_EXC_ERROR;
1296: ELSE --reg required flag is Y
1297: IF (l_reg_frozen_flag = 'Y')
1298: THEN
1299: IF (AMS_DEBUG_HIGH_ON) THEN
1300:
1301: AMS_UTILITY_PVT.debug_message('Registrations for this event offering are no longer accepted');
1302: END IF;
1303: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_FROZEN');
1304: x_return_status := FND_API.g_ret_sts_error;
1305: RAISE FND_API.G_EXC_ERROR;
1306: END IF;
1307:
1308: IF ( (l_max_attendee_override_flag = 'Y')
1301: AMS_UTILITY_PVT.debug_message('Registrations for this event offering are no longer accepted');
1302: END IF;
1303: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_FROZEN');
1304: x_return_status := FND_API.g_ret_sts_error;
1305: RAISE FND_API.G_EXC_ERROR;
1306: END IF;
1307:
1308: IF ( (l_max_attendee_override_flag = 'Y')
1309: OR (l_waitlist_flag = 'N')
1330:
1331: AMS_UTILITY_PVT.debug_message('Registrations sold out. Waitlist not allowed for this event offering');
1332: END IF;
1333: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_WAIT_ALLOWED');
1334: x_return_status := FND_API.g_ret_sts_error;
1335: RAISE FND_API.G_EXC_ERROR;
1336: ELSE -- wailist allowed
1337: -- if (l_reg_waitlist_pct is NOT NULL)
1338: -- then
1331: AMS_UTILITY_PVT.debug_message('Registrations sold out. Waitlist not allowed for this event offering');
1332: END IF;
1333: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_WAIT_ALLOWED');
1334: x_return_status := FND_API.g_ret_sts_error;
1335: RAISE FND_API.G_EXC_ERROR;
1336: ELSE -- wailist allowed
1337: -- if (l_reg_waitlist_pct is NOT NULL)
1338: -- then
1339: if ( (nvl(l_waitlist_flag, 'X') <> 'Y')
1339: if ( (nvl(l_waitlist_flag, 'X') <> 'Y')
1340: AND (check_waitlist_availability( l_reg_waitlist_pct
1341: , l_effective_capacity
1342: , l_event_offer_id
1343: ) = FND_API.g_false
1344: )
1345: )
1346: THEN
1347: IF (AMS_DEBUG_HIGH_ON) THEN
1352:
1353: AMS_UTILITY_PVT.debug_message('Waiting list for this event offer ing is full');
1354: END IF;
1355: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_WAIT_AVAILABLE');
1356: x_return_status := FND_API.g_ret_sts_error;
1357: RAISE FND_API.G_EXC_ERROR;
1358: end if; -- check_waitlist_availability
1359: -- end if; -- l_reg_waitlist_pct
1360: l_system_status_code := 'WAITLISTED';
1353: AMS_UTILITY_PVT.debug_message('Waiting list for this event offer ing is full');
1354: END IF;
1355: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_WAIT_AVAILABLE');
1356: x_return_status := FND_API.g_ret_sts_error;
1357: RAISE FND_API.G_EXC_ERROR;
1358: end if; -- check_waitlist_availability
1359: -- end if; -- l_reg_waitlist_pct
1360: l_system_status_code := 'WAITLISTED';
1361: Insert_evtRegs( p_evt_regs_rec => l_evt_regs_rec
1371: END IF; -- Reg required flag is Y else N
1372: END IF; -- invite only flag is Y else N
1373: END IF; -- event offer id not null
1374:
1375: IF FND_API.to_boolean(p_commit)
1376: THEN
1377: COMMIT;
1378: END IF; -- p_commit
1379:
1376: THEN
1377: COMMIT;
1378: END IF; -- p_commit
1379:
1380: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1381: , p_count => x_msg_count
1382: , p_data => x_msg_data
1383: );
1384:
1391: END IF;
1392:
1393: EXCEPTION
1394:
1395: WHEN FND_API.g_exc_error
1396: THEN
1397: ROLLBACK TO CREATE_EvtRegs_PVT;
1398: x_return_status := FND_API.g_ret_sts_error;
1399: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1394:
1395: WHEN FND_API.g_exc_error
1396: THEN
1397: ROLLBACK TO CREATE_EvtRegs_PVT;
1398: x_return_status := FND_API.g_ret_sts_error;
1399: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1400: , p_count => x_msg_count
1401: , p_data => x_msg_data
1402: );
1395: WHEN FND_API.g_exc_error
1396: THEN
1397: ROLLBACK TO CREATE_EvtRegs_PVT;
1398: x_return_status := FND_API.g_ret_sts_error;
1399: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1400: , p_count => x_msg_count
1401: , p_data => x_msg_data
1402: );
1403:
1400: , p_count => x_msg_count
1401: , p_data => x_msg_data
1402: );
1403:
1404: WHEN FND_API.g_exc_unexpected_error
1405: THEN
1406: ROLLBACK TO CREATE_EvtRegs_PVT;
1407: x_return_status := FND_API.g_ret_sts_unexp_error ;
1408: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1403:
1404: WHEN FND_API.g_exc_unexpected_error
1405: THEN
1406: ROLLBACK TO CREATE_EvtRegs_PVT;
1407: x_return_status := FND_API.g_ret_sts_unexp_error ;
1408: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1409: , p_count => x_msg_count
1410: , p_data => x_msg_data
1411: );
1404: WHEN FND_API.g_exc_unexpected_error
1405: THEN
1406: ROLLBACK TO CREATE_EvtRegs_PVT;
1407: x_return_status := FND_API.g_ret_sts_unexp_error ;
1408: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1409: , p_count => x_msg_count
1410: , p_data => x_msg_data
1411: );
1412:
1412:
1413: WHEN OTHERS
1414: THEN
1415: ROLLBACK TO CREATE_EvtRegs_PVT;
1416: x_return_status := FND_API.g_ret_sts_unexp_error ;
1417: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1418: THEN
1419: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1420: END IF;
1417: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1418: THEN
1419: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1420: END IF;
1421: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1422: , p_count => x_msg_count
1423: , p_data => x_msg_data
1424: );
1425:
1425:
1426: End Create_evtregs;
1427:
1428: PROCEDURE UPDATE_evtregs_wrapper( P_Api_Version_Number IN NUMBER
1429: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1430: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1431: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1432: , P_evt_regs_Rec IN evt_regs_Rec_Type
1433: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1426: End Create_evtregs;
1427:
1428: PROCEDURE UPDATE_evtregs_wrapper( P_Api_Version_Number IN NUMBER
1429: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1430: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1431: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1432: , P_evt_regs_Rec IN evt_regs_Rec_Type
1433: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1434: , p_cancellation_reason_code IN VARCHAR2 := NULL
1427:
1428: PROCEDURE UPDATE_evtregs_wrapper( P_Api_Version_Number IN NUMBER
1429: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1430: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1431: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1432: , P_evt_regs_Rec IN evt_regs_Rec_Type
1433: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1434: , p_cancellation_reason_code IN VARCHAR2 := NULL
1435: , x_cancellation_code OUT NOCOPY VARCHAR2
1429: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1430: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1431: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1432: , P_evt_regs_Rec IN evt_regs_Rec_Type
1433: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1434: , p_cancellation_reason_code IN VARCHAR2 := NULL
1435: , x_cancellation_code OUT NOCOPY VARCHAR2
1436: , X_Return_Status OUT NOCOPY VARCHAR2
1437: , X_Msg_Count OUT NOCOPY NUMBER
1468: -- Standard Start of API savepoint
1469: SAVEPOINT UPDATE_evtregs_wrapper;
1470:
1471: -- Standard call to check for call compatibility.
1472: IF (NOT FND_API.Compatible_API_Call( l_api_version_number
1473: , p_api_version_number
1474: , l_api_name
1475: , G_PKG_NAME
1476: )
1475: , G_PKG_NAME
1476: )
1477: )
1478: THEN
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: END IF; -- compatible API call
1481:
1482:
1483: -- Initialize message list if p_init_msg_list is set to TRUE.
1480: END IF; -- compatible API call
1481:
1482:
1483: -- Initialize message list if p_init_msg_list is set to TRUE.
1484: IF (FND_API.to_Boolean(p_init_msg_list))
1485: THEN
1486: FND_MSG_PUB.initialize;
1487: END IF; -- p_init_msg_list
1488:
1486: FND_MSG_PUB.initialize;
1487: END IF; -- p_init_msg_list
1488:
1489: -- Initialize API return status to SUCCESS
1490: x_return_status := FND_API.G_RET_STS_SUCCESS;
1491:
1492: OPEN c_reg;
1493: FETCH c_reg
1494: INTO l_evt_regs_rec;
1494: INTO l_evt_regs_rec;
1495: IF c_reg%NOTFOUND THEN
1496: CLOSE c_reg;
1497: AMS_UTILITY_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
1498: RAISE FND_API.g_exc_error;
1499: END IF; -- c_reg%NOTFOUND
1500: CLOSE c_reg;
1501:
1502: open c_cancel_status_id;
1505: close c_cancel_status_id;
1506:
1507: -- soagrawa added on 29-jan-2003
1508: /* IF ((l_evt_regs_rec.user_status_id = p_evt_regs_rec.user_status_id
1509: OR p_evt_regs_rec.user_status_id = FND_API.g_miss_num)
1510: AND (l_evt_regs_rec.attended_flag = p_evt_regs_rec.attended_flag
1511: OR p_evt_regs_rec.attended_flag = FND_API.g_miss_char)
1512: AND (l_evt_regs_rec.reg_source_type_code = p_evt_regs_rec.reg_source_type_code
1513: OR p_evt_regs_rec.reg_source_type_code = FND_API.g_miss_char)
1507: -- soagrawa added on 29-jan-2003
1508: /* IF ((l_evt_regs_rec.user_status_id = p_evt_regs_rec.user_status_id
1509: OR p_evt_regs_rec.user_status_id = FND_API.g_miss_num)
1510: AND (l_evt_regs_rec.attended_flag = p_evt_regs_rec.attended_flag
1511: OR p_evt_regs_rec.attended_flag = FND_API.g_miss_char)
1512: AND (l_evt_regs_rec.reg_source_type_code = p_evt_regs_rec.reg_source_type_code
1513: OR p_evt_regs_rec.reg_source_type_code = FND_API.g_miss_char)
1514: )
1515: THEN
1509: OR p_evt_regs_rec.user_status_id = FND_API.g_miss_num)
1510: AND (l_evt_regs_rec.attended_flag = p_evt_regs_rec.attended_flag
1511: OR p_evt_regs_rec.attended_flag = FND_API.g_miss_char)
1512: AND (l_evt_regs_rec.reg_source_type_code = p_evt_regs_rec.reg_source_type_code
1513: OR p_evt_regs_rec.reg_source_type_code = FND_API.g_miss_char)
1514: )
1515: THEN
1516: AMS_UTILITY_PVT.debug_message('Nothing changed');
1517: RETURN;
1530: THEN
1531: -- trying to update both attended flag to Y and status to cancel
1532: -- A registrant who has already attended cannot have his registration cancelled.
1533: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_ATTENDED_1');
1534: RAISE FND_API.g_exc_error;
1535:
1536: ELSIF l_evt_regs_rec.user_status_id <> p_evt_regs_rec.user_status_id
1537: THEN
1538: -- trying to update status to cancel when attended flag is already Y
1537: THEN
1538: -- trying to update status to cancel when attended flag is already Y
1539: -- A registrant who has already attended cannot have his registration cancelled.
1540: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_ATTENDED_1');
1541: RAISE FND_API.g_exc_error;
1542:
1543: ELSIF p_evt_regs_Rec.attended_flag <> l_evt_regs_Rec.attended_flag
1544: THEN
1545: -- trying to update attended flag to Y when status is already cancelled
1544: THEN
1545: -- trying to update attended flag to Y when status is already cancelled
1546: -- Cannot update the Attended flag for the Registrant whose Registration Status is Cancelled.
1547: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_ATTENDED');
1548: RAISE FND_API.g_exc_error;
1549: END IF;
1550: END IF;
1551:
1552:
1584: END IF; -- l_cancel_id
1585:
1586: EXCEPTION
1587:
1588: WHEN FND_API.g_exc_error
1589: THEN
1590: ROLLBACK TO UPDATE_evtregs_wrapper;
1591: x_return_status := FND_API.g_ret_sts_error;
1592: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1587:
1588: WHEN FND_API.g_exc_error
1589: THEN
1590: ROLLBACK TO UPDATE_evtregs_wrapper;
1591: x_return_status := FND_API.g_ret_sts_error;
1592: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1593: , p_count => x_msg_count
1594: , p_data => x_msg_data
1595: );
1588: WHEN FND_API.g_exc_error
1589: THEN
1590: ROLLBACK TO UPDATE_evtregs_wrapper;
1591: x_return_status := FND_API.g_ret_sts_error;
1592: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1593: , p_count => x_msg_count
1594: , p_data => x_msg_data
1595: );
1596:
1593: , p_count => x_msg_count
1594: , p_data => x_msg_data
1595: );
1596:
1597: WHEN FND_API.g_exc_unexpected_error
1598: THEN
1599: ROLLBACK TO UPDATE_evtregs_wrapper;
1600: x_return_status := FND_API.g_ret_sts_unexp_error ;
1601: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1596:
1597: WHEN FND_API.g_exc_unexpected_error
1598: THEN
1599: ROLLBACK TO UPDATE_evtregs_wrapper;
1600: x_return_status := FND_API.g_ret_sts_unexp_error ;
1601: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1602: , p_count => x_msg_count
1603: , p_data => x_msg_data
1604: );
1597: WHEN FND_API.g_exc_unexpected_error
1598: THEN
1599: ROLLBACK TO UPDATE_evtregs_wrapper;
1600: x_return_status := FND_API.g_ret_sts_unexp_error ;
1601: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1602: , p_count => x_msg_count
1603: , p_data => x_msg_data
1604: );
1605:
1605:
1606: WHEN OTHERS
1607: THEN
1608: ROLLBACK TO UPDATE_evtregs_wrapper;
1609: x_return_status := FND_API.g_ret_sts_unexp_error ;
1610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1611: THEN
1612: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1613: END IF;
1610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1611: THEN
1612: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1613: END IF;
1614: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1615: , p_count => x_msg_count
1616: , p_data => x_msg_data
1617: );
1618: END Update_evtregs_wrapper;
1617: );
1618: END Update_evtregs_wrapper;
1619:
1620: PROCEDURE Update_evtregs( P_Api_Version_Number IN NUMBER
1621: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1622: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1623: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1624: , P_evt_regs_Rec IN evt_regs_Rec_Type
1625: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1618: END Update_evtregs_wrapper;
1619:
1620: PROCEDURE Update_evtregs( P_Api_Version_Number IN NUMBER
1621: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1622: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1623: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1624: , P_evt_regs_Rec IN evt_regs_Rec_Type
1625: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1626: , X_Return_Status OUT NOCOPY VARCHAR2
1619:
1620: PROCEDURE Update_evtregs( P_Api_Version_Number IN NUMBER
1621: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1622: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1623: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1624: , P_evt_regs_Rec IN evt_regs_Rec_Type
1625: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1626: , X_Return_Status OUT NOCOPY VARCHAR2
1627: , X_Msg_Count OUT NOCOPY NUMBER
1621: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1622: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1623: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1624: , P_evt_regs_Rec IN evt_regs_Rec_Type
1625: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
1626: , X_Return_Status OUT NOCOPY VARCHAR2
1627: , X_Msg_Count OUT NOCOPY NUMBER
1628: , X_Msg_Data OUT NOCOPY VARCHAR2
1629: )
1704: -- Standard Start of API savepoint
1705: SAVEPOINT UPDATE_EvtRegs_PVT;
1706:
1707: -- Standard call to check for call compatibility.
1708: IF (NOT FND_API.Compatible_API_Call( l_api_version_number
1709: , p_api_version_number
1710: , l_api_name
1711: , G_PKG_NAME
1712: )
1711: , G_PKG_NAME
1712: )
1713: )
1714: THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1716: END IF; -- compatible API call
1717:
1718:
1719: -- Initialize message list if p_init_msg_list is set to TRUE.
1716: END IF; -- compatible API call
1717:
1718:
1719: -- Initialize message list if p_init_msg_list is set to TRUE.
1720: IF (FND_API.to_Boolean(p_init_msg_list))
1721: THEN
1722: FND_MSG_PUB.initialize;
1723: END IF; -- p_init_msg_list
1724:
1722: FND_MSG_PUB.initialize;
1723: END IF; -- p_init_msg_list
1724:
1725: -- Initialize API return status to SUCCESS
1726: x_return_status := FND_API.G_RET_STS_SUCCESS;
1727:
1728: -- add complete_evtreg_rec to complete rec with existing values instead of empty FND_API.g_miss_char
1729: -- replace g_miss_char/num/date with current column values
1730: IF (AMS_DEBUG_HIGH_ON) THEN
1724:
1725: -- Initialize API return status to SUCCESS
1726: x_return_status := FND_API.G_RET_STS_SUCCESS;
1727:
1728: -- add complete_evtreg_rec to complete rec with existing values instead of empty FND_API.g_miss_char
1729: -- replace g_miss_char/num/date with current column values
1730: IF (AMS_DEBUG_HIGH_ON) THEN
1731:
1732: AMS_Utility_PVT.debug_message(l_full_name ||': complete');
1741: END IF;
1742:
1743: -- Invoke validation procedures
1744: Validate_evtregs( p_api_version_number => l_api_version_number
1745: , p_init_msg_list => FND_API.G_FALSE
1746: , p_validation_level => p_validation_level
1747: , P_evt_regs_Rec => l_evt_regs_Rec
1748: , p_validation_mode => JTF_PLSQL_API.g_update
1749: , x_return_status => l_return_status
1750: , x_msg_count => x_msg_count
1751: , x_msg_data => x_msg_data
1752: );
1753:
1754: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
1755: THEN
1756: RAISE FND_API.g_exc_unexpected_error;
1757: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1758: THEN
1752: );
1753:
1754: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
1755: THEN
1756: RAISE FND_API.g_exc_unexpected_error;
1757: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1758: THEN
1759: RAISE FND_API.g_exc_error;
1760: END IF; -- l_return_status
1753:
1754: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
1755: THEN
1756: RAISE FND_API.g_exc_unexpected_error;
1757: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1758: THEN
1759: RAISE FND_API.g_exc_error;
1760: END IF; -- l_return_status
1761:
1755: THEN
1756: RAISE FND_API.g_exc_unexpected_error;
1757: ELSIF (l_return_status = FND_API.g_ret_sts_error)
1758: THEN
1759: RAISE FND_API.g_exc_error;
1760: END IF; -- l_return_status
1761:
1762: OPEN c_old_reg_status(l_evt_regs_Rec.event_registration_id);
1763: FETCH c_old_reg_status
1773:
1774: IF (nvl(l_event_status, 'X') in ('ARCHIVED', 'CLOSED'))
1775: THEN
1776: AMS_Utility_PVT.Error_Message('AMS_EVENT_REG_UPDATE_ERROR', 'STATUS', l_event_status_name);
1777: RAISE FND_API.g_exc_error;
1778: END IF;
1779:
1780: -- make sure the status code matches the user status id
1781: OPEN c_get_status_code(l_evt_regs_Rec.user_status_id);
1792: )
1793: )
1794: THEN
1795: AMS_UTILITY_PVT.error_message('AMS_EVT_REG_NO_WAIT_AVAILABLE');
1796: RAISE FND_API.g_exc_error;
1797: END IF;
1798:
1799: IF ( (l_old_reg_status = 'WAITLISTED')
1800: AND (l_evt_regs_Rec.system_status_code = 'REGISTERED')
1878: and object_version_number = l_evt_regs_Rec.object_version_number;
1879:
1880: IF (SQL%NOTFOUND) THEN
1881: AMS_UTILITY_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
1882: RAISE FND_API.g_exc_error;
1883: END IF; -- SQL%NOTFOUND
1884:
1885: IF ( (l_old_reg_status = 'WAITLISTED')
1886: AND (l_evt_regs_Rec.system_status_code = 'REGISTERED')
1931: l_bind_values(1) := TO_CHAR(l_evt_regs_Rec.event_registration_id);
1932:
1933:
1934: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
1935: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
1936: )
1937: THEN
1938: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
1939: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
1935: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
1936: )
1937: THEN
1938: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
1939: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
1940: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
1941: , p_object_type => l_object_type -- IN VARCHAR2
1942: , p_object_id => l_object_id -- l_evt_regs_rec.event_offer_id -- IN NUMBER
1943: , p_trigger_type => 'REG_CONFIRM' -- IN VARCHAR2
1936: )
1937: THEN
1938: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
1939: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
1940: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
1941: , p_object_type => l_object_type -- IN VARCHAR2
1942: , p_object_id => l_object_id -- l_evt_regs_rec.event_offer_id -- IN NUMBER
1943: , p_trigger_type => 'REG_CONFIRM' -- IN VARCHAR2
1944: -- , p_requestor_type => -- IN VARCHAR2 := NULL
1969: IF (AMS_DEBUG_HIGH_ON) THEN
1970: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
1971: END IF;
1972:
1973: IF l_return_status = FND_API.g_ret_sts_error THEN
1974: RAISE FND_API.g_exc_error;
1975: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1976: RAISE FND_API.g_exc_unexpected_error;
1977: END IF;
1970: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
1971: END IF;
1972:
1973: IF l_return_status = FND_API.g_ret_sts_error THEN
1974: RAISE FND_API.g_exc_error;
1975: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1976: RAISE FND_API.g_exc_unexpected_error;
1977: END IF;
1978:
1971: END IF;
1972:
1973: IF l_return_status = FND_API.g_ret_sts_error THEN
1974: RAISE FND_API.g_exc_error;
1975: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1976: RAISE FND_API.g_exc_unexpected_error;
1977: END IF;
1978:
1979: END IF;
1972:
1973: IF l_return_status = FND_API.g_ret_sts_error THEN
1974: RAISE FND_API.g_exc_error;
1975: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1976: RAISE FND_API.g_exc_unexpected_error;
1977: END IF;
1978:
1979: END IF;
1980: END IF; -- ATTENDANCE FLAG
1981: END IF;
1982:
1983:
1984: -- Standard check for p_commit
1985: IF FND_API.to_Boolean( p_commit )
1986: THEN
1987: COMMIT WORK;
1988: END IF; -- p_commit
1989:
1986: THEN
1987: COMMIT WORK;
1988: END IF; -- p_commit
1989:
1990: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1991: , p_count => x_msg_count
1992: , p_data => x_msg_data
1993: );
1994:
2002:
2003:
2004: EXCEPTION
2005:
2006: WHEN FND_API.g_exc_error
2007: THEN
2008: ROLLBACK TO UPDATE_EvtRegs_PVT;
2009: x_return_status := FND_API.g_ret_sts_error;
2010: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2005:
2006: WHEN FND_API.g_exc_error
2007: THEN
2008: ROLLBACK TO UPDATE_EvtRegs_PVT;
2009: x_return_status := FND_API.g_ret_sts_error;
2010: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2011: , p_count => x_msg_count
2012: , p_data => x_msg_data
2013: );
2006: WHEN FND_API.g_exc_error
2007: THEN
2008: ROLLBACK TO UPDATE_EvtRegs_PVT;
2009: x_return_status := FND_API.g_ret_sts_error;
2010: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2011: , p_count => x_msg_count
2012: , p_data => x_msg_data
2013: );
2014:
2011: , p_count => x_msg_count
2012: , p_data => x_msg_data
2013: );
2014:
2015: WHEN FND_API.g_exc_unexpected_error
2016: THEN
2017: ROLLBACK TO UPDATE_EvtRegs_PVT;
2018: x_return_status := FND_API.g_ret_sts_unexp_error ;
2019: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2014:
2015: WHEN FND_API.g_exc_unexpected_error
2016: THEN
2017: ROLLBACK TO UPDATE_EvtRegs_PVT;
2018: x_return_status := FND_API.g_ret_sts_unexp_error ;
2019: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2020: , p_count => x_msg_count
2021: , p_data => x_msg_data
2022: );
2015: WHEN FND_API.g_exc_unexpected_error
2016: THEN
2017: ROLLBACK TO UPDATE_EvtRegs_PVT;
2018: x_return_status := FND_API.g_ret_sts_unexp_error ;
2019: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2020: , p_count => x_msg_count
2021: , p_data => x_msg_data
2022: );
2023:
2023:
2024: WHEN OTHERS
2025: THEN
2026: ROLLBACK TO UPDATE_EvtRegs_PVT;
2027: x_return_status := FND_API.g_ret_sts_unexp_error ;
2028: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2029: THEN
2030: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2031: END IF; -- check_msg_level
2028: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2029: THEN
2030: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2031: END IF; -- check_msg_level
2032: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2033: , p_count => x_msg_count
2034: , p_data => x_msg_data
2035: );
2036:
2039: -- modified sugupta 06/21/2000
2040: -- return cancellation code as Varchar2
2041:
2042: PROCEDURE Cancel_evtregs( P_Api_Version_Number IN NUMBER
2043: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2044: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
2045: , p_object_version IN NUMBER
2046: , p_event_offer_id IN NUMBER
2047: , p_registrant_party_id IN NUMBER
2040: -- return cancellation code as Varchar2
2041:
2042: PROCEDURE Cancel_evtregs( P_Api_Version_Number IN NUMBER
2043: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2044: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
2045: , p_object_version IN NUMBER
2046: , p_event_offer_id IN NUMBER
2047: , p_registrant_party_id IN NUMBER
2048: , p_confirmation_code IN VARCHAR2
2047: , p_registrant_party_id IN NUMBER
2048: , p_confirmation_code IN VARCHAR2
2049: , p_registration_group_id IN NUMBER
2050: , p_cancellation_reason_code IN VARCHAR2
2051: , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
2052: , x_cancellation_code OUT NOCOPY VARCHAR2
2053: , X_Return_Status OUT NOCOPY VARCHAR2
2054: , X_Msg_Count OUT NOCOPY NUMBER
2055: , X_Msg_Data OUT NOCOPY VARCHAR2
2181: AMS_Utility_PVT.debug_message(l_full_name || ': start');
2182: END IF;
2183:
2184: -- Standard call to check for call compatibility.
2185: IF (NOT FND_API.Compatible_API_Call( l_api_version_number
2186: , p_api_version_number
2187: , l_api_name
2188: , G_PKG_NAME
2189: )
2188: , G_PKG_NAME
2189: )
2190: )
2191: THEN
2192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2193: END IF; -- compatible API call
2194:
2195: -- Initialize message list if p_init_msg_list is set to TRUE.
2196: IF (FND_API.to_Boolean(p_init_msg_list))
2192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2193: END IF; -- compatible API call
2194:
2195: -- Initialize message list if p_init_msg_list is set to TRUE.
2196: IF (FND_API.to_Boolean(p_init_msg_list))
2197: THEN
2198: FND_MSG_PUB.initialize;
2199: END IF; -- p_init_msg_list
2200:
2198: FND_MSG_PUB.initialize;
2199: END IF; -- p_init_msg_list
2200:
2201: -- Initialize API return status to SUCCESS
2202: x_return_status := FND_API.G_RET_STS_SUCCESS;
2203:
2204: IF (AMS_DEBUG_HIGH_ON) THEN
2205: AMS_Utility_PVT.debug_message(l_full_name || ': cancel');
2206: END IF;
2241:
2242: AMS_UTILITY_PVT.debug_message(' Corresponding event offering information is not provided');
2243: END IF;
2244: AMS_Utility_PVT.error_message('AMS_EVT_REG_CANC_NO_EVOID');
2245: x_return_status := FND_API.g_ret_sts_error;
2246: RAISE FND_API.G_EXC_ERROR;
2247: ELSE
2248: IF l_registration_group_id is NULL
2249: THEN
2242: AMS_UTILITY_PVT.debug_message(' Corresponding event offering information is not provided');
2243: END IF;
2244: AMS_Utility_PVT.error_message('AMS_EVT_REG_CANC_NO_EVOID');
2245: x_return_status := FND_API.g_ret_sts_error;
2246: RAISE FND_API.G_EXC_ERROR;
2247: ELSE
2248: IF l_registration_group_id is NULL
2249: THEN
2250: IF l_confirmation_code is NULL
2253:
2254: AMS_UTILITY_PVT.debug_message(' Corresponding confirmation code for the event offering is not provided');
2255: END IF;
2256: AMS_Utility_PVT.error_message('AMS_EVT_REG_CANC_NO_CODE');
2257: x_return_status := FND_API.g_ret_sts_error;
2258: RAISE FND_API.G_EXC_ERROR;
2259: ELSE
2260: IF (AMS_DEBUG_HIGH_ON) THEN
2261:
2254: AMS_UTILITY_PVT.debug_message(' Corresponding confirmation code for the event offering is not provided');
2255: END IF;
2256: AMS_Utility_PVT.error_message('AMS_EVT_REG_CANC_NO_CODE');
2257: x_return_status := FND_API.g_ret_sts_error;
2258: RAISE FND_API.G_EXC_ERROR;
2259: ELSE
2260: IF (AMS_DEBUG_HIGH_ON) THEN
2261:
2262: AMS_Utility_PVT.debug_message(l_full_name ||': before off det cursor');
2284: END IF;
2285: IF (nvl(l_event_status, 'X') in ('ARCHIVED', 'CLOSED'))
2286: THEN
2287: AMS_Utility_PVT.Error_Message('AMS_EVENT_REG_UPDATE_ERROR', 'STATUS', l_event_status_name);
2288: RAISE FND_API.g_exc_error;
2289: END IF;
2290:
2291: IF (l_reg_charge_flag = 'N')
2292: THEN
2325: l_bind_names(1) := 'REGISTRATION_ID' ;
2326: l_bind_values(1):= TO_CHAR(l_event_registration_id) ;
2327:
2328: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2329: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2330: )
2331: THEN
2332:
2333: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2330: )
2331: THEN
2332:
2333: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2334: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2335: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2336: , p_object_type => l_object_type -- IN VARCHAR2
2337: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2338: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2331: THEN
2332:
2333: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2334: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2335: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2336: , p_object_type => l_object_type -- IN VARCHAR2
2337: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2338: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2339: -- , p_requestor_type => -- IN VARCHAR2 := NULL
2363: IF (AMS_DEBUG_HIGH_ON) THEN
2364: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2365: END IF;
2366:
2367: IF l_return_status = FND_API.g_ret_sts_error THEN
2368: RAISE FND_API.g_exc_error;
2369: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2370: RAISE FND_API.g_exc_unexpected_error;
2371: END IF;
2364: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2365: END IF;
2366:
2367: IF l_return_status = FND_API.g_ret_sts_error THEN
2368: RAISE FND_API.g_exc_error;
2369: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2370: RAISE FND_API.g_exc_unexpected_error;
2371: END IF;
2372:
2365: END IF;
2366:
2367: IF l_return_status = FND_API.g_ret_sts_error THEN
2368: RAISE FND_API.g_exc_error;
2369: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2370: RAISE FND_API.g_exc_unexpected_error;
2371: END IF;
2372:
2373: END IF;
2366:
2367: IF l_return_status = FND_API.g_ret_sts_error THEN
2368: RAISE FND_API.g_exc_error;
2369: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2370: RAISE FND_API.g_exc_unexpected_error;
2371: END IF;
2372:
2373: END IF;
2374: END IF; -- attended flag and sysdate
2381: , X_Return_Status => l_return_status
2382: , X_Msg_Count => x_msg_count
2383: , X_Msg_Data => x_msg_data
2384: );
2385: IF l_return_status = FND_API.g_ret_sts_unexp_error
2386: THEN
2387: RAISE FND_API.g_exc_unexpected_error;
2388: ELSIF l_return_status = FND_API.g_ret_sts_error
2389: THEN
2383: , X_Msg_Data => x_msg_data
2384: );
2385: IF l_return_status = FND_API.g_ret_sts_unexp_error
2386: THEN
2387: RAISE FND_API.g_exc_unexpected_error;
2388: ELSIF l_return_status = FND_API.g_ret_sts_error
2389: THEN
2390: RAISE FND_API.g_exc_error;
2391: END IF; -- l_return_status
2384: );
2385: IF l_return_status = FND_API.g_ret_sts_unexp_error
2386: THEN
2387: RAISE FND_API.g_exc_unexpected_error;
2388: ELSIF l_return_status = FND_API.g_ret_sts_error
2389: THEN
2390: RAISE FND_API.g_exc_error;
2391: END IF; -- l_return_status
2392:
2386: THEN
2387: RAISE FND_API.g_exc_unexpected_error;
2388: ELSIF l_return_status = FND_API.g_ret_sts_error
2389: THEN
2390: RAISE FND_API.g_exc_error;
2391: END IF; -- l_return_status
2392:
2393: ELSE
2394: IF (nvl(l_event_end_date, sysdate+1) < sysdate)
2432: l_bind_names(1) := 'REGISTRATION_ID' ;
2433: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2434:
2435: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2436: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2437: )
2438: THEN
2439: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2440: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2436: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2437: )
2438: THEN
2439: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2440: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2441: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2442: , p_object_type => l_object_type -- IN VARCHAR2
2443: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2444: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2437: )
2438: THEN
2439: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2440: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2441: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2442: , p_object_type => l_object_type -- IN VARCHAR2
2443: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2444: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2445: -- , p_requestor_type => -- IN VARCHAR2 := NULL
2471: IF (AMS_DEBUG_HIGH_ON) THEN
2472: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2473: END IF;
2474:
2475: IF l_return_status = FND_API.g_ret_sts_error THEN
2476: RAISE FND_API.g_exc_error;
2477: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2478: RAISE FND_API.g_exc_unexpected_error;
2479: END IF;
2472: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2473: END IF;
2474:
2475: IF l_return_status = FND_API.g_ret_sts_error THEN
2476: RAISE FND_API.g_exc_error;
2477: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2478: RAISE FND_API.g_exc_unexpected_error;
2479: END IF;
2480: END IF;
2473: END IF;
2474:
2475: IF l_return_status = FND_API.g_ret_sts_error THEN
2476: RAISE FND_API.g_exc_error;
2477: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2478: RAISE FND_API.g_exc_unexpected_error;
2479: END IF;
2480: END IF;
2481: END IF;
2474:
2475: IF l_return_status = FND_API.g_ret_sts_error THEN
2476: RAISE FND_API.g_exc_error;
2477: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2478: RAISE FND_API.g_exc_unexpected_error;
2479: END IF;
2480: END IF;
2481: END IF;
2482: x_cancellation_code := l_cancellation_code;
2488: , X_Return_Status => l_return_status
2489: , X_Msg_Count => x_msg_count
2490: , X_Msg_Data => x_msg_data
2491: );
2492: IF l_return_status = FND_API.g_ret_sts_unexp_error
2493: THEN
2494: RAISE FND_API.g_exc_unexpected_error;
2495: ELSIF l_return_status = FND_API.g_ret_sts_error
2496: THEN
2490: , X_Msg_Data => x_msg_data
2491: );
2492: IF l_return_status = FND_API.g_ret_sts_unexp_error
2493: THEN
2494: RAISE FND_API.g_exc_unexpected_error;
2495: ELSIF l_return_status = FND_API.g_ret_sts_error
2496: THEN
2497: RAISE FND_API.g_exc_error;
2498: END IF; -- l_return_status
2491: );
2492: IF l_return_status = FND_API.g_ret_sts_unexp_error
2493: THEN
2494: RAISE FND_API.g_exc_unexpected_error;
2495: ELSIF l_return_status = FND_API.g_ret_sts_error
2496: THEN
2497: RAISE FND_API.g_exc_error;
2498: END IF; -- l_return_status
2499:
2493: THEN
2494: RAISE FND_API.g_exc_unexpected_error;
2495: ELSIF l_return_status = FND_API.g_ret_sts_error
2496: THEN
2497: RAISE FND_API.g_exc_error;
2498: END IF; -- l_return_status
2499:
2500: END IF; -- event end date < sysdate
2501: END IF; -- reg charge flag
2541: END IF;
2542: IF (nvl(l_event_status, 'X') in ('ARCHIVED', 'CLOSED'))
2543: THEN
2544: AMS_Utility_PVT.Error_Message('AMS_EVENT_REG_UPDATE_ERROR', 'STATUS', l_event_status_name);
2545: RAISE FND_API.g_exc_error;
2546: END IF;
2547:
2548: IF (l_reg_charge_flag = 'N')
2549: THEN
2582: l_bind_names(1) := 'REGISTRATION_ID' ;
2583: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2584:
2585: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2586: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2587: )
2588: THEN
2589: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2590: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2586: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2587: )
2588: THEN
2589: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2590: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2591: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2592: , p_object_type => l_object_type -- IN VARCHAR2
2593: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2594: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2587: )
2588: THEN
2589: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2590: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2591: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2592: , p_object_type => l_object_type -- IN VARCHAR2
2593: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2594: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2595: -- , p_requestor_type => -- IN VARCHAR2 := NULL
2621: IF (AMS_DEBUG_HIGH_ON) THEN
2622: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2623: END IF;
2624:
2625: IF l_return_status = FND_API.g_ret_sts_error THEN
2626: RAISE FND_API.g_exc_error;
2627: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2628: RAISE FND_API.g_exc_unexpected_error;
2629: END IF;
2622: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2623: END IF;
2624:
2625: IF l_return_status = FND_API.g_ret_sts_error THEN
2626: RAISE FND_API.g_exc_error;
2627: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2628: RAISE FND_API.g_exc_unexpected_error;
2629: END IF;
2630: END IF;
2623: END IF;
2624:
2625: IF l_return_status = FND_API.g_ret_sts_error THEN
2626: RAISE FND_API.g_exc_error;
2627: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2628: RAISE FND_API.g_exc_unexpected_error;
2629: END IF;
2630: END IF;
2631: END IF;
2624:
2625: IF l_return_status = FND_API.g_ret_sts_error THEN
2626: RAISE FND_API.g_exc_error;
2627: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2628: RAISE FND_API.g_exc_unexpected_error;
2629: END IF;
2630: END IF;
2631: END IF;
2632: x_cancellation_code := l_cancellation_code;
2638: , X_Return_Status => l_return_status
2639: , X_Msg_Count => x_msg_count
2640: , X_Msg_Data => x_msg_data
2641: );
2642: IF l_return_status = FND_API.g_ret_sts_unexp_error
2643: THEN
2644: RAISE FND_API.g_exc_unexpected_error;
2645: ELSIF l_return_status = FND_API.g_ret_sts_error
2646: THEN
2640: , X_Msg_Data => x_msg_data
2641: );
2642: IF l_return_status = FND_API.g_ret_sts_unexp_error
2643: THEN
2644: RAISE FND_API.g_exc_unexpected_error;
2645: ELSIF l_return_status = FND_API.g_ret_sts_error
2646: THEN
2647: RAISE FND_API.g_exc_error;
2648: END IF; -- l_return_status
2641: );
2642: IF l_return_status = FND_API.g_ret_sts_unexp_error
2643: THEN
2644: RAISE FND_API.g_exc_unexpected_error;
2645: ELSIF l_return_status = FND_API.g_ret_sts_error
2646: THEN
2647: RAISE FND_API.g_exc_error;
2648: END IF; -- l_return_status
2649:
2643: THEN
2644: RAISE FND_API.g_exc_unexpected_error;
2645: ELSIF l_return_status = FND_API.g_ret_sts_error
2646: THEN
2647: RAISE FND_API.g_exc_error;
2648: END IF; -- l_return_status
2649:
2650: ELSE
2651: IF (l_event_end_date < sysdate)
2657: IF (AMS_DEBUG_HIGH_ON) THEN
2658:
2659: AMS_UTILITY_PVT.debug_message('AMS_EVT_REG_CANC_DATE');
2660: END IF;
2661: x_return_status := FND_API.g_ret_sts_error;
2662: RAISE FND_API.G_EXC_ERROR;
2663: ELSE
2664: IF (l_cancellation_code IS NULL)
2665: THEN
2658:
2659: AMS_UTILITY_PVT.debug_message('AMS_EVT_REG_CANC_DATE');
2660: END IF;
2661: x_return_status := FND_API.g_ret_sts_error;
2662: RAISE FND_API.G_EXC_ERROR;
2663: ELSE
2664: IF (l_cancellation_code IS NULL)
2665: THEN
2666: OPEN c_evtregs_cancel_seq;
2696: l_bind_names(1) := 'REGISTRATION_ID' ;
2697: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2698:
2699: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2700: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2701: )
2702: THEN
2703: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2704: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2700: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2701: )
2702: THEN
2703: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2704: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2705: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2706: , p_object_type => l_object_type -- IN VARCHAR2
2707: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2708: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2701: )
2702: THEN
2703: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
2704: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
2705: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
2706: , p_object_type => l_object_type -- IN VARCHAR2
2707: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
2708: , p_trigger_type => 'REG_CANCEL' -- IN VARCHAR2
2709: -- , p_requestor_type => -- IN VARCHAR2 := NULL
2735: IF (AMS_DEBUG_HIGH_ON) THEN
2736: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2737: END IF;
2738:
2739: IF l_return_status = FND_API.g_ret_sts_error THEN
2740: RAISE FND_API.g_exc_error;
2741: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2742: RAISE FND_API.g_exc_unexpected_error;
2743: END IF;
2736: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
2737: END IF;
2738:
2739: IF l_return_status = FND_API.g_ret_sts_error THEN
2740: RAISE FND_API.g_exc_error;
2741: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2742: RAISE FND_API.g_exc_unexpected_error;
2743: END IF;
2744: END IF;
2737: END IF;
2738:
2739: IF l_return_status = FND_API.g_ret_sts_error THEN
2740: RAISE FND_API.g_exc_error;
2741: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2742: RAISE FND_API.g_exc_unexpected_error;
2743: END IF;
2744: END IF;
2745: END IF;
2738:
2739: IF l_return_status = FND_API.g_ret_sts_error THEN
2740: RAISE FND_API.g_exc_error;
2741: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2742: RAISE FND_API.g_exc_unexpected_error;
2743: END IF;
2744: END IF;
2745: END IF;
2746: x_cancellation_code := l_cancellation_code;
2752: , X_Return_Status => l_return_status
2753: , X_Msg_Count => x_msg_count
2754: , X_Msg_Data => x_msg_data
2755: );
2756: IF l_return_status = FND_API.g_ret_sts_unexp_error
2757: THEN
2758: RAISE FND_API.g_exc_unexpected_error;
2759: ELSIF l_return_status = FND_API.g_ret_sts_error
2760: THEN
2754: , X_Msg_Data => x_msg_data
2755: );
2756: IF l_return_status = FND_API.g_ret_sts_unexp_error
2757: THEN
2758: RAISE FND_API.g_exc_unexpected_error;
2759: ELSIF l_return_status = FND_API.g_ret_sts_error
2760: THEN
2761: RAISE FND_API.g_exc_error;
2762: END IF; -- l_return_status
2755: );
2756: IF l_return_status = FND_API.g_ret_sts_unexp_error
2757: THEN
2758: RAISE FND_API.g_exc_unexpected_error;
2759: ELSIF l_return_status = FND_API.g_ret_sts_error
2760: THEN
2761: RAISE FND_API.g_exc_error;
2762: END IF; -- l_return_status
2763: END IF; -- event end date
2757: THEN
2758: RAISE FND_API.g_exc_unexpected_error;
2759: ELSIF l_return_status = FND_API.g_ret_sts_error
2760: THEN
2761: RAISE FND_API.g_exc_error;
2762: END IF; -- l_return_status
2763: END IF; -- event end date
2764: END IF; -- reg charge flag
2765: END IF; -- CONF CODE NOT NULL
2767: END IF; -- registration group id null
2768: END IF; -- event offer id
2769:
2770: -- Standard check for p_commit
2771: IF (FND_API.to_Boolean(p_commit))
2772: THEN
2773: COMMIT WORK;
2774: END IF; -- p_commit
2775:
2773: COMMIT WORK;
2774: END IF; -- p_commit
2775:
2776: -- Standard call to get message count and if count is 1, get message info.
2777: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2778: , p_count => x_msg_count
2779: , p_data => x_msg_data
2780: );
2781:
2788: END IF;
2789:
2790: EXCEPTION
2791:
2792: WHEN FND_API.g_exc_error
2793: THEN
2794: ROLLBACK TO Cancel_EvtRegs_PVT;
2795: x_return_status := FND_API.g_ret_sts_error;
2796: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2791:
2792: WHEN FND_API.g_exc_error
2793: THEN
2794: ROLLBACK TO Cancel_EvtRegs_PVT;
2795: x_return_status := FND_API.g_ret_sts_error;
2796: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2797: , p_count => x_msg_count
2798: , p_data => x_msg_data
2799: );
2792: WHEN FND_API.g_exc_error
2793: THEN
2794: ROLLBACK TO Cancel_EvtRegs_PVT;
2795: x_return_status := FND_API.g_ret_sts_error;
2796: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2797: , p_count => x_msg_count
2798: , p_data => x_msg_data
2799: );
2800:
2797: , p_count => x_msg_count
2798: , p_data => x_msg_data
2799: );
2800:
2801: WHEN FND_API.g_exc_unexpected_error
2802: THEN
2803: ROLLBACK TO Cancel_EvtRegs_PVT;
2804: x_return_status := FND_API.g_ret_sts_unexp_error;
2805: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2800:
2801: WHEN FND_API.g_exc_unexpected_error
2802: THEN
2803: ROLLBACK TO Cancel_EvtRegs_PVT;
2804: x_return_status := FND_API.g_ret_sts_unexp_error;
2805: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2806: , p_count => x_msg_count
2807: , p_data => x_msg_data
2808: );
2801: WHEN FND_API.g_exc_unexpected_error
2802: THEN
2803: ROLLBACK TO Cancel_EvtRegs_PVT;
2804: x_return_status := FND_API.g_ret_sts_unexp_error;
2805: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2806: , p_count => x_msg_count
2807: , p_data => x_msg_data
2808: );
2809:
2809:
2810: WHEN OTHERS
2811: THEN
2812: ROLLBACK TO Cancel_EvtRegs_PVT;
2813: x_return_status := FND_API.g_ret_sts_unexp_error;
2814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2815: THEN
2816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2817: END IF; -- check_msg_level
2814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2815: THEN
2816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2817: END IF; -- check_msg_level
2818: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2819: , p_count => x_msg_count
2820: , p_data => x_msg_data
2821: );
2822:
2822:
2823: End Cancel_evtregs;
2824:
2825: PROCEDURE lock_evtregs( p_api_version_Number IN NUMBER
2826: , p_init_msg_list IN VARCHAR2 := FND_API.g_false
2827: , p_validation_level IN NUMBER := FND_API.g_valid_level_full
2828: , x_return_status OUT NOCOPY VARCHAR2
2829: , x_msg_count OUT NOCOPY NUMBER
2830: , x_msg_data OUT NOCOPY VARCHAR2
2823: End Cancel_evtregs;
2824:
2825: PROCEDURE lock_evtregs( p_api_version_Number IN NUMBER
2826: , p_init_msg_list IN VARCHAR2 := FND_API.g_false
2827: , p_validation_level IN NUMBER := FND_API.g_valid_level_full
2828: , x_return_status OUT NOCOPY VARCHAR2
2829: , x_msg_count OUT NOCOPY NUMBER
2830: , x_msg_data OUT NOCOPY VARCHAR2
2831: , p_event_registration_id IN NUMBER
2853:
2854: AMS_Utility_PVT.debug_message(l_full_name||': start');
2855: END IF;
2856:
2857: IF FND_API.to_boolean(p_init_msg_list)
2858: THEN
2859: FND_MSG_PUB.initialize;
2860: END IF; -- p_init_msg_list
2861:
2858: THEN
2859: FND_MSG_PUB.initialize;
2860: END IF; -- p_init_msg_list
2861:
2862: IF (NOT FND_API.compatible_api_call( l_api_version_number
2863: , p_api_version_number
2864: , l_api_name
2865: , g_pkg_name
2866: )
2865: , g_pkg_name
2866: )
2867: )
2868: THEN
2869: RAISE FND_API.g_exc_unexpected_error;
2870: END IF; -- compatible API call
2871:
2872: x_return_status := FND_API.G_RET_STS_SUCCESS;
2873:
2868: THEN
2869: RAISE FND_API.g_exc_unexpected_error;
2870: END IF; -- compatible API call
2871:
2872: x_return_status := FND_API.G_RET_STS_SUCCESS;
2873:
2874: ------------------------ lock -------------------------
2875: IF (AMS_DEBUG_HIGH_ON) THEN
2876:
2883: IF (c_reg_b%NOTFOUND)
2884: THEN
2885: CLOSE c_reg_b;
2886: AMS_Utility_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
2887: RAISE FND_API.g_exc_error;
2888: END IF;
2889: CLOSE c_reg_b;
2890:
2891: -------------------- finish --------------------------
2888: END IF;
2889: CLOSE c_reg_b;
2890:
2891: -------------------- finish --------------------------
2892: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2893: , p_count => x_msg_count
2894: , p_data => x_msg_data
2895: );
2896:
2905: EXCEPTION
2906:
2907: WHEN AMS_Utility_PVT.resource_locked
2908: THEN
2909: x_return_status := FND_API.g_ret_sts_error;
2910: AMS_Utility_PVT.error_message('AMS_API_RESOURCE_LOCKED');
2911: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2912: , p_count => x_msg_count
2913: , p_data => x_msg_data
2907: WHEN AMS_Utility_PVT.resource_locked
2908: THEN
2909: x_return_status := FND_API.g_ret_sts_error;
2910: AMS_Utility_PVT.error_message('AMS_API_RESOURCE_LOCKED');
2911: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2912: , p_count => x_msg_count
2913: , p_data => x_msg_data
2914: );
2915:
2912: , p_count => x_msg_count
2913: , p_data => x_msg_data
2914: );
2915:
2916: WHEN FND_API.g_exc_error
2917: THEN
2918: x_return_status := FND_API.g_ret_sts_error;
2919: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2920: , p_count => x_msg_count
2914: );
2915:
2916: WHEN FND_API.g_exc_error
2917: THEN
2918: x_return_status := FND_API.g_ret_sts_error;
2919: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2920: , p_count => x_msg_count
2921: , p_data => x_msg_data
2922: );
2915:
2916: WHEN FND_API.g_exc_error
2917: THEN
2918: x_return_status := FND_API.g_ret_sts_error;
2919: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2920: , p_count => x_msg_count
2921: , p_data => x_msg_data
2922: );
2923:
2920: , p_count => x_msg_count
2921: , p_data => x_msg_data
2922: );
2923:
2924: WHEN FND_API.g_exc_unexpected_error
2925: THEN
2926: x_return_status := FND_API.g_ret_sts_unexp_error;
2927: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2928: , p_count => x_msg_count
2922: );
2923:
2924: WHEN FND_API.g_exc_unexpected_error
2925: THEN
2926: x_return_status := FND_API.g_ret_sts_unexp_error;
2927: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2928: , p_count => x_msg_count
2929: , p_data => x_msg_data
2930: );
2923:
2924: WHEN FND_API.g_exc_unexpected_error
2925: THEN
2926: x_return_status := FND_API.g_ret_sts_unexp_error;
2927: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2928: , p_count => x_msg_count
2929: , p_data => x_msg_data
2930: );
2931:
2930: );
2931:
2932: WHEN OTHERS
2933: THEN
2934: x_return_status := FND_API.g_ret_sts_unexp_error;
2935: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
2936: THEN
2937: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2938: END IF; -- check_msg_Level
2935: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
2936: THEN
2937: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2938: END IF; -- check_msg_Level
2939: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2940: , p_count => x_msg_count
2941: , p_data => x_msg_data
2942: );
2943:
2943:
2944: END lock_evtregs;
2945:
2946: PROCEDURE delete_evtRegs( p_api_version_number IN NUMBER
2947: , p_init_msg_list IN VARCHAR2 := FND_API.g_false
2948: , p_commit IN VARCHAR2 := FND_API.g_false
2949: , p_object_version IN NUMBER
2950: , p_event_registration_id IN NUMBER
2951: , x_return_status OUT NOCOPY VARCHAR2
2944: END lock_evtregs;
2945:
2946: PROCEDURE delete_evtRegs( p_api_version_number IN NUMBER
2947: , p_init_msg_list IN VARCHAR2 := FND_API.g_false
2948: , p_commit IN VARCHAR2 := FND_API.g_false
2949: , p_object_version IN NUMBER
2950: , p_event_registration_id IN NUMBER
2951: , x_return_status OUT NOCOPY VARCHAR2
2952: , x_msg_count OUT NOCOPY NUMBER
2967:
2968: AMS_Utility_PVT.debug_message(l_full_name||': start');
2969: END IF;
2970:
2971: IF FND_API.to_boolean(p_init_msg_list)
2972: THEN
2973: FND_MSG_PUB.initialize;
2974: END IF; -- p_init_msg_list
2975:
2972: THEN
2973: FND_MSG_PUB.initialize;
2974: END IF; -- p_init_msg_list
2975:
2976: IF (NOT FND_API.compatible_api_call( l_api_version_number
2977: , p_api_version_number
2978: , l_api_name
2979: , g_pkg_name
2980: )
2979: , g_pkg_name
2980: )
2981: )
2982: THEN
2983: RAISE FND_API.g_exc_unexpected_error;
2984: END IF; -- compatible API call
2985:
2986: x_return_status := FND_API.G_RET_STS_SUCCESS;
2987:
2982: THEN
2983: RAISE FND_API.g_exc_unexpected_error;
2984: END IF; -- compatible API call
2985:
2986: x_return_status := FND_API.G_RET_STS_SUCCESS;
2987:
2988: ------------------------ delete ------------------------
2989: IF (AMS_DEBUG_HIGH_ON) THEN
2990:
2998:
2999: IF (SQL%NOTFOUND)
3000: THEN
3001: AMS_Utility_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
3002: RAISE FND_API.g_exc_error;
3003: END IF; -- SQL%NOTFOUND
3004:
3005: -------------------- finish --------------------------
3006: IF (FND_API.to_boolean(p_commit))
3002: RAISE FND_API.g_exc_error;
3003: END IF; -- SQL%NOTFOUND
3004:
3005: -------------------- finish --------------------------
3006: IF (FND_API.to_boolean(p_commit))
3007: THEN
3008: COMMIT;
3009: END IF; -- p_commit
3010:
3007: THEN
3008: COMMIT;
3009: END IF; -- p_commit
3010:
3011: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3012: , p_count => x_msg_count
3013: , p_data => x_msg_data
3014: );
3015:
3022: END IF;
3023:
3024: EXCEPTION
3025:
3026: WHEN FND_API.g_exc_error
3027: THEN
3028: ROLLBACK TO delete_evtRegs;
3029: x_return_status := FND_API.g_ret_sts_error;
3030: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3025:
3026: WHEN FND_API.g_exc_error
3027: THEN
3028: ROLLBACK TO delete_evtRegs;
3029: x_return_status := FND_API.g_ret_sts_error;
3030: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3031: , p_count => x_msg_count
3032: , p_data => x_msg_data
3033: );
3026: WHEN FND_API.g_exc_error
3027: THEN
3028: ROLLBACK TO delete_evtRegs;
3029: x_return_status := FND_API.g_ret_sts_error;
3030: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3031: , p_count => x_msg_count
3032: , p_data => x_msg_data
3033: );
3034:
3031: , p_count => x_msg_count
3032: , p_data => x_msg_data
3033: );
3034:
3035: WHEN FND_API.g_exc_unexpected_error
3036: THEN
3037: ROLLBACK TO delete_evtRegs;
3038: x_return_status := FND_API.g_ret_sts_unexp_error ;
3039: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3034:
3035: WHEN FND_API.g_exc_unexpected_error
3036: THEN
3037: ROLLBACK TO delete_evtRegs;
3038: x_return_status := FND_API.g_ret_sts_unexp_error ;
3039: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3040: , p_count => x_msg_count
3041: , p_data => x_msg_data
3042: );
3035: WHEN FND_API.g_exc_unexpected_error
3036: THEN
3037: ROLLBACK TO delete_evtRegs;
3038: x_return_status := FND_API.g_ret_sts_unexp_error ;
3039: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3040: , p_count => x_msg_count
3041: , p_data => x_msg_data
3042: );
3043:
3043:
3044: WHEN OTHERS
3045: THEN
3046: ROLLBACK TO delete_evtRegs;
3047: x_return_status := FND_API.g_ret_sts_unexp_error ;
3048: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3049: THEN
3050: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3051: END IF; -- check_msg_level
3048: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3049: THEN
3050: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3051: END IF; -- check_msg_level
3052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3053: , p_count => x_msg_count
3054: , p_data => x_msg_data
3055: );
3056:
3056:
3057: END delete_evtRegs;
3058:
3059: PROCEDURE prioritize_waitlist( p_api_version_number IN NUMBER
3060: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3061: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3062: , p_override_availability IN VARCHAR2 := FND_API.G_FALSE
3063: , p_event_offer_id IN NUMBER
3064: , x_return_status OUT NOCOPY VARCHAR2
3057: END delete_evtRegs;
3058:
3059: PROCEDURE prioritize_waitlist( p_api_version_number IN NUMBER
3060: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3061: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3062: , p_override_availability IN VARCHAR2 := FND_API.G_FALSE
3063: , p_event_offer_id IN NUMBER
3064: , x_return_status OUT NOCOPY VARCHAR2
3065: , x_msg_count OUT NOCOPY NUMBER
3058:
3059: PROCEDURE prioritize_waitlist( p_api_version_number IN NUMBER
3060: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3061: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3062: , p_override_availability IN VARCHAR2 := FND_API.G_FALSE
3063: , p_event_offer_id IN NUMBER
3064: , x_return_status OUT NOCOPY VARCHAR2
3065: , x_msg_count OUT NOCOPY NUMBER
3066: , x_msg_data OUT NOCOPY VARCHAR2
3155:
3156: AMS_Utility_PVT.debug_message(l_full_name||': start');
3157: END IF;
3158:
3159: IF FND_API.to_boolean(p_init_msg_list)
3160: THEN
3161: FND_MSG_PUB.initialize;
3162: END IF; -- p_init_msg_list
3163:
3160: THEN
3161: FND_MSG_PUB.initialize;
3162: END IF; -- p_init_msg_list
3163:
3164: IF (NOT FND_API.compatible_api_call( l_api_version_number
3165: , p_api_version_number
3166: , l_api_name
3167: , g_pkg_name
3168: )
3167: , g_pkg_name
3168: )
3169: )
3170: THEN
3171: RAISE FND_API.g_exc_unexpected_error;
3172: END IF; -- compatible API call
3173:
3174: -- Initialize API return status to SUCCESS
3175: l_return_status := FND_API.G_RET_STS_SUCCESS;
3171: RAISE FND_API.g_exc_unexpected_error;
3172: END IF; -- compatible API call
3173:
3174: -- Initialize API return status to SUCCESS
3175: l_return_status := FND_API.G_RET_STS_SUCCESS;
3176:
3177: -- validate not null values passed for required parameters...
3178: IF (p_event_offer_id IS NULL)
3179: THEN
3177: -- validate not null values passed for required parameters...
3178: IF (p_event_offer_id IS NULL)
3179: THEN
3180: AMS_Utility_PVT.error_message('AMS_EVT_REG_PR_NULL_PARAM');
3181: l_return_status := FND_API.g_ret_sts_error;
3182: END IF; -- p_event_offer_id
3183:
3184: /* check Offer id's fk .....*/
3185: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3184: /* check Offer id's fk .....*/
3185: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3186: , 'event_offer_id'
3187: , p_event_offer_id
3188: ) = FND_API.g_false
3189: )
3190: THEN
3191: AMS_Utility_PVT.error_message('AMS_EVT_REG_PR_BAD_EVOID');
3192: l_return_status := FND_API.g_ret_sts_error;
3188: ) = FND_API.g_false
3189: )
3190: THEN
3191: AMS_Utility_PVT.error_message('AMS_EVT_REG_PR_BAD_EVOID');
3192: l_return_status := FND_API.g_ret_sts_error;
3193: -- RAISE FND_API.g_exc_error;
3194: END IF; -- check_fk_exists
3195:
3196: ------------------api logic-----------------------
3189: )
3190: THEN
3191: AMS_Utility_PVT.error_message('AMS_EVT_REG_PR_BAD_EVOID');
3192: l_return_status := FND_API.g_ret_sts_error;
3193: -- RAISE FND_API.g_exc_error;
3194: END IF; -- check_fk_exists
3195:
3196: ------------------api logic-----------------------
3197: -- Get the offering details of offer id
3233:
3234: AMS_UTILITY_PVT.debug_message('Registrations for the event offering are frozen- Cannot prioritize your wait');
3235: END IF;
3236: -- AMS_Utility_PVT.error_message('AMS_EVT_REG_PRI_FROZEN');
3237: -- RAISE FND_API.G_EXC_ERROR;
3238: RETURN;
3239: END IF; -- l_reg_frozen_flag
3240:
3241: if ( (p_override_availability = FND_API.G_FALSE)
3237: -- RAISE FND_API.G_EXC_ERROR;
3238: RETURN;
3239: END IF; -- l_reg_frozen_flag
3240:
3241: if ( (p_override_availability = FND_API.G_FALSE)
3242: AND
3243: (check_reg_availability( l_effective_capacity
3244: , p_event_offer_id
3245: ) <= 0
3250:
3251: AMS_UTILITY_PVT.debug_message('No Waitlist Available');
3252: END IF;
3253: -- AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_WAIT_ALLOWED');
3254: -- RAISE FND_API.G_EXC_ERROR;
3255: RETURN;
3256: END IF;
3257:
3258: OPEN c_prioritize_waiting_minnum(p_event_offer_id);
3272: THEN
3273: /*
3274: -- create task for notification
3275: AMS_TASK_PVT.Create_task( p_api_version => l_api_version_number
3276: , p_init_msg_list => FND_API.g_false
3277: , p_commit => FND_API.g_false
3278: , p_task_id => NULL
3279: , p_task_name => 'wait list registration task for - '||l_event_offer_name
3280: , p_task_type_id => 15 -- from jtf_task_types_vl
3273: /*
3274: -- create task for notification
3275: AMS_TASK_PVT.Create_task( p_api_version => l_api_version_number
3276: , p_init_msg_list => FND_API.g_false
3277: , p_commit => FND_API.g_false
3278: , p_task_id => NULL
3279: , p_task_name => 'wait list registration task for - '||l_event_offer_name
3280: , p_task_type_id => 15 -- from jtf_task_types_vl
3281: , p_task_status_id => 13 -- in jtf_task_statuses_vl, 13
3293: , x_msg_count => x_msg_count
3294: , x_msg_data => x_msg_data
3295: , x_task_id => l_task_id
3296: );
3297: IF (l_return_status = FND_API.g_ret_sts_error)
3298: THEN
3299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3300: THEN
3301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3300: THEN
3301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3302: END IF; -- check_msg_level
3303: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3304: , p_count => x_msg_count
3305: , p_data => x_msg_data
3306: );
3307: RAISE FND_API.g_exc_error;
3303: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3304: , p_count => x_msg_count
3305: , p_data => x_msg_data
3306: );
3307: RAISE FND_API.g_exc_error;
3308: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3309: THEN
3310: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3311: THEN
3304: , p_count => x_msg_count
3305: , p_data => x_msg_data
3306: );
3307: RAISE FND_API.g_exc_error;
3308: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3309: THEN
3310: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3311: THEN
3312: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3310: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3311: THEN
3312: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3313: END IF; -- check_msg_level
3314: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3315: , p_count => x_msg_count
3316: , p_data => x_msg_data
3317: );
3318: RAISE FND_API.g_exc_unexpected_error;
3314: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3315: , p_count => x_msg_count
3316: , p_data => x_msg_data
3317: );
3318: RAISE FND_API.g_exc_unexpected_error;
3319: END IF; -- l_return_status
3320: -- create task assignment
3321: IF (AMS_DEBUG_HIGH_ON) THEN
3322:
3322:
3323: AMS_Utility_PVT.debug_message('calling AMS_TASK_PVT.Create_Task_Assignment');
3324: END IF;
3325: AMS_TASK_PVT.Create_Task_Assignment( p_api_version => l_api_version_number
3326: , p_init_msg_list => FND_API.g_false
3327: , p_commit => FND_API.g_false
3328: , p_task_id => l_task_id
3329: , p_resource_type_code => 'RS_EMPLOYEE'
3330: , p_resource_id => l_sales_rep_id
3323: AMS_Utility_PVT.debug_message('calling AMS_TASK_PVT.Create_Task_Assignment');
3324: END IF;
3325: AMS_TASK_PVT.Create_Task_Assignment( p_api_version => l_api_version_number
3326: , p_init_msg_list => FND_API.g_false
3327: , p_commit => FND_API.g_false
3328: , p_task_id => l_task_id
3329: , p_resource_type_code => 'RS_EMPLOYEE'
3330: , p_resource_id => l_sales_rep_id
3331: , p_assignment_status_id => 1
3333: , x_msg_count => x_msg_count
3334: , x_msg_data => x_msg_data
3335: , x_task_assignment_id => l_task_assignment_id
3336: );
3337: IF (l_return_status = FND_API.g_ret_sts_error)
3338: THEN
3339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3340: THEN
3341: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3340: THEN
3341: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3342: END IF; -- check_msg_level
3343: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3344: , p_count => x_msg_count
3345: , p_data => x_msg_data
3346: );
3347: RAISE FND_API.g_exc_error;
3343: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3344: , p_count => x_msg_count
3345: , p_data => x_msg_data
3346: );
3347: RAISE FND_API.g_exc_error;
3348: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3349: THEN
3350: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3351: THEN
3344: , p_count => x_msg_count
3345: , p_data => x_msg_data
3346: );
3347: RAISE FND_API.g_exc_error;
3348: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3349: THEN
3350: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3351: THEN
3352: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3350: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3351: THEN
3352: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3353: END IF; -- check_msg_level
3354: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3355: , p_count => x_msg_count
3356: , p_data => x_msg_data
3357: );
3358: RAISE FND_API.g_exc_unexpected_error;
3354: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3355: , p_count => x_msg_count
3356: , p_data => x_msg_data
3357: );
3358: RAISE FND_API.g_exc_unexpected_error;
3359: END IF; -- l_return_status
3360: ELSE -- l_e_auto_register_flag
3361: */
3362: update ams_event_registrations set
3379:
3380: IF (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
3381: THEN
3382: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
3383: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
3384: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
3385: , p_object_type => l_object_type -- IN VARCHAR2
3386: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
3387: , p_trigger_type => 'REG_CONFIRM' -- IN VARCHAR2
3380: IF (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
3381: THEN
3382: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
3383: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
3384: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false
3385: , p_object_type => l_object_type -- IN VARCHAR2
3386: , p_object_id => l_object_id --p_event_offer_id -- IN NUMBER
3387: , p_trigger_type => 'REG_CONFIRM' -- IN VARCHAR2
3388: -- , p_requestor_type => -- IN VARCHAR2 := NULL
3414: IF (AMS_DEBUG_HIGH_ON) THEN
3415: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
3416: END IF;
3417:
3418: IF l_return_status = FND_API.g_ret_sts_error THEN
3419: RAISE FND_API.g_exc_error;
3420: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3421: RAISE FND_API.g_exc_unexpected_error;
3422: END IF;
3415: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
3416: END IF;
3417:
3418: IF l_return_status = FND_API.g_ret_sts_error THEN
3419: RAISE FND_API.g_exc_error;
3420: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3421: RAISE FND_API.g_exc_unexpected_error;
3422: END IF;
3423:
3416: END IF;
3417:
3418: IF l_return_status = FND_API.g_ret_sts_error THEN
3419: RAISE FND_API.g_exc_error;
3420: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3421: RAISE FND_API.g_exc_unexpected_error;
3422: END IF;
3423:
3424: END IF;
3417:
3418: IF l_return_status = FND_API.g_ret_sts_error THEN
3419: RAISE FND_API.g_exc_error;
3420: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3421: RAISE FND_API.g_exc_unexpected_error;
3422: END IF;
3423:
3424: END IF;
3425:
3437:
3438: x_return_status := l_return_status;
3439:
3440: -- Standard check for p_commit
3441: IF (FND_API.to_Boolean(p_commit))
3442: THEN
3443: COMMIT WORK;
3444: END IF; -- p_commit
3445:
3442: THEN
3443: COMMIT WORK;
3444: END IF; -- p_commit
3445:
3446: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3447: , p_count => x_msg_count
3448: , p_data => x_msg_data
3449: );
3450:
3457: END IF;
3458:
3459: EXCEPTION
3460:
3461: WHEN FND_API.g_exc_error
3462: THEN
3463: ROLLBACK TO prioritize_waitlist;
3464: x_return_status := FND_API.g_ret_sts_error;
3465: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3460:
3461: WHEN FND_API.g_exc_error
3462: THEN
3463: ROLLBACK TO prioritize_waitlist;
3464: x_return_status := FND_API.g_ret_sts_error;
3465: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3466: , p_count => x_msg_count
3467: , p_data => x_msg_data
3468: );
3461: WHEN FND_API.g_exc_error
3462: THEN
3463: ROLLBACK TO prioritize_waitlist;
3464: x_return_status := FND_API.g_ret_sts_error;
3465: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3466: , p_count => x_msg_count
3467: , p_data => x_msg_data
3468: );
3469:
3466: , p_count => x_msg_count
3467: , p_data => x_msg_data
3468: );
3469:
3470: WHEN FND_API.g_exc_unexpected_error
3471: THEN
3472: ROLLBACK TO prioritize_waitlist;
3473: x_return_status := FND_API.g_ret_sts_unexp_error;
3474: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3469:
3470: WHEN FND_API.g_exc_unexpected_error
3471: THEN
3472: ROLLBACK TO prioritize_waitlist;
3473: x_return_status := FND_API.g_ret_sts_unexp_error;
3474: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3475: , p_count => x_msg_count
3476: , p_data => x_msg_data
3477: );
3470: WHEN FND_API.g_exc_unexpected_error
3471: THEN
3472: ROLLBACK TO prioritize_waitlist;
3473: x_return_status := FND_API.g_ret_sts_unexp_error;
3474: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3475: , p_count => x_msg_count
3476: , p_data => x_msg_data
3477: );
3478:
3478:
3479: WHEN OTHERS
3480: THEN
3481: ROLLBACK TO prioritize_waitlist;
3482: x_return_status := FND_API.g_ret_sts_unexp_error;
3483: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3484: THEN
3485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3486: END IF; -- check_msg_level
3483: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3484: THEN
3485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3486: END IF; -- check_msg_level
3487: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3488: , p_count => x_msg_count
3489: , p_data => x_msg_data
3490: );
3491:
3509: -- 'Attendant information' is mandatory, but for account information...
3510: -- if registrant info is changed, reg_contact id is stored in original_reg_contact_id column..
3511: -------------------------------------------------------------
3512: PROCEDURE substitute_and_validate( P_Api_Version_Number IN NUMBER
3513: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3514: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3515: , p_confirmation_code IN VARCHAR2
3516: , p_attendant_party_id IN NUMBER
3517: , p_attendant_contact_id IN NUMBER
3510: -- if registrant info is changed, reg_contact id is stored in original_reg_contact_id column..
3511: -------------------------------------------------------------
3512: PROCEDURE substitute_and_validate( P_Api_Version_Number IN NUMBER
3513: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3514: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3515: , p_confirmation_code IN VARCHAR2
3516: , p_attendant_party_id IN NUMBER
3517: , p_attendant_contact_id IN NUMBER
3518: , p_attendant_account_id IN NUMBER
3540:
3541: AMS_Utility_PVT.debug_message(l_full_name || ': start');
3542: END IF;
3543:
3544: IF FND_API.to_boolean(p_init_msg_list)
3545: THEN
3546: FND_MSG_PUB.initialize;
3547: END IF; -- p_init_msg_list
3548:
3545: THEN
3546: FND_MSG_PUB.initialize;
3547: END IF; -- p_init_msg_list
3548:
3549: IF (NOT FND_API.compatible_api_call( l_api_version_number
3550: , p_api_version_number
3551: , l_api_name
3552: , g_pkg_name
3553: )
3552: , g_pkg_name
3553: )
3554: )
3555: THEN
3556: RAISE FND_API.g_exc_unexpected_error;
3557: END IF; -- compatible API call
3558:
3559: -- Initialize API return status to SUCCESS
3560: l_return_status := FND_API.G_RET_STS_SUCCESS;
3556: RAISE FND_API.g_exc_unexpected_error;
3557: END IF; -- compatible API call
3558:
3559: -- Initialize API return status to SUCCESS
3560: l_return_status := FND_API.G_RET_STS_SUCCESS;
3561:
3562: -- validate not null values passed for required parameters...
3563: IF ( (p_confirmation_code IS NULL)
3564: OR (p_attendant_party_id IS NULL)
3566: OR (p_registrant_contact_id IS NULL)
3567: )
3568: THEN
3569: AMS_Utility_PVT.error_message('AMS_EVT_REG_SUBST_NULL_PARAM');
3570: x_return_status := FND_API.g_ret_sts_error;
3571: RAISE FND_API.g_exc_error;
3572: END IF; -- null ids
3573:
3574: -- validate the registrant fk info....
3567: )
3568: THEN
3569: AMS_Utility_PVT.error_message('AMS_EVT_REG_SUBST_NULL_PARAM');
3570: x_return_status := FND_API.g_ret_sts_error;
3571: RAISE FND_API.g_exc_error;
3572: END IF; -- null ids
3573:
3574: -- validate the registrant fk info....
3575: check_registrant_fk_info( p_registrant_party_id
3577: , p_registrant_account_id
3578: , x_return_status => l_return_status
3579: );
3580:
3581: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3582: THEN
3583: RAISE FND_API.g_exc_unexpected_error;
3584: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3585: THEN
3579: );
3580:
3581: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3582: THEN
3583: RAISE FND_API.g_exc_unexpected_error;
3584: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3585: THEN
3586: RAISE FND_API.g_exc_error;
3587: END IF; -- l_return_status
3580:
3581: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3582: THEN
3583: RAISE FND_API.g_exc_unexpected_error;
3584: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3585: THEN
3586: RAISE FND_API.g_exc_error;
3587: END IF; -- l_return_status
3588:
3582: THEN
3583: RAISE FND_API.g_exc_unexpected_error;
3584: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3585: THEN
3586: RAISE FND_API.g_exc_error;
3587: END IF; -- l_return_status
3588:
3589: -- update sql stmt
3590: -------------------------- update --------------------
3605:
3606: IF (SQL%NOTFOUND)
3607: THEN
3608: AMS_Utility_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
3609: RAISE FND_API.g_exc_error;
3610: END IF; -- SQL%NOTFOUND
3611:
3612: -- Standard check for p_commit
3613: IF (FND_API.to_Boolean(p_commit))
3609: RAISE FND_API.g_exc_error;
3610: END IF; -- SQL%NOTFOUND
3611:
3612: -- Standard check for p_commit
3613: IF (FND_API.to_Boolean(p_commit))
3614: THEN
3615: COMMIT WORK;
3616: END IF; -- p_commit
3617:
3614: THEN
3615: COMMIT WORK;
3616: END IF; -- p_commit
3617:
3618: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3619: , p_count => x_msg_count
3620: , p_data => x_msg_data
3621: );
3622:
3628:
3629: END IF;
3630:
3631: EXCEPTION
3632: WHEN FND_API.g_exc_error
3633: THEN
3634: ROLLBACK TO substitute_validate_PVT;
3635: x_return_status := FND_API.g_ret_sts_error;
3636: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3631: EXCEPTION
3632: WHEN FND_API.g_exc_error
3633: THEN
3634: ROLLBACK TO substitute_validate_PVT;
3635: x_return_status := FND_API.g_ret_sts_error;
3636: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3637: , p_count => x_msg_count
3638: , p_data => x_msg_data
3639: );
3632: WHEN FND_API.g_exc_error
3633: THEN
3634: ROLLBACK TO substitute_validate_PVT;
3635: x_return_status := FND_API.g_ret_sts_error;
3636: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3637: , p_count => x_msg_count
3638: , p_data => x_msg_data
3639: );
3640:
3637: , p_count => x_msg_count
3638: , p_data => x_msg_data
3639: );
3640:
3641: WHEN FND_API.g_exc_unexpected_error
3642: THEN
3643: ROLLBACK TO substitute_validate_PVT;
3644: x_return_status := FND_API.g_ret_sts_unexp_error;
3645: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3640:
3641: WHEN FND_API.g_exc_unexpected_error
3642: THEN
3643: ROLLBACK TO substitute_validate_PVT;
3644: x_return_status := FND_API.g_ret_sts_unexp_error;
3645: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3646: , p_count => x_msg_count
3647: , p_data => x_msg_data
3648: );
3641: WHEN FND_API.g_exc_unexpected_error
3642: THEN
3643: ROLLBACK TO substitute_validate_PVT;
3644: x_return_status := FND_API.g_ret_sts_unexp_error;
3645: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3646: , p_count => x_msg_count
3647: , p_data => x_msg_data
3648: );
3649:
3649:
3650: WHEN OTHERS
3651: THEN
3652: ROLLBACK TO substitute_validate_PVT;
3653: x_return_status := FND_API.g_ret_sts_unexp_error;
3654: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3655: THEN
3656: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3657: END IF; -- check_msg_level
3654: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3655: THEN
3656: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3657: END IF; -- check_msg_level
3658: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3659: , p_count => x_msg_count
3660: , p_data => x_msg_data
3661: );
3662:
3681: -- the transfer will fail...
3682: -- PAYMENT details are not taken care of in this API call....
3683: -------------------------------------------------------------
3684: PROCEDURE transfer_and_validate( P_Api_Version_Number IN NUMBER
3685: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3686: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3687: , p_object_version IN NUMBER
3688: , p_old_confirmation_code IN VARCHAR2
3689: , p_old_offer_id IN NUMBER
3682: -- PAYMENT details are not taken care of in this API call....
3683: -------------------------------------------------------------
3684: PROCEDURE transfer_and_validate( P_Api_Version_Number IN NUMBER
3685: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
3686: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
3687: , p_object_version IN NUMBER
3688: , p_old_confirmation_code IN VARCHAR2
3689: , p_old_offer_id IN NUMBER
3690: , p_new_offer_id IN NUMBER
3744:
3745: AMS_Utility_PVT.debug_message(l_full_name || ': start');
3746: END IF;
3747:
3748: IF FND_API.to_boolean(p_init_msg_list)
3749: THEN
3750: FND_MSG_PUB.initialize;
3751: END IF; -- p_init_msg_list
3752:
3749: THEN
3750: FND_MSG_PUB.initialize;
3751: END IF; -- p_init_msg_list
3752:
3753: IF (NOT FND_API.compatible_api_call( l_api_version_number
3754: , p_api_version_number
3755: , l_api_name
3756: , g_pkg_name
3757: )
3756: , g_pkg_name
3757: )
3758: )
3759: THEN
3760: RAISE FND_API.g_exc_unexpected_error;
3761: END IF; -- compatible API call
3762:
3763: -- Initialize API return status to SUCCESS
3764: l_return_status := FND_API.G_RET_STS_SUCCESS;
3760: RAISE FND_API.g_exc_unexpected_error;
3761: END IF; -- compatible API call
3762:
3763: -- Initialize API return status to SUCCESS
3764: l_return_status := FND_API.G_RET_STS_SUCCESS;
3765:
3766: -- validate not null values passed for required parameters...
3767: IF ( (p_old_confirmation_code IS NULL)
3768: OR (p_old_offer_id IS NULL)
3770: OR (p_waitlist_flag IS NULL)
3771: )
3772: THEN
3773: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_NULL_PARAM');
3774: x_return_status := FND_API.g_ret_sts_error;
3775: RAISE FND_API.g_exc_error;
3776: END IF; -- null ids
3777:
3778: -- check Offer id's fk .....
3771: )
3772: THEN
3773: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_NULL_PARAM');
3774: x_return_status := FND_API.g_ret_sts_error;
3775: RAISE FND_API.g_exc_error;
3776: END IF; -- null ids
3777:
3778: -- check Offer id's fk .....
3779: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3778: -- check Offer id's fk .....
3779: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3780: , 'event_offer_id'
3781: , p_old_offer_id
3782: ) = FND_API.g_false
3783: )
3784: THEN
3785: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3786: x_return_status := FND_API.g_ret_sts_error;
3782: ) = FND_API.g_false
3783: )
3784: THEN
3785: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3786: x_return_status := FND_API.g_ret_sts_error;
3787: RAISE FND_API.g_exc_error;
3788: END IF; -- check_fk_exists
3789:
3790: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3783: )
3784: THEN
3785: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3786: x_return_status := FND_API.g_ret_sts_error;
3787: RAISE FND_API.g_exc_error;
3788: END IF; -- check_fk_exists
3789:
3790: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3791: , 'event_offer_id'
3789:
3790: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3791: , 'event_offer_id'
3792: , p_new_offer_id
3793: ) = FND_API.g_false
3794: )
3795: THEN
3796: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3797: x_return_status := FND_API.g_ret_sts_error;
3793: ) = FND_API.g_false
3794: )
3795: THEN
3796: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3797: x_return_status := FND_API.g_ret_sts_error;
3798: RAISE FND_API.g_exc_error;
3799: END IF; -- check_fk_exists
3800:
3801: -- Prevent cancelled registrants from cancelled (probably should not be at this level in the tech stack)
3794: )
3795: THEN
3796: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_BAD_EVOID');
3797: x_return_status := FND_API.g_ret_sts_error;
3798: RAISE FND_API.g_exc_error;
3799: END IF; -- check_fk_exists
3800:
3801: -- Prevent cancelled registrants from cancelled (probably should not be at this level in the tech stack)
3802: open get_registrant_status(p_old_confirmation_code);
3806:
3807: IF (nvl(l_system_status_code,'X') = 'CANCELLED')
3808: THEN
3809: AMS_Utility_PVT.error_message('AMS_EVT_REG_TR_CANCEL');
3810: RAISE FND_API.g_exc_error;
3811: END IF; -- l_system_status_code
3812:
3813: ------------------api logic-----------------------
3814: -- Get the offering details of new offer id
3846: , X_Return_Status => l_return_status
3847: , X_Msg_Count => x_msg_count
3848: , X_Msg_Data => x_msg_data
3849: );
3850: IF l_return_status = FND_API.g_ret_sts_unexp_error
3851: THEN
3852: RAISE FND_API.g_exc_unexpected_error;
3853: ELSIF l_return_status = FND_API.g_ret_sts_error
3854: THEN
3848: , X_Msg_Data => x_msg_data
3849: );
3850: IF l_return_status = FND_API.g_ret_sts_unexp_error
3851: THEN
3852: RAISE FND_API.g_exc_unexpected_error;
3853: ELSIF l_return_status = FND_API.g_ret_sts_error
3854: THEN
3855: RAISE FND_API.g_exc_error;
3856: END IF; -- l_return_status
3849: );
3850: IF l_return_status = FND_API.g_ret_sts_unexp_error
3851: THEN
3852: RAISE FND_API.g_exc_unexpected_error;
3853: ELSIF l_return_status = FND_API.g_ret_sts_error
3854: THEN
3855: RAISE FND_API.g_exc_error;
3856: END IF; -- l_return_status
3857:
3851: THEN
3852: RAISE FND_API.g_exc_unexpected_error;
3853: ELSIF l_return_status = FND_API.g_ret_sts_error
3854: THEN
3855: RAISE FND_API.g_exc_error;
3856: END IF; -- l_return_status
3857:
3858: x_old_system_status_code := 'CANCELLED';
3859: IF (AMS_DEBUG_HIGH_ON) THEN
3900: , x_Msg_Count => x_msg_count
3901: , x_Msg_Data => x_msg_data
3902: );
3903:
3904: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3905: THEN
3906: RAISE FND_API.g_exc_unexpected_error;
3907: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3908: THEN
3902: );
3903:
3904: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3905: THEN
3906: RAISE FND_API.g_exc_unexpected_error;
3907: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3908: THEN
3909: RAISE FND_API.g_exc_error;
3910: END IF; -- l_return_status
3903:
3904: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3905: THEN
3906: RAISE FND_API.g_exc_unexpected_error;
3907: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3908: THEN
3909: RAISE FND_API.g_exc_error;
3910: END IF; -- l_return_status
3911: x_new_system_status_code := l_system_status_code;
3905: THEN
3906: RAISE FND_API.g_exc_unexpected_error;
3907: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3908: THEN
3909: RAISE FND_API.g_exc_error;
3910: END IF; -- l_return_status
3911: x_new_system_status_code := l_system_status_code;
3912:
3913: -- if reg successfull....call cancel_reg for old event offer id and pass out cancellation code for old
3926: , X_Msg_Count => x_msg_count
3927: , X_Msg_Data => x_msg_data
3928: );
3929:
3930: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3931: THEN
3932: RAISE FND_API.g_exc_unexpected_error;
3933: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3934: THEN
3928: );
3929:
3930: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3931: THEN
3932: RAISE FND_API.g_exc_unexpected_error;
3933: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3934: THEN
3935: RAISE FND_API.g_exc_error;
3936: END IF; -- l_return_status
3929:
3930: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
3931: THEN
3932: RAISE FND_API.g_exc_unexpected_error;
3933: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3934: THEN
3935: RAISE FND_API.g_exc_error;
3936: END IF; -- l_return_status
3937: x_old_system_status_code := 'CANCELLED';
3931: THEN
3932: RAISE FND_API.g_exc_unexpected_error;
3933: ELSIF (l_return_status = FND_API.g_ret_sts_error)
3934: THEN
3935: RAISE FND_API.g_exc_error;
3936: END IF; -- l_return_status
3937: x_old_system_status_code := 'CANCELLED';
3938:
3939: ELSE -- check_reg_availability
3950: ELSE -- wailist allowed
3951: if (check_waitlist_availability( l_reg_waitlist_pct
3952: , l_effective_capacity
3953: , p_new_offer_id
3954: ) = FND_API.g_false
3955: )
3956: then
3957: IF (AMS_DEBUG_HIGH_ON) THEN
3958:
3983: , x_Msg_Count => x_msg_count
3984: , x_Msg_Data => x_msg_data
3985: );
3986:
3987: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3988: RAISE FND_API.g_exc_unexpected_error;
3989: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
3990: RAISE FND_API.g_exc_error;
3991: END IF;
3984: , x_Msg_Data => x_msg_data
3985: );
3986:
3987: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3988: RAISE FND_API.g_exc_unexpected_error;
3989: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
3990: RAISE FND_API.g_exc_error;
3991: END IF;
3992: x_new_system_status_code := l_system_status_code;
3985: );
3986:
3987: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3988: RAISE FND_API.g_exc_unexpected_error;
3989: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
3990: RAISE FND_API.g_exc_error;
3991: END IF;
3992: x_new_system_status_code := l_system_status_code;
3993:
3986:
3987: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3988: RAISE FND_API.g_exc_unexpected_error;
3989: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
3990: RAISE FND_API.g_exc_error;
3991: END IF;
3992: x_new_system_status_code := l_system_status_code;
3993:
3994: -- if waitlisting is successfull....call cancel_reg for old event offer id....
4008: , X_Msg_Count => x_msg_count
4009: , X_Msg_Data => x_msg_data
4010: );
4011:
4012: IF l_return_status = FND_API.g_ret_sts_unexp_error
4013: THEN
4014: RAISE FND_API.g_exc_unexpected_error;
4015: ELSIF l_return_status = FND_API.g_ret_sts_error
4016: THEN
4010: );
4011:
4012: IF l_return_status = FND_API.g_ret_sts_unexp_error
4013: THEN
4014: RAISE FND_API.g_exc_unexpected_error;
4015: ELSIF l_return_status = FND_API.g_ret_sts_error
4016: THEN
4017: RAISE FND_API.g_exc_error;
4018: END IF;
4011:
4012: IF l_return_status = FND_API.g_ret_sts_unexp_error
4013: THEN
4014: RAISE FND_API.g_exc_unexpected_error;
4015: ELSIF l_return_status = FND_API.g_ret_sts_error
4016: THEN
4017: RAISE FND_API.g_exc_error;
4018: END IF;
4019: x_old_system_status_code := 'CANCELLED';
4013: THEN
4014: RAISE FND_API.g_exc_unexpected_error;
4015: ELSIF l_return_status = FND_API.g_ret_sts_error
4016: THEN
4017: RAISE FND_API.g_exc_error;
4018: END IF;
4019: x_old_system_status_code := 'CANCELLED';
4020: end if; -- waitlist available
4021: END IF; -- wailist allowed
4024: END IF; --Reg required flag
4025:
4026:
4027: -- Standard check for p_commit
4028: IF (FND_API.to_Boolean(p_commit))
4029: THEN
4030: COMMIT WORK;
4031: END IF; -- p_commit
4032:
4029: THEN
4030: COMMIT WORK;
4031: END IF; -- p_commit
4032:
4033: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4034: , p_count => x_msg_count
4035: , p_data => x_msg_data
4036: );
4037:
4043:
4044: END IF;
4045:
4046: EXCEPTION
4047: WHEN FND_API.g_exc_error
4048: THEN
4049: ROLLBACK TO transfer_validate_PVT;
4050: x_return_status := FND_API.g_ret_sts_error;
4051: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4046: EXCEPTION
4047: WHEN FND_API.g_exc_error
4048: THEN
4049: ROLLBACK TO transfer_validate_PVT;
4050: x_return_status := FND_API.g_ret_sts_error;
4051: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4052: , p_count => x_msg_count
4053: , p_data => x_msg_data
4054: );
4047: WHEN FND_API.g_exc_error
4048: THEN
4049: ROLLBACK TO transfer_validate_PVT;
4050: x_return_status := FND_API.g_ret_sts_error;
4051: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4052: , p_count => x_msg_count
4053: , p_data => x_msg_data
4054: );
4055:
4052: , p_count => x_msg_count
4053: , p_data => x_msg_data
4054: );
4055:
4056: WHEN FND_API.g_exc_unexpected_error
4057: THEN
4058: ROLLBACK TO transfer_validate_PVT;
4059: x_return_status := FND_API.g_ret_sts_unexp_error ;
4060: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4055:
4056: WHEN FND_API.g_exc_unexpected_error
4057: THEN
4058: ROLLBACK TO transfer_validate_PVT;
4059: x_return_status := FND_API.g_ret_sts_unexp_error ;
4060: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4061: , p_count => x_msg_count
4062: , p_data => x_msg_data
4063: );
4056: WHEN FND_API.g_exc_unexpected_error
4057: THEN
4058: ROLLBACK TO transfer_validate_PVT;
4059: x_return_status := FND_API.g_ret_sts_unexp_error ;
4060: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4061: , p_count => x_msg_count
4062: , p_data => x_msg_data
4063: );
4064:
4064:
4065: WHEN OTHERS
4066: THEN
4067: ROLLBACK TO transfer_validate_PVT;
4068: x_return_status := FND_API.g_ret_sts_unexp_error ;
4069: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4070: THEN
4071: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4072: END IF; -- check_msg_level
4069: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4070: THEN
4071: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4072: END IF; -- check_msg_level
4073: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4074: , p_count => x_msg_count
4075: , p_data => x_msg_data
4076: );
4077:
4097: IS
4098:
4099: BEGIN
4100:
4101: x_return_status := FND_API.g_ret_sts_success;
4102: ------------------------ owner_user_id --------------------------
4103: IF (p_evt_Regs_rec.owner_user_id IS NULL)
4104: THEN
4105: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_OWNER_ID');
4102: ------------------------ owner_user_id --------------------------
4103: IF (p_evt_Regs_rec.owner_user_id IS NULL)
4104: THEN
4105: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_OWNER_ID');
4106: x_return_status := FND_API.g_ret_sts_error;
4107: RETURN;
4108: END IF;
4109:
4110: /* Should user status be mandatory .. it wont be passed from screen, but derived from system status
4115: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_NO_USER_STATUS');
4116: FND_MSG_PUB.add;
4117: END IF;
4118:
4119: x_return_status := FND_API.g_ret_sts_error;
4120: RETURN;
4121: END IF;
4122: */
4123:
4124: ----------------------REG PARTY ID---------------------------------
4125: IF (p_evt_Regs_rec.registrant_party_id IS NULL)
4126: THEN
4127: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_PARTY');
4128: x_return_status := FND_API.g_ret_sts_error;
4129: RETURN;
4130: END IF;
4131:
4132: ------------------------ payment status-Order header/line id --------------------------
4136: THEN
4137: IF (p_evt_Regs_rec.order_header_id IS NULL)
4138: THEN
4139: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_ORDER_HEADER');
4140: x_return_status := FND_API.g_ret_sts_error;
4141: RETURN;
4142: END IF; -- order_header_id
4143: ELSIF (p_evt_Regs_rec.payment_status_code = 'FREE')
4144: THEN
4144: THEN
4145: IF (p_evt_Regs_rec.order_header_id IS NOT NULL)
4146: THEN
4147: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_ORDER_HEADER');
4148: x_return_status := FND_API.g_ret_sts_error;
4149: RETURN;
4150: END IF; -- order_header_id
4151: END IF; -- payment_status_code
4152: END IF; -- payment_status_code is not null
4156: AND (p_evt_Regs_rec.order_header_id IS NULL)
4157: )
4158: THEN
4159: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_ORDER_HEADER');
4160: x_return_status := FND_API.g_ret_sts_error;
4161: RETURN;
4162: END IF; -- order_line_id/order_header_id
4163:
4164: ------------------------ Order header/line id-Account needed------------------
4170: AND (p_evt_regs_rec.attendant_account_id IS NULL)
4171: )
4172: THEN
4173: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_ACCT_FOR_ORDER');
4174: x_return_status := FND_API.g_ret_sts_error;
4175: RETURN;
4176: END IF; -- registrant_account_id/attendant_account_id
4177: END IF; -- order_line_id/order_header_id
4178:
4179: -----------------------REG CONTACT ID-----------------------------------
4180: IF (p_evt_Regs_rec.registrant_contact_id IS NULL)
4181: THEN
4182: AMS_Utility_PVT.error_message('AMS_EVT_REG_NO_CONTACT_ID');
4183: x_return_status := FND_API.g_ret_sts_error;
4184: RETURN;
4185: END IF; -- registrant_contact_id
4186:
4187: END check_evtRegs_req_items;
4207:
4208: BEGIN
4209:
4210: -- check reg id, conf code only for create mode
4211: x_return_status := FND_API.g_ret_sts_success;
4212:
4213: IF ( (p_validation_mode = JTF_PLSQL_API.g_create)
4214: AND (p_event_registration_id IS NOT NULL)
4215: )
4215: )
4216: THEN
4217: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'
4218: , 'event_registration_id = ' || p_event_registration_id
4219: ) = FND_API.g_false
4220: )
4221: THEN
4222: AMS_Utility_PVT.error_message('AMS_EVT_REG_DUPLICATE_ID');
4223: x_return_status := FND_API.g_ret_sts_error;
4219: ) = FND_API.g_false
4220: )
4221: THEN
4222: AMS_Utility_PVT.error_message('AMS_EVT_REG_DUPLICATE_ID');
4223: x_return_status := FND_API.g_ret_sts_error;
4224: RETURN;
4225: END IF; -- check_uniqueness
4226: END IF; -- p_event_registration_id
4227:
4231: THEN
4232: /* bug#1490374 commented OUT NOCOPY this piece
4233: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'
4234: , 'confirmation_code = ''' || p_confirmation_code || ''''
4235: ) = FND_API.g_false
4236: )
4237: */
4238: open c_conf_code(p_confirmation_code);
4239: fetch c_conf_code
4241: close c_conf_code;
4242: IF (l_dummy <> 1)
4243: THEN
4244: AMS_Utility_PVT.error_message('AMS_EVT_REG_DUPLICATE_CODE');
4245: x_return_status := FND_API.g_ret_sts_error;
4246: RETURN;
4247: END IF; -- l_dummy
4248: END IF; -- p_confirmation_code
4249:
4260:
4261: BEGIN
4262:
4263: ------------------- EVENT OFFER ID ----------------
4264: IF (p_evt_regs_rec.event_offer_id <> FND_API.g_miss_num)
4265: THEN
4266: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
4267: , 'event_offer_id'
4268: , p_evt_regs_rec.event_offer_id
4265: THEN
4266: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
4267: , 'event_offer_id'
4268: , p_evt_regs_rec.event_offer_id
4269: ) = FND_API.g_false
4270: )
4271: THEN
4272: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_EVENT_OFFER_ID');
4273: x_return_status := FND_API.g_ret_sts_error;
4269: ) = FND_API.g_false
4270: )
4271: THEN
4272: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_EVENT_OFFER_ID');
4273: x_return_status := FND_API.g_ret_sts_error;
4274: RETURN;
4275: END IF; -- check_fk_exists
4276: END IF; -- event_offer_id
4277:
4275: END IF; -- check_fk_exists
4276: END IF; -- event_offer_id
4277:
4278: ------------APPLICATION ID---------------------
4279: IF (p_evt_regs_rec.application_id <> FND_API.g_miss_num)
4280: THEN
4281: IF (AMS_Utility_PVT.check_fk_exists( 'fnd_application'
4282: , 'application_id'
4283: , p_evt_regs_rec.application_id
4280: THEN
4281: IF (AMS_Utility_PVT.check_fk_exists( 'fnd_application'
4282: , 'application_id'
4283: , p_evt_regs_rec.application_id
4284: ) = FND_API.g_false
4285: )
4286: THEN
4287: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_APPLICATION_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_APPLICATION_ID');
4288: x_return_status := FND_API.g_ret_sts_error;
4289: RETURN;
4290: END IF; -- check_fk_exists
4291: END IF; -- application_id
4292:
4290: END IF; -- check_fk_exists
4291: END IF; -- application_id
4292:
4293: --------------user status id------------------------
4294: IF (p_evt_regs_rec.user_status_id <> FND_API.g_miss_num)
4295: THEN
4296: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4297: , 'user_status_id'
4298: , p_evt_regs_rec.user_status_id
4295: THEN
4296: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4297: , 'user_status_id'
4298: , p_evt_regs_rec.user_status_id
4299: ) = FND_API.g_false
4300: )
4301: THEN
4302: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_USER_STATUS_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_USER_STATUS_ID');
4303: x_return_status := FND_API.g_ret_sts_error;
4304: RETURN;
4305: END IF; -- check_fk_exists
4306: END IF; -- user_status_id
4307:
4305: END IF; -- check_fk_exists
4306: END IF; -- user_status_id
4307:
4308: --------------------------SOURCE CODE-------------------
4309: IF p_evt_regs_rec.source_code <> FND_API.g_miss_char THEN
4310: IF (AMS_Utility_PVT.check_fk_exists( 'ams_source_codes'
4311: , 'source_code'
4312: , p_evt_regs_rec.source_code
4313: , AMS_Utility_PVT.g_varchar2
4310: IF (AMS_Utility_PVT.check_fk_exists( 'ams_source_codes'
4311: , 'source_code'
4312: , p_evt_regs_rec.source_code
4313: , AMS_Utility_PVT.g_varchar2
4314: ) = FND_API.g_false
4315: )
4316: THEN
4317: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_SOURCE_CODE');
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_SOURCE_CODE');
4318: x_return_status := FND_API.g_ret_sts_error;
4319: RETURN;
4320: END IF; -- check_fk_exists
4321: END IF; -- source_code
4322:
4320: END IF; -- check_fk_exists
4321: END IF; -- source_code
4322:
4323: --------------- attendant language-----------------------
4324: IF (p_evt_regs_rec.attendant_language <> FND_API.g_miss_char)
4325: THEN
4326: IF (AMS_Utility_PVT.check_fk_exists( 'fnd_languages'
4327: , 'language_code'
4328: , p_evt_regs_rec.attendant_language
4326: IF (AMS_Utility_PVT.check_fk_exists( 'fnd_languages'
4327: , 'language_code'
4328: , p_evt_regs_rec.attendant_language
4329: , AMS_Utility_PVT.g_varchar2
4330: ) = FND_API.g_false
4331: )
4332: THEN
4333: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_LANGUAGE');
4334: x_return_status := FND_API.g_ret_sts_error;
4330: ) = FND_API.g_false
4331: )
4332: THEN
4333: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_LANGUAGE');
4334: x_return_status := FND_API.g_ret_sts_error;
4335: RETURN;
4336: END IF; -- check_fk_exists
4337: END IF; -- attendant_language
4338:
4336: END IF; -- check_fk_exists
4337: END IF; -- attendant_language
4338:
4339: ---------------------TARGET LIST ID------------------
4340: IF (p_evt_regs_rec.target_list_id <> FND_API.g_miss_num)
4341: THEN
4342: IF (AMS_Utility_PVT.check_fk_exists( 'ams_list_headers_all'
4343: , 'list_header_id'
4344: , p_evt_regs_rec.target_list_id
4341: THEN
4342: IF (AMS_Utility_PVT.check_fk_exists( 'ams_list_headers_all'
4343: , 'list_header_id'
4344: , p_evt_regs_rec.target_list_id
4345: ) = FND_API.g_false
4346: )
4347: THEN
4348: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_TARGET_LIST_ID');
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_TARGET_LIST_ID');
4349: x_return_status := FND_API.g_ret_sts_error;
4350: RETURN;
4351: END IF; -- check_fk_exists
4352: END IF; -- target_list_id
4353:
4351: END IF; -- check_fk_exists
4352: END IF; -- target_list_id
4353:
4354: ---------------------SYSTEM STATUS CODE--------------------
4355: IF (p_evt_regs_rec.system_status_code <> FND_API.g_miss_char)
4356: THEN
4357: IF (p_validation_mode = JTF_PLSQL_API.g_create)
4358: THEN
4359: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4359: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4360: , 'system_status_code'
4361: , p_evt_regs_rec.system_status_code
4362: , AMS_Utility_PVT.g_varchar2
4363: ) = FND_API.g_false
4364: )
4365: THEN
4366: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_SYS_STATUS');
4367: x_return_status := FND_API.g_ret_sts_error;
4363: ) = FND_API.g_false
4364: )
4365: THEN
4366: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_SYS_STATUS');
4367: x_return_status := FND_API.g_ret_sts_error;
4368: RETURN;
4369: END IF; -- check_fk_exists
4370: ELSE
4371: -- will have to validate system status rules against ams_status_order_rules
4392: IS
4393:
4394: BEGIN
4395:
4396: x_return_status := FND_API.g_ret_sts_success;
4397: ----------------------- registration_source_type--------------
4398: IF (p_evt_regs_rec.reg_source_type_code <> FND_API.g_miss_char)
4399: THEN
4400: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_REG_SOURCE'
4394: BEGIN
4395:
4396: x_return_status := FND_API.g_ret_sts_success;
4397: ----------------------- registration_source_type--------------
4398: IF (p_evt_regs_rec.reg_source_type_code <> FND_API.g_miss_char)
4399: THEN
4400: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_REG_SOURCE'
4401: , p_lookup_code => p_evt_regs_rec.reg_source_type_code
4402: ) = FND_API.g_false
4398: IF (p_evt_regs_rec.reg_source_type_code <> FND_API.g_miss_char)
4399: THEN
4400: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_REG_SOURCE'
4401: , p_lookup_code => p_evt_regs_rec.reg_source_type_code
4402: ) = FND_API.g_false
4403: )
4404: THEN
4405: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_SOURCE_TYPE');
4406: x_return_status := FND_API.g_ret_sts_error;
4402: ) = FND_API.g_false
4403: )
4404: THEN
4405: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_SOURCE_TYPE');
4406: x_return_status := FND_API.g_ret_sts_error;
4407: RETURN;
4408: END IF; -- check_lookup_exists
4409: END IF; -- reg_source_type_code
4410:
4408: END IF; -- check_lookup_exists
4409: END IF; -- reg_source_type_code
4410:
4411: -----------------------PAYMENT STATUS_CODE--------------
4412: IF (p_evt_regs_rec.payment_status_code <> FND_API.g_miss_char)
4413: THEN
4414: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_PAYMENT_STATUS'
4415: , p_lookup_code => p_evt_regs_rec.payment_status_code
4416: ) = FND_API.g_false
4412: IF (p_evt_regs_rec.payment_status_code <> FND_API.g_miss_char)
4413: THEN
4414: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_PAYMENT_STATUS'
4415: , p_lookup_code => p_evt_regs_rec.payment_status_code
4416: ) = FND_API.g_false
4417: )
4418: THEN
4419: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_PAY_STAT');
4420: x_return_status := FND_API.g_ret_sts_error;
4416: ) = FND_API.g_false
4417: )
4418: THEN
4419: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_PAY_STAT');
4420: x_return_status := FND_API.g_ret_sts_error;
4421: RETURN;
4422: END IF; -- check_lookup_exists
4423: END IF; -- payment_status_code
4424:
4422: END IF; -- check_lookup_exists
4423: END IF; -- payment_status_code
4424:
4425: ------------------------CANCELLATION REASON CODE-------------------
4426: IF (p_evt_regs_rec.cancellation_reason_code <> FND_API.g_miss_char)
4427: THEN
4428: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_CANCEL_REASON_CODE'
4429: , p_lookup_code => p_evt_regs_rec.cancellation_reason_code
4430: ) = FND_API.g_false
4426: IF (p_evt_regs_rec.cancellation_reason_code <> FND_API.g_miss_char)
4427: THEN
4428: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_CANCEL_REASON_CODE'
4429: , p_lookup_code => p_evt_regs_rec.cancellation_reason_code
4430: ) = FND_API.g_false
4431: )
4432: THEN
4433: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_CANCEL_REASON');
4434: x_return_status := FND_API.g_ret_sts_error;
4430: ) = FND_API.g_false
4431: )
4432: THEN
4433: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_CANCEL_REASON');
4434: x_return_status := FND_API.g_ret_sts_error;
4435: RETURN;
4436: END IF; -- check_lookup_exists
4437: END IF; -- cancellation_reason_code
4438:
4436: END IF; -- check_lookup_exists
4437: END IF; -- cancellation_reason_code
4438:
4439: ------------------------ATTENDANCE FAILURE REASON-------------------
4440: IF (p_evt_regs_rec.attendance_failure_reason <> FND_API.g_miss_char)
4441: THEN
4442: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_ATTENDANCE_FAILURE'
4443: , p_lookup_code => p_evt_regs_rec.attendance_failure_reason
4444: ) = FND_API.g_false
4440: IF (p_evt_regs_rec.attendance_failure_reason <> FND_API.g_miss_char)
4441: THEN
4442: IF (AMS_Utility_PVT.check_lookup_exists( p_lookup_type => 'AMS_EVENT_ATTENDANCE_FAILURE'
4443: , p_lookup_code => p_evt_regs_rec.attendance_failure_reason
4444: ) = FND_API.g_false
4445: )
4446: THEN
4447: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_ATTEN_FAILURE');
4448: x_return_status := FND_API.g_ret_sts_error;
4444: ) = FND_API.g_false
4445: )
4446: THEN
4447: AMS_Utility_PVT.error_message('AMS_EVT_REG_BAD_ATTEN_FAILURE');
4448: x_return_status := FND_API.g_ret_sts_error;
4449: RETURN;
4450: END IF; -- check_lookup_exists
4451: END IF; -- attendance_failure_reason
4452:
4484: END IF;
4485: check_evtRegs_req_items( p_evt_Regs_rec => p_evt_Regs_rec
4486: , x_return_status => x_return_status
4487: );
4488: IF (x_return_status <> FND_API.g_ret_sts_success)
4489: THEN
4490: RETURN;
4491: END IF;
4492:
4501: , p_event_registration_id => p_evt_Regs_rec.event_registration_id
4502: , x_return_status => x_return_status
4503: , p_validation_mode => p_validation_mode
4504: );
4505: IF (x_return_status <> FND_API.g_ret_sts_success)
4506: THEN
4507: RETURN;
4508: END IF;
4509:
4517: check_evtRegs_fk_items( p_evt_Regs_rec => p_evt_Regs_rec
4518: , x_return_status => x_return_status
4519: , p_validation_mode => p_validation_mode
4520: );
4521: IF (x_return_status <> FND_API.g_ret_sts_success)
4522: THEN
4523: RETURN;
4524: END IF;
4525:
4532: END IF;
4533: check_evtRegs_lookup_items( p_evt_Regs_rec => p_evt_Regs_rec
4534: , x_return_status => x_return_status
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_flag_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:
4611: temp_attendant_contact_id,
4612: temp_event_offer_id;
4613: IF (chkexists%NOTFOUND)
4614: THEN
4615: x_return_status := FND_API.g_ret_sts_success;
4616: ELSE
4617: IF (AMS_DEBUG_HIGH_ON) THEN
4618:
4619: AMS_Utility_PVT.debug_message('This record already exists');
4618:
4619: AMS_Utility_PVT.debug_message('This record already exists');
4620: END IF;
4621: AMS_Utility_PVT.error_message('AMS_EVENT_REGISTRANT_EXISTS');
4622: x_return_status := FND_API.g_ret_sts_error;
4623: END IF;
4624: CLOSE chkexists;
4625:
4626: END CHECK_EVTREGS_RECORD;
4625:
4626: END CHECK_EVTREGS_RECORD;
4627:
4628: PROCEDURE Validate_evtregs( p_api_version_number IN NUMBER
4629: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
4630: , p_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
4631: , p_evt_regs_Rec IN evt_regs_Rec_Type
4632: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
4633: , X_Return_Status OUT NOCOPY VARCHAR2
4626: END CHECK_EVTREGS_RECORD;
4627:
4628: PROCEDURE Validate_evtregs( p_api_version_number IN NUMBER
4629: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
4630: , p_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
4631: , p_evt_regs_Rec IN evt_regs_Rec_Type
4632: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
4633: , X_Return_Status OUT NOCOPY VARCHAR2
4634: , X_Msg_Count OUT NOCOPY NUMBER
4650:
4651: AMS_Utility_PVT.debug_message(l_full_name||': start');
4652: END IF;
4653:
4654: IF (FND_API.to_boolean(p_init_msg_list))
4655: THEN
4656: FND_MSG_PUB.initialize;
4657: END IF; -- p_init_msg_list
4658:
4655: THEN
4656: FND_MSG_PUB.initialize;
4657: END IF; -- p_init_msg_list
4658:
4659: IF (NOT FND_API.compatible_api_call( l_api_version_number
4660: , p_api_version_number
4661: , l_api_name
4662: , g_pkg_name
4663: )
4662: , g_pkg_name
4663: )
4664: )
4665: THEN
4666: RAISE FND_API.g_exc_unexpected_error;
4667: END IF; -- compatible API call
4668:
4669: x_return_status := FND_API.g_ret_sts_success;
4670:
4665: THEN
4666: RAISE FND_API.g_exc_unexpected_error;
4667: END IF; -- compatible API call
4668:
4669: x_return_status := FND_API.g_ret_sts_success;
4670:
4671: ---------------------- validate ------------------------
4672:
4673: IF (AMS_DEBUG_HIGH_ON) THEN
4683: , p_validation_mode => p_validation_mode
4684: , x_return_status => l_return_status
4685: );
4686:
4687: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4688: THEN
4689: RAISE FND_API.g_exc_unexpected_error;
4690: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4691: THEN
4685: );
4686:
4687: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4688: THEN
4689: RAISE FND_API.g_exc_unexpected_error;
4690: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4691: THEN
4692: RAISE FND_API.g_exc_error;
4693: END IF; -- l_return_status
4686:
4687: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4688: THEN
4689: RAISE FND_API.g_exc_unexpected_error;
4690: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4691: THEN
4692: RAISE FND_API.g_exc_error;
4693: END IF; -- l_return_status
4694: END IF; -- p_validation_level
4688: THEN
4689: RAISE FND_API.g_exc_unexpected_error;
4690: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4691: THEN
4692: RAISE FND_API.g_exc_error;
4693: END IF; -- l_return_status
4694: END IF; -- p_validation_level
4695:
4696: /*
4703: THEN
4704: check_evtRegs_record( P_evt_regs_Rec => l_evt_regs_Rec
4705: , x_return_status => l_return_status
4706: );
4707: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4708: THEN
4709: RAISE FND_API.g_exc_unexpected_error;
4710: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4711: THEN
4705: , x_return_status => l_return_status
4706: );
4707: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4708: THEN
4709: RAISE FND_API.g_exc_unexpected_error;
4710: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4711: THEN
4712: RAISE FND_API.g_exc_error;
4713: END IF; -- l_return_status
4706: );
4707: IF (l_return_status = FND_API.g_ret_sts_unexp_error)
4708: THEN
4709: RAISE FND_API.g_exc_unexpected_error;
4710: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4711: THEN
4712: RAISE FND_API.g_exc_error;
4713: END IF; -- l_return_status
4714: END IF; -- p_validation_level
4708: THEN
4709: RAISE FND_API.g_exc_unexpected_error;
4710: ELSIF (l_return_status = FND_API.g_ret_sts_error)
4711: THEN
4712: RAISE FND_API.g_exc_error;
4713: END IF; -- l_return_status
4714: END IF; -- p_validation_level
4715:
4716: -------------------- finish --------------------------
4713: END IF; -- l_return_status
4714: END IF; -- p_validation_level
4715:
4716: -------------------- finish --------------------------
4717: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
4718: , p_count => x_msg_count,
4719: , p_data => x_msg_data
4720: );
4721: */
4725: END IF;
4726:
4727: EXCEPTION
4728:
4729: WHEN FND_API.g_exc_error
4730: THEN
4731: x_return_status := FND_API.g_ret_sts_error;
4732: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4733: , p_count => x_msg_count
4727: EXCEPTION
4728:
4729: WHEN FND_API.g_exc_error
4730: THEN
4731: x_return_status := FND_API.g_ret_sts_error;
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: );
4728:
4729: WHEN FND_API.g_exc_error
4730: THEN
4731: x_return_status := FND_API.g_ret_sts_error;
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:
4733: , p_count => x_msg_count
4734: , p_data => x_msg_data
4735: );
4736:
4737: WHEN FND_API.g_exc_unexpected_error
4738: THEN
4739: x_return_status := FND_API.g_ret_sts_unexp_error;
4740: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4741: , p_count => x_msg_count
4735: );
4736:
4737: WHEN FND_API.g_exc_unexpected_error
4738: THEN
4739: x_return_status := FND_API.g_ret_sts_unexp_error;
4740: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4741: , p_count => x_msg_count
4742: , p_data => x_msg_data
4743: );
4736:
4737: WHEN FND_API.g_exc_unexpected_error
4738: THEN
4739: x_return_status := FND_API.g_ret_sts_unexp_error;
4740: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4741: , p_count => x_msg_count
4742: , p_data => x_msg_data
4743: );
4744:
4743: );
4744:
4745: WHEN OTHERS
4746: THEN
4747: x_return_status := FND_API.g_ret_sts_unexp_error;
4748: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4749: THEN
4750: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4751: END IF; -- check_msg_level
4748: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4749: THEN
4750: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4751: END IF; -- check_msg_level
4752: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4753: , p_count => x_msg_count
4754: , p_data => x_msg_data
4755: );
4756:
4768: IS
4769:
4770: BEGIN
4771:
4772: x_evt_regs_rec.EVENT_REGISTRATION_ID := FND_API.g_miss_num;
4773: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4774: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4775: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4776: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4769:
4770: BEGIN
4771:
4772: x_evt_regs_rec.EVENT_REGISTRATION_ID := FND_API.g_miss_num;
4773: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4774: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4775: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4776: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4777: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4770: BEGIN
4771:
4772: x_evt_regs_rec.EVENT_REGISTRATION_ID := FND_API.g_miss_num;
4773: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4774: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4775: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4776: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4777: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4778: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4771:
4772: x_evt_regs_rec.EVENT_REGISTRATION_ID := FND_API.g_miss_num;
4773: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4774: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4775: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4776: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4777: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4778: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4779: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4772: x_evt_regs_rec.EVENT_REGISTRATION_ID := FND_API.g_miss_num;
4773: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4774: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4775: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4776: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4777: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4778: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4779: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4780: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4773: x_evt_regs_rec.last_update_date := FND_API.g_miss_date;
4774: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4775: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4776: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4777: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4778: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4779: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4780: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4781: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4774: x_evt_regs_rec.last_updated_by := FND_API.g_miss_num;
4775: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4776: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4777: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4778: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4779: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4780: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4781: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4782: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4775: x_evt_regs_rec.creation_date := FND_API.g_miss_date;
4776: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4777: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4778: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4779: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4780: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4781: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4782: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4783: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4776: x_evt_regs_rec.created_by := FND_API.g_miss_num;
4777: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4778: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4779: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4780: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4781: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4782: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4783: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4784: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4777: x_evt_regs_rec.last_update_login := FND_API.g_miss_num;
4778: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4779: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4780: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4781: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4782: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4783: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4784: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4785: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4778: x_evt_regs_rec.object_version_number := FND_API.g_miss_num;
4779: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4780: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4781: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4782: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4783: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4784: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4785: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4786: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4779: x_evt_regs_rec.EVENT_OFFER_ID := FND_API.g_miss_num;
4780: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4781: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4782: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4783: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4784: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4785: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4786: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4787: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4780: x_evt_regs_rec.application_id := FND_API.g_miss_num;
4781: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4782: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4783: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4784: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4785: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4786: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4787: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4788: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4781: x_evt_regs_rec.ACTIVE_FLAG := FND_API.g_miss_char;
4782: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4783: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4784: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4785: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4786: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4787: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4788: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4789: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4782: x_evt_regs_rec.OWNER_USER_ID := FND_API.g_miss_num;
4783: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4784: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4785: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4786: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4787: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4788: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4789: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4790: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4783: x_evt_regs_rec.SYSTEM_STATUS_CODE := FND_API.g_miss_char;
4784: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4785: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4786: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4787: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4788: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4789: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4790: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4791: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4784: x_evt_regs_rec.DATE_REGISTRATION_PLACED := FND_API.g_miss_date;
4785: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4786: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4787: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4788: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4789: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4790: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4791: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4792: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4785: x_evt_regs_rec.USER_STATUS_ID := FND_API.g_miss_num;
4786: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4787: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4788: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4789: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4790: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4791: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4792: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4793: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4786: x_evt_regs_rec.LAST_REG_STATUS_DATE := FND_API.g_miss_date;
4787: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4788: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4789: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4790: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4791: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4792: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4793: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4794: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4787: x_evt_regs_rec.REG_SOURCE_TYPE_CODE := FND_API.g_miss_char;
4788: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4789: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4790: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4791: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4792: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4793: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4794: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4788: x_evt_regs_rec.REGISTRATION_SOURCE_ID := FND_API.g_miss_num;
4789: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4790: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4791: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4792: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4793: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4794: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4796: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4789: x_evt_regs_rec.CONFIRMATION_CODE := FND_API.g_miss_char;
4790: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4791: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4792: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4793: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4794: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4796: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4797: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4790: x_evt_regs_rec.SOURCE_CODE := FND_API.g_miss_char;
4791: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4792: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4793: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4794: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4796: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4797: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4791: x_evt_regs_rec.REGISTRATION_GROUP_ID := FND_API.g_miss_num;
4792: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4793: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4794: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4796: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4797: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4799: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4792: x_evt_regs_rec.REGISTRANT_PARTY_ID := FND_API.g_miss_num;
4793: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4794: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4796: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4797: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4799: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4800: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4793: x_evt_regs_rec.REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4794: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4796: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4797: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4799: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4800: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4801: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4794: x_evt_regs_rec.REGISTRANT_ACCOUNT_ID := FND_API.g_miss_num;
4795: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4796: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4797: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4799: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4800: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4801: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4802: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4795: x_evt_regs_rec.ATTENDANT_PARTY_ID := FND_API.g_miss_num;
4796: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4797: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4799: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4800: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4801: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4802: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4803: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4796: x_evt_regs_rec.ATTENDANT_CONTACT_ID := FND_API.g_miss_num;
4797: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4799: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4800: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4801: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4802: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4803: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4804: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4797: x_evt_regs_rec.ATTENDANT_ACCOUNT_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4799: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4800: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4801: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4802: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4803: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4804: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4805: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4798: x_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID := FND_API.g_miss_num;
4799: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4800: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4801: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4802: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4803: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4804: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4805: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4806: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4799: x_evt_regs_rec.PROSPECT_FLAG := FND_API.g_miss_char;
4800: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4801: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4802: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4803: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4804: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4805: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4806: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4807: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4800: x_evt_regs_rec.ATTENDED_FLAG := FND_API.g_miss_char;
4801: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4802: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4803: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4804: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4805: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4806: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4807: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4808: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4801: x_evt_regs_rec.CONFIRMED_FLAG := FND_API.g_miss_char;
4802: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4803: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4804: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4805: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4806: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4807: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4808: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4809: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4802: x_evt_regs_rec.EVALUATED_FLAG := FND_API.g_miss_char;
4803: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4804: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4805: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4806: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4807: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4808: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4809: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4810: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4803: x_evt_regs_rec.ATTENDANCE_RESULT_CODE := FND_API.g_miss_char;
4804: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4805: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4806: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4807: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4808: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4809: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4810: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4811: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4804: x_evt_regs_rec.WAITLISTED_PRIORITY := FND_API.g_miss_num;
4805: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4806: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4807: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4808: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4809: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4810: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4811: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4812: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4805: x_evt_regs_rec.TARGET_LIST_ID := FND_API.g_miss_num;
4806: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4807: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4808: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4809: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4810: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4811: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4812: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4813: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4806: x_evt_regs_rec.INBOUND_MEDIA_ID := fnd_api.g_miss_num;
4807: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4808: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4809: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4810: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4811: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4812: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4813: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4814: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4807: x_evt_regs_rec.INBOUND_CHANNEL_ID := fnd_api.g_miss_num;
4808: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4809: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4810: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4811: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4812: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4813: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4814: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4815: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4808: x_evt_regs_rec.CANCELLATION_CODE := fnd_api.g_miss_char;
4809: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4810: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4811: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4812: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4813: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4814: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4815: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4816: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4809: x_evt_regs_rec.CANCELLATION_REASON_CODE := fnd_api.g_miss_char;
4810: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4811: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4812: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4813: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4814: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4815: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4816: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4817: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4810: x_evt_regs_rec.ATTENDANCE_FAILURE_REASON := fnd_api.g_miss_char;
4811: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4812: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4813: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4814: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4815: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4816: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4817: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4818: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4811: x_evt_regs_rec.ATTENDANT_LANGUAGE := fnd_api.g_miss_char;
4812: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4813: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4814: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4815: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4816: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4817: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4818: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4819: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4812: x_evt_regs_rec.SALESREP_ID := fnd_api.g_miss_num;
4813: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4814: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4815: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4816: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4817: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4818: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4819: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4820: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4813: x_evt_regs_rec.ORDER_HEADER_ID := fnd_api.g_miss_num;
4814: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4815: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4816: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4817: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4818: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4819: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4820: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4821: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4814: x_evt_regs_rec.ORDER_LINE_ID := fnd_api.g_miss_num;
4815: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4816: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4817: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4818: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4819: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4820: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4821: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4822: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4815: x_evt_regs_rec.DESCRIPTION := fnd_api.g_miss_char;
4816: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4817: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4818: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4819: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4820: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4821: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4822: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4823: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4816: x_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG := fnd_api.g_miss_char;
4817: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4818: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4819: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4820: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4821: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4822: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4823: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4824: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4817: x_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG := fnd_api.g_miss_char;
4818: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4819: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4820: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4821: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4822: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4823: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4824: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4825: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4818: x_evt_regs_rec.PAYMENT_STATUS_CODE := fnd_api.g_miss_char;
4819: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4820: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4821: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4822: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4823: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4824: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4825: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4826: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4819: x_evt_regs_rec.AUTO_REGISTER_FLAG := fnd_api.g_miss_char;
4820: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4821: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4822: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4823: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4824: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4825: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4826: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4827: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4820: x_evt_regs_rec.attribute_category := FND_API.g_miss_char;
4821: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4822: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4823: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4824: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4825: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4826: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4827: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4828: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4821: x_evt_regs_rec.attribute1 := FND_API.g_miss_char;
4822: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4823: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4824: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4825: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4826: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4827: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4828: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4829: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4822: x_evt_regs_rec.attribute2 := FND_API.g_miss_char;
4823: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4824: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4825: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4826: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4827: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4828: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4829: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4830: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4823: x_evt_regs_rec.attribute3 := FND_API.g_miss_char;
4824: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4825: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4826: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4827: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4828: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4829: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4830: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4831: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4824: x_evt_regs_rec.attribute4 := FND_API.g_miss_char;
4825: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4826: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4827: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4828: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4829: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4830: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4831: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4832: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4825: x_evt_regs_rec.attribute5 := FND_API.g_miss_char;
4826: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4827: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4828: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4829: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4830: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4831: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4832: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4833: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4826: x_evt_regs_rec.attribute6 := FND_API.g_miss_char;
4827: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4828: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4829: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4830: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4831: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4832: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4833: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4834: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4827: x_evt_regs_rec.attribute7 := FND_API.g_miss_char;
4828: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4829: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4830: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4831: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4832: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4833: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4834: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4835: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4828: x_evt_regs_rec.attribute8 := FND_API.g_miss_char;
4829: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4830: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4831: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4832: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4833: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4834: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4835: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4836: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4829: x_evt_regs_rec.attribute9 := FND_API.g_miss_char;
4830: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4831: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4832: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4833: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4834: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4835: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4836: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4837: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4830: x_evt_regs_rec.attribute10 := FND_API.g_miss_char;
4831: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4832: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4833: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4834: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4835: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4836: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4837: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4838: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4831: x_evt_regs_rec.attribute11 := FND_API.g_miss_char;
4832: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4833: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4834: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4835: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4836: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4837: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4838: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4839: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4832: x_evt_regs_rec.attribute12 := FND_API.g_miss_char;
4833: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4834: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4835: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4836: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4837: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4838: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4839: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4840: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4833: x_evt_regs_rec.attribute13 := FND_API.g_miss_char;
4834: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4835: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4836: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4837: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4838: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4839: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4840: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4841: x_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE := FND_API.g_miss_char; --Hornet : added for imeeting integration
4834: x_evt_regs_rec.attribute14 := FND_API.g_miss_char;
4835: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4836: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4837: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4838: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4839: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4840: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4841: x_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE := FND_API.g_miss_char; --Hornet : added for imeeting integration
4842:
4835: x_evt_regs_rec.attribute15 := FND_API.g_miss_char;
4836: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4837: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4838: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4839: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4840: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4841: x_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE := FND_API.g_miss_char; --Hornet : added for imeeting integration
4842:
4843: END init_evtregs_rec;
4836: x_evt_regs_rec.attendee_role_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4837: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4838: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4839: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4840: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4841: x_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE := FND_API.g_miss_char; --Hornet : added for imeeting integration
4842:
4843: END init_evtregs_rec;
4844:
4837: x_evt_regs_rec.notification_type := FND_API.g_miss_char; -- Hornet : added for imeeting integration
4838: x_evt_regs_rec.last_notified_time := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4839: x_evt_regs_rec.EVENT_JOIN_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4840: x_evt_regs_rec.EVENT_EXIT_TIME := FND_API.g_miss_date; -- Hornet : added for imeeting integration
4841: x_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE := FND_API.g_miss_char; --Hornet : added for imeeting integration
4842:
4843: END init_evtregs_rec;
4844:
4845: --------------complete evtregs rec for update-------------------------
4874: IF (c_reg%NOTFOUND)
4875: THEN
4876: CLOSE c_reg;
4877: AMS_UTILITY_PVT.error_message('AMS_API_RECORD_NOT_FOUND');
4878: -- RAISE FND_API.g_exc_error;
4879: END IF; -- c_reg%NOTFOUND
4880: CLOSE c_reg;
4881:
4882: -- This procedure should complete the record by going through all the items in the incoming record.
4879: END IF; -- c_reg%NOTFOUND
4880: CLOSE c_reg;
4881:
4882: -- This procedure should complete the record by going through all the items in the incoming record.
4883: IF (p_evt_regs_rec.EVENT_OFFER_ID = FND_API.g_miss_num)
4884: THEN
4885: x_complete_rec.EVENT_OFFER_ID := l_reg_rec.EVENT_OFFER_ID;
4886: END IF; -- EVENT_OFFER_ID
4887:
4884: THEN
4885: x_complete_rec.EVENT_OFFER_ID := l_reg_rec.EVENT_OFFER_ID;
4886: END IF; -- EVENT_OFFER_ID
4887:
4888: IF (p_evt_regs_rec.APPLICATION_ID = FND_API.g_miss_num)
4889: THEN
4890: x_complete_rec.APPLICATION_ID := l_reg_rec.APPLICATION_ID;
4891: END IF; -- APPLICATION_ID
4892:
4889: THEN
4890: x_complete_rec.APPLICATION_ID := l_reg_rec.APPLICATION_ID;
4891: END IF; -- APPLICATION_ID
4892:
4893: IF (p_evt_regs_rec.ACTIVE_FLAG = FND_API.g_miss_char)
4894: THEN
4895: x_complete_rec.ACTIVE_FLAG := l_reg_rec.ACTIVE_FLAG;
4896: END IF; -- ACTIVE_FLAG
4897:
4894: THEN
4895: x_complete_rec.ACTIVE_FLAG := l_reg_rec.ACTIVE_FLAG;
4896: END IF; -- ACTIVE_FLAG
4897:
4898: IF (p_evt_regs_rec.OWNER_USER_ID = FND_API.g_miss_num)
4899: THEN
4900: x_complete_rec.OWNER_USER_ID := l_reg_rec.OWNER_USER_ID;
4901: END IF; -- OWNER_USER_ID
4902:
4899: THEN
4900: x_complete_rec.OWNER_USER_ID := l_reg_rec.OWNER_USER_ID;
4901: END IF; -- OWNER_USER_ID
4902:
4903: IF (p_evt_regs_rec.SYSTEM_STATUS_CODE = FND_API.g_miss_char)
4904: THEN
4905: x_complete_rec.SYSTEM_STATUS_CODE := l_reg_rec.SYSTEM_STATUS_CODE;
4906: END IF; -- SYSTEM_STATUS_CODE
4907:
4904: THEN
4905: x_complete_rec.SYSTEM_STATUS_CODE := l_reg_rec.SYSTEM_STATUS_CODE;
4906: END IF; -- SYSTEM_STATUS_CODE
4907:
4908: IF (p_evt_regs_rec.DATE_REGISTRATION_PLACED = FND_API.g_miss_date)
4909: THEN
4910: x_complete_rec.DATE_REGISTRATION_PLACED := l_reg_rec.DATE_REGISTRATION_PLACED;
4911: END IF; -- DATE_REGISTRATION_PLACED
4912:
4909: THEN
4910: x_complete_rec.DATE_REGISTRATION_PLACED := l_reg_rec.DATE_REGISTRATION_PLACED;
4911: END IF; -- DATE_REGISTRATION_PLACED
4912:
4913: IF (p_evt_regs_rec.USER_STATUS_ID = FND_API.g_miss_num)
4914: THEN
4915: x_complete_rec.USER_STATUS_ID := l_reg_rec.USER_STATUS_ID;
4916: END IF; -- USER_STATUS_ID
4917:
4914: THEN
4915: x_complete_rec.USER_STATUS_ID := l_reg_rec.USER_STATUS_ID;
4916: END IF; -- USER_STATUS_ID
4917:
4918: IF (p_evt_regs_rec.LAST_REG_STATUS_DATE = FND_API.g_miss_date)
4919: THEN
4920: x_complete_rec.LAST_REG_STATUS_DATE := l_reg_rec.LAST_REG_STATUS_DATE;
4921: END IF; -- LAST_REG_STATUS_DATE
4922:
4919: THEN
4920: x_complete_rec.LAST_REG_STATUS_DATE := l_reg_rec.LAST_REG_STATUS_DATE;
4921: END IF; -- LAST_REG_STATUS_DATE
4922:
4923: IF (p_evt_regs_rec.REG_SOURCE_TYPE_CODE = FND_API.g_miss_char)
4924: THEN
4925: x_complete_rec.REG_SOURCE_TYPE_CODE := l_reg_rec.REG_SOURCE_TYPE_CODE;
4926: END IF; -- REG_SOURCE_TYPE_CODE
4927:
4924: THEN
4925: x_complete_rec.REG_SOURCE_TYPE_CODE := l_reg_rec.REG_SOURCE_TYPE_CODE;
4926: END IF; -- REG_SOURCE_TYPE_CODE
4927:
4928: IF (p_evt_regs_rec.REGISTRATION_SOURCE_ID = FND_API.g_miss_num)
4929: THEN
4930: x_complete_rec.REGISTRATION_SOURCE_ID := l_reg_rec.REGISTRATION_SOURCE_ID;
4931: END IF; -- REGISTRATION_SOURCE_ID
4932:
4929: THEN
4930: x_complete_rec.REGISTRATION_SOURCE_ID := l_reg_rec.REGISTRATION_SOURCE_ID;
4931: END IF; -- REGISTRATION_SOURCE_ID
4932:
4933: IF (p_evt_regs_rec.CONFIRMATION_CODE = FND_API.g_miss_char)
4934: THEN
4935: x_complete_rec.CONFIRMATION_CODE := l_reg_rec.CONFIRMATION_CODE;
4936: END IF; -- CONFIRMATION_CODE
4937:
4934: THEN
4935: x_complete_rec.CONFIRMATION_CODE := l_reg_rec.CONFIRMATION_CODE;
4936: END IF; -- CONFIRMATION_CODE
4937:
4938: IF (p_evt_regs_rec.SOURCE_CODE = FND_API.g_miss_char)
4939: THEN
4940: x_complete_rec.SOURCE_CODE := l_reg_rec.SOURCE_CODE;
4941: END IF; -- SOURCE_CODE
4942:
4939: THEN
4940: x_complete_rec.SOURCE_CODE := l_reg_rec.SOURCE_CODE;
4941: END IF; -- SOURCE_CODE
4942:
4943: IF (p_evt_regs_rec.REGISTRATION_GROUP_ID = FND_API.g_miss_num)
4944: THEN
4945: x_complete_rec.REGISTRATION_GROUP_ID := l_reg_rec.REGISTRATION_GROUP_ID;
4946: END IF; -- REGISTRATION_GROUP_ID
4947:
4944: THEN
4945: x_complete_rec.REGISTRATION_GROUP_ID := l_reg_rec.REGISTRATION_GROUP_ID;
4946: END IF; -- REGISTRATION_GROUP_ID
4947:
4948: IF (p_evt_regs_rec.REGISTRANT_PARTY_ID = FND_API.g_miss_num)
4949: THEN
4950: x_complete_rec.REGISTRANT_PARTY_ID := l_reg_rec.REGISTRANT_PARTY_ID;
4951: END IF; -- REGISTRANT_PARTY_ID
4952:
4949: THEN
4950: x_complete_rec.REGISTRANT_PARTY_ID := l_reg_rec.REGISTRANT_PARTY_ID;
4951: END IF; -- REGISTRANT_PARTY_ID
4952:
4953: IF (p_evt_regs_rec.REGISTRANT_CONTACT_ID = FND_API.g_miss_num)
4954: THEN
4955: x_complete_rec.REGISTRANT_CONTACT_ID := l_reg_rec.REGISTRANT_CONTACT_ID;
4956: END IF; -- REGISTRANT_CONTACT_ID
4957:
4954: THEN
4955: x_complete_rec.REGISTRANT_CONTACT_ID := l_reg_rec.REGISTRANT_CONTACT_ID;
4956: END IF; -- REGISTRANT_CONTACT_ID
4957:
4958: IF (p_evt_regs_rec.REGISTRANT_ACCOUNT_ID = FND_API.g_miss_num)
4959: THEN
4960: x_complete_rec.REGISTRANT_ACCOUNT_ID := l_reg_rec.REGISTRANT_ACCOUNT_ID;
4961: END IF; -- REGISTRANT_ACCOUNT_ID
4962:
4959: THEN
4960: x_complete_rec.REGISTRANT_ACCOUNT_ID := l_reg_rec.REGISTRANT_ACCOUNT_ID;
4961: END IF; -- REGISTRANT_ACCOUNT_ID
4962:
4963: IF (p_evt_regs_rec.ATTENDANT_PARTY_ID = FND_API.g_miss_num)
4964: THEN
4965: x_complete_rec.ATTENDANT_PARTY_ID := l_reg_rec.ATTENDANT_PARTY_ID;
4966: END IF; -- ATTENDANT_PARTY_ID
4967:
4964: THEN
4965: x_complete_rec.ATTENDANT_PARTY_ID := l_reg_rec.ATTENDANT_PARTY_ID;
4966: END IF; -- ATTENDANT_PARTY_ID
4967:
4968: IF (p_evt_regs_rec.ATTENDANT_CONTACT_ID = FND_API.g_miss_num)
4969: THEN
4970: x_complete_rec.ATTENDANT_CONTACT_ID := l_reg_rec.ATTENDANT_CONTACT_ID;
4971: END IF; -- ATTENDANT_CONTACT_ID
4972:
4969: THEN
4970: x_complete_rec.ATTENDANT_CONTACT_ID := l_reg_rec.ATTENDANT_CONTACT_ID;
4971: END IF; -- ATTENDANT_CONTACT_ID
4972:
4973: IF (p_evt_regs_rec.ATTENDANT_ACCOUNT_ID = FND_API.g_miss_num)
4974: THEN
4975: x_complete_rec.ATTENDANT_ACCOUNT_ID := l_reg_rec.ATTENDANT_ACCOUNT_ID;
4976: END IF; -- ATTENDANT_ACCOUNT_ID
4977:
4974: THEN
4975: x_complete_rec.ATTENDANT_ACCOUNT_ID := l_reg_rec.ATTENDANT_ACCOUNT_ID;
4976: END IF; -- ATTENDANT_ACCOUNT_ID
4977:
4978: IF (p_evt_regs_rec.ORIGINAL_REGISTRANT_CONTACT_ID = FND_API.g_miss_num)
4979: THEN
4980: x_complete_rec.ORIGINAL_REGISTRANT_CONTACT_ID := l_reg_rec.ORIGINAL_REGISTRANT_CONTACT_ID;
4981: END IF; -- ORIGINAL_REGISTRANT_CONTACT_ID
4982:
4979: THEN
4980: x_complete_rec.ORIGINAL_REGISTRANT_CONTACT_ID := l_reg_rec.ORIGINAL_REGISTRANT_CONTACT_ID;
4981: END IF; -- ORIGINAL_REGISTRANT_CONTACT_ID
4982:
4983: IF (p_evt_regs_rec.PROSPECT_FLAG = FND_API.g_miss_char)
4984: THEN
4985: x_complete_rec.PROSPECT_FLAG := l_reg_rec.PROSPECT_FLAG;
4986: END IF; -- PROSPECT_FLAG
4987:
4984: THEN
4985: x_complete_rec.PROSPECT_FLAG := l_reg_rec.PROSPECT_FLAG;
4986: END IF; -- PROSPECT_FLAG
4987:
4988: IF (p_evt_regs_rec.ATTENDED_FLAG = FND_API.g_miss_char)
4989: THEN
4990: x_complete_rec.ATTENDED_FLAG := l_reg_rec.ATTENDED_FLAG;
4991: END IF; -- ATTENDED_FLAG
4992:
4989: THEN
4990: x_complete_rec.ATTENDED_FLAG := l_reg_rec.ATTENDED_FLAG;
4991: END IF; -- ATTENDED_FLAG
4992:
4993: IF (p_evt_regs_rec.EVALUATED_FLAG = FND_API.g_miss_char)
4994: THEN
4995: x_complete_rec.EVALUATED_FLAG := l_reg_rec.EVALUATED_FLAG;
4996: END IF; -- EVALUATED_FLAG
4997:
4994: THEN
4995: x_complete_rec.EVALUATED_FLAG := l_reg_rec.EVALUATED_FLAG;
4996: END IF; -- EVALUATED_FLAG
4997:
4998: IF (p_evt_regs_rec.CONFIRMED_FLAG = FND_API.g_miss_char)
4999: THEN
5000: x_complete_rec.CONFIRMED_FLAG := l_reg_rec.CONFIRMED_FLAG;
5001: END IF; -- CONFIRMED_FLAG
5002:
4999: THEN
5000: x_complete_rec.CONFIRMED_FLAG := l_reg_rec.CONFIRMED_FLAG;
5001: END IF; -- CONFIRMED_FLAG
5002:
5003: IF (p_evt_regs_rec.ATTENDANCE_RESULT_CODE = FND_API.g_miss_char)
5004: THEN
5005: x_complete_rec.ATTENDANCE_RESULT_CODE := l_reg_rec.ATTENDANCE_RESULT_CODE;
5006: END IF; -- ATTENDANCE_RESULT_CODE
5007:
5004: THEN
5005: x_complete_rec.ATTENDANCE_RESULT_CODE := l_reg_rec.ATTENDANCE_RESULT_CODE;
5006: END IF; -- ATTENDANCE_RESULT_CODE
5007:
5008: IF (p_evt_regs_rec.WAITLISTED_PRIORITY = FND_API.g_miss_num)
5009: THEN
5010: x_complete_rec.WAITLISTED_PRIORITY := l_reg_rec.WAITLISTED_PRIORITY;
5011: END IF; -- WAITLISTED_PRIORITY
5012:
5009: THEN
5010: x_complete_rec.WAITLISTED_PRIORITY := l_reg_rec.WAITLISTED_PRIORITY;
5011: END IF; -- WAITLISTED_PRIORITY
5012:
5013: IF (p_evt_regs_rec.TARGET_LIST_ID = FND_API.g_miss_num)
5014: THEN
5015: x_complete_rec.TARGET_LIST_ID := l_reg_rec.TARGET_LIST_ID;
5016: END IF; -- TARGET_LIST_ID
5017:
5014: THEN
5015: x_complete_rec.TARGET_LIST_ID := l_reg_rec.TARGET_LIST_ID;
5016: END IF; -- TARGET_LIST_ID
5017:
5018: IF (p_evt_regs_rec.INBOUND_MEDIA_ID = FND_API.g_miss_num)
5019: THEN
5020: x_complete_rec.INBOUND_MEDIA_ID := l_reg_rec.INBOUND_MEDIA_ID;
5021: END IF; -- INBOUND_MEDIA_ID
5022:
5019: THEN
5020: x_complete_rec.INBOUND_MEDIA_ID := l_reg_rec.INBOUND_MEDIA_ID;
5021: END IF; -- INBOUND_MEDIA_ID
5022:
5023: IF (p_evt_regs_rec.INBOUND_CHANNEL_ID = FND_API.g_miss_num)
5024: THEN
5025: x_complete_rec.INBOUND_CHANNEL_ID := l_reg_rec.INBOUND_CHANNEL_ID;
5026: END IF; -- INBOUND_CHANNEL_ID
5027:
5024: THEN
5025: x_complete_rec.INBOUND_CHANNEL_ID := l_reg_rec.INBOUND_CHANNEL_ID;
5026: END IF; -- INBOUND_CHANNEL_ID
5027:
5028: IF (p_evt_regs_rec.CANCELLATION_CODE = FND_API.g_miss_char)
5029: THEN
5030: x_complete_rec.CANCELLATION_CODE := l_reg_rec.CANCELLATION_CODE;
5031: END IF; -- CANCELLATION_CODE
5032:
5029: THEN
5030: x_complete_rec.CANCELLATION_CODE := l_reg_rec.CANCELLATION_CODE;
5031: END IF; -- CANCELLATION_CODE
5032:
5033: IF (p_evt_regs_rec.CANCELLATION_REASON_CODE = FND_API.g_miss_char)
5034: THEN
5035: x_complete_rec.CANCELLATION_REASON_CODE := l_reg_rec.CANCELLATION_REASON_CODE;
5036: END IF; -- CANCELLATION_REASON_CODE
5037:
5034: THEN
5035: x_complete_rec.CANCELLATION_REASON_CODE := l_reg_rec.CANCELLATION_REASON_CODE;
5036: END IF; -- CANCELLATION_REASON_CODE
5037:
5038: IF (p_evt_regs_rec.ATTENDANCE_FAILURE_REASON = FND_API.g_miss_char)
5039: THEN
5040: x_complete_rec.ATTENDANCE_FAILURE_REASON := l_reg_rec.ATTENDANCE_FAILURE_REASON;
5041: END IF; -- ATTENDANCE_FAILURE_REASON
5042:
5039: THEN
5040: x_complete_rec.ATTENDANCE_FAILURE_REASON := l_reg_rec.ATTENDANCE_FAILURE_REASON;
5041: END IF; -- ATTENDANCE_FAILURE_REASON
5042:
5043: IF (p_evt_regs_rec.ATTENDANT_LANGUAGE = FND_API.g_miss_char)
5044: THEN
5045: x_complete_rec.ATTENDANT_LANGUAGE := l_reg_rec.ATTENDANT_LANGUAGE;
5046: END IF; -- ATTENDANT_LANGUAGE
5047:
5044: THEN
5045: x_complete_rec.ATTENDANT_LANGUAGE := l_reg_rec.ATTENDANT_LANGUAGE;
5046: END IF; -- ATTENDANT_LANGUAGE
5047:
5048: IF (p_evt_regs_rec.SALESREP_ID = FND_API.g_miss_num)
5049: THEN
5050: x_complete_rec.SALESREP_ID := l_reg_rec.SALESREP_ID;
5051: END IF; -- SALESREP_ID
5052:
5049: THEN
5050: x_complete_rec.SALESREP_ID := l_reg_rec.SALESREP_ID;
5051: END IF; -- SALESREP_ID
5052:
5053: IF (p_evt_regs_rec.ORDER_HEADER_ID = FND_API.g_miss_num)
5054: THEN
5055: x_complete_rec.ORDER_HEADER_ID := l_reg_rec.ORDER_HEADER_ID;
5056: END IF; -- ORDER_HEADER_ID
5057:
5054: THEN
5055: x_complete_rec.ORDER_HEADER_ID := l_reg_rec.ORDER_HEADER_ID;
5056: END IF; -- ORDER_HEADER_ID
5057:
5058: IF (p_evt_regs_rec.ORDER_LINE_ID = FND_API.g_miss_num)
5059: THEN
5060: x_complete_rec.ORDER_LINE_ID := l_reg_rec.ORDER_LINE_ID;
5061: END IF; -- ORDER_LINE_ID
5062:
5059: THEN
5060: x_complete_rec.ORDER_LINE_ID := l_reg_rec.ORDER_LINE_ID;
5061: END IF; -- ORDER_LINE_ID
5062:
5063: IF (p_evt_regs_rec.DESCRIPTION = FND_API.g_miss_char)
5064: THEN
5065: x_complete_rec.DESCRIPTION := l_reg_rec.DESCRIPTION;
5066: END IF; -- DESCRIPTION
5067:
5064: THEN
5065: x_complete_rec.DESCRIPTION := l_reg_rec.DESCRIPTION;
5066: END IF; -- DESCRIPTION
5067:
5068: IF (p_evt_regs_rec.MAX_ATTENDEE_OVERRIDE_FLAG = FND_API.g_miss_char)
5069: THEN
5070: x_complete_rec.MAX_ATTENDEE_OVERRIDE_FLAG := l_reg_rec.MAX_ATTENDEE_OVERRIDE_FLAG;
5071: END IF; -- MAX_ATTENDEE_OVERRIDE_FLAG
5072:
5069: THEN
5070: x_complete_rec.MAX_ATTENDEE_OVERRIDE_FLAG := l_reg_rec.MAX_ATTENDEE_OVERRIDE_FLAG;
5071: END IF; -- MAX_ATTENDEE_OVERRIDE_FLAG
5072:
5073: IF (p_evt_regs_rec.INVITE_ONLY_OVERRIDE_FLAG = FND_API.g_miss_char)
5074: THEN
5075: x_complete_rec.INVITE_ONLY_OVERRIDE_FLAG := l_reg_rec.INVITE_ONLY_OVERRIDE_FLAG;
5076: END IF; -- INVITE_ONLY_OVERRIDE_FLAG
5077:
5074: THEN
5075: x_complete_rec.INVITE_ONLY_OVERRIDE_FLAG := l_reg_rec.INVITE_ONLY_OVERRIDE_FLAG;
5076: END IF; -- INVITE_ONLY_OVERRIDE_FLAG
5077:
5078: IF (p_evt_regs_rec.PAYMENT_STATUS_CODE = FND_API.g_miss_char)
5079: THEN
5080: x_complete_rec.PAYMENT_STATUS_CODE := l_reg_rec.PAYMENT_STATUS_CODE;
5081: END IF; -- PAYMENT_STATUS_CODE
5082:
5079: THEN
5080: x_complete_rec.PAYMENT_STATUS_CODE := l_reg_rec.PAYMENT_STATUS_CODE;
5081: END IF; -- PAYMENT_STATUS_CODE
5082:
5083: IF (p_evt_regs_rec.AUTO_REGISTER_FLAG = FND_API.g_miss_char)
5084: THEN
5085: x_complete_rec.AUTO_REGISTER_FLAG := l_reg_rec.AUTO_REGISTER_FLAG;
5086: END IF; -- AUTO_REGISTER_FLAG
5087:
5084: THEN
5085: x_complete_rec.AUTO_REGISTER_FLAG := l_reg_rec.AUTO_REGISTER_FLAG;
5086: END IF; -- AUTO_REGISTER_FLAG
5087:
5088: IF (p_evt_regs_rec.ATTRIBUTE_CATEGORY = FND_API.g_miss_char)
5089: THEN
5090: x_complete_rec.ATTRIBUTE_CATEGORY := l_reg_rec.ATTRIBUTE_CATEGORY;
5091: END IF; -- ATTRIBUTE_CATEGORY
5092:
5089: THEN
5090: x_complete_rec.ATTRIBUTE_CATEGORY := l_reg_rec.ATTRIBUTE_CATEGORY;
5091: END IF; -- ATTRIBUTE_CATEGORY
5092:
5093: IF (p_evt_regs_rec.ATTRIBUTE1 = FND_API.g_miss_char)
5094: THEN
5095: x_complete_rec.ATTRIBUTE1 := l_reg_rec.ATTRIBUTE1;
5096: END IF; -- ATTRIBUTE1
5097:
5094: THEN
5095: x_complete_rec.ATTRIBUTE1 := l_reg_rec.ATTRIBUTE1;
5096: END IF; -- ATTRIBUTE1
5097:
5098: IF (p_evt_regs_rec.ATTRIBUTE2 = FND_API.g_miss_char)
5099: THEN
5100: x_complete_rec.ATTRIBUTE2 := l_reg_rec.ATTRIBUTE2;
5101: END IF; -- ATTRIBUTE2
5102:
5099: THEN
5100: x_complete_rec.ATTRIBUTE2 := l_reg_rec.ATTRIBUTE2;
5101: END IF; -- ATTRIBUTE2
5102:
5103: IF (p_evt_regs_rec.ATTRIBUTE3 = FND_API.g_miss_char)
5104: THEN
5105: x_complete_rec.ATTRIBUTE3 := l_reg_rec.ATTRIBUTE3;
5106: END IF; -- ATTRIBUTE3
5107:
5104: THEN
5105: x_complete_rec.ATTRIBUTE3 := l_reg_rec.ATTRIBUTE3;
5106: END IF; -- ATTRIBUTE3
5107:
5108: IF (p_evt_regs_rec.ATTRIBUTE4 = FND_API.g_miss_char)
5109: THEN
5110: x_complete_rec.ATTRIBUTE4 := l_reg_rec.ATTRIBUTE4;
5111: END IF; -- ATTRIBUTE4
5112:
5109: THEN
5110: x_complete_rec.ATTRIBUTE4 := l_reg_rec.ATTRIBUTE4;
5111: END IF; -- ATTRIBUTE4
5112:
5113: IF (p_evt_regs_rec.ATTRIBUTE5 = FND_API.g_miss_char)
5114: THEN
5115: x_complete_rec.ATTRIBUTE5 := l_reg_rec.ATTRIBUTE5;
5116: END IF; -- ATTRIBUTE5
5117:
5114: THEN
5115: x_complete_rec.ATTRIBUTE5 := l_reg_rec.ATTRIBUTE5;
5116: END IF; -- ATTRIBUTE5
5117:
5118: IF (p_evt_regs_rec.ATTRIBUTE6 = FND_API.g_miss_char)
5119: THEN
5120: x_complete_rec.ATTRIBUTE6 := l_reg_rec.ATTRIBUTE6;
5121: END IF; -- ATTRIBUTE6
5122:
5119: THEN
5120: x_complete_rec.ATTRIBUTE6 := l_reg_rec.ATTRIBUTE6;
5121: END IF; -- ATTRIBUTE6
5122:
5123: IF (p_evt_regs_rec.ATTRIBUTE7 = FND_API.g_miss_char)
5124: THEN
5125: x_complete_rec.ATTRIBUTE7 := l_reg_rec.ATTRIBUTE7;
5126: END IF; -- ATTRIBUTE7
5127:
5124: THEN
5125: x_complete_rec.ATTRIBUTE7 := l_reg_rec.ATTRIBUTE7;
5126: END IF; -- ATTRIBUTE7
5127:
5128: IF (p_evt_regs_rec.ATTRIBUTE8 = FND_API.g_miss_char)
5129: THEN
5130: x_complete_rec.ATTRIBUTE8 := l_reg_rec.ATTRIBUTE8;
5131: END IF; -- ATTRIBUTE8
5132:
5129: THEN
5130: x_complete_rec.ATTRIBUTE8 := l_reg_rec.ATTRIBUTE8;
5131: END IF; -- ATTRIBUTE8
5132:
5133: IF (p_evt_regs_rec.ATTRIBUTE9 = FND_API.g_miss_char)
5134: THEN
5135: x_complete_rec.ATTRIBUTE9 := l_reg_rec.ATTRIBUTE9;
5136: END IF; -- ATTRIBUTE9
5137:
5134: THEN
5135: x_complete_rec.ATTRIBUTE9 := l_reg_rec.ATTRIBUTE9;
5136: END IF; -- ATTRIBUTE9
5137:
5138: IF (p_evt_regs_rec.ATTRIBUTE10 = FND_API.g_miss_char)
5139: THEN
5140: x_complete_rec.ATTRIBUTE10 := l_reg_rec.ATTRIBUTE10;
5141: END IF; -- ATTRIBUTE10
5142:
5139: THEN
5140: x_complete_rec.ATTRIBUTE10 := l_reg_rec.ATTRIBUTE10;
5141: END IF; -- ATTRIBUTE10
5142:
5143: IF (p_evt_regs_rec.ATTRIBUTE11 = FND_API.g_miss_char)
5144: THEN
5145: x_complete_rec.ATTRIBUTE11 := l_reg_rec.ATTRIBUTE11;
5146: END IF; -- ATTRIBUTE11
5147:
5144: THEN
5145: x_complete_rec.ATTRIBUTE11 := l_reg_rec.ATTRIBUTE11;
5146: END IF; -- ATTRIBUTE11
5147:
5148: IF (p_evt_regs_rec.ATTRIBUTE12 = FND_API.g_miss_char)
5149: THEN
5150: x_complete_rec.ATTRIBUTE12 := l_reg_rec.ATTRIBUTE12;
5151: END IF; -- ATTRIBUTE12
5152:
5149: THEN
5150: x_complete_rec.ATTRIBUTE12 := l_reg_rec.ATTRIBUTE12;
5151: END IF; -- ATTRIBUTE12
5152:
5153: IF (p_evt_regs_rec.ATTRIBUTE13 = FND_API.g_miss_char)
5154: THEN
5155: x_complete_rec.ATTRIBUTE13 := l_reg_rec.ATTRIBUTE13;
5156: END IF; -- ATTRIBUTE13
5157:
5154: THEN
5155: x_complete_rec.ATTRIBUTE13 := l_reg_rec.ATTRIBUTE13;
5156: END IF; -- ATTRIBUTE13
5157:
5158: IF (p_evt_regs_rec.ATTRIBUTE14 = FND_API.g_miss_char)
5159: THEN
5160: x_complete_rec.ATTRIBUTE14 := l_reg_rec.ATTRIBUTE14;
5161: END IF; -- ATTRIBUTE14
5162:
5159: THEN
5160: x_complete_rec.ATTRIBUTE14 := l_reg_rec.ATTRIBUTE14;
5161: END IF; -- ATTRIBUTE14
5162:
5163: IF (p_evt_regs_rec.ATTRIBUTE15 = FND_API.g_miss_char)
5164: THEN
5165: x_complete_rec.ATTRIBUTE15 := l_reg_rec.ATTRIBUTE15;
5166: END IF; -- ATTRIBUTE15
5167:
5165: x_complete_rec.ATTRIBUTE15 := l_reg_rec.ATTRIBUTE15;
5166: END IF; -- ATTRIBUTE15
5167:
5168: -- Hornet: following six fields added for imeeting integration
5169: IF (p_evt_regs_rec.attendee_role_type = FND_API.g_miss_char)
5170: THEN
5171: x_complete_rec.attendee_role_type := l_reg_rec.attendee_role_type;
5172: END IF; -- attendee_role_type
5173:
5170: THEN
5171: x_complete_rec.attendee_role_type := l_reg_rec.attendee_role_type;
5172: END IF; -- attendee_role_type
5173:
5174: IF (p_evt_regs_rec.notification_type = FND_API.g_miss_char)
5175: THEN
5176: x_complete_rec.notification_type := l_reg_rec.notification_type;
5177: END IF; -- notification_type
5178:
5175: THEN
5176: x_complete_rec.notification_type := l_reg_rec.notification_type;
5177: END IF; -- notification_type
5178:
5179: IF (p_evt_regs_rec.last_notified_time = FND_API.g_miss_date)
5180: THEN
5181: x_complete_rec.last_notified_time := l_reg_rec.last_notified_time;
5182: END IF; -- last_notified_time
5183:
5180: THEN
5181: x_complete_rec.last_notified_time := l_reg_rec.last_notified_time;
5182: END IF; -- last_notified_time
5183:
5184: IF (p_evt_regs_rec.EVENT_JOIN_TIME = FND_API.g_miss_date)
5185: THEN
5186: x_complete_rec.EVENT_JOIN_TIME := l_reg_rec.EVENT_JOIN_TIME;
5187: END IF; -- EVENT_JOIN_TIME
5188:
5185: THEN
5186: x_complete_rec.EVENT_JOIN_TIME := l_reg_rec.EVENT_JOIN_TIME;
5187: END IF; -- EVENT_JOIN_TIME
5188:
5189: IF (p_evt_regs_rec.EVENT_EXIT_TIME = FND_API.g_miss_date)
5190: THEN
5191: x_complete_rec.EVENT_EXIT_TIME := l_reg_rec.EVENT_EXIT_TIME;
5192: END IF; -- EVENT_EXIT_TIME
5193:
5190: THEN
5191: x_complete_rec.EVENT_EXIT_TIME := l_reg_rec.EVENT_EXIT_TIME;
5192: END IF; -- EVENT_EXIT_TIME
5193:
5194: IF (p_evt_regs_rec.MEETING_ENCRYPTION_KEY_CODE = FND_API.g_miss_char)
5195: THEN
5196: x_complete_rec.MEETING_ENCRYPTION_KEY_CODE := l_reg_rec.MEETING_ENCRYPTION_KEY_CODE;
5197: END IF; -- MEETING_ENCRYPTION_KEY_CODE
5198:
5300: -- create media_rec
5301: JTF_IH_PUB.Create_MediaItem
5302: (
5303: p_api_version => 1.0,
5304: p_init_msg_list => FND_API.g_false,
5305: p_commit => FND_API.g_false,
5306: -- p_resp_appl_id => l_resp_appl_id,
5307: -- p_resp_id => l_resp_id,
5308: p_user_id => l_user_id,
5301: JTF_IH_PUB.Create_MediaItem
5302: (
5303: p_api_version => 1.0,
5304: p_init_msg_list => FND_API.g_false,
5305: p_commit => FND_API.g_false,
5306: -- p_resp_appl_id => l_resp_appl_id,
5307: -- p_resp_id => l_resp_id,
5308: p_user_id => l_user_id,
5309: -- p_login_id => l_login_id,
5312: x_msg_data => l_msg_data,
5313: p_media_rec => l_media_rec,
5314: x_media_id => l_media_id
5315: );
5316: IF l_return_status <> FND_API.g_ret_sts_success THEN
5317: RAISE FND_API.g_exc_error;
5318: RETURN;
5319: END IF;
5320:
5313: p_media_rec => l_media_rec,
5314: x_media_id => l_media_id
5315: );
5316: IF l_return_status <> FND_API.g_ret_sts_success THEN
5317: RAISE FND_API.g_exc_error;
5318: RETURN;
5319: END IF;
5320:
5321: IF (AMS_DEBUG_HIGH_ON) THEN
5377: -- create interaction
5378: JTF_IH_PUB.Create_Interaction
5379: (
5380: p_api_version => 1.0,
5381: p_init_msg_list => FND_API.g_false,
5382: p_commit => FND_API.g_false,
5383: -- p_resp_appl_id => l_resp_appl_id, -- 530
5384: -- p_resp_id => l_resp_id, -- fnd global
5385: p_user_id => l_user_id,
5378: JTF_IH_PUB.Create_Interaction
5379: (
5380: p_api_version => 1.0,
5381: p_init_msg_list => FND_API.g_false,
5382: p_commit => FND_API.g_false,
5383: -- p_resp_appl_id => l_resp_appl_id, -- 530
5384: -- p_resp_id => l_resp_id, -- fnd global
5385: p_user_id => l_user_id,
5386: -- p_login_id => l_login_id,
5389: x_msg_data => l_msg_data,
5390: p_interaction_rec => l_interaction_rec,
5391: p_activities => l_activities
5392: );
5393: IF l_return_status <> FND_API.g_ret_sts_success THEN
5394: RAISE FND_API.g_exc_error;
5395: RETURN;
5396: END IF;
5397:
5390: p_interaction_rec => l_interaction_rec,
5391: p_activities => l_activities
5392: );
5393: IF l_return_status <> FND_API.g_ret_sts_success THEN
5394: RAISE FND_API.g_exc_error;
5395: RETURN;
5396: END IF;
5397:
5398: END write_interaction;