1: PACKAGE BODY QPR_PRICE_NEGOTIATION_PUB AS
2: /* $Header: QPRADEAPB.pls 120.22 2008/05/30 09:15:39 vinnaray ship $ */
3:
4: FUNCTION Get_QPR_Status RETURN VARCHAR2 IS
5:
44: --l_app_name varchar2(240);
45: PRAGMA AUTONOMOUS_TRANSACTION;
46: begin
47: g_origin := p_quote_origin;
48: debug_log('In QPR_PRICE_NEGOTIATION_PUB.create_pn_request');
49: debug_log('Quote origin: '||p_quote_origin);
50: debug_log('Quote header ID: '||p_quote_header_id);
51: debug_log('Quote header number: '||p_quote_number);
52: debug_log('Quote header version: '||p_quote_version);
123: is
124: l_response_status varchar2(20);
125: l_deal_id number;
126: begin
127: debug_log('In QPR_PRICE_NEGOTIATION_PUB.get_pn_approval_status');
128: debug_log('Quote origin: '||p_quote_origin);
129: debug_log('Quote header ID: '||p_quote_header_id);
130: -- debug_out('Quote origin: '||p_quote_origin);
131: -- debug_out('Quote header ID: '||p_quote_header_id);
219: l_ret varchar2(240);
220: l_mesg varchar2(240);
221: x_msg_count number;
222: begin
223: debug_log('In QPR_PRICE_NEGOTIATION_PUB.cancel_active_requests');
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225: qpr_deal_pvt.cancel_pn_request(p_quote_origin,
226: p_quote_header_id,
227: instance_id,
283: l_err varchar2(240);
284: begin
285: x_return_status := FND_API.G_RET_STS_SUCCESS;
286: g_origin := p_quote_origin;
287: debug_log('In QPR_PRICE_NEGOTIATION_PUB.create_request');
288: debug_log('Quote origin: '||p_quote_origin);
289: debug_log('Quote header ID: '||p_quote_header_id);
290: debug_log('Instance ID : '||p_instance_id);
291:
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);
392: debug_log('Instance ID : '||instance_id);
393: debug_log('Updatable : '||updatable);