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 1350: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1346: AND operation_seq_num = p_operation_seq_num
1347: AND resource_seq_num = p_parent_seq_num;
1348: exception
1349: when no_data_found then
1350: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1351: end;
1352: end if;
1353: end;
1354: UPDATE WIP_JOB_DTLS_INTERFACE

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

2870: set schedule_seq_num = sched_seq
2871: where current of sched_rows;
2872: end if;
2873:
2874: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then
2875: update wip_job_dtls_interface
2876: set replacement_group_num = fnd_api.g_miss_num
2877: where current of sched_rows;
2878: elsif (sched_row.substitute_group_num is not null) then

Line 2876: set replacement_group_num = fnd_api.g_miss_num

2872: end if;
2873:
2874: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then
2875: update wip_job_dtls_interface
2876: set replacement_group_num = fnd_api.g_miss_num
2877: where current of sched_rows;
2878: elsif (sched_row.substitute_group_num is not null) then
2879: l_res_sub := 0;
2880:

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

3024: set schedule_seq_num = sched_seq
3025: where current of sched_rows;
3026: end if;
3027:
3028: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then
3029: -- not allowed to erase the sub/repl group of an existing alt res
3030: update wip_job_dtls_interface
3031: set substitute_group_num = sub_group,
3032: replacement_group_num = repl_group

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

3077: l_error_msg VARCHAR2(2000);
3078: BEGIN
3079: wip_op_resources_utilities.validate_sub_groups(p_wip_entity_id, null, l_status, l_error_msg, l_op_seq);
3080:
3081: if (l_status = fnd_api.g_ret_sts_error) then
3082: for l_inv_row in c_invalid_rows(l_op_seq) loop
3083: if(wip_job_details.std_alone = 1) then
3084: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
3085: p_text => substr(l_error_msg,1,500),