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

Line 129: , p_init_msg_list => FND_API.G_TRUE

125: -- Call QP_Limits_PVT.Process_Limits
126:
127: QP_Limits_PVT.Process_Limits
128: ( p_api_version_number => 1.0
129: , p_init_msg_list => FND_API.G_TRUE
130: , x_return_status => l_return_status
131: , x_msg_count => x_msg_count
132: , x_msg_data => x_msg_data
133: , p_control_rec => l_control_rec

Line 140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

136: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
137: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
138: );
139:
140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

137: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
138: );
139:
140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:

Line 142: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

138: );
139:
140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:
146:

Line 143: RAISE FND_API.G_EXC_ERROR;

139:
140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:
146:
147: -- Unload out tbl

Line 189: l_x_LIMIT_ATTRS_rec.db_flag := FND_API.G_FALSE;

185:
186: -- Write to cache.
187: -- Set db_flag to False before writing to cache
188:
189: l_x_LIMIT_ATTRS_rec.db_flag := FND_API.G_FALSE;
190:
191: Write_LIMIT_ATTRS
192: ( p_LIMIT_ATTRS_rec => l_x_LIMIT_ATTRS_rec
193: );

Line 197: x_return_status := FND_API.G_RET_STS_SUCCESS;

193: );
194:
195: -- Set return status.
196:
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: -- Get message count and data
200:
201: OE_MSG_PUB.Count_And_Get

Line 209: WHEN FND_API.G_EXC_ERROR THEN

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

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: EXCEPTION
208:
209: WHEN FND_API.G_EXC_ERROR THEN
210:
211: x_return_status := FND_API.G_RET_STS_ERROR;
212:
213: -- Get message count and data
214:
215: OE_MSG_PUB.Count_And_Get

Line 220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

216: ( p_count => x_msg_count
217: , p_data => x_msg_data
218: );
219:
220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
221:
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223:
224: -- Get message count and data

Line 222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

218: );
219:
220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
221:
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223:
224: -- Get message count and data
225:
226: OE_MSG_PUB.Count_And_Get

Line 233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

229: );
230:
231: WHEN OTHERS THEN
232:
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234:
235: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
236: THEN
237: OE_MSG_PUB.Add_Exc_Msg

Line 408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

404: , 'Unrecognized attribute'
405: );
406: END IF;
407:
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409:
410: END IF;
411:
412: -- Set Operation.

Line 414: IF FND_API.To_Boolean(l_LIMIT_ATTRS_rec.db_flag) THEN

410: END IF;
411:
412: -- Set Operation.
413:
414: IF FND_API.To_Boolean(l_LIMIT_ATTRS_rec.db_flag) THEN
415: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
416: ELSE
417: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
418: END IF;

Line 429: , p_init_msg_list => FND_API.G_TRUE

425: -- Call QP_Limits_PVT.Process_Limits
426:
427: QP_Limits_PVT.Process_Limits
428: ( p_api_version_number => 1.0
429: , p_init_msg_list => FND_API.G_TRUE
430: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
431: , x_return_status => l_return_status
432: , x_msg_count => x_msg_count
433: , x_msg_data => x_msg_data

Line 430: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

Line 442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

438: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
439: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
440: );
441:
442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;

Line 443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

439: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
440: );
441:
442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447:

Line 444: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

440: );
441:
442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447:
448:

Line 445: RAISE FND_API.G_EXC_ERROR;

441:
442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447:
448:
449: -- Unload out tbl

Line 455: x_attribute1 := FND_API.G_MISS_CHAR;

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

Line 456: x_attribute10 := FND_API.G_MISS_CHAR;

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

Line 457: x_attribute11 := FND_API.G_MISS_CHAR;

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

Line 458: x_attribute12 := FND_API.G_MISS_CHAR;

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

Line 459: x_attribute13 := FND_API.G_MISS_CHAR;

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

Line 460: x_attribute14 := FND_API.G_MISS_CHAR;

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

Line 461: x_attribute15 := FND_API.G_MISS_CHAR;

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

Line 462: x_attribute2 := FND_API.G_MISS_CHAR;

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

Line 463: x_attribute3 := FND_API.G_MISS_CHAR;

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

Line 464: x_attribute4 := FND_API.G_MISS_CHAR;

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

Line 465: x_attribute5 := FND_API.G_MISS_CHAR;

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

Line 466: x_attribute6 := FND_API.G_MISS_CHAR;

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

Line 467: x_attribute7 := FND_API.G_MISS_CHAR;

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

Line 468: x_attribute8 := FND_API.G_MISS_CHAR;

464: x_attribute4 := FND_API.G_MISS_CHAR;
465: x_attribute5 := FND_API.G_MISS_CHAR;
466: x_attribute6 := FND_API.G_MISS_CHAR;
467: x_attribute7 := FND_API.G_MISS_CHAR;
468: x_attribute8 := FND_API.G_MISS_CHAR;
469: x_attribute9 := FND_API.G_MISS_CHAR;
470: x_comparison_operator_code := FND_API.G_MISS_CHAR;
471: x_context := FND_API.G_MISS_CHAR;
472: x_limit_attribute := FND_API.G_MISS_CHAR;

Line 469: x_attribute9 := FND_API.G_MISS_CHAR;

465: x_attribute5 := FND_API.G_MISS_CHAR;
466: x_attribute6 := FND_API.G_MISS_CHAR;
467: x_attribute7 := FND_API.G_MISS_CHAR;
468: x_attribute8 := FND_API.G_MISS_CHAR;
469: x_attribute9 := FND_API.G_MISS_CHAR;
470: x_comparison_operator_code := FND_API.G_MISS_CHAR;
471: x_context := FND_API.G_MISS_CHAR;
472: x_limit_attribute := FND_API.G_MISS_CHAR;
473: x_limit_attribute_context := FND_API.G_MISS_CHAR;

Line 470: x_comparison_operator_code := FND_API.G_MISS_CHAR;

466: x_attribute6 := FND_API.G_MISS_CHAR;
467: x_attribute7 := FND_API.G_MISS_CHAR;
468: x_attribute8 := FND_API.G_MISS_CHAR;
469: x_attribute9 := FND_API.G_MISS_CHAR;
470: x_comparison_operator_code := FND_API.G_MISS_CHAR;
471: x_context := FND_API.G_MISS_CHAR;
472: x_limit_attribute := FND_API.G_MISS_CHAR;
473: x_limit_attribute_context := FND_API.G_MISS_CHAR;
474: x_limit_attribute_id := FND_API.G_MISS_NUM;

Line 471: x_context := FND_API.G_MISS_CHAR;

467: x_attribute7 := FND_API.G_MISS_CHAR;
468: x_attribute8 := FND_API.G_MISS_CHAR;
469: x_attribute9 := FND_API.G_MISS_CHAR;
470: x_comparison_operator_code := FND_API.G_MISS_CHAR;
471: x_context := FND_API.G_MISS_CHAR;
472: x_limit_attribute := FND_API.G_MISS_CHAR;
473: x_limit_attribute_context := FND_API.G_MISS_CHAR;
474: x_limit_attribute_id := FND_API.G_MISS_NUM;
475: x_limit_attribute_type := FND_API.G_MISS_CHAR;

Line 472: x_limit_attribute := FND_API.G_MISS_CHAR;

468: x_attribute8 := FND_API.G_MISS_CHAR;
469: x_attribute9 := FND_API.G_MISS_CHAR;
470: x_comparison_operator_code := FND_API.G_MISS_CHAR;
471: x_context := FND_API.G_MISS_CHAR;
472: x_limit_attribute := FND_API.G_MISS_CHAR;
473: x_limit_attribute_context := FND_API.G_MISS_CHAR;
474: x_limit_attribute_id := FND_API.G_MISS_NUM;
475: x_limit_attribute_type := FND_API.G_MISS_CHAR;
476: x_limit_attr_datatype := FND_API.G_MISS_CHAR;

Line 473: x_limit_attribute_context := FND_API.G_MISS_CHAR;

469: x_attribute9 := FND_API.G_MISS_CHAR;
470: x_comparison_operator_code := FND_API.G_MISS_CHAR;
471: x_context := FND_API.G_MISS_CHAR;
472: x_limit_attribute := FND_API.G_MISS_CHAR;
473: x_limit_attribute_context := FND_API.G_MISS_CHAR;
474: x_limit_attribute_id := FND_API.G_MISS_NUM;
475: x_limit_attribute_type := FND_API.G_MISS_CHAR;
476: x_limit_attr_datatype := FND_API.G_MISS_CHAR;
477: x_limit_attr_value := FND_API.G_MISS_CHAR;

Line 474: x_limit_attribute_id := FND_API.G_MISS_NUM;

470: x_comparison_operator_code := FND_API.G_MISS_CHAR;
471: x_context := FND_API.G_MISS_CHAR;
472: x_limit_attribute := FND_API.G_MISS_CHAR;
473: x_limit_attribute_context := FND_API.G_MISS_CHAR;
474: x_limit_attribute_id := FND_API.G_MISS_NUM;
475: x_limit_attribute_type := FND_API.G_MISS_CHAR;
476: x_limit_attr_datatype := FND_API.G_MISS_CHAR;
477: x_limit_attr_value := FND_API.G_MISS_CHAR;
478: x_limit_id := FND_API.G_MISS_NUM;

Line 475: x_limit_attribute_type := FND_API.G_MISS_CHAR;

471: x_context := FND_API.G_MISS_CHAR;
472: x_limit_attribute := FND_API.G_MISS_CHAR;
473: x_limit_attribute_context := FND_API.G_MISS_CHAR;
474: x_limit_attribute_id := FND_API.G_MISS_NUM;
475: x_limit_attribute_type := FND_API.G_MISS_CHAR;
476: x_limit_attr_datatype := FND_API.G_MISS_CHAR;
477: x_limit_attr_value := FND_API.G_MISS_CHAR;
478: x_limit_id := FND_API.G_MISS_NUM;
479: x_comparison_operator := FND_API.G_MISS_CHAR;

Line 476: x_limit_attr_datatype := FND_API.G_MISS_CHAR;

472: x_limit_attribute := FND_API.G_MISS_CHAR;
473: x_limit_attribute_context := FND_API.G_MISS_CHAR;
474: x_limit_attribute_id := FND_API.G_MISS_NUM;
475: x_limit_attribute_type := FND_API.G_MISS_CHAR;
476: x_limit_attr_datatype := FND_API.G_MISS_CHAR;
477: x_limit_attr_value := FND_API.G_MISS_CHAR;
478: x_limit_id := FND_API.G_MISS_NUM;
479: x_comparison_operator := FND_API.G_MISS_CHAR;
480: x_limit := FND_API.G_MISS_CHAR;

Line 477: x_limit_attr_value := FND_API.G_MISS_CHAR;

473: x_limit_attribute_context := FND_API.G_MISS_CHAR;
474: x_limit_attribute_id := FND_API.G_MISS_NUM;
475: x_limit_attribute_type := FND_API.G_MISS_CHAR;
476: x_limit_attr_datatype := FND_API.G_MISS_CHAR;
477: x_limit_attr_value := FND_API.G_MISS_CHAR;
478: x_limit_id := FND_API.G_MISS_NUM;
479: x_comparison_operator := FND_API.G_MISS_CHAR;
480: x_limit := FND_API.G_MISS_CHAR;
481:

Line 478: x_limit_id := FND_API.G_MISS_NUM;

474: x_limit_attribute_id := FND_API.G_MISS_NUM;
475: x_limit_attribute_type := FND_API.G_MISS_CHAR;
476: x_limit_attr_datatype := FND_API.G_MISS_CHAR;
477: x_limit_attr_value := FND_API.G_MISS_CHAR;
478: x_limit_id := FND_API.G_MISS_NUM;
479: x_comparison_operator := FND_API.G_MISS_CHAR;
480: x_limit := FND_API.G_MISS_CHAR;
481:
482: -- Load display out parameters if any

Line 479: x_comparison_operator := FND_API.G_MISS_CHAR;

475: x_limit_attribute_type := FND_API.G_MISS_CHAR;
476: x_limit_attr_datatype := FND_API.G_MISS_CHAR;
477: x_limit_attr_value := FND_API.G_MISS_CHAR;
478: x_limit_id := FND_API.G_MISS_NUM;
479: x_comparison_operator := FND_API.G_MISS_CHAR;
480: x_limit := FND_API.G_MISS_CHAR;
481:
482: -- Load display out parameters if any
483:

Line 480: x_limit := FND_API.G_MISS_CHAR;

476: x_limit_attr_datatype := FND_API.G_MISS_CHAR;
477: x_limit_attr_value := FND_API.G_MISS_CHAR;
478: x_limit_id := FND_API.G_MISS_NUM;
479: x_comparison_operator := FND_API.G_MISS_CHAR;
480: x_limit := FND_API.G_MISS_CHAR;
481:
482: -- Load display out parameters if any
483:
484: l_LIMIT_ATTRS_val_rec := QP_Limit_Attrs_Util.Get_Values

Line 647: x_return_status := FND_API.G_RET_STS_SUCCESS;

643: );
644:
645: -- Set return status.
646:
647: x_return_status := FND_API.G_RET_STS_SUCCESS;
648:
649: -- Get message count and data
650:
651: OE_MSG_PUB.Count_And_Get

Line 659: WHEN FND_API.G_EXC_ERROR THEN

655:
656:
657: EXCEPTION
658:
659: WHEN FND_API.G_EXC_ERROR THEN
660:
661: x_return_status := FND_API.G_RET_STS_ERROR;
662:
663: -- Get message count and data

Line 661: x_return_status := FND_API.G_RET_STS_ERROR;

657: EXCEPTION
658:
659: WHEN FND_API.G_EXC_ERROR THEN
660:
661: x_return_status := FND_API.G_RET_STS_ERROR;
662:
663: -- Get message count and data
664:
665: OE_MSG_PUB.Count_And_Get

Line 670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

666: ( p_count => x_msg_count
667: , p_data => x_msg_data
668: );
669:
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671:
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
673:
674: -- Get message count and data

Line 672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

668: );
669:
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671:
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
673:
674: -- Get message count and data
675:
676: OE_MSG_PUB.Count_And_Get

Line 683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

679: );
680:
681: WHEN OTHERS THEN
682:
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
684:
685: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: THEN
687: OE_MSG_PUB.Add_Exc_Msg

Line 759: IF FND_API.To_Boolean(l_LIMIT_ATTRS_rec.db_flag) THEN

755: );
756:
757: -- Set Operation.
758:
759: IF FND_API.To_Boolean(l_LIMIT_ATTRS_rec.db_flag) THEN
760: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
761: ELSE
762: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
763: END IF;

Line 774: , p_init_msg_list => FND_API.G_TRUE

770: -- Call QP_Limits_PVT.Process_Limits
771:
772: QP_Limits_PVT.Process_Limits
773: ( p_api_version_number => 1.0
774: , p_init_msg_list => FND_API.G_TRUE
775: , x_return_status => l_return_status
776: , x_msg_count => x_msg_count
777: , x_msg_data => x_msg_data
778: , p_control_rec => l_control_rec

Line 786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

782: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
783: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
784: );
785:
786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;

Line 787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

783: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
784: );
785:
786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;
791:

Line 788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

784: );
785:
786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;
791:
792:

Line 789: RAISE FND_API.G_EXC_ERROR;

785:
786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;
791:
792:
793: -- Load OUT parameters.

Line 814: x_return_status := FND_API.G_RET_STS_SUCCESS;

810:
811:
812: -- Set return status.
813:
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: -- Get message count and data
817:
818: OE_MSG_PUB.Count_And_Get

Line 826: WHEN FND_API.G_EXC_ERROR THEN

822:
823:
824: EXCEPTION
825:
826: WHEN FND_API.G_EXC_ERROR THEN
827:
828: x_return_status := FND_API.G_RET_STS_ERROR;
829:
830: -- Get message count and data

Line 828: x_return_status := FND_API.G_RET_STS_ERROR;

824: EXCEPTION
825:
826: WHEN FND_API.G_EXC_ERROR THEN
827:
828: x_return_status := FND_API.G_RET_STS_ERROR;
829:
830: -- Get message count and data
831:
832: OE_MSG_PUB.Count_And_Get

Line 837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

833: ( p_count => x_msg_count
834: , p_data => x_msg_data
835: );
836:
837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
838:
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
840:
841: -- Get message count and data

Line 839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

846: );
847:
848: WHEN OTHERS THEN
849:
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
851:
852: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
853: THEN
854: OE_MSG_PUB.Add_Exc_Msg

Line 924: , p_init_msg_list => FND_API.G_TRUE

920: -- Call QP_Limits_PVT.Process_Limits
921:
922: QP_Limits_PVT.Process_Limits
923: ( p_api_version_number => 1.0
924: , p_init_msg_list => FND_API.G_TRUE
925: , x_return_status => l_return_status
926: , x_msg_count => x_msg_count
927: , x_msg_data => x_msg_data
928: , p_control_rec => l_control_rec

Line 935: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

931: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
932: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
933: );
934:
935: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
937: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;

Line 936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

932: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
933: );
934:
935: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
937: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940:

Line 937: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

933: );
934:
935: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
937: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940:
941:

Line 938: RAISE FND_API.G_EXC_ERROR;

934:
935: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
937: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940:
941:
942: -- Clear LIMIT_ATTRS record cache

Line 948: x_return_status := FND_API.G_RET_STS_SUCCESS;

944: Clear_LIMIT_ATTRS;
945:
946: -- Set return status.
947:
948: x_return_status := FND_API.G_RET_STS_SUCCESS;
949:
950: -- Get message count and data
951:
952: OE_MSG_PUB.Count_And_Get

Line 960: WHEN FND_API.G_EXC_ERROR THEN

956:
957:
958: EXCEPTION
959:
960: WHEN FND_API.G_EXC_ERROR THEN
961:
962: x_return_status := FND_API.G_RET_STS_ERROR;
963:
964: -- Get message count and data

Line 962: x_return_status := FND_API.G_RET_STS_ERROR;

958: EXCEPTION
959:
960: WHEN FND_API.G_EXC_ERROR THEN
961:
962: x_return_status := FND_API.G_RET_STS_ERROR;
963:
964: -- Get message count and data
965:
966: OE_MSG_PUB.Count_And_Get

Line 971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

967: ( p_count => x_msg_count
968: , p_data => x_msg_data
969: );
970:
971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
972:
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
974:
975: -- Get message count and data

Line 973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

969: );
970:
971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
972:
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
974:
975: -- Get message count and data
976:
977: OE_MSG_PUB.Count_And_Get

Line 984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

980: );
981:
982: WHEN OTHERS THEN
983:
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
985:
986: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
987: THEN
988: OE_MSG_PUB.Add_Exc_Msg

Line 1041: , p_init_msg_list => FND_API.G_TRUE

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

Line 1051: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1053: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1049: );
1050:
1051: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056:
1057:

Line 1054: RAISE FND_API.G_EXC_ERROR;

1050:
1051: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056:
1057:
1058: -- Set return status.

Line 1060: x_return_status := FND_API.G_RET_STS_SUCCESS;

1056:
1057:
1058: -- Set return status.
1059:
1060: x_return_status := FND_API.G_RET_STS_SUCCESS;
1061:
1062: -- Get message count and data
1063:
1064: OE_MSG_PUB.Count_And_Get

Line 1072: WHEN FND_API.G_EXC_ERROR THEN

1068:
1069:
1070: EXCEPTION
1071:
1072: WHEN FND_API.G_EXC_ERROR THEN
1073:
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075:
1076: -- Get message count and data

Line 1074: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1079: ( p_count => x_msg_count
1080: , p_data => x_msg_data
1081: );
1082:
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1084:
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1086:
1087: -- Get message count and data

Line 1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1081: );
1082:
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1084:
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1086:
1087: -- Get message count and data
1088:
1089: OE_MSG_PUB.Count_And_Get

Line 1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1092: );
1093:
1094: WHEN OTHERS THEN
1095:
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1097:
1098: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1099: THEN
1100: OE_MSG_PUB.Add_Exc_Msg

Line 1211: , p_init_msg_list => FND_API.G_TRUE

1207: -- Call QP_Limits_PVT.Lock_Limits
1208:
1209: QP_Limits_PVT.Lock_Limits
1210: ( p_api_version_number => 1.0
1211: , p_init_msg_list => FND_API.G_TRUE
1212: , x_return_status => l_return_status
1213: , x_msg_count => x_msg_count
1214: , x_msg_data => x_msg_data
1215: , p_LIMIT_ATTRS_tbl => l_LIMIT_ATTRS_tbl

Line 1221: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1217: , x_LIMIT_ATTRS_tbl => l_x_LIMIT_ATTRS_tbl
1218: , x_LIMIT_BALANCES_tbl => l_x_LIMIT_BALANCES_tbl
1219: );
1220:
1221: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1222:
1223: -- Set DB flag and write record to cache.
1224:
1225: l_x_LIMIT_ATTRS_rec.db_flag := FND_API.G_TRUE;

Line 1225: l_x_LIMIT_ATTRS_rec.db_flag := FND_API.G_TRUE;

1221: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1222:
1223: -- Set DB flag and write record to cache.
1224:
1225: l_x_LIMIT_ATTRS_rec.db_flag := FND_API.G_TRUE;
1226:
1227: Write_LIMIT_ATTRS
1228: ( p_LIMIT_ATTRS_rec => l_x_LIMIT_ATTRS_rec
1229: , p_db_record => TRUE

Line 1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1254: , 'Lock_Row'
1255: );
1256: END IF;
1257:
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1259:
1260: -- Get message count and data
1261:
1262: OE_MSG_PUB.Count_And_Get

Line 1307: g_LIMIT_ATTRS_rec.db_flag := FND_API.G_TRUE;

1303: g_LIMIT_ATTRS_rec := QP_Limit_Attrs_Util.Query_Row
1304: ( p_limit_attribute_id => p_limit_attribute_id
1305: );
1306:
1307: g_LIMIT_ATTRS_rec.db_flag := FND_API.G_TRUE;
1308:
1309: -- Load DB record
1310:
1311: g_db_LIMIT_ATTRS_rec := g_LIMIT_ATTRS_rec;