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 478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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

Line 481: FND_MSG_PUB.Add;

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

Line 499: FND_MSG_PUB.Count_And_Get

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

Line 509: FND_MSG_PUB.Count_And_Get

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

Line 519: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 533: FND_MSG_PUB.Count_And_Get

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

Line 593: FND_MSG_PUB.initialize;

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

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

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

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

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

Line 636: FND_MSG_PUB.Add;

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

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

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

Line 762: FND_MSG_PUB.Add;

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

Line 780: FND_MSG_PUB.Count_And_Get

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

Line 791: FND_MSG_PUB.Count_And_Get

787: EXCEPTION
788: WHEN FND_API.G_EXC_ERROR THEN
789: ROLLBACK TO update_Plan_element;
790: x_return_status := FND_API.G_RET_STS_ERROR ;
791: FND_MSG_PUB.Count_And_Get
792: (
793: p_count => x_msg_count ,
794: p_data => x_msg_data ,
795: p_encoded => FND_API.G_FALSE

Line 801: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 815: FND_MSG_PUB.Count_And_Get

811: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
812: THEN
813: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
814: END IF;
815: FND_MSG_PUB.Count_And_Get
816: (
817: p_count => x_msg_count ,
818: p_data => x_msg_data ,
819: p_encoded => FND_API.G_FALSE

Line 872: FND_MSG_PUB.initialize;

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

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

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

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

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

Line 917: FND_MSG_PUB.Add;

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

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

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

Line 950: FND_MSG_PUB.Add;

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

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

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

Line 977: FND_MSG_PUB.Add;

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

Line 1040: FND_MSG_PUB.Count_And_Get

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

Line 1051: FND_MSG_PUB.Count_And_Get

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

Line 1061: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 1075: FND_MSG_PUB.Count_And_Get

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