APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_UTILITIES

Line 2973: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number,

2969: return;
2970: END IF;
2971:
2972: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop
2973: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number,
2974: p_organization_id => l_serRec.organization_id,
2975: p_inventory_item_id => l_serRec.primary_item_id,
2976: p_wip_entity_id => p_wip_entity_id,
2977: p_operation_seq_num => null,

Line 2982: wip_utilities.get_message_stack(p_msg => x_err_msg);

2978: p_intraoperation_step_type => null,
2979: x_return_status => x_return_status);
2980: if(x_return_status <> fnd_api.g_ret_sts_success) then
2981: rollback to wipjdstb10;
2982: wip_utilities.get_message_stack(p_msg => x_err_msg);
2983: exit;
2984: end if;
2985: end loop;
2986: exception

Line 3034: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number_new,

3030: return;
3031: END IF;
3032:
3033: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop
3034: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number_new,
3035: p_organization_id => l_serRec.organization_id,
3036: p_inventory_item_id => l_serRec.primary_item_id,
3037: p_wip_entity_id => p_wip_entity_id,
3038: p_operation_seq_num => null,

Line 3043: wip_utilities.get_message_stack(p_msg => x_err_msg);

3039: p_intraoperation_step_type => null,
3040: x_return_status => x_return_status);
3041: if(x_return_status <> fnd_api.g_ret_sts_success) then
3042: rollback to wipjdstb20;
3043: wip_utilities.get_message_stack(p_msg => x_err_msg);
3044: exit;
3045: end if;
3046:
3047: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number_old,

Line 3047: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number_old,

3043: wip_utilities.get_message_stack(p_msg => x_err_msg);
3044: exit;
3045: end if;
3046:
3047: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number_old,
3048: p_organization_id => l_serRec.organization_id,
3049: p_inventory_item_id => l_serRec.primary_item_id,
3050: p_wip_entity_id => null,
3051: p_operation_seq_num => null,

Line 3055: wip_utilities.get_message_stack(p_msg => x_err_msg);

3051: p_operation_seq_num => null,
3052: p_intraoperation_step_type => null,
3053: x_return_status => x_return_status);
3054: if(x_return_status <> fnd_api.g_ret_sts_success) then
3055: wip_utilities.get_message_stack(p_msg => x_err_msg);
3056: exit;
3057: end if;
3058:
3059: end loop;

Line 3107: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number,

3103: return;
3104: END IF;
3105:
3106: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop
3107: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number,
3108: p_organization_id => l_serRec.organization_id,
3109: p_inventory_item_id => l_serRec.primary_item_id,
3110: p_wip_entity_id => null,
3111: p_operation_seq_num => null,

Line 3116: wip_utilities.get_message_stack(p_msg => x_err_msg);

3112: p_intraoperation_step_type => null,
3113: x_return_status => x_return_status);
3114: if(x_return_status <> fnd_api.g_ret_sts_success) then
3115: rollback to wipjdstb30;
3116: wip_utilities.get_message_stack(p_msg => x_err_msg);
3117: exit;
3118: end if;
3119: end loop;
3120: exception

Line 3177: wip_utilities.generate_serials(p_item_id => l_primary_item_id,

3173:
3174: --if the user did not provide enough serial numbers
3175: if(l_serialization_start_op is not null and
3176: l_start_quantity > l_rowCount) then
3177: wip_utilities.generate_serials(p_item_id => l_primary_item_id,
3178: p_org_id => p_organization_id,
3179: p_qty => to_number(l_start_quantity - l_rowCount),
3180: p_wip_entity_id => p_wip_entity_id,
3181: p_revision => null,