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

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

11: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12: , p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
13: )
14: IS
15: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: l_price_adj_error VARCHAR2(30):= NULL;
17: l_attribute_name VARCHAR2(50):= NULL;
18: l_tmp_string VARCHAR2(30):= NULL;
19: l_agr_type_code VARCHAR2(30):= NULL;

Line 34: l_return_status := FND_API.G_RET_STS_ERROR;

30:
31: /* IF p_Header_Adj_rec.price_adjustment_id IS NULL
32: THEN
33:
34: l_return_status := FND_API.G_RET_STS_ERROR;
35:
36: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
37: THEN
38:

Line 52: l_return_status := FND_API.G_RET_STS_ERROR;

48:
49: IF p_Header_Adj_rec.header_id IS NULL
50: THEN
51:
52: l_return_status := FND_API.G_RET_STS_ERROR;
53:
54: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
55: THEN
56:

Line 71: l_return_status := FND_API.G_RET_STS_ERROR;

67: IF p_Header_adj_rec.list_header_id is null
68: and p_Header_adj_rec.list_line_type_code not in ('COST','TAX')
69: THEN
70:
71: l_return_status := FND_API.G_RET_STS_ERROR;
72:
73: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
74: THEN
75:

Line 88: l_return_status := FND_API.G_RET_STS_ERROR;

84:
85: IF p_Header_adj_rec.list_header_id is not null and
86: p_Header_adj_rec.list_line_id IS NULL THEN
87:
88: l_return_status := FND_API.G_RET_STS_ERROR;
89:
90: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
91: THEN
92:

Line 104: l_return_status := FND_API.G_RET_STS_ERROR;

100:
101:
102: IF p_Header_adj_rec.list_line_type_code IS NULL THEN
103:
104: l_return_status := FND_API.G_RET_STS_ERROR;
105:
106: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
107: THEN
108:

Line 125: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

121:
122:
123: -- Return Error if a required attribute is missing.
124:
125: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
126:
127: RAISE FND_API.G_EXC_ERROR;
128:
129: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 127: RAISE FND_API.G_EXC_ERROR;

123: -- Return Error if a required attribute is missing.
124:
125: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
126:
127: RAISE FND_API.G_EXC_ERROR;
128:
129: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130:
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 129: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

125: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
126:
127: RAISE FND_API.G_EXC_ERROR;
128:
129: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130:
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132:
133: END IF;

Line 131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

127: RAISE FND_API.G_EXC_ERROR;
128:
129: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130:
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132:
133: END IF;
134:
135: --

Line 142: l_return_status := FND_API.G_RET_STS_ERROR;

138:
139: IF upper(p_Header_adj_rec.updated_flag) ='Y' and
140: p_Header_adj_rec.change_reason_code is null THEN
141:
142: l_return_status := FND_API.G_RET_STS_ERROR;
143:
144: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
145: THEN
146:

Line 158: l_return_status := FND_API.G_RET_STS_ERROR;

154:
155: IF p_Header_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' and
156: p_Header_adj_rec.charge_type_code IS NULL THEN
157:
158: l_return_status := FND_API.G_RET_STS_ERROR;
159:
160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
161: THEN
162:

Line 176: l_return_status := FND_API.G_RET_STS_ERROR;

172: IF p_Header_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' AND
173: p_Header_adj_rec.adjusted_amount IS NULL
174: THEN
175:
176: l_return_status := FND_API.G_RET_STS_ERROR;
177:
178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
179: THEN
180:

Line 193: l_return_status := FND_API.G_RET_STS_ERROR;

189: IF p_Header_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' AND
190: p_Header_adj_rec.operand IS NULL
191: THEN
192:
193: l_return_status := FND_API.G_RET_STS_ERROR;
194:
195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
196: THEN
197:

Line 226: l_return_status := FND_API.G_RET_STS_ERROR;

222: IF p_Header_adj_rec.ac_attribute6 IS NULL THEN
223: l_attribute_name := 'AETC Reason Code';
224: END IF;
225: IF l_attribute_name IS NOT NULL THEN
226: l_return_status := FND_API.G_RET_STS_ERROR;
227:
228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
229: THEN
230:

Line 264: l_return_status := FND_API.G_RET_STS_ERROR;

260: -- AND ENABLED_FLAG = 'Y';
261: EXCEPTION
262:
263: WHEN NO_DATA_FOUND THEN
264: l_return_status := FND_API.G_RET_STS_ERROR;
265: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
266: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
267: OE_Order_Util.Get_Attribute_Name('CHARGE_SUBTYPE_CODE'));
268: OE_MSG_PUB.Add;

Line 278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

274: ( G_PKG_NAME ,
275: 'Record - Charge Type/Subtype validation'
276: );
277: END IF;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END;
280: END IF;
281:
282: IF p_Header_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' and

Line 286: l_return_status := FND_API.G_RET_STS_ERROR;

282: IF p_Header_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' and
283: p_Header_adj_rec.arithmetic_operator <> 'LUMPSUM'
284: THEN
285:
286: l_return_status := FND_API.G_RET_STS_ERROR;
287:
288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
289: THEN
290:

Line 324: WHEN FND_API.G_EXC_ERROR THEN

320: oe_debug_pub.Add('Exiting OE_CNCL_VALIDATE_HEADER_ADJ.Entity',1);
321:
322: EXCEPTION
323:
324: WHEN FND_API.G_EXC_ERROR THEN
325:
326: x_return_status := FND_API.G_RET_STS_ERROR;
327:
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 326: x_return_status := FND_API.G_RET_STS_ERROR;

322: EXCEPTION
323:
324: WHEN FND_API.G_EXC_ERROR THEN
325:
326: x_return_status := FND_API.G_RET_STS_ERROR;
327:
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329:
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

324: WHEN FND_API.G_EXC_ERROR THEN
325:
326: x_return_status := FND_API.G_RET_STS_ERROR;
327:
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329:
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331:
332: WHEN OTHERS THEN

Line 330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

326: x_return_status := FND_API.G_RET_STS_ERROR;
327:
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329:
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331:
332: WHEN OTHERS THEN
333:
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331:
332: WHEN OTHERS THEN
333:
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335:
336: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
337: THEN
338: OE_MSG_PUB.Add_Exc_Msg

Line 356: x_return_status := FND_API.G_RET_STS_SUCCESS;

352: IS
353: BEGIN
354:
355: oe_debug_pub.Add('Entering OE_CNCL_VALIDATE_HEADER_ADJ.Attributes',1);
356: x_return_status := FND_API.G_RET_STS_SUCCESS;
357:
358: -- Validate Header_Adj attributes
359:
360: /* IF p_Header_Adj_rec.price_adjustment_id IS NOT NULL

Line 363: x_return_status := FND_API.G_RET_STS_ERROR;

359:
360: /* IF p_Header_Adj_rec.price_adjustment_id IS NOT NULL
361: THEN
362: IF NOT OE_CNCL_Validate_Adj.Price_Adjustment(p_Header_Adj_rec.price_adjustment_id) THEN
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: END IF;
365: END IF;
366: */
367:

Line 371: x_return_status := FND_API.G_RET_STS_ERROR;

367:
368: IF p_Header_Adj_rec.creation_date IS NOT NULL
369: THEN
370: IF NOT OE_CNCL_Validate_Adj.Creation_Date(p_Header_Adj_rec.creation_date) THEN
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: END IF;
373: END IF;
374: IF p_Header_Adj_rec.pricing_phase_id IS NOT NULL
375: THEN

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374: IF p_Header_Adj_rec.pricing_phase_id IS NOT NULL
375: THEN
376: IF NOT OE_CNCL_Validate_Adj.Pricing_Phase_id(p_Header_Adj_rec.pricing_phase_id)
377: THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380: END IF;
381:
382:

Line 387: x_return_status := FND_API.G_RET_STS_ERROR;

383: IF p_Header_Adj_rec.adjusted_amount IS NOT NULL
384: THEN
385: IF NOT OE_CNCL_Validate_Adj.Adjusted_Amount(p_Header_Adj_rec.adjusted_amount)
386: THEN
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: END IF;
389: END IF;
390:
391: IF p_Header_Adj_rec.created_by IS NOT NULL

Line 394: x_return_status := FND_API.G_RET_STS_ERROR;

390:
391: IF p_Header_Adj_rec.created_by IS NOT NULL
392: THEN
393: IF NOT OE_CNCL_Validate_Adj.Created_By(p_Header_Adj_rec.created_by) THEN
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: END IF;
396: END IF;
397:
398: IF p_Header_Adj_rec.last_update_date IS NOT NULL

Line 401: x_return_status := FND_API.G_RET_STS_ERROR;

397:
398: IF p_Header_Adj_rec.last_update_date IS NOT NULL
399: THEN
400: IF NOT OE_CNCL_Validate_Adj.Last_Update_Date(p_Header_Adj_rec.last_update_date) THEN
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: END IF;
403: END IF;
404:
405: IF p_Header_Adj_rec.last_updated_by IS NOT NULL

Line 408: x_return_status := FND_API.G_RET_STS_ERROR;

404:
405: IF p_Header_Adj_rec.last_updated_by IS NOT NULL
406: THEN
407: IF NOT OE_CNCL_Validate_Adj.Last_Updated_By(p_Header_Adj_rec.last_updated_by) THEN
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: END IF;
410: END IF;
411:
412: IF p_Header_Adj_rec.last_update_login IS NOT NULL

Line 415: x_return_status := FND_API.G_RET_STS_ERROR;

411:
412: IF p_Header_Adj_rec.last_update_login IS NOT NULL
413: THEN
414: IF NOT OE_CNCL_Validate_Adj.Last_Update_Login(p_Header_Adj_rec.last_update_login) THEN
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: END IF;
417: END IF;
418:
419: IF p_Header_Adj_rec.program_application_id IS NOT NULL

Line 422: x_return_status := FND_API.G_RET_STS_ERROR;

418:
419: IF p_Header_Adj_rec.program_application_id IS NOT NULL
420: THEN
421: IF NOT OE_CNCL_Validate_Adj.Program_Application(p_Header_Adj_rec.program_application_id) THEN
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: END IF;
424: END IF;
425:
426: IF p_Header_Adj_rec.program_id IS NOT NULL

Line 429: x_return_status := FND_API.G_RET_STS_ERROR;

425:
426: IF p_Header_Adj_rec.program_id IS NOT NULL
427: THEN
428: IF NOT OE_CNCL_Validate_Adj.Program(p_Header_Adj_rec.program_id) THEN
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: END IF;
431: END IF;
432:
433: IF p_Header_Adj_rec.program_update_date IS NOT NULL

Line 436: x_return_status := FND_API.G_RET_STS_ERROR;

432:
433: IF p_Header_Adj_rec.program_update_date IS NOT NULL
434: THEN
435: IF NOT OE_CNCL_Validate_Adj.Program_Update_Date(p_Header_Adj_rec.program_update_date) THEN
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: END IF;
438: END IF;
439:
440: IF p_Header_Adj_rec.request_id IS NOT NULL

Line 443: x_return_status := FND_API.G_RET_STS_ERROR;

439:
440: IF p_Header_Adj_rec.request_id IS NOT NULL
441: THEN
442: IF NOT OE_CNCL_Validate_Adj.Request(p_Header_Adj_rec.request_id) THEN
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: END IF;
445: END IF;
446:
447: /* IF p_Header_Adj_rec.header_id IS NOT NULL

Line 450: x_return_status := FND_API.G_RET_STS_ERROR;

446:
447: /* IF p_Header_Adj_rec.header_id IS NOT NULL
448: THEN
449: IF NOT OE_CNCL_Validate_Adj.Header(p_Header_Adj_rec.header_id) THEN
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: END IF;
452: END IF;
453: */
454:

Line 458: x_return_status := FND_API.G_RET_STS_ERROR;

454:
455: IF p_Header_Adj_rec.discount_id IS NOT NULL
456: THEN
457: IF NOT OE_CNCL_Validate_Adj.Discount(p_Header_Adj_rec.discount_id) THEN
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: END IF;
460: END IF;
461:
462: IF p_Header_Adj_rec.discount_line_id IS NOT NULL

Line 465: x_return_status := FND_API.G_RET_STS_ERROR;

461:
462: IF p_Header_Adj_rec.discount_line_id IS NOT NULL
463: THEN
464: IF NOT OE_CNCL_Validate_Adj.Discount_Line(p_Header_Adj_rec.discount_line_id) THEN
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: END IF;
467: END IF;
468:
469: IF p_Header_Adj_rec.automatic_flag IS NOT NULL

Line 472: x_return_status := FND_API.G_RET_STS_ERROR;

468:
469: IF p_Header_Adj_rec.automatic_flag IS NOT NULL
470: THEN
471: IF NOT OE_CNCL_Validate_Adj.Automatic(p_Header_Adj_rec.automatic_flag) THEN
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: END IF;
474: END IF;
475:
476: IF p_Header_Adj_rec.percent IS NOT NULL

Line 479: x_return_status := FND_API.G_RET_STS_ERROR;

475:
476: IF p_Header_Adj_rec.percent IS NOT NULL
477: THEN
478: IF NOT OE_CNCL_Validate_Adj.Percent(p_Header_Adj_rec.percent) THEN
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;
481: END IF;
482:
483: IF p_Header_Adj_rec.line_id IS NOT NULL

Line 486: x_return_status := FND_API.G_RET_STS_ERROR;

482:
483: IF p_Header_Adj_rec.line_id IS NOT NULL
484: THEN
485: IF NOT OE_CNCL_Validate_Adj.Line(p_Header_Adj_rec.line_id) THEN
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: END IF;
488: END IF;
489:
490: IF p_Header_Adj_rec.list_line_no IS NOT NULL

Line 493: x_return_status := FND_API.G_RET_STS_ERROR;

489:
490: IF p_Header_Adj_rec.list_line_no IS NOT NULL
491: THEN
492: IF NOT OE_CNCL_Validate_Adj.List_Line_No(p_Header_Adj_rec.list_line_no) THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: END IF;
495: END IF;
496:
497: IF p_Header_Adj_rec.source_system_code IS NOT NULL

Line 500: x_return_status := FND_API.G_RET_STS_ERROR;

496:
497: IF p_Header_Adj_rec.source_system_code IS NOT NULL
498: THEN
499: IF NOT OE_CNCL_Validate_Adj.source_system_code(p_Header_Adj_rec.source_system_code) THEN
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: END IF;
502: END IF;
503:
504: IF p_Header_Adj_rec.benefit_qty IS NOT NULL

Line 507: x_return_status := FND_API.G_RET_STS_ERROR;

503:
504: IF p_Header_Adj_rec.benefit_qty IS NOT NULL
505: THEN
506: IF NOT OE_CNCL_Validate_Adj.benefit_qty(p_Header_Adj_rec.benefit_qty) THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: END IF;
509: END IF;
510:
511: IF p_Header_Adj_rec.benefit_uom_code IS NOT NULL

Line 514: x_return_status := FND_API.G_RET_STS_ERROR;

510:
511: IF p_Header_Adj_rec.benefit_uom_code IS NOT NULL
512: THEN
513: IF NOT OE_CNCL_Validate_Adj.benefit_uom_code(p_Header_Adj_rec.benefit_uom_code) THEN
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: END IF;
516: END IF;
517:
518: IF p_Header_Adj_rec.print_on_invoice_flag IS NOT NULL

Line 521: x_return_status := FND_API.G_RET_STS_ERROR;

517:
518: IF p_Header_Adj_rec.print_on_invoice_flag IS NOT NULL
519: THEN
520: IF NOT OE_CNCL_Validate_Adj.print_on_invoice_flag(p_Header_Adj_rec.print_on_invoice_flag) THEN
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: END IF;
523: END IF;
524:
525: IF p_Header_Adj_rec.expiration_date IS NOT NULL

Line 528: x_return_status := FND_API.G_RET_STS_ERROR;

524:
525: IF p_Header_Adj_rec.expiration_date IS NOT NULL
526: THEN
527: IF NOT OE_CNCL_Validate_Adj.expiration_date(p_Header_Adj_rec.expiration_date) THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: END IF;
530: END IF;
531:
532: IF p_Header_Adj_rec.rebate_transaction_type_code IS NOT NULL

Line 535: x_return_status := FND_API.G_RET_STS_ERROR;

531:
532: IF p_Header_Adj_rec.rebate_transaction_type_code IS NOT NULL
533: THEN
534: IF NOT OE_CNCL_Validate_Adj.rebate_transaction_type_code(p_Header_Adj_rec.rebate_transaction_type_code) THEN
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: END IF;
537: END IF;
538:
539:

Line 543: x_return_status := FND_API.G_RET_STS_ERROR;

539:
540: IF p_Header_Adj_rec.rebate_transaction_reference IS NOT NULL
541: THEN
542: IF NOT OE_CNCL_Validate_Adj.rebate_transaction_reference(p_Header_Adj_rec.rebate_transaction_reference) THEN
543: x_return_status := FND_API.G_RET_STS_ERROR;
544: END IF;
545: END IF;
546:
547: IF p_Header_Adj_rec.rebate_payment_system_code IS NOT NULL

Line 550: x_return_status := FND_API.G_RET_STS_ERROR;

546:
547: IF p_Header_Adj_rec.rebate_payment_system_code IS NOT NULL
548: THEN
549: IF NOT OE_CNCL_Validate_Adj.rebate_payment_system_code(p_Header_Adj_rec.rebate_payment_system_code) THEN
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: END IF;
552: END IF;
553:
554: IF p_Header_Adj_rec.Redeemed_Date IS NOT NULL

Line 557: x_return_status := FND_API.G_RET_STS_ERROR;

553:
554: IF p_Header_Adj_rec.Redeemed_Date IS NOT NULL
555: THEN
556: IF NOT OE_CNCL_Validate_Adj.Redeemed_Date(p_Header_Adj_rec.Redeemed_Date) THEN
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: END IF;
559: END IF;
560:
561: IF p_Header_Adj_rec.redeemed_flag IS NOT NULL

Line 564: x_return_status := FND_API.G_RET_STS_ERROR;

560:
561: IF p_Header_Adj_rec.redeemed_flag IS NOT NULL
562: THEN
563: IF NOT OE_CNCL_Validate_Adj.Redeemed_Flag(p_Header_Adj_rec.redeemed_flag) THEN
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: END IF;
566: END IF;
567:
568: IF p_Header_Adj_rec.accrual_flag IS NOT NULL

Line 571: x_return_status := FND_API.G_RET_STS_ERROR;

567:
568: IF p_Header_Adj_rec.accrual_flag IS NOT NULL
569: THEN
570: IF NOT OE_CNCL_Validate_Adj.Accrual_Flag(p_Header_Adj_rec.accrual_flag) THEN
571: x_return_status := FND_API.G_RET_STS_ERROR;
572: END IF;
573: END IF;
574:
575: IF p_Header_Adj_rec.credit_or_charge_flag IS NOT NULL

Line 578: x_return_status := FND_API.G_RET_STS_ERROR;

574:
575: IF p_Header_Adj_rec.credit_or_charge_flag IS NOT NULL
576: THEN
577: IF NOT OE_CNCL_Validate.credit_or_charge_flag(p_Header_Adj_rec.credit_or_charge_flag) THEN
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: END IF;
580: END IF;
581:
582: IF p_Header_Adj_rec.charge_type_code IS NOT NULL

Line 585: x_return_status := FND_API.G_RET_STS_ERROR;

581:
582: IF p_Header_Adj_rec.charge_type_code IS NOT NULL
583: THEN
584: IF NOT OE_CNCL_Validate.charge_type_code(p_Header_Adj_rec.charge_type_code) THEN
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: END IF;
587: END IF;
588:
589: IF p_Header_Adj_rec.charge_subtype_code IS NOT NULL

Line 592: x_return_status := FND_API.G_RET_STS_ERROR;

588:
589: IF p_Header_Adj_rec.charge_subtype_code IS NOT NULL
590: THEN
591: IF NOT OE_CNCL_Validate.charge_subtype_code(p_Header_Adj_rec.charge_subtype_code) THEN
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: END IF;
594: END IF;
595:
596: IF p_Header_Adj_rec.estimated_flag IS NOT NULL

Line 599: x_return_status := FND_API.G_RET_STS_ERROR;

595:
596: IF p_Header_Adj_rec.estimated_flag IS NOT NULL
597: THEN
598: IF NOT OE_CNCL_Validate.estimated(p_Header_Adj_rec.estimated_flag) THEN
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: END IF;
601: END IF;
602:
603: IF p_Header_Adj_rec.invoiced_flag IS NOT NULL

Line 606: x_return_status := FND_API.G_RET_STS_ERROR;

602:
603: IF p_Header_Adj_rec.invoiced_flag IS NOT NULL
604: THEN
605: IF NOT OE_CNCL_Validate.invoiced(p_Header_Adj_rec.invoiced_flag) THEN
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: END IF;
608: END IF;
609:
610: IF p_Header_Adj_rec.context IS NOT NULL

Line 651: x_return_status := FND_API.G_RET_STS_ERROR;

647: ,p_attribute14 => p_Header_Adj_rec.attribute14
648: ,p_attribute15 => p_Header_Adj_rec.attribute15) THEN
649:
650:
651: x_return_status := FND_API.G_RET_STS_ERROR;
652:
653: oe_debug_pub.add('After Header Adjustment desc_flex ' || x_return_status,2);
654:
655: END IF;

Line 664: WHEN FND_API.G_EXC_ERROR THEN

660: oe_debug_pub.Add('Exiting OE_CNCL_VALIDATE_HEADER_ADJ.Attributes',1);
661:
662: EXCEPTION
663:
664: WHEN FND_API.G_EXC_ERROR THEN
665:
666: x_return_status := FND_API.G_RET_STS_ERROR;
667:
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 666: x_return_status := FND_API.G_RET_STS_ERROR;

662: EXCEPTION
663:
664: WHEN FND_API.G_EXC_ERROR THEN
665:
666: x_return_status := FND_API.G_RET_STS_ERROR;
667:
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669:
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

664: WHEN FND_API.G_EXC_ERROR THEN
665:
666: x_return_status := FND_API.G_RET_STS_ERROR;
667:
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669:
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671:
672: WHEN OTHERS THEN

Line 670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

666: x_return_status := FND_API.G_RET_STS_ERROR;
667:
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669:
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671:
672: WHEN OTHERS THEN
673:
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671:
672: WHEN OTHERS THEN
673:
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675:
676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: OE_MSG_PUB.Add_Exc_Msg