[Home] [Help]
381: -- if profile option indicates Copying from header to offer, make a call to
382: -- copy_ev_header_to_offer procedure to copy appropriate fields from header to offer.
383: -- associations of header will be copied
384:
385: l_copy_flag := FND_PROFILE.Value('AMS_COPY_EVH_TO_EVO');--'Y';
386:
387: IF (p_evo_rec.event_level = 'MAIN' and l_copy_flag = 'Y' and p_evo_rec.event_object_type = 'EVEO') then
388: IF (AMS_DEBUG_HIGH_ON) THEN
389:
431: -- default event calendar, present;y defailting it to be same as campaigns calendar.. SHOULD CHANGE
432: -- not sure about the logic, should it be defaulted only for MAIN events, not the agenda..
433:
434: -- IF l_evo_rec.event_calendar IS NULL THEN
435: l_evo_rec.event_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
436: -- END IF;
437: ----------------------------user status and system status---------------------
438:
439: -- added sugupta 07/20/2000 for event agenda, stastuses shouldnt be defaulted to 1/NEW
635:
636: -- integration with inventory and pricing api's happens at update level..
637: --the user enters inventory number from reg set up screen..
638: -- 05/09/2000 however setting up the organization id here from profile option...
639: l_org_id := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');
640: -- 05/10/2000 based on values of city, state, country passed, call hz_loc API
641: -- to create a new loc_id to be inserted into offers table
642: -- city/state/country will never be passed for event agenda... so no need to put an if loop for event level
643:
667: END IF;
668: END IF;
669:
670: -- Added by rmajumda (09/15/05). MOAC changes
671: l_ou_id := fnd_profile.value('DEFAULT_ORG_ID');
672:
673:
674: IF l_evo_rec.object_version_number = 2 THEN -- copy
675: l_ovn := 2;
874: l_evo_rec.certification_credits,
875: l_evo_rec.coordinator_id,
876: l_evo_rec.priority_type_code,
877: l_evo_rec.cancellation_reason_code,
878: NVL(l_evo_rec.auto_register_flag, nvl(FND_PROFILE.value('AMS_AUTO_REGISTER_FLAG'), 'Y')),
879: l_evo_rec.email,
880: l_evo_rec.phone,
881: l_evo_rec.fund_amount_tc,
882: l_evo_rec.fund_amount_fc,
904: l_evo_rec.attribute15,
905: -- l_evo_rec.country_code,
906: -- The above will require the JSP to send the country_code as part of the rec.
907: -- This is not needed the API can pick it up as follows:
908: NVL(l_evo_rec.country_code, TO_NUMBER(FND_PROFILE.value('AMS_SRCGEN_USER_CITY'))),
909: -- The above picks up the country code from the Profile option if the one sent in
910: -- by the JSP page is null.
911: l_evo_rec.business_unit_id,
912: -- The JSPs are expected to send the value of the business_unit_id. It is nullable.
2569: url = l_evo_rec.url,
2570: timezone_id = l_evo_rec.timezone_id,
2571: --event_venue_id = l_evo_rec.event_venue_id,
2572: inbound_script_name = l_evo_rec.inbound_script_name,
2573: auto_register_flag = NVL(l_evo_rec.auto_register_flag, nvl(FND_PROFILE.value('AMS_AUTO_REGISTER_FLAG'), 'Y')),
2574: attribute_category = l_evo_rec.attribute_category,
2575: attribute1 = l_evo_rec.attribute1,
2576: attribute2 = l_evo_rec.attribute2,
2577: attribute3 = l_evo_rec.attribute3,
2693: url = l_evo_rec.url,
2694: timezone_id = l_evo_rec.timezone_id,
2695: -- event_venue_id = l_evo_rec.event_venue_id,
2696: inbound_script_name = l_evo_rec.inbound_script_name,
2697: auto_register_flag = NVL(l_evo_rec.auto_register_flag, nvl(FND_PROFILE.value('AMS_AUTO_REGISTER_FLAG'), 'Y')),
2698: attribute_category = l_evo_rec.attribute_category,
2699: attribute1 = l_evo_rec.attribute1,
2700: attribute2 = l_evo_rec.attribute2,
2701: attribute3 = l_evo_rec.attribute3,
5532: x_complete_rec.business_unit_id := l_evo_rec.business_unit_id;
5533: END IF;
5534: -- sugupta added calendar fields
5535: IF p_evo_rec.event_calendar = FND_API.g_miss_char THEN
5536: x_complete_rec.event_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
5537: END IF;
5538:
5539: IF p_evo_rec.start_period_name = FND_API.g_miss_char THEN
5540: x_complete_rec.start_period_name := l_evo_rec.start_period_name;
5684:
5685: l_commit := p_commit;
5686: l_validation_level := fnd_api.g_VALID_LEVEL_FULL;
5687: l_item_rec.SEGMENT1 := p_inv_item_number;
5688: l_item_rec.ORGANIZATION_ID := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');
5689: --204;
5690: l_item_rec.DESCRIPTION := p_inv_item_desc;
5691: l_item_rec.LONG_DESCRIPTION := p_inv_long_desc;
5692: l_item_rec.event_flag := 'Y';
5833:
5834: -- dbms_output.put_line('create List header called');
5835: x_return_status := FND_API.g_ret_sts_success;
5836: -- todo- get Header name from profile option AMS_PRICELIST_HEADER_NAME
5837: p_price_list_rec.name := FND_PROFILE.value('AMS_PRICELIST_HEADER_NAME');
5838: --'Event Registration Pricing';
5839: p_price_list_rec.created_by := p_evo_rec.owner_user_id;
5840: p_price_list_rec.creation_date := sysdate;
5841: p_price_list_rec.currency_code := p_evo_rec.pricelist_header_currency_code;
6872: WHERE evo.pricelist_header_id = qph.price_list_id
6873: AND qph.currency_code = curr_code;
6874:
6875: BEGIN
6876: l_qp_profile := FND_PROFILE.Value('AMS_USE_GLOBAL_PRICING');
6877: l_evo_rec := p_evo_rec;
6878:
6879: -- Remove the following line once the testing is done.
6880: l_qp_profile := 'N';
7266: x_return_status := FND_API.G_RET_STS_SUCCESS;
7267:
7268: -- Start of Fulfillment VMODUR
7269:
7270: l_fulfilment := FND_PROFILE.Value('AMS_FULFILL_ENABLE_FLAG');
7271:
7272: IF (AMS_DEBUG_HIGH_ON) THEN
7273: AMS_Utility_PVT.debug_message(' Fulfilment Profile :' || l_fulfilment);
7274: END IF;