DBA Data[Home] [Help]

APPS.WIP_OP_RESOURCES_UTILITIES dependencies on FND_API

Line 288: x_return_status := fnd_api.g_ret_sts_success;

284: Procedure delete_orphaned_alternates (p_wip_entity_id in number,
285: p_schedule_id in number,
286: x_return_status out nocopy varchar2) is
287: begin
288: x_return_status := fnd_api.g_ret_sts_success;
289:
290: delete from wip_sub_operation_resources wsor
291: where wip_entity_id = p_wip_entity_id
292: and nvl(repetitive_schedule_id, -1) = nvl(p_schedule_id, -1)

Line 301: x_return_status := fnd_api.g_ret_sts_unexp_error;

297: and wor.operation_seq_num = wsor.operation_seq_num
298: and wor.substitute_group_num = wsor.substitute_group_num);
299: exception
300: when others then
301: x_return_status := fnd_api.g_ret_sts_unexp_error;
302: end delete_orphaned_alternates;
303:
304: PROCEDURE Validate_Sub_Groups (p_wip_entity_id NUMBER,
305: p_schedule_id NUMBER,

Line 395: x_return_status := fnd_api.g_ret_sts_error;

391: end if;
392: end if;
393:
394: if (error_exists = true) then
395: x_return_status := fnd_api.g_ret_sts_error;
396: x_msg_data := fnd_message.get;
397: x_operation_seq_num := cur_op.operation_seq_num;
398: return;
399: end if;

Line 409: x_return_status := fnd_api.g_ret_sts_success;

405: last_parent_resource_seq := cur_opres.parent_resource_seq;
406: end loop;
407: end loop;
408:
409: x_return_status := fnd_api.g_ret_sts_success;
410: EXCEPTION
411: when others then
412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413: end validate_sub_groups;

Line 412: x_return_status := fnd_api.g_ret_sts_unexp_error;

408:
409: x_return_status := fnd_api.g_ret_sts_success;
410: EXCEPTION
411: when others then
412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413: end validate_sub_groups;
414:
415: Procedure Update_Resource_Instances(p_wip_entity_id NUMBER,
416: p_org_id NUMBER) is