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.OE_VALIDATE_LINE_PATTR dependencies on FND_API

Line 17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: , p_Line_Price_Attr_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
14: , p_old_Line_Price_Attr_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: --
19: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20: --
21: BEGIN

Line 28: l_return_status := FND_API.G_RET_STS_ERROR;

24:
25: IF p_Line_Price_Attr_rec.order_price_attrib_id IS NULL
26: THEN
27:
28: l_return_status := FND_API.G_RET_STS_ERROR;
29:
30: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
31: THEN
32:

Line 48: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

44:
45:
46: -- Return Error if a required attribute is missing.
47:
48: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
49:
50: RAISE FND_API.G_EXC_ERROR;
51:
52: END IF;

Line 50: RAISE FND_API.G_EXC_ERROR;

46: -- Return Error if a required attribute is missing.
47:
48: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
49:
50: RAISE FND_API.G_EXC_ERROR;
51:
52: END IF;
53:
54: --

Line 70: WHEN FND_API.G_EXC_ERROR THEN

66: x_return_status := l_return_status;
67:
68: EXCEPTION
69:
70: WHEN FND_API.G_EXC_ERROR THEN
71:
72: x_return_status := FND_API.G_RET_STS_ERROR;
73:
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 72: x_return_status := FND_API.G_RET_STS_ERROR;

68: EXCEPTION
69:
70: WHEN FND_API.G_EXC_ERROR THEN
71:
72: x_return_status := FND_API.G_RET_STS_ERROR;
73:
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75:
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

70: WHEN FND_API.G_EXC_ERROR THEN
71:
72: x_return_status := FND_API.G_RET_STS_ERROR;
73:
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75:
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: WHEN OTHERS THEN

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

72: x_return_status := FND_API.G_RET_STS_ERROR;
73:
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75:
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: WHEN OTHERS THEN
79:
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: WHEN OTHERS THEN
79:
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81:
82: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
83: THEN
84: FND_MSG_PUB.Add_Exc_Msg

Line 99: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

95: ( x_return_status OUT NOCOPY VARCHAR2
96:
97: , p_Line_Price_Attr_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
98: , p_old_Line_Price_Attr_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
99: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
100: )
101: IS
102: l_column_prefix varchar2(20);
103: l_column_value varchar2(240); --Bug#2708343

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
106: --
107: BEGIN
108:
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111: -- Validate Line_Pricing_PAttr attributes
112:
113:

Line 121: x_return_status := FND_API.G_RET_STS_ERROR;

117: p_old_Line_Price_Attr_rec.override_flag OR
118: p_old_Line_Price_Attr_rec.override_flag IS NULL )
119: THEN
120: IF NOT OE_Validate_adj.Override_Flag(p_Line_Price_Attr_rec.override_flag) THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: END IF;
123: END IF;
124:
125:

Line 134: x_return_status := FND_API.G_RET_STS_ERROR;

130: p_old_Line_Price_Attr_rec.created_by OR
131: p_old_Line_Price_Attr_rec.created_by IS NULL )
132: THEN
133: IF NOT OE_Validate_adj.Created_By(p_Line_Price_Attr_rec.created_by) THEN
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: END IF;
136: END IF;
137:
138: IF p_Line_Price_Attr_rec.creation_date IS NOT NULL AND

Line 144: x_return_status := FND_API.G_RET_STS_ERROR;

140: p_old_Line_Price_Attr_rec.creation_date OR
141: p_old_Line_Price_Attr_rec.creation_date IS NULL )
142: THEN
143: IF NOT OE_Validate_adj.Creation_Date(p_Line_Price_Attr_rec.creation_date) THEN
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: END IF;
146: END IF;
147:
148: IF p_Line_Price_Attr_rec.flex_title IS NOT NULL AND

Line 154: x_return_status := FND_API.G_RET_STS_ERROR;

150: p_old_Line_Price_Attr_rec.flex_title OR
151: p_old_Line_Price_Attr_rec.flex_title IS NULL )
152: THEN
153: IF NOT OE_Validate_adj.Flex_Title(p_Line_Price_Attr_rec.flex_title) THEN
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: END IF;
156: END IF;
157:
158: IF p_Line_Price_Attr_rec.header_id IS NOT NULL AND

Line 164: x_return_status := FND_API.G_RET_STS_ERROR;

160: p_old_Line_Price_Attr_rec.header_id OR
161: p_old_Line_Price_Attr_rec.header_id IS NULL )
162: THEN
163: IF NOT OE_Validate_adj.Header(p_Line_Price_Attr_rec.header_id) THEN
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: END IF;
166: END IF;
167:
168: IF p_Line_Price_Attr_rec.last_updated_by IS NOT NULL AND

Line 174: x_return_status := FND_API.G_RET_STS_ERROR;

170: p_old_Line_Price_Attr_rec.last_updated_by OR
171: p_old_Line_Price_Attr_rec.last_updated_by IS NULL )
172: THEN
173: IF NOT OE_Validate_adj.Last_Updated_By(p_Line_Price_Attr_rec.last_updated_by) THEN
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: END IF;
176: END IF;
177:
178: IF p_Line_Price_Attr_rec.last_update_date IS NOT NULL AND

Line 184: x_return_status := FND_API.G_RET_STS_ERROR;

180: p_old_Line_Price_Attr_rec.last_update_date OR
181: p_old_Line_Price_Attr_rec.last_update_date IS NULL )
182: THEN
183: IF NOT OE_Validate_adj.Last_Update_Date(p_Line_Price_Attr_rec.last_update_date) THEN
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: END IF;
186: END IF;
187:
188: IF p_Line_Price_Attr_rec.last_update_login IS NOT NULL AND

Line 194: x_return_status := FND_API.G_RET_STS_ERROR;

190: p_old_Line_Price_Attr_rec.last_update_login OR
191: p_old_Line_Price_Attr_rec.last_update_login IS NULL )
192: THEN
193: IF NOT OE_Validate_adj.Last_Update_Login(p_Line_Price_Attr_rec.last_update_login) THEN
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: END IF;
196: END IF;
197:
198: IF p_Line_Price_Attr_rec.line_id IS NOT NULL AND

Line 204: x_return_status := FND_API.G_RET_STS_ERROR;

200: p_old_Line_Price_Attr_rec.line_id OR
201: p_old_Line_Price_Attr_rec.line_id IS NULL )
202: THEN
203: IF NOT OE_Validate_adj.Line(p_Line_Price_Attr_rec.line_id) THEN
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: END IF;
206: END IF;
207:
208: IF p_Line_Price_Attr_rec.order_price_attrib_id IS NOT NULL AND

Line 214: x_return_status := FND_API.G_RET_STS_ERROR;

210: p_old_Line_Price_Attr_rec.order_price_attrib_id OR
211: p_old_Line_Price_Attr_rec.order_price_attrib_id IS NULL )
212: THEN
213: IF NOT OE_Validate_adj.Order_Price_Attrib(p_Line_Price_Attr_rec.order_price_attrib_id) THEN
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: END IF;
216: END IF;
217:
218: IF p_Line_Price_Attr_rec.program_application_id IS NOT NULL AND

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220: p_old_Line_Price_Attr_rec.program_application_id OR
221: p_old_Line_Price_Attr_rec.program_application_id IS NULL )
222: THEN
223: IF NOT OE_Validate_adj.Program_Application(p_Line_Price_Attr_rec.program_application_id) THEN
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: END IF;
226: END IF;
227:
228: IF p_Line_Price_Attr_rec.program_id IS NOT NULL AND

Line 234: x_return_status := FND_API.G_RET_STS_ERROR;

230: p_old_Line_Price_Attr_rec.program_id OR
231: p_old_Line_Price_Attr_rec.program_id IS NULL )
232: THEN
233: IF NOT OE_Validate_adj.Program(p_Line_Price_Attr_rec.program_id) THEN
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: END IF;
236: END IF;
237:
238: IF p_Line_Price_Attr_rec.program_update_date IS NOT NULL AND

Line 244: x_return_status := FND_API.G_RET_STS_ERROR;

240: p_old_Line_Price_Attr_rec.program_update_date OR
241: p_old_Line_Price_Attr_rec.program_update_date IS NULL )
242: THEN
243: IF NOT OE_Validate_adj.Program_Update_Date(p_Line_Price_Attr_rec.program_update_date) THEN
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: END IF;
246: END IF;
247:
248: IF p_Line_Price_Attr_rec.request_id IS NOT NULL AND

Line 254: x_return_status := FND_API.G_RET_STS_ERROR;

250: p_old_Line_Price_Attr_rec.request_id OR
251: p_old_Line_Price_Attr_rec.request_id IS NULL )
252: THEN
253: IF NOT OE_Validate_adj.Request(p_Line_Price_Attr_rec.request_id) THEN
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: END IF;
256: END IF;
257: if OE_GLOBALS.g_validate_desc_flex ='Y' then --bug 4343612
258: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Line_PAttr .attributes ',1);

Line 400: x_return_status := FND_API.G_RET_STS_ERROR;

396: p_line_price_attr_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
397:
398: null;
399: ELSE
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: END IF;
402: END IF;*/
403:
404: END IF;

Line 819: p_old_Line_Price_Attr_rec.pricing_context <> FND_API.G_MISS_CHAR) THEN

815: AND
816: p_Line_Price_Attr_rec.pricing_context <>
817: p_old_Line_Price_Attr_rec.pricing_context
818: AND
819: p_old_Line_Price_Attr_rec.pricing_context <> FND_API.G_MISS_CHAR) THEN
820:
821: FND_MESSAGE.SET_NAME('ONT','ONT_OTA_UPDATE_NOT_ALLOWED');
822: OE_MSG_PUB.ADD;
823: RAISE FND_API.G_EXC_ERROR;

Line 823: RAISE FND_API.G_EXC_ERROR;

819: p_old_Line_Price_Attr_rec.pricing_context <> FND_API.G_MISS_CHAR) THEN
820:
821: FND_MESSAGE.SET_NAME('ONT','ONT_OTA_UPDATE_NOT_ALLOWED');
822: OE_MSG_PUB.ADD;
823: RAISE FND_API.G_EXC_ERROR;
824: END IF;
825:
826: if p_Line_Price_Attr_rec.flex_title='QP_ATTR_DEFNS_PRICING' then
827: l_column_prefix := 'PRICING';

Line 834: IF p_Line_Price_Attr_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN

830: end if;
831:
832: -- Added the IF condition(s) for bug#2708343
833:
834: IF p_Line_Price_Attr_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
835: l_column_value := null;
836: ELSE
837: l_column_value := p_Line_Price_Attr_rec.pricing_attribute1;
838: END IF;

Line 845: IF p_Line_Price_Attr_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN

841: ( column_name => l_column_prefix||'_ATTRIBUTE1'
842: , column_value => l_column_value
843: );
844:
845: IF p_Line_Price_Attr_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
846: l_column_value := null;
847: ELSE
848: l_column_value := p_Line_Price_Attr_rec.pricing_attribute2;
849: END IF;

Line 856: IF p_Line_Price_Attr_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN

852: ( column_name => l_column_prefix||'_ATTRIBUTE2'
853: , column_value => l_column_value
854: );
855:
856: IF p_Line_Price_Attr_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
857: l_column_value := null;
858: ELSE
859: l_column_value := p_Line_Price_Attr_rec.pricing_attribute3;
860: END IF;

Line 867: IF p_Line_Price_Attr_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN

863: ( column_name => l_column_prefix||'_ATTRIBUTE3'
864: , column_value => l_column_value
865: );
866:
867: IF p_Line_Price_Attr_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
868: l_column_value := null;
869: ELSE
870: l_column_value := p_Line_Price_Attr_rec.pricing_attribute4;
871: END IF;

Line 878: IF p_Line_Price_Attr_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN

874: ( column_name => l_column_prefix||'_ATTRIBUTE4'
875: , column_value => l_column_value
876: );
877:
878: IF p_Line_Price_Attr_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
879: l_column_value := null;
880: ELSE
881: l_column_value := p_Line_Price_Attr_rec.pricing_attribute5;
882: END IF;

Line 889: IF p_Line_Price_Attr_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN

885: ( column_name => l_column_prefix||'_ATTRIBUTE5'
886: , column_value => l_column_value
887: );
888:
889: IF p_Line_Price_Attr_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
890: l_column_value := null;
891: ELSE
892: l_column_value := p_Line_Price_Attr_rec.pricing_attribute6;
893: END IF;

Line 900: IF p_Line_Price_Attr_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN

896: ( column_name => l_column_prefix||'_ATTRIBUTE6'
897: , column_value => l_column_value
898: );
899:
900: IF p_Line_Price_Attr_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
901: l_column_value := null;
902: ELSE
903: l_column_value := p_Line_Price_Attr_rec.pricing_attribute7;
904: END IF;

Line 911: IF p_Line_Price_Attr_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN

907: ( column_name => l_column_prefix||'_ATTRIBUTE7'
908: , column_value => l_column_value
909: );
910:
911: IF p_Line_Price_Attr_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
912: l_column_value := null;
913: ELSE
914: l_column_value := p_Line_Price_Attr_rec.pricing_attribute8;
915: END IF;

Line 922: IF p_Line_Price_Attr_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN

918: ( column_name => l_column_prefix||'_ATTRIBUTE8'
919: , column_value => l_column_value
920: );
921:
922: IF p_Line_Price_Attr_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
923: l_column_value := null;
924: ELSE
925: l_column_value := p_Line_Price_Attr_rec.pricing_attribute9;
926: END IF;

Line 941: IF p_Line_Price_Attr_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN

937: , column_value => p_Line_Price_Attr_rec.pricing_context
938: );
939: ***/
940:
941: IF p_Line_Price_Attr_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
942: l_column_value := null;
943: ELSE
944: l_column_value := p_Line_Price_Attr_rec.pricing_attribute10;
945: END IF;

Line 952: IF p_Line_Price_Attr_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN

948: ( column_name => l_column_prefix||'_ATTRIBUTE10'
949: , column_value => l_column_value
950: );
951:
952: IF p_Line_Price_Attr_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
953: l_column_value := null;
954: ELSE
955: l_column_value := p_Line_Price_Attr_rec.pricing_attribute11;
956: END IF;

Line 963: IF p_Line_Price_Attr_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN

959: ( column_name => l_column_prefix||'_ATTRIBUTE11'
960: , column_value => l_column_value
961: );
962:
963: IF p_Line_Price_Attr_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
964: l_column_value := null;
965: ELSE
966: l_column_value := p_Line_Price_Attr_rec.pricing_attribute12;
967: END IF;

Line 974: IF p_Line_Price_Attr_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN

970: ( column_name => l_column_prefix||'_ATTRIBUTE12'
971: , column_value => l_column_value
972: );
973:
974: IF p_Line_Price_Attr_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
975: l_column_value := null;
976: ELSE
977: l_column_value := p_Line_Price_Attr_rec.pricing_attribute13;
978: END IF;

Line 985: IF p_Line_Price_Attr_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN

981: ( column_name => l_column_prefix||'_ATTRIBUTE13'
982: , column_value => l_column_value
983: );
984:
985: IF p_Line_Price_Attr_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
986: l_column_value := null;
987: ELSE
988: l_column_value := p_Line_Price_Attr_rec.pricing_attribute14;
989: END IF;

Line 996: IF p_Line_Price_Attr_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN

992: ( column_name => l_column_prefix||'_ATTRIBUTE14'
993: , column_value => l_column_value
994: );
995:
996: IF p_Line_Price_Attr_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
997: l_column_value := null;
998: ELSE
999: l_column_value := p_Line_Price_Attr_rec.pricing_attribute15;
1000: END IF;

Line 1007: IF p_Line_Price_Attr_rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN

1003: ( column_name => l_column_prefix||'_ATTRIBUTE15'
1004: , column_value => l_column_value
1005: );
1006:
1007: IF p_Line_Price_Attr_rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
1008: l_column_value := null;
1009: ELSE
1010: l_column_value := p_Line_Price_Attr_rec.pricing_attribute16;
1011: END IF;

Line 1018: IF p_Line_Price_Attr_rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN

1014: ( column_name => l_column_prefix||'_ATTRIBUTE16'
1015: , column_value => l_column_value
1016: );
1017:
1018: IF p_Line_Price_Attr_rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
1019: l_column_value := null;
1020: ELSE
1021: l_column_value := p_Line_Price_Attr_rec.pricing_attribute17;
1022: END IF;

Line 1029: IF p_Line_Price_Attr_rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN

1025: ( column_name => l_column_prefix||'_ATTRIBUTE17'
1026: , column_value => l_column_value
1027: );
1028:
1029: IF p_Line_Price_Attr_rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
1030: l_column_value := null;
1031: ELSE
1032: l_column_value := p_Line_Price_Attr_rec.pricing_attribute18;
1033: END IF;

Line 1040: IF p_Line_Price_Attr_rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN

1036: ( column_name => l_column_prefix||'_ATTRIBUTE18'
1037: , column_value => l_column_value
1038: );
1039:
1040: IF p_Line_Price_Attr_rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
1041: l_column_value := null;
1042: ELSE
1043: l_column_value := p_Line_Price_Attr_rec.pricing_attribute19;
1044: END IF;

Line 1051: IF p_Line_Price_Attr_rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN

1047: ( column_name => l_column_prefix||'_ATTRIBUTE19'
1048: , column_value => l_column_value
1049: );
1050:
1051: IF p_Line_Price_Attr_rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
1052: l_column_value := null;
1053: ELSE
1054: l_column_value := p_Line_Price_Attr_rec.pricing_attribute20;
1055: END IF;

Line 1062: IF p_Line_Price_Attr_rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN

1058: ( column_name => l_column_prefix||'_ATTRIBUTE20'
1059: , column_value => l_column_value
1060: );
1061:
1062: IF p_Line_Price_Attr_rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
1063: l_column_value := null;
1064: ELSE
1065: l_column_value := p_Line_Price_Attr_rec.pricing_attribute21;
1066: END IF;

Line 1073: IF p_Line_Price_Attr_rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN

1069: ( column_name => l_column_prefix||'_ATTRIBUTE21'
1070: , column_value => l_column_value
1071: );
1072:
1073: IF p_Line_Price_Attr_rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
1074: l_column_value := null;
1075: ELSE
1076: l_column_value := p_Line_Price_Attr_rec.pricing_attribute22;
1077: END IF;

Line 1084: IF p_Line_Price_Attr_rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN

1080: ( column_name => l_column_prefix||'_ATTRIBUTE22'
1081: , column_value => l_column_value
1082: );
1083:
1084: IF p_Line_Price_Attr_rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
1085: l_column_value := null;
1086: ELSE
1087: l_column_value := p_Line_Price_Attr_rec.pricing_attribute23;
1088: END IF;

Line 1095: IF p_Line_Price_Attr_rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN

1091: ( column_name => l_column_prefix||'_ATTRIBUTE23'
1092: , column_value => l_column_value
1093: );
1094:
1095: IF p_Line_Price_Attr_rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
1096: l_column_value := null;
1097: ELSE
1098: l_column_value := p_Line_Price_Attr_rec.pricing_attribute24;
1099: END IF;

Line 1106: IF p_Line_Price_Attr_rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN

1102: ( column_name => l_column_prefix||'_ATTRIBUTE24'
1103: , column_value => l_column_value
1104: );
1105:
1106: IF p_Line_Price_Attr_rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
1107: l_column_value := null;
1108: ELSE
1109: l_column_value := p_Line_Price_Attr_rec.pricing_attribute25;
1110: END IF;

Line 1117: IF p_Line_Price_Attr_rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN

1113: ( column_name => l_column_prefix||'_ATTRIBUTE25'
1114: , column_value => l_column_value
1115: );
1116:
1117: IF p_Line_Price_Attr_rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
1118: l_column_value := null;
1119: ELSE
1120: l_column_value := p_Line_Price_Attr_rec.pricing_attribute26;
1121: END IF;

Line 1128: IF p_Line_Price_Attr_rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN

1124: ( column_name => l_column_prefix||'_ATTRIBUTE26'
1125: , column_value => l_column_value
1126: );
1127:
1128: IF p_Line_Price_Attr_rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
1129: l_column_value := null;
1130: ELSE
1131: l_column_value := p_Line_Price_Attr_rec.pricing_attribute27;
1132: END IF;

Line 1139: IF p_Line_Price_Attr_rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN

1135: ( column_name => l_column_prefix||'_ATTRIBUTE27'
1136: , column_value => l_column_value
1137: );
1138:
1139: IF p_Line_Price_Attr_rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
1140: l_column_value := null;
1141: ELSE
1142: l_column_value := p_Line_Price_Attr_rec.pricing_attribute28;
1143: END IF;

Line 1150: IF p_Line_Price_Attr_rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN

1146: ( column_name => l_column_prefix||'_ATTRIBUTE28'
1147: , column_value => l_column_value
1148: );
1149:
1150: IF p_Line_Price_Attr_rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
1151: l_column_value := null;
1152: ELSE
1153: l_column_value := p_Line_Price_Attr_rec.pricing_attribute29;
1154: END IF;

Line 1161: IF p_Line_Price_Attr_rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN

1157: ( column_name => l_column_prefix||'_ATTRIBUTE29'
1158: , column_value => l_column_value
1159: );
1160:
1161: IF p_Line_Price_Attr_rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
1162: l_column_value := null;
1163: ELSE
1164: l_column_value := p_Line_Price_Attr_rec.pricing_attribute30;
1165: END IF;

Line 1172: IF p_Line_Price_Attr_rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN

1168: ( column_name => l_column_prefix||'_ATTRIBUTE30'
1169: , column_value => l_column_value
1170: );
1171:
1172: IF p_Line_Price_Attr_rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
1173: l_column_value := null;
1174: ELSE
1175: l_column_value := p_Line_Price_Attr_rec.pricing_attribute31;
1176: END IF;

Line 1183: IF p_Line_Price_Attr_rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN

1179: ( column_name => l_column_prefix||'_ATTRIBUTE31'
1180: , column_value => l_column_value
1181: );
1182:
1183: IF p_Line_Price_Attr_rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
1184: l_column_value := null;
1185: ELSE
1186: l_column_value := p_Line_Price_Attr_rec.pricing_attribute32;
1187: END IF;

Line 1194: IF p_Line_Price_Attr_rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN

1190: ( column_name => l_column_prefix||'_ATTRIBUTE32'
1191: , column_value => l_column_value
1192: );
1193:
1194: IF p_Line_Price_Attr_rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
1195: l_column_value := null;
1196: ELSE
1197: l_column_value := p_Line_Price_Attr_rec.pricing_attribute33;
1198: END IF;

Line 1205: IF p_Line_Price_Attr_rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN

1201: ( column_name => l_column_prefix||'_ATTRIBUTE33'
1202: , column_value => l_column_value
1203: );
1204:
1205: IF p_Line_Price_Attr_rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
1206: l_column_value := null;
1207: ELSE
1208: l_column_value := p_Line_Price_Attr_rec.pricing_attribute34;
1209: END IF;

Line 1216: IF p_Line_Price_Attr_rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN

1212: ( column_name => l_column_prefix||'_ATTRIBUTE34'
1213: , column_value => l_column_value
1214: );
1215:
1216: IF p_Line_Price_Attr_rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
1217: l_column_value := null;
1218: ELSE
1219: l_column_value := p_Line_Price_Attr_rec.pricing_attribute35;
1220: END IF;

Line 1227: IF p_Line_Price_Attr_rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN

1223: ( column_name => l_column_prefix||'_ATTRIBUTE35'
1224: , column_value => l_column_value
1225: );
1226:
1227: IF p_Line_Price_Attr_rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
1228: l_column_value := null;
1229: ELSE
1230: l_column_value := p_Line_Price_Attr_rec.pricing_attribute36;
1231: END IF;

Line 1238: IF p_Line_Price_Attr_rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN

1234: ( column_name => l_column_prefix||'_ATTRIBUTE36'
1235: , column_value => l_column_value
1236: );
1237:
1238: IF p_Line_Price_Attr_rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
1239: l_column_value := null;
1240: ELSE
1241: l_column_value := p_Line_Price_Attr_rec.pricing_attribute37;
1242: END IF;

Line 1249: IF p_Line_Price_Attr_rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN

1245: ( column_name => l_column_prefix||'_ATTRIBUTE37'
1246: , column_value => l_column_value
1247: );
1248:
1249: IF p_Line_Price_Attr_rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
1250: l_column_value := null;
1251: ELSE
1252: l_column_value := p_Line_Price_Attr_rec.pricing_attribute38;
1253: END IF;

Line 1260: IF p_Line_Price_Attr_rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN

1256: ( column_name => l_column_prefix||'_ATTRIBUTE38'
1257: , column_value => l_column_value
1258: );
1259:
1260: IF p_Line_Price_Attr_rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
1261: l_column_value := null;
1262: ELSE
1263: l_column_value := p_Line_Price_Attr_rec.pricing_attribute39;
1264: END IF;

Line 1271: IF p_Line_Price_Attr_rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN

1267: ( column_name => l_column_prefix||'_ATTRIBUTE39'
1268: , column_value => l_column_value
1269: );
1270:
1271: IF p_Line_Price_Attr_rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
1272: l_column_value := null;
1273: ELSE
1274: l_column_value := p_Line_Price_Attr_rec.pricing_attribute40;
1275: END IF;

Line 1282: IF p_Line_Price_Attr_rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN

1278: ( column_name => l_column_prefix||'_ATTRIBUTE40'
1279: , column_value => l_column_value
1280: );
1281:
1282: IF p_Line_Price_Attr_rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
1283: l_column_value := null;
1284: ELSE
1285: l_column_value := p_Line_Price_Attr_rec.pricing_attribute41;
1286: END IF;

Line 1293: IF p_Line_Price_Attr_rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN

1289: ( column_name => l_column_prefix||'_ATTRIBUTE41'
1290: , column_value => l_column_value
1291: );
1292:
1293: IF p_Line_Price_Attr_rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
1294: l_column_value := null;
1295: ELSE
1296: l_column_value := p_Line_Price_Attr_rec.pricing_attribute42;
1297: END IF;

Line 1304: IF p_Line_Price_Attr_rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN

1300: ( column_name => l_column_prefix||'_ATTRIBUTE42'
1301: , column_value => l_column_value
1302: );
1303:
1304: IF p_Line_Price_Attr_rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
1305: l_column_value := null;
1306: ELSE
1307: l_column_value := p_Line_Price_Attr_rec.pricing_attribute43;
1308: END IF;

Line 1315: IF p_Line_Price_Attr_rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN

1311: ( column_name => l_column_prefix||'_ATTRIBUTE43'
1312: , column_value => l_column_value
1313: );
1314:
1315: IF p_Line_Price_Attr_rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
1316: l_column_value := null;
1317: ELSE
1318: l_column_value := p_Line_Price_Attr_rec.pricing_attribute44;
1319: END IF;

Line 1326: IF p_Line_Price_Attr_rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN

1322: ( column_name => l_column_prefix||'_ATTRIBUTE44'
1323: , column_value => l_column_value
1324: );
1325:
1326: IF p_Line_Price_Attr_rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
1327: l_column_value := null;
1328: ELSE
1329: l_column_value := p_Line_Price_Attr_rec.pricing_attribute45;
1330: END IF;

Line 1337: IF p_Line_Price_Attr_rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN

1333: ( column_name => l_column_prefix||'_ATTRIBUTE45'
1334: , column_value => l_column_value
1335: );
1336:
1337: IF p_Line_Price_Attr_rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
1338: l_column_value := null;
1339: ELSE
1340: l_column_value := p_Line_Price_Attr_rec.pricing_attribute46;
1341: END IF;

Line 1348: IF p_Line_Price_Attr_rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN

1344: ( column_name => l_column_prefix||'_ATTRIBUTE46'
1345: , column_value => l_column_value
1346: );
1347:
1348: IF p_Line_Price_Attr_rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
1349: l_column_value := null;
1350: ELSE
1351: l_column_value := p_Line_Price_Attr_rec.pricing_attribute47;
1352: END IF;

Line 1359: IF p_Line_Price_Attr_rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN

1355: ( column_name => l_column_prefix||'_ATTRIBUTE47'
1356: , column_value => l_column_value
1357: );
1358:
1359: IF p_Line_Price_Attr_rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
1360: l_column_value := null;
1361: ELSE
1362: l_column_value := p_Line_Price_Attr_rec.pricing_attribute48;
1363: END IF;

Line 1370: IF p_Line_Price_Attr_rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN

1366: ( column_name => l_column_prefix||'_ATTRIBUTE48'
1367: , column_value => l_column_value
1368: );
1369:
1370: IF p_Line_Price_Attr_rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
1371: l_column_value := null;
1372: ELSE
1373: l_column_value := p_Line_Price_Attr_rec.pricing_attribute49;
1374: END IF;

Line 1381: IF p_Line_Price_Attr_rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN

1377: ( column_name => l_column_prefix||'_ATTRIBUTE49'
1378: , column_value => l_column_value
1379: );
1380:
1381: IF p_Line_Price_Attr_rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
1382: l_column_value := null;
1383: ELSE
1384: l_column_value := p_Line_Price_Attr_rec.pricing_attribute50;
1385: END IF;

Line 1392: IF p_Line_Price_Attr_rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN

1388: ( column_name => l_column_prefix||'_ATTRIBUTE50'
1389: , column_value => l_column_value
1390: );
1391:
1392: IF p_Line_Price_Attr_rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
1393: l_column_value := null;
1394: ELSE
1395: l_column_value := p_Line_Price_Attr_rec.pricing_attribute51;
1396: END IF;

Line 1403: IF p_Line_Price_Attr_rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN

1399: ( column_name => l_column_prefix||'_ATTRIBUTE51'
1400: , column_value => l_column_value
1401: );
1402:
1403: IF p_Line_Price_Attr_rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
1404: l_column_value := null;
1405: ELSE
1406: l_column_value := p_Line_Price_Attr_rec.pricing_attribute52;
1407: END IF;

Line 1414: IF p_Line_Price_Attr_rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN

1410: ( column_name => l_column_prefix||'_ATTRIBUTE52'
1411: , column_value => l_column_value
1412: );
1413:
1414: IF p_Line_Price_Attr_rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
1415: l_column_value := null;
1416: ELSE
1417: l_column_value := p_Line_Price_Attr_rec.pricing_attribute53;
1418: END IF;

Line 1425: IF p_Line_Price_Attr_rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN

1421: ( column_name => l_column_prefix||'_ATTRIBUTE53'
1422: , column_value => l_column_value
1423: );
1424:
1425: IF p_Line_Price_Attr_rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
1426: l_column_value := null;
1427: ELSE
1428: l_column_value := p_Line_Price_Attr_rec.pricing_attribute54;
1429: END IF;

Line 1436: IF p_Line_Price_Attr_rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN

1432: ( column_name => l_column_prefix||'_ATTRIBUTE54'
1433: , column_value => l_column_value
1434: );
1435:
1436: IF p_Line_Price_Attr_rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
1437: l_column_value := null;
1438: ELSE
1439: l_column_value := p_Line_Price_Attr_rec.pricing_attribute55;
1440: END IF;

Line 1447: IF p_Line_Price_Attr_rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN

1443: ( column_name => l_column_prefix||'_ATTRIBUTE55'
1444: , column_value => l_column_value
1445: );
1446:
1447: IF p_Line_Price_Attr_rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
1448: l_column_value := null;
1449: ELSE
1450: l_column_value := p_Line_Price_Attr_rec.pricing_attribute56;
1451: END IF;

Line 1458: IF p_Line_Price_Attr_rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN

1454: ( column_name => l_column_prefix||'_ATTRIBUTE56'
1455: , column_value => l_column_value
1456: );
1457:
1458: IF p_Line_Price_Attr_rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
1459: l_column_value := null;
1460: ELSE
1461: l_column_value := p_Line_Price_Attr_rec.pricing_attribute57;
1462: END IF;

Line 1469: IF p_Line_Price_Attr_rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN

1465: ( column_name => l_column_prefix||'_ATTRIBUTE57'
1466: , column_value => l_column_value
1467: );
1468:
1469: IF p_Line_Price_Attr_rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
1470: l_column_value := null;
1471: ELSE
1472: l_column_value := p_Line_Price_Attr_rec.pricing_attribute58;
1473: END IF;

Line 1480: IF p_Line_Price_Attr_rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN

1476: ( column_name => l_column_prefix||'_ATTRIBUTE58'
1477: , column_value => l_column_value
1478: );
1479:
1480: IF p_Line_Price_Attr_rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
1481: l_column_value := null;
1482: ELSE
1483: l_column_value := p_Line_Price_Attr_rec.pricing_attribute59;
1484: END IF;

Line 1491: IF p_Line_Price_Attr_rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN

1487: ( column_name => l_column_prefix||'_ATTRIBUTE59'
1488: , column_value => l_column_value
1489: );
1490:
1491: IF p_Line_Price_Attr_rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
1492: l_column_value := null;
1493: ELSE
1494: l_column_value := p_Line_Price_Attr_rec.pricing_attribute60;
1495: END IF;

Line 1502: IF p_Line_Price_Attr_rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN

1498: ( column_name => l_column_prefix||'_ATTRIBUTE60'
1499: , column_value => l_column_value
1500: );
1501:
1502: IF p_Line_Price_Attr_rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
1503: l_column_value := null;
1504: ELSE
1505: l_column_value := p_Line_Price_Attr_rec.pricing_attribute61;
1506: END IF;

Line 1513: IF p_Line_Price_Attr_rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN

1509: ( column_name => l_column_prefix||'_ATTRIBUTE61'
1510: , column_value => l_column_value
1511: );
1512:
1513: IF p_Line_Price_Attr_rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
1514: l_column_value := null;
1515: ELSE
1516: l_column_value := p_Line_Price_Attr_rec.pricing_attribute62;
1517: END IF;

Line 1524: IF p_Line_Price_Attr_rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN

1520: ( column_name => l_column_prefix||'_ATTRIBUTE62'
1521: , column_value => l_column_value
1522: );
1523:
1524: IF p_Line_Price_Attr_rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
1525: l_column_value := null;
1526: ELSE
1527: l_column_value := p_Line_Price_Attr_rec.pricing_attribute63;
1528: END IF;

Line 1535: IF p_Line_Price_Attr_rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN

1531: ( column_name => l_column_prefix||'_ATTRIBUTE63'
1532: , column_value => l_column_value
1533: );
1534:
1535: IF p_Line_Price_Attr_rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
1536: l_column_value := null;
1537: ELSE
1538: l_column_value := p_Line_Price_Attr_rec.pricing_attribute64;
1539: END IF;

Line 1546: IF p_Line_Price_Attr_rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN

1542: ( column_name => l_column_prefix||'_ATTRIBUTE64'
1543: , column_value => l_column_value
1544: );
1545:
1546: IF p_Line_Price_Attr_rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
1547: l_column_value := null;
1548: ELSE
1549: l_column_value := p_Line_Price_Attr_rec.pricing_attribute65;
1550: END IF;

Line 1557: IF p_Line_Price_Attr_rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN

1553: ( column_name => l_column_prefix||'_ATTRIBUTE65'
1554: , column_value => l_column_value
1555: );
1556:
1557: IF p_Line_Price_Attr_rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
1558: l_column_value := null;
1559: ELSE
1560: l_column_value := p_Line_Price_Attr_rec.pricing_attribute66;
1561: END IF;

Line 1568: IF p_Line_Price_Attr_rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN

1564: ( column_name => l_column_prefix||'_ATTRIBUTE66'
1565: , column_value => l_column_value
1566: );
1567:
1568: IF p_Line_Price_Attr_rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
1569: l_column_value := null;
1570: ELSE
1571: l_column_value := p_Line_Price_Attr_rec.pricing_attribute67;
1572: END IF;

Line 1579: IF p_Line_Price_Attr_rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN

1575: ( column_name => l_column_prefix||'_ATTRIBUTE67'
1576: , column_value => l_column_value
1577: );
1578:
1579: IF p_Line_Price_Attr_rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
1580: l_column_value := null;
1581: ELSE
1582: l_column_value := p_Line_Price_Attr_rec.pricing_attribute68;
1583: END IF;

Line 1590: IF p_Line_Price_Attr_rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN

1586: ( column_name => l_column_prefix||'_ATTRIBUTE68'
1587: , column_value => l_column_value
1588: );
1589:
1590: IF p_Line_Price_Attr_rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
1591: l_column_value := null;
1592: ELSE
1593: l_column_value := p_Line_Price_Attr_rec.pricing_attribute69;
1594: END IF;

Line 1601: IF p_Line_Price_Attr_rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN

1597: ( column_name => l_column_prefix||'_ATTRIBUTE69'
1598: , column_value => l_column_value
1599: );
1600:
1601: IF p_Line_Price_Attr_rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
1602: l_column_value := null;
1603: ELSE
1604: l_column_value := p_Line_Price_Attr_rec.pricing_attribute70;
1605: END IF;

Line 1612: IF p_Line_Price_Attr_rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN

1608: ( column_name => l_column_prefix||'_ATTRIBUTE70'
1609: , column_value => l_column_value
1610: );
1611:
1612: IF p_Line_Price_Attr_rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
1613: l_column_value := null;
1614: ELSE
1615: l_column_value := p_Line_Price_Attr_rec.pricing_attribute71;
1616: END IF;

Line 1623: IF p_Line_Price_Attr_rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN

1619: ( column_name => l_column_prefix||'_ATTRIBUTE71'
1620: , column_value => l_column_value
1621: );
1622:
1623: IF p_Line_Price_Attr_rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
1624: l_column_value := null;
1625: ELSE
1626: l_column_value := p_Line_Price_Attr_rec.pricing_attribute72;
1627: END IF;

Line 1634: IF p_Line_Price_Attr_rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN

1630: ( column_name => l_column_prefix||'_ATTRIBUTE72'
1631: , column_value => l_column_value
1632: );
1633:
1634: IF p_Line_Price_Attr_rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
1635: l_column_value := null;
1636: ELSE
1637: l_column_value := p_Line_Price_Attr_rec.pricing_attribute73;
1638: END IF;

Line 1645: IF p_Line_Price_Attr_rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN

1641: ( column_name => l_column_prefix||'_ATTRIBUTE73'
1642: , column_value => l_column_value
1643: );
1644:
1645: IF p_Line_Price_Attr_rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
1646: l_column_value := null;
1647: ELSE
1648: l_column_value := p_Line_Price_Attr_rec.pricing_attribute74;
1649: END IF;

Line 1656: IF p_Line_Price_Attr_rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN

1652: ( column_name => l_column_prefix||'_ATTRIBUTE74'
1653: , column_value => l_column_value
1654: );
1655:
1656: IF p_Line_Price_Attr_rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
1657: l_column_value := null;
1658: ELSE
1659: l_column_value := p_Line_Price_Attr_rec.pricing_attribute75;
1660: END IF;

Line 1667: IF p_Line_Price_Attr_rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN

1663: ( column_name => l_column_prefix||'_ATTRIBUTE75'
1664: , column_value => l_column_value
1665: );
1666:
1667: IF p_Line_Price_Attr_rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
1668: l_column_value := null;
1669: ELSE
1670: l_column_value := p_Line_Price_Attr_rec.pricing_attribute76;
1671: END IF;

Line 1678: IF p_Line_Price_Attr_rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN

1674: ( column_name => l_column_prefix||'_ATTRIBUTE76'
1675: , column_value => l_column_value
1676: );
1677:
1678: IF p_Line_Price_Attr_rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
1679: l_column_value := null;
1680: ELSE
1681: l_column_value := p_Line_Price_Attr_rec.pricing_attribute77;
1682: END IF;

Line 1689: IF p_Line_Price_Attr_rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN

1685: ( column_name => l_column_prefix||'_ATTRIBUTE77'
1686: , column_value => l_column_value
1687: );
1688:
1689: IF p_Line_Price_Attr_rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
1690: l_column_value := null;
1691: ELSE
1692: l_column_value := p_Line_Price_Attr_rec.pricing_attribute78;
1693: END IF;

Line 1700: IF p_Line_Price_Attr_rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN

1696: ( column_name => l_column_prefix||'_ATTRIBUTE78'
1697: , column_value => l_column_value
1698: );
1699:
1700: IF p_Line_Price_Attr_rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
1701: l_column_value := null;
1702: ELSE
1703: l_column_value := p_Line_Price_Attr_rec.pricing_attribute79;
1704: END IF;

Line 1711: IF p_Line_Price_Attr_rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN

1707: ( column_name => l_column_prefix||'_ATTRIBUTE79'
1708: , column_value => l_column_value
1709: );
1710:
1711: IF p_Line_Price_Attr_rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
1712: l_column_value := null;
1713: ELSE
1714: l_column_value := p_Line_Price_Attr_rec.pricing_attribute80;
1715: END IF;

Line 1722: IF p_Line_Price_Attr_rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN

1718: ( column_name => l_column_prefix||'_ATTRIBUTE80'
1719: , column_value => l_column_value
1720: );
1721:
1722: IF p_Line_Price_Attr_rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
1723: l_column_value := null;
1724: ELSE
1725: l_column_value := p_Line_Price_Attr_rec.pricing_attribute81;
1726: END IF;

Line 1733: IF p_Line_Price_Attr_rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN

1729: ( column_name => l_column_prefix||'_ATTRIBUTE81'
1730: , column_value => l_column_value
1731: );
1732:
1733: IF p_Line_Price_Attr_rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
1734: l_column_value := null;
1735: ELSE
1736: l_column_value := p_Line_Price_Attr_rec.pricing_attribute82;
1737: END IF;

Line 1744: IF p_Line_Price_Attr_rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN

1740: ( column_name => l_column_prefix||'_ATTRIBUTE82'
1741: , column_value => l_column_value
1742: );
1743:
1744: IF p_Line_Price_Attr_rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
1745: l_column_value := null;
1746: ELSE
1747: l_column_value := p_Line_Price_Attr_rec.pricing_attribute83;
1748: END IF;

Line 1755: IF p_Line_Price_Attr_rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN

1751: ( column_name => l_column_prefix||'_ATTRIBUTE83'
1752: , column_value => l_column_value
1753: );
1754:
1755: IF p_Line_Price_Attr_rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
1756: l_column_value := null;
1757: ELSE
1758: l_column_value := p_Line_Price_Attr_rec.pricing_attribute84;
1759: END IF;

Line 1766: IF p_Line_Price_Attr_rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN

1762: ( column_name => l_column_prefix||'_ATTRIBUTE84'
1763: , column_value => l_column_value
1764: );
1765:
1766: IF p_Line_Price_Attr_rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
1767: l_column_value := null;
1768: ELSE
1769: l_column_value := p_Line_Price_Attr_rec.pricing_attribute85;
1770: END IF;

Line 1777: IF p_Line_Price_Attr_rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN

1773: ( column_name => l_column_prefix||'_ATTRIBUTE85'
1774: , column_value => l_column_value
1775: );
1776:
1777: IF p_Line_Price_Attr_rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
1778: l_column_value := null;
1779: ELSE
1780: l_column_value := p_Line_Price_Attr_rec.pricing_attribute86;
1781: END IF;

Line 1788: IF p_Line_Price_Attr_rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN

1784: ( column_name => l_column_prefix||'_ATTRIBUTE86'
1785: , column_value => l_column_value
1786: );
1787:
1788: IF p_Line_Price_Attr_rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
1789: l_column_value := null;
1790: ELSE
1791: l_column_value := p_Line_Price_Attr_rec.pricing_attribute87;
1792: END IF;

Line 1799: IF p_Line_Price_Attr_rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN

1795: ( column_name => l_column_prefix||'_ATTRIBUTE87'
1796: , column_value => l_column_value
1797: );
1798:
1799: IF p_Line_Price_Attr_rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
1800: l_column_value := null;
1801: ELSE
1802: l_column_value := p_Line_Price_Attr_rec.pricing_attribute88;
1803: END IF;

Line 1810: IF p_Line_Price_Attr_rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN

1806: ( column_name => l_column_prefix||'_ATTRIBUTE88'
1807: , column_value => l_column_value
1808: );
1809:
1810: IF p_Line_Price_Attr_rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
1811: l_column_value := null;
1812: ELSE
1813: l_column_value := p_Line_Price_Attr_rec.pricing_attribute89;
1814: END IF;

Line 1821: IF p_Line_Price_Attr_rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN

1817: ( column_name => l_column_prefix||'_ATTRIBUTE89'
1818: , column_value => l_column_value
1819: );
1820:
1821: IF p_Line_Price_Attr_rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
1822: l_column_value := null;
1823: ELSE
1824: l_column_value := p_Line_Price_Attr_rec.pricing_attribute90;
1825: END IF;

Line 1832: IF p_Line_Price_Attr_rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN

1828: ( column_name => l_column_prefix||'_ATTRIBUTE90'
1829: , column_value => l_column_value
1830: );
1831:
1832: IF p_Line_Price_Attr_rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
1833: l_column_value := null;
1834: ELSE
1835: l_column_value := p_Line_Price_Attr_rec.pricing_attribute91;
1836: END IF;

Line 1843: IF p_Line_Price_Attr_rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN

1839: ( column_name => l_column_prefix||'_ATTRIBUTE91'
1840: , column_value => l_column_value
1841: );
1842:
1843: IF p_Line_Price_Attr_rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
1844: l_column_value := null;
1845: ELSE
1846: l_column_value := p_Line_Price_Attr_rec.pricing_attribute92;
1847: END IF;

Line 1854: IF p_Line_Price_Attr_rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN

1850: ( column_name => l_column_prefix||'_ATTRIBUTE92'
1851: , column_value => l_column_value
1852: );
1853:
1854: IF p_Line_Price_Attr_rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
1855: l_column_value := null;
1856: ELSE
1857: l_column_value := p_Line_Price_Attr_rec.pricing_attribute93;
1858: END IF;

Line 1865: IF p_Line_Price_Attr_rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN

1861: ( column_name => l_column_prefix||'_ATTRIBUTE93'
1862: , column_value => l_column_value
1863: );
1864:
1865: IF p_Line_Price_Attr_rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
1866: l_column_value := null;
1867: ELSE
1868: l_column_value := p_Line_Price_Attr_rec.pricing_attribute94;
1869: END IF;

Line 1876: IF p_Line_Price_Attr_rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN

1872: ( column_name => l_column_prefix||'_ATTRIBUTE94'
1873: , column_value => l_column_value
1874: );
1875:
1876: IF p_Line_Price_Attr_rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
1877: l_column_value := null;
1878: ELSE
1879: l_column_value := p_Line_Price_Attr_rec.pricing_attribute95;
1880: END IF;

Line 1887: IF p_Line_Price_Attr_rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN

1883: ( column_name => l_column_prefix||'_ATTRIBUTE95'
1884: , column_value => l_column_value
1885: );
1886:
1887: IF p_Line_Price_Attr_rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
1888: l_column_value := null;
1889: ELSE
1890: l_column_value := p_Line_Price_Attr_rec.pricing_attribute96;
1891: END IF;

Line 1898: IF p_Line_Price_Attr_rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN

1894: ( column_name => l_column_prefix||'_ATTRIBUTE96'
1895: , column_value => l_column_value
1896: );
1897:
1898: IF p_Line_Price_Attr_rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
1899: l_column_value := null;
1900: ELSE
1901: l_column_value := p_Line_Price_Attr_rec.pricing_attribute97;
1902: END IF;

Line 1909: IF p_Line_Price_Attr_rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN

1905: ( column_name => l_column_prefix||'_ATTRIBUTE97'
1906: , column_value => l_column_value
1907: );
1908:
1909: IF p_Line_Price_Attr_rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
1910: l_column_value := null;
1911: ELSE
1912: l_column_value := p_Line_Price_Attr_rec.pricing_attribute98;
1913: END IF;

Line 1920: IF p_Line_Price_Attr_rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN

1916: ( column_name => l_column_prefix||'_ATTRIBUTE98'
1917: , column_value => l_column_value
1918: );
1919:
1920: IF p_Line_Price_Attr_rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
1921: l_column_value := null;
1922: ELSE
1923: l_column_value := p_Line_Price_Attr_rec.pricing_attribute99;
1924: END IF;

Line 1931: IF p_Line_Price_Attr_rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN

1927: ( column_name => l_column_prefix||'_ATTRIBUTE99'
1928: , column_value => l_column_value
1929: );
1930:
1931: IF p_Line_Price_Attr_rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
1932: l_column_value := null;
1933: ELSE
1934: l_column_value := p_Line_Price_Attr_rec.pricing_attribute100;
1935: END IF;

Line 1960: x_return_status := FND_API.G_RET_STS_ERROR;

1956: p_line_price_attr_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
1957: -- don't raise error.
1958: null;
1959: ELSE
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: END IF;
1962: END IF;*/
1963: END IF;
1964: end if ; /* if OE_GLOBALS.g_validate_desc_flex ='Y' then --bug 4343612 */

Line 1969: WHEN FND_API.G_EXC_ERROR THEN

1965: -- Done validating attributes
1966:
1967: EXCEPTION
1968:
1969: WHEN FND_API.G_EXC_ERROR THEN
1970:
1971: x_return_status := FND_API.G_RET_STS_ERROR;
1972:
1973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1971: x_return_status := FND_API.G_RET_STS_ERROR;

1967: EXCEPTION
1968:
1969: WHEN FND_API.G_EXC_ERROR THEN
1970:
1971: x_return_status := FND_API.G_RET_STS_ERROR;
1972:
1973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1974:
1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1969: WHEN FND_API.G_EXC_ERROR THEN
1970:
1971: x_return_status := FND_API.G_RET_STS_ERROR;
1972:
1973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1974:
1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1976:
1977: WHEN OTHERS THEN

Line 1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1971: x_return_status := FND_API.G_RET_STS_ERROR;
1972:
1973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1974:
1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1976:
1977: WHEN OTHERS THEN
1978:
1979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1976:
1977: WHEN OTHERS THEN
1978:
1979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1980:
1981: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1982: THEN
1983: FND_MSG_PUB.Add_Exc_Msg

Line 1999: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1995:
1996: , p_Line_Price_Attr_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
1997: )
1998: IS
1999: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2000: --
2001: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2002: --
2003: BEGIN

Line 2013: RAISE FND_API.G_EXC_ERROR;

2009: -- lkxu: modified to prevent the user from deleting OTA pricing context.
2010: IF OE_GLOBALS.EQUAL(p_Line_Price_Attr_rec.pricing_context,'OTA') THEN
2011: FND_MESSAGE.SET_NAME('ONT','ONT_OTA_DELETE_NOT_ALLOWED');
2012: OE_MSG_PUB.ADD;
2013: RAISE FND_API.G_EXC_ERROR;
2014: END IF;
2015:
2016: x_return_status := l_return_status;
2017:

Line 2020: WHEN FND_API.G_EXC_ERROR THEN

2016: x_return_status := l_return_status;
2017:
2018: EXCEPTION
2019:
2020: WHEN FND_API.G_EXC_ERROR THEN
2021:
2022: x_return_status := FND_API.G_RET_STS_ERROR;
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2022: x_return_status := FND_API.G_RET_STS_ERROR;

2018: EXCEPTION
2019:
2020: WHEN FND_API.G_EXC_ERROR THEN
2021:
2022: x_return_status := FND_API.G_RET_STS_ERROR;
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025:
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2020: WHEN FND_API.G_EXC_ERROR THEN
2021:
2022: x_return_status := FND_API.G_RET_STS_ERROR;
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025:
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027:
2028: WHEN OTHERS THEN

Line 2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2022: x_return_status := FND_API.G_RET_STS_ERROR;
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025:
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027:
2028: WHEN OTHERS THEN
2029:
2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027:
2028: WHEN OTHERS THEN
2029:
2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2031:
2032: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2033: THEN
2034: FND_MSG_PUB.Add_Exc_Msg