APPS.IGW_PROP_CHECKLIST_PVT dependencies on FND_API

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

2: /* $Header: igwvpchb.pls 115.7 2002/11/14 18:52:13 vmedikon ship $*/
3:
4:
5: Procedure update_prop_checklist (
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_checklist (
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_document_type_code IN VARCHAR2,

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

4:
5: Procedure update_prop_checklist (
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_document_type_code IN VARCHAR2,
12: p_checklist_order IN NUMBER,

Line 31: IF p_commit = FND_API.G_TRUE THEN

27: n NUMBER;
28:
29: BEGIN
30: -- create savepoint if p_commit is true
31: IF p_commit = FND_API.G_TRUE THEN
32: SAVEPOINT update_prop_checklist;
33: END IF;
34:
35: -- initialize message list if p_init_msg_list is true

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

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

Line 41: x_return_status := fnd_api.g_ret_sts_success;

37: fnd_msg_pub.initialize;
38: end if;
39:
40: -- initialize return_status to success
41: x_return_status := fnd_api.g_ret_sts_success;
42:
43: -- and also check locking.
44: CHECK_LOCK
45: (x_rowid => x_rowid

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

71: end if;
72:
73: check_errors;
74:
75: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
76: igw_prop_checklist_tbh.update_row (
77: x_rowid => x_rowid
78: ,P_PROPOSAL_ID => P_PROPOSAL_ID
79: ,P_DOCUMENT_TYPE_CODE => P_DOCUMENT_TYPE_CODE

Line 92: if fnd_api.to_boolean(p_commit) then

88:
89: check_errors;
90:
91: -- standard check of p_commit
92: if fnd_api.to_boolean(p_commit) then
93: commit work;
94: end if;
95:
96:

Line 103: WHEN FND_API.G_EXC_ERROR THEN

99: p_data => x_msg_data);
100:
101:
102: EXCEPTION
103: WHEN FND_API.G_EXC_ERROR THEN
104: IF p_commit = FND_API.G_TRUE THEN
105: ROLLBACK TO update_prop_checklist;
106: END IF;
107:

Line 104: IF p_commit = FND_API.G_TRUE THEN

100:
101:
102: EXCEPTION
103: WHEN FND_API.G_EXC_ERROR THEN
104: IF p_commit = FND_API.G_TRUE THEN
105: ROLLBACK TO update_prop_checklist;
106: END IF;
107:
108: x_return_status := FND_API.G_RET_STS_ERROR;

Line 108: x_return_status := FND_API.G_RET_STS_ERROR;

104: IF p_commit = FND_API.G_TRUE THEN
105: ROLLBACK TO update_prop_checklist;
106: END IF;
107:
108: x_return_status := FND_API.G_RET_STS_ERROR;
109:
110: fnd_msg_pub.count_and_get(p_count => x_msg_count,
111: p_data => x_msg_data);
112:

Line 115: IF p_commit = FND_API.G_TRUE THEN

111: p_data => x_msg_data);
112:
113:
114: WHEN OTHERS THEN
115: IF p_commit = FND_API.G_TRUE THEN
116: ROLLBACK TO update_prop_checklist;
117: END IF;
118:
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

115: IF p_commit = FND_API.G_TRUE THEN
116: ROLLBACK TO update_prop_checklist;
117: END IF;
118:
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120:
121: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_CHECKLIST_PVT',
122: p_procedure_name => 'UPDATE_PROP_CHECKLIST',
123: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 147: x_return_status := FND_API.G_RET_STS_ERROR;

143: and record_version_number = p_record_version_number;
144:
145: EXCEPTION
146: WHEN NO_DATA_FOUND THEN
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
149: FND_MSG_PUB.Add;
150: raise fnd_api.g_exc_error;
151:

Line 150: raise fnd_api.g_exc_error;

146: WHEN NO_DATA_FOUND THEN
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
149: FND_MSG_PUB.Add;
150: raise fnd_api.g_exc_error;
151:
152: WHEN OTHERS THEN
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_CHECKLIST_PVT',

Line 153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

149: FND_MSG_PUB.Add;
150: raise fnd_api.g_exc_error;
151:
152: WHEN OTHERS THEN
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_CHECKLIST_PVT',
155: p_procedure_name => 'CHECK_LOCK',
156: p_error_text => SUBSTRB(SQLERRM,1,240));
157: raise fnd_api.g_exc_unexpected_error;

Line 157: raise fnd_api.g_exc_unexpected_error;

153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_CHECKLIST_PVT',
155: p_procedure_name => 'CHECK_LOCK',
156: p_error_text => SUBSTRB(SQLERRM,1,240));
157: raise fnd_api.g_exc_unexpected_error;
158:
159: END CHECK_LOCK;
160:
161: -------------------------------------------------------------------------------------------------------

Line 167: RAISE FND_API.G_EXC_ERROR;

163: l_msg_count NUMBER;
164: BEGIN
165: l_msg_count := fnd_msg_pub.count_msg;
166: IF (l_msg_count > 0) THEN
167: RAISE FND_API.G_EXC_ERROR;
168: END IF;
169:
170: END CHECK_ERRORS;
171: -----------------------------------------------------------------------------------------------------

Line 218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

214:
215: EXCEPTION
216: WHEN OTHERS THEN
217:
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219:
220: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_CHECKLIST_PVT',
221: p_procedure_name => 'POPULATE_CHECKLIST',
222: p_error_text => SUBSTRB(SQLERRM,1,240));