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.IEM_CLASSIFICATIONS_PVT dependencies on FND_MSG_PUB

Line 95: FND_MSG_PUB.initialize;

91:
92: -- Initialize message list if p_init_msg_list is set to TRUE.
93: IF FND_API.to_Boolean( p_init_msg_list )
94: THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97:
98: -- Initialize API return status to SUCCESS
99: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 166: FND_MSG_PUB.Count_And_Get

162: IF FND_API.To_Boolean(p_commit) THEN
163: COMMIT WORK;
164: END IF;
165: -- Standard callto get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get
167: ( p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170: EXCEPTION

Line 174: FND_MSG_PUB.Count_And_Get

170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: ROLLBACK TO create_item_PVT;
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: FND_MSG_PUB.Count_And_Get
175: ( p_count => x_msg_count,
176: p_data => x_msg_data
177: );
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 181: FND_MSG_PUB.Count_And_Get

177: );
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179: ROLLBACK TO update_item_PVT;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: FND_MSG_PUB.Count_And_Get
182: ( p_count => x_msg_count,
183: p_data => x_msg_data
184: );
185: WHEN OTHERS THEN

Line 188: IF FND_MSG_PUB.Check_Msg_Level

184: );
185: WHEN OTHERS THEN
186: ROLLBACK TO create_item_PVT;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: IF FND_MSG_PUB.Check_Msg_Level
189: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
190: THEN
191: FND_MSG_PUB.Add_Exc_Msg
192: ( G_PKG_NAME ,

Line 189: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

185: WHEN OTHERS THEN
186: ROLLBACK TO create_item_PVT;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: IF FND_MSG_PUB.Check_Msg_Level
189: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
190: THEN
191: FND_MSG_PUB.Add_Exc_Msg
192: ( G_PKG_NAME ,
193: l_api_name

Line 191: FND_MSG_PUB.Add_Exc_Msg

187: x_return_status := FND_API.G_RET_STS_ERROR;
188: IF FND_MSG_PUB.Check_Msg_Level
189: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
190: THEN
191: FND_MSG_PUB.Add_Exc_Msg
192: ( G_PKG_NAME ,
193: l_api_name
194: );
195: END IF;

Line 196: FND_MSG_PUB.Count_And_Get

192: ( G_PKG_NAME ,
193: l_api_name
194: );
195: END IF;
196: FND_MSG_PUB.Count_And_Get
197: ( p_count => x_msg_count ,
198: p_data => x_msg_data
199: );
200:

Line 255: FND_MSG_PUB.initialize;

251: END IF;
252: -- Initialize message list if p_init_msg_list is set to TRUE.
253: IF FND_API.to_Boolean( p_init_msg_list )
254: THEN
255: FND_MSG_PUB.initialize;
256: END IF;
257: -- Initialize API return status to SUCCESS
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259: IF p_classification_id IS NOT NULL THEN

Line 275: FND_MSG_PUB.Count_And_Get

271: IF FND_API.To_Boolean(p_commit) THEN
272: COMMIT WORK;
273: END IF;
274: -- Standard callto get message count and if count is 1, get message info.
275: FND_MSG_PUB.Count_And_Get
276: ( p_count => x_msg_count,
277: p_data => x_msg_data
278: );
279: EXCEPTION

Line 283: FND_MSG_PUB.Count_And_Get

279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: ROLLBACK TO delete_item_PVT;
282: x_return_status := FND_API.G_RET_STS_ERROR ;
283: FND_MSG_PUB.Count_And_Get
284: ( p_count => x_msg_count,
285: p_data => x_msg_data
286: );
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 290: FND_MSG_PUB.Count_And_Get

286: );
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: ROLLBACK TO delete_item_PVT;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
290: FND_MSG_PUB.Count_And_Get
291: ( p_count => x_msg_count,
292: p_data => x_msg_data
293: );
294: WHEN OTHERS THEN

Line 297: IF FND_MSG_PUB.Check_Msg_Level

293: );
294: WHEN OTHERS THEN
295: ROLLBACK TO delete_item_PVT;
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: IF FND_MSG_PUB.Check_Msg_Level
298: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
299: THEN
300: FND_MSG_PUB.Add_Exc_Msg
301: ( G_PKG_NAME ,

Line 298: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

294: WHEN OTHERS THEN
295: ROLLBACK TO delete_item_PVT;
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: IF FND_MSG_PUB.Check_Msg_Level
298: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
299: THEN
300: FND_MSG_PUB.Add_Exc_Msg
301: ( G_PKG_NAME ,
302: l_api_name

Line 300: FND_MSG_PUB.Add_Exc_Msg

296: x_return_status := FND_API.G_RET_STS_ERROR;
297: IF FND_MSG_PUB.Check_Msg_Level
298: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
299: THEN
300: FND_MSG_PUB.Add_Exc_Msg
301: ( G_PKG_NAME ,
302: l_api_name
303: );
304: END IF;

Line 305: FND_MSG_PUB.Count_And_Get

301: ( G_PKG_NAME ,
302: l_api_name
303: );
304: END IF;
305: FND_MSG_PUB.Count_And_Get
306: ( p_count => x_msg_count ,
307: p_data => x_msg_data
308: );
309:

Line 388: FND_MSG_PUB.initialize;

384: END IF;
385: -- Initialize message list if p_init_msg_list is set to TRUE.
386: IF FND_API.to_Boolean( p_init_msg_list )
387: THEN
388: FND_MSG_PUB.initialize;
389: END IF;
390: -- Initialize API return status to SUCCESS
391: x_return_status := FND_API.G_RET_STS_SUCCESS;
392: UPDATE IEM_CLASSIFICATIONS

Line 420: FND_MSG_PUB.Count_And_Get

416: IF FND_API.To_Boolean(p_commit) THEN
417: COMMIT WORK;
418: END IF;
419: -- Standard callto get message count and if count is 1, get message info.
420: FND_MSG_PUB.Count_And_Get
421: ( p_count => x_msg_count,
422: p_data => x_msg_data
423: );
424: EXCEPTION

Line 428: FND_MSG_PUB.Count_And_Get

424: EXCEPTION
425: WHEN FND_API.G_EXC_ERROR THEN
426: ROLLBACK TO update_item_PVT;
427: x_return_status := FND_API.G_RET_STS_ERROR ;
428: FND_MSG_PUB.Count_And_Get
429: ( p_count => x_msg_count,
430: p_data => x_msg_data
431: );
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 435: FND_MSG_PUB.Count_And_Get

431: );
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO update_item_PVT;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
435: FND_MSG_PUB.Count_And_Get
436: ( p_count => x_msg_count,
437: p_data => x_msg_data
438: );
439: WHEN IEM_DUPLICATE_CLASS THEN

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

439: WHEN IEM_DUPLICATE_CLASS THEN
440: ROLLBACK TO update_item_PVT;
441: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_CLASSIFICATION');
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
444: THEN
445: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
446: END IF;
447: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

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

441: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_CLASSIFICATION');
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
444: THEN
445: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
446: END IF;
447: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
448: WHEN OTHERS THEN
449: ROLLBACK TO update_item_PVT;

Line 447: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
444: THEN
445: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
446: END IF;
447: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
448: WHEN OTHERS THEN
449: ROLLBACK TO update_item_PVT;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: IF FND_MSG_PUB.Check_Msg_Level

Line 451: IF FND_MSG_PUB.Check_Msg_Level

447: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
448: WHEN OTHERS THEN
449: ROLLBACK TO update_item_PVT;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: IF FND_MSG_PUB.Check_Msg_Level
452: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg
455: ( G_PKG_NAME ,

Line 452: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

448: WHEN OTHERS THEN
449: ROLLBACK TO update_item_PVT;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: IF FND_MSG_PUB.Check_Msg_Level
452: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg
455: ( G_PKG_NAME ,
456: l_api_name

Line 454: FND_MSG_PUB.Add_Exc_Msg

450: x_return_status := FND_API.G_RET_STS_ERROR;
451: IF FND_MSG_PUB.Check_Msg_Level
452: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg
455: ( G_PKG_NAME ,
456: l_api_name
457: );
458: END IF;

Line 459: FND_MSG_PUB.Count_And_Get

455: ( G_PKG_NAME ,
456: l_api_name
457: );
458: END IF;
459: FND_MSG_PUB.Count_And_Get
460: ( p_count => x_msg_count ,
461: p_data => x_msg_data
462: );
463: END;

Line 501: FND_MSG_PUB.initialize;

497: END IF;
498:
499: IF FND_API.to_Boolean( p_init_msg_list )
500: THEN
501: FND_MSG_PUB.initialize;
502: END IF;
503:
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:

Line 561: FND_MSG_PUB.Count_And_Get

557: IF FND_API.To_Boolean(p_commit) THEN
558: COMMIT WORK;
559: END IF;
560:
561: FND_MSG_PUB.Count_And_Get
562: ( p_count => x_msg_count,
563: p_data => x_msg_data
564: );
565: EXCEPTION

Line 569: FND_MSG_PUB.Add;

565: EXCEPTION
566: WHEN IEM_DUP_CLASS THEN
567: ROLLBACK TO create_item_jsp;
568: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_CLASSIFICATION');
569: FND_MSG_PUB.Add;
570: x_return_status := FND_API.G_RET_STS_ERROR ;
571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
572:
573: WHEN FND_API.G_EXC_ERROR THEN

Line 571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

567: ROLLBACK TO create_item_jsp;
568: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_CLASSIFICATION');
569: FND_MSG_PUB.Add;
570: x_return_status := FND_API.G_RET_STS_ERROR ;
571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
572:
573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO create_item_jsp;
575: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 576: FND_MSG_PUB.Count_And_Get

572:
573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO create_item_jsp;
575: x_return_status := FND_API.G_RET_STS_ERROR ;
576: FND_MSG_PUB.Count_And_Get
577: ( p_count => x_msg_count,
578: p_data => x_msg_data
579: );
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 583: FND_MSG_PUB.Count_And_Get

579: );
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: ROLLBACK TO create_item_jsp;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
583: FND_MSG_PUB.Count_And_Get
584: ( p_count => x_msg_count,
585: p_data => x_msg_data
586: );
587: WHEN OTHERS THEN

Line 590: IF FND_MSG_PUB.Check_Msg_Level

586: );
587: WHEN OTHERS THEN
588: ROLLBACK TO create_item_jsp;
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: IF FND_MSG_PUB.Check_Msg_Level
591: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg
594: ( G_PKG_NAME ,

Line 591: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

587: WHEN OTHERS THEN
588: ROLLBACK TO create_item_jsp;
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: IF FND_MSG_PUB.Check_Msg_Level
591: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg
594: ( G_PKG_NAME ,
595: l_api_name

Line 593: FND_MSG_PUB.Add_Exc_Msg

589: x_return_status := FND_API.G_RET_STS_ERROR;
590: IF FND_MSG_PUB.Check_Msg_Level
591: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg
594: ( G_PKG_NAME ,
595: l_api_name
596: );
597: END IF;

Line 598: FND_MSG_PUB.Count_And_Get

594: ( G_PKG_NAME ,
595: l_api_name
596: );
597: END IF;
598: FND_MSG_PUB.Count_And_Get
599: ( p_count => x_msg_count ,
600: p_data => x_msg_data
601: );
602:

Line 640: FND_MSG_PUB.initialize;

636: END IF;
637:
638: IF FND_API.to_Boolean( p_init_msg_list )
639: THEN
640: FND_MSG_PUB.initialize;
641: END IF;
642:
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644:

Line 700: FND_MSG_PUB.Count_And_Get

696: IF FND_API.To_Boolean(p_commit) THEN
697: COMMIT WORK;
698: END IF;
699:
700: FND_MSG_PUB.Count_And_Get
701: ( p_count => x_msg_count,
702: p_data => x_msg_data
703: );
704: EXCEPTION

Line 708: FND_MSG_PUB.Add;

704: EXCEPTION
705: WHEN IEM_DUP_CLASS THEN
706: ROLLBACK TO create_item_jsp;
707: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_INTENT');
708: FND_MSG_PUB.Add;
709: x_return_status := FND_API.G_RET_STS_ERROR ;
710: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
711:
712: WHEN FND_API.G_EXC_ERROR THEN

Line 710: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

706: ROLLBACK TO create_item_jsp;
707: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_INTENT');
708: FND_MSG_PUB.Add;
709: x_return_status := FND_API.G_RET_STS_ERROR ;
710: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
711:
712: WHEN FND_API.G_EXC_ERROR THEN
713: ROLLBACK TO create_item_jsp;
714: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 715: FND_MSG_PUB.Count_And_Get

711:
712: WHEN FND_API.G_EXC_ERROR THEN
713: ROLLBACK TO create_item_jsp;
714: x_return_status := FND_API.G_RET_STS_ERROR ;
715: FND_MSG_PUB.Count_And_Get
716: ( p_count => x_msg_count,
717: p_data => x_msg_data
718: );
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 722: FND_MSG_PUB.Count_And_Get

718: );
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO create_item_jsp;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
722: FND_MSG_PUB.Count_And_Get
723: ( p_count => x_msg_count,
724: p_data => x_msg_data
725: );
726: WHEN OTHERS THEN

Line 729: IF FND_MSG_PUB.Check_Msg_Level

725: );
726: WHEN OTHERS THEN
727: ROLLBACK TO create_item_jsp;
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: IF FND_MSG_PUB.Check_Msg_Level
730: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
731: THEN
732: FND_MSG_PUB.Add_Exc_Msg
733: ( G_PKG_NAME ,

Line 730: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

726: WHEN OTHERS THEN
727: ROLLBACK TO create_item_jsp;
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: IF FND_MSG_PUB.Check_Msg_Level
730: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
731: THEN
732: FND_MSG_PUB.Add_Exc_Msg
733: ( G_PKG_NAME ,
734: l_api_name

Line 732: FND_MSG_PUB.Add_Exc_Msg

728: x_return_status := FND_API.G_RET_STS_ERROR;
729: IF FND_MSG_PUB.Check_Msg_Level
730: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
731: THEN
732: FND_MSG_PUB.Add_Exc_Msg
733: ( G_PKG_NAME ,
734: l_api_name
735: );
736: END IF;

Line 737: FND_MSG_PUB.Count_And_Get

733: ( G_PKG_NAME ,
734: l_api_name
735: );
736: END IF;
737: FND_MSG_PUB.Count_And_Get
738: ( p_count => x_msg_count ,
739: p_data => x_msg_data
740: );
741:

Line 771: FND_MSG_PUB.initialize;

767: END IF;
768:
769: --Initialize the message list if p_init_msg_list is set to TRUE
770: If FND_API.to_Boolean(p_init_msg_list) THEN
771: FND_MSG_PUB.initialize;
772: END IF;
773:
774: --Initialize API status return
775: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 790: FND_MSG_PUB.ADD;

786: END LOOP;
787:
788: IF SQL%NOTFOUND THEN
789: FND_MESSAGE.SET_NAME('IEM', 'IEM_EXP_INVALID_ACCOUNT');
790: FND_MSG_PUB.ADD;
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:
794: --Standard check of p_commit

Line 800: FND_MSG_PUB.Count_And_Get

796: COMMIT WORK;
797: END IF;
798:
799: -- Standard callto get message count and if count is 1, get message info.
800: FND_MSG_PUB.Count_And_Get
801: ( p_count => x_msg_count,
802: p_data => x_msg_data
803: );
804: EXCEPTION

Line 808: FND_MSG_PUB.Count_And_Get

804: EXCEPTION
805: WHEN FND_API.G_EXC_ERROR THEN
806: ROLLBACK TO delete_item_wrap;
807: x_return_status := FND_API.G_RET_STS_ERROR ;
808: FND_MSG_PUB.Count_And_Get
809: ( p_count => x_msg_count,
810: p_data => x_msg_data
811: );
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 815: FND_MSG_PUB.Count_And_Get

811: );
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813: ROLLBACK TO delete_item_wrap;
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
815: FND_MSG_PUB.Count_And_Get
816: ( p_count => x_msg_count,
817: p_data => x_msg_data
818: );
819: WHEN OTHERS THEN

Line 822: IF FND_MSG_PUB.Check_Msg_Level

818: );
819: WHEN OTHERS THEN
820: ROLLBACK TO delete_item_wrap;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: IF FND_MSG_PUB.Check_Msg_Level
823: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
824: THEN
825: FND_MSG_PUB.Add_Exc_Msg
826: ( G_PKG_NAME ,

Line 823: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

819: WHEN OTHERS THEN
820: ROLLBACK TO delete_item_wrap;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: IF FND_MSG_PUB.Check_Msg_Level
823: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
824: THEN
825: FND_MSG_PUB.Add_Exc_Msg
826: ( G_PKG_NAME ,
827: l_api_name

Line 825: FND_MSG_PUB.Add_Exc_Msg

821: x_return_status := FND_API.G_RET_STS_ERROR;
822: IF FND_MSG_PUB.Check_Msg_Level
823: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
824: THEN
825: FND_MSG_PUB.Add_Exc_Msg
826: ( G_PKG_NAME ,
827: l_api_name
828: );
829: END IF;

Line 830: FND_MSG_PUB.Count_And_Get

826: ( G_PKG_NAME ,
827: l_api_name
828: );
829: END IF;
830: FND_MSG_PUB.Count_And_Get
831: ( p_count => x_msg_count ,
832: p_data => x_msg_data
833: );
834: --Standard call to get message count and message info

Line 835: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

831: ( p_count => x_msg_count ,
832: p_data => x_msg_data
833: );
834: --Standard call to get message count and message info
835: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
836: p_data => x_msg_data);
837: END delete_item_wrap;
838: PROCEDURE delete_item_wrap_sss
839: (p_api_version_number IN NUMBER,

Line 868: FND_MSG_PUB.initialize;

864: END IF;
865:
866: --Initialize the message list if p_init_msg_list is set to TRUE
867: If FND_API.to_Boolean(p_init_msg_list) THEN
868: FND_MSG_PUB.initialize;
869: END IF;
870:
871: --Initialize API status return
872: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 910: FND_MSG_PUB.Count_And_Get

906: COMMIT WORK;
907: END IF;
908:
909: -- Standard callto get message count and if count is 1, get message info.
910: FND_MSG_PUB.Count_And_Get
911: ( p_count => x_msg_count,
912: p_data => x_msg_data
913: );
914: EXCEPTION

Line 918: FND_MSG_PUB.Count_And_Get

914: EXCEPTION
915: WHEN FND_API.G_EXC_ERROR THEN
916: ROLLBACK TO delete_item_wrap;
917: x_return_status := FND_API.G_RET_STS_ERROR ;
918: FND_MSG_PUB.Count_And_Get
919: ( p_count => x_msg_count,
920: p_data => x_msg_data
921: );
922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 925: FND_MSG_PUB.Count_And_Get

921: );
922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
923: ROLLBACK TO delete_item_wrap;
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: FND_MSG_PUB.Count_And_Get
926: ( p_count => x_msg_count,
927: p_data => x_msg_data
928: );
929: WHEN OTHERS THEN

Line 932: IF FND_MSG_PUB.Check_Msg_Level

928: );
929: WHEN OTHERS THEN
930: ROLLBACK TO delete_item_wrap;
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: IF FND_MSG_PUB.Check_Msg_Level
933: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
934: THEN
935: FND_MSG_PUB.Add_Exc_Msg
936: ( G_PKG_NAME ,

Line 933: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

929: WHEN OTHERS THEN
930: ROLLBACK TO delete_item_wrap;
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: IF FND_MSG_PUB.Check_Msg_Level
933: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
934: THEN
935: FND_MSG_PUB.Add_Exc_Msg
936: ( G_PKG_NAME ,
937: l_api_name

Line 935: FND_MSG_PUB.Add_Exc_Msg

931: x_return_status := FND_API.G_RET_STS_ERROR;
932: IF FND_MSG_PUB.Check_Msg_Level
933: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
934: THEN
935: FND_MSG_PUB.Add_Exc_Msg
936: ( G_PKG_NAME ,
937: l_api_name
938: );
939: END IF;

Line 940: FND_MSG_PUB.Count_And_Get

936: ( G_PKG_NAME ,
937: l_api_name
938: );
939: END IF;
940: FND_MSG_PUB.Count_And_Get
941: ( p_count => x_msg_count ,
942: p_data => x_msg_data
943: );
944: --Standard call to get message count and message info

Line 945: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

941: ( p_count => x_msg_count ,
942: p_data => x_msg_data
943: );
944: --Standard call to get message count and message info
945: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
946: p_data => x_msg_data);
947: END delete_item_wrap_sss;
948:
949: PROCEDURE update_item_wrap (p_api_version_number IN NUMBER,

Line 984: FND_MSG_PUB.initialize;

980: END IF;
981: -- Initialize message list if p_init_msg_list is set to TRUE.
982: IF FND_API.to_Boolean( p_init_msg_list )
983: THEN
984: FND_MSG_PUB.initialize;
985: END IF;
986: -- Initialize API return status to SUCCESS
987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988:

Line 1036: FND_MSG_PUB.Count_And_Get

1032: IF FND_API.To_Boolean(p_commit) THEN
1033: COMMIT WORK;
1034: END IF;
1035: -- Standard callto get message count and if count is 1, get message info.
1036: FND_MSG_PUB.Count_And_Get
1037: ( p_count => x_msg_count,
1038: p_data => x_msg_data
1039: );
1040: EXCEPTION

Line 1044: FND_MSG_PUB.Count_And_Get

1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN
1042: ROLLBACK TO update_item_PVT;
1043: x_return_status := FND_API.G_RET_STS_ERROR ;
1044: FND_MSG_PUB.Count_And_Get
1045: ( p_count => x_msg_count,
1046: p_data => x_msg_data
1047: );
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1051: FND_MSG_PUB.Count_And_Get

1047: );
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: ROLLBACK TO update_item_PVT;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1051: FND_MSG_PUB.Count_And_Get
1052: ( p_count => x_msg_count,
1053: p_data => x_msg_data
1054: );
1055: WHEN OTHERS THEN

Line 1058: IF FND_MSG_PUB.Check_Msg_Level

1054: );
1055: WHEN OTHERS THEN
1056: ROLLBACK TO update_item_PVT;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: IF FND_MSG_PUB.Check_Msg_Level
1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME ,

Line 1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1055: WHEN OTHERS THEN
1056: ROLLBACK TO update_item_PVT;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: IF FND_MSG_PUB.Check_Msg_Level
1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME ,
1063: l_api_name

Line 1061: FND_MSG_PUB.Add_Exc_Msg

1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: IF FND_MSG_PUB.Check_Msg_Level
1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME ,
1063: l_api_name
1064: );
1065: END IF;

Line 1066: FND_MSG_PUB.Count_And_Get

1062: ( G_PKG_NAME ,
1063: l_api_name
1064: );
1065: END IF;
1066: FND_MSG_PUB.Count_And_Get
1067: ( p_count => x_msg_count ,
1068: p_data => x_msg_data
1069: );
1070: END;

Line 1111: FND_MSG_PUB.initialize;

1107: END IF;
1108: -- Initialize message list if p_init_msg_list is set to TRUE.
1109: IF FND_API.to_Boolean( p_init_msg_list )
1110: THEN
1111: FND_MSG_PUB.initialize;
1112: END IF;
1113: -- Initialize API return status to SUCCESS
1114: x_return_status := FND_API.G_RET_STS_SUCCESS;
1115:

Line 1185: FND_MSG_PUB.Count_And_Get

1181: IF FND_API.To_Boolean(p_commit) THEN
1182: COMMIT WORK;
1183: END IF;
1184: -- Standard callto get message count and if count is 1, get message info.
1185: FND_MSG_PUB.Count_And_Get
1186: ( p_count => x_msg_count,
1187: p_data => x_msg_data
1188: );
1189: EXCEPTION

Line 1192: FND_MSG_PUB.Add;

1188: );
1189: EXCEPTION
1190: WHEN DUPLICATE_INTENT THEN
1191: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_INTENT');
1192: FND_MSG_PUB.Add;
1193: x_return_status := FND_API.G_RET_STS_ERROR ;
1194: FND_MSG_PUB.Count_And_Get
1195: ( p_count => x_msg_count,
1196: p_data => x_msg_data

Line 1194: FND_MSG_PUB.Count_And_Get

1190: WHEN DUPLICATE_INTENT THEN
1191: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_INTENT');
1192: FND_MSG_PUB.Add;
1193: x_return_status := FND_API.G_RET_STS_ERROR ;
1194: FND_MSG_PUB.Count_And_Get
1195: ( p_count => x_msg_count,
1196: p_data => x_msg_data
1197: );
1198:

Line 1202: FND_MSG_PUB.Count_And_Get

1198:
1199: WHEN FND_API.G_EXC_ERROR THEN
1200: ROLLBACK TO update_item_PVT;
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202: FND_MSG_PUB.Count_And_Get
1203: ( p_count => x_msg_count,
1204: p_data => x_msg_data
1205: );
1206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1209: FND_MSG_PUB.Count_And_Get

1205: );
1206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1207: ROLLBACK TO update_item_PVT;
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: FND_MSG_PUB.Count_And_Get
1210: ( p_count => x_msg_count,
1211: p_data => x_msg_data
1212: );
1213: WHEN OTHERS THEN

Line 1216: IF FND_MSG_PUB.Check_Msg_Level

1212: );
1213: WHEN OTHERS THEN
1214: ROLLBACK TO update_item_PVT;
1215: x_return_status := FND_API.G_RET_STS_ERROR;
1216: IF FND_MSG_PUB.Check_Msg_Level
1217: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: FND_MSG_PUB.Add_Exc_Msg
1220: ( G_PKG_NAME ,

Line 1217: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1213: WHEN OTHERS THEN
1214: ROLLBACK TO update_item_PVT;
1215: x_return_status := FND_API.G_RET_STS_ERROR;
1216: IF FND_MSG_PUB.Check_Msg_Level
1217: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: FND_MSG_PUB.Add_Exc_Msg
1220: ( G_PKG_NAME ,
1221: l_api_name

Line 1219: FND_MSG_PUB.Add_Exc_Msg

1215: x_return_status := FND_API.G_RET_STS_ERROR;
1216: IF FND_MSG_PUB.Check_Msg_Level
1217: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: FND_MSG_PUB.Add_Exc_Msg
1220: ( G_PKG_NAME ,
1221: l_api_name
1222: );
1223: END IF;

Line 1224: FND_MSG_PUB.Count_And_Get

1220: ( G_PKG_NAME ,
1221: l_api_name
1222: );
1223: END IF;
1224: FND_MSG_PUB.Count_And_Get
1225: ( p_count => x_msg_count ,
1226: p_data => x_msg_data
1227: );
1228: END;