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

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

90: x_calc_formula_id := l_calc_formula_id;
91:
92: -- Raise an error, if rate schedule id is null, not exists in the database
93: IF x_rate_schedule_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_RATE_SCH_NOT_EXIST');
97: FND_MSG_PUB.Add;
98: END IF;

Line 97: FND_MSG_PUB.Add;

93: IF x_rate_schedule_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_RATE_SCH_NOT_EXIST');
97: FND_MSG_PUB.Add;
98: END IF;
99: x_loading_status := 'RATE_SCH_NOT_EXIST';
100: RAISE FND_API.G_EXC_ERROR ;
101: END IF;

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

104: -- Validate Rule : End period must be greater than Start period
105:
106: IF (p_rt_quota_asgns_rec.end_date IS NOT NULL
107: AND trunc(p_rt_quota_asgns_rec.end_date) < Trunc(p_rt_quota_asgns_rec.start_date)) THEN
108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
109: THEN
110: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_RANGE');
111: FND_MSG_PUB.Add;
112: END IF;

Line 111: FND_MSG_PUB.Add;

107: AND trunc(p_rt_quota_asgns_rec.end_date) < Trunc(p_rt_quota_asgns_rec.start_date)) THEN
108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
109: THEN
110: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_RANGE');
111: FND_MSG_PUB.Add;
112: END IF;
113: x_loading_status := 'INVALID_END_DATE';
114: RAISE FND_API.G_EXC_ERROR ;
115: END IF;

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

139:
140: -- check the rt_quota_asgns_id is Not null and exists in the database
141:
142: IF x_rt_quota_asgn_id IS NULL THEN
143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
144: THEN
145: FND_MESSAGE.SET_NAME ('CN' , 'CN_RT_QUOTA_NOT_EXISTS');
146: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);
147: FND_MESSAGE.SET_TOKEN('RATE_SCHEDULE_NAME',p_rt_quota_asgns_rec.rate_schedule_name_old );

Line 149: FND_MSG_PUB.Add;

145: FND_MESSAGE.SET_NAME ('CN' , 'CN_RT_QUOTA_NOT_EXISTS');
146: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);
147: FND_MESSAGE.SET_TOKEN('RATE_SCHEDULE_NAME',p_rt_quota_asgns_rec.rate_schedule_name_old );
148: FND_MESSAGE.SET_TOKEN('START_DATE',p_rt_quota_asgns_rec.start_date_old );
149: FND_MSG_PUB.Add;
150: END IF;
151: x_loading_status := 'RT_QUOTA_NOT_EXISTS';
152: RAISE FND_API.G_EXC_ERROR ;
153: END IF;

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

164: AND rt_quota_asgn_id <> Nvl(x_rt_quota_asgn_id,0)
165: AND Trunc(start_date) = Trunc(p_rt_quota_Asgns_rec.start_date)
166: ;
167: IF (l_tmp <> 0) THEN
168: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
169: THEN
170: FND_MESSAGE.SET_NAME ('CN' , 'CN_RT_QUOTA_EXISTS');
171: FND_MSG_PUB.Add;
172: END IF;

Line 171: FND_MSG_PUB.Add;

167: IF (l_tmp <> 0) THEN
168: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
169: THEN
170: FND_MESSAGE.SET_NAME ('CN' , 'CN_RT_QUOTA_EXISTS');
171: FND_MSG_PUB.Add;
172: END IF;
173: x_loading_status := 'RT_QUOTA_EXISTS';
174: END IF ;
175:

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

190:
191: -- check quota type, if quota type is NONE you cannot have rates
192:
193: IF Nvl(cn_chk_plan_element_pkg.get_quota_type ( p_quota_id ),'NONE') = 'NONE' THEN
194: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
195: THEN
196: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_CANNOT_HAVE_RATE' );
197: FND_MSG_PUB.Add;
198: END IF;

Line 197: FND_MSG_PUB.Add;

193: IF Nvl(cn_chk_plan_element_pkg.get_quota_type ( p_quota_id ),'NONE') = 'NONE' THEN
194: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
195: THEN
196: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_CANNOT_HAVE_RATE' );
197: FND_MSG_PUB.Add;
198: END IF;
199: x_loading_status := 'QUOTA_CANNOT_HAVE_RATE';
200: RAISE FND_API.G_EXC_ERROR ;
201: END IF;

Line 206: FND_MSG_PUB.Count_And_Get

202:
203: -- End of Validate rt Quota Asigns .
204: -- Standard call to get message count and if count is 1, get message info.
205:
206: FND_MSG_PUB.Count_And_Get
207: (
208: p_count => x_msg_count,
209: p_data => x_msg_data,
210: p_encoded => FND_API.G_FALSE

Line 216: FND_MSG_PUB.Count_And_Get

212:
213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_ERROR ;
216: FND_MSG_PUB.Count_And_Get
217: (
218: p_count => x_msg_count ,
219: p_data => x_msg_data ,
220: p_encoded => FND_API.G_FALSE

Line 225: FND_MSG_PUB.Count_And_Get

221: );
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: x_loading_status := 'UNEXPECTED_ERR';
225: FND_MSG_PUB.Count_And_Get
226: (
227: p_count => x_msg_count ,
228: p_data => x_msg_data ,
229: p_encoded => FND_API.G_FALSE

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

230: );
231: WHEN OTHERS THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: x_loading_status := 'UNEXPECTED_ERR';
234: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
237: END IF;
238: FND_MSG_PUB.Count_And_Get

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

232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: x_loading_status := 'UNEXPECTED_ERR';
234: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
237: END IF;
238: FND_MSG_PUB.Count_And_Get
239: (
240: p_count => x_msg_count,

Line 238: FND_MSG_PUB.Count_And_Get

234: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
237: END IF;
238: FND_MSG_PUB.Count_And_Get
239: (
240: p_count => x_msg_count,
241: p_data => x_msg_data,
242: p_encoded=> FND_API.G_FALSE

Line 299: FND_MSG_PUB.initialize;

295:
296: -- Initialize message list if p_init_msg_list is set to TRUE.
297:
298: IF FND_API.to_Boolean( p_init_msg_list ) THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301:
302:
303: -- Initialize API return status to success

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

336:
337: IF (p_quota_name IS NOT NULL
338: AND l_quota_id IS NULL )
339: THEN
340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
341: THEN
342: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
343: THEN
344: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');

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

338: AND l_quota_id IS NULL )
339: THEN
340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
341: THEN
342: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
343: THEN
344: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');
345: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);
346: FND_MSG_PUB.Add;

Line 346: FND_MSG_PUB.Add;

342: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
343: THEN
344: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');
345: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);
346: FND_MSG_PUB.Add;
347: END IF;
348: x_loading_status := 'CN_PLN_NOT_EXIST' ;
349: RAISE FND_API.G_EXC_ERROR;
350: END IF;

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

475: x_loading_status := l_loading_status;
476: -- Raise an error if the return status is not success
477:
478: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
479: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
480: THEN
481: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_SEQUENCE' );
482: FND_MSG_PUB.Add;
483: END IF;

Line 482: FND_MSG_PUB.Add;

478: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
479: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
480: THEN
481: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_SEQUENCE' );
482: FND_MSG_PUB.Add;
483: END IF;
484: x_loading_status := 'CN_INVALID_DATE_SEQUENCE';
485: RAISE FND_API.G_EXC_ERROR ;
486: END IF;

Line 500: FND_MSG_PUB.Count_And_Get

496: END IF;
497:
498: -- Standard call to get message count and if count is 1, get message info.
499:
500: FND_MSG_PUB.Count_And_Get
501: (
502: p_count => x_msg_count ,
503: p_data => x_msg_data ,
504: p_encoded => FND_API.G_FALSE

Line 510: FND_MSG_PUB.Count_And_Get

506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: ROLLBACK TO create_rt_quota_asgns;
509: x_return_status := FND_API.G_RET_STS_ERROR ;
510: FND_MSG_PUB.Count_And_Get
511: (
512: p_count => x_msg_count ,
513: p_data => x_msg_data ,
514: p_encoded => FND_API.G_FALSE

Line 520: FND_MSG_PUB.Count_And_Get

516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: ROLLBACK TO create_rt_quota_asgns;
518: x_loading_status := 'UNEXPECTED_ERR';
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
520: FND_MSG_PUB.Count_And_Get
521: (
522: p_count => x_msg_count ,
523: p_data => x_msg_data ,
524: p_encoded => FND_API.G_FALSE

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

526: WHEN OTHERS THEN
527: ROLLBACK TO create_rt_quota_asgns;
528: x_loading_status := 'UNEXPECTED_ERR';
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: THEN
532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
533: END IF;
534: FND_MSG_PUB.Count_And_Get

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

528: x_loading_status := 'UNEXPECTED_ERR';
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: THEN
532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
533: END IF;
534: FND_MSG_PUB.Count_And_Get
535: (
536: p_count => x_msg_count ,

Line 534: FND_MSG_PUB.Count_And_Get

530: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: THEN
532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
533: END IF;
534: FND_MSG_PUB.Count_And_Get
535: (
536: p_count => x_msg_count ,
537: p_data => x_msg_data ,
538: p_encoded => FND_API.G_FALSE

Line 594: FND_MSG_PUB.initialize;

590:
591: -- Initialize message list if p_init_msg_list is set to TRUE.
592:
593: IF FND_API.to_Boolean( p_init_msg_list ) THEN
594: FND_MSG_PUB.initialize;
595: END IF;
596:
597:
598: -- Initialize API return status to success

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

627:
628: IF (p_quota_name IS NOT NULL
629: AND l_quota_id IS NULL )
630: THEN
631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
632: THEN
633: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
634: THEN
635: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');

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

629: AND l_quota_id IS NULL )
630: THEN
631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
632: THEN
633: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
634: THEN
635: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');
636: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);
637: FND_MSG_PUB.Add;

Line 637: FND_MSG_PUB.Add;

633: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
634: THEN
635: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');
636: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);
637: FND_MSG_PUB.Add;
638: END IF;
639: x_loading_status := 'CN_PLN_NOT_EXIST' ;
640: RAISE FND_API.G_EXC_ERROR ;
641: END IF;

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

757:
758: -- Raise an error if the return status is not success
759:
760: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
762: THEN
763: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_SEQUENCE' );
764: FND_MSG_PUB.Add;
765: END IF;

Line 764: FND_MSG_PUB.Add;

760: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
762: THEN
763: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_SEQUENCE' );
764: FND_MSG_PUB.Add;
765: END IF;
766: x_loading_status := 'CN_INVALID_DATE_SEQUENCE';
767: RAISE FND_API.G_EXC_ERROR ;
768: END IF;

Line 782: FND_MSG_PUB.Count_And_Get

778: END IF;
779:
780: -- Standard call to get message count and if count is 1, get message info.
781:
782: FND_MSG_PUB.Count_And_Get
783: (
784: p_count => x_msg_count ,
785: p_data => x_msg_data ,
786: p_encoded => FND_API.G_FALSE

Line 793: FND_MSG_PUB.Count_And_Get

789: EXCEPTION
790: WHEN FND_API.G_EXC_ERROR THEN
791: ROLLBACK TO update_Plan_element;
792: x_return_status := FND_API.G_RET_STS_ERROR ;
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

Line 803: FND_MSG_PUB.Count_And_Get

799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
800: ROLLBACK TO update_Plan_Element;
801: x_loading_status := 'UNEXPECTED_ERR';
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
803: FND_MSG_PUB.Count_And_Get
804: (
805: p_count => x_msg_count ,
806: p_data => x_msg_data ,
807: p_encoded => FND_API.G_FALSE

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

809: WHEN OTHERS THEN
810: ROLLBACK TO update_plan_element;
811: x_loading_status := 'UNEXPECTED_ERR';
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
813: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN
815: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
816: END IF;
817: FND_MSG_PUB.Count_And_Get

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

811: x_loading_status := 'UNEXPECTED_ERR';
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
813: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN
815: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
816: END IF;
817: FND_MSG_PUB.Count_And_Get
818: (
819: p_count => x_msg_count ,

Line 817: FND_MSG_PUB.Count_And_Get

813: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN
815: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
816: END IF;
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

Line 874: FND_MSG_PUB.initialize;

870:
871: -- Initialize message list if p_init_msg_list is set to TRUE.
872:
873: IF FND_API.to_Boolean( p_init_msg_list ) THEN
874: FND_MSG_PUB.initialize;
875: END IF;
876:
877: -- Initialize API return status to success
878:

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

909:
910: IF (p_quota_name IS NOT NULL
911: AND l_quota_id IS NULL )
912: THEN
913: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
914: THEN
915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
916: THEN
917: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');

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

911: AND l_quota_id IS NULL )
912: THEN
913: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
914: THEN
915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
916: THEN
917: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');
918: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);
919: FND_MSG_PUB.Add;

Line 919: FND_MSG_PUB.Add;

915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
916: THEN
917: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');
918: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);
919: FND_MSG_PUB.Add;
920: END IF;
921: x_loading_status := 'CN_PLN_NOT_EXIST' ;
922: RAISE FND_API.G_EXC_ERROR ;
923: END IF;

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

942:
943: -- if rate_quota_assign_id is NULL then Unable to find the record from database
944:
945: IF l_rt_quota_asgn_id IS NULL THEN
946: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
947: THEN
948: FND_MESSAGE.SET_NAME ('CN' , 'CN_RT_QUOTA_NOT_EXISTS');
949: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);
950: FND_MESSAGE.SET_TOKEN('RATE_SCHEDULE_NAME',p_rt_quota_asgns_rec_tbl(i).rate_schedule_name );

Line 952: FND_MSG_PUB.Add;

948: FND_MESSAGE.SET_NAME ('CN' , 'CN_RT_QUOTA_NOT_EXISTS');
949: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);
950: FND_MESSAGE.SET_TOKEN('RATE_SCHEDULE_NAME',p_rt_quota_asgns_rec_tbl(i).rate_schedule_name );
951: FND_MESSAGE.SET_TOKEN('START_DATE',p_rt_quota_asgns_rec_tbl(i).start_date );
952: FND_MSG_PUB.Add;
953: END IF;
954: x_loading_status := 'RT_QUOTA_NOT_EXISTS';
955: RAISE FND_API.G_EXC_ERROR ;
956: END IF;

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

972: );
973: x_loading_status := l_loading_status;
974:
975: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
976: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
977: THEN
978: FND_MESSAGE.SET_NAME ('CN' , 'CN_RATE_DELETE_NOT_ALLOWED' );
979: FND_MSG_PUB.Add;
980: END IF;

Line 979: FND_MSG_PUB.Add;

975: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
976: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
977: THEN
978: FND_MESSAGE.SET_NAME ('CN' , 'CN_RATE_DELETE_NOT_ALLOWED' );
979: FND_MSG_PUB.Add;
980: END IF;
981: x_loading_status := 'CN_RATE_DELETE_NOT_ALLOWED';
982: RAISE FND_API.G_EXC_ERROR ;
983: END IF;

Line 1042: FND_MSG_PUB.Count_And_Get

1038:
1039:
1040: -- Standard call to get message count and if count is 1, get message info.
1041:
1042: FND_MSG_PUB.Count_And_Get
1043: (
1044: p_count => x_msg_count ,
1045: p_data => x_msg_data ,
1046: p_encoded => FND_API.G_FALSE

Line 1053: FND_MSG_PUB.Count_And_Get

1049: EXCEPTION
1050: WHEN FND_API.G_EXC_ERROR THEN
1051: ROLLBACK TO delete_rt_quota_asgns;
1052: x_return_status := FND_API.G_RET_STS_ERROR ;
1053: FND_MSG_PUB.Count_And_Get
1054: (
1055: p_count => x_msg_count ,
1056: p_data => x_msg_data ,
1057: p_encoded => FND_API.G_FALSE

Line 1063: FND_MSG_PUB.Count_And_Get

1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1060: ROLLBACK TO delete_rt_quota_asgns;
1061: x_loading_status := 'UNEXPECTED_ERR';
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1063: FND_MSG_PUB.Count_And_Get
1064: (
1065: p_count => x_msg_count ,
1066: p_data => x_msg_data ,
1067: p_encoded => FND_API.G_FALSE

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

1069: WHEN OTHERS THEN
1070: ROLLBACK TO delete_rt_quota_asgns;
1071: x_loading_status := 'UNEXPECTED_ERR';
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1073: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1074: THEN
1075: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1076: END IF;
1077: FND_MSG_PUB.Count_And_Get

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

1071: x_loading_status := 'UNEXPECTED_ERR';
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1073: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1074: THEN
1075: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1076: END IF;
1077: FND_MSG_PUB.Count_And_Get
1078: (
1079: p_count => x_msg_count ,

Line 1077: FND_MSG_PUB.Count_And_Get

1073: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1074: THEN
1075: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1076: END IF;
1077: FND_MSG_PUB.Count_And_Get
1078: (
1079: p_count => x_msg_count ,
1080: p_data => x_msg_data ,
1081: p_encoded => FND_API.G_FALSE