eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGW_PROP_PERSON_DEGREES_PVT dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2: /* $Header: igwvppdb.pls 115.4 2002/11/15 00:41:41 ashkumar ship $*/
3:
4:
5: Procedure update_prop_person_degrees (
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
9: x_rowid IN VARCHAR2,
10: P_PROPOSAL_ID IN NUMBER,

Line 7: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3:
4:
5: Procedure update_prop_person_degrees (
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
9: x_rowid IN VARCHAR2,
10: P_PROPOSAL_ID IN NUMBER,
11: P_PERSON_DEGREE_ID IN NUMBER,

Line 8: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,

4:
5: Procedure update_prop_person_degrees (
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
9: x_rowid IN VARCHAR2,
10: P_PROPOSAL_ID IN NUMBER,
11: P_PERSON_DEGREE_ID IN NUMBER,
12: P_SHOW_FLAG IN VARCHAR2,

Line 29: IF p_commit = FND_API.G_TRUE THEN

25: l_msg_index_out NUMBER;
26:
27: BEGIN
28: -- create savepoint if p_commit is true
29: IF p_commit = FND_API.G_TRUE THEN
30: SAVEPOINT update_prop_person_degrees;
31: END IF;
32:
33: -- initialize message list if p_init_msg_list is true

Line 34: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

30: SAVEPOINT update_prop_person_degrees;
31: END IF;
32:
33: -- initialize message list if p_init_msg_list is true
34: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
35: fnd_msg_pub.initialize;
36: end if;
37:
38: -- initialize return_status to success

Line 39: x_return_status := fnd_api.g_ret_sts_success;

35: fnd_msg_pub.initialize;
36: end if;
37:
38: -- initialize return_status to success
39: x_return_status := fnd_api.g_ret_sts_success;
40:
41: /*
42: -- first validate user rights
43:

Line 63: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then

59: ------------------------------------- value_id conversion ---------------------------------
60:
61: -------------------------------------------- validations -----------------------------------------------------
62:
63: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
64: igw_prop_person_degrees_tbh.update_row (
65: x_rowid => x_rowid
66: ,P_PROPOSAL_ID => P_PROPOSAL_ID
67: ,P_PERSON_DEGREE_ID => P_PERSON_DEGREE_ID

Line 79: if fnd_api.to_boolean(p_commit) then

75:
76: check_errors;
77:
78: -- standard check of p_commit
79: if fnd_api.to_boolean(p_commit) then
80: commit work;
81: end if;
82:
83:

Line 90: WHEN FND_API.G_EXC_ERROR THEN

86: p_data => x_msg_data);
87:
88:
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: IF p_commit = FND_API.G_TRUE THEN
92: ROLLBACK TO update_prop_person_degrees;
93: END IF;
94:

Line 91: IF p_commit = FND_API.G_TRUE THEN

87:
88:
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: IF p_commit = FND_API.G_TRUE THEN
92: ROLLBACK TO update_prop_person_degrees;
93: END IF;
94:
95: x_return_status := FND_API.G_RET_STS_ERROR;

Line 95: x_return_status := FND_API.G_RET_STS_ERROR;

91: IF p_commit = FND_API.G_TRUE THEN
92: ROLLBACK TO update_prop_person_degrees;
93: END IF;
94:
95: x_return_status := FND_API.G_RET_STS_ERROR;
96:
97: fnd_msg_pub.count_and_get(p_count => x_msg_count,
98: p_data => x_msg_data);
99:

Line 102: IF p_commit = FND_API.G_TRUE THEN

98: p_data => x_msg_data);
99:
100:
101: WHEN OTHERS THEN
102: IF p_commit = FND_API.G_TRUE THEN
103: ROLLBACK TO update_prop_person_degrees;
104: END IF;
105:
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

102: IF p_commit = FND_API.G_TRUE THEN
103: ROLLBACK TO update_prop_person_degrees;
104: END IF;
105:
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107:
108: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_DEGREES_PVT',
109: p_procedure_name => 'UPDATE_PROP_PERSON_DEGREES',
110: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 134: x_return_status := FND_API.G_RET_STS_ERROR;

130: and record_version_number = p_record_version_number;
131:
132: EXCEPTION
133: WHEN NO_DATA_FOUND THEN
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: -- FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
136: FND_MESSAGE.SET_NAME('IGW','IGW_DIFFERENT_MESSAGE');
137: FND_MSG_PUB.Add;
138: raise fnd_api.g_exc_error;

Line 138: raise fnd_api.g_exc_error;

134: x_return_status := FND_API.G_RET_STS_ERROR;
135: -- FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
136: FND_MESSAGE.SET_NAME('IGW','IGW_DIFFERENT_MESSAGE');
137: FND_MSG_PUB.Add;
138: raise fnd_api.g_exc_error;
139:
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_DEGREES_PVT',

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

137: FND_MSG_PUB.Add;
138: raise fnd_api.g_exc_error;
139:
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_DEGREES_PVT',
143: p_procedure_name => 'CHECK_LOCK',
144: p_error_text => SUBSTRB(SQLERRM,1,240));
145: raise fnd_api.g_exc_unexpected_error;

Line 145: raise fnd_api.g_exc_unexpected_error;

141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_DEGREES_PVT',
143: p_procedure_name => 'CHECK_LOCK',
144: p_error_text => SUBSTRB(SQLERRM,1,240));
145: raise fnd_api.g_exc_unexpected_error;
146:
147: END CHECK_LOCK;
148:
149: -------------------------------------------------------------------------------------------------------

Line 155: RAISE FND_API.G_EXC_ERROR;

151: l_msg_count NUMBER;
152: BEGIN
153: l_msg_count := fnd_msg_pub.count_msg;
154: IF (l_msg_count > 0) THEN
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;
157:
158: END CHECK_ERRORS;
159:

Line 170: x_return_status:= FND_API.G_RET_STS_SUCCESS;

166: x VARCHAR2(1);
167: y VARCHAR2(1);
168:
169: BEGIN
170: x_return_status:= FND_API.G_RET_STS_SUCCESS;
171:
172: IF (IGW_SECURITY.ALLOW_MODIFY ('NARRATIVE', P_PROPOSAL_ID, FND_GLOBAL.USER_ID) = 'N') THEN
173: x_return_status:= FND_API.G_RET_STS_ERROR;
174: fnd_message.set_name('IGW', 'IGW_NO_RIGHTS');

Line 173: x_return_status:= FND_API.G_RET_STS_ERROR;

169: BEGIN
170: x_return_status:= FND_API.G_RET_STS_SUCCESS;
171:
172: IF (IGW_SECURITY.ALLOW_MODIFY ('NARRATIVE', P_PROPOSAL_ID, FND_GLOBAL.USER_ID) = 'N') THEN
173: x_return_status:= FND_API.G_RET_STS_ERROR;
174: fnd_message.set_name('IGW', 'IGW_NO_RIGHTS');
175: fnd_msg_pub.add;
176: END IF;
177:

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177:
178: EXCEPTION
179:
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
183: p_procedure_name => 'VALIDATE_LOGGED_USER_RIGHTS',
184: p_error_text => SUBSTRB(SQLERRM,1,240));
185: raise fnd_api.g_exc_unexpected_error;

Line 185: raise fnd_api.g_exc_unexpected_error;

181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
183: p_procedure_name => 'VALIDATE_LOGGED_USER_RIGHTS',
184: p_error_text => SUBSTRB(SQLERRM,1,240));
185: raise fnd_api.g_exc_unexpected_error;
186: END VALIDATE_LOGGED_USER_RIGHTS;
187: */
188:
189: -------------------------------------------------------------------------------------------------------------------

Line 194: PROCEDURE POPULATE_BIO_TABLES (p_init_msg_list in varchar2 := FND_API.G_FALSE,

190: -- the following code transfers the degrees pertaining to the appropriate proposal and person from the
191: -- igw_person_degrees table to the igw_prop_person_degrees table and from igw_person_biosketch table to
192: -- the igw_prop_person_biosketch_table
193:
194: PROCEDURE POPULATE_BIO_TABLES (p_init_msg_list in varchar2 := FND_API.G_FALSE,
195: p_commit in varchar2 := FND_API.G_FALSE,
196: p_validate_only in varchar2 := FND_API.G_FALSE,
197: p_proposal_id in number,
198: p_party_id in number,

Line 195: p_commit in varchar2 := FND_API.G_FALSE,

191: -- igw_person_degrees table to the igw_prop_person_degrees table and from igw_person_biosketch table to
192: -- the igw_prop_person_biosketch_table
193:
194: PROCEDURE POPULATE_BIO_TABLES (p_init_msg_list in varchar2 := FND_API.G_FALSE,
195: p_commit in varchar2 := FND_API.G_FALSE,
196: p_validate_only in varchar2 := FND_API.G_FALSE,
197: p_proposal_id in number,
198: p_party_id in number,
199: x_return_status out NOCOPY varchar2,

Line 196: p_validate_only in varchar2 := FND_API.G_FALSE,

192: -- the igw_prop_person_biosketch_table
193:
194: PROCEDURE POPULATE_BIO_TABLES (p_init_msg_list in varchar2 := FND_API.G_FALSE,
195: p_commit in varchar2 := FND_API.G_FALSE,
196: p_validate_only in varchar2 := FND_API.G_FALSE,
197: p_proposal_id in number,
198: p_party_id in number,
199: x_return_status out NOCOPY varchar2,
200: x_msg_count out NOCOPY number,

Line 239: IF p_commit = FND_API.G_TRUE THEN

235:
236: BEGIN
237:
238: -- create savepoint if p_commit is true
239: IF p_commit = FND_API.G_TRUE THEN
240: SAVEPOINT populate_bio_tables;
241: END IF;
242:
243: -- initialize message list if p_init_msg_list is set to true

Line 244: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

240: SAVEPOINT populate_bio_tables;
241: END IF;
242:
243: -- initialize message list if p_init_msg_list is set to true
244: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
245: fnd_msg_pub.initialize;
246: end if;
247:
248: -- initialize return status to success

Line 249: x_return_status := fnd_api.g_ret_sts_success;

245: fnd_msg_pub.initialize;
246: end if;
247:
248: -- initialize return status to success
249: x_return_status := fnd_api.g_ret_sts_success;
250:
251:
252: -- delete those degrees in igw_prop_person_degrees which are not in igw_person_degrees
253: -- for the proposal under consideration

Line 364: if fnd_api.to_boolean(p_commit) then

360: end loop;
361: close d;
362:
363: -- standard check of p_commit
364: if fnd_api.to_boolean(p_commit) then
365: commit work;
366: end if;
367:
368:

Line 376: IF p_commit = FND_API.G_TRUE THEN

372:
373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: IF p_commit = FND_API.G_TRUE THEN
377: ROLLBACK TO populate_bio_tables;
378: END IF;
379:
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

376: IF p_commit = FND_API.G_TRUE THEN
377: ROLLBACK TO populate_bio_tables;
378: END IF;
379:
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381:
382: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_DEGREES_PVT',
383: p_procedure_name => 'POPULATE_BIO_TABLES',
384: p_error_text => SUBSTRB(SQLERRM,1,240));