DBA Data[Home] [Help]

APPS.QP_QP_FORM_CURR_LISTS dependencies on FND_API

Line 126: , p_init_msg_list => FND_API.G_TRUE

122: -- Call QP_Currency_PVT.Process_Currency
123:
124: QP_Currency_PVT.Process_Currency
125: ( p_api_version_number => 1.0
126: , p_init_msg_list => FND_API.G_TRUE
127: , x_return_status => l_return_status
128: , x_msg_count => x_msg_count
129: , x_msg_data => x_msg_data
130: , p_control_rec => l_control_rec

Line 137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

133: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
134: );
135: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Default_Attributes');
136:
137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134: );
135: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Default_Attributes');
136:
137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142:

Line 139: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

135: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Default_Attributes');
136:
137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142:
143:

Line 140: RAISE FND_API.G_EXC_ERROR;

136:
137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142:
143:
144: -- Load OUT parameters.

Line 185: l_x_CURR_LISTS_rec.db_flag := FND_API.G_FALSE;

181:
182: -- Write to cache.
183: -- Set db_flag to False before writing to cache
184:
185: l_x_CURR_LISTS_rec.db_flag := FND_API.G_FALSE;
186:
187: Write_CURR_LISTS
188: ( p_CURR_LISTS_rec => l_x_CURR_LISTS_rec
189: );

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: );
190:
191: -- Set return status.
192:
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194:
195: -- Get message count and data
196:
197: OE_MSG_PUB.Count_And_Get

Line 205: WHEN FND_API.G_EXC_ERROR THEN

201:
202:
203: EXCEPTION
204:
205: WHEN FND_API.G_EXC_ERROR THEN
206:
207: x_return_status := FND_API.G_RET_STS_ERROR;
208:
209: -- Get message count and data

Line 207: x_return_status := FND_API.G_RET_STS_ERROR;

203: EXCEPTION
204:
205: WHEN FND_API.G_EXC_ERROR THEN
206:
207: x_return_status := FND_API.G_RET_STS_ERROR;
208:
209: -- Get message count and data
210:
211: OE_MSG_PUB.Count_And_Get

Line 216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

212: ( p_count => x_msg_count
213: , p_data => x_msg_data
214: );
215:
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217:
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
219:
220: -- Get message count and data

Line 218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

214: );
215:
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217:
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
219:
220: -- Get message count and data
221:
222: OE_MSG_PUB.Count_And_Get

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

225: );
226:
227: WHEN OTHERS THEN
228:
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230:
231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
232: THEN
233: OE_MSG_PUB.Add_Exc_Msg

Line 413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

409: , 'Unrecognized attribute'
410: );
411: END IF;
412:
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414:
415: END IF;
416:
417: -- Set Operation.

Line 419: IF FND_API.To_Boolean(l_CURR_LISTS_rec.db_flag) THEN

415: END IF;
416:
417: -- Set Operation.
418:
419: IF FND_API.To_Boolean(l_CURR_LISTS_rec.db_flag) THEN
420: l_CURR_LISTS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
421: ELSE
422: l_CURR_LISTS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
423: END IF;

Line 430: , p_init_msg_list => FND_API.G_TRUE

426: -- oe_debug_pub.add('Calling QP_Currency_PVT.Process_Currency from F package; Change_Attribute');
427:
428: QP_Currency_PVT.Process_Currency
429: ( p_api_version_number => 1.0
430: , p_init_msg_list => FND_API.G_TRUE
431: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
432: , x_return_status => l_return_status
433: , x_msg_count => x_msg_count
434: , x_msg_data => x_msg_data

Line 431: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

427:
428: QP_Currency_PVT.Process_Currency
429: ( p_api_version_number => 1.0
430: , p_init_msg_list => FND_API.G_TRUE
431: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
432: , x_return_status => l_return_status
433: , x_msg_count => x_msg_count
434: , x_msg_data => x_msg_data
435: , p_control_rec => l_control_rec

Line 445: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

441: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Change_Attribute');
442: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Change_Attribute; l_x_CURR_LISTS_rec.base_markup_value: '||l_x_CURR_LISTS_rec.base_markup_value);
443: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Change_Attribute; l_x_CURR_LISTS_rec.Description: '||l_x_CURR_LISTS_rec.Description);
444:
445: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
447: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
448: RAISE FND_API.G_EXC_ERROR;
449: END IF;

Line 446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

442: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Change_Attribute; l_x_CURR_LISTS_rec.base_markup_value: '||l_x_CURR_LISTS_rec.base_markup_value);
443: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Change_Attribute; l_x_CURR_LISTS_rec.Description: '||l_x_CURR_LISTS_rec.Description);
444:
445: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
447: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
448: RAISE FND_API.G_EXC_ERROR;
449: END IF;
450:

Line 447: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

443: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Change_Attribute; l_x_CURR_LISTS_rec.Description: '||l_x_CURR_LISTS_rec.Description);
444:
445: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
447: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
448: RAISE FND_API.G_EXC_ERROR;
449: END IF;
450:
451:

Line 448: RAISE FND_API.G_EXC_ERROR;

444:
445: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
447: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
448: RAISE FND_API.G_EXC_ERROR;
449: END IF;
450:
451:
452: -- Init OUT parameters to missing.

Line 454: x_attribute1 := FND_API.G_MISS_CHAR;

450:
451:
452: -- Init OUT parameters to missing.
453:
454: x_attribute1 := FND_API.G_MISS_CHAR;
455: x_attribute10 := FND_API.G_MISS_CHAR;
456: x_attribute11 := FND_API.G_MISS_CHAR;
457: x_attribute12 := FND_API.G_MISS_CHAR;
458: x_attribute13 := FND_API.G_MISS_CHAR;

Line 455: x_attribute10 := FND_API.G_MISS_CHAR;

451:
452: -- Init OUT parameters to missing.
453:
454: x_attribute1 := FND_API.G_MISS_CHAR;
455: x_attribute10 := FND_API.G_MISS_CHAR;
456: x_attribute11 := FND_API.G_MISS_CHAR;
457: x_attribute12 := FND_API.G_MISS_CHAR;
458: x_attribute13 := FND_API.G_MISS_CHAR;
459: x_attribute14 := FND_API.G_MISS_CHAR;

Line 456: x_attribute11 := FND_API.G_MISS_CHAR;

452: -- Init OUT parameters to missing.
453:
454: x_attribute1 := FND_API.G_MISS_CHAR;
455: x_attribute10 := FND_API.G_MISS_CHAR;
456: x_attribute11 := FND_API.G_MISS_CHAR;
457: x_attribute12 := FND_API.G_MISS_CHAR;
458: x_attribute13 := FND_API.G_MISS_CHAR;
459: x_attribute14 := FND_API.G_MISS_CHAR;
460: x_attribute15 := FND_API.G_MISS_CHAR;

Line 457: x_attribute12 := FND_API.G_MISS_CHAR;

453:
454: x_attribute1 := FND_API.G_MISS_CHAR;
455: x_attribute10 := FND_API.G_MISS_CHAR;
456: x_attribute11 := FND_API.G_MISS_CHAR;
457: x_attribute12 := FND_API.G_MISS_CHAR;
458: x_attribute13 := FND_API.G_MISS_CHAR;
459: x_attribute14 := FND_API.G_MISS_CHAR;
460: x_attribute15 := FND_API.G_MISS_CHAR;
461: x_attribute2 := FND_API.G_MISS_CHAR;

Line 458: x_attribute13 := FND_API.G_MISS_CHAR;

454: x_attribute1 := FND_API.G_MISS_CHAR;
455: x_attribute10 := FND_API.G_MISS_CHAR;
456: x_attribute11 := FND_API.G_MISS_CHAR;
457: x_attribute12 := FND_API.G_MISS_CHAR;
458: x_attribute13 := FND_API.G_MISS_CHAR;
459: x_attribute14 := FND_API.G_MISS_CHAR;
460: x_attribute15 := FND_API.G_MISS_CHAR;
461: x_attribute2 := FND_API.G_MISS_CHAR;
462: x_attribute3 := FND_API.G_MISS_CHAR;

Line 459: x_attribute14 := FND_API.G_MISS_CHAR;

455: x_attribute10 := FND_API.G_MISS_CHAR;
456: x_attribute11 := FND_API.G_MISS_CHAR;
457: x_attribute12 := FND_API.G_MISS_CHAR;
458: x_attribute13 := FND_API.G_MISS_CHAR;
459: x_attribute14 := FND_API.G_MISS_CHAR;
460: x_attribute15 := FND_API.G_MISS_CHAR;
461: x_attribute2 := FND_API.G_MISS_CHAR;
462: x_attribute3 := FND_API.G_MISS_CHAR;
463: x_attribute4 := FND_API.G_MISS_CHAR;

Line 460: x_attribute15 := FND_API.G_MISS_CHAR;

456: x_attribute11 := FND_API.G_MISS_CHAR;
457: x_attribute12 := FND_API.G_MISS_CHAR;
458: x_attribute13 := FND_API.G_MISS_CHAR;
459: x_attribute14 := FND_API.G_MISS_CHAR;
460: x_attribute15 := FND_API.G_MISS_CHAR;
461: x_attribute2 := FND_API.G_MISS_CHAR;
462: x_attribute3 := FND_API.G_MISS_CHAR;
463: x_attribute4 := FND_API.G_MISS_CHAR;
464: x_attribute5 := FND_API.G_MISS_CHAR;

Line 461: x_attribute2 := FND_API.G_MISS_CHAR;

457: x_attribute12 := FND_API.G_MISS_CHAR;
458: x_attribute13 := FND_API.G_MISS_CHAR;
459: x_attribute14 := FND_API.G_MISS_CHAR;
460: x_attribute15 := FND_API.G_MISS_CHAR;
461: x_attribute2 := FND_API.G_MISS_CHAR;
462: x_attribute3 := FND_API.G_MISS_CHAR;
463: x_attribute4 := FND_API.G_MISS_CHAR;
464: x_attribute5 := FND_API.G_MISS_CHAR;
465: x_attribute6 := FND_API.G_MISS_CHAR;

Line 462: x_attribute3 := FND_API.G_MISS_CHAR;

458: x_attribute13 := FND_API.G_MISS_CHAR;
459: x_attribute14 := FND_API.G_MISS_CHAR;
460: x_attribute15 := FND_API.G_MISS_CHAR;
461: x_attribute2 := FND_API.G_MISS_CHAR;
462: x_attribute3 := FND_API.G_MISS_CHAR;
463: x_attribute4 := FND_API.G_MISS_CHAR;
464: x_attribute5 := FND_API.G_MISS_CHAR;
465: x_attribute6 := FND_API.G_MISS_CHAR;
466: x_attribute7 := FND_API.G_MISS_CHAR;

Line 463: x_attribute4 := FND_API.G_MISS_CHAR;

459: x_attribute14 := FND_API.G_MISS_CHAR;
460: x_attribute15 := FND_API.G_MISS_CHAR;
461: x_attribute2 := FND_API.G_MISS_CHAR;
462: x_attribute3 := FND_API.G_MISS_CHAR;
463: x_attribute4 := FND_API.G_MISS_CHAR;
464: x_attribute5 := FND_API.G_MISS_CHAR;
465: x_attribute6 := FND_API.G_MISS_CHAR;
466: x_attribute7 := FND_API.G_MISS_CHAR;
467: x_attribute8 := FND_API.G_MISS_CHAR;

Line 464: x_attribute5 := FND_API.G_MISS_CHAR;

460: x_attribute15 := FND_API.G_MISS_CHAR;
461: x_attribute2 := FND_API.G_MISS_CHAR;
462: x_attribute3 := FND_API.G_MISS_CHAR;
463: x_attribute4 := FND_API.G_MISS_CHAR;
464: x_attribute5 := FND_API.G_MISS_CHAR;
465: x_attribute6 := FND_API.G_MISS_CHAR;
466: x_attribute7 := FND_API.G_MISS_CHAR;
467: x_attribute8 := FND_API.G_MISS_CHAR;
468: x_attribute9 := FND_API.G_MISS_CHAR;

Line 465: x_attribute6 := FND_API.G_MISS_CHAR;

461: x_attribute2 := FND_API.G_MISS_CHAR;
462: x_attribute3 := FND_API.G_MISS_CHAR;
463: x_attribute4 := FND_API.G_MISS_CHAR;
464: x_attribute5 := FND_API.G_MISS_CHAR;
465: x_attribute6 := FND_API.G_MISS_CHAR;
466: x_attribute7 := FND_API.G_MISS_CHAR;
467: x_attribute8 := FND_API.G_MISS_CHAR;
468: x_attribute9 := FND_API.G_MISS_CHAR;
469: x_base_currency_code := FND_API.G_MISS_CHAR;

Line 466: x_attribute7 := FND_API.G_MISS_CHAR;

462: x_attribute3 := FND_API.G_MISS_CHAR;
463: x_attribute4 := FND_API.G_MISS_CHAR;
464: x_attribute5 := FND_API.G_MISS_CHAR;
465: x_attribute6 := FND_API.G_MISS_CHAR;
466: x_attribute7 := FND_API.G_MISS_CHAR;
467: x_attribute8 := FND_API.G_MISS_CHAR;
468: x_attribute9 := FND_API.G_MISS_CHAR;
469: x_base_currency_code := FND_API.G_MISS_CHAR;
470: x_context := FND_API.G_MISS_CHAR;

Line 467: x_attribute8 := FND_API.G_MISS_CHAR;

463: x_attribute4 := FND_API.G_MISS_CHAR;
464: x_attribute5 := FND_API.G_MISS_CHAR;
465: x_attribute6 := FND_API.G_MISS_CHAR;
466: x_attribute7 := FND_API.G_MISS_CHAR;
467: x_attribute8 := FND_API.G_MISS_CHAR;
468: x_attribute9 := FND_API.G_MISS_CHAR;
469: x_base_currency_code := FND_API.G_MISS_CHAR;
470: x_context := FND_API.G_MISS_CHAR;
471: x_currency_header_id := FND_API.G_MISS_NUM;

Line 468: x_attribute9 := FND_API.G_MISS_CHAR;

464: x_attribute5 := FND_API.G_MISS_CHAR;
465: x_attribute6 := FND_API.G_MISS_CHAR;
466: x_attribute7 := FND_API.G_MISS_CHAR;
467: x_attribute8 := FND_API.G_MISS_CHAR;
468: x_attribute9 := FND_API.G_MISS_CHAR;
469: x_base_currency_code := FND_API.G_MISS_CHAR;
470: x_context := FND_API.G_MISS_CHAR;
471: x_currency_header_id := FND_API.G_MISS_NUM;
472: x_description := FND_API.G_MISS_CHAR;

Line 469: x_base_currency_code := FND_API.G_MISS_CHAR;

465: x_attribute6 := FND_API.G_MISS_CHAR;
466: x_attribute7 := FND_API.G_MISS_CHAR;
467: x_attribute8 := FND_API.G_MISS_CHAR;
468: x_attribute9 := FND_API.G_MISS_CHAR;
469: x_base_currency_code := FND_API.G_MISS_CHAR;
470: x_context := FND_API.G_MISS_CHAR;
471: x_currency_header_id := FND_API.G_MISS_NUM;
472: x_description := FND_API.G_MISS_CHAR;
473: x_name := FND_API.G_MISS_CHAR;

Line 470: x_context := FND_API.G_MISS_CHAR;

466: x_attribute7 := FND_API.G_MISS_CHAR;
467: x_attribute8 := FND_API.G_MISS_CHAR;
468: x_attribute9 := FND_API.G_MISS_CHAR;
469: x_base_currency_code := FND_API.G_MISS_CHAR;
470: x_context := FND_API.G_MISS_CHAR;
471: x_currency_header_id := FND_API.G_MISS_NUM;
472: x_description := FND_API.G_MISS_CHAR;
473: x_name := FND_API.G_MISS_CHAR;
474: -- x_row_id := FND_API.G_MISS_CHAR; -- Commented by Sunil

Line 471: x_currency_header_id := FND_API.G_MISS_NUM;

467: x_attribute8 := FND_API.G_MISS_CHAR;
468: x_attribute9 := FND_API.G_MISS_CHAR;
469: x_base_currency_code := FND_API.G_MISS_CHAR;
470: x_context := FND_API.G_MISS_CHAR;
471: x_currency_header_id := FND_API.G_MISS_NUM;
472: x_description := FND_API.G_MISS_CHAR;
473: x_name := FND_API.G_MISS_CHAR;
474: -- x_row_id := FND_API.G_MISS_CHAR; -- Commented by Sunil
475: x_base_currency := FND_API.G_MISS_CHAR;

Line 472: x_description := FND_API.G_MISS_CHAR;

468: x_attribute9 := FND_API.G_MISS_CHAR;
469: x_base_currency_code := FND_API.G_MISS_CHAR;
470: x_context := FND_API.G_MISS_CHAR;
471: x_currency_header_id := FND_API.G_MISS_NUM;
472: x_description := FND_API.G_MISS_CHAR;
473: x_name := FND_API.G_MISS_CHAR;
474: -- x_row_id := FND_API.G_MISS_CHAR; -- Commented by Sunil
475: x_base_currency := FND_API.G_MISS_CHAR;
476: x_currency_header := FND_API.G_MISS_CHAR;

Line 473: x_name := FND_API.G_MISS_CHAR;

469: x_base_currency_code := FND_API.G_MISS_CHAR;
470: x_context := FND_API.G_MISS_CHAR;
471: x_currency_header_id := FND_API.G_MISS_NUM;
472: x_description := FND_API.G_MISS_CHAR;
473: x_name := FND_API.G_MISS_CHAR;
474: -- x_row_id := FND_API.G_MISS_CHAR; -- Commented by Sunil
475: x_base_currency := FND_API.G_MISS_CHAR;
476: x_currency_header := FND_API.G_MISS_CHAR;
477: -- x_row := FND_API.G_MISS_CHAR;

Line 474: -- x_row_id := FND_API.G_MISS_CHAR; -- Commented by Sunil

470: x_context := FND_API.G_MISS_CHAR;
471: x_currency_header_id := FND_API.G_MISS_NUM;
472: x_description := FND_API.G_MISS_CHAR;
473: x_name := FND_API.G_MISS_CHAR;
474: -- x_row_id := FND_API.G_MISS_CHAR; -- Commented by Sunil
475: x_base_currency := FND_API.G_MISS_CHAR;
476: x_currency_header := FND_API.G_MISS_CHAR;
477: -- x_row := FND_API.G_MISS_CHAR;
478: x_base_rounding_factor := FND_API.G_MISS_NUM;

Line 475: x_base_currency := FND_API.G_MISS_CHAR;

471: x_currency_header_id := FND_API.G_MISS_NUM;
472: x_description := FND_API.G_MISS_CHAR;
473: x_name := FND_API.G_MISS_CHAR;
474: -- x_row_id := FND_API.G_MISS_CHAR; -- Commented by Sunil
475: x_base_currency := FND_API.G_MISS_CHAR;
476: x_currency_header := FND_API.G_MISS_CHAR;
477: -- x_row := FND_API.G_MISS_CHAR;
478: x_base_rounding_factor := FND_API.G_MISS_NUM;
479: x_base_markup_operator := FND_API.G_MISS_CHAR;

Line 476: x_currency_header := FND_API.G_MISS_CHAR;

472: x_description := FND_API.G_MISS_CHAR;
473: x_name := FND_API.G_MISS_CHAR;
474: -- x_row_id := FND_API.G_MISS_CHAR; -- Commented by Sunil
475: x_base_currency := FND_API.G_MISS_CHAR;
476: x_currency_header := FND_API.G_MISS_CHAR;
477: -- x_row := FND_API.G_MISS_CHAR;
478: x_base_rounding_factor := FND_API.G_MISS_NUM;
479: x_base_markup_operator := FND_API.G_MISS_CHAR;
480: x_base_markup_value := FND_API.G_MISS_NUM;

Line 477: -- x_row := FND_API.G_MISS_CHAR;

473: x_name := FND_API.G_MISS_CHAR;
474: -- x_row_id := FND_API.G_MISS_CHAR; -- Commented by Sunil
475: x_base_currency := FND_API.G_MISS_CHAR;
476: x_currency_header := FND_API.G_MISS_CHAR;
477: -- x_row := FND_API.G_MISS_CHAR;
478: x_base_rounding_factor := FND_API.G_MISS_NUM;
479: x_base_markup_operator := FND_API.G_MISS_CHAR;
480: x_base_markup_value := FND_API.G_MISS_NUM;
481: x_base_markup_formula_id := FND_API.G_MISS_NUM;

Line 478: x_base_rounding_factor := FND_API.G_MISS_NUM;

474: -- x_row_id := FND_API.G_MISS_CHAR; -- Commented by Sunil
475: x_base_currency := FND_API.G_MISS_CHAR;
476: x_currency_header := FND_API.G_MISS_CHAR;
477: -- x_row := FND_API.G_MISS_CHAR;
478: x_base_rounding_factor := FND_API.G_MISS_NUM;
479: x_base_markup_operator := FND_API.G_MISS_CHAR;
480: x_base_markup_value := FND_API.G_MISS_NUM;
481: x_base_markup_formula_id := FND_API.G_MISS_NUM;
482: x_base_markup_formula := FND_API.G_MISS_CHAR;

Line 479: x_base_markup_operator := FND_API.G_MISS_CHAR;

475: x_base_currency := FND_API.G_MISS_CHAR;
476: x_currency_header := FND_API.G_MISS_CHAR;
477: -- x_row := FND_API.G_MISS_CHAR;
478: x_base_rounding_factor := FND_API.G_MISS_NUM;
479: x_base_markup_operator := FND_API.G_MISS_CHAR;
480: x_base_markup_value := FND_API.G_MISS_NUM;
481: x_base_markup_formula_id := FND_API.G_MISS_NUM;
482: x_base_markup_formula := FND_API.G_MISS_CHAR;
483:

Line 480: x_base_markup_value := FND_API.G_MISS_NUM;

476: x_currency_header := FND_API.G_MISS_CHAR;
477: -- x_row := FND_API.G_MISS_CHAR;
478: x_base_rounding_factor := FND_API.G_MISS_NUM;
479: x_base_markup_operator := FND_API.G_MISS_CHAR;
480: x_base_markup_value := FND_API.G_MISS_NUM;
481: x_base_markup_formula_id := FND_API.G_MISS_NUM;
482: x_base_markup_formula := FND_API.G_MISS_CHAR;
483:
484:

Line 481: x_base_markup_formula_id := FND_API.G_MISS_NUM;

477: -- x_row := FND_API.G_MISS_CHAR;
478: x_base_rounding_factor := FND_API.G_MISS_NUM;
479: x_base_markup_operator := FND_API.G_MISS_CHAR;
480: x_base_markup_value := FND_API.G_MISS_NUM;
481: x_base_markup_formula_id := FND_API.G_MISS_NUM;
482: x_base_markup_formula := FND_API.G_MISS_CHAR;
483:
484:
485: -- oe_debug_pub.add('%%Inside F- Change_Attribute; CHECK-POINT-1');

Line 482: x_base_markup_formula := FND_API.G_MISS_CHAR;

478: x_base_rounding_factor := FND_API.G_MISS_NUM;
479: x_base_markup_operator := FND_API.G_MISS_CHAR;
480: x_base_markup_value := FND_API.G_MISS_NUM;
481: x_base_markup_formula_id := FND_API.G_MISS_NUM;
482: x_base_markup_formula := FND_API.G_MISS_CHAR;
483:
484:
485: -- oe_debug_pub.add('%%Inside F- Change_Attribute; CHECK-POINT-1');
486: -- Load display out parameters if any

Line 664: x_return_status := FND_API.G_RET_STS_SUCCESS;

660: );
661:
662: -- Set return status.
663:
664: x_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: -- Get message count and data
667:
668: OE_MSG_PUB.Count_And_Get

Line 676: WHEN FND_API.G_EXC_ERROR THEN

672:
673:
674: EXCEPTION
675:
676: WHEN FND_API.G_EXC_ERROR THEN
677:
678: x_return_status := FND_API.G_RET_STS_ERROR;
679:
680: -- Get message count and data

Line 678: x_return_status := FND_API.G_RET_STS_ERROR;

674: EXCEPTION
675:
676: WHEN FND_API.G_EXC_ERROR THEN
677:
678: x_return_status := FND_API.G_RET_STS_ERROR;
679:
680: -- Get message count and data
681:
682: OE_MSG_PUB.Count_And_Get

Line 687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

683: ( p_count => x_msg_count
684: , p_data => x_msg_data
685: );
686:
687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
688:
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690:
691: -- Get message count and data

Line 689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

685: );
686:
687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
688:
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690:
691: -- Get message count and data
692:
693: OE_MSG_PUB.Count_And_Get

Line 700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

696: );
697:
698: WHEN OTHERS THEN
699:
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701:
702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
703: THEN
704: OE_MSG_PUB.Add_Exc_Msg

Line 775: IF FND_API.To_Boolean(l_CURR_LISTS_rec.db_flag) THEN

771: -- oe_debug_pub.add('Inside QPXFCURB; After calling get_curr_lists; l_CURR_LISTS_rec.description: '||l_CURR_LISTS_rec.description);
772:
773: -- Set Operation.
774:
775: IF FND_API.To_Boolean(l_CURR_LISTS_rec.db_flag) THEN
776: l_CURR_LISTS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
777: ELSE
778: l_CURR_LISTS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
779: END IF;

Line 786: , p_init_msg_list => FND_API.G_TRUE

782:
783: -- oe_debug_pub.add('Calling QP_Currency_PVT.Process_Currency from F package; Validate_and_Write');
784: QP_Currency_PVT.Process_Currency
785: ( p_api_version_number => 1.0
786: , p_init_msg_list => FND_API.G_TRUE
787: , x_return_status => l_return_status
788: , x_msg_count => x_msg_count
789: , x_msg_data => x_msg_data
790: , p_control_rec => l_control_rec

Line 798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

794: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
795: );
796: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Validate_and_Write');
797:
798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;

Line 799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

795: );
796: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Validate_and_Write');
797:
798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803:

Line 800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

796: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Validate_and_Write');
797:
798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803:
804:

Line 801: RAISE FND_API.G_EXC_ERROR;

797:
798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803:
804:
805: -- Load OUT parameters.

Line 825: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 837: WHEN FND_API.G_EXC_ERROR THEN

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

Line 839: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 929: , p_init_msg_list => FND_API.G_TRUE

925: -- Call QP_Currency_PVT.Process_Currency
926:
927: QP_Currency_PVT.Process_Currency
928: ( p_api_version_number => 1.0
929: , p_init_msg_list => FND_API.G_TRUE
930: , x_return_status => l_return_status
931: , x_msg_count => x_msg_count
932: , x_msg_data => x_msg_data
933: , p_control_rec => l_control_rec

Line 940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

936: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
937: );
938: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Delete_Row');
939:
940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;

Line 941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

937: );
938: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Delete_Row');
939:
940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945:

Line 942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

938: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Delete_Row');
939:
940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945:
946:

Line 943: RAISE FND_API.G_EXC_ERROR;

939:
940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945:
946:
947: -- Clear CURR_LISTS record cache

Line 953: x_return_status := FND_API.G_RET_STS_SUCCESS;

949: Clear_CURR_LISTS;
950:
951: -- Set return status.
952:
953: x_return_status := FND_API.G_RET_STS_SUCCESS;
954:
955: -- Get message count and data
956:
957: OE_MSG_PUB.Count_And_Get

Line 965: WHEN FND_API.G_EXC_ERROR THEN

961:
962:
963: EXCEPTION
964:
965: WHEN FND_API.G_EXC_ERROR THEN
966:
967: x_return_status := FND_API.G_RET_STS_ERROR;
968:
969: -- Get message count and data

Line 967: x_return_status := FND_API.G_RET_STS_ERROR;

963: EXCEPTION
964:
965: WHEN FND_API.G_EXC_ERROR THEN
966:
967: x_return_status := FND_API.G_RET_STS_ERROR;
968:
969: -- Get message count and data
970:
971: OE_MSG_PUB.Count_And_Get

Line 976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

972: ( p_count => x_msg_count
973: , p_data => x_msg_data
974: );
975:
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977:
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
979:
980: -- Get message count and data

Line 978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

974: );
975:
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977:
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
979:
980: -- Get message count and data
981:
982: OE_MSG_PUB.Count_And_Get

Line 989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

985: );
986:
987: WHEN OTHERS THEN
988:
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
990:
991: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
992: THEN
993: OE_MSG_PUB.Add_Exc_Msg

Line 1045: , p_init_msg_list => FND_API.G_TRUE

1041: -- Call QP_Currency_PVT.Process_Currency
1042:
1043: QP_Currency_PVT.Process_Currency
1044: ( p_api_version_number => 1.0
1045: , p_init_msg_list => FND_API.G_TRUE
1046: , x_return_status => l_return_status
1047: , x_msg_count => x_msg_count
1048: , x_msg_data => x_msg_data
1049: , p_control_rec => l_control_rec

Line 1055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1051: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
1052: );
1053: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Process_Entity');
1054:
1055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;

Line 1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1052: );
1053: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Process_Entity');
1054:
1055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060:

Line 1057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1053: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Process_Entity');
1054:
1055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060:
1061:

Line 1058: RAISE FND_API.G_EXC_ERROR;

1054:
1055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060:
1061:
1062: -- Set return status.

Line 1064: x_return_status := FND_API.G_RET_STS_SUCCESS;

1060:
1061:
1062: -- Set return status.
1063:
1064: x_return_status := FND_API.G_RET_STS_SUCCESS;
1065:
1066: -- Get message count and data
1067:
1068: OE_MSG_PUB.Count_And_Get

Line 1076: WHEN FND_API.G_EXC_ERROR THEN

1072:
1073:
1074: EXCEPTION
1075:
1076: WHEN FND_API.G_EXC_ERROR THEN
1077:
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079:
1080: -- Get message count and data

Line 1078: x_return_status := FND_API.G_RET_STS_ERROR;

1074: EXCEPTION
1075:
1076: WHEN FND_API.G_EXC_ERROR THEN
1077:
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079:
1080: -- Get message count and data
1081:
1082: OE_MSG_PUB.Count_And_Get

Line 1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1083: ( p_count => x_msg_count
1084: , p_data => x_msg_data
1085: );
1086:
1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1088:
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1090:
1091: -- Get message count and data

Line 1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1085: );
1086:
1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1088:
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1090:
1091: -- Get message count and data
1092:
1093: OE_MSG_PUB.Count_And_Get

Line 1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1096: );
1097:
1098: WHEN OTHERS THEN
1099:
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1101:
1102: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1103: THEN
1104: OE_MSG_PUB.Add_Exc_Msg

Line 1156: , p_init_msg_list => FND_API.G_TRUE

1152: -- Call QP_Currency_PVT.Process_Currency
1153:
1154: QP_Currency_PVT.Process_Currency
1155: ( p_api_version_number => 1.0
1156: , p_init_msg_list => FND_API.G_TRUE
1157: , x_return_status => l_return_status
1158: , x_msg_count => x_msg_count
1159: , x_msg_data => x_msg_data
1160: , p_control_rec => l_control_rec

Line 1166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1162: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
1163: );
1164: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Process_Object');
1165:
1166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: END IF;

Line 1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1163: );
1164: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Process_Object');
1165:
1166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: END IF;
1171:

Line 1168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1164: -- oe_debug_pub.add('AFTER Calling QP_Currency_PVT.Process_Currency from F package; Process_Object');
1165:
1166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: END IF;
1171:
1172:

Line 1169: RAISE FND_API.G_EXC_ERROR;

1165:
1166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: END IF;
1171:
1172:
1173: -- Set return status.

Line 1175: x_return_status := FND_API.G_RET_STS_SUCCESS;

1171:
1172:
1173: -- Set return status.
1174:
1175: x_return_status := FND_API.G_RET_STS_SUCCESS;
1176:
1177: -- Get message count and data
1178:
1179: OE_MSG_PUB.Count_And_Get

Line 1187: WHEN FND_API.G_EXC_ERROR THEN

1183:
1184:
1185: EXCEPTION
1186:
1187: WHEN FND_API.G_EXC_ERROR THEN
1188:
1189: x_return_status := FND_API.G_RET_STS_ERROR;
1190:
1191: -- Get message count and data

Line 1189: x_return_status := FND_API.G_RET_STS_ERROR;

1185: EXCEPTION
1186:
1187: WHEN FND_API.G_EXC_ERROR THEN
1188:
1189: x_return_status := FND_API.G_RET_STS_ERROR;
1190:
1191: -- Get message count and data
1192:
1193: OE_MSG_PUB.Count_And_Get

Line 1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1194: ( p_count => x_msg_count
1195: , p_data => x_msg_data
1196: );
1197:
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199:
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1201:
1202: -- Get message count and data

Line 1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1196: );
1197:
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199:
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1201:
1202: -- Get message count and data
1203:
1204: OE_MSG_PUB.Count_And_Get

Line 1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1207: );
1208:
1209: WHEN OTHERS THEN
1210:
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1212:
1213: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1214: THEN
1215: OE_MSG_PUB.Add_Exc_Msg

Line 1323: , p_init_msg_list => FND_API.G_TRUE

1319: -- Call QP_Currency_PVT.Lock_Currency
1320:
1321: QP_Currency_PVT.Lock_Currency
1322: ( p_api_version_number => 1.0
1323: , p_init_msg_list => FND_API.G_TRUE
1324: , x_return_status => l_return_status
1325: , x_msg_count => x_msg_count
1326: , x_msg_data => x_msg_data
1327: , p_CURR_LISTS_rec => l_CURR_LISTS_rec

Line 1334: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1330: );
1331:
1332: -- oe_debug_pub.add('Inside QPXFCURB Lock_Row; l_return_status: '||l_return_status);
1333:
1334: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1335: -- oe_debug_pub.add('Inside QPXFCURB Lock_Row; p_base_markup_value: '||p_base_markup_value);
1336:
1337: -- Set DB flag and write record to cache.
1338:

Line 1339: l_x_CURR_LISTS_rec.db_flag := FND_API.G_TRUE;

1335: -- oe_debug_pub.add('Inside QPXFCURB Lock_Row; p_base_markup_value: '||p_base_markup_value);
1336:
1337: -- Set DB flag and write record to cache.
1338:
1339: l_x_CURR_LISTS_rec.db_flag := FND_API.G_TRUE;
1340:
1341: Write_CURR_LISTS
1342: ( p_CURR_LISTS_rec => l_x_CURR_LISTS_rec
1343: , p_db_record => TRUE

Line 1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1370: , 'Lock_Row'
1371: );
1372: END IF;
1373:
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375:
1376: -- Get message count and data
1377:
1378: OE_MSG_PUB.Count_And_Get

Line 1428: g_CURR_LISTS_rec.db_flag := FND_API.G_TRUE;

1424: g_CURR_LISTS_rec := QP_Curr_Lists_Util.Query_Row
1425: ( p_currency_header_id => p_currency_header_id
1426: );
1427:
1428: g_CURR_LISTS_rec.db_flag := FND_API.G_TRUE;
1429:
1430: -- Load DB record
1431:
1432: g_db_CURR_LISTS_rec := g_CURR_LISTS_rec;