APPS.WIP_RESOURCE_VALIDATIONS dependencies on FND_API

Line 416: IF(l_return_status <> fnd_api. g_ret_sts_success) THEN

412: p_org_id => p_organization_id,
413: p_op_seq_num => p_operation_seq_num,
414: x_return_status => l_return_status);
415:
416: IF(l_return_status <> fnd_api. g_ret_sts_success) THEN
417: l_warning_exists := true;
418: -- If we are unable to cancel all PO/requisition associated to this
419: -- job, we will try to cancel as much as we can, then user need to
420: -- manually cancel the rest.

Line 1382: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1378: AND operation_seq_num = p_operation_seq_num
1379: AND resource_seq_num = p_parent_seq_num;
1380: exception
1381: when no_data_found then
1382: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1383: end;
1384: end if;
1385: end;
1386: UPDATE WIP_JOB_DTLS_INTERFACE

Line 2944: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then

2940: set schedule_seq_num = sched_seq
2941: where current of sched_rows;
2942: end if;
2943:
2944: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then
2945:
2946: update wip_job_dtls_interface
2947: set replacement_group_num = fnd_api.g_miss_num
2948: where current of sched_rows;

Line 2947: set replacement_group_num = fnd_api.g_miss_num

2943:
2944: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then
2945:
2946: update wip_job_dtls_interface
2947: set replacement_group_num = fnd_api.g_miss_num
2948: where current of sched_rows;
2949: elsif (sched_row.substitute_group_num is not null) then
2950:
2951: l_res_sub := 0;

Line 3101: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then

3097: set schedule_seq_num = sched_seq
3098: where current of sched_rows;
3099: end if;
3100:
3101: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then
3102: -- not allowed to erase the sub/repl group of an existing alt res
3103: update wip_job_dtls_interface
3104: set substitute_group_num = sub_group,
3105: replacement_group_num = repl_group

Line 3154: if (l_status = fnd_api.g_ret_sts_error) then

3150: l_error_msg VARCHAR2(2000);
3151: BEGIN
3152: wip_op_resources_utilities.validate_sub_groups(p_wip_entity_id, null, l_status, l_error_msg, l_op_seq);
3153:
3154: if (l_status = fnd_api.g_ret_sts_error) then
3155: for l_inv_row in c_invalid_rows(l_op_seq) loop
3156: if(wip_job_details.std_alone = 1) then
3157: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
3158: p_text => substr(l_error_msg,1,500),