DBA Data[Home] [Help]

APPS.PSB_WS_LINE_YEAR_I_PVT dependencies on FND_API

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

14:
15: PROCEDURE Insert_Row
16: (
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_return_status OUT NOCOPY VARCHAR2,
22: p_msg_count OUT NOCOPY NUMBER,

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

15: PROCEDURE Insert_Row
16: (
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_return_status OUT NOCOPY VARCHAR2,
22: p_msg_count OUT NOCOPY NUMBER,
23: p_msg_data OUT NOCOPY VARCHAR2,

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

16: (
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_return_status OUT NOCOPY VARCHAR2,
22: p_msg_count OUT NOCOPY NUMBER,
23: p_msg_data OUT NOCOPY VARCHAR2,
24: --

Line 96: IF NOT FND_API.Compatible_API_Call ( l_api_version,

92: BEGIN
93: --
94: SAVEPOINT Insert_Row_Pvt ;
95: --
96: IF NOT FND_API.Compatible_API_Call ( l_api_version,
97: p_api_version,
98: l_api_name,
99: G_PKG_NAME )
100: THEN

Line 101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

97: p_api_version,
98: l_api_name,
99: G_PKG_NAME )
100: THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
102: END IF;
103:
104: --
105:

Line 106: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

102: END IF;
103:
104: --
105:
106: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
107: FND_MSG_PUB.initialize ;
108: END IF;
109: --
110: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 110: p_return_status := FND_API.G_RET_STS_SUCCESS ;

106: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
107: FND_MSG_PUB.initialize ;
108: END IF;
109: --
110: p_return_status := FND_API.G_RET_STS_SUCCESS ;
111:
112:
113:
114: -- Initialize the table

Line 197: p_init_msg_list => FND_API.G_FALSE,

193:
194: PSB_WS_ACCT_PVT.Create_Account_Dist
195: (
196: p_api_version => 1.0,
197: p_init_msg_list => FND_API.G_FALSE,
198: p_commit => FND_API.G_FALSE,
199: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
200: p_return_status => l_return_status,
201: p_msg_count => p_msg_count,

Line 198: p_commit => FND_API.G_FALSE,

194: PSB_WS_ACCT_PVT.Create_Account_Dist
195: (
196: p_api_version => 1.0,
197: p_init_msg_list => FND_API.G_FALSE,
198: p_commit => FND_API.G_FALSE,
199: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
200: p_return_status => l_return_status,
201: p_msg_count => p_msg_count,
202: p_msg_data => p_msg_data,

Line 199: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

195: (
196: p_api_version => 1.0,
197: p_init_msg_list => FND_API.G_FALSE,
198: p_commit => FND_API.G_FALSE,
199: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
200: p_return_status => l_return_status,
201: p_msg_count => p_msg_count,
202: p_msg_data => p_msg_data,
203: --

Line 214: p_distribute_flag => FND_API.G_TRUE,

210: p_concatenated_segments => p_concatenated_segments,
211: p_currency_code => p_currency_code,
212: p_balance_type => 'E', -- Always Estimate
213: p_ytd_amount => l_ytd_amount,
214: p_distribute_flag => FND_API.G_TRUE,
215: p_period_amount => l_period_amount,
216: p_service_package_id => p_service_package_id
217: );
218:

Line 244: p_init_msg_list => FND_API.G_FALSE,

240: ELSE
241: PSB_WS_ACCT_PVT.Create_Account_Dist
242: (
243: p_api_version => 1.0,
244: p_init_msg_list => FND_API.G_FALSE,
245: p_commit => FND_API.G_FALSE,
246: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
247: p_return_status => l_return_status,
248: p_msg_count => p_msg_count,

Line 245: p_commit => FND_API.G_FALSE,

241: PSB_WS_ACCT_PVT.Create_Account_Dist
242: (
243: p_api_version => 1.0,
244: p_init_msg_list => FND_API.G_FALSE,
245: p_commit => FND_API.G_FALSE,
246: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
247: p_return_status => l_return_status,
248: p_msg_count => p_msg_count,
249: p_msg_data => p_msg_data,

Line 246: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

242: (
243: p_api_version => 1.0,
244: p_init_msg_list => FND_API.G_FALSE,
245: p_commit => FND_API.G_FALSE,
246: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
247: p_return_status => l_return_status,
248: p_msg_count => p_msg_count,
249: p_msg_data => p_msg_data,
250: --

Line 261: p_distribute_flag => FND_API.G_TRUE,

257: p_concatenated_segments => p_concatenated_segments,
258: p_currency_code => p_currency_code,
259: p_balance_type => 'E', -- Always Estimate
260: p_ytd_amount => l_ytd_amount,
261: p_distribute_flag => FND_API.G_TRUE,
262: p_period_amount => l_period_amount,
263: p_position_line_id => p_position_line_id,
264: p_element_set_id => p_element_set_id,
265: p_salary_account_line => p_salary_account_line,

Line 270: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

266: p_service_package_id => p_service_package_id
267: );
268: END IF;
269: --
270: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
271: fnd_message.set_name('PSB', 'WS_CREATE_DIST_FAILED_EXC');
272: RAISE FND_API.G_EXC_ERROR ;
273: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
274: fnd_message.set_name('PSB', 'WS_CREATE_DIST_FAILED_UNEXC');

Line 272: RAISE FND_API.G_EXC_ERROR ;

268: END IF;
269: --
270: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
271: fnd_message.set_name('PSB', 'WS_CREATE_DIST_FAILED_EXC');
272: RAISE FND_API.G_EXC_ERROR ;
273: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
274: fnd_message.set_name('PSB', 'WS_CREATE_DIST_FAILED_UNEXC');
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
276: END IF;

Line 273: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

269: --
270: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
271: fnd_message.set_name('PSB', 'WS_CREATE_DIST_FAILED_EXC');
272: RAISE FND_API.G_EXC_ERROR ;
273: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
274: fnd_message.set_name('PSB', 'WS_CREATE_DIST_FAILED_UNEXC');
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
276: END IF;
277:

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

271: fnd_message.set_name('PSB', 'WS_CREATE_DIST_FAILED_EXC');
272: RAISE FND_API.G_EXC_ERROR ;
273: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
274: fnd_message.set_name('PSB', 'WS_CREATE_DIST_FAILED_UNEXC');
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
276: END IF;
277:
278:
279: END IF;

Line 285: IF FND_API.To_Boolean ( p_commit ) THEN

281:
282:
283: END LOOP;
284: --
285: IF FND_API.To_Boolean ( p_commit ) THEN
286: COMMIT WORK;
287: END iF;
288: --
289: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 294: WHEN FND_API.G_EXC_ERROR THEN

290: p_data => p_msg_data );
291: --
292: EXCEPTION
293: --
294: WHEN FND_API.G_EXC_ERROR THEN
295: --
296: ROLLBACK TO Insert_Row_Pvt ;
297: p_return_status := FND_API.G_RET_STS_ERROR;
298: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 297: p_return_status := FND_API.G_RET_STS_ERROR;

293: --
294: WHEN FND_API.G_EXC_ERROR THEN
295: --
296: ROLLBACK TO Insert_Row_Pvt ;
297: p_return_status := FND_API.G_RET_STS_ERROR;
298: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
299: p_data => p_msg_data );
300: --
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

297: p_return_status := FND_API.G_RET_STS_ERROR;
298: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
299: p_data => p_msg_data );
300: --
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: --
303: ROLLBACK TO Insert_Row_Pvt ;
304: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 304: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

300: --
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: --
303: ROLLBACK TO Insert_Row_Pvt ;
304: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
306: p_data => p_msg_data );
307: --
308: WHEN OTHERS THEN

Line 311: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

307: --
308: WHEN OTHERS THEN
309: --
310: ROLLBACK TO Insert_Row_Pvt ;
311: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: --
313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
314: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
315: l_api_name);