APPS.IEU_UWQM_ITEMS_PKG dependencies on FND_API

Line 34: x_return_status := fnd_api.g_ret_sts_success;

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

Line 99: x_return_status := fnd_api.g_ret_sts_error;

95:
96: exception
97: when others then
98: --dbms_output.put_line('err while inserting : '||sqlcode||' - '||sqlerrm);
99: x_return_status := fnd_api.g_ret_sts_error;
100: x_msg_data := sqlerrm;
101: end;
102:
103: end INSERT_ROW;

Line 132: x_return_status := fnd_api.g_ret_sts_success;

128: ) is
129:
130: begin
131:
132: x_return_status := fnd_api.g_ret_sts_success;
133:
134: UPDATE IEU_UWQM_ITEMS
135: SET
136: CREATED_BY = P_USER_ID,

Line 161: x_return_status := fnd_api.g_ret_sts_error;

157: WHERE WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE
158: AND WORKITEM_PK_ID = P_WORKITEM_PK_ID;
159:
160: if (sql%notfound) then
161: x_return_status := fnd_api.g_ret_sts_error;
162: x_msg_data := 'Work Item does not exist in UWQ Metaphor table';
163: end if;
164:
165: exception

Line 167: x_return_status := fnd_api.g_ret_sts_error;

163: end if;
164:
165: exception
166: when others then
167: x_return_status := fnd_api.g_ret_sts_error;
168: x_msg_data := sqlerrm;
169:
170: end UPDATE_ROW;
171:

Line 203: x_return_status := fnd_api.g_ret_sts_success;

199: l_status_id NUMBER := 0;
200:
201: begin
202:
203: x_return_status := fnd_api.g_ret_sts_success;
204:
205: IEU_UWQM_ITEMS_PKG.UPDATE_ROW
206: ( p_WORKITEM_OBJ_CODE,
207: p_workitem_pk_id,

Line 272: x_return_status := fnd_api.g_ret_sts_success;

268: ) IS
269:
270: begin
271:
272: x_return_status := fnd_api.g_ret_sts_success;
273:
274: delete from IEU_UWQM_ITEMS
275: where WORK_ITEM_ID = P_WORK_ITEM_ID
276: and WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE

Line 280: x_return_status := fnd_api.g_ret_sts_error;

276: and WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE
277: and WORKITEM_PK_ID = P_WORKITEM_PK_ID;
278:
279: if (sql%notfound) then
280: x_return_status := fnd_api.g_ret_sts_error;
281: x_msg_data := sqlcode||' '||sqlerrm;
282: end if;
283:
284: end DELETE_ROW;

Line 298: x_return_status := fnd_api.g_ret_sts_success;

294: ) IS
295:
296: begin
297:
298: x_return_status := fnd_api.g_ret_sts_success;
299:
300: IF ( p_work_item_id is not null)
301: THEN
302: UPDATE IEU_UWQM_ITEMS

Line 318: x_return_status := fnd_api.g_ret_sts_error;

314: AND WORKITEM_PK_ID = P_WORKITEM_PK_ID;
315: END IF;
316:
317: if (sql%notfound) then
318: x_return_status := fnd_api.g_ret_sts_error;
319: end if;
320:
321: end UPDATE_STATUS_FLAG;
322: end IEU_UWQM_ITEMS_PKG;