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_MSG_PUB

Line 40: FND_MSG_PUB.initialize;

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

Line 58: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

54: AND sqc.srp_quota_cate_id = p_srp_quota_cate_id
55: ;
56:
57: IF l_formula_id IS NULL THEN
58: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
59: THEN
60: FND_MESSAGE.SET_NAME('CN', 'CN_FORMULA_NOT_ASSIGNED');
61: FND_MSG_PUB.Add;
62: END IF;

Line 61: FND_MSG_PUB.Add;

57: IF l_formula_id IS NULL THEN
58: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_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:

Line 72: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

68: FROM cn_calc_formulas
69: WHERE calc_formula_id = l_formula_id;
70:
71: IF l_formula_status <> 'COMPLETE' THEN
72: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
73: THEN
74: FND_MESSAGE.SET_NAME('CN', 'CN_FORMULA_INCOMPLETE');
75: FND_MSG_PUB.Add;
76: END IF;

Line 75: FND_MSG_PUB.Add;

71: IF l_formula_status <> 'COMPLETE' THEN
72: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_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:

Line 113: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

109: USING p_srp_quota_cate_id, l_est_achievement, IN OUT l_estimated_payout, IN OUT l_return_status;
110:
111: EXCEPTION
112: WHEN OTHERS THEN
113: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
114: THEN
115: FND_MESSAGE.SET_NAME('CN', 'CN_FORMU_UNEXP_ERR');
116: FND_MSG_PUB.Add;
117: END IF;

Line 116: FND_MSG_PUB.Add;

112: WHEN OTHERS THEN
113: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_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:

Line 127: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_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
129: FND_MESSAGE.SET_NAME('CN', 'CN_FORM_DIV_BY_ZERO');
130: FND_MSG_PUB.Add;
131: END IF;

Line 130: FND_MSG_PUB.Add;

126: /*
127: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_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

Line 144: FND_MSG_PUB.Count_And_Get

140: x_estimated_payout := l_estimated_payout;
141:
142: -- Standard call to get message count and if count is 1, get message
143: -- info.
144: FND_MSG_PUB.Count_And_Get
145: ( p_count => x_msg_count ,
146: p_data => x_msg_data );
147:
148:

Line 153: FND_MSG_PUB.Count_And_Get

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
157: ROLLBACK TO get_payout_for_attain;

Line 159: FND_MSG_PUB.Count_And_Get

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
163: ROLLBACK TO get_payout_for_attain;

Line 165: IF FND_MSG_PUB.Check_Msg_Level

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
169: (G_PKG_NAME ,

Line 166: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
169: (G_PKG_NAME ,
170: l_api_name );

Line 168: FND_MSG_PUB.Add_Exc_Msg

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
169: (G_PKG_NAME ,
170: l_api_name );
171: END IF;
172: FND_MSG_PUB.Count_And_Get

Line 172: FND_MSG_PUB.Count_And_Get

168: FND_MSG_PUB.Add_Exc_Msg
169: (G_PKG_NAME ,
170: l_api_name );
171: END IF;
172: FND_MSG_PUB.Count_And_Get
173: (p_count => x_msg_count ,
174: p_data => x_msg_data );
175:
176: END;

Line 205: FND_MSG_PUB.initialize;

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

Line 224: FND_MSG_PUB.Count_And_Get

220: );
221:
222: -- Standard call to get message count and if count is 1, get message
223: -- info.
224: FND_MSG_PUB.Count_And_Get
225: ( p_count => x_msg_count ,
226: p_data => x_msg_data );
227:
228: EXCEPTION

Line 232: FND_MSG_PUB.Count_And_Get

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
236: ROLLBACK TO get_payout_for_pct_attain;

Line 238: FND_MSG_PUB.Count_And_Get

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
242: ROLLBACK TO get_payout_for_pct_attain;

Line 244: IF FND_MSG_PUB.Check_Msg_Level

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
248: (G_PKG_NAME ,

Line 245: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
248: (G_PKG_NAME ,
249: l_api_name );

Line 247: FND_MSG_PUB.Add_Exc_Msg

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
248: (G_PKG_NAME ,
249: l_api_name );
250: END IF;
251: FND_MSG_PUB.Count_And_Get

Line 251: FND_MSG_PUB.Count_And_Get

247: FND_MSG_PUB.Add_Exc_Msg
248: (G_PKG_NAME ,
249: l_api_name );
250: END IF;
251: FND_MSG_PUB.Count_And_Get
252: (p_count => x_msg_count ,
253: p_data => x_msg_data );
254:
255: