DBA Data[Home] [Help]

APPS.PSB_WS_POSITION_CPC_PVT dependencies on FND_API

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

9:
10: PROCEDURE Calculate_Position_Cost
11: (
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: --
17: p_return_status OUT NOCOPY VARCHAR2,

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

10: PROCEDURE Calculate_Position_Cost
11: (
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: --
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,

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

11: (
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: --
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
19: p_msg_data OUT NOCOPY VARCHAR2,

Line 33: p_init_msg_list => FND_API.G_FALSE,

29: --
30: PSB_WS_POS_PVT.Calculate_Position_Cost
31: (
32: p_api_version => 1.0,
33: p_init_msg_list => FND_API.G_FALSE,
34: p_commit => FND_API.G_FALSE,
35: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
36: --
37: p_return_status => l_return_status,

Line 34: p_commit => FND_API.G_FALSE,

30: PSB_WS_POS_PVT.Calculate_Position_Cost
31: (
32: p_api_version => 1.0,
33: p_init_msg_list => FND_API.G_FALSE,
34: p_commit => FND_API.G_FALSE,
35: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
36: --
37: p_return_status => l_return_status,
38: p_msg_count => p_msg_count,

Line 35: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

31: (
32: p_api_version => 1.0,
33: p_init_msg_list => FND_API.G_FALSE,
34: p_commit => FND_API.G_FALSE,
35: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
36: --
37: p_return_status => l_return_status,
38: p_msg_count => p_msg_count,
39: p_msg_data => p_msg_data,

Line 47: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

43: );
44: --
45: p_return_status := l_return_status;
46:
47: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
48: RAISE FND_API.G_EXC_ERROR ;
49: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
51: END IF;

Line 48: RAISE FND_API.G_EXC_ERROR ;

44: --
45: p_return_status := l_return_status;
46:
47: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
48: RAISE FND_API.G_EXC_ERROR ;
49: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
51: END IF;
52:

Line 49: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

45: p_return_status := l_return_status;
46:
47: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
48: RAISE FND_API.G_EXC_ERROR ;
49: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
51: END IF;
52:
53: EXCEPTION

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

46:
47: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
48: RAISE FND_API.G_EXC_ERROR ;
49: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
51: END IF;
52:
53: EXCEPTION
54: --

Line 55: WHEN FND_API.G_EXC_ERROR THEN

51: END IF;
52:
53: EXCEPTION
54: --
55: WHEN FND_API.G_EXC_ERROR THEN
56: --
57: p_return_status := FND_API.G_RET_STS_ERROR;
58: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
59: p_data => p_msg_data );

Line 57: p_return_status := FND_API.G_RET_STS_ERROR;

53: EXCEPTION
54: --
55: WHEN FND_API.G_EXC_ERROR THEN
56: --
57: p_return_status := FND_API.G_RET_STS_ERROR;
58: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
59: p_data => p_msg_data );
60: --
61: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 61: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

57: p_return_status := FND_API.G_RET_STS_ERROR;
58: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
59: p_data => p_msg_data );
60: --
61: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
62: --
63: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
64: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
65: p_data => p_msg_data );

Line 63: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

59: p_data => p_msg_data );
60: --
61: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
62: --
63: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
64: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
65: p_data => p_msg_data );
66: --
67: WHEN OTHERS THEN

Line 69: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

65: p_data => p_msg_data );
66: --
67: WHEN OTHERS THEN
68: --
69: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70: --
71: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
72: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
73: l_api_name);