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 481: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_SEQUENCE' );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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