APPS.IGW_STUDY_TITLES_TBH dependencies on FND_API

Line 15: x_return_status := FND_API.G_RET_STS_SUCCESS;

11: ) is
12: cursor C is select ROWID from IGW_STUDY_TITLES
13: where STUDY_TITLE_ID = X_STUDY_TITLE_ID;
14: begin
15: x_return_status := FND_API.G_RET_STS_SUCCESS;
16: insert into IGW_STUDY_TITLES (
17: STUDY_TITLE_ID,
18: STUDY_TITLE,
19: ENROLLMENT_STATUS,

Line 44: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

40: EXCEPTION
41: WHEN OTHERS THEN
42: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_STUDY_TITLES_TBH'
43: ,p_procedure_name => 'INSERT_ROW' );
44: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
45: RAISE;
46:
47: end INSERT_ROW;
48:

Line 72: x_return_status := FND_API.G_RET_STS_SUCCESS;

68: WHERE study_title_id = x_study_title_id;
69:
70: begin
71:
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: IF l_row_id IS NULL THEN
75: OPEN get_row_id;
76: FETCH get_row_id INTO l_row_id;

Line 93: x_return_status := FND_API.G_RET_STS_ERROR;

89:
90: if (sql%notfound) then
91: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
92: FND_MSG_PUB.Add;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: end if;
95:
96: EXCEPTION
97: WHEN OTHERS THEN

Line 100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

96: EXCEPTION
97: WHEN OTHERS THEN
98: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_STUDY_TITLES_TBH'
99: ,p_procedure_name => 'UPDATE_ROW' );
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: RAISE;
102:
103: end UPDATE_ROW;
104:

Line 124: x_return_status := FND_API.G_RET_STS_SUCCESS;

120: WHERE study_title_id = x_study_title_id;
121:
122: begin
123:
124: x_return_status := FND_API.G_RET_STS_SUCCESS;
125:
126: IF l_row_id IS NULL THEN
127: OPEN get_row_id;
128: FETCH get_row_id INTO l_row_id;

Line 144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

140: EXCEPTION
141: WHEN OTHERS THEN
142: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_STUDY_TITLES_TBH'
143: ,p_procedure_name => 'DELETE_ROW' );
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
145: RAISE;
146: end DELETE_ROW;
147:
148: end IGW_STUDY_TITLES_TBH;