APPS.IGW_PROP_SCIENCE_CODES_TBH dependencies on FND_API

Line 33: x_return_status := Fnd_Api.G_Ret_Sts_Success;

29: science_code = p_science_code;
30:
31: BEGIN
32:
33: x_return_status := Fnd_Api.G_Ret_Sts_Success;
34:
35: IF p_mode = 'I' THEN
36:
37: l_last_updated_by := 1;

Line 86: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

82: EXCEPTION
83:
84: WHEN others THEN
85:
86: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
87:
88: Fnd_Msg_Pub.Add_Exc_Msg
89: (
90: p_pkg_name => G_PKG_NAME,

Line 94: RAISE Fnd_Api.G_Exc_Unexpected_Error;

90: p_pkg_name => G_PKG_NAME,
91: p_procedure_name => l_api_name
92: );
93:
94: RAISE Fnd_Api.G_Exc_Unexpected_Error;
95:
96: END Insert_Row;
97:
98: ---------------------------------------------------------------------------

Line 118: x_return_status := Fnd_Api.G_Ret_Sts_Success;

114: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
115:
116: BEGIN
117:
118: x_return_status := Fnd_Api.G_Ret_Sts_Success;
119:
120: IF p_mode = 'I' THEN
121:
122: l_last_updated_by := 1;

Line 154: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

150: EXCEPTION
151:
152: WHEN others THEN
153:
154: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
155:
156: Fnd_Msg_Pub.Add_Exc_Msg
157: (
158: p_pkg_name => G_PKG_NAME,

Line 162: RAISE Fnd_Api.G_Exc_Unexpected_Error;

158: p_pkg_name => G_PKG_NAME,
159: p_procedure_name => l_api_name
160: );
161:
162: RAISE Fnd_Api.G_Exc_Unexpected_Error;
163:
164: END Update_Row;
165:
166: ---------------------------------------------------------------------------

Line 179: x_return_status := Fnd_Api.G_Ret_Sts_Success;

175: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
176:
177: BEGIN
178:
179: x_return_status := Fnd_Api.G_Ret_Sts_Success;
180:
181: DELETE igw_prop_science_codes
182: WHERE rowid = p_rowid
183: AND record_version_number = p_record_version_number;

Line 197: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

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

Line 205: RAISE Fnd_Api.G_Exc_Unexpected_Error;

201: p_pkg_name => G_PKG_NAME,
202: p_procedure_name => l_api_name
203: );
204:
205: RAISE Fnd_Api.G_Exc_Unexpected_Error;
206:
207: END Delete_Row;
208:
209: ---------------------------------------------------------------------------