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

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

40: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
41: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
42: )
43: IS
44: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
45: BEGIN
46:
47: -- Check required attributes.
48:

Line 52: l_return_status := FND_API.G_RET_STS_ERROR;

48:
49: IF p_Agreement_rec.agreement_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 70: l_return_status := FND_API.G_RET_STS_ERROR;

66: IF p_Agreement_rec.agreement_source_code = 'PAGR' AND
67: p_Agreement_rec.price_list_id IS NULL
68: THEN
69:
70: l_return_status := FND_API.G_RET_STS_ERROR;
71:
72: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
73: THEN
74:

Line 83: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

79: END IF;
80:
81: END IF;
82:
83: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
84:
85: RAISE FND_API.G_EXC_ERROR;
86:
87: END IF;

Line 85: RAISE FND_API.G_EXC_ERROR;

81: END IF;
82:
83: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
84:
85: RAISE FND_API.G_EXC_ERROR;
86:
87: END IF;
88:
89: --Commented by sssriniv for making terms field optional

Line 94: l_return_status := FND_API.G_RET_STS_ERROR;

90: /* IF p_Agreement_rec.agreement_source_code = 'PAGR' AND
91: p_Agreement_rec.term_id IS NULL
92: THEN
93:
94: l_return_status := FND_API.G_RET_STS_ERROR;
95:
96: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
97: THEN
98:

Line 108: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

104:
105: END IF;
106: */
107:
108: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
109:
110: RAISE FND_API.G_EXC_ERROR;
111:
112: END IF;

Line 110: RAISE FND_API.G_EXC_ERROR;

106: */
107:
108: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
109:
110: RAISE FND_API.G_EXC_ERROR;
111:
112: END IF;
113: --End code added by rchellam for OKC
114:

Line 129: l_return_status := FND_API.G_RET_STS_ERROR;

125: -- );
126:
127: if NOT ( Allow_Revision( p_Agreement_rec => p_Agreement_rec))
128: THEN
129: l_return_status := FND_API.G_RET_STS_ERROR;
130: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
131: THEN
132: FND_MESSAGE.SET_NAME('QP','QP_NO_REVISION');
133: OE_MSG_PUB.Add;

Line 138: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

134: end if;
135:
136: END IF;
137:
138: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
139:
140: RAISE FND_API.G_EXC_ERROR;
141:
142: END IF;

Line 140: RAISE FND_API.G_EXC_ERROR;

136: END IF;
137:
138: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
139:
140: RAISE FND_API.G_EXC_ERROR;
141:
142: END IF;
143:
144: IF NOT ( Handle_Revision (p_Agreement_rec => p_Agreement_rec ))

Line 147: l_return_status := FND_API.G_RET_STS_ERROR;

143:
144: IF NOT ( Handle_Revision (p_Agreement_rec => p_Agreement_rec ))
145: THEN
146:
147: l_return_status := FND_API.G_RET_STS_ERROR;
148:
149: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
150: THEN
151: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_REVISION');

Line 168: l_return_status := FND_API.G_RET_STS_ERROR;

164: then
165:
166: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
167: THEN
168: l_return_status := FND_API.G_RET_STS_ERROR;
169: FND_MESSAGE.SET_NAME('QP','QP_OVERLAPPING_START_DATE');
170: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision');
171: OE_MSG_PUB.Add;
172: /*

Line 183: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

179:
180: end if;
181:
182:
183: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
184:
185: RAISE FND_API.G_EXC_ERROR;
186:
187: END IF;

Line 185: RAISE FND_API.G_EXC_ERROR;

181:
182:
183: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
184:
185: RAISE FND_API.G_EXC_ERROR;
186:
187: END IF;
188:
189:

Line 195: l_return_status := FND_API.G_RET_STS_ERROR;

191: THEN
192:
193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
194: THEN
195: l_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MESSAGE.SET_NAME('QP','QP_OVERLAPPING_END_DATE');
197: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision');
198: OE_MSG_PUB.Add;
199: /*

Line 215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

211: END IF;
212:
213: -- Return Error if a required attribute is missing.
214:
215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
216:
217: RAISE FND_API.G_EXC_ERROR;
218:
219: END IF;

Line 217: RAISE FND_API.G_EXC_ERROR;

213: -- Return Error if a required attribute is missing.
214:
215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
216:
217: RAISE FND_API.G_EXC_ERROR;
218:
219: END IF;
220:
221:

Line 226: l_return_status := FND_API.G_RET_STS_ERROR;

222: --Begin code added by rchellam for OKC
223: IF NOT (Valid_Agreement_Source (p_Agreement_rec => p_Agreement_rec ))
224: THEN
225:
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) THEN
229: FND_MESSAGE.SET_NAME('QP','QP_INVALID_AGR_SOURCE_CODE');
230: OE_MSG_PUB.Add;

Line 235: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

231: END IF;
232:
233: END IF;
234:
235: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
236:
237: RAISE FND_API.G_EXC_ERROR;
238:
239: END IF;

Line 237: RAISE FND_API.G_EXC_ERROR;

233: END IF;
234:
235: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
236:
237: RAISE FND_API.G_EXC_ERROR;
238:
239: END IF;
240: --End code added by rchellam for OKC
241:

Line 259: WHEN FND_API.G_EXC_ERROR THEN

255: x_return_status := l_return_status;
256:
257: EXCEPTION
258:
259: WHEN FND_API.G_EXC_ERROR THEN
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;
262:
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257: EXCEPTION
258:
259: WHEN FND_API.G_EXC_ERROR THEN
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;
262:
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264:
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

259: WHEN FND_API.G_EXC_ERROR THEN
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;
262:
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264:
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266:
267: WHEN OTHERS THEN

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261: x_return_status := FND_API.G_RET_STS_ERROR;
262:
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264:
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266:
267: WHEN OTHERS THEN
268:
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266:
267: WHEN OTHERS THEN
268:
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270:
271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: OE_MSG_PUB.Add_Exc_Msg

Line 292: x_return_status := FND_API.G_RET_STS_SUCCESS;

288: )
289: IS
290: BEGIN
291:
292: x_return_status := FND_API.G_RET_STS_SUCCESS;
293:
294: -- Validate Agreement attributes
295:
296: IF p_Agreement_rec.accounting_rule_id IS NOT NULL AND

Line 302: x_return_status := FND_API.G_RET_STS_ERROR;

298: p_old_Agreement_rec.accounting_rule_id OR
299: p_old_Agreement_rec.accounting_rule_id IS NULL )
300: THEN
301: IF NOT OE_Validate_Attr.Accounting_Rule(p_Agreement_rec.accounting_rule_id) THEN
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: END IF;
304: END IF;
305:
306: IF p_Agreement_rec.agreement_contact_id IS NOT NULL AND

Line 312: x_return_status := FND_API.G_RET_STS_ERROR;

308: p_old_Agreement_rec.agreement_contact_id OR
309: p_old_Agreement_rec.agreement_contact_id IS NULL )
310: THEN
311: IF NOT OE_Validate_Attr.Agreement_Contact(p_Agreement_rec.agreement_contact_id) THEN
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: END IF;
314: END IF;
315:
316: IF p_Agreement_rec.agreement_id IS NOT NULL AND

Line 322: x_return_status := FND_API.G_RET_STS_ERROR;

318: p_old_Agreement_rec.agreement_id OR
319: p_old_Agreement_rec.agreement_id IS NULL )
320: THEN
321: IF NOT OE_Validate_Attr.Agreement(p_Agreement_rec.agreement_id) THEN
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: END IF;
324: END IF;
325:
326: IF p_Agreement_rec.agreement_num IS NOT NULL AND

Line 332: x_return_status := FND_API.G_RET_STS_ERROR;

328: p_old_Agreement_rec.agreement_num OR
329: p_old_Agreement_rec.agreement_num IS NULL )
330: THEN
331: IF NOT OE_Validate_Attr.Agreement_Num(p_Agreement_rec.agreement_num) THEN
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: END IF;
334: END IF;
335:
336: IF p_Agreement_rec.agreement_type_code IS NOT NULL AND

Line 342: x_return_status := FND_API.G_RET_STS_ERROR;

338: p_old_Agreement_rec.agreement_type_code OR
339: p_old_Agreement_rec.agreement_type_code IS NULL )
340: THEN
341: IF NOT OE_Validate_Attr.Agreement_Type(p_Agreement_rec.agreement_type_code) THEN
342: x_return_status := FND_API.G_RET_STS_ERROR;
343: END IF;
344: END IF;
345:
346: IF p_Agreement_rec.created_by IS NOT NULL AND

Line 352: x_return_status := FND_API.G_RET_STS_ERROR;

348: p_old_Agreement_rec.created_by OR
349: p_old_Agreement_rec.created_by IS NULL )
350: THEN
351: IF NOT OE_Validate_Attr.Created_By(p_Agreement_rec.created_by) THEN
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: END IF;
354: END IF;
355:
356: IF p_Agreement_rec.creation_date IS NOT NULL AND

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358: p_old_Agreement_rec.creation_date OR
359: p_old_Agreement_rec.creation_date IS NULL )
360: THEN
361: IF NOT OE_Validate_Attr.Creation_Date(p_Agreement_rec.creation_date) THEN
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: END IF;
364: END IF;
365:
366: --

Line 374: x_return_status := FND_API.G_RET_STS_ERROR;

370: p_old_Agreement_rec.sold_to_org_id OR
371: p_old_Agreement_rec.sold_to_org_id IS NULL )
372: THEN
373: IF NOT OE_Validate_Attr.Customer(p_Agreement_rec.sold_to_org_id) THEN
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: END IF;
376: END IF;
377:
378:

Line 387: x_return_status := FND_API.G_RET_STS_ERROR;

383: p_old_Agreement_rec.customer_id OR
384: p_old_Agreement_rec.customer_id IS NULL )
385: THEN
386: IF NOT OE_Validate_Attr.Customer(p_Agreement_rec.customer_id) THEN
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: END IF;
389: END IF;
390: */
391:

Line 398: x_return_status := FND_API.G_RET_STS_ERROR;

394: p_old_Agreement_rec.end_date_active OR
395: p_old_Agreement_rec.end_date_active IS NULL )
396: THEN
397: IF NOT OE_Validate_Attr.End_Date_Active(p_Agreement_rec.end_date_active) THEN
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: END IF;
400: END IF;
401:
402: IF p_Agreement_rec.freight_terms_code IS NOT NULL AND

Line 408: x_return_status := FND_API.G_RET_STS_ERROR;

404: p_old_Agreement_rec.freight_terms_code OR
405: p_old_Agreement_rec.freight_terms_code IS NULL )
406: THEN
407: IF NOT OE_Validate_Attr.Freight_Terms(p_Agreement_rec.freight_terms_code) THEN
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: END IF;
410: END IF;
411:
412: IF p_Agreement_rec.invoice_contact_id IS NOT NULL AND

Line 418: x_return_status := FND_API.G_RET_STS_ERROR;

414: p_old_Agreement_rec.invoice_contact_id OR
415: p_old_Agreement_rec.invoice_contact_id IS NULL )
416: THEN
417: IF NOT OE_Validate_Attr.Invoice_Contact(p_Agreement_rec.invoice_contact_id) THEN
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: END IF;
420: END IF;
421:
422: -- Changes

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426: p_old_Agreement_rec.invoice_to_org_id OR
427: p_old_Agreement_rec.invoice_to_org_id IS NULL )
428: THEN
429: IF NOT OE_Validate_Attr.Invoice_To_Site_Use(p_Agreement_rec.invoice_to_org_id) THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: END IF;
432: END IF;
433:
434: --

Line 441: x_return_status := FND_API.G_RET_STS_ERROR;

437: p_old_Agreement_rec.invoice_to_site_use_id OR
438: p_old_Agreement_rec.invoice_to_site_use_id IS NULL )
439: THEN
440: IF NOT OE_Validate_Attr.Invoice_To_Site_Use(p_Agreement_rec.invoice_to_site_use_id) THEN
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: END IF;
443: END IF;
444: */
445:

Line 452: x_return_status := FND_API.G_RET_STS_ERROR;

448: p_old_Agreement_rec.invoicing_rule_id OR
449: p_old_Agreement_rec.invoicing_rule_id IS NULL )
450: THEN
451: IF NOT OE_Validate_Attr.Invoicing_Rule(p_Agreement_rec.invoicing_rule_id) THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: END IF;
454: END IF;
455:
456: IF p_Agreement_rec.last_updated_by IS NOT NULL AND

Line 462: x_return_status := FND_API.G_RET_STS_ERROR;

458: p_old_Agreement_rec.last_updated_by OR
459: p_old_Agreement_rec.last_updated_by IS NULL )
460: THEN
461: IF NOT OE_Validate_Attr.Last_Updated_By(p_Agreement_rec.last_updated_by) THEN
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: END IF;
464: END IF;
465:
466: IF p_Agreement_rec.last_update_date IS NOT NULL AND

Line 472: x_return_status := FND_API.G_RET_STS_ERROR;

468: p_old_Agreement_rec.last_update_date OR
469: p_old_Agreement_rec.last_update_date IS NULL )
470: THEN
471: IF NOT OE_Validate_Attr.Last_Update_Date(p_Agreement_rec.last_update_date) THEN
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: END IF;
474: END IF;
475:
476: IF p_Agreement_rec.last_update_login IS NOT NULL AND

Line 482: x_return_status := FND_API.G_RET_STS_ERROR;

478: p_old_Agreement_rec.last_update_login OR
479: p_old_Agreement_rec.last_update_login IS NULL )
480: THEN
481: IF NOT OE_Validate_Attr.Last_Update_Login(p_Agreement_rec.last_update_login) THEN
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: END IF;
484: END IF;
485:
486: IF p_Agreement_rec.name IS NOT NULL AND

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

488: p_old_Agreement_rec.name OR
489: p_old_Agreement_rec.name IS NULL )
490: THEN
491: IF NOT OE_Validate_Attr.Name(p_Agreement_rec.name) THEN
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: END IF;
494:
495: /* Check Revisions */
496:

Line 509: x_return_status := FND_API.G_RET_STS_ERROR;

505: p_old_Agreement_rec.override_arule_flag OR
506: p_old_Agreement_rec.override_arule_flag IS NULL )
507: THEN
508: IF NOT OE_Validate_Attr.Override_Arule(p_Agreement_rec.override_arule_flag) THEN
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: END IF;
511: END IF;
512:
513: IF p_Agreement_rec.override_irule_flag IS NOT NULL AND

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515: p_old_Agreement_rec.override_irule_flag OR
516: p_old_Agreement_rec.override_irule_flag IS NULL )
517: THEN
518: IF NOT OE_Validate_Attr.Override_Irule(p_Agreement_rec.override_irule_flag) THEN
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: END IF;
521: END IF;
522:
523: IF p_Agreement_rec.price_list_id IS NOT NULL AND

Line 529: x_return_status := FND_API.G_RET_STS_ERROR;

525: p_old_Agreement_rec.price_list_id OR
526: p_old_Agreement_rec.price_list_id IS NULL )
527: THEN
528: IF NOT OE_Validate_Attr.Price_List(p_Agreement_rec.price_list_id) THEN
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: END IF;
531: END IF;
532:
533: IF p_Agreement_rec.purchase_order_num IS NOT NULL AND

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535: p_old_Agreement_rec.purchase_order_num OR
536: p_old_Agreement_rec.purchase_order_num IS NULL )
537: THEN
538: IF NOT OE_Validate_Attr.Purchase_Order_Num(p_Agreement_rec.purchase_order_num) THEN
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: END IF;
541: END IF;
542:
543: IF p_Agreement_rec.revision IS NOT NULL AND

Line 549: x_return_status := FND_API.G_RET_STS_ERROR;

545: p_old_Agreement_rec.revision OR
546: p_old_Agreement_rec.revision IS NULL )
547: THEN
548: IF NOT OE_Validate_Attr.Revision(p_Agreement_rec.revision) THEN
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: END IF;
551: END IF;
552:
553: IF p_Agreement_rec.revision_date IS NOT NULL AND

Line 559: x_return_status := FND_API.G_RET_STS_ERROR;

555: p_old_Agreement_rec.revision_date OR
556: p_old_Agreement_rec.revision_date IS NULL )
557: THEN
558: IF NOT OE_Validate_Attr.Revision_Date(p_Agreement_rec.revision_date) THEN
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: END IF;
561: END IF;
562:
563: IF p_Agreement_rec.revision_reason_code IS NOT NULL AND

Line 569: x_return_status := FND_API.G_RET_STS_ERROR;

565: p_old_Agreement_rec.revision_reason_code OR
566: p_old_Agreement_rec.revision_reason_code IS NULL )
567: THEN
568: IF NOT OE_Validate_Attr.Revision_Reason(p_Agreement_rec.revision_reason_code) THEN
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: END IF;
571: END IF;
572:
573: IF p_Agreement_rec.salesrep_id IS NOT NULL AND

Line 579: x_return_status := FND_API.G_RET_STS_ERROR;

575: p_old_Agreement_rec.salesrep_id OR
576: p_old_Agreement_rec.salesrep_id IS NULL )
577: THEN
578: IF NOT OE_Validate_Attr.Salesrep(p_Agreement_rec.salesrep_id) THEN
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: END IF;
581: END IF;
582:
583: IF p_Agreement_rec.ship_method_code IS NOT NULL AND

Line 589: x_return_status := FND_API.G_RET_STS_ERROR;

585: p_old_Agreement_rec.ship_method_code OR
586: p_old_Agreement_rec.ship_method_code IS NULL )
587: THEN
588: IF NOT OE_Validate_Attr.Ship_Method(p_Agreement_rec.ship_method_code) THEN
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: END IF;
591: END IF;
592:
593: IF p_Agreement_rec.signature_date IS NOT NULL AND

Line 599: x_return_status := FND_API.G_RET_STS_ERROR;

595: p_old_Agreement_rec.signature_date OR
596: p_old_Agreement_rec.signature_date IS NULL )
597: THEN
598: IF NOT OE_Validate_Attr.Signature_Date(p_Agreement_rec.signature_date) THEN
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: END IF;
601: END IF;
602:
603: IF p_Agreement_rec.start_date_active IS NOT NULL AND

Line 609: x_return_status := FND_API.G_RET_STS_ERROR;

605: p_old_Agreement_rec.start_date_active OR
606: p_old_Agreement_rec.start_date_active IS NULL )
607: THEN
608: IF NOT OE_Validate_Attr.Start_Date_Active(p_Agreement_rec.start_date_active) THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: END IF;
611: END IF;
612:
613: IF p_Agreement_rec.term_id IS NOT NULL AND

Line 619: x_return_status := FND_API.G_RET_STS_ERROR;

615: p_old_Agreement_rec.term_id OR
616: p_old_Agreement_rec.term_id IS NULL )
617: THEN
618: IF NOT OE_Validate_Attr.Term(p_Agreement_rec.term_id) THEN
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: END IF;
621: END IF;
622:
623: -- Added for bug#4029589

Line 630: x_return_status := FND_API.G_RET_STS_ERROR;

626: p_old_Agreement_rec.invoice_to_customer_id OR
627: p_old_Agreement_rec.invoice_to_customer_id IS NULL )
628: THEN
629: IF NOT OE_Validate_Attr.Invoice_To_Customer_Id(p_Agreement_rec.invoice_to_customer_id) THEN
630: x_return_status := FND_API.G_RET_STS_ERROR;
631: END IF;
632: END IF;
633:
634: IF (p_Agreement_rec.attribute1 IS NOT NULL AND

Line 772: x_return_status := FND_API.G_RET_STS_ERROR;

768:
769: -- Validate descriptive flexfield.
770:
771: IF NOT OE_Validate_Attr.Desc_Flex( 'AGREEMENT' ) THEN
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: END IF;
774:
775: END IF;
776:

Line 781: WHEN FND_API.G_EXC_ERROR THEN

777: -- Done validating attributes
778:
779: EXCEPTION
780:
781: WHEN FND_API.G_EXC_ERROR THEN
782:
783: x_return_status := FND_API.G_RET_STS_ERROR;
784:
785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 783: x_return_status := FND_API.G_RET_STS_ERROR;

779: EXCEPTION
780:
781: WHEN FND_API.G_EXC_ERROR THEN
782:
783: x_return_status := FND_API.G_RET_STS_ERROR;
784:
785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
786:
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

781: WHEN FND_API.G_EXC_ERROR THEN
782:
783: x_return_status := FND_API.G_RET_STS_ERROR;
784:
785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
786:
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
788:
789: WHEN OTHERS THEN

Line 787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

783: x_return_status := FND_API.G_RET_STS_ERROR;
784:
785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
786:
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
788:
789: WHEN OTHERS THEN
790:
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
788:
789: WHEN OTHERS THEN
790:
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
792:
793: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
794: THEN
795: OE_MSG_PUB.Add_Exc_Msg

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

806: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
807: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
808: )
809: IS
810: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
811: BEGIN
812:
813: -- Validate entity delete.
814:

Line 823: WHEN FND_API.G_EXC_ERROR THEN

819: x_return_status := l_return_status;
820:
821: EXCEPTION
822:
823: WHEN FND_API.G_EXC_ERROR THEN
824:
825: x_return_status := FND_API.G_RET_STS_ERROR;
826:
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 825: x_return_status := FND_API.G_RET_STS_ERROR;

821: EXCEPTION
822:
823: WHEN FND_API.G_EXC_ERROR THEN
824:
825: x_return_status := FND_API.G_RET_STS_ERROR;
826:
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828:
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

823: WHEN FND_API.G_EXC_ERROR THEN
824:
825: x_return_status := FND_API.G_RET_STS_ERROR;
826:
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828:
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830:
831: WHEN OTHERS THEN

Line 829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

825: x_return_status := FND_API.G_RET_STS_ERROR;
826:
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828:
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830:
831: WHEN OTHERS THEN
832:
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830:
831: WHEN OTHERS THEN
832:
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834:
835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837: OE_MSG_PUB.Add_Exc_Msg