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

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

13: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_dummy_c VARCHAR2(1);
19: BEGIN
20:
21: -- oe_debug_pub.add('VALIDATIONS: Inside Header L Package');

Line 28: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 60: l_return_status := FND_API.G_RET_STS_ERROR;

56: and nvl(end_date_active,trunc(sysdate));
57:
58: EXCEPTION
59: WHEN NO_DATA_FOUND THEN
60: l_return_status := FND_API.G_RET_STS_ERROR;
61: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CURRENCY');
62: OE_MSG_PUB.Add;
63:
64: END;

Line 68: p_CURR_LISTS_rec.base_markup_operator <> FND_API.G_MISS_CHAR)

64: END;
65:
66: -- Validate header records' base_markup_operator
67: IF (p_CURR_LISTS_rec.base_markup_operator IS NOT NULL and
68: p_CURR_LISTS_rec.base_markup_operator <> FND_API.G_MISS_CHAR)
69: THEN
70: BEGIN
71: -- oe_debug_pub.add('VALIDATE Headers base_markup_operator');
72:

Line 85: l_return_status := FND_API.G_RET_STS_ERROR;

81:
82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN
84: -- oe_debug_pub.add('ERROR: Base Markup_Operator is Invalid');
85: l_return_status := FND_API.G_RET_STS_ERROR;
86: FND_MESSAGE.SET_NAME('QP','QP_INVALID_MARKUP_OPRTR'); -- CHANGE MESG_CODE
87: FND_MESSAGE.SET_TOKEN('MARKUP_OPERATOR',p_CURR_LISTS_rec.base_markup_operator);
88: OE_MSG_PUB.Add;
89:

Line 95: p_CURR_LISTS_rec.base_markup_formula_id <> FND_API.G_MISS_NUM)

91: END IF;
92:
93: -- Validate header records' base_markup_formula
94: IF (p_CURR_LISTS_rec.base_markup_formula_id IS NOT NULL and
95: p_CURR_LISTS_rec.base_markup_formula_id <> FND_API.G_MISS_NUM)
96: THEN
97: BEGIN
98: -- oe_debug_pub.add('VALIDATE Headers base_markup_formula');
99:

Line 126: l_return_status := FND_API.G_RET_STS_ERROR;

122: and nvl(fl.end_date_active, trunc(sysdate)));
123:
124: EXCEPTION
125: WHEN NO_DATA_FOUND THEN
126: l_return_status := FND_API.G_RET_STS_ERROR;
127: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_NOT_FOUND');
128: OE_MSG_PUB.Add;
129:
130: END;

Line 136: p_CURR_LISTS_rec.base_markup_operator <> FND_API.G_MISS_CHAR) AND

132:
133: -- Validate header records' conditional columns
134: -- Markup value or formula should be present if operator is present
135: IF ((p_CURR_LISTS_rec.base_markup_operator IS NOT NULL and
136: p_CURR_LISTS_rec.base_markup_operator <> FND_API.G_MISS_CHAR) AND
137: (p_CURR_LISTS_rec.base_markup_formula_id IS NULL AND
138: p_CURR_LISTS_rec.base_markup_value IS NULL)
139: )
140: THEN

Line 142: l_return_status := FND_API.G_RET_STS_ERROR;

138: p_CURR_LISTS_rec.base_markup_value IS NULL)
139: )
140: THEN
141: -- oe_debug_pub.add('ERROR: Markup Formula or Value should be provided if Markup Operator is present');
142: l_return_status := FND_API.G_RET_STS_ERROR;
143: FND_MESSAGE.SET_NAME('QP','QP_FRML_OR_VAL_REQD'); -- CHANGE MESG_CODE
144: OE_MSG_PUB.Add;
145: END IF;
146:

Line 154: l_return_status := FND_API.G_RET_STS_ERROR;

150: p_CURR_LISTS_rec.base_markup_value IS NOT NULL)
151: )
152: THEN
153: -- oe_debug_pub.add('ERROR: Markup Formula or Value can be provided only if Markup Operator is present');
154: l_return_status := FND_API.G_RET_STS_ERROR;
155: FND_MESSAGE.SET_NAME('QP','QP_MARKUP_OPRTR_REQD'); -- CHANGE MESG_CODE
156: OE_MSG_PUB.Add;
157: END IF;
158:

Line 165: l_return_status := FND_API.G_RET_STS_ERROR;

161: p_CURR_LISTS_rec.base_currency_code IS NOT NULL THEN
162: IF NOT QP_Validate.Rounding_Factor(p_CURR_LISTS_rec.base_rounding_factor,
163: p_CURR_LISTS_rec.base_currency_code) THEN
164: oe_debug_pub.add('QPXLCURB.ENTITY base rounding_factor error occured');
165: l_return_status := FND_API.G_RET_STS_ERROR;
166: END IF;
167: END IF;
168: -- Bug 2293974 - rounding factor is mandatory
169: If (p_CURR_LISTS_rec.base_rounding_factor is NULL or

Line 170: p_CURR_LISTS_rec.base_rounding_factor = FND_API.G_MISS_NUM )

166: END IF;
167: END IF;
168: -- Bug 2293974 - rounding factor is mandatory
169: If (p_CURR_LISTS_rec.base_rounding_factor is NULL or
170: p_CURR_LISTS_rec.base_rounding_factor = FND_API.G_MISS_NUM )
171: then
172: l_return_status := FND_API.G_RET_STS_ERROR;
173:
174: FND_MESSAGE.SET_NAME('QP','QP_RNDG_FACTOR_REQD');

Line 172: l_return_status := FND_API.G_RET_STS_ERROR;

168: -- Bug 2293974 - rounding factor is mandatory
169: If (p_CURR_LISTS_rec.base_rounding_factor is NULL or
170: p_CURR_LISTS_rec.base_rounding_factor = FND_API.G_MISS_NUM )
171: then
172: l_return_status := FND_API.G_RET_STS_ERROR;
173:
174: FND_MESSAGE.SET_NAME('QP','QP_RNDG_FACTOR_REQD');
175: oe_msg_pub.add;
176:

Line 180: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

176:
177: end if;
178: -- Return Error if a required attribute is missing.
179:
180: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
181:
182: RAISE FND_API.G_EXC_ERROR;
183:
184: END IF;

Line 182: RAISE FND_API.G_EXC_ERROR;

178: -- Return Error if a required attribute is missing.
179:
180: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
181:
182: RAISE FND_API.G_EXC_ERROR;
183:
184: END IF;
185:
186: --

Line 202: WHEN FND_API.G_EXC_ERROR THEN

198: x_return_status := l_return_status;
199:
200: EXCEPTION
201:
202: WHEN FND_API.G_EXC_ERROR THEN
203:
204: x_return_status := FND_API.G_RET_STS_ERROR;
205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 204: x_return_status := FND_API.G_RET_STS_ERROR;

200: EXCEPTION
201:
202: WHEN FND_API.G_EXC_ERROR THEN
203:
204: x_return_status := FND_API.G_RET_STS_ERROR;
205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
207:
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

202: WHEN FND_API.G_EXC_ERROR THEN
203:
204: x_return_status := FND_API.G_RET_STS_ERROR;
205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
207:
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209:
210: WHEN OTHERS THEN

Line 208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

204: x_return_status := FND_API.G_RET_STS_ERROR;
205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
207:
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209:
210: WHEN OTHERS THEN
211:
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209:
210: WHEN OTHERS THEN
211:
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213:
214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
215: THEN
216: OE_MSG_PUB.Add_Exc_Msg

Line 235: x_return_status := FND_API.G_RET_STS_SUCCESS;

231: )
232: IS
233: BEGIN
234:
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236:
237: -- Validate CURR_LISTS attributes
238:
239: IF p_CURR_LISTS_rec.base_currency_code IS NOT NULL AND

Line 245: x_return_status := FND_API.G_RET_STS_ERROR;

241: p_old_CURR_LISTS_rec.base_currency_code OR
242: p_old_CURR_LISTS_rec.base_currency_code IS NULL )
243: THEN
244: IF NOT QP_Validate.Base_Currency(p_CURR_LISTS_rec.base_currency_code) THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: END IF;
247: END IF;
248:
249: IF p_CURR_LISTS_rec.created_by IS NOT NULL AND

Line 255: x_return_status := FND_API.G_RET_STS_ERROR;

251: p_old_CURR_LISTS_rec.created_by OR
252: p_old_CURR_LISTS_rec.created_by IS NULL )
253: THEN
254: IF NOT QP_Validate.Created_By(p_CURR_LISTS_rec.created_by) THEN
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: END IF;
257: END IF;
258:
259: IF p_CURR_LISTS_rec.creation_date IS NOT NULL AND

Line 265: x_return_status := FND_API.G_RET_STS_ERROR;

261: p_old_CURR_LISTS_rec.creation_date OR
262: p_old_CURR_LISTS_rec.creation_date IS NULL )
263: THEN
264: IF NOT QP_Validate.Creation_Date(p_CURR_LISTS_rec.creation_date) THEN
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: END IF;
267: END IF;
268:
269: IF p_CURR_LISTS_rec.currency_header_id IS NOT NULL AND

Line 275: x_return_status := FND_API.G_RET_STS_ERROR;

271: p_old_CURR_LISTS_rec.currency_header_id OR
272: p_old_CURR_LISTS_rec.currency_header_id IS NULL )
273: THEN
274: IF NOT QP_Validate.Currency_Header(p_CURR_LISTS_rec.currency_header_id) THEN
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: END IF;
277: END IF;
278:
279: IF p_CURR_LISTS_rec.description IS NOT NULL AND

Line 285: x_return_status := FND_API.G_RET_STS_ERROR;

281: p_old_CURR_LISTS_rec.description OR
282: p_old_CURR_LISTS_rec.description IS NULL )
283: THEN
284: IF NOT QP_Validate.Description(p_CURR_LISTS_rec.description) THEN
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: END IF;
287: END IF;
288:
289: IF p_CURR_LISTS_rec.last_updated_by IS NOT NULL AND

Line 295: x_return_status := FND_API.G_RET_STS_ERROR;

291: p_old_CURR_LISTS_rec.last_updated_by OR
292: p_old_CURR_LISTS_rec.last_updated_by IS NULL )
293: THEN
294: IF NOT QP_Validate.Last_Updated_By(p_CURR_LISTS_rec.last_updated_by) THEN
295: x_return_status := FND_API.G_RET_STS_ERROR;
296: END IF;
297: END IF;
298:
299: IF p_CURR_LISTS_rec.last_update_date IS NOT NULL AND

Line 305: x_return_status := FND_API.G_RET_STS_ERROR;

301: p_old_CURR_LISTS_rec.last_update_date OR
302: p_old_CURR_LISTS_rec.last_update_date IS NULL )
303: THEN
304: IF NOT QP_Validate.Last_Update_Date(p_CURR_LISTS_rec.last_update_date) THEN
305: x_return_status := FND_API.G_RET_STS_ERROR;
306: END IF;
307: END IF;
308:
309: IF p_CURR_LISTS_rec.last_update_login IS NOT NULL AND

Line 315: x_return_status := FND_API.G_RET_STS_ERROR;

311: p_old_CURR_LISTS_rec.last_update_login OR
312: p_old_CURR_LISTS_rec.last_update_login IS NULL )
313: THEN
314: IF NOT QP_Validate.Last_Update_Login(p_CURR_LISTS_rec.last_update_login) THEN
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: END IF;
317: END IF;
318:
319: IF p_CURR_LISTS_rec.name IS NOT NULL AND

Line 325: x_return_status := FND_API.G_RET_STS_ERROR;

321: p_old_CURR_LISTS_rec.name OR
322: p_old_CURR_LISTS_rec.name IS NULL )
323: THEN
324: IF NOT QP_Validate.Name(p_CURR_LISTS_rec.name) THEN
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: END IF;
327: END IF;
328:
329: IF p_CURR_LISTS_rec.program_application_id IS NOT NULL AND

Line 335: x_return_status := FND_API.G_RET_STS_ERROR;

331: p_old_CURR_LISTS_rec.program_application_id OR
332: p_old_CURR_LISTS_rec.program_application_id IS NULL )
333: THEN
334: IF NOT QP_Validate.Program_Application(p_CURR_LISTS_rec.program_application_id) THEN
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: END IF;
337: END IF;
338:
339: IF p_CURR_LISTS_rec.program_id IS NOT NULL AND

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: p_old_CURR_LISTS_rec.program_id OR
342: p_old_CURR_LISTS_rec.program_id IS NULL )
343: THEN
344: IF NOT QP_Validate.Program(p_CURR_LISTS_rec.program_id) THEN
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: END IF;
347: END IF;
348:
349: IF p_CURR_LISTS_rec.program_update_date IS NOT NULL AND

Line 355: x_return_status := FND_API.G_RET_STS_ERROR;

351: p_old_CURR_LISTS_rec.program_update_date OR
352: p_old_CURR_LISTS_rec.program_update_date IS NULL )
353: THEN
354: IF NOT QP_Validate.Program_Update_Date(p_CURR_LISTS_rec.program_update_date) THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: END IF;
357: END IF;
358:
359: IF p_CURR_LISTS_rec.request_id IS NOT NULL AND

Line 365: x_return_status := FND_API.G_RET_STS_ERROR;

361: p_old_CURR_LISTS_rec.request_id OR
362: p_old_CURR_LISTS_rec.request_id IS NULL )
363: THEN
364: IF NOT QP_Validate.Request(p_CURR_LISTS_rec.request_id) THEN
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: END IF;
367: END IF;
368:
369: IF p_CURR_LISTS_rec.base_rounding_factor IS NOT NULL AND

Line 375: x_return_status := FND_API.G_RET_STS_ERROR;

371: p_old_CURR_LISTS_rec.base_rounding_factor OR
372: p_old_CURR_LISTS_rec.base_rounding_factor IS NULL )
373: THEN
374: IF NOT QP_Validate.base_rounding_factor(p_CURR_LISTS_rec.base_rounding_factor) THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: END IF;
377: END IF;
378:
379: IF p_CURR_LISTS_rec.base_markup_operator IS NOT NULL AND

Line 386: x_return_status := FND_API.G_RET_STS_ERROR;

382: p_old_CURR_LISTS_rec.base_markup_operator IS NULL )
383: THEN
384: -- oe_debug_pub.add('ERROR: in Attributes procedure of L package for base_markup_operator');
385: IF NOT QP_Validate.base_markup_operator(p_CURR_LISTS_rec.base_markup_operator) THEN
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: END IF;
388: END IF;
389:
390: IF p_CURR_LISTS_rec.base_markup_value IS NOT NULL AND

Line 396: x_return_status := FND_API.G_RET_STS_ERROR;

392: p_old_CURR_LISTS_rec.base_markup_value OR
393: p_old_CURR_LISTS_rec.base_markup_value IS NULL )
394: THEN
395: IF NOT QP_Validate.base_markup_value(p_CURR_LISTS_rec.base_markup_value) THEN
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: END IF;
398: END IF;
399:
400: IF p_CURR_LISTS_rec.base_markup_formula_id IS NOT NULL AND

Line 406: x_return_status := FND_API.G_RET_STS_ERROR;

402: p_old_CURR_LISTS_rec.base_markup_formula_id OR
403: p_old_CURR_LISTS_rec.base_markup_formula_id IS NULL )
404: THEN
405: IF NOT QP_Validate.base_markup_formula(p_CURR_LISTS_rec.base_markup_formula_id) THEN
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: END IF;
408: END IF;
409:
410:

Line 421: x_return_status := FND_API.G_RET_STS_ERROR;

417: p_old_CURR_LISTS_rec.row_id OR
418: p_old_CURR_LISTS_rec.row_id IS NULL )
419: THEN
420: IF NOT QP_Validate.Row(p_CURR_LISTS_rec.row_id) THEN
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: END IF;
423: END IF;
424: Commented by Sunil */
425:

Line 564: x_return_status := FND_API.G_RET_STS_ERROR;

560:
561: -- Validate descriptive flexfield.
562:
563: IF NOT QP_Validate.Desc_Flex( 'CURR_LISTS' ) THEN
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: END IF;
566:
567: END IF;
568:

Line 573: WHEN FND_API.G_EXC_ERROR THEN

569: -- Done validating attributes
570:
571: EXCEPTION
572:
573: WHEN FND_API.G_EXC_ERROR THEN
574:
575: x_return_status := FND_API.G_RET_STS_ERROR;
576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 575: x_return_status := FND_API.G_RET_STS_ERROR;

571: EXCEPTION
572:
573: WHEN FND_API.G_EXC_ERROR THEN
574:
575: x_return_status := FND_API.G_RET_STS_ERROR;
576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
578:
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

573: WHEN FND_API.G_EXC_ERROR THEN
574:
575: x_return_status := FND_API.G_RET_STS_ERROR;
576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
578:
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580:
581: WHEN OTHERS THEN

Line 579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

575: x_return_status := FND_API.G_RET_STS_ERROR;
576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
578:
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580:
581: WHEN OTHERS THEN
582:
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580:
581: WHEN OTHERS THEN
582:
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584:
585: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
586: THEN
587: OE_MSG_PUB.Add_Exc_Msg

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

598: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
599: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
600: )
601: IS
602: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
603: BEGIN
604:
605: -- Validate entity delete.
606:

Line 615: WHEN FND_API.G_EXC_ERROR THEN

611: x_return_status := l_return_status;
612:
613: EXCEPTION
614:
615: WHEN FND_API.G_EXC_ERROR THEN
616:
617: x_return_status := FND_API.G_RET_STS_ERROR;
618:
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 617: x_return_status := FND_API.G_RET_STS_ERROR;

613: EXCEPTION
614:
615: WHEN FND_API.G_EXC_ERROR THEN
616:
617: x_return_status := FND_API.G_RET_STS_ERROR;
618:
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620:
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

615: WHEN FND_API.G_EXC_ERROR THEN
616:
617: x_return_status := FND_API.G_RET_STS_ERROR;
618:
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620:
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622:
623: WHEN OTHERS THEN

Line 621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

617: x_return_status := FND_API.G_RET_STS_ERROR;
618:
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620:
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622:
623: WHEN OTHERS THEN
624:
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622:
623: WHEN OTHERS THEN
624:
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626:
627: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
628: THEN
629: OE_MSG_PUB.Add_Exc_Msg