424: WHEN INVALID_OBJ_TYPE_EXCEPTION
425: THEN
426: ROLLBACK to sp_wip_wol_grp;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INVALID_OBJ_TYPE');
429: FND_MSG_PUB.Add;
430: FND_MSG_PUB.Count_AND_Get
431: ( p_count => x_msg_count,
432: p_data => x_msg_data
435: WHEN INVALID_REL_TYPE_EXCEPTION
436: THEN
437: ROLLBACK to sp_wip_wol_grp;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INVALID_REL_TYPE');
440: FND_MSG_PUB.Add;
441: FND_MSG_PUB.Count_AND_Get
442: ( p_count => x_msg_count,
443: p_data => x_msg_data
446: WHEN PARENT_CHILD_SAME_EXCEPTION
447: THEN
448: ROLLBACK to sp_wip_wol_grp;
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_PARENT_CHILD_SAME');
451: FND_MSG_PUB.Add;
452: FND_MSG_PUB.Count_AND_Get
453: ( p_count => x_msg_count,
454: p_data => x_msg_data
457: WHEN BAD_REL_STATUS_EXCEPTION
458: THEN
459: ROLLBACK to sp_wip_wol_grp;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_BAD_REL_STATUS');
462: FND_MSG_PUB.Add;
463: FND_MSG_PUB.Count_AND_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data
468: WHEN DEP_REL_EXIST_EXCEPTION
469: THEN
470: ROLLBACK to sp_wip_wol_grp;
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_DEPENDENT_REL_EXIST');
473: FND_MSG_PUB.Add;
474: FND_MSG_PUB.Count_AND_Get
475: ( p_count => x_msg_count,
476: p_data => x_msg_data
479: WHEN CONST_REL_EXIST_EXCEPTION
480: THEN
481: ROLLBACK to sp_wip_wol_grp;
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_CONSTRAINED_REL_EXIST');
484: FND_MSG_PUB.Add;
485: FND_MSG_PUB.Count_AND_Get
486: ( p_count => x_msg_count,
487: p_data => x_msg_data
490: WHEN DUPLICATE_PARENT_EXCEPTION
491: THEN
492: ROLLBACK to sp_wip_wol_grp;
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_PARENT_EXIST');
495: FND_MSG_PUB.Add;
496: FND_MSG_PUB.Count_AND_Get
497: ( p_count => x_msg_count,
498: p_data => x_msg_data
501: WHEN LOOP_FOUND_EXCEPTION
502: THEN
503: ROLLBACK to sp_wip_wol_grp;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_LOOP_FOUND');
506: FND_MSG_PUB.Add;
507: FND_MSG_PUB.Count_AND_Get
508: ( p_count => x_msg_count,
509: p_data => x_msg_data
512: WHEN INSERT_FAIL_EXCEPTION
513: THEN
514: ROLLBACK to sp_wip_wol_grp;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INSERT_FAIL');
517: FND_MSG_PUB.Add;
518: FND_MSG_PUB.Count_AND_Get
519: ( p_count => x_msg_count,
520: p_data => x_msg_data
756:
757: WHEN DEP_REL_EXIST_EXCEPTION THEN
758: ROLLBACK to sp_wip_wol_grp;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_CHILD_DEP_REL_EXIST');
761: FND_MSG_PUB.Add;
762: FND_MSG_PUB.Count_AND_Get
763: ( p_count => x_msg_count,
764: p_data => x_msg_data
766:
767: WHEN NO_SUCH_RELID_EXCEPTION THEN
768: ROLLBACK to sp_wip_wol_grp;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_NO_SUCH_REL_ID');
771: FND_MSG_PUB.Add;
772: FND_MSG_PUB.Count_AND_Get
773: ( p_count => x_msg_count,
774: p_data => x_msg_data
777: WHEN DELETE_FAIL_EXCEPTION
778: THEN
779: ROLLBACK to sp_wip_wol_grp;
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_DELETE_FAIL');
782: FND_MSG_PUB.Add;
783: FND_MSG_PUB.Count_AND_Get
784: ( p_count => x_msg_count,
785: p_data => x_msg_data