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.QP_QP_FORM_CURR_DETAILS dependencies on FND_API

Line 148: , p_init_msg_list => FND_API.G_TRUE

144: -- oe_debug_pub.add('BEF CDT F package; l_x_CURR_LISTS_rec.currency_header_id : '||l_x_CURR_LISTS_rec.currency_header_id);
145: -- oe_debug_pub.add('l_CURR_LISTS_rec.currency_header_id : '||l_CURR_DETAILS_rec.currency_header_id);
146: QP_Currency_PVT.Process_Currency
147: ( p_api_version_number => 1.0
148: , p_init_msg_list => FND_API.G_TRUE
149: , x_return_status => l_return_status
150: , x_msg_count => x_msg_count
151: , x_msg_data => x_msg_data
152: , p_control_rec => l_control_rec

Line 160: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

156: );
157: -- oe_debug_pub.add('AFT CDT F package; currency_header_id: '||l_x_CURR_DETAILS_tbl(1).currency_header_id);
158:
159:
160: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157: -- oe_debug_pub.add('AFT CDT F package; currency_header_id: '||l_x_CURR_DETAILS_tbl(1).currency_header_id);
158:
159:
160: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:

Line 162: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

158:
159:
160: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166:

Line 163: RAISE FND_API.G_EXC_ERROR;

159:
160: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166:
167: -- Unload out tbl

Line 225: l_x_CURR_DETAILS_rec.db_flag := FND_API.G_FALSE;

221:
222: -- Write to cache.
223: -- Set db_flag to False before writing to cache
224:
225: l_x_CURR_DETAILS_rec.db_flag := FND_API.G_FALSE;
226:
227: Write_CURR_DETAILS
228: ( p_CURR_DETAILS_rec => l_x_CURR_DETAILS_rec
229: );

Line 233: x_return_status := FND_API.G_RET_STS_SUCCESS;

229: );
230:
231: -- Set return status.
232:
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234:
235: -- Get message count and data
236:
237: OE_MSG_PUB.Count_And_Get

Line 245: WHEN FND_API.G_EXC_ERROR THEN

241:
242:
243: EXCEPTION
244:
245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: -- Get message count and data

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

243: EXCEPTION
244:
245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: -- Get message count and data
250:
251: OE_MSG_PUB.Count_And_Get

Line 256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

252: ( p_count => x_msg_count
253: , p_data => x_msg_data
254: );
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257:
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259:
260: -- Get message count and data

Line 258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

254: );
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257:
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259:
260: -- Get message count and data
261:
262: OE_MSG_PUB.Count_And_Get

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

265: );
266:
267: WHEN OTHERS THEN
268:
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270:
271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: OE_MSG_PUB.Add_Exc_Msg

Line 485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

481: , 'Unrecognized attribute'
482: );
483: END IF;
484:
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486:
487: END IF;
488:
489: -- Set Operation.

Line 491: IF FND_API.To_Boolean(l_CURR_DETAILS_rec.db_flag) THEN

487: END IF;
488:
489: -- Set Operation.
490:
491: IF FND_API.To_Boolean(l_CURR_DETAILS_rec.db_flag) THEN
492: l_CURR_DETAILS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
493: ELSE
494: l_CURR_DETAILS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
495: END IF;

Line 506: , p_init_msg_list => FND_API.G_TRUE

502: -- Call QP_Currency_PVT.Process_Currency
503:
504: QP_Currency_PVT.Process_Currency
505: ( p_api_version_number => 1.0
506: , p_init_msg_list => FND_API.G_TRUE
507: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
508: , x_return_status => l_return_status
509: , x_msg_count => x_msg_count
510: , x_msg_data => x_msg_data

Line 507: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

503:
504: QP_Currency_PVT.Process_Currency
505: ( p_api_version_number => 1.0
506: , p_init_msg_list => FND_API.G_TRUE
507: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
508: , x_return_status => l_return_status
509: , x_msg_count => x_msg_count
510: , x_msg_data => x_msg_data
511: , p_control_rec => l_control_rec

Line 520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

516: );
517:
518: -- oe_debug_pub.add(' Insdie F package inside Change_Attributes; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
519:
520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;

Line 521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

517:
518: -- oe_debug_pub.add(' Insdie F package inside Change_Attributes; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
519:
520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;
525:

Line 522: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

518: -- oe_debug_pub.add(' Insdie F package inside Change_Attributes; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
519:
520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;
525:
526:

Line 523: RAISE FND_API.G_EXC_ERROR;

519:
520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;
525:
526:
527: -- Unload out tbl

Line 533: x_attribute1 := FND_API.G_MISS_CHAR;

529: l_x_CURR_DETAILS_rec := l_x_CURR_DETAILS_tbl(1);
530:
531: -- Init OUT parameters to missing.
532:
533: x_attribute1 := FND_API.G_MISS_CHAR;
534: x_attribute10 := FND_API.G_MISS_CHAR;
535: x_attribute11 := FND_API.G_MISS_CHAR;
536: x_attribute12 := FND_API.G_MISS_CHAR;
537: x_attribute13 := FND_API.G_MISS_CHAR;

Line 534: x_attribute10 := FND_API.G_MISS_CHAR;

530:
531: -- Init OUT parameters to missing.
532:
533: x_attribute1 := FND_API.G_MISS_CHAR;
534: x_attribute10 := FND_API.G_MISS_CHAR;
535: x_attribute11 := FND_API.G_MISS_CHAR;
536: x_attribute12 := FND_API.G_MISS_CHAR;
537: x_attribute13 := FND_API.G_MISS_CHAR;
538: x_attribute14 := FND_API.G_MISS_CHAR;

Line 535: x_attribute11 := FND_API.G_MISS_CHAR;

531: -- Init OUT parameters to missing.
532:
533: x_attribute1 := FND_API.G_MISS_CHAR;
534: x_attribute10 := FND_API.G_MISS_CHAR;
535: x_attribute11 := FND_API.G_MISS_CHAR;
536: x_attribute12 := FND_API.G_MISS_CHAR;
537: x_attribute13 := FND_API.G_MISS_CHAR;
538: x_attribute14 := FND_API.G_MISS_CHAR;
539: x_attribute15 := FND_API.G_MISS_CHAR;

Line 536: x_attribute12 := FND_API.G_MISS_CHAR;

532:
533: x_attribute1 := FND_API.G_MISS_CHAR;
534: x_attribute10 := FND_API.G_MISS_CHAR;
535: x_attribute11 := FND_API.G_MISS_CHAR;
536: x_attribute12 := FND_API.G_MISS_CHAR;
537: x_attribute13 := FND_API.G_MISS_CHAR;
538: x_attribute14 := FND_API.G_MISS_CHAR;
539: x_attribute15 := FND_API.G_MISS_CHAR;
540: x_attribute2 := FND_API.G_MISS_CHAR;

Line 537: x_attribute13 := FND_API.G_MISS_CHAR;

533: x_attribute1 := FND_API.G_MISS_CHAR;
534: x_attribute10 := FND_API.G_MISS_CHAR;
535: x_attribute11 := FND_API.G_MISS_CHAR;
536: x_attribute12 := FND_API.G_MISS_CHAR;
537: x_attribute13 := FND_API.G_MISS_CHAR;
538: x_attribute14 := FND_API.G_MISS_CHAR;
539: x_attribute15 := FND_API.G_MISS_CHAR;
540: x_attribute2 := FND_API.G_MISS_CHAR;
541: x_attribute3 := FND_API.G_MISS_CHAR;

Line 538: x_attribute14 := FND_API.G_MISS_CHAR;

534: x_attribute10 := FND_API.G_MISS_CHAR;
535: x_attribute11 := FND_API.G_MISS_CHAR;
536: x_attribute12 := FND_API.G_MISS_CHAR;
537: x_attribute13 := FND_API.G_MISS_CHAR;
538: x_attribute14 := FND_API.G_MISS_CHAR;
539: x_attribute15 := FND_API.G_MISS_CHAR;
540: x_attribute2 := FND_API.G_MISS_CHAR;
541: x_attribute3 := FND_API.G_MISS_CHAR;
542: x_attribute4 := FND_API.G_MISS_CHAR;

Line 539: x_attribute15 := FND_API.G_MISS_CHAR;

535: x_attribute11 := FND_API.G_MISS_CHAR;
536: x_attribute12 := FND_API.G_MISS_CHAR;
537: x_attribute13 := FND_API.G_MISS_CHAR;
538: x_attribute14 := FND_API.G_MISS_CHAR;
539: x_attribute15 := FND_API.G_MISS_CHAR;
540: x_attribute2 := FND_API.G_MISS_CHAR;
541: x_attribute3 := FND_API.G_MISS_CHAR;
542: x_attribute4 := FND_API.G_MISS_CHAR;
543: x_attribute5 := FND_API.G_MISS_CHAR;

Line 540: x_attribute2 := FND_API.G_MISS_CHAR;

536: x_attribute12 := FND_API.G_MISS_CHAR;
537: x_attribute13 := FND_API.G_MISS_CHAR;
538: x_attribute14 := FND_API.G_MISS_CHAR;
539: x_attribute15 := FND_API.G_MISS_CHAR;
540: x_attribute2 := FND_API.G_MISS_CHAR;
541: x_attribute3 := FND_API.G_MISS_CHAR;
542: x_attribute4 := FND_API.G_MISS_CHAR;
543: x_attribute5 := FND_API.G_MISS_CHAR;
544: x_attribute6 := FND_API.G_MISS_CHAR;

Line 541: x_attribute3 := FND_API.G_MISS_CHAR;

537: x_attribute13 := FND_API.G_MISS_CHAR;
538: x_attribute14 := FND_API.G_MISS_CHAR;
539: x_attribute15 := FND_API.G_MISS_CHAR;
540: x_attribute2 := FND_API.G_MISS_CHAR;
541: x_attribute3 := FND_API.G_MISS_CHAR;
542: x_attribute4 := FND_API.G_MISS_CHAR;
543: x_attribute5 := FND_API.G_MISS_CHAR;
544: x_attribute6 := FND_API.G_MISS_CHAR;
545: x_attribute7 := FND_API.G_MISS_CHAR;

Line 542: x_attribute4 := FND_API.G_MISS_CHAR;

538: x_attribute14 := FND_API.G_MISS_CHAR;
539: x_attribute15 := FND_API.G_MISS_CHAR;
540: x_attribute2 := FND_API.G_MISS_CHAR;
541: x_attribute3 := FND_API.G_MISS_CHAR;
542: x_attribute4 := FND_API.G_MISS_CHAR;
543: x_attribute5 := FND_API.G_MISS_CHAR;
544: x_attribute6 := FND_API.G_MISS_CHAR;
545: x_attribute7 := FND_API.G_MISS_CHAR;
546: x_attribute8 := FND_API.G_MISS_CHAR;

Line 543: x_attribute5 := FND_API.G_MISS_CHAR;

539: x_attribute15 := FND_API.G_MISS_CHAR;
540: x_attribute2 := FND_API.G_MISS_CHAR;
541: x_attribute3 := FND_API.G_MISS_CHAR;
542: x_attribute4 := FND_API.G_MISS_CHAR;
543: x_attribute5 := FND_API.G_MISS_CHAR;
544: x_attribute6 := FND_API.G_MISS_CHAR;
545: x_attribute7 := FND_API.G_MISS_CHAR;
546: x_attribute8 := FND_API.G_MISS_CHAR;
547: x_attribute9 := FND_API.G_MISS_CHAR;

Line 544: x_attribute6 := FND_API.G_MISS_CHAR;

540: x_attribute2 := FND_API.G_MISS_CHAR;
541: x_attribute3 := FND_API.G_MISS_CHAR;
542: x_attribute4 := FND_API.G_MISS_CHAR;
543: x_attribute5 := FND_API.G_MISS_CHAR;
544: x_attribute6 := FND_API.G_MISS_CHAR;
545: x_attribute7 := FND_API.G_MISS_CHAR;
546: x_attribute8 := FND_API.G_MISS_CHAR;
547: x_attribute9 := FND_API.G_MISS_CHAR;
548: x_context := FND_API.G_MISS_CHAR;

Line 545: x_attribute7 := FND_API.G_MISS_CHAR;

541: x_attribute3 := FND_API.G_MISS_CHAR;
542: x_attribute4 := FND_API.G_MISS_CHAR;
543: x_attribute5 := FND_API.G_MISS_CHAR;
544: x_attribute6 := FND_API.G_MISS_CHAR;
545: x_attribute7 := FND_API.G_MISS_CHAR;
546: x_attribute8 := FND_API.G_MISS_CHAR;
547: x_attribute9 := FND_API.G_MISS_CHAR;
548: x_context := FND_API.G_MISS_CHAR;
549: x_conversion_date := FND_API.G_MISS_DATE;

Line 546: x_attribute8 := FND_API.G_MISS_CHAR;

542: x_attribute4 := FND_API.G_MISS_CHAR;
543: x_attribute5 := FND_API.G_MISS_CHAR;
544: x_attribute6 := FND_API.G_MISS_CHAR;
545: x_attribute7 := FND_API.G_MISS_CHAR;
546: x_attribute8 := FND_API.G_MISS_CHAR;
547: x_attribute9 := FND_API.G_MISS_CHAR;
548: x_context := FND_API.G_MISS_CHAR;
549: x_conversion_date := FND_API.G_MISS_DATE;
550: x_conversion_date_type := FND_API.G_MISS_CHAR;

Line 547: x_attribute9 := FND_API.G_MISS_CHAR;

543: x_attribute5 := FND_API.G_MISS_CHAR;
544: x_attribute6 := FND_API.G_MISS_CHAR;
545: x_attribute7 := FND_API.G_MISS_CHAR;
546: x_attribute8 := FND_API.G_MISS_CHAR;
547: x_attribute9 := FND_API.G_MISS_CHAR;
548: x_context := FND_API.G_MISS_CHAR;
549: x_conversion_date := FND_API.G_MISS_DATE;
550: x_conversion_date_type := FND_API.G_MISS_CHAR;
551: --x_conversion_method := FND_API.G_MISS_CHAR;

Line 548: x_context := FND_API.G_MISS_CHAR;

544: x_attribute6 := FND_API.G_MISS_CHAR;
545: x_attribute7 := FND_API.G_MISS_CHAR;
546: x_attribute8 := FND_API.G_MISS_CHAR;
547: x_attribute9 := FND_API.G_MISS_CHAR;
548: x_context := FND_API.G_MISS_CHAR;
549: x_conversion_date := FND_API.G_MISS_DATE;
550: x_conversion_date_type := FND_API.G_MISS_CHAR;
551: --x_conversion_method := FND_API.G_MISS_CHAR;
552: x_conversion_type := FND_API.G_MISS_CHAR;

Line 549: x_conversion_date := FND_API.G_MISS_DATE;

545: x_attribute7 := FND_API.G_MISS_CHAR;
546: x_attribute8 := FND_API.G_MISS_CHAR;
547: x_attribute9 := FND_API.G_MISS_CHAR;
548: x_context := FND_API.G_MISS_CHAR;
549: x_conversion_date := FND_API.G_MISS_DATE;
550: x_conversion_date_type := FND_API.G_MISS_CHAR;
551: --x_conversion_method := FND_API.G_MISS_CHAR;
552: x_conversion_type := FND_API.G_MISS_CHAR;
553: x_currency_detail_id := FND_API.G_MISS_NUM;

Line 550: x_conversion_date_type := FND_API.G_MISS_CHAR;

546: x_attribute8 := FND_API.G_MISS_CHAR;
547: x_attribute9 := FND_API.G_MISS_CHAR;
548: x_context := FND_API.G_MISS_CHAR;
549: x_conversion_date := FND_API.G_MISS_DATE;
550: x_conversion_date_type := FND_API.G_MISS_CHAR;
551: --x_conversion_method := FND_API.G_MISS_CHAR;
552: x_conversion_type := FND_API.G_MISS_CHAR;
553: x_currency_detail_id := FND_API.G_MISS_NUM;
554: x_currency_header_id := FND_API.G_MISS_NUM;

Line 551: --x_conversion_method := FND_API.G_MISS_CHAR;

547: x_attribute9 := FND_API.G_MISS_CHAR;
548: x_context := FND_API.G_MISS_CHAR;
549: x_conversion_date := FND_API.G_MISS_DATE;
550: x_conversion_date_type := FND_API.G_MISS_CHAR;
551: --x_conversion_method := FND_API.G_MISS_CHAR;
552: x_conversion_type := FND_API.G_MISS_CHAR;
553: x_currency_detail_id := FND_API.G_MISS_NUM;
554: x_currency_header_id := FND_API.G_MISS_NUM;
555: x_end_date_active := FND_API.G_MISS_DATE;

Line 552: x_conversion_type := FND_API.G_MISS_CHAR;

548: x_context := FND_API.G_MISS_CHAR;
549: x_conversion_date := FND_API.G_MISS_DATE;
550: x_conversion_date_type := FND_API.G_MISS_CHAR;
551: --x_conversion_method := FND_API.G_MISS_CHAR;
552: x_conversion_type := FND_API.G_MISS_CHAR;
553: x_currency_detail_id := FND_API.G_MISS_NUM;
554: x_currency_header_id := FND_API.G_MISS_NUM;
555: x_end_date_active := FND_API.G_MISS_DATE;
556: x_fixed_value := FND_API.G_MISS_NUM;

Line 553: x_currency_detail_id := FND_API.G_MISS_NUM;

549: x_conversion_date := FND_API.G_MISS_DATE;
550: x_conversion_date_type := FND_API.G_MISS_CHAR;
551: --x_conversion_method := FND_API.G_MISS_CHAR;
552: x_conversion_type := FND_API.G_MISS_CHAR;
553: x_currency_detail_id := FND_API.G_MISS_NUM;
554: x_currency_header_id := FND_API.G_MISS_NUM;
555: x_end_date_active := FND_API.G_MISS_DATE;
556: x_fixed_value := FND_API.G_MISS_NUM;
557: x_markup_formula_id := FND_API.G_MISS_NUM;

Line 554: x_currency_header_id := FND_API.G_MISS_NUM;

550: x_conversion_date_type := FND_API.G_MISS_CHAR;
551: --x_conversion_method := FND_API.G_MISS_CHAR;
552: x_conversion_type := FND_API.G_MISS_CHAR;
553: x_currency_detail_id := FND_API.G_MISS_NUM;
554: x_currency_header_id := FND_API.G_MISS_NUM;
555: x_end_date_active := FND_API.G_MISS_DATE;
556: x_fixed_value := FND_API.G_MISS_NUM;
557: x_markup_formula_id := FND_API.G_MISS_NUM;
558: x_markup_operator := FND_API.G_MISS_CHAR;

Line 555: x_end_date_active := FND_API.G_MISS_DATE;

551: --x_conversion_method := FND_API.G_MISS_CHAR;
552: x_conversion_type := FND_API.G_MISS_CHAR;
553: x_currency_detail_id := FND_API.G_MISS_NUM;
554: x_currency_header_id := FND_API.G_MISS_NUM;
555: x_end_date_active := FND_API.G_MISS_DATE;
556: x_fixed_value := FND_API.G_MISS_NUM;
557: x_markup_formula_id := FND_API.G_MISS_NUM;
558: x_markup_operator := FND_API.G_MISS_CHAR;
559: x_markup_value := FND_API.G_MISS_NUM;

Line 556: x_fixed_value := FND_API.G_MISS_NUM;

552: x_conversion_type := FND_API.G_MISS_CHAR;
553: x_currency_detail_id := FND_API.G_MISS_NUM;
554: x_currency_header_id := FND_API.G_MISS_NUM;
555: x_end_date_active := FND_API.G_MISS_DATE;
556: x_fixed_value := FND_API.G_MISS_NUM;
557: x_markup_formula_id := FND_API.G_MISS_NUM;
558: x_markup_operator := FND_API.G_MISS_CHAR;
559: x_markup_value := FND_API.G_MISS_NUM;
560: x_price_formula_id := FND_API.G_MISS_NUM;

Line 557: x_markup_formula_id := FND_API.G_MISS_NUM;

553: x_currency_detail_id := FND_API.G_MISS_NUM;
554: x_currency_header_id := FND_API.G_MISS_NUM;
555: x_end_date_active := FND_API.G_MISS_DATE;
556: x_fixed_value := FND_API.G_MISS_NUM;
557: x_markup_formula_id := FND_API.G_MISS_NUM;
558: x_markup_operator := FND_API.G_MISS_CHAR;
559: x_markup_value := FND_API.G_MISS_NUM;
560: x_price_formula_id := FND_API.G_MISS_NUM;
561: x_rounding_factor := FND_API.G_MISS_NUM;

Line 558: x_markup_operator := FND_API.G_MISS_CHAR;

554: x_currency_header_id := FND_API.G_MISS_NUM;
555: x_end_date_active := FND_API.G_MISS_DATE;
556: x_fixed_value := FND_API.G_MISS_NUM;
557: x_markup_formula_id := FND_API.G_MISS_NUM;
558: x_markup_operator := FND_API.G_MISS_CHAR;
559: x_markup_value := FND_API.G_MISS_NUM;
560: x_price_formula_id := FND_API.G_MISS_NUM;
561: x_rounding_factor := FND_API.G_MISS_NUM;
562: x_selling_rounding_factor := FND_API.G_MISS_NUM;

Line 559: x_markup_value := FND_API.G_MISS_NUM;

555: x_end_date_active := FND_API.G_MISS_DATE;
556: x_fixed_value := FND_API.G_MISS_NUM;
557: x_markup_formula_id := FND_API.G_MISS_NUM;
558: x_markup_operator := FND_API.G_MISS_CHAR;
559: x_markup_value := FND_API.G_MISS_NUM;
560: x_price_formula_id := FND_API.G_MISS_NUM;
561: x_rounding_factor := FND_API.G_MISS_NUM;
562: x_selling_rounding_factor := FND_API.G_MISS_NUM;
563: x_start_date_active := FND_API.G_MISS_DATE;

Line 560: x_price_formula_id := FND_API.G_MISS_NUM;

556: x_fixed_value := FND_API.G_MISS_NUM;
557: x_markup_formula_id := FND_API.G_MISS_NUM;
558: x_markup_operator := FND_API.G_MISS_CHAR;
559: x_markup_value := FND_API.G_MISS_NUM;
560: x_price_formula_id := FND_API.G_MISS_NUM;
561: x_rounding_factor := FND_API.G_MISS_NUM;
562: x_selling_rounding_factor := FND_API.G_MISS_NUM;
563: x_start_date_active := FND_API.G_MISS_DATE;
564: x_to_currency_code := FND_API.G_MISS_CHAR;

Line 561: x_rounding_factor := FND_API.G_MISS_NUM;

557: x_markup_formula_id := FND_API.G_MISS_NUM;
558: x_markup_operator := FND_API.G_MISS_CHAR;
559: x_markup_value := FND_API.G_MISS_NUM;
560: x_price_formula_id := FND_API.G_MISS_NUM;
561: x_rounding_factor := FND_API.G_MISS_NUM;
562: x_selling_rounding_factor := FND_API.G_MISS_NUM;
563: x_start_date_active := FND_API.G_MISS_DATE;
564: x_to_currency_code := FND_API.G_MISS_CHAR;
565: x_currency_detail := FND_API.G_MISS_CHAR;

Line 562: x_selling_rounding_factor := FND_API.G_MISS_NUM;

558: x_markup_operator := FND_API.G_MISS_CHAR;
559: x_markup_value := FND_API.G_MISS_NUM;
560: x_price_formula_id := FND_API.G_MISS_NUM;
561: x_rounding_factor := FND_API.G_MISS_NUM;
562: x_selling_rounding_factor := FND_API.G_MISS_NUM;
563: x_start_date_active := FND_API.G_MISS_DATE;
564: x_to_currency_code := FND_API.G_MISS_CHAR;
565: x_currency_detail := FND_API.G_MISS_CHAR;
566: x_currency_header := FND_API.G_MISS_CHAR;

Line 563: x_start_date_active := FND_API.G_MISS_DATE;

559: x_markup_value := FND_API.G_MISS_NUM;
560: x_price_formula_id := FND_API.G_MISS_NUM;
561: x_rounding_factor := FND_API.G_MISS_NUM;
562: x_selling_rounding_factor := FND_API.G_MISS_NUM;
563: x_start_date_active := FND_API.G_MISS_DATE;
564: x_to_currency_code := FND_API.G_MISS_CHAR;
565: x_currency_detail := FND_API.G_MISS_CHAR;
566: x_currency_header := FND_API.G_MISS_CHAR;
567: x_markup_formula := FND_API.G_MISS_CHAR;

Line 564: x_to_currency_code := FND_API.G_MISS_CHAR;

560: x_price_formula_id := FND_API.G_MISS_NUM;
561: x_rounding_factor := FND_API.G_MISS_NUM;
562: x_selling_rounding_factor := FND_API.G_MISS_NUM;
563: x_start_date_active := FND_API.G_MISS_DATE;
564: x_to_currency_code := FND_API.G_MISS_CHAR;
565: x_currency_detail := FND_API.G_MISS_CHAR;
566: x_currency_header := FND_API.G_MISS_CHAR;
567: x_markup_formula := FND_API.G_MISS_CHAR;
568: x_price_formula := FND_API.G_MISS_CHAR;

Line 565: x_currency_detail := FND_API.G_MISS_CHAR;

561: x_rounding_factor := FND_API.G_MISS_NUM;
562: x_selling_rounding_factor := FND_API.G_MISS_NUM;
563: x_start_date_active := FND_API.G_MISS_DATE;
564: x_to_currency_code := FND_API.G_MISS_CHAR;
565: x_currency_detail := FND_API.G_MISS_CHAR;
566: x_currency_header := FND_API.G_MISS_CHAR;
567: x_markup_formula := FND_API.G_MISS_CHAR;
568: x_price_formula := FND_API.G_MISS_CHAR;
569: x_to_currency := FND_API.G_MISS_CHAR;

Line 566: x_currency_header := FND_API.G_MISS_CHAR;

562: x_selling_rounding_factor := FND_API.G_MISS_NUM;
563: x_start_date_active := FND_API.G_MISS_DATE;
564: x_to_currency_code := FND_API.G_MISS_CHAR;
565: x_currency_detail := FND_API.G_MISS_CHAR;
566: x_currency_header := FND_API.G_MISS_CHAR;
567: x_markup_formula := FND_API.G_MISS_CHAR;
568: x_price_formula := FND_API.G_MISS_CHAR;
569: x_to_currency := FND_API.G_MISS_CHAR;
570: x_curr_attribute_type := FND_API.G_MISS_CHAR;

Line 567: x_markup_formula := FND_API.G_MISS_CHAR;

563: x_start_date_active := FND_API.G_MISS_DATE;
564: x_to_currency_code := FND_API.G_MISS_CHAR;
565: x_currency_detail := FND_API.G_MISS_CHAR;
566: x_currency_header := FND_API.G_MISS_CHAR;
567: x_markup_formula := FND_API.G_MISS_CHAR;
568: x_price_formula := FND_API.G_MISS_CHAR;
569: x_to_currency := FND_API.G_MISS_CHAR;
570: x_curr_attribute_type := FND_API.G_MISS_CHAR;
571: x_curr_attribute_context := FND_API.G_MISS_CHAR;

Line 568: x_price_formula := FND_API.G_MISS_CHAR;

564: x_to_currency_code := FND_API.G_MISS_CHAR;
565: x_currency_detail := FND_API.G_MISS_CHAR;
566: x_currency_header := FND_API.G_MISS_CHAR;
567: x_markup_formula := FND_API.G_MISS_CHAR;
568: x_price_formula := FND_API.G_MISS_CHAR;
569: x_to_currency := FND_API.G_MISS_CHAR;
570: x_curr_attribute_type := FND_API.G_MISS_CHAR;
571: x_curr_attribute_context := FND_API.G_MISS_CHAR;
572: x_curr_attribute := FND_API.G_MISS_CHAR;

Line 569: x_to_currency := FND_API.G_MISS_CHAR;

565: x_currency_detail := FND_API.G_MISS_CHAR;
566: x_currency_header := FND_API.G_MISS_CHAR;
567: x_markup_formula := FND_API.G_MISS_CHAR;
568: x_price_formula := FND_API.G_MISS_CHAR;
569: x_to_currency := FND_API.G_MISS_CHAR;
570: x_curr_attribute_type := FND_API.G_MISS_CHAR;
571: x_curr_attribute_context := FND_API.G_MISS_CHAR;
572: x_curr_attribute := FND_API.G_MISS_CHAR;
573: x_curr_attribute_value := FND_API.G_MISS_CHAR;

Line 570: x_curr_attribute_type := FND_API.G_MISS_CHAR;

566: x_currency_header := FND_API.G_MISS_CHAR;
567: x_markup_formula := FND_API.G_MISS_CHAR;
568: x_price_formula := FND_API.G_MISS_CHAR;
569: x_to_currency := FND_API.G_MISS_CHAR;
570: x_curr_attribute_type := FND_API.G_MISS_CHAR;
571: x_curr_attribute_context := FND_API.G_MISS_CHAR;
572: x_curr_attribute := FND_API.G_MISS_CHAR;
573: x_curr_attribute_value := FND_API.G_MISS_CHAR;
574: x_precedence := FND_API.G_MISS_NUM;

Line 571: x_curr_attribute_context := FND_API.G_MISS_CHAR;

567: x_markup_formula := FND_API.G_MISS_CHAR;
568: x_price_formula := FND_API.G_MISS_CHAR;
569: x_to_currency := FND_API.G_MISS_CHAR;
570: x_curr_attribute_type := FND_API.G_MISS_CHAR;
571: x_curr_attribute_context := FND_API.G_MISS_CHAR;
572: x_curr_attribute := FND_API.G_MISS_CHAR;
573: x_curr_attribute_value := FND_API.G_MISS_CHAR;
574: x_precedence := FND_API.G_MISS_NUM;
575:

Line 572: x_curr_attribute := FND_API.G_MISS_CHAR;

568: x_price_formula := FND_API.G_MISS_CHAR;
569: x_to_currency := FND_API.G_MISS_CHAR;
570: x_curr_attribute_type := FND_API.G_MISS_CHAR;
571: x_curr_attribute_context := FND_API.G_MISS_CHAR;
572: x_curr_attribute := FND_API.G_MISS_CHAR;
573: x_curr_attribute_value := FND_API.G_MISS_CHAR;
574: x_precedence := FND_API.G_MISS_NUM;
575:
576: -- Load display out parameters if any

Line 573: x_curr_attribute_value := FND_API.G_MISS_CHAR;

569: x_to_currency := FND_API.G_MISS_CHAR;
570: x_curr_attribute_type := FND_API.G_MISS_CHAR;
571: x_curr_attribute_context := FND_API.G_MISS_CHAR;
572: x_curr_attribute := FND_API.G_MISS_CHAR;
573: x_curr_attribute_value := FND_API.G_MISS_CHAR;
574: x_precedence := FND_API.G_MISS_NUM;
575:
576: -- Load display out parameters if any
577:

Line 574: x_precedence := FND_API.G_MISS_NUM;

570: x_curr_attribute_type := FND_API.G_MISS_CHAR;
571: x_curr_attribute_context := FND_API.G_MISS_CHAR;
572: x_curr_attribute := FND_API.G_MISS_CHAR;
573: x_curr_attribute_value := FND_API.G_MISS_CHAR;
574: x_precedence := FND_API.G_MISS_NUM;
575:
576: -- Load display out parameters if any
577:
578: l_CURR_DETAILS_val_rec := QP_Curr_Details_Util.Get_Values

Line 823: x_return_status := FND_API.G_RET_STS_SUCCESS;

819: );
820:
821: -- Set return status.
822:
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825: -- Get message count and data
826:
827: OE_MSG_PUB.Count_And_Get

Line 835: WHEN FND_API.G_EXC_ERROR THEN

831:
832:
833: EXCEPTION
834:
835: WHEN FND_API.G_EXC_ERROR THEN
836:
837: x_return_status := FND_API.G_RET_STS_ERROR;
838:
839: -- Get message count and data

Line 837: x_return_status := FND_API.G_RET_STS_ERROR;

833: EXCEPTION
834:
835: WHEN FND_API.G_EXC_ERROR THEN
836:
837: x_return_status := FND_API.G_RET_STS_ERROR;
838:
839: -- Get message count and data
840:
841: OE_MSG_PUB.Count_And_Get

Line 846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

842: ( p_count => x_msg_count
843: , p_data => x_msg_data
844: );
845:
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847:
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
849:
850: -- Get message count and data

Line 848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

844: );
845:
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847:
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
849:
850: -- Get message count and data
851:
852: OE_MSG_PUB.Count_And_Get

Line 859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

855: );
856:
857: WHEN OTHERS THEN
858:
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
860:
861: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
862: THEN
863: OE_MSG_PUB.Add_Exc_Msg

Line 934: IF FND_API.To_Boolean(l_CURR_DETAILS_rec.db_flag) THEN

930: );
931:
932: -- Set Operation.
933:
934: IF FND_API.To_Boolean(l_CURR_DETAILS_rec.db_flag) THEN
935: l_CURR_DETAILS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
936: ELSE
937: l_CURR_DETAILS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
938: END IF;

Line 949: , p_init_msg_list => FND_API.G_TRUE

945: -- Call QP_Currency_PVT.Process_Currency
946:
947: QP_Currency_PVT.Process_Currency
948: ( p_api_version_number => 1.0
949: , p_init_msg_list => FND_API.G_TRUE
950: , x_return_status => l_return_status
951: , x_msg_count => x_msg_count
952: , x_msg_data => x_msg_data
953: , p_control_rec => l_control_rec

Line 962: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

958: );
959:
960: -- oe_debug_pub.add(' Insdie F package after V_A_W; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
961:
962: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
965: RAISE FND_API.G_EXC_ERROR;
966: END IF;

Line 963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

959:
960: -- oe_debug_pub.add(' Insdie F package after V_A_W; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
961:
962: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
965: RAISE FND_API.G_EXC_ERROR;
966: END IF;
967:

Line 964: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

960: -- oe_debug_pub.add(' Insdie F package after V_A_W; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
961:
962: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
965: RAISE FND_API.G_EXC_ERROR;
966: END IF;
967:
968:

Line 965: RAISE FND_API.G_EXC_ERROR;

961:
962: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
965: RAISE FND_API.G_EXC_ERROR;
966: END IF;
967:
968:
969: -- Load OUT parameters.

Line 990: x_return_status := FND_API.G_RET_STS_SUCCESS;

986:
987:
988: -- Set return status.
989:
990: x_return_status := FND_API.G_RET_STS_SUCCESS;
991:
992: -- Get message count and data
993:
994: OE_MSG_PUB.Count_And_Get

Line 1002: WHEN FND_API.G_EXC_ERROR THEN

998:
999:
1000: EXCEPTION
1001:
1002: WHEN FND_API.G_EXC_ERROR THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005:
1006: -- Get message count and data

Line 1004: x_return_status := FND_API.G_RET_STS_ERROR;

1000: EXCEPTION
1001:
1002: WHEN FND_API.G_EXC_ERROR THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005:
1006: -- Get message count and data
1007:
1008: OE_MSG_PUB.Count_And_Get

Line 1013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1009: ( p_count => x_msg_count
1010: , p_data => x_msg_data
1011: );
1012:
1013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1014:
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1016:
1017: -- Get message count and data

Line 1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1011: );
1012:
1013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1014:
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1016:
1017: -- Get message count and data
1018:
1019: OE_MSG_PUB.Count_And_Get

Line 1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1022: );
1023:
1024: WHEN OTHERS THEN
1025:
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1027:
1028: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1029: THEN
1030: OE_MSG_PUB.Add_Exc_Msg

Line 1098: , p_init_msg_list => FND_API.G_TRUE

1094: -- Call QP_Currency_PVT.Process_Currency
1095:
1096: QP_Currency_PVT.Process_Currency
1097: ( p_api_version_number => 1.0
1098: , p_init_msg_list => FND_API.G_TRUE
1099: , x_return_status => l_return_status
1100: , x_msg_count => x_msg_count
1101: , x_msg_data => x_msg_data
1102: , p_control_rec => l_control_rec

Line 1108: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1104: , x_CURR_LISTS_rec => l_x_CURR_LISTS_rec
1105: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
1106: );
1107:
1108: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1110: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;

Line 1109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1105: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
1106: );
1107:
1108: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1110: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113:

Line 1110: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1106: );
1107:
1108: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1110: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113:
1114:

Line 1111: RAISE FND_API.G_EXC_ERROR;

1107:
1108: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1110: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113:
1114:
1115: -- Clear CURR_DETAILS record cache

Line 1121: x_return_status := FND_API.G_RET_STS_SUCCESS;

1117: Clear_CURR_DETAILS;
1118:
1119: -- Set return status.
1120:
1121: x_return_status := FND_API.G_RET_STS_SUCCESS;
1122:
1123: -- Get message count and data
1124:
1125: OE_MSG_PUB.Count_And_Get

Line 1133: WHEN FND_API.G_EXC_ERROR THEN

1129:
1130:
1131: EXCEPTION
1132:
1133: WHEN FND_API.G_EXC_ERROR THEN
1134:
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136:
1137: -- Get message count and data

Line 1135: x_return_status := FND_API.G_RET_STS_ERROR;

1131: EXCEPTION
1132:
1133: WHEN FND_API.G_EXC_ERROR THEN
1134:
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136:
1137: -- Get message count and data
1138:
1139: OE_MSG_PUB.Count_And_Get

Line 1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1140: ( p_count => x_msg_count
1141: , p_data => x_msg_data
1142: );
1143:
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145:
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147:
1148: -- Get message count and data

Line 1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1142: );
1143:
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145:
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147:
1148: -- Get message count and data
1149:
1150: OE_MSG_PUB.Count_And_Get

Line 1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1153: );
1154:
1155: WHEN OTHERS THEN
1156:
1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1158:
1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: OE_MSG_PUB.Add_Exc_Msg

Line 1212: , p_init_msg_list => FND_API.G_TRUE

1208: -- Call QP_Currency_PVT.Process_Currency
1209:
1210: QP_Currency_PVT.Process_Currency
1211: ( p_api_version_number => 1.0
1212: , p_init_msg_list => FND_API.G_TRUE
1213: , x_return_status => l_return_status
1214: , x_msg_count => x_msg_count
1215: , x_msg_data => x_msg_data
1216: , p_control_rec => l_control_rec

Line 1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1217: , x_CURR_LISTS_rec => l_x_CURR_LISTS_rec
1218: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
1219: );
1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1223: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;

Line 1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1218: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
1219: );
1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1223: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;
1226:

Line 1223: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1219: );
1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1223: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;
1226:
1227:

Line 1224: RAISE FND_API.G_EXC_ERROR;

1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1223: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;
1226:
1227:
1228: -- Set return status.

Line 1230: x_return_status := FND_API.G_RET_STS_SUCCESS;

1226:
1227:
1228: -- Set return status.
1229:
1230: x_return_status := FND_API.G_RET_STS_SUCCESS;
1231:
1232: -- Get message count and data
1233:
1234: OE_MSG_PUB.Count_And_Get

Line 1242: WHEN FND_API.G_EXC_ERROR THEN

1238:
1239:
1240: EXCEPTION
1241:
1242: WHEN FND_API.G_EXC_ERROR THEN
1243:
1244: x_return_status := FND_API.G_RET_STS_ERROR;
1245:
1246: -- Get message count and data

Line 1244: x_return_status := FND_API.G_RET_STS_ERROR;

1240: EXCEPTION
1241:
1242: WHEN FND_API.G_EXC_ERROR THEN
1243:
1244: x_return_status := FND_API.G_RET_STS_ERROR;
1245:
1246: -- Get message count and data
1247:
1248: OE_MSG_PUB.Count_And_Get

Line 1253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1249: ( p_count => x_msg_count
1250: , p_data => x_msg_data
1251: );
1252:
1253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1254:
1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1256:
1257: -- Get message count and data

Line 1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1251: );
1252:
1253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1254:
1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1256:
1257: -- Get message count and data
1258:
1259: OE_MSG_PUB.Count_And_Get

Line 1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1262: );
1263:
1264: WHEN OTHERS THEN
1265:
1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1267:
1268: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1269: THEN
1270: OE_MSG_PUB.Add_Exc_Msg

Line 1408: , p_init_msg_list => FND_API.G_TRUE

1404: -- Call QP_Currency_PVT.Lock_Currency
1405:
1406: QP_Currency_PVT.Lock_Currency
1407: ( p_api_version_number => 1.0
1408: , p_init_msg_list => FND_API.G_TRUE
1409: , x_return_status => l_return_status
1410: , x_msg_count => x_msg_count
1411: , x_msg_data => x_msg_data
1412: , p_CURR_DETAILS_tbl => l_CURR_DETAILS_tbl

Line 1418: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1414: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
1415: );
1416: -- oe_debug_pub.add('after calling QP_Currency_PVT.Lock_Currency');
1417:
1418: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1419:
1420: -- Set DB flag and write record to cache.
1421:
1422: l_x_CURR_DETAILS_rec.db_flag := FND_API.G_TRUE;

Line 1422: l_x_CURR_DETAILS_rec.db_flag := FND_API.G_TRUE;

1418: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1419:
1420: -- Set DB flag and write record to cache.
1421:
1422: l_x_CURR_DETAILS_rec.db_flag := FND_API.G_TRUE;
1423:
1424: Write_CURR_DETAILS
1425: ( p_CURR_DETAILS_rec => l_x_CURR_DETAILS_rec
1426: , p_db_record => TRUE

Line 1455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1451: , 'Lock_Row'
1452: );
1453: END IF;
1454:
1455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1456:
1457: -- Get message count and data
1458:
1459: OE_MSG_PUB.Count_And_Get

Line 1504: g_CURR_DETAILS_rec.db_flag := FND_API.G_TRUE;

1500: g_CURR_DETAILS_rec := QP_Curr_Details_Util.Query_Row
1501: ( p_currency_detail_id => p_currency_detail_id
1502: );
1503:
1504: g_CURR_DETAILS_rec.db_flag := FND_API.G_TRUE;
1505:
1506: -- Load DB record
1507:
1508: g_db_CURR_DETAILS_rec := g_CURR_DETAILS_rec;