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

Line 18: RAISE FND_API.G_EXC_ERROR;

14: IF (p_token IS NOT NULL) THEN
15: FND_MESSAGE.SET_TOKEN (p_token, p_token_value);
16: END IF;
17: FND_MSG_PUB.ADD;
18: RAISE FND_API.G_EXC_ERROR;
19: END Raise_Error;
20:
21: -- Procedure to Validate Code Info passed in various modes
22: -- to Setup_Code API

Line 25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

21: -- Procedure to Validate Code Info passed in various modes
22: -- to Setup_Code API
23: PROCEDURE Validate_Code
24: (p_mode IN VARCHAR2,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
26: p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type)
27: IS
28: l_code_exists NUMBER;
29: l_eff_end_date DATE;

Line 126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

122: -- Procedure to Validate Code Combination Info passed in various modes
123: -- to Setup_Combination API
124: PROCEDURE Validate_Combination
125: (p_mode IN VARCHAR2,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
127: p_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,
128: x_set_id OUT NOCOPY NUMBER,
129: x_failure_exists OUT NOCOPY NUMBER,
130: x_cause_exists OUT NOCOPY NUMBER,

Line 281: IF (p_combination_rec.effective_end_date = FND_API.G_MISS_DATE) THEN

277: p_combination_rec.cause_code || ' - ' ||
278: p_combination_rec.resolution_code);
279: END IF;
280:
281: IF (p_combination_rec.effective_end_date = FND_API.G_MISS_DATE) THEN
282:
283: IF (l_failure_end_date IS NOT NULL AND
284: TRUNC(SYSDATE) > TRUNC(l_failure_end_date)) THEN
285: Raise_Error ('EAM_FAILURECODE_INACTIVE','FAILURE_CODE',p_combination_rec.failure_code);

Line 332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

328: END Validate_Combination;
329:
330: PROCEDURE Setup_Code
331: (p_api_version IN NUMBER ,
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
333: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
335: p_mode IN VARCHAR2 ,
336: p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type,

Line 333: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

329:
330: PROCEDURE Setup_Code
331: (p_api_version IN NUMBER ,
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
333: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
335: p_mode IN VARCHAR2 ,
336: p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type,
337: x_return_status OUT NOCOPY VARCHAR2 ,

Line 334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

330: PROCEDURE Setup_Code
331: (p_api_version IN NUMBER ,
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
333: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
335: p_mode IN VARCHAR2 ,
336: p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type,
337: x_return_status OUT NOCOPY VARCHAR2 ,
338: x_msg_count OUT NOCOPY NUMBER ,

Line 369: IF NOT FND_API.Compatible_API_Call (l_api_version,

365: -- API savepoint
366: SAVEPOINT Setup_Code_PVT;
367:
368: -- check for call compatibility.
369: IF NOT FND_API.Compatible_API_Call (l_api_version,
370: p_api_version,
371: l_api_name,
372: G_PKG_NAME )
373: THEN

Line 374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

370: p_api_version,
371: l_api_name,
372: G_PKG_NAME )
373: THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END IF;
376:
377: -- Initialize message list if p_init_msg_list is set to TRUE.
378: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 378: IF FND_API.to_Boolean( p_init_msg_list ) THEN

374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END IF;
376:
377: -- Initialize message list if p_init_msg_list is set to TRUE.
378: IF FND_API.to_Boolean( p_init_msg_list ) THEN
379: FND_MSG_PUB.initialize;
380: END IF;
381:
382: -- Initialize API return status to success

Line 383: x_return_status := FND_API.G_RET_STS_SUCCESS;

379: FND_MSG_PUB.initialize;
380: END IF;
381:
382: -- Initialize API return status to success
383: x_return_status := FND_API.G_RET_STS_SUCCESS;
384:
385: -- Validate Failure Code Info passed
386: Validate_Code(p_mode, p_validation_level, p_failurecode_rec);
387:

Line 461: FND_API.G_MISS_CHAR, NULL,

457: OPEN lock_fc;
458: UPDATE eam_failure_codes
459: SET description = decode(p_failurecode_rec.description,
460: NULL,description,
461: FND_API.G_MISS_CHAR, NULL,
462: p_failurecode_rec.description),
463: effective_end_date = decode(
464: p_failurecode_rec.effective_end_date,
465: NULL,effective_end_date,

Line 466: FND_API.G_MISS_DATE,NULL,

462: p_failurecode_rec.description),
463: effective_end_date = decode(
464: p_failurecode_rec.effective_end_date,
465: NULL,effective_end_date,
466: FND_API.G_MISS_DATE,NULL,
467: p_failurecode_rec.effective_end_date)
468: WHERE failure_code = l_code;
469: CLOSE lock_fc;
470: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN

Line 475: FND_API.G_MISS_CHAR, NULL,

471: OPEN lock_cc;
472: UPDATE eam_cause_codes
473: SET description = decode(p_failurecode_rec.description,
474: NULL,description,
475: FND_API.G_MISS_CHAR, NULL,
476: p_failurecode_rec.description),
477: effective_end_date = decode(
478: p_failurecode_rec.effective_end_date,
479: NULL,effective_end_date,

Line 480: FND_API.G_MISS_DATE,NULL,

476: p_failurecode_rec.description),
477: effective_end_date = decode(
478: p_failurecode_rec.effective_end_date,
479: NULL,effective_end_date,
480: FND_API.G_MISS_DATE,NULL,
481: p_failurecode_rec.effective_end_date)
482: WHERE cause_code = l_code;
483: CLOSE lock_cc;
484: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN

Line 489: FND_API.G_MISS_CHAR, NULL,

485: OPEN lock_rc;
486: UPDATE eam_resolution_codes
487: SET description = decode(p_failurecode_rec.description,
488: NULL,description,
489: FND_API.G_MISS_CHAR, NULL,
490: p_failurecode_rec.description),
491: effective_end_date = decode(
492: p_failurecode_rec.effective_end_date,
493: NULL,effective_end_date,

Line 494: FND_API.G_MISS_DATE,NULL,

490: p_failurecode_rec.description),
491: effective_end_date = decode(
492: p_failurecode_rec.effective_end_date,
493: NULL,effective_end_date,
494: FND_API.G_MISS_DATE,NULL,
495: p_failurecode_rec.effective_end_date)
496: WHERE resolution_code = l_code;
497: CLOSE lock_rc;
498: END IF;

Line 516: IF FND_API.To_Boolean( p_commit ) THEN

512:
513: END IF;
514:
515: -- Standard check of p_commit.
516: IF FND_API.To_Boolean( p_commit ) THEN
517: COMMIT WORK;
518: END IF;
519:
520: -- call to get message count and if count is 1, get message info.

Line 526: WHEN FND_API.G_EXC_ERROR THEN

522: (p_count => x_msg_count,
523: p_data => x_msg_data
524: );
525: EXCEPTION
526: WHEN FND_API.G_EXC_ERROR THEN
527: ROLLBACK TO Setup_Code_PVT;
528: x_return_status := FND_API.G_RET_STS_ERROR ;
529: FND_MSG_PUB.Count_And_Get
530: (p_count => x_msg_count ,

Line 528: x_return_status := FND_API.G_RET_STS_ERROR ;

524: );
525: EXCEPTION
526: WHEN FND_API.G_EXC_ERROR THEN
527: ROLLBACK TO Setup_Code_PVT;
528: x_return_status := FND_API.G_RET_STS_ERROR ;
529: FND_MSG_PUB.Count_And_Get
530: (p_count => x_msg_count ,
531: p_data => x_msg_data
532: );

Line 533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

529: FND_MSG_PUB.Count_And_Get
530: (p_count => x_msg_count ,
531: p_data => x_msg_data
532: );
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: ROLLBACK TO Setup_Code_PVT;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
536: FND_MSG_PUB.Count_And_Get
537: (p_count => x_msg_count,

Line 535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

531: p_data => x_msg_data
532: );
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: ROLLBACK TO Setup_Code_PVT;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
536: FND_MSG_PUB.Count_And_Get
537: (p_count => x_msg_count,
538: p_data => x_msg_data
539: );

Line 545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

541: ROLLBACK TO Setup_Code_PVT;
542: Raise_Error ('EAM_ROW_LOCKED',NULL,NULL);
543: WHEN OTHERS THEN
544: ROLLBACK TO Setup_Code_PVT;
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
546: IF FND_MSG_PUB.Check_Msg_Level
547: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg

Line 562: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

558: END Setup_Code;
559:
560: PROCEDURE Setup_Combination
561: (p_api_version IN NUMBER ,
562: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
563: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
564: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
565: p_mode IN VARCHAR2 ,
566: p_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,

Line 563: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

559:
560: PROCEDURE Setup_Combination
561: (p_api_version IN NUMBER ,
562: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
563: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
564: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
565: p_mode IN VARCHAR2 ,
566: p_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,
567: x_return_status OUT NOCOPY VARCHAR2 ,

Line 564: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

560: PROCEDURE Setup_Combination
561: (p_api_version IN NUMBER ,
562: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
563: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
564: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
565: p_mode IN VARCHAR2 ,
566: p_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,
567: x_return_status OUT NOCOPY VARCHAR2 ,
568: x_msg_count OUT NOCOPY NUMBER ,

Line 607: IF NOT FND_API.Compatible_API_Call (l_api_version,

603: -- API savepoint
604: SAVEPOINT Setup_Combination_PVT;
605:
606: -- check for call compatibility.
607: IF NOT FND_API.Compatible_API_Call (l_api_version,
608: p_api_version,
609: l_api_name,
610: G_PKG_NAME )
611: THEN

Line 612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

608: p_api_version,
609: l_api_name,
610: G_PKG_NAME )
611: THEN
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614:
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 616: IF FND_API.to_Boolean( p_init_msg_list ) THEN

612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614:
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list ) THEN
617: FND_MSG_PUB.initialize;
618: END IF;
619:
620: -- Initialize API return status to success

Line 621: x_return_status := FND_API.G_RET_STS_SUCCESS;

617: FND_MSG_PUB.initialize;
618: END IF;
619:
620: -- Initialize API return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: -- Validate Combination Info passed
624: Validate_Combination (p_mode, p_validation_level, p_combination_rec,
625: l_set_id,l_failure_exists, l_cause_exists,

Line 643: l_failure_code_status := FND_API.G_RET_STS_SUCCESS;

639: END IF;
640:
641: IF (p_mode = 'C') THEN
642:
643: l_failure_code_status := FND_API.G_RET_STS_SUCCESS;
644: l_cause_code_status := FND_API.G_RET_STS_SUCCESS;
645: l_resolution_code_status := FND_API.G_RET_STS_SUCCESS;
646:
647: /** Commented since dynamic code creation is not allowed ** Bug#5070342

Line 644: l_cause_code_status := FND_API.G_RET_STS_SUCCESS;

640:
641: IF (p_mode = 'C') THEN
642:
643: l_failure_code_status := FND_API.G_RET_STS_SUCCESS;
644: l_cause_code_status := FND_API.G_RET_STS_SUCCESS;
645: l_resolution_code_status := FND_API.G_RET_STS_SUCCESS;
646:
647: /** Commented since dynamic code creation is not allowed ** Bug#5070342
648: IF (l_failure_exists = 0) THEN

Line 645: l_resolution_code_status := FND_API.G_RET_STS_SUCCESS;

641: IF (p_mode = 'C') THEN
642:
643: l_failure_code_status := FND_API.G_RET_STS_SUCCESS;
644: l_cause_code_status := FND_API.G_RET_STS_SUCCESS;
645: l_resolution_code_status := FND_API.G_RET_STS_SUCCESS;
646:
647: /** Commented since dynamic code creation is not allowed ** Bug#5070342
648: IF (l_failure_exists = 0) THEN
649: -- create failure code

Line 655: p_commit => FND_API.G_FALSE,

651: failure_rec.code := p_combination_rec.failure_code;
652: failure_rec.description:= p_combination_rec.failure_description;
653: Setup_Code (p_api_version => 1.0,
654: p_init_msg_list => p_init_msg_list,
655: p_commit => FND_API.G_FALSE,
656: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
657: p_mode => 'C',
658: p_failurecode_rec => failure_rec,
659: x_return_status => l_failure_code_status,

Line 656: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

652: failure_rec.description:= p_combination_rec.failure_description;
653: Setup_Code (p_api_version => 1.0,
654: p_init_msg_list => p_init_msg_list,
655: p_commit => FND_API.G_FALSE,
656: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
657: p_mode => 'C',
658: p_failurecode_rec => failure_rec,
659: x_return_status => l_failure_code_status,
660: x_msg_count => l_msg_count,

Line 664: l_cause_code_status := FND_API.G_RET_STS_SUCCESS;

660: x_msg_count => l_msg_count,
661: x_msg_data => l_msg_data);
662: END IF;
663:
664: l_cause_code_status := FND_API.G_RET_STS_SUCCESS;
665: IF (l_cause_exists = 0) THEN
666: -- create cause code
667: cause_rec.code_type := EAM_FailureCodes_PUB.G_CAUSE_CODE;
668: cause_rec.code := p_combination_rec.cause_code;

Line 672: p_commit => FND_API.G_FALSE,

668: cause_rec.code := p_combination_rec.cause_code;
669: cause_rec.description:= p_combination_rec.cause_description;
670: Setup_Code (p_api_version => 1.0,
671: p_init_msg_list => p_init_msg_list,
672: p_commit => FND_API.G_FALSE,
673: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
674: p_mode => 'C',
675: p_failurecode_rec => cause_rec,
676: x_return_status => l_cause_code_status,

Line 673: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

669: cause_rec.description:= p_combination_rec.cause_description;
670: Setup_Code (p_api_version => 1.0,
671: p_init_msg_list => p_init_msg_list,
672: p_commit => FND_API.G_FALSE,
673: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
674: p_mode => 'C',
675: p_failurecode_rec => cause_rec,
676: x_return_status => l_cause_code_status,
677: x_msg_count => l_msg_count,

Line 681: l_resolution_code_status := FND_API.G_RET_STS_SUCCESS;

677: x_msg_count => l_msg_count,
678: x_msg_data => l_msg_data);
679: END IF;
680:
681: l_resolution_code_status := FND_API.G_RET_STS_SUCCESS;
682: IF (l_resolution_exists = 0) THEN
683: -- create resolution code
684: resolution_rec.code_type := EAM_FailureCodes_PUB.G_RESOLUTION_CODE;
685: resolution_rec.code := p_combination_rec.resolution_code;

Line 689: p_commit => FND_API.G_FALSE,

685: resolution_rec.code := p_combination_rec.resolution_code;
686: resolution_rec.description:= p_combination_rec.resolution_description;
687: Setup_Code (p_api_version => 1.0,
688: p_init_msg_list => p_init_msg_list,
689: p_commit => FND_API.G_FALSE,
690: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
691: p_mode => 'C',
692: p_failurecode_rec => resolution_rec,
693: x_return_status => l_resolution_code_status,

Line 690: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

686: resolution_rec.description:= p_combination_rec.resolution_description;
687: Setup_Code (p_api_version => 1.0,
688: p_init_msg_list => p_init_msg_list,
689: p_commit => FND_API.G_FALSE,
690: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
691: p_mode => 'C',
692: p_failurecode_rec => resolution_rec,
693: x_return_status => l_resolution_code_status,
694: x_msg_count => l_msg_count,

Line 699: IF (l_failure_code_status = FND_API.G_RET_STS_SUCCESS AND

695: x_msg_data => l_msg_data);
696: END IF;
697: **/
698:
699: IF (l_failure_code_status = FND_API.G_RET_STS_SUCCESS AND
700: l_cause_code_status = FND_API.G_RET_STS_SUCCESS AND
701: l_resolution_code_status = FND_API.G_RET_STS_SUCCESS) THEN
702:
703: -- Insert into eam failure combinations

Line 700: l_cause_code_status = FND_API.G_RET_STS_SUCCESS AND

696: END IF;
697: **/
698:
699: IF (l_failure_code_status = FND_API.G_RET_STS_SUCCESS AND
700: l_cause_code_status = FND_API.G_RET_STS_SUCCESS AND
701: l_resolution_code_status = FND_API.G_RET_STS_SUCCESS) THEN
702:
703: -- Insert into eam failure combinations
704: INSERT INTO eam_failure_combinations

Line 701: l_resolution_code_status = FND_API.G_RET_STS_SUCCESS) THEN

697: **/
698:
699: IF (l_failure_code_status = FND_API.G_RET_STS_SUCCESS AND
700: l_cause_code_status = FND_API.G_RET_STS_SUCCESS AND
701: l_resolution_code_status = FND_API.G_RET_STS_SUCCESS) THEN
702:
703: -- Insert into eam failure combinations
704: INSERT INTO eam_failure_combinations
705: (combination_id ,

Line 740: FND_API.G_MISS_DATE, NULL,

736: UPDATE eam_failure_combinations
737: SET effective_end_date =
738: decode(p_combination_rec.effective_end_date,
739: NULL, effective_end_date,
740: FND_API.G_MISS_DATE, NULL,
741: p_combination_rec.effective_end_date),
742: last_update_date = l_last_update_date,
743: last_updated_by = l_last_updated_by,
744: last_update_login = l_last_update_login

Line 760: IF FND_API.To_Boolean( p_commit ) THEN

756: END IF;
757:
758: x_combination_id := l_combination_id;
759: -- Standard check of p_commit.
760: IF FND_API.To_Boolean( p_commit ) THEN
761: COMMIT WORK;
762: END IF;
763:
764: -- call to get message count and if count is 1, get message info.

Line 770: WHEN FND_API.G_EXC_ERROR THEN

766: (p_count => x_msg_count,
767: p_data => x_msg_data
768: );
769: EXCEPTION
770: WHEN FND_API.G_EXC_ERROR THEN
771: ROLLBACK TO Setup_Combination_PVT;
772: x_return_status := FND_API.G_RET_STS_ERROR ;
773: FND_MSG_PUB.Count_And_Get
774: (p_count => x_msg_count ,

Line 772: x_return_status := FND_API.G_RET_STS_ERROR ;

768: );
769: EXCEPTION
770: WHEN FND_API.G_EXC_ERROR THEN
771: ROLLBACK TO Setup_Combination_PVT;
772: x_return_status := FND_API.G_RET_STS_ERROR ;
773: FND_MSG_PUB.Count_And_Get
774: (p_count => x_msg_count ,
775: p_data => x_msg_data
776: );

Line 777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

773: FND_MSG_PUB.Count_And_Get
774: (p_count => x_msg_count ,
775: p_data => x_msg_data
776: );
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: ROLLBACK TO Setup_Combination_PVT;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780: FND_MSG_PUB.Count_And_Get
781: (p_count => x_msg_count,

Line 779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

775: p_data => x_msg_data
776: );
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: ROLLBACK TO Setup_Combination_PVT;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780: FND_MSG_PUB.Count_And_Get
781: (p_count => x_msg_count,
782: p_data => x_msg_data
783: );

Line 786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

782: p_data => x_msg_data
783: );
784: WHEN OTHERS THEN
785: ROLLBACK TO Setup_Combination_PVT;
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
787: IF FND_MSG_PUB.Check_Msg_Level
788: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
789: THEN
790: FND_MSG_PUB.Add_Exc_Msg

Line 803: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

799: END Setup_Combination;
800:
801: PROCEDURE Copy_FailureSet
802: (p_api_version IN NUMBER ,
803: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
804: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
805: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
806: p_source_set_id IN NUMBER ,
807: p_destination_set_id IN NUMBER ,

Line 804: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

800:
801: PROCEDURE Copy_FailureSet
802: (p_api_version IN NUMBER ,
803: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
804: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
805: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
806: p_source_set_id IN NUMBER ,
807: p_destination_set_id IN NUMBER ,
808: x_return_status OUT NOCOPY VARCHAR2 ,

Line 805: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

801: PROCEDURE Copy_FailureSet
802: (p_api_version IN NUMBER ,
803: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
804: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
805: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
806: p_source_set_id IN NUMBER ,
807: p_destination_set_id IN NUMBER ,
808: x_return_status OUT NOCOPY VARCHAR2 ,
809: x_msg_count OUT NOCOPY NUMBER ,

Line 821: IF NOT FND_API.Compatible_API_Call (l_api_version,

817: -- API savepoint
818: SAVEPOINT Copy_FailureSet_PVT;
819:
820: -- check for call compatibility.
821: IF NOT FND_API.Compatible_API_Call (l_api_version,
822: p_api_version,
823: l_api_name,
824: G_PKG_NAME )
825: THEN

Line 826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

822: p_api_version,
823: l_api_name,
824: G_PKG_NAME )
825: THEN
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828:
829: -- Initialize message list if p_init_msg_list is set to TRUE.
830: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 830: IF FND_API.to_Boolean( p_init_msg_list ) THEN

826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828:
829: -- Initialize message list if p_init_msg_list is set to TRUE.
830: IF FND_API.to_Boolean( p_init_msg_list ) THEN
831: FND_MSG_PUB.initialize;
832: END IF;
833:
834: -- Initialize API return status to success

Line 835: x_return_status := FND_API.G_RET_STS_SUCCESS;

831: FND_MSG_PUB.initialize;
832: END IF;
833:
834: -- Initialize API return status to success
835: x_return_status := FND_API.G_RET_STS_SUCCESS;
836:
837: -- Copy active combinations from source set to destination set
838: INSERT INTO eam_failure_combinations
839: (combination_id ,

Line 873: IF FND_API.To_Boolean( p_commit ) THEN

869: AND efc2.cause_code = efc.cause_code
870: AND efc2.resolution_code = efc2.resolution_code);
871:
872: -- Standard check of p_commit.
873: IF FND_API.To_Boolean( p_commit ) THEN
874: COMMIT WORK;
875: END IF;
876:
877: -- call to get message count and if count is 1, get message info.

Line 884: WHEN FND_API.G_EXC_ERROR THEN

880: p_data => x_msg_data
881: );
882:
883: EXCEPTION
884: WHEN FND_API.G_EXC_ERROR THEN
885: ROLLBACK TO Copy_FailureSet_PVT;
886: x_return_status := FND_API.G_RET_STS_ERROR ;
887: FND_MSG_PUB.Count_And_Get
888: (p_count => x_msg_count ,

Line 886: x_return_status := FND_API.G_RET_STS_ERROR ;

882:
883: EXCEPTION
884: WHEN FND_API.G_EXC_ERROR THEN
885: ROLLBACK TO Copy_FailureSet_PVT;
886: x_return_status := FND_API.G_RET_STS_ERROR ;
887: FND_MSG_PUB.Count_And_Get
888: (p_count => x_msg_count ,
889: p_data => x_msg_data
890: );

Line 891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

887: FND_MSG_PUB.Count_And_Get
888: (p_count => x_msg_count ,
889: p_data => x_msg_data
890: );
891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
892: ROLLBACK TO Copy_FailureSet_PVT;
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
894: FND_MSG_PUB.Count_And_Get
895: (p_count => x_msg_count,

Line 893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

889: p_data => x_msg_data
890: );
891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
892: ROLLBACK TO Copy_FailureSet_PVT;
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
894: FND_MSG_PUB.Count_And_Get
895: (p_count => x_msg_count,
896: p_data => x_msg_data
897: );

Line 900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

896: p_data => x_msg_data
897: );
898: WHEN OTHERS THEN
899: ROLLBACK TO Copy_FailureSet_PVT;
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
901: IF FND_MSG_PUB.Check_Msg_Level
902: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
903: THEN
904: FND_MSG_PUB.Add_Exc_Msg

Line 934: l_failurecode_rec.effective_end_date := FND_API.G_MISS_DATE;

930: l_failurecode_rec.stored_last_upd_date := p_stored_last_upd_date;
931:
932:
933: IF (p_mode = 'U' AND p_effective_end_date IS NULL) THEN
934: l_failurecode_rec.effective_end_date := FND_API.G_MISS_DATE;
935: ELSE
936: l_failurecode_rec.effective_end_date := p_effective_end_date;
937: END IF;
938:

Line 940: l_failurecode_rec.description := FND_API.G_MISS_CHAR;

936: l_failurecode_rec.effective_end_date := p_effective_end_date;
937: END IF;
938:
939: IF (p_mode = 'U' AND p_description IS NULL) THEN
940: l_failurecode_rec.description := FND_API.G_MISS_CHAR;
941: ELSE
942: l_failurecode_rec.description:= p_description;
943: END IF;
944:

Line 947: p_init_msg_list => FND_API.G_TRUE,

943: END IF;
944:
945: Setup_Code
946: (p_api_version => 1.0,
947: p_init_msg_list => FND_API.G_TRUE,
948: p_commit => FND_API.G_FALSE,
949: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
950: p_mode => p_mode,
951: p_failurecode_rec => l_failurecode_rec,

Line 948: p_commit => FND_API.G_FALSE,

944:
945: Setup_Code
946: (p_api_version => 1.0,
947: p_init_msg_list => FND_API.G_TRUE,
948: p_commit => FND_API.G_FALSE,
949: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
950: p_mode => p_mode,
951: p_failurecode_rec => l_failurecode_rec,
952: x_return_status => x_return_status,

Line 949: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

945: Setup_Code
946: (p_api_version => 1.0,
947: p_init_msg_list => FND_API.G_TRUE,
948: p_commit => FND_API.G_FALSE,
949: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
950: p_mode => p_mode,
951: p_failurecode_rec => l_failurecode_rec,
952: x_return_status => x_return_status,
953: x_msg_count => x_msg_count,

Line 1000: l_combination_rec.effective_end_date := FND_API.G_MISS_DATE;

996: l_combination_rec.last_updated_by := p_last_updated_by;
997: l_combination_rec.last_update_login := p_last_update_login;
998:
999: IF (p_mode = 'U' AND p_effective_end_date IS NULL) THEN
1000: l_combination_rec.effective_end_date := FND_API.G_MISS_DATE;
1001: ELSE
1002: l_combination_rec.effective_end_date := p_effective_end_date;
1003: END IF;
1004:

Line 1007: p_init_msg_list => FND_API.G_TRUE ,

1003: END IF;
1004:
1005: Setup_Combination
1006: (p_api_version => 1.0 ,
1007: p_init_msg_list => FND_API.G_TRUE ,
1008: p_commit => FND_API.G_FALSE ,
1009: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1010: p_mode => p_mode ,
1011: p_combination_rec => l_combination_rec ,

Line 1008: p_commit => FND_API.G_FALSE ,

1004:
1005: Setup_Combination
1006: (p_api_version => 1.0 ,
1007: p_init_msg_list => FND_API.G_TRUE ,
1008: p_commit => FND_API.G_FALSE ,
1009: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1010: p_mode => p_mode ,
1011: p_combination_rec => l_combination_rec ,
1012: x_return_status => x_return_status ,

Line 1009: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1005: Setup_Combination
1006: (p_api_version => 1.0 ,
1007: p_init_msg_list => FND_API.G_TRUE ,
1008: p_commit => FND_API.G_FALSE ,
1009: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1010: p_mode => p_mode ,
1011: p_combination_rec => l_combination_rec ,
1012: x_return_status => x_return_status ,
1013: x_msg_count => x_msg_count ,

Line 1054: x_return_status := FND_API.G_RET_STS_SUCCESS;

1050: BEGIN
1051: FND_MSG_PUB.initialize;
1052:
1053: -- Initialize API return status to success
1054: x_return_status := FND_API.G_RET_STS_SUCCESS;
1055: BEGIN
1056: IF (p_code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
1057: OPEN lock_fc;
1058: FETCH lock_fc

Line 1078: RAISE FND_API.G_EXC_ERROR;

1074: END IF;
1075: IF (p_last_update_date <> l_last_update_date) THEN
1076: FND_MESSAGE.SET_NAME ('FND', 'FND_RECORD_CHANGED_ERROR');
1077: FND_MSG_PUB.ADD;
1078: RAISE FND_API.G_EXC_ERROR;
1079: END IF;
1080: IF (l_rowcount = 0) THEN
1081: FND_MESSAGE.SET_NAME ('FND', 'FND_RECORD_DELETED_ERROR');
1082: FND_MSG_PUB.ADD;

Line 1083: RAISE FND_API.G_EXC_ERROR;

1079: END IF;
1080: IF (l_rowcount = 0) THEN
1081: FND_MESSAGE.SET_NAME ('FND', 'FND_RECORD_DELETED_ERROR');
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;
1085: EXCEPTION
1086: WHEN G_LOCKROW_EXCEPTION THEN
1087: FND_MESSAGE.SET_NAME ('FND', 'FND_LOCK_RECORD_ERROR');

Line 1089: RAISE FND_API.G_EXC_ERROR;

1085: EXCEPTION
1086: WHEN G_LOCKROW_EXCEPTION THEN
1087: FND_MESSAGE.SET_NAME ('FND', 'FND_LOCK_RECORD_ERROR');
1088: FND_MSG_PUB.ADD;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END;
1091: EXCEPTION
1092: WHEN FND_API.G_EXC_ERROR THEN
1093: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1092: WHEN FND_API.G_EXC_ERROR THEN

1088: FND_MSG_PUB.ADD;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END;
1091: EXCEPTION
1092: WHEN FND_API.G_EXC_ERROR THEN
1093: x_return_status := FND_API.G_RET_STS_ERROR ;
1094: WHEN OTHERS THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096: IF FND_MSG_PUB.Check_Msg_Level

Line 1093: x_return_status := FND_API.G_RET_STS_ERROR ;

1089: RAISE FND_API.G_EXC_ERROR;
1090: END;
1091: EXCEPTION
1092: WHEN FND_API.G_EXC_ERROR THEN
1093: x_return_status := FND_API.G_RET_STS_ERROR ;
1094: WHEN OTHERS THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096: IF FND_MSG_PUB.Check_Msg_Level
1097: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1091: EXCEPTION
1092: WHEN FND_API.G_EXC_ERROR THEN
1093: x_return_status := FND_API.G_RET_STS_ERROR ;
1094: WHEN OTHERS THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096: IF FND_MSG_PUB.Check_Msg_Level
1097: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1098: THEN
1099: FND_MSG_PUB.Add_Exc_Msg

Line 1127: x_return_status := FND_API.G_RET_STS_SUCCESS;

1123: BEGIN
1124: FND_MSG_PUB.initialize;
1125:
1126: -- Initialize API return status to success
1127: x_return_status := FND_API.G_RET_STS_SUCCESS;
1128: BEGIN
1129: OPEN lock_combination;
1130: FETCH lock_combination
1131: INTO l_end_date, l_last_update_date;

Line 1137: RAISE FND_API.G_EXC_ERROR;

1133: CLOSE lock_combination;
1134: IF (p_last_update_date <> l_last_update_date) THEN
1135: FND_MESSAGE.SET_NAME ('FND', 'FND_RECORD_CHANGED_ERROR');
1136: FND_MSG_PUB.ADD;
1137: RAISE FND_API.G_EXC_ERROR;
1138: END IF;
1139: IF (l_rowcount = 0) THEN
1140: FND_MESSAGE.SET_NAME ('FND', 'FND_RECORD_DELETED_ERROR');
1141: FND_MSG_PUB.ADD;

Line 1142: RAISE FND_API.G_EXC_ERROR;

1138: END IF;
1139: IF (l_rowcount = 0) THEN
1140: FND_MESSAGE.SET_NAME ('FND', 'FND_RECORD_DELETED_ERROR');
1141: FND_MSG_PUB.ADD;
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144: EXCEPTION
1145: WHEN G_LOCKROW_EXCEPTION THEN
1146: FND_MESSAGE.SET_NAME ('FND', 'FND_LOCK_RECORD_ERROR');

Line 1148: RAISE FND_API.G_EXC_ERROR;

1144: EXCEPTION
1145: WHEN G_LOCKROW_EXCEPTION THEN
1146: FND_MESSAGE.SET_NAME ('FND', 'FND_LOCK_RECORD_ERROR');
1147: FND_MSG_PUB.ADD;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END;
1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1151: WHEN FND_API.G_EXC_ERROR THEN

1147: FND_MSG_PUB.ADD;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END;
1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR ;
1153: WHEN OTHERS THEN
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1155: IF FND_MSG_PUB.Check_Msg_Level

Line 1152: x_return_status := FND_API.G_RET_STS_ERROR ;

1148: RAISE FND_API.G_EXC_ERROR;
1149: END;
1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR ;
1153: WHEN OTHERS THEN
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1155: IF FND_MSG_PUB.Check_Msg_Level
1156: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR ;
1153: WHEN OTHERS THEN
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1155: IF FND_MSG_PUB.Check_Msg_Level
1156: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1157: THEN
1158: FND_MSG_PUB.Add_Exc_Msg