DBA Data[Home] [Help]

APPS.ENG_PROPAGATION_LOG_UTIL dependencies on FND_API

Line 15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

11:
12: ---------------------------------------------------------------
13: -- API Return Status . --
14: ---------------------------------------------------------------
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:

Line 17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

13: -- API Return Status . --
14: ---------------------------------------------------------------
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: G_LOG_LEVEL CONSTANT NUMBER := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));
21: G_LOG_MODE VARCHAR2(3);

Line 18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

14: ---------------------------------------------------------------
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: G_LOG_LEVEL CONSTANT NUMBER := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));
21: G_LOG_MODE VARCHAR2(3);
22:

Line 337: , p_delete_map_logs IN VARCHAR2 := FND_API.G_TRUE

333: ----------------------------------------------------------
334:
335: PROCEDURE Perform_Writes_For_Log (
336: p_entity_map_rec IN Entity_Map_Log_Rec_Type
337: , p_delete_map_logs IN VARCHAR2 := FND_API.G_TRUE
338: , x_return_status IN OUT NOCOPY VARCHAR2
339: )
340: IS
341: CURSOR c_change_logs (

Line 351: AND FND_API.G_TRUE = p_delete_map_logs

347: FROM eng_change_logs_b
348: WHERE change_id = cp_change_id
349: AND local_organization_id = cp_local_org_id
350: AND log_type_code <> 'INFO'
351: AND FND_API.G_TRUE = p_delete_map_logs
352: AND change_propagation_map_id = cp_change_map_id;
353:
354: l_new_log_id NUMBER;
355: l_val VARCHAR2(200);

Line 456: , p_delete_map_logs => FND_API.G_TRUE

452: );
453:
454: Perform_Writes_For_Log(
455: p_entity_map_rec => l_entity_map_rec
456: , p_delete_map_logs => FND_API.G_TRUE
457: , x_return_status => l_return_status
458: );
459: Debug_Log(G_LOG_PROCEDURE, 'Write_Propagation_Log.End');
460: EXCEPTION

Line 643: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

639: END Add_Entity_Map;
640:
641: PROCEDURE Mark_Component_Change_Transfer (
642: p_api_version IN NUMBER
643: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
644: , p_commit IN VARCHAR2 := FND_API.G_FALSE
645: , x_return_status OUT NOCOPY VARCHAR2 --
646: , x_msg_count OUT NOCOPY NUMBER --
647: , x_msg_data OUT NOCOPY VARCHAR2 --

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

640:
641: PROCEDURE Mark_Component_Change_Transfer (
642: p_api_version IN NUMBER
643: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
644: , p_commit IN VARCHAR2 := FND_API.G_FALSE
645: , x_return_status OUT NOCOPY VARCHAR2 --
646: , x_msg_count OUT NOCOPY NUMBER --
647: , x_msg_data OUT NOCOPY VARCHAR2 --
648: , p_change_id IN NUMBER

Line 663: IF NOT FND_API.Compatible_API_Call ( l_api_version

659: -- Standard Start of API savepoint
660: SAVEPOINT Mark_Component_Change_Transfer;
661:
662: -- Standard call to check for call compatibility
663: IF NOT FND_API.Compatible_API_Call ( l_api_version
664: ,p_api_version
665: ,l_api_name
666: ,G_PKG_NAME )
667: THEN

Line 668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

664: ,p_api_version
665: ,l_api_name
666: ,G_PKG_NAME )
667: THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:
671: -- Initialize message list if p_init_msg_list is set to TRUE.
672: IF FND_API.to_Boolean( p_init_msg_list )

Line 672: IF FND_API.to_Boolean( p_init_msg_list )

668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:
671: -- Initialize message list if p_init_msg_list is set to TRUE.
672: IF FND_API.to_Boolean( p_init_msg_list )
673: THEN
674: FND_MSG_PUB.initialize;
675: END IF ;
676:

Line 691: IF FND_API.To_Boolean ( p_commit )

687: );
688: Write_Propagation_Log;
689:
690: -- Standard ending code ------------------------------------------------
691: IF FND_API.To_Boolean ( p_commit )
692: THEN
693: COMMIT WORK;
694: END IF;
695: EXCEPTION

Line 698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

694: END IF;
695: EXCEPTION
696: WHEN OTHERS THEN
697: ROLLBACK TO Mark_Component_Change_Transfer;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
699: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
700: THEN
701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
702: END IF;