DBA Data[Home] [Help]

APPS.QP_VALIDATE_LIMIT_BALANCES dependencies on FND_API

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

13: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
14: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: BEGIN
19:
20: -- Check required attributes.
21:

Line 25: l_return_status := FND_API.G_RET_STS_ERROR;

21:
22: IF p_LIMIT_BALANCES_rec.limit_balance_id IS NULL
23: THEN
24:
25: l_return_status := FND_API.G_RET_STS_ERROR;
26:
27: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
28: THEN
29:

Line 45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 47: RAISE FND_API.G_EXC_ERROR;

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

Line 67: WHEN FND_API.G_EXC_ERROR THEN

63: x_return_status := l_return_status;
64:
65: EXCEPTION
66:
67: WHEN FND_API.G_EXC_ERROR THEN
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 69: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74:
75: WHEN OTHERS THEN
76:
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78:
79: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
80: THEN
81: OE_MSG_PUB.Add_Exc_Msg

Line 100: x_return_status := FND_API.G_RET_STS_SUCCESS;

96: )
97: IS
98: BEGIN
99:
100: x_return_status := FND_API.G_RET_STS_SUCCESS;
101:
102: -- Validate LIMIT_BALANCES attributes
103:
104: IF p_LIMIT_BALANCES_rec.available_amount IS NOT NULL AND

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

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:
114: IF p_LIMIT_BALANCES_rec.consumed_amount IS NOT NULL AND

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

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:
124: IF p_LIMIT_BALANCES_rec.created_by IS NOT NULL AND

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

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:
134: IF p_LIMIT_BALANCES_rec.creation_date IS NOT NULL AND

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

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:
144: IF p_LIMIT_BALANCES_rec.last_updated_by IS NOT NULL AND

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

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:
154: IF p_LIMIT_BALANCES_rec.last_update_date IS NOT NULL AND

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

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:
164: IF p_LIMIT_BALANCES_rec.last_update_login IS NOT NULL AND

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

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:
174: IF p_LIMIT_BALANCES_rec.limit_balance_id IS NOT NULL AND

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

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:
184: IF p_LIMIT_BALANCES_rec.limit_id IS NOT NULL AND

Line 190: x_return_status := FND_API.G_RET_STS_ERROR;

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:
194: IF p_LIMIT_BALANCES_rec.multival_attr1_type IS NOT NULL AND

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

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:
204: IF p_LIMIT_BALANCES_rec.multival_attr1_context IS NOT NULL AND

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

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:
214: IF p_LIMIT_BALANCES_rec.multival_attribute1 IS NOT NULL AND

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

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:
224: IF p_LIMIT_BALANCES_rec.multival_attr1_value IS NOT NULL AND

Line 230: x_return_status := FND_API.G_RET_STS_ERROR;

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:
234: IF p_LIMIT_BALANCES_rec.multival_attr1_datatype IS NOT NULL AND

Line 240: x_return_status := FND_API.G_RET_STS_ERROR;

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:
244: IF p_LIMIT_BALANCES_rec.multival_attr2_type IS NOT NULL AND

Line 250: x_return_status := FND_API.G_RET_STS_ERROR;

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:
254: IF p_LIMIT_BALANCES_rec.multival_attr2_context IS NOT NULL AND

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

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:
264: IF p_LIMIT_BALANCES_rec.multival_attribute2 IS NOT NULL AND

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

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:
274: IF p_LIMIT_BALANCES_rec.multival_attr2_value IS NOT NULL AND

Line 280: x_return_status := FND_API.G_RET_STS_ERROR;

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:
284: IF p_LIMIT_BALANCES_rec.multival_attr2_datatype IS NOT NULL AND

Line 290: x_return_status := FND_API.G_RET_STS_ERROR;

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:
294: IF p_LIMIT_BALANCES_rec.organization_attr_context IS NOT NULL AND

Line 300: x_return_status := FND_API.G_RET_STS_ERROR;

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:
304: IF p_LIMIT_BALANCES_rec.organization_attribute IS NOT NULL AND

Line 310: x_return_status := FND_API.G_RET_STS_ERROR;

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:
314: IF p_LIMIT_BALANCES_rec.organization_attr_value IS NOT NULL AND

Line 320: x_return_status := FND_API.G_RET_STS_ERROR;

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:
324: IF p_LIMIT_BALANCES_rec.program_application_id IS NOT NULL AND

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

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:
334: IF p_LIMIT_BALANCES_rec.program_id IS NOT NULL AND

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

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:
344: IF p_LIMIT_BALANCES_rec.program_update_date IS NOT NULL AND

Line 350: x_return_status := FND_API.G_RET_STS_ERROR;

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:
354: IF p_LIMIT_BALANCES_rec.request_id IS NOT NULL AND

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

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:
364: IF p_LIMIT_BALANCES_rec.reserved_amount IS NOT NULL AND

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

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:
374: IF (p_LIMIT_BALANCES_rec.attribute1 IS NOT NULL AND

Line 512: x_return_status := FND_API.G_RET_STS_ERROR;

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;
516:

Line 521: WHEN FND_API.G_EXC_ERROR THEN

517: -- Done validating attributes
518:
519: EXCEPTION
520:
521: WHEN FND_API.G_EXC_ERROR THEN
522:
523: x_return_status := FND_API.G_RET_STS_ERROR;
524:
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 523: x_return_status := FND_API.G_RET_STS_ERROR;

519: EXCEPTION
520:
521: WHEN FND_API.G_EXC_ERROR THEN
522:
523: x_return_status := FND_API.G_RET_STS_ERROR;
524:
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526:
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

521: WHEN FND_API.G_EXC_ERROR THEN
522:
523: x_return_status := FND_API.G_RET_STS_ERROR;
524:
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526:
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528:
529: WHEN OTHERS THEN

Line 527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

523: x_return_status := FND_API.G_RET_STS_ERROR;
524:
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526:
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528:
529: WHEN OTHERS THEN
530:
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528:
529: WHEN OTHERS THEN
530:
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532:
533: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
534: THEN
535: OE_MSG_PUB.Add_Exc_Msg

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

546: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
547: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
548: )
549: IS
550: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
551: BEGIN
552:
553: -- Validate entity delete.
554:

Line 563: WHEN FND_API.G_EXC_ERROR THEN

559: x_return_status := l_return_status;
560:
561: EXCEPTION
562:
563: WHEN FND_API.G_EXC_ERROR THEN
564:
565: x_return_status := FND_API.G_RET_STS_ERROR;
566:
567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 565: x_return_status := FND_API.G_RET_STS_ERROR;

561: EXCEPTION
562:
563: WHEN FND_API.G_EXC_ERROR THEN
564:
565: x_return_status := FND_API.G_RET_STS_ERROR;
566:
567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
568:
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

563: WHEN FND_API.G_EXC_ERROR THEN
564:
565: x_return_status := FND_API.G_RET_STS_ERROR;
566:
567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
568:
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570:
571: WHEN OTHERS THEN

Line 569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

565: x_return_status := FND_API.G_RET_STS_ERROR;
566:
567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
568:
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570:
571: WHEN OTHERS THEN
572:
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570:
571: WHEN OTHERS THEN
572:
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574:
575: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
576: THEN
577: OE_MSG_PUB.Add_Exc_Msg