DBA Data[Home] [Help]

APPS.CN_RT_QUOTA_ASGNS_PVT dependencies on FND_MESSAGE

Line 96: FND_MESSAGE.SET_NAME ('CN' , 'CN_RATE_SCH_NOT_EXIST');

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;
99: x_loading_status := 'RATE_SCH_NOT_EXIST';
100: RAISE FND_API.G_EXC_ERROR ;

Line 110: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_RANGE');

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;
113: x_loading_status := 'INVALID_END_DATE';
114: RAISE FND_API.G_EXC_ERROR ;

Line 145: FND_MESSAGE.SET_NAME ('CN' , 'CN_RT_QUOTA_NOT_EXISTS');

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 );
148: FND_MESSAGE.SET_TOKEN('START_DATE',p_rt_quota_asgns_rec.start_date_old );
149: FND_MSG_PUB.Add;

Line 146: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);

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 );
148: FND_MESSAGE.SET_TOKEN('START_DATE',p_rt_quota_asgns_rec.start_date_old );
149: FND_MSG_PUB.Add;
150: END IF;

Line 147: FND_MESSAGE.SET_TOKEN('RATE_SCHEDULE_NAME',p_rt_quota_asgns_rec.rate_schedule_name_old );

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 );
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';

Line 148: FND_MESSAGE.SET_TOKEN('START_DATE',p_rt_quota_asgns_rec.start_date_old );

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 );
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 ;

Line 170: FND_MESSAGE.SET_NAME ('CN' , 'CN_RT_QUOTA_EXISTS');

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;
173: x_loading_status := 'RT_QUOTA_EXISTS';
174: END IF ;

Line 196: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_CANNOT_HAVE_RATE' );

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;
199: x_loading_status := 'QUOTA_CANNOT_HAVE_RATE';
200: RAISE FND_API.G_EXC_ERROR ;

Line 344: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');

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;
347: END IF;
348: x_loading_status := 'CN_PLN_NOT_EXIST' ;

Line 345: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);

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;
347: END IF;
348: x_loading_status := 'CN_PLN_NOT_EXIST' ;
349: RAISE FND_API.G_EXC_ERROR;

Line 480: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_SEQUENCE' );

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;
483: x_loading_status := 'CN_INVALID_DATE_SEQUENCE';
484: RAISE FND_API.G_EXC_ERROR ;

Line 634: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');

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;
637: END IF;
638: x_loading_status := 'CN_PLN_NOT_EXIST' ;

Line 635: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);

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;
637: END IF;
638: x_loading_status := 'CN_PLN_NOT_EXIST' ;
639: RAISE FND_API.G_EXC_ERROR ;

Line 761: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_SEQUENCE' );

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;
764: x_loading_status := 'CN_INVALID_DATE_SEQUENCE';
765: RAISE FND_API.G_EXC_ERROR ;

Line 915: FND_MESSAGE.SET_NAME('CN' , 'CN_PLN_NOT_EXIST');

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;
918: END IF;
919: x_loading_status := 'CN_PLN_NOT_EXIST' ;

Line 916: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name);

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;
918: END IF;
919: x_loading_status := 'CN_PLN_NOT_EXIST' ;
920: RAISE FND_API.G_EXC_ERROR ;

Line 946: FND_MESSAGE.SET_NAME ('CN' , 'CN_RT_QUOTA_NOT_EXISTS');

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 );
949: FND_MESSAGE.SET_TOKEN('START_DATE',p_rt_quota_asgns_rec_tbl(i).start_date );
950: FND_MSG_PUB.Add;

Line 947: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);

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 );
949: FND_MESSAGE.SET_TOKEN('START_DATE',p_rt_quota_asgns_rec_tbl(i).start_date );
950: FND_MSG_PUB.Add;
951: END IF;

Line 948: FND_MESSAGE.SET_TOKEN('RATE_SCHEDULE_NAME',p_rt_quota_asgns_rec_tbl(i).rate_schedule_name );

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 );
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';

Line 949: FND_MESSAGE.SET_TOKEN('START_DATE',p_rt_quota_asgns_rec_tbl(i).start_date );

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 );
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 ;

Line 976: FND_MESSAGE.SET_NAME ('CN' , 'CN_RATE_DELETE_NOT_ALLOWED' );

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;
979: x_loading_status := 'CN_RATE_DELETE_NOT_ALLOWED';
980: RAISE FND_API.G_EXC_ERROR ;