268: || ' Source Code Id ' || l_CampaignCodeID);
269: FETCH c_campaignid INTO lx_campaignCodeId, lx_CampaignCode, lx_CampaignID;
270: IF (c_CampaignId%FOUND) then
271: LogMessage('MoreCampaign Code Match. Will be using default is set ');
272: lx_campaignCode := FND_PROFILE.VALUE('AST_DEFAULT_SOURCE_CODE');
273: if lx_CampaignCode is not NULL then
274: OPEN c_campaigncode(lx_CampaignCode);
275: FETCH c_campaigncode INTO l_campaignCodeId, l_campaignid;
276: IF c_CampaignCode%FOUND THEN
563: BEGIN
564: G_CurrentForm := UPPER(p_formName);
565: END setCurrentForm ;
566: BEGIN
567: l_Profile := NVL(Fnd_Profile.VALUE('AST_MATCH_CAMP_DNIS'), 'N');
568: l_DumpData := NVL(Fnd_Profile.VALUE('AST_DUMP_PARAMS'), 'N');
569: l_NoAreaCodeMatch := NVL(Fnd_Profile.value('AST_ANI_WITHOUT_AREACODE'), 'N');
570: END Okl_Uwq_Sel_Pkg;
564: G_CurrentForm := UPPER(p_formName);
565: END setCurrentForm ;
566: BEGIN
567: l_Profile := NVL(Fnd_Profile.VALUE('AST_MATCH_CAMP_DNIS'), 'N');
568: l_DumpData := NVL(Fnd_Profile.VALUE('AST_DUMP_PARAMS'), 'N');
569: l_NoAreaCodeMatch := NVL(Fnd_Profile.value('AST_ANI_WITHOUT_AREACODE'), 'N');
570: END Okl_Uwq_Sel_Pkg;
565: END setCurrentForm ;
566: BEGIN
567: l_Profile := NVL(Fnd_Profile.VALUE('AST_MATCH_CAMP_DNIS'), 'N');
568: l_DumpData := NVL(Fnd_Profile.VALUE('AST_DUMP_PARAMS'), 'N');
569: l_NoAreaCodeMatch := NVL(Fnd_Profile.value('AST_ANI_WITHOUT_AREACODE'), 'N');
570: END Okl_Uwq_Sel_Pkg;