DBA Data[Home] [Help]

APPS.IGW_PROP_PERSON_BIOSKETCH_PVT dependencies on FND_MSG_PUB

Line 35: fnd_msg_pub.initialize;

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
39: x_return_status := fnd_api.g_ret_sts_success;

Line 85: fnd_msg_pub.count_and_get(p_count => x_msg_count,

81: end if;
82:
83:
84: -- standard call to get message count and if count is 1, get message info
85: fnd_msg_pub.count_and_get(p_count => x_msg_count,
86: p_data => x_msg_data);
87:
88:
89: EXCEPTION

Line 97: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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:
100:
101: WHEN OTHERS THEN

Line 108: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_BIOSKETCH_PVT',

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_BIOSKETCH_PVT',
109: p_procedure_name => 'UPDATE_PROP_PERSON_BIOSKETCH',
110: p_error_text => SUBSTRB(SQLERRM,1,240));
111:
112: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 112: fnd_msg_pub.count_and_get(p_count => x_msg_count,

108: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_BIOSKETCH_PVT',
109: p_procedure_name => 'UPDATE_PROP_PERSON_BIOSKETCH',
110: p_error_text => SUBSTRB(SQLERRM,1,240));
111:
112: fnd_msg_pub.count_and_get(p_count => x_msg_count,
113: p_data => x_msg_data);
114:
115:
116: END update_prop_person_biosketch;

Line 136: FND_MSG_PUB.Add;

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_MSG_PUB.Add;
137: raise fnd_api.g_exc_error;
138:
139: WHEN OTHERS THEN
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 141: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_BIOSKETCH_PVT',

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

Line 152: l_msg_count := fnd_msg_pub.count_msg;

148: -------------------------------------------------------------------------------------------------------
149: PROCEDURE CHECK_ERRORS is
150: l_msg_count NUMBER;
151: BEGIN
152: l_msg_count := fnd_msg_pub.count_msg;
153: IF (l_msg_count > 0) THEN
154: RAISE FND_API.G_EXC_ERROR;
155: END IF;
156:

Line 174: fnd_msg_pub.add;

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

Line 181: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

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