DBA Data[Home] [Help]

APPS.WIP_OPERATION_VALIDATE dependencies on FND_API

Line 101: x_return_status := FND_API.G_RET_STS_ERROR;

97:
98: Exception
99:
100: when others then
101: x_return_status := FND_API.G_RET_STS_ERROR;
102: x_err_msg := 'ERROR IN WIPOPVDB.ADD_OPERATION: ' || SQLERRM;
103: x_err_code := to_char(SQLCODE);
104: return;
105:

Line 164: x_return_status := FND_API.G_RET_STS_ERROR;

160:
161: Exception
162:
163: when others then
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: x_err_msg := 'ERROR IN WIPOPVDB.CHANGE_OPERATION: ' || SQLERRM;
166: x_err_code := to_char(SQLCODE);
167:
168: return;

Line 445: and standard_operation_id <> fnd_api.g_miss_num

441: and substitution_type = p_sub_type
442: and wip_entity_id = p_wip_entity_id
443: and organization_id = p_organization_id
444: and standard_operation_id is not null
445: and standard_operation_id <> fnd_api.g_miss_num
446: and not exists (select 1
447: from bom_standard_operations
448: where standard_operation_id = wjdi.standard_operation_id
449: and organization_id = wjdi.organization_id);

Line 481: and standard_operation_id <> fnd_api.g_miss_num

477: and substitution_type = p_sub_type
478: and wip_entity_id = p_wip_entity_id
479: and organization_id = p_organization_id
480: and standard_operation_id is not null
481: and standard_operation_id <> fnd_api.g_miss_num
482: and not exists (select 1
483: from bom_standard_operations
484: where standard_operation_id = wjdi.standard_operation_id
485: and organization_id = wjdi.organization_id);