DBA Data[Home] [Help]

APPS.PSB_WS_POSITION_FTE_O_PVT dependencies on FND_API

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

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

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

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

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

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

Line 54: IF NOT FND_API.Compatible_API_Call ( l_api_version,

50: BEGIN
51: --
52: SAVEPOINT Update_Row_Pvt ;
53: --
54: IF NOT FND_API.Compatible_API_Call ( l_api_version,
55: p_api_version,
56: l_api_name,
57: G_PKG_NAME )
58: THEN

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

55: p_api_version,
56: l_api_name,
57: G_PKG_NAME )
58: THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
60: END IF;
61: --
62:
63: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 63: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
60: END IF;
61: --
62:
63: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
64: FND_MSG_PUB.initialize ;
65: END IF;
66: --
67: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 67: p_return_status := FND_API.G_RET_STS_SUCCESS ;

63: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
64: FND_MSG_PUB.initialize ;
65: END IF;
66: --
67: p_return_status := FND_API.G_RET_STS_SUCCESS ;
68: --
69: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
70: l_period_fte(l_init_index) := null;
71: end loop;

Line 91: p_init_msg_list => FND_API.G_FALSE,

87: --
88: PSB_WS_POS_PVT.Create_FTE_Lines
89: (
90: p_api_version => 1.0,
91: p_init_msg_list => FND_API.G_FALSE,
92: p_commit => FND_API.G_FALSE,
93: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
94: --
95: p_return_status => l_return_status,

Line 92: p_commit => FND_API.G_FALSE,

88: PSB_WS_POS_PVT.Create_FTE_Lines
89: (
90: p_api_version => 1.0,
91: p_init_msg_list => FND_API.G_FALSE,
92: p_commit => FND_API.G_FALSE,
93: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
94: --
95: p_return_status => l_return_status,
96: p_msg_count => p_msg_count,

Line 93: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

89: (
90: p_api_version => 1.0,
91: p_init_msg_list => FND_API.G_FALSE,
92: p_commit => FND_API.G_FALSE,
93: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
94: --
95: p_return_status => l_return_status,
96: p_msg_count => p_msg_count,
97: p_msg_data => p_msg_data,

Line 107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

103: p_current_stage_seq => p_current_stage_seq,
104: p_period_fte => l_period_fte
105: );
106:
107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR ;
109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
111: END IF;

Line 108: RAISE FND_API.G_EXC_ERROR ;

104: p_period_fte => l_period_fte
105: );
106:
107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR ;
109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
111: END IF;
112:

Line 109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

105: );
106:
107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR ;
109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
111: END IF;
112:
113:

Line 110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

106:
107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR ;
109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
111: END IF;
112:
113:
114: --

Line 115: IF FND_API.To_Boolean ( p_commit ) THEN

111: END IF;
112:
113:
114: --
115: IF FND_API.To_Boolean ( p_commit ) THEN
116: COMMIT WORK;
117: END iF;
118: --
119: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 124: WHEN FND_API.G_EXC_ERROR THEN

120: p_data => p_msg_data );
121: --
122: EXCEPTION
123: --
124: WHEN FND_API.G_EXC_ERROR THEN
125: --
126: ROLLBACK TO Update_Row_Pvt ;
127: p_return_status := FND_API.G_RET_STS_ERROR;
128: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 127: p_return_status := FND_API.G_RET_STS_ERROR;

123: --
124: WHEN FND_API.G_EXC_ERROR THEN
125: --
126: ROLLBACK TO Update_Row_Pvt ;
127: p_return_status := FND_API.G_RET_STS_ERROR;
128: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
129: p_data => p_msg_data );
130: --
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

127: p_return_status := FND_API.G_RET_STS_ERROR;
128: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
129: p_data => p_msg_data );
130: --
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: --
133: ROLLBACK TO Update_Row_Pvt ;
134: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 134: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

130: --
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: --
133: ROLLBACK TO Update_Row_Pvt ;
134: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
136: p_data => p_msg_data );
137: --
138: WHEN OTHERS THEN

Line 141: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

137: --
138: WHEN OTHERS THEN
139: --
140: ROLLBACK TO Update_Row_Pvt ;
141: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: --
143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
145: l_api_name);