APPS.FTE_SEL_GROUPS_PKG dependencies on WSH_UTIL_CORE

Line 603: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

599: --
600:
601:
602:
603: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
604:
605:
606: --
607: -- Get the new group id

Line 617: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

613: END IF;
614:
615: IF ((l_new_group_id <= 0) OR
616: (l_new_group_id is null)) THEN
617: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
618: RETURN;
619: END IF;
620:
621: l_t_new_group_id := to_char(l_new_group_id);

Line 665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

661:
662: EXCEPTION
663: WHEN OTHERS THEN
664: ROLLBACK TO insert_fte_sel_groups;
665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
666: RETURN;
667: END;
668:
669:

Line 1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1133:
1134: CLOSE c_get_result_assignments;
1135: END LOOP;
1136:
1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1138:
1139: RETURN;
1140:
1141: EXCEPTION

Line 1146: WSH_UTIL_CORE.Println('The unexpected error from FTE_SEL_GROUPS_PKG.COPY_GROUP is ' ||l_error_text);

1142: WHEN OTHERS THEN
1143: x_group_id := null;
1144: l_error_code := SQLCODE;
1145: l_error_text := SQLERRM;
1146: WSH_UTIL_CORE.Println('The unexpected error from FTE_SEL_GROUPS_PKG.COPY_GROUP is ' ||l_error_text);
1147: WSH_UTIL_CORE.default_handler('FTE_SEL_GROUPS_PKG.COPY_GROUP');
1148: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1149: RETURN;
1150:

Line 1147: WSH_UTIL_CORE.default_handler('FTE_SEL_GROUPS_PKG.COPY_GROUP');

1143: x_group_id := null;
1144: l_error_code := SQLCODE;
1145: l_error_text := SQLERRM;
1146: WSH_UTIL_CORE.Println('The unexpected error from FTE_SEL_GROUPS_PKG.COPY_GROUP is ' ||l_error_text);
1147: WSH_UTIL_CORE.default_handler('FTE_SEL_GROUPS_PKG.COPY_GROUP');
1148: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1149: RETURN;
1150:
1151: END COPY_GROUP;

Line 1148: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1144: l_error_code := SQLCODE;
1145: l_error_text := SQLERRM;
1146: WSH_UTIL_CORE.Println('The unexpected error from FTE_SEL_GROUPS_PKG.COPY_GROUP is ' ||l_error_text);
1147: WSH_UTIL_CORE.default_handler('FTE_SEL_GROUPS_PKG.COPY_GROUP');
1148: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1149: RETURN;
1150:
1151: END COPY_GROUP;
1152: