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

Line 47: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

43: -- End of Comments
44:
45: PROCEDURE Process_Attributes
46: ( p_api_version_number IN NUMBER
47: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
48: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
49: , p_commit IN VARCHAR2 := FND_API.G_FALSE
50: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 48: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

44:
45: PROCEDURE Process_Attributes
46: ( p_api_version_number IN NUMBER
47: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
48: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
49: , p_commit IN VARCHAR2 := FND_API.G_FALSE
50: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
52: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 49: , p_commit IN VARCHAR2 := FND_API.G_FALSE

45: PROCEDURE Process_Attributes
46: ( p_api_version_number IN NUMBER
47: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
48: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
49: , p_commit IN VARCHAR2 := FND_API.G_FALSE
50: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
52: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53: , p_CON_rec IN Con_Rec_Type :=

Line 79: IF NOT FND_API.Compatible_API_Call

75: BEGIN
76:
77: -- Standard call to check for call compatibility
78:
79: IF NOT FND_API.Compatible_API_Call
80: ( l_api_version_number
81: , p_api_version_number
82: , l_api_name
83: , G_PKG_NAME

Line 86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

82: , l_api_name
83: , G_PKG_NAME
84: )
85: THEN
86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87: END IF;
88:
89: -- Perform Value to Id conversion
90:

Line 101: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

97: , x_CON_rec => l_CON_rec
98: , x_SEG_tbl => l_SEG_tbl
99: );
100:
101: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;

Line 102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

98: , x_SEG_tbl => l_SEG_tbl
99: );
100:
101: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106:

Line 103: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

99: );
100:
101: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106:
107:

Line 104: RAISE FND_API.G_EXC_ERROR;

100:
101: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106:
107:
108: -- Call QP_Attributes_PVT.Process_Attributes

Line 116: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

112:
113: QP_Attributes_PVT.Process_Attributes
114: ( p_api_version_number => 1.0
115: , p_init_msg_list => p_init_msg_list
116: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
117: , p_commit => p_commit
118: , x_return_status => x_return_status
119: , x_msg_count => x_msg_count
120: , x_msg_data => x_msg_data

Line 135: IF FND_API.to_Boolean(p_return_values) THEN

131: x_SEG_tbl := l_SEG_tbl;
132:
133: -- If p_return_values is TRUE then convert Ids to Values.
134:
135: IF FND_API.to_Boolean(p_return_values) THEN
136:
137: Id_To_Value
138: ( p_CON_rec => l_CON_rec
139: , p_SEG_tbl => l_SEG_tbl

Line 148: WHEN FND_API.G_EXC_ERROR THEN

144: END IF;
145:
146: EXCEPTION
147:
148: WHEN FND_API.G_EXC_ERROR THEN
149:
150: x_return_status := FND_API.G_RET_STS_ERROR;
151:
152: -- Get message count and data

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

146: EXCEPTION
147:
148: WHEN FND_API.G_EXC_ERROR THEN
149:
150: x_return_status := FND_API.G_RET_STS_ERROR;
151:
152: -- Get message count and data
153:
154: OE_MSG_PUB.Count_And_Get

Line 159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

155: ( p_count => x_msg_count
156: , p_data => x_msg_data
157: );
158:
159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
160:
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
162:
163: -- Get message count and data

Line 161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

157: );
158:
159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
160:
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
162:
163: -- Get message count and data
164:
165: OE_MSG_PUB.Count_And_Get

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

168: );
169:
170: WHEN OTHERS THEN
171:
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
173:
174: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: OE_MSG_PUB.Add_Exc_Msg

Line 209: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

205: -- End of Comments
206:
207: PROCEDURE Lock_Attributes
208: ( p_api_version_number IN NUMBER
209: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
210: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
211: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
212: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
213: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 210: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

206:
207: PROCEDURE Lock_Attributes
208: ( p_api_version_number IN NUMBER
209: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
210: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
211: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
212: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
213: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
214: , p_CON_rec IN Con_Rec_Type :=

Line 239: IF NOT FND_API.Compatible_API_Call

235: BEGIN
236:
237: -- Standard call to check for call compatibility
238:
239: IF NOT FND_API.Compatible_API_Call
240: ( l_api_version_number
241: , p_api_version_number
242: , l_api_name
243: , G_PKG_NAME

Line 246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

242: , l_api_name
243: , G_PKG_NAME
244: )
245: THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: END IF;
248:
249: -- Perform Value to Id conversion
250:

Line 261: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

257: , x_CON_rec => l_CON_rec
258: , x_SEG_tbl => l_SEG_tbl
259: );
260:
261: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: , x_SEG_tbl => l_SEG_tbl
259: );
260:
261: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:

Line 263: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

259: );
260:
261: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:
267:

Line 264: RAISE FND_API.G_EXC_ERROR;

260:
261: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:
267:
268: -- Call QP_Attributes_PVT.Lock_Attributes

Line 290: IF FND_API.to_Boolean(p_return_values) THEN

286: x_SEG_tbl := l_SEG_tbl;
287:
288: -- If p_return_values is TRUE then convert Ids to Values.
289:
290: IF FND_API.to_Boolean(p_return_values) THEN
291:
292: Id_To_Value
293: ( p_CON_rec => l_CON_rec
294: , p_SEG_tbl => l_SEG_tbl

Line 303: WHEN FND_API.G_EXC_ERROR THEN

299: END IF;
300:
301: EXCEPTION
302:
303: WHEN FND_API.G_EXC_ERROR THEN
304:
305: x_return_status := FND_API.G_RET_STS_ERROR;
306:
307: -- Get message count and data

Line 305: x_return_status := FND_API.G_RET_STS_ERROR;

301: EXCEPTION
302:
303: WHEN FND_API.G_EXC_ERROR THEN
304:
305: x_return_status := FND_API.G_RET_STS_ERROR;
306:
307: -- Get message count and data
308:
309: OE_MSG_PUB.Count_And_Get

Line 314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

310: ( p_count => x_msg_count
311: , p_data => x_msg_data
312: );
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315:
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317:
318: -- Get message count and data

Line 316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

312: );
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315:
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317:
318: -- Get message count and data
319:
320: OE_MSG_PUB.Count_And_Get

Line 327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

323: );
324:
325: WHEN OTHERS THEN
326:
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
328:
329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: OE_MSG_PUB.Add_Exc_Msg

Line 364: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

360: -- End of Comments
361:
362: PROCEDURE Get_Attributes
363: ( p_api_version_number IN NUMBER
364: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
365: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
366: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
367: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
368: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 365: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

361:
362: PROCEDURE Get_Attributes
363: ( p_api_version_number IN NUMBER
364: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
365: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
366: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
367: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
368: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
369: , p_prc_context_id IN NUMBER :=

Line 370: FND_API.G_MISS_NUM

366: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
367: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
368: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
369: , p_prc_context_id IN NUMBER :=
370: FND_API.G_MISS_NUM
371: , p_prc_context IN VARCHAR2 :=
372: FND_API.G_MISS_CHAR
373: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ Con_Rec_Type
374: , x_CON_val_rec OUT NOCOPY /* file.sql.39 change */ Con_Val_Rec_Type

Line 372: FND_API.G_MISS_CHAR

368: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
369: , p_prc_context_id IN NUMBER :=
370: FND_API.G_MISS_NUM
371: , p_prc_context IN VARCHAR2 :=
372: FND_API.G_MISS_CHAR
373: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ Con_Rec_Type
374: , x_CON_val_rec OUT NOCOPY /* file.sql.39 change */ Con_Val_Rec_Type
375: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ Seg_Tbl_Type
376: , x_SEG_val_tbl OUT NOCOPY /* file.sql.39 change */ Seg_Val_Tbl_Type

Line 388: IF NOT FND_API.Compatible_API_Call

384: BEGIN
385:
386: -- Standard call to check for call compatibility
387:
388: IF NOT FND_API.Compatible_API_Call
389: ( l_api_version_number
390: , p_api_version_number
391: , l_api_name
392: , G_PKG_NAME

Line 395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

391: , l_api_name
392: , G_PKG_NAME
393: )
394: THEN
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END IF;
397:
398: -- Standard check for Val/ID conversion
399:

Line 400: IF p_prc_context = FND_API.G_MISS_CHAR

396: END IF;
397:
398: -- Standard check for Val/ID conversion
399:
400: IF p_prc_context = FND_API.G_MISS_CHAR
401: THEN
402:
403: l_prc_context_id := p_prc_context_id;
404:

Line 405: ELSIF p_prc_context_id <> FND_API.G_MISS_NUM THEN

401: THEN
402:
403: l_prc_context_id := p_prc_context_id;
404:
405: ELSIF p_prc_context_id <> FND_API.G_MISS_NUM THEN
406:
407: l_prc_context_id := p_prc_context_id;
408:
409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 426: IF l_prc_context_id = FND_API.G_MISS_NUM THEN

422: l_prc_context_id := QP_Value_To_Id.prc_context
423: ( p_prc_context => p_prc_context
424: );
425:
426: IF l_prc_context_id = FND_API.G_MISS_NUM THEN
427: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
428: THEN
429:
430: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');

Line 437: RAISE FND_API.G_EXC_ERROR;

433:
434: END IF;
435: END IF;
436:
437: RAISE FND_API.G_EXC_ERROR;
438:
439: END IF;
440:
441:

Line 462: IF FND_API.TO_BOOLEAN(p_return_values) THEN

458: x_SEG_tbl := l_SEG_tbl;
459:
460: -- If p_return_values is TRUE then convert Ids to Values.
461:
462: IF FND_API.TO_BOOLEAN(p_return_values) THEN
463:
464: Id_To_Value
465: ( p_CON_rec => l_CON_rec
466: , p_SEG_tbl => l_SEG_tbl

Line 475: x_return_status := FND_API.G_RET_STS_SUCCESS;

471: END IF;
472:
473: -- Set return status
474:
475: x_return_status := FND_API.G_RET_STS_SUCCESS;
476:
477: -- Get message count and data
478:
479: OE_MSG_PUB.Count_And_Get

Line 487: WHEN FND_API.G_EXC_ERROR THEN

483:
484:
485: EXCEPTION
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488:
489: x_return_status := FND_API.G_RET_STS_ERROR;
490:
491: -- Get message count and data

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: EXCEPTION
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488:
489: x_return_status := FND_API.G_RET_STS_ERROR;
490:
491: -- Get message count and data
492:
493: OE_MSG_PUB.Count_And_Get

Line 498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

494: ( p_count => x_msg_count
495: , p_data => x_msg_data
496: );
497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
499:
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501:
502: -- Get message count and data

Line 500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

496: );
497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
499:
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501:
502: -- Get message count and data
503:
504: OE_MSG_PUB.Count_And_Get

Line 511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

507: );
508:
509: WHEN OTHERS THEN
510:
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
512:
513: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
514: THEN
515: OE_MSG_PUB.Add_Exc_Msg

Line 564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

560: , 'Id_To_Value'
561: );
562: END IF;
563:
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565:
566: END Id_To_Value;
567:
568: -- Procedure Value_To_Id

Line 587: x_return_status := FND_API.G_RET_STS_SUCCESS;

583: BEGIN
584:
585: -- Init x_return_status.
586:
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588:
589: -- Convert CON
590:
591: l_CON_rec := QP_Con_Util.Get_Ids

Line 598: IF l_CON_rec.return_status = FND_API.G_RET_STS_ERROR THEN

594: );
595:
596: x_CON_rec := l_CON_rec;
597:
598: IF l_CON_rec.return_status = FND_API.G_RET_STS_ERROR THEN
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: END IF;
601:
602: -- Convert SEG

Line 599: x_return_status := FND_API.G_RET_STS_ERROR;

595:
596: x_CON_rec := l_CON_rec;
597:
598: IF l_CON_rec.return_status = FND_API.G_RET_STS_ERROR THEN
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: END IF;
601:
602: -- Convert SEG
603:

Line 617: IF l_SEG_rec.return_status = FND_API.G_RET_STS_ERROR THEN

613: );
614:
615: x_SEG_tbl(l_index) := l_SEG_rec;
616:
617: IF l_SEG_rec.return_status = FND_API.G_RET_STS_ERROR THEN
618: x_return_status := FND_API.G_RET_STS_ERROR;
619: END IF;
620:
621: l_index := p_SEG_val_tbl.NEXT(l_index);

Line 618: x_return_status := FND_API.G_RET_STS_ERROR;

614:
615: x_SEG_tbl(l_index) := l_SEG_rec;
616:
617: IF l_SEG_rec.return_status = FND_API.G_RET_STS_ERROR THEN
618: x_return_status := FND_API.G_RET_STS_ERROR;
619: END IF;
620:
621: l_index := p_SEG_val_tbl.NEXT(l_index);
622:

Line 637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

633: , 'Value_To_Id'
634: );
635: END IF;
636:
637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
638:
639: END Value_To_Id;
640:
641: END QP_Attributes_PUB;