DBA Data[Home] [Help]

APPS.CN_TRX_FACTORS_PVT dependencies on FND_MSG_PUB

Line 70: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

66: -- get the Quota Rule ID
67: x_quota_rule_id := cn_chk_plan_element_pkg.get_quota_rule_id(x_quota_id, x_rev_class_id);
68: IF p_quota_name IS NOT NULL THEN
69: IF x_quota_id IS NULL THEN
70: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');
73: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);
74: FND_MSG_PUB.Add;

Line 74: FND_MSG_PUB.Add;

70: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');
73: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);
74: FND_MSG_PUB.Add;
75: RAISE FND_API.G_EXC_ERROR ;
76: END IF;
77: END IF;
78: END IF;

Line 82: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

78: END IF;
79:
80: IF p_rev_class_name IS NOT NULL THEN
81: IF x_rev_class_id IS NULL THEN
82: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
83: THEN
84: FND_MESSAGE.SET_NAME ('CN' , 'CN_REV_CLASS_NOT_EXIST');
85: FND_MSG_PUB.Add;
86: END IF;

Line 85: FND_MSG_PUB.Add;

81: IF x_rev_class_id IS NULL THEN
82: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
83: THEN
84: FND_MESSAGE.SET_NAME ('CN' , 'CN_REV_CLASS_NOT_EXIST');
85: FND_MSG_PUB.Add;
86: END IF;
87: x_loading_status := 'CN_REV_CLASS_NOT_EXIST';
88: RAISE FND_API.G_EXC_ERROR ;
89: END IF ;

Line 94: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

90: END IF;
91:
92:
93: IF x_quota_rule_id IS NULL THEN
94: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
95: THEN
96: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_RULE_NOT_EXIST');
97: FND_MSG_PUB.Add;
98: END IF;

Line 97: FND_MSG_PUB.Add;

93: IF x_quota_rule_id IS NULL THEN
94: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
95: THEN
96: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_RULE_NOT_EXIST');
97: FND_MSG_PUB.Add;
98: END IF;
99: x_loading_status := 'CN_QUOTA_RULE_NOT_EXIST';
100: RAISE FND_API.G_EXC_ERROR ;
101: END IF;

Line 175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

171: END IF;
172:
173: IF ltrim(Rtrim(p_rev_class_name)) <> Ltrim(Rtrim(p_trx_factor_rec.rev_class_name))
174: THEN
175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
176: THEN
177: FND_MESSAGE.SET_NAME ('CN' , 'CN_INCONSISTENT_REV_CLASS');
178: FND_MSG_PUB.Add;
179: END IF;

Line 178: FND_MSG_PUB.Add;

174: THEN
175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
176: THEN
177: FND_MESSAGE.SET_NAME ('CN' , 'CN_INCONSISTENT_REV_CLASS');
178: FND_MSG_PUB.Add;
179: END IF;
180: x_loading_status := 'CN_INCONSISTENT_REV_CLASS';
181: RAISE FND_API.G_EXC_ERROR ;
182: END IF;

Line 201: FND_MSG_PUB.Count_And_Get

197:
198: -- End of Validate Trx Factors.
199: -- Standard call to get message count and if count is 1, get message info.
200: --+
201: FND_MSG_PUB.Count_And_Get
202: (
203: p_count => x_msg_count,
204: p_data => x_msg_data,
205: p_encoded => FND_API.G_FALSE

Line 210: FND_MSG_PUB.Count_And_Get

206: );
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: x_return_status := FND_API.G_RET_STS_ERROR ;
210: FND_MSG_PUB.Count_And_Get
211: (
212: p_count => x_msg_count ,
213: p_data => x_msg_data ,
214: p_encoded => FND_API.G_FALSE

Line 219: FND_MSG_PUB.Count_And_Get

215: );
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
218: x_loading_status := 'UNEXPECTED_ERR';
219: FND_MSG_PUB.Count_And_Get
220: (
221: p_count => x_msg_count ,
222: p_data => x_msg_data ,
223: p_encoded => FND_API.G_FALSE

Line 228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

224: );
225: WHEN OTHERS THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: x_loading_status := 'UNEXPECTED_ERR';
228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
231: END IF;
232: FND_MSG_PUB.Count_And_Get

Line 230: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: x_loading_status := 'UNEXPECTED_ERR';
228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
231: END IF;
232: FND_MSG_PUB.Count_And_Get
233: (
234: p_count => x_msg_count,

Line 232: FND_MSG_PUB.Count_And_Get

228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
231: END IF;
232: FND_MSG_PUB.Count_And_Get
233: (
234: p_count => x_msg_count,
235: p_data => x_msg_data,
236: p_encoded=> FND_API.G_FALSE

Line 289: FND_MSG_PUB.initialize;

285: --+
286: -- Initialize message list if p_init_msg_list is set to TRUE.
287: -- +
288: IF FND_API.to_Boolean( p_init_msg_list ) THEN
289: FND_MSG_PUB.initialize;
290: END IF;
291: -- +
292: -- Initialize API return status to success
293: --+

Line 380: FND_MSG_PUB.Count_And_Get

376: END IF;
377: --+
378: -- Standard call to get message count and if count is 1, get message info.
379: --+
380: FND_MSG_PUB.Count_And_Get
381: (
382: p_count => x_msg_count ,
383: p_data => x_msg_data ,
384: p_encoded => FND_API.G_FALSE

Line 390: FND_MSG_PUB.Count_And_Get

386: EXCEPTION
387: WHEN FND_API.G_EXC_ERROR THEN
388: ROLLBACK TO Update_Trx_Factors;
389: x_return_status := FND_API.G_RET_STS_ERROR ;
390: FND_MSG_PUB.Count_And_Get
391: (
392: p_count => x_msg_count ,
393: p_data => x_msg_data ,
394: p_encoded => FND_API.G_FALSE

Line 400: FND_MSG_PUB.Count_And_Get

396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO Update_Trx_Factors;
398: x_loading_status := 'UNEXPECTED_ERR';
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: FND_MSG_PUB.Count_And_Get
401: (
402: p_count => x_msg_count ,
403: p_data => x_msg_data ,
404: p_encoded => FND_API.G_FALSE

Line 410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

406: WHEN OTHERS THEN
407: ROLLBACK TO Update_Trx_Factors;
408: x_loading_status := 'UNEXPECTED_ERR';
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
411: THEN
412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
413: END IF;
414: FND_MSG_PUB.Count_And_Get

Line 412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

408: x_loading_status := 'UNEXPECTED_ERR';
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
411: THEN
412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
413: END IF;
414: FND_MSG_PUB.Count_And_Get
415: (
416: p_count => x_msg_count ,

Line 414: FND_MSG_PUB.Count_And_Get

410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
411: THEN
412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
413: END IF;
414: FND_MSG_PUB.Count_And_Get
415: (
416: p_count => x_msg_count ,
417: p_data => x_msg_data ,
418: p_encoded => FND_API.G_FALSE