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

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

63: -- End of Comments
64:
65: PROCEDURE Process_Attr_Mapping
66: ( p_api_version_number IN NUMBER
67: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
69: , p_commit IN VARCHAR2 := FND_API.G_FALSE
70: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

64:
65: PROCEDURE Process_Attr_Mapping
66: ( p_api_version_number IN NUMBER
67: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
69: , p_commit IN VARCHAR2 := FND_API.G_FALSE
70: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
72: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

65: PROCEDURE Process_Attr_Mapping
66: ( p_api_version_number IN NUMBER
67: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
69: , p_commit IN VARCHAR2 := FND_API.G_FALSE
70: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
72: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73: , p_PTE_rec IN Pte_Rec_Type :=

Line 132: IF NOT FND_API.Compatible_API_Call

128: BEGIN
129:
130: -- Standard call to check for call compatibility
131:
132: IF NOT FND_API.Compatible_API_Call
133: ( l_api_version_number
134: , p_api_version_number
135: , l_api_name
136: , G_PKG_NAME

Line 139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

135: , l_api_name
136: , G_PKG_NAME
137: )
138: THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141:
142: -- Perform Value to Id conversion
143:

Line 166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 169: RAISE FND_API.G_EXC_ERROR;

165:
166: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171:
172:
173: -- Call QP_Attr_Map_PVT.Process_Attr_Mapping

Line 184: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

180:
181: QP_Attr_Map_PVT.Process_Attr_Mapping
182: ( p_api_version_number => 1.0
183: , p_init_msg_list => p_init_msg_list
184: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
185: , p_commit => p_commit
186: , x_return_status => x_return_status
187: , x_msg_count => x_msg_count
188: , x_msg_data => x_msg_data

Line 215: IF FND_API.to_Boolean(p_return_values) THEN

211: x_FNA_tbl := l_FNA_tbl;
212:
213: -- If p_return_values is TRUE then convert Ids to Values.
214:
215: IF FND_API.to_Boolean(p_return_values) THEN
216:
217: Id_To_Value
218: ( p_PTE_rec => l_PTE_rec
219: , p_RQT_tbl => l_RQT_tbl

Line 235: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

231:
232: END IF;
233:
234: -- If Process_Attr_mapping is successful, Check for Enabled Fnas
235: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
236: QP_Attr_Map_PVT.Check_Enabled_Fnas
237: ( x_msg_data => x_msg_data
238: , x_msg_count => x_msg_count
239: , x_return_status => l_enabled_fnas_ret_sts

Line 245: WHEN FND_API.G_EXC_ERROR THEN

241: END IF;
242:
243: EXCEPTION
244:
245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: -- Get message count and data

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

243: EXCEPTION
244:
245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: -- Get message count and data
250:
251: OE_MSG_PUB.Count_And_Get

Line 256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

252: ( p_count => x_msg_count
253: , p_data => x_msg_data
254: );
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257:
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259:
260: -- Get message count and data

Line 258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

254: );
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257:
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259:
260: -- Get message count and data
261:
262: OE_MSG_PUB.Count_And_Get

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

265: );
266:
267: WHEN OTHERS THEN
268:
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270:
271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: OE_MSG_PUB.Add_Exc_Msg

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

302: -- End of Comments
303:
304: PROCEDURE Process_Attr_Mapping
305: ( p_api_version_number IN NUMBER
306: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
307: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
308: , p_commit IN VARCHAR2 := FND_API.G_FALSE
309: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
310: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

303:
304: PROCEDURE Process_Attr_Mapping
305: ( p_api_version_number IN NUMBER
306: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
307: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
308: , p_commit IN VARCHAR2 := FND_API.G_FALSE
309: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
310: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
311: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

304: PROCEDURE Process_Attr_Mapping
305: ( p_api_version_number IN NUMBER
306: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
307: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
308: , p_commit IN VARCHAR2 := FND_API.G_FALSE
309: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
310: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
311: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
312: , p_PTE_rec IN Pte_Rec_Type :=

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

401: -- End of Comments
402:
403: PROCEDURE Lock_Attr_Mapping
404: ( p_api_version_number IN NUMBER
405: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
406: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
407: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
408: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
409: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

402:
403: PROCEDURE Lock_Attr_Mapping
404: ( p_api_version_number IN NUMBER
405: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
406: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
407: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
408: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
409: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
410: , p_PTE_rec IN Pte_Rec_Type :=

Line 467: IF NOT FND_API.Compatible_API_Call

463: BEGIN
464:
465: -- Standard call to check for call compatibility
466:
467: IF NOT FND_API.Compatible_API_Call
468: ( l_api_version_number
469: , p_api_version_number
470: , l_api_name
471: , G_PKG_NAME

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

470: , l_api_name
471: , G_PKG_NAME
472: )
473: THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:
477: -- Perform Value to Id conversion
478:

Line 501: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

497: , x_SOU_tbl => l_SOU_tbl
498: , x_FNA_tbl => l_FNA_tbl
499: );
500:
501: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;

Line 502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

498: , x_FNA_tbl => l_FNA_tbl
499: );
500:
501: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:

Line 503: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

499: );
500:
501: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507:

Line 504: RAISE FND_API.G_EXC_ERROR;

500:
501: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507:
508: -- Call QP_Attr_Map_PVT.Lock_Attr_Mapping

Line 547: IF FND_API.to_Boolean(p_return_values) THEN

543: x_FNA_tbl := l_FNA_tbl;
544:
545: -- If p_return_values is TRUE then convert Ids to Values.
546:
547: IF FND_API.to_Boolean(p_return_values) THEN
548:
549: Id_To_Value
550: ( p_PTE_rec => l_PTE_rec
551: , p_RQT_tbl => l_RQT_tbl

Line 568: WHEN FND_API.G_EXC_ERROR THEN

564: END IF;
565:
566: EXCEPTION
567:
568: WHEN FND_API.G_EXC_ERROR THEN
569:
570: x_return_status := FND_API.G_RET_STS_ERROR;
571:
572: -- Get message count and data

Line 570: x_return_status := FND_API.G_RET_STS_ERROR;

566: EXCEPTION
567:
568: WHEN FND_API.G_EXC_ERROR THEN
569:
570: x_return_status := FND_API.G_RET_STS_ERROR;
571:
572: -- Get message count and data
573:
574: OE_MSG_PUB.Count_And_Get

Line 579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

575: ( p_count => x_msg_count
576: , p_data => x_msg_data
577: );
578:
579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
580:
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
582:
583: -- Get message count and data

Line 581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

577: );
578:
579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
580:
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
582:
583: -- Get message count and data
584:
585: OE_MSG_PUB.Count_And_Get

Line 592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

588: );
589:
590: WHEN OTHERS THEN
591:
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
593:
594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
595: THEN
596: OE_MSG_PUB.Add_Exc_Msg

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

625: -- End of Comments
626:
627: PROCEDURE Lock_Attr_Mapping
628: ( p_api_version_number IN NUMBER
629: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
630: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
631: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
632: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
633: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

626:
627: PROCEDURE Lock_Attr_Mapping
628: ( p_api_version_number IN NUMBER
629: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
630: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
631: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
632: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
633: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
634: , p_PTE_rec IN Pte_Rec_Type :=

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

720: -- End of Comments
721:
722: PROCEDURE Get_Attr_Mapping
723: ( p_api_version_number IN NUMBER
724: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
725: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
726: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
727: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
728: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

721:
722: PROCEDURE Get_Attr_Mapping
723: ( p_api_version_number IN NUMBER
724: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
725: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
726: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
727: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
728: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
729: , p_lookup_code IN VARCHAR2 :=

Line 730: FND_API.G_MISS_CHAR

726: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
727: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
728: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
729: , p_lookup_code IN VARCHAR2 :=
730: FND_API.G_MISS_CHAR
731: , p_lookup IN VARCHAR2 :=
732: FND_API.G_MISS_CHAR
733: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
734: , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type

Line 732: FND_API.G_MISS_CHAR

728: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
729: , p_lookup_code IN VARCHAR2 :=
730: FND_API.G_MISS_CHAR
731: , p_lookup IN VARCHAR2 :=
732: FND_API.G_MISS_CHAR
733: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
734: , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type
735: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Tbl_Type
736: , x_RQT_val_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Val_Tbl_Type

Line 760: IF NOT FND_API.Compatible_API_Call

756: BEGIN
757:
758: -- Standard call to check for call compatibility
759:
760: IF NOT FND_API.Compatible_API_Call
761: ( l_api_version_number
762: , p_api_version_number
763: , l_api_name
764: , G_PKG_NAME

Line 767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

763: , l_api_name
764: , G_PKG_NAME
765: )
766: THEN
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768: END IF;
769:
770: -- Standard check for Val/ID conversion
771:

Line 772: IF p_lookup = FND_API.G_MISS_CHAR

768: END IF;
769:
770: -- Standard check for Val/ID conversion
771:
772: IF p_lookup = FND_API.G_MISS_CHAR
773: THEN
774:
775: l_lookup_code := p_lookup_code;
776:

Line 777: ELSIF p_lookup_code <> FND_API.G_MISS_CHAR THEN

773: THEN
774:
775: l_lookup_code := p_lookup_code;
776:
777: ELSIF p_lookup_code <> FND_API.G_MISS_CHAR THEN
778:
779: l_lookup_code := p_lookup_code;
780:
781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 798: IF l_lookup_code = FND_API.G_MISS_CHAR THEN

794: l_lookup_code := QP_Value_To_Id.lookup
795: ( p_lookup => p_lookup
796: );
797:
798: IF l_lookup_code = FND_API.G_MISS_CHAR THEN
799: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
800: THEN
801:
802: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');

Line 809: RAISE FND_API.G_EXC_ERROR;

805:
806: END IF;
807: END IF;
808:
809: RAISE FND_API.G_EXC_ERROR;
810:
811: END IF;
812:
813:

Line 842: IF FND_API.TO_BOOLEAN(p_return_values) THEN

838: x_FNA_tbl := l_FNA_tbl;
839:
840: -- If p_return_values is TRUE then convert Ids to Values.
841:
842: IF FND_API.TO_BOOLEAN(p_return_values) THEN
843:
844: Id_To_Value
845: ( p_PTE_rec => l_PTE_rec
846: , p_RQT_tbl => l_RQT_tbl

Line 863: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 875: WHEN FND_API.G_EXC_ERROR THEN

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

Line 877: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

932: -- End of Comments
933:
934: PROCEDURE Get_Attr_Mapping
935: ( p_api_version_number IN NUMBER
936: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
937: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
938: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
939: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
940: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

933:
934: PROCEDURE Get_Attr_Mapping
935: ( p_api_version_number IN NUMBER
936: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
937: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
938: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
939: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
940: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
941: , p_lookup_code IN VARCHAR2 :=

Line 942: FND_API.G_MISS_CHAR

938: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
939: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
940: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
941: , p_lookup_code IN VARCHAR2 :=
942: FND_API.G_MISS_CHAR
943: , p_lookup IN VARCHAR2 :=
944: FND_API.G_MISS_CHAR
945: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
946: , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type

Line 944: FND_API.G_MISS_CHAR

940: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
941: , p_lookup_code IN VARCHAR2 :=
942: FND_API.G_MISS_CHAR
943: , p_lookup IN VARCHAR2 :=
944: FND_API.G_MISS_CHAR
945: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
946: , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type
947: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Tbl_Type
948: , x_RQT_val_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Val_Tbl_Type

Line 1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1050: , 'Id_To_Value'
1051: );
1052: END IF;
1053:
1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1055:
1056: END Id_To_Value;
1057:
1058: -- Procedure Value_To_Id

Line 1093: x_return_status := FND_API.G_RET_STS_SUCCESS;

1089: BEGIN
1090:
1091: -- Init x_return_status.
1092:
1093: x_return_status := FND_API.G_RET_STS_SUCCESS;
1094:
1095: -- Convert PTE
1096:
1097: l_PTE_rec := QP_Pte_Util.Get_Ids

Line 1104: IF l_PTE_rec.return_status = FND_API.G_RET_STS_ERROR THEN

1100: );
1101:
1102: x_PTE_rec := l_PTE_rec;
1103:
1104: IF l_PTE_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: END IF;
1107:
1108: -- Convert RQT

Line 1105: x_return_status := FND_API.G_RET_STS_ERROR;

1101:
1102: x_PTE_rec := l_PTE_rec;
1103:
1104: IF l_PTE_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: END IF;
1107:
1108: -- Convert RQT
1109:

Line 1123: IF l_RQT_rec.return_status = FND_API.G_RET_STS_ERROR THEN

1119: );
1120:
1121: x_RQT_tbl(l_index) := l_RQT_rec;
1122:
1123: IF l_RQT_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: END IF;
1126:
1127: l_index := p_RQT_val_tbl.NEXT(l_index);

Line 1124: x_return_status := FND_API.G_RET_STS_ERROR;

1120:
1121: x_RQT_tbl(l_index) := l_RQT_rec;
1122:
1123: IF l_RQT_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: END IF;
1126:
1127: l_index := p_RQT_val_tbl.NEXT(l_index);
1128:

Line 1146: IF l_SSC_rec.return_status = FND_API.G_RET_STS_ERROR THEN

1142: );
1143:
1144: x_SSC_tbl(l_index) := l_SSC_rec;
1145:
1146: IF l_SSC_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148: END IF;
1149:
1150: l_index := p_SSC_val_tbl.NEXT(l_index);

Line 1147: x_return_status := FND_API.G_RET_STS_ERROR;

1143:
1144: x_SSC_tbl(l_index) := l_SSC_rec;
1145:
1146: IF l_SSC_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148: END IF;
1149:
1150: l_index := p_SSC_val_tbl.NEXT(l_index);
1151:

Line 1169: IF l_PSG_rec.return_status = FND_API.G_RET_STS_ERROR THEN

1165: );
1166:
1167: x_PSG_tbl(l_index) := l_PSG_rec;
1168:
1169: IF l_PSG_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1170: x_return_status := FND_API.G_RET_STS_ERROR;
1171: END IF;
1172:
1173: l_index := p_PSG_val_tbl.NEXT(l_index);

Line 1170: x_return_status := FND_API.G_RET_STS_ERROR;

1166:
1167: x_PSG_tbl(l_index) := l_PSG_rec;
1168:
1169: IF l_PSG_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1170: x_return_status := FND_API.G_RET_STS_ERROR;
1171: END IF;
1172:
1173: l_index := p_PSG_val_tbl.NEXT(l_index);
1174:

Line 1192: IF l_SOU_rec.return_status = FND_API.G_RET_STS_ERROR THEN

1188: );
1189:
1190: x_SOU_tbl(l_index) := l_SOU_rec;
1191:
1192: IF l_SOU_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194: END IF;
1195:
1196: l_index := p_SOU_val_tbl.NEXT(l_index);

Line 1193: x_return_status := FND_API.G_RET_STS_ERROR;

1189:
1190: x_SOU_tbl(l_index) := l_SOU_rec;
1191:
1192: IF l_SOU_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194: END IF;
1195:
1196: l_index := p_SOU_val_tbl.NEXT(l_index);
1197:

Line 1215: IF l_FNA_rec.return_status = FND_API.G_RET_STS_ERROR THEN

1211: );
1212:
1213: x_FNA_tbl(l_index) := l_FNA_rec;
1214:
1215: IF l_FNA_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: END IF;
1218:
1219: l_index := p_FNA_val_tbl.NEXT(l_index);

Line 1216: x_return_status := FND_API.G_RET_STS_ERROR;

1212:
1213: x_FNA_tbl(l_index) := l_FNA_rec;
1214:
1215: IF l_FNA_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: END IF;
1218:
1219: l_index := p_FNA_val_tbl.NEXT(l_index);
1220:

Line 1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1231: , 'Value_To_Id'
1232: );
1233: END IF;
1234:
1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1236:
1237: END Value_To_Id;
1238:
1239: END QP_Attr_Map_PUB;