APPS.IGW_SUBJECT_INFORMATION_PVT dependencies on IGW_SUBJECT_INFORMATION

Line 1: PACKAGE BODY IGW_SUBJECT_INFORMATION_PVT AS

1: PACKAGE BODY IGW_SUBJECT_INFORMATION_PVT AS
2: --$Header: igwvsuib.pls 115.5 2002/11/15 00:50:28 ashkumar ship $
3:
4:
5: PROCEDURE CREATE_SUBJECT_INFORMATION

Line 37: IGW_SUBJECT_INFORMATION_TBH.INSERT_ROW (

33: fnd_msg_pub.initialize;
34: end if;
35:
36:
37: IGW_SUBJECT_INFORMATION_TBH.INSERT_ROW (
38: X_ROWID => x_rowid,
39: X_STUDY_TITLE_ID => p_study_title_id,
40: X_SUBJECT_TYPE_CODE => p_subject_type_code,
41: X_SUBJECT_RACE_CODE => p_subject_race_code,

Line 90: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',

86: if p_commit = fnd_api.g_true then
87: rollback to create_subject_information;
88: end if;
89: x_return_status := fnd_api.g_ret_sts_unexp_error;
90: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',
91: p_procedure_name => 'CREATE_SUBJECT_INFORMATION');
92:
93: Fnd_Msg_Pub.Count_And_Get
94: ( p_count => x_msg_count,

Line 155: IGW_SUBJECT_INFORMATION_TBH.UPDATE_ROW (

151: End if;
152: RAISE FND_API.G_EXC_ERROR;
153: End if;
154:
155: IGW_SUBJECT_INFORMATION_TBH.UPDATE_ROW (
156: X_ROWID => p_rowid,
157: X_STUDY_TITLE_ID => p_study_title_id,
158: X_SUBJECT_TYPE_CODE => p_subject_type_code,
159: X_SUBJECT_RACE_CODE => p_subject_race_code,

Line 215: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',

211: IF p_commit = FND_API.G_TRUE THEN
212: ROLLBACK TO update_study_title;
213: END IF;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',
216: p_procedure_name => 'UPDATE_SUBJECT_INFORMATION');
217: Fnd_Msg_Pub.Count_And_Get
218: ( p_count => x_msg_count,
219: p_data => x_msg_data);

Line 272: IGW_SUBJECT_INFORMATION_TBH.DELETE_ROW(

268: End if;
269:
270: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
271:
272: IGW_SUBJECT_INFORMATION_TBH.DELETE_ROW(
273: x_rowid => x_rowid,
274: x_record_version_number => p_record_version_number,
275: x_return_status => x_return_status);
276:

Line 326: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',

322: IF p_commit = FND_API.G_TRUE THEN
323: ROLLBACK TO update_study_title;
324: END IF;
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',
327: p_procedure_name => 'DELETE_SUBJECT_INFORMATION');
328: Fnd_Msg_Pub.Count_And_Get
329: ( p_count => x_msg_count,
330: p_data => x_msg_data);

Line 343: from igw_subject_information

339: l_dummy integer;
340: BEGIN
341: select 1
342: into l_dummy
343: from igw_subject_information
344: where rowid = x_rowid
345: and record_version_number = p_record_version_number;
346:
347: EXCEPTION

Line 356: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',

352: raise fnd_api.g_exc_error;
353:
354: WHEN OTHERS THEN
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SUBJECT_INFORMATION_PVT',
357: p_procedure_name => 'CHECK_LOCK');
358: raise fnd_api.g_exc_unexpected_error;
359:
360:

Line 363: END IGW_SUBJECT_INFORMATION_PVT;

359:
360:
361: END CHECK_LOCK;
362:
363: END IGW_SUBJECT_INFORMATION_PVT;