DBA Data[Home] [Help]

APPS.PSB_WS_POSITION_FTE_I_PVT dependencies on FND_API

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

9:
10: PROCEDURE Insert_Row
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 Insert_Row
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 56: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

57: p_api_version,
58: l_api_name,
59: G_PKG_NAME )
60: THEN
61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
62: END IF;
63:
64: --
65:

Line 66: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

62: END IF;
63:
64: --
65:
66: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
67: FND_MSG_PUB.initialize ;
68: END IF;
69: --
70: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

Line 88: p_return_status := FND_API.G_RET_STS_SUCCESS ;

84: l_period_fte(10) := p_period_10;
85: l_period_fte(11) := p_period_11;
86: l_period_fte(12) := p_period_12;
87:
88: p_return_status := FND_API.G_RET_STS_SUCCESS ;
89:
90: --
91:
92: PSB_WS_POS_PVT.Create_FTE_Lines

Line 95: p_init_msg_list => FND_API.G_FALSE,

91:
92: PSB_WS_POS_PVT.Create_FTE_Lines
93: (
94: p_api_version => 1.0,
95: p_init_msg_list => FND_API.G_FALSE,
96: p_commit => FND_API.G_FALSE,
97: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
98: --
99: p_return_status => l_return_status,

Line 96: p_commit => FND_API.G_FALSE,

92: PSB_WS_POS_PVT.Create_FTE_Lines
93: (
94: p_api_version => 1.0,
95: p_init_msg_list => FND_API.G_FALSE,
96: p_commit => FND_API.G_FALSE,
97: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
98: --
99: p_return_status => l_return_status,
100: p_msg_count => p_msg_count,

Line 97: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

93: (
94: p_api_version => 1.0,
95: p_init_msg_list => FND_API.G_FALSE,
96: p_commit => FND_API.G_FALSE,
97: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
98: --
99: p_return_status => l_return_status,
100: p_msg_count => p_msg_count,
101: p_msg_data => p_msg_data,

Line 103: p_recalculate_flag => FND_API.G_TRUE,

99: p_return_status => l_return_status,
100: p_msg_count => p_msg_count,
101: p_msg_data => p_msg_data,
102: p_fte_line_id => p_fte_line_id,
103: p_recalculate_flag => FND_API.G_TRUE,
104: --
105: p_worksheet_id => p_worksheet_id,
106: p_position_line_id => p_position_line_id,
107: p_budget_year_id => p_budget_year_id,

Line 114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

110: p_current_stage_seq => p_current_stage_seq,
111: p_period_fte => l_period_fte
112: );
113: --
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
115: fnd_message.set_name('PSB', 'WS_CREATE_FTE_FAILED_EXC');
116: RAISE FND_API.G_EXC_ERROR ;
117: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
118: fnd_message.set_name('PSB', 'WS_CREATE_FTE_FAILED_UNEXC');

Line 116: RAISE FND_API.G_EXC_ERROR ;

112: );
113: --
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
115: fnd_message.set_name('PSB', 'WS_CREATE_FTE_FAILED_EXC');
116: RAISE FND_API.G_EXC_ERROR ;
117: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
118: fnd_message.set_name('PSB', 'WS_CREATE_FTE_FAILED_UNEXC');
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
120: END IF;

Line 117: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

113: --
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
115: fnd_message.set_name('PSB', 'WS_CREATE_FTE_FAILED_EXC');
116: RAISE FND_API.G_EXC_ERROR ;
117: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
118: fnd_message.set_name('PSB', 'WS_CREATE_FTE_FAILED_UNEXC');
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
120: END IF;
121:

Line 119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

115: fnd_message.set_name('PSB', 'WS_CREATE_FTE_FAILED_EXC');
116: RAISE FND_API.G_EXC_ERROR ;
117: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
118: fnd_message.set_name('PSB', 'WS_CREATE_FTE_FAILED_UNEXC');
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
120: END IF;
121:
122:
123: --

Line 124: IF FND_API.To_Boolean ( p_commit ) THEN

120: END IF;
121:
122:
123: --
124: IF FND_API.To_Boolean ( p_commit ) THEN
125: COMMIT WORK;
126: END iF;
127: --
128: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 133: WHEN FND_API.G_EXC_ERROR THEN

129: p_data => p_msg_data );
130: --
131: EXCEPTION
132: --
133: WHEN FND_API.G_EXC_ERROR THEN
134: --
135: ROLLBACK TO Insert_Row_Pvt ;
136: p_return_status := FND_API.G_RET_STS_ERROR;
137: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 136: p_return_status := FND_API.G_RET_STS_ERROR;

132: --
133: WHEN FND_API.G_EXC_ERROR THEN
134: --
135: ROLLBACK TO Insert_Row_Pvt ;
136: p_return_status := FND_API.G_RET_STS_ERROR;
137: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
138: p_data => p_msg_data );
139: --
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

136: p_return_status := FND_API.G_RET_STS_ERROR;
137: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
138: p_data => p_msg_data );
139: --
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: --
142: ROLLBACK TO Insert_Row_Pvt ;
143: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 143: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

139: --
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: --
142: ROLLBACK TO Insert_Row_Pvt ;
143: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
145: p_data => p_msg_data );
146: --
147: WHEN OTHERS THEN

Line 150: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

146: --
147: WHEN OTHERS THEN
148: --
149: ROLLBACK TO Insert_Row_Pvt ;
150: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151: --
152: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
153: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
154: l_api_name);