161:
162: fnd_file.put_line(fnd_file.log, text);
163:
164: if (g_origin = 660 or g_origin = 697) then
165: qpr_deal_pvt.debug_ext_log(text, g_origin);
166: end if;
167:
168: /* if g_origin = 660 then
169: oe_debug_pub.add(text);
178: p_instance_id number)
179: return varchar2
180: is
181: begin
182: if (qpr_deal_pvt.has_active_requests(p_quote_origin,
183: p_quote_header_id,
184: p_instance_id)) then
185: return('Y');
186: else
196: p_instance_id number)
197: return varchar2
198: is
199: begin
200: if (qpr_deal_pvt.has_saved_requests(p_quote_origin,
201: p_quote_header_id,
202: p_instance_id)) then
203: return('Y');
204: else
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,
228: l_ret);
229: if l_ret <> FND_API.G_RET_STS_SUCCESS then
230: raise exe_severe_error;
231: end if;
232: --if not suppress_event then
233: if suppress_event = 'N' then-- 14153525
234: --qpr_deal_pvt.source_call_back(
235: qpr_deal_pvt.handle_request_event(
236: p_quote_origin,
237: p_quote_header_id,
238: null,
231: end if;
232: --if not suppress_event then
233: if suppress_event = 'N' then-- 14153525
234: --qpr_deal_pvt.source_call_back(
235: qpr_deal_pvt.handle_request_event(
236: p_quote_origin,
237: p_quote_header_id,
238: null,
239: null,
347: skip_search in boolean default true) return varchar2
348: is
349: l_dummy number;
350: begin
351: return(qpr_deal_pvt.get_redirect_function(p_quote_origin,
352: p_quote_header_id, instance_id, skip_search));
353: exception
354: when others then
355: return null;