DBA Data[Home] [Help]

APPS.CN_CREDIT_TYPE_CONV_PVT dependencies on FND_MSG_PUB

Line 77: FND_MSG_PUB.initialize;

73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF FND_API.to_Boolean( p_init_msg_list ) THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79: -- Initialize API return status to success
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: -- API body

Line 92: fnd_msg_pub.ADD;

88: FOR eachrow in l_similar_conv_csr LOOP
89: IF (cn_api.date_range_overlap(p_start_date, p_end_date,
90: eachrow.start_date, eachrow.end_date)) THEN
91: fnd_message.set_name('CN', 'CN_CTC_DATE_OVERLAP');
92: fnd_msg_pub.ADD;
93: RAISE fnd_api.g_exc_error;
94: END IF;
95: END LOOP;
96:

Line 99: fnd_msg_pub.ADD;

95: END LOOP;
96:
97: if (p_from_credit_type = p_to_credit_type) then
98: fnd_message.set_name('CN', 'CN_CTC_SAME_ERR');
99: fnd_msg_pub.ADD;
100: RAISE fnd_api.g_exc_error;
101: end if;
102:
103: IF (p_conv_factor < 0) THEN

Line 105: fnd_msg_pub.ADD;

101: end if;
102:
103: IF (p_conv_factor < 0) THEN
104: fnd_message.set_name('CN', 'CN_CTC_NEG_CONV_ERR');
105: fnd_msg_pub.ADD;
106: RAISE fnd_api.g_exc_error;
107: END IF;
108:
109: SELECT cn_credit_conv_fcts_s.nextval

Line 132: FND_MSG_PUB.Count_And_Get

128: IF FND_API.To_Boolean( p_commit ) THEN
129: COMMIT WORK;
130: END IF;
131: -- Standard call to get message count and if count is 1, get message info.
132: FND_MSG_PUB.Count_And_Get
133: (p_count => x_msg_count ,
134: p_data => x_msg_data ,
135: p_encoded => FND_API.G_FALSE );
136: EXCEPTION

Line 140: FND_MSG_PUB.Count_And_Get

136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: ROLLBACK TO create_conversion_pvt;
139: x_return_status := FND_API.G_RET_STS_ERROR ;
140: FND_MSG_PUB.Count_And_Get
141: (p_count => x_msg_count ,
142: p_data => x_msg_data ,
143: p_encoded => FND_API.G_FALSE );
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 147: FND_MSG_PUB.Count_And_Get

143: p_encoded => FND_API.G_FALSE );
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: ROLLBACK TO create_conversion_pvt;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147: FND_MSG_PUB.Count_And_Get
148: (p_count => x_msg_count ,
149: p_data => x_msg_data ,
150: p_encoded => FND_API.G_FALSE );
151: WHEN OTHERS THEN

Line 154: IF FND_MSG_PUB.Check_Msg_Level

150: p_encoded => FND_API.G_FALSE );
151: WHEN OTHERS THEN
152: ROLLBACK TO create_conversion_pvt;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: IF FND_MSG_PUB.Check_Msg_Level
155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: FND_MSG_PUB.Add_Exc_Msg
158: (G_PKG_NAME ,

Line 155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

151: WHEN OTHERS THEN
152: ROLLBACK TO create_conversion_pvt;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: IF FND_MSG_PUB.Check_Msg_Level
155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: FND_MSG_PUB.Add_Exc_Msg
158: (G_PKG_NAME ,
159: l_api_name );

Line 157: FND_MSG_PUB.Add_Exc_Msg

153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: IF FND_MSG_PUB.Check_Msg_Level
155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: FND_MSG_PUB.Add_Exc_Msg
158: (G_PKG_NAME ,
159: l_api_name );
160: END IF;
161: FND_MSG_PUB.Count_And_Get

Line 161: FND_MSG_PUB.Count_And_Get

157: FND_MSG_PUB.Add_Exc_Msg
158: (G_PKG_NAME ,
159: l_api_name );
160: END IF;
161: FND_MSG_PUB.Count_And_Get
162: (p_count => x_msg_count ,
163: p_data => x_msg_data ,
164: p_encoded => FND_API.G_FALSE );
165: END Create_Conversion;

Line 258: FND_MSG_PUB.initialize;

254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: IF FND_API.to_Boolean( p_init_msg_list ) THEN
258: FND_MSG_PUB.initialize;
259: END IF;
260: -- Initialize API return status to success
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262: -- API body

Line 269: fnd_msg_pub.ADD;

265: close l_ovn_csr;
266:
267: IF (l_object_version <> p_object_version) THEN
268: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
269: fnd_msg_pub.ADD;
270: RAISE fnd_api.g_exc_error;
271: END IF;
272:
273: IF (cn_api.invalid_date_range(p_start_date, p_end_date,

Line 283: fnd_msg_pub.ADD;

279: FOR eachrow in l_similar_conv_csr LOOP
280: IF (cn_api.date_range_overlap(p_start_date, p_end_date,
281: eachrow.start_date, eachrow.end_date)) THEN
282: fnd_message.set_name('CN', 'CN_CTC_DATE_OVERLAP');
283: fnd_msg_pub.ADD;
284: RAISE fnd_api.g_exc_error;
285: END IF;
286: END LOOP;
287:

Line 290: fnd_msg_pub.ADD;

286: END LOOP;
287:
288: if (p_from_credit_type = p_to_credit_type) then
289: fnd_message.set_name('CN', 'CN_CTC_SAME_ERR');
290: fnd_msg_pub.ADD;
291: RAISE fnd_api.g_exc_error;
292: end if;
293:
294: IF (p_conv_factor < 0) THEN

Line 296: fnd_msg_pub.ADD;

292: end if;
293:
294: IF (p_conv_factor < 0) THEN
295: fnd_message.set_name('CN', 'CN_CTC_NEG_CONV_ERR');
296: fnd_msg_pub.ADD;
297: RAISE fnd_api.g_exc_error;
298: END IF;
299:
300: CN_CREDIT_CONV_FCTS_PKG.Update_Row(

Line 319: FND_MSG_PUB.Count_And_Get

315: IF FND_API.To_Boolean( p_commit ) THEN
316: COMMIT WORK;
317: END IF;
318: -- Standard call to get message count and if count is 1, get message info.
319: FND_MSG_PUB.Count_And_Get
320: (p_count => x_msg_count ,
321: p_data => x_msg_data ,
322: p_encoded => FND_API.G_FALSE );
323: EXCEPTION

Line 327: FND_MSG_PUB.Count_And_Get

323: EXCEPTION
324: WHEN FND_API.G_EXC_ERROR THEN
325: ROLLBACK TO update_conversion_pvt;
326: x_return_status := FND_API.G_RET_STS_ERROR ;
327: FND_MSG_PUB.Count_And_Get
328: (p_count => x_msg_count ,
329: p_data => x_msg_data ,
330: p_encoded => FND_API.G_FALSE );
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 334: FND_MSG_PUB.Count_And_Get

330: p_encoded => FND_API.G_FALSE );
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: ROLLBACK TO update_conversion_pvt;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: FND_MSG_PUB.Count_And_Get
335: (p_count => x_msg_count ,
336: p_data => x_msg_data ,
337: p_encoded => FND_API.G_FALSE );
338: WHEN OTHERS THEN

Line 341: IF FND_MSG_PUB.Check_Msg_Level

337: p_encoded => FND_API.G_FALSE );
338: WHEN OTHERS THEN
339: ROLLBACK TO update_conversion_pvt;
340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
341: IF FND_MSG_PUB.Check_Msg_Level
342: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
343: THEN
344: FND_MSG_PUB.Add_Exc_Msg
345: (G_PKG_NAME ,

Line 342: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

338: WHEN OTHERS THEN
339: ROLLBACK TO update_conversion_pvt;
340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
341: IF FND_MSG_PUB.Check_Msg_Level
342: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
343: THEN
344: FND_MSG_PUB.Add_Exc_Msg
345: (G_PKG_NAME ,
346: l_api_name );

Line 344: FND_MSG_PUB.Add_Exc_Msg

340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
341: IF FND_MSG_PUB.Check_Msg_Level
342: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
343: THEN
344: FND_MSG_PUB.Add_Exc_Msg
345: (G_PKG_NAME ,
346: l_api_name );
347: END IF;
348: FND_MSG_PUB.Count_And_Get

Line 348: FND_MSG_PUB.Count_And_Get

344: FND_MSG_PUB.Add_Exc_Msg
345: (G_PKG_NAME ,
346: l_api_name );
347: END IF;
348: FND_MSG_PUB.Count_And_Get
349: (p_count => x_msg_count ,
350: p_data => x_msg_data ,
351: p_encoded => FND_API.G_FALSE );
352: END Update_Conversion;

Line 426: FND_MSG_PUB.initialize;

422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: END IF;
424: -- Initialize message list if p_init_msg_list is set to TRUE.
425: IF FND_API.to_Boolean( p_init_msg_list ) THEN
426: FND_MSG_PUB.initialize;
427: END IF;
428: -- Initialize API return status to success
429: x_return_status := FND_API.G_RET_STS_SUCCESS;
430: -- API body

Line 437: fnd_msg_pub.ADD;

433: close l_ovn_csr;
434:
435: IF (l_object_version <> p_object_version) THEN
436: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
437: fnd_msg_pub.ADD;
438: RAISE fnd_api.g_exc_error;
439: END IF;
440:
441: CN_CREDIT_CONV_FCTS_PKG.Delete_Row(x_credit_conv_fct_id => p_conv_id);

Line 449: FND_MSG_PUB.Count_And_Get

445: IF FND_API.To_Boolean( p_commit ) THEN
446: COMMIT WORK;
447: END IF;
448: -- Standard call to get message count and if count is 1, get message info.
449: FND_MSG_PUB.Count_And_Get
450: (p_count => x_msg_count ,
451: p_data => x_msg_data ,
452: p_encoded => FND_API.G_FALSE );
453: EXCEPTION

Line 457: FND_MSG_PUB.Count_And_Get

453: EXCEPTION
454: WHEN FND_API.G_EXC_ERROR THEN
455: ROLLBACK TO delete_conversion_pvt;
456: x_return_status := FND_API.G_RET_STS_ERROR ;
457: FND_MSG_PUB.Count_And_Get
458: (p_count => x_msg_count ,
459: p_data => x_msg_data ,
460: p_encoded => FND_API.G_FALSE );
461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 464: FND_MSG_PUB.Count_And_Get

460: p_encoded => FND_API.G_FALSE );
461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
462: ROLLBACK TO delete_conversion_pvt;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
464: FND_MSG_PUB.Count_And_Get
465: (p_count => x_msg_count ,
466: p_data => x_msg_data ,
467: p_encoded => FND_API.G_FALSE );
468: WHEN OTHERS THEN

Line 471: IF FND_MSG_PUB.Check_Msg_Level

467: p_encoded => FND_API.G_FALSE );
468: WHEN OTHERS THEN
469: ROLLBACK TO delete_conversion_pvt;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: IF FND_MSG_PUB.Check_Msg_Level
472: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg
475: (G_PKG_NAME ,

Line 472: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

468: WHEN OTHERS THEN
469: ROLLBACK TO delete_conversion_pvt;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: IF FND_MSG_PUB.Check_Msg_Level
472: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg
475: (G_PKG_NAME ,
476: l_api_name );

Line 474: FND_MSG_PUB.Add_Exc_Msg

470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: IF FND_MSG_PUB.Check_Msg_Level
472: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg
475: (G_PKG_NAME ,
476: l_api_name );
477: END IF;
478: FND_MSG_PUB.Count_And_Get

Line 478: FND_MSG_PUB.Count_And_Get

474: FND_MSG_PUB.Add_Exc_Msg
475: (G_PKG_NAME ,
476: l_api_name );
477: END IF;
478: FND_MSG_PUB.Count_And_Get
479: (p_count => x_msg_count ,
480: p_data => x_msg_data ,
481: p_encoded => FND_API.G_FALSE );
482: END Delete_Conversion;