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

Line 11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
13: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
15: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type

Line 27: IF p_attr_id = FND_API.G_MISS_NUM THEN

23:
24: -- If attr_id is missing compare old and new records and for
25: -- every changed attribute clear its dependent fields.
26:
27: IF p_attr_id = FND_API.G_MISS_NUM THEN
28:
29: IF NOT OE_GLOBALS.Equal(p_Contract_rec.agreement_id,p_old_Contract_rec.agreement_id)
30: THEN
31: NULL;

Line 360: IF l_Contract_rec.agreement_id = FND_API.G_MISS_NUM THEN

356: IS
357: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
358: BEGIN
359:
360: IF l_Contract_rec.agreement_id = FND_API.G_MISS_NUM THEN
361: l_Contract_rec.agreement_id := p_old_Contract_rec.agreement_id;
362: END IF;
363:
364: IF l_Contract_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 364: IF l_Contract_rec.attribute1 = FND_API.G_MISS_CHAR THEN

360: IF l_Contract_rec.agreement_id = FND_API.G_MISS_NUM THEN
361: l_Contract_rec.agreement_id := p_old_Contract_rec.agreement_id;
362: END IF;
363:
364: IF l_Contract_rec.attribute1 = FND_API.G_MISS_CHAR THEN
365: l_Contract_rec.attribute1 := p_old_Contract_rec.attribute1;
366: END IF;
367:
368: IF l_Contract_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 368: IF l_Contract_rec.attribute10 = FND_API.G_MISS_CHAR THEN

364: IF l_Contract_rec.attribute1 = FND_API.G_MISS_CHAR THEN
365: l_Contract_rec.attribute1 := p_old_Contract_rec.attribute1;
366: END IF;
367:
368: IF l_Contract_rec.attribute10 = FND_API.G_MISS_CHAR THEN
369: l_Contract_rec.attribute10 := p_old_Contract_rec.attribute10;
370: END IF;
371:
372: IF l_Contract_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 372: IF l_Contract_rec.attribute11 = FND_API.G_MISS_CHAR THEN

368: IF l_Contract_rec.attribute10 = FND_API.G_MISS_CHAR THEN
369: l_Contract_rec.attribute10 := p_old_Contract_rec.attribute10;
370: END IF;
371:
372: IF l_Contract_rec.attribute11 = FND_API.G_MISS_CHAR THEN
373: l_Contract_rec.attribute11 := p_old_Contract_rec.attribute11;
374: END IF;
375:
376: IF l_Contract_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 376: IF l_Contract_rec.attribute12 = FND_API.G_MISS_CHAR THEN

372: IF l_Contract_rec.attribute11 = FND_API.G_MISS_CHAR THEN
373: l_Contract_rec.attribute11 := p_old_Contract_rec.attribute11;
374: END IF;
375:
376: IF l_Contract_rec.attribute12 = FND_API.G_MISS_CHAR THEN
377: l_Contract_rec.attribute12 := p_old_Contract_rec.attribute12;
378: END IF;
379:
380: IF l_Contract_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 380: IF l_Contract_rec.attribute13 = FND_API.G_MISS_CHAR THEN

376: IF l_Contract_rec.attribute12 = FND_API.G_MISS_CHAR THEN
377: l_Contract_rec.attribute12 := p_old_Contract_rec.attribute12;
378: END IF;
379:
380: IF l_Contract_rec.attribute13 = FND_API.G_MISS_CHAR THEN
381: l_Contract_rec.attribute13 := p_old_Contract_rec.attribute13;
382: END IF;
383:
384: IF l_Contract_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 384: IF l_Contract_rec.attribute14 = FND_API.G_MISS_CHAR THEN

380: IF l_Contract_rec.attribute13 = FND_API.G_MISS_CHAR THEN
381: l_Contract_rec.attribute13 := p_old_Contract_rec.attribute13;
382: END IF;
383:
384: IF l_Contract_rec.attribute14 = FND_API.G_MISS_CHAR THEN
385: l_Contract_rec.attribute14 := p_old_Contract_rec.attribute14;
386: END IF;
387:
388: IF l_Contract_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 388: IF l_Contract_rec.attribute15 = FND_API.G_MISS_CHAR THEN

384: IF l_Contract_rec.attribute14 = FND_API.G_MISS_CHAR THEN
385: l_Contract_rec.attribute14 := p_old_Contract_rec.attribute14;
386: END IF;
387:
388: IF l_Contract_rec.attribute15 = FND_API.G_MISS_CHAR THEN
389: l_Contract_rec.attribute15 := p_old_Contract_rec.attribute15;
390: END IF;
391:
392: IF l_Contract_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 392: IF l_Contract_rec.attribute2 = FND_API.G_MISS_CHAR THEN

388: IF l_Contract_rec.attribute15 = FND_API.G_MISS_CHAR THEN
389: l_Contract_rec.attribute15 := p_old_Contract_rec.attribute15;
390: END IF;
391:
392: IF l_Contract_rec.attribute2 = FND_API.G_MISS_CHAR THEN
393: l_Contract_rec.attribute2 := p_old_Contract_rec.attribute2;
394: END IF;
395:
396: IF l_Contract_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 396: IF l_Contract_rec.attribute3 = FND_API.G_MISS_CHAR THEN

392: IF l_Contract_rec.attribute2 = FND_API.G_MISS_CHAR THEN
393: l_Contract_rec.attribute2 := p_old_Contract_rec.attribute2;
394: END IF;
395:
396: IF l_Contract_rec.attribute3 = FND_API.G_MISS_CHAR THEN
397: l_Contract_rec.attribute3 := p_old_Contract_rec.attribute3;
398: END IF;
399:
400: IF l_Contract_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 400: IF l_Contract_rec.attribute4 = FND_API.G_MISS_CHAR THEN

396: IF l_Contract_rec.attribute3 = FND_API.G_MISS_CHAR THEN
397: l_Contract_rec.attribute3 := p_old_Contract_rec.attribute3;
398: END IF;
399:
400: IF l_Contract_rec.attribute4 = FND_API.G_MISS_CHAR THEN
401: l_Contract_rec.attribute4 := p_old_Contract_rec.attribute4;
402: END IF;
403:
404: IF l_Contract_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 404: IF l_Contract_rec.attribute5 = FND_API.G_MISS_CHAR THEN

400: IF l_Contract_rec.attribute4 = FND_API.G_MISS_CHAR THEN
401: l_Contract_rec.attribute4 := p_old_Contract_rec.attribute4;
402: END IF;
403:
404: IF l_Contract_rec.attribute5 = FND_API.G_MISS_CHAR THEN
405: l_Contract_rec.attribute5 := p_old_Contract_rec.attribute5;
406: END IF;
407:
408: IF l_Contract_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 408: IF l_Contract_rec.attribute6 = FND_API.G_MISS_CHAR THEN

404: IF l_Contract_rec.attribute5 = FND_API.G_MISS_CHAR THEN
405: l_Contract_rec.attribute5 := p_old_Contract_rec.attribute5;
406: END IF;
407:
408: IF l_Contract_rec.attribute6 = FND_API.G_MISS_CHAR THEN
409: l_Contract_rec.attribute6 := p_old_Contract_rec.attribute6;
410: END IF;
411:
412: IF l_Contract_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 412: IF l_Contract_rec.attribute7 = FND_API.G_MISS_CHAR THEN

408: IF l_Contract_rec.attribute6 = FND_API.G_MISS_CHAR THEN
409: l_Contract_rec.attribute6 := p_old_Contract_rec.attribute6;
410: END IF;
411:
412: IF l_Contract_rec.attribute7 = FND_API.G_MISS_CHAR THEN
413: l_Contract_rec.attribute7 := p_old_Contract_rec.attribute7;
414: END IF;
415:
416: IF l_Contract_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 416: IF l_Contract_rec.attribute8 = FND_API.G_MISS_CHAR THEN

412: IF l_Contract_rec.attribute7 = FND_API.G_MISS_CHAR THEN
413: l_Contract_rec.attribute7 := p_old_Contract_rec.attribute7;
414: END IF;
415:
416: IF l_Contract_rec.attribute8 = FND_API.G_MISS_CHAR THEN
417: l_Contract_rec.attribute8 := p_old_Contract_rec.attribute8;
418: END IF;
419:
420: IF l_Contract_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 420: IF l_Contract_rec.attribute9 = FND_API.G_MISS_CHAR THEN

416: IF l_Contract_rec.attribute8 = FND_API.G_MISS_CHAR THEN
417: l_Contract_rec.attribute8 := p_old_Contract_rec.attribute8;
418: END IF;
419:
420: IF l_Contract_rec.attribute9 = FND_API.G_MISS_CHAR THEN
421: l_Contract_rec.attribute9 := p_old_Contract_rec.attribute9;
422: END IF;
423:
424: IF l_Contract_rec.context = FND_API.G_MISS_CHAR THEN

Line 424: IF l_Contract_rec.context = FND_API.G_MISS_CHAR THEN

420: IF l_Contract_rec.attribute9 = FND_API.G_MISS_CHAR THEN
421: l_Contract_rec.attribute9 := p_old_Contract_rec.attribute9;
422: END IF;
423:
424: IF l_Contract_rec.context = FND_API.G_MISS_CHAR THEN
425: l_Contract_rec.context := p_old_Contract_rec.context;
426: END IF;
427:
428: IF l_Contract_rec.created_by = FND_API.G_MISS_NUM THEN

Line 428: IF l_Contract_rec.created_by = FND_API.G_MISS_NUM THEN

424: IF l_Contract_rec.context = FND_API.G_MISS_CHAR THEN
425: l_Contract_rec.context := p_old_Contract_rec.context;
426: END IF;
427:
428: IF l_Contract_rec.created_by = FND_API.G_MISS_NUM THEN
429: l_Contract_rec.created_by := p_old_Contract_rec.created_by;
430: END IF;
431:
432: IF l_Contract_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 432: IF l_Contract_rec.creation_date = FND_API.G_MISS_DATE THEN

428: IF l_Contract_rec.created_by = FND_API.G_MISS_NUM THEN
429: l_Contract_rec.created_by := p_old_Contract_rec.created_by;
430: END IF;
431:
432: IF l_Contract_rec.creation_date = FND_API.G_MISS_DATE THEN
433: l_Contract_rec.creation_date := p_old_Contract_rec.creation_date;
434: END IF;
435:
436: IF l_Contract_rec.discount_id = FND_API.G_MISS_NUM THEN

Line 436: IF l_Contract_rec.discount_id = FND_API.G_MISS_NUM THEN

432: IF l_Contract_rec.creation_date = FND_API.G_MISS_DATE THEN
433: l_Contract_rec.creation_date := p_old_Contract_rec.creation_date;
434: END IF;
435:
436: IF l_Contract_rec.discount_id = FND_API.G_MISS_NUM THEN
437: l_Contract_rec.discount_id := p_old_Contract_rec.discount_id;
438: END IF;
439:
440: IF l_Contract_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 440: IF l_Contract_rec.last_updated_by = FND_API.G_MISS_NUM THEN

436: IF l_Contract_rec.discount_id = FND_API.G_MISS_NUM THEN
437: l_Contract_rec.discount_id := p_old_Contract_rec.discount_id;
438: END IF;
439:
440: IF l_Contract_rec.last_updated_by = FND_API.G_MISS_NUM THEN
441: l_Contract_rec.last_updated_by := p_old_Contract_rec.last_updated_by;
442: END IF;
443:
444: IF l_Contract_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 444: IF l_Contract_rec.last_update_date = FND_API.G_MISS_DATE THEN

440: IF l_Contract_rec.last_updated_by = FND_API.G_MISS_NUM THEN
441: l_Contract_rec.last_updated_by := p_old_Contract_rec.last_updated_by;
442: END IF;
443:
444: IF l_Contract_rec.last_update_date = FND_API.G_MISS_DATE THEN
445: l_Contract_rec.last_update_date := p_old_Contract_rec.last_update_date;
446: END IF;
447:
448: IF l_Contract_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 448: IF l_Contract_rec.last_update_login = FND_API.G_MISS_NUM THEN

444: IF l_Contract_rec.last_update_date = FND_API.G_MISS_DATE THEN
445: l_Contract_rec.last_update_date := p_old_Contract_rec.last_update_date;
446: END IF;
447:
448: IF l_Contract_rec.last_update_login = FND_API.G_MISS_NUM THEN
449: l_Contract_rec.last_update_login := p_old_Contract_rec.last_update_login;
450: END IF;
451:
452: IF l_Contract_rec.price_list_id = FND_API.G_MISS_NUM THEN

Line 452: IF l_Contract_rec.price_list_id = FND_API.G_MISS_NUM THEN

448: IF l_Contract_rec.last_update_login = FND_API.G_MISS_NUM THEN
449: l_Contract_rec.last_update_login := p_old_Contract_rec.last_update_login;
450: END IF;
451:
452: IF l_Contract_rec.price_list_id = FND_API.G_MISS_NUM THEN
453: l_Contract_rec.price_list_id := p_old_Contract_rec.price_list_id;
454: END IF;
455:
456: IF l_Contract_rec.pricing_contract_id = FND_API.G_MISS_NUM THEN

Line 456: IF l_Contract_rec.pricing_contract_id = FND_API.G_MISS_NUM THEN

452: IF l_Contract_rec.price_list_id = FND_API.G_MISS_NUM THEN
453: l_Contract_rec.price_list_id := p_old_Contract_rec.price_list_id;
454: END IF;
455:
456: IF l_Contract_rec.pricing_contract_id = FND_API.G_MISS_NUM THEN
457: l_Contract_rec.pricing_contract_id := p_old_Contract_rec.pricing_contract_id;
458: END IF;
459:
460: RETURN l_Contract_rec;

Line 473: IF l_Contract_rec.agreement_id = FND_API.G_MISS_NUM THEN

469: IS
470: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
471: BEGIN
472:
473: IF l_Contract_rec.agreement_id = FND_API.G_MISS_NUM THEN
474: l_Contract_rec.agreement_id := NULL;
475: END IF;
476:
477: IF l_Contract_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 477: IF l_Contract_rec.attribute1 = FND_API.G_MISS_CHAR THEN

473: IF l_Contract_rec.agreement_id = FND_API.G_MISS_NUM THEN
474: l_Contract_rec.agreement_id := NULL;
475: END IF;
476:
477: IF l_Contract_rec.attribute1 = FND_API.G_MISS_CHAR THEN
478: l_Contract_rec.attribute1 := NULL;
479: END IF;
480:
481: IF l_Contract_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 481: IF l_Contract_rec.attribute10 = FND_API.G_MISS_CHAR THEN

477: IF l_Contract_rec.attribute1 = FND_API.G_MISS_CHAR THEN
478: l_Contract_rec.attribute1 := NULL;
479: END IF;
480:
481: IF l_Contract_rec.attribute10 = FND_API.G_MISS_CHAR THEN
482: l_Contract_rec.attribute10 := NULL;
483: END IF;
484:
485: IF l_Contract_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 485: IF l_Contract_rec.attribute11 = FND_API.G_MISS_CHAR THEN

481: IF l_Contract_rec.attribute10 = FND_API.G_MISS_CHAR THEN
482: l_Contract_rec.attribute10 := NULL;
483: END IF;
484:
485: IF l_Contract_rec.attribute11 = FND_API.G_MISS_CHAR THEN
486: l_Contract_rec.attribute11 := NULL;
487: END IF;
488:
489: IF l_Contract_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 489: IF l_Contract_rec.attribute12 = FND_API.G_MISS_CHAR THEN

485: IF l_Contract_rec.attribute11 = FND_API.G_MISS_CHAR THEN
486: l_Contract_rec.attribute11 := NULL;
487: END IF;
488:
489: IF l_Contract_rec.attribute12 = FND_API.G_MISS_CHAR THEN
490: l_Contract_rec.attribute12 := NULL;
491: END IF;
492:
493: IF l_Contract_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 493: IF l_Contract_rec.attribute13 = FND_API.G_MISS_CHAR THEN

489: IF l_Contract_rec.attribute12 = FND_API.G_MISS_CHAR THEN
490: l_Contract_rec.attribute12 := NULL;
491: END IF;
492:
493: IF l_Contract_rec.attribute13 = FND_API.G_MISS_CHAR THEN
494: l_Contract_rec.attribute13 := NULL;
495: END IF;
496:
497: IF l_Contract_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 497: IF l_Contract_rec.attribute14 = FND_API.G_MISS_CHAR THEN

493: IF l_Contract_rec.attribute13 = FND_API.G_MISS_CHAR THEN
494: l_Contract_rec.attribute13 := NULL;
495: END IF;
496:
497: IF l_Contract_rec.attribute14 = FND_API.G_MISS_CHAR THEN
498: l_Contract_rec.attribute14 := NULL;
499: END IF;
500:
501: IF l_Contract_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 501: IF l_Contract_rec.attribute15 = FND_API.G_MISS_CHAR THEN

497: IF l_Contract_rec.attribute14 = FND_API.G_MISS_CHAR THEN
498: l_Contract_rec.attribute14 := NULL;
499: END IF;
500:
501: IF l_Contract_rec.attribute15 = FND_API.G_MISS_CHAR THEN
502: l_Contract_rec.attribute15 := NULL;
503: END IF;
504:
505: IF l_Contract_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 505: IF l_Contract_rec.attribute2 = FND_API.G_MISS_CHAR THEN

501: IF l_Contract_rec.attribute15 = FND_API.G_MISS_CHAR THEN
502: l_Contract_rec.attribute15 := NULL;
503: END IF;
504:
505: IF l_Contract_rec.attribute2 = FND_API.G_MISS_CHAR THEN
506: l_Contract_rec.attribute2 := NULL;
507: END IF;
508:
509: IF l_Contract_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 509: IF l_Contract_rec.attribute3 = FND_API.G_MISS_CHAR THEN

505: IF l_Contract_rec.attribute2 = FND_API.G_MISS_CHAR THEN
506: l_Contract_rec.attribute2 := NULL;
507: END IF;
508:
509: IF l_Contract_rec.attribute3 = FND_API.G_MISS_CHAR THEN
510: l_Contract_rec.attribute3 := NULL;
511: END IF;
512:
513: IF l_Contract_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 513: IF l_Contract_rec.attribute4 = FND_API.G_MISS_CHAR THEN

509: IF l_Contract_rec.attribute3 = FND_API.G_MISS_CHAR THEN
510: l_Contract_rec.attribute3 := NULL;
511: END IF;
512:
513: IF l_Contract_rec.attribute4 = FND_API.G_MISS_CHAR THEN
514: l_Contract_rec.attribute4 := NULL;
515: END IF;
516:
517: IF l_Contract_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 517: IF l_Contract_rec.attribute5 = FND_API.G_MISS_CHAR THEN

513: IF l_Contract_rec.attribute4 = FND_API.G_MISS_CHAR THEN
514: l_Contract_rec.attribute4 := NULL;
515: END IF;
516:
517: IF l_Contract_rec.attribute5 = FND_API.G_MISS_CHAR THEN
518: l_Contract_rec.attribute5 := NULL;
519: END IF;
520:
521: IF l_Contract_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 521: IF l_Contract_rec.attribute6 = FND_API.G_MISS_CHAR THEN

517: IF l_Contract_rec.attribute5 = FND_API.G_MISS_CHAR THEN
518: l_Contract_rec.attribute5 := NULL;
519: END IF;
520:
521: IF l_Contract_rec.attribute6 = FND_API.G_MISS_CHAR THEN
522: l_Contract_rec.attribute6 := NULL;
523: END IF;
524:
525: IF l_Contract_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 525: IF l_Contract_rec.attribute7 = FND_API.G_MISS_CHAR THEN

521: IF l_Contract_rec.attribute6 = FND_API.G_MISS_CHAR THEN
522: l_Contract_rec.attribute6 := NULL;
523: END IF;
524:
525: IF l_Contract_rec.attribute7 = FND_API.G_MISS_CHAR THEN
526: l_Contract_rec.attribute7 := NULL;
527: END IF;
528:
529: IF l_Contract_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 529: IF l_Contract_rec.attribute8 = FND_API.G_MISS_CHAR THEN

525: IF l_Contract_rec.attribute7 = FND_API.G_MISS_CHAR THEN
526: l_Contract_rec.attribute7 := NULL;
527: END IF;
528:
529: IF l_Contract_rec.attribute8 = FND_API.G_MISS_CHAR THEN
530: l_Contract_rec.attribute8 := NULL;
531: END IF;
532:
533: IF l_Contract_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 533: IF l_Contract_rec.attribute9 = FND_API.G_MISS_CHAR THEN

529: IF l_Contract_rec.attribute8 = FND_API.G_MISS_CHAR THEN
530: l_Contract_rec.attribute8 := NULL;
531: END IF;
532:
533: IF l_Contract_rec.attribute9 = FND_API.G_MISS_CHAR THEN
534: l_Contract_rec.attribute9 := NULL;
535: END IF;
536:
537: IF l_Contract_rec.context = FND_API.G_MISS_CHAR THEN

Line 537: IF l_Contract_rec.context = FND_API.G_MISS_CHAR THEN

533: IF l_Contract_rec.attribute9 = FND_API.G_MISS_CHAR THEN
534: l_Contract_rec.attribute9 := NULL;
535: END IF;
536:
537: IF l_Contract_rec.context = FND_API.G_MISS_CHAR THEN
538: l_Contract_rec.context := NULL;
539: END IF;
540:
541: IF l_Contract_rec.created_by = FND_API.G_MISS_NUM THEN

Line 541: IF l_Contract_rec.created_by = FND_API.G_MISS_NUM THEN

537: IF l_Contract_rec.context = FND_API.G_MISS_CHAR THEN
538: l_Contract_rec.context := NULL;
539: END IF;
540:
541: IF l_Contract_rec.created_by = FND_API.G_MISS_NUM THEN
542: l_Contract_rec.created_by := NULL;
543: END IF;
544:
545: IF l_Contract_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 545: IF l_Contract_rec.creation_date = FND_API.G_MISS_DATE THEN

541: IF l_Contract_rec.created_by = FND_API.G_MISS_NUM THEN
542: l_Contract_rec.created_by := NULL;
543: END IF;
544:
545: IF l_Contract_rec.creation_date = FND_API.G_MISS_DATE THEN
546: l_Contract_rec.creation_date := NULL;
547: END IF;
548:
549: IF l_Contract_rec.discount_id = FND_API.G_MISS_NUM THEN

Line 549: IF l_Contract_rec.discount_id = FND_API.G_MISS_NUM THEN

545: IF l_Contract_rec.creation_date = FND_API.G_MISS_DATE THEN
546: l_Contract_rec.creation_date := NULL;
547: END IF;
548:
549: IF l_Contract_rec.discount_id = FND_API.G_MISS_NUM THEN
550: l_Contract_rec.discount_id := NULL;
551: END IF;
552:
553: IF l_Contract_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 553: IF l_Contract_rec.last_updated_by = FND_API.G_MISS_NUM THEN

549: IF l_Contract_rec.discount_id = FND_API.G_MISS_NUM THEN
550: l_Contract_rec.discount_id := NULL;
551: END IF;
552:
553: IF l_Contract_rec.last_updated_by = FND_API.G_MISS_NUM THEN
554: l_Contract_rec.last_updated_by := NULL;
555: END IF;
556:
557: IF l_Contract_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 557: IF l_Contract_rec.last_update_date = FND_API.G_MISS_DATE THEN

553: IF l_Contract_rec.last_updated_by = FND_API.G_MISS_NUM THEN
554: l_Contract_rec.last_updated_by := NULL;
555: END IF;
556:
557: IF l_Contract_rec.last_update_date = FND_API.G_MISS_DATE THEN
558: l_Contract_rec.last_update_date := NULL;
559: END IF;
560:
561: IF l_Contract_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 561: IF l_Contract_rec.last_update_login = FND_API.G_MISS_NUM THEN

557: IF l_Contract_rec.last_update_date = FND_API.G_MISS_DATE THEN
558: l_Contract_rec.last_update_date := NULL;
559: END IF;
560:
561: IF l_Contract_rec.last_update_login = FND_API.G_MISS_NUM THEN
562: l_Contract_rec.last_update_login := NULL;
563: END IF;
564:
565: IF l_Contract_rec.price_list_id = FND_API.G_MISS_NUM THEN

Line 565: IF l_Contract_rec.price_list_id = FND_API.G_MISS_NUM THEN

561: IF l_Contract_rec.last_update_login = FND_API.G_MISS_NUM THEN
562: l_Contract_rec.last_update_login := NULL;
563: END IF;
564:
565: IF l_Contract_rec.price_list_id = FND_API.G_MISS_NUM THEN
566: l_Contract_rec.price_list_id := NULL;
567: END IF;
568:
569: IF l_Contract_rec.pricing_contract_id = FND_API.G_MISS_NUM THEN

Line 569: IF l_Contract_rec.pricing_contract_id = FND_API.G_MISS_NUM THEN

565: IF l_Contract_rec.price_list_id = FND_API.G_MISS_NUM THEN
566: l_Contract_rec.price_list_id := NULL;
567: END IF;
568:
569: IF l_Contract_rec.pricing_contract_id = FND_API.G_MISS_NUM THEN
570: l_Contract_rec.pricing_contract_id := NULL;
571: END IF;
572:
573: RETURN l_Contract_rec;

Line 626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

622: , 'Update_Row'
623: );
624: END IF;
625:
626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627:
628: END Update_Row;
629:
630: -- Procedure Insert_Row

Line 709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

705: , 'Insert_Row'
706: );
707: END IF;
708:
709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
710:
711: END Insert_Row;
712:
713: -- Procedure Delete_Row

Line 737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

733: , 'Delete_Row'
734: );
735: END IF;
736:
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738:
739: END Delete_Row;
740:
741: -- Function Query_Row

Line 818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

814: , 'Query_Row'
815: );
816: END IF;
817:
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819:
820: END Query_Row;
821:
822: -- Procedure lock_Row

Line 892: ((p_Contract_rec.agreement_id = FND_API.G_MISS_NUM) OR

888: -- Row locked. Compare IN attributes to DB attributes.
889:
890: IF ( (l_Contract_rec.agreement_id =
891: p_Contract_rec.agreement_id) OR
892: ((p_Contract_rec.agreement_id = FND_API.G_MISS_NUM) OR
893: ( (l_Contract_rec.agreement_id IS NULL) AND
894: (p_Contract_rec.agreement_id IS NULL))))
895: AND ( (l_Contract_rec.attribute1 =
896: p_Contract_rec.attribute1) OR

Line 897: ((p_Contract_rec.attribute1 = FND_API.G_MISS_CHAR) OR

893: ( (l_Contract_rec.agreement_id IS NULL) AND
894: (p_Contract_rec.agreement_id IS NULL))))
895: AND ( (l_Contract_rec.attribute1 =
896: p_Contract_rec.attribute1) OR
897: ((p_Contract_rec.attribute1 = FND_API.G_MISS_CHAR) OR
898: ( (l_Contract_rec.attribute1 IS NULL) AND
899: (p_Contract_rec.attribute1 IS NULL))))
900: AND ( (l_Contract_rec.attribute10 =
901: p_Contract_rec.attribute10) OR

Line 902: ((p_Contract_rec.attribute10 = FND_API.G_MISS_CHAR) OR

898: ( (l_Contract_rec.attribute1 IS NULL) AND
899: (p_Contract_rec.attribute1 IS NULL))))
900: AND ( (l_Contract_rec.attribute10 =
901: p_Contract_rec.attribute10) OR
902: ((p_Contract_rec.attribute10 = FND_API.G_MISS_CHAR) OR
903: ( (l_Contract_rec.attribute10 IS NULL) AND
904: (p_Contract_rec.attribute10 IS NULL))))
905: AND ( (l_Contract_rec.attribute11 =
906: p_Contract_rec.attribute11) OR

Line 907: ((p_Contract_rec.attribute11 = FND_API.G_MISS_CHAR) OR

903: ( (l_Contract_rec.attribute10 IS NULL) AND
904: (p_Contract_rec.attribute10 IS NULL))))
905: AND ( (l_Contract_rec.attribute11 =
906: p_Contract_rec.attribute11) OR
907: ((p_Contract_rec.attribute11 = FND_API.G_MISS_CHAR) OR
908: ( (l_Contract_rec.attribute11 IS NULL) AND
909: (p_Contract_rec.attribute11 IS NULL))))
910: AND ( (l_Contract_rec.attribute12 =
911: p_Contract_rec.attribute12) OR

Line 912: ((p_Contract_rec.attribute12 = FND_API.G_MISS_CHAR) OR

908: ( (l_Contract_rec.attribute11 IS NULL) AND
909: (p_Contract_rec.attribute11 IS NULL))))
910: AND ( (l_Contract_rec.attribute12 =
911: p_Contract_rec.attribute12) OR
912: ((p_Contract_rec.attribute12 = FND_API.G_MISS_CHAR) OR
913: ( (l_Contract_rec.attribute12 IS NULL) AND
914: (p_Contract_rec.attribute12 IS NULL))))
915: AND ( (l_Contract_rec.attribute13 =
916: p_Contract_rec.attribute13) OR

Line 917: ((p_Contract_rec.attribute13 = FND_API.G_MISS_CHAR) OR

913: ( (l_Contract_rec.attribute12 IS NULL) AND
914: (p_Contract_rec.attribute12 IS NULL))))
915: AND ( (l_Contract_rec.attribute13 =
916: p_Contract_rec.attribute13) OR
917: ((p_Contract_rec.attribute13 = FND_API.G_MISS_CHAR) OR
918: ( (l_Contract_rec.attribute13 IS NULL) AND
919: (p_Contract_rec.attribute13 IS NULL))))
920: AND ( (l_Contract_rec.attribute14 =
921: p_Contract_rec.attribute14) OR

Line 922: ((p_Contract_rec.attribute14 = FND_API.G_MISS_CHAR) OR

918: ( (l_Contract_rec.attribute13 IS NULL) AND
919: (p_Contract_rec.attribute13 IS NULL))))
920: AND ( (l_Contract_rec.attribute14 =
921: p_Contract_rec.attribute14) OR
922: ((p_Contract_rec.attribute14 = FND_API.G_MISS_CHAR) OR
923: ( (l_Contract_rec.attribute14 IS NULL) AND
924: (p_Contract_rec.attribute14 IS NULL))))
925: AND ( (l_Contract_rec.attribute15 =
926: p_Contract_rec.attribute15) OR

Line 927: ((p_Contract_rec.attribute15 = FND_API.G_MISS_CHAR) OR

923: ( (l_Contract_rec.attribute14 IS NULL) AND
924: (p_Contract_rec.attribute14 IS NULL))))
925: AND ( (l_Contract_rec.attribute15 =
926: p_Contract_rec.attribute15) OR
927: ((p_Contract_rec.attribute15 = FND_API.G_MISS_CHAR) OR
928: ( (l_Contract_rec.attribute15 IS NULL) AND
929: (p_Contract_rec.attribute15 IS NULL))))
930: AND ( (l_Contract_rec.attribute2 =
931: p_Contract_rec.attribute2) OR

Line 932: ((p_Contract_rec.attribute2 = FND_API.G_MISS_CHAR) OR

928: ( (l_Contract_rec.attribute15 IS NULL) AND
929: (p_Contract_rec.attribute15 IS NULL))))
930: AND ( (l_Contract_rec.attribute2 =
931: p_Contract_rec.attribute2) OR
932: ((p_Contract_rec.attribute2 = FND_API.G_MISS_CHAR) OR
933: ( (l_Contract_rec.attribute2 IS NULL) AND
934: (p_Contract_rec.attribute2 IS NULL))))
935: AND ( (l_Contract_rec.attribute3 =
936: p_Contract_rec.attribute3) OR

Line 937: ((p_Contract_rec.attribute3 = FND_API.G_MISS_CHAR) OR

933: ( (l_Contract_rec.attribute2 IS NULL) AND
934: (p_Contract_rec.attribute2 IS NULL))))
935: AND ( (l_Contract_rec.attribute3 =
936: p_Contract_rec.attribute3) OR
937: ((p_Contract_rec.attribute3 = FND_API.G_MISS_CHAR) OR
938: ( (l_Contract_rec.attribute3 IS NULL) AND
939: (p_Contract_rec.attribute3 IS NULL))))
940: AND ( (l_Contract_rec.attribute4 =
941: p_Contract_rec.attribute4) OR

Line 942: ((p_Contract_rec.attribute4 = FND_API.G_MISS_CHAR) OR

938: ( (l_Contract_rec.attribute3 IS NULL) AND
939: (p_Contract_rec.attribute3 IS NULL))))
940: AND ( (l_Contract_rec.attribute4 =
941: p_Contract_rec.attribute4) OR
942: ((p_Contract_rec.attribute4 = FND_API.G_MISS_CHAR) OR
943: ( (l_Contract_rec.attribute4 IS NULL) AND
944: (p_Contract_rec.attribute4 IS NULL))))
945: AND ( (l_Contract_rec.attribute5 =
946: p_Contract_rec.attribute5) OR

Line 947: ((p_Contract_rec.attribute5 = FND_API.G_MISS_CHAR) OR

943: ( (l_Contract_rec.attribute4 IS NULL) AND
944: (p_Contract_rec.attribute4 IS NULL))))
945: AND ( (l_Contract_rec.attribute5 =
946: p_Contract_rec.attribute5) OR
947: ((p_Contract_rec.attribute5 = FND_API.G_MISS_CHAR) OR
948: ( (l_Contract_rec.attribute5 IS NULL) AND
949: (p_Contract_rec.attribute5 IS NULL))))
950: AND ( (l_Contract_rec.attribute6 =
951: p_Contract_rec.attribute6) OR

Line 952: ((p_Contract_rec.attribute6 = FND_API.G_MISS_CHAR) OR

948: ( (l_Contract_rec.attribute5 IS NULL) AND
949: (p_Contract_rec.attribute5 IS NULL))))
950: AND ( (l_Contract_rec.attribute6 =
951: p_Contract_rec.attribute6) OR
952: ((p_Contract_rec.attribute6 = FND_API.G_MISS_CHAR) OR
953: ( (l_Contract_rec.attribute6 IS NULL) AND
954: (p_Contract_rec.attribute6 IS NULL))))
955: AND ( (l_Contract_rec.attribute7 =
956: p_Contract_rec.attribute7) OR

Line 957: ((p_Contract_rec.attribute7 = FND_API.G_MISS_CHAR) OR

953: ( (l_Contract_rec.attribute6 IS NULL) AND
954: (p_Contract_rec.attribute6 IS NULL))))
955: AND ( (l_Contract_rec.attribute7 =
956: p_Contract_rec.attribute7) OR
957: ((p_Contract_rec.attribute7 = FND_API.G_MISS_CHAR) OR
958: ( (l_Contract_rec.attribute7 IS NULL) AND
959: (p_Contract_rec.attribute7 IS NULL))))
960: AND ( (l_Contract_rec.attribute8 =
961: p_Contract_rec.attribute8) OR

Line 962: ((p_Contract_rec.attribute8 = FND_API.G_MISS_CHAR) OR

958: ( (l_Contract_rec.attribute7 IS NULL) AND
959: (p_Contract_rec.attribute7 IS NULL))))
960: AND ( (l_Contract_rec.attribute8 =
961: p_Contract_rec.attribute8) OR
962: ((p_Contract_rec.attribute8 = FND_API.G_MISS_CHAR) OR
963: ( (l_Contract_rec.attribute8 IS NULL) AND
964: (p_Contract_rec.attribute8 IS NULL))))
965: AND ( (l_Contract_rec.attribute9 =
966: p_Contract_rec.attribute9) OR

Line 967: ((p_Contract_rec.attribute9 = FND_API.G_MISS_CHAR) OR

963: ( (l_Contract_rec.attribute8 IS NULL) AND
964: (p_Contract_rec.attribute8 IS NULL))))
965: AND ( (l_Contract_rec.attribute9 =
966: p_Contract_rec.attribute9) OR
967: ((p_Contract_rec.attribute9 = FND_API.G_MISS_CHAR) OR
968: ( (l_Contract_rec.attribute9 IS NULL) AND
969: (p_Contract_rec.attribute9 IS NULL))))
970: AND ( (l_Contract_rec.context =
971: p_Contract_rec.context) OR

Line 972: ((p_Contract_rec.context = FND_API.G_MISS_CHAR) OR

968: ( (l_Contract_rec.attribute9 IS NULL) AND
969: (p_Contract_rec.attribute9 IS NULL))))
970: AND ( (l_Contract_rec.context =
971: p_Contract_rec.context) OR
972: ((p_Contract_rec.context = FND_API.G_MISS_CHAR) OR
973: ( (l_Contract_rec.context IS NULL) AND
974: (p_Contract_rec.context IS NULL))))
975: AND ( (l_Contract_rec.created_by =
976: p_Contract_rec.created_by) OR

Line 977: ((p_Contract_rec.created_by = FND_API.G_MISS_NUM) OR

973: ( (l_Contract_rec.context IS NULL) AND
974: (p_Contract_rec.context IS NULL))))
975: AND ( (l_Contract_rec.created_by =
976: p_Contract_rec.created_by) OR
977: ((p_Contract_rec.created_by = FND_API.G_MISS_NUM) OR
978: ( (l_Contract_rec.created_by IS NULL) AND
979: (p_Contract_rec.created_by IS NULL))))
980: AND ( (l_Contract_rec.creation_date =
981: p_Contract_rec.creation_date) OR

Line 982: ((p_Contract_rec.creation_date = FND_API.G_MISS_DATE) OR

978: ( (l_Contract_rec.created_by IS NULL) AND
979: (p_Contract_rec.created_by IS NULL))))
980: AND ( (l_Contract_rec.creation_date =
981: p_Contract_rec.creation_date) OR
982: ((p_Contract_rec.creation_date = FND_API.G_MISS_DATE) OR
983: ( (l_Contract_rec.creation_date IS NULL) AND
984: (p_Contract_rec.creation_date IS NULL))))
985: AND ( (l_Contract_rec.discount_id =
986: p_Contract_rec.discount_id) OR

Line 987: ((p_Contract_rec.discount_id = FND_API.G_MISS_NUM) OR

983: ( (l_Contract_rec.creation_date IS NULL) AND
984: (p_Contract_rec.creation_date IS NULL))))
985: AND ( (l_Contract_rec.discount_id =
986: p_Contract_rec.discount_id) OR
987: ((p_Contract_rec.discount_id = FND_API.G_MISS_NUM) OR
988: ( (l_Contract_rec.discount_id IS NULL) AND
989: (p_Contract_rec.discount_id IS NULL))))
990: AND ( (l_Contract_rec.last_updated_by =
991: p_Contract_rec.last_updated_by) OR

Line 992: ((p_Contract_rec.last_updated_by = FND_API.G_MISS_NUM) OR

988: ( (l_Contract_rec.discount_id IS NULL) AND
989: (p_Contract_rec.discount_id IS NULL))))
990: AND ( (l_Contract_rec.last_updated_by =
991: p_Contract_rec.last_updated_by) OR
992: ((p_Contract_rec.last_updated_by = FND_API.G_MISS_NUM) OR
993: ( (l_Contract_rec.last_updated_by IS NULL) AND
994: (p_Contract_rec.last_updated_by IS NULL))))
995: AND ( (l_Contract_rec.last_update_date =
996: p_Contract_rec.last_update_date) OR

Line 997: ((p_Contract_rec.last_update_date = FND_API.G_MISS_DATE) OR

993: ( (l_Contract_rec.last_updated_by IS NULL) AND
994: (p_Contract_rec.last_updated_by IS NULL))))
995: AND ( (l_Contract_rec.last_update_date =
996: p_Contract_rec.last_update_date) OR
997: ((p_Contract_rec.last_update_date = FND_API.G_MISS_DATE) OR
998: ( (l_Contract_rec.last_update_date IS NULL) AND
999: (p_Contract_rec.last_update_date IS NULL))))
1000: AND ( (l_Contract_rec.last_update_login =
1001: p_Contract_rec.last_update_login) OR

Line 1002: ((p_Contract_rec.last_update_login = FND_API.G_MISS_NUM) OR

998: ( (l_Contract_rec.last_update_date IS NULL) AND
999: (p_Contract_rec.last_update_date IS NULL))))
1000: AND ( (l_Contract_rec.last_update_login =
1001: p_Contract_rec.last_update_login) OR
1002: ((p_Contract_rec.last_update_login = FND_API.G_MISS_NUM) OR
1003: ( (l_Contract_rec.last_update_login IS NULL) AND
1004: (p_Contract_rec.last_update_login IS NULL))))
1005: AND ( (l_Contract_rec.price_list_id =
1006: p_Contract_rec.price_list_id) OR

Line 1007: ((p_Contract_rec.price_list_id = FND_API.G_MISS_NUM) OR

1003: ( (l_Contract_rec.last_update_login IS NULL) AND
1004: (p_Contract_rec.last_update_login IS NULL))))
1005: AND ( (l_Contract_rec.price_list_id =
1006: p_Contract_rec.price_list_id) OR
1007: ((p_Contract_rec.price_list_id = FND_API.G_MISS_NUM) OR
1008: ( (l_Contract_rec.price_list_id IS NULL) AND
1009: (p_Contract_rec.price_list_id IS NULL))))
1010: AND ( (l_Contract_rec.pricing_contract_id =
1011: p_Contract_rec.pricing_contract_id) OR

Line 1012: ((p_Contract_rec.pricing_contract_id = FND_API.G_MISS_NUM) OR

1008: ( (l_Contract_rec.price_list_id IS NULL) AND
1009: (p_Contract_rec.price_list_id IS NULL))))
1010: AND ( (l_Contract_rec.pricing_contract_id =
1011: p_Contract_rec.pricing_contract_id) OR
1012: ((p_Contract_rec.pricing_contract_id = FND_API.G_MISS_NUM) OR
1013: ( (l_Contract_rec.pricing_contract_id IS NULL) AND
1014: (p_Contract_rec.pricing_contract_id IS NULL))))
1015: THEN
1016:

Line 1023: x_return_status := FND_API.G_RET_STS_SUCCESS;

1019: x_Contract_rec := l_Contract_rec;
1020:
1021: -- Set return status
1022:
1023: x_return_status := FND_API.G_RET_STS_SUCCESS;
1024: x_Contract_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1025:
1026: ELSE
1027:

Line 1024: x_Contract_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1020:
1021: -- Set return status
1022:
1023: x_return_status := FND_API.G_RET_STS_SUCCESS;
1024: x_Contract_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1025:
1026: ELSE
1027:
1028: -- Row has changed by another user.

Line 1030: x_return_status := FND_API.G_RET_STS_ERROR;

1026: ELSE
1027:
1028: -- Row has changed by another user.
1029:
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1032:
1033: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1034: THEN

Line 1031: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;

1027:
1028: -- Row has changed by another user.
1029:
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1032:
1033: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1034: THEN
1035:

Line 1047: x_return_status := FND_API.G_RET_STS_ERROR;

1043: EXCEPTION
1044:
1045: WHEN NO_DATA_FOUND THEN
1046:
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1049:
1050: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1051: THEN

Line 1048: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;

1044:
1045: WHEN NO_DATA_FOUND THEN
1046:
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1049:
1050: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1051: THEN
1052:

Line 1059: x_return_status := FND_API.G_RET_STS_ERROR;

1055:
1056: END IF;
1057: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1058:
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1061:
1062: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1063: THEN

Line 1060: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;

1056: END IF;
1057: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1058:
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1061:
1062: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1063: THEN
1064:

Line 1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1067:
1068: END IF;
1069: WHEN OTHERS THEN
1070:
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: x_Contract_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073:
1074: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1075: THEN

Line 1072: x_Contract_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1068: END IF;
1069: WHEN OTHERS THEN
1070:
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: x_Contract_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073:
1074: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1075: THEN
1076: OE_MSG_PUB.Add_Exc_Msg

Line 1096: p_Contract_rec.agreement_id <> FND_API.G_MISS_NUM AND

1092: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
1093: BEGIN
1094:
1095: IF p_Contract_rec.agreement_id IS NOT NULL AND
1096: p_Contract_rec.agreement_id <> FND_API.G_MISS_NUM AND
1097: NOT OE_GLOBALS.Equal(p_Contract_rec.agreement_id,
1098: p_old_Contract_rec.agreement_id)
1099: THEN
1100: l_Contract_val_rec.agreement := OE_Id_To_Value.Agreement

Line 1106: p_Contract_rec.discount_id <> FND_API.G_MISS_NUM AND

1102: );
1103: END IF;
1104:
1105: IF p_Contract_rec.discount_id IS NOT NULL AND
1106: p_Contract_rec.discount_id <> FND_API.G_MISS_NUM AND
1107: NOT OE_GLOBALS.Equal(p_Contract_rec.discount_id,
1108: p_old_Contract_rec.discount_id)
1109: THEN
1110: l_Contract_val_rec.discount := OE_Id_To_Value.Discount

Line 1116: p_Contract_rec.price_list_id <> FND_API.G_MISS_NUM AND

1112: );
1113: END IF;
1114:
1115: IF p_Contract_rec.price_list_id IS NOT NULL AND
1116: p_Contract_rec.price_list_id <> FND_API.G_MISS_NUM AND
1117: NOT OE_GLOBALS.Equal(p_Contract_rec.price_list_id,
1118: p_old_Contract_rec.price_list_id)
1119: THEN
1120: l_Contract_val_rec.price_list := OE_Id_To_Value.Price_List

Line 1141: l_Contract_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1137: BEGIN
1138:
1139: -- initialize return_status.
1140:
1141: l_Contract_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1142:
1143: -- initialize l_Contract_rec.
1144:
1145: l_Contract_rec := p_Contract_rec;

Line 1147: IF p_Contract_val_rec.agreement <> FND_API.G_MISS_CHAR

1143: -- initialize l_Contract_rec.
1144:
1145: l_Contract_rec := p_Contract_rec;
1146:
1147: IF p_Contract_val_rec.agreement <> FND_API.G_MISS_CHAR
1148: THEN
1149:
1150: IF p_Contract_rec.agreement_id <> FND_API.G_MISS_NUM THEN
1151:

Line 1150: IF p_Contract_rec.agreement_id <> FND_API.G_MISS_NUM THEN

1146:
1147: IF p_Contract_val_rec.agreement <> FND_API.G_MISS_CHAR
1148: THEN
1149:
1150: IF p_Contract_rec.agreement_id <> FND_API.G_MISS_NUM THEN
1151:
1152: l_Contract_rec.agreement_id := p_Contract_rec.agreement_id;
1153:
1154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1169: IF l_Contract_rec.agreement_id = FND_API.G_MISS_NUM THEN

1165: l_Contract_rec.agreement_id := OE_Value_To_Id.agreement
1166: ( p_agreement => p_Contract_val_rec.agreement
1167: );
1168:
1169: IF l_Contract_rec.agreement_id = FND_API.G_MISS_NUM THEN
1170: l_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1171: END IF;
1172:
1173: END IF;

Line 1170: l_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;

1166: ( p_agreement => p_Contract_val_rec.agreement
1167: );
1168:
1169: IF l_Contract_rec.agreement_id = FND_API.G_MISS_NUM THEN
1170: l_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1171: END IF;
1172:
1173: END IF;
1174:

Line 1177: IF p_Contract_val_rec.discount <> FND_API.G_MISS_CHAR

1173: END IF;
1174:
1175: END IF;
1176:
1177: IF p_Contract_val_rec.discount <> FND_API.G_MISS_CHAR
1178: THEN
1179:
1180: IF p_Contract_rec.discount_id <> FND_API.G_MISS_NUM THEN
1181:

Line 1180: IF p_Contract_rec.discount_id <> FND_API.G_MISS_NUM THEN

1176:
1177: IF p_Contract_val_rec.discount <> FND_API.G_MISS_CHAR
1178: THEN
1179:
1180: IF p_Contract_rec.discount_id <> FND_API.G_MISS_NUM THEN
1181:
1182: l_Contract_rec.discount_id := p_Contract_rec.discount_id;
1183:
1184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1199: IF l_Contract_rec.discount_id = FND_API.G_MISS_NUM THEN

1195: l_Contract_rec.discount_id := OE_Value_To_Id.discount
1196: ( p_discount => p_Contract_val_rec.discount
1197: );
1198:
1199: IF l_Contract_rec.discount_id = FND_API.G_MISS_NUM THEN
1200: l_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1201: END IF;
1202:
1203: END IF;

Line 1200: l_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;

1196: ( p_discount => p_Contract_val_rec.discount
1197: );
1198:
1199: IF l_Contract_rec.discount_id = FND_API.G_MISS_NUM THEN
1200: l_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1201: END IF;
1202:
1203: END IF;
1204:

Line 1207: IF p_Contract_val_rec.price_list <> FND_API.G_MISS_CHAR

1203: END IF;
1204:
1205: END IF;
1206:
1207: IF p_Contract_val_rec.price_list <> FND_API.G_MISS_CHAR
1208: THEN
1209:
1210: IF p_Contract_rec.price_list_id <> FND_API.G_MISS_NUM THEN
1211:

Line 1210: IF p_Contract_rec.price_list_id <> FND_API.G_MISS_NUM THEN

1206:
1207: IF p_Contract_val_rec.price_list <> FND_API.G_MISS_CHAR
1208: THEN
1209:
1210: IF p_Contract_rec.price_list_id <> FND_API.G_MISS_NUM THEN
1211:
1212: l_Contract_rec.price_list_id := p_Contract_rec.price_list_id;
1213:
1214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1229: IF l_Contract_rec.price_list_id = FND_API.G_MISS_NUM THEN

1225: l_Contract_rec.price_list_id := OE_Value_To_Id.price_list
1226: ( p_price_list => p_Contract_val_rec.price_list
1227: );
1228:
1229: IF l_Contract_rec.price_list_id = FND_API.G_MISS_NUM THEN
1230: l_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1231: END IF;
1232:
1233: END IF;

Line 1230: l_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;

1226: ( p_price_list => p_Contract_val_rec.price_list
1227: );
1228:
1229: IF l_Contract_rec.price_list_id = FND_API.G_MISS_NUM THEN
1230: l_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1231: END IF;
1232:
1233: END IF;
1234: