APPS.IGW_PROP_LOCATIONS_TBH dependencies on FND_API

Line 20: x_return_status := FND_API.G_RET_STS_SUCCESS;

16: X_LAST_UPDATE_DATE DATE;
17: X_LAST_UPDATED_BY NUMBER;
18: X_LAST_UPDATE_LOGIN NUMBER;
19: begin
20: x_return_status := FND_API.G_RET_STS_SUCCESS;
21:
22: X_LAST_UPDATE_DATE := SYSDATE;
23: if(X_MODE = 'I') then
24: X_LAST_UPDATED_BY := 1;

Line 75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

71: EXCEPTION
72: WHEN OTHERS THEN
73: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_LOCATIONS_TBH'
74: ,p_procedure_name => 'INSERT_ROW' );
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
76: RAISE;
77: end INSERT_ROW;
78: -----------------------------------------------------------------------------
79:

Line 102: x_return_status := FND_API.G_RET_STS_SUCCESS;

98: WHERE proposal_id = x_proposal_id
99: AND (PERFORMING_ORGANIZATION_ID = X_PERFORMING_ORGANIZATION_ID or PARTY_ID = X_PARTY_ID);
100: begin
101:
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103:
104: IF l_row_id IS NULL THEN
105: OPEN get_row_id;
106: FETCH get_row_id INTO l_row_id;

Line 148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

144: EXCEPTION
145: WHEN OTHERS THEN
146: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_LOCATIONS_TBH'
147: ,p_procedure_name => 'UPDATE_ROW' );
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
149: RAISE;
150: end UPDATE_ROW;
151:
152: -----------------------------------------------------------------------------

Line 173: x_return_status := FND_API.G_RET_STS_SUCCESS;

169: AND (PERFORMING_ORGANIZATION_ID = X_PERFORMING_ORGANIZATION_ID or PARTY_ID = X_PARTY_ID);
170:
171: begin
172:
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175: IF l_row_id IS NULL THEN
176: OPEN get_row_id;
177: FETCH get_row_id INTO l_row_id;

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

192: EXCEPTION
193: WHEN OTHERS THEN
194: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_LOCATIONS_TBH'
195: ,p_procedure_name => 'DELETE_ROW' );
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: RAISE;
198: end DELETE_ROW;
199:
200: end IGW_PROP_LOCATIONS_TBH;