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.QPR_DASHBOARD_UTIL dependencies on FND_API

Line 16: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

12: )
13: IS
14:
15: l_api_name CONSTANT VARCHAR2(30) := 'Populate_Dashboard_Util';
16: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: l_dashboard_type VARCHAR2(1);
18: l_source_template_id NUMBER;
19: l_dashboard_id NUMBER;
20: n_dashboard_id NUMBER;

Line 53: x_return_status := FND_API.G_RET_STS_SUCCESS;

49: END;
50:
51: IF SQL%FOUND THEN
52: IF l_dashboard_type = 'I' THEN
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54: --ask shanmu whether error needs to be raised here
55: END IF;
56: ELSE
57: OPEN c_dashboard;

Line 72: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

68: SELECT QPR_DASHBOARD_MASTER_S.NEXTVAL into n_dashboard_id FROM DUAL;
69: Populate_Dashboard_Details(p_user_id,p_plan_id,l_dashboard_id,n_dashboard_id,l_dsb_table,l_return_status);
70:
71:
72: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
73: --generate proper error log ask shanmu
74:
75: SELECT dashboard_name,source_lang
76: INTO l_dashboard_name,l_source_lang

Line 101: x_return_status := FND_API.G_RET_STS_ERROR;

97: EXCEPTION
98: WHEN TEMPLATE_NOT_FOUND THEN
99: --populate a msg saying no default template exists in table
100: ROLLBACK to Create_Dashboard_Default_P;
101: x_return_status := FND_API.G_RET_STS_ERROR;
102: FND_MESSAGE.SET_NAME('QPR','QPR_API_INVALID_INPUT');
103: FND_MESSAGE.SET_TOKEN('ERROR_TEXT','Default Dashboard template Not found');
104: --FND_MESSAGE_PUB.add;
105: raise FND_API.G_EXC_ERROR;

Line 105: raise FND_API.G_EXC_ERROR;

101: x_return_status := FND_API.G_RET_STS_ERROR;
102: FND_MESSAGE.SET_NAME('QPR','QPR_API_INVALID_INPUT');
103: FND_MESSAGE.SET_TOKEN('ERROR_TEXT','Default Dashboard template Not found');
104: --FND_MESSAGE_PUB.add;
105: raise FND_API.G_EXC_ERROR;
106:
107: WHEN OTHERS THEN
108: ROLLBACK to Create_Dashboard_Default_P;
109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

105: raise FND_API.G_EXC_ERROR;
106:
107: WHEN OTHERS THEN
108: ROLLBACK to Create_Dashboard_Default_P;
109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
110: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
111: FND_MSG_PUB.Add_Exc_Msg
112: ( G_PKG_NAME,
113: l_api_name

Line 117: raise FND_API.G_EXC_UNEXPECTED_ERROR;

113: l_api_name
114: );
115: END IF;
116:
117: raise FND_API.G_EXC_UNEXPECTED_ERROR;
118:
119: END Create_Dashboard_Default;
120:
121:

Line 135: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

131: )
132: IS
133:
134: l_api_name CONSTANT VARCHAR2(30) := 'Populate_Dashboard_Util';
135: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
136: l_dashboard_detail_id NUMBER;
137: n_dashboard_detail_id NUMBER;
138: l_row_number NUMBER;
139: l_col_number NUMBER;

Line 182: x_return_status := FND_API.G_RET_STS_SUCCESS;

178: p_dsb_table(l_counter).width := details_rec.width;
179: l_counter := l_counter + 1;
180:
181: END LOOP;
182: x_return_status := FND_API.G_RET_STS_SUCCESS;
183:
184: EXCEPTION
185: WHEN NO_DATA_FOUND THEN
186: ROLLBACK TO Populate_Dashboard_Details_P;

Line 187: x_return_status := FND_API.G_RET_STS_ERROR;

183:
184: EXCEPTION
185: WHEN NO_DATA_FOUND THEN
186: ROLLBACK TO Populate_Dashboard_Details_P;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MESSAGE.Set_Name ('QPR','QPR_API_INVALID_INPUT');
189: FND_MESSAGE.Set_Token ('ERROR_TEXT','No Rows for Content Id in Reports table');
190: FND_MSG_PUB.Add;
191: raise FND_API.G_EXC_ERROR;

Line 191: raise FND_API.G_EXC_ERROR;

187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MESSAGE.Set_Name ('QPR','QPR_API_INVALID_INPUT');
189: FND_MESSAGE.Set_Token ('ERROR_TEXT','No Rows for Content Id in Reports table');
190: FND_MSG_PUB.Add;
191: raise FND_API.G_EXC_ERROR;
192:
193: WHEN TOO_MANY_ROWS THEN
194: ROLLBACK TO Populate_Dashboard_Details_P;
195: x_return_status := FND_API.G_RET_STS_ERROR;

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191: raise FND_API.G_EXC_ERROR;
192:
193: WHEN TOO_MANY_ROWS THEN
194: ROLLBACK TO Populate_Dashboard_Details_P;
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MESSAGE.Set_Name ('QPR','QPR_API_INVALID_INPUT');
197: FND_MESSAGE.Set_Token ('ERROR_TEXT','Too many Rows for Content Id in Reports table');
198: FND_MSG_PUB.Add;
199: WHEN OTHERS THEN

Line 201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

197: FND_MESSAGE.Set_Token ('ERROR_TEXT','Too many Rows for Content Id in Reports table');
198: FND_MSG_PUB.Add;
199: WHEN OTHERS THEN
200: ROLLBACK TO Populate_Dashboard_Details_P;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: FND_MSG_PUB.Add_Exc_Msg
205: ( G_PKG_NAME,

Line 210: raise FND_API.G_EXC_UNEXPECTED_ERROR;

206: l_api_name
207: );
208: END IF;
209:
210: raise FND_API.G_EXC_UNEXPECTED_ERROR;
211:
212: END Populate_Dashboard_Details;
213:
214:

Line 374: x_return_status := FND_API.G_RET_STS_SUCCESS;

370:
371: DELETE FROM QPR_DASHBOARD_MASTER_B
372: WHERE PLAN_ID = p_price_plan_id;
373:
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375: EXCEPTION
376: WHEN OTHERS
377: THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375: EXCEPTION
376: WHEN OTHERS
377: THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END DELETE_DASHBOARDS;
380:
381:
382: END QPR_DASHBOARD_UTIL;