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

Line 9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

5:
6:
7: PROCEDURE get_payout_for_attain
8: (
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER :=
11: FND_API.G_VALID_LEVEL_FULL,
12: p_srp_quota_cate_id IN NUMBER,
13: p_est_achievement IN NUMBER,

Line 11: FND_API.G_VALID_LEVEL_FULL,

7: PROCEDURE get_payout_for_attain
8: (
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER :=
11: FND_API.G_VALID_LEVEL_FULL,
12: p_srp_quota_cate_id IN NUMBER,
13: p_est_achievement IN NUMBER,
14: p_what_if_flag IN BOOLEAN := FALSE,
15: x_estimated_payout OUT NOCOPY NUMBER,

Line 39: IF FND_API.to_Boolean( p_init_msg_list ) THEN

35: -- Standard Start of API savepoint
36: SAVEPOINT get_payout_for_attain;
37:
38: -- Initialize message list if p_init_msg_list is set to TRUE.
39: IF FND_API.to_Boolean( p_init_msg_list ) THEN
40: FND_MSG_PUB.initialize;
41: END IF;
42: -- Initialize API return status to success
43: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 43: x_return_status := FND_API.G_RET_STS_SUCCESS;

39: IF FND_API.to_Boolean( p_init_msg_list ) THEN
40: FND_MSG_PUB.initialize;
41: END IF;
42: -- Initialize API return status to success
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:
45:
46:
47: -- Find the formula associated with the srp_quota_cate

Line 63: RAISE FND_API.G_EXC_ERROR;

59: THEN
60: FND_MESSAGE.SET_NAME('CN', 'CN_FORMULA_NOT_ASSIGNED');
61: FND_MSG_PUB.Add;
62: END IF;
63: RAISE FND_API.G_EXC_ERROR;
64: END IF;
65:
66: SELECT formula_status, org_id
67: INTO l_formula_status, l_org_id

Line 77: RAISE FND_API.G_EXC_ERROR;

73: THEN
74: FND_MESSAGE.SET_NAME('CN', 'CN_FORMULA_INCOMPLETE');
75: FND_MSG_PUB.Add;
76: END IF;
77: RAISE FND_API.G_EXC_ERROR;
78: END IF;
79:
80: IF p_what_if_flag THEN -- What if scenario
81:

Line 118: RAISE FND_API.G_EXC_ERROR;

114: THEN
115: FND_MESSAGE.SET_NAME('CN', 'CN_FORMU_UNEXP_ERR');
116: FND_MSG_PUB.Add;
117: END IF;
118: RAISE FND_API.G_EXC_ERROR;
119: END;
120:
121: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
122: RAISE FND_API.G_EXC_ERROR;

Line 121: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

117: END IF;
118: RAISE FND_API.G_EXC_ERROR;
119: END;
120:
121: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
122: RAISE FND_API.G_EXC_ERROR;
123: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: ELSIF l_return_status = 'Z' THEN

Line 122: RAISE FND_API.G_EXC_ERROR;

118: RAISE FND_API.G_EXC_ERROR;
119: END;
120:
121: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
122: RAISE FND_API.G_EXC_ERROR;
123: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: ELSIF l_return_status = 'Z' THEN
126: /*

Line 123: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

119: END;
120:
121: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
122: RAISE FND_API.G_EXC_ERROR;
123: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: ELSIF l_return_status = 'Z' THEN
126: /*
127: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

120:
121: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
122: RAISE FND_API.G_EXC_ERROR;
123: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: ELSIF l_return_status = 'Z' THEN
126: /*
127: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
128: THEN

Line 132: RAISE FND_API.G_EXC_ERROR;

128: THEN
129: FND_MESSAGE.SET_NAME('CN', 'CN_FORM_DIV_BY_ZERO');
130: FND_MSG_PUB.Add;
131: END IF;
132: RAISE FND_API.G_EXC_ERROR;
133: */
134: -- Next line added after supressing divide by zero message
135: l_estimated_payout := 0;
136:

Line 150: WHEN FND_API.G_EXC_ERROR THEN

146: p_data => x_msg_data );
147:
148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO get_payout_for_attain;
152: x_return_status := FND_API.G_RET_STS_ERROR ;
153: FND_MSG_PUB.Count_And_Get
154: (p_count => x_msg_count ,

Line 152: x_return_status := FND_API.G_RET_STS_ERROR ;

148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO get_payout_for_attain;
152: x_return_status := FND_API.G_RET_STS_ERROR ;
153: FND_MSG_PUB.Count_And_Get
154: (p_count => x_msg_count ,
155: p_data => x_msg_data );
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

152: x_return_status := FND_API.G_RET_STS_ERROR ;
153: FND_MSG_PUB.Count_And_Get
154: (p_count => x_msg_count ,
155: p_data => x_msg_data );
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO get_payout_for_attain;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: FND_MSG_PUB.Count_And_Get
160: (p_count => x_msg_count ,

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

154: (p_count => x_msg_count ,
155: p_data => x_msg_data );
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO get_payout_for_attain;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: FND_MSG_PUB.Count_And_Get
160: (p_count => x_msg_count ,
161: p_data => x_msg_data );
162: WHEN OTHERS THEN

Line 164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

160: (p_count => x_msg_count ,
161: p_data => x_msg_data );
162: WHEN OTHERS THEN
163: ROLLBACK TO get_payout_for_attain;
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
165: IF FND_MSG_PUB.Check_Msg_Level
166: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
167: THEN
168: FND_MSG_PUB.Add_Exc_Msg

Line 182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

178:
179:
180: PROCEDURE get_payout_for_pct_attain
181: (
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
183: p_validation_level IN NUMBER :=
184: FND_API.G_VALID_LEVEL_FULL,
185: p_srp_quota_cate_id IN NUMBER,
186: p_attain_percent IN NUMBER,

Line 184: FND_API.G_VALID_LEVEL_FULL,

180: PROCEDURE get_payout_for_pct_attain
181: (
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
183: p_validation_level IN NUMBER :=
184: FND_API.G_VALID_LEVEL_FULL,
185: p_srp_quota_cate_id IN NUMBER,
186: p_attain_percent IN NUMBER,
187: p_annual_quota IN NUMBER,
188: p_what_if_flag IN BOOLEAN := FALSE,

Line 204: IF FND_API.to_Boolean( p_init_msg_list ) THEN

200: -- Standard Start of API savepoint
201: SAVEPOINT get_payout_for_pct_attain;
202:
203: -- Initialize message list if p_init_msg_list is set to TRUE.
204: IF FND_API.to_Boolean( p_init_msg_list ) THEN
205: FND_MSG_PUB.initialize;
206: END IF;
207: -- Initialize API return status to success
208: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 208: x_return_status := FND_API.G_RET_STS_SUCCESS;

204: IF FND_API.to_Boolean( p_init_msg_list ) THEN
205: FND_MSG_PUB.initialize;
206: END IF;
207: -- Initialize API return status to success
208: x_return_status := FND_API.G_RET_STS_SUCCESS;
209:
210: l_est_achievement := p_attain_percent/100*p_annual_quota;
211:
212: get_payout_for_attain

Line 229: WHEN FND_API.G_EXC_ERROR THEN

225: ( p_count => x_msg_count ,
226: p_data => x_msg_data );
227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: ROLLBACK TO get_payout_for_pct_attain;
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: FND_MSG_PUB.Count_And_Get
233: (p_count => x_msg_count ,

Line 231: x_return_status := FND_API.G_RET_STS_ERROR ;

227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: ROLLBACK TO get_payout_for_pct_attain;
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: FND_MSG_PUB.Count_And_Get
233: (p_count => x_msg_count ,
234: p_data => x_msg_data );
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: FND_MSG_PUB.Count_And_Get
233: (p_count => x_msg_count ,
234: p_data => x_msg_data );
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: ROLLBACK TO get_payout_for_pct_attain;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: FND_MSG_PUB.Count_And_Get
239: (p_count => x_msg_count ,

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

233: (p_count => x_msg_count ,
234: p_data => x_msg_data );
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: ROLLBACK TO get_payout_for_pct_attain;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: FND_MSG_PUB.Count_And_Get
239: (p_count => x_msg_count ,
240: p_data => x_msg_data );
241: WHEN OTHERS THEN

Line 243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

239: (p_count => x_msg_count ,
240: p_data => x_msg_data );
241: WHEN OTHERS THEN
242: ROLLBACK TO get_payout_for_pct_attain;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: IF FND_MSG_PUB.Check_Msg_Level
245: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
246: THEN
247: FND_MSG_PUB.Add_Exc_Msg

Line 395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

391: EXIT;
392: END IF;
393:
394: ELSE
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END IF;
397: END LOOP;
398:
399: -- deal with the exceeding amount