DBA Data[Home] [Help]

APPS.GMS_AWARD_DELETE_PKG dependencies on GMS_AWARD_DELETE_PKG

Line 1: PACKAGE BODY GMS_AWARD_DELETE_PKG as

1: PACKAGE BODY GMS_AWARD_DELETE_PKG as
2: /* $Header: gmsawdlb.pls 115.14 2003/08/01 09:34:00 lveerubh ship $ */
3:
4: -- Awards delete
5: ----------------------------------------------------------------------------------------

Line 36: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_EVENT_EXIST');

32: BEGIN
33: p_Err_Code := 'U';
34: p_Err_Stage := 'CHECK_EVENT_EXIST';
35: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_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;

Line 80: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_FUNDING_EXISTS');

76: BEGIN
77: retcode :='U';
78: errbuff := 'Error :'||substr(sqlerrm,1,200);
79: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
80: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_FUNDING_EXISTS');
81: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
82: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
83: FND_MSG_PUB.add;
84: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 123: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_BASELINED_BUDGET_EXIST');

119: BEGIN
120: p_Err_Code :='U';
121: p_err_stage :=' CHECK_BASELINED_BUDGET_EXIST';
122: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_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;

Line 162: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_ADL_EXIST');

158: BEGIN
159: p_Err_Code :='U';
160: p_Err_Stage :='CHECK_ADL_EXIST';
161: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
162: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_ADL_EXIST');
163: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
164: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
165: RETURN TRUE;
166: END;

Line 205: l_Funding_Exists:= GMS_AWARD_DELETE_PKG.CHECK_FUNDING_EXISTS

201: l_draft_budget_exists boolean;
202: Begin
203: FND_MSG_PUB.Initialize;
204: IF p_Award_Template_flag ='DEFERRED' THEN
205: l_Funding_Exists:= GMS_AWARD_DELETE_PKG.CHECK_FUNDING_EXISTS
206: (p_Award_Id =>p_Award_id,
207: p_msg_count =>p_msg_count,
208: RETCODE =>retcode,
209: ERRBUFF =>errbuff);

Line 216: l_Draft_Budget_Exists:=GMS_AWARD_DELETE_PKG.CHECK_DRAFT_BUDGET_EXISTS

212: END IF;
213:
214: IF l_funding_Exists THEN
215:
216: l_Draft_Budget_Exists:=GMS_AWARD_DELETE_PKG.CHECK_DRAFT_BUDGET_EXISTS
217: (p_Award_Id =>p_Award_id,
218: p_msg_count =>p_msg_count,
219: RETCODE =>retcode,
220: ERRBUFF =>errbuff);

Line 322: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: DELETE_AWARD_DETAIL');

318: --'S' for success, 'E' form exception for , and 'U' for Undefine Exception
319: retcode :='U';
320: errbuff := 'Error :'||substr(sqlerrm,1,200);
321: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
322: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: DELETE_AWARD_DETAIL');
323: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
324: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
325: FND_MSG_PUB.add;
326: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 441: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: DELETE_AWARD_OK');

437: --'S' for success, 'E' form exception for , and 'U' for Undefine Exception
438: retcode :='U';
439: errbuff := 'Error :'||substr(sqlerrm,1,200);
440: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
441: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: DELETE_AWARD_OK');
442: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
443: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
444: RETURN FALSE;
445: END;

Line 483: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_DRAFT_BUDGET_EXISTS');

479: BEGIN
480: retcode := 'U';
481: errbuff := 'Error :'||substr(sqlerrm,1,200);
482: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
483: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_DRAFT_BUDGET_EXISTS');
484: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
485: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
486: FND_MSG_PUB.add;
487: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 540: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: DELETE_AWARD_ALL');

536: --'S' for success, 'E' form exception for , and 'U' for Undefine Exception
537: retcode :='U';
538: errbuff := 'Error :'||substr(sqlerrm,1,200);
539: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
540: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: DELETE_AWARD_ALL');
541: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
542: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
543: FND_MSG_PUB.add;
544: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 548: END GMS_AWARD_DELETE_PKG;

544: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
545: p_data => errbuff);
546: END;
547: END DELETE_AWARD_ALL;
548: END GMS_AWARD_DELETE_PKG;