745:
746: IF p_user_name IS NULL THEN
747: x_return_status := fnd_api.g_ret_sts_error;
748: fnd_message.set_name('POS', 'POS_CRSUSER_USERNAME_NULL');
749: fnd_msg_pub.ADD;
750: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
751: RETURN;
752: END IF;
753:
746: IF p_user_name IS NULL THEN
747: x_return_status := fnd_api.g_ret_sts_error;
748: fnd_message.set_name('POS', 'POS_CRSUSER_USERNAME_NULL');
749: fnd_msg_pub.ADD;
750: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
751: RETURN;
752: END IF;
753:
754: OPEN l_fnd_user_cur;
757: CLOSE l_fnd_user_cur;
758: x_return_status := fnd_api.g_ret_sts_error;
759: fnd_message.set_name('POS', 'POS_CRSUSER_USERNAME_EXISTS');
760: fnd_message.set_token('USER_NAME', p_user_name);
761: fnd_msg_pub.ADD;
762: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
763: RETURN;
764: END IF;
765: CLOSE l_fnd_user_cur;
758: x_return_status := fnd_api.g_ret_sts_error;
759: fnd_message.set_name('POS', 'POS_CRSUSER_USERNAME_EXISTS');
760: fnd_message.set_token('USER_NAME', p_user_name);
761: fnd_msg_pub.ADD;
762: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
763: RETURN;
764: END IF;
765: CLOSE l_fnd_user_cur;
766:
766:
767: IF p_user_email IS NULL THEN
768: x_return_status := fnd_api.g_ret_sts_error;
769: fnd_message.set_name('POS', 'POS_CRSUSER_EMAIL_NULL');
770: fnd_msg_pub.ADD;
771: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
772: RETURN;
773: END IF;
774:
767: IF p_user_email IS NULL THEN
768: x_return_status := fnd_api.g_ret_sts_error;
769: fnd_message.set_name('POS', 'POS_CRSUSER_EMAIL_NULL');
770: fnd_msg_pub.ADD;
771: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
772: RETURN;
773: END IF;
774:
775: IF p_person_party_id IS NULL THEN
774:
775: IF p_person_party_id IS NULL THEN
776: x_return_status := fnd_api.g_ret_sts_error;
777: fnd_message.set_name('POS', 'POS_CRSUSER_PERSON_PARTY_NULL');
778: fnd_msg_pub.ADD;
779: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
780: RETURN;
781: END IF;
782:
775: IF p_person_party_id IS NULL THEN
776: x_return_status := fnd_api.g_ret_sts_error;
777: fnd_message.set_name('POS', 'POS_CRSUSER_PERSON_PARTY_NULL');
778: fnd_msg_pub.ADD;
779: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
780: RETURN;
781: END IF;
782:
783: OPEN l_party_cur;
786: CLOSE l_party_cur;
787: x_return_status := fnd_api.g_ret_sts_error;
788: fnd_message.set_name('POS', 'POS_CRSUSER_BAD_PERSON_PARTYID');
789: fnd_message.set_token('PERSON_PARTY_ID', p_person_party_id);
790: fnd_msg_pub.ADD;
791: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
792: RETURN;
793: END IF;
794: CLOSE l_party_cur;
787: x_return_status := fnd_api.g_ret_sts_error;
788: fnd_message.set_name('POS', 'POS_CRSUSER_BAD_PERSON_PARTYID');
789: fnd_message.set_token('PERSON_PARTY_ID', p_person_party_id);
790: fnd_msg_pub.ADD;
791: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
792: RETURN;
793: END IF;
794: CLOSE l_party_cur;
795:
796: IF l_party_rec.status <> 'A' THEN
797: x_return_status := fnd_api.g_ret_sts_error;
798: fnd_message.set_name('POS', 'POS_CRSUSER_PERSON_PARTY_INACT');
799: fnd_message.set_token('PERSON_PARTY_ID', p_person_party_id);
800: fnd_msg_pub.ADD;
801: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
802: RETURN;
803: END IF;
804:
797: x_return_status := fnd_api.g_ret_sts_error;
798: fnd_message.set_name('POS', 'POS_CRSUSER_PERSON_PARTY_INACT');
799: fnd_message.set_token('PERSON_PARTY_ID', p_person_party_id);
800: fnd_msg_pub.ADD;
801: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
802: RETURN;
803: END IF;
804:
805: IF l_party_rec.party_type <> 'PERSON' THEN
805: IF l_party_rec.party_type <> 'PERSON' THEN
806: x_return_status := fnd_api.g_ret_sts_error;
807: fnd_message.set_name('POS', 'POS_CRSUSER_PARTY_NOT_PERSON');
808: fnd_message.set_token('PERSON_PARTY_ID', p_person_party_id);
809: fnd_msg_pub.ADD;
810: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
811: RETURN;
812: END IF;
813:
806: x_return_status := fnd_api.g_ret_sts_error;
807: fnd_message.set_name('POS', 'POS_CRSUSER_PARTY_NOT_PERSON');
808: fnd_message.set_token('PERSON_PARTY_ID', p_person_party_id);
809: fnd_msg_pub.ADD;
810: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
811: RETURN;
812: END IF;
813:
814: IF p_password IS NULL THEN