DBA Data[Home] [Help]

APPS.OE_VALIDATE_AGREEMENT dependencies on OE_VALIDATE_ATTR

Line 301: IF NOT OE_Validate_Attr.Accounting_Rule(p_Agreement_rec.accounting_rule_id) THEN

297: ( p_Agreement_rec.accounting_rule_id <>
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:

Line 311: IF NOT OE_Validate_Attr.Agreement_Contact(p_Agreement_rec.agreement_contact_id) THEN

307: ( p_Agreement_rec.agreement_contact_id <>
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:

Line 321: IF NOT OE_Validate_Attr.Agreement(p_Agreement_rec.agreement_id) THEN

317: ( p_Agreement_rec.agreement_id <>
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:

Line 331: IF NOT OE_Validate_Attr.Agreement_Num(p_Agreement_rec.agreement_num) THEN

327: ( p_Agreement_rec.agreement_num <>
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:

Line 341: IF NOT OE_Validate_Attr.Agreement_Type(p_Agreement_rec.agreement_type_code) THEN

337: ( p_Agreement_rec.agreement_type_code <>
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:

Line 351: IF NOT OE_Validate_Attr.Created_By(p_Agreement_rec.created_by) THEN

347: ( p_Agreement_rec.created_by <>
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:

Line 361: IF NOT OE_Validate_Attr.Creation_Date(p_Agreement_rec.creation_date) THEN

357: ( p_Agreement_rec.creation_date <>
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:

Line 373: IF NOT OE_Validate_Attr.Customer(p_Agreement_rec.sold_to_org_id) THEN

369: ( p_Agreement_rec.sold_to_org_id <>
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:

Line 386: IF NOT OE_Validate_Attr.Customer(p_Agreement_rec.customer_id) THEN

382: ( p_Agreement_rec.customer_id <>
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: */

Line 397: IF NOT OE_Validate_Attr.End_Date_Active(p_Agreement_rec.end_date_active) THEN

393: ( p_Agreement_rec.end_date_active <>
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:

Line 407: IF NOT OE_Validate_Attr.Freight_Terms(p_Agreement_rec.freight_terms_code) THEN

403: ( p_Agreement_rec.freight_terms_code <>
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:

Line 417: IF NOT OE_Validate_Attr.Invoice_Contact(p_Agreement_rec.invoice_contact_id) THEN

413: ( p_Agreement_rec.invoice_contact_id <>
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:

Line 429: IF NOT OE_Validate_Attr.Invoice_To_Site_Use(p_Agreement_rec.invoice_to_org_id) THEN

425: ( p_Agreement_rec.invoice_to_org_id <>
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:

Line 440: IF NOT OE_Validate_Attr.Invoice_To_Site_Use(p_Agreement_rec.invoice_to_site_use_id) THEN

436: ( p_Agreement_rec.invoice_to_site_use_id <>
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: */

Line 451: IF NOT OE_Validate_Attr.Invoicing_Rule(p_Agreement_rec.invoicing_rule_id) THEN

447: ( p_Agreement_rec.invoicing_rule_id <>
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:

Line 461: IF NOT OE_Validate_Attr.Last_Updated_By(p_Agreement_rec.last_updated_by) THEN

457: ( p_Agreement_rec.last_updated_by <>
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:

Line 471: IF NOT OE_Validate_Attr.Last_Update_Date(p_Agreement_rec.last_update_date) THEN

467: ( p_Agreement_rec.last_update_date <>
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:

Line 481: IF NOT OE_Validate_Attr.Last_Update_Login(p_Agreement_rec.last_update_login) THEN

477: ( p_Agreement_rec.last_update_login <>
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:

Line 491: IF NOT OE_Validate_Attr.Name(p_Agreement_rec.name) THEN

487: ( p_Agreement_rec.name <>
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 */

Line 508: IF NOT OE_Validate_Attr.Override_Arule(p_Agreement_rec.override_arule_flag) THEN

504: ( p_Agreement_rec.override_arule_flag <>
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:

Line 518: IF NOT OE_Validate_Attr.Override_Irule(p_Agreement_rec.override_irule_flag) THEN

514: ( p_Agreement_rec.override_irule_flag <>
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:

Line 528: IF NOT OE_Validate_Attr.Price_List(p_Agreement_rec.price_list_id) THEN

524: ( p_Agreement_rec.price_list_id <>
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:

Line 538: IF NOT OE_Validate_Attr.Purchase_Order_Num(p_Agreement_rec.purchase_order_num) THEN

534: ( p_Agreement_rec.purchase_order_num <>
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:

Line 548: IF NOT OE_Validate_Attr.Revision(p_Agreement_rec.revision) THEN

544: ( p_Agreement_rec.revision <>
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:

Line 558: IF NOT OE_Validate_Attr.Revision_Date(p_Agreement_rec.revision_date) THEN

554: ( p_Agreement_rec.revision_date <>
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:

Line 568: IF NOT OE_Validate_Attr.Revision_Reason(p_Agreement_rec.revision_reason_code) THEN

564: ( p_Agreement_rec.revision_reason_code <>
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:

Line 578: IF NOT OE_Validate_Attr.Salesrep(p_Agreement_rec.salesrep_id) THEN

574: ( p_Agreement_rec.salesrep_id <>
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:

Line 588: IF NOT OE_Validate_Attr.Ship_Method(p_Agreement_rec.ship_method_code) THEN

584: ( p_Agreement_rec.ship_method_code <>
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:

Line 598: IF NOT OE_Validate_Attr.Signature_Date(p_Agreement_rec.signature_date) THEN

594: ( p_Agreement_rec.signature_date <>
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:

Line 608: IF NOT OE_Validate_Attr.Start_Date_Active(p_Agreement_rec.start_date_active) THEN

604: ( p_Agreement_rec.start_date_active <>
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:

Line 618: IF NOT OE_Validate_Attr.Term(p_Agreement_rec.term_id) THEN

614: ( p_Agreement_rec.term_id <>
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:

Line 629: IF NOT OE_Validate_Attr.Invoice_To_Customer_Id(p_Agreement_rec.invoice_to_customer_id) THEN

625: ( p_Agreement_rec.invoice_to_customer_id <>
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:

Line 771: IF NOT OE_Validate_Attr.Desc_Flex( 'AGREEMENT' ) THEN

767: */
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;