209: THEN
210: --Error condition
211: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
212: THEN
213: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
214: fnd_msg_pub.add;
215: END IF;
216:
217: x_loading_status := 'CN_INVALID_DATE_RANGE';
225:
226: IF (p_pmtplan_rec.maximum_amount < p_pmtplan_rec.minimum_amount)
227: THEN
228: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
229: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_MAX_LT_MIN');
230: FND_MSG_PUB.Add;
231: END IF;
232: x_loading_status := 'CN_SPP_MAX_LT_MIN';
233: RAISE FND_API.G_EXC_ERROR ;
241: THEN
242: --Error condition
243: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
244: THEN
245: fnd_message.set_name('CN', 'CN_INVALID_PMT_PLAN_FLAGS');
246: fnd_msg_pub.add;
247: END IF;
248:
249: x_status := 'CN_INVALID_PMT_PLAN_FLAGS';
259:
260: --Error condition
261: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
262: THEN
263: fnd_message.set_name('CN', 'CN_INVALID_PMT_PLAN_FLAGS');
264: fnd_msg_pub.add;
265: END IF;
266:
267: x_status := 'CN_INVALID_PMT_PLAN_FLAGS';
301: then
302: --Error condition
303: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
304: THEN
305: fnd_message.set_name('CN', 'CN_PAY_INVALID_PG_CODE');
306: fnd_msg_pub.add;
307: END IF;
308:
309: x_status := 'CN_PAY_INVALID_PG_CODE';
331:
332: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
333: THEN
334:
335: fnd_message.set_name('CN', 'CN_INVALID_CREDIT_TYPE');
336: fnd_msg_pub.add;
337: END IF;
338:
339: x_loading_status := 'CN_INVALID_CREDIT_TYPE';
353: l_pay_interval_type_id NOT IN (-1000, -1001, -1002)
354: THEN
355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
356: THEN
357: fnd_message.set_name('CN', 'CN_INVALID_PAY_INTERVAL');
358: fnd_msg_pub.add;
359: END IF;
360: x_loading_status := 'CN_INVALID_PAY_INTERVAL';
361: CLOSE get_pay_interval_type_id;
566: l_pay_interval_type_id = -1002 ) THEN
567:
568: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
569: THEN
570: fnd_message.set_name('CN', 'CN_INVALID_PAY_INT_AND_REC_INT');
571: fnd_msg_pub.add;
572: END IF;
573:
574: x_status := 'CN_INV_PAY_INT_AND_REC';
584: nvl(l_pay_against_commission,'Y') <> 'N' THEN
585: --Error condition
586: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
587: THEN
588: fnd_message.set_name('CN', 'CN_INVALID_REC_AND_PAC');
589: fnd_msg_pub.add;
590: END IF;
591:
592: x_status := 'CN_INVALID_REC_AND_PAC';
600: nvl(l_pay_against_commission,'Y') = 'N' THEN
601: --Error condition
602: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
603: THEN
604: fnd_message.set_name('CN', 'CN_INVALID_REC_AND_PAC');
605: fnd_msg_pub.add;
606: END IF;
607:
608: x_status := 'CN_INVALID_REC_AND_PAC';
658: ELSE
659: -- The pmt plan already exists - Raise an Error Meassge
660: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
661: THEN
662: FND_MESSAGE.SET_NAME ('CN' , 'CN_PMT_PLAN_EXISTS');
663: FND_MSG_PUB.Add;
664: END IF;
665: x_loading_status := 'CN_PMT_PLAN_EXISTS';
666: RAISE FND_API.G_EXC_ERROR ;
910: THEN
911: --Error condition
912: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
913: THEN
914: fnd_message.set_name('CN', 'CN_PP_SDT_CANNOT_NULL');
915: fnd_msg_pub.add;
916: END IF;
917:
918: x_loading_status := 'CN_PP_SDT_CANNOT_NULL';
926: THEN
927: --Error condition
928: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
929: THEN
930: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
931: fnd_msg_pub.add;
932: END IF;
933:
934: x_loading_status := 'CN_INVALID_DATE_RANGE';
940: THEN
941: --Error condition
942: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
943: THEN
944: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
945: fnd_msg_pub.add;
946: END IF;
947:
948: x_loading_status := 'CN_INVALID_DATE_RANGE';
970: p_pmtplan_rec.object_version_number) THEN
971:
972: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
973: THEN
974: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
975: fnd_msg_pub.add;
976: END IF;
977:
978: x_loading_status := 'CN_INVALID_OBJECT_VERSION';
989: THEN
990:
991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
992: THEN
993: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_PMT_PLAN');
994: fnd_message.set_token('PMT_PLAN_NAME', l_old_pmtPlan_Rec.name);
995: FND_MSG_PUB.Add;
996: END IF;
997:
990:
991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
992: THEN
993: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_PMT_PLAN');
994: fnd_message.set_token('PMT_PLAN_NAME', l_old_pmtPlan_Rec.name);
995: FND_MSG_PUB.Add;
996: END IF;
997:
998: x_loading_status := 'CN_INVALID_PMT_PLAN';
1024: THEN
1025:
1026: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1027: THEN
1028: FND_MESSAGE.SET_NAME ('CN' , 'CN_REC_FLG_UPD_NA');
1029: FND_MSG_PUB.Add;
1030: END IF;
1031:
1032: x_loading_status := 'CN_REC_FLG_UPD_NA';
1034: ELSE IF(p_pmtplan_rec.payment_group_code <> l_pp_rec.payment_group_code)
1035: THEN
1036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1037: THEN
1038: FND_MESSAGE.SET_NAME ('CN' , 'CN_PYMT_GRP_CODE_UPD_NA');
1039: FND_MSG_PUB.Add;
1040: END IF;
1041:
1042: x_loading_status := 'CN_PYMT_GRP_CODE_UPD_NA';
1068:
1069: --Error condition
1070: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1071: THEN
1072: fnd_message.set_name('CN', 'CN_PMT_PLAN_CHANGE_NA');
1073: fnd_msg_pub.add;
1074: END IF;
1075:
1076: x_status := 'CN_PMT_PLAN_CHANGE_NA';
1139: l_pay_interval_type_id = -1002 ) THEN
1140:
1141: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1142: THEN
1143: fnd_message.set_name('CN', 'CN_INVALID_PAY_INT_AND_REC_INT');
1144: fnd_msg_pub.add;
1145: END IF;
1146:
1147: x_status := 'CN_INV_PAY_INT_AND_REC';
1153: l_pay_interval_type_id = -1001 ) THEN
1154:
1155: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1156: THEN
1157: fnd_message.set_name('CN', 'CN_INVALID_PAY_INT_AND_REC_INT');
1158: fnd_msg_pub.add;
1159: END IF;
1160:
1161: x_status := 'CN_INV_PAY_INT_AND_REC';
1174: l_pay_interval_type_id = -1002 ) THEN
1175:
1176: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1177: THEN
1178: fnd_message.set_name('CN', 'CN_INVALID_PAY_INT_AND_REC_INT');
1179: fnd_msg_pub.add;
1180: END IF;
1181:
1182: x_status := 'CN_INV_PAY_INT_AND_REC';
1192: nvl(p_pmtplan_rec.pay_against_commission,'Y') <> 'N' THEN
1193: --Error condition
1194: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1195: THEN
1196: fnd_message.set_name('CN', 'CN_INVALID_REC_AND_PAC');
1197: fnd_msg_pub.add;
1198: END IF;
1199:
1200: x_loading_status := 'CN_INVALID_REC_AND_PAC';
1388: THEN
1389:
1390: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1391: THEN
1392: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_PMT_PLAN');
1393: fnd_message.set_token('PMT_PLAN_NAME', p_PmtPlan_rec.name);
1394: FND_MSG_PUB.Add;
1395: END IF;
1396:
1389:
1390: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1391: THEN
1392: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_PMT_PLAN');
1393: fnd_message.set_token('PMT_PLAN_NAME', p_PmtPlan_rec.name);
1394: FND_MSG_PUB.Add;
1395: END IF;
1396:
1397: x_loading_status := 'CN_INVALID_PMT_PLAN';
1407: IF l_count <> 0
1408: THEN
1409: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1410: THEN
1411: fnd_message.set_name('CN', 'CN_DELETE_NA');
1412: fnd_msg_pub.add;
1413: END IF;
1414:
1415: x_loading_status := 'CN_DELETE_NA';
1424: IF l_count <> 0
1425: THEN
1426: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1427: THEN
1428: fnd_message.set_name('CN', 'CN_DELETE_NA');
1429: fnd_msg_pub.add;
1430: END IF;
1431: x_loading_status := 'CN_DELETE_NA';
1432: RAISE FND_API.G_EXC_ERROR;