40:
41: -- Initialize message list if p_init_msg_list is set to TRUE.
42: IF FND_API.to_Boolean( p_init_msg_list )
43: THEN
44: FND_MSG_PUB.initialize;
45: END IF;
46:
47: x_return_status := FND_API.G_RET_STS_SUCCESS ;
48:
45: END IF;
46:
47: x_return_status := FND_API.G_RET_STS_SUCCESS ;
48:
49: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
50: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
51: fnd_message.Set_Token('TEXT', ' ********* Before calling PV_OPPORTUNITY_VHUK.Create_Opportunity_Post');
52: fnd_msg_pub.Add;
53: END IF;
48:
49: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
50: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
51: fnd_message.Set_Token('TEXT', ' ********* Before calling PV_OPPORTUNITY_VHUK.Create_Opportunity_Post');
52: fnd_msg_pub.Add;
53: END IF;
54:
55: PV_OPPORTUNITY_VHUK.Create_Opportunity_Post (
56: p_api_version_number => 1.0,
62: x_return_status => x_return_status,
63: x_msg_count => x_msg_count,
64: x_msg_data => x_msg_data);
65:
66: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
67: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
68: fnd_message.Set_Token('TEXT', '********* After calling PV_OPPORTUNITY_VHUK.Create_Opportunity_Post');
69: fnd_msg_pub.Add;
70: END IF;
65:
66: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
67: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
68: fnd_message.Set_Token('TEXT', '********* After calling PV_OPPORTUNITY_VHUK.Create_Opportunity_Post');
69: fnd_msg_pub.Add;
70: END IF;
71:
72: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
73: RAISE FND_API.G_EXC_ERROR;
75:
76: EXCEPTION
77: WHEN FND_API.G_EXC_ERROR THEN
78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
80: p_count => x_msg_count,
81: p_data => x_msg_data);
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
80: p_count => x_msg_count,
81: p_data => x_msg_data);
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
84: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
85: p_count => x_msg_count,
86: p_data => x_msg_data);
87: WHEN OTHERS THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85: p_count => x_msg_count,
86: p_data => x_msg_data);
87: WHEN OTHERS THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
90: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
91: p_count => x_msg_count,
92: p_data => x_msg_data);
93:
86: p_data => x_msg_data);
87: WHEN OTHERS THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
90: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
91: p_count => x_msg_count,
92: p_data => x_msg_data);
93:
94: END Create_opp_header_Post;
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158:
159: IF FND_API.to_Boolean( p_init_msg_list )
160: THEN
161: FND_MSG_PUB.initialize;
162: END IF;
163:
164: x_return_status := FND_API.G_RET_STS_SUCCESS ;
165:
174: close lc_get_channel_type;
175:
176: FND_MESSAGE.Set_Name('PV', 'PV_LEAD_NOT_FOUND');
177: FND_MESSAGE.Set_Token('LEAD_ID', p_header_rec.lead_id);
178: FND_MSG_PUB.Add;
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180:
181: end if;
182:
199: close lc_chk_channel_code;
200:
201: FND_MESSAGE.Set_Name('PV', 'PV_INVALID_CHANNEL_CODE');
202: FND_MESSAGE.Set_Token('P_CHANNEL', p_header_rec.channel_code);
203: FND_MSG_PUB.Add;
204:
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206:
207: end if;
213: then
214:
215: FND_MESSAGE.Set_Name('PV', 'PV_OPP_ALREADY_ASSIGNED');
216: FND_MESSAGE.Set_Token('P_CHANNEL', l_to_channel_meaning);
217: FND_MSG_PUB.Add;
218:
219: RAISE FND_API.G_EXC_ERROR;
220:
221: end if;
236: x_msg_data => x_msg_data);
237:
238:
239: -- Standard call to get message count and if count is 1, get message info.
240: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data);
243:
244: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
248: EXCEPTION
249:
250: WHEN FND_API.G_EXC_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_ERROR ;
252: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data);
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: p_data => x_msg_data);
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
258: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: p_count => x_msg_count,
260: p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
264: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
265: p_count => x_msg_count,
266: p_data => x_msg_data);
267: END update_opp_header_pre;
260: p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
264: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
265: p_count => x_msg_count,
266: p_data => x_msg_data);
267: END update_opp_header_pre;
268:
311: -- Added this code for bugfix : 1975105
312: x_return_status := FND_API.G_RET_STS_SUCCESS ;
313:
314: -- Standard call to get message count and if count is 1, get message info.
315: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
316: p_count => x_msg_count,
317: p_data => x_msg_data);
318: EXCEPTION
319:
318: EXCEPTION
319:
320: WHEN FND_API.G_EXC_ERROR THEN
321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
323: p_count => x_msg_count,
324: p_data => x_msg_data);
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323: p_count => x_msg_count,
324: p_data => x_msg_data);
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
327: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data);
330: WHEN OTHERS THEN
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: p_count => x_msg_count,
329: p_data => x_msg_data);
330: WHEN OTHERS THEN
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
333: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
334: p_count => x_msg_count,
335: p_data => x_msg_data);
336: END update_opp_header_post;
329: p_data => x_msg_data);
330: WHEN OTHERS THEN
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
333: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
334: p_count => x_msg_count,
335: p_data => x_msg_data);
336: END update_opp_header_post;
337: