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

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

14: , p_old_Header_Price_Attr_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
15: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
16: )
17: IS
18: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: --
20: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21: --
22: BEGIN

Line 33: l_return_status := FND_API.G_RET_STS_ERROR;

29:
30: IF p_Header_Price_Attr_rec.order_price_attrib_id IS NULL
31: THEN
32:
33: l_return_status := FND_API.G_RET_STS_ERROR;
34:
35: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
36: THEN
37:

Line 53: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 55: RAISE FND_API.G_EXC_ERROR;

51: -- Return Error if a required attribute is missing.
52:
53: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
54:
55: RAISE FND_API.G_EXC_ERROR;
56:
57: END IF;
58:
59: --

Line 78: WHEN FND_API.G_EXC_ERROR THEN

74: oe_debug_pub.add( 'EXITING OE_VALIDATE_HEADER_PATTR.ENTITY' , 1 ) ;
75: END IF;
76: EXCEPTION
77:
78: WHEN FND_API.G_EXC_ERROR THEN
79:
80: x_return_status := FND_API.G_RET_STS_ERROR;
81:
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 80: x_return_status := FND_API.G_RET_STS_ERROR;

76: EXCEPTION
77:
78: WHEN FND_API.G_EXC_ERROR THEN
79:
80: x_return_status := FND_API.G_RET_STS_ERROR;
81:
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83:
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

78: WHEN FND_API.G_EXC_ERROR THEN
79:
80: x_return_status := FND_API.G_RET_STS_ERROR;
81:
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83:
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85:
86: WHEN OTHERS THEN

Line 84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

80: x_return_status := FND_API.G_RET_STS_ERROR;
81:
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83:
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85:
86: WHEN OTHERS THEN
87:
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85:
86: WHEN OTHERS THEN
87:
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89:
90: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
91: THEN
92: FND_MSG_PUB.Add_Exc_Msg

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

103: ( x_return_status OUT NOCOPY VARCHAR2
104:
105: , p_Header_Price_Attr_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
106: , p_old_Header_Price_Attr_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
107: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
108: )
109: IS
110: l_column_prefix varchar2(20);
111: --

Line 119: x_return_status := FND_API.G_RET_STS_SUCCESS;

115:
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add( 'ENTERING OE_VALIDATE_HEADER_PATTR.ATTRIBUTES' , 1 ) ;
118: END IF;
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120:
121: -- Validate Line_Pricing_PAttr attributes
122:
123: IF p_Header_Price_Attr_rec.created_by IS NOT NULL AND

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: p_old_Header_Price_Attr_rec.created_by OR
126: p_old_Header_Price_Attr_rec.created_by IS NULL )
127: THEN
128: IF NOT OE_Validate_Adj.Created_By(p_Header_Price_Attr_rec.created_by) THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: END IF;
131: END IF;
132:
133: IF p_Header_Price_Attr_rec.creation_date IS NOT NULL AND

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: p_old_Header_Price_Attr_rec.creation_date IS NULL )
137: THEN
138: IF NOT OE_Validate_Adj.Creation_Date
139: (p_Header_Price_Attr_rec.creation_date) THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: END IF;
142: END IF;
143:
144: IF p_Header_Price_Attr_rec.flex_title IS NOT NULL AND

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: p_old_Header_Price_Attr_rec.flex_title IS NULL )
148: THEN
149: IF NOT OE_Validate_Adj.Flex_Title
150: (p_Header_Price_Attr_rec.flex_title) THEN
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: END IF;
153: END IF;
154:
155: IF p_Header_Price_Attr_rec.header_id IS NOT NULL AND

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

157: p_old_Header_Price_Attr_rec.header_id OR
158: p_old_Header_Price_Attr_rec.header_id IS NULL )
159: THEN
160: IF NOT OE_Validate_Adj.Header(p_Header_Price_Attr_rec.header_id) THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: END IF;
163: END IF;
164:
165: IF p_Header_Price_Attr_rec.last_updated_by IS NOT NULL AND

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: p_old_Header_Price_Attr_rec.last_updated_by IS NULL )
169: THEN
170: IF NOT OE_Validate_Adj.Last_Updated_By
171: (p_Header_Price_Attr_rec.last_updated_by) THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: END IF;
174: END IF;
175:
176: IF p_Header_Price_Attr_rec.last_update_date IS NOT NULL AND

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179: p_old_Header_Price_Attr_rec.last_update_date IS NULL )
180: THEN
181: IF NOT OE_Validate_Adj.Last_Update_Date
182: (p_Header_Price_Attr_rec.last_update_date) THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: END IF;
185: END IF;
186:
187: IF p_Header_Price_Attr_rec.last_update_login IS NOT NULL AND

Line 194: x_return_status := FND_API.G_RET_STS_ERROR;

190: p_old_Header_Price_Attr_rec.last_update_login IS NULL )
191: THEN
192: IF NOT OE_Validate_Adj.Last_Update_Login
193: (p_Header_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_Header_Price_Attr_rec.override_flag IS NOT NULL AND

Line 205: x_return_status := FND_API.G_RET_STS_ERROR;

201: p_old_Header_Price_Attr_rec.override_flag IS NULL )
202: THEN
203: IF NOT OE_Validate_Adj.Override_Flag
204: (p_Header_Price_Attr_rec.override_flag) THEN
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: END IF;
207: END IF;
208:
209:

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

212: p_old_Header_Price_Attr_rec.line_id OR
213: p_old_Header_Price_Attr_rec.line_id IS NULL )
214: THEN
215: IF NOT OE_Validate_Adj.Line(p_Header_Price_Attr_rec.line_id) THEN
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: END IF;
218: END IF;
219:
220: IF p_Header_Price_Attr_rec.order_price_attrib_id IS NOT NULL AND

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

223: p_old_Header_Price_Attr_rec.order_price_attrib_id IS NULL )
224: THEN
225: IF NOT OE_Validate_Adj.Order_Price_Attrib
226: (p_Header_Price_Attr_rec.order_price_attrib_id) THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: END IF;
229: END IF;
230:
231: IF p_Header_Price_Attr_rec.program_application_id IS NOT NULL AND

Line 238: x_return_status := FND_API.G_RET_STS_ERROR;

234: p_old_Header_Price_Attr_rec.program_application_id IS NULL )
235: THEN
236: IF NOT OE_Validate_Adj.Program_Application
237: (p_Header_Price_Attr_rec.program_application_id) THEN
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: END IF;
240: END IF;
241:
242: IF p_Header_Price_Attr_rec.program_id IS NOT NULL AND

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245: p_old_Header_Price_Attr_rec.program_id IS NULL )
246: THEN
247: IF NOT OE_Validate_Adj.Program
248: (p_Header_Price_Attr_rec.program_id) THEN
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: END IF;
251: END IF;
252:
253: IF p_Header_Price_Attr_rec.program_update_date IS NOT NULL AND

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

256: p_old_Header_Price_Attr_rec.program_update_date IS NULL )
257: THEN
258: IF NOT OE_Validate_Adj.Program_Update_Date
259: (p_Header_Price_Attr_rec.program_update_date) THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: END IF;
262: END IF;
263:
264: IF p_Header_Price_Attr_rec.request_id IS NOT NULL AND

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: p_old_Header_Price_Attr_rec.request_id IS NULL )
268: THEN
269: IF NOT OE_Validate_Adj.Request
270: (p_Header_Price_Attr_rec.request_id) THEN
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: END IF;
273: END IF;
274: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
275: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_PAttr.attributes ',1);

Line 1249: x_return_status := FND_API.G_RET_STS_ERROR;

1245: -- Validate descriptive flexfield.
1246: /* commented for bug#5679839
1247: IF NOT OE_Validate_adj.Desc_Flex( 'QP', p_Header_Price_Attr_rec.Flex_Title )
1248: THEN
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: END IF;
1251: */
1252: END IF;
1253: end if; -- bug4343612

Line 1261: WHEN FND_API.G_EXC_ERROR THEN

1257: oe_debug_pub.add( 'EXITING OE_VALIDATE_HEADER_PATTR.ATTRIBUTES' , 1 ) ;
1258: END IF;
1259: EXCEPTION
1260:
1261: WHEN FND_API.G_EXC_ERROR THEN
1262:
1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264:
1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1263: x_return_status := FND_API.G_RET_STS_ERROR;

1259: EXCEPTION
1260:
1261: WHEN FND_API.G_EXC_ERROR THEN
1262:
1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264:
1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1266:
1267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1261: WHEN FND_API.G_EXC_ERROR THEN
1262:
1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264:
1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1266:
1267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1268:
1269: WHEN OTHERS THEN

Line 1267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264:
1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1266:
1267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1268:
1269: WHEN OTHERS THEN
1270:
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1268:
1269: WHEN OTHERS THEN
1270:
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272:
1273: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1274: THEN
1275: FND_MSG_PUB.Add_Exc_Msg

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

1287:
1288: , p_Header_Price_Attr_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
1289: )
1290: IS
1291: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1292: --
1293: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1294: --
1295: BEGIN

Line 1307: WHEN FND_API.G_EXC_ERROR THEN

1303: x_return_status := l_return_status;
1304:
1305: EXCEPTION
1306:
1307: WHEN FND_API.G_EXC_ERROR THEN
1308:
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310:
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1309: x_return_status := FND_API.G_RET_STS_ERROR;

1305: EXCEPTION
1306:
1307: WHEN FND_API.G_EXC_ERROR THEN
1308:
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310:
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312:
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1307: WHEN FND_API.G_EXC_ERROR THEN
1308:
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310:
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312:
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314:
1315: WHEN OTHERS THEN

Line 1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310:
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312:
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314:
1315: WHEN OTHERS THEN
1316:
1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314:
1315: WHEN OTHERS THEN
1316:
1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1318:
1319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1320: THEN
1321: FND_MSG_PUB.Add_Exc_Msg