DBA Data[Home] [Help]

APPS.CSI_PRICING_ATTRIBS_PUB dependencies on FND_MSG_PUB

Line 59: FND_MSG_PUB.initialize;

55:
56:
57: -- Initialize message list if p_init_msg_list is set to TRUE.
58: IF FND_API.to_Boolean( p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62:
63: -- Initialize API return status to success

Line 99: FND_MSG_PUB.ADD;

95: -- check if atleast one query parameters are passed
96: IF (p_pricing_attribs_query_rec.pricing_attribute_id = FND_API.G_MISS_NUM)
97: AND (p_pricing_attribs_query_rec.instance_id = FND_API.G_MISS_NUM) THEN
98: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
99: FND_MSG_PUB.ADD;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
102:
103:

Line 146: FND_MSG_PUB.ADD;

142: csi_pricing_attribs_pvt.Construct_pri_From_Hist(x_pricing_attribs_tbl, p_time_stamp);
143: ELSE
144: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
145: FND_MESSAGE.SET_TOKEN('TIME_STAMP',p_time_stamp);
146: FND_MSG_PUB.ADD;
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;
149: END IF;
150:

Line 169: FND_MSG_PUB.Count_And_Get

165: -- End disable trace
166: ****/
167:
168: -- Standard call to get message count and if count is get message info.
169: FND_MSG_PUB.Count_And_Get
170: (p_count => x_msg_count ,
171: p_data => x_msg_data
172: );
173:

Line 180: FND_MSG_PUB.Count_And_Get

176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: -- ROLLBACK TO get_pricing_attribs;
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: FND_MSG_PUB.Count_And_Get
181: ( p_count => x_msg_count,
182: p_data => x_msg_data
183: );
184:

Line 188: FND_MSG_PUB.Count_And_Get

184:
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: -- ROLLBACK TO get_pricing_attribs;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
188: FND_MSG_PUB.Count_And_Get
189: ( p_count => x_msg_count,
190: p_data => x_msg_data
191: );
192:

Line 201: IF FND_MSG_PUB.Check_Msg_Level

197:
198: -- ROLLBACK TO get_pricing_attribs;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200:
201: IF FND_MSG_PUB.Check_Msg_Level
202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: FND_MSG_PUB.Add_Exc_Msg
205: ( g_pkg_name ,

Line 202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

198: -- ROLLBACK TO get_pricing_attribs;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200:
201: IF FND_MSG_PUB.Check_Msg_Level
202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: FND_MSG_PUB.Add_Exc_Msg
205: ( g_pkg_name ,
206: l_api_name

Line 204: FND_MSG_PUB.Add_Exc_Msg

200:
201: IF FND_MSG_PUB.Check_Msg_Level
202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: FND_MSG_PUB.Add_Exc_Msg
205: ( g_pkg_name ,
206: l_api_name
207: );
208: END IF;

Line 210: FND_MSG_PUB.Count_And_Get

206: l_api_name
207: );
208: END IF;
209:
210: FND_MSG_PUB.Count_And_Get
211: ( p_count => x_msg_count,
212: p_data => x_msg_data
213: );
214:

Line 267: FND_MSG_PUB.initialize;

263:
264:
265: -- Initialize message list if p_init_msg_list is set to TRUE.
266: IF FND_API.to_Boolean( p_init_msg_list ) THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269:
270:
271: -- Initialize API return status to success

Line 326: x_msg_data := FND_MSG_PUB.GET

322: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
323: l_msg_index := 1;
324: l_msg_count := x_msg_count;
325: WHILE l_msg_count > 0 LOOP
326: x_msg_data := FND_MSG_PUB.GET
327: ( l_msg_index,
328: FND_API.G_FALSE );
329:
330: csi_gen_utility_pvt.put_line( ' Failed Pub:create_pricing_attribs..');

Line 358: FND_MSG_PUB.Count_And_Get

354: -- End disable trace
355: ****/
356:
357: -- Standard call to get message count and if count is get message info.
358: FND_MSG_PUB.Count_And_Get
359: (p_count => x_msg_count ,
360: p_data => x_msg_data
361: );
362:

Line 369: FND_MSG_PUB.Count_And_Get

365:
366: WHEN FND_API.G_EXC_ERROR THEN
367: ROLLBACK TO create_pricing_attribs;
368: x_return_status := FND_API.G_RET_STS_ERROR ;
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count,
371: p_data => x_msg_data
372: );
373:

Line 377: FND_MSG_PUB.Count_And_Get

373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: ROLLBACK TO create_pricing_attribs;
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
377: FND_MSG_PUB.Count_And_Get
378: ( p_count => x_msg_count,
379: p_data => x_msg_data
380: );
381:

Line 386: IF FND_MSG_PUB.Check_Msg_Level

382: WHEN OTHERS THEN
383: ROLLBACK TO create_pricing_attribs;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385:
386: IF FND_MSG_PUB.Check_Msg_Level
387: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
388: THEN
389: FND_MSG_PUB.Add_Exc_Msg
390: ( g_pkg_name,

Line 387: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

383: ROLLBACK TO create_pricing_attribs;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385:
386: IF FND_MSG_PUB.Check_Msg_Level
387: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
388: THEN
389: FND_MSG_PUB.Add_Exc_Msg
390: ( g_pkg_name,
391: l_api_name

Line 389: FND_MSG_PUB.Add_Exc_Msg

385:
386: IF FND_MSG_PUB.Check_Msg_Level
387: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
388: THEN
389: FND_MSG_PUB.Add_Exc_Msg
390: ( g_pkg_name,
391: l_api_name
392: );
393: END IF;

Line 395: FND_MSG_PUB.Count_And_Get

391: l_api_name
392: );
393: END IF;
394:
395: FND_MSG_PUB.Count_And_Get
396: ( p_count => x_msg_count,
397: p_data => x_msg_data
398: );
399:

Line 454: FND_MSG_PUB.initialize;

450:
451:
452: -- Initialize message list if p_init_msg_list is set to TRUE.
453: IF FND_API.to_Boolean( p_init_msg_list ) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456:
457:
458: -- Initialize API return status to success

Line 512: x_msg_data := FND_MSG_PUB.GET

508: l_msg_index := 1;
509:
510: l_msg_count := x_msg_count;
511: WHILE l_msg_count > 0 LOOP
512: x_msg_data := FND_MSG_PUB.GET
513: (l_msg_index,
514: FND_API.G_FALSE );
515:
516: csi_gen_utility_pvt.put_line( ' Failed Pub:update_pricing_attribs..');

Line 544: FND_MSG_PUB.Count_And_Get

540: -- End disable trace
541: ****/
542:
543: -- Standard call to get message count and if count is get message info.
544: FND_MSG_PUB.Count_And_Get
545: (p_count => x_msg_count ,
546: p_data => x_msg_data
547: );
548:

Line 554: FND_MSG_PUB.Count_And_Get

550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN
552: ROLLBACK TO update_pricing_attribs;
553: x_return_status := FND_API.G_RET_STS_ERROR ;
554: FND_MSG_PUB.Count_And_Get
555: ( p_count => x_msg_count,
556: p_data => x_msg_data
557: );
558:

Line 562: FND_MSG_PUB.Count_And_Get

558:
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: ROLLBACK TO update_pricing_attribs;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
562: FND_MSG_PUB.Count_And_Get
563: ( p_count => x_msg_count,
564: p_data => x_msg_data
565: );
566:

Line 571: IF FND_MSG_PUB.Check_Msg_Level

567: WHEN OTHERS THEN
568: ROLLBACK TO update_pricing_attribs;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570:
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg
575: ( g_pkg_name,

Line 572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

568: ROLLBACK TO update_pricing_attribs;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570:
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg
575: ( g_pkg_name,
576: l_api_name

Line 574: FND_MSG_PUB.Add_Exc_Msg

570:
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg
575: ( g_pkg_name,
576: l_api_name
577: );
578: END IF;

Line 580: FND_MSG_PUB.Count_And_Get

576: l_api_name
577: );
578: END IF;
579:
580: FND_MSG_PUB.Count_And_Get
581: ( p_count => x_msg_count,
582: p_data => x_msg_data
583: );
584:

Line 638: FND_MSG_PUB.initialize;

634:
635:
636: -- Initialize message list if p_init_msg_list is set to TRUE.
637: IF FND_API.to_Boolean( p_init_msg_list ) THEN
638: FND_MSG_PUB.initialize;
639: END IF;
640:
641:
642: -- Initialize API return status to success

Line 696: x_msg_data := FND_MSG_PUB.GET

692: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
693: l_msg_index := 1;
694: l_msg_count := x_msg_count;
695: WHILE l_msg_count > 0 LOOP
696: x_msg_data := FND_MSG_PUB.GET
697: (l_msg_index,
698: FND_API.G_FALSE );
699:
700: csi_gen_utility_pvt.put_line( ' Failed Pub:expire_pricing_attribs..');

Line 729: FND_MSG_PUB.Count_And_Get

725: -- End disable trace
726: ****/
727:
728: -- Standard call to get message count and if count is get message info.
729: FND_MSG_PUB.Count_And_Get
730: (p_count => x_msg_count ,
731: p_data => x_msg_data
732: );
733:

Line 741: FND_MSG_PUB.Count_And_Get

737: WHEN FND_API.G_EXC_ERROR THEN
738:
739: ROLLBACK TO expire_pricing_attribs;
740: x_return_status := FND_API.G_RET_STS_ERROR ;
741: FND_MSG_PUB.Count_And_Get
742: ( p_count => x_msg_count,
743: p_data => x_msg_data
744: );
745:

Line 750: FND_MSG_PUB.Count_And_Get

746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
747:
748: ROLLBACK TO expire_pricing_attribs;
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
750: FND_MSG_PUB.Count_And_Get
751: ( p_count => x_msg_count,
752: p_data => x_msg_data
753: );
754:

Line 760: IF FND_MSG_PUB.Check_Msg_Level

756:
757: ROLLBACK TO expire_pricing_attribs;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759:
760: IF FND_MSG_PUB.Check_Msg_Level
761: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
762: THEN
763: FND_MSG_PUB.Add_Exc_Msg
764: ( g_pkg_name,

Line 761: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

757: ROLLBACK TO expire_pricing_attribs;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759:
760: IF FND_MSG_PUB.Check_Msg_Level
761: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
762: THEN
763: FND_MSG_PUB.Add_Exc_Msg
764: ( g_pkg_name,
765: l_api_name

Line 763: FND_MSG_PUB.Add_Exc_Msg

759:
760: IF FND_MSG_PUB.Check_Msg_Level
761: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
762: THEN
763: FND_MSG_PUB.Add_Exc_Msg
764: ( g_pkg_name,
765: l_api_name
766: );
767: END IF;

Line 769: FND_MSG_PUB.Count_And_Get

765: l_api_name
766: );
767: END IF;
768:
769: FND_MSG_PUB.Count_And_Get
770: ( p_count => x_msg_count,
771: p_data => x_msg_data
772: );
773: