DBA Data[Home] [Help]

APPS.GMS_AWARD_DELETE_PKG dependencies on FND_MSG_PUB

Line 83: FND_MSG_PUB.add;

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,
85: p_data => errbuff);
86: RETURN FALSE;
87: END;

Line 84: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

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,
85: p_data => errbuff);
86: RETURN FALSE;
87: END;
88: END check_funding_exists;

Line 203: FND_MSG_PUB.Initialize;

199: l_err_stack varchar2(240) :='';
200: l_Funding_Exists boolean;
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,

Line 244: FND_MSG_PUB.add;

240: END IF;
241: END LOOP;
242: IF (l_err_code <> 0) then
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;

Line 245: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

241: END LOOP;
242: IF (l_err_code <> 0) then
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

Line 266: FND_MSG_PUB.add;

262:
263:
264: IF retcode <> 'S' then
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;

Line 267: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

263:
264: IF retcode <> 'S' then
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:

Line 325: FND_MSG_PUB.add;

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,
327: p_data => errbuff);
328: ROLLBACK;
329: END;

Line 326: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

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,
327: p_data => errbuff);
328: ROLLBACK;
329: END;
330: END DELETE_AWARD_DETAIL;

Line 486: FND_MSG_PUB.add;

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,
488: p_data => Errbuff);
489:
490: RETURN TRUE;

Line 487: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

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,
488: p_data => Errbuff);
489:
490: RETURN TRUE;
491: -- RAISE FND_API.G_EXC_ERROR;

Line 543: FND_MSG_PUB.add;

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,
545: p_data => errbuff);
546: END;
547: END DELETE_AWARD_ALL;

Line 544: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

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,
545: p_data => errbuff);
546: END;
547: END DELETE_AWARD_ALL;
548: END GMS_AWARD_DELETE_PKG;