173: -- Error, check the msg level and add an error message to the
174: -- API message list
175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
176: THEN
177: FND_MESSAGE.SET_NAME ('CN', 'CN_SALESREP_NOT_FOUND');
178: FND_MSG_PUB.Add;
179: END IF;
180: END IF;
181: WHEN too_many_rows THEN
186: -- Error, check the msg level and add an error message to the
187: -- API message list
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
189: THEN
190: FND_MESSAGE.SET_NAME ('CN', 'CN_SALESREP_TOO_MANY_ROWS');
191: FND_MSG_PUB.Add;
192: END IF;
193: END IF;
194: END chk_and_get_salesrep_id;
323:
324: --Error condition
325: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
326: THEN
327: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
328: fnd_message.set_token('PAY_GROUP_NAME', l_paygroup_assign_rec.pay_group_name);
329: fnd_msg_pub.add;
330: END IF;
331:
324: --Error condition
325: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
326: THEN
327: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
328: fnd_message.set_token('PAY_GROUP_NAME', l_paygroup_assign_rec.pay_group_name);
329: fnd_msg_pub.add;
330: END IF;
331:
332: x_loading_status := 'CN_INVALID_PAY_GROUP';
757: --
758:
759: if nvl(l_paygroup_assign_rec.org_id, -99) <>
760: Nvl(l_old_paygroup_assign_rec.org_id, -99) then
761: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
762: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
763: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
764: 'cn.plsql.cn_srp_paygroup_pub.update_srp_assignment.error',
765: true);
765: true);
766: end if;
767:
768: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
769: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
770: FND_MSG_PUB.Add;
771: END IF;
772:
773: RAISE FND_API.G_EXC_ERROR ;
811:
812: --Error condition
813: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
814: THEN
815: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
816: fnd_message.set_token('PAY_GROUP_NAME',
817: l_old_paygroup_assign_rec.pay_group_name);
818: fnd_msg_pub.add;
819: END IF;
812: --Error condition
813: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
814: THEN
815: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
816: fnd_message.set_token('PAY_GROUP_NAME',
817: l_old_paygroup_assign_rec.pay_group_name);
818: fnd_msg_pub.add;
819: END IF;
820:
863:
864: --Error condition
865: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
866: THEN
867: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
868: fnd_message.set_token('PAY_GROUP_NAME', l_paygroup_assign_rec.pay_group_name);
869: fnd_msg_pub.add;
870: END IF;
871:
864: --Error condition
865: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
866: THEN
867: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
868: fnd_message.set_token('PAY_GROUP_NAME', l_paygroup_assign_rec.pay_group_name);
869: fnd_msg_pub.add;
870: END IF;
871:
872: x_loading_status := 'CN_INVALID_PAY_GROUP';
984: IF get_srp_pay_group_id_cur%rowcount = 0
985: THEN
986: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
987: THEN
988: fnd_message.set_name('CN', 'CN_INVALID_SRP_PGRP_ASGN');
989: fnd_message.set_token('EMPLOYEE_TYPE',
990: l_old_paygroup_assign_rec.employee_type);
991: fnd_message.set_token('EMPLOYEE_NUMBER',
992: l_old_paygroup_assign_rec.employee_number);
985: THEN
986: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
987: THEN
988: fnd_message.set_name('CN', 'CN_INVALID_SRP_PGRP_ASGN');
989: fnd_message.set_token('EMPLOYEE_TYPE',
990: l_old_paygroup_assign_rec.employee_type);
991: fnd_message.set_token('EMPLOYEE_NUMBER',
992: l_old_paygroup_assign_rec.employee_number);
993: fnd_msg_pub.add;
987: THEN
988: fnd_message.set_name('CN', 'CN_INVALID_SRP_PGRP_ASGN');
989: fnd_message.set_token('EMPLOYEE_TYPE',
990: l_old_paygroup_assign_rec.employee_type);
991: fnd_message.set_token('EMPLOYEE_NUMBER',
992: l_old_paygroup_assign_rec.employee_number);
993: fnd_msg_pub.add;
994: END IF;
995: x_loading_status := 'CN_INVALID_SRP_PGRP_ASGN';