eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QPR_PRICE_NEGOTIATION_PUB dependencies on FND_API

Line 13: IF G_PRODUCT_STATUS = FND_API.G_MISS_CHAR THEN

9: l_retval BOOLEAN;
10: BEGIN
11:
12:
13: IF G_PRODUCT_STATUS = FND_API.G_MISS_CHAR THEN
14:
15: l_retval := fnd_installation.get(l_application_id,l_application_id,
16: l_status,l_industry);
17:

Line 224: x_return_status := FND_API.G_RET_STS_SUCCESS;

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,
228: l_ret);

Line 229: if l_ret <> FND_API.G_RET_STS_SUCCESS then

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: --qpr_deal_pvt.source_call_back(

Line 242: if l_ret <> FND_API.G_RET_STS_SUCCESS then

238: null,
239: instance_id,
240: 'CANCELLED',
241: l_ret, x_mesg_data);
242: if l_ret <> FND_API.G_RET_STS_SUCCESS then
243: raise exe_severe_error;
244: end if;
245: end if;
246: exception

Line 247: WHEN FND_API.G_EXC_ERROR THEN

243: raise exe_severe_error;
244: end if;
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,

Line 248: x_return_status := FND_API.G_RET_STS_ERROR ;

244: end if;
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

Line 254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

250: ( p_encoded => 'F',
251: p_count => x_msg_count,
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,

Line 255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

251: p_count => x_msg_count,
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

Line 262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

258: p_count => x_msg_count,
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

Line 285: x_return_status := FND_API.G_RET_STS_SUCCESS;

281: l_response_id number;
282: l_ret number;
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);

Line 319: WHEN FND_API.G_EXC_ERROR THEN

315: raise exe_severe_error;
316: end if;
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,

Line 320: x_return_status := FND_API.G_RET_STS_ERROR ;

316: end if;
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

Line 326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

322: ( p_encoded => 'F',
323: p_count => x_msg_count,
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,

Line 327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

323: p_count => x_msg_count,
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

Line 334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

330: p_count => x_msg_count,
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

Line 395: x_return_status := FND_API.G_RET_STS_SUCCESS;

391: debug_log('Quote header ID: '||source_ref_id);
392: debug_log('Instance ID : '||instance_id);
393: debug_log('Updatable : '||updatable);
394:
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396: if has_active_requests(source_id, source_ref_id, instance_id) = 'Y' then
397: debug_log('There are active requests');
398: if nvl(updatable, 'Y') = 'Y' then
399: l_changed := QPR_LOAD_MEAS_DATA.is_source_quote_changed(l_err,

Line 412: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

408: if nvl(l_changed, 'Y') = 'Y' then
409: debug_log('The source document is changed');
410: cancel_active_requests( source_id, source_ref_id, instance_id,
411: true, x_return_status , x_mesg_data);
412: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
413: debug_log(x_mesg_data);
414: raise exe_severe_error;
415: end if;
416: debug_log('The current deal cancelled');

Line 420: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

416: debug_log('The current deal cancelled');
417: create_request(source_id, source_ref_id, instance_id,
418: true, p_is_deal_compliant, p_rules_desc,
419: x_return_status , x_mesg_data);
420: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
421: debug_log(x_mesg_data);
422: raise exe_severe_error;
423: end if;
424: debug_log('New deal created');

Line 446: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

442: else
443: create_request(source_id, source_ref_id, instance_id,
444: true, p_is_deal_compliant, p_rules_desc,
445: x_return_status , x_mesg_data);
446: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
447: debug_log(x_mesg_data);
448: raise exe_severe_error;
449: end if;
450: debug_log('New deal created');

Line 456: WHEN FND_API.G_EXC_ERROR THEN

452: redirect_function := get_redirect_function(source_id, source_ref_id, instance_id, true);
453: debug_log('Is Deal Compliant: '||p_is_deal_compliant);
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,

Line 457: x_return_status := FND_API.G_RET_STS_ERROR ;

453: debug_log('Is Deal Compliant: '||p_is_deal_compliant);
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

Line 463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

459: ( p_encoded => 'F',
460: p_count => x_msg_count,
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,

Line 464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

460: p_count => x_msg_count,
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

Line 471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

467: p_count => x_msg_count,
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