85: --
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: --
88: IF FND_API.to_Boolean( p_init_msg_list ) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91: --
92: -- Initialize API return status to success
93: --
141: --
142: -- Standard call to get message count and if count is 1, get message info.
143: --
144:
145: FND_MSG_PUB.Count_And_Get
146: (
147: p_count => x_msg_count ,
148: p_data => x_msg_data ,
149: p_encoded => FND_API.G_FALSE
154: WHEN FND_API.G_EXC_ERROR THEN
155: ROLLBACK TO Create_delete_Wrkhst;
156:
157: x_return_status := FND_API.G_RET_STS_ERROR ;
158: FND_MSG_PUB.Count_And_Get
159: (
160: p_count => x_msg_count ,
161: p_data => x_msg_data ,
162: p_encoded => FND_API.G_FALSE
165: ROLLBACK TO Create_delete_Wrkhst;
166:
167: x_loading_status := 'UNEXPECTED_ERR';
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
169: FND_MSG_PUB.Count_And_Get
170: (
171: p_count => x_msg_count ,
172: p_data => x_msg_data ,
173: p_encoded => FND_API.G_FALSE
177:
178: ROLLBACK TO Create_delete_Wrkhst;
179: x_loading_status := 'UNEXPECTED_ERR';
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
182: THEN
183: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
184: END IF;
185: FND_MSG_PUB.Count_And_Get
179: x_loading_status := 'UNEXPECTED_ERR';
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
182: THEN
183: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
184: END IF;
185: FND_MSG_PUB.Count_And_Get
186: (
187: p_count => x_msg_count ,
181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
182: THEN
183: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
184: END IF;
185: FND_MSG_PUB.Count_And_Get
186: (
187: p_count => x_msg_count ,
188: p_data => x_msg_data ,
189: p_encoded => FND_API.G_FALSE
261: --
262: -- Initialize message list if p_init_msg_list is set to TRUE.
263: --
264: IF FND_API.to_Boolean( p_init_msg_list ) THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267: --
268: -- Initialize API return status to success
269: --
345: --
346: -- Standard call to get message count and if count is 1, get message info.
347: --
348:
349: FND_MSG_PUB.Count_And_Get
350: (
351: p_count => x_msg_count ,
352: p_data => x_msg_data ,
353: p_encoded => FND_API.G_FALSE
358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO Apply_payment_plan_upd;
360:
361: x_return_status := FND_API.G_RET_STS_ERROR ;
362: FND_MSG_PUB.Count_And_Get
363: (
364: p_count => x_msg_count ,
365: p_data => x_msg_data ,
366: p_encoded => FND_API.G_FALSE
369: ROLLBACK TO Apply_payment_plan_upd;
370:
371: x_loading_status := 'UNEXPECTED_ERR';
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: FND_MSG_PUB.Count_And_Get
374: (
375: p_count => x_msg_count ,
376: p_data => x_msg_data ,
377: p_encoded => FND_API.G_FALSE
381:
382: ROLLBACK TO Apply_payment_plan_upd ;
383: x_loading_status := 'UNEXPECTED_ERR';
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
388: END IF;
389: FND_MSG_PUB.Count_And_Get
383: x_loading_status := 'UNEXPECTED_ERR';
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
388: END IF;
389: FND_MSG_PUB.Count_And_Get
390: (
391: p_count => x_msg_count ,
385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
388: END IF;
389: FND_MSG_PUB.Count_And_Get
390: (
391: p_count => x_msg_count ,
392: p_data => x_msg_data ,
393: p_encoded => FND_API.G_FALSE
459: --
460: -- Initialize message list if p_init_msg_list is set to TRUE.
461: --
462: IF FND_API.to_Boolean( p_init_msg_list ) THEN
463: FND_MSG_PUB.initialize;
464: END IF;
465: --
466: -- Initialize API return status to success
467: --
558: --
559: -- Standard call to get message count and if count is 1, get message info.
560: --
561:
562: FND_MSG_PUB.Count_And_Get
563: (
564: p_count => x_msg_count ,
565: p_data => x_msg_data ,
566: p_encoded => FND_API.G_FALSE
571: WHEN FND_API.G_EXC_ERROR THEN
572: ROLLBACK TO Apply_payment_plan_del;
573:
574: x_return_status := FND_API.G_RET_STS_ERROR ;
575: FND_MSG_PUB.Count_And_Get
576: (
577: p_count => x_msg_count ,
578: p_data => x_msg_data ,
579: p_encoded => FND_API.G_FALSE
582: ROLLBACK TO Apply_payment_plan_del;
583:
584: x_loading_status := 'UNEXPECTED_ERR';
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
586: FND_MSG_PUB.Count_And_Get
587: (
588: p_count => x_msg_count ,
589: p_data => x_msg_data ,
590: p_encoded => FND_API.G_FALSE
594:
595: ROLLBACK TO Apply_payment_plan_del ;
596: x_loading_status := 'UNEXPECTED_ERR';
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
599: THEN
600: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
601: END IF;
602: FND_MSG_PUB.Count_And_Get
596: x_loading_status := 'UNEXPECTED_ERR';
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
599: THEN
600: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
601: END IF;
602: FND_MSG_PUB.Count_And_Get
603: (
604: p_count => x_msg_count ,
598: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
599: THEN
600: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
601: END IF;
602: FND_MSG_PUB.Count_And_Get
603: (
604: p_count => x_msg_count ,
605: p_data => x_msg_data ,
606: p_encoded => FND_API.G_FALSE
689: --
690: -- Initialize message list if p_init_msg_list is set to TRUE.
691: --
692: IF FND_API.to_Boolean( p_init_msg_list ) THEN
693: FND_MSG_PUB.initialize;
694: END IF;
695: --
696: -- Initialize API return status to success
697: --
789: --
790: -- Standard call to get message count and if count is 1, get message info.
791: --
792:
793: FND_MSG_PUB.Count_And_Get
794: (
795: p_count => x_msg_count ,
796: p_data => x_msg_data ,
797: p_encoded => FND_API.G_FALSE
802: WHEN FND_API.G_EXC_ERROR THEN
803: ROLLBACK TO Apply_payment_plan_cre;
804:
805: x_return_status := FND_API.G_RET_STS_ERROR ;
806: FND_MSG_PUB.Count_And_Get
807: (
808: p_count => x_msg_count ,
809: p_data => x_msg_data ,
810: p_encoded => FND_API.G_FALSE
813: ROLLBACK TO Apply_payment_plan_cre;
814:
815: x_loading_status := 'UNEXPECTED_ERR';
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
817: FND_MSG_PUB.Count_And_Get
818: (
819: p_count => x_msg_count ,
820: p_data => x_msg_data ,
821: p_encoded => FND_API.G_FALSE
825:
826: ROLLBACK TO Apply_payment_plan_cre ;
827: x_loading_status := 'UNEXPECTED_ERR';
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
829: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
830: THEN
831: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
832: END IF;
833: FND_MSG_PUB.Count_And_Get
827: x_loading_status := 'UNEXPECTED_ERR';
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
829: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
830: THEN
831: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
832: END IF;
833: FND_MSG_PUB.Count_And_Get
834: (
835: p_count => x_msg_count ,
829: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
830: THEN
831: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
832: END IF;
833: FND_MSG_PUB.Count_And_Get
834: (
835: p_count => x_msg_count ,
836: p_data => x_msg_data ,
837: p_encoded => FND_API.G_FALSE