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_VALIDATE_LIMIT_BALANCES dependencies on QP_VALIDATE

Line 1: PACKAGE BODY QP_Validate_Limit_Balances AS

1: PACKAGE BODY QP_Validate_Limit_Balances AS
2: /* $Header: QPXLLMBB.pls 120.1 2005/06/08 04:12:10 appldev $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Limit_Balances';

2: /* $Header: QPXLLMBB.pls 120.1 2005/06/08 04:12:10 appldev $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Limit_Balances';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 109: IF NOT QP_Validate.Available_Amount(p_LIMIT_BALANCES_rec.available_amount) THEN

105: ( p_LIMIT_BALANCES_rec.available_amount <>
106: p_old_LIMIT_BALANCES_rec.available_amount OR
107: p_old_LIMIT_BALANCES_rec.available_amount IS NULL )
108: THEN
109: IF NOT QP_Validate.Available_Amount(p_LIMIT_BALANCES_rec.available_amount) THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: END IF;
112: END IF;
113:

Line 119: IF NOT QP_Validate.Consumed_Amount(p_LIMIT_BALANCES_rec.consumed_amount) THEN

115: ( p_LIMIT_BALANCES_rec.consumed_amount <>
116: p_old_LIMIT_BALANCES_rec.consumed_amount OR
117: p_old_LIMIT_BALANCES_rec.consumed_amount IS NULL )
118: THEN
119: IF NOT QP_Validate.Consumed_Amount(p_LIMIT_BALANCES_rec.consumed_amount) THEN
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: END IF;
122: END IF;
123:

Line 129: IF NOT QP_Validate.Created_By(p_LIMIT_BALANCES_rec.created_by) THEN

125: ( p_LIMIT_BALANCES_rec.created_by <>
126: p_old_LIMIT_BALANCES_rec.created_by OR
127: p_old_LIMIT_BALANCES_rec.created_by IS NULL )
128: THEN
129: IF NOT QP_Validate.Created_By(p_LIMIT_BALANCES_rec.created_by) THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: END IF;
132: END IF;
133:

Line 139: IF NOT QP_Validate.Creation_Date(p_LIMIT_BALANCES_rec.creation_date) THEN

135: ( p_LIMIT_BALANCES_rec.creation_date <>
136: p_old_LIMIT_BALANCES_rec.creation_date OR
137: p_old_LIMIT_BALANCES_rec.creation_date IS NULL )
138: THEN
139: IF NOT QP_Validate.Creation_Date(p_LIMIT_BALANCES_rec.creation_date) THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: END IF;
142: END IF;
143:

Line 149: IF NOT QP_Validate.Last_Updated_By(p_LIMIT_BALANCES_rec.last_updated_by) THEN

145: ( p_LIMIT_BALANCES_rec.last_updated_by <>
146: p_old_LIMIT_BALANCES_rec.last_updated_by OR
147: p_old_LIMIT_BALANCES_rec.last_updated_by IS NULL )
148: THEN
149: IF NOT QP_Validate.Last_Updated_By(p_LIMIT_BALANCES_rec.last_updated_by) THEN
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: END IF;
152: END IF;
153:

Line 159: IF NOT QP_Validate.Last_Update_Date(p_LIMIT_BALANCES_rec.last_update_date) THEN

155: ( p_LIMIT_BALANCES_rec.last_update_date <>
156: p_old_LIMIT_BALANCES_rec.last_update_date OR
157: p_old_LIMIT_BALANCES_rec.last_update_date IS NULL )
158: THEN
159: IF NOT QP_Validate.Last_Update_Date(p_LIMIT_BALANCES_rec.last_update_date) THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: END IF;
162: END IF;
163:

Line 169: IF NOT QP_Validate.Last_Update_Login(p_LIMIT_BALANCES_rec.last_update_login) THEN

165: ( p_LIMIT_BALANCES_rec.last_update_login <>
166: p_old_LIMIT_BALANCES_rec.last_update_login OR
167: p_old_LIMIT_BALANCES_rec.last_update_login IS NULL )
168: THEN
169: IF NOT QP_Validate.Last_Update_Login(p_LIMIT_BALANCES_rec.last_update_login) THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: END IF;
172: END IF;
173:

Line 179: IF NOT QP_Validate.Limit_Balance(p_LIMIT_BALANCES_rec.limit_balance_id) THEN

175: ( p_LIMIT_BALANCES_rec.limit_balance_id <>
176: p_old_LIMIT_BALANCES_rec.limit_balance_id OR
177: p_old_LIMIT_BALANCES_rec.limit_balance_id IS NULL )
178: THEN
179: IF NOT QP_Validate.Limit_Balance(p_LIMIT_BALANCES_rec.limit_balance_id) THEN
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: END IF;
182: END IF;
183:

Line 189: IF NOT QP_Validate.Limit(p_LIMIT_BALANCES_rec.limit_id) THEN

185: ( p_LIMIT_BALANCES_rec.limit_id <>
186: p_old_LIMIT_BALANCES_rec.limit_id OR
187: p_old_LIMIT_BALANCES_rec.limit_id IS NULL )
188: THEN
189: IF NOT QP_Validate.Limit(p_LIMIT_BALANCES_rec.limit_id) THEN
190: x_return_status := FND_API.G_RET_STS_ERROR;
191: END IF;
192: END IF;
193:

Line 199: IF NOT QP_Validate.Multival_Attr1_Type(p_LIMIT_BALANCES_rec.multival_attr1_type) THEN

195: ( p_LIMIT_BALANCES_rec.multival_attr1_type <>
196: p_old_LIMIT_BALANCES_rec.multival_attr1_type OR
197: p_old_LIMIT_BALANCES_rec.multival_attr1_type IS NULL )
198: THEN
199: IF NOT QP_Validate.Multival_Attr1_Type(p_LIMIT_BALANCES_rec.multival_attr1_type) THEN
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: END IF;
202: END IF;
203:

Line 209: IF NOT QP_Validate.Multival_Attr1_Context(p_LIMIT_BALANCES_rec.multival_attr1_context) THEN

205: ( p_LIMIT_BALANCES_rec.multival_attr1_context <>
206: p_old_LIMIT_BALANCES_rec.multival_attr1_context OR
207: p_old_LIMIT_BALANCES_rec.multival_attr1_context IS NULL )
208: THEN
209: IF NOT QP_Validate.Multival_Attr1_Context(p_LIMIT_BALANCES_rec.multival_attr1_context) THEN
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: END IF;
212: END IF;
213:

Line 219: IF NOT QP_Validate.Multival_Attribute1(p_LIMIT_BALANCES_rec.multival_attribute1) THEN

215: ( p_LIMIT_BALANCES_rec.multival_attribute1 <>
216: p_old_LIMIT_BALANCES_rec.multival_attribute1 OR
217: p_old_LIMIT_BALANCES_rec.multival_attribute1 IS NULL )
218: THEN
219: IF NOT QP_Validate.Multival_Attribute1(p_LIMIT_BALANCES_rec.multival_attribute1) THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: END IF;
222: END IF;
223:

Line 229: IF NOT QP_Validate.Multival_Attr1_Value(p_LIMIT_BALANCES_rec.multival_attr1_value) THEN

225: ( p_LIMIT_BALANCES_rec.multival_attr1_value <>
226: p_old_LIMIT_BALANCES_rec.multival_attr1_value OR
227: p_old_LIMIT_BALANCES_rec.multival_attr1_value IS NULL )
228: THEN
229: IF NOT QP_Validate.Multival_Attr1_Value(p_LIMIT_BALANCES_rec.multival_attr1_value) THEN
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: END IF;
232: END IF;
233:

Line 239: IF NOT QP_Validate.Multival_Attr1_Datatype(p_LIMIT_BALANCES_rec.multival_attr1_datatype) THEN

235: ( p_LIMIT_BALANCES_rec.multival_attr1_datatype <>
236: p_old_LIMIT_BALANCES_rec.multival_attr1_datatype OR
237: p_old_LIMIT_BALANCES_rec.multival_attr1_datatype IS NULL )
238: THEN
239: IF NOT QP_Validate.Multival_Attr1_Datatype(p_LIMIT_BALANCES_rec.multival_attr1_datatype) THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: END IF;
242: END IF;
243:

Line 249: IF NOT QP_Validate.Multival_Attr2_Type(p_LIMIT_BALANCES_rec.multival_attr2_type) THEN

245: ( p_LIMIT_BALANCES_rec.multival_attr2_type <>
246: p_old_LIMIT_BALANCES_rec.multival_attr2_type OR
247: p_old_LIMIT_BALANCES_rec.multival_attr2_type IS NULL )
248: THEN
249: IF NOT QP_Validate.Multival_Attr2_Type(p_LIMIT_BALANCES_rec.multival_attr2_type) THEN
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: END IF;
252: END IF;
253:

Line 259: IF NOT QP_Validate.Multival_Attr2_Context(p_LIMIT_BALANCES_rec.multival_attr2_context) THEN

255: ( p_LIMIT_BALANCES_rec.multival_attr2_context <>
256: p_old_LIMIT_BALANCES_rec.multival_attr2_context OR
257: p_old_LIMIT_BALANCES_rec.multival_attr2_context IS NULL )
258: THEN
259: IF NOT QP_Validate.Multival_Attr2_Context(p_LIMIT_BALANCES_rec.multival_attr2_context) THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: END IF;
262: END IF;
263:

Line 269: IF NOT QP_Validate.Multival_Attribute2(p_LIMIT_BALANCES_rec.multival_attribute2) THEN

265: ( p_LIMIT_BALANCES_rec.multival_attribute2 <>
266: p_old_LIMIT_BALANCES_rec.multival_attribute2 OR
267: p_old_LIMIT_BALANCES_rec.multival_attribute2 IS NULL )
268: THEN
269: IF NOT QP_Validate.Multival_Attribute2(p_LIMIT_BALANCES_rec.multival_attribute2) THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: END IF;
272: END IF;
273:

Line 279: IF NOT QP_Validate.Multival_Attr2_Value(p_LIMIT_BALANCES_rec.multival_attr2_value) THEN

275: ( p_LIMIT_BALANCES_rec.multival_attr2_value <>
276: p_old_LIMIT_BALANCES_rec.multival_attr2_value OR
277: p_old_LIMIT_BALANCES_rec.multival_attr2_value IS NULL )
278: THEN
279: IF NOT QP_Validate.Multival_Attr2_Value(p_LIMIT_BALANCES_rec.multival_attr2_value) THEN
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: END IF;
282: END IF;
283:

Line 289: IF NOT QP_Validate.Multival_Attr2_Datatype(p_LIMIT_BALANCES_rec.multival_attr2_datatype) THEN

285: ( p_LIMIT_BALANCES_rec.multival_attr2_datatype <>
286: p_old_LIMIT_BALANCES_rec.multival_attr2_datatype OR
287: p_old_LIMIT_BALANCES_rec.multival_attr2_datatype IS NULL )
288: THEN
289: IF NOT QP_Validate.Multival_Attr2_Datatype(p_LIMIT_BALANCES_rec.multival_attr2_datatype) THEN
290: x_return_status := FND_API.G_RET_STS_ERROR;
291: END IF;
292: END IF;
293:

Line 299: IF NOT QP_Validate.Organization_Attr_Context(p_LIMIT_BALANCES_rec.organization_attr_context) THEN

295: ( p_LIMIT_BALANCES_rec.organization_attr_context <>
296: p_old_LIMIT_BALANCES_rec.organization_attr_context OR
297: p_old_LIMIT_BALANCES_rec.organization_attr_context IS NULL )
298: THEN
299: IF NOT QP_Validate.Organization_Attr_Context(p_LIMIT_BALANCES_rec.organization_attr_context) THEN
300: x_return_status := FND_API.G_RET_STS_ERROR;
301: END IF;
302: END IF;
303:

Line 309: IF NOT QP_Validate.Organization_Attribute(p_LIMIT_BALANCES_rec.organization_attribute) THEN

305: ( p_LIMIT_BALANCES_rec.organization_attribute <>
306: p_old_LIMIT_BALANCES_rec.organization_attribute OR
307: p_old_LIMIT_BALANCES_rec.organization_attribute IS NULL )
308: THEN
309: IF NOT QP_Validate.Organization_Attribute(p_LIMIT_BALANCES_rec.organization_attribute) THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: END IF;
312: END IF;
313:

Line 319: IF NOT QP_Validate.Organization_Attr_Value(p_LIMIT_BALANCES_rec.organization_attr_value) THEN

315: ( p_LIMIT_BALANCES_rec.organization_attr_value <>
316: p_old_LIMIT_BALANCES_rec.organization_attr_value OR
317: p_old_LIMIT_BALANCES_rec.organization_attr_value IS NULL )
318: THEN
319: IF NOT QP_Validate.Organization_Attr_Value(p_LIMIT_BALANCES_rec.organization_attr_value) THEN
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: END IF;
322: END IF;
323:

Line 329: IF NOT QP_Validate.Program_Application(p_LIMIT_BALANCES_rec.program_application_id) THEN

325: ( p_LIMIT_BALANCES_rec.program_application_id <>
326: p_old_LIMIT_BALANCES_rec.program_application_id OR
327: p_old_LIMIT_BALANCES_rec.program_application_id IS NULL )
328: THEN
329: IF NOT QP_Validate.Program_Application(p_LIMIT_BALANCES_rec.program_application_id) THEN
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: END IF;
332: END IF;
333:

Line 339: IF NOT QP_Validate.Program(p_LIMIT_BALANCES_rec.program_id) THEN

335: ( p_LIMIT_BALANCES_rec.program_id <>
336: p_old_LIMIT_BALANCES_rec.program_id OR
337: p_old_LIMIT_BALANCES_rec.program_id IS NULL )
338: THEN
339: IF NOT QP_Validate.Program(p_LIMIT_BALANCES_rec.program_id) THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: END IF;
342: END IF;
343:

Line 349: IF NOT QP_Validate.Program_Update_Date(p_LIMIT_BALANCES_rec.program_update_date) THEN

345: ( p_LIMIT_BALANCES_rec.program_update_date <>
346: p_old_LIMIT_BALANCES_rec.program_update_date OR
347: p_old_LIMIT_BALANCES_rec.program_update_date IS NULL )
348: THEN
349: IF NOT QP_Validate.Program_Update_Date(p_LIMIT_BALANCES_rec.program_update_date) THEN
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: END IF;
352: END IF;
353:

Line 359: IF NOT QP_Validate.Request(p_LIMIT_BALANCES_rec.request_id) THEN

355: ( p_LIMIT_BALANCES_rec.request_id <>
356: p_old_LIMIT_BALANCES_rec.request_id OR
357: p_old_LIMIT_BALANCES_rec.request_id IS NULL )
358: THEN
359: IF NOT QP_Validate.Request(p_LIMIT_BALANCES_rec.request_id) THEN
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: END IF;
362: END IF;
363:

Line 369: IF NOT QP_Validate.Reserved_Amount(p_LIMIT_BALANCES_rec.reserved_amount) THEN

365: ( p_LIMIT_BALANCES_rec.reserved_amount <>
366: p_old_LIMIT_BALANCES_rec.reserved_amount OR
367: p_old_LIMIT_BALANCES_rec.reserved_amount IS NULL )
368: THEN
369: IF NOT QP_Validate.Reserved_Amount(p_LIMIT_BALANCES_rec.reserved_amount) THEN
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: END IF;
372: END IF;
373:

Line 511: IF NOT QP_Validate.Desc_Flex( 'LIMIT_BALANCES' ) THEN

507: */
508:
509: -- Validate descriptive flexfield.
510:
511: IF NOT QP_Validate.Desc_Flex( 'LIMIT_BALANCES' ) THEN
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: END IF;
514:
515: END IF;

Line 585: END QP_Validate_Limit_Balances;

581: END IF;
582:
583: END Entity_Delete;
584:
585: END QP_Validate_Limit_Balances;