eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_AWARD_DELETE_PKG dependencies on FND_MESSAGE

Line 35: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');

31: WHEN OTHERS THEN
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;

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 37: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);

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;
41: END;

Line 38: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);

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;
41: END;
42: END check_event_exist;

Line 79: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');

75: WHEN OTHERS THEN
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;

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 81: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);

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,
85: p_data => errbuff);

Line 82: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);

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

Line 122: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');

118: WHEN OTHERS THEN
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;

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 124: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);

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;
128: END;

Line 125: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);

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;
128: END;
129: END check_baselined_budget_exist;

Line 161: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');

157: WHEN OTHERS THEN
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;

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 163: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);

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;
167: END check_adl_exist;

Line 164: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);

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;
167: END check_adl_exist;
168: --==========================================================

Line 243: FND_MESSAGE.SET_NAME('GMS','GMS_DELETE_DRAFT_FAIL');

239: exit;
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

Line 265: FND_MESSAGE.SET_NAME('GMS','GMS_DELETE_FUNDING_FAIL');

261: ERRBUF => errbuff);
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

Line 321: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');

317: BEGIN
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;

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 323: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);

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

Line 324: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);

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

Line 440: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');

436: BEGIN
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;

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 442: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);

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;
446: END delete_award_ok;

Line 443: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);

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;
446: END delete_award_ok;
447:

Line 482: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');

478: WHEN OTHERS THEN
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;

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 484: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);

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

Line 485: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);

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

Line 539: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');

535: ROLLBACK;
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;

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 541: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);

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

Line 542: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);

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