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,
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,
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,
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,
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,
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,
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;
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:
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
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: --
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 );
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
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 );
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
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);