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_LIMIT_BALANCES dependencies on FND_API

Line 139: , p_init_msg_list => FND_API.G_TRUE

135: -- Call QP_Limits_PVT.Process_Limits
136:
137: QP_Limits_PVT.Process_Limits
138: ( p_api_version_number => 1.0
139: , p_init_msg_list => FND_API.G_TRUE
140: , x_return_status => l_return_status
141: , x_msg_count => x_msg_count
142: , x_msg_data => x_msg_data
143: , p_control_rec => l_control_rec

Line 150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

146: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
147: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
148: );
149:
150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

147: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
148: );
149:
150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155:

Line 152: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

148: );
149:
150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155:
156:

Line 153: RAISE FND_API.G_EXC_ERROR;

149:
150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155:
156:
157: -- Unload out tbl

Line 209: l_x_LIMIT_BALANCES_rec.db_flag := FND_API.G_FALSE;

205:
206: -- Write to cache.
207: -- Set db_flag to False before writing to cache
208:
209: l_x_LIMIT_BALANCES_rec.db_flag := FND_API.G_FALSE;
210:
211: Write_LIMIT_BALANCES
212: ( p_LIMIT_BALANCES_rec => l_x_LIMIT_BALANCES_rec
213: );

Line 217: x_return_status := FND_API.G_RET_STS_SUCCESS;

213: );
214:
215: -- Set return status.
216:
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218:
219: -- Get message count and data
220:
221: OE_MSG_PUB.Count_And_Get

Line 229: WHEN FND_API.G_EXC_ERROR THEN

225:
226:
227: EXCEPTION
228:
229: WHEN FND_API.G_EXC_ERROR THEN
230:
231: x_return_status := FND_API.G_RET_STS_ERROR;
232:
233: -- Get message count and data

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227: EXCEPTION
228:
229: WHEN FND_API.G_EXC_ERROR THEN
230:
231: x_return_status := FND_API.G_RET_STS_ERROR;
232:
233: -- Get message count and data
234:
235: OE_MSG_PUB.Count_And_Get

Line 240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

236: ( p_count => x_msg_count
237: , p_data => x_msg_data
238: );
239:
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241:
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243:
244: -- Get message count and data

Line 242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

238: );
239:
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241:
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243:
244: -- Get message count and data
245:
246: OE_MSG_PUB.Count_And_Get

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

249: );
250:
251: WHEN OTHERS THEN
252:
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254:
255: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: OE_MSG_PUB.Add_Exc_Msg

Line 458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

454: , 'Unrecognized attribute'
455: );
456: END IF;
457:
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459:
460: END IF;
461:
462: -- Set Operation.

Line 464: IF FND_API.To_Boolean(l_LIMIT_BALANCES_rec.db_flag) THEN

460: END IF;
461:
462: -- Set Operation.
463:
464: IF FND_API.To_Boolean(l_LIMIT_BALANCES_rec.db_flag) THEN
465: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
466: ELSE
467: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_CREATE;
468: END IF;

Line 479: , p_init_msg_list => FND_API.G_TRUE

475: -- Call QP_Limits_PVT.Process_Limits
476:
477: QP_Limits_PVT.Process_Limits
478: ( p_api_version_number => 1.0
479: , p_init_msg_list => FND_API.G_TRUE
480: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
481: , x_return_status => l_return_status
482: , x_msg_count => x_msg_count
483: , x_msg_data => x_msg_data

Line 480: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

476:
477: QP_Limits_PVT.Process_Limits
478: ( p_api_version_number => 1.0
479: , p_init_msg_list => FND_API.G_TRUE
480: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
481: , x_return_status => l_return_status
482: , x_msg_count => x_msg_count
483: , x_msg_data => x_msg_data
484: , p_control_rec => l_control_rec

Line 492: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

488: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
489: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
490: );
491:
492: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: END IF;

Line 493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

489: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
490: );
491:
492: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: END IF;
497:

Line 494: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

490: );
491:
492: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: END IF;
497:
498:

Line 495: RAISE FND_API.G_EXC_ERROR;

491:
492: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: END IF;
497:
498:
499: -- Unload out tbl

Line 505: x_attribute1 := FND_API.G_MISS_CHAR;

501: l_x_LIMIT_BALANCES_rec := l_x_LIMIT_BALANCES_tbl(1);
502:
503: -- Init OUT parameters to missing.
504:
505: x_attribute1 := FND_API.G_MISS_CHAR;
506: x_attribute10 := FND_API.G_MISS_CHAR;
507: x_attribute11 := FND_API.G_MISS_CHAR;
508: x_attribute12 := FND_API.G_MISS_CHAR;
509: x_attribute13 := FND_API.G_MISS_CHAR;

Line 506: x_attribute10 := FND_API.G_MISS_CHAR;

502:
503: -- Init OUT parameters to missing.
504:
505: x_attribute1 := FND_API.G_MISS_CHAR;
506: x_attribute10 := FND_API.G_MISS_CHAR;
507: x_attribute11 := FND_API.G_MISS_CHAR;
508: x_attribute12 := FND_API.G_MISS_CHAR;
509: x_attribute13 := FND_API.G_MISS_CHAR;
510: x_attribute14 := FND_API.G_MISS_CHAR;

Line 507: x_attribute11 := FND_API.G_MISS_CHAR;

503: -- Init OUT parameters to missing.
504:
505: x_attribute1 := FND_API.G_MISS_CHAR;
506: x_attribute10 := FND_API.G_MISS_CHAR;
507: x_attribute11 := FND_API.G_MISS_CHAR;
508: x_attribute12 := FND_API.G_MISS_CHAR;
509: x_attribute13 := FND_API.G_MISS_CHAR;
510: x_attribute14 := FND_API.G_MISS_CHAR;
511: x_attribute15 := FND_API.G_MISS_CHAR;

Line 508: x_attribute12 := FND_API.G_MISS_CHAR;

504:
505: x_attribute1 := FND_API.G_MISS_CHAR;
506: x_attribute10 := FND_API.G_MISS_CHAR;
507: x_attribute11 := FND_API.G_MISS_CHAR;
508: x_attribute12 := FND_API.G_MISS_CHAR;
509: x_attribute13 := FND_API.G_MISS_CHAR;
510: x_attribute14 := FND_API.G_MISS_CHAR;
511: x_attribute15 := FND_API.G_MISS_CHAR;
512: x_attribute2 := FND_API.G_MISS_CHAR;

Line 509: x_attribute13 := FND_API.G_MISS_CHAR;

505: x_attribute1 := FND_API.G_MISS_CHAR;
506: x_attribute10 := FND_API.G_MISS_CHAR;
507: x_attribute11 := FND_API.G_MISS_CHAR;
508: x_attribute12 := FND_API.G_MISS_CHAR;
509: x_attribute13 := FND_API.G_MISS_CHAR;
510: x_attribute14 := FND_API.G_MISS_CHAR;
511: x_attribute15 := FND_API.G_MISS_CHAR;
512: x_attribute2 := FND_API.G_MISS_CHAR;
513: x_attribute3 := FND_API.G_MISS_CHAR;

Line 510: x_attribute14 := FND_API.G_MISS_CHAR;

506: x_attribute10 := FND_API.G_MISS_CHAR;
507: x_attribute11 := FND_API.G_MISS_CHAR;
508: x_attribute12 := FND_API.G_MISS_CHAR;
509: x_attribute13 := FND_API.G_MISS_CHAR;
510: x_attribute14 := FND_API.G_MISS_CHAR;
511: x_attribute15 := FND_API.G_MISS_CHAR;
512: x_attribute2 := FND_API.G_MISS_CHAR;
513: x_attribute3 := FND_API.G_MISS_CHAR;
514: x_attribute4 := FND_API.G_MISS_CHAR;

Line 511: x_attribute15 := FND_API.G_MISS_CHAR;

507: x_attribute11 := FND_API.G_MISS_CHAR;
508: x_attribute12 := FND_API.G_MISS_CHAR;
509: x_attribute13 := FND_API.G_MISS_CHAR;
510: x_attribute14 := FND_API.G_MISS_CHAR;
511: x_attribute15 := FND_API.G_MISS_CHAR;
512: x_attribute2 := FND_API.G_MISS_CHAR;
513: x_attribute3 := FND_API.G_MISS_CHAR;
514: x_attribute4 := FND_API.G_MISS_CHAR;
515: x_attribute5 := FND_API.G_MISS_CHAR;

Line 512: x_attribute2 := FND_API.G_MISS_CHAR;

508: x_attribute12 := FND_API.G_MISS_CHAR;
509: x_attribute13 := FND_API.G_MISS_CHAR;
510: x_attribute14 := FND_API.G_MISS_CHAR;
511: x_attribute15 := FND_API.G_MISS_CHAR;
512: x_attribute2 := FND_API.G_MISS_CHAR;
513: x_attribute3 := FND_API.G_MISS_CHAR;
514: x_attribute4 := FND_API.G_MISS_CHAR;
515: x_attribute5 := FND_API.G_MISS_CHAR;
516: x_attribute6 := FND_API.G_MISS_CHAR;

Line 513: x_attribute3 := FND_API.G_MISS_CHAR;

509: x_attribute13 := FND_API.G_MISS_CHAR;
510: x_attribute14 := FND_API.G_MISS_CHAR;
511: x_attribute15 := FND_API.G_MISS_CHAR;
512: x_attribute2 := FND_API.G_MISS_CHAR;
513: x_attribute3 := FND_API.G_MISS_CHAR;
514: x_attribute4 := FND_API.G_MISS_CHAR;
515: x_attribute5 := FND_API.G_MISS_CHAR;
516: x_attribute6 := FND_API.G_MISS_CHAR;
517: x_attribute7 := FND_API.G_MISS_CHAR;

Line 514: x_attribute4 := FND_API.G_MISS_CHAR;

510: x_attribute14 := FND_API.G_MISS_CHAR;
511: x_attribute15 := FND_API.G_MISS_CHAR;
512: x_attribute2 := FND_API.G_MISS_CHAR;
513: x_attribute3 := FND_API.G_MISS_CHAR;
514: x_attribute4 := FND_API.G_MISS_CHAR;
515: x_attribute5 := FND_API.G_MISS_CHAR;
516: x_attribute6 := FND_API.G_MISS_CHAR;
517: x_attribute7 := FND_API.G_MISS_CHAR;
518: x_attribute8 := FND_API.G_MISS_CHAR;

Line 515: x_attribute5 := FND_API.G_MISS_CHAR;

511: x_attribute15 := FND_API.G_MISS_CHAR;
512: x_attribute2 := FND_API.G_MISS_CHAR;
513: x_attribute3 := FND_API.G_MISS_CHAR;
514: x_attribute4 := FND_API.G_MISS_CHAR;
515: x_attribute5 := FND_API.G_MISS_CHAR;
516: x_attribute6 := FND_API.G_MISS_CHAR;
517: x_attribute7 := FND_API.G_MISS_CHAR;
518: x_attribute8 := FND_API.G_MISS_CHAR;
519: x_attribute9 := FND_API.G_MISS_CHAR;

Line 516: x_attribute6 := FND_API.G_MISS_CHAR;

512: x_attribute2 := FND_API.G_MISS_CHAR;
513: x_attribute3 := FND_API.G_MISS_CHAR;
514: x_attribute4 := FND_API.G_MISS_CHAR;
515: x_attribute5 := FND_API.G_MISS_CHAR;
516: x_attribute6 := FND_API.G_MISS_CHAR;
517: x_attribute7 := FND_API.G_MISS_CHAR;
518: x_attribute8 := FND_API.G_MISS_CHAR;
519: x_attribute9 := FND_API.G_MISS_CHAR;
520: x_available_amount := FND_API.G_MISS_NUM;

Line 517: x_attribute7 := FND_API.G_MISS_CHAR;

513: x_attribute3 := FND_API.G_MISS_CHAR;
514: x_attribute4 := FND_API.G_MISS_CHAR;
515: x_attribute5 := FND_API.G_MISS_CHAR;
516: x_attribute6 := FND_API.G_MISS_CHAR;
517: x_attribute7 := FND_API.G_MISS_CHAR;
518: x_attribute8 := FND_API.G_MISS_CHAR;
519: x_attribute9 := FND_API.G_MISS_CHAR;
520: x_available_amount := FND_API.G_MISS_NUM;
521: x_consumed_amount := FND_API.G_MISS_NUM;

Line 518: x_attribute8 := FND_API.G_MISS_CHAR;

514: x_attribute4 := FND_API.G_MISS_CHAR;
515: x_attribute5 := FND_API.G_MISS_CHAR;
516: x_attribute6 := FND_API.G_MISS_CHAR;
517: x_attribute7 := FND_API.G_MISS_CHAR;
518: x_attribute8 := FND_API.G_MISS_CHAR;
519: x_attribute9 := FND_API.G_MISS_CHAR;
520: x_available_amount := FND_API.G_MISS_NUM;
521: x_consumed_amount := FND_API.G_MISS_NUM;
522: x_context := FND_API.G_MISS_CHAR;

Line 519: x_attribute9 := FND_API.G_MISS_CHAR;

515: x_attribute5 := FND_API.G_MISS_CHAR;
516: x_attribute6 := FND_API.G_MISS_CHAR;
517: x_attribute7 := FND_API.G_MISS_CHAR;
518: x_attribute8 := FND_API.G_MISS_CHAR;
519: x_attribute9 := FND_API.G_MISS_CHAR;
520: x_available_amount := FND_API.G_MISS_NUM;
521: x_consumed_amount := FND_API.G_MISS_NUM;
522: x_context := FND_API.G_MISS_CHAR;
523: x_limit_balance_id := FND_API.G_MISS_NUM;

Line 520: x_available_amount := FND_API.G_MISS_NUM;

516: x_attribute6 := FND_API.G_MISS_CHAR;
517: x_attribute7 := FND_API.G_MISS_CHAR;
518: x_attribute8 := FND_API.G_MISS_CHAR;
519: x_attribute9 := FND_API.G_MISS_CHAR;
520: x_available_amount := FND_API.G_MISS_NUM;
521: x_consumed_amount := FND_API.G_MISS_NUM;
522: x_context := FND_API.G_MISS_CHAR;
523: x_limit_balance_id := FND_API.G_MISS_NUM;
524: x_limit_id := FND_API.G_MISS_NUM;

Line 521: x_consumed_amount := FND_API.G_MISS_NUM;

517: x_attribute7 := FND_API.G_MISS_CHAR;
518: x_attribute8 := FND_API.G_MISS_CHAR;
519: x_attribute9 := FND_API.G_MISS_CHAR;
520: x_available_amount := FND_API.G_MISS_NUM;
521: x_consumed_amount := FND_API.G_MISS_NUM;
522: x_context := FND_API.G_MISS_CHAR;
523: x_limit_balance_id := FND_API.G_MISS_NUM;
524: x_limit_id := FND_API.G_MISS_NUM;
525: x_multival_attr1_type := FND_API.G_MISS_CHAR;

Line 522: x_context := FND_API.G_MISS_CHAR;

518: x_attribute8 := FND_API.G_MISS_CHAR;
519: x_attribute9 := FND_API.G_MISS_CHAR;
520: x_available_amount := FND_API.G_MISS_NUM;
521: x_consumed_amount := FND_API.G_MISS_NUM;
522: x_context := FND_API.G_MISS_CHAR;
523: x_limit_balance_id := FND_API.G_MISS_NUM;
524: x_limit_id := FND_API.G_MISS_NUM;
525: x_multival_attr1_type := FND_API.G_MISS_CHAR;
526: x_multival_attr1_context := FND_API.G_MISS_CHAR;

Line 523: x_limit_balance_id := FND_API.G_MISS_NUM;

519: x_attribute9 := FND_API.G_MISS_CHAR;
520: x_available_amount := FND_API.G_MISS_NUM;
521: x_consumed_amount := FND_API.G_MISS_NUM;
522: x_context := FND_API.G_MISS_CHAR;
523: x_limit_balance_id := FND_API.G_MISS_NUM;
524: x_limit_id := FND_API.G_MISS_NUM;
525: x_multival_attr1_type := FND_API.G_MISS_CHAR;
526: x_multival_attr1_context := FND_API.G_MISS_CHAR;
527: x_multival_attribute1 := FND_API.G_MISS_CHAR;

Line 524: x_limit_id := FND_API.G_MISS_NUM;

520: x_available_amount := FND_API.G_MISS_NUM;
521: x_consumed_amount := FND_API.G_MISS_NUM;
522: x_context := FND_API.G_MISS_CHAR;
523: x_limit_balance_id := FND_API.G_MISS_NUM;
524: x_limit_id := FND_API.G_MISS_NUM;
525: x_multival_attr1_type := FND_API.G_MISS_CHAR;
526: x_multival_attr1_context := FND_API.G_MISS_CHAR;
527: x_multival_attribute1 := FND_API.G_MISS_CHAR;
528: x_multival_attr1_value := FND_API.G_MISS_CHAR;

Line 525: x_multival_attr1_type := FND_API.G_MISS_CHAR;

521: x_consumed_amount := FND_API.G_MISS_NUM;
522: x_context := FND_API.G_MISS_CHAR;
523: x_limit_balance_id := FND_API.G_MISS_NUM;
524: x_limit_id := FND_API.G_MISS_NUM;
525: x_multival_attr1_type := FND_API.G_MISS_CHAR;
526: x_multival_attr1_context := FND_API.G_MISS_CHAR;
527: x_multival_attribute1 := FND_API.G_MISS_CHAR;
528: x_multival_attr1_value := FND_API.G_MISS_CHAR;
529: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;

Line 526: x_multival_attr1_context := FND_API.G_MISS_CHAR;

522: x_context := FND_API.G_MISS_CHAR;
523: x_limit_balance_id := FND_API.G_MISS_NUM;
524: x_limit_id := FND_API.G_MISS_NUM;
525: x_multival_attr1_type := FND_API.G_MISS_CHAR;
526: x_multival_attr1_context := FND_API.G_MISS_CHAR;
527: x_multival_attribute1 := FND_API.G_MISS_CHAR;
528: x_multival_attr1_value := FND_API.G_MISS_CHAR;
529: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
530: x_multival_attr2_type := FND_API.G_MISS_CHAR;

Line 527: x_multival_attribute1 := FND_API.G_MISS_CHAR;

523: x_limit_balance_id := FND_API.G_MISS_NUM;
524: x_limit_id := FND_API.G_MISS_NUM;
525: x_multival_attr1_type := FND_API.G_MISS_CHAR;
526: x_multival_attr1_context := FND_API.G_MISS_CHAR;
527: x_multival_attribute1 := FND_API.G_MISS_CHAR;
528: x_multival_attr1_value := FND_API.G_MISS_CHAR;
529: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
530: x_multival_attr2_type := FND_API.G_MISS_CHAR;
531: x_multival_attr2_context := FND_API.G_MISS_CHAR;

Line 528: x_multival_attr1_value := FND_API.G_MISS_CHAR;

524: x_limit_id := FND_API.G_MISS_NUM;
525: x_multival_attr1_type := FND_API.G_MISS_CHAR;
526: x_multival_attr1_context := FND_API.G_MISS_CHAR;
527: x_multival_attribute1 := FND_API.G_MISS_CHAR;
528: x_multival_attr1_value := FND_API.G_MISS_CHAR;
529: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
530: x_multival_attr2_type := FND_API.G_MISS_CHAR;
531: x_multival_attr2_context := FND_API.G_MISS_CHAR;
532: x_multival_attribute2 := FND_API.G_MISS_CHAR;

Line 529: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;

525: x_multival_attr1_type := FND_API.G_MISS_CHAR;
526: x_multival_attr1_context := FND_API.G_MISS_CHAR;
527: x_multival_attribute1 := FND_API.G_MISS_CHAR;
528: x_multival_attr1_value := FND_API.G_MISS_CHAR;
529: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
530: x_multival_attr2_type := FND_API.G_MISS_CHAR;
531: x_multival_attr2_context := FND_API.G_MISS_CHAR;
532: x_multival_attribute2 := FND_API.G_MISS_CHAR;
533: x_multival_attr2_value := FND_API.G_MISS_CHAR;

Line 530: x_multival_attr2_type := FND_API.G_MISS_CHAR;

526: x_multival_attr1_context := FND_API.G_MISS_CHAR;
527: x_multival_attribute1 := FND_API.G_MISS_CHAR;
528: x_multival_attr1_value := FND_API.G_MISS_CHAR;
529: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
530: x_multival_attr2_type := FND_API.G_MISS_CHAR;
531: x_multival_attr2_context := FND_API.G_MISS_CHAR;
532: x_multival_attribute2 := FND_API.G_MISS_CHAR;
533: x_multival_attr2_value := FND_API.G_MISS_CHAR;
534: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;

Line 531: x_multival_attr2_context := FND_API.G_MISS_CHAR;

527: x_multival_attribute1 := FND_API.G_MISS_CHAR;
528: x_multival_attr1_value := FND_API.G_MISS_CHAR;
529: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
530: x_multival_attr2_type := FND_API.G_MISS_CHAR;
531: x_multival_attr2_context := FND_API.G_MISS_CHAR;
532: x_multival_attribute2 := FND_API.G_MISS_CHAR;
533: x_multival_attr2_value := FND_API.G_MISS_CHAR;
534: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
535: x_organization_attr_context := FND_API.G_MISS_CHAR;

Line 532: x_multival_attribute2 := FND_API.G_MISS_CHAR;

528: x_multival_attr1_value := FND_API.G_MISS_CHAR;
529: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
530: x_multival_attr2_type := FND_API.G_MISS_CHAR;
531: x_multival_attr2_context := FND_API.G_MISS_CHAR;
532: x_multival_attribute2 := FND_API.G_MISS_CHAR;
533: x_multival_attr2_value := FND_API.G_MISS_CHAR;
534: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
535: x_organization_attr_context := FND_API.G_MISS_CHAR;
536: x_organization_attribute := FND_API.G_MISS_CHAR;

Line 533: x_multival_attr2_value := FND_API.G_MISS_CHAR;

529: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
530: x_multival_attr2_type := FND_API.G_MISS_CHAR;
531: x_multival_attr2_context := FND_API.G_MISS_CHAR;
532: x_multival_attribute2 := FND_API.G_MISS_CHAR;
533: x_multival_attr2_value := FND_API.G_MISS_CHAR;
534: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
535: x_organization_attr_context := FND_API.G_MISS_CHAR;
536: x_organization_attribute := FND_API.G_MISS_CHAR;
537: x_organization_attr_value := FND_API.G_MISS_CHAR;

Line 534: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;

530: x_multival_attr2_type := FND_API.G_MISS_CHAR;
531: x_multival_attr2_context := FND_API.G_MISS_CHAR;
532: x_multival_attribute2 := FND_API.G_MISS_CHAR;
533: x_multival_attr2_value := FND_API.G_MISS_CHAR;
534: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
535: x_organization_attr_context := FND_API.G_MISS_CHAR;
536: x_organization_attribute := FND_API.G_MISS_CHAR;
537: x_organization_attr_value := FND_API.G_MISS_CHAR;
538: x_reserved_amount := FND_API.G_MISS_NUM;

Line 535: x_organization_attr_context := FND_API.G_MISS_CHAR;

531: x_multival_attr2_context := FND_API.G_MISS_CHAR;
532: x_multival_attribute2 := FND_API.G_MISS_CHAR;
533: x_multival_attr2_value := FND_API.G_MISS_CHAR;
534: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
535: x_organization_attr_context := FND_API.G_MISS_CHAR;
536: x_organization_attribute := FND_API.G_MISS_CHAR;
537: x_organization_attr_value := FND_API.G_MISS_CHAR;
538: x_reserved_amount := FND_API.G_MISS_NUM;
539: x_limit_balance := FND_API.G_MISS_CHAR;

Line 536: x_organization_attribute := FND_API.G_MISS_CHAR;

532: x_multival_attribute2 := FND_API.G_MISS_CHAR;
533: x_multival_attr2_value := FND_API.G_MISS_CHAR;
534: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
535: x_organization_attr_context := FND_API.G_MISS_CHAR;
536: x_organization_attribute := FND_API.G_MISS_CHAR;
537: x_organization_attr_value := FND_API.G_MISS_CHAR;
538: x_reserved_amount := FND_API.G_MISS_NUM;
539: x_limit_balance := FND_API.G_MISS_CHAR;
540: x_limit := FND_API.G_MISS_CHAR;

Line 537: x_organization_attr_value := FND_API.G_MISS_CHAR;

533: x_multival_attr2_value := FND_API.G_MISS_CHAR;
534: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
535: x_organization_attr_context := FND_API.G_MISS_CHAR;
536: x_organization_attribute := FND_API.G_MISS_CHAR;
537: x_organization_attr_value := FND_API.G_MISS_CHAR;
538: x_reserved_amount := FND_API.G_MISS_NUM;
539: x_limit_balance := FND_API.G_MISS_CHAR;
540: x_limit := FND_API.G_MISS_CHAR;
541:

Line 538: x_reserved_amount := FND_API.G_MISS_NUM;

534: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
535: x_organization_attr_context := FND_API.G_MISS_CHAR;
536: x_organization_attribute := FND_API.G_MISS_CHAR;
537: x_organization_attr_value := FND_API.G_MISS_CHAR;
538: x_reserved_amount := FND_API.G_MISS_NUM;
539: x_limit_balance := FND_API.G_MISS_CHAR;
540: x_limit := FND_API.G_MISS_CHAR;
541:
542: -- Load display out parameters if any

Line 539: x_limit_balance := FND_API.G_MISS_CHAR;

535: x_organization_attr_context := FND_API.G_MISS_CHAR;
536: x_organization_attribute := FND_API.G_MISS_CHAR;
537: x_organization_attr_value := FND_API.G_MISS_CHAR;
538: x_reserved_amount := FND_API.G_MISS_NUM;
539: x_limit_balance := FND_API.G_MISS_CHAR;
540: x_limit := FND_API.G_MISS_CHAR;
541:
542: -- Load display out parameters if any
543:

Line 540: x_limit := FND_API.G_MISS_CHAR;

536: x_organization_attribute := FND_API.G_MISS_CHAR;
537: x_organization_attr_value := FND_API.G_MISS_CHAR;
538: x_reserved_amount := FND_API.G_MISS_NUM;
539: x_limit_balance := FND_API.G_MISS_CHAR;
540: x_limit := FND_API.G_MISS_CHAR;
541:
542: -- Load display out parameters if any
543:
544: l_LIMIT_BALANCES_val_rec := QP_Limit_Balances_Util.Get_Values

Line 766: x_return_status := FND_API.G_RET_STS_SUCCESS;

762: );
763:
764: -- Set return status.
765:
766: x_return_status := FND_API.G_RET_STS_SUCCESS;
767:
768: -- Get message count and data
769:
770: OE_MSG_PUB.Count_And_Get

Line 778: WHEN FND_API.G_EXC_ERROR THEN

774:
775:
776: EXCEPTION
777:
778: WHEN FND_API.G_EXC_ERROR THEN
779:
780: x_return_status := FND_API.G_RET_STS_ERROR;
781:
782: -- Get message count and data

Line 780: x_return_status := FND_API.G_RET_STS_ERROR;

776: EXCEPTION
777:
778: WHEN FND_API.G_EXC_ERROR THEN
779:
780: x_return_status := FND_API.G_RET_STS_ERROR;
781:
782: -- Get message count and data
783:
784: OE_MSG_PUB.Count_And_Get

Line 789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

785: ( p_count => x_msg_count
786: , p_data => x_msg_data
787: );
788:
789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
790:
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792:
793: -- Get message count and data

Line 791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

787: );
788:
789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
790:
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792:
793: -- Get message count and data
794:
795: OE_MSG_PUB.Count_And_Get

Line 802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

798: );
799:
800: WHEN OTHERS THEN
801:
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
803:
804: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
805: THEN
806: OE_MSG_PUB.Add_Exc_Msg

Line 878: IF FND_API.To_Boolean(l_LIMIT_BALANCES_rec.db_flag) THEN

874: );
875:
876: -- Set Operation.
877:
878: IF FND_API.To_Boolean(l_LIMIT_BALANCES_rec.db_flag) THEN
879: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
880: ELSE
881: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_CREATE;
882: END IF;

Line 893: , p_init_msg_list => FND_API.G_TRUE

889: -- Call QP_Limits_PVT.Process_Limits
890:
891: QP_Limits_PVT.Process_Limits
892: ( p_api_version_number => 1.0
893: , p_init_msg_list => FND_API.G_TRUE
894: , x_return_status => l_return_status
895: , x_msg_count => x_msg_count
896: , x_msg_data => x_msg_data
897: , p_control_rec => l_control_rec

Line 905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

901: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
902: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
903: );
904:
905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;

Line 906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

902: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
903: );
904:
905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;
910:

Line 907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

903: );
904:
905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;
910:
911:

Line 908: RAISE FND_API.G_EXC_ERROR;

904:
905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;
910:
911:
912: -- Load OUT parameters.

Line 933: x_return_status := FND_API.G_RET_STS_SUCCESS;

929:
930:
931: -- Set return status.
932:
933: x_return_status := FND_API.G_RET_STS_SUCCESS;
934:
935: -- Get message count and data
936:
937: OE_MSG_PUB.Count_And_Get

Line 945: WHEN FND_API.G_EXC_ERROR THEN

941:
942:
943: EXCEPTION
944:
945: WHEN FND_API.G_EXC_ERROR THEN
946:
947: x_return_status := FND_API.G_RET_STS_ERROR;
948:
949: -- Get message count and data

Line 947: x_return_status := FND_API.G_RET_STS_ERROR;

943: EXCEPTION
944:
945: WHEN FND_API.G_EXC_ERROR THEN
946:
947: x_return_status := FND_API.G_RET_STS_ERROR;
948:
949: -- Get message count and data
950:
951: OE_MSG_PUB.Count_And_Get

Line 956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

952: ( p_count => x_msg_count
953: , p_data => x_msg_data
954: );
955:
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957:
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
959:
960: -- Get message count and data

Line 958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

954: );
955:
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957:
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
959:
960: -- Get message count and data
961:
962: OE_MSG_PUB.Count_And_Get

Line 969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

965: );
966:
967: WHEN OTHERS THEN
968:
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
970:
971: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
972: THEN
973: OE_MSG_PUB.Add_Exc_Msg

Line 1043: , p_init_msg_list => FND_API.G_TRUE

1039: -- Call QP_Limits_PVT.Process_Limits
1040:
1041: QP_Limits_PVT.Process_Limits
1042: ( p_api_version_number => 1.0
1043: , p_init_msg_list => FND_API.G_TRUE
1044: , x_return_status => l_return_status
1045: , x_msg_count => x_msg_count
1046: , x_msg_data => x_msg_data
1047: , p_control_rec => l_control_rec

Line 1054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1050: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
1051: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1052: );
1053:
1054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1057: RAISE FND_API.G_EXC_ERROR;
1058: END IF;

Line 1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1051: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1052: );
1053:
1054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1057: RAISE FND_API.G_EXC_ERROR;
1058: END IF;
1059:

Line 1056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1052: );
1053:
1054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1057: RAISE FND_API.G_EXC_ERROR;
1058: END IF;
1059:
1060:

Line 1057: RAISE FND_API.G_EXC_ERROR;

1053:
1054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1057: RAISE FND_API.G_EXC_ERROR;
1058: END IF;
1059:
1060:
1061: -- Clear LIMIT_BALANCES record cache

Line 1067: x_return_status := FND_API.G_RET_STS_SUCCESS;

1063: Clear_LIMIT_BALANCES;
1064:
1065: -- Set return status.
1066:
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;
1068:
1069: -- Get message count and data
1070:
1071: OE_MSG_PUB.Count_And_Get

Line 1079: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1081: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1099: );
1100:
1101: WHEN OTHERS THEN
1102:
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1104:
1105: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1106: THEN
1107: OE_MSG_PUB.Add_Exc_Msg

Line 1160: , p_init_msg_list => FND_API.G_TRUE

1156: -- Call QP_Limits_PVT.Process_Limits
1157:
1158: QP_Limits_PVT.Process_Limits
1159: ( p_api_version_number => 1.0
1160: , p_init_msg_list => FND_API.G_TRUE
1161: , x_return_status => l_return_status
1162: , x_msg_count => x_msg_count
1163: , x_msg_data => x_msg_data
1164: , p_control_rec => l_control_rec

Line 1170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1166: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
1167: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1168: );
1169:
1170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;

Line 1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1167: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1168: );
1169:
1170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175:

Line 1172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1168: );
1169:
1170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175:
1176:

Line 1173: RAISE FND_API.G_EXC_ERROR;

1169:
1170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175:
1176:
1177: -- Set return status.

Line 1179: x_return_status := FND_API.G_RET_STS_SUCCESS;

1175:
1176:
1177: -- Set return status.
1178:
1179: x_return_status := FND_API.G_RET_STS_SUCCESS;
1180:
1181: -- Get message count and data
1182:
1183: OE_MSG_PUB.Count_And_Get

Line 1191: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1193: x_return_status := FND_API.G_RET_STS_ERROR;

1189: EXCEPTION
1190:
1191: WHEN FND_API.G_EXC_ERROR THEN
1192:
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194:
1195: -- Get message count and data
1196:
1197: OE_MSG_PUB.Count_And_Get

Line 1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1198: ( p_count => x_msg_count
1199: , p_data => x_msg_data
1200: );
1201:
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203:
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205:
1206: -- Get message count and data

Line 1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1200: );
1201:
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203:
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205:
1206: -- Get message count and data
1207:
1208: OE_MSG_PUB.Count_And_Get

Line 1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1211: );
1212:
1213: WHEN OTHERS THEN
1214:
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1216:
1217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: OE_MSG_PUB.Add_Exc_Msg

Line 1350: , p_init_msg_list => FND_API.G_TRUE

1346: -- Call QP_Limits_PVT.Lock_Limits
1347:
1348: QP_Limits_PVT.Lock_Limits
1349: ( p_api_version_number => 1.0
1350: , p_init_msg_list => FND_API.G_TRUE
1351: , x_return_status => l_return_status
1352: , x_msg_count => x_msg_count
1353: , x_msg_data => x_msg_data
1354: , p_LIMIT_BALANCES_tbl => l_LIMIT_BALANCES_tbl

Line 1360: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1356: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
1357: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1358: );
1359:
1360: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1361:
1362: -- Set DB flag and write record to cache.
1363:
1364: l_x_LIMIT_BALANCES_rec.db_flag := FND_API.G_TRUE;

Line 1364: l_x_LIMIT_BALANCES_rec.db_flag := FND_API.G_TRUE;

1360: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1361:
1362: -- Set DB flag and write record to cache.
1363:
1364: l_x_LIMIT_BALANCES_rec.db_flag := FND_API.G_TRUE;
1365:
1366: Write_LIMIT_BALANCES
1367: ( p_LIMIT_BALANCES_rec => l_x_LIMIT_BALANCES_rec
1368: , p_db_record => TRUE

Line 1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1393: , 'Lock_Row'
1394: );
1395: END IF;
1396:
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398:
1399: -- Get message count and data
1400:
1401: OE_MSG_PUB.Count_And_Get

Line 1446: g_LIMIT_BALANCES_rec.db_flag := FND_API.G_TRUE;

1442: g_LIMIT_BALANCES_rec := QP_Limit_Balances_Util.Query_Row
1443: ( p_limit_balance_id => p_limit_balance_id
1444: );
1445:
1446: g_LIMIT_BALANCES_rec.db_flag := FND_API.G_TRUE;
1447:
1448: -- Load DB record
1449:
1450: g_db_LIMIT_BALANCES_rec := g_LIMIT_BALANCES_rec;