63: null;
64: else
65: -- ERROR --
66: x_return_status := FND_API.g_ret_sts_unexp_error;
67: fnd_message.set_name('AST','AST_UWQ_INVALID_CAMPAIGN');
68: l_error_msg := fnd_message.get;
69: FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
70: FND_MESSAGE.Set_Token('TEXT', l_error_msg || ' ' || l_description, FALSE);
71: FND_MSG_PUB.ADD;
64: else
65: -- ERROR --
66: x_return_status := FND_API.g_ret_sts_unexp_error;
67: fnd_message.set_name('AST','AST_UWQ_INVALID_CAMPAIGN');
68: l_error_msg := fnd_message.get;
69: FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
70: FND_MESSAGE.Set_Token('TEXT', l_error_msg || ' ' || l_description, FALSE);
71: FND_MSG_PUB.ADD;
72: RAISE FND_API.G_EXC_ERROR;
65: -- ERROR --
66: x_return_status := FND_API.g_ret_sts_unexp_error;
67: fnd_message.set_name('AST','AST_UWQ_INVALID_CAMPAIGN');
68: l_error_msg := fnd_message.get;
69: FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
70: FND_MESSAGE.Set_Token('TEXT', l_error_msg || ' ' || l_description, FALSE);
71: FND_MSG_PUB.ADD;
72: RAISE FND_API.G_EXC_ERROR;
73: end if;
66: x_return_status := FND_API.g_ret_sts_unexp_error;
67: fnd_message.set_name('AST','AST_UWQ_INVALID_CAMPAIGN');
68: l_error_msg := fnd_message.get;
69: FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
70: FND_MESSAGE.Set_Token('TEXT', l_error_msg || ' ' || l_description, FALSE);
71: FND_MSG_PUB.ADD;
72: RAISE FND_API.G_EXC_ERROR;
73: end if;
74: CLOSE c_camp_description;
72: RAISE FND_API.G_EXC_ERROR;
73: end if;
74: CLOSE c_camp_description;
75: elsif l_camp_descr is not null then
76: fnd_message.set_name('AST','AST_CAMP');
77: l_campaign := fnd_message.get;
78: l_description := '< ' || l_campaign || ':' || l_camp_descr || ' > ' ;
79: else
80: fnd_message.set_name('AST','AST_NO_CAMP_DATA');
73: end if;
74: CLOSE c_camp_description;
75: elsif l_camp_descr is not null then
76: fnd_message.set_name('AST','AST_CAMP');
77: l_campaign := fnd_message.get;
78: l_description := '< ' || l_campaign || ':' || l_camp_descr || ' > ' ;
79: else
80: fnd_message.set_name('AST','AST_NO_CAMP_DATA');
81: l_no_campaign := fnd_message.get;
76: fnd_message.set_name('AST','AST_CAMP');
77: l_campaign := fnd_message.get;
78: l_description := '< ' || l_campaign || ':' || l_camp_descr || ' > ' ;
79: else
80: fnd_message.set_name('AST','AST_NO_CAMP_DATA');
81: l_no_campaign := fnd_message.get;
82: l_description := '< '|| l_no_campaign || ': > ';
83: end if;
84:
77: l_campaign := fnd_message.get;
78: l_description := '< ' || l_campaign || ':' || l_camp_descr || ' > ' ;
79: else
80: fnd_message.set_name('AST','AST_NO_CAMP_DATA');
81: l_no_campaign := fnd_message.get;
82: l_description := '< '|| l_no_campaign || ': > ';
83: end if;
84:
85: -- setting the OUT variables -begin