120: -- Call QP_Attributes_PVT.Process_Attributes
121:
122: QP_Attributes_PVT.Process_Attributes
123: ( p_api_version_number => 1.0
124: , p_init_msg_list => FND_API.G_TRUE
125: , x_return_status => l_return_status
126: , x_msg_count => x_msg_count
127: , x_msg_data => x_msg_data
128: , p_control_rec => l_control_rec
130: , x_CON_rec => l_x_CON_rec
131: , x_SEG_tbl => l_x_SEG_tbl
132: );
133:
134: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;
131: , x_SEG_tbl => l_x_SEG_tbl
132: );
133:
134: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;
139:
132: );
133:
134: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;
139:
140:
133:
134: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;
139:
140:
141: -- Load OUT parameters.
177:
178: -- Write to cache.
179: -- Set db_flag to False before writing to cache
180:
181: l_x_CON_rec.db_flag := FND_API.G_FALSE;
182:
183: Write_CON
184: ( p_CON_rec => l_x_CON_rec
185: );
185: );
186:
187: -- Set return status.
188:
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190:
191: -- Get message count and data
192:
193: OE_MSG_PUB.Count_And_Get
197:
198:
199: EXCEPTION
200:
201: WHEN FND_API.G_EXC_ERROR THEN
202:
203: x_return_status := FND_API.G_RET_STS_ERROR;
204:
205: -- Get message count and data
199: EXCEPTION
200:
201: WHEN FND_API.G_EXC_ERROR THEN
202:
203: x_return_status := FND_API.G_RET_STS_ERROR;
204:
205: -- Get message count and data
206:
207: OE_MSG_PUB.Count_And_Get
208: ( p_count => x_msg_count
209: , p_data => x_msg_data
210: );
211:
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213:
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215:
216: -- Get message count and data
210: );
211:
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213:
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215:
216: -- Get message count and data
217:
218: OE_MSG_PUB.Count_And_Get
221: );
222:
223: WHEN OTHERS THEN
224:
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
226:
227: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
228: THEN
229: OE_MSG_PUB.Add_Exc_Msg
396: , 'Unrecognized attribute'
397: );
398: END IF;
399:
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401:
402: END IF;
403:
404: -- Set Operation.
402: END IF;
403:
404: -- Set Operation.
405:
406: IF FND_API.To_Boolean(l_CON_rec.db_flag) THEN
407: l_CON_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
408: ELSE
409: l_CON_rec.operation := QP_GLOBALS.G_OPR_CREATE;
410: END IF;
412: -- Call QP_Attributes_PVT.Process_Attributes
413:
414: QP_Attributes_PVT.Process_Attributes
415: ( p_api_version_number => 1.0
416: , p_init_msg_list => FND_API.G_TRUE
417: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
418: , x_return_status => l_return_status
419: , x_msg_count => x_msg_count
420: , x_msg_data => x_msg_data
413:
414: QP_Attributes_PVT.Process_Attributes
415: ( p_api_version_number => 1.0
416: , p_init_msg_list => FND_API.G_TRUE
417: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
418: , x_return_status => l_return_status
419: , x_msg_count => x_msg_count
420: , x_msg_data => x_msg_data
421: , p_control_rec => l_control_rec
424: , x_CON_rec => l_x_CON_rec
425: , x_SEG_tbl => l_x_SEG_tbl
426: );
427:
428: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
425: , x_SEG_tbl => l_x_SEG_tbl
426: );
427:
428: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433:
426: );
427:
428: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433:
434:
427:
428: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433:
434:
435: -- Init OUT parameters to missing.
433:
434:
435: -- Init OUT parameters to missing.
436:
437: x_attribute1 := FND_API.G_MISS_CHAR;
438: x_attribute10 := FND_API.G_MISS_CHAR;
439: x_attribute11 := FND_API.G_MISS_CHAR;
440: x_attribute12 := FND_API.G_MISS_CHAR;
441: x_attribute13 := FND_API.G_MISS_CHAR;
434:
435: -- Init OUT parameters to missing.
436:
437: x_attribute1 := FND_API.G_MISS_CHAR;
438: x_attribute10 := FND_API.G_MISS_CHAR;
439: x_attribute11 := FND_API.G_MISS_CHAR;
440: x_attribute12 := FND_API.G_MISS_CHAR;
441: x_attribute13 := FND_API.G_MISS_CHAR;
442: x_attribute14 := FND_API.G_MISS_CHAR;
435: -- Init OUT parameters to missing.
436:
437: x_attribute1 := FND_API.G_MISS_CHAR;
438: x_attribute10 := FND_API.G_MISS_CHAR;
439: x_attribute11 := FND_API.G_MISS_CHAR;
440: x_attribute12 := FND_API.G_MISS_CHAR;
441: x_attribute13 := FND_API.G_MISS_CHAR;
442: x_attribute14 := FND_API.G_MISS_CHAR;
443: x_attribute15 := FND_API.G_MISS_CHAR;
436:
437: x_attribute1 := FND_API.G_MISS_CHAR;
438: x_attribute10 := FND_API.G_MISS_CHAR;
439: x_attribute11 := FND_API.G_MISS_CHAR;
440: x_attribute12 := FND_API.G_MISS_CHAR;
441: x_attribute13 := FND_API.G_MISS_CHAR;
442: x_attribute14 := FND_API.G_MISS_CHAR;
443: x_attribute15 := FND_API.G_MISS_CHAR;
444: x_attribute2 := FND_API.G_MISS_CHAR;
437: x_attribute1 := FND_API.G_MISS_CHAR;
438: x_attribute10 := FND_API.G_MISS_CHAR;
439: x_attribute11 := FND_API.G_MISS_CHAR;
440: x_attribute12 := FND_API.G_MISS_CHAR;
441: x_attribute13 := FND_API.G_MISS_CHAR;
442: x_attribute14 := FND_API.G_MISS_CHAR;
443: x_attribute15 := FND_API.G_MISS_CHAR;
444: x_attribute2 := FND_API.G_MISS_CHAR;
445: x_attribute3 := FND_API.G_MISS_CHAR;
438: x_attribute10 := FND_API.G_MISS_CHAR;
439: x_attribute11 := FND_API.G_MISS_CHAR;
440: x_attribute12 := FND_API.G_MISS_CHAR;
441: x_attribute13 := FND_API.G_MISS_CHAR;
442: x_attribute14 := FND_API.G_MISS_CHAR;
443: x_attribute15 := FND_API.G_MISS_CHAR;
444: x_attribute2 := FND_API.G_MISS_CHAR;
445: x_attribute3 := FND_API.G_MISS_CHAR;
446: x_attribute4 := FND_API.G_MISS_CHAR;
439: x_attribute11 := FND_API.G_MISS_CHAR;
440: x_attribute12 := FND_API.G_MISS_CHAR;
441: x_attribute13 := FND_API.G_MISS_CHAR;
442: x_attribute14 := FND_API.G_MISS_CHAR;
443: x_attribute15 := FND_API.G_MISS_CHAR;
444: x_attribute2 := FND_API.G_MISS_CHAR;
445: x_attribute3 := FND_API.G_MISS_CHAR;
446: x_attribute4 := FND_API.G_MISS_CHAR;
447: x_attribute5 := FND_API.G_MISS_CHAR;
440: x_attribute12 := FND_API.G_MISS_CHAR;
441: x_attribute13 := FND_API.G_MISS_CHAR;
442: x_attribute14 := FND_API.G_MISS_CHAR;
443: x_attribute15 := FND_API.G_MISS_CHAR;
444: x_attribute2 := FND_API.G_MISS_CHAR;
445: x_attribute3 := FND_API.G_MISS_CHAR;
446: x_attribute4 := FND_API.G_MISS_CHAR;
447: x_attribute5 := FND_API.G_MISS_CHAR;
448: x_attribute6 := FND_API.G_MISS_CHAR;
441: x_attribute13 := FND_API.G_MISS_CHAR;
442: x_attribute14 := FND_API.G_MISS_CHAR;
443: x_attribute15 := FND_API.G_MISS_CHAR;
444: x_attribute2 := FND_API.G_MISS_CHAR;
445: x_attribute3 := FND_API.G_MISS_CHAR;
446: x_attribute4 := FND_API.G_MISS_CHAR;
447: x_attribute5 := FND_API.G_MISS_CHAR;
448: x_attribute6 := FND_API.G_MISS_CHAR;
449: x_attribute7 := FND_API.G_MISS_CHAR;
442: x_attribute14 := FND_API.G_MISS_CHAR;
443: x_attribute15 := FND_API.G_MISS_CHAR;
444: x_attribute2 := FND_API.G_MISS_CHAR;
445: x_attribute3 := FND_API.G_MISS_CHAR;
446: x_attribute4 := FND_API.G_MISS_CHAR;
447: x_attribute5 := FND_API.G_MISS_CHAR;
448: x_attribute6 := FND_API.G_MISS_CHAR;
449: x_attribute7 := FND_API.G_MISS_CHAR;
450: x_attribute8 := FND_API.G_MISS_CHAR;
443: x_attribute15 := FND_API.G_MISS_CHAR;
444: x_attribute2 := FND_API.G_MISS_CHAR;
445: x_attribute3 := FND_API.G_MISS_CHAR;
446: x_attribute4 := FND_API.G_MISS_CHAR;
447: x_attribute5 := FND_API.G_MISS_CHAR;
448: x_attribute6 := FND_API.G_MISS_CHAR;
449: x_attribute7 := FND_API.G_MISS_CHAR;
450: x_attribute8 := FND_API.G_MISS_CHAR;
451: x_attribute9 := FND_API.G_MISS_CHAR;
444: x_attribute2 := FND_API.G_MISS_CHAR;
445: x_attribute3 := FND_API.G_MISS_CHAR;
446: x_attribute4 := FND_API.G_MISS_CHAR;
447: x_attribute5 := FND_API.G_MISS_CHAR;
448: x_attribute6 := FND_API.G_MISS_CHAR;
449: x_attribute7 := FND_API.G_MISS_CHAR;
450: x_attribute8 := FND_API.G_MISS_CHAR;
451: x_attribute9 := FND_API.G_MISS_CHAR;
452: x_context := FND_API.G_MISS_CHAR;
445: x_attribute3 := FND_API.G_MISS_CHAR;
446: x_attribute4 := FND_API.G_MISS_CHAR;
447: x_attribute5 := FND_API.G_MISS_CHAR;
448: x_attribute6 := FND_API.G_MISS_CHAR;
449: x_attribute7 := FND_API.G_MISS_CHAR;
450: x_attribute8 := FND_API.G_MISS_CHAR;
451: x_attribute9 := FND_API.G_MISS_CHAR;
452: x_context := FND_API.G_MISS_CHAR;
453: x_enabled_flag := FND_API.G_MISS_CHAR;
446: x_attribute4 := FND_API.G_MISS_CHAR;
447: x_attribute5 := FND_API.G_MISS_CHAR;
448: x_attribute6 := FND_API.G_MISS_CHAR;
449: x_attribute7 := FND_API.G_MISS_CHAR;
450: x_attribute8 := FND_API.G_MISS_CHAR;
451: x_attribute9 := FND_API.G_MISS_CHAR;
452: x_context := FND_API.G_MISS_CHAR;
453: x_enabled_flag := FND_API.G_MISS_CHAR;
454: x_prc_context_code := FND_API.G_MISS_CHAR;
447: x_attribute5 := FND_API.G_MISS_CHAR;
448: x_attribute6 := FND_API.G_MISS_CHAR;
449: x_attribute7 := FND_API.G_MISS_CHAR;
450: x_attribute8 := FND_API.G_MISS_CHAR;
451: x_attribute9 := FND_API.G_MISS_CHAR;
452: x_context := FND_API.G_MISS_CHAR;
453: x_enabled_flag := FND_API.G_MISS_CHAR;
454: x_prc_context_code := FND_API.G_MISS_CHAR;
455: x_prc_context_id := FND_API.G_MISS_NUM;
448: x_attribute6 := FND_API.G_MISS_CHAR;
449: x_attribute7 := FND_API.G_MISS_CHAR;
450: x_attribute8 := FND_API.G_MISS_CHAR;
451: x_attribute9 := FND_API.G_MISS_CHAR;
452: x_context := FND_API.G_MISS_CHAR;
453: x_enabled_flag := FND_API.G_MISS_CHAR;
454: x_prc_context_code := FND_API.G_MISS_CHAR;
455: x_prc_context_id := FND_API.G_MISS_NUM;
456: x_prc_context_type := FND_API.G_MISS_CHAR;
449: x_attribute7 := FND_API.G_MISS_CHAR;
450: x_attribute8 := FND_API.G_MISS_CHAR;
451: x_attribute9 := FND_API.G_MISS_CHAR;
452: x_context := FND_API.G_MISS_CHAR;
453: x_enabled_flag := FND_API.G_MISS_CHAR;
454: x_prc_context_code := FND_API.G_MISS_CHAR;
455: x_prc_context_id := FND_API.G_MISS_NUM;
456: x_prc_context_type := FND_API.G_MISS_CHAR;
457: x_seeded_description := FND_API.G_MISS_CHAR;
450: x_attribute8 := FND_API.G_MISS_CHAR;
451: x_attribute9 := FND_API.G_MISS_CHAR;
452: x_context := FND_API.G_MISS_CHAR;
453: x_enabled_flag := FND_API.G_MISS_CHAR;
454: x_prc_context_code := FND_API.G_MISS_CHAR;
455: x_prc_context_id := FND_API.G_MISS_NUM;
456: x_prc_context_type := FND_API.G_MISS_CHAR;
457: x_seeded_description := FND_API.G_MISS_CHAR;
458: x_seeded_flag := FND_API.G_MISS_CHAR;
451: x_attribute9 := FND_API.G_MISS_CHAR;
452: x_context := FND_API.G_MISS_CHAR;
453: x_enabled_flag := FND_API.G_MISS_CHAR;
454: x_prc_context_code := FND_API.G_MISS_CHAR;
455: x_prc_context_id := FND_API.G_MISS_NUM;
456: x_prc_context_type := FND_API.G_MISS_CHAR;
457: x_seeded_description := FND_API.G_MISS_CHAR;
458: x_seeded_flag := FND_API.G_MISS_CHAR;
459: x_seeded_prc_context_name := FND_API.G_MISS_CHAR;
452: x_context := FND_API.G_MISS_CHAR;
453: x_enabled_flag := FND_API.G_MISS_CHAR;
454: x_prc_context_code := FND_API.G_MISS_CHAR;
455: x_prc_context_id := FND_API.G_MISS_NUM;
456: x_prc_context_type := FND_API.G_MISS_CHAR;
457: x_seeded_description := FND_API.G_MISS_CHAR;
458: x_seeded_flag := FND_API.G_MISS_CHAR;
459: x_seeded_prc_context_name := FND_API.G_MISS_CHAR;
460: x_user_description := FND_API.G_MISS_CHAR;
453: x_enabled_flag := FND_API.G_MISS_CHAR;
454: x_prc_context_code := FND_API.G_MISS_CHAR;
455: x_prc_context_id := FND_API.G_MISS_NUM;
456: x_prc_context_type := FND_API.G_MISS_CHAR;
457: x_seeded_description := FND_API.G_MISS_CHAR;
458: x_seeded_flag := FND_API.G_MISS_CHAR;
459: x_seeded_prc_context_name := FND_API.G_MISS_CHAR;
460: x_user_description := FND_API.G_MISS_CHAR;
461: x_user_prc_context_name := FND_API.G_MISS_CHAR;
454: x_prc_context_code := FND_API.G_MISS_CHAR;
455: x_prc_context_id := FND_API.G_MISS_NUM;
456: x_prc_context_type := FND_API.G_MISS_CHAR;
457: x_seeded_description := FND_API.G_MISS_CHAR;
458: x_seeded_flag := FND_API.G_MISS_CHAR;
459: x_seeded_prc_context_name := FND_API.G_MISS_CHAR;
460: x_user_description := FND_API.G_MISS_CHAR;
461: x_user_prc_context_name := FND_API.G_MISS_CHAR;
462: x_enabled := FND_API.G_MISS_CHAR;
455: x_prc_context_id := FND_API.G_MISS_NUM;
456: x_prc_context_type := FND_API.G_MISS_CHAR;
457: x_seeded_description := FND_API.G_MISS_CHAR;
458: x_seeded_flag := FND_API.G_MISS_CHAR;
459: x_seeded_prc_context_name := FND_API.G_MISS_CHAR;
460: x_user_description := FND_API.G_MISS_CHAR;
461: x_user_prc_context_name := FND_API.G_MISS_CHAR;
462: x_enabled := FND_API.G_MISS_CHAR;
463: x_prc_context := FND_API.G_MISS_CHAR;
456: x_prc_context_type := FND_API.G_MISS_CHAR;
457: x_seeded_description := FND_API.G_MISS_CHAR;
458: x_seeded_flag := FND_API.G_MISS_CHAR;
459: x_seeded_prc_context_name := FND_API.G_MISS_CHAR;
460: x_user_description := FND_API.G_MISS_CHAR;
461: x_user_prc_context_name := FND_API.G_MISS_CHAR;
462: x_enabled := FND_API.G_MISS_CHAR;
463: x_prc_context := FND_API.G_MISS_CHAR;
464: x_seeded := FND_API.G_MISS_CHAR;
457: x_seeded_description := FND_API.G_MISS_CHAR;
458: x_seeded_flag := FND_API.G_MISS_CHAR;
459: x_seeded_prc_context_name := FND_API.G_MISS_CHAR;
460: x_user_description := FND_API.G_MISS_CHAR;
461: x_user_prc_context_name := FND_API.G_MISS_CHAR;
462: x_enabled := FND_API.G_MISS_CHAR;
463: x_prc_context := FND_API.G_MISS_CHAR;
464: x_seeded := FND_API.G_MISS_CHAR;
465:
458: x_seeded_flag := FND_API.G_MISS_CHAR;
459: x_seeded_prc_context_name := FND_API.G_MISS_CHAR;
460: x_user_description := FND_API.G_MISS_CHAR;
461: x_user_prc_context_name := FND_API.G_MISS_CHAR;
462: x_enabled := FND_API.G_MISS_CHAR;
463: x_prc_context := FND_API.G_MISS_CHAR;
464: x_seeded := FND_API.G_MISS_CHAR;
465:
466: -- Load display out parameters if any
459: x_seeded_prc_context_name := FND_API.G_MISS_CHAR;
460: x_user_description := FND_API.G_MISS_CHAR;
461: x_user_prc_context_name := FND_API.G_MISS_CHAR;
462: x_enabled := FND_API.G_MISS_CHAR;
463: x_prc_context := FND_API.G_MISS_CHAR;
464: x_seeded := FND_API.G_MISS_CHAR;
465:
466: -- Load display out parameters if any
467:
460: x_user_description := FND_API.G_MISS_CHAR;
461: x_user_prc_context_name := FND_API.G_MISS_CHAR;
462: x_enabled := FND_API.G_MISS_CHAR;
463: x_prc_context := FND_API.G_MISS_CHAR;
464: x_seeded := FND_API.G_MISS_CHAR;
465:
466: -- Load display out parameters if any
467:
468: l_CON_val_rec := QP_Con_Util.Get_Values
633: );
634:
635: -- Set return status.
636:
637: x_return_status := FND_API.G_RET_STS_SUCCESS;
638:
639: -- Get message count and data
640:
641: OE_MSG_PUB.Count_And_Get
645:
646:
647: EXCEPTION
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650:
651: x_return_status := FND_API.G_RET_STS_ERROR;
652:
653: -- Get message count and data
647: EXCEPTION
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650:
651: x_return_status := FND_API.G_RET_STS_ERROR;
652:
653: -- Get message count and data
654:
655: OE_MSG_PUB.Count_And_Get
656: ( p_count => x_msg_count
657: , p_data => x_msg_data
658: );
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661:
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
663:
664: -- Get message count and data
658: );
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661:
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
663:
664: -- Get message count and data
665:
666: OE_MSG_PUB.Count_And_Get
669: );
670:
671: WHEN OTHERS THEN
672:
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
674:
675: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
676: THEN
677: OE_MSG_PUB.Add_Exc_Msg
741: );
742:
743: -- Set Operation.
744:
745: IF FND_API.To_Boolean(l_CON_rec.db_flag) THEN
746: l_CON_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
747: ELSE
748: l_CON_rec.operation := QP_GLOBALS.G_OPR_CREATE;
749: END IF;
751: -- Call QP_Attributes_PVT.Process_Attributes
752:
753: QP_Attributes_PVT.Process_Attributes
754: ( p_api_version_number => 1.0
755: , p_init_msg_list => FND_API.G_TRUE
756: , x_return_status => l_return_status
757: , x_msg_count => x_msg_count
758: , x_msg_data => x_msg_data
759: , p_control_rec => l_control_rec
762: , x_CON_rec => l_x_CON_rec
763: , x_SEG_tbl => l_x_SEG_tbl
764: );
765:
766: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
763: , x_SEG_tbl => l_x_SEG_tbl
764: );
765:
766: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771:
764: );
765:
766: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771:
772:
765:
766: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771:
772:
773: -- Load OUT parameters.
789:
790:
791: -- Set return status.
792:
793: x_return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: -- Get message count and data
796:
797: OE_MSG_PUB.Count_And_Get
801:
802:
803: EXCEPTION
804:
805: WHEN FND_API.G_EXC_ERROR THEN
806:
807: x_return_status := FND_API.G_RET_STS_ERROR;
808:
809: -- Get message count and data
803: EXCEPTION
804:
805: WHEN FND_API.G_EXC_ERROR THEN
806:
807: x_return_status := FND_API.G_RET_STS_ERROR;
808:
809: -- Get message count and data
810:
811: OE_MSG_PUB.Count_And_Get
812: ( p_count => x_msg_count
813: , p_data => x_msg_data
814: );
815:
816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
817:
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
819:
820: -- Get message count and data
814: );
815:
816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
817:
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
819:
820: -- Get message count and data
821:
822: OE_MSG_PUB.Count_And_Get
825: );
826:
827: WHEN OTHERS THEN
828:
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
830:
831: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
832: THEN
833: OE_MSG_PUB.Add_Exc_Msg
892: -- Call QP_Attributes_PVT.Process_Attributes
893:
894: QP_Attributes_PVT.Process_Attributes
895: ( p_api_version_number => 1.0
896: , p_init_msg_list => FND_API.G_TRUE
897: , x_return_status => l_return_status
898: , x_msg_count => x_msg_count
899: , x_msg_data => x_msg_data
900: , p_control_rec => l_control_rec
902: , x_CON_rec => l_x_CON_rec
903: , x_SEG_tbl => l_x_SEG_tbl
904: );
905:
906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
909: RAISE FND_API.G_EXC_ERROR;
910: END IF;
903: , x_SEG_tbl => l_x_SEG_tbl
904: );
905:
906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
909: RAISE FND_API.G_EXC_ERROR;
910: END IF;
911:
904: );
905:
906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
909: RAISE FND_API.G_EXC_ERROR;
910: END IF;
911:
912:
905:
906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
909: RAISE FND_API.G_EXC_ERROR;
910: END IF;
911:
912:
913: -- Clear CON record cache
915: Clear_CON;
916:
917: -- Set return status.
918:
919: x_return_status := FND_API.G_RET_STS_SUCCESS;
920:
921: -- Get message count and data
922:
923: OE_MSG_PUB.Count_And_Get
927:
928:
929: EXCEPTION
930:
931: WHEN FND_API.G_EXC_ERROR THEN
932:
933: x_return_status := FND_API.G_RET_STS_ERROR;
934:
935: -- Get message count and data
929: EXCEPTION
930:
931: WHEN FND_API.G_EXC_ERROR THEN
932:
933: x_return_status := FND_API.G_RET_STS_ERROR;
934:
935: -- Get message count and data
936:
937: OE_MSG_PUB.Count_And_Get
938: ( p_count => x_msg_count
939: , p_data => x_msg_data
940: );
941:
942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
943:
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
945:
946: -- Get message count and data
940: );
941:
942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
943:
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
945:
946: -- Get message count and data
947:
948: OE_MSG_PUB.Count_And_Get
951: );
952:
953: WHEN OTHERS THEN
954:
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
956:
957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
958: THEN
959: OE_MSG_PUB.Add_Exc_Msg
1006: -- Call QP_Attributes_PVT.Process_Attributes
1007:
1008: QP_Attributes_PVT.Process_Attributes
1009: ( p_api_version_number => 1.0
1010: , p_init_msg_list => FND_API.G_TRUE
1011: , x_return_status => l_return_status
1012: , x_msg_count => x_msg_count
1013: , x_msg_data => x_msg_data
1014: , p_control_rec => l_control_rec
1015: , x_CON_rec => l_x_CON_rec
1016: , x_SEG_tbl => l_x_SEG_tbl
1017: );
1018:
1019: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1021: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1022: RAISE FND_API.G_EXC_ERROR;
1023: END IF;
1016: , x_SEG_tbl => l_x_SEG_tbl
1017: );
1018:
1019: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1021: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1022: RAISE FND_API.G_EXC_ERROR;
1023: END IF;
1024:
1017: );
1018:
1019: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1021: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1022: RAISE FND_API.G_EXC_ERROR;
1023: END IF;
1024:
1025:
1018:
1019: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1021: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1022: RAISE FND_API.G_EXC_ERROR;
1023: END IF;
1024:
1025:
1026: -- Set return status.
1024:
1025:
1026: -- Set return status.
1027:
1028: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029:
1030: -- Get message count and data
1031:
1032: OE_MSG_PUB.Count_And_Get
1036:
1037:
1038: EXCEPTION
1039:
1040: WHEN FND_API.G_EXC_ERROR THEN
1041:
1042: x_return_status := FND_API.G_RET_STS_ERROR;
1043:
1044: -- Get message count and data
1038: EXCEPTION
1039:
1040: WHEN FND_API.G_EXC_ERROR THEN
1041:
1042: x_return_status := FND_API.G_RET_STS_ERROR;
1043:
1044: -- Get message count and data
1045:
1046: OE_MSG_PUB.Count_And_Get
1047: ( p_count => x_msg_count
1048: , p_data => x_msg_data
1049: );
1050:
1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1052:
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1054:
1055: -- Get message count and data
1049: );
1050:
1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1052:
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1054:
1055: -- Get message count and data
1056:
1057: OE_MSG_PUB.Count_And_Get
1060: );
1061:
1062: WHEN OTHERS THEN
1063:
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1065:
1066: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1067: THEN
1068: OE_MSG_PUB.Add_Exc_Msg
1115: -- Call QP_Attributes_PVT.Process_Attributes
1116:
1117: QP_Attributes_PVT.Process_Attributes
1118: ( p_api_version_number => 1.0
1119: , p_init_msg_list => FND_API.G_TRUE
1120: , x_return_status => l_return_status
1121: , x_msg_count => x_msg_count
1122: , x_msg_data => x_msg_data
1123: , p_control_rec => l_control_rec
1124: , x_CON_rec => l_x_CON_rec
1125: , x_SEG_tbl => l_x_SEG_tbl
1126: );
1127:
1128: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1131: RAISE FND_API.G_EXC_ERROR;
1132: END IF;
1125: , x_SEG_tbl => l_x_SEG_tbl
1126: );
1127:
1128: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1131: RAISE FND_API.G_EXC_ERROR;
1132: END IF;
1133:
1126: );
1127:
1128: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1131: RAISE FND_API.G_EXC_ERROR;
1132: END IF;
1133:
1134:
1127:
1128: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1131: RAISE FND_API.G_EXC_ERROR;
1132: END IF;
1133:
1134:
1135: -- Set return status.
1133:
1134:
1135: -- Set return status.
1136:
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138:
1139: -- Get message count and data
1140:
1141: OE_MSG_PUB.Count_And_Get
1145:
1146:
1147: EXCEPTION
1148:
1149: WHEN FND_API.G_EXC_ERROR THEN
1150:
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152:
1153: -- Get message count and data
1147: EXCEPTION
1148:
1149: WHEN FND_API.G_EXC_ERROR THEN
1150:
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152:
1153: -- Get message count and data
1154:
1155: OE_MSG_PUB.Count_And_Get
1156: ( p_count => x_msg_count
1157: , p_data => x_msg_data
1158: );
1159:
1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1161:
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1163:
1164: -- Get message count and data
1158: );
1159:
1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1161:
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1163:
1164: -- Get message count and data
1165:
1166: OE_MSG_PUB.Count_And_Get
1169: );
1170:
1171: WHEN OTHERS THEN
1172:
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1174:
1175: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1176: THEN
1177: OE_MSG_PUB.Add_Exc_Msg
1277: -- Call QP_Attributes_PVT.Lock_Attributes
1278:
1279: QP_Attributes_PVT.Lock_Attributes
1280: ( p_api_version_number => 1.0
1281: , p_init_msg_list => FND_API.G_TRUE
1282: , x_return_status => l_return_status
1283: , x_msg_count => x_msg_count
1284: , x_msg_data => x_msg_data
1285: , p_CON_rec => l_CON_rec
1286: , x_CON_rec => l_x_CON_rec
1287: , x_SEG_tbl => l_x_SEG_tbl
1288: );
1289:
1290: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1291:
1292: -- Set DB flag and write record to cache.
1293:
1294: l_x_CON_rec.db_flag := FND_API.G_TRUE;
1290: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1291:
1292: -- Set DB flag and write record to cache.
1293:
1294: l_x_CON_rec.db_flag := FND_API.G_TRUE;
1295:
1296: Write_CON
1297: ( p_CON_rec => l_x_CON_rec
1298: , p_db_record => TRUE
1323: , 'Lock_Row'
1324: );
1325: END IF;
1326:
1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328:
1329: -- Get message count and data
1330:
1331: OE_MSG_PUB.Count_And_Get
1372: g_CON_rec := QP_Con_Util.Query_Row
1373: ( p_prc_context_id => p_prc_context_id
1374: );
1375:
1376: g_CON_rec.db_flag := FND_API.G_TRUE;
1377:
1378: -- Load DB record
1379:
1380: g_db_CON_rec := g_CON_rec;