DBA Data[Home] [Help]

APPS.AP_PMT_ACKNOWLEDGE dependencies on FND_API

Line 7: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_PMT_ACKNOWLEDGE';
5:
6: PROCEDURE mark_check_acknowledged
7: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_payment_id IN NUMBER,
9: x_return_status OUT nocopy VARCHAR2,
10: x_msg_count OUT nocopy NUMBER,
11: x_msg_data OUT nocopy VARCHAR2

Line 20: IF FND_API.to_Boolean( p_init_msg_list ) THEN

16: l_debug_info VARCHAR2(2000);
17:
18: BEGIN
19: -- Initialize message list if p_init_msg_list is set to TRUE.
20: IF FND_API.to_Boolean( p_init_msg_list ) THEN
21: FND_MSG_PUB.initialize;
22: END IF;
23:
24: -- Initialize API return status to success

Line 25: x_return_status := FND_API.G_RET_STS_SUCCESS;

21: FND_MSG_PUB.initialize;
22: END IF;
23:
24: -- Initialize API return status to success
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26:
27: UPDATE ap_checks_all
28: SET ACKNOWLEDGED_FLAG = 'Y'
29: WHERE payment_id = p_payment_id;

Line 32: WHEN FND_API.G_EXC_ERROR THEN

28: SET ACKNOWLEDGED_FLAG = 'Y'
29: WHERE payment_id = p_payment_id;
30:
31: EXCEPTION
32: WHEN FND_API.G_EXC_ERROR THEN
33: x_return_status := FND_API.G_RET_STS_ERROR ;
34: FND_MSG_PUB.Count_And_Get
35: ( p_count => x_msg_count,
36: p_data => x_msg_data

Line 33: x_return_status := FND_API.G_RET_STS_ERROR ;

29: WHERE payment_id = p_payment_id;
30:
31: EXCEPTION
32: WHEN FND_API.G_EXC_ERROR THEN
33: x_return_status := FND_API.G_RET_STS_ERROR ;
34: FND_MSG_PUB.Count_And_Get
35: ( p_count => x_msg_count,
36: p_data => x_msg_data
37: );

Line 38: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

34: FND_MSG_PUB.Count_And_Get
35: ( p_count => x_msg_count,
36: p_data => x_msg_data
37: );
38: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
39: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
40: FND_MSG_PUB.Count_And_Get
41: ( p_count => x_msg_count,
42: p_data => x_msg_data

Line 39: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

35: ( p_count => x_msg_count,
36: p_data => x_msg_data
37: );
38: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
39: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
40: FND_MSG_PUB.Count_And_Get
41: ( p_count => x_msg_count,
42: p_data => x_msg_data
43: );

Line 45: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

41: ( p_count => x_msg_count,
42: p_data => x_msg_data
43: );
44: WHEN OTHERS THEN
45: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
46: IF FND_MSG_PUB.Check_Msg_Level
47: (
48: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
49: )