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: if suppress_event = 'N' then-- 14153525

Line 243: if l_ret <> FND_API.G_RET_STS_SUCCESS then

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

Line 248: WHEN FND_API.G_EXC_ERROR THEN

244: raise exe_severe_error;
245: end if;
246: end if;
247: exception
248: WHEN FND_API.G_EXC_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_ERROR ;
250: FND_MSG_PUB.Count_And_Get
251: ( p_encoded => 'F',
252: p_count => x_msg_count,

Line 249: x_return_status := FND_API.G_RET_STS_ERROR ;

245: end if;
246: end if;
247: exception
248: WHEN FND_API.G_EXC_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_ERROR ;
250: FND_MSG_PUB.Count_And_Get
251: ( p_encoded => 'F',
252: p_count => x_msg_count,
253: p_data => x_mesg_data

Line 255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

251: ( p_encoded => 'F',
252: p_count => x_msg_count,
253: p_data => x_mesg_data
254: );
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
257: FND_MSG_PUB.Count_And_Get
258: ( p_encoded => 'F',
259: p_count => x_msg_count,

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

252: p_count => x_msg_count,
253: p_data => x_mesg_data
254: );
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
257: FND_MSG_PUB.Count_And_Get
258: ( p_encoded => 'F',
259: p_count => x_msg_count,
260: p_data => x_mesg_data

Line 263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

259: p_count => x_msg_count,
260: p_data => x_mesg_data
261: );
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
264: FND_MSG_PUB.Count_And_Get
265: ( p_encoded => 'F',
266: p_count => x_msg_count,
267: p_data => x_mesg_data

Line 286: x_return_status := FND_API.G_RET_STS_SUCCESS;

282: l_response_id number;
283: l_ret number;
284: l_err varchar2(240);
285: begin
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287: g_origin := p_quote_origin;
288: debug_log('In QPR_PRICE_NEGOTIATION_PUB.create_request');
289: debug_log('Quote origin: '||p_quote_origin);
290: debug_log('Quote header ID: '||p_quote_header_id);

Line 320: WHEN FND_API.G_EXC_ERROR THEN

316: raise exe_severe_error;
317: end if;
318:
319: exception
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
323: ( p_encoded => 'F',
324: p_count => x_msg_count,

Line 321: x_return_status := FND_API.G_RET_STS_ERROR ;

317: end if;
318:
319: exception
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
323: ( p_encoded => 'F',
324: p_count => x_msg_count,
325: p_data => x_mesg_data

Line 327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

323: ( p_encoded => 'F',
324: p_count => x_msg_count,
325: p_data => x_mesg_data
326: );
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
329: FND_MSG_PUB.Count_And_Get
330: ( p_encoded => 'F',
331: p_count => x_msg_count,

Line 328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

324: p_count => x_msg_count,
325: p_data => x_mesg_data
326: );
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
329: FND_MSG_PUB.Count_And_Get
330: ( p_encoded => 'F',
331: p_count => x_msg_count,
332: p_data => x_mesg_data

Line 335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

331: p_count => x_msg_count,
332: p_data => x_mesg_data
333: );
334: WHEN OTHERS THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
336: FND_MSG_PUB.Count_And_Get
337: ( p_encoded => 'F',
338: p_count => x_msg_count,
339: p_data => x_mesg_data

Line 396: x_return_status := FND_API.G_RET_STS_SUCCESS;

392: debug_log('Quote header ID: '||source_ref_id);
393: debug_log('Instance ID : '||instance_id);
394: debug_log('Updatable : '||updatable);
395:
396: x_return_status := FND_API.G_RET_STS_SUCCESS;
397: if has_active_requests(source_id, source_ref_id, instance_id) = 'Y' then
398: debug_log('There are active requests');
399: if nvl(updatable, 'Y') = 'Y' then
400: --changes for bug 14080143 / 14153525

Line 415: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 423: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 449: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 459: WHEN FND_API.G_EXC_ERROR THEN

455: redirect_function := get_redirect_function(source_id, source_ref_id, instance_id, true);
456: debug_log('Is Deal Compliant: '||p_is_deal_compliant);
457: debug_log('Failed rules descriptions: '||p_rules_desc);
458: exception
459: WHEN FND_API.G_EXC_ERROR THEN
460: x_return_status := FND_API.G_RET_STS_ERROR ;
461: FND_MSG_PUB.Count_And_Get
462: ( p_encoded => 'F',
463: p_count => x_msg_count,

Line 460: x_return_status := FND_API.G_RET_STS_ERROR ;

456: debug_log('Is Deal Compliant: '||p_is_deal_compliant);
457: debug_log('Failed rules descriptions: '||p_rules_desc);
458: exception
459: WHEN FND_API.G_EXC_ERROR THEN
460: x_return_status := FND_API.G_RET_STS_ERROR ;
461: FND_MSG_PUB.Count_And_Get
462: ( p_encoded => 'F',
463: p_count => x_msg_count,
464: p_data => x_mesg_data

Line 466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

462: ( p_encoded => 'F',
463: p_count => x_msg_count,
464: p_data => x_mesg_data
465: );
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
468: FND_MSG_PUB.Count_And_Get
469: ( p_encoded => 'F',
470: p_count => x_msg_count,

Line 467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

463: p_count => x_msg_count,
464: p_data => x_mesg_data
465: );
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
468: FND_MSG_PUB.Count_And_Get
469: ( p_encoded => 'F',
470: p_count => x_msg_count,
471: p_data => x_mesg_data

Line 474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

470: p_count => x_msg_count,
471: p_data => x_mesg_data
472: );
473: WHEN OTHERS THEN
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
475: FND_MSG_PUB.Count_And_Get
476: ( p_encoded => 'F',
477: p_count => x_msg_count,
478: p_data => x_mesg_data