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
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;
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:
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:
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
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: );
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
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
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
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
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
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
454: , 'Unrecognized attribute'
455: );
456: END IF;
457:
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459:
460: END IF;
461:
462: -- Set Operation.
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;
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
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
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;
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:
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:
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
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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
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:
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
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
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
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
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
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
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
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;
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
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;
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:
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:
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.
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
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
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
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
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
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
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
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;
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:
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:
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
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
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
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
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
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
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
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
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;
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:
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:
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.
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
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
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
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
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
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
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
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;
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
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
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;