DBA Data[Home] [Help]

APPS.QP_QP_FORM_CON dependencies on FND_API

Line 124: , p_init_msg_list => FND_API.G_TRUE

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

Line 134: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 136: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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:

Line 137: RAISE FND_API.G_EXC_ERROR;

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.

Line 181: l_x_CON_rec.db_flag := FND_API.G_FALSE;

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: );

Line 189: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 201: WHEN FND_API.G_EXC_ERROR THEN

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

Line 203: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: , 'Unrecognized attribute'
397: );
398: END IF;
399:
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401:
402: END IF;
403:
404: -- Set Operation.

Line 406: IF FND_API.To_Boolean(l_CON_rec.db_flag) THEN

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;

Line 416: , p_init_msg_list => FND_API.G_TRUE

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

Line 417: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

Line 428: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 430: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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:

Line 431: RAISE FND_API.G_EXC_ERROR;

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.

Line 437: x_attribute1 := FND_API.G_MISS_CHAR;

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;

Line 438: x_attribute10 := 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;

Line 439: x_attribute11 := 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;

Line 440: x_attribute12 := 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;

Line 441: x_attribute13 := 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;

Line 442: x_attribute14 := 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;

Line 443: x_attribute15 := 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;

Line 444: x_attribute2 := 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;

Line 445: x_attribute3 := 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;

Line 446: x_attribute4 := 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;

Line 447: x_attribute5 := 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;

Line 448: x_attribute6 := 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;

Line 449: x_attribute7 := 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;

Line 450: x_attribute8 := 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;

Line 451: x_attribute9 := 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;

Line 452: x_context := 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;
456: x_prc_context_type := FND_API.G_MISS_CHAR;

Line 453: x_enabled_flag := 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;

Line 454: x_prc_context_code := 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;

Line 455: x_prc_context_id := FND_API.G_MISS_NUM;

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;

Line 456: x_prc_context_type := 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;

Line 457: x_seeded_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;

Line 458: x_seeded_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;
462: x_enabled := FND_API.G_MISS_CHAR;

Line 459: x_seeded_prc_context_name := 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;

Line 460: x_user_description := 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;

Line 461: x_user_prc_context_name := 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:

Line 462: x_enabled := 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:
466: -- Load display out parameters if any

Line 463: x_prc_context := 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
467:

Line 464: x_seeded := 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:
468: l_CON_val_rec := QP_Con_Util.Get_Values

Line 637: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 649: WHEN FND_API.G_EXC_ERROR THEN

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

Line 651: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 745: IF FND_API.To_Boolean(l_CON_rec.db_flag) THEN

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;

Line 755: , p_init_msg_list => FND_API.G_TRUE

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

Line 766: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 768: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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:

Line 769: RAISE FND_API.G_EXC_ERROR;

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.

Line 793: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 805: WHEN FND_API.G_EXC_ERROR THEN

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

Line 807: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 896: , p_init_msg_list => FND_API.G_TRUE

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

Line 906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 908: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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:

Line 909: RAISE FND_API.G_EXC_ERROR;

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

Line 919: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 931: WHEN FND_API.G_EXC_ERROR THEN

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

Line 933: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1010: , p_init_msg_list => FND_API.G_TRUE

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

Line 1019: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1021: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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:

Line 1022: RAISE FND_API.G_EXC_ERROR;

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.

Line 1028: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1040: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1042: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1119: , p_init_msg_list => FND_API.G_TRUE

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

Line 1128: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1130: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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:

Line 1131: RAISE FND_API.G_EXC_ERROR;

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.

Line 1137: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1149: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1151: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1281: , p_init_msg_list => FND_API.G_TRUE

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

Line 1290: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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;

Line 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

Line 1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1376: g_CON_rec.db_flag := FND_API.G_TRUE;

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;