DBA Data[Home] [Help]

APPS.EAM_PROCESS_FAILURE_ENTRY_PVT dependencies on FND_API

Line 529: -- Default = FND_API.G_FALSE

525: -- Pre-reqs : None.
526: -- Parameters :
527: -- IN : p_api_version IN NUMBER Required
528: -- p_init_msg_list IN VARCHAR2 Optional
529: -- Default = FND_API.G_FALSE
530: -- p_commit IN VARCHAR2 Optional
531: -- Default = FND_API.G_FALSE
532: -- p_eam_failure_entry_record IN
533: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

Line 531: -- Default = FND_API.G_FALSE

527: -- IN : p_api_version IN NUMBER Required
528: -- p_init_msg_list IN VARCHAR2 Optional
529: -- Default = FND_API.G_FALSE
530: -- p_commit IN VARCHAR2 Optional
531: -- Default = FND_API.G_FALSE
532: -- p_eam_failure_entry_record IN
533: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
534: -- p_eam_failure_codes_tbl IN
535: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

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

546: ***************************************************************************/
547:
548: PROCEDURE Process_Failure_Entry
549: ( p_api_version IN NUMBER := 1.0
550: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
551: , p_commit IN VARCHAR2 := FND_API.G_FALSE
552: , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
553: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
554: , x_return_status OUT NOCOPY VARCHAR2

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

547:
548: PROCEDURE Process_Failure_Entry
549: ( p_api_version IN NUMBER := 1.0
550: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
551: , p_commit IN VARCHAR2 := FND_API.G_FALSE
552: , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
553: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
554: , x_return_status OUT NOCOPY VARCHAR2
555: , x_msg_count OUT NOCOPY NUMBER

Line 598: IF NOT FND_API.Compatible_API_Call (l_api_version,

594: -- API savepoint
595: SAVEPOINT Process_Failure_Entry_PVT;
596:
597: -- check for call compatibility.
598: IF NOT FND_API.Compatible_API_Call (l_api_version,
599: p_api_version,
600: l_api_name,
601: G_PKG_NAME )
602: THEN

Line 603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

599: p_api_version,
600: l_api_name,
601: G_PKG_NAME )
602: THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
607: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 607: IF FND_API.to_Boolean( p_init_msg_list ) THEN

603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
607: IF FND_API.to_Boolean( p_init_msg_list ) THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610:
611: -- Initialize API return status to success

Line 612: x_return_status := FND_API.G_RET_STS_SUCCESS;

608: FND_MSG_PUB.initialize;
609: END IF;
610:
611: -- Initialize API return status to success
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613: l_token_name := NULL;
614: l_token_value := NULL;
615:
616: l_eam_failure_entry_record := p_eam_failure_entry_record;

Line 644: RAISE FND_API.G_EXC_ERROR;

640: , value => l_token_value
641: );
642: END IF;
643: FND_MSG_PUB.Add;
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;
646:
647: ELSE
648: /* dbms_output.put_line('After Validate_failure_entry_record1'); */

Line 654: RAISE FND_API.G_EXC_ERROR;

650: --1: Failure Information Entry
651: --2: Failure Information Update
652: FND_MESSAGE.SET_NAME ('EAM', 'EAM_FA_INVALID_TXN_TYPE');
653: FND_MSG_PUB.Add;
654: RAISE FND_API.G_EXC_ERROR;
655: /* dbms_output.put_line('After Validate_failure_entry_record2'); */
656:
657: END IF;
658:

Line 756: RAISE FND_API.G_EXC_ERROR;

752: , value => l_token_value
753: );
754: END IF;
755: FND_MSG_PUB.Add;
756: RAISE FND_API.G_EXC_ERROR;
757: END IF;
758:
759: FOR i IN 1..l_eam_failure_codes_tbl.count
760: LOOP

Line 870: WHEN FND_API.G_EXC_ERROR THEN

866: x_eam_failure_entry_record := l_eam_failure_entry_record;
867: x_eam_failure_codes_tbl := l_eam_failure_codes_tbl;
868:
869: EXCEPTION
870: WHEN FND_API.G_EXC_ERROR THEN
871: ROLLBACK TO Process_Failure_Entry_PVT;
872: x_return_status := FND_API.G_RET_STS_ERROR ;
873: /* FND_MSG_PUB.Count_And_Get
874: (

Line 872: x_return_status := FND_API.G_RET_STS_ERROR ;

868:
869: EXCEPTION
870: WHEN FND_API.G_EXC_ERROR THEN
871: ROLLBACK TO Process_Failure_Entry_PVT;
872: x_return_status := FND_API.G_RET_STS_ERROR ;
873: /* FND_MSG_PUB.Count_And_Get
874: (
875: p_count => x_msg_count ,
876: p_data => x_msg_data

Line 878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

874: (
875: p_count => x_msg_count ,
876: p_data => x_msg_data
877: ); */
878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
879: ROLLBACK TO Process_Failure_Entry_PVT;
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
881: /* FND_MSG_PUB.Count_And_Get
882: (

Line 880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

876: p_data => x_msg_data
877: ); */
878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
879: ROLLBACK TO Process_Failure_Entry_PVT;
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
881: /* FND_MSG_PUB.Count_And_Get
882: (
883: p_count => x_msg_count,
884: p_data => x_msg_data

Line 888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

884: p_data => x_msg_data
885: ); */
886: WHEN OTHERS THEN
887: ROLLBACK TO Process_Failure_Entry_PVT;
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
889: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
890: THEN
891: FND_MSG_PUB.Add_Exc_Msg
892: (

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

903: END process_failure_entry;
904:
905: PROCEDURE Delete_Failure_Entry
906: ( p_api_version IN NUMBER := 1.0
907: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
908: , p_commit IN VARCHAR2 := FND_API.G_FALSE
909: , p_source_id IN NUMBER
910: , x_return_status OUT NOCOPY VARCHAR2
911: , x_msg_count OUT NOCOPY NUMBER

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

904:
905: PROCEDURE Delete_Failure_Entry
906: ( p_api_version IN NUMBER := 1.0
907: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
908: , p_commit IN VARCHAR2 := FND_API.G_FALSE
909: , p_source_id IN NUMBER
910: , x_return_status OUT NOCOPY VARCHAR2
911: , x_msg_count OUT NOCOPY NUMBER
912: , x_msg_data OUT NOCOPY VARCHAR2

Line 925: IF NOT FND_API.Compatible_API_Call (l_api_version,

921: -- API savepoint
922: SAVEPOINT Delete_Failure_Entry_pvt;
923:
924: -- check for call compatibility.
925: IF NOT FND_API.Compatible_API_Call (l_api_version,
926: p_api_version,
927: l_api_name,
928: G_PKG_NAME )
929: THEN

Line 930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

926: p_api_version,
927: l_api_name,
928: G_PKG_NAME )
929: THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932:
933: -- Initialize message list if p_init_msg_list is set to TRUE.
934: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 934: IF FND_API.to_Boolean( p_init_msg_list ) THEN

930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932:
933: -- Initialize message list if p_init_msg_list is set to TRUE.
934: IF FND_API.to_Boolean( p_init_msg_list ) THEN
935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: -- Initialize API return status to success

Line 939: x_return_status := FND_API.G_RET_STS_SUCCESS;

935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: -- Initialize API return status to success
939: x_return_status := FND_API.G_RET_STS_SUCCESS;
940:
941: SELECT COUNT(1) INTO l_count FROM eam_asset_failures WHERE source_id = p_source_id;
942:
943: IF l_count >=1 THEN

Line 958: IF(p_commit = FND_API.G_TRUE) THEN

954: ELSE
955: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Failure information doesn''t exist') ; END IF;
956: END IF;
957:
958: IF(p_commit = FND_API.G_TRUE) THEN
959: COMMIT;
960: END IF;
961:
962: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 962: x_return_status := FND_API.G_RET_STS_SUCCESS;

958: IF(p_commit = FND_API.G_TRUE) THEN
959: COMMIT;
960: END IF;
961:
962: x_return_status := FND_API.G_RET_STS_SUCCESS;
963:
964: EXCEPTION
965: WHEN OTHERS THEN
966: ROLLBACK TO Delete_Failure_Entry_pvt;

Line 968: x_return_status := FND_API.G_RET_STS_ERROR;

964: EXCEPTION
965: WHEN OTHERS THEN
966: ROLLBACK TO Delete_Failure_Entry_pvt;
967: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Error in deleting the existing failure data:'||SQLERRM) ; END IF;
968: x_return_status := FND_API.G_RET_STS_ERROR;
969:
970: END Delete_Failure_Entry;
971:
972: