APPS.IGW_PROP_PERSONS_TBH dependencies on FND_API

Line 42: x_return_status := Fnd_Api.G_Ret_Sts_Success;

38: person_party_id = p_person_party_id;
39:
40: BEGIN
41:
42: x_return_status := Fnd_Api.G_Ret_Sts_Success;
43:
44: IF p_mode = 'I' THEN
45:
46: l_last_updated_by := 1;

Line 116: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

112: EXCEPTION
113:
114: WHEN others THEN
115:
116: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
117:
118: Fnd_Msg_Pub.Add_Exc_Msg
119: (
120: p_pkg_name => G_PKG_NAME,

Line 124: RAISE Fnd_Api.G_Exc_Unexpected_Error;

120: p_pkg_name => G_PKG_NAME,
121: p_procedure_name => l_api_name
122: );
123:
124: RAISE Fnd_Api.G_Exc_Unexpected_Error;
125:
126: END Insert_Row;
127:
128: ---------------------------------------------------------------------------

Line 155: x_return_status := Fnd_Api.G_Ret_Sts_Success;

151: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
152:
153: BEGIN
154:
155: x_return_status := Fnd_Api.G_Ret_Sts_Success;
156:
157: IF p_mode = 'I' THEN
158:
159: l_last_updated_by := 1;

Line 199: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

195: EXCEPTION
196:
197: WHEN others THEN
198:
199: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
200:
201: Fnd_Msg_Pub.Add_Exc_Msg
202: (
203: p_pkg_name => G_PKG_NAME,

Line 207: RAISE Fnd_Api.G_Exc_Unexpected_Error;

203: p_pkg_name => G_PKG_NAME,
204: p_procedure_name => l_api_name
205: );
206:
207: RAISE Fnd_Api.G_Exc_Unexpected_Error;
208:
209: END Update_Row;
210:
211: ---------------------------------------------------------------------------

Line 224: x_return_status := Fnd_Api.G_Ret_Sts_Success;

220: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
221:
222: BEGIN
223:
224: x_return_status := Fnd_Api.G_Ret_Sts_Success;
225:
226: DELETE igw_prop_persons
227: WHERE rowid = p_rowid
228: AND record_version_number = p_record_version_number;

Line 242: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

238: EXCEPTION
239:
240: WHEN others THEN
241:
242: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
243:
244: Fnd_Msg_Pub.Add_Exc_Msg
245: (
246: p_pkg_name => G_PKG_NAME,

Line 250: RAISE Fnd_Api.G_Exc_Unexpected_Error;

246: p_pkg_name => G_PKG_NAME,
247: p_procedure_name => l_api_name
248: );
249:
250: RAISE Fnd_Api.G_Exc_Unexpected_Error;
251:
252: END Delete_Row;
253:
254: ---------------------------------------------------------------------------