DBA Data[Home] [Help]

APPS.QP_QP_FORM_RQT dependencies on FND_API

Line 138: , p_init_msg_list => FND_API.G_TRUE

134: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
135:
136: QP_Attr_Map_PVT.Process_Attr_Mapping
137: ( p_api_version_number => 1.0
138: , p_init_msg_list => FND_API.G_TRUE
139: , x_return_status => l_return_status
140: , x_msg_count => x_msg_count
141: , x_msg_data => x_msg_data
142: , p_control_rec => l_control_rec

Line 152: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

148: , x_SOU_tbl => l_x_SOU_tbl
149: , x_FNA_tbl => l_x_FNA_tbl
150: );
151:
152: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: , x_FNA_tbl => l_x_FNA_tbl
150: );
151:
152: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;
157:

Line 154: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

150: );
151:
152: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;
157:
158:

Line 155: RAISE FND_API.G_EXC_ERROR;

151:
152: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;
157:
158:
159: -- Unload out tbl

Line 204: l_x_RQT_rec.db_flag := FND_API.G_FALSE;

200:
201: -- Write to cache.
202: -- Set db_flag to False before writing to cache
203:
204: l_x_RQT_rec.db_flag := FND_API.G_FALSE;
205:
206: Write_RQT
207: ( p_RQT_rec => l_x_RQT_rec
208: );

Line 212: x_return_status := FND_API.G_RET_STS_SUCCESS;

208: );
209:
210: -- Set return status.
211:
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213:
214: -- Get message count and data
215:
216: OE_MSG_PUB.Count_And_Get

Line 224: WHEN FND_API.G_EXC_ERROR THEN

220:
221:
222: EXCEPTION
223:
224: WHEN FND_API.G_EXC_ERROR THEN
225:
226: x_return_status := FND_API.G_RET_STS_ERROR;
227:
228: -- Get message count and data

Line 226: x_return_status := FND_API.G_RET_STS_ERROR;

222: EXCEPTION
223:
224: WHEN FND_API.G_EXC_ERROR THEN
225:
226: x_return_status := FND_API.G_RET_STS_ERROR;
227:
228: -- Get message count and data
229:
230: OE_MSG_PUB.Count_And_Get

Line 235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

231: ( p_count => x_msg_count
232: , p_data => x_msg_data
233: );
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236:
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238:
239: -- Get message count and data

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

233: );
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236:
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238:
239: -- Get message count and data
240:
241: OE_MSG_PUB.Count_And_Get

Line 248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

244: );
245:
246: WHEN OTHERS THEN
247:
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
249:
250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
251: THEN
252: OE_MSG_PUB.Add_Exc_Msg

Line 434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

430: , 'Unrecognized attribute'
431: );
432: END IF;
433:
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435:
436: END IF;
437:
438: -- Set Operation.

Line 440: IF FND_API.To_Boolean(l_RQT_rec.db_flag) THEN

436: END IF;
437:
438: -- Set Operation.
439:
440: IF FND_API.To_Boolean(l_RQT_rec.db_flag) THEN
441: l_RQT_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
442: ELSE
443: l_RQT_rec.operation := QP_GLOBALS.G_OPR_CREATE;
444: END IF;

Line 455: , p_init_msg_list => FND_API.G_TRUE

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

Line 456: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

Line 471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

469: );
470:
471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
474: RAISE FND_API.G_EXC_ERROR;
475: END IF;
476:
477:

Line 474: RAISE FND_API.G_EXC_ERROR;

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

Line 484: x_attribute1 := FND_API.G_MISS_CHAR;

480: l_x_RQT_rec := l_x_RQT_tbl(1);
481:
482: -- Init OUT parameters to missing.
483:
484: x_attribute1 := FND_API.G_MISS_CHAR;
485: x_attribute10 := FND_API.G_MISS_CHAR;
486: x_attribute11 := FND_API.G_MISS_CHAR;
487: x_attribute12 := FND_API.G_MISS_CHAR;
488: x_attribute13 := FND_API.G_MISS_CHAR;

Line 485: x_attribute10 := FND_API.G_MISS_CHAR;

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

Line 486: x_attribute11 := FND_API.G_MISS_CHAR;

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

Line 487: x_attribute12 := FND_API.G_MISS_CHAR;

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

Line 488: x_attribute13 := FND_API.G_MISS_CHAR;

484: x_attribute1 := FND_API.G_MISS_CHAR;
485: x_attribute10 := FND_API.G_MISS_CHAR;
486: x_attribute11 := FND_API.G_MISS_CHAR;
487: x_attribute12 := FND_API.G_MISS_CHAR;
488: x_attribute13 := FND_API.G_MISS_CHAR;
489: x_attribute14 := FND_API.G_MISS_CHAR;
490: x_attribute15 := FND_API.G_MISS_CHAR;
491: x_attribute2 := FND_API.G_MISS_CHAR;
492: x_attribute3 := FND_API.G_MISS_CHAR;

Line 489: x_attribute14 := FND_API.G_MISS_CHAR;

485: x_attribute10 := FND_API.G_MISS_CHAR;
486: x_attribute11 := FND_API.G_MISS_CHAR;
487: x_attribute12 := FND_API.G_MISS_CHAR;
488: x_attribute13 := FND_API.G_MISS_CHAR;
489: x_attribute14 := FND_API.G_MISS_CHAR;
490: x_attribute15 := FND_API.G_MISS_CHAR;
491: x_attribute2 := FND_API.G_MISS_CHAR;
492: x_attribute3 := FND_API.G_MISS_CHAR;
493: x_attribute4 := FND_API.G_MISS_CHAR;

Line 490: x_attribute15 := FND_API.G_MISS_CHAR;

486: x_attribute11 := FND_API.G_MISS_CHAR;
487: x_attribute12 := FND_API.G_MISS_CHAR;
488: x_attribute13 := FND_API.G_MISS_CHAR;
489: x_attribute14 := FND_API.G_MISS_CHAR;
490: x_attribute15 := FND_API.G_MISS_CHAR;
491: x_attribute2 := FND_API.G_MISS_CHAR;
492: x_attribute3 := FND_API.G_MISS_CHAR;
493: x_attribute4 := FND_API.G_MISS_CHAR;
494: x_attribute5 := FND_API.G_MISS_CHAR;

Line 491: x_attribute2 := FND_API.G_MISS_CHAR;

487: x_attribute12 := FND_API.G_MISS_CHAR;
488: x_attribute13 := FND_API.G_MISS_CHAR;
489: x_attribute14 := FND_API.G_MISS_CHAR;
490: x_attribute15 := FND_API.G_MISS_CHAR;
491: x_attribute2 := FND_API.G_MISS_CHAR;
492: x_attribute3 := FND_API.G_MISS_CHAR;
493: x_attribute4 := FND_API.G_MISS_CHAR;
494: x_attribute5 := FND_API.G_MISS_CHAR;
495: x_attribute6 := FND_API.G_MISS_CHAR;

Line 492: x_attribute3 := FND_API.G_MISS_CHAR;

488: x_attribute13 := FND_API.G_MISS_CHAR;
489: x_attribute14 := FND_API.G_MISS_CHAR;
490: x_attribute15 := FND_API.G_MISS_CHAR;
491: x_attribute2 := FND_API.G_MISS_CHAR;
492: x_attribute3 := FND_API.G_MISS_CHAR;
493: x_attribute4 := FND_API.G_MISS_CHAR;
494: x_attribute5 := FND_API.G_MISS_CHAR;
495: x_attribute6 := FND_API.G_MISS_CHAR;
496: x_attribute7 := FND_API.G_MISS_CHAR;

Line 493: x_attribute4 := FND_API.G_MISS_CHAR;

489: x_attribute14 := FND_API.G_MISS_CHAR;
490: x_attribute15 := FND_API.G_MISS_CHAR;
491: x_attribute2 := FND_API.G_MISS_CHAR;
492: x_attribute3 := FND_API.G_MISS_CHAR;
493: x_attribute4 := FND_API.G_MISS_CHAR;
494: x_attribute5 := FND_API.G_MISS_CHAR;
495: x_attribute6 := FND_API.G_MISS_CHAR;
496: x_attribute7 := FND_API.G_MISS_CHAR;
497: x_attribute8 := FND_API.G_MISS_CHAR;

Line 494: x_attribute5 := FND_API.G_MISS_CHAR;

490: x_attribute15 := FND_API.G_MISS_CHAR;
491: x_attribute2 := FND_API.G_MISS_CHAR;
492: x_attribute3 := FND_API.G_MISS_CHAR;
493: x_attribute4 := FND_API.G_MISS_CHAR;
494: x_attribute5 := FND_API.G_MISS_CHAR;
495: x_attribute6 := FND_API.G_MISS_CHAR;
496: x_attribute7 := FND_API.G_MISS_CHAR;
497: x_attribute8 := FND_API.G_MISS_CHAR;
498: x_attribute9 := FND_API.G_MISS_CHAR;

Line 495: x_attribute6 := FND_API.G_MISS_CHAR;

491: x_attribute2 := FND_API.G_MISS_CHAR;
492: x_attribute3 := FND_API.G_MISS_CHAR;
493: x_attribute4 := FND_API.G_MISS_CHAR;
494: x_attribute5 := FND_API.G_MISS_CHAR;
495: x_attribute6 := FND_API.G_MISS_CHAR;
496: x_attribute7 := FND_API.G_MISS_CHAR;
497: x_attribute8 := FND_API.G_MISS_CHAR;
498: x_attribute9 := FND_API.G_MISS_CHAR;
499: x_context := FND_API.G_MISS_CHAR;

Line 496: x_attribute7 := FND_API.G_MISS_CHAR;

492: x_attribute3 := FND_API.G_MISS_CHAR;
493: x_attribute4 := FND_API.G_MISS_CHAR;
494: x_attribute5 := FND_API.G_MISS_CHAR;
495: x_attribute6 := FND_API.G_MISS_CHAR;
496: x_attribute7 := FND_API.G_MISS_CHAR;
497: x_attribute8 := FND_API.G_MISS_CHAR;
498: x_attribute9 := FND_API.G_MISS_CHAR;
499: x_context := FND_API.G_MISS_CHAR;
500: x_enabled_flag := FND_API.G_MISS_CHAR;

Line 497: x_attribute8 := FND_API.G_MISS_CHAR;

493: x_attribute4 := FND_API.G_MISS_CHAR;
494: x_attribute5 := FND_API.G_MISS_CHAR;
495: x_attribute6 := FND_API.G_MISS_CHAR;
496: x_attribute7 := FND_API.G_MISS_CHAR;
497: x_attribute8 := FND_API.G_MISS_CHAR;
498: x_attribute9 := FND_API.G_MISS_CHAR;
499: x_context := FND_API.G_MISS_CHAR;
500: x_enabled_flag := FND_API.G_MISS_CHAR;
501: x_line_level_global_struct := FND_API.G_MISS_CHAR;

Line 498: x_attribute9 := FND_API.G_MISS_CHAR;

494: x_attribute5 := FND_API.G_MISS_CHAR;
495: x_attribute6 := FND_API.G_MISS_CHAR;
496: x_attribute7 := FND_API.G_MISS_CHAR;
497: x_attribute8 := FND_API.G_MISS_CHAR;
498: x_attribute9 := FND_API.G_MISS_CHAR;
499: x_context := FND_API.G_MISS_CHAR;
500: x_enabled_flag := FND_API.G_MISS_CHAR;
501: x_line_level_global_struct := FND_API.G_MISS_CHAR;
502: x_line_level_view_name := FND_API.G_MISS_CHAR;

Line 499: x_context := FND_API.G_MISS_CHAR;

495: x_attribute6 := FND_API.G_MISS_CHAR;
496: x_attribute7 := FND_API.G_MISS_CHAR;
497: x_attribute8 := FND_API.G_MISS_CHAR;
498: x_attribute9 := FND_API.G_MISS_CHAR;
499: x_context := FND_API.G_MISS_CHAR;
500: x_enabled_flag := FND_API.G_MISS_CHAR;
501: x_line_level_global_struct := FND_API.G_MISS_CHAR;
502: x_line_level_view_name := FND_API.G_MISS_CHAR;
503: x_order_level_global_struct := FND_API.G_MISS_CHAR;

Line 500: x_enabled_flag := FND_API.G_MISS_CHAR;

496: x_attribute7 := FND_API.G_MISS_CHAR;
497: x_attribute8 := FND_API.G_MISS_CHAR;
498: x_attribute9 := FND_API.G_MISS_CHAR;
499: x_context := FND_API.G_MISS_CHAR;
500: x_enabled_flag := FND_API.G_MISS_CHAR;
501: x_line_level_global_struct := FND_API.G_MISS_CHAR;
502: x_line_level_view_name := FND_API.G_MISS_CHAR;
503: x_order_level_global_struct := FND_API.G_MISS_CHAR;
504: x_order_level_view_name := FND_API.G_MISS_CHAR;

Line 501: x_line_level_global_struct := FND_API.G_MISS_CHAR;

497: x_attribute8 := FND_API.G_MISS_CHAR;
498: x_attribute9 := FND_API.G_MISS_CHAR;
499: x_context := FND_API.G_MISS_CHAR;
500: x_enabled_flag := FND_API.G_MISS_CHAR;
501: x_line_level_global_struct := FND_API.G_MISS_CHAR;
502: x_line_level_view_name := FND_API.G_MISS_CHAR;
503: x_order_level_global_struct := FND_API.G_MISS_CHAR;
504: x_order_level_view_name := FND_API.G_MISS_CHAR;
505: x_pte_code := FND_API.G_MISS_CHAR;

Line 502: x_line_level_view_name := FND_API.G_MISS_CHAR;

498: x_attribute9 := FND_API.G_MISS_CHAR;
499: x_context := FND_API.G_MISS_CHAR;
500: x_enabled_flag := FND_API.G_MISS_CHAR;
501: x_line_level_global_struct := FND_API.G_MISS_CHAR;
502: x_line_level_view_name := FND_API.G_MISS_CHAR;
503: x_order_level_global_struct := FND_API.G_MISS_CHAR;
504: x_order_level_view_name := FND_API.G_MISS_CHAR;
505: x_pte_code := FND_API.G_MISS_CHAR;
506: x_request_type_code := FND_API.G_MISS_CHAR;

Line 503: x_order_level_global_struct := FND_API.G_MISS_CHAR;

499: x_context := FND_API.G_MISS_CHAR;
500: x_enabled_flag := FND_API.G_MISS_CHAR;
501: x_line_level_global_struct := FND_API.G_MISS_CHAR;
502: x_line_level_view_name := FND_API.G_MISS_CHAR;
503: x_order_level_global_struct := FND_API.G_MISS_CHAR;
504: x_order_level_view_name := FND_API.G_MISS_CHAR;
505: x_pte_code := FND_API.G_MISS_CHAR;
506: x_request_type_code := FND_API.G_MISS_CHAR;
507: x_request_type_desc := FND_API.G_MISS_CHAR;

Line 504: x_order_level_view_name := FND_API.G_MISS_CHAR;

500: x_enabled_flag := FND_API.G_MISS_CHAR;
501: x_line_level_global_struct := FND_API.G_MISS_CHAR;
502: x_line_level_view_name := FND_API.G_MISS_CHAR;
503: x_order_level_global_struct := FND_API.G_MISS_CHAR;
504: x_order_level_view_name := FND_API.G_MISS_CHAR;
505: x_pte_code := FND_API.G_MISS_CHAR;
506: x_request_type_code := FND_API.G_MISS_CHAR;
507: x_request_type_desc := FND_API.G_MISS_CHAR;
508: x_row_id := FND_API.G_MISS_CHAR;

Line 505: x_pte_code := FND_API.G_MISS_CHAR;

501: x_line_level_global_struct := FND_API.G_MISS_CHAR;
502: x_line_level_view_name := FND_API.G_MISS_CHAR;
503: x_order_level_global_struct := FND_API.G_MISS_CHAR;
504: x_order_level_view_name := FND_API.G_MISS_CHAR;
505: x_pte_code := FND_API.G_MISS_CHAR;
506: x_request_type_code := FND_API.G_MISS_CHAR;
507: x_request_type_desc := FND_API.G_MISS_CHAR;
508: x_row_id := FND_API.G_MISS_CHAR;
509: x_enabled := FND_API.G_MISS_CHAR;

Line 506: x_request_type_code := FND_API.G_MISS_CHAR;

502: x_line_level_view_name := FND_API.G_MISS_CHAR;
503: x_order_level_global_struct := FND_API.G_MISS_CHAR;
504: x_order_level_view_name := FND_API.G_MISS_CHAR;
505: x_pte_code := FND_API.G_MISS_CHAR;
506: x_request_type_code := FND_API.G_MISS_CHAR;
507: x_request_type_desc := FND_API.G_MISS_CHAR;
508: x_row_id := FND_API.G_MISS_CHAR;
509: x_enabled := FND_API.G_MISS_CHAR;
510: x_pte := FND_API.G_MISS_CHAR;

Line 507: x_request_type_desc := FND_API.G_MISS_CHAR;

503: x_order_level_global_struct := FND_API.G_MISS_CHAR;
504: x_order_level_view_name := FND_API.G_MISS_CHAR;
505: x_pte_code := FND_API.G_MISS_CHAR;
506: x_request_type_code := FND_API.G_MISS_CHAR;
507: x_request_type_desc := FND_API.G_MISS_CHAR;
508: x_row_id := FND_API.G_MISS_CHAR;
509: x_enabled := FND_API.G_MISS_CHAR;
510: x_pte := FND_API.G_MISS_CHAR;
511: x_request_type := FND_API.G_MISS_CHAR;

Line 508: x_row_id := FND_API.G_MISS_CHAR;

504: x_order_level_view_name := FND_API.G_MISS_CHAR;
505: x_pte_code := FND_API.G_MISS_CHAR;
506: x_request_type_code := FND_API.G_MISS_CHAR;
507: x_request_type_desc := FND_API.G_MISS_CHAR;
508: x_row_id := FND_API.G_MISS_CHAR;
509: x_enabled := FND_API.G_MISS_CHAR;
510: x_pte := FND_API.G_MISS_CHAR;
511: x_request_type := FND_API.G_MISS_CHAR;
512: x_row := FND_API.G_MISS_CHAR;

Line 509: x_enabled := FND_API.G_MISS_CHAR;

505: x_pte_code := FND_API.G_MISS_CHAR;
506: x_request_type_code := FND_API.G_MISS_CHAR;
507: x_request_type_desc := FND_API.G_MISS_CHAR;
508: x_row_id := FND_API.G_MISS_CHAR;
509: x_enabled := FND_API.G_MISS_CHAR;
510: x_pte := FND_API.G_MISS_CHAR;
511: x_request_type := FND_API.G_MISS_CHAR;
512: x_row := FND_API.G_MISS_CHAR;
513:

Line 510: x_pte := FND_API.G_MISS_CHAR;

506: x_request_type_code := FND_API.G_MISS_CHAR;
507: x_request_type_desc := FND_API.G_MISS_CHAR;
508: x_row_id := FND_API.G_MISS_CHAR;
509: x_enabled := FND_API.G_MISS_CHAR;
510: x_pte := FND_API.G_MISS_CHAR;
511: x_request_type := FND_API.G_MISS_CHAR;
512: x_row := FND_API.G_MISS_CHAR;
513:
514: -- Load display out parameters if any

Line 511: x_request_type := FND_API.G_MISS_CHAR;

507: x_request_type_desc := FND_API.G_MISS_CHAR;
508: x_row_id := FND_API.G_MISS_CHAR;
509: x_enabled := FND_API.G_MISS_CHAR;
510: x_pte := FND_API.G_MISS_CHAR;
511: x_request_type := FND_API.G_MISS_CHAR;
512: x_row := FND_API.G_MISS_CHAR;
513:
514: -- Load display out parameters if any
515:

Line 512: x_row := FND_API.G_MISS_CHAR;

508: x_row_id := FND_API.G_MISS_CHAR;
509: x_enabled := FND_API.G_MISS_CHAR;
510: x_pte := FND_API.G_MISS_CHAR;
511: x_request_type := FND_API.G_MISS_CHAR;
512: x_row := FND_API.G_MISS_CHAR;
513:
514: -- Load display out parameters if any
515:
516: l_RQT_val_rec := QP_Rqt_Util.Get_Values

Line 686: x_return_status := FND_API.G_RET_STS_SUCCESS;

682: );
683:
684: -- Set return status.
685:
686: x_return_status := FND_API.G_RET_STS_SUCCESS;
687:
688: -- Get message count and data
689:
690: OE_MSG_PUB.Count_And_Get

Line 698: WHEN FND_API.G_EXC_ERROR THEN

694:
695:
696: EXCEPTION
697:
698: WHEN FND_API.G_EXC_ERROR THEN
699:
700: x_return_status := FND_API.G_RET_STS_ERROR;
701:
702: -- Get message count and data

Line 700: x_return_status := FND_API.G_RET_STS_ERROR;

696: EXCEPTION
697:
698: WHEN FND_API.G_EXC_ERROR THEN
699:
700: x_return_status := FND_API.G_RET_STS_ERROR;
701:
702: -- Get message count and data
703:
704: OE_MSG_PUB.Count_And_Get

Line 709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

705: ( p_count => x_msg_count
706: , p_data => x_msg_data
707: );
708:
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710:
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
712:
713: -- Get message count and data

Line 711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

707: );
708:
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710:
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
712:
713: -- Get message count and data
714:
715: OE_MSG_PUB.Count_And_Get

Line 722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

718: );
719:
720: WHEN OTHERS THEN
721:
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
723:
724: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
725: THEN
726: OE_MSG_PUB.Add_Exc_Msg

Line 804: IF FND_API.To_Boolean(l_RQT_rec.db_flag) THEN

800: );
801:
802: -- Set Operation.
803:
804: IF FND_API.To_Boolean(l_RQT_rec.db_flag) THEN
805: l_RQT_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
806: ELSE
807: l_RQT_rec.operation := QP_GLOBALS.G_OPR_CREATE;
808: END IF;

Line 819: , p_init_msg_list => FND_API.G_TRUE

815: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
816:
817: QP_Attr_Map_PVT.Process_Attr_Mapping
818: ( p_api_version_number => 1.0
819: , p_init_msg_list => FND_API.G_TRUE
820: , x_return_status => l_return_status
821: , x_msg_count => x_msg_count
822: , x_msg_data => x_msg_data
823: , p_control_rec => l_control_rec

Line 834: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

830: , x_SOU_tbl => l_x_SOU_tbl
831: , x_FNA_tbl => l_x_FNA_tbl
832: );
833:
834: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
837: RAISE FND_API.G_EXC_ERROR;
838: END IF;

Line 835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

831: , x_FNA_tbl => l_x_FNA_tbl
832: );
833:
834: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
837: RAISE FND_API.G_EXC_ERROR;
838: END IF;
839:

Line 836: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

832: );
833:
834: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
837: RAISE FND_API.G_EXC_ERROR;
838: END IF;
839:
840:

Line 837: RAISE FND_API.G_EXC_ERROR;

833:
834: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
837: RAISE FND_API.G_EXC_ERROR;
838: END IF;
839:
840:
841: -- Load OUT parameters.

Line 862: x_return_status := FND_API.G_RET_STS_SUCCESS;

858:
859:
860: -- Set return status.
861:
862: x_return_status := FND_API.G_RET_STS_SUCCESS;
863:
864: -- Get message count and data
865:
866: OE_MSG_PUB.Count_And_Get

Line 874: WHEN FND_API.G_EXC_ERROR THEN

870:
871:
872: EXCEPTION
873:
874: WHEN FND_API.G_EXC_ERROR THEN
875:
876: x_return_status := FND_API.G_RET_STS_ERROR;
877:
878: -- Get message count and data

Line 876: x_return_status := FND_API.G_RET_STS_ERROR;

872: EXCEPTION
873:
874: WHEN FND_API.G_EXC_ERROR THEN
875:
876: x_return_status := FND_API.G_RET_STS_ERROR;
877:
878: -- Get message count and data
879:
880: OE_MSG_PUB.Count_And_Get

Line 885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

881: ( p_count => x_msg_count
882: , p_data => x_msg_data
883: );
884:
885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
886:
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
888:
889: -- Get message count and data

Line 887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

883: );
884:
885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
886:
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
888:
889: -- Get message count and data
890:
891: OE_MSG_PUB.Count_And_Get

Line 898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

894: );
895:
896: WHEN OTHERS THEN
897:
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
899:
900: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
901: THEN
902: OE_MSG_PUB.Add_Exc_Msg

Line 978: , p_init_msg_list => FND_API.G_TRUE

974: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
975:
976: QP_Attr_Map_PVT.Process_Attr_Mapping
977: ( p_api_version_number => 1.0
978: , p_init_msg_list => FND_API.G_TRUE
979: , x_return_status => l_return_status
980: , x_msg_count => x_msg_count
981: , x_msg_data => x_msg_data
982: , p_control_rec => l_control_rec

Line 992: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

988: , x_SOU_tbl => l_x_SOU_tbl
989: , x_FNA_tbl => l_x_FNA_tbl
990: );
991:
992: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
995: RAISE FND_API.G_EXC_ERROR;
996: END IF;

Line 993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

989: , x_FNA_tbl => l_x_FNA_tbl
990: );
991:
992: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
995: RAISE FND_API.G_EXC_ERROR;
996: END IF;
997:

Line 994: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

990: );
991:
992: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
995: RAISE FND_API.G_EXC_ERROR;
996: END IF;
997:
998:

Line 995: RAISE FND_API.G_EXC_ERROR;

991:
992: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
995: RAISE FND_API.G_EXC_ERROR;
996: END IF;
997:
998:
999: -- Clear RQT record cache

Line 1005: x_return_status := FND_API.G_RET_STS_SUCCESS;

1001: Clear_RQT;
1002:
1003: -- Set return status.
1004:
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006:
1007: -- Get message count and data
1008:
1009: OE_MSG_PUB.Count_And_Get

Line 1017: WHEN FND_API.G_EXC_ERROR THEN

1013:
1014:
1015: EXCEPTION
1016:
1017: WHEN FND_API.G_EXC_ERROR THEN
1018:
1019: x_return_status := FND_API.G_RET_STS_ERROR;
1020:
1021: -- Get message count and data

Line 1019: x_return_status := FND_API.G_RET_STS_ERROR;

1015: EXCEPTION
1016:
1017: WHEN FND_API.G_EXC_ERROR THEN
1018:
1019: x_return_status := FND_API.G_RET_STS_ERROR;
1020:
1021: -- Get message count and data
1022:
1023: OE_MSG_PUB.Count_And_Get

Line 1028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1024: ( p_count => x_msg_count
1025: , p_data => x_msg_data
1026: );
1027:
1028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1029:
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1031:
1032: -- Get message count and data

Line 1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1026: );
1027:
1028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1029:
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1031:
1032: -- Get message count and data
1033:
1034: OE_MSG_PUB.Count_And_Get

Line 1041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1037: );
1038:
1039: WHEN OTHERS THEN
1040:
1041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1042:
1043: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1044: THEN
1045: OE_MSG_PUB.Add_Exc_Msg

Line 1104: , p_init_msg_list => FND_API.G_TRUE

1100: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping
1101:
1102: QP_Attr_Map_PVT.Process_Attr_Mapping
1103: ( p_api_version_number => 1.0
1104: , p_init_msg_list => FND_API.G_TRUE
1105: , x_return_status => l_return_status
1106: , x_msg_count => x_msg_count
1107: , x_msg_data => x_msg_data
1108: , p_control_rec => l_control_rec

Line 1117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1113: , x_SOU_tbl => l_x_SOU_tbl
1114: , x_FNA_tbl => l_x_FNA_tbl
1115: );
1116:
1117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1120: RAISE FND_API.G_EXC_ERROR;
1121: END IF;

Line 1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1114: , x_FNA_tbl => l_x_FNA_tbl
1115: );
1116:
1117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1120: RAISE FND_API.G_EXC_ERROR;
1121: END IF;
1122:

Line 1119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1115: );
1116:
1117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1120: RAISE FND_API.G_EXC_ERROR;
1121: END IF;
1122:
1123:

Line 1120: RAISE FND_API.G_EXC_ERROR;

1116:
1117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1120: RAISE FND_API.G_EXC_ERROR;
1121: END IF;
1122:
1123:
1124: -- Set return status.

Line 1126: x_return_status := FND_API.G_RET_STS_SUCCESS;

1122:
1123:
1124: -- Set return status.
1125:
1126: x_return_status := FND_API.G_RET_STS_SUCCESS;
1127:
1128: -- Get message count and data
1129:
1130: OE_MSG_PUB.Count_And_Get

Line 1138: WHEN FND_API.G_EXC_ERROR THEN

1134:
1135:
1136: EXCEPTION
1137:
1138: WHEN FND_API.G_EXC_ERROR THEN
1139:
1140: x_return_status := FND_API.G_RET_STS_ERROR;
1141:
1142: -- Get message count and data

Line 1140: x_return_status := FND_API.G_RET_STS_ERROR;

1136: EXCEPTION
1137:
1138: WHEN FND_API.G_EXC_ERROR THEN
1139:
1140: x_return_status := FND_API.G_RET_STS_ERROR;
1141:
1142: -- Get message count and data
1143:
1144: OE_MSG_PUB.Count_And_Get

Line 1149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1145: ( p_count => x_msg_count
1146: , p_data => x_msg_data
1147: );
1148:
1149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1150:
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1152:
1153: -- Get message count and data

Line 1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1147: );
1148:
1149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1150:
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1152:
1153: -- Get message count and data
1154:
1155: OE_MSG_PUB.Count_And_Get

Line 1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1158: );
1159:
1160: WHEN OTHERS THEN
1161:
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1163:
1164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1165: THEN
1166: OE_MSG_PUB.Add_Exc_Msg

Line 1283: , p_init_msg_list => FND_API.G_TRUE

1279: -- Call QP_Attr_Map_PVT.Lock_Attr_Mapping
1280:
1281: QP_Attr_Map_PVT.Lock_Attr_Mapping
1282: ( p_api_version_number => 1.0
1283: , p_init_msg_list => FND_API.G_TRUE
1284: , x_return_status => l_return_status
1285: , x_msg_count => x_msg_count
1286: , x_msg_data => x_msg_data
1287: , p_RQT_tbl => l_RQT_tbl

Line 1296: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1292: , x_SOU_tbl => l_x_SOU_tbl
1293: , x_FNA_tbl => l_x_FNA_tbl
1294: );
1295:
1296: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1297:
1298: -- Set DB flag and write record to cache.
1299:
1300: l_x_RQT_rec.db_flag := FND_API.G_TRUE;

Line 1300: l_x_RQT_rec.db_flag := FND_API.G_TRUE;

1296: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1297:
1298: -- Set DB flag and write record to cache.
1299:
1300: l_x_RQT_rec.db_flag := FND_API.G_TRUE;
1301:
1302: Write_RQT
1303: ( p_RQT_rec => l_x_RQT_rec
1304: , p_db_record => TRUE

Line 1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1329: , 'Lock_Row'
1330: );
1331: END IF;
1332:
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1334:
1335: -- Get message count and data
1336:
1337: OE_MSG_PUB.Count_And_Get

Line 1382: g_RQT_rec.db_flag := FND_API.G_TRUE;

1378: g_RQT_rec := QP_Rqt_Util.Query_Row
1379: ( p_request_type_code => p_request_type_code
1380: );
1381:
1382: g_RQT_rec.db_flag := FND_API.G_TRUE;
1383:
1384: -- Load DB record
1385:
1386: g_db_RQT_rec := g_RQT_rec;