DBA Data[Home] [Help]

APPS.GMS_AWARD_DELETE_PKG dependencies on FND_API

Line 40: -- RAISE FND_API.G_EXC_ERROR;

36: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_EVENT_EXIST');
37: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
38: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
39: RETURN TRUE;
40: -- RAISE FND_API.G_EXC_ERROR;
41: END;
42: END check_event_exist;
43:
44:

Line 127: -- RAISE FND_API.G_EXC_ERROR;

123: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_BASELINED_BUDGET_EXIST');
124: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
125: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
126: RETURN TRUE;
127: -- RAISE FND_API.G_EXC_ERROR;
128: END;
129: END check_baselined_budget_exist;
130: ---------------------------------------------------------------------------------------
131: --Check ADL exist for the award

Line 211: RAISE FND_API.G_EXC_ERROR; --bug 2355648

207: p_msg_count =>p_msg_count,
208: RETCODE =>retcode,
209: ERRBUFF =>errbuff);
210: IF retcode <> 'S' THEN
211: RAISE FND_API.G_EXC_ERROR; --bug 2355648
212: END IF;
213:
214: IF l_funding_Exists THEN
215:

Line 223: RAISE FND_API.G_EXC_ERROR; --bug 2355648

219: RETCODE =>retcode,
220: ERRBUFF =>errbuff);
221:
222: IF retcode <> 'S' THEN
223: RAISE FND_API.G_EXC_ERROR; --bug 2355648
224: END IF;
225: IF l_Draft_Budget_Exists THEN
226: FOR PROJECT_INFO IN GET_PROJECT_ID
227: LOOP

Line 247: RAISE FND_API.G_EXC_ERROR; --bug 2355648

243: FND_MESSAGE.SET_NAME('GMS','GMS_DELETE_DRAFT_FAIL');
244: FND_MSG_PUB.add;
245: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
246: p_data => errbuff);
247: RAISE FND_API.G_EXC_ERROR; --bug 2355648
248: END IF;
249: END IF; --End if for l_Draft_Budget_Exists
250:
251: FOR FUNDING_INFO IN PROJECT_FUNDING

Line 269: RAISE FND_API.G_EXC_ERROR; --bug 2355648

265: FND_MESSAGE.SET_NAME('GMS','GMS_DELETE_FUNDING_FAIL');
266: FND_MSG_PUB.add;
267: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
268: p_data => errbuff);
269: RAISE FND_API.G_EXC_ERROR; --bug 2355648
270: END IF;
271:
272: GMS_MULTI_FUNDING.DELETE_AWARD_FUNDING
273: (X_INSTALLMENT_ID => FUNDING_INFO.INSTALLMENT_ID,

Line 282: RAISE FND_API.G_EXC_ERROR;

278: X_msg_count => p_msg_count,
279: RETCODE => retcode );
280:
281: IF retcode <> 'S' then
282: RAISE FND_API.G_EXC_ERROR;
283: END IF;
284: END LOOP;
285: END IF ; --End if for l_funding_Exists
286:

Line 298: RAISE FND_API.G_EXC_ERROR;

294: ERRBUF => errbuff );
295:
296:
297: IF retcode<> 'S' THEN
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300: END IF; -- End if for :gms_awards_v.Award_Template_flag
301: DELETE_AWARD_ALL(p_Award_Id =>p_Award_id,
302: p_msg_count =>p_msg_count,

Line 306: RAISE FND_API.G_EXC_ERROR;

302: p_msg_count =>p_msg_count,
303: RETCODE =>retcode,
304: ERRBUFF =>errbuff);
305: IF retcode <> 'S' THEN
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;
308: retcode :='S';
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN

Line 310: WHEN FND_API.G_EXC_ERROR THEN

306: RAISE FND_API.G_EXC_ERROR;
307: END IF;
308: retcode :='S';
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: BEGIN
312: retcode :='E';
313: errbuff := 'Error :'||substr(sqlerrm,1,200);
314: ROLLBACK;

Line 354: RAISE FND_API.G_EXC_ERROR;

350: BEGIN
351: l_event_exist := check_event_exist(p_award_Id, l_retcode, l_errbuff);
352:
353: IF l_retcode <> 'S' THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: l_adl_exist := check_adl_exist(p_award_id, l_retcode, l_errbuff);
358:

Line 360: RAISE FND_API.G_EXC_ERROR;

356:
357: l_adl_exist := check_adl_exist(p_award_id, l_retcode, l_errbuff);
358:
359: IF l_retcode <> 'S' THEN
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:
363: l_baselined_exist := check_baselined_budget_exist(p_award_Id,l_retcode, l_errbuff);
364:

Line 366: RAISE FND_API.G_EXC_ERROR;

362:
363: l_baselined_exist := check_baselined_budget_exist(p_award_Id,l_retcode, l_errbuff);
364:
365: IF l_retcode <> 'S' THEN
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368:
369: IF ( l_event_exist OR
370: l_adl_exist OR

Line 426: RAISE FND_API.G_EXC_ERROR ;

422: retcode :='S';
423: RETURN FALSE;
424: END IF;
425: ELSE
426: RAISE FND_API.G_EXC_ERROR ;
427: END IF; */
428: EXCEPTION
429: WHEN FND_API.G_EXC_ERROR THEN
430: BEGIN

Line 429: WHEN FND_API.G_EXC_ERROR THEN

425: ELSE
426: RAISE FND_API.G_EXC_ERROR ;
427: END IF; */
428: EXCEPTION
429: WHEN FND_API.G_EXC_ERROR THEN
430: BEGIN
431: retcode :='E';
432: errbuff := 'Error :'||substr(sqlerrm,1,200);
433: RETURN FALSE;

Line 491: -- RAISE FND_API.G_EXC_ERROR;

487: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
488: p_data => Errbuff);
489:
490: RETURN TRUE;
491: -- RAISE FND_API.G_EXC_ERROR;
492: END;
493: END check_draft_budget_exists;
494: -------------------------------------------------------------------------------------------------------
495: --Delete the Award Details