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

Line 142: , p_init_msg_list => FND_API.G_TRUE

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

Line 156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

152: , x_SOU_tbl => l_x_SOU_tbl
153: , x_FNA_tbl => l_x_FNA_tbl
154: );
155:
156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;

Line 157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

153: , x_FNA_tbl => l_x_FNA_tbl
154: );
155:
156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;
161:

Line 158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

154: );
155:
156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;
161:
162:

Line 159: RAISE FND_API.G_EXC_ERROR;

155:
156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;
161:
162:
163: -- Unload out tbl

Line 211: l_x_SOU_rec.db_flag := FND_API.G_FALSE;

207:
208: -- Write to cache.
209: -- Set db_flag to False before writing to cache
210:
211: l_x_SOU_rec.db_flag := FND_API.G_FALSE;
212:
213: Write_SOU
214: ( p_SOU_rec => l_x_SOU_rec
215: );

Line 219: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 231: WHEN FND_API.G_EXC_ERROR THEN

227:
228:
229: EXCEPTION
230:
231: WHEN FND_API.G_EXC_ERROR THEN
232:
233: x_return_status := FND_API.G_RET_STS_ERROR;
234:
235: -- Get message count and data

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

251: );
252:
253: WHEN OTHERS THEN
254:
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
256:
257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: OE_MSG_PUB.Add_Exc_Msg

Line 446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

442: , 'Unrecognized attribute'
443: );
444: END IF;
445:
446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
447:
448: END IF;
449:
450: -- Set Operation.

Line 452: IF FND_API.To_Boolean(l_SOU_rec.db_flag) THEN

448: END IF;
449:
450: -- Set Operation.
451:
452: IF FND_API.To_Boolean(l_SOU_rec.db_flag) THEN
453: l_SOU_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
454: ELSE
455: l_SOU_rec.operation := QP_GLOBALS.G_OPR_CREATE;
456: END IF;

Line 467: , p_init_msg_list => FND_API.G_TRUE

463: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
464:
465: QP_Attr_Map_PVT.Process_Attr_Mapping
466: ( p_api_version_number => 1.0
467: , p_init_msg_list => FND_API.G_TRUE
468: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
469: , x_return_status => l_return_status
470: , x_msg_count => x_msg_count
471: , x_msg_data => x_msg_data

Line 468: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

464:
465: QP_Attr_Map_PVT.Process_Attr_Mapping
466: ( p_api_version_number => 1.0
467: , p_init_msg_list => FND_API.G_TRUE
468: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
469: , x_return_status => l_return_status
470: , x_msg_count => x_msg_count
471: , x_msg_data => x_msg_data
472: , p_control_rec => l_control_rec

Line 483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

479: , x_SOU_tbl => l_x_SOU_tbl
480: , x_FNA_tbl => l_x_FNA_tbl
481: );
482:
483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;

Line 484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

480: , x_FNA_tbl => l_x_FNA_tbl
481: );
482:
483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:

Line 485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

481: );
482:
483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:
489:

Line 486: RAISE FND_API.G_EXC_ERROR;

482:
483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:
489:
490: -- Unload out tbl

Line 496: x_attribute1 := FND_API.G_MISS_CHAR;

492: l_x_SOU_rec := l_x_SOU_tbl(1);
493:
494: -- Init OUT parameters to missing.
495:
496: x_attribute1 := FND_API.G_MISS_CHAR;
497: x_attribute10 := FND_API.G_MISS_CHAR;
498: x_attribute11 := FND_API.G_MISS_CHAR;
499: x_attribute12 := FND_API.G_MISS_CHAR;
500: x_attribute13 := FND_API.G_MISS_CHAR;

Line 497: x_attribute10 := FND_API.G_MISS_CHAR;

493:
494: -- Init OUT parameters to missing.
495:
496: x_attribute1 := FND_API.G_MISS_CHAR;
497: x_attribute10 := FND_API.G_MISS_CHAR;
498: x_attribute11 := FND_API.G_MISS_CHAR;
499: x_attribute12 := FND_API.G_MISS_CHAR;
500: x_attribute13 := FND_API.G_MISS_CHAR;
501: x_attribute14 := FND_API.G_MISS_CHAR;

Line 498: x_attribute11 := FND_API.G_MISS_CHAR;

494: -- Init OUT parameters to missing.
495:
496: x_attribute1 := FND_API.G_MISS_CHAR;
497: x_attribute10 := FND_API.G_MISS_CHAR;
498: x_attribute11 := FND_API.G_MISS_CHAR;
499: x_attribute12 := FND_API.G_MISS_CHAR;
500: x_attribute13 := FND_API.G_MISS_CHAR;
501: x_attribute14 := FND_API.G_MISS_CHAR;
502: x_attribute15 := FND_API.G_MISS_CHAR;

Line 499: x_attribute12 := FND_API.G_MISS_CHAR;

495:
496: x_attribute1 := FND_API.G_MISS_CHAR;
497: x_attribute10 := FND_API.G_MISS_CHAR;
498: x_attribute11 := FND_API.G_MISS_CHAR;
499: x_attribute12 := FND_API.G_MISS_CHAR;
500: x_attribute13 := FND_API.G_MISS_CHAR;
501: x_attribute14 := FND_API.G_MISS_CHAR;
502: x_attribute15 := FND_API.G_MISS_CHAR;
503: x_attribute2 := FND_API.G_MISS_CHAR;

Line 500: x_attribute13 := FND_API.G_MISS_CHAR;

496: x_attribute1 := FND_API.G_MISS_CHAR;
497: x_attribute10 := FND_API.G_MISS_CHAR;
498: x_attribute11 := FND_API.G_MISS_CHAR;
499: x_attribute12 := FND_API.G_MISS_CHAR;
500: x_attribute13 := FND_API.G_MISS_CHAR;
501: x_attribute14 := FND_API.G_MISS_CHAR;
502: x_attribute15 := FND_API.G_MISS_CHAR;
503: x_attribute2 := FND_API.G_MISS_CHAR;
504: x_attribute3 := FND_API.G_MISS_CHAR;

Line 501: x_attribute14 := FND_API.G_MISS_CHAR;

497: x_attribute10 := FND_API.G_MISS_CHAR;
498: x_attribute11 := FND_API.G_MISS_CHAR;
499: x_attribute12 := FND_API.G_MISS_CHAR;
500: x_attribute13 := FND_API.G_MISS_CHAR;
501: x_attribute14 := FND_API.G_MISS_CHAR;
502: x_attribute15 := FND_API.G_MISS_CHAR;
503: x_attribute2 := FND_API.G_MISS_CHAR;
504: x_attribute3 := FND_API.G_MISS_CHAR;
505: x_attribute4 := FND_API.G_MISS_CHAR;

Line 502: x_attribute15 := FND_API.G_MISS_CHAR;

498: x_attribute11 := FND_API.G_MISS_CHAR;
499: x_attribute12 := FND_API.G_MISS_CHAR;
500: x_attribute13 := FND_API.G_MISS_CHAR;
501: x_attribute14 := FND_API.G_MISS_CHAR;
502: x_attribute15 := FND_API.G_MISS_CHAR;
503: x_attribute2 := FND_API.G_MISS_CHAR;
504: x_attribute3 := FND_API.G_MISS_CHAR;
505: x_attribute4 := FND_API.G_MISS_CHAR;
506: x_attribute5 := FND_API.G_MISS_CHAR;

Line 503: x_attribute2 := FND_API.G_MISS_CHAR;

499: x_attribute12 := FND_API.G_MISS_CHAR;
500: x_attribute13 := FND_API.G_MISS_CHAR;
501: x_attribute14 := FND_API.G_MISS_CHAR;
502: x_attribute15 := FND_API.G_MISS_CHAR;
503: x_attribute2 := FND_API.G_MISS_CHAR;
504: x_attribute3 := FND_API.G_MISS_CHAR;
505: x_attribute4 := FND_API.G_MISS_CHAR;
506: x_attribute5 := FND_API.G_MISS_CHAR;
507: x_attribute6 := FND_API.G_MISS_CHAR;

Line 504: x_attribute3 := FND_API.G_MISS_CHAR;

500: x_attribute13 := FND_API.G_MISS_CHAR;
501: x_attribute14 := FND_API.G_MISS_CHAR;
502: x_attribute15 := FND_API.G_MISS_CHAR;
503: x_attribute2 := FND_API.G_MISS_CHAR;
504: x_attribute3 := FND_API.G_MISS_CHAR;
505: x_attribute4 := FND_API.G_MISS_CHAR;
506: x_attribute5 := FND_API.G_MISS_CHAR;
507: x_attribute6 := FND_API.G_MISS_CHAR;
508: x_attribute7 := FND_API.G_MISS_CHAR;

Line 505: x_attribute4 := FND_API.G_MISS_CHAR;

501: x_attribute14 := FND_API.G_MISS_CHAR;
502: x_attribute15 := FND_API.G_MISS_CHAR;
503: x_attribute2 := FND_API.G_MISS_CHAR;
504: x_attribute3 := FND_API.G_MISS_CHAR;
505: x_attribute4 := FND_API.G_MISS_CHAR;
506: x_attribute5 := FND_API.G_MISS_CHAR;
507: x_attribute6 := FND_API.G_MISS_CHAR;
508: x_attribute7 := FND_API.G_MISS_CHAR;
509: x_attribute8 := FND_API.G_MISS_CHAR;

Line 506: x_attribute5 := FND_API.G_MISS_CHAR;

502: x_attribute15 := FND_API.G_MISS_CHAR;
503: x_attribute2 := FND_API.G_MISS_CHAR;
504: x_attribute3 := FND_API.G_MISS_CHAR;
505: x_attribute4 := FND_API.G_MISS_CHAR;
506: x_attribute5 := FND_API.G_MISS_CHAR;
507: x_attribute6 := FND_API.G_MISS_CHAR;
508: x_attribute7 := FND_API.G_MISS_CHAR;
509: x_attribute8 := FND_API.G_MISS_CHAR;
510: x_attribute9 := FND_API.G_MISS_CHAR;

Line 507: x_attribute6 := FND_API.G_MISS_CHAR;

503: x_attribute2 := FND_API.G_MISS_CHAR;
504: x_attribute3 := FND_API.G_MISS_CHAR;
505: x_attribute4 := FND_API.G_MISS_CHAR;
506: x_attribute5 := FND_API.G_MISS_CHAR;
507: x_attribute6 := FND_API.G_MISS_CHAR;
508: x_attribute7 := FND_API.G_MISS_CHAR;
509: x_attribute8 := FND_API.G_MISS_CHAR;
510: x_attribute9 := FND_API.G_MISS_CHAR;
511: x_attribute_sourcing_id := FND_API.G_MISS_NUM;

Line 508: x_attribute7 := FND_API.G_MISS_CHAR;

504: x_attribute3 := FND_API.G_MISS_CHAR;
505: x_attribute4 := FND_API.G_MISS_CHAR;
506: x_attribute5 := FND_API.G_MISS_CHAR;
507: x_attribute6 := FND_API.G_MISS_CHAR;
508: x_attribute7 := FND_API.G_MISS_CHAR;
509: x_attribute8 := FND_API.G_MISS_CHAR;
510: x_attribute9 := FND_API.G_MISS_CHAR;
511: x_attribute_sourcing_id := FND_API.G_MISS_NUM;
512: x_attribute_sourcing_level := FND_API.G_MISS_CHAR;

Line 509: x_attribute8 := FND_API.G_MISS_CHAR;

505: x_attribute4 := FND_API.G_MISS_CHAR;
506: x_attribute5 := FND_API.G_MISS_CHAR;
507: x_attribute6 := FND_API.G_MISS_CHAR;
508: x_attribute7 := FND_API.G_MISS_CHAR;
509: x_attribute8 := FND_API.G_MISS_CHAR;
510: x_attribute9 := FND_API.G_MISS_CHAR;
511: x_attribute_sourcing_id := FND_API.G_MISS_NUM;
512: x_attribute_sourcing_level := FND_API.G_MISS_CHAR;
513: x_application_id := FND_API.G_MISS_NUM;

Line 510: x_attribute9 := FND_API.G_MISS_CHAR;

506: x_attribute5 := FND_API.G_MISS_CHAR;
507: x_attribute6 := FND_API.G_MISS_CHAR;
508: x_attribute7 := FND_API.G_MISS_CHAR;
509: x_attribute8 := FND_API.G_MISS_CHAR;
510: x_attribute9 := FND_API.G_MISS_CHAR;
511: x_attribute_sourcing_id := FND_API.G_MISS_NUM;
512: x_attribute_sourcing_level := FND_API.G_MISS_CHAR;
513: x_application_id := FND_API.G_MISS_NUM;
514: x_context := FND_API.G_MISS_CHAR;

Line 511: x_attribute_sourcing_id := FND_API.G_MISS_NUM;

507: x_attribute6 := FND_API.G_MISS_CHAR;
508: x_attribute7 := FND_API.G_MISS_CHAR;
509: x_attribute8 := FND_API.G_MISS_CHAR;
510: x_attribute9 := FND_API.G_MISS_CHAR;
511: x_attribute_sourcing_id := FND_API.G_MISS_NUM;
512: x_attribute_sourcing_level := FND_API.G_MISS_CHAR;
513: x_application_id := FND_API.G_MISS_NUM;
514: x_context := FND_API.G_MISS_CHAR;
515: x_enabled_flag := FND_API.G_MISS_CHAR;

Line 512: x_attribute_sourcing_level := FND_API.G_MISS_CHAR;

508: x_attribute7 := FND_API.G_MISS_CHAR;
509: x_attribute8 := FND_API.G_MISS_CHAR;
510: x_attribute9 := FND_API.G_MISS_CHAR;
511: x_attribute_sourcing_id := FND_API.G_MISS_NUM;
512: x_attribute_sourcing_level := FND_API.G_MISS_CHAR;
513: x_application_id := FND_API.G_MISS_NUM;
514: x_context := FND_API.G_MISS_CHAR;
515: x_enabled_flag := FND_API.G_MISS_CHAR;
516: x_request_type_code := FND_API.G_MISS_CHAR;

Line 513: x_application_id := FND_API.G_MISS_NUM;

509: x_attribute8 := FND_API.G_MISS_CHAR;
510: x_attribute9 := FND_API.G_MISS_CHAR;
511: x_attribute_sourcing_id := FND_API.G_MISS_NUM;
512: x_attribute_sourcing_level := FND_API.G_MISS_CHAR;
513: x_application_id := FND_API.G_MISS_NUM;
514: x_context := FND_API.G_MISS_CHAR;
515: x_enabled_flag := FND_API.G_MISS_CHAR;
516: x_request_type_code := FND_API.G_MISS_CHAR;
517: x_seeded_flag := FND_API.G_MISS_CHAR;

Line 514: x_context := FND_API.G_MISS_CHAR;

510: x_attribute9 := FND_API.G_MISS_CHAR;
511: x_attribute_sourcing_id := FND_API.G_MISS_NUM;
512: x_attribute_sourcing_level := FND_API.G_MISS_CHAR;
513: x_application_id := FND_API.G_MISS_NUM;
514: x_context := FND_API.G_MISS_CHAR;
515: x_enabled_flag := FND_API.G_MISS_CHAR;
516: x_request_type_code := FND_API.G_MISS_CHAR;
517: x_seeded_flag := FND_API.G_MISS_CHAR;
518: x_seeded_sourcing_type := FND_API.G_MISS_CHAR;

Line 515: x_enabled_flag := FND_API.G_MISS_CHAR;

511: x_attribute_sourcing_id := FND_API.G_MISS_NUM;
512: x_attribute_sourcing_level := FND_API.G_MISS_CHAR;
513: x_application_id := FND_API.G_MISS_NUM;
514: x_context := FND_API.G_MISS_CHAR;
515: x_enabled_flag := FND_API.G_MISS_CHAR;
516: x_request_type_code := FND_API.G_MISS_CHAR;
517: x_seeded_flag := FND_API.G_MISS_CHAR;
518: x_seeded_sourcing_type := FND_API.G_MISS_CHAR;
519: x_seeded_value_string := FND_API.G_MISS_CHAR;

Line 516: x_request_type_code := FND_API.G_MISS_CHAR;

512: x_attribute_sourcing_level := FND_API.G_MISS_CHAR;
513: x_application_id := FND_API.G_MISS_NUM;
514: x_context := FND_API.G_MISS_CHAR;
515: x_enabled_flag := FND_API.G_MISS_CHAR;
516: x_request_type_code := FND_API.G_MISS_CHAR;
517: x_seeded_flag := FND_API.G_MISS_CHAR;
518: x_seeded_sourcing_type := FND_API.G_MISS_CHAR;
519: x_seeded_value_string := FND_API.G_MISS_CHAR;
520: x_segment_id := FND_API.G_MISS_NUM;

Line 517: x_seeded_flag := FND_API.G_MISS_CHAR;

513: x_application_id := FND_API.G_MISS_NUM;
514: x_context := FND_API.G_MISS_CHAR;
515: x_enabled_flag := FND_API.G_MISS_CHAR;
516: x_request_type_code := FND_API.G_MISS_CHAR;
517: x_seeded_flag := FND_API.G_MISS_CHAR;
518: x_seeded_sourcing_type := FND_API.G_MISS_CHAR;
519: x_seeded_value_string := FND_API.G_MISS_CHAR;
520: x_segment_id := FND_API.G_MISS_NUM;
521: x_user_sourcing_type := FND_API.G_MISS_CHAR;

Line 518: x_seeded_sourcing_type := FND_API.G_MISS_CHAR;

514: x_context := FND_API.G_MISS_CHAR;
515: x_enabled_flag := FND_API.G_MISS_CHAR;
516: x_request_type_code := FND_API.G_MISS_CHAR;
517: x_seeded_flag := FND_API.G_MISS_CHAR;
518: x_seeded_sourcing_type := FND_API.G_MISS_CHAR;
519: x_seeded_value_string := FND_API.G_MISS_CHAR;
520: x_segment_id := FND_API.G_MISS_NUM;
521: x_user_sourcing_type := FND_API.G_MISS_CHAR;
522: x_user_value_string := FND_API.G_MISS_CHAR;

Line 519: x_seeded_value_string := FND_API.G_MISS_CHAR;

515: x_enabled_flag := FND_API.G_MISS_CHAR;
516: x_request_type_code := FND_API.G_MISS_CHAR;
517: x_seeded_flag := FND_API.G_MISS_CHAR;
518: x_seeded_sourcing_type := FND_API.G_MISS_CHAR;
519: x_seeded_value_string := FND_API.G_MISS_CHAR;
520: x_segment_id := FND_API.G_MISS_NUM;
521: x_user_sourcing_type := FND_API.G_MISS_CHAR;
522: x_user_value_string := FND_API.G_MISS_CHAR;
523: x_attribute_sourcing := FND_API.G_MISS_CHAR;

Line 520: x_segment_id := FND_API.G_MISS_NUM;

516: x_request_type_code := FND_API.G_MISS_CHAR;
517: x_seeded_flag := FND_API.G_MISS_CHAR;
518: x_seeded_sourcing_type := FND_API.G_MISS_CHAR;
519: x_seeded_value_string := FND_API.G_MISS_CHAR;
520: x_segment_id := FND_API.G_MISS_NUM;
521: x_user_sourcing_type := FND_API.G_MISS_CHAR;
522: x_user_value_string := FND_API.G_MISS_CHAR;
523: x_attribute_sourcing := FND_API.G_MISS_CHAR;
524: x_enabled := FND_API.G_MISS_CHAR;

Line 521: x_user_sourcing_type := FND_API.G_MISS_CHAR;

517: x_seeded_flag := FND_API.G_MISS_CHAR;
518: x_seeded_sourcing_type := FND_API.G_MISS_CHAR;
519: x_seeded_value_string := FND_API.G_MISS_CHAR;
520: x_segment_id := FND_API.G_MISS_NUM;
521: x_user_sourcing_type := FND_API.G_MISS_CHAR;
522: x_user_value_string := FND_API.G_MISS_CHAR;
523: x_attribute_sourcing := FND_API.G_MISS_CHAR;
524: x_enabled := FND_API.G_MISS_CHAR;
525: x_request_type := FND_API.G_MISS_CHAR;

Line 522: x_user_value_string := FND_API.G_MISS_CHAR;

518: x_seeded_sourcing_type := FND_API.G_MISS_CHAR;
519: x_seeded_value_string := FND_API.G_MISS_CHAR;
520: x_segment_id := FND_API.G_MISS_NUM;
521: x_user_sourcing_type := FND_API.G_MISS_CHAR;
522: x_user_value_string := FND_API.G_MISS_CHAR;
523: x_attribute_sourcing := FND_API.G_MISS_CHAR;
524: x_enabled := FND_API.G_MISS_CHAR;
525: x_request_type := FND_API.G_MISS_CHAR;
526: x_seeded := FND_API.G_MISS_CHAR;

Line 523: x_attribute_sourcing := FND_API.G_MISS_CHAR;

519: x_seeded_value_string := FND_API.G_MISS_CHAR;
520: x_segment_id := FND_API.G_MISS_NUM;
521: x_user_sourcing_type := FND_API.G_MISS_CHAR;
522: x_user_value_string := FND_API.G_MISS_CHAR;
523: x_attribute_sourcing := FND_API.G_MISS_CHAR;
524: x_enabled := FND_API.G_MISS_CHAR;
525: x_request_type := FND_API.G_MISS_CHAR;
526: x_seeded := FND_API.G_MISS_CHAR;
527: x_segment := FND_API.G_MISS_CHAR;

Line 524: x_enabled := FND_API.G_MISS_CHAR;

520: x_segment_id := FND_API.G_MISS_NUM;
521: x_user_sourcing_type := FND_API.G_MISS_CHAR;
522: x_user_value_string := FND_API.G_MISS_CHAR;
523: x_attribute_sourcing := FND_API.G_MISS_CHAR;
524: x_enabled := FND_API.G_MISS_CHAR;
525: x_request_type := FND_API.G_MISS_CHAR;
526: x_seeded := FND_API.G_MISS_CHAR;
527: x_segment := FND_API.G_MISS_CHAR;
528:

Line 525: x_request_type := FND_API.G_MISS_CHAR;

521: x_user_sourcing_type := FND_API.G_MISS_CHAR;
522: x_user_value_string := FND_API.G_MISS_CHAR;
523: x_attribute_sourcing := FND_API.G_MISS_CHAR;
524: x_enabled := FND_API.G_MISS_CHAR;
525: x_request_type := FND_API.G_MISS_CHAR;
526: x_seeded := FND_API.G_MISS_CHAR;
527: x_segment := FND_API.G_MISS_CHAR;
528:
529: -- Load display out parameters if any

Line 526: x_seeded := FND_API.G_MISS_CHAR;

522: x_user_value_string := FND_API.G_MISS_CHAR;
523: x_attribute_sourcing := FND_API.G_MISS_CHAR;
524: x_enabled := FND_API.G_MISS_CHAR;
525: x_request_type := FND_API.G_MISS_CHAR;
526: x_seeded := FND_API.G_MISS_CHAR;
527: x_segment := FND_API.G_MISS_CHAR;
528:
529: -- Load display out parameters if any
530:

Line 527: x_segment := FND_API.G_MISS_CHAR;

523: x_attribute_sourcing := FND_API.G_MISS_CHAR;
524: x_enabled := FND_API.G_MISS_CHAR;
525: x_request_type := FND_API.G_MISS_CHAR;
526: x_seeded := FND_API.G_MISS_CHAR;
527: x_segment := FND_API.G_MISS_CHAR;
528:
529: -- Load display out parameters if any
530:
531: l_SOU_val_rec := QP_Sou_Util.Get_Values

Line 714: x_return_status := FND_API.G_RET_STS_SUCCESS;

710: );
711:
712: -- Set return status.
713:
714: x_return_status := FND_API.G_RET_STS_SUCCESS;
715:
716: -- Get message count and data
717:
718: OE_MSG_PUB.Count_And_Get

Line 726: WHEN FND_API.G_EXC_ERROR THEN

722:
723:
724: EXCEPTION
725:
726: WHEN FND_API.G_EXC_ERROR THEN
727:
728: x_return_status := FND_API.G_RET_STS_ERROR;
729:
730: -- Get message count and data

Line 728: x_return_status := FND_API.G_RET_STS_ERROR;

724: EXCEPTION
725:
726: WHEN FND_API.G_EXC_ERROR THEN
727:
728: x_return_status := FND_API.G_RET_STS_ERROR;
729:
730: -- Get message count and data
731:
732: OE_MSG_PUB.Count_And_Get

Line 737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

733: ( p_count => x_msg_count
734: , p_data => x_msg_data
735: );
736:
737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
738:
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740:
741: -- Get message count and data

Line 739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

735: );
736:
737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
738:
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740:
741: -- Get message count and data
742:
743: OE_MSG_PUB.Count_And_Get

Line 750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

746: );
747:
748: WHEN OTHERS THEN
749:
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
751:
752: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
753: THEN
754: OE_MSG_PUB.Add_Exc_Msg

Line 832: IF FND_API.To_Boolean(l_SOU_rec.db_flag) THEN

828: );
829:
830: -- Set Operation.
831:
832: IF FND_API.To_Boolean(l_SOU_rec.db_flag) THEN
833: l_SOU_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
834: ELSE
835: l_SOU_rec.operation := QP_GLOBALS.G_OPR_CREATE;
836: END IF;

Line 847: , p_init_msg_list => FND_API.G_TRUE

843: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
844:
845: QP_Attr_Map_PVT.Process_Attr_Mapping
846: ( p_api_version_number => 1.0
847: , p_init_msg_list => FND_API.G_TRUE
848: , x_return_status => l_return_status
849: , x_msg_count => x_msg_count
850: , x_msg_data => x_msg_data
851: , p_control_rec => l_control_rec

Line 862: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

858: , x_SOU_tbl => l_x_SOU_tbl
859: , x_FNA_tbl => l_x_FNA_tbl
860: );
861:
862: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;

Line 863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

859: , x_FNA_tbl => l_x_FNA_tbl
860: );
861:
862: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;
867:

Line 864: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

860: );
861:
862: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;
867:
868:

Line 865: RAISE FND_API.G_EXC_ERROR;

861:
862: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;
867:
868:
869: -- Load OUT parameters.

Line 890: x_return_status := FND_API.G_RET_STS_SUCCESS;

886:
887:
888: -- Set return status.
889:
890: x_return_status := FND_API.G_RET_STS_SUCCESS;
891:
892: -- Get message count and data
893:
894: OE_MSG_PUB.Count_And_Get

Line 902: WHEN FND_API.G_EXC_ERROR THEN

898:
899:
900: EXCEPTION
901:
902: WHEN FND_API.G_EXC_ERROR THEN
903:
904: x_return_status := FND_API.G_RET_STS_ERROR;
905:
906: -- Get message count and data

Line 904: x_return_status := FND_API.G_RET_STS_ERROR;

900: EXCEPTION
901:
902: WHEN FND_API.G_EXC_ERROR THEN
903:
904: x_return_status := FND_API.G_RET_STS_ERROR;
905:
906: -- Get message count and data
907:
908: OE_MSG_PUB.Count_And_Get

Line 913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

909: ( p_count => x_msg_count
910: , p_data => x_msg_data
911: );
912:
913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
914:
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
916:
917: -- Get message count and data

Line 915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

911: );
912:
913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
914:
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
916:
917: -- Get message count and data
918:
919: OE_MSG_PUB.Count_And_Get

Line 926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

922: );
923:
924: WHEN OTHERS THEN
925:
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
927:
928: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: OE_MSG_PUB.Add_Exc_Msg

Line 1006: , p_init_msg_list => FND_API.G_TRUE

1002: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
1003:
1004: QP_Attr_Map_PVT.Process_Attr_Mapping
1005: ( p_api_version_number => 1.0
1006: , p_init_msg_list => FND_API.G_TRUE
1007: , x_return_status => l_return_status
1008: , x_msg_count => x_msg_count
1009: , x_msg_data => x_msg_data
1010: , p_control_rec => l_control_rec

Line 1020: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1016: , x_SOU_tbl => l_x_SOU_tbl
1017: , x_FNA_tbl => l_x_FNA_tbl
1018: );
1019:
1020: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;

Line 1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1017: , x_FNA_tbl => l_x_FNA_tbl
1018: );
1019:
1020: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;
1025:

Line 1022: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1018: );
1019:
1020: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;
1025:
1026:

Line 1023: RAISE FND_API.G_EXC_ERROR;

1019:
1020: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;
1025:
1026:
1027: -- Clear SOU record cache

Line 1033: x_return_status := FND_API.G_RET_STS_SUCCESS;

1029: Clear_SOU;
1030:
1031: -- Set return status.
1032:
1033: x_return_status := FND_API.G_RET_STS_SUCCESS;
1034:
1035: -- Get message count and data
1036:
1037: OE_MSG_PUB.Count_And_Get

Line 1045: WHEN FND_API.G_EXC_ERROR THEN

1041:
1042:
1043: EXCEPTION
1044:
1045: WHEN FND_API.G_EXC_ERROR THEN
1046:
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048:
1049: -- Get message count and data

Line 1047: x_return_status := FND_API.G_RET_STS_ERROR;

1043: EXCEPTION
1044:
1045: WHEN FND_API.G_EXC_ERROR THEN
1046:
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048:
1049: -- Get message count and data
1050:
1051: OE_MSG_PUB.Count_And_Get

Line 1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1052: ( p_count => x_msg_count
1053: , p_data => x_msg_data
1054: );
1055:
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057:
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059:
1060: -- Get message count and data

Line 1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1054: );
1055:
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057:
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059:
1060: -- Get message count and data
1061:
1062: OE_MSG_PUB.Count_And_Get

Line 1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1065: );
1066:
1067: WHEN OTHERS THEN
1068:
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1070:
1071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1072: THEN
1073: OE_MSG_PUB.Add_Exc_Msg

Line 1132: , p_init_msg_list => FND_API.G_TRUE

1128: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
1129:
1130: QP_Attr_Map_PVT.Process_Attr_Mapping
1131: ( p_api_version_number => 1.0
1132: , p_init_msg_list => FND_API.G_TRUE
1133: , x_return_status => l_return_status
1134: , x_msg_count => x_msg_count
1135: , x_msg_data => x_msg_data
1136: , p_control_rec => l_control_rec

Line 1145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1141: , x_SOU_tbl => l_x_SOU_tbl
1142: , x_FNA_tbl => l_x_FNA_tbl
1143: );
1144:
1145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;

Line 1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1142: , x_FNA_tbl => l_x_FNA_tbl
1143: );
1144:
1145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150:

Line 1147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1143: );
1144:
1145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150:
1151:

Line 1148: RAISE FND_API.G_EXC_ERROR;

1144:
1145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150:
1151:
1152: -- Set return status.

Line 1154: x_return_status := FND_API.G_RET_STS_SUCCESS;

1150:
1151:
1152: -- Set return status.
1153:
1154: x_return_status := FND_API.G_RET_STS_SUCCESS;
1155:
1156: -- Get message count and data
1157:
1158: OE_MSG_PUB.Count_And_Get

Line 1166: WHEN FND_API.G_EXC_ERROR THEN

1162:
1163:
1164: EXCEPTION
1165:
1166: WHEN FND_API.G_EXC_ERROR THEN
1167:
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169:
1170: -- Get message count and data

Line 1168: x_return_status := FND_API.G_RET_STS_ERROR;

1164: EXCEPTION
1165:
1166: WHEN FND_API.G_EXC_ERROR THEN
1167:
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169:
1170: -- Get message count and data
1171:
1172: OE_MSG_PUB.Count_And_Get

Line 1177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1173: ( p_count => x_msg_count
1174: , p_data => x_msg_data
1175: );
1176:
1177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1178:
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1180:
1181: -- Get message count and data

Line 1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1175: );
1176:
1177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1178:
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1180:
1181: -- Get message count and data
1182:
1183: OE_MSG_PUB.Count_And_Get

Line 1190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1186: );
1187:
1188: WHEN OTHERS THEN
1189:
1190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1191:
1192: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1193: THEN
1194: OE_MSG_PUB.Add_Exc_Msg

Line 1315: , p_init_msg_list => FND_API.G_TRUE

1311: -- Call QP_Attr_Map_PVT.Lock_Attr_Mapping
1312:
1313: QP_Attr_Map_PVT.Lock_Attr_Mapping
1314: ( p_api_version_number => 1.0
1315: , p_init_msg_list => FND_API.G_TRUE
1316: , x_return_status => l_return_status
1317: , x_msg_count => x_msg_count
1318: , x_msg_data => x_msg_data
1319: , p_SOU_tbl => l_SOU_tbl

Line 1328: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1324: , x_SOU_tbl => l_x_SOU_tbl
1325: , x_FNA_tbl => l_x_FNA_tbl
1326: );
1327:
1328: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1329:
1330: -- Set DB flag and write record to cache.
1331:
1332: l_x_SOU_rec.db_flag := FND_API.G_TRUE;

Line 1332: l_x_SOU_rec.db_flag := FND_API.G_TRUE;

1328: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1329:
1330: -- Set DB flag and write record to cache.
1331:
1332: l_x_SOU_rec.db_flag := FND_API.G_TRUE;
1333:
1334: Write_SOU
1335: ( p_SOU_rec => l_x_SOU_rec
1336: , p_db_record => TRUE

Line 1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1361: , 'Lock_Row'
1362: );
1363: END IF;
1364:
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1366:
1367: -- Get message count and data
1368:
1369: OE_MSG_PUB.Count_And_Get

Line 1414: g_SOU_rec.db_flag := FND_API.G_TRUE;

1410: g_SOU_rec := QP_Sou_Util.Query_Row
1411: ( p_attribute_sourcing_id => p_attribute_sourcing_id
1412: );
1413:
1414: g_SOU_rec.db_flag := FND_API.G_TRUE;
1415:
1416: -- Load DB record
1417:
1418: g_db_SOU_rec := g_SOU_rec;