APPS.IEU_WR_ITEMS_PKG dependencies on FND_API

Line 36: x_return_status := fnd_api.g_ret_sts_success;

32:
33: begin
34:
35: begin
36: x_return_status := fnd_api.g_ret_sts_success;
37: INSERT INTO IEU_UWQM_ITEMS
38: ( WORK_ITEM_ID,
39: OBJECT_VERSION_NUMBER,
40: CREATED_BY,

Line 105: x_return_status := fnd_api.g_ret_sts_error;

101:
102: exception
103: when others then
104: --dbms_output.put_line('err while inserting : '||sqlcode||' - '||sqlerrm);
105: x_return_status := fnd_api.g_ret_sts_error;
106: x_msg_data := sqlerrm;
107: end;
108:
109: end INSERT_ROW;

Line 140: x_return_status := fnd_api.g_ret_sts_success;

136: ) is
137:
138: begin
139:
140: x_return_status := fnd_api.g_ret_sts_success;
141:
142: UPDATE IEU_UWQM_ITEMS
143: SET
144: CREATED_BY = P_USER_ID,

Line 171: x_return_status := fnd_api.g_ret_sts_error;

167: WHERE WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE
168: AND WORKITEM_PK_ID = P_WORKITEM_PK_ID;
169:
170: if (sql%notfound) then
171: x_return_status := fnd_api.g_ret_sts_error;
172: x_msg_data := 'Work Item does not exist in UWQ Metaphor table';
173: end if;
174:
175: exception

Line 177: x_return_status := fnd_api.g_ret_sts_error;

173: end if;
174:
175: exception
176: when others then
177: x_return_status := fnd_api.g_ret_sts_error;
178: x_msg_data := sqlerrm;
179:
180: end UPDATE_ROW;
181:

Line 216: x_return_status := fnd_api.g_ret_sts_success;

212: l_status_id NUMBER := 0;
213:
214: begin
215:
216: x_return_status := fnd_api.g_ret_sts_success;
217:
218: IEU_WR_ITEMS_PKG.UPDATE_ROW
219: ( p_WORKITEM_OBJ_CODE,
220: p_workitem_pk_id,

Line 291: x_return_status := fnd_api.g_ret_sts_success;

287: l_message VARCHAR2(4000);
288:
289: begin
290: l_message := '';
291: x_return_status := fnd_api.g_ret_sts_success;
292:
293: delete from IEU_UWQM_ITEMS
294: where WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE
295: and WORKITEM_PK_ID = P_WORKITEM_PK_ID;

Line 299: x_return_status := fnd_api.g_ret_sts_error;

295: and WORKITEM_PK_ID = P_WORKITEM_PK_ID;
296:
297: if (sql%notfound) then
298:
299: x_return_status := fnd_api.g_ret_sts_error;
300:
301: FND_MESSAGE.SET_NAME('IEU', 'IEU_WP_NO_FOUND');
302: l_message := FND_MESSAGE.GET;
303:

Line 304: RAISE fnd_api.g_exc_error;

300:
301: FND_MESSAGE.SET_NAME('IEU', 'IEU_WP_NO_FOUND');
302: l_message := FND_MESSAGE.GET;
303:
304: RAISE fnd_api.g_exc_error;
305: end if;
306:
307: EXCEPTION
308: WHEN fnd_api.g_exc_error THEN

Line 308: WHEN fnd_api.g_exc_error THEN

304: RAISE fnd_api.g_exc_error;
305: end if;
306:
307: EXCEPTION
308: WHEN fnd_api.g_exc_error THEN
309:
310: x_return_status := fnd_api.g_ret_sts_error;
311: x_msg_data := l_message;
312:

Line 310: x_return_status := fnd_api.g_ret_sts_error;

306:
307: EXCEPTION
308: WHEN fnd_api.g_exc_error THEN
309:
310: x_return_status := fnd_api.g_ret_sts_error;
311: x_msg_data := l_message;
312:
313: end DELETE_ROW;
314:

Line 327: x_return_status := fnd_api.g_ret_sts_success;

323: ) IS
324:
325: begin
326:
327: x_return_status := fnd_api.g_ret_sts_success;
328:
329: IF ( p_work_item_id is not null)
330: THEN
331: UPDATE IEU_UWQM_ITEMS

Line 347: x_return_status := fnd_api.g_ret_sts_error;

343: AND WORKITEM_PK_ID = P_WORKITEM_PK_ID;
344: END IF;
345:
346: if (sql%notfound) then
347: x_return_status := fnd_api.g_ret_sts_error;
348: end if;
349:
350: end UPDATE_STATUS_FLAG;
351: end IEU_WR_ITEMS_PKG;