245: end if;
246: exception
247: WHEN FND_API.G_EXC_ERROR THEN
248: x_return_status := FND_API.G_RET_STS_ERROR ;
249: FND_MSG_PUB.Count_And_Get
250: ( p_encoded => 'F',
251: p_count => x_msg_count,
252: p_data => x_mesg_data
253: );
252: p_data => x_mesg_data
253: );
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
256: FND_MSG_PUB.Count_And_Get
257: ( p_encoded => 'F',
258: p_count => x_msg_count,
259: p_data => x_mesg_data
260: );
259: p_data => x_mesg_data
260: );
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
263: FND_MSG_PUB.Count_And_Get
264: ( p_encoded => 'F',
265: p_count => x_msg_count,
266: p_data => x_mesg_data
267: );
317:
318: exception
319: WHEN FND_API.G_EXC_ERROR THEN
320: x_return_status := FND_API.G_RET_STS_ERROR ;
321: FND_MSG_PUB.Count_And_Get
322: ( p_encoded => 'F',
323: p_count => x_msg_count,
324: p_data => x_mesg_data
325: );
324: p_data => x_mesg_data
325: );
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
328: FND_MSG_PUB.Count_And_Get
329: ( p_encoded => 'F',
330: p_count => x_msg_count,
331: p_data => x_mesg_data
332: );
331: p_data => x_mesg_data
332: );
333: WHEN OTHERS THEN
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
335: FND_MSG_PUB.Count_And_Get
336: ( p_encoded => 'F',
337: p_count => x_msg_count,
338: p_data => x_mesg_data
339: );
383:
384: begin
385:
386: g_origin := source_id;
387: fnd_msg_pub.initialize;
388:
389: debug_log('In QPR_PRICE_NEGOTIATION_PUB.initiate_deal');
390: debug_log('Quote origin: '||source_id);
391: debug_log('Quote header ID: '||source_ref_id);
454: debug_log('Failed rules descriptions: '||p_rules_desc);
455: exception
456: WHEN FND_API.G_EXC_ERROR THEN
457: x_return_status := FND_API.G_RET_STS_ERROR ;
458: FND_MSG_PUB.Count_And_Get
459: ( p_encoded => 'F',
460: p_count => x_msg_count,
461: p_data => x_mesg_data
462: );
461: p_data => x_mesg_data
462: );
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
465: FND_MSG_PUB.Count_And_Get
466: ( p_encoded => 'F',
467: p_count => x_msg_count,
468: p_data => x_mesg_data
469: );
468: p_data => x_mesg_data
469: );
470: WHEN OTHERS THEN
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
472: FND_MSG_PUB.Count_And_Get
473: ( p_encoded => 'F',
474: p_count => x_msg_count,
475: p_data => x_mesg_data
476: );