APPS.IGW_PROP_COMMENTS_TBH dependencies on FND_API

Line 34: x_return_status := Fnd_Api.G_Ret_Sts_Success;

30: trunc(last_update_date) = trunc(SYSDATE);
31:
32: BEGIN
33:
34: x_return_status := Fnd_Api.G_Ret_Sts_Success;
35:
36: IF p_mode = 'I' THEN
37:
38: l_last_updated_by := 1;

Line 89: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

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

Line 97: RAISE Fnd_Api.G_Exc_Unexpected_Error;

93: p_pkg_name => G_PKG_NAME,
94: p_procedure_name => l_api_name
95: );
96:
97: RAISE Fnd_Api.G_Exc_Unexpected_Error;
98:
99: END Insert_Row;
100:
101: ---------------------------------------------------------------------------

Line 122: x_return_status := Fnd_Api.G_Ret_Sts_Success;

118: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
119:
120: BEGIN
121:
122: x_return_status := Fnd_Api.G_Ret_Sts_Success;
123:
124: IF p_mode = 'I' THEN
125:
126: l_last_updated_by := 1;

Line 159: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

155: EXCEPTION
156:
157: WHEN others THEN
158:
159: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
160:
161: Fnd_Msg_Pub.Add_Exc_Msg
162: (
163: p_pkg_name => G_PKG_NAME,

Line 167: RAISE Fnd_Api.G_Exc_Unexpected_Error;

163: p_pkg_name => G_PKG_NAME,
164: p_procedure_name => l_api_name
165: );
166:
167: RAISE Fnd_Api.G_Exc_Unexpected_Error;
168:
169: END Update_Row;
170:
171: ---------------------------------------------------------------------------

Line 184: x_return_status := Fnd_Api.G_Ret_Sts_Success;

180: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
181:
182: BEGIN
183:
184: x_return_status := Fnd_Api.G_Ret_Sts_Success;
185:
186: DELETE igw_prop_comments
187: WHERE rowid = p_rowid
188: AND record_version_number = p_record_version_number;

Line 202: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

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

Line 210: RAISE Fnd_Api.G_Exc_Unexpected_Error;

206: p_pkg_name => G_PKG_NAME,
207: p_procedure_name => l_api_name
208: );
209:
210: RAISE Fnd_Api.G_Exc_Unexpected_Error;
211:
212: END Delete_Row;
213:
214: ---------------------------------------------------------------------------