APPS.WIP_SFCB_UTILITIES dependencies on FND_API

Line 752: --if (p_ret_status <> FND_API.G_RET_STS_SUCCESS) then

748: p_msg_count => l_msg_count,
749: p_msg_data => l_msg_data ) ;
750:
751: -- commit regardless of status..
752: --if (p_ret_status <> FND_API.G_RET_STS_SUCCESS) then
753: -- rollback;
754: --else
755:
756: -- this was to fix the bug#845918

Line 1981: ret VARCHAR2(4) := FND_API.G_TRUE;

1977: /* for validating the display date */
1978: function is_validate_displaydate(p_date IN VARCHAR2) return VARCHAR2
1979: IS
1980: t_date DATE;
1981: ret VARCHAR2(4) := FND_API.G_TRUE;
1982: BEGIN
1983: BEGIN
1984: select to_date(p_date, fnd_date.output_mask)
1985: into t_date

Line 1988: ret := FND_API.G_FALSE;

1984: select to_date(p_date, fnd_date.output_mask)
1985: into t_date
1986: from dual;
1987: EXCEPTION WHEN OTHERS THEN
1988: ret := FND_API.G_FALSE;
1989: END;
1990: return ret;
1991: END;
1992:

Line 1997: ret VARCHAR2(4) := FND_API.G_TRUE;

1993: /* for validating display datetime */
1994: function is_validate_displayDT(p_date IN VARCHAR2) return VARCHAR2
1995: IS
1996: t_date DATE;
1997: ret VARCHAR2(4) := FND_API.G_TRUE;
1998: BEGIN
1999: BEGIN
2000: select to_date(p_date, fnd_date.outputdt_mask)
2001: into t_date

Line 2004: ret := FND_API.G_FALSE;

2000: select to_date(p_date, fnd_date.outputdt_mask)
2001: into t_date
2002: from dual;
2003: EXCEPTION WHEN OTHERS THEN
2004: ret := FND_API.G_FALSE;
2005: END;
2006: return ret;
2007: END;
2008:

Line 2035: return FND_API.G_RET_STS_ERROR;

2031: select to_date(p_to_dt,fnd_date.outputdt_mask) - to_date(p_from_dt,fnd_date.outputdt_mask)
2032: into diff
2033: from dual;
2034: EXCEPTION WHEN OTHERS THEN
2035: return FND_API.G_RET_STS_ERROR;
2036: END;
2037: return to_char(diff * 24); -- return in hours
2038: END;
2039: