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

Line 141: , p_init_msg_list => FND_API.G_TRUE

137: -- Call QP_Attributes_PVT.Process_Attributes
138:
139: QP_Attributes_PVT.Process_Attributes
140: ( p_api_version_number => 1.0
141: , p_init_msg_list => FND_API.G_TRUE
142: , x_return_status => l_return_status
143: , x_msg_count => x_msg_count
144: , x_msg_data => x_msg_data
145: , p_control_rec => l_control_rec

Line 151: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 153: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 154: RAISE FND_API.G_EXC_ERROR;

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

Line 214: l_x_SEG_rec.db_flag := FND_API.G_FALSE;

210:
211: -- Write to cache.
212: -- Set db_flag to False before writing to cache
213:
214: l_x_SEG_rec.db_flag := FND_API.G_FALSE;
215:
216: Write_SEG
217: ( p_SEG_rec => l_x_SEG_rec
218: );

Line 222: x_return_status := FND_API.G_RET_STS_SUCCESS;

218: );
219:
220: -- Set return status.
221:
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223:
224: -- Get message count and data
225:
226: OE_MSG_PUB.Count_And_Get

Line 234: WHEN FND_API.G_EXC_ERROR THEN

230:
231:
232: EXCEPTION
233:
234: WHEN FND_API.G_EXC_ERROR THEN
235:
236: x_return_status := FND_API.G_RET_STS_ERROR;
237:
238: -- Get message count and data

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

232: EXCEPTION
233:
234: WHEN FND_API.G_EXC_ERROR THEN
235:
236: x_return_status := FND_API.G_RET_STS_ERROR;
237:
238: -- Get message count and data
239:
240: OE_MSG_PUB.Count_And_Get

Line 245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

241: ( p_count => x_msg_count
242: , p_data => x_msg_data
243: );
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248:
249: -- Get message count and data

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

243: );
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248:
249: -- Get message count and data
250:
251: OE_MSG_PUB.Count_And_Get

Line 258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

254: );
255:
256: WHEN OTHERS THEN
257:
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259:
260: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
261: THEN
262: OE_MSG_PUB.Add_Exc_Msg

Line 468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

464: , 'Unrecognized attribute'
465: );
466: END IF;
467:
468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
469:
470: END IF;
471:
472: -- Set Operation.

Line 474: IF FND_API.To_Boolean(l_SEG_rec.db_flag) THEN

470: END IF;
471:
472: -- Set Operation.
473:
474: IF FND_API.To_Boolean(l_SEG_rec.db_flag) THEN
475: l_SEG_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
476: ELSE
477: l_SEG_rec.operation := QP_GLOBALS.G_OPR_CREATE;
478: END IF;

Line 489: , p_init_msg_list => FND_API.G_TRUE

485: -- Call QP_Attributes_PVT.Process_Attributes
486:
487: QP_Attributes_PVT.Process_Attributes
488: ( p_api_version_number => 1.0
489: , p_init_msg_list => FND_API.G_TRUE
490: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
491: , x_return_status => l_return_status
492: , x_msg_count => x_msg_count
493: , x_msg_data => x_msg_data

Line 490: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

486:
487: QP_Attributes_PVT.Process_Attributes
488: ( p_api_version_number => 1.0
489: , p_init_msg_list => FND_API.G_TRUE
490: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
491: , x_return_status => l_return_status
492: , x_msg_count => x_msg_count
493: , x_msg_data => x_msg_data
494: , p_control_rec => l_control_rec

Line 501: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

497: , x_CON_rec => l_x_CON_rec
498: , x_SEG_tbl => l_x_SEG_tbl
499: );
500:
501: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;

Line 502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

498: , x_SEG_tbl => l_x_SEG_tbl
499: );
500:
501: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:

Line 503: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

499: );
500:
501: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507:

Line 504: RAISE FND_API.G_EXC_ERROR;

500:
501: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507:
508: -- Unload out tbl

Line 514: x_attribute1 := FND_API.G_MISS_CHAR;

510: l_x_SEG_rec := l_x_SEG_tbl(1);
511:
512: -- Init OUT parameters to missing.
513:
514: x_attribute1 := FND_API.G_MISS_CHAR;
515: x_attribute10 := FND_API.G_MISS_CHAR;
516: x_attribute11 := FND_API.G_MISS_CHAR;
517: x_attribute12 := FND_API.G_MISS_CHAR;
518: x_attribute13 := FND_API.G_MISS_CHAR;

Line 515: x_attribute10 := FND_API.G_MISS_CHAR;

511:
512: -- Init OUT parameters to missing.
513:
514: x_attribute1 := FND_API.G_MISS_CHAR;
515: x_attribute10 := FND_API.G_MISS_CHAR;
516: x_attribute11 := FND_API.G_MISS_CHAR;
517: x_attribute12 := FND_API.G_MISS_CHAR;
518: x_attribute13 := FND_API.G_MISS_CHAR;
519: x_attribute14 := FND_API.G_MISS_CHAR;

Line 516: x_attribute11 := FND_API.G_MISS_CHAR;

512: -- Init OUT parameters to missing.
513:
514: x_attribute1 := FND_API.G_MISS_CHAR;
515: x_attribute10 := FND_API.G_MISS_CHAR;
516: x_attribute11 := FND_API.G_MISS_CHAR;
517: x_attribute12 := FND_API.G_MISS_CHAR;
518: x_attribute13 := FND_API.G_MISS_CHAR;
519: x_attribute14 := FND_API.G_MISS_CHAR;
520: x_attribute15 := FND_API.G_MISS_CHAR;

Line 517: x_attribute12 := FND_API.G_MISS_CHAR;

513:
514: x_attribute1 := FND_API.G_MISS_CHAR;
515: x_attribute10 := FND_API.G_MISS_CHAR;
516: x_attribute11 := FND_API.G_MISS_CHAR;
517: x_attribute12 := FND_API.G_MISS_CHAR;
518: x_attribute13 := FND_API.G_MISS_CHAR;
519: x_attribute14 := FND_API.G_MISS_CHAR;
520: x_attribute15 := FND_API.G_MISS_CHAR;
521: x_attribute2 := FND_API.G_MISS_CHAR;

Line 518: x_attribute13 := FND_API.G_MISS_CHAR;

514: x_attribute1 := FND_API.G_MISS_CHAR;
515: x_attribute10 := FND_API.G_MISS_CHAR;
516: x_attribute11 := FND_API.G_MISS_CHAR;
517: x_attribute12 := FND_API.G_MISS_CHAR;
518: x_attribute13 := FND_API.G_MISS_CHAR;
519: x_attribute14 := FND_API.G_MISS_CHAR;
520: x_attribute15 := FND_API.G_MISS_CHAR;
521: x_attribute2 := FND_API.G_MISS_CHAR;
522: x_attribute3 := FND_API.G_MISS_CHAR;

Line 519: x_attribute14 := FND_API.G_MISS_CHAR;

515: x_attribute10 := FND_API.G_MISS_CHAR;
516: x_attribute11 := FND_API.G_MISS_CHAR;
517: x_attribute12 := FND_API.G_MISS_CHAR;
518: x_attribute13 := FND_API.G_MISS_CHAR;
519: x_attribute14 := FND_API.G_MISS_CHAR;
520: x_attribute15 := FND_API.G_MISS_CHAR;
521: x_attribute2 := FND_API.G_MISS_CHAR;
522: x_attribute3 := FND_API.G_MISS_CHAR;
523: x_attribute4 := FND_API.G_MISS_CHAR;

Line 520: x_attribute15 := FND_API.G_MISS_CHAR;

516: x_attribute11 := FND_API.G_MISS_CHAR;
517: x_attribute12 := FND_API.G_MISS_CHAR;
518: x_attribute13 := FND_API.G_MISS_CHAR;
519: x_attribute14 := FND_API.G_MISS_CHAR;
520: x_attribute15 := FND_API.G_MISS_CHAR;
521: x_attribute2 := FND_API.G_MISS_CHAR;
522: x_attribute3 := FND_API.G_MISS_CHAR;
523: x_attribute4 := FND_API.G_MISS_CHAR;
524: x_attribute5 := FND_API.G_MISS_CHAR;

Line 521: x_attribute2 := FND_API.G_MISS_CHAR;

517: x_attribute12 := FND_API.G_MISS_CHAR;
518: x_attribute13 := FND_API.G_MISS_CHAR;
519: x_attribute14 := FND_API.G_MISS_CHAR;
520: x_attribute15 := FND_API.G_MISS_CHAR;
521: x_attribute2 := FND_API.G_MISS_CHAR;
522: x_attribute3 := FND_API.G_MISS_CHAR;
523: x_attribute4 := FND_API.G_MISS_CHAR;
524: x_attribute5 := FND_API.G_MISS_CHAR;
525: x_attribute6 := FND_API.G_MISS_CHAR;

Line 522: x_attribute3 := FND_API.G_MISS_CHAR;

518: x_attribute13 := FND_API.G_MISS_CHAR;
519: x_attribute14 := FND_API.G_MISS_CHAR;
520: x_attribute15 := FND_API.G_MISS_CHAR;
521: x_attribute2 := FND_API.G_MISS_CHAR;
522: x_attribute3 := FND_API.G_MISS_CHAR;
523: x_attribute4 := FND_API.G_MISS_CHAR;
524: x_attribute5 := FND_API.G_MISS_CHAR;
525: x_attribute6 := FND_API.G_MISS_CHAR;
526: x_attribute7 := FND_API.G_MISS_CHAR;

Line 523: x_attribute4 := FND_API.G_MISS_CHAR;

519: x_attribute14 := FND_API.G_MISS_CHAR;
520: x_attribute15 := FND_API.G_MISS_CHAR;
521: x_attribute2 := FND_API.G_MISS_CHAR;
522: x_attribute3 := FND_API.G_MISS_CHAR;
523: x_attribute4 := FND_API.G_MISS_CHAR;
524: x_attribute5 := FND_API.G_MISS_CHAR;
525: x_attribute6 := FND_API.G_MISS_CHAR;
526: x_attribute7 := FND_API.G_MISS_CHAR;
527: x_attribute8 := FND_API.G_MISS_CHAR;

Line 524: x_attribute5 := FND_API.G_MISS_CHAR;

520: x_attribute15 := FND_API.G_MISS_CHAR;
521: x_attribute2 := FND_API.G_MISS_CHAR;
522: x_attribute3 := FND_API.G_MISS_CHAR;
523: x_attribute4 := FND_API.G_MISS_CHAR;
524: x_attribute5 := FND_API.G_MISS_CHAR;
525: x_attribute6 := FND_API.G_MISS_CHAR;
526: x_attribute7 := FND_API.G_MISS_CHAR;
527: x_attribute8 := FND_API.G_MISS_CHAR;
528: x_attribute9 := FND_API.G_MISS_CHAR;

Line 525: x_attribute6 := FND_API.G_MISS_CHAR;

521: x_attribute2 := FND_API.G_MISS_CHAR;
522: x_attribute3 := FND_API.G_MISS_CHAR;
523: x_attribute4 := FND_API.G_MISS_CHAR;
524: x_attribute5 := FND_API.G_MISS_CHAR;
525: x_attribute6 := FND_API.G_MISS_CHAR;
526: x_attribute7 := FND_API.G_MISS_CHAR;
527: x_attribute8 := FND_API.G_MISS_CHAR;
528: x_attribute9 := FND_API.G_MISS_CHAR;
529: x_availability_in_basic := FND_API.G_MISS_CHAR;

Line 526: x_attribute7 := FND_API.G_MISS_CHAR;

522: x_attribute3 := FND_API.G_MISS_CHAR;
523: x_attribute4 := FND_API.G_MISS_CHAR;
524: x_attribute5 := FND_API.G_MISS_CHAR;
525: x_attribute6 := FND_API.G_MISS_CHAR;
526: x_attribute7 := FND_API.G_MISS_CHAR;
527: x_attribute8 := FND_API.G_MISS_CHAR;
528: x_attribute9 := FND_API.G_MISS_CHAR;
529: x_availability_in_basic := FND_API.G_MISS_CHAR;
530: x_context := FND_API.G_MISS_CHAR;

Line 527: x_attribute8 := FND_API.G_MISS_CHAR;

523: x_attribute4 := FND_API.G_MISS_CHAR;
524: x_attribute5 := FND_API.G_MISS_CHAR;
525: x_attribute6 := FND_API.G_MISS_CHAR;
526: x_attribute7 := FND_API.G_MISS_CHAR;
527: x_attribute8 := FND_API.G_MISS_CHAR;
528: x_attribute9 := FND_API.G_MISS_CHAR;
529: x_availability_in_basic := FND_API.G_MISS_CHAR;
530: x_context := FND_API.G_MISS_CHAR;
531: x_prc_context_id := FND_API.G_MISS_NUM;

Line 528: x_attribute9 := FND_API.G_MISS_CHAR;

524: x_attribute5 := FND_API.G_MISS_CHAR;
525: x_attribute6 := FND_API.G_MISS_CHAR;
526: x_attribute7 := FND_API.G_MISS_CHAR;
527: x_attribute8 := FND_API.G_MISS_CHAR;
528: x_attribute9 := FND_API.G_MISS_CHAR;
529: x_availability_in_basic := FND_API.G_MISS_CHAR;
530: x_context := FND_API.G_MISS_CHAR;
531: x_prc_context_id := FND_API.G_MISS_NUM;
532: x_seeded_flag := FND_API.G_MISS_CHAR;

Line 529: x_availability_in_basic := FND_API.G_MISS_CHAR;

525: x_attribute6 := FND_API.G_MISS_CHAR;
526: x_attribute7 := FND_API.G_MISS_CHAR;
527: x_attribute8 := FND_API.G_MISS_CHAR;
528: x_attribute9 := FND_API.G_MISS_CHAR;
529: x_availability_in_basic := FND_API.G_MISS_CHAR;
530: x_context := FND_API.G_MISS_CHAR;
531: x_prc_context_id := FND_API.G_MISS_NUM;
532: x_seeded_flag := FND_API.G_MISS_CHAR;
533: x_seeded_format_type := FND_API.G_MISS_CHAR;

Line 530: x_context := FND_API.G_MISS_CHAR;

526: x_attribute7 := FND_API.G_MISS_CHAR;
527: x_attribute8 := FND_API.G_MISS_CHAR;
528: x_attribute9 := FND_API.G_MISS_CHAR;
529: x_availability_in_basic := FND_API.G_MISS_CHAR;
530: x_context := FND_API.G_MISS_CHAR;
531: x_prc_context_id := FND_API.G_MISS_NUM;
532: x_seeded_flag := FND_API.G_MISS_CHAR;
533: x_seeded_format_type := FND_API.G_MISS_CHAR;
534: x_seeded_precedence := FND_API.G_MISS_NUM;

Line 531: x_prc_context_id := FND_API.G_MISS_NUM;

527: x_attribute8 := FND_API.G_MISS_CHAR;
528: x_attribute9 := FND_API.G_MISS_CHAR;
529: x_availability_in_basic := FND_API.G_MISS_CHAR;
530: x_context := FND_API.G_MISS_CHAR;
531: x_prc_context_id := FND_API.G_MISS_NUM;
532: x_seeded_flag := FND_API.G_MISS_CHAR;
533: x_seeded_format_type := FND_API.G_MISS_CHAR;
534: x_seeded_precedence := FND_API.G_MISS_NUM;
535: x_seeded_segment_name := FND_API.G_MISS_CHAR;

Line 532: x_seeded_flag := FND_API.G_MISS_CHAR;

528: x_attribute9 := FND_API.G_MISS_CHAR;
529: x_availability_in_basic := FND_API.G_MISS_CHAR;
530: x_context := FND_API.G_MISS_CHAR;
531: x_prc_context_id := FND_API.G_MISS_NUM;
532: x_seeded_flag := FND_API.G_MISS_CHAR;
533: x_seeded_format_type := FND_API.G_MISS_CHAR;
534: x_seeded_precedence := FND_API.G_MISS_NUM;
535: x_seeded_segment_name := FND_API.G_MISS_CHAR;
536: x_seeded_valueset_id := FND_API.G_MISS_NUM;

Line 533: x_seeded_format_type := FND_API.G_MISS_CHAR;

529: x_availability_in_basic := FND_API.G_MISS_CHAR;
530: x_context := FND_API.G_MISS_CHAR;
531: x_prc_context_id := FND_API.G_MISS_NUM;
532: x_seeded_flag := FND_API.G_MISS_CHAR;
533: x_seeded_format_type := FND_API.G_MISS_CHAR;
534: x_seeded_precedence := FND_API.G_MISS_NUM;
535: x_seeded_segment_name := FND_API.G_MISS_CHAR;
536: x_seeded_valueset_id := FND_API.G_MISS_NUM;
537: x_segment_code := FND_API.G_MISS_CHAR;

Line 534: x_seeded_precedence := FND_API.G_MISS_NUM;

530: x_context := FND_API.G_MISS_CHAR;
531: x_prc_context_id := FND_API.G_MISS_NUM;
532: x_seeded_flag := FND_API.G_MISS_CHAR;
533: x_seeded_format_type := FND_API.G_MISS_CHAR;
534: x_seeded_precedence := FND_API.G_MISS_NUM;
535: x_seeded_segment_name := FND_API.G_MISS_CHAR;
536: x_seeded_valueset_id := FND_API.G_MISS_NUM;
537: x_segment_code := FND_API.G_MISS_CHAR;
538: x_segment_id := FND_API.G_MISS_NUM;

Line 535: x_seeded_segment_name := FND_API.G_MISS_CHAR;

531: x_prc_context_id := FND_API.G_MISS_NUM;
532: x_seeded_flag := FND_API.G_MISS_CHAR;
533: x_seeded_format_type := FND_API.G_MISS_CHAR;
534: x_seeded_precedence := FND_API.G_MISS_NUM;
535: x_seeded_segment_name := FND_API.G_MISS_CHAR;
536: x_seeded_valueset_id := FND_API.G_MISS_NUM;
537: x_segment_code := FND_API.G_MISS_CHAR;
538: x_segment_id := FND_API.G_MISS_NUM;
539: x_application_id := FND_API.G_MISS_NUM;

Line 536: x_seeded_valueset_id := FND_API.G_MISS_NUM;

532: x_seeded_flag := FND_API.G_MISS_CHAR;
533: x_seeded_format_type := FND_API.G_MISS_CHAR;
534: x_seeded_precedence := FND_API.G_MISS_NUM;
535: x_seeded_segment_name := FND_API.G_MISS_CHAR;
536: x_seeded_valueset_id := FND_API.G_MISS_NUM;
537: x_segment_code := FND_API.G_MISS_CHAR;
538: x_segment_id := FND_API.G_MISS_NUM;
539: x_application_id := FND_API.G_MISS_NUM;
540: x_segment_mapping_column := FND_API.G_MISS_CHAR;

Line 537: x_segment_code := FND_API.G_MISS_CHAR;

533: x_seeded_format_type := FND_API.G_MISS_CHAR;
534: x_seeded_precedence := FND_API.G_MISS_NUM;
535: x_seeded_segment_name := FND_API.G_MISS_CHAR;
536: x_seeded_valueset_id := FND_API.G_MISS_NUM;
537: x_segment_code := FND_API.G_MISS_CHAR;
538: x_segment_id := FND_API.G_MISS_NUM;
539: x_application_id := FND_API.G_MISS_NUM;
540: x_segment_mapping_column := FND_API.G_MISS_CHAR;
541: x_user_format_type := FND_API.G_MISS_CHAR;

Line 538: x_segment_id := FND_API.G_MISS_NUM;

534: x_seeded_precedence := FND_API.G_MISS_NUM;
535: x_seeded_segment_name := FND_API.G_MISS_CHAR;
536: x_seeded_valueset_id := FND_API.G_MISS_NUM;
537: x_segment_code := FND_API.G_MISS_CHAR;
538: x_segment_id := FND_API.G_MISS_NUM;
539: x_application_id := FND_API.G_MISS_NUM;
540: x_segment_mapping_column := FND_API.G_MISS_CHAR;
541: x_user_format_type := FND_API.G_MISS_CHAR;
542: x_user_precedence := FND_API.G_MISS_NUM;

Line 539: x_application_id := FND_API.G_MISS_NUM;

535: x_seeded_segment_name := FND_API.G_MISS_CHAR;
536: x_seeded_valueset_id := FND_API.G_MISS_NUM;
537: x_segment_code := FND_API.G_MISS_CHAR;
538: x_segment_id := FND_API.G_MISS_NUM;
539: x_application_id := FND_API.G_MISS_NUM;
540: x_segment_mapping_column := FND_API.G_MISS_CHAR;
541: x_user_format_type := FND_API.G_MISS_CHAR;
542: x_user_precedence := FND_API.G_MISS_NUM;
543: x_user_segment_name := FND_API.G_MISS_CHAR;

Line 540: x_segment_mapping_column := FND_API.G_MISS_CHAR;

536: x_seeded_valueset_id := FND_API.G_MISS_NUM;
537: x_segment_code := FND_API.G_MISS_CHAR;
538: x_segment_id := FND_API.G_MISS_NUM;
539: x_application_id := FND_API.G_MISS_NUM;
540: x_segment_mapping_column := FND_API.G_MISS_CHAR;
541: x_user_format_type := FND_API.G_MISS_CHAR;
542: x_user_precedence := FND_API.G_MISS_NUM;
543: x_user_segment_name := FND_API.G_MISS_CHAR;
544: x_user_valueset_id := FND_API.G_MISS_NUM;

Line 541: x_user_format_type := FND_API.G_MISS_CHAR;

537: x_segment_code := FND_API.G_MISS_CHAR;
538: x_segment_id := FND_API.G_MISS_NUM;
539: x_application_id := FND_API.G_MISS_NUM;
540: x_segment_mapping_column := FND_API.G_MISS_CHAR;
541: x_user_format_type := FND_API.G_MISS_CHAR;
542: x_user_precedence := FND_API.G_MISS_NUM;
543: x_user_segment_name := FND_API.G_MISS_CHAR;
544: x_user_valueset_id := FND_API.G_MISS_NUM;
545: x_prc_context := FND_API.G_MISS_CHAR;

Line 542: x_user_precedence := FND_API.G_MISS_NUM;

538: x_segment_id := FND_API.G_MISS_NUM;
539: x_application_id := FND_API.G_MISS_NUM;
540: x_segment_mapping_column := FND_API.G_MISS_CHAR;
541: x_user_format_type := FND_API.G_MISS_CHAR;
542: x_user_precedence := FND_API.G_MISS_NUM;
543: x_user_segment_name := FND_API.G_MISS_CHAR;
544: x_user_valueset_id := FND_API.G_MISS_NUM;
545: x_prc_context := FND_API.G_MISS_CHAR;
546: x_seeded := FND_API.G_MISS_CHAR;

Line 543: x_user_segment_name := FND_API.G_MISS_CHAR;

539: x_application_id := FND_API.G_MISS_NUM;
540: x_segment_mapping_column := FND_API.G_MISS_CHAR;
541: x_user_format_type := FND_API.G_MISS_CHAR;
542: x_user_precedence := FND_API.G_MISS_NUM;
543: x_user_segment_name := FND_API.G_MISS_CHAR;
544: x_user_valueset_id := FND_API.G_MISS_NUM;
545: x_prc_context := FND_API.G_MISS_CHAR;
546: x_seeded := FND_API.G_MISS_CHAR;
547: x_seeded_valueset := FND_API.G_MISS_CHAR;

Line 544: x_user_valueset_id := FND_API.G_MISS_NUM;

540: x_segment_mapping_column := FND_API.G_MISS_CHAR;
541: x_user_format_type := FND_API.G_MISS_CHAR;
542: x_user_precedence := FND_API.G_MISS_NUM;
543: x_user_segment_name := FND_API.G_MISS_CHAR;
544: x_user_valueset_id := FND_API.G_MISS_NUM;
545: x_prc_context := FND_API.G_MISS_CHAR;
546: x_seeded := FND_API.G_MISS_CHAR;
547: x_seeded_valueset := FND_API.G_MISS_CHAR;
548: x_segment := FND_API.G_MISS_CHAR;

Line 545: x_prc_context := FND_API.G_MISS_CHAR;

541: x_user_format_type := FND_API.G_MISS_CHAR;
542: x_user_precedence := FND_API.G_MISS_NUM;
543: x_user_segment_name := FND_API.G_MISS_CHAR;
544: x_user_valueset_id := FND_API.G_MISS_NUM;
545: x_prc_context := FND_API.G_MISS_CHAR;
546: x_seeded := FND_API.G_MISS_CHAR;
547: x_seeded_valueset := FND_API.G_MISS_CHAR;
548: x_segment := FND_API.G_MISS_CHAR;
549: x_user_valueset := FND_API.G_MISS_CHAR;

Line 546: x_seeded := FND_API.G_MISS_CHAR;

542: x_user_precedence := FND_API.G_MISS_NUM;
543: x_user_segment_name := FND_API.G_MISS_CHAR;
544: x_user_valueset_id := FND_API.G_MISS_NUM;
545: x_prc_context := FND_API.G_MISS_CHAR;
546: x_seeded := FND_API.G_MISS_CHAR;
547: x_seeded_valueset := FND_API.G_MISS_CHAR;
548: x_segment := FND_API.G_MISS_CHAR;
549: x_user_valueset := FND_API.G_MISS_CHAR;
550: x_seeded_description := FND_API.G_MISS_CHAR;

Line 547: x_seeded_valueset := FND_API.G_MISS_CHAR;

543: x_user_segment_name := FND_API.G_MISS_CHAR;
544: x_user_valueset_id := FND_API.G_MISS_NUM;
545: x_prc_context := FND_API.G_MISS_CHAR;
546: x_seeded := FND_API.G_MISS_CHAR;
547: x_seeded_valueset := FND_API.G_MISS_CHAR;
548: x_segment := FND_API.G_MISS_CHAR;
549: x_user_valueset := FND_API.G_MISS_CHAR;
550: x_seeded_description := FND_API.G_MISS_CHAR;
551: x_user_description := FND_API.G_MISS_CHAR;

Line 548: x_segment := FND_API.G_MISS_CHAR;

544: x_user_valueset_id := FND_API.G_MISS_NUM;
545: x_prc_context := FND_API.G_MISS_CHAR;
546: x_seeded := FND_API.G_MISS_CHAR;
547: x_seeded_valueset := FND_API.G_MISS_CHAR;
548: x_segment := FND_API.G_MISS_CHAR;
549: x_user_valueset := FND_API.G_MISS_CHAR;
550: x_seeded_description := FND_API.G_MISS_CHAR;
551: x_user_description := FND_API.G_MISS_CHAR;
552: x_required_flag := FND_API.G_MISS_CHAR;

Line 549: x_user_valueset := FND_API.G_MISS_CHAR;

545: x_prc_context := FND_API.G_MISS_CHAR;
546: x_seeded := FND_API.G_MISS_CHAR;
547: x_seeded_valueset := FND_API.G_MISS_CHAR;
548: x_segment := FND_API.G_MISS_CHAR;
549: x_user_valueset := FND_API.G_MISS_CHAR;
550: x_seeded_description := FND_API.G_MISS_CHAR;
551: x_user_description := FND_API.G_MISS_CHAR;
552: x_required_flag := FND_API.G_MISS_CHAR;
553: x_party_hierarchy_enabled_flag := FND_API.G_MISS_CHAR; -- Added for TCA

Line 550: x_seeded_description := FND_API.G_MISS_CHAR;

546: x_seeded := FND_API.G_MISS_CHAR;
547: x_seeded_valueset := FND_API.G_MISS_CHAR;
548: x_segment := FND_API.G_MISS_CHAR;
549: x_user_valueset := FND_API.G_MISS_CHAR;
550: x_seeded_description := FND_API.G_MISS_CHAR;
551: x_user_description := FND_API.G_MISS_CHAR;
552: x_required_flag := FND_API.G_MISS_CHAR;
553: x_party_hierarchy_enabled_flag := FND_API.G_MISS_CHAR; -- Added for TCA
554:

Line 551: x_user_description := FND_API.G_MISS_CHAR;

547: x_seeded_valueset := FND_API.G_MISS_CHAR;
548: x_segment := FND_API.G_MISS_CHAR;
549: x_user_valueset := FND_API.G_MISS_CHAR;
550: x_seeded_description := FND_API.G_MISS_CHAR;
551: x_user_description := FND_API.G_MISS_CHAR;
552: x_required_flag := FND_API.G_MISS_CHAR;
553: x_party_hierarchy_enabled_flag := FND_API.G_MISS_CHAR; -- Added for TCA
554:
555: -- Load display out parameters if any

Line 552: x_required_flag := FND_API.G_MISS_CHAR;

548: x_segment := FND_API.G_MISS_CHAR;
549: x_user_valueset := FND_API.G_MISS_CHAR;
550: x_seeded_description := FND_API.G_MISS_CHAR;
551: x_user_description := FND_API.G_MISS_CHAR;
552: x_required_flag := FND_API.G_MISS_CHAR;
553: x_party_hierarchy_enabled_flag := FND_API.G_MISS_CHAR; -- Added for TCA
554:
555: -- Load display out parameters if any
556:

Line 553: x_party_hierarchy_enabled_flag := FND_API.G_MISS_CHAR; -- Added for TCA

549: x_user_valueset := FND_API.G_MISS_CHAR;
550: x_seeded_description := FND_API.G_MISS_CHAR;
551: x_user_description := FND_API.G_MISS_CHAR;
552: x_required_flag := FND_API.G_MISS_CHAR;
553: x_party_hierarchy_enabled_flag := FND_API.G_MISS_CHAR; -- Added for TCA
554:
555: -- Load display out parameters if any
556:
557: l_SEG_val_rec := QP_Seg_Util.Get_Values

Line 788: x_return_status := FND_API.G_RET_STS_SUCCESS;

784: );
785:
786: -- Set return status.
787:
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789:
790: -- Get message count and data
791:
792: OE_MSG_PUB.Count_And_Get

Line 800: WHEN FND_API.G_EXC_ERROR THEN

796:
797:
798: EXCEPTION
799:
800: WHEN FND_API.G_EXC_ERROR THEN
801:
802: x_return_status := FND_API.G_RET_STS_ERROR;
803:
804: -- Get message count and data

Line 802: x_return_status := FND_API.G_RET_STS_ERROR;

798: EXCEPTION
799:
800: WHEN FND_API.G_EXC_ERROR THEN
801:
802: x_return_status := FND_API.G_RET_STS_ERROR;
803:
804: -- Get message count and data
805:
806: OE_MSG_PUB.Count_And_Get

Line 811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

807: ( p_count => x_msg_count
808: , p_data => x_msg_data
809: );
810:
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812:
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
814:
815: -- Get message count and data

Line 813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

809: );
810:
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812:
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
814:
815: -- Get message count and data
816:
817: OE_MSG_PUB.Count_And_Get

Line 824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

820: );
821:
822: WHEN OTHERS THEN
823:
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
825:
826: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
827: THEN
828: OE_MSG_PUB.Add_Exc_Msg

Line 889: if g_db_seg_rec.segment_id = FND_API.G_MISS_NUM then

885:
886: -- Read SEG from cache
887:
888:
889: if g_db_seg_rec.segment_id = FND_API.G_MISS_NUM then
890: dummy_seg_id := 'G_MISS_NUM';
891: else
892: dummy_seg_id := g_db_seg_rec.segment_id;
893: end if;

Line 895: if g_db_seg_rec.application_id = FND_API.G_MISS_NUM then

891: else
892: dummy_seg_id := g_db_seg_rec.segment_id;
893: end if;
894:
895: if g_db_seg_rec.application_id = FND_API.G_MISS_NUM then
896: dummy_app_id := 'G_MISS_NUM';
897: else
898: dummy_app_id := g_db_seg_rec.application_id;
899: end if;

Line 906: if g_db_seg_rec.segment_id = FND_API.G_MISS_NUM then

902: ( p_db_record => TRUE
903: , p_segment_id => p_segment_id
904: );
905:
906: if g_db_seg_rec.segment_id = FND_API.G_MISS_NUM then
907: dummy_seg_id := 'G_MISS_NUM';
908: else
909: dummy_seg_id := g_db_seg_rec.segment_id;
910: end if;

Line 912: if g_db_seg_rec.application_id = FND_API.G_MISS_NUM then

908: else
909: dummy_seg_id := g_db_seg_rec.segment_id;
910: end if;
911:
912: if g_db_seg_rec.application_id = FND_API.G_MISS_NUM then
913: dummy_app_id := 'G_MISS_NUM';
914: else
915: dummy_app_id := g_db_seg_rec.application_id;
916: end if;

Line 925: IF FND_API.To_Boolean(l_SEG_rec.db_flag) THEN

921: );
922:
923: -- Set Operation.
924:
925: IF FND_API.To_Boolean(l_SEG_rec.db_flag) THEN
926: l_SEG_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
927: ELSE
928: l_SEG_rec.operation := QP_GLOBALS.G_OPR_CREATE;
929: END IF;

Line 940: , p_init_msg_list => FND_API.G_TRUE

936: -- Call QP_Attributes_PVT.Process_Attributes
937:
938: QP_Attributes_PVT.Process_Attributes
939: ( p_api_version_number => 1.0
940: , p_init_msg_list => FND_API.G_TRUE
941: , x_return_status => l_return_status
942: , x_msg_count => x_msg_count
943: , x_msg_data => x_msg_data
944: , p_control_rec => l_control_rec

Line 951: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

947: , x_CON_rec => l_x_CON_rec
948: , x_SEG_tbl => l_x_SEG_tbl
949: );
950:
951: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
954: RAISE FND_API.G_EXC_ERROR;
955: END IF;

Line 952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

948: , x_SEG_tbl => l_x_SEG_tbl
949: );
950:
951: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
954: RAISE FND_API.G_EXC_ERROR;
955: END IF;
956:

Line 953: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

949: );
950:
951: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
954: RAISE FND_API.G_EXC_ERROR;
955: END IF;
956:
957:

Line 954: RAISE FND_API.G_EXC_ERROR;

950:
951: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
954: RAISE FND_API.G_EXC_ERROR;
955: END IF;
956:
957:
958: -- Load OUT parameters.

Line 979: x_return_status := FND_API.G_RET_STS_SUCCESS;

975:
976:
977: -- Set return status.
978:
979: x_return_status := FND_API.G_RET_STS_SUCCESS;
980:
981: -- Get message count and data
982:
983: OE_MSG_PUB.Count_And_Get

Line 991: WHEN FND_API.G_EXC_ERROR THEN

987:
988:
989: EXCEPTION
990:
991: WHEN FND_API.G_EXC_ERROR THEN
992:
993: x_return_status := FND_API.G_RET_STS_ERROR;
994:
995: -- Get message count and data

Line 993: x_return_status := FND_API.G_RET_STS_ERROR;

989: EXCEPTION
990:
991: WHEN FND_API.G_EXC_ERROR THEN
992:
993: x_return_status := FND_API.G_RET_STS_ERROR;
994:
995: -- Get message count and data
996:
997: OE_MSG_PUB.Count_And_Get

Line 1002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

998: ( p_count => x_msg_count
999: , p_data => x_msg_data
1000: );
1001:
1002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1005:
1006: -- Get message count and data

Line 1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1000: );
1001:
1002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1005:
1006: -- Get message count and data
1007:
1008: OE_MSG_PUB.Count_And_Get

Line 1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1011: );
1012:
1013: WHEN OTHERS THEN
1014:
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1016:
1017: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1018: THEN
1019: OE_MSG_PUB.Add_Exc_Msg

Line 1087: , p_init_msg_list => FND_API.G_TRUE

1083: -- Call QP_Attributes_PVT.Process_Attributes
1084:
1085: QP_Attributes_PVT.Process_Attributes
1086: ( p_api_version_number => 1.0
1087: , p_init_msg_list => FND_API.G_TRUE
1088: , x_return_status => l_return_status
1089: , x_msg_count => x_msg_count
1090: , x_msg_data => x_msg_data
1091: , p_control_rec => l_control_rec

Line 1097: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1093: , x_CON_rec => l_x_CON_rec
1094: , x_SEG_tbl => l_x_SEG_tbl
1095: );
1096:
1097: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1100: RAISE FND_API.G_EXC_ERROR;
1101: END IF;

Line 1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1094: , x_SEG_tbl => l_x_SEG_tbl
1095: );
1096:
1097: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1100: RAISE FND_API.G_EXC_ERROR;
1101: END IF;
1102:

Line 1099: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1095: );
1096:
1097: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1100: RAISE FND_API.G_EXC_ERROR;
1101: END IF;
1102:
1103:

Line 1100: RAISE FND_API.G_EXC_ERROR;

1096:
1097: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1100: RAISE FND_API.G_EXC_ERROR;
1101: END IF;
1102:
1103:
1104: -- Clear SEG record cache

Line 1110: x_return_status := FND_API.G_RET_STS_SUCCESS;

1106: Clear_SEG;
1107:
1108: -- Set return status.
1109:
1110: x_return_status := FND_API.G_RET_STS_SUCCESS;
1111:
1112: -- Get message count and data
1113:
1114: OE_MSG_PUB.Count_And_Get

Line 1122: WHEN FND_API.G_EXC_ERROR THEN

1118:
1119:
1120: EXCEPTION
1121:
1122: WHEN FND_API.G_EXC_ERROR THEN
1123:
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125:
1126: -- Get message count and data

Line 1124: x_return_status := FND_API.G_RET_STS_ERROR;

1120: EXCEPTION
1121:
1122: WHEN FND_API.G_EXC_ERROR THEN
1123:
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125:
1126: -- Get message count and data
1127:
1128: OE_MSG_PUB.Count_And_Get

Line 1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1129: ( p_count => x_msg_count
1130: , p_data => x_msg_data
1131: );
1132:
1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1134:
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1136:
1137: -- Get message count and data

Line 1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1131: );
1132:
1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1134:
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1136:
1137: -- Get message count and data
1138:
1139: OE_MSG_PUB.Count_And_Get

Line 1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1142: );
1143:
1144: WHEN OTHERS THEN
1145:
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147:
1148: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1149: THEN
1150: OE_MSG_PUB.Add_Exc_Msg

Line 1201: , p_init_msg_list => FND_API.G_TRUE

1197: -- Call QP_Attributes_PVT.Process_Attributes
1198:
1199: QP_Attributes_PVT.Process_Attributes
1200: ( p_api_version_number => 1.0
1201: , p_init_msg_list => FND_API.G_TRUE
1202: , x_return_status => l_return_status
1203: , x_msg_count => x_msg_count
1204: , x_msg_data => x_msg_data
1205: , p_control_rec => l_control_rec

Line 1210: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1206: , x_CON_rec => l_x_CON_rec
1207: , x_SEG_tbl => l_x_SEG_tbl
1208: );
1209:
1210: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1212: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;

Line 1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1207: , x_SEG_tbl => l_x_SEG_tbl
1208: );
1209:
1210: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1212: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;
1215:

Line 1212: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1208: );
1209:
1210: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1212: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;
1215:
1216:

Line 1213: RAISE FND_API.G_EXC_ERROR;

1209:
1210: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1212: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;
1215:
1216:
1217: -- Set return status.

Line 1219: x_return_status := FND_API.G_RET_STS_SUCCESS;

1215:
1216:
1217: -- Set return status.
1218:
1219: x_return_status := FND_API.G_RET_STS_SUCCESS;
1220:
1221: -- Get message count and data
1222:
1223: OE_MSG_PUB.Count_And_Get

Line 1231: WHEN FND_API.G_EXC_ERROR THEN

1227:
1228:
1229: EXCEPTION
1230:
1231: WHEN FND_API.G_EXC_ERROR THEN
1232:
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234:
1235: -- Get message count and data

Line 1233: x_return_status := FND_API.G_RET_STS_ERROR;

1229: EXCEPTION
1230:
1231: WHEN FND_API.G_EXC_ERROR THEN
1232:
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234:
1235: -- Get message count and data
1236:
1237: OE_MSG_PUB.Count_And_Get

Line 1242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1238: ( p_count => x_msg_count
1239: , p_data => x_msg_data
1240: );
1241:
1242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1243:
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1245:
1246: -- Get message count and data

Line 1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1240: );
1241:
1242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1243:
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1245:
1246: -- Get message count and data
1247:
1248: OE_MSG_PUB.Count_And_Get

Line 1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1251: );
1252:
1253: WHEN OTHERS THEN
1254:
1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1256:
1257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1258: THEN
1259: OE_MSG_PUB.Add_Exc_Msg

Line 1387: , p_init_msg_list => FND_API.G_TRUE

1383: -- Call QP_Attributes_PVT.Lock_Attributes
1384:
1385: QP_Attributes_PVT.Lock_Attributes
1386: ( p_api_version_number => 1.0
1387: , p_init_msg_list => FND_API.G_TRUE
1388: , x_return_status => l_return_status
1389: , x_msg_count => x_msg_count
1390: , x_msg_data => x_msg_data
1391: , p_SEG_tbl => l_SEG_tbl

Line 1396: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1392: , x_CON_rec => l_x_CON_rec
1393: , x_SEG_tbl => l_x_SEG_tbl
1394: );
1395:
1396: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1397:
1398: -- Set DB flag and write record to cache.
1399:
1400: l_x_SEG_rec.db_flag := FND_API.G_TRUE;

Line 1400: l_x_SEG_rec.db_flag := FND_API.G_TRUE;

1396: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1397:
1398: -- Set DB flag and write record to cache.
1399:
1400: l_x_SEG_rec.db_flag := FND_API.G_TRUE;
1401:
1402: Write_SEG
1403: ( p_SEG_rec => l_x_SEG_rec
1404: , p_db_record => TRUE

Line 1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1429: , 'Lock_Row'
1430: );
1431: END IF;
1432:
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434:
1435: -- Get message count and data
1436:
1437: OE_MSG_PUB.Count_And_Get

Line 1482: g_SEG_rec.db_flag := FND_API.G_TRUE;

1478: g_SEG_rec := QP_Seg_Util.Query_Row
1479: ( p_segment_id => p_segment_id
1480: );
1481:
1482: g_SEG_rec.db_flag := FND_API.G_TRUE;
1483:
1484: -- Load DB record
1485:
1486: g_db_SEG_rec := g_SEG_rec;