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

Line 151: , p_init_msg_list => FND_API.G_TRUE

147: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
148:
149: QP_Attr_Map_PVT.Process_Attr_Mapping
150: ( p_api_version_number => 1.0
151: , p_init_msg_list => FND_API.G_TRUE
152: , x_return_status => l_return_status
153: , x_msg_count => x_msg_count
154: , x_msg_data => x_msg_data
155: , p_control_rec => l_control_rec

Line 165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

161: , x_SOU_tbl => l_x_SOU_tbl
162: , x_FNA_tbl => l_x_FNA_tbl
163: );
164:
165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162: , x_FNA_tbl => l_x_FNA_tbl
163: );
164:
165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170:

Line 167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

163: );
164:
165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170:
171:

Line 168: RAISE FND_API.G_EXC_ERROR;

164:
165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170:
171:
172: -- Unload out tbl

Line 214: l_x_FNA_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_FNA_rec.db_flag := FND_API.G_FALSE;
215:
216: Write_FNA
217: ( p_FNA_rec => l_x_FNA_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 431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

427: , 'Unrecognized attribute'
428: );
429: END IF;
430:
431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432:
433: END IF;
434:
435: -- Set Operation.

Line 437: IF FND_API.To_Boolean(l_FNA_rec.db_flag) THEN

433: END IF;
434:
435: -- Set Operation.
436:
437: IF FND_API.To_Boolean(l_FNA_rec.db_flag) THEN
438: l_FNA_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
439: ELSE
440: l_FNA_rec.operation := QP_GLOBALS.G_OPR_CREATE;
441: END IF;

Line 452: , p_init_msg_list => FND_API.G_TRUE

448: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
449:
450: QP_Attr_Map_PVT.Process_Attr_Mapping
451: ( p_api_version_number => 1.0
452: , p_init_msg_list => FND_API.G_TRUE
453: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
454: , x_return_status => l_return_status
455: , x_msg_count => x_msg_count
456: , x_msg_data => x_msg_data

Line 453: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

449:
450: QP_Attr_Map_PVT.Process_Attr_Mapping
451: ( p_api_version_number => 1.0
452: , p_init_msg_list => FND_API.G_TRUE
453: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
454: , x_return_status => l_return_status
455: , x_msg_count => x_msg_count
456: , x_msg_data => x_msg_data
457: , p_control_rec => l_control_rec

Line 468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

464: , x_SOU_tbl => l_x_SOU_tbl
465: , x_FNA_tbl => l_x_FNA_tbl
466: );
467:
468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;

Line 469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

465: , x_FNA_tbl => l_x_FNA_tbl
466: );
467:
468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473:

Line 470: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

466: );
467:
468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473:
474:

Line 471: RAISE FND_API.G_EXC_ERROR;

467:
468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473:
474:
475: -- Unload out tbl

Line 481: x_attribute1 := FND_API.G_MISS_CHAR;

477: l_x_FNA_rec := l_x_FNA_tbl(1);
478:
479: -- Init OUT parameters to missing.
480:
481: x_attribute1 := FND_API.G_MISS_CHAR;
482: x_attribute10 := FND_API.G_MISS_CHAR;
483: x_attribute11 := FND_API.G_MISS_CHAR;
484: x_attribute12 := FND_API.G_MISS_CHAR;
485: x_attribute13 := FND_API.G_MISS_CHAR;

Line 482: x_attribute10 := FND_API.G_MISS_CHAR;

478:
479: -- Init OUT parameters to missing.
480:
481: x_attribute1 := FND_API.G_MISS_CHAR;
482: x_attribute10 := FND_API.G_MISS_CHAR;
483: x_attribute11 := FND_API.G_MISS_CHAR;
484: x_attribute12 := FND_API.G_MISS_CHAR;
485: x_attribute13 := FND_API.G_MISS_CHAR;
486: x_attribute14 := FND_API.G_MISS_CHAR;

Line 483: x_attribute11 := FND_API.G_MISS_CHAR;

479: -- Init OUT parameters to missing.
480:
481: x_attribute1 := FND_API.G_MISS_CHAR;
482: x_attribute10 := FND_API.G_MISS_CHAR;
483: x_attribute11 := FND_API.G_MISS_CHAR;
484: x_attribute12 := FND_API.G_MISS_CHAR;
485: x_attribute13 := FND_API.G_MISS_CHAR;
486: x_attribute14 := FND_API.G_MISS_CHAR;
487: x_attribute15 := FND_API.G_MISS_CHAR;

Line 484: x_attribute12 := FND_API.G_MISS_CHAR;

480:
481: x_attribute1 := FND_API.G_MISS_CHAR;
482: x_attribute10 := FND_API.G_MISS_CHAR;
483: x_attribute11 := FND_API.G_MISS_CHAR;
484: x_attribute12 := FND_API.G_MISS_CHAR;
485: x_attribute13 := FND_API.G_MISS_CHAR;
486: x_attribute14 := FND_API.G_MISS_CHAR;
487: x_attribute15 := FND_API.G_MISS_CHAR;
488: x_attribute2 := FND_API.G_MISS_CHAR;

Line 485: x_attribute13 := FND_API.G_MISS_CHAR;

481: x_attribute1 := FND_API.G_MISS_CHAR;
482: x_attribute10 := FND_API.G_MISS_CHAR;
483: x_attribute11 := FND_API.G_MISS_CHAR;
484: x_attribute12 := FND_API.G_MISS_CHAR;
485: x_attribute13 := FND_API.G_MISS_CHAR;
486: x_attribute14 := FND_API.G_MISS_CHAR;
487: x_attribute15 := FND_API.G_MISS_CHAR;
488: x_attribute2 := FND_API.G_MISS_CHAR;
489: x_attribute3 := FND_API.G_MISS_CHAR;

Line 486: x_attribute14 := FND_API.G_MISS_CHAR;

482: x_attribute10 := FND_API.G_MISS_CHAR;
483: x_attribute11 := FND_API.G_MISS_CHAR;
484: x_attribute12 := FND_API.G_MISS_CHAR;
485: x_attribute13 := FND_API.G_MISS_CHAR;
486: x_attribute14 := FND_API.G_MISS_CHAR;
487: x_attribute15 := FND_API.G_MISS_CHAR;
488: x_attribute2 := FND_API.G_MISS_CHAR;
489: x_attribute3 := FND_API.G_MISS_CHAR;
490: x_attribute4 := FND_API.G_MISS_CHAR;

Line 487: x_attribute15 := FND_API.G_MISS_CHAR;

483: x_attribute11 := FND_API.G_MISS_CHAR;
484: x_attribute12 := FND_API.G_MISS_CHAR;
485: x_attribute13 := FND_API.G_MISS_CHAR;
486: x_attribute14 := FND_API.G_MISS_CHAR;
487: x_attribute15 := FND_API.G_MISS_CHAR;
488: x_attribute2 := FND_API.G_MISS_CHAR;
489: x_attribute3 := FND_API.G_MISS_CHAR;
490: x_attribute4 := FND_API.G_MISS_CHAR;
491: x_attribute5 := FND_API.G_MISS_CHAR;

Line 488: x_attribute2 := FND_API.G_MISS_CHAR;

484: x_attribute12 := FND_API.G_MISS_CHAR;
485: x_attribute13 := FND_API.G_MISS_CHAR;
486: x_attribute14 := FND_API.G_MISS_CHAR;
487: x_attribute15 := FND_API.G_MISS_CHAR;
488: x_attribute2 := FND_API.G_MISS_CHAR;
489: x_attribute3 := FND_API.G_MISS_CHAR;
490: x_attribute4 := FND_API.G_MISS_CHAR;
491: x_attribute5 := FND_API.G_MISS_CHAR;
492: x_attribute6 := FND_API.G_MISS_CHAR;

Line 489: x_attribute3 := FND_API.G_MISS_CHAR;

485: x_attribute13 := FND_API.G_MISS_CHAR;
486: x_attribute14 := FND_API.G_MISS_CHAR;
487: x_attribute15 := FND_API.G_MISS_CHAR;
488: x_attribute2 := FND_API.G_MISS_CHAR;
489: x_attribute3 := FND_API.G_MISS_CHAR;
490: x_attribute4 := FND_API.G_MISS_CHAR;
491: x_attribute5 := FND_API.G_MISS_CHAR;
492: x_attribute6 := FND_API.G_MISS_CHAR;
493: x_attribute7 := FND_API.G_MISS_CHAR;

Line 490: x_attribute4 := FND_API.G_MISS_CHAR;

486: x_attribute14 := FND_API.G_MISS_CHAR;
487: x_attribute15 := FND_API.G_MISS_CHAR;
488: x_attribute2 := FND_API.G_MISS_CHAR;
489: x_attribute3 := FND_API.G_MISS_CHAR;
490: x_attribute4 := FND_API.G_MISS_CHAR;
491: x_attribute5 := FND_API.G_MISS_CHAR;
492: x_attribute6 := FND_API.G_MISS_CHAR;
493: x_attribute7 := FND_API.G_MISS_CHAR;
494: x_attribute8 := FND_API.G_MISS_CHAR;

Line 491: x_attribute5 := FND_API.G_MISS_CHAR;

487: x_attribute15 := FND_API.G_MISS_CHAR;
488: x_attribute2 := FND_API.G_MISS_CHAR;
489: x_attribute3 := FND_API.G_MISS_CHAR;
490: x_attribute4 := FND_API.G_MISS_CHAR;
491: x_attribute5 := FND_API.G_MISS_CHAR;
492: x_attribute6 := FND_API.G_MISS_CHAR;
493: x_attribute7 := FND_API.G_MISS_CHAR;
494: x_attribute8 := FND_API.G_MISS_CHAR;
495: x_attribute9 := FND_API.G_MISS_CHAR;

Line 492: x_attribute6 := FND_API.G_MISS_CHAR;

488: x_attribute2 := FND_API.G_MISS_CHAR;
489: x_attribute3 := FND_API.G_MISS_CHAR;
490: x_attribute4 := FND_API.G_MISS_CHAR;
491: x_attribute5 := FND_API.G_MISS_CHAR;
492: x_attribute6 := FND_API.G_MISS_CHAR;
493: x_attribute7 := FND_API.G_MISS_CHAR;
494: x_attribute8 := FND_API.G_MISS_CHAR;
495: x_attribute9 := FND_API.G_MISS_CHAR;
496: x_context := FND_API.G_MISS_CHAR;

Line 493: x_attribute7 := FND_API.G_MISS_CHAR;

489: x_attribute3 := FND_API.G_MISS_CHAR;
490: x_attribute4 := FND_API.G_MISS_CHAR;
491: x_attribute5 := FND_API.G_MISS_CHAR;
492: x_attribute6 := FND_API.G_MISS_CHAR;
493: x_attribute7 := FND_API.G_MISS_CHAR;
494: x_attribute8 := FND_API.G_MISS_CHAR;
495: x_attribute9 := FND_API.G_MISS_CHAR;
496: x_context := FND_API.G_MISS_CHAR;
497: x_enabled_flag := FND_API.G_MISS_CHAR;

Line 494: x_attribute8 := FND_API.G_MISS_CHAR;

490: x_attribute4 := FND_API.G_MISS_CHAR;
491: x_attribute5 := FND_API.G_MISS_CHAR;
492: x_attribute6 := FND_API.G_MISS_CHAR;
493: x_attribute7 := FND_API.G_MISS_CHAR;
494: x_attribute8 := FND_API.G_MISS_CHAR;
495: x_attribute9 := FND_API.G_MISS_CHAR;
496: x_context := FND_API.G_MISS_CHAR;
497: x_enabled_flag := FND_API.G_MISS_CHAR;
498: x_functional_area_id := FND_API.G_MISS_NUM;

Line 495: x_attribute9 := FND_API.G_MISS_CHAR;

491: x_attribute5 := FND_API.G_MISS_CHAR;
492: x_attribute6 := FND_API.G_MISS_CHAR;
493: x_attribute7 := FND_API.G_MISS_CHAR;
494: x_attribute8 := FND_API.G_MISS_CHAR;
495: x_attribute9 := FND_API.G_MISS_CHAR;
496: x_context := FND_API.G_MISS_CHAR;
497: x_enabled_flag := FND_API.G_MISS_CHAR;
498: x_functional_area_id := FND_API.G_MISS_NUM;
499: x_pte_sourcesystem_fnarea_id := FND_API.G_MISS_NUM;

Line 496: x_context := FND_API.G_MISS_CHAR;

492: x_attribute6 := FND_API.G_MISS_CHAR;
493: x_attribute7 := FND_API.G_MISS_CHAR;
494: x_attribute8 := FND_API.G_MISS_CHAR;
495: x_attribute9 := FND_API.G_MISS_CHAR;
496: x_context := FND_API.G_MISS_CHAR;
497: x_enabled_flag := FND_API.G_MISS_CHAR;
498: x_functional_area_id := FND_API.G_MISS_NUM;
499: x_pte_sourcesystem_fnarea_id := FND_API.G_MISS_NUM;
500: x_pte_source_system_id := FND_API.G_MISS_NUM;

Line 497: x_enabled_flag := FND_API.G_MISS_CHAR;

493: x_attribute7 := FND_API.G_MISS_CHAR;
494: x_attribute8 := FND_API.G_MISS_CHAR;
495: x_attribute9 := FND_API.G_MISS_CHAR;
496: x_context := FND_API.G_MISS_CHAR;
497: x_enabled_flag := FND_API.G_MISS_CHAR;
498: x_functional_area_id := FND_API.G_MISS_NUM;
499: x_pte_sourcesystem_fnarea_id := FND_API.G_MISS_NUM;
500: x_pte_source_system_id := FND_API.G_MISS_NUM;
501: x_seeded_flag := FND_API.G_MISS_CHAR;

Line 498: x_functional_area_id := FND_API.G_MISS_NUM;

494: x_attribute8 := FND_API.G_MISS_CHAR;
495: x_attribute9 := FND_API.G_MISS_CHAR;
496: x_context := FND_API.G_MISS_CHAR;
497: x_enabled_flag := FND_API.G_MISS_CHAR;
498: x_functional_area_id := FND_API.G_MISS_NUM;
499: x_pte_sourcesystem_fnarea_id := FND_API.G_MISS_NUM;
500: x_pte_source_system_id := FND_API.G_MISS_NUM;
501: x_seeded_flag := FND_API.G_MISS_CHAR;
502: x_enabled := FND_API.G_MISS_CHAR;

Line 499: x_pte_sourcesystem_fnarea_id := FND_API.G_MISS_NUM;

495: x_attribute9 := FND_API.G_MISS_CHAR;
496: x_context := FND_API.G_MISS_CHAR;
497: x_enabled_flag := FND_API.G_MISS_CHAR;
498: x_functional_area_id := FND_API.G_MISS_NUM;
499: x_pte_sourcesystem_fnarea_id := FND_API.G_MISS_NUM;
500: x_pte_source_system_id := FND_API.G_MISS_NUM;
501: x_seeded_flag := FND_API.G_MISS_CHAR;
502: x_enabled := FND_API.G_MISS_CHAR;
503: x_functional_area := FND_API.G_MISS_CHAR;

Line 500: x_pte_source_system_id := FND_API.G_MISS_NUM;

496: x_context := FND_API.G_MISS_CHAR;
497: x_enabled_flag := FND_API.G_MISS_CHAR;
498: x_functional_area_id := FND_API.G_MISS_NUM;
499: x_pte_sourcesystem_fnarea_id := FND_API.G_MISS_NUM;
500: x_pte_source_system_id := FND_API.G_MISS_NUM;
501: x_seeded_flag := FND_API.G_MISS_CHAR;
502: x_enabled := FND_API.G_MISS_CHAR;
503: x_functional_area := FND_API.G_MISS_CHAR;
504: x_pte_sourcesystem_fnarea := FND_API.G_MISS_CHAR;

Line 501: x_seeded_flag := FND_API.G_MISS_CHAR;

497: x_enabled_flag := FND_API.G_MISS_CHAR;
498: x_functional_area_id := FND_API.G_MISS_NUM;
499: x_pte_sourcesystem_fnarea_id := FND_API.G_MISS_NUM;
500: x_pte_source_system_id := FND_API.G_MISS_NUM;
501: x_seeded_flag := FND_API.G_MISS_CHAR;
502: x_enabled := FND_API.G_MISS_CHAR;
503: x_functional_area := FND_API.G_MISS_CHAR;
504: x_pte_sourcesystem_fnarea := FND_API.G_MISS_CHAR;
505: x_pte_source_system := FND_API.G_MISS_CHAR;

Line 502: x_enabled := FND_API.G_MISS_CHAR;

498: x_functional_area_id := FND_API.G_MISS_NUM;
499: x_pte_sourcesystem_fnarea_id := FND_API.G_MISS_NUM;
500: x_pte_source_system_id := FND_API.G_MISS_NUM;
501: x_seeded_flag := FND_API.G_MISS_CHAR;
502: x_enabled := FND_API.G_MISS_CHAR;
503: x_functional_area := FND_API.G_MISS_CHAR;
504: x_pte_sourcesystem_fnarea := FND_API.G_MISS_CHAR;
505: x_pte_source_system := FND_API.G_MISS_CHAR;
506: x_seeded := FND_API.G_MISS_CHAR;

Line 503: x_functional_area := FND_API.G_MISS_CHAR;

499: x_pte_sourcesystem_fnarea_id := FND_API.G_MISS_NUM;
500: x_pte_source_system_id := FND_API.G_MISS_NUM;
501: x_seeded_flag := FND_API.G_MISS_CHAR;
502: x_enabled := FND_API.G_MISS_CHAR;
503: x_functional_area := FND_API.G_MISS_CHAR;
504: x_pte_sourcesystem_fnarea := FND_API.G_MISS_CHAR;
505: x_pte_source_system := FND_API.G_MISS_CHAR;
506: x_seeded := FND_API.G_MISS_CHAR;
507:

Line 504: x_pte_sourcesystem_fnarea := FND_API.G_MISS_CHAR;

500: x_pte_source_system_id := FND_API.G_MISS_NUM;
501: x_seeded_flag := FND_API.G_MISS_CHAR;
502: x_enabled := FND_API.G_MISS_CHAR;
503: x_functional_area := FND_API.G_MISS_CHAR;
504: x_pte_sourcesystem_fnarea := FND_API.G_MISS_CHAR;
505: x_pte_source_system := FND_API.G_MISS_CHAR;
506: x_seeded := FND_API.G_MISS_CHAR;
507:
508: -- Load display out parameters if any

Line 505: x_pte_source_system := FND_API.G_MISS_CHAR;

501: x_seeded_flag := FND_API.G_MISS_CHAR;
502: x_enabled := FND_API.G_MISS_CHAR;
503: x_functional_area := FND_API.G_MISS_CHAR;
504: x_pte_sourcesystem_fnarea := FND_API.G_MISS_CHAR;
505: x_pte_source_system := FND_API.G_MISS_CHAR;
506: x_seeded := FND_API.G_MISS_CHAR;
507:
508: -- Load display out parameters if any
509:

Line 506: x_seeded := FND_API.G_MISS_CHAR;

502: x_enabled := FND_API.G_MISS_CHAR;
503: x_functional_area := FND_API.G_MISS_CHAR;
504: x_pte_sourcesystem_fnarea := FND_API.G_MISS_CHAR;
505: x_pte_source_system := FND_API.G_MISS_CHAR;
506: x_seeded := FND_API.G_MISS_CHAR;
507:
508: -- Load display out parameters if any
509:
510: l_FNA_val_rec := QP_Fna_Util.Get_Values

Line 657: x_return_status := FND_API.G_RET_STS_SUCCESS;

653: );
654:
655: -- Set return status.
656:
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659: -- Get message count and data
660:
661: OE_MSG_PUB.Count_And_Get

Line 669: WHEN FND_API.G_EXC_ERROR THEN

665:
666:
667: EXCEPTION
668:
669: WHEN FND_API.G_EXC_ERROR THEN
670:
671: x_return_status := FND_API.G_RET_STS_ERROR;
672:
673: -- Get message count and data

Line 671: x_return_status := FND_API.G_RET_STS_ERROR;

667: EXCEPTION
668:
669: WHEN FND_API.G_EXC_ERROR THEN
670:
671: x_return_status := FND_API.G_RET_STS_ERROR;
672:
673: -- Get message count and data
674:
675: OE_MSG_PUB.Count_And_Get

Line 680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

676: ( p_count => x_msg_count
677: , p_data => x_msg_data
678: );
679:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681:
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
683:
684: -- Get message count and data

Line 682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

678: );
679:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681:
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
683:
684: -- Get message count and data
685:
686: OE_MSG_PUB.Count_And_Get

Line 693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

689: );
690:
691: WHEN OTHERS THEN
692:
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
694:
695: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
696: THEN
697: OE_MSG_PUB.Add_Exc_Msg

Line 775: IF FND_API.To_Boolean(l_FNA_rec.db_flag) THEN

771: );
772:
773: -- Set Operation.
774:
775: IF FND_API.To_Boolean(l_FNA_rec.db_flag) THEN
776: l_FNA_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
777: ELSE
778: l_FNA_rec.operation := QP_GLOBALS.G_OPR_CREATE;
779: END IF;

Line 790: , p_init_msg_list => FND_API.G_TRUE

786: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
787:
788: QP_Attr_Map_PVT.Process_Attr_Mapping
789: ( p_api_version_number => 1.0
790: , p_init_msg_list => FND_API.G_TRUE
791: , x_return_status => l_return_status
792: , x_msg_count => x_msg_count
793: , x_msg_data => x_msg_data
794: , p_control_rec => l_control_rec

Line 805: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

801: , x_SOU_tbl => l_x_SOU_tbl
802: , x_FNA_tbl => l_x_FNA_tbl
803: );
804:
805: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
808: RAISE FND_API.G_EXC_ERROR;
809: END IF;

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

802: , x_FNA_tbl => l_x_FNA_tbl
803: );
804:
805: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
808: RAISE FND_API.G_EXC_ERROR;
809: END IF;
810:

Line 807: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

803: );
804:
805: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
808: RAISE FND_API.G_EXC_ERROR;
809: END IF;
810:
811:

Line 808: RAISE FND_API.G_EXC_ERROR;

804:
805: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
808: RAISE FND_API.G_EXC_ERROR;
809: END IF;
810:
811:
812: -- Load OUT parameters.

Line 833: x_return_status := FND_API.G_RET_STS_SUCCESS;

829:
830:
831: -- Set return status.
832:
833: x_return_status := FND_API.G_RET_STS_SUCCESS;
834:
835: -- Get message count and data
836:
837: OE_MSG_PUB.Count_And_Get

Line 845: WHEN FND_API.G_EXC_ERROR THEN

841:
842:
843: EXCEPTION
844:
845: WHEN FND_API.G_EXC_ERROR THEN
846:
847: x_return_status := FND_API.G_RET_STS_ERROR;
848:
849: -- Get message count and data

Line 847: x_return_status := FND_API.G_RET_STS_ERROR;

843: EXCEPTION
844:
845: WHEN FND_API.G_EXC_ERROR THEN
846:
847: x_return_status := FND_API.G_RET_STS_ERROR;
848:
849: -- Get message count and data
850:
851: OE_MSG_PUB.Count_And_Get

Line 856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

852: ( p_count => x_msg_count
853: , p_data => x_msg_data
854: );
855:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
857:
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
859:
860: -- Get message count and data

Line 858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

854: );
855:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
857:
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
859:
860: -- Get message count and data
861:
862: OE_MSG_PUB.Count_And_Get

Line 869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

865: );
866:
867: WHEN OTHERS THEN
868:
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
870:
871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
872: THEN
873: OE_MSG_PUB.Add_Exc_Msg

Line 949: , p_init_msg_list => FND_API.G_TRUE

945: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
946:
947: QP_Attr_Map_PVT.Process_Attr_Mapping
948: ( p_api_version_number => 1.0
949: , p_init_msg_list => FND_API.G_TRUE
950: , x_return_status => l_return_status
951: , x_msg_count => x_msg_count
952: , x_msg_data => x_msg_data
953: , p_control_rec => l_control_rec

Line 963: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

959: , x_SOU_tbl => l_x_SOU_tbl
960: , x_FNA_tbl => l_x_FNA_tbl
961: );
962:
963: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
966: RAISE FND_API.G_EXC_ERROR;
967: END IF;

Line 964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

960: , x_FNA_tbl => l_x_FNA_tbl
961: );
962:
963: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
966: RAISE FND_API.G_EXC_ERROR;
967: END IF;
968:

Line 965: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

961: );
962:
963: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
966: RAISE FND_API.G_EXC_ERROR;
967: END IF;
968:
969:

Line 966: RAISE FND_API.G_EXC_ERROR;

962:
963: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
966: RAISE FND_API.G_EXC_ERROR;
967: END IF;
968:
969:
970: -- Clear FNA record cache

Line 976: x_return_status := FND_API.G_RET_STS_SUCCESS;

972: Clear_FNA;
973:
974: -- Set return status.
975:
976: x_return_status := FND_API.G_RET_STS_SUCCESS;
977:
978: -- Get message count and data
979:
980: OE_MSG_PUB.Count_And_Get

Line 988: WHEN FND_API.G_EXC_ERROR THEN

984:
985:
986: EXCEPTION
987:
988: WHEN FND_API.G_EXC_ERROR THEN
989:
990: x_return_status := FND_API.G_RET_STS_ERROR;
991:
992: -- Get message count and data

Line 990: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1008: );
1009:
1010: WHEN OTHERS THEN
1011:
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1013:
1014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1015: THEN
1016: OE_MSG_PUB.Add_Exc_Msg

Line 1075: , p_init_msg_list => FND_API.G_TRUE

1071: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
1072:
1073: QP_Attr_Map_PVT.Process_Attr_Mapping
1074: ( p_api_version_number => 1.0
1075: , p_init_msg_list => FND_API.G_TRUE
1076: , x_return_status => l_return_status
1077: , x_msg_count => x_msg_count
1078: , x_msg_data => x_msg_data
1079: , p_control_rec => l_control_rec

Line 1088: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1084: , x_SOU_tbl => l_x_SOU_tbl
1085: , x_FNA_tbl => l_x_FNA_tbl
1086: );
1087:
1088: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;

Line 1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1085: , x_FNA_tbl => l_x_FNA_tbl
1086: );
1087:
1088: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;
1093:

Line 1090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1086: );
1087:
1088: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;
1093:
1094:

Line 1091: RAISE FND_API.G_EXC_ERROR;

1087:
1088: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;
1093:
1094:
1095: -- Set return status.

Line 1097: x_return_status := FND_API.G_RET_STS_SUCCESS;

1093:
1094:
1095: -- Set return status.
1096:
1097: x_return_status := FND_API.G_RET_STS_SUCCESS;
1098:
1099: -- Get message count and data
1100:
1101: OE_MSG_PUB.Count_And_Get

Line 1109: WHEN FND_API.G_EXC_ERROR THEN

1105:
1106:
1107: EXCEPTION
1108:
1109: WHEN FND_API.G_EXC_ERROR THEN
1110:
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112:
1113: -- Get message count and data

Line 1111: x_return_status := FND_API.G_RET_STS_ERROR;

1107: EXCEPTION
1108:
1109: WHEN FND_API.G_EXC_ERROR THEN
1110:
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112:
1113: -- Get message count and data
1114:
1115: OE_MSG_PUB.Count_And_Get

Line 1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1116: ( p_count => x_msg_count
1117: , p_data => x_msg_data
1118: );
1119:
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121:
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1123:
1124: -- Get message count and data

Line 1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1118: );
1119:
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121:
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1123:
1124: -- Get message count and data
1125:
1126: OE_MSG_PUB.Count_And_Get

Line 1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1129: );
1130:
1131: WHEN OTHERS THEN
1132:
1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1134:
1135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1136: THEN
1137: OE_MSG_PUB.Add_Exc_Msg

Line 1248: , p_init_msg_list => FND_API.G_TRUE

1244: -- Call QP_Attr_Map_PVT.Lock_Attr_Mapping
1245:
1246: QP_Attr_Map_PVT.Lock_Attr_Mapping
1247: ( p_api_version_number => 1.0
1248: , p_init_msg_list => FND_API.G_TRUE
1249: , x_return_status => l_return_status
1250: , x_msg_count => x_msg_count
1251: , x_msg_data => x_msg_data
1252: , p_FNA_tbl => l_FNA_tbl

Line 1261: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1257: , x_SOU_tbl => l_x_SOU_tbl
1258: , x_FNA_tbl => l_x_FNA_tbl
1259: );
1260:
1261: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1262:
1263: -- Set DB flag and write record to cache.
1264:
1265: l_x_FNA_rec.db_flag := FND_API.G_TRUE;

Line 1265: l_x_FNA_rec.db_flag := FND_API.G_TRUE;

1261: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1262:
1263: -- Set DB flag and write record to cache.
1264:
1265: l_x_FNA_rec.db_flag := FND_API.G_TRUE;
1266:
1267: Write_FNA
1268: ( p_FNA_rec => l_x_FNA_rec
1269: , p_db_record => TRUE

Line 1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1294: , 'Lock_Row'
1295: );
1296: END IF;
1297:
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299:
1300: -- Get message count and data
1301:
1302: OE_MSG_PUB.Count_And_Get

Line 1347: g_FNA_rec.db_flag := FND_API.G_TRUE;

1343: g_FNA_rec := QP_Fna_Util.Query_Row
1344: ( p_pte_sourcesystem_fnarea_id => p_pte_sourcesystem_fnarea_id
1345: );
1346:
1347: g_FNA_rec.db_flag := FND_API.G_TRUE;
1348:
1349: -- Load DB record
1350:
1351: g_db_FNA_rec := g_FNA_rec;