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_MSG_PUB

Line 11: fnd_msg_pub.initialize;

7: X_Err_Code OUT NOCOPY VARCHAR2,
8: X_Err_Stage OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
9: Row_Check INTEGER;
10: Begin
11: fnd_msg_pub.initialize;
12: Select
13: 1
14: into
15: Row_Check

Line 37: FND_MSG_PUB.add;

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

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

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;
41: WHEN OTHERS THEN
42: X_Err_Code := 'U';

Line 48: FND_MSG_PUB.add;

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:
52: RETURN FALSE;

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

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:
52: RETURN FALSE;
53: END ROW_EXISTS_IN_GMS_SUMM_FUNDING;

Line 64: fnd_msg_pub.initialize;

60: X_Total_Revenue_Amount OUT NOCOPY NUMBER,
61: X_Err_Code OUT NOCOPY VARCHAR2,
62: X_Err_Stage OUT NOCOPY VARCHAR2) IS
63: Begin
64: fnd_msg_pub.initialize;
65:
66: /*Bug 3643335: Added trunc for total_billed_amount and total_revenue_amount) */
67: select
68: total_funding_amount,

Line 93: FND_MSG_PUB.add;

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
97: X_Err_Code := 'U';

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

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
97: X_Err_Code := 'U';
98: X_Err_Stage := SQLCODE||' '||SQLERRM;

Line 103: FND_MSG_PUB.add;

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:
107: END GET_GMS_SUMM_FUNDING;

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

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:
107: END GET_GMS_SUMM_FUNDING;
108:

Line 117: fnd_msg_pub.initialize;

113: X_Err_Code OUT NOCOPY VARCHAR2,
114: X_Err_Stage OUT NOCOPY VARCHAR2) IS
115: St_Total_Funding NUMBER(22,5);
116: Begin
117: fnd_msg_pub.initialize;
118:
119: update GMS_SUMMARY_PROJECT_FUNDINGS
120: set TOTAL_FUNDING_AMOUNT = X_Funding_Amount,
121: LAST_UPDATE_DATE = SYSDATE ,

Line 139: FND_MSG_PUB.add;

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;
143:

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

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;
143:
144: END UPDATE_GMS_SUMM_PROJ_FUNDING;

Line 153: fnd_msg_pub.initialize;

149: X_Funding_Amount IN NUMBER,
150: X_Err_Code OUT NOCOPY VARCHAR2,
151: X_Err_Stage OUT NOCOPY VARCHAR2) IS
152: Begin
153: fnd_msg_pub.initialize;
154:
155: INSERT INTO GMS_SUMMARY_PROJECT_FUNDINGS
156: (INSTALLMENT_ID ,
157: PROJECT_ID,

Line 184: FND_MSG_PUB.add;

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:
188: End INSERT_GMS_SUMM_PROJ_FUNDING;

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

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:
188: End INSERT_GMS_SUMM_PROJ_FUNDING;
189:

Line 310: fnd_msg_pub.initialize;

306: END;
307:
308: Begin
309:
310: fnd_msg_pub.initialize;
311: -- Assume project funding row has been deleted.
312:
313: GET_GMS_SUMM_FUNDING(X_Installment_Id,
314: X_Project_Id,

Line 359: FND_MSG_PUB.add;

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:
363: RAISE FND_API.G_EXC_ERROR;

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

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:
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

Line 368: FND_MSG_PUB.add;

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:
372: RAISE FND_API.G_EXC_ERROR;

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

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:
372: RAISE FND_API.G_EXC_ERROR;
373: End If;

Line 396: FND_MSG_PUB.add;

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;
400: Else

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

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;
400: Else
401: X_Total_Funding_Amount := (X_Total_Funding_Amount - X_Funding_Amount);

Line 479: FND_MSG_PUB.add;

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;
483: Elsif (X_Invoice_Limit_Flag ='Y') AND (X_Total_Funding_Amount < X_Total_Billed_Amount) then

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

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;
483: Elsif (X_Invoice_Limit_Flag ='Y') AND (X_Total_Funding_Amount < X_Total_Billed_Amount) then
484: X_Err_Code := 'E';

Line 487: FND_MSG_PUB.add;

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;
491: Else

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

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;
491: Else
492: UPDATE_GMS_SUMM_PROJ_FUNDING(X_Installment_Id,