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.GMS_PO_API_GRP dependencies on FND_API

Line 5: -- Declare package variables used for FND_API calls.

1: package BODY GMS_PO_API_GRP as
2: --$Header: gmsgpoxb.pls 120.3 2006/03/29 21:09:33 bkattupa noship $
3:
4: -- Start of comments
5: -- Declare package variables used for FND_API calls.
6: -- End of comments
7: -- ------------------
8:
9: G_api_version CONSTANT NUMBER := 1.0 ;

Line 87: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

83:
84: l_dummy NUMBER ;
85: BEGIN
86:
87: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
88:
89: IF NVL(p_interface_obj.distribution_id.COUNT,0) <= 0 then
90: return ;
91: END IF ;

Line 263: IF NOT FND_API.Compatible_API_Call( G_api_version,

259: and adl_line_num = 1 ;
260: begin
261: -- Standrad call to check API compatibility.
262:
263: IF NOT FND_API.Compatible_API_Call( G_api_version,
264: p_api_version,
265: l_api_name,
266: G_pkg_name ) THEN
267:

Line 268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

264: p_api_version,
265: l_api_name,
266: G_pkg_name ) THEN
267:
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
269: END IF ;
270:
271: -- Initialize message list if p_init_msg_list is set to TRUE
272: --

Line 273: IF FND_API.to_boolean( p_init_msg_list) THEN

269: END IF ;
270:
271: -- Initialize message list if p_init_msg_list is set to TRUE
272: --
273: IF FND_API.to_boolean( p_init_msg_list) THEN
274:
275: FND_MSG_PUB.initialize ;
276:
277: END IF ;

Line 281: l_return_status := FND_API.G_RET_STS_SUCCESS ;

277: END IF ;
278:
279: -- Initialize API return status to success.
280: --
281: l_return_status := FND_API.G_RET_STS_SUCCESS ;
282:
283: --
284: -- Determine the validation level
285: --

Line 286: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

282:
283: --
284: -- Determine the validation level
285: --
286: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
287:
288: -- No validation logic required for this API.
289: --
290: NULL ;

Line 317: RAISE FND_API.G_EXC_ERROR ;

313: -- Error processing and return from here.
314: --
315: FND_MESSAGE.set_name('GMS', 'GMS_ADL_NOT_FOUND') ;
316: FND_MSG_PUB.add ;
317: RAISE FND_API.G_EXC_ERROR ;
318: end if ;
319:
320: --
321: -- ADL creation starts here

Line 373: WHEN FND_API.G_EXC_ERROR then

369: x_msg_count := l_msg_count ;
370: x_msg_data := l_msg_data ;
371: x_return_status := l_return_status ;
372: EXCEPTION
373: WHEN FND_API.G_EXC_ERROR then
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
376: p_count => x_msg_count ,
377: p_data => x_msg_data ) ;

Line 374: x_return_status := FND_API.G_RET_STS_ERROR ;

370: x_msg_data := l_msg_data ;
371: x_return_status := l_return_status ;
372: EXCEPTION
373: WHEN FND_API.G_EXC_ERROR then
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
376: p_count => x_msg_count ,
377: p_data => x_msg_data ) ;
378:

Line 375: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

371: x_return_status := l_return_status ;
372: EXCEPTION
373: WHEN FND_API.G_EXC_ERROR then
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
376: p_count => x_msg_count ,
377: p_data => x_msg_data ) ;
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

375: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
376: p_count => x_msg_count ,
377: p_data => x_msg_data ) ;
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
382: p_count => x_msg_count ,
383: p_data => x_msg_data ) ;

Line 380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

376: p_count => x_msg_count ,
377: p_data => x_msg_data ) ;
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
382: p_count => x_msg_count ,
383: p_data => x_msg_data ) ;
384: WHEN OTHERS THEN

Line 381: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

377: p_data => x_msg_data ) ;
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
382: p_count => x_msg_count ,
383: p_data => x_msg_data ) ;
384: WHEN OTHERS THEN
385:

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

382: p_count => x_msg_count ,
383: p_data => x_msg_data ) ;
384: WHEN OTHERS THEN
385:
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
387: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
388: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
389: END IF ;
390: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

Line 390: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
387: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
388: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
389: END IF ;
390: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
391: p_count => x_msg_count ,
392: p_data => x_msg_data ) ;
393: end CREATE_COPY_DOC_ADL ;
394: -- ===========================

Line 443: IF NOT FND_API.Compatible_API_Call( G_api_version,

439: l_api_name varchar2(45) := 'create_autocreate_po_adl' ;
440: begin
441:
442: -- Standrad call to check API compatibility.
443: IF NOT FND_API.Compatible_API_Call( G_api_version,
444: p_api_version,
445: l_api_name,
446: G_pkg_name) THEN
447:

Line 448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

444: p_api_version,
445: l_api_name,
446: G_pkg_name) THEN
447:
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
449: END IF ;
450:
451: -- Initialize message list if p_init_msg_list is set to TRUE
452: --

Line 453: IF FND_API.to_boolean( p_init_msg_list) THEN

449: END IF ;
450:
451: -- Initialize message list if p_init_msg_list is set to TRUE
452: --
453: IF FND_API.to_boolean( p_init_msg_list) THEN
454:
455: FND_MSG_PUB.initialize ;
456:
457: END IF ;

Line 461: l_return_status := FND_API.G_RET_STS_SUCCESS ;

457: END IF ;
458:
459: -- Initialize API return status to success.
460: --
461: l_return_status := FND_API.G_RET_STS_SUCCESS ;
462:
463: --
464: -- Determine the validation level
465: --

Line 466: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

462:
463: --
464: -- Determine the validation level
465: --
466: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
467:
468: -- No validation logic required for this API.
469: --
470: NULL ;

Line 485: WHEN FND_API.G_EXC_ERROR then

481: x_msg_data := l_msg_data ;
482: x_return_status := l_return_status ;
483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_ERROR then
486: x_return_status := FND_API.G_RET_STS_ERROR ;
487: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
488: p_count => x_msg_count ,
489: p_data => x_msg_data ) ;

Line 486: x_return_status := FND_API.G_RET_STS_ERROR ;

482: x_return_status := l_return_status ;
483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_ERROR then
486: x_return_status := FND_API.G_RET_STS_ERROR ;
487: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
488: p_count => x_msg_count ,
489: p_data => x_msg_data ) ;
490:

Line 487: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_ERROR then
486: x_return_status := FND_API.G_RET_STS_ERROR ;
487: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
488: p_count => x_msg_count ,
489: p_data => x_msg_data ) ;
490:
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

487: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
488: p_count => x_msg_count ,
489: p_data => x_msg_data ) ;
490:
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
493: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
494: p_count => x_msg_count ,
495: p_data => x_msg_data ) ;

Line 492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

488: p_count => x_msg_count ,
489: p_data => x_msg_data ) ;
490:
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
493: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
494: p_count => x_msg_count ,
495: p_data => x_msg_data ) ;
496: WHEN OTHERS THEN

Line 493: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

489: p_data => x_msg_data ) ;
490:
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
493: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
494: p_count => x_msg_count ,
495: p_data => x_msg_data ) ;
496: WHEN OTHERS THEN
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

493: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
494: p_count => x_msg_count ,
495: p_data => x_msg_data ) ;
496: WHEN OTHERS THEN
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
498:
499: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
500: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
501: END IF ;

Line 503: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

499: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
500: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
501: END IF ;
502:
503: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
504: p_count => x_msg_count ,
505: p_data => x_msg_data ) ;
506: end CREATE_AUTOCREATE_PO_ADL ;
507:

Line 555: IF NOT FND_API.Compatible_API_Call( G_api_version,

551: l_api_name varchar2(45) := 'create_release_adl' ;
552: begin
553:
554: -- Standrad call to check API compatibility.
555: IF NOT FND_API.Compatible_API_Call( G_api_version,
556: p_api_version,
557: l_api_name,
558: G_pkg_name) THEN
559:

Line 560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

556: p_api_version,
557: l_api_name,
558: G_pkg_name) THEN
559:
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
561: END IF ;
562:
563: -- Initialize message list if p_init_msg_list is set to TRUE
564: --

Line 565: IF FND_API.to_boolean( p_init_msg_list) THEN

561: END IF ;
562:
563: -- Initialize message list if p_init_msg_list is set to TRUE
564: --
565: IF FND_API.to_boolean( p_init_msg_list) THEN
566:
567: FND_MSG_PUB.initialize ;
568:
569: END IF ;

Line 573: l_return_status := FND_API.G_RET_STS_SUCCESS ;

569: END IF ;
570:
571: -- Initialize API return status to success.
572: --
573: l_return_status := FND_API.G_RET_STS_SUCCESS ;
574:
575: --
576: -- Determine the validation level
577: --

Line 578: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

574:
575: --
576: -- Determine the validation level
577: --
578: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
579:
580: -- No validation logic required for this API.
581: --
582: NULL ;

Line 597: WHEN FND_API.G_EXC_ERROR then

593: x_msg_data := l_msg_data ;
594: x_return_status := l_return_status ;
595:
596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR then
598: x_return_status := FND_API.G_RET_STS_ERROR ;
599: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
600: p_count => x_msg_count ,
601: p_data => x_msg_data ) ;

Line 598: x_return_status := FND_API.G_RET_STS_ERROR ;

594: x_return_status := l_return_status ;
595:
596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR then
598: x_return_status := FND_API.G_RET_STS_ERROR ;
599: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
600: p_count => x_msg_count ,
601: p_data => x_msg_data ) ;
602:

Line 599: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

595:
596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR then
598: x_return_status := FND_API.G_RET_STS_ERROR ;
599: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
600: p_count => x_msg_count ,
601: p_data => x_msg_data ) ;
602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

599: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
600: p_count => x_msg_count ,
601: p_data => x_msg_data ) ;
602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
605: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
606: p_count => x_msg_count ,
607: p_data => x_msg_data ) ;

Line 604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

600: p_count => x_msg_count ,
601: p_data => x_msg_data ) ;
602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
605: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
606: p_count => x_msg_count ,
607: p_data => x_msg_data ) ;
608: WHEN OTHERS THEN

Line 605: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

601: p_data => x_msg_data ) ;
602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
605: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
606: p_count => x_msg_count ,
607: p_data => x_msg_data ) ;
608: WHEN OTHERS THEN
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

605: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
606: p_count => x_msg_count ,
607: p_data => x_msg_data ) ;
608: WHEN OTHERS THEN
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610:
611: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
612: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
613: END IF ;

Line 615: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

611: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
612: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
613: END IF ;
614:
615: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
616: p_count => x_msg_count ,
617: p_data => x_msg_data ) ;
618: end CREATE_RELEASE_ADL ;
619:

Line 658: IF NOT FND_API.Compatible_API_Call( G_api_version,

654: and adl.adl_line_num = 1 ;
655: begin
656:
657: -- Standrad call to check API compatibility.
658: IF NOT FND_API.Compatible_API_Call( G_api_version,
659: p_api_version,
660: l_api_name,
661: G_pkg_name) THEN
662:

Line 663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

659: p_api_version,
660: l_api_name,
661: G_pkg_name) THEN
662:
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
664: END IF ;
665:
666: -- Initialize message list if p_init_msg_list is set to TRUE
667: --

Line 668: IF FND_API.to_boolean( p_init_msg_list) THEN

664: END IF ;
665:
666: -- Initialize message list if p_init_msg_list is set to TRUE
667: --
668: IF FND_API.to_boolean( p_init_msg_list) THEN
669:
670: FND_MSG_PUB.initialize ;
671:
672: END IF ;

Line 676: l_return_status := FND_API.G_RET_STS_SUCCESS ;

672: END IF ;
673:
674: -- Initialize API return status to success.
675: --
676: l_return_status := FND_API.G_RET_STS_SUCCESS ;
677:
678: --
679: -- Determine the validation level
680: --

Line 681: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

677:
678: --
679: -- Determine the validation level
680: --
681: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
682:
683: -- No validation logic required for this API.
684: --
685: NULL ;

Line 709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

705: return l_award_number ;
706:
707: EXCEPTION
708: WHEN OTHERS THEN
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
710:
711: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
712: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
713: END IF ;

Line 715: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

711: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
712: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
713: END IF ;
714:
715: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
716: p_count => x_msg_count ,
717: p_data => x_msg_data ) ;
718: end GET_AWARD_NUMBER ;
719: -- ==================

Line 757: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;

753:
754: l_award_id NUMBER ;
755: l_msg_count NUMBER ;
756: l_msg_data varchar2(2000) ;
757: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
758: l_api_name varchar2(50) := 'get_award_id' ;
759: l_gms_enabled BOOLEAN ;
760:
761: BEGIN

Line 768: IF NOT FND_API.Compatible_API_Call( G_api_version,

764:
765:
766: -- Standrad call to check API compatibility.
767:
768: IF NOT FND_API.Compatible_API_Call( G_api_version,
769: p_api_version,
770: l_api_name,
771: G_pkg_name ) THEN
772:

Line 773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

769: p_api_version,
770: l_api_name,
771: G_pkg_name ) THEN
772:
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
774: END IF ;
775:
776: -- Initialize message list if p_init_msg_list is set to TRUE
777: --

Line 778: IF FND_API.to_boolean( p_init_msg_list) THEN

774: END IF ;
775:
776: -- Initialize message list if p_init_msg_list is set to TRUE
777: --
778: IF FND_API.to_boolean( p_init_msg_list) THEN
779:
780: FND_MSG_PUB.initialize ;
781:
782: END IF ;

Line 786: l_return_status := FND_API.G_RET_STS_SUCCESS ;

782: END IF ;
783:
784: -- Initialize API return status to success.
785: --
786: l_return_status := FND_API.G_RET_STS_SUCCESS ;
787:
788: --
789: -- Determine the validation level
790: --

Line 791: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

787:
788: --
789: -- Determine the validation level
790: --
791: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
792:
793: -- No validation logic required for this API.
794: --
795: NULL ;

Line 819: x_return_status := FND_API.G_RET_STS_ERROR ;

815: x_return_status := l_return_status ;
816: return l_award_id ;
817: EXCEPTION
818: WHEN NO_DATA_FOUND THEN
819: x_return_status := FND_API.G_RET_STS_ERROR ;
820: FND_MESSAGE.set_name('GMS', 'GMS_INVALID_AWARD') ;
821: FND_MSG_PUB.add ;
822: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
823: p_count => x_msg_count ,

Line 822: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

818: WHEN NO_DATA_FOUND THEN
819: x_return_status := FND_API.G_RET_STS_ERROR ;
820: FND_MESSAGE.set_name('GMS', 'GMS_INVALID_AWARD') ;
821: FND_MSG_PUB.add ;
822: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
823: p_count => x_msg_count ,
824: p_data => x_msg_data ) ;
825:
826: RETURN l_award_id ;

Line 828: WHEN FND_API.G_EXC_ERROR then

824: p_data => x_msg_data ) ;
825:
826: RETURN l_award_id ;
827:
828: WHEN FND_API.G_EXC_ERROR then
829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
831: p_count => x_msg_count ,
832: p_data => x_msg_data ) ;

Line 829: x_return_status := FND_API.G_RET_STS_ERROR ;

825:
826: RETURN l_award_id ;
827:
828: WHEN FND_API.G_EXC_ERROR then
829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
831: p_count => x_msg_count ,
832: p_data => x_msg_data ) ;
833:

Line 830: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

826: RETURN l_award_id ;
827:
828: WHEN FND_API.G_EXC_ERROR then
829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
831: p_count => x_msg_count ,
832: p_data => x_msg_data ) ;
833:
834: RETURN l_award_id ;

Line 836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

832: p_data => x_msg_data ) ;
833:
834: RETURN l_award_id ;
835:
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
838: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
839: p_count => x_msg_count ,
840: p_data => x_msg_data ) ;

Line 837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

833:
834: RETURN l_award_id ;
835:
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
838: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
839: p_count => x_msg_count ,
840: p_data => x_msg_data ) ;
841: RETURN l_award_id ;

Line 838: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

834: RETURN l_award_id ;
835:
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
838: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
839: p_count => x_msg_count ,
840: p_data => x_msg_data ) ;
841: RETURN l_award_id ;
842:

Line 845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

841: RETURN l_award_id ;
842:
843: WHEN OTHERS THEN
844:
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
847: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
848: END IF ;
849: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

Line 849: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
847: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
848: END IF ;
849: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
850: p_count => x_msg_count ,
851: p_data => x_msg_data ) ;
852: RETURN l_award_id ;
853: END GET_AWARD_ID ;

Line 903: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;

899: p_calling_module in varchar2) is
900:
901: l_msg_count NUMBER ;
902: l_msg_data varchar2(2000) ;
903: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
904: l_api_name varchar2(50) := 'validate_transaction' ;
905: l_sponsored_flag varchar2(1) ;
906: l_gms_enabled BOOLEAN ;
907: l_spon_project BOOLEAN ;

Line 923: IF NOT FND_API.Compatible_API_Call( G_api_version,

919: BEGIN
920:
921: -- Standrad call to check API compatibility.
922:
923: IF NOT FND_API.Compatible_API_Call( G_api_version,
924: p_api_version,
925: l_api_name,
926: G_pkg_name ) THEN
927:

Line 928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

924: p_api_version,
925: l_api_name,
926: G_pkg_name ) THEN
927:
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
929: END IF ;
930:
931: -- Initialize message list if p_init_msg_list is set to TRUE
932: --

Line 933: IF FND_API.to_boolean( p_init_msg_list) THEN

929: END IF ;
930:
931: -- Initialize message list if p_init_msg_list is set to TRUE
932: --
933: IF FND_API.to_boolean( p_init_msg_list) THEN
934:
935: FND_MSG_PUB.initialize ;
936:
937: END IF ;

Line 941: l_return_status := FND_API.G_RET_STS_SUCCESS ;

937: END IF ;
938:
939: -- Initialize API return status to success.
940: --
941: l_return_status := FND_API.G_RET_STS_SUCCESS ;
942: -- ----------------
943: -- BUG:4739557 x_return_status not initialized in validate_transactions.
944: --
945: x_return_status := l_return_status ;

Line 950: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

946:
947: --
948: -- Determine the validation level
949: --
950: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
951:
952: -- No validation logic required for this API.
953: --
954: NULL ;

Line 970: x_return_status := FND_API.G_RET_STS_ERROR ;

966: END IF ;
967:
968: IF l_spon_project then
969: IF p_award_id is null THEN
970: x_return_status := FND_API.G_RET_STS_ERROR ;
971: FND_MESSAGE.set_name('GMS', 'GMS_AWARD_REQUIRED') ;
972: FND_MSG_PUB.add ;
973: RAISE FND_API.G_EXC_ERROR ;
974: END IF ;

Line 973: RAISE FND_API.G_EXC_ERROR ;

969: IF p_award_id is null THEN
970: x_return_status := FND_API.G_RET_STS_ERROR ;
971: FND_MESSAGE.set_name('GMS', 'GMS_AWARD_REQUIRED') ;
972: FND_MSG_PUB.add ;
973: RAISE FND_API.G_EXC_ERROR ;
974: END IF ;
975: ELSE
976: IF p_award_id is not NULL THEN
977:

Line 978: x_return_status := FND_API.G_RET_STS_ERROR ;

974: END IF ;
975: ELSE
976: IF p_award_id is not NULL THEN
977:
978: x_return_status := FND_API.G_RET_STS_ERROR ;
979: FND_MESSAGE.set_name('GMS', 'GMS_AWARD_NOT_ALLOWED') ;
980: FND_MSG_PUB.add ;
981: RAISE FND_API.G_EXC_ERROR ;
982: ELSE

Line 981: RAISE FND_API.G_EXC_ERROR ;

977:
978: x_return_status := FND_API.G_RET_STS_ERROR ;
979: FND_MESSAGE.set_name('GMS', 'GMS_AWARD_NOT_ALLOWED') ;
980: FND_MSG_PUB.add ;
981: RAISE FND_API.G_EXC_ERROR ;
982: ELSE
983: RETURN ;
984: END IF ;
985: END IF ;

Line 993: x_return_status := FND_API.G_RET_STS_ERROR ;

989: return ;
990: END IF ;
991:
992: if l_project_type_class_code = 'CONTRACT' then
993: x_return_status := FND_API.G_RET_STS_ERROR ;
994: fnd_message.set_name('GMS','GMS_IP_INVALID_PROJ_TYPE');
995: FND_MSG_PUB.add ;
996: RAISE FND_API.G_EXC_ERROR ;
997: end if;

Line 996: RAISE FND_API.G_EXC_ERROR ;

992: if l_project_type_class_code = 'CONTRACT' then
993: x_return_status := FND_API.G_RET_STS_ERROR ;
994: fnd_message.set_name('GMS','GMS_IP_INVALID_PROJ_TYPE');
995: FND_MSG_PUB.add ;
996: RAISE FND_API.G_EXC_ERROR ;
997: end if;
998:
999: gms_transactions_pub.validate_transaction(p_project_id => p_project_id,
1000: p_task_id => p_task_id,

Line 1008: x_return_status := FND_API.G_RET_STS_ERROR ;

1004: p_calling_module => 'TXNVALID',
1005: p_outcome => l_msg_data );
1006: IF l_msg_data is NOT NULL then
1007:
1008: x_return_status := FND_API.G_RET_STS_ERROR ;
1009: fnd_message.set_name('GMS',l_msg_data );
1010: FND_MSG_PUB.add ;
1011: RAISE FND_API.G_EXC_ERROR ;
1012:

Line 1011: RAISE FND_API.G_EXC_ERROR ;

1007:
1008: x_return_status := FND_API.G_RET_STS_ERROR ;
1009: fnd_message.set_name('GMS',l_msg_data );
1010: FND_MSG_PUB.add ;
1011: RAISE FND_API.G_EXC_ERROR ;
1012:
1013: END IF ;
1014:
1015: x_msg_count := l_msg_count ;

Line 1019: WHEN FND_API.G_EXC_ERROR then

1015: x_msg_count := l_msg_count ;
1016: x_msg_data := l_msg_data ;
1017: x_return_status := l_return_status ;
1018: EXCEPTION
1019: WHEN FND_API.G_EXC_ERROR then
1020: x_return_status := FND_API.G_RET_STS_ERROR ;
1021: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1022: p_count => x_msg_count ,
1023: p_data => x_msg_data ) ;

Line 1020: x_return_status := FND_API.G_RET_STS_ERROR ;

1016: x_msg_data := l_msg_data ;
1017: x_return_status := l_return_status ;
1018: EXCEPTION
1019: WHEN FND_API.G_EXC_ERROR then
1020: x_return_status := FND_API.G_RET_STS_ERROR ;
1021: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1022: p_count => x_msg_count ,
1023: p_data => x_msg_data ) ;
1024:

Line 1021: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1017: x_return_status := l_return_status ;
1018: EXCEPTION
1019: WHEN FND_API.G_EXC_ERROR then
1020: x_return_status := FND_API.G_RET_STS_ERROR ;
1021: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1022: p_count => x_msg_count ,
1023: p_data => x_msg_data ) ;
1024:
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1021: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1022: p_count => x_msg_count ,
1023: p_data => x_msg_data ) ;
1024:
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1027: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1028: p_count => x_msg_count ,
1029: p_data => x_msg_data ) ;

Line 1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1022: p_count => x_msg_count ,
1023: p_data => x_msg_data ) ;
1024:
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1027: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1028: p_count => x_msg_count ,
1029: p_data => x_msg_data ) ;
1030: WHEN OTHERS THEN

Line 1027: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1023: p_data => x_msg_data ) ;
1024:
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1027: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1028: p_count => x_msg_count ,
1029: p_data => x_msg_data ) ;
1030: WHEN OTHERS THEN
1031:

Line 1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1028: p_count => x_msg_count ,
1029: p_data => x_msg_data ) ;
1030: WHEN OTHERS THEN
1031:
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1033: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1034: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
1035: END IF ;
1036: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

Line 1036: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1033: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1034: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
1035: END IF ;
1036: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1037: p_count => x_msg_count ,
1038: p_data => x_msg_data ) ;
1039: END validate_transaction ;
1040:

Line 1136: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;

1132: p_award_set_id IN NUMBER ) is
1133:
1134: l_msg_count NUMBER ;
1135: l_msg_data varchar2(2000) ;
1136: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
1137: l_api_name varchar2(50) := 'create_pdoi_adls' ;
1138: l_adl_rec gms_award_distributions%ROWTYPE;
1139: l_gms_enabled BOOLEAN ;
1140:

Line 1147: IF NOT FND_API.Compatible_API_Call( G_api_version,

1143: -- STUB API
1144: --
1145: -- Standrad call to check API compatibility.
1146:
1147: IF NOT FND_API.Compatible_API_Call( G_api_version,
1148: p_api_version,
1149: l_api_name,
1150: G_pkg_name ) THEN
1151:

Line 1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1148: p_api_version,
1149: l_api_name,
1150: G_pkg_name ) THEN
1151:
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1153: END IF ;
1154:
1155: -- Initialize message list if p_init_msg_list is set to TRUE
1156: --

Line 1157: IF FND_API.to_boolean( p_init_msg_list) THEN

1153: END IF ;
1154:
1155: -- Initialize message list if p_init_msg_list is set to TRUE
1156: --
1157: IF FND_API.to_boolean( p_init_msg_list) THEN
1158:
1159: FND_MSG_PUB.initialize ;
1160:
1161: END IF ;

Line 1165: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1161: END IF ;
1162:
1163: -- Initialize API return status to success.
1164: --
1165: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1166:
1167: --
1168: -- Determine the validation level
1169: --

Line 1170: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1166:
1167: --
1168: -- Determine the validation level
1169: --
1170: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1171:
1172: -- No validation logic required for this API.
1173: --
1174: NULL ;

Line 1216: WHEN FND_API.G_EXC_ERROR then

1212: x_msg_count := l_msg_count ;
1213: x_msg_data := l_msg_data ;
1214: x_return_status := l_return_status ;
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR then
1217: x_return_status := FND_API.G_RET_STS_ERROR ;
1218: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1219: p_count => x_msg_count ,
1220: p_data => x_msg_data ) ;

Line 1217: x_return_status := FND_API.G_RET_STS_ERROR ;

1213: x_msg_data := l_msg_data ;
1214: x_return_status := l_return_status ;
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR then
1217: x_return_status := FND_API.G_RET_STS_ERROR ;
1218: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1219: p_count => x_msg_count ,
1220: p_data => x_msg_data ) ;
1221:

Line 1218: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1214: x_return_status := l_return_status ;
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR then
1217: x_return_status := FND_API.G_RET_STS_ERROR ;
1218: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1219: p_count => x_msg_count ,
1220: p_data => x_msg_data ) ;
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1218: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1219: p_count => x_msg_count ,
1220: p_data => x_msg_data ) ;
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1224: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1225: p_count => x_msg_count ,
1226: p_data => x_msg_data ) ;

Line 1223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1219: p_count => x_msg_count ,
1220: p_data => x_msg_data ) ;
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1224: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1225: p_count => x_msg_count ,
1226: p_data => x_msg_data ) ;
1227: WHEN OTHERS THEN

Line 1224: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1220: p_data => x_msg_data ) ;
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1224: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1225: p_count => x_msg_count ,
1226: p_data => x_msg_data ) ;
1227: WHEN OTHERS THEN
1228:

Line 1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1225: p_count => x_msg_count ,
1226: p_data => x_msg_data ) ;
1227: WHEN OTHERS THEN
1228:
1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1230: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1231: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
1232: END IF ;
1233: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

Line 1233: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1230: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1231: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
1232: END IF ;
1233: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1234: p_count => x_msg_count ,
1235: p_data => x_msg_data ) ;
1236: END create_pdoi_adls ;
1237: --

Line 1304: IF NOT FND_API.Compatible_API_Call( G_api_version,

1300: l_gms_enabled boolean ;
1301:
1302: BEGIN
1303: -- Standrad call to check API compatibility.
1304: IF NOT FND_API.Compatible_API_Call( G_api_version,
1305: p_api_version,
1306: l_api_name,
1307: G_pkg_name ) THEN
1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1304: IF NOT FND_API.Compatible_API_Call( G_api_version,
1305: p_api_version,
1306: l_api_name,
1307: G_pkg_name ) THEN
1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1309: END IF ;
1310: -- Initialize message list if p_init_msg_list is set to TRUE
1311: --
1312: IF FND_API.to_boolean( p_init_msg_list) THEN

Line 1312: IF FND_API.to_boolean( p_init_msg_list) THEN

1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1309: END IF ;
1310: -- Initialize message list if p_init_msg_list is set to TRUE
1311: --
1312: IF FND_API.to_boolean( p_init_msg_list) THEN
1313: FND_MSG_PUB.initialize ;
1314: END IF ;
1315: -- Initialize API return status to success.
1316: --

Line 1317: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1313: FND_MSG_PUB.initialize ;
1314: END IF ;
1315: -- Initialize API return status to success.
1316: --
1317: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1318: --
1319: -- Determine the validation level
1320: --
1321: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1321: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1317: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1318: --
1319: -- Determine the validation level
1320: --
1321: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1322: -- No validation logic required for this API.
1323: --
1324: NULL ;
1325: END IF ;

Line 1360: WHEN FND_API.G_EXC_ERROR then

1356: l_adl_rec.po_distribution_id:= p_po_distribution_id ;
1357: gms_awards_dist_pkg.create_adls(l_adl_rec) ;
1358:
1359: EXCEPTION
1360: WHEN FND_API.G_EXC_ERROR then
1361: x_return_status := FND_API.G_RET_STS_ERROR ;
1362: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ) ;

Line 1361: x_return_status := FND_API.G_RET_STS_ERROR ;

1357: gms_awards_dist_pkg.create_adls(l_adl_rec) ;
1358:
1359: EXCEPTION
1360: WHEN FND_API.G_EXC_ERROR then
1361: x_return_status := FND_API.G_RET_STS_ERROR ;
1362: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ) ;
1365:

Line 1362: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1358:
1359: EXCEPTION
1360: WHEN FND_API.G_EXC_ERROR then
1361: x_return_status := FND_API.G_RET_STS_ERROR ;
1362: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ) ;
1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1362: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ) ;
1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1368: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1369: p_count => x_msg_count ,
1370: p_data => x_msg_data ) ;

Line 1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ) ;
1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1368: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1369: p_count => x_msg_count ,
1370: p_data => x_msg_data ) ;
1371: WHEN OTHERS THEN

Line 1368: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1364: p_data => x_msg_data ) ;
1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1368: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1369: p_count => x_msg_count ,
1370: p_data => x_msg_data ) ;
1371: WHEN OTHERS THEN
1372:

Line 1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1369: p_count => x_msg_count ,
1370: p_data => x_msg_data ) ;
1371: WHEN OTHERS THEN
1372:
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1374: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1375: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
1376: END IF ;
1377: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

Line 1377: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1374: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1375: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
1376: END IF ;
1377: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1378: p_count => x_msg_count ,
1379: p_data => x_msg_data ) ;
1380: END CREATE_PO_ADL ;
1381:

Line 1480: IF NOT FND_API.Compatible_API_Call( G_api_version,

1476: and adl_line_num = 1 ;
1477:
1478: BEGIN
1479: -- Standrad call to check API compatibility.
1480: IF NOT FND_API.Compatible_API_Call( G_api_version,
1481: p_api_version,
1482: l_api_name,
1483: G_pkg_name ) THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1480: IF NOT FND_API.Compatible_API_Call( G_api_version,
1481: p_api_version,
1482: l_api_name,
1483: G_pkg_name ) THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1485: END IF ;
1486: -- Initialize message list if p_init_msg_list is set to TRUE
1487: --
1488: IF FND_API.to_boolean( p_init_msg_list) THEN

Line 1488: IF FND_API.to_boolean( p_init_msg_list) THEN

1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1485: END IF ;
1486: -- Initialize message list if p_init_msg_list is set to TRUE
1487: --
1488: IF FND_API.to_boolean( p_init_msg_list) THEN
1489: FND_MSG_PUB.initialize ;
1490: END IF ;
1491: -- Initialize API return status to success.
1492: --

Line 1493: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1489: FND_MSG_PUB.initialize ;
1490: END IF ;
1491: -- Initialize API return status to success.
1492: --
1493: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1494: --
1495: -- Determine the validation level
1496: --
1497: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1497: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1493: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1494: --
1495: -- Determine the validation level
1496: --
1497: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1498: -- No validation logic required for this API.
1499: --
1500: NULL ;
1501: END IF ;

Line 1611: WHEN FND_API.G_EXC_ERROR then

1607: END IF ;
1608: x_award_set_id_out := l_award_set_id_out ;
1609:
1610: EXCEPTION
1611: WHEN FND_API.G_EXC_ERROR then
1612: x_return_status := FND_API.G_RET_STS_ERROR ;
1613: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1614: p_count => x_msg_count ,
1615: p_data => x_msg_data ) ;

Line 1612: x_return_status := FND_API.G_RET_STS_ERROR ;

1608: x_award_set_id_out := l_award_set_id_out ;
1609:
1610: EXCEPTION
1611: WHEN FND_API.G_EXC_ERROR then
1612: x_return_status := FND_API.G_RET_STS_ERROR ;
1613: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1614: p_count => x_msg_count ,
1615: p_data => x_msg_data ) ;
1616:

Line 1613: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1609:
1610: EXCEPTION
1611: WHEN FND_API.G_EXC_ERROR then
1612: x_return_status := FND_API.G_RET_STS_ERROR ;
1613: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1614: p_count => x_msg_count ,
1615: p_data => x_msg_data ) ;
1616:
1617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1613: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1614: p_count => x_msg_count ,
1615: p_data => x_msg_data ) ;
1616:
1617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1619: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1620: p_count => x_msg_count ,
1621: p_data => x_msg_data ) ;

Line 1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1614: p_count => x_msg_count ,
1615: p_data => x_msg_data ) ;
1616:
1617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1619: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1620: p_count => x_msg_count ,
1621: p_data => x_msg_data ) ;
1622: WHEN OTHERS THEN

Line 1619: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1615: p_data => x_msg_data ) ;
1616:
1617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1619: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1620: p_count => x_msg_count ,
1621: p_data => x_msg_data ) ;
1622: WHEN OTHERS THEN
1623:

Line 1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1620: p_count => x_msg_count ,
1621: p_data => x_msg_data ) ;
1622: WHEN OTHERS THEN
1623:
1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1625: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1626: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
1627: END IF ;
1628: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

Line 1628: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1625: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1626: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
1627: END IF ;
1628: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1629: p_count => x_msg_count ,
1630: p_data => x_msg_data ) ;
1631: END MAINTAIN_PO_ADL ;
1632:

Line 1668: IF NOT FND_API.Compatible_API_Call( G_api_version,

1664: l_api_name varchar2(50) := 'DELETE_PO_ADL' ;
1665: l_gms_enabled boolean ;
1666: BEGIN
1667: -- Standrad call to check API compatibility.
1668: IF NOT FND_API.Compatible_API_Call( G_api_version,
1669: p_api_version,
1670: l_api_name,
1671: G_pkg_name ) THEN
1672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1668: IF NOT FND_API.Compatible_API_Call( G_api_version,
1669: p_api_version,
1670: l_api_name,
1671: G_pkg_name ) THEN
1672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1673: END IF ;
1674: -- Initialize message list if p_init_msg_list is set to TRUE
1675: --
1676: IF FND_API.to_boolean( p_init_msg_list) THEN

Line 1676: IF FND_API.to_boolean( p_init_msg_list) THEN

1672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1673: END IF ;
1674: -- Initialize message list if p_init_msg_list is set to TRUE
1675: --
1676: IF FND_API.to_boolean( p_init_msg_list) THEN
1677: FND_MSG_PUB.initialize ;
1678: END IF ;
1679: -- Initialize API return status to success.
1680: --

Line 1681: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1677: FND_MSG_PUB.initialize ;
1678: END IF ;
1679: -- Initialize API return status to success.
1680: --
1681: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1682: --
1683: -- Determine the validation level
1684: --
1685: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1685: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1681: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1682: --
1683: -- Determine the validation level
1684: --
1685: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1686: -- No validation logic required for this API.
1687: --
1688: NULL ;
1689: END IF ;

Line 1713: WHEN FND_API.G_EXC_ERROR then

1709: and po_distribution_id = p_po_distribution_id ;
1710: END IF ;
1711:
1712: EXCEPTION
1713: WHEN FND_API.G_EXC_ERROR then
1714: x_return_status := FND_API.G_RET_STS_ERROR ;
1715: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1716: p_count => x_msg_count ,
1717: p_data => x_msg_data ) ;

Line 1714: x_return_status := FND_API.G_RET_STS_ERROR ;

1710: END IF ;
1711:
1712: EXCEPTION
1713: WHEN FND_API.G_EXC_ERROR then
1714: x_return_status := FND_API.G_RET_STS_ERROR ;
1715: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1716: p_count => x_msg_count ,
1717: p_data => x_msg_data ) ;
1718:

Line 1715: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1711:
1712: EXCEPTION
1713: WHEN FND_API.G_EXC_ERROR then
1714: x_return_status := FND_API.G_RET_STS_ERROR ;
1715: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1716: p_count => x_msg_count ,
1717: p_data => x_msg_data ) ;
1718:
1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1715: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1716: p_count => x_msg_count ,
1717: p_data => x_msg_data ) ;
1718:
1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1721: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1722: p_count => x_msg_count ,
1723: p_data => x_msg_data ) ;

Line 1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1716: p_count => x_msg_count ,
1717: p_data => x_msg_data ) ;
1718:
1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1721: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1722: p_count => x_msg_count ,
1723: p_data => x_msg_data ) ;
1724: WHEN OTHERS THEN

Line 1721: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1717: p_data => x_msg_data ) ;
1718:
1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1721: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1722: p_count => x_msg_count ,
1723: p_data => x_msg_data ) ;
1724: WHEN OTHERS THEN
1725:

Line 1726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1722: p_count => x_msg_count ,
1723: p_data => x_msg_data ) ;
1724: WHEN OTHERS THEN
1725:
1726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1727: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1728: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
1729: END IF ;
1730: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

Line 1730: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

1726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1727: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1728: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
1729: END IF ;
1730: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
1731: p_count => x_msg_count ,
1732: p_data => x_msg_data ) ;
1733: END DELETE_PO_ADL ;
1734: