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_SUMM_FUNDING_PKG dependencies on FND_MESSAGE

Line 33: FND_MESSAGE.SET_NAME('GMS','GMS_MULT_ROW_FOR_INST');

29: RETURN FALSE;
30: WHEN TOO_MANY_ROWS THEN
31: X_Err_Code := 'E';
32: X_Err_Stage := 'There is more than one row for the Installment '||to_char(X_Installment_Id)||' and the Project '||to_char(X_Project_Id);
33: FND_MESSAGE.SET_NAME('GMS','GMS_MULT_ROW_FOR_INST');
34: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
35: FND_MESSAGE.SET_TOKEN('PROJECT_ID',to_char(X_Project_Id) );
36: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : ROW_EXISTS_IN_GMS_SUMM_FUNDING');
37: FND_MSG_PUB.add;

Line 34: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );

30: WHEN TOO_MANY_ROWS THEN
31: X_Err_Code := 'E';
32: X_Err_Stage := 'There is more than one row for the Installment '||to_char(X_Installment_Id)||' and the Project '||to_char(X_Project_Id);
33: FND_MESSAGE.SET_NAME('GMS','GMS_MULT_ROW_FOR_INST');
34: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
35: FND_MESSAGE.SET_TOKEN('PROJECT_ID',to_char(X_Project_Id) );
36: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : ROW_EXISTS_IN_GMS_SUMM_FUNDING');
37: FND_MSG_PUB.add;
38: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 35: FND_MESSAGE.SET_TOKEN('PROJECT_ID',to_char(X_Project_Id) );

31: X_Err_Code := 'E';
32: X_Err_Stage := 'There is more than one row for the Installment '||to_char(X_Installment_Id)||' and the Project '||to_char(X_Project_Id);
33: FND_MESSAGE.SET_NAME('GMS','GMS_MULT_ROW_FOR_INST');
34: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
35: FND_MESSAGE.SET_TOKEN('PROJECT_ID',to_char(X_Project_Id) );
36: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : ROW_EXISTS_IN_GMS_SUMM_FUNDING');
37: FND_MSG_PUB.add;
38: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
39: p_data => X_Err_Stage);

Line 36: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : ROW_EXISTS_IN_GMS_SUMM_FUNDING');

32: X_Err_Stage := 'There is more than one row for the Installment '||to_char(X_Installment_Id)||' and the Project '||to_char(X_Project_Id);
33: FND_MESSAGE.SET_NAME('GMS','GMS_MULT_ROW_FOR_INST');
34: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
35: FND_MESSAGE.SET_TOKEN('PROJECT_ID',to_char(X_Project_Id) );
36: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : ROW_EXISTS_IN_GMS_SUMM_FUNDING');
37: FND_MSG_PUB.add;
38: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
39: p_data => X_Err_Stage);
40: RETURN FALSE;

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

40: RETURN FALSE;
41: WHEN OTHERS THEN
42: X_Err_Code := 'U';
43: X_Err_Stage := (SQLCODE||' '||SQLERRM);
44: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
45: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : ROW_EXISTS_IN_GMS_SUMM_FUNDING');
46: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
47: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
48: FND_MSG_PUB.add;

Line 45: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : ROW_EXISTS_IN_GMS_SUMM_FUNDING');

41: WHEN OTHERS THEN
42: X_Err_Code := 'U';
43: X_Err_Stage := (SQLCODE||' '||SQLERRM);
44: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
45: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : ROW_EXISTS_IN_GMS_SUMM_FUNDING');
46: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
47: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
48: FND_MSG_PUB.add;
49: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 46: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);

42: X_Err_Code := 'U';
43: X_Err_Stage := (SQLCODE||' '||SQLERRM);
44: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
45: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : ROW_EXISTS_IN_GMS_SUMM_FUNDING');
46: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
47: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
48: FND_MSG_PUB.add;
49: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
50: p_data => X_Err_Stage);

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

43: X_Err_Stage := (SQLCODE||' '||SQLERRM);
44: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
45: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : ROW_EXISTS_IN_GMS_SUMM_FUNDING');
46: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
47: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
48: FND_MSG_PUB.add;
49: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
50: p_data => X_Err_Stage);
51:

Line 91: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ACT_PRJ_TSK_IN_SF');

87: X_Err_Stage := 'No row found for Project and Task specified in GMS_SUMMARY_PROJECT_FUNDINGS';
88: X_Total_Funding_Amount := -99;
89: X_Total_Billed_Amount := -99;
90: X_Total_Revenue_Amount := -99;
91: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ACT_PRJ_TSK_IN_SF');
92: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : GET_GMS_SUMM_FUNDING');
93: FND_MSG_PUB.add;
94: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
95: p_data => X_Err_Stage );

Line 92: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : GET_GMS_SUMM_FUNDING');

88: X_Total_Funding_Amount := -99;
89: X_Total_Billed_Amount := -99;
90: X_Total_Revenue_Amount := -99;
91: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ACT_PRJ_TSK_IN_SF');
92: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : GET_GMS_SUMM_FUNDING');
93: FND_MSG_PUB.add;
94: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
95: p_data => X_Err_Stage );
96: WHEN OTHERS THEN

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

95: p_data => X_Err_Stage );
96: WHEN OTHERS THEN
97: X_Err_Code := 'U';
98: X_Err_Stage := SQLCODE||' '||SQLERRM;
99: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
100: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : GET_GMS_SUMM_FUNDING');
101: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
102: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
103: FND_MSG_PUB.add;

Line 100: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : GET_GMS_SUMM_FUNDING');

96: WHEN OTHERS THEN
97: X_Err_Code := 'U';
98: X_Err_Stage := SQLCODE||' '||SQLERRM;
99: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
100: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : GET_GMS_SUMM_FUNDING');
101: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
102: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
103: FND_MSG_PUB.add;
104: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 101: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);

97: X_Err_Code := 'U';
98: X_Err_Stage := SQLCODE||' '||SQLERRM;
99: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
100: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : GET_GMS_SUMM_FUNDING');
101: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
102: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
103: FND_MSG_PUB.add;
104: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
105: p_data => X_Err_Stage);

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

98: X_Err_Stage := SQLCODE||' '||SQLERRM;
99: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
100: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : GET_GMS_SUMM_FUNDING');
101: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
102: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
103: FND_MSG_PUB.add;
104: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
105: p_data => X_Err_Stage);
106:

Line 135: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ROW_FOR_PRJ_TSK_SF');

131: X_Err_Code := 'S';
132: If SQL%NOTFOUND THEN
133: X_Err_Code := 'E';
134: X_Err_Stage := 'No Row to update for Installment '||to_char(X_Installment_Id)||' and Project '||to_char(X_Project_Id);
135: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ROW_FOR_PRJ_TSK_SF');
136: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : UPDATE_GMS_SUMM_PROJ_FUNDING');
137: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
138: FND_MESSAGE.SET_TOKEN('PROJECT_ID', to_char(X_Project_Id) );
139: FND_MSG_PUB.add;

Line 136: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : UPDATE_GMS_SUMM_PROJ_FUNDING');

132: If SQL%NOTFOUND THEN
133: X_Err_Code := 'E';
134: X_Err_Stage := 'No Row to update for Installment '||to_char(X_Installment_Id)||' and Project '||to_char(X_Project_Id);
135: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ROW_FOR_PRJ_TSK_SF');
136: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : UPDATE_GMS_SUMM_PROJ_FUNDING');
137: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
138: FND_MESSAGE.SET_TOKEN('PROJECT_ID', to_char(X_Project_Id) );
139: FND_MSG_PUB.add;
140: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 137: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );

133: X_Err_Code := 'E';
134: X_Err_Stage := 'No Row to update for Installment '||to_char(X_Installment_Id)||' and Project '||to_char(X_Project_Id);
135: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ROW_FOR_PRJ_TSK_SF');
136: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : UPDATE_GMS_SUMM_PROJ_FUNDING');
137: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
138: FND_MESSAGE.SET_TOKEN('PROJECT_ID', to_char(X_Project_Id) );
139: FND_MSG_PUB.add;
140: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
141: p_data => X_Err_Stage );

Line 138: FND_MESSAGE.SET_TOKEN('PROJECT_ID', to_char(X_Project_Id) );

134: X_Err_Stage := 'No Row to update for Installment '||to_char(X_Installment_Id)||' and Project '||to_char(X_Project_Id);
135: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ROW_FOR_PRJ_TSK_SF');
136: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : UPDATE_GMS_SUMM_PROJ_FUNDING');
137: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
138: FND_MESSAGE.SET_TOKEN('PROJECT_ID', to_char(X_Project_Id) );
139: FND_MSG_PUB.add;
140: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
141: p_data => X_Err_Stage );
142: End If;

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

176: EXCEPTION
177:
178: WHEN OTHERS THEN
179: X_Err_Code := 'U';
180: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : INSERT_GMS_SUMM_PROJ_FUNDING');
182: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
183: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
184: FND_MSG_PUB.add;

Line 181: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : INSERT_GMS_SUMM_PROJ_FUNDING');

177:
178: WHEN OTHERS THEN
179: X_Err_Code := 'U';
180: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : INSERT_GMS_SUMM_PROJ_FUNDING');
182: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
183: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
184: FND_MSG_PUB.add;
185: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 182: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);

178: WHEN OTHERS THEN
179: X_Err_Code := 'U';
180: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : INSERT_GMS_SUMM_PROJ_FUNDING');
182: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
183: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
184: FND_MSG_PUB.add;
185: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
186: p_data => X_Err_Stage);

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

179: X_Err_Code := 'U';
180: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : INSERT_GMS_SUMM_PROJ_FUNDING');
182: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
183: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
184: FND_MSG_PUB.add;
185: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
186: p_data => X_Err_Stage);
187:

Line 356: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV_BILL'); commented for bug 6642901*/

352: ((X_Total_Funding_Amount - X_Funding_Amount) < X_Total_Revenue_Amount)
353: ) then
354: X_Err_Code := 'E';
355: /* X_Err_Stage := 'Total Funding Amount cannot go less than Total Billed Amount or Total Revenue Amount';
356: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV_BILL'); commented for bug 6642901*/
357: X_Err_Stage := 'You cannot delete the funding line, as this will cause total funds to be less than the total revenue amount';
358: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV');
359: FND_MSG_PUB.add;
360: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 358: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV');

354: X_Err_Code := 'E';
355: /* X_Err_Stage := 'Total Funding Amount cannot go less than Total Billed Amount or Total Revenue Amount';
356: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV_BILL'); commented for bug 6642901*/
357: X_Err_Stage := 'You cannot delete the funding line, as this will cause total funds to be less than the total revenue amount';
358: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV');
359: FND_MSG_PUB.add;
360: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
361: p_data => X_Err_Stage );
362:

Line 367: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_BILL');

363: RAISE FND_API.G_EXC_ERROR;
364: Elsif (X_Invoice_Limit_Flag ='Y') and ((X_Total_Funding_Amount - X_Funding_Amount) < X_Total_Billed_Amount) then
365: X_Err_Code := 'E';
366: X_Err_Stage := 'You cannot delete the funding line, as this will cause total funds to be less than the total billed amount';
367: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_BILL');
368: FND_MSG_PUB.add;
369: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
370: p_data => X_Err_Stage );
371:

Line 392: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ROW_FOR_PRJ_TSK_SF');

388: If SQL%ROWCOUNT = 0 THEN
389: X_Err_Code := 'E';
390: X_Err_Stage := 'No Row to delete for Installment '||to_char(X_Installment_Id)||' and Project '||to_char(X_Project_Id);
391:
392: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ROW_FOR_PRJ_TSK_SF');
393: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : DELETE_GMS_SUMM_PROJ_FUNDING');
394: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
395: FND_MESSAGE.SET_TOKEN('PROJECT_ID', to_char(X_Project_Id) );
396: FND_MSG_PUB.add;

Line 393: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : DELETE_GMS_SUMM_PROJ_FUNDING');

389: X_Err_Code := 'E';
390: X_Err_Stage := 'No Row to delete for Installment '||to_char(X_Installment_Id)||' and Project '||to_char(X_Project_Id);
391:
392: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ROW_FOR_PRJ_TSK_SF');
393: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : DELETE_GMS_SUMM_PROJ_FUNDING');
394: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
395: FND_MESSAGE.SET_TOKEN('PROJECT_ID', to_char(X_Project_Id) );
396: FND_MSG_PUB.add;
397: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 394: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );

390: X_Err_Stage := 'No Row to delete for Installment '||to_char(X_Installment_Id)||' and Project '||to_char(X_Project_Id);
391:
392: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ROW_FOR_PRJ_TSK_SF');
393: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : DELETE_GMS_SUMM_PROJ_FUNDING');
394: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
395: FND_MESSAGE.SET_TOKEN('PROJECT_ID', to_char(X_Project_Id) );
396: FND_MSG_PUB.add;
397: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
398: p_data => X_Err_Stage );

Line 395: FND_MESSAGE.SET_TOKEN('PROJECT_ID', to_char(X_Project_Id) );

391:
392: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ROW_FOR_PRJ_TSK_SF');
393: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_SUMM_FUNDING_PKG : DELETE_GMS_SUMM_PROJ_FUNDING');
394: FND_MESSAGE.SET_TOKEN('INSTALLMENT_ID',to_char(X_Installment_Id) );
395: FND_MESSAGE.SET_TOKEN('PROJECT_ID', to_char(X_Project_Id) );
396: FND_MSG_PUB.add;
397: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
398: p_data => X_Err_Stage );
399: End If;

Line 476: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV_BILL'); Commented for bug 6445688*/

472: (X_Total_Funding_Amount < X_Total_Revenue_Amount)
473: ) then
474: X_Err_Code := 'E';
475: /* X_Err_Stage := 'Total Funding cannot go less than the Total Revenue Amount or Total Billed Amount';
476: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV_BILL'); Commented for bug 6445688*/
477: X_Err_Stage := 'You cannot delete the funding line, as this will cause total funds to be less than the total revenue amount';
478: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV');
479: FND_MSG_PUB.add;
480: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 478: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV');

474: X_Err_Code := 'E';
475: /* X_Err_Stage := 'Total Funding cannot go less than the Total Revenue Amount or Total Billed Amount';
476: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV_BILL'); Commented for bug 6445688*/
477: X_Err_Stage := 'You cannot delete the funding line, as this will cause total funds to be less than the total revenue amount';
478: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_REV');
479: FND_MSG_PUB.add;
480: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
481: p_data => X_Err_Stage );
482: RAISE FND_API.G_EXC_ERROR;

Line 486: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_BILL');

482: RAISE FND_API.G_EXC_ERROR;
483: Elsif (X_Invoice_Limit_Flag ='Y') AND (X_Total_Funding_Amount < X_Total_Billed_Amount) then
484: X_Err_Code := 'E';
485: X_Err_Stage := 'You cannot delete the funding line, as this will cause total funds to be less than the total billed amount';
486: FND_MESSAGE.SET_NAME('GMS','GMS_FUND_LESS_BILL');
487: FND_MSG_PUB.add;
488: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
489: p_data => X_Err_Stage );
490: RAISE FND_API.G_EXC_ERROR;