DBA Data[Home] [Help]

APPS.CN_PMTPLAN_PUB dependencies on FND_API

Line 50: x_return_status := FND_API.G_RET_STS_SUCCESS;

46:
47: BEGIN
48:
49: -- Initialize API return status to success
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51: x_loading_status := p_loading_status;
52: x_status := p_loading_status ;
53:
54:

Line 91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

87: END IF;
88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: x_loading_status := 'UNEXPECTED_ERR';
93: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
94: THEN
95: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );

Line 182: p_encoded => FND_API.G_FALSE

178: FND_MSG_PUB.Count_And_Get
179: (
180: p_count => x_msg_count,
181: p_data => x_msg_data,
182: p_encoded => FND_API.G_FALSE
183: );
184:
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN

Line 186: WHEN FND_API.G_EXC_ERROR THEN

182: p_encoded => FND_API.G_FALSE
183: );
184:
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_ERROR ;
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 187: x_return_status := FND_API.G_RET_STS_ERROR ;

183: );
184:
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_ERROR ;
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
191: x_loading_status := 'UNEXPECTED_ERR';

Line 189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_ERROR ;
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
191: x_loading_status := 'UNEXPECTED_ERR';
192:
193: WHEN OTHERS THEN

Line 190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_ERROR ;
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
191: x_loading_status := 'UNEXPECTED_ERR';
192:
193: WHEN OTHERS THEN
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
191: x_loading_status := 'UNEXPECTED_ERR';
192:
193: WHEN OTHERS THEN
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: x_loading_status := 'UNEXPECTED_ERR';
196: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
197: THEN
198: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );

Line 254: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

250: BEGIN
251: -- Standard Start of API savepoint
252: SAVEPOINT Update_PmtPlan;
253: -- Standard call to check for call compatibility.
254: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
255: p_api_version ,
256: l_api_name ,
257: L_PKG_NAME )
258: THEN

Line 259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

255: p_api_version ,
256: l_api_name ,
257: L_PKG_NAME )
258: THEN
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: END IF;
261: -- Initialize message list if p_init_msg_list is set to TRUE.
262: IF FND_API.to_Boolean( p_init_msg_list ) THEN
263: FND_MSG_PUB.initialize;

Line 262: IF FND_API.to_Boolean( p_init_msg_list ) THEN

258: THEN
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: END IF;
261: -- Initialize message list if p_init_msg_list is set to TRUE.
262: IF FND_API.to_Boolean( p_init_msg_list ) THEN
263: FND_MSG_PUB.initialize;
264: END IF;
265: -- Initialize API return status to success
266: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 266: x_return_status := FND_API.G_RET_STS_SUCCESS;

262: IF FND_API.to_Boolean( p_init_msg_list ) THEN
263: FND_MSG_PUB.initialize;
264: END IF;
265: -- Initialize API return status to success
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267: x_loading_status := 'CN_UPDATED';
268: -- API body
269:
270: --Initialize g_mode

Line 332: RAISE FND_API.G_EXC_ERROR ;

328: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
329: FND_MSG_PUB.Add;
330: END IF;
331:
332: RAISE FND_API.G_EXC_ERROR ;
333: end if;
334: l_update_rec.name := p_PmtPlan_rec.name;
335: l_update_rec.minimum_amount := p_PmtPlan_rec.minimum_amount;
336: l_update_rec.maximum_amount := p_PmtPlan_rec.maximum_amount;

Line 377: IF FND_API.To_Boolean( p_commit ) THEN

373: );
374:
375: -- End of API body.
376: -- Standard check of p_commit.
377: IF FND_API.To_Boolean( p_commit ) THEN
378: COMMIT WORK;
379: END IF;
380: -- Standard call to get message count and if count is 1, get message info.
381: FND_MSG_PUB.Count_And_Get

Line 385: p_encoded => FND_API.G_FALSE

381: FND_MSG_PUB.Count_And_Get
382: (
383: p_count => x_msg_count ,
384: p_data => x_msg_data ,
385: p_encoded => FND_API.G_FALSE
386: );
387: EXCEPTION
388: WHEN FND_API.G_EXC_ERROR THEN
389: ROLLBACK TO Update_PmtPlan;

Line 388: WHEN FND_API.G_EXC_ERROR THEN

384: p_data => x_msg_data ,
385: p_encoded => FND_API.G_FALSE
386: );
387: EXCEPTION
388: WHEN FND_API.G_EXC_ERROR THEN
389: ROLLBACK TO Update_PmtPlan;
390: x_return_status := FND_API.G_RET_STS_ERROR ;
391: FND_MSG_PUB.Count_And_Get
392: (

Line 390: x_return_status := FND_API.G_RET_STS_ERROR ;

386: );
387: EXCEPTION
388: WHEN FND_API.G_EXC_ERROR THEN
389: ROLLBACK TO Update_PmtPlan;
390: x_return_status := FND_API.G_RET_STS_ERROR ;
391: FND_MSG_PUB.Count_And_Get
392: (
393: p_count => x_msg_count ,
394: p_data => x_msg_data ,

Line 395: p_encoded => FND_API.G_FALSE

391: FND_MSG_PUB.Count_And_Get
392: (
393: p_count => x_msg_count ,
394: p_data => x_msg_data ,
395: p_encoded => FND_API.G_FALSE
396: );
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: ROLLBACK TO Update_PmtPlan;
399: x_loading_status := 'UNEXPECTED_ERR';

Line 397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

393: p_count => x_msg_count ,
394: p_data => x_msg_data ,
395: p_encoded => FND_API.G_FALSE
396: );
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: ROLLBACK TO Update_PmtPlan;
399: x_loading_status := 'UNEXPECTED_ERR';
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401: FND_MSG_PUB.Count_And_Get

Line 400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

396: );
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: ROLLBACK TO Update_PmtPlan;
399: x_loading_status := 'UNEXPECTED_ERR';
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401: FND_MSG_PUB.Count_And_Get
402: (
403: p_count => x_msg_count ,
404: p_data => x_msg_data ,

Line 405: p_encoded => FND_API.G_FALSE

401: FND_MSG_PUB.Count_And_Get
402: (
403: p_count => x_msg_count ,
404: p_data => x_msg_data ,
405: p_encoded => FND_API.G_FALSE
406: );
407: WHEN OTHERS THEN
408: ROLLBACK TO Update_PmtPlan;
409: x_loading_status := 'UNEXPECTED_ERR';

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

406: );
407: WHEN OTHERS THEN
408: ROLLBACK TO Update_PmtPlan;
409: x_loading_status := 'UNEXPECTED_ERR';
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
412: THEN
413: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
414: END IF;

Line 419: p_encoded => FND_API.G_FALSE

415: FND_MSG_PUB.Count_And_Get
416: (
417: p_count => x_msg_count ,
418: p_data => x_msg_data ,
419: p_encoded => FND_API.G_FALSE
420: );
421: END Update_PmtPlan;
422:
423: ---------------------------------------------------------------------------*