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

Line 132: , p_init_msg_list => FND_API.G_TRUE

128: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
129:
130: QP_Attr_Map_PVT.Process_Attr_Mapping
131: ( p_api_version_number => 1.0
132: , p_init_msg_list => FND_API.G_TRUE
133: , x_return_status => l_return_status
134: , x_msg_count => x_msg_count
135: , x_msg_data => x_msg_data
136: , p_control_rec => l_control_rec

Line 146: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

142: , x_SOU_tbl => l_x_SOU_tbl
143: , x_FNA_tbl => l_x_FNA_tbl
144: );
145:
146: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
149: RAISE FND_API.G_EXC_ERROR;
150: END IF;

Line 147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

143: , x_FNA_tbl => l_x_FNA_tbl
144: );
145:
146: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
149: RAISE FND_API.G_EXC_ERROR;
150: END IF;
151:

Line 148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

144: );
145:
146: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
149: RAISE FND_API.G_EXC_ERROR;
150: END IF;
151:
152:

Line 149: RAISE FND_API.G_EXC_ERROR;

145:
146: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
149: RAISE FND_API.G_EXC_ERROR;
150: END IF;
151:
152:
153: -- Unload out tbl

Line 192: l_x_SSC_rec.db_flag := FND_API.G_FALSE;

188:
189: -- Write to cache.
190: -- Set db_flag to False before writing to cache
191:
192: l_x_SSC_rec.db_flag := FND_API.G_FALSE;
193:
194: Write_SSC
195: ( p_SSC_rec => l_x_SSC_rec
196: );

Line 200: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 212: WHEN FND_API.G_EXC_ERROR THEN

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

Line 214: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

232: );
233:
234: WHEN OTHERS THEN
235:
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237:
238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: OE_MSG_PUB.Add_Exc_Msg

Line 406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 412: IF FND_API.To_Boolean(l_SSC_rec.db_flag) THEN

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

Line 427: , p_init_msg_list => FND_API.G_TRUE

423: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
424:
425: QP_Attr_Map_PVT.Process_Attr_Mapping
426: ( p_api_version_number => 1.0
427: , p_init_msg_list => FND_API.G_TRUE
428: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
429: , x_return_status => l_return_status
430: , x_msg_count => x_msg_count
431: , x_msg_data => x_msg_data

Line 428: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

424:
425: QP_Attr_Map_PVT.Process_Attr_Mapping
426: ( p_api_version_number => 1.0
427: , p_init_msg_list => FND_API.G_TRUE
428: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
429: , x_return_status => l_return_status
430: , x_msg_count => x_msg_count
431: , x_msg_data => x_msg_data
432: , p_control_rec => l_control_rec

Line 443: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 445: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 446: RAISE FND_API.G_EXC_ERROR;

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

Line 456: x_application_short_name := FND_API.G_MISS_CHAR;

452: l_x_SSC_rec := l_x_SSC_tbl(1);
453:
454: -- Init OUT parameters to missing.
455:
456: x_application_short_name := FND_API.G_MISS_CHAR;
457: x_attribute1 := FND_API.G_MISS_CHAR;
458: x_attribute10 := FND_API.G_MISS_CHAR;
459: x_attribute11 := FND_API.G_MISS_CHAR;
460: x_attribute12 := FND_API.G_MISS_CHAR;

Line 457: x_attribute1 := FND_API.G_MISS_CHAR;

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

Line 458: x_attribute10 := FND_API.G_MISS_CHAR;

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

Line 459: x_attribute11 := FND_API.G_MISS_CHAR;

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

Line 460: x_attribute12 := FND_API.G_MISS_CHAR;

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

Line 461: x_attribute13 := FND_API.G_MISS_CHAR;

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

Line 462: x_attribute14 := FND_API.G_MISS_CHAR;

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

Line 463: x_attribute15 := FND_API.G_MISS_CHAR;

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

Line 464: x_attribute2 := FND_API.G_MISS_CHAR;

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

Line 465: x_attribute3 := FND_API.G_MISS_CHAR;

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

Line 466: x_attribute4 := FND_API.G_MISS_CHAR;

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

Line 467: x_attribute5 := FND_API.G_MISS_CHAR;

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

Line 468: x_attribute6 := FND_API.G_MISS_CHAR;

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

Line 469: x_attribute7 := FND_API.G_MISS_CHAR;

465: x_attribute3 := FND_API.G_MISS_CHAR;
466: x_attribute4 := FND_API.G_MISS_CHAR;
467: x_attribute5 := FND_API.G_MISS_CHAR;
468: x_attribute6 := FND_API.G_MISS_CHAR;
469: x_attribute7 := FND_API.G_MISS_CHAR;
470: x_attribute8 := FND_API.G_MISS_CHAR;
471: x_attribute9 := FND_API.G_MISS_CHAR;
472: x_context := FND_API.G_MISS_CHAR;
473: x_enabled_flag := FND_API.G_MISS_CHAR;

Line 470: x_attribute8 := FND_API.G_MISS_CHAR;

466: x_attribute4 := FND_API.G_MISS_CHAR;
467: x_attribute5 := FND_API.G_MISS_CHAR;
468: x_attribute6 := FND_API.G_MISS_CHAR;
469: x_attribute7 := FND_API.G_MISS_CHAR;
470: x_attribute8 := FND_API.G_MISS_CHAR;
471: x_attribute9 := FND_API.G_MISS_CHAR;
472: x_context := FND_API.G_MISS_CHAR;
473: x_enabled_flag := FND_API.G_MISS_CHAR;
474: x_pte_code := FND_API.G_MISS_CHAR;

Line 471: x_attribute9 := FND_API.G_MISS_CHAR;

467: x_attribute5 := FND_API.G_MISS_CHAR;
468: x_attribute6 := FND_API.G_MISS_CHAR;
469: x_attribute7 := FND_API.G_MISS_CHAR;
470: x_attribute8 := FND_API.G_MISS_CHAR;
471: x_attribute9 := FND_API.G_MISS_CHAR;
472: x_context := FND_API.G_MISS_CHAR;
473: x_enabled_flag := FND_API.G_MISS_CHAR;
474: x_pte_code := FND_API.G_MISS_CHAR;
475: x_pte_source_system_id := FND_API.G_MISS_NUM;

Line 472: x_context := FND_API.G_MISS_CHAR;

468: x_attribute6 := FND_API.G_MISS_CHAR;
469: x_attribute7 := FND_API.G_MISS_CHAR;
470: x_attribute8 := FND_API.G_MISS_CHAR;
471: x_attribute9 := FND_API.G_MISS_CHAR;
472: x_context := FND_API.G_MISS_CHAR;
473: x_enabled_flag := FND_API.G_MISS_CHAR;
474: x_pte_code := FND_API.G_MISS_CHAR;
475: x_pte_source_system_id := FND_API.G_MISS_NUM;
476: x_enabled := FND_API.G_MISS_CHAR;

Line 473: x_enabled_flag := FND_API.G_MISS_CHAR;

469: x_attribute7 := FND_API.G_MISS_CHAR;
470: x_attribute8 := FND_API.G_MISS_CHAR;
471: x_attribute9 := FND_API.G_MISS_CHAR;
472: x_context := FND_API.G_MISS_CHAR;
473: x_enabled_flag := FND_API.G_MISS_CHAR;
474: x_pte_code := FND_API.G_MISS_CHAR;
475: x_pte_source_system_id := FND_API.G_MISS_NUM;
476: x_enabled := FND_API.G_MISS_CHAR;
477: x_pte := FND_API.G_MISS_CHAR;

Line 474: x_pte_code := FND_API.G_MISS_CHAR;

470: x_attribute8 := FND_API.G_MISS_CHAR;
471: x_attribute9 := FND_API.G_MISS_CHAR;
472: x_context := FND_API.G_MISS_CHAR;
473: x_enabled_flag := FND_API.G_MISS_CHAR;
474: x_pte_code := FND_API.G_MISS_CHAR;
475: x_pte_source_system_id := FND_API.G_MISS_NUM;
476: x_enabled := FND_API.G_MISS_CHAR;
477: x_pte := FND_API.G_MISS_CHAR;
478: x_pte_source_system := FND_API.G_MISS_CHAR;

Line 475: x_pte_source_system_id := FND_API.G_MISS_NUM;

471: x_attribute9 := FND_API.G_MISS_CHAR;
472: x_context := FND_API.G_MISS_CHAR;
473: x_enabled_flag := FND_API.G_MISS_CHAR;
474: x_pte_code := FND_API.G_MISS_CHAR;
475: x_pte_source_system_id := FND_API.G_MISS_NUM;
476: x_enabled := FND_API.G_MISS_CHAR;
477: x_pte := FND_API.G_MISS_CHAR;
478: x_pte_source_system := FND_API.G_MISS_CHAR;
479:

Line 476: x_enabled := FND_API.G_MISS_CHAR;

472: x_context := FND_API.G_MISS_CHAR;
473: x_enabled_flag := FND_API.G_MISS_CHAR;
474: x_pte_code := FND_API.G_MISS_CHAR;
475: x_pte_source_system_id := FND_API.G_MISS_NUM;
476: x_enabled := FND_API.G_MISS_CHAR;
477: x_pte := FND_API.G_MISS_CHAR;
478: x_pte_source_system := FND_API.G_MISS_CHAR;
479:
480: -- Load display out parameters if any

Line 477: x_pte := FND_API.G_MISS_CHAR;

473: x_enabled_flag := FND_API.G_MISS_CHAR;
474: x_pte_code := FND_API.G_MISS_CHAR;
475: x_pte_source_system_id := FND_API.G_MISS_NUM;
476: x_enabled := FND_API.G_MISS_CHAR;
477: x_pte := FND_API.G_MISS_CHAR;
478: x_pte_source_system := FND_API.G_MISS_CHAR;
479:
480: -- Load display out parameters if any
481:

Line 478: x_pte_source_system := FND_API.G_MISS_CHAR;

474: x_pte_code := FND_API.G_MISS_CHAR;
475: x_pte_source_system_id := FND_API.G_MISS_NUM;
476: x_enabled := FND_API.G_MISS_CHAR;
477: x_pte := FND_API.G_MISS_CHAR;
478: x_pte_source_system := FND_API.G_MISS_CHAR;
479:
480: -- Load display out parameters if any
481:
482: l_SSC_val_rec := QP_Ssc_Util.Get_Values

Line 621: x_return_status := FND_API.G_RET_STS_SUCCESS;

617: );
618:
619: -- Set return status.
620:
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: -- Get message count and data
624:
625: OE_MSG_PUB.Count_And_Get

Line 633: WHEN FND_API.G_EXC_ERROR THEN

629:
630:
631: EXCEPTION
632:
633: WHEN FND_API.G_EXC_ERROR THEN
634:
635: x_return_status := FND_API.G_RET_STS_ERROR;
636:
637: -- Get message count and data

Line 635: x_return_status := FND_API.G_RET_STS_ERROR;

631: EXCEPTION
632:
633: WHEN FND_API.G_EXC_ERROR THEN
634:
635: x_return_status := FND_API.G_RET_STS_ERROR;
636:
637: -- Get message count and data
638:
639: OE_MSG_PUB.Count_And_Get

Line 644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

640: ( p_count => x_msg_count
641: , p_data => x_msg_data
642: );
643:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645:
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
647:
648: -- Get message count and data

Line 646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

642: );
643:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645:
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
647:
648: -- Get message count and data
649:
650: OE_MSG_PUB.Count_And_Get

Line 657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

653: );
654:
655: WHEN OTHERS THEN
656:
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
658:
659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
660: THEN
661: OE_MSG_PUB.Add_Exc_Msg

Line 739: IF FND_API.To_Boolean(l_SSC_rec.db_flag) THEN

735: );
736:
737: -- Set Operation.
738:
739: IF FND_API.To_Boolean(l_SSC_rec.db_flag) THEN
740: l_SSC_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
741: ELSE
742: l_SSC_rec.operation := QP_GLOBALS.G_OPR_CREATE;
743: END IF;

Line 754: , p_init_msg_list => FND_API.G_TRUE

750: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
751:
752: QP_Attr_Map_PVT.Process_Attr_Mapping
753: ( p_api_version_number => 1.0
754: , p_init_msg_list => FND_API.G_TRUE
755: , x_return_status => l_return_status
756: , x_msg_count => x_msg_count
757: , x_msg_data => x_msg_data
758: , p_control_rec => l_control_rec

Line 769: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

765: , x_SOU_tbl => l_x_SOU_tbl
766: , x_FNA_tbl => l_x_FNA_tbl
767: );
768:
769: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;

Line 770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

766: , x_FNA_tbl => l_x_FNA_tbl
767: );
768:
769: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774:

Line 771: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

767: );
768:
769: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774:
775:

Line 772: RAISE FND_API.G_EXC_ERROR;

768:
769: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774:
775:
776: -- Load OUT parameters.

Line 797: x_return_status := FND_API.G_RET_STS_SUCCESS;

793:
794:
795: -- Set return status.
796:
797: x_return_status := FND_API.G_RET_STS_SUCCESS;
798:
799: -- Get message count and data
800:
801: OE_MSG_PUB.Count_And_Get

Line 809: WHEN FND_API.G_EXC_ERROR THEN

805:
806:
807: EXCEPTION
808:
809: WHEN FND_API.G_EXC_ERROR THEN
810:
811: x_return_status := FND_API.G_RET_STS_ERROR;
812:
813: -- Get message count and data

Line 811: x_return_status := FND_API.G_RET_STS_ERROR;

807: EXCEPTION
808:
809: WHEN FND_API.G_EXC_ERROR THEN
810:
811: x_return_status := FND_API.G_RET_STS_ERROR;
812:
813: -- Get message count and data
814:
815: OE_MSG_PUB.Count_And_Get

Line 820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

816: ( p_count => x_msg_count
817: , p_data => x_msg_data
818: );
819:
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
821:
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
823:
824: -- Get message count and data

Line 822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

818: );
819:
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
821:
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
823:
824: -- Get message count and data
825:
826: OE_MSG_PUB.Count_And_Get

Line 833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

829: );
830:
831: WHEN OTHERS THEN
832:
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
834:
835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837: OE_MSG_PUB.Add_Exc_Msg

Line 913: , p_init_msg_list => FND_API.G_TRUE

909: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
910:
911: QP_Attr_Map_PVT.Process_Attr_Mapping
912: ( p_api_version_number => 1.0
913: , p_init_msg_list => FND_API.G_TRUE
914: , x_return_status => l_return_status
915: , x_msg_count => x_msg_count
916: , x_msg_data => x_msg_data
917: , p_control_rec => l_control_rec

Line 927: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

923: , x_SOU_tbl => l_x_SOU_tbl
924: , x_FNA_tbl => l_x_FNA_tbl
925: );
926:
927: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;

Line 928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

924: , x_FNA_tbl => l_x_FNA_tbl
925: );
926:
927: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932:

Line 929: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

925: );
926:
927: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932:
933:

Line 930: RAISE FND_API.G_EXC_ERROR;

926:
927: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932:
933:
934: -- Clear SSC record cache

Line 940: x_return_status := FND_API.G_RET_STS_SUCCESS;

936: Clear_SSC;
937:
938: -- Set return status.
939:
940: x_return_status := FND_API.G_RET_STS_SUCCESS;
941:
942: -- Get message count and data
943:
944: OE_MSG_PUB.Count_And_Get

Line 952: WHEN FND_API.G_EXC_ERROR THEN

948:
949:
950: EXCEPTION
951:
952: WHEN FND_API.G_EXC_ERROR THEN
953:
954: x_return_status := FND_API.G_RET_STS_ERROR;
955:
956: -- Get message count and data

Line 954: x_return_status := FND_API.G_RET_STS_ERROR;

950: EXCEPTION
951:
952: WHEN FND_API.G_EXC_ERROR THEN
953:
954: x_return_status := FND_API.G_RET_STS_ERROR;
955:
956: -- Get message count and data
957:
958: OE_MSG_PUB.Count_And_Get

Line 963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

959: ( p_count => x_msg_count
960: , p_data => x_msg_data
961: );
962:
963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
964:
965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
966:
967: -- Get message count and data

Line 965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

961: );
962:
963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
964:
965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
966:
967: -- Get message count and data
968:
969: OE_MSG_PUB.Count_And_Get

Line 976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

972: );
973:
974: WHEN OTHERS THEN
975:
976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
977:
978: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
979: THEN
980: OE_MSG_PUB.Add_Exc_Msg

Line 1039: , p_init_msg_list => FND_API.G_TRUE

1035: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
1036:
1037: QP_Attr_Map_PVT.Process_Attr_Mapping
1038: ( p_api_version_number => 1.0
1039: , p_init_msg_list => FND_API.G_TRUE
1040: , x_return_status => l_return_status
1041: , x_msg_count => x_msg_count
1042: , x_msg_data => x_msg_data
1043: , p_control_rec => l_control_rec

Line 1052: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1054: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1055: RAISE FND_API.G_EXC_ERROR;

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

Line 1061: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1073: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1075: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1084: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1208: , p_init_msg_list => FND_API.G_TRUE

1204: -- Call QP_Attr_Map_PVT.Lock_Attr_Mapping
1205:
1206: QP_Attr_Map_PVT.Lock_Attr_Mapping
1207: ( p_api_version_number => 1.0
1208: , p_init_msg_list => FND_API.G_TRUE
1209: , x_return_status => l_return_status
1210: , x_msg_count => x_msg_count
1211: , x_msg_data => x_msg_data
1212: , p_SSC_tbl => l_SSC_tbl

Line 1221: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1217: , x_SOU_tbl => l_x_SOU_tbl
1218: , x_FNA_tbl => l_x_FNA_tbl
1219: );
1220:
1221: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1222:
1223: -- Set DB flag and write record to cache.
1224:
1225: l_x_SSC_rec.db_flag := FND_API.G_TRUE;

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

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

Line 1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

1303: g_SSC_rec := QP_Ssc_Util.Query_Row
1304: ( p_pte_source_system_id => p_pte_source_system_id
1305: );
1306:
1307: g_SSC_rec.db_flag := FND_API.G_TRUE;
1308:
1309: -- Load DB record
1310:
1311: g_db_SSC_rec := g_SSC_rec;