561: begin
562:
563: -- bepid must not be null or FND_API.G_MISS_NUM
564: IF (i_bepid IS NULL) OR (i_bepid = FND_API.G_MISS_NUM) THEN
565: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
566: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
567: fnd_message.set_token('PARAM', 'i_bepid: ' || i_bepid);
568: fnd_message.set_token('REASON', 'Incorrect param value');
569: fnd_msg_pub.add;
562:
563: -- bepid must not be null or FND_API.G_MISS_NUM
564: IF (i_bepid IS NULL) OR (i_bepid = FND_API.G_MISS_NUM) THEN
565: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
566: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
567: fnd_message.set_token('PARAM', 'i_bepid: ' || i_bepid);
568: fnd_message.set_token('REASON', 'Incorrect param value');
569: fnd_msg_pub.add;
570:
563: -- bepid must not be null or FND_API.G_MISS_NUM
564: IF (i_bepid IS NULL) OR (i_bepid = FND_API.G_MISS_NUM) THEN
565: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
566: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
567: fnd_message.set_token('PARAM', 'i_bepid: ' || i_bepid);
568: fnd_message.set_token('REASON', 'Incorrect param value');
569: fnd_msg_pub.add;
570:
571: RAISE FND_API.G_EXC_ERROR;
564: IF (i_bepid IS NULL) OR (i_bepid = FND_API.G_MISS_NUM) THEN
565: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
566: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
567: fnd_message.set_token('PARAM', 'i_bepid: ' || i_bepid);
568: fnd_message.set_token('REASON', 'Incorrect param value');
569: fnd_msg_pub.add;
570:
571: RAISE FND_API.G_EXC_ERROR;
572: END IF;
573:
574: -- object_version_number must not be null or FND_API.G_MISS_NUM
575: -- for update API
576: IF (i_object_version IS NULL) OR (i_object_version = FND_API.G_MISS_NUM) THEN
577: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
578: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
579: fnd_message.set_token('PARAM', 'i_object_version: ' || i_object_version);
580: fnd_message.set_token('REASON', 'Incorrect param value');
581: fnd_msg_pub.add;
574: -- object_version_number must not be null or FND_API.G_MISS_NUM
575: -- for update API
576: IF (i_object_version IS NULL) OR (i_object_version = FND_API.G_MISS_NUM) THEN
577: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
578: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
579: fnd_message.set_token('PARAM', 'i_object_version: ' || i_object_version);
580: fnd_message.set_token('REASON', 'Incorrect param value');
581: fnd_msg_pub.add;
582:
575: -- for update API
576: IF (i_object_version IS NULL) OR (i_object_version = FND_API.G_MISS_NUM) THEN
577: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
578: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
579: fnd_message.set_token('PARAM', 'i_object_version: ' || i_object_version);
580: fnd_message.set_token('REASON', 'Incorrect param value');
581: fnd_msg_pub.add;
582:
583: RAISE FND_API.G_EXC_ERROR;
576: IF (i_object_version IS NULL) OR (i_object_version = FND_API.G_MISS_NUM) THEN
577: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
578: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
579: fnd_message.set_token('PARAM', 'i_object_version: ' || i_object_version);
580: fnd_message.set_token('REASON', 'Incorrect param value');
581: fnd_msg_pub.add;
582:
583: RAISE FND_API.G_EXC_ERROR;
584: END IF;
610: -- to null. However IBY_BEPINFO.NAME is a not null column
611: -- note it's ok for the input param to be null. In that case
612: -- the existing value in db is retained
613: IF i_bepname = FND_API.G_MISS_CHAR THEN
614: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
615: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
616: fnd_message.set_token('PARAM', 'i_bepname: FND_API.G_MISS_CHAR');
617: fnd_message.set_token('REASON', 'Incorrect param value');
618: fnd_msg_pub.add;
611: -- note it's ok for the input param to be null. In that case
612: -- the existing value in db is retained
613: IF i_bepname = FND_API.G_MISS_CHAR THEN
614: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
615: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
616: fnd_message.set_token('PARAM', 'i_bepname: FND_API.G_MISS_CHAR');
617: fnd_message.set_token('REASON', 'Incorrect param value');
618: fnd_msg_pub.add;
619:
612: -- the existing value in db is retained
613: IF i_bepname = FND_API.G_MISS_CHAR THEN
614: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
615: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
616: fnd_message.set_token('PARAM', 'i_bepname: FND_API.G_MISS_CHAR');
617: fnd_message.set_token('REASON', 'Incorrect param value');
618: fnd_msg_pub.add;
619:
620: RAISE FND_API.G_EXC_ERROR;
613: IF i_bepname = FND_API.G_MISS_CHAR THEN
614: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
615: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
616: fnd_message.set_token('PARAM', 'i_bepname: FND_API.G_MISS_CHAR');
617: fnd_message.set_token('REASON', 'Incorrect param value');
618: fnd_msg_pub.add;
619:
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
625: -- to null. However IBY_BEPINFO.SUFFIX is a not null column
626: -- note it's ok for the input param to be null. In that case
627: -- the existing value in db is retained
628: IF i_bepsuffix = FND_API.G_MISS_CHAR THEN
629: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
630: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
631: fnd_message.set_token('PARAM', 'i_bepsuffix: FND_API.G_MISS_CHAR');
632: fnd_message.set_token('REASON', 'Incorrect param value');
633: fnd_msg_pub.add;
626: -- note it's ok for the input param to be null. In that case
627: -- the existing value in db is retained
628: IF i_bepsuffix = FND_API.G_MISS_CHAR THEN
629: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
630: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
631: fnd_message.set_token('PARAM', 'i_bepsuffix: FND_API.G_MISS_CHAR');
632: fnd_message.set_token('REASON', 'Incorrect param value');
633: fnd_msg_pub.add;
634:
627: -- the existing value in db is retained
628: IF i_bepsuffix = FND_API.G_MISS_CHAR THEN
629: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
630: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
631: fnd_message.set_token('PARAM', 'i_bepsuffix: FND_API.G_MISS_CHAR');
632: fnd_message.set_token('REASON', 'Incorrect param value');
633: fnd_msg_pub.add;
634:
635: RAISE FND_API.G_EXC_ERROR;
628: IF i_bepsuffix = FND_API.G_MISS_CHAR THEN
629: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
630: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
631: fnd_message.set_token('PARAM', 'i_bepsuffix: FND_API.G_MISS_CHAR');
632: fnd_message.set_token('REASON', 'Incorrect param value');
633: fnd_msg_pub.add;
634:
635: RAISE FND_API.G_EXC_ERROR;
636: END IF;