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

Line 138: , p_init_msg_list => FND_API.G_TRUE

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

Line 149: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 151: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 152: RAISE FND_API.G_EXC_ERROR;

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

Line 208: l_x_LIMITS_rec.db_flag := FND_API.G_FALSE;

204:
205: -- Write to cache.
206: -- Set db_flag to False before writing to cache
207:
208: l_x_LIMITS_rec.db_flag := FND_API.G_FALSE;
209:
210: Write_LIMITS
211: ( p_LIMITS_rec => l_x_LIMITS_rec
212: );

Line 216: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 228: WHEN FND_API.G_EXC_ERROR THEN

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

Line 230: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 465: IF FND_API.To_Boolean(l_LIMITS_rec.db_flag) THEN

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

Line 475: , p_init_msg_list => FND_API.G_TRUE

471: -- Call QP_Limits_PVT.Process_Limits
472:
473: QP_Limits_PVT.Process_Limits
474: ( p_api_version_number => 1.0
475: , p_init_msg_list => FND_API.G_TRUE
476: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
477: , x_return_status => l_return_status
478: , x_msg_count => x_msg_count
479: , x_msg_data => x_msg_data

Line 476: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

472:
473: QP_Limits_PVT.Process_Limits
474: ( p_api_version_number => 1.0
475: , p_init_msg_list => FND_API.G_TRUE
476: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
477: , x_return_status => l_return_status
478: , x_msg_count => x_msg_count
479: , x_msg_data => x_msg_data
480: , p_control_rec => l_control_rec

Line 488: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

484: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
485: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
486: );
487:
488: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;

Line 489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

485: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
486: );
487:
488: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:

Line 490: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

486: );
487:
488: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494:

Line 491: RAISE FND_API.G_EXC_ERROR;

487:
488: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494:
495: -- Init OUT parameters to missing.

Line 497: x_amount := FND_API.G_MISS_NUM;

493:
494:
495: -- Init OUT parameters to missing.
496:
497: x_amount := FND_API.G_MISS_NUM;
498: x_attribute1 := FND_API.G_MISS_CHAR;
499: x_attribute10 := FND_API.G_MISS_CHAR;
500: x_attribute11 := FND_API.G_MISS_CHAR;
501: x_attribute12 := FND_API.G_MISS_CHAR;

Line 498: x_attribute1 := FND_API.G_MISS_CHAR;

494:
495: -- Init OUT parameters to missing.
496:
497: x_amount := FND_API.G_MISS_NUM;
498: x_attribute1 := FND_API.G_MISS_CHAR;
499: x_attribute10 := FND_API.G_MISS_CHAR;
500: x_attribute11 := FND_API.G_MISS_CHAR;
501: x_attribute12 := FND_API.G_MISS_CHAR;
502: x_attribute13 := FND_API.G_MISS_CHAR;

Line 499: x_attribute10 := FND_API.G_MISS_CHAR;

495: -- Init OUT parameters to missing.
496:
497: x_amount := FND_API.G_MISS_NUM;
498: x_attribute1 := FND_API.G_MISS_CHAR;
499: x_attribute10 := FND_API.G_MISS_CHAR;
500: x_attribute11 := FND_API.G_MISS_CHAR;
501: x_attribute12 := FND_API.G_MISS_CHAR;
502: x_attribute13 := FND_API.G_MISS_CHAR;
503: x_attribute14 := FND_API.G_MISS_CHAR;

Line 500: x_attribute11 := FND_API.G_MISS_CHAR;

496:
497: x_amount := FND_API.G_MISS_NUM;
498: x_attribute1 := FND_API.G_MISS_CHAR;
499: x_attribute10 := FND_API.G_MISS_CHAR;
500: x_attribute11 := FND_API.G_MISS_CHAR;
501: x_attribute12 := FND_API.G_MISS_CHAR;
502: x_attribute13 := FND_API.G_MISS_CHAR;
503: x_attribute14 := FND_API.G_MISS_CHAR;
504: x_attribute15 := FND_API.G_MISS_CHAR;

Line 501: x_attribute12 := FND_API.G_MISS_CHAR;

497: x_amount := FND_API.G_MISS_NUM;
498: x_attribute1 := FND_API.G_MISS_CHAR;
499: x_attribute10 := FND_API.G_MISS_CHAR;
500: x_attribute11 := FND_API.G_MISS_CHAR;
501: x_attribute12 := FND_API.G_MISS_CHAR;
502: x_attribute13 := FND_API.G_MISS_CHAR;
503: x_attribute14 := FND_API.G_MISS_CHAR;
504: x_attribute15 := FND_API.G_MISS_CHAR;
505: x_attribute2 := FND_API.G_MISS_CHAR;

Line 502: x_attribute13 := FND_API.G_MISS_CHAR;

498: x_attribute1 := FND_API.G_MISS_CHAR;
499: x_attribute10 := FND_API.G_MISS_CHAR;
500: x_attribute11 := FND_API.G_MISS_CHAR;
501: x_attribute12 := FND_API.G_MISS_CHAR;
502: x_attribute13 := FND_API.G_MISS_CHAR;
503: x_attribute14 := FND_API.G_MISS_CHAR;
504: x_attribute15 := FND_API.G_MISS_CHAR;
505: x_attribute2 := FND_API.G_MISS_CHAR;
506: x_attribute3 := FND_API.G_MISS_CHAR;

Line 503: x_attribute14 := FND_API.G_MISS_CHAR;

499: x_attribute10 := FND_API.G_MISS_CHAR;
500: x_attribute11 := FND_API.G_MISS_CHAR;
501: x_attribute12 := FND_API.G_MISS_CHAR;
502: x_attribute13 := FND_API.G_MISS_CHAR;
503: x_attribute14 := FND_API.G_MISS_CHAR;
504: x_attribute15 := FND_API.G_MISS_CHAR;
505: x_attribute2 := FND_API.G_MISS_CHAR;
506: x_attribute3 := FND_API.G_MISS_CHAR;
507: x_attribute4 := FND_API.G_MISS_CHAR;

Line 504: x_attribute15 := FND_API.G_MISS_CHAR;

500: x_attribute11 := FND_API.G_MISS_CHAR;
501: x_attribute12 := FND_API.G_MISS_CHAR;
502: x_attribute13 := FND_API.G_MISS_CHAR;
503: x_attribute14 := FND_API.G_MISS_CHAR;
504: x_attribute15 := FND_API.G_MISS_CHAR;
505: x_attribute2 := FND_API.G_MISS_CHAR;
506: x_attribute3 := FND_API.G_MISS_CHAR;
507: x_attribute4 := FND_API.G_MISS_CHAR;
508: x_attribute5 := FND_API.G_MISS_CHAR;

Line 505: x_attribute2 := FND_API.G_MISS_CHAR;

501: x_attribute12 := FND_API.G_MISS_CHAR;
502: x_attribute13 := FND_API.G_MISS_CHAR;
503: x_attribute14 := FND_API.G_MISS_CHAR;
504: x_attribute15 := FND_API.G_MISS_CHAR;
505: x_attribute2 := FND_API.G_MISS_CHAR;
506: x_attribute3 := FND_API.G_MISS_CHAR;
507: x_attribute4 := FND_API.G_MISS_CHAR;
508: x_attribute5 := FND_API.G_MISS_CHAR;
509: x_attribute6 := FND_API.G_MISS_CHAR;

Line 506: x_attribute3 := FND_API.G_MISS_CHAR;

502: x_attribute13 := FND_API.G_MISS_CHAR;
503: x_attribute14 := FND_API.G_MISS_CHAR;
504: x_attribute15 := FND_API.G_MISS_CHAR;
505: x_attribute2 := FND_API.G_MISS_CHAR;
506: x_attribute3 := FND_API.G_MISS_CHAR;
507: x_attribute4 := FND_API.G_MISS_CHAR;
508: x_attribute5 := FND_API.G_MISS_CHAR;
509: x_attribute6 := FND_API.G_MISS_CHAR;
510: x_attribute7 := FND_API.G_MISS_CHAR;

Line 507: x_attribute4 := FND_API.G_MISS_CHAR;

503: x_attribute14 := FND_API.G_MISS_CHAR;
504: x_attribute15 := FND_API.G_MISS_CHAR;
505: x_attribute2 := FND_API.G_MISS_CHAR;
506: x_attribute3 := FND_API.G_MISS_CHAR;
507: x_attribute4 := FND_API.G_MISS_CHAR;
508: x_attribute5 := FND_API.G_MISS_CHAR;
509: x_attribute6 := FND_API.G_MISS_CHAR;
510: x_attribute7 := FND_API.G_MISS_CHAR;
511: x_attribute8 := FND_API.G_MISS_CHAR;

Line 508: x_attribute5 := FND_API.G_MISS_CHAR;

504: x_attribute15 := FND_API.G_MISS_CHAR;
505: x_attribute2 := FND_API.G_MISS_CHAR;
506: x_attribute3 := FND_API.G_MISS_CHAR;
507: x_attribute4 := FND_API.G_MISS_CHAR;
508: x_attribute5 := FND_API.G_MISS_CHAR;
509: x_attribute6 := FND_API.G_MISS_CHAR;
510: x_attribute7 := FND_API.G_MISS_CHAR;
511: x_attribute8 := FND_API.G_MISS_CHAR;
512: x_attribute9 := FND_API.G_MISS_CHAR;

Line 509: x_attribute6 := FND_API.G_MISS_CHAR;

505: x_attribute2 := FND_API.G_MISS_CHAR;
506: x_attribute3 := FND_API.G_MISS_CHAR;
507: x_attribute4 := FND_API.G_MISS_CHAR;
508: x_attribute5 := FND_API.G_MISS_CHAR;
509: x_attribute6 := FND_API.G_MISS_CHAR;
510: x_attribute7 := FND_API.G_MISS_CHAR;
511: x_attribute8 := FND_API.G_MISS_CHAR;
512: x_attribute9 := FND_API.G_MISS_CHAR;
513: x_basis := FND_API.G_MISS_CHAR;

Line 510: x_attribute7 := FND_API.G_MISS_CHAR;

506: x_attribute3 := FND_API.G_MISS_CHAR;
507: x_attribute4 := FND_API.G_MISS_CHAR;
508: x_attribute5 := FND_API.G_MISS_CHAR;
509: x_attribute6 := FND_API.G_MISS_CHAR;
510: x_attribute7 := FND_API.G_MISS_CHAR;
511: x_attribute8 := FND_API.G_MISS_CHAR;
512: x_attribute9 := FND_API.G_MISS_CHAR;
513: x_basis := FND_API.G_MISS_CHAR;
514: x_context := FND_API.G_MISS_CHAR;

Line 511: x_attribute8 := FND_API.G_MISS_CHAR;

507: x_attribute4 := FND_API.G_MISS_CHAR;
508: x_attribute5 := FND_API.G_MISS_CHAR;
509: x_attribute6 := FND_API.G_MISS_CHAR;
510: x_attribute7 := FND_API.G_MISS_CHAR;
511: x_attribute8 := FND_API.G_MISS_CHAR;
512: x_attribute9 := FND_API.G_MISS_CHAR;
513: x_basis := FND_API.G_MISS_CHAR;
514: x_context := FND_API.G_MISS_CHAR;
515: x_limit_exceed_action_code := FND_API.G_MISS_CHAR;

Line 512: x_attribute9 := FND_API.G_MISS_CHAR;

508: x_attribute5 := FND_API.G_MISS_CHAR;
509: x_attribute6 := FND_API.G_MISS_CHAR;
510: x_attribute7 := FND_API.G_MISS_CHAR;
511: x_attribute8 := FND_API.G_MISS_CHAR;
512: x_attribute9 := FND_API.G_MISS_CHAR;
513: x_basis := FND_API.G_MISS_CHAR;
514: x_context := FND_API.G_MISS_CHAR;
515: x_limit_exceed_action_code := FND_API.G_MISS_CHAR;
516: x_limit_hold_flag := FND_API.G_MISS_CHAR;

Line 513: x_basis := FND_API.G_MISS_CHAR;

509: x_attribute6 := FND_API.G_MISS_CHAR;
510: x_attribute7 := FND_API.G_MISS_CHAR;
511: x_attribute8 := FND_API.G_MISS_CHAR;
512: x_attribute9 := FND_API.G_MISS_CHAR;
513: x_basis := FND_API.G_MISS_CHAR;
514: x_context := FND_API.G_MISS_CHAR;
515: x_limit_exceed_action_code := FND_API.G_MISS_CHAR;
516: x_limit_hold_flag := FND_API.G_MISS_CHAR;
517: x_limit_id := FND_API.G_MISS_NUM;

Line 514: x_context := FND_API.G_MISS_CHAR;

510: x_attribute7 := FND_API.G_MISS_CHAR;
511: x_attribute8 := FND_API.G_MISS_CHAR;
512: x_attribute9 := FND_API.G_MISS_CHAR;
513: x_basis := FND_API.G_MISS_CHAR;
514: x_context := FND_API.G_MISS_CHAR;
515: x_limit_exceed_action_code := FND_API.G_MISS_CHAR;
516: x_limit_hold_flag := FND_API.G_MISS_CHAR;
517: x_limit_id := FND_API.G_MISS_NUM;
518: x_limit_level_code := FND_API.G_MISS_CHAR;

Line 515: x_limit_exceed_action_code := FND_API.G_MISS_CHAR;

511: x_attribute8 := FND_API.G_MISS_CHAR;
512: x_attribute9 := FND_API.G_MISS_CHAR;
513: x_basis := FND_API.G_MISS_CHAR;
514: x_context := FND_API.G_MISS_CHAR;
515: x_limit_exceed_action_code := FND_API.G_MISS_CHAR;
516: x_limit_hold_flag := FND_API.G_MISS_CHAR;
517: x_limit_id := FND_API.G_MISS_NUM;
518: x_limit_level_code := FND_API.G_MISS_CHAR;
519: x_limit_number := FND_API.G_MISS_NUM;

Line 516: x_limit_hold_flag := FND_API.G_MISS_CHAR;

512: x_attribute9 := FND_API.G_MISS_CHAR;
513: x_basis := FND_API.G_MISS_CHAR;
514: x_context := FND_API.G_MISS_CHAR;
515: x_limit_exceed_action_code := FND_API.G_MISS_CHAR;
516: x_limit_hold_flag := FND_API.G_MISS_CHAR;
517: x_limit_id := FND_API.G_MISS_NUM;
518: x_limit_level_code := FND_API.G_MISS_CHAR;
519: x_limit_number := FND_API.G_MISS_NUM;
520: x_list_header_id := FND_API.G_MISS_NUM;

Line 517: x_limit_id := FND_API.G_MISS_NUM;

513: x_basis := FND_API.G_MISS_CHAR;
514: x_context := FND_API.G_MISS_CHAR;
515: x_limit_exceed_action_code := FND_API.G_MISS_CHAR;
516: x_limit_hold_flag := FND_API.G_MISS_CHAR;
517: x_limit_id := FND_API.G_MISS_NUM;
518: x_limit_level_code := FND_API.G_MISS_CHAR;
519: x_limit_number := FND_API.G_MISS_NUM;
520: x_list_header_id := FND_API.G_MISS_NUM;
521: x_list_line_id := FND_API.G_MISS_NUM;

Line 518: x_limit_level_code := FND_API.G_MISS_CHAR;

514: x_context := FND_API.G_MISS_CHAR;
515: x_limit_exceed_action_code := FND_API.G_MISS_CHAR;
516: x_limit_hold_flag := FND_API.G_MISS_CHAR;
517: x_limit_id := FND_API.G_MISS_NUM;
518: x_limit_level_code := FND_API.G_MISS_CHAR;
519: x_limit_number := FND_API.G_MISS_NUM;
520: x_list_header_id := FND_API.G_MISS_NUM;
521: x_list_line_id := FND_API.G_MISS_NUM;
522: x_multival_attr1_type := FND_API.G_MISS_CHAR;

Line 519: x_limit_number := FND_API.G_MISS_NUM;

515: x_limit_exceed_action_code := FND_API.G_MISS_CHAR;
516: x_limit_hold_flag := FND_API.G_MISS_CHAR;
517: x_limit_id := FND_API.G_MISS_NUM;
518: x_limit_level_code := FND_API.G_MISS_CHAR;
519: x_limit_number := FND_API.G_MISS_NUM;
520: x_list_header_id := FND_API.G_MISS_NUM;
521: x_list_line_id := FND_API.G_MISS_NUM;
522: x_multival_attr1_type := FND_API.G_MISS_CHAR;
523: x_multival_attr1_context := FND_API.G_MISS_CHAR;

Line 520: x_list_header_id := FND_API.G_MISS_NUM;

516: x_limit_hold_flag := FND_API.G_MISS_CHAR;
517: x_limit_id := FND_API.G_MISS_NUM;
518: x_limit_level_code := FND_API.G_MISS_CHAR;
519: x_limit_number := FND_API.G_MISS_NUM;
520: x_list_header_id := FND_API.G_MISS_NUM;
521: x_list_line_id := FND_API.G_MISS_NUM;
522: x_multival_attr1_type := FND_API.G_MISS_CHAR;
523: x_multival_attr1_context := FND_API.G_MISS_CHAR;
524: x_multival_attribute1 := FND_API.G_MISS_CHAR;

Line 521: x_list_line_id := FND_API.G_MISS_NUM;

517: x_limit_id := FND_API.G_MISS_NUM;
518: x_limit_level_code := FND_API.G_MISS_CHAR;
519: x_limit_number := FND_API.G_MISS_NUM;
520: x_list_header_id := FND_API.G_MISS_NUM;
521: x_list_line_id := FND_API.G_MISS_NUM;
522: x_multival_attr1_type := FND_API.G_MISS_CHAR;
523: x_multival_attr1_context := FND_API.G_MISS_CHAR;
524: x_multival_attribute1 := FND_API.G_MISS_CHAR;
525: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;

Line 522: x_multival_attr1_type := FND_API.G_MISS_CHAR;

518: x_limit_level_code := FND_API.G_MISS_CHAR;
519: x_limit_number := FND_API.G_MISS_NUM;
520: x_list_header_id := FND_API.G_MISS_NUM;
521: x_list_line_id := FND_API.G_MISS_NUM;
522: x_multival_attr1_type := FND_API.G_MISS_CHAR;
523: x_multival_attr1_context := FND_API.G_MISS_CHAR;
524: x_multival_attribute1 := FND_API.G_MISS_CHAR;
525: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
526: x_multival_attr2_type := FND_API.G_MISS_CHAR;

Line 523: x_multival_attr1_context := FND_API.G_MISS_CHAR;

519: x_limit_number := FND_API.G_MISS_NUM;
520: x_list_header_id := FND_API.G_MISS_NUM;
521: x_list_line_id := FND_API.G_MISS_NUM;
522: x_multival_attr1_type := FND_API.G_MISS_CHAR;
523: x_multival_attr1_context := FND_API.G_MISS_CHAR;
524: x_multival_attribute1 := FND_API.G_MISS_CHAR;
525: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
526: x_multival_attr2_type := FND_API.G_MISS_CHAR;
527: x_multival_attr2_context := FND_API.G_MISS_CHAR;

Line 524: x_multival_attribute1 := FND_API.G_MISS_CHAR;

520: x_list_header_id := FND_API.G_MISS_NUM;
521: x_list_line_id := FND_API.G_MISS_NUM;
522: x_multival_attr1_type := FND_API.G_MISS_CHAR;
523: x_multival_attr1_context := FND_API.G_MISS_CHAR;
524: x_multival_attribute1 := FND_API.G_MISS_CHAR;
525: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
526: x_multival_attr2_type := FND_API.G_MISS_CHAR;
527: x_multival_attr2_context := FND_API.G_MISS_CHAR;
528: x_multival_attribute2 := FND_API.G_MISS_CHAR;

Line 525: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;

521: x_list_line_id := FND_API.G_MISS_NUM;
522: x_multival_attr1_type := FND_API.G_MISS_CHAR;
523: x_multival_attr1_context := FND_API.G_MISS_CHAR;
524: x_multival_attribute1 := FND_API.G_MISS_CHAR;
525: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
526: x_multival_attr2_type := FND_API.G_MISS_CHAR;
527: x_multival_attr2_context := FND_API.G_MISS_CHAR;
528: x_multival_attribute2 := FND_API.G_MISS_CHAR;
529: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;

Line 526: x_multival_attr2_type := FND_API.G_MISS_CHAR;

522: x_multival_attr1_type := FND_API.G_MISS_CHAR;
523: x_multival_attr1_context := FND_API.G_MISS_CHAR;
524: x_multival_attribute1 := FND_API.G_MISS_CHAR;
525: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
526: x_multival_attr2_type := FND_API.G_MISS_CHAR;
527: x_multival_attr2_context := FND_API.G_MISS_CHAR;
528: x_multival_attribute2 := FND_API.G_MISS_CHAR;
529: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
530: x_organization_flag := FND_API.G_MISS_CHAR;

Line 527: x_multival_attr2_context := FND_API.G_MISS_CHAR;

523: x_multival_attr1_context := FND_API.G_MISS_CHAR;
524: x_multival_attribute1 := FND_API.G_MISS_CHAR;
525: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
526: x_multival_attr2_type := FND_API.G_MISS_CHAR;
527: x_multival_attr2_context := FND_API.G_MISS_CHAR;
528: x_multival_attribute2 := FND_API.G_MISS_CHAR;
529: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
530: x_organization_flag := FND_API.G_MISS_CHAR;
531: x_limit_exceed_action := FND_API.G_MISS_CHAR;

Line 528: x_multival_attribute2 := FND_API.G_MISS_CHAR;

524: x_multival_attribute1 := FND_API.G_MISS_CHAR;
525: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
526: x_multival_attr2_type := FND_API.G_MISS_CHAR;
527: x_multival_attr2_context := FND_API.G_MISS_CHAR;
528: x_multival_attribute2 := FND_API.G_MISS_CHAR;
529: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
530: x_organization_flag := FND_API.G_MISS_CHAR;
531: x_limit_exceed_action := FND_API.G_MISS_CHAR;
532: x_limit := FND_API.G_MISS_CHAR;

Line 529: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;

525: x_multival_attr1_datatype := FND_API.G_MISS_CHAR;
526: x_multival_attr2_type := FND_API.G_MISS_CHAR;
527: x_multival_attr2_context := FND_API.G_MISS_CHAR;
528: x_multival_attribute2 := FND_API.G_MISS_CHAR;
529: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
530: x_organization_flag := FND_API.G_MISS_CHAR;
531: x_limit_exceed_action := FND_API.G_MISS_CHAR;
532: x_limit := FND_API.G_MISS_CHAR;
533: x_limit_level := FND_API.G_MISS_CHAR;

Line 530: x_organization_flag := FND_API.G_MISS_CHAR;

526: x_multival_attr2_type := FND_API.G_MISS_CHAR;
527: x_multival_attr2_context := FND_API.G_MISS_CHAR;
528: x_multival_attribute2 := FND_API.G_MISS_CHAR;
529: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
530: x_organization_flag := FND_API.G_MISS_CHAR;
531: x_limit_exceed_action := FND_API.G_MISS_CHAR;
532: x_limit := FND_API.G_MISS_CHAR;
533: x_limit_level := FND_API.G_MISS_CHAR;
534: x_list_header := FND_API.G_MISS_CHAR;

Line 531: x_limit_exceed_action := FND_API.G_MISS_CHAR;

527: x_multival_attr2_context := FND_API.G_MISS_CHAR;
528: x_multival_attribute2 := FND_API.G_MISS_CHAR;
529: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
530: x_organization_flag := FND_API.G_MISS_CHAR;
531: x_limit_exceed_action := FND_API.G_MISS_CHAR;
532: x_limit := FND_API.G_MISS_CHAR;
533: x_limit_level := FND_API.G_MISS_CHAR;
534: x_list_header := FND_API.G_MISS_CHAR;
535: x_list_line := FND_API.G_MISS_CHAR;

Line 532: x_limit := FND_API.G_MISS_CHAR;

528: x_multival_attribute2 := FND_API.G_MISS_CHAR;
529: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
530: x_organization_flag := FND_API.G_MISS_CHAR;
531: x_limit_exceed_action := FND_API.G_MISS_CHAR;
532: x_limit := FND_API.G_MISS_CHAR;
533: x_limit_level := FND_API.G_MISS_CHAR;
534: x_list_header := FND_API.G_MISS_CHAR;
535: x_list_line := FND_API.G_MISS_CHAR;
536: x_organization := FND_API.G_MISS_CHAR;

Line 533: x_limit_level := FND_API.G_MISS_CHAR;

529: x_multival_attr2_datatype := FND_API.G_MISS_CHAR;
530: x_organization_flag := FND_API.G_MISS_CHAR;
531: x_limit_exceed_action := FND_API.G_MISS_CHAR;
532: x_limit := FND_API.G_MISS_CHAR;
533: x_limit_level := FND_API.G_MISS_CHAR;
534: x_list_header := FND_API.G_MISS_CHAR;
535: x_list_line := FND_API.G_MISS_CHAR;
536: x_organization := FND_API.G_MISS_CHAR;
537:

Line 534: x_list_header := FND_API.G_MISS_CHAR;

530: x_organization_flag := FND_API.G_MISS_CHAR;
531: x_limit_exceed_action := FND_API.G_MISS_CHAR;
532: x_limit := FND_API.G_MISS_CHAR;
533: x_limit_level := FND_API.G_MISS_CHAR;
534: x_list_header := FND_API.G_MISS_CHAR;
535: x_list_line := FND_API.G_MISS_CHAR;
536: x_organization := FND_API.G_MISS_CHAR;
537:
538: -- Load display out parameters if any

Line 535: x_list_line := FND_API.G_MISS_CHAR;

531: x_limit_exceed_action := FND_API.G_MISS_CHAR;
532: x_limit := FND_API.G_MISS_CHAR;
533: x_limit_level := FND_API.G_MISS_CHAR;
534: x_list_header := FND_API.G_MISS_CHAR;
535: x_list_line := FND_API.G_MISS_CHAR;
536: x_organization := FND_API.G_MISS_CHAR;
537:
538: -- Load display out parameters if any
539:

Line 536: x_organization := FND_API.G_MISS_CHAR;

532: x_limit := FND_API.G_MISS_CHAR;
533: x_limit_level := FND_API.G_MISS_CHAR;
534: x_list_header := FND_API.G_MISS_CHAR;
535: x_list_line := FND_API.G_MISS_CHAR;
536: x_organization := FND_API.G_MISS_CHAR;
537:
538: -- Load display out parameters if any
539:
540: l_LIMITS_val_rec := QP_Limits_Util.Get_Values

Line 767: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 779: WHEN FND_API.G_EXC_ERROR THEN

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

Line 781: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 877: IF FND_API.To_Boolean(l_LIMITS_rec.db_flag) THEN

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

Line 887: , p_init_msg_list => FND_API.G_TRUE

883: -- Call QP_Limits_PVT.Process_Limits
884:
885: QP_Limits_PVT.Process_Limits
886: ( p_api_version_number => 1.0
887: , p_init_msg_list => FND_API.G_TRUE
888: , x_return_status => l_return_status
889: , x_msg_count => x_msg_count
890: , x_msg_data => x_msg_data
891: , p_control_rec => l_control_rec

Line 899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

895: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
896: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
897: );
898:
899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: END IF;

Line 900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

896: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
897: );
898:
899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: END IF;
904:

Line 901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

897: );
898:
899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: END IF;
904:
905:

Line 902: RAISE FND_API.G_EXC_ERROR;

898:
899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: END IF;
904:
905:
906: -- Load OUT parameters.

Line 926: x_return_status := FND_API.G_RET_STS_SUCCESS;

922:
923:
924: -- Set return status.
925:
926: x_return_status := FND_API.G_RET_STS_SUCCESS;
927:
928: -- Get message count and data
929:
930: OE_MSG_PUB.Count_And_Get

Line 938: WHEN FND_API.G_EXC_ERROR THEN

934:
935:
936: EXCEPTION
937:
938: WHEN FND_API.G_EXC_ERROR THEN
939:
940: x_return_status := FND_API.G_RET_STS_ERROR;
941:
942: -- Get message count and data

Line 940: x_return_status := FND_API.G_RET_STS_ERROR;

936: EXCEPTION
937:
938: WHEN FND_API.G_EXC_ERROR THEN
939:
940: x_return_status := FND_API.G_RET_STS_ERROR;
941:
942: -- Get message count and data
943:
944: OE_MSG_PUB.Count_And_Get

Line 949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

945: ( p_count => x_msg_count
946: , p_data => x_msg_data
947: );
948:
949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
950:
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952:
953: -- Get message count and data

Line 951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

947: );
948:
949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
950:
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952:
953: -- Get message count and data
954:
955: OE_MSG_PUB.Count_And_Get

Line 962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

958: );
959:
960: WHEN OTHERS THEN
961:
962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
963:
964: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
965: THEN
966: OE_MSG_PUB.Add_Exc_Msg

Line 1031: , p_init_msg_list => FND_API.G_TRUE

1027: -- Call QP_Limits_PVT.Process_Limits
1028:
1029: QP_Limits_PVT.Process_Limits
1030: ( p_api_version_number => 1.0
1031: , p_init_msg_list => FND_API.G_TRUE
1032: , x_return_status => l_return_status
1033: , x_msg_count => x_msg_count
1034: , x_msg_data => x_msg_data
1035: , p_control_rec => l_control_rec

Line 1042: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1038: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
1039: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1040: );
1041:
1042: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;

Line 1043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1039: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1040: );
1041:
1042: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047:

Line 1044: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1040: );
1041:
1042: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047:
1048:

Line 1045: RAISE FND_API.G_EXC_ERROR;

1041:
1042: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047:
1048:
1049: -- Clear LIMITS record cache

Line 1055: x_return_status := FND_API.G_RET_STS_SUCCESS;

1051: Clear_LIMITS;
1052:
1053: -- Set return status.
1054:
1055: x_return_status := FND_API.G_RET_STS_SUCCESS;
1056:
1057: -- Get message count and data
1058:
1059: OE_MSG_PUB.Count_And_Get

Line 1067: WHEN FND_API.G_EXC_ERROR THEN

1063:
1064:
1065: EXCEPTION
1066:
1067: WHEN FND_API.G_EXC_ERROR THEN
1068:
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070:
1071: -- Get message count and data

Line 1069: x_return_status := FND_API.G_RET_STS_ERROR;

1065: EXCEPTION
1066:
1067: WHEN FND_API.G_EXC_ERROR THEN
1068:
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070:
1071: -- Get message count and data
1072:
1073: OE_MSG_PUB.Count_And_Get

Line 1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1074: ( p_count => x_msg_count
1075: , p_data => x_msg_data
1076: );
1077:
1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1079:
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1081:
1082: -- Get message count and data

Line 1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1076: );
1077:
1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1079:
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1081:
1082: -- Get message count and data
1083:
1084: OE_MSG_PUB.Count_And_Get

Line 1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1087: );
1088:
1089: WHEN OTHERS THEN
1090:
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1092:
1093: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1094: THEN
1095: OE_MSG_PUB.Add_Exc_Msg

Line 1148: , p_init_msg_list => FND_API.G_TRUE

1144: -- Call QP_Limits_PVT.Process_Limits
1145:
1146: QP_Limits_PVT.Process_Limits
1147: ( p_api_version_number => 1.0
1148: , p_init_msg_list => FND_API.G_TRUE
1149: , x_return_status => l_return_status
1150: , x_msg_count => x_msg_count
1151: , x_msg_data => x_msg_data
1152: , p_control_rec => l_control_rec

Line 1158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1154: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
1155: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1156: );
1157:
1158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;

Line 1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1155: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1156: );
1157:
1158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;
1163:

Line 1160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1156: );
1157:
1158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;
1163:
1164:

Line 1161: RAISE FND_API.G_EXC_ERROR;

1157:
1158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;
1163:
1164:
1165: -- Set return status.

Line 1167: x_return_status := FND_API.G_RET_STS_SUCCESS;

1163:
1164:
1165: -- Set return status.
1166:
1167: x_return_status := FND_API.G_RET_STS_SUCCESS;
1168:
1169: -- Get message count and data
1170:
1171: OE_MSG_PUB.Count_And_Get

Line 1179: WHEN FND_API.G_EXC_ERROR THEN

1175:
1176:
1177: EXCEPTION
1178:
1179: WHEN FND_API.G_EXC_ERROR THEN
1180:
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182:
1183: -- Get message count and data

Line 1181: x_return_status := FND_API.G_RET_STS_ERROR;

1177: EXCEPTION
1178:
1179: WHEN FND_API.G_EXC_ERROR THEN
1180:
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182:
1183: -- Get message count and data
1184:
1185: OE_MSG_PUB.Count_And_Get

Line 1190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1186: ( p_count => x_msg_count
1187: , p_data => x_msg_data
1188: );
1189:
1190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1191:
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1193:
1194: -- Get message count and data

Line 1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1188: );
1189:
1190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1191:
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1193:
1194: -- Get message count and data
1195:
1196: OE_MSG_PUB.Count_And_Get

Line 1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1199: );
1200:
1201: WHEN OTHERS THEN
1202:
1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1204:
1205: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1206: THEN
1207: OE_MSG_PUB.Add_Exc_Msg

Line 1260: , p_init_msg_list => FND_API.G_TRUE

1256: -- Call QP_Limits_PVT.Process_Limits
1257:
1258: QP_Limits_PVT.Process_Limits
1259: ( p_api_version_number => 1.0
1260: , p_init_msg_list => FND_API.G_TRUE
1261: , x_return_status => l_return_status
1262: , x_msg_count => x_msg_count
1263: , x_msg_data => x_msg_data
1264: , p_control_rec => l_control_rec

Line 1270: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1266: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
1267: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1268: );
1269:
1270: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;

Line 1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1267: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1268: );
1269:
1270: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:

Line 1272: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1268: );
1269:
1270: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:
1276:

Line 1273: RAISE FND_API.G_EXC_ERROR;

1269:
1270: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:
1276:
1277: -- Set return status.

Line 1279: x_return_status := FND_API.G_RET_STS_SUCCESS;

1275:
1276:
1277: -- Set return status.
1278:
1279: x_return_status := FND_API.G_RET_STS_SUCCESS;
1280:
1281: -- Get message count and data
1282:
1283: OE_MSG_PUB.Count_And_Get

Line 1291: WHEN FND_API.G_EXC_ERROR THEN

1287:
1288:
1289: EXCEPTION
1290:
1291: WHEN FND_API.G_EXC_ERROR THEN
1292:
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294:
1295: -- Get message count and data

Line 1293: x_return_status := FND_API.G_RET_STS_ERROR;

1289: EXCEPTION
1290:
1291: WHEN FND_API.G_EXC_ERROR THEN
1292:
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294:
1295: -- Get message count and data
1296:
1297: OE_MSG_PUB.Count_And_Get

Line 1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1298: ( p_count => x_msg_count
1299: , p_data => x_msg_data
1300: );
1301:
1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1303:
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1305:
1306: -- Get message count and data

Line 1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1300: );
1301:
1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1303:
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1305:
1306: -- Get message count and data
1307:
1308: OE_MSG_PUB.Count_And_Get

Line 1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1311: );
1312:
1313: WHEN OTHERS THEN
1314:
1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1316:
1317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1318: THEN
1319: OE_MSG_PUB.Add_Exc_Msg

Line 1445: , p_init_msg_list => FND_API.G_TRUE

1441: -- Call QP_Limits_PVT.Lock_Limits
1442:
1443: QP_Limits_PVT.Lock_Limits
1444: ( p_api_version_number => 1.0
1445: , p_init_msg_list => FND_API.G_TRUE
1446: , x_return_status => l_return_status
1447: , x_msg_count => x_msg_count
1448: , x_msg_data => x_msg_data
1449: , p_LIMITS_rec => l_LIMITS_rec

Line 1455: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1451: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
1452: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1453: );
1454:
1455: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1456:
1457: -- Set DB flag and write record to cache.
1458:
1459: l_x_LIMITS_rec.db_flag := FND_API.G_TRUE;

Line 1459: l_x_LIMITS_rec.db_flag := FND_API.G_TRUE;

1455: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1456:
1457: -- Set DB flag and write record to cache.
1458:
1459: l_x_LIMITS_rec.db_flag := FND_API.G_TRUE;
1460:
1461: Write_LIMITS
1462: ( p_LIMITS_rec => l_x_LIMITS_rec
1463: , p_db_record => TRUE

Line 1492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1488: , 'Lock_Row'
1489: );
1490: END IF;
1491:
1492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1493:
1494: -- Get message count and data
1495:
1496: OE_MSG_PUB.Count_And_Get

Line 1541: g_LIMITS_rec.db_flag := FND_API.G_TRUE;

1537: g_LIMITS_rec := QP_Limits_Util.Query_Row
1538: ( p_limit_id => p_limit_id
1539: );
1540:
1541: g_LIMITS_rec.db_flag := FND_API.G_TRUE;
1542:
1543: -- Load DB record
1544:
1545: g_db_LIMITS_rec := g_LIMITS_rec;